1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 1999, week 4 2 80 35_Re: Unable to extend to next volume22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 22 Oct 1999 07:11:19 +0100548_ISO-8859-1 Ivon check the following in no particular order ;

- are ACS routines involved? - what volumes are being made available to this pageset? - what is the largest single extent space on one of these volumes for taking the next extent ?

you may wish to know that there are work arounds to problems with extents .. and in addition version 5 allows for 254 extents if my memory serves me right. The work around is that if you find yourself with a page set in a large number of extents (some bacth job came along and filled it [...] 83 27 16_How to use SQLDA9_baskarans17_baskarans@INF.COM31_Fri, 22 Oct 1999 13:08:01 +0530356_windows-1252 Hi List users

I have to use SQLDA for a varying select query in Dynamic SQL in a VSCOBOL2 + DB2 + CICS program, when I gave an INCLUDE stmt, the precompilation failed giving illegal symbol SQLDA,when I hardcoded the SQLDA structure, the variables were not getting populated, could anybody mail me back on how to include the SQLDA. [...] 111 114 17_Re: Jan 1st posts13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Fri, 22 Oct 1999 09:08:00 +0100340_iso-8859-1 List I agree with Mark and, like Anne, we two DB2 DBAs at AN have volunteered and have split the cover 50/50.

We took one look at the recompense on offer and couldn't look the proverbial gift horse etc.etc..

If it all goes pear shaped the DBAs will, I believe, have mainly a testing/coordinating role to play. [...] 226 81 17_Re: Jan 1st posts13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 22 Oct 1999 09:49:47 +0100549_iso-8859-1 What does "torked" mean?



> -----Original Message----- > From: Mark Labby [mailto:mlabby@PHEAA.ORG] > Sent: 21 October 1999 20:19 > To: DB2-L@RYCI.COM > Subject: Jan 1st posts > > > Our organization was just conducting an internal survey of > how we feel we will > make out with the year 2000 turn over. Overall, our comfort > level is very high > - we've upgraded and tested everything that could be a > problem. One thing that > seems to have slipped the minds of a lot of us here in the US > and Canada is that > we [...] 308 154 17_Re: Jan 1st posts0_18_mebert@AMADEUS.NET31_Fri, 22 Oct 1999 10:58:01 +0100431_us-ascii Didn't Mr. Clinton sign a law saying that american companies CANNOT be sued for Y2K problems occurring during the first 3 months of 2000 or so?

I belong to the "what-me-worry" group. My colleague got the lucky draw, he will be on-site during the Y2K night (meaning he has to camp out at his desk) and get a big compensation. I just will be on-call and get a much smaller compensation (but still nice to have). [...] 463 47 25_Comand DB2 - OPTIMIZE FOR19_Pedro Correia (DSI)27_TE00102@MUNDIALCONFIANCA.PT31_Fri, 22 Oct 1999 10:37:59 +0200529_- Hi All

I have a program with this:

EXEC SQL DECLARE FETCH_TMCPG CURSOR FOR SELECT NUM_PAGAMENTO ; NUM_REC_QUITACAO ; TIPO_PAGAMENTO ; VALOR_DEB_ESC ; VALOR_DEB_EURO ; VALOR_CRE_ESC ; VALOR_CRE_EURO ; NUMERARIO_ENT_ESC ; NUMERARIO_ENT_EURO ; CHEQUE_ENT_ESC ; CHEQUE_ENT_EURO ; NUM_CONTA_AGENTE ; TRANSF_BANC_ESC ;TRANSF_BANC_EURO FROM TMCPG WHERE (TIMESTAMP_UPDATED > : W800-CONTROL-ENTRA AND TIMESTAMP_UPDATED < : W800-CONTROL-SAIDA AND NUM_CTA_DEPENDENCIA = : M-TMCPG-NUM-CTA-DEPENDEN AND SITUACAO <> 'CN') [...] 511 21 33_How to decide the length of SQLDA20_Baskaran Subramaniam27_subramaniam.baskaran@DB.COM31_Fri, 22 Oct 1999 16:31:46 +0530288_us-ascii Hi List users

When I use SQLDA, I am getting an SQL Error -804 with reason code 7 (which indicates an invalid SQLDA length), I tried values 13216 & 33016 for SQLDABC and am getting the same error. Could anybody mail me the criteria to decide the length of the SQLDA. [...] 533 71 27_Re: EMC TimeFinder question11_Ron Haupert23_rhaupert@GOLDENGATE.NET31_Fri, 22 Oct 1999 06:41:43 -0500632_iso-8859-1 EMC TimeFinder can be integrated into DB2 environments in several ways. There are two primary functions associated with TimeFinder, - Volumes SPLIT functionality and SNAP functionality. Volume SPLIT provides volume mirrors or copies of volumes while SPLIT provides copies of data sets. The TABLESPACE or DATABASE should be quiesced using a START R/O and Quiesce WRITE YES ( to flush buffers) when the volumes are SPLIT or data sets are SNAPped. These procedures tend to take seconds. The application can be made available immediately after the SPLIT or SNAP is performed. The copy process is NOT part of the overall [...] 605 157 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!10_Ven Ilagan18_vilagan@ONE.NET.AU31_Fri, 22 Oct 1999 09:00:45 +1000511_us-ascii Hi Tim & Max,

It's not only with SHRLEVEL REFERENCE but also with SHRLEVEL CHANGE that SYSCOPY is essential - I've got an online reorg happening early in the morning subsequently followed by an image copy by the afternoon and really do NOT want any inline copy to happen during my reorg. The way I've gotten around this forced inline-copy is to have my copyddn have DSN=......TEMPWORK,DISP=(,DELETE),UNIT=SYSDA so that immediately after the job ends, the dataset is simply deleted in DASD. [...] 763 72 29_Re: Comand DB2 - OPTIMIZE FOR10_Ven Ilagan18_vilagan@ONE.NET.AU31_Fri, 22 Oct 1999 09:21:16 +1000546_us-ascii Seems like you're probably doing List Prefetches - next time you ask about something like this, it'll help to give stats or explain outputs.

What's probably happening is the Timestamp_Updated index is not clustered and you're going all over the place in fetching the data - The OPtimize for n rows probably wouldn't help you, unless you really are fetching only very few "n" rows. The FOR FETCH ONLY only kicks in lock avoidance and somehow, I don't think your performance degradation could be the result of excessive locks. [...] 836 34 56_running DB2 Web Control Center applet without web server12_Adam, Daniel15_dadam@GRATEX.SK31_Fri, 22 Oct 1999 14:27:34 +0200384_- Hi,

DB2 UDB on NT ( WR9074 )

Trying to run Web Control Center java aplet ( or any other DB2 java applet ) localy on my machine, having no web server installed. Manuals say it is possible, but I always get error in Java Console window :

com.ms.security.SecurityExceptionEx[com/ibm/db2/navigator/admin/AdminConnect ion.create]: cannot access "localhost" ... [...] 871 28 16_Term util error.16_Fernando Estevez24_festevez@BANCORIO.COM.AR31_Fri, 22 Oct 1999 09:39:27 -0300348_iso-8859-1 Hi all:

We are running on DB2 V5. I execute a term utility command but it ended error. The reason code is REASON=X'00E40030', and now I can't run the same type of utility (online reorg) on the same tablespace; I can run distinct type of utility (runstats, copy, .......). Somebody know a way to eliminate this utility??????? [...] 900 123 17_Re: Jan 1st posts0_24_lightsey@ITS.STATE.MS.US31_Fri, 22 Oct 1999 07:56:43 -0500588_us-ascii Torqued !

How about "all bent out of shape" or "thouroughly PO'd" ?

As for the Jan 1 thing, we've been told to be available from 29 Dec through 10 Jan ( don't ask to take off and you don't have permission to get sick or die ! ). Even though our testing - simulations and IPLing a box , FEP, and various routers and gateways to various dates/times in the oh-so-near future and running the various apps through the normal daily/weekly/monthly/annual cycles - has revealed only 1 unanticipated problem, the politicos have decided to have us on full availability. [...] 1024 30 46_Re: Running UDB 6.1 Control Center under Linux12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 22 Oct 1999 07:55:33 -0500319_us-ascii Steve:

I am having the same problem with Windows 98. The DB2CC starts the java and then terminates. I have followed the instructions, but see no diagnostics. This is suppose to run off of the JRE installed with the product? I have removed the other Java install from the system without any effect. [...] 1055 50 20_Re: Term util error.11_Stout, Anne23_Anne.Stout@DOWJONES.COM31_Fri, 22 Oct 1999 09:17:40 -0400695_iso-8859-1 Fernando,

There sould be additional messages and/or a dump which should give us additional information as to what the problem is...

Anne Stout

-----Original Message----- From: Fernando Estevez [mailto:festevez@BANCORIO.COM.AR] Sent: Friday, October 22, 1999 8:39 AM To: DB2-L@RYCI.COM Subject: Term util error.



Hi all:

We are running on DB2 V5. I execute a term utility command but it ended error. The reason code is REASON=X'00E40030', and now I can't run the same type of utility (online reorg) on the same tablespace; I can run distinct type of utility (runstats, copy, .......). Somebody know a way to eliminate this utility??????? [...] 1106 236 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!0_18_mebert@AMADEUS.NET31_Fri, 22 Oct 1999 15:20:26 +0100548_us-ascii I'm sorry but I still cannot see the point of this discussion. Why would you want to do a Reorg but not an imagecopy? The strategy outlined below seems to me to have the following "features" (a Microsoft term): - you do not save any space (you need it first for the ..TEMPWORK dataset, later for the real imagecopy) - you use additional CPU & elapsed time (for doing the second IC) - you clutter up SYSCOPY with unneeded FIC/Quiesce entries - if something happens to your data between the OLR and the IC, you can only recover to just [...] 1343 46 37_Re: How to decide the length of SQLDA13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Fri, 22 Oct 1999 08:20:35 -0500389_iso-8859-1 I do not know the answer to your question ... but we had a hard-to-solve -804 after a program change. It was related to over writing memory and working storage used by DB2.

We stepped through the program, looking at the parameter list variables (plist ) DB2 uses, and somewhere all of the data was replaced by zeros. All subsequent calls to DB2 failed with an -804. [...] 1390 41 20_DB2 Datamigrate Tool0_20_evans036@MC.DUKE.EDU31_Fri, 22 Oct 1999 09:40:08 -0400494_us-ascii i have written a data migration tool in rexx that relies heavily on the REXX RLX product from Relational Architects. It's purpose is to copy referentially intact data.

The general idea is to provide the program with (usually one) table with a where clause for the source & a target subsystem/table qualifier to determine the destination. Referential constraints are interrogated in order to deduce other tables & row subsets that need to be part of the migration strategy. [...] 1432 41 29_Re: replication + data joiner0_15_leon@CA.IBM.COM31_Thu, 21 Oct 1999 20:09:24 +0200703_us-ascii It is possible but you will not like the performance if you need to move large volumes of data.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



David Ayers on 10/18/99 10:19:48 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: replication + data joiner







We are looking at replicating data from DB2 v5.1 OS/390 to DB2 v5.1 OS/390 using data joiner. We have the DPROP/R CAPTURE (MVS) running. Do we need the Apply for MVS if we have data joiner (e.g. target tables of DB2 v5.1 OS/390 defined in data joiner as nicknames). I [...] 1474 32 21_Data sharing question0_23_Mike_Levine@TEKHELP.NET31_Fri, 22 Oct 1999 09:59:19 -0400499_us-ascii Hi,

I was testing data sharing and ran into the following probem which may be 'working as designed'. I was trying to load tables from two different data sharing members on different LPARs against the same database. All jobs (except one) on both system were waiting for database U locks. I was able to run unloads this way but the loads could not run. Why are multiple load jobs able to run currently on the same member but not on different members? Is this working as designed? [...] 1507 53 13_Re: DDF again0_15_leon@CA.IBM.COM31_Thu, 21 Oct 1999 21:03:23 +0200459_us-ascii Every time you: - install a new version or release of DB2 Connect or - apply a new DB2 Connect FixPack or - install DB2 Connect on a new operating system you (the DBA) need to bind all of the utilities that come with DB2 Connect. Once you bind them everybody else will be able to use them and do not need to bind themselves. If you are using DB2 Connect on Windows, I suggest you use DB2 Client Configuration Assistant (DB2 CCA) to do the bind. [...] 1561 162 17_Re: Jan 1st posts10_Mark Labby16_mlabby@PHEAA.ORG31_Fri, 22 Oct 1999 10:02:44 -0400410_us-ascii LOL - Yes, I meant to say torqued instead of torked.

I did run spell check and the word I originally used passed through. But, at the last moment, I thought that word may be a tad more graphic than I needed it to be and changed it...

At 2-3 a.m. on January 1st, I think all of our language will revert back to our most basic and favorite phrases if there are major problems. [...] 1724 48 33_Data sharing question - more info0_23_Mike_Levine@TEKHELP.NET31_Fri, 22 Oct 1999 10:28:48 -0400658_us-ascii Hi,

The jobs were also waiting for an X lock on resource UTSERIAL, TYPE=UTSE.

Regards, Michael Levine Premier Data Services, Inc.





>To: DB2 Data Base Discussion List >From: Mike_Levine@tekhelp.net >Subject: Data sharing question > >Hi, > >I was testing data sharing and ran into the following probem which >may be 'working as designed'. I was trying to load tables from two >different data sharing members on different LPARs against the same >database. All jobs (except one) on both system were waiting for >database U locks. I was able to run unloads this way but the loads >could not run. [...] 1773 21 25_Planning for Data Sharing17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Fri, 22 Oct 1999 09:29:49 -0500337_koi8-r I would appreciate any guidance on the topic of planning for data sharing. If you know of any resources I should access - urls, publications, etc. I would appreciate knowing about them.

Also, for those of you who have implemented data sharing, I would appreciate any general or specific advice you have time to share. [...] 1795 45 29_Re: Planning for Data Sharing0_20_John_Lendman@FPL.COM31_Fri, 22 Oct 1999 10:31:41 -0400515_us-ascii There are some good REDBOOKS on IBM web site. John







Gerald Bustamente on 10/22/99 10:29:49 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Planning for Data Sharing







I would appreciate any guidance on the topic of planning for data sharing. If you know of any resources I should access - urls, publications, etc. I would appreciate knowing about them. [...] 1841 47 29_Re: Planning for Data Sharing22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 22 Oct 1999 15:44:04 +0100434_ISO-8859-1 We have just done this .. and can help where required ...

bit busy at t he mo .. but give me a nudge next week and we can have a chat about it.

Leslie Pendlebury-Bowe DB2 OS390 SAP





______________________________ Reply Separator _________________________________ Subject: Planning for Data Sharing Author: Gerald Bustamente at Internet Date: 10/22/99 9:29 AM [...] 1889 51 60_FW: running DB2 Web Control Center applet without web server12_Adam, Daniel15_dadam@GRATEX.SK31_Fri, 22 Oct 1999 16:46:52 +0200621_- With following versions it works : Netscape Navigator 4.04 for Windows 95 or Windows NT JDK 1.1.4 patch for Navigator 4.04 As described here http://www-4.ibm.com/software/data/db2/udb/webcc/browsers.html

Sorry for disturbing Daniel



> -----Original Message----- > From: Adam, Daniel > Sent: Friday, October 22, 1999 2:28 PM > To: Db2-L (E-mail); Db2eug (E-mail) > Subject: running DB2 Web Control Center applet without web server > > Hi, > > DB2 UDB on NT ( WR9074 ) > > Trying to run Web Control Center java aplet ( or any other DB2 java applet > ) localy on my machine, having no web server [...] 1941 94 26_Re: DB2 Connect to the Web0_15_leon@CA.IBM.COM31_Fri, 22 Oct 1999 16:03:04 +0200488_us-ascii Michael, you do not deploy CAE on the web. The whole point of the web enablement is not to deploy any software out on the client except the web browser (Netscape, MS Internet Explorer etc.).

We have lots of successful deployments of DB2 Connect with web applications. Many of these are very large line of business applications. If you want to see one in action go to http://www.walmart.com/. Every transaction on this site goes through DB2 Connect to DB2 for OS/390. [...] 2036 73 37_Re: Data sharing question - more info11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 22 Oct 1999 07:49:39 PDT491_- I converted our DB2 systems to data-sharing this year, and I have run loads of separate partitions of the same tablespace at the same time on different members of the data-sharing group with no contention and no problems. One important issue: what version of DB2 and what maintenance do you have on? IBM frequently comes out with data-sharing fixes and some of them involve locking contention issues. We are at DB2 version 5.1 9810 with all HIPERS applied up to the end of MAY, 1999. [...] 2110 66 29_Re: Planning for Data Sharing13_Adrian Savory34_Adrian.Savory@CCMAIL.EU.SONY.CO.JP31_Fri, 22 Oct 1999 16:03:12 +0100536_ISO-8859-1 The Data Sharing Planning and Admin Guide is a good place to start.

Adrian Savory ACSIS Ltd





______________________________ Reply Separator _________________________________ Subject: Re: Planning for Data Sharing Author: Leslie Pendlebury-Bowe at Internet Date: 10/22/99 3:44 PM



We have just done this .. and can help where required ...

bit busy at t he mo .. but give me a nudge next week and we can have a chat about it. [...] 2177 21 19_Logging out of sync13_Craig Anthony17_craig@CAC.PSU.EDU31_Fri, 22 Oct 1999 11:06:27 -0400513_US-ASCII We are running DB2 5.2 Enterprise edition on AIX 4.3.2. LOGERETAIN is set to ON. LOGPRIMARY is set to 5 and LOGSECONDARY is set to 2. What has happened is that First Active Log File and Next Active Log file have gotten out of sync. When the 5th primary log filled new logs were created and the first log of the new batch is actived but the last file of the batch is marked as the next active file. In essence I loose the use of three log files. Also when the new log files are created the old files [...] 2199 87 37_Re: Data sharing question - more info0_23_Mike_Levine@TEKHELP.NET31_Fri, 22 Oct 1999 11:13:29 -0400622_us-ascii Hi,

We are at DB2 V5 9901.





>I converted our DB2 systems to data-sharing this year, and I have run loads >of separate partitions of the same tablespace at the same time on different >members of the data-sharing group with no contention and no problems. >One important issue: what version of DB2 and what maintenance do you have >on? IBM frequently comes out with data-sharing fixes and some of them >involve locking contention issues. We are at DB2 version 5.1 9810 with all >HIPERS applied up to the end of MAY, 1999. > >Rick > > >>From: Mike_Levine@TEKHELP.NET >>Reply-To: DB2 [...] 2287 111 37_Re: Data sharing question - more info11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 22 Oct 1999 08:53:25 PDT594_- At a minimum I would say you need to put on the HIPER ptfs up to the end of August 1999, because there are several data-sharing fixes in there. UQ32868 sounds similar to your problem.

Rick



>From: Mike_Levine@TEKHELP.NET >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Data sharing question - more info >Date: Fri, 22 Oct 1999 11:13:29 -0400 > >Hi, > >We are at DB2 V5 9901. > > > > >I converted our DB2 systems to data-sharing this year, and I have run >loads > >of separate partitions of the same tablespace at the same [...] 2399 25 24_Re: DB2 Datamigrate Tool13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 22 Oct 1999 12:00:09 -0400460_iso-8859-1 >note that if you dont have REXX/RLX from RA, >it could be very difficult retrofit. Steve, Sounds pretty cool I just wanted to comment on your observation that it may be difficult to retro-fit if one didn't have RLX.

In the session on Rexx Support for DB2 on OS/390 at the DB2 tech conference in New Orleans last month, Jim Ruddy stated that Rexx Stored Procedures support is designed to work with most of the current Rexx/DB2 products. [...] 2425 211 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Oct 1999 11:13:12 -0500558_us-ascii Ven, I hope that you are ensuring that there are no updates between your reorg and your next "real" image copy since you could not recover to current until then, and the copy pending flag would not be set. (because you could not use your logs to forward recover until you have a good image copy.) And, since you are going through the overhead of building the image copy anyway, why don't you keep it? Since IBM appears to be recommending that we do our image copies to DASD rather than tape (see DB2 V6 enhancements regarding parallel copy and [...] 2637 99 20_Re: Term util error.0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Oct 1999 11:22:32 -0500372_us-ascii Fernando, Are you talking to IBM about the -term util command failure?

Since the Term util command failed, was the utility id deleted? If the utility id was deleted, could there still be a lock on the tablespace? Did you do a -display database? If this was just a test subsystem, I might use -start database....access(force) (use with extreme care!!) [...] 2737 193 17_Re: Jan 1st posts14_O'Conner, John26_john.oconner@COURTS.WA.GOV31_Fri, 22 Oct 1999 09:18:25 -0700410_iso-8859-1 We've been to the future and back on our Y2K LPAR and had no surprises (except for the lack of problems). My wife found a t-shirt that stated my sentiment very well -- Y2K Complacent.

John O'Conner John.OConner@courts.wa.gov

-----Original Message----- From: Mark Labby [mailto:mlabby@PHEAA.ORG] Sent: Friday, October 22, 1999 7:03 AM To: DB2-L@RYCI.COM Subject: Re: Jan 1st posts [...] 2931 70 21_DB2 stored procedures16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Fri, 22 Oct 1999 09:29:39 -0700616_- Any comments would be appreciated.

> -----Original Message----- > From: Bruce Baxter [SMTP:Bruce_Baxter@TAX.STATE.NY.US] > Sent: Friday, October 22, 1999 6:04 AM > To: CICS-L@LISTSERV.UGA.EDU > Subject: Re: DB2 stored procedures > > Our experiences with stored procedures here have not been that good. The > DB2 stored procedure address space has crashed many times since the > implementation of a large app the beginning of this year. I don't know > the > specifics of why, but it seems that DB2's environment for the stored > procedures is nowhere near as robust as is CICS. For that reason, there > [...] 3002 304 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Oct 1999 12:02:01 -0500563_us-ascii Michael, Regarding the reasons for not requiring an image copy during a sharelevel reference reorg: Most people that I have talked to still take their image copies directly to tape, and they stack many datasets on a tape in order to better utilize the tape drives. If you image copy to disk, then it makes HUGE sense to take the image copy during the reorg. (be patient, I will get there) If you image copy to tape, and stack multiple datasets on a tape, then you have LABEL= parms in your JCL which complicates restart. (And, isn't your tape drive [...] 3307 118 18_Peculiar Behavior?17_Price, Jeff (EDS)14_jprice@NCL.COM31_Fri, 22 Oct 1999 13:49:52 -0400501_ISO-8859-1 DB2 for OS/390 V5.1 putlevel 99/06: I have a simple two-table join query, executed from an SQR program that is used to update PeopleSoft Tools tables. The actual program is over a year old and was working perfectly, until today, when its access path took a change for the worse. Investigation, showed that Runstats was missing on one of the indexes used. Once runstats was run on the index the access path corrected itself. B U T H E R E I S T H E R E A L Q U E S T I O N: The explain [...] 3426 19 24_Re: DB2 Datamigrate Tool9_Ray Lopez19_raylopez@US.IBM.COM31_Fri, 22 Oct 1999 11:32:06 -0600304_us-ascii Can you tell me more about this Data Migrate tool you've developed? I have a database of about 300 tables. Some are linked via DB2 RI, others are linked via application code (RI triggers). Would this tool help me unload an RI intact subset of the production data to use as a test database? [...] 3446 26 14_COOL:Gen - MVS15_Michael Bancale21_mbancale@TXFB-INS.COM31_Fri, 22 Oct 1999 13:02:20 -0500352_iso-8859-1 I'm back with another COOL:Gen question. There is an option of building RPROF tables which appears to be how Sterling/TI avoided using Comm Area in CICS Programs to store the keys when scrolling forward and backwards and restarting. The option is to use these RPROF tables or to use Temp Storage. Does anyone have experience with this? [...] 3473 50 29_Re: Planning for Data Sharing11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 22 Oct 1999 11:16:45 PDT357_- A good list of hints and tips is at: http://www-4.ibm.com/software/data/db2/os390/dshints.html

I would emphasize: 1. Get educated on data-sharing. 2. At least be at DB2 version 5 with data-sharing ptfs applied. 3. Of course, your OS/390 system must be a SYSPLEX. 4. Get very familiar with coupling facility issues: sizing, ICF vs. standalone. [...] 3524 52 20_Re: Term util error.13_Chuck Hinchey22_chinchey@RJCONSULT.COM31_Fri, 22 Oct 1999 13:16:12 -0500329_iso-8859-1 There is a known bug in DB2 v5 with term util. It sometimes fails and leaves the utilid on the system, thus preventing further utility processing. There is also a patch that appears to correct this issue. I don't know the numbers, but you should be able to search for it on line or your IBM rep should know them. [...] 3577 59 29_Re: Planning for Data Sharing17_Gerald Bustamente20_ggbusta@LANDSEND.COM31_Fri, 22 Oct 1999 13:21:29 -0500645_koi8-r Thanks alot Rick. I will take your advice.

Jerry

rick creech wrote:

> A good list of hints and tips is at: > http://www-4.ibm.com/software/data/db2/os390/dshints.html > > I would emphasize: > 1. Get educated on data-sharing. > 2. At least be at DB2 version 5 with data-sharing ptfs applied. > 3. Of course, your OS/390 system must be a SYSPLEX. > 4. Get very familiar with coupling facility issues: sizing, ICF vs. > standalone. > > Rick > > >From: Gerald Bustamente > >Reply-To: DB2 Data Base Discussion List > >To: DB2-L@RYCI.COM > >Subject: Planning for Data Sharing > [...] 3637 70 21_Re: Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Fri, 22 Oct 1999 14:35:54 -0400541_us-ascii I don't see any TABLE LOCK statement any where....

rolchua@SES.COM.SG on 10/21/99 07:33:15 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Row level locking







Hi Nash,

Check SYSIBM.SYSSTMT for possible "LOCK TABLE" sql statement in your program. Eg. Select TEXT from SYSIBM.SYSSTMT where NAME = dbrmname.













Nash Gupta on 22/10/99 00:41:54 [...] 3708 16 27_ZPARM - Idle Thread Storage13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Fri, 22 Oct 1999 11:23:14 -0700374_- Does anyone know what the parm name is on the ZPARM which allows you specify the amount of storage for IDLE THREAD's. ? Thanks Dan

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 3725 70 27_Re: Stored procedure abends12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Fri, 22 Oct 1999 15:00:26 -0400328_iso-8859-1 Thanks for the help. I did find the zparm parameter (stormxab) which you can set from 0 to 255 to indicate the number of abends before the stored procedure is stopped. I have set it at 25 in the test environment and the programmers are quite happy with it. I will keep it at zero in production at least for now. [...] 3796 125 27_Re: Stored procedure abends12_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Fri, 22 Oct 1999 15:02:30 -0400265_iso-8859-1 Thanks for the help. I did find a zparm parameter (stormxab) which you can set from 0 to 255 to indicate how many abends you can have before a stored procedure is put out of service. I have it set to 25 in test and the programmers seem to be happy. [...] 3922 61 31_Re: ZPARM - Idle Thread Storage0_33_Patrick.McManus@MUTUALOFOMAHA.COM31_Fri, 22 Oct 1999 14:06:53 -0500594_us-ascii I don't know that you can specify the amount of storage for an idle thread. Is it parm "IDTHTOIN" that lets you specify the amount of time before an idle thread is cancelled what you are looking for? Below is a brief description of the parm "IDTHTOIN".

Specify the approximate time, in seconds, that an active server thread is allowed to remain idle before it is canceled. The thread is canceled after the timeout value expires, releasing its locks and cursors. Inactive and indoubt threads are not subject to timeout. Because threads are checked every 3 minutes to see if [...] 3984 18 22_os390 v4 to v5 upgrade0_27_Bud.Greenman@ONONDAGA.NY.US31_Fri, 22 Oct 1999 15:11:34 -0400524_- We are looking at upgrading to v6 shortly from v4 (with a stop at v5). Our Tech support people are a little leary about the upgrade since we had a few problems going from 3 to 4. We are relatively new to DB2 and, in fact, when we were at v3 there were no productional databases. I was asked to find out what the upgrade entails and if the customization options that are currently being used would be automatically picked up. If anyone else has had experience with this we would appreciate any input TIA. Bud Greenman [...] 4003 37 31_Re: ZPARM - Idle Thread Storage12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 22 Oct 1999 12:17:26 PDT712_- Parm is: IDTHTOIN values are seconds 0-9999 (0 = no timeout) Make sure to syncronize this with any other 'server' timeout parameters.

Craig Patton DB2 DBA



>From: Dan S Brogdon >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: ZPARM - Idle Thread Storage >Date: Fri, 22 Oct 1999 11:23:14 -0700 > >Does anyone know what the parm name is on the ZPARM which allows you >specify >the amount of storage for IDLE THREAD's. ? >Thanks >Dan > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage at http://www.ryci.com/db2-l. The owners of [...] 4041 51 24_Re: DB2 Datamigrate Tool0_20_evans036@MC.DUKE.EDU31_Fri, 22 Oct 1999 15:30:55 -0400367_us-ascii ray,

this tool can unload ri intact rows. you basically specify the name of a single table & selection criterion & the tool does the rest. the web page specified in my original post has a lot more info.

only declarative ri is supported (ie not triggers)

what platform or you running on & do you have RLX from relational architects? [...] 4093 53 37_DB2 Connect Version 6 Wildcard option11_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Fri, 22 Oct 1999 15:12:00 EDT641_us-ascii Hello list,

We upgraded our DB2 Connect server to version 6 with no problems last month and began rolling out upgrades for the V6 clients. One of our developers reported that she could no longer access certain tables using the Powerbuilder tool. After some research, I determined that tables with an underscore ('_") in the name would generate an error message "can't access table", but tables without an underscore worked fine. There is a new parameter called wildcard (using client configuration assistant it is under properties -> settings -> advanced -> optimization OR underscore=0 in the DB2CLI.INI file). For our [...] 4147 20 28_bind default for currentdata12_Wayne Fugere22_fugere_wayne@YAHOO.COM31_Fri, 22 Oct 1999 12:58:36 -0700529_us-ascii Does anyone know of a way to change bind defaults? We are wanting to change the CURRENTDATA default from NO to YES. Has anyone done this before? TIA Wayne

__________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4168 34 32_Re: bind default for currentdata20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 22 Oct 1999 15:58:10 -0400659_- NO was default in earlier DB2 versions, I think pre v3. Which version are you running ?

> -----Original Message----- > From: Wayne Fugere [SMTP:fugere_wayne@YAHOO.COM] > Sent: Friday, October 22, 1999 3:59 PM > To: DB2-L@RYCI.COM > Subject: bind default for currentdata > > Does anyone know of a way to change bind defaults? > We are wanting to change the CURRENTDATA default from NO to YES. > Has anyone done this before? > TIA > Wayne > > __________________________________________________ > Do You Yahoo!? > Bid and sell for free at http://auctions.yahoo.com > > ================================================ > To change your subscription [...] 4203 31 20_change bind defaults12_Wayne Fugere22_fugere_wayne@YAHOO.COM31_Fri, 22 Oct 1999 13:15:29 -0700400_us-ascii I hate it when that happens. What I meant was: We are wanting to change the CURRENTDATA default to NO from YES.

But the option is not the issue, has anyone ever changed any default bind parameter and if so, how.

At 03:11 PM 10/22/99 -0400, you wrote: >We are looking at upgrading to v6 shortly from v4 (with a stop at v5). Our >Tech support people are a little leary about the upgrade since we had a few >problems going from 3 to 4. We are relatively new to DB2 and, in fact, when >we were at v3 there were no productional databases. >I was asked to find out what the upgrade entails and if the customization >options that are currently being used would be automatically picked up. If >anyone else has had experience with this we would appreciate any [...] 4290 49 32_Re: bind default for currentdata10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Fri, 22 Oct 1999 13:04:58 -0700683_us-ascii I believe this was an option in ZPARM in v4. There is no option in v5 that I've found.

Bill Welch

>At 12:58 PM 10/22/99 -0700, you wrote: >Does anyone know of a way to change bind defaults? >We are wanting to change the CURRENTDATA default from NO to YES. >Has anyone done this before? >TIA >Wayne > >__________________________________________________ >Do You Yahoo!? >Bid and sell for free at http://auctions.yahoo.com > >================================================ >To change your subscription options or to cancel your subscription visit the >DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be >reached at DB2-L-REQUEST@RYCI.COM. 4340 14 24_Re: change bind defaults0_31_truman.g.brown@BELLATLANTIC.COM31_Fri, 22 Oct 1999 16:20:48 -0400472_us-ascii Users/DBA's cannot change DB2 defaults. In fact, it's a very good idea to always use explicit syntax to get exactly what you want, then you don't have to worry about IBM changing any defaults and the subsequent GOTCHA....

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4355 52 18_Re: COOL:Gen - MVS11_Mark Ediger15_mediger@CME.COM31_Fri, 22 Oct 1999 15:41:05 -0500436_us-ascii Michael,

We long ago (when it was known as IEF) converted from the RPROF table to Temp Storage because those tables became a bottlneck for our applications' performance. I would recommend against them but if you do use them, try to use separate tables for different applications. Also, we coded our action blocks to avoid keeping scrolling information in either place (we also use the psuedoconversational option). [...] 4408 67 18_Re: COOL:Gen - MVS19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Fri, 22 Oct 1999 13:46:33 -0700573_- 1. Whichever option you pick, the RPROF option will still be required (as of COOL:Gen V4.1 at least) for interactive testing. This will require the RPROF table in the test database(s) assigned to the developers.

2. We used the TS option for code generated to run under CICS, generally because we felt the overhead of CICS managed Temp Store in memory would be less than a DB2 object on DASD. What we didn't know at the time was that unless you exit from the COOL:Gen module through the application code, the TS record doesn't get deleted. Since our users had [...] 4476 140 22_Re: Peculiar Behavior?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 22 Oct 1999 16:59:38 -0400365_iso-8859-1 The VARCHAR in the index is tricky and needs DSNZPARM changes in order to achieve match cols or index only access. The parm is RETVLCFK=NO/YES. "Yes" will show more match cols because in this cas entire column value is stored (in non variable form).

If your application logic is dependent on varchar length then this option is not advisable. [...] 4617 30 23_New to web applications0_21_kramps@NATIONWIDE.COM31_Fri, 22 Oct 1999 17:40:35 -0400527_us-ascii We are just starting to look into accessing DB2 OS/390 data from web-based applications, and so we know very little about DB2 Connect and other such software.

With that in mind, we have a new web application that will access DB2 OS/390 data. Its basic architecture is a Windows client accessing a Windows NT server. This is where the web server will be. From there, DB2 OS/390 data will be accessed. Initially, this application will remain internal, but eventually it will be made available to the public. [...] 4648 43 18_DB2 thread problem11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Fri, 22 Oct 1999 15:09:18 -0700295_- Esteemed list

Our CICS admin canceled a DB2 thread which it seems was active for over 4 hrs., but the thread did not terminate, then he went into Omegamon for CICS and killed the transaction. Even then the DB2 thread did not go away. At this point I was called. This is what I saw [...] 4692 102 22_Re: DB2 thread problem0_19_Tim.Lowe@STPAUL.COM31_Fri, 22 Oct 1999 17:37:36 -0500409_us-ascii Sanjay, The DB2 cancel thread command will not have any effect if the program is not in DB2 at the moment. It would take effect when the program next calls DB2. In order to cancel this transaction you would have to use the CICS command to "force purge" the transaction. (at this shop, a CICS systems programmer would do this) The CICS/DB2 connection would not stop because of the active thread. [...] 4795 78 22_Re: DB2 thread problem11_Case, Missy15_CASEM@PKSIS.COM31_Fri, 22 Oct 1999 17:38:24 -0500533_- Sanjay, Was this an SAP thread problem? W had a similar problem with our SAP threads doing that and found it was some CICS settings for thresholds in SAP. I can get the full details from my CICS person if you'd like. We even had to go so far as bouncing our PROD DB2 region once to clear that out, because bouncing CICS didn't even clear it out all the way. We kept thinking it was ATAB deadlocks or code problems. Our entire list of threads in Omegamon would show 'not-in-db2' except for 1 wait-lock thread - pages worth and [...] 4874 38 23_Re: Recover to Copy/POT8_Dan Tuck26_DTuck@GRPWISE-EAST.TRW.COM31_Fri, 22 Oct 1999 18:50:19 -0400568_US-ASCII I agree with you suggested method. Perform a ToCopy recovery and then do a ToRBA recovery with LogOnly. I believe that Recover, when it finds the missing IC would fallback to LogOnly anyway.

>>> 10/15 12:36 PM >>> I want to recover a tablespace to a particular RBA (TORBA). However, I want it to begin from a particular Image Copy about five copies back ( some intermediate IC datasets were inadvertently deleted), and do log applies from that point forward. Which combinations of parameters and multiple loads do I use? [...] 4913 24 31_Re: ZPARM - Idle Thread Storage13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Fri, 22 Oct 1999 16:30:32 -0700546_- Found it,, thought I'd let you know.

APAR PQ06377

(2) For further DBM1 storage relief, it is recommended to reduce the default ADMF AGENT LOCAL POOL expansion size (in DSNZPARM)to 32k, this can be done by modifying the DSNTIJUZ job to specify &ALPOOLX=32256 in the DSN6SPRM parameters. This will help reduce the storage held by ALL active threads and system agents as well as inactive Distributed threads. Note: if you have NEVER experience any DBM1 private storage shortage then there is NO need to alter this DB2 DSNZPARM. [...] 4938 68 25_Comand DB2 - OPTIMIZE FOR14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 23 Oct 1999 12:09:42 +1000663_us-ascii Pleas supply EXPLAIN output and Strobe details of CPU on Declare, Open, Fetch, and Close.

Also Wait Time (I/O + Locking etc.) and estimated SQL Counts if you have them.

Also what are indexes and columns in indexes?

From: Michael Hannan

>From: "Pedro Correia (DSI)" >Subject: Comand DB2 - OPTIMIZE FOR >To: DB2-L@RYCI.COM > >Hi All > >I have a program with this: > >EXEC SQL > DECLARE FETCH_TMCPG CURSOR FOR > SELECT > NUM_PAGAMENTO > ; NUM_REC_QUITACAO > ; TIPO_PAGAMENTO > ; VALOR_DEB_ESC > ; VALOR_DEB_EURO > ; VALOR_CRE_ESC > ; VALOR_CRE_EURO > ; NUMERARIO_ENT_ESC > ; NUMERARIO_ENT_EURO [...] 5007 31 63_CICS-DB2 Attachment Thread Sign-on and RCT AUTH=GROUP Parameter0_22_kmulcahy@CHECKFREE.COM31_Sat, 23 Oct 1999 09:35:15 -0400497_us-ascii Hi! I have number of performance questions about the CICS-DB2 Attachment Facility and think it best to pose one question at at time. I'll try to make the questions as unambiguous as possible.

IBM recommends that we maximize thread reuse and minimize thread sign-on to acheive the best performance for high-priority high-volume transaction workloads. How this is implemented has been consistently documented in the publication library, red books, and conference presentations. [...] 5039 69 18_Re: Old packages..9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Sat, 23 Oct 1999 12:26:57 -0400389_iso-8859-1 Or, you could just set up a rule that saves package versions based on very liberal guidelines. For example: keep "n" versions of every package per collid, making sure that any versions to be freed are older than "m" months. You can code an SQL statement to build the package free commands, and (if DB2 for OS/390), use DSNTIAUL to construct the command list for execution. [...] 5109 139 28_Repost: DB2 Datamigrate Tool19_J. Michael Morrilll21_xavier@NETEXPRESS.NET31_Sat, 23 Oct 1999 12:45:30 -0500389_iso-8859-1 Greetings!

Below is a reply from Bob Smith to a post made by Ray Lopez. Mr. Smith is not a subscriber to the list. At Mr. Smith's request, I am forwarding his reply to the list. The attachment mention at the end of the post was removed because attachments may not be posted to the list. If you would like a copy of the attachment, please contact Mr. Smith directly. [...] 5249 52 55_Re: Automatic Number generator for a table - on DB2 UDB18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Sat, 23 Oct 1999 14:55:29 -0300305_iso-8859-1 Hi Milorad! Have you solved the autonumber problem? I implemented the solution proposed in "DB2 Universal Database V5 Implementing Sequences", it needs some minor fixes, but it is working fine. If you need more help, just ask me. Sorry for the delay, I´m checking mail only once a week :( [...] 5302 21 36_The DB2-L web page has been updated.19_J. Michael Morrilll21_xavier@NETEXPRESS.NET31_Sat, 23 Oct 1999 13:13:10 -0500493_iso-8859-1 Greetings!

The DB2-L web page at www.ryci.com/db2-L has been updated. Not much has changed. We have expended on some issues such as off topic post and authority to post.

Cheers!

J. Michael Morrill DB2-L Chief List Owner

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5324 289 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Sat, 23 Oct 1999 20:34:06 +0200298_x-user-defined Hi, Just an add-on. You may want to look after using VTS and then you get, in one go, both writing to a disk (the VTS disk ) and stacking on a cart. VTS uses an RS/6000 machine with big disks to get the data and then communicates with the tape robot to stack it on some magstar cart. 5614 106 22_Re: DB2 thread problem11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Sat, 23 Oct 1999 11:53:35 -0700483_- Missy,

We do not have SAP here. It is a CICS-COBOL-DB2 program. Being in development region, I don't think we would have reached any CICS threshold, though I am not sure which threshold you are talking about ? Could you get me more info from your CICS folks. May be we oughta take a look at CICS parameters. What puzzles me most is 'Why there were 20 odd transaction waiting for entry type thread ?' when the RCT entry for the same transaction has THRDM=5 and THRDA=3. [...] 5721 27 29_Accessing Rows In a DB2 Table10_Ravi Verma26_ravi.verma@TELECOMMAND.COM31_Sat, 23 Oct 1999 14:10:20 -0700424_us-ascii Dear friends,

I have two issues I need your comment on.

1. Those who know Oracle must have know pseudo column called ROWID which is concatenation of row address:block address:filename etc. ROWID is the fastest way to access a row in an Oracle table. Does DB2 have something like that?

2. Does DB2 have a hashing function? I need to hash values of few columns for subsequent faster access. [...] 5749 55 33_Re: Accessing Rows In a DB2 Table0_24_ssethi@LOT.TATASTEEL.COM31_Sun, 24 Oct 1999 11:48:15 +0530515_- Hi ,

1) ROWID concept is there in DB2 V6 not before that but as i came to know from this list only that ROWID can change after the Reorg is done and it looks quite correct to me ,however i have neither tried this in DB2 nor in Oracle.Can u please tell me that how it works in Oracle ?. 2) Regarding the Hashing i am not sure if some functions are available in later to V5 but DB2 uses three types of pointers to access the data internally i.e Indexes,Hashes and Links and out of these pointers Hashes [...] 5805 20 17_BP Hit Percentage0_24_ssethi@LOT.TATASTEEL.COM31_Sun, 24 Oct 1999 12:22:56 +0530329_- Hi All, What are the condition under which BP Hit %age will be negative ?. I have heard that if pages are read in but not GETPAGED then it will be negative ,this is o.k ,but except in case of Sequential Detection will this condition arise in any other case ,infact will it arise in case of sequential detection as well ?. [...] 5826 37 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!14_Max 'Guderian'13_mocion@TIN.IT31_Sun, 24 Oct 1999 12:17:04 +0200406_iso-8859-1 I Know, Isaac.

We are evaluating this solution as alternative to a Storagetek/CA tape manager.

But the problem, until we decide what is the solution to our problems (we really need a

device of this type), remains: I can't avoid inline image copy. Instead, if I could copy

tablespaces after the reorg and not IN the reorg I could administrate backups without any [...] 5864 35 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!14_Max 'Guderian'13_mocion@TIN.IT31_Sun, 24 Oct 1999 12:19:02 +0200568_iso-8859-1 Thanks for informations, Tim.

I was surprised that no one had the same 'problem'. I don't understand why you can't decide the 'type' of image copy you can run after reorg.

To execute reorg sharelevel reference you HAD to create GDGs on DASD so you can run many and many parallel reorg. But you had to have DASD space for GDGs, wasted space because GDGs are 'inactive' dataset and if you have few DASD you had to delete GDGs after 1-2 days. With a backup with DSNUM ALL, instead, you can copy with one-shot all partition reorged in a tape [...] 5900 53 26_Re: os390 v4 to v5 upgrade50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Sun, 24 Oct 1999 09:06:08 -0400450_- I had some problems with going from 3 to 4. It was in the additional indexes that were required. 4 to 5 went smooth. I would imagine that being so new to DB2 your shop has not developed any specific exits.

I would recommend that you read Migrating the DB2 subsystem in DB2 for OS/390 V5 Installation Guide Document Number: GC26-8970-01 Build Date: 01/13/99 19:18:18 Build Version: 1.3.0 Book Path: /u/ftp/books/os390/books/DSNIG0F4.BOO [...] 5954 49 26_Re: os390 v4 to v5 upgrade11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Sun, 24 Oct 1999 07:16:05 -0700595_- Bud,

I did a migration from ver 2.3 to v5.1 for a client 6 months ago. Did not have any problems whatsoever. If you want the current customization to carry forward to newer version, you have to make sure that you specify the right DSNTIDxx member of the old version DSNSAMP, when you run DSNTINST CLIST. Many times DB2 sysprog just make changes to DSNZPARM without updating DSNTIDxx member(DSNTIDxx can be updated either directly or through the CLIST). Hence the DSNTIDxx member usually is out of sync with DSNZPARM. In this case you have to re-enter those customization values in [...] 6004 70 27_Fw: EMC TimeFinder question11_Ron Haupert23_rhaupert@GOLDENGATE.NET31_Sun, 24 Oct 1999 10:30:32 -0500632_iso-8859-1 EMC TimeFinder can be integrated into DB2 environments in several ways. There are two primary functions associated with TimeFinder, - Volumes SPLIT functionality and SNAP functionality. Volume SPLIT provides volume mirrors or copies of volumes while SPLIT provides copies of data sets. The TABLESPACE or DATABASE should be quiesced using a START R/O and Quiesce WRITE YES ( to flush buffers) when the volumes are SPLIT or data sets are SNAPped. These procedures tend to take seconds. The application can be made available immediately after the SPLIT or SNAP is performed. The copy process is NOT part of the overall [...] 6075 92 33_Re: Accessing Rows In a DB2 Table14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Mon, 25 Oct 1999 01:43:25 +1000548_us-ascii Despite the DB2 V6 workings of ROWID being surrounded by secrecy, their workings can be deduced relatively easily.

The ROWID is made up of a combination of sections just like Oracle ROWID has sections.

One part of it is stored in each table row defined to have a ROWID. Part 1 is the unique generated number the never changes for a row and can be stored in the row permanently. At time of extraction of a Rowid from the row, two other parts need to be attached: Part 2 is the current RID or address of the the row. This [...] 6168 49 37_Re: How to decide the length of SQLDA14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 25 Oct 1999 12:04:19 +1000441_us-ascii Baskar,

Did you also set SQLN to 300 (first time) or 750?

Value in SQLDABC = 16 * SQLN + 44.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Tooronga +61 3 9261 1802 james.campbell@energyis.com.au -----Original Message----- From: Baskaran Subramaniam [mailto:subramaniam.baskaran@DB.COM] Sent: Friday, October 22, 1999 9:02 PM To: DB2-L@RYCI.COM Subject: How to decide the length of SQLDA [...] 6218 30 17_Imports & Exports0_30_Milorad_Cerovac@TAC.VIC.GOV.AU31_Mon, 25 Oct 1999 12:27:19 +1000379_us-ascii Dear listers,

We're in a bit of a pickle again ... we're a UDB ver 5 site running on an NT box. We're desperately trying to copy a database from one server (prod) to a QA server. We've been trying a backup followed by a restore but are having trouble because of information that DB2 keeps on the backup which prevents the target database from being useable. [...] 6249 60 21_Re: Imports & Exports0_18_rolchua@SES.COM.SG31_Mon, 25 Oct 1999 14:11:11 +0800306_us-ascii You can just copy the whole directory of the database to the QA server. Then catalog the database in the QA server. (Your setup in the QA server must be the same as the production Server. That is, if the prod database is resided in E: drive, then you should copy the files into E: drive too. [...] 6310 49 16_How to use SQLDA13_Paul Fletcher28_Paul_L_Fletcher@BISCUITS.COM31_Mon, 25 Oct 1999 07:30:47 +0000568_us-ascii Baskar,

Unfortunately you can not just include SQLDA in a COBOL program, you have to code it yourself first.

Here is what I have used many times.



01 SQLDA. 02 SQLDAID PIC X(8) VALUE 'SQLDA '. 02 SQLDABC PIC S9(8) COMP VALUE 33016. 02 SQLN PIC S9(4) COMP VALUE 750. 02 SQLD PIC S9(4) COMP VALUE 0. 02 SQLVAR OCCURS 1 TO 750 TIMES DEPENDING ON SQLN. 03 SQLTYPE PIC S9(4) COMP. 03 SQLLEN PIC S9(4) COMP. 03 SQLLEN-R REDEFINES SQLLEN. 05 SQLLEN-1 PIC X. 05 SQLLEN-2 PIC X. 03 SQLDATA PIC S9(9) COMP. 03 SQLIND PIC S9(9) COMP. 03 [...] 6360 101 21_Re: Row level locking0_18_rolchua@SES.COM.SG31_Mon, 25 Oct 1999 15:10:51 +0800387_us-ascii Hi Nash, Are you using Row-level locking? If you are, check that you application is not doing a tablespace scan. If your application is doing a tablespace scan, it is likely that you have reach the maximum locks, so db2 escalated to tablespace lock.

Regards Roland











Nash Gupta on 23/10/99 02:35:54 [...] 6462 19 12_Long Varchar0_24_ssethi@LOT.TATASTEEL.COM31_Mon, 25 Oct 1999 11:18:00 +0530335_- Hi all, I am trying to unload a table which is having a column of Data Type Long Varchar(2048 Bytes). After unloading i am not able to find the data corresponding to that field in the Sequeuntial File. I would like to know Is there any specific parameter to be given while unloading the tables containing Long Varchar columns . [...] 6482 15 29_Re: Comand DB2 - OPTIMIZE FOR19_Pedro Correia (DSI)27_TE00102@MUNDIALCONFIANCA.PT31_Mon, 25 Oct 1999 08:44:58 +0200337_- Thanks to Alistair Maclean; Michael Hannan and Ven llagan for their help.

Best regards

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6498 94 18_DSTATS Comments...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Mon, 25 Oct 1999 11:33:20 +0300359_- Hello List,

I've just started to use DSTATS. It performed very well for my test queries. I measured the performance with the cost of SQL. Most of the test queries' cost factor decreased. But when i started to use it for DataWarehouse env. Cost factor of every Query is almost doubled. I was expecting them to decrease. How do you explain this ? [...] 6593 51 21_Re: Imports & Exports0_23_john.lantz@ZURICHUS.COM31_Mon, 25 Oct 1999 09:16:37 -0400349_us-ascii Use the DB2MOVE utility that is found under the SQLLIB\MISC directory. Just type in DB2MOVE ? to get the syntax. I believe it's documented in the manuals as well. Basically it will export and import objects from one database to another. But it also has the option to do a load rather than IMPORT. Which is what I think you want to do. [...] 6645 20 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!0_19_Tim.Lowe@STPAUL.COM31_Mon, 25 Oct 1999 09:00:35 -0500364_us-ascii Isaac, DB2 developers told us at the DB2 technical conference that a virtual tape drive would appear the DB2 V6 for OS/390 as a tape drive. Therefore, they said that DB2 V6 parallel copy and recovery would not occur if you were using VTS, it would be done serially. (It would seem that sometimes it does not pay to "fool mother nature",or DB2?). (-: [...] 6666 137 22_Re: DB2 thread problem11_Mark Ediger15_mediger@CME.COM31_Mon, 25 Oct 1999 08:56:09 -0500556_us-ascii Sanjay,

If you are sure that there was only one AP20 transaction running and not three, then check to see if anyone issued a "DSNC MODIFY TRANSACTION AP20 1" command. This would have reset the max transactions for the transaction to 1. As for the cause of the problem, check for Transaction dumps for that transaction around the time of the transacton startup. Also since your entry thread does not specify TWAIT, this is defaulting to YES. If this is not what you want be sure to specify TWAIT=POOL so that transactons will not wait. [...] 6804 159 22_FW: DB2 thread problem14_Murray Webster26_Murray.Webster@MS.RC.GC.CA31_Mon, 25 Oct 1999 10:13:01 -0400380_iso-8859-1 We had a similar problem with threads that appeared to be dead but were yet holding resources. We fixed the problem with APAR PQ18780 which is for CICS TS 1.2. I believe that there are different APARs that one can apply for this problem for different releases of CICS.

Murray Webster Revenue Canada DB2 Software Support ITB/TOCS/HTM/AIS/MEDS (613) 941-6710 [...] 6964 29 15_Abend with -80420_Baskaran Subramaniam27_subramaniam.baskaran@DB.COM31_Mon, 25 Oct 1999 19:47:25 +0530560_us-ascii Hi James

Thanks for providing the info regarding the calculation of length of SQLDA. In the IBM book manager it is given as SQLDABC = 16 + 44 * SQLN., could you please confirm whether this is right.

But even after specifying the length as you said, ( I had given 33016 for SQLDABC along with SQLN as 750 ) the same abend (-804) persists. The reason code is again 07 which indicates invalid SQLDA length. For this application regarding Variable list select using Dynamic SQL I know in prior that only a max of 6 columns are going to [...] 6994 117 21_Re: Row level locking13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 25 Oct 1999 10:32:14 -0400576_- How big is the table? If the table is tiny, i.e. just a few rows that fit on one page, then with page-level locking, the app will have locked other rows just because they're on the same page.

> -----Original Message----- > From: rolchua@SES.COM.SG [SMTP:rolchua@SES.COM.SG] > Sent: Monday, October 25, 1999 3:11 AM > To: DB2-L@RYCI.COM > Subject: Re: Row level locking > > Hi Nash, > Are you using Row-level locking? If you are, check that you application is > not doing a tablespace scan. If your application is doing a tablespace > scan, it is likely that you [...] 7112 134 18_Re: Old packages..16_Eric Harper st1719_eharper@ROSEINT.COM31_Mon, 25 Oct 1999 09:42:57 -0500582_iso-8859-1 I have battled with this problem for many years. The issue of packages that use AUTO versioning is one problem. The only guarantee to find the correct version, is to examine the load module. In Cobol II the Consistency Token was reversed last four bytes first and first four bytes last, just after the literal 'VER'. I have not rechecked this for Cobol LE. You have to verify, because invariably, someone promotes a program to production, then backs out the load module without rebinding, so the newest module may not be the one currently in use. Someone had a Rexx [...] 7247 23 18_Re: Old packages..0_19_Tim.Lowe@STPAUL.COM31_Mon, 25 Oct 1999 10:00:23 -0500559_us-ascii We too have had some problems where an application "backed out" a change by copying the "old" load module back to a production loadlib and wound up with -805 problems due to DB2 package cleanup. (maybe twice a year?) I have been considering changing our DB2 package cleanup process from using column PCTIMESTAMP to using a TIMESTAMP (if TIMESTAMP is "bad" due to PQ22694, I would still use PCTIMESTAMP). (We use version AUTO, and "cleanup"/free all but the newest version of each package in each collection for each dbrmlib.) What do you think? [...] 7271 126 21_Re: Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 25 Oct 1999 11:28:02 -0400362_us-ascii Roland, I am using the default value (I believe DB2 uses row level locking as a default)...I don't know how to confirm whether its really using row level locking...Now how do I check for tablespace scan?? The tables are indexed well..That should take care of the tablescans..

Thanks! - Nash

rolchua@SES.COM.SG on 10/25/99 02:10:51 AM [...] 7398 146 21_Re: Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 25 Oct 1999 11:52:20 -0400386_us-ascii Lynne, the tables have anyhere between 50 and 7000 rows..Its small database....Now, will a table with 5000 to 7000 rows , or even 10000 rows do a page level locking??? Some of these tables have around 20 -25 columns...





Lynne Flatley on 10/25/99 09:32:14 AM

Please respond to DB2 Data Base Discussion List [...] 7545 90 21_Re: Imports & Exports13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Mon, 25 Oct 1999 10:54:20 CDT315_- Doing a redirected restore would be by far the quickest. There is nothing in the backup image that would prevent restoring on to another server other than codepage. If you encounter code page problem than create the database with the required code page on the target server and then do a redirected restore. [...] 7636 58 21_Re: Row level locking14_Wayne Driscoll19_WDriscoll@QUEST.COM31_Mon, 25 Oct 1999 09:06:28 -0700543_iso-8859-1 Nash, Page locking is only available on DB2 for MVS or OS/390, not on DB2 for Windows NT or UNIX. In your original post, you mentioned that the problem was that you turned off auto-commit then inserted a row, then issued a select on the table and got locked out. What was the select statement doing? When an insert is done, DB2 will take a number of locks in order to prevent any indexes from being corrupted, perhaps this, not a table lock is the problem. To resolve this, you would need to use the snapshot monitor in UDB to [...] 7695 38 17_QMF batch problem18_Sundaresan, Sundar33_Sundar.Sundaresan@SEA.SIEMENS.COM31_Mon, 25 Oct 1999 12:11:46 -0400557_- This is a problem that we have been experiencing when several QMF batch jobs are running together. If anybody could suggest a solution it would be greatly appreciated.

DB2 ver 4.1 put level 9810 QMF 3.3

-------------------------------- Step return code 998 --------------------------------



READY

ISPSTART PGM(DSQQMFE) PARM(M=B,S=DSNP, I=Q.OP1MD_P1S(&&QUERY=MSQ7210Q,&&FORM=MSQ7210F, &&RPTID='XXXXXXXX')) NEWAPPL(DSQE)

ISPT036 Table in use -/-TBOPEN issued for table ISPSPROF that is in use, ENQUEUE failed. [...] 7734 95 21_Re: Row level locking0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 25 Oct 1999 11:12:33 -0500339_us-ascii To find out what level of locking is used, take a look at SYSIBM.SYSTABLESPACE.LOCKRULE A - any (I'm not positive that includes Row, in one place manuals seems to imply that it starts at Page locks) P-page R-Row S Tablespace T Table

To check for a TS scan do an EXPLAIN and look for ACCESSTYPE=R and TSLOCLMODE=U or X [...] 7830 83 21_Re: Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 25 Oct 1999 12:17:40 -0400319_us-ascii Wayne, the select statement was fired just to see if I could access any other row except the one which was inserted (since that was in uncommitted state)... Now, lets say I have table (10000 rows and 35 columns) which is accessed quite often...Will the table get locked everytime an insert is performed?? [...] 7914 69 33_Re: Accessing Rows In a DB2 Table14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 25 Oct 1999 11:18:59 -0500569_ISO-8859-1 Some answers to your questions:

1. As of Version 6, DB2 does have the ROWID data type. Here is the text right out of the DB2 V6 SQL Reference manual:

A row ID is a value that uniquely identifies a row in a table...A ROWID column enables queries to be written that navigate directly to a row in the table. Each value in a ROWID column must be unique, and DB2 maintains the values permanently, even across table space reorganizations. When a row is inserted into the table, DB2 generates a value for the ROWID column unless one is supplied. [...] 7984 93 21_Re: QMF batch problem0_19_Tim.Lowe@STPAUL.COM31_Mon, 25 Oct 1999 11:19:04 -0500413_us-ascii Sundar, You might want to add a DD statement like this to your jcl: //ISPPROF DD DCB=(RECFM=F,LRECL=80,BLKSIZE=0), // SPACE=(TRK,(1,1,1))

It works in my environment, and if you have no dependency on information in the profile dataset, it should work for you.

I also add these DD statements to eliminate dependencies on an spf list and log dataset: //ISPLIST DD DUMMY //ISPLOG DD DUMMY [...] 8078 85 33_Re: Accessing Rows In a DB2 Table10_Ravi Verma26_ravi.verma@TELECOMMAND.COM31_Mon, 25 Oct 1999 09:35:45 -0700398_us-ascii Thanks a lot for the help.

Regarding the hashing function. My need to is to do search on a large table containing over 20 million rows. I was thinking of creating a summary table with ROWID, and hashed values of the natural key from the target table. After which I would hash the values from the source(staging area tables) and search the summary table with the hashed values. [...] 8164 101 55_Re: Automatic Number generator for a table - on DB2 UDB10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 25 Oct 1999 12:48:51 -0400389_us-ascii



Daniel, do you where can I get a copy of "DB2 Universal Database V5 Implementing Sequences" The web site address you metioned last time doesn't have...Can you pls send an attachement of that file..ThanksC! _ Nash

Centro de Computos on 10/23/99 12:55:29 PM

Please respond to DB2 Data Base Discussion List [...] 8266 125 21_Re: QMF batch problem11_Daryl Wells18_dwwell1@US.IBM.COM31_Mon, 25 Oct 1999 12:46:16 -0400474_us-ascii You will also need specify your clist library in this dd. The start is an ispf dialog manager command.

------------------------------------------------------------------ From: Daryl Wells DB/DC Support IBM Global Services Tie Line 427-3242 Phone (813) 878-3242



Tim.Lowe@STPAUL.COM on 10/25/99 12:19:04 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: QMF batch problem [...] 8392 101 21_Re: Row level locking13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 25 Oct 1999 13:01:45 -0400337_- I believe we are discussing DB2 for OS/390, correct? The locksize defaults to ANY, which starts out at page-level locking and escalates to table or tablespace. To do row-level locking you have to specify it on the tablespace definition at CREATE or ALTER time. Also, all indices need to be type 2. What version of DB2 are you at? [...] 8494 130 21_Re: Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Mon, 25 Oct 1999 13:04:40 -0400642_us-ascii Lynne, I have DB2 for AIX v5.2 here..Hope this helps..Thanks! - Nash

Lynne Flatley on 10/25/99 12:01:45 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Row level locking







I believe we are discussing DB2 for OS/390, correct? The locksize defaults to ANY, which starts out at page-level locking and escalates to table or tablespace. To do row-level locking you have to specify it on the tablespace definition at CREATE or ALTER time. Also, all indices need to be type 2. What version of DB2 are you at? [...] 8625 122 33_Re: Accessing Rows In a DB2 Table12_Myron Miller24_myron_miller@HOTMAIL.COM29_Mon, 25 Oct 1999 10:34:58 PDT483_- Again, why do you need hashed values for keys? There are lots of applications which use natural keys that have many more rows that 20 million that perform very well. I've worked with data warehouse tables with hundred's of millions of rows in the various tables without hash keys. The performance depends more upon good quality SQL and the design of the tables with indexes that support the SQL. With DB2, there is very little need for direct hash key lookups like in Oracle. [...] 8748 129 33_Re: Accessing Rows In a DB2 Table10_Ravi Verma26_ravi.verma@TELECOMMAND.COM31_Mon, 25 Oct 1999 10:47:35 -0700573_us-ascii Because fast is not good enough for me, I want it faster. Just kidding, thanks for your response.

Myron Miller wrote:

> Again, why do you need hashed values for keys? There are lots of > applications which use natural keys that have many more rows that 20 million > that perform very well. I've worked with data warehouse tables with > hundred's of millions of rows in the various tables without hash keys. The > performance depends more upon good quality SQL and the design of the tables > with indexes that support the SQL. With DB2, there is [...] 8878 66 36_Re: Use of Image Copy NOT in SYSCOPY11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Mon, 25 Oct 1999 09:53:31 -0700692_- Venkat,

The SPRMCTU parm didnot work, I get -807.

Sanjay

-----Original Message----- From: Pillay, Venkat (PCA) Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Wednesday, October 13, 1999 7:01 AM Subject: Re: Use of Image Copy NOT in SYSCOPY



>Rick > > Sure recovery checks for entry in SYSCOPY. Following ways to do this >- > >Traditional way - DSN1COPY without RESET option followed by LOGONLY recovery >TORBA or TOLOGPOINT > >Unusual way - While assembling DSNZPARM set SPRMCTU bit to X'80' (macro >DSN6SPRC) to enable catalog update. Insert an entry in SYSCOPY and you >should be able to recover as [...] 8945 179 26_Re: FW: DB2 thread problem11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Mon, 25 Oct 1999 10:08:45 -0700690_- Mark/ Murray,

Thanks for the input, I will pass this info to our CICS admin. There was no DSNC MODIFY command given, though.

Sanjay

-----Original Message----- From: Murray Webster Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Monday, October 25, 1999 7:14 AM Subject: FW: DB2 thread problem



>We had a similar problem with threads that appeared to be dead but were yet >holding resources. We fixed the problem with APAR PQ18780 which is for CICS >TS 1.2. I believe that there are different APARs that one can apply for >this problem for different releases of CICS. > >Murray Webster >Revenue [...] 9125 188 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Mon, 25 Oct 1999 08:33:11 -0700453_- Ven,

If you delete the imagecopy taken after REORG(in the morning), then you can not recover to any point in time(should a situation arise) between the REORG and the afternoon imagecopy.

Sanjay

-----Original Message----- From: Ven Ilagan Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Friday, October 22, 1999 5:25 AM Subject: Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !! [...] 9314 150 21_Re: Row level locking13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 25 Oct 1999 15:08:50 -0400621_iso-8859-1 I'm sorry...I was sending you down the wrong path...I was speaking from the world of OS/390. UDB for AIX, NT, etc. doesn't do page locks. Wayne's suggestion of turning on the snapshot monitor for deadlocks should give you the answers you need, i.e. exactly what is contending with what.

> -----Original Message----- > From: Nash Gupta [SMTP:nashgupt@US.IBM.COM] > Sent: Monday, October 25, 1999 1:05 PM > To: DB2-L@RYCI.COM > Subject: Re: Row level locking > > Lynne, I have DB2 for AIX v5.2 here..Hope this helps..Thanks! > - Nash > > Lynne Flatley on 10/25/99 12:01:45 PM > > [...] 9465 29 68_Message from the List Owners: If you need to contact the list owners19_J. Michael Morrilll21_xavier@NETEXPRESS.NET31_Mon, 25 Oct 1999 14:25:39 -0500415_iso-8859-1 Greetings!

If you need to contact the list owners including me, please send your e-mail to db2-L-request@ryci.com

I have accepted a position as Integration Manager for VantagePoint (www.vantagepoint.com). I will be starting November 1, 1999. From now until the first of the year, my work with DB2-L will be limited. Therefore, I will not be able to quickly reply to requests for help. [...] 9495 24 23_Tools for Data Sharing?9_Sally Mir16_smir@BCBS-GA.COM31_Mon, 25 Oct 1999 15:26:03 -0400365_us-ascii What tools would you all recommend as essential needs for a data sharing environment? I assume a good performance monitor is crucial.

Can you recommend good monitors and/or other products that we should look into? Any pros, cons, things to look out for in this one versus another?

TIA,

Sally Mir Blue Cross Blue Shield of Georgia [...] 9520 23 31_DB2 Global Temporary Table -55113_David S. Bird25_DBird@KEMPERINSURANCE.COM31_Mon, 25 Oct 1999 14:42:51 -0500359_us-ascii I'm supporting an application that is using global temporary tables to copy rows of a table, change a key, value, and put them back in the table with the new key.

The Bind is failing on the Insert into temporary table statement with a -551.

Is it possible to grant insert and select authority on a DB2 Global Temporary another id? [...] 9544 103 33_Re: Accessing Rows In a DB2 Table0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 25 Oct 1999 14:47:43 -0500608_us-ascii Is hashing the key and idea you came up with yourself, based on past experience, or is it a technique that has been recommended to you (by a person or book, etc) specifically for use in a DB2 application?

I wonder if you are trying to apply old techniques to newer technology (like driving and 'manually' shifting an automatic transmission (of course excluding the newest type of auto transmission that is designed for manual shifting)). With older, less "advanced" DBMS the DBA and programmer had to be much more concerned with hand tuning: - explicitly identifying index to use (index [...] 9648 45 35_Re: DB2 Global Temporary Table -55122_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 25 Oct 1999 12:55:08 -0700486_iso-8859-1 I believe the only grant available to GTT's are grant all privileges. From the manual:

GRANT ALL PRIVILEGES ON T is valid, but you cannot grant specific privileges on T. Of the ALL privileges, only the ALTER, INSERT, DELETE, and SELECT privileges can actually be used on T.

-----Original Message----- From: David S. Bird [mailto:DBird@KEMPERINSURANCE.COM] Sent: Monday, October 25, 1999 12:43 PM To: DB2-L@RYCI.COM Subject: DB2 Global Temporary Table -551 [...] 9694 41 35_Re: DB2 Global Temporary Table -55113_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 25 Oct 1999 15:02:19 -0500373_US-ASCII Hello David, You cannot UPDATE a global temporary table. Use the GRANT ALL PRIVILEGES ON temporary table name. HTH Kurt

>>> "David S. Bird" 10/25/99 02:42PM >>> I'm supporting an application that is using global temporary tables to copy rows of a table, change a key, value, and put them back in the table with the new key. [...] 9736 84 36_Re: Use of Image Copy NOT in SYSCOPY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 25 Oct 1999 16:05:29 -0400605_- Did you try &SPRMCTU SETC '1' ?

> -----Original Message----- > From: sanjay jain [SMTP:sanjay_jain@EMAIL.MSN.COM] > Sent: Monday, October 25, 1999 12:54 PM > To: DB2-L@RYCI.COM > Subject: Re: Use of Image Copy NOT in SYSCOPY > > Venkat, > > The SPRMCTU parm didnot work, I get -807. > > Sanjay > > -----Original Message----- > From: Pillay, Venkat (PCA) > Newsgroups: bit.listserv.db2-l > To: DB2-L@RYCI.COM > Date: Wednesday, October 13, 1999 7:01 AM > Subject: Re: Use of Image Copy NOT in SYSCOPY > > > >Rick > > > > Sure recovery checks for entry [...] 9821 42 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 25 Oct 1999 22:06:49 +0200415_x-user-defined Hi Tim, If it'll work like that then IBM is shooting itself. I don't see it as "fooling" but as using resources wisely. Anyway - I don't have V6 handy but someone who has it and a VTS can give it a try. If not then back to the old method of using disk and immediate migrate to cart. BTW - there should be a new box from EMC which emulates tapes on disks only (unlike VTS which uses tapes at the end). 9864 17 24_Re: DB2 Datamigrate Tool9_Ray Lopez19_raylopez@US.IBM.COM31_Mon, 25 Oct 1999 14:09:01 -0600416_us-ascii We're running DB2 V5 on an OS/390. Without including application enforced RI, this will probably not work for me.

No, we don't have RDX.

Thanks anyhow.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9882 21 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!0_19_Tim.Lowe@STPAUL.COM31_Mon, 25 Oct 1999 15:42:06 -0500349_us-ascii Isaac, I am sorry, I was only sharing what I was told. I did not really like the answer either. On the positive side, we were told that future releases would implement parallelism for tape. Maybe in DB2 V7?? (and I was just trying to inject some humor with "fooling mother nature". At least, I thought it was funny! Sorry about that.) [...] 9904 52 15_Re: CRUD Matrix11_John Wynton21_jwynton@THEMISINC.COM31_Mon, 25 Oct 1999 16:40:56 -0400417_- Dear List Members:

The following was posted to DB2-L via a Newsgroup connection and because the poster is not subscribed did not make it to the list. I have the author's permission to post for the list members to reply to.

PLEASE reply to his email address (his name is Geoff) and NOT to the list, as he is not subscribed. I have sent him instructions however, so this question may appear again. [...] 9957 46 13_SQL code -81215_Philip, Sibimon19_PhilipS@SEALAND.COM31_Mon, 25 Oct 1999 16:54:01 -0400461_iso-8859-1 I have created a plan with *.* in COLLID and NAME assuming that DB2 will find the correct package by scanning all the collection. When I executed the program I got -812. Explanation in the book manager

-812 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM program-name.consistency-token USING PLAN plan-name [...] 10004 14 12_Load Utility8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Mon, 25 Oct 1999 15:54:13 -0500406_us-ascii Hi, We are in the process of setting up a big Data warehouse. And we are looking for a party utility to load data. Any recommendations?? Thanks in advance.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10019 21 28_Migrating UDB EEE 5.2 to 6.10_25_Pierre.Evans@AUTOZONE.COM31_Mon, 25 Oct 1999 16:20:54 -0500501_us-ascii Greetings all, We're migrating our test UDB EEE instance here from v5.2 to v6.1, and we have a couple questions re the admin server. Can an admin server instance created under v5.2 be migrated to 6.1, or do we delete that instance and recreate it ? Consequently, will the new control center still recognize our 5.2 production instance/database if the admin server was created as a v6.1 instance? I expect it to, but if anyone can confirm that i'd appreciate it. Thanks in advance Pierre [...] 10041 46 32_Re: Migrating UDB EEE 5.2 to 6.111_Steve Mazer17_smazer@FMTUSA.COM31_Mon, 25 Oct 1999 19:00:41 -0400585_us-ascii Pierre, I've migrated my personal edition on my laptop to Version 6.1 without doing ANYTHING to the admin server and it came up without a problem. It recognizes my V6.1DB2 UDB instance and includes all the features for Version 6.1 It also recognizes the development, test, and production DB2 UDB EEE instances at the site I'm working at. It shows all the options as before and can recognize the features in 5.2 without showing the features in 6.1, such as 'Generate SQL'. It does, however, show the 'Estimate Size' option for tables and indexes - kind of a nice feature. [...] 10088 250 46_SAP & ALICE on DB2 v5.1 dataset extend failure13_Ricardo Gomes30_ricardo.gomes@MELLO-IMPERIO.PT31_Tue, 26 Oct 1999 00:06:12 +0100426_iso-8859-1 Hi all. I'm having a big problem with my SAPR3 DB2 (v5.1 on OS390 2.6)instalation procedure After SAPR3 completed it's installation, another product was added: ALICE which is an ABAP4 programmed package operating on top of SAPR3. Once it's installation took place, several tablespaces & other common tables/indexes etc objects were added to DB2. Afterwards Package configuration began. And my problem as well. [...] 10339 49 35_Re: DB2 Global Temporary Table -55113_George Peters22_gpeters@COMPUSERVE.COM31_Mon, 25 Oct 1999 19:37:11 -0400644_iso-8859-1 David Priovs can be GRANTed to anybody, but I think you must GRANT ALL privileges on a GTT (with that wording)...check the Reference Manual. George

>-----Original Message----- >From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of >David S. Bird >Sent: Monday, October 25, 1999 3:43 PM >To: DB2-L@RYCI.COM >Subject: DB2 Global Temporary Table -551 > > > >I'm supporting an application that is using global temporary >tables to copy rows >of a table, change a key, value, and put them back in the table >with the new >key. > >The Bind is failing on the Insert into temporary table statement >with a -551. > [...] 10389 129 18_DSTATS Comments...14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 26 Oct 1999 09:37:46 +1000364_iso-8859-1 Cuneyt,

Without DSTATS information DB2 has only limited information available to estimate the cost of queries. Additional information will help DB2 estimate the costs better (but still be inaccurate). The better cost estimating may be higher for many queries and lower for some. With reduced information DB2 tend to be a bit too optimistic. [...] 10519 82 21_Re: Imports & Exports0_18_rolchua@SES.COM.SG31_Tue, 26 Oct 1999 09:01:08 +0800731_us-ascii Hi Milorad,

Have you tried "create database from Backup" . I had used this method to create the prod database (from prod server) into our backup server.

Roland.









john.lantz@ZURICHUS.COM on 25/10/99 21:16:37

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: CHUA CHONG KEE ROLAND/EDP/SES) Subject: Re: Imports & Exports







Use the DB2MOVE utility that is found under the SQLLIB\MISC directory. Just type in DB2MOVE ? to get the syntax. I believe it's documented in the manuals as well. Basically it will export and import objects from one database to another. But it also has the [...] 10602 40 6_DPROPR15_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Tue, 26 Oct 1999 13:08:19 +1000408_us-ascii Hi All,

Environment : DB2 for OS/390 V5 : DPROPR V5.1

While attempting to propagate changes from one of our tables (DB2 OS/390 to DB2 OS/390) we get this message :

ASN1011E The copy request has incompatible source and target attributes. The error code is 4C1104.

All other tables are propagating fine, and the registration and set-up for this table seem to be fine. [...] 10643 185 21_Re: Row level locking0_18_rolchua@SES.COM.SG31_Tue, 26 Oct 1999 14:56:02 +0800470_us-ascii Nash,

Additional to Wayne's suggestion: You can also activate the Event Analyzer - Turn on the deadlock parm. This will give you the detail of the deadlock event.

Roland











Lynne Flatley on 26/10/99 03:08:50

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: CHUA CHONG KEE ROLAND/EDP/SES) Subject: Re: Row level locking [...] 10829 37 31_consistency token --> timestamp9_Slot J.P.23_J.P.Slot@RF.RABOBANK.NL31_Tue, 26 Oct 1999 10:55:29 +0100426_us-ascii Hello DB2-L members,

On behalf of a fellow DBA i'm sending this message to u. I hope u can provide him with an answer.

I'm trying to write a program which compares the consistency token in a DBRM (example: 263EA7300F764388) with the token in the load module. It would be nice to translate the token in a readable timestamp format. Can anyone tell me how to translate the consistency token ?? [...] 10867 37 10_Abend -80419_Karthik Subramaniam26_karthik.subramaniam@DB.COM31_Tue, 26 Oct 1999 17:09:55 +0530688_us-ascii hai... When using dynamic sql for variable list select in VS-COBOL-II even after specifying correct SQLDA length say 33016 for 750 columns to retrieved, the same abend with Sqlcode -804 and sqlstate 07002 is comming.

As I have understood there is some problem in providing the list parameters for a SQL statement that is, here a PREPARE statement, what are the points to be considered? Can anybody throw some light on this? Is there any special considerations to be kept in mind during compilation, if the program involves CICS that is, an online application. Thanks and Regards. ***************************************************************** Karthik Subramaniam, [...] 10905 14 8_SQLERRMC12_David Thomas21_davidthomas@CHUBB.COM31_Tue, 26 Oct 1999 08:10:47 -0400470_us-ascii I've looked through all of my IBM/DB2 manuals, but have been unable to find any kind of a format for the SQLERRMC that is a part of the SQLCA. What should I do to know how DB2 formats the SQLERRMC for specific sqlcodes?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 10920 39 16_Re: Load Utility12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 26 Oct 1999 05:11:30 PDT698_- Kurian,

I have worked with the load utilities from both BMC and PLATINUM. Both are mature and relatively bug free, BMC having been around slightly longer. Both are VERY fast and offer additional features to make them easy to use.

HTH, Craig Patton





>From: Kurian B >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Load Utility >Date: Mon, 25 Oct 1999 15:54:13 -0500 > >Hi, We are in the process of setting up a big Data warehouse. And we are >looking for a party utility to load data. Any recommendations?? >Thanks in advance. > >================================================ >To change [...] 10960 30 12_Re: SQLERRMC13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 26 Oct 1999 08:35:18 -0400642_iso-8859-1 Hello again David. The SQLCA(the structure in which you'll find SQLERRMC) is described in Appendix C of the SQL reference. As it's described there, SQLERRMC "Contains one or more tokens, separated by X'FF', that are substituted for variables in the descriptions of error conditions."

Sounds like you are looking for one place where the format of these tokens are all described. You won't find it. The SQLcode error messages are fill-in-the-blanks type messages and the number of blanks(filled in by tokens from SQLERRMC) vary from message to message. For example for -904 there are 3 tokens: reason code, resource type [...] 10991 45 12_Re: SQLERRMC18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Tue, 26 Oct 1999 07:35:10 -0500617_iso-8859-1 David, see OS390/DB2 V5 SQL REF. manual, Appendix C SQLCA field descriptions, bookmanager ref: C.1.1. HTH, Rick Davis Technical Architect SWBT One Bell Center St. Louis, MO 63101 "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other [...] 11037 31 28_Collection-Id specification.13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 26 Oct 1999 08:14:55 -0500504_iso-8859-1 I want to know how DB2/OS390 V5.1 resolves which collection-id to use for static remote applications. The programs I am talking about are PC based applications written in C or Cobol, which have been through the DB2 pre-compiler. They use DB2 Connect.

Two examples/questions may help to explain what it is I am asking. 1. We have a 3rd party application written in C or Cobol and executes it packages from collection XYZ. 2. How does DB2 Connect know that the collection is NULLID. [...] 11069 73 35_Re: consistency token --> timestamp20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 26 Oct 1999 09:29:46 -0400321_- Here is the trick to convert CONTOKEN to timestamp (Curtsey: James Campbell , Australia).

The contoken has to be first convert into TOD clock (Store clock value).

Split the contoken into two full words (4 bytes) each. ---> part1 + part2 Hex multiply the second word with X'08' ---> part2 * 8 = part3 [...] 11143 43 27_FW: data encryption program12_Fertaki Gina20_GFertaki@EUROBANK.GR31_Tue, 26 Oct 1999 16:57:17 +0200435_windows-1253 Hello everybody, I am also interested in any available encryption code for the very same reason, as there is a need to encrypt passwords in DB2 in our installation also. Thank you in advance.

Gina Fertaki DBA EFG Eurobank Greece

-----Original Message----- From: Usregion10@AOL.COM [mailto:Usregion10@AOL.COM] Sent: Wednesday, October 20, 1999 9:41 PM To: DB2-L@RYCI.COM Subject: data encryption program [...] 11187 15 30_Generate create tablespace DDL13_Andy G Gravin25_Andy_G_Gravin@CARADON.COM31_Tue, 26 Oct 1999 14:51:26 +0000514_us-ascii Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our databases and generate the "create tablespace" and "create table" DDL. Does anyone know of software that will read the catalog tables and generate the "create tablespace" and "create table" DDL?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11203 39 34_Re: Generate create tablespace DDL15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Tue, 26 Oct 1999 10:15:09 -0400666_iso-8859-1 BMC's catalog manager can be used to generate the DDL.

Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com





-----Original Message----- From: Andy G Gravin [mailto:Andy_G_Gravin@CARADON.COM] Sent: Tuesday, October 26, 1999 9:51 AM To: DB2-L@RYCI.COM Subject: Generate create tablespace DDL



Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our databases and generate the "create tablespace" and "create table" DDL. Does anyone know of software that will read the catalog tables and generate the "create tablespace" and "create table" DDL? [...] 11243 44 34_Re: Generate create tablespace DDL12_Janis Thomas20_thomasj@PLATINUM.COM31_Tue, 26 Oct 1999 09:20:01 -0500815_us-ascii RC/Migrator from Computer Associates......... http://www.cai.com/products/db2/rcmigrator/overview.htm









Andy G Gravin on 10/26/99 09:51:26 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Generate create tablespace DDL







Note: Some recipients have been dropped due to syntax errors. Please refer to the "$AdditionalHeaders" item for the complete headers.





Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our databases and generate the "create tablespace" and "create table" DDL. Does anyone know of software that will read the catalog tables and generate the "create tablespace" and "create table" DDL? [...] 11288 34 34_Re: Generate create tablespace DDL11_Stout, Anne23_Anne.Stout@DOWJONES.COM31_Tue, 26 Oct 1999 10:28:18 -0400460_iso-8859-1 PLatinums RC migrator will do that.... their RC Update will also, but it is much more limited in scope... Both products are very good... I believe BMC has products with similar capacity but I have not used them..I think Compuware has something as well...

-----Original Message----- From: Andy G Gravin [mailto:Andy_G_Gravin@CARADON.COM] Sent: Tuesday, October 26, 1999 10:51 AM To: DB2-L@RYCI.COM Subject: Generate create tablespace DDL [...] 11323 77 32_DB2 Connect CC Strange Behaviour30_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE31_Mon, 25 Oct 1999 18:28:00 +0200375_iso-8859-1 --- Received from BG1.KELLERC 6785-2761 25-10-99 18.28

-> DB2-L@RYCI.COM

Hello, IMHO the command center in NT for DB2 Connect Personal Edition 5.2 FP 8 isn't much of a center. I am connecting from a NT 4.0 workstation to DB2V5 for OS/390 via TCP/IP.

The following command is entered in the command center (the German says everything ok). [...] 11401 411 50_Re: SAP & ALICE on DB2 v5.1 dataset extend failure22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 26 Oct 1999 15:47:11 +0100744_ISO-8859-1 my apologies .. max extents is 255 ..

regards Leslie



______________________________ Reply Separator _________________________________ Subject: SAP & ALICE on DB2 v5.1 dataset extend failure Author: Ricardo Gomes at Internet Date: 10/26/99 12:06 AM



Hi all. I'm having a big problem with my SAPR3 DB2 (v5.1 on OS390 2.6)instalation procedure After SAPR3 completed it's installation, another product was added: ALICE which is an ABAP4 programmed package operating on top of SAPR3. Once it's installation took place, several tablespaces & other common tables/indexes etc objects were added to DB2. Afterwards Package configuration began. And my problem as well. [...] 11813 35 34_Re: Generate create tablespace DDL11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Tue, 26 Oct 1999 07:50:45 -0700474_- CA's RC/Migrator does it. I am sure BMC and other vendors have a product too. But if you just want to generate DDL, why buy a product ? I would rather write a in-house utility (REXX & SQL) to generate DDL.

Sanjay Jain Pro Sol Inc.

-----Original Message----- From: Andy G Gravin Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Tuesday, October 26, 1999 7:14 AM Subject: Generate create tablespace DDL [...] 11849 42 34_Re: Generate create tablespace DDL12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 26 Oct 1999 07:57:27 PDT748_- Andy,

There are several companies that offer this type of software: CA/Platinum, BMC, Compuware, Candle, CDB.....Platinum and BMC have been around the longest.

HTH Craig Patton



>From: Andy G Gravin >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Generate create tablespace DDL >Date: Tue, 26 Oct 1999 14:51:26 +0000 > >Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our >databases >and generate the "create tablespace" and "create table" DDL. Does anyone >know >of software that will read the catalog tables and generate the "create >tablespace" and "create table" DDL? > >================================================ >To [...] 11892 43 34_Re: Generate create tablespace DDL13_Keith Gilbert17_kgilbert@CSA1.COM31_Tue, 26 Oct 1999 10:04:07 -0500295_iso-8859-1 Andy,

I few months ago Michael Hannan posted a set of SQL that would produce DDL from the system catalog. You could check the archives for this post or I could send you the copy I saved. I haven't had the chance to play with the SQL yet but it seems fairly comprehensive. [...] 11936 64 34_Re: Generate create tablespace DDL11_Daryl Wells18_dwwell1@US.IBM.COM31_Tue, 26 Oct 1999 11:02:21 -0400497_us-ascii Use REXX, ISPF Dialog Manager, and RXSQL. Note: RXSQL is unsupport but very good and stable.

------------------------------------------------------------------ From: Daryl Wells DB/DC Support IBM Global Services Tie Line 427-3242 Phone (813) 878-3242



sanjay jain on 10/26/99 10:50:45 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Generate create tablespace DDL [...] 12001 52 34_Re: Generate create tablespace DDL19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM31_Tue, 26 Oct 1999 15:54:13 +0100595_us-ascii Hi, Try BMC Catalog Manager. IT WORKS and is pretty simple to use.

Dhiren.



______________________________ Reply Separator _________________________________ Subject: Generate create tablespace DDL Author: Andy.G.Gravin (Andy_G_Gravin@CARADON.COM) at unix,mime Date: 26/10/99 15:51



Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our databases and generate the "create tablespace" and "create table" DDL. Does anyone know of software that will read the catalog tables and generate the "create tablespace" and "create table" DDL? [...] 12054 79 16_Re: Load Utility19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM31_Tue, 26 Oct 1999 15:50:22 +0100645_- Kurian,

We have been using BMC Load Plus at my site for some time now and it seems to be fairly steady. Should be a good bet espaecially for partionened tablespaces.

Dhiren.



______________________________ Reply Separator _________________________________ Subject: Re: Load Utility Author: prgpatton (prgpatton@HOTMAIL.COM) at unix,mime Date: 26/10/99 13:11



Kurian,

I have worked with the load utilities from both BMC and PLATINUM. Both are mature and relatively bug free, BMC having been around slightly longer. Both are VERY fast and offer additional features to make them easy to use. [...] 12134 66 34_Re: Generate create tablespace DDL14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 26 Oct 1999 11:12:20 -0400320_iso-8859-1 Andy:

And if your requirements aren't too complex you may be able to make do with DB2PLI8 program available for free from IBM. Use DDL or DDLONLY option to get your DDLs. I have recently started using it (since this shop doesn't have RC/Migrator) and so far had no problems.

Thanks, Manas. [...] 12201 65 34_Re: Generate create tablespace DDL10_Nash Gupta19_nashgupt@US.IBM.COM31_Tue, 26 Oct 1999 11:08:42 -0400629_us-ascii Keith, can you pls send the copy of SQL to generate DDLs from the sys catalog. Thanks! - Nash

Keith Gilbert on 10/26/99 10:04:07 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Generate create tablespace DDL







Andy,

I few months ago Michael Hannan posted a set of SQL that would produce DDL from the system catalog. You could check the archives for this post or I could send you the copy I saved. I haven't had the chance to play with the SQL yet but it seems fairly comprehensive. [...] 12267 67 34_Re: Generate create tablespace DDL19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM31_Tue, 26 Oct 1999 16:09:32 +0100478_us-ascii Hi Andy,

Did you receive this mail. I am very new to the mailing list and am not sure that the mails are being posted on the mailing list.

Rgds, Dhiren.



______________________________ Reply Separator _________________________________ Subject: Re: Generate create tablespace DDL Author: Dhirendra Chaudhary at ln,o,london,operations Date: 26/10/99 15:53



Hi, Try BMC Catalog Manager. IT WORKS and is pretty simple to use. [...] 12335 13 12_Re: SQLERRMC0_19_Tim.Lowe@STPAUL.COM31_Tue, 26 Oct 1999 10:14:31 -0500352_us-ascii Why don't you just call DSNTIAR to format the error message from the SQLCA so that you could read it?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12349 14 34_Re: Generate create tablespace DDL12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Tue, 26 Oct 1999 10:08:04 -0500424_us-ascii I'm sure BMC or CA/Platinum can do that for you. I have created a program that will do it also. Check with the software vendors or contact me directly and we can discuss it.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12364 35 13_Auth Clean Up13_Chuck Hinchey22_chinchey@RJCONSULT.COM31_Tue, 26 Oct 1999 10:21:00 -0500577_iso-8859-1 I am working to implement secondary auth ids in an existing system. There are many, many grants to individual user ids (including many redundant grants from multiple users). As part of this effort, my client wants to "clean up" the catalog by revoking all old and superfluous grants. So far so good. The problem is with views. Even when the id that created the view still has access (either through a grant to public or to the secondary auth id) to the underlying table, the view is dropped when the revoke is issued. It seems to be a sequence/timestamp thing. [...] 12400 64 17_Re: Auth Clean Up12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 26 Oct 1999 08:30:58 PDT476_- Chuck,

CA/Platinum has RC/secure that will do this for you (it allows views to be dropped as well as any other object, then recreates the object using new userids as specified) It can also prevent this from happening in the future. Another technique is to temporarily make the user one of the 'Install Sysadm', then drop the user's auth, then remove them from 'Install Sysadm'. This is tedious and involves the Zparms, but will prevent the dropping of the view. [...] 12465 16 34_Re: Generate create tablespace DDL0_25_Clint.Taylor@AUTOZONE.COM31_Tue, 26 Oct 1999 10:46:05 -0500401_us-ascii I would be very interested in seeing the SQL for generating the DDL. I would appreciate it if you send me the SQL that you have.



Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12482 648 55_FW: Gen DDL from DB2 Catlg V2 - Setup and Sample Output13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 26 Oct 1999 10:53:24 -0500441_ISO-8859-1 Reposting to get in the new server archives.

-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Tuesday, August 17, 1999 9:50 AM To: DB2-L@AMERICAN.EDU Subject: Gen DDL from DB2 Catlg V2 - Setup and Sample Output



Generate DDL from DB2 Catlg using SQL: This part is Setup DDL/SQL followed by Sample Output after @@@ Actual DDL gen is other messages. Use at own risk. [...] 13131 636 38_FW: Gen DDL from DB2 Catlg V2 - Part 113_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 26 Oct 1999 10:53:45 -0500658_ISO-8859-1 Reposting.

-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Tuesday, August 17, 1999 9:51 AM To: DB2-L@AMERICAN.EDU Subject: Gen DDL from DB2 Catlg V2 - Part 1



Generate DDL from DB2 Catlg using SQL commences (continued in parts 2 and 3). Other message has setup and sample output. Most previous restrictions covered. -- LIMITATIONS: NO V6 STUFF. -- ONLY ALLOWS VIEWS ON VIEWS OR ON TABLES (NOT ON ALIASES OR SYNS) -- SOME LITTLE THINGS LEFT OUT, E.G. DS PASSWORDS. -- DOESN'T DO UTILITY CONTROL STMTS LIKE RECOV INDEX OR CHECK DATA -- NO SYNONYMS (ASSUMES USE OF ALIASES). -- SOME [...] 13768 737 38_FW: Gen DDL from DB2 Catlg V2 - Part 213_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 26 Oct 1999 10:54:02 -0500824_ISO-8859-1 Reposting.

-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Tuesday, August 17, 1999 9:51 AM To: DB2-L@AMERICAN.EDU Subject: Gen DDL from DB2 Catlg V2 - Part 2



Generate DDL from DB2 Catlg using SQL continues (see also in parts 1 and 3). Other message has Setup and sample output.

---------------------------------------------------------------------- -- TABLE DROP RESTRICT ON DROP. ---------------------------------------------------------------------- SELECT SUBSTR(TEXT,1,80) AS TEXT ,TBCREATOR ,TBNAME ,CLAUSENO ,SUBNAME ,SEQNO ,LINENO FROM (SELECT CREATOR AS TBCREATOR ,NAME AS TBNAME ,' ' AS SUBNAME ,0 AS CLAUSENO ,0 AS SEQNO ,LINENO ,CASE WHEN LINENO = 1 THEN ' ALTER TABLE '!!STRIP(CREATOR)!!'.'!!STRIP(NAME) !! ' DROP RESTRICT ON [...] 14506 696 38_FW: Gen DDL from DB2 Catlg V2 - Part 313_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 26 Oct 1999 10:54:20 -0500932_ISO-8859-1 Reposting.

-----Original Message----- From: Michael Hannan [mailto:mhannan@C031.AONE.NET.AU] Sent: Tuesday, August 17, 1999 9:51 AM To: DB2-L@AMERICAN.EDU Subject: Gen DDL from DB2 Catlg V2 - Part 3



Generate DDL from DB2 Catlg using SQL completes (see also in parts 1 and 2). Other message has Setup and sample output.

---------------------------------------------------------------------- -- VIEWS - VIEW TEXT FROM SYSVIEWS ---------------------------------------------------------------------- SELECT TEXT80 AS TEXT ,LEVEL ,CREATOR ,NAME ,10 AS CLAUSENO ,LINENO FROM (SELECT SUBSTR(TEXT1 !! VALUE(SUBSTR(V.TEXT,1, CASE WHEN LENGTH(V.TEXT) >= PRIORLENREC2 THEN PRIORLENREC2 ELSE LENGTH(V.TEXT) END),'')!!' ' ,1,80) AS TEXT80 ,Y.NAME, Y.CREATOR, Y.LINENO ,LEVEL FROM ---------------------------------------------------------------------- -- THE FOLLOWING COMPLEX CODE REDISTRIBUTES VIEW [...] 15203 72 34_Re: Generate create tablespace DDL0_21_william.poston@DB.COM31_Tue, 26 Oct 1999 11:17:58 -0600713_us-ascii BMC Catalog Mamager will even generate DDL for dependent objects



---------------------------------------- Message History ----------------------------------------



From: Dhirendra.Chaudhary@wdr.com on 10/26/99 02:54 PM GMT

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: Subject: Re: Generate create tablespace DDL







Hi, Try BMC Catalog Manager. IT WORKS and is pretty simple to use.

Dhiren.



______________________________ Reply Separator _________________________________ Subject: Generate create tablespace DDL Author: Andy.G.Gravin (Andy_G_Gravin@CARADON.COM) at unix,mime Date: 26/10/99 15:51 [...] 15276 57 34_Re: Generate create tablespace DDL0_24_Ray.Price@DRESDNERKB.COM31_Tue, 26 Oct 1999 16:10:18 +0100564_- RC/Migrator from Platinum/CA.

Ray Price DBA Dresdner Kleinwort Benson London





-----Original Message----- From: Andy G Gravin [SMTP:Andy_G_Gravin@CARADON.COM] Sent: Tuesday, October 26, 1999 3:51 PM To: DB2-L@RYCI.COM Subject: Generate create tablespace DDL

Under DB2 for OS/390 ver 5.1, we have a need to reverse engineer our databases and generate the "create tablespace" and "create table" DDL. Does anyone know of software that will read the catalog tables and generate the "create tablespace" and "create table" DDL? [...] 15334 63 34_Re: Generate create tablespace DDL12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Tue, 26 Oct 1999 12:21:58 -0500745_us-ascii Here is what I use to extract the ddl, I also wrapped a program around this to create a formatted output:

1.) First the database, tablespaces and tables:

SELECT A.NAME, A.DBNAME, B.STORNAME, B.PQTY, B.SQTY, A.LOCKRULE, A.ERASERULE, A.CLOSERULE, A.BPOOL, A.SEGSIZE, B.FREEPAGE, B.PCTFREE, C.NAME, D.NAME, D.COLNO, D.COLTYPE, D.LENGTH, D.SCALE, D.NULLS, D.DEFAULT, D.DEFAULTVALUE FROM SYSIBM.SYSTABLESPACE A, SYSIBM.SYSTABLEPART B, SYSIBM.SYSTABLES C, SYSIBM.SYSCOLUMNS D WHERE A.CREATOR = :WS-CREATOR AND (A.NAME = B.TSNAME AND A.DBNAME = B.DBNAME) AND (A.NAME = C.TSNAME AND A.DBNAME = C.DBNAME AND A.CREATOR = C.CREATOR) AND (C.NAME = D.TBNAME) AND D.TBCREATOR = A.CREATOR ORDER BY A.DBNAME, A.NAME, C.NAME, D.COLNO [...] 15398 82 34_Re: Generate create tablespace DDL11_Hilton Tina15_HiltonT@TCE.COM31_Tue, 26 Oct 1999 12:35:09 -0500603_iso-8859-1 Manas,

What is DB2PLI8? I can't find any reference to it in the DB2 manuals.

Tina

-----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@PFSFHQ.COM] Sent: Tuesday, October 26, 1999 10:12 AM To: DB2-L@RYCI.COM Subject: Re: Generate create tablespace DDL



Andy:

And if your requirements aren't too complex you may be able to make do with DB2PLI8 program available for free from IBM. Use DDL or DDLONLY option to get your DDLs. I have recently started using it (since this shop doesn't have RC/Migrator) and so far had no problems. [...] 15481 62 48_DB2 udb v5.2 upgrade from v2.1 on OS/2 - NETBIOS9_Tim Czech22_Tim.A.Czech@DELUXE.COM31_Tue, 26 Oct 1999 12:48:38 -0500396_UTF-8 Hello everyone. I need your help. I have run into a problem when migrating a v 2.1 db to v 5.2 on OS/2. Some background: The actual migration is to a new (different) server with os2 warp version 3. The reason for this move is for Y2k purposes, so the application people want to keep all the software including OS the same. We insisted on migrating to a supported release of DB2. (5.2) [...] 15544 27 28_DB2 Connect EE on Windows NT11_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Tue, 26 Oct 1999 14:00:46 EDT516_us-ascii Hi,

We recently upgraded to DB2 Connect V6 (using V5.2 FP7 clients) on the server and have had very few problems. However, now that we are testing V6 clients, the server is getting Dr Watson's and has to be rebooted before the clients can access DB2. Has anyone else had this experience? We are currently running NT with service pack 3, so my first step will be to upgrade NT to at least service pack 4. Has anyone installed fixpack 1 for DB2 Connect? If so, what problems does this FP resolve? [...] 15572 13 34_Re: Generate create tablespace DDL0_25_Clint.Taylor@AUTOZONE.COM31_Tue, 26 Oct 1999 13:01:44 -0500349_us-ascii I tried to find it on the IBM internet site and could not find it. Where do I go to find DB2pli8??

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15586 47 33_fwd: DB2 Connect EE on Windows NT11_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Tue, 26 Oct 1999 14:05:50 EDT295_us-ascii One more thought.....how do you monitor the DB2 Connect server (in an automated fashion) to ensure that the clients can access DB2? When we get the Dr Watson, I can ping the server without any problem, but how do I know the path to the mainframe is always available?

TIA, R [...] 15634 142 34_Re: Generate create tablespace DDL14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 26 Oct 1999 14:12:38 -0400643_iso-8859-1 Tina:

DB2PLI8 is a PL/1 program available for download from IBMLINK. Following are the first few lines from the code itself:

//********************************************************************** //* * //* DB2PLI8 DB2 service aid to collect diagnostic information * //* * //* Generate UPDATE and INSERT SQL statements from the DB2 catalog * //* for statistics related to one or more DB2 tables. Optionally * //* collect VIEW and DDL information. * //* * //* This file is DB2PLI8 in DLL (RETAIN) (compile and linkedit). * //* Locally, this file is on the 17A disk. * //* * //* REFER to DB2PLI8L for the linkedit [...] 15777 86 17_Re: Auth Clean Up13_Chuck Hinchey22_chinchey@RJCONSULT.COM31_Tue, 26 Oct 1999 13:51:46 -0500478_iso-8859-1 Thanks Craig. We were already planning to use the install sysadm technique to clean up our individual sysadms (less than 10), but I was hoping for something a little less tedious for our views (several hundred).

Chuck Hinchey chinchey@rjconsult.com

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of craig patton Sent: Tuesday, October 26, 1999 10:31 AM To: DB2-L@RYCI.COM Subject: Re: Auth Clean Up [...] 15864 42 50_Re: REORG SHARELEVEL REFERENCE & SYSCOPY DDNAME !!12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 26 Oct 1999 21:16:45 +0200162_x-user-defined Hi, It was funny- I just like to twiddle around with all those options and many times you get something good and new and unexpected..

Thanks 15907 17 38_Re: Migrating UDB EEE 5.2 to 6.1 (AIX)0_25_Pierre.Evans@AUTOZONE.COM31_Tue, 26 Oct 1999 14:15:03 -0500349_us-ascii Thanks for the info, Steve. I suspected I wouldn't encounter a problem with the Control Center. Have you seen/heard of any problems with ADSM after the migration ? My offline tape backup failed on the nodes where 5.2 (production) coexists with 6.1 (test). It complained about not being able to bind the db2 shared library 'libadsm.a'. [...] 15925 52 26_Requests to mother IBM....14_Max 'Guderian'13_mocion@TIN.IT31_Tue, 26 Oct 1999 21:49:20 +0200406_iso-8859-1 Hello folks & dear collegues !

Does anyone knows how a poor men who work every day (since 1993) with DB2 can send any

request to mother IBM for any implementations/corrections ?

Horacio Terrizzano said that all customers can express suggestions, but he didn't said HOW !

For instance, I would like to have the possibility to avoid inline image copy during reorg [...] 15978 29 46_Creation of Field Procedure on Existing Column14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 26 Oct 1999 16:58:18 -0400522_us-ascii The Administration Guide says that you can't add a field procedure to an existing column. This rule makes sense in the general case because the data already on the database would have to be encoded. However, the field proc we want to add wouldn't change any of the data that's already there (it would only affect data to be added in the future). Does anyone know how to fool DB2 into using the field procedure without reloading all the tables, a process which would probably put us offline for about a week? [...] 16008 20 14_help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Tue, 26 Oct 1999 17:09:10 -0400460_iso-8859-1 I need help. I have to set up drda for testing & I don't have a lot of time. Are there any shortcuts I can take without reading entire db2 manuals? (I started to & my eyes are crossing already)

TIA Marg

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16029 22 5_ROWID10_Ravi Verma26_ravi.verma@TELECOMMAND.COM31_Tue, 26 Oct 1999 14:30:26 -0700454_us-ascii Dear Friends,

I need help in finding more information on ROWID in DB2 Version 6. Do you know which manual /chapter has information on ROWID.

Thanks a lot.

Regards.

Ravi Verma.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16052 87 15_Re: CRUD Matrix25_Robinson, Peter [IBM GSA]40_Peter.J.Robinson@CORPMAIL.TELSTRA.COM.AU31_Wed, 27 Oct 1999 06:54:51 +1000420_- Geoff

Try the plan table. You could probably use it rather than trying to parse the package statements or something.

PJR

Peter Robinson Senior Performance DBA Application & Production Support IBM-GSA Enterprise Services Brisbane, Australia

* BG07, PO Box 435, Brisbane 4001 > ' (07) 3887-8129 or 0418-400-959 > 7 (07) 3221-0173 > * peterobi@au1.ibm.com peter.j.robinson@telstra.com.au [...] 16140 16 29_Browser/GUI interface to CICS11_Craig Otway16_otwayc@TENET.EDU31_Tue, 26 Oct 1999 17:11:34 -0500487_UTF-8 I need to ask this question one last time. What middleware solutions do you know about that provide a browser interface with html and java options to CICS? We are looking at GT Software (Novation), Data21(IpServer) and SofTouch(Crossplex).

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16157 111 35_Re: consistency token --> timestamp14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Wed, 27 Oct 1999 08:53:40 +1000524_us-ascii Pillay, Did you really mean 'Curtsey: James Campbell'....is James perhaps short for something else ?

Sorry, Paul.

---------------------- Forwarded by Paul A Redhead/CorpServ/qdot/au on 27/10/99 08:54 ---------------------------



"Pillay, Venkat (PCA)" on 26/10/99 23:29:46

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Paul A Redhead/CorpServ/qdot/au) Subject: Re: consistency token --> timestamp [...] 16269 23 22_regarding DB2-ESTIMATE17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Tue, 26 Oct 1999 16:32:23 PDT588_- Hi Everybody,



How do i download db2-estimator from internet. does it helps in caluculating space, tuning performance?. What is the internet sit name to look into. somebody can help me in this.

thanks. ravi

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16293 31 25_DB2 UDB v5.2 on WindowsNT0_27_Bill_C._Burke@CEDONLINE.COM31_Tue, 26 Oct 1999 17:43:46 -0700632_us-ascii We are developing an application using DB2. We are not in production. Our databases are small by most standards (400- 500 meg) We recently upgraded to fix pack 10 on the platform noted above. Shortly after that upgrade we started receiving several Dr Watsons (WinNT error capture) each day. Due to development dead line considerations, we decided to "remove" the fixpack, restore and proceed. The only way to "remove" the fixpack is to reinstall. There were no issues with the reinstall. When attempting to re-create the databases from backup images made immediately before the reinstall we received the following SQL [...] 16325 20 52_Re: DB2 udb v5.2 upgrade from v2.1 on OS/2 - NETBIOS16_Turgut Kalfaoglu20_turgut@EGENET.COM.TR31_Wed, 27 Oct 1999 02:57:45 +0300529_US-ASCII you need to go into MPTS and configure those values that are giving you errors; such as , you need 200 or more sessions, etc. -turgut





----- Turgut Kalfaoglu, EgeNet Internet Services http://www.egenet.com.tr All of Turkey Online: http://find.egenet.com.tr

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16346 107 27_Re: data encryption program14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 27 Oct 1999 11:52:38 +1000524_us-ascii Many years ago, this is how I did this:

1) Generate a series of 64 random numbers in the range 1 - (2**64-1). Store in an array of 64 entries.

2) Given a user-id and password (I am presuming both are 8 bytes long) - XOR user-id and password together. (This means two users with the same password will generate different encrypted passwords). - take each bit of the result in turn. If bit is on, add equivalent entry from table of random numbers into result. - store result as encrypted password. [...] 16454 80 46_Re: ACF2 to RACF conversion - db2 dependencies11_Peter Broad20_mjs.pbb@SYMPATICO.CA31_Tue, 26 Oct 1999 22:57:31 -0400573_us-ascii All;

FYI there is a limit of 245 secondary authids per primary authid. This is current as of DB2 OS/390 V5 and I raised a question at the recent Toronto tech conference and there were no plans to increase the limit.

Peter

dcreed@CSC.COM wrote:

> We did several years ago. > > I honestly don't remember too much, but... The shop converted grew up with > acf2. We had implemented our > own code to handle secondary authid support prior to ACF2 providing it. So > during the conversion of > ACF2 rules to RACF, we can across a delima [...] 16535 55 35_Re: consistency token --> timestamp0_24_ssethi@LOT.TATASTEEL.COM31_Wed, 27 Oct 1999 08:59:57 +0530716_- For translating and comparing this consistency token i had seen in DB2 UPDATE from XEPHON , i do not remember in which edition .U can check out between Jan'98 to Aug.'98 editions.

Thanks

Sanjeev













J.P.Slot@RF.RABOBANK.NL on 10/27/99 01:40:04 AM

To: DB2-L@RYCI.COM cc: (bcc: SANJEEV SETHI/ITS - Tata Steel) Subject: consistency token --> timestamp







Hello DB2-L members, On behalf of a fellow DBA i'm sending this message to u. I hope u can provide him with an answer. I'm trying to write a program which compares the consistency token in a DBRM (example: 263EA7300F764388) with the token in the load [...] 16591 55 9_Re: ROWID0_24_ssethi@LOT.TATASTEEL.COM31_Wed, 27 Oct 1999 09:05:02 +0530570_- It is available in all the manuals of DB2V6 including What's New in V6. I am sending u the cuttings from What's New in V6 document which says ....................

Row IDs for direct access to data rows A new data type, ROWID, can give you the ability to re-access a row directly, without using the index or scanning the table. When an application selects a ROWID column from a table, the returned value can be saved in a host variable. Then you can use that value as the search condition of subsequent selects, deletes, or updates, which results in direct [...] 16647 106 26_Re: regarding DB2-ESTIMATE0_22_The-Thanh.Luong@AGF.BE31_Wed, 27 Oct 1999 13:24:55 +0200627_- Hi, Go to the site http://www6.software.ibm.com/dl/db2est/db2estm-p and download from there. Yes, DB2-Estimator helps us a lot.

The-Thanh LUONG AGF Belgium / ALLIANZ Group e-mail: The-Thanh.Luong@agf.be



-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Wednesday, October 27, 1999 1:32 AM To: DB2-L@RYCI.COM Subject: regarding DB2-ESTIMATE



Hi Everybody,



How do i download db2-estimator from internet. does it helps in caluculating space, tuning performance?. What is the internet sit name to look into. somebody can help me in this. [...] 16754 64 29_Re: DB2 UDB v5.2 on WindowsNT16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Wed, 27 Oct 1999 07:56:10 -0400541_us-ascii Bill,

You didn't mention what fixpak was applied at the time of the backup (I'm assuming fixpak10). To restore from the image, you should be at or above the level that the backup was taken under. One odd thing, is that the restore is seeing a codepage of 0 in the backup. To the best of my knowledge, there is no such code page. One reason for the SQLCODE you received, states that the backup could be corrupted. If that's the case, and you have no other way of restoring (such as a system backup), you may have to call [...] 16819 34 33_Re: Browser/GUI interface to CICS14_Sunit C. Patke19_patkes1@STATE.MI.US31_Wed, 27 Oct 1999 09:01:43 -0400526_US-ASCII For existing 3270 applications you can use Host On Demand from IBM.

If you are writing new programs, you can use CICS Transaction Server to write applications for Web environment.

HTH Sunit



>>> Craig Otway 10/26 6:11 PM >>> I need to ask this question one last time. What middleware solutions do you know about that provide a browser interface with html and java options to CICS? We are looking at GT Software (Novation), Data21(IpServer) and SofTouch(Crossplex). [...] 16854 32 18_Re: help with drda14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 27 Oct 1999 09:06:30 -0700454_us-ascii Marg, Can you be more specific on what you are trying to do? Phil

-----Original Message----- From: Marg Gozdowski [SMTP:marg.gozdowski@LA-Z-BOY.COM] Sent: Tuesday, October 26, 1999 2:09 PM To: DB2-L@RYCI.COM Subject: help with drda

I need help. I have to set up drda for testing & I don't have a lot of time. Are there any shortcuts I can take without reading entire db2 manuals? (I started to & my eyes are crossing already) [...] 16887 48 18_Re: help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Wed, 27 Oct 1999 09:24:02 -0400395_iso-8859-1 So far, my instructions are to get ready to set up drda - I don't have any specifics & I'm not sure what I need to do besides dsnzparm mod. I'm confused on what needs to be updated in db2 & racf.



-----Original Message----- From: Philip Gunning [mailto:pgunning@BOSCOVS.COM] Sent: Wednesday, October 27, 1999 12:07 PM To: DB2-L@RYCI.COM Subject: Re: help with drda [...] 16936 19 24_PeopleSoft Configuration13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Wed, 27 Oct 1999 08:28:01 -0500516_iso-8859-1 I have a question about the PeopleSoft setup for sites which use DB2 Connect EE. Do you use a dedicated server for DB2 Connect EE and one for the Tuxedo application server, or is it common to have both on the same box?

Thank you Glenn Mackey (515) 267 5767

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16956 132 35_Re: consistency token --> timestamp20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Oct 1999 09:32:57 -0400708_- Oops... Spell checker...

I meant "courtesy". Thanks to James Campbell..



> -----Original Message----- > From: Paul A Redhead [SMTP:Paul.A.Redhead@TRANSPORT.QLD.GOV.AU] > Sent: Tuesday, October 26, 1999 6:54 PM > To: DB2-L@RYCI.COM > Subject: Re: consistency token --> timestamp > > Pillay, > Did you really mean 'Curtsey: James Campbell'....is James perhaps > short > for something else ? > > Sorry, > Paul. > > ---------------------- Forwarded by Paul A Redhead/CorpServ/qdot/au on > 27/10/99 > 08:54 --------------------------- > > > "Pillay, Venkat (PCA)" on 26/10/99 23:29:46 > > Please respond to DB2 Data Base Discussion List > > To: [...] 17089 85 18_Re: help with drda12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 27 Oct 1999 06:37:01 PDT523_- Marg,

This sounds like setting up DDF between DB2 SSIDs. If this is the case, it is relatively simple. Check the INSTALLATION guide for DB2 and there is a section on implementing DDF. IT is a SHORT section and spells out exactly what you need to do. Basically, it is initializing the communication tables in the Catalog (V5). (In V4 the tables are not technically part of the catalog, but still need set up.) I believe there is only 1 parm that needs set in the Zparms (it's been awhile since I set this up). [...] 17175 47 28_Re: PeopleSoft Configuration12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 27 Oct 1999 06:39:44 PDT334_- Glenn,

I have found that the server is one of the performance bottlenecks with PeopleSoft (in DB2 for OS/390). While it is possible to run both on the same server, it seems to work best when you don't. If you can separate them, do so.

HTH Craig Patton DB2 DBA Working with PeopleSoft Implementations and Upgrades [...] 17223 36 28_Re: PeopleSoft Configuration14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 27 Oct 1999 09:45:31 -0700594_us-ascii Glenn, We have both on the same box. If the box is big enough you shouldn't have any problems. However, you need to take fail-over into consideration. We really have not. Phil

-----Original Message----- From: Mackey, Glenn [SMTP:GMackey@GUIDEMAIL.COM] Sent: Wednesday, October 27, 1999 6:28 AM To: DB2-L@RYCI.COM Subject: PeopleSoft Configuration

I have a question about the PeopleSoft setup for sites which use DB2 Connect EE. Do you use a dedicated server for DB2 Connect EE and one for the Tuxedo application server, or is it common to have both on the same box? [...] 17260 143 18_Re: help with drda19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Wed, 27 Oct 1999 15:48:58 +0200614_iso-8859-1 Do you have the DIST started task currently running,

//???DIST JOB MSGLEVEL=1 //STARTING EXEC USNDIST XX************************************************* XX* JCL PROCEDURE FOR THE STARTUP OF THE XX* DISTRIBUTED DATA FACILITY ADDRESS SPACE XX* XX************************************************* XXUSNDIST PROC RGN=0K, XX LIB='???PROD.SDSNEXIT' XXIEFPROC EXEC PGM=DSNYASCP,REGION=&RGN IEFC653I SUBSTITUTION JCL - PGM=DSNYASCP,REGION=0K XXSTEPLIB DD DISP=SHR,DSN=&LIB IEFC653I SUBSTITUTION JCL - DISP=SHR,DSN=???PROD.SDSNEXIT XX DD DISP=SHR,DSN=CEE.SCEERUN XX DD DISP=SHR,DSN=???PROD.SDSNLOAD [...] 17404 162 18_Re: help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Wed, 27 Oct 1999 10:13:42 -0400433_iso-8859-1 I do not have DIST running. Unable to find proc in my sdsnsamp lib. Do I have to go through the install again to create it? I will copy & mod the jcl below for testing, but, I would like to have my smpe files reflect current system.

-----Original Message----- From: Briggs, N. - Neil - [mailto:N.Briggs@CANON-EUROPA.COM] Sent: Wednesday, October 27, 1999 9:49 AM To: DB2-L@RYCI.COM Subject: Re: help with drda [...] 17567 16 34_Re: Generate create tablespace DDL14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM31_Wed, 27 Oct 1999 16:00:20 +0100393_us-ascii We are using BMC change manager to create all of our DDL on a daily basis. It works fine, no problems.

Tom Decabooter Honda Europe n.v.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17584 43 9_Re: ROWID14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Wed, 27 Oct 1999 09:47:13 -0500729_ISO-8859-1 Ravi:

There is a lot of good information on ROWID in the Release Planning Guide, as well as some information in the SQL Reference. Both of these manuals can be downloaded from the IBM web site:

http://www-4.ibm.com/software/data/db2/os390/v6books.html

Good luck, Craig S. Mullins Director of DB2 Technology Planning BMC Software http://www.bmc.com http://www.craigsmullins.com

-----Original Message----- >Date: Tue, 26 Oct 1999 14:30:26 -0700 >From: Ravi Verma >Subject: ROWID > >Dear Friends, > >I need help in finding more information on ROWID in DB2 Version 6. Do >you know which manual /chapter has information on ROWID. > >Thanks a lot. > >Regards. > [...] 17628 169 18_Re: help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Wed, 27 Oct 1999 11:08:20 -0400485_iso-8859-1 Please disregard last message listed below - I finally found the dist proc. Sorry for the confusion. I want to thank you & Craig for your help - I think I am on the right track, but, I might have more questions later on.



I do not have DIST running. Unable to find proc in my sdsnsamp lib. Do I have to go through the install again to create it? I will copy & mod the jcl below for testing, but, I would like to have my smpe files reflect current system. [...] 17798 131 27_Re: data encryption program15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Wed, 27 Oct 1999 10:17:13 -0500319_ISO-8859-1 James,

A very interesting way to generate a password.

I think you have one instruction wrong. At the instruction following LOOP1#B, don't you want to use a SLDL rather than a SRDL. Shift right always loads the high bit with zero which would mess up the LTR/BNM test on the next iteration. [...] 17930 41 5_ROWID14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 28 Oct 1999 02:04:14 +1000700_us-ascii Ravi,

For more info on ROWID see:

DB2 Admin Guide - performance chapters. DB2 V6 Performance Topics (Red Book) DB2 SQL Manual

From: Michael Hannan >From: Ravi Verma >Subject: ROWID >To: DB2-L@RYCI.COM > >Dear Friends, > >I need help in finding more information on ROWID in DB2 Version 6. Do >you know which manual /chapter has information on ROWID. > >Thanks a lot. > >Regards. > >Ravi Verma. > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. > > [...] 17972 59 29_Re: DB2 UDB v5.2 on WindowsNT10_Nash Gupta19_nashgupt@US.IBM.COM31_Wed, 27 Oct 1999 12:35:46 -0400694_us-ascii Try recreating an empty shell of the database using the ddl with the codepage same as that of that of the backup image and restore again..This should work...

- Nash

Bill_C._Burke@CEDONLINE.COM on 10/26/99 07:43:46 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: DB2 UDB v5.2 on WindowsNT







We are developing an application using DB2. We are not in production. Our databases are small by most standards (400- 500 meg) We recently upgraded to fix pack 10 on the platform noted above. Shortly after that upgrade we started receiving several Dr Watsons (WinNT error capture) [...] 18032 203 17_R: help with drda11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Wed, 27 Oct 1999 09:39:19 -0700734_- -----Original Message----- From: sanjay jain To: DB2 Data Base Discussion List Date: Wednesday, October 27, 1999 8:15 AM Subject: Re: Re: help with drda



>Marg, > >Job DSNTIJMV in SDSNSAMP, creates the started task JCL for all DB2 address >spaces including one for DDF (name would be something like 'DIST'). >It should have been added to one of your JES proclibs during >installation/migration of DB2. > >Sanjay Jain >Pro Sol Inc. > >-----Original Message----- >From: Marg Gozdowski >Newsgroups: bit.listserv.db2-l >To: DB2-L@RYCI.COM >Date: Wednesday, October 27, 1999 7:15 AM >Subject: Re: help with drda > > >>I [...] 18236 114 18_Re: help with drda11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Wed, 27 Oct 1999 09:40:01 -0700611_- >In addition you will have to add the DDF record in BSDS. Take a look at >utility DSNJU003 for doing this. DB2 has to be down if you are updating >BSDS. > >Sanjay Jain >Pro Sol Inc. > >-----Original Message----- >From: craig patton >Newsgroups: bit.listserv.db2-l >To: DB2-L@RYCI.COM >Date: Wednesday, October 27, 1999 6:39 AM >Subject: Re: help with drda > > >>Marg, >> >>This sounds like setting up DDF between DB2 SSIDs. If this is the case, it >>is relatively simple. Check the INSTALLATION guide for DB2 and there is a >>section on implementing DDF. IT is a [...] 18351 14 8_rowcount14_Jones, Peter J18_pjones2@LEHMAN.COM31_Wed, 27 Oct 1999 13:03:49 -0400336_- Is there a way of limiting the result set of an SQL statement Peter J. Jones Lehman Brothers

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18366 12 16_Recall: rowcount14_Jones, Peter J18_pjones2@LEHMAN.COM31_Wed, 27 Oct 1999 13:04:30 -0400304_- Jones, Peter J would like to recall the message, "rowcount".

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18379 24 8_Rowcount14_Jones, Peter J18_pjones2@LEHMAN.COM31_Wed, 27 Oct 1999 13:10:50 -0400325_- Sorry my last post contained an incomplete message: -

Is there a way to limiting the result set of an SQL statement?

We have a Java app that accesses both Sybase and DB2. Queries sent to the Sybase server have the size of the result set limited by issuing "set rowcount n" prior to the select statement. [...] 18404 39 12_Re: Rowcount11_Steve Mazer17_smazer@FMTUSA.COM31_Wed, 27 Oct 1999 13:16:27 -0400531_us-ascii Peter, I don't know of an easy way in OS/390 to do this. However, in DB2 UDB (Unix, NT, OS2) you can add the phrase 'fetch first n rows only' to the end of your query. Regards, Steve Mazer

At 01:10 PM 10/27/99 -0400, you wrote: >Sorry my last post contained an incomplete message: - > >Is there a way to limiting the result set of an SQL statement? > >We have a Java app that accesses both Sybase and DB2. Queries sent to the >Sybase server have the size of the result set limited by issuing "set >rowcount n" [...] 18444 107 30_RES: DB2 UDB v5.2 on WindowsNT17_Flavio Y. Togashi23_flaviot@SOFTPLAN.COM.BR31_Wed, 27 Oct 1999 15:24:57 -0300643_us-ascii Bill, You will have to apply the fixpak 10 again. This is causing the invalid codepage message .

Flavio





----- Mensagem original ----- De: Michael McCarthy [SMTP:Michael_McCarthy@DTC.ORG] Enviada em: Quarta-feira, 27 de Outubro de 1999 08:56 Para: DB2-L@RYCI.COM Assunto: Re: DB2 UDB v5.2 on WindowsNT

Bill,

You didn't mention what fixpak was applied at the time of the backup (I'm assuming fixpak10). To restore from the image, you should be at or above the level that the backup was taken under. One odd thing, is that the restore is seeing a codepage of 0 in the backup. To the best [...] 18552 46 28_Re: PeopleSoft Configuration11_Brown, Alan20_Alan_Brown@BCBST.COM31_Wed, 27 Oct 1999 13:21:33 -0400322_iso-8859-1 Glenn:

We have both on the same box. As long as your server has sufficient horsepower (CPU and memory), you shouldn't have any trouble. In addition, putting them on the same box eliminates a network hop and lets the Tuxedo services run in the DB2 Connect address space instead of using a DB2 agent. [...] 18599 44 12_Re: Rowcount0_20_ddlusk@HOUSEHOLD.COM31_Wed, 27 Oct 1999 12:20:15 -0500488_us-ascii if you are doing it online (os/390) using the DB2 interactive processor in your global defaults... you can set the limit on the number of rows returned..

the same for fileaid for db2... you can specify the number of rows that you want returned.



<>

P Peter, I don't know of an easy way in OS/390 to do this. However, in DB2 UDB (Unix, NT, OS2) you can add the phrase 'fetch first n rows only' to the end of your query. Regards, Steve Mazer [...] 18644 64 12_Re: Rowcount14_Jones, Peter J18_pjones2@LEHMAN.COM31_Wed, 27 Oct 1999 13:29:09 -0400520_- Thanks Steve,

Does anyone know if "fetch first n rows only" will be available for DB2 OS/390 version 6?

Peter J. Jones Lehman Brothers



-----Original Message----- From: Steve Mazer [SMTP:smazer@FMTUSA.COM] Sent: Wednesday, October 27, 1999 1:16 PM To: DB2-L@RYCI.COM Subject: Re: Rowcount

Peter, I don't know of an easy way in OS/390 to do this. However, in DB2 UDB (Unix, NT, OS2) you can add the phrase 'fetch first n rows only' to the end of your query. Regards, Steve Mazer [...] 18709 130 18_Re: help with drda14_Marg Gozdowski27_marg.gozdowski@LA-Z-BOY.COM31_Wed, 27 Oct 1999 13:59:39 -0400702_iso-8859-1 Thank you, Sanjay

-----Original Message----- From: sanjay jain [mailto:sanjay_jain@EMAIL.MSN.COM] Sent: Wednesday, October 27, 1999 12:40 PM To: DB2-L@RYCI.COM Subject: Re: help with drda



>In addition you will have to add the DDF record in BSDS. Take a look at >utility DSNJU003 for doing this. DB2 has to be down if you are updating >BSDS. > >Sanjay Jain >Pro Sol Inc. > >-----Original Message----- >From: craig patton >Newsgroups: bit.listserv.db2-l >To: DB2-L@RYCI.COM >Date: Wednesday, October 27, 1999 6:39 AM >Subject: Re: help with drda > > >>Marg, >> >>This sounds like setting up DDF between DB2 SSIDs. If this is [...] 18840 89 12_Re: Rowcount0_15_leon@CA.IBM.COM31_Wed, 27 Oct 1999 11:13:46 -0700395_us-ascii You can expect to see FETCH FIRST n ROWS in the upcoming release of the DB2 for OS/390, however, I can not tell you if it will be retrofitted into V6.1.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



"Jones, Peter J" on 10/27/99 10:29:09 AM

Please respond to DB2 Data Base Discussion List [...] 18930 75 29_Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Wed, 27 Oct 1999 14:29:33 -0500458_us-ascii Hi,

I'm completely stumped and had to ask this question. I recently added an index to a table in our ERP package (INDUS Passsport(c)) to improve performance for an on-line function. As is normal procedure I then rebound all plans/packages that access that table and performed further analysis to make sure that new access paths are at least as good as old paths. For several queries I found some startling results that I cannot explain: [...] 19006 26 30_DB2 Connect performance tuning14_James R. Brown25_brownjr@CI.RICHMOND.VA.US31_Wed, 27 Oct 1999 16:07:04 -0400568_iso-8859-1 Hi all,

I am trying to tweak better response time out of DB2 Connect to satisfy our user requirements. We currently route the request from a Win95 CAE to a WinNT SNA server via TCP/IP to DB2/MVS v4 via SNA gateway and VTAM. The initial connection response time, which includes the query, is consuming 6-8 seconds of clock time. Our DB2 monitor shows that only 2 seconds of this is used by the DB2 server. Each subsequent transaction takes about 3 seconds elapsed with 1 second in DB2. Does anyone have any ideas where I can start looking to try [...] 19033 100 12_Re: Rowcount14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 27 Oct 1999 16:31:49 -0400626_iso-8859-1 Peter:

I believe you should be able to do this in DB2 V6/OS 390 using an UDF....Look at the sample COUNTER() UDF.

SELECT bla bla bla from tbname where cond1.... and COUNTER() <= no._of_rows_desired



Thanks, Manas.



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jones, Peter J > Sent: Wednesday, October 27, 1999 1:29 PM > To: DB2-L@RYCI.COM > Subject: Re: Rowcount > > > Thanks Steve, > > Does anyone know if "fetch first n rows only" will be available for DB2 > OS/390 version 6? > > Peter J. Jones > Lehman [...] 19134 81 15_DB2 Table Locks16_Brian F. Patella25_patellab@WORLDNET.ATT.NET31_Wed, 27 Oct 1999 16:33:09 -0400508_iso-8859-1 I have a locking situation in DB2 V5.1 for OS/390. The users are executing dynamic queries from SQR programs from the client workstations using DB2 Connect V5.2 Personal Edition with TCP\IP connections.

When I analyzed some of these queries I was expecting to see page level locks since I defined the tablespace for testing purposes to locksize page and lockmax 0. For some reason these queries are acquiring table locks. Can this have something to do with the way the SQL is written? [...] 19216 38 54_LOGONLY Recovery after a SNAPSHOT restore for SAP data0_20_John_Lendman@FPL.COM31_Wed, 27 Oct 1999 16:41:52 -0400310_us-ascii I have been having a discussion about the way LOGONLY recovery works in DB2.

If we take a SNAPSHOT dump of DB2 data, which includes DB2 catalog and BSDS, at 4:00am Then process work until 2:00pm We then have a system failure We determine that we want to recover all the tables to current. [...] 19255 80 43_Re: UDB courseware? / Education Opportunity11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Wed, 27 Oct 1999 16:53:00 -0400529_iso-8859-1 Scott & DB2 UDB EE & EEE Education Seekers,

I have prepared a full day DB2 UDB EE & EEE Design for Performance course that will be offered publicly, for the first time, at the DB2 Symposium November 8th in NY/NJ.

In this session, I will discuss DBM & DB CFG parameters, sort and join optimizations, best practices for physical design of tablespaces, tables, and indexes, monitoring techniques, large database performance experiences and considerations, bufferpool optimization techniques, and more. [...] 19336 13 4_Test0_18_DB2DBAinTX@AOL.COM29_Wed, 27 Oct 1999 16:57:52 EDT255_us-ascii Test

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19350 66 58_Re: LOGONLY Recovery after a SNAPSHOT restore for SAP data11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Wed, 27 Oct 1999 14:17:40 -0700363_- John,

Your recovery (using log) is limited by the active and archive log RBAs listed in BSDS. So if you restore BSDS as of 4 am. You can not proceed beyond that. What you should do instead is leave the BSDS and system catalog/directory out of it and just SNAPBACK the tablespaces(I don't have first hand experience with SNAPSHOT) and do a LOGAPPLY. [...] 19417 41 39_Password Change on DB2 Connect EE/OS39011_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Wed, 27 Oct 1999 15:57:58 EDT418_us-ascii Hello,

I tried researching this topic in the archives and on the IBM we page, but the archives prior to about a month ago are still among the missing. I'm pretty sure this was covered in a previous post...but here goes anyway:

We have DB2 for OS390 V5 @ 9805, DB2 Connect V6.1 (server and client). When I try to change my password, using the CCA Password button, I get the following error: [...] 19459 13 34_Re: Generate create tablespace DDL0_18_DB2DBAinTX@AOL.COM29_Wed, 27 Oct 1999 17:27:29 EDT322_us-ascii I was unable to get DB2PLI8 from IBMLINK. How do you get it from there?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19473 65 43_Re: Password Change on DB2 Connect EE/OS39010_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Wed, 27 Oct 1999 14:33:54 -0700585_us-ascii You have to be running OS/2 on your workstation. This has not been implemented for Windows/NT. BW

The opinions or statements expressed herein are my own and should not be taken as a position, opinion, or endorsement of the University of California.

At 03:57 PM 10/27/99 -0400, Robert Hall wrote: >Hello, > >I tried researching this topic in the archives and on the IBM we page, but the >archives prior to about a month ago are still among the missing. I'm pretty >sure this was covered in a previous post...but here goes anyway: > >We have DB2 for OS390 V5 [...] 19539 119 33_Re: Strange access path selection20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 27 Oct 1999 18:05:47 -0400426_iso-8859-1 There are few details missing, which could shed more light on what actually happened. However I would point out few areas to look for.

1. V5 no longer looks at CARD/COLCARD/FIRSTKEYCARD/FULLKEYCARD but looks at CARDF/COLCARDF/FIRSTKEYCARDF/FULLKEYCARDF.

2. Some time DBAs are not aware of correct runstat syntax - Example: RUNSTAT TABLESPACE XXX.YY INDEX ALL does not populate column statistics. [...] 19659 102 15_Re: CRUD Matrix10_Leo Flores23_leoflores@EARTHLINK.NET31_Wed, 27 Oct 1999 15:55:42 -0700366_us-ascii John,

I'm a retired DBA and I remember using Platinum RC/Query to get this info also. Let's see if I can remember.

1) go to Packages. 2) go to Tables. Fill in the CollectionID/Package name or wildcard them. I believe this should do it. You may want to use the EXPANDED QUERY option to handle any sorting or other custom options you want. [...] 19762 152 27_Re: data encryption program14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Thu, 28 Oct 1999 10:06:48 +1000582_us-ascii Yep, SLDL is what I meant. Just call me "Dyslexic"!

James

-----Original Message----- From: Blaicher, Chris [mailto:Chris_Blaicher@BMC.COM] Sent: Thursday, October 28, 1999 1:17 AM To: DB2-L@RYCI.COM Subject: Re: data encryption program



James,

A very interesting way to generate a password.

I think you have one instruction wrong. At the instruction following LOOP1#B, don't you want to use a SLDL rather than a SRDL. Shift right always loads the high bit with zero which would mess up the LTR/BNM test on the next iteration. [...] 19915 93 43_Re: Password Change on DB2 Connect EE/OS3900_14_dcreed@CSC.COM31_Wed, 27 Oct 1999 19:09:07 -0500303_us-ascii You can change the password on the host , even if running on NT...if you have the zparm set up to do so. EXTSEC=YES, is the value you need.

I know this works... I did have to put on 1 ptf ...but it was fairly old. and you will see a logrec error for the failure if that is the case [...] 20009 93 12_Re: Rowcount16_Richard A Yevich15_ryevich@IBM.NET31_Wed, 27 Oct 1999 20:43:35 -0400326_iso-8859-1 It is coming in the near future...that is either in an update to OS/390 DB2 V6 or later...it is on the short list of new enhancements (since it is already on UDB UNOL). If you want a guess? Not V6 but perhaps later in a V[next]...and that is in the near future. Definition of near future? Sooner than later... [...] 20103 136 15_Re: CRUD Matrix14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Thu, 28 Oct 1999 11:10:31 +1000526_us-ascii John, If you look in SYSIBM.SYSTABAUTH every bound package will have an entry with it's name as the GRANTEE and GRANTEETYPE of 'P' and an appropriate flag 'Y' for SELECTAUTH, INSERTAUTH, UPDATEAUTH and DELETEAUTH. So for a particular package you could perform some selecting and sorting to get a CRUD matrix. I guess if you have a PLAN containing a list of (or all ) packages in a collection, then you could join from SYSPACKAGE to SYSTABAUTH and do some sorting....just trying to give you a straw to clutch at. [...] 20240 16 30_DIST Address Space SRB/TCB CPU30_GroupIT - Jenny Kuan Kong Lang19_jennykkl@MAS.COM.MY31_Thu, 28 Oct 1999 09:53:42 -0700370_us-ascii Hi, I have just extracted some statistics on DB2 Distributed Address Space and would appreciate if someone tcould offer

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 20257 29 35_DIST address space SRB/TCB CPU Time30_GroupIT - Jenny Kuan Kong Lang19_jennykkl@MAS.COM.MY31_Thu, 28 Oct 1999 10:05:03 -0700409_us-ascii Hi, I have just extracted some statistics on DB2 Distributed Address Space using Merill's MXG V16.16, and would appreciate if someone could explain what would contribute towards DIST CPU usage:

Task CPU SRB Time: 1:31:39 (hh:mm:ss) Task CPU TCB Time: 12:47:20 Preempt Clients CPU Time: 0:01:03 Enclave CPU Time: 12:44:42

We are in DB2 OS390 Version 4.1; DB2 Connect Version 5; 5.2 [...] 20287 29 59_Same database name in two different instances on one server24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Wed, 27 Oct 1999 21:37:41 -0700813_us-ascii Can the "subject" be done on DB2 UDB V6 for NT? If not, why not?

I think the answers are "No." and "Because of the system global directory." Is that right?

TIA, Frank

+-------------------------------------+--------------------------------------+ | Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 | | The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs | | Post Office Box 1421 | E-mail: fillmore@ws1.tfg-rdbms.com | | Ellicott City, Maryland 21041-1421 | URL: http://www.thefillmoregroup.com | | USA | | +-------------------------------------+--------------------------------------+ | DB2 Family, Oracle, Client/Server, Distributed Database | | "Relational Database Solutions"(sm) | +----------------------------------------------------------------------------+ [...] 20317 91 33_Re: Strange access path selection0_24_ssethi@LOT.TATASTEEL.COM31_Thu, 28 Oct 1999 09:35:10 +0530451_- Hi Michael Levine, Could u please tell me that which is newly added index and cluster ratio of the indexes. I am also bit surprised to find this access path and its once again making me think that Optimizer is too smart.

Thanks

Sanjeev









Mike_Levine@TEKHELP.NET on 10/27/99 07:33:59 PM

To: DB2-L@RYCI.COM cc: (bcc: SANJEEV SETHI/ITS - Tata Steel) Subject: Strange access path selection [...] 20409 39 33_Re: Browser/GUI interface to CICS0_17_JTonchick@AOL.COM29_Thu, 28 Oct 1999 00:42:35 EDT351_us-ascii In a message dated 10/26/99 5:12:12 PM Central Daylight Time, otwayc@TENET.EDU writes:

<< I need to ask this question one last time. What middleware solutions do you know about that provide a browser interface with HTML and Java options to CICS? We are looking at GT Software (Novation), Data21(IpServer) and SofTouch(Crossplex). [...] 20449 18 24_Net.data Programing Book17_suthep thampranee18_suthepth@SCB.CO.TH31_Thu, 28 Oct 1999 11:54:58 +0100402_Windows-874 Hi all, I want to buy Net.data Programing Book but I couldn't find it.Does anyone has an suggestion?(Because IBM only has few documents.) Thanks JOE

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 20468 112 57_Re: LOGONLY Recovery after a SNAPSHOT restore for SAP dat22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 28 Oct 1999 06:22:53 +0100419_ISO-8859-1 Sanjay/John I agree with both of you .. my shop has only just started to think about snaps a possible recovery option .. but due to excessive amounts of UCBs required I think we will stick with a hot standby site as our short term recovery option and then standard DR if the hot standby is dead aswell. (we do have the X82 upgrade with 1024 UCBs per RVA but we still don't think we will go this route). [...] 20581 43 28_Re: Net.data Programing Book0_24_ssethi@LOT.TATASTEEL.COM31_Thu, 28 Oct 1999 11:22:31 +0530797_- Go to Web Site www.software.ibm.com\data\net.data and then go to library section.

I have downloaded from there only .U can download for NT,UNIX and OS390 as well.

Thanks

Sanjeev







suthepth@SCB.CO.TH on 10/28/99 06:28:51 AM

To: DB2-L@RYCI.COM cc: (bcc: SANJEEV SETHI/ITS - Tata Steel) Subject: Net.data Programing Book







Hi all, I want to buy Net.data Programing Book but I couldn't find it.Does anyone has an suggestion?(Because IBM only has few documents.) Thanks JOE ================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 20625 40 28_Re: Net.data Programing Book22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 28 Oct 1999 07:13:17 +0100493_ISO-8859-1 Have you tried AMAZON.COM ?

If I remember correctly there are a few whitepapers on the IBM web site? - I am sure that when I worked with it a year ago I used a white paper of something similar to configure and play with it ..

Leslie Pendlebury-Bowe



______________________________ Reply Separator _________________________________ Subject: Net.data Programming Book Author: suthep thampranee at Internet Date: 10/28/99 11:54 AM [...] 20666 26 24_Net.data Programing Book17_suthep thampranee18_suthepth@SCB.CO.TH31_Thu, 28 Oct 1999 13:52:10 +0100634_Windows-874 Thanks for your help( Sanjeev and Leslie). Anyway I already get Net.data documents from www.software.ibm.com and I already tried to search on www.amazon.com. My users(programmers) are not pleased to use Net.data. They give some reasons about it; 1.Very difficult to develop. 2.Not easy to use. 3.No more documents and more examples(They already get some documents that I download from www.software.ibm.com but they say that not enough). 4.Nobody can help or suggest them how to solve the problems.(Only one on two from IBM but they're always busy) etc. Then they really want to walk away from Net.data and try to use [...] 20693 20 28_Fonts on GUI for DB2 V6.1 NT7_sompong17_sompong@SCB.CO.TH31_Thu, 28 Oct 1999 13:58:41 +0700307_Windows-874 Hello,

After installation of DB2 version 6.1 on my NT server ver. V.4 service pack 4 (Thai Edition) with full options; I found that the new GUI which has been rewritten which Java come up with very small fonts.

Please guide me how to make these fonts to be bigger. Thank you. [...] 20714 47 19_Re: DB2 Table Locks12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 28 Oct 1999 04:42:34 PDT676_- Brian,

What kind of table locks are being used? CAn you EXPLAIN the SQL and send it to the list?

Craig Patton DB2 DBA Specializing in PeopleSoft implementations and upgrades.



>From: "Brian F. Patella" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 Table Locks >Date: Wed, 27 Oct 1999 16:33:09 -0400 > >I have a locking situation in DB2 V5.1 for OS/390. The users are executing >dynamic queries from SQR programs from the client workstations using DB2 >Connect V5.2 Personal Edition with TCP\IP connections. > >When I analyzed some of these queries I was expecting to [...] 20762 57 28_Re: Net.data Programing Book18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Thu, 28 Oct 1999 07:07:34 -0500655_Windows-874 Suthep, You haven't mentioned IBM Redbooks. There are many published on Net.Data. If you haven't seen them, go to the following website and search on "Net.Data": http://www-4.ibm.com/software/data/db2/os390/moreread.html HTH, Rick Davis Technical Architect SWBT One Bell Center St. Louis, MO 63101 "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender [...] 20820 109 33_Re: Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 08:12:56 -0500630_us-ascii Hi,

Cluster ratios for both indexes is 81% and neither are clustering indexes.

Thanks, Michael Levine Premier Data Services, Inc.





>Hi Michael Levine, > Could u please tell me that which is newly added index and cluster >ratio of the indexes. >I am also bit surprised to find this access path and its once again making >me think that Optimizer is too smart. > >Thanks > >Sanjeev > > > > > >Mike_Levine@TEKHELP.NET on 10/27/99 07:33:59 PM > >To: DB2-L@RYCI.COM >cc: (bcc: SANJEEV SETHI/ITS - Tata Steel) >Subject: Strange access path selection > > > > >Hi, >I'm completely stumped [...] 20930 46 19_Re: DB2 Table Locks18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM31_Thu, 28 Oct 1999 07:25:55 -0500624_iso-8859-1 Brian, is it possible the code is issuing a LOCK TABLE statement? HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 20977 138 33_Re: Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 08:26:46 -0500441_us-ascii Hi Pillay,

The only difference in SYSINDEXES is TI1CAFAC has a PIECESIZE value of 0 and TI4CAFAC has a value of 2097152. FIRSTKEYCARDF and FULLKEYCARDF are identical at 3.869300E+05 and 5.14495E+05. Runstats was performed after the reorg as follows:

RUNSTATS TABLESPACE xxxxxx.TISCAFAC TABLE(xxxxxx.TIDCAFAC) INDEX(ALL) COLUMN(ALL) SHRLEVEL CHANGE

Thanks,

Michael Levine Premier Data Services, Inc. [...] 21116 44 26_Maintenance of Code tables10_Neil Paton27_neil_paton@STANDARDLIFE.COM31_Thu, 28 Oct 1999 13:21:12 +0100576_iso-8859-1 A first post for me.

You know the kind of table - often a handful of rows with a code, description, userid and timestamp. The users say there might be a change once in a blue moon - then changes start coming through every couple of months. Traditionally the DBA area has applied changes using SQL but they're getting a bit fed-up and are asking for a maintenance process be delivered with the application. I favour allowing users to change the data using a 3rd party tool such as RC/Update or Fileaid-DB2. Any maintenance process is likely to be pretty [...] 21161 82 30_Re: Maintenance of Code tables11_Mark Ediger15_mediger@CME.COM31_Thu, 28 Oct 1999 07:59:54 -0500568_us-ascii Neil,

We do allow the use of RC/Update to update production parameter and code tables that do not have maintenance screens. But we have a lot of conditions. The updates can only be made with an "Emergency Userid" which is kept by production control and turned over to the programmer or user when requested and when they have an authorized emergency change request. (We consider dynamic changes to production tables equivalent to any other production change, requiring a change request). The userid is audited. The DBAs never have to get involved. [...] 21244 156 33_Re: Strange access path selection10_Mann, Tony19_tmann@UTILICORP.COM31_Thu, 28 Oct 1999 08:04:04 -0500537_ISO-8859-1 Mike:

With the old access and 3 matchcols DB2 had to walk through the index hitting (not fully clustered at 81%) several pages: then individual I/Os (worst case) to the data pages.

With the new access, DB2 pulls one index page to find a single key entry followed by a string of RIDs. Fullkey/Firstkey = 514495/386930 = 1.3 on average. -- not tooo long a list, so the RID sort can't be much of a problem. DB2 then hits the data page(s) using list prefetch - a single chained I/O call, if I remember rightly. [...] 21401 177 33_Re: Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 09:20:05 -0500323_us-ascii Hi Tony,

Good analysis! What especially threw me was the move away from indexonly access and switch to list prefetch. I thought it would always be preferable not to have to touch the data pages. I guess that due to the relative high card of the first key performance shouldn't be too bad in this case. [...] 21579 54 39_Re: DIST address space SRB/TCB CPU Time10_Mann, Tony19_tmann@UTILICORP.COM31_Thu, 28 Oct 1999 08:20:38 -0500290_- Jenny, that CPU is mostly your client thread activity (queries, PC applications etc).

DB2 usually bills CPU back to the user job, but cannot do that with DIST because the users don't have a presence on OS/390 itself. So DIST gets billed with all the CPU used by the user SQL. [...] 21634 12 3_QMF17_Janice L. Manners19_MANNEJL@THIOKOL.COM31_Thu, 28 Oct 1999 07:24:55 -0600378_- I just got off the phone with IBM Direct - they claim QMF for VM and QMF for Windows are no charge features of DB2 6.1. This for real?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 21647 222 33_Re: Strange access path selection20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 28 Oct 1999 09:35:41 -0400383_iso-8859-1 Mike

The index only is only for the WHERE clause but it has to go to data page to update the two column values hence the data pages have to be retrieved. As Tony said doing a sync I/O to retrieve datapage is not wise especially if data pages are sparsely distributed. List Prefetch can read up to span of 150 pages and retrieve up to 32 data pages in one I/O. [...] 21870 39 7_Re: QMF24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 28 Oct 1999 08:34:29 -0700534_us-ascii Janice, Just order it and find out...

Regards, Frank



On Thu, 28 Oct 1999 07:24:55 -0600, Janice L. Manners wrote:

>I just got off the phone with IBM Direct - they claim QMF for VM and >QMF for Windows are no charge features of DB2 6.1. >This for real? > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. [...] 21910 34 38_Removing a DB2 V2.1 Instance from AIX?0_15_sokeefe@VCU.EDU31_Thu, 28 Oct 1999 08:31:59 -0400451_us-ascii Esteemed List Members:

I have upgraded to UDB/EE (V5.2) for AIX, and I now need to remove the old V2.1.2 DB2 instance. Although I have actual hard copy manuals for V2.1, I can not find a reference to REMOVING an instance, just creating one. When I go to IBM on the WEB, and select DB2/Common Servers I get UDB documentation. Can someone on the list provide the command/syntax for removing an instance under V2.1.2 on AIX? Thanks, [...] 21945 242 33_Re: Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 10:01:05 -0500613_us-ascii Thanks Pillay,

One last question/comment that comes to mind. I can see how list prefetch might out perform the old path but why wouldn't DB2 choose the same technique on the smaller of the two indexes (TI1CAFAC)?

Regards,

Michael Levine Premier Data Services, Inc.





>Mike > > The index only is only for the WHERE clause but it has to go to data >page to update the two column values hence the data pages have to be >retrieved. As Tony said doing a sync I/O to retrieve datapage is not wise >especially if data pages are sparsely distributed. List Prefetch [...] 22188 95 30_Re: Maintenance of Code tables0_22_BILL_GALLAGHER@PHL.COM31_Thu, 28 Oct 1999 10:08:04 -0400379_us-ascii Neil,

Our #1 rule in the Database Administration team in my shop is "We don't do data". Responsibility for loading and maintaining code tables, as well as any other application tables, belong entirely to the I.S. team that supports the application in question. We (the DBA's) have removed ourselves entirely from the process, and refuse to be drawn back in. [...] 22284 300 33_Re: Strange access path selection20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 28 Oct 1999 10:12:57 -0400361_iso-8859-1 Mike

That puzzles me too. I guess Frank Ingrassia or Michael hannan could answer that well. I have seen many of this out of way accesses but all of them had some of the reasons below

- Data type not matching (or stage 2 variables introduced) - xxcardf values were -1 (Some one updated card but forgot cardf) - nlevel = 2 etc. etc. [...] 22585 59 42_Re: Removing a DB2 V2.1 Instance from AIX?12_Janet Rolsma12_janet@NM.NET31_Thu, 28 Oct 1999 08:14:42 -0600268_us-ascii Look for a file called db2idrop. This is a script that will drop an instance. It should be in the same place as the db2icrt script. I don't remember the exact syntax, but if you try running it with -h it should give you the proper syntax.

Janet

22645 60 25_Parallelism (When or Not)0_24_ssethi@LOT.TATASTEEL.COM31_Thu, 28 Oct 1999 20:00:59 +0530578_- I am resending this message presuming nobody received it as i didn't get any reply as of now .

Hi All, I was told by some of the senior people in our place that Parallelism (I/O,CPU or Sysplex) will be in effect only in the partitioned tablespaces but i am unable to agree on this point.As i have read in either Developer's Guide ,Admin Guide or any other article or FAQ's that Parallelism(I/O and CPU) can be in affect in non-partitioned tablespaces as well but it will be most efficient in Partitioned tablespaces.I was quite satisfied with Developer's Guide in [...] 22706 124 30_Re: Maintenance of Code tables0_28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 28 Oct 1999 16:29:32 +0100588_us-ascii I totally agree with Bill; we - the DBAs - don't do data either - well, in some way we do since altering tables e.g. sometimes involves unloading and reloading data, but apart from this we are not allowed direct access to our production data; We allow application designers to write their own sql since they have to accept full responsibilty if anything goes wrong; the designers, however, mustn't use SPUFI or DSNTEP1, they may give the SQL into the hands of a member our data-group that consequently runs the SQL without accepting responibilty for the quality of the SQL. [...] 22831 20 33_BP Hit Percentage(Negative Value)0_24_ssethi@LOT.TATASTEEL.COM31_Thu, 28 Oct 1999 20:02:00 +0530329_- Hi All, What are the condition under which BP Hit %age will be negative ?. I have heard that if pages are read in but not GETPAGED then it will be negative ,this is o.k ,but except in case of Sequential Detection will this condition arise in any other case ,infact will it arise in case of sequential detection as well ?. [...] 22852 19 21_DB2/OS390 compression14_Gary Bernhardt18_GBernhardt@CSI.COM31_Thu, 28 Oct 1999 09:43:19 -0500543_ISO-8859-1 Has anyone measured the CPU overhead that comes with compression. I am sure that YMMV, but am looking for ROT or user experiences.

Also, does the CPU time used to drive compression get charged back to the thread? I am only concerned with hardware compression in DB2 OS/390. TIA, Gary

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 22872 49 37_Re: BP Hit Percentage(Negative Value)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 28 Oct 1999 10:48:45 -0400474_- Sanjeev

This mostly happen when you have segmented tablespace. Either Dynamic prefetch or Sequential prefetch brings more pages than actual getpages.

Segmented tablespace having zero pages (performatted by db2 but having no header info) does not do issue getpages neither mass deleted pages or free pages (as seen from the spacemap). But sequential prefetch is blind and all the pages brought by I/O are loaded to bufferpool though not having getpages. [...] 22922 120 57_Re: LOGONLY Recovery after a SNAPSHOT restore for SAP dat14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 28 Oct 1999 10:58:09 -0400609_us-ascii Hi John, (list)

There is a Red book covering this topic its title is "Using RVA and SnapShot for Business Intelligence Applications with OS/390 and DB2" - SG24-5333-00. It is available on the Web at WWW.REDBOOKS.IBM.COM.

Good Reading !

Bill G.



Leslie Pendlebury-Bowe wrote:

> Sanjay/John > I agree with both of you .. my shop has only just started to think > about snaps a possible recovery option .. but due to excessive amounts > of UCBs required I think we will stick with a hot standby site as our > short term recovery option and then standard DR [...] 23043 21 37_Reply- DB2 Connect performance tuning12_Jason Hughes20_Jason.Hughes@TRW.COM31_Thu, 28 Oct 1999 07:59:45 -0700571_US-ASCII For some good information on ODBC tuning, go to the DB2 Product and Technical Service Library at http://www-4.ibm.com/software/data/db2/library/

Go into the DB2 Universal Database library and check out the Connectivity Technotes. You will finds tips to speed up the initial connection and other issues.

Jason

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23065 41 25_Re: DB2/OS390 compression20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 28 Oct 1999 11:10:43 -0400445_- Bob Omerza of UPS had a detailed presentation in IDUG last year on compression and they have CPU gain due to reduced getpages and less I/O. I remember he was telling 3% overhead on DBM1 address space.

I was wondering why should there be overhead (hardware compression in effect) ? Prefetch I/O, Log I/o are all reduced and they mainly attributed to system address space CPU so I would expect no increase (if not reduction in cpu). [...] 23107 66 25_Re: DB2/OS390 compression13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 28 Oct 1999 10:18:12 -0500402_iso-8859-1 I understand the term to be more like "hardware assisted compression", so I assume there is still some software driving the compression/decompression routine ... hence some overhead in CPU.

I did not see the presentation, but perhaps he was saying that the compression routine had a 3% overhead in his investigation, but overall the CPU came down due to the reasons you mention. [...] 23174 90 25_Re: DB2/OS390 compression0_22_BILL_GALLAGHER@PHL.COM31_Thu, 28 Oct 1999 11:24:15 -0400629_us-ascii YMMV = "your milage may vary" (?)









"Mackey, Glenn" on 10/28/99 11:18:12 AM

Please respond to DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance) bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance Subject: Re: DB2/OS390 compression







I understand the term to be more like "hardware assisted compression", so I assume there is still some software driving the compression/decompression routine ... hence some overhead in CPU. [...] 23265 68 19_Re: DB2 Table Locks16_Brian F. Patella25_patellab@WORLDNET.ATT.NET31_Thu, 28 Oct 1999 11:30:24 -0400421_iso-8859-1 The SQL is not using the LOCK TABLE statement.

According to Boole and Babbage the tablespace level lock is PSET ISHR it also has a TABL ISHR. I was expecting to see DPAG ISHR.



-----Original Message----- From: craig patton Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Thursday, October 28, 1999 7:42 AM Subject: Re: DB2 Table Locks [...] 23334 35 21_I/O ERROR DURING READ12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 28 Oct 1999 08:38:53 PDT320_- Hi folks:

I'm getting a lot of I/O error as you can see below with tablespaces and indexspaces and I don't know what is the reason that is ocasioning this problem. I know how fix it but if anyone has experienced the same problem I would like to heard about and what are I've got to do to avoid this error. [...] 23370 85 29_Re: Parallelism (When or Not)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 28 Oct 1999 11:46:14 -0400613_- Not untill V6, prior to that atleast one table involved in the query should be partitioned to utilize parallelism.

Thats my understanding -Pillay

> -----Original Message----- > From: ssethi@LOT.TATASTEEL.COM [SMTP:ssethi@LOT.TATASTEEL.COM] > Sent: Thursday, October 28, 1999 10:31 AM > To: DB2-L@RYCI.COM > Subject: Parallelism (When or Not) > > I am resending this message presuming nobody received it as i didn't get > any reply as of now . > > Hi All, > I was told by some of the senior people in our place that Parallelism > (I/O,CPU or Sysplex) will be in effect only in the partitioned [...] 23456 66 34_Re: DB2 Connect performance tuning14_Steven Camitta30_steven.camitta@INGRAMMICRO.COM31_Thu, 28 Oct 1999 08:46:49 -0700508_iso-8859-1 James,

Our configuration is similar. My perspective is as follows:

6 - 8 seconds for a connection is not unreasonable if you do it only once per "user session". The 3 second transaction is where you can see a major improvement if you focus on stored procedures. These will help you big time. DB2 V4 SPs are weak so try to move to V5 ASAP. For read only work you can set the SP up with "commit on return" so that you can make a single round trip from the Connect gateway to DB2. [...] 23523 45 25_Re: DB2/OS390 compression22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 28 Oct 1999 16:47:42 +0100505_ISO-8859-1 Gary

we have a fair few pagesets compressed here and have not seen huge CPU overhead as a result .. given time I could get you some figures. We are performance tuning our Virtual Pools with the Bufferpool Tool and are infact finding better performance as compression is giving us more rows per page and therefore in a lot of cases more rows are being found in the bufferpool when read .. which saves us a fortune in cycles when or if the page should have been bought in from DASD . [...] 23569 29 33_DB2 OS/390 Utility Test: V5 vs V623_Lee, Kenneth (Exchange)14_kmlee@BEAR.COM31_Thu, 28 Oct 1999 11:59:10 -0400413_- According to IBM, V6 utilities should be much faster than those of V5. In fact, one instructor at the DB2 conference in New Orleans claimed that it is upto 10 times better. Well, I did some benchmark testing of Load, Image Copy, Reorg, Unload and Recover and found NO significant improvement of any utility. Some are even slower. Is there someone out there who have experienced that I(or IBM) was wrong??? [...] 23599 142 25_Re: DB2/OS390 compression0_18_mebert@AMADEUS.NET31_Thu, 28 Oct 1999 18:08:22 +0100489_us-ascii Unless I got something wrong, it's like this: IBM Machine language has special instructions for compression/decompression. You can install additional hardware for those. If you don't do this, the instruction gets trapped and emulated in software. It's the same as for decimal number or string support. This instruction uses CPU time like any other. This CPU time gets billed to the thread using DB2, not the DB2 spaces (DB2 doesn't care about data, it just moves it around). [...] 23742 21 34_Data Replication on DB2/6000 (AIX)10_Nash Gupta19_nashgupt@US.IBM.COM31_Thu, 28 Oct 1999 12:21:00 -0400538_us-ascii Hello List!

I need to replicate data from one DB2/AIX box to another DB2/AIX box (v5.2). Have no experience with DB2 replication features. Can somebody please recommend whatz the best way to start?? Redbooks, papers, guides etc..etc....

Help is appreciated...

- Nash

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23764 32 25_Re: DB2/OS390 compression10_Ken Koleto23_kkoleto@PAINEWEBBER.COM31_Thu, 28 Oct 1999 12:23:47 -0400508_us-ascii In the course of our original investigation the worst increase (~3%) came from "SELECT * FROM" which is what we all tell everybody not to do anyway .

The increase is from the fact that although we call it hardware compression there is still a software "COMPRESS" instruction and the reverse. The hardware process started by the software instruction, like all other instructions, takes some amount of CPU cycles. How often it gets used (or not) is a factor in the CPU time of the job. [...] 23797 18 0_15_Narasim Narayan24_Narasim_Narayan@GLIC.COM31_Thu, 28 Oct 1999 12:15:37 -0400312_us-ascii Hi I am getting a resource unavailable message and the sqlerrd(4) has a value which the manual describes as containing timerons and would indicate a rough estimate of resources required . Can you direct me to where I can get more information on this and how to translate the info given TIA Narasim [...] 23816 79 42_Re: Removing a DB2 V2.1 Instance from AIX?13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Thu, 28 Oct 1999 11:27:13 CDT404_- To drop the instance ... 1)Force application all 2)Drop all the local databases *** Doing a backup of the databases before dropping them would be a better. 3)db2stop 4)db2 terminate 5)run the command: /usr/lpp/db2_02_01/instance/db2idrop

Instructions can also be found in DB2 Quick Beginnings Guide.

Link to V2 Docs is http://www-4.ibm.com/software/data/db2/library/ [...] 23896 122 43_Re: Password Change on DB2 Connect EE/OS39011_Robert Hall25_robert.hall@OCC.TREAS.GOV29_Thu, 28 Oct 1999 12:22:17 EDT452_us-ascii Hi Danny,

Do you remember the ptf that you had to apply? My system's programmer searched IBM link and we can't seem to find it. We changed EXTSEC to yes and we are still having problems.

( TMON still shows the zparm as extsec=N, but I think that is just a problem with TMON since the assembly date on the zparm module (as reported by TMON) is today and the assembly job shows extsec =yes and is going to the correctly pds.) [...] 24019 68 63_Re: Same database name in two different instances on one server13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Thu, 28 Oct 1999 11:34:38 CDT462_- Yup cannot be done because of global directory. You can create/catalog databases having same name separated by an alias. But dbname and alias name for a database cannot be duplicated on the same instance.

regards, Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...] 24088 19 18_bind-package error15_Raghu Tarigonda29_rtarigo@NOTES.MNET.USWEST.COM31_Thu, 28 Oct 1999 10:48:15 -0600428_us-ascii Hai

I am getting a sql error -805 (80N) when binding a package.Share your expertise if any body has got the same error.I would appreciate your help.

Thanks. Raghu.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 24108 35 25_Re: DB2/OS390 compression0_31_truman.g.brown@BELLATLANTIC.COM31_Thu, 28 Oct 1999 13:04:41 -0400437_us-ascii Dr. Ebert makes many valid points (as usual). The compression topic has been discussed often and vociferously. My own experience is that like almost everything else in DB2, "it depends".

In the late '80s I worked for a company that used compression via 3rd party software and edit procs. That method was crude, but end-to-end performance (key word - PERFORMANCE) was better, which was all that mattered to the user. [...] 24144 153 15_Re: CRUD Matrix13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Thu, 28 Oct 1999 11:56:27 -0500443_us-ascii Compuware's DBA-Xpert has a facility that creates a table called DBCOLIMPACT. This table can then be accessed within the product to give you this information. However, I have just given the programmer access to read this table directly in QMF and they can get this information whenever they need it. I didn't realize how much they used it, until we were changing releases of DBA-Xpert one time and it wasn't initially available. [...] 24298 178 33_Re: Strange access path selection11_Kwan, James18_James_Kwan@BMC.COM31_Thu, 28 Oct 1999 12:16:36 -0500327_ISO-8859-1 Tony,

I am assuming your analysis is correct. Would the optimizer still choose first index since it has same first col and has less leaf pages? If on average there will be only 1.1/1.3 record returned, it should still be faster to use 3 matching cols than with a list prefetch unless the data is skewed. [...] 24477 55 38_Re: Data Replication on DB2/6000 (AIX)10_Marc Baime23_mbaime1@TAMPABAY.RR.COM31_Thu, 28 Oct 1999 13:30:08 -0400450_iso-8859-1 I recommend the following: The DB2 Replication Certification Guideby Jonathan Cook, Robert Harbus 432 pages 1 edition (April 15, 1999) Prentice Hall; ISBN: 0130824240

I used this book to study and pass the Replication Certification exam and it was helpful as a reference in implementing my current AIX to AIX user copy replication setup. You can probably pick it up at Borders or Barnes & Noble. If not Amazon has it for sure. [...] 24533 16 30_DB2 Connect performance tuning0_39_brian_holroyd.consultant@PEOPLESOFT.COM31_Thu, 28 Oct 1999 10:11:51 -0700297_us-ascii The best material I've seen on this is from Hugh Smith of IBM Santa Teresa Labs entitled "DB2 Network Computing Tuning - Tips and recommendations". Its a presentation he has given at the last IDUG and DB2 Tech Conferences. Suggest you track down someone who attended. Its on the CD. [...] 24550 199 33_Re: Strange access path selection0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 13:54:40 -0500302_us-ascii Hi,

The cardinality of Q_LEVEL is only four and COMPANY is only nine and is also skewed. This would explain why a matchcol 1 is almost as good as a matchcol 3. The previous access path was chosen before I had done the full column RUNSTATS so now DB2 is too smart for his own good! [...] 24750 39 22_Re: bind-package error0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 14:03:14 -0500354_us-ascii Hi,

Are you sure you are getting this error when BINDing or when actually running the program? Typically a -805 is a timestamp mismatch error for a package meaning that the program load module being executed does not match up with the DBRM that produced the package.

Regards,

Michael Levine Premier Data Services, Inc. [...] 24790 72 25_Re: DB2/OS390 compression12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 28 Oct 1999 11:03:12 PDT554_- Hi Gary:

I want say something, is just my point of view about my own experience with db2 compression. We've got a lot a tables that has more than 50 millions records on each one and we were lucky because we start to use db2 data compression and the majority of the data are string of character , for that reason the compression of data worked more eficiently reaching about 80% of data compressed. It help us to reduce huge amount of dasd required for tablespaces and reduce huge amount of I/O required to read the tablespaces and it ins't [...] 24863 18 26_Re: Day Light Savings Time0_21_william.poston@DB.COM31_Thu, 28 Oct 1999 13:03:22 -0600464_us-ascii What step, or preventions are shops taking to deal with day light savings time.

example: 1. Shutting down DB2 2. Quiesce the DB2 tables spaces before changing time 3. Issueing Archive Log before. 4. etc....

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 24882 119 29_Re: Parallelism (When or Not)10_Marc Baime23_mbaime1@TAMPABAY.RR.COM31_Thu, 28 Oct 1999 14:14:35 -0400588_iso-8859-1 In version 5.2 running on a UNIX /intel platform, you can have parallelism if you are running on an SMP machine. In the database manager configuration file set intra_parallel = yes and if you want the optimizer to choose whether to parallelize tasks set the max_querydegree paramter to -1. You can set this parameter to # of processors but my experience indicates this seems to peg the box (use all the CPU) unneccesarily. You also want to set dft_degree in the database configuration file to -1 as this will also tell the optimizer to select the degree of parallelism it [...] 25002 15 25_Re: DB2/OS390 compression14_Gary Bernhardt18_GBernhardt@CSI.COM31_Thu, 28 Oct 1999 14:38:19 -0500307_ISO-8859-1 > What does YMMV mean?

Your Mileage May Vary...

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 25018 69 22_Re: bind-package error15_Raghu Tarigonda29_rtarigo@NOTES.MNET.USWEST.COM31_Thu, 28 Oct 1999 13:42:06 -0600699_us-ascii Hai Mike,

Thanks first of all.

Actually I am getting -551 when binding and -805 when running.your help would be appreciated.

Thanks Raghu.







Mike_Levine@TEKHELP.NET on 10/28/99 03:03:14 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc:

Subject: Re: bind-package error







Hi,

Are you sure you are getting this error when BINDing or when actually running the program? Typically a -805 is a timestamp mismatch error for a package meaning that the program load module being executed does not match up with the DBRM that produced the package. [...] 25088 95 22_Re: bind-package error15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Thu, 28 Oct 1999 16:01:38 -0400510_iso-8859-1 Raghu,

The owner of the package or plan do not have required access for select/update/delete/insert. Tell the DBA to grant whatever the access it is telling in the error message.

Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com





-----Original Message----- From: Raghu Tarigonda [mailto:rtarigo@NOTES.MNET.USWEST.COM] Sent: Thursday, October 28, 1999 2:42 PM To: DB2-L@RYCI.COM Subject: Re: bind-package error [...] 25184 17 22_Re: bind-package error0_18_DB2DBAinTX@AOL.COM29_Thu, 28 Oct 1999 16:05:13 EDT339_us-ascii The -551 was probably caused by the userid in the owner parameter. That userid must be a valid group id tied to the bind person or the userid of the bind person or have bind agent given to the bind person by the owner. The -805 will go away if the contoken on the dbrm matches the compile date of the program after the bind. [...] 25202 108 22_Re: bind-package error12_Terry Spikes21_terryspikes@YAHOO.COM31_Thu, 28 Oct 1999 13:15:38 -0700390_us-ascii Raghu,

You are getting the -805 at runtime because of the -551 at BIND time. The bind didn't work, so of course the Consistency Token in the package doesn't match the one in the load module. Fix the -551 on the BIND and the -805 should go away. FYI... There have been several posting about consistency tokens in the past few weeks, you may want to search the archives. [...] 25311 95 22_Re: bind-package error0_23_Mike_Levine@TEKHELP.NET31_Thu, 28 Oct 1999 16:14:21 -0500474_us-ascii Hi,

Has your problem be resolved? If you are still getting the -805, for a batch program make sure that there are no other versions of the load module in another library in the STEPLIB. For a CICS program make sure that you NEW COPIED and that there are no other versions being picked up by CICS. Your -551 is an authorization problem with the OWNER keyword of the package. The OWNER must have the necessary authority to perform run SQL in the program. [...] 25407 100 19_Re: DB2 Table Locks14_Linda Claussen18_lindafc@NETINS.NET31_Thu, 28 Oct 1999 16:23:04 -0500544_ISO-8859-1 IS is an Intent Share lock (often referred to as a gross lock). When using LOCKSIZE PAGE on Segmented tablespaces you acquire a hierarchy of locks. You get an IS lock on the tablespace, an IS lock on the table and a concitional S (Share) lock on the pages. The IS locks on the tablespace and table are to prevent DDL from changing the definition of the object or another user from issueing a LOCK TABLE EXCLUSIVE while a user is accessing the data with SQL. The Intent locks are compatible, you can have many IS and IX locks on [...] 25508 39 26_Re: Day Light Savings Time11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 28 Oct 1999 15:04:13 PDT675_- We power off for an hour, and then there are no log issues or timestamp issues. (acctually a little more than an hour).





>From: william.poston@DB.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Day Light Savings Time >Date: Thu, 28 Oct 1999 13:03:22 -0600 > >What step, or preventions are shops taking to deal with day light savings >time. > >example: > 1. Shutting down DB2 > 2. Quiesce the DB2 tables spaces before changing time > 3. Issueing Archive Log before. > 4. etc.... > >================================================ >To change your subscription options or to cancel your subscription [...] 25548 122 19_Re: DB2 Table Locks16_Brian F. Patella25_patellab@WORLDNET.ATT.NET31_Thu, 28 Oct 1999 18:10:34 -0400437_iso-8859-1 Thank you Linda!

I have actually found something in Craig Mullins book that explains this. I guess what confused me was that I was not seeing the page locks in the Boole monitor.

Brian.



-----Original Message----- From: Linda Claussen Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Thursday, October 28, 1999 5:27 PM Subject: Re: DB2 Table Locks [...] 25671 68 26_Re: Day Light Savings Time12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 28 Oct 1999 17:14:30 -0500445_us-ascii Although there are those of us here who believe that we could survive a dynamic time change backward, we are still doing a full shutdown for an hour on all of our OS/390 systems, then re-IPLing with the clock set back. On VM, we got away with letting VM change it's own time back automattically, and SQL/DS never had a problem with it. In the spring we do just dynamically change the clock forward an hour via MVS console command. [...] 25740 29 33_DB2 OS/390 Utility Test: V5 vs V623_Lee, Kenneth (Exchange)14_kmlee@BEAR.COM31_Thu, 28 Oct 1999 18:57:29 -0400476_- > Resend: > According to IBM, V6 utilities should be much faster than those of V5. In > fact, one instructor at the DB2 conference in New Orleans claimed that it > is upto 10 times better. Well, I did some benchmark testing of Load, Image > Copy, Reorg, Unload and Recover and found NO significant improvement of > any utility. Some are even slower. Is there someone out there who have > experienced that I(or IBM) was wrong??? > > Thanks, > Kenneth Lee > 973-793-5981 [...] 25770 29 26_Re: Day Light Savings Time23_Lee, Kenneth (Exchange)14_kmlee@BEAR.COM31_Thu, 28 Oct 1999 18:55:51 -0400421_- Resend: According to IBM, V6 utilities should be much faster than those of V5. In fact, one instructor at the DB2 conference in New Orleans claimed that it is upto 10 times better. Well, I did some benchmark testing of Load, Image Copy, Reorg, Unload and Recover and found NO significant improvement of any utility. Some are even slower. Is there someone out there who have experienced that I(or IBM) was wrong??? [...] 25800 87 25_Re: I/O ERROR DURING READ23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Thu, 28 Oct 1999 23:53:24 -0000638_iso-8859-1 if this is mvs or os390 get the sysprogs to check the locrec for disk errors.

Andrew Puddy Phone 07 3867 1747 Mobile 0419 824 076





-----Original Message----- From: HARBRY ARIZA [mailto:harbry_a@HOTMAIL.COM] Sent: Friday, 29 October 1999 1:39 To: DB2-L@RYCI.COM Subject: I/O ERROR DURING READ



Hi folks:

I'm getting a lot of I/O error as you can see below with tablespaces and indexspaces and I don't know what is the reason that is ocasioning this problem. I know how fix it but if anyone has experienced the same problem I would like to heard about and what are I've got [...] 25888 53 0_14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 29 Oct 1999 14:17:51 +1000622_us-ascii Narasim,

The "resource unavailable" message is the one you should be following: what is the resource, why is unavailable, how can I make it available? The SQLERRMC field contains the name of the resource you cannot get.

SQLERRD(4) contains a floating point number, called the 'timeron', which is a measure of the cost of running the query. It does not name any resources. Timerons are, at best only usefull as an indicative relative measurement. That is, given two queries to get the same information, the one with the lowest timeron value will usually (but not always) be quicker. The timeron [...] 25942 18 36_About DB2 Data Analyst Certification0_23_tbalakri@HEITECH.COM.MY31_Fri, 29 Oct 1999 12:29:40 +0800422_US-ASCII Hi all, I am new to DB2 Database.Is there any certified course on Db2(application and DBA). If any one having info on this please let me know.

thanks & regards bala

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.