1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2001, week 4 2 32 41_Re: Different results in program vs SPUFI13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 22 Jan 2001 00:20:34 -0600554_- On Fri, 19 Jan 2001 21:31:31 -0600, Terry Purcell wrote:

>Mohammad, > >The standard question to this is: Did you populate the host variable before >the OPEN CURSOR or before the FETCH? > >But the fact that you mention the INTO implies a singleton select.

Yes it's a siglton select as I'm only interested in SQLCODE. The first line of display is displaying the host variable actually used. The second line is for another variable while the third line is a display of SQLCODE straight from SQLCA structure. [...] 35 101 33_Re: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 22 Jan 2001 11:41:46 +0530519_- Dave, I am not sure ' ABC' will take the first two bytes as length. It is hard to disagree with you that is why i am asking : Are you sure that it will give -311 as the SQLCODE if the size of the VARCHAR field in your example is 5. I think length is to be explicitly specified and that too to the separate COMP variables in the cobol programs. Normally, for the VARCHAR defined fields the DCLGEN degenerated will be containing the LEN and TEXT portion of the VARCHAR column which will be something like this.... [...] 137 93 25_Re: Sync of two Databases0_18_mebert@AMADEUS.NET31_Mon, 22 Jan 2001 09:47:26 +0100469_us-ascii You can use ADRDSSU COPY to copy DB2 tablespaces/indexes but it will always copy the allocated space. According to the docu, and my experiments, there is no way to make it copy the used space only. It seems you can use COPY to copy to pre-allocated target files: but they need to have the same name as the source files, so this doesn't work in an SMS environment, and I did not check this further. I cannot say whether this would copy only the used part. [...] 231 72 41_Re: Connections (not threads) running out13_Tony Hurlston26_Tony.Hurlston@ZURICH.CO.UK31_Mon, 22 Jan 2001 09:20:44 -0000833_iso-8859-1 CTHREAD=1500



Regards

Tony -----Original Message----- From: LOMBARD,Shaun Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: 21 January 2001 23:40 Subject: Re: Connections (not threads) running out



>Tony, > >What is the value for CTHREAD (Maximum concurrent threads) ? > >Shaun > >-----Original Message----- >From: Tony Hurlston [mailto:Tony.Hurlston@ZURICH.CO.UK] >Sent: Friday, 19 January 2001 20:39 >To: DB2-L@RYCI.COM >Subject: Connections (not threads) running out > > >List, > >I am currently experiencing connection problems (IDBACK) with a DB2 V5 >System. > >The problem centres around Omegamon reporting that 99% of all background >connections are used (IDBACK=1200) yet >the display of Active Connections totals around [...] 304 26 0_14_Bilal YILDIRIM25_byildirim@HALKBANK.COM.TR31_Mon, 22 Jan 2001 11:43:56 +0200437_iso-8859-1 Hi all, We are using IBM db2 version 5.1.Now planning to upgrade our disk to ESS Shark and using PPRC in two Sharks,(Also using Flashcopy,etc..) and Db2 5.1 is not compatible with PPRC , I am not sure Anyone has comment about it,and solutions also Please share me.

Regards.



------------------------- Bilal YILDIRIM Db2 Administrator Halkbank 2000 byildirim@halkbank.com.tr ------------------------- [...] 331 41 0_33_=?iso-8859-1?Q?R.teoman_KO=C7ER?=22_tkocer@HALKBANK.COM.TR31_Mon, 22 Jan 2001 12:30:05 +0200548_iso-8859-1 you can not use suspend-resume option of pprc unless you can upgrade to v6 -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Bilal YILDIRIM Sent: 22 Ocak 2001 Pazartesi 11:44 To: DB2-L@RYCI.COM Subject:



Hi all, We are using IBM db2 version 5.1.Now planning to upgrade our disk to ESS Shark and using PPRC in two Sharks,(Also using Flashcopy,etc..) and Db2 5.1 is not compatible with PPRC , I am not sure Anyone has comment about it,and solutions also Please share me. [...] 373 35 41_Running BIND/REBIND from within a program13_Tim K. Larsen23_tim-kent.larsen@UBS.COM31_Mon, 22 Jan 2001 11:53:39 +0100523_US-ASCII Greetings list,

how would you run BIND/REBIND's from within a program ?

I'm currently doing some work on automating our change process and as part of that I would also like to run DB2 BINDs under the control of the automation-program. The structure is like this:

DSN myprog BIND/REBIND

I'm not to keen on launching another DSN processor under my program to run the BINDs and REBINDs... and I'm not to keen on running DSN in a subsequent job-step and "pipe" the control statements. [...] 409 127 33_Re: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 22 Jan 2001 15:39:21 +0530528_- Dave, At the same time what you are talking regarding ' ABC' is true for LOAD utility using the flat file for VARCHAR data. If the positions etc are all right then the LOAD may fail but still there is no question of -311

Regards, Sanjeev

> -----Original Message----- > From: S, Sanjeev (CTS) > Sent: Monday, January 22, 2001 11:40 AM > To: 'DB2 Data Base Discussion List' > Subject: RE: Insert & Update using VARCHAR > > Dave, > I am not sure ' ABC' will take the first two bytes as length. It is hard > to [...] 537 39 22_Re: DB2 Books for PL/110_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 22 Jan 2001 05:03:55 -0600347_- So far as I'm aware, there aren't any IBM manuals specifically for PL/1 and DB2. If there were, then they would only be duplicating information found in other manuals. There are few additional considerations for embedding SQL in PL/1 programs compared with to other traditional languages, e.g. (or i.e.) Assembler and (particularly) COBOL. [...] 577 44 41_Re: Different results in program vs SPUFI10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 22 Jan 2001 05:12:23 -0600622_- What is the data type of the column you are comparing to the host variable (WPJ_TITLE_NO, I assume), and of the host variable itself?

On Mon, 22 Jan 2001 00:20:34 -0600, Mohammad Khan wrote:

>On Fri, 19 Jan 2001 21:31:31 -0600, Terry Purcell > wrote: > >>Mohammad, >> >>The standard question to this is: Did you populate the host variable before >>the OPEN CURSOR or before the FETCH? >> >>But the fact that you mention the INTO implies a singleton select. > >Yes it's a siglton select as I'm only interested in SQLCODE. The first line >of display is [...] 622 72 25_??: suspend-resume option19_Alekos Papadopoulos13_apapad@NBG.GR31_Mon, 22 Jan 2001 13:47:35 +0200392_iso-8859-1 As far as I remember, suspend-resume option is available as a usermod in DB2 V5, through a PTF in DB2 V6 and is (will be) standard in V7.

Alekos Papadopoulos M.Sc. System DB Administrator National Bank of Greece

-----Αρχικό μήνυμα----- Από: R.teoman KOCER [mailto:tkocer@HALKBANK.COM.TR] Αποστολή: Δευτέρα, 22 Ιανουαρίου 2001 12:30 μμ Προς: DB2-L@RYCI.COM Θέμα: [...] 695 45 0_19_Ajay_Kizhakkekappil30_Ajay_Kizhakkekappil@SATYAM.COM31_Mon, 22 Jan 2001 16:58:17 +0530605_- dont think DB2V5 has any compatibility issues with PPRC. However ESS should be able to support PPRC. If it currently doesnot support, then a ESS microcode upgrade would be needed.

Thanks, Ajay



> ---------- > From: Bilal YILDIRIM[SMTP:byildirim@HALKBANK.COM.TR] > Reply To: DB2 Data Base Discussion List > Sent: Monday, January 22, 2001 3:13 PM > To: DB2-L@RYCI.COM > > Hi all, > We are using IBM db2 version 5.1.Now planning to upgrade our disk to > ESS Shark and using PPRC in two Sharks,(Also using Flashcopy,etc..) > and Db2 5.1 is not compatible with PPRC , I am not sure [...] 741 27 26_Need help with DB2 connect14_Anton Larionov22_anton_larionov@MAIL.RU31_Mon, 22 Jan 2001 05:52:55 -0600615_- Hallo! I'm is beginner with DB2 product. In my company use DB2/400 as DB server. We develop applications on LINUX Red Hat 6.0 server. I install "DB2 Connect Personal Edition 7.1 for LINUX" and try to connectining to AS/400. Instalation finished without errors, but when i trying connecting to extrern DB on AS/400 i get message "SQL1400N Authentication not supported" . I change Aythentication type in DB manager to Server, Client , DCS... Without any effect... Connecting to local DB is established. We use TCPIP protocol(PING work good). I try to resolve problem almost week, reading and searching in web, [...] 769 59 33_Re: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Jan 2001 07:12:26 -0500531_iso-8859-1 Thanks for your thoughts, Sanjeev.

Here is the Cobol code upon which I base my obersvatsions: ---------------------------- ... 01 DCLSTAFF. 10 STAFF-ID PIC S9(4) USAGE COMP. 10 STAFF-NAME. 49 STAFF-NAME-LEN PIC S9(4) USAGE COMP. 49 STAFF-NAME-TEXT PIC X(9). 10 STAFF-DEPT PIC S9(4) USAGE COMP. 10 STAFF-JOB PIC X(5). 10 STAFF-YEARS PIC S9(4) USAGE COMP. 10 STAFF-SALARY PIC S9(5)V9(2) USAGE COMP-3. 10 STAFF-COMM PIC S9(5)V9(2) USAGE COMP-3. ***************************************************************** [...] 829 97 74_Re: Question about replication from DB2 OS/390 V5.1 to DB2 UDB Un ix V 7.113_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 22 Jan 2001 07:22:03 -0500682_us-ascii What version of UDB? 6.1 or 7.1?

Thanks!



Lynne A. Flatley New England Financial (617) 578-4079 (work) (781) 718-0919 (cell) lflatley@nefn.com



> -----Original Message----- > From: McClendon, Rick [SMTP:RMcClendon@ADMIN.FSU.EDU] > Sent: Thursday, January 18, 2001 4:00 PM > To: DB2-L@RYCI.COM > Subject: Re: Question about replication from DB2 OS/390 V5.1 to DB2 > UDB Un ix V 7.1 > > We are replicating from os/390 v 5.1 to UDB AIX. > Rick McClendon - F.S.U. > > -----Original Message----- > From: rick creech [mailto:ykcirc@HOTMAIL.COM] > Sent: Thursday, January 18, 2001 3:52 PM > To: DB2-L@RYCI.COM > Subject: Re: Question about [...] 927 71 21_Re: Using REXX in QMF13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM31_Mon, 22 Jan 2001 07:23:17 -0500349_us-ascii Dave, I have never written a QMF PROC that contains REXX code. If you look at the examples using REXX in the QMF manuals, it is the reverse. REXX calls QMF. I have written REXX programs that call QMF. I am able to pass variables to QMF that were passed from the JCL that I am running. Here is a portion of the REXX program that I use: [...] 999 49 45_Re: Running BIND/REBIND from within a program10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 22 Jan 2001 06:44:22 -0600442_- By setting yourself these restrictions, you're narrowing down your options considerably. I wouldn't rule out the option of building your control statements in one step/job and running them in another so quickly. This approach is widely adopted, and pays dividends in terms of simplicity of processing, performance, and 'restartability'.



On Mon, 22 Jan 2001 11:53:39 +0100, Tim K. Larsen wrote: [...] 1049 22 41_Re: Different results in program vs SPUFI19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Mon, 22 Jan 2001 07:54:46 EST542_us-ascii Mohammed,

I have not seen all the responses to your posting but I would suggest to see if you are using any host variable in your predicates that might belong to a File Section (FD) definition.

Regards,

Rajeev P. Dhanawade Phone: 302-577-4659 ext. 221 Fax : 302-577-4454

================================================ 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. 1072 98 33_Re: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 22 Jan 2001 18:10:13 +0530396_- Sorry for not coding the 49 Levels, instead coding the 05. I should have taken care of that as well(More of Sqlcode concentration rather than COBOL and precompliation). Thanks for this correction.

Dave, this is interesting as i have not faced this. I will do some experiments and get back to the list. In the mean time we would definitely find some more comments on our discussion. [...] 1171 19 24_Version 7 NT UDB Fixpak212_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 22 Jan 2001 07:11:46 -0600529_iso-8859-1 I was not able to unzip FP2_WR21229.zip using the pkunzip.exe that was in fixpak2 I had to use winzip32.

Anyone else have this problem?

We don't have winzip on all of our systems so it would be nice if a pkunzip.exe that worked would be packaged with the fixpak.

================================================ 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. 1191 30 41_DB2 Visual Explain - authorisation needed15_Pierre Dagenais19_pdagenai@UOTTAWA.CA31_Mon, 22 Jan 2001 08:21:30 -0500395_us-ascii Hi

Here is my opinion on this subject.

Why don't we ask IBM to create a new system privilege called "EXPLAIN"

This privilege would enable the grantee to execute the explain command without having privilege on the table(s) of the sql statement inside the explain command.

I believe it would enhance the use of Visual explain in production by developers. [...] 1222 67 20_Re: QUIESCE QUESTION11_Brazil, Pat27_PBrazil@MIDATLANTIC.AAA.COM31_Mon, 22 Jan 2001 08:34:01 -0500396_- What happens if the job step does fail? Does a DBA have to get involved or have you established some type of automation so that Operations can handle the recovery?

Pat



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Bill Happel Sent: Friday, January 19, 2001 5:21 PM To: DB2-L@RYCI.COM Subject: Re: QUIESCE QUESTION [...] 1290 31 33_Re: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Jan 2001 08:37:03 -0500390_iso-8859-1 Hi Sanjeev.

Yes, what I am describing is from real testing done years ago and repeated moments ago. For me this started about 6 years ago when a very bright programmer told me that I was enforcing unnecessary coding standards when I told developers that they needed to supply a length for varchar inserts or updates. He claimed he had test results showing otherwise. [...] 1322 24 43_Anyone using DPROP to move IMS data to DB2?14_Bernie OConnor26_Bernie.OConnor@ANIXTER.COM31_Mon, 22 Jan 2001 04:43:04 -0600486_- We are thinking about using the IMS DPROP tool to move data from IMS to DB2. Subsequently, we are considering using DPROPR from DB2 v6 on OS/390 to DB2 V7 for NT.

I am especially interested in any experiences on the IMS DPROP tool. Its initial appeal is that since it is log-based, it will let us avoid intruding into old code to change logic for downstream applications. We are unsure about ease of use and reliability. Any news on tricks and traps would be appreciated. [...] 1347 149 37_Re: Stored procedures and auto-rebind12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 22 Jan 2001 05:49:10 -0800604_us-ascii It is PQ43444. They're fixing several aspects in this PTF. (Just got INFOLINK back). --- "LAM, Leo" wrote: > Myron, > Thanks for the info. > I found APAR PQ43444 but it's more related to SPB. > I couldn't find the APAR > you mentioned about invalidating packages when a > stored procedure is > dropped. > > Regards > Leo > > -----Original Message----- > From: Myron Miller [mailto:myronwmiller@YAHOO.COM] > Sent: Thursday, 18 January 2001 23:22 > To: DB2-L@RYCI.COM > Subject: Re: Stored procedures and auto-rebind > > > My interpretation of what IBM told me about this [...] 1497 17 21_Re: Using REXX in QMF10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 22 Jan 2001 14:48:11 +0100365_us-ascii In db2-l documents there's one example of REXX & QMF I've never seen the reverse.

Regards

Max Scarpa

================================================ 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. 1515 14 44_Monitoring Storage in the DBM1 address space10_Tom Glaser14_tg5444@SBC.COM31_Mon, 22 Jan 2001 07:56:27 -0600361_- We have encountered several subsystem failures where IBM has read the dump and indicated the problem looks like we don't have enough storage. There response was for us to "monitor free storage availability in dbm1 address space." Does anyone have any suggestions on how to go about performing this function? We are using DB2 PM and Tmon/DB2. Thanks, Tom [...] 1530 39 48_Re: Monitoring Storage in the DBM1 address space11_rick creech18_ykcirc@HOTMAIL.COM31_Mon, 22 Jan 2001 08:11:29 -0600670_- Hi,

If you also have TMON/MVS you can keep an eye on Working Set Size(WS).

HTH,

Rick Creech



>From: Tom Glaser >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Monitoring Storage in the DBM1 address space >Date: Mon, 22 Jan 2001 07:56:27 -0600 > >We have encountered several subsystem failures where IBM has read the dump >and indicated the problem looks like we don't have enough storage. There >response was for us to "monitor free storage availability in dbm1 address >space." Does anyone have any suggestions on how to go about performing >this function? We are using [...] 1570 39 48_Re: Monitoring Storage in the DBM1 address space15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Mon, 22 Jan 2001 08:20:51 -0600474_iso-8859-1

Try Pool Advisor for DB2 from BMC Software. It has the full report on DBM1 storage that IBM tells you how to get from about 5 different sources. It also has a lot of other goodies!



Andy Lankester BMC Software ltd

-----Original Message----- From: Tom Glaser [mailto:tg5444@SBC.COM] Sent: 22 January 2001 13:56 To: DB2-L@RYCI.COM Subject: Monitoring Storage in the DBM1 address space [...] 1610 45 25_Re: Sync of two Databases12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Mon, 22 Jan 2001 09:55:53 -0500527_us-ascii Sri Sri I believe you(if you are the original poster) said they are user defined datasets. If you are familiar with REXX I would use the CATALOG SEARCH INTERFACE as documented in DFSMS/MVS Version 1 Release 5 managing catalogs appendix D to create IDCAMS define statements for your test database datasets based on the production database datasets. There are samples in SYS1.SAMPLIB(IGGCSIxx) for both REXX and ASM. I have used this technique to determine define parameters based on current useage. Good luck. HTH [...] 1656 11 33_Re: INSERT & UPDATE USING VARCHAR0_27_Bud.Greenman@ONONDAGA.NY.US31_Mon, 22 Jan 2001 09:58:37 -0500344_- Also if you are using PL/1 instead of COBOL a datatype of CHAR (12) VARYING will provide the length.

================================================ 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. 1668 35 48_Re: Monitoring Storage in the DBM1 address space10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 22 Jan 2001 16:00:38 +0100382_us-ascii Hi Tom.....If I can suggests:

Take a look at:

DB2 UDB for OS/390 Storage Management (in Solution Journal - Spring 2000 Vol 7, Number 1) by John Campbell & Mary Petras

It's a good article were it's described DB2 storage allocation (How and when).....and there are some suggestions for storage tuning....(and take a look at Chuck Hoover's articles) [...] 1704 43 0_19_Ajay_Kizhakkekappil30_Ajay_Kizhakkekappil@SATYAM.COM31_Mon, 22 Jan 2001 15:26:15 +0530587_- I dont think DB2V5 has any compatibility issues with PPRC. However ESS should be able to support PPRC. If it currently doesnot support, then a ESS microcode upgrade would be needed.

Thanks, Ajay > ---------- > From: Bilal YILDIRIM[SMTP:byildirim@HALKBANK.COM.TR] > Reply To: DB2 Data Base Discussion List > Sent: Monday, January 22, 2001 3:13 PM > To: DB2-L@RYCI.COM > > Hi all, > We are using IBM db2 version 5.1.Now planning to upgrade our disk to > ESS Shark and using PPRC in two Sharks,(Also using Flashcopy,etc..) > and Db2 5.1 is not compatible with PPRC , I am not [...] 1748 35 38_DB2 for OS/390 and the support of Java12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 22 Jan 2001 16:24:35 +0100720_iso-8859-1 Hello Listers,

just a short question: We all know that DB2 for OS/390 supports JAVA. In which version the Java support was introduced ?

Thanks for any advice.

With kind regards - mit freundlichen Grόssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- [...] 1784 134 26_Re: FW: RDS Limit Exceeded16_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Mon, 22 Jan 2001 07:37:26 -0800578_us-ascii I'm not sure if you've rec'd a response to this, but I believe it is PQ15670.

Alison Pelletier Discover Financial Services --- "Lorenz, Don" wrote: > Susan, > > We looked at PQ19045, but that is not the correct > APAR. We may have missed > it, but we did not find a hit related to index > screening. Can someone in the > list provide the APAR? > > We are DB2 V5, PUT level 0003.....going to 0008 or > 0011 shortly....on our > legacy systems. > > Regards, > > -----Original Message----- > From: Susan Lawson [mailto:lawson_susan@YAHOO.COM] [...] 1919 42 20_Declared Temp Tables13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Mon, 22 Jan 2001 09:51:44 -0600572_iso-8859-1 Dear List,

This past weekend, I put into our production system the first program to take advantage of the new V6 'Declared Temporary Tables'. The program is relatively high use CICS transaction. The program declares the temp table at the beginning, uses the table and then drops the table before returning to CICS. After about two hours of heavy use, the transaction started getting -904 on the TEMP database. After some research, it was determined that the DBD for the TEMP database had grown to DATABASE = DSCTEMP STATUS = RW DBD LENGTH = 6687068 [...] 1962 37 28_Re: Version 7 NT UDB Fixpak213_Ellen Richter19_e2richte@HEWITT.COM31_Mon, 22 Jan 2001 09:35:52 -0600436_us-ascii Yes...we had the same problem. Used PKZIP for Windows product ...........





From: "Martin, Paul" on 01/22/2001 07:11 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Client: Subject: Version 7 NT UDB Fixpak2

I was not able to unzip FP2_WR21229.zip using the pkunzip.exe that was in fixpak2 I had to use winzip32. [...] 2000 44 45_Re: DB2 Visual Explain - authorization needed13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Mon, 22 Jan 2001 10:43:04 -0500598_- Has anyone tried using the BINDAGENT authority to see if that will allow the EXPLAIN?

Dave Kenski

> -----Original Message----- > From: Pierre Dagenais [SMTP:pdagenai@UOTTAWA.CA] > Sent: Monday, January 22, 2001 8:22 AM > To: DB2-L@RYCI.COM > Subject: DB2 Visual Explain - authorisation needed > > Hi > > Here is my opinion on this subject. > > Why don't we ask IBM to create a new system privilege called "EXPLAIN" > > This privilege would enable the grantee to execute the explain command > without having > privilege on the table(s) of the sql statement inside the explain > [...] 2045 34 45_Re: Running BIND/REBIND from within a program13_Tim K. Larsen23_tim-kent.larsen@UBS.COM31_Mon, 22 Jan 2001 16:53:33 +0100534_US-ASCII John could you elaborate on "performance" benefits ?

True - the "pipe to a subsequent step/task" approach is simpler, commonly used and ofcourse still a runner-up.

I will however be invoked under control of another software package, and being able to run in 1 step will give me some advantages in terms of control over the entire process as well as "co-existing" with the other software package. Therefore the option of running BIND under my control must be evaluated before a design decision can be made. [...] 2080 44 45_Re: DB2 Visual Explain - authorization needed13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Mon, 22 Jan 2001 10:44:33 -0500603_- Has anyone tried the BINDAGENT authorization to see if that allows the EXPLAIN?

Dave Kenski

> -----Original Message----- > From: Pierre Dagenais [SMTP:pdagenai@UOTTAWA.CA] > Sent: Monday, January 22, 2001 8:22 AM > To: DB2-L@RYCI.COM > Subject: DB2 Visual Explain - authorisation needed > > Hi > > Here is my opinion on this subject. > > Why don't we ask IBM to create a new system privilege called "EXPLAIN" > > This privilege would enable the grantee to execute the explain command > without having > privilege on the table(s) of the sql statement inside the explain > command. > [...] 2125 46 48_Re: Monitoring Storage in the DBM1 address space10_Tom Taylor17_ttaylor@CHUBB.COM31_Mon, 22 Jan 2001 10:49:36 -0500313_us-ascii We use omegamon. peek at the address space and then use the 'amap' function. the available space 'ELSQA/SWA/USER' should let you know how close you are to the 2 gig limit. IBM has recommended a 250 meg buffer for those occasiaonal problematic threads. Make sure you use 'constor' zparm this helps . [...] 2172 74 45_Re: DB2 Visual Explain - authorization needed11_Suresh Sane21_data_arch@HOTMAIL.COM31_Mon, 22 Jan 2001 09:59:48 -0600470_- David,

The problem with BINDAGENT is that it allows a user to bind a package/plan. For most programmers, this would be too much authority since they will be able to not only explain a production program but also be able to bind it (without the underlying authority to the tables). Clearly, we need another auth group like BINDAGENT. I propose EXPLAINAGENT (OK, IBM developers, can we have it in V7?) that will allow an explain only but not a package/plan. [...] 2247 28 24_Re: Declared Temp Tables13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Jan 2001 11:08:51 -0500382_iso-8859-1 Hi Scott, I have seen the VSAM dataset grow in extents as I inserted more rows in the temp table. But I only had one table instance (one task) in the research experiments I was performing, so I imagine the dbd didn't grow. I noticed closing the tablespace seemed to free up the space. I don't imagine you'd have the ability to do that in such a dynamic environment. [...] 2276 63 45_Re: Running BIND/REBIND from within a program14_Toppins, Smike21_smike.toppins@GWL.COM31_Mon, 22 Jan 2001 09:09:02 -0700662_- If I'm understanding correctly for what you're asking; you should be able to accomplish this with a REXX program. You can determine/build the BIND/REBIND cards that you wish via the DSNREXX interface and then invoke the DSN command processor in the same step.



SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094



> ---------- > From: Tim K. Larsen[SMTP:tim-kent.larsen@UBS.COM] > Reply To: DB2 Data Base Discussion List > Sent: Monday, January 22, 2001 8:53 AM > To: DB2-L@RYCI.COM > Subject: Re: Running BIND/REBIND from within a program > > John could you elaborate on "performance" benefits ? > > True - the [...] 2340 55 28_Re: Version 7 NT UDB Fixpak212_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 22 Jan 2001 10:32:22 -0600417_iso-8859-1 We don't have PKZIP for windows on our workstations. It is kind of frustrating that a vendor will give you a fix for a problem, compress it, give you a program (i.e. PKUNZIP.EXE) and say use this program to unzip the compress file and expect you to go to another vendor to secure software that will in fact uncompress the fix. This isn't the first fixpak that we had to use winzip32 to uncompress it! [...] 2396 69 22_DB2 UDB v7 and OS/2 v412_David Booher22_David.Booher@QUEST.COM31_Mon, 22 Jan 2001 08:39:42 -0800367_iso-8859-1 We have been attempting (going on 4 days) to install an OS/2 v4 system with DB2 UDB EE v7. After working through our problems getting OS/2 installed, we have come to a problem with DB2 and TCPIP. The DB2 says that it does not detect any TCPIP installed in the OS/2. In fact, it is there and functioning perfectly. We can browse the web, ping, etc.... [...] 2466 79 31_Re: indexable global temp table15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Mon, 22 Jan 2001 10:46:45 -0600504_iso-8859-1 Dave,

Seeing a thread on "Declared Temp Tables" I recalled this posting of yours....

Has this been resolved? I notice that in your DDLs you are using all the default size paramaters(stogroup,priqty,secqty)...is it possible that your collegue was working with voluminous data and ran out of space or something while you were successful because you experimented with little data...I do not know how DB2 would behave under B37 conditions with dgtts...and do not want to try... [...] 2546 123 48_Re: Monitoring Storage in the DBM1 address space14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Mon, 22 Jan 2001 08:45:02 -0800568_iso-8859-1 Tom,I forget the panel in TMON, but it is something like system summary?, when you get there select the DBM1 addess space in question and it shows you all storage allocated/used. I would be careful using the "constor" ZPARM as there is overhead associated with it. Certain types of dynamic SQL when executed over and over will consume lots of storage, see if you can find the SQL and tweak it. Start by determining what programs are running when this happens. Just some ideas. We had this same problem at a site caused by certain dynamic sql. HTH Phil [...] 2670 65 33_Re: Insert & Update using VARCHAR13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 22 Jan 2001 10:47:05 -0600380_US-ASCII Hello Dave, We use assembler on OS/390. What results were you referring to ?. We always provide a 2 byte field :hv for the varchar field length, else we get the results I described. Thanks, Kurt

>>> Dave_Seibert@COMPUWARE.COM 01/20/01 09:20PM >>> >I thought in the program you must move the proper value to a length field >before issuing an Insert or Update. [...] 2736 87 23_Re: QUERYNO in V6 OS3900_22_Rohn.Solecki@MTS.MB.CA31_Mon, 22 Jan 2001 10:48:46 -0600380_us-ascii Well, better late than never. I hope (hint, hint, anyone at IBM taking notes ;-) ) that to make max use of the new feature, that they also make the QUERYNO available at run time (maybe thru SQLCA.SQLERRMC? or a new function "CURRENT QUERYNO"?) to help trouble shooting. It would provide an explicit, direct link between an error message/sqlcode and the source code. [...] 2824 62 41_Re: Different results in program vs SPUFI13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 22 Jan 2001 10:40:09 -0600599_iso-8859-1 I've seen a couple other responses to this, so I'll just toss out a couple other ideas that haven't already been mentioned that I've seen cause similar behavior - - Is this a called program with the host-variable in the linkage section? If so, try either moving the linkage-section item to working storage prior to the select (and use the working-storage variable as the host variable), or add "move 0 to sql-init-flag" to the beginning of your program. - Does the program do any data-manipulation (update/delete) prior to this call? If so, what are the chances the data has changed [...] 2887 30 33_Re: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Jan 2001 12:09:53 -0500342_iso-8859-1 Hello Kurt, Sorry I wasn't clear.

In your post last week you said: > If you do not tell DB2 the length of the varchar field it will pad >the inserts and updates with blanks to the maximum char size.

I was asking you the environment in which you see the results where DB2 will pad varchar fields to the max size. [...] 2918 41 31_Re: indexable global temp table13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 22 Jan 2001 12:13:14 -0500418_iso-8859-1 Hi Tonmoy,

Yes this has been resolved. I posted news of the resolution back on January 4th.

For the full post, try linking to http://jupiter.ryci.com/cgi/wa.exe?A2=ind0101A&L=DB2-L&P=R9437&m=20287

or go to the archives and search for indexable global.

It was posted on Thu, 4 Jan 2001 08:17:35 -0500 The subject is >> DB2 crash remedied -- Was > indexable global temp table [...] 2960 13 35_Re: Dataload for DB2 on VM question10_Wes Wright23_wesleyw@RENEWAL-IIS.COM31_Mon, 22 Jan 2001 11:14:01 -0600389_- Since there is no way to put rejected records into an exceptions table, is it possible to save these records to a text file?

Thanks a lot.

================================================ 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. 2974 48 33_Re: Insert & Update using VARCHAR13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 22 Jan 2001 11:24:57 -0600350_US-ASCII Hello Dave, Thanks for your clarification, My point was if you didn't supply a 2 byte :hv length and only the varchar field it self to the application then DB2 will pad the remainder of the field with blanks X'40's. Best regards, Kurt



>>> Dave_Seibert@COMPUWARE.COM 01/22/01 11:09AM >>> Hello Kurt, Sorry I wasn't clear. [...] 3023 56 41_Re: Different results in program vs SPUFI13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 22 Jan 2001 11:43:09 -0600550_- Thanks every body for helping me. I've finally got it working by changing the singleton select to cursor processing (declare, open, fetch, close). Now it does return a sqlcode 0 ( instead of +100) where it should. But that raises more questions than it answers. It's about a year since I took a few sqls plus cobol code and crammed all into one sql. At the time of change I did pretty thorough testing ( well ! ) and everything worked all right. Running a query on the production database showed only around 150 cases where this did'nt work ( [...] 3080 24 16_space calculator10_Lisa Bruce27_db2list_questions@YAHOO.COM31_Mon, 22 Jan 2001 09:43:21 -0800557_us-ascii Greetings...

Does any one have a space calculator rexx for index and tablespaces?.If so can you please pass it on to us?

Thanks. Lisa

__________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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. 3105 59 35_Increasing Active Log VSAM Datasets16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Mon, 22 Jan 2001 13:07:00 -0500252_iso-8859-1 Env: DB2 V6.1 OS/390

Could someone detail the procedure for increasing the size of the active logs in DB2? If it's in a reference manual somewhere, please point me in the right direction. TIA.

Gerald R. (Garry) Brookman

3165 60 17_New Collection Id16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Mon, 22 Jan 2001 13:11:38 -0500312_iso-8859-1 Env: DB2 V6.1 OS/390

How do you create a new Collection Id for an existing package(s)? Can you have the same package in two (2) or more collection id's at the same time? Can you just update the appropriate SYSIBM tables with the new collection id? TIA.

Gerald R. (Garry) Brookman

3226 94 21_Re: New Collection Id16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 22 Jan 2001 13:25:23 -0500413_iso-8859-1 Just specify the new collection id on the pacakge bind. The collection gets created automagically. Yes, you can have 1 package in > 1 collections. This technique is often used when you need the same program to access multiple copies of the data. Simply have different collection IDs for each table CREATOR and specify CREATOR in the QUALIFER parameter on the package bind and use unqualified SQL. [...] 3321 34 39_Re: Increasing Active Log VSAM Datasets13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Mon, 22 Jan 2001 10:36:25 -0800518_iso-8859-1 Archive the active logs not currently logging; stop DB2 and increase their size; then start DB2 and archive the active log which is currently logging ; again stop DB2 and increase it's size; start DB2 again. Someone in list will point out if I have missed something.

Ashish /*std. Disclaimer*/

-----Original Message----- From: Brookman, Gerald [SMTP:gerald.brookman@US.ORIGIN-IT.COM] Sent: Monday, January 22, 2001 10:07 AM To: DB2-L@RYCI.COM Subject: Increasing Active Log VSAM Datasets [...] 3356 46 25_DB2 UDB Log File Sizing ?15_Jackson Reavill18_damcon2@US.IBM.COM31_Mon, 22 Jan 2001 13:37:18 -0500574_us-ascii Hello all,

Is there any rule of thumb for setting the size and number of DB2 UDB log files? Having lived my life to this point as a mainframe development DBA, I haven't had to tackle this one before.

Our environment is DB2 UDB V6.1 fixpack5 on AIX. We will be using log retain and userexit. Concurrent users will be about 30 with fairly heavy update activity. There are a couple of lobs, but those shouldn't be heavily hit. Because of the nature of the application, when updates are done all columns are updated whether they have changed or not. [...] 3403 46 39_Re: Increasing Active Log VSAM Datasets12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Mon, 22 Jan 2001 13:37:30 -0500716_iso-8859-1 Look in Utility Guide and REference manual under DSNJU003(change log inventory). They discuss enlarging active logs there.







"Brookman, Gerald" @RYCI.COM> on 01/22/2001 01:07:00 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Increasing Active Log VSAM Datasets







Env: DB2 V6.1 OS/390

Could someone detail the procedure for increasing the size of the active logs in DB2? If it's in a reference manual somewhere, please point me in the right direction. TIA. [...] 3450 33 39_Re: Increasing Active Log VSAM Datasets13_Steven Kinler17_SKinler@VNSNY.ORG31_Mon, 22 Jan 2001 13:30:08 -0500635_- Gerald,

You can find the information you are looking for to expand the active log datasets in the System Administration Guide Vol I. Look under Recovery Scenarios. Active log failure.



> -----Original Message----- > From: Brookman, Gerald [SMTP:gerald.brookman@US.ORIGIN-IT.COM] > Sent: Monday, January 22, 2001 1:07 PM > To: DB2-L@RYCI.COM > Subject: Increasing Active Log VSAM Datasets > > Env: DB2 V6.1 OS/390 > > Could someone detail the procedure for increasing the size of the active > logs in DB2? If it's in a reference manual somewhere, please point me in > the right direction. TIA. > > Gerald R. [...] 3484 57 39_Re: Increasing Active Log VSAM Datasets12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Mon, 22 Jan 2001 13:50:35 -0500640_us-ascii Be aware also Garry if you are archiving to dasd that they will have to be adjusted also.







Steven Kinler @RYCI.COM> on 01/22/2001 01:30:08 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Increasing Active Log VSAM Datasets



Gerald,

You can find the information you are looking for to expand the active log datasets in the System Administration Guide Vol I. Look under Recovery Scenarios. Active log failure. [...] 3542 44 20_Re: space calculator9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Mon, 22 Jan 2001 11:45:05 -0700508_iso-8859-1 You might try DB2 estimator. It's a FREE download .

http://www3.software.ibm.com/srchdown?searchstr=db2%20estimator

Cheers, Don Alden



-----Original Message----- From: Lisa Bruce [mailto:db2list_questions@YAHOO.COM] Sent: Monday, January 22, 2001 10:43 AM To: DB2-L@RYCI.COM Subject: space calculator



Greetings...

Does any one have a space calculator rexx for index and tablespaces?.If so can you please pass it on to us?

Thanks. Lisa [...] 3587 63 39_Re: Increasing Active Log VSAM Datasets50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Mon, 22 Jan 2001 13:58:40 -0500378_iso-8859-1 One other thing I forgot to mention

You want to size the the actives to fit an entire active log onto tape for the archive process. You don't want the active logs to split across two tapes. We had an active log span 2 tapes (reason was that they had a short tape in the silo) the result was the active spanned across two tapes and caused problems ar D/R. [...] 3651 35 12_Load Utility22_Walls, Lucious MANTECH20_TCI1@BUPERS.NAVY.MIL31_Mon, 22 Jan 2001 14:41:30 -0500572_iso-8859-1 Hi List,

I'm in the process of moving data between two DB2 subsystems - production to test. I'm using the unload program DSNTIAUL and the Load utility to move the data. I need to load at least 20 tables in test. I want to load only the rows that contain SSN'S ending with an odd number. Even after this selection criterion a few of the test tables will contain over a million rows. The question I have is....Is there a way to select these rows through the load utility? I've tried numerous ways to include more than one field-selection-criterion on [...] 3687 74 12_Load Utility15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Mon, 22 Jan 2001 14:01:20 -0600478_us-ascii Unload only required rows and then load.

select * from table where ssn like '%%%%%%%%%1' or ssn like '%%%%%%%%%3' or ssn like '%%%%%%%%%7' or ssn like '%%%%%%%%%9'

This type of unload may take more time because of redundant predicate but could solve your problem.



Regards Nayeem









---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/22/2001 01:52 PM --------------------------- [...] 3762 61 25_Re: Subject: Load Utility11_Pedro Cunha18_pplfilho@IG.COM.BR31_Mon, 22 Jan 2001 18:08:06 -0200345_- Hello Lucious,

Have you read about UNLOAD EXTERNAL and UNLOAD DISCARD? Maybe you can use these options to do what you need to do. It is also a good idea, before using these options to check http://techsupport.services.ibm.com/390/psd-adv.html and see what APARS you may need to apply to your DB2 subsystems.

[]s Pedro Cunha [...] 3824 35 39_A separate subsystem for Peoplesoft HR?12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 22 Jan 2001 14:14:48 -0600383_us-ascii Hi.

Our shop is relatively new to DB2 / OS390. We've had it installed for a little over a year, and are implementing our first production system (an in-house developed general ledger app.) this upcoming weekend.

I don't have all of the details on this, but I believe we are going forward with Peoplesoft's HR system (V8?), using DB2 for OS/390 as the DB. [...] 3860 77 43_Re: A separate subsystem for Peoplesoft HR?0_26_truman.g.brown@VERIZON.COM31_Mon, 22 Jan 2001 15:35:11 -0500384_us-ascii Absolutely put it in a separate subsystem, or the other applications may face a lot of contention.

Also, most PeopleSoft tables have quite a few unused columns, so insist on using compression (we have seen over 80 percent compression rates). Compression will usually reduce DASD requirements and significantly improve bufferpool hits for PeopleSoft applications. [...] 3938 24 43_Re: A separate subsystem for Peoplesoft HR?11_Jose' Gomez21_Jose_Gomez@WENDYS.COM31_Mon, 22 Jan 2001 15:41:47 -0500149_us-ascii We have HRMS and Finance. We have them on separate DB2 subsystems. Performance/Tuning was one reason we split them and Disaster Recovery was 3963 43 43_Re: A separate subsystem for Peoplesoft HR?22_Edward J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 22 Jan 2001 14:49:17 -0600161_iso-8859-1 Guess business practices and politics rears it's ugly head. Maybe separate bufferpools would be a compromise that everyone could live (and tune) with. 4007 77 16_Re: Load Utility19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 22 Jan 2001 15:01:50 -0600696_iso-8859-1 Lucious, note the following, especially PARMS('SQL'):

//SYSTSIN DD * DSN SYSTEM(ssid) RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) LIB('vcat.RUNLIB.LOAD') - PARMS('SQL') /* //SYSIN DD * SELECT * FROM creatorName.tableName WHERE predicates <---- any number

ORDER BY col1, col2 <----- clustering index order

;

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 [...] 4085 37 68_Re: DB2 Connect Personal Edition CALL OS/390 Stored Procedure - Help11_Ken Shepard27_kshepard@HASTINGSMUTUAL.COM31_Mon, 22 Jan 2001 15:01:40 -0600480_- This issue has been resolved thanks to a gentleman at COMPUWARE and a gentleman at Meijer, Inc. One oddity that may have kept us from hitting at least part of the answer on DB2-L was that we didn't recognize that the text immediately following the SQLSTATE=HYC00 was actually the beginning of a separate message. Resolution was the application of DB2 UDB V7.1 for NT/2000 FIXPACK 2 on DB2 Connect Personal Edition. Following is the text from the gentlemen mentioned above: [...] 4123 52 43_Re: A separate subsystem for Peoplesoft HR?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 22 Jan 2001 15:09:40 -0600547_iso-8859-1 I had sent the attached message to the list about a year ago regarding the topic of Peoplesoft and if it could live in the same subsystem as other applications. When I originally sent this I mentioned I was probably in the minority on this issue, and I realize I'm STILL in the minority, but I think my comments from a year ago are still valid. I would still go back to the question of "what would you do differently with a dedicated Peoplesoft subsystem?". If the answer is "nothing", then why bother? What tuning can you do in a [...] 4176 14 23_Re: Global transactions12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 22 Jan 2001 15:16:12 -0600334_- One minor point to fix the URL

ibm.com/redbooks

Roger Miller, DB2 for OS/390

================================================ 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. 4191 15 11_New to List20_Paul H. Bohannon Jr.21_PBohannon@MSIINET.COM31_Mon, 22 Jan 2001 15:29:36 -0600415_us-ascii Are there any good DB2 classes on installation, implementation, and customization? I know good is relevant but I haven't found anything.

Paul H. Bohannon Jr.

================================================ 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. 4207 68 29_Re: DB2 UDB Log File Sizing ?18_Gert van der Kooij15_geko@WANADOO.NL31_Mon, 22 Jan 2001 22:53:59 +0100328_iso-8859-1 Hi,

November 1999 this question was asked in the comp.databases.ibm-db2 newsgroup. This was the formula posted by Roger Zheng from the DB2 lab which could be used to calculate the logfilesize needed when using V5. If you ask the question in the newsgroup again, maybe he will answer the question again :) [...] 4276 93 41_Re: Connections (not threads) running out13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU31_Tue, 23 Jan 2001 09:07:32 +1100320_iso-8859-1 Tony,

I last used Omegamon 8 years ago on Ver 270, so does it indicate if any of the active threads are using parallelism and if so how many parallel tasks?

I am guessing that the shadow server product uses a remote connection to DB2, so it's limit will be governed by MAXDBAT and CONDBAT. [...] 4370 105 39_Repost: TDAN.com New Issue Announcement13_Morrill, John12_JohnM@VP.NET31_Mon, 22 Jan 2001 15:19:13 -0700402_- Issue 15.0 of The Data Administration Newsletter (TDAN.com) is now available on-line. This issue has a dozen new articles, a new feature column title The Database Report, dozens of new conferences listed, new book reviews, many new job ads, new resources and links, and much more.

The new articles -- located at http://www.tdan.com/edatt1_article.htm -- address many topics including ... [...] 4476 74 16_Fwd: New to List24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 22 Jan 2001 17:29:32 -0800441_us-ascii Paul, Which platform are you interested in? The Fillmore Group (http://www.thefillmoregroup.com) has many classes available for DB2 Server for VSE&VM in traditional lecture and Internet formats. We also provide DB2 UDB for Linux, Unix, and Windows courses in the classroom. There are several vendors on the list who provide DB2 for OS/390 training. Finally, there's IBM itself at http://www.software.ibm.com/services/learning. [...] 4551 89 53_Groupbufferpool Structure Size Increase By New Policy12_Chris Munson18_cmunson@US.IBM.COM31_Mon, 22 Jan 2001 14:34:04 -0800405_us-ascii Andy, I saw several notes on this subject and don't know if your questions were completely answered so I thought I'd throw my 2 cents in. What you mention below about the size of a GBP being able to be changed on the fly does work (as long as the SIZE parameter and CF storage allows for it). In a previous append you mentioned that when you tried the rebuild command you got the following: [...] 4641 111 35_Re: Dataload for DB2 on VM question24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 22 Jan 2001 17:37:41 -0800324_us-ascii

Wes, No, the Database Services Utility (DBSU) is not as sophisticated as it's sibling utilitites on other platforms. There are a couple of things you can do.

1) If you just want to capture duplicate key records, load the data with no unique indexes or Primary Keys and submit the following SQL: [...] 4753 47 108_Repost: Giga Online Survey: "What is your production database pla tform [any version] for data warehousing?"13_Morrill, John12_JohnM@VP.NET31_Mon, 22 Jan 2001 15:41:09 -0700645_- Dear DB2 Interested Parties,

Giga Information Group is currently conducting a survey on their Web Site at http://www.gigaweb.com/ asking the question:

What is your production database platform [any version] for data warehousing? o IBM mainframe o IBM other o Microsoft o NCR o Oracle o Other, including legacy systems

Please consider a quick trip to the Giga Web site to register your company's data warehouse DBMS platform. Hopefully your feedback to this survey will ensure accurate representation of DB2's usage on both the mainframe ("IBM mainframe") or in the UNIX, Windows or AS/400 ("IBM other") environments. [...] 4801 139 67_OS/390 DB2 Installation, Implementation and Customization Education20_Paul H. Bohannon Jr.21_PBohannon@MSIINET.COM31_Mon, 22 Jan 2001 16:39:49 -0600458_us-ascii Frank, I'm looking for DB2 on OS/390 training. I looked at IBM education but I didn't see anything that talked about Installation and customization. I see System Administration, and how to mange database/tables. It should be fairly simple to install with the ServerPak process but I'm sure that I need to make parameter decisions and don't have a clue what I would need to do. I'm looking for some course(s) that would give me that background. [...] 4941 39 47_Write an article for the IDUG Solutions Journal12_David Beulke22_dbeulke@COMPUSERVE.COM31_Mon, 22 Jan 2001 17:35:15 -0500367_ISO-8859-1 All,

Would you like exposure to the DB2 community and almost every DB2 shop in the world?

All you have to do is write an article for the next issue of the IDUG Solutions Journal. We are beginning to put together the next issue with a (very large database) VLDB theme and need your article detailing your experiences, issues and success. [...] 4981 84 21_Re: New Collection Id14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 23 Jan 2001 13:03:11 +1100675_iso-8859-1 Of course, before using a collection, the bind owner needs an appropriate authority (CREATE or PACKADM) in the collection. A collection is really just an indexing concept - nothing is actually "created".

Technically, a package exists in only a single collection - its name is "..()". I think you meant: can two packages with the name package-id (ie program name) exist in two different collections? Not only is the answer to that question "yes" (as eric explained), but you can also have two different packages with the same package-id in the _same_ collection - provided their version-ids and consistancy tokens [...] 5066 46 21_Re: Using REXX in QMF14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 23 Jan 2001 13:05:35 +1100471_iso-8859-1 In QMF, you can use the TSO command to execute a REXX/CLIST. "QMF issues the ISPF SELECT CMD statement for you" so you can SELECT PGM(DSQCCI).

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Scott Lindsey [mailto:sflindsey@HIGHLIGHTS-CORP.COM] Sent: Monday, January 22, 2001 11:23 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Using REXX in QMF [...] 5113 31 24_DB2 EEE V7.1 on Win/200012_Kent Collins15_kcollins@WF.NET31_Mon, 22 Jan 2001 20:26:43 -0600583_iso-8859-1 We are experiencing a problem after installing DB2 V7.1 EEE Single Partition on Win/2000 machines. After the successful installation, we see in Services that DB2 has started. From the Command Window if we execute the db2stop command we get the No start database error message. If we execute the db2start command we see "Database already started" error message. if we go into Services and stop DB2 service, we can then execute db2start from the command window successfully. However, the db2stop command from the command window gives the same "no start command" error. [...] 5145 137 41_Re: Different results in program vs SPUFI13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 22 Jan 2001 22:53:57 -0600316_- To check my theory regarding this problem ( that singleton select is not working ) I wrote a program with both singleton select and and cursor. And sure enough the FETCH found the row but the SELECT did not. Here is program, the job output and working data. And yes our DBA is going to get in touch with IBM. [...] 5283 25 24_High CPU usage on delete7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Mon, 22 Jan 2001 22:59:01 -0600346_- Dear List,

We have a partitioned tablespace with 3 million rows of 10 parts. It has atleast 25 child tables. It has 3 NPIs. All indexes are Type 2.

we noticed that a program SQL delete on this table using primary key in the where clause is taking a long time. I can see in omegamon, each delete query is taking many seconds. [...] 5309 73 28_Re: High CPU usage on delete16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 23 Jan 2001 10:50:26 +0530532_- Hello Sri,

Is the index on foreign key(all the 25 child tables) has the same sequence of columns as the primary key columns ? Atleast the leading columns. Have u checked the explain ? There are lot more things left to check up and i am sure you will take them as you move on. So, let's start with EXPLAIN output, If index is used, let's check the column sequence. If column sequence is used then let's look at the filter factors(as you said high CPU is taken). However, deleting from 25 child table is still not easy. [...] 5383 14 47_Joann Tobin/FRA/PutnamInv is out of the office.11_JoAnn Tobin25_Joann_Tobin@PUTNAMINV.COM31_Tue, 23 Jan 2001 00:15:24 -0500365_us-ascii I will be out of the office from 01/23/2001 until 01/29/2001.

I will respond to your message when I return.

================================================ 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. 5398 62 28_Re: High CPU usage on delete12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Tue, 23 Jan 2001 16:26:38 +1100360_- Sri, I am assuming that there are appropriate Indices, on your Foreign Keys (FKs) in the child tables; but I still think that the most of your time is going to be checking the 25 RI constraints rather than pseudo deleting rows off the 3 NPIs. Particularly if there are any "ON DELETE CASCADE" rules which may very well pull in quite a few other tables. [...] 5461 76 16_Re: Load Utility16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 23 Jan 2001 11:14:23 +0530386_- Is the answer given by Rick sufficient ? I think it should be as there are 5 (single digit) Odd numbers only and it can be coded in the IN list using SUBSTR. If i am not wrong, your WHEN clause should work. What is the error you are getting ? If it is syntax error, please match it up with Manual. It can also be the error due to position of the end character you are providing. [...] 5538 57 45_Case Sensitivity of SQL statements in DB2/40020_Yasas Mallawarachchi14_yasas@SLIIT.LK31_Tue, 23 Jan 2001 12:16:37 +0600331_iso-8859-1 Hi All,

Is db2/400 database case sensitive? I have an appliation which uses DB2 database. The application was developed using anothe dbms and I tried to change the dbms to DB2/400. Then came across that the table field names are case sensitive. Is there an option where I can set the case sensitivity "off"? [...] 5596 64 42_Re: DB2 for OS/390 and the support of Java23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 Jan 2001 08:52:26 -0000407_iso-8859-1 Peter

Hi. I thought it was V6.

Les

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Monday, January 22, 2001 3:25 PM To: DB2-L@RYCI.COM Subject: DB2 for OS/390 and the support of Java



Hello Listers,

just a short question: We all know that DB2 for OS/390 supports JAVA. In which version the Java support was introduced ? [...] 5661 63 0_0_18_dsi.listsrv@DB.COM31_Tue, 23 Jan 2001 14:56:53 +0530470_us-ascii Hi Philip, Thanks for the solution. As suggested by you, when I used SQLGetDiagField function, it returned me the parameter number. But when I used column of data type DECIMAL, it returned me the column number as SQL_COLUMN_NUMBER_UNKNOWN. Can you please throw light on this error?.



Ramesh, The SQLGetDiagfield() function will return the SQL_DIAG_COLUMN_NUMBER field which will contain either the column number or parameter number. HTH Phil [...] 5725 113 45_Re: DB2 Visual Explain - authorization needed16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 23 Jan 2001 15:18:13 +0530387_- EXPLAINAGENT looks to me another good solution, infact it is better than EXPLAIN(ONLY) as suggested by James because it is easier to implement for individual SQL statements used for EXPLAIN i.e EXPLAIN PLAN FOR SET QUERY NO..... Whoever will be having the EXPLAINAGENT authority will be able to get the explain for the plans/packages as well as for the individual SQL statements. [...] 5839 48 33_Re: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 23 Jan 2001 15:24:37 +0530536_- Dave, I think what Kurt wants to point out is something like this.

Table definition : VAR1 VARCHAR(40)

Dclgen Definition : 02 VAR1. 49 VAR1-LEN PIC S9(4) COMP. 49 VAR1-TEXT PIC X(40).

Move 'ABC' to VAR1-TEXT

Insert into table values(VAR1).

If we do not supply the length and we are moving the content not to the group variable but to the individual text field then DB2 will pad the variable to its maximum length. In the above example if we display the length of VAR1 then it will be 40 not 3. [...] 5888 100 57_Re: Groupbufferpool Structure Size Increase By New Policy23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 Jan 2001 09:52:56 -0000399_iso-8859-1 Andy (And Rick)

I have read your mails and replies and must say that I agree with what you are saying - the docs are a little vague.

We have moments when we change our policy here and then do a re-build of the GBPs that have changed - but it seems to work fine (we are V6 though) - assuming enough critical storage is available to hold both the old and new structures. [...] 5989 180 72_Re: OS/390 DB2 Installation, Implementation and Customization Edu cation23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 Jan 2001 09:55:47 -0000317_iso-8859-1 Hi

have you spoken to CA or BMC about courses?

they may have something on this....alternatively everyone here on the list will help as you go through the process. The Install Book is very very easy to use .... if I can use it to put V6 in and convert to datasharing .. then anybody can. [...] 6170 54 40_Re: Using DB2 PM for exception reporting23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 Jan 2001 09:58:47 -0000621_iso-8859-1 Tom

we are .. mail me .. we are in the early stages .. but we have started the process.

Les

-----Original Message----- From: Tom Glaser [mailto:tg5444@SBC.COM] Sent: Friday, January 12, 2001 4:35 PM To: DB2-L@RYCI.COM Subject: Using DB2 PM for exception reporting



Is there anyone out there using DB2 PM to perform "periodic exception processing?" That is, using DB2 PM to monitor your subsystem so that in the event that some threshold is reached (such as n number of deadlocks are reached, or a thread using up 20 minutes of CPU time), DB2 PM will notify you. I would [...] 6225 51 60_Re: Catalog Utility abend causing package to be invalidated?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 23 Jan 2001 09:34:51 -0000685_iso-8859-1 Bill

It certainly sounds like it.

Have you been in touch with IBM?

Leslie

-----Original Message----- From: Johnson, Bill [mailto:bjo23@ALLSTATE.COM] Sent: Thursday, January 11, 2001 5:40 PM To: DB2-L@RYCI.COM Subject: Catalog Utility abend causing package to be invalidated?



All, We had our DB2 (V6) catalog backup job abend the other night. Before it was restarted, DB2 was recycled. The skeleton cursor table was in UTRO upon DB2's return and there weren't any utilities outstanding and we had to perform an access(force) to make the SCT available. Later in the day, we had a situation where a package had been invalidated. [...] 6277 80 45_Re: Running BIND/REBIND from within a program10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 23 Jan 2001 04:25:34 -0600368_- Tim,

All I meant by 'performance benefits' is that it would be vastly more efficient to run all your binds in one go than to pick a method which involved invoking the command processor for each one (which I know you said that you didn't want to do).

I don't know if this is a viable option in this case, but as you're running in batch, could you: [...] 6358 69 16_Re: Load Utility14_Winska, Krysia27_Krysia_Winska@THOMSON.CO.UK31_Tue, 23 Jan 2001 10:40:18 -0000624_iso-8859-1 Within DSNTIAUL you can use any SQL at all. Hence you can use this to unload only the rows you want to load to the other subsystem.

Krysia Winska -----Original Message----- From: Walls, Lucious MANTECH [mailto:TCI1@BUPERS.NAVY.MIL] Sent: Monday, January 22, 2001 7:42 PM To: DB2-L@RYCI.COM Subject: Load Utility



Hi List,

I'm in the process of moving data between two DB2 subsystems - production to test. I'm using the unload program DSNTIAUL and the Load utility to move the data. I need to load at least 20 tables in test. I want to load only the rows that contain SSN'S ending [...] 6428 30 20_Recall: Load Utility14_Winska, Krysia27_Krysia_Winska@THOMSON.CO.UK31_Tue, 23 Jan 2001 10:42:21 -0000523_- Winska, Krysia would like to recall the message, "Load Utility".



********************************************************************** This email and any files and/or attachments transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed.

If you have received this email in error, please notify the Systems Manager at Thomson Holidays Ltd., by telephoning +44 (0)20 7387 9321, by reverse charge or collect call if you wish. [...] 6459 27 31_CSP 3.3 with DB2 6.1 under VSE?15_Thomas Machovec26_thomas.machovec@AT.IBM.COM31_Tue, 23 Jan 2001 12:09:17 +0100315_us-ascii Dear friends,

is there anybody outside in the world, who is still using CSP/AE V3.3 under VSE/ESA ? We want to migrate our Database from SQL/VSE 3.5 to DB2/VSE 6.1 but remain with CSP, because we do not want to migrate our few CSP applications.

I want to know, wether this works or not. [...] 6487 141 57_Re: Groupbufferpool Structure Size Increase By New Policy9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 23 Jan 2001 11:08:10 +0000411_us-ascii Chris, Thanks for your detailed reply. I was trying to carry out the rebuild when the GBPs were in DUPLEX mode. I had a look at the V6 manuals and it does indeed say that you have to stop DUPLEXing first. I guess I must have missed this in the DOC hold information for the ptf which retrofitted DUPLEXing into V5. Thanks for clarifying this. Kind Regards, Andy Hunt - Scottish And Southern Energy [...] 6629 106 16_Re: Load Utility19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Tue, 23 Jan 2001 05:34:07 -0600454_us-ascii Krysia,

No need to "recall" your message !!!

There are two "flavours" of DSNTIAUL - one which allows only any SQL and the other which simply takes a table name as input and unloads the whole table.

For the latter of these the SYSIN DD statement simply contains the qualified table name.

To get the other one to work you add a PARM('SQL') to your RUN PROGRAM(DSNTIAUL) and your SYSIN has the SQL statement in it. [...] 6736 236 16_Re: Load Utility10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 23 Jan 2001 06:54:09 -0600392_- This is an actual example of control cards I have used with DSNTIAUL / PARM('SQL') to unload information (the actual content is unimportant for the purposes of the example):

//SYSIN DD * DROP TABLE EXTRACT_1;

CREATE GLOBAL TEMPORARY TABLE EXTRACT_1 (TRAN_REF CHAR(32) NOT NULL, TRAN_DATE DATE NOT NULL, TRAN_HOUR DECIMAL(2,0) NOT NULL, TRAN_COUNT DECIMAL(9,0) NOT NULL); [...] 6973 59 33_Isolation Level 'UR' (dirty read)18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 23 Jan 2001 08:32:51 -0500457_iso-8859-1 Could anyone shed any light on the 'locking' that takes place when using a package thats bound with an isolation level of 'UR'?? I know the manual says that it 'acquires few locks' but this to me is kind of fuzzy. We are using UR for some of our applications that come in either using DB2 Connect or Datajoiner. When I look at our TMON monitor for a specific thread that is using one of these packages I see the following under MX PG LOCKS: [...] 7033 91 28_Re: High CPU usage on delete11_David Nance16_DWNance@FHSC.COM31_Tue, 23 Jan 2001 08:38:32 -0500569_US-ASCII Sri, We had a problem similar to this at my last position. The deletes on the parent table were almost impossible due to high usage of the child tables, on the cascading deletes. We wnet with a solution similar to what Nick described. We performed a reorg with delete processing on the parent table, reorgs on the child tables and used check data to clean up the children. This process ended up being speedier than we first thought it would be. I don't remember the exact execution time but was less than 20 minutes, deleting close to ninety million rows [...] 7125 95 37_Re: Isolation Level 'UR' (dirty read)17_Massimo Biancucci19_mbiancucci@DEBIS.IT31_Tue, 23 Jan 2001 14:58:55 +0100340_us-ascii At the last DB2 Conference I heard a nice discussion about the "LOCK AVOIDANCE".

During the conference I received an explanation flow about the lock mechanism and, as I see, there's no lock for a plan using Isolation Level (UR), only latch.

If u don't have dynamic sql i think there's no reason to acquire lock. [...] 7221 74 37_Re: Isolation Level 'UR' (dirty read)10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 23 Jan 2001 08:08:17 -0600617_- If you have bound your Package with ISOLATION(UR), then any Read Only SELECTs will execute with ISOLATION(UR). Quite obviously, any non-RO SELECTS will not be UR. Less obviously, any Subselects will not be UR either.



On Tue, 23 Jan 2001 08:32:51 -0500, Whittaker, Stephen wrote:

> Could anyone shed any light on the 'locking' that takes place when using a >package thats >bound with an isolation level of 'UR'?? >I know the manual says that it 'acquires few locks' but this to me is kind >of fuzzy. > We are using UR for some of our applications that come [...] 7296 72 33_FW: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 23 Jan 2001 09:14:48 -0500564_iso-8859-1 Hi Sanjeev,

If that is what Kurt is saying, I have to disagree.

There is something in VAR1-LEN . Whether it is binary zeros, spaces, something residual from a prior piece of logic, some value exists there. It is that value, whether you intend it to be used or not, which is used as the length. If VAR1-LEN has binary zeros, a row is inserted with that column containing a zero length; if it contains spaces an attempt is made to insert a row with that column having a length of 16448. If your column is defined that large, (requiring [...] 7369 109 28_Re: High CPU usage on delete15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 08:25:32 -0600582_us-ascii Hi Sri

If indexes are being utilized then you have to reorganize indexes, double check index entries in sysibm.sysindex ,sysibm.sysindexpart.

Regards Nayeem

---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 08:17 AM ---------------------------



"S, Sanjeev (CTS)" on 01/22/2001 11:20:26 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)

Subject: Re: High CPU usage on delete [...] 7479 100 42_Re: DB2 for OS/390 and the support of Java19_Ajay_Kizhakkekappil30_Ajay_Kizhakkekappil@SATYAM.COM31_Tue, 23 Jan 2001 14:48:58 +0530608_iso-8859-1 Hi,

It's available from V5.

Ajay

> ---------- > From: Pendlebury-Bowe, > Leslie[SMTP:Leslie.Pendlebury-Bowe@EU.SONY.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, January 23, 2001 2:22 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 for OS/390 and the support of Java > > Peter > > Hi. I thought it was V6. > > Les > > -----Original Message----- > From: Peter, Georg [mailto:G.Peter@DZBW.DE] > Sent: Monday, January 22, 2001 3:25 PM > To: DB2-L@RYCI.COM > Subject: DB2 for OS/390 and the support of Java > > > Hello Listers, > > just a short question: We all [...] 7580 48 43_Re: A separate subsystem for Peoplesoft HR?13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Tue, 23 Jan 2001 09:36:10 -0500409_US-ASCII At a previous shop (which shall remain nameless), our primary consideration was recovery. With Payroll, especially. If processes weren't followed to the letter, it was possible to completely screw up payroll processing. The PeopleSoft-provided "backout" process was complex and time-consuming. Forward recovery from Image Copies of 37+ tablespaces was tested, with an elapsed time of 4.5 hours. [...] 7629 23 34_CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 23 Jan 2001 09:39:25 -0500345_US-ASCII Hello List, I am at a client site and requested DB2 UDB to be installed on my WIN 98 desktop. Once the install was completed Fix pack 6 was put on. Once that was done I tried to open information center and/or control center and receive error CLI0616E. The text is: "[IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01 [...] 7653 25 23_UDB Certification Costs0_22_BILL_GALLAGHER@PHL.COM31_Tue, 23 Jan 2001 10:05:05 -0500324_us-ascii Hi,

Just a quick question to anybody who can answer . . . what are the $$$ costs associated with taking a UDB Certification test? I know that the Certification tests are usually offered for free at IDUG, etc., but what would be the costs if I were to go to a training center to take one of these tests? [...] 7679 45 23_UDB Certification Costs15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 09:12:02 -0600745_us-ascii It was around $120/- during (Sept-Oct 1999). ---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 09:07 AM ---------------------------



BILL_GALLAGHER@PHL.COM on 01/23/2001 09:05:05 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)

Subject: UDB Certification Costs





Hi,

Just a quick question to anybody who can answer . . . what are the $$$ costs associated with taking a UDB Certification test? I know that the Certification tests are usually offered for free at IDUG, etc., but what would be the costs if I were to go to a training center to take one of these [...] 7725 45 23_UDB Certification Costs15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 09:12:30 -0600733_us-ascii GO TO www.ibm.com/certify ---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 09:09 AM ---------------------------



BILL_GALLAGHER@PHL.COM on 01/23/2001 09:05:05 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)

Subject: UDB Certification Costs





Hi,

Just a quick question to anybody who can answer . . . what are the $$$ costs associated with taking a UDB Certification test? I know that the Certification tests are usually offered for free at IDUG, etc., but what would be the costs if I were to go to a training center to take one of these tests? [...] 7771 86 20_Re: QUIESCE QUESTION16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Tue, 23 Jan 2001 10:20:29 -0500517_us-ascii I'm sorry to say but I disagree w/ Jim and Bill.

It is not necessary to externalize changed pages (i.e., updated pages not yet written to DASD from the bufferpools) to establish a system wide point of recovery.

WRITE(YES) must be utilized for DFSMS CONCURRENT COPY type image copies.

WRITE(NO), as specified in the administration guide, is less restrictive in terms of DRAIN LOCK acquisition and because I/O does not have to be incurred, the quiesce operation will execute quicker. [...] 7858 47 38_AW: CLI0616E - Starting Control Center16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Tue, 23 Jan 2001 16:25:50 +0100605_iso-8859-1 Is a listener process runing of port 6789? (netstat -a -n) Did you start the service for JDBC?

Roland



> -----Ursprόngliche Nachricht----- > Von: Troy Coleman [SMTP:Colematr@MEIJER.COM] > Gesendet am: Dienstag, 23. Januar 2001 15:39 > An: DB2-L@RYCI.COM > Betreff: CLI0616E - Starting Control Center > > Hello List, > I am at a client site and requested DB2 UDB to be installed on my WIN 98 > desktop. Once the install was completed Fix pack 6 was put on. Once that > was done I tried to open information center and/or control center and > receive error CLI0616E. The [...] 7906 17 31_imagecopy suddenly running long7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Tue, 23 Jan 2001 09:22:48 -0600323_- Dear list,

One of our daily production incremental imagecopy jobs that normally take 25min suddenly kept running for nearly 5 hours but TCB only .20 min. We had to cancel it. Each tablespace being copied was taking between 4 to 6 min instead of seconds earlier. Anyone has come across such a problem? Thanks, [...] 7924 39 22_VSAM naming convention14_Peacock Julian25_Julian_Peacock@SWEB.CO.UK31_Tue, 23 Jan 2001 15:28:57 -0000513_iso-8859-1 Fellow DB2ers,

If a tablespace has < 16 partitions, each partition can store up to 4Gb. VSAM can only handle 2Gb per dataset. So there must be 2 VSAM datasets for each 4Gb partition! The Annn section of the VSAM dataset name indicates the partition or dataset number. How is the second VSAM dataset named in a 4Gb partition? For example, if we have a 16 partitioned tablespace, and the first partition broaches the 2GB limit, will the second one be called A017! (We are a DB2 ver. 5 site). [...] 7964 56 42_Re: AW: CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 23 Jan 2001 10:40:54 -0500618_ISO-8859-1 I am running win98. I do not have a service at 6789. How do I start JDBC on win98? Thank you for your help. Troy

>>> SchiradinR@ALTE-LEIPZIGER.DE 01/23/01 10:25AM >>> Is a listener process runing of port 6789? (netstat -a -n) Did you start the service for JDBC?

Roland



> -----Ursprόngliche Nachricht----- > Von: Troy Coleman [SMTP:Colematr@MEIJER.COM] > Gesendet am: Dienstag, 23. Januar 2001 15:39 > An: DB2-L@RYCI.COM > Betreff: CLI0616E - Starting Control Center > > Hello List, > I am at a client site and requested DB2 UDB to be installed on my WIN 98 > desktop. Once [...] 8021 114 26_Re: VSAM naming convention0_18_mebert@AMADEUS.NET31_Tue, 23 Jan 2001 16:37:35 +0100396_us-ascii Wrong. VSAM datasets can go up to 4 GB (since when?? No idea). So there is never more than one DS per partition.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany





From: Peacock Julian on 23/01/2001 15:28 GMT

Please respond to DB2 Data Base Discussion List [...] 8136 14 35_Re: imagecopy suddenly running long15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Tue, 23 Jan 2001 09:29:50 -0600380_us-ascii Have the paths to your tape drives benn changed recently? Has any maint been done to MVS in any way? This is where I would start.

================================================ 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. 8151 129 35_Re: imagecopy suddenly running long10_Bill Disch23_bill.disch@GENMILLS.COM31_Tue, 23 Jan 2001 09:53:12 -0600421_- Sri:

Has some massive update/insert of data occurred that resulted in most pages being updated and hence your incremental now copies almost as much as a fullcopy plus the overhead of checking which pages have changed? Are you using IBM utility? I use BMC COPY+ which can change from a random getpage of changed pages to a full tablespace scan when the percentage of changed pages exceeds a specified level. [...] 8281 19 37_Re: Isolation Level 'UR' (dirty read)19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Tue, 23 Jan 2001 11:00:57 EST411_us-ascii This is something new to me. Why would subselects NOT use UR?



Regards,

Rajeev P. Dhanawade Phone: 302-577-4659 ext. 221 Fax : 302-577-4454

================================================ 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. 8301 34 37_Re: Isolation Level 'UR' (dirty read)10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 23 Jan 2001 17:02:07 +0100336_us-ascii Hi Stephen....

I made many tests when Isolation Level UR came out (there was not anyT.REX wandering on the earth, I can't remeber if it was Giurassic or Liassic age) and it acquires some locks as Mass-delete lock (I think it's the only unlock request that appers in you small report) and some other 'intent' locks. [...] 8336 78 50_New Documents in the DB2-L Documents Archival List13_Morrill, John12_JohnM@VP.NET31_Tue, 23 Jan 2001 09:11:14 -07003429_- Greetings!



There are two new documents in the DB2-L Documents Archival List (http://jupiter.ryci.com/archives/db2-l-documents.html)

The first document is titled "DB2 for MVS/ESA V4 (5695-DB2) to be withdrawn from service effective December 31, 2001"

The second document is titled "IBM Redbooks Summary for December 2000"

Cheers!

J. Michael Morrill







begin 600 winmail.dat M>)\^(A,0`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<` M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`06``P`.````T00/BL```,`WC^O;P```P``@`@@ M!@``````P````````$8`````4H4``"=J`0`>``&`""`&``````#````````` M1@````!4A0```0````0````Y+C``"P`"@`@@!@``````P````````$8````` M!H4````````#``.`""`&``````#`````````1@`````!A0````````L`!(`( M(`8``````,````````!&``````.%````````"P`%@`@@!@``````P``````` M`$8`````#H4````````#``:`""`&``````#`````````1@`````0A0`````` M``,`!X`((`8``````,````````!&`````!&%`````````P`)@`@@!@`````` MP````````$8`````&(4````````>``J`""`&``````#`````````1@`````V MA0```0````$`````````'@`+@`@@!@``````P````````$8`````-X4```$` M```!`````````!X`#(`((`8``````,````````!&`````#B%```!`````0`` M```````"`0D0`0```,`!``"\`0``L@(``$Q:1G6]CY.(`P`*`')C<&3!Q`3T&EV!T`@3`0`"05`*&@" M0'`Z+R\0:G5P:0ZP\`/P(*"P9')A=P.@`U(@%!#\`3X&4#('9- M!;`%$&P8`!VO-N1]`3@0'@!P``$````S````3F5W($1O8W5M96YT`#%` M`0````8```!*3TA.30````,`&D``````'@`P0`$````&````2D](3DT````# M`!E```````,`@!#_____`@%'``$````Y````8SU54SMA/2`[<#U686YT86=E M(%!O:6YT.VP]0T]&1D5%4TA/4"TP,3`Q,C,Q-C$Q,31:+3(P-C4``````@'Y M/P$```!-`````````-RG0,C`0A`:M+D(`"LOX8(!`````````"]//59!3E1! M1T4@4$])3E0O3U4]5E!.150O0TX]4D5#25!)14Y44R]#3CU*3TA.30`````> M`/@_`0````X```!-;W)R:6QL+"!*;VAN````'@`X0`$````&````2D](3DT` M```"`?L_`0```$T`````````W*=`R,!"$!JTN0@`*R_A@@$`````````+T\] M5D%.5$%'12!03TE.5"]/53U64$Y%5"]#3CU214-)4$E%3E13+T-./4I/2$Y- M`````!X`^C\!````#@```$UO`#E``0````8```!* M3TA.30```$``!S!XY!\<5X7``4``"##2H(0>5X7``1X`/0`!`````0`````` M```>`!T.`0```#,```!.97<@1&]C=6UE;G1S(&EN('1H92!$0C(M3"!$;V-U M;65N=',@07)C:&EV86P@3&ES=```'@`U$`$```!'````/#,V0T$Q,3=$0C`P M0C@W-$5!04,V1$5$1C%!,C%",S=&,4,R14,V0&-O9F9E97-H;W`N9F]R=&-O M;&QI;G,N=G`N;F5T/@``"P`I```````+`",```````,`!A`"Z?4>`P`'$"
I've been using DB2 UDB for a couple of years now, but am now working with DB2/400. I'm used to being able to a LOAD utility to get data into a UDB table, but the AS/400 doesn't appear to have that utility. I have Client Access Express loaded (v4.5.0 to match our AS/400), and when using the Transfer Data to AS/400 I get the following error: [...] 8459 67 28_Re: High CPU usage on delete0_24_db46@DAIMLERCHRYSLER.COM31_Tue, 23 Jan 2001 10:47:10 -0500292_us-ascii If those 25 child tables use foreign keys, then on each row deleted from the parent, it must check the foreign keys on the dependent tables. If on delete restrict, then it stops, if on delete cascade it then deletes those rows and searches for any FK's on that table and so on. [...] 8527 12 35_Re: imagecopy suddenly running long0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 Jan 2001 10:29:37 -0600302_us-ascii Has someone altered the tablespace to TRACKMOD=NO ?

================================================ 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. 8540 48 14_regarding load17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Tue, 23 Jan 2001 10:27:39 -0600310_- Hi Folks,

In our shop we are using DB2 V6 on OS390. i unloaded the data using REORG UNLOAD ONLY. but when i tried to load the data back to the table it is giving problem. it is saying

THE COMPRESSION DICTIONARY WAS NOT BUILT FOR TABLE SPACE (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 [...] 8589 18 46_European IDUG in Florence...req for some info.10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 23 Jan 2001 17:32:55 +0100461_us-ascii I need some informations about the costs and how to subscribe at next European IDUG in Florence, October 2001. I checked IDUG web site but I didn't find any information.



Thank for help Max Scarpa

================================================ 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. 8608 69 18_Re: regarding load16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 23 Jan 2001 11:36:35 -0500513_iso-8859-1 Ravi, Have you looked in SYSERR and SYSMAP datasets?

regards,

eric pearson NS ITO Database Support



-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Tuesday, January 23, 2001 11:28 AM To: DB2-L@RYCI.COM Subject: regarding load



Hi Folks,

In our shop we are using DB2 V6 on OS390. i unloaded the data using REORG UNLOAD ONLY. but when i tried to load the data back to the table it is giving problem. it is saying [...] 8678 80 37_Re: Isolation Level 'UR' (dirty read)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 23 Jan 2001 11:43:42 -0500394_ISO-8859-1 Steve

You will get page or row locks if there is any updating SQL in the package. Updates will use ISOLATION(CS) even in a UR package. Only the read-only SQL runs UR. Also there might be overrides coded on the SQL, e.g. SELECT ... WITH CS.

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner [...] 8759 103 42_500+ links about DB2 for OS/390 (01/22/01)6_DB2usa18_db2usa@HOTMAIL.COM31_Tue, 23 Jan 2001 10:40:17 -0600736_ISO-8859-1 Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes):

- English : http://www.db2usa.com - Franηais: http://www.db2france.com

Last update on Monday, January 22nd 2001 ========================================

* Technical papers: http://db2usa.hypermart.net/earticle.htm

December 2000 issue of IDUG Journal is available on line: - Mining the DB2 catalog with SQL by Suresh Sane, IDUG journal, December 2000. - SQL: Building Block #1 by Sheryl Larsen, IDUG journal, December 2000. - DB2 for OS/390: Version 5 vs Version 6 Outer Join Performance by Maryela Weihrauch, IDUG journal, December 2000. - The Seedy Underworld of DB2 UDB for OS/390 by Chad Reiber, IDUG journal, [...] 8863 53 43_Re: A separate subsystem for Peoplesoft HR?13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 23 Jan 2001 10:50:48 -0600562_iso-8859-1 We run it in the same sub-system. DB2 is robust enough to handle it. I treat it like another application. glenn

-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Monday, January 22, 2001 2:15 PM To: DB2-L@RYCI.COM Subject: A separate subsystem for Peoplesoft HR?



Hi.

Our shop is relatively new to DB2 / OS390. We've had it installed for a little over a year, and are implementing our first production system (an in-house developed general ledger app.) this upcoming weekend. [...] 8917 84 14_regarding load15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 10:51:43 -0600384_us-ascii Ravi , I think you needed to use FORMAT UNLOAD option as well. May be I'm wrong , lets see what others will suggest.

//SYSIN DD * LOAD DATA INDDN SYSREC01 REPLACE LOG NO FORMAT UNLOAD INTO TABLE USERID.TABLE_NAME /*



Regards Nayeem ---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 10:45 AM --------------------------- [...] 9002 141 16_Re: Load Utility22_Walls, Lucious MANTECH20_TCI1@BUPERS.NAVY.MIL31_Tue, 23 Jan 2001 12:09:09 -0500693_iso-8859-1 Rick,

I used your example to unload selected data from one of our production tables. I submitted the following JCL:

//UNLOAD EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2P) RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB51) - LIB('SYS2A.MCXX.DB2.RUNLIB.LOAD') - PARMS('SQL') /* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSREC00 DD UNIT=3380,SPACE=(CYL,(250,50)),DISP=(NEW,CATLG,DELETE), // DSN=KMDB.DSNTIAUL.SYSREC00.ENLSTS //SYSPUNCH DD UNIT=3380,SPACE=(TRK,(1,1)),DISP=(NEW,CATLG,DELETE), // DSN=KMDB.DSNTIAUL.SYSPUNCH.ENLSTS //SYSIN DD * SELECT * FROM XXXXXDPD.KM_ENLISTED WHERE SUBSTR(SSN,9,1) IN ('1', '3', '5', '7', '9') /* // [...] 9144 83 18_Re: regarding load0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 Jan 2001 11:09:43 -0600552_us-ascii Why don't you try REORG UNLOAD EXTERNAL ?







ravi kumar hassan To: DB2-L@RYCI.COM Subject: regarding load Sent by: DB2 Data Base Discussion List



01/23/2001 10:27 AM Please respond to DB2 Data Base Discussion List











Hi Folks,

In our shop we are using DB2 V6 on OS390. i unloaded the data using REORG UNLOAD ONLY. but when i tried to load the data back to the table it is giving problem. it is saying [...] 9228 38 50_FW: European IDUG in Florence...req for some info.13_Morrill, John12_JohnM@VP.NET31_Tue, 23 Jan 2001 10:13:30 -0700599_- Greetings Max!

I forward your e-mail to idug@idug.org

I check the site myself and only found the instructions for submitting papers. They may not have open registration yet.

Cheers!

John

-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Tuesday, January 23, 2001 9:33 AM To: DB2-L@RYCI.COM Subject: European IDUG in Florence...req for some info.



I need some informations about the costs and how to subscribe at next European IDUG in Florence, October 2001. I checked IDUG web site but I didn't find any information. [...] 9267 14 16_Re: Load Utility13_Larry Jardine22_larry.jardine@WCOM.COM31_Tue, 23 Jan 2001 12:06:31 -0500280_iso-8859-1 Don't forget the semicolon.

================================================ 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. 9282 49 38_Re: CLI0616E - Starting Control Center21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Tue, 23 Jan 2001 12:12:43 -0500665_iso-8859-1 Troy, Make sure you have the Java Applet server running. Issue db2jstrt 6790 to start the process.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Troy Coleman Sent: Tuesday, January 23, 2001 9:39 AM To: DB2-L@RYCI.COM Subject: CLI0616E - Starting Control Center



Hello List, I am at a client site and requested DB2 UDB to be installed on my WIN 98 desktop. Once the install was completed Fix pack 6 was put on. Once that was done I tried to open information center and/or control center and receive error CLI0616E. The text is: "[IBM][JDBC Driver] CLI0616E [...] 9332 158 16_Re: Load Utility13_Daley, Norman18_NDaley@CINERGY.COM31_Tue, 23 Jan 2001 12:14:54 -0500942_iso-8859-1 You dropped the finicky ';' at the end.

Norm Daley Cinergy

-----Original Message----- From: Walls, Lucious MANTECH [mailto:TCI1@BUPERS.NAVY.MIL] Sent: Tuesday, January 23, 2001 12:09 PM To: DB2-L@RYCI.COM Subject: Re: Load Utility



Rick,

I used your example to unload selected data from one of our production tables. I submitted the following JCL:

//UNLOAD EXEC PGM=IKJEFT01,DYNAMNBR=20 //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DB2P) RUN PROGRAM(DSNTIAUL) PLAN(DSNTIB51) - LIB('SYS2A.MCXX.DB2.RUNLIB.LOAD') - PARMS('SQL') /* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSREC00 DD UNIT=3380,SPACE=(CYL,(250,50)),DISP=(NEW,CATLG,DELETE), // DSN=KMDB.DSNTIAUL.SYSREC00.ENLSTS //SYSPUNCH DD UNIT=3380,SPACE=(TRK,(1,1)),DISP=(NEW,CATLG,DELETE), // DSN=KMDB.DSNTIAUL.SYSPUNCH.ENLSTS //SYSIN DD * SELECT * FROM XXXXXDPD.KM_ENLISTED WHERE SUBSTR(SSN,9,1) IN ('1', '3', '5', '7', [...] 9491 62 28_Re: Version 7 NT UDB Fixpak215_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Tue, 23 Jan 2001 12:09:45 -0500557_us-ascii what is the url for downloading db2 7.1 fixpak2?

"Martin, Paul" wrote:

> We don't have PKZIP for windows on our workstations. > It is kind of frustrating that a vendor will give you a fix for a problem, > compress it, give you a program (i.e. PKUNZIP.EXE) and say use this program > to unzip the compress file and expect you to go to another vendor to secure > software that will in fact uncompress the fix. > This isn't the first fixpak that we had to use winzip32 to uncompress it! > > -----Original Message----- > From: Ellen [...] 9554 109 18_Re: regarding load17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Tue, 23 Jan 2001 11:10:34 -0600671_- Hi Mohamed,

Thank you very much.... it works fine... i was missing FORMAT UNLOAD in SYSIN statement.

Thanks Kumar



>From: Mohammed Nayeem >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: regarding load >Date: Tue, 23 Jan 2001 10:51:43 -0600 > >Ravi , I think you needed to use FORMAT UNLOAD option as well. >May be I'm wrong , lets see what others will suggest. > >//SYSIN DD * >LOAD > DATA > INDDN SYSREC01 > REPLACE > LOG NO > FORMAT UNLOAD > INTO TABLE USERID.TABLE_NAME >/* > > >Regards >Nayeem >---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on [...] 9664 172 16_Re: Load Utility0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 23 Jan 2001 11:43:17 -0600534_us-ascii Try indenting you SELECT statement at least one more space.









"Walls, Lucious MANTECH" @RYCI.COM> on 2001/01/23 11:09:09 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Re: Load Utility



Rick,

I used your example to unload selected data from one of our production tables. I submitted the following JCL: [...] 9837 57 38_Re: CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 23 Jan 2001 12:51:37 -0500507_ISO-8859-1 Jim, I tried DB2JSTRT 6790 and just DB2JSTRT and receive the same error.

Troy



>>> brownjr@CI.RICHMOND.VA.US 01/23/01 12:12PM >>> Troy, Make sure you have the Java Applet server running. Issue db2jstrt 6790 to start the process.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Troy Coleman Sent: Tuesday, January 23, 2001 9:39 AM To: DB2-L@RYCI.COM Subject: CLI0616E - Starting Control Center [...] 9895 207 16_Re: Load Utility16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Tue, 23 Jan 2001 12:53:24 -0500479_us-ascii Lucious,

Place a semicolon at the end of the SELECT * statement.

SELECT * FROM XXXXXDPD.KM_ENLISTED WHERE SUBSTR(SSN,9,1) IN ('1', '3', '5', '7', '9') ;

FYI - indentation has nothing to do w/ the error you are receiving!!!!



Rick Molera

Mainframe DB2 DBA











Rohn.Solecki@MTS.MB.CA on 01/23/2001 12:43:17 PM

Please respond to DB2 Data Base Discussion List [...] 10103 182 16_Re: Load Utility22_Walls, Lucious MANTECH20_TCI1@BUPERS.NAVY.MIL31_Tue, 23 Jan 2001 13:00:37 -0500327_iso-8859-1 Hi Listers,

The UNLOAD JOB works fine now. I was missing the ';' at the end of the SQL statements submitted after SYSIN DD *.

Thanks everyone for all of your great advice. These new UNLOAD parameters are going to make loading the test tables a whole lot easier and faster.

Lucious Mantech. [...] 10286 117 38_Re: CLI0616E - Starting Control Center23_Rajgopalan Swaminaathan44_rajgopalan.swaminaathan@FARMERSINSURANCE.COM31_Tue, 23 Jan 2001 09:52:03 -0800497_iso-8859-1 May be you have not opted for starting the db2 services automatically when your machine comes up during installation.. so please start all the db2 services manually from outside and then try going to control center.









Troy Coleman cc: (bcc: Rajgopalan Swaminaathan/HO/Farmers/USA/Zurich) 01/23/01 Subject: Re: CLI0616E - Starting Control 09:51 AM Center Please respond to DB2 Data Base Discussion List [...] 10404 25 13_Remote access12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Tue, 23 Jan 2001 13:22:54 -0500341_us-ascii Excuse my ignorance here please,but here is a scenario that I don't have an answer for.

Scenario: Application running on SYSTEM A wants to access DB2 on SYSTEM B, but there is no DB2 running on SYSTEM A and both systems are OS/390. How do we do it.....

Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support [...] 10430 85 28_Re: Version 7 NT UDB Fixpak213_Ellen Richter19_e2richte@HEWITT.COM31_Tue, 23 Jan 2001 12:55:47 -0600498_us-ascii URL is FTP://FTP.software.ibm.com/ps/products/db2/fixes/english-us. If downloading db2ntv71 (DB2 - Windows NT v7.1) you must put a back slash in the URL.











From: Benjamin Reches on 01/23/2001 11:09 AM

Please respond to Benjamin.Reches@msdw.com

To: DB2-L@RYCI.COM cc: Client: Subject: Re: Version 7 NT UDB Fixpak2

what is the url for downloading db2 7.1 fixpak2?

"Martin, Paul" wrote: [...] 10516 31 18_Row Level Security9_Norm Kern18_nkern@TOGETHER.NET31_Tue, 23 Jan 2001 13:51:22 -0500621_iso-8859-1 We are moving some applications from IDMS to DB2. We currently use DB Procedures upon obtaining data from certain record types (tables). These procedures are called automatically based on some hard-wiring within IDMS (via the Schemas).



These procedures perform logic to see if the individual is looking at his own records, if he can look at agents within his agency (if an agency office manager) or at other agencies (if set up as an alternative agency). In addition, some data on some of the records is 'masked' to make it unavailable to 'most' users. All told, the current assembler exit [...] 10548 21 35_Re: imagecopy suddenly running long7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Tue, 23 Jan 2001 12:57:50 -0600443_- Bill,

>Has some massive update/insert of data occurred that resulted in most pages >being updated and hence your incremental now copies almost as much as a >fullcopy plus the overhead of checking which pages have changed?

Absolutely no massive changes have happened. In fact the same IIC that ran 12 hours earlier took just 25min. Also Fullcopy of all these tablespaces takes around 90min. We use IBM imagecopy on DB2 V6. [...] 10570 18 35_Re: imagecopy suddenly running long7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Tue, 23 Jan 2001 13:01:12 -0600464_- Tim,

>Has someone altered the tablespace to TRACKMOD=NO ?

No alter of any of the tablespaces have been made. We noticed that there were some DFDSS dump of unrelated volumes going on at same time.

Sri

================================================ 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. 10589 33 17_Re: Remote access13_Thomas Dunlap25_tsdunlap@WORLDNET.ATT.NET31_Tue, 23 Jan 2001 14:26:24 -0500301_us-ascii Stan Goodwin wrote: > > Excuse my ignorance here please,but here is a scenario that I don't have an > answer for. > > Scenario: Application running on SYSTEM A wants to access DB2 on SYSTEM B, > but there is no DB2 running on SYSTEM A and both systems are OS/390. How do > we do it..... [...] 10623 123 38_Re: CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 23 Jan 2001 14:48:39 -0500495_ISO-8859-1 Jim, I didn't think you had any options under WIN98. I think I may have a bad install of WIN98 or something missing. The person next to me has WIN98 however a different machine and his Control Center worked fine after an initial install. I know under WINNT or WIN2000 you have services that auto start. The person next to me has a task run when I press CNTL-ALT-DEL "Db2id". I do not have this task running. I've tried DB2STOP & DB2START. These commands do not work under win98. [...] 10747 211 16_Re: Load Utility19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 23 Jan 2001 13:45:51 -0600612_iso-8859-1 Lucious, it might help to order the unloaded data in clustering index order. This wouldn't be recommended if the table is quite large -- reorg is faster.

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. [...] 10959 163 37_Re: FW: Insert & Update using VARCHAR11_John Puglia16_jpuglia@IWON.COM31_Tue, 23 Jan 2001 14:49:59 -0500409_ISO-8859-1 Sorry, for not getting back sooner, was occupied with some production problems.

Thank you to everyone who has responded.

Yes I have an explanation to my phenomenon.

First of all this is the layout of one of those fields and the code to the program.

TABLE

XYZ_COL VARCHAR (55) NOT NULL WITH DEFAULT





01 DCLGEN

10 XYZ_COL CHAR(55) [...] 11123 60 17_Re: Remote access11_rick creech18_ykcirc@HOTMAIL.COM31_Tue, 23 Jan 2001 13:43:28 -0600644_- Also,

This is the capability of data-sharing. You would have a DB2 engine(member of the data sharing group) on each os/390, but they share the DB2 catalog and of course access the same application database.

HTH,

Rick Creech



>From: Thomas Dunlap >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Remote access >Date: Tue, 23 Jan 2001 14:26:24 -0500 > >Stan Goodwin wrote: > > > > Excuse my ignorance here please,but here is a scenario that I don't have >an > > answer for. > > > > Scenario: Application running on SYSTEM A wants to [...] 11184 42 17_Re: Remote access13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 23 Jan 2001 14:06:46 -0600453_US-ASCII Hello Stan, Are these systems sharing DASD and other resources ?. You could use APPC to do the job. HTH Kurt



>>> STANLEY_GOODWIN@MECH.DISA.MIL 01/23/01 12:22PM >>> Excuse my ignorance here please,but here is a scenario that I don't have an answer for.

Scenario: Application running on SYSTEM A wants to access DB2 on SYSTEM B, but there is no DB2 running on SYSTEM A and both systems are OS/390. How do we do it..... [...] 11227 24 37_Re: FW: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 23 Jan 2001 15:28:26 -0500341_iso-8859-1 Thanks for the very perplexing response, John.

I must be wrong in asserting that you need lengths.

Everything I've seen and all code I have experimented with convince me that you do need the length and that the precompile fails if you don't supply the proper structure or DB2 uses the first 2 bytes for length. [...] 11252 98 37_Re: FW: Insert & Update using VARCHAR13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 23 Jan 2001 14:39:22 -0600404_US-ASCII Hello Dave, I'm sticking to my experiences on this one. If you do not supply DB2 with a length for the varchar field DB2 will pad the field to its maximum length. Both Sanjeev and John have provided good examples. Regards, Kurt









>>> Dave_Seibert@COMPUWARE.COM 01/23/01 08:14AM >>> Hi Sanjeev,

If that is what Kurt is saying, I have to disagree. [...] 11351 26 37_Re: FW: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 23 Jan 2001 15:58:32 -0500348_iso-8859-1 Hey Kurt, Thanks for the reply.

That's why I give up.

I tried what John describes and I get the precompile error. DSNH312I E DSNHSMUD LINE 65 COL 31 UNDEFINED OR UNUSABLE HOST VARIABLE So, I have no explanation.

Glad you all persevered and didn't let me get away with ponitificating on something that is wrong. [...] 11378 32 19_parallel processing17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Tue, 23 Jan 2001 14:55:10 -0600576_- Hi Folks,

We are using DB2 V6. on OS390, We are having problem with DEGREE OPTION in BIND, All these days we were using DEGREE (ANY) while binding a program in PROD. environment. if i am right this allows the parallel processing becuase of this it improves the performance.... can somebody just explain how this parallel processing works???? the job was taking lots of lots time because of this we changed to DEGREE (1) as a default and rebinded the . if i am right this option does not allow for parallel processing so it should reduce the performance..... but [...] 11411 31 41_DB2 listening thru multiple TCP/IP stacks17_Belfield, Alma G.21_Alma.Belfield@TWA.COM31_Tue, 23 Jan 2001 15:07:02 -0600615_iso-8859-1 We're implementing TCP/IP into DDF (now we have the pre-req OS/390 level) and are struggling with multiple TCP/IP stacks. We have several LPARs spread across two physical machines and each LPAR normally runs just one TCP/IP stack, and the DB2 subsystems running on that LPAR obviously need to be accessed thru that stack. But sometimes we move the workload of some LPARs onto another LPAR (hardware upgrades etc), and during these periods we run several TCP/IP stacks within the one OS/390 LPAR. In this situation, DB2 'connects' to all the running stacks i.e. the DRDA port is active and listening [...] 11443 178 42_Re: AW: CLI0616E - Starting Control Center14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Tue, 23 Jan 2001 13:17:16 -0800546_iso-8859-1 Troy, The only way that I have ever been able to run the Control Center under win98 is to do the following from a DB2 command window: db2jstrt 7000 db2cc 7000

The 7000 is an abitrary port number. Both the jdbc service (started via db2jstrt) and the Control Center need to use the same port (7000 in my example). They both are supposed to default to 6789, but I have had problems with this on win98. Good luck. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 11622 79 42_Re: AW: CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Tue, 23 Jan 2001 16:38:33 -0500386_ISO-8859-1 I tried this and it didn't work. The client has several machines with win98. They installed on one of them and everything was OK. However, several machines have the same problem as me. I installed on my home machine win98 with no problems. We also have a machine here with no problem. I think my machine must have had a bad install of win98. Thanks for the information. [...] 11702 50 19_db2 6.1 ddf and wlm0_24_lightsey@ITS.STATE.MS.US31_Tue, 23 Jan 2001 15:24:42 -0600477_us-ascii Background: 12 days ago we converted the production db2 from v5.1 to v6.1 ( os/390 2.8 ) and ever since we've had some major issues with the amount of cpu being gobbled by the enclaves. We are running wlm goal-mode, have been for a couple of years, and didn't change any of the definitions in wlm to start with. CPU jumped from significant-but-livable ( 12% - 40% total on a r36) to an unreasonable level where nearly 100% of the r36 was claimed by the enclaves. [...] 11753 179 42_Re: AW: CLI0616E - Starting Control Center15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 15:34:34 -0600520_us-ascii





Hi Wayne Driscoll

I have also tried this way & I'am able to go in control center where i found only SYSTEMS and i am not getting instances ....etc......etc... how to configure this.

Thanks Nayeem ---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 03:27 PM ---------------------------



Wayne Driscoll on 01/23/2001 03:17:16 PM

Please respond to DB2 Data Base Discussion List [...] 11933 68 41_LinkEdit of WLM-managed Stored Procedures13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Tue, 23 Jan 2001 16:49:18 -0500415_US-ASCII List,

Here's our next round of implementation issues. We are DB2 for OS/390 V6.1, data sharing, WLM-enabled. We've done the Create Procedure, including the WLM environment name, WLM proc is in ProcLib, WLM Application Environment is defined, etc.

Funny thing is, when we try the obvious thing during the Program Preparation LinkEdit step (Linkedit with "DSNRLI"), we get these messages: [...] 12002 25 45_Re: LinkEdit of WLM-managed Stored Procedures0_19_Tim.Lowe@STPAUL.COM31_Tue, 23 Jan 2001 15:53:33 -0600385_us-ascii It would appear that SP01 already includes DSNALI before you attempt to include DSNRLI. (Perhaps this module has already gone through linkedit and the DSNHLI call has been resolved to DSNALI?) If you want to replace DSNALI (CAF) with DSNRLI (RRS), you could try this: REPLACE DSNALI INCLUDE SYSLIB(DSNRLI) (I think I have this right) Or, you could you just recompile it? [...] 12028 137 42_Re: AW: CLI0616E - Starting Control Center15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 15:55:33 -0600494_us-ascii





I'm getting this in control center :

"The DB2 Administration Server is not active. SQLSTATE=08001"



I have started using command 'db2 db2start' in command window too. Is path setting is needed , I have checked using 'db2set -all' also Any input on this helps me.

Thanks in advance Nayeem





---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 01/23/2001 03:48 PM --------------------------- [...] 12166 22 20_Control Center issue15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 15:58:54 -0600565_us-ascii Hi all I'm getting this in control center :

"The DB2 Administration Server is not active. SQLSTATE=08001"

I have started using command 'db2 db2start' in command window too. Is path setting is needed , I have checked using 'db2set -all' also Any input on this helps me.

Thanks in advance Nayeem

================================================ 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. 12189 47 24_Re: Control Center issue15_Stacey L Waters23_waterss1@NATIONWIDE.COM31_Tue, 23 Jan 2001 16:04:27 -0600569_us-ascii Have you done a db2admin start?









Mohammed Nayeem @RYCI.COM> on 01/23/2001 03:58:54 PM

From: Mohammed Nayeem @RYCI.COM on 01/23/2001 03:58 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Control Center issue

Hi all I'm getting this in control center :

"The DB2 Administration Server is not active. SQLSTATE=08001" [...] 12237 35 24_Re: Control Center issue11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 23 Jan 2001 17:04:08 -0500684_us-ascii Try:

db2admin start

-Scott

Mohammed Nayeem wrote in message news: <862569DD.007778A1.00@momed.com>... > Hi all > I'm getting this in control center : > > "The DB2 Administration Server is not active. SQLSTATE=08001" > > I have started using command 'db2 db2start' in command window too. > Is path setting is needed , I have checked using 'db2set -all' also > Any input on this helps me. > > Thanks in advance > Nayeem > > ================================================ > 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 [...] 12273 16 24_Re: Control Center issue15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 16:10:18 -0600413_us-ascii I ran this but not solved

DB2CLP C:\SQLLIB\bin>db2 db2admin start DB21034E The command was processed as on SQL statement because it was not a valid command

================================================ 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. 12290 114 42_Re: AW: CLI0616E - Starting Control Center22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 23 Jan 2001 17:09:13 -0500544_iso-8859-1 The DB2 Administration Server must be started. The start command is 'db2admin start' without the quotes. The stop command is 'db2admin stop' without the quotes.

db2start starts the DBMS engine.





Mike Piontkowski TP&S Technical Maintenance Voice: +1 302.886.4612 Fax: +1 302.886.4749



-----Original Message----- From: Mohammed Nayeem [mailto:Mohammed_Nayeem@MOMED.COM] Sent: Tuesday, January 23, 2001 16:56 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] AW: CLI0616E - Starting Control Center [...] 12405 42 24_Re: Control Center issue15_Stacey L Waters23_waterss1@NATIONWIDE.COM31_Tue, 23 Jan 2001 16:17:28 -0600539_us-ascii Was the "db2admin start" command issued on the server where the database is running?









Mohammed Nayeem @RYCI.COM> on 01/23/2001 04:10:18 PM

From: Mohammed Nayeem @RYCI.COM on 01/23/2001 04:10 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: Re: Control Center issue

I ran this but not solved [...] 12448 41 24_Re: Control Center issue22_Piontkowski, Michael L35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 23 Jan 2001 17:17:43 -0500478_iso-8859-1 Do not specify 'db2 db2admin start' specify 'db2admin start' It's a command that must be executed by the operating system not the DB2 command processor.





Mike Piontkowski TP&S Technical Maintenance Voice: +1 302.886.4612 Fax: +1 302.886.4749



-----Original Message----- From: Mohammed Nayeem [mailto:Mohammed_Nayeem@MOMED.COM] Sent: Tuesday, January 23, 2001 17:10 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Control Center issue [...] 12490 12 24_Re: Control Center issue15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 16:20:01 -0600254_us-ascii Yes

================================================ 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. 12503 110 16_Re: Load Utility22_Walls, Lucious MANTECH20_TCI1@BUPERS.NAVY.MIL31_Tue, 23 Jan 2001 17:24:29 -0500416_iso-8859-1 Sanjeev,

I ran the Load job last week and I don't have the output listings from those jobs. I'm certain the errors I got were SQL syntax errors. DB2 didn't like the way I contructed the WHEN clause. If you have know how to properly contruct a WHEN clause using multiple field-selection-criteria I will be interested in seeing an example. Post it on the DB2 Discussion List or e-mail it to me. [...] 12614 12 24_Re: Control Center issue15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 23 Jan 2001 16:29:31 -0600312_us-ascii Actually I have installed personal edition on pc with win 98.

================================================ 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. 12627 93 37_Re: Isolation Level 'UR' (dirty read)12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 24 Jan 2001 09:30:51 +1100546_- Stephen, also don't forget if you are looking at the at the locks the thread has taken, there will also be locks that have been taken against Catalogue & Directory tables, for the tables being accessed, and the plan/packages being used.

But like Max (Ciao Max e ciao mio amici a Italia) was saying, I vaguely recall something being said about quasi mass delete locks, but I can't remember why. If any one knows better please chirp up. Anyway I still believe that unless the application needs 100% accurate data UR is the way to go. [...] 12721 50 37_Re: FW: Insert & Update using VARCHAR14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 09:42:42 +1100441_iso-8859-1 Dclgen Definition : 02 VAR1. 49 VAR1-LEN PIC S9(4) COMP. 49 VAR1-TEXT PIC X(40).

This is invalid, since VAR1-LEN should be unsigned. Which leads onto my real point:

I tried what John describes and I get the precompile error. DSNH312I E DSNHSMUD LINE 65 COL 31 UNDEFINED OR UNUSABLE HOST VARIABLE So, I have no explanation. [...] 12772 28 5_Barf?15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 24 Jan 2001 10:37:13 +1100447_- ..sometimes it is some minor thing that makes DB2 barf ...

Barf? Barf?! Good grief, no wonder the French get upset about the 'cultural hegemony of the US'. What's wrong with puke? Spew, even? How about up-chuck, hurl, or just vom'? Or, my particular favourite (especially given my current locale), chunder? Anyone remember 'Men at Work'? You know, Vegemite sandwiches, etc.? No? Oh well... [...] 12801 37 45_Re: LinkEdit of WLM-managed Stored Procedures14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 10:41:04 +1100331_iso-8859-1 Are you recompiling from source, or are you re-linkling the V5 load module? A MAP option on the link step might help you resolve where your are getting DSNALI from.

Another possibile way of handling this is to specify ATTACH(RRSAF) in precompilation. This will generate calls to DSNHLIR (instead of DSNHLI). [...] 12839 53 16_Re: Load Utility14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 10:44:23 +1100450_iso-8859-1 perhaps you still have the LOAD statement you used? Even without the error messages it might help us construct a valid WHEN.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Walls, Lucious MANTECH [mailto:TCI1@BUPERS.NAVY.MIL] Sent: Wednesday, January 24, 2001 9:24 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Load Utility [...] 12893 34 26_DB2/400 SQL Tuning Choices15_Schmidt, Mike J20_Mike.Schmidt@MKG.COM31_Tue, 23 Jan 2001 17:43:19 -0600623_iso-8859-1 I'm an Oracle DBA/Developer transitioning to DB2 UDB for AS/400. I'm new to DB2/400 and this listserv but I will try not to waste your time.

My question is related to SQL tuning, explain plans, and performance statistics. I know how to approach these tasks with Oracle installations but I'm facing a learning curve doing the same with DB2. Where would you focus your SQL tuning education efforts? For example: should I start using the GUI-based "Operations Navigator" tools ("Visual Explain") or will I need to get under the covers and use AS/400 commands like STRDBMON to generate performance data? [...] 12928 60 17_Re: Remote access14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 11:15:45 +1100473_iso-8859-1 Is CICS running on both systems with cross-system MRO? Then you should be able to put together an EXCI application to get to system B.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Stan Goodwin [mailto:STANLEY_GOODWIN@MECH.DISA.MIL] Sent: Wednesday, January 24, 2001 5:23 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Remote access Importance: High [...] 12989 65 26_Re: VSAM naming convention15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 24 Jan 2001 11:22:51 +1100483_- Good question, Julian. We've got a tablespace in a testing environment that I've just noticed is simple (!). It's flipped to a couple of datasets, each exactly (within 5 tracks, according to my rough calculations) 2Gb i.e. 43695 tracks. This is consistent with the Admin Guide which states, 'The maximum size of a data set in the simple table space is 2 gigabytes'. It also says up to 4Gb per partition, but I dont' know if it'll all go in one dataset. One way to find out... [...] 13055 59 9_Re: Barf?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 11:35:05 +1100435_iso-8859-1 Every culture has words that create an emotional resonance with its members. It is because barf does _not_ has that resonance that allows me to use it - when the other words you mention are too coarse for my refined sensibilities.

James -----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Wednesday, January 24, 2001 10:37 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Barf? [...] 13115 50 37_Re: FW: Insert & Update using VARCHAR10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 24 Jan 2001 10:40:09 +1000456_ISO-8859-1 Dave,

U might have tried it with a variable defined at the level 49. If u try it with a variable defined at any other level like 01 or 05, the precompiler accepts it as a valid variable and does it as John described.

Cheers. Kals

-----Original Message----- From: Seibert, Dave [SMTP:Dave_Seibert@COMPUWARE.COM] Sent: Wednesday, January 24, 2001 7:59 AM To: DB2-L@RYCI.COM Subject: Re: FW: Insert & Update using VARCHAR [...] 13166 44 19_DB2 Estimator- help14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Wed, 24 Jan 2001 12:16:53 +1100678_iso-8859-1 **************************************************************** IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...] 13211 64 88_Repost: Help Needed for CIOView Project to Develop Data Managemen t Cost Estimating Tool13_Morrill, John12_JohnM@VP.NET31_Tue, 23 Jan 2001 18:52:18 -0700689_- -----Original Message----- From: Michael Swift [mailto:dbswift@us.ibm.com] Sent: Tuesday, January 23, 2001 5:44 PM To: DB2 Interested Parties Cc: Gordon Sears; nancyJ@us.ibm.com Subject: Help Needed for CIOView Project to Develop Data Management Cost Estimating Tool



Dear DB2 Interested Parties

We're looking for customers who would be willing to talk to CIOview, an affiliate of International Data Corporation (IDC), who are developing a Cost Estimating tool for IBM. CIOview would like to talk with you to try and understand how you are currently using IBM's Data Management software products. The purpose of this exercise is to try and gather a diverse set [...] 13276 46 9_Re: Barf?11_Doug Fuerst14_djfirst@LI.NET31_Tue, 23 Jan 2001 20:52:23 -0500652_us-ascii Veggiemite I know about (unfortunately), but chunder????? :-))



At 10:37 AM 1/24/2001 +1100, you wrote: > >..sometimes it is some minor thing that makes DB2 barf ... > > >Barf? Barf?! Good grief, no wonder the French get upset about the >'cultural hegemony of the US'. What's wrong with puke? Spew, even? How >about up-chuck, hurl, or just vom'? Or, my particular favourite (especially >given my current locale), chunder? Anyone remember 'Men at Work'? You >know, Vegemite sandwiches, etc.? No? Oh well... > >Sorry for the off-topic post. For some reason James' note ticked my funny [...] 13323 59 9_Re: Barf?15_Sydney Brereton21_sbrereton@MMAL.COM.AU31_Wed, 24 Jan 2001 12:51:31 +1030743_US-ASCII No different to 'laugh at the grass' or 'call Huey'.



______________________________ Reply Separator _________________________________ Subject: Re: Barf? Author: DB2 Data Base Discussion List at MMALHQ01 Date: 23/1/01 20:52



Veggiemite I know about (unfortunately), but chunder????? :-))



At 10:37 AM 1/24/2001 +1100, you wrote: > >..sometimes it is some minor thing that makes DB2 barf ... > > >Barf? Barf?! Good grief, no wonder the French get upset about the >'cultural hegemony of the US'. What's wrong with puke? Spew, even? How >about up-chuck, hurl, or just vom'? Or, my particular favourite (especially >given my current [...] 13383 59 37_Re: DB2 Estimator- help - belay that!14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Wed, 24 Jan 2001 13:29:33 +1100678_iso-8859-1 **************************************************************** IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...] 13443 43 37_Re: Isolation Level 'UR' (dirty read)14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 13:49:16 +1100575_iso-8859-1 Have you though of tracing IFCID 21 to see what is actually locked?

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Wednesday, January 24, 2001 12:33 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Isolation Level 'UR' (dirty read)



Could anyone shed any light on the 'locking' that takes place when using a package thats bound with an isolation level of 'UR'?? [...] 13487 78 9_Re: Barf?14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Wed, 24 Jan 2001 14:38:21 +1100678_iso-8859-1 **************************************************************** IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...] 13566 172 41_Re: Different results in program vs SPUFI14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Wed, 24 Jan 2001 14:47:15 +1100678_iso-8859-1 **************************************************************** IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...] 13739 88 33_Re: Insert & Update using VARCHAR14_Tennant, Steve24_Steve.Tennant@ATO.GOV.AU31_Wed, 24 Jan 2001 16:24:13 +1100678_iso-8859-1 **************************************************************** IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 2869 and delete all copies of this transmission together with any attachments. [...] 13828 66 23_Re: parallel processing14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Tue, 23 Jan 2001 23:39:59 -0600501_iso-8859-1 Kumar,

Seriously, since it takes pages to explain all the possibilities. There is a wonderful section on this in the DB2 Administration Manual. It should provide you with most of the information you need. It is several pages long.

Regards, Richard

Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums [...] 13895 40 37_Re: FW: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 24 Jan 2001 11:58:06 +0530985_- <<<<""""Glad you all persevered and didn't let me get away with ponitificating on something that is wrong.""""

""""David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com"""">>>>

=== Dave, I think this is what the list is made for.

Regards, Sanjeev ===



----------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this [...] 13936 130 33_Re: Insert & Update using VARCHAR16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 24 Jan 2001 12:01:38 +0530448_iso-8859-1 Steve, I agree with you but sometimes we do not blame COBOL because we are looking from some other perspective and that is DB2 should be smart enough not to do the padding. This is not logically possible and will become bugs, it has to pad the blanks because DB2 never know if blanks have got any meaning for the user. This is the reason i think length field is made for. If you want to save the space then code one more statement. [...] 14067 96 17_Re: Remote access16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 24 Jan 2001 12:06:28 +0530608_- Isn't this the place where we require DB2 Connect for OS/390, which we were discussing some 2 months back. Would that do the work what Stan's requirements are ?? I think so.

I am not sure i again want to start the discussion or not. Hoping for good !!

Regards, Sanjeev

> -----Original Message----- > From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] > Sent: Wednesday, January 24, 2001 5:46 AM > To: DB2-L@RYCI.COM > Subject: Re: Remote access > > Is CICS running on both systems with cross-system MRO? Then you should be > able to put together an EXCI application to get [...] 14164 73 22_Re: DB2 V6.1 migration23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 24 Jan 2001 06:28:09 -0000395_iso-8859-1 Stan

1. Image Coy & a snap 2. No as it was large enough 3. None

On the point of Catmaint .. there is some thought being given to making Catmaint a 24 x 7 thing .. i.e, if I am correct, there is some suggestions that you may be able to upgrade while you system is still running .. an interesting concept and one that I am sure a lot of people will be happy about .. [...] 14238 78 16_Re: Load Utility16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 24 Jan 2001 12:35:20 +0530390_- Hi Lucious,

I realized that you need to give multiple values for the positions to be used in the WHEN clause and hence the single LOAD card may not work. As said earlier, you have only 5 odd values then you can have 5 LOAD card using the same input dataset can serve the purpose but you need to defer the index building till last LOAD. Not a good solution to suggest i think. [...] 14317 16 41_Paul H Bohannon/msi is out of the office.20_Paul H. Bohannon Jr.21_PBohannon@MSIINET.COM31_Wed, 24 Jan 2001 01:01:19 -0600439_us-ascii I will be out of the office starting 01/24/2001 and will not return until 01/25/2001.

I will be out of the office 01/24/01 until 01/25/01 I will return your messages upon my return.

================================================ 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. 14334 75 26_Re: VSAM naming convention16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Wed, 24 Jan 2001 12:48:58 +0530627_- Julian,

I think this is not valid for Partitioned Tablespace. Partitioned Tablespace can have dataset defined upto 4 GB in size. This is valid for non-partitioned tablespace.

HTH Regards, Sanjeev

> -----Original Message----- > From: Peacock Julian [SMTP:Julian_Peacock@SWEB.CO.UK] > Sent: Tuesday, January 23, 2001 8:59 PM > To: DB2-L@RYCI.COM > Subject: VSAM naming convention > > Fellow DB2ers, > > If a tablespace has < 16 partitions, each partition can store up > to > 4Gb. VSAM can only handle 2Gb per dataset. So there must be 2 VSAM > datasets for each 4Gb partition! The Annn section of the [...] 14410 23 22_DB2 V6.1 & CICS TS 1.232_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 24 Jan 2001 09:21:00 +0200391_- Hello List,

In the near future we're planning to upgrade 6.1. We'll work with CICS TS 1.2 for a while with 6.1 until CICS TS 1.3.

How many of you using 6.1 and TS 1.2 to gather and do you have any special maintenance for CICS or DB2 for this combination.

Regards,



Cuneyt GOKSU Garanti Teknoloji Tel : 0090-212-4783210 mailto:Cuneytg@garanti.com.tr [...] 14434 19 9_Re: Barf?10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Jan 2001 08:38:51 +0100418_us-ascii Is 'barf' this a new features supported in DB2 V 8 ? ;-)

Or Is it an ORACLE wonder feature ?

Regards

Max Scarpa (who doesn't know what barf means)

================================================ 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. 14454 63 26_Re: DB2 V6.1 & CICS TS 1.214_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 24 Jan 2001 18:47:19 +1100352_iso-8859-1 Neither DB2 V6 nor CICS TS 1.2 supply DSNCLI or (I'm told) DSNCUEXT. (DB2 V6 expects CICS to supply them - which TS 1.3 does; CICS TS 1.2 expects DB2 to supply them.) Make sure you keep your DB2 V5 versions.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...] 14518 14 29_DSNTIAUL in Platinum Strategy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 24 Jan 2001 03:46:38 -0600456_- Hello list

I'm just trying to use DSNTIAUL with the Platinum's Batch processor, but I'm not able to succeed. Has anyone experience with that and can tell me, how to do. I would appreciate a little example.

================================================ 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. 14533 50 39_nmake error in Stored Procedure Builder11_Carl Newton30_newtonc@INNOVATION-GROUP.CO.UK31_Wed, 24 Jan 2001 09:54:01 -00001011_- All,

I am using the Stored Procedure Builder for the first time and have the received the following error

set SQLROUTINE_FILENAME=P4947620 set db2path=C:\PROGRA~1\SQLLIB

nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak

*** C:\PROGRA~1\SQLLIB\function\routine\sqlproc\GENIQ\DBO\tmp\P4947620.def *** LIBRARY P4947620 EXPORTS _pgsjmp@16 pgsjmp=_pgsjmp@16



C:\PROGRA~1\SQLLIB\function\routine\sqlproc\GENIQ\DBO\tmp>set SQLROUTINE_FILENAME=P4947620

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\GENIQ\DBO\tmp>set db2path=C:\PROGRA~1\SQLLIB

C:\PROGRA~1\SQLLIB\function\routine\sqlproc\GENIQ\DBO\tmp>nmake /f C:\PROGRA~1\SQLLIB\function\routine\sqlproc.mak

'nmake' is not recognized as an internal or external command, operable program or batch file.

------------------------------------------------------------------------ ----

SQL7032N SQL procedure "SP_ADDLOCK" not created. Diagnostic file is "P4947620.log". SQLSTATE=42904 [...] 14584 202 33_Re: DSNTIAUL in Platinum Strategy19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Wed, 24 Jan 2001 11:03:39 +0100394_iso-8859-1 Walter

Below is a sample strategy:-

--========================================================================== === -- V PLATINUM RC/COPY 01/22/01 09:49:47

--========================================================================== === --SOURCE INFORMATION:

-- TABLE ===> KRAM20_JCL_SKELTON

-- CREATOR ===> SQLUSRK

-- SSID ===> TSN

14787 39 37_Re: Isolation Level 'UR' (dirty read)14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 24 Jan 2001 04:27:05 -0600572_iso-8859-1 Using UR will mean you get the lowest number of locks. Any other type of isolation will give more locks.

All SQL activity on DB2 will result in locks on the DBD, the tablespace, table, and index(s) of the object you are accessing, and also on the package or plan. These locks ensure that other activity will not change the object structure or access paths while your SQL is running. It is part of DB2 basic integrity. Also, if you are running in data sharing mode there may be various additional p-locks taken. IBM does not give a public definition [...] 14827 17 54_Re: FW: European IDUG in Florence...req for some info.10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Jan 2001 11:42:02 +0100340_us-ascii Hi John, thank you. I appreciated it !! :-))

Regards

Max Scarpa DB2 sysprog

================================================ 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. 14845 31 46_DBRM Current Release Marker: Where documented?15_Hans Schuermann18_hschuermann@DIS.CH31_Wed, 24 Jan 2001 05:10:09 -0600313_- Hi all,

I' m going through our DBRM libraries in order to find out the precompiler version that created them. There is a current release marker in the DBRM header record (last byte of record, Field DBRMMRIC in macro DSNXDBRM) and I guess the meaning is:

'G': V4.1 'H': V5.1 'I' and 'J': V6.1 [...] 14877 38 33_Re: DSNTIAUL in Platinum Strategy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 24 Jan 2001 05:12:09 -0600397_- Neil

I should explain my problem a little bit deeper:

I've unloaded a table using DSNTIAUL with PARMS SQL with a similar SQL like that:

SELECT INTEGER(DIGITS(BD)!!AGT) , TIMESTAMP(BEARB_DAT, ZEIT) FROM DB2.OBTB0101 WHERE SPARTE IN ('AS', 'HA') AND VNR < '002000000'

Now I want to do that in a platinum strategy. When I use your proposal I've got a syntax error: [...] 14916 14 50_Re: DBRM Current Release Marker: Where documented?15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 24 Jan 2001 05:18:21 -0600424_- Hans

I think a description of these letters are in the SQL reference manual for the catalog table SYSIBM.SYSPACKAGE column IBMREQD. I believe that's the same as in the DBRM.

================================================ 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. 14931 22 24_Old consistency chestnut13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 24 Jan 2001 05:28:09 -0600428_- I fancy writing a little Rexx to display the three little contokens for a package: SYSPACKAGE, DBRM and LOAD MODULE.

I know how to get the contoken from the first two, and I know how to search for a contoken in the latter, but is there a way to merely extract the contoken from a load module? When I find a contoken in a load module, the position (row,column) in the load module is different for each load module. [...] 14954 72 22_Re: Row Level Security14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 24 Jan 2001 05:39:33 -0600300_iso-8859-1 I once designed an application that implemented row level security in DB2 using the Bell/La Padula model, with the object of getting as close to 'B1' security as possible. This was done back in the DB2 V3 days, but DB2 row level security has not changed since then (i.e. still none). [...] 15027 27 23_Re: parallel processing14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 24 Jan 2001 06:03:11 -0600377_iso-8859-1 There is no such thing as a quick description of how DB2 does parallel processing. If you are really interested in how this works, then look at the IBM Red Book web site and search for DB2 and parallel. I think there is a good description in one of those. Be aware that it may already be out of date, as IBM are adding to this functionality with every release. [...] 15055 16 26_Re: VSAM naming convention14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 24 Jan 2001 06:06:03 -0600442_iso-8859-1 The maximum size of a VSAM dataset depends on the level of VSAM you are using. The relevant information is given in the SQL manual in the section on DB2 limits.

From Edward Vassie...

================================================ 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. 15072 62 50_Re: DBRM Current Release Marker: Where documented?15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 24 Jan 2001 13:25:46 +0000546_us-ascii Hello Hans,

The release dependency marker 'J' was introduced with the support for identity columns in DB2 V6. Identity columns support was introduced with APAR PQ30652.

Regards,

Toine Michielse



Hans Schuermann @RYCI.COM> on 01/24/2001 11:10:09 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: DBRM Current Release Marker: Where documented? [...] 15135 41 9_Re: Barf?11_Doug Fuerst14_djfirst@LI.NET31_Wed, 24 Jan 2001 07:49:07 -0500702_us-ascii Gee, and I thought that was worshiping the porcelain god Ralf! :-))

Doug





snip>>>>>>>> >**************************************************************** >No No VEGEMITE and chunder is what usually >happen to a septic who tries it :-) Not to be >confused with technicolour yawn, or the >porcelain telephone (used when calling >the Great God Hughie). > >-----Original Message----- >From: Doug Fuerst [mailto:djfirst@LI.NET] >Sent: Wednesday, 24 January 2001 12:52 >To: DB2-L@RYCI.COM >Subject: Re: Barf? > > >Veggiemite I know about (unfortunately), but chunder????? :-)) snip.... Doug Fuerst Consultant BK Associates Brooklyn, NY (718) 921-2620 djfirst@li.net [...] 15177 19 9_Re: Barf?13_Henry J. Cobb14_hcobb@SLIP.NET31_Wed, 24 Jan 2001 06:54:23 -0600494_- Hey!

Barf's my favorite character from the movie Spaceballs.

Half man, half dog, he's his own best friend.

Henry J. Cobb hcobb@slip.net http://www.io.com/~hcobb Any sufficiently cool technology is indistinguishable from religion.

================================================ 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. 15197 13 9_Re: Barf?11_Eric Robida22_Eric_Robida@BCBSME.COM31_Wed, 24 Jan 2001 07:56:35 -0500360_us-ascii I kinda like 'tecnicolor-yawn' and 'worshipping at the porcelain altar'. I'll go back to lurking now.........

================================================ 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. 15211 20 3_DDF13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM31_Wed, 24 Jan 2001 07:10:14 -0600344_us-ascii For those of the list using DDF, what tcpip changes did you have to make to turn it on for DB2 V6? What ports are typically specified in the DB2 set up for DRDA and the resync port? Our shop wants to turn it on and it was never initially installed. Do I have to go back thru the clists or has anyone found an easy way to "cheat"? [...] 15232 82 33_AW: DSNTIAUL in Platinum Strategy12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Wed, 24 Jan 2001 14:11:43 +0100340_iso-8859-1 Hi Walter,

didn't test it, just an idea:

RC/M inplace migration with _D_ata only (Update Options - Exclusive Options). When you create migration strategy you have the possibility to select columns and to code a where clause. The disadvantage is, that you have to edit the output to delete the load statements. [...] 15315 61 45_Re: LinkEdit of WLM-managed Stored Procedures15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Wed, 24 Jan 2001 08:09:07 -0500436_iso-8859-1 ATTACH(RRSAF)in the precompilation is how we handled it - Works Great!

But I am still disillusioned about what actually happens between a calling module connected with DSNALI executing the WLM stored procedure that must run under DSNRLI.

I can't find evidence that a new thread using DSNRLI is created - But if it is created, what information is used to "fill in" the added parameters for that connection? [...] 15377 104 33_Re: DSNTIAUL in Platinum Strategy16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 24 Jan 2001 13:17:27 -0000656_iso-8859-1 You dont have to DELETE the LOAD statements. When executing the Batch Processor, you can specify UNLOAD MODE ===> U which ONLY executes the batch processor statements containing the UNLOAD commands.

Best regards Steen

> -----Original Message----- > From: Thomas Weber [SMTP:thomas.weber@LDS.NRW.DE] > Sent: Wednesday, January 24, 2001 2:12 PM > To: DB2-L@RYCI.COM > Subject: AW: DSNTIAUL in Platinum Strategy > > Hi Walter, > > didn't test it, just an idea: > > RC/M inplace migration with _D_ata only (Update Options - Exclusive Options). > When you create migration strategy you have the possibility to select columns > and [...] 15482 65 37_Re: FW: Insert & Update using VARCHAR13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 24 Jan 2001 08:36:13 -0500367_iso-8859-1 Thanks again to all correcting me. Thanks especially to James Campbell for suggesting I double-check the precompile error and declaration. It is as you and Kals and others suggested -- there is another problem with the host variable. I guess that's why they don't pay me to be a Cobol programmer anymore (come to think of it, no one ever really did). [...] 15548 21 31_Case Stmt Enhancements in V7???11_David Nance16_DWNance@FHSC.COM31_Wed, 24 Jan 2001 08:36:43 -0500367_US-ASCII I was looking through the what's new in V7 yesterday, looking for info about the case stmt and found none. Would anyone happen to know if there are plans to enhance the case stmt to allow subselects, 'exists', and 'in' predicates? I can make sense of not allowing a subselect in a case stmt in the select clause, but not for a case in the where clause. [...] 15570 124 37_Re: Isolation Level 'UR' (dirty read)10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Jan 2001 14:45:57 +0100321_us-ascii Ciao Nick....

I suppose you heard about mass delete in some discussion about REORG SHRLEVEL CHANGE, where there's a mass delete lock. It's used (mainly) to prevent a delete of all the rows from a table while the 'claimer' online reorg is running (in segmented tables, very good for massive deletes). [...] 15695 74 9_Re: Barf?15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Wed, 24 Jan 2001 09:26:43 -0500548_iso-8859-1 I personally prefer to say that it "consumed excrement and expired". It travels much better in polite company. ;)

-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, January 23, 2001 7:35 PM To: DB2-L@RYCI.COM Subject: Re: Barf?



Every culture has words that create an emotional resonance with its members. It is because barf does _not_ has that resonance that allows me to use it - when the other words you mention are too coarse for my refined sensibilities. [...] 15770 156 37_Re: Isolation Level 'UR' (dirty read)10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 24 Jan 2001 08:39:39 -0600530_- This is an extract from DB2 for OS/390 V5 Application Programming and SQL Guide: 4.2.5.1.4:

"Restrictions on Concurrent Access: An application using UR isolation cannot run concurrently with a utility that drains all claim classes. Also, the application must acquire two types of lock:

A special mass delete lock acquired in S mode on the target table or table space. A "mass delete" is a DELETE statement without a WHERE clause; that operation must acquire the lock in X mode and so cannot run concurrently. [...] 15927 78 50_Re: DBRM Current Release Marker: Where documented?12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 24 Jan 2001 09:00:21 -0600583_iso-8859-1 Hans:

Because we have been supporting Bind Avoidance since 1991 we are quite familiar with this field. You do have the correct field name. The codes are:

'A' V1R2 'B' V1R3 'C' V2R1 'D' V2R2 'E' V3R1 'F' V3R1 'G' V4R1 'H' V5R1 'I' V6R1 'J' V6R1 'K' V7R1 ???

Of course, the V7R1 is just a guess. Note that both V3R1 and V6R1 had two letter codes. If you are interested in more detail you can download the Avoid Bind Manual from our WEB Site www.hlstechnologies.com or get other documentation from IBM for their Bind Manager product, Program Number [...] 16006 45 22_Re: regarding DSN1COPY15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 24 Jan 2001 09:03:27 -0600299_us-ascii Hi Sri

Yes , it helped me a lot. But still I'm trying to copy data from image copy of source tablepace into target tablespace of same structure but different test db's. I wanted to use only old image copy of source tablespace but not actual dataset which is having latest data. [...] 16052 54 35_Re: Case Stmt Enhancements in V7???14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 24 Jan 2001 09:19:28 -0600739_iso-8859-1 Dave,

IBM has not announced any changes for the CASE expression specifically for V7 OS/390.

Regards, Richard

Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > David Nance > Sent: Wednesday, January 24, 2001 7:37 AM > To: DB2-L@RYCI.COM > Subject: Case Stmt Enhancements in V7??? > > > I was looking through the what's new in V7 yesterday, looking > for info about the case stmt and found none. Would anyone happen > [...] 16107 18 24_Temporary Mail TURN-OFF.17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Wed, 24 Jan 2001 08:24:30 -0700383_US-ASCII Hi,

How do I temporarily TURN-OFF the mail? I will be on vacation from 1/25 through 2/14 of 2001.

Thanks for the help.

================================================ 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. 16126 64 22_Re: regarding DSN1COPY10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 24 Jan 2001 09:21:15 -0600307_- If you wish to use DSN1COPY to restore a Tablespace with an Image Copy taken of a different Tablespace, then you will need to use the OBIDXLAT function. See DB2 for OS/390 V5 Utility Guide and Reference: 3.7.1.6. Also, search the archives in this Discussion List for some pitfalls you may encounter. [...] 16191 213 28_Re: Old consistency chestnut0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 Jan 2001 09:30:58 -0600505_us-ascii I copied the following tip from the list some time in the past I have done this in REXX. You have to look at the DBRM first to get the contoken, since it is in a fixed spot. In load modules I've found some with the last four bytes of the contoken first and others with all eight in order. I didn't pursue whether you can locate the contoken for a load module. ( My intent was to produce a report of all DBRM libraries and load libraries for one module, so you can do a copy and avoid [...] 16405 45 7_Re: DDF10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 24 Jan 2001 16:28:46 +0100440_us-ascii Hi Katy...

I installed DDF last year and I found many useful suggestion in the red book:

WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database

SG24-2212-00

In this book are described all steps you need to install TCP/IP & DDF.

We do not use standard ports, we use high values (30000 and 40000 for instances) for TCP/IP ports, to avoid problems with other applications. [...] 16451 24 32_Temporary Mail TURN-OFF. (Reply)0_22_scott.goodell@WCOM.COM31_Wed, 24 Jan 2001 09:49:05 -0600353_us-ascii You need to send a mail to LISTSERV@RYCI.COM Subject blank and the mail body with SET DB2-L NOMail

When you want the mail back on again send a mail with SET DB2-L Mail

You can get your own REFCARD by sending a mail to LISTERV@RYCI.COM

I think you just specify REFCARD but it may be LISTSERV REFCARD as a body command. [...] 16476 52 42_Re: DB2 for OS/390 and the support of Java14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Wed, 24 Jan 2001 09:49:32 -0600710_iso-8859-1 Peter:

Java support via JDBC (dynamic API for SQL) was added in V5 for DB2 for OS/390. SQLJ support (for static embedded SQL) was added in DB2 V6 (V5 with a retrofit APAR).

Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com cmullins@compuserve.com

-----Original Message----- >From: Peter, Georg [mailto:G.Peter@DZBW.DE] >Sent: Monday, January 22, 2001 3:25 PM >To: DB2-L@RYCI.COM >Subject: DB2 for OS/390 and the support of Java > >Hello Listers, > >just a short question: We all know that DB2 for OS/390 supports JAVA. In >which version the Java support was introduced ? > >Thanks for any [...] 16529 48 32_Temporary Mail TURN-OFF. (Reply)0_22_scott.goodell@WCOM.COM31_Wed, 24 Jan 2001 09:52:11 -0600529_us-ascii Ooops.. The command for your own REFCARD is INFO REFCARD sent to LISTSERV@RYCI.COM











Armando Zaporteza cc: Sent by: DB2 Data Subject: Temporary Mail TURN-OFF. Base Discussion List



01/24/01 09:24 AM Please respond to DB2 Data Base Discussion List









Hi,

How do I temporarily TURN-OFF the mail? I will be on vacation from 1/25 through 2/14 of 2001. [...] 16578 166 33_Re: DSNTIAUL in Platinum Strategy0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 24 Jan 2001 09:50:55 -06001030_us-ascii If its just issuing Select statements, you could use DSNTEP2. It allows the ability to issue selects. This implies that your systems programmer or DBA has bound DSNTEP2 into the subsystem you are running and that you include the steplib of where it resides .

//IMPCTCK EXEC PGM=IKJEFT01,REGION=3M //STEPLIB DD DISP=SHR,DSN=DB2.ALIAS.MOEQ.DSNEXIT // DD DISP=SHR,DSN=DB2.ALIAS.MOEQ.DSNLOAD // DD DISP=SHR,DSN=DB2.V5R1M0.TGTB.RUNLIB.LOAD // DD DISP=SHR,DSN=PROBUILD.ALIAS.ISPLLIB //ISPSLIB DD DISP=SHR,DSN=MAST.SKELETON.JCLLIB // DD DISP=SHR,DSN=SYS1.ISPF.ISPSLIB //ISPMLIB DD DISP=SHR,DSN=MAST.ISPF.MSGLIB // DD DISP=SHR,DSN=SYS1.ISPF.ISPMLIB //ISPPLIB DD DISP=SHR,DSN=SYS1.ISPF.ISPPLIB //ISPTLIB DD DISP=(,PASS),DSN=&&ISPTLIB, // SPACE=(TRK,(1,1,6)),UNIT=TEMPDA, // DCB=SYS1.ISPF.ISPTLIB // DD DISP=SHR,DSN=SYS1.ISPF.ISPTLIB //*ISPFILE DD SYSOUT=(A,INTRDR), //ISPFILE DD SYSOUT=*, // DCB=(LRECL=80,BLKSIZE=3200,RECFM=FB) //SYSPROC DD DISP=SHR,DSN=SYS2.TSO.CLISTLIB //SYSUADS DD DISP=SHR,DSN=SYS1.UADS //SYSLBC [...] 16745 111 22_Re: Row Level Security0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 Jan 2001 09:52:26 -0600381_us-ascii The design you describe is very similar to one of our applications. - Master tables with restricted access (but in our case the access is restricted within the application, via controlled access to read/update functionality), - changes made to service order tables, - changes applied to master via a batch process (users cannot make direct changes to master tables). [...] 16857 50 50_Re: DBRM Current Release Marker: Where documented?36_Enarson, Mike (CC-Database Services)29_Mike.Enarson@CONAGRAFOODS.COM31_Wed, 24 Jan 2001 09:50:56 -0600531_iso-8859-1 Gerald, shouldn't "E" be V2.3 instead of another V3.1?



Regards Mike Enarson ConAgra Foods, Inc.







-----Original Message----- From: Gerald Hodge [mailto:ghodge@ATTGLOBAL.NET] Sent: Wednesday, January 24, 2001 9:00 AM To: DB2-L@RYCI.COM Subject: Re: DBRM Current Release Marker: Where documented?



Hans:

Because we have been supporting Bind Avoidance since 1991 we are quite familiar with this field. You do have the correct field name. The codes are: [...] 16908 28 28_Re: Temporary Mail TURN-OFF.13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 24 Jan 2001 10:53:50 -0500436_iso-8859-1 You can also go to http://www.ryci.com/db2-l.

and from there click the "join or leave" the list link.

On that page, fill out your email address and name and in the Miscellaneou section select

Mail delivery disabled temporarily

then click the "Join the list" box.

Confusing, but it works.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com [...] 16937 46 22_Re: regarding DSN1COPY15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 24 Jan 2001 09:56:27 -0600901_us-ascii JCL Info : using image copy of test1 and trying to copy in test2 db of same structure

Any Idea ????

//STEP005 EXEC PGM=DSN1COPY,PARM='RESET,FULLCOPY,OBIDXLAT' //SYSPRINT DD SYSOUT=* //SYSUT1 DD DSN=MMITMMO.E1ACPT.BMKBK017.COPYB.G0031V00,DISP=SHR //SYSUT2 DD DSN=MMITMMOV.DSNDBD.MMITCGUT.MMISUT01.I0001.A001,DISP=SHR //SYSXLAT DD * 662,694 159,2 168,6 163,8 164,5 162,7 161,4 /*



DSN1999I START OF DSN1COPY FOR JOB X164437D STEP005 DSN1989I DSN1COPY IS PROCESSED WITH THE FOLLOWING OPTIONS: NO CHECK/NO PRINT/ 4K/FULLCOPY /NON-SEGMENT/NUMPARTS = 0/ OBIDXL DSSIZE= DSN1998I INPUT DSNAME = MMITMMO.E1ACPT.BMKBK017.COPYB.G0031V00 , SEQ DSN1997I OUTPUT DSNAME = MMITMMOV.DSNDBD.MMITCGUT.MMISUT01.I0001.A001, VSAM DSN1984I UNEXPECTED PAGE NUMBER, EXPECTING: 000042 0000 00000000 00000000 00000130 00560040 00550002 00000041 00000000 00000000 0020 009FC0FF FFFFFFFF [...] 16984 21 41_Re: Different results in program vs SPUFI13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 24 Jan 2001 10:00:04 -0600512_- No, it's DEGREE(1) and no partitioned tablespaces. Mohammad



On Wed, 24 Jan 2001 14:47:15 +1100, Tennant, Steve wrote: >Mohammad, > as a matter of interest is this bound DEGRE(ANY)? and >are the tables partitioned? > >Steve T >

================================================ 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. 17006 48 36_Re: Temporary Mail TURN-OFF. (Reply)17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Wed, 24 Jan 2001 08:56:53 -0700558_US-ASCII Scott,

Thanks for your response.

Please expand on the "REFCARD" keyword. Do I send the Email twice - one with set DB2-L mail and one with REFCARD?

Thanks again.







______________________________ Reply Separator _________________________________ Subject: Temporary Mail TURN-OFF. (Reply) Author: DB2 Data Base Discussion List at INTERNET-MAIL Date: 1/24/01 9:49 AM



You need to send a mail to LISTSERV@RYCI.COM Subject blank and the mail body with SET DB2-L NOMail [...] 17055 78 22_Re: regarding DSN1COPY10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 24 Jan 2001 10:09:31 -0600426_- Are you sure that 'MMITMMO.E1ACPT.BMKBK017.COPYB.G0031V00' is a FULL Image Copy?

If so:

When you say 'same structure': are they exactly the same in terms of:

If Segmented, same space allocations/segsize, etc.

If Partitioned, same space allocations/numparts, etc.

i.e. Are they truly identical?

Was the Source Table ALTERed after the last Reorg before the Image Copy was taken? [...] 17134 13 22_Re: regarding DSN1COPY15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 24 Jan 2001 10:19:13 -0600325_us-ascii Yes , Its a image copy taken along with reorg. and Its non-partitioned ts.

================================================ 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. 17148 23 19_newcomer needs help15_Lechner Gerhard24_glechner@METROPOLITAN.AT31_Wed, 24 Jan 2001 17:12:46 +0100463_iso-8859-1 Hi there!

I'm new to the DB2 profession and would need a little help to get started. Having been an application programmer and having slightly touched DB2, SQL and stuff I'm not completely offshore. If you got some neat files on your PC that could provide me with a basic unterstanding, fundamentals conceptual things, that would aid me a great deal. I got manuals in bookform and on CD but thats nothing you would wanna read as a starter. [...] 17172 82 22_Re: regarding DSN1COPY0_18_mebert@AMADEUS.NET31_Wed, 24 Jan 2001 17:24:53 +01001625_us-ascii Hi Mohammed,

for an Inline imagecopy you need to specify INLCOPY instead of FULLCOPY.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany





From: Mohammed Nayeem on 24/01/2001 16:19 GMT

Please respond to DB2 Data Base Discussion List









|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> [...] 17255 28 22_Re: regarding DSN1COPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 24 Jan 2001 10:27:09 -0600427_iso-8859-1 Ahh..That explains it. This is an inline image copy. You have to use the INLCOPY parm to tell DSN1COPY that the pages are out of order.

-----Original Message----- From: Mohammed Nayeem [mailto:Mohammed_Nayeem@MOMED.COM] Sent: Wednesday, January 24, 2001 10:19 AM To: DB2-L@RYCI.COM Subject: Re: regarding DSN1COPY



Yes , Its a image copy taken along with reorg. and Its non-partitioned ts. [...] 17284 58 23_Re: newcomer needs help9_Cam White20_cwhite@REVEALNET.COM31_Wed, 24 Jan 2001 11:39:30 -0500475_iso-8859-1 Gary,

Download a 30-day trial version of the Knowledge Base for DB2 from RevealNet and you will get everything you need to know about DB2 design, devevolopment, SQL issues etc. Here's your link:

http://www.revealnet.com/Products/DB2/db2adm.htm

Also, please don't forget to sign-up to win a chance for a FREE full-conference registration to IDUG in Orlando, Florida (travel and accomodations excluded). Sign up at http://www.revealnet.com [...] 17343 90 22_Re: regarding DSN1COPY22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Wed, 24 Jan 2001 14:41:16 -0200443_iso-8859-1 If one of your original tables has suffered some alter (e.g. adding a column) and no subsequent reorg, you will need to follow the steps below (kindly explained to me by Michael Murley in a previous email on this list):

"1. Drop the target table. 2. Re-create the target table with all but the last column defined. 3. Alter the target table to add the last column. 4. DSN1COPY from the image copy 5. Rebuild the indexes [...] 17434 71 50_Re: DBRM Current Release Marker: Where documented?12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 24 Jan 2001 10:45:47 -0600460_iso-8859-1 Mike:

Your correct that is an error in the comments in our code. I'll correct that. Thanks!

GSH

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Enarson, Mike (CC-Database Services) Sent: Wednesday, January 24, 2001 9:51 AM To: DB2-L@RYCI.COM Subject: Re: DBRM Current Release Marker: Where documented?



Gerald, shouldn't "E" be V2.3 instead of another V3.1? [...] 17506 87 40_Re: Temporary Mail TURN-OFF. (Reply - 2)0_22_scott.goodell@WCOM.COM31_Wed, 24 Jan 2001 10:25:08 -0600300_us-ascii The INFO REFCARD command will just send you a mail that lists all the commands and syntax.

You should send it as a seperate mail. The SET DB2-L NOMail command mail is all you need to turn off mail and when you get your refcard you will see the SET command syntax for future use. [...] 17594 43 29_Reusing tablespace partitions21_Foley, Tom (CAP, VFS)23_Tom.Foley@GECAPITAL.COM31_Wed, 24 Jan 2001 11:50:10 -0500499_iso-8859-1 Help!!!!!

We are a DB2 OS/390 V5 environment. We have a tablespace with 60 parts and the cluster index has a value(format yyyy-mm-dd) for each of the 60 parts. My problem is:

This is a rolling 60 months of data and we now have data in all 60 partitions with the 61st month coming up at the end of this month. We need to empty part 1 to load in the new data, change the value in the clustering index for part 1 and be able to repeat this process each month from now on. [...] 17638 15 22_Re: regarding DSN1COPY15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 24 Jan 2001 11:11:09 -0600458_us-ascii With INLCOPY , it went through sucessfully , but after this when I do REORG this message i'm getting: ,UTIL ,DSNUPROC- UNSUCCESSFUL SORT 04E S REASON=00C9021C DSNUPROC UTIL - ABEND=S04E U0000 REASON=00C9021C

================================================ 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. 17654 112 23_Re: newcomer needs help0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 24 Jan 2001 11:11:28 -0600547_us-ascii Here are some web sites I have looked at in past (haven't checked recently):

http://www.compuware.com/products/file/index.htm Has a link to Chuck Hoover presentations. You will see the link near the bottom of the page under the title 'Chuck Hoover Presentation Series'.

http://www.db2mag.com DB2 Magazine

http://www.intelligententerprise.com/ Online magazine. articles by Joe Celko (he's an SQL wizard) up to Oct 98 http://www.dbmsmag.com/artin301.html#A000009 after Oct 98 http://www.intelligententerprise.com/ [...] 17767 51 22_Re: regarding DSN1COPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 24 Jan 2001 11:17:58 -0600515_iso-8859-1 Nayeem,

This probably means that your source and target table space definitions are inconsistent or that your OBID translation was not exactly correct:

00C9021C

Explanation: While running a utility, the data manager detected an inconsistent data condition. A row was encountered that is not represented by a record OBD in the database descriptor (DBD). This abend may indicate an internal DB2 error, but most likely occurs due to a user error. Possible user errors may include: [...] 17819 126 33_Re: Reusing tablespace partitions0_18_mebert@AMADEUS.NET31_Wed, 24 Jan 2001 19:21:18 +0100614_us-ascii Hi Tom,

looks like you're in for some crash weekend work, doing the Unload/Drop/Create/Reload thing... There was some discussion about how to do this efficiently just recently, look in the archives. I've done this several times for TSs with up to 50 GB of data in the past, no problem.

If I remember correctly, partition rebalancing is only possible with V6 (certainly not V5). In your case, however, this would translate to doing a full TS reorg every month. So I would suggest (re-)creating the TS with 254 partitions, extending the usability of your concept 21 years into the future [...] 17946 41 20_Communication issues12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Wed, 24 Jan 2001 12:27:35 -0600336_iso-8859-1 I have 3 LPARS, 3 DB2 subsystems on the mainframe. I can execute SPUFI selects from and to any of the 3 DB2 subsystems on the mainframe. My understanding is that VTAM is responsible for this communication, so I feel I have the VTAM part of the world properly established (we don't have a VTAM person here, I set it up). [...] 17988 32 16_FW: DBMS product4_IDUG12_IDUG@SBA.COM31_Wed, 24 Jan 2001 12:33:23 -0600725_KOI8-R -----Original Message----- From: specialvn@aol.com [mailto:specialvn@aol.com] Sent: Wednesday, January 24, 2001 1:00 AM To: idug@sba.com Subject: DBMS product





The following feedback was submitted via the IDUG website:

Name: Vanessa Subject: DBMS product Email: specialvn@aol.com Date: 01/24/01-11:59:59

Comment/Suggestion:





I was wondering if you can give me a list of Database management systems products. Thank You.

================================================ 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. 18021 142 41_Re: Connections (not threads) running out13_Tony Hurlston26_Tony.Hurlston@ZURICH.CO.UK31_Tue, 23 Jan 2001 15:48:51 -0000504_iso-8859-1 Shaun,

It doesn't look like threads are using parallelism, however, I think the problem is one of interpretation of the manual.

The book says about IDBACK:

'the maximum number of concurrent connections identified to DB2 from batch'

Its that word 'connections' that is confusing - it appears to relate exactly to the number of 'concurrent threads' that Shadow Server is allowed to have, and is nothing to do with the number of connections reported by Omegamon. [...] 18164 36 28_Re: Old consistency chestnut12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 24 Jan 2001 13:17:46 -0600567_us-ascii Marcus and Ron:

There is another catch and that is how languages other than COBOL store the TOKEN. Take a look at the method used by the optimizer for C++! The design issue comes from the fact that the program is supposed to call DB2, and not the other way around. This makes searching the load module CPU consuming, unless you are familiar with specific assembler techniques. One of the questions is will you find the token in the load module or something that looks like a token. Validating that the module contains static SQL first is a help. [...] 18201 200 33_Re: Reusing tablespace partitions15_Jackson Reavill18_damcon2@US.IBM.COM31_Wed, 24 Jan 2001 14:22:30 -0500389_us-ascii Tom,

FYI... if your tablespace is defined as regular (not large) then the values of the last partition are ignored and all of the data will go into the last partition. Obviously, this would also apply if you have high values. Not that this is a desirable thing, but it might buy you some time. Of course, it may not last for long since you're limited to 1GB per part. [...] 18402 63 24_Re: Communication issues13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 24 Jan 2001 13:37:49 -0600573_US-ASCII Hello John, We define the port number in the CDB but you could probably also use the svcename in the dbmcfg. I have not tried it but it seems that this should also work. HTH Kurt



>>> John.Vernon@TRS.STATE.TX.US 01/24/01 12:27PM >>> I have 3 LPARS, 3 DB2 subsystems on the mainframe. I can execute SPUFI selects from and to any of the 3 DB2 subsystems on the mainframe. My understanding is that VTAM is responsible for this communication, so I feel I have the VTAM part of the world properly established (we don't have a VTAM person here, I set [...] 18466 16 22_Re: Row Level Security12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 24 Jan 2001 13:38:40 -0600330_- The security mechanisms for using some of your own programming inside DB2 include user-defined data types and functions, stored procedures, EDITPROCs and FIELDPROCs. My guess for the best match on your question is the EDITPROC. See the Administration Guide appendix on exits, and I think we still ship the sample DSN8EAE1. [...] 18483 21 22_Re: regarding DSN1COPY15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Wed, 24 Jan 2001 14:18:57 -0600482_us-ascii Ebert, Michael , Cam and all

Thank you to all of you for responding to my mails, by providing required solution and I have successfully able to do dsn1copy using image copy.

Once again thank you.

Regards Nayeem

================================================ 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. 18505 59 46_DB2 UDB AIX Question for Migration of Instance10_Mark Labby16_mlabby@PHEAA.ORG31_Wed, 24 Jan 2001 16:57:50 -0500389_iso-8859-1 I have been asked to forward this message to the list. Has anyone seen any similar problem when trying to migrate a database?

----- Forwarded by Mark Labby/PHEAA on 01/24/01 05:03 PM -----









ERROR WHILE RUNNING DB2CKMIG COMMAND TO MIGRATE DB2 V5.2 INSTANCE:

Platform: DB2 UDB (EE) AIX 4.3.3 SP2 model 9076 DB2 Version 5.1 [...] 18565 214 33_Re: Reusing tablespace partitions10_Ilagan Ven25_vilagan@WOOLWORTHS.COM.AU31_Thu, 25 Jan 2001 11:52:25 +1100407_iso-8859-1 Hi Tom,

A few years back, I outlined a solution (which I think I called Extending Last Partition) the principle of which should apply equally well for you in exactly the same methodology that you wanted, i.e. roll over the partitions every month. I've used this approach successfully in the past and I'm sure that it'll work for you as well. In essence, it'll go something like this. [...] 18780 230 33_FW: Reusing tablespace partitions10_Ilagan Ven25_vilagan@WOOLWORTHS.COM.AU31_Thu, 25 Jan 2001 11:56:01 +1100269_iso-8859-1 Ooops - forgot to say that I haven't tried it but this method worked for me in extending last partition.... so test it please and tell me if it works or not (maybe it won't as the rids might be messed up as the new partition is in front not at the end) [...] 19011 28 34_DB2 Connect MTS and 2-Phase Commit9_Ken Hynes17_khynes@TRIGON.COM31_Wed, 24 Jan 2001 20:53:03 -0600531_- We are in the process of developing several component based applications. I recently had a problem posed to me regarding one of them. The group involved is trying to run a multi database update via MTS with at least one of the updates to a file residing on DB2 for OS/390. We are trying to use Enterprise connect for this and it does not seem to be working. Since I'm primarily a Mainframe "type" I'm not certain how to help them. Has anyone done or been involved with a project of this nature using MTS and if so could you [...] 19040 27 26_Multiple DB2's and Endevor9_Ken Hynes17_khynes@TRIGON.COM31_Wed, 24 Jan 2001 21:01:09 -0600581_- We are in the process of adding an additional DB2 subsystem to the shop. Prior to this we have run everything under one "Main" DB2 system (one for Production and one for Testing).

I am comfortable with the need to Steplib and keep separate copies of the various ISPF libraries in order to keep the release levels of the software straight. However, I am not comfortable with all the various "layers" posed by Endevor. Does anyone out there have some experiences they would be willing to share about adding additonal DB2's to Endevor and/or how they set up the various [...] 19068 63 9_"DB2 CLI"0_18_dsi.listsrv@DB.COM31_Thu, 25 Jan 2001 09:38:48 +0530470_us-ascii Hi Philip, Thanks for the solution. As suggested by you, when I used SQLGetDiagField function, it returned me the parameter number. But when I used column of data type DECIMAL, it returned me the column number as SQL_COLUMN_NUMBER_UNKNOWN. Can you please throw light on this error?.



Ramesh, The SQLGetDiagfield() function will return the SQL_DIAG_COLUMN_NUMBER field which will contain either the column number or parameter number. HTH Phil [...] 19132 13 35_Re: imagecopy suddenly running long7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Wed, 24 Jan 2001 23:00:28 -0600373_- Our System programmers informed us most probably it is a tape drive problem.

The same job ran on next night in 15 minutes.

================================================ 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. 19146 16 35_Re: imagecopy suddenly running long7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Wed, 24 Jan 2001 23:05:42 -0600410_- Our system programmers informed us, probably it is due to a tape drive problem.

Same job ran in 15 minutes on next night.

Thanks for all your help. Sri.

================================================ 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. 19163 38 22_Performance Monitoring11_Frau Mόller24_u.a.a.mueller@FREENET.DE31_Thu, 25 Jan 2001 07:34:38 +0100569_ISO-8859-1 Hello All,

as an absolute novice to DB2 performance monitoring (we use IBM DB2 PM) and a relative novice to DB2 I wonder whether there is anyone to tell me which (if there are any at all) are the most outstanding, let's say, "beginners' parameters" to look at in the PM in order to get a first idea for sorting out whether I have got locking problems or logging problems (we are also using data sharing), buffer pool problems, CPU queuing problems or any other of the most common performance problems. As there are quite 'a few' parameters to be [...] 19202 110 26_Re: Performance Monitoring16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 25 Jan 2001 12:40:09 +0530655_iso-8859-1 Anna, I think you must be aware of Accounting and Statistics report. Accounting report short layout is used to extract :

1)DB2 response time (elapsed time) 2)Resources used (processor,I/Os) 3)Lock suspensions 4)Usage of packages and DBRMs 5)Processor,I/O wait,and lock wait time for each package/plan

To start with, only Class 1 (Total Elapsed Time)accounting trace is sufficient and for in depth information you can use class 2 (In DB2 Time) and class 3(Wait time) for plans and class 7(In DB2 Time) and class 8(Wait time) for packages. For more detailed analysis Accounting report long layout can be used once the problems [...] 19313 31 26_Re: Performance Monitoring10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 25 Jan 2001 10:04:46 +0100462_us-ascii Anna I think it's time for a visit to Joel Goldstein's web site :

http://www.responsivesystems.com/ and check 'White papers and presentation' . The article:



DB2 System Performance Metrics







It's a good starting point for a 'novice' (I started here...) and it provides some 'numbers'. AND you can read this articles in few minutes. In the same time you can see many others aspect of system tuning. [...] 19345 52 0_20_Yasas Mallawarachchi14_yasas@SLIIT.LK31_Thu, 25 Jan 2001 15:13:40 +0600169_iso-8859-1 Hi All,

When using ODBC Is there anyway where I can edit/update a recordset which is a multi table query. Please reply if u know.



Yashas 19398 53 37_Updating Multi Table Queries via ODBC20_Yasas Mallawarachchi14_yasas@SLIIT.LK31_Thu, 25 Jan 2001 15:14:05 +0600169_iso-8859-1 Hi All,

When using ODBC Is there anyway where I can edit/update a recordset which is a multi table query. Please reply if u know.



Yashas 19452 53 37_Updating Multi Table Queries via ODBC20_Yasas Mallawarachchi14_yasas@SLIIT.LK31_Thu, 25 Jan 2001 15:14:10 +0600169_iso-8859-1 Hi All,

When using ODBC Is there anyway where I can edit/update a recordset which is a multi table query. Please reply if u know.



Yashas 19506 17 33_Re: DSNTIAUL in Platinum Strategy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 25 Jan 2001 04:40:42 -0600391_- Shan

This won't help me, because I want do change the structure of the table using platinum's alter facility. During unloading the table, I want to take values from two columns, combine them and put then into the new column.

I think the syntax of platinum's standard unload (not fast unload) doesn't offer the syntax I need, so I want to call DSNTIAUL in that strategy. [...] 19524 67 22_Re: Row Level Security14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Thu, 25 Jan 2001 05:48:14 -0600457_iso-8859-1 Out of idle curiosity, a question ... Users have only insert authority to the transaction table (no reads allowed!). In the security model, what is the reason for this restriction? Since we allow changes to be made to even after a prior change has be made (change to pending change, and boy!, is it a pain in the butt to get right) not allowing read access to pending changes would really be a severe limit to our process. [...] 19592 19 33_Re: Reusing tablespace partitions14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Thu, 25 Jan 2001 05:51:17 -0600550_iso-8859-1 There are BMC products that allow you to re-balance partitions. Some other vendors also have similar products. Send me a e-mail direct if you want further details of the BMC products.

Mind you, if you do not already have them installed you may have a problem...

From Edward Vassie...

================================================ 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. 19612 35 16_Lock on SYSGROUP0_19_mike.holmans@BT.COM31_Thu, 25 Jan 2001 12:28:42 -0000571_- DB2 V5, OS/390 2.8.

We had a couple of failures last night because processes timed out trying to get hold of DSNDB06.SYSGROUP.X'0006'.

The first one was an application program which was trying to extend a tablespace, and the signs are that the process holding the lock on SYSGROUP was a STOSPACE. About ten minutes later, the STOSPACE fell over with a timeout on the same resource, which this time was being held by another application program. This other application program had started after the timeout which made the other application fall over. [...] 19648 10 33_Re: Reusing tablespace partitions10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Thu, 25 Jan 2001 07:51:17 -0500543_- Seems like what we have here is a basic design flaw. All of the advice I have seen so far has been geared toward working with the existing structure, and based on the short term and deadlines and other stuff this may be the quick fix. However, I recommend reviewing the requirements for your data. If you truly need to continue rolling data in the fashion you describe, then maybe we need to fix the problem. I would add a column to the table called part_num. The value of this column would be calculated based on the date being added. [...] 19659 73 20_Re: Lock on SYSGROUP19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 25 Jan 2001 06:58:17 -0600469_iso-8859-1 Mike, From DB2 UDB for OS390 V6 Utility Guide; note the "However" clause:

"2.20.3 Concurrency and compatibility

STOSPACE does not set a utility restrictive state on the target object.

STOSPACE can run concurrently on the same target object with any utility. However, because STOSPACE updates the catalog, concurrent STOSPACE utility jobs or other concurrent applications that update the catalog might cause timeouts and deadlocks." [...] 19733 182 33_Re: Reusing tablespace partitions27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 25 Jan 2001 08:38:14 -0500629_iso-8859-1 Michael,

Why use LOG YES in the load to empty the partition? Wouldn't LOG NO be better?

Tina Hilton Bertelsmann mediaSystems

> -----Original Message----- > From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] > Sent: January 24, 2001 1:21 PM > To: DB2-L@RYCI.COM > Subject: Re: Reusing tablespace partitions > > Hi Tom, > > looks like you're in for some crash weekend work, doing the > Unload/Drop/Create/Reload thing... There was some discussion about how to > do > this efficiently just recently, look in the archives. I've done this > several > times for TSs with up to 50 GB of data in the [...] 19916 14 50_Re: DB2 UDB AIX Question for Migration of Instance11_Mike Fatula17_mfatula@PHEAA.ORG31_Thu, 25 Jan 2001 08:41:05 -0500301_us-ascii Hi:

Sorry Mark I have not had this problem.

================================================ 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. 19931 55 38_Re: DB2 Connect MTS and 2-Phase Commit10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 25 Jan 2001 09:37:44 -0500704_us-ascii Ken Exactly what type of problems.... We are going in the same direction. Tom







Ken Hynes @RYCI.COM> on 01/24/2001 09:53:03 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DB2 Connect MTS and 2-Phase Commit



We are in the process of developing several component based applications. I recently had a problem posed to me regarding one of them. The group involved is trying to run a multi database update via MTS with at least one of the updates to a file residing on DB2 for OS/390. We [...] 19987 28 48_S0C1 errors after applying maintenance to DB2 V527_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 25 Jan 2001 10:50:17 -0500475_- I applied some maintenance to get all the toleration/coexistence/fallback PTFs on DB2 V5 so I can upgrade to V6. DB2 starts up fine, but I get an abend whenever I try to connect. SPUFI and DSNTIAUL get S0C1 abends, QMF gets a -901, and DSNTEP2 gets a U4087 and some CEEnnnn messages. I've triple-checked that I did everything required by the action holds, and I can't think of anything else that would have caused this. I looked in IBMLINK but couldn't find any hits. [...] 20016 127 52_Re: S0C1 errors after applying maintenance to DB2 V512_David Booher22_David.Booher@QUEST.COM31_Thu, 25 Jan 2001 08:11:15 -0800675_iso-8859-1 Did you re-run installation steps DSNTIJTM and DSNTIJSG to re-assemble DSNTIAD and rebind your objects?



-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Thursday, January 25, 2001 9:50 AM To: DB2-L@RYCI.COM Subject: S0C1 errors after applying maintenance to DB2 V5



I applied some maintenance to get all the toleration/coexistence/fallback PTFs on DB2 V5 so I can upgrade to V6. DB2 starts up fine, but I get an abend whenever I try to connect. SPUFI and DSNTIAUL get S0C1 abends, QMF gets a -901, and DSNTEP2 gets a U4087 and some CEEnnnn messages. I've triple-checked that I did [...] 20144 54 33_Re: DSNTIAUL in Platinum Strategy9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 25 Jan 2001 09:34:09 -0700555_us-ascii You can do what you are wanting using Fast Unload. It does not matter what you choose for OUTPUT-FORMAT (LOAD (PFL), or DSNTIAUL). Here is an example of what the SYSIN would look like to do what you describe, having it generate DSNTIAUL unload output and load control cards.

//SYSIN DD * FASTUNLOAD INPUT-FORMAT TABLE LOAD-CONTROL DB2LOAD OUTPUT-FORMAT DSNTIAUL SHRLEVEL CHANGE ESTIMATED-ROWS 200 SQL-ACCESS EXTENSION SELECT RACS_OBJECT, RACS_USERID, RACS_LAST_UDATE || RACS_LAST_UTIME AS DATETIME, RACS_DATA FROM PTI.PTLOG_CATSTATS; [...] 20199 224 33_Re: Reusing tablespace partitions12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 25 Jan 2001 18:36:20 +020050_iso-8859-1 Hi, To prevent "copy pending" .

20424 10 23_OK to TERM Utility?????11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM31_Thu, 25 Jan 2001 11:34:51 -0500524_- We had a load utility that rejected 89 million rows due to an application program problem. That's my story and I'm stickin' to it. The question was asked if the utility could be terminated in the report phase. While we were discussing this the job completed and we did not term the utility. For our info and future whats is the answer? We think that if the utility is in the report phase all indexes and data are ok. We were going to check the status on the objects to verify everything was ok and force if not in rw [...] 20435 56 52_Re: S0C1 errors after applying maintenance to DB2 V527_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 25 Jan 2001 11:50:06 -0500616_- There were no holds to say I had to rebind -- that was optional and didn't mention any of IBM-supplied ones. I can't use anything to connect to DB2. BMC Catalog Manager also fails. I can issue commands (-dis database works anyway).

> -----Original Message----- > From: David Booher [SMTP:David.Booher@QUEST.COM] > Sent: January 25, 2001 11:11 AM > To: DB2-L@RYCI.COM > Subject: Re: S0C1 errors after applying maintenance to DB2 V5 > > Did you re-run installation steps DSNTIJTM and DSNTIJSG to re-assemble > DSNTIAD and rebind your objects? > > > -----Original Message----- > From: Hilton, Tina, BmS - [...] 20492 26 52_Re: S0C1 errors after applying maintenance to DB2 V512_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 25 Jan 2001 19:07:51 +0200470_iso-8859-1 Hi, I'm guessing here - Maybe you need to do "refresh LLA" for the libraries involved (or stop & start it by console commnds: "p lla" & "s lla").

Isaac Yassin DBMS & IT Consultant yassin@netvision.net.il

>There were no holds to say I had to rebind -- that was optional and didn't >mention any of IBM-supplied ones. I can't use anything to connect to DB2. >BMC Catalog Manager also fails. I can issue commands (-dis database works >anyway). [...] 20519 19 14_Example needed13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Thu, 25 Jan 2001 12:45:08 -0500485_- Hi! Our applications programming staff has asked me to raise this question on their behalf. Where can I find an example of a Net.Data macro calling a DB2 stored procedure? Website? Reference Manual? Redbook?

Thanks,

Dave Kenski

================================================ 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. 20539 155 38_Re: CLI0616E - Starting Control Center15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM31_Thu, 25 Jan 2001 09:48:37 -0800647_iso-8859-1 There is a JDBC Applet Server Service specific to the Control Center. Make sure that one is started. Steve

-----Original Message----- From: Troy Coleman [mailto:Colematr@MEIJER.COM] Sent: Tuesday, January 23, 2001 11:49 AM To: DB2-L@RYCI.COM Subject: Re: CLI0616E - Starting Control Center



Jim, I didn't think you had any options under WIN98. I think I may have a bad install of WIN98 or something missing. The person next to me has WIN98 however a different machine and his Control Center worked fine after an initial install. I know under WINNT or WIN2000 you have services that auto start. The person next [...] 20695 23 33_Re: Reusing tablespace partitions12_Tal Lifshitz21_Tal.Lifshitz@MSDW.COM31_Thu, 25 Jan 2001 12:48:39 -0500580_us-ascii Try the following formula to calculate the part_num:

part_num = year - trunc(year/5)*5 + month

Bill Brown wrote:

> Seems like what we have here is a basic design flaw. All of the advice I have seen so far has been geared toward working with the existing structure, and based on the short term and deadlines and other stuff this may be the quick fix. However, I recommend reviewing the requirements for your data. If you truly need to continue rolling data in the fashion you describe, then maybe we need to fix the problem. I would add a column [...] 20719 40 52_Re: S0C1 errors after applying maintenance to DB2 V550_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Thu, 25 Jan 2001 13:05:19 -0500400_iso-8859-1 F LLA,REFRESH

-----Original Message----- From: Isaac Yassin [mailto:yassin@NETVISION.NET.IL] Sent: Thursday, January 25, 2001 12:08 PM To: DB2-L@RYCI.COM Subject: Re: S0C1 errors after applying maintenance to DB2 V5



Hi, I'm guessing here - Maybe you need to do "refresh LLA" for the libraries involved (or stop & start it by console commnds: "p lla" & "s lla"). [...] 20760 158 38_Re: CLI0616E - Starting Control Center12_Troy Coleman19_Colematr@MEIJER.COM31_Thu, 25 Jan 2001 13:06:22 -0500430_ISO-8859-1 I'm sorry but I'm very ignorant in this area. I tried as others have told me to do: DB2JSTRT 7000 followed by DB2CC 7000. I've tried DB2START... Can you give me a step by step procedure on what it is that I am supposed to type. Thank you. Troy

>>> steven.camitta@INGRAMMICRO.COM 01/25/01 12:48PM >>> There is a JDBC Applet Server Service specific to the Control Center. Make sure that one is started. Steve [...] 20919 47 52_Re: S0C1 errors after applying maintenance to DB2 V527_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Thu, 25 Jan 2001 13:11:46 -0500300_- Nope. Not in this case. Maintenance was applied to a copy of the libraries, which I have in the started tasks, so it uses those instead of the ones in linklist. I even tried overriding the steplib in the batch jobs I ran to point to the sdsnload with maintenance, but that didn't help either. [...] 20967 45 11_New To List18_Elizabeth A. Pratt14_prattea@NU.COM31_Thu, 25 Jan 2001 13:07:52 -0500563_us-ascii Hi all -

I hope that some developers may be able to answer my question.

I am new to the DB2-L list.. I do application/ analysis work presently in Natural using ADABAS, DB2, and VSAM.

We are working on a new project that will be using Cobol with DB2.

The work we have done in the past on DB2 - we have used SQL to help set up Select statements, among it's other uses. We have used DSNTIAUL to dump DB2 tables to sequential files when having difficulties with bad data. And we have used the Platinum toolkit which includes [...] 21013 13 52_Re: S0C1 errors after applying maintenance to DB2 V50_19_Tim.Lowe@STPAUL.COM31_Thu, 25 Jan 2001 12:28:30 -0600295_us-ascii Tina, Are your new libraries APF authorized?

================================================ 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. 21027 28 21_DB2/OS390 Query tools14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Thu, 25 Jan 2001 13:45:06 -0500383_us-ascii Hi fellow Listers (I tend to lean left :-)

I searched the list archives to no avail so now I am asking this question after pressure from management to 'get a consensus on ..'

"What products are other sites using for Query purposes against DB2 ?"

The information they are looking for is, tool used, number of users and approximate size of database. [...] 21056 59 15_Re: New To List11_KATHY JONES26_JONESKS@GROUPWISE.CCSD.NET31_Thu, 25 Jan 2001 10:44:18 -0800412_US-ASCII Our developers also use File-Aid for DB2. I have used it too and it is a pretty good product. It is a Compuware product. Some of them also use RC-Update.

>>> prattea@NU.COM 01/25/01 10:07AM >>> Hi all -

I hope that some developers may be able to answer my question.

I am new to the DB2-L list.. I do application/ analysis work presently in Natural using ADABAS, DB2, and VSAM. [...] 21116 17 28_[Fwd: DB2/OS390 and UDB V 7]18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Thu, 25 Jan 2001 20:08:05 +0100356_us-ascii Hi all,

This is a message from a colloquia, every suggestion is welcome.

Gerrit Groenendaal

================================================ 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. 21134 17 28_[Fwd: DB2/OS390 and UDB V 7]18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Thu, 25 Jan 2001 20:11:10 +0100309_us-ascii Hi,

Who knows the solution?

Gerrit Groendaal

================================================ 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. 21152 17 13_Excel and DB217_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Thu, 25 Jan 2001 11:32:30 -0800486_us-ascii I am attempting to use Lotus Excel on Windows 95 to access OS/390 DB2 V5.1 data. I have DB2 Connect V7.1 working successfully and wanted to know if anyone has any info on how to setup excel to be able to access the DB2 data.

TIA

================================================ 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. 21170 24 12_VSAM EXTENTS14_Karthik Ganesh21_karthik_gus@YAHOO.COM31_Thu, 25 Jan 2001 11:46:56 -0800626_us-ascii I believe I came across sometime agao that the VSAM extents doens't affect the performance anymore after DB2V5. Could anyone guide me out ot find more information on this topic?

Thanks in advance

Kartik

__________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. 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. 21195 48 36_Repost: [Fwd: DB2/OS390 and UDB V 7]16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Thu, 25 Jan 2001 14:53:02 -0500483_us-ascii Richard,

Perhaps something go wrong, but this was the question.

Gerrit







Hi,

Who knows the solution?

Gerrit Groendaal



Subject: DB2/OS390 and UDB V 7 Date: Thu, 25 Jan 2001 14:57:15 +0100 From: Paul Jansen Organization: Planet Internet Newsgroups: ibm.software.db2.mvs





We're trying to exchange data between DB2 V6 for OS/390 and UDB V7 on a NT platform. [...] 21244 35 17_Re: Excel and DB212_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Jan 2001 11:56:29 -0800599_us-ascii What version of EXCELL? EXCELL 95 is not supported. EXCELL 97 works mostly. EXCELL 2000 works fine. --- Charles Jambrosic wrote: > I am attempting to use Lotus Excel on Windows 95 to > access OS/390 DB2 V5.1 > data. I have DB2 Connect V7.1 working successfully > and wanted to know if > anyone has any info on how to setup excel to be able > to access the DB2 > data. > > TIA > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The [...] 21280 41 16_Re: VSAM EXTENTS19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 25 Jan 2001 13:58:26 -0600669_iso-8859-1 Karthik, Search the DB2-L Archives on EXTENTS. Particularly note Joel Goldstein's contributions.

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." [...] 21322 57 16_Re: VSAM EXTENTS15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 25 Jan 2001 14:03:17 -0600574_iso-8859-1 Hi, Kartik, I haven't heard anything about that. However, whether having VSAM extents will affect your performance depends on what kind of query is being performed and whether the data needed is in any of the extents. If the query is doing direct index access then whether the data resides in an extra extent won't make much difference. If the query is doing some type of sequential access and the desired data resides in many extents then, yes, it will take more time to bring back the data from DASD. If the data has already been fetched into a bufferpool [...] 21380 38 14_KILL Command ?15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 25 Jan 2001 15:19:36 -0500318_us-ascii Hi All,

A couple of questions were asked of me that I wasn't sure what the answer was. So, of course, I'm turning to the List for assistance.

Will DB2 rollback cleanly when the UNIX KILL command is issued on a running application? I answered that I would hope so, but didn't know for sure. [...] 21419 120 43_IDUG NA Conference Orlando, May 13-17, 200114_Philip Gunning24_Philip.Gunning@QUEST.COM31_Thu, 25 Jan 2001 12:41:48 -0800389_iso-8859-1 FY. Posted for IDUG.

[IDUG 2001 - North America Information Live on www.idug.org]

Dear Database Professional-

The International DB2 Users Group (IDUG) invites you to IDUG 2001 - North America. The Conference Preview is in the mail and on its way to you...but you don't have to wait! You can find detailed conference information at http://www.idug.org. [...] 21540 36 52_Re: S0C1 errors after applying maintenance to DB2 V512_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 25 Jan 2001 13:23:00 -0500600_- Just reaching here...did you apply maint to the early code and did an IPL take affect after updating?



>>> DB2-L@RYCI.COM@inter2 01/25/01 09:58AM >>> I applied some maintenance to get all the toleration/coexistence/fallback PTFs on DB2 V5 so I can upgrade to V6. DB2 starts up fine, but I get an abend whenever I try to connect. SPUFI and DSNTIAUL get S0C1 abends, QMF gets a -901, and DSNTEP2 gets a U4087 and some CEEnnnn messages. I've triple-checked that I did everything required by the action holds, and I can't think of anything else that would have caused this. I looked [...] 21577 75 17_Re: Excel and DB217_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Thu, 25 Jan 2001 13:01:45 -0800475_us-ascii Myron, I have Excell 97 but I have figured it out. I am missing the Query component which will require reinstalling that portion but I was able to access via Microsoft Access. So I'm confident that when I install the query portion of Excell it will also work properly.

Thanks.







Myron Miller cc: Sent by: DB2 Subject: Re: Excel and DB2 Data Base Discussion List [...] 21653 70 52_Re: S0C1 errors after applying maintenance to DB2 V515_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 25 Jan 2001 22:09:48 +0000548_us-ascii Hello Tina,

Have you checked to output of your SMP/E apply job for any link-edit failures/warnings? Do you find any records related to the ABEND0C1 in erep?

Regards,

Toine Michielse





BOB JEANDRON @RYCI.COM> on 01/25/2001 06:23:00 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Re: S0C1 errors after applying maintenance to DB2 V5 [...] 21724 40 8_2G limit16_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Thu, 25 Jan 2001 14:25:45 -0800357_us-ascii We are DB2 OS/390 V5. We had a situation yesterday that I'd like to run past the list.

Indexspace is stogroup defined and was at the 2 gig. limit. It was not pieced, as it should have been. DB2 goes to extend to the next dataset, but there isn't enough space on any pack to get the primary alloc. contiguous. So we must to "something". [...] 21765 63 18_Re: KILL Command ?14_Scott Saunders20_ssaunders@SIEBEL.COM31_Thu, 25 Jan 2001 14:31:07 -0800366_iso-8859-1 Jackson; DB2 FORCE is really the way to go with this. It will allow a normal rollback and let everything else keep running. Unix KILL could bring the database down very suddenly. DB2 would then go through crash recovery when you tried to use it again.

Regards, Scott Saunders

Opinions expressed are my own and not those of my employer. [...] 21829 58 12_Re: 2G limit24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 25 Jan 2001 14:31:03 -0800592_- Yes, you should have been able to alter the primary quantity to a smaller value. I've used this technique in the past for tablespaces that only slightly exceeded 2 gig.

Although this is just a technicality, the primary quantity can take up to 5 extents.

> -----Original Message----- > From: Alison Pelletier [SMTP:alison_pelletier@YAHOO.COM] > Sent: Thursday, January 25, 2001 2:26 PM > To: DB2-L@RYCI.COM > Subject: 2G limit > > We are DB2 OS/390 V5. We had a situation yesterday > that I'd like to run past the list. > > Indexspace is stogroup defined and was at the 2 [...] 21888 39 29_Re: DB2 Connect V7.1 question13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 25 Jan 2001 17:11:05 -0600344_iso-8859-1 Just fyi:

We introduced an error into the PeopleSoft app when migrating to v6.1 fp5 from v6.1 fp4b. This error was still occurring with v7.1 fp1, but was fixed by v7.1 fp2.

Also, a unix client app got a drda heap error that was introduced by 6.1 fp5, that still occurred in 7.1 fp1, but was corrected by v7.1 fp2. [...] 21928 73 29_Re: DB2 Connect V7.1 question12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Jan 2001 16:51:20 -0800556_us-ascii We're running FP1f in production and FP2 in test several places. Lots of problems with SPB that won't be fixed until FP3 or later. Plus serious problem with VB recordset function. worked in v5 but fails consistently in V7 --- "Shapiro, Dave" wrote: > Just fyi: > > We introduced an error into the PeopleSoft app when > migrating to v6.1 fp5 from v6.1 fp4b. This error > was still occurring with v7.1 fp1, but was fixed by > v7.1 fp2. > > Also, a unix client app got a drda heap error that > was introduced by 6.1 [...] 22002 104 17_Re: Excel and DB212_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Jan 2001 17:32:12 -0800563_us-ascii Only problem we're having with both ACCESS 97 and up and MSQUERY is in handling long varchar tables. We keep getting #DELETED with them. Didn't before with V5. Have open PMR with IBM about this. Tried lots of various settings in CLIINI to test. --- Charles Jambrosic wrote: > Myron, > I have Excell 97 but I have figured it out. I am > missing the Query > component which will require reinstalling that > portion but I was able to > access via Microsoft Access. So I'm confident that > when I install the query > portion of [...] 22107 59 30_Re: DB2 Connect V7.1 stability12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 25 Jan 2001 17:09:10 -0800386_us-ascii Sorry for the delay in answering but we just put it in when you sent originally. Have had for a period of time (fixpack 1f). Fp2 is in testing. Only serious problem: VB recordset function doesn't work. CLIINI settings changed and some problems in keeping old settings when upgraded from 5. But other than that its working fine. No fallover or concentrators at this point. [...] 22167 47 52_Re: S0C1 errors after applying maintenance to DB2 V517_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Fri, 26 Jan 2001 12:26:55 +1100448_us-ascii Hi, This one is realy on the outside but have you an additional library concatenated infront of your DB2 load libraraies in the MSTR etc address spaces where you may have a module like Hourglass linked (was around for Y2K testing but can still be used).

You probably can guess why this comes to mind for me! (been caught twice). When this happens results are very unpredicatble. If you do then you will need to relink modules. [...] 22215 63 52_Re: S0C1 errors after applying maintenance to DB2 V512_HARBRY ARIZA20_harbry_a@HOTMAIL.COM31_Thu, 25 Jan 2001 19:59:34 -0600603_- Check sys1.logrec. There you may find the abending programs. It will point to the right direction to fix your problem.



>To: DB2-L@RYCI.COM >cc: >Subject: Re: S0C1 errors after applying maintenance to DB2 V5 > > > >Just reaching here...did you apply maint to the early code and did an IPL >take >affect after updating? > > > >>> DB2-L@RYCI.COM@inter2 01/25/01 09:58AM >>> >I applied some maintenance to get all the toleration/coexistence/fallback >PTFs on DB2 V5 so I can upgrade to V6. DB2 starts up fine, but I get an >abend whenever I try to connect. SPUFI and DSNTIAUL get S0C1 [...] 22279 14 47_Craig McGinnis/AO/USR/FTU is out of the office.14_Craig McGinnis29_craig.mcginnis@FIRSTUNION.COM31_Fri, 26 Jan 2001 02:09:32 -0500365_us-ascii I will be out of the office from 01/26/2001 until 01/29/2001.

I will respond to your message when I return.

================================================ 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. 22294 124 13_DB2 and Excel0_20_vpacheco@AMADEUS.NET31_Fri, 26 Jan 2001 10:17:54 +0100598_us-ascii Charles Besides DB2 Connect and Excel you also need to have MS Query installed. This normally is set up on the basic installation of MS Office.

DB2 Connect automatically sets up the ODBC that you need to import data using Excel.





Open Excel, On the Data menu choose 'Get External Data' and then 'Create New Query'. It should then prompt you with the Data Sources configured on your environment. You should now see the DB2 DB's. Highlight the one you are interested in and hit 'OK'. The control is now passed to DB2 Connect for sign on process. After that [...] 22419 12 33_Re: DSNTIAUL in Platinum Strategy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 26 Jan 2001 03:55:59 -0600298_- Hello Rob

The pity is, I don't have fast unload

================================================ 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. 22432 112 33_Re: Reusing tablespace partitions0_18_mebert@AMADEUS.NET31_Fri, 26 Jan 2001 11:12:53 +0100620_us-ascii Better try

part_num=12*(year-trunc(year/5)*5)+month

We are using this technique in many of our partitioned TSs. I am not entirely happy with it (without having a better idea I can recommend):

- either you have to include the part_num in all your queries (that means you have to know the formula, and use it every time), or - you have to do a Join with a table that contains the valid (part_num, year, month) combinations (which gives bad performance), or - you have to use NPIs which I don't recommend due to problems with managing monster indexes, as well as performance degradations [...] 22545 69 33_Re: DSNTIAUL in Platinum Strategy22_steen elsborg pedersen25_elsborg_steen@HOTMAIL.COM31_Fri, 26 Jan 2001 10:27:32 -0000578_- Hi Walter

Try to use this input for running DSNTIAUL in CA's batch processor...

.CONNECT xxxx

.ALLOC FI(SYSREC00) + DA('SEP.SYSREC00') + TRACKS + SPACE(1,15) + UNIT(SYSDA) + NEW CATALOG .ALLOC FI(SYSPUNCH) + DA('SEP.SYSPUNCH') + TRACKS + SPACE(1,15) + UNIT(SYSDA) + NEW CATALOG .ALLOC FI(SYSPRINT) + SYSOUT(*) -- SQL STATEMENT .ALLOC FI(SYSIN) + DA('SEP.ISQL(TEST)') + SHR -- CALL DSNTIAUL .CALL DSN PARM(TD99) INDDN(SYSTSIN) .DATA RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) - PARMS('SQL') .ENDDATA .FREE FI(SYSPRINT) .FREE FI(SYSPUNCH) .FREE FI(SYSREC00) [...] 22615 12 33_Re: DSNTIAUL in Platinum Strategy15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 26 Jan 2001 05:57:07 -0600298_- Hi Steen

Great. It work's. Thank you very much.

================================================ 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. 22628 18 32_using test db2 as production db233_=?iso-8859-1?Q?R.teoman_KO=C7ER?=22_tkocer@HALKBANK.COM.TR31_Fri, 26 Jan 2001 14:12:49 +0200430_iso-8859-1 dear list we have 3 db2 subsystem in test environment namely DDB2,TDB2 and SDB2 D for Developmment T for Test. is it possible to use TDB2 as DDB2? What i need to do? Thanks you.

================================================ 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. 22647 37 37_Problem with DB2/VSE 6.1 and FZESQLDS15_Thomas Machovec22_thomas.machovec@VOL.AT31_Fri, 26 Jan 2001 14:47:14 +0100394_us-ascii We are migrating from SQL3.5 to Db2/VSE 6.1 and are still using CSP/AE 3.3. After migrating the DB we created SQL Accessmodule for the CSP/AE Online transactions with VSE-job FZESQLDS as described in the Program Directory of CSP/AE.

Our FZESQLDS-statement is: FZESQLDS FZFGNSQL SQLDIM=5,ISOLA=CS,SQLTYPE=SQLDS,SQLREL=61

Before migration the value for SQLREL was 35. [...] 22685 26 36_Re: using test db2 as production db210_John Hardy27_john_j_hardy@CONSULTANT.COM31_Fri, 26 Jan 2001 07:49:45 -0600624_- I think you need to make your query a little bit more understandable.



On Fri, 26 Jan 2001 14:12:49 +0200, =?iso-8859-1?Q?R.teoman_KO=C7ER?= wrote:

>dear list >we have 3 db2 subsystem in test environment namely DDB2,TDB2 and SDB2 >D for Developmment T for Test. >is it possible to use TDB2 as DDB2? >What i need to do? >Thanks you. > >================================================ >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. [...] 22712 239 33_Re: Reusing tablespace partitions14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 26 Jan 2001 13:58:38 -0000344_iso-8859-1 When I first read this I was struck my an immediate problem, but before I jumped in I wanted to double-check.

Now I have spoken with the lead developer for CAs Partition Expert product (which will help you out in rebalancing and rolling partitions, but as Ed Vassie says from BMC, it's probably too late to help you now. [...] 22952 75 52_Re: S0C1 errors after applying maintenance to DB2 V527_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Fri, 26 Jan 2001 09:04:48 -0500337_- This is it. Tic-toc got me. I got caught by this last summer, too, but DB2 failed on startup saying the module level was wrong. I thought I looked for the DSNXGRDS in the apply output, but apparently I didn't. I reapplied the zap and everything's wonderful now.

Thanks to everyone who sent suggestions. This list is great! [...] 23028 58 36_Re: using test db2 as production db215_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Fri, 26 Jan 2001 09:06:35 -0500588_windows-1250 It seems to me that "DDB2" and "TDB2" are the same.... "SDB2" appears to be your staging area for production moves and should always mirror your production subsystem.

My suggestion for what it is worth - (4 years ago I didn't know what DB2 was)

* Use "DDB2" for system developers to play with - Creating things is a messy business! * Use "TDB2" for True functional test systems that should not change often - This is what application developers would use to develop and test their apps. * Use "SDB2" for stage testing - meaning activity here should mirror [...] 23087 62 41_Re: Problem with DB2/VSE 6.1 and FZESQLDS24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Fri, 26 Jan 2001 09:56:42 -0800297_us-ascii Thomas, This is a CSP problem, not DB2. Is CSP/AE v3.3 still supported? Does it support DB2 V6.1? You might not be able to do what you want. As you probably know, SQL/DS V3.5 and DB2 Server for VSE&VM V5.1 are withdrawn from support on January 31, 2001 (5 days from now). Good luck. [...] 23150 101 33_Re: Reusing tablespace partitions15_Murley, Michael22_Michael_Murley@BMC.COM31_Fri, 26 Jan 2001 08:55:21 -0600349_iso-8859-1 Phil,

The rows themselves don't have the high-order bits that represent the partition number, but the page number for every page in the table space does. I'm not sure what you mean when you say 'rebuild all the rids'; rebuilding the indexes wouldn't change the table space page numbers. Am I misunderstanding something here ? [...] 23252 87 16_Re: VSAM EXTENTS11_Jeff Brokaw20_jeffbrokaw@YAHOO.COM31_Fri, 26 Jan 2001 09:54:10 -0600509_- I agree with what Linda says here, in general, although I would just add the following: (1) since DB2 doesn't do its own channel programs, the version of DB2 wouldn't seem relevant to VSAM extent issues, since that is the absolute lowest level of I/O, but I'm just offering an opinion here; (2) direct access could still be a problem with multiple extents if pointer records (overflow rows) cause access to pages not currently in the bufferpool, forcing yet more direct I/O, which is *very* expensive. [...] 23340 39 33_Re: DSNTIAUL in Platinum Strategy9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 26 Jan 2001 09:36:35 -0700324_us-ascii Go into the model that you are using in your strategy. Template the model (you can do this under the Profile choices in Migrator). In the model you can turn on which utilities Migrator will use (IBM or Platinum). You toggle the utilities on and off. If you turn off fload, then IBM load will be turned on,etc. [...] 23380 39 18_Re: Example needed11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 26 Jan 2001 09:20:43 -0800628_iso-8859-1 When you install Net.Data you get some sample macros. look for files stpins.d2w and stpdel.d2w in the directory ..../netdata/macros/

ref; 7.6.2 (page 42) Net.Data Version 2.2 Program Directory

cliff:-)

-----Original Message----- From: Kenski, David [mailto:David.Kenski@MARRIOTT.COM] Sent: Thursday, January 25, 2001 9:45 AM To: DB2-L@RYCI.COM Subject: Example needed



Hi! Our applications programming staff has asked me to raise this question on their behalf. Where can I find an example of a Net.Data macro calling a DB2 stored procedure? Website? Reference Manual? Redbook? [...] 23420 152 33_Re: Reusing tablespace partitions0_26_mark.walker@CUNAMUTUAL.COM31_Fri, 26 Jan 2001 11:27:12 -0600505_us-ascii Michael & Phil,

This conversation has been fascinating to me. As the discussion has progressed, something in the back of my mind kept saying that this wasn't a good thing to do because we don't really know with any certainty just what DB2's reaction would be. Your posts have just confirmed my feeling all along that creativity is a good thing when applied properly, but when playing with the nuts and bolts under the cover, we should just let DB2 do its thing even if it is painful. [...] 23573 75 33_Re: DSNTIAUL in Platinum Strategy9_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Fri, 26 Jan 2001 12:31:19 -0500420_us-ascii It is indeed possible to use the Utility models to specify whether to use Platinum utilities vs. IBM, but since DSNTIAUL is not officially a utility, it is not an option within the utility model. If you don't select the Platinum Fast Unload, you will get Platinum's proprietary unload program to do the unloads, which, if memory serves me correctly, produces a different type of unload file from DSNTIAUL. [...] 23649 25 60_Using REOPT(VARS) to pull in current RUNSTATS for static SQL13_Brendan Friel28_Brendan_Friel@NOTES.NTRS.COM31_Fri, 26 Jan 2001 11:31:58 -0600355_us-ascii I've seen a bit of a pattern in some OS/390 shops.

Run RUNSTATS jobs very frequently ('to improve performance'), hardly ever rebind static SQL.

In the archives, and the various bibles I don't find a lot of discussion of using REOPT(VARS) to pull in current stats. I would think the overhead in batch jobs wouldn't be that bad. [...] 23675 66 30_Re: Multiple DB2's and Endevor11_Bill Happel22_WRHappel@US.FORTIS.COM31_Fri, 26 Jan 2001 12:00:18 -0600345_US-ASCII We have Endevor and two DB2 subsystems. Endevor is a very flexible, not very user-friendly, Source Control System. You need to establish Environments and Stages. Each Environment.Stage has it's own set of parameters. Some of these parameters will be the DB2 subsystem and DB2 libraries, which will be different amongst the stages. [...] 23742 197 17_Re: DB2 and Excel17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Fri, 26 Jan 2001 10:20:02 -0800478_us-ascii Thanks for the info Victor.









vpacheco@AMAD EUS.NET To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: DB2 and Excel Discussion List



01/26/01 01:17 AM Please respond to DB2 Data Base Discussion List











Charles Besides DB2 Connect and Excel you also need to have MS Query installed. This normally is set up on the basic installation of MS Office. [...] 23940 58 64_Re: Using REOPT(VARS) to pull in current RUNSTATS for static SQL16_Maculsay, Gary R28_Maculsay.Gary@EMERYWORLD.COM31_Fri, 26 Jan 2001 18:26:27 -0000497_iso-8859-1 My experience of late shows more shops NOT running runstats indiscriminately. Instead, stats are captured without affecting the catalog columns used for optimizing (Platinum Database Analyzer, etc) and those stats are used to determine the need for maintenance, historical reporting, etc. Major releases of application software/database changes enable a window to re-apply "controlled" statistics. DB2 has a wonderful optimizer, but there are exceptions, and they usually kill us. [...] 23999 25 23_UDB Unicode support ???14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 26 Jan 2001 13:35:06 -0500394_iso-8859-1 Hi All,

We are using UDB V7.1 on NT here. Our database needs to support UCS-2 in the future to store Unicode characters (like strings in Japanese, Chinese etc.).

Is there something that needs to be done prior to and during creating the database to support this ? Does a column which will store the multi-language strings needs to be defined in any particular way? [...] 24025 23 30_Financial ERP tool from Lawson14_Chavez, George16_GEORGEC@IADB.ORG31_Fri, 26 Jan 2001 13:46:32 -0500427_iso-8859-1 Our organization select the Financial ERP tool from Lawson. We are in the process of recommending a DBMS such as DB2 OS/390, Oracle, MS SQL server. I would appreciate if I can get feed back from DB2 DBA's providing support for Lawson financial product.

If some body participate in the selection of a DBM for the Financial ERP tool from Lawson and want to share information with me I would appreciate it. [...] 24049 112 33_Re: DSNTIAUL in Platinum Strategy9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 26 Jan 2001 12:16:05 -0700537_us-ascii It has been my experience that Platinum's proprietary unload can pretty much do anything DSNTIAUL can as well. Here is an example of the proprietary unload output for unloading 2 columns into 1. This works for me, maybe I am missing something more that you are trying to do? This example is generating a migration strategy, then after analysis going into the output and changing the SELECT to contain the concatenation, and changing the load INTO statements to use the new table format, while using the proprietary unload. [...] 24162 18 12_VSAM RENAMES13_Davis, Ronald17_DavisRo@CONED.COM31_Fri, 26 Jan 2001 15:32:17 -0500480_iso-8859-1 Has anyone had experience with renaming DB2 vsam datasets?. We're setting up a read-only application that does daily load replaces. They require 24 x 7 access. I want to set up two sets of vsam datasets (a & b), load into the inactive dataset(b) rename the active to a bogus name(c small allocation), then rename the inactive(b)to the actual production dataset name(a). Then rename the bogus(c) to the inactive (b). I need pros and cons - all help is appreciated. [...] 24181 49 16_Re: VSAM RENAMES15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 26 Jan 2001 14:37:45 -0600454_iso-8859-1 I just used this today..... // jobcard......... //LISTC EXEC PGM=IDCAMS,REGION=1024K //SYSPRINT DD SYSOUT=* //SYSIN DD * ALTER xxxx.xxxx.xxxx.xx - NEWNAME(xxxx.xxxx.xxxx.xx.yy)

You have to run it against each piece of the file, cluster, data, index.

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin

"The basis of optimism is sheer terror." - Oscar Wilde [...] 24231 26 16_Re: VSAM RENAMES0_19_Tim.Lowe@STPAUL.COM31_Fri, 26 Jan 2001 14:44:10 -0600395_us-ascii Ronald, You might want to look at using RENAME TABLE to "switch" between your "active" and "inactive" tables instead of trying to rename the datasets. (RENAME TABLE was new with DB2 V5) Or, you could use a view to make the switch?

Otherwise, I think you are going to have a problem with your current plan with "load to inactive" since you would need a table to do the load. [...] 24258 76 16_Re: VSAM RENAMES15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Fri, 26 Jan 2001 15:17:26 -0600716_us-ascii I have a job that does just that:



//USA0050B JOB 'SULLIVAN',CLASS=M,MSGCLASS=H,NOTIFY=USA0050, // REGION=0M,TIME=1440 //* //* //*--------------------------------------------------------------------- //* THIS JCL DOES THE FOLLOWING : //* 1. DEFINES A LARGE INDEX FOR ONE OF CATALOG INDEX SPACE //* 0101 //* 2. RUN DSN1COPY OLD TO NEW DATASET //* //* 3. RENAME CURRENT TO OLD AND NEW TO CURRENT //* //* 4. START THE TABLE SPACE OR INDEX WHICH STOPPED EARLIER //* //* //* EXECUTE IDCAMS TO DEFINE THE NEW INDEX DATA SET. //* //DEFTS EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * DELETE USADQA2B.DSNDBC.ZZLZ02A.ZZLZ02A$.NEW01.A001 CLUSTER PURGE DEFINE CLUSTER - [...] 24335 50 38_V6 Load: Parlallel Index Build Problem14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Fri, 26 Jan 2001 12:48:06 -0600539_us-ascii Hello List,

I am testing some new V6 features of DB2. I am attempting to run a LOAD with parallel index building, by specifiying SORTKEYS N and including sortworks SW01WK01, SW02WK02, etc.

The LOAD returned S04E with REASON=X'00E4001A'. The quickref on this reason code is: --------------------------------------------------------------------------------------------------------------- 00E4001A

Explanation: An error was detected while using SVC 99 to retrieve information on the DD statements supplied. [...] 24386 95 38_V6 Load: Parlallel Index Build Problem15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Fri, 26 Jan 2001 16:29:51 -0600564_us-ascii Hi Richard

Increase size of the following files SYSUT1 & Sortwork file try by specifying rough value :

SW01WK01 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND) SW01WK02 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND) SW01WK03 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND)

SW01WK04 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND) SW01WK05 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND) SW01WK06 DD UNIT=SYSDA,SPACE=(CYL,(200,200),,,ROUND)

I think need to specify 6 sort files for parallel sort plus build phase so that it can run parallel. [...] 24482 41 27_Advanced SQL Training Class24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 26 Jan 2001 15:05:42 -0800524_- To anyone in the Portland, Oregon area:

This is essentially a repost, but with additional information about payment options.



Class Notice:

CNF, INC in Portland, Oregon will be hosting a 2-day Advanced SQL class from Yevich, Lawson and Associates on February 6-7, and again on February 8-9. The class is suitable for both DBAs and developers. The class is open to the Portland area community. Details on the class subject can be found at http://www.ylassoc.com/Education/education_06.htm. [...] 24524 60 16_Re: VSAM RENAMES14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Fri, 26 Jan 2001 18:00:47 -0600555_- I think the rename table was meant to rename in place an existing table, EMP to EMPLOYEE for example. DB2 Catalog entries are updated as well. However, the DBIDs,OBIDs,PSIDs, etc... internally are still the same. Take 2 tables for example: tab1 & tab2. If you renamed the object tab1 to tab1a and tab2 back to tab1, the tab1a would be inaccessible as a table, as they would be isolated Linear VSAM clusters. If the new tab1 was loaded as some other table in order to populate it, then its OBID, DBID, PSID would be different and the new tab1 would [...] 24585 35 38_Re: DB2 Connect MTS and 2-Phase Commit9_Ken Hynes17_khynes@TRIGON.COM31_Fri, 26 Jan 2001 21:23:07 -0600510_- I haven't seen the actual messages yet as I'm splitting my time on several other "fires", but in discussing the problem with the developers. They are trying to build a "multi-threaded" application with MTS acting more or less as the coordinator. If any of the several updates fails they need to be able to rollback the entire Unit of Work. So far they have not been able to accomplish this. I was told that even with a songle update thread and a deliberate ABORT Rollback thre update took place (OUCH). [...] 24621 93 52_Re: S0C1 errors after applying maintenance to DB2 V517_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 27 Jan 2001 15:05:14 +1100324_us-ascii Tina, So ya got caught twice as well, welcome to the club. Knowing me, I will get caught again. Wwe have even put warnings all over the place - next one is in the MSTR JCL as you probably will look there for the error message. Next time it will not take us as long (or at least I try to convince myself this!) [...] 24715 23 20_ipname needed or not12_Rakesh Kumar21_rakesh457@HOTMAIL.COM31_Sat, 27 Jan 2001 05:17:37 -0000284_- ALL, In our installation there is no entry for the catalog table SYSIBM.IPNAMES and our DRDA access is thru TCP/IP.Is it mandatory to have an entry in this table or in other words what are the impact of not having an entry in this table.Can any one from IBM eloborate on this. [...] 24739 75 16_Re: VSAM RENAMES14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sat, 27 Jan 2001 17:50:36 +1100377_iso-8859-1 1) You can't do what you are proposing. When you "load into the inactive dataset" it will have DB2 table/tablespace obids appropriate to the inactive name. When you "rename the inactive(b)to the actual production dataset name(a)", DB2 will be expecting the OBIDs in the becoming-active dataset to be those appropriate to the active name, not the inactive name. [...] 24815 36 24_Re: ipname needed or not11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Sat, 27 Jan 2001 05:52:41 -0500634_ISO-8859-1 Rakesh

You only need entries in IPNAMES if this DB2 will send SQL requests to another database server. SQL requests from remote clients coming into this DB2 do not use IPNAMES.

Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk

Message text written by DB2 Data Base Discussion List >ALL, In our installation there is no entry for the catalog table SYSIBM.IPNAMES and our DRDA access is thru TCP/IP.Is it mandatory to have an entry in this table or in other words what are the impact of not having an entry in this table.Can any one from IBM eloborate on this. [...] 24852 125 42_Re: V6 Load: Parlallel Index Build Problem11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Sat, 27 Jan 2001 05:52:39 -0500403_ISO-8859-1 Nayeem, Richard

You both seem to have problems with the DD naming. The DD name convention for index build parallelism is SWnnWKmm where nn is task number and mm is dataset number within task. Nayeem's example provides datasets for one task only, so no parallelism. Richard provides a dataset 2 for task 2 but no dataset 1. You must have a SW02WK01 before you can have a SW02WK02. [...] 24978 165 30_Re: Multiple DB2's and Endevor0_14_DPetro@AOL.COM29_Sat, 27 Jan 2001 09:22:58 EST559_US-ASCII Ken,

If all you need to do is permit each existing Endevor Environment/Stage/System/Subsystem to reference multiple DB2's, then all you should need to do is setup additional processor groups. For example, if your existing processor group is named COBCOMP1 and processes programs into DB2T/DB2P (Test/Prod), you could simply create a second processor group called COBCOMP2 that processes programs into DB3T/DB3P. Which DB2 is used is then dependent on which processor group the program uses when added to Endevor. This suggestion assumes: [...] 25144 29 17_Workfile Prefetch12_John Piccoli16_jpiccoli@LOOK.CA31_Sat, 27 Jan 2001 14:25:02 -0500443_us-ascii Does a high value in the "Workfile Prefetch Not Scheduled" field(BP sort/merge section of the statistics detail report) indicate: 1)sortwork pool shortage 2)bufferpool shortage

John CDS

================================================ 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. 25174 39 27_V6 on OS/390: wrong index ?16_Jean-Paul Coenen19_jpc_db2@HOTMAIL.COM31_Sun, 28 Jan 2001 13:43:22 +0100381_- Dear list,

Wondering why the optimizer desides to use a "fat" index instead of a "slim" one. Situation: V6 on OS/390. Table with several indices, two of them starting with the same columns. INDEX1: COL1 asc, COL2 asc. Clustering index. INDEX2: COL1 asc, COL2 asc, followed by 6 other columns, making this index about 100% broader than the first ons. Recent runstats. [...] 25214 14 51_Daniel Sullivan/ZI/USA/Zurich is out of the office.15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Sun, 28 Jan 2001 07:23:37 -0600365_us-ascii I will be out of the office from 01/28/2001 until 01/29/2001.

I will respond to your message when I return.

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