1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2000, week 2 2 21 39_DB2 Dual Logging to Single logging mode9_SrinivasG17_SRINIVASG@INF.COM30_Sat, 8 Apr 2000 13:12:39 +0530391_iso-8859-1 Hi, I would like to know what are the issues to be takken care while falling back from Dual logging to Single logging mode. Does any one have a step by step approach or tell me where I can find info in this regard?

Is it sufficient to change the DSN6LOGP macro parameters TWOACTV and TWOARCH in DSNTIJUZ to NO ? Is there anything else that needs to be taken care of ? [...] 24 30 37_Re: Loding data in partition of table11_Mike Turner29_Michael_Turner@COMPUSERVE.COM30_Sat, 8 Apr 2000 05:13:40 -0400389_ISO-8859-1 LOCKPART has NO effect on utilities, only on SQL. The problem in this case is almost certainly the Load control cards as identified by Tim Lowe. LOAD RESUME YES ... INTO TABLE PART n REPLACE is a load replace of partition n and a load resume of all other partitions. LOAD ... INTO TABLE PART n REPLACE is a load replace of part n with NO load activity on other partitions. [...] 55 72 33_Re: optimizerrrrr & List Prefetch14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Sat, 8 Apr 2000 19:38:04 +1000349_us-ascii Sanjeev,

I'm not too keen on this clause you wrote: "...main culprit was list prefetch which was causing the physical RDS sorting..."

List Prefetch, on its own, is not a bad thing if the entire result set is fetched. The cost of the RID sort is totally insignificant compared to cost of visiting all the qualifying rows. [...] 128 121 33_Re: optimizerrrrr & List Prefetch10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Sat, 8 Apr 2000 14:44:07 GMT550_us-ascii Hi Michael, I wanted to say in case of Kaushal's query ,if the query without Optimize for 1 row was taking more time then ofcourse the reason was RDS sort but in that case RDS sort could only be avoided by disabling list prefetch i.e by adding Optimize for 1 row clause. Otherwise list prefetch is good but do we prefer our online transanction to use any kind of prefetch, if we can get away with few more "Death by Random I/O" and have better response time by having better buffer pool utilization during the peak online hours. But if [...] 250 186 33_Re: optimizerrrrr & List Prefetch14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Sat, 8 Apr 2000 15:13:34 -0400434_iso-8859-1 Sanjeev,

Regarding the opto 1 row versus the list prefetch in Kaushal's query. I cannot remember or find the original but -- if he is processing the entire result set then it is one issue. If he is processing only a part of the qualified rows with opto 1 row, then that is something else. But to simply state that RDS sort should be avoided by using opto 1 row leaves a lot of room for some serious discussion. [...] 437 23 19_Long Running thread14_Gilbert Aquino18_gaquino@GIO.COM.AU30_Sun, 9 Apr 2000 07:33:17 +1000360_us-ascii Hi,

We have a problem in our production DB2 region (DB2 V5) where a batch job was force cancelled last night after running for 6 hours but the thread in DB2 won't terminate. THe thread was also cancelled in DB2 but it has been at least 12 hours since it was cancelled and it is still in 'wait-service' status in DB2. What are our options? [...] 461 146 33_Re: optimizerrrrr & List Prefetch14_Michael Hannan24_mhannan@C031.AONE.NET.AU30_Sun, 9 Apr 2000 09:47:19 +1000502_us-ascii Sanjeev,

Sorry I misinterpreted what you were saying about the the 'physical RDS Sort'. I thought you referred to the RID Sort for some strange reason.

List Prefetch can save I/Os in an online situation because it can get multiple data pages with a single I/O. So its good for onlines also, particularly now that index screening available. Even gets used for very small result sets when an index is updated so that index to be updated can be used as access path index also. [...] 608 144 34_Re: DB2/MVS V4 performance problem10_Leo Flores23_leoflores@EARTHLINK.NET30_Sat, 8 Apr 2000 18:11:55 -0700581_us-ascii Hi Tina,

Let me refer you to these references of the Installation Guide.

http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNIG0D8/2%2e7%2e26

and

http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/BOOKS/DSNIG0D8/2%2e7%2e26%2e1?SHELF=

The 2nd reference mentions the changes to to the default of CURRENTDATA(NO) to (YES) on BINDS. you may want to review you SQL and BIND options and determine if CD should be (YES) or (NO).

Also, have you changed the indexes to TYPE 2 to reduce lock contention and increase througput? [...] 753 42 67_Re: More testing of VPSEQT/HPSEQT as it applies to "LIST PREFETCH "10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Sun, 9 Apr 2000 05:55:36 GMT507_us-ascii Hi all, However this is a news for me but good to get the new thing again .But i am still not clear if the list and dynamic prefetch pages are marked as random when actual getpage is done then why we are saying this "List Prefetch can save I/Os in an online situation because it can get multiple data pages with a single I/O". If it is marked as random but processed sequentially then O.K but why it is done so? . Does it mean actually more I/O is needed in this case than what we think it is [...] 796 264 33_Re: optimizerrrrr & List Prefetch10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Sun, 9 Apr 2000 06:05:56 GMT440_us-ascii Hi Richard, I think your last two paragraph said what i wanted to say : Bottom line is that there is never an ALWAYS approach to these situations, and there are an extremely large number of dependencies. If an entire result set is going to be used, batch or online then: RDS sort is not bad. List prefetch is not bad. Sequential access is not bad. But Death by random I/O is bad. However, random I/O without death is not bad. [...] 1061 176 34_Re: DB2/MVS V4 performance problem24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM30_Sun, 9 Apr 2000 21:14:44 +1000393_iso-8859-1 Tina,

From memory there was a nasty if you have a combination of type 1 indexes and SQL running uncommited read.

I think that the combination of UR and Type 1 indexes forced a tablespace scan instead of using an index. If you have this combination then it could account for your increased cpu usage. I do not think the problem would show up in an explain output. [...] 1238 41 23_Re: Long Running thread12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Sun, 9 Apr 2000 18:09:26 +0200409_x-user-defined Hi, I hope that by the time you get this response your rollback is over. If you have a monitor look for activity of reading from logs (active/archive) this indicates rollback. You can check if any other thread is holding the tables/indexes affected by the batch run.

If the thread is totally hung - no cpu, no i/o, no read from logs - then it looks like you'll have to recycle DB2. [...] 1280 93 67_Re: More testing of VPSEQT/HPSEQT as it applies to "LIST PREFETCH "14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Sun, 9 Apr 2000 12:44:18 -0400622_iso-8859-1 Sanjeev,

The I/O is not in question here as it is asynchronous and multiple pages per I/O. The clarification is on what queues it is stored on, and what are the status of the pages after GETPAGE. All pages retrieved by dynamic prefetch are not necessarily ever the subject of a GETPAGE. Dynamic prefetch can be triggered, and stage many more pages than are ever referenced. For example, a process can be moving through an object, processing data in little sequential chunks, which would trigger dynamic prefetch. Dynamic prefetch starts loading the next set of sequential pages, but the application [...] 1374 67 44_Re: Compatibility of a DB2 (OS/390) program.0_20_gabriele@NZ1.IBM.COM31_Mon, 10 Apr 2000 09:39:43 +1200421_us-ascii Giorgio,

existing applications are always compatible with new DB2 version/release. This means taht if have a program already running in DB2, you don't need to pre-compile, compile, link-edit and bind it again when you upgrade DB2 to a new version/release. However you might have to rebind some or all programs to take advantage of the improvements in the optimizer delivered in each release/version. [...] 1442 18 46_Re: Little DB2, DB2 UNO, DB2 for Elsewhere ...12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 10 Apr 2000 11:15:37 +1200433_us-ascii Following on from Colin's excellent DB2/MM suggestion, how about MS-DB2? Hey, if it worked for DOS...



Raymond Bell DB2 DBA IBM NZ (contracting - but for how long now?)

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1461 281 33_Re: optimizerrrrr & List Prefetch14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Mon, 10 Apr 2000 09:31:27 +1000342_us-ascii From original question: "The difference in the CPU usage between using and not using the optimize option was it was 2 seconds faster while using it for a result set of around 100,000 rows."

If the query was online and only a few rows fetched, I wish Kaushal said so. I would have answered the question quite differently. [...] 1743 34 39_What's the point of STOGROUPS with SMS?12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 10 Apr 2000 11:41:04 +1200600_us-ascii '... If we have ACS routines assigning datasets to disks, why do we need any more DB2 STOGROUPs defined than SYSDEFLT?...'

You don't. Or rather, I also think you don't. I've gone through this site and removed all the non-SYSDEFLT stogroups in all our subsystems, except for a few objects in one of the Production subsystems that have a high availability requirement (don't they all?) which is delaying the change. We've got SYSDEFLT having volumes ('*','*') so we can go multiple-volume if necessary, but we let SMS manage the actual placement of the datasets. Seems to work OK. [...] 1778 26 43_Re: What's the point of STOGROUPS with SMS?12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 10 Apr 2000 11:54:06 +1200529_us-ascii Adrian,

Like your idea of using #TABLE and #INDEX in the volume parm for stogroups. Good thinking. Tried having pairs of stogroups for each application once (one tablespace, one index) which wasn't too bad, but I like the 'cleanliness', if you like, of your suggestion.

It's posts like yours that bring home the value of this list to me. Unbiased, factual, non-confrontational, useful, colourful, tasty, 64-bit, wide screen... Sorry, got carried away there. Just wanted to say thanks for a good idea. [...] 1805 23 37_Re: Loding data in partition of table12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 10 Apr 2000 12:04:16 +1200591_us-ascii Anindita,

Make sure your 'load data' cards specify the partition number in the 'into table' part of the cards, not before. Otherwise you'll lock the whole tablespace during the load (which you're doing). This assumes, of course, that your data is keyed for the partition you're loading.

Hope this helps,



Raymond

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1829 82 44_Re: Finding SYSCOPY transactions in the logs0_29_Greg.Palgrave@BANKWEST.COM.AU31_Mon, 10 Apr 2000 09:16:03 +0800416_us-ascii Carl,

Could you perhaps do a SELECT DBNAME,TSNAME, DSNAME etc from SYSIBM.SYCOPY prior to running the MODIFY? If you are doing a modify AGE(nn) then you could code a where clause with TIMESTAMP older than nn days ago.

Cheers,

Greg Palgrave Database Administration IT Services Bank of Western Australia Ph : (08) 9449-3810 Fax : (08) 9449-3795 eMail : greg.palgrave@bankwest.com.au [...] 1912 112 10_Newsgroups14_Richard Yevich21_ryevich@ATTGLOBAL.NET30_Sun, 9 Apr 2000 20:45:18 -0400740_iso-8859-1 Has anyone ever found or used the newsgroup called: ibm.software.db2.mvs

Thanks, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net DB2 Performance Journal, Quarterly www.YLAssoc.com -- www.DB2-Portal.com





> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Greg.Palgrave@BANKWEST.COM.AU > Sent: Sunday, April 09, 2000 9:16 PM > To: DB2-L@RYCI.COM > Subject: Re: Finding SYSCOPY transactions in the logs > > > Carl, > > Could you perhaps do a SELECT DBNAME,TSNAME, DSNAME etc from SYSIBM.SYCOPY > prior to running the MODIFY? If you are doing a modify AGE(nn) then you > could code a where clause with TIMESTAMP older than nn [...] 2025 80 43_Re: What's the point of STOGROUPS with SMS?15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Mon, 10 Apr 2000 11:57:15 +1000498_iso-8859-1 Well, the point is to have your cake and eat it too.

We don't care where the vast majority of our DB2 datasets went but we did care where we put the 1% of the datasets that account for 60% of all IO went.

What we had found was that when several of these high usage datasets ended up on the same volume, then response time would go to pot (due to IOSQ times) . Rather than let this happen and then move them we had a look at out IO patterns and then did the following: [...] 2106 94 43_Re: What's the point of STOGROUPS with SMS?0_14_DPetro@AOL.COM28_Sun, 9 Apr 2000 22:25:50 EDT488_US-ASCII Richard,

What version of DB2? I am interested in the PTF you mentioned as well as the presentation.

Thanks very much, Dave.



In a message dated 04/09/2000 10:00:13 PM Eastern Daylight Time, rsimpson@MACQUARIE.COM.AU writes:

<< Well, the point is to have your cake and eat it too.

We don't care where the vast majority of our DB2 datasets went but we did care where we put the 1% of the datasets that account for 60% of all IO went. [...] 2201 128 43_Re: What's the point of STOGROUPS with SMS?15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Mon, 10 Apr 2000 12:50:20 +1000538_iso-8859-1 Was V4, now V5

Here is what I have on this PTF ... (From my IBM GSA DB2 Sprog) ... Following on from our discussion yesterday regarding the problem with >2Gb dsets and that they won't extend properly when using the SMS classes with the Guaranteed Space option which is part of you DASD mgmt strategy. I did some investgation on this topic - many other people complained about it as well - it seems that there is now a PTF fix for it OW38997 (9908). I don't know if you still can access viewblue but there is a long [...] 2330 57 32_Re: REXX & DSNWLIR - It works !!14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 10 Apr 2000 15:50:06 +1000483_iso-8859-1 ....

I think I'll settle for your help when the situation is reversed.

James -----Original Message----- From: Massimo Scarpa [mailto:mscarpa@CESVE.IT] Sent: Friday, April 07, 2000 7:24 PM To: DB2-L@RYCI.COM Subject: Re: REXX & DSNWLIR - It works !!



Hi James,

IT WORKS !!!

I read many times that DSNWLI2 has an entry point in CAF (so creating a connection), but, [...] 2388 33 27_DB2 Erly code compatibility0_20_gabriele@NZ1.IBM.COM31_Mon, 10 Apr 2000 17:58:52 +1200348_us-ascii Hello,

I am working on a triple jump DB2 for MVS V3 to DB2 UDB for OS/390 V6 and I was wondering if I can reduce the number of IPL upgrading the Erly code just once. This means running V3, V4 and V5 with the V6 erly code.

I know that's not a problem for V5 but cannot find any clear statement for the previous versions. [...] 2422 148 14_Re: Newsgroups19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Mon, 10 Apr 2000 02:20:04 -0400461_iso-8859-1 Point your news reader to news://news.software.ibm.com/ibm.software.db2.mvs

A pointer to this is located at http://www-.ibm.com/software/data/db2/os390/support.html There's also newsgroups for each of the platforms DB2 UDB supports.

The best thing to do is add the IBM news server news://news.software.ibm.com to the list of news servers in your news reader.

There all kinds of IBM oriented newsgroups on their news server. [...] 2571 101 36_Re: DB2 Capacity Planning - M-Values14_Adrian Collett27_adriancollett@TISCALINET.IT31_Mon, 10 Apr 2000 10:20:36 +0200523_iso-8859-1 Gabriele, The two pints are yours !! Thanks a lot.

Isaac, Sorry, but I was after the M-Value.

Adrian.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of gabriele@NZ1.IBM.COM Sent: 07 April 2000 03:06 To: DB2-L@RYCI.COM Subject: Re: DB2 Capacity Planning - M-Values

Adrian,

M-Value for 9672-Y86 is 39513

the full record for the model: Model 9672-Y86 #CPs 8 M-Value 39513 MIPS 926 MIPS per CP 115.8 DASD I/O rate 3698 [...] 2673 63 43_Re: What's the point of STOGROUPS with SMS?13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 10 Apr 2000 09:55:07 +0100617_us-ascii

Thanks for the compliment - the money's in the post :-)

Adrian





|--------+-----------------------> | | Raymond Bell | | | | | | | | | 10/04/00 | | | 00:54 | | | Please | | | respond to | | | DB2 Data Base| | | Discussion | | | List | | | | |--------+-----------------------> >---------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Adrian Savory/ZI/England/Zurich) | | Subject: Re: What's the point of STOGROUPS | | with SMS? | >---------------------------------------------------------| [...] 2737 93 44_Re: Java Stored Proc - NullPointerException?14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Mon, 10 Apr 2000 09:59:27 +0100368_- Hi Chris.

Can't help too much with the first question, I'm afraid. I know that the remote debugger is part of VisualAge, and must run on the same platform as the DB2 server that's running the SP. For OS/390 (the environment I've had most experience with), this is part of Enterprise Toolkit component of VisualAge for Java Enterprise Edition for OS/390. [...] 2831 92 43_Re: What's the point of STOGROUPS with SMS?0_19_mike.holmans@BT.COM31_Mon, 10 Apr 2000 11:45:50 +0100614_iso-8859-1 -----Original Message----- From: Joel Goldstein [SMTP:joel_goldstein@COMPUSERVE.COM] Sent: Friday, April 07, 2000 9:58 PM To: DB2-L@RYCI.COM Subject: Re: What's the point of STOGROUPS with SMS?

Dataset placement still DOES matter. DASD performance in most installations is a mess at best , and yes, there are some that have good performance - but not when it has all been given to SMS. I know this will will flame the debate again - and I again, I say that I will be happy to change my opinion when someone sends me RMF data that will prove they are getting good performance when everything [...] 2924 147 11_Re: DR step9_jim.szabo22_jim.szabo@MCIWORLD.COM30_Sun, 9 Apr 2000 16:14:29 -0400339_iso-8859-1 DB2 for OS/390

One reason to possibly go out of ACCESS(MAINT) mode is to use third-party recovery utilities.

We were using an enhanced RECOVERY tool by a third-party vendor, and it could not be used under ACCESS(MAINT) - did nasty overlays of memory that necessitated not just a subsystem bounce, but an IPL. [...] 3072 138 43_Re: What's the point of STOGROUPS with SMS?13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 10 Apr 2000 12:38:28 +0100590_us-ascii Mike,

I think we're all agreed that dataset placement does matter, it's the method of how to to administer the placement of datasets that's up for debate i.e. 'by hand', or using SMS ACS routines, etc. I must admit I'm leaning more and more towards the SMS approach, because from a selfish point-of-view it's less hassle for me. Also I don't see it as abdicating responsibilty, but rather delegating responsibility to the people who I see should be responsible - the storage management team. If they're not up to the job or are not willing to co-operate with the DBA's [...] 3211 141 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)0_19_mike.holmans@BT.COM31_Mon, 10 Apr 2000 12:31:17 +0100388_iso-8859-1 Adrian,

The idea of passing the #TABLE/#INDEX is indeed neat, so thanks for passing that on.

But the question which occurred to me on reading your post was "why does anyone want to use multiple VCATs for the DB2 data?"

I'm sure there are some excellent reasons for doing it, but they've never impinged on us in our part of the swamp (that I know of). [...] 3353 24 21_DB2 Forms Experiences15_Jeffery A Price17_jprice@IPALCO.COM31_Mon, 10 Apr 2000 06:56:06 -0500399_us-ascii Hello All,

I was wondering if anyone could share some experiences with DB2 forms. Does anybody use it in production? If so, how do you use it? If I understand correctly, you can store applet on a server, and the forms are stored in DB2. When somebody points to the webpage, the applet downloads, and then retrieves the forms from DB2. Any comments would be greatly appreciated. [...] 3378 25 19_Longer column names19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Apr 2000 06:57:07 -0500601_iso-8859-1 Hi all, Does anyone know when or if longer column names, I've heard they will be increased to 30 bytes, will be introduced?

TIA, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, [...] 3404 23 38_ERWin Support for DB2 UDB for OS390 V619_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Apr 2000 06:59:21 -0500610_iso-8859-1 Hi all, Has anyone heard when ERWin will be upgraded to handle V6 for OS390? TIA, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail [...] 3428 56 23_Re: Longer column names14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 10 Apr 2000 07:11:30 -0400700_iso-8859-1 On the OS/390, according to presentations by Roger, after the next release/version maybe. In other words, not in the version after V6 but later.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net DB2 Performance Journal, Quarterly www.YLAssoc.com -- www.DB2-Portal.com





> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > DAVIS, RICK (SBCSI) > Sent: Monday, April 10, 2000 7:57 AM > To: DB2-L@RYCI.COM > Subject: Longer column names > > > Hi all, > Does anyone know when or if longer column names, I've heard they > will be increased to 30 bytes, will be introduced? > [...] 3485 107 43_Re: What's the point of STOGROUPS with SMS?11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 10 Apr 2000 08:38:00 -0400562_ISO-8859-1 Richard

Sounds very interesting. Could you please send me a copy of your presentation, or maybe you could post it to DB2-L-DOCUMENTS?

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner

Message text written by DB2 Data Base Discussion List >Well, the point is to have your cake and eat it too.

We don't care where the vast majority of our DB2 datasets went but we did care where we put the 1% of the datasets that account for 60% of all IO went. [...] 3593 193 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 10 Apr 2000 13:42:03 +0100452_us-ascii Mike,

Some sites I have worked for like to have a seperate VCAT for each DB2 application. I've got no strong opinion on this but I guess it gives you a greater level of granularity e.g. the storage people can answer questions like 'How much space is application x taking?' or 'How much has application y grown in the last 6 months?'. For critical applications I suppose it would also be easier to give them preferential treatment. [...] 3787 93 10_INDEX Keys10_ajay kumar19_db2v5r1@HOTMAIL.COM29_Mon, 10 Apr 2000 18:24:17 IST318_- Hi,

I have a small doubt, Is it good to have a table's field the same sequence of Index keys.

For example option 1: I have created a table with fileds A1,B1,C1,D1 and created unique index as C1 and D1. Is this is good ? option 2 : Instead creating table C1,D1,A1,B1 and have index keys C1 and D1. [...] 3881 135 14_Re: INDEX Keys10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Mon, 10 Apr 2000 13:18:08 GMT533_us-ascii Hi karthik, First of all page is or pages are processed by an I/O not the row/column and a page has to contain all the columns (either in 4K or 32K).Sequential prefetch is not dependent on how much columns or rows your page contains.However, it depends on page size i.e 4K or 32K(8 x 4K) . If you are talking about sequential prefetch on Index pages ,As it contains C1 and D1 only then prefetch will be done on index pages, which will give you what it contains.If at all any kind of prefetch will be done on data pages [...] 4017 127 12_DB2 rowcount18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 10 Apr 2000 09:03:30 -0400345_iso-8859-1 I've got a question I'd like to post out here that deals with DB2/QMF. (I'm a DB2/DBA and really know very little about Oracle but I'll use an Oracle example or what I know about it).

In Oracle I understand that you could write a SQL stmt like: SELECT ROWCOUNT, EMPLOYEE_NUMBER, DEPT FROM ABC.TABLENAME WHERE ROWCOUNT < 6 [...] 4145 48 26_Naming conventions for DB217_Sejal Champaneria30_Sejal.Champaneria@RICH.FRB.ORG31_Mon, 10 Apr 2000 09:18:08 -0400370_US-ASCII So far the following suggestions by Ray Potts were the best in my opinion. Very simple - to the point, concise and leaving no room for doubts and very professional as well.

===================BY RAY POTTS============ Since they are all supposed to be the DB2 Universal Database Family, how about either:

DB2/390 DB2/NT DB2/Unix DB2/Sol ,etc. [...] 4194 19 44_Re: Compatibility of a DB2 (OS/390) program.17_Giorgio De Nunzio25_giorgio.denunzio@UNILE.IT31_Mon, 10 Apr 2000 15:50:11 +0200460_us-ascii >existing applications are always compatible with new DB2 version/release.

Thanks Gabriele (Italian name; are you Italian or of Italian origin?). This completely answers my question!

Ciao Giorgio

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4214 64 43_Re: What's the point of STOGROUPS with SMS?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Apr 2000 15:40:46 +0200548_us-ascii When I was younger I worked as DASD administrator, I learned many things about SMS so now I can view the problem from the point of view of DASD and DB2 Admin.

I used SMS from a long time and I still enjoy of it, expecially with a wise dataset standard naming (it's fundamental), but and I agree with Joel, dataset placement is still important, expecially if you aren't able to change a SQL you bought from a 3rd party. In this case IT'S important to execute 1000000000000 I/O to satisfy a bad access and make the client happy. [...] 4279 199 16_Re: DB2 rowcount11_Mayo Arthur19_Arthur.Mayo@IRS.GOV31_Mon, 10 Apr 2000 09:47:31 -0400476_iso-8859-1 Steve,

If all you want is the first 6 of any given table with a column heading of 'Rowcount' do the following in QMF:

SELECT column name AS ROWCOUNT FROM table1 A WHERE 6 > (SELECT COUNT(*) FROM table1 b WHERE A.column name < b.column name)

Hope this helps.



-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Monday, April 10, 2000 9:04 AM To: DB2-L@RYCI.COM Subject: DB2 rowcount [...] 4479 11 17_UNSUBSCRIBE DB2 L18_McDowell, Scott M.19_SMMcDowell@WEST.COM31_Mon, 10 Apr 2000 08:49:32 -0500253_iso-8859-1

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4491 33 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Apr 2000 15:51:40 +0200404_us-ascii There are other reason, as using the 1st qualifier to identify macro applications and for

accounting (I don't know how it works, but I know that this happens), to spread names among

many ICF catalogs ( I heard some sysprog had problems with catalog with only a VCAT), for a

better granularity in DASD placement (it less simple but it's ok for some sites), to have some [...] 4525 71 33_Re: Time consuming load processes14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Mon, 10 Apr 2000 10:24:19 -0400473_us-ascii Hello Kartik,

From your note "2) Transfer file from production to test" - Does this mean that you are dealing with separate LPAR's ? = If this is the case then you could just Mirror the production subsystem on the test LPAR - by stopping the Prod ssid and copying everything on the prod LPAR (using DFDSS) and "transferring" the copies to the test LPAR. Start the test ssid and you are have a copy of prod at the point of the stop. Just a thought .... [...] 4597 60 44_Re: Finding SYSCOPY transactions in the logs19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Apr 2000 09:27:31 -0500566_iso-8859-1 Carl, Are you using the IBM MODIFY utility? IBM's MODIFY use to list all the SYSCOPY rows it deleted. If you're not using IBM's, perhaps there is an option you could turn on to do it.

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at [...] 4658 118 43_Re: What's the point of STOGROUPS with SMS?0_19_Tim.Lowe@STPAUL.COM31_Mon, 10 Apr 2000 09:36:38 -0500573_us-ascii In my opinion, I think it is shameless that packages with poor SQL seem to thrive without addressing their performance problems. In that light, I sometimes wish that nobody would try to "help" their poor SQL by working on DASD or bufferpool performance. I would like to see all "crummy sql" in application packages get noticed, and fixed for all of their customers, or to see them go out of business! Many times, I have been asked to improve performance for an application package, only to find that the SQL in the package needs to be changed, and nobody can [...] 4777 46 43_Re: DB2 Dual Logging to Single logging mode19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 10 Apr 2000 09:54:58 -0500592_iso-8859-1 Srini, Why stop dual logging? Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 4824 28 43_Re: What's the point of STOGROUPS with SMS?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Apr 2000 16:58:02 +0200544_us-ascii It's shamelless, but it happens and very often too, as I can see in db2-l and as I can hear from many and many DB2 collegues & fellows. It's the real life, not a white test lab (but tests are verry useful, it's clear and obvious !!!!). You know......

As a free choice or imposition it happens, and often it's YOUR fault if the product doesn't work, as the sales people said: 'It's simply GREAT. We have 100000000000 installation all over the world and it works GREAT. And the add a 99% discount in price list' . How can we [...] 4853 21 43_Re: DB2 Dual Logging to Single logging mode14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 10 Apr 2000 17:03:05 +0200474_us-ascii Why can't you use dual logging with ONE archive log only ?

Just yesterday we lost a SPARE DASD and another SPARE was not so good..... Are you so

reckless ? If so I envy you !!!

Regards

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4875 95 35_Re: Documentation for TCP/IP errors0_14_dcreed@CSC.COM31_Mon, 10 Apr 2000 10:07:38 -0500688_us-ascii I have always had trouble finding these as well.

I think depending on, they are located in several different books. 1) Application Development Reference: Assembler Callable Services for OpenEdition MVS

Basically the rc=140 says The pipe is broken. (lots of help huh)

There is an Information item " APAR Identifier ...... II11670 Last Changed ........ 99/04/22 MSGDSNL511I RC=140 for TCP PIPE BROKEN or RC=1121 CONNECTION RESET by PEER. APPLICATION RECEIVED ABEND04E RC00E50013 ..... .... Workstation support reviewed the DB2TRC trace and confirmed this is reset by exceeding the timeout limit. The customer found out this problem correlates to the ODBC [...] 4971 173 16_Re: DB2 rowcount14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 11 Apr 2000 01:28:26 +1000287_us-ascii Arthur,

Try your SQL on a 1 million row table and tell me how it performed. Also how does renaming a column as ROWCOUNT help? Remember orginal question said ROWCOUNT has to be < 6 in every row. Your query appears to get up to 6 rows of highest 'column name' values. [...] 5145 185 44_Re: Compatibility of a DB2 (OS/390) program.10_Bill Disch23_bill.disch@GENMILLS.COM31_Mon, 10 Apr 2000 10:34:55 -0500583_iso-8859-1 Giorgio,

You should not have a problem. We are currently running DB2 V5 on OS/390 V1.2 and CICS 4.1. There are still batch and CICS COBOL programs executing on a daily basis which were precompiled, compiled on DB2 V1.3, MVS/XA, CICS 1.7 and who knows what other obsolete versions of software. The DB2 PLANs usually went through a REBIND 6 months to a year after a DB2 upgrade following the REORG and RUNSTATS under the new version. The REBIND uses the SQL in the DB2 Catalog rather than the DBRM which is fortunate because some of our DBRMs have "disappeared" [...] 5331 28 34_RBA/LRSN and timestamp translation0_21_jsumarroca@LACAIXA.ES31_Mon, 10 Apr 2000 17:41:25 +0100368_us-ascii How can I get the timestamp associated for a given RBA (and LRSN for data sharing)?

And the RBA/LRSN of a given timestamp?

I need it for our Disaster Recovery site, since we have to syncronize several DBMS to a common point: IMS (which only understands timestamps) and DB2 (only understands RBA/LRSN), and a common "languaje" is requiered. [...] 5360 18 44_Re: Compatibility of a DB2 (OS/390) program.17_Giorgio De Nunzio25_giorgio.denunzio@UNILE.IT31_Mon, 10 Apr 2000 18:11:37 +0200375_us-ascii Thanks Bill, for your reply, and for the other details you directly sent to my e-mail address!

Good work Ciao Giorgio

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5379 47 13_quiesce locks13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Mon, 10 Apr 2000 11:55:55 -0400318_us-ascii I am running db2 udb v6.1 on solaris... I was loading a table using the control center. Did not have load restart The job was cancelled before ending and the tablespace is now in quiesce exclusive. I tried to run the quiesce reset but to no avail, system will not accept any quiesce.. any suggestions...thanks 5427 98 33_Re: Time consuming load processes11_Kwan, James18_James_Kwan@BMC.COM31_Mon, 10 Apr 2000 10:56:53 -0500350_ISO-8859-1 Kartik,

If you are loading a very large table with only few updates per week, then using the incremental image copy may be best for you. However you require to have a third party tool such as BMC UNLOAD PLUS or other vendor unload products to do that.



James Kwan





Kartik Subramanian wrote: [...] 5526 144 14_Re: INDEX Keys0_19_mike.holmans@BT.COM31_Mon, 10 Apr 2000 14:57:54 +0100428_iso-8859-1 The physical order of rows in the table is determined by which index is defined as the clustering index. The order in which the columns appear in the table rows is irrelevant. In your example, if you create the index (C1,D1) with the attribute CLUSTER, and REORG the data (on a regular basis), it won't matter where in the row these columns occur if all you are concerned about is sequential access performance. [...] 5671 61 38_Re: RBA/LRSN and timestamp translation20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 10 Apr 2000 12:03:19 -0400416_us-ascii Unfortunately RBA, as the name suggests, is relative byte address and there is no easy conversion to timestamp. It is because, the log activity varies from time to time. But a rough way to get approximate time is to use any of the following -

- REPORT RECOVERY utility - Browse through SYSCOPY records - LOG analyzer - DSNJU003 or - any other unofficial method in which you could read SYSLGRNGX [...] 5733 58 16_Re: DB2 rowcount0_19_mike.holmans@BT.COM31_Mon, 10 Apr 2000 16:59:11 +0100368_- I know nothing at all worthwhile about Oracle SQL syntax, but it looks to me as though this could be written for DB2/390 V5 as:

SELECT COUNT(*) AS ROWCOUNT, EMPLOYEE_NUMBER, DEPT FROM abc.tablename GROUP BY EMPLOYEE_NUMBER, DEPT HAVING COUNT(*) < 6

Of course, if I haven't understood what Steve was trying to do, that won't be the right solution. [...] 5792 32 35_Move Catalog & Boot Strap Datasets.16_Pantazis Pantazi20_zakis@CYTANET.COM.CY31_Mon, 10 Apr 2000 19:15:30 +0300314_us-ascii Hi,

We are using DB2 V4 for OS390 and we are facing a small problem. We are using three subsystems of DB2 and since now there was no problem but recently due to house keeping we have found out that the disks that the DB2 catalog and Boot Strap Datasets reside are used by other files as well. [...] 5825 17 38_Experiencing shortages on subpool 241.11_Brian Lynch27_BLynch@GRPWISE-EAST.TRW.COM31_Mon, 10 Apr 2000 12:36:27 -0400414_US-ASCII We are Experiencing shortages on subpool 241. We are running OS/390 2.5 DB2 v5.1 PUT level 9805 with bunches of maintenance.

Anybody else having this problem?

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5843 67 17_Re: optimizerrrrr16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Mon, 10 Apr 2000 09:54:28 -0700361_iso-8859-1 If DB2 expects 1 row, then there is nothing to prefetch and nothing to sort. When it actually accesses the data, it will do what is necessary, but the explain is based on the SQL's assertion that it should optimize for 1 row.

Tony Provenzola BEST Consulting * Phone: (503) 532-0772 * Fax: (503) 532-2618 * Email: Tony.Provenzola@nike.com [...] 5911 39 42_Re: Experiencing shortages on subpool 241.17_Linda F. Claussen18_lindafc@NETINS.NET31_Mon, 10 Apr 2000 12:04:01 -0500571_ISO-8859-1 Brian,

Check out Info. Apar # II04309. It's where I start looking when I have Storage Problems.

Linda F. Claussen Claussen & Associates, Inc DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/



---------- From: Brian Lynch To: DB2-L@RYCI.COM Subject: Experiencing shortages on subpool 241. Date: Monday, April 10, 2000 11:36 AM

We are Experiencing shortages on subpool 241. We are running OS/390 2.5 DB2 v5.1 PUT level 9805 with bunches of maintenance. [...] 5951 24 16_Re: DB2 rowcount13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 10 Apr 2000 13:14:12 -0400350_iso-8859-1 I believe what Stephen is looking for is what is called RowNum in Oracle. "RowNum is another of the pseudocolumns and is the number of each row counted as it is retrieved from the database; that is, whenyou execute a select, the first row returned is given the RowNum of 1, ..." from ORACLE 8: The Complete Reference -- Oracle Press. [...] 5976 115 16_Re: DB2 rowcount11_Mayo Arthur19_Arthur.Mayo@IRS.GOV31_Mon, 10 Apr 2000 13:13:44 -0400609_iso-8859-1 Not available on the Mainframe. I believe it's available in DB2 UDB V6.

-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Monday, April 10, 2000 1:14 PM To: DB2-L@RYCI.COM Subject: Re: DB2 rowcount



I believe what Stephen is looking for is what is called RowNum in Oracle. "RowNum is another of the pseudocolumns and is the number of each row counted as it is retrieved from the database; that is, whenyou execute a select, the first row returned is given the RowNum of 1, ..." from ORACLE 8: The Complete Reference -- Oracle Press. [...] 6092 80 39_Re: Move Catalog & Boot Strap Datasets.50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Mon, 10 Apr 2000 13:15:44 -0400520_- Get the definitions from the DB2.Version.???.samplib of the BSDS,

they look similiar to this :::



//STEP01 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSIN DD * DELETE DBTWOS5.BKBK01 DEFINE CLUSTER - ( NAME(DBTWOS5.BKBK01) - VOLUMES(DB2501) - REUSE - SHAREOPTIONS(2 3) ) - DATA - ( NAME(DBTWOS5.BKBK01.DATA) - RECORDS(160 20) - RECORDSIZE(4089 4089) - CONTROLINTERVALSIZE(4096) - FREESPACE(0 20) - KEYS(4 0) ) - INDEX - ( NAME(DBTWOS5.BKBK01.INDEX) - RECORDS(5 5) - CONTROLINTERVALSIZE(1024) ) [...] 6173 37 17_Re: RCT questions7_Dave R.19_daver1212@YAHOO.COM31_Mon, 10 Apr 2000 10:09:29 -0700450_us-ascii

I hoped someone else would also post in regard to your question. The performance enhancements in CICS 4.1 and MVS 5.1 (both of which you're beyond) essentially eliminate the thrashing that would occur if you had too many threads in one CICS region. The main limitation now is total number of threads in a single DB2 subsystem (member for those in data sharing) and the amount of available storage in the particular CICS region. [...] 6211 15 39_Re: Move Catalog & Boot Strap Datasets.25_Edward(Ed) J. Finnell,III23_efinnell@SEEBECK.UA.EDU31_Mon, 10 Apr 2000 12:30:47 -0500389_us-ascii You won't get very far with IEBCOPY(PDS's). I've used FDR and DF/DSS to move BOOTSTRAP and Catalogs. The associated DB/2 SSI must be down.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6227 215 16_Re: DB2 rowcount18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 10 Apr 2000 13:17:11 -0400549_iso-8859-1 Dave: That is 'it'. Sorry I thought it was Rowcount but you are probably right that it is RowNum. I saw this work once in Oracle and thought we might be able to do the same thing here. The results I saw from Oracle were something like this:

RowNum Employee Number 1 123456 2 345689 3 555555 4 667666 5 389793 etc....Then I guess you can do there 'where' clause on the 'RowNum' and limit the number of results. Sounds like we can't, at least at this point. I appreciate all who responded and sorry about the column name mixup. [...] 6443 174 28_DB2 Idle Thread timeout parm18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Mon, 10 Apr 2000 12:57:23 -0400554_iso-8859-1 Need some support here. When I brought in DB2 Connect to our company here last year we had the default value of this 'idle thread timeout' set to '0'. Not good, cause it can leave the threads out there forever and tie up resources. So into the IBM manuals I go to get some help. After doing indepth reading I changed the 'idle thread timeout' value to 300 seconds (5 mins) and DDF Threads (CMTSTAT) value to 'Inactive'. I figured; heck after 5 minutes if you haven't communicated with DB2 then you must be done or there's a problem. Also [...] 6618 173 73_Re: Cancelling threads asynchronously - is there a way to do it in batch?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Mon, 10 Apr 2000 12:53:43 -0500356_us-ascii Many thanks to Lyon, Bing, Craig and Michael for their suggestions. While some of the ideas had possibilities, none quite fit the bill (for various reasons),

This week our DBA Advisor came up with the solution on how to generate stops asynchronously and it worked like a charm so I thought I'd share it with you along with a question. [...] 6792 44 24_Load Design & Strategies7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Mon, 10 Apr 2000 13:05:34 -0500432_- Hello everyone,

The database system I am designing (on UDB EEE) involves a great amount of LOADing of data from flat files on an annual, weekly, and daily basis. The database is normalized to the 3NF. Therefore, in most cases a row of a flat file will be translated into 2 to 3 rows of physical tables. Performance is an issue for us as these tables will hold up to 1B rows. The row lengths are normally short though. [...] 6837 195 16_Re: DB2 rowcount16_Daniel Boulanger19_dboulang@CA.IBM.COM31_Mon, 10 Apr 2000 10:20:30 -0400336_us-ascii



Hi there,

In such case, can we use a similar approach to extract the 2 last entries of a given table or sub-query ?

Let says for instance I want to have the timestamp of the 2 last most recent reorgs that were performed on any given object in DB2, how would I need to code my SQL statement ? [...] 7033 17 37_Anyone using Query Patroller on AIX ?0_25_Pierre.Evans@AUTOZONE.COM31_Mon, 10 Apr 2000 13:25:59 -0500323_us-ascii Has anyone gotten Query Patroller to work with UDB v6.1 on Aix ? I'm curious if I'm the only one experiencing problems with being able to submit queries to QP. Fixpack 3 includes an APAR which should solve a problem with the server starting, but after applying it i'm still getting nowhere... Regards, Pierre [...] 7051 87 16_Re: DB2 rowcount13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Mon, 10 Apr 2000 13:29:43 -0500519_iso-8859-1 One option I'll toss out since the initial question mentioned QMF -- You can tell QMF to limit the number of rows returned by using "ROWLIMIT". Ex -- "RUN QUERY (ROWLIMIT=5)". By using this QMF will only fetch 5 rows. There is also a "&ROW" expression that can be used in QMF forms (as part of form.calc, along with form.detail), which is defined as "the row number of the data evaluated in the expression". This would give you the a sequence number for each row that is returned (for what it's worth). [...] 7139 47 39_Re: Move Catalog & Boot Strap Datasets.16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Mon, 10 Apr 2000 11:38:42 -0700582_- Check the Utility Guide under DSNJU003 and follow the steps for enlarging the datasets. You will follow the same procedure except you won't be enlarging the datasets (unless you want to do that at the same time).

Duane

> -----Original Message----- > From: Pantazis Pantazi [SMTP:zakis@CYTANET.COM.CY] > Sent: Monday, April 10, 2000 9:15 AM > To: DB2-L@RYCI.COM > Subject: Move Catalog & Boot Strap Datasets. > > Hi, > > We are using DB2 V4 for OS390 and we are facing a small problem. > We are using three subsystems of DB2 and since now there was no > problem [...] 7187 16 13_RRS-Interface16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Mon, 10 Apr 2000 21:05:53 +0200350_- Who use DB2RLI (RRSAG-attachment)? We found some restrictions and I want to know who use it.

Roland

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7204 56 39_Re: Move Catalog & Boot Strap Datasets.12_Bing Alabata25_bing.alabata@MCMASTER.COM31_Mon, 10 Apr 2000 14:20:17 -0500511_us-ascii Hi Pantazis,

You can use any DASD facility for the moves such as FDR or DFDSS. In fact, you can use IDCAMS DELETE/DEFINE cluster statements. DB2 looks for only the BSDS and log "dataset names" in the ICF catalog regardless of volume placement.

Just remember to update the DSNTIDxx member of DSN410.SDSNSAMP with the right VOLSDATx values. Come migration to DB2 V5, your tailored jobs will point to the correct volumes when you specify the updated DSNTIDxx in the installation panel. [...] 7261 70 31_Re: DB2 Erly code compatibility38_Enarson, Mike (CC-Application Support)24_Mike.Enarson@CONAGRA.COM31_Mon, 10 Apr 2000 14:50:22 -0500347_iso-8859-1 Hi Gabriele. I upgraded from V 3.1 to V 5.1 on a few systems when we went to DB2 V5 and based on what IBM told us 2 years ago what you plan will not quite work.

IBM at the time said that a DB2 only supports the next version or prior version of the ERLY code. So that V3.1 and V4.1 would probably not work with V6 ERLY code. [...] 7332 231 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)12_Kirk Hampton16_khampto1@TXU.COM31_Mon, 10 Apr 2000 16:43:32 -0500626_us-ascii Mike, at our site we use multiple VCATs to logically separate datasets where we have multiple Test "Environments" or different test levels of the same tablespaces that exist within the same DB2 subsystem. This is basically redundant, since the tablespace names also contain an "environment" character to distinguish them.

In our production subsystems, we still have many of our original pre-SMS STOGROUPS, which now all point to volume '*'. But we are slowly moving toward having only one, as Richard Simpson described in his reply, to handle the 99% of tablespaces for which we let SMS do its own thing. [...] 7564 63 37_Job apparently hung or looping in DB215_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Mon, 10 Apr 2000 14:07:08 -0800572_iso-8859-1 DB2 V4.1 - MVS We have a batch job that occasionally seems to get hung up in DB2. The symptoms are: in Omegamon the All threads connected to DB2 screen the job says In-SQL-Call and is getting CPU percent but the GetPg, Update, & Commit counts aren't changing. When zoomed the on-call person could see that the program was staying on the same SQL call and not changing. The job started at 21:51, was cancelled at 23:57, then restarted and ran to completion with no other corrective action taken and no further problems encountered. This was also the fix in [...] 7628 26 23_SQL Procedures Pre-reqs17_Belfield, Alma G.15_AGBELFI@TWA.COM31_Mon, 10 Apr 2000 16:57:52 -0500649_iso-8859-1 Can someone confirm whether a C compiler is a pre-requisite for SQL Procedures language with DB2 for OS/290 V5?

The following statement appears in the 'readme' text on the web site (start at http://www.software.ibm.com/software/data/db2/os390/spb/exciting/ and work your way from there): ATTENTION: The IBM C/C++ for OS/390 optional feature must be installed before you can use SQL Procedures support for DB2 for OS/390. Is it possible to generate the SQL Procedures programs into any language other than C? e.g. COBOL or PL/I? I suspect not. I haven't seen anything in the doco to indicate that it is possible, but I thought [...] 7655 47 27_Re: SQL Procedures Pre-reqs38_Enarson, Mike (CC-Application Support)24_Mike.Enarson@CONAGRA.COM31_Mon, 10 Apr 2000 17:19:27 -0500447_iso-8859-1 If you are referring to DB2 Stored Procedures for DB2 V5 then the answer is no unless they are written in C. LE/370 is a requirement thou. The few stored procedures we have written in version 5, we have used COBOL for MVS.

Regards Mike Enarson



-----Original Message----- From: Belfield, Alma G. [mailto:AGBELFI@TWA.COM] Sent: Monday, April 10, 2000 4:58 PM To: DB2-L@RYCI.COM Subject: SQL Procedures Pre-reqs [...] 7703 51 27_Re: SQL Procedures Pre-reqs17_Linda F. Claussen18_lindafc@NETINS.NET31_Mon, 10 Apr 2000 17:51:37 -0500422_ISO-8859-1 To use the new SQL Procedure language you must have a C compiler. The CREATE PROCEDURE ... LANGUAGE SQL is converted into a C program and is then prep'd like any other Stored Procedure.

Until you have implemented the support you cannot use the LANGUAGE SQL.

Linda F. Claussen Claussen & Associates, Inc DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ [...] 7755 182 141_Repost: DB2 Certification Preparation 1-Day Class (was REMINDER: IDUG No. American Conference - Discounted Early Registration Until April 14)13_Morrill, John12_JohnM@VP.NET31_Mon, 10 Apr 2000 18:28:16 -0600723_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

A special DB2 certification preparation seminar is being offered on Sunday, May 13 prior to this year's IDUG North American conference (May 14-17 in Dallas...see bulletin previously sent to you below). The seminar compliments the free DB2 certification available again this year at IDUG. A copy of the DB2 UDB [...] 7938 91 41_Re: Job apparently hung or looping in DB211_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Tue, 11 Apr 2000 08:29:14 +0800745_us-ascii Hi Mitchell, Could you provide the accounting detail report for this particular Job. (please turn on accounting trace class 1,2,3).









"Mitchell, Sandi" on 11/04/2000 06:07:08 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: ROLAND CHUA CHONG KEE/DATACEN/IT/SGX) Subject: Job apparently hung or looping in DB2







DB2 V4.1 - MVS We have a batch job that occasionally seems to get hung up in DB2. The symptoms are: in Omegamon the All threads connected to DB2 screen the job says In-SQL-Call and is getting CPU percent but the GetPg, Update, & Commit counts aren't changing. [...] 8030 55 38_Re: RBA/LRSN and timestamp translation14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 11 Apr 2000 11:12:48 +1000459_iso-8859-1 Jordi,

Use DSN1LOGP to print the block containing the log record at the RBA. The time it was generated will be reported.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: jsumarroca@LACAIXA.ES [mailto:jsumarroca@LACAIXA.ES] Sent: Tuesday, April 11, 2000 2:41 AM To: DB2-L@RYCI.COM Subject: RBA/LRSN and timestamp translation [...] 8086 26 56_Re: DB2-L Digest - 9 Apr 2000 to 10 Apr 2000 (#2000-105)0_16_JJaiwant@AOL.COM29_Mon, 10 Apr 2000 21:41:42 EDT589_US-ASCII Richard, I was very interested by your post on the List server with regard to the SMS managed datasets. I would very much appreciate a copy of your presentation on the same that you are referring to in your post. We are contemplating moving to SMS, and I was concerned about our large datasets accessed most frequently. I had analyzed SMF42-6 records to identify some usage characteristics in the present scheme of things and am unsure how SMS would manage those datasets. The argument is strongly in favour of SMS because of the "logical placement" of datasets and the RAID [...] 8113 26 27_Re: SQL Procedures Pre-reqs13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 10 Apr 2000 23:19:21 -0400546_iso-8859-1 Hi Mike,

Alma's question was about the new SQL Procedures language aka PSM -- an equivalent to the pl-sql language in Oracle (or T-sql in Sybase, I think). This is not the same as Stored Procedures. You're correct--Stored Procedures can be written in several languages).

And as Linda states, PSM(at least as far as announced thus far) generates C code and you do need a C compiler. I've seen some information that says you specifically need the IBM LE C, but I can't find that at the moment, so I might be mistaken. [...] 8140 94 17_Re: quiesce locks11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Tue, 11 Apr 2000 13:33:37 +1000584_- I assume you've tried load terminate and that did not fix the problem. Try rerunning the load with an empty input file - that usually does the trick.

Cheers, Ulrich

> -----Original Message----- > From: Jimmy Willett [SMTP:Jimmy.Willett@NCMAIL.NET] > Sent: Tuesday, April 11, 2000 1:56 AM > To: DB2-L@RYCI.COM > Subject: quiesce locks > > I am running db2 udb v6.1 on solaris... > I was loading a table using the control center. Did not have load > restart > The job was cancelled before ending and the tablespace is now in > quiesce exclusive. I tried to run the [...] 8235 28 37_DB2 V4 HITACHI Mainframe & ERQUAL200F13_Tony Hurlston26_Tony.Hurlston@ZURICH.CO.UK31_Tue, 11 Apr 2000 07:34:59 +0100331_iso-8859-1 I am trying to run DB2 V4.1 on a HDS box and am expericencing random ERQUAL200F messages.

Has anyone any experience of DB2 & HDS that could help?

There are a number of DB2 Subsystems running all appear to be affected and all currently running OK on IBM kit.

Any suggestions greatfully received [...] 8264 99 16_Re: DB2 rowcount0_19_mike.holmans@BT.COM31_Tue, 11 Apr 2000 09:56:45 +0100382_- Oh, is that what you want to do? You did say we could use QMF as well as DB2, didn't you?

Right, then.

In QMF, execute the query

SELECT X, Y, Z, 1 FROM my.table WHERE.... ORDER BY....

Then, when it shows the result, go into FORM and change the column heading currently set to COL1 to 'ROW NUM' and its usage to CSUM, and you've got what you wnat. [...] 8364 54 33_Re: What's the point of Stogroups0_19_david.a.owen@BT.COM31_Tue, 11 Apr 2000 10:28:15 +0100321_- All, I have been very interested by the discussions going on over the last couple of days on this subject. Mike has mentioned the possibility of using SYSDEFLT only and letting SMS manage the DASD. Joel has suggested that Dataset Placement is still crucial in the scheme of things.

This is where I come in. [...] 8419 112 33_Re: What's the point of Stogroups13_Adrian Savory24_adrian.savory@ZURICH.COM31_Tue, 11 Apr 2000 11:11:11 +0100590_us-ascii Hi Dave,

Under no circumstances let SMS manage the dataset placement without some serious ACS routines being in place. Multiple pools are a must in your situation otherwise you will not be able to guarantee optimum I/O performance. A classic case is where an application has grown to the point where the storage administrators need to add more volumes to the pool. The next time you reorg (if you reorg things that big!) SMS will choose to use those volumes unless you tell it otherwise. You could end up with your most heavily used partitions and their indexes over a [...] 8532 26 26_LOGONLY option of recovery16_Panopoulos Nikos12_npano@NBG.GR31_Tue, 11 Apr 2000 13:47:47 +0300511_- Hello list,

I am trying to investigate the recovery feature of DB2 that can be achieved using the LOGONLY option (recovering the data using the log only starting with a backup that is created outside of the DB2 control) In my case I use the RVA snapshot feature. * Is it a good way for recovery and in what cases is it recommended? * Which exactly is the mechanism of such a recovery? How can DB2 understand from which point and how long will apply the log records to the recovered VSAM data set? [...] 8559 28 18_dynamic vs. static11_idit Berman18_idit.b@MOSTEAM.COM31_Tue, 11 Apr 2000 13:33:13 +0200362_windows-1255 Hello list, What do you know about current IBM recommendations regarding the usage of dynamic SQL versus static SQL? Is it truth that the overhead was minimized and could actually be ignored? What is your own experience? TIA, Idit Idit Berman OnTarget Product Manager MOST – MOdern Software Technologies Ltd. Kehilat Venetzia 10 Tel Aviv 61241 [...] 8588 64 22_Re: dynamic vs. static19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 11 Apr 2000 07:12:07 -0500401_windows-1255 Idit, DB2 for OS390. I think its enough to simply say that dynamic SQL has a longer path-length than static even when the dynamic SQL gets a hit in cache. Whether that path-length cost is significant relates to your application/workload/response-time requirements. If I knew a particular online transaction was going to run a million times a day I'd certainly try to use static SQL. [...] 8653 128 22_Re: dynamic vs. static0_22_The-Thanh.Luong@AGF.BE31_Tue, 11 Apr 2000 14:30:56 +0200401_- DB2 V4 and OS390 here. We use static SQL and are VERY reluctant to go for dynamic SQL. What about resource consumption, response time, control over the quality of the SQLs (we don't have a specific QA department), etc...? We run on-line production (CICS, IMS) from 4 a.m. to 7 p.m. and cannot afford for example runaway tasks. I am very interested in knowing the reasons to go for dynamic SQL. [...] 8782 19 0_12_Rakesh Kumar21_rakesh457@HOTMAIL.COM29_Tue, 11 Apr 2000 12:29:12 GMT390_- Hi ALL, We have DB2 V5 running in our installation.I would like to know what are the steps to access DB2 data from the web.Could anyone show me an example of a macro file (HTML + SQL ).Also could you explain about DB2 WWW Connection . Thanx in Advance.

RAKESH KUMAR ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com [...] 8802 53 12_trace syntax4_IBM116_IBM1@UBIL.COM.TR31_Tue, 11 Apr 2000 16:08:03 +0300391_ISO-8859-9 hello everybody,

this is probably an easy question for some of you - at least so I hope, otherwise I'm done for...

please help me with the syntax for a level 2 DBSS trace on subcomponents ENTRY, EXIT, LOCK, INDEX and DM on DB2 Server for VSE.

my colleague from the labs who requested this is on a very different time zone, and I find myself a bit stuck! [...] 8856 78 16_FW: trace syntax4_IBM116_IBM1@UBIL.COM.TR31_Tue, 11 Apr 2000 16:14:06 +0300636_ISO-8859-9 forgot to add,

I think the TRACDBSS parm should read as follows: TRACDBSS=22020020020

(clear as daylight, isn't it?)

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it



> -----Original Message----- > From: IBM1 > Sent: Tuesday, April 11, 2000 4:08 PM > To: 'lista DB2' > Subject: trace syntax > > hello everybody, > > this is probably an easy question for some of you - at least so I hope, > otherwise I'm done for... > > please help me with the syntax for a level 2 DBSS trace on subcomponents > ENTRY, EXIT, LOCK, INDEX and DM [...] 8935 119 22_Re: dynamic vs. static0_19_mike.holmans@BT.COM31_Tue, 11 Apr 2000 14:19:32 +0100611_iso-8859-1 There's a difference between allowing ad hoc queries during your online production day and having programs which can wish to execute different bits of SQL depending on the data they find.

Display Customer Details might have a number of options, so that the user can request Address, Bill History, Outstanding Orders, or a combination of any or all of them. You could code some logic which had a lot of static statements, one each for Add, BH, OO, Add+OO, Add+BH, OO+BH, and Add+OO+BH, or you could have something which constructed the requisite statement on the fly. The latter option is [...] 9055 50 25_Re: SYSSTMT/TEXT contents9_Colin Fay13_cfay2@CSC.COM31_Tue, 11 Apr 2000 10:11:23 -0400450_iso-8859-1 Hi,

Re; OS/370 DB2 v 5 SQL

Does anyone have the layout of the TEXT field in SYSIBM.SYSSTMT? It looks something like this with the actual SQL followed by WS field references:

...÷...+SELECT PRODUCT_ID INTO : H FROM SPRDJOBT WHERE JOB_ID = : H AND HULL_ID = : H .......... .........D.....DCL-SPRDJOBT.PRODUCT-ID......Ř............D.....DCL-WOHDRT.WO-GROUP-ID .....Ř.........D.....WS-COMM-AREA.WS-COMM-HULL etc..... [...] 9106 200 151_Repost: RESEND: DB2 Certification Preparation 1-Day Class (was RE MINDER: IDUG No. American Conference - Discounted Early Registration Unti l April 14)13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Apr 2000 08:16:31 -0600487_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Resending this note correcting the date of the optional pre-conference seminars...should be Sunday, May 14... [...] 9307 177 79_Repost: DB2 Achieves Record Breaking Results for Peoplesoft and S AP Benchmarks13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Apr 2000 08:16:31 -0600579_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

IBM and SAP AG, and IBM and PeopleSoft recently published new, record-setting benchmark results using DB2. Below are summaries of DB2's industry leading results for: [...] 9485 92 25_Re: SYSSTMT/TEXT contents17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Tue, 11 Apr 2000 15:42:13 +0100574_iso-8859-1 Hi Colin

If you have "extended " EXPLAIN enabled at your site then the PREDICATE_TABLE will have the information you want.

Regards

Nagaraj



______________________________ Reply Separator _________________________________ Subject: Re: SYSSTMT/TEXT contents Author: cfay2 (cfay2@CSC.COM) at unix,mime Date: 11/04/00 15:11



Hi,

Re; OS/370 DB2 v 5 SQL

Does anyone have the layout of the TEXT field in SYSIBM.SYSSTMT? It looks something like this with the actual SQL followed by WS field references: [...] 9578 133 25_Re: SYSSTMT/TEXT contents13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 11 Apr 2000 15:55:16 +0100586_iso-8859-1 Not in production, I hope!

-----Original Message----- From: Nagaraj Pudukotai [mailto:Nagaraj.Pudukotai@WDR.COM] Sent: 11 April 2000 15:42 To: DB2-L@RYCI.COM Subject: Re: SYSSTMT/TEXT contents



Hi Colin

If you have "extended " EXPLAIN enabled at your site then the PREDICATE_TABLE will have the information you want.

Regards

Nagaraj



______________________________ Reply Separator _________________________________ Subject: Re: SYSSTMT/TEXT contents Author: cfay2 (cfay2@CSC.COM) at unix,mime Date: 11/04/00 15:11 [...] 9712 100 22_Re: dynamic vs. static0_19_Tim.Lowe@STPAUL.COM31_Tue, 11 Apr 2000 10:02:01 -0500593_us-ascii In my opinion, the 2 problems with dynamic SQL are the authorities needed, and performance. Assuming that authority is not a problem, then I believe that you may be able to take advantage of dynamic sql caching to improve performance of dynamic sql. However, if all of your dynamic sql includes different parameters as literals, (rather than using parameter markers), then I have heard that you may not get much benefit from dynamic sql caching since the sql will always be "different". For this reason, we have not turned on dynamic sql caching here, and we have been unable to [...] 9813 38 27_Re: SQL Procedures Pre-reqs16_Alma G. Belfield15_agbelfi@TWA.COM31_Tue, 11 Apr 2000 09:59:46 -0500307_- Thanks for the replies. I am indeed asking about the new SQL Procedures lang, not just plain old Stored Procedure. And you've probably guessed we don't have a C compiler at all, so we won't be implementing SQL Procedures anytime soon, we'll just stick with Cobol for the moment.

Alma Belfield [...] 9852 101 25_Re: SYSSTMT/TEXT contents17_Erkki Sřndergaard20_esonderg@SCA.CSC.COM31_Tue, 11 Apr 2000 17:25:36 +0200417_us-ascii



Hi Colin,

I've actually been working at externalizing that info for a while (as a left-hand job) and it isn't quite done yet. If you can live with fairly rough code I have a COBOL module that can extract host variable information from the TEXT column in SYSSTMT and SYSPACKSTMT, but it doesn't quite match it with the table columns yet (that's the part I'm presently working on). [...] 9954 181 25_Re: SYSSTMT/TEXT contents17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Tue, 11 Apr 2000 16:37:51 +0100624_iso-8859-1 Hi Marcus

May I know why?. I thought these tables have quite useful information in them. Is it a big overhead or something??.

Thanks and Regards

Nagaraj



______________________________ Reply Separator _________________________________ Subject: Re: SYSSTMT/TEXT contents Author: Marcus.Davage (Marcus.Davage@LLOYDSTSB.CO.UK) at unix,mime Date: 11/04/00 15:55



Not in production, I hope!

-----Original Message----- From: Nagaraj Pudukotai [mailto:Nagaraj.Pudukotai@WDR.COM] Sent: 11 April 2000 15:42 To: DB2-L@RYCI.COM Subject: Re: SYSSTMT/TEXT contents [...] 10136 119 39_Re: Move Catalog & Boot Strap Datasets.13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 10 Apr 2000 16:42:03 -0500625_iso-8859-1 I just copy the dataset via DFDSS, infact last did it a few weeks ago. Example JCL below (incl BSDS and others), change the OUTVOL and datasets name. Specify the cluster components. DB2 must be down Glenn



//STEP1 EXEC PGM=ADRDSSU,PARM='UTILMSG=YES' //* //SYSPRINT DD SYSOUT=* //OUTVOL1 DD VOL=SER=DESTINATIONVOL,UNIT=3390,DISP=SHR //FILTERDS DD * INCLUDE(DBT1.BSDS02 - DBT1.LOGCOPY1.DS01 - DBT1.LOGCOPY1.DS02 ) /* //SYSIN DD * COPY DATASET(FILTERDD(FILTERDS)) - ALLDATA(*) - ALLEXCP - CATALOG - DELETE - OUTDDNAME(OUTVOL1 ) - PERCENTUTILIZED(100) - PROCESS(UNDEFINEDSORG) - TGTALLOC(SOURCE) /* [...] 10256 23 31_Re: DB2 Erly code compatibility14_Thomas, Steven21_Steven_Thomas@BMC.COM31_Tue, 11 Apr 2000 11:17:55 -0500404_ISO-8859-1 Hi Gabriele,

I've worked with a customer who went from Version 2.3 to 5 in one step, and they got the Erly code to work OK there. I haven't seen it done for V3 to 6 though. I also can't promise that it would be supported by IBM.

If you need more information, email me off-list and I'll contact my customer and see what had to be done to get the erly code to work correctly. [...] 10280 439 33_Re: What's the point of Stogroups16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 11 Apr 2000 12:34:45 -0400453_iso-8859-1 Based on what we have here, I'm not sure you can make a statement that absolute. It depends on the DASD you have. As I understand it, RVA technology (what we use here) is a large subpool of virtual DASD with multiple channels where all channels can can be used all virtual "volumes". Even though a dataset is cataloged to a specific volume, that volume is virtual -- somewhere in the the subpool -- not really a specific tangible volume [...] 10720 94 21_Re: Why Not DB2??????17_Price, Jeff (EDS)14_jprice@NCL.COM31_Tue, 11 Apr 2000 12:35:27 -0400558_- Several reasons this occurs: 1) Very few DBAs are experts in both DB2 and Oracle and so even if their opinion is sought it is very likely that they will recommend the database they are familiar with. 2) There are many more Oracle shops than DB2 shops (re-read point-1). 3) The UNIX world has always had a less restrictive mentality compared to say an OS/390 mainframe world. So there is a perception that if you let the developers have more freedom to do their jobs, they can get a project completed faster in a UNIX world, where they are unhindered, [...] 10815 300 41_Re: Job apparently hung or looping in DB215_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Tue, 11 Apr 2000 08:50:33 -0800506_iso-8859-1 Here is the Accounting Sumamry and Detail reports for the night the job appeared to get hung up.





Omegamon II for DB2 V300 Accounting Summary

Run Date=04/11/2000 Grouped by PlanName





Thread Commit Abort Total Total In-DB2 In-DB2 Planname Total Total Total ElapTime CPU Time Time CPU Time

-------- ------ ------ ----- ------------ --------- ------------ --------- WA0PD600 196400 196513 1 4:48:12.843 002:24:14 4:37:16.449 002:17:01 [...] 11116 150 40_DB2/OS390 Huge DB2 Service Wait times???10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Tue, 11 Apr 2000 11:28:52 -0500592_us-ascii List,

DB2 service task waits are defined in Omegamon like this: > DB2 SERVICE TASK WAIT > WAITS FOR DB2 SERVICES. TYPES OF DB2 SERVICES INCLUDE OPEN/CLOSE OF > DATASET, DFHSM RECALL OF A DATASET, SYSLGRNG UPDATE, OR > DEFINE/EXTEND/DELETE OF DATASET, COMMIT PHASE 2 FOR READ ONLY

With that in mind, this is a select only program, so it shouldn't be logging related. The max open datasets haven't reached 5000, the high water mark is more like 4650 since the end of March when the region was last cycled. These datasets are very heavily used and no recall activity [...] 11267 148 39_Re: Move Catalog & Boot Strap Datasets.22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 11 Apr 2000 12:59:57 -0400385_ISO-8859-1 You might want to consider the SPHERE parameter. It's used to specify that all objects associated with a VSAM cluster (truename, alt index, aliases etc...) are included when processing the VSAM cluster.

Granted, it's not required for the DB2 BSDS and active log data sets but I'm in the habit of specifying it for all VSAM clusters whether it's required or not. [...] 11416 225 25_Re: SYSSTMT/TEXT contents20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Apr 2000 13:17:32 -0400385_iso-8859-1 It is not overhead but is not documented or supported by IBM. Besides it can bring down your DB2 on certain occasions. That is why it is not recommended in production.

-----Original Message----- From: Nagaraj Pudukotai [SMTP:Nagaraj.Pudukotai@WDR.COM] Sent: Tuesday, April 11, 2000 11:38 AM To: DB2-L@RYCI.COM Subject: Re: SYSSTMT/TEXT contents

Hi Marcus [...] 11642 82 25_Re: SYSSTMT/TEXT contents20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 11 Apr 2000 13:22:38 -0400336_iso-8859-1 Colin

The TXT field in SYSSTMT or STMT field in SYSPACKSTMT has the same format as that of the DBRM. This is mapped by DSNXNBRM macro. I wrote a REXX to find out all the host-variable having mismatch of datatype , long time ago. Let me search for my archives to find that REXX. If I get it I will mail it to you. [...] 11725 325 25_Re: SYSSTMT/TEXT contents16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Tue, 11 Apr 2000 14:26:04 -0400606_iso-8859-1 Please copy the list -- I would like to have that too. Thanks

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] > Sent: Tuesday, April 11, 2000 1:23 PM > To: DB2-L@RYCI.COM > Subject: Re: SYSSTMT/TEXT contents > > Colin > > The TXT field in SYSSTMT or STMT field in SYSPACKSTMT has the same > format as that of the DBRM. This is mapped by DSNXNBRM macro. I wrote a > REXX to find out all the host-variable having mismatch of datatype , long > time ago. Let me search [...] 12051 90 26_TDAN.com 12.0 Announcement13_Morrill, John12_JohnM@VP.NET31_Tue, 11 Apr 2000 12:28:59 -0600490_iso-8859-1 Re: The Data Administration Newsletter -- http://www.tdan.com/

I am pleased to announce that issue 12.0 of The Data Administration Newsletter has been posted to the TDAN.com web-site. This issue features new book reviews, conference & seminar lists, job classifieds, links & resources, ... and of course, a dozen new articles on topics including business intelligence, knowledge management frameworks, e-business, data warehousing, best practices, ... and much more. [...] 12142 62 48_Thanks...Re: Move Catalog & Boot Strap Datasets.16_Pantazis Pantazi20_zakis@CYTANET.COM.CY31_Tue, 11 Apr 2000 21:39:12 +0300591_us-ascii Thanks for all your information.

I have DFDSS on the Boot Strap Datasets and it wotk OK, now I have to try it on the catalog as well.

Thanks for your help again.



Duane Lee - ATCX wrote:

> Check the Utility Guide under DSNJU003 and follow the steps for enlarging > the datasets. You will follow the same procedure except you won't be > enlarging the datasets (unless you want to do that at the same time). > > Duane > > > -----Original Message----- > > From: Pantazis Pantazi [SMTP:zakis@CYTANET.COM.CY] > > Sent: Monday, April 10, 2000 9:15 [...] 12205 60 43_Re: WLM Stored Procedures and non-swappable11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Tue, 11 Apr 2000 15:02:40 -0400492_us-ascii Rather strange, but I am posting an answer to my own questions. Since I received no answers from this listproc, I posed the question to IBM support and, with their permission, I am repeating their response here.



>1) We have converted all our in-house stored procedures to WLM. I notice the address space for WLM stored procedures is swappable, while our prior non-WLM address space was nonswappable. Should I ask the MVS systems programmer to make this change? > [...] 12266 68 41_Re: Experiencing shortages on subpool 24111_Sam Knutson21_sknutson@LANDMARK.COM31_Tue, 11 Apr 2000 16:05:54 -0400411_us-ascii From: Brian Lynch >We are Experiencing shortages on subpool 241. >We are running OS/390 2.5 >DB2 v5.1 PUT level 9805 with bunches of maintenance.

Hi Brian,

I wrote this resolution for my technical support group. It might help you get started analyzing your common storage use.

How to get more detailed information on CSA/SQA usage for debugging? [...] 12335 148 21_Re: Why Not DB2??????14_Hans Dingerdis21_dingerdis@SIONELL.COM31_Tue, 11 Apr 2000 22:37:39 +0200535_iso-8859-1 Having some dba experience in db2 and oracle, and being in the middle of a mainframe/db2 to unix/oracle conversion, i think i know one of the reasons why mf/db2 is not in the picture anymore. We're talking to a generation with an IT education where the word mainframe was something they had to look for in a dictionary. It was unix, unix, unix. So if a decision had to be made as to where a project was build in (for), you had to convince that kind of people that a mf had some values, a unix environment did not have. [...] 12484 36 33_Re: What's the point of Stogroups14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 11 Apr 2000 16:49:43 -0400617_ISO-8859-1 Yes, but your I/O contention (queueing) occurs at the logical volume level, the volume your data is assigned to - like DBP001. The contention occurs long before channels come into play. The volume is not "virtual" from the OS/390 perspective.... Regards, Joel Goldstein





Message text written by DB2 Data Base Discussion List >Based on what we have here, I'm not sure you can make a statement that absolute. It depends on the DASD you have. As I understand it, RVA technology (what we use here) is a large subpool of virtual DASD with multiple channels where all channels can can [...] 12521 236 41_Re: Job apparently hung or looping in DB212_Ram Dorairaj19_jbrams_99@YAHOO.COM31_Tue, 11 Apr 2000 13:47:33 -0700308_us-ascii Hello Mitchell,

Similar problem happened to me when i was running a batch program with CPU parallelism. When changed to DEGREE = 1 . That problem never came. But I did not know why and I am not suggesting here to change DEGREE option but I thought of passing on this information to you. [...] 12758 27 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 12 Apr 2000 10:06:06 +1200595_us-ascii Mike/Adrian,

Personally I like to see one VCAT for all the datasets for a particular subsystem. Probably for a similar reason that some people prefer multiple VCATs i.e. makes it easier to group datasets together. It just depends on your definition of 'group'. I know some places have separate VCATs for the DSNDB01/6/7 and log datasets (this might be closer to the GSD standards... Gab?) but I can't say I like it. While managing multiple subsystems it makes my life easier if all the datasets for a subsystem have the same VCAT. I Quite like having image copies using the [...] 12786 132 16_Re: trace syntax0_20_gabriele@NZ1.IBM.COM31_Wed, 12 Apr 2000 09:54:15 +1200582_us-ascii Aurora,

first I warn you that I don't know DB2 Server for VSE or SQL/DS at all, but I am curious by nature and according to the manual TRACDBSS is an 11-digit parameter that specifies the parts of the DBSS that are to be traced and the level. Where 0 is specified, tracing is not done. Where 1 is specified, tracing displays only module entry and exit points. Where 2 is specified, tracing is done in greater detail. The positional digits correspond to the following DBSS functions and subcomponents: ENTRY, EXIT, LOG, LOCK, LUW, DC, DM, STOR, SORT, INDEX, and [...] 12919 47 27_Re: SQL Procedures Pre-reqs16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 11 Apr 2000 17:39:02 -0400598_iso-8859-1 C LE/370. LE for ALL stored procedures...

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Seibert, Dave > Sent: Monday, April 10, 2000 11:19 PM > To: DB2-L@RYCI.COM > Subject: Re: SQL Procedures Pre-reqs > > > Hi Mike, > > Alma's question was about the new SQL Procedures language aka > PSM -- an > equivalent to the pl-sql language in Oracle (or T-sql in Sybase, I think). > This is not the same as Stored Procedures. > You're correct--Stored Procedures can be written in several languages). > > And as Linda states, [...] 12967 204 145_Re: Repost: DB2 Certification Preparation 1-Day Class (was REMINDER: IDUG No. American Conference - Discounted Early Registration Until April 14)16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 11 Apr 2000 17:39:06 -0400630_iso-8859-1 But all Mike Swift's postings are available on www.DB2-portal.com and all old messages will be archived there also for searching and so forth

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Morrill, John > Sent: Monday, April 10, 2000 8:28 PM > To: DB2-L@RYCI.COM > Subject: Repost: DB2 Certification Preparation 1-Day Class (was > REMINDER: IDUG No. American Conference - Discounted Early Registration > Until April 14) > > > Greetings! > > Below is a posting from Mike Swift's DB2 Interested Parties > mailing list. If > you would like to join his [...] 13172 23 16_Re: DB2 rowcount12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Wed, 12 Apr 2000 10:58:53 +1200344_us-ascii Steve,

Arthur's suggestion on getting the first 6 rows works - I've used it myself after seeing it in an ancient Platinum Solutions flyer - but a word of caution. Bear in mind that it won't retrieve the first 6 values, rather the rows that have the lowest 6 values. So if you have any duplicate values they'll also appear. [...] 13196 22 24_DB2 to ORACLE via DB2CLI13_CAROLINE BEAN26_Caroline.Bean@AWTPL.COM.AU31_Wed, 12 Apr 2000 09:04:03 +1000545_- Dear fellow List'ners

Can anyone out there tell me if what we are trying to do is feasible, and if so, how we can get it to work ?

Application basically wants to access Oracle data using DB2 ODBC to connect. It comes from a webpage to DB2 via NetData, then passes SQL to an Oracle database (either NT or OS/390 based) using DB2CLI and TCP/IP. Oracle instances have been defined in LOCATIONS and IPNAMES Catalog tables. The NetData connection to DB2 is fine, DB2 monitor shows remote call going thru to Oracle, then nothing. [...] 13219 327 61_Repost: Introducing DB2 UDB for UNIX, Windows, OS/2 Version 713_Morrill, John12_JohnM@VP.NET31_Tue, 11 Apr 2000 17:18:23 -0600703_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

In a preview of the formal announcement next week, IBM today launched a new version of DB2 Universal Database for UNIX, Windows, OS/ at an event in Vienna. You will find summaries of DB Version 7 on the IBM corporate Internet site at http://www.ibm.com and the IBM data management software [...] 13547 18 12_CAF Question20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Tue, 11 Apr 2000 19:22:54 EDT417_US-ASCII Do anyone know how to get the reason code after a sqlcode 904. I am using CAF to attach to DB2. When I do a Open on a cursor I receive a sqlcode 904 resource not available. The DB2 application programming and SQL Guide lead you to believe that the reason code in in R0. I am using assembler language. The Sqlcode is in R15, but I can not access the reason code to find what is the real problem. Thanks. [...] 13566 40 16_Re: CAF Question14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 12 Apr 2000 10:38:24 +1000434_iso-8859-1 Edward,

Wrong place: after calls to DSNALI the reason code will be in R0; after SQL (your situation) look in SQLERRMC.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au -----Original Message----- From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] Sent: Wednesday, April 12, 2000 9:23 AM To: DB2-L@RYCI.COM Subject: CAF Question [...] 13607 17 16_Re: CAF Question20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Tue, 11 Apr 2000 21:10:44 EDT495_US-ASCII Jim, In the sqlca I have a SQLERRM, but no SQLERRMC. In SQLERRM I get only .DBCURSOR. Also the funny thing about this is it was working at one time with no changes to the program and the Database and Tablespace is both in READ WRITE status. Ed.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13625 38 16_Re: CAF Question14_Linda Claussen18_lindafc@NETINS.NET31_Tue, 11 Apr 2000 20:20:30 -0500637_ISO-8859-1 Ed,

Have you checked the DB2 MSTR address space? The Unavail should also show up there with the reason code?

Linda F. Claussen Claussen & Assoc. lindafc@netins.net http://www.netins.net/showcase/lclaussen

---------- From: Edward C. Benoit Jr. To: DB2-L@RYCI.COM Subject: Re: CAF Question Date: Tuesday, April 11, 2000 8:10 PM

Jim, In the sqlca I have a SQLERRM, but no SQLERRMC. In SQLERRM I get only .DBCURSOR. Also the funny thing about this is it was working at one time with no changes to the program and the Database and Tablespace is both in READ WRITE status. Ed. [...] 13664 42 16_Re: CAF Question14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 12 Apr 2000 11:49:28 +1000376_iso-8859-1 Ed,

SQLERRM is a grouping field that contains SQLERRML, the halfword length, and SQLERRMC, the 70 characters. It is a language specific thing. I presume your dots are actually x'ff' characters.

What version of DB2 are you using? For example, if you are using V6 and Identity columns, there's PQ35300 TOKENS IN SQLCA NOT FILLED IN FOR SQLCODE904. [...] 13707 40 13_regarding QMF17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Tue, 11 Apr 2000 19:43:34 PDT485_- Hi Folks,

I have a question regarding qmf. i need to take a count for certina no. of rows in horizantally.

for ex.

col1 count -------- ------- 15 15 3 15

78 78 78 4 78

like this i need to get the result from the query, is there any option in qmf to get the count in like above. or do i need to do something in the query. col1 is the result from the query. but count is i need to get from the option of the qmf. can anybody help in this issue. [...] 13748 25637 17_Re: regarding QMF12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Tue, 11 Apr 2000 22:32:59 -0500457_iso-8859-1 Here is the sql QMF generated- Select A.OFF_DATE_MO, COUNT ( * ) From PD.PART1_3DAYS_ALL_V A Group By A.OFF_DATE_MO

Attached is the QMF for WIndows prompted query

If you need it sideways along the page You can use the Across in the form's usage column.



-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Tuesday, April 11, 2000 9:44 PM To: DB2-L@RYCI.COM Subject: regarding QMF [...] 39386 54 17_Re: regarding QMF9_Birk, Tim17_BirkT@DIEBOLD.COM31_Wed, 12 Apr 2000 00:10:08 -0400440_iso-8859-1 Ravi,

Assuming you have order by col1 in query, in form put break1 on col1. Then in f.b1 in the footing area put &count.

-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Tuesday, April 11, 2000 10:44 PM To: DB2-L@RYCI.COM Subject: regarding QMF



Hi Folks,

I have a question regarding qmf. i need to take a count for certina no. of rows in horizantally. [...] 39441 16 96_Per-Erik Svennberg/P001890/Nordbanken =?iso-8859-1?q?=E4r?= inte =?iso-8859-1?q?p=E5?= kontoret.15_Pelle Svennberg24_per-erik.svennberg@NB.SE29_Wed, 12 Apr 2000 05:17:46 GMT337_iso-8859-1 Jag är borta frĺn kontoret frĺn 2000-04-12 till 2000-04-24.

har semester (välförtjänt) ===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 39458 54 16_Smart Optimizer?14_Peter Backlund15_pbacklu@IBM.NET31_Wed, 12 Apr 2000 06:58:24 +0200 39513 42 23_Reading root page only?14_Peter Backlund15_pbacklu@IBM.NET31_Wed, 12 Apr 2000 07:01:09 +0200 39556 50 28_FW: DB2 to ORACLE via DB2CLI14_Richard Bourke25_Richard.Bourke@MERANT.COM31_Wed, 12 Apr 2000 10:03:24 +0200429_- Caroline, I think there is an obvious reason this won't work, unless I'm missing a component somewhere. The oracle instances in LOCATIONS are being called via DRDA. That requires the Oracle Instance to act as a DRDA server. Oracle does have DRDA enablement (I think it's called the Oracle Procedural Gateway), but I suspect that it will only act as a DRDA requester. It "listens" for TNS (oracle's net protocol) not DRDA. [...] 39607 244 25_Re: SYSSTMT/TEXT contents13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 12 Apr 2000 09:15:31 +0100587_iso-8859-1 The extended plan tables are available only through an undocumented and unsupported zap to DSNZPARMS. I have used them in the past, and indeed, have based quite a nifty little SQL analyser upon them. But a conversation I had with Roger Miller, two years ago, made me realise not only the dubious benefits of the zap, but the dangers of applying it in production... just think, if anything went wrong with your subsystem (I can cite examples of where that has happened to me), IBM will NOT come rushing to your aid, because of your little "modification". Been there. Done [...] 39852 58 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 12 Apr 2000 09:21:34 +0100683_iso-8859-1 How about one VCAT across ALL subsystems?

-----Original Message----- From: Raymond Bell [mailto:raymondb@NZ1.IBM.COM] Sent: 11 April 2000 23:06 To: DB2-L@RYCI.COM Subject: Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)



Mike/Adrian,

Personally I like to see one VCAT for all the datasets for a particular subsystem. Probably for a similar reason that some people prefer multiple VCATs i.e. makes it easier to group datasets together. It just depends on your definition of 'group'. I know some places have separate VCATs for the DSNDB01/6/7 and log datasets (this might be closer to the GSD standards... Gab?) but I can't [...] 39911 23 53_Anyone experienced Mantech SQL Conversion Workbench ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 12 Apr 2000 08:38:51 +0100558_us-ascii Has anyone experienced using the Mantech SQL Conversion Workbench for converting a SQLServer system to DB2 (either AIX or OS/390).

The system is written in Visual Basic and relies heavily on stored procedures.

TIA



Philip Nelson Senior DBA Scottish Widows (teamdba@attglobal.net)

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 39935 28 18_DB2/390 and SAP BW13_adriancollett27_adriancollett@TISCALINET.IT31_Wed, 12 Apr 2000 03:54:14 -0500364_us-ascii Does anybody know where I can get info on SAP BW and DB2/390 ?? Web sites, redbooks etc.

Also, is anybody ACTUALLY using DB2/390 (V6) and SAP BW(V1.2B) ?

Any help would be greatly appreciated - and as usual - will be remunerated with copius quantities of your favourite liquid.

TIA,

Adrian Collett DB2 Consultant, Milan, Italy. 39964 76 27_Re: Reading root page only?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 12 Apr 2000 09:34:22 GMT327_iso-8859-1 Hi Peter, I would like to give this cutting to you from my Archieve which was posted by Michael Hannan in March only when we had some discussion about Selecting MIN and MAX function.I think it will clarify why not the result can be given by root page only.

However this was in related to TYPE 2 Indexes. [...] 40041 107 20_Re: Smart Optimizer?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 12 Apr 2000 09:46:23 GMT536_iso-8859-1 Hi Peter, I had never thought of this till now but your question made me to give some try.I tried running some queries and found that DB2 doesn't do the sort in the 2nd case mentioned by you. First of all in the first case in the subquery DB2 does the sorting in DSNDB07 and keep it there and access it from there using the sparse index mechanism. In second case it looks that DB2 just starts sending the indentified pages and after that data manager applies all the values in the IN LIST ,If any one of those qualifies [...] 40149 285 25_Re: SYSSTMT/TEXT contents17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Wed, 12 Apr 2000 10:50:06 +0100734_iso-8859-1 Thanks very much Marcus for your explanation. BTW what's new in V6 explain tables?.



______________________________ Reply Separator _________________________________ Subject: Re: SYSSTMT/TEXT contents Author: Marcus.Davage (Marcus.Davage@LLOYDSTSB.CO.UK) at unix,mime Date: 12/04/00 09:15



The extended plan tables are available only through an undocumented and unsupported zap to DSNZPARMS. I have used them in the past, and indeed, have based quite a nifty little SQL analyser upon them. But a conversation I had with Roger Miller, two years ago, made me realise not only the dubious benefits of the zap, but the dangers of applying it in production... just think, if anything went wrong [...] 40435 35 60_DSNWLIR2, trace AUTHID and IFI AUTHOD: need a little help...14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Apr 2000 11:57:46 +0200395_us-ascii Hi all, I need a little help from DB2 gurus, because my ignorance is abyssal.....

I'm using DSNALI & DSNWLIR2 to call IFI via REXX and for a READA intruction I obtain a RC

00E60824, that is the AUTHID of the started trace (monitor trace) is different (or not authorized)

from AUTHID provided by REXX. Of course all AUTHID are equal, but nevertheless the error [...] 40471 16 76_DSNWLIR2, trace AUTHID and IFI AUTHID: need a little help...- errata corrige14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Apr 2000 12:10:06 +0200347_us-ascii It was DSNWLI2 instead of DSNWLIR2. A copy/paste with an alien R .....

Regards MAx Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 40488 145 21_Re: Why Not DB2??????4_IBM116_IBM1@UBIL.COM.TR31_Wed, 12 Apr 2000 14:11:51 +0300559_ISO-8859-9 my 2 turkish lira worth.... (and that's saying VERY little!):

I agree totally with Jeff especially on points 1 (expertise) and 6 (gobblededook), and in the working environment I find myself in at the moment, the situation is medium-sized banks with logical security problems, 100 agencies and over 200 ATMs/POS' are switching from the most popular IBM system here (VSE) over to Oracle because they get the whole package for "peanuts", ready-made and packed with application programming which they can (easily?) customise and/or tailor. [...] 40634 85 22_Re: What is in a name?13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 12 Apr 2000 12:15:20 +0100511_iso-8859-1 Currently, there is so much disparity between the members of the DB2 family that different nomenclature is necessary to distinguish them. However, to type "DB2 Universal Database for OS/390" is a pain in the neck each time I want to refer to it.

When DB2 Universal Database for OS/390 is indistinguishable from DB2 Universal Database for UNIX, Windows, OS/2, DB2 Universal Database for AS/400 and DB2 for VSE & VM, then there will be no need to separate out the names from the platforms. [...] 40720 428 33_Re: What's the point of Stogroups13_Adrian Savory24_adrian.savory@ZURICH.COM31_Wed, 12 Apr 2000 12:18:15 +0100597_us-ascii



Andrea,

The facts as I see it are:

- we have a BIG system - partitioning - parallelism - heavy insert/read activity - a need to make it perform as well as possible (as evidenced by existing STOGROUP definitions)

Given this information there is no way I would throw the system to the mercy of SMS without some careful planning. With regard to RVA, I guess what you're saying is that dataset placement does not matter, as the data gets spread everywhere anyway. I have to say that this is not the case. I've worked with a large totally SMS-managed [...] 41149 135 20_Re: Smart Optimizer?17_Nagaraj Pudukotai25_Nagaraj.Pudukotai@WDR.COM31_Wed, 12 Apr 2000 12:25:46 +0100444_iso-8859-1 Hi Sanjeev

This is a question which is a bit out of context. I read in Gabrielle's book that sparse indexes are not supported by DB2. I also read somewhere that for noncorrelated IN subqueries sparse indexes are built on the inner query column to help scan the inner composite table faster. In which cases other than the one above, does DB2 employ (if it does) sparse index. Is there a way we can find out if it did so?. [...] 41285 17 30_Re: LOGONLY option of recovery11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Wed, 12 Apr 2000 06:37:49 -0500328_- Nikolaos, LOGONLY option can be used. I believe DB2 reads the HPGRBRBA value of the spacemap page to determine how far back in the log to go. I have used LOGONLY recoveries after laying down an image copy via DSN1COPY. At times, this scenario is much faster than RECOVER tablespace. Regards, John Rosser Duke Energy Corp [...] 41303 90 16_Re: trace syntax4_IBM116_IBM1@UBIL.COM.TR31_Wed, 12 Apr 2000 15:01:35 +0300427_- Gabriele,

thanks very much for your help, however, our mail server was down all of yesterday so I worked out the trace syntax myself in the end - from the same manual.

to tell the truth, I hoped that somebody might "spell check" my syntax before I started the trace...

thanks anyway!!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it [...] 41394 76 20_Re: Smart Optimizer?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Wed, 12 Apr 2000 12:06:57 GMT327_us-ascii Hi Nagaraj, I think i wrote this paragraph in the same context as you mentioned .

"First of all in the first case in the subquery DB2 does the sorting in DSNDB07 and keep it there and access it from there using the sparse index mechanism."

And the first case of the query which peter had given is : [...] 41471 118 22_Re: What is in a name?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Apr 2000 08:06:13 -0500562_iso-8859-1 Hi all, IBM has a branding problem and I can see why they recommend the names. However, I feel as most of you out here in the real world do because I've been using names like DB2 UDB/OS390, and DB2 UDB/NT.

Kind Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in [...] 41590 145 26_Repost: What is in a name?13_Morrill, John12_JohnM@VP.NET31_Wed, 12 Apr 2000 07:36:11 -0600681_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

In May 1999 I sent the bulletin below to this distribution list. These principals, names and usage guidelines for DB2 still apply, although we still see many references that depart for these standards...even by IBMers. :-\ So, I thought that it was worth resending... [...] 41736 811 43_Repost: Press Coverage of the DB2 V7 Launch13_Morrill, John12_JohnM@VP.NET31_Wed, 12 Apr 2000 07:36:12 -0600600_iso-8859-1 Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

IBM's launch today of Version 7 of DB2 Universal Database for UNIX, Windows, OS/2 resulted in broad coverage in the press. Below is a compilation of the articles, here are the headlines: [...] 42548 16 58_DSNWLI2, trace AUTHID and IFI AUTHOD: problem resolved !!!14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 12 Apr 2000 15:46:01 +0200373_us-ascii I fixed the problem with DSNWLI2. Now rexx mini-monitor works.Thanks all (?) for the help ;-))))

Regards Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 42565 96 78_IDUG 12th Annual North American Conference May 14 - May 18, 2000 Dallas, Texas14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 12 Apr 2000 10:05:24 -0400622_iso-8859-1 Greetings! For those DB2-L subscribers attending this year, the following arrangements have been made with IDUG Headquarters:

DB2-L Ribbons issued at registration to DB2-L subscribers At the Tuesday lunch, 2 tables have been reserved for DB2-L'ers to use. These will have DB2-L signs on them.

Please wear your ribbons so we can all associate names with faces! Also, if you will be sitting with the group at the Tuesday lunch, please email me at pgunning@boscovs.com so I can get a count and reserve more tables if needed. Also, If anyone else has a suggestion for the gathering, let me know. [...] 42662 50 33_DB2 Version 6 - Migration Problem0_23_pjackson@SUMMITBANK.COM31_Wed, 12 Apr 2000 10:05:31 -0400689_us-ascii Hi Folks,

We are attempting to migrate to V6 (several subsystems, one at a time).

With the second subsystem we are receiving the following error in the CATMAINT step:





DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RELODCAT DSNU050I DSNUGUTC - CATMAINT UPDATE DSNU750I DSNUECM0 - CATMAINT UPDATE STARTED DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - VERIFYING CATALOG IS AT CORRECT L DSNU777I DSNUECM0 - CATMAINT UPDATE STATUS - BEGINNING MIGRATION SQL PROCESSIN DSNU778I -DBQ1 DSNUEXDL - ERROR PROCESSING SQL STATEMENT - SQL CODE IS: -544 SQL MESSAGE TOKENS: THE FOLLOWING IS THE PROBLEM SQL STATEMENT: ALTER INDEX SYSIBM.DSNAUH01 [...] 42713 51 27_Re: SQL Procedures Pre-reqs38_Enarson, Mike (CC-Application Support)24_Mike.Enarson@CONAGRA.COM31_Wed, 12 Apr 2000 09:02:07 -0500341_iso-8859-1 Hi Dave. That's interesting. Would that be what's generated out of the new SQL Builder that I'm thinking they talked about in the version 6 transistion class?

In the past LE/370 has included the C run time libraries which is why we have not needed a C compiler before. Has that changed with recent releases of LE/370? [...] 42765 152 17_Thread simulation18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 12 Apr 2000 09:59:33 -0400550_iso-8859-1 Anybody know how to force a thread to fall under the 'idle thread timeout' parm??

We are trying to simulate where a client creates a thread into DB2/OS390 and for some reason it hits the idle thread timeout. We have an application that gets kicked off using DDF and for some reason it will occasionally hit the idle thread timeout value and the thread will get cancelled. This is what should happen. We're just trying to recreate it and not sure how to go about it. We tried submitting the job from an NT box and we let it run [...] 42918 23 73_Re: Cancelling threads asynchronously - is there a way to do it in batch?18_Madeleine Fournier27_madeleine.f.fournier@AIB.IE31_Wed, 12 Apr 2000 09:05:14 -0500565_- Hello,

The Platinum log might fill up quite a lot depending on the jobs. You can display the content of it in the Log Maintenance Tool (option W) just to check how many rows each of your jobs will add. If you are using BP in production in a regular basis (scheduled jobs or other) I would recommend you put in place the automatic log purge job. The sample JCL is in SRCLIB(LOG#ADEL). It works with parameters contained in PARMLIB member ALOGDEL. You can get more information in the General Utilities Guide. I don't know about contention on this table [...] 42942 266 25_Re: SYSSTMT/TEXT contents9_Mark Ruhe19_Mark.Ruhe@QUEST.COM31_Wed, 12 Apr 2000 07:19:32 -0700402_iso-8859-1 Also, although I can't confirm, I heard that of version 6.0 they exteneded plan tables are not being populated anymore. Regardless, per that same discussion with Roger Miller, these tables have not been supported. So the information they contain may be misleading. Also keep in mind that not all host varialbe mismatches will cause nonindexability so a bit of testing will be required. [...] 43209 20 25_Re: SYSSTMT/TEXT contents9_Colin Fay13_cfay2@CSC.COM31_Wed, 12 Apr 2000 10:33:45 -0400423_us-ascii Hi ,

I am interested in your statement :

"not all host varialbe mismatches will cause nonindexability".

Can you provide sample exceptions?

Colin

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 43230 70 18_Buffer Pool Tuning14_Lisa Ouellette29_Lisa.Ouellette@FIRSTUNION.COM31_Wed, 12 Apr 2000 09:45:31 -0500380_- I'm embarking on an effort to improve performance by tuning our buffer pools. I'm wondering how to measure the success of the changes I am considering in terms online response time or batch run times. Right now we have on one of our production subsystems:

BP0 - Catalog, DSNDB07 - 15000 buffers BP1 - index datasets - 20000 buffers BP2 - ts datasets - 30000 buffers [...] 43301 62 21_Re: Thread simulation13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 12 Apr 2000 09:54:57 -0500624_US-ASCII Steve, Change ZPARM CMTSTAT=ACITVE. and do distributed select with NO commit. This will allow your thread to stay active until ZPARM IDTHTOIN= is reached. HTH Kurt

>>> stephen.whittaker@CPLC.COM 04/12/00 08:59AM >>> Anybody know how to force a thread to fall under the 'idle thread timeout' parm??

We are trying to simulate where a client creates a thread into DB2/OS390 and for some reason it hits the idle thread timeout. We have an application that gets kicked off using DDF and for some reason it will occasionally hit the idle thread timeout value and the thread will get cancelled. This is [...] 43364 274 22_Re: dynamic vs. static10_Bill Disch23_bill.disch@GENMILLS.COM31_Wed, 12 Apr 2000 10:06:23 -0500318_iso-8859-1 Look no further than Sap R/3. The application utilizes dynamic SQL almost 100% and depends on the DB2 cache for performance (avoids PREPARE). Another feature within R/3 is SAP Query which allows end users to create ad-hoc requests. SAP Query is often turned off in Production to avoid runaway queries. [...] 43639 54 83_Re: IDUG 12th Annual North American Conference May 14 - May 18, 2 000 Dallas, Texas17_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV31_Wed, 12 Apr 2000 11:09:54 -0400535_iso-8859-1 Hi Phil,

We have talked in the past and I would love to catch up with you at IDUG. Please put me on the DB2-L list . Would you also add Mr.. Chris Hayes also.

I need to get some information as to how to write a course proposal for using DB2 UDB NT for a local community college. Currently they use ACCESS as the RDBMS for teaching the DATABASE DESIGN and CONCEPTS course. I know you have taught using DB2 UDB and was wondering if you could help me out. I teach part time in the Baltimore County Community [...] 43694 131 22_Re: Buffer Pool Tuning16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Wed, 12 Apr 2000 11:16:53 -0400415_iso-8859-1



If you are interested there is a presentation from Chuck Hoover concerning Buffer Pool tuning the URL is located at http://www.compuware.com/products/file/

The link is on the bottom of the page. This presentation is NOT marketing but a presentation by Mr. Hoover concerning the subject mentioned above. Also note there are a number of other DB2 presentation on the same page. [...] 43826 159 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 12 Apr 2000 11:18:02 -0400454_- Raymond,

I agree with you and that's how we do it here. Catalog's datasets have one VCAT which is representative of the given subsystem and all applications have a slightly different VCAT for all applications data in that subsystem. Image copies also have the same HLQ and the tablespaces they back up and from the application side also include the tablespace/indexspace name. It sure makes it much easier to know what is attached to what. [...] 43986 80 21_Re: Thread simulation22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 12 Apr 2000 11:14:50 -0400564_- Stephen -

Make sure ZPARMs CMTSTAT=INACITVE and > IDTHTOIN=x where x is not zero. > "Unplugging" the NT box will not necessarily cause an active thread to go idle.

I believe that as long as the thread is accumulating CPU time it is an active thread, not an idle active thread.

Using the above ZPARMs, I've created an idle active thread by executing some distributed SQL and don't do a commit - either explicitly or implicitly with an auto commit. Eventually the idle thread time out threshold is satisfied and the thread is terminated. [...] 44067 373 22_Re: Buffer Pool Tuning18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 12 Apr 2000 11:17:44 -0400570_iso-8859-1 Lisa: We're currently using a tool called DB2 Buffer Pool Tool. Its remarketed by IBM and put out by, I think, Responsive systems. If you have a tool like this you can simulate all your changes FIRST before making them in the production environments. I've been spending alot of time myself trying to understand our buffer pool mentality here and making changes to it based on using this tuning tool. Its a good tool and gives you alot of information on each pool and what your changes will or will not do. Sorry I don't have any recommendations for your [...] 44441 46 25_Re: SYSSTMT/TEXT contents9_Mark Ruhe19_Mark.Ruhe@QUEST.COM31_Wed, 12 Apr 2000 08:21:48 -0700565_iso-8859-1 I can give a example of why this is the case. Consider a character comparison of a character column of length 5 to a host variable of length 4. The data manager can still make this comparison by appending padding to the host variable and still be able to perform a CLC on the 2 fields. Performing this in the opposite manner requires modifying each column value by appending padding. Since table or index data is contiguous the column value must be isolated from the rest of data by moving it prior to appending the padding. Then the comparison can [...] 44488 51 57_Re: Anyone experienced Mantech SQL Conversion Workbench ?13_Keith Gilbert17_kgilbert@CSA1.COM31_Wed, 12 Apr 2000 10:27:06 -0500384_iso-8859-1 Philip,

We are currently working with Mantech to provide a quote for converting an Oracle database to DB2. But, our system is written in COBOL uses no stored procedures. I would be happy to share some information with you when we get started with them. Another company we are working with is "Source Recovery". Their web site is http://www.source-recovery.com/ [...] 44540 32 30_Re: LOGONLY option of recovery11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Wed, 12 Apr 2000 11:33:49 -0400612_ISO-8859-1 A minor correction. HPGRBRBA is held in the header page, not the space map page.

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner

Message text written by DB2 Data Base Discussion List >Nikolaos, LOGONLY option can be used. I believe DB2 reads the HPGRBRBA value of the spacemap page to determine how far back in the log to go. I have used LOGONLY recoveries after laying down an image copy via DSN1COPY. At times, this scenario is much faster than RECOVER tablespace. Regards, John Rosser Duke Energy Corp< [...] 44573 34 0_9_Bob Crail11_bcc@IBM.NET31_Wed, 12 Apr 2000 11:24:20 -040022_iso-8859-1 unsubscribe 44608 63 22_Re: Ad-hoc query tools9_JANA BONE25_Jana.Bone@TLC.STATE.TX.US31_Wed, 12 Apr 2000 10:42:04 -0500275_US-ASCII I am wondering if other shops out there allow user access thru ad-hoc query and reporting tools?

If you do, how do you handle security and performance?

Thanks for any input, Jana

Jana Bone DBA, Texas Legislative Council jana.bone@tlc.state.tx.us 44672 18 13_CLI interface10_Tom Taylor17_ttaylor@CHUBB.COM31_Wed, 12 Apr 2000 11:51:56 -0400541_us-ascii Hi all Does anyone have info on the call level interface (CLI). I most interested in usage, performance,stability and problems. We currently are using MQ to CICS to DB2 inorder to processes distributed requests. I was wondering if the CLI could/should be used in the same manner?

Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 44691 64 22_Re: Buffer Pool Tuning14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 12 Apr 2000 11:51:48 -0400395_ISO-8859-1 Lisa, Your system hit ratio for BP2 in the 50% range, so there should be a lot of room for improvement. Look at your application Accounting data. Class2 elapsed time, and Class3 wait time for I/O. What % of C2 elapsed is I/O wait? If > 10%, you should be able to get substantial performance improvements from BP tuning. Moving DB07 out of BP0 should be your first and easy step. [...] 44756 350 22_Re: dynamic vs. static16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 12 Apr 2000 12:09:09 -0400653_- PeopleSoft applications are also almost fully dynamic SQL.

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Bill Disch [SMTP:bill.disch@GENMILLS.COM] > Sent: Wednesday, April 12, 2000 11:06 AM > To: DB2-L@RYCI.COM > Subject: Re: dynamic vs. static > > Look no further than Sap R/3. The application utilizes dynamic SQL almost > 100% and depends on the DB2 cache for performance (avoids PREPARE). > Another feature within R/3 is SAP Query which allows end users to create > ad-hoc requests. SAP Query is often turned off in Production to avoid > runaway queries. > > Bill [...] 45107 143 25_Re: SYSSTMT/TEXT contents20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 12 Apr 2000 12:04:22 -0400381_iso-8859-1 The bad new is - I could not find the REXX which I wrote to detect data-type mis-match.

The good new is - I happen to be working on a very similar one. This one uses REXX-DB2 interface but Does not detect any data-type mismatch instead, it reads the packstmt and formats the STMT to show the SQL along with all the input host-variable data-type definitions. [...] 45251 170 22_Re: What is in a name?0_19_Tim.Lowe@STPAUL.COM31_Wed, 12 Apr 2000 11:21:31 -0500555_us-ascii For the new DB2 version for the Unix, NT, OS/2 platform, will DB2 UDB V7/UNO be acceptable? Or, UWO for Unix, Windows, OS/2? When they come out with the next DB2 version for OS/390, will DB2 UDB V7/OS390 be acceptable? Once all supported releases of DB2 are UDB, will IBM "rebrand" again to eliminate the UDB in the name, or is this just additional baggage that we will always be asked to drag around? Is IBM objecting to any abbreviation or acronym at all? If not, can they suggest an acronym? We do need some kind of "short-hand". As they [...] 45422 98 33_Re: What's the point of Stogroups11_James Drewe20_James.Drewe@AEXP.COM31_Wed, 12 Apr 2000 09:36:13 -0700345_- Dave

The problem with using the default (SYSDEFLT) pool is that in some shops, disk space has to be charged back to a particular project -- and this complicates matters. If your shop doesn ,t get involved with disk space charge back, then it may work well until some "bean counter" wants to know why you aren ,t doing charge back. [...] 45521 19 33_Client Connectivity to DB2 OS/39016_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Wed, 12 Apr 2000 12:53:45 -0400306_iso-8859-1 Hey Folks.. I'm trying to get connectivity to DB2 OS/390 from a Window's '98 client without having to go through a gateway. We have DB2 Connect EE for our WEB server's, do I have to put the same on my client? Thanks...

Michael Dempsey Data Base Administration UNC Health Care System [...] 45541 26 27_Checking for Altered Tables13_Moss, William15_MossW@AETNA.COM31_Wed, 12 Apr 2000 13:19:18 -0400513_- I'm looking for a way to determine that if a table that has been altered to add a new column, has the table been reorged after the alter ? I have a list of tables whose ALTEREDTS is greater than their CREATEDTS so I know the tables have been altered, but I can't look at the SYSCOPY table to check for reorg dates because some of the tables were altered last year and the information for these tables is gone from SYSCOPY. Is there a byte in the header page of the tablespace I can look at to determine if [...] 45568 43 37_Re: Client Connectivity to DB2 OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 12 Apr 2000 13:23:08 -0400640_- Your choices -

DB2 Connect Personal Edition (PE) on Win 98 client <--> TCP/IP or SNA <--> DB2 OS/390



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

> ---------- > From: Dempsey, Michael[SMTP:MDempse@UNCH.UNC.EDU] > Sent: Wednesday, April 12, 2000 12:53 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Client Connectivity to DB2 OS/390 > > Hey Folks.. > I'm trying to get connectivity to DB2 OS/390 from a Window's '98 > client > without having to go through a gateway. We have DB2 Connect EE for our > WEB > server's, do I have to put the same on my client? Thanks... > > [...] 45612 29 16_UDB CCA Question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Apr 2000 13:19:53 -0400452_- We have a webserver that connects to a UDB database on Unix. The datasource is being changed to point a new Unix box with the same datasource (database) name. When we change the host name, update the datasource and access the database via the web application, it is actually selecting data from the old database on the old host. Yet, when we use command center to access the datasource, it retrieves the data from the new database and new host. [...] 45642 38 37_Re: Client Connectivity to DB2 OS/39011_Danny Davis16_DTDAVIS@PCMH.COM31_Wed, 12 Apr 2000 13:37:36 -0400551_US-ASCII DB2 Connect Personal Edition is the solution for connecting from the pc directly to the mainframe. PE places the integrated SNA stack directly on the pc's hard drive.

Danny Davis Systems Analyst Univerity Health Systems dtdavis@pcmh.com

>>> "Dempsey, Michael" 04/12/00 12:53PM >>> Hey Folks.. I'm trying to get connectivity to DB2 OS/390 from a Window's '98 client without having to go through a gateway. We have DB2 Connect EE for our WEB server's, do I have to put the same on my client? Thanks... [...] 45681 53 20_Re: UDB CCA Question14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 12 Apr 2000 13:43:10 -0400495_iso-8859-1 Peter,You can't catalog the same datasource twice on the same machine. Are you sure it worked? Seems to be you are pointing to the original datasource. Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Krawetzky, Peter J Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, April 12, 2000 1:19 PM Subject: UDB CCA Question [...] 45735 73 20_Re: UDB CCA Question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Apr 2000 13:41:29 -0400697_- The datasource stays the same but the host name is changing.





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





-----Original Message----- From: Philip Gunning [mailto:pgunning@BOSCOVS.COM] Sent: Wednesday, April 12, 2000 1:43 PM To: DB2-L@RYCI.COM Subject: Re: UDB CCA Question



Peter,You can't catalog the same datasource twice on the same machine. Are you sure it worked? Seems to be you are pointing to the original datasource. Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS [...] 45809 109 20_Re: UDB CCA Question21_Sean M O'Keefe/AC/VCU15_sokeefe@VCU.EDU31_Wed, 12 Apr 2000 13:49:39 -0400576_us-ascii Did you catalog the 'new' node for the database on the new box?







"Krawetzky, Peter J" To: DB2-L@RYCI.COM Subject: Re: UDB CCA Question

04/12/2000 01:41 PM Please respond to DB2 Data Base Discussion List













The datasource stays the same but the host name is changing.





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301 [...] 45919 101 20_Re: UDB CCA Question14_Philip Gunning20_pgunning@BOSCOVS.COM31_Wed, 12 Apr 2000 13:56:09 -0400420_iso-8859-1 Sounds to me like you are still pointing to the old host. Delete the datasource and re-add it making sure that it is pointing to the new host. You should then be ok. Somewhere it is still picking up the old one. Delete the old datasource, and if you get connection errors that will tell you someone is using the old one. Find out where they are coming in from, change it there and you should be ok, Phil [...] 46021 53 27_Re: Reading root page only?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 12 Apr 2000 13:53:10 -0400462_us-ascii Peter

The entry on the root page can't be used for result sets. This is because the index-entry on the root page or non-leaf pages has highest value (for ascending index and inverted high value for descending index) possible and also could be truncated. This means root page can have entry which does not even exist in the data page or leaf page (because it is just highest possible value in those page ranges not necessarily a real value). [...] 46075 16 31_Static SQL interface to DB2/39013_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 12 Apr 2000 12:32:45 -0500382_- Is there any support for static SQL for PC based development tool accessing data on DB2 for OS/390. I mean a VC++ ( or VB or PowerBuilder ) running on a Wintel PC accessing data through a static SQL interface rather than ODBC. I've heard of SQLJ but is it applicable to other languages ? Does the Java program utilizing SQLJ has to necessarily execute on S/390? TIA Mohammad [...] 46092 90 37_Re: DB2 Version 6 - Migration Problem0_29_paul.packham@POSTOFFICE.CO.UK31_Wed, 12 Apr 2000 18:59:42 +0000503_us-ascii Pat,

The Catmaint utility works in mysterious way and the example below is no exception. It seems to indicate that you are violating a check constraint, but as far as I can gather there should be none defined on sysuserauth.

Are you sure you are running catmaint on a V5 catalog ? Also have you completed the required pre-reqs i.e. got rid of all TYPE 1 indexes, dropped views from syscoldist & syscoldiststats, do you have any shared read-only data, or data set passwords ? [...] 46183 126 20_Re: UDB CCA Question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 12 Apr 2000 14:07:37 -0400439_- I tried each step below. The only thing that we have come up with here is that the server must be recycled so whatever information is in memory is gone and the reboot picks up the new definition. Funny thing is I performed the same steps on another server in another location and it worked fine. All I did was change the host property of the datasource, saved it, and that webserver was pointing to the new database on the new box. [...] 46310 59 31_Re: Checking for Altered Tables19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 12 Apr 2000 13:31:04 -0500248_iso-8859-1 Hi Bill, I had to stop my research but think I got close to the info you need. I think the info is in the DBD. Go to page 348 in the Diagnosis Gde. and Ref. for DB2 UDB/OS390 V5. See OBDREVLF of Record Type OBD as a starting point. [...] 46370 79 20_Re: Smart Optimizer?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 12 Apr 2000 14:47:12 -0400396_us-ascii Few things about IN list.

IN list is treated like multiple matching index scans. For example:-

IN (C1,C2,C3) is equivalent to =C1 ; =C2 ; =C3;

If IN list is long and BETWEEN can be used then BETWEEN is preferable.

If IN list exceeds 50% row threshold then IN list is ignored.

IN list can't use list prefetch until index screening APAR is applied. [...] 46450 44 39_DB2 Stored Procedures - Debugging Tools15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Wed, 12 Apr 2000 15:30:31 -0400351_windows-1252 We are coding DB2 COBOL LE/370 stored procedures and would like to test them using an interactive debugging tool. I came across some advice on the list that suggests turning on run time and compile time debug options in the stored procedure code, but we’re looking for a tool that is more interactive. Anyone using a tool like this? [...] 46495 34 40_DB2 Stored Procedures - Language Choices15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Wed, 12 Apr 2000 15:43:32 -0400509_windows-1252 We’re looking for the pros/cons of coding DB2 stored procedures with COBOL vs. Java vs. the new SQL Procedures language.

We plan to use COBOL because of the large knowledgebase of mainframe programmers at our shop. But we’re exploring the possibilities of SQL Procedures and Java.

Our environment is DB2 5.1 on OS/390 2.5 using IBM DB2 ODBC driver 5.2 via the IBM DB2 Connect gateway 5.2. The stored procedures will be called from VB 6 applications and intranet/internet apps. [...] 46530 41 35_Re: DB2 Service Wait Times (answer)10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Wed, 12 Apr 2000 15:49:03 -0500586_us-ascii Well, no one has had any guesses on my 5 1/2 hour DB2 Service Wait times. So here's what we have discovered:

The DB2 Service Wait times also include 'parallelism evaluation' - this isn't in the manuals for DB2PM or Omegamon explanations. At a cost of approximately 2 MS per, if you do the math on the reports, it's about 2.06 MS for each wait. The package that was running had been rebound 3/20/00 after reorging & runstating the tablespaces & indexspaces in the package, with DEGREE(ANY). The Omegamon reports I included in my first message appear to support this [...] 46572 80 66_Repost: Beta Program for DB2 UDB for UNIX, Windows, OS/2 Version 713_Morrill, John12_JohnM@VP.NET31_Wed, 12 Apr 2000 15:02:12 -0600575_- Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

The beta program for Version 7 of DB2 UDB for UNIX, Windows, OS/2 is now open. Go to http://www.ibm.com/software/data/db2/udb/v7/beta/ for free download of the beta code. [...] 46653 57 58_Repost: Webinar: DB2 UDB for UNIX, Windows, OS/2 Version 713_Morrill, John12_JohnM@VP.NET31_Wed, 12 Apr 2000 15:28:54 -0600611_- Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

You may want to listen to the summary presentation on DB2 UDB for UNIX, Windows, OS/2 Version 7 available now on IBM's "Webinar" site at http://webevents.broadcast.com/ibm/db2certificateprep022000/home.tl . [...] 46711 60 35_Re: DB2 Service Wait Times (answer)22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 12 Apr 2000 17:49:04 -0400644_- I'm interested in the end results.



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

> ---------- > From: Missy Case[SMTP:Missy.Case@FIRSTDATACORP.COM] > Sent: Wednesday, April 12, 2000 4:49 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DB2 Service Wait Times (answer) > > Well, no one has had any guesses on my 5 1/2 hour DB2 Service Wait times. > So here's what we have discovered: > > The DB2 Service Wait times also include 'parallelism evaluation' - this > isn't in the manuals for DB2PM or Omegamon explanations. At a cost of > approximately 2 MS per, if you do the math on [...] 46772 47 35_Re: DB2 Service Wait Times (answer)12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 12 Apr 2000 17:02:00 -0400596_- Please post the results, we will be very interested. And Thanks.

>>> DB2-L@RYCI.COM@inter2 04/12/00 03:41PM >>> Well, no one has had any guesses on my 5 1/2 hour DB2 Service Wait times. So here's what we have discovered:

The DB2 Service Wait times also include 'parallelism evaluation' - this isn't in the manuals for DB2PM or Omegamon explanations. At a cost of approximately 2 MS per, if you do the math on the reports, it's about 2.06 MS for each wait. The package that was running had been rebound 3/20/00 after reorging & runstating the tablespaces & indexspaces in the [...] 46820 228 37_Re: DB2 Version 6 - Migration Problem12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Wed, 12 Apr 2000 18:11:34 -0400370_iso-8859-1 3 things:

a) Did you run the Check Index and DSN1COPY w/check utilities on your catalog to make sure nothing was broken?

b) Did you run DSNTIJP or the DSNTESQ queries to verify that you don't have any unsupported objects? like -- No TYPE 1 Indexes IF you found Type 1, did you convert them? -- No dataset passwords -- Shared Read Only DATA [...] 47049 31 43_Re: DB2 Dual Logging to Single logging mode15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 12 Apr 2000 08:15:54 -0500515_us-ascii What type of DASD do you have?



Massimo Scarpa wrote: > > Why can't you use dual logging with ONE archive log only ? > > Just yesterday we lost a SPARE DASD and another SPARE was not so good..... Are > you so > > reckless ? If so I envy you !!! > > Regards > > Max Scarpa > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l The owners of the list can be reached a [...] 47081 717 33_Re: What's the point of Stogroups16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Wed, 12 Apr 2000 18:46:02 -0400558_iso-8859-1 We do not have ESS yet either, but my IOSQ times are 0 most of the time. Occasionally we may have one that will not be and very rarely one that gets to 15-20 milliseconds. Each of our RVA units have 8 paths and each also has 2 gig of internal cache (compressed 3.6 times). Anyway, my whole point was that the statement shouldn't have been so absolute. As with most things connected with DB2 ---- it depends ---- on individual factors for individual shops. Personally I really enjoy not having to watch space for about 40,000 datasets all the [...] 47799 91 33_Re: What's the point of Stogroups15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 12 Apr 2000 08:34:53 -0500357_us-ascii My company, SolarFlare Software, came out with DASDivide for precisely the IOSQ problem described below. All the hardware vendors didn't want to 'fess up to this problem (for the past few years). So, IBM came out with Shark (and a bunch of MVS/OS390 PTFs) to get around the IOSQ problem. Doesn't that prove there has been a problem all along? [...] 47891 31 18_DB2 v6 parallelism12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 12 Apr 2000 18:41:03 -0500352_us-ascii Hi All, We have the Peoplesoft Financials Release 6 application running in DB2 for OS/390 v5.1. It is in its own separate DB2 subsystem for purely political reasons. We have several other DB2 V5.1 subsystems, and we have a test DB2 UDB for OS/390 V6.1 subsystem up on the same LPAR where we are testing Peoplesoft Financials Release 7.5. [...] 47923 48 23_Question about triggers18_Centro de Computos21_iplc05@INFOVIA.COM.AR31_Wed, 12 Apr 2000 20:40:16 -0300498_us-ascii Hi all !

Two questions:

1) I've made an after update trigger on a table, which inserts one row in the same table. The trigger has a WHEN clause which tests the value of a column, and the row inserted by the trigger is asigned a value in this field that avoids recursive calls, but nonetheless I receive the message "The application heap size is not large enough to process this command".Is the trigger working recursively? Is there any other way to trigger this insert? [...] 47972 109 20_Re: Smart Optimizer?14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Thu, 13 Apr 2000 10:07:54 +1000581_us-ascii A very good answer from Venkat.

I have noticed that AND COL IN (2,2) or AND COL IN (:hostv1,:hostv1) does not perform measurably worse than equals predicate for non list prefetch access paths and does not return twice as many rows even for access type = 'N'. So it seems that DB2 does not do it twice. I have used this technique to disable transitive closure in joins. I believe that DB2 must sort the list in memory to enable it to recognize duplicates and skip the duplicate. Otherwise potentially twice as many rows would be returned, i.e. duplicates, when [...] 48082 14 16_Re: CAF Question20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 12 Apr 2000 21:25:17 EDT343_US-ASCII Thanks Linda Claussen and James Campbell. I found the message on the DB2 master. Thanks. Ed.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 48097 80 28_UDB PDE Installation Problem29_Sireesh Chandra.M,J16 Chennai25_msireesh@MSDC.HCLTECH.COM31_Thu, 13 Apr 2000 07:46:38 +0530437_windows-1252 Hi, When I try to install DB2 UDB Personal Developer Edition V6.1, I get the following error. ------------------------------------------------------- An error occurred during the move data process: -132

Component: File Group: File: -------------------------------------------------------

Did anyone face this problem?? I have downloaded the software from IBM site. Its a 60 day trial offer.

TIA Sireesh. 48178 51 35_Re: Static SQL interface to DB2/39010_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 13 Apr 2000 03:21:43 GMT305_us-ascii Hi , I have got DB2 V6 for windows NT and it has got DB2 software development kit with DB2 connect.I think your purpose of writing static sqls through PC to access the data can be obtained by having these 2 components. Download a trail copy of DB2 V6 and install those two components in PC. [...] 48230 49 22_Re: DB2 v6 parallelism24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Wed, 12 Apr 2000 22:45:40 -0500427_- Kirk,

We are running Peoplesoft financials version 5.1 in a dedicated DB2 (v5.1) production subsystem. We also have a small amount of PS 7.5 in the same subsystem. We turned on dynamic caching about a year ago and have had very good results. You may want to consider it.

I do not know what are cdssrdef setting is since I'm out of the office, but I will look into it since we are planning for DB2 v6 also. [...] 48280 31 35_FW: Static SQL interface to DB2/39014_Richard Bourke25_Richard.Bourke@MERANT.COM31_Thu, 13 Apr 2000 09:23:07 +0200406_- Mohammed, there are several 3rd party products that allow this. Merant, where I work, makes one of them (ConnectPremium for DB2). You are still using VC++/VB/Powerbuilder/Access/Excel/Delphi/whatever it is. You are also stil using odbc, since that is what allows the openness to so many front-ends environments. The transformation to static sql takes place transparently to the application. Richard [...] 48312 53 20_Re: UDB CCA Question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 13 Apr 2000 05:06:47 -0400426_- The solution to this problem was to stop the web services on the NT server and restart them. Looks like once an ODBC connection is made, it's persistent. Any changes made to the datasource are unaffected until the web services restart.

Thanks for all the replies!





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301 [...] 48366 20 22_Re: DB2 v6 parallelism0_29_paul.packham@POSTOFFICE.CO.UK31_Thu, 13 Apr 2000 10:41:38 +0000538_us-ascii Kirk,

We were running with CDSSRDEF=ANY set on our SAP systems. Like you when we went to DB2 v6 we encountered numerous problems which made us turn parallelism off. The problems we encountered were to do with performance & also some issues with DB2PM.

Regards, Paul Packham

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 48387 273 33_Re: What's the point of Stogroups19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Apr 2000 07:11:26 -0500610_iso-8859-1 Andrea, Could you please send me the name and phone number of the storage administrator who set up your DB2 ACS routines? Please do this directly rather than using db2-l!



Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from [...] 48661 55 40_DB2 V4 ABEND + Termination during reorg.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Apr 2000 14:51:01 +0200509_us-ascii Our subsidiary with DB2 V 4 experimented twice a katastrofic abend while executing many

reorgs in parallel. There are no problems until, suddenly, DB2 abend with a message:

*** DSNV086E - DB2 ABNORMAL TERMINATION REASON=00E50702 ***

Looking with attention they can see only dump request by DB2 like:

*** DUMPID=001 REQUESTED BY JOB (DB1ADBM1) *** *** DUMP TITLE=DB1A,ABND=04E-00C2010E,U=SYSOPR ,C=XYR00.410.BMC -D *** SNB5CMA,M=DSNTFRCV,LOC=DSNBBM .DSNB1LPL+07AC *** [...] 48717 69 35_Re: DB2 Service Wait Times (answer)11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 13 Apr 2000 08:54:24 -0400586_ISO-8859-1 Missy

Some thoughts to throw into the pot now that you mention parallelism and Data Sharing. Could the program be using Sysplex Query parallelism? Maybe it is waiting for results to be returned from other members of the group. This could also lead to lots of messages via IRLM to return the result sets. I suspect that the Omegamon information you posted is only for the originating member and does not show the activity on the assisting members. I also note in the Omegamon data that Max Degree is one indicating that only one parallel stream maximum ran on the [...] 48787 48 22_Re: Buffer Pool Tuning14_Lisa Ouellette29_Lisa.Ouellette@FIRSTUNION.COM31_Thu, 13 Apr 2000 07:52:52 -0500476_- Thanks everyone for their suggestions and directions to good doc! I'm still interested in knowing what metric would show the delays caused by a system checkpoint having to flush the buffer pool. Does that show up in Class 3 I/O wait?

I did go look at application % of Class 3 I/O wait to Class 2 Elapsed - I think this is a great idea and a good metric for measuring success. For your interest from one of our smaller production DB2 subystems - all bufferpools: [...] 48836 187 57_Re: DB2-L Digest - 12 Apr 2000 to 13 Apr 2000 (#2000-109)0_19_ddzienni@US.IBM.COM31_Thu, 13 Apr 2000 09:00:09 -0400400_us-ascii 22. Cancelling threads asynchronously - is there a way to do it in batch?

Yes, I have used a batch method which consists of capturing the DB2 display output and formatting the MVS cancel command with IEBGENER then passing it to the program NST560 for execution. I use 2 procs which makes JCL updates and maintenance easier. You also need authority to execute the NST560 program. [...] 49024 24 35_Re: Static SQL interface to DB2/39013_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 13 Apr 2000 08:56:40 -0500393_- On Thu, 13 Apr 2000 03:21:43 GMT, Sanjeev .. wrote:

>Hi , > I have got DB2 V6 for windows NT and it has got DB2 software >development kit with DB2 connect.I think your purpose of writing static >sqls through PC to access the data can be obtained by having these 2 >components. >Download a trail copy of DB2 V6 and install those two components in PC. > [...] 49049 84 44_Re: DB2 V4 ABEND + Termination during reorg.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Apr 2000 09:12:01 -0500620_iso-8859-1 Max, I might have found a hit in the APARs. See APAR PQ09771. Do you have PTFs UQ12694 UQ12695 installed?

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...] 49134 24 30_Coding for -811 on SELECT INTO12_John Cameron26_JCameron@MSI-INSURANCE.COM31_Thu, 13 Apr 2000 09:15:58 -0500354_us-ascii I have always coded a cursor and a single fetch when I need one row where many could be returned. Someone here is telling me that I should use a singleton select (SELECT INTO) and handle SQLCODE -811 the same as a zero. Do the host variables actually get the values of the first row, or are they whatever value they were before execution ? [...] 49159 46 34_Re: Coding for -811 on SELECT INTO20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 13 Apr 2000 10:27:03 -0400461_us-ascii Yes. DB2 currently populates the host variables even when -811 SQLCODE is issued. But this is not a recommended method because the future release of DB2 may not do the same.

Ideally a cursor should be opened whenever more than 1 row is expected.



-----Original Message----- From: John Cameron [SMTP:JCameron@MSI-INSURANCE.COM] Sent: Thursday, April 13, 2000 10:16 AM To: DB2-L@RYCI.COM Subject: Coding for -811 on SELECT INTO [...] 49206 30 34_Re: Coding for -811 on SELECT INTO13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 13 Apr 2000 10:32:45 -0400467_iso-8859-1 Hi John, You might want to search the archives on this topic. Every few months seems like there's a new religious-war level discussion of this.

I am in the camp that believes that IBM has clearly stated that the results found in host variables after a -811 are unpredictable and it's a very bad idea to code programs tolerating -811 and using data from host variables after -811 -- no matter what the circumstancial evidence seems to indicate. [...] 49237 42 34_Re: Coding for -811 on SELECT INTO13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Thu, 13 Apr 2000 15:30:00 +0100565_- John if you use the -811 way you cannot guarantee any data in any host variables.

Ian McDonald DB2 DBA Abbey National ---------- From: John Cameron To: DB2-L@RYCI.COM Subject: Coding for -811 on SELECT INTO Date: 13 April 2000 15:15

I have always coded a cursor and a single fetch when I need one row where many could be returned. Someone here is telling me that I should use a singleton select (SELECT INTO) and handle SQLCODE -811 the same as a zero. Do the host variables actually get the values of the first row, or are they whatever value [...] 49280 62 34_Re: Coding for -811 on SELECT INTO19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Apr 2000 09:31:34 -0500552_iso-8859-1 Hi John, This is no reflection on you but, jeez, this question comes up too often. IBM has stated in several manuals that you should not rely on data returned when a -811 occurs. However, for every Version of DB2 thus far, the host variables are populated with whatever the first row is based on your SELECT predicates. What IBM is trying to say, and very few appear to be listening, is that in the future the host variables may NOT be populated because a -811 is, in fact, an ERROR situation. As others on this list have mentioned and [...] 49343 25 44_Re: DB2 V4 ABEND + Termination during reorg.14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 13 Apr 2000 16:39:17 +0200539_us-ascii Davis, Rick,

Thanks for answers !

Even if we don't have GBP the APAR seems to describe the problem of my collegues.

They are checking if PTF were applied (I believe PTF were NOT applied).....



Thanks again & Regards

Max Scarpa System & Data Admin

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 49369 56 34_Re: Coding for -811 on SELECT INTO14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Thu, 13 Apr 2000 09:52:15 -0500554_iso-8859-1 John,

This topic always sets off a MAJOR battle of words, but let me just throw out my $0.02 worth...

If you need to use the data, code the cursor & fetch. -811 will probably return data from one row or the other, but it may not be what you really wanted, and it may not always do this (IBM does not promise that it will...). Furthermore, the cursor is clearer from a maintenance perspective, as user needs and data change. Your users may decide they always want the first (or last) record based on the values you're using. [...] 49426 53 35_Re: Static SQL interface to DB2/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 13 Apr 2000 10:59:35 -0400337_- ODBC is typically dynamic but it doesn't have to be. ODBC is used for static SQL also.

- DB2 Connect offers static SQL using Call Level Interface (CLI) - SQLJ - We use StarSQL from Star Quest to execute static SQL initiated from a Microsoft ASP application on an IIS web server. The same can be done with a VB application. [...] 49480 59 31_Re: Checking for Altered Tables9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 13 Apr 2000 16:23:48 +0100624_iso-8859-1 Bill,

As a reorg (and load replace) performs a delete and redefine of the dataset, the created date on ISPF menu 3.4 should help.

Jim.

-----Original Message----- From: Moss, William [mailto:MossW@AETNA.COM] Sent: 12 April 2000 18:19 To: DB2-L@RYCI.COM Subject: Checking for Altered Tables



I'm looking for a way to determine that if a table that has been altered to add a new column, has the table been reorged after the alter ? I have a list of tables whose ALTEREDTS is greater than their CREATEDTS so I know the tables have been altered, but I can't look at the SYSCOPY [...] 49540 23 49_relative dispatching priorities of address spaces15_Belfield, Al G.15_AGBELFI@TWA.COM31_Thu, 13 Apr 2000 10:21:36 -0500516_iso-8859-1 Is there any recent documentation about setting the dispatching priorities of the DB2 address spaces? I found some discussion about the priority of the DIST address space in the redbook 'DB2 V4 Non-DS Perf. Topics' SG24-4502-00 but is there something more recent? We're starting to use Stored Procedures which will be called by PC clients, so the recommendations about the SPAS and DIST address spaces are my main area of interest. We'll be using the DB2-established SPAS address space not WLM ones. [...] 49564 118 53_Re: relative dispatching priorities of address spaces15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 13 Apr 2000 17:36:42 +0100554_us-ascii Hello Alma,

Is the information in the DB2 V6 admin guide about setting address space priorities recent enough?



The following was cut/pasted from that book.





Review the following SRM options when installing or tuning a DB2 subsystem (see also DB2 Installation Guide). Be aware that there are special considerations for where you place the address space for the distributed data facility. Generally, set MVS processor dispatching priorities in the following order, from highest to lowest priority: [...] 49683 103 31_Re: Checking for Altered Tables15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 13 Apr 2000 17:40:00 +0100535_us-ascii Jim,

Unless you use the REUSE option.....

REUSE When used with SHRLEVEL NONE, specifies that REORG logically resets and reuses DB2-managed data sets without deleting and redefining them. If you do not specify REUSE and SHRLEVEL NONE, DB2 deletes and redefines DB2-managed data sets to reset them.

Regards,



Toine Michielse DB2 for OS/390 Technical Specialist Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 49787 83 31_Re: Checking for Altered Tables22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 13 Apr 2000 11:43:13 -0400676_- Assuming the REUSE option was not specified.



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

> ---------- > From: Jim Leask[SMTP:jim.leask@RS-COMPONENTS.COM] > Sent: Thursday, April 13, 2000 11:23 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Checking for Altered Tables > > Bill, > > As a reorg (and load replace) performs a delete and redefine of the > dataset, > the created date on ISPF menu 3.4 should help. > > Jim. > > -----Original Message----- > From: Moss, William [mailto:MossW@AETNA.COM] > Sent: 12 April 2000 18:19 > To: DB2-L@RYCI.COM > Subject: Checking for Altered Tables > > > I'm looking for [...] 49871 89 34_Re: Coding for -811 on SELECT INTO16_Michael McMorrow25_michael.g.mcmorrow@AIB.IE31_Thu, 13 Apr 2000 16:49:22 +0100521_ISO-8859-1 Hi, On the 'Existence Checking' front, the use of Singleton Select with subsequent SQLCODE/SQLSTATE interpretation is a common approach and comes with IBM imprematur (Redbook SG24-2233-00....'DB2 for OS/390 Application Design for High Performance' ....Section 3.8.2). So it is, at least, a legitimate technique. Performance winner of (A) Overhead of Open/Close Cursor versus (B) Overhead of Singleton Select searching for a second row depends on access paths and I guess has been widely debated. Michael. [...] 49961 121 31_Re: Checking for Altered Tables9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 13 Apr 2000 16:53:06 +0100550_iso-8859-1 Toine,

Good point.

Jim.

-----Original Message----- From: Toine Michielse [mailto:vndobtm@US.IBM.COM] Sent: 13 April 2000 17:40 To: DB2-L@RYCI.COM Subject: Re: Checking for Altered Tables



Jim,

Unless you use the REUSE option.....

REUSE When used with SHRLEVEL NONE, specifies that REORG logically resets and reuses DB2-managed data sets without deleting and redefining them. If you do not specify REUSE and SHRLEVEL NONE, DB2 deletes and redefines DB2-managed data sets to reset them. [...] 50083 134 53_Re: relative dispatching priorities of address spaces15_Belfield, Al G.15_AGBELFI@TWA.COM31_Thu, 13 Apr 2000 10:49:40 -0500490_iso-8859-1 Thanks, that'll teach me to use better search strings in Acrobat! I've now managed to find the corresponding section in the V5 manual.

-----Original Message----- From: Toine Michielse [mailto:vndobtm@US.IBM.COM] Sent: Thursday, April 13, 2000 11:37 AM To: DB2-L@RYCI.COM Subject: Re: relative dispatching priorities of address spaces



Hello Alma,

Is the information in the DB2 V6 admin guide about setting address space priorities recent enough? [...] 50218 22 18_Extents question ?23_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Thu, 13 Apr 2000 12:11:47 -0400556_iso-8859-1 Hi All, I would like to know , if a db2 dataset (either Tablespace or an Index) running into extents have impacts on STATS like LEAFDIST , FAROFFPOS, NEAROFFPOS ?? It affects the I/O yes, how and what about these stats.

Thank you regards

Kaushal Trivedi DBA Universal Biller (732)-457-2858

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 50241 30 53_Re: relative dispatching priorities of address spaces12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 13 Apr 2000 11:07:00 -0400641_- II08461 was an old V3 info APAR regarding dispatching priorities. It did not discuss WLM.

>>> DB2-L@RYCI.COM@inter2 04/13/00 10:29AM >>> Is there any recent documentation about setting the dispatching priorities of the DB2 address spaces? I found some discussion about the priority of the DIST address space in the redbook 'DB2 V4 Non-DS Perf. Topics' SG24-4502-00 but is there something more recent? We're starting to use Stored Procedures which will be called by PC clients, so the recommendations about the SPAS and DIST address spaces are my main area of interest. We'll be using the DB2-established SPAS address space not [...] 50272 31 46_Shadow Direct, DB2 V5.1 and Stored Procedures.6_JS DBA18_js_dba@HOTMAIL.COM29_Thu, 13 Apr 2000 17:15:43 BST316_- Hi,

We are in the middle of installing DB2 V5.1.

The question of stored procedures was raised. One of the features of DB2 V5.1 is that it can now return result sets to the application instead of a block of data.

It appears that multiple result sets are supported by DRDA. My question is; [...] 50304 51 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 13 Apr 2000 12:23:09 -0400399_us-ascii Unfortunately No. The return of result sets (by just using OPEN in the main procedure) using DB2 stored procedure is exclusive with DB2 stored procedure. No one else (3rd party) has done it so far.

-----Original Message----- From: JS DBA [SMTP:js_dba@HOTMAIL.COM] Sent: Thursday, April 13, 2000 1:16 PM To: DB2-L@RYCI.COM Subject: Shadow Direct, DB2 V5.1 and Stored Procedures. [...] 50356 57 22_Re: Buffer Pool Tuning14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 13 Apr 2000 12:29:39 -0400552_ISO-8859-1 Message text written by DB2 Data Base Discussion List >Thanks everyone for their suggestions and directions to good doc! I'm still interested in knowing what metric would show the delays caused by a system checkpoint having to flush the buffer pool. Does that show up in Class 3 I/O wait?< +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + Yes, it will show as increased IO elapsed times during and immediately after a checkpoint. Just to check on your buffer pool hit ratios, the correct formula to use is: [...] 50414 73 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Thu, 13 Apr 2000 11:35:02 -0500598_- Richard, I think you can. We connect to DB2 V5 using StarSQL ODBC driver. If Neon's Shadow direct can handle ODBC 3.0 Call statement, it should pass the result set to the client apps from DB2. Peavy

> ---------- > From: Pillay, Venkat (PCA)[SMTP:venkat_pillay@ML.COM] > Reply To: DB2 Data Base Discussion List > Sent: Thursday, April 13, 2000 11:23 AM > To: DB2-L@RYCI.COM > Subject: Re: Shadow Direct, DB2 V5.1 and Stored Procedures. > > Unfortunately No. The return of result sets (by just using OPEN in the > main procedure) using DB2 stored procedure is exclusive with DB2 stored [...] 50488 217 33_Cancelling threads asynchronously0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Thu, 13 Apr 2000 11:43:37 -0500421_us-ascii Hi Dwayne, This is great info. Thanks for supplying the detail. I'm afraid I'm not familiar with NST560. Can you tell me more about what it is and where you get it from?

Shan Leatherman DBA Specialist American Century Services









ddzienni@US.IBM.COM on 04/13/2000 08:00:09 AM





Please respond to DB2 Data Base Discussion List [...] 50706 128 31_Re: Checking for Altered Tables22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 13 Apr 2000 12:43:38 -0400668_- Toine -

What happens if you do not specify REUSE and specify SHRLELVEL NONE, and the data set is not DB2 managed.



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

> ---------- > From: Toine Michielse[SMTP:vndobtm@US.IBM.COM] > Sent: Thursday, April 13, 2000 12:40 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Checking for Altered Tables > > Jim, > > Unless you use the REUSE option..... > > REUSE When used with SHRLEVEL NONE, specifies that REORG logically > resets and reuses > DB2-managed data sets without deleting and redefining them. > If you do not specify REUSE and > SHRLEVEL NONE, DB2 [...] 50835 171 31_Re: Checking for Altered Tables15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 13 Apr 2000 19:15:50 +0100385_us-ascii Hello Mike,

REORG will not delete/reallocate a user managed dataset. So if you would like to change the dataset characteristics you'd have to to an UNLOAD PAUSE, delete/redefine the dataset, and resume the REORG. I guess that's why they are called 'user-managed'.

For SHRLEVEL REFERENCE/CHANGE the user is also responsible for defining the shadow datasets. [...] 51007 116 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 13 Apr 2000 13:29:07 -0400363_us-ascii Peavy

I am not sure what kinds of result set you are mentioning. But DB2 stored procedure has a feature in which you could open a cursor inside the stored procedure and client program can fetch the result one by one before closing the cursor outside of stored procedure. The same can be done through a Cobol program using associate locators. [...] 51124 37 27_Information on Deleted rows18_Sekar.S (Exchange)18_Sekar.S@TARGET.COM31_Thu, 13 Apr 2000 12:18:45 -0500566_iso-8859-1 Hi All, We have a problem in our shop DB2/OS-390 like "all of sudden "2 million rows were gone in a table". I will explain the situation.

We usually take the full image copy of the whole database on each day morning 1:00am. Then there will be lot of insertion of rows and updates during the whole day using CICS screen. Also during the day time, there will be some batch jobs just read the tables for creating the reports. Suddenly sometime in evening users started complaining a problem in online and when we analyze, we found that the table [...] 51162 127 34_Re: Coding for -811 on SELECT INTO16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Thu, 13 Apr 2000 14:04:35 -0400602_- They will have the values of the first row DB2 returns.

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: John Cameron [SMTP:JCameron@MSI-INSURANCE.COM] > Sent: Thursday, April 13, 2000 10:16 AM > To: DB2-L@RYCI.COM > Subject: Coding for -811 on SELECT INTO > > I have always coded a cursor and a single fetch when I need one row where > many could be returned. > Someone here is telling me that I should use a singleton select (SELECT > INTO) and handle SQLCODE > -811 the same as a zero. Do the host variables actually [...] 51290 57 31_Re: Information on Deleted rows11_Kwan, James18_James_Kwan@BMC.COM31_Thu, 13 Apr 2000 13:12:29 -0500447_ISO-8859-1 Sekar,

I think you can still find out what happened using log analyzer as long as the logs are still there. Have someone with proper authority to scan the log with table filtering to see what has happened during that time.

James Kwan

-----Original Message----- From: Sekar.S (Exchange) [mailto:Sekar.S@TARGET.COM] Sent: Thursday, April 13, 2000 12:19 PM To: DB2-L@RYCI.COM Subject: Information on Deleted rows [...] 51348 54 35_Re: Static SQL interface to DB2/39012_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 13 Apr 2000 11:13:47 -0700286_us-ascii What do you mean SQL interface static not like ODBC? You can have "Static" or "Dynamic" SQL with ODBC with no problems with ODBC from a number of different vendors. How else would you access DB2 for OS/390 unless you want to write your own DRDA routines and not use ODBC? [...] 51403 238 34_Re: Coding for -811 on SELECT INTO16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Thu, 13 Apr 2000 14:20:49 -0400492_- At the risk of jumping into the war -- :-) -- we used the -811 coding for existance when we didn't care about the data that was returned because it proved faster that the whole OPEN/FETCH/CLOSE process with the volume of data we were processing at the time. I will admit that that was several releases of DB2 ago and we have not benchmarked newer releases to see if that is still true. To me, the singleton select would be simpler when looking at it at 3:00am than the cursor process. [...] 51642 102 34_Re: Coding for -811 on SELECT INTO15_Johnson, Steven23_X2SJOHNS@SOUTHERNCO.COM31_Thu, 13 Apr 2000 13:42:38 -0500611_- We have a table that has several million rows with no unique index. Currently we use Select Distinct . Nobody has mentioned this as an option. Is an OPEN/FETCH/CLOSE faster than the Select Distinct.

Steven Johnson Applications DBA



> -----Original Message----- > From: Milligan, Andrea [SMTP:Andrea_Milligan@BCBST.COM] > Sent: Thursday, April 13, 2000 2:21 PM > To: DB2-L@RYCI.COM > Subject: Re: Coding for -811 on SELECT INTO > > At the risk of jumping into the war -- :-) -- we used the -811 coding for > existance when we didn't care about the data that was returned because it > [...] 51745 29 18_DB2 control center15_Philip, Sibimon27_Sibimon_Philip@CSXLINES.COM31_Thu, 13 Apr 2000 15:01:12 -0400543_iso-8859-1 > All list users, > > I am getting the following error when I start the control center in a > Window NT machine. I have no knowledge about JDBC. Please let me know if > anybody know the solution for this. I just installed DB2 personal edition > and DB2 connect. DB2 connect seems to be able to connect to DB2 Version > 5.1 on OS/390. > > [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01 > > thanks > Sibimon Philip > 972-813-5517 - Office > 972-417-3597 - Residence > E-mail - Sibimon_Philip@csxlines.com > > > [...] 51775 67 22_Re: DB2 control center13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Thu, 13 Apr 2000 15:21:25 -0400560_us-ascii Philip,,,, go to Start,,,,then settings...then control panel...then services... in services be sure that the db2 jdbc applet server (two of them) is started..

"Philip, Sibimon" wrote:

> > All list users, > > > > I am getting the following error when I start the control center in a > > Window NT machine. I have no knowledge about JDBC. Please let me know if > > anybody know the solution for this. I just installed DB2 personal edition > > and DB2 connect. DB2 connect seems to be able to connect to DB2 Version > > 5.1 on OS/390. [...] 51843 67 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.10_Mike Evans28_evansmp@CO.MECKLENBURG.NC.US31_Thu, 13 Apr 2000 13:00:43 -0400463_US-ASCII Richard, I believe that shadowdirect does support stored procedures with result sets. I'm not sure about multiple result sets but you should check with their tech. support.

>>> "Pillay, Venkat (PCA)" 04/13/00 12:23PM >>> Unfortunately No. The return of result sets (by just using OPEN in the main procedure) using DB2 stored procedure is exclusive with DB2 stored procedure. No one else (3rd party) has done it so far. [...] 51911 168 22_Re: DB2 control center13_Wilson, Randy22_Randy_Wilson@BCBST.COM31_Thu, 13 Apr 2000 15:21:20 -0400383_- Phil, This is the only doc I can find on it.... have you verified that the JDBC server is running in your system services? .. go to start/settings/control panel/ services .... and look for DB2 JDBC Applet server

hope this helps,

Randy Wilson



CLI0616E Error opening socket.

Explanation: Cannot open the socket to server, server may be down. [...] 52080 129 34_Re: Coding for -811 on SELECT INTO19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 13 Apr 2000 14:34:03 -0500629_iso-8859-1 Steven, DB2 UDB/OS390 V6 and earlier; SELECT DISTINCT requires a sort. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 52210 150 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.16_Dennis P Bennett20_dbennett@NEONSYS.COM31_Thu, 13 Apr 2000 14:45:26 -0500465_us-ascii



(Embedded image moved to file: pic32070.pcx) Dennis P Bennett @ NEON 04/13/2000 02:45 PM



Richard,

Shadow Direct has supported returning result sets from DB2 stored procedures and Shadow Remote Procedure Call programs for some time.

Recently we have added support for returning multiple result sets from DB2 stored procedures and Shadow RPCs.

If you have any questions please call at (800) 505-6366. [...] 52361 178 22_Re: DB2 control center18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Thu, 13 Apr 2000 15:20:19 -0400403_iso-8859-1 I get the same message too. I'm trying to get ahold of our client/server person here to find out what is going on but she's out... I've deinstalled DB2 Connect and resintalled and get the same msg. I can connect to my HOST DB2V5 subsystems so that is working. Just can't use this control center... It worked the other day but now I get this same msg.. Any help would be appreciate too.. [...] 52540 57 49_Connect to DB2 server on Linux from DB2 on OS/39011_Wang, Jason23_jason.wang@CHECKSOL.COM31_Thu, 13 Apr 2000 14:41:10 -0500355_iso-8859-1 Greeting all,

I am trying to connect to db2 server on linux from db2 on os/390 using DSNTIA51 program. DB2 catalog tables SYSIBM.LOCATIONS, SYSIBM.IPNAMES AND SYSIBM.USERNAMES have been populated with correct values (I think). However, I got the message "RDB NOT FOUND" when the program run (the detailed messages is as following): [...] 52598 25 35_Re: Static SQL interface to DB2/3900_22_Rohn.Solecki@MTS.MB.CA31_Thu, 13 Apr 2000 14:55:11 -0500407_us-ascii Is there any support for static SQL for PC based development tool accessing data on DB2 for OS/390. I mean a VC++ ( or VB or PowerBuilder ) running on a Wintel PC accessing data through a static SQL interface rather than ODBC. I've heard of SQLJ but is it applicable to other languages ? Does the Java program utilizing SQLJ has to necessarily execute on S/390? TIA Mohammad [...] 52624 109 50_Re: Shadow Direct, DB2 V5.1 and Stored Procedures.0_20_gabriele@NZ1.IBM.COM31_Fri, 14 Apr 2000 07:49:44 +1200431_us-ascii Richard,

a few years ago I worked for a customer who was running DB2 V4.1 and we installed Shadow Direct to provide TCPIP connectivity to ODBC clients and support for stored procedures returning multiple result sets.

Before the native TCPIP support was introduced in DB2 V5.1 and the consequent client support via DB2 Connect, Shadow Direct was a viable option to open DB2 for MVS to network computing. [...] 52734 64 22_Re: DB2 control center15_Philip, Sibimon27_Sibimon_Philip@CSXLINES.COM31_Thu, 13 Apr 2000 16:08:04 -0400502_iso-8859-1 Jimmy,

Thanks.. It was not started, so I stated it. Now if I click on control center, nothing is coming up. Does it take a longgggggggg time to come up first time?

Thanks Sibimon Philip 972-813-5517 - Office 972-417-3597 - Residence E-mail - Sibimon_Philip@csxlines.com







-----Original Message----- From: Jimmy Willett [mailto:Jimmy.Willett@NCMAIL.NET] Sent: Thursday, April 13, 2000 2:21 PM To: DB2-L@RYCI.COM Subject: Re: DB2 control center [...] 52799 98 22_Re: DB2 control center13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Thu, 13 Apr 2000 16:12:44 -0400518_us-ascii No, should not take too long to come up. Did you get the logon box? one other thing, your win nt logon id should only be 8 chrs or less and be part of the admin group on your machine.. i learned that lesson the hard way..

"Philip, Sibimon" wrote:

> Jimmy, > > Thanks.. It was not started, so I stated it. Now if I click on control > center, nothing is coming up. Does it take a longgggggggg time to come up > first time? > > Thanks > Sibimon Philip > 972-813-5517 - Office > 972-417-3597 - [...] 52898 44 34_Re: Coding for -811 on SELECT INTO13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Thu, 13 Apr 2000 15:51:30 -0500643_- On Thu, 13 Apr 2000 09:15:58 -0500, John Cameron wrote:

>I have always coded a cursor and a single fetch when I need one row where >many could be returned. >Someone here is telling me that I should use a singleton select (SELECT >INTO) and handle SQLCODE >-811 the same as a zero. Do the host variables actually get the values of >the first row, or are they >whatever value they were before execution ? > >TIA for any advise on this ! > >John Cameron >651.631.7188 >jcameron@msi-insurance.com > >================================================ >To change your subscription options or to cancel your [...] 52943 98 22_Re: DB2 control center15_Philip, Sibimon27_Sibimon_Philip@CSXLINES.COM31_Thu, 13 Apr 2000 17:06:02 -0400403_iso-8859-1 The control center came up and I could see tables in the mainframe. Now I get the following error when I try to use Display command by right clicking on Subsystem. Any solution on this.

[IBM][CLI Driver][DB2] SQL0204N "DSNACCMD " is an undefined name. SQLSTATE=42704

thanks Sibimon Philip 972-813-5517 - Office 972-417-3597 - Residence E-mail - Sibimon_Philip@csxlines.com [...] 53042 23 35_Re: Static SQL interface to DB2/39013_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 13 Apr 2000 15:55:38 -0500375_- On Thu, 13 Apr 2000 11:13:47 -0700, Myron Miller wrote:

>What do you mean SQL interface static not like ODBC? >You can have "Static" or "Dynamic" SQL with ODBC with >no problems with ODBC from a number of different >vendors. How else would you access DB2 for OS/390 >unless you want to write your own DRDA routines and >not use ODBC? > [...] 53066 46 35_Re: Static SQL interface to DB2/39014_Steven Camitta30_steven.camitta@INGRAMMICRO.COM31_Thu, 13 Apr 2000 14:07:56 -0700422_iso-8859-1 Absolutely. It's called embedded sql. Your source starts out as an *.sqc file and is translated by the precompiler into either *.c or *.cpp plus a *.bnd that is the equivalent of a dbrm. Rgds, Steve



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Thursday, April 13, 2000 12:55 PM To: DB2-L@RYCI.COM Subject: Re: Static SQL interface to DB2/390 [...] 53113 26 22_Re: DB2 control center14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Thu, 13 Apr 2000 14:30:36 -0700459_iso-8859-1 I believe that this is because there are stored procedures that need to be installed in the subsystem to support Control Center. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.



The control center came up and I could see tables in the mainframe. Now I get the following error when I try to use Display command by right clicking on Subsystem. Any solution on this. [...] 53140 24 64_Re: What's the point of multiple VCATs? (was STOGROUPS with SMS)12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 14 Apr 2000 09:53:57 +1200396_us-ascii Yeah, sure, as long as your dbname/spacename standards allow for unique dataset names. Can't say I'd go that far, though... Don't know what the effect on the ICF catalog might be, either.



Raymond

Date: Wed, 12 Apr 2000 09:21:34 +0100 From: Marcus Davage Subject: Re: What's the point of multiple VCATs? (was STOGROUPS with SMS) [...] 53165 23 42_CICS & DB2 Program - Connecting to AS/400.10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Thu, 13 Apr 2000 17:03:41 -0500369_- Hi, I am trying to access AS/400 database from a CICS / DB2 program using SQL CONNECT verb. I am getting -922 from the CICS program on SQL CONNECT statement.

Has anybody in the list did it? We want to find out, whether it's feasible in first place. I could execute the same code (from CICS program) , in batch region (compiled & linked as batch program). [...] 53189 302 25_Re: SYSSTMT/TEXT contents12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 13 Apr 2000 17:10:08 -0500365_iso-8859-1 Mark:

The extended explain tables still exist. There is even more information. They are turned on / off by flipping the same bit as before, and there is still an exposure of a bind failing because of an issue with one or more of the tables. Because of this set the tables up under a different id than that normally used for production binds. [...] 53492 51 34_Re: Coding for -811 on SELECT INTO4_IBM116_IBM1@UBIL.COM.TR31_Fri, 14 Apr 2000 01:48:43 +0300412_- the host variables are actually populated and it normally is with the results from the 1st row but you should watch out for:

a - nullable columns (they do not bear the null value, but the most recent non-null (or default if initialised beforehand) b - unpredictability, i.e. sometimes the values ARE NOT those of the 1st row c - future changes since IBM seem to be planning to change this, anyway! [...] 53544 99 35_Re: Static SQL interface to DB2/3900_15_leon@CA.IBM.COM31_Thu, 13 Apr 2000 19:29:51 -0400430_us-ascii First let me say that I think that the Static vs. Dynamic is not nearly as important today as it used to be in the past. There are 3 reasons why people want static SQL: 1. application-based security i.e. grant execute on package rather then administer privileges on base tables 2. better performance 3. because somebody told them a long time ago that one should always go for static SQL and that dynamic SQL is evil [...] 53644 109 46_Re: CICS & DB2 Program - Connecting to AS/400.0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 14 Apr 2000 09:13:01 +0800372_us-ascii Peavy,

The -922 is only an authorisation error. If you check the manuals, it shows you several possible reasons for the problem. I'm not familiar with AS/400, but if it's similar to OS/390 you may need to check how your CICS RCT entries are set up, and ensure the appropriate userid has EXECUTE on the plan, or any plan exit is defined correctly etc. [...] 53754 33 35_Re: Static SQL interface to DB2/39010_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 14 Apr 2000 03:37:12 GMT556_us-ascii What i understood is that you wanted to access your DB2 UDB for OS/390 from your PC .For this you need to have DB2 connect installed on your PC and DB2 UDB for OS/390 configured on that using client configuration assistant.Other than this you need to have DB2 software development kit also installed in your PC which enables you to precompile your applications and bind them at remote location. I had used it sometime in Dec'99 and i am writing you what i did.I took a sample program given with DB2 UDB V6 trial copy.That was a C program and [...] 53788 19 42_2 UDB Version On The Same Solaris/Unix Box18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Fri, 14 Apr 2000 07:15:22 -0400374_- Does anyone have a Solaris environment that is running both V5.2 and V6.1? We just installed 6.1 and DAS is not recognizing the new instance so we can't access it from a client workstation. DAS is installed under V5.2.





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301 [...] 53808 142 22_DB2 connect & packages18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Fri, 14 Apr 2000 07:31:22 -0400514_iso-8859-1 Could someone explain to me how this works?

I have DB2 Connect EE installed on my desktop. Works fine. I do a 'connect' to one of our DB2/OS390 subsystems and I get a good connection. Then lets say I do a 'select * from abc.table' and it sends the result set back to my screen. So far so good, everything works just fine. Now when I go out to our TMON monitor for that subsystem I look up the thread that I just used to do this 'select'. I drill down and I see the PACKAGE that it is using. [...] 53951 43 46_Re: CICS & DB2 Program - Connecting to AS/400.12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 14 Apr 2000 05:47:45 -0700534_us-ascii Does the auth ID of the CICS executing program have authority on the AS/400?

--- "Rao, Peavy" wrote: > Hi, > I am trying to access AS/400 database from a CICS / > DB2 program using SQL > CONNECT verb. > I am getting -922 from the CICS program on SQL > CONNECT statement. > > Has anybody in the list did it? > We want to find out, whether it's feasible in first > place. > I could execute the same code (from CICS program) , > in batch region > (compiled & linked as batch program). > [...] 53995 31 44_Migrating DB in DB2/2 v 2.1 to UDB/NT v. 5.00_28_Adriana.Teixeira@VOGA.COM.BR31_Fri, 14 Apr 2000 09:51:00 -0300521_us-ascii Hi All, We have to migrate a db that is in DB2/2 version 2.1 to UDB/NT version 5.0 and we're facing some problems. I will describe the steps that we've done until now: 1 - the db2ckmig was executed in the OS/2 machine to verify if the db can be migrated, and nothing was returned; 2 - the db was cataloged in the NT machine within UDB/NT as a remote db and is accessible; 3 - the user that is executing the operations has sysadm authority in both sides; 4 - we've tried to execute the MIGRATE DB command in [...] 54027 114 26_Re: DB2 connect & packages12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Fri, 14 Apr 2000 09:19:18 -0400542_us-ascii DB2 Connect is a static bound application. It's the client program that 'selects' that package. It's works the same way as a MF program selects its package.

Martin.

"Whittaker, Stephen" wrote:

> > > Could someone explain to me how this works? > > I have DB2 Connect EE installed on my desktop. Works fine. > I do a 'connect' to one of our DB2/OS390 subsystems and I get a good > connection. > Then lets say I do a 'select * from abc.table' and it sends the result > set back to my > screen. So far so good, [...] 54142 187 26_Re: DB2 connect & packages12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Fri, 14 Apr 2000 08:29:08 -0500362_iso-8859-1 My thought would be that the package you see is for DB2CLI ODBC driver being used. When you initially installed DB2 connect you connected to the OS/390 system and did a bind for DDCSMVS.LST which included the package for DB2CLI (the CS,RR, UR, etc ) and it doesn't care what dynamic SQL you throw at it, the system will use the SQLC29N4 package. [...] 54330 88 26_Re: DB2 connect & packages15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Fri, 14 Apr 2000 09:47:25 -0400664_windows-1252 We use the CURRENTPACKAGESET parameter to control the package that is executed by dynamic SQL. When I say control the package executed, I mean the collection id of the package that is executed. For example, if you want to execute package COLLA.SQLC29N4, you would set the CURRENTPACKAGESET=COLLA. In this way, you can create packages in application-specific collections and copy the ‘out-of-the-box’ packages from the NULLID collection to your application collection. Creating the new packages with DYNAMICRULES(BIND) allows you to grant execute on the packages to a user id, but the table authorities are granted only to the CREATOR (or binder) [...] 54419 36 49_Re: 00E20003 abends on db2 v5 / os/390 - solution0_24_lightsey@ITS.STATE.MS.US31_Fri, 14 Apr 2000 09:27:31 -0500598_us-ascii For those who may be interested:

We decreased the size of the EDM pool last weekend just before IPL time and the abend hasn't recurred.

I did watch the first full "batch" cycle run through and monitored everything with both our BMC tools and the systemwide Omegamon. After the EDM reduction, everything ran as normal and at the time for the final commit, the DBM1 task suddenly jumped from using 6200 expanded storage frames to 62000 frames, the available memory above the 16M line dropped from 1400M to 32k. Everything wrapped up nicely, I went to bed, and by daylight [...] 54456 24 21_List for Visual Basic23_AITHA, BHEEMSEN (SBCSI)23_B4AITHA@MSG.PACBELL.COM31_Fri, 14 Apr 2000 07:34:51 -0700481_iso-8859-1 --- All~

Does anybody on this list have any idea about any lists for Visual Basic.

TIA

Bheemsen Aitha DB2 Support (System Test) SBC Services, 3W500V (925)867-6294 (w) (925)327-5419 (pgr) (925)275-2110 (Home)

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 54481 20 12_stored procs14_subrata mondal25_subratamondal@HOTMAIL.COM29_Fri, 14 Apr 2000 14:39:59 GMT483_- I just wanted to know if stored procs are easier to write in Db2 - ver 7(beta).? did anyone try it out?

TIA subrata

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 54502 220 41_Re: DB2 Service Wait Times (FINAL answer)10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Fri, 14 Apr 2000 09:40:36 -0500553_us-ascii Mike & All, The final answer was to do a DEGREE (1) rebind with a UR thrown in for good measure. The TOTAL runtime was UNDER 3 minutes! I'd guess that qualifies for a successfull answer. Here's a paste of the Omegamon report for your edification.

Obviously the UR tunred our locks down to little or none, but the real gain was in no more 'other suspends' and Parallel groups executed. I had no idea the parallelism evaluation was so expensive - with a bunch of select w/ =- clauses returning single rows, it definitely DOESN'T pay! [...] 54723 61 49_Re: 00E20003 abends on db2 v5 / os/390 - solution13_John Arbogast16_jfarbo@YAHOO.COM31_Fri, 14 Apr 2000 07:48:13 -0700544_us-ascii Sorry if you already posted this, but what was the size of your EDM pool before and after??

--- lightsey@ITS.STATE.MS.US wrote: > For those who may be interested: > > We decreased the size of the EDM pool last weekend > just before IPL time and > the abend hasn't recurred. > > I did watch the first full "batch" cycle run through > and monitored > everything with both our BMC tools and the > systemwide Omegamon. After the > EDM reduction, everything ran as normal and at the > time for the final > commit, the DBM1 task [...] 54785 51 7_Updates11_Vijay Kumar25_vijay_kumar90@HOTMAIL.COM29_Fri, 14 Apr 2000 10:59:34 EDT568_- Hi Everyone,

We ran a one-time job to change the format of the policy numbers last week for a list of policies (about 20000) specified by our client, and encountered a great problem described below.

The policy number was part of index (3 rd column in the 5-column index) and there are 5 such production indexes. DB2 resorted to using INDEX scan (MATCHCOLS = 0, ACCESSTYPE= I) and this resulted in a very poor performance. So the job was cancelled and our DBA dropped all the 5 indexes and created an index with Policy number as the only column in [...] 54837 64 72_Repost: "What's New?" for DB2 UDB for OS/390 Version 7 is Now Av ailable13_Morrill, John12_JohnM@VP.NET31_Fri, 14 Apr 2000 09:27:52 -0600687_- Greetings!

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

Cheers!

J. Michael Morrill Chief DB2-L List Owner =================================================



Dear DB2 Interested Parties,

DB2 Universal Database for OS/390 Version 7 will be announced next Tuesday, April 18. The V7 "What's New?" book (in .pdf format) is available now at http://www.ibm.com/software/data/db2/os390/pdf/whatv7.pdf (requires Adobe Acrobat Reader 4.0, download from www.adobe.com if needed). [...] 54902 19 49_Re: 00E20003 abends on db2 v5 / os/390 - solution0_24_lightsey@ITS.STATE.MS.US31_Fri, 14 Apr 2000 10:28:43 -0500518_us-ascii Current size is about 24M (6125 pages). Old size was about 8000 pages - increased from the older size of 6125 pages to try to improve the performance of our main application which is entirely Powerbuilder / dynamic sql. Obviously ( in hindsight ), this wasn't our best idea - especially since there wasn't a perceptible improvement for the "online" users. ( How does one describe online and batch processes when all of the processes are on win/nt and the big box sees all as IP connected ddf threads ? ) [...] 54922 103 11_Re: Updates20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 14 Apr 2000 11:51:15 -0400500_us-ascii Assuming you create a new index (the 6th index) on policy number alone. This would not result in index scan of other 5 indexes. Following would happen.

1. DB2 will use 6th index since it is matching fully to decide RID(s). 2. All the row(s) corresponding to RID(s) will be updated. 3. For updating the entries for the other indexes, DB2 will derive the key(s) from the row(s) itself or themselves. That will result in a access similar to matching index scan for other 5 indexes. [...] 55026 18 50_TCP/IP shareport option used with DB2 Data Sharing10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 14 Apr 2000 13:03:19 -0400486_us-ascii Hi all

Is it possible and/or useful to use 'shareport' option in TCP/IP with a data sharing environment where 2 members are running on the same LPAR. ie: 2 members of a DS group using same port number on the same lpar

Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 55045 68 38_Is there a plausible explanation ?????23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 14 Apr 2000 15:09:19 -0400581_- Hello list,

This problem was reported to me by a programmer and while I am still investigating it, I thought I would run it by the list to get any pointers

Programmer runs a COBOL-DB2 CAF program which updates one column of a table based upon flat file input. After the program is executed, programmer runs a spufi to check results and finds that only the first row (in the program execution logic) was updated, others have old value. Programmer add commit after each update and adds displays. Subsequent run updated value for all the rows in the program, but [...] 55114 20 8_Net.data10_Tim Miller21_tmiller@TELCORDIA.COM31_Fri, 14 Apr 2000 15:20:02 -0400504_us-ascii I was wondering if anyone knows of any good books explaining net.data. I have download all documentation/samples from IBM Net.data web site, but I was looking for more can anyone help.



Tim

Please send email to tmiller@telcordia.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 55135 93 42_Re: Is there a plausible explanation ?????14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Fri, 14 Apr 2000 15:27:00 -0400466_us-ascii We had a similar problem, but maybe not the same as yours...

Platform: Online COBOL and DB2 under CICS running on OS/390

Symptom: User adds new record/row, but it does not show up on browse panel

Reason: Record was being inserted "out of order" in Db2 tablespace; Browse was doing a Tablespace scan, so the user did not see the record in the order he expected. Had he scrolled down another 10 or 12 screens, he would have seen it. [...] 55229 109 42_Re: Is there a plausible explanation ?????15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 14 Apr 2000 21:27:05 +0100389_us-ascii Hello,

Is the program by any chance reading all the rows through a cursor and then using an update statement that uses key values extracted from the cursor? (as opposed to doing an update where current of cursor...). If that's the case I could imagine that the hostvariables used in the update are not refreshed after the first fetch but still point to the first row. [...] 55339 57 12_Re: Net.data15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 14 Apr 2000 21:32:25 +0100487_us-ascii Hello Tim,

Have you tried the redbook 'Accessing DB2 for OS/390 Data from the World Wide Web'? SG24-5273.

You can view it online or download it from www.redbooks.ibm.com.

Regards.

Toine Michielse DB2 for OS/390 Technical Specialist Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS



Tim Miller @RYCI.COM> on 04/14/2000 08:20:02 PM [...] 55397 25 25_USING ENABLE PARM ON BIND16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Fri, 14 Apr 2000 13:01:09 -0700633_- I'd like to know if anyone is in the practice of providing a specific value on the ENABLE parm on the BIND statement when binding plans? Currently, our environment does not force this specification, and thus the default is used. Additionally, when plans accessed via CICS are migrated to production, access to each plan is granted to PUBLIC. Since this practice does open up authorization and exposure issues, we were considering rebinding the plans with ENABLE(CICS) since the authorization checking to execute each transaction would be done within CICS. Our concern is that it could possibly create some additional overhead [...] 55423 124 42_Re: Is there a plausible explanation ?????0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Fri, 14 Apr 2000 15:07:22 -0500499_us-ascii I could offer one more explanation (not that this is necessarily the case).

If the following conditions are met, this could be the problem:

1) The program is made up of a mainline and a called program 2) The transactions are read in on a file that is passed to the called program thru linkage 3) The passed area is not working storage but the input file buffer area (described in the file FD) 4) The linkage in the called program is used as a host variable for the call. [...] 55548 34 26_Hate to bug you but ......15_Sherri Sterling23_ssterling@BPD.TREAS.GOV31_Fri, 14 Apr 2000 16:33:27 -0400584_US-ASCII ______________________________ Forward Header __________________________________ Subject: Hate to bug you but ...... Author: Sherri Sterling at pb40po Date: 04/14/2000 2:50 PM



We are still trying to set up the user exit for UDB archiving. Every time it switches to a new log file we get the following error:

User Exit returned error on ARCHIVE log file S0000017.LOG from /db2fs01/db2u6u[/NODE0000/SQL00001/SQLOGDIR/ for database CT2D0001, error code 28. We get the exact same message for the next log and the next log but the S0000018.LOG and etc. [...] 55583 47 42_DB2/RACF exit failing, no error message???0_22_BILL_GALLAGHER@PHL.COM31_Fri, 14 Apr 2000 16:35:39 -0400543_us-ascii Hi,

This is basically a reprint of an ETR I just opened with IBM in IBMLink. I thought I'd also post it here to see if anybody on the list might have some answers or suggestions . . .

We are using the DB2/RACF exit DSNX@XAC to allow our DB2 security to be administered by RACF. It looks like the exit may have failed sometime this week, and is no longer active. Since we are still in the process of migrating our security from native DB2 to RACF, most of the "old" native DB2 authorizations are still in place, and [...] 55631 178 42_Re: Is there a plausible explanation ?????23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 14 Apr 2000 16:43:39 -0400702_iso-8859-1 Bingo.......Larry you are right on target.....phew........I wish I was more COBOL literate. It is not a mainline-called program situation, but the host variables indeed were part of file FD section, not working storage section. Moving it to Working Storage did the trick..

Thanks a lot

Sanjay



> -----Original Message----- > From: L-IS.Kirkpatrick@MUTUALOFOMAHA.COM > [SMTP:L-IS.Kirkpatrick@MUTUALOFOMAHA.COM] > Sent: Friday, April 14, 2000 4:07 PM > To: DB2-L@RYCI.COM > Subject: Re: Is there a plausible explanation ????? > > I could offer one more explanation (not that this is necessarily the > case). > > If the following conditions are met, this could [...] 55810 26 30_Re: Hate to bug you but ......0_25_Pierre.Evans@AUTOZONE.COM31_Fri, 14 Apr 2000 15:47:45 -0500627_us-ascii Sherri, I dont recall the exact meaning of the err 28, but from memory the last time i used user exits u need to basically debug the userexit program and ensure that everything its attempting to do can be done: If the program attempts to move the inactive log to another directory, or even back it up to a device, ensure you have write permissions on that directory/device, you have read permissions on the log, the directory/device exists(!), there is space in that directory/device etc... HTH Pierre -------------------------------------------------------------------------------------------------------------- [...] 55837 54 31_FW: Information on Deleted rows18_Sekar.S (Exchange)18_Sekar.S@TARGET.COM31_Fri, 14 Apr 2000 16:20:19 -0500566_iso-8859-1 Hi, Thanks everyone who has replied. Now I have got the summary report. Can any please help me quickly on how I can find the mass delete of the cause. I have the tablespace and database name with me.

Thanks in Advance, Sekar.S.

> -----Original Message----- > From: Sekar.S (Exchange) > Sent: Thursday, April 13, 2000 12:19 PM > To: DB2-L@RYCI.COM > Subject: Information on Deleted rows > > Hi All, > We have a problem in our shop DB2/OS-390 like "all of sudden "2 > million rows were gone in a table". I will explain the situation. > > [...] 55892 111 42_Re: Is there a plausible explanation ?????20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 14 Apr 2000 15:34:57 -0400347_us-ascii Sanjay

I could suggest two things.

1. May be your spufi is running with UR !! 2. CAF provides tracing. You have to allocate DD DSNTRACE through your run JCL. The output could be huge but if you think you could still afford it then trace the CAF program. 3. Someone did DSN1COPY and indexes were not recovered properly. [...] 56004 33 34_Re: Coding for -811 on SELECT INTO16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 14 Apr 2000 16:33:33 -0400575_iso-8859-1 (1) -811: With a negative return code, in this case a -811, the values returned are NOT guaranteed. It is a negative return code and no one should trust an application on the returned contents. That is clearly defined by IBM.

(2) Existence checking: When there is more than one row possible, using singleton selects is not the best and most efficient method for checking existence. This is only true when there is only 0 or 1 row possible and there is a unique index in support of this. See the archives for my messages on this, Roger Miller's answers [...] 56038 174 42_Re: Is there a plausible explanation ?????0_19_Tim.Lowe@STPAUL.COM31_Fri, 14 Apr 2000 16:35:42 -0500483_us-ascii Sanjay, If this is the problem, then I believe there be a compiler warning like this: IGYSC2025-W "LK-FIELD-NAME" or one of its subordinates was referenced, but "LK-FIELD-NAME" was a "LINKAGE SECTION" item that did not have addressability. This reference will not be resolved successfully at execution.

Thanks, Tim Lowe

P.S. Larry, even if this is not the problem, it still is a very good answer for a Friday afternoon brain-twister! You deserve a prize! [...] 56213 69 29_Re: USING ENABLE PARM ON BIND0_19_Tim.Lowe@STPAUL.COM31_Fri, 14 Apr 2000 17:04:28 -0500435_us-ascii Jeff, On all of our "online" plans(CICS and IMS), we grant execute to public, and use ENABLE(CICS,IMSMPP). I did some monitoring when I made this change, but I was unable to see any performance impact.

Thanks, Tim













"Jeff A L'Italien" on 04/14/2000 03:01:09 PM

Please respond to DB2 Data Base Discussion List [...] 56283 27 38_Re: Hate to bug you but ....(Userexit)13_Jim Cleveland15_Jscleve@AOL.COM29_Fri, 14 Apr 2000 23:46:01 EDT538_US-ASCII Hi Sherri,

When we set up the userexit, it threw the same return code 28. There is an option in the sample code to turn on error logging and isolate the cause more specifically ('Unnknown error' ain't very helpful, huh?). I did this and also looked through the C code to see what was going on. We haven't completely debugged it yet but, what it amounts to is that the Userexit builds a path name where it expects to find the log file (based on a variable you set up top in the program, it should to match the logfile [...]