1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2000, week 3 2 70 56_Re: Using a gateway to trigger insert to DB2 from Oracle13_Michael Moore27_Michael_Moore@PUTNAMINV.COM31_Sat, 15 Jul 2000 10:34:28 -0400362_us-ascii Jana, we use the Oracle Transparent Gateway for DB2, version 4.0.1.1, to send data back and forth between db2 OS/390 V5 and Oracle on Sun Solaris V7.3.4. Some of these scripts, written in SQL*PLUS, utilize Oracle triggers to update/insert DB2 tables based on activity in Oracle. The trigger just utilizes a database link to point to the DB2 table. [...] 73 122 41_Re: limiting the number of returning rows16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Sat, 15 Jul 2000 12:44:19 -0400396_iso-8859-1 There are a couple of options, depending on how the result set is determined.

1 - Wait for Version 7.1 of DB2 on OS/390 which has that support for FETCH FIRST xx ROWS

2 - Put the SELECT in a cursor with OPTIMIZE FOR 1 ROW, then fetch 10 times -- this assumes that there is a unique or clustering index or tablespace scan representing the order you want the data in. [...] 196 46 11_Re: Extents15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sun, 16 Jul 2000 11:01:44 -0500465_us-ascii Joel Goldstein wrote: > > Roger Miller answered this a couple of months ago, and his answer will be > in the archives. > There is a some small CPU impact for large numbers of extents.



CPU increase is incurred ONLY for physical I/O (call to Media Manager modules to generate the CCW stream) because of looping through the EDB (Extent Definition Blocks) looking for the appropriate CCHHR (cyl, head, record) for the page/RBA in question. [...] 243 91 55_Re: AW: How to dtermine if HW-Compression supported ...15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sun, 16 Jul 2000 11:03:27 -0500576_iso-8859-1 see below.....





Roland Schiradin wrote: > > Do the following to tell if the system contains the software or hardware > to run a CSRCMPSC macro: > > 1. Determine if CSRCMPSC is available, by running the following: > > L 15,16 Get CVT address > USING CVT,15 Set up addressability to the C > TM CVTFLAG2,CVTCMPSC Is CSRCMPSC available? > BZ NO_CSRCMPSC Branch if not available > * Compression feature is available > . > . > NO_CSRCMPSC DS 0H > > 2. Determine if the CMPSC hardware instruction is available, by running > the following: > > L [...] 335 29 22_Re: RELEASE DEALLOCATE12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 17 Jul 2000 10:53:52 +1200525_us-ascii Julian/Adrian,

Going from memory (of your posting), I'd say your analysis of what's happening is correct. Julian, the 45-second timeout is an average. As you know, thread reuse occurs if a matching plan/tran/authid combo is executed within 2 cycles of the last combo running. There's a zparm value (can't remember which one, and can't be bothered to look it up) that sets the cycle time, which defaults to 30 seconds. So, the average reuse time works out to be one full cycle, plus 1/2 the second cycle. [...] 365 143 20_Re: SEQ. CACHE ZPARM15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Mon, 17 Jul 2000 09:03:19 +1000349_iso-8859-1 We have set it to SEQ. While an RVA (which we use) on some ways 'ignores' the instruction not to cache, the setting used in this ZPARM will effect the cache discard algorithym employed. For us it therefore makes sense to set the parm to SEQ. Sorry about being so vague, it is several years since I went though all this step by step. [...] 509 41 22_Re: RELEASE DEALLOCATE12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 17 Jul 2000 11:51:15 +1200429_us-ascii Julian,

Bugger. Nick (Cianci) has hit the nail into my head, to paraphrase somewhat. The parm that controls the cycle time is not a zparm value as I said, but in the RCT as Nick pointed out. Oops. To quote from the type=init bit in the Installation Guide:

PURGEC=minutes,seconds Specifies the length of the protected thread purge cycle. The maximum value for PURGEC is (59,59). The minimum is (0,30). [...] 551 33 11_Re: Extents14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Sun, 16 Jul 2000 20:13:15 -0400379_ISO-8859-1 Well Jim, While you have a slightly lower level of detail, that's exactly what Roger said a couple of month ago. Joel

essage text written by DB2 Data Base Discussion List >Joel Goldstein wrote: > > Roger Miller answered this a couple of months ago, and his answer will be > in the archives. > There is a some small CPU impact for large numbers of extents. [...] 585 16 23_Re: Disable Datasharing12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 17 Jul 2000 12:28:42 +1200408_us-ascii Nice spot, Mr. Murley. I guess D2C9D3D3C4E2 would have worked fine too. The combinations are endless, really (and kinda entertaining).



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. 602 17 29_DB@ Manuals online in the WEB19_Kleber Faria Vianna14_kfv@UOL.COM.BR31_Sat, 15 Jul 2000 19:00:23 -0300351_iso-8859-1 Does anybody know WHERE I can download DB2 manuals from?

Thanks for replying.

Kleber

================================================ 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. 620 357 41_Re: limiting the number of returning rows19_Kleber Faria Vianna14_kfv@UOL.COM.BR31_Sat, 15 Jul 2000 18:56:16 -0300585_iso-8859-1

Kurt,

Thank you very much for replying. However, "FOR FETCH ONLY" does not work for OS/390, MVS-ESA.

Kleber

-----Mensagem original----- De: Kurt Sahlberg Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Data: Quinta-feira, 13 de Julho de 2000 19:38 Assunto: Re: limiting the number of returning rows



Kleber, Try this

SELECT * FROM owner.table X WHERE 20 >= (SELECT COUNT(*) FROM owner.table Y WHERE Y.colunm <= X.column) AND X.column < somevalue FOR FTECH ONLY [...] 978 71 33_Re: DB@ Manuals online in the WEB0_29_Greg.Palgrave@BANKWEST.COM.AU31_Mon, 17 Jul 2000 11:14:19 +0800719_us-ascii Try

http://www-4.ibm.com/software/data/db2/library/

and follow the links.

Regards, Greg Palgrave Database Administration IT Services Bank of Western Australia

eMail : greg.palgrave@bankwest.com.au



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



From: Kleber Faria Vianna on 16/07/2000 06:00





Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Greg Palgrave/PRS/SS/BankWest)

Subject: DB@ Manuals online in the WEB







Does anybody know WHERE I can download DB2 manuals from? [...] 1050 45 33_Re: DB@ Manuals online in the WEB12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Mon, 17 Jul 2000 13:17:04 +1000454_- DB2 OS/390 base page - http://www-4.ibm.com/software/data/db2/ for all the DB2 flavours, selecting OS390 & then Library takes you to :- http://www-4.ibm.com/software/data/db2/os390/library.html . The only thing it won't have is the DB2 Diagnostic Guide. But the PM manuals are also there. The V6, & above, manuals have proper Abode indexes.

Redbooks can be found in :- http://www.redbooks.ibm.com/ and then drop in your DB2 search criteria [...] 1096 18 19_How to encrypt data12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Mon, 17 Jul 2000 12:51:56 +0530449_us-ascii Hi All ! We have a problem. How to encrypt the data while sending from web server ( Domino Go ) to DB2 UDB 5.2 on AIX. We are using net.data in between web server and DB2 UDB.

Regards Diwakar

================================================ 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. 1115 19 12_Re: 00C9008415_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Mon, 17 Jul 2000 03:25:40 -0500470_- If there's no monitor around or you don't have access to it ... a simple

-DIS DATABASE(DSNDB07) LOCKS

could shed some light, too. Relate the CORRID with a -DIS THREAD(*) to find the culprit ...



/M.

================================================ 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. 1135 35 12_Re: 00C9008410_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Mon, 17 Jul 2000 10:53:40 +0100416_iso-8859-1 thanks

-----Original Message----- From: Matthias Pohlig [mailto:matthias.pohlig@T-ONLINE.DE] Sent: Monday, July 17, 2000 8:26 AM To: DB2-L@RYCI.COM Subject: Re: 00C90084



If there's no monitor around or you don't have access to it ... a simple

-DIS DATABASE(DSNDB07) LOCKS

could shed some light, too. Relate the CORRID with a -DIS THREAD(*) to find the culprit ... [...] 1171 125 12_Re: 00C9008410_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Mon, 17 Jul 2000 10:55:12 +0100556_iso-8859-1 ta

-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: Friday, July 14, 2000 7:14 PM To: DB2-L@RYCI.COM Subject: Re: 00C90084



Pete,

You might try having your automation software flag the 00c90084 (and 00c900a5 while you are at it) and issue a -DIS DATABASE....USE command to see the mix at the time.

Dave -----Original Message----- From: Pete Coles [mailto:peter.coles@SOMERFIELD.CO.UK] Sent: Thursday, July 13, 2000 10:33 AM To: DB2-L@RYCI.COM Subject: Re: 00C90084 [...] 1297 24 37_Re: Repair level ID trivial question.14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Mon, 17 Jul 2000 11:44:56 +0100425_us-ascii Hi Toine & Venkat, and THX for the hints.

Yes, I misunderstood the REPAIR LEVELID update. I made some tests and EVEN HPGRBRBA in header page is updated

and not only PGLOGRBA, HPGLEVEL and HPGPLELV (level-id for down level detection). I thought that recovery base RBA

was left unchanged after a REPAIR LEVELID and it was NOT involved in down level detection. It's the first time I try this. [...] 1322 33 40_DB2PM V5 activation Data Collector error15_Michele Granito29_michele.granito@ISTRUZIONE.IT31_Mon, 17 Jul 2000 11:42:51 +0200528_iso-8859-1 Hello,

I've a problem with DB2PM Data Collector when I start the address space. The error is:

DGOV1312E subsysid 0 TCP/IP FUNCTION CALL 'GETCLIENTI' FAILED. ERRNO=156 The DB2PM message send me to TCP/IP for MVS API Reference manual but I didn't find the ERRNO=156.



Can anybody help me?

Thanks in advance.

Michele Granito EDS Italy Delivery Via Maremmana Superiore, 29 Monteporzio Catone (RM) tel. +39 06 9402392 fax +39 06 9402237 e-mail: michele.granito@istruzione.it [...] 1356 20 43_Regarding How to encrypt the net.data .....12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Mon, 17 Jul 2000 15:39:46 +0530298_us-ascii Hi Thanks. You are right. We have a web server ( Domino Go 4.6.2 ) with Net.Data which interacts with the DB2 UDB 5.2 on AIX 4.3.2 when we sent data from Net.Data (Application Server) 2.0.8 to DB2 server then we want it should be in the encrypted form.

Thanks & Regard Diwakar [...] 1377 40 27_Can not terminate a utility19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Mon, 17 Jul 2000 13:14:29 +0200386_iso-8859-1 Dear All

Os390 DB2 version 5

I was attempting to perform a reorg (sharelevel change), and obtained the result - resource unavailable on the mapping table index. I wanted to just terminate the utility. I used the following command:-

-TERM UTILITY(PCESIS) where PCESIS is the name of the utility.

The following information was then displayed:- [...] 1418 81 31_Re: Can not terminate a utility13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 17 Jul 2000 12:25:30 +0100379_us-ascii Neil,

How up-to-date are you with your maintenance? If I remember correctly I got this a good few months ago - recently I've had this problem and I can terminate the utility without a problem, so I suspect there's been a fix for this.

Allocate DSNTEST.DSNDBC.TLOGOS.AAAM10.S0001.A001 using IDCAMS and you should be able to then terminate the utility. [...] 1500 16 31_Re: Can not terminate a utility14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Mon, 17 Jul 2000 13:47:28 +0100338_us-ascii Did you drop tablespace while an utility was stopped ?

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. 1517 45 28_Re: Primary Authid for a BMP13_Keemle Joan T25_KeemleJoanT@JOHNDEERE.COM31_Mon, 17 Jul 2000 06:56:51 -0500446_us-ascii Check and see if you are using the authorization / signon sample exits - refer to Appendix B of the Administration Guide. We use the exit to call RACF and gather the secondary authid list, and we append 'IMS' (or CICS) to the list of authids. This allows granting execution to 'IMS', which works well for LTERMs that are not signed on. PSBname is the same as plan name in our environment. HTH. Thanks, Joan Keemle / Deere & Company [...] 1563 21 14_A QMF Question24_Jose Manuel Ayala Wilson18_jayala@HERDATA.COM31_Mon, 17 Jul 2000 14:19:53 +0200472_us-ascii Hi everybody,

Please, could any anybody tell me if its is possible to save the result from QMF query in a file to inspect results later ?

Thanks in advance,

JM Ayala Wilson HERDATA, S.L Madrid, SPAIN.

================================================ 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. 1585 44 18_Re: A QMF Question14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 17 Jul 2000 14:33:04 +0100594_us-ascii Jose,

sure, just enter 'save data as .....'

Regards Ruediger Kurtz

Jose Manuel Ayala Wilson schrieb: > > Hi everybody, > > Please, could any anybody tell me if its is possible to save the result > from QMF query in a file to inspect results later ? > > Thanks in advance, > > JM Ayala Wilson > HERDATA, S.L > Madrid, SPAIN. > > ================================================ > 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. 1630 36 18_Re: A QMF Question22_Lindsay, William (BIS)24_WLindsay@EXCHANGE.ML.COM31_Mon, 17 Jul 2000 08:37:21 -0400381_iso-8859-1 I believe the command is EXPORT.

-----Original Message----- From: Jose Manuel Ayala Wilson [mailto:jayala@HERDATA.COM] Sent: Monday, July 17, 2000 8:20 AM To: DB2-L@RYCI.COM Subject: A QMF Question



Hi everybody,

Please, could any anybody tell me if its is possible to save the result from QMF query in a file to inspect results later ? [...] 1667 38 18_Re: A QMF Question12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Mon, 17 Jul 2000 07:40:42 -0500305_iso-8859-1 It is very easy to do with QMF for Windows. You can export after you run your query or use the plug in for Excel or MSAccess to get the data in those formats. In QMF running under CICS or TSO, you can run the query in batch and send the output to a file instead of a printer with the jcl. [...] 1706 15 55_Can not terminate a utility - Thanks for the help : eom19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Mon, 17 Jul 2000 15:09:14 +0200357_iso-8859-1 Thanks to those who replied to my earlier post. The problem is now resolved.

Kindest regards Neil

================================================ 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. 1722 147 18_Re: A QMF Question16_Bancale, Michael21_MBancale@TXFB-INS.COM31_Mon, 17 Jul 2000 08:13:49 -0500303_iso-8859-1 As you can see there are many ways to save data for later inspection. The Save Data As name actually creates a DB2 table for you. You can then use this table in later SQL statements. We use this method heavily when we are generating reports for users which require more than simple SQL. [...] 1870 86 18_Re: A QMF Question9_JANA BONE25_JANA.BONE@TLC.STATE.TX.US31_Mon, 17 Jul 2000 08:08:10 -0500496_US-ASCII Sure, do a 'SAVE DATA AS' after you have your results. You can give QMF a dataset name (if you use a new name QMF will create it with the correct dataset attributes), or you can give QMF a table name. If you use a table name you can have QMF create a new table, or you can save the data to an existing table (if it has the same column types and lengths). If you allow QMF to create a new table, it will be saved to the database and tablespace specified in your current QMF profile. [...] 1957 21 21_2GB IX taking extents21_Rechsteiner, Tom (TH)20_trechsteiner@DOW.COM31_Mon, 17 Jul 2000 08:16:01 -0500576_iso-8859-1 Hello DB2 Discussion List,

I have a quick question for you, How can you tell if DB2 is actually using an extent of an object?

Background; We have a non-partitioned 2GB index defined and it typically resides in 2 extents. (A001 & A002) On June 17 the IX was reorged (2extents still, was reorged for leaf distribution trigger) Then on July 3rd another extent A003, is taken by DB2. It was reorged over the weekend and it failed with a 00D70003; Some or all of the data sets already exist. It was complaining about the A003 dataset. Before I delete [...] 1979 32 22_flashcopy for ES/Shark4_IBM119_IBM1@EGEBANK.COM.TR31_Mon, 17 Jul 2000 16:33:42 +0300309_- just a quick update on this subject:

although IBM (i.e..... we) said that the product would be available on GA on 18 june 2000, today the sales manager said next "DEFINITELY SURE" release date is 28 july, next.

after which I shall try and keep you posted on how it works and performs.... [...] 2012 60 25_Re: 2GB IX taking extents19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 17 Jul 2000 08:35:23 -0500611_iso-8859-1 Hi Tom, DB2 UDB for OS390 V6. Based on the error message, 00D70003, this dataset should be empty or contain invalid data from "another life." Is the tablespace user-defined? Read error message text carefully. Also, A001, A002 are datasets. Datasets may have extents. 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 [...] 2073 34 47_Re: Regarding How to encrypt the net.data .....25_Carlos Eduardo de Miranda25_carlos_e@CCUEC.UNICAMP.BR31_Mon, 17 Jul 2000 10:49:53 -0300598_us-ascii Diwakar:

What is your operating system at the machine where the Web Server and Net.Data are installed on? What is the version of the DB2 Client?

Carlos State University of Campinas Brazil

Diwakar Goel wrote:

> Hi > Thanks. You are right. We have a web server ( Domino Go 4.6.2 ) with > Net.Data which interacts with the DB2 UDB 5.2 on AIX 4.3.2 when we sent data > from Net.Data (Application Server) 2.0.8 to DB2 server then we want it should be > in the encrypted form. > > Thanks & Regard > Diwakar > > ================================================ > [...] 2108 42 70_Thanks ... Mini Survey Result - PeopleSoft and Production Data ac cess13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 17 Jul 2000 08:53:57 -0500433_iso-8859-1 Hi,

About two weeks ago I asked the group some questions to get a feel on what type of access PeopleSoft programmers have to production data in other sites.

Thanks to all those who responded.

Below is a summary of the results. The question, followed by the count of the Yes-No replies.



Questions Security - Does your PeopleSoft programming staff have access to production data ... [...] 2151 87 55_Re: AW: How to dtermine if HW-Compression supported ...0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 17 Jul 2000 09:35:42 -0500478_us-ascii Thanks for the great tip, it's just what I was looking for (skipping assembler). Unfortunately I'm not sure about the last step in the process, interpretting the output.

READY test 'sys1.linklib(iefbr14)' TEST l 10.%+179 l(1) xc 00FCFB41. E8 *Y * 00000000 TEST

I'm guessing that output indicates we are using an "E8" model processor. If I count over to position 40 and 80 there is nothing. Does that mean we do not have hardware compression support. [...] 2239 995 11_Re: Columns11_Pedro Cunha24_pedro.cunha@CAIXA.GOV.BR31_Mon, 17 Jul 2000 11:35:32 -0300670_iso-8859-1 I hope this helps,





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



Administration Guide

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

DB2 Universal Database Version 6 Incompatibilities This section focuses on the DB2 Universal Database Version 6 incompatibilities.



System Catalog Views



System Catalog Views in DB2 Universal Database Version 6

UNIX OS/2 WIN



Change:

In the system catalog views, new codes have been introduced: "U" for typed tables, and "W" for typed views. [...] 3235 332 41_Re: limiting the number of returning rows13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 17 Jul 2000 09:38:42 -0500593_ISO-8859-1 Kleber For Fetch Only and For Read Only have been available since V4, I think. I sure someone will correct me if I'm wrong. Kurt



>>> kfv@UOL.COM.BR 07/15/00 04:56PM >>>



Kurt,

Thank you very much for replying. However, "FOR FETCH ONLY" does not work for OS/390, MVS-ESA.

Kleber

-----Mensagem original----- De: Kurt Sahlberg Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Data: Quinta-feira, 13 de Julho de 2000 19:38 Assunto: Re: limiting the number of returning rows [...] 3568 56 18_Re: A QMF Question13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Mon, 17 Jul 2000 09:42:39 -0500478_us-ascii Hi,

There is another way that no one has mentioned yet. You can print your report to a file by redirecting the output of DSQPRINT using a clist in a clist library that QMF knows about. This clist in the example is PRTDS80. It allocates a file with the name of the userid.QMFPRT80 which has an lrecl of 80. To allocate in cylinders, add CYLINDERS. The clist list can be set up with parameters to change the lrecl and blksize or different clists can be used. [...] 3625 52 55_Re: AW: How to dtermine if HW-Compression supported ...13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Mon, 17 Jul 2000 10:52:53 -0400369_iso-8859-1 You need to break the single byte returned (see that "l(1)"?) into a bit string - in your case, you get "1110 1000"; this indicates that you have both software (first bit from left, hex value 8) and hardware (second bit from the left, hex value 4) compression.

In shorthand, any returned value greater than x'C0' (=x'80' + x'40') indicates both. [...] 3678 190 41_AW: limiting the number of returning rows12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 17 Jul 2000 16:54:11 +0200307_iso-8859-1 Kurt, you are right.

The FOR FETCH ONLY clause works since Version 4.1 of DB2 for OS/390. And if it is really a read only (that means a data snapshot only) it might be good to code WITH UR too............. But like everything "It depends...what you want to do with the fetched row... [...] 3869 30 41_Re: limiting the number of returning rows13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Mon, 17 Jul 2000 11:17:39 -0400400_iso-8859-1 I think there's some confusion here; a "FOR FETCH ONLY" clause doesn't make sense in a SELECT statement; I would expect to see it in a cursor declaration - similarly "WITH UR"...

Gregg Sawyer

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Monday, July 17, 2000 10:54 AM To: DB2-L@RYCI.COM Subject: AW: limiting the number of returning rows [...] 3900 89 34_Problems with DSNDB01.SYSLGRNX ...17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Mon, 17 Jul 2000 17:27:03 +0200820_us-ascii Hi all, a customer of us have a problem with the tablespace DSNDB01.SYSLGRNX, so no INSERT, nor UPDATE or DELETE could be done in every table of the subsystem.

The system is DB2 for OS/390 v5.1

I try to check all the indexes in the tablespace with the following JCL

//CHKINDX EXEC PGM=DSNUTILB,REGION=1024K, // PARM='DSN1,DSNTEX' //STEPLIB DD DSN=DSN510.SDSNLOAD,DISP=SHR //******************************************************************** //* Data Sets usati dall'Utility //******************************************************************** //SORTWK01 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND) //SYSPRINT DD SYSOUT=* //UTPRINT DD DUMMY sopprime messaggi del SORT //SYSIN DD * CHECK INDEX (ALL) TABLESPACE DSNDB01.SYSLGRNX //* [...] 3990 63 21_DB2 UDB V6.1 for AIX?0_18_damcon2@US.IBM.COM31_Mon, 17 Jul 2000 11:31:44 -0400331_us-ascii Hi all,

I've got 2 databases in 2 instances on the same AIX box. I'm trying to connect to EPMSDB, in instance db200001, from instance db200004. What do I need to do so they can see each other? I've setup an alias on one instance to point to a database in another instance, but still get the following message: [...] 4054 28 29_regarding OPTIMIZE FOR N ROWS0_39_brian_holroyd.consultant@PEOPLESOFT.COM31_Mon, 17 Jul 2000 09:17:07 -0700567_us-ascii If you are talking about the DB2 buffer pool, "optimize for 1 row" doesn't make any difference, DB2 retrieves all the rows into the buffer, but the Optimizer may choose a different access path.

If you are talking about the buffer on the client in a client/server environment, ie RQRIOBLK in DB2 Connect, "optimize for 1 row" makes a big difference. It will only send 1 row to the client buffer, which will satisfy the first fetch. If another fetch is issued, a request for another row is sent to the server ie a second round trip is required. So [...] 4083 78 25_Re: DB2 UDB V6.1 for AIX?14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Mon, 17 Jul 2000 10:49:46 -0500467_US-ASCII Jay,

When you cataloged the node did you use "catalog local node ...." ?

Mike >>> damcon2@US.IBM.COM 07/17/00 10:31AM >>> Hi all,

I've got 2 databases in 2 instances on the same AIX box. I'm trying to connect to EPMSDB, in instance db200001, from instance db200004. What do I need to do so they can see each other? I've setup an alias on one instance to point to a database in another instance, but still get the following message: [...] 4162 118 25_Re: DB2 UDB V6.1 for AIX?22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 17 Jul 2000 13:06:22 -0400300_- Given: 2 instances INST1 and INST2 on the same AIX box. INST1 has database DB1 INST2 has database DB2

It helps to think that From instance INST1's point of view database DB2 is a local "remote" database and From instance INST2's point of view database DB1 is a local "remote" database. [...] 4281 48 33_Re: regarding OPTIMIZE FOR N ROWS22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 17 Jul 2000 13:25:52 -0400701_- Very interesting...



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

> ---------- > From: > brian_holroyd.consultant@PEOPLESOFT.COM[SMTP:brian_holroyd.consultant@PEOP > LESOFT.COM] > Sent: Monday, July 17, 2000 12:17 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] regarding OPTIMIZE FOR N ROWS > > If you are talking about the DB2 buffer pool, "optimize for 1 row" doesn't > make any difference, DB2 retrieves all the rows into the buffer, but the > Optimizer may choose a different access path. > > If you are talking about the buffer on the client in a client/server > environment, ie RQRIOBLK in DB2 Connect, "optimize for 1 row" makes a [...] 4330 75 33_Re: regarding OPTIMIZE FOR N ROWS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 17 Jul 2000 13:38:08 -0400535_us-ascii It doesn't always bring all the data to DB2 bufferpool. "OPTIMIZE FOR 1 ROW" helps optimizer make a better decision. Consider the following scenario -

"SELECT CUST_NO , CUST_BILL_AMT FROM TABLE1 WHERE CUST_NO > ? ORDER BY CUST_NO"

If there is an ascending index on CUST_NO then "optimize clause" influences the optimizer to prefer choosing the index instead of tablespace scan. If there is no index on CUST_NO or index is descending then original (pre OPTIMIZE FOR) access path is most likely not affected. [...] 4406 29 34_SQL30081N TCP problem on NT server13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 17 Jul 2000 12:27:03 -0500576_- I've got two NT4.0 servers, fixpack 6a running DB6.1, fixpack 4.

The webserver is the client to the database server on the other machine.

The database client keeps getting these errors under load:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001 [...] 4436 60 38_Re: SQL30081N TCP problem on NT server13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 17 Jul 2000 12:57:03 -0500410_iso-8859-1 Henry, Search the archives. This topic has been touched upon a few times recently.

I am also trying to solve the same error.

Search on these topics as subjects, also on SQL30081N

"Help needed with problem" Posted by Shauna Hadden, It has good replies. "DB2 Connect Error: SQL30081N" Posted by me.

The search engine is ... http://jupiter.ryci.com/archives/db2-l.html [...] 4497 19 74_Re: Thanks ... Mini Survey Result - PeopleSoft and Production Data ac cess26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Mon, 17 Jul 2000 13:20:00 -0500311_- Have you tried www.zoomerang.com ? It's really neat in it's ability to create surveys and capture the results and do analysis of variance if you're so inclined. We're testing it and have had more fun with it than a barrel of jello. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 4517 121 11_Access path41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Mon, 17 Jul 2000 15:31:44 -0300360_iso-8859-1 I have got a quite simple query (in a COBOL program) that gives a sequential access path when bound. Differently, if I explain the same query using DB2 Visual Explain (or Spufi) I get an index acess, matchcols 1. The query is:

SELECT IDPESSOA, TIPOPESSOA INTO :WS-IDPESSOA, :WS-TIPOPESSOA FROM SYSADM.PESSOAS WHERE IDPESSOA = :WS-IDCADU [...] 4639 56 15_Re: Access path24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Mon, 17 Jul 2000 11:36:51 -0700608_iso-8859-1 Try comparing the definition of the column IDPESSOA with the definition of the host variable :WS-IDCADU. I've most often seen this problem when the definitions are different.

> -----Original Message----- > From: Cláudio Meluzzi Mendes [SMTP:P000002@BEG.COM.BR] > Sent: Monday, July 17, 2000 11:32 AM > To: DB2-L@RYCI.COM > Subject: Access path > > I have got a quite simple query (in a COBOL program) that gives a > sequential access path when bound. Differently, if I explain the same > query using DB2 Visual Explain (or Spufi) I get an index acess, matchcols > 1. The query is: > > [...] 4696 59 15_Re: Access path12_craig patton21_prgpatton@HOTMAIL.COM29_Mon, 17 Jul 2000 11:43:43 PDT657_- Claudio,

What is the 'filter factor' for that column? Is it the FIRST column of the cluster key (or the only column?) Also, it would help to know what bind parameters are being used, are they different from the 'spufi' bind?

Craig Patton







>From: Cláudio Meluzzi Mendes >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Access path >Date: Mon, 17 Jul 2000 15:31:44 -0300 > > I have got a quite simple query (in a COBOL program) that gives a >sequential access path when bound. Differently, if I explain the same query >using DB2 Visual Explain (or [...] 4756 57 15_Re: Access path20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Mon, 17 Jul 2000 14:57:41 -0400434_iso-8859-1 I am sure you have explained using parameter marker using spufi instead of putting actual value -

SELECT IDPESSOA, TIPOPESSOA FROM SYSADM.PESSOAS WHERE IDPESSOA = ?

But just to double check, did you use parameter marker while explaining ?

-----Original Message----- From: Cláudio Meluzzi Mendes [SMTP:P000002@BEG.COM.BR] Sent: Monday, July 17, 2000 2:32 PM To: DB2-L@RYCI.COM Subject: Access path [...] 4814 213 38_Re: DB2 UDB V6.1 for AIX? Working now!0_18_damcon2@US.IBM.COM31_Mon, 17 Jul 2000 16:18:23 -0400613_us-ascii Ok,

Seems that for some reason changing my .profile to execute db2profile from the sqllib, instead of having it copied in-stream, has fixed the problem. Not sure why because I just copied it today. Anyway, I'm now able to connect to databases across instances! Yippee!

Thanks to all, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW ----------------------------------------------------- [...] 5028 15 45_Are BMC indexes on the DB2 Catalog desirable?13_Cathy Overman15_coverma@TWA.COM31_Mon, 17 Jul 2000 14:58:31 -0500380_- As one weighs the plus and minus factors of creating user indexes on the DB2 catalog, would it be desirable to create BMC indexes on the DB2 catalog? This is recommended in BMC's Administrative Products for DB2 Installation Guide and sample SQL is supplied in the BMC.CNTL(DCIDB2IX) library. (I have DB2 V5 for OS/390 and am installing version 6.1 of the BMC admin tools). [...] 5044 230 38_Re: DB2 UDB V6.1 for AIX? Working now!13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Mon, 17 Jul 2000 16:26:13 -0400614_iso-8859-1 Sounds like your problem had to do with the DB2INSTANCE environment variable. Congratulations...

Jim Fletcher

-----Original Message----- From: damcon2@US.IBM.COM [mailto:damcon2@US.IBM.COM] Sent: Monday, July 17, 2000 4:18 PM To: DB2-L@RYCI.COM Subject: Re: DB2 UDB V6.1 for AIX? Working now!



Ok,

Seems that for some reason changing my .profile to execute db2profile from the sqllib, instead of having it copied in-stream, has fixed the problem. Not sure why because I just copied it today. Anyway, I'm now able to connect to databases across instances! Yippee! [...] 5275 41 49_Re: Are BMC indexes on the DB2 Catalog desirable?13_Gendron, Dave28_Dave.Gendron@COASTALCORP.COM31_Mon, 17 Jul 2000 15:47:51 -0500675_us-ascii Cathy,

We found it necessary to create the recommended indexes for performance. Haven't had any problems with this.

Dave

Dave Gendron - Database Systems Support Colorado Interstate Gas Co. (Coastal Corp.), 2 North Nevada Ave., Colorado Springs, CO 80903 719-520-4760 dave.gendron@coastalcorp.com

> -----Original Message----- > From: Cathy Overman [SMTP:coverma@TWA.COM] > Sent: Monday, July 17, 2000 1:59 PM > To: DB2-L@RYCI.COM > Subject: Are BMC indexes on the DB2 Catalog desirable? > > As one weighs the plus and minus factors of creating user indexes on the > DB2 catalog, would it be desirable to create BMC indexes on the DB2 [...] 5317 151 51_Re: How to dtermine if HW-Compression supported ...0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 17 Jul 2000 17:14:36 -0500461_us-ascii Greg explained it all to me (offline from the list). Here is his explaination of how to interpret the output from test utility to see if you have hardware &/or software compression available on your CPU











"Sawyer, Gregg" on 2000/07/17 03:39:04 PM

To: "'Rohn.Solecki@mts.mb.ca'" cc: Subject: RE: AW: How to dtermine if HW-Compression supported ... [...] 5469 180 25_Re: DB2 UDB V6.1 for AIX?0_18_damcon2@US.IBM.COM31_Mon, 17 Jul 2000 13:57:25 -0400370_us-ascii Mike & Mike,

Thanks for your responses. Yes, the node is defined as local. Below is the definition:

Node name = DB200001 Comment = Instance for EPMSDB Protocol = LOCAL Instance name = db200001

I tried defining the database alias in instance db200004 to point to the node, but still get the same message. Below is the alias definition: [...] 5650 97 25_Re: 2GB IX taking extents12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Tue, 18 Jul 2000 09:58:04 +1000352_- Tom, Weird! You say that the problem is occurring in a REORG. When DB2 REORGs, it deletes and redefines the underlying DataSets. Which means it should have deleted the DataSets A001, A002, and A003, and then re-allocated the ones it needed; assuming a plain IBM "vanilla" REORG { SHRLEVEL(NONE), STOGROUP Defined & not using the REUSE option }. [...] 5748 71 44_Re: DB2PM V5 activation Data Collector error14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 18 Jul 2000 10:11:52 +1000364_iso-8859-1 UNIX, from whence TCP/IP sprung, tends to use error numbers that are unique across an entire component rather than unique within a function. The IP error codes are listed in an Appendix, and 156 means (I think): Process initialization error - Attempt to initialize again.

Ask your TCPIP people if anything is happening in its address space. [...] 5820 153 38_Re: Problems with DSNDB01.SYSLGRNX ...0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 18 Jul 2000 08:37:21 +0800626_us-ascii Alessandro,

Obviously the RECOVER utility is stopping you from running other utilities, and you'll need to clean up your stopped utilities first.

I *can* help you with the X'00E40030' abend on the TERM UTIL:

APAR Identifier ...... PQ24684 Last Changed..99/05/04 DISPLAY OR TERM UTIL ENDS RC00E40030 AFTER ABEND0C1.

We had this problem recently, and couldn't term a utility (COPY luckily) in our prod DB2. This APAR was a perfect match for us, but as we were just upgrading system software, we were lacking a testing area for a few days, and didn't want to put the fix in mid-week, so [...] 5974 82 47_Re: Regarding How to encrypt the net.data .....12_Diwakar Goel32_Diwakar.Goel@VASHIMAIL.LTITL.COM31_Tue, 18 Jul 2000 08:42:33 +0530589_us-ascii Hi ! The operating system is IBM AIX 4.3.2 on which Web Server, Net.Data are installed. The version of the DB2 client is 5.2.



Thanks & Regards Diwakar













Carlos Eduardo de Miranda on 07/17/2000 08:19:53 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Diwakar Goel/LTITLVSH)





Subject: Re: Regarding How to encrypt the net.data ..... [...] 6057 314 79_FW: IBM ITSO Residency: DB2 UDB Server for OS/390 Version 7 Perf ormance Topics13_Morrill, John12_JohnM@VP.NET31_Mon, 17 Jul 2000 21:42:08 -0600367_iso-8859-1 Dear DB2 Interested Parties,

Please find below an announcement of a residency with the International Technical Support Organization (ITSO*, the "Redbook" writers), for a project to research and write a new IBM Redbook DB2 UDB for OS/390 Version 7 Performance Topics. This San Jose, California residency begins 30 October and lasts for 7 weeks. [...] 6372 398 87_Repost: "IBM blows lid off the TPC-C" and other Press Coverage of the DB2 TPC-C Results13_Morrill, John12_JohnM@VP.NET31_Mon, 17 Jul 2000 21:43:35 -0600545_iso-8859-1 DB2 Interested Parties,

Timothy Dyck's eWeek article (below), "IBM blows lid off the TPC-C", is well-researched and worth a read. I included a couple of other articles below as well: "IBM sets new record for server cluster" (from the451), "IBM wins, Oracle complains. So what?" (eWeek), and "Microsoft Loses Its SQL Bragging Rights" (Computerworld). For those of you who can read Danish, check out at an article about the benchmark in Computerworld Denmark at http://www.computerworld.dk/vis_artikel.asp?ArticleID=7306 ). [...] 6771 122 38_Re: Problems with DSNDB01.SYSLGRNX ...19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 17 Jul 2000 11:24:04 -0500297_iso-8859-1 Hi Alessandro, You might try to do a LOGONLY RECOVERy of SYSLGRNX. If that fails, you may have to drop and recreate it, make sure to initialize it, use JCL in dsnsamp. Make sure to be aware of impact of dropping it. See the archives for more info. Start doing image copies!!!!!!!! [...] 6894 182 21_Re: UDB for NT script11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Tue, 18 Jul 2000 13:59:07 +1000421_- Hi Neal, For the password problem the following may work depending on other security requirements. 1. create a cmd file that only the user running the script can access (viz. no one else can read it) 2. one line in the cmd file is: set password=passkey 3. In your cmd script which connects to the database: db2 -v connect to sample user user1 using %password% Of course this assumes password for user1 is passkey. [...] 7077 73 44_Re: DB2PM V5 activation Data Collector error23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 18 Jul 2000 07:07:03 +0100500_iso-8859-1 Michele Hi. Sounds like you are having problem with setting up a link with the IP task .. make sure that you have the correct IP address and port setup in your parms into the collector .. i.e the IP address must be that for the LPAR and can be obtained from the OS390 guys that manage the IP address space. The port .. now there is a funny ... I set our up over a year ago and from memory I can remember having to go for a range of about 3500 for all our ports across the collectors. [...] 7151 19 29_DDF performance consideration11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Tue, 18 Jul 2000 15:06:50 +0800542_us-ascii Hi,

We will be using DB2 connect to access our data stored on DB2 (Version 5) for OS/390. Front end applications will be using Websphere or ODBC. Are there any good books or articles on DDF performance tuning? What are the things that I should watch out for?

Thanks in advance.

================================================ 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. 7171 75 55_Re: AW: How to dtermine if HW-Compression supported ...15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Tue, 18 Jul 2000 02:03:57 -0500665_- "TEST" can do this for you as well ... just use



l 10.%+179 l(1) b

(list at (address 10=CVT)+absolute X'179' B=BINARY ) HTH.

/M. (for a REXX doing the same thing for you, look at the archives of a last week !)

<----------------------------------------------------------->



On Mon, 17 Jul 2000 10:52:53 -0400, Sawyer, Gregg wrote:

>You need to break the single byte returned (see that "l(1)"?) into a bit >string - in your case, you get "1110 1000"; this indicates that you have >both software (first bit from left, hex value 8) and hardware (second bit >from the left, hex value [...] 7247 26 19_UDB/AIX stress test20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM29_Tue, 18 Jul 2000 07:30:01 GMT452_- Hi List

We are running UDB 7.1 on an RS/6000. Does anyone know of any third party tools to allow us to stress test our application? Has anyone done this without using any tools?

Any info in this area would be much appreciated.

Thanks,

Pav Kumar-Chatterjee



________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com [...] 7274 112 44_Re: DB2PM V5 activation Data Collector error0_29_paul.packham@POSTOFFICE.CO.UK31_Tue, 18 Jul 2000 09:31:52 +0000286_us-ascii Les,

I'm not sure what maint level you are at for DB2PM V6, but you might want to check you have PQ35784/UQ43671 & PQ39354/UQ44903 applied. We had these raised. The PTFs are only just available so we are just about to put them on, so I don;t know if they work yet. [...] 7387 20 37_NET.DATA for OS/390 Program Directory9_SrinivasG17_SRINIVASG@INF.COM31_Tue, 18 Jul 2000 14:42:58 +0530421_- Hi, Can any one send me the Program Directory for NET.DATA V 2.1? I have PGMDIR for V2.2 but the Tape is for 2.1.

Thanks

Srinivas G Infosys Technologies, Bangalore

================================================ 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. 7408 24 23_Re: UDB/AIX stress test12_Kent Collins15_kcollins@WF.NET31_Tue, 18 Jul 2000 07:04:24 -0500407_iso-8859-1 Assuming AIX 4.3 is the operating system there is a selection of performance tools in the Performance ToolBox which you can install. There are also reporting tools like monitor which you can download from the web that will run in batch mode and report key resource thresholds.



Robert M. Collins Jr ( Kent ) IBM Certified DB2 UDB DBA Phone: 940.241.2242 Email: kcollins@wf.net [...] 7433 24 23_Re: UDB/AIX stress test13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 18 Jul 2000 08:48:06 -0400644_iso-8859-1 Hello Pav, Compuware has a suite of tools providing solutions in the Stress testing area. I believe QA-Load will do what you need. See

http://www.compuware.com/products/auto/products/qaload.htm

Feel free to contact me off-list if you'd like to talk with a sales or support person.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.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. 7458 25 33_Re: DDF performance consideration14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 18 Jul 2000 09:10:59 -0400649_us-ascii Roland, These are a few of the references that I would recommend that you look at. They deal with all aspects of tuning DB2 Connect in a TCPIP and SNA environment. Be aware of the fact that DB2 creates an enclave for DDF connections coming in and these enclaves can use a lot of CPU if not controlled by workload manager or priorities if not using workload manager. Redbook: Wow! DRDA Supports TCPIP, DB2 Server for OS/390 and DB2 Universal Database, SG24-2212-00. See performance white papers at http://www-4.ibm.com/software/data/db2/performance/. DRDA Certification Guide, available from most online bookstores and IBM; DB2 Connect [...] 7484 128 49_Problem while connecting to DB2 UDB 6.1 on OS/39026_Janakiraman S, J16 Chennai23_janaks@MSDC.HCLTECH.COM31_Tue, 18 Jul 2000 18:41:57 +0530476_iso-8859-1



hi all,

We have installed DB2 UDB V7.1 (Personal Edition)on Win 98 and tried to connect to DB2 UDB V6.1 on OS/390 through TCPIP, we get the following error message on the mainframe side.

DSNL032I - DSNLIRTR DRDA EXCEPTION CONDITION IN 101 REQUEST FROM REQUESTOR LOCATION=x.x.x.x FOR THREAD WITH LUWID=CCA0FD25.G4D8.B45BF92D2CF6 REASON=00D3101C ERROR ID=DSNLIRTR0003 IFCID=0192 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000009 [...] 7613 74 15_Re: Access path41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Tue, 18 Jul 2000 10:16:01 -0300334_iso-8859-1 Francis, Craig and Venkat,

The host variable :WS-IDCADU was defined in COBOL as COMP3 instead of USAGE COMP. That probably caused a type conversion in DB2 (I do not know why) and, consequently, the chosen access path was sequential. The access path changed to I (index) after correcting the host variable type. [...] 7688 66 49_Re: Are BMC indexes on the DB2 Catalog desirable?0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM31_Tue, 18 Jul 2000 08:21:58 -0500487_us-ascii What BMC tool does the new index help?

We have Catalog Manager so I'm curious if it benefits that tool or if its for a different tool.









"Gendron, Dave" on 07/17/2000 03:47:51 PM





Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Shan Leatherman/MO/americancentury) Subject: Re: Are BMC indexes on the DB2 Catalog desirable? [...] 7755 10 21_SQL to Display All RI11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM31_Tue, 18 Jul 2000 09:33:03 -0400458_- Does anyone have some sample SQL that they would be willing to share that will enable a user to supply a table name and receive a report showing ALL tables associated with that table via referential integrity? TIA.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 7766 89 49_Re: Are BMC indexes on the DB2 Catalog desirable?15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 18 Jul 2000 08:34:59 -0500349_iso-8859-1 Catalog Manager in particular but also Change manager, Alter, DASD manager and any utility that supports wildcarding of object names. Since these indexes are only updated by DDL, which should be relatively rare on a production system, they do not seem in general to cause performance problems.

Andy Lankester BMC Software Ltd [...] 7856 43 25_Re: SQL to Display All RI15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 18 Jul 2000 09:37:33 -0400506_- SELECT A.TBNAME, A.RELNAME, A.COLNAME,B.REFTBNAME,B.DELETERULE ,A.COLSEQ FROM SYSIBM.SYSFOREIGNKEYS A , SYSIBM.SYSRELS B WHERE A.CREATOR = ? AND A.TBNAME = ? AND A.CREATOR = B.CREATOR AND A.TBNAME = B.TBNAME AND A.RELNAME = B.RELNAME ORDER BY A.RELNAME, A.COLSEQ WITH UR



Sibimon Philip







-----Original Message----- From: Tom Johnson [mailto:new_to_db2@SPRINGMAIL.COM] Sent: Tuesday, July 18, 2000 8:33 AM To: DB2-L@RYCI.COM Subject: SQL to Display All RI [...] 7900 58 53_Re: Problem while connecting to DB2 UDB 6.1 on OS/39020_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Tue, 18 Jul 2000 14:50:19 +0100585_iso-8859-1 The problem is that the version of DB2 Connect which you are using is only capable of connecting to another Fisher-Price DB2 (i.e. not to an OS/390 DB2). Hence the lack of a target system selection option. I know this because I had the same problem myself. The answer is to use "DB2 Personal Developer's Edition 7.1" which includes a version of DB2 Connect which can connect to any flavour of DB2, and which is available for free download from http://service.software.ibm.com/segdown?segment=DM &family=DB [...] 7959 29 14_15 table limit18_Mitchell Michele E22_mitchell.me@MELLON.COM31_Tue, 18 Jul 2000 09:50:53 -0400538_- Hi

We just applied the OS/390 V5/V6 fallback maintenance this weekend, and yesterday a problem popped up as a result. I guess there was some 'loophole' in V5 that allowed more than 15 tables in joins. One of the fallback PTFs fixed this loophole.

One query (so far) started having table limit errors yesterday, but for a reason which leads me to ask this question. The query only has 15 tables, but the select statement has an 'AS' in it. ex. (Select A.ACCOUNT AS RPT_ACCOUNT). Upon removing the AS, the query works. [...] 7989 105 49_Re: Are BMC indexes on the DB2 Catalog desirable?13_john arbogast19_arbo@CP-DEMO.CP.NET31_Tue, 18 Jul 2000 07:05:09 -0700586_- I just installed the majority of the BMC utilities: Load Copy Reorg Recover Unload Check BMCDSN and I don't see any DDL for catalog indexes in either the JCL or the CNTL datasets? Where else should I be looking?

On Tue, 18 July 2000, "Lankester, Andy" wrote:

> > Catalog Manager in particular but also Change manager, Alter, DASD manager > and any utility that supports wildcarding of object names. Since these > indexes are only updated by DDL, which should be relatively rare on a > production system, they do not seem in general to cause performance > problems. [...] 8095 38 18_DB2 - CICS threads12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Tue, 18 Jul 2000 09:07:25 -0500521_- I am hoping someone on the list can help us. This question is also being posted to the CICS list.

The environment is MVS 5.2.2, DB2 V4.1 and CICS V4.1.

We have a DB2 application that occasionaly goes short-on-storage in CICS. Soon after this we find that some of the threads from this application are still "active" in DB2 but the tasks do not exist in CICS. These threads are not doing any SQL in DB2, they are just sitting there, no CPU cycles used. However, they are holding LOCKS on DB2 objects. [...] 8134 129 49_Re: Are BMC indexes on the DB2 Catalog desirable?15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 18 Jul 2000 09:11:22 -0500525_iso-8859-1 They are only shipped with the Administration products.

Andy Lankester BMC Software Ltd.

-----Original Message----- From: john arbogast [mailto:arbo@CP-DEMO.CP.NET] Sent: 18 July 2000 15:05 To: DB2-L@RYCI.COM Subject: Re: Are BMC indexes on the DB2 Catalog desirable?



I just installed the majority of the BMC utilities: Load Copy Reorg Recover Unload Check BMCDSN and I don't see any DDL for catalog indexes in either the JCL or the CNTL datasets? Where else should I be looking? [...] 8264 127 49_Re: Are BMC indexes on the DB2 Catalog desirable?17_Overman, Cathy A.15_COVERMA@TWA.COM31_Tue, 18 Jul 2000 09:12:03 -0500570_iso-8859-1 The sample DDL is in the Administrative Tools (Catalog Mgr, DASD Mgr., Change Mgr., etc.) library BMC.CNTL in member (DCUDB2IX).

-----Original Message----- From: john arbogast [mailto:arbo@CP-DEMO.CP.NET] Sent: Tuesday, July 18, 2000 9:05 AM To: DB2-L@RYCI.COM Subject: Re: Are BMC indexes on the DB2 Catalog desirable?



I just installed the majority of the BMC utilities: Load Copy Reorg Recover Unload Check BMCDSN and I don't see any DDL for catalog indexes in either the JCL or the CNTL datasets? Where else should I be looking? [...] 8392 24 17_URGENT : software19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Tue, 18 Jul 2000 16:17:35 +0200537_iso-8859-1 Dear All

A bit off topic this but any help will be greatly appreciated. Can somebody please advise me as to the definitions for the following:-

Software Hardware

I have been asked to supply this information to our legal dept.



Thanks in advance Neil

================================================ 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. 8417 59 21_Re: URGENT : software15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Tue, 18 Jul 2000 09:24:27 -0500462_iso-8859-1 Hardware:

A computer and the associated physical equipment directly involved in the performance of data-processing or communications functions.

Software:

The programs, routines, and symbolic languages that control the functioning of the hardware and direct its operation.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992, 1996 by Houghton Mifflin Company. All rights reserved. [...] 8477 38 21_Re: URGENT : software14_Waterman, Fred22_FWaterman@AEGONUSA.COM31_Tue, 18 Jul 2000 09:24:59 -0500577_- If you can kick it, it's hardware.

> -----Original Message----- > From: Briggs, N. - Neil - [SMTP:N.Briggs@CANON-EUROPA.COM] > Sent: Tuesday, July 18, 2000 9:18 AM > To: DB2-L@RYCI.COM > Subject: URGENT : software > > Dear All > > A bit off topic this but any help will be greatly appreciated. Can > somebody > please advise me as to the definitions for the following:- > > Software > Hardware > > I have been asked to supply this information to our legal dept. > > > Thanks in advance > Neil > > ================================================ > To change your [...] 8516 52 21_Re: URGENT : software24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 18 Jul 2000 07:28:50 -0700562_- Is that what they mean when they say boot the machine?

> -----Original Message----- > From: Waterman, Fred [SMTP:FWaterman@AEGONUSA.COM] > Sent: Tuesday, July 18, 2000 7:25 AM > To: DB2-L@RYCI.COM > Subject: Re: URGENT : software > > If you can kick it, it's hardware. > > > -----Original Message----- > > From: Briggs, N. - Neil - [SMTP:N.Briggs@CANON-EUROPA.COM] > > Sent: Tuesday, July 18, 2000 9:18 AM > > To: DB2-L@RYCI.COM > > Subject: URGENT : software > > > > Dear All > > > > A bit off topic this but any help will be greatly appreciated. [...] 8569 176 49_Re: Are BMC indexes on the DB2 Catalog desirable?9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 18 Jul 2000 15:26:24 +0100429_us-ascii You can also add some additional user indexes for Recovery Manager/Change Manager - member (DCIDB2I1). Comments in this member indicates that there are yet more user defined index definitions in members (DCIDB2I2) and (ARMINDEX). All in the CNTL library. Kind Regards, Andy Hunt - Scottish And Southern Energy









"Lankester, Andy" on 18/07/2000 15:11:22 [...] 8746 71 22_Re: DB2 - CICS threads15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 09:34:21 -0500289_iso-8859-1 I don't know of any way in V4 except to use something like Omegamon for DB2 that has a facility for cancelling DB2 threads. I believe that you can cancel distributed threads in V4 but not CICS threads. I could be wrong though. It has been a while since we have been on V4. [...] 8818 63 22_Re: DB2 - CICS threads20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 18 Jul 2000 10:35:21 -0400618_us-ascii -----Original Message----- From: Carol Sutfin [SMTP:csutfin@AMSOUTH.COM] Sent: Tuesday, July 18, 2000 10:07 AM To: DB2-L@RYCI.COM Subject: DB2 - CICS threads

I am hoping someone on the list can help us. This question is also being posted to the CICS list.

The environment is MVS 5.2.2, DB2 V4.1 and CICS V4.1.

We have a DB2 application that occasionaly goes short-on-storage in CICS. Soon after this we find that some of the threads from this application are still "active" in DB2 but the tasks do not exist in CICS. These threads are not doing any SQL in DB2, they are just sitting [...] 8882 65 22_Re: DB2 - CICS threads20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 18 Jul 2000 10:36:17 -0400356_us-ascii Can you send us -DIS THREAD output of these thread (the problem ones) ?

-----Original Message----- From: Carol Sutfin [SMTP:csutfin@AMSOUTH.COM] Sent: Tuesday, July 18, 2000 10:07 AM To: DB2-L@RYCI.COM Subject: DB2 - CICS threads

I am hoping someone on the list can help us. This question is also being posted to the CICS list. [...] 8948 36 13_When to REORG10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Tue, 18 Jul 2000 16:39:13 +0100696_iso-8859-1 Hi all, DB2 version 5 OS/390.

Simple question but potentially complicated answers:

How do I determine when to REORG a tablespace based on the numerous catalogue statistics available?

















> ------------------------------------------------------------------ > Pete Coles - Systems Integration > > Email: peter.coles@somerfield.co.uk > > Tel: +44 117 935 6726 > > >

================================================ 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. 8985 19 21_Re: URGENT : software14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Tue, 18 Jul 2000 16:39:54 +0100480_us-ascii In a UNIX system yes........Sometimes they use a car battery and cables. Pay attention if the it's is a diesel car battery...

Sorry, I couldn't resist....

Max Scarpa

(who escaped from UNIX client/server hell)

================================================ 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. 9005 83 22_Re: DB2 - CICS threads15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 09:43:15 -0500589_iso-8859-1 I need to correct myself. There is a cancel thread command for V4. Look it up in the Command Reference manual.

Linda

-----Original Message----- From: Billings, Linda Sent: Tuesday, July 18, 2000 9:34 AM To: 'DB2 Data Base Discussion List' Subject: RE: DB2 - CICS threads



I don't know of any way in V4 except to use something like Omegamon for DB2 that has a facility for cancelling DB2 threads. I believe that you can cancel distributed threads in V4 but not CICS threads. I could be wrong though. It has been a while since we have been on V4. [...] 9089 91 21_Re: URGENT : software12_John Cameron26_JCameron@MSI-INSURANCE.COM31_Tue, 18 Jul 2000 09:40:18 -0500426_us-ascii I'm not sure - ever kick a Microsoft Windows NT CD-ROM ?

Of course, we'd have to debate if Windows is really "software"









"Leblanc, Francis C - To: DB2-L@RYCI.COM CNF" cc: Sent by: DB2 Data Base Discussion List



07/18/00 09:28 AM Please respond to DB2 Data Base Discussion List [...] 9181 13 17_Re: When to REORG12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Tue, 18 Jul 2000 09:49:22 -0500398_us-ascii In the sample library that comes with DB2, there are various queries you can run to determine when to reorg. The member would be: SDSNSAMP(DSNTESP)

================================================ 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. 9195 70 18_Re: 15 table limit15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Tue, 18 Jul 2000 09:38:29 -0500416_- Michele,

would you allow me one question: Do you really get a -129 SQLCODE (too many tables in subselect) or just a -101 (statement too long or too complex) ??

in the first case, I'd assume it's a glitch in V6 compatibility code, in the lattter ....well, i remember a long time ago (v2 to v3 conversion), when a thing called "transitive closure" was introduced, we experienced similar problems. [...] 9266 84 47_Re: Regarding How to encrypt the net.data .....25_Carlos Eduardo de Miranda25_carlos_e@CCUEC.UNICAMP.BR31_Tue, 18 Jul 2000 11:58:44 -0300442_us-ascii Diwakar:

You have both sides, client and server, running AIX. In this case, it is possible to set up the parameter authentication, at the client machine, to server_encrypt. Do the following:

1. Login at the client as db2instance user. 2. db2 update dbm cfg using authentication server_encrypt 3. db2 terminate

Now verify, via sniff or other software, if data from client to server is in the encrypted form. [...] 9351 28 17_Re: When to REORG10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Tue, 18 Jul 2000 16:59:28 +0100602_iso-8859-1 THANKS

-----Original Message----- From: Dan Sullivan [mailto:daniel.sullivan@ZURICHUS.COM] Sent: Tuesday, July 18, 2000 2:49 PM To: DB2-L@RYCI.COM Subject: Re: When to REORG



In the sample library that comes with DB2, there are various queries you can run to determine when to reorg. The member would be: SDSNSAMP(DSNTESP)

================================================ 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. [...] 9380 19 18_Re: 15 table limit14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Tue, 18 Jul 2000 10:59:32 -0400478_us-ascii Yes. Any nested table is considered as a "table" to the count for DB2. The "loophole" you mentioned was not a hole but a PTF that allowed more the 15. I suppose the maintenance you applied simply did not have that PTF in as the PTF has been known to cause problems with storage and bringing DB2 down. There is a "fix" as I understand it that allows more the 15 tables but places a limit you can set on the number of tables reducing the potention for DB2 problems. [...] 9400 78 17_Re: When to REORG15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 10:00:26 -0500620_iso-8859-1 Hi, Pete,

It depends........

If the majority of your queries against the tablespace are accessing data in cluster order then CLUSTERRATIO becomes very important. If the CLUSTERRATIO is less than 80% then an index is used if available. If not, then List Prefetch kicks in. If they are mostly doing direct index access of a single row then this is not important. If your tablespace has VARCHAR columns then NEARINDREF and FARINDREF become important. If you are out of freespace or the tablespace is going into excessive extents (What this means may vary from shop to shop.) then reorg anyway [...] 9479 80 25_Re: SQL to Display All RI13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 18 Jul 2000 10:00:24 -0500337_us-ascii Hi,

Sibimon's query will find the parent of a table. We use this query to find the children tables. It is written to find all the parent/child relationships in an application, but could be adapted to look for the children of a single table. Our application id's are in the 3 and 4 position of the dbname and tsname. [...] 9560 58 28_Re: DB2/OS390 DSN1CHKR usage0_17_sjvagnier@AEP.COM31_Tue, 18 Jul 2000 11:00:38 -0400763_us-ascii Hello Ron,

I currently run DSN1CHKR on catalog tablespaces when migrating to a new release.

Regards, Steve Vagnier American Electric Power









Ron Johnson @RYCI.COM> on 07/10/2000 11:40:27 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DB2/OS390 DSN1CHKR usage



We currently run DSN1CHKR on catalog tablespaces during a weekly scheduled IPL and DB2 downtime. This has been done since before my time as a DBA and in over 9 years it has yet to find any problems in the catalog. This is falling into the catagory "Do [...] 9619 108 18_Re: 15 table limit18_Mitchell Michele E22_mitchell.me@MELLON.COM31_Tue, 18 Jul 2000 11:03:32 -0400445_- The error is:

Query 1 caused the following error: SQL Error State: 54004, ODBC Error: [IBM][CLI Driver][DB2] SQL0129N The statement contains too many table names (the maximum is 15). SQLSTATE=54004

. Error Code 80004005

We thought about the potential view issue, but it works once you remove the AS in the SELECT statement. And as a workaround, we are raised that limit to 16 today to see if it resolves the problem. [...] 9728 60 50_How do you get one site to be instep with another?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 18 Jul 2000 16:04:43 +0100425_iso-8859-1 Hi all, I wonder if you could give me your thoughts on the following.

We currently have two machines one on our existing site the other at our DR site some 25 miles away connected by a large pipe.

We are V6(OS390) and Datasharing.

What options do we have for getting an up-to-date copy of our production database to the DR site on a regular basis (between 15 and 60 minutes out of sync)? [...] 9789 27 18_Re: 15 table limit15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Tue, 18 Jul 2000 10:09:57 -0500411_- Michelle,

both of your responders are somewhat right.

check out APAR PQ31326 , it has the whole story !!! and: a method to increase the limit !!

but as the APAR text already mentions: wath the storage consumption of your db2 address space !

(the APAR is publicly viewable folling this thread:

http://techsupport.services.ibm.com/support/s390 (search:) db2 sqlcode -129 [...] 9817 91 53_AW: Problem while connecting to DB2 UDB 6.1 on OS/39012_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 18 Jul 2000 17:33:01 +0200429_iso-8859-1 Hugh,

thanks for the wonderful words "Fisher-Price DB2". Seems you are a true mainframer. Are you ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r

-----Ursprüngliche Nachricht----- Von: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] Gesendet am: Dienstag, 18. Juli 2000 15:50 An: DB2-L@RYCI.COM Betreff: Re: Problem while connecting to DB2 UDB 6.1 on OS/390 [...] 9909 131 53_Re: Problem while connecting to DB2 UDB 6.1 on OS/3904_IBM119_IBM1@EGEBANK.COM.TR31_Tue, 18 Jul 2000 18:39:06 +0300454_ISO-8859-9 take it from me guys.... better fisher-price db2 than mickey mouse one (the one I am stuck with these days....)

:-)))))))))))))))))))

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 10041 121 22_Re: DB2 - CICS threads12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Tue, 18 Jul 2000 10:44:27 -0500348_- Linda, and all

I have tried using the -CANCEL THREAD(token) here. The problem is that DB2 will only cancel the thread when it is actively doing something in DB2. These threads aren't really active (doing SQL). No CPU cycles. Therefore DB2 cannot cancel them and they continue to hold resources and cause problems with the batch jobs. [...] 10163 42 34_Rejected posting to DB2-L@RYCI.COM16_Manfred Beilfuss17_beilfuss@CONTI.DE31_Tue, 18 Jul 2000 17:43:11 +0200519_us-ascii Hello Everybody, I need to install DB2-RTCL-Fixpack's unattended on more than 300 NT-workstations, but I didn't find a way to do it in the same manner like I install the base version of the RTCL with response files a.s.o.!

Additionally there seems to be a problem installing the appropriate language version of the fixpak, in relation to the installed language version of base-product and correlated to the regional + keyboard settings of the nt-workstation where the fixpak is to be installed on. [...] 10206 97 53_Re: Problem while connecting to DB2 UDB 6.1 on OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 18 Jul 2000 11:35:31 -0400442_- Hugh as you said -

DB2 UDB Personal Edition does not include DB2 Connect. DB2 Personal Developers Edition includes DB2 Connect.

However, there might be a little confusion.

DB2 Connect is a DRDA Application Requester (AR) that connects to data bases supporting DRDA Application Server (AS). The IBM data bases that support DRDA AS are DB2 for OS/390, DB2 for VM & VSE and DB2 for AS/400. They also support DRDA AR. [...] 10304 140 22_Re: DB2 - CICS threads15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 10:54:45 -0500657_iso-8859-1 I was afraid of that. It's been so long that I don't remember. Sorry, I am afraid that I can't help.

Linda

-----Original Message----- From: Carol Sutfin [mailto:csutfin@AMSOUTH.COM] Sent: Tuesday, July 18, 2000 10:44 AM To: DB2-L@RYCI.COM Subject: Re: DB2 - CICS threads



Linda, and all

I have tried using the -CANCEL THREAD(token) here. The problem is that DB2 will only cancel the thread when it is actively doing something in DB2. These threads aren't really active (doing SQL). No CPU cycles. Therefore DB2 cannot cancel them and they continue to hold resources and cause problems with the batch jobs. [...] 10445 50 21_Re: URGENT : software12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 18 Jul 2000 11:56:36 -0400372_us-ascii I'm not sure I would want a legal department working for me that truly didn't know the difference!

There are gray areas between hardware and software which I would say are:-

Software written on paper is software but fails the 'kicking test'. Same for tapes, CD-ROMs etc.

Firmware and microcode looks like hardware but contains software. [...] 10496 158 57_Re: AW: Problem while connecting to DB2 UDB 6.1 on OS/3900_15_leon@CA.IBM.COM31_Tue, 18 Jul 2000 11:56:47 -0400559_us-ascii



There still seems to be some confusion on what is required to connect ot DB2 for OS/390. If you are using DB2 CCA to configure a connection and you do not see host or AS/400 identified as a choice for the target database server platform then you do not have DB2 Connect installed. This means that you will not have direct connectivity to DB2 for OS/390. You will be able to go through a DB2 Connect Enterprise Edition server if you have one somewhere in your organization. If you do not see host or AS/400 systems in the DB2 CCA [...] 10655 75 57_Re: AW: Problem while connecting to DB2 UDB 6.1 on OS/39022_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 18 Jul 2000 12:26:34 -0400645_- Leon -

Is the $39 DB2 Personal Developers Edition V6.1 purchased from IBMShop an unlimited license or a "try and buy" 60 day license?



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

> ---------- > From: leon@CA.IBM.COM[SMTP:leon@CA.IBM.COM] > Sent: Tuesday, July 18, 2000 11:56 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] AW: Problem while connecting to DB2 UDB 6.1 on > OS/390 > > <> > > > There still seems to be some confusion on what is required to connect ot > DB2 for OS/390. If you are using DB2 CCA to configure a connection and you > do not [...] 10731 54 33_Re: DDF performance consideration22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 18 Jul 2000 12:36:25 -0400641_- The DB2 Connectivity Supplement is very useful as well.



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

> ---------- > From: Philip Gunning[SMTP:pgunning@PHEAA.ORG] > Sent: Tuesday, July 18, 2000 9:10 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DDF performance consideration > > Roland, These are a few of the references that I would recommend that you > look > at. They deal with all aspects of tuning DB2 Connect in a TCPIP and SNA > environment. Be aware of the fact that DB2 creates an enclave for DDF > connections coming in and these enclaves can use a lot of CPU if [...] 10786 103 54_Re: How do you get one site to be instep with another?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 18 Jul 2000 11:54:41 -0500551_iso-8859-1 Leslie, In a "prior life" we had RRDF tested and all but implemented just before I left and was satisfied it would work. Some issues worth mentioning that where applicable then but maybe not now due to upgrades in the product: 1) The DR site cannot have RI because of the way the "apply" process worked. We had developed a method to build all the required ALTERs to put RI on and put them in table that was also under RRDF. 2) All source tables participating in DR require DATA CAPTURE CHANGES. Has impact on amount of logging. 3) How [...] 10890 19 18_Re: 15 table limit14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Tue, 18 Jul 2000 13:03:51 -0400455_us-ascii I would be curious to know what you found to be wrong with my statement. Since I have personally written 40+ table queries for my developers and have had to deal with the ramifications of the limit for several months, I am curious to know what I have missed when answering the question originally ask as to the "as" clause being counted as a table (not the use for columns) by DB2 and the general comments I made as to what IBM did and why. [...] 10910 25 27_Stable Put Level for DB2 V625_Skelton, Terry (corp) USX21_tskelton.inc@MOOG.COM31_Tue, 18 Jul 2000 13:06:48 -0400379_- We have the base tapes for DB2 V6 and maint tapes up to Put 9907.We're going to install V6 in our TEST regions. Does anyone have a good feel for what Put level we should be at before turning it over to our applications group to start testing? Also, is there an IBM website that states put levels and what was corrected? I couldn't find anything substantial. Thanks, Terry [...] 10936 14 16_Fisher-Price DB213_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Tue, 18 Jul 2000 12:15:57 -0500403_- As for "Fisher-Price DB2", the top TPC-C score has intel inside.

I guess there's no limit to what you can build, if you've got enough legos.

-HJC

================================================ 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. 10951 34 20_Re: Fisher-Price DB214_Ruth Gramolini26_rgramolini@TAX.STATE.VT.US31_Tue, 18 Jul 2000 13:40:22 -0400682_iso-8859-1 The same kind of results were found for Oracle but then M$ had to retract the numbers. Hmmmm...RBG ----- Original Message ----- From: Henry J. Cobb Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, July 18, 2000 1:15 PM Subject: Fisher-Price DB2



> As for "Fisher-Price DB2", the top TPC-C score has intel inside. > > I guess there's no limit to what you can build, if you've got enough legos. > > -HJC > > ================================================ > 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 [...] 10986 100 22_Re: DB2 - CICS threads5_Sales16_sales@RELARC.COM31_Tue, 18 Jul 2000 14:16:47 -0400420_iso-8859-1 The company I work for, Relational Architects, has a product named the DB2 Thread Control Series. It allows you to cancel any kind of DB2 thread as well as threads originating from a CICS transaction. The latest version of Thread/SERIES was enhanced to issue a series of DB2, MVS, CICS and communications commands to remove CICS / DB2 threads along with the originating CICS transactions, if so desired. [...] 11087 44 20_Re: Fisher-Price DB215_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 13:26:35 -0500486_iso-8859-1 If you put too many Legos(TM)together doesn't the overhead it takes to coordinate the workload that all those Legos(TM) are processing eventually become greater than the workload itself?

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

"A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila." - Mitch Ratliffe [...] 11132 26 38_Re: Problems with DSNDB01.SYSLGRNX ...17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 18 Jul 2000 20:31:11 +020077_us-ascii Greg, Davis : thanks for yours suggestion.

Alessandro

11159 65 33_No need to re-initialize SYSUTILX28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 18 Jul 2000 10:06:07 PDT356_- There is a way to get TERM command to delete a SYSUTILX record without dropping and redefining the VSAM data set. The steps below cause TERM to think no cleanup of any kind is required and simply delete the row from SYSUTILX. This method removes ONE stopped utility row, rather than ALL rows, which may or may not be important in a given situation. [...] 11225 98 57_Re: AW: Problem while connecting to DB2 UDB 6.1 on OS/39023_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 18 Jul 2000 14:36:13 -0400462_- Leon,

Are there any issues with DB2 connect on Windows/98 connecting to DB2/OS390 (ver 5 and ver 6) ?. I have had no problem installing UDB ver 6 and ver 7 on Windows/NT and then connecting to mainframe DB2. But I have not been able to do so on my Laptop (Window 98). In DB2 CCA (under Windows 98), I don't get the choice for target database server platform that I get under Windows NT. The error message on DB2MSTR after the connection attempt is [...] 11324 80 17_Re: When to REORG0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 18 Jul 2000 13:46:28 -0500429_us-ascii Something that I have "home brewed" is to keep track of the changed pages for each tablespace pageset. With some native VSAM code, you can skip through the bit maps on a tablespace and come up with the number of pages that are changed. If you then keep track of this (possibly in a DB2 table that has a key of the tablespace name), you can then do reorganizations based on how frequently that a pageset is changed. [...] 11405 95 31_Re: Stable Put Level for DB2 V615_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 18 Jul 2000 14:51:44 -0400267_iso-8859-1 We are running with PDO Level 0005 of DB2 V6.1 for OS/390 V2.6 in out DB2 test subsystem. I believe I have read on past DB2 postings that the RML was Level 0003, but there's been many fixes since that time some of which are hipers and ones we needed. [...] 11501 62 20_Re: Fisher-Price DB212_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 18 Jul 2000 11:53:41 PDT735_- Isn't it CA/Legos(tm) now????



>From: "Billings, Linda" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Fisher-Price DB2 >Date: Tue, 18 Jul 2000 13:26:35 -0500 > >If you put too many Legos(TM)together doesn't the overhead it takes to >coordinate the workload that all those Legos(TM) are processing eventually >become greater than the workload itself? > >Linda Billings >Enterprise Systems Programmer >Info-Tech Services >Department of Administration >State of Wisconsin > >"A computer lets you make more mistakes faster than any invention in >human history - with the possible exceptions of handguns and tequila." - >Mitch Ratliffe > > [...] 11564 78 20_Re: Fisher-Price DB215_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 18 Jul 2000 14:00:39 -0500822_iso-8859-1 Ouch! Don't say that too loudly! You will give them ideas!

Linda

-----Original Message----- From: craig patton [mailto:prgpatton@HOTMAIL.COM] Sent: Tuesday, July 18, 2000 1:54 PM To: DB2-L@RYCI.COM Subject: Re: Fisher-Price DB2



Isn't it CA/Legos(tm) now????



>From: "Billings, Linda" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Fisher-Price DB2 >Date: Tue, 18 Jul 2000 13:26:35 -0500 > >If you put too many Legos(TM)together doesn't the overhead it takes to >coordinate the workload that all those Legos(TM) are processing eventually >become greater than the workload itself? > >Linda Billings >Enterprise Systems Programmer >Info-Tech Services >Department of Administration >State [...] 11643 89 20_Re: Fisher-Price DB214_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Tue, 18 Jul 2000 15:12:31 -0400657_us-ascii We are CA Resistance is futile Everything will be assimilated

;-) Bill G.

Billings, Linda wrote:

> Ouch! Don't say that too loudly! You will give them ideas! > > Linda > > -----Original Message----- > From: craig patton [mailto:prgpatton@HOTMAIL.COM] > Sent: Tuesday, July 18, 2000 1:54 PM > To: DB2-L@RYCI.COM > Subject: Re: Fisher-Price DB2 > > Isn't it CA/Legos(tm) now???? > > >From: "Billings, Linda" > >Reply-To: DB2 Data Base Discussion List > >To: DB2-L@RYCI.COM > >Subject: Re: Fisher-Price DB2 > >Date: Tue, 18 Jul 2000 13:26:35 -0500 > > > >If you put too many [...] 11733 170 31_Re: Stable Put Level for DB2 V612_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 18 Jul 2000 12:44:25 -0700358_us-ascii It would be very interesting to hear now what the official "gold" level is. My client put 003 on and then the "gold" level tape after that and still had to put on over 200 PTFs due to many problems with the "gold" level tape ptfs in hold status. Some of the PTFs forced to put on were just issued in the last couple of weeks. Its really scary. [...] 11904 112 20_Re: Fisher-Price DB29_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 18 Jul 2000 13:32:18 -0600436_iso-8859-1 I remember a few months ago the rumor was that CA acquired itself. If I were Bill Gates or Larry Ellison I would be watching my "backside".

DBA

-----Original Message----- From: William Gannon [mailto:wgannon@INET-SERVICES.PALMBEACH.K12.FL.US] Sent: Tuesday, July 18, 2000 1:13 PM To: DB2-L@RYCI.COM Subject: Re: Fisher-Price DB2



We are CA Resistance is futile Everything will be assimilated [...] 12017 68 20_Re: Fisher-Price DB220_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Tue, 18 Jul 2000 15:02:49 -0500658_- The latest about CA and Microsoft: Subject: MS & CA



Judge Jackson stuns court, sentences Microsoft to "fate worse than death" Before a packed and hushed courtroom, Judge Thomas Penfield Jackson today rendered his final decision in the Microsoft anti-trust case. "In my opinion, it is practially impossible to be any more guilty of monopolistic practices than Microsoft," said the Judge. "I contemplated breaking Microsoft into little teeny tiny pieces, but suddenly it occurred to me that they deserve a far worse punishment." "I hereby sentence Microsoft to be acquired by Computer Associates," intoned the Judge, his voice laced with [...] 12086 21 33_Stored procedures and SMTP e-mail0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 18 Jul 2000 13:03:33 -0500340_us-ascii I just had a wild thought. Is it possible to send e-mail from a stored procedure that runs on DB2 for MVS?

Has anyone out there ever attempted to do something like this?

Does anyone have any code fragments that they could share for putting this type of process together?

Larry Kirkpatrick Mutual of Omaha [...] 12108 59 49_Re: Are BMC indexes on the DB2 Catalog desirable?0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 18 Jul 2000 13:11:32 -0500420_us-ascii Not only would I create the indexes on the catalog tables, I would also be careful to set up the proper index(s) on the PLAN_TABLES to support the "DESC" function on either a DBRM or a package. This function can show the access paths that DB2 chose for a given query if the PLAN_TABLE information exists. However, if the PLAN_TABLE does not have the proper index, the "DESC" function will go out to lunch! [...] 12168 54 37_My QMF question never got any answers0_23_edie.richardson@SRS.GOV31_Tue, 18 Jul 2000 16:21:12 -0400533_us-ascii I sent this eariler but did not get any replies. Does anyone have a clue? Your assistance is greatly appreciated. ---------------

I'm using QMF to edit values in a table. The table has a column that has packed data in it that is nullible. Everytime I return a row that has data in the packed column and try to PF8, I get an error and exitted out of the editor. It also will not let me edit the packed column thru QMF. Does anyone know how I can edit this packed column using the QMF table editor? And of course, [...] 12223 45 41_Re: My QMF question never got any answers22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 18 Jul 2000 16:48:21 -0400690_- QMF for OS/390 V6.1 books are at http://www.ibm.com/software/data/db2/os390/v6books.html



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

> ---------- > From: edie.richardson@SRS.GOV[SMTP:edie.richardson@SRS.GOV] > Sent: Tuesday, July 18, 2000 4:21 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] My QMF question never got any answers > > > I sent this eariler but did not get any replies. Does anyone have a clue? > Your assistance is greatly appreciated. > --------------- > > I'm using QMF to edit values in a table. The table has a column that has > packed data in it that is nullible. Everytime I return a row that has > data [...] 12269 41 41_Re: My QMF question never got any answers9_Birk, Tim17_BirkT@DIEBOLD.COM31_Tue, 18 Jul 2000 17:10:22 -0400428_iso-8859-1 Edie,

You don't say whether this column is decimal, or char with packed data in it. I suspect the latter. The QMF table editor will convert a decimal column to displayable format, but it displays a character column as is. If it's loaded with nondisplayable data, it cannot be updated. And depending on what the undisplayable data is, it may send a control code to your 3270 session that will screw it up. [...] 12311 27 28_-913 SQLCODE and DB2 Connect13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 18 Jul 2000 16:31:02 -0500598_iso-8859-1 Hello,

Can anyone shed some light on why our distributed SQL (through DB2 Connect) receives -913's from resource timeouts on the host (DB2 OS/390 V5). The exact SQL when run through SPUFI (or any host process) receives -911's.

The reason we are interested in this difference is because with a -911, DB2 rolls back any updates automatically and with a -913, the application must do it. This is definitely manageable, but we are wondering why 'distributed' processes do not behave the same? Is it how we have our environment set up (i.e. is it controllable/changeable)? [...] 12339 94 21_Re: URGENT : software12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Tue, 18 Jul 2000 17:39:53 -0400548_iso-8859-1 http://www.whatis.com/ http://www.m-w.com/dictionary.htm http://www.dictionary.com/



----Original Message----- From: Briggs, N. - Neil - [mailto:N.Briggs@CANON-EUROPA.COM] Sent: Tuesday, July 18, 2000 10:18 AM To: DB2-L@RYCI.COM Subject: URGENT : software



Dear All

A bit off topic this but any help will be greatly appreciated. Can somebody please advise me as to the definitions for the following:-

Software Hardware

I have been asked to supply this information to our legal dept. [...] 12434 78 62_Repost: July 19 Web broadcast features DB2 Net Search Extender13_Morrill, John12_JohnM@VP.NET31_Tue, 18 Jul 2000 16:43:11 -0600365_iso-8859-1 Dear DB2 Interested Parties,

On July 19 at 11:00am - 12:30pm EDT, IBM developerWorks will broadcast over the Web a session on high speed text search using the new DB2 Net Search Extender ( http://www.ibm.com/software/data/db2/extenders/netsearch/ ) available with DB2 UDB for UNIX, Windows, OS/2 Version 7. Below is an abstract of the event. [...] 12513 25 18_Secondary auth IDs16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Tue, 18 Jul 2000 16:06:21 -0700578_- We are finally investigating setting up and using secondary auth ids. Our attempts so far have not been good. We compiled the sample authorization exits using the JCL in DSNTIJEX. Everything compiled ok. We recycled our test DB2 system to incorporate the exits. We created a RACF group ID, call it AGRP, and granted CREATEDBA as one of the authorizations to that group id in the DB2 subsystem. We then connected a TSO id, call it ATSOID, to AGRP. ATSOID does not have any explicit authorizations in the DB2 subsystem. When ATSOID tried to create a database it received a [...] 12539 55 22_Re: Secondary auth IDs13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 18 Jul 2000 16:10:42 -0700652_iso-8859-1 Did you do a :

SET CURRENT SQLID = 'AGRP'

Ashish.

-----Original Message----- From: Duane Lee - ATCX [SMTP:DLee@MAIL.MARICOPA.GOV] Sent: Tuesday, July 18, 2000 4:06 PM To: DB2-L@RYCI.COM Subject: Secondary auth IDs

We are finally investigating setting up and using secondary auth ids. Our attempts so far have not been good. We compiled the sample authorization exits using the JCL in DSNTIJEX. Everything compiled ok. We recycled our test DB2 system to incorporate the exits. We created a RACF group ID, call it AGRP, and granted CREATEDBA as one of the authorizations to that group id in the DB2 subsystem. [...] 12595 70 43_has anyone used OAM - Object Access Method?14_Peter McKellar32_peter.mckellar@CENTRELINK.GOV.AU31_Wed, 19 Jul 2000 10:50:23 +1000543_us-ascii Hello,

I am interested in anyone's observations on how well OAM (Object Access Method) works and would welcome any feedback.

We are currently evaluating it as a possibility for archiving a large amount of our data (about 2 terabytes, adding about 1 terabyte per year). These archives could then be accessed as required and the object retrieved would then be moved within the storage heirarchy to be cached on disk for subsequent reference. OAM appears to meet our needs, but the documentation is not exactly clear. [...] 12666 24 40_DB2 Migration V4 to V5 CATMAINT 00E4060130_GROUPIT - Jenny Kuan Kong Lang19_jennykkl@MAS.COM.MY31_Wed, 19 Jul 2000 09:33:56 -0700413_us-ascii Hi, In my attempt to invoke CATMAINT to migrate DB2 V4 to V5, the job 'abended' with error code 00E40601. DB2 subsystem came tumbling down with ABEND=S04F U0000 REASON=00000000 in MSTR address space, DUMP TITLE=DBT, ABND=04E-00E40601,U=DB2ADM0, C=XYR00.510.UTIL-DSNUECMI,M=DSNTFRCV,LOC=DSNUTILA.DSNUEXDL+0B28 in DBM1 address space. We are at DB2 Version 4 PUT9910, running on OS/390 V1.3. Any clue? [...] 12691 21 21_corporate data policy13_Al DiGiovanni13_al-d@HOME.COM31_Tue, 18 Jul 2000 23:14:42 -0400496_us-ascii I'm developing a corporate data policy and guidelines for the usage of data from adhoc reporting and distribution to client customers. Does anyone have a written policy they would like to share, and further develop and enhance?



> ================================================ > 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. [...] 12713 57 45_Re: DDF performance consideration - Thank you11_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Wed, 19 Jul 2000 12:58:34 +0800708_us-ascii Thank You. Philip and Mike for your fast response and recommendation.







Philip Gunning @RYCI.COM> on 18/07/2000 09:10:59 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Re: DDF performance consideration



Roland, These are a few of the references that I would recommend that you look at. They deal with all aspects of tuning DB2 Connect in a TCPIP and SNA environment. Be aware of the fact that DB2 creates an enclave for DDF connections coming in and these enclaves can use a lot of CPU if not [...] 12771 18 33_Re: DDF performance consideration13_John Schluter23_john.schluter@TELIA.COM31_Wed, 19 Jul 2000 02:18:31 -0500418_- You can start at:

http://www-4.ibm.com/software/data/db2/performance/

and maybe do a search of the redbooks at:

http://www.redbooks.ibm.com.

/John

================================================ 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. 12790 30 42_REXX interface problem: DESCRIBE statement16_Singh, Harmander26_Harmander.Singh@ATO.GOV.AU31_Wed, 19 Jul 2000 17:53:18 +1000444_iso-8859-1 Hi,

I am unable to run the following SQL using the DB2 REXX interface:

"EXECSQL DESCRIBE TABLE :TABLE INTO :SQLDA"

The REXX variable TABLE contains the name of a table (dbowner.table)

The run fails with an SQLCODE of -188 (the string representation of a name is invalid).

This is especially surprising because the code is copied verbatim from the 'DRAW' macro provided in the DB2 REXX manual. [...] 12821 95 17_Re: When to REORG10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Wed, 19 Jul 2000 10:09:33 +0100658_iso-8859-1 thank you

-----Original Message----- From: L-IS.Kirkpatrick@MUTUALOFOMAHA.COM [mailto:L-IS.Kirkpatrick@MUTUALOFOMAHA.COM] Sent: Tuesday, July 18, 2000 6:46 PM To: DB2-L@RYCI.COM Subject: Re: When to REORG



Something that I have "home brewed" is to keep track of the changed pages for each tablespace pageset. With some native VSAM code, you can skip through the bit maps on a tablespace and come up with the number of pages that are changed. If you then keep track of this (possibly in a DB2 table that has a key of the tablespace name), you can then do reorganizations based on how frequently that a pageset is changed. [...] 12917 68 46_Re: REXX interface problem: DESCRIBE statement14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 19 Jul 2000 18:34:18 +1000541_iso-8859-1 Harminder

Hmmm, had exactly the same experience. I posted what I found. Why don't you get a bit of practise in searching the archives? http://jupiter.ryci.com/archives/db2-l.html

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au

-----Original Message----- From: Singh, Harmander [mailto:Harmander.Singh@ATO.GOV.AU] Sent: Wednesday, July 19, 2000 5:53 PM To: DB2-L@RYCI.COM Subject: [DB2-L] REXX interface problem: DESCRIBE statement [...] 12986 46 18_Re: 15 table limit15_Matthias Pohlig27_matthias.pohlig@T-ONLINE.DE31_Wed, 19 Jul 2000 03:20:42 -0500558_- On Tue, 18 Jul 2000 13:03:51 -0400, John P Shipley wrote:

>I would be curious to know what you found to be wrong with my statement. Since >I have personally written 40+ table queries for my developers and have had to >deal with the ramifications of the limit for several months, I am curious to >know what I have missed when answering the question originally ask as to the >"as" clause being counted as a table (not the use for columns) by DB2 and the >general comments I made as to what IBM did and why. > >Patrick [...] 13033 59 31_Re: Stable Put Level for DB2 V614_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 19 Jul 2000 18:38:42 +1000395_iso-8859-1 Put 0106? (Yes, I know it won't be out for a year)

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9840 3864 James.Campbell@Hancorp.com.au

-----Original Message----- From: Skelton, Terry (corp) USX [mailto:tskelton.inc@MOOG.COM] Sent: Wednesday, July 19, 2000 3:07 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Stable Put Level for DB2 V6 [...] 13093 62 37_Re: Stored procedures and SMTP e-mail14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 19 Jul 2000 18:51:51 +1000346_iso-8859-1 Larry

Should actually be quite easy - provided you have a local SMTP server. All you'ld have to do is allocate a sysout file with an appropriate DEST and write to it.

For an example of how it can be done, have a look at Lionel Dyck's XMITIP (which is a REXX that writes emails). see http://www.geocities.com/lbdyck. [...] 13156 21 29_Clustering Indexes - Question13_Skelton Brian20_skelton.b@MELLON.COM31_Wed, 19 Jul 2000 06:51:59 -0400538_- Hope this is not a silly question.

But could someone tell me if you don't define any of your indexes as clustering. But you have primary keys, will these be used as clustering indexes or will DB2 still use the first index that you created to cluster your data.

Thanks

Brian

================================================ 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. 13178 13 33_Re: Clustering Indexes - Question14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Wed, 19 Jul 2000 07:38:56 -0400407_us-ascii It think it used to be and I assume still is the case that the oldest defined index will default to the clustering index if one is not specifically defined.

================================================ 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. 13192 59 33_AW: Clustering Indexes - Question12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 19 Jul 2000 13:51:07 +0200626_iso-8859-1 Brian,

yes, DB2 for OS/390 will choose the first created index on that specific table to cluster the data in this table.

BTW: What are your reasons not to define a clustering index ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 13252 68 22_Re: Secondary auth IDs11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Wed, 19 Jul 2000 08:16:41 -0400334_us-ascii I'll second the suggestion below and add my 2 cents worth of possible explanation. It may be that ATSOID has a PROFILE PREFIX setting - that becomes the CURRENT SQLID within DB2I (and SPUFI). So, you may get by with either of the following commands. SET CURRENT SQLID = 'AGRP' or alternatively, TSO PROFILE PREFIX(AGRP) [...] 13321 181 47_Re: has anyone used OAM - Object Access Method?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 19 Jul 2000 07:11:33 -0500486_iso-8859-1 Yes, we use OAM for our document imaging applications. I will try to answer your questions the best that I can.

1) Objects are stored in DB2 initially. How long they stay there depends on how you have set up the SMS management class for that particular group of objects (A collection). They can reside there temporarily and then get migrated to another level (commonly an optical cartridge) when the OSMC cycle runs or they can stay in the DB2 table permanently. [...] 13503 51 17_What Time is it ?24_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Wed, 19 Jul 2000 22:10:03 +1000428_iso-8859-1 I have been involved in developing a web based application , that uses an architecture along the lines that Leon Katsnelson has suggested.

- Web server - Application server - DB2 Connect EE gateway - DB2 OS/390 & Stored Procedures

Add the odd firewalls, some Java programs and surprise surprise you have a hardware and software architecture that can let a web clients access data on our mainframe. [...] 13555 42 88_Urgent help required : Handling of Japanese (Kana and Kanji) characters by DB2 on OS/39010_K V Ramana27_kv_ramana@CHENNAI.TCS.CO.IN31_Wed, 19 Jul 2000 17:55:21 +0530387_us-ascii Hi,

Anyone out there knows how exactly DB2 (Ver 6.1 on OS/390) handles both single-byte Kana and double-byte Kanji characters. We specified a CCSID of 939 in DSNZPARM. We would like to know if

1) If DB2 can handle mixed characters comprising of single byte EBCDIC, single byte Kana and double byte Kanji. If so, what is the correct code page to be specified. [...] 13598 295 47_Re: has anyone used OAM - Object Access Method?0_26_mark.walker@CUNAMUTUAL.COM31_Wed, 19 Jul 2000 07:31:25 -0500448_us-ascii

Just a note on #10 below. I saw some documentation yesterday that in OS/390 2.9, you can set up an OAMPlex to work in a sysplex datasharing environment. We haven't investigated the particulars yet, but we're guessing that we will pursue it.

Mark Walker









(Embedded image moved "Billings, Linda" to file: @RYCI.COM> pic23992.pcx) 07/19/2000 07:11 AM [...] 13894 115 17_Re: When to REORG19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 19 Jul 2000 07:31:35 -0500439_iso-8859-1 Hi Larry, I'm not being critical or "snippy" here but it seems to me that a change to a page isn't necessarily a reason to reorg. (Consider an UPDATE in-place.) You are also reliant on Image Copy or some other method setting the change bit back. Is there something unique to your site's data or processing that would make changed pages a reorg trigger? Or do you perform some further checking after finding a changed page? [...] 14010 110 22_Re: Secondary auth IDs12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 19 Jul 2000 05:32:32 PDT506_- 1 point to make about secondary ids, for GRANT, REVOKE and CREATE it is the authorizations of the CURRENT SQLID ONLY that are used. For all other SQL, it is the combination of CURRENT SQLID and ALL SECONDARY ID Authorizations that are used. So you must SET CURRENT SQLID to the secondary ID for the GRANT REVOKE and CREATE, but NOT for SELECT, UPDATE DELETE....etc. The OTHER exception is the OWNER of a PLAN or PACKAGE that must have the authorizations to access the tables in the PLAN or PACKAGE. [...] 14121 254 47_Re: has anyone used OAM - Object Access Method?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 19 Jul 2000 07:39:10 -0500302_iso-8859-1 Hi, Mark!

I hope that this is an improvement on the "OAMPLEX" that I saw a while back. That one only made it possible to bring your OAM on a different LPAR and then manually switch the optical devices to point to the different LPAR. I didn't like it. It seemed too clunky to me. [...] 14376 29 33_Re: Clustering Indexes - Question16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 19 Jul 2000 13:38:59 +0100376_- I agree - DB2 chooses the FIRST index created as CLUSTERING - until you explicitely define an index as CLUSTER. However - remember that data will NOT be clustered if the index is NOT defined as CLUSTER. I tried this back in version 4 - and after a reorg - data was in the exact same sequence as before the reorg. I must admit I dont kknow if this has changed since V4. [...] 14406 60 33_Re: Clustering Indexes - Question12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 19 Jul 2000 13:00:25 GMT301_- It is TRUE that a REORG without a CLUSTERing index will NOT change the ORDER of the DATA in the table to match the 'default clustering' index. In this case the REORG simply reestablishes FREEPAGE and PCTFREE. This has been true since the beginning of DB2 (v1.3 for me)

HTH, Craig Patton [...] 14467 64 22_Re: Secondary auth IDs11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Wed, 19 Jul 2000 08:34:24 -0500405_- A couple of possibilities........

Be sure that your exit is concatenated first in your DB2 procs. IBM ships a prototype exit which is in SDSNLOAD. If this is concatenated ahead of SDSNEXIT your exit may not be the one that is in effect.

Also, you might want to check your LNKLSTxx member to see order of concatenation if not overriding this in your SYS2.PROCs for your DB2 subsystem. [...] 14532 51 33_Re: Clustering Indexes - Question15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 19 Jul 2000 08:42:50 -0500312_iso-8859-1 I think that it must also be clarified here that a primary key and a clustering key don't have to be the same and, very often, are not. A primary key is considered an entry point to the data in a data model. It is also used to enforce RI. A clustering key only keeps the data in a certain order. [...] 14584 63 33_Re: Clustering Indexes - Question0_19_mike.holmans@BT.COM31_Wed, 19 Jul 2000 14:53:29 +0100353_- If you don't define a clustering index, DB2 for OS/390 makes an arbitrary decision as to which index to use for sequencing purposes.

In shorthand, it's the first index defined, but remember that DB2 can't read your design documentation and doesn't know in what order you thought up the indexes: it only has the catalog/directory to go on. [...] 14648 125 47_Re: has anyone used OAM - Object Access Method?12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Wed, 19 Jul 2000 08:58:14 -0500336_- Peter,

I will add to what Linda had:

7. Yes, We are currently (and have been for at least 6 years) using OnDemand to access objects using OAM. You do need to be careful about how long (or not long) you keep objects on DASD before they migrate to Optical platter (or tape). We also use OAM to store objects on tape. [...] 14774 134 17_Re: When to REORG20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Wed, 19 Jul 2000 14:57:43 +0100282_iso-8859-1 I too don't like to be critical, but I don't get it either. The method described would be one way of deciding whether to take an image copy, (or would be if there was no CHANGELIMIT parameter!), but I can't see how it helps at all in deciding whether to reorganise. [...] 14909 20 24_Unload from Image Copies12_Aditya Narra31_Aditya.Narra@NYCBOE.NYCENET.EDU31_Wed, 19 Jul 2000 10:10:00 -0400538_- Hi All, I am trying to do an unload from an Image copy but I am not able to do it.I gave the SYSIN as follows,please do let me know if I am wrong. Thanks, Audi //UNLOAD DD DSN=RAMS1.APPL1.IC.DPGA1OR1.STGAREM1S1.G0064V00,DISP=SHR //SYSIN DD * INFILE UNLOAD SELECT * FROM RAMT3.REIMTL ;

/*

================================================ 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. 14930 165 17_Re: When to REORG20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 19 Jul 2000 10:07:34 -0400365_iso-8859-1 I too am a little bit critical with this approach. The space map information is subjected to change from release to release e.g. TRACKMOD NO & member cluster etc. Simply looking at dirty bit does not really mean that reorg may be necessary. If a shop is using BMC COPY PLUS and uses RESETMOD NO then dirty bits will not be touched by the imagecopy. [...] 15096 53 28_Re: Unload from Image Copies15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Wed, 19 Jul 2000 09:18:49 -0500725_us-ascii What utility are you using? Platinum/CA (uhhhh) has a fast unload utility that works great!

DeeDee









Aditya Narra cc: Sent by: DB2 Data Base Subject: Unload from Image Copies Discussion List



07/19/00 09:10 AM Please respond to DB2 Data Base Discussion List









Hi All, I am trying to do an unload from an Image copy but I am not able to do it.I gave the SYSIN as follows,please do let me know if I am wrong. Thanks, Audi //UNLOAD DD DSN=RAMS1.APPL1.IC.DPGA1OR1.STGAREM1S1.G0064V00,DISP=SHR //SYSIN DD * INFILE UNLOAD SELECT * FROM RAMT3.REIMTL ; [...] 15150 181 17_Re: When to REORG14_Maxfield, John21_John_Maxfield@BMC.COM31_Wed, 19 Jul 2000 09:41:30 -0500609_iso-8859-1 This may already be obvious to some... but I thought it was worth mentioning in this thread.

Two important indicators of file page set disorganization are OFFPOS and INDREF.

NEAROFFPOS/FAROFFPOS represent the number of rows that have not been inserted close to rows with similar clustering key values because of a lack of space in the key range. These values can be found in SYSINDEXPART. DB2 Version 6 uses these values in their conditional reorg enhancement. The calculation (NEAROFFPOSF + FAROFFPOSF) * 100 / CARDF is used to determine the percentage of rows that are OFFPOS. [...] 15332 174 17_Re: When to REORG0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 19 Jul 2000 09:38:44 -0500621_us-ascii Rick -

I realize that I have left out many details regarding using changed pages as a trigger for reorganizations. That was intentional. I really wanted to present a concept and not a specific solution.

I also realize that a reorganization should not be done each time a page is changed. You could (conceptually) track the number or percentage of changed pages and then use this information as a "leading indicator" of when to do a reorganization. You could further validate this by running the runstats utility whenever the accumulated changed pages hits a threshold and then use DB2 queries [...] 15507 40 28_Re: Unload from Image Copies20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 19 Jul 2000 10:40:04 -0400391_us-ascii You haven't provided sufficient information. Seems to me that your are trying BMC unload from an imagecopy. What is the error message? Could you show your complete JCL instead of just SYSIN ?

-----Original Message----- From: Aditya Narra [SMTP:Aditya.Narra@NYCBOE.NYCENET.EDU] Sent: Wednesday, July 19, 2000 10:10 AM To: DB2-L@RYCI.COM Subject: Unload from Image Copies [...] 15548 211 17_Re: When to REORG9_Mike Mays26_MikeM@EGGERSCONSULTING.COM31_Wed, 19 Jul 2000 09:48:13 -0500592_iso-8859-1 I have a question for the list. Can anyone tell me where to search for a list of some sort that would contain names of companies that use DB2 as a database in the Chicago area? Thanks for the help. Mike





> -----Original Message----- > From: Maxfield, John [SMTP:John_Maxfield@BMC.COM] > Sent: Wednesday, July 19, 2000 9:41 AM > To: DB2-L@RYCI.COM > Subject: Re: When to REORG > > This may already be obvious to some... but I thought it was worth > mentioning > in this thread. > > Two important indicators of file page set disorganization are OFFPOS and [...] 15760 167 47_Re: has anyone used OAM - Object Access Method?12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 19 Jul 2000 09:58:03 -0500668_us-ascii Hi Peter, Just to clarify, I think from your original posting you are talking about writing your own application to store data using OAM. OAM is an access method, an operating system service, which in turn, is used beneath several IBM-written applications (OnDemand, ImagePlus, Visual Info). OAM objects stored by one application (ImagePlus) would not be retrievable by another application (OnDemand), because they would not share their object catalog information, and even if they could, they would not necessarily understand each other's data content. So anything that you stored with your in-house written (native) OAM application would not be usable [...] 15928 56 28_Re: Unload from Image Copies12_Moreno, Jose19_Jose_Moreno@BMC.COM31_Wed, 19 Jul 2000 10:15:44 -0500540_iso-8859-1 If you are using BMC's UNLOAD PLUS the correct JCL should be something like :

//UNLOAD EXEC PGM=ADUUMAIN,REGION=0M, // PARM='ssid,,NEW,,MSGLEVEL(1)' //SYSIN DD * UNLOAD INFILE DD1 SELECT * FROM RAMT3.REIMTL * //DD1 DD RAMS1.APPL1.IC.DPGA1OR1.STGAREM1S1.G0064V00,DISP=SHR //SYSREC DD DSN=your.SYSREC, // DISP=(,CATLG),SPACE=(xxx),UNIT=xxx //SYSCNTL DD DSN=your.SYSCNTL, // DISP=(,CATLG),SPACE=(TRK,(1,1)),UNIT=xxx //UTPRINT DD SYSOUT=* //SYSPRINT DD SYSOUT=*

Jose Moreno BMC Software EMEA DB2 Solutions Manager [...] 15985 30 44_Re: DB2 Migration V4 to V5 CATMAINT 00E4060112_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 19 Jul 2000 10:18:00 -0400675_- Check SYSLOG for other messages. I don't remember this error, but we did have problems when the TEMP tablespaces were too small. Also, check the volumes that the catalog is on to make sure you have enough space to extend. Good Luck. >>> DB2-L@RYCI.COM@i 07/18/00 08:26PM >>> Hi, In my attempt to invoke CATMAINT to migrate DB2 V4 to V5, the job 'abended' with error code 00E40601. DB2 subsystem came tumbling down with ABEND=S04F U0000 REASON=00000000 in MSTR address space, DUMP TITLE=DBT, ABND=04E-00E40601,U=DB2ADM0, C=XYR00.510.UTIL-DSNUECMI,M=DSNTFRCV,LOC=DSNUTILA.DSNUEXDL+0B28 in DBM1 address space. We are at DB2 Version 4 PUT9910, running on OS/390 V1.3. Any [...] 16016 231 17_Re: When to REORG9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Wed, 19 Jul 2000 09:26:59 -0600545_iso-8859-1 Following is a very good Web Site discussing DB2 for OS390 REORG information.

http://www.gabrielledb2.com/brr.pdf

Cheers, DBA

-----Original Message----- From: Mike Mays [mailto:MikeM@EGGERSCONSULTING.COM] Sent: Wednesday, July 19, 2000 8:48 AM To: DB2-L@RYCI.COM Subject: Re: When to REORG



I have a question for the list. Can anyone tell me where to search for a list of some sort that would contain names of companies that use DB2 as a database in the Chicago area? Thanks for the help. Mike [...] 16248 57 44_Re: DB2 Migration V4 to V5 CATMAINT 00E4060114_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 19 Jul 2000 10:48:55 -0500450_- for the 1st run of the CATMAINT at our shop, we had to run against the compatability PTF:

CATMAINT UPDATE UNLDDN PQ22051

then after it ran, we ran the 2nd run:

CATMAINT UPDATE

Maybe this will help

-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Wednesday, July 19, 2000 9:18 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Migration V4 to V5 CATMAINT 00E40601 Sensitivity: Personal [...] 16306 38 17_Re: When to REORG12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Wed, 19 Jul 2000 10:49:03 -0500574_us-ascii The ones I know of:

First National Bank Harris Bank Northern Trust LaSalle Bank AB&Amro Bank One Aon Insurance Blue Cross Blue Sheild CNA Alstate Zurich Insurance CBOE Merchantile Exchange Amoco Trans Union Peoples Gas Com Ed McDonalds Jewel Foods Dominicks Sears Montgomery Wards



All Consulting Firms

================================================ 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. 16345 94 17_Re: When to REORG12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Wed, 19 Jul 2000 11:05:00 -0500402_us-ascii Thanks, John.

I think that the impact of NEAROFFPOS/FAROFFPOS depends on the nature of your processing. If you are retrieving clusters of rows, it is important to be in good clustering order. However, if you are retrieving single rows (OLTP processing), then clustering means very little. I would set a higher OFFPOSLIMIT in the conditional reorg for non-cluster-dependent tables. [...] 16440 200 17_Re: When to REORG19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 19 Jul 2000 10:59:44 -0500512_iso-8859-1 Larry, OK, I'll concede that tracking the number of changed pages by tablespace could be used as an "indicator" to do a RUNSTATS on that tablespace (no sense doing RUNSTATS on tablespaces that have no UPDATE, INSERT, or DELETE activity). My decision to reorg would be based on RUNSTATS info. Again, it could be that for a given tablespace all access was due to UPDATEs in-place and a reorg would not be required (given no VARCHAR columns). How do you determine when an index needs to be reorged? [...] 16641 47 22_Re: When to REORG?????13_john arbogast19_arbo@CP-DEMO.CP.NET31_Wed, 19 Jul 2000 09:07:40 -0700549_- What in the world does this have to do about when to reorg???!!!



On Wed, 19 July 2000, Dan Sullivan wrote:

> > The ones I know of: > > First National Bank > Harris Bank > Northern Trust > LaSalle Bank > AB&Amro > Bank One > Aon Insurance > Blue Cross Blue Sheild > CNA > Alstate > Zurich Insurance > CBOE > Merchantile Exchange > Amoco > Trans Union > Peoples Gas > Com Ed > McDonalds > Jewel Foods > Dominicks > Sears > Montgomery Wards > > > All Consulting Firms > > ================================================ > [...] 16689 28 22_Re: When to REORG?????13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Wed, 19 Jul 2000 11:06:02 -0500347_- >What in the world does this have to do about when to reorg???!!! > >> The ones I know of: >> >> First National Bank >> Harris Bank >> Northern Trust >> LaSalle Bank >> AB&Amro >> Bank One

I assume he means that there is more merger and acquisition activity coming up during the next financial sector reorg. [...] 16718 63 17_Re: When to REORG0_20_bjnigh@HOUSEHOLD.COM31_Wed, 19 Jul 2000 10:01:15 -0700728_us-ascii Household International, the company I work for, also uses DB2. They are located in the Chicago area.









Dan Sullivan on 07/19/2000 08:49:03 AM

Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM cc: (bcc: Barbara J. Nigh/Household International) Subject: Re: When to REORG





The ones I know of:

First National Bank Harris Bank Northern Trust LaSalle Bank AB&Amro Bank One Aon Insurance Blue Cross Blue Sheild CNA Alstate Zurich Insurance CBOE Merchantile Exchange Amoco Trans Union Peoples Gas Com Ed McDonalds Jewel Foods Dominicks Sears Montgomery Wards [...] 16782 30 28_Urgent solution required....17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Wed, 19 Jul 2000 22:52:21 +0500473_- Hello All,

We are doing a VSAM to DB2 migration. The CICS programs perform STARTBR,READNEXT,READPREV on the VSAM files. Now the VSAM files have been migrated to DB2 tables.

The below is how we are going about doing these things: ========================================= The STARTBR is taken care by declaring & opening a cursor where pkey >= :hostvars The READNEXT will be a fetch of this CURSOR. We need some light on how to go about doing READPREV. [...] 16813 65 32_Re: Urgent solution required....19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 19 Jul 2000 12:48:36 -0500375_iso-8859-1 Hi Vijay, "We need some light on how to go about doing READPREV." Wait for V7 which will have a scrollable, forward and backward, cursor! The best methods I've seen were in either a V4 or V5 DB2 Performance Redbook. You can find these online at the IBM Web site: http://www-4.ibm.com/software/data/db2/os390/ Then search on "DB2 Performance" in the Redbooks. [...] 16879 87 21_Re: What Time is it ?24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Wed, 19 Jul 2000 12:55:28 -0500450_- I remember going to a talk about mainframe clocks (admittedly years ago) and the IBM specs for the TOD clock accuracy allowed for a lot of drift (over time). In those days, you could buy a hardware feature to get a more accurate clock. Note: the average wrist watch was rumored to be more accurate than the mainframe's clock at that time. My point is even if the mainframe has a better clock now, I doubt that the PC's clock is very accurate. [...] 16967 156 41_Re: My QMF question never got any answers0_23_edie.richardson@SRS.GOV31_Wed, 19 Jul 2000 14:07:17 -0400280_us-ascii This column is char 6 and apparently they are storing nondisplayable characters. Why? - It is beyond me. I agree it was pretty stupid but I'll give that programmer the benefit of the doubt and say it was caused by ignorance. Needless to say he is no longer with us. [...] 17124 80 21_FW: What Time is it ?22_Lindsay, William (BIS)24_WLindsay@EXCHANGE.ML.COM31_Wed, 19 Jul 2000 14:41:23 -0400554_iso-8859-1 -----Original Message----- From: Lindsay, William (BIS) Sent: Wednesday, July 19, 2000 2:24 PM To: 'Peter_Schwarcz@bigpond.com' Subject: RE: What Time is it ?



One option for time synchronization is handled by a DCE (Distributed Computing Environment) where time servers poll each other and time is synchronized(when necessary) and published as needed. So all applications, etc would use the published time. This is one option, and one I've only read aboout. I'm sure there are others.....IBM publishes lots of info on DCE. [...] 17205 22 35_RE : ADDING NEW VOLUMES TO STOGROUP12_Andre Cupido22_wcacu@WOOLWORTHS.CO.ZA31_Wed, 19 Jul 2000 20:49:55 +0200515_US-ASCII Hi All

I need to fix a space problem pronto. If i were to add an additional volume to a specific stogroup , stop and start the tablespace , will the offending file extend to the newly added volume .



Thanking you in advance

Andre Cupido

================================================ 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. 17228 39 39_Re: RE : ADDING NEW VOLUMES TO STOGROUP20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 19 Jul 2000 14:56:07 -0400520_us-ascii Now we are on SMS but I remember the old days and answer to your question is yes it will.

-----Original Message----- From: Andre Cupido [SMTP:wcacu@WOOLWORTHS.CO.ZA] Sent: Wednesday, July 19, 2000 2:50 PM To: DB2-L@RYCI.COM Subject: RE : ADDING NEW VOLUMES TO STOGROUP Importance: High

Hi All

I need to fix a space problem pronto. If i were to add an additional volume to a specific stogroup , stop and start the tablespace , will the offending file extend to the newly added volume . [...] 17268 17 45_Question re: moving large amounts of UDB data18_MCCARTHY, DANIEL M27_DANIEL_M_MCCARTHY@FLEET.COM31_Wed, 19 Jul 2000 15:08:44 -0400447_iso-8859-1 We have the need to export large amounts of data - up to 63 GIG - from UDB on AIX for reuse in a non UDB environment. I know that I can export the data to local disk and then move the file via tar, ftp, etc. I'm wondering if someone has experience or recommendations on other ways to move large amounts of data. Can this data be piped to a tape device? Will the export utility handle a tape change? Any information is appreciated. [...] 17286 107 21_Re: What Time is it ?24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Wed, 19 Jul 2000 14:25:51 -0500310_- Update: IBM's SYSPLEX timer is much more accurate (than years ago) and can automatically set itself to the correct time if it has a modem and a phone line. This sysplex timer is also related to the DCE (which Bill Lindsay also mentioned).

Richard Humphris CNA Online Systems - DB2 (312) 822-5193 [...] 17394 47 49_Re: Question re: moving large amounts of UDB data15_Donny Ledbetter28_donny.ledbetter@AUTOZONE.COM31_Wed, 19 Jul 2000 14:16:37 -0500653_us-ascii Daniel Are you working working with UDB EE or UDB EEE





"MCCARTHY, DANIEL M" To: DB2-L@RYCI.COM Subject: Question re: moving large amounts of Sent by: DB2 Data UDB data Base Discussion List



07/19/00 02:08 PM Please respond to DB2 Data Base Discussion List











We have the need to export large amounts of data - up to 63 GIG - from UDB on AIX for reuse in a non UDB environment. I know that I can export the data to local disk and then move the file via tar, ftp, etc. I'm wondering if someone has experience [...] 17442 13 24_Turn of Archive logging!11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 19 Jul 2000 14:29:49 -0500348_us-ascii Does anyone know the ZPARM setting to stop Archive logging on a TEST system in DB2 ver 6.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. 17456 31 28_Re: Turn of Archive logging!13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 19 Jul 2000 13:30:32 -0700436_iso-8859-1 Does DB2 allow that ? Would be a surprise to me. You can of course 'overwrite' the same archive log dataset again and again.

Ashish.

-----Original Message----- From: Jeff Faughn [SMTP:Jeff_Faughn@MAY-CO.COM] Sent: Wednesday, July 19, 2000 12:30 PM To: DB2-L@RYCI.COM Subject: Turn of Archive logging!

Does anyone know the ZPARM setting to stop Archive logging on a TEST system in DB2 ver 6.1... : ) [...] 17488 54 39_Re: RE : ADDING NEW VOLUMES TO STOGROUP14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 19 Jul 2000 16:47:03 -0500328_- You didn't indicate whether your data was controlled via SMS or not , but if SMS was controlling it, adding a volume to the proper SMS STORAGEGROUP will handle the problem. If the allocation is controlled via non-SMS then the additional volume would have to be added with an 'ALTER STOGROUP ADD VOLUMES(VOLSER)' command. [...] 17543 93 33_Re: Clustering Indexes - Question14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 19 Jul 2000 17:25:38 -0400700_iso-8859-1 You only need to specify SORTDATA on the REORG I believe to get around the problem when you have not defined a clustering index.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > craig patton > Sent: Wednesday, July 19, 2000 9:00 AM > To: DB2-L@RYCI.COM > Subject: Re: Clustering Indexes - Question > > > It is TRUE that a REORG without a CLUSTERing index will NOT > change the ORDER > of the DATA in [...] 17637 112 33_Re: Clustering Indexes - Question15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 19 Jul 2000 17:52:51 -0500533_iso-8859-1 Richard,

According to the doc, if no explicit clustering index exists, SORTDATA is ignored (DB2 V6 Utility Guide, p. 319). I haven't tested this myself.

Michael Murley BMC

-----Original Message----- From: Richard Yevich [mailto:ryevich@attglobal.net] Sent: Wednesday, July 19, 2000 4:26 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question



You only need to specify SORTDATA on the REORG I believe to get around the problem when you have not defined a clustering index. [...] 17750 147 33_Re: Clustering Indexes - Question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 19 Jul 2000 15:58:49 -0700480_iso-8859-1 Well ,

That has been my understanding too all these years ; again I have not tested it.

Ashish.

-----Original Message----- From: Murley, Michael [SMTP:Michael_Murley@BMC.COM] Sent: Wednesday, July 19, 2000 3:53 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question

Richard,

According to the doc, if no explicit clustering index exists, SORTDATA is ignored (DB2 V6 Utility Guide, p. 319). I haven't tested this myself. [...] 17898 10 32_Re: Urgent solution required....0_27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 19 Jul 2000 19:18:00 -0400307_- just declare the cursor as select .... order by pkey descending

================================================ 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. 17909 84 32_Re: Urgent solution required....23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Wed, 19 Jul 2000 23:17:46 -0000437_iso-8859-1 WITH caution THE pkey >= WOULD HAVE TO BE pkey <= and and order by pkey desc so you will have to be careful about indexing the table or use both a desc and ascending indexes .



Andrew Puddy



-----Original Message----- From: Vijay Subramanyam [mailto:vijay.subramanyam@HPSBLR.SOFT.NET] Sent: Thursday, 20 July 2000 3:52 To: DB2-L@RYCI.COM Subject: Urgent solution required.... Importance: High [...] 17994 91 27_IBM load utility ---- a bug23_AITHA, BHEEMSEN (SBCSI)22_BA2984@MSG.PACBELL.COM31_Wed, 19 Jul 2000 16:21:11 -0700398_iso-8859-1 Hi list,

We have a table with last column defined with NNWD(not null with default). The type is CHAR. Length is 1. We loaded this table using IBM load utility. The load file was incorrect in the sense that the last column contained NULLS (i.e. x'00' in the dataset when viewed with hex on). But the load didn't fail, neither there were any warnings too. Here is the output : [...] 18086 82 61_FW: Bloor Research: "IBM Drags DB2 into the e-commerce Arena"13_Morrill, John12_JohnM@VP.NET31_Wed, 19 Jul 2000 17:28:03 -0600394_iso-8859-1 Dear DB2 Interested Parties,

I thought that I had sent this report to you back in April, but apparently not. It's worth a look (was written based on a pre-announce DB2 V7 briefing for analysts). Check out the Web site at IT-Analyst.com for this report and other interesting links/reports: http://www.it-analysis.com/00-04-13-1.html?its

Regards, Mike + + + + + + + [...] 18169 30 31_Re: IBM load utility ---- a bug13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 19 Jul 2000 19:38:08 -0400579_iso-8859-1 Hi Bheemsen,

You didn't load nulls. You loaded one byte of binary zeroes -- a perfectly legal value for a Char(1) field.

Nulls in DB2 tables are identified by the null-indicator and are only inserted into a column which has been defined as nullable.

Note that you can have the load utility load nulls(only into nullable columns, of course) with the Nullif parameter which tells the load utility to look for a special character in the input record. For instance, look at the nullif parms for PTN_ORIG_DT POSITION(125) and OPTN_EXP_DT POSITION [...] 18200 132 31_Re: IBM load utility ---- a bug22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 19 Jul 2000 19:54:50 -0400323_iso-8859-1 1. As far as the LOAD utility is concerned you did not load NULLS into the last column so no warning message is issued. x'00' is not automatically NULLS as far as the LOAD utility is concerned.

The LOAD utility will consider the input for a column NULL if there is a NULLIF specified for the column. [...] 18333 147 33_Re: Clustering Indexes - Question14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 19 Jul 2000 19:03:44 -0400729_iso-8859-1 According to the document referenced, you are correct and I am wrong. That is one of those things that I know I read somewhere along the way, but never tested either.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Murley, Michael > Sent: Wednesday, July 19, 2000 6:53 PM > To: DB2-L@RYCI.COM > Subject: Re: Clustering Indexes - Question > > > Richard, > > According to the doc, if no explicit clustering index exists, SORTDATA [...] 18481 125 37_Re: AW: Clustering Indexes - Question0_29_Greg.Palgrave@BANKWEST.COM.AU31_Thu, 20 Jul 2000 08:10:46 +0800341_us-ascii It uses the one with the lowest OBID, which is not always the first one created, as OBIDs can be reused.

I believe that DB2 will not treat it as a clustering index for REORG etc - if you want it clustered, you need to explicitly define a clustering index. It's the only way to guarantee you get the clustering YOU want. [...] 18607 78 11_ALTER INDEX19_=?big5?B?tPa90qr4?=21_A000896@MS.SKH.ORG.TW31_Thu, 20 Jul 2000 20:44:37 +0800536_big5 HI ALL ! Becase I want change index to other volume (using stogroup) ,so batch program 1. stop database(popddb) space(xxfee001) 2. alter index skdba.xxfee001 using storgroup skhst222 3. display ddatabase(popddb) space(xxfee001) show : xxfee001 stopp(meaning current stopping), because online transaction in use tablespace and index about 20 minutes question : 1. why batch job isn't timeout 2. cancel batch job , why start database(popdbd) space(xxfee001) still stopp 3.I must stop db2 and start db2 index xxfee001 change rw status 18686 76 37_Re: AW: Clustering Indexes - Question14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 19 Jul 2000 20:11:03 -0400540_iso-8859-1 Sorry, unless something has really changed -- the index picked for INSERTS, when there is no clustering index, is based on a control block chain, in the DBD, in the EDM pool, at run time according to IBM doc and tests done years ago. It has nothing to do with the OBID. The oldest living index will be the first one in the chain of control blocks. Drop and recreate, with no intervening stuff happening, and it may actually stay in the same place in the chain, but generally moves to the bottom of the list. The OBID may or [...] 18763 21 30_UDB 6.1 control centre problem16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Wed, 19 Jul 2000 23:24:15 -0400333_iso-8859-1 I am having a problem with the control centre of UDB 6.1 on WIN 98. Whenever I open up the CC, I see it on the toolbar for about a second and then it closes.

Everything else seems to be working OK. I can use the command centre, start the Database manager, connect to the sample databases, use DB2 Connect etc. [...] 18785 51 32_Re: Urgent solution required....7_naresha15_naresha@INF.COM31_Thu, 20 Jul 2000 09:39:21 +0530521_iso-8859-1 Declare 2 cursors one for forward reading and one for backward reading (declare cursor order by ascending / descending as required). For READPREV open the corresponding cursor (which is order by descending key value)with key value from the other cursor and Fetch / Close.

HTH Naresh

-----Original Message----- From: Vijay Subramanyam [mailto:vijay.subramanyam@HPSBLR.SOFT.NET] Sent: Wednesday, July 19, 2000 11:22 PM To: DB2-L@RYCI.COM Subject: Urgent solution required.... Importance: High [...] 18837 90 33_Re: Clustering Indexes - Question15_Richard Simpson25_rsimpson@MACQUARIE.COM.AU31_Thu, 20 Jul 2000 14:57:50 +1000545_iso-8859-1 We have tested it (SORTDATA without a clustering index), it is ignored.

You get this message: DSNU301I -DB2P DSNURFIT - KEYWORD 'SORTDATA' SPECIFIED AND/OR KEYWORD 'NOSYSREC' WAS SPECIFIED BUT NO CLUSTERING INDEX EXISTS, KEYWORD IS IGNORED

We have a home written program which generates REORGS according to the criteria in the Admin Manual. It always specifies SORTDATA (it isn't smart enought to workout when it shouldn't) and this is ignored with the above message for tables without explicit clustering indexes. [...] 18928 17 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Thu, 20 Jul 2000 01:01:47 -0500455_us-ascii I will be out of the office starting 07/20/2000 and will not return until 07/21/2000.



I will respond to your message when I return. If this is an emergency, please contact Alison Pellitier.

================================================ 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. 18946 53 34_Re: UDB 6.1 control centre problem27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Thu, 20 Jul 2000 12:23:46 +0530316_iso-8859-1 Robert,

I also had this problem . The problem could be in the Virtual memory.

If you are using Windows NT/98 go to the Settings/ System, and then to general and try to increase the memory page size.

If your machine RAM is 32 MB , try increasing it to 64MB and then it will work. [...] 19000 31 22_Re: Secondary auth IDs9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Thu, 20 Jul 2000 08:45:54 +0100338_us-ascii Duane,

here is a couple of simple rules of thumb which may help.

1, If you are creating a new DB2 object that has a CREATOR, such as a table, you need to set your current SQLID to the authorisation id that has the DB2 privilege. This is the authid that becomes the CREATOR in the appropriate Catalog table(s). [...] 19032 45 44_Is CONNECT needed on DB2 UDB for Sun Solaris0_20_vpacheco@AMADEUS.NET31_Thu, 20 Jul 2000 09:41:31 +0100430_us-ascii Dear DB2 Community

My background in DB2 on OS/390. I have also some experience with DB2 Connect (NT). But now I am involved in a Project that also involved DB2 UDB on SUN Solaris.

In a simplistic way, the developers for this Project want to develop on C++ on the Sun machine using DB2 UDB as the RDBMS (Dynamic Embedded SQL) and then ship the software to be run on USS (BPXBATCH) and/or native OS/390. [...] 19078 23 53_Turn of Archive logging !!!- An unreachable desire ??14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 09:51:33 +0100375_us-ascii if only it were true!!!! I'd like to have this features as ORACLE (vade repro vsam) .....I think an instruction like INSERT INTO

XXXX.TABLE_FURLONG LOG NO (or NOLOG) will be verrry appreciated. It'll be user's responsibility to guarantee

data consistency.....Now some 'system' tables don't log....why we cannot use this 'feature' for all tables ? [...] 19102 22 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 09:45:03 +0100552_us-ascii if only it were true!!!! I'd like to have this features as ORACLE (vade retro) .....I think an instruction like INSERT INTO

XXXX.TABLE_FURLONG LOG NO (or NOLOG) will be verrry appreciated. It'll be user's responsibility to guarantee

data consistency.....

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. 19125 16 46_Re: REXX interface problem: DESCRIBE statement11_Rolf Merkle21_rolf.merkle@DVG-KA.DE31_Thu, 20 Jul 2000 02:39:04 -0500434_- There are also other errors in the REXX-Interface. Look for APAR PQ31316 and PTF UQ38048. After installation of this PTF at our site the interface worked fine.

Rolf Merkle DB2-Sysprog

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19142 50 28_Re: Turn of Archive logging!23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 20 Jul 2000 09:17:48 +0100454_iso-8859-1 if enough people ask for it then it will come .. infact I do believe there is a patch to allow log no ..

Les

-----Original Message----- From: Massimo Scarpa [mailto:Massimo_Scarpa@DEBIS.IT] Sent: Thursday, July 20, 2000 9:45 AM To: DB2-L@RYCI.COM Subject: Re: Turn of Archive logging!



if only it were true!!!! I'd like to have this features as ORACLE (vade retro) .....I think an instruction like INSERT INTO [...] 19193 19 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 10:57:08 +0100451_us-ascii Really ? Can you tell me where this patch is ? But I think that this patch disable logs for ALL applications running in DB2 and

not for applications you need...

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. 19213 37 28_Re: Turn of Archive logging!13_Ricardo Gomes30_ricardo.gomes@MELLO-IMPERIO.PT31_Thu, 20 Jul 2000 11:11:25 +0100621_- Perhaps you are referring to the chage in DSN6LOGP macro, OFFLOAD=NO. But it's fairly unacceptable to use it in mainstream situations... it disables log archiving but may place you in a dangerous non-recoverable-from situation. I used it once or twice... although never in a Production system.

> -----Original Message----- > From: Massimo Scarpa [SMTP:Massimo_Scarpa@DEBIS.IT] > Sent: Thursday, July 20, 2000 10:57 AM > To: DB2-L@RYCI.COM > Subject: Re: Turn of Archive logging! > > Really ? Can you tell me where this patch is ? But I think that this > patch > disable logs for ALL applications running in [...] 19251 23 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 11:34:14 +0100336_us-ascii I've some problem with my mail and NOW, reading all messages about logging I realize that we were dealing with

ARCHIVE LOGs. What I would like to obtain is disable LOGGING in some way and for some application so

insert/update/delete are not logged under certain conditions, as in LOAD LOG NO, for instances. [...] 19275 60 28_Re: Turn of Archive logging!23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 20 Jul 2000 10:45:09 +0100421_iso-8859-1 Max

hi.

yes there is a patch that allows for all logging to be stopped .. used really only when you know for a fact that "ALL" your work will not be logged .. i.e you have a backup to go back to if things fail .. good for mass migrations where insert/delete etc is going to be very high. We have not used it but I can see that it would be of help in the situation where we do a big upgrade. [...] 19336 64 28_Re: Turn of Archive logging!23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 20 Jul 2000 10:45:46 +0100612_iso-8859-1 ...mmm, yes another nice feature but once again only when the situation calls for it.

Les

-----Original Message----- From: Ricardo Gomes [mailto:ricardo.gomes@MELLO-IMPERIO.PT] Sent: Thursday, July 20, 2000 11:11 AM To: DB2-L@RYCI.COM Subject: Re: Turn of Archive logging!



Perhaps you are referring to the chage in DSN6LOGP macro, OFFLOAD=NO. But it's fairly unacceptable to use it in mainstream situations... it disables log archiving but may place you in a dangerous non-recoverable-from situation. I used it once or twice... although never in a Production system. [...] 19401 48 28_Re: Turn of Archive logging!15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Thu, 20 Jul 2000 04:53:42 -0500453_iso-8859-1 Max,

Is your main problem the logging I/O rate or the size of the logs? If the latter then there are third party solutions to reduce log size. Contact me by email if you would like more information.

Regards,

Andy Lankester andy_lankester@bmc.com

-----Original Message----- From: Massimo Scarpa [mailto:Massimo_Scarpa@DEBIS.IT] Sent: 20 July 2000 11:34 To: DB2-L@RYCI.COM Subject: Re: Turn of Archive logging! [...] 19450 15 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 11:58:04 +0100389_us-ascii We are converting ALL utilities & TOOLS from BMC to other 3rd party.....And reducing logging IS NOT my problem. Sorry...

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. 19466 26 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 11:56:39 +0100401_us-ascii Hi Les, thanks for the answer.

I'll search, but what I would like to have is the capability to turn off/on logging using programs like DSNTIAUL to

insert/delete/update rows without generating a HUGE amount of logs (and relative archives) and using this 'instruction' with

SQL, said DELETE FROM TABLE XXX.YYY NOLOG...

Please mother IBM listen to your son !!!! [...] 19493 58 17_Replication on NT33_Aydan Yuceer (ayuceer@tai.com.tr)18_ayuceer@TAI.COM.TR31_Thu, 20 Jul 2000 13:20:38 +0300365_iso-8859-1 I tried simple replication scenario ( 2 databases on the same machine, readonly copy of source table on the other db). It works successfully. I tried to apply same replication with 2 machines on the LAN, apply program failed. Export is successful but import failed with that message: SQL3025N A parameter specifying a filename or path is not valid. [...] 19552 72 34_Re: UDB 6.1 control centre problem16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Thu, 20 Jul 2000 07:33:07 -0400414_iso-8859-1 Deepak

Thanks for the suggestions. First of all I have 192 MG on my machine. And I believe that in WIN 98 you can't change the memory page size. (if you can, can you tell where under control panel). As for logging on as d2admin , I tried that using my machine domain name and that didn't work either. All the other functions seem to be working with no issues. it is just the control centre. [...] 19625 167 31_Re: IBM load utility ---- a bug0_27_jim.leask@RS-COMPONENTS.COM31_Thu, 20 Jul 2000 12:40:23 +0100366_iso-8859-1 The following statement from Bheemsen seems to suggest that LOAD did not load in x'00' > and repeated the select query(changing the where class to > AUTO_TRMNTN_REN_CD > = ' ') and it returned all the rows.

Is it possible that the x'00' signified end of record to DB2 and therefore DB2 loaded in the default value for this column i.e. spaces. [...] 19793 58 28_Re: Turn of Archive logging!23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 20 Jul 2000 12:42:10 +0100509_iso-8859-1 max

good call and I think IBM should listen .. I am out at the labs in October so I will raise it then.

regards

Leslie

-----Original Message----- From: Massimo Scarpa [mailto:Massimo_Scarpa@DEBIS.IT] Sent: Thursday, July 20, 2000 11:57 AM To: DB2-L@RYCI.COM Subject: Re: Turn of Archive logging!



Hi Les, thanks for the answer.

I'll search, but what I would like to have is the capability to turn off/on logging using programs like DSNTIAUL to [...] 19852 29 31_Re: IBM load utility ---- a bug13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 20 Jul 2000 07:49:12 -0400352_iso-8859-1 >The following statement from Bheemsen seems to suggest that LOAD did not >load in x'00'

Hi Jim, I missed this part of his message too at first but upon re-reading before I replied, I noticed he said:

********** Then I ran the following query :

UPDATE CIBSTBN.BAGA_OPTN_SELT SET AUTO_TRMNTN_REN_CD = ' ' ********** [...] 19882 25 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 20 Jul 2000 13:55:38 +0100379_us-ascii Thanks again. There are many people waiting for this, asa far as I know. And if there are 'system' tables (global temporary

tables, the tables used in online reorg... for instance) that do not log, may be that this implementation will be simple.

Plz ask for it when you'll be in mega-giga IBM labs . Otherways I'll buy ORACLE (aaaaarrrgggghhhh !!!!). [...] 19908 58 31_Re: IBM load utility ---- a bug0_27_jim.leask@RS-COMPONENTS.COM31_Thu, 20 Jul 2000 12:57:59 +0100446_iso-8859-1 Ooops.

Cheers Dave, Jim.

-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: 20 July 2000 12:49 To: DB2-L@RYCI.COM Subject: Re: IBM load utility ---- a bug



>The following statement from Bheemsen seems to suggest that LOAD did not >load in x'00'

Hi Jim, I missed this part of his message too at first but upon re-reading before I replied, I noticed he said: [...] 19967 18 37_Another DB2 UDB V6.1 for AIX question10_Robert Ord21_robertord@HOTMAIL.COM29_Thu, 20 Jul 2000 12:01:43 GMT380_- Mainframe DB2 person getting to grips with UDB 6.1 on AIX. I have a number of databases sitting on a single instance. Can I reference tables in different databases in a single SQL statement ? If so, how do I do it ?

Rob ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com [...] 19986 85 34_Re: UDB 6.1 control centre problem25_Carlos Eduardo de Miranda25_carlos_e@CCUEC.UNICAMP.BR31_Thu, 20 Jul 2000 09:15:04 -0300562_us-ascii Robert:

Did you install JDK 1.1.x in you Windows machine? The Control Center of DB2 UDB 6.1 is Java based on..

HTH

Carlos State University of Campinas Brazil

"Galambos, Robert" wrote:

> Deepak > > Thanks for the suggestions. First of all I have 192 MG on my > machine. And I believe that in WIN 98 you can't change the memory page size. > (if you can, can you tell where under control panel). As for logging on as > d2admin , I tried that using my machine domain name and that didn't work > either. All the other [...] 20072 43 28_SOS! Oracle to DB2 migration16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Thu, 20 Jul 2000 08:42:47 EDT429_- Dear List, I have been tasked to migrate ORACLE tables to a DB2 database. I have no ORACLE experience and will like to get tips, suggestions and comments from anyone who has successfully migrated from Oracle to DB2 to share their strategy with me. Here's what I'm thinking: Is there any tool (even shareware, freeware or in-house utility they can share) that can 1. Convert oracle column/data type to DB2 column/data type [...] 20116 70 32_Re: SOS! Oracle to DB2 migration13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Thu, 20 Jul 2000 08:54:36 -0400612_iso-8859-1 Christine,

There is a very good article on this process in the summer issue of DB2 Magazine (Vol. 5 Number 2). I believe it can be viewed at http://www.db2mag.com. I was involved in the tail-end of this type of project. The article mentions tools from Man-tech. We used some tools from Embarcadero. ER/Studio will take a data model from Oracle as input and produce DB2 DDL. DBArtisan is a very useful tool for administering Oracle and DB2 databases from the same graphical interface(on the NT/AIX level..you didn't mention the platform). As always with tools like these, you have to watch [...] 20187 59 32_Re: SOS! Oracle to DB2 migration13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Thu, 20 Jul 2000 08:55:29 -0400680_iso-8859-1 Pardon me Christine..you did mention the environment...Still, the article might be of some help. Jim

-----Original Message----- From: Christine Sawyer [mailto:cosawyer@HOTMAIL.COM] Sent: Thursday, July 20, 2000 8:43 AM To: DB2-L@RYCI.COM Subject: SOS! Oracle to DB2 migration



Dear List, I have been tasked to migrate ORACLE tables to a DB2 database. I have no ORACLE experience and will like to get tips, suggestions and comments from anyone who has successfully migrated from Oracle to DB2 to share their strategy with me. Here's what I'm thinking: Is there any tool (even shareware, freeware or in-house utility they can share) that can 1. [...] 20247 21 32_Re: SOS! Oracle to DB2 migration13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 20 Jul 2000 08:58:40 -0400492_iso-8859-1 Christine, If you haven't already, have a look at

http://www-4.ibm.com/software/data/db2/migration/

Good luck. It should be fun.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.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. 20269 62 32_Re: SOS! Oracle to DB2 migration16_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU31_Thu, 20 Jul 2000 08:01:13 -0500335_iso-8859-1 ERwin from CA can reverse engineer from Oracle to a data model. DDL could then be generated from the data model with DB2 as the target environment. There may need to be some tweaks to some of the columns, particularly if you're using some of the less common data types. That should get the majority of the DDL, though. [...] 20332 41 15_Re: ALTER INDEX20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 20 Jul 2000 09:07:13 -0400490_us-ascii If you have protected threads and packages or plans are bound with RELEASE(DEALLOCATE) then ALTER can't get the drains. In such cases you should try -STOP DB(..) SPACE(..) AT(COMMIT). This syntax will be able to drain all the claimers and has more chances of getting your -STOP command work.

-Venkat

-----Original Message----- From: A000896@MS.SKH.ORG.TW [SMTP:A000896@MS.SKH.ORG.TW] Sent: Thursday, July 20, 2000 8:45 AM To: DB2-L@RYCI.COM Subject: ALTER INDEX [...] 20374 174 33_Re: Clustering Indexes - Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 20 Jul 2000 09:04:41 -0400494_iso-8859-1 Sorry for the previous mail, which I sent. I don't get my mails in proper sequence. Please ignore my earlier question.

-----Original Message----- From: Richard Yevich [SMTP:ryevich@ATTGLOBAL.NET] Sent: Wednesday, July 19, 2000 7:04 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question

According to the document referenced, you are correct and I am wrong. That is one of those things that I know I read somewhere along the way, but never tested either. [...] 20549 120 33_Re: Clustering Indexes - Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 20 Jul 2000 09:01:20 -0400388_us-ascii I think SORTDATA is ignored if there is no explicit clustering index is available. Is there a new APAR, which came recently to make SORTDATA work even without an explicit clustering index?

-----Original Message----- From: Richard Yevich [SMTP:ryevich@ATTGLOBAL.NET] Sent: Wednesday, July 19, 2000 5:26 PM To: DB2-L@RYCI.COM Subject: Re: Clustering Indexes - Question [...] 20670 14 37_Recall: Clustering Indexes - Question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 20 Jul 2000 09:10:51 -0400338_us-ascii Pillay, Venkat (PCA) would like to recall the message, "Clustering Indexes - Question".

================================================ 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. 20685 29 16_list of datasets11_Deb Hellard20_debmac82@HOTMAIL.COM29_Thu, 20 Jul 2000 13:14:58 GMT716_- Hi All!

I need a way (preferably an SQL) to get a list of all datasets associated with a DB2 tablespace/indexspace, including all the different Annn suffixes created because of the 2G dataset limit/partitions/LARGE NPI.

Any help will be appreciated!















________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail 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. 20715 73 32_Re: SOS! Oracle to DB2 migration13_Keith Gilbert17_kgilbert@CSA1.COM31_Thu, 20 Jul 2000 08:36:34 -0500546_iso-8859-1 Christine,

I am currently in the process of converting an Oracle database to DB2 so I might be able to answer some of your more specific questions if you wish to e-mail me outside the list. I suggest you look into a software product called TOAD (Tool for Oracle Application Developers) from Quest Software (www.quest.com). This is an excellent Oracle tool that will enable you to determine the Oracle attributes you are looking for. You can download a 30-day trial for free. If I can be of any other help just let me know. [...] 20789 98 17_Re: When To Reorg16_Norbert Thiebaud23_norbert@INFOTELCORP.COM31_Thu, 20 Jul 2000 08:54:20 -0400361_iso-8859-1 There is a product out-there from INFOTEL called Master-Util, that will do exactly that: Determine an 'organization ratio' based on spacemap among other thing. It is not using the catalog. It will then prioritize the candidates and dynamically execute the reorg within a given timeframe, taking care of eventual recover and few other 'details'. [...] 20888 84 32_AW: SOS! Oracle to DB2 migration12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 20 Jul 2000 15:46:11 +0200552_iso-8859-1 May be you'll find some helpful things on the following url:

http://www-4.ibm.com/software/data/db2/migration/

HTH. With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 20973 61 20_Re: list of datasets19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 20 Jul 2000 09:05:22 -0500311_iso-8859-1 Deb, Can't immediately think of a way to do this with 'just' SQL. Try this. Do an IDCAMS LISTCAT ENTRY(aaaa.*). If your naming convention doesn't list the tablespaces and indexes near each other, perhaps you could do a sort of some kind to make reading the report easier.

HTH, Rick Davis [...] 21035 66 20_Re: list of datasets11_Deb Hellard20_debmac82@HOTMAIL.COM29_Thu, 20 Jul 2000 14:16:36 GMT663_- But this doesn't assure me that a dataset 'belongs' to DB2. It's not necessarily true that datasets that comply to the DB2 naming convention were created by (or created to be used by) DB2.









>From: "DAVIS, RICK (SBCSI)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: list of datasets >Date: Thu, 20 Jul 2000 09:05:22 -0500 > >Deb, > Can't immediately think of a way to do this with 'just' SQL. >Try this. Do an IDCAMS LISTCAT ENTRY(aaaa.*). If your naming convention >doesn't list the tablespaces and indexes near each other, perhaps you could >do a [...] 21102 97 20_Re: list of datasets19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 20 Jul 2000 09:36:13 -0500593_iso-8859-1 You'll have to compare the LISTCAT against all table and index spaces in the DB2 Catalog.

You have my permission to beat with a feather any person found creating a VSAM LINEAR dataset that complies with the DB2 naming convention for use other than DB2's!

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 [...] 21200 108 20_Re: list of datasets11_Deb Hellard20_debmac82@HOTMAIL.COM29_Thu, 20 Jul 2000 14:52:53 GMT290_- Well, is it that simple? That's what I thought when I committed to do it, but I found out later that I don't know how.

If the 2G limit is reached for a dataset and DB2 creates an additional dataset with a different suffix, is there any indication to that in the DB2 catalog ? [...] 21309 157 20_Re: list of datasets15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 20 Jul 2000 10:53:40 -0400685_iso-8859-1 Deb,

I do two items to find out the physical dataset names:

I run this SQL:

SELECT A.DBNAME, A.TSNAME, A.NAME, A.CREATOR, B.NAME, B.INDEXSPACE, B.CREATOR FROM SYSIBM.SYSTABLES A,

SYSIBM.SYSINDEXES B

WHERE A.NAME = B.TBNAME

AND A.CREATOR = B.CREATOR

AND A.DBNAME = 'dbname'

ORDER BY 1,2,3,4

What this returns is the Tablesname along with the indexspacename (of which I let DB2 control the 8 character name assignment since the application has longer than 8 characters for their index name ** by the way that wasn't my choosing). This will only show entries that have an index. If a tablespace does not have [...] 21467 61 20_Re: list of datasets14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Thu, 20 Jul 2000 07:58:29 -0700586_us-ascii Deb, I used a rexx routine and the DB2-rexx interface to build ISPF dialogs. My way was to use SQL to get all TS partition names and associated IX partition names from the DB2 catalog by appropriate joins. I put them in an ISPF table in the order I wanted using TBSORT. Once you know all the DBnames and TS or IX names, and you know the high level qualifier, just process your ISPF table issuing, for each row, a LISTC LVL(highlevel-qualifier.DSNDBD.dbname.ts-or-ix-name) The returned list of complete dataset names can be trapped in your rexx routine then parsed and put [...] 21529 37 41_Re: Another DB2 UDB V6.1 for AIX question22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 20 Jul 2000 11:13:59 -0400731_- No



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

> ---------- > From: Robert Ord[SMTP:robertord@HOTMAIL.COM] > Sent: Thursday, July 20, 2000 8:01 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Another DB2 UDB V6.1 for AIX question > > Mainframe DB2 person getting to grips with UDB 6.1 on AIX. I have a number > of databases sitting on a single instance. Can I reference tables in > different databases in a single SQL statement ? If so, how do I do it ? > > Rob > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > ================================================ > [...] 21567 98 20_Re: list of datasets15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Thu, 20 Jul 2000 08:18:07 -0700357_iso-8859-1 I inherited this job so I don't know a lot about it other than it works and is easy to use... The report includes current allocation information.

//JS10 EXEC DMS //DMS.FILES DD DSN=xxxxx.DMSAR.DMSFILES, // DISP=SHR //DMS.ARCHIVEC DD DUMMY //DMS.SYSIN DD * FIND DSN= vcat.DSNDBC.dbname./ REPORT MVD //* //PRINT.SYSPRINT DD SYSOUT=* // [...] 21666 56 41_Re: Another DB2 UDB V6.1 for AIX question13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Thu, 20 Jul 2000 11:20:02 -0400417_iso-8859-1 I believe DB2 UDB 7.1 will have an add-on product called "Relational Connect" which will allow joins across DB2 databases, as well as Oracle.

Jim Fletcher jim.fletcher@bsis.com

-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Thursday, July 20, 2000 11:14 AM To: DB2-L@RYCI.COM Subject: Re: Another DB2 UDB V6.1 for AIX question [...] 21723 29 14_No read engine21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Thu, 20 Jul 2000 11:22:28 -0400583_iso-8859-1 Hi all,

After converting to a Shark dasd system and upgrading the OS/390 processor, I am seeing between 1000 and 4500 occurrances of sequential prefetch being disable due to a no read engine available condition. I understanding that the primary cause of this is due to I/O queueing. Does this relate only to DB2 activity or is it at the OS/390 image level? Does anyone have any tips for narrowing down what process is causing this to occur? The Shark was configured on a 1-to-1 volume basis, i.e. for each 3990 volume a single volume was defined on the Shark. [...] 21753 96 20_Re: list of datasets12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 20 Jul 2000 08:22:52 PDT423_- If you have the QUERY tool from CA/Platinum, ALL the DSNs for ALL objects can be listed, unfortunately, I don't think I can get TS and IX listed in the same report, but I can print the results of each and get a complete list. I assume that BMC, Candle, CDB, Compuserve and others can get this list as well. If you have a catalog query tool, this is the easiest way to get the list of all parts or multi-dsn objects. [...] 21850 130 34_Re: UDB 6.1 control centre problem22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 20 Jul 2000 11:29:37 -0400312_- Make sure the JDBC Applet Server is started. If it's not start it with the command db2jstrt. The JDBC Applet Server will default to listening on port 6789.

Start up the Control Center. It's default is use port 6789 as well.

The Control Center UI is Java and it needs the JDBC Applet Server. [...] 21981 13 18_Re: No read engine14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 20 Jul 2000 11:34:34 -0400375_us-ascii You should expect to see a reduction of IO Queueing with the Shark. Are you sure you weren't seeing it before also? HTH Phil

================================================ 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. 21995 88 41_Re: Another DB2 UDB V6.1 for AIX question0_15_leon@CA.IBM.COM31_Thu, 20 Jul 2000 11:35:32 -0400598_us-ascii You are correct. V7.1 of DB2 UDB and DB2 Connect products can do a Distributed Join. However, you will NOT need DB2 Relational Connect add-on unless you also want to involve Oracle databases in your distributed join. Ability to reference tables/views from multiple DB2 Family databases in a single SELECT is now native to both DB2 UDB and DB2 Connect and does not require any extra pieces. You will find our manuals referring to this function as a "Federated Database". Ability to support distributed updates is not yet available in these products but is in plan for future releases. [...] 22084 69 48_Performance Issue with DB@ Server for VM and VSE15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Thu, 20 Jul 2000 10:24:31 -0500578_- Hope you guys can help me!

Firstly .. the application in question is written in VisualAge generator (The NEW CSP) and it is a called from another VAGen application.

It takes 15-20 minutes for a user to scroll thru 1 page of data(approx 15 rows of information on the screen). This change in performance apparently happenned out of no-where.(i.e. no visible changes were made to the application) When I look at the database through a SHOW ACTIVE command I see a lot bytes going thru the lpagebuffers. When I issue a VMC RTMESA D I/O command i see 777000+ i/o [...] 22154 91 41_Re: Another DB2 UDB V6.1 for AIX question22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 20 Jul 2000 11:41:58 -0400483_- Jim -

My bad. I was too quick on the reply. Can't do it with DB2 UDB V6.1 Can do it with DB2 UDB V6.1 & DataJoiner.

DB2 UDB V7.1 with "Relational Connect is the 1st phase of integrating DataJoiner into DB2 UDB. If I recall correctly it supports read only.

My understanding is that the all the DataJoiner functions (updates, non-relational data access , etc...) will be phased into UDB "Relational Connect" either through fix paks or new version/releases. [...] 22246 39 18_Re: No read engine21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Thu, 20 Jul 2000 11:47:15 -0400494_iso-8859-1 Yes,

The seq. prefetch disabled is defined as an exception in TMON and I check those exception every a.m. Everything was clear other than a few sporadic occurrances before the dasd was switched, now I see it on an almost daily basis. A -dis bufferpool(bp0) detail also confirms that the monitor is reporting the numbers correctly. Performance overall has improved dramatically with the new processor and dasd, but I need to track down where this bottleneck is happening. [...] 22286 36 20_Re: list of datasets11_Deb Hellard20_debmac82@HOTMAIL.COM29_Thu, 20 Jul 2000 15:59:16 GMT391_- Thanks everybody, but I did not get a complete answer yet.

Using a non-DB2 tool (ISPF 3.4 / IDCAMS / Whatever) I can get a list of datasets that match: .DSNDBD...I0001.* Theoretically, I might get in the result set some datasets that are non-DB2 ( and were created just to confuse me ;-) ) so I think that using a non-DB2 tool is not what I'm looking for. [...] 22323 42 18_Re: No read engine14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 20 Jul 2000 12:23:05 -0400574_ISO-8859-1 Just converting to Shark alone does not get rid of IOQ problems. The feature with Shark that can alleviate this problem is assigning multiple LCU addresses to a logical device. If your installation has not done this, then you still have IOQ problems. Why you are seeing this now (if you didn't have the problem before), I don't know. Something else had to change someplace... either at the MVS level, DASD config level ... something/someplace. You need to get together with your MVS sysprogs, DASD management, and perhaps the IBM support reps. Regards, Joel [...] 22366 131 22_Re: Secondary auth IDs16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Thu, 20 Jul 2000 09:30:35 -0700588_iso-8859-1 Thanks for you responses. The info solved our "troubles".

> -----Original Message----- > From: craig patton [SMTP:prgpatton@HOTMAIL.COM] > Sent: Wednesday, July 19, 2000 5:33 AM > To: DB2-L@RYCI.COM > Subject: Re: Secondary auth IDs > > 1 point to make about secondary ids, for GRANT, REVOKE and CREATE it is > the > authorizations of the CURRENT SQLID ONLY that are used. For all other > SQL, > it is the combination of CURRENT SQLID and ALL SECONDARY ID Authorizations > that are used. So you must SET CURRENT SQLID to the secondary ID for the > GRANT REVOKE and [...] 22498 68 24_Help requested for query15_Melvin Demmicks25_melvin_demmicks@YAHOO.COM31_Thu, 20 Jul 2000 09:49:21 -0700375_us-ascii I have the following SQL

SELECT PM.PRB_NO, 'ACTIVE CALLS', COUNT(*) FROM PR.CALL C , PR.PRB_MASTER PM WHERE PM.PRB_NO = 69376 AND PM.PRB_NO = C.PRB_NO GROUP BY PM.PRB_NO

UNION

SELECT PM.PRB_NO, 'ARCHIVED CALLS', COUNT(*) FROM PR.CALL_ARC AC , PR.PRB_MASTER PM WHERE PM.PRB_NO = 69376 AND PM.PRB_NO = AC.PRB_NO GROUP BY PM.PRB_NO ORDER BY 1 [...] 22567 26 34_Re: UDB 6.1 control centre problem13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Thu, 20 Jul 2000 11:36:28 -0500387_- I have JDK1.2.2.etc installed for real work, but sometimes I need to run the DB2 control center, so I wrote this script, which you would need to greatly adapt to run on your machine.

(I also installed the IBM JDK and unpacked all of the DB2 jars into my classpath.)

# CC.BAT c: cd \sqllib\bin db2admin start db2start db2jstrt 6790 cd \sqllib\cc \ibmjava\bin\java CC [...] 22594 92 28_Re: Help requested for query13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Thu, 20 Jul 2000 10:09:34 -0700517_iso-8859-1 Try

Select PRB_NO,'ALL CALLS',SUM (COL2) FROM () T1.

i.e. storing result of your query in a temporary table T1 and executing an outer query. As an aside, I don't think GROUP BY and ORDER BY are adding any value to your query as your query is for a specific PRB_NO.

Thanks.

Ashish.

-----Original Message----- From: Melvin Demmicks [SMTP:melvin_demmicks@YAHOO.COM] Sent: Thursday, July 20, 2000 9:49 AM To: DB2-L@RYCI.COM Subject: Help requested for query [...] 22687 80 18_Re: No read engine21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Thu, 20 Jul 2000 13:13:13 -0400577_iso-8859-1 Thanks to Joel and Philip.

I was not expecting a conversion to Shark to eliminate I/O problems, I just don't understand why I started seeing such a high level after the conversion when only sporadic incidents were occurring before (by sporadic I mean 1/month max.)

Joel, I take it from your response that this is not just isolated to the DB2 sub-system but global to the entire operating system. I'm trying to get an idea if there may be one area I can concentrate on. Also, is there someplace where I can get a definition of what a "read engine" [...] 22768 17 20_Re: list of datasets13_Dana Nicholis26_dana.nicholis@ZURICHUS.COM31_Thu, 20 Jul 2000 12:08:05 -0500365_us-ascii Maybe the NACTIVE in SYSTABLESPACE would be useful. If my math is correct a 4K table at 2Gig would be approx 500,000 pages, so (as long as runstats are current) a query of NACTIVE over 500,000 would indicate more than one physical dataset. My query identified all the multi-dataset tables at our shop. You would have to check 32K page tables as well. [...] 22786 58 20_Re: list of datasets12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 20 Jul 2000 17:36:45 GMT643_- Unfortunately, no, for NON-Partitioned objects, there is NO indicator of Multiple DSN's that I know of as of V5 and I haven't seen that as a change in V6 or V7 either.

HTH, Craig Patton



>From: Deb Hellard >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: list of datasets >Date: Thu, 20 Jul 2000 15:59:16 GMT > >Thanks everybody, but I did not get a complete answer yet. > >Using a non-DB2 tool (ISPF 3.4 / IDCAMS / Whatever) I can get a list of >datasets that match: .DSNDBD...I0001.* >Theoretically, I might get in the result [...] 22845 61 18_Re: No read engine14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 20 Jul 2000 13:53:29 -0400561_ISO-8859-1 As a simplistic approach, consider a read-engine to be a task that actually requests the physical I/O. For DB2 V4 and V5 there are a maximum of 300 read engines (tasks). So, when they are all waiting for I/Os to complete, you run out of read engines. This is always caused by poorly performing I/O subsystems. It was not clear if you migrated from native 3390 devices directly to Shark, which is a RAID device. If you are getting a poor cache hit ratio, and you have to really read from multiple scsi disks, your performance can easily be worse [...] 22907 86 18_Re: No read engine21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Thu, 20 Jul 2000 14:15:40 -0400662_iso-8859-1 Joel,

Thank you! This is exactly the explanation I've been looking for.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Joel Goldstein Sent: Thursday, July 20, 2000 1:53 PM To: DB2-L@RYCI.COM Subject: Re: No read engine



As a simplistic approach, consider a read-engine to be a task that actually requests the physical I/O. For DB2 V4 and V5 there are a maximum of 300 read engines (tasks). So, when they are all waiting for I/Os to complete, you run out of read engines. This is always caused by poorly performing I/O subsystems. It was not clear [...] 22994 13 18_Re: No read engine14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 20 Jul 2000 14:15:49 -0400352_us-ascii Thanks Joel., I should have said if it is setup right, plus it depends on a lot of other things! Phil

================================================ 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. 23008 147 31_Re: IBM load utility ---- a bug23_AITHA, BHEEMSEN (SBCSI)22_BA2984@MSG.PACBELL.COM31_Thu, 20 Jul 2000 11:22:12 -0700509_iso-8859-1 Thanx to all who replied for this question. Thanx Mike for your explanation.

-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Wednesday, July 19, 2000 4:55 PM To: DB2-L@RYCI.COM Subject: Re: IBM load utility ---- a bug



1. As far as the LOAD utility is concerned you did not load NULLS into the last column so no warning message is issued. x'00' is not automatically NULLS as far as the LOAD utility is concerned. [...] 23156 61 31_WLM stored procedures in DB2 V618_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Thu, 20 Jul 2000 14:22:58 -0500609_- I have noticed that when WLM starts a SPAS address space we are seeing the following messages:

$HASP373 DB2ZWLM STARTED ACF9CCCD USERID ACFSTCID IS ASSIGNED TO THIS JOB - DB2ZWLM IEF403I DB2ZWLM - STARTED - TIME=13.33.41 DSNX986I DSNX9WLM ATTEMPT TO DUBPROCESS FAILED WITH RV = FFFFFFFF RC = 0000009C RSN = 0B0C00FC SSN = DB2Z PROC= DB2ZWLM DSNX986I DSNX9WLS ATTEMPT TO DUBTHREAD FAILED WITH RV = FFFFFFFF RC = DSNX986I DSNX9WLS ATTEMPT TO DUBTHREAD FAILED WITH RV = FFFFFFFF RC = 0000009C RSN = 0B0C00FC SSN = DB2Z PROC= DB2ZWLM DSNX986I DSNX9WLS ATTEMPT TO DUBTHREAD FAILED WITH RV = FFFFFFFF [...] 23218 80 32_Re: SOS! Oracle to DB2 migration12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 20 Jul 2000 15:31:00 -0400632_- There is a REDBOOK SG24-5478-00, 'Converting from ORACLE AIX to DB2 for OS/390'. You may find some useful info there depending on your environment.

>>> DB2-L@RYCI.COM@inter2 07/20/00 08:36AM >>> Christine,

I am currently in the process of converting an Oracle database to DB2 so I might be able to answer some of your more specific questions if you wish to e-mail me outside the list. I suggest you look into a software product called TOAD (Tool for Oracle Application Developers) from Quest Software (www.quest.com). This is an excellent Oracle tool that will enable you to determine the Oracle attributes you [...] 23299 15 11_Alter Table12_Aditya Narra31_Aditya.Narra@NYCBOE.NYCENET.EDU31_Thu, 20 Jul 2000 16:52:00 -0400439_- Hi all, I would like to know if I can remove a column from an existing table.I know we cannot change the data type of an existing column.I wonder why we cannot.Any ideas are welcome. Thanks, Audi

================================================ 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. 23315 36 15_Re: Alter Table13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Thu, 20 Jul 2000 15:59:13 -0500343_- >I would like to know if I can remove a column from an existing table.

Drop and recreate it.

>I know we cannot change the data type of an existing column.

You can generally move to longer strings without problems.

>I wonder why we cannot.

What happens to your poor queries if their columns disappear? [...] 23352 34 61_Quest Software eSeminar - DB2 UDB 6.1 - A Look Under the Hood13_Jim Wankowski23_Jim.Wankowski@QUEST.COM31_Thu, 20 Jul 2000 14:34:45 -0700639_iso-8859-1 You're invited to attend, without leaving your desk, a free e-seminar hosted by Quest Software on August 17. Deb Jenson, Director of DB2 Development, will discuss the internals of DB2 for Windows and UNIX. See how client application requests are processed and learn how to better identify and resolve performance bottlenecks with an approach that is based on understanding the DB2 process model. Since various DB2 components work together to complicate performance monitoring, Deb will also discuss how to simplify monitoring the performance of your DB2 UDB databases by using the proper tools. Learn how easy it can be to [...] 23387 235 48_Re: Is CONNECT needed on DB2 UDB for Sun Solaris11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jul 2000 08:31:56 +1000537_- Hi Vitor, 1. Yes, a DB2 command window exists on Sun. Execute the db2profile for your instance, and execute the db2 command. 2. However, I don't think a DB2 command window will help you here. A CONNECT to UDB returns a pointer (connection handle). This is required on all subsequent calls for actions against that database. So, while a DB2 CLP can establish a connection for subsequent sql, I am not aware of any way to get access to this handle to a program outside of the DB2 CLP. 3. You may be able to execute the CONNECT in a [...] 23623 45 15_Re: Alter Table16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Thu, 20 Jul 2000 19:32:10 -0400357_us-ascii Hi, using a view without the column effectively removes it from the table. The other way is to unload the table, drop and recreate without the column and reload. Check the reload jcl to ensure you are not reloading that column. ' HTH TomF







Aditya Narra on 07/20/2000 04:52:00 PM [...] 23669 19 31_Re: Stable Put Level for DB2 V612_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 21 Jul 2000 12:58:06 +1200363_us-ascii 0106, huh? A bit harsh, maybe, but possibly true. We've had a bit of trouble recently with V5 and PQ16946, the one that allows rows to be updated such that they can move partitions. It seems to have spawned a few PTFs but, I believe, there will be an APAR for PQ39836 shortly. Hasn't burnt us too bad - we're not usually into updating primary keys. [...] 23689 148 28_Re: Turn of Archive logging!11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jul 2000 11:13:43 +1000554_- Max,

I know you're not serious about buying ORACLE (or are you???), but until BIG DB2 gets this feature, maybe you should look at little db2 / Fisher-Price DB2 / DB2 UNO etc (sorry, I promise I won't get into all this again, not after my last experience...), it has had the NOT LOGGED feature for ages (well, for a couple of years anyway). This fact should also increase your chances of getting your request accepted, since no doubt IBM is working hard at making DB2 a truly universal database, with common features across all flavours :-) [...] 23838 61 28_Re: Turn of Archive logging!14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 20 Jul 2000 21:31:21 -0400397_iso-8859-1 Ah ha! You want the capability to allow user enforced data errors into your database that you won't be able to recover from? Hum...

Read between the lines...mother has listened to the masses, and not the minimal strange children! )joke joke - :-) :-) -- Always afraid that tongue in cheek gets strange responses when embedded in emails. But seriously, the message is clear! [...] 23900 100 36_Re: AW: SOS! Oracle to DB2 migration14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 21 Jul 2000 12:59:51 +1000746_iso-8859-1 -----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Thursday, July 20, 2000 11:46 PM To: DB2-L@RYCI.COM Subject: [DB2-L] AW: SOS! Oracle to DB2 migration



May be you'll find some helpful things on the following url:

http://www-4.ibm.com/software/data/db2/migration/

HTH. With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 24001 88 32_Re: SOS! Oracle to DB2 migration14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 21 Jul 2000 13:18:48 +1000633_iso-8859-1 Christine

Make sure you read http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245478.pdf as well as follow the other suggestions. (btw skip SG24-4981 - it is about converting to Oracle under OS/390.)

Of course, it's just a begining. The real horrors await you if you have to convert Oracle SPs or UDFs written in PL/SQL (Stored Procedure Builder came too late for us) or OCI (we bit the bullet and converted to COBOL and static SQL), or sequences (Identity columns also came too late). There's a lot to be said for saying "this is all an application problem." (All these require DB2 V6 - another can of [...] 24090 87 29_Urgent Help Required: DB2 UDB21_Yashas Mallawarachchi14_yasas@SLIIT.LK31_Fri, 21 Jul 2000 15:45:08 +0600534_iso-8859-1 Dear friends!

Our Institution owns an IBM AS/400 server which is dedicated for Domino. It uses OS/400 V4R4 as the operating system. SB2 Universal database is also installed in it. We are accessing the AS/400 using AS/400 Client Access express for V4R4.



For a a project we are currently involved in, we recommended using an IBM AS/400 server to be used as the central database/Application Server for their MIS. The Application Software is a cleint server based and it uses DB2 Universal database. [...] 24178 128 9_Your help0_18_dsi.listsrv@DB.COM31_Fri, 21 Jul 2000 11:00:57 +0530355_us-ascii

Hi all,

In our application we are using 60+ tables. Whenever we try to access any of these tables using 'select statement' , the database becomes 'Inconsistent'. Once we do a 'reorg' of the database, the database becomes 'consistent'. The configuration details of the database after the 'select statement' is attached below : [...] 24307 100 21_Database Inconsistent0_18_dsi.listsrv@DB.COM31_Fri, 21 Jul 2000 11:31:08 +0530380_us-ascii Hi all,

We are working on UDB 5.2 Database and in our application we are using 60+ tables. Whenever we try to access any of these tables using 'select statement' , the database becomes 'Inconsistent'. Once we do a 'reorg' of the database, the database becomes 'consistent'. The configuration details of the database after the 'select statement' is as below : [...] 24408 168 25_Re: Database Inconsistent0_29_Greg.Palgrave@BANKWEST.COM.AU31_Fri, 21 Jul 2000 14:27:59 +0800399_us-ascii Have you checked in db2diag.log file for any error messages or db2alert.log file? There may be diagnostics in there that you can use when getting assitance from your IBM support. You should contact them for assistance if the cause is not obvious.

What other events have occurred recently that may have affected the tables/database e.g load failed, disk restores etc.? Fixpacks? [...] 24577 557 25_Re: Database Inconsistent11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Fri, 21 Jul 2000 16:36:14 +1000604_iso-8859-1 A similar question came up in comp.databases.ibm-db2 a couple of months ago, and this was the reply from the Toronto lab:

... If there are no connections to the database, and the database has not been activated, and the database was shut down normally (i.e. did not abend), then consistent will = YES. After you have connected, as soon as an insert, update (i.e. any data modification), the consistent flag will = NO. The flag will not be set to YES again until a point where all connections have disconnected normally, (and/or the database has been deactivated successfully if it [...] 25135 112 28_Re: Help requested for query7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Fri, 21 Jul 2000 12:34:40 +0530459_iso-8859-1 Hi Melvin, As mentioned by Ashish ,GROUP BY and ORDER BY are not required in your query .One more thing is that if you are using Inline View for finding out the result set for "ALL CALLS" then you can not use ORDER BY and GROUP BY.

Regrads

Sanjeev

-----Original Message----- From: Mohan, Ashish [mailto:Ashish.Mohan@NIKE.COM] Sent: Thursday, July 20, 2000 10:40 PM To: DB2-L@RYCI.COM Subject: Re: Help requested for query [...] 25248 59 15_AW: Alter Table12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 21 Jul 2000 09:29:52 +0200630_iso-8859-1 Audi, I assume you are running DB2 for OS/390. At this point in time there is no chance to remove a column from an existing table. The only and the simple way is to use the specific column no longer..

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 25308 11 0_16_Daniel Gillieron23_daniel.gillieron@AGI.CH31_Fri, 21 Jul 2000 09:38:18 +0100259_us-ascii signoff*

================================================ 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. 25320 63 13_Re: Your help19_Peggs, Neal (ANFIS)22_neal.peggs@ANFIS.CO.UK31_Fri, 21 Jul 2000 09:54:57 +0100374_- Hi,

You don't say whether you can still use the database after it becomes 'inconsistent'. If so then I don't think you have any problems. My understanding of the situation is that the 'database_consistent' parameter will contain the value 'No' if there are any units of work running against the database or data that has not been written to disk from buffers. [...] 25384 47 46_Import data into DB2 for OS/390 via DB2 for NT12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 21 Jul 2000 11:14:44 +0200331_iso-8859-1 We are very, very new in DB2 for Windows NT and we run into the following problem:

Using DB2 for NT we did the connect to one of our DB2 for OS/390 systems. Okay, that works. After this we tried the following statement:

import from tgisanre.ixf of ixf messages import.txt insert into popgis.tgisanre; [...] 25432 114 28_Re: Help requested for query0_19_mike.holmans@BT.COM31_Fri, 21 Jul 2000 12:57:14 +0100640_- I think you'll find that the GROUP BY is essential, because without it you will get a -122 SQL code for inconsistent grouping.

Mike Holmans BT ISE Technical Design mike.holmans@bt.com

This post represents the views of the author and does not necessarily accurately represent the views of BT

> -----Original Message----- > From: Mohan, Ashish [SMTP:Ashish.Mohan@NIKE.COM] > Sent: Thursday, July 20, 2000 6:10 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Help requested for query > > Try > > Select PRB_NO,'ALL CALLS',SUM (COL2) FROM () T1. > > i.e. storing result of your query in a temporary table [...] 25547 15 13_Re: Your help14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 21 Jul 2000 08:48:50 -0400274_us-ascii Neal is correct. The database will almost always be inconsistent. We had this same situation and it truned out to be nothing. If you are not having any other problems then you should be okay. If not, you may have to do a restart on the database, etc. HTH Phil [...] 25563 37 39_Help! Name change for "Data Processing"14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Fri, 21 Jul 2000 09:15:30 -0400334_us-ascii Dear Fellow DB2-L'ers,

We are a local municipality with 150,000 citizens and are contemplating a name change from our current moniker of "Data Processing" to something more modern and indicative of our mission. As such, we have to get City Council to agree to a change in the City Code just to get a name change. [...] 25601 78 43_Re: Help! Name change for "Data Processing"0_27_jim.leask@RS-COMPONENTS.COM31_Fri, 21 Jul 2000 14:23:50 +0100674_iso-8859-1 Information Systems (IS) Information Technology (IT)

I would say Communication Technology is Information Technology.

Jim.

-----Original Message----- From: Greg DiGiorgio [mailto:gdigior@CI.NEWPORT-NEWS.VA.US] Sent: 21 July 2000 14:16 To: DB2-L@RYCI.COM Subject: Help! Name change for "Data Processing"



Dear Fellow DB2-L'ers,

We are a local municipality with 150,000 citizens and are contemplating a name change from our current moniker of "Data Processing" to something more modern and indicative of our mission. As such, we have to get City Council to agree to a change in the City Code just to get a name change. [...] 25680 12 43_Re: Help! Name change for "Data Processing"14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Fri, 21 Jul 2000 15:28:59 +0100269_us-ascii Knowledge system ?

================================================ 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. 25693 95 34_Fw: UDB 6.1 Control Centre problem10_Mark Feven19_markfeven@YAHOO.COM31_Fri, 21 Jul 2000 14:28:29 +0100453_iso-8859-1

Hi,



There is a known problem with starting the Control Center starting on a Win95 or Win98 machine if you have JRE 1.2 (Java 2.0) installed on your machine. DB2 installs and uses its own JRE 1.1.x for the Control Center.

The usual symptom is that when the user clicks on the Control Center icon, the task bar or screen flickers, and nothing happens. From the command line, db2cc just returns to the prompt. [...] 25789 70 43_Re: Help! Name change for "Data Processing"0_19_mike.holmans@BT.COM31_Fri, 21 Jul 2000 14:30:23 +0100685_- Information Technology Systems?

Actually, I merely wanted a giggle at the expense of that wonderful "newtwork" typo. Are you sure the town isn't Newport Newts?

Mike Holmans BT ISE Technical Design mike.holmans@bt.com

This post represents the views of the author and does not necessarily accurately represent the views of BT

> -----Original Message----- > From: Greg DiGiorgio [SMTP:gdigior@CI.NEWPORT-NEWS.VA.US] > Sent: Friday, July 21, 2000 2:16 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Help! Name change for "Data Processing" > > Dear Fellow DB2-L'ers, > > We are a local municipality with 150,000 citizens and are contemplating a > name change [...] 25860 95 43_Re: Help! Name change for "Data Processing"14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 21 Jul 2000 14:38:56 +0100497_iso-8859-1 How about throwing a few techie words together with some businessy words and seeing what happens? e.g. Any combination of: Telephony, Information, Technical, Bureau, Knowledge, Technology, Communications, Business, Data, e- with any other combination of: Systems, Services, Support, Technologies, Communications, Networks and maybe one of these in between: -based-, -enabled-, to come up with something like: Telephony, Information Technology Systems & Associated Support Services [...] 25956 128 43_Re: Help! Name change for "Data Processing"15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 21 Jul 2000 08:44:02 -0500439_iso-8859-1 It could be a game like throwing dice at a bar for a drink. Put one on each die and then shake and throw. See what comes up. It could work.

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

"A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila." - Mitch Ratliffe [...] 26085 77 43_Re: Help! Name change for "Data Processing"15_Murley, Michael22_Michael_Murley@BMC.COM31_Fri, 21 Jul 2000 08:51:31 -0500516_iso-8859-1 Greg,

Here are a few more ideas:

Municipal Information Processing Systems (MIPS) Municipal Information Support and Technology (MIST) City Information Technology Enablement or Communications and Information Technology Enablement (CITE) Newport News Information Technology Systems (NNITS) Knowledge Networks and Information Technology Systems (KNITS) Local Information Technology Enablement (LITE)

Michael Murley

p.s. Sorry about this. I like puns. Especially acronym puns. [...] 26163 72 43_Re: Help! Name change for "Data Processing"13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Fri, 21 Jul 2000 09:55:19 -0400357_iso-8859-1 How about:

CNN SI (City of Newport News Systems Integration)?

You might have a copyright problem....

I used to work for a large insurance company that started with 'P'. The name of our department was Information System Services(ISS). For some reason, the name of the company was never included with our department name. [...] 26236 101 43_Re: Help! Name change for "Data Processing"0_24_John_McComb@VANGUARD.COM31_Fri, 21 Jul 2000 09:58:10 -0400882_us-ascii How about Newport Institute of Technology for Processing Information and Communications Knowledge Systems (NIT-PICKS)

John McComb











"Murley, Michael" on 07/21/2000 09:51:31 AM Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John McComb/IT/VGI) Subject: Re: [DB2-L] Help! Name change for "Data Processing"





Greg,

Here are a few more ideas:

Municipal Information Processing Systems (MIPS) Municipal Information Support and Technology (MIST) City Information Technology Enablement or Communications and Information Technology Enablement (CITE) Newport News Information Technology Systems (NNITS) Knowledge Networks and Information Technology Systems (KNITS) Local Information Technology Enablement (LITE) [...] 26338 59 50_Re: Import data into DB2 for OS/390 via DB2 for NT14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Fri, 21 Jul 2000 08:57:04 -0500433_ISO-8859-1 Georg,

A couple questions :

1. Have you bound the DB2 utilitites against OS390? 2. Is IXF a valid format for OS390?

Mike

>>> G.Peter@DZBW.DE 07/21/00 04:14AM >>> We are very, very new in DB2 for Windows NT and we run into the following problem:

Using DB2 for NT we did the connect to one of our DB2 for OS/390 systems. Okay, that works. After this we tried the following statement: [...] 26398 112 28_Re: Turn of Archive logging!12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 21 Jul 2000 07:00:41 -0700598_us-ascii Which "mother" - Mother OS/390 or Mother PC/server. It seems that one side doesn't know what the other is doing, since the PC side has this capability. :=) (joking semi).

Seriously, there are situations where we have tables that need to be created and updated for short periods of time (hours or days) that don't need recovery. Temporary tables won't help because multiple users need access to the same data and they need to stay around between commits. We can create the tables via loads but then data must be updated/inserted into the tables thru complex SQL. And the tables [...] 26511 14 28_Re: Turn of Archive logging!14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Fri, 21 Jul 2000 16:04:12 +0100282_us-ascii Thanks Myron.

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. 26526 184 29_Re: Turn off Archive logging!13_Adrian Savory24_adrian.savory@ZURICH.COM31_Fri, 21 Jul 2000 15:10:03 +0100478_iso-8859-1 Migrations of ERPs from other platforms to DB2 would seriously benefit from this, as would migrations from one ERP release to another . The elapsed times for these is horrendous, and anything that can improve on it would be more than welcome.

Adrian Savory ACSIS Ltd







Myron Miller cc: Sent by: DB2 Subject: Re: Turn of Archive logging! Data Base Discussion List [...] 26711 95 50_AW: Import data into DB2 for OS/390 via DB2 for NT12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 21 Jul 2000 16:16:01 +0200563_iso-8859-1 Mike, thanks for your questions. Here are the answers...

>>> 1. Have you bound the DB2 utilitites against OS390? <<<< I've nothing found that I have to do so. If possible please provide me the specific manual for a description what to do. Thanks.

>>> 2. Is IXF a valid format for OS390? <<< I hope so... The data we want to load was delivered from another IT center that runs the same application. But unfortunately the application guru there is out of the office for some weeks and so I cannot ask him... And so I posted my problem [...] 26807 85 27_RUNSTATS- KEYCARD & FREQVAL11_Rosie Porco17_rporco@UOTTAWA.CA31_Fri, 21 Jul 2000 10:32:06 -0400701_us-ascii We are OS390 DB2V5.1 My questions relate to Runstats with the KEYCARD option and FREQVAL. RUNSTATS TABLESPACE(DBD004.TBS017) TABLE(ALL) INDEX(ALL,KEYCARD) one table in tablespace , one composite index (4 columns cola,colb,colc,cold) .

This runstats create 2 rows in SYSCOLDIST . FREQUENCT TPYE CARDF COLGROUPCOLNO -1 C +0.32186E+05 HEX(0203) -1 C +0.32374E+05 HEX(020304) I thought CARDF would contain: ''The number of distinct values for the column group''. How do I read this info?. Also ran runstats with RUNSTATS TABLESPACE(DBD004.TBS017) TABLE(ALL) INDEX(ALL,KEYCARD FREQVAL NUMCOLS 1 COUNT 10 FREQVAL NUMCOLS 2 COUNT 5 FREQVAL NUMCOLS 3 COUNT 2 FREQVAL NUMCOLS 4 COUNT 2 As [...] 26893 65 28_Stored Procedure Performance27_Scott.Gjerdingen (Exchange)27_Scott.Gjerdingen@TARGET.COM31_Fri, 21 Jul 2000 09:25:30 -0500670_iso-8859-1 I am considering converting a common cobol subroutine into a stored procedure (os/390 based) which will be called from batch jobs, cics transactions and potentially in the future in a client/server n-tier capacity. I have seen benchmark data on improvements stores procedures can provide client server applications that previously executed dynamic SQL but I have not seen any sort of comparison between OS/390 based batch and CICS transactions using stored procedures vs. cobol subroutines (i.e. gains resulting from something other than reduction in network time). I suppose there will be some runtime improvement associated to running the SPAS in goal [...] 26959 87 31_Re: RUNSTATS- KEYCARD & FREQVAL12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 21 Jul 2000 14:46:27 GMT546_- HTH,

The value in the CARDF is in FLOATING POINT format. Take the numeric, and move the decimal to the right using the number after the E. For example in your list you have : +0.32186E+05 This is the equivelent of: 32861. (Move the decimal 5 places to the right).

The reason you are NOT getting index access is that you are NOT referencing the first column of the index key (cola). I believe the first version of DB2 that CAN use an index without referencing the first column in the index key is V6. (I don't remember all of [...] 27047 116 54_Re: AW: Import data into DB2 for OS/390 via DB2 for NT14_Mike Lebermann18_Lebermm@BCBSKC.COM31_Fri, 21 Jul 2000 09:47:06 -0500520_ISO-8859-1 Georg,

The easiest way to bind the utilities:

1. Open the Client Configuration Assistant from DB2 for NT folder. 2. Highlight the DB2 OS390 database alias from the list of databases available and click on Bind 3. Select Bind DB2 utilities, click Continue 4. You will be prompted to connect to the OS390 database. Connect to the database. 5. Highlight the utilities you want to bind, and click on Options. 6. Select Row Blocking All, click OK 7. Then click OK from the Bind Utilites window. [...] 27164 82 31_Re: RUNSTATS- KEYCARD & FREQVAL0_19_mike.holmans@BT.COM31_Fri, 21 Jul 2000 15:50:49 +0100464_- You have an index with four columns. SYSIBM.SYSINDEXES contains the columns FIRSTKEYCARDF and FULLKEYCARDF. These are the number of distinct values for the first column of the key and for the key containing all four columns, respectively. What goes into SYSCOLDIST as type C stats are the intermediate partial key statistics for the first two and first three columns. You will find how many columns each row refers to by reference to the NUMCOLUMNS column. [...] 27247 78 15_Re: Alter Table14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Fri, 21 Jul 2000 10:26:55 -0500582_iso-8859-1 Actually, changing or removing a column from a current table is a little more complicated than described below. When you drop the table, all subordinate objects are also dropped and security for that table is revoked. So, if all you really want to do is add a column or change a definition, be sure to also keep a record of the indexes, views, and synonyms on the table (aliases are not dropped). Do not forget primary and foreign keys, check constraints, FIELDPROC and EDITPROC assignments, labels and comments in the catalog, and if you are on DB2 V6 any triggers [...] 27326 98 32_Re: -913 SQLCODE and DB2 Connect12_Chris Rennie28_chris.rennie@CCRA-ADRC.GC.CA31_Fri, 21 Jul 2000 10:29:53 -0500270_- Hi Dave,

I'm not sure if this will help, but we've run into similar problems with remote CICS configurations and the following writeup might give you some ideas for your problem:

--------------------------------------------------------------------------- 27425 25 34_DB2 Connect and Solaris - SQL2071N11_Tim Kearney22_tkearney@ACCESS360.COM31_Fri, 21 Jul 2000 11:26:11 -0500349_- Subject: Error SQL2071N: An error occured while accessing the shared lib "libdb2licm.so". Reason code: ""

We are using DB2 Connect Enterprise Edition V6.1 on Solaris (Developer license) for connectivity to DB2 for OS/390. When trying their JDBC driver sample code and our own Java JDBC application, we got error message in both cases: [...] 27451 27 22_DB2 Connect - SQL0551N14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 21 Jul 2000 12:49:28 -0400398_- Hi, I'm getting the above SQL code when I try to use DB2 Connect interactivly (from an MS/DOS prompt) doing a select on a table. When I run a JDBC program that goes thru a Solaris gateway with the connection statements coded in the program the select is successful. Both methods are going to the same region, passing the same userid and password. Any thoughts would be appreciated. TIA Dean [...] 27479 19 60_DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ?16_Christine Sawyer20_cosawyer@HOTMAIL.COM29_Fri, 21 Jul 2000 13:16:27 EDT 27499 170 64_Re: DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ?13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 21 Jul 2000 12:23:08 -0500530_US-ASCII Christine, You do not use a length with varchar, you use POSITION ex. NAME POSITION( 415: 446 ) VARCHAR

HTH Kurt

Hi List, I'm having problem loading a table. The problem it seems is with a VARCHAR column of my table. I have "VARCHAR(60) NOT NULL" define as a column and DB2 don't seem to like my definition. I have research how DB2 handles VARCHAR and I don't see anything wrong with my definition (then again, what do I know!). The following SDSF display shows the error I got when I ran my test job: [...] 27670 58 26_Re: DB2 Connect - SQL0551N16_Michael McCarthy18_mmccarthy@DTCC.COM31_Fri, 21 Jul 2000 13:30:50 -0400468_us-ascii Dean,

This could happen if you're using SNA and USERID translation for your connection if the SYSIBM.USERNAMES (SYSUSERNAMES before V5), does not switch the USERID from the gateway you use when executing from Windows DB2 Command Window.

Hope this helps,

Mike.









Dean Montevago on 07/21/2000 12:49:28 PM

Please respond to DB2 Data Base Discussion List [...] 27729 75 26_Re: DB2 Connect - SQL0551N14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 21 Jul 2000 13:47:13 -0400589_- We are using TCP/IP

> -----Original Message----- > From: Michael McCarthy [SMTP:mmccarthy@DTCC.COM] > Sent: Friday, July 21, 2000 1:31 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect - SQL0551N > > Dean, > > This could happen if you're using SNA and USERID translation for your > connection if the SYSIBM.USERNAMES (SYSUSERNAMES before V5), does not > switch the USERID from the gateway you use when executing from Windows DB2 > Command Window. > > Hope this helps, > > Mike. > > > > > > Dean Montevago on 07/21/2000 12:49:28 PM > > Please respond to [...] 27805 84 64_Re: DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ?13_Crowley, Paul21_CrowleP@DIVINVEST.COM31_Fri, 21 Jul 2000 12:54:16 -0500386_iso-8859-1 Christine, If your table is not too large you could run a unload with sysrec dd dummy and unload will generate the load parmcard in syspunch dataset. Paul C.

-----Original Message----- From: Christine Sawyer [mailto:cosawyer@HOTMAIL.COM] Sent: Friday, July 21, 2000 1:16 PM To: DB2-L@RYCI.COM Subject: DB2 Load problem: What's wrong with "VARCHAR(60) NOT NULL" ? [...] 27890 19 43_Re: Help! Name change for "Data Processing"26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Fri, 21 Jul 2000 12:55:56 -0500391_- Think I saw the first "Instant Buzzword Generator" on the back of business card from an OEM vendor. One of the bright kiddies even made a random phrase generator out of it. Advanced Information Synergy was a favorite. Today you need to buy the "e" vowel somewhere. eConnection, eBusiness, eSystems, eNough...... Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 27910 17 24_DB2 V7 OS/390 and IMS V&14_Gill, Joseph G19_joseph.gill@EDS.COM31_Fri, 21 Jul 2000 13:48:38 -0400441_iso-8859-1 The current doc on DB2 V7, only mentions IMS V6 as working with this release. (That is from Pg 49 of the planning guide.)

What is the status of IMS V7 compatibility?

Thanks !

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 27928 68 43_Re: Help! Name change for "Data Processing"21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Fri, 21 Jul 2000 11:10:05 -0400688_iso-8859-1 Greg

We call ourselves "Department of Information Technology" or DIT at the City of Richmond.

Jim



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Greg DiGiorgio Sent: Friday, July 21, 2000 9:16 AM To: DB2-L@RYCI.COM Subject: Help! Name change for "Data Processing"



Dear Fellow DB2-L'ers,

We are a local municipality with 150,000 citizens and are contemplating a name change from our current moniker of "Data Processing" to something more modern and indicative of our mission. As such, we have to get City Council to agree to a change in the City Code just to get a name [...] 27997 134 31_Re: RUNSTATS- KEYCARD & FREQVAL13_Dana Nicholis26_dana.nicholis@ZURICHUS.COM31_Fri, 21 Jul 2000 10:16:26 -0500387_us-ascii



I found the same thing, there is a PTF that you may be missing:

APAR Identifier ...... PQ31133 Last Changed ........ 00/04/05 RUNSTATS ... INDEX ALL RETURNS UNEXPECTED OUTPUT IN SYSIBM.SYSCOLDIST : TYPE='F' ROWS, BUT NO TYPE='C' ROWS.

PTF List: Release 510 : UQ41000 available 00/03/17 (F003 ) Release 610 : UQ41001 available 00/03/17 (F003 ) [...] 28132 27 28_Re: DB2 V7 OS/390 and IMS V&0_17_JTonchick@AOL.COM29_Fri, 21 Jul 2000 14:08:05 EDT531_US-ASCII In a message dated 07/21/2000 1:02:14 PM Central Daylight Time, joseph.gill@EDS.COM writes:

<< The current doc on DB2 V7, only mentions IMS V6 as working with this release. (That is from Pg 49 of the planning guide.)

What is the status of IMS V7 compatibility? >>

The DB2 manual probably only mentioned IMS V6 since V7 was not GA at the time of printing. I'm sure that IBM will have IMS V7 support DB2 V7 and vice versa once they both go GA. They haven't miss this in the past, as far as I know. [...] 28160 560 35_DSNTESP queries / number of extents41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Fri, 21 Jul 2000 15:12:16 -0300362_iso-8859-1 I have been looking for ways of avoiding several extents in index and tablespace datasets, but when I run queries from DSNTESP the values returned from those queries do not confirm with those I get from a dataset listing.

This query (query #20 from DSNTESP, DB2 V.5) should return the number of extents for tablespaces of database 'DBBEG' [...] 28721 19 29_SPUFI and two versions of DB211_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 21 Jul 2000 11:25:58 -0700510_iso-8859-1 Hi all, Does anyone have a way to handle SPUFI with subsystems at different versions without having to go to the READY prompt to change loadlibs?? We have v5 SDSNLOAD and SDSNEXIT in the linklist and our development subsystem is going to v6. thanks cliff:-)

================================================ 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. 28741 42 33_Re: SPUFI and two versions of DB212_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 21 Jul 2000 11:36:52 -0700587_us-ascii Its fairly straight forward if you go into the clists that invoke SPUFI (and option D). You change the allocations to test to see what version and allocate the appropriate version at that time (either upon entry) or via option D. There's a ISPF parm that tells what version you're invoking. Just test that parm and do the allocations based upon that test. --- Cliff Boley wrote: > Hi all, > Does anyone have a way to handle SPUFI with > subsystems at different versions > without having to go > to the READY prompt to change loadlibs?? > [...] 28784 20 10_table hits15_Kuashal Trivedi17_c_triveka@BAM.COM31_Fri, 21 Jul 2000 14:46:37 -0400464_iso-8859-1 Hi All, I would like to know if there is any way I could find out tables that are being hit like a zillion times in a day, we have Insight,tmon, or maybe any ther means.

TIA

regards Kaushal Trivedi

================================================ 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. 28805 34 14_Re: table hits9_Mark Ruhe19_Mark.Ruhe@QUEST.COM31_Fri, 21 Jul 2000 11:55:41 -0700421_iso-8859-1 You might want to look at Subsystem Analyzer from CA/Platinum

-----Original Message----- From: Kuashal Trivedi [mailto:c_triveka@BAM.COM] Sent: Friday, July 21, 2000 1:47 PM To: DB2-L@RYCI.COM Subject: table hits



Hi All, I would like to know if there is any way I could find out tables that are being hit like a zillion times in a day, we have Insight,tmon, or maybe any ther means. [...] 28840 112 39_Re: DSNTESP queries / number of extents13_Larry Jardine22_larry.jardine@WCOM.COM31_Fri, 21 Jul 2000 14:52:24 -0400350_iso-8859-1 BlankI'll take a stab at this.

Your query is measuring an extent as growth beyond the PRIQTY of 3; however, the 3 listed in systablepart is equivalent to 3 pages (4k each). To get this, you would have had to create the space with a priqty of 12 (you request it in terms of kilobytes; it is reported back in terms of 4k pages). [...] 28953 53 23_How to recover QMFSPACE13_Carol Robbins18_CJRobbins@FHSC.COM31_Fri, 21 Jul 2000 15:03:08 -0400316_US-ASCII In order to move user QMF spaces, the spaces were backed up with Image Copies. After the QMF spaces were dropped and recreated, we are having a problem trying to restore the tables in these spaces due to info dropped from the SYSCOPY table. Is there a way to pull this info from the image copy? thanks Carol 29007 45 27_Re: How to recover QMFSPACE15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 21 Jul 2000 14:21:27 -0500459_iso-8859-1 You should have unloaded the data rather than backed up with image copies. When you dropped your tables DB2 also deletes ALL information pertaining to the tables including image copies, catalog stats, info about updates in the logs, all authorities, RI, etc.

If you still have the data sets that the image copies you will probably be able to recover the data using DSN1COPY. Look in the DB2 utilities manual to find out how this works. [...] 29053 71 27_Re: How to recover QMFSPACE13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 21 Jul 2000 14:26:39 -0500542_US-ASCII Carol, you can use DSN1PRNT to print the header page(s) that contain the OBIDs, DBIDs AND SPIDs you need for the OBIDXLAT parms in a DSN1COPY restore. HTH Kurt



>>> CJRobbins@FHSC.COM 07/21/00 02:03PM >>>

In order to move user QMF spaces, the spaces were backed up with Image Copies. After the QMF spaces were dropped and recreated, we are having a problem trying to restore the tables in these spaces due to info dropped from the SYSCOPY table. Is there a way to pull this info from the image copy? thanks Carol 29125 65 39_Re: DSNTESP queries / number of extents14_Susan E Carter18_SCARTER@PANTEX.COM31_Fri, 21 Jul 2000 14:22:00 -0500398_US-ASCII Claudio,

Another thing to keep in mind when allocating primary space is that you can have a table in primary extents but not DB2 extents because of fragmented packs. We create all our tablespaces in whole cylinders to avoid your very same problem. I also included the sql that we use to determine extents. Should have the same result set as yours but perhaps a little simpler. [...] 29191 23 16_dynamic E - CRUD19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Fri, 21 Jul 2000 15:31:17 -0400300_us-ascii Here's a question. I've been asked to remove some columns from a table. I tell if they are used via packages, and have the programmer do PANVALET scans of code but...., for those tables dynamically accessed by the web I cannot tell who accesses what, and to a lesser degree, how often. [...] 29215 42 27_Re: How to recover QMFSPACE15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 21 Jul 2000 14:41:50 -0500412_iso-8859-1 Good point, Kurt. Thanks!

Linda

-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Friday, July 21, 2000 2:27 PM To: DB2-L@RYCI.COM Subject: Re: How to recover QMFSPACE



Carol, you can use DSN1PRNT to print the header page(s) that contain the OBIDs, DBIDs AND SPIDs you need for the OBIDXLAT parms in a DSN1COPY restore. HTH Kurt [...] 29258 227 25_Re: Database Inconsistent12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 21 Jul 2000 12:48:49 -0700587_us-ascii An "inconsistent" database is a broken database. Instead of using REORG, try using RESTORE from your backups. You have taken backups of course. The reason why it broke may be in the db2diag.log, and associated trace or dump files located in the same directory. Tim --- Greg.Palgrave@BANKWEST.COM.AU wrote: > Have you checked in db2diag.log file for any error > messages or db2alert.log > file? > There may be diagnostics in there that you can use > when getting assitance > from your IBM support. You should contact them for > assistance if the cause > is not obvious. > > [...] 29486 42 33_Re: SPUFI and two versions of DB211_Suresh Sane21_data_arch@HOTMAIL.COM29_Fri, 21 Jul 2000 15:04:29 CDT718_- Cliff: one simple option is to provide 2 different panel options and LIBDEF the proper lodlib prior to execution. Not elegant, but works.

HTH.

Suresh



>From: Cliff Boley >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: SPUFI and two versions of DB2 >Date: Fri, 21 Jul 2000 11:25:58 -0700 > >Hi all, >Does anyone have a way to handle SPUFI with subsystems at different >versions >without having to go >to the READY prompt to change loadlibs?? >We have v5 SDSNLOAD and SDSNEXIT in the linklist and our development >subsystem is going to v6. >thanks >cliff:-) > >================================================ [...] 29529 59 51_DB2 Connect Subsystem Name as Current SQLID problem12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 21 Jul 2000 15:06:38 -0500534_us-ascii Hello.



I'm passing this on from one of our programmers. Thanks in advance for any assistance!



-=-=-=-=-=-=-=-=-=-=-=



I am trying to use DB2 Connect Personal Edition to connect my Windows NT development workstation to DB2 OS/390. Using the DB2 Client Configuration Assistant, I can connect to our newly created DB2 subsystem and successfully bind the DB2 Utilities. Once connected, I am having problems setting the Current SQLID and viewing our tables and other data objects. [...] 29589 30 29_DB2 Connect - SQL0551N Take 214_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 21 Jul 2000 16:12:07 -0400503_- I'm posting this again, I've been fiddling with this for a while and can't come up with anything.

Hi, I'm getting the above SQL code when I try to use DB2 Connect interactivly (from an MS/DOS prompt) doing a select on a table. When I run a JDBC program that goes thru a Solaris gateway with the connection statements coded in the program the select is successful. Both methods are going to the same region, passing the same userid and password. Any thoughts would be appreciated. TIA Dean [...] 29620 33 26_DB2 Connect sysplex option13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 21 Jul 2000 15:21:18 -0500504_iso-8859-1 Hello,

Does anyone have experience using the sysplex option of DB2 Connect EE? And if so, how would one exclude a particular MVS image in the MVS sysplex (i.e. DB2 data sharing group member) from receiving distributed work (assuming WLM is in goal mode)?

We use the sysplex option in our test environment (WLM in compatibility mode) but found that workload balancing was not working well. IBM told us that it would work in WLM goal mode, which we are working toward anyway. [...] 29654 77 30_Re: DB2 Connect sysplex option10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 21 Jul 2000 16:57:06 -0400879_us-ascii Dave

I curious about the 'it doesn't work well' what does that mean. I may be moving towards distributed balancing and wlm in compat mode.

Tom













"Shapiro, Dave" on 07/21/2000 04:21:18 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Thomas G Taylor/ChubbMail)





Subject: DB2 Connect sysplex option















Hello,

Does anyone have experience using the sysplex option of DB2 Connect EE? And if so, how would one exclude a particular MVS image in the MVS sysplex (i.e. DB2 data sharing group member) from receiving distributed work (assuming WLM is in goal mode)? [...] 29732 115 30_Re: DB2 Connect sysplex option13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 21 Jul 2000 16:37:20 -0500408_iso-8859-1 Tom,

We found that of 8 DB2's in a datasharing group, work would be routed unpredictably and no workload balancing would result. For example, 2 or 3 DB2's would get loaded up heavily, all day, and others would only get a few requestors, while still others would get no work at all. There was no pattern at all as to what category a DB2 would fall into at any particular point in time. [...] 29848 81 30_Re: DB2 Connect SYSPLEX option0_15_leon@CA.IBM.COM31_Fri, 21 Jul 2000 18:20:23 -0400665_us-ascii Dave, how about setting MAXDBAT=0 if you want to exclude a member from distributed workload?

How workload is distributed between members of the SYSPLEX will depend on whether you are using DB2 Connect V6.1 or V7.1 with Connection Concentrator turned on. it will also depend on the type of application mix (long running connections vs. frequent connect/disconnect). DB2 Connect V6.1 and V7.1 with Connection Concentrator turned off does the evaluation of which member to send the work to at connection establishment time. This means that if you have long-running connections (e.g. application server that builds up several connections at server [...] 29930 33 14_Re: table hits14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Fri, 21 Jul 2000 19:56:34 -0400484_ISO-8859-1 Insight can show you this, so can Tmon. Depending on which datacenter you are running at, you may also have access to Buffer Pool Tool for DB2. You could also look at DASD/Xpert for DB2. Check with Karl King and Charles Valentin. Regards, Joel

Message text written by DB2 Data Base Discussion List >I would like to know if there is any way I could find out tables that are being hit like a zillion times in a day, we have Insight,tmon, or maybe any ther means. [...]