1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2003, week 3 2 31 27_Package NULLID.SQLLF000 ???37_=?iso-8859-7?B?xMfMz8rBIMrBy8vJz9DH?=24_dimokap@INTERAMERICAN.GR31_Tue, 15 Jul 2003 09:00:09 +0300344_iso-8859-7 Hello List,

lately, some problems i faced in our production DB2 (V6) with dynamic sql distributed applications, had to do with the package SQLLF000 of the nullid collection.I know what the nullid.packages are for, but I would like to find out what exactly that certain package does.Could anybody shed some light on it??? [...] 34 103 35_Re: REBDP prohibits reorg (DSNU214I0_20_Gerhard.Heiss@RUV.DE31_Tue, 15 Jul 2003 10:07:12 +0200483_iso-8859-1 Tony,

both did'nt work. Even REPAIR INDEX (index name) NORBDPEND ended with RC=8 ( DSNU212I ). What helped was: -start .... access(FORCE). REBDP was reset and tablespace could be reorged.

thank you

regards

gerhard heiss





-----Original Message----- From: Provenzola, Tony [mailto:Tony.Provenzola@NIKE.COM] Sent: Monday, July 14, 2003 5:52 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: REBDP prohibits reorg (DSNU214I [...] 138 14 35_Re: REBDP prohibits reorg (DSNU214I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 15 Jul 2003 04:19:19 -0500483_- Gerhard

The only possibilities, to get rid of REORGP is to LOAD REPLACE or to REORG these partitions. Since you have dropped your unload-datasets, you MUST reorg once again. No START ACCESS(FORCE) nor any REPAIR helps.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 153 15 35_Re: REBDP prohibits reorg (DSNU214I33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 15 Jul 2003 05:00:23 -0500512_- Gerhard

There is some risk, if you start an index using ACCESS(FORCE) and than reorganize the tablespace, because the reorg by default, uses the index to unload the data. Therefore you can get data loss (which I experienced a couple of weeks ago).

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 169 51 35_Re: REBDP prohibits reorg (DSNU214I0_20_Gerhard.Heiss@RUV.DE31_Tue, 15 Jul 2003 13:55:32 +0200343_iso-8859-1 Walter,

using SORTDATA option ( as Tony Provenzola suggested earlier )should prevent potential loss of data cause no index is used. Still I wonder why the participating partitions, after limitkey change, are locked in such a restrictive state. Reorg pending is clearly necessary, but why is it not even allowed to read? [...] 221 61 15_FW: DR Question13_Barb Milligan25_Barb_Milligan@CARGILL.COM31_Tue, 15 Jul 2003 07:01:10 -0500431_US-ASCII For our DR, SYSUTILX,DBD01 and SYSCOPY we restore these first from backup copies. Then the rest of the system tables can be restored. Then you can apply the logs since the last backup.

Barb

-----Original Message----- From: LISTSERV@LISTSERV.YLASSOC.COM [mailto:LISTSERV@LISTSERV.YLASSOC.COM] Sent: Monday, July 14, 2003 8:13 AM Cc: dlamas@DUKE-ENERGY.COM Subject: DR Question



Hi Listers, [...] 283 46 17_Re: Odd SQL error11_David Nance16_DWNance@FHSC.COM31_Tue, 15 Jul 2003 08:33:33 -0400518_US-ASCII No, it ended up I needed as Virginia suggested, that I needed the following TIMESTAMP(CHAR(B.D_ENTERED,ISO) || rest of timestamp that I wanted)

Dave Nance First Health Services, Corp. (804)527-6841



>>> dsw-dba@JUNO.COM 7/14/03 10:19:14 PM >>> Dave:

Can I infer from this that you did not have the DSNHDECP load module library (SDSNEXIT) concatenated anywhere in your JOBLIB or STEPLIB for the DSNTIAUL job? That would explain why SPUFI and QMF worked but DSNTIAUL did not... [...] 330 204 15_Re: DR Question13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Tue, 15 Jul 2003 09:01:20 -0400398_us-ascii We, too, found that putting the logs on DASD made a dramatic improvement in recovery time. (In our case, we also found that using 3490 hardware compression on the archive log tape seriously slowed log reads, to the point that one 750-mb log took two hours.)

IBM recommends that, if you are moving your log from tape to disk, you use IDCAMS REPRO to do the file copy operation. [...] 535 212 14_Re: ABEND -31012_Smith, Bruce22_Bruce.Smith@BBANDT.COM31_Tue, 15 Jul 2003 09:24:10 -0400558_iso-8859-1 Steve:

You are correct in your example. I guess it is the classic example of the computer doing what I said instead of what I meant. Perhaps it's a problem with the "AS" being optional?

What I'd really like to see the DB/2 pre-compiler do is match the columns of the DECLARE CURSOR to the host variables in the FETCH INTO. It has the information it needs. It could even check to make sure the data types of the columns are compatible with the data types of the host variables if there is an INCLUDE of the DCLGEN copybook. This [...] 748 27 40_DB2 UDB v7 on AIX - Client configuration15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Tue, 15 Jul 2003 10:06:01 -0400313_- When I try to set up a DB2 run time client, the checkbox (1) that specifies "physically resides on the host" is not there. In the database name (3), you can only type in 8 characters.

When I installed Enterprise Edition, I then got the checkbox and could type in all 10 characters on database name. [...] 776 114 14_History Tables13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Tue, 15 Jul 2003 11:03:54 -0400674_US-ASCII Esteemed List,

Maybe it's me; maybe I'm just not seeing something.

My question revolves around the Catalog "History" tables (SYSIBM.SYSINDEXES_HIST, SYSIBM.SYSTABLES_HIST, etc). I perused these tables and noted multiple entries in each for various objects. For example, there were 18 entries in SYSTABLES_HIST for one of our production tables.

But what distinguishes these rows? Are they in some order, or identified in some way? The only thing can find is the STATSTIME column, but the manual description is less than helpful, to wit: If RUNSTATS updated the statistics, the date and time when the last invocation of RUNSTATS updated the [...] 891 46 19_Re: FW: DR Question21_Edward C. Benoit, Jr.19_DB2Automate@AOL.COM29_Tue, 15 Jul 2003 11:16:12 EDT310_US-ASCII Dan, To automate the complete DB2 DR process, save your self a lot of problems and join a free DB2/IMS/CICS DR discussion list. you may wish to visit: Recovery Knowledge http://www.recoveryknowledge.com



Regards, Ed.





938 40 35_Re: REBDP prohibits reorg (DSNU214I14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Tue, 15 Jul 2003 10:42:38 -0500349_us-ascii Gerhard, Reorg Pending inhibits reading because until the tablespace partitions have been reorged, the values for the limit keys in the reorg pending partitions may not reflect the actual data that is in those partitions. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: All opinions are strictly my own. [...] 979 28 52_Determining ccess Path Differences Between V6 and V715_Joseph, Michael27_Michael.Joseph@CAREMARK.COM31_Tue, 15 Jul 2003 11:43:38 -0500613_iso-8859-1 Hello List

Once again I turn to my list brethren for sagely advice. We are soon to migrate from DB2 V6 to V7 on OS/390. There are some rumblings here about possible shareware to evaluate potential access path differences that might be incurred during rebind. We have Platinum Plan Analyzer and could utilize the compare feature but we're not hot on this option mainly due to the non-specific output it generates (maybe I'm not using it right). So, are there any products out there that specifically address this requirement? Or has anyone developed a home-grown variety that proved useful? [...] 1008 23 18_Data Propagator V821_Claypool, Alisa@HHSDC21_AClaypoo@HHSDC.CA.GOV31_Tue, 15 Jul 2003 10:17:19 -0700359_- We are currently using Data Propagator V7 on OS/390 2.10. End of support for this product is 11/30/03, so we're preparing to upgrade. Has anyone done this? If you have, please share your experience with me.

All responses are appreciated.

Thanks, Alisa Claypool HHSDC DB2 Support wk (916) 454-8194 fax (916) 739-7787 aclaypoo@hhsdc.ca.gov [...] 1032 16 16_DB2 REXX Connect7_db2_dba21_db2_dba@BELLSOUTH.NET31_Tue, 15 Jul 2003 12:25:29 -0500531_- I have been a CLIST user until just recently when we installed the REXX DB2 interface. I can code a successful REXX procedure on an lpar that has only one DB2 on it and it works just fine. I can even comment out the LIBDEF for ISPLLIB and it still work. However, wen I move this procedure to an lpar with multiple DB2s and include the LIBDEF statement for ISPLLIB and use the dsnload library that includes the program DSNREXX I receive a -3 return code after the CONNECT statement. Any recommendations would be appreciated. [...] 1049 92 17_Re: Odd SQL error14_Virginia Davis26_Virginia.Davis@PREMERA.COM31_Tue, 15 Jul 2003 10:50:48 -0700287_iso-8859-1 Both Daves,

I believe Dave W's inference is correct. It's been 14 years since I did an install and on a Friday afternoon I couldn't for the life of me think of where the date format was. (Hence my inane comment about Plan or Package settings, but I digress . . .) [...] 1142 32 11_unsubscribe16_Samir Chatterjee34_Samir.Chatterjee@BANKOFAMERICA.COM31_Tue, 15 Jul 2003 18:59:12 +0100528_- unsubscribe



_____________________________________________________________________ Notice to recipient: The information in this internet e-mail and any attachments is confidential and may be privileged. It is intended solely for the addressee. If you are not the intended addressee please notify the sender immediately by telephone. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. [...] 1175 53 17_Re: CLUSTERRATIOF13_Marcia Riedel26_mriedel@TUCSONELECTRIC.COM31_Tue, 15 Jul 2003 13:17:57 -0500598_- Hello, Michael.

You do have a "taker"! I ran across this recently when researching why some column statistics were not correct. (We are V6, maintenance Oct 2002, plus PQ69693 statistics fix).

A customer information package here has a column used as the high-order key column in numerous unique indexes. It has one (yes, 1) value only. A package was recently re-bound and performance took a huge dive. A different access path was chosen based on COLCARD on this column. The value for this column in the queried table was >1 and the data itself has only one value (verified with [...] 1229 133 17_Re: Odd SQL error0_22_BRIAN_GOLDBERG@QVC.COM31_Tue, 15 Jul 2003 14:46:04 -0400386_us-ascii Just an FYI. I've always encouraged the use of explicit definition of the date format in any SQL. I got caught in this once when a shop outsourced its operations, and the new site changed the default date format (although they swore to me that they didn't), and much of the SQL stopped working. To me, it was worth any additional overhead that the formatting would incur. [...] 1363 53 55_DB2 UDB v8.1 for Windows 2000 remote connection problem11_John Kruger23_DHSPA43@DHS.STATE.IL.US31_Tue, 15 Jul 2003 13:51:19 -0500435_US-ASCII Greetings All! I installed DB2 UDB v8.1 for Windows 2000 and can no longer connect to the remote databases on AIX. The remote databases are on AIX v3.3.3 and the db2level is DB2 UDB Fixpak 8. The error message I receive is "invalid userid or password". I tried other valid id's and I receive the same error. DB2 UDB v8.1 appears to be passing hidden characters to AIX because AIX will revoke the id after three attempts. [...] 1417 48 31_Re: Package NULLID.SQLLF000 ???10_Dale Smock28_Dale.Smock@ARVATOSYSTEMS.COM31_Tue, 15 Jul 2003 13:51:48 -0500731_iso-8859-7 It is the package used for the call level interface of DB2 Connect from Microsoft Tools (Access, Excel, Query) with Isolation(CS) (cursor stability).

Dale Smock

-----Original Message----- From: dimokap@INTERAMERICAN.GR [mailto:dimokap@INTERAMERICAN.GR] Sent: Tuesday, July 15, 2003 1:00 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Package NULLID.SQLLF000 ???



Hello List,

lately, some problems i faced in our production DB2 (V6) with dynamic sql distributed applications, had to do with the package SQLLF000 of the nullid collection.I know what the nullid.packages are for, but I would like to find out what exactly that certain package does.Could anybody shed some light on it??? [...] 1466 187 18_Re: History Tables14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 15 Jul 2003 22:11:17 +0100457_iso-8859-1 Hi Lockwood,

The statstime columnn is the timestamp when RUNSTATS was run on the target table (ie the time that the statisics in the _HIST table were collected.

This is what the description says if you read it after understanding what it is trying to say(!)



Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 1654 30 111_Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset ?11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Tue, 15 Jul 2003 16:47:00 -0500312_iso-8859-7 Hi Gurus,

I just needed a confirmation that I don't need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset. Yeah I won't be able to create tablespace even after I had defined my VSAM dataset if there are any thread active on the database. [...] 1685 48 116_Re: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defin ing Workspace Tablespace as User Managed Dataset ?11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 15 Jul 2003 16:10:08 -0700380_- Amit, No you don't. I've dropped and created temp tablespaces in v7 without stopping DSNDB07. cliff:-)

-----Original Message----- From: Sinha, Amit [mailto:Sinha.Amit@MBCO.COM] Sent: Tuesday, July 15, 2003 2:47 PM To: DB2-L@listserv.ylassoc.com Subject: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset ? [...] 1734 38 22_Re: Data Propagator V812_John Piccoli18_jpiccoli@SPRINT.CA31_Tue, 15 Jul 2003 20:24:56 -0400321_us-ascii Alisa,

End of support for DPROPR 7.1 on OS/390 is not 11/30/03 and is currently undetermined. I've confirmed this with IBM support. There was an error in a recent IBM letter distributed in the U.S. which identifed 11/30/03 as the end of support date. This was to have been corrected.

John CDS [...] 1773 75 17_Re: Odd SQL error13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 16 Jul 2003 00:36:20 GMT634_- Ginny:

The installation default for DATE and TIME is ISO. If your site's customized DSNHDECP module also specifies ISO for DATE and TIME, you'll get consistent results regardless of whether you have SDSNEXIT in the LOADLIB/STEPLIB concatenation or not.

However, if your customized DSNHDECP module specifies something other than ISO (like USA), I would think you would get inconsistent results depending on whether you have SDSNEXIT in the LOADLIB/STEPLIB concatenation or not. Haven't tested this out though (our customized DSHDECP has ISO specified, same as the default, so I'll get the same output either way). [...] 1849 24 17_Re: Odd SQL error13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 16 Jul 2003 00:39:35 GMT560_- Having been caught by this once or twice myself (in a previous Sysprog incarnation), I think this is an excellent idea!

David

--- BRIAN_GOLDBERG@QVC.COM wrote:

Just an FYI. I've always encouraged the use of explicit definition of the date format in any SQL. I got caught in this once when a shop outsourced its operations, and the new site changed the default date format (although they swore to me that they didn't), and much of the SQL stopped working. To me, it was worth any additional overhead that the formatting would incur. [...] 1874 46 115_Re: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset ?13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 16 Jul 2003 00:55:50 GMT615_- I don't think it's necessary to -STOP DSNDB07 before DEFINEing the VSAM and CREATEing _new_ tablespaces (if that's what you're doing).

I don't think it's absolutely necessary to -STOP the entire database DSNDB07 before DELETE/DEFINING and DROP/CREATEing existing tablespaces.

However, the key would be (as you say) "when there are no threads active on the database DSNDB07". I think I would at least -STOP the TABLESPACE I was about to blow away and re-create, just so nothing sneaks in and tries to use it while I'm working on it. Unless I'm in a maintenance window when I _know_ nothing else [...] 1921 32 57_Anita D N CHAN/SED IT APH/HBAP/HSBC is out of the office.10_Anita Chan23_anitadnchan@HSBC.COM.HK31_Wed, 16 Jul 2003 14:30:47 +0800635_us-ascii I will be out of the office from 07/16/2003 until 07/18/2003.

I will respond to your message when I return.

For urgent matter, please contact Fung Kam Yiu on ext 21555 (IDMS) or Vera Tang on ext 21807 (DB2).







********************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...] 1954 121 11_unsubscribe13_Ealey, Paul M18_paul.ealey@EDS.COM31_Wed, 16 Jul 2003 10:32:43 +010010_-

2076 41 33_a bit off topic - abend S978 RC0416_Aurora Dell'Anno28_Aurora.DellAnno@UK.QUEST.COM31_Wed, 16 Jul 2003 11:44:06 +0100359_iso-8859-1 Hello list,

does anybody know if an old MVS problem has re-occurred in z/OS 1.3 or are we (me and my client) the only ones suffering?

This abend, System 978 RC04 IEA7051 ERROR DURING FREEMAIN, is a very old apar, I found them on IBMlink dated 1998 but we have been getting them as recently as yesterday! on z/OS with DB2 V7.1... [...] 2118 145 40_Betr.: a bit off topic - abend S978 RC0411_Roy Verweij28_R_Verweij@BELASTINGDIENST.NL31_Wed, 16 Jul 2003 13:21:33 +0200348_iso-8859-1 Are you sure your DATA or DATAPOINTER values of your FREEMAIN statements are correct? If they are not correct it seems to me that this will make a program to try and free memory that is either not there or what was expected.

If this is not the problem there's nothing I can tell you more. We're still running in OS/390 mode. [...] 2264 127 37_Re: a bit off topic - abend S978 RC0416_Aurora Dell'Anno28_Aurora.DellAnno@UK.QUEST.COM31_Wed, 16 Jul 2003 13:04:25 +0100441_iso-8859-1 Hi Bob,

I am getting it with a batch job as it happens, which runs within DB2. My this is more of a question for IBM-Main mailing list I guess, but since the customer is experiencing with a batch job relating to DB2...

ciao!

Aurora Emanuela Dell'Anno Systems Engineer Quest Software

Office: +44 (0)1628 606660 Mobile: +44 (0)7881 818867 Fax: +44 (0)1628 606606 email: aurora.dellanno@uk.quest.com [...] 2392 17 8_question12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Wed, 16 Jul 2003 08:15:27 -0400444_us-ascii Does anyone know of any guidelines generated by IBM on what should the responsibilities of a DB2 DBA be!!!!!!!!!!!!!!!!!!!

Stan Goodwin DSN: 430-4335 Outside:- 717-605-4335

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 2410 51 12_Re: question19_Fitzgibbons, Ann E.23_Ann.Fitzgibbons@UBS.COM31_Wed, 16 Jul 2003 08:25:13 -0400315_iso-8859-1 please do share when you get the answer to this question.

I'd like to add some depth to the question:

how does your shop handle compensation for 24x7 support? are you compensated for working in the middle of the night / on the weekend or is it just considered to be "part of the job"? [...] 2462 36 12_AW: question12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 16 Jul 2003 14:45:40 +0200489_iso-8859-1 Ann,

true, but not good: Working in the middle of the night and/or on the weekend sometimes is just a part of the DBA job in our company....

With kind regards - mit freundlichen Gruessen, Georg H. Peter ---------------------------------------------------------------------- -----Ursprüngliche Nachricht----- Von: Fitzgibbons, Ann E. [mailto:Ann.Fitzgibbons@UBS.COM] Gesendet: Mittwoch, 16. Juli 2003 14:25 An: DB2-L@LISTSERV.YLASSOC.COM Betreff: Re: question [...] 2499 28 12_Re: question9_Art Gates15_GatesA@DCAD.ORG31_Wed, 16 Jul 2003 07:33:56 -0500239_us-ascii Being a fairly new DB2 shop here (2 yrs), we'd be interested in the answer also. A lot of questions about that here. Also, as far as 24x7 support. As a salaried employees in our area, it is considered 'part of the job' - BUT we do 2528 37 12_Re: question8_Ken Kane15_kkane@UBSPW.COM31_Wed, 16 Jul 2003 08:48:54 -0400507_iso-8859-1 That response would be too voluminous a for this listserv, you should rephrase the question to read ,

"what should the responsibilities of a DB2 DBA NOT be "



-----Original Message----- From: Stan Goodwin [mailto:STANLEY_GOODWIN@MECH.DISA.MIL] Sent: Wednesday, July 16, 2003 8:15 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: question



Does anyone know of any guidelines generated by IBM on what should the responsibilities of a DB2 DBA be!!!!!!!!!!!!!!!!!!! [...] 2566 87 12_Re: question16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 16 Jul 2003 08:57:02 -0400419_iso-8859-1 Here contractors bill for the calls (but not for being on call) Employees get older and wiser. The wiser they get, the more likely they are to retreive some of the lost time via an unofficial 'comp time' process.

There is a financial shop about 30 miles up the road which gives the oncall person a 'beeper differential'. I do not know the percent. I have heard that in NYC, 10% is fairly common. [...] 2654 55 12_Re: question12_McKown, John22_JMckown@UICIINSCTR.COM31_Wed, 16 Jul 2003 07:58:17 -0500506_- I can't say for DBA, but for our Tech Support and programmers, any work done over 40 hours/week is "free to the company". Even if it is mandantory overtime, it is not paid for. Having said that, the IT managers here generally keep track of this "overtime" and allow "discretionary time off" with pay if somebody is being overworked. But it is not a company policy. In the U.S., such workers are classified as "exempt" by the U.S. Department of Labor and so companies are not forced to pay overtime. [...] 2710 32 12_Re: question10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 16 Jul 2003 15:01:29 +0200628_us-ascii Troubles with the boss ? Identity crisis ?

I read something by IBM some years ago but I don't remember where......I'll try to find it.

Anyway there are some Web resources as Craig Mullin's dbazine (see 'What is a DBA ?'), or:

http://www.mainframeforum.com/t603369.html

http://www.db2mag.com/db_area/archives/2000/q3/idug.shtml

or search 'DBA duties' with Google or similar.

HTH

Max Scarpa

PS AFAIK DBA duties are not a constant in the universe: here according my boss DBA should clean windows,switch of PCs at night and so on other than working with DB2.... [...] 2743 147 16_Re: AW: question13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 16 Jul 2003 09:32:18 -0400503_iso-8859-1 Here, too. Work when the job requires. OTOH, it looks from the want ads like we get pretty well paid for it by comparison with the rest of the industry.

If it gets too crazy, don't hide it when you feel burned out. If the wheel isn't squeaky, they won't know it needs grease. Wish I had better advice for you. If management isn't listening, there's not a lot you can do -- they're just as human as the rest of us, and people have an amazing ability to ignore inconvenient truths. [...] 2891 54 12_Re: question0_19_csutfin@AMSOUTH.COM31_Wed, 16 Jul 2003 08:36:09 -0500455_us-ascii Here the DBA does everything the programmers cannot and will not do.

And no beeper differential or overtime pay. Anything over 40 is free to the company.

Carol Sutfin Corporate DBA AmSouth Bank (205)261-5214 csutfin@amsouth.com







Stan Goodwin cc: Sent by: DB2 Data Subject: question Base Discussion List [...] 2946 47 12_Re: question15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Wed, 16 Jul 2003 09:37:37 -0400465_- I thought IBM classified someone as a DBA if they could decipher their default value for any question asked of them - "It Depends"!



-----Original Message----- From: Max Scarpa [mailto:mscarpa@CESVE.IT] Sent: Wednesday, July 16, 2003 9:01 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question

Troubles with the boss ? Identity crisis ?

I read something by IBM some years ago but I don't remember where......I'll try to find it. [...] 2994 148 12_Re: question13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 16 Jul 2003 09:47:14 -0400500_us-ascii Hey Max... * Instantly and painlessly resolve all security issues relating to the database * Keep all test data pristine, referentially correct, and fully backed up, no matter when (or by whom) it is generated * Have a tested disaster recovery plan which covers all scenarios, without a separate budget/staff * Read MVS dumps * Solve performance problems without the need to change SQL * Leap tall buildings in a single bound * Recover subsystems in two minutes without loss of data... [...] 3143 179 12_Re: question50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Wed, 16 Jul 2003 10:08:03 -0400709_iso-8859-1

1) MIND READER 2) SMOKE & MIRROR SPECIALIST

-----Original Message----- From: Phil Sevetson [mailto:Phil.Sevetson@WAKEFERN.COM] Sent: Wednesday, July 16, 2003 9:47 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question





Hey Max... * Instantly and painlessly resolve all security issues relating to the database * Keep all test data pristine, referentially correct, and fully backed up, no matter when (or by whom) it is generated * Have a tested disaster recovery plan which covers all scenarios, without a separate budget/staff * Read MVS dumps * Solve performance problems without the need to change SQL * Leap tall buildings in a single bound * Recover [...] 3323 22 12_Re: question9_Art Gates15_GatesA@DCAD.ORG31_Wed, 16 Jul 2003 09:12:01 -05009_us-ascii 3346 70 116_Re: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defin ing Workspace Tablespace as User Managed Dataset ?11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Wed, 16 Jul 2003 08:50:57 -0500372_iso-8859-1 Thanks David, Cliff the answer was helpful we have more space in our work area :-)

-----Original Message----- From: David S Waugh [mailto:dsw-dba@JUNO.COM] Sent: Tuesday, July 15, 2003 7:56 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset ? [...] 3417 210 12_Re: question8_Ken Kane15_kkane@UBSPW.COM31_Wed, 16 Jul 2003 10:29:18 -0400697_iso-8859-1 and perform all of these in 4 languages

-----Original Message----- From: Phil Sevetson [mailto:Phil.Sevetson@WAKEFERN.COM] Sent: Wednesday, July 16, 2003 9:47 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question





Hey Max... * Instantly and painlessly resolve all security issues relating to the database * Keep all test data pristine, referentially correct, and fully backed up, no matter when (or by whom) it is generated * Have a tested disaster recovery plan which covers all scenarios, without a separate budget/staff * Read MVS dumps * Solve performance problems without the need to change SQL * Leap tall buildings in a single bound * Recover [...] 3628 36 12_Re: question15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Wed, 16 Jul 2003 09:53:49 -0500506_iso-8859-1 DBAs must interpret error messages because the responsible party is too lazy to do that himself. (What's a manual?) Here in Wisconsin government, IT workers are unionized. We get compensation for overtime, but only 1-1. This compensation can be in time off or $$$. We also get paid for carrying our pagers when designated as on-call. This is only about $2.50 per hour outside of normal working hours but it can add up to a few hundred dollars a month depending on how much you are on call. [...] 3665 24 12_Re: question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Wed, 16 Jul 2003 07:57:42 -0700571_ISO-8859-1 A good book is Database Administration - The complete guide to Practices and Procedures by Craig S Mullins - it has been very helpful to me as a newbie DBA.

Kathy Jones Central Information Services Clark County School District O/S390 DB2 DBA NT DB2 DBA 702-799-5040 x366 ksjones2@interact.ccsd.net

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 3690 66 22_Re: Data Propagator V821_Claypool, Alisa@HHSDC21_AClaypoo@HHSDC.CA.GOV31_Wed, 16 Jul 2003 08:28:37 -0700328_- I contacted IBM support rep and she confirmed it ends 11/30/03. She sent me the withdrawal announcement (903-027) dated 2/4/03. It is also shown on their website at URL http://www-3.ibm.com/software/data/dpropr/eos.html. I want it to be wrong but that isn't what IBM told me. I don't know how to get a definitive answer. [...] 3757 28 12_Re: question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Wed, 16 Jul 2003 08:28:18 -0700582_ISO-8859-1 DB2 Data Base Discussion List writes: >Here in Wisconsin government, IT workers are unionized. We get >compensation >for overtime, but only 1-1. This compensation can be in time off or $$$. >We >also get paid for carrying our pagers when designated as on-call. This is >only about $2.50 per hour outside of normal working hours but it can add >up >to a few hundred dollars a month depending on how much you are on call. Here in NV, we are unionized too and we get time and a half for overtime - guess I should quit complaining about the [...] 3786 23 28_cics transaction with insert10_Yang Chuan24_yang_chuan@HISUNTECH.COM31_Wed, 16 Jul 2003 10:50:52 -0500441_- Hey. We just have a test compare insert 36 short records with insert 1 large record which have 36 times of the short records in a transaction. By tmon/db2,we found that the db2 elapse time is not much difference,but the application time of insert 36 records is much longer than the other one. By tmon/cics, the elapse time of insert 36 records is 3 times than insert only one large records. The main differnce is the TCB SWITCH time. [...] 3810 63 12_Re: question15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Wed, 16 Jul 2003 11:05:48 -0500332_iso-8859-1 "We also get 3 hrs callback if we are called after hours regardless of how short of a time we spend - so 15 minute fix - 3 hrs pay! "

If we have to drive in to fix something then we get an automatic 2 hours pay. This is only an advantage if you don't live far away. If we can dial in then this doesn't apply. [...] 3874 20 12_Re: question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Wed, 16 Jul 2003 08:59:33 -0700477_ISO-8859-1 I wanted to add to my comments - you may think 3 hr callback and time and a half is great BUT remember I work for the school district and my base salary is probably about 1/2 of yours. To get a good retirement plan and a job for the next 15 yrs - I took a big cut in pay but I also got training as a DBA when I was a programmer/analyst in my former life. So you can envy my overtime pay but remember it still doesn't pay me as much as you in the private sector [...] 3895 44 12_Re: question15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Wed, 16 Jul 2003 11:26:47 -0500399_iso-8859-1 Ooops! I stand corrected. A coworker who subscribes to the list says that if I dial in for at least 1/2 hour then I get an automatic two hours pay. Looks like I am owed some time....

Linda

-----Original Message----- From: Kathleen S. Jones [mailto:ksjones2@INTERACT.CCSD.NET] Sent: Wednesday, July 16, 2003 10:28 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question [...] 3940 140 11_Re: DSNREXX13_Merritt, Hank16_HMerritt@GHI.COM31_Wed, 16 Jul 2003 12:34:08 -0400482_iso-8859-1 I had a similar problem with a homegrown utility. It worked on our single subsystem "sandbox" LPAR and failed when I tried to move it to a three subsystem development LPAR. I tried to compile it into a shared library with a shared dbrm and bind it in each subsystem. The -3 I was getting seemed to be from a timestamp mismatch because it was solved when I compiled into separate loadlibs/dbrms and then did the binds. I still don't know why the sharing didn't work. [...] 4081 103 12_Re: question13_Merritt, Hank16_HMerritt@GHI.COM31_Wed, 16 Jul 2003 12:37:16 -0400611_iso-8859-1 With my company outsourcing the mainframe in November, I may find myself envying you even if you worked for minimum wage. :<

-----Original Message----- From: Kathleen S. Jones [mailto:ksjones2@INTERACT.CCSD.NET] Sent: Wednesday, July 16, 2003 12:00 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] question



I wanted to add to my comments - you may think 3 hr callback and time and a half is great BUT remember I work for the school district and my base salary is probably about 1/2 of yours. To get a good retirement plan and a job for the next 15 yrs - I took a big [...] 4185 138 37_Re: a bit off topic - abend S978 RC0413_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 16 Jul 2003 09:45:30 -0500382_- What kind of job are you running. Program name, etc? What are the complete error messages in the LOG? Any SYSOUT with additional error messages, DB2 return codes?

-----Original Message----- From: Aurora Dell'Anno [mailto:Aurora.DellAnno@UK.QUEST.COM] Sent: Wednesday, July 16, 2003 7:04 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: a bit off topic - abend S978 RC04 [...] 4324 135 32_Re: cics transaction with insert11_David Nance16_DWNance@FHSC.COM31_Wed, 16 Jul 2003 12:57:05 -0400566_US-ASCII Keep in mind 36 separate insert statements is a bit more work than one insert of the same size. You have all the logging for the individual statements, you have different datasets that need to be accessed, plus a lot more instructions in your program, imagine how many more that works out to within DB2. There was a slide show in the document archives for this list back in August 2000, that contains a lot of useful information on high insert usage and the impacts that changes to the structures and to the application programs had on the elapsed and [...] 4460 65 12_Re: question12_Rohn Solecki19_rohnski@HOTMAIL.COM31_Wed, 16 Jul 2003 11:42:11 -0500427_iso-8859-1 In the company I used to work for, DBA was unionized (too bad the contract didn't provide any job security ;-) ) so we had beeper pay ("standby"). Originally it was $20/day on call, then recently changed to 2 hours pay/day on call (MUCH better!). In theory, any time we were called was considered overtime (at double time), but in practice most people didn't actually bill for all of the call time they worked. [...] 4526 62 32_Re: cics transaction with insert13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 16 Jul 2003 12:00:46 -0500592_iso-8859-1 When you execute an SQL statement from CICS, control is passed over to the DB2 TCB and then switched back again after the SQL is completed. This would be the reason you are seeing extended time in "TCB SWITCH". There can be some relief for this by defining the transaction as THREADSAFE, which can avoid some of the TCB switching. Note there there are some gotchas involved, so tread carefully (Dave Raiman from IBM has given a couple presentations in the past that include more information on this). Aside from THREADSAFE, you could also alleviate the tcb switching by using [...] 4589 100 41_C Stored Procedure Problem on AIX - HELP!15_Jackson Reavill18_damcon2@US.IBM.COM31_Wed, 16 Jul 2003 13:07:02 -0400568_US-ASCII Reposting in hopes of a response...

Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 356-5317, Tie Line 8-697-5317

----------------------------------------------------- Happiness is not around the corner. Happiness is the Contour (SVT) of the road. ----------------------------------------------------- The early bird gets the worm, but the second mouse gets the cheese. -----------------------------------------------------

----- Forwarded by Jackson Reavill/Tampa/Contr/IBM on 07/16/2003 12:55 PM ----- [...] 4690 47 15_Re: SEARCH -87910_Bob Riehle23_Bob.Riehle@AIRBORNE.COM31_Wed, 16 Jul 2003 11:11:23 -0700369_iso-8859-1 we are trying to change a vargraphic to a varchar for bit data field. Is there anything magical I need to do to accomplish this, or can I just unload and load? Thanks, Bob

-----Original Message----- From: Patric Becker [mailto:Patric_Becker@SIS-WEST.DE] Sent: Friday, July 11, 2003 1:16 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: SEARCH -879 [...] 4738 46 20_Re: DB2 REXX Connect13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Wed, 16 Jul 2003 13:20:44 -0500482_iso-8859-1 Could you send me a sample of your code beginning with address tso 'SUBCOM DSNREXX' ?

Make sure that you have only REXX commands and DSNREXX commands (example: EXECSQL...) following the ADDRESS DSNREXX statement until you delete DSNREXX and use another ADDRESS command.

Johnny.

-----Original Message----- From: db2_dba [mailto:db2_dba@BELLSOUTH.NET] Sent: Tuesday, July 15, 2003 12:25 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 REXX Connect [...] 4785 27 12_Re: question9_Art Gates15_GatesA@DCAD.ORG31_Wed, 16 Jul 2003 16:09:39 -0500241_us-ascii Kathleen, I work for a 'quasi- government' company and I also don't make as much as the private sector and, although I don't get OT, we do have an outstanding retirement plan. I also was a programmer analyst in my former life and am 4813 52 12_Re: question0_26_truman.g.brown@VERIZON.COM31_Wed, 16 Jul 2003 17:30:57 -0400450_iso-8859-1 I would rather have the money up front and plan my own retirement, especially in light of the fact that many companies are now cutting back on or eliminating retirment plans that retirees thought were cast in bronze.

George









"Art Gates" @LISTSERV.YLASSOC.COM> on 07/16/2003 05:09:39 PM

Please respond to "DB2 Data Base Discussion List" [...] 4866 24 12_Re: question17_Kathleen S. Jones26_ksjones2@INTERACT.CCSD.NET31_Wed, 16 Jul 2003 14:35:26 -0700544_ISO-8859-1 DB2 Data Base Discussion List writes: >Kathleen, I work for a 'quasi- government' company and I also don't make >as much as the private sector and, although I don't get OT, we do have an >outstanding retirement plan. I also was a programmer analyst in my >former life and am >getting DB2 training / experience here. So it's what makes you happy ! yep, said I would never work for a government agency but you should never say never - most days I love my work and learning to be a DBA is challenging! [...] 4891 32 12_Re: question14_Allen, Susan A24_susan.a.allen@BOEING.COM31_Wed, 16 Jul 2003 15:02:39 -0700421_iso-8859-1 it is considered flex time and reduces a regular shift in the 2 week pay period

-- Susan

-----Original Message----- From: Fitzgibbons, Ann E. [mailto:Ann.Fitzgibbons@UBS.COM] Sent: Wednesday, July 16, 2003 5:25 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question



please do share when you get the answer to this question.

I'd like to add some depth to the question: [...] 4924 15 45_Re: C Stored Procedure Problem on AIX - HELP!0_18_IWANT2BEME@AOL.COM31_Wed, 16 Jul 2003 19:40:03 -0400329_iso-8859-1 Have you checked your security? Just a thought.

Jacquie

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 4940 42 12_Re: question16_Lance D. Jackson30_LJackson@PANDRUEASSOCIATES.COM31_Wed, 16 Jul 2003 20:53:33 -0400441_us-ascii Stan,

I have a document that may be of some assistance. If you give me your e-mail address, I will attach it on a note.

Lance J. Pandrue Associates, Inc. www.PandrueAssociates.com 215.295.5561

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Stan Goodwin Sent: Wednesday, July 16, 2003 8:15 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: question [...] 4983 18 12_Re: question12_Cianci, Nick19_nick.cianci@EDS.COM31_Thu, 17 Jul 2003 11:34:23 +1000403_- .. and my .06 Euro's worth

Read Dilbert, substitute the words Engineer for DBA, and you probably come close.

Cheers, Nick F. Cianci

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 5002 21 0_18_Sivaraman, Anand S23_anand.sivaraman@EDS.COM31_Thu, 17 Jul 2003 00:38:03 -0500364_- Hi Lister, Db2 programs in the mainframe environment are normally executed through the utility IKJEFT01. Is it possible to execute Db2 programs without using any utilities ie can a db2 program be executed directly (EXEC PGM=db2pgm name) without these utilities.

Any help on this regard would be greatly appreciated.

Thanks & Regards S.S.Anand [...] 5024 36 0_14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Thu, 17 Jul 2003 08:47:29 +0200292_- Yes. You need to build a CAF connection with a special call to DSNALI, IIRC. THIS is the normal way to execute a batch db2 program.

You will have to read the manuals, I guess, because at our site we call a routine which does the CAF connect for us, so I don't know the details. [...] 5061 34 0_15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Thu, 17 Jul 2003 10:16:45 +0300373_us-ascii On Thu, 17 Jul 2003 00:38:03 -0500 "Sivaraman, Anand S" wrote:

:> Db2 programs in the mainframe environment are normally executed through the :>utility IKJEFT01. :> Is it possible to execute Db2 programs without using any utilities ie can a :>db2 program be executed directly (EXEC PGM=db2pgm name) without these :>utilities. [...] 5096 30 0_16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 17 Jul 2003 09:18:00 +0200415_iso-8859-1 In these days I would look at RRSAF (DSNRLI) instead of CAF (DSNALI)

Roland

-----Original Message----- From: Bernd Oppolzer [mailto:Bernd.Oppolzer@T-ONLINE.DE] Sent: Thursday, July 17, 2003 8:47 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject:



Yes. You need to build a CAF connection with a special call to DSNALI, IIRC. THIS is the normal way to execute a batch db2 program. [...] 5127 24 26_IDUG Solution Journal link10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 17 Jul 2003 09:50:37 +0200352_us-ascii Estimeed Listers

I had a look to IDUG web site and I saw (since a lot of time) that the last issue of Solution Journal dates to October 2002, but I'm pretty sure that there are more recent issues.

Does anyone know if recent Solution Journal issues are still available online ? If yes could you please provide the web link ? [...] 5152 10 12_Re: question9_Nguyen DT13_ndt98@FREE.FR31_Thu, 17 Jul 2003 03:02:57 -0500328_- we are paid for every hour worked out of the office hour - (France :-)

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 5163 52 0_0_20_Gerhard.Heiss@RUV.DE31_Thu, 17 Jul 2003 11:48:58 +0200340_- Don't know assets and drawbacks of RRSAF vs CAF in a pure mainframe environment, but TSO terminal monitor programm IKJFT01 is probably not the best choice. There are third-party-products (like ARC from BMC) which take care of attachment and easily let you handle commit-frequency, repositioning of datasets and restore of variables. [...] 5216 53 30_Re: IDUG Solution Journal link6_ScotDB18_teamdba@SCOTDB.COM31_Thu, 17 Jul 2003 11:58:03 +0100421_- Max,

If you get an answer to your question then I (as one of the ISJ Editorial Board) would like to know the answer. I've asked the same question myself and not got a response.

I guess that there is a case for keeping recent articles back from the website for a few months, to encourage IDUG membership (through conference attendance or other fee-based activity). Membership gets you a printed copy. [...] 5270 58 37_problems db2 v7 migration and unicode14_Craig McKellar26_craig.mckellar@BIGPOND.COM31_Thu, 17 Jul 2003 20:53:23 +1000594_iso-8859-1 Has anyone had problems with client applications post migration db2 v7 os390 by not having unicode installed on os390?



We have just migrated a client from db2 V6 os/390 to V7 and are experiencing some data translation problems. We suspect that the problem may be related to unicode enablement or lack off. We do not have unicode enable on OS/390 yet. The client applications generally use JDBC. I have seen the info apars relating to unicode enablement for stored procedure builder and it seems to indicate there could be more problems than just the SPB. II13277 [...] 5329 24 30_Re: IDUG Solution Journal link10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 17 Jul 2003 13:21:09 +0200272_us-ascii Hi

Thank for your response. What I'd like to know if ISJ is still free or not. I got the paper on V8 but I never saw most recent

issues so I was wondering if you've to pay to see them (but I think there should be a warning or something similar [...] 5354 199 20_Re: DB2 REXX Connect17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR31_Thu, 17 Jul 2003 08:35:14 -0300619_iso-8859-1 Johnny,

This is a piece of code to connect to a subsystem and location. SQLCA handling code is not mine, I got it from a post in this list.

/* rexx */ arg subsys location ... abort=1 ... if ¬ INIT_DSNREXX() then EXIT 99 ... INIT_DSNREXX: msgtext='Conecting to subsystem 'sysid rc= SAY_MSG(1) ; rc = rxsubcom('ADD','DSNREXX','DSNREXX') if rc<>0 then RETURN 0 ; sqlstmt=" CONNECT "sysid address "DSNREXX" sqlstmt if rc<>0 then , do msgtext ='Error connecting to subsystem 'sysid rc=SAY_MSG(1) RETURN 0 end if sqlcode <> 0 then if ¬ SQLCA() then RETURN 0 ; sql=" EXECSQL CONNECT TO "location [...] 5554 68 41_Re: problems db2 v7 migration and unicode17_Walter Trovijo Jr18_wtrovijo@IG.COM.BR31_Thu, 17 Jul 2003 08:41:19 -0300405_iso-8859-1 Yes, I did.

I´ve solved it using DISABLEUNICODE=1 on db2cli.ini, but I don´t know if it will solve your problems. If I understood what you said, your apps do work but you have some data translation problems. In my case apps just stopped to work.

Walter.

|Has anyone had problems with client applications post migration db2 v7 os390 by not having unicode installed on os390? 5623 35 30_Re: IDUG Solution Journal link6_Daniel15_bufes@YAHOO.COM31_Thu, 17 Jul 2003 06:41:27 -0500587_- On Thu, 17 Jul 2003 11:58:03 +0100, ScotDB wrote:

>Max, > >If you get an answer to your question then I (as one of the ISJ >Editorial Board) would like to know the answer. I've asked the same >question myself and not got a response. > >I guess that there is a case for keeping recent articles back from the >website for a few months, to encourage IDUG membership (through >conference attendance or other fee-based activity). Membership gets you >a printed copy. > >However the web links have been erratic to say the least !!! The recent >article which [...] 5659 44 0_16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jul 2003 08:25:27 -0400434_iso-8859-1 What you want is called CAF (Call Attach Facility). Most of our batch jobs use this. It is a simple and well-documented interface which requires no software other than the DB2 product itself.

Regards, Eric Pearson NS ITO DB2 support



-----Original Message----- From: Sivaraman, Anand S [mailto:anand.sivaraman@EDS.COM] Sent: Thursday, July 17, 2003 1:38 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: [...] 5704 59 26_Question on DISABLEUNICODE17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Thu, 17 Jul 2003 22:43:26 +1000398_iso-8859-1 Hi, I am wandering where we should set this parameter.

Our environment includes Websphere running on AIX & DB2 EE v7 fp 6 connecting to DB2 OS390 v7 (recently upgraded).

We do not have unicode enabled in OS390 and therefore want to disable it via the above parm.

My question is where do we set this parm, my guess is on the AIX server where the DB2 EE resides. [...] 5764 76 0_16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 17 Jul 2003 08:49:10 -0400748_iso-8859-1 Gerhard,

Biggest advantage of RRSAF vs CAF is that RRSAF allows you to coordinate COMMIT processing of DB2 and other (e.g. VSAM) recoverable resources.

Regards, Eric Pearson NS ITO DB2 support



-----Original Message----- From: Gerhard.Heiss@RUV.DE [mailto:Gerhard.Heiss@RUV.DE] Sent: Thursday, July 17, 2003 5:49 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject:



Don't know assets and drawbacks of RRSAF vs CAF in a pure mainframe environment, but TSO terminal monitor programm IKJFT01 is probably not the best choice. There are third-party-products (like ARC from BMC) which take care of attachment and easily let you handle commit-frequency, repositioning of datasets and restore of variables. [...] 5841 38 29_InDUG Conference Registration11_Carl Nelson22_Carl.Nelson@ANTHEM.COM31_Thu, 17 Jul 2003 08:23:18 -0500391_us-ascii Reminder!! Please register for next week's InDUG conference to be held July 22nd Tuesday @ Farm Bureau. As of today, we have only 1 RSVP. We need to know how many to plan for.

Please RSVP to Margie Barrick with name, company, phone number, & email by email to: Margie.Barrick@infarmbureau.com



(See attached file: InDUG 2003 Summer Conference Program.pdf) [...] 5880 63 41_Re: problems db2 v7 migration and unicode10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 17 Jul 2003 09:20:01 -0400379_us-ascii Craig

We are in the middle of this right know.... The ONLY way to fix the issue is to 1) install fixpack 9 or 2) set 'disableunicode' on ALL the clients.

search for 'disableunicode' on ibm.com .... you will find a tech note indicated the issue

This is a major bug

PS .. you will also need to enable 'unicode systems services' on 0S/390. [...] 5944 55 30_Re: Question on DISABLEUNICODE10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 17 Jul 2003 09:24:43 -0400441_us-ascii Rich

I believe it is in the 'release notes' and it will be set on all clients. In my case we had 3000 clients...so it was easier to enable the 'unicode system services' on os/390 (not that difficult)

Tom





Richard Cotterill cc: Sent by: DB2 Data Subject: Question on DISABLEUNICODE Base Discussion List [...] 6000 47 30_Re: question - off topic sorry15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Thu, 17 Jul 2003 08:39:15 -0500446_iso-8859-1 I have heard that France has some very strict work rules. One of which is that the work week cannot be longer than 35 hours. It is the law. Must be nice.

Linda Billings Database Administrator (New guv, new reorg, same ol', same ol') State of Wisconsin Department of Administration Division of Enterprise Technology Bureau of Development and Operations phone - 608-264-6396 fax - 608-261-0618 linda.billings@deg.state.wi.us [...] 6048 224 20_Re: DB2 REXX Connect13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Thu, 17 Jul 2003 08:41:15 -0500305_iso-8859-1 Walter, the code looks fine, but display your sqlcode before you exit(return) the INIT_DSNREXX: routine. If you get a -3 RC the program exits before displaying the sqlcode unless it is performed within the other piece of code I can not see. The sqlcode may help you determine the problem. [...] 6273 46 69_DB2 REXX dsntiar routine syntax error position (was DB2 REXX Connect)14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 17 Jul 2003 23:47:00 +1000600_ISO-8859-1 not quite on the topic of the original question, but since Walter posted the code ... I have discovered that I hadn't tested every permutation of position of a syntax error in this snippet:

> i_syn_pos = sqlerrd.5 - i_text_pos + 1 > select > when i_syn_pos = 1 then > syn_err_message = '|<- There´s a syntax error here *****' > when i_syn_pos < 5 then > syn_err_message = copies('*',i_syn_pos-1)||, > '|<- There´s a syntax error here *****' > when i_syn_pos < 34 then > syn_err_message = '****'copies(' ',i_syn_pos-5)||, > '|<- There´s a syntax error here *****' > otherwise > [...] 6320 74 48_IKJEFT01 vs RRSAF -- What's normal? What's best?12_Marcia Crisp16_MA-Crisp@WIU.EDU31_Thu, 17 Jul 2003 08:43:49 -0500329_iso-8859-1 We are a shop new to DB2, and a relatively small one compared to many of you. Our plan is to use IKJEFT01 for most batch programs, and to use RRSAF for subprograms (since they might be called by non-DB2 programs). I was surprised to see Bernd's comment that CAF "is the normal way to access a batch DB2 program." [...] 6395 29 39_Reorg Space of a multi-table tablespace12_Paul Packham26_paul.packham@ROYALMAIL.COM31_Thu, 17 Jul 2003 14:41:06 +0000546_us-ascii Hi,

For as long as I can remember we have relied on BMC's BMCSTATS calculation of reorg space for an index or tablespace. We plug this figure into an 'intelligent reorg' which we run at our site which helps it decide if a) to reorg, b) what alternation to priqty/secqty is required, c) whether the reorged object will fit within the stogroup etc. . Now that we are on v7 of DB2 we are wondering if we can make more use of Real Time Stats (RTS), and plug information from the RTS tables into our intelligent reorg. One of the [...] 6425 186 32_Number of weekdays betwen 2 date23_THOLKAPPIAN Chidambaram21_CTholkap@COVANSYS.COM31_Thu, 17 Jul 2003 19:32:22 +0530188_iso-8859-1 Hi,

Shall anybody, please let me know how to find the number of weekdays between 2 date columns, in query.

DB2 is V7.1 on Z/OS

Regards, Thol



6612 88 11_Compression4_DBAS14_DBAS@CWCOM.NET31_Thu, 17 Jul 2003 15:19:47 +0100451_iso-8859-1 In the IBM Utility Guide and Reference Manual DB2 V5 Page 2-181 I found the following comment. I'm afraid I do not understand it and was wondering if anyone could enlighten me.

"Compressed Data: Use caution when recovering a portion of a table space or partition, say one data set, to a prior point in time. If the data set being recovered has been compressed with a different dictionary, then you can no longer read the data." [...] 6701 18 0_13_Frank Rosewin19_rosewinfrank@UDB.NU31_Thu, 17 Jul 2003 10:39:06 -0400355_iso-8859-1 I'm not sure ARC from BMC allows your applications to connect to DB2 under RRSAF. Smart/RRSAF, the Call Attach Facility product from RAI supports both RRSAF and CAF. Smart/RESTART from the same vendor lets you handle commit-frequency, repositioning of datasets, DB2 cursors and restore of variables as well.

Regards, Frank Rosewin. [...] 6720 79 30_Re: Question on DISABLEUNICODE17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Fri, 18 Jul 2003 00:45:22 +1000417_iso-8859-1 Tom, Why the client as it is Websphere on the AIX server that is connecting to DB2. I suspect these clienst don't even need DB2 runtime on their machines. I am just not sure.

Richard ----- Original Message ----- From: "Tom Taylor" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, July 17, 2003 11:24 PM Subject: Re: Question on DISABLEUNICODE [...] 6800 91 31_Re: UNION vs UNION ALL question18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Thu, 17 Jul 2003 09:50:42 -0500624_- On Fri, 6 Jun 2003 14:24:22 -0500, Lakenburger, Sandra A [ITS] wrote:

>I have the following SQL statement that when run with a simple UNION, returns data >as expected. When the UNION is replaced with a UNION ALL, no rows are returned. >I've had a PMR open with IBM for a little over month now and don't really seem to be >getting anywhere as they can't recreate the problem. The SQL in question is: > > SELECT Y.TBNAME, Y.NAME, Y.UNIQUERULE, Y.COLCOUNT > FROM SYSIBM.SYSINDEXES Y > WHERE Y.TBCREATOR = 'SYSIBM' > AND Y.TBNAME IN ('SYSTABLESPACE', 'SYSTABLES') > AND EXISTS [...] 6892 19 36_Re: Number of weekdays betwen 2 date33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Thu, 17 Jul 2003 09:55:57 -0500415_- Thol

You can use the function DAYS

SELECT DAYS(CURRENT DATE + 3 DAYS) - DAYS(CURRENT DATE) FROM SYSIBM.SYSDUMMY1

gives you 3.

HTH

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 6912 44 100_Free Educational eSeminar =?ISO-8859-1?Q?=96?= Quest Software , Top 10 DB2 v8.1 ESE Performance Tips13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Thu, 17 Jul 2003 10:30:13 -0500427_ISO-8859-1 Wednesday, July 23, 2003, 10:00 AM Central Standard Time (CST) Presented by Scott Olson, Product Manager - DB2 Solutions

DB2 UDB Enterprise Edition and DB2 UDB Enterprise-Extended Edition have been merged with V8.1 into a single product: DB2 UDB Enterprise Server Edition(ESE) bringing the best of the two worlds on both SMP and MPP environment. Learn how to tune this new environment to your advantage. [...] 6957 63 36_Re: Number of weekdays betwen 2 date23_THOLKAPPIAN Chidambaram21_CTholkap@COVANSYS.COM31_Thu, 17 Jul 2003 22:27:32 +0530518_iso-8859-1 Thanks Walter

I was looking for something like

SELECT (WHOLE_WEEKS * 5) + CASE WHEN EXTRA_DAYS < 6 THEN EXTRA_DAYS - RND_WK WHEN EXTRA_DAYS = 6 THEN EXTRA_DAYS - 1 - RND_WK WHEN EXTRA_DAYS > 6 THEN EXTRA_DAYS - 2 - RND_WK END FROM ( SELECT (DAYS(CURRENT DATE + 13 DAYS) - DAYS(CURRENT DATE) ) / 7 AS WHOLE_WEEKS, MOD((DAYS(CURRENT DATE + 13 DAYS) - DAYS(CURRENT DATE)),7) + DAYOFWEEK_ISO(CURRENT DATE) AS EXTRA_DAYS , DAYOFWEEK_ISO(CURRENT DATE) AS RND_WK FROM SYSIBM.SYSDUMMY1 ) AS TEMP [...] 7021 62 37_Re: Number of weekdays between 2 date14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 17 Jul 2003 18:12:30 +0100427_iso-8859-1 Weekdays is (relatively) easy - working days might be different (do you need to take public holidays into account, for example?)

You might also consider a user defined function to take two dates as input and return the relevant number of days

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 7084 75 22_UDB DBA opportunity...18_peabody associates20_jkoval@OPTONLINE.NET31_Thu, 17 Jul 2003 14:18:51 -0700634_iso-8859-1 Hello, I was hoping somebody out there might know of someone in the industry who could benefit from this opportunity in NYC (or possibly in central NJ). Thank you for any help you can offer! Sr UDB/DB2 (UNIX/Mainframe) Database Administrator needed for full time career opportunity with major Investment Firm in New York City or possible in central NJ location. Base salary 100k to 120k. Requires strong UDB on UNIX and DB2 on Mainframe with some hands on Team Leadership experience in the Investment Industry. Need solid experience in relevant RDBMS technologies to research and execute the migration and maintenance [...] 7160 34 30_Re: question - off topic sorry15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Thu, 17 Jul 2003 14:18:32 -0400468_iso-8859-1 Why must it be Nice? Don't the people in Marseilles get the same benefits? ;)

-----Original Message----- From: Billings, Linda [mailto:Linda.Billings@DEG.STATE.WI.US] Sent: Thursday, July 17, 2003 9:39 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question - off topic sorry



I have heard that France has some very strict work rules. One of which is that the work week cannot be longer than 35 hours. It is the law. Must be nice. [...] 7195 32 27_SYSDBASE performance issues14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jul 2003 14:15:12 -0400579_iso-8859-1 We have two subsystems (TEST & PROD) used solely for Peoplesoft. The two systems are set up very similar to each other with the exception of a few ZPARMS that are different in TSGT to accommodate the many more objects that the subsystem contains.

The TEST subsystem is much larger that the PROD subsystem however I have noticed that it takes considerably more time to do a simple query against the PROD subsystem than the TEST subsystem. I have noticed this when doing a SPUFI as well as using our BMC tools to obtain basic object information. Each time a [...] 7228 33 31_Re: SYSDBASE performance issues9_Art Gates15_GatesA@DCAD.ORG31_Thu, 17 Jul 2003 13:26:02 -0500222_us-ascii Being a fairly new DB2 DBA I try to run index reorgs and runstats on our Prod system every weekend. I also try to keep the indexes in a different bufferpool than the tables.

Art Gates Database Administrator 7262 15 30_Re: question - off topic sorry0_26_truman.g.brown@VERIZON.COM31_Thu, 17 Jul 2003 14:44:04 -0400413_us-ascii Does the French 35 hour work week also apply to the French army during hostilities? That would explain why they always need our help during a war...

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 7278 37 41_DARI File for a C Stored Procedure on AIX15_Jackson Reavill18_damcon2@US.IBM.COM31_Thu, 17 Jul 2003 14:51:59 -0400403_US-ASCII Well, I figured out that when trying to execute a C stored procedure on AIX DB2 is looking for a DARI file in /u/db200001/sqllib/function/. Anyone know how to create one or what one is the correct one to specify for a new user created C SP or how to bypass it? There are a number of them out there such as db2xml which holds some type of information for a number of DB2 XML specific SP's. [...] 7316 157 31_Re: SYSDBASE performance issues13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Thu, 17 Jul 2003 14:59:17 -0400587_US-ASCII Dear M Rogers,

It isn't clear from your note what you mean by "do a simple query against the PROD subsystem ". Do you mean accessing Production Peoplesoft data? Or do you mean using Catalog Manager to look at object definitions?

For the latter, I heartily suggest that you visit the Options section of Catalog Manager and check out the Catalog Manager Switches section. We have the switch "_ NOT WILD " set to ON. This is because many Peoplesoft tables begin with PS_" , and CatMan considers the underscore character as a wildcard. This might be part of your [...] 7474 119 17_Re: Odd SQL error14_Virginia Davis26_Virginia.Davis@PREMERA.COM31_Thu, 17 Jul 2003 12:04:39 -0700568_iso-8859-1 I always thought the installation default for Date and Time was ISO. I don't understand why our installation module does not reflect that and I couldn't get a clear answer from my SysProg. Our customized DSNHDECP module definitely specifies USA. This is the second shop I've worked in where that was the case (not under my control) and it can be painful. In one company the SysProgs reset it during every upgrade. New developers and DBAs not expecting it get nailed at least once. So specifying the format in the SQL at all times is an excellent idea. [...] 7594 17 31_Re: SYSDBASE performance issues0_26_truman.g.brown@VERIZON.COM31_Thu, 17 Jul 2003 15:07:18 -0400561_us-ascii A while back we had some PeopleSoft performance issues that were related to extremely heavy (and unnecessary) catalog table read activity. The offending queries were modified to remove the unnecessary SQL. I identified the problem but did not take part in the fix so can't give you any specifics.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 7612 25 47_DB2 CONNECT to DB2 mainframe (SQLLC200 package)0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 17 Jul 2003 16:04:37 -0400357_us-ascii All,

We have a JAVA application which uses DB2 connect to access mainframe DB2 V7. Every time the application executes we notice that package SQLLC200 is being executed and our display shows over 133,000 records being sorted. However, we are unsure what records are being sorted. This could also explain the initial slow response time. [...] 7638 169 31_Re: SYSDBASE performance issues14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Thu, 17 Jul 2003 16:10:21 -0400563_iso-8859-1 Thanks, I'll give your suggestions a try. It doesn't seem to be as much of a problem accessing peoplesoft data as it is looking at object definitions against the catalog tables whether it be in Catalog manager or SPUFI. Even a simple select against sysindexes in spufi takes much longer in PROD than it does in TEST and we probably have 6-7 times as many objects in TEST than we do in PROD. I didn't think to consider wildcarding to be a problem because when I run the same catalog manager search in TEST it returns the information fairly quickly [...] 7808 68 51_Re: DB2 CONNECT to DB2 mainframe (SQLLC200 package)10_Alice Frus16_FRUSA@BCBSIL.COM31_Thu, 17 Jul 2003 15:30:27 -0500726_us-ascii generically it is dynamic sql - we see it in PeopleSoft all the time.





Ed_Vetock@NAVYFED ERAL.ORG To: DB2-L@LISTSERV.YLASSOC.COM Sent by: "DB2 cc: Data Base Subject: DB2 CONNECT to DB2 mainframe (SQLLC200 package) Discussion List" 07/17/2003 03:04 PM Please respond to "DB2 Data Base Discussion List"







All,

We have a JAVA application which uses DB2 connect to access mainframe DB2 V7. Every time the application executes we notice that package SQLLC200 is being executed and our display shows over 133,000 records being sorted. However, we are unsure what records are being sorted. This could also explain the initial slow [...] 7877 15 115_Re: Do I need to stop the Database DSNDB07 (DB2 V7 /390) if defining Workspace Tablespace as User Managed Dataset ?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 16:19:03 -0500503_- We did not get the V7 books changed for this one, but I think we found the last scenario that included stop and start, and took them out. To see the change, check section 7.11.4 in the redbook SG24-6121 V7 Presentation Guide.

Roger Miller

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 7893 102 52_Re: IKJEFT01 vs RRSAF -- What's normal? What's best?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 16:55:18 -0500352_- In the beginning, there was only the DSN command, running under IKJEFT02, a.k.a. TSO TMP (plus the IMS and CICS attaches and utilities of course). A few functions still have only commands. We added the CAF option in V1R2, primarily thinking of applications that needed controls. Some vendors built on it. Some customers made CAF their standard. [...] 7996 95 52_Re: IKJEFT01 vs RRSAF -- What's normal? What's best?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 18 Jul 2003 08:13:02 +1000584_US-ASCII You can't use both in one execution unit. You have to use either/or. Once TSO-AF is active for the main program, you cannot (I believe) use RRSAF in a subprogram.

The reason that most people use TSO-AF for batch programs is that it requires no extra code, they've always done so and DSNHLI is an alias of only DSNELI (the TSO-AF module). Hence when they code "EXEC SQL SELECT ... END-EXEC", and this is translated into "CALL 'DSNHLI' USING ...", the default module linked into the execution program is DSNELI (or if they let it be dynamically loaded at execution [...] 8092 35 15_Re: Compression14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 18 Jul 2003 08:13:03 +1000335_US-ASCII I think you've overlooked the fact that there are RECOVER options (DSNUM and PAGE) that can be used to recover part of a tablespace/partition to a different time from the part that contains the compression directory. Hence the "potion of" in the warning.

James Campbell

On 17 Jul 2003 at 15:19, DBAS wrote: [...] 8128 16 41_Re: problems db2 v7 migration and unicode12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 17:07:39 -0500564_- Java runs in Unicode. Getting the Unicode services installed is important, especially in V7. The Info APARs II13048 and II13049 describe the process. I'd also suggest the Unicode presentation on the web, ftp://ftp.software.ibm.com/software/db2storedprocedure/db2zos390/techdocs/d0 5.pdf

Roger Miller

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 8145 22 56_Re: DB2 precompile phase in z/OS C/C++ compiler (DB2 V7)12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 17:15:36 -0500310_- Do you have the V7 APAR PQ52412 applied? Are running the z/OS R2 C compiler? For C++, you need the z/OS V1R5 compiler and DB2 UDB for z/OS Version 8.

There is more information in the updated V7 Application Programming and SQL Guide, chapter 20. You need the one on the web. Here is one paste ... [...] 8168 29 22_Re: Migrating V6 to V712_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 17:20:16 -0500596_- Where a plan or package is dependent upon a table that is changed, the plan is invalidated. Part of the migration process is selecting these plans and packages and rebinding them.

Roger Miller

On Fri, 11 Jul 2003 08:34:07 -0400, Doanh Nguyen wrote:

>Hi everyone, > >We are migrating from V6 to V7 in a few weeks. I notice there are 19 >catalog tables that will be changed. >Will the migration process identify all affected plan/packages that need >to be rebound? > >Thanks, >Doanh Nguyen >Federal Reserve Information System >(804) 697-7822 [...] 8198 23 34_Lots more presentations on the web12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 17:31:08 -0500410_- Even more presentations were added to the DB2 UDB for z/OS web site recently. In addition to the nine I noted last week, there are 17 more. If you want to get the DB2 UDB for z/OS developer presentations from IDUG, then

Start at the main DB2 UDB for z/OS web site ibm.com/software/db2zos Click on Support Click on Technical Presentations Sort results by Date - newest first and check the top 25. [...] 8222 43 0_12_Peery, Jerry19_Jerry_Peery@BMC.COM31_Thu, 17 Jul 2003 17:55:54 -0500709_iso-8859-1 BMC's Application Restart Control (AR/CTL) product replaces any other method, including program IKJEFT01, that you may be using to perform a batch attach of the application program. For DB2 batch application programs using AR/CTL, any other product performing attachments to DB2 on behalf of the DB2 application program must be removed from the STEPLIB, JOBLIB, and LNKLST concatenation. AR/CTL handles the connection to DB2 on behalf of the application program, replacing the DB2 call attach facility (CAF). However, AR/CTL supports existing CAF programs without program changes. It will handle are the functions of checkpoint/restart, commit-frequency, repositioning of datasets, DB2 Cursor [...] 8266 78 31_Re: SYSDBASE performance issues10_Alice Frus16_FRUSA@BCBSIL.COM31_Thu, 17 Jul 2003 13:57:47 -0500466_us-ascii We have a similar setup and regular reorgs on the catalog - and more importantly runstats - makes a big difference. If you have a time constraint do the runstats first.





"Melissa Rogers" cc: Sent by: "DB2 Subject: SYSDBASE performance issues Data Base Discussion List" 07/17/2003 01:15 PM Please respond to "DB2 Data Base Discussion List" [...] 8345 14 18_Re: zparm question12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Jul 2003 17:51:07 -0500490_- Try APARs PQ50462 and PQ65335. If the situations look similar to yours, then turning on the switches can make an improvement. It would be possible to see performance regression too, so let's be careful out there.

Roger Miller

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 8360 46 30_Re: Question on DISABLEUNICODE12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 17 Jul 2003 18:06:17 -0700342_us-ascii That's where you set it. The AIX server where Db2 EE resides. You don't have to enable UNICODE on the OS/390 side unless you want to actually run JAVA on the mainframe or take advantage of the UNICODE OS/390 features.

As long as your DB2 EE DB2CLI.INI file has DISABLEUNICODE=1 in it, you won't have the UNICODE problem. [...] 8407 160 21_Fw: Re: Odd SQL error13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 18 Jul 2003 03:51:19 GMT330_- Well, it looks like I was wrong about point # 2 "I would think you would get inconsistent results depending on whether you have SDSNEXIT in the LOADLIB/STEPLIB concatenation or not." (OK -- I'm feeling distinctly damp again...). A friend of mine who has access to a V7 sandbox DB2 ran some tests, and here are his results: [...] 8568 54 37_Re: a bit off topic - abend S978 RC0413_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 18 Jul 2003 03:56:57 GMT523_- Aurora:

Check the archive of DB2-L and IBM-MAIN. I'm almost sure I remember someone reporting the same problem a month or two ago. But (mind like a steel sieve) I can't remember where I saw it...

David Waugh, NCW DSW Consulting & Services Former DB2 Sysprog, now clueless DB2 UDB Win/NT DBA =================================================== Supplemental Commandments for the Nineties =================================================== Thou shalt not shoot tourists just because it's tourist season. [...] 8623 98 31_Re: SYSDBASE performance issues17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Thu, 17 Jul 2003 22:41:27 -0500582_- On Thu, 17 Jul 2003 16:10:21 -0400, Melissa Rogers wrote:

>Thanks, I'll give your suggestions a try. It doesn't seem to be as much of >a problem accessing peoplesoft data as it is looking at object definitions >against the catalog tables whether it be in Catalog manager or SPUFI. Even >a simple select against sysindexes in spufi takes much longer in PROD than >it does in TEST and we probably have 6-7 times as many objects in TEST than >we do in PROD. I didn't think to consider wildcarding to be a problem >because when I run the same [...] 8722 59 31_Re: SYSDBASE performance issues13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 18 Jul 2003 04:16:01 GMT564_- Melissa: A couple of quick thoughts:

- Check to see if one subsystem has *user-defined* indexes on the catalog tables and the other doesn't. Somebody may have defined them on TEST because it was so big, but did not define them on PROD. - Make sure RUNSTATS has been run (recently) on both. - Check to see if DSNDB07 # of tablespaces (and sizes) are similar. - Check ZPARMS settings on both subsystems are equal (esp. EDM pool, SRT pool, RID pool, etc.). - Check ZPARMS to see if any "hidden" performance switches have been turned on in one subsystem [...] 8782 49 17_Re: Odd SQL error13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 18 Jul 2003 04:34:02 GMT532_- Ginny:

The installation default, if you do not specify otherwise, *is* ISO. You specify it on the Application Programming Defaults panel DSNTIP4, and it gets assembled into DSNHDECP in SDSNEXIT.



DSNTIP4 INSTALL DB2 - APPLICATION PROGRAMMING DEFAULTS PANEL 2 ===> _

Enter data below:

1 DATE FORMAT ===> ISO ISO, JIS, USA, EUR, LOCAL 2 TIME FORMAT ===> ISO ISO, JIS, USA, EUR, LOCAL 3 LOCAL DATE LENGTH ===> 0 10-254 or 0 for no exit 4 LOCAL TIME LENGTH ===> 0 8-254 or 0 for no exit [snip] [...] 8832 22 34_Messages and Codes, latest edition0_20_Gerhard.Heiss@RUV.DE31_Fri, 18 Jul 2003 09:02:49 +0200657_- collecting inline statistics during LOAD (STATISTICS INDEX(ALL) UPDATE ALL) I got: DSNU622I -DBT2 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR #QBDBA00.Q01X200 NOT SUCCESSFUL, REASON = 00E70114 Couldn't find this reason in "Third Edition, Softcopy Only (October 2002)" which was downloaded from http://publib.boulder.ibm.com/cgi-bin/bookmgr. Are there any later editions?

regards

gerhard

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 8855 148 31_Re: UNION vs UNION ALL question18_Bednarz, Michael P22_Michael.Bednarz@CA.COM31_Fri, 18 Jul 2003 08:27:48 +0100311_iso-8859-1 Hi Sandra, i run that query against a V7 DB2 not realy know witch maintenance level but in both cases I got the same result.

Regards

Michael Bednarz

CA Computer Associates GmbH FSG Consultant tel: +49 (0) 211 5306 295 fax: +49 (0) 211 5306 200 mobile: +49 (0) 170 85 38 576 [...] 9004 102 38_Re: Messages and Codes, latest edition19_Alekos Papadopoulos13_apapad@NBG.GR31_Fri, 18 Jul 2003 10:31:27 +0200423_ISO-8859-7 Hello Gerhard,

I don't know about newer editions of Messages and Codes. Your case however relates to PQ66513 (open APAR) - possibly that's why it does not appear in M&C book yet.

hth

Alekos -----Original Message----- From: Gerhard.Heiss@RUV.DE [mailto:Gerhard.Heiss@RUV.DE] Sent: Friday, July 18, 2003 10:03 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Messages and Codes, latest edition [...] 9107 74 38_Re: Messages and Codes, latest edition13_Michael Ebert18_mebert@AMADEUS.NET31_Fri, 18 Jul 2003 10:50:56 +0200324_us-ascii I always check messages and RCs on the internet - but 00E70114 isn't listed there either. Searching for it on the APAR DB gives one hit: PQ66513. Opened nearly one year ago, still no fix. This is yet another bug in a permanent stream of them for Inline Statistics. Use standalone RUNSTATS to prevent problems. [...] 9182 53 30_Re: question - off topic sorry15_Patrick Hignett33_Patrick.Hignett@MORGANSTANLEY.COM31_Fri, 18 Jul 2003 10:49:15 +0100595_us-ascii But they have 11% unemployment which is not so nice.

"Billings, Linda" wrote:

> I have heard that France has some very strict work rules. One of which is > that the work week cannot be longer than 35 hours. It is the law. Must be > nice. > > Linda Billings > Database Administrator (New guv, new reorg, same ol', same ol') > State of Wisconsin > Department of Administration > Division of Enterprise Technology > Bureau of Development and Operations > phone - 608-264-6396 > fax - 608-261-0618 > linda.billings@deg.state.wi.us > > "Not all chemicals are bad. Without [...] 9236 29 30_Re: question - off topic sorry28_=?iso-8859-1?q?SPUFI=20Doo?=20_spufidoo@YAHOO.CO.UK31_Fri, 18 Jul 2003 11:37:33 +0100425_iso-8859-1 At least they've got clean hands in this one.

-----Original Message----- From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] Sent: 17 July 2003 19:44 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question - off topic sorry



Does the French 35 hour work week also apply to the French army during hostilities? That would explain why they always need our help during a war... [...] 9266 59 30_Re: question - off topic sorry11_ANGOT HARRY18_harry.angot@CDN.FR31_Fri, 18 Jul 2003 14:47:59 +0200657_iso-8859-1 Neither they have to howl with Bush and Co....

> -----Message d'origine----- > De: SPUFI Doo [SMTP:spufidoo@YAHOO.CO.UK] > Date: vendredi 18 juillet 2003 12:38 > À: DB2-L@LISTSERV.YLASSOC.COM > Objet: Re: question - off topic sorry > > At least they've got clean hands in this one. > > -----Original Message----- > From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] > Sent: 17 July 2003 19:44 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: question - off topic sorry > > > Does the French 35 hour work week also apply to the French army during > hostilities? That would explain why they always need our help during [...] 9326 91 30_Re: question - off topic sorry15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Fri, 18 Jul 2003 08:04:06 -0500740_iso-8859-1 I didn't vote for him. That's all I have to say about that.

-----Original Message----- From: ANGOT HARRY [mailto:harry.angot@CDN.FR] Sent: Friday, July 18, 2003 7:48 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question - off topic sorry



Neither they have to howl with Bush and Co....

> -----Message d'origine----- > De: SPUFI Doo [SMTP:spufidoo@YAHOO.CO.UK] > Date: vendredi 18 juillet 2003 12:38 > À: DB2-L@LISTSERV.YLASSOC.COM > Objet: Re: question - off topic sorry > > At least they've got clean hands in this one. > > -----Original Message----- > From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] > Sent: 17 July 2003 19:44 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: [...] 9418 119 30_Re: question - off topic sorry18_Bednarz, Michael P22_Michael.Bednarz@CA.COM31_Fri, 18 Jul 2003 14:24:16 +0100612_iso-8859-1 Nobody vote for him but he is President! How is that going?????

> -----Original Message----- > From: Billings, Linda [mailto:Linda.Billings@deg.state.wi.us] > Sent: Freitag, 18. Juli 2003 15:04 > To: 'DB2 Data Base Discussion List' > Subject: RE: question - off topic sorry > > > I didn't vote for him. That's all I have to say about that. > > -----Original Message----- > From: ANGOT HARRY [mailto:harry.angot@CDN.FR] > Sent: Friday, July 18, 2003 7:48 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: question - off topic sorry > > > Neither they have to howl with Bush and Co.... > > [...] 9538 16 30_Re: question - off topic sorry10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 18 Jul 2003 15:33:12 +0200433_us-ascii What about to stop this part of thread now....to me it doesn't look promising....just an opinion of course

Max Scarpa Certified no mass destruction weapons owner

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 9555 150 30_Re: question - off topic sorry15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Fri, 18 Jul 2003 08:42:49 -0500389_iso-8859-1 From what I recall Bush didn't win the popular vote. It was the electoral vote that got him in.

-----Original Message----- From: Bednarz, Michael P [mailto:Michael.Bednarz@CA.COM] Sent: Friday, July 18, 2003 8:24 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question - off topic sorry



Nobody vote for him but he is President! How is that going????? [...] 9706 176 30_Re: question - off topic sorry11_Greuter, Al18_Al.Greuter@SSA.GOV31_Fri, 18 Jul 2003 09:55:02 -0400410_iso-8859-1 This is WAY off topic. Can we end it now please!

Thanks,

Al Greuter 410-496-9547 -----Original Message----- From: Billings, Linda [mailto:Linda.Billings@DEG.STATE.WI.US] Sent: Friday, July 18, 2003 9:43 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: question - off topic sorry

From what I recall Bush didn't win the popular vote. It was the electoral vote that got him in. [...] 9883 41 30_Re: question - off topic sorry12_McKown, John22_JMckown@UICIINSCTR.COM31_Fri, 18 Jul 2003 09:10:25 -050033_- Totally Agreed.



9925 82 30_Re: Question on DISABLEUNICODE17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 19 Jul 2003 01:23:44 +1000422_iso-8859-1 Myron, Thanks for the reply.

We have just upgraded to V7 from V6 on OS390 and are having lots of problems - UNICODE be one possible problem.

Have you been through this - we are seeing lots of SQLCODES -301 for a JAVA apps connecting to DB2 OS390. This didn't happen when we were on V6 (or so I am lead to believe). We are also seeing OC4 in some apps but believe we have identified this one. [...] 10008 58 21_How many connections?11_Davis, Nick16_NDavis@KABLE.COM31_Fri, 18 Jul 2003 11:05:15 -0500139_iso-8859-1

Use many concurrent connections does DB2 Enterprise Server Edition Version 8.1 support?

Thank you



10067 230 30_Re: question - off topic sorry12_Scott Taylor25_scott.taylor@AUTOZONE.COM31_Fri, 18 Jul 2003 09:07:37 -0500535_iso-8859-1 I agree Max, the direction this one is taking is not a good one. Let's talk religion instead! :) ----------------------------------------------------------------------------------------------------

Scott Taylor Senior DB2 DBA, Autozone 123 S Front St, Memphis, TN 38103 (901)/495-7797







"Billings, Linda" cc: Sent by: DB2 Data Subject: Re: question - off topic sorry Base Discussion List [...] 10298 14 40_Sally Mir/OPS/WACH is out of the office.9_Sally Mir22_sally.mir@WACHOVIA.COM31_Fri, 18 Jul 2003 12:43:39 -0400404_US-ASCII I will be out of the office from 07/18/2003 until 07/29/2003.

Please contact the DBA on call for your database administration needs.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 10313 107 70_Re: a bit off topic - abend S978 RC04 and DB2-l LISTSERV search e rror11_Wang, Jason18_JWang@CARREKER.COM31_Fri, 18 Jul 2003 09:58:20 -0500403_- Hello list,

Environment: OS/390 V2.10 and DB2 version 7.

I am getting this error right now when I run a java JDBC program from within Unix system service. The program get an connection, issues sql query, and get resultset back, and then it close resultset and statement, however when it tried to close the connection by an java statement "con.close()", I got the following message: [...] 10421 46 30_Re: question - off topic sorry12_McKown, John22_JMckown@UICIINSCTR.COM31_Fri, 18 Jul 2003 12:21:30 -0500115_- Ah, you mean "vi" vs. "emacs" with perhaps a bit of ISPF vs. XEDIT for us "legacy" people?



10468 39 19_Non-DB2 question...16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Fri, 18 Jul 2003 11:15:29 -0700413_us-ascii Hi !!

We have a COBOL program here which allocates an output dataset on a tape (UNIT=TAPE) and then performs millions of writes on that dataset (through COBOL WRITE statement). The developer wants the dataset on the tape because the dataset size is too huge to permanently reside on DASD.

I am planning to suggest to the developer the following plan to speed up the program execution: [...] 10508 185 25_Re: Fw: Re: Odd SQL error12_Cathy Taddei27_Cathy.Taddei@PACIFICORP.COM31_Fri, 18 Jul 2003 13:04:20 -0500572_- I may be all wet here, but I would think that DB2 does not pick up DSNHDECP values from the JOBLIB/STEPLIB of the job, but rather from the STEPLIB of ssidMSTR. Cathy

On Fri, 18 Jul 2003 03:51:19 GMT, David S Waugh wrote:

>Well, it looks like I was wrong about point # 2 "I would think you would get inconsistent results depending on whether you have SDSNEXIT in the LOADLIB/STEPLIB concatenation or not." (OK -- I'm feeling distinctly damp again...). A friend of mine who has access to a V7 sandbox DB2 ran some tests, and here are [...] 10694 69 23_Re: Non-DB2 question...0_26_truman.g.brown@VERIZON.COM31_Fri, 18 Jul 2003 14:28:11 -0400254_us-ascii No. Why do you think doing the I/O TWICE - once to disk, and then later from disk to tape in another job or step - would use LESS TOTAL CPU? CPU in the first step would probably be much the same regardles of whether it was to disk or tape. [...] 10764 78 23_Re: Non-DB2 question...15_Billings, Linda30_Linda.Billings@DEG.STATE.WI.US31_Fri, 18 Jul 2003 13:37:26 -0500448_iso-8859-1 Hi, Raquel, Since I am on a roll with off-topics :), I will take a stab at this one. I agree with George. Your CPU time would remain the same. Elapsed time may be a bit shorter, but only if your copy to tape isn't in the same job. Don't you have some kind of storage management in place? Here with DFHSM we would set the data set up in a management class that would cause it to roll off onto cheaper storage after a period of time. [...] 10843 19 23_Re: Non-DB2 question...0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 18 Jul 2003 13:42:56 -0500536_us-ascii Assuming QSAM is being used to write to the tape, I would

a) be sure it is blocked as close to but not exceeding 32767, (DCB=BLKSIZE=0 should do that) b) put 100 buffers (DCB=BUFNO=100) on the tape DD in the JCL c) Use sufficient Region on the Job card.

Stg

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 10863 109 23_Re: Non-DB2 question...30_Mekala, Rama Mohan (Cognizant)25_MRamaMo@CHN.COGNIZANT.COM31_Sat, 19 Jul 2003 00:12:42 +0530568_iso-8859-1 I think, there won't be much saving CPU time, but Elapsed time would drastically reduce. Ram

-----Original Message----- From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] Sent: Friday, July 18, 2003 11:58 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Non-DB2 question...



No. Why do you think doing the I/O TWICE - once to disk, and then later from disk to tape in another job or step - would use LESS TOTAL CPU? CPU in the first step would probably be much the same regardles of whether it was to disk or tape. [...] 10973 235 25_Re: Fw: Re: Odd SQL error11_John Wallin24_john.wallin@ZURICHNA.COM31_Fri, 18 Jul 2003 13:47:07 -0500403_US-ASCII While running a RRS started Procedure with no DSNEXIT lib, I could not connect to the mainframe system DB2X. The error said subsystem DSN identify failed -- wrong SSID . DSN is the default SSID used in IBM's Default DSNHDECP that comes with the system libraries. When I added our DSNEXIT with the genned module DECP to the steplib JCL for the WLM managed procedure everything worked fine. [...] 11209 72 23_Re: Non-DB2 question...14_Wayne Campbell28_Wayne.Campbell@COURTS.WA.GOV31_Fri, 18 Jul 2003 12:03:17 -0700481_- As with everything else "it depends"

Are you concerned with CPU time as related to cost? Writing to Disk and then copying to Tape will always take more CPU.

Are you more worried about clock time of the COBOL program, trying to make a batch window? Then writing to DASD may or may not be faster. With the new tape drive and depending on how everything is set up, it may actually be faster to write to tape. Your system programmer may have a good feel for this. [...] 11282 16 23_Re: Non-DB2 question...14_Lisa Ouellette29_Lisa.Ouellette@FIRSTUNION.COM31_Fri, 18 Jul 2003 13:51:17 -0500386_- Writing a large file to tape may actually be faster than writing it to disk if it is properly blocked - depends on your hardware and I/O configuration. It is a common misconception.

Obviously the overhead of a tape mount (say up to 30 seconds) is significant for a small file but for a very large file is insignificant and the tape performance may make that up plus some. [...] 11299 26 46_Increasing the number of Secondary RACF Groups10_Dean Capps18_Dean.Capps@MCI.COM31_Fri, 18 Jul 2003 14:50:02 -0500401_- Hi,

We are running into an issue wherein the number of Secondary RACF groups that a primary RACF ID is connected to is exceeding the limit of 245. I understand that secondary RACF checking is controlled in DSN3@ATH. My questions are:

01. Has anyone else encountered this problem? 02. If yes, any work arounds? 03. Has anyone tried to modify DSN3@ATH to increase the limit of 245? [...] 11326 232 25_Re: Fw: Re: Odd SQL error12_michael bell24_mbell11@WORLDNET.ATT.NET31_Fri, 18 Jul 2003 15:48:56 -0500467_iso-8859-1 The normal answer is "It depends" 1. Yes, xxxxMSTR has a copy of DECP - That is where CCSID's, DEC31, Date format, and some other "STUFF" that is consistent for the entire subsystem is defined. That is retrieved from the steplib in the proc for the mstr address space. 2. The precompiler and other "BATCH" process will obviously get it from joblib/steplib. 3. The default subsystem to connect to is one of the documented accesses from joblib/steplib. [...] 11559 79 23_Re: Non-DB2 question...12_michael bell24_mbell11@WORLDNET.ATT.NET31_Fri, 18 Jul 2003 15:49:01 -0500576_us-ascii Maximum transfer rate for striped DASD is about 20 MB/sec. Non striped DASD is about 10 MB/SEC for shark and current DASD. Older DASD - which is what you usually assign to temp files/sort work, etc is even less than that. Normal is about 5MB/sec. Last time I checked the fastest tape was inbetween those values but this changes every 6 months. The last performance evaluations I saw - said that for tape at 32K buffers there was no benefit in CPU or elapsed time beyond DCB=BUFNO=10. In fact even DASD blocked at half track (DCB=BLKSIZE=0) didn't show any delta [...] 11639 54 23_Re: Non-DB2 question...28_McDonnell, Victor non Unisys27_Victor.McDonnell@UNISYS.COM31_Fri, 18 Jul 2003 15:50:13 -0500352_iso-8859-1 You will absolutely save on ET and I/O! Most data centers do not allow program writes to tape but only utility writes (GENER, Syncsort) -- go with your plan! and tell 'em Syncsort if they have it.

-----Original Message----- From: Raquel Rodriguez To: DB2-L@LISTSERV.YLASSOC.COM Sent: 7/18/03 1:15 PM Subject: Non-DB2 question... [...] 11694 16 36_Steve Westfall is out of the office.14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Fri, 18 Jul 2003 17:06:27 -0400380_us-ascii I will be out of the office starting 07/18/2003 and will not return until 07/21/2003.



Steve Westfall

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 11711 173 13_XML Usage Q's13_Tariq Rathore27_Tariq.Rathore@COURTS.WA.GOV31_Fri, 18 Jul 2003 14:34:25 -0700490_- Hello,





We are starting to get out feet wet with XML on the DB2/390 and want to learn from your experiences in:





= Managing DADs and DTDs with respect to

- naming conventions

- migration between environments e.g. dev to test





= If USS is necessary for some of these objects





= Using USS in the usage of some of these objects and what kind of security setup is needed for end users [...] 11885 29 23_Next Key locking in UDB10_John Lantz23_john.lantz@ZURICHNA.COM31_Fri, 18 Jul 2003 16:33:38 -0500571_- We are having an issue in UDB on the windows platform with locking and it's with NS (next key share). We are at 7.2 (fp8). We've set the variable db2_rr_ro_rs=yes and our application will insert/update rows while other connections are trying to insert other data. This is the locking conflict we are having: Lock mode = Exclusive Lock (X) Lock mode requested = Next Key Share (NS) An UPDATE/INSERT has locked a row, and another connection is trying to INSERT into the table (with a different UNIQUE key). The insert is waiting because it's trying to get a NS lock [...] 11915 80 52_Re: IKJEFT01 vs RRSAF -- What's normal? What's best?5_DB2-L24_DB2-L@SUPPORT.RELARC.COM31_Fri, 18 Jul 2003 17:52:18 -0400537_- IBM has stated they will no longer provide enhancements for CAF, and RRSAF is the strategic interface to connect application programs to various resource managers, e.g. WebSphere MQ, DB2, etc. Going forward, RRSAF is the preferred attachment.

RAI's attachment facility, Smart/RRSAF allows your batch DB2 applications to connect to DB2 using either the traditional call attach facilily or the newer interface, RRSAF (Resource Recovery Services Attachment Facility) as a stand alone product, without any source code changes. [...] 11996 44 17_Row Number in SQL12_Pabia, Steve21_steve_pabia@MERCK.COM31_Fri, 18 Jul 2003 15:56:07 -0400309_iso-8859-1 Hi,

I'm trying to do the following in SQL (SPUFI) but can't figure out how to do it. Assuming that I have a table with two columns:

COMPNO BATCH_ID

I'd like to retrieve rows as follows:

???? COMPNO BATCH_ID 1 01 N1234 2 01 P4567 3 01 P6789 4 01 R1234 ... ... ..... [...] 12041 140 52_AW: IKJEFT01 vs RRSAF -- What's normal? What's best?16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Sat, 19 Jul 2003 01:14:20 +0200498_iso-8859-1 Beside RRSAF as the preferred atttachment.

IBM should aware of the other attachments and should provide the possibility

to handle different attachments under TSO/ISPF. Don't IBM know it's a multithreaded environment????

Sample ISPF Screen 1 Application 1 with CAF ISPF Screen 2 Start application 2 with RRSAF cause RC00F30024

Also the debug info from CAF (DSNALI) via DD DSNTRACE is very helpful instead of the RRSAF trace info. Which is almost useless. [...] 12182 72 56_Re: AW: IKJEFT01 vs RRSAF -- What's normal? What's best?14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Sat, 19 Jul 2003 06:56:01 +0200650_- Hello,

we also had problems with multithreading and TSO. We tried to switch completely to DSNALI, even with TSO, but after some experiments we stayed with DSNELI.

But another problem comes to mind:

we wanted to have a replacement for DSNHLI, which examines the environment (TSO, Batch, IMS) and switches to the correct interface (DSNELI, DSNALI, DFSLI000). The environment is examined only the very first time; after that the correct entry point is stored; subsequent calls go to the original IBM interface directly. This works, we did some ASSEMBLER coding and linked the original IBM interfaces with changed names (LKED [...] 12255 74 23_Re: Non-DB2 question...12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 19 Jul 2003 10:51:58 +0200279_- Hi,

When you say "write to tape" do you mean VTS (or comparable product) or "real tape"? Working with VTS (if you have it) looks to me as the answer in this case. Writing to DASD and than copying it will cost you in CPU & ELAPSED as the copy does not come free :-( [...] 12330 57 23_Re: Non-DB2 question...15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Sat, 19 Jul 2003 22:18:07 +0300328_us-ascii On Fri, 18 Jul 2003 15:50:13 -0500 "McDonnell, Victor non Unisys" wrote:

:> You will absolutely save on ET and I/O! Most data centers do not allow :>program writes to tape but only utility writes (GENER, Syncsort) -- :>go with your plan! and tell 'em Syncsort if they have it. [...] 12388 55 23_Re: Non-DB2 question...13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Sat, 19 Jul 2003 14:51:00 -0500437_iso-8859-1 I would go for tape directly, but give it a test and let us know the result. As of 'most sites not allowing direct write to tape' - that is the first I've heard of such a practice. Others might have some insight to such practice.

-----Original Message----- From: Raquel Rodriguez [mailto:raquel_rodriguezus@YAHOO.COM] Sent: Friday, July 18, 2003 1:15 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Non-DB2 question... [...] 12444 38 38_Re: Messages and Codes, latest edition20_D'Aleo Claudio (IBM)24_daleoc@TELEFONICA.COM.AR31_Sat, 19 Jul 2003 19:50:40 -0300368_- Hi list, when running inline statistics on REORG TABLESPACE LIST xxxx ... STATISTICS TABLE(ALL) INDEX ALL KEYCARD I get an abend with other reason (don't remember now which). But if I take KEYCARD out it runs OK. It also runs OK with REORG TABLESPACE dbname.tsname ... STATISTICS TABLE(ALL) INDEX ALL KEYCARD Does it relate with PQ66513? Regards, Horacio Villa [...] 12483 84 21_Re: Row Number in SQL35_=?windows-1255?B?7unr4Owg7Onh+O7v?=25_mliberman@MIVTACHIM.CO.IL31_Sun, 20 Jul 2003 10:52:36 +0200631_windows-1255 Hi Steve,

There is a quite easy way to do it using the ROWID function: Select ROWID(expression),COMPNO,BATCH_ID From creator.tab1 Where.......

Notice that you'll have to add a mathematical expression to the ROWID value because the result from the ROWID function returns Hexa format value.

Good luck,



Michael Liberman Senior DBA Mivtachim Inc

mliberman@mivtachim.co.il







-----Original Message----- From: Pabia, Steve [mailto:steve_pabia@MERCK.COM] Sent: Friday, July 18, 2003 9:56 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Row Number in SQL [...] 12568 22 48_URG: DB2 (Z/OS) DBA with Peoplesoft 8 Experience17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sun, 20 Jul 2003 07:34:04 -0500358_- Hi, We have an immediate opening (contractual position) for a DB2 DBA with experience in performance tuning Peoplesoft 8 financial suite. The person should have 3+ years of experience as a DBA in DB2 /Z-OS environment. Familiarity with toolset is a requirement. Nature of work: Performance tuning Batch and online processes. Maintain PS environments. [...] 12591 99 30_Re: Question on DISABLEUNICODE12_Myron Miller22_myronwmiller@YAHOO.COM31_Sun, 20 Jul 2003 10:24:14 -0700561_us-ascii Its entirely possible that the UNICODE is causing your -301s. Also are you on at least FP6 of DB2 Connect? There's lots of JAVA type incompatibilities with prior versions and DB2 V7.

Myron --- Richard Cotterill wrote: > Myron, > Thanks for the reply. > > We have just upgraded to V7 from V6 on OS390 and are having lots of > problems - UNICODE be one possible problem. > > Have you been through this - we are seeing lots of SQLCODES -301 for a JAVA > apps connecting to DB2 OS390. This didn't happen when we were [...] 12691 60 27_Re: Next Key locking in UDB14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Sun, 20 Jul 2003 22:05:31 -0500592_us-ascii John, I've just reread a presentation from the 2000 Tech Conference given by an IBM developer regarding this issue. It appears that while the rr_to_rs=yes will prevent next key locking during inserts and deletes, there still may be next key locks taken for end of range locking, at least this is my interpretation. The presentation is entitled Locking and Concurrency in DB2/UDB for Intel and Unix, presentor Leslie Cranston, and was from the 2000 tech conference. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: All opinions are strictly my own. [...] 12752 15 50_Wayne Goodwin/CIS/TJX/TJXCOS is out of the office.13_Wayne Goodwin21_Wayne_Goodwin@TJX.COM31_Mon, 21 Jul 2003 01:02:36 -0400403_us-ascii I will be out of the office starting 07/19/2003 and will not return until 07/27/2003.

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://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 12768 23 16_DB2 V7 - Unicode17_Frost, Mark [GRB]24_mark.frost@CITIGROUP.COM31_Mon, 21 Jul 2003 11:20:03 +0100396_ISO-8859-1 Hi.

Having recently upgraded to V7 on OS390 we are now having some problems connecting from client java applications to the host. The problems are code page conversion issues, related to unicode support. We do not have unicode services activated on OS390.

Does anyone know if there is a minimum Fixpack level of DB2 Connect required for accessing DB2 V7 on OS/390 ? [...] 12792 21 30_DFSORT symbols from SYSCOLUMNS36_=?us-ascii?Q?Oscar_Salgado_Sanchez?=12_oss19@TID.ES31_Mon, 21 Jul 2003 12:09:02 +0200468_us-ascii Hello:

Does anybody know whether is there any utility which generates symbols to DFSORT Rel. 14 based on the definitions found within SYSIBM.SYSCOLUMNS?

Regards

Oscar Salgado Sanchez

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 12814 11 13_SIGNOFF DB2-L13_Ealey, Paul M18_paul.ealey@EDS.COM31_Mon, 21 Jul 2003 11:52:58 +0100267_iso-8859-1

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 12826 65 20_Re: DB2 V7 - Unicode12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Mon, 21 Jul 2003 07:24:29 -0400676_us-ascii In the DB2CLI.ini file you need to add:

[COMMON] DISABLEUNICODE=1

The [COMMON] could also be listed for each subsystem if you would like...

This fixed the problem for us...

HTH

Mark

Mark Anzmann Tech Services Manager DHRIS Program - Team Accenture Phone: 410-238-1213 email: manzmann@dhr.state.md.us

>>> mark.frost@CITIGROUP.COM 07/21/03 06:20AM >>> Hi.

Having recently upgraded to V7 on OS390 we are now having some problems connecting from client java applications to the host. The problems are code page conversion issues, related to unicode support. We do not have unicode services activated on OS390. [...] 12892 96 20_Re: DB2 V7 - Unicode17_Frost, Mark [GRB]24_mark.frost@CITIGROUP.COM31_Mon, 21 Jul 2003 12:33:37 +0100423_iso-8859-1 Hi Mark.

Thanks for that. Ive seen that one as a solution to a certain error. However, one of the things I am trying to find out what happens if you access a DB2 V7 OS390 host with a pre unicode compliant version of DB2 Connect ?

We have some workstations that work with DB2 V7 and others that experience code page errors.. I am trying to pin this down to a fixpack / version of DB2 connect ? [...] 12989 16 63_Dirk Pohl/Coburg/SERCON/DE ist =?ISO-8859-1?Q?au=DFer_Haus=2E?=9_Dirk Pohl19_dirk.pohl@SERCON.DE31_Mon, 21 Jul 2003 13:46:28 +0200399_ISO-8859-1 Ich werde ab 21.07.2003 nicht im Büro sein. Ich kehre zurück am 10.08.2003.

Ich werde Ihre Nachricht nach meiner Rückkehr beantworten. ===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13006 85 31_Re: SYSDBASE performance issues14_Melissa Rogers26_mrogers@NYSTRS.STATE.NY.US31_Mon, 21 Jul 2003 07:55:41 -0400653_iso-8859-1 Thanks for the information. I will give these things a try.

-----Original Message----- From: David S Waugh [mailto:dsw-dba@JUNO.COM] Sent: Friday, July 18, 2003 12:16 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: SYSDBASE performance issues



Melissa: A couple of quick thoughts:

- Check to see if one subsystem has *user-defined* indexes on the catalog tables and the other doesn't. Somebody may have defined them on TEST because it was so big, but did not define them on PROD. - Make sure RUNSTATS has been run (recently) on both. - Check to see if DSNDB07 # of tablespaces (and sizes) are similar. - Check [...] 13092 57 44_Re: DB2 UDB v7 on AIX - Client configuration11_Grant Allen21_grant@TOWERSOFT.CO.UK31_Mon, 21 Jul 2003 13:30:22 +0100604_iso-8859-1 Not too familiar with the "physically resides on host" option, but it should be possible to catalog the db under an 8 character or less alias, and then use that alias.

Ciao Fuzzy :-)

> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of McClendon, Rick > Sent: Tuesday, July 15, 2003 15:06 > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: DB2 UDB v7 on AIX - Client configuration > > > When I try to set up a DB2 run time client, the checkbox (1) > that specifies > "physically resides on the host" is not there. In [...] 13150 31 50_Re: Increasing the number of Secondary RACF Groups11_Tim Wilkins30_tim.wilkins.g09a@STATEFARM.COM31_Mon, 21 Jul 2003 07:26:24 -0500349_- 01. Has anyone else encountered this problem?

Yes

02. If yes, any work arounds?

Check all Secondary Auth ID's for user * (asterik) as these will count toward the limit. Have your RACF Administrator create a group that will be used to exclude a user(s) from Secondary Auth ID's that have the asterik in their access list. [...] 13182 81 50_Re: Increasing the number of Secondary RACF Groups11_Tim Wilkins30_tim.wilkins.g09a@STATEFARM.COM31_Mon, 21 Jul 2003 07:53:20 -0500640_- Have your RACF Administrator run the DB2 loads, see RACDBUTB from IBM (snip shown below). The queries that can be used in a clist are shown below too.



Name: RACDBUTB

Description: Define the table space and tables used to contain the output of the RACF Data Base Unload Utility (IRRDBU00).

Operation: These are sample data definition language (DDL) statements that can be used to create tables to hold the output of the RACF Database Unload Utility (IRRDBU00). These statements create the tablespace IRRDBU00 in the data base RACFDB2. The tables that are created are shown below. The "Record Type" refers [...] 13264 31 19_'Top X' SQL - Help!14_Lisa Ouellette29_Lisa.Ouellette@FIRSTUNION.COM31_Mon, 21 Jul 2003 08:11:35 -0500410_- I knew how to do this and forgot. Can someone help me? DB2 UDB OS/390 V7.

I have a 'BATJOB' table that contains one row for every job that executed in the last 75 days. I want a result set that has the details for every job that executed if that job's total elapsed time for the month is in the 'top 20'. Oh - and I want it all based on the last full month's jobs (right now that would be June). [...] 13296 61 20_Re: DB2 V7 - Unicode10_Tom Taylor17_ttaylor@CHUBB.COM31_Mon, 21 Jul 2003 09:21:21 -0400469_us-ascii Mark

udb v7 Fixpack 9 will fix the unicode translation problems or disableunicode=y

search for 'disableunicode' at ibm.... look for technical notes

Tom





"Frost, Mark [GRB]" To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 V7 - Unicode Sent by: DB2 Data Base Discussion List



07/21/03 06:20 AM Please respond to DB2 Data Base Discussion List [...] 13358 53 27_Re: Next Key locking in UDB14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 21 Jul 2003 10:21:25 -0400335_ISO-8859-1 John,

We had a similar problem with next key locking and we did set the db2_rr_to_rs to YES, but that does not remove the problem, only seems to alleviate it a little. Finally the best solution we found was to manage our units of work into smaller chunks and also to slightly increase the LOCKTIMEOUT parameter. [...] 13412 41 42_Backing up stored procedures on UDB on AIX0_24_lightsey@ITS.STATE.MS.US31_Mon, 21 Jul 2003 09:35:42 -0500546_us-ascii My users are getting more and more interested in using SQL and Java stored procedures - so I, as their final fallback and fall-guy, need to make sure that I can recover not only their data but also the stored procedures themselves. Questions -

1) Does an offline, full backup of the database back up the stored procedure source ? ( I'm guessing not ), 2) We back up the various directories using FDR-Upstream - including the ones where the .jar / .c are located. What would I need to do to get a restored jar or c rebound to [...] 13454 22 46_Insert in segmented tablespace vs nonsegmented17_Christophe Radier17_c300501@YAHOO.COM31_Mon, 21 Jul 2003 10:01:44 -0500492_- dear all, just to verify something , I've read somewhere (but could not remind where i read it) , that with a non segmented tablespace , if space is not found near the page it should be , DB2 will start the scan from the beginning of the tablespace until it can find the place where it can put the record (I suppose it reads space map and if it has a doubt it reads data page ? ) Can you confirm me that my memory is good . And i suppose that with a segmented tablespace db2 first try [...] 13477 54 50_Re: Insert in segmented tablespace vs nonsegmented14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 21 Jul 2003 16:42:00 +0100332_iso-8859-1 For segmented it looks in the right page, then in the current segment and then creates a new segment at the end of the tabespace (or at least it used to!)

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 13532 19 50_Re: Insert in segmented tablespace vs nonsegmented2_JH16_tzs61x@YAHOO.COM31_Mon, 21 Jul 2003 08:48:08 -0700403_us-ascii Thanks !



__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13552 18 19_test, please ignore2_JH16_tzs61x@YAHOO.COM31_Mon, 21 Jul 2003 08:50:08 -0700393_us-ascii Thanks

__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13571 21 29_REXX/DB2 interface, free or $2_JH16_tzs61x@YAHOO.COM31_Mon, 21 Jul 2003 09:04:19 -0700525_us-ascii To all: Is there any additional cost for REXX/DB2 interface. or is it a "FREE" product comes with DB2 tapes. We have z/OS DB2 Ver7. Thanks

__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13593 65 23_Re: 'Top X' SQL - Help!15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Mon, 21 Jul 2003 12:37:12 -0400662_iso-8859-1 Lisa, for your full month predicate try

month(endts) = month(lastdate(current date) - 1 month)

The lastdate function will give the last date for the month in the argument then substract 1 month from that date and then determine the month for that date.



Bob Lawrence DBA Boscov's Dept Stores LLc





> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Lisa Ouellette > Sent: Monday, July 21, 2003 9:12 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: 'Top X' SQL - Help! > > > I knew how to do this and forgot. Can someone help me? DB2 [...] 13659 139 20_Re: DB2 V7 - Unicode13_Patrick Testa16_ptesta@CHUBB.COM31_Mon, 21 Jul 2003 12:38:23 -0400563_us-ascii Mark, It is very highly reccommended to install and configure the Conversion Services Support for UNICODE - the 'alternate' - ICONV - is used if Conversion Services is not found by DB2 - BUT ICONV has defects that will NOT be fixed by IBM support. DISABLEUNICODE=1 does - well - stop unicode flows from V7 clients - BUT - depending on how your DB2 Connect is 'distributed' - rolling out a DB2CLI.INI change can be a challenge. FIXPACK 9 - does correct some issues (like an explicit CLI0109E data truncation error) - BUT - must be on the CLIENTs and [...] 13799 44 33_Re: REXX/DB2 interface, free or $15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Mon, 21 Jul 2003 13:01:43 -0400617_iso-8859-1 I believe it is a free orderable feature with its own FMID Bob Lawrence DBA Boscov's Dept Stores LLc





> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of JH > Sent: Monday, July 21, 2003 12:04 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: REXX/DB2 interface, free or $ > > > To all: > Is there any additional cost for REXX/DB2 interface. > or is it a "FREE" product comes with DB2 tapes. > We have z/OS DB2 Ver7. > Thanks > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 [...] 13844 39 33_Re: REXX/DB2 interface, free or $11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 21 Jul 2003 09:45:19 -0700481_- JH, it came with my v7 tapes. Look for FMID JDB771H To install look at the Program Directory "DB2 Rexx Language Support (gi10-8219-00). cliff:-)

-----Original Message----- From: JH [mailto:tzs61x@YAHOO.COM] Sent: Monday, July 21, 2003 9:04 AM To: DB2-L@listserv.ylassoc.com Subject: REXX/DB2 interface, free or $



To all: Is there any additional cost for REXX/DB2 interface. or is it a "FREE" product comes with DB2 tapes. We have z/OS DB2 Ver7. Thanks [...] 13884 15 21_Rebind after RUNSTATS15_Barbara J. Nigh20_bjnigh@HOUSEHOLD.COM31_Mon, 21 Jul 2003 10:27:55 -0700494_us-ascii We have a batch program that runs every day. If the runstats utility runs against the table being used by the batch program, the program then starts to runs very slowly until rebound. Any suggestions on how to resolve this issue?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 13900 37 33_Re: REXX/DB2 interface, free or $13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Mon, 21 Jul 2003 12:32:31 -0500480_iso-8859-1 It is free.

-----Original Message----- From: JH [mailto:tzs61x@YAHOO.COM] Sent: Monday, July 21, 2003 11:04 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: REXX/DB2 interface, free or $



To all: Is there any additional cost for REXX/DB2 interface. or is it a "FREE" product comes with DB2 tapes. We have z/OS DB2 Ver7. Thanks

__________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com [...] 13938 19 22_A little support humor13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Mon, 21 Jul 2003 12:36:54 -0500358_- I was currently working a problem with one of our many many DB2 product vendors (I lost count after 5). And, I was running a DSN1LOGP job against the BSDS. On the first round my STARTLRSN/ENDLRSN did not have the information they were looking for. They suggested using STARTLRSN(000000000000) ENDLRSN(FFFFFFFFFFFF) for all the members of my DS group. [...] 13958 44 26_Re: A little support humor14_Shaul Bergfeld18_sbergfeld@TACT.COM31_Mon, 21 Jul 2003 13:50:39 -0400634_iso-8859-1 Do you always save the best part of the joke to yourself ???

-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Monday, July 21, 2003 1:37 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: A little support humor



I was currently working a problem with one of our many many DB2 product vendors (I lost count after 5). And, I was running a DSN1LOGP job against the BSDS. On the first round my STARTLRSN/ENDLRSN did not have the information they were looking for. They suggested using STARTLRSN(000000000000) ENDLRSN(FFFFFFFFFFFF) for all the members of my DS group. [...] 14003 34 26_Re: A little support humor50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Mon, 21 Jul 2003 13:53:57 -0400636_iso-8859-1 I can't even imagine all the havoc that would have caused.....

-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Monday, July 21, 2003 1:37 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: A little support humor



I was currently working a problem with one of our many many DB2 product vendors (I lost count after 5). And, I was running a DSN1LOGP job against the BSDS. On the first round my STARTLRSN/ENDLRSN did not have the information they were looking for. They suggested using STARTLRSN(000000000000) ENDLRSN(FFFFFFFFFFFF) for all the members of my DS group. [...] 14038 51 44_YL&A August - September DB2 Course Offerings12_susan lawson24_susan_lawson@YLASSOC.COM31_Mon, 21 Jul 2003 12:55:19 -0500473_iso-8859-1 It’s not too late to enroll in the YL&A courses being held at the Techknowledge Training facilities in Columbia, MD.

8/11-12 DB2 High Performance Design and Tuning 8/18-19 Advanced Programming: Stored Procedures, UDFs and Triggers 8/20 DB2 UDB V8 for UNIX/Windows Performance 8/21-22 DB2 Version 7 Transition 8/25 DB2 V7/V8 z/OS Impacts on Design and Performance 8/26 DB2 V7 DBA Certification Crammer Course 9/3-4 Advanced SQL Coding and Performance [...] 14090 64 26_Re: A little support humor12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 21 Jul 2003 21:18:21 +0200392_- Hi,

I suggest you print it and send it to the company involved (+ the paper bill as well as CPU bill :-)





Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Shaul Bergfeld Sent: Monday, July 21, 2003 7:51 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: A little support humor [...] 14155 48 18_DB2 type 2 indexes11_Regina Post21_Regina.Post@PHILA.GOV31_Mon, 21 Jul 2003 14:07:07 -0400384_us-ascii We have an application that is experiencing problems since migrating to type 2 indexes. Specifically a batch program which does inserts/ updates .. completely hangs after a certain amount of time. We have proven that the problem exists in both v5.1 and v7.1 of DB2. If we alter the indexes back to type 1 (which is only possible in v5.1) the program works as it should. [...] 14204 72 22_Re: DB2 type 2 indexes12_Scott Taylor25_scott.taylor@AUTOZONE.COM31_Mon, 21 Jul 2003 14:12:40 -0500570_us-ascii Never head of this either. Could you elaborate a bit about "completely hangs"? Do you have a DB2 monitor to check the thread status when the hang occurs?

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

Scott Taylor Senior DB2 DBA, Autozone 123 S Front St, Memphis, TN 38103 (901)/495-7797







Regina Post cc: Sent by: DB2 Data Subject: DB2 type 2 indexes Base Discussion List [...] 14277 72 33_Re: REXX/DB2 interface, free or $14_Martin Flavell18_mflavell@I-TCS.COM31_Mon, 21 Jul 2003 20:15:13 +0100 14350 241 18_Image copy failure22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 21 Jul 2003 11:18:12 -0500542_iso-8859-1

Dear listeners,

OS/390 2.10 DB2 V7.1 (No Data-sharing)

I have a Job that does image copies of about 1,000 the tables in 6 different application databases using LISTDEF. Yesterday, the Job failed with the following error after running for about an hour and a half (usually, it runs about 4 hrs)

DSNU099I -DB2P DSNUBADR - IRLM LOCK REQUEST FAILED, IRLM RETURN CODE = X'00000008' IRLM REASON CODE = X'2000' DSNU017I DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASSON=X'00E40085' [...] 14592 65 56_Re: DB2 precompile phase in z/OS C/C++ compiler (DB2 V7)10_Lisa Bates29_Lisa.Bates@ROCKETSOFTWARE.COM31_Mon, 21 Jul 2003 16:30:44 -0400538_iso-8859-1 Roger, Yes we have the DB2 ptf, and we are using the z/OS R2 C compiler. This is on a z/OS 1.3 system, I have also tried using the 1.4 CBC libraries, same result. We have read the V7 App Prog & SQL guide. The newly added details under the heading "Using the C SQL statement coprocessor" on P399 appear promising. However without an example, we're left wondering if we have the syntax correct. The error message generated when trying to compile the program is *=WARNING=========> CCN0049 The option "SQL" is not supported. [...] 14658 81 60_FW: Re: DB2 precompile phase in z/OS C/C++ compiler (DB2 V7)10_Lisa Bates29_Lisa.Bates@ROCKETSOFTWARE.COM31_Mon, 21 Jul 2003 16:36:25 -0400328_iso-8859-1 One more detail, the original intent was to use C++, however since your email says that support for C++ is not added until z/OS 1.5 and DB2 V8 the programmer will use C until those versions are available in our environment. The error shown below is trying to compile using C, not C++. Lisa Bates Rocket Software [...] 14740 128 22_Re: DB2 type 2 indexes15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM31_Mon, 21 Jul 2003 16:44:20 -0400528_us-ascii We experienced this with one PassPort index as we were getting ready to migrate from release 5 to release 6.1 of DB2 at FPL. We tried tweeking the index, but to no avail. The batch program that seemed to use this table the most used it as a work table, so it was constantly inserting, updating and deleting rows from the table. This was the only index we had a problem with. Since no-one was able to come up with a better solution at the time, I ended up getting rid of the index, which was unique, and just added [...] 14869 31 34_Re: DFSORT symbols from SYSCOLUMNS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 22 Jul 2003 07:56:36 +1000650_US-ASCII Do you mean "within SYSx.PARMLIB/IPLPARM "? If so, IBM-MAIN would be a better place to ask.

James Campbell

On 21 Jul 2003 at 12:09, Oscar Salgado Sanchez wrote:

> Hello: > > Does anybody know whether is there any utility which generates symbols to > DFSORT Rel. 14 based on the definitions found within SYSIBM.SYSCOLUMNS? > > Regards > > Oscar Salgado Sanchez > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...] 14901 34 38_Re: Messages and Codes, latest edition14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 22 Jul 2003 08:12:33 +1000802_US-ASCII http://www-3.ibm.com/software/data/db2/os390/infoupdates.html - although it's not there either.

James Campbell

On 18 Jul 2003 at 9:02, Gerhard.Heiss@RUV.DE wrote:

> collecting inline statistics during LOAD (STATISTICS INDEX(ALL) UPDATE ALL) > I got: > DSNU622I -DBT2 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR > #QBDBA00.Q01X200 NOT SUCCESSFUL, REASON = 00E70114 > Couldn't find this reason in "Third Edition, Softcopy Only (October 2002)" > which was downloaded from http://publib.boulder.ibm.com/cgi-bin/bookmgr. > Are there any later editions? > > regards > > gerhard > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the [...] 14936 45 50_Re: Increasing the number of Secondary RACF Groups14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 22 Jul 2003 08:12:33 +1000412_US-ASCII Is it possible to filter the RACF groups in some way. - I recall that the RACF groups you use for DB2 privileges start with '#'; does your DSN3@ATH pass only those to DB2. - Can you use intelligent filtering. EG if an id is in two groups one which allows read and update access and one which allows only read access, the latter is superfluous. - maybe its time to switch to RACF based permissions. [...] 14982 59 22_JCL to run another JCL6_Nam Wu21_Nam_Wu@PEOPLESOFT.COM31_Mon, 21 Jul 2003 15:49:54 -0700435_us-ascii Hi,

I am a newbie to the DB2 mainframe. I have a question regarding JCL. Is it possible for a JCL to execute another JCL?

//NAMSJOB JOB 'ACCOUNT',CLASS=J,MSGCLASS=C, // NOTIFY=&SYSUID //*************************************************************** //STEP1 EXEC PGM=?????,DYNAMNBR=20,REGION=4096K //SYSEXEC DD DISP=SHR,DSN=&&RUNJCL //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //



Thanks!

15042 167 26_Re: JCL to run another JCL22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 21 Jul 2003 18:10:33 -0500593_iso-8859-1

If you have that JCL in a PDS, you can use something like this to submit it in batch, if that's what you're looking for:

//*-------------------------------------------------------------------* //* SUBMIT JOBS FROM A PDS MEMBER IN BATCH //*-------------------------------------------------------------------* //SUBSNPBU EXEC PGM=IKJEFT1B //SYSPRINT DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * SUBMIT 'HLQ.JCLLIB(TEST)'

HTH,

Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736 [...] 15210 56 26_Re: JCL to run another JCL12_Cathy Taddei27_Cathy.Taddei@PACIFICORP.COM31_Mon, 21 Jul 2003 18:11:29 -0500566_- Yes, this is accomplished using a JES2 facility called the internal reader. The following example is from the JES2 Initialization and Tuning Guide. You may be interested to read the section from that manual titled "Using the Internal Reader Facility".

... //STEP9 EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=Z //SYSUT2 DD SYSOUT=(A,INTRDR) //SYSIN DD DUMMY //SYSUT1 DD DATA,DLM=XX //MYJOB1 JOB ACCT,VAZQUEZ,CLASS=A //STEP1 EXEC PGM=CRUSHER //ERRORS DD SYSOUT=A //INPUT DD DSN=JES2.INIT.TUNE,DISP=SHR //OUTPUT DD DSN=SMALL.BOOK,DISP=SHR XX //STEP10 EXEC ... [...] 15267 38 26_Re: JCL to run another JCL15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Tue, 22 Jul 2003 02:19:58 +0300490_us-ascii On Mon, 21 Jul 2003 15:49:54 -0700 Nam Wu wrote:

:>I am a newbie to the DB2 mainframe. I have a question regarding JCL. Is :>it possible for a JCL to execute another JCL? :> :>//NAMSJOB JOB 'ACCOUNT',CLASS=J,MSGCLASS=C, :>// NOTIFY=&SYSUID :>//*************************************************************** :>//STEP1 EXEC PGM=?????,DYNAMNBR=20,REGION=4096K :>//SYSEXEC DD DISP=SHR,DSN=&&RUNJCL :>//SYSTSPRT DD SYSOUT=* :>//SYSPRINT DD SYSOUT=* [...] 15306 14 22_Online REORG with COPY15_Barbara J. Nigh20_bjnigh@HOUSEHOLD.COM31_Mon, 21 Jul 2003 17:45:27 -0700457_us-ascii If I execute an online reorg with an image copy on a tablespace, do I need to run the quiesce utility to get a clean point of recovery or can I use the backup from the online reorg to recover?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 15321 59 24_Hiperpools Vs Dataspaces16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Mon, 21 Jul 2003 18:35:50 -0700398_us-ascii I know hiperpools Vs Dataspaces have been discussed (beaten!!) several times here but I still have (at least) one doubt.

In the absence of z/OS architecture (without 64 bit support), I have heard that hiperpools or dataspaces are *almost* similar in performance. Many people have reported that dataspaces have provided some minor benefits over hiperpools. Here is my question: [...] 15381 104 23_Re: Non-DB2 question...16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Mon, 21 Jul 2003 18:41:50 -0700273_us-ascii Thanks for all the replies. As suggested by most, my tests indicated that though the elapsed time for writing to a tape does exceed that of writing to a disk (around 70% more), the CPU time for writing to tape was actually a bit less (around 10% in my case). [...] 15486 64 37_Re : IDUG Solutions Journal / Website6_ScotDB18_teamdba@SCOTDB.COM31_Tue, 22 Jul 2003 03:15:24 +0100692_- Brenda Castiel, editor of IDUG Solutions Journal, has asked me to forward the following to the DB2-L.

Hopefully it clears up some of the issues.

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

As Editor of the Solutions Journal, allow me to reply to your comments.

1. We are behind by one issue on the website, issue #1 for 2003, which came out in May. We are working with a new web services provider this year, and there were some mis-communication and learning curve issues, etc. We hope to have this issue up very soon. It's definitely not our intention to hold anything back, as our [...] 15551 143 23_Re: Non-DB2 question...11_John Wallin24_john.wallin@ZURICHNA.COM31_Mon, 21 Jul 2003 22:17:56 -0500362_US-ASCII I guess the only other question is do you use SMS. In that case write to disk, set up an SMS class which migrates to tape within 15 minutes and you are done. You can recall the migrated tape and use disk access speeds to restore the IC.



Raquel Rodriguez @LISTSERV.YLASSOC.COM> on 07/21/2003 08:41:50 PM [...]