1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2001, week 3 2 72 25_Fw: CALL STORED PROCEDURE19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW31_Thu, 15 Nov 2001 14:26:09 +0800349_big5

----- Original Message ----- From: ´ö˝ŇŞř To: DB2 Data Base Discussion List Sent: Monday, November 12, 2001 11:48 AM Subject: CALL STORED PROCEDURE



HI: 1. Can someone use sql statement call stored procedure: call procedure name using descriptor descriptor-name 2. Can provide cobol sampe program thanks you tang shen yuan 75 17 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Thu, 15 Nov 2001 01:01:58 -0600518_us-ascii I will be out of the office starting 11/14/2001 and will not return until 11/19/2001.

I will be working an alternate schedule on Thursday, November 15th and Friday, November 16th. For immediate DB2 DBA assistance, please contact my backup, Dona Bell, at x2822.

================================================ 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. 93 26 38_2 Problems w/ DB2 6.1 on AIX, A.S.A.P.11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Thu, 15 Nov 2001 14:44:38 +0700292_- Our client's shop is using DB2 6.1 on Aix box. We have a problem when we want to create an automatic increment column to act as the PK on the DB2 tables. How can we do that on DB2 6.1 ? In DB2 7.1 we can use the identity column or a column with formula. How can we do that on DB2 6.1? [...] 120 110 29_Re: Plan Table interpretation41_=?ISO-8859-1?Q?Serdar_Sabri_=D6ZKUBULAY?=29_Serdar.Ozkubulay@AKNET.COM.TR31_Thu, 15 Nov 2001 09:47:55 +0200525_ISO-8859-1 Thanks to all for replys. Actually we already have and use Visual Explain for individual package access path checking, it is really nice. But I want to make batch processing and get some listings according to some criterias from the PLAN_TABLE and DSN_STATEMNT_TABLE.

Regards

Serdar Sabri ÖZKUBULAY, AKNET

-----Original Message----- From: Thomas E. Faglon [mailto:tfaglon@TELCORDIA.COM] Sent: Wednesday, November 14, 2001 8:16 PM To: DB2-L@RYCI.COM Subject: Re: Plan Table interpretation [...] 231 63 29_Re: Plan Table interpretation13_Schulz Thomas20_thomas.schulz@SVI.DE31_Thu, 15 Nov 2001 11:22:23 +0100670_iso-8859-1 http://www-4.ibm.com/software/data/db2/os390/db2ve/

Regrads Thomas

"Sniderman, Karl" schrieb: > > Manoj: > Could you be specific about the web site address where this product is > available? I tried IBM.com and could not navigate to anywhere that knew > anything about "Visual Explain" > > Karl > > -----Original Message----- > From: Veedu, Manoj [mailto:MVeedu@STATE.NM.US] > Sent: Wednesday, November 14, 2001 10:41 AM > To: DB2-L@RYCI.COM > Subject: Re: Plan Table interpretation > > Visual Explain is a good tool to interpret plan table, statement table and > function table rows. Its downloadable for free from IBM web site. > > Manoj [...] 295 19 59_Derez D. Lusk/Household International is out of the office.13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Thu, 15 Nov 2001 05:41:28 -0600541_us-ascii I will be out of the office starting 11/15/2001 and will not return until 11/16/2001.

I will be out of the office today . please call 847-824-2871 and leave detailed message or via HOUSEMAIL - page EMPZ59 Any critical issues Please notify Mars Primary Support HTSMARS - via Housemail

================================================ 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. 315 47 30_UDF and SQL Procedure Language11_Alfred Moos21_moos@FH-HEIDELBERG.DE31_Thu, 15 Nov 2001 13:04:29 +0100466_iso-8859-1 Hello list,

I want to use the SQL procedure statements in programming SQL user defined functions. The language elements I found described in the SQL Reference Volume 2, page 1059 ...

Using the following SQL-statements I was successfull: IF THEN ELSE SET = FOR AS SELECT ... END FOR

No success I had using the following SQL-statements: CASE ... DECLARE CURSOR FOR ... LOOP ... END LOOP REPEAT ... UNTIL ... [...] 363 81 39_Re: DB2 MONITORS FOR UDB RUNNING ON AIX16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Thu, 15 Nov 2001 11:55:29 +0000369_us-ascii Hi Jeff,

nowadays a lot of companies produce monitors for your particular Flavour of DB2, and of course, that's also the case with Candle!

Our Omegamon XE for DB2 UDB on distributed systems went GA a few months ago, and if you'd like to know more about it, please do not hesitate to contact me offline, or your local friendly Candle Rep!!!! [...] 445 55 51_UDF and SQL Procedure Language DB2 UDB V7.2 Windows11_Alfred Moos21_moos@FH-HEIDELBERG.DE31_Thu, 15 Nov 2001 13:16:41 +0100340_iso-8859-1 Hello list,

Please excuse me. In my first e-mail I have forgotten to say that I am using DB2 UDB V7.2 under Windows 2000.

Here my problem: I want to use the SQL procedure statements in programming SQL user defined functions. The language elements I found described in the SQL Reference Volume 2, page 1059 ... [...] 501 22 18_Recovery procedure9_Don Cross20_Don.Cross@TC.FAA.GOV31_Thu, 15 Nov 2001 07:52:18 -0500355_us-ascii We are getting ready for production from research and testing. We are running DB2 v6 on OS390 2.9. We want to test recovery of a dropped database that has several segmented tablespaces with some indexes on the individual tables. We have a full cataloged image copy on tape plus incrementals. I do not know if cataloging is important or not. [...] 524 55 39_Re: DB2 MONITORS FOR UDB RUNNING ON AIX12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Thu, 15 Nov 2001 06:58:46 -0600361_iso-8859-1 We done an evaluation of the monitors out there and found the DataBase-Guys had the best monitor to fit our needs!



Jeff A L'Italien cc: (bcc: Aurora E DellAnno/CAM/Candle) Subject: DB2 MONITORS FOR UDB RUNNING ON AIX 14/11/2001 19:17 Please respond to DB2 Data Base Discussion List [...] 580 105 24_Re: Resource Limit Error11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 15 Nov 2001 08:18:53 -0500353_iso-8859-1 The table layout I use for RLF in DB2 V6 is:

Column Name ColNo Datatyp Length ----1----v----2----v----3----v----4---- AUTHID 1 CHAR 8 PLANNAME 2 CHAR 8 "ASUTIME" 3 INTEGER 4 LUNAME 4 CHAR 8 RLFFUNC 5 CHAR 1 RLFBIND 6 CHAR 1 RLFCOLLN 7 CHAR 18 RLFPKG 8 CHAR 8 RLFASUERR 9 INTEGER 4 RLFASUWARN 10 INTEGER 4 RLF_CATEGORY_B 11 CHAR 1 [...] 686 84 42_Re: 2 Problems w/ DB2 6.1 on AIX, A.S.A.P.15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 15 Nov 2001 09:12:34 -0500599_us-ascii Endy,

Check out the generate_unique function.

HTH, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303

----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - Bavarian Motor Works -----------------------------------------------------







Endy Lambey cc: Sent by: DB2 Subject: 2 Problems w/ DB2 6.1 on AIX, A.S.A.P. Data Base Discussion List [...] 771 68 22_Re: Recovery procedure13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Thu, 15 Nov 2001 06:29:58 -0800364_us-ascii Don,

I don't believe so. There is no guarentee that your newly recreated database and all its objects will have the same IDs. (i.e. OBID).

You will probably have to use DSN1COPY to map the IDs on the Image Copy to the new IDs in SYSCATALOG.

See DSN1PRNT (for getting the old IDs) and DBN1COPY in the Utility Guide and Reference. [...] 840 14 22_Re: Recovery procedure10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Nov 2001 15:30:15 +0100331_us-ascii I guess what happens if xBIDs are not the same, for instance ?

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 855 57 22_Re: Recovery procedure11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Thu, 15 Nov 2001 09:33:33 -0500374_iso-8859-1 I don't think you'll want to do this to a production system, since you would get syscopy out of whack with the rest of the catalog and directory. I'm not even sure it would work, and you would lose information on copies that were done after the recovery point. Plus, the dbid, obid, etc. may not match. Plus you need SYSLGRNX to match. And so on, and so on. [...] 913 58 22_Re: Recovery procedure14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 15 Nov 2001 10:04:28 -0500434_iso-8859-1 Don,

If this is a real concern, prevention is probably the best medicine. Create tables "with restrict on drop" which will not allow the database or tablespace(s) to be dropped until the table(s) is/are altered.



Regards, Scott

-----Original Message----- From: Don Cross [mailto:Don.Cross@TC.FAA.GOV] Sent: Thursday, November 15, 2001 7:52 AM To: DB2-L@RYCI.COM Subject: Recovery procedure [...] 972 63 17_Re: Recover error12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 15 Nov 2001 09:26:00 -0500501_- Check MSGLOG of recover job, you are probably getting a tape error reading the 2nd IC on the tape. DB2 will then automatically fall back to a previous IC. If none was found (deleted by modify), you will get this kind of error. Remember you are dealing with REMOTE ICs only, (RECOVERYDDN) on IC's SYSINs, since DSNZPARM is set to SITETYP=RECOVERYSITE. Have you tried just recovering the 2nd tablespace without any DD statements in the job? This should mount the tape using what DB2 knows about. [...] 1036 29 19_table determination11_Danny Davis16_DTDAVIS@PCMH.COM31_Thu, 15 Nov 2001 10:39:45 -0500448_US-ASCII I received a timeout error on a tablespace datapage. The error message follows. The tablespace in question contains several tables. Can someone please tell me how to map the page number in the error message (X'000096') to it's correct table?

DSNILMCL RESOURCE UNAVAILABLE CORRELATION-ID=PSAPPSRV.exe CONNECTION-ID=SERVER LUW-ID=PCMNET01.SNI00001.07D10B080720=31447 REASON 00C9008E TYPE 00000302 NAME PEA0HHR3.HRAPP6 .X'000096' [...] 1066 105 17_Re: Recover error18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 15 Nov 2001 10:47:59 -0500491_iso-8859-1 Bob: Thanks for the info. Our disaster recovery team has broken down their operation now and heading back. They never did get this application recovered. I'm sure we'll have a post-disaster recovery meeting on this and I'll be sure to pass on any information as to what we find out the problem was/is. I'm also curious to find out what methods they tried to get the recovery to work. To all who responded with your comments and suggestion; THANK-YOU its greatly appreciated. [...] 1172 44 22_Re: Recovery procedure12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 15 Nov 2001 09:57:00 -0500398_- One simple way to recover from a dropped object is take cold (DB2 down) backups, using non-DB2 utilities, nightly and restore the whole DB2 subsystem. But, most shops can't afford the downtime or the loss of transactions. So... I think if you go the route you have described, you will find yourself in a disaster recovery mode and restore the entire DB2 subsystem from before the drop time. [...] 1217 67 42_Re: 2 Problems w/ DB2 6.1 on AIX, A.S.A.P.19_Robert M Collins Jr15_kcollins@WF.NET31_Thu, 15 Nov 2001 10:12:13 -0600485_iso-8859-1 Upgrade the 6.1 database to DB2 V7.1 FP4 which will provide DB2 Sequences. You also must upgrade the clients to the same level as the database. This should be done any way.

You can use a trigger to generate a unique sequence value. I assume the suggestion to use generate_unique is not a option because you want the key values to be uniformed and ascending. The function generate_unique will return a unique random value which may not be good for a primary key. [...] 1285 18 17_Re: Recover error10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Nov 2001 17:22:36 +0100402_us-ascii You're welcome Steve, but let us know what was the problem. I'm just designing a DR recovery procedure.........



Thanks

MAx Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1304 31 7_Redbook12_McKown, John22_JMckown@HEALTHAXIS.COM31_Thu, 15 Nov 2001 08:09:14 -0600514_- This redbook may be of interest.

DB2 for z/OS and OS/390 Tools for Performance Management Revised: November, 10, 2001 More details are available at http://www.redbooks.ibm.com/redpieces/abstracts/sg246508.html





---------------------------------------------------------------------- John McKown HealthAxis

All opinions are my own and are not the opinions of my employer.

Unsolicited telephone calls from vendors are NOT appreciated and tend to upset my management. [...] 1336 69 107_Repost: The IBM e-business Software Strategy (And resources to an swer your underlying technical questions)14_Morrill John M26_MorrillJohnM@JOHNDEERE.COM31_Thu, 15 Nov 2001 10:47:30 -0600617_- Dear DB2 Interested Parties,

Many of you are architecting, designing, building and supporting production intranet, extranet and Internet systems utilizing a variety of technologies and accessing a multitude of back-end DB2 and other data stores, on a variety of platforms. A recently refreshed Website, IBM e-business Software Strategy, at -> http://www.ibm.com/software/ebusiness/ will be of interest to any of you working on such systems. It not only provides a good summary of IBM's e-business software strategy, but includes lots of links for research into specific areas of interest, check it out. [...] 1406 169 17_Re: Recover error0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Thu, 15 Nov 2001 10:27:26 -0600551_us-ascii Hi Steve, One thing that we ran into at one of our DR tests some time back was that we had problems recovering using one of the image copy tapes. What we discovered was that when this particular offsite tape was created, it was REPRO'ing a BK1 backup to a BK2 tape. Unbeknowst to us at the time, this particular REPRO job was missing the RECFM and the LRECL and while the REPRO would successfully finish each time we were unaware that it wasn't usable in a recovery situation. Because it was missing a LRECL and RECFM, this confused DB2 [...] 1576 59 23_Re: table determination16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Thu, 15 Nov 2001 10:06:04 -0700363_us-ascii Danny,

If you run a formatted DSN1PRNT against the page in question, you should see a field labeled PGSOBD containing a hex value for the row's corresponding table. Once you're converted this value to decimal, you should be able to query the catalog for a matching table within the tablespace.

Regards, Jeff L'Italien American Express [...] 1636 16 21_Re: CHECK CONSTRAINTS11_Roger Ghose25_roger.ghose@MTO.GOV.ON.CA31_Thu, 15 Nov 2001 11:01:48 -0600326_- Cindy, Thanks a Million. It works very well.

Much appreciated!

Roger

================================================ 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. 1653 187 27_Re: evaluate statement cost13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 15 Nov 2001 12:15:41 -0600423_iso-8859-1 Actually i think this is just a misunderstanding. I have worked with many folks from non-English speaking background and as you suspect - The phrase "I have a doubt" really means "I am uncertain or I am not sure".

The first time I was presented with a "I have a doubt" to one of my answers I was taken back a bit, but realizing English was the persons second language put things in context a bit ... [...] 1841 61 25_Re: Total sort row length11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 15 Nov 2001 13:29:33 -0500338_ISO-8859-1 Shaun

If you have a 32K work tablespace defined in DSNDB07, it can be used by Sort even if the sort record length does not exceed 4K. I think that DB2 spreads the workload over all available work tablespaces except where the sort record size is greater than 4K, in which case it cannot use the 4K work tablespaces. [...] 1903 32 32_FW: DB2 Record Exclusive Control13_Nguyen, Cindy22_Cindy.Nguyen@OCGOV.COM31_Thu, 15 Nov 2001 10:22:06 -0800550_iso-8859-1 > -----Original Message----- > From: Nguyen, Cindy > Sent: Wednesday, November 14, 2001 5:23 PM > To: DB2-L@RYCI.COM > Subject: DB2 Record Exclusive Control > > Hi , > I appreciate a lot if you can help me to find the solution on DB2 > Record Exclusive Control. > if a batch jobs updates a record in DB2 , all other batch and online > tasks are prevented from reading that record (and possibly any other > record in that records 'page'), until the program issues a commit (usually > the end of the program) or when the program ended. [...] 1936 27 45_SAPR3 with shadow backups and recover LOGONLY11_rick creech18_ykcirc@HOTMAIL.COM31_Thu, 15 Nov 2001 12:43:44 -0600308_- Has anyone done the following with SAPR3 on OS/390. We are DB2 version 6.1:

1. Restore all volumes (except logs and BSDS) to a shadow (or snapshot) backup. 2. Recover all changed tablespaces with LOGONLY to a more current point such as to current. 3. Rebuild or recover all associated indexes. [...] 1964 55 32_Re: DB2 Record Exclusive Control16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 15 Nov 2001 14:24:07 -0500466_iso-8859-1 The most obvious solution would be to have the application COMMIT at a reasonable frequency rather than waiting until program end. Is there a compelling business reason why the program cannot COMMIT?

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Nguyen, Cindy [mailto:Cindy.Nguyen@OCGOV.COM] Sent: Thursday, November 15, 2001 1:22 PM To: DB2-L@RYCI.COM Subject: FW: DB2 Record Exclusive Control [...] 2020 39 33_Re: Online Reorg Abend - DB2 V5.114_Donald A Smith18_dsmithj@US.IBM.COM31_Thu, 15 Nov 2001 14:31:50 -0500728_us-ascii You may scroll the information below UP, DOWN, LEFT, and/or RIGHT as needed -------------------- V=IBM P=DB2 MESSAGES R=V6 I=DSNU099I -------------------- ********************* Text Below Copyright (c) 2001, IBM ********************* DSNU099I csect-name - IRLM 'req-type' REQUEST FAILED, IRLM RETURN CODE = X'return-code' IRLM REASON CODE = X'reason-code' Explanation: The request to the IRLM to obtain or release a lock failed for the reasons specified in return-code and reason-code. In a non data-sharing environment, the requested lock is the utility serialization lock. In a data sharing environment, the requested lock is the utility serialization lock, the utility identifier lock, or the utility execution [...] 2060 62 32_Re: DB2 Record Exclusive Control12_Myron Miller22_Myron.Miller@BMWNA.COM31_Thu, 15 Nov 2001 14:29:05 -0500472_iso-8859-1 I don't see this as a limitation. This locking issue will keep the data integrity.

Options: 1) Have reasonably frequent Commit processing in batch jobs (and this doesn't mean just at end of job but at reasonable time periods). (Personally I think this is by far the best method).

2) Use Uncommitted read for processing. Some potential exposure to reading data that isn't committed and will be backed out. Allows for maximum job interleaving. [...] 2123 89 49_Re: SAPR3 with shadow backups and recover LOGONLY0_20_John_Lendman@FPL.COM31_Thu, 15 Nov 2001 14:32:56 -0500383_us-ascii Rick, I am in the process of trying to get this type of process to work. I have tested it on a small scale and everything worked fine. Then when I did it for real at the DR site, I has some problems.

The main problem that I am running into is that of the RBA in the dataset itself, (HPBRBRBA) that determines how far back DB2 is going to ask for an archive log. [...] 2213 44 36_Re: FW: DB2 Record Exclusive Control7_DB2 DBA21_db2_dba@BELLSOUTH.NET31_Thu, 15 Nov 2001 14:48:47 -0500557_ISO-8859-1 I think you will find that if you establish a standard commit policy to be used by all applications that page level locking is not as restrictive as you think. If batch applications are not performing commits properly, yes you may have a problem. Also, commits should not just be considered based on a unit of work count, but also based on time. If a batch application is swapped out it still holds locks and the unit of work count is not increasing, but if you are also doing commits based on time when the program becomes active again the [...] 2258 161 36_Re: FW: DB2 Record Exclusive Control14_Philip Gunning24_philip.gunning@QUEST.COM31_Thu, 15 Nov 2001 12:27:57 -0800583_iso-8859-1 Cindy, This is not a database limitation but a "feature" to ensure data integrity. It is clear that your shop has no Standard regarding commits. That is really where your problem is. Applications should issue commits based on a number of rows updated (loop counter) or time period. If they don't, you could see rollbacks taking up to 2x as long to backout changes that were not committed. Thus resulting in an even longer period of data unavailability. Also, if you have a long running batch job with no commits and the subsystem crashes you could be down for hours, [...] 2420 120 49_Re: SAPR3 with shadow backups and recover LOGONLY11_rick creech18_ykcirc@HOTMAIL.COM31_Thu, 15 Nov 2001 14:51:46 -0600383_- John, Yes, I would like very much to see your list of steps. Thank you. I do not know how to find out how far back on the log DB2 might need to go for a given tablespace. Perhaps it has something to do when the last time the tablespace was quiesced. There are RBAs in sysibm.syscopy to identify the quiesce. Maybe one of the experts on recovery out there can answer this one. [...] 2541 24 32_Hitachi Shadow Image or Snapshot13_Wheatley, Tom25_Tom.Wheatley@ATCOITEK.COM31_Thu, 15 Nov 2001 13:56:55 -0700420_iso-8859-1 Has anybody had experience using Hitachi's Shadow Image or Snapshot copy to take point in time backups of the DB2 system and possibly the databases? Have you encountered issues, problems?

Thanks.

Tom Wheatley ATCO I-Tek Team Lead, Enterprise Server and Data Center Facilities Bus: (780) 420-5088 Fax: (780) 420-3916 E-mail: tom.wheatley@atcoitek.com [...] 2566 22 16_IDENTITY problem16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Thu, 15 Nov 2001 13:30:00 -0800595_- DB2 for OS390 V6. maint level PDO049. Table with Identity column defined as APPOINTMENT_ID INTEGER GENERATED BY DEFAULT AS IDENTITY,

Some rows existed in the table. A LOAD RESUME was done where the identity column was not specified on LOAD cntl card so DB2 assigned the next value correctly. Then an SQL insert was done where the identity column was not specified and now DB2 assigned a value that was more than 1000 larger than the most recently assigned identity value. There is a UNIQUE index on the identity column. Why wasn't the next identity value assigned in sequence? DB2 [...] 2589 30 32_moving LOB between os390 and udb5_Ramon15_rivasws@AOL.COM31_Thu, 15 Nov 2001 15:21:13 -0600357_- Does anyone know if it is possible to move LOB data back and forth between DB2v6 on OS/390 and UDBv6/7? SPUFI and application programs are dying on BLOB field when we try to access the UDB data from the mainframe. The db2 error message is:

DSNT408I SQLCODE = -351, SQLSTATE = 56084, MISCELLANEOUS SQL OR PRODUCT RESTRICTION FROM OS/2 TOKENS 2 [...] 2620 30 45_what is hash value and how do you convert it?11_Danny Davis16_DTDAVIS@PCMH.COM31_Thu, 15 Nov 2001 16:41:00 -0500368_US-ASCII In reference to the error message below, what is the relevance of HASH VALUE and how do I translate that into something usable?

LOCK TYPE: DATA PAGE RESOURCE NAME: DB=PEA0HHR3 OB=HRAPP6 RESOURCE #: X'0000009600' HASH VALUE: X'01197C96' FUNCTION: LOCK STATE: S DURATION: MANUAL ZPARM INTERVAL: 60 INTERVAL COUNT: 1 REQUESTING WU: 007D008E-0B0C8E08 [...] 2651 56 36_Re: Hitachi Shadow Image or Snapshot13_Daley, Norman24_Norman.Daley@CINERGY.COM31_Thu, 15 Nov 2001 16:54:07 -0500383_iso-8859-1 Tom, We use Shadow Image to do our snaps. I've been told that HDS now calls it "TRUE COPY" instead of Shadow Image. We found a time in the wee hours when we can have a few-minute-long window without any batch processing, suspend DB2 logging, and break the mirrors for the entire complex. Such a much simpler way to do disaster recovery than the old days (last year). [...] 2708 22 32_Re: DB2 Record Exclusive Control13_Nguyen, Cindy22_Cindy.Nguyen@OCGOV.COM31_Thu, 15 Nov 2001 12:01:55 -0800360_iso-8859-1 Hi Myron, 1. I read your recommendations I would like to confirm with you that we will set the uncommitted read for isolation level of batch processing inside the package or plan or inside program? 2. Use Row level locking rather than Page locking, where we will set up the row level locking instead of Page level locking? Thank you very much! [...] 2731 34 20_Re: INDEX ONLY QUERY11_Roger Ghose25_roger.ghose@MTO.GOV.ON.CA31_Thu, 15 Nov 2001 15:45:31 -0600596_- Terry, The following are the catalog statistic for all the indexes:

The query prefers to use the IX1 in production:

NAME CREATOR FIRSTKEYCARD FULLKEYCARD NLEAF NLEVELS ---+---------+---------+---------+---------+---------+---------+--------- IX1 PROD 8443503 20397685 152210 3 IX2 PROD 8592054 21741249 175333 4

The query prefers to use the IX2 in MIRROR image:

NAME CREATOR FIRSTKEYCARD FULLKEYCARD NLEAF NLEVELS ---+---------+---------+---------+---------+---------+---------+-------- IX1 MIRROR 8547706 21301399 126801 3 IX2 MIRROR 8547706 21301399 137429 4 [...] 2766 68 18_Re: unicode and NT12_Scott Fauque19_scott.fauque@CA.COM31_Thu, 15 Nov 2001 15:57:22 -0600425_- There was a pretty good presentation at this years tech conference titled: U29 Application Development with Unicode.

For basic UNICODE undestanding one of the best description and details I've found so far are in Chapter 6 Networking Computing in Redbook 'DB2 UDB Server for OS/390 and z/OS Version 7 Presentation Guide' available here in PDF or HTML format: http://www.redbooks.ibm.com/abstracts/sg246121.html [...] 2835 29 34_QMF Help (QMF3.3, DB2 V6.1, OS390)11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Thu, 15 Nov 2001 14:32:44 -0800407_iso-8859-1 Hi, List. I have a bit of a problem and I'm looking for any assistance. We lost our QMF guru, I can spell it so I'm the new guru. :)



I have a situation where user1 does a select on a table and gets the column headings returned but no data. User2 does a cut and paste of the query into his QMF and the query returns data. Query works fine for me and several of his co-workers. [...] 2865 13 11_unsubscribe13_Sunil Venkata27_svenkata@GWMAIL.STATE.NV.US31_Thu, 15 Nov 2001 15:01:29 -0800257_US-ASCII



===============================================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. 2879 23 30_The migration jobs that follow14_John Hanegraaf22_jhanegraaf@BIGPOND.COM31_Thu, 15 Nov 2001 16:56:30 -0600404_ISO-8859-1 The following procedures are automated for the Common Code table migrations, e.g. MV Catagories etc., any irregular migrations are submitted manually to operations but follow the same process.

1. Backup of target Data.

Uses IBM’s unload program running against the production database, used for rollback should migration fail. e.g. PDBPUMVC

2. Unload of source Data. [...] 2903 64 38_Re: QMF Help (QMF3.3, DB2 V6.1, OS390)12_Raymond Bell17_rbell@NZ1.IBM.COM31_Fri, 16 Nov 2001 11:57:48 +1300297_us-ascii Hi Robert,

Might not be QMF per se. Is the query looking at a view? Does that view have some tricky clauses like verifying the current sqlid is in a list/row in a table somewhere? That might be your best bet. Try to get the DDL of the objects being queried and go from there. [...] 2968 61 20_Re: IDENTITY problem13_Bright, Randy20_Randy_Bright@BMC.COM31_Thu, 15 Nov 2001 17:08:56 -0600384_iso-8859-1 I can't give you a definite on what IBM load is doing, but I can tell you what I have learned from experience. It appears the load utility will start loading IDENTITY values at the next available value in the cache, but when the load is complete, the values remaining in the cache are "lost" and the next INSERT will assign the first value at the next cache interval. [...] 3030 53 32_Re: DB2 Record Exclusive Control10_John Hardy25_john_hardy@ALLIANZ.COM.AU31_Thu, 15 Nov 2001 17:09:06 -0600357_- Binding some packages with an Isolation Level of UR can be very beneficial in many cases. However, you (and your users) need to be aware of the consequences before you do it. Also, depending upon what your programs are doing, it might not help you.

Row level locking is expensive. You need to know in which cases you should consider using it. [...] 3084 60 38_Re: QMF Help (QMF3.3, DB2 V6.1, OS390)14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 16 Nov 2001 10:32:49 +1100336_US-ASCII Is the query on an unqualified name. If so, they could be different tables.

Are you accessing different db2 subsystems?

Is the query on a view with row level security? ( select * from base_view where exists (select 1 from security_table where security_row = base_row and security_row = "allow user access" ) [...] 3145 68 22_Re: Recovery procedure17_Nicholson, Martin20_MNicholson@USSCO.COM31_Thu, 15 Nov 2001 17:33:47 -0600613_- We use Data Definition Control Support (DDCS) to prevent accidental drops. It was available before WITH RESTRICT ON DROP.

> -----Original Message----- > From: BOB JEANDRON [SMTP:BOB.JEANDRON@USDA.GOV] > Sent: Thursday, November 15, 2001 8:57 AM > To: DB2-L@RYCI.COM > Subject: Re: Recovery procedure > > One simple way to recover from a dropped object is take cold (DB2 down) > backups, using non-DB2 utilities, nightly and restore the whole DB2 > subsystem. > But, most shops can't afford the downtime or the loss of transactions. > So... > I think if you go the route you have described, you will [...] 3214 98 40_Re: 2 Problems w/ DB2 6.1 on AIX, Thanks11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Fri, 16 Nov 2001 06:38:23 +0700614_ISO-8859-1 Thank you Robert & Jackson,

*********** REPLY SEPARATOR ***********

On 11/15/2001 at 10:12 AM Robert M Collins Jr wrote:

>Upgrade the 6.1 database to DB2 V7.1 FP4 which will provide DB2 Sequences. >You also must upgrade the clients to the same level as the database. This >should be done any way. > >You can use a trigger to generate a unique sequence value. I assume the >suggestion to use generate_unique is not a option because you want the key >values to be uniformed and ascending. The function generate_unique will >return a unique random value which may not be good for [...] 3313 81 38_Re: QMF Help (QMF3.3, DB2 V6.1, OS390)11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Thu, 15 Nov 2001 16:39:30 -0700404_- Hi, Raymond. Yes the query is looking at a view but it's very simple, SELECT * FROM table, no additional where clauses on it at all. And yes, user1 (actually PUBLIC) has select access on the view............

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Thursday, November 15, 2001 3:58 PM To: DB2-L@RYCI.COM Subject: Re: QMF Help (QMF3.3, DB2 V6.1, OS390) [...] 3395 50 38_Re: QMF Help (QMF3.3, DB2 V6.1, OS390)12_Raymond Bell17_rbell@NZ1.IBM.COM31_Fri, 16 Nov 2001 13:19:10 +1300343_us-ascii OK, so now it's time to check out James' suggestions i.e. are you both querying from the same subsystem? Is the query referencing unqualified objects? Are you sure 'table' in your query is an actual table and not a view/synonym/alias? Get your bucket and spade and start digging, I'm afraid. The truth is out there, somewhere... [...] 3446 82 20_Re: IDENTITY problem14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 16 Nov 2001 11:43:54 +1100340_US-ASCII In this case, where the column is GENERATED BY DEFAULT AS IDENTITY, IBM does not guarantee "an IDENTITY column will not be assigned a duplicate value". If you inserted a row with a given value, DB2 can happily generate the same value - and give the _un_happy user a -803 if there is a unique index violation. [...] 3529 94 48_Los Angeles Area DB2 User Group December Meeting15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Thu, 15 Nov 2001 16:41:14 -0800624_us-ascii The LAADB2UG December meeting: The LAADB2UG is pleased to announce the December meeting and speaker. Several members have expressed interests in the migration, implementation, performance and support of V7. We have designed a sequence of presentations and vendor supported events that will address all the above functions and the tools needed to make it work for both the mainframe and client server environments (NT, UNIX, AIX). It is critical for all of our members to make the effort to attend the monthly meetings to get the most benefit out of these presentations and meet face to face with the fantastic [...] 3624 12 0_13_Olson, Carlos14_COlson@QRS.COM31_Thu, 15 Nov 2001 17:10:27 -0800276_iso-8859-1 SET Carlos Olson NOMAIL

================================================ 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. 3637 20 29_DB2 and WLM Stored Procedures13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 15 Nov 2001 19:12:55 -0600341_US-ASCII Hi, I sent a thread out the other day about RRS and DB2 and got no replies. So I'll try again. Does anyone know what the system overhead is for the RRS sub-system ? I'm running DB2 in a mono-plex CPU environment 9672-R65, OS/390 2.9 and DB2 6.1. Can anyone share your experiences with DB2 a WLM Stored Procedures. Thanks, Kurt [...] 3658 45 52_Trying to create summary table -what's going wrong ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Thu, 15 Nov 2001 20:38:46 -0500669_iso-8859-1 Hi List,

I am trying to create a summary table with the follow command:

create summary table mac.atest_summary as ( select fact_datatype_i from MAC.MAC_FACT_DATATYPE_TB where fact_datatype_i in (1,2,3,4,5) GROUP BY fact_datatype_i ) data initially deferred refresh immediate enable query optimization in mac_d_4k_tsp001 index in MAC_I_4K_TSP001;

And I get the following error: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20058N The fullselect specified for the summary table "MAC.ATEST_SUMMARY" is not valid. SQLSTATE=428EC [...] 3704 114 20_Re: INDEX ONLY QUERY10_James Kwan19_JamesDB2Kwan@CS.COM29_Thu, 15 Nov 2001 22:28:57 EST351_US-ASCII Roger,

Although the index stats are the same, do you know if all column stats have same value? My suspension is the column cardinality is different, ie the filter factor will be greatly affected. I would also be interested to know what values are populated in DSN_STATMNT_TABLE. May be the CPU model will also affect the outcome. [...] 3819 16 49_George Koegel/Rochester/IBM is out of the office.13_George Koegel18_gkoegel@US.IBM.COM31_Fri, 16 Nov 2001 02:32:24 -0500473_us-ascii I will be out of the office starting November 16, 2001 and will not return until November 19, 2001.

If DBDC Performance support is needed Immediately, Please contact my Backup Brian Beahan or my Manager Lauren Pauli

================================================ 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. 3836 26 36_Control blocks in CICS-DB2 interface14_Vamsi G Charan29_vamsicharan@CHENNAI.TCS.CO.IN31_Fri, 16 Nov 2001 13:17:28 +0530401_us-ascii Hi List !

Can any one kindly give the details of 1 How a CICS -DB2 interface is setup ( in terms of control blocks) . 2 What are the control blocks involved and how they communicate with each other,and what happens when a CICS region is brought down?

Any reading material reference in web or text will be highly appreciated.Also any such know-how regarding CICS-MQ series? [...] 3863 30 49_Dean J Burchill/TCC/DCC/DCX is out of the office.0_24_db46@DAIMLERCHRYSLER.COM31_Fri, 16 Nov 2001 04:03:51 -0500790_us-ascii I will be out of the office starting 11/16/2001 and will not return until 11/26/2001.

I will respond to your message when I return.

For emergency reasons only, you can contact my home at (810) 296-2356







****************************************************************************

The information contained in this transmission, which may be confidential and proprietary, is only for the intended recipients. Unauthorized use is strictly prohibited. If you receive this transmission in error, please notify me immediately by telephone or electronic mail and confirm that you deleted this transmission and the reply from your electronic mail system. **************************************************************************** [...] 3894 113 31_DB2 Utilities in Rexx (TSOUTIL)14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 16 Nov 2001 12:11:22 -0000786_iso-8859-1 I'm trying to run Roger Miller's TSOUTIL (see http://jupiter.ryci.com/cgi/wa.exe?A2=ind9912D&L=DB2-L&P=R1133) in Rexx, building up the SYSIN and SYSPRINT dd statements beforehand.

But how do you call it? Address LINK? LINKMVS? ATTACH? "TSOEXEC CALL..."? What? How? Has anyone done this before? If so, HELP!

Thanks!

Marcus





----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 4008 31 46_DB2/Server problem :: anybody had this problem50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Fri, 16 Nov 2001 07:12:16 -0500614_iso-8859-1 NT group recently moved some servers. Appreciate any input: Bob Knight





DSNL032I % DSNLZDJN DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION= FOR THREAD WITH LUWID=DBTWOP2.AMSB1L03.07D10B0F1506=6834 REASON=00D35000 ERROR ID=DSNLZSEA0091 IFCID=0191 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001 DSNL032I % DSNLZDJN DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION=147.154.248.162 FOR THREAD WITH LUWID=DBTWOP2.DBTWOP2.B6BE73679236=6839 REASON=00D35922 ERROR ID=DSNLZSPA003C IFCID=0191 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000002 [...] 4040 168 49_Re: SAPR3 with shadow backups and recover LOGONLY0_20_John_Lendman@FPL.COM31_Fri, 16 Nov 2001 07:20:45 -0500353_us-ascii Rick, a quiesce with write(yes) will update the RBA that is needed for the LOGONLY recovery. But in SAP at my shop we can not do a quiesce because there are too many tablespace. I will put that list together for you I am not sure how soon I can get it to you, since I am on vacation next week, but if not today then some time in December. [...] 4209 23 38_Default Value In UNICODE on DB2/390 V712_Simon George26_simon_x_george@HOTMAIL.COM31_Fri, 16 Nov 2001 12:57:56 +0000 4233 57 32_Re: DB2 Record Exclusive Control12_Myron Miller22_Myron.Miller@BMWNA.COM31_Fri, 16 Nov 2001 08:15:00 -0500425_iso-8859-1 You can set UR at the package level or inside the program. Its your choice. To set at the package level, just bind with UR rather than CS.

For program, use the WITH UR clause on the select level.

Remember that with UR, the data returned is potentially corrupt in that if another program is updating and abends, those updates you read will be backed out. If this risk is acceptable, then use UR. [...] 4291 45 33_Re: DB2 and WLM Stored Procedures12_Myron Miller22_Myron.Miller@BMWNA.COM31_Fri, 16 Nov 2001 08:19:20 -0500307_iso-8859-1 Kurt, I don't have any exact measurements, just a general feel. But from what little I've seen on my client's RRS, the overhead is very minimal, much less than 1%. I think that the amount of CPU used by RRS is lost in the amount used by various other tasks, including less than optimal SQL. [...] 4337 65 56_Re: Trying to create summary table -what's going wrong ?11_David Nance16_DWNance@FHSC.COM31_Fri, 16 Nov 2001 08:23:03 -0500359_US-ASCII Abhijit, I haven't worked with summary tables as yet. The first idea that comes to mind though is the "IN" predicate. Its not allowed in case stmts and some other circumstances. Try making it an and/or condition.

>>> Abhijit.Sinha@GS.COM 11/15/01 08:38PM >>> Hi List,

I am trying to create a summary table with the follow command: [...] 4403 114 36_Re: Hitachi Shadow Image or Snapshot13_Daley, Norman24_Norman.Daley@CINERGY.COM31_Fri, 16 Nov 2001 08:36:19 -0500460_iso-8859-1 Mike, We are on DB2 V5. The SET LOG SUSPEND command and SET LOG RESUME isn't available until V6, but there is a usermod to V5 that does almost the same thing. It modifies the SET ARC command so that SET ARC TIME(0) suspends logging and flushes the log buffers, and SET ARC TIME(1) resumes logging. The only strange thing with the usermod is that updaters do not time out like the SET LOG SUSPEND is supposed to do. They just wait indefinitely. [...] 4518 19 35_Re: DB2 Utilities in Rexx (TSOUTIL)10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 16 Nov 2001 14:41:23 +0100445_us-ascii Try:

"CALL 'your_AUTH_library(TSOUTIL)' 'DB2_SSID,UTILNAME,' "

where utilname= your desired utility (it's a variable). Pay attention to ' and " " (apostophes)

Worked for me.

================================================ 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. 4538 86 35_Re: DB2 Utilities in Rexx (TSOUTIL)17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Fri, 16 Nov 2001 14:31:05 +0100677_us-ascii This looks to work !

ADDRESS TSO "CALL 'MYLIB.AUTHLOAD(TSOUTIL)' 'DSNX,TSOUTIL,'"

Best regards.









"Davage, Marcus" @RYCI.COM> on 16/11/2001 13.11.22

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DB2 Utilities in Rexx (TSOUTIL)







I'm trying to run Roger Miller's TSOUTIL (see http://jupiter.ryci.com/cgi/wa.exe?A2=ind9912D&L=DB2-L&P=R1133) in Rexx, building up the SYSIN and SYSPRINT dd statements beforehand. [...] 4625 31 52_DB2 Connect V7 connection help with inactive threads14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Fri, 16 Nov 2001 07:45:02 -0600606_iso-8859-1 We are using DB2 Connect for the first time with two applications and I'm having an authorization problem.

First,

Application A comes in with Authorization id Y Application B comes in with Authorization id Z

Once the applications returns an answer they go inactive (this is good).

But, if Application B then starts again it trys to use the thread with authorization id Y and fails with a authorization error. Why would application B use that inactive thread? I have to cancel the inactive DDF threads to get it to work. Does any have an idea what is causing the [...] 4657 56 33_Re: DB2 and WLM Stored Procedures11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Fri, 16 Nov 2001 07:47:15 -0600458_us-ascii We are also OS/390 2.9 and DB2 6.1. We run WLM in Goal mode on our DSS machine and it runs okay after some painful days of everyone learning how to use DB2 Stored procedures and WLM. I think how much resources it uses would depend on the workload of the machine. In our case very little. Also we had a few problems when in Compat mode because it requires "user administration", when some jobs abended they did not refresh the WLM Task! ... : ) [...] 4714 201 49_Re: SAPR3 with shadow backups and recover LOGONLY11_rick creech18_ykcirc@HOTMAIL.COM31_Fri, 16 Nov 2001 08:28:49 -0600363_- John, December will be great. I have been looking at the issue at this shop and realize that it needs to be tested thoroughly before a commitment can be made as to its usability in any real recovery scenarios that may arise. I am planning to be testing the process sometime in the next few months, so using your suggested list of steps will be a big help. [...] 4916 43 33_Re: DB2 and WLM Stored Procedures11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Fri, 16 Nov 2001 09:57:27 -0500502_iso-8859-1 I am not sure how we can measure RRS overhead but here is some information that may help you. We have DB2 WLM SPs on a 9672-T26 (243 mips). So far since IPL (about 124 hours) the RRS address space has used 43 CPU seconds a small part of the total cost of the running the SPs. (10,000+ CPU secs) We are running quite a few SPs in 1 test and 1 production DB2 subsystems. Note that RRS can also be used for other things besides DB2 WLM stored procedures, so you need to note that as well. [...] 4960 52 56_Re: DB2 Connect V7 connection help with inactive threads12_Myron Miller22_Myron.Miller@BMWNA.COM31_Fri, 16 Nov 2001 09:59:28 -0500494_iso-8859-1 When application A or Application B get an answer, do they close the result set and close the connection or do they leave the connection open?

Normally, if the connection is actually closed, then the application must connect again with a userid and password that is verified by the security manager at your db2 site. If you're using some type of connection pooling at your DB2 connect user machine, then its entirely possible that this is causing your security problems. [...] 5013 160 35_Re: DB2 Utilities in Rexx (TSOUTIL)14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 16 Nov 2001 15:01:08 -0000571_iso-8859-1 Tried that. I got a 17 *-* ADDRESS TSO "CALL 'G370250.GEN.LOAD(TSOUTIL)' 'ssid,uid,utproc'"

>L> "CALL 'G370250.GEN.LOAD(TSOUTIL)' 'ssid,uid,utproc'" +++ RC(999) +++ when running it.



-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: 16 November 2001 13:41 To: DB2-L@RYCI.COM Subject: Re: DB2 Utilities in Rexx (TSOUTIL)



Try:

"CALL 'your_AUTH_library(TSOUTIL)' 'DB2_SSID,UTILNAME,' "

where utilname= your desired utility (it's a variable). Pay attention to ' and " " (apostophes) [...] 5174 70 40_Re: Control blocks in CICS-DB2 interface0_16_khampto1@TXU.COM31_Fri, 16 Nov 2001 09:46:14 -0600385_us-ascii There is a huge "it depends" qualifying any answer to these questions, with regards to what versions of bith CICS and DB2 you are running. The interface changed significantly between CICS 4.1 and earlier, and CICS Transaction server 1.1 and above. Also, with DB2 v6.1 and above, the interface code ownership changed and is no longer shipped with DB2, it belongs to CICS. [...] 5245 105 20_Re: IDENTITY problem13_Bright, Randy20_Randy_Bright@BMC.COM31_Fri, 16 Nov 2001 09:47:02 -0600380_iso-8859-1 I guess I wasn't too clear in my response. I meant that if DB2 assigns the value, they guarantee it will not duplicate any other value they assign. It is true that if it is "GENERATED BY DEFAULT", the user is responsible for values he/she inserts. A unique index is highly recommended for a "GENERATED BY DEFAULT" column if the application requires unique values. [...] 5351 24 18_Re: unicode and NT12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 16 Nov 2001 09:39:27 -0600500_- My body is still on its way back from Australia. Here's how I'd phrase the sound byte.

Unicode is in the present for many customers, even when they don't know it. Java uses Unicode. EBCDIC and ASCII platforms are moving to Unicode and using Unicode for more effective translations. Unicode support is in DB2 for UNIX & Windows V6, DB2 for z/OS & OS/390 V7, OS/390 V2R8, and in the z/Architecture & zSeries instruction set. So you will be moving to Unicode, if you're not already there. [...] 5376 59 32_Directory COPY/RECOVERY question9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Fri, 16 Nov 2001 16:38:13 +0000615_us-ascii This is probably one for somebody at IBM (Dan Courter or Chris Munson?)

One of my fellow DBAs was attempting to recover SYSUTILX TOCOPY. The job ran for hours before it was cancelled and MSTR was prompting for archlogs from way before the copy was taken. He hadn't specified the TOVOLUME CATALOG parameter. The syntax diagram in the manual shows that the parameter isn't mandatory and the relevant text is a bit unclear, is the parameter actually required? Prior to me discovering that the recover works fine with the TOVOLUME parameter specified, I ran DSN1LOGP against the archlogs because I [...] 5436 34 35_Re: DB2 Utilities in Rexx (TSOUTIL)10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 16 Nov 2001 17:49:03 +0100499_us-ascii I'm VERRRY sorry...the correct syntax is:



"CALL 'your_apf_auth_lib(TSOUTILB)' 'DB2_ssid,utility_id' "

where:

your_apf_auth_lib an APF-authorized library

DB2_ssid your DB2 identifier

utility_id the utility identifier (may be Furlong, Playmate or every name you desire)

TSOUTILB and TSOUTIL must be declared in SYS1.PARMLIB in IKJTSOxx member (under AUTHPGM and AUTHTSF sections). I tested it 2 secs ago.

Sorry for the mistake... [...] 5471 66 56_Re: DB2 Connect V7 connection help with inactive threads14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Fri, 16 Nov 2001 10:50:09 -0600411_iso-8859-1 Pooling is not being used.

-----Original Message----- From: Myron Miller [mailto:Myron.Miller@BMWNA.COM] Sent: Friday, November 16, 2001 8:59 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect V7 connection help with inactive threads



When application A or Application B get an answer, do they close the result set and close the connection or do they leave the connection open? [...] 5538 46 56_Re: DB2 Connect V7 connection help with inactive threads13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 16 Nov 2001 10:59:00 -0600438_US-ASCII Hi Al, If you are using the access control authorization exit (DSNX@XAC) look at PQ43169 this is a match to your problem discription. HTH Kurt



>>> Al_Zobjeck@TTX.COM 11/16/01 07:45AM >>> We are using DB2 Connect for the first time with two applications and I'm having an authorization problem.

First,

Application A comes in with Authorization id Y Application B comes in with Authorization id Z [...] 5585 83 16_Re: COBOL Arrays14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Fri, 16 Nov 2001 12:13:19 -0500538_us-ascii You can check the "IN Predicate" section of the SQL Reference Vol 1 [Version 6.1]. Example 4 shows a structure of host variables in the IN ( ) list. With some cleverness you can overlay the structure with an array in COBOL: see the REDEFINES clause in COBOL. Parse the input into the array within a loop, moving the PIC XXX numbers to the PIC COMP array. If there is a variable number of input values you have two choices: pad the unused IN ( ) list values with the last value (as previously suggested); or have a series of [...] 5669 33 34_auto-execute a SP at db2 startup ?0_24_lightsey@ITS.STATE.MS.US31_Fri, 16 Nov 2001 11:20:07 -0600576_us-ascii One of my users thinks that he needs a stored procedure or trigger to automatically fire immediately after db2 subsystem startup/restart to load a set of tables into the bufferpool and save his first victim/user the i/o delay associated with loading this ridiculous look-up table. I've suggested that he have CA/OPS handle this but his boss wants db2 itself to do this. I've also not found anything in the manuals, on IBMLink , or elsewhere online that would suggest that db2 can automatically trigger a SP ( kind of like the cics plt ). Does any one have a way [...] 5703 119 35_Re: DB2 Utilities in Rexx (TSOUTIL)17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Fri, 16 Nov 2001 18:34:19 +0100432_iso-8859-1 If I'm not wrong you have to:

1) call the load module from an APF auth library (u have to linkedit it with the AC=1 option) 2) insert into the IKJEFTxx member of PARMLIB the TSOUTIL and TSOUTILB

Best regards.









"Davage, Marcus" @RYCI.COM> on 16/11/2001 16.01.08

Please respond to DB2 Data Base Discussion List [...] 5823 53 60_Is this legal? Embedded SQL in an External UDF written in C?0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 16 Nov 2001 11:32:29 -0600395_us-ascii I have a question about what is legal in an external UDF written in C and possible work-arounds.

I know that an SQL Scalar UDF can be created with the READS SQL DATA option, and that it can contain an SQL "SELECT" statement and return that data. However, we need to create a UDF that does some manipulations best accomplished using a programming language (in this case, C). [...] 5877 223 49_Re: SAPR3 with shadow backups and recover LOGONLY14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Fri, 16 Nov 2001 11:40:48 -0600507_iso-8859-1 I use the BMC Copy Plus product for SAP and it creates multiple groups (or jobs) that run at one time. I use "FULL YES" for full copy and "SHRLEVEL CHANGE" and this runs nightly. At the DR I then use BMC Recovery Manager and Recover Plus which use the groups to create mulitple jobs to bring back my data. Because I do full copies on a nightly basis I always have the logs that I need. As a mater of fact you can define in Recovery Manager how many logs you want to put on disk so tapes can [...] 6101 91 64_Re: Is this legal? Embedded SQL in an External UDF written in C?16_Michael McCarthy18_mmccarthy@DTCC.COM31_Fri, 16 Nov 2001 12:55:04 -0500553_us-ascii Hi Steve,

I have a UDF written in C that selects a row from a table, and returns the result. I have defined my UDF as READS SQL DATA. I move the host variable to my return argument without changing it. I don't see any reason why you wouldn't be able to manipulate the variable in your UDF before returning it. My UDF reads a table of "logical" to "physical" remote DB2 locations. We use this for programmers using the connect statement so that they don't have to hard code locations when moving code to another subsystem. My UDF is [...] 6193 27 74_Addition to "Is this legal? Embedded SQL in an External UDF written in C?"0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 16 Nov 2001 12:42:56 -0600512_us-ascii Sorry, I forgot to mention our platform: DB2 UDB EEE 7.2 on AIX 4.3.3.0.

Steve Westfall Equifax, Inc.







This message contains information from Equifax, Inc. which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster@equifax.com. [...] 6221 26 49_Re: SAPR3 with shadow backups and recover LOGONLY0_20_John_Lendman@FPL.COM31_Fri, 16 Nov 2001 14:03:51 -0500535_us-ascii A.J. What you describe here is not a LOGONLY recovery.

If you use the image copies as input to your recovery, then the log does take part, but it is not a LOGONLY recovery. In a LOGONLY recover, it bypassed using any image copy of the dataset, it assumes that you have already restored the dataset with some type of utility. It then uses the RBA in the header of the dataset to find which archive log it needs to do the recovery of that dataset. Once it finds the archive log it does FAST LOG APPLY and bring that [...] 6248 15 48_can an Identity column be used as a foreign key?15_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 16 Nov 2001 14:49:04 -0500371_iso-8859-1 Hi, we are on DB2 V6 OS/390. Can an Identity column be the parent in a foreign key?

thank you for your response

================================================ 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. 6264 20 14_New at BLOB's.29_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Fri, 16 Nov 2001 15:14:44 -0500548_us-ascii I have successfully create a LOB table but I can't seem to get it loaded, can some one offer a sample of a load program for images. I am trying to use DB2IMAGE via SQL but not much luck.

Any samples or help would be greatly appreciated.

Dave Cronin dcronin@bpd.treas.gov 304-480-6639

================================================ 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. 6285 96 15_UDB NT Security12_Collier, Mel21_MCollier@TXFB-INS.COM31_Fri, 16 Nov 2001 14:35:28 -0600534_iso-8859-1 We are currently in the process of setting up our DB2 UDB security on the NT platform. We are curious how others are applying security, both on the application level and on the individual user level?

We currently have all access removed from the public usergroup, except for some select access. We have also added one individual DB User and are somewhat satisfied with the access that user has. Also, on the individual level, how are you tracking individuals who have the authority to update table information? [...] 6382 86 56_Re: Trying to create summary table -what's going wrong ?14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Fri, 16 Nov 2001 15:37:54 -0500620_iso-8859-1 David,

I tried by not using the "IN" predicate. Instead used : fact_datatype_i = 1. This does not work either and gives the same error.

Thanks,

Abhijit

-----Original Message----- From: David Nance [mailto:DWNance@FHSC.COM] Sent: Friday, November 16, 2001 8:23 AM To: DB2-L@RYCI.COM Subject: Re: Trying to create summary table -what's going wrong ?



Abhijit, I haven't worked with summary tables as yet. The first idea that comes to mind though is the "IN" predicate. Its not allowed in case stmts and some other circumstances. Try making it an and/or condition. [...] 6469 18 20_Re: INDEX ONLY QUERY8_Harish G24_hari_gangadhar@YAHOO.COM31_Fri, 16 Nov 2001 14:16:25 -0600496_- Hi Roger,

In your original post I notice that the length of the COL2 column is different between the two index definitions. Was that a typo ? If not, was that "corrected" when you did the test on the MIRROR tables ?

Thanks,

Harish.

================================================ 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. 6488 41 52_Re: can an Identity column be used as a foreign key?13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Fri, 16 Nov 2001 13:35:22 -0800467_us-ascii Hi Stephen,

Yes.

Tink --- "Neff, Stephen R" wrote: > Hi, we are on DB2 V6 OS/390. Can an Identity column > be the parent in a > foreign key? > > thank you for your response > > ================================================ > 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. [...] 6530 65 56_Re: Trying to create summary table -what's going wrong ?19_Pascal-Marc Gelinas30_pascal-marc.gelinas@WANADOO.FR31_Fri, 16 Nov 2001 18:12:57 +0100691_iso-8859-1 Don't you need something like a avg(), sum(),... ?

PM

----- Original Message ----- From: "Sinha, Abhijit" Newsgroups: bit.listserv.db2-l To: Sent: Friday, November 16, 2001 2:38 AM Subject: Trying to create summary table -what's going wrong ?



> Hi List, > > I am trying to create a summary table with the follow command: > > create summary table mac.atest_summary > as > ( > select fact_datatype_i > from MAC.MAC_FACT_DATATYPE_TB > where fact_datatype_i in (1,2,3,4,5) > GROUP BY fact_datatype_i > ) > data initially deferred > refresh immediate > enable query optimization > in mac_d_4k_tsp001 > index in [...] 6596 83 42_Re: Default Value In UNICODE on DB2/390 V714_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 17 Nov 2001 11:20:40 +1100 6680 118 64_Re: Is this legal? Embedded SQL in an External UDF written in C?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 17 Nov 2001 16:01:49 +1100539_US-ASCII Although Steve didn't say so, his problem description is consistant with DB2 for Windows etc (and inconsistant with DB2 for OS/390).

Not that it helps produce a work around.

James Campbell



On 16 Nov 2001, at 12:55, Michael McCarthy wrote:

Date sent: Fri, 16 Nov 2001 12:55:04 -0500 Send reply to: DB2 Data Base Discussion List From: Michael McCarthy Subject: Re: [DB2-L] Is this legal? Embedded SQL in an External UDF written in C? To: DB2-L@RYCI.COM [...] 6799 15 55_Elizabeth F. Brune/0Q/Caterpillar is out of the office.18_Elizabeth F. Brune25_brune_elizabeth_f@CAT.COM31_Sat, 17 Nov 2001 03:02:00 -0600459_us-ascii I will be out of the office from 17Nov2001 until 26Nov2001.

If you need immediate DRM/Database Administration service, please contact Mike Roling (6-3146), Keri Girard (6-3091) or Dan Parsons (6-3665).

================================================ 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. 6815 43 18_Re: New at BLOB's.12_leila rahimi21_lshosaini@HOTMAIL.COM31_Sat, 17 Nov 2001 11:24:12 +0000395_- hi,i had ur problem ,,,then i searched in list server archive,there was a sample in java language,,,,,if u use os/390 ,,,u can use system samplib,there is an example in c language....for load in a blob,,,,,,i think ur question about db2image type is about select it through sql,,,,u must use content keyword before that column name,,,,,,, i hope my exprience will be useful.....bye leila [...] 6859 33 52_Re: can an Identity column be used as a foreign key?12_tim malamphy20_timalamphy@YAHOO.COM31_Sat, 17 Nov 2001 13:23:51 -0800496_us-ascii Not sure about OS/390, but it will work on AIX v7.x systems. Tim --- "Neff, Stephen R" wrote: > Hi, we are on DB2 V6 OS/390. Can an Identity column > be the parent in a > foreign key? > > thank you for your response > > ================================================ > 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. [...] 6893 50 12_Re: Prefetch19_Pascal-Marc Gelinas30_pascal-marc.gelinas@WANADOO.FR31_Sat, 17 Nov 2001 19:49:33 +0100537_iso-8859-1 The optimizer may consider the statistics as invalid/corrupt in certain situations. When there is not enough rows is one case (if i remember correctly). The optimizer may instead choose defaults. Just like when runstats has never been issued against a certain table. (-1 in some columns)

PM





----- Original Message ----- From: "Walter Janissen" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, November 14, 2001 8:48 AM Subject: Re: Prefetch [...] 6944 50 38_please speak english - not teen - here15_Melvin Demmicks25_melvin_demmicks@YAHOO.COM31_Sat, 17 Nov 2001 20:44:17 -0800405_us-ascii Hello Leila, Thanks for your post.

It's a small matter but I, for one, think you'd have more credibility here if you wrote as if this were a professional technical forum, not a teen chat room.

ur is spelled *your* or *you're*(and it's significant to know the difference); u is spelled *you*. Some also consider that using all lowercase is almost as tasteful as using all CAPS. [...] 6995 47 52_Re: Testing SQLJ stored proc using Procedure Builder13_Greg Farquhar25_Greg_Farquhar@BIGPOND.COM31_Mon, 19 Nov 2001 10:31:09 +1100367_Windows-1252 I haven't done this yet myself so I am guessing a little. Your JAR does not contain the serialized profile. The class loader is complaining. I think that the jar file is deployed from your workstation to the catalog. It will need to contain all your class files and the serialized profiles. This will include class files for iterators and contexts. [...] 7043 70 17_Re: JDBC vs SQLJ?13_Greg Farquhar25_Greg_Farquhar@BIGPOND.COM31_Mon, 19 Nov 2001 10:31:29 +1100412_iso-8859-1 Mohammad,

I agree in part with your comments. However it is still like attempting to stop a steam train with a marshmallow.

Even Gartner Says Companies Overspent $1 Billion on Application Server Technology in the past year and an additional $2 Billion May Be Wasted Over Next Two Years. See http://www4.gartner.com/5_about/press_releases/2001/pr20010820b.html

Another quote: [...] 7114 26 32_Re: DB2 Record Exclusive Control10_John Hardy25_john_hardy@ALLIANZ.COM.AU31_Sun, 18 Nov 2001 17:44:03 -0600574_- Myron,

"Also, I disagree with the flat statement that Row level locking is more expensive than Page level locking. It depends."

I do not think that I flatly stated that Row level locking is more expensive than page level locking, merely that it is expensive. Perhaps in hindsight I should have said that Row Level locking CAN BE expensive. I know (just;)) enough about DB2 to know that there are very few things that can be said about DB2 without needing to be qualified in some way. The trouble is that it takes a lot of experience to fully comprehend [...] 7141 100 16_Bind permissions13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Mon, 19 Nov 2001 12:52:10 +1100669_iso-8859-1 Fellow listers,

I sent this to the other list(DB2EUG) but got no response so I am trying here as it relates to os390 anyway...

Steve T -----Original Message----- From: TENNANT Steve (EDS) Sent: Tuesday, 13 November 2001 11:04 AM To: 'db2eug@lists.best.com' Subject: DB2EUG: FP4 and bind permissions





G'day,

I just installed FixPack 4 onto udb 7.2 and hit a small problem when running the bind to the mainframe (ddcsmvs.lst). I got a permissions error (ssyid.NULLID.SQLABD01. SQLSTATE=42501). I can easily fix the problem by giving my userid the permission as I have SYSADM but that is my question....If I am a [...] 7242 26 32_Re: DB2 Record Exclusive Control29_=?iso-8859-1?q?Half=20Eaten?=24_half_beaten@YAHOO.COM.AU31_Mon, 19 Nov 2001 13:31:44 +1100554_iso-8859-1 Warning. Be careful approaching this man! Half'

--- John Hardy wrote: > Myron, > Haven't we all been approached at some point ... >



http://shopping.yahoo.com.au - Yahoo! Shopping - Get organised for Christmas early this year!

================================================ 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. 7269 23 41_Borland C++ with Stored Procedure Builder29_=?iso-8859-1?q?Half=20Eaten?=24_half_beaten@YAHOO.COM.AU31_Mon, 19 Nov 2001 13:38:19 +1100565_iso-8859-1 Hi Folks, Has anyone got Borland's free C++ compiler (http://www.borland.com/bcppbuilder/freecompiler/) working with the Stored Procedure Builder? If so, would you mind sharing the details?

Regards, Half'

http://shopping.yahoo.com.au - Yahoo! Shopping - Get organised for Christmas early this year!

================================================ 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. 7293 55 42_Re: please speak english - not teen - here29_=?iso-8859-1?q?Half=20Eaten?=24_half_beaten@YAHOO.COM.AU31_Mon, 19 Nov 2001 13:44:02 +1100324_iso-8859-1 Melvin, Have you stopped taking your medication ... or are ya just pullin' our chains? Half'



Hello Leila, Thanks for your post.

It's a small matter but I, for one, think you'd have more credibility here if you wrote as if this were a professional technical forum, not a teen chat room. [...] 7349 24 16_Reorg parameters7_db user20_dbuser75@HOTMAIL.COM31_Mon, 19 Nov 2001 02:41:21 +0000494_- Hi List,

I have a question about Reorg parameters MAXRO,LONGLOG and DELAY parameters.What these parameters do during Reorg and how these parameters affect the reorg process,can any of the list members explain in detail about these parameters and how it should be implemented for minimum downtime of application.

Thanks Kumar

_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp [...] 7374 18 11_UNSUBSCRIBE12_E, Sivakumar29_Sivakumar.E@BLR.HPSGLOBAL.COM31_Mon, 19 Nov 2001 11:15:33 +0500519_- UNSUBSCRIBEWARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you.----------------- HCL Perot Systems [...] 7393 23 19_DB2 for Linux tools8_dba dbat17_dbathai@YAHOO.COM31_Sun, 18 Nov 2001 23:06:10 -0800510_us-ascii Hi all, Are there any data warehouse tools or tools(reorg ,unload etc.) on DB2 for Linux?

Thanks, Davis



__________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.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. 7417 20 41_DB2 UDB for Sun Solaris . OS Tuning parms9_SrinivasG18_SRINIVASG@INFY.COM31_Mon, 19 Nov 2001 13:29:46 +0530438_iso-8859-1 Hi,

Has anyone done OS tuning to improve DB2 performance on Sun Solaris or has a document that has details for the same ? Please pass on the Info to me .

Regards, Srinivas G

===============================================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. 7438 98 17_Re: JDBC vs SQLJ?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 19 Nov 2001 19:29:39 +1100535_US-ASCII Co-incidently the next message I read contained this: "How is it that EJBs have become synonymous with J2EE in the minds of so many people? One answer is the natural tendency of software vendors to try to sell you the most expensive product. Is a commissioned salesperson going to sell you an inexpensive servlet/JSP solution if he or she can convince you to buy an "enterprise" application server (with EJB!) for 10 times as much? The tendencies of human nature should make the answer to that question fairly obvious. " [...] 7537 26 58_Return Result Set from a Stored Procedure to a Cobol Prog?11_Mina Gohari23_mgohari@DPI2.DPI.NET.IR31_Mon, 19 Nov 2001 12:24:25 +0330334_US-ASCII Hi to all,

I have a stored Procedure which returns a result set. I have declared a cursor in stored procedure and opened it.

in caller program(cobol, The Stored procedure have been called and after that Associate and Allocate cursor and fetch the data. My problem is : it returns the data in wrong format. [...] 7564 18 52_Re: can an Identity column be used as a foreign key?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 19 Nov 2001 10:11:32 +0100390_us-ascii According to the new Red Book

'DB2 for z/OS Application programming topics'

it's one of the suggested usage

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7583 69 42_Re: please speak english - not teen - here12_leila rahimi21_lshosaini@HOTMAIL.COM31_Mon, 19 Nov 2001 09:53:38 +0000626_- Hello, Thanks for your post. bye.

>From: Melvin Demmicks >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: please speak english - not teen - here >Date: Sat, 17 Nov 2001 20:44:17 -0800 > >Hello Leila, > Thanks for your post. > >It's a small matter but I, for one, think you'd have >more credibility here if you wrote as if this were a >professional technical forum, not a teen chat room. > >ur is spelled *your* or *you're*(and it's significant >to know the difference); u is spelled *you*. >Some also consider that using all lowercase is almost [...] 7653 44 20_AW: Reorg parameters12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 19 Nov 2001 11:00:21 +0100509_iso-8859-1 Kumar,

just a very short description....

MAXRO specifies the amount of time for the last iteration of log processing for the online REORG. Specifying a small positive MAXRO value reduces the length of the period of read-only access - but it might increase the elapsed time for your REORG to complete.

LONGLOG designates how DB2 will react if the number of records that the next log processing iteration is not lower than the number that the previous iterations processed. [...] 7698 61 62_AW: Return Result Set from a Stored Procedure to a Cobol Prog?12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 19 Nov 2001 11:09:49 +0100504_iso-8859-1 Mina,

Some time ago I heard that MVS applications (that display ASCII encoded data) actually receive the data as EBCDIC.

But these MVS applications sort the data using the ASCII collating sequence.



May that be the reason for your "data in wrong format" ?

With kind regards - mit freundlichen Grüssen, Georg H. Peter ---------------------------------------------------------------------- All opinions are my own and are not the opinions of my employer. [...] 7760 39 20_Re: Reorg parameters0_24_Bruce.Williamson@PSIR.IE31_Mon, 19 Nov 2001 04:18:06 -0600846_- Howzit Kumar?

have a look at: http://publibz.boulder.ibm.com/cgi- bin/bookmgr_OS390/BOOKS/DSNUG0G3/2.16 This has all the info you require.

Cheers Bruce



On Mon, 19 Nov 2001 02:41:21 +0000, db user wrote:

>Hi List, > >I have a question about Reorg parameters MAXRO,LONGLOG and DELAY >parameters.What these parameters do during Reorg and how these parameters >affect the reorg process,can any of the list members explain in detail about >these parameters and how it should be implemented >for minimum downtime of application. > >Thanks >Kumar > >_________________________________________________________________ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > >================================================ >To change your subscription options or to [...] 7800 21 55_returningt values from a cobol SP to a JAVA application14_Vamsi G Charan29_vamsicharan@CHENNAI.TCS.CO.IN31_Mon, 19 Nov 2001 16:14:31 +0530385_us-ascii Hi List, I am calling a Cobol SP(On OS/390) which has got two IN and one OUT parameters(All are char(6)) form a Java application(from W-NT). But the problem i am facing is, iam unable to get the value of the OUT parameter It is showing NULL value. Is there any specific way to send the OUT parameters from COBOL to JAVA ? Can any body kindly suggest any solution please. [...] 7822 24 24_problem with date format11_arvind_heda40_arvind_heda@INTERSOLUTIONS.STPN.SOFT.NET31_Mon, 19 Nov 2001 16:23:59 +0530445_iso-8859-1 hi list members,

I am writing an generic application on db2 whcih need to run on db2 at various locations. but Db2 takes the date format (for writing and reading from the database) from the installation paramters. Is there any way to override this parameter, or to specify the fromat explicitly, As provided in oracle that the application can , along with the date , also specify the format used(19-11-2001,'dd-mm-yyyy'). [...] 7847 22 59_Re: returningt values from a cobol SP to a JAVA application18_Jose Ramon Vazquez17_jrvazquez@ATCA.ES31_Mon, 19 Nov 2001 12:41:03 +0100464_us-ascii Hi,

We have programs like this with the same platform and works fine. Please check:

> Negative SQLCODE in the SP.

> Do a DISPLAY in the SP to see the IN variables.



Best regards.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7870 73 33_SQL Query Optimization(DB2 V 6.1)10_praveen_kj19_praveen_kj@INFY.COM31_Mon, 19 Nov 2001 18:09:34 +0530319_iso-8859-1 Hi All,

1.) what should be order of predicates(DB2 V 6.1) in the where clause for better performance . lets say there are three predicates

Column 3 = X Column 2 = Y Column 1 = Z

The ascending order of records given by predicates is

Column 3 = X < Column 2 = Y < Column 1 = Z [...] 7944 60 28_Re: problem with date format0_22_blyons2@CSCPLOENZKE.DE31_Mon, 19 Nov 2001 14:22:38 +0100616_us-ascii Arvind, You can specify the date and time formats as a precompiler option (OS/390). There are several standard formats available. As long as you specify the same format on all sites, you don't have a problem with any date/time handling. However, if you mean that you want to support the standard format for each site, then you'll probably need to 1) choose a standard format for internal handling of these fields within your application, and 2) provide parameterised conversion routines to convert to/from the site format. As for explicit format specification, take a look at the CHAR function ... you [...] 8005 60 28_Re: problem with date format13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Mon, 19 Nov 2001 05:07:23 -0800664_us-ascii Hi Arvind,

When developing an application that must be transportable between locations that may have different date defaults, it is best to always use the CHAR(expression,date_format) function. The date_format will override the local default. See the CHAR function in the SQL Reference manual.

Hope this helps.

Tink --- arvind_heda wrote: > hi list members, > > I am writing an generic application on db2 whcih > need to run on db2 at > various locations. > but Db2 takes the date format (for writing and > reading from the database) > from the installation paramters. Is there any way [...] 8066 32 28_List of SQL-STMT-TYPE values0_24_Mike_Jarrett@MANDG.CO.UK31_Mon, 19 Nov 2001 13:09:28 +0000716_us-ascii Hi list, Does anyone know where I can get my hands on a complete list of possible values for the SQL-STMT-TYPE sub-field of the PLISTnnn structures which are inserted into Cobol source by the DB2 precompiler? Thanks in advance, Mike.





______________________________________________________________________ The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information, or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Although this e-mail and any attachments are believed to be free [...] 8099 75 12_Re: Prefetch13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 19 Nov 2001 07:44:01 -0600635_iso-8859-1 Recent testing has shown that the OPTIMIZE clause is ignored if CARDF is 1.

Setting CARDF to 2 will enable the optimize clause and subsequent disabling of sequential prefetch.

The only guaranteed way to disable prefetch, as suggested earlier, is to set VPSEQT=0. Allocating these small tables to their own bufferpool, setting VPSEQT=0 (and possibly using FIFO to minimize queue management overhead), is the suggested method rather than having to code the OPTIMIZE clause for alll SQL statements. As demonstrated by Walter (and explained above), the OPTIMIZE clause is sometimes ignored in this situation. [...] 8175 114 37_Re: SQL Query Optimization(DB2 V 6.1)13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 19 Nov 2001 08:15:11 -0600415_iso-8859-1 Praveen,

Check out the section "Order of evaluating predicates" in the DB2 Administration Guide, or DB2 Application Programming and SQL Guide.

Basically, the order you code predicates that are matched to index keys does not matter, since DB2 will apply them in the order of the matching index keys. If you think of a telephone book, and you have an index on LASTNAME, FIRST_INIT, then [...] 8290 25 42_Re: please speak english - not teen - here13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 19 Nov 2001 09:17:22 -0500355_iso-8859-1 I'm sure Melvin thinks he's just kidding. Lousy joke, really. Or maybe h_e is right; could be a medication level problem.

Hey Half, is that your first name or your last name? And which is it eaten or beaten?

Hey Leila, you're certainly welcome here, however you speak -- as long as you don't spell 'any' "ne". (Just kidding) [...] 8316 16 52_Re: Testing SQLJ stored proc using Procedure Builder13_Waldo Tumanut52_Waldo_Tumanut/MO/americancentury@AMERICANCENTURY.COM31_Mon, 19 Nov 2001 08:07:52 -0600390_- Thanks for the response, Greg. You are probably correct. But I'm not deploying from a workstation. I'm doing all the preparation steps on OS/390. I found my problem. I did not have the .ser in my CLASSPATH in the Java stored procedures WLM environment. Another way to do it is to specify the .ser as -resource in the hpj-compile (a detail I forgot to mention is that I'm using hpj). [...] 8333 32 43_Windows 3270 Terminal Emulator for free !!!17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Mon, 19 Nov 2001 15:40:30 +0100583_us-ascii Few months ago i fond, round around the internet, a free software to emulate a 327X session on TCP. Because of a unarrestable Alzeimer syndrom, i'm not able to find it again ! Did i dream ? Was it really ?

Every help will be highly appreciate.

txn in advance



Massimo Biancucci Technical Engineering Mainframe Technical Support-database T-Systems Italia S.p.A. Via degli Ontani, 25 36100 - Vicenza (VI) Phone: +39 0444558110 Fax: +39 0444558232 Mobile: +39 3482558906 e-mail: Massimo.Biancucci@t-systems.it Internet: http://www.t-systems.it [...] 8366 44 48_REXX RC set to +1 (= SQL warning) on open cursor12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Mon, 19 Nov 2001 16:38:49 +0100367_us-ascii Hi everybody,

After migrating to V7 we get the REXX return code RC set to +1 after every open cursor operation. The SQLDA fields seems normal, especially SQLWARN.0 is blank. Here is the display of SQLCA after the open cursor:

RC = 1 SQLCODE = 0 SQLSTATE = 00000 SQLERRMC = SQLERRP = DSN SQLERRD =0,0,0,-1,0,0 SQLWARN = ,N, , , ,1, , , , , [...] 8411 54 47_Re: Windows 3270 Terminal Emulator for free !!!11_Jose Moreno30_jose.moreno@FR.CDBSOFTWARE.COM31_Mon, 19 Nov 2001 16:40:00 +0100391_us-ascii Try this : http://www.ncn.com/nwmall/software/telnet.html I was using it some month ago and it was good

Jose Moreno CDB Software France

-----Message d'origine----- De : DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]De la part de Massimo Biancucci Envoye : lundi 19 novembre 2001 15:41 A : DB2-L@RYCI.COM Objet : Windows 3270 Terminal Emulator for free !!! [...] 8466 139 47_Re: Windows 3270 Terminal Emulator for free !!!12_David Booher22_David.Booher@QUEST.COM31_Mon, 19 Nov 2001 07:43:49 -0800422_iso-8859-1 One that I've tried and used on my laptop is MochaSoft TN3270. It is easy to install and doesn't take up a lot of space. You can get it at: http://www.tucows.com

Dave Booher Quest Software

-----Original Message----- From: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] Sent: Monday, November 19, 2001 8:41 AM To: DB2-L@RYCI.COM Subject: Windows 3270 Terminal Emulator for free !!! [...] 8606 21 38_z/OS pricing for GDPS/XRC remote site?0_17_JTonchick@AOL.COM29_Mon, 19 Nov 2001 10:49:58 EST460_US-ASCII Does anyone know if the remote site of a GDPS/XRC (Globaly Dispersed Parallel Sysplex with Extended Remote Copy) configuration qualifies as part of a sysplex for PSLC pricing? We currently have 2 datacenters. If we were to connect them in a GDPS/XRC configuration could we reduce the costs of software at the second site by switching the license to "band C" off of the first site sysplex, instead of incurring the "base cost" on the second site? [...] 8628 55 47_Re: Windows 3270 Terminal Emulator for free !!!13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM31_Mon, 19 Nov 2001 10:04:07 -0600555_iso-8859-1 QWS3270 is what I have used:

http://ww2.mcgill.ca/cc/software/qws3270/

Regards, Andy Seuffert

-----Original Message----- From: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] Sent: Monday, November 19, 2001 8:41 AM To: DB2-L@RYCI.COM Subject: Windows 3270 Terminal Emulator for free !!!



Few months ago i fond, round around the internet, a free software to emulate a 327X session on TCP. Because of a unarrestable Alzeimer syndrom, i'm not able to find it again ! Did i dream ? Was it really ? [...] 8684 24 42_Re: Default Value In UNICODE on DB2/390 V712_Simon George26_simon_x_george@HOTMAIL.COM31_Mon, 19 Nov 2001 16:44:34 +0000 8709 66 18_Re: Datalink Field13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Mon, 19 Nov 2001 11:39:46 -0600341_iso-8859-1 Hi Abi,

I worked with datalinks awhile back and it is pretty complicated to set up. You tell db2 where to put the file in the DB2 DLFM server. IBM recommended to us that the DLFM (datalinks file manager) be on a separate box from the DB2. When the DLFM and the DB2 are talking to each other, you just issue an insert. [...] 8776 24 46_Information on migrating to Websphere with DB212_Newton, Carl21_newtonc@UK.TIGPLC.COM31_Mon, 19 Nov 2001 17:53:46 -0000483_iso-8859-1 All,

We have an application that is currently architected as HTML (with a little Java Script) using ASP (very little coding) under IIS, going over COM to C++ objects on an NT server, ADO is then used over ODBC to DB2 V6 on an S/390. We are currently looking at Websphere for the Web serving and running the C++ code (in Java wrappers). I would like any pointers to good redbooks on this and if anyone has any input to performance with JDBC connections to DB2. [...] 8801 28 34_DSN1COPY No Extents, Second Volume0_20_Jones.H@GRAINGER.COM31_Mon, 19 Nov 2001 12:17:00 -0500357_- DB2 OS/390 V5. SMS. Using DSN1COPY to move production data to test using prod imagecopies with OBXLAT. For larger tablespaces we get error

DSN1992I VSAM PUT ERROR, RPLERREG = 008, RPLERRCD = 028

whenever a dasd volume runs out of space and DB2 tries to extend to another volume. We DO NOT have this problem with an unload/load process. [...] 8830 34 21_Identity column usage22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 19 Nov 2001 10:32:39 -0800606_iso-8859-1 Hi there,

We are in the process of examining the usage of Identity columns and we wondering about other shops experiences. The one piece that we would like some information on is when propagating the data back to the test system for applications folks. Are there any concerns about keeping the catalog entries in SYSSEQUENCES and SSYSSEQUENCESDEP in synch. In other words have you run into any problems with duplicate keys in the test data when they are not kept in synch? We are planning on using these in a partitioned tablespace by Month, Day, Generated as always identity column [...] 8865 67 38_Re: DSN1COPY No Extents, Second Volume13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Mon, 19 Nov 2001 11:00:13 -0800583_us-ascii Hyden,

Yes my co-workers had that problem. If remember correctly, IBM said that extending a single VSAM dataset to multiple volumes was not supported with this offline utility. Maybe Roger Miller can shed some light on this.

Tink --- Jones.H@GRAINGER.COM wrote: > DB2 OS/390 V5. SMS. > Using DSN1COPY to move production data to test using > prod > imagecopies with OBXLAT. For larger tablespaces we > get error > > DSN1992I VSAM PUT ERROR, RPLERREG = 008, RPLERRCD = > 028 > > whenever a dasd volume runs out of space and DB2 > tries to extend to another [...] 8933 22 2_V79_Ted Pesta18_tpesta@AMQUEST.COM31_Mon, 19 Nov 2001 13:52:14 -0500285_iso-8859-1 We are looking at migrating from V5 to V7 instead of V6. I know V7 has been GA since March 2001, but I've not heard that it's stable. I found the archive articles by Roger Miller ( 13 Mar 2001) and Eric Pearson (12 Jun 2001). I was looking for more recent experiences. [...] 8956 54 38_Re: DSN1COPY No Extents, Second Volume11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Mon, 19 Nov 2001 12:54:46 -0600395_iso-8859-1 As far as I remember you cannot have extents in the target. So even if the source was in the extents you have to define the target so that it does not have to copy into extents. For DSN1COPY to work you should have everything on Primary for the target, If you have the target in two datasets you will have to define the datasets using IDCAMs outside of DB2 and then do DSN1COPY. [...] 9011 22 26_DB2 UDB7.2 connect problem15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 19 Nov 2001 14:22:19 -0500298_iso-8859-1 I downloaded and installed the personal edition of DB2 UDB7.2 and installed the typical on a workstation. Then I added a database which connect to OS/390 DB2 V6. When I tried to connect, it is failing , but does not give any sqlstate, but when I go to the help, I get the following [...] 9034 53 38_Re: DSN1COPY No Extents, Second Volume12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Mon, 19 Nov 2001 14:25:19 -0500532_us-ascii Hayden, was this a LOB? Was there any IEC messages?







Jones.H@GRAINGER.COM@RYCI.COM> on 11/19/2001 12:17:00 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DSN1COPY No Extents, Second Volume



DB2 OS/390 V5. SMS. Using DSN1COPY to move production data to test using prod imagecopies with OBXLAT. For larger tablespaces we get error [...] 9088 23 63_DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB070_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 19 Nov 2001 14:36:16 -0500309_us-ascii To all,

Could use immediate feedback on this one. For a variety of reasons, an index had to be built in our PRODUCTION environment on a 34M record table. The CREATE index did not use DEFER YES because we did not want to use the REBUILD utility and affect the CICS read-only transactions. [...] 9112 23 25_-DIS LIMIT(*) Has a limit0_20_Jones.H@GRAINGER.COM31_Mon, 19 Nov 2001 13:36:00 -0500427_- -DIS DBNAME(databasename) SPACENAM(*) LIMIT(*)

The manual says that LIMIT(*) limits the display to "the space available".

Anybody know what space that refers to? Our warehouse has a fair number of objects. I get a rc of 12 in batch with SYSTSPRT DD SYSOUT=* and my display is limited to 2342 lines. Clearly, we are not talking a JES space limit. I get the same executing it in DB2I. Is this a zparm thing? [...] 9136 16 35_Migrating UDB EE systems on AIX and12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Mon, 19 Nov 2001 14:01:49 -0600336_iso-8859-1 After migrating AIX UDB EE systems from version 6 to version 7 I noticed that the version 6 SQLLIB library and all of its sub-directories were still out there (renamed to sqlllib_v61) is there a command to fall-back if the migration falls for some reason? Can I delete these libraries if the version 7 system is stable? [...] 9153 58 25_Re: Identity column usage19_Hynes, Carol A. DOC27_Carol.Hynes@DOC.STATE.WI.US31_Mon, 19 Nov 2001 13:55:59 -0600556_iso-8859-1 Hi, We are using identity columns as primary and foreign keys on a DB2 6.1, OS390 platform and they are a pain as far as migrating data from one system to another. In order to keep the referential integrity when the data is moved the columns had to be defined as GENERATED BY DEFAULT. When you move the data to another system using the load utilities, or export/import utilites, the catalog tables do not get updated. The only way we've been able to do it, is by unloading the tables from production, running a query to get the current max [...] 9212 40 6_Re: V712_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Mon, 19 Nov 2001 14:23:07 -0600616_iso-8859-1 Roger Miller's Developer's Corner in IDUG SOLUTION JOURNAL VOL 8 NO 3 (I just received my copy today) states that "V7 is looking very solid now"....

hth, john

-----Original Message----- From: Ted Pesta [mailto:tpesta@AMQUEST.COM] Sent: Monday, November 19, 2001 12:52 PM To: DB2-L@RYCI.COM Subject: V7



We are looking at migrating from V5 to V7 instead of V6. I know V7 has been GA since March 2001, but I've not heard that it's stable. I found the archive articles by Roger Miller ( 13 Mar 2001) and Eric Pearson (12 Jun 2001). I was looking for more recent experiences. [...] 9253 39 30_Re: DB2 UDB7.2 connect problem12_Myron Miller22_Myron.Miller@BMWNA.COM31_Mon, 19 Nov 2001 15:20:47 -0500426_iso-8859-1 DB2 UDB personal edition does not support DB2 Connect to OS/390. That's another product. Its DB2 Connect Personal Edition. To the best of my knowledge, the two cannot run at the same time. You need DB2 UDB EE to accomplish this.

-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Monday, November 19, 2001 2:22 PM To: DB2-L@RYCI.COM Subject: DB2 UDB7.2 connect problem [...] 9293 42 67_Re: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB070_25_Ed_Vetock@NAVYFEDERAL.ORG31_Mon, 19 Nov 2001 15:54:41 -0500633_us-ascii To all,

FYI: The job completed successfully in 3 hours 5 minutes.

R/..Ed







Ed Vetock 11/19/2001 02:36 PM

To: DB2 Data Base Discussion List cc:

Subject: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB07 (Document link: Ed Vetock)

To all,

Could use immediate feedback on this one. For a variety of reasons, an index had to be built in our PRODUCTION environment on a 34M record table. The CREATE index did not use DEFER YES because we did not want to use the REBUILD utility and affect the CICS read-only transactions. [...] 9336 39 12_DSNUTIL Eror12_Mathur, Anil29_AMathur@HARLEYSVILLEGROUP.COM31_Mon, 19 Nov 2001 15:58:40 -0500312_- Hi List,

We are getting the following error when we try to connect to the subsystem from the Control Center on NT. We are OS/390 2.10, DB2 V 7.1 Can anyone tell me what I should be looking into. I have no clue. DSNUTIL is defined in its own WLM address space with NUMTCB = 1. Thanks for your help. [...] 9376 92 25_Re: Identity column usage22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 19 Nov 2001 13:00:38 -0800551_iso-8859-1 Thanks for the response.. I have been playing with this all morning.. What we have is generated always as identity, with a start value like I mentioned below.. What I am thinking of is using a start value of zero for the test systems so that we do not have the problem with duplicate keys on inserts.. So we take the production data that started with a negative large number, load test with it's data, and any new inserts into the test tables start with zero and move forward. Once production reaches zero in about 7 years we drop and [...] 9469 40 52_Re: Testing SQLJ stored proc using Procedure Builder13_Greg Farquhar25_Greg_Farquhar@BIGPOND.COM31_Tue, 20 Nov 2001 08:24:20 +1100458_iso-8859-1 Waldo,

I have always had a problem adding the serialised profile as a resource to hpj. I have found that it is required to jar up the profile then add the jar as a resource to hpj.

Greg

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Waldo Tumanut Sent: Tuesday, November 20, 2001 1:08 AM To: DB2-L@RYCI.COM Subject: Re: Testing SQLJ stored proc using Procedure Builder [...] 9510 145 25_Re: Identity column usage10_Mark Doyle19_mdoyle@JCPENNEY.COM31_Mon, 19 Nov 2001 15:44:32 -0600620_iso-8859-1 That sounds like a really elegant solution!

----- Original Message ----- From: "Killen, Martin W - CNF" Newsgroups: bit.listserv.db2-l To: Sent: Monday, November 19, 2001 3:00 PM Subject: Re: Identity column usage



> Thanks for the response.. I have been playing with this all morning.. What > we have is generated always as identity, with a start value like I mentioned > below.. What I am thinking of is using a start value of zero for the test > systems so that we do not have the problem with duplicate keys on inserts.. > So we take the [...] 9656 77 38_Re: DSN1COPY No Extents, Second Volume0_19_Tim.Lowe@STPAUL.COM31_Mon, 19 Nov 2001 15:53:27 -0600493_us-ascii Hayden, In order to avoid this problem, I alter the dataset you are copying to, adding multiple candidate volumes. For example, something like this: ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 ADDVOLUMES(* * * * *) Then, after the DSN1COPY is complete, I do something like this several times: ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 REMOVEVOLUMES(*)

This is because DSN1COPY is an external utility, and does not go through the code that DB2 uses to add candidate volumes. [...] 9734 25 52_REQ : IBM Response to latest from Oracle Spindoctors19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Mon, 19 Nov 2001 16:58:56 -0600364_us-ascii Is there an IBM response to the latest from the Oracle "Ministry of Truth", which made a major appearance in the UK Sunday newspapers (targetted at business managers rather than techies as usual).

This involves Oracle claiming that their product is "more secure" than their competitors. You can read the claims for yourself on their Web site. [...] 9760 57 39_Re: DB2 MONITORS FOR UDB RUNNING ON AIX19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Mon, 19 Nov 2001 17:00:12 -0600425_us-ascii Jeff,

Sorry I took so long to reply but my message got bounced by the DB2-L list.

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

We are running the suite of tools from Database GUYS Inc. (http://www.breakthroughdb2.com).

SQL-GUY in particular would be just the thing for you. It allows you to pinpoint SQL which is causing problems and interfaces nicely with the DB2 provided tools such as Index Advisor and Explain. [...] 9818 42 5_Index7_db user20_dbuser75@HOTMAIL.COM31_Mon, 19 Nov 2001 23:40:16 +0000512_- List,

I have a question about creating index.

Lets say i have a query:

Select Col1,Col2,Col3 form tb where col1 = value and col2 = value;

Which index is the best option

A) Unique index on COL1,COL2,COLX(adding another column from table to make unique) or

B) non unique index on COL1,COL2.There is no DASD issue for adding an extra column to make it unique but will it prove advantage over non-unique.What are the factors to be considered while creating an index. [...] 9861 13 16_Re: DSNUTIL Eror9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 19 Nov 2001 17:49:44 -0600371_- What does the JCL proc look like for the WLM environment used by DSNUTILS?

Jim Ruddy DB2 for z/OS and OS/390 Development

================================================ 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. 9875 13 52_Re: REXX RC set to +1 (= SQL warning) on open cursor9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 19 Nov 2001 17:55:08 -0600359_- The SQLWARN fields are not blank and therefore there is a warning.

Jim Ruddy DB2 for z/OS OS/390 Development

================================================ 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. 9889 137 9_Re: Index10_James Kwan19_JamesDB2Kwan@CS.COM29_Mon, 19 Nov 2001 20:41:39 EST577_US-ASCII Kumar,

I will give a try. The answer you will get from others probably is "it depends". I will only give you some factors that will help you to make the decision. 1) There is no need to create an unique index unless you have a requirement to make sure it is unique. 2) Unique key and duplicate key have different internal structures. For non-unique index, duplicate keys will be linked together. Ie if you have non evenly distributed data, then some keys will takes longer time to update. 3) If some fields are frequently accessed, then you might consider [...] 10027 91 25_Re: Identity column usage14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Nov 2001 12:47:02 +1100456_US-ASCII Bit of a , isn't it.

http://jupiter.ryci.com/cgi/wa.exe?A2=ind0008C&L=DB2- L&P=R4949 is one way of handling it.

Another, if you are "strictly" concened with moving data from production to development, say, is to have interspersed numbers: Prod uses START 1 INCREMENT 2; dev uses GENERATED BY DEFAULT START 2 INCREMENT 2. The numbers generated in production can never match those generated in development. [...] 10119 72 9_Re: Index14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Nov 2001 13:19:30 +1100322_US-ASCII Kumar

1) If COLX is COL3 then option 1 will probably be best - because DB2 will be able to satisfy the query using the index alone.

2) If COL1, COL2, COLX is clustered (ie data rows in the same order), this will be next best - since DB2 will (probably) trigger pre- fetch to suck data rows in. [...] 10192 42 59_Re: returningt values from a cobol SP to a JAVA application14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Nov 2001 13:19:30 +1100462_US-ASCII Can you post COBOL code (at least linkage section, procedure division, essential code), SP definition, Java code?

James Campbell

On 19 Nov 2001, at 16:14, Vamsi G Charan wrote:

Date sent: Mon, 19 Nov 2001 16:14:31 +0530 Send reply to: DB2 Data Base Discussion List From: Vamsi G Charan Subject: [DB2-L] returningt values from a cobol SP to a JAVA application To: DB2-L@RYCI.COM [...] 10235 50 62_Re: Return Result Set from a Stored Procedure to a Cobol Prog?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Nov 2001 13:19:30 +1100443_US-ASCII Mina,

What data does the SP get, what data does the caller get, what is "wrong" with it?

James Campbell



On 19 Nov 2001, at 12:24, Mina Gohari wrote:

Date sent: Mon, 19 Nov 2001 12:24:25 +0330 Send reply to: DB2 Data Base Discussion List From: Mina Gohari Subject: [DB2-L] Return Result Set from a Stored Procedure to a Cobol Prog? To: DB2-L@RYCI.COM [...] 10286 36 32_Re: List of SQL-STMT-TYPE values14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Nov 2001 13:19:30 +1100429_US-ASCII SDSNMACS(DSNX????) (not handy to a system at the moment) has the layout of the parameter list - including this.

James Campbell



On 19 Nov 2001, at 13:09, Mike_Jarrett@MANDG.CO.UK wrote:

Date sent: Mon, 19 Nov 2001 13:09:28 +0000 Send reply to: DB2 Data Base Discussion List From: Mike_Jarrett@MANDG.CO.UK Subject: [DB2-L] List of SQL-STMT-TYPE values To: DB2-L@RYCI.COM [...] 10323 90 38_Re: DSN1COPY No Extents, Second Volume10_John Hardy25_john_hardy@ALLIANZ.COM.AU31_Mon, 19 Nov 2001 20:22:37 -0600703_- Hayden,

Bear in mind that your first extent on the additional volume will be the size of your primary rather than secondary allocation.





On Mon, 19 Nov 2001 15:53:27 -0600, Tim.Lowe@STPAUL.COM wrote:

>Hayden, >In order to avoid this problem, I alter the dataset you are copying to, >adding multiple candidate volumes. >For example, something like this: > ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 ADDVOLUMES(* * * * *) >Then, after the DSN1COPY is complete, I do something like this several >times: > ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 REMOVEVOLUMES(*) > >This is because DSN1COPY is an external utility, and does not go through >the code that DB2 uses [...] 10414 79 9_Re: Index16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Mon, 19 Nov 2001 22:38:38 -0700590_us-ascii Kumar,

I couple of points come to mind regarding your query and index makeup. The first is that if your application already knows what the values are for COL1 and COL2 within your SQL statement since each are being tested with equal conditions, then it is not necessary to include them within your list of selected columns. As far as whether to include an additional column to your index (COL3), specifically to accommodate this SQL statement, I would say that it would be worth the effort. This would allow for index only access, and this index was not the clustering [...] 10494 62 52_Re: REXX RC set to +1 (= SQL warning) on open cursor12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Tue, 20 Nov 2001 07:33:19 +0100349_us-ascii Thanks for your answer Jim.

I thougt the important place to look for if there's an error is SQLWARN.0 which "contains a blank if no other indicator is set to a warning condition, that is no other indicator contains a W or Z)" Here is the piece of code I'm executing and the result in a more readable form than in my first mail: [...] 10557 17 38_Re: DSN1COPY No Extents, Second Volume10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 20 Nov 2001 03:00:32 -0600400_- Hayden,

When we get the same problem, we do the same as Tim Lowe - use IDCAMS ALTER to add extra candidate volumes.

Regards,

Steve Lamb

================================================ 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. 10575 14 35_Re: DB2 Utilities in Rexx (TSOUTIL)10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 20 Nov 2001 11:00:39 +0100309_us-ascii Hi Marcus

Did you succeeded in running TSOUTIL ????

================================================ 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. 10590 54 72_Mixed Sessions: HELP!! ( JAVA-DB2ConnectEE-DB2v6OS390-StoredProced ures)15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 20 Nov 2001 13:16:02 +0100498_iso-8859-1 Dear Listers,

We have a situation using DB2 Connect 7.1 EE on NT for a JAVA application using JDBC connecting to OS/390 DB2 v 6 using Cobol Stored Proceudes. In this situation the end users get the results of anothers users transaction on his/her screen. This is quite disturbing as you can imagine. Did anyone encounter this problem somewhere with JAVA-DB2Connect-StoredProcedures? Are there do's and don'ts in coding we might not be aware of? Any help is much appreciated. [...] 10645 78 77_Re: Mixed Sessions: HELP!! ( JAVA-DB2ConnectEE-DB2v6OS390-StoredP roced ures)12_Myron Miller22_Myron.Miller@BMWNA.COM31_Tue, 20 Nov 2001 08:00:00 -0500461_ISO-8859-1 I saw this same problem with 7.1 and JAVA early. Are you on at least fixpack 2a? And are you using pooling? Also, we had some problems with the way the JAVA programs were connecting (source coding issues). We changed to a more consistent connection interface (I don't remember the exact details). Also we were using DB2 Connect pooling rather than JAVA Application Server pooling. When we got rid of the DB2 Connect pooling the issue went away. [...] 10724 82 29_Re: -DIS LIMIT(*) Has a limit0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 20 Nov 2001 07:28:05 -0600484_us-ascii We have thousands of DB2 objects and hit this limit a couple years ago. I don't recall what the limit of space is (sorry) but for us and the automated process that would check to make sure that objects weren't in a restrict status each day, we ended up splitting out our displays into smaller segments so that we could get the info we needed. Would love to see IBM increase that limit so this wasn't necessary, but this may be a work around for you if you run into it.. [...] 10807 23 62_Re: Return Result Set from a Stored Procedure to a Cobol Prog?11_Mina Gohari23_mgohari@DPI2.DPI.NET.IR31_Tue, 20 Nov 2001 06:54:15 -0600368_- Thanks for your reply, I solved my problem, I had a cursor which opened inside of Stored Procedure. this cursor was declared as a cursor on a select char(desc) as Desc from table1.

When I called the SP inside of Cobol Program, it was curropt the Char data.

After that I tried to change the select to select desc from table1. it answered properly. [...] 10831 42 45_Re: DB2 UDB for Sun Solaris . OS Tuning parms12_Benner, Jeff24_Jeff.Benner@CAREMARK.COM31_Tue, 20 Nov 2001 07:43:28 -0600498_iso-8859-1 Yes I have.

The relevant kernel tuning parameters can be found in "Quick Beginnings for Unix" which comes with your standard document set. Search for the word "kernel".

Please note that kernel configuration parameters seem to have been set up for Solaris 7 or prior, and in Solaris 8 some of the noted parameters are now obsoleted. You will have to check Solaris 8 docs if you are at Solaris 8, to determine which IBM kernel configuration settings now have no effect. [...] 10874 50 16_Re: DSNUTIL Eror12_Mathur, Anil29_AMathur@HARLEYSVILLEGROUP.COM31_Tue, 20 Nov 2001 08:54:28 -0500870_- Jim - Following is the jcl proc for the WLM environment used by DSNUTILS.



//DB2DEV PROC RGN=0K,APPLENV=DSNDUTIL,DB2SSN=DSND,NUMTCB=1 //DB2 EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT, // PARM='&DB2SSN,&NUMTCB,&APPLENV' //**STEPLIB DD DISP=SHR,DSN=SYS1.DB2V7.RUN.LOAD //STEPLIB DD DISP=SHR,DSN=SYS1.DB2V7.RUN.SDSNLOAD // DD DISP=SHR,DSN=SYS1.CEE.SCEERUN //**** DD DISP=SHR,DSN=SYS2.DSND.WLM.SYSPROC.LOAD //*SYSEXEC DD DISP=SHR,DSN=SYS1.DB2V7.RUN.SDSNCLST //*SQLDBRM DD DISP=SHR,DSN=SYS1.DB2V7.RUN.DBRMLIB.DATA //*SQLCSRC DD DISP=SHR,DSN=SYS1.DB2V7.RUN.SRCLIB.DATA //*SQLLMOD DD DISP=SHR,DSN=SYS1.DB2V7.RUN.LOAD //SYSUDUMP DD SYSOUT=* //SYSOUT DD SYSOUT=* //UTPRINT DD SYSOUT=* //DSSPRINT DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //CEEDUMP DD SYSOUT=* //SYSIN DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSPRINT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) [...] 10925 43 14_Recovery issue14_Database Admin21_db2udbxpert@YAHOO.COM31_Tue, 20 Nov 2001 05:54:10 -0800512_us-ascii Dear DB2 gurus,

Consider following events on same database in DB2 V6 os/390

1) Took Image copy @ 9 am 2) Done few UPDATE(s) @ 10 am 3) issue COMMIT @ 11 am 4) Ran few more UPDATE(s) & inserts @ 12 noon 5) Before issueing COMMIT , I've found the updates/inserts done in step 4 are incorrect. My requirement is to RECOVER to the previous COMMIT point. In that case how do I recover ? I do not want to recover from the image copy taken @ 9 am. How should I get logpoint or RBA so that I [...] 10969 27 9_Post-Test11_Alfred Moos21_moos@FH-HEIDELBERG.DE31_Tue, 20 Nov 2001 15:03:46 +010026_iso-8859-1 pardon.

10997 87 34_DSN1COPY No Extents, Second Volume0_20_Jones.H@GRAINGER.COM31_Tue, 20 Nov 2001 08:06:00 -0500483_- Tim, Will that work with SMS?

Hayden --------------------------------------------------------------------------

Hayden, In order to avoid this problem, I alter the dataset you are copying to, adding multiple candidate volumes. For example, something like this: ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 ADDVOLUMES(* * * * *) Then, after the DSN1COPY is complete, I do something like this several times: ALTER hlq.DSNDBD.dbname.tsname.I0001.A001 REMOVEVOLUMES(*) [...] 11085 80 20_Re: INDEX ONLY QUERY13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 20 Nov 2001 08:28:32 -0600560_iso-8859-1 Roger,

There could be any number of reasons why the two environments differ in their access path selection. Different statistics, different releases or even maintenance levels of DB2 (hence potentially different optimizer cost models).

I believe the optimizer considers a 3 level index + data access as a cheaper option than index only on a four level index. This is regardless of the fact that there is more liklihood of finding the index page already in the bufferpool, since an index page can generally fit more rows per page. [...] 11166 108 52_Re: DB2 MONITORS FOR UDB RUNNING ON AIX (or Solaris)12_Benner, Jeff24_Jeff.Benner@CAREMARK.COM31_Tue, 20 Nov 2001 08:26:20 -0600501_iso-8859-1 One large Chicago shop I have worked at used Database Guys, and we were all very happy with it. We are seriously considering it at my current shop as well. I highly recommend it. Besides offering a range of easily customizable reports, easily interfaced with existing tools, and historical as well as detailed realtime reporting, it is very competitively priced. It is available for Solaris, AIX and Linux. There is the traditional server-based product as well as a newer Java client. [...] 11275 131 38_Re: DSN1COPY No Extents, Second Volume0_19_Tim.Lowe@STPAUL.COM31_Tue, 20 Nov 2001 08:49:34 -0600493_us-ascii Hayden, Yes, this will work with SMS. Adding candidate volumes of * is essentially the same thing that DB2 does when it has a stogroup of volume(*). There are two differences, the most important of which is that the primary allocation is taken on each volume, as John Hardy mentioned. And, when DB2 attempts to extend it adds a single additional volume, and then if it fails, it removes that candidate. I just add multiple candidates, and remove any that are not used afterward. [...] 11407 66 67_Re: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB0710_James Kwan19_JamesDB2Kwan@CS.COM29_Tue, 20 Nov 2001 09:50:38 EST377_US-ASCII Ed,

May be you should try to create index with defer yes and then recover the index.

James Kwan

IBM Certified Specialist



In a message dated 11/19/01 3:30:58 PM Central Standard Time, Ed_Vetock@NAVYFEDERAL.ORG writes:



> To all, > > FYI: The job completed successfully in 3 hours 5 minutes. > > R/..Ed >



11474 37 0_6_Db udb16_db2eee@YAHOO.COM31_Tue, 20 Nov 2001 07:10:09 -0800377_us-ascii List ,

We are trying to evaluate our options on the various DB2 tools available .

IBM DB2 Tools CA-Platinum BMC Tools

We have got quite a few responses/references on Platinum & BMC tools , but we are finding it quite difficult to benchmark IBM on the same scale . There have been a few mails on the list , but none stirred up a good debate . [...] 11512 47 38_Re: DSN1COPY No Extents, Second Volume16_Lemaire, Nigel B21_nigel.lemaire@EDS.COM31_Tue, 20 Nov 2001 09:29:15 -0600605_- Are you using SMS managed DASD? I have experienced this same problem. MOST frustrating. We use Implicitly defined clusters and SMS managed DASD. What appears to happen is that the allocation is constrained to the initial volume allocated. Since any volume that can accommodate the primary allocation is "good" you may get one with only enough space for the primary and no extents. When you attempt to take an extent, you fail. No consideration is given to using another volume...strange. The only way I found around this is to Explicitly define the failing cluster with a LARGE primary, big enough [...] 11560 25 67_Re: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB0710_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 20 Nov 2001 16:39:11 +0100320_us-ascii Hi Ed

Could you please specify table record lenght and index key length ? DB2 Xtimator gave less than 2 hours to REBUILD

the index, but it's based on 1 column and a row length of 53 and obvously it's a rough estimation. Can you provide your

CPU type too ? Just to play witha real case [...] 11586 26 9_Re: Index8_Harish G24_hari_gangadhar@YAHOO.COM31_Tue, 20 Nov 2001 09:26:30 -0600528_- Kumar,

If you already have a clustering index on table, TB, and the columns belonging to this index does not contain COL1 and COL2, but contains COLX (and COLX is a high order column in the clustering index)....then, adding COLX to the new COL1 and COL2 index (to make it unique) can improve the clusterratio of the new index. When I use the word, improve, what I mean is that clusterratio may improve over an index with COL1 and COL2 only under the same scenario. Again, test this before you decide to implement. [...] 11613 14 52_Re: can an Identity column be used as a foreign key?15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 20 Nov 2001 09:39:37 -0600416_- Hi Stephen

Although it's possible to use an identity column in a foreign key, there are some difficulties to be aware of, if you drop and recreate your parent table.

================================================ 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. 11628 50 41_Table is not Available../UDB/SUN.. Urgent15_Rajesh Udandrao17_urajes1@YAHOO.COM31_Tue, 20 Nov 2001 08:51:59 -0800467_us-ascii Hello UDB gurus Yesterday I had a problem saying that the table is unavailable Reason: I Restored and rolled forward a data base from a online backup and some logs, there are some tables created with “NOT LOGGED INITIALLY” option. Backup is taken before any transaction on those tables. After rolling forward till end of logs we are not able to access the tables Is there any way I can get the data back into the tables. There are many tables like this [...] 11679 21 25_Stored procedure question15_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Tue, 20 Nov 2001 09:51:38 -0700585_- This is most likely a dumb question, but here goes.

How do you return data from a stored procedure without using the "WITH RETURN" option on a cursor? I'm trying to return IMS/DB data through the procedure. Any help would be appreciated.



Dave Schaeffer IT Database Leader Bendix CVS E-Mail: Dave.Schaeffer@Honeywell.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. 11701 14 32_Re: List of SQL-STMT-TYPE values12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 20 Nov 2001 10:19:03 -0600441_- Look in SDSNMACS member DSNXRDI. You will notice many changes for new releases and PTFs, so I'd suggest trying to find a way to get the latest with just a compile.

Roger Miller, DB2 for z/OS

================================================ 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. 11716 70 39_Re: DB2 MONITORS FOR UDB RUNNING ON AIX13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Tue, 20 Nov 2001 10:37:42 -0600689_- On Wed, 14 Nov 2001 12:17:14 -0700, Jeff A L'Italien wrote:

>I'd like to know what type of performance monitors people are using for UDB >under AIX. We currently have BMC Patrol installed, but from what I understand, >it is geared more toward the overall system health. What we're looking for, is >something which provides similar functionality to that of BMC's Apptune tool >for OS390. We would like to be able to isolate those dynamic queries which are >long running or processor intensive. I appreciate all feedback. > >Regards, >Jeff L'Italien >American Express > >================================================ >To change your subscription [...] 11787 30 24_Re: SQL/DS question -71234_Filip Ruhdensj=?ISO-8859-1?Q?=F6?=25_filip.ruhdensjo@PULSEN.SE31_Tue, 20 Nov 2001 10:38:36 -0600343_ISO-8859-1 Hi John,

Try to allocate many more internal dbspaces. In system administration there says "...in addition to the minimum of 30, you may want to provide 10 internal dbspaces for each NCUSER." (page 20, chapter 2 Planning for Database Generation)

If you have 30 NCUSER the number of internal dbspaces would be 300. [...] 11818 15 38_Re: DSN1COPY No Extents, Second Volume12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 20 Nov 2001 10:40:40 -0600532_- I looked at the Utility Guide and Reference and found a brief discussion under DSN1COPY, Adding additional volumes for SYSUT2. For these data sets working offline, we don't have the DB2 subsystem code or information, so the DB2 extend code does not work.

Roger Miller, DB2 for z/OS

================================================ 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. 11834 18 6_Re: V712_Roger Miller19_millerrl@US.IBM.COM31_Tue, 20 Nov 2001 10:56:55 -0600329_- I'm pretty cautious, since I get the complaints directly and often several times. V7 looks very good. The V7 APAR backlog is about 20% of the V6 backlog. I try to chase down problem rumors, and the latest was not related to the code, for example. For a service level recommendation, use the IBM Consolidated Service Test. [...] 11853 54 29_Re: Stored procedure question0_19_Tim.Lowe@STPAUL.COM31_Tue, 20 Nov 2001 11:06:59 -0600415_us-ascii Dave, Can you put the IMS data into a DB2 Global Temporary Table, and then open a cursor for return on the GTT?

Thanks, Tim





"Schaeffer, Dave" cc: Sent by: DB2 Data Subject: Stored procedure question Base Discussion List



11/20/2001 10:51 AM Please respond to DB2 Data Base Discussion List [...] 11908 29 29_Re: Stored procedure question12_Jim Harrison17_jharrison@GMX.NET31_Tue, 20 Nov 2001 12:07:12 -0500507_us-ascii How much data? If it's not a lot, how about laying it up in a table defined as an "out" parameter.

At 09:51 AM 11/20/2001 -0700, Schaeffer, Dave said: >This is most likely a dumb question, but here goes. > >How do you return data from a stored procedure without >using the "WITH RETURN" option on a cursor? I'm trying >to return IMS/DB data through the procedure. Any help >would be appreciated. > > >Dave Schaeffer >IT Database Leader >Bendix CVS >E-Mail: Dave.Schaeffer@Honeywell.com [...] 11938 32 16_Cursor Question.22_Augustine, Jobi M B22524_Jobi.Augustine@CIGNA.COM31_Tue, 20 Nov 2001 12:11:32 -0500359_iso-8859-1 Hi List,

I have a very simple COBOL question. We use DB2 OS/390 V6 in our shop.

Is there is any chance that the cursor in a calling program gets closed after the control comes back from one of its called program. There is no COMMIT in the called program. The cursor in the calling program is NOT defined with "WITH HOLD" option. [...] 11971 58 29_DB2 UDB Client I/O Block Size14_MIKE FRIEDRICH27_RDBA002@REVENUE.STATE.IL.US31_Tue, 20 Nov 2001 11:22:45 -0600599_US-ASCII My question is on the Client I/O Block size parameter RQRIOBLK for DB2 UDB V7.2 (NT, AIX). We were having some communications problems over Novell network at times. The application would work fine and then a few moments later the following error would be received.

SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.243.133.206". Communication function detecting the error: "recv". Protocol specific error code(s): "10014", "*", "*". SQLSTATE=08001 [...] 12030 43 52_Re: can an Identity column be used as a foreign key?17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Tue, 20 Nov 2001 11:25:24 -0600346_us-ascii As long as the parent table is created with generate by default and not always you should not have a problem. By default allows you to do a load on your parent table. Generate always says that the system will always generate the field. We are starting to use them as foreign keys on one of our applications, and so far no problems. [...] 12074 121 77_Re: Mixed Sessions: HELP!! ( JAVA-DB2ConnectEE-DB2v6OS390-StoredP roced ures)15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Tue, 20 Nov 2001 18:26:55 +0100443_iso-8859-1 Myron,

I'm not sure what you mean with fixpack 2a, how can I find out? We're not using pooling ; DB2CONNECT_IN_APP_PROCESS is not in effect. We're not using beans, straight JAVA is used. We're also using MTS.EXE, does that help you. It would be so nice if you could remember some (juicy) details.. Thanks for your answer so far. It's good to know the problem has been encountered before. Looking forward to your answer. [...] 12196 22 31_-904 with reason code 00C200F3.13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 20 Nov 2001 11:34:07 -0600534_iso-8859-1 This is for DB2 V6 on OS390 -- About a week ago I had around a dozen jobs go down with a -904 sqlcode, reason code 00C200F3. These were unload jobs running select statements under DSNTIAUL, using uncommitted read. DB2 produced a DSNT376I message pointing to a timeout, and showed the blocker as being another unload job (also using uncommitted read). I'm at a loss to explain what would cause this (a UR thread blocking a UR thread, resulting in a -904/00C200F3). The 00C200F3 reason code points to 4 possibilities... [...] 12219 23 39_Re: DB2 MONITORS FOR UDB RUNNING ON AIX13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Tue, 20 Nov 2001 11:04:37 -0600558_- Hi Bill I also forgot to mention the we will also be offering another alternative for monitoring DB2 AIX . Quest Software's Foglight monitor will be adding a DB2 agent in January as well. This is a full "lights out" 24x7 agent based enterprise monitoring solution with automatic alerting capability as well as historical repository for application analysis. Again you can view additional information on Foglight at: WWW.QUEST.COM Thanks Again Jim Wankowski DB2 Product/Marketing Manager Quest Software 4320 Winfield Rd, suite 500 Warrenville,Il,60555 [...] 12243 18 16_Re: DSNUTIL Eror9_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 20 Nov 2001 11:16:29 -0600335_- JCL proc looks fine.

You need to open a problem so service can look into this further. Make sure you have the log of the MVS console and the EREP report of SYS1.LOGREC. It will also be helpful if you can do a "DISPLAY SQL" (I think) in CC/390 so you can capture the the utility statement which is being sent to DSNUTILS. [...] 12262 62 67_Re: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB070_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 20 Nov 2001 11:42:19 -0500443_us-ascii Max,

Record length = 457 Index length = 63 CPU type 2064-1C7 # of records in table = 34 million

By the way, It took 3 hours to do the build. I'd be curious as to what Xtimator came up with. Thank you for responding.

R/..Ed











Max Scarpa @RYCI.COM> on 11/20/2001 10:39:11 AM

Please respond to DB2 Data Base Discussion List [...] 12325 76 18_Rebuilding of NPIs15_Hissam Tressa K23_Tressa.K.Hissam@IRS.GOV31_Tue, 20 Nov 2001 13:48:04 -0500537_iso-8859-1

I have a table that has 1.5 billion rows that is loaded on a weekly basis. This is accomplished via partition loads but the table also has a NPI on it for user access. Therefore, the NPI gets dropped and must be rebuilt weekly. It is currently taking about 9 hours to do this. I would be interested to know exactly how DB2 does the rebuild - does it unload the record for all 1.5M records or just the key? Is there anyway (I haven't found a way) to build the NPI off the partitioning IX (or merge the partitions) [...] 12402 39 56_Re: REQ : IBM Response to latest from Oracle Spindoctors12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 20 Nov 2001 12:40:41 -0600536_- Security has always had a very high priority at IBM, and our solutions tend to encompass the hardware, the operating system and all of the authorized programs. There is a good book that addresses the IBM Security Architecture, SC28-8135. You can also see that we continue to make improvements in our security in every new version. An overview of the DB2 for z/OS and OS/390 security is on the external web, along with lots of other security presentations: http://www-1.ibm.com/servers/eserver/zseries/zos/racf/presentations.html [...] 12442 13 21_NUMLKTS and LOCKMAX 014_Hester, Rhonda25_Rhonda.Hester@ACS-INC.COM31_Tue, 20 Nov 2001 14:15:58 -0500388_iso-8859-1 DB2 V6, OS/390 V2.6 - If I set LOCKMAX to 0 for a tablespace and disable lock escalation will the value for NUMLKTS be used in any way?

================================================ 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. 12456 44 22_Re: Rebuilding of NPIs0_20_Jones.H@GRAINGER.COM31_Tue, 20 Nov 2001 13:57:00 -0500319_- Tressa, You said 1.5 billion and then 1.5 M records. I assume you meant the billion if it takes 9 hours to rebuild the index. If so, could you share the JCL and control cards you use for that rebuild? I'd be curious to see what kind of space you need for the various datasets and how your sortworks are handled. [...] 12501 49 25_Re: NUMLKTS and LOCKMAX 012_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 20 Nov 2001 12:13:15 -0800633_us-ascii Rhonda,

If you disable lock escalation (LOCKMAX 0) you will 'probably' want to increase NUMLKTS. This is due to the fact that you probably will be holding more locks per object.

Regards, Susan --- "Hester, Rhonda" wrote: > DB2 V6, OS/390 V2.6 - If I set LOCKMAX to 0 for a > tablespace and disable > lock escalation will the value for NUMLKTS be used > in any way? > > ================================================ > 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 [...] 12551 19 33_Kevin Davis is out of the office.11_Kevin Davis18_kevin.davis@DB.COM31_Tue, 20 Nov 2001 14:06:20 -0600139_us-ascii I will be out of the office from 11/20/2001 until 11/26/2001.

I will respond to your message when I return.



12571 61 22_Re: Rebuilding of NPIs12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 20 Nov 2001 12:20:13 -0800559_us-ascii Tressa,

Unfortunately, today even in V7, there really is no alternative to this type process when rebuilding the entire NPI. Maybe in the near future.....

Regards, Susan --- Hissam Tressa K wrote: > > I have a table that has 1.5 billion rows that is > loaded on a weekly basis. > This is accomplished via partition loads but the > table also has a NPI on it > for user access. Therefore, the NPI gets dropped > and must be rebuilt > weekly. It is currently taking about 9 hours to do > this. I would be > [...] 12633 113 22_Re: Rebuilding of NPIs10_James Kwan19_JamesDB2Kwan@CS.COM29_Tue, 20 Nov 2001 15:25:31 EST554_US-ASCII Tressa,

Couple suggestions 1) Do you have to drop the NPI? Are you loading the whole table or just some partitions? What shrlevel you are using while loading? With resume yes, NPI is updated instead of being rebuilt. This might save you some time.

2) IBM V7 and some third party load utilities allow you to have online load which means you don' t have to drop your NPI. Of course it will depends on how many rows are being load each week. If you are loading 1.5B rows each row, then it probably won't work. If you are loading [...] 12747 17 14_database alias3_db218_db2_user@YAHOO.COM31_Tue, 20 Nov 2001 14:43:36 -0600426_iso-8859-1 I am trying to access plan table from visual explain. For this I need to specify the database alias name. We have OS 390 DB2 6.1 . Can anyone help me find this?.

Thanks

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12765 36 22_IBM DB2 Tools Feedback6_Db udb16_db2eee@YAHOO.COM31_Tue, 20 Nov 2001 13:25:21 -0800377_us-ascii List ,

We are trying to evaluate our options on the various DB2 tools available .

IBM DB2 Tools CA-Platinum BMC Tools

We have got quite a few responses/references on Platinum & BMC tools , but we are finding it quite difficult to benchmark IBM on the same scale . There have been a few mails on the list , but none stirred up a good debate . [...] 12802 67 35_Re: -904 with reason code 00C200F3.11_Chad Walmer19_cwalmer@RITEAID.COM31_Tue, 20 Nov 2001 16:25:24 -0500308_iso-8859-1 Mike, We see these errors when the MVS sysprogs rebuild the lock structure. I believe any threads which need to propagate locks to the lock structure will fail with this message while the structure is rebuilding (usually only takes a minute or so for us and it's done during off-peak hours.) [...] 12870 15 51_Bruce C Crosby/GL/KSC/KeyCorp is out of the office.12_Bruce Crosby26_Bruce_C_Crosby@KEYBANK.COM31_Tue, 20 Nov 2001 17:04:06 -0500429_us-ascii I will be out of the office from 11/20/2001 until 11/26/2001.

I will respond to your message when I return. If you need a response sooner contact Robert Vargo or Jim Szabo

================================================ 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. 12886 85 18_Re: Recovery issue14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Nov 2001 10:32:03 +1100496_US-ASCII May I ask what platform this is on? The technique to be used will be different between DB2 for z/OS&OS/390, for Windows et al, for iSeries, for VSE, for Uncle Tom Cobley and all.

I am presuming you mean on z/OS&OS/390.

Further, I presume this is somewhat theoretical, given your requirement to not ROLLBACK. I doubt that you would be able to do anything to recover until you've either ROLLBACKed or COMMITed - until then the locks you have would preclude a RECOVERed. [...] 12972 16 35_Re: DB2 Utilities in Rexx (TSOUTIL)13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Tue, 20 Nov 2001 17:53:31 -0600369_- Buon giorno, Max!

No I haven't tried it yet - I've got to get it APF authorised by the guys in HQ!

Ciao! Marcus

================================================ 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. 12989 102 20_Re: Cursor Question.14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Wed, 21 Nov 2001 11:45:16 +1100352_iso-8859-1 Hi Jobi,

It is possible. You don't say if you are running online or batch, but from the V5 Application Programming and SQL manual:

3.2.3 If your program completes a unit of work (that is, it commits the changes made so far), and you do not want DB2 to close all open cursors, declare the cursor with the WITH HOLD option. [...] 13092 18 33_Image copy (DSNUTILB) performance10_Ron, Yoram12_rony@ANZ.COM31_Wed, 21 Nov 2001 12:00:18 +1100414_iso-8859-1 The Image Copy program (DB2YTILB) on our DB2 V5 seem to be using BSAM (according to a Strobe report I ran on an Image Copy job). Still, the Utility user guide say that if you want to improve performance you can code a BUFNO= on input/output DDs. Am I missing something ? I thought that BSAM ignores these BUFNO parameters. Is there any other way of speeding the IC performance ? Thanks, Yoram Ron. [...] 13111 55 50_Re: Information on migrating to Websphere with DB29_Eric Kwai18_Eric_Kwai@DTCC.COM31_Tue, 20 Nov 2001 19:57:56 -0600570_- Carl:

Try the following redbooks. You can find them in www.redbooks.ibm.com with the keyword WebSphere.

WebSphere Application Server Development Best Practices for Performance and Scalability

http://www-4.ibm.com/software/webservers/appserv/ws_bestpractices.pdf

1. IBM WebSphere V4.0 Advanced Edition Handbook, SG24-6176-00 Redpiece, last update November-19-2001 5. WebSphere V3.5 Handbook, SG24-6161-00 Redbook, published January-10-2001

12. WebSphere V3 Performance Tuning Guide, SG24-5657-00 Redbook, published March-24-2000 [...] 13167 22 42_Null Indicator Variable in Fetch Statement12_John Piccoli16_jpiccoli@LOOK.CA31_Tue, 20 Nov 2001 22:29:07 -0500568_us-ascii A null indicator variable is required for a singleton select(against a table with non-nullable columns) that contains a SUM column function in order to handle a null value returned from an empty table.

Is this also true for a FETCH statement within a cursor?

We are on DB2 OS/390 V5.1

John C.D.S.

================================================ 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. 13190 46 37_Re: Image copy (DSNUTILB) performance14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Nov 2001 15:26:04 +1100408_US-ASCII Under BSAM, buffering is totally under program control. The utilities can access the appropriate information (DCBBUFNO after OPEN) and use your BUFNO - if they want to.

Presumably they want to.

Under QSAM, you have to use exit routines to override BUFNO information, and so is done less frequently.

James Campbell



On 21 Nov 2001, at 12:00, Ron, Yoram wrote: [...] 13237 43 46_Re: Null Indicator Variable in Fetch Statement14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Nov 2001 19:05:44 +1100304_US-ASCII An indicator variable is only _required_ when a null is actually retrieved - if you only get non-null values you don't need one, whether for a singleton select or a fetch.

If you are asking "will the sum function in a cursor return a null if the table is empty" the answer is "yes". [...] 13281 40 18_AW: database alias12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Wed, 21 Nov 2001 09:27:49 +0100676_iso-8859-1 Hi db2,

try SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1;

regards

Thomas

> -----Ursprüngliche Nachricht----- > Von: db2 [mailto:db2_user@YAHOO.COM] > Gesendet am: Dienstag, 20. November 2001 21:44 > An: DB2-L@RYCI.COM > Betreff: database alias > > I am trying to access plan table from visual explain. For > this I need to specify the database alias name. We have OS > 390 DB2 6.1 . Can anyone help me find this?. > > Thanks > > ===============================================To change your > subscription options or to cancel your subscription visit the > DB2-L webpage at http://www.ryci.com/db2-l. The owners of the > list can be [...] 13322 19 56_Shan Leatherman/MO/americancentury is out of the office.0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Wed, 21 Nov 2001 02:34:02 -0600547_us-ascii I will be out of the office starting 11/21/2001 and will not return until 11/26/2001.

If you need additional assistance, send a message to *DB or if you need immediate assistance page the primary DBA on call at (816) 292-5449 or contact the help desk (816) 340-4250.

Shan Leatherman

================================================ 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. 13342 31 45_Re: Table is not Available../UDB/SUN.. Urgent11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Wed, 21 Nov 2001 09:51:46 +0100427_us-ascii Hello Rajesh,

I need a clear understanding of what you have done. Does the following list describe your actions in the right order of time?

1. uow1 starts 2. create table T ... not logged initially 3. insert into T, and other DML 4. uow1 ends 5. backup db 6. uow2 starts 7. any sql against T ... 8. uow2 ends ... n. restore db from the backup taken at point 5. n+1. rollforward db until end of logs [...] 13374 85 47_Re: Windows 3270 Terminal Emulator for free !!!0_24_Bruce.Williamson@PSIR.IE31_Wed, 21 Nov 2001 02:38:11 -0600923_- Howzit Massimo?

Have a look at http://cws.internet.com/telnet.html for ratings, reviews, prices, download links of software et. etc..

Cheers Bruce





__________________________________________________

Bruce Williamson DB2 Database Administrator

perotsystems information resource(tm)

TSG DBA Computer Centre Cabinteely Dublin 18 Ireland

Bruce.Williamson@ps.net



On Mon, 19 Nov 2001 10:04:07 -0600, Andy Seuffert wrote:

>QWS3270 is what I have used: > >http://ww2.mcgill.ca/cc/software/qws3270/ > >Regards, > Andy Seuffert > >-----Original Message----- >From: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] >Sent: Monday, November 19, 2001 8:41 AM >To: DB2-L@RYCI.COM >Subject: Windows 3270 Terminal Emulator for free !!! > > >Few months ago i fond, round around the internet, a free software to [...] 13460 66 37_Declare Temporary Table' with DSNREXX19_Bruno Van den Eeden29_bruno.vandeneeden@FORTISAG.BE31_Wed, 21 Nov 2001 03:06:16 -0600383_- Hello,

I am trying to use DSNREXX with the sql statement 'Declare Tempory Table' , but I get always a bad return code RC(-1) .

The ADD function of RXSUBCOM is ok. The CONNECT to my DB2 subsystem is ok.

Does someone try using the DTT with DSNREXX?

The same sql statement with SPUFI works fine. So, the TEMP database and tablespace are well created. [...] 13527 31 67_Re: DB2 OS/390 V6: Request assistance with CREATE INDEX and DSNDB0710_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 21 Nov 2001 10:47:14 +0100449_us-ascii Ed,

I made a very rough estimation with IBM Xtimator, but I doesn't like it because I couldn't simulate a CREATE INDEX , I try with REBUILD INDEX but it heavy depends on I/O subsystem (I use RAMAC-3 as DASDs) . Moreover the table/index are 'simulated' (ie I added columns until I reached the given table/index record length). I simulate your CPU using a 9672 y76 (approx 800+ Mips) and I supposed a 50% BP hit. The results are: [...] 13559 27 57_Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Nov 2001 13:20:02 +0100424_iso-8859-1 Fellow listers,

In a batch JCL we have the need to check if a a DB2 for OS/390 subsystem is up before the batch program get started.

Anyone out there who can provide me a real world example of the JCL and DB2 command(s) needed ?

Thanks in advance.

With kind regards - mit freundlichen Grüssen, Georg H. Peter ---------------------------------------------------------------------- [...] 13587 20 46_Are there indexes degined for catalog tables ?14_Vamsi G Charan29_vamsicharan@CHENNAI.TCS.CO.IN31_Wed, 21 Nov 2001 11:42:40 +0530422_us-ascii Hi list ,

I have got a theoretical question : Are there indexes defined for catalog tables ?

can anybody kindly throw sime light on it ?

regards vamsi

================================================ 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. 13608 13 52_Re: can an Identity column be used as a foreign key?15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Wed, 21 Nov 2001 06:00:35 -0600398_- Jeremy

But in that case, you have to adjust the start-value, when you recreate the table, because LOAD doesn't update the MAXASSIGNED VALUE, right?

================================================ 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. 13622 49 50_AW: Are there indexes degined for catalog tables ?12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Nov 2001 13:50:12 +0100456_iso-8859-1 Vamsi,

with the following SQL you can find the indexes defined on catalog tables: select tbcreator, tbname, creator, name as indexname from sysibm.sysindexes where tbcreator = 'SYSIBM' order by 1, 2 asc with ur ;

And since Version 4 (or was it 5 ?) of DB2 for OS/390 you have the opportunity to create your own indexes on the DB2 catalog tables to assist with performance and object reporting queries that access the catalog. [...] 13672 59 50_Re: Are there indexes degined for catalog tables ?29_Chavali, Srikanth (Cognizant)26_CSrikant@CHN.COGNIZANT.COM31_Wed, 21 Nov 2001 18:09:03 +0530636_- Hi Vamsi, There are indexes defined for the catalog tables and you can find them in the catalog table SYSIBM.SYSINDEXES.

Regards, Srikanth

> -----Original Message----- > From: Vamsi G Charan [SMTP:vamsicharan@CHENNAI.TCS.CO.IN] > Sent: Wednesday, November 21, 2001 11:43 AM > To: DB2-L@RYCI.COM > Subject: Are there indexes degined for catalog tables ? > > Hi list , > > I have got a theoretical question : Are there indexes defined for > catalog tables ? > > can anybody kindly throw sime light on it ? > > regards > vamsi > > ================================================ > To change your subscription options [...] 13732 82 61_Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Wed, 21 Nov 2001 14:00:40 +0100524_iso-8859-1 Try using this:

//VERIFY EXEC PGM=IKJEFT01,DYNAMNBR=20, //STEPLIB DD DISP=SHR,DSN=DB2exitlibrary //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM (DSN1) END /*

If RC from tis step is equal 0 db2 should be up !

Best regards.









"Peter, Georg" @RYCI.COM> on 21/11/2001 13.20.02

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 13815 120 61_Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 21 Nov 2001 13:02:00 +0000653_us-ascii

Georg, I sometimes run the following REXX EXEC in batch to see if DB2 is up. Return Codes can be set depending on the 'curdstatus' value (I do this in another routine of the EXEC).

x=outtrap(x.,'*','NOCONCAT') execlin1 = "DSN SYSTEM(" || ssid || ")" queue 'END' address tso execlin1 x=outtrap('OFF') if x.0 = 0 then do x=outtrap(x.,'*','NOCONCAT') execlin1 = "DSN SYSTEM(" || ssid || ")" displn1 = '-DIS DATABASE(DSNDB01,DSNDB06) SPACENAM(*) LIMIT(*)' queue displn1 queue 'END' address tso execlin1 x=outtrap('OFF') db2avail = 'yes' cursdstatus = 'DB2 is available for thread connection' do e = 1 to x.0 parse upper var x.e [...] 13936 56 50_AW: Are there indexes degined for catalog tables ?12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Wed, 21 Nov 2001 14:02:46 +0100675_iso-8859-1 Hi Vamsi,

you can see the indexes on the catalog tables in sysindexes. Try s.th. like the following query:

SELECT A.TBNAME, A.NAME, B.COLNAME, B.COLSEQ FROM SYSIBM.SYSINDEXES A, SYSIBM.SYSKEYS B WHERE A.NAME = B.IXNAME AND A.CREATOR = B.IXCREATOR AND A.CREATOR = 'SYSIBM' ORDER BY 1, 2, 4 WITH UR;

regards

Thomas

> -----Ursprüngliche Nachricht----- > Von: Vamsi G Charan [mailto:vamsicharan@CHENNAI.TCS.CO.IN] > Gesendet am: Mittwoch, 21. November 2001 07:13 > An: DB2-L@RYCI.COM > Betreff: Are there indexes degined for catalog tables ? > > Hi list , > > I have got a theoretical question : Are there indexes > defined for [...] 13993 15 51_Suzanne Alexander/STL/Peabody is out of the office.17_Suzanne Alexander28_SAlexander@PEABODYENERGY.COM31_Wed, 21 Nov 2001 07:01:26 -0600389_us-ascii I will be out of the office starting 11/21/2001 and will not return until 11/26/2001.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14009 37 61_AW: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Nov 2001 14:27:22 +0100502_iso-8859-1 Thanks Massimo.

With kind regards, Georg

-----Ursprüngliche Nachricht----- Von: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] Gesendet am: Mittwoch, 21. November 2001 14:01 An: DB2-L@RYCI.COM Betreff: Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up

Try using this:

//VERIFY EXEC PGM=IKJEFT01,DYNAMNBR=20, //STEPLIB DD DISP=SHR,DSN=DB2exitlibrary //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM (DSN1) END /* [...] 14047 62 61_AW: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 21 Nov 2001 14:31:50 +0100494_iso-8859-1 Thanks, Andy.

With kind regards, Georg

-----Ursprüngliche Nachricht----- Von: Andy Hunt [mailto:Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK] Gesendet am: Mittwoch, 21. November 2001 14:02 An: DB2-L@RYCI.COM Betreff: Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up



Georg, I sometimes run the following REXX EXEC in batch to see if DB2 is up. Return Codes can be set depending on the 'curdstatus' value (I do this in another routine of the EXEC). [...] 14110 162 77_Re: Mixed Sessions: HELP!! ( JAVA-DB2ConnectEE-DB2v6OS390-StoredP roced ures)12_Myron Miller22_Myron.Miller@BMWNA.COM31_Wed, 21 Nov 2001 08:43:11 -0500552_iso-8859-1 You can go to the DB2 UDB site and see the various fixes. IBM releases sets of fixes in what's called a fixpack and numbers them sequentially from the release of the product: 1,2,3,4 etc. Fixpack 2a is a special correction fixpack for FIXPACK 2 that resolves some problems with UDB, especially on AIX servers. The current fixpack is 4. Catch in using 4 is if you are using DB2 stored procedure builder, you must be fairly current with your DB2 maintenance as there is a required PTF for DB2 OS/390 that must be on for Fixpack 4 to work [...] 14273 25 61_Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 21 Nov 2001 14:52:33 +0100369_us-ascii Hi

Massimo (Hi Max how is it) gave a very quick and fast solution.

Anyway I've a general-purpose REXX execs that check all existing subsystems running on your LPAR using CVT concatenation and it can be easily customized for DB2 users to check if DB2(s) address space(s) are running.

If you think it may be useful let me know offline. [...] 14299 47 16_REBIND vs. BATCH14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Wed, 21 Nov 2001 15:05:18 +0100584_iso-8859-1 Hi everyone out there in DB2-Land,

we have an application that does our daily rebind-job at about 11 p.m. At the same time there's a number of batch-jobs abending, but there's also a number of batch-jobs completing successfully. We do get an -904 every now and then in the job-output, and the rebind-job gets an X'00E30083' - condition. When the batch-jobs get restarted about an hour later they will run just fine. Now we wonder whether, and if yes, how the rebind might affect our batch-window ? Does anyone have a clue ? Any suggestion is more than welcome. [...] 14347 234 77_Re: Mixed Sessions: HELP!! ( JAVA-DB2ConnectEE-DB2v6OS390-StoredP roced ures)13_Villa Horacio17_hvilla@TTI.COM.AR31_Wed, 21 Nov 2001 11:12:20 -0300306_iso-8859-1 This is a question on JAAP's problem: Could this happen because JAAP is using Temporary Tables in his stored procedures and all the users are connecting to DB2 with the same userid and everyone goes to the same Temporary Table? Kind regards, Horacio Villa TTI S.A. Buenos Aires - Argentina [...] 14582 42 6_Re: V79_Ted Pesta18_tpesta@AMQUEST.COM31_Wed, 21 Nov 2001 09:39:00 -0500624_iso-8859-1 Thank you to everyone who responded. The help was very much appreciated.

Ted Pesta AmQUEST, Inc.





-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Tuesday, November 20, 2001 11:57 AM To: DB2-L@RYCI.COM Subject: Re: V7

I'm pretty cautious, since I get the complaints directly and often several times. V7 looks very good. The V7 APAR backlog is about 20% of the V6 backlog. I try to chase down problem rumors, and the latest was not related to the code, for example. For a service level recommendation, use the IBM Consolidated Service Test. [...] 14625 32 69_Pittsburgh DB2 User Group - Calendar of Events thru end of March 200210_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Wed, 21 Nov 2001 09:51:25 -0500334_us-ascii Can you believe it's almost 2002! I finally got our http://www.db2parug.org website updated w/our upcoming 2002 events! Below are the details. If you wish to register for either of the upcoming V7 classes, please let me know. Tks!! Seeya

March 6th Pittsburgh DB2 User Group Meeting (Agenda yet to be determined.) [...] 14658 27 69_Central PA DB2 User Group - Calendar of Events thru end of March 200210_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Wed, 21 Nov 2001 09:49:42 -0500422_us-ascii Greetings! Wow, can you believe it's almost 2002! I finally got our http://www.db2parug.org website updated w/our upcoming 2002 events! Below are the details. If you wish to register for the upcoming V7 class, please let me know. Tks!! Seeya



March 4th-5th DB2 V7 Migration Richard Yevich of YL&A. $300



March 14th Central PA DB2 User Group Meeting (Agenda yet to be determined.) [...] 14686 38 52_Re: can an Identity column be used as a foreign key?17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Wed, 21 Nov 2001 08:00:58 -0600537_us-ascii Yes





From: Walter Janissen @RYCI.COM on 11/21/2001 06:00 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: can an Identity column be used as a foreign key?



Jeremy

But in that case, you have to adjust the start-value, when you recreate the table, because LOAD doesn't update the MAXASSIGNED VALUE, right? [...] 14725 117 28_WLM Application Environments13_Brunner Don J21_Don.J.Brunner@IRS.GOV31_Wed, 21 Nov 2001 10:05:55 -0500421_iso-8859-1 My question concerns defining DB2 WLM Application Environments in a Data Sharing Environment. It appears that you can't specify the Group Attach Name on the DB2SSN= parameter. Is this correct?

In the tests I've done so far, the messages in the log states a procedure is being started for a particular subsystem (which happens to be an actual member of the Group rather than the Group name itself). [...] 14843 83 32_Re: WLM Application Environments0_17_sjvagnier@AEP.COM31_Wed, 21 Nov 2001 10:39:32 -0500496_us-ascii Hello Don,

I am assigning a Group Attach name to DB2SSN= in a two-way Data Sharing environment with no connectivity problems using Control Center. What happens if you specify the actual member name? Does it work then?

Regards,

**************************************** Steve Vagnier Principal IT Systems Administrator American Electric Power Shared Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-223-3677 Audinet: 200-3677 [...] 14927 43 29_Bootstrap Log Synchronization9_John Rich17_JOHN.RICH@BFI.COM31_Wed, 21 Nov 2001 10:33:00 -0600363_- I have a DB2 system with two log files; a primary (Copy1) and backup (Copy2).

The log map, shows the following archive log generations:

Copy1: 637 through 744 Copy2: 544 through 575, and 637 through 744

When I do DSNJU003 log deletes to remove the Copy2 versions 544 - 575, then I get the following error on subsequent system startup: [...] 14971 13 41_Re: Declare Temporary Table' with DSNREXX9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 21 Nov 2001 10:45:20 -0600371_- You need to do a PREPARE/EXECUTE or an EXECUTE IMMEDIATE of the statement.

Jim Ruddy DB2 for z/OS and OS/390 Development

================================================ 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. 14985 17 22_Re: Rebuilding of NPIs9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 21 Nov 2001 10:51:02 -0600322_- In addition I would like to see the utility output to see what degree of parallelism you are getting (i.e., how many partitions are being "unloaded" - actually means key values being unloaded - in parallel).

You are on at tleast DB2 for OS/390 V6, right?

Jim Ruddy DB2 for z/OS and OS/390 Development [...] 15003 22 33_DB2 Connect Version Compatibility12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 21 Nov 2001 10:43:00 -0500419_- All of the DB2 Connect packages are installed into the NULLID collection. If we install a new version/Fixpack of DB2 connect, IBM recommends a rebind. Will DB2 Connect continue to work if for Example there are PCs accessing DB2 on OS/390 directly: DB2 Connect PE V7 FP3 DB2 Connect PE V7 FP4 DB2 Connect V6 FP5 Client Admin using DB2 Connect EE V5.2 In the above scenario, the packages in DB2 will be PE V7 FP4. [...] 15026 65 33_Re: Bootstrap Log Synchronization16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 21 Nov 2001 12:05:55 -0500416_iso-8859-1 You do not need to delete and define. Just REPRO Copy1 onto Copy2.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: John Rich [mailto:JOHN.RICH@BFI.COM] Sent: Wednesday, November 21, 2001 11:33 AM To: DB2-L@RYCI.COM Subject: Bootstrap Log Synchronization



I have a DB2 system with two log files; a primary (Copy1) and backup (Copy2). [...] 15092 113 32_Re: WLM Application Environments13_Brunner Don J21_Don.J.Brunner@IRS.GOV31_Wed, 21 Nov 2001 12:26:37 -0500460_iso-8859-1 Steve,

You do mean in the WLM ApplEnv definition and not in the associated Started Task? If I specify the actual member name in the WLM ApplEnv definition it works, if I specify the Group name in the same place I get the connect error.

Don

-----Original Message----- From: sjvagnier@AEP.COM [mailto:sjvagnier@AEP.COM] Sent: Wednesday, November 21, 2001 10:40 AM To: DB2-L@RYCI.COM Subject: Re: WLM Application Environments [...] 15206 96 33_Re: Bootstrap Log Synchronization15_Gordon Fishwick39_Gordon.Fishwick@SCOTTISH-SOUTHERN.CO.UK31_Wed, 21 Nov 2001 17:33:05 +0000521_us-ascii Hi John,

I'd certainly recommend following the manual - just make sure you take a backup of the bootstrap you are going to copy over...

Best regards,

Gordon Fishwick DB2 Systems Programmer Scottish and Southern Energy plc







John Rich on 21/11/2001 16:33:00

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Gordon Fishwick/HAV/SSE) Subject: [DB2-L] Bootstrap Log Synchronization [...] 15303 165 43_Southeastern Federated Database Vendor Fair13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Wed, 21 Nov 2001 09:49:53 -0800538_us-ascii (note:)If you want to go and have not signed up yet, please sign up ASAP so we can get an count for ordering food.

The 2001 Southeastern Federated Database Vendor Fair, sponsored by SIRDUG and CltOUG, will be held next week, just south of Charlotte. 14 of the best-known vendors in the business will be demonstrating their products, giving presentations, handing out information, and (of course!) giving away great door prizes. And all of it, including plenty of good food, is free. Don't miss out -- register today. [...] 15469 68 33_Re: Bootstrap Log Synchronization12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 21 Nov 2001 19:45:35 +0200484_windows-1255 Hi, Since you already have DB2 down, it's ok. to do it. You can look at "recover bsds" command (db2 commands book) as well but doing the copy from bsds01 to bsds02 while db2 is down should solve your problem.

Isaac Yassin yassini@bezeqint.net



----- Original Message ----- From: "John Rich" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, November 21, 2001 6:33 PM Subject: Bootstrap Log Synchronization [...] 15538 24 30_REXX programming for Beginners13_Olson, Carlos14_COlson@QRS.COM31_Wed, 21 Nov 2001 10:01:07 -0800542_iso-8859-1 Can anyone recommend a good REXX programming for beginners book as well as a good REXX reference book?

Thanks in advance,

Carlos Olson Database Administrator QRS Corporation 510-215-3873 colson@qrs.com IBM Certified Solutions Expert DB2 V7.1 Database Administration for OS390

================================================ 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. 15563 27 10_-904 on 4K11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 21 Nov 2001 13:20:28 -0500545_iso-8859-1 We were having trouble with dynamic SQL running wild, so last weekend we set PARAMDEG to 4 (it did default to 0) to limit parallelism. Now we have a batch job running DSNTIAUL suddenly getting a -904 on the 4K tablespaces. It ran fine for months, runstats haven't been re-run since before the last successful execution, and the tables have only grown slightly. Could the PARAMDEG change be the cause? There are no entries in PLAN_TABLE since this is dynamic SQL. Would it limit the number of 4K datasets it will use for sorting? [...] 15591 99 32_Re: WLM Application Environments0_17_sjvagnier@AEP.COM31_Wed, 21 Nov 2001 13:24:32 -0500622_us-ascii Don, change the WLM ApplEnv definition to DB2SSN=&IWMSSNM. This allows WLM to substitute the applicable member name that is requesting the service.

Hope this helps....

**************************************** Steve Vagnier Principal IT Systems Administrator American Electric Power Shared Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-223-3677 Audinet: 200-3677







Brunner Don J cc: Sent by: DB2 Subject: Re: WLM Application Environments Data Base Discussion List [...] 15691 38 15_Position Wanted18_J. Michael Morrill17_john@JMORRILL.NET31_Wed, 21 Nov 2001 10:22:55 -0800412_us-ascii Greetings!

I am looking for a DB2 DBA, Data Modeler or Application Programmer position in the northern Colorado area. I will be available March 1st, 2002.

I have over 15 years experience in DB2/OS390, plus team leadership, project management and application development experience. I also have some experience in DB2 UDB and was as other database management systems (MS-SQL, Oracle). [...] 15730 21 34_Re: REXX programming for Beginners9_Jim Ruddy18_jaruddy@US.IBM.COM31_Wed, 21 Nov 2001 12:17:45 -0600378_- Mike Cowlishaw is the inventor of REXX and his book is the best I have seen.

The REXX Language, M. F. Cowlishaw; In English: ISBN 0-13-780735-X Prentice-Hall, 1985; ISBN 0-13-780651-5 (Second edition), 1990; In German: ISBN 3-446-15195-8 Carl Hanser Verlag, 1988; ISBN 0-13-780784-8 P-H International, 1988; In Japanese: ISBN 4-7649-0136-6 Kindai-kagaku-sha, 1988 [...] 15752 86 20_Re: REBIND vs. BATCH13_Olson, Carlos14_COlson@QRS.COM31_Wed, 21 Nov 2001 10:52:16 -0800478_iso-8859-1 Ruediger, You cannot rebind an executing program and you cannot execute a program being rebound without risk of timeout. I'm just curious as to why your shop automatically rebinds programs on a daily basis? I would be concerned about getting unpredictable access path problems. My suggestion would be to remove the automatic rebind job and only rebind when something significant to the optimizer has changed and you predict an improved access path would result. [...] 15839 100 17_SET CURRENT SQLID10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 21 Nov 2001 12:02:39 -0700561_iso-8859-1 Hi list, We are DB2 for OS/390 V7. We have a requirement for each branch only see rows that belong to itself so we create different view for each branch. All views have same view name with different qualifier(schema name). User access view from their WEB browser through the WEB server which running Business Object. We use RACF to protect DB2 so view qualifier is defined as a RACF group and userids are connected to the proper RACF group. The problem is there is no way for user or Business Object to do 'SET CURRENT SQLID' to get proper view [...] 15940 24 33_Re: Bootstrap Log Synchronization12_Sue Janowitz22_sjanowitz@MEDIAONE.NET31_Wed, 21 Nov 2001 14:21:49 -0500321_iso-8859-1 John, I think the confusion may be because there are 2 BSDS - bootstrap - datasets - and 2 copies of the archive log. You are deleting the extra copy 2 archive logs, but I suspect you're only deleting them from one of the BSDS datasets. When DB2 comes up, it sees that the BSDS 1 and 2 are not identical. [...] 15965 47 37_Re: DB2 Connect Version Compatibility13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 21 Nov 2001 13:30:54 -0600608_iso-8859-1 Bob,

Yes, any existing packages (corresponding to other versions and/or fixpack levels) will not be affected except for the following caveat:

Theoretically only new packages would be bound with a new version, however, we encountered a painful situation where "old" existing packages, for which previous releases were dependent, were re-bound. No documentation or even the little utility which lists the packages to be bound had warned us of this. The result was a total lockout of production workload for around 5 minutes while the dependent packages were locked during rebind. [...] 16013 82 21_Re: SET CURRENT SQLID0_19_Tim.Lowe@STPAUL.COM31_Wed, 21 Nov 2001 14:00:49 -0600607_us-ascii Grace, Is there any way that you could setup a single view that did a join with another table that indicated which sqlids could view which branches? For example: table branch_table column branch, name table branch_auth_table columns branch, sqlid view branch_view select t1.branch, name from branch_table t1, branch_auth_table t2 where t1.branch = t2.branch and t2.sqlid = current sqlid The authority table could control which sqlids could see which branches, and secondary authids could be added to enable different people to see different groups by setting their sqlid to the different ids. [...] 16096 21 18_Re: database alias10_Rob Wright17_rwright@LIC.CO.NZ31_Thu, 22 Nov 2001 09:20:44 +1200595_us-ascii The database ALIAS name is the name of your ODBC connection that will be used to connect to DB2. To configure Visual Explain, you will first have to configure a DB2 ODBC connection. You will require some form of connect software that is compatible with DB2. The software will depend on the operating system from which you wish to connect. For example, if you have a unix based client, you will need to dig deep and buy DB2 Connect EE / UE or equivalent. For windows/Linux, you can try DB2 Connect Personal Edition. Take a look at http://www-4.ibm.com/software/data/db2/db2connect/ [...] 16118 30 40_Question about Insert on DB2 V6.1 OS/39011_Robert Jans26_robert.jans@ALBERTSONS.COM31_Wed, 21 Nov 2001 13:36:51 -0800557_iso-8859-1 Hi, listers. Something of an oddball question. I'm looking an INSERT statement in an application program in Omegamon for DB2. Omegamon reports: SQL Request Type = DYNAMIC SQL Call Type = INSERT SQL Statement Number = 00991

I don't recall seeing DYNAMIC for other INSERT statements. The application has inserted about 4.5M rows into this table and has been running about 21 hours. Just a bit (!) longer than expected. It has about 2M more to go in this run, with 3 more similar runs scheduled. The 4 runs should be add about 30M rows. [...] 16149 64 25_Re: -904 on 4K & PARAMDEG11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 21 Nov 2001 16:36:13 -0500336_iso-8859-1 Upon further investigation, it appears that we could use 5 4K work files. At least we got the -904 messages on 5 of them in the MSTR address space. So, we're going to increase it to 6 so we can use all 7 work files.

Is there anyone out there that can explain what these fields mean on the accounting long report? [...] 16214 63 44_Re: Question about Insert on DB2 V6.1 OS/39013_BL.Tink Tysor16_tink@BLTYSOR.COM31_Wed, 21 Nov 2001 14:16:19 -0800584_us-ascii Robert,

Is there any reason the choose not to do loads?

Tink --- Robert Jans wrote: > Hi, listers. Something of an oddball question. I'm > looking an INSERT > statement in an application program in Omegamon for > DB2. Omegamon reports: > SQL Request Type = DYNAMIC > SQL Call Type = INSERT > SQL Statement Number = 00991 > > I don't recall seeing DYNAMIC for other INSERT > statements. The application > has inserted about 4.5M rows into this table and has > been running about 21 > hours. Just a bit (!) longer than expected. [...] 16278 90 44_Re: Question about Insert on DB2 V6.1 OS/39011_Robert Jans26_robert.jans@ALBERTSONS.COM31_Wed, 21 Nov 2001 14:49:37 -0800419_- Hi, Tink. Yes. There is data in the input file for 2 tables. There has to be logic applied to the input record (data modification) based on which table the record is going to be inserted into. I realize this implies that the app actually inserts into 2 tables. Yes, that is correct. However data volumes are such that the table referred to in this insert will receive about 6M of the 6.2M input records......... [...] 16369 85 50_Re: Are there indexes degined for catalog tables ?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 22 Nov 2001 11:08:39 +1100421_ISO-8859-1 Just a couple of points:

If you hadn't noticed, the major difference between Georg's SQL and Thomas', is that Thomas' will not pick up any user created indexes which do not have SYSIBM as their creator-id. Personally, I go for paranoia and use SYSINDEXES.DBNAME = 'DSNDB06' since there is no guarantee that every table in the catalog will use SYSIBM as its creator. (Does now, but what about V10?) [...] 16455 108 61_Re: Batch-Jobs: Checking if a DB2 for OS/390 susbsystem is up14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 22 Nov 2001 11:08:39 +1100310_US-ASCII Just a REXX programming tip: what happens when DB2 is down? Your END sub-command is left in the data stack - ready to pop up when you least expect it to.

I always put a "newstack" before and a "delstack" after playing with the data stack. That way I make sure I discard what I don't want. [...] 16564 47 37_Re: DB2 Connect Version Compatibility14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 22 Nov 2001 11:08:39 +1100592_US-ASCII Although they are bound into the same collid, I believe they have (well, "should have", since Dave's note suggest otherwise) unique program-name/versions. Hence, it is not that the packages are compatable, but rather each platform/version/fixpack has its own.

James Campbell

On 21 Nov 2001, at 10:43, BOB JEANDRON wrote:

Priority: Normal Date sent: Wed, 21 Nov 2001 10:43:00 -0500 Send reply to: DB2 Data Base Discussion List From: BOB JEANDRON Subject: [DB2-L] DB2 Connect Version Compatibility To: DB2-L@RYCI.COM [...] 16612 20 29_-104 from DSN8ES1 in DSNTEJ6316_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Wed, 21 Nov 2001 19:34:00 -0800423_- We are DB2 for OS/390 V6 and just starting with stored procedures. I got a -104 from IVP job DSNTEJ63 in step PH063S03 trying to register the SQL stored procedure. DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "".

The SQL causing the problim is - CREATE PROCEDURE DSN8.DSN8ES1 ...... COMMIT ON RETURN NO P1: BEGIN NOT ATOMIC DECLARE EMPLOYEE_NUMBER CHAR(6); Is there a PTF to correct this? [...] 16633 27 10_ODBC error13_Abi Manoahran23_abi@PROTEOMESYSTEMS.COM31_Wed, 21 Nov 2001 22:12:21 -0600347_- Hi Folks,

I am using a DB2 database server 7.2 EEE on Linux box and trying to connect it from Windows NT with DB2 ODBC connection by using Oracle Reports 6. ( DB2 admin client is installed on NT Box)

I can connect and see all the tables from DB2 but when I try to get blob field then I am getting the following error message. [...]