1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 1999, week 5 2 88 52_Re: Passing values between columns and host variable14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Wed, 29 Dec 1999 17:33:55 +1100365_- Michael,

Good questions. So good, I'll admit that I don't know the correct answers. Hopefully, my attempt to answer will spark some interest from those that do.

1) Rebind does not produce an error because a datatype or length mismatch is still a valid access path (just not a good one generally). Precompile would consider this to be an error. [...] 91 128 52_Re: Passing values between columns and host variable0_24_ssethi@LOT.TATASTEEL.COM29_Wed, 29 Dec 1999 09:24:04 GMT565_us-ascii 1) The data type and length have to be the content of the DBRM which helps optimizer to decide whether it is a stage-2 or stage-1 predicate. Sqlcode of -304 is returned when the actual data extraction takes place during the run time.I have done a small experiment with a sample COBOL program and found that precompiler also doesn't notice the data type and length mismatch and it doesn't give an error. 2) For the data length mismatch it gives -304 and for data type mismatch it gives -303. 3) Yes, the DBRM and Plan is independent of the programming [...] 220 25 20_DB2/390 Y2K coverage28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Wed, 29 Dec 1999 02:50:08 PST568_- The DB2/390 staff at the lab has split into three shifts to provide 24x7 support through January 7, 2000, should we be needed. We will periodically check DB2-L, but you should contact IBM Service in your geography to start official channels working, if you have a problem.

On DB2-L I suggest you put the words "URGENT Y2K" in your subject line (plus other unique information) if you have a problem so that list members can quickly identify the posts that require attention. I expect we will see mostly posts of an uneventful roll over and shared relief. [...] 246 22 15_Re: Y2K NETWORK13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 29 Dec 1999 07:35:44 -0500572_iso-8859-1 I will be in our office for 2nd shift coverage(15:00-23:30 EST, 20:00-04:30 GMT) through the weekend. I expect to attempt to head home after that and keep a casual eye on things from there.

Wishing peace and calm and all the best to everyone.

David Seibert Compuware Corporation Dave_Seibert@compuware.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. 269 63 22_Re: DB2-L Y2K coverage0_23_J.P.Slot@RF.RABOBANK.NL31_Wed, 29 Dec 1999 14:10:00 +0100339_us-ascii Hello all,

Within our shop the gate-keepers of the network are attempting to shut down the internet e-mail gateway. Thus I won't be able to inform and get informed by the DB2-L. People over here are afraid of possible Y2K-virus infections. If I get an anti-Y2K-virus shot I will be available on januari 1th ( GMT+1. ) [...] 333 44 24_Re: DB2/390 Y2K coverage24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Wed, 29 Dec 1999 08:21:53 -0500432_iso-8859-1 Hi - a humble suggestion: if someone could consoliate the Y2K/DB2 experiences of this momentous upcoming weekend as a post-mortem - even just a bullet list would be fine - so we can all share in the wealth......Thanks

-----Original Message----- From: Dan Courter (1-408-463-3870) [mailto:daniel_courter@VNET.IBM.COM] Sent: Wednesday, December 29, 1999 5:50 AM To: DB2-L@RYCI.COM Subject: DB2/390 Y2K coverage [...] 378 102 38_Re: JCL for Platinum Command Processor11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 29 Dec 1999 08:12:48 -0500747_iso-8859-1 Here is what I have used. This also runs standard IBM commands as well.

//* //* //********************************************************************** //* THIS JCL RUNS THE PLATINUM COMMAND PROCESSOR IN BATCH MODE //********************************************************************** //* //PTLDB2C EXEC PGM=PTLDRIVM,PARM='EP=PTLDB2C/DB2P' //STEPLIB DD DSN=PLATINUM.DB2.UTIL.LOADLIB,DISP=SHR //PTILIB DD DSN=PLATINUM.DB2.UTIL.LOADLIB,DISP=SHR //PTIPARM DD DSN=PLATINUM.DB2.UTIL.PARMLIB,DISP=SHR //PTIXMSG DD DSN=PLATINUM.DB2.UTIL.XMESSAGE,DISP=SHR //PTIMSG DD SYSOUT=* //SYSPRINT DD SYSOUT=* //* //SYSIN DD * -DISPLAY PLATINUM(*) -DIS DB(DBNAME) SPACENAM(*) RESTRICT LIMIT(*) -TERM PLATINUM (DBNAME) SPACENAM(TSNAME) /* [...] 481 45 50_Replication of Vendor Package Database in UDB v6.10_22_BILL_GALLAGHER@PHL.COM31_Wed, 29 Dec 1999 08:35:58 -0500645_us-ascii We're being asked by our management if we can come up with a potential solution to the following scenario using replication:

We have a puchased application currently running at our site that tracks in-house problems and resolutions to those problems for our help-desk. The help desk is now looking to utilize our offshore resource to provide second-shift (their first-shift) support for the application. They can connect to the application running locally here in the US via our network, but response time is reportedly dreadfully slow. So as an alternative, they want to look into the possibility of maintaining two copies [...] 527 13 26_Question for Platinum (CA)14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Wed, 29 Dec 1999 08:37:00 -0600358_us-ascii Is there a web site or list to scan for early warnings or alerts on y2k problems with CA/Platinum products?

================================================ 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. 541 12 61_=?iso-8859-1?B?UulmLiA6IFF1ZXN0aW9uIGZvciBQbGF0aW51bSAoQ0Ep?=0_26_denzil.coulter@UNICIBLE.CH31_Wed, 29 Dec 1999 14:48:01 +0100284_us-ascii http://www.cai.com/2000/index.htm

================================================ 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. 554 26 54_Re: Replication of Vendor Package Database in UDB v6.111_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Wed, 29 Dec 1999 08:42:43 -0500646_us-ascii Bill, You didn't say how current the replication on each end must be, but Data Propagator Relational (DPROPR) could easily handle the two-way replication with minimal changes to the database and well as manage the changes across different operating systems. It runs asynchronously with little impact to the online system. Depending upon the transaction volume, you could probably set it up so that the synchronization between the databases could be done every 15 minutes or so. You can adjust that cycle to optimize performance and minimize impact to the online system. The Capture component captures changes from the database log, [...] 581 20 35_DB2 VSE to DB2 os/390 V5 conversion14_Chris Cronrath18_CCronrath@NESL.COM31_Wed, 29 Dec 1999 09:21:29 -0500280_- We are in the middle of a conversion from DB2 on a VSE to DB2 on the OS/390. One of our tasks is to ensure that old database backups can be restored to DB2 OS/390. Backups made on VSE in the SQL/DS format have been successfully restored used the LOAD option FORMAT SQL/DS. [...] 602 51 39_Re: DB2 VSE to DB2 os/390 V5 conversion24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Wed, 29 Dec 1999 09:35:37 +0000398_us-ascii Chris, This doesn't exactly address your question, but I do have a suggestion. Instead of unloading and reloading your data from DB2 for VSE to DB2 for OS/390, it would be easier and faster to establish a DRDA connection between the two databases. That way you could run a process on OS/390 that would directly read the VSE database without having to go to an intermediate flat file. [...] 654 85 17_Reorg DB2 catalog10_Wang.James24_Wang.James@AAA-CALIF.COM31_Wed, 29 Dec 1999 06:52:54 -0800417_iso-8859-1 Can anyone share some experience on this one? Or where I can get more information about it? Any documented step by step procedure?

We are considering reorg our DB2 catalogs in attempt to improve the catalog access performance. We haven't reorged our DB2 catalog since DB2 V4 and we are experiencing some very slow response time especially during the utility functions such as SYSCOPY clean up. [...] 740 101 41_Re: Reorg DB2 catalog/MODIFY running time0_18_mebert@AMADEUS.NET31_Wed, 29 Dec 1999 16:36:53 +0100566_us-ascii Hello,

yes I have done this about 4 months ago (DB2 V5, OS/390 R2.6). You can find some exchanges on this in the archives because the first try left me with an empty Cat/Dir because of a coding error, and then I had trouble recovering the Cat/Dir because I kept specifying the Index space names instead of the Index names. Now I have working & tested JCLs for Cat/Dir Reorg, Cat/Dir Recover, Check/Checkr and an auxiliary REXX that lists used and allocated space. If you're interested in these, write me and I can send them to you as Word files [...] 842 135 41_Re: Reorg DB2 catalog/MODIFY running time12_John Schatko24_John.Schatko@MEDSTAT.COM31_Wed, 29 Dec 1999 10:40:23 -0500670_iso-8859-1 I would be interested in obtaining a the JCLs and REXX mentioned below...thanks

-----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: Wednesday, December 29, 1999 10:37 AM To: DB2-L@RYCI.COM Subject: Re: Reorg DB2 catalog/MODIFY running time



Hello,

yes I have done this about 4 months ago (DB2 V5, OS/390 R2.6). You can find some exchanges on this in the archives because the first try left me with an empty Cat/Dir because of a coding error, and then I had trouble recovering the Cat/Dir because I kept specifying the Index space names instead of the Index names. Now I have working & tested [...] 978 64 54_Re: Replication of Vendor Package Database in UDB v6.10_17_JTonchick@AOL.COM29_Wed, 29 Dec 1999 11:06:43 EST670_us-ascii In a message dated 12/29/1999 7:38:32 AM Central Standard Time, BILL_GALLAGHER@PHL.COM writes:

<< We're being asked by our management if we can come up with a potential solution to the following scenario using replication:

We have a purchased application currently running at our site that tracks in-house problems and resolutions to those problems for our help-desk. The help desk is now looking to utilize our offshore resource to provide second-shift (their first-shift) support for the application. They can connect to the application running locally here in the US via our network, but response time is reportedly dreadfully slow. So as [...] 1043 149 21_Re: Reorg DB2 catalog22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 29 Dec 1999 15:12:58 +0000284_ISO-8859-1 James I reorged our catalog and directory a few months ago and it took an hour to run ..

there is a set way of reorging the catalog and directory and it is documented very well in the manuals .. the order I used was :

1. Backup the Catalog and directory [...] 1193 94 54_Re: Replication of Vendor Package Database in UDB v6.113_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 29 Dec 1999 11:15:48 -0500633_us-ascii Amen! You have synchronization issues every time someone needs to do a load or recovery. You have additional cpu costs on both ends for the replication agent. It's an ugly road to go down (my humble opinion).

> -----Original Message----- > From: JTonchick@AOL.COM [SMTP:JTonchick@AOL.COM] > Sent: Wednesday, December 29, 1999 11:07 AM > To: DB2-L@RYCI.COM > Subject: Re: Replication of Vendor Package Database in UDB v6.1 > > In a message dated 12/29/1999 7:38:32 AM Central Standard Time, > BILL_GALLAGHER@PHL.COM writes: > > << We're being asked by our management if we can come up with a potential > solution [...] 1288 47 54_Re: Replication of Vendor Package Database in UDB v6.10_22_Rohn.Solecki@MTS.MB.CA31_Wed, 29 Dec 1999 10:19:57 -0600368_us-ascii I don't have an answer specifically to your question but here is one for you to think a about ... "Software Piracy!" Does your vendor allow you to run an unlicensed copy at a remote location. I'm willing to bet they aren't. Ask them about suggestions for data replication, I'm willing to bet they've already had to answer that question from other sites. [...] 1336 77 37_Reorg DB2 catalog & Directory - again22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 29 Dec 1999 15:23:51 +0000292_ISO-8859-1 Here goes again - my last post was rejected

James I reorged our catalog and directory a few months ago and it took an hour to run ..

there is a set way of reorging the catalog and directory and it is documented very well in the manuals .. the order I used was : [...] 1414 85 54_Re: Replication of Vendor Package Database in UDB v6.10_22_BILL_GALLAGHER@PHL.COM31_Wed, 29 Dec 1999 12:03:27 -0500436_us-ascii We're well aware of the potential licensing issues with doing this, and I'm sure the appropriate people will address and resolve those issues with the vendor as part of the overall evaluation of whether or not this is an appropriate approach to solve this situation. I'm just looking at the purely technical aspects of how to do it from a DBA point-of-view, and any advice of what to do/not do, what to look out for, etc. [...] 1500 27 40_Accessing VSAM in a DB2 Stored Procedure13_Bernie Polley29_bpolley@JHUADIG.ADMIN.JHU.EDU31_Wed, 29 Dec 1999 12:08:36 -0500367_US-ASCII We have a stored procedure written in COBOL for OS390 that reads a VSAM = file. The stored procedure abends with a SYSTEM COMPLETION CODE=3D0C4 = REASON CODE=3D00000004 in module IGZCPAC. This occurs as soon as the sp = opens the VSAM file. We have the JCL DD statement in the stored procedures= address space JCL procedure. Does anyone have any clues? [...] 1528 61 26_IRLM running out of memory0_18_mebert@AMADEUS.NET31_Wed, 29 Dec 1999 18:18:46 +0100588_us-ascii Hello all,

as part of our Y2K preparation procedures, I had planned to take fresh imagecopies of all our TS, and then do a QUIESCE just before midnight to establish a recovery point - I am not concerned about DB2 failing, but this might come in handy if an application starts chewing up data after midnight. I used a SAS program to generate the QUIESCE job, partitioning our subsystems into parts containing about 700-1100 Tablespaces each (QUIESCE accepts a maximum of 1165 TSs), or 1400-3500 partitions. However, I got an abend because IRLM ran out of lock memory: [...] 1590 42 28_How to implement the Timeout10_ajay kumar19_db2v5r1@HOTMAIL.COM29_Wed, 29 Dec 1999 22:51:10 IST456_- Hi

We are using BD2 V5r1, We want DB2 to initiate the timeout if the resource is unavailable for x seconds.

The problem is During BIND, the job is simply idle for more than 25 mts, it is not come out? We are binding the package to 'xxx' collection.(somebody will test the application which will use the 'xxx' collection). Sometimes there is not application but the bind will be idle for more than 20 mts, but the thread status is '*'. [...] 1633 181 41_Re: Reorg DB2 catalog/MODIFY running time0_18_mebert@AMADEUS.NET31_Wed, 29 Dec 1999 18:22:28 +0100446_us-ascii Until now, I have gotten about 15 requests for the CAT/DIR REORG JCLs and REXX... I will send them tomorrow, so I can collect some more.

To explain further on the MODIFY topic: I had a TS with 6000+ SYSCOPY entries, relating to 204 days. Doing a MODIFY ... DELETE AGE(20) took about 1500 CPU seconds, and maybe 40 mins elapsed (I don't know these numbers exactly, as I had many MODIFY statements in one DSNUTILB invocation). [...] 1815 47 44_Re: Accessing VSAM in a DB2 Stored Procedure22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 29 Dec 1999 13:11:01 -0500698_- Ensure the DB2 Stored Procedure JCL proc is using the correct Language Environment (LE) run time library *.SCEERUN - either through the link list or a steplib.

The LE runtime version must support the COBOL for OS/390 version.



Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com

> ---------- > From: Bernie Polley[SMTP:bpolley@JHUADIG.ADMIN.JHU.EDU] > Sent: Wednesday, December 29, 1999 12:08 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Accessing VSAM in a DB2 Stored Procedure > > We have a stored procedure written in COBOL for OS390 that reads a VSAM = > file. The stored procedure abends with a SYSTEM COMPLETION CODE=3D0C4 = > [...] 1863 162 41_Re: Reorg DB2 catalog/MODIFY running time12_Price, David22_David.Price@SCHWAB.COM31_Wed, 29 Dec 1999 10:50:47 -0800421_iso-8859-1 FYI ... We had a similar problem with Modify.

If you have a tablespace which has a lot of SYSCOPY entries spread over many days/months/years, then try DELETE AGE(*) on the modify command. While this removes all the SYSCOPY entries for a given database.tablespace ..., it runs much faster than DELETE AGE(XXX) when there are an excessive number of SYSCOPY entries for a given database.tablespace... [...] 2026 16 41_Getting job-name from Cobol / DB2 program19_kishore erukulapati21_kishore_e@HOTMAIL.COM29_Wed, 29 Dec 1999 11:04:49 PST460_- Hi , Is there any way to get the job-name from Cobol / DB2 ? ( Using DB2 System tables or something else ) ______________________________________________________ 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. 2043 86 30_Re: IRLM running out of memory0_23_Mike_Levine@TEKHELP.NET31_Wed, 29 Dec 1999 14:13:47 -0500372_us-ascii Hi,

If you are not looking for advice to raise your MAXCSA to 7M (PC=NO) then you could try stopping the database(s), start for UT only and quiesce a single tablespace which would be the recovery point for all of the tablespaces in that database. This could be repeated for all of the databases that you want to create consistent recovery points for. [...] 2130 101 30_Re: IRLM running out of memory12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 29 Dec 1999 11:17:40 PST626_- Michael:

I would like suggest to you use LOCK TABLE statements (like this 'LOCK TABLE TCREATOR.TNAME IN SHARE or EXCLUSIVE MODE') and I bet you won't have problem at all. Try it out .

I hope it helps.

Harbry.



>From: mebert@AMADEUS.NET >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: IRLM running out of memory >Date: Wed, 29 Dec 1999 18:18:46 +0100 > >Hello all, > >as part of our Y2K preparation procedures, I had planned to take fresh >imagecopies of all our TS, and then do a QUIESCE just before midnight to >establish a recovery point - I [...] 2232 94 45_Re: Getting job-name from Cobol / DB2 program14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Wed, 29 Dec 1999 14:38:52 -0500305_us-ascii Here's the assembler subroutine we use. It's got a few homegrown macros which should be easy to decipher ("NOLSA" on the ENTER macro means no low save area -- just STM into the high save area provided), and you'll want to take out the locator/descriptor stuff, but the essentials are there: [...] 2327 29 45_Re: Getting job-name from Cobol / DB2 program12_Jim Harrison12_jimh@QIS.NET31_Wed, 29 Dec 1999 14:33:34 -0500634_us-ascii Gilbert Saint Flour has a sample posted at his web site:

http://members.home.net/gsf/tools/cob2job.txt

At 11:04 AM 12/29/99 PST, you wrote: >Hi , > Is there any way to get the job-name from Cobol / DB2 ? ( Using DB2 >System tables or something else ) >______________________________________________________ >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. > > [...] 2357 115 30_Re: IRLM running out of memory0_17_ttaylor@CHUBB.COM31_Wed, 29 Dec 1999 14:44:38 -05001035_us-ascii HI

The online V5 books include

>>__MODIFY__irlmproc,SET___,CSA=nnn_________________________________>< |



http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNCR0F5/2%2e42?SHELF=DSNSH0F5







I haven't tried it and Ii don't know if you need PTF's ???



Tom













mebert@AMADEUS.NET on 12/29/99 12:18:46 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Thomas G Taylor/ChubbMail)





Subject: IRLM running out of memory















Hello all,

as part of our Y2K preparation procedures, I had planned to take fresh imagecopies of all our TS, and then do a QUIESCE just before midnight to establish a recovery point - I am not concerned about DB2 failing, but this might come in handy if an application [...] 2473 432 30_Re: IRLM running out of memory0_22_aylswop@WELLSFARGO.COM31_Wed, 29 Dec 1999 12:00:54 -0800672_iso-8859-1 The PTF enabling this is UQ17535, and was available at the 9806 level. PQ12126 has the full description of what's included.

> -----Original Message----- > From: ttaylor@CHUBB.COM [SMTP:ttaylor@CHUBB.COM] > Sent: Wednesday, December 29, 1999 12:45 PM > To: DB2-L@RYCI.COM > Subject: Re: IRLM running out of memory > > HI > > The online V5 books include > > >>__MODIFY__irlmproc,SET___,CSA=nnn_________________________________>< | > > > http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNCR0F5/2%2e42?SHEL > F=DSNSH0F5 > > > > > I haven't tried it and Ii don't know if you need PTF's ??? > > > Tom > > > > > > > > mebert@AMADEUS.NET on 12/29/99 [...] 2906 38 38_DB2/390 Y2K coverage......good luck !!14_Max 'Guderian'16_mocion@LIBERO.IT31_Wed, 29 Dec 1999 21:31:19 +0100292_us-ascii I hope It 'll be only a safety crew.....in a red metal box with a little hammer and a BIG warning :

'In case of Y2K bug break the glass' ..... Just to exorcise Y2K bug.

I heard many collegues will be in touch this night via e-mail, so that there 'll be a big news [...] 2945 24 30_Re: IRLM running out of memory12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 29 Dec 1999 14:38:01 -0800338_us-ascii The IRLM release is the same for DB2 V4, V5 and V6. It's still IRLM V2R1. The changes which were provided after DB2 V5 general availability are documented in the Version 6 Release Guide, chapter 6 User Productivity, section 4 IRLM Enhancements. If you are V4, V5 or V6 DB2, you can put on the service and use these changes. [...] 2970 35 31_Re: DB2 for OS/390 Y2K coverage12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 29 Dec 1999 15:16:55 -0800490_us-ascii We've been calling this time the 12 days of Y2K. I enjoyed a couple of Y2K cards at www.bluemountain.com This evening I get to cover second shift 16:00 to 24:30 PST, then first shift for a couple of days and third shift for Saturday (or early Sunday morning). The off-shift team is big, with developers, managers, Test/Performance/Tools, and Level 2. I think we have about 30 people here second shift, just in case. We get to provide some of the old answers, recycling works. [...] 3006 28 14_regarding IRLM17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Wed, 29 Dec 1999 19:19:48 PST444_- Hello Everybody,

Can anybody explain about IRLM, how it works with db2, 1) suppose if i running a db2 batch jobs and db2 cics jobs how irlm will be react, 2) how many locks will be needed for each job. 3) can we altered the irlm. do we has authority to alter it. 4) what is the size of the each irlm lock and what is the space taken by each lock. 5) suppose if you don't have a irlm lock, what is the problem we are going to get. [...] 3035 43 45_Re: Getting job-name from Cobol / DB2 program0_24_ssethi@LOT.TATASTEEL.COM29_Thu, 30 Dec 1999 03:33:44 GMT474_us-ascii If u are using some online monitoring tools like O-MON ,u can get the job name corresponding to a plan.

Sanjeev









kishore erukulapati @RYCI.COM> on 12/29/99 07:04:49 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Getting job-name from Cobol / DB2 program [...] 3079 46 18_Re: regarding IRLM8_georgewu27_george.wu@CHINATRUST.COM.TW31_Thu, 30 Dec 1999 11:28:10 +0800596_big5 Ravi, average 250 byte per lock. george -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of ravi kumar hassan Sent: Thursday, December 30, 1999 11:20 AM To: DB2-L@RYCI.COM Subject: regarding IRLM



Hello Everybody,

Can anybody explain about IRLM, how it works with db2, 1) suppose if i running a db2 batch jobs and db2 cics jobs how irlm will be react, 2) how many locks will be needed for each job. 3) can we altered the irlm. do we has authority to alter it. 4) what is the size of the each irlm lock and what is the [...] 3126 54 37_Re: accessing MVS os/390 data from PC12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 29 Dec 1999 23:11:18 -0800335_us-ascii There are so many options for connecting DB2 for OS/390 with a PC. Most of the ones that I like best use DB2 Connect as part of the connection, but the options include MQ Series, CICS, various web connections and many gateway products. Don't forget stored procedures. Here are the primary red books with the information: [...] 3181 23 30_Re: Question for Platinum (CA)10_Leo Flores23_leoflores@EARTHLINK.NET31_Thu, 30 Dec 1999 00:22:10 -0800457_us-ascii Try http://antivirus.cai.com/

HTH - Leo Flores

Susan Birgeles wrote:

> Is there a web site or list to scan for early warnings or alerts on > y2k problems with CA/Platinum products? > > ================================================ > 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. [...] 3205 25 15_SAP chooses ...12_Adam, Daniel15_dadam@GRATEX.SK31_Thu, 30 Dec 1999 10:56:48 +0100563_- Makes you wonder...

SAP Selects Microsoft SQL Server 7.0 as Strategic Development And Production Platform for Windows NT and Windows 2000, Offering Customers Expanded Platform Choices http://www.sap.com/press/12_99/12_99_13.htm







Daniel Adam Gratex International http://www.gratex.sk

================================================ 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. 3231 45 19_Re: SAP chooses ...22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Dec 1999 10:27:01 +0000571_ISO-8859-1 Err ... I thought they choose DB2 ?????????

talk about trying to keep everyone happy.

Leslie



______________________________ Reply Separator _________________________________ Subject: SAP chooses ... Author: "Adam; Daniel" at Internet Date: 12/30/99 10:56 AM



Makes you wonder...

SAP Selects Microsoft SQL Server 7.0 as Strategic Development And Production Platform for Windows NT and Windows 2000, Offering Customers Expanded Platform Choices http://www.sap.com/press/12_99/12_99_13.htm [...] 3277 19 52_Options of Language Environment for Stored Procedure0_24_ujjwal@LOT.TATASTEEL.COM29_Thu, 30 Dec 1999 11:41:27 GMT539_us-ascii Dear List , Can anyone tell me what are the Language Environment Runtime Options used while executing the Stored Procedure ? The Stored Procedure is written in IBM COBOL for MVS.At present the column in SYSIBM.SYSPROCEDURES " RUNOPTS" is blank.

THANX in Advance. UJJAL BHATTACHARYA

================================================ 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. 3297 33 27_SNAPSHOT - recovery options13_Adrian Savory24_adrian.savory@ZURICH.COM31_Thu, 30 Dec 1999 11:51:53 +0000572_us-ascii Hi folks,

Can any IBMer (or anyone else) tell me if (when?) the DB2 Recover utility will support SNAPSHOT in future i.e. snap back virtual concurrent copy backups, rather than recover them at the usual speed?

What I'm looking for is a fast AND flexible method of recovering a large number of DB2 objects, some of which will be big. SNAPSHOT looks to be the way forward, but I need fast recovery. The only way I think I can get that at the moment is by taking offline DFDSS dumps (via SNAPSHOT) and restoring them (snapping them back), but this [...] 3331 64 31_Re: SNAPSHOT - recovery options22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Dec 1999 11:13:30 +0000337_ISO-8859-1 Adrian

I can tell you this ..

in about 2/3 years time .. and that is assuming it gets pushed up the priority list in IBM ...

Also I think somebody on here did the LOGONLY stuff or was looking into it about two months ago .. have a look in the archives as I am sure this subject has been chewed over. [...] 3396 39 29_How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 30 Dec 1999 07:36:27 -0500579_us-ascii to support a company's test and production environments? I'm trying to gather some statistics or rule-of-thumb for my boss who would like to increase our staff.

There are 6 of us, including my boss to support IMS, DB2 (for OS/390), MS SQL Server and we're starting to get into UDB/NT. There are about 30 IMS databases, 115 DB2 databases and 20 SQL Server databases in production. I would say that the DB2 and SQL Server databases have 30 - 40 tables each. We have twice that number of databases in test, given that we typically have a unit-test database and [...] 3436 63 18_Re: regarding IRLM12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 30 Dec 1999 05:34:50 PST433_- Ravi:

-The number of locks on db2 Batchs jobs depend on the access paths used by your program (How you going to get the data ? Sequentialy , Ramdon or How much data you need to move?.( using list prefetch, sequential prefetch, index scan).

- Another important thing that you need keep in mind is the commit frecuency and hOW you bound your plans or packages(ACQUIRE(USE/ALLOCATE) and RELEASE(COMMIT/DEALLOCATE). [...] 3500 109 33_Re: How many DBAs does it take...0_22_BILL_GALLAGHER@PHL.COM31_Thu, 30 Dec 1999 08:38:57 -0500369_us-ascii Lynne,

We're in a somewhat similar situation, and we know that we're understaffed. We have 4 DBA's supporting four different DBMS platforms: DB2 on OS/390, MS SQL Server running on NT, Oracle/Rdb running on VMS, and just recently UDB on AIX. Each of the four of us are supporting two of the above systems, so that we have two people for each DBMS. [...] 3610 41 19_Re: SAP chooses ...14_Chris Cronrath18_CCronrath@NESL.COM31_Thu, 30 Dec 1999 08:51:33 -0500473_iso-8859-1 Someone please explain why they would choose both DB2 and Microsoft SQL Server?

How and why did IBM let this get away? Is DB2 on Windows NT/2000 not as good as Microsoft SQL Server? I have worked with both and I know this is not the case.

My boss saw this and I am now having a very hard time convincing him DB2 UDB for NT is the way to go. Why couldn't IBM prove DB2 UDB is the way to go on all platforms? This would have made my job easier. [...] 3652 45 30_Re: IRLM running out of memory50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Thu, 30 Dec 1999 08:56:33 -0500307_- I had this problem going from v3 to v4 on a test LPAR. I changed the parameter to PC=YES and was able to run. I was not to concerned because it was the test lpar and not the production lpar. Then upon migration to v5 the ECSA was expanded on that lpar and I changed back to PC=NO to keep consistent. [...] 3698 75 33_Re: [SNAPSHOT - recovery options]9_Jo K.Nash17_jo.k.nash@USA.NET29_Thu, 30 Dec 1999 08:59:45 EST318_US-ASCII Adrian,

I also asked some snapshot questions a while back, because it does appear to be a good fast solution. But as you have uncovered there limitations. BMC so far is the only vendor I have found that is taking advantage of the hardware snapshot technology in more than just their copy utility. [...] 3774 71 19_Re: SAP chooses ...22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Dec 1999 13:13:33 +0000481_ISO-8859-1 Chris

I have worked with both (SQL server not as much as UDB) and SQL server is a crock of smelly dung with a shinny marketing man standing behind it. UDB IS THE BEST! and I too wish to know why IBM have let this slip through their fingers ..

Les



______________________________ Reply Separator _________________________________ Subject: Re: SAP chooses ... Author: Chris Cronrath at Internet Date: 12/30/99 8:51 AM [...] 3846 58 33_Re: How many DBAs does it take...11_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Thu, 30 Dec 1999 09:09:25 -0500610_us-ascii Lynne,

I'll look back through my "archives" (that means the mess in my filing cabinet) but I remember from an IS management seminar I attended earlier in the year that on average 1 DBA per 12-20 programmers is ideal. I don't remember who came up with that number or how they justified it. Of course, that depends on how active your developement staff is in new development as opposed to supporting purchased packages, if you have a Warehousing environment you are supporting, and how self-sufficient are your end-users. We have 3 DBA's supporting 50 programmers in an environment with DB2 [...] 3905 30 28_REXX stored procedures in V611_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Thu, 30 Dec 1999 09:30:31 -0500397_us-ascii I'm submitting these questions to DB2 listproc because I believe the answers will be useful for all V6 installations that want to use REXX stored procedures.

I have UQ35973 applied to enable REXX stored procedures to function in V6. I can CREATE a PROCEDURE with language REXX.

BUT...

I have no documentation for how to use REXX stored procedures. Specifically, [...] 3936 225 41_Re: Reorg DB2 catalog/MODIFY running time0_18_mebert@AMADEUS.NET31_Thu, 30 Dec 1999 15:44:54 +0100588_us-ascii Hello again,

I have just sent the mentioned Cat/Dir Reorg JCL, Recover JCL, Check JCL & LISTC REXX to 23 people who have requested them. If I have missed someone, or you have just caught up with your emails, and want some too, just write.

As I said, I'm sure that REORGing the Cat/Dir will NOT help you with performance problems (I'm surprised that IBM recommended it for this). In our case, it was done because one disk was 100% full, preventing BINDs because SYSPKAGE could not extend, to redistribute TSs over the two disks dedicated to the Cat/Dir, resize [...] 4162 18 54_Re: How many DBAs does it take to change a light bulb?0_23_Mike_Levine@TEKHELP.NET31_Thu, 30 Dec 1999 09:52:11 -0500416_us-ascii NONE....it's a hardware problem! Sorry, I couldn't resist.



Have a very happy and safe New Year 2000!

Michael Levine Premier Data Services, Inc.

================================================ 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. 4181 57 19_My little wish ....14_subrata mondal25_subratamondal@HOTMAIL.COM29_Thu, 30 Dec 1999 15:03:23 GMT432_- Dear all Db2-L,



A WISH FOR THE NEW MILLENNIUM FROM SUBRATA MONDAL

May your hair, your teeth, your face-lift not fall; and may your blood pressure, your triglycerides, your cholesterol, your white blood count not rise.

May you get a clean bill of health from your dentist, your cardiologist, gastro-endocrinologist, urologist, proctologist, podiatrist, psychiatrist, plumber, electrician ... etc. [...] 4239 109 33_Re: How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 30 Dec 1999 10:12:01 -0500598_us-ascii Jim, I like that metric! I'll forward this on to my boss. We have tools to automate our work (Platinum Database Analyzer, Plan Analyzer, etc. but we don't know how to use them and we haven't made time to learn how to use them...vicious cycle, eh?).

Thanks much!

> -----Original Message----- > From: Jim Knisley [SMTP:Jim_Knisley@FORETHOUGHT.COM] > Sent: Thursday, December 30, 1999 9:09 AM > To: DB2-L@RYCI.COM > Subject: Re: How many DBAs does it take... > > Lynne, > > I'll look back through my "archives" (that means the mess in my filing > cabinet) > but I remember [...] 4349 155 33_Re: How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 30 Dec 1999 10:17:24 -0500617_iso-8859-1 Bill, Not to depress you but it sounds like you're even more understaffed than us! I forwarded your email on to my boss. Luckily, he's a joy to work for (and no, he's not on the listserv :-) ).

Thanks for the feedback!



> -----Original Message----- > From: BILL_GALLAGHER@PHL.COM [SMTP:BILL_GALLAGHER@PHL.COM] > Sent: Thursday, December 30, 1999 8:39 AM > To: DB2-L@RYCI.COM > Subject: Re: How many DBAs does it take... > > Lynne, > > We're in a somewhat similar situation, and we know that we're > understaffed. We > have 4 DBA's supporting four different DBMS platforms: DB2 on [...] 4505 67 32_Re: REXX stored procedures in V617_Linda F. Claussen18_lindafc@NETINS.NET31_Thu, 30 Dec 1999 09:58:17 -0600761_ISO-8859-1 Joe,

Have you checked the DB2 for OS/390 REXX Language Support manual available on the web? There's a sample in the appendix and set up instructions. You can download from:

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

Cheers, Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985

---------- > From: Joe Luthman > To: DB2-L@RYCI.COM > Subject: REXX stored procedures in V6 > Date: Thursday, December 30, 1999 8:30 AM > > I'm submitting these questions to DB2 listproc because I believe the answers will be useful for all V6 installations that want to use REXX [...] 4573 91 19_Re: SAP chooses ...0_23_Mike_Levine@TEKHELP.NET31_Thu, 30 Dec 1999 10:58:38 -0500538_us-ascii Hi,

I would not go quite this far...I think that SAP simply choose not to put all of their eggs in one basket. I'm sure this was not overlooked by IBM. The DB2 win over Oracle was big though!

Regards,

Michael Levine Premier Data Services, Inc.



> Chris > > I have worked with both (SQL server not as much as UDB) and SQL server > is a crock of smelly dung with a shinny marketing man standing behind > it. UDB IS THE BEST! and I too wish to know why IBM have let this > slip through their [...] 4665 161 33_Re: How many DBAs does it take...14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 30 Dec 1999 11:34:20 -0800538_us-ascii Lynn, We have 4 fulltime employees doing day to day DBA work. All in all we support just short of a terabyte of data including UDB on NT. We also use contractors for specific tasks when we need them. At times we have had a total of 9 DBAs. We have about 60 developers both onsite and offsite. I can tell you that we still don't have enough hands. We try and review all SQL during development, and fix bad SQL and tweak access paths, that means capturing SQL using Detector and Plan Analyzer, or using event monitors in UDB. [...] 4827 139 30_Re: Question for Platinum (CA)9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 30 Dec 1999 09:36:47 -0700504_us-ascii CA's Year 2000 web site (this includes former Platinum products):

http://www.cai.com/2000

You can also track any issue your site creates via Star TCC. Here are instructions for getting a Star TCC ID, if you do not have one.

Information on StarTCC:

StarTCC is Computer Associates web based issue reporting interface. The following procedures can be used to sign yourself up for a StarTCC ID, and receive hyper notification for the products you are interested in. [...] 4967 20 28_Landmark Systems Y2K Support10_Lee Cooper20_lcooper@LANDMARK.COM31_Thu, 30 Dec 1999 11:44:34 -0500419_us-ascii From Thursday, December 30,1999 through Friday, January 7, 2000, Landmark will have expanded support with additional staffing to handle any Y2K Severity 1 problems in the Landmark TMON for DB2 product (or any other Landmark product). Our support number is 1-800-775-5675. Landmark personnel will also post any necessary notices on the main page of the Landmark Support Web Site(www.support.landmark.com). [...] 4988 21 6_db2 v615_Sherri Sterling23_ssterling@BPD.TREAS.GOV31_Thu, 30 Dec 1999 11:47:47 -0500387_US-ASCII Some new features that came with db2 version 6 are data types for images, audio, video and text extenders. We are trying to experiment with these extenders. My question is this, Does the application for manipulating these data types have to be a C/C++ program or can it be a Java/JDBC program? Reason is, we do not have a C compiler and are not sure if we need to get one. [...] 5010 29 41_Re: Reorg DB2 catalog/MODIFY running time12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 30 Dec 1999 18:44:56 +0200509_x-user-defined Hi, Except of all of the above which is in agreement with my findings and notes from more then a year ago (although I didn't do the mathematical calculations), Pleas take a look at your BP0 where cat/dir are located to see if it's sized properly. You should consider your real memory, expanded storage and system paging activity as well to try and get a tuned BP (and/or buy a tool). I tend to enlarge BP0 when I need to run a heavy maintenance on the cat/dir and then change it back to normal. 5040 130 19_Re: SAP chooses ...22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 30 Dec 1999 15:52:46 +0000371_ISO-8859-1 Michael

.. remains to be seen how IBM take this .. but ...

...I am not saying that the product isn't right for certain people ..

what really annoys me is that marketing machines like microsoft are able to just steam their way into places because they already have a strangle hold on the infrastructure through their other products .. [...] 5171 69 19_Re: SAP chooses ...12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 30 Dec 1999 18:58:20 +0200537_x-user-defined Hi, If I remember correctly OS/2 was much better then windows (all versions), so .....????? (I know -I still use OS/2 on production system). It looks like mgmt. all over around are going by consensus on microsoft tools on the NT platform. They don't want to be hassled by having to combine two products. If microsoft will be broken to 3-4 companies then it may change. BTW - T had to do some work on SQL SERVER both 6.5 and 7.0 and there is a big improvement (It is still far from DB2 UDB). SAP had to move away from [...] 5241 15 13_DB2 Optimizer13_Toppins, Mike19_MToppins@UNIPAC.COM31_Thu, 30 Dec 1999 09:54:34 -0700291_iso-8859-1 Could someone please give me a brief summary of how the optimizer determines how to choose access paths. We've got some dynamic SQL jobs that run every day. One day, they will choose to use the index(es) that we've set up to be used and the next day, it uses different ones. [...] 5257 169 19_Re: SAP chooses ...11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 30 Dec 1999 09:10:26 PST516_- It seems to me that you are describing the way the world works. I heard years ago that IBM got a foothold in the hardware market mainly through marketing tactics like you described. There were other computers out there, such as Burroughs and Honeywell that did a good job; but the difference on who ultimately took charge of the marketplace was the marketing accomplishments... OS2 already had many of the features that were seen in Windows 95; but it was marketing that made people go crazy over Windows 95. [...] 5427 52 10_Re: db2 v616_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 30 Dec 1999 11:24:43 -0600299_iso-8859-1 Sherri,

For an application using an extender: 1 - if DB2 ODBC, it can use CLI 2 - if not ODBC, then is can use SQL 3 - But DB2 extender APIs require at this time, C or C++

Most of the extender use will be on client stations for displaying and manipulating the objects. [...] 5480 169 19_Re: SAP chooses ...50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Thu, 30 Dec 1999 12:47:00 -0500588_iso-8859-1 You are absolutely right.

I watched this go on in a previous shop where :::

Model 204 Supra Ultra DB2 IMS Oracle ?? were in use over the past 10 years.

> ---------- > From: Leslie > Pendlebury-Bowe[SMTP:Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP] > Reply To: DB2 Data Base Discussion List > Sent: Thursday, December 30, 1999 10:52 AM > To: DB2-L@RYCI.COM > Subject: Re: SAP chooses ... > > Michael > > .. remains to be seen how IBM take this .. but ... > > ...I am not saying that the product isn't right for certain people .. > > what really annoys [...] 5650 200 33_Re: How many DBAs does it take...13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 30 Dec 1999 12:47:20 -0500617_iso-8859-1 I forgot to include in our DBA headcount the DBA who has been working to implement clustering on SQL Server 7.0. So we have a total of 7 DBAs, including our boss. We have 2 full-time data modelers. Development projects are not required to use them (and they couldn't anyway, as the data modelers are under-staffed). We have 3 people who support our gateway products (MDI, Direct Connect and DB2 Connect, which is our strategic gateway product) and replication products (Sybase and DataJoiner). Through the gateways comes about 60% of our SQL, that's right...you guessed it, dynamically. We don't have [...] 5851 58 17_Re: DB2 Optimizer12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 30 Dec 1999 09:55:30 -0800628_us-ascii The optimizer looks through the query and table statistics at a very detailed level to determine costs for the query, then uses the access paths which compute as the lowest total cost.

There are significant differences from version to version and sometimes in PTFs. For a meaningful description, start with the Administration Guide chapter "Tuning Your Queries" for some of the most common situtations and tuning. If you want to see the statistics in a bit more detail, that's in the "Maintaining Statistics in the Catalog" chapter. To look at detailed analysis, then there is the "Using EXPLAIN to improve [...] 5910 83 30_Re: Question for Platinum (CA)14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Thu, 30 Dec 1999 13:01:00 -0600424_us-ascii I was far more interested in seeing issues discovered by my counterparts in other areas of the globe who hit Y2k before we do. That way, I could take measures to avoid/mitigate them.



______________________________ Reply Separator _________________________________ Subject: Re: Question for Platinum (CA) Author: DB2-L@RYCI.COM (DB2 Data Base Discussion List) at internet Date: 12/30/99 10:36 AM [...] 5994 18 14_Sort pool size0_17_ttaylor@CHUBB.COM31_Thu, 30 Dec 1999 13:19:02 -0500484_us-ascii Hi all

I 'm trying to size the srtpool zparm correctly and decided to use the manual. The manual gives a formula for srtpool size, but doesn't indicate what happens when this storage limit is reached. What happens??

Tom

================================================ 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. 6013 98 30_Re: Question for Platinum (CA)24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 30 Dec 1999 10:19:08 -0800480_- This is all very nice, and IBM has a Y2K web address as I'm sure that most of the other major vendors have. The problem with this is that I suspect that most of these companies will probably do some heavy-duty sanitizing of any information they put on their web sites. We could very easily find that problems are being handled similarly to how Coke handled their recent quality problems in Europe, first by denying they had a problem, and later by minimizing the severity. [...] 6112 70 34_Useful VARBusiness articles on Y2K12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 30 Dec 1999 10:41:32 -0800390_us-ascii - Gartner Group: Y2K Bug May Bite Later In The Year - On The Eve of Y2K - US Corporations Confident About Y2K - 5 Million Will Spend New Year's Eve On Call - Millennium Marathon: Y2K Watchers Ring In 24 New Years - Equity Investors Predict Y2K To Drop Stock Market 10 To 15 Percent - Corporations Confident About Y2K, Says Cap Gemini Survey - Countries Proclaim Y2K Readiness [...] 6183 34 18_Re: Sort pool size0_31_truman.g.brown@BELLATLANTIC.COM31_Thu, 30 Dec 1999 13:43:23 -0500365_us-ascii If application code incurs a sort and the "run" (a string of sorted results rows) does not complete within the SORTPOOL size, the run will be written to DASD (a 4K work dataset) and later merged with the ensuing runs that complete the sort. If I recall correctly, multiple SORTPOOL entities exist (one for each concurrent application sort operation). [...] 6218 15 7_DSNDB070_20_bjnigh@HOUSEHOLD.COM31_Thu, 30 Dec 1999 10:41:04 -0800392_us-ascii When placing the DSNDB07 work files on separate DASD volumes, should there be any other files on the same volume?

Barbara Jo Nigh, DBA

================================================ 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. 6234 39 11_Re: DSNDB070_31_truman.g.brown@BELLATLANTIC.COM31_Thu, 30 Dec 1999 13:50:04 -0500464_us-ascii Only if the other files are VERY LOW activity. Also, if you size SORTPOOL and work dataset bufferpool correctly (application and storage allowing), you'll have minimum usage of the 4K work datasets.

George







bjnigh@HOUSEHOLD.COM on 12/30/99 01:41:04 PM

Please respond to "DB2 Data Base Discussion List"

To: DB2-L@RYCI.COM cc: (bcc: TRUMAN G. BROWN/EMPL/MD/Bell-Atl) Subject: DSNDB07 [...] 6274 26 22_Re: DB2-L Y2K coverage12_Jim Harrison12_jimh@QIS.NET31_Thu, 30 Dec 1999 14:23:03 -0500569_us-ascii Yeah, they're doing the same thing here. If you still have web access (they *say* we're supposed to, but who knows), you can sign up for a free web based email service like Hotmail.

At 02:10 PM 12/29/99 +0100, you wrote: >Hello all, > >Within our shop the gate-keepers of the network are attempting to shut >down the internet e-mail gateway. Thus I won't be able to inform and >get informed by the DB2-L. People over here are afraid of possible >Y2K-virus infections. >If I get an anti-Y2K-virus shot I will be available on januari 1th ( >GMT+1. ) [...] 6301 39 11_Re: DSNDB0712_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 30 Dec 1999 11:48:03 PST736_- Barbara:

Is highly recomemmded specifie dedicated volumes to the dsndb07. These volumes going to have high activity, that's why is not recommemded allocate another datasets on those specific volumes. The same thing occur with the sort bufferpool. Is better dedicated one bufferpool to the dsndb07.





>From: bjnigh@HOUSEHOLD.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DSNDB07 >Date: Thu, 30 Dec 1999 10:41:04 -0800 > >When placing the DSNDB07 work files on separate DASD volumes, should there >be >any other files on the same volume? > >Barbara Jo Nigh, DBA > >================================================ >To change your subscription options or to [...] 6341 130 31_Re: SnapShot - recovery options12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 30 Dec 1999 11:57:48 -0800480_us-ascii The question is not clear to me. It would be more helpful if you describe your objective than an implementation. I included a number of possibilities I've heard before in the discussion below.

Even when we understand what you want, we do not provide much information about dates. There is too much uncertainty in timing, and too many people take a general statement as a firm commitment. As usual, here are a couple of my opinions and some of the background. [...] 6472 27 19_Re: SAP chooses ...12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 30 Dec 1999 12:11:04 -0800499_us-ascii SAP chooses DB2

SAP and IBM announced that the award-winning IBM DB2 Universal Database will replace Oracle as the primary database on IBM, Sun and Linux platforms for internal development and production systems within SAP.

The platforms include Windows 2000,in addition to the already available solutions for Sun Microsystems, Linux, Windows NT and IBM's RS/6000, AS/400 and S/390 ... For the complete story go to http://www2.software.ibm.com/news/news.nsf/n/smum4edn6t [...] 6500 23 19_Re: SAP chooses ...16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 30 Dec 1999 15:09:37 -0600444_iso-8859-1 MISLEADING INITIAL POSTING...

Only has to do with mySAP.com Solutions on NT. IBM DB2 is the strategic and production platform for SAP development according to both SAP and IBM.

This is th full title of the anouncement:

SAP Selects Microsoft SQL Server 7.0 as Strategic Development And Production Platform for mySAP.com™ Solutions On Windows NT and Windows 2000, Offering Customers Expanded Platform Choices [...] 6524 52 56_Re: Options of Language Environment for Stored Procedure14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Fri, 31 Dec 1999 11:29:38 +1000488_us-ascii Ujjal

Depends. When LE is installed, the CEEDOPT might have been generated which contains 'default default' options. In addition, a CDDUOPT (which provides overriding defaults) might have been generated and put into one of WLM's STEPLIB libraries.

Generate a procedure/function that does nothing, but specify a run-time option of RPTOPTS(ON). When the procedure/function program finishes, a report of the options will be generated - probably to DDname=SYSOUT. [...] 6577 170 27_Re: Ignore Duplicate Rows ?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Sat, 31 Dec 1994 11:46:05 +1000517_us-ascii This just clarifies my views re Cursor verses Singleton Select.

My benchmark tests showed that Cursor with single fetch and OPTIMIZE FOR 1 ROW used only a little extra CPU in batch over Singleton Select (the difference is more significant if SQL repeated in a loop due to lookaside reducing Getpage component), but also used less CPU than Singleton Select in some cases where Singleton Select had a bad access path or had to scan a long way looking for a second row (even when there wasn't one). [...] 6748 47 68_Tuning PeopleSoft on DB2 for OS/390 - Atlanta Class 1/17 - 1/18/200013_Brian Holroyd31_Brian_Holroyd@DB-CONSULTING.COM31_Thu, 30 Dec 1999 17:46:39 -0800113_iso-8859-1 Space is available in this class.

For registration and information, go to www.db-consulting.com 6796 21 31_Re: DB2 for OS/390 Y2K coverage10_Ken Koleto23_kkoleto@PAINEWEBBER.COM31_Thu, 30 Dec 1999 21:03:10 -0500468_us-ascii Nice to have company on the o'dark-thirty hours. I'll be here 'till 0700 EST, and again on 1/1 at 0700. Coverage is lighter tonight, but ramps up tomorrow and through the week-end.

Ken

'my opinions only'

================================================ 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. 6818 15 12_INFO REFCARD0_20_johan.bijnens@ALZ.BE31_Fri, 31 Dec 1999 08:54:39 +0200303_us-ascii Johan Bijnens@ALZ 31/12/99 08:54

INFO REFCARD

================================================ 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. 6834 15 18_LISTSERV nodigest"0_20_johan.bijnens@ALZ.BE31_Fri, 31 Dec 1999 08:52:52 +0200304_us-ascii Johan Bijnens@ALZ 31/12/99 08:52

SET NODIGests

================================================ 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. 6850 15 18_LISTSERV nodigest"0_20_johan.bijnens@ALZ.BE31_Fri, 31 Dec 1999 09:11:58 +0200306_us-ascii Johan Bijnens@ALZ 31/12/99 09:11

SET DB2-L NODIG

================================================ 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. 6866 40 19_Re: SAP chooses ...22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 31 Dec 1999 07:20:48 +0000469_ISO-8859-1 Richard that sounds a lot clearer now .. Les



______________________________ Reply Separator _________________________________ Subject: Re: SAP chooses ... Author: Richard A Yevich at Internet Date: 12/30/99 3:09 PM



MISLEADING INITIAL POSTING...

Only has to do with mySAP.com Solutions on NT. IBM DB2 is the strategic and production platform for SAP development according to both SAP and IBM. [...] 6907 12 38_How's the Y2K bug in Australia (grin)?11_Paul Turpin26_Paul.Turpin@FIRSTUNION.COM31_Fri, 31 Dec 1999 07:23:38 -0800423_- Since the clock just struck midnight in Australia I wondered in anyone down under can tell us that all is well. I saw the fireworks on TV and the lights were still working (GRIN).

================================================ 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. 6920 67 42_Re: How's the Y2K bug in Australia (grin)?0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 31 Dec 1999 21:35:01 +0800302_us-ascii Well it's 21.34 as I post this, and we're GMT + 8 in Western Australia. So far our nightly processing is going well (for next day of 01/01/2000).

I'll post an update later if time permits - and I'm still awake.... :)

No reports of disaster from the Eastern States so far... [...] 6988 15 30_IBM Y2K Proactive information-16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Fri, 31 Dec 1999 08:34:06 -0500311_us-ascii FYI http://www-4.ibm.com/software/year2000/alert/

Tom

================================================ 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. 7004 15 42_IBM Y2K proactive information/notification16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Fri, 31 Dec 1999 08:37:44 -0500348_us-ascii FYI http://www-4.ibm.com/software/year2000/alert/

Have a Happy - See you Next Century!!!!!

================================================ 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. 7020 44 42_Re: How's the Y2K bug in Australia (grin)?12_SAPKIN, Mike32_Mike.SAPKIN@SUNCORPMETWAY.COM.AU30_Sat, 1 Jan 2000 00:28:35 +1000662_- We clicked over 25 minutes ago and our tests on DB2 show everything is OK...as was expected

Mike Sapkin Database Consultant Database, Process and Testing Support Application Specialist Services Suncorp-Metway Ltd Ph (07) 3835 5493 Fax (07) 383 61667 E-mail: Mike.SAPKIN@suncorpmetway.com.au



> -----Original Message----- > From: Paul Turpin [SMTP:Paul.Turpin@FIRSTUNION.COM] > Sent: Saturday, 1 January 2000 1:24 > To: DB2-L@RYCI.COM > Subject: How's the Y2K bug in Australia (grin)? > > Since the clock just struck midnight in Australia I wondered in anyone > down under can tell us that all is well. I saw the fireworks on TV and > [...] 7065 74 33_Re: How many DBAs does it take...11_James Drewe20_James.Drewe@AEXP.COM31_Fri, 31 Dec 1999 08:54:58 -0700447_- Lynne

If you were asking for an informal answer, it would seem that you need more staff -- either full time employees or contract workers. The diversity of DBMSes and platforms seem to indicate a need there. A more complete answer would depend on your actual data base volume, both current and forecasted. There can alsobe a problem when program developers design the structures that lead to data quality issues and low reusability. [...] 7140 60 42_Re: How's the Y2K bug in Australia (grin)?17_suthep thampranee18_suthepth@SCB.CO.TH30_Sat, 1 Jan 2000 00:16:21 -0000664_Windows-874 NOW WE'RE TESTING BATCH AND ONLINE.THE DB2 UTILITIES ARE O.K.

---------- > From: SAPKIN, Mike > To: DB2-L@RYCI.COM > Subject: Re: How's the Y2K bug in Australia (grin)? > Date: 31 ¸Ñ¹ÇÒ¤Á 2542 14:28 > > We clicked over 25 minutes ago and our tests on DB2 show everything is > OK...as was expected > > Mike Sapkin > Database Consultant > Database, Process and Testing Support > Application Specialist Services > Suncorp-Metway Ltd > Ph (07) 3835 5493 Fax (07) 383 61667 > E-mail: Mike.SAPKIN@suncorpmetway.com.au > > > > -----Original Message----- > > From: Paul Turpin [SMTP:Paul.Turpin@FIRSTUNION.COM] > [...] 7201 43 42_Re: How's the Y2K bug in Australia (grin)?0_29_Greg.Palgrave@BANKWEST.COM.AU30_Sat, 1 Jan 2000 01:32:22 +0800488_us-ascii 01.30 am <*Yawn!*> (GMT + 8) and all's well. DB2 humming along on OS/390. DB2 UDB trundling along on NT. DBA chugging away on coffee :)

Just running through our checklist, but no problems to report.

Good luck to everyone else, may Y2K be a non-event for you as well.



Greg Palgrave Database Administration Group Information Services, Level 10, Tower Bank of Western Australia eMail : greg.palgrave@bankwest.com.au [...] 7245 15 3_Y2K17_suthep thampranee18_suthepth@SCB.CO.TH30_Sat, 1 Jan 2000 00:55:32 -0000315_Windows-874 HI ALL DB2 OS/390 IS O.K. IN THAILAND. JOE(SUTHEP THAMPRANEE)

================================================ 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. 7261 13 40_Dumb FTP question (ftp.software.ibm.com)11_Kurt Rompot21_RompotK@SCHNEIDER.COM31_Fri, 31 Dec 1999 12:29:36 -0600378_us-ascii Trying to establish an anonymous FTP session to ftp.software,ibm.com. It prompts me for a "Gateway Password". How do I respond?

================================================ 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. 7275 22 44_Re: Dumb FTP question (ftp.software.ibm.com)13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 31 Dec 1999 13:37:54 -0500587_iso-8859-1 >Trying to establish an anonymous FTP session to ftp.software,ibm.com. It >prompts me for a "Gateway Password". How do I respond?

Usually the anonymous FTP sites ask you to enter your email address as your password.

Try that.

David Seibert Compuware Corporation File-AID product planner Dave_Seibert@compuware.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. 7298 39 44_Re: Dumb FTP question (ftp.software.ibm.com)0_17_dodge@DISISIT.COM31_Fri, 31 Dec 1999 13:00:41 -0600604_- put in anything terminanated with a @.

such as

a@





In , on 12/31/99 at 12:29 PM, Kurt Rompot said:

>Trying to establish an anonymous FTP session to ftp.software,ibm.com. It >prompts me for a "Gateway Password". How do I respond?

>================================================ >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. [...] 7338 19 27_Istanbul, Turkey Calling...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Sat, 1 Jan 2000 00:43:58 +0200494_- So far so good!!! It's still up and working..Utilities are Ok, Batch and Online Access has no problem..

:-))

Cüneyt GÖKSU GARANTI TEKNOLOJI Tel : 0090-212-657 0404 Ext: 1218 mailto:Cuneytg@garanti.com.tr Visit : http://www.kultur.gov.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. 7358 43 31_Re: Istanbul, Turkey Calling...14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 31 Dec 1999 17:54:38 -0800430_us-ascii Cuneyt, Thanks for the heads up. Happy Millenium!!! Phil Reading, Pennsylvania USA

Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner

-----Original Message----- From: Cuneyt Goksu (Garanti Teknoloji) [SMTP:CuneytG@GARANTI.COM.TR] Sent: Friday, December 31, 1999 2:44 PM To: DB2-L@RYCI.COM Subject: Istanbul, Turkey Calling... [...] 7402 12 49_I missed the News from Australia on the rollover?0_20_John_Lendman@FPL.COM31_Fri, 31 Dec 1999 18:30:37 -0500269_us-ascii What was the news?

================================================ 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. 7415 14 31_Y2K Update from DB2 Development28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Fri, 31 Dec 1999 15:26:22 PST426_- New Zealand, Australia, SE Asia and Japan report no activity and a very uneventful Y2K roll over. So far the extended coverage is suffering from nothing more than boredom.

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. 7430 35 53_Re: I missed the News from Australia on the rollover?16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 31 Dec 1999 17:41:56 -0600707_iso-8859-1 There was none. As predicted, worldwide so far, 6:30 PM Eastern, nothing of significance. Couple nasty rumors, but nothing substantiated.

Richard Yevich

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > John_Lendman@FPL.COM > Sent: Friday, December 31, 1999 5:31 PM > To: DB2-L@RYCI.COM > Subject: I missed the News from Australia on the rollover? > > > What was the news? > > ================================================ > 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. > [...] 7466 59 29_How many DBAs does it take...12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Fri, 31 Dec 1999 18:44:27 -0500548_ISO-8859-1 Lynn,

I'm speaking from my own experience when I say the best thing you can do for yourself is to MAKE THE TIME to learn how to use those tools. I can sympathise with your comment about not having the time, but the same scenario works in the other direction if you get it started that way. The maintaining and caring for DB2 databases part of the DBA's job is greatly reduced in the time and effort required once you start utilizing those tools, thus leaving more time for the other aspects of the DBA's job. We now have the [...] 7526 37 54_Y2K in Italy: a first report from CESVe, Padua, Italy.14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 1 Jan 2000 01:23:25 +0100359_us-ascii Nice to meet you on DB2-l ! It survived to Y2k bug !!

Ok, we tested a first part of application (POS & bancomat, something like credit cards), DB2

v. 5 and OS/390 v 2.5, with some DB2 utilities....and all seems to work well.

Later in the night some heavy batch and utilities will be started, so a second report will follow. [...] 7564 56 58_Re: Y2K in Italy: a first report from CESVe, Padua, Italy.14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 31 Dec 1999 19:32:42 -0800376_us-ascii Thanks Max. Regards, Phil

Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner

-----Original Message----- From: Max 'Guderian' [SMTP:mocion@LIBERO.IT] Sent: Friday, December 31, 1999 4:23 PM To: DB2-L@RYCI.COM Subject: Y2K in Italy: a first report from CESVe, Padua, Italy. [...] 7621 72 35_Re: Y2K in Italy: another report...14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT30_Sat, 1 Jan 2000 01:45:05 +0100619_- Everything Ok also here : OS390 1.3, Cics 4.1, DB2 4.1 and so on

.... hoping it will be so easy with applications....



> -----Messaggio originale----- > Da: Philip Gunning [SMTP:pgunning@boscovs.com] > Inviato: Saturday, January 01, 2000 4:33 AM > A: DB2-L@RYCI.COM > Oggetto: Re: Y2K in Italy: a first report from CESVe, Padua, Italy. > > Thanks Max. Regards, Phil > > Philip K. Gunning > DB2 DBA > IBM Certified Solutions Expert -- DB2 UDB > IBM Cetfified Solutions Expert -- CICS TS > Assoc List Owner > > -----Original Message----- > From: Max 'Guderian' [SMTP:mocion@LIBERO.IT] > Sent: [...] 7694 94 35_Re: Y2K in Italy: another report...14_Philip Gunning20_pgunning@BOSCOVS.COM31_Fri, 31 Dec 1999 19:51:17 -0800378_us-ascii Glad to hear it Franco, Happy New Year

Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner

-----Original Message----- From: Masone, Franco [SMTP:F.Masone@CEDACRIOVEST.IT] Sent: Friday, December 31, 1999 4:45 PM To: DB2-L@RYCI.COM Subject: Re: Y2K in Italy: another report... [...] 7789 26 18_Any news from U.K?13_Deepak Kini M21_deepakk@WIPHYD.GE.COM30_Sat, 1 Jan 2000 10:31:14 +0530726_Windows-1252 *************************************************************************** Deepak Kini M GE CBD Insurance Wipro-GE Offshore Development Center Wipro Technologies 1-8-448, Lakshmi Building S.P. Road, Begumpet, Secunderabad - India Tel : 91-40-7896008, Extn : 4519 Fax: 91-40-7896123 E-mail:Deepak.MKini@wipro.com deepakk@wiphyd.ge.com The World's First SEI CMM Level 5 Software Services Company ****************************************************************************

================================================ 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. 7816 22 22_Y2K Update from US EST14_Philip Gunning20_pgunning@BOSCOVS.COM30_Sat, 1 Jan 2000 00:13:07 -0500544_us-ascii Just finished testing utilities, backups, QMF, Platinum tools at 97f tape and all is well so far. Have additiona testing to complete. Regards, Phil

Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner Reading, Pa

================================================ 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.