midrange.com -- midrange-l mailing list

Re: Change column name on DDL SQL table in iSeries Navigator

Raul A. Jager W. — 2013-05-22T08:53:48-05:00

Someone recently started an off-topic thread on the RPG400-l subject "change column name in sql?"; I gave some replies, one including some effective scripts [without the "CL:" designation for the non-SQL]: http://archive.midrange.com/rpg400-l/201305/threads.html#00120 Renaming a column is allowed and easily effected with the CREATE VIEW statement; optionally combined with RENAME TABLE or RENAME VIEW so as to have the VIEW object with the corrected names take place of the TABLE or VIEW which still has the u...

Re: include current date in logical file

Buck Calabro — 2013-05-22T08:42:15-05:00

I agree this is easy. Maybe too easy. Among my few regrets on this platform is the fact that I personally used STRSQL to do things like CREATE VIEW and GRANT. There's nothing wrong with STRSQL - it works great! The problem comes when I need to re-create the view for some reason. Could be a DR scenario and the view was locked and not on the tapes. Could be trying to create a new LPAR or a new test library. I personally use i Navigator scripts to do all of this work now. I keep them in the IFS, with names th...

Re: SQL procedure trace

Vernon Hamberg — 2013-05-22T08:10:26-05:00

Re: Change column name on DDL SQL table in iSeries Navigator

Vernon Hamberg — 2013-05-22T08:02:11-05:00

Re: Writable image catalog - usable as LODRUN?

Vernon Hamberg — 2013-05-22T07:53:19-05:00

Re: SQL procedure trace

Pete Helgren — 2013-05-22T07:48:19-05:00

Re: Housekeeping

rob — 2013-05-22T07:06:46-05:00

So, is the goal then to get IBM and the alternative vendors working on a VIOS solution? Or, is it to wait to see how IBM gets native support for IBM Storwize SAN products (V7000 & V3700) and see if this will allow native connections for third party SANs also? Rob Berendt

RE: Roll-back program questions

Koester, Michael — 2013-05-22T07:02:27-05:00

Thanks Alan. I have looked at that, but did not see anything that would specifically facilitate a roll-back. If it has that functionality, please help me find what I missed. -- Michael a the over the the screw it in Been at commands, commands aren't applications operating a being recovery CL rnmobj recoverable others, and long before could back back in source

RE: BRMS recovery

rob — 2013-05-22T07:01:22-05:00

Paul, I've lost some of the original train of thoughts as to why you were avoiding OMITs in BRMS. I think it has to do with your restore. On a related note, when we do our restricted full system save we specify OMITS(*IGNORE) On a daily basis we do have a lot of "this not saved" kind of stuff due to locks. Mainly the log files you noted. I have a lower priority item on my list to some day deal with this. I do have some directories in which I specify the whole directory as Can be saved . . . . . . . . . . . ...

Re: Migrate iTERA to PowerHA

rob — 2013-05-22T06:52:04-05:00

That was IBM "TRYING" to gouge me. I left them no doubt as to what they could do with that proposal. We've also since replaced the IBM SAN switch with a Cisco one. Obviously sticking with all IBM equipment doesn't get you any preferential treatment from IBM and the speeds on that switch were getting a little dated. Rob Berendt

Re: Change column name on DDL SQL table in iSeries Navigator

rob — 2013-05-22T06:42:34-05:00

<snip> ... or go to www.common.org and add a requirement there - You don't need to be a COMMON member, just get a user and passwordin the "Community" tab. </snip> and if the phase of the moon is just right and sun spots aren't flaring up and if the bluegills in the pond are circling counterclockwise the website just may work Rob Berendt

Re: Migrate iTERA to PowerHA

Jim Oberholtzer — 2013-05-22T06:41:46-05:00

external storage, we have the option of make a flash copy of the iASP before the upgrade and switch. If the switch and conversion fail and you have to "go back" to the previous release, we can vary off the iASP, reverse the flash copy, and then bring it back up on the older release partition. question is a bit different. conversions occurring due to an OS upgrade. #2. Do your switch and quickly upgrade the OS on #1. Now, if it all goes to heck on the new OS you could try switching back and hope that any da...

Re: Migrate iTERA to PowerHA

rob — 2013-05-22T06:32:45-05:00

Jim, I am hearing both sides of that argument, and the jury is still out. Yes, every time you mention SAN everyone thinks you have unlimited pockets and come running to you as if you're the new gold rush. IBM trying to gouge me an extra $10K for SAN support just to maintain an IBM tape drive attached to an IBM SAN switch to IBM i on Power, and they were already all under maintenance, is a classic example. However, the PC tech here is using Net App (and/or Cisco) SAN disk that is mirrored from one location t...

Re: SQL Delete from multiple files

rob — 2013-05-22T06:19:36-05:00

I understand work arounds, sometimes. However when I hear "I want to do ... but I don't want to use this totally free, fully supported, part of the OS that doesn't conflict with any of my business rules, how do I go about doing that?" I get a little baffled. Rob Berendt

RE: BRMS recovery

Steinmetz, Paul — 2013-05-21T22:56:04-05:00

I am skeptical of a no-wait lock, if the SWA is also skipping those objects but taking significantly longer than a non-SWA.... but I accept your conclusion, because I have too little knowledge or practical experience outside of database objects. But I do know about the implementation of the stream file, which is effectively the same as a database member and a dataspace; i.e. same object types but different subtypes, so many implementations are very similar between the database and the stream file. But AFaI...

Re: WebQry 1.1.2 Not Fully Starting

TheBorg — 2013-05-21T22:10:46-05:00

Re: Writable image catalog - usable as LODRUN?

Jim Oberholtzer — 2013-05-21T20:49:29-05:00

SQL procedure trace

Mike Cunningham — 2013-05-21T20:41:37-05:00

Is there a way to turn on a trace for a call to a DB2 stored procedure (all SQL - no RPG) coming from an external server running a perl app on a linux server connecting using the IBM iSeries ODBC driver.

Writable image catalog - usable as LODRUN?

Vernon Hamberg — 2013-05-21T20:16:53-05:00

Just got an installation CD from a vendor and asked our system guy to install the product. We do everything with image catalogs and apparently don't have an optical drive easy to use - I can't respond to any questions as to why that. So I believe we can create an image catalog, then an image catalog entry with FROMFILE(*NEW) and mount it on a virtual optical device. Now if we copy the contents of the CD to that image catalog - /QOPT/SOMECDID - either with FTP or a file share - is that virtual CD usable for ...

Re: Change column name on DDL SQL table in iSeries Navigator

Vernon Hamberg — 2013-05-21T19:55:03-05:00