1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 1999, week 2 2 36 25_Re: Bufferpool Allocation30_Humphris,Richard,CNA Insurance24_Richard.Humphris@CNA.COM30_Thu, 7 Oct 1999 15:19:22 -0500553_- Only problem could be if your processor doesn't have enough storage to support your buffer pools. If your buffer pools aren't seeing a lot of MVS paging, then there isn't a penality. Otherwise, you may want to size it better or get more real storage.

IBM uses a hash implementation to find pages in the buffer pool, so CPU time used to find things in the buffer pool remains the same reguardless of the size of the buffer pool (very nice). In fact, if the increase in the buffer pool will avoid more I/O you'll probably see a reduction in [...] 39 12 42_Gordon Reich/WCBAlta is out of the office.0_22_gordon.reich@WCB.AB.CA30_Fri, 8 Oct 1999 01:01:29 -0600147_us-ascii I will be out of the office starting 1999/10/08 and will not return until 1999/10/12.

I will respond to your message when I return. 52 21 13_Indexes on RI0_28_ruediger.kurtz@HUK-COBURG.DE30_Fri, 8 Oct 1999 10:16:54 +0100463_us-ascii Hi anyone out there,

I have a question concerning indices on foreign keys in our shop. We automatically generate indices on foreign keys. A survey on SYSIBM.SYSPACKDEP has shown that quite a number of those indices is not being used by packages. Now we're wondering whether we can drop those indices without any harm or whether those indices will be used by DB2 internally to check on RI, especially when deleting rows from dependent tables. [...] 74 119 37_Re: [Fwd: [Fwd: Re: Altering fields]]0_28_ruediger.kurtz@HUK-COBURG.DE30_Fri, 8 Oct 1999 10:21:58 +0100817_us-ascii Phil,

as you mentioned DBArtisan just one question, how do you alter a tablespace using DBArtisan ?

TIA Ruediger







thomas.roedel@HUK-COBURG.DE wrote: > > -- > >"""""< > !_ _! > (o) (o) > oOOO--(_)--OOOo-----------------------------------------------------* > * * > * Thomas Roedel * > * * > * HUK-Coburg Phone: 09561/96-3915 * > * Versicherungen-Bausparen Fax : 09561/96-3678 * > * Abt. Informatik (Datenbanken) * > * Bahnhofsplatz Mail: thomas.roedel@huk-coburg.de * > * 96450 Coburg * > *-------------------------------------------------------------------* > > --------------------------------------------------------------- > > Subject: [Fwd: Re: Altering fields] > Date: Thu, 07 Oct 1999 16:09:02 +0100 > From: ruediger.kurtz@huk-coburg.de > Organization: [...] 194 34 22_Re: ROWID partitioning13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 8 Oct 1999 10:24:56 +0100491_iso-8859-1 >Best, is some clustering key that matches the order of range/batch >retrieval. If that is not the case, then we need another very long answer >to your problem. > >Richard Yevich

You're right, of course. I'm just clutching at straws. I thought of ROWID partitioning as a possible option because the underlying data structure's clustering keys does not lend itself to partitioning. The application's default clutering key (on any table) is the table's unique key. Doh! [...] 229 39 17_Re: Indexes on RI0_24_ssethi@LOT.TATASTEEL.COM30_Fri, 8 Oct 1999 14:51:28 +0530327_- If DB2 Internally uses any of the parameters or the objects for its internal operation then IBMREQD for that Row will be 'Y'. So ,if u can find any row with IBMREQD as 'Y' then u cann't /shouldn't delete that row or drop that particular index otherwise as i think u are free to determine and drop the redundant indexes. [...] 269 15 32_Re: Access to DB2 other than SQL17_Giorgio De Nunzio25_giorgio.denunzio@UNILE.IT30_Fri, 8 Oct 1999 12:14:02 +0200298_us-ascii Hi Ken and Chris, and thanks for your kind replies. My idea was to maximize the access speed by a more direct access, but I am now convinced (by your answers and by comments received from other DB2 gurus) that this is not a good way to follow. Thank you very much for your advices. Giorgio 285 43 32_Re: Access to DB2 other than SQL13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Fri, 8 Oct 1999 11:29:13 +0100377_iso-8859-1 I have heared of an intrepid programmer who, armed with the diagnosis guide and notes from the DB2 internals course, wrote an assembler program to access the underlying linear VSAM data set of a DB2 tablespace. His reason was curiosity rather than performance. Of course, should IBM wish to change the page layout in a new release, the program becomes invalid. [...] 329 36 17_Unload Only "bug"10_Ven Ilagan18_vilagan@ONE.NET.AU30_Fri, 8 Oct 1999 08:48:19 +1000573_us-ascii Hi Guys,

Has anybody got any APAR to point me to for this quirk I found just lately. We're on V5 - OS/390 on put 9906. (I think)

1. Table had Alter Table Add columns added (about 5 columns). Tablespace consists of 16 partitions. 2. Reorg Tablespace .... PART 1 SORTDATA UNLOAD ONLY done. 3. After some interval, LOAD DATA LOG NO RESUME YES FORMAT UNLOAD INTO TABLE ... PART 1 REPLACE undertaken - rc=8 with all rows discarded with message saying column so-so (1st column alter added) could not be loaded as end of row found. So frustrating when [...] 366 32 31_DB2 v5 mvs to oracle AIX rs600019_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM30_Fri, 8 Oct 1999 12:49:58 +0200461_iso-8859-1 Hello All,

Can anybody please advise me as to the best way to "push/pull" data from a DB2 subsystem version 5 running on os390 to Oracle running on a unix rs6000.

I have currently got jobs set up that unload the data from the DB2 tables to sequential flat files which are then sent to the rs6000 box via tcp/ip. Using this approach I cannot vouch for the consistancy of the data if there is a problem with the tcp/ip transmission. [...] 399 31 46_Re: Gordon Reich/WCBAlta is out of the office.10_Rick Davis22_richard.g.davis@DB.COM30_Fri, 8 Oct 1999 06:58:48 -0600567_us-ascii gordon, please don't auto-respond to db2-l. set nomail via mail to listserv@ryci.com



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



From: gordon.reich@wcb.ab.ca on 10/08/99 07:01 AM GMT

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: Subject: Gordon Reich/WCBAlta is out of the office.







I will be out of the office starting 1999/10/08 and will not return until 1999/10/12.

I will respond to your message when I return. 431 30 58_Tracking Resource Limit Facility activity - DB2 for OS/39012_Sue Janowitz18_SJanowitz@NEFN.COM30_Fri, 8 Oct 1999 08:16:34 -0400387_- We are at DB2 V5.1 (OS/390), and use Landmark's TMON for DB2 monitor. We have just implemented the use of the DB2 resource limit facility (RLF) to kill threads using 3 specific plans that use too much CPU time. We have problems with these threads infrequently - maybe once every few weeks - but with enough impact that we want to automatically kill them before things go too far. [...] 462 33 12_DSNU406I !!!0_28_Giuseppe_Di_Donna@CARTASI.IT30_Fri, 8 Oct 1999 14:24:44 +0200611_us-ascii While taking a fullimagecopy on a TS in a non-datasharing enviroment and invoking a normal :

COPY TABLESPACE DBxxxxxx.TSxxxxxx COPYDDN SYSCOPYx

I received a warning (04) DSNU406 !!! wich means :

DSNU406I FULL IMAGE COPY SHOULD BE TAKEN FOR BOTH LOCAL SITE AND RECOVERY SITE.

Explanation: The requested full image is for one site only but history shows that there were image copies taken for both local site and recovery site and the table space is in copy pending status, or point in time recover has been done on the table space, or the table space is in copy pending [...] 496 13 30_DB2 Connect - DB2DIAG.LOG file11_Steck, Dave16_Steckd@ABCBS.COM30_Fri, 8 Oct 1999 07:32:26 -0500300_iso-8859-1 There is a file DB2DIAG.LOG on our NT machines running DB2 Connect PE that is about 20m in size and growing. Is there a way to configure DB2 Connect so less information is logged to slow down the growth rate?

How can I reduce its size now that it's that big? Can you just delete it? 510 11 56_=?iso-8859-1?Q?R=E9f._:_DB2_Connect_-_DB2DIAG.LOG_file?=14_Denzil Coulter26_Denzil.Coulter@UNICIBLE.CH30_Fri, 8 Oct 1999 14:44:01 +0200155_us-ascii try modifying the 'client settings...' in the client config assistant. The Diagnostic tab contains the 'Diagnostic error capture level' parameter. 522 29 34_Re: DB2 Connect - DB2DIAG.LOG file13_Philip Nelson21_teamdba@ATTGLOBAL.NET30_Fri, 8 Oct 1999 13:41:35 +0100549_us-ascii On Fri, 8 Oct 1999 07:32:26 -0500, Steck, Dave wrote:

>There is a file DB2DIAG.LOG on our NT machines running DB2 Connect PE that >is about 20m in size and growing. Is there a way to configure DB2 Connect >so less information is logged to slow down the growth rate?

You can set the environment variable DIAGLEVEL - by default this is 3, but can be reduced. However its good to have this level of statistics in case of problems. > >How can I reduce its size now that it's that big? Can you just delete it? > Simply delete [...] 552 24 34_Re: DB2 Connect - DB2DIAG.LOG file14_Philip Gunning20_pgunning@BOSCOVS.COM30_Fri, 8 Oct 1999 08:49:28 -0400367_- you can just delete it. Db2 Connect will recreate it if it needs it. Phil

Phil Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Certified Solutions Expert -- CICS TS

-----Original Message----- From: Steck, Dave [SMTP:Steckd@ABCBS.COM] Sent: Friday, October 08, 1999 8:32 AM To: DB2-L@RYCI.COM Subject: DB2 Connect - DB2DIAG.LOG file [...] 577 42 25_Re: DB2 SUBSYSTEM MONITOR14_Philip Gunning20_pgunning@BOSCOVS.COM30_Fri, 8 Oct 1999 08:54:59 -0400341_- Mary Ann, We use Platinum Detector. We trialed BMC Apptune and Detector and found them to both do a good job. We have VB, Powerbuilder, and Peoplesoft and a tool to capture dynamic sql is a must. HTH Phil

Phil Gunning Assoc List Owner DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Certified Solutions Expert -- CICS TS [...] 620 48 30_DB2, MS Access and DB2 Connect12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US30_Fri, 8 Oct 1999 07:48:31 -0500559_iso-8859-1 > -----Original Message----- > From: Reid, Louise > Sent: Thursday, October 07, 1999 9:14 AM > To: 'xavier@netexpress.net' > Subject: FW: DB2, MS Access and DB2 Connect > I must not understand how this works. I sent this message (attached) last > week but do not see it on the list. > I also tried to send this search to 'LISTSERVE@RYCI.COM' > SEARCH DB2-L FROM TODAY-7 TO TODAY WHERE SUBJECT CONTAINS ACCESS > > and again with quotes around the search words and rec'd error messages on > both. > > I have never used a listserve before so I'm [...] 669 40 34_Re: DB2 Connect - DB2DIAG.LOG file16_Michael McCarthy24_Michael_McCarthy@DTC.ORG30_Fri, 8 Oct 1999 09:01:13 -0400537_us-ascii Dave,

There is a Database Manager Configuration parameter called DIAGLEVEL. Level 1 is for severe errors only, Level 2 is for normal and severe errors, Level 3 is for warnings, normal, and severe errors, and Level 4 is for informational, warning, normal, and severe error messages. You probably have this set to 3(default) or 4. If you delete the db2diag.log, no harm is done. The next time DB2 needs to write to it, it will be recreated. Use the update dbm cfg command to change the DIAGLEVEL to the desired level. [...] 710 62 18_Re: RID in DB2 UDB14_Huang, Eugenia16_HuangE@AETNA.COM30_Fri, 8 Oct 1999 09:03:14 -0400494_- Jim:

Sorry for not being clear enough. Unfortunately, the UDB that I referred to is UDB on distributed environment, such as: UDB on Windows, NT, AIX UNIX, that what we're currently trying to figure out any easier way to help out the applications that struggling with their online inserts and deletes... -----Original Message----- From: Campbell James [mailto:James.Campbell@ENERGYIS.COM.AU] Sent: Wednesday, October 06, 1999 9:14 PM To: DB2-L@RYCI.COM Subject: Re: RID in DB2 UDB [...] 773 75 41_Re: CA's DB2 for OS/390 Tech Forum (U.S.)12_Janis Thomas20_thomasj@PLATINUM.COM30_Fri, 8 Oct 1999 08:29:54 -0500394_us-ascii To answer the 2 questions about Canada, more Tech Forums are being planned for after the first of the year. The cities and dates have not been finalized yet, but they are looking at including some cities in Canada. Sorry I don't have anymore specific information right now. When I get the final information passed to me, it will be added to the web site, and I will post it here. [...] 849 27 28_Control Center Error UDB 6.114_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Fri, 8 Oct 1999 09:36:31 -0400581_iso-8859-1 Hi!

I need some help resolving the following error. I just completed installing UDB 6.1 PE on my NT Workstation and rebooted the machine. It came up and said DB2 V6.1 installed successfully. But when I invoke Control Center, I get :

IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01

I get the same error when I try to invoke the Information Center. However, I can use CCA, CLP and the command center and am able to Catalog DRDA host databases as well as local database - just can't use the control center and Information center.. [...] 877 37 25_why does this take longer13_Oelkers, Phil25_phil.oelkers@EXPERIAN.COM30_Fri, 8 Oct 1999 06:25:19 -0700448_- We have a process that populates a db2 table using a

Insert ... from select ...

The only use of the resulting table is as input into a cobol program. The entire table is brought into the program row by row just like it was a flat file.

To make things run a bit better we tried using DB2BATCH to run only the select portion of the sql used to create the table and create a flatfile that can be read by the cobol program. [...] 915 20 35_IBM Enterprise Storage Server (ESS)17_Gerald Bustamente20_ggbusta@LANDSEND.COM30_Fri, 8 Oct 1999 08:41:38 -0500355_koi8-r I am curious if anyone if familiar with this new technology and could give their impression on the impact of ESS and the need for placing datasets to minimize hotspots and the impact on the need for reorganization.

Tall order, I know. But any advice would be greatly appreciated.

Thank,

Jerry Bustamente Lands' End 608-935-4815 936 54 32_SV: Control Center Error UDB 6.125_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE30_Fri, 8 Oct 1999 15:41:42 +0200656_ISO-8859-1 Manas,

CLI0616E Error opening socket. Explanation: Cannot open the socket to server, server may be down. User Response: Ensure JDBC server is up, and rerun your program.

check that the required services are up and running, go to control panel and services. Hope this helps.

Sven Heidorn

> -----Ursprungligt meddelande----- > Från: Manas Dasgupta [SMTP:manas.dasgupta@PFSFHQ.COM] > Skickat: den 8 oktober 1999 15:37 > Till: DB2-L@RYCI.COM > Ämne: Control Center Error UDB 6.1 > > Hi! > > I need some help resolving the following error. I just completed > installing > UDB 6.1 PE on my NT Workstation and rebooted [...] 991 45 22_Stored Procedure Error15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU30_Fri, 8 Oct 1999 09:48:30 -0400463_iso-8859-1 The story of the Run away Procedure-

I have the procedure defined in SYSPROCEDURES I have the procedure bound into a collection/plan I have queried the catalog, the package is listed within the collection, and the collection is listed for the plan. So all the packages within the collection should be found in that plan. I have (in the past month) ran the procedure passing the proper IN/OUT parm and returned the single result set desired [...] 1037 56 29_Re: why does this take longer18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM30_Fri, 8 Oct 1999 09:44:07 -0400556_- Check your logic to make sure you are not closing and reopening the file before each read. This can create a significant amout of overhead.

I assume you are running this on an OS/390 environment?





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301





-----Original Message----- From: Oelkers, Phil [mailto:phil.oelkers@EXPERIAN.COM] Sent: Friday, October 08, 1999 9:25 AM To: DB2-L@RYCI.COM Subject: why does this take longer [...] 1094 67 26_Re: Stored Procedure Error20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 8 Oct 1999 09:55:30 -0400619_- Rick

Do you give control to WLM to start/stop the SPAS ? In this case, you have to issue VARY APPLENV=xxx,RESUME operator command so that SPAS can refresh load library.

HTH Pillay

> -----Original Message----- > From: McClendon, Rick [SMTP:RMcClendon@ADMIN.FSU.EDU] > Sent: Friday, October 08, 1999 9:49 AM > To: DB2-L@RYCI.COM > Subject: Stored Procedure Error > > The story of the Run away Procedure- > > I have the procedure defined in SYSPROCEDURES > I have the procedure bound into a collection/plan > I have queried the catalog, the package is listed within the collection, > and > the [...] 1162 59 38_Re: Stored Procedure Error -Correction20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 8 Oct 1999 09:57:58 -0400591_- I am sorry, I wrote RESUME in the last mail - should have been REFRESH

> -----Original Message----- > From: McClendon, Rick [SMTP:RMcClendon@ADMIN.FSU.EDU] > Sent: Friday, October 08, 1999 9:49 AM > To: DB2-L@RYCI.COM > Subject: Stored Procedure Error > > The story of the Run away Procedure- > > I have the procedure defined in SYSPROCEDURES > I have the procedure bound into a collection/plan > I have queried the catalog, the package is listed within the collection, > and > the collection is listed for the plan. So all the packages within the > collection should be found [...] 1222 57 29_Re: why does this take longer0_20_John_Lendman@FPL.COM30_Fri, 8 Oct 1999 09:52:22 -0400379_us-ascii There are couple of things you could do. One is extract the data in a flat file then use the load utility to put the data back into the table, just make sure you use the resume yes parm. John







"Oelkers, Phil" on 10/08/99 09:25:19 AM

Please respond to "DB2 Data Base Discussion List" [...] 1280 59 29_Re: why does this take longer0_19_mike.holmans@BT.COM30_Fri, 8 Oct 1999 15:03:06 +0100453_- When you create the flat file, you incur physical writes to DASD. When you do the INSERTs, the pages get updated in buffer, but the write to DASD is asynchronous.

With the first, the writes to DASD have to complete before your process is finished; in the second, your operation completes once the bufferpool has been updated, and the write to DASD can happen whenever DB2 gets round to it, but does not hold up your subsequent processing. [...] 1340 101 34_Re: DBM1 asynch write buffer flush11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM30_Fri, 8 Oct 1999 07:24:21 -0700595_- Richard,

I beg to differ from your interpretation of 'Asynch I/O wait'.

1) It is not due to shortage of log output buffer. Any delay in writing to OUTBUFF is part of 'Service task wait time' in the accounting report, not Asynch I/O wait time.

2) The statement you quoted from IBM manual " specify the maximum value for OUTBUFF (up to 4000KB) to prevent buffer shortages. In fact, IBM's exact words are: >"The buffer MUST be large enough to prevent buffer shortages in order to >decrease the number of forced I/O operations (forced because there are no >more buffers) [...] 1442 49 35_Re: DB2 v5 mvs to oracle AIX rs60008_Long, Ed15_Ed.Long@FMR.COM30_Fri, 8 Oct 1999 10:27:02 -0400277_- We have similar activities and have tried several options. 1: Tape. This is our default. 2: DB2 connect looks like our next option. 3: Neon has a product as well. 4: We have not had many problems with FTP at all. You don't specify how much data, Is it Gb. or Terabytes? [...] 1492 53 16_Re: DSNU406I !!!0_23_Mike_Levine@TEKHELP.NET30_Fri, 8 Oct 1999 10:31:34 -0400569_us-ascii Hi Pino,

History never lies...At some point in time someone took an image copy with RECOVERYDDN specified in the image copy control card. This is just a warning and can be ignored if you do not intend to perform disaster recovery by bringing up DB2 as 'recovery site'. Many installations create two image copies of a tablespace, one for local recovery (COPYDDN) and one for disaster recovery purposes (RECOVERYDDN). At the disaster recovery site, DSNZPARM is changed to recovery site and DB2 calls for image copies created with the RECOVERYDDN DD. [...] 1546 75 29_Re: why does this take longer0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 8 Oct 1999 09:29:58 -0500344_us-ascii I have been told that doing a LOAD of a flatfile with LOG NO (default is YES) is faster than doing the equivalent individual inserts from a program because logging of individual inserts is disabled during the load. Remember that you have to do an IMAGE COPY after the LOAD to remove the copy pending status that is set by LOG NO. [...] 1622 102 29_Re: why does this take longer11_Case, Missy15_CASEM@PKSIS.COM30_Fri, 8 Oct 1999 10:01:28 -0500312_- Rohn, Or you can use the inline copy feature with the load LOG(NO) utility. I have found this to work really great in V5, saved time and helped my DR as the users option was 'setnocopypend' right after the load. The load w/ copy is faster than the load then image copy so it should be an easy sell point. [...] 1725 178 19_Re: Altering fields27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Fri, 8 Oct 1999 18:55:10 +0530477_iso-8859-1 Richard, On receiving K's and Craig's mail, we tried using this ALTER command to increase the lenght of the varchar field . The syntax is as follows : ALTER TABLE table-name ALTER COLUMN column-alteration SET DATA TYPE VARCHAR (integer)

When we tried using this on DB2 version 5 for os/390 , we got a -199 SQL REturn code. Do we need to do some retrofitting on our DB2 version to enable this. If so how do we go about doing it. Thanks in Advance Deepak. [...] 1904 60 25_Re: DB2 SUBSYSTEM MONITOR14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 8 Oct 1999 10:06:32 -0500521_iso-8859-1 Mary Ann:

A good complement to BMC's Activity Monitor is BMC's Apptune solution.

APPTUNE quickly identifies the largest, resource-consuming, performance-constrained or error-prone SQL statements. It delivers a precise assessment of SQL statement performance by providing data that has been collected and correlated to the time DB2 spent processing the SQL statement.

Apptune will work well to help you find and fix the problems you are having with your dynamic SQL (static SQL, too). [...] 1965 88 19_Re: Altering fields20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 8 Oct 1999 11:09:06 -0400609_ISO-8859-1 You have to have APAR PQ16674 - "EXTEND VARCHAR LENGTH clause of ALTER TABLE"



> -----Original Message----- > From: Thakral, Deepak Kumar (CTS) [SMTP:TDeepak@CHN.CTS-CORP.COM] > Sent: Friday, October 08, 1999 9:25 AM > To: DB2-L@RYCI.COM > Subject: Re: Altering fields > > Richard, > On receiving K's and Craig's mail, we tried using this ALTER command to > increase the lenght of the varchar field . The syntax is as follows : > > ALTER TABLE table-name > ALTER COLUMN column-alteration > SET DATA TYPE VARCHAR (integer) > > When we tried using this on DB2 version 5 for os/390 [...] 2054 134 44_Re: -904 on package when not binding - reply0_22_rob.crane@PLATINUM.COM30_Fri, 8 Oct 1999 10:19:03 -0500456_us-ascii The SKPT(skeleton package tables) and PT(package tables (copies of SKPT)) reside in the EDM pool. Using packages typically helps EDM Pool storage management by decreasing the size of the objects in the EDM pool. (Smaller package DBRMs vs one large plan DBRM). Try and monitor the I/0 activity in the directory (DSNDB01) increased I/) to the directory could imply to small of EDM pool. Based on your -904, I doubt this is an EDM pool problem. [...] 2189 93 35_Re: Output from the TSO DSN Command11_Jim Keohane19_jimkeo@LOCKSTAR.COM30_Fri, 8 Oct 1999 11:24:26 -0700582_iso-8859-1 Ran,

Does DSN ... TEST(0) write to DSNTRACE any more info than one would see when running same code under non-TSO batch via Call Attach Facility (CAF) with

//DSNTRACE DD SYSOUT=....

Thanks! - Jim

Ran Abeykoon wrote:

> Chuck, > > As others suggested you can capture the output of DB2 commands into a data set > using the REXX OUTTRAP command. However it's a longer way of achieving the > desired result. > The best and the cleanest way to capture the output is by allocating a data set > to a file called DSNTRACE which DB2 uses to [...] 2283 296 34_Re: Archlog copy from tape to disk11_rick creech18_ykcirc@HOTMAIL.COM28_Fri, 8 Oct 1999 08:23:39 PDT419_- Another issue to be aware of with the logs: To avoid problems copying a tape archive log to the active log, there is an very good description of the issues and how to determine the correct blksize in the DB2 ADMIN GUIDE under the heading "Determining the Size of the Active logs". Quoting: "We recommend that the number of records for the active log be divisible by the blocking factor of the archive log." etc. [...] 2580 56 25_Re: DB2 SUBSYSTEM MONITOR14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 8 Oct 1999 10:23:40 -0500521_iso-8859-1 Mary Ann:

A good complement to BMC's Activity Monitor is BMC's Apptune solution.

APPTUNE quickly identifies the largest, resource-consuming, performance-constrained or error-prone SQL statements. It delivers a precise assessment of SQL statement performance by providing data that has been collected and correlated to the time DB2 spent processing the SQL statement.

Apptune will work well to help you find and fix the problems you are having with your dynamic SQL (static SQL, too). [...] 2637 41 35_Re: query involving 2 different DBs18_Centro de Computos21_iplc05@INFOVIA.COM.AR30_Fri, 8 Oct 1999 12:29:24 -0300304_us-ascii Hi K! Well, I followed the thread since it started, I issued more or less the same question some two weeks ago and have no repplies, so I would sorry if any responses are posted only to you. Please, don't exclude me !!!

Thanks in advance

Daniel Red Robe Wizard from Palanthus [...] 2679 44 18_Re: Scripts in UDB18_Centro de Computos21_iplc05@INFOVIA.COM.AR30_Fri, 8 Oct 1999 12:32:12 -0300431_iso-8859-1 Hi Don ! I had the same problem with a backup script some days ago, I received lots of suggestions from the list in order to solve the problem, and at last I solved it (in fact, it "solved" I don´t exactly know how or why...). I created the script using the SmartGuide, and I also couldn´t view the code of the script. I forward you the post I received with your Subject. Good luck, HTH and "cross your fingers" :) [...] 2724 78 54_Re: Scripts in UDB (was: RE: Scheduled backup failure)18_Centro de Computos21_iplc05@INFOVIA.COM.AR30_Fri, 8 Oct 1999 12:32:07 -0300592_us-ascii ---------- Desde: Greg.Palgrave@BANKWEST.COM.AU[SMTP:Greg.Palgrave@BANKWEST.COM.AU] Enviado el: Tuesday, September 21, 1999 9:27 PM Para: DB2-L@LISTSERV.AMERICAN.EDU Asunto: Re: Scheduled backup failure

<> Hi Daniel,

A few suggestions:

1. Check that the DB2DAS00 service is running properly on the DB2 server. If the DAS has died, then job scheduling goes with it. The DAS can sometimes go into what we call "na na land" i.e. the service is started, but not talking to the rest of the world - requiring a stop & start of the service. [...] 2803 64 40_RV: DB2LOOK in the UDB v 5.2 environment18_Centro de Computos21_iplc05@INFOVIA.COM.AR30_Fri, 8 Oct 1999 12:36:38 -0300563_us-ascii ---------- Desde: Usuario de email IPLC05 Enviado el: Friday, October 08, 1999 12:32 PM Para: 'DB2 Data Base Discussion List' Asunto: RE: DB2LOOK in the UDB v 5.2 environment

Hi, folks ! This post is rather old but I haven't found any repplies in my mailbox. I installed DB2 UDB 5.2 on a Win NT 4.0 and DB2LOOK worked fine for six or seven days. After that, everytime I issue the same command (db2look -d gesval -a -e -o gesval.ddl) it started Dr. Watson (I hate it so much!!!) and the file was created empty. The database looks and performs [...] 2868 22 8_rollback10_Vikas Puri24_Vikas.Puri@METAMORGS.COM30_Fri, 8 Oct 1999 11:41:42 -0400331_us-ascii Hi ALL,

A small question to the gurus of DB2.

Can I replace exec cics syncpoint rollback exit cics.

with exec sql rollback exit rollback.

I know syncpoint is double phase commit and we can't replace it with commit. But I guess above should not give any problem. Please suggest.

Thanks vp 2891 36 19_Re: Altering fields14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 8 Oct 1999 10:49:22 -0500465_iso-8859-1 Mr. Kurtz:

I was talking about DB2 UDB for OS/390 in my response regarding altering columns. Although I believe it is applicable to DB2 UDB on other platforms as well. You have to be careful with terminology these days because DB2 is now UDB on OS/390 as well as on NT, AIX, OS/2, etc. For alteration tools from BMC check out Alter and Change Manager (for OS/390) and Patrol DB-Alter and patrol DB-Change Manager (for distributed platforms). [...] 2928 41 12_Re: rollback15_Philip, Sibimon19_PhilipS@SEALAND.COM30_Fri, 8 Oct 1999 11:52:31 -0400385_iso-8859-1 I have not tested, but rollback also should be two phase. Cics must be handling other recoverable resource like VSAM file or MQ series, so need to rollback that also. Most probably you will get a negative sqlcode with new DB2 rollback. DB2 may not execute.

Thanks Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com [...] 2970 20 35_Authorization needed to use EXPLAIN15_Gilgian Schranz25_gilgian.schranz@DVBERN.CH30_Fri, 8 Oct 1999 10:46:43 -0700575_- Manual "DB2 for OS/390 Version 5 SQL Reference" says that the authorization rules for the EXPLAIN statement are those defined for the SQL statement specified in the EXPLAIN statement. For example, to EXPLAIN a DELETE statement, the authorization needed to execute the DELETE statement is necessary to explain it.

In our production environment we only have SELECT authority. We have no chance to get, and we don't really need, more rights. But we would like to use the EXPLAIN statement without the need to modify the SQL statements extracted from the programs. [...] 2991 87 67_Re: DB2connect : SQL10007N Message "-1092".... THANK YOU FOR HELP !14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT30_Fri, 8 Oct 1999 18:03:01 +0200652_iso-8859-1 THANK YOU VERY MUCH FOR HELP, VERY APPRECIATED !!!!!

> -----Messaggio originale----- > Da: leon@CA.IBM.COM [SMTP:leon@CA.IBM.COM] > Inviato: venerdì 8 ottobre 1999 0.41 > A: DB2-L@RYCI.COM > Oggetto: Re: DB2connect : SQL10007N Message "-1092" could not be > retrieved . R eason code: "4". > > Being a local administrator on an NT machine was a requirement on Db2 > Connect > pre-V6.1 systems. In v6.1 being a local administrator is no longer a > requirement > to catalog databases etc. > > Leon Katsnelson, DB2 Connect Development Manager > mailto:leon@ca.ibm.com > > > Philip Gunning on 10/07/99 01:10:10 [...] 3079 29 30_SYSCTRL granting itself SYSADM13_Chuck Hinchey22_chinchey@RJCONSULT.COM30_Fri, 8 Oct 1999 11:02:27 -0500389_iso-8859-1 I found this in the V5 Admin manual.

¦ SYSCTRL authority is intended for separation of ¦ ¦ function, not for added security. If any plans have ¦ ¦ their EXECUTE privilege granted to PUBLIC, an ID with ¦ ¦ SYSCTRL authority can grant itself SYSADM authority. The ¦ ¦ only control over such actions is to audit the activity ¦ ¦ of IDs with high levels of authority. ¦ [...] 3109 45 18_Re: Scripts in UDB10_Marc Baime23_mbaime1@TAMPABAY.RR.COM30_Fri, 8 Oct 1999 12:00:33 -0400483_iso-8859-1 Don,

Version 6.1 of the CAE can be downloaded from http://www.software.ibm.com/data/db2/db2tech/clientpak.html for free. In version 6.1 a show command button has been added to virtually every one of the Control Center Dialogues (e.g. Database Create Smartguide). This button allows you to view the SQL being generated by the smartguide or other dialogue and to save it as an ascii script if you desire. It's a great new feature and I have been using it a lot. [...] 3155 54 19_Re: Altering fields14_Grainger, Phil21_Phil.Grainger@CAI.COM30_Fri, 8 Oct 1999 17:12:43 +0100670_- Or of course there's also RC/Migrator, RC/Compare and RC/Update for OS390 as well as Enterprise DBA and Desktop DBA for non-mainframe platforms - all from Computer Associates.

I'm surprised Craig has forgotten to mention those!!

Phil Grainger Director DB2 Operations, Europe Computer Associates International

> -----Original Message----- > From: Mullins, Craig [SMTP:Craig_Mullins@BMC.COM] > Sent: Friday, October 08, 1999 4:49 PM > To: DB2-L@RYCI.COM > Subject: Re: Altering fields > > Mr. Kurtz: > > I was talking about DB2 UDB for OS/390 in my response regarding altering > columns. Although I believe it is applicable to DB2 UDB on other [...] 3210 125 41_LabTalk, Stored Procedure Builder, Oct 2014_Vivian Nalbone16_nalbone@HOME.COM30_Fri, 8 Oct 1999 09:03:32 -0700736_iso-8859-1 Next Lightyear Consulting LabTalk: October 20, 10am - 12 noon pacific Stored Procedure Builder presented by Connie Nelin of IBM Santa Teresa Laboratory.

800-289-0579 code 795218 to register. Presentation material, beginning October 12 at http://www.lightyr.com in the 'Downloads' section.

Stored Procedure Builder is an easy to use development environment for creating, installing and testing stored procedures. It allows you to focus on creating your stored procedure logic rather than the details of registering, building, and installing stored procedures on a DB2 server. It provides a single development environment which supports the entire DB2 family, ranging from workstations to System/390. Connie [...] 3336 15 36_Restoring from DB2 V2 to DB2 UDB 5.250_Karina Chong-Sing - Cesercomp(Jefe Dpto. Sistemas)26_kchong@GOLIAT.ESPOL.EDU.EC30_Fri, 8 Oct 1999 11:23:53 +0500136_US-ASCII Hi all,

Anybody knows which is the process to restore a DB2 V2 database into a DB2 UDB system?.

Karina Chong Sing 3352 49 12_Re: rollback10_Vikas Puri24_Vikas.Puri@METAMORGS.COM30_Fri, 8 Oct 1999 12:23:22 -0400579_us-ascii I am doing 'syncpoint rollback' if SQLcode is other than 0 while updating one DB2 table. Actually we are getting ASP3 abend at that syncpoint rollback. Program has lots of syncpoint so I thought if it can be replaced by rollback. Thanks vp At 11:52 AM 10/8/99 -0400, you wrote: >I have not tested, but rollback also should be two phase. Cics must be >handling other recoverable resource like VSAM file or MQ series, so need to >rollback that also. Most probably you will get a negative sqlcode with new >DB2 rollback. DB2 may not execute. > >Thanks >Sibimon Philip [...] 3402 81 39_Re: IBM Enterprise Storage Server (ESS)14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 8 Oct 1999 12:34:59 -0400619_ISO-8859-1 Message text written by DB2 Data Base Discussion List >I am curious if anyone if familiar with this new technology and could give their impression on the impact of ESS and the need for placing datasets to minimize hotspots and the impact on the need for reorganization.< +++++++++++++++++++++++++++++++++++++++ Based on the results so far, the ESS "may" remove the need to worry about where datasets are placed.... because the multiple address assignment for a volume allows more than one path to the device and thus the datasets - the eliminates IOQ time. So far test results have been quite positive, [...] 3484 40 12_ARCHIVE LOGS18_Padmanabham, Paddy27_PPadmanabham@IDAHOPOWER.COM30_Fri, 8 Oct 1999 10:44:40 -0600587_iso-8859-1 Hi All

I have a typical question bothering me.

We have the oldest imagecopy datasets copied on 99189(julian date) (July 8th 1999). We have the archive logs from 99189 onwards till today(99281). But the BSDS (as it can hold a maximum of 1000 archive log datasets) has the oldest archive log entry for 99229 (August 17th 1999).(The reason is we experience approximately 18 (average) archive log activities per day Which is absurd & we are trying to reduce them to 2 per day by increasing the size of ACTIVE log datasets. That's another issue I am working on) [...] 3525 34 34_Re: DBM1 asynch write buffer flush15_Jim Lewandowski22_jlewand@STARNETINC.COM30_Thu, 7 Oct 1999 20:39:41 -0500377_us-ascii sanjay jain wrote:

> Asynch I/O wait (read/write) are caused by delay at the channel/DASD level. > If it is a sizable percentage of your total elapsed time, you should sit > with DASD people and figure out a better dataset placement for db2 > tables/indexes.



So, where do we stand. How can an active thread wait on an asynchronous I/O when: [...] 3560 29 34_Re: DBM1 asynch write buffer flush15_Jim Lewandowski22_jlewand@STARNETINC.COM30_Thu, 7 Oct 1999 20:40:42 -0500546_us-ascii Any thoughts on this from anyone?

Jim Lewandowski

> When DBM1 takes a checkpoint and has to flush buffers, is there any > specific order to buffer flushing? Does DBM1 start at the lowest BP# > and go upwards? > > The reason for this is that I would like to put the "least > important" writes in a BP# that is taken care of last by DBM1 such that > the more important writes finish first. > > BTW, I had asked previously (months ago) about buffer LRU internals and > specifically wanted to know in what circumstances a [...] 3590 46 39_Re: Authorization needed to use EXPLAIN16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE30_Fri, 8 Oct 1999 18:31:34 +0100329_ISO-8859-1 Gilgian, I raised the same issue a couple on months ago on this list....Unfortunately that's just the way it is....You need the same DB2 authority to Explain a query as to Run a query....Bizarre....Maybe a friendly IBM developer will take it on board sometime??? Michael Mc Morrow. DBA Manager, AIB Bank, Dublin. [...] 3637 27 34_Re: DBM1 asynch write buffer flush20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 8 Oct 1999 13:43:37 -0400527_- > As DBM1 is flushing a modified > > buffer, is a thread allow a share lock on that page during (while in > > flight) the asynch write process? Or, does DBM1 place an exclusive lock > > during the write? > > > [Pillay, Venkat (PCA)]

Jim While DBM1 writes the pages, there is no impact on locks held on that page. Locks are maintained by IRLM. Here is an example -> Issue an update statement from SPUFI with AUTOCOMMIT NO and then wait for two checkpoints for the uncommitted page to be written to DASD (you could [...] 3665 63 16_Re: ARCHIVE LOGS10_Rick Davis22_richard.g.davis@DB.COM30_Fri, 8 Oct 1999 12:56:10 -0600337_us-ascii Paddy, My guess is that I don't think trying to use an older BSDS with the current active logs will work because the RBAs (LRSNs) won't match up with the current active log checkpoints. It looks to me that the best you can do is a TOCOPY recovery from the copy taken 99189. (Don't forget to rebuild any indexes.) HTH, Rick [...] 3729 82 39_Re: IBM Enterprise Storage Server (ESS)10_Rick Davis22_richard.g.davis@DB.COM30_Fri, 8 Oct 1999 13:22:55 -0600414_us-ascii Joel, I know you're one of the best on stuff like this so, humour me and let me ask some dumb questions. How do they do that? Doesn't eliminating IOQ imply a r/w head, or some such thing, for each address assignment per volume? Once the Nth address assignment is reached; what happens? How does this relate to number of channels per controller? Where can I find out more on this stuff? Regards, Rick [...] 3812 57 23_Fwd: DB2 with CICS EXCI0_14_DPetro@AOL.COM28_Fri, 8 Oct 1999 14:35:54 EDT424_us-ascii I'm reposting this in case it got lost in the cutover to the new Listserve. Any info would be appreciated.

Thanks. Dave.

Our development staff is investigating the use of the CICS/EXCI interface to call online modules from batch jobs. Does anyone have experience with this from the DB2 side? What things, if any, should we be looking for from a performance standpoint, locking, monitoring, etc.? [...] 3870 111 16_Re: ARCHIVE LOGS22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM30_Fri, 8 Oct 1999 15:02:38 -0400533_- Paddy -

>Or can I use DSNJU003 to register an archive log dataset dated 99191 into >the existing BSDS although the latest BSDS contains the oldest archive log >entry as taken on 99229? ( I think its not possible!!!)

Try it and let us know!

This might work. Does anyone know if the archive log date range MUST be continuous. For recoverability and integrity purposes it makes sense that the archive log date range (or more precisely - the RBA range) MUST be continuous but does DB2 enforce the continuity? [...] 3982 22 36_Alter table foreign key sqlcode -1040_18_jchimes@PARKER.COM30_Fri, 8 Oct 1999 15:54:21 -0400399_us-ascii I am trying to run the following DDL:

add foreign key (REGION_ID, TMR_LABEL) references POLICY_REGION (REGION_ID, TMR_LABEL) on delete cascade;

I get the following error:

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE .

The SQL Guide states that the constraint name is optional. Any ideas on what the problem is? TIA. 4005 34 40_Re: Alter table foreign key sqlcode -10413_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Fri, 8 Oct 1999 14:57:39 -0500449_US-ASCII TRY add foreign key (REGION_ID, TMR_LABEL) references POLICY_REGION on delete cascade; HTH Kurt

>>> 10/08/99 02:54PM >>> I am trying to run the following DDL:

add foreign key (REGION_ID, TMR_LABEL) references POLICY_REGION (REGION_ID, TMR_LABEL) on delete cascade;

I get the following error:

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "(". SOME SYMBOLS THAT MIGHT BE . [...] 4040 59 25_Re: DB2 SUBSYSTEM MONITOR14_Gregg Willhoit21_gwillhoit@NEONSYS.COM30_Fri, 8 Oct 1999 15:41:53 -0500550_us-ascii Gregg Willhoit@NEON 10/08/99 03:41 PM



Shadow Direct from NEON Systems (where I work) has a comprehensive performance monitor built-in for Client/Server and Web applications. This feature provides detailed tracing and diagnostic information on a per-session and per-SQL statement basis. Using this facility, all of the SQL, network I/O operations, buffers, etc. for one session and/or application can be easily isolated and analyzed as need be. Precise CPU time, Tiimeron, and clock time information is readily available. [...] 4100 58 16_Re: ARCHIVE LOGS12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 8 Oct 1999 15:42:00 -0400510_- There is a ZPARM, MAXARCH, which tells DB2 how many archives to keep in the BSDS. You can try to change this max to a higher number. Then Add, using DSNJU003, the Rest of the archive logs to the BSDS starting with the one you need. Make sure the RBAs are accurate. You can get that info from one of the BSDSs on the archive tapes. Don't know if/how syslgrnx falls into all of this. I would try this on a TEST DB2: Bring down the DB2 subsystem Copy the BSDS to another DSN Attempt to add the archives to [...] 4159 54 28_Re: Welcome to the RYCI site12_John Morrill12_johnm@VP.NET30_Fri, 8 Oct 1999 16:28:08 -0500469_iso-8859-1 Thomas

I have been going through all my e-mail about DB2-L. I assume that you are receiving your mail in digest form and you are happy now. Let me know if you have any other problems.

Cheers!

John

-----Original Message----- From: owner-db2-l@ryci.com [mailto:owner-db2-l@ryci.com]On Behalf Of Thomas Beyer Sent: Tuesday, September 28, 1999 11:05 AM To: Multiple recipients of list db2-l Subject: Re: Welcome to the RYCI site [...] 4214 64 22_Re: ROWID partitioning10_Ven Ilagan18_vilagan@ONE.NET.AU30_Fri, 8 Oct 1999 09:11:51 +1000305_iso-8859-1 First time I've encountered this terminology "NPI PARALLELISM" - is it true then that with using piecesize on an NPI resulting to say 10 datasets for the NPI, a non-matching index scan would invoke a degree of 10 as it acts on this index?

Can you clarify please Richard - thanks... [...] 4279 37 13_Indexes on RI14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Sat, 9 Oct 1999 10:44:01 +1000317_us-ascii Ruediger,

F.K. Indexes are used for R.I. checks on Delete of Parent row. If not available T.S. scan used.

Can drop F.K. index if not used and Parent row delete is not allowed. We drop them on large tables where parent is small reference table with very static rows (almost never deleted). [...] 4317 136 46_Re: inserts into DB2 OS390 with unique indexes14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Sat, 9 Oct 1999 10:44:19 +1000308_us-ascii Tim,

I can't agree with you here re overheads for Binary Search. I agree with Rick Creech. Type 2 duplicate indexes are fine because the RID is treated as an additional column that makes the index entry unique, but has advantages of not needing to restore the entire entry for each RID. [...] 4454 70 56_The Data Administration Newsletter (http://www.tdan.com)19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Fri, 8 Oct 1999 22:08:18 -0500484_iso-8859-1 Greetings!

All the list owner, I like to past on to you information about other sources of information that may be of interest to the DB2 community.

The Data Administration Newsletter (TDAN) is on such source. Enclosed is an announcement I received from TDAN

Cheers!

J. Michael Morrill DB2-L Chief List Owner

---------------------------------------------------------------------------------------------------- Dear TDAN.com Readers, [...] 4525 33 12_Re: rollback0_24_ssethi@LOT.TATASTEEL.COM30_Sat, 9 Oct 1999 11:24:02 +0530239_- If u use EXEC SQL ROLLBACK END EXEC instead of EXEC CICS SYNCPOINT ROLLBACK END EXEC then u will get sqlcode -926 as in case of commit u will get -925 and it means that it is not valid in IMS or CICS as ROLLBACK is also two phase . [...] 4559 40 40_SV: Restoring from DB2 V2 to DB2 UDB 5.225_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE30_Sat, 9 Oct 1999 14:30:15 +0200440_ISO-8859-1 Karina,

Simply run the restore database command using your V2 backup copy, the migration to V5 will be done on the fly. You might have problems with the migration depending on how big your logs where in the V2 database. If you encounter a -1704 rc 3 (migration failed, logs full) just go to the control center and make the logs for the resored db larger, then run the migrate database comand against the restored db. [...] 4600 70 60_Repost: DB2 UDB EEE for NT Rocks Intel Developers Conference19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:30 -0500757_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

At the Intel Development Conference (IDF) September 2, 1999, DB2 UDB EEE for NT was on stage with keynote speaker John Miner, Vice President and General Manager of the Communications Products Group, Intel Corporation. Included within his keynote address, "Server Technology Advancements for the Internet Economy", was a demonstration by [...] 4671 183 60_Repost: DB2 UDB EEE Scalability Demonstration on Sun Solaris19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:31 -0500688_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is a brief summary of a demonstration performed by Sun Microsystems and IBM in support of a large data warehouse proposal. The results are excellent, showing excellent scalability for the query workload with database size ranging from 100 GB to 1 TB (raw data). [...] 4855 83 59_Repost: Check Out the New Issue of DB2 Magazine (Fall 1999)19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:34 -0500536_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

The new issue of DB2 Magazine, focusing on e-business as well as the usual fine core DB2 content, is now available. [...] 4939 116 57_Repost: New Book: The Essential Guide to Data Warehousing19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:34 -0500594_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Lou Agosta, industry analyst at Giga Information Group, has recently published a new book on data warehousing and knowledge engineering. Below is an abstract about the book. [...] 5056 106 121_Repost: DOWNLOAD: Complimentary Copy of DB2 UDB V6.1 Personal Developer's Edition; or Request a DB2 UDB Evaluation CD-ROM19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:35 -0500524_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

REMINDER, you can:

o download a complimentary copy of DB2 UDB V6.1 Personal Developer's Edition, [...] 5163 242 109_Repost: Press Release: IBM FORTIFIES BUSINESS INTELLIGENCE INITIATIVES WITH ENHANCED DATA MANAGEMENT SOFTWARE19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:38 -0500747_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

IBM this week launched a new company-wide campaign for the fast growing business intelligence market. The solutions encompass software, servers, consulting/services, and applications. Please see http://www-3.ibm.com/solutions/businessintelligence/ for details of these announcements and more information on IBM's BI portfolio. [...] 5406 85 81_Repost: Redbook Announcement: SG24-5462-00 Storage Management with DB2 for OS/39019_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:39 -0500707_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

The new IBM Redbook, "Storage Management with DB2 for OS/390" (SG24-5462-00, ISBN Number 0738414204) can now be downloaded as a PDF file from http://www.redbooks.ibm.com/abstracts/sg245462.html. (You can order hardcopy four to six weeks following the publish date of September 21, 1999. [...] 5492 104 70_Repost: "Hands on Databases - Room to Manoeuvre" (PC World, UK 9/1/99)19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:07:39 -0500607_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is a brief article about DB2 Universal Database Satellite Edition and DB2 Everywhere, "Hands on Databases - Room to Manoeuvre" by Mark Whitehorn (published in PC World, UK 9/1/99). [...] 5597 144 96_Repost: Download OR Order CD-ROM Complimentary Copy of DB2 UDB V6.1 Personal Developer's Edition19_J. Michael Morrilll21_xavier@NETEXPRESS.NET30_Sat, 9 Oct 1999 14:08:48 -0500553_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

As a follow-up to my note to you (below) regarding the complimentary copy of DB2 UDB Personal Developer Edition V6.1 via download... [...] 5742 29 43_How to reset the tablespace state to normal0_22_linlibin@MAIL.DCAC.COM31_Sun, 10 Oct 1999 18:49:00 +0800574_us-ascii Hi,dear DB2 experts! I feel some shy as a listner so long and didnot put in my two cents once,In any case i appreciate you all these experts' speakings cause i benifit it much. I have a tough problem for you help to resove.it come as this:i use db2 v5.0 on NT platform,but,somebody changed one talbe's state to share,so cause the tablespace's state which the tabe resides abnormally (share), and i dont know who lacked which table! even all users have been reconnected once at least! So, how to find which table has been lacked,and how to reset the tablesapce [...] 5772 102 18_Re: -805 REXX code10_Klaas Punt14_punt@XS4ALL.NL30_Sat, 9 Oct 1999 11:01:07 +0100697_- Op 27-sep-99 schreef Eric Pearson:

>Please stop sending me email >or I will complain to your ISP. >eric pearson >ericp@mindspring.com

>At 08:17 PM 9/26/99 -0400, you wrote: >>Please remove me from this list. >> >>Thank you! >> >> >>-----Original Message----- >>From:Shaun Z Lombard [SMTP:Shaun.Z.Lombard@transport.qld.gov.au] >>Sent:Sunday, September 26, 1999 7:56 PM >>To:Multiple recipients of list DB2-l >>Subject:Re: -805 REXX code >> >> >> >>Hi John, >> >>Thanks for posting this code. I converted it to a batch proccess >>which will >>identify which package versions are invalid (contoken not found in >>loadlib). The >>program would then generate a FREE Package to get [...] 5875 87 18_Re: -805 REXX code10_Klaas Punt14_punt@XS4ALL.NL30_Sat, 9 Oct 1999 11:00:50 +0100617_- Op 27-sep-99 schreef Eric Pearson:

>Please stop sending me email >or I will complain to your ISP. >eric pearson >ericp@mindspring.com >At 09:56 AM 9/27/99 +1000, you wrote: >> >> >>Hi John, >> >>Thanks for posting this code. I converted it to a batch proccess which will >>identify which package versions are invalid (contoken not found in >loadlib). The >>program would then generate a FREE Package to get rid of the invalid >versions. >> >>Thanks again. >> >>Shaun >> >>PS. Lets hope the South Africans can retain the Rugby World Cup this year. >> >> >> >> >>pak02449@PIXIE.CO.ZA on 26/09/99 03:17:05 [...] 5963 84 18_Re: -805 REXX code10_Klaas Punt14_punt@XS4ALL.NL30_Sat, 9 Oct 1999 11:00:38 +0100657_- Op 27-sep-99 schreef Eric Pearson:

>@MOE.EDU.TW >At 09:56 AM 9/27/99 +1000, you wrote: >> >> >>Hi John, >> >>Thanks for posting this code. I converted it to a batch proccess which will >>identify which package versions are invalid (contoken not found in >loadlib). The >>program would then generate a FREE Package to get rid of the invalid >versions. >> >>Thanks again. >> >>Shaun >> >>PS. Lets hope the South Africans can retain the Rugby World Cup this year. >> >> >> >> >>pak02449@PIXIE.CO.ZA on 26/09/99 03:17:05 >> >>Please respond to DB2 Data Base Discussion List >> >>To: DB2-L@LISTSERV.AMERICAN.EDU >>cc: [...] 6048 46 44_DB2 Symposium London, Frankfurt and New York11_Klaas Brant22_KBrant@XANADU.DEMON.NL31_Sun, 10 Oct 1999 21:32:43 +0200578_iso-8859-1 Dear DB2 Professional,

Do you want to extend your DB2 knowledge? Do you want to know everything about Performance, Data Warehousing, SQL, Version 6, Recovery, Data Sharing, Internals or retrofitted PTF’s? Tired of these one-hour sessions that do not cover enough important details? What you need is the DB2-Symposium! Get educated on a topic with our full day in-depth training on hot topics. And you can assemble your own seminar: one or multiple days. Pay for only the sessions you want to attend providing you quality education at an affordable price. [...] 6095 43 65_Needed!! Any advice on how to organize daily tasks as a New DBA??16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Sun, 10 Oct 1999 18:03:34 EDT431_- Greetings to all,

I am a new DB2 DBA and will like to organize my daily activities/task as efficiently and productively as I can. Bear with me everyone if the following questions are simple. My questions to you seasoned practitoners are:

1. What should a DBA do as she settles in for the work day to ascertain the health of her DB2 systems? What are the things you startoff with after the first cup of coffe?? [...] 6139 71 69_Re: Needed!! Any advice on how to organize daily tasks as a New DBA??10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Sun, 10 Oct 1999 15:32:30 -0700533_us-ascii >At 06:03 PM 10/10/99 -0400, you wrote: >Greetings to all, > >I am a new DB2 DBA and will like to organize my daily activities/task >as efficiently and productively as I can. Bear with me everyone if the >following questions are simple. My questions to you seasoned practitoners >are: > > 1. What should a DBA do as she settles in for the work day to > ascertain the health of her DB2 systems? What are the > things you startoff with after the first cup of coffe?? > > 2. Tools available to me in the management of DB2 [...] 6211 82 62_Re: Tracking Resource Limit Facility activity - DB2 for OS/39015_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Mon, 11 Oct 1999 09:59:07 +1000445_us-ascii Sue,

I have the same problem, the best I could come up with was to define an exception definition based on amount of CPU. Example below. This one should tell you when a thread running plan DISTSERV reaches 2 CPU seconds(our limit).

HOW LIMIT DET HOW LIMIT WAS DETERMINED DRXAPREC GT 0 COUNT 9(9) THREAD CPU TIM THREAD CPU TIME DRASCTIM GT 00:00:02.0000 HH:MM:SS.TTTT PLAN NAME PLAN NAME DRHCPLAN EQ DISTSERV CHAR(08) [...] 6294 66 35_Re: DB2 v5 mvs to oracle AIX rs600014_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 11 Oct 1999 10:14:21 +1000451_us-ascii Hi Neil,

We use FTP for a similar process. If you are worried about integrity, write a little CRC generator. Run it on the MVS side, FTP the CRC value to the unix side (this also make a conveient "all the data has been sent" indicactor if needed) and rerun the CRC (of course, you'll have to take the EBCDIC to ASCII conversion into account) on the unix side and compare it to the MVS CRC check. If they match, good; if not, not. [...] 6361 66 16_Re: DSNU406I !!!14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 11 Oct 1999 10:25:43 +1000628_us-ascii Giuseppe

What does the following SQL reveal:

SELECT * FROM SYSIBM.SYSCOPY WHERE DBNAME = 'DBxxxx' AND TSNAME = 'TSxxxxxx' AND ICTYPE = 'F' AND ICBACKUP='RP' ?

If it does produce some rows, you might want to run a MODIFY RECOVERY to delete the rows. You won't, then, get this message.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Tooronga +61 3 9261 1802 james.campbell@energyis.com.au -----Original Message----- From: Giuseppe_Di_Donna@CARTASI.IT [mailto:Giuseppe_Di_Donna@CARTASI.IT] Sent: Friday, October 08, 1999 10:25 PM To: DB2-L@RYCI.COM Subject: DSNU406I !!! [...] 6428 45 47_Re: How to reset the tablespace state to normal14_CLAUDIO MARCOS23_cmarcos@POWERNET.COM.AR31_Sun, 10 Oct 1999 20:31:22 -0300682_iso-8859-1 Please, unsuscribe me of your list.

-----Mensaje original----- De: linlibin@MAIL.DCAC.COM Grupos de noticias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Fecha: domingo 10 de octubre de 1999 7:57 Asunto: How to reset the tablespace state to normal



>Hi,dear DB2 experts! > I feel some shy as a listner so long and didnot put in my two cents >once,In any case i appreciate you all these experts' speakings cause i >benifit it much. > I have a tough problem for you help to resove.it come as this:i use db2 >v5.0 on NT platform,but,somebody changed one talbe's state to share,so >cause the tablespace's state [...] 6474 60 69_Re: Needed!! Any advice on how to organize daily tasks as a New DBA??14_CLAUDIO MARCOS23_cmarcos@POWERNET.COM.AR31_Sun, 10 Oct 1999 20:32:41 -0300648_iso-8859-1 Please unsuscribe me of your list

-----Mensaje original----- De: Christine Sawyer Grupos de noticias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Fecha: domingo 10 de octubre de 1999 19:13 Asunto: Needed!! Any advice on how to organize daily tasks as a New DBA??



>Greetings to all, > >I am a new DB2 DBA and will like to organize my daily activities/task >as efficiently and productively as I can. Bear with me everyone if the >following questions are simple. My questions to you seasoned practitoners >are: > > 1. What should a DBA do as she settles in for the work day to [...] 6535 88 69_Re: Needed!! Any advice on how to organize daily tasks as a New DBA??14_CLAUDIO MARCOS23_cmarcos@POWERNET.COM.AR31_Sun, 10 Oct 1999 20:32:55 -0300667_iso-8859-1 Please unsuscribe me of your list

-----Mensaje original----- De: Bill Welch Grupos de noticias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Fecha: domingo 10 de octubre de 1999 19:33 Asunto: Re: Needed!! Any advice on how to organize daily tasks as a New DBA??



>>At 06:03 PM 10/10/99 -0400, you wrote: >>Greetings to all, >> >>I am a new DB2 DBA and will like to organize my daily activities/task >>as efficiently and productively as I can. Bear with me everyone if the >>following questions are simple. My questions to you seasoned practitoners >>are: >> >> 1. What should a DBA do as [...] 6624 116 18_Re: -805 REXX code14_CLAUDIO MARCOS23_cmarcos@POWERNET.COM.AR31_Sun, 10 Oct 1999 20:31:50 -0300764_iso-8859-1 Please unsuscribe me of your list -----Mensaje original----- De: Klaas Punt Grupos de noticias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Fecha: domingo 10 de octubre de 1999 9:04 Asunto: Re: -805 REXX code



>Op 27-sep-99 schreef Eric Pearson: > >>Please stop sending me email >>or I will complain to your ISP. >>eric pearson >>ericp@mindspring.com > >>At 08:17 PM 9/26/99 -0400, you wrote: >>>Please remove me from this list. >>> >>>Thank you! >>> >>> >>>-----Original Message----- >>>From:Shaun Z Lombard [SMTP:Shaun.Z.Lombard@transport.qld.gov.au] >>>Sent:Sunday, September 26, 1999 7:56 PM >>>To:Multiple recipients of list DB2-l >>>Subject:Re: -805 REXX code >>> >>> >>> >>>Hi John, >>> >>>Thanks [...] 6741 136 35_Re: Output from the TSO DSN Command12_Ran Abeykoon23_Ran_Abeykoon@AMP.COM.AU31_Mon, 11 Oct 1999 10:36:48 +1000579_iso-8859-1 Jim, Yes,you're right. CAF writes diagnostic trace messages if you allocate a DSNTRACE data set either dynamically or by including a //DSNTRACE DD statement in your JCL, FYI, following is more details from the IBM Manuals regarding the use of the TEST parameter.

TEST(integer) integer specifies the last two digits of the module name in order to trace a single DSN module. Specify a number greater than 100 to trace all DSN modules. DSN trace information messages are written to the TSO SYSTSPRT DD statement, and optionally, to the DSNTRACE DD statement. [...] 6878 28 69_Re: Needed!! Any advice on how to organize daily tasks as a New DBA??10_Davis Morr20_gliebert@ATRAXIS.COM31_Mon, 11 Oct 1999 07:46:57 +0200519_us-ascii Please unsuscribe me of your list



Kind Regards

Gaby Liebert

_____________________________________________

Atraxis AG Customer Help Desk

Phone: 41 1 812 4474 Telefax: 41 1 812 9898 Telex: ZRHXUSR E-Mail: gliebert@sairgroup.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. 6907 13 69_Re: Needed!! Any advice on how to organize daily tasks as a New DBA??10_Davis Morr20_gliebert@ATRAXIS.COM31_Mon, 11 Oct 1999 07:59:21 +0200284_us-ascii Please unsuscribe me of your list

================================================ 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. 6921 36 13_Unsuscribe me19_Krishnalatha Parcha20_klatha@WIPHYD.GE.COM31_Mon, 11 Oct 1999 11:41:53 +053081_ISO-8859-1 Please unsuscribe me of your list



Regards Latha

6958 183 24_Migration Step 3 Queries13_Kallia Dimoka24_dimokap@INTERAMERICAN.GR31_Mon, 11 Oct 1999 10:43:05 +0300572_iso-8859-7 Hello List, we are in the process of migrating from DB2 for OS/390 V4 to V5 .In migration step 3, there is a number of queries to be run in order to check catalog tables consistency.These queries are included in member DSNTESQ from SDSNSAMP library. The following query returns a significant number of rows, but i think that the results are expected and normal, mainly because a certain package may be contained in more than one collids. I would like to know if i should take the non-zero result of this query under consideration, or if i could bypass it. [...] 7142 74 16_Re: ARCHIVE LOGS22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 11 Oct 1999 08:14:41 +0100273_ISO-8859-1 Paddy from what you describe I would say you are stuck in a catch 22 .. cannot add the archive logs with JU03 becuase you need the latest defined .. cannot get rid of an arch log as you may need them ...

I would say to recover to copy you need to .. [...] 7217 81 16_Re: ARCHIVE LOGS14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 11 Oct 1999 18:49:18 +1000429_us-ascii Paddy,

One option, out of left field:

I don't ___think___ that there is any particular information in the log that identifies the log dataset. So, you could concatenate several archive log datasets into one big dataset, recording the begining and end RBA of the little archive that went into the big dataset. Then edit the BSDS to replace the little (al-be-them real) archives with your big archives. [...] 7299 25 16_Re: ARCHIVE LOGS10_Davis Morr20_gliebert@ATRAXIS.COM31_Mon, 11 Oct 1999 10:57:35 +0200521_us-ascii I don't want your damn mails. Keep them to yourself....



Gaby Liebert

_____________________________________________

Atraxis AG Customer Help Desk

Phone: 41 1 812 4474 Telefax: 41 1 812 9898 Telex: ZRHXUSR E-Mail: gliebert@sairgroup.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. 7325 80 28_Re: Migration Step 3 Queries14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Mon, 11 Oct 1999 18:57:35 +1000362_us-ascii Kallia,

If what you say is true, then

SELECT NAME FROM SYSIBM.SYSPACKAGE PK WHERE SYSENTRIES ^= 0 AND SYSENTRIES ^= (SELECT COUNT(*) FROM SYSIBM.SYSPKSYSTEM PS WHERE PK.NAME = PS.NAME AND PK.COLLID = PS.COLLID AND PK.CONTOKEN = PS.CONTOKEN );

should return zero rows. If this doesn't return zero rows, then you have a problem. [...] 7406 26 28_Re: Migration Step 3 Queries10_Davis Morr20_gliebert@ATRAXIS.COM31_Mon, 11 Oct 1999 11:02:40 +0200506_us-ascii I don't want your damn mails

Kind Regards

Gaby Liebert

_____________________________________________

Atraxis AG Customer Help Desk

Phone: 41 1 812 4474 Telefax: 41 1 812 9898 Telex: ZRHXUSR E-Mail: gliebert@sairgroup.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. 7433 92 70_Re: Needed!! Any advice on how to organize daily tasks as a New D BA??13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 11 Oct 1999 11:37:37 +0100607_iso-8859-1 Hi,

At a risk of sounding like a broken record... "it depends!" In a previous incarnation, I used to run SQL to display tablespaces without image copies taken in the last week (insert i/c frequency here). I also use to run (weekly) a REPAIR DBD TEST DATABASE on each database I administered to check that the OBIDs were consistent. (This certainly saved my skin on one occasion.) If you're a development DBA, you could craft SQL to pick out violations of naming standards. I would also recommend Bill's suggestion of running post-RUNSTATS Health check SQL. If you have authority, run [...] 7526 24 15_ERwin vs Popkin18_Ray.Turpen@WOODMEN19_rturpen@WOODMEN.COM29_Mon, 11 Oct 1999 09:12:02 EDT348_US-ASCII We are a DB2 V5.1 OS/390 shop getting ready to look at data modeling software for a data warehouse application. We have been told ERwin is the industry leader when it comes to data modeling with DB2 on the mainframe. Does anyone have any feedback on Popkin System Architect 2001 or any other good DB2 data modeling software packages? [...] 7551 176 46_Re: inserts into DB2 OS390 with unique indexes16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Mon, 11 Oct 1999 06:36:30 -0700378_iso-8859-1 As I understand the original question, the secondary index contains unique values whether it is defined as UNIQUE or not. The question is whether there is extra overhead in defining it as UNIQUE, as DB2 would have to do extra processing to ensure the uniqueness when doing an INSERT. The index would contain the same columns and the same cardinality either way. [...] 7728 21 25_Oggetto: Re: DSNU406I !!!0_28_Giuseppe_Di_Donna@CARTASI.IT31_Mon, 11 Oct 1999 15:39:22 +0200348_us-ascii During a diagnosis of the problem ,we obviusly have a row in the syscopy wich means that we took a "RECOVERYDDN copy " doing a OnlineREORG.... (shrlevel change) but the problem is that not everytime i'm obtaining the warning doing a simple fullimagecopy only at the local site...

i'm losting something...anyway thenks James... [...] 7750 16 24_Re: reason = X'00E40311'0_35_john_lawniczak@STANDARDANDPOORS.COM31_Mon, 11 Oct 1999 09:59:18 -0400478_us-ascii Has anyone gotten an X'00E40311' while running runstats on the system catalog ? TIA, John

SYSINDEXPART CATALOG UPDATE FOR SYSIBM.DSNDSX01 SUCCESSFUL UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40311'

================================================ 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. 7767 46 19_Re: ERwin vs Popkin16_Raffi Garabedian22_hirondel@IX.NETCOM.COM31_Mon, 11 Oct 1999 09:06:57 -0500708_us-ascii I know of two other DB2 data modeling tools from:

1. www.embarcadero.com 2. Bachman/Cayenne/Business Team/ from Sterling Software

Alongside ERwin and Popkin products.

Shop around and compare price/performance/etc...

Enjoy the search.

Raffi Garabedian 913.851.3281







"Ray.Turpen@WOODMEN" wrote:

> We are a DB2 V5.1 OS/390 shop getting ready to look at > data modeling software for a data warehouse application. > We have been told ERwin is the industry leader when it > comes to data modeling with DB2 on the mainframe. > Does anyone have any feedback on Popkin System > Architect 2001 or any other good DB2 data modeling > [...] 7814 26 41_Debugging Stored Procedures with Xpediter0_39_robert.j.hartmann@US.ARTHURANDERSEN.COM31_Mon, 11 Oct 1999 09:45:42 -0600691_us-ascii I have seen that the Xpediter folks state that they can work with Stored Procedures in a unit testing environment. Has anyone tested this out? What are the limitations? Are there any special links, coding...?

*******************Internet Email Confidentiality Footer*******************



Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your [...] 7841 53 45_Re: Debugging Stored Procedures with Xpediter0_20_ddlusk@HOUSEHOLD.COM31_Mon, 11 Oct 1999 09:59:22 -0500694_us-ascii sure... you need to compile the stored procedure within xpediter for it's listing and have the proper libraries in your setup...









robert.j.hartmann@US.ARTHURANDERSEN.COM 10/11/99 10:45 AM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM cc: (bcc: Derez D. Lusk/Household International) Subject: Debugging Stored Procedures with Xpediter





I have seen that the Xpediter folks state that they can work with Stored Procedures in a unit testing environment. Has anyone tested this out? What are the limitations? Are there any special links, coding...? [...] 7895 52 45_Re: Debugging Stored Procedures with Xpediter20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 11 Oct 1999 11:06:54 -0400714_- Do you mean ORACLE STORED PROCEDURE ?? I have heard of XPEDITER/SQL for ORACLE .

Is there any for DB2 STORED PROCEDURE debugger other than CODE/370 ?

> -----Original Message----- > From: robert.j.hartmann@US.ARTHURANDERSEN.COM > [SMTP:robert.j.hartmann@US.ARTHURANDERSEN.COM] > Sent: Monday, October 11, 1999 11:46 AM > To: DB2-L@RYCI.COM > Subject: Debugging Stored Procedures with Xpediter > > I have seen that the Xpediter folks state that they can work with Stored > Procedures in a unit testing environment. Has anyone tested this out? > What are > the limitations? Are there any special links, coding...? > > *******************Internet Email Confidentiality > Footer******************* [...] 7948 80 70_Re: Needed!! Any advice on how to organize daily tasks as a New D BA??14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 11 Oct 1999 10:11:27 -0500609_iso-8859-1 Christine:

My suggestion to you would be to automate as many of the routine tasks as you possibly can given the tools at your disposal. If you can set up your environment to determine what is good and what is bad and to alert you when the "bad" happens: e.g. reorg needed, potential out of space situation, nearing bufferpool threshold, etc. etc. That way you will be informed when the problem happens and can respond accordingly. You can automate using vendor tools, Rexx, or whatever scripting/programming tools you have at your disposal. Even a minimal amount of automation can save [...] 8029 79 45_Re: Debugging Stored Procedures with Xpediter0_19_Tim.Lowe@STPAUL.COM31_Mon, 11 Oct 1999 10:12:58 -0500499_us-ascii Robert, We talked to people from Xpediter for the past few years about supporting DB2 stored procedures. They have recently told us that they are going to work on it. When last I heard, they told us that we should test them by calling them like subroutines, taking out any unique "stored procedure" code. (perhaps they consider this to be "unit testing"?) I do not consider this to be support for DB2 stored procedures, but perhaps they have added some new support? I hope this helps. [...] 8109 57 25_multiple language support14_Michael Rooney22_MRooney@COMPUSERVE.COM31_Mon, 11 Oct 1999 12:38:23 -0400495_ISO-8859-1 Where looking to expand our business internationally. Currently we have one Production DB2 and one test DB2 subsystem (V5) on OS/390 V2.6 and our business if focused in the USA (English support only).

Were looking to replicate some of our existing programs to use new tables that will be loaded in Spanish. The New programs will be recompiled and translated to Spanish. The Application is CICS based. Another Spanish CICS region will be created to support the application [...] 8167 39 10_Unsubcribe14_Steve Shreeves30_steve@SHREEVES.FREESERVE.CO.UK31_Mon, 11 Oct 1999 18:36:12 +010033_iso-8859-1 Please unsubscribe me. 8207 52 36_Re: JDBC connect to OS/390 subsystem18_COLLINS, BUFF (PB)23_EACOLLI@MSG.PACBELL.COM31_Mon, 11 Oct 1999 10:44:13 -0700504_iso-8859-1 Hello. I believe all you need to do is change the DB2SQLJSSID=ssid in your JDBC properties file. This is assuming you have bound the JDBC packages and plans on the other DB2 you are trying to select from.





Buff Collins - DB2 System Support Pacific Bell - EACOLLI@.PACBELL.COM



-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: Thursday, October 07, 1999 12:33 PM To: DB2-L@RYCI.COM Subject: JDBC connect to OS/390 subsystem [...] 8260 17 27_Delete volume from STOGROUP16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Mon, 11 Oct 1999 16:15:00 -0700510_- My understanding of DB2(V4) use of STOGROUP volumes is that if I add a volume to a STOGROUP and then take an extent on that second volume, then DB2 will not attempt to add further extents on the 1st volume. My question is, if I remove the second volume from the STOGROUP and freeup space on the 1st volume, will DB2 then use the 1st volume for secondary extents? Also, if the second volume is removed from STOGROUP and space made available on 1st volume, will DB2 be able to use 1st volume for a REORG? [...] 8278 210 46_Re: inserts into DB2 OS390 with unique indexes14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 12 Oct 1999 10:25:19 +1000399_us-ascii Tony & others,

I apologise for addressing someone else's comment (Time Lowe's) and not the original question. I came in late on the discussion.

There is a slight length disadvantage in defining an index as NOT UNIQUE when it is actually UNIQUE, so I always define the index as unique if it is guaranteed to be unique due to includes all columns in primary or unique key. [...] 8489 224 46_Re: inserts into DB2 OS390 with unique indexes16_Richard A Yevich15_ryevich@IBM.NET31_Mon, 11 Oct 1999 20:29:43 -0400394_iso-8859-1 First: A simple comment. No one would write code that added that kind of overhead. When an insert occurs, it probes based on value. If UNIQUE and value matched, forget it, no insert. If NON-UNIQUE and valued matched, INSERT it. So where is this additional code? There is none.

Second: If an index is truly UNIQUE, and if DB2 can determine it, it is marked UNIQUE anyway. [...] 8714 13 15_DB2_PARALLEL_IO12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 11 Oct 1999 21:04:23 -0500385_iso-8859-1 Anyone know where the DB2_PARALLEL_IO parm should be set on AIX? Is it set in everyone's profile or just the instance profile, OR ??

================================================ 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. 8728 38 34_00C9008E (timeout!) on 304(TS RID)0_28_Giuseppe_Di_Donna@CARTASI.IT31_Tue, 12 Oct 1999 10:27:13 +0200553_us-ascii A single batch is often involved in timeout on a Ts rid ,it seems with itself generating two thread........ lock escalation ? It's a cobol II ,not PLI !.

any suggestion will be a nice gift !!.



DSNT376I +DS1P PLAN=GSPL0001 WITH CORRELATION-ID=GGS00120 CONNECTION-ID=BATCH LUW-ID=DB2P.LUDB2PR.B2FB63B87B86=12795 THREAD-INFO=PROD:*:*:* IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=GSPL0001 WITH CORRELATION-ID=GGS00120 CONNECTION-ID=BATCH LUW-ID=DB2P.LUDB2PR.B2FB63B87B86=12783 THREAD-INFO=PROD:*:*:* ON MEMBER DS1P [...] 8767 49 16_Sort Pool sizing20_Christoph Sassenrath36_christoph.sassenrath@D2MANNESMANN.DE31_Tue, 12 Oct 1999 09:26:42 +0100309_us-ascii Dear experts,

I found different formulas for sort pool sizing:

1) RED Book: DB2 V3 Performance Topics: 16.0000 (16 + sort key length + sort data lenght) * n 2) DB2 for MVS/ESA V4 Administration Guide: 16.000 * (12 + sort key length + sort data length + 4) (if using hardware sort) [...] 8817 13 43_Antwort: 00C9008E (timeout!) on 304(TS RID)0_23_duerr_jacobsg@WESTLB.DE31_Tue, 12 Oct 1999 10:58:47 +0100332_us-ascii maybe the mainprogram calls an assembler subroutine, which generates two threads?

================================================ 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. 8831 80 15_REPAIR DBD TEST13_Kallia Dimoka24_dimokap@INTERAMERICAN.GR31_Tue, 12 Oct 1999 12:03:29 +0300544_iso-8859-7 Hello List, i read a message yesterday by Marcus Davage,concerning the tasks a DBA has to deal with . One of them is to run a REPAIR TEST DBD Utility against the databases.As i had never used that mode of REPAIR utility, i tried it out and found out that there were errors in my most important production database! I also ran a REPAIR DBD DIAGNOSE afterwards. I would like to know what actions i have to undertake in order to fix the problems and the extension at which i should be worried about my skin because of them.....!!! [...] 8912 71 19_Re: REPAIR DBD TEST13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 12 Oct 1999 10:59:50 +0100483_iso-8859-7 Kallia,

I have had no problem in correcting DBD errors. Just follow the following steps:



1. Image copy your catalog and directory 2. Run REPAIR DBD REBUILD for each of your databases in error 3.

Image copy your catalog and directory

Does anyone disagree? Regards, Marcus

-----Original Message----- From: Kallia Dimoka [mailto:dimokap@INTERAMERICAN.GR] Sent: 12 October 1999 10:03 To: DB2-L@RYCI.COM Subject: REPAIR DBD TEST [...] 8984 135 19_Re: REPAIR DBD TEST22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 12 Oct 1999 11:25:27 +0100572_ISO-8859-1 Kallia

this is what I would do ...

regards

Leslie DB2 OS390 / SAP DB2 UDB Certified DBA



______________________________ Reply Separator _________________________________ Subject: Re: REPAIR DBD TEST Author: Marcus Davage at Internet Date: 10/12/99 10:59 AM



Kallia,

I have had no problem in correcting DBD errors. Just follow the following steps:



1. Image copy your catalog and directory 2. Run REPAIR DBD REBUILD for each of your databases in error 3. [...] 9120 42 19_Re: DB2_PARALLEL_IO16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Tue, 12 Oct 1999 07:28:19 -0400447_us-ascii Paul,

The DB2_PARALLEL_IO parm is a DB2 registry variable that you set with the db2set command. To set it at the instance level, simply enter the following: db2set -i DB2_PARALLEL_IO=ON. To se all registry variables, enter: db2set -all.

-Mike.









"Martin, Paul" on 10/11/99 10:04:23 PM

Please respond to DB2 Data Base Discussion List [...] 9163 71 19_Re: DB2_PARALLEL_IO12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Tue, 12 Oct 1999 06:56:55 -0500340_iso-8859-1 OK, thanks Mike. One more question: We were getting the following message (a ton of them) on the DB2DIAG.LOG - will they go away once we get the new database created with db2set -i DB2_PARALLEL_IO=ON?

Here is the message on the db2diag.log String Title:SMP OPT PID:54330 Node:000 SS not SMP-parallelized. Reason 180. [...] 9235 103 19_Re: DB2_PARALLEL_IO16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Tue, 12 Oct 1999 08:12:52 -0400536_us-ascii Paul,

The -i specifies that every database in the instance will use parallel IO. The message in your db2diag.log looks like a CPU not IO parallelism message. I'm not sure why this is occurring. One question might be, did you create this database via a redirected restore from another machine of different configuration? If so, you will need to set the database manager configuration parm CPUSPEED to -1. Then stop and start DB2. This will cause DB2 to recalculate the processor(s) available to it. Hope this helps, [...] 9339 25 25_Date calculation question10_Robert Ord21_robertord@HOTMAIL.COM29_Tue, 12 Oct 1999 05:40:39 PDT438_- Forgive my laziness, but has anyone got a piece of sql which produces ISO week and period numbers from a DB2 date field ?

I had some horrendous sql from years back which I have lost. I was going to convert/simplify it with the new date calculation features.



Regards

Robert Ord



______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com [...] 9365 19 16_Is list working?14_Rob Cottensway17_db2whiz@YAHOO.COM31_Tue, 12 Oct 1999 06:05:24 -0700430_us-ascii Testing to see if list is working?



=====

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9385 32 34_Does anyone know of any Positions?14_Rob Cottensway17_db2whiz@YAHOO.COM31_Tue, 12 Oct 1999 06:08:59 -0700357_us-ascii Hello everyone!

I am a Production Support Analyst and am looking for a new assignment with a large, stable company. I am searching for a long term, permanent position. I prefer an environment that has strong emphasis on using DB2....Does anyone have any suggestions as to where I should look? I am located in the Washington Metro area. [...] 9418 65 38_Re: 00C9008E (timeout!) on 304(TS RID)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 12 Oct 1999 09:33:31 -0400290_- 1. It is row level locking. 2. (Timing out with itself !!!), I have seen this earlier. We migrated from V3 to V4 and this problem started appearing. If you see the lock detailes thru traces then you will find that this just REPORTING BUG. The real agent involved was something else. [...] 9484 90 22_Re: ROWID partitioning16_Richard A Yevich15_ryevich@IBM.NET31_Tue, 12 Oct 1999 09:59:26 -0400445_iso-8859-1 The full answer would take too long, but PIECESIZE provides parallelism in many ways. Each PIECE is a different file, not an extent, so in effect it is similar to the partitioning index. Biggest boost is to increase concurrency. Also another super feature is that when a page range scan can be determined by the key ranges, DB2 can use the NPI as the access path into the non-contiguous pieces, and can do this in parallel also. [...] 9575 65 19_Dynamic SQL Caching12_Michael Ryle17_mryle@TSISOFT.COM31_Tue, 12 Oct 1999 09:53:51 -0400561_iso-8859-1 One of the features of the software product my company markets for OS390 allows our users to process DB2 SQL statements dynamically through our product in MVS and CICS. We accomplish this more or less in the standard way, i.e., by doing a PREPARE followed by a DESCRIBE INTO a sqlda followed by an EXECUTE, etc. We would like to be able to take advantage of the dynamic SQL caching feature introduced in DB2 V5 but don't know how to determine whether dynamic SQL caching is in effect for a particular DB2 subsystem. Does anyone know of a way to [...] 9641 47 25_Updating using substring?12_thomas otway16_otwayc@TENET.EDU31_Tue, 12 Oct 1999 09:07:43 -0500293_iso-8859-1 The programmers at our shop would like to use " set substr(lastname,1,5)='xxxxx' " to update. I know that in 4.1 this is not possible and it looks the same in 5. Do any of the later releases have some type of reference modification similar to COBOL's or even another option? Thanks. 9689 22 24_DB2 Connect cmallc rc=2014_Masone, Franco24_F.Masone@CEDACRIOVEST.IT31_Tue, 12 Oct 1999 16:09:25 +0200448_- Hi to all, Db2connect again...... I am trying to do a connection with the OS390 DB2 V4.1, I try to use APPC thru SNA SERVER (Independent LU 6.2). I followed all the directions from the manual, at time of connection I receive a message reporting a return code 20 (product specific error) from cmallc. Any suggest ? The 6.2 lu is defined in Sysibm.lunames. How can I debug this (perhaps communication (CPI) problem ?) Thanks in advance Franco [...] 9712 48 29_Re: Updating using substring?13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 12 Oct 1999 15:12:17 +0100581_iso-8859-1 Try set lastname = 'XXXXX' || substr(lastname,5,80) (or whatever the length of lastname is)

Marcus

-----Original Message----- From: thomas otway [mailto:otwayc@TENET.EDU] Sent: 12 October 1999 15:08 To: DB2-L@RYCI.COM Subject: Updating using substring?



The programmers at our shop would like to use " set substr(lastname,1,5)='xxxxx' " to update. I know that in 4.1 this is not possible and it looks the same in 5. Do any of the later releases have some type of reference modification similar to COBOL's or even another option? Thanks. [...] 9761 51 23_Re: Dynamic SQL Caching12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 12 Oct 1999 07:16:10 PDT681_- Michael,

I don't know if you can find out dynamically at runtime as it is the 'CACHEDYN' DSNZPARM that determines DYNAMIC CACHING for a SSID. There are tools available (ie. RC/QUERY from CA/Platinum) to determine the whether or not it is turned on for each SSID.

HTH, Craig Patton Contract DBA







>From: Michael Ryle >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Dynamic SQL Caching >Date: Tue, 12 Oct 1999 09:53:51 -0400 > >One of the features of the software product my company markets for OS390 >allows our users to process DB2 SQL statements dynamically through our [...] 9813 20 28_JDBC Updates taking too long13_Craig Anthony17_craig@CAC.PSU.EDU31_Tue, 12 Oct 1999 10:17:55 -0400513_US-ASCII We are using DB2 UDB 5.2, Java 1.1 and JDBC under AIX to do updates to a database. The updates are taking too long. When we do an iostat, we are seeing that it is reading 5-8MB for each update and only writing about 4K. The database has about 10000 records in it currently. If we write all of the update statements to a file and do a db2 -t < file.sql. The updates (500) of them take less than 3 seconds, but using JDBC with prepare/execute, the entire process is taking over 30 minutes. Any ideas? [...] 9834 19 38_DB2 Connect and the Nullid Collection.15_Timothy J Tiner28_Timothy_J_Tiner@NOTES.FH.COM31_Tue, 12 Oct 1999 07:14:23 -0700548_us-ascii Is it possible to bind the packages that come with DB2 Connect into another collection other than the default 'nullid' collection in DB2 for OS/390? If so, how is this done and then how does a workstation refer to this collection at execution time?

Tim Tiner Foundation Health Systems, Inc.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9854 47 23_Re: Dynamic SQL Caching20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 12 Oct 1999 10:37:05 -0400376_- Michael

IFI is answer to that. IFCID 106 gives DSNZPARM parameter. There are two easy way to do this -

1. Use your own IFI commands 2. Use a free-bee stored procedure DSNWZP. Installation job DSNTIJSG, which binds and define stored procedure. This runs under DB2 SPAS. To invoke use standard call - "CALL DSNWZP (:Host-var)" , The host-var is CHAR(8600). [...] 9902 47 14_db2 batch - mq16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Tue, 12 Oct 1999 15:53:18 +0100397_ISO-8859-1 Hi,

We're currently developing a new category of application region and I'd like to get your opinions on the best option. The application reads an MQ message, performs DB2 for OS/390 V4 stuff, and writes back an MQ message. Technically this is a batch process (ie. not TSO,CICS,IMS transactional) but it acts like an online process (handling approx 5,000 messages per day). [...] 9950 133 28_SV: DB2 Connect cmallc rc=2025_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE31_Tue, 12 Oct 1999 16:59:30 +0200545_ISO-8859-1 Franco, I can't really help you with the problem, but this is what the manual says.

20 CM_PRODUCT_SPECIFIC_ERROR The local program made a CPI-C call that failed because of a platform-related condition. Explanation An operational problem has been detected which relates to the CPI-C product that the local program is using. A description of the error has been written to the local CPI-C product's system error log. See the product documentation for an indication of conditions and state changes caused by this return code. [...] 10084 45 42_Re: DB2 Connect and the Nullid Collection.13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 12 Oct 1999 10:04:21 -0500336_iso-8859-1 I worked around this by executing a BIND COPY into the desired collection-id from nullid collection via a batch mainframe job. I did not try and get the install process to bind directly other than nullid.

The second part was to modify DB2CLI.INI for the database section .... I added ... CURRENTPACKAGESET=xxxxxx [...] 10130 64 18_Re: db2 batch - mq13_Chie, Jim (C)17_chiej@CONNEXT.COM31_Tue, 12 Oct 1999 08:02:30 -0700343_iso-8859-1 Lots of people run IMS as a transaction processor, but use DB2 for the database. Its a good option if you have IMS already there, doing other things. You can use a BMP for the queue listeners, and MPPs for the transactions that process the messages. Just make sure specify the correct COMMIT options, or you may lose messages. [...] 10195 55 38_Re: Does anyone know of any Positions?15_Cellich, Robert27_Robert.Cellich@MARRIOTT.COM31_Tue, 12 Oct 1999 11:09:04 -0400384_- Bob, you really should check out Marriott International, we have a pretty big DB2 shop here and are looking for 6-8 people currently that have DB2. The person to contact would be Rhonda.Fox@Marriott.com send her resumes via email. Or fax it to her at 301 380 5882

She will see to it that the resumes will get forwarded to the proper managers hiring for DB2 DBA's Etc... [...] 10251 84 34_Re: SYSCTRL granting itself SYSADM13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 12 Oct 1999 10:05:15 -0500584_iso-8859-1 As far as syscntrl authority existing for data-security, think of it this way -- Syscntrl authority includes the ability to bind a plan/package with any authid as the owner. If someone with syscntrl wanted to access some data that they did not have access to, it would be as simple as binding a plan used by something like spufi or qmf with dynamicrules(bind), and putting a sysadm authid as the plan-owner (If the "RETAIN" keyword is used, then the syscntrl authid still has execute access on the plan, which can now access any data). Also keep in mind that syscntrl [...] 10336 15 14_DB2-L Archives13_Fisher, Larry19_LFISHER@INTEGON.COM31_Tue, 12 Oct 1999 11:14:58 -0400341_- Have the DB2-L Archives been moved ? If they have been moved where are they ?

Larry Fisher

================================================ 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. 10352 51 9_DDF error15_Thomas Karlsson19_thkar97@HOTMAIL.COM30_Tue, 12 Oct 1999 17:19:01 CEST388_- Hi All! --------- I have a problem with DDF.

I have DB2 Connect EE 5.2 and when I connect thru APPC It works fine, but when I try to connect Via TCPIP I get the following error: DSNL030I : DSNLTSEC DDF PROCESSING FAILURE FOR LUWID=A409F974.G821.B2FC014402FE AUTHID=SSDDTKA, REASON=00F30013

Is it anything to do with RACF or is it something wrong in my CDB- database. [...] 10404 333 46_Re: inserts into DB2 OS390 with unique indexes0_19_Tim.Lowe@STPAUL.COM31_Tue, 12 Oct 1999 10:22:35 -0500563_us-ascii Richard, How does DB2 "determine that an index is unique" if you have not defined it as unique? I disagree with you that: "Row level locking is only to solve the problem of multiple updaters on the same page at absolutely the same time". Row-level locking can also be used to solve problems with multiple deleters on the same page at the same time. And, I suspect that the deletes may be the problem described here, so I mentioned it. 3. I have not heard before that row-level locks are not supported in a data-sharing environment. If this is true, [...] 10738 85 18_Re: db2 batch - mq11_John Wynton21_jwynton@THEMISINC.COM31_Tue, 12 Oct 1999 11:24:26 -0400438_- Michael,

This reply is from our Senior Instructor and MQ Guru, Tom Dunlap. He is not subscribed to the DB2 list so I have forwarded them on. He has embedded replies within an eddited version of your message in appropriate places.

John Wynton Marketing Director, PathPoint Software Themis, Inc. Specialists in DB2, MQ and CICS Training 1-800-756-3000; 908-233-8900 (Int'l); 908-233-7401 (Fax) http://www.themisinc.com [...] 10824 156 32_Re: SV: DB2 Connect cmallc rc=200_27_Jim.Leask@RS-COMPONENTS.COM31_Tue, 12 Oct 1999 16:29:36 +0100443_ISO-8859-1

Sven,

I am currently about to set up a link from QMF for Windows to DB2 v4 using CPI-C. Please supply the title of the manual you were referring to concerning CPI-C error messages.

Thank you, Jim Leask.

______________________________ Reply Separator _________________________________ Subject: SV: DB2 Connect cmallc rc=20 Author: Sven.Heidorn (Sven.Heidorn@CSN.SE) at Internet Date: 12/10/99 15:59 [...] 10981 118 46_Re: inserts into DB2 OS390 with unique indexes20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 12 Oct 1999 11:46:25 -0400345_- Tim

>>How does DB2 "determine that an index is unique" if you have not defined it >>as unique?

Three important columns on the catalog tables CARDF, COLCARDF and FIRSTKEYCARDF tells optimizer that index is unique. When CARDF = COLCARDF or CARDF = FIRSTKEYCARDF (depends on the situation) , optimizer knows the filter factor. [...] 11100 78 13_Re: DDF error14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 12 Oct 1999 11:54:30 -0400424_- Your userid does not have access to the DB2 subystem in RACF. Problem Determination: During TCB connection processing, Subsystem Support invokes the RACROUTE service (causing a RACF RACHECK) to verify the authorization ID associated with the requester. If the RACF return code indicates the requester is not authorized to connect to this DB2 subsystem, the connection request is terminated with this reason code. HTH [...] 11179 202 32_SV: SV: DB2 Connect cmallc rc=2025_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE31_Tue, 12 Oct 1999 18:16:15 +0200319_ISO-8859-1 Jim, Should I say good luck, or. Anyway, we have been trying the same for quite some time now, that's why I had the manual handy. It's on the DB2 udb V6, Manuals in PostScrip format CD, and the file name is Db2ape60.exe. If you don't have the CD send me a note offline and I will send you the PDF file. [...] 11382 24 24_Loading LARGE table NPIs14_Mike Ockenfels28_Michael.D.Ockenfels@WCOM.COM31_Tue, 12 Oct 1999 11:20:48 -0500532_us-ascii I'm trying to load (replace) multiple partitions of a LARGE table. Each partition contains approximately 15 million rows. The reload and sort phase perform in a reasonable amount of time (i.e. 40 minutes). However, the build phase takes much longer (ie.. 14 hours). There is one partitioning index and 3 NPIs. The partitioning index is built in minutes. After that, the -dis util build phase count stops and doesn't resume for an hour or two. This happens with each of the NPIs. Each NPI is a Type 2 non-unique index. [...] 11407 30 14_DB2-L Archives0_32_thomas.e.faglon@BELLATLANTIC.COM31_Tue, 12 Oct 1999 12:24:04 -0400573_us-ascii http://jupiter.ryci.com/archives/db2-l.html

To: DB2-L@RYCI.COM cc: (bcc: Thomas E Faglon) From: "Fisher, Larry" Date: 10/12/99 03:14:58 PM GMT Subject: DB2-L Archives





Have the DB2-L Archives been moved ? If they have been moved where are they ?

Larry Fisher

================================================ 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. [...] 11438 201 32_Re: SV: DB2 Connect cmallc rc=2014_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 12 Oct 1999 12:32:12 -0400539_- Guys, We went with IBM Communications Server for Windows NT, we tried PCOM for a short time but ran into too many problems with it. If you follow the DB2 Connect Quick Beginnings you should be able to get it up and running. CPIC problems are tough to solve. IBM Comm Server has an error log which contains useful information, plus your DB2 MSTR address space log on the host (if you are getting there), a VTAM trace might help also if you can't find anything wrong with your SAN setup on your client. I have step by step procedures [...] 11640 85 19_Re: REPAIR DBD TEST12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 12 Oct 1999 18:46:22 +0200291_x-user-defined Hi, This is usually the best way to go. If it doesn't work - then you open a problem with IBM and send them a copy of all things involved (maybe you miss some ptf) and restore your cat/dir.

BTW - I tend to use the dsn1chkr as well as the "repair teat & diagnose". [...] 11726 69 18_Re: db2 batch - mq12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 12 Oct 1999 18:55:39 +0200427_x-user-defined Hi, I would use the IMS option (we do it and it works fine). Using CAF is not as bad as you fear. You should sit ones to build yourself a small program example and afterwards it'll be much easier. If you plan to use "C" then beware of the syntax in the books as both V4 and V5 books has errors in the syntax, but if you read the other languages examples then you get it right. CAF performance is better then TSO. 11796 94 16_Re: ARCHIVE LOGS11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Tue, 12 Oct 1999 10:04:34 -0700430_- Leslie,

I am not much familiar with log analyzer, but if the logs (in this case archive logs) are not cataloged in BSDS, can log analyzer still build the SQL ?

Sanjay

-----Original Message----- From: Leslie Pendlebury-Bowe Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Monday, October 11, 1999 12:52 AM Subject: Re: ARCHIVE LOGS [...] 11891 72 28_Re: Loading LARGE table NPIs15_Murley, Michael22_Michael_Murley@BMC.COM31_Tue, 12 Oct 1999 13:02:13 -0500377_iso-8859-1 I'm posting this reply for Donna Di Carlo, who is temporarily unable to post to this list:

Mike,

It sounds like the sort is slowing you down. Even though the display claims that the sort has completed, I'll bet that the sort has not completely turned around. PIECESIZE will give you more data sets, but it will not decrease the size of your sort. [...] 11964 145 16_Re: ARCHIVE LOGS13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Tue, 12 Oct 1999 13:15:47 -0500519_iso-8859-1 Sanjay,

(I cannot speak for CA's Log Analyzer, but,) BMC's Patrol DB-Log Master for DB2 for MVS does allow for user specification of DB2 logs no longer referenced in the BSDS. One caveat to consider if using either product in the mode of processing logs outside of the BSDS is whether or not your tables are defined with Data Capture Changes. If you are defined with Data Capture None, you will need to specify all logs necessary to allow for updates to be completed from the nearest image copy. [...] 12110 107 13_Re: DDF error16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Tue, 12 Oct 1999 14:43:48 -0400778_us-ascii Thomas,

To add to Phil's reply, the CDB is not used for IP connections when DB2 OS/390 is acting as an application requester (AR).

-Mike.









Philip Gunning on 10/12/99 11:54:30 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: Re: [DB2-L] DDF error







Your userid does not have access to the DB2 subystem in RACF. Problem Determination: During TCB connection processing, Subsystem Support invokes the RACROUTE service (causing a RACF RACHECK) to verify the authorization ID associated with the requester. If the RACF return code indicates the requester is not authorized [...] 12218 31 31_Date variable usage in CLI/ODBC6_RANJAN23_Ranjan.Kotnala@WCOM.COM31_Tue, 12 Oct 1999 12:39:33 -0600510_iso-8859-1 Hi list

For the following ODBC(CLI) code

rc=SQLBindCol(StmtHandle,1,SQL_C_DATE,(SQLPOINTER) Last_Updt_Dt,sizeof(Last_Updt_Dt), NULL);

SQL_C_DATE represents the C data type of the variable identified as Column 1 in the SQL statement pointed to by StmtHandle . The column is of DATE type in DB2. What should be the data type of Last_Updt_Dt whcih is the c / cpp program variable being bound to Column 1 so that I receive the date as yyyy-mm-dd ; the default DB2 date format. [...] 12250 63 36_$ Db2 International language support14_Michael Rooney22_MRooney@COMPUSERVE.COM31_Tue, 12 Oct 1999 15:38:53 -0400496_ISO-8859-1 Where looking to expand our business internationally. Currently we have one Production DB2 and one test DB2 subsystem (V5) on OS/390 V2.6 and our business is focused in the USA (English support only).

Were looking to replicate some of our existing programs to use new tables that will be loaded in Spanish. The New programs will be recompiled and translated to Spanish. The Application is CICS based. Another Spanish CICS region will be created to support the application. [...] 12314 95 40_Re: $ Db2 International language support26_Lindsay, William (SOM400A)24_WLindsay@EXCHANGE.ML.COM31_Tue, 12 Oct 1999 15:52:49 -0400537_iso-8859-1 Look into XML as a common format. It has excellent data exchange, and international translation capabilities. Most database platforms are offering Import/Export capabilities to XML. More information can be found at http://www.w3c.org/xml

As a for instance all Windows Office 2000 products will handle XML formatted data.

HTH

Bill Lindsay

Project Manager - Web Development Merrill Lynch Global Data Sourcing and Delivery 400 Atrium Drive - 5S51A Somerset NJ 08873-2861 [...] 12410 135 19_Re: REPAIR DBD TEST0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 12 Oct 1999 14:52:00 -0500503_us-ascii Out of curiosity I tried REPAIR DBD TEST on a couple of our DB's (development and production). I got the output listed below. I've looked up the DSN* messages, but don't know enough about DB2 to translate the IBM documentation to figure what it is trying to tell me.

Can anyone interpret the DSNU901I and DSNU919I errors for me? How significant are these errors? What is an OBD, "Object DB"? Where does the "Existing Value" exist, in the DBD or the CAT What is the "Rebuilt" value? [...] 12546 20 42_ACF2 to RACF conversion - db2 dependencies0_18_Usregion10@AOL.COM29_Tue, 12 Oct 1999 16:17:32 EDT497_us-ascii hi all!

Has anyone of you done a conversion from ACF2 to RACF ? I would like to know what are the db2 dependencies n such a conversion. Any checklist out there? Any input in this regard would be a great help. Thanks in advance.

Anil

================================================ 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. 12567 22 13_Re: DDF error11_Kenneth Lam14_klam@BTMNA.COM31_Tue, 12 Oct 1999 16:18:10 -0400470_us-ascii Hi, I also getting some sort of error when I tried used UDB EE 5.2 TCP/IP. When I use UDB Client Configuration Assistance to manually add a new database, I got communication socket errors. From the mainframe side we are using UDB V6.1 for OS/390. Here is the message I got when I start DDF in MVS. DSNLILNR TCP/IP GETHOSTBYADDR FAILED WITH 332 RETURN CODE=1 AND REASON CODE=00000000 . Did I missing something in CDB tables. Can some one give some insight. [...] 12590 73 46_Re: ACF2 to RACF conversion - db2 dependencies0_14_dcreed@CSC.COM31_Tue, 12 Oct 1999 15:43:38 -0500561_us-ascii We did several years ago.

I honestly don't remember too much, but... The shop converted grew up with acf2. We had implemented our own code to handle secondary authid support prior to ACF2 providing it. So during the conversion of ACF2 rules to RACF, we can across a delima of too many RACF groups connected to a user that could be passed thru to DB2. I can't remember the limit but it seems like something like around 200. (I didn't say it was a smart conversion). So we made sure to create a structure that identified group that were used [...] 12664 49 13_Re: DDF error14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 12 Oct 1999 16:53:35 -0400491_- Ken, Check the etc.services or tcpip.profile or other tcpip datasets to ensure the hostname and dotted decimal ip address is present. I belive DB2 tries to resolve the host name by reading the ip datasets first, then a DSN server if you have one. HTH Phil

This is spelled out in the Redbook, Wow! DB2 Supports TCPIP for DB2 for OS/390 (the name is something like that, I left my copy at home). Go to www.redbooks.ibm.com/redbooks and you can look at this book online. HTH Phil [...] 12714 24 17_Extending DSNTIAR11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Tue, 12 Oct 1999 17:01:53 -0400576_us-ascii DSNTIAR is a nice start for post-processing of SQLCODE message text. But I would like to extend its functionality for some SQLCODES, to help the user more quickly determine how to fix the problem. Ex. for -532, I would like to display ALL the first-level child rows of the one parent table that is experiencing the referential integrity error. Ex 2. -805 SQLCODE actually includes the SQL for five types of errors that may have occurred. I'd like to execute those for which I have the information available, and place the output into a DSN of my choosing. Ex 3. [...] 12739 20 36_Reuse of space for large tablespaces22_Garud, Aniruddha (PCA)20_AGarud@NA2.US.ML.COM31_Tue, 12 Oct 1999 17:04:07 -0400459_iso-8859-1 Hi All,

Is the the space deleted is reused immidiately (without Reorg) for the new inserts in case of Large (partitioned) tablespaces? The tablespace is not complressed.

TIA, Aniruddha DB2 DBA

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12760 53 28_Re: Loading LARGE table NPIs14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Tue, 12 Oct 1999 22:32:51 +0100358_- If you are load replacing many partitions, it may even be worth dropping thise NPIs, doing the load and then recreating (with DEFER YES of course) followed by index RECOVERies for the NPIs

Rebuilding (or in place updating) of NPIs during partition level operations is not something you reall want to be doing a lot of (as you have discovered!) [...] 12814 43 19_Re: ERwin vs Popkin14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 12 Oct 1999 16:41:49 -0500384_iso-8859-1 Although I know nothing about its quality, another data modeling offering with DB2 support is Silverrun from CSA (www.silverrun.com). Visio Enterprise also touts support for DB2 with the technology they acquired from InfoModelers. Microsoft just announced (9/15/99) that they will be acquiring Visio (don't know whether that bodes ill or well for future DB2 support). [...] 12858 13 13_Re: DDF error12_Phil Gunning15_Cicsesa@AOL.COM29_Tue, 12 Oct 1999 19:23:16 EDT309_us-ascii Sorry, that should be DNS. Must of been thinking of DB2!!!

================================================ 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. 12872 77 46_Re: ACF2 to RACF conversion - db2 dependencies0_29_Adrian.Talbot@BANKWEST.COM.AU31_Wed, 13 Oct 1999 08:15:21 +0800483_us-ascii Hi,

We also went through the pain of converting from ACF/2 to RACF for DB2 Security. I posted details of the problems which we encountered and how we got around them to the list several months ago.

You might want to look in the archives for them.

Cheers

Adrian Talbot Database Administration Group Information Services, Level 10, Tower Bank of Western Australia Ph : (08) 9449-6273 Fax : (08) 9449-6133 eMail : adrian.talbot@bankwest.com.au [...] 12950 126 46_Re: inserts into DB2 OS390 with unique indexes16_Richard A Yevich15_ryevich@IBM.NET31_Tue, 12 Oct 1999 20:17:52 -0400360_iso-8859-1 Tim, Sorry but with very little time these are very much to the point:

1 - Regarding the implicit unique index features -- it is documented in the V5 manuals as is a new feature in V5. Catalog is not updated but optimizer can determine during access path selection (RTFM).

2 - updates = DML [insert, update, delete] by definition [...] 13077 144 16_Re: ARCHIVE LOGS22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 13 Oct 1999 07:36:45 +0100438_ISO-8859-1 Sanjay I have only just started to use the product .. and infact I am using the product to build a "dynamic - quiet time" intelligent automatic reorg process at our 24 x 7 SAP site .. where we are unable to perform online reorgs due to heavy claimers on objects .. so from my short experience with the product I am fairly confident that you can get this information from it - infact I will test it for you sometime today. [...] 13222 98 44_Re: RV: DB2LOOK in the UDB v 5.2 environment0_30_Milorad_Cerovac@TAC.VIC.GOV.AU31_Wed, 13 Oct 1999 16:45:30 +1000427_us-ascii We're still a bit stumped on this one. Don't have any problems with running the exact same db2look syntax (with exception of the database name) on other servers. Odd thing is that when we submit the db2look job it hangs. If we cancel it after a few minutes we check the output and it has succeeded in displaying some of the DDL syntax. Currently making do with a work-around solution - but its still a real pain. [...] 13321 129 13_Re: DDF error14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM31_Wed, 13 Oct 1999 08:57:45 +0200306_us-ascii I had the same error when setting up TCP/IP connections to our DB2 V5.1 on OS/390 V2.6. In RACF there must be a profile in class DSNR with the name subsystem.DIST where 'subsystem' is the name of your DB2 subsystem on OS/390. A user must have READ access to this profile in order to use DDF. [...] 13451 17 28_Installing JDBC on DB2 OS39011_Michael Lim24_TSMLIM@HKCLEARING.COM.HK31_Wed, 13 Oct 1999 16:05:29 +0800397_US-ASCII Can someone tell me where I can find documentation on how to install JDBC on DB2 V5 OS390? Does this component come with DB2 V5?

thanks, Mike

===============================================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. 13469 19 25_Help in Stored Procedures12_pankajkakkar15_pankajk@INF.COM31_Wed, 13 Oct 1999 01:17:11 -0700481_iso-8859-1 Hi, I am a newbie in DB2 list. I will appreciate if somebody can throw pointers on website or Books available for Coding Stored procedures in DB2. Also on calling them in CICS COBOL and Batch COBOL programs.

Thanks Pankaj

================================================ 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. 13489 44 28_Re: Loading LARGE table NPIs10_Ven Ilagan18_vilagan@ONE.NET.AU31_Wed, 13 Oct 1999 08:04:39 +1000345_us-ascii Build of NPI's are serialized so depending on how many total rows you have, it might be better for you to submit 3 simultaneous jobs of Rebuild Index for each of the NPI's, i.e. have the job terminate (you can use DIAGNOSE to stop at a specific phase) at the building of the NPI's and kick in the multi-tasked jobs simultaneously. [...] 13534 40 29_Re: Help in Stored Procedures8_DVRAMESH16_DVRAMESH@INF.COM31_Wed, 13 Oct 1999 14:46:45 +0530607_iso-8859-1 Hi Pankaj

Ramesh here we gave support for your Aetna project at pune. Pls contact SrinivasG@inf.com our db2 administrator he is having some examples with him.



Rgrds Eshwar

-----Original Message----- From: pankajkakkar [mailto:pankajk@INF.COM] Sent: Wednesday, October 13, 1999 1:47 PM To: DB2-L@RYCI.COM Subject: Help in Stored Procedures



Hi, I am a newbie in DB2 list. I will appreciate if somebody can throw pointers on website or Books available for Coding Stored procedures in DB2. Also on calling them in CICS COBOL and Batch COBOL programs. [...] 13575 47 29_SV: Help in Stored Procedures25_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE31_Wed, 13 Oct 1999 12:19:35 +0200619_ISO-8859-1 Pankaj,

there is a redbook covering this, it's called "Getting Started with DB2 Stored Procedures: Give Them a Call through the Network" and the form # is SG24-4693-01.

Sven Heidorn

> -----Ursprungligt meddelande----- > Från: pankajkakkar [SMTP:pankajk@INF.COM] > Skickat: den 13 oktober 1999 10:17 > Till: DB2-L@RYCI.COM > Ämne: Help in Stored Procedures > > Hi, > I am a newbie in DB2 list. > I will appreciate if somebody can throw pointers on website or Books > available for Coding Stored procedures in DB2. Also on calling them in > CICS > COBOL and Batch COBOL programs. > > [...] 13623 164 46_Re: inserts into DB2 OS390 with unique indexes0_19_mike.holmans@BT.COM31_Wed, 13 Oct 1999 11:35:24 +0100586_ISO-8859-1 Richard,

I'd agree that if you have an access path problem in the normal operation of a system, then lying to DB2 isn't a sensible workaround.

But are you saying that faked statistics should not be used even for system build-up?

When you first put a system live, and there are no rows in the CUSTOMER_ORDER table, but you expect there to be 500,000 rows there after a month or two, is there not a case for taking the stats from your volume test environment and putting them into the production catalog? What you'll get won't be the fastest possible [...] 13788 80 28_Re: Loading LARGE table NPIs15_Tiller, Michiel22_Michiel_Tiller@BMC.COM31_Wed, 13 Oct 1999 05:21:27 -0500556_iso-8859-1 Have you tried using the SORTKEYS option?

- - - 8< - - - - "2.8.1.3.13 Improving Performance with SORTKEYS"

If you use SORTKEYS, index keys are passed to sort in memory rather than written to work files. Avoiding this I/O to the work files improves LOAD performance. DASD space requirements for the SYSUT1 and SORTOUT data sets are also reduced, especially if an estimate of the number of keys to sort is provided. Also, elapsed time from the start of the reload phase to the end of the build phase is reduced. - - - 8< - - - [...] 13869 13 26_UDB6.1 on Win 95 resources11_Eric Robida22_Eric_Robida@BCBSME.COM31_Wed, 13 Oct 1999 08:02:45 -0400344_us-ascii Can anyone recommend some good resources for learning how to use UDB on the windows platform?

================================================ 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. 13883 47 28_FW: Loading LARGE table NPIs32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 13 Oct 1999 15:34:52 +0300401_- I would suggest you to use DIAGNOSE utility for the LOAD process. I had the same problem for DW env. Use Diagnose to abend your LOAD job after RELOAD phase and start concurrent recover index jobs for each NPI.

Cuneyt GOKSU DBA IBM CSE - DB2 Universal Database V5 Database Administration GARANTÝ TEKNOLOJÝ Istanbul / TURKEY Tel : 0090-212-657 0404 Ext: 1218 mailto:Cuneytg@garanti.com.tr [...] 13931 22 23_Euro IDUG get-together?0_19_mike.holmans@BT.COM31_Wed, 13 Oct 1999 14:08:41 +0100320_- What with the list server moving and the associated teething troubles, and being on holiday, I haven't seen all that much of the list traffic in the last month.

Has anyone arranged a get-together for list subscribers in Nice next week?

If not, is it possible to arrange something at this late date? [...] 13954 12 51_=?iso-8859-1?Q?R=E9f._:_Euro_IDUG_get-together=3F?=14_Denzil Coulter26_Denzil.Coulter@UNICIBLE.CH31_Wed, 13 Oct 1999 15:15:50 +0200279_us-ascii I would be interested. When?

================================================ 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. 13967 29 40_Alternatives to CA/Platinum DB2 products17_Ben Ollo NONLILLY27_OLLO_BEN_NONLILLY@LILLY.COM31_Wed, 13 Oct 1999 08:29:18 -0500549_us-ascii Since CA bought Platinum, we have been looking for alternatives to Platinum Recovery Analyzer and Platinum Log Analyzer.

Do any members of the list know of good replacements for these products?

Thanks for your help.

Ben Ollo Eli Lilly and Company 317.277.8829 bollojr@lilly.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. 13997 19 32_Use of Image Copy NOT in SYSCOPY10_Rick Davis22_richard.g.davis@DB.COM31_Wed, 13 Oct 1999 08:26:11 -0600494_us-ascii Hi all and thanks in advance. Environment: DB2 for OS390 V5. Has anyone successfully done a RECOVER TOCOPY of a tablespace from an image copy not recorded in SYSIBM.SYSCOPY? Seems to me the RECOVER utility might check to see if the copy was in SYSCOPY. We intend, for Y2K testing reasons, to delete it from SYSCOPY, but might need it for fallback purposes. It will remain catalogued. We then intend to do a LOGONLY recovery to a quiesce point we set after the copy. Regards, Rick [...] 14017 36 27_Re: Euro IDUG get-together?14_Jakofcic Darja22_darja.jakofcic@N-LB.SI31_Wed, 13 Oct 1999 15:47:54 +0200592_- It's a nice idea Darja

> -----Original Message----- > From: mike.holmans@BT.COM [SMTP:mike.holmans@BT.COM] > Sent: 13. oktober 1999 15:09 > To: DB2-L@ryci.com > Subject: Euro IDUG get-together? > > What with the list server moving and the associated teething troubles, and > being on holiday, I haven't seen all that much of the list traffic in the > last month. > > Has anyone arranged a get-together for list subscribers in Nice next week? > > If not, is it possible to arrange something at this late date? > > Mike Holmans > BT ISE Technical Design > mike.holmans@bt.com > > [...] 14054 22 20_DB2 User Exit & ADSM0_21_rvpham@DSTSYSTEMS.COM31_Wed, 13 Oct 1999 08:44:50 -0500298_us-ascii Hello List,

If you got DB2 User Exit progam of DB2 UDB v5.2 on UNIX or Solaris platforms which use ADSM, could you send me a note how did you get the DB2 User Exit C program compiled. I had troubles to compile it using cc or gcc with ADSM. (NT worked just fine, but not UNIX). [...] 14077 18 36_Re: Use of Image Copy NOT in SYSCOPY0_23_duerr_jacobsg@WESTLB.DE31_Wed, 13 Oct 1999 16:00:17 +0100418_us-ascii Hi Rick,

you should run the DSN1COPY-Utility. For more information use the DB2 Utility Guide and Reference, Section "Stand-Alone Utilities"

Regards Guido

================================================ 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. 14096 46 36_Re: Use of Image Copy NOT in SYSCOPY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 13 Oct 1999 10:00:08 -0400380_- Rick

Sure recovery checks for entry in SYSCOPY. Following ways to do this -

Traditional way - DSN1COPY without RESET option followed by LOGONLY recovery TORBA or TOLOGPOINT

Unusual way - While assembling DSNZPARM set SPRMCTU bit to X'80' (macro DSN6SPRC) to enable catalog update. Insert an entry in SYSCOPY and you should be able to recover as usual. [...] 14143 23 39_Visual Explain and Run-time Clien V6.1?0_21_RompotK@SCHNEIDER.COM29_Wed, 13 Oct 1999 13:58:03 GMT414_us-ascii Is anyone running Visual Explain V6 for Windows '95 with the DB2 Runtime Client V6.1?

I can't get my database connections within Visual Explain to work anymore. I get an error message that looks like this: 'Primitive failed in: PlatformFunction>>#callWithArguments: due to OS error1157'.

Everything works fine outside of Visual Explain.

Thanks, Kurt Rompot rompotk@schneider.com [...] 14167 53 46_Re: ACF2 to RACF conversion - db2 dependencies17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Wed, 13 Oct 1999 09:15:59 -0500549_iso-8859-1 Anil,

I've never done a conversion to RACF, but two excellent resources for understanding how to control DB2 access using RACF are:

1) OS/390 Security Server (RACF) Security Administrator's Guide Document Number SC28-1915-05

http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/ICH1A705/CCONTENTS especially chapter 11 and appendix 'C'

2) SG245158: Ready for e-business - OS/390 Security Server Enhancements (Chapter 4) http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245158.pdf

Hope this helps, [...] 14221 35 19_DB2 V6 enhancements12_Kapil Mathur25_kapil.mathur@WACHOVIA.COM31_Wed, 13 Oct 1999 10:04:53 -0400675_us-ascii Hi, I heard from folks who went to the Tech Conference in New Orleans that for DB2 for OS/390, IBM will include future capabilities to:- 1) add/delete partitions to an existing partitioned tablespace. 2) drop all support for simple tablespaces completely. 3) turn-off any logging for certain tablespaces by designating them non-recoverable (i.e. only recover TO-COPY based on user's discretion) 4) Allow support for "index-only" tables (like Oracle does with ORGANIZATION INDEX clause) 5) Enhance IBM Online-Reorg so that instead of renaming the shadow linear data sets in the switch-phase, DB2 will internally "rename" the VCAT entries themselves allowing for [...] 14257 46 27_Re: Euro IDUG get-together?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 13 Oct 1999 10:21:10 -0400705_ISO-8859-1 I will there... any suggestions? As long as it is not when the vendor area is open since I have to be in our stand.

Regards, Joel |======================================================= | Joel Goldstein | Responsive Systems Company |======================================================= | WEB Site | www.responsivesystems.com |======================================================= | Buffer Pool Tool for DB2 & DASD/Xpert for DB2 | >>> The Answers for your performance problems <<< |------------------------------------------------------- | Tel.(800) DB2-EXPErt Tel.(800) 322-3973 | Tel.(732) 972-1261 Fax.(732) 972-9416 |======================================================= [...] 14304 55 23_Re: DB2 V6 enhancements15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Wed, 13 Oct 1999 10:33:26 -0400450_iso-8859-1 Kapil,

The What's New Technical Manual is a good source to find out what's coming up in the new release and is usually published in advance of the GA of a release. Take a look at V6 and you will see the information you speak of.

Susan Loria

-----Original Message----- From: Kapil Mathur [mailto:kapil.mathur@WACHOVIA.COM] Sent: Wednesday, October 13, 1999 10:05 AM To: DB2-L@RYCI.COM Subject: DB2 V6 enhancements [...] 14360 46 44_Re: Alternatives to CA/Platinum DB2 products14_Stevens, Wayne21_Wayne_Stevens@BMC.COM31_Wed, 13 Oct 1999 09:29:29 -0500625_iso-8859-1 BMC's alternative to Log Analyzer is PATROL DB-Log Master for DB2 for MVS http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900 3201800c6d70&dmw_format=html. BMC's alternative to Recovery Analyzer is RECOVERY MANAGER for DB2 http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900 32018008db2e&dmw_format=html.

Wayne Stevens BMC Software, Inc.



-----Original Message----- From: Ben Ollo NONLILLY [mailto:OLLO_BEN_NONLILLY@LILLY.COM] Sent: Wednesday, October 13, 1999 8:29 AM To: DB2-L@RYCI.COM Subject: Alternatives to CA/Platinum DB2 products [...] 14407 66 36_Re: Use of Image Copy NOT in SYSCOPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 13 Oct 1999 09:35:38 -0500392_iso-8859-1 Rick,

If you delete the earliest image copy with the DB2 Modify utility, remember that this will also delete related SYSLGRNX entries for the space, making a subsequent RECOVER LOGONLY operation impossible without somehow bypassing SYSLGRNX. Also, as you suggest, the DB2 Recover utility will not allow a TOCOPY recovery if the copy is no longer registered in SYSCOPY. [...] 14474 48 24_Re: DB2 User Exit & ADSM13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 13 Oct 1999 15:36:48 +0100427_us-ascii You don't need to compile a user exit to backup DB2 with ADSM - this comes supplied prebuilt already.

You just use the command -

DB2 BACKUP DATABASE dbname USE ADSM

If however you're talking about backing up logs using ADSM then I'm all ears, as this is something I'm about to start looking at. We use mainly AIX, but have a couple of Solaris boxes as well which we are about to start using. [...] 14523 35 107_$199 - Nov 18-19 - Willie Favero - DB2 Recovery From Z to A & Fun with DB2 Performance for Everyone Classes0_23_cathy.peck@HIGHMARK.COM31_Wed, 13 Oct 1999 10:58:43 -0400617_us-ascii Hi all, just a reminder, in order to get a 10% discount on Willie's two classes being held in Central PA you must register 30 days prior to the class dates.

Contact me if you have any questions. Tks!!! Seeya Cathy Peck - (717) 975-7396 / Cathy.Peck@Highmark.Com

--------------------------- Willie Favero Class - 11/18 - $199 - DB2 Recovery from Z to A To see class details & to register, go to http://www.bmc.com.education.index.html Click on REGISTER. Then click on COURSE REGISTRATION. Then click on CONTINUE. Then select DB2 RECOVERY FROM Z TO A (2nd occurrence) on the drop down menu. [...] 14559 97 44_Re: Alternatives to CA/Platinum DB2 products14_Stevens, Wayne21_Wayne_Stevens@BMC.COM31_Wed, 13 Oct 1999 10:07:25 -0500738_iso-8859-1 I am sorry, the other URL's were in error, please try the following:

> BMC's alternative to Log Analyzer is PATROL DB-Log Master for DB2 for MVS http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900 3201800c6d70&dmw_format=html

> BMC's alternative to Recovery Analyzer is RECOVERY MANAGER for DB2 http://www.bmc.com/rs-bin/RightSite/getcontent/bmcdoc.html?dmw_objectid=0900 32018008db2e&dmw_format=html

Wayne Stevens BMC Software, Inc. wayne_stevens@bmc.com





-----Original Message----- From: Toolan, George [mailto:George.Toolan@fmr.com] Sent: Wednesday, October 13, 1999 9:43 AM To: 'Stevens, Wayne ' Subject: RE: Alternatives to CA/Platinum DB2 products [...] 14657 54 27_We have a chance to help...14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 13 Oct 1999 11:11:18 -0400553_ISO-8859-1 We have thousands of people on this list. We have an opportunity to make a difference in the world.



RE: World Hunger

- **This is NOT a joke.** - **I have been to this site and it appears to be real**

Many of you have no doubt heard that the UN has estimated that the worlds' population passed 6 billion this week. All of those people dont read the fRIDAY fUNNIES. But alot of those people are hungry every day. The note below, passed onto me by Bernie Domanski, can help make a difference ... to the hungry. [...] 14712 111 31_SQL Query Problem (through FTP)14_Medel Guevarra17_deng777@EMAIL.COM31_Wed, 13 Oct 1999 11:12:24 -0400257_- Hi, I am new to the list and I'm not sure whether this is the proper forum to submit this message. Anyway the other half of the problem involves SQL Query on DB2 and I thought someone in the LIST may have the answer. Thanks in advance for your help. [...] 14824 74 31_Re: We have a chance to help...16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Wed, 13 Oct 1999 11:23:52 -0400298_us-ascii Joel,

I think it's great that you feel so strongly about world hunger. However, I'm sure each of us on this list has a charitable organization that they donate to. This is a database discussion list and I don't believe this is the proper forum to be pulling a Sally Struthers. [...] 14899 22 31_Performance Monitoring Question14_Sandi Mitchell24_smitchell@AVISTACORP.COM31_Wed, 13 Oct 1999 08:22:43 -0700371_US-ASCII In performance monitoring I've read to compare the class 1 to class 2 elapsed and CPU times and if they are bigger than expected or outside the normal range that warrants further investigation. What I don't know is where to begin with the further investigation. In a batch program what does a large difference in times point to as a potential problem area? [...] 14922 43 23_Online Reorg Parameters0_27_BoSDBA@BANKOFSCOTLAND.CO.UK31_Wed, 13 Oct 1999 15:39:05 +0000605_us-ascii Dear list,

We have not yet implemented Online reorg, but we're thinking about it. We've started testing it in our development environment, while running a batch update program to test concurrency. My question is, what are other people doing with the online reorg parameters, in particular MAXRO, LONGLOG and DELAY. We found that if the MAXRO was too big, the updating process would time out, and if it was too small, the reorg could not complete until after the updating process finished. The problem seems to be with the final iteration of the Log Apply stage when the tablespace is [...] 14966 98 31_Re: We have a chance to help...12_Michael Ryle17_mryle@TSISOFT.COM31_Wed, 13 Oct 1999 11:30:16 -0400471_- The Hunger Site has a policy against spamming and requests that interested parties pass their website address on only to people they know personally.

Michael Ryle TSI International, Inc. Phone: (508) 240-0432 Fax: (520) 752-3548 mryle@tsisoft.com





-----Original Message----- From: Michael McCarthy [mailto:Michael_McCarthy@DTC.ORG] Sent: Wednesday, October 13, 1999 11:24 AM To: DB2-L@RYCI.COM Subject: Re: We have a chance to help... [...] 15065 98 31_Re: We have a chance to help...13_Adrian Savory34_Adrian.Savory@CCMAIL.EU.SONY.CO.JP31_Wed, 13 Oct 1999 16:38:18 +0100494_ISO-8859-1 Mike,

I disagree. I've just been to the site and all you need to do is click on a button, not put your hand in your pocket. It takes 10 seconds!

Anything worthwhile like this is worth publicising everywhere.

Adrian Savory ACSIS Ltd



______________________________ Reply Separator _________________________________ Subject: Re: We have a chance to help... Author: Michael McCarthy at Internet Date: 10/13/99 11:23 AM [...] 15164 31 20_DB2 GUI tools on AIX11_Daniel Adam15_dadam@GRATEX.SK31_Wed, 13 Oct 1999 17:47:15 +0200437_- Hi DB2 people, I just started with DB2 UDB on AIX v5.2. Command line seems to be ok, but I am surprised not to find any of "visual" tools like db2cc, db2cca... Are they or are they not in version 5.2 ? Is it just our installation or is it the product itself that don't have them ? I read something about Web Control Center, I will try that also, but have to download it first. I hope Web Control Center isn't the only posibility. [...] 15196 19 19_SECURITY VIOLATIONS20_NARRA, ADITYA, CFCTR14_anarra@ATT.COM31_Wed, 13 Oct 1999 11:42:21 -0400333_- Hi All, I would like to know the procedure to audit the security violations for the online CICS applications.Like logging a user who tries to make more than 4 unsuccessful attempts at passwords.I would also like to periodically review security logs containing access violations.Any suggestions are welcome. Thanks in advance. [...] 15216 64 45_Moving data across volumes in a storage group29_Sireesh Chandra.M,J16 Chennai25_msireesh@MSDC.HCLTECH.COM31_Wed, 13 Oct 1999 21:42:21 +0530400_iso-8859-1 Hi All, We are using DB2 V5 for OS/390 V2.6. One of the DB2 storage groups we have has four volumes associated with it. We want to release one volume from the list and use it for other purposes. That particular volume has three tablespaces which obviously needs to be moved to in any of the other three volumes. How should we go about doing that??? Can anyone help me in this regard. [...] 15281 30 28_Mixing Type 1/Type 2 Indexes11_Jerry Boehm25_GBOEHM@GW.DOT.STATE.NY.US31_Wed, 13 Oct 1999 12:10:41 -0500586_- Hi all,

After much procrastination, we are finally ready to convert our V4 indexes to type 2. We're aware of CATMAINT for converting the catalog and directory indexes, and we know we'll have to rebuild other indexes after the conversion.

We are trying to resolve whether there are any special issues to be considered when we decide how to break up the workload. We might decide to split the task by database, or perhaps by grouping tablespaces according to row counts. One question that has come to mind -- If we split our task to anything less than full databases [...] 15312 140 31_Re: We have a chance to help...0_19_mike.holmans@BT.COM31_Wed, 13 Oct 1999 17:08:57 +0100613_iso-8859-1 From the FAQ for DB2-L:

"Please do not post messages criticizing other subscribers for making off topic posts. If you feel take a posting was inappropriate, please make your feelings know, in private, to the list owner.

"Most important of all. There is no cause, need or issue so great that it justifies an off topic post. This especially includes pleads for sick and dying children, whose final wish is to set a world's record by receiving the most e-mail, post cards or refrigerator magnets. Do not post any warnings about computer viruses, e-mail that will explode when opened or [...] 15453 13 24_conversion ADABAS to DB221_Haroldo Osorio - Real19_haroldo@REAL.COM.BR31_Wed, 13 Oct 1999 11:01:16 -0700459_- There is a plan to convert we traditional DBMS ADABAS to DB2. So, I'd like to talk with persons that has experience with this. If anybody knows some product that can be used in any kind of convertion. Haroldo Osorio

================================================ 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. 15467 77 24_Re: DB2 User Exit & ADSM11_Hilton Tina15_HiltonT@TCE.COM31_Wed, 13 Oct 1999 11:12:39 -0500425_iso-8859-1 Philip,

I used to work with ADSM on AIX. We had Oracle for the database and used SQL-Backtrack to back up to ADSM. We just scheduled the incremental backup of the box (using the standard ADSM client) to run after the database backup. Of course, that only works if you have the logs in JFS. If you don't use JFS, then I don't know how you would back them up since ADSM won't backup raw logical volumes. [...] 15545 41 49_Re: Moving data across volumes in a storage group15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Wed, 13 Oct 1999 12:16:10 -0400352_ISO-8859-1 I think you can remove the volume from Stogroup and the re-org all the table space on that volume. DB2 will put the dataset on to other volume in the stogroup if there is enough space. Please let me know if there is any other way.

Sibimon Philip 972-702-2515 - Office 972-417-3597 - Residence E-mail - Sibimon_philip@sealand.com [...] 15587 62 49_Re: Moving data across volumes in a storage group18_Sundaresan, Sundar33_Sundar.Sundaresan@SEA.SIEMENS.COM31_Wed, 13 Oct 1999 12:21:03 -0400385_- Sireesh

I have done something similar. Stop the tablespaces and run the following dfdss :

//STEP1 EXEC PGM=ADRDSSU //SYSPRINT DD SYSOUT=* //SYSIN DD * COPY - DATASET( - INCLUDE ( - HLQ.DSNDBC.DBNAME.TSNAME.I0001.A001 - ) - ) - CATALOG - TOL(ENQF) - DELETE - ODY(DBT041) IDY(DBP046) /* //

Where the ODY refers to the volume moved to and IDY the volser from. [...] 15650 132 35_Re: SQL Query Problem (through FTP)15_Wells, Davis B.21_davis.wells@TGSLC.ORG31_Wed, 13 Oct 1999 11:28:28 -0500463_iso-8859-1 Our FTP guru thinks you maybe overlaying one site command with the other. He suggest the following: Quote site db2=dsn1 file=sql

all in one command, unfortunately we are not setup to test any further at this time.

Davis Wells davis.wells@tgslc.org

-----Original Message----- From: Medel Guevarra [mailto:deng777@EMAIL.COM] Sent: Wednesday, October 13, 1999 10:12 AM To: DB2-L@RYCI.COM Subject: SQL Query Problem (through FTP) [...] 15783 60 32_Re: Mixing Type 1/Type 2 Indexes0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 13 Oct 1999 11:28:39 -0500316_us-ascii Running type 1 and type 2 indexes is not an issue. After more than 3 months, I've just finished the last reorg job for our migration to type 2. Most of our indexes were converted to type 2 shortly after we moved to V5, but a few (600 or so) were missed (or maybe converted back to type 1 by accident). [...] 15844 47 28_Re: Migration Step 3 Queries12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 13 Oct 1999 12:10:00 -0400590_- We have run this and have 0 rows returned every time. You may have a problem, contact IBM.

>>> DB2-L@RYCI.COM@inter2 10/11/99 02:49AM >>> Hello List, we are in the process of migrating from DB2 for OS/390 V4 to V5 .In migration step 3, there is a number of queries to be run in order to check catalog tables consistency.These queries are included in member DSNTESQ from SDSNSAMP library. The following query returns a significant number of rows, but i think that the results are expected and normal, mainly because a certain package may be contained in more than one collids. [...] 15892 99 49_Re: Moving data across volumes in a storage group22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Wed, 13 Oct 1999 13:26:20 -0400468_- This will work as long as the tablespace is single volume. If the tablespace is multi-vol, then the DFDSS syntax requires additional options. I can't recall the exact options...there're in the DFDSS manual.

I don't recommend TOL(ENQF) when moving a data set. There should be no ENQ when the tablespace is stopped in DB2. If there is an ENQ on the underlying VSAM file, then I suspect DFDSS's attempt to catalog the VSAM file on the new volume will fail. [...] 15992 122 31_Re: We have a chance to help...12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 13 Oct 1999 10:36:46 PDT711_- I agree with Adrian.

Craig Patton



>From: Adrian Savory >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: We have a chance to help... >Date: Wed, 13 Oct 1999 16:38:18 +0100 > >Mike, > >I disagree. I've just been to the site and all you need to do is click on a >button, not put your hand in your pocket. It takes 10 seconds! > >Anything worthwhile like this is worth publicising everywhere. > >Adrian Savory >ACSIS Ltd > > >______________________________ Reply Separator >_________________________________ >Subject: Re: We have a chance to help... >Author: Michael McCarthy at [...] 16115 41 49_Re: Moving data across volumes in a storage group12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 13 Oct 1999 10:38:21 PDT647_- Sireesh,

REMOVE the volume from the STOGROUP and REORG the objects that use that STOGROUP and have files on the volume.

HTH, Craig Patton DB2 DBA



>From: "Sireesh Chandra.M,J16 Chennai" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Moving data across volumes in a storage group >Date: Wed, 13 Oct 1999 21:42:21 +0530 > >Hi All, > We are using DB2 V5 for OS/390 V2.6. One of the DB2 storage groups >we have has four volumes associated with it. We want to release one volume >from the list and use it for other purposes. That particular volume [...] 16157 36 19_Re: REPAIR DBD TEST12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 13 Oct 1999 12:36:00 -0400543_- We just had the same problem. Ran the rebuild with no problem. Suggest you call IBM support. There are PTFs regarding DBD rebuild, you should make sure you have them on. This is fine if it works, IBM Level 2 told me that worst horror story is rebuild did not work and it took an IBM consultant 200 hours to fix. In our case, the directory was corrupted and catalog was ok. Rebuild creates directory from the catalog. We had to stop DB2 and restart to get true picture of what was going on...TEST and DIAGNOSE were giving false readings [...] 16194 24 31_Re: We have a chance to help...6_RANJAN23_Ranjan.Kotnala@WCOM.COM31_Wed, 13 Oct 1999 11:44:03 -0600343_iso-8859-1 Please stop this now. One or two such mails can be ignored if we do not appreciate them being seen on this forum . Why set in a war on the net? It will be nice if people who have time can look into my question which I posted yesterday. Can all of us in the list expect that this is the last mail with the above subject matter. [...] 16219 141 44_Re: RV: DB2LOOK in the UDB v 5.2 environment11_Scott Hayes24_shayes@DATABASE-GUYS.COM31_Wed, 13 Oct 1999 14:19:10 -0400547_iso-8859-1 db2look is probably hanging because of lock contention. I suspect your value for LOCKTIMEOUT is -1.

db2 get db cfg for DBNAME

...and check the value of locktimeout

db2 update monitor switches using lock on db2 get snapshot for locks on DBNAME

... commands above should help you diagnose the lock contention

Cheers, Scott

I will be presenting "DB2 UDB EE/EEE Design & Performance" at the DB2 Symposium November 8th in NY/NJ. For more information, please visit http://www.db2-symposium.com/ [...] 16361 77 42_Re: DB2 Connect and the Nullid Collection.10_Mann, Tony19_tmann@UTILICORP.COM31_Wed, 13 Oct 1999 12:24:27 -0500658_- Glenn/Tim,

Why are you doing this?

(Pure curiosity!)



Tony Mann Sr. DBA/Utilicorp United, KCMO









> ---------- > From: Mackey, Glenn[SMTP:GMackey@GUIDEMAIL.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, October 12, 1999 10:04 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect and the Nullid Collection. > > I worked around this by executing a BIND COPY into the desired > collection-id > from nullid collection via a batch mainframe job. I did not try and get > the > install process to bind directly other than nullid. > > The second part was to modify DB2CLI.INI for [...] 16439 15 16_Psoft and DB2 V614_Matt Szeszycki22_mszeszycki@WALLACE.COM31_Wed, 13 Oct 1999 13:43:20 -0500366_iso-8859-1 Is anyone running Peoplesoft Financials 7.04.x or earlier on DB2 V6 for OS/390? Thanks in advance, Matt Szeszycki

================================================ 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. 16455 93 49_Re: Moving data across volumes in a storage group10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU31_Wed, 13 Oct 1999 12:09:14 -0700438_us-ascii IBM's DFDSS will do this. So long as the datasets in question are not open, DFDSS will even move them while DB2 is running.

Unless you need the space they are occupying on the current volume, they can be left there even after you ALTER the stogroup. DB2 will reallocate them on the remaining volumes in the stogroup when they are recovered or reorged so long as the REUSE parameter is not used in the parameter card. [...] 16549 148 19_Re: REPAIR DBD TEST12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 13 Oct 1999 21:46:51 +0200615_x-user-defined Hi, All definitions and relations are best explained in the "diagnosis guide". The rebuilt process builds the directory info (dsndb01) from catalog(dsndb06) - so existing is in dsndb01 and rebuilt means what you'll get when you'll rebuilt it.

Rohn.Solecki@MTS.MB.CA wrote: > > Out of curiosity I tried REPAIR DBD TEST on a couple of our DB's (development and production). I got the output listed below. I've looked up the DSN* messages, but don't know enough about DB2 to translate the IBM documentation to figure > what it is trying to tell me. > > Can anyone interpret the DSNU901I and [...] 16698 23 14_Re: Unsubcribe34_=?iso-8859-1?q?Peter=20Pullerman?=22_sevenmessage@YAHOO.COM31_Wed, 13 Oct 1999 13:08:44 -0700485_iso-8859-1 --- Steve Shreeves schrieb: > Please unsubscribe me. > me too.

=====

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 16722 168 19_Re: REPAIR DBD TEST0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 13 Oct 1999 15:26:12 -0500484_us-ascii Thanks Isaac.

The 'diagnosis guide' you mention (and others have mentioned recently) is it a DB2 or OS/390 V2.* specific book? We get IBM Bookreader "Online Library Omnibus Edition, OS/390 Collect" updates on CD-ROM (current updated as of June 99). I've check the table of contents and and detailed listings for DB2 and have not seen a 'diagnosis guide'. I also did a search on the IBM website (http://www.ibm.com/), but did not see any titles that seemed right. [...] 16891 233 19_Re: REPAIR DBD TEST22_Piontkowski Michael ML38_michael.piontkowski@ZCSWILM.ZENECA.COM31_Wed, 13 Oct 1999 16:48:39 -0400757_iso-8859-1 Rohn -

The diagnosis guide is DB2 for OS/390 Version 5 Diagnosis Guide and Reference LY27-9659

BookManager is available as a Licensed Online Book. Its available on BookManager CD-ROM LK2T-9075.





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

> ---------- > From: Rohn.Solecki@MTS.MB.CA[SMTP:Rohn.Solecki@MTS.MB.CA] > Sent: Wednesday, October 13, 1999 4:26 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] REPAIR DBD TEST > > Thanks Isaac. > > The 'diagnosis guide' you mention (and others have mentioned recently) is > it a DB2 or OS/390 V2.* specific book? We get IBM Bookreader "Online > Library Omnibus Edition, OS/390 Collect" updates on CD-ROM (current > [...] 17125 227 19_Re: REPAIR DBD TEST14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Wed, 13 Oct 1999 15:57:33 -0500545_iso-8859-1 No, The Diagnosis Guide and Reference is a completely different book. I don't know the pub number, but it is a "LY" book, ie. it contains licensed material and therefore isn't available from the web interface. Wayne Driscoll Product Developer Quest Software Inc. NOTE: All opinions are strictly my own -----Original Message----- From: Rohn.Solecki@MTS.MB.CA Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Wednesday, October 13, 1999 3:36 PM Subject: Re: [DB2-L] REPAIR DBD TEST [...] 17353 37 32_Re: Mixing Type 1/Type 2 Indexes12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 13 Oct 1999 15:51:00 -0400509_- Don't use REPAIR to remove the recover pending after convert. Should go without saying but it happened here and probably was the reason our directory and catalog got out of SYNC forcing us to do a DBD REBUILD. >>> DB2-L@RYCI.COM@inter2 10/13/99 12:10PM >>> Hi all,

After much procrastination, we are finally ready to convert our V4 indexes to type 2. We're aware of CATMAINT for converting the catalog and directory indexes, and we know we'll have to rebuild other indexes after the conversion. [...] 17391 51 40_Format change for DB2 Messages - PQ3073222_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM29_Wed, 13 Oct 1999 14:30:34 PDT315_- Version 6 of DB2 UDB for OS/390 will receive a minor change this fall to extend the message capacity of the product by supporting longer message numbers. DB2 applications and end users are not affected but there is potential impact for tool vendors or customers which produce their own administrative tools. [...] 17443 35 73_Important message from the List Owners: What to Post and what not to post12_John Morrill12_johnm@VP.NET31_Wed, 13 Oct 1999 17:33:24 -0500567_iso-8859-1 Greetings!

Thank you Mike Holmans for posting straight from the FAQ, which can be find at the address listed at the bottom of all messages.

This list is for discussion about DB2 and DB2 related products. We are very generous in terms of the range of topics concerning DB2. For example, a post about a job opening, a request for guidance about the role of a DBA and a question about how to access a DB2 database from Visual Basic are all acceptable and fit into the mission of this list. We have even had a discussion about the direction [...] 17479 66 29_Re: Updating using substring?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 14 Oct 1999 08:29:27 +1000803_iso-8859-1 Or try set lastname = 'XXXXX' || substr(lastname,5)

Michael Hannan

>>From owner-db2-l@RYCI.COM Wed Oct 13 00:17:32 1999 >Newsgroups: bit.listserv.db2-l >Date: Tue, 12 Oct 1999 15:12:17 +0100 >Reply-To: DB2 Data Base Discussion List >Sender: DB2 Data Base Discussion List >From: Marcus Davage >Subject: Re: Updating using substring? >To: DB2-L@RYCI.COM > >Try >set lastname = 'XXXXX' || substr(lastname,5,80) >(or whatever the length of lastname is) > >Marcus > >-----Original Message----- >From: thomas otway [mailto:otwayc@TENET.EDU] >Sent: 12 October 1999 15:08 >To: DB2-L@RYCI.COM >Subject: Updating using substring? > > >The programmers at our shop would like to use " set >substr(lastname,1,5)='xxxxx' [...] 17546 33 45_DB2 Allocation with Shared Read-only database0_14_DPetro@AOL.COM29_Wed, 13 Oct 1999 19:19:41 EDT627_us-ascii We have observed an interesting phenomenon that seems to have occurred very recently. We have the following setup:

1) DB2 v5.1 2) Shared-Read Only Database 3) Tablespace is Stogroup managed and Stogroup contains 3 volumes 4) Datasets are SMS-managed and SMS Storage Class always resolves to 'Guaranteed Space'

When a tablespace is created (such as during a Reorg Delete/Define), it is allocated such that there is 1 extent on each volume in the DB2 Stogroup and those extents are sized at the PRIQTY. It doesn't matter how many volumes are in the Stogroup, whatever the number, that's the number of [...] 17580 52 46_Mismatching Nullability and Transitive closure14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 14 Oct 1999 10:32:55 +1000490_us-ascii Dear List,

I previously stated that DB2 was very forgiving re joining columns where one side of join is a NULL column and other side is a NOT NULL. Join predicate is still indexable.

However what out for predicates generated through Transitive Closure. These are Stage 2! (not indexable). I have tested it. Perhaps you wondered why DB2 chose a strange join sequence or why less matching columns than expected. This problem brought to my attention by Ric Techow. [...] 17633 17 49_Re: Moving data across volumes in a storage group0_37_SRIRENGAN_VENKATESH_KUMAR@IRAS.GOV.SG31_Thu, 14 Oct 1999 10:49:08 +0800357_US-ASCII Hi,

You could dismil the pack from MVS side and then reorg the affected tablespaces.

Regards

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17651 238 30_DB2 UDB coexisting with Oracle9_Krug, Ken17_Ken.Krug@NIKE.COM31_Wed, 13 Oct 1999 13:47:15 -0700363_iso-8859-1 Our group is developing the plan for a new system and one of the configurations that is being considered is running DB2 UDB 6.1 on the same Unix box where Oracle 8.1.5 is running. The Unix box runs Solaris 2.6. Does anyone have any experience here. I need to find out if there are any issues regarding these two DBMS's coexisting on the same box. [...] 17890 54 23_dsn1copy (small mayday)10_Derek Lund22_derek.lund@UTORONTO.CA31_Thu, 14 Oct 1999 00:21:38 -0400572_US-ASCII I am looking for advice from fellow digesters:

Problem: Users (and managment) have deleted a small amount of "very important" data on a large partitioned table 3 days ago. They REALLY would like to get the data back. (We are on DB2 V4.1)

State of Backups: Have full imagecopies at partition level from 5 days ago and 1 day ago. Have incremental partition imagecopies at 4,3,2 days ago. Ideally want to get the data from the full backup + 2 incremental partition imagecopies but might settle for just full partition imagecopies from 5 days ago. [...] 17945 101 27_Re: dsn1copy (small mayday)14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Thu, 14 Oct 1999 14:46:28 +1000422_us-ascii Derek,

1) First preference: There are 3rd party products (we don't have any of these) which can generate the SQL to roll-out changes. One of these might be able to generate INSERT statements to re-insert the deleted data.

2) Second preference: Use a 3rd party unload tool. For example, BMC's Unload+ allows one to unload (using a simplified WHERE clause) from a full or incremental image copy. [...] 18047 98 27_Re: dsn1copy (small mayday)14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU31_Thu, 14 Oct 1999 14:58:34 +1000323_us-ascii Derek, This is where one of the 3rd party utilities that 'process' the log comes in handy ( BMC/CA/?others?). You could specify the known period and tables and ask it to produce UNDO sql for you, which would be your INSERT statements (problems however, I believe, if the tablespace is defined as compressed). [...] 18146 42 27_Re: Euro IDUG get-together?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 09:15:16 +0100495_ISO-8859-1 I'll be there ... any suggestion on a place / time when to meet?

Leslie Pendlebury-Bowe DB2 OS390 / SAP



______________________________ Reply Separator _________________________________ Subject: Euro IDUG get-together? Author: mike.holmans@BT.COM at Internet Date: 10/13/99 2:08 PM



What with the list server moving and the associated teething troubles, and being on holiday, I haven't seen all that much of the list traffic in the last month. [...] 18189 114 31_Re: We have a chance to help...22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 10:03:11 +0100431_ISO-8859-1 here here... Les



______________________________ Reply Separator _________________________________ Subject: Re: We have a chance to help... Author: Adrian Savory at Internet Date: 10/13/99 4:38 PM



Mike,

I disagree. I've just been to the site and all you need to do is click on a button, not put your hand in your pocket. It takes 10 seconds! [...] 18304 183 16_Re: ARCHIVE LOGS14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Thu, 14 Oct 1999 10:09:35 +0100382_iso-8859-1 I love a question with a QUICK and easy answer!!

In the normal course of events, Log Analyzer does use the BSDS to determine which active/archive logs to process (we do this because it's the only way we can be sure that we are reading the right logs).

But, you do have the option of specifying your own input logs to Log Analyzer if "you know better"! [...] 18488 67 27_Re: Euro IDUG get-together?0_19_mike.holmans@BT.COM31_Thu, 14 Oct 1999 10:18:31 +0100413_- It seems that people would like to have such a get-together, and that no-one has yet arranged one.

My plane is scheduled to arrive in Nice at about 3pm Sunday, so I guess I'll probably get round to registration at about 5pm. If there isn't an announcement there that such a get-together has been arranged, I'll try and see what can be done and then get something put out on the daily announcements. [...] 18556 61 60_Re: Important message from the List Owners: What to Post and22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 10:17:43 +0100405_ISO-8859-1 my apologies for my message earlier "here here" - I only just recieved the follow on mails asking people to stop posting on this subject.

Leslie



______________________________ Reply Separator _________________________________ Subject: Important message from the List Owners: What to Post and wha Author: John Morrill at Internet Date: 10/13/99 5:33 PM [...] 18618 29 21_DSNTIJUZ with DB2 up?11_Tim Blewitt22_timblewitt@HOTMAIL.COM29_Thu, 14 Oct 1999 09:24:10 GMT322_- Fellow DB2 Professionals,

I have been asked to install DDF for some of our DB2 systems and have modified the necessary parameters via the CLIST. Job DSNTIJUZ specifies DISP=OLD for the bootstrap data sets and hence will wait until DB2 is down. Is it safe to code DISP=SHR to update the BSDS while DB2 is up? [...] 18648 274 34_Re: DB2 UDB coexisting with Oracle22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 11:06:26 +0100269_ISO-8859-1 Hi Ken you could try the DB2 E-mail user group . All of us in the group use DB2 UDB (AIX/Solaris,NT etc) and in my opinion is the best single place of information on the subject. It is also monitored by the developers of the product ... which helps ... [...] 18923 114 25_Re: DSNTIJUZ with DB2 up?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 11:15:56 +0100483_ISO-8859-1 Hi Tim, you will get a DSNJ219I message .. infact you will get ;

DSNJ219I DSNJU002 OPEN ERROR, DDNAME=SYSUT1

produced when the DSNJU003 runs against the BSDS to setup the LOCATION, LUNAME etc parameters ....

The manual says about this message (and in my opinion states the obvious) :



3.9.80 DSNJ219I

---------------------------------------------------------------------- ---- DSNJ219I csect-name OPEN ERROR, DDNAME=xxxxxxxx [...] 19038 20 30_Connect to DB2 on NT from Host14_MARINO SAVOLDI23_db2dba@TECHNOLOGIST.COM31_Tue, 12 Oct 1999 17:20:50 +0100433_iso-8859-1 How i can connect an application (running on db2 host) to a db2 v5.2 on NT ? Which catalog tables i must fill ?

Thanks in advance.

Marino Savoldi Banca Lombarda Italy

================================================ 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. 19059 80 27_Re: dsn1copy (small mayday)14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Thu, 14 Oct 1999 12:47:50 +0100411_- Derek,

In the absence of tools this is the best (and only) way to proceed. It also gives people the chance to see what the data is before it's re-inserted.

The inly warning is to make sure you don't DSN1COPY over the real production tablespaces. I know this soubds like a pointless warning, but one of my DBAs once DSN1COPY'd data the wrong way and made a small problem MUCH MUCH bigger!!! [...] 19140 26 27_Re: Online Reorg Parameters0_22_kmulcahy@CHECKFREE.COM31_Thu, 14 Oct 1999 07:48:30 -0400544_us-ascii MAXRO 1 LONGLOG CONTINUE DELAY 0 DRAIN ALL TIMEOUT TERM should be able to keep the no-access suspension period (the beginning of the last log apply phase iteration to the end of the switch phase) short -- less than 30 seconds and probably better. Make sure that your transactions and batch processes commit frequently so they can be drained. A -TERM UTILITY (// IF step.ABEND) step will quickly cleanup an abend, and can reduce -904 "resource unavailable" conditions in all phases except certain nasty abends in the switch phase. [...] 19167 22 13_parallele I/O15_STANLEY GOODWIN29_STANLEY_GOODWIN@MECH.DISA.MIL31_Thu, 14 Oct 1999 07:58:07 -0400514_US-ASCII WHen: That is the question at hand here.

If I have table 'A' in 10 partitions and a secondary index on column C and I ran the query below:



'Select * from A order by C'

Will DB2 choose parallel I/O number of rows aprox 30 million......

================================================ 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. 19190 21 18_People Soft in DB212_Silvia Motta21_silviamotta@YAHOO.COM31_Thu, 14 Oct 1999 05:41:49 -0700474_us-ascii Is anyone running Peoplesoft HHRR 7.5 on DB2 V4 for OS/390? Thanks in advance,



=====

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19212 53 35_Re: Performance Monitoring Question13_Michalik, Ken19_kmichalik@KRAFT.COM31_Thu, 14 Oct 1999 07:52:04 -0500417_- I believe that class 2 times as the part that the sysadm or application DBA can possibly influence. Class 1 ususally is the same as the step execution time, which includes application code and MVS delays.

Even the class 2 elapsed time can be affected by MVS....the sum of class 2 CPU and class 3 wait times times may not be close to the class 2 elapsed time because of things like MVS dispatching wait. [...] 19266 18 23_DBA Training in Atlanta11_Ken Liberty26_KLiberty@CONSULTEC-INC.COM31_Thu, 14 Oct 1999 09:06:16 -0400316_US-ASCII I'm looking for Training oppurtunities in the Atlanta area. I know of Platinum/CA and IBM, but has anyone had any positve experiences with other trainers in the Atlanta area. If so, please let me know how to contact them, so I can gather more information about what kind of training they are offering. [...] 19285 36 20_QMF Reporting Counts11_Ken Liberty26_KLiberty@CONSULTEC-INC.COM31_Thu, 14 Oct 1999 09:05:56 -0400552_US-ASCII I'm trying to generate counts based on a certain value in a column, I remember doing this in the past, but I can't remember how I actually did it... Here's the scenario:



Name Address Emergency Contact -------------------------------------------------------------------------------- -------------------------- J. Smith 123 Apple Avenue M. Stewart M. Mouse 9819 Disney Drive D. Duck 1 Waddle Way S. White ----------- ------------------------- ---------------- 3 2 --> I want a count of those rows which have a value > Spaces [...] 19322 92 23_Re: DB2 V6 enhancements0_18_damcon2@US.IBM.COM31_Thu, 14 Oct 1999 09:55:47 -0400593_us-ascii Kapil,

Take a look at site - http://www-4.ibm.com/software/data/db2/os390/whatsnew/whatv620.htm.

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 878-3525, Tie Line 8-427-3525 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW -----------------------------------------------------



"Loria, Susan C." on 10/13/99 10:33:26 AM

Please respond to DB2 Data Base Discussion List [...] 19415 203 16_Re: ARCHIVE LOGS11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Thu, 14 Oct 1999 07:09:49 -0700645_- Thanks Phil & Leslie....Sounds like a good feature !!! -----Original Message----- From: Grainger, Phil Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Thursday, October 14, 1999 2:12 AM Subject: Re: ARCHIVE LOGS



>I love a question with a QUICK and easy answer!! > >In the normal course of events, Log Analyzer does use the BSDS to determine >which active/archive logs to process (we do this because it's the only way >we can be sure that we are reading the right logs). > >But, you do have the option of specifying your own input logs to Log >Analyzer if "you know better"! [...] 19619 74 40_Re: $ Db2 International language support14_Michael Rooney22_MRooney@COMPUSERVE.COM31_Thu, 14 Oct 1999 10:21:09 -0400327_ISO-8859-1 Thanks for your resonce Bill. I would like to use XML in the near future , but were're at V5 currently and need for internatonal support is within the next 2 months. The application is CICS based. Does anyone have any suggestions or comments about DB2 supporting multi-language tables within one DB2 subsystem. [...] 19694 23 24_Grant Execute on Package0_27_mamccormack@STATESTREET.COM31_Thu, 14 Oct 1999 10:23:34 -0400316_US-ASCII This question will expose some of the gaps in my knowledge of DB2 security.

It is possible to grant execute authority on a plan, and I think I know when to use this. It is also possible to grant execute authority on a package. I don't know when it is appropriate to use this variation on grant. [...] 19718 23 42_Re: Binding Db2 Connect Utilities - OS/39012_Perry Pounds27_Perry.Pounds@DIRECTLINE.COM31_Thu, 14 Oct 1999 15:42:17 +0000611_us-ascii We are currently testing Db2 Connect. I have bound the utilities contained within the DDCSMVS.LST list. We currently grant all authorizations to secondary auth ids (these are RACF groups), however when binding the utilities there would appear to be no way of utilizing secondary auth ids. I have had to grant authorization to the userid that is translated via sysibm.usernames. I could always establish a userid with the same name as one of the RACF groups, attach it to the group in question, bind the utilities and after completion delete the userid from RACF. The question is has anyone manage [...] 19742 90 24_Re: DB2 User Exit & ADSM0_14_dcreed@CSC.COM31_Thu, 14 Oct 1999 09:06:08 -0500373_us-ascii I have done this for archive logs as well. The best book is a Redbook called Using ADSM to Back Up Database SG24-4335 http://www.redbooks.ibm.com/

The actual compile that I used was cc -o db2uexit db2uexit.c -L/usr/lib/adsm/api/bin \ > -IApiDS -l/usr/lib/adsm/api/bin

then turned on the userexit db2 "update db cfg for dbname using userexit on" [...] 19833 17 15_DSNDBM1 Storage12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 14 Oct 1999 10:03:00 -0400357_- How much storage is the dsndbm1 address space using at your site? We are looking at RMF Monitor 3 and viewing the number of page frames being used. We currently use around 300 Meg for Production DB2s and it fluctuates during the day.

Also, does anyone have an idea on when storage gets released when it is no longer in use? Thanks in advance. [...] 19851 29 11_DB2 and HSM15_Jeffery A Price17_jprice@IPALCO.COM31_Thu, 14 Oct 1999 09:07:31 -0500585_us-ascii Hello All,

I am seeking advice/experiences when using HSM to manage DB2 Archive Logs and Image Copies. We want to have HSM migrate archive log datasets and image copies to tape as soon as they are produced, but are concerned with the effects of a massive recovery (if we are ever faced with such a task!). For example, A long running batch job (heavy update activity) with infrequent commits causes db2 to "ARCHIVE LOG QUIESCE" 12 - 16 times (three, 125 Cylinder Active Log Datasets), and there are a large amount of image copies needed. We are concerned that DB2 [...] 19881 56 24_Re: QMF Reporting Counts14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 01:03:43 +1000729_us-ascii To count values > ' ':

SELECT ..., SUM(CASE WHEN COL > ' ' THEN 1 ELSE 0 END) FROM TABLE WHERE ...

From: Michael Hannan

>From: Ken Liberty >Subject: QMF Reporting Counts >To: DB2-L@RYCI.COM > >I'm trying to generate counts based on a certain value in a column, I remember >doing this in the past, but I can't remember how I actually did it... Here's the >scenario: > > >Name Address Emergency Contact >--------------------------------------------------------------------------- ----- >-------------------------- >J. Smith 123 Apple Avenue M. Stewart >M. Mouse 9819 Disney Drive >D. Duck 1 Waddle Way S. White >----------- ------------------------- ---------------- [...] 19938 84 35_Re: Performance Monitoring Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 14 Oct 1999 11:06:53 -0400366_- Ken

I would like to add few points on your answer. There is a slight difference the way CLASS 1 & CLASS 2 CPU time, works for CICS and other attachment facilities.

In CICS -> CLASS 1 - CLASS 2 CPU time usually indicate overhead due to attachment facility and application cpu is not included in CLASS 1 CPU. This means you need to tune your RCT. [...] 20023 107 40_SV: $ Db2 International language support25_Heidorn Sven IT Sundsvall19_Sven.Heidorn@CSN.SE31_Thu, 14 Oct 1999 17:19:23 +0200534_ISO-8859-1 Michael,

I did this for a customer who had sales organizations at different locations in the world. This was some time ago, back when v2.3 was about to be released.

What we did was quite basic actually, all sales orgs where using the same code base going against 7 mirror db's. We bound 7 copies of all packages into 7 different collections, one/database. In the application we issued a SET CURRENT PACKAGESET to retrieve the package from the collection corresponding to the current sales orgs database. [...] 20131 74 34_Re: Connect to DB2 on NT from Host16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Thu, 14 Oct 1999 11:28:56 -0400571_us-ascii Marino,

SNA:

You will need to populate SYSIBM.LOCATIONS with the UDB database alias name as the LOCATION, the UDB TPN name as the TPN, and the partner LU as the LINKNAME. The same partner LU name must first be defined in SYSIBM.LUNAMES. The appropriate VTAM definitions will need to be defined for the partner LU's to talk to each other. On the UDB side, you will need to update the dbm cfg TPNAME parm to the same value as you specified for the TPN on the OS/390 Requester. Make sure the DB2COMM registry variable is set to APPC (db2set -all [...] 20206 52 28_Re: Grant Execute on Package0_21_kramps@NATIONWIDE.COM31_Thu, 14 Oct 1999 11:08:39 -0400472_us-ascii In order to bind a plan that contains packages, the binder must have execute authority on the packages. If the plan being bound includes packages from different collections, then the package owner will need to grant execute authority on the package to the id that is binding the plan. Otherwise, the bind will fail, but I forget what the actual SQL code is when that happens. This is the only case that I'm aware of where grant execute on package is needed. [...] 20259 27 16_00E40030 on load15_Deborah Barrett22_dbarrett@ISS.EBSCO.COM31_Thu, 14 Oct 1999 10:38:39 -0500375_- Hello DB2 list mateys-

We are at V5, service level 9907, vanilla with no 3rd party vendor utilities etc. One of our offsite contract programmers has apparently run a load which is stopped and crashed in some way, although nobody can give me any more info about it, and now they would like to term the utility. When we try to terminate it (for days now), we get [...] 20287 42 19_Re: DSNDBM1 Storage11_Stout, Anne23_Anne.Stout@DOWJONES.COM31_Thu, 14 Oct 1999 11:29:49 -0400578_iso-8859-1 Bob,

Your DBM1 address space includes your buffers, so it will vary depending on the sites buffer size.

Anne Stout

-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Thursday, October 14, 1999 10:03 AM To: DB2-L@RYCI.COM Subject: DSNDBM1 Storage Sensitivity: Personal

How much storage is the dsndbm1 address space using at your site? We are looking at RMF Monitor 3 and viewing the number of page frames being used. We currently use around 300 Meg for Production DB2s and it fluctuates during the day. [...] 20330 70 15_Re: DB2 and HSM22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Thu, 14 Oct 1999 16:48:49 +0100430_ISO-8859-1 Jeffery I have not performed a recovery using HSMed archive logs before.

however, I would assume that DB2 would call for HSM to recall each archive dataset as it needs it during the log apply phase .. this will ofcourse fill up your DASD pool, but you would be at liberty(assuming enough tape drives assigned to HSM, and spare tapes are available) to then HMIG an archive log once DB2 has finished with it. [...] 20401 89 24_Re: QMF Reporting Counts14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Thu, 14 Oct 1999 17:02:44 +0100329_- I tried to resist, but

what ever happend to

SELECT COUNT(*) from table WHERE COL > ' '

I hope it hasn't become compulsory to use CASE expressions whilst I wasn't looking!!

(and by the way, the original question was about QMF edit codes and not SQL, but it's been so long since I used QMF.....) [...] 20491 159 46_Re: inserts into DB2 OS390 with unique indexes14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 02:09:33 +1000592_us-ascii I have a comment on Richard's point 5 "Do not lie to DB2!".

No need for anyone to be too upset by this, but don't be too literal. I basically agree with the point but would express my own view slightly differently as follows:

If modifying DB2 Catlg Stats., do it to improve the Optimizer's understanding of the real nature of the data and not to make it completely misunderstand. The purpose of many stats (e.g. COLCARDF) is to calculate filter factors, so modify those stats to make filter factor calculations more realistic for the way your site uses predicates [...] 20651 102 50_Announcing NEW - Influence join outer table choice14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 02:09:36 +1000360_us-ascii The new technique is known as "Stage 1 Filter Factor Disabler" and looks like: AND (predicate OR A.joincol <> B.joincol) It takes a while to explain why and how.

There are many ways to influence the sequence which DB2 visits tables in a join, or which should be the outer table, including the arrival of DB2 V6 for OS/390 Optimizer Hints. [...] 20754 111 24_Re: QMF Reporting Counts14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 02:20:40 +1000617_us-ascii Phil,

Your solution is fine to count for only 1 column.

My solution is more generic in that it can be used to count No. of non-blanks on several separate columns at once. Original example appeared to have 2 columns counted at least.

From: Michael Hannan

>From: "Grainger, Phil" >Subject: Re: QMF Reporting Counts >To: DB2-L@RYCI.COM > >I tried to resist, but > >what ever happend to > >SELECT COUNT(*) from table WHERE COL > ' ' > >I hope it hasn't become compulsory to use CASE expressions whilst I wasn't >looking!! > >(and by the way, the original [...] 20866 31 12_SQL Question16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 14 Oct 1999 12:25:53 -0400332_iso-8859-1 Hey Folks..

INSERT INTO OWNER.TAB1 SELECT * FROM OWNER.TAB2

TAB1 - new table with 7 columns (last column a 1 byte character data type) TAB2 - old table with 6 columns (Exactly the same as TAB1 EXCEPT for the last column)

It's ok for me to have the last column blank for the existing (old) data. [...] 20898 54 16_Re: SQL Question16_Bachi Allamsetty27_Bachi.Allamsetty@NCMAIL.NET31_Thu, 14 Oct 1999 12:36:08 -0400628_us-ascii Maybe you can modify your query to :

INSERT INTO OWNER.TAB1 SELECT TAB2.COL1, TAB2.COL2, TAB2.COL3, TAB2.COL4, TAB2.COL5, TAB2.COL6, TAB2.COL7, ' ' FROM OWNER.TAB2



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

"Dempsey, Michael" wrote:

> Hey Folks.. > > INSERT INTO OWNER.TAB1 > SELECT * FROM OWNER.TAB2 > > TAB1 - new table with 7 columns (last column a 1 byte character data type) > TAB2 - old table with 6 columns (Exactly the same as TAB1 EXCEPT for the > last column) > > It's ok for me to have the last column blank for the existing (old) data. > > Obviously the above SQL will [...] 20953 115 35_Re: Performance Monitoring Question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 02:34:26 +1000552_us-ascii Venkat,

I slightly vary on one point here, while mostly agreeing very much.

>In CICS -> CLASS 1 - CLASS 2 CPU time usually indicate overhead due to >attachment facility and application cpu is not included in CLASS 1 CPU. This >means you need to tune your RCT.

This overhead (Class 1 - Class 2 CPU) for CICS is mostly a measure of API overhead for calling DB2 and often (for normal behaviour) closely correlates with number of SQLs (DMLs) executed by the transaction(s), as reported by DB2PM Accounting Detail Report. [...] 21069 53 16_Re: SQL Question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 02:39:08 +1000603_us-ascii Michael,

INSERT INTO OWNER.TAB1 SELECT X.*, ' ' AS BLANK FROM OWNER.TAB2 X

will do, I think.

From: Michael Hannan

>From: "Dempsey, Michael" >Subject: SQL Question >To: DB2-L@RYCI.COM > >Hey Folks.. > > INSERT INTO OWNER.TAB1 > SELECT * FROM OWNER.TAB2 > >TAB1 - new table with 7 columns (last column a 1 byte character data type) >TAB2 - old table with 6 columns (Exactly the same as TAB1 EXCEPT for the >last column) > > It's ok for me to have the last column blank for the existing (old) data. > >Obviously the above SQL will not work. [...] 21123 71 53_Re: Triggers / User Defined SQLSTATEs Recommendations12_Janet Rolsma12_janet@NM.NET31_Thu, 14 Oct 1999 10:45:25 -0600467_us-ascii Hi there.

We've set up our SQLSTATEs as just a standard incremented number in the range they say is available. We track what the last used state was (we have a lookup table with primary keys and the like that we use for our incremented keys).

As for the diagnostic text, I find that giving it a meaningful message for each time it's used is very helpful. That way I know exactly where to start looking for the problem when I see the text. [...] 21195 42 34_ODBC- catalog locks - OS/390 db2v40_17_rporco@UOTTAWA.CA31_Thu, 14 Oct 1999 13:41:24 +0000443_US-ASCII Hi, This is the first time I post to the listserve . I hope someone can help me out. Background: We have DB2 Connect enterprise edition V52 db2 V4 going to V5 / os/390

Problem: Locks on the catalog prevent us from perform any DDL on db2 objects. Cause of lock are client-server applications such as Msaccess , Power Builder and the like, EX: SYSIBM.SYSCOLDIST TABLE INTENDED SHARE HELD DSNDB06.SYSDBASE PAGESET SHARE HELD [...] 21238 27 26_Stored Procedures and PL/125_Skelton, Terry (corp) USX21_tskelton.inc@MOOG.COM31_Thu, 14 Oct 1999 13:54:54 -0400518_iso-8859-1 Dear List,

I have a PL/1 program that is compiled with the Language Environment which is calling a stored procedure - but when it executes I receive an sqlcode -471 with a reason code of 00e79006. I have already looked up the error code and reason code but still can not resolve my problem. It is telling me that the program is not initializing the Language Env. correctly -CEEPIPI is the module - I see the CEEPIPI module in my Link edit map - what else must I do? Help is greatly appreciated. [...] 21266 28 28_Need Old Copy of VEWIN95.ZIP0_21_RompotK@SCHNEIDER.COM29_Thu, 14 Oct 1999 17:54:25 GMT309_us-ascii I'm having a lot of trouble getting the latest download of Visual Explain for Windows '95 to work. I had been using the May version successfully but had to download it again (long story). Now it locks up when trying to connect to a database. I tried it with both CAE 5.2 and Runtime Client 6.1. [...] 21295 78 35_Re: Performance Monitoring Question12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 14 Oct 1999 19:58:17 +0200503_x-user-defined Hi, Point is that many times you get complaints about DB2 performance and when you check it you find it's in the application code and then you need to become a politician and decide how to continue as it's not really in your kingdom (maybe you think it is but the project manager or any other application VP etc. think it is not). Part of being a DBA is using internal politics correctly to handle situations like that. Maybe it's a little bit of the thread but it happens too many times. 21374 50 20_Re: 00E40030 on load16_Skrivanek, David28_David.Skrivanek@DOWJONES.COM31_Thu, 14 Oct 1999 14:02:23 -0400307_iso-8859-1 Deborah,

It is possible that the tablespace that contains the table which you are trying to load is stopped. Try displaying the tablespace to verify this. If it is stop mode, start it and you should be able to terminate the utility. This could also be the reason why the load failed. [...] 21425 166 35_Re: Performance Monitoring Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 14 Oct 1999 14:20:07 -0400458_iso-8859-1 Michael

I do not agree with you on this one. May be you could give more info on this to convince me. Please comment on the following experiment -

I ran traces on a thread to find out various CPU charges. I picked up CPU time from CPU header for SQL traces, which is IFCID 59,60,61,65,66 (fetch,select,u/i/d, open,close) and IFCID 58 marks the end of SQL. Next I calculated CPU time for connect & disconnect request (121 & 122). [...] 21592 14 17_What's happening?0_32_Gordon.P.PROUTY@ODOT.STATE.OR.US31_Thu, 14 Oct 1999 11:40:59 -0700463_iso-8859-1 I have not got a mail from the list server other than test or probe messages. Is no one using it anymore or do I need to do something to receive messages again? The last message I got was a probe on 10/12/1999.

================================================ 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. 21607 47 37_DB2 Connect to DB2/OS390 using TCP/IP14_Philip Trbovic19_TRBOVICP@BCBSIL.COM31_Thu, 14 Oct 1999 13:30:29 -0500441_US-ASCII Esteemed Group:

I am trying to connect to a DB2 subsystem using DB2 Connect (version 5.2 fixpack 8) and connecting to and OS390 rel 2.6, DB2 5.1. When ever I try to connect I receive the following error message:

DSNL032I =DL01 DSNLIRTR DRDA EXCEPTION CONDITION IN 493 REQUEST FROM REQUESTOR LOCATION=172.17.225.251 FOR THREAD WITH LUWID=AC11E1FB.G47D.B2FE61EE0112 REASON=00D3101C ERROR ID=DSNLIRTR0001 IFCID=0192 [...] 21655 27 17_Row level locking10_Nash Gupta19_nashgupt@US.IBM.COM31_Thu, 14 Oct 1999 14:36:15 -0400533_us-ascii Hello folks!

I was trying to run an expt. to achieve a row level locking, but couldn't figure out what the problem was. This is what I did.

I turned off the auto-commit feature in the control center (v5.2) and inserted a row in the table X and then I tried to access different row (not the one which I inserted) in the table X from another db2 client. But db2 wouldn't even let me access the table X. It just locks up the entire table. Is it possible to attain a state where db2 would allow other rows to [...] 21683 11 30_Re: Stored Procedures and PL/10_27_Bud.Greenman@ONONDAGA.NY.US31_Thu, 14 Oct 1999 14:48:00 -0400387_- What version of the PL/1 compiler are you using. Stored procedures require PL/1 for MVS 1.0 or higher. OS PL/1, any version, is not acceptable.

================================================ 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. 21695 164 35_Re: Performance Monitoring Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 14 Oct 1999 14:49:21 -0400466_iso-8859-1 Michael

Out of curiosity I picked this from Dave Raiman's tech presentation. He has a diagram showing 1 through 9 activities. CICS CMF CPU = 1+5+9 CLASS 1 CPU = 2+3+4+6+7+8 CLASS 2 CPU = 3+7

The exact words -"Most of the tuning in this presentation will affect the times indicated by number 2,4,6 and 8" "You can estimate the CPU utilization of the attachment overhead with the following formula: (DB2 Class 1 CPU) - (DB2 Class 2 CPU)" [...] 21860 78 38_Re: ODBC- catalog locks - OS/390 db2v40_14_dcreed@CSC.COM31_Thu, 14 Oct 1999 13:43:32 -0500631_us-ascii We were having some problems early and implemented the following for most applications. In the db2cli.ini we specify CURSORHOLD=0 Make sure you isolation level = Read commented (Cursor Stablity..default value) To avoid some catalog contention, we used an indirect copy of the catalog. This was extremely easy for us, since we were using BMC and had already used catalog indirect. We just made alias's of these and pointed to them SYSSCHEMA=SYSADMO There are also some maint that helped to resolve some contention with binds. Basically it down graded the extent of the locks needed to perform that action, forgot what [...] 21939 67 19_Re: DSNDBM1 Storage12_Kirk Hampton16_khampto1@TXU.COM31_Thu, 14 Oct 1999 13:51:57 -0500411_us-ascii I believe EDM pool is also allocated in DBM1. Ours looks to be running about the same as yours, Bob. 220 to 480 meg each on 4 different subsystems, the biggest usage is the one with the most buffers, as Anne said.











"Stout, Anne" on 10/14/99 10:29:49 AM

Please respond to DB2 Data Base Discussion List [...] 22007 66 38_Re: ODBC- catalog locks - OS/390 db2v414_David Williams21_dba-1@DOL.STATE.GA.US31_Thu, 14 Oct 1999 14:56:18 -0400350_us-ascii I am interested in answers to this also. As we have more and more ODBC query tools using our data, we are encountering this problem more often.

Some things that I have done:

Set idle thread timeout in zparms to 900 seconds. This has helped some. You may want a higher or lower value here. Don't know what other sites use. [...] 22074 26 29_Data Encryption in Peoplesoft14_Philip Trbovic19_TRBOVICP@BCBSIL.COM31_Thu, 14 Oct 1999 13:55:04 -0500336_US-ASCII Hello everyone, I have a request from my user area to secure the data within our PeopleSoft database. To the best of my knowledge, there isn't any third party product to encrypt PeopleSoft data within DB2.

How do other companies our there encrypt their PeopleSoft data? Do thy encrypt the data on the network only? [...] 22101 52 32_Re: Need Old Copy of VEWIN95.ZIP12_Myron Miller24_myron_miller@HOTMAIL.COM29_Thu, 14 Oct 1999 11:59:21 PDT370_- I've been using the September version extensively. I'm currently using DB2 Connect 5.2 fixpack 10 to a DB2 5.1 9905+ OS/390 version.

You really want to de-install your May version and then reinstall the September version. The September version fixes many problems in the May version and is much more stable. Don't go back. Its not worth it in the hassles. [...] 22154 58 27_Re: Online Reorg Parameters13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Thu, 14 Oct 1999 15:03:30 -0400510_US-ASCII Hi Ken,

I am interested in your abend check and -term util logic. My concern is what happens if the Reorg fails during the Switch phase. I was able to force an abend with a cc of S04E due to an unavailable resource. This failure has always occurred before the Switch Phase actually started. Therefore, I am having trouble creating a situation where the abend occurs during the Switch Phase so I can test the recovery from this condition. The -term util statement did clean up the utility. [...] 22213 89 38_Re: ODBC- catalog locks - OS/390 db2v40_14_dcreed@CSC.COM31_Thu, 14 Oct 1999 14:15:34 -0500582_us-ascii Opps... good point. Forgot must also set the DSNZPARM CMTSTAT=INACTIVE, This will enable idle threads to be cancellable. To allow the idle thread timeout to work. Regards Danny







dba-1@dol.state.ga.us on 10/14/99 01:56:18 PM

Please respond to DB2-L@ryci.com

To: DB2-L@ryci.com cc: (bcc: Daniel S Creed/HI/CSC) Subject: Re: ODBC- catalog locks - OS/390 db2v4





I am interested in answers to this also. As we have more and more ODBC query tools using our data, we are encountering this problem more often. [...] 22303 23 27_Re: Online Reorg Parameters0_23_Lockwood_Lyon@AMWAY.COM31_Thu, 14 Oct 1999 15:21:39 -0400294_us-ascii To test your recovery from an abend during the switch phase, I'd suggest creating a bunch of extra unneeded indexes on some table in the tablespace. Say twenty or so. Each will have to be renamed during the switch phase, so you'd have plenty of time to force an abend 'manually'. [...] 22327 76 41_Re: DB2 Connect to DB2/OS390 using TCP/IP16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Thu, 14 Oct 1999 15:10:19 -0400368_us-ascii Phil,

Check you DCS Database entry in DB2 Connect. When you catalog dcs db as the must match exactly to the LOCATION specified in the DB2 OS/390 boot strap dataset. Use DSNJU004 with the BSDS as input. Max to the bottom of the output for the DDF record, which will contain the LOCATION. Hope this helps, [...] 22404 42 27_Re: Online Reorg Parameters13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Thu, 14 Oct 1999 15:59:58 -0400446_US-ASCII Lockwood,

Thank you for your help.

I will give that a try.

Burgess Evans

>>> 10/14/99 03:21PM >>> To test your recovery from an abend during the switch phase, I'd suggest creating a bunch of extra unneeded indexes on some table in the tablespace. Say twenty or so. Each will have to be renamed during the switch phase, so you'd have plenty of time to force an abend 'manually'. [...] 22447 147 35_Re: SQL Query Problem (through FTP)13_Deng Guevarra17_deng777@EMAIL.COM31_Thu, 14 Oct 1999 15:17:26 -0700654_- On Wed, 13 Oct 1999 11:28:28 -0500, Wells, Davis B. wrote:

>Our FTP guru thinks you maybe overlaying one site command with the other. >He suggest the following: >Quote site db2=dsn1 file=sql > >all in one command, unfortunately we are not setup to test any further at >this time. > >Davis Wells >davis.wells@tgslc.org > >-----Original Message----- >From: Medel Guevarra [mailto:deng777@EMAIL.COM] >Sent: Wednesday, October 13, 1999 10:12 AM >To: DB2-L@RYCI.COM >Subject: SQL Query Problem (through FTP) > > >Hi, >I am new to the list and I'm not sure whether this is the proper forum to >submit this message. Anyway [...] 22595 33 25_Index vs Tablespace Scans0_20_ddlusk@HOUSEHOLD.COM31_Thu, 14 Oct 1999 16:34:04 -0500393_us-ascii Using DB2V5 OS/390

I need to delete some rows on a table... It has one column as its primary index (clustered) The table has been re-orged, and runstats have been performed.

The table has delete constraint rules with another table...and this is a parent table. The respective rows have been deleted from the child table both tables have approx 45 million rows each [...] 22629 62 41_Re: DB2 Connect to DB2/OS390 using TCP/IP8_Long, Ed15_Ed.Long@FMR.COM31_Thu, 14 Oct 1999 18:13:01 -0400574_- Three questions: 1: Are you sure the port address is 446 on both sides(Connect and DDF)? 2: Do you have the necessary security access (RACF and NT/UNIX)? 3: Can you ping both ways?

> -----Original Message----- > From: Philip Trbovic [SMTP:TRBOVICP@BCBSIL.COM] > Sent: Thursday, October 14, 1999 2:30 PM > To: DB2-L@RYCI.COM > Subject: DB2 Connect to DB2/OS390 using TCP/IP > > Esteemed Group: > > I am trying to connect to a DB2 subsystem using DB2 Connect (version 5.2 > fixpack 8) and connecting to and OS390 rel 2.6, DB2 5.1. When ever I try > to connect I [...] 22692 62 29_Re: Index vs Tablespace Scans12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 14 Oct 1999 15:18:45 PDT301_- Derez,

How many of the rows will be deleted? It is possible that DB2 is not using the index due to more than 60% (somewhere in that range) of the data rows will be accessed, making a tablespace scan more efficient. I don't know if this is your case or not. Any other suggestions, folks? [...] 22755 107 29_Re: Index vs Tablespace Scans0_19_Tim.Lowe@STPAUL.COM31_Thu, 14 Oct 1999 17:31:29 -0500533_us-ascii Derez, How do you know that it is doing a tablespace scan? Is it possible that it is using the index? Just an idea, I hope it helps.

Thanks, Tim













craig patton on 10/14/99 05:18:45 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Tim Lowe/sfm/spc)





Subject: Re: Index vs Tablespace Scans [...] 22863 37 13_IMS LISTSERVs0_32_thomas.e.faglon@BELLATLANTIC.COM31_Thu, 14 Oct 1999 19:12:31 -0400383_us-ascii Neil use this address to send request to subscribe listproc @ lists.missouri.edu

with this in the body of the message subscribe ims-l your name

I just resubscribed today. It works Tom

To: DB2-L @ AMERICAN.EDU cc: (bcc: Thomas E Faglon) From: Neil Hauptmann Date: 09/01/99 07:44:19 PM GMT Subject: IMS LISTSERVs [...] 22901 194 35_Re: Performance Monitoring Question14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Fri, 15 Oct 1999 09:33:53 +1000532_us-ascii Venkat,

Actually I may have used a misnomer by calling it API and not been technically correct. I think it should be called CICS thread sub-task switch time.

Akira Shibamiya quotes and extra 0.2 millisecs of CPU overhead per SQL (on 180J stabdard machine) when CICS processing.

I still believe that this overhead per SQL shows in the difference between Class 1 and Class 2 CPU, and therefore this difference is largely (may be not exclusively) proportional to no. of SQLs executed if all is well. [...] 23096 65 38_Re: ODBC- catalog locks - OS/390 db2v40_15_leon@CA.IBM.COM31_Thu, 14 Oct 1999 19:42:11 -0400387_us-ascii In additional to all other excellent suggestions that you received (CURSORHOLD=0, inactive threads etc. ) you should probably take a look at DB2OCAT utility. DB2OCAT creates a separate catalog(s) that your interactive ODBC/JDBC users can use so they never obtain any locks on the real catalog.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com [...] 23162 101 20_Re: 00E40030 on load0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 15 Oct 1999 08:41:34 +0800438_us-ascii Hi Deborah,

From the V5 manual, it suggests there should be other messages (presumably in MSTR or DBM1 joblog) and/or an SVC dump associated with this problem.

Have a look and see if there are any more clues.... ------------------------------------------------------------------------- 00E40030

Explanation: A -DISPLAY UTILITY or -TERM UTILITY command has failed in the command subsystem. (Oh Duh!!) :} [...] 23264 77 41_Re: DB2 Connect to DB2/OS390 using TCP/IP19_Kassar, Bechir Jose14_JOSEK@IADB.ORG31_Thu, 14 Oct 1999 21:56:44 -0400497_windows-1252 Do you have UNIX Services for OS/390 (OMVS) running? It is required for TCP/IP connection to DB2.

-----Original Message----- From: Long, Ed [mailto:Ed.Long@FMR.COM] Sent: Thursday, October 14, 1999 6:13 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect to DB2/OS390 using TCP/IP



Three questions: 1: Are you sure the port address is 446 on both sides(Connect and DDF)? 2: Do you have the necessary security access (RACF and NT/UNIX)? 3: Can you ping both ways? [...] 23342 127 47_Reverse-engineer catalog statistics collection?9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Thu, 14 Oct 1999 23:03:35 -0400357_iso-8859-1 Environs: DB2/OS 390 V5

We are starting to investigate the use of "enhanced" DB2 catalog statistics to improve access to our DW and other tables. By "enhanced", I mean specifying non-default options for RUNSTATS or the third-party equivalent: TABLE, INDEX, COLUMN, KEYCARD, even use of the DSTATS program and manually inserting data. [...] 23470 52 19_Re: DSNDBM1 Storage15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 14 Oct 1999 03:00:13 -0500278_us-ascii BOB JEANDRON wrote: > > How much storage is the dsndbm1 address space using at your site? We are > looking at RMF Monitor 3 and viewing the number of page frames being used. We > currently use around 300 Meg for Production DB2s and it fluctuates during the > day. [...]