1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2000, week 2 2 91 54_Re: Jeff Gross (FW: Bad News (was Re: 15 table limit))23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Mon, 8 May 2000 07:22:17 +0100396_iso-8859-1 Aurora, Whilst I agree with your request, .. can I suggest in future that you send this kind of mail direct to the list owner.

kindest regards

Leslie Fastrack Information Systems

-----Original Message----- From: IBM1 [mailto:IBM1@UBIL.COM.TR] Sent: Saturday, May 06, 2000 8:14 AM To: DB2-L@RYCI.COM Subject: Jeff Gross (FW: Bad News (was Re: 15 table limit)) [...] 94 46 29_Re: DSNDB07 and Shark - pav's23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Mon, 8 May 2000 07:25:26 +0100375_iso-8859-1 we are thinking about doing this ourselves ... which should improve the crap performance we get from the DSNDB07 datasets we have now (sorry WRK .. as we are datasharing now).

Leslie

-----Original Message----- From: Tom Taylor [mailto:ttaylor@CHUBB.COM] Sent: Thursday, May 04, 2000 2:55 PM To: DB2-L@RYCI.COM Subject: DSNDB07 and Shark - pav's [...] 141 76 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Toine Michielse18_vndobtm@US.IBM.COM30_Mon, 8 May 2000 08:49:57 +0100404_us-ascii Jim,

Haven't been following the thread for a while but here's one consideration. If you keep dirty pages around until checkpoint then it will also take a longer time for pages to be able to be moved to hiperpool. As a result you will need a larger virtual pool. In a lot of installations I've worked with, hiperpools are a good way to reduce the virtual storage requirement of DBM1. [...] 218 54 39_"Setup cannot create username db2admin"14_Romeo B Titong26_rbtitong@ACISYSTEMS.COM.PH30_Mon, 8 May 2000 16:22:15 +0800412_us-ascii HI all!

I already have installed DB2 UDB 6.1 on many NT machines, but this is the first time I encountered this error:

"Setup cannot create username db2admin"

I tried Workgroup and Enterprise editions and still same problem.

I tried manually creating user DB2ADMIN and logging in using DB2ADMIN. But DB2 was not able to verify if the user exists and returns same error. [...] 273 20 43_Re: "Setup cannot create username db2admin"14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM30_Mon, 8 May 2000 12:23:26 +0200358_us-ascii We had this problem when installing DB2 UDB 6.1 on NT V4 fixpack 5.

Our environment was : 2 WinNT being part of the same security domain. On the panel where you specify 'db2admin' during the UDB installation, you should prefix the userid with the name of the primary domain controller, thus specifying the 'complete' path to the userid. [...] 294 25 43_Re: "Setup cannot create username db2admin"13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Mon, 8 May 2000 07:58:02 -0400353_iso-8859-1 I have seen the first problem you describe with 6.1 EE and I have resolved it by manually creating the ID. When you do this, DB2 install does warn you that it can't validate the password, but it's a warning only and the install has always completed successfully for me. I believe the only group db2admin needs to be in is Administrator. [...] 320 16 63_Re: Bad News (was Re: Changing Passwords via DB2 Connect v5.2.)13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Mon, 8 May 2000 07:34:47 -0500377_- How did you define security in the CCA for this database? Did you select 'On the Host or AS/400 DCS'?

We have successfully implemented the change password feature using DB2 Connect PE V6.1 and DB2/OS390 V5.1. All we had to do is set Extended Security to Y. We already had the DDF started task defined and restricted in Top Secret so no changes were needed there. [...] 337 587 63_Repost: DB2 Sets BI Performance Record in 300GB TPC-H Benchmark13_Morrill, John12_JohnM@VP.NET30_Mon, 8 May 2000 07:33:34 -0600753_iso-8859-1 Greetings!

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

Cheers!

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



Dear DB2 Interested Parties,

On May 3, 2000 IBM announced that its next generation NUMA-Q 2000 and DB2 Universal Database Version 7.1 have set new records for both performance and price/performance in the industry standard TPC-H benchmark, confirming that DB2 Universal Database is the leading DBMS platform for large-scale business intelligence applications. Below is [...] 925 61 23_Re: Unix "grep" Command13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Mon, 8 May 2000 08:27:58 -0500322_us-ascii Hi Dale, I think that you will find that many people that "grew up" on DB2 on the mainframe tend to avoid UNIX commands like grep and awk and try to do everything in SQL. Also it is more efficient to write the code in SQL and let DB2 do the work, than to read the data into a script and manipulate it there. [...] 987 24 29_Question about UQ18604 ( V5).9_Ted Pesta18_tpesta@AMQUEST.COM30_Mon, 8 May 2000 10:05:26 -0400386_iso-8859-1 Good Morning,

I'm applying maintenance to a V5 subsystem. One of the PTF's being applied is UQ18604. When I do the apply check, I get a message GIM54502E :

ALLOCATION FAILED FOR DSNEXIT BECAUSE THERE IS NO DD STATEMENT IN THE JCL AND NO DDDEF ENTRY IN TARGET ZONE DSNTARG.

My question is: Shouldn't V5 PTF's be using SDSNEXIT instead of DSNEXIT ??? [...] 1012 94 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 8 May 2000 09:36:28 -0500636_ISO-8859-1 Jim, I tend to agree with you that, given the right circumstances, I should exploit I/O subsystem capabilities. But again, this must be weighed against OS390 overhead (which steals CPU clicks from all tasks including DB2) and the suspended tasks waiting on those pages during the I/O. The longer the I/O takes to complete the longer the wait. Improved I/O subsystems do this faster and return EOC faster too. But it isn't necessarily true that upping VDWQT or DWQT will increase changed pages per dataset. There's some point, given datasets assigned remain constant, where increasing bufferpool size doesn't improve hit [...] 1107 112 23_Re: Unix "grep" Command12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV30_Mon, 8 May 2000 10:47:39 -0400558_iso-8859-1 One of the most convenient features I've seen in UDB/Windows is its search capabilities. I'd assume that UDB/AIX is equivalent. Its been awhile since I've looked at it, but I seem to remember going through the "movie" database tutorial in V5.1, where the demo was showing how to do natural language, phonetic, and "like" searches very easily on varied types of data, including LOBs of pictures. I haven't looked at V6.1 yet, but I'd have to assume that they've only gotten better and could easily accomplish what you're looking for natively. [...] 1220 38 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING13_Adrian Savory24_adrian.savory@ZURICH.COM30_Mon, 8 May 2000 16:00:07 +0100444_us-ascii Rick,

>I think I see a pattern developing, at least for me. If I had a >bufferpool where changed pages per dataset were high (good >locality-of-reference), and this will seem counterdictory to some, I'd up >the VDWQT and DWQT if my I/O subsystem and OS390 can handle it, hoping that >re-referenced/updated page hits remained high. It seems to me that this >would give you the I/O subsystem exploitation you rightly desire. [...] 1259 43 43_Re: "Setup cannot create username db2admin"14_Philip Gunning20_pgunning@BOSCOVS.COM30_Mon, 8 May 2000 11:20:05 -0400385_iso-8859-1 This only happens when installing on a BDC. The userid must exist on the PDC, then enter the domain name followed by the \userid. Example: DB2DOM1\DB2ADMIN. That will work. You do not run into this problem on stand alone servers, just BDCs. HTH Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS [...] 1303 16 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 8 May 2000 10:11:10 -0500472_us-ascii Great discussion ... Question sligthly off the thread.

When you alter SYSTABLESPACE.BPOOL to move the TS to a new buffer pool, when does the change take effect, immediately or after the DB2 subsystem is re-started.

================================================ 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. 1320 15 42_DB2 Connect PE for NT using DB2 UDB on AIX13_Shauna Hadden24_shauna.hadden@BCBSKS.COM30_Mon, 8 May 2000 10:17:49 -0500415_- We are trying to set up DB2 Connect PE on NT to talk to DB2 UDB on AIX. Is there a way to use DB2 UDB on the AIX box without having to set up Unix accounts for all of the clients/programmers? I am sure the secret is within the Authentication parameters and we have played with both SERVER and CLIENT with no luck. I have checked out the manual(s), but they are very confusing. Can anyone provide assistance? [...] 1336 247 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 8 May 2000 10:38:18 -0500543_ISO-8859-1 Hi Paul, Thank you very much for your insights. I've tried but cannot find a reference for your following statements:

"My understanding for the VDWQT is that if it is hit ALL pages on the queue for that pageset are written out. I believe that if a set-write page is part of a few pages about to be written but for which the I/O has not yet been scheduled has a GETPAGE issued for it by the buffer manager then it is actually removed from the queue and used and then a synchronous write is performed for it on completion [...] 1584 32 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING17_Lobenstein, Jerry30_Jerry_Lobenstein@COMPUWARE.COM30_Mon, 8 May 2000 11:46:20 -0400544_iso-8859-1 The next request for a page of data will utilize the new BufferPool assigned.



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Monday, May 08, 2000 11:11 AM To: DB2-L@RYCI.COM Subject: Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING



Great discussion ... Question sligthly off the thread.

When you alter SYSTABLESPACE.BPOOL to move the TS to a new buffer pool, when does the change take effect, immediately or after the DB2 subsystem is re-started. [...] 1617 143 23_Re: Unix "grep" Command12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 8 May 2000 18:53:42 +0200722_x-user-defined Hi, It ain't the same and NOT for DB2 tables, BUT if you want GREP on MF here is something:

/* REXX */ TRACE O "ISREDIT MACRO (PARM) " "ISPEXEC CONTROL ERRORS RETURN" PARSE UPPER VAR PARM CMD STR COL IF CMD='' THEN CALL INFO; IF STR='' THEN STR=CMD; LSTR=LEFT(STR,1); IF LSTR='!' THEN STR=SUBSTR(STR,2); SELECT; WHEN LEFT(STR,1)='[' THEN CALL PATTERN; WHEN LEFT(STR,1)='~' THEN CALL START ; WHEN CMD='-V' | LSTR='!' THEN "ISREDIT EXCLUDE ALL '"STR"'"; OTHERWISE DO; "ISREDIT EXCLUDE ALL" "ISREDIT FIND ALL '"STR"'" END; END; /* "ISREDIT DELETE ALL EXCLUDE" "ISREDIT RESET" */ RETURN; /*****************************************************************/ PATTERN: X=POS(']',STR); L=LENGTH(STR); IF [...] 1761 36 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 8 May 2000 19:01:23 +0200585_x-user-defined Hi, Stop TS/Start TS is enough (same for IX).

Isaac Yassin

Rohn.Solecki@MTS.MB.CA wrote: > > Great discussion ... Question sligthly off the thread. > > When you alter SYSTABLESPACE.BPOOL to move the TS to a new buffer pool, when > does the change take effect, immediately or after the DB2 subsystem is > re-started. > > ================================================ > 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. 1798 38 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Mon, 8 May 2000 12:01:59 -0400473_ISO-8859-1 The object has to be stopped/started for the new pool assignment to take effect. Regards, Joel



Message text written by DB2 Data Base Discussion List > The next request for a page of data will utilize the new BufferPool assigned.



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Monday, May 08, 2000 11:11 AM To: DB2-L@RYCI.COM Subject: Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING [...] 1837 61 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING14_Massimo Scarpa16_mscarpa@CESVE.IT30_Mon, 8 May 2000 18:02:43 +0200411_us-ascii Hi Rick, Hi Jim & Adrian

I 'm following this very interesting argument and I tend to agree with Joel Goldstein's

opinion that in a multiple bufferpool environment usually pages/writes tend to be constant even

modifying (V)DWQT limits in many cases. I made many and many tests using many

applications and many bufferpool. Yes there are some application that show a high [...] 1899 63 23_Re: Unix "grep" Command15_Ruzeski, Dennis30_dennis.ruzeski@INGRAMMICRO.COM30_Mon, 8 May 2000 12:05:15 -0400827_iso-8859-1 It's actually an add on product called DB2 Text Extender which eases text search capabilities-

http://www-4.ibm.com/software/data/db2/extenders/text.htm

Check it out.







-----Original Message----- From: Hylton Tom P [mailto:Tom.P.Hylton@IRS.GOV] Sent: Monday, May 08, 2000 10:48 AM To: DB2-L@RYCI.COM Subject: Re: Unix "grep" Command





One of the most convenient features I've seen in UDB/Windows is its search capabilities. I'd assume that UDB/AIX is equivalent. Its been awhile since I've looked at it, but I seem to remember going through the "movie" database tutorial in V5.1, where the demo was showing how to do natural language, phonetic, and "like" searches very easily on varied [...] 1963 96 18_Re: DB2 V7 manuals15_Belfield, Al G.15_AGBELFI@TWA.COM30_Mon, 8 May 2000 11:00:38 -0500371_iso-8859-1 Thanks for the responses. I knew the PDF manuals were supposed to be on the website.... trouble was that I was starting from the DB2 Product page and following the V7 Beta path from there, which doesn't give you the same pages as going thru the normal download path. Mystery solved (thanks to the patience of Sven Heidorn who gave the right web address). [...] 2060 103 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Mon, 8 May 2000 11:24:29 -0500585_ISO-8859-1 Hi Max, Good to hear from you! Ref. your following statement, all in good fun:

" . . . an application using small code tables that are heavenly referenced by application ."

I would normally defer all tuning efforts and let God sort it out.

Very Best Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you [...] 2164 25 100_UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Mon, 8 May 2000 10:44:03 -0500464_iso-8859-1 From a DB2 command window when I do the following select: select contract_nbr, nullif(last_extract_dt, date('0001-01-01')) from dbtest.edi_sale_reporting

I get the following error: SQL0332N There is no available conversion for the source code page target code page "1252". Reason code "1". SQLSTATE=57017.

Any ideas?

Also, I tried changing my DB2CODEPAGE to 437 and I received the same error except instead of 1252 it had 437. [...] 2190 29 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Mon, 8 May 2000 11:55:54 -0500357_US-ASCII Rohn, After you stop and start the tablespace / index space. Kurt

>>> Rohn.Solecki@MTS.MB.CA 05/08/00 10:11AM >>> Great discussion ... Question sligthly off the thread.

When you alter SYSTABLESPACE.BPOOL to move the TS to a new buffer pool, when does the change take effect, immediately or after the DB2 subsystem is re-started. [...] 2220 12 55_Re: DB2-L Digest - 7 May 2000 to 8 May 2000 (#2000-135)15_William Buckley15_Bucci21@AOL.COM28_Mon, 8 May 2000 13:10:26 EDT251_US-ASCII

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 2233 41 46_Datajoiner on NT using Control Center function18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Mon, 8 May 2000 13:25:10 -0400553_iso-8859-1 We're using DataJoiner on an NT machine to access our DB2 OS/390 DB2 subsystems. I've been trying to use the 'Control Center' feature that comes with DB2 Connect EE that I have on my desktop to kind of administor the Datajoiner box. (I'm a mainframe DB2/DBA and this is my first venture into the world of NT so please be kind).... Question: Does anyone know of a good 'hardcopy manual' that tells about using this Control Center option?? There seems to be alot of things that you can do as a DBA by using Control Center but when I click [...] 2275 95 50_Re: Datajoiner on NT using Control Center function11_David Ayers24_david.ayers@HIGHMARK.COM30_Mon, 8 May 2000 13:51:08 -0400380_us-ascii Steve, I do not believe the DB2 control center (DB2 UDB 5.x or greater) will work with datajoiner since datajoiner is based on the DB2 common server v2.1 code. Datajoiner does come with an archaic version of the control center called the database director (exec db2dd). This lets you persome of the tasks (e.g. monitoring / backup / restore / catalog visability...) [...] 2371 138 50_Re: Datajoiner on NT using Control Center function23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Mon, 8 May 2000 14:06:54 -0400621_- IBM integrated Data Joiner into UDB V 7 using Federated databases. So I guess control center should work well with it now. We are currently playing with it and looking at replacing datajoiner with UDB ver 7 integrated datajoiner when it becomes GA.

HTH

Sanjay

> -----Original Message----- > From: David Ayers [SMTP:david.ayers@HIGHMARK.COM] > Sent: Monday, May 08, 2000 1:51 PM > To: DB2-L@RYCI.COM > Subject: Re: Datajoiner on NT using Control Center function > > Steve, I do not believe the DB2 control center (DB2 UDB 5.x or greater) > will > work with datajoiner since datajoiner is based [...] 2510 64 104_Re: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error11_Ioana Masek29_Ioana_Masek@AISMAIL.WUSTL.EDU30_Mon, 8 May 2000 13:41:05 -0500291_us-ascii We have DB2 V6.1 and we got the exactly the same error when we tried to use Visual Explain. We called IBM and they recommended us to install UQ35864 PTF. I just got it in the mail and I plan to install it this afternoon. I'll let you know if it fixed the problem or not. Ioana [...] 2575 40 36_Converting V5.1 to V6.1 stored procs11_Robert Jans22_robertjans@HOTMAIL.COM28_Mon, 8 May 2000 18:57:17 GMT542_- I've been having problems posting this, so I'm trying from a different account Robert --------------------------------------- Hello, DB2er's!

Question for those who have installed V6.1 and converted their v5.1 stored procs.

I understand the v6.1 conversion process. It WILL work for some of our stored proc's, the ones that don't use an authid. How have people converted their stored proc's that use authids to v6.1? We have 800+ like this and really don't want to do any more manual process that we need to............. [...] 2616 31 27_32K LOGGING RECORD (DB2 V4)12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM28_Mon, 8 May 2000 12:15:31 PDT526_- Hi folks:



I just want to see if anybody can help me with this question. Here in our shop we have an aplication that uses tablespaces with 32k pages size. My question is how many log records db2 needs to hold a 32k record. I was looking for it in all db2 manual but it hard to find a accurate information about it. I think that db2 must use nine CI's to hold the entire record. The first one is used to hold control information and the next eight CI'S to hold the record information. I would like to hear [...] 2648 98 23_Re: Unix "grep" Command12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV30_Mon, 8 May 2000 15:08:53 -0400443_iso-8859-1 Yep. you're right. I'd forgotten that the extenders were add ons, since I installed them at the same time as the product.

tom

-----Original Message----- From: Ruzeski, Dennis [mailto:dennis.ruzeski@INGRAMMICRO.COM] Sent: Monday, May 08, 2000 12:05 PM To: DB2-L@RYCI.COM Subject: Re: Unix "grep" Command



It's actually an add on product called DB2 Text Extender which eases text search capabilities- [...] 2747 21 31_Re: 32K LOGGING RECORD (DB2 V4)0_31_truman.g.brown@BELLATLANTIC.COM30_Mon, 8 May 2000 15:28:20 -0400555_us-ascii Harry,

Never thought about it but I'll bet a dollar to a donut that it only logs data that's been changed, so it could be anything from a small record to 9 pages, de- pending on the data/CRUD activity (subject to the same rules as 4K pages).

Just another uninformed opinion...

George

================================================ 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. 2769 28 31_Re: 32K LOGGING RECORD (DB2 V4)14_Dean Montevago18_DMonteva@VNSNY.ORG30_Mon, 8 May 2000 15:29:39 -0400299_- Hi, I am setting DB2 V5 with JDBC, When I update SYSIBM.SYSLOCATIONS am I updating it with the name of the DB2 subsystem that I will be connected to via a JDBC call ? Thanks, Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax [...] 2798 79 104_Re: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Mon, 8 May 2000 14:17:39 -0500411_iso-8859-1 Thanks - I'll check to see if I have it on - I did open a PMR with IBM, based on your comments if I don't have it on I'll pull it down.

-----Original Message----- From: Ioana Masek [mailto:Ioana_Masek@AISMAIL.WUSTL.EDU] Sent: Monday, May 08, 2000 1:41 PM To: DB2-L@RYCI.COM Subject: Re: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error [...] 2878 30 33_syspackdep rows - DB2 V5 - OS/39011_Vijay Kumar25_vijay_kumar90@HOTMAIL.COM28_Mon, 8 May 2000 16:18:06 EDT537_- Hello Everyone,

I have an application that does a select from a table using an index DIPALI1X and an insert into the same table. The EXPLAIN shows that this is the only index. When I query the SYSPACKDEP table for this program, I see there are 2 indexes the package is dependent upon, namely, DIPALI1X and DIPALI2X. Please note that the tables has 3 indexes, DIPALI1X, 2X, 3X. The index 1X has 5 columns, 2X has 14 columns, 3X has 16 columns. The index 1X columns are also present in 2X aand 3X but not as leading columns. [...] 2909 172 50_Re: Datajoiner on NT using Control Center function13_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Mon, 8 May 2000 15:31:25 CDT455_- DataJoiner is not fully integrated into v7.x. I believe with base v7.x you can only do select at the target data sources. Execution of DML statements at remote data source will be added later to v7.



Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|************** [...] 3082 85 23_Re: Unix "grep" Command12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Mon, 8 May 2000 13:45:13 -0700684_iso-8859-1 Dale:

-----Original Message----- From: Dale Miller [mailto:dmille@TRADESERVICE.COM] Sent: Friday, May 05, 2000 1:36 PM To: DB2-L@RYCI.COM Subject: Re: Unix "grep" Command



Wayne, We market a package to the electical distribution industry and for competitve purposes we need to offer a relational database option. We are also porting to SQLServer on NT, and may look at the new database offering from Oracle, when we accomplish the above. Some of the reasons would be allowing users to take advantage of more modern tools for customization and adhoc reporting, and to take advantage of stored procedures etc. and recovery features to approach 24x7 [...] 3168 55 104_Re: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error13_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Mon, 8 May 2000 15:50:47 CDT749_- use DB2CODEPAGE=850



Umair Hussain******************************** DBA Consultant * DB2 UDB, Oracle, Sybase, DataJoiner * IBM Certified Solution Expert - DB2 UDB DBA * IBM Certified AIX System Administrator * ********|All Disclaimers Apply|**************



>From: "Martin, Paul" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con > nect V6 on AI) I get an ODBC error >Date: Mon, 8 May 2000 10:44:03 -0500 > >From a DB2 command window when I do the following select: >select contract_nbr, nullif(last_extract_dt, date('0001-01-01')) from >dbtest.edi_sale_reporting > >I get the following [...] 3224 77 50_Re: Datajoiner on NT using Control Center function0_23_sjtoeniskoetter@AEP.COM30_Mon, 8 May 2000 16:56:18 -0400496_us-ascii Steve,

When DataJoiner refers to DATABASE 2 Administration Guide or any other DATABASE 2 books it is talking about the DB2 version 2 books, since DataJoiner is built off of DB2 version 2. Can you order them from IBM or somewhere? I don't know. We still have our copies from when our shop ran DB2 version 2 so I use them when needed. You can probably get away with using the version 5 or version 6 manuals since a lot of the basic commands and information didn't change much. [...] 3302 31 44_Differences/Benefits Between Visual Explain?11_James Drewe20_James.Drewe@AEXP.COM30_Mon, 8 May 2000 14:17:17 -0700406_- Dear Listserv Members

I was wondering if any of you have experience with Visual Explain on both Windows 98 and NT.

I heard at a recent conference that Visual Explain on NT is better, but our resident IBM'er says there is no difference between the code base on either OS. Could there be a benefit of running on NT because the product is memory intensive and NT can address more memory? [...] 3334 54 37_Re: syspackdep rows - DB2 V5 - OS/39017_Linda F. Claussen18_lindafc@NETINS.NET30_Mon, 8 May 2000 17:19:56 -0500710_ISO-8859-1 Vijay,

Inserts use the CLUSTER Index to perform insertions. Is DIPALI2X the clustering Index?

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



---------- From: Vijay Kumar To: DB2-L@RYCI.COM Subject: syspackdep rows - DB2 V5 - OS/390 Date: Monday, May 08, 2000 3:18 PM

Hello Everyone,

I have an application that does a select from a table using an index DIPALI1X and an insert into the same table. The EXPLAIN shows that this is the only index. When I query the SYSPACKDEP table for this program, I see there are 2 indexes the package is [...] 3389 29 26_V5.1 Stored Proc's to v6.111_Robert Jans21_Jans.Robert@AMSTR.COM30_Fri, 5 May 2000 11:20:00 -0600409_- Hello, DB2er's!

Question for those who have installed V6.1 and converted their v5.1 stored procs. I understand the v6.1 conversion process. It WILL work for some of our stored proc's, the ones that don't use an authid. How have people converted their stored proc's that use authids to v6.1? We have 800+ like this and really don't want to do any more manual process that we need to............. [...] 3419 69 37_Re: syspackdep rows - DB2 V5 - OS/39010_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Tue, 9 May 2000 04:11:52 GMT599_us-ascii Hi Vijay, I have found a similar case(with bit of difference) but i was using the partitioned tablespace and in explain that showed one index which was not the partitioning one and when i monitored thru the omegamon i found that partitioning index was also being used.I looked at the explain and found that PAGE_RANGE column was having a value "Y".I thought it was using the partitioning index because of using the selective partition.I didn't check the SYSIBM.SYSPLANDEP but this might be the case as well. I cann't tell you surely because i was using REOPT(VARS) and that might also [...] 3489 106 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING14_Paul A Redhead35_Paul.A.Redhead@TRANSPORT.QLD.GOV.AU30_Tue, 9 May 2000 10:47:08 +1000359_us-ascii Rick, I'll try and address the questions as I see them in your response.

**** >>Hi Paul, >> Thank you very much for your insights. I've tried but cannot find a >>reference for your following statements: >> >>"My understanding for the VDWQT is that if it is hit ALL pages on >>the queue for that pageset are written out." *** [...] 3596 22 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING14_Massimo Scarpa16_mscarpa@CESVE.IT30_Tue, 9 May 2000 08:34:53 +0200519_us-ascii I read so many posts about (V)DWQT theory & practice during this week and for this reason I

think the only thing to say is : 'In God we trust'.....(keeping an eye on Murphy's law).

Sorry, it was an cut & paste error......

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. 3619 69 50_Re: Datajoiner on NT using Control Center function4_IBM116_IBM1@UBIL.COM.TR30_Tue, 9 May 2000 09:42:28 +0300732_- Stephen,

try looking in http://www-4.ibm.com/cgi-bin/db2www/library/pubs.d2w/ (aka DB2 product and service tech library - DB2 publications).

ciao!

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



> -----Original Message----- > From: Whittaker, Stephen [SMTP:stephen.whittaker@CPLC.COM] > Sent: Monday, May 08, 2000 8:25 PM > To: DB2-L@RYCI.COM > Subject: Datajoiner on NT using Control Center function > > We're using DataJoiner on an NT machine to access our DB2 OS/390 DB2 > subsystems. > I've been trying to use the 'Control Center' feature that comes with DB2 > Connect EE that > I have on my desktop to kind of administor the [...] 3689 185 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM28_Tue, 9 May 2000 09:16:51 GMT550_us-ascii Hi Paul and others,

**** >>"I believe that if a set-write page is part of a few pages about to be written but for which the I/O >>has not yet been scheduled has a GETPAGE issued for it by the buffer manager then it is >>actually removed from the queue and used and then a synchronous write is >>performed for it on completion of that 'update'. In this way you will only >>wait for a page if it is actually in the process of being written." **** As far as my conclusion goes for above paragraph, it is not neccessary [...] 3875 53 48_Re: Differences/Benefits Between Visual Explain?13_Martin Kenney25_martin.kenney@RAILINC.COM30_Tue, 9 May 2000 06:54:15 -0400399_us-ascii Is there a visual explain for Windows 98? I checked last week on the IBM free download site and only saw versions for OS/2, Windows 95, and Windows NT. Thanks.







James Drewe on 05/08/2000 05:17:17 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Marty R Kenney/RICC/AAR) [...] 3929 61 36_ERROR QUERYING DB2 UDB FROM MS-QUERY7_Gustavo26_lozano@BANDEIRANTES.COM.BR30_Tue, 9 May 2000 09:34:49 -0300321_Windows-1252 Hi fellows!

I've encoutered an error when trying to query DB2/UDB 6.1 from MS-QUERY 8.00. The message is "very clear": UNKNOWN SOFTWARE EXCEPTION and nothing else... Can anyone help me? Thank you very much.

Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil 3991 30 28_HSM migrating data to level20_20_Carl_Nelson@AICI.COM30_Tue, 9 May 2000 08:32:22 -0500614_us-ascii Members:

We have HSM running in a production and a test subsystem (on the LPAR) migrating DB2 datasets directly to level 2 (tape). We have encountered some resistance to pulling DB2 datasets out of HSM control. I have searched the archives but did not find any discussion on this topic. I also have been reading the "Storage Management for OS/390" redbook for recommended approaches. My instinct suggests this is generally not a good idea particularly for production. Before we get too far into this, I would like to develop some supporting evidence to support the use of or discontinuing the [...] 4022 74 37_Re: syspackdep rows - DB2 V5 - OS/39011_Vijay Kumar25_vijay_kumar90@HOTMAIL.COM28_Tue, 9 May 2000 09:50:14 EDT746_- Thanks Linda and Sanjeev for your explanations. In my case, as Linda said, the index 2X is CLUSTERing index.

Thanks again, Vijay Kumar.



>From: "Linda F. Claussen" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: syspackdep rows - DB2 V5 - OS/390 >Date: Mon, 8 May 2000 17:19:56 -0500 > >Vijay, > >Inserts use the CLUSTER Index to perform insertions. Is DIPALI2X the >clustering Index? > >Linda F. Claussen >Claussen & Associates, Inc >DB2 Consulting and Training >lindafc@netins.net >http://www.netins.net/showcase/lclaussen/ > > >---------- >From: Vijay Kumar >To: DB2-L@RYCI.COM >Subject: syspackdep rows - DB2 V5 - OS/390 [...] 4097 46 33_Re: Question about UQ18604 ( V5).11_Hayden, Lee18_Lee_Hayden@CSX.COM30_Tue, 9 May 2000 10:04:19 -0400531_iso-8859-1 Ted,

At the bottom of the DSNTIJUZ job that is distributed with DB2 there is a little piece of smp/e code that reads in jcl for a "JCLIN". This updates the smp/e zone to track changes for the modules in that jcl and re-assemble, re-link when maintenance is applied. Personally, I do not use this part, but it looks like you have an old one in your smp zone. I think if you run the little smp step that came with v5 job dsntijuz, your smp will be updated to point to sdsnexit. Note that you then will have to [...] 4144 59 37_Re: syspackdep rows - DB2 V5 - OS/39019_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 9 May 2000 10:13:05 -0500623_ISO-8859-1 Hi Vijay, Some very good suggestions thus far -- here's another; you may have several older versions of the PACKAGE on SYSPACKAGE.

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, [...] 4204 70 25_XML for DB2/UDB for OS39012_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Tue, 9 May 2000 11:26:49 -0400279_iso-8859-1 Hello,

Does anyone know when XML will be available on DB2 for OS390?



Thanks, Robert

__________________________________ Reply to: Robert Hall Sr. DB2 DBA

Robert.Hall@OCC.Treas.Gov



4275 87 31_Re: 32K LOGGING RECORD (DB2 V4)13_McDonald, Ken20_Ken_McDonald@BMC.COM30_Tue, 9 May 2000 10:06:57 -0500531_ISO-8859-1 Hi Harbry,

Allow for 10 log pages to be used for a 32K log record... It is feasible that the header information and the first portion of the data is in the middle or toward the end of the first log page, 8 more full pages, and the last of the data spanning onto the 10th page. Taking into account an Update Not In Place with the row moving to a different page, you can potentially have 20 log pages... 10 for the original record being changed into a pointer and 10 more for the insert into the new location. [...] 4363 25 4_JDBC14_Dean Montevago18_DMonteva@VNSNY.ORG30_Tue, 9 May 2000 11:52:43 -0400338_- Hi, I am setting DB2 V5 with JDBC, when someone issues jdbc:db2os390:location, where is the driver db2os390 located and loaded from ? I see the CLI module DSNAOCLI in SDSNLOAD. Is this what gets executed ? Thanks, Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax [...] 4389 20 13_DB2 Authority11_Yu, Shu-Lan16_SYU1@ALLDATA.NET30_Tue, 9 May 2000 11:15:12 -0500353_iso-8859-1 We are in OS/390 DB2 V5. I have SYSCTRL authority and DBADM on a database. However, I cannot create a view with a qualified name that's not my primary ID or secondary ID. In the DB2 Administration Guide, it states that if my current SQL ID has SYSADM or SYSCTRL authority, I can use any qualifier for a view or alias. What am I missing? [...] 4410 53 48_Re: Differences/Benefits Between Visual Explain?14_John P Shipley24_jpshiple@DUKE-ENERGY.COM30_Tue, 9 May 2000 13:07:12 -0400568_us-ascii We use both and have not experienced any differences in output, function or performance. Hope this helps...









James Drewe on 05/08/2000 05:17:17 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John P Shipley/Corp/DukePower) Subject: Differences/Benefits Between Visual Explain?







Dear Listserv Members

I was wondering if any of you have experience with Visual Explain on both Windows 98 and NT. [...] 4464 56 5_DB2-L7_Gustavo26_lozano@BANDEIRANTES.COM.BR30_Tue, 9 May 2000 14:14:02 -0300189_Windows-1252 Fellows:

Is DB2-L online? I'm not receiving messages... Thank you.

Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes São Paulo - Brasil

4521 12 9_List test13_Toppins, Mike19_MToppins@UNIPAC.COM30_Tue, 9 May 2000 13:47:15 -0600323_iso-8859-1 Just a test. Not gotten any messages from the list for a few days now.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4534 122 104_Re: UDB Version 6 on NT reading a table on DB2 OS/390 V5 (via DB2 Con nect V6 on AI) I get an ODBC error11_Ioana Masek29_Ioana_Masek@AISMAIL.WUSTL.EDU30_Tue, 9 May 2000 15:07:00 -0500326_us-ascii Paul, We just applied the latest maintenance (and we're still up and running :-) ), and checked in particular for the suggested ptf (UQ35864) to have it installed. We found out that we're still getting the same error message when we try to use Visual Explain. I'll let you know when we'll fix the problem. Ioana [...] 4657 17 10_DB2 / ISPF14_Dean Montevago18_DMonteva@VNSNY.ORG30_Tue, 9 May 2000 16:53:08 -0400444_- Hi I'm creating a LIBDEF clist for SPUFI. If I have my DB2 load libraries in the linklist, do I have to specify a ISPLLIB allocation ? Sometimes products require this, is DB2 one of them? Thanks, Dean

================================================ 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. 4675 31 21_DB2 UDB NT monitoring12_Wayne Fugere22_fugere_wayne@YAHOO.COM30_Tue, 9 May 2000 14:37:36 -0700377_us-ascii I wanted to know what was recommended to monitor UDB databases running on NT. I want the software to be able to run on a client and monitor the remote UDB server. Some tool that is like Omegamon on the mainframe. I have looked into some CA/Platinum products, but it requires an agent to run, which is only available to run on UNIX. Any help would be appreciated. [...] 4707 88 40_SYSPACKSTMT.STMTNO column size too small0_22_Rohn.Solecki@MTS.MB.CA30_Tue, 9 May 2000 17:01:01 -0500320_iso-8859-1 DB2 V5, OS390

We have a rather large program that we are trying to debug. Our trace tool (Boole & Babbage) logs syspackstmt sql statement numbers but we can't find a match. When we look in the DB2 catalog, SYSPACKSTMT, for the line number, STMTNO, we get zero for the statement we are looking at. [...] 4796 59 48_Re: Differences/Benefits Between Visual Explain?14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM30_Tue, 9 May 2000 17:52:42 -0500400_iso-8859-1 James,

I do not know about Windows 98, but FYI:

For the past year or so, I have been running Visual Explain (V5) on Windows 95, while my Co-worker has been using Windows NT. I am not a heavy user of it, however I have used it on both his PC and mine and recall no problems with either one. So I would expect that if it executes on Win-95, it will execute on Win-98 too. [...] 4856 61 37_Re: syspackdep rows - DB2 V5 - OS/39016_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 9 May 2000 17:28:33 -0400420_iso-8859-1 1 - Page range scan uses the clustering index to determine which partitions to go against 2 - After partitions are selected either the clustering index or the NPI can be used, in which case only the NPI is in explain but there is a dependency on the clustering index -- either at bind time with real data, or at run time with reopt(vars)) 3 - Clustering index also used for INSERTS, not shown in explain [...] 4918 62 30_Re: V5.1 Stored Proc's to v6.116_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 9 May 2000 17:28:35 -0400710_iso-8859-1 Sorry, it is a manual procedure:

If AUTHID used and LUNAME is blank, you must CREATE PROCEDURE AUTHID.abcdef to implements the new security scheme.

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

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Robert Jans > Sent: Friday, May 05, 2000 1:20 PM > To: DB2-L@RYCI.COM > Subject: V5.1 Stored Proc's to v6.1 > > > Hello, DB2er's! > > Question for those who have installed V6.1 and converted their v5.1 stored > procs. I understand the v6.1 conversion process. It [...] 4981 55 48_Re: Differences/Benefits Between Visual Explain?16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 9 May 2000 17:28:37 -0400671_iso-8859-1 It is the same code base. Increased memory on 98 will suffice.

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

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > James Drewe > Sent: Monday, May 08, 2000 5:17 PM > To: DB2-L@RYCI.COM > Subject: Differences/Benefits Between Visual Explain? > > > Dear Listserv Members > > I was wondering if any of you have experience with > Visual Explain on both Windows 98 and NT. > > I heard at a recent conference that Visual Explain on NT > [...] 5037 26 38_How to findout who deleted the records17_ravi kumar hassan18_ravibh@HOTMAIL.COM28_Tue, 9 May 2000 17:50:47 PDT272_- Hi Folks,

In our shop we are using DB2 V4. somebody deleted few records from one of the db2 table. so we need to find who deleted from that table. is there any we can find out who deleted the table or is there any IBM utility to run on the table to findout. [...] 5064 13 14_We up or down?8_Bob Abad16_BobRabad@AOL.COM28_Tue, 9 May 2000 22:19:03 EDT298_US-ASCII Surprised that my in-basket was empty today????

================================================ 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. 5078 130 50_Re: Datajoiner on NT using Control Center function13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM30_Tue, 9 May 2000 08:27:18 +0530530_us-ascii David !! I am interested in some more info on datajoiner. Do u mean to say that Datajoiner will not work with DB2 V5.X as the main server and other databases as Oracle and Sysbase / SQL server ????

We are planning to integrate all the databases and replicate into a single DB2 database. So now the plan is to implement Datajoiner with db2 5.x and then make that as the control database. wont this work ?? visa vis.... can we integrate the same using an Oracle database ?? and replicate from DB2 to Oracle. ?? [...] 5209 27 27_Problem in Data Propagation13_Mayank Sharma33_Mayank.Sharma@POWAIMAIL.LTITL.COM31_Wed, 10 May 2000 10:25:30 +0530328_us-ascii Hi all

I am trying to propagate data to replicate a small table. To do So I have created a table with DATA CAPTURE CHANGES. Now I am trying to insert a record in this table thru an application it returns SQL CODE 947.

I have not DPROP installed on our system and Monitor trace class 6 is already up. [...] 5237 19 27_DB2 Log records recovery !!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 10 May 2000 17:25:39 +0530455_us-ascii Hi !! I have a query ..on recovery . I have a situation where I have not taken any image copy of the tablespace that was created a month ago. I have all the log archives . Can I recover back to 15 days before . I had done a quiesce 15 days ago ?? If I know a particular RBA to which I have to rollback , is it possible to rollback / recover from the active log records without any image copy . if yes what is the procedure. ?? regards Vishy [...] 5257 12 26_Is the list still active ?14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 10 May 2000 14:25:30 +0200265_us-ascii test test test

================================================ 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. 5270 166 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 10 May 2000 07:47:28 -0500564_ISO-8859-1 Hi Paul, Thanks for your valuable observations. I'm not taking "cheap shots" and you or anyone else; I, like you, am just trying to fully understand this issue. I would make the same conclusions as you except for one. Perhaps someone has an update for us? In the manual, and "reading between the lines", I don't think all pages, if there were more than 128, for a particular dataset are written when VDWQT is hit. It appears to me that VDWQT is handled like DWQT. In other words, should a dataset have updated pages equal to or greater than VDWQT, [...] 5437 23 43_References to SDSNLOAD in link-edit SYSLIBs0_29_paul.packham@POSTOFFICE.CO.UK31_Wed, 10 May 2000 13:51:25 +0000552_us-ascii Hi,

Currently we use non-version specific data set high level qualifiers for our DB2 code. We are thinking of moving to using the standard IBM data set names which contain a version specific HLQ. Because we do not change the HLQ between versions we do not currently have to alter the link-edit SYSLIB concatenation in our compile PROCs. I wondered how the change of HLQ was handled in other shops that do use the standard IBM names (hopefully without changing hard coded values for SDSNLOAD in every compile PROC when we upgrade). [...] 5461 13 17_Test - Ignore msg14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 10 May 2000 10:03:10 -0400261_ISO-8859-1 are we up?

===============================================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. 5475 33 22_QUERY FOR MISSING ID'S0_20_ddlusk@HOUSEHOLD.COM31_Wed, 10 May 2000 09:15:43 -0500193_us-ascii HI ON DB2V5/OS390 We have a table with an id as the key I'm trying to get a listing of all of the id's that are not being used (i.e gaps) the current query that I using now is:

5509 88 23_Re: Unix "grep" Command22_Lindsay, William (GES)24_WLindsay@EXCHANGE.ML.COM31_Wed, 10 May 2000 12:13:30 -0400492_iso-8859-1 We use DB2 UDB running on AIX, and it has been deemed the preferred RDBMS from a Firm-Wide perspective. Regarding GREP, would using SQL with "Like ARG%" be out of the question as a replacement for CALL SYSTEM "grep ARG" ?

Bill Lindsay Benefits and Investment Solutions 401(k) Distribution



-----Original Message----- From: Dale Miller [mailto:dmille@TRADESERVICE.COM] Sent: Friday, May 05, 2000 4:36 PM To: DB2-L@RYCI.COM Subject: Re: Unix "grep" Command [...] 5598 79 25_DB2 for Quality assurance6_monica19_monica@BANEB.COM.BR30_Tue, 9 May 2000 10:11:31 -0300334_iso-8859-1 Hi, all,

We are implementing a new DB2 subystem for Quality assurance. This subsystem intend to be identical to our production environment (in terms of logical data), so we have to have data up-to-date data. We are doing unload data (from our production environment) / load data (onto our quality environment). [...] 5678 51 45_See Quest Software's New DB2 Products at IDUG13_Jim Wankowski23_Jim.Wankowski@QUEST.COM30_Tue, 9 May 2000 15:35:48 -0700368_iso-8859-1 Attention IDUG attendees, stop by booth #419 at the IDUG North American Conference in Dallas, May 14-18, to get a sneak preview of Quest Software's integrated database management solutions for DB2 UDB. You'll see firsthand how Quest combines the essential components needed to obtain optimal database performance in a smart integrated suite, covering: [...] 5730 47 36_Log only recovery of old static data0_24_Mike_Jarrett@MANDG.CO.UK31_Wed, 10 May 2000 10:53:16 +0000461_us-ascii Hi list, Please could someone answer a disaster recovery question for me?

Suppose, on a Friday, I restore a big tablespace partition, outside the control of DB2, from a DASD volume dump which was taken last weekend. Then, I restore the logs, catalog and BSDS from a DFDSS backup which was taken only yesterday. Suppose also that, unbeknown to me, there weren't actually any changes to the partition since my weekly volume dumps were taken. [...] 5778 36 48_SQL tuning tool for UDB DB2 for Windows and Unix11_Bruce Allen25_bruce.allen@ATTGLOBAL.NET31_Wed, 10 May 2000 23:12:24 +1000311_iso-8859-1 I would like to invite you to test a new SQL tuning tool that we have developed using DB2 on the Windows NT, AIX and Sun platforms.

What will it cost you? Zero dollars, but obviously time to run it in your environment, and we would appreciate if you could let us know how well it worked. [...] 5815 59 32_Re: HSM migrating data to level20_22_Rohn.Solecki@MTS.MB.CA31_Wed, 10 May 2000 11:33:05 -0500447_us-ascii We allow HSM to archive DB2 datasets in Development, but not in production (non DB2 production datasets are HSM archived).

In dev. we have found that DB2 will not use an archived Tablespace, but will recall a HSM archived Indexspace.

DB2 V5 for OS390









Carl_Nelson@AICI.COM@RYCI.COM> on 2000/05/09 08:32:22 AM

Please respond to DB2 Data Base Discussion List [...] 5875 64 29_Re: DB2 for Quality assurance12_HEPP SHERY C17_schepp@SRPNET.COM31_Wed, 10 May 2000 09:55:32 -0700329_ISO-8859-1 Monica- Assuming you're on db2 os/390 and if your data structures are identical you could use the dsn1copy to lay down production image copies into your qa database. This process is quicker than unloads/loads- but does have a few gotchas. Let me know if you want additional information on using the dsn1copy. HTH [...] 5940 185 50_Re: Datajoiner on NT using Control Center function11_David Ayers24_david.ayers@HIGHMARK.COM31_Wed, 10 May 2000 12:57:12 -0400432_us-ascii Vishy, what you are trying to do will work. What i had stated is that datajoiner is based on the db2 common server code. The control center will not work do to differences between db2 udb 5 and db2 cs v2 (datajoiner). Datajoiner is a key player in ibm heterogeneous replication strategy. Datajoiner and DB2 CS have an old old old version of the control center called database director (exec command db2dd to start it) [...] 6126 21 27_Pager or Email Notification12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Wed, 10 May 2000 10:10:34 -0700313_iso-8859-1 Hi List!

Any idea what software you would use to send DB2 error messages to a pager or email address from within a COBOL program on OS/390? Am familiar with some options in the Unix/NT environment, but we have a need to look at this in our legacy applications.

Any help appreciated! [...] 6148 49 17_Re: DB2 Authority13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 10 May 2000 10:22:42 -0700445_iso-8859-1 It surprises me that Admin guide says that SYSCTRL can name any qualifier for view. SYSCTRL authid , by default does not have even a 'Select' authority on existing tables ; so how can it create a view ???

I believe what it means is that if the Userid with SYSCTRL has 'created' the database and table in it (because SYSCTRL has CREATEDBA authority) , only then can it name anyone as the qualifier for views on that table. [...] 6198 63 36_ERROR QUERYING DB2 UDB FROM MS-QUERY7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Wed, 10 May 2000 14:20:20 -0300339_Windows-1252 Hi fellows!

I've encoutered an error when trying to query DB2/UDB 6.1 from MS-QUERY 8.00. The message is "very clear": UNKNOWN SOFTWARE EXCEPTION and nothing else... Any known issues? Can anyone help me? Thank you very much.

Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil 6262 80 40_Re: Log only recovery of old static data13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 10 May 2000 10:27:59 -0700693_us-ascii I believe it know it by scanning SYSLGRNX. Thanks.

Ashish.

-----Original Message----- From: Mike_Jarrett@MANDG.CO.UK [SMTP:Mike_Jarrett@MANDG.CO.UK] Sent: Wednesday, May 10, 2000 3:53 AM To: DB2-L@RYCI.COM Subject: Log only recovery of old static data

Hi list, Please could someone answer a disaster recovery question for me?

Suppose, on a Friday, I restore a big tablespace partition, outside the control of DB2, from a DASD volume dump which was taken last weekend. Then, I restore the logs, catalog and BSDS from a DFDSS backup which was taken only yesterday. Suppose also that, unbeknown to me, there weren't actually any changes to the partition [...] 6343 15 23_Please remove from list15_Andrew W. Brown15_awbrown@GTE.NET31_Wed, 10 May 2000 12:19:19 -0500313_us-ascii Please remove my ID from you lists.

Thanks Andrew Brown

================================================ 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. 6359 62 32_Re: HSM migrating data to level219_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Wed, 10 May 2000 10:42:43 -0700460_- We do have HSM turned on for the testing DB2 pool, but not production - the delay in retrieving objects when it's an online transaction calling for it wasn't acceptable.

Then to, we have discovered that DB2 will frequently have problems with a recalled object (reason 00C90094 - Explanation: A data set is in a state that is different from what DB2 expects. Possible causes are: A data set was deleted and redefined without DB2's knowledge etc.) [...] 6422 26 26_Re: QUERY FOR MISSING ID'S10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Wed, 10 May 2000 12:17:56 -0500343_us-ascii It seems to me it would be easier to compare it to a table that was populated with all possible values 3 thru 650000. Build a 1 row table, populate it and then you can do a bit more with your select where not exists maybe.

I've usually found that doing addition in a query has historically been a poor performance option. [...] 6449 19 31_Re: Pager or Email Notification10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Wed, 10 May 2000 12:24:06 -0500329_us-ascii We used AFOPER to grab messages from SYSLOG (DB2*MSTR) & email us. There was also a Heat ticket option that opened up a problem ticket upon certain conditions, and HEAT sev 1 WILL page. Maybe our solution was a combination of both, but I'm pretty sure most automation packages could work out the paging issue also. [...] 6469 62 42_Re: How to findout who deleted the records13_McDonald, Ken20_Ken_McDonald@BMC.COM31_Wed, 10 May 2000 12:55:03 -0500677_ISO-8859-1 Hi Ravi,

Using DSN1LOGP, print log records for your range (STARTRBA(xxxx) ENDRBA(xxxx)) and tablespace in question (DBID(hex dbid) OBID(hex psid of space)). The DELETE records will be associated with a URID: here 0003F34E8E2A URID(0003F34BDAE8) DBID(012B) OBID(0029)

You then use DSN1LOGP to print the BEGIN UR record associated with the URID above. The BEGIN UR has the AUTHID, PLAN NAME, Correlation ID (i.e. jobname, tsoid) and other information associated with the related DM records in that unit of recovery. You can see this information in the eyecatcher portion of the BEGIN UR DSN1LOGP print and/or map the record using DSNMACS(DSNDQJ00). [...] 6532 91 13_Why the -111?0_18_damcon2@US.IBM.COM31_Wed, 10 May 2000 13:55:23 -0400383_us-ascii Hello all,

I'm looking for some insight into a SQL perplexity. The environment is DB2 V5 (production) and V6 (development) for OS/390.

The following query gives a -111 (a column function does not include a function name) in both environments:

SELECT X.COL1 FROM ( SELECT SUM(Y.COL1) AS COL1 FROM ( SELECT 1 AS COL1 FROM DAMCON2.TESTT ) AS Y ) AS X [...] 6624 52 31_Re: DB2 Log records recovery !!15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 10 May 2000 13:03:52 -0500481_ISO-8859-1 I don't know of a way to do this with the standard DB2 utilities unless you have some sort of backup (image copy, pack dump, whatever) before the target point in time.

But if you have BMC RECOVER PLUS for DB2*, you can use the BACKOUT feature to undo all updates since the target point in time. You can't back through LOAD or REORG events and you might not be able to back through a segmented mass delete (if the data pages were re-used and DCC was not on). [...] 6677 80 48_Re: Differences/Benefits Between Visual Explain?12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 10 May 2000 11:11:38 -0700581_us-ascii The windows 95 version runs just fine on Windows 98. I have been using it for some time. --- Martin Kenney wrote: > Is there a visual explain for Windows 98? I checked > last week on the IBM free > download site and > only saw versions for OS/2, Windows 95, and Windows > NT. Thanks. > > > > > James Drewe on 05/08/2000 > 05:17:17 PM > > Please respond to DB2 Data Base Discussion List > > > To: DB2-L@RYCI.COM > cc: (bcc: Marty R Kenney/RICC/AAR) > > Subject: Differences/Benefits Between Visual > [...] 6758 69 26_Re: QUERY FOR MISSING ID'S14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 10 May 2000 14:14:50 -0400413_iso-8859-1 You can create a table with id as the only column and populate it with all possible values in the range (3 to 650003). You can use a spreadsheet or REXX or some scripting tool to do this. You can then run the following query to find the gaps:

select a.id from (select x.id, y.emplr_id from idtable x left outer join testdb.cust_emplr y on x.id = y.emplr_id ) as a where a.emplr_id is null; [...] 6828 44 31_Re: Pager or Email Notification16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM31_Wed, 10 May 2000 14:18:58 -0400726_us-ascii I've been reading about SMTP in the TCP/IP for MVS manuals, but we haven't implemented anything yet. Here's a link to a relevant chapter at IBM's BookManager site: http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/EZAA2003/1%2e4

There are also sample CICS programs that use SMTP in CICS SupportPacs. Here's a link to the CICS SupportPac page: http://www-4.ibm.com/software/ts/cics/txppacs/



> -----Original Message----- > From: Kline, Wayne [SMTP:wayne.kline@INGRAMMICRO.COM] > Sent: Wednesday, May 10, 2000 1:11 PM > To: DB2-L@RYCI.COM > Subject: Pager or Email Notification > > Hi List! > > Any idea what software you would use to send DB2 error messages to a pager > or email address [...] 6873 72 32_Re: HSM migrating data to level212_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 10 May 2000 11:23:24 -0700359_us-ascii I've had a number of clients with them both ways, some HSM and nothing HSM. Generally the argument against HSM is time to recall from level 2 is unacceptable. It does cause the first user of the dataset to wait a lengthy period of time. I've found that if level 2 is on a VTS system, the waits aren't too bad, generally less than 10-15 seconds. [...] 6946 81 17_Re: DB2 Authority13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 10 May 2000 13:23:59 -0500568_iso-8859-1 Not believing that this was really in the Admin guide, I went and looked it up -- you're correct that this does say SYSCNTRL can create views with any qualifier... "If your current SQL ID ... has SYSADM or SYSCTRL authority, you can also use any qualifier for a view or alias". I was also surprised to see this since it goes against everything I had seen in the past. From looking a little closer it looks like this is technically correct, but also a little misleading. The SQL Reference addresses this in a little more detail (under "CREATE VIEW")... [...] 7028 54 26_order by clause (DB2 V5.1)10_Derek Lund22_derek.lund@UTORONTO.CA31_Wed, 10 May 2000 14:32:01 -0400319_US-ASCII I have run the following query successfully in DB2 V5.1 in both QMF and DSNTEP2

select col1 from T1 order by col2

(col2 is a column on T1 table) The SQL softcopy manual seems to indicate that this is allowed in DB2 V5.1 (while the hardcopy version that we have seems to indicate otherwise). [...] 7083 43 14_Re: DB2 / ISPF16_Michael McCarthy18_mmccarthy@DTCC.COM31_Wed, 10 May 2000 14:41:46 -0400607_us-ascii Dean,

you do not need to allocate the DB2 load libs if they are in the linklist,

-Mike.









Dean Montevago on 05/09/2000 04:53:08 PM

Please respond to DB2 Data Base Discussion List

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







Hi I'm creating a LIBDEF clist for SPUFI. If I have my DB2 load libraries in the linklist, do I have to specify a ISPLLIB allocation ? Sometimes products require this, is DB2 one of them? Thanks, Dean [...] 7127 67 34_DB2 Connect to MVS DB2 V.5 problem12_Dudley Moore16_dumoore@NMSU.EDU31_Wed, 10 May 2000 10:53:44 -0600360_us-ascii Hello everybody,

I have a problem with a new connection using the DB2 Connect Enterprise Gateway on a AIX V4.3.x to MVS DB2 V.5. We have connections to our DB2 production and development subsystems working correctly. I added LU entries SMIT to connect with our MVS DB2 test subsystem and am receiving the following msg in the db2diag.log: [...] 7195 92 32_Re: HSM migrating data to level214_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Wed, 10 May 2000 13:49:13 -0500341_iso-8859-1 Not to quibble, but programmer time is pretty expensive too.... And as much pressure as most programming staffs are under to produce "RIGHT NOW", waiting (even 15 seconds) for each of however many datasets needed is an unnecessary burden. Decent response time is just one of the many tools programmers need to do their jobs. [...] 7288 60 14_Re: DB2 / ISPF14_Dean Montevago18_DMonteva@VNSNY.ORG31_Wed, 10 May 2000 14:49:04 -0400580_- My first reply on the DB2-List. I thought I was black listed or something !!

Thanks Mike.

> -----Original Message----- > From: Michael McCarthy [SMTP:mmccarthy@DTCC.COM] > Sent: Wednesday, May 10, 2000 2:42 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 / ISPF > > Dean, > > you do not need to allocate the DB2 load libs if they are in the > linklist, > > -Mike. > > > > > > Dean Montevago on 05/09/2000 04:53:08 PM > > Please respond to DB2 Data Base Discussion List > > To: DB2-L@RYCI.COM > cc: (bcc: Michael McCarthy/DTC) [...] 7349 81 48_Re: Differences/Benefits Between Visual Explain?19_Lisa Westcott-Dryer29_Lisa_Westcott-Dryer@AMWAY.COM31_Wed, 10 May 2000 14:56:13 -0400561_us-ascii I use it on Win 95 and have not had it lock me up. (yet)

Lisa









John P Shipley @RYCI.COM> on 05/09/2000 01:07:12 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Differences/Benefits Between Visual Explain?



We use both and have not experienced any differences in output, function or performance. Hope this helps... [...] 7431 96 30_Re: order by clause (DB2 V5.1)0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 10 May 2000 14:03:20 -0500646_us-ascii Eliminating the -208 error in V5 was a retro fit fix via an apar

see V5 APAR list at http://www-4.ibm.com/software/data/db2/os390/v5apar.html APAR NUMBER: PQ34118 RESOLVED AS: ENHANCEMENT REQUEST

ABSTRACT: PQ34118: QMF QBE MSGDSQ85150 AFTER INSTALLING DB2 APAR



ORIGINATING DETAILS: DB2 apar removes the SQL restriction that a column in the ORDERBY clause should also be present in the SELECT list. When using QMF QBE to construct a query using this functionality message DSQ85150 is returned. Before these SQL queries ended with sqlcode -208 (SQLCODE208) [...] 7528 22 22_ProEdit vs. RC/Update?10_Steve Gold15_steve_g@USA.COM31_Wed, 10 May 2000 15:14:13 -0400558_us-ascii I have a client that has to migrate off of ProEdit due to lack of support for DB2 6.1.

What features are found in ProEdit that are NOT found in RC/Update?

Thanks

______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

================================================ 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. 7551 82 38_Re: DB2 Connect to MVS DB2 V.5 problem13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 10 May 2000 14:43:33 -0500575_US-ASCII Dudley, Does the Operating system from the Control Center show up as MVS/ESA and type DRDA ? If not try adding OSTYPE MVS when cataloging the node. HTH Kurt



>>> dumoore@NMSU.EDU 05/10/00 11:53AeM >>> Hello everybody,

I have a problem with a new connection using the DB2 Connect Enterprise Gateway on a AIX V4.3.x to MVS DB2 V.5. We have connections to our DB2 production and development subsystems working correctly. I added LU entries SMIT to connect with our MVS DB2 test subsystem and am receiving the following msg in the db2diag.log: [...] 7634 55 31_Re: DB2 Log records recovery !!19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 10 May 2000 14:44:16 -0500430_ISO-8859-1 Vishy, In a word, I think yes (if you got all the archives, including the one when the tablespace was created, to the point you wish to recover). However, getting there won't be easy. First find a checkpoint RBA closest to the point you wish, then do a RECOVER to that RBA. If there was an inflight UR at this point, data integrity becomes involved. Finding a checkpoint would probably start by scanning the BSDS. [...] 7690 59 31_Re: Pager or Email Notification14_Dean Montevago18_DMonteva@VNSNY.ORG31_Wed, 10 May 2000 15:52:49 -0400675_- Yes. SMTP is a viable option. You can programmatically build the SMTP statements to notify users. It's a little cryptic but it works.

> -----Original Message----- > From: Swinski, Kenneth [SMTP:KSwinski@INTERNAL.MASSMUTUAL.COM] > Sent: Wednesday, May 10, 2000 2:19 PM > To: DB2-L@RYCI.COM > Subject: Re: Pager or Email Notification > > I've been reading about SMTP in the TCP/IP for MVS manuals, but we haven't > implemented anything yet. Here's a link to a relevant chapter at IBM's > BookManager site: > http://www.s390.ibm.com/bookmgr-cgi/bookmgr.cmd/BOOKS/EZAA2003/1%2e4 > > There are also sample CICS programs that use SMTP in CICS SupportPacs. > Here's a [...] 7750 75 40_Re: Log only recovery of old static data4_IBM116_IBM1@UBIL.COM.TR31_Wed, 10 May 2000 22:57:56 +0300668_- as far as I know, DB2 will scan all the logs until its own last "sync" point...

ciao!

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



> -----Original Message----- > From: Mike_Jarrett@MANDG.CO.UK [SMTP:Mike_Jarrett@MANDG.CO.UK] > Sent: Wednesday, May 10, 2000 1:53 PM > To: DB2-L@RYCI.COM > Subject: Log only recovery of old static data > > Hi list, > Please could someone answer a disaster recovery question for me? > > Suppose, on a Friday, I restore a big tablespace partition, outside the > control of DB2, from a DASD volume dump which was taken last weekend. > Then, [...] 7826 76 31_Re: Pager or Email Notification10_Ruth Blake15_rblake3@CSC.COM31_Wed, 10 May 2000 15:02:42 -0500513_us-ascii If you get SMTP (email) option working from a COBOL program at your site, you could email the desired page text to a paging service. For example, quoting from METROCALL's website (www.metrocall.com): ---- Callers may access Word Pagers using: ... any internet e-mail service can send a message to a Metrocall word pager, using the following addressing scheme: "=ten digit pager #@page.metrocall.com". ---- We don't have this type of paging implemented -- I'm just speculating on a solution for you. [...] 7903 83 30_Re: order by clause (DB2 V5.1)4_IBM116_IBM1@UBIL.COM.TR31_Wed, 10 May 2000 23:06:07 +0300654_- derek,

the restriction for QMF, on columns in the order by clause was eliminated through APAR PQ23778/PQ34118.

ciao!

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



> -----Original Message----- > From: Derek Lund [SMTP:derek.lund@UTORONTO.CA] > Sent: Wednesday, May 10, 2000 9:32 PM > To: DB2-L@RYCI.COM > Subject: order by clause (DB2 V5.1) > > I have run the following query successfully in DB2 V5.1 > in both QMF and DSNTEP2 > > select col1 from T1 > order by col2 > > (col2 is a column on T1 table) > The SQL softcopy manual seems to indicate that [...] 7987 134 17_Re: Why the -111?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 10 May 2000 16:07:49 -0400409_us-ascii Jay

I have noticed too many of those syntax bugs in DB2 using nested table expressions. Many we have reported to IBM.

In your case it is a definite bug. But if you include a column function for the outer table expression then things would work. Below is example -

SELECT SUM(X.COL1) FROM ( SELECT SUM(Y.COL1) AS COL1 FROM ( SELECT 1 AS COL1 FROM DAMCON2.TESTT ) AS Y ) AS X [...] 8122 58 25_Re: DB2 UDB NT monitoring0_15_leon@CA.IBM.COM31_Wed, 10 May 2000 16:01:40 -0400387_us-ascii Have you tried using DB2 Control Center that comes as part of the DB2 UDB product? What about Windows NT Performance Monitor which is part of the Windows NT operating system? Both are free and are probably already installed on your machine. I am not saying that these are in the same class as Omegamon but you should give then a try just to see how far they will take you. [...] 8181 92 14_Re: DB2 / ISPF20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 10 May 2000 16:15:01 -0400323_us-ascii It happened to me many times. If you didn't get the reply then assume one of the following -

- Questions was too tough - Questions was too easy - The guy who knew the answer is busy with production problems so didn't check his DB2-L folder - One fine day some would reply - Roger Miller is out of town [...] 8274 95 31_Re: Pager or Email Notification12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM31_Wed, 10 May 2000 13:16:34 -0700680_iso-8859-1 Thanks to all respondents! Looks like I have some homework to do. But SMTP sounds like the way to go.

Wayne

-----Original Message----- From: Ruth Blake [mailto:rblake3@CSC.COM] Sent: Wednesday, May 10, 2000 1:03 PM To: DB2-L@RYCI.COM Subject: Re: Pager or Email Notification



If you get SMTP (email) option working from a COBOL program at your site, you could email the desired page text to a paging service. For example, quoting from METROCALL's website (www.metrocall.com): ---- Callers may access Word Pagers using: ... any internet e-mail service can send a message to a Metrocall word pager, using the following addressing scheme: [...] 8370 89 31_Re: DB2 Log records recovery !!4_IBM116_IBM1@UBIL.COM.TR31_Wed, 10 May 2000 23:21:08 +0300406_- Vishy,

you can do recovery from log, to a particular RBA or PIT. Recovery from log is a very lengthy and time consuming process, if you are on v 5, look in administration guide, chapter entitled "Recovery Method: roll-forward recovery".

good reading to you!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it [...] 8460 29 30_Re: order by clause (DB2 V5.1)10_Derek Lund22_derek.lund@UTORONTO.CA31_Wed, 10 May 2000 16:20:28 -0400476_US-ASCII Thank you for the information.

On Wed, 10 May 2000 14:03:20 -0500 Rohn.Solecki@MTS.MB.CA wrote:

> Eliminating the -208 error in V5 was a retro fit fix via an apar > > see V5 APAR list at http://www-4.ibm.com/software/data/db2/os390/v5apar.html > > APAR NUMBER: PQ34118 RESOLVED AS: ENHANCEMENT REQUEST >

---------------------- Derek Lund Manager, Technical Services Student Information Systems University of Toronto Ph (416) 946-3301 [...] 8490 22 10_BMC option23_Trivedi, Kaushal J, IOG17_kjtrivedi@ATT.COM31_Wed, 10 May 2000 16:22:19 -0400271_iso-8859-1 Hi All, I just wanted to throw this in as I couldn't find it, We have to load data from a flat file to a table, and one of the date fields is being generated as a julian date , does BMC have any option to convert it to a regular DB2 date while loading .? [...] 8513 25 31_Re: Pager or Email Notification11_Joe Bitetto31_joseph.bitetto@US.PWCGLOBAL.COM31_Wed, 10 May 2000 15:13:03 -0500545_ISO-8859-1 If your shop is like ours and you don’t have SMTP running on your mainframe, you may want to try this. I usually use this method from TSO batch IKJEFT01 but you probably can call the REXX program from a Cobol program. All you need to do is: 1) On your Unix box write a shell script issuing a “mailx” command to your beeper address or Email address. You can include a shell variable to pass the DB2 error message. 2) Then create a REXX program that issues a TCP/IP “REXEC” command to execute your script and pass parameters. (You [...] 8539 24 41_Extracting data in comma delimited format10_John Routh25_John_Routh@CANADALIFE.COM31_Wed, 10 May 2000 16:19:13 -0400427_us-ascii Hello List:

I want to extract data from DB2 so that every column is delimited with a comma. This is needed so that it can be loaded into an Oracle database. I have found out that Platinum Fast Unload and IBM's High Performance Unload tools can do this but I don't have access to either tool. Craig Mullin's Developer's Guide (3rd edition) mentions that DSNTIAUL can do this (p.902) but it doesn't say how. [...] 8564 26 35_UDB Version 6 SAMPLE Database on NT13_Scott Goodell22_Scott.Goodell@WCOM.COM31_Wed, 10 May 2000 15:30:14 -0500564_us-ascii I have installed UDB V6 on an NT machine and all went well. I have defined a USER without NT admin rights into the SYSADM group and updated DBM CFG. According to the manuals a USER needs only SYSADM authority to run the db2stop, db2start and db2sampl commands. The user signs on and can create databases, tables and so on. When he runs the db2sampl command he gets an error saying he is not authorized for that command. Interesting enough the message indicates user "" is not authorized. This user can create the sample database and tables in it but [...] 8591 18 31_Re: Pager or Email Notification26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 10 May 2000 15:38:42 -0500522_- We,re testing a similar model now. They're so fancy that can take pages, eMail, or voice phone messages. Don't know if it's just us or the service but there seems to be more dead spots than regular beepers. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ 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. 8610 54 45_Re: Extracting data in comma delimited format13_Keith Gilbert17_kgilbert@CSA1.COM31_Wed, 10 May 2000 15:40:31 -0500516_iso-8859-1 John,

If you have Access and ODBC on your PC you can link to the mainframe tables through Access and then export the tables from Access in comma delimited format. It's slow but it is a good poor man's solution.



Keith Gilbert DBA Central Service Association Tupelo, MS





-----Original Message----- From: John Routh [mailto:John_Routh@CANADALIFE.COM] Sent: Wednesday, May 10, 2000 3:19 PM To: DB2-L@RYCI.COM Subject: Extracting data in comma delimited format [...] 8665 53 45_Re: Extracting data in comma delimited format17_Patricia Candella21_pcandella@METLIFE.COM31_Wed, 10 May 2000 16:41:37 -0400302_us-ascii John, Using dsntiaul, you can code an sql statement where you select a ',' after each column. You will need to include "parms('sql')" in your run statement. You might want to code the ',' in a substr so that you avoid getting variable lengh columns in your output ==> substr(',',1,1).... [...] 8719 45 45_Re: Extracting data in comma delimited format12_Rich Smrcina19_rsmrcina@EXECPC.COM31_Wed, 10 May 2000 15:32:51 -0500565_us-ascii QMF for Windows is another alternative, if you have it. There is a 60-day free trial available from www.rocketsoftware.com.

John Routh wrote: > > Hello List: > > I want to extract data from DB2 so that every column is delimited with a comma. > This is needed so that it can be loaded into an Oracle database. I have found > out that Platinum Fast Unload and IBM's High Performance Unload tools can do > this but I don't have access to either tool. Craig Mullin's Developer's Guide > (3rd edition) mentions that DSNTIAUL can do this (p.902) but [...] 8765 53 45_Re: Extracting data in comma delimited format14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Wed, 10 May 2000 13:48:26 -0700392_iso-8859-1 John, To do this with DSNTIAUL, you will need to run the program with PARM='SQL' specified then you could use the following SQL statement

SELECT a, ',' ,b, ',' ,c, ',', etc from mytable

This will put the literal "," between each column printed out. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 8819 27 14_DB07 Workfiles12_Dan Lohmeier26_lohmeier.dan@PRINCIPAL.COM31_Wed, 10 May 2000 15:48:20 -0500324_- We are looking for creative ways to control usage of 4K workfiles in DB07. CICS activity does not like it when dynamic ad-hoc SQL chew up the space and cause CICS transactions to take resource unavailable SQLCODES. Has anyone come up with an effective way to manage access to workfiles using one of these strategies: [...] 8847 42 14_Re: BMC option11_Burch, Todd18_Todd_Burch@BMC.COM31_Wed, 10 May 2000 15:55:37 -0500385_ISO-8859-1 Yes, see pages 3.89 for LoadPlus V4.3 and the table 3-11 on page 3-90 of the Reference.

If your julian format is yyddd, use DATE-3 EXTERNAL. If yyyyddd, use DATE-3E EXTERNAL.

Todd Burch.

-----Original Message----- From: Trivedi, Kaushal J, IOG [mailto:kjtrivedi@ATT.COM] Sent: Wednesday, May 10, 2000 3:22 PM To: DB2-L@RYCI.COM Subject: BMC option [...] 8890 126 26_Re: ProEdit vs. RC/Update?15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Wed, 10 May 2000 17:14:29 -0400638_- Can you elaborate on the "doesn't work" for V6.1? What didn't work and what kind of support was missing?

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Steve Gold [SMTP:steve_g@USA.COM] > Sent: Wednesday, May 10, 2000 3:14 PM > To: DB2-L@RYCI.COM > Subject: [DB2-L] ProEdit vs. RC/Update? > > I have a client that has to migrate off of ProEdit due to lack of support > for DB2 6.1. > > What features are found in ProEdit that are NOT found in RC/Update? > > Thanks > > ______________________________________________ > FREE Personalized Email at Mail.com [...] 9017 16 29_Accessing DB2 (OS390) from OE15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Wed, 10 May 2000 17:44:42 -0400338_us-ascii How does one access DB2 (running on os/390) from an OE app running on the same machine?

================================================ 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. 9034 25 18_Re: DB07 Workfiles0_17_JTonchick@AOL.COM29_Wed, 10 May 2000 17:57:55 EDT300_US-ASCII Dan, I don't know of anything other than QMF and DB2 resource limit facilities to throttle ad-hoc queries. The DB2 resource limit facility can target specific users and plans and place limits on them. So you can target the CICS regions with one threshold, yet allow the query in batch. [...] 9060 111 31_Re: DB2 Log records recovery !!15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 10 May 2000 17:08:38 -0500321_ISO-8859-1 Vishy,

Yes, sorry, if you have the logs from the time of the create, you can recover forward from that point with DB2 Recover. But as far as I know only RECOVER PLUS lets you back out the changes. I thought that's what you were after when you said 'rollback / recover from the active log records.' [...] 9172 39 25_UDB missing sqlspsc files12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 10 May 2000 15:16:49 -0700428_us-ascii Somehow we've managed to lose the files which define the tablespace containers (/filesystem/instanceid/NODE0001/SQL00001/sqlspsc.1 & 2). This volume group was not backed up because we were taking DB2 backups of all the data, and knew we'd have to recover from DB2 backups as opposed to volume backups. We thought this was only data, and didn't realize there were other constructs which should have been backed up. [...] 9212 15 33_Candle's Quickchange/Quickcompare15_Camitta, Steven30_steven.camitta@INGRAMMICRO.COM31_Wed, 10 May 2000 15:20:51 -0700360_iso-8859-1 Does anyone have these products installed? Would you please share your experiences with them. Thanks, Steve

================================================ 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. 9228 91 29_Re: DB2 for Quality assurance12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 10 May 2000 15:40:52 -0700577_us-ascii There's always the DataPropagator tool from IBM. It's close to real-time updating. --- HEPP SHERY C wrote: > Monica- Assuming you're on db2 os/390 and if your > data structures are > identical you could use the dsn1copy to lay down > production image copies > into your qa database. This process is quicker than > unloads/loads- but does > have a few gotchas. Let me know if you want > additional information on using > the dsn1copy. HTH > > Regards, > > Shery Hepp > SRP > Sr. Database Adminstrator > Information Services > > > (602)236-2650 [...] 9320 46 47_Re: References to SDSNLOAD in link-edit SYSLIBs12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 10 May 2000 15:45:37 -0700558_us-ascii There is a lightly documented systems programmer facility from IBM called IPOUPDTE which will do mass changes to every member of a PDS. Make sure you have a $$$coibm member in the PDS so it will work. --- paul.packham@POSTOFFICE.CO.UK wrote: > Hi, > > Currently we use non-version specific data set high > level qualifiers for our DB2 > code. We are thinking of moving to using the > standard IBM data set names which > contain a version specific HLQ. Because we do not > change the HLQ between > versions we do not currently have to alter the [...] 9367 96 47_Re: References to SDSNLOAD in link-edit SYSLIBs11_MILNE, John31_John.MILNE@SUNCORPMETWAY.COM.AU31_Thu, 11 May 2000 08:44:58 +1000308_- Paul

We make use of the JCL Includes. We have a set of includes for each subsystems, which are stored centrally in the system proclib concatenation If we need to change the DB2 libraries we want people linkediting with (or running utilities with) we change some proclib members and away we go. [...] 9464 120 17_Re: DB2 Authority15_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU31_Thu, 11 May 2000 09:07:46 +1000467_us-ascii I think the answer will come in DB2 V7 - there are a number of user requests that are implemented, one of which is - "Allow DBADM to create view with different qualifier".

Shaun







"Vaughan, Mike" on 11/05/2000 04:23:59

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Shaun Z Lombard/CorpServ/qdot/au) Subject: Re: DB2 Authority [...] 9585 68 44_Re: VERTICAL DEFERRED WRITE THRESHOLD SETING14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 10 May 2000 20:07:36 -0400407_ISO-8859-1 Sanjeev, In the below situation, the updated page will be written synchronously, not wait for a ckpt to to write it asynch. I believe the synch wrie takes place at commit, not immediately after the update. You may see some examples of this in a statistics interval, where there are no ckpts, and there are still some small number of synch writes (which appear as counts in the iwth bucket). [...] 9654 54 18_Re: DB07 Workfiles11_rick creech18_ykcirc@HOTMAIL.COM29_Wed, 10 May 2000 17:20:24 PDT350_- Hi, If you were data sharing, you could move the adhoc sql to a different member of the data sharing group. Each member of the group has its own sort work database. We are getting ready to add a third member to our data sharing system in order to move a datamart application for the purpose of freeing up cpu resources on the original member. [...] 9709 104 45_Re: Extracting data in comma delimited format0_29_Greg.Palgrave@BANKWEST.COM.AU31_Thu, 11 May 2000 08:29:21 +0800347_us-ascii Just watch out for any data which has embedded commas....... if you have any, you need to enclose that data in quotes or you will get truncation, and the remaining data is treated as the next column which may cause you a few problems on IMPORT. You may need to check for NULLs also - depends on what you are doing with the CSV file. [...] 9814 58 26_Re: ProEdit vs. RC/Update?13_Thomas, Janis19_Janis.Thomas@CA.COM31_Wed, 10 May 2000 20:53:56 -0400591_iso-8859-1 Steve -

Since these are both CA products, I wanted to respond to you, however if your client has questions concerning the differences between these products, please have them contact me directly.

RC/Update basically covers the same functionality as ProEdit but offers a lot more funtionality above and beyond ProEdit. There are minor differences, for example, ProEdit provides for specifying a load and unload job for a table. This is done through RC/Update's integration with RC/Query, RC/Query is part of the package that is replacing the ProSeries products. [...] 9873 95 38_Re: DB2 Connect to MVS DB2 V.5 problem12_Dudley Moore16_dumoore@NMSU.EDU31_Wed, 10 May 2000 17:47:21 -0600590_iso-8859-1 Kurt, Thanks for the suggestion. I just tried uncataloging the node and adding the OSTYPE parameter, then recycling DB2 Connect and got the same error.

I went back and checked the entries in the SYSIBM.LUNAMES for the test subsystem and found the independent LU name was missing and thought for sure that was the problem. But I've stopped and started DDF on MVS, varied the VTAM node inactive and active, started and stopped DB2 Connect and Communications Server on the AIX box and still get the same exact error. Is there something else I need to do or a particular [...] 9969 35 33_SQLCODE -471 in stored procedures8_LAM, Leo17_l.lam@IOOF.COM.AU31_Thu, 11 May 2000 11:38:25 +1000446_ISO-8859-1

We are at V5 and run stored procedures under WLM. The stored procedure timeout (STORTIME) is set to 180. Occassionally we have some timeouts (SQLCODE -471) in some stored procedures. We don't think the system is so heavily loaded that WLM decides not to start another DB2WLM task to handle the stored procedure. Are there any parameters or system limits that we may have missed ? Anyone experienced the similar problems ? [...] 10005 20 31_Re: DB2 Log records recovery !!20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Wed, 10 May 2000 21:58:22 EDT534_US-ASCII Hello Vishy, Good news. We have a tool that will generate a summary of all your recovery points of a Tablespace by Timestamp and RBA. Be it a Quiese point by RBA, Image copy, or tablespaceset. It will also generate the complete Job JCL and Cntl cards by Pick and Chose. You simply key-in the tablespace and the application tool will display a list of Recovery Points for you to select by Timestamp or by Quiesed RBA. If anyone would like to see some sample panels let me know and I will email them off-list. Thanks, Ed. [...] 10026 19 14_DB2 connection14_Dmitriy Bobrov16_wertor@TICON.NET31_Wed, 10 May 2000 23:50:10 -0500426_iso-8859-1 Is anybody knows how to connect DB2 database with UNIX R6000 boxes in order to establish normal data retrieval and access from DB2 by RS6000? What kind of interface do we need? RS6000 operates on UNIX platform with use of C++ or C for applications. We need natively access DB2 V5 database through RS6000. IBM should provide some kind of software for this. Is anybody knows, what is it? Appreciate your answer. [...] 10046 31 17_Re: Why the -111?10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Thu, 11 May 2000 05:37:39 GMT283_us-ascii Hi Venkat and Jay, I do not know how this one worked but it worked.I just added one more step in the Venkat's query and it worked. SELECT COL1 FROM (SELECT SUM(X.COL1) COL1 FROM (SELECT SUM(Y.COL1) AS COL1 FROM (SELECT 1 AS COL1 FROM DAMCON2.TESTT ) AS Y ) AS X ) AS Z [...] 10078 231 50_Re: Datajoiner on NT using Control Center function13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Thu, 11 May 2000 11:42:15 +0530435_us-ascii Thanks David. !! I still have some things unanswered .....

Let me make the picture very clear ..



I have 4 systems .

1. in Unix and Oracle

2. in NT Oracle

3. Sybase on NT

4. DB2 V5.1 on NT

1. Now how do I go about the planning . Do I get Datajoiner for NT and integrate it with DB2 , and make DB2 as the control database ?? if yes then how to proceed after that ?? [...] 10310 35 72_Problem in exporting data using the QMF EXPORT command in a Rexx program18_Sridhar_Adusumilli29_Sridhar_Adusumilli@SATYAM.COM31_Thu, 11 May 2000 11:34:40 +0530375_- Hello List,

I have a task where I need to export data for many tables using the QMF Export command and this should be done very frequently. So, I thought of automating it by writing a Rexx program. First I created a Qmf query and ran this query in Rexx program by supplying the table names and column names using the Qmf global variables. This part works fine. [...] 10346 89 77_Re: Problem in exporting data using the QMF EXPORT command in a R exx program0_24_Ray.Price@DRESDNERKB.COM31_Thu, 11 May 2000 07:35:54 +0100338_iso-8859-1 I have used REXX to generate QMF EXPORT commands. The way I run them is to call QMF from REXX. So build the QMF EXPORT command in REXX, then issue something like:

"call dsqcix" call_command

where call_command is the REXX variable holding the QMF EXPORT command. So the variable substitution is done by REXX. [...] 10436 63 32_Re: HSM migrating data to level214_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 11 May 2000 16:36:21 +1000444_iso-8859-1 A long time ago, in an evironment that no longer exists, the sysprogs used to HSM migrate the test and acceptance test DB2 clusters.

What we found was that if we gave the application people EXECUTE authority on the clusters (we didn't want to give them READ), they could run a batch HSM RECALL on them. So first thing every morning they submitted their recall job (and every night HSM rolled the clusters back onto tape) [...] 10500 46 18_Re: DB2 connection18_Gert van der Kooij15_geko@WANADOO.NL31_Thu, 11 May 2000 08:36:52 +0200317_iso-8859-1 Hi, Take a look at the Embedded Programming Guide. It tells you what you need for for your C applications. If you want to connect to a database on another RS6000 you need to catalog that database on the 'client' . Take a look at the catalog node and catalog database command in the Command Reference. [...] 10547 38 21_Performance of MODIFY39_=?ISO-8859-1?Q?=22Per_Callerst=E5l=22?=22_per.callerstal@MIPS.SE31_Thu, 11 May 2000 09:19:39 +0200371_ISO-8859-1 Hi All !

If this has been covered recently in the list I apologize, and can someone please direct me to that discussion.

Due to circumstances beyond our control, for one of our systems, MODIFY RECOVERY TABLESPACE has not been run since 1992 !!!

When we try to remedy the situation by running MODIFYs, we get BIG performance problems. [...] 10586 19 21_Performance of MODIFY17_Andreas Constanti24_andreas.constanti@AGI.CH31_Thu, 11 May 2000 09:57:20 +0100511_us-ascii Hi Per

To get out of this awkward situation, perhaps you can delete and recreate SYSCOPY and SYSLGRNX and then Image Copy all your tablespaces. Don't forget to also create the associated Indexes and do the initialize (DSNTIJID Job).

Regards, Andy

================================================ 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. 10606 52 27_Re: Info in DB2 Logs OS/39012_Moreno, Jose19_Jose_Moreno@BMC.COM31_Thu, 11 May 2000 03:12:11 -0500536_ISO-8859-1 Mary Ann,

getting information with DSN1LOGP is very difficult. There are tools on the market that will allow you to easily get information from the log. One of those is BMC's RESOLVE LogMaster for DB2 (http://www.bmc.com/products/proddocview.html?product_seq_id=2097)

Regards.

Jose Moreno BMC Software EMEA S/390 SBU

-----Original Message----- From: Pickett, Mary Ann [mailto:pickettm@DOT.STATE.AL.US] Sent: Thursday, May 04, 2000 11:47 PM To: DB2-L@RYCI.COM Subject: Info in DB2 Logs OS/390 [...] 10659 125 32_Re: HSM migrating data to level212_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 11 May 2000 09:43:00 +0100541_iso-8859-1 I tried it once for a development subsystem because we were short of DASD and the subsystem was only used occasionally.

First we found that the large datasets wouldn't go to ML1 because they were too big, so we changed to go to ML2 directly. We then found that the recalls were serialised by HSM and when we had a lot of activity (which was quite often because we were short of DASD) the DB2 wait for recall timed out. We then increased the ZPARM to wait up to 5 mins for recalls and found that some queries could run [...] 10785 153 25_Re: Performance of MODIFY0_18_mebert@AMADEUS.NET31_Thu, 11 May 2000 10:14:58 +0100530_iso-8859-1 Hi Per,

this has been discussed in the last days of December '99, look for subject "Re: Reorg DB2 catalog/MODIFY running time".

One solution would be to modify entries off one day (or a few days) at a time. This will not reduce the total CPU time, but will allow you to spread it out over a period of weeks, and it also won't block SYSCOPY for hours at a time. Of course this will mean hundreds of thousands or millions of MODIFY steps, but it's easy to write a REXX or SAS job to generate your JCL. [...] 10939 312 50_SV: Datajoiner on NT using Control Center function0_19_Sven.Heidorn@CSN.SE31_Thu, 11 May 2000 11:13:25 +0200573_ISO-8859-1 Vishy,

First, if you buy DataJoiner you get it for both NT and AIX, it's up to you where you want to run it. Now, DataJoiner is a DB2 system of it's own, so what you do after you have installed DataJoiner and set up all the communication stuff, is to create a database in the DataJoiner DB2 system. In this database you can create either normal tables, like in any other DB2database, or you can create nicknames to tables residing in another database and/or platform, like for instance Oracle or Sybase. To a user, application or another DB2 system, [...] 11252 148 31_Re: DB2 Log records recovery !!4_IBM116_IBM1@UBIL.COM.TR31_Thu, 11 May 2000 12:11:21 +0300376_ISO-8859-9 Michael,

I only replied attaching your message because I had deleted the original one from Vishy. As a matter of fact, when recovering from log I preferred to use RECOVER PLUS since we had it in house and it's a nice product!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@ubil.com.tr aurora.dellanno@sistinf.it [...] 11401 70 25_Re: Performance of MODIFY19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Thu, 11 May 2000 09:30:50 +0200339_iso-8859-1 It is a long time since I have done something like this. But if I remember correctly you can unload the data from the syscopy table. Delete the data records that you no longer require and then reload the data back into the table. When I say unload and load I cannot remember whether this was using the utility or DSN1COPY. [...] 11472 117 29_Re: DB2 for Quality assurance4_IBM116_IBM1@UBIL.COM.TR31_Thu, 11 May 2000 12:13:08 +0300694_- tim,

or anybody more knowledgeable than myself, where can I find some good info about DataPropagator?

ciao!

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



> -----Original Message----- > From: tim malamphy [SMTP:timalamphy@YAHOO.COM] > Sent: Thursday, May 11, 2000 1:41 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 for Quality assurance > > There's always the DataPropagator tool from IBM. It's > close to real-time updating. > --- HEPP SHERY C wrote: > > Monica- Assuming you're on db2 os/390 and if your > > data structures are > > identical you could use the dsn1copy to [...] 11590 47 31_Re: DB2 Log records recovery !!4_IBM116_IBM1@UBIL.COM.TR31_Thu, 11 May 2000 12:28:36 +0300646_- edward,

I would be very interested!

ciao!

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



> -----Original Message----- > From: Edward C. Benoit Jr. [SMTP:DB2Automate@AOL.COM] > Sent: Thursday, May 11, 2000 4:58 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Log records recovery !! > > Hello Vishy, Good news. We have a tool that will generate a summary of > all your recovery points of a Tablespace by Timestamp and RBA. Be it a > Quiese point by RBA, Image copy, or tablespaceset. It will also generate > the > complete Job JCL and Cntl cards by [...] 11638 38 45_Re: Extracting data in comma delimited format19_Suren Dheenadayalan16_suren_228@C4.COM31_Thu, 11 May 2000 10:47:49 -0000334_- Hi everybody, This is in reply to John Routh\'s query. I work on DB2 UDB V5 (NT Environment). From the control center,if a export is done in Delimited ASCII format. The exprt file would be a text file containing data values separated by columns and the text columns within the text qulaifier. Find out if this is useful to you [...] 11677 60 31_Re: DB2 Log records recovery !!19_Suren Dheenadayalan16_suren_228@C4.COM31_Thu, 11 May 2000 11:09:52 -0000646_- edward, I am also interested

regards suren

On Thu, 11 May 2000 12:28:36 +0300 IBM1 wrote: >edward, > >I would be very interested! > >ciao! > >Aurora Dell\'Anno >Systems Engineer >IBM Software Support >e-mail: >ibm1@ubil.com.tr >aurora.dellanno@sistinf.it > > >> -----Original Message----- >> From: Edward C. Benoit Jr. [SMTP:DB2Automate@AOL.COM] >> Sent: Thursday, May 11, 2000 4:58 AM >> To: DB2-L@RYCI.COM >> Subject: Re: DB2 Log records recovery !! >> >> Hello Vishy, Good news. We have a tool that will generate a summary of >> all your recovery points of a Tablespace by Timestamp and RBA. Be it a >> [...] 11738 120 30_Re: order by clause (DB2 V5.1)19_Suren Dheenadayalan24_suren_228@REDIFFMAIL.COM31_Thu, 11 May 2000 10:59:11 -0000320_- Thi is in reply to Rohn's query about order by clause.

I work on DB2 UDB V5.1 NT envoronment. I tested your query in my environment. It works fine. The column that is specified in the order by clause need not be a column in the result set.

You will have to check out with your version and platform. [...] 11859 95 34_Re: interface to DB2 on the RS600010_Marc Baime14_mbaime@GTE.NET31_Thu, 11 May 2000 07:03:28 -0400408_iso-8859-1 Dmitriy,

I'm not exactly sure what you mean by standard existing interfaces but the control center works fine with DB2 on the RS6000. Or you can use a telnet session to get there and manipulate the database. Are you talking about something else...some sort of application programming interface perhaps? If not, all the standard methods of getting to DB2 work on an RS6000/AIX machine. [...] 11955 93 31_Re: DB2 Log records recovery !!11_Iztok Jeras27_Iztok.Jeras@OMVISTRABENZ.SI31_Thu, 11 May 2000 13:31:06 +0200650_- Edward,

if it's possible I'd be interested too

iztok.jeras@omvistrabenz.si

thanks in advance,

Iztok Jeras

> -----Original Message----- > From: Suren Dheenadayalan [SMTP:suren_228@C4.COM] > Sent: Thursday, May 11, 2000 1:10 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Log records recovery !! > > edward, > I am also interested > > regards > suren > > On Thu, 11 May 2000 12:28:36 +0300 IBM1 wrote: > >edward, > > > >I would be very interested! > > > >ciao! > > > >Aurora Dell\'Anno > >Systems Engineer > >IBM Software Support > >e-mail: > >ibm1@ubil.com.tr > >aurora.dellanno@sistinf.it > > [...] 12049 52 47_Re: References to SDSNLOAD in link-edit SYSLIBs11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 11 May 2000 07:54:57 -0400651_iso-8859-1 Paul,

Since we have multiple sub-systems across multiple LPARs we use a form of dsnload like DB2.DB2x.DSNLOAD where DB2x is the ssid of that sub-system. In our compile procedures we use the DB2.DB2x.DSNLOAD associated with the LAST sub-system that we will upgrade or apply maintenance. In our case this is the "most important" production environment. Since DB2 has consistently supported backward compatibility, programs compiled with this level of DB2 run fine in all newer levels. This also prevents the use of "new" features until they are supported across the enterprise as we run the program pre-compilers at that level as [...] 12102 12 29_Re: DB2 for Quality assurance10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Thu, 11 May 2000 07:56:51 -0400569_- I don't know how much data you will be required to move, but you may be setting yourself up to spend a lot of time moving data. Question, why do you need to continuously move production data? If the purpose of the environment is to perform the qa function, simply moveing the data from production will not necessarily serve your purpose. It seems like the qa group should be "constructing" data that tests out particular scenarios. In this manner you can be assured that you are truely QAing the applications. When you copy data from any environment it does not [...] 12115 96 40_Re: Log only recovery of old static data11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 11 May 2000 08:05:02 -0400490_iso-8859-1 Mike,

This information is stored in the directory table SYSIBM.SYSLGRNX. You can use report recovery utility to see what logs would be required. Here is info for V4 version.

2.16 Chapter 2-16. REPORT

The REPORT online utility provides information about table spaces. Use REPORT TABLESPACESET to find the names of all the table spaces and tables in a referential structure. Use REPORT RECOVERY to find information necessary for recovering a table space. [...] 12212 61 45_Re: Extracting data in comma delimited format9_Jim Leask27_jim.leask@RS-COMPONENTS.COM31_Thu, 11 May 2000 13:07:32 +0100466_iso-8859-1 John,

Oracle can use the punch cards from a DSNTIAUL unload as the map for a load into an Oracle table of the same/similar definition with little amendment required. See Oracle utility SQLLDR further information in the Oracle Server Utilities manual.

Jim.

-----Original Message----- From: John Routh [mailto:John_Routh@CANADALIFE.COM] Sent: 10 May 2000 21:19 To: DB2-L@RYCI.COM Subject: Extracting data in comma delimited format [...] 12274 76 25_Re: Performance of MODIFY37_=?us-ascii?Q?=22Per_Callerst=E5l=22?=22_per.callerstal@MIPS.SE31_Thu, 11 May 2000 14:07:35 +0200326_us-ascii Hi !

Michael and Neil and others, thanks for the advice.

1. If I do an unload and load (after deletion un unwanted rows) of the SYSCOPY tables, are we sure that we don't miss any cleanup processing done by DB2, via the MODIFY utility, behind the scene ? Otherwise this seems to be the best option. [...] 12351 63 40_Angelo:IN CORRECT RESULTS ON VERSION 6.118_Angelo Grotticelli34_angelo.grotticelli@MSE.TALBOTS.COM31_Thu, 11 May 2000 08:22:23 -0400463_iso-8859-1 Has anyone had this problem...? It seems IBM does not know about this problem I have open an ETR but not have received any feed back except we are working on it. I don't believe this is a new issue. Somebody somewhere has run into this problem. Can some look at the Query and see if this unusual or is this some hole fixed in version 6 I believe there is enough DB2 users in our list that give me a resolution and/or suggestions. I appreciate it! [...] 12415 106 25_Re: Performance of MODIFY19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Thu, 11 May 2000 14:43:29 +0200303_iso-8859-1 Hi Pers,

I personally didn't have any problems, as I made sure that in the event of a recovery, I always had an image copy dataset after the cut off point from when the rows where deleted. Therefor DB2 nor I was bother about what happened before this time.

The process was [...] 12522 47 33_FW: Accessing DB2 (OS390) from OE17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Thu, 11 May 2000 08:54:40 -0400405_- One option that I have used is to write a JAVA program with either JDBC or SQLJ to access my DB2 OS/390 databases.

You can find details and some program examples in the following IBM manual: Application Programming Guide and Reference for Java

which is available in PDF format at the following IBM websites: for DB2 OS/390 V5 http://www-4.ibm.com/software/data/db2/os390/v5books.html [...] 12570 36 23_IMPORT UTILITY QUESTION18_MCCARTHY, DANIEL M27_DANIEL_M_MCCARTHY@FLEET.COM31_Thu, 11 May 2000 08:38:37 -0400433_iso-8859-1 I have a question re: the IMPORT utility. According to the UDB Command reference manual the INTO table-name clause -

"can use an alias for INSERT, INSERT_UPDATE, or REPLACE, except in the case of a down-level server, when the fully qualified or the unqualified table name should be used. A qualified table name is in the form: schema.tablename. The schema is the user name under which the table was created.". [...] 12607 18 22_SQLJ Stored Procedures18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 11 May 2000 09:04:35 -0400329_- I created a SQLJ stored procedure in UDB V6.1 on Solaris but when I run it, it gives me an 818 (timestamp) error. I rebound the package associated with the SP and the same error occurs. Does anyone know which package would need to be rebound in order to execute this stored procedure? I am using SPB to build and test it. [...] 12626 51 25_Re: Performance of MODIFY11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 11 May 2000 09:06:06 -0400514_ISO-8859-1 In my opinion this is a highly dangerous technique. You are certainly will miss cleanup done by MODIFY, specifically the removal of entries from the Directory tablespace SYSLGRNX. You will probably get away with it if SYSCOPY and SYSLGRNX are out of step in such a way that there are older entries in SYSLGRNX than SYSCOPY, but you are left with the problem of how to clean up SYSLGRNX. What will MODIFY do next time you run it? Delete all the old SYSLGRNX entries or get screwed up? I don't know. [...] 12678 19 37_Re: Candle's Quickchange/Quickcompare0_19_RTurpen@WOODMEN.COM31_Thu, 11 May 2000 08:14:49 -0500329_us-ascii We just replaced the Platinum RC tools with Candle DB\Workbench and DB\Quickchange. The product is easy to install, easy to use, and not very costly to purchase compared to other products. If you only need the basic tools for DB2 administration, Candle is a solid choice.

Ray Turpen DBA Woodmen of the World [...] 12698 57 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 11 May 2000 09:14:54 -0400510_ISO-8859-1 Let me add my two pence worth (about 3 cents at today's exchange rate). The discussion about 128 pages seems to me to have missed one minor point. It is my understanding that, when DB2 schedules an async write task, that task will write up to 128 pages from its associated pageset. However this is done by multiple Write I/Os, each of which can be for up to 32 pages. I believe that the 150 CI boundary applies to the pages written in a single write I/O and not to the 128 total pages written. [...] 12756 142 25_Re: Performance of MODIFY15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 11 May 2000 15:13:49 +0100460_us-ascii Hello Pers,

Yes,

You may miss processing that DB2 MODIFY does. I don't think it's a good idea to do this unless you are ABSOLUTELY sure what you are doing and this is not a production system. If you s...w up.. You're on your own....

Regards,

Toine Michielse

Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS



"Briggs, N. - Neil -" @RYCI.COM> on 05/11/2000 01:43:29 PM [...] 12899 74 25_Re: Performance of MODIFY15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 11 May 2000 15:21:41 +0100792_us-ascii Hello,

In addition to Mike's comments. You'll also miss out on DBD updates.......... Couldn't agree more with Mike.... Very dangerous.

Regards,



Toine Michielse



Mike Turner @RYCI.COM> on 05/11/2000 02:06:06 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Re: Performance of MODIFY





In my opinion this is a highly dangerous technique. You are certainly will miss cleanup done by MODIFY, specifically the removal of entries from the Directory tablespace SYSLGRNX. You will probably get away with it if SYSCOPY and SYSLGRNX are out of step in such [...] 12974 199 37_FAO Toine - RE: Performance of MODIFY19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Thu, 11 May 2000 15:29:34 +0200340_iso-8859-1 Toine,

Could you please detail the processing that DB2 MODIFY performs and the possible errors that could be encountered. As we are in a situation here where the process I described has been performed in a production environment (8 months ago I think?). I ask because I would hate to have the DB2 sub system s..w up. [...] 13174 317 50_Re: Datajoiner on NT using Control Center function18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 11 May 2000 09:31:16 -0400637_- How do you map this in Control Center? Please provide the syntax. We are using control center V6.1 fixpack3. DataJoiner is V2.1.1.

-----Original Message----- From: Sven.Heidorn@CSN.SE [mailto:Sven.Heidorn@CSN.SE] Sent: Thursday, May 11, 2000 5:13 AM To: DB2-L@RYCI.COM Subject: SV: Datajoiner on NT using Control Center function



Vishy,

First, if you buy DataJoiner you get it for both NT and AIX, it's up to you where you want to run it. Now, DataJoiner is a DB2 system of it's own, so what you do after you have installed DataJoiner and set up all the communication stuff, is to create a database in [...] 13492 151 25_Re: Performance of MODIFY0_18_mebert@AMADEUS.NET31_Thu, 11 May 2000 15:32:43 +0100532_us-ascii 1. MODIFY doesn't just delete rows in SYSCOPY, it also has to synchronise SYSLGRNX, and possibly other things. I have some doubts that the unload/delete/load procedure is possible. I definitely wouldn't recommend it in a production system. You might find out you have a shot catalog just when trying to urgently recover an important tablespace months later! 2. If I remember correctly, the last time this was discussed, somebody from IBM stated that MODIFY won't use user defined indexes. But you might simply try it. [...] 13644 182 25_Re: Performance of MODIFY37_=?us-ascii?Q?=22Per_Callerst=E5l=22?=22_per.callerstal@MIPS.SE31_Thu, 11 May 2000 15:35:52 +0200404_us-ascii Hello Toine,

Point taken. I will consider all ideas a bit before we do any drastic. As part of this data has been in the SYSCOPY table since early nineties, it can stay for a little while more.

Now that Santa Teresa stepped in "unofficially?", do you have any ideas except Michaels (doing a little processing at a time), to speed up the MODIFYies. Will adding an index work ? [...] 13827 76 25_Re: Performance of MODIFY20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 11 May 2000 09:38:56 -0400390_us-ascii I agree with Mike. We had a similar situation. We ran MODIFY in multiple steps e.g. first job MODIFY AGE(2000) Then MODIFY AGE(1000) followed by AGE(500).. AGE(365) etc.

Since MODIFY jobs don't interfere with any SQL and only hinder if there is any utility running on the same object (or imagecopy of SYSCOPY itself), there is a lot of room to run these jobs stepwise. [...] 13904 79 35_FW: DB2 Stored Procedures Standards13_Morrill, John12_JohnM@VP.NET31_Thu, 11 May 2000 07:53:46 -0600488_-



-----Original Message----- From: martin.kenney@RAILINC.COM [mailto:martin.kenney@RAILINC.COM] Sent: Thursday, May 11, 2000 7:25 AM To: DB2-L-REQUEST@RYCI.COM Subject: DB2 Stored Procedures Standards







We are beginning to use DB2 Stored Procedures where I work. Management wants us to come up with standards for them. Does anyone have any that they could send to me. If you want you can E-mail me directly at : MARTIN.KENNEY@RAILINC.COM [...] 13984 23 20_Unknown IBM packages10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 11 May 2000 10:03:25 -0400516_us-ascii HI all



does anyone know what the following packages are

NULLID.SQLABB7A, NULLID.SQLL1B7A NULLID.SQLL2B7A.

The ddcs quick beginnings book (version 6 appendix G) breaks down the package name, but '7' is not listed as a platform

Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14008 108 27_Re: Info in DB2 Logs OS/39013_McDonald, Ken20_Ken_McDonald@BMC.COM31_Thu, 11 May 2000 08:58:39 -0500582_ISO-8859-1 Hi Mary Ann,

Ravi Kumar Hassan asked a similar question yesterday to which I responded (included below). The tool referenced by Jose will correlate the URID information to the related DM records and has robust filtering capabilities to allow you extract log data for a specific user, table, or several other options. This filtering will allow you to extract only the log records associated with your immediate concern, eliminating the other potentially confusing noise on the log. In addition to reporting capabilities, Log Master can do many other things... [...] 14117 86 33_Re: Question about UQ18604 ( V5).12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Thu, 11 May 2000 10:01:16 -0400461_iso-8859-1 Perhaps you have a typo, what does your JCL look like?

I have an SDSNEXIT in my DDDEFs.



-----Original Message----- From: Ted Pesta [mailto:tpesta@AMQUEST.COM] Sent: Monday, May 08, 2000 10:05 AM To: DB2-L@RYCI.COM Subject: Question about UQ18604 ( V5).

Good Morning,

I'm applying maintenance to a V5 subsystem. One of the PTF's being applied is UQ18604. When I do the apply check, I get a message GIM54502E : [...] 14204 50 33_Re: Question about UQ18604 ( V5).9_Ted Pesta18_tpesta@AMQUEST.COM31_Thu, 11 May 2000 10:26:34 -0400439_iso-8859-1 Tom,

Thank you for responding. I have the SDSNEXIT in my DDDEF's also. The message is generated when I attempt to do an APPLY CHECK on a PTF. The name of the DD in the message is generated by SMP, not my JCL/DDDEFs.

Ted Pesta

-----Original Message----- From: Hylton Tom P [mailto:Tom.P.Hylton@IRS.GOV] Sent: Thursday, May 11, 2000 10:01 AM To: DB2-L@RYCI.COM Subject: Re: Question about UQ18604 ( V5). [...] 14255 52 47_Re: References to SDSNLOAD in link-edit SYSLIBs0_19_mike.holmans@BT.COM31_Thu, 11 May 2000 14:17:42 +0100408_- We don't use the "standard" IBM names, as such, but we are now using version-specific library names for the base code. But the startup JCL, compile PROCs, etc still refer to subsystem-specific library names which are aliases of the base libraries. So we perform maintenance or upgrades by preparing the new code library and then changing the alias to point to the new library rather then the old one. [...] 14308 260 41_Re: FAO Toine - RE: Performance of MODIFY15_Toine Michielse18_vndobtm@US.IBM.COM31_Thu, 11 May 2000 16:26:10 +0100471_us-ascii Hello Neil,

No I can not detail the processing that MODIFY does.

Even if I knew the details that would be confidential and intellectual property of IBM.

However, If you read the diagnosis guide carefully, you can find that for instance OBDs are deleted when modify knows that any remaining iamge copies don't contain records from previously dropped tables in a particular tablespace. This DBD cleanup process would certainly be missed. [...] 14569 364 50_SV: Datajoiner on NT using Control Center function0_19_Sven.Heidorn@CSN.SE31_Thu, 11 May 2000 16:36:08 +0200352_ISO-8859-1 Just define the DataJoiner machine to your client with the Client Configuration Assistant, then it should show up in the Control Center. You might not get all Control Center functionality but you should at least see the tables, we mainly wanted to use the Command Center instead of the terrible Dos prompt when working with DataJoiner. [...] 14934 80 33_Re: Question about UQ18604 ( V5).19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 11 May 2000 09:36:26 -0500598_ISO-8859-1 Ted, A PTF is normally NOT specific about libraries. And the GIM msg may need updating. I'd check my clone or target DDDEFs to ensure correct library names.

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your [...] 15015 80 44_FW: Angelo:IN CORRECT RESULTS ON VERSION 6.118_Angelo Grotticelli34_angelo.grotticelli@MSE.TALBOTS.COM31_Thu, 11 May 2000 10:37:54 -0400504_iso-8859-1 Can someone respond ! Can anyone take a look at this problem, I am sure I am not the only person who has had this problem.

Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help ! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help !! Please help ! [...] 15096 122 38_Re: DB2 Connect to MVS DB2 V.5 problem13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 11 May 2000 09:52:03 -0500366_ISO-8859-1 Hello Dudley, If using TCP/IP then its the HOSTNAME and SERVICENAME that are case sensitive when cataloging the node. Are you using IP or SNA ? Kurt

>>> dumoore@NMSU.EDU 05/10/00 06:47PM >>> Kurt, Thanks for the suggestion. I just tried uncataloging the node and adding the OSTYPE parameter, then recycling DB2 Connect and got the same error. [...] 15219 314 41_Re: FAO Toine - RE: Performance of MODIFY19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Thu, 11 May 2000 17:15:09 +0200570_iso-8859-1 Dear Toine,

Thank you for taking the time to respond to my question earlier. I do agree that 99.9% of the time to tinker with the recovery information outside the scope of DB2 can be problematic, if not damn right dangerous.

When the decision was made to perform the procedure described in earlier posts, it was based on the assumption that there would never be a need to recover to a point prior to a recent image copy, say 1 week previous from the current day. Rows were deleted from syscopy before this point in time (i.e. before 1 week [...] 15534 48 25_Re: Performance of MODIFY17_Andreas Constanti24_andreas.constanti@AGI.CH31_Thu, 11 May 2000 17:17:01 +0100592_us-ascii Hello Toine

... which again leads me to the question: Is there a way to get rid of unwanted SYSLGRNX entries ? As I posted on this subject earlier but didn't get a usable answer I enclose it again:

The DB2 for OS/390 V5 SQL Reference Manual states on page 361: "Deleting SYSLGRNG records for dropped table spaces: After dropping a table space, you cannot delete the associated records. If you want to remove the records, you must quiesce the table space, and then run the MODIFY RECOVERY utility before dropping the table space. If you delete the SYSLGRNG records [...] 15583 49 4_JDBC0_32_Larry.Hill1@BRIDGE.BELLSOUTH.COM31_Thu, 11 May 2000 10:22:06 -0500670_US-ASCII Dean,

Assuming you stuck with the default pathnames provided in the SMP/E sample jobs for JDBC, the JDBC driver is in Unix System Services in: /usr/lpp/db2/db2510/classes/db2jdbcclasses.zip

If you're having trouble accessing the driver, you may not have all of your environmental variables setup correctly and/or your DSNAOCLI initialization file. If you look at the file /usr/lpp/db2/db2510/README, there is an explanation of all the things you need to setup for the JDBC environment. If you haven't yet done so, you should download PTF UQ41618 (APAR PQ19814) to upgrade to the sqlj/jdbc type 2 driver. This is a complete replacement of the [...] 15633 139 38_Re: DB2 Connect to MVS DB2 V.5 problem14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 11 May 2000 11:29:13 -0400506_iso-8859-1 Dudley, I believe the symbolic destination has to be upper case on AIX. On NT it must be upper case. At least that has been my experience. HTH Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Kurt Sahlberg Newsgroups: bit.listserv.db2-l To: Sent: Thursday, May 11, 2000 10:52 AM Subject: Re: DB2 Connect to MVS DB2 V.5 problem [...] 15773 37 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 11 May 2000 11:28:10 -0400577_ISO-8859-1 Right on the money Mike..... even with current exchange rates. Regards, Joel



Message text written by DB2 Data Base Discussion List >Let me add my two pence worth (about 3 cents at today's exchange rate). The discussion about 128 pages seems to me to have missed one minor point. It is my understanding that, when DB2 schedules an async write task, that task will write up to 128 pages from its associated pageset. However this is done by multiple Write I/Os, each of which can be for up to 32 pages. I believe that the 150 CI boundary applies to [...] 15811 20 23_Defragging DB2 Volumes?19_Scarlett McLaughlin29_SMcLaughlin@CONSULTEC-INC.COM31_Thu, 11 May 2000 11:29:51 -0400437_US-ASCII We are engaged in a discussion with our DASD management folks about defragging our DB2 volumes. They have expressed concerns about the risks involved in using ADRDSSU. We have never had a problem with ADRDSSU here, but they have heard of problems in other shops. Do any of you have any documented instances of DB2 data being scrambled by ADRDSSU? Do you use any other utilities to defrag your DB2 volumes? Thanks, Scarlett [...] 15832 82 25_Re: DB2 UDB NT monitoring10_Park, Stan17_SPark@STATE.NM.US31_Thu, 11 May 2000 09:31:41 -0600423_ISO-8859-1 I am looking at the following that may be of interest:

About the full Windows NT 4.0 Resource Kit.

The full Windows NT 4.0 Resource Kit contains valuable technical and performance information about Windows NT 4.0, as well as many more tools and utilities that enhance and extend the operating system. For information about the full Windows NT 4.0 Resource Kit, see our World Wide Web site at: [...] 15915 62 41_Extracting data in comma delimited format12_Kosin, Chuck24_chuck.kosin@EXPERIAN.COM31_Thu, 11 May 2000 08:21:51 -0700380_iso-8859-1 Here is one example. In this case, the delimiter is ":". SUBSCRIBER_ID is a character column. COMPANY_ID is an integer. The DIGITS function is used to convert the integer values to character values. Unfortunately, the DIGITS function drops the sign. To get the sign, the CASE expression is used. The SUBSTR function is used to eliminate the VARCHAR length values. [...] 15978 213 25_Re: Performance of MODIFY12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 11 May 2000 08:34:43 PDT538_- My 2 cents:

I just cleaned up our production system that had not had MODIFY run for over 9 months. (This is a PeopleSoft FS system with about 4000 tablespaces or so and each is backed up daily.) I ran at the database level (none with more than 250 tablespaces) and the worst ran about 20 minutes.) All in all I deleted several hundred thousand rows, in a total of about 3 hours. This job now runs (age 20) on a weekly basis. Have been running for 3 weeks with absolutely NO problems. I would NOT recommend to delete 100,000 [...] 16192 41 31_Re: DB2 Log records recovery !!17_Armando Zaporteza25_azaporte@CI.PHOENIX.AZ.US31_Thu, 11 May 2000 08:34:06 -0700707_US-ASCII Ed,

Please do send me some sample panels.

Thanks.



armando



______________________________ Reply Separator _________________________________ Subject: Re: DB2 Log records recovery !! Author: DB2 Data Base Discussion List at INTERNET-MAIL Date: 5/10/00 9:58 PM



Hello Vishy, Good news. We have a tool that will generate a summary of all your recovery points of a Tablespace by Timestamp and RBA. Be it a Quiese point by RBA, Image copy, or tablespaceset. It will also generate the complete Job JCL and Cntl cards by Pick and Chose. You simply key-in the tablespace and the application tool will display a list of Recovery [...] 16234 24 70_Difference between IN and EXISTS predicates in a correlated subqueries12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 11 May 2000 08:40:54 PDT371_- Hi Folks:

I read before an article where It said that in some cases to gain a good perfomance in a correlated subqueries is better specify the EXISTS predicate instead of IN predicate. In our shop an user wrote a huge query using IN predicate but I rewrote it using EXISTS and now it look better. I would like to hear your comments about it. Thanks a lot , [...] 16259 301 35_Re: Performance of MODIFY; SYSLGRNX0_18_mebert@AMADEUS.NET31_Thu, 11 May 2000 17:54:18 +0100316_us-ascii It seems to me that the runtime problems encountered by me (and others) occur only in connection with partitioned TSs, when you take ICs at both partition and full TS level. I too now take care to run MODIFY on the problematic ones weekly; runtime is now at most one CPU minute per TS (still a lot...) [...] 16561 148 29_Re: DB2 for Quality assurance12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 11 May 2000 09:03:57 -0700647_us-ascii try your friendly IBM rep...or here: http://www-4.ibm.com/software/data/dbtools/datarepl.html --- IBM1 wrote: > tim, > > or anybody more knowledgeable than myself, where can > I find some good info > about DataPropagator? > > ciao! > > Aurora Dell'Anno > Systems Engineer > IBM Software Support > e-mail: > ibm1@ubil.com.tr > aurora.dellanno@sistinf.it > > > > -----Original Message----- > > From: tim malamphy [SMTP:timalamphy@YAHOO.COM] > > Sent: Thursday, May 11, 2000 1:41 AM > > To: DB2-L@RYCI.COM > > Subject: Re: DB2 for Quality assurance > > > > There's always the DataPropagator tool from IBM. > It's > > [...] 16710 119 33_Re: Question about UQ18604 ( V5).22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 11 May 2000 12:07:22 -0400574_- Ted -

Each MOD entry in the SMP/E target zone specifies its LMOD name. The LMOD entry in the target zone specifies its SYSLIB DDNAME. The LMOD is link edited into the SYSLIB DDNAME.

For example, in DB2 for OS/390, MOD DSNKUNR2 is in LMOD DSNK2DM whose SYSLIB is SDSNLOAD.

Make sure the LMOD SYSLIB entry(s) is SDSNEXIT & not DSNEXIT (SDSNLOAD not DSNLOAD, etc...) for the MOD(s) the PTF is installing. If the error message does not specify the LMOD that wants to use DSNEXIT, then you're going to have to check all the LMODs affected by the PTF. [...] 16830 391 35_Re: Performance of MODIFY; SYSLGRNX15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Thu, 11 May 2000 12:15:30 -0400567_us-ascii I got bit by this also when trying to cleanup SYSCOPY. Modify for non partitioned tablespaces ran in very acceptable time even when deleting several hundred at a time. When non LARGE partitions where deleted the time only went up by factor of 1 or 2. BUT when I tried a LARGE tablespace it went up from minutes to hours close to twenty seven. It seems like there is a lot of internal checking going on for partioned tablespaces that is not present for non partitioned tablespaces. Also most of our IC's are at the partitioned level with very infrequent [...] 17222 23 35_See You All Next Week In Dallas !!!13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Thu, 11 May 2000 16:12:42 +0100485_us-ascii Just about to sign off from work before heading for IDUG in Dallas tomorrow.

See you all there - please say hello if you see me.

Phil Nelson



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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17246 21 49_Definition of Lock Summary Report Change Requests15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Thu, 11 May 2000 09:16:16 -0700462_iso-8859-1 DB2 V5, OS/390, Omegamon for DB2 Version 300

I am looking at an Omegamon report, Accounting Lock Summary. One of the fields is Change Requests, but I can't seem to find a definition for it other than number of change requests issued to IRLM. Would that be lock promotion as defined in the DB2 manual as the action of exchanging one lock on a resource for a more restrictive lock on the same resource, held by the same application process? [...] 17268 33 61_Errors at Clients (Dr Watsons) when going through DB2 Connect13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Thu, 11 May 2000 16:17:09 +0100355_us-ascii We are having intermittent problems with our DB2 Connect (V5.2) gateway to DB2 for OS/390 V5.

About once a day users at client PCs can't connect - with WinNT they get a "Dr Watsons" dump and with OS/2 they get a SYS3175 (?).

Connections from the gateway to the mainframe (from a Telnet session on the gateway) still work fine. [...] 17302 29 15_www.dbazine.com14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Thu, 11 May 2000 11:18:15 -0500503_ISO-8859-1 FYI Folks... check out a new on-line magazine for DBAs at http://www.dbazine.com/

The first "issue" is up and available now with fresh content on the home page and links to relevant sites, articles, and information in four individual sections, one each dedicated to DB2, Oracle, SQL Server, and IMS.

Happy reading, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com cmullins@compuserve.com [...] 17332 388 35_Re: Performance of MODIFY; SYSLGRNX19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 11 May 2000 11:29:41 -0500521_ISO-8859-1 Hi Doc, I've always avoided issues like this by adding a MODIFY step to every Image Copy job. That way you are deleting just one IC, and maybe a quiesce, reorg, etc, each time. Once, and I stress ONCE, when about 50 or 60 Image Copy jobs were running at once, one timed out on SYSIBM.SYSCOPY or the internal util table. BTW, from memory, I believe SYSLGRNX was one of the directory tables where user-defined indexed weren't used. I searched the DB2-L archives and couldn't find a hit on this item though. [...] 17721 99 45_Re: Extracting data in comma delimited format27_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Thu, 11 May 2000 11:46:01 -0500466_- You can use help from next little SQL to prepare SQL for CSV extraction, if you have many tables or columns to write

--PREPARE SELECT STATEMENT TO EXTRACT CSV FILE FROM TABLE SELECT TBNAME, '1 SELECT ', ' ', ' ' FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'MY_TABLE' UNION SELECT TBNAME, '2', NAME, ''',''' FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'MY_TABLE' UNION SELECT TBNAME, '3 FROM ', 'XXXX.'||TBNAME, ' ' FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'MY_TABLE' [...] 17821 37 26_Re: ProEdit vs. RC/Update?7_Steve G15_steve_g@USA.COM31_Thu, 11 May 2000 12:58:48 -0400526_- Andrea,

They were told that ProEdit will not exploit DB2 6.1 features, and were encouraged to switch to RC/Update.

If you know of differences between ProEDIT and RC/Update, please reply.

Thanks!



------Original Message------ From: Andrea Milligan To: DB2-L@RYCI.COM Sent: May 10, 2000 9:14:29 PM GMT Subject: Re: ProEdit vs. RC/Update?



Can you elaborate on the "doesn't work" for V6.1? What didn't work and what kind of support was missing? [...] 17859 87 25_Re: Performance of MODIFY19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 11 May 2000 12:03:24 -0500597_ISO-8859-1 Andreas, Never done this but here's what I'd try. DSN1PRNT SYSLGRNX and SYSCOPY. Find all the unused tablespaces. Run MODIFY on them. Please let us know how you successfully clean up SYSLGRNX. HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this [...] 17947 21 33_Pros and Cons of table/tablespace20_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Thu, 11 May 2000 11:59:49 -0500348_- All, We are getting ready to create a new Database and there are a number of DBA's in our group that prefer having multiple tables per tablespace mainly for RI considerations. Then there is a group of us that prefer 1 table per tablespace mainly for ease of recovery. Can anyone give us additional pros and cons for these two methodologies. [...] 17969 44 37_Re: Pros and Cons of table/tablespace15_Murley, Michael22_Michael_Murley@BMC.COM31_Thu, 11 May 2000 12:30:12 -0500379_ISO-8859-1 Bill,

The LOAD REPLACE utility is a common source of errors when using multiple tables per table space, probably because it refers to a table name but deletes data at the table space level. If I had a nickel for every time I've seen someone accidently wipe out all the tables in a space with a LOAD REPLACE for a single table, I'd have...a lot of nickels. [...] 18014 154 33_Re: Question about UQ18604 ( V5).9_Ted Pesta18_tpesta@AMQUEST.COM31_Thu, 11 May 2000 13:33:53 -0400433_iso-8859-1 Thanks Mike.

-----Original Message----- From: Piontkowski Michael ML [mailto:michael.piontkowski@ASTRAZENECA.COM] Sent: Thursday, May 11, 2000 12:07 PM To: DB2-L@RYCI.COM Subject: Re: Question about UQ18604 ( V5).

Ted -

Each MOD entry in the SMP/E target zone specifies its LMOD name. The LMOD entry in the target zone specifies its SYSLIB DDNAME. The LMOD is link edited into the SYSLIB DDNAME. [...] 18169 284 25_Re: Performance of MODIFY13_Woody Lahaise33_William.Lahaise@LIBERTYMUTUAL.COM31_Thu, 11 May 2000 13:27:48 -0400378_iso-8859-1 About 7 years ago encountered such a problem with MODIFY - it is a real problem! (it was a short term contract and they wanted me to work on other problems - so never found the solution).

-----Original Message----- From: craig patton [SMTP:prgpatton@HOTMAIL.COM] Sent: Thursday, May 11, 2000 11:35 AM To: DB2-L@RYCI.COM Subject: Re: Performance of MODIFY [...] 18454 145 33_Re: Question about UQ18604 ( V5).13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 11 May 2000 12:42:57 -0500430_US-ASCII Ted, use UCLIN to delete dsnexit for the LMOD if you have multiple syslibs . ex. UCLIN . DEL LMOD(xxxxxxxx) SYSLIB(DSNEXIT) . HTH Kurt







>>> michael.piontkowski@ASTRAZENECA.COM 05/11/00 11:07AM >>> Ted -

Each MOD entry in the SMP/E target zone specifies its LMOD name. The LMOD entry in the target zone specifies its SYSLIB DDNAME. The LMOD is link edited into the SYSLIB DDNAME. [...] 18600 146 33_Re: Question about UQ18604 ( V5).13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 11 May 2000 12:48:13 -0500470_US-ASCII Sorry, forgot the ENDUCL. in last post.

Ted, use UCLIN to delete dsnexit for the LMOD if you have multiple syslibs . ex. UCLIN . DEL LMOD(xxxxxxxx) SYSLIB(DSNEXIT) . ENDUCL . HTH Kurt



>>> michael.piontkowski@ASTRAZENECA.COM 05/11/00 11:07AM >>> Ted -

Each MOD entry in the SMP/E target zone specifies its LMOD name. The LMOD entry in the target zone specifies its SYSLIB DDNAME. The LMOD is link edited into the SYSLIB DDNAME. [...] 18747 74 37_Re: Pros and Cons of table/tablespace19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 11 May 2000 12:49:12 -0500612_ISO-8859-1 Hi Bill, Along with Michael's comment, I'd add the following: ask those DBAs who recommend multi-table tablespaces if they've ever been a production, oncall DBA in a busy 24x7, high availability shop!

HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this [...] 18822 63 37_Re: Pros and Cons of table/tablespace9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 11 May 2000 12:16:20 -0600571_us-ascii Another consideration dealing the the load utility on multi-table tablespaces deals with LOAD RESUME YES LOG NO functionality. If the tables in the tablespace don't all have the same owner you can get into situations where one user will do a load resume log no of their table (DB2 allows this since they are the owner of the table) and leaves the tablespace in COPYPEND, causing havoc for the other tables in that tablespace. This can be very common in QMF environments when users execute the SAVE data command and all point at the same default tablespace. [...] 18886 128 37_Re: Pros and Cons of table/tablespace0_19_Tim.Lowe@STPAUL.COM31_Thu, 11 May 2000 13:15:39 -0500540_us-ascii I do not think that it is unreasonable to put more than 1 table in a tablespace in some situations, provided that everyone is familiar with the potential problems. Given the growth of some shops, and the limits on the number of datasets that can be open, it does seem wasteful to add an additional tablespace for a very small table. Especially if this is a small "code table" that is read-only. In fact, I have heard that in some future DB2 OS/390 release we may be able to put more than 1 index in an indexspace for the same [...] 19015 18 11_Open cursor14_James R. Brown25_brownjr@CI.RICHMOND.VA.US31_Thu, 11 May 2000 14:24:43 -0400354_iso-8859-1 Hi all,

One real quick question. Does a cursor remain open if no rows are returned?

Jim

================================================ 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. 19034 97 37_Re: Pros and Cons of table/tablespace20_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Thu, 11 May 2000 13:16:03 -0500620_- Rick, We are oncall DBAs in a very busy 24x7 high availability shop. That's why we are pushing for the single table per tablespace but since we are new to this company, our recommendations carry little if any weight!!! Bill Johnson DBA Allstate Insurance Company

> -----Original Message----- > From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] > Sent: Thursday, May 11, 2000 1:49 PM > To: DB2-L@RYCI.COM > Subject: Re: Pros and Cons of table/tablespace > > Hi Bill, > Along with Michael's comment, I'd add the following: ask those > DBAs > who recommend multi-table tablespaces if they've ever been a [...] 19132 129 37_Re: Pros and Cons of table/tablespace0_19_csutfin@AMSOUTH.COM31_Thu, 11 May 2000 13:40:27 -0500405_- Bill Another consideration is RECOVERY. You know someone will need only one of the tables recovered and want the rest to "stay the way they are". That is always an interesting fire drill about 2:00 a.m.

Just another problem to contend with. Good Luck Carol Sutfin AmSouth Bank N.A.









"Johnson, Bill (GLIC)" on 05/11/2000 01:16:03 PM [...] 19262 39 31_Re: DB2 Log records recovery !!23_AITHA, BHEEMSEN (SBCSI)23_B4AITHA@MSG.PACBELL.COM31_Thu, 11 May 2000 11:39:54 -0700664_iso-8859-1 Ed.

I am interested. Please send it to b4aitha@msg.pacbell.com

Thanx..

-----Original Message----- From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] Sent: Wednesday, May 10, 2000 6:58 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Log records recovery !!



Hello Vishy, Good news. We have a tool that will generate a summary of all your recovery points of a Tablespace by Timestamp and RBA. Be it a Quiese point by RBA, Image copy, or tablespaceset. It will also generate the complete Job JCL and Cntl cards by Pick and Chose. You simply key-in the tablespace and the application tool will display a list of Recovery [...] 19302 66 37_Re: Pros and Cons of table/tablespace0_19_Tim.Lowe@STPAUL.COM31_Thu, 11 May 2000 13:42:43 -0500415_us-ascii Bill, Can you tell me what your "RI considerations" are that make you want to use multiple tables per tablespace? Offhand, I do not see what these 2 things have to do with one another.

Thanks, Tim













"Johnson, Bill (GLIC)" on 05/11/2000 11:59:49 AM

Please respond to DB2 Data Base Discussion List [...] 19369 40 47_PowerBuilder (NT 4.0) to OS/390 DB2 UDB Problem12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 11 May 2000 13:49:17 -0500452_us-ascii Hi All.

We often open mainframe DB2 tables through the PowerBuilder 6.5 (or 7.0) Database painter.

We installed the latest refresh to DB2 UDB for OS/390 V6 last Monday.

We're using DB2 Connect Personal edition V6.1 for the interface between PB and the Mainframe DDF address space.

Here's the problem:

For some tables, we get the message: Table "blah-blah" has no columns, possible invalid table format. [...] 19410 61 36_ERROR QUERYING DB2 UDB FROM MS-QUERY7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Thu, 11 May 2000 15:51:16 -0300321_Windows-1252 Hi fellows!

I've encoutered an error when trying to query DB2/UDB 6.1 from MS-QUERY 8.00. The message is "very clear": UNKNOWN SOFTWARE EXCEPTION and nothing else... Can anyone help me? Thank you very much.

Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirantes Sao Paulo - Brazil 19472 163 37_Re: Pros and Cons of table/tablespace20_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Thu, 11 May 2000 13:52:50 -0500403_iso-8859-1 Tim, I agree that in the case of small code tables, putting more than one table in a tablespace is fine. This is the first shop that I've seen that puts very large tables in the same tablespace basically to guarantee Referential Integrity when the need to recover arises! The 2 newly hired DBAs(myself included) do not agree with this philosophy! Bill Johnson DBA Allstate Insurance Co. [...] 19636 90 37_Re: Pros and Cons of table/tablespace12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 11 May 2000 12:03:37 PDT640_- Also, There are performance considerations of having multiple users attempting to access different tables in the same tablespace at the same time. This is a SINGLE VSAM file. How many of the I/O's can occur concurrently??? Craig Patton DB2 DBA



>From: Tim.Lowe@STPAUL.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Pros and Cons of table/tablespace >Date: Thu, 11 May 2000 13:42:43 -0500 > >Bill, >Can you tell me what your "RI considerations" are that make you want to use >multiple tables per tablespace? >Offhand, I do not see what these 2 things have to do with one [...] 19727 89 37_Re: Pros and Cons of table/tablespace20_Johnson, Bill (GLIC)18_bjo23@ALLSTATE.COM31_Thu, 11 May 2000 14:03:47 -0500398_- Tim, The thinking here is that if one table becomes corrupted, then they want to recover that table and all related tables. If they are all in the same tablespace, then just recover the entire tablespace! I'm trying to gather ammunition to develop any new databases using the one table per tablespace rule. Don't kill the messenger, I agree with you. Bill Johnson DBA Allstate Insurance Co. [...] 19817 113 37_Re: Pros and Cons of table/tablespace12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 11 May 2000 12:17:26 PDT660_- Bill, If you are using system managed RI, they can do the exact same thing using tablespacesets..... Craig Patton



>From: "Johnson, Bill (GLIC)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Pros and Cons of table/tablespace >Date: Thu, 11 May 2000 14:03:47 -0500 > >Tim, The thinking here is that if one table becomes corrupted, then they >want to recover that table and all related tables. If they are all in the >same tablespace, then just recover the entire tablespace! I'm trying to >gather ammunition to develop any new databases using the one table per >tablespace [...] 19931 48 31_Re: DB2 Log records recovery !!12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Thu, 11 May 2000 12:21:43 PDT612_- Please Ed I am interested too. I'll be really appreciate if you could send me a copy to harbry_a@hotamil.com

Thanks again

harbry

>From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] >Sent: Wednesday, May 10, 2000 6:58 PM >To: DB2-L@RYCI.COM >Subject: Re: DB2 Log records recovery !! > > >Hello Vishy, Good news. We have a tool that will generate a summary of >all your recovery points of a Tablespace by Timestamp and RBA. Be it a >Quiese point by RBA, Image copy, or tablespaceset. It will also generate >the >complete Job JCL and Cntl cards by Pick and Chose. You simply key-in [...] 19980 99 51_Re: PowerBuilder (NT 4.0) to OS/390 DB2 UDB Problem12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Thu, 11 May 2000 14:34:42 -0500691_us-ascii Hi.

No, no alias's are involved. We can't open the table to see anything.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 636-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



---------------------- Forwarded by Steve Grimes/Systems/ais on 05/11/2000 02:35 PM ---------------------------



SMcLaughlin@consultec-inc.com (Scarlett McLaughlin) on 05/11/2000 02:01:12 PM





To: Steve Grimes/Systems/ais

cc:





Subject: Re:PowerBuilder (NT 4.0) to OS/390 DB2 UDB Problem [...] 20080 67 37_Re: Pros and Cons of table/tablespace11_Burch, Todd18_Todd_Burch@BMC.COM31_Thu, 11 May 2000 14:49:03 -0500543_ISO-8859-1 In the beginning, IBM created DB2 by merging an algebra book and a telephone book. IBM looked at it and (their marketing department) said it was good.

On the second day, IBM created simple tablespaces. IBM looked at them and said (from a storage administrators viewpoint) they are good.

However, there were those in the land who did not agree, because early DBAs had to compromise between ease of administration (dataset backup and recovery, blah blah blah) and application performance (actually, they still do). [...] 20148 160 37_Re: Pros and Cons of table/tablespace12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 11 May 2000 13:28:30 -0700377_ISO-8859-1 Todd- very interesting spin on such a controversial subject. Now if I may add my $.02 worth- As a dba supporting a peoplesoft application- anyone familiar with this product knows there are many many objects. In the beginning all objects were delivered as 1 database. Just to paint a picture- we would have had one database with 67 tablespaces and 5000+ tables. [...] 20309 19 20_DB2 V6 fmid question18_Sandra Lakenburger34_Sandra.Lakenburger@MAIL.SPRINT.COM31_Thu, 11 May 2000 15:42:36 -0500364_- We're starting to look at DB2 V6. When I went out to the PSP option on IBMLink I found several other fmids that I'm curious about. Does anyone know what JDB661G (TEXT Extenders SRCH GT) and/or JDB661M (TEXT Extenders SRCH MI) are? I cannot find them documented anywhere else.

Sandra Lakenburger DB2 Development Team Lead Systems and Software Support [...] 20329 165 38_Re: DB2 Connect to MVS DB2 V.5 problem14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 11 May 2000 11:29:13 -0400506_iso-8859-1 Dudley, I believe the symbolic destination has to be upper case on AIX. On NT it must be upper case. At least that has been my experience. HTH Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Kurt Sahlberg Newsgroups: bit.listserv.db2-l To: Sent: Thursday, May 11, 2000 10:52 AM Subject: Re: DB2 Connect to MVS DB2 V.5 problem [...] 20495 178 33_Re: Question about UQ18604 ( V5).12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Thu, 11 May 2000 17:19:40 -0400264_iso-8859-1 Ok, you need to drill down from the PTF to find the SYSLIB entries for what it touches. Go to GLOBAL zone to find what this SYSMOD does as MACS or MODs. Then go to the TARGET zone and look in MOD to get the LMOD references, and MAC for its SYSLIB. [...] 20674 75 45_Re: Extracting data in comma delimited format10_Juan Lanus21_jlanus@INTERAR.COM.AR31_Thu, 11 May 2000 18:31:48 -0300363_us-ascii John:

I run DB2 UDB 5.2 in NT. Surprised by your question I started the "control center" and clicked tables > oneTable > export and there I was offered an option to export in DEL format. It worked fine, see the output:

.................... msg file: SQL3104N The Export utility is beginning to export data to file "c:\ejercicios.csv". [...] 20750 463 37_Re: Pros and Cons of table/tablespace15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Thu, 11 May 2000 15:36:57 -0400300_iso-8859-1 Expand that scenerio a little and suppose that -- since you have to recover all tables in the tablespace, not just one --- the additional tables now force other tablespaces to be recovered for data to be in sync with itself. Who/how do you identify those situations easily at 3:00am! [...] 21214 241 26_Re: ProEdit vs. RC/Update?15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Thu, 11 May 2000 17:26:34 -0400426_- I don't know that I can compare them exactly, but we have both and I will tell you how we use them.

First let me say that we do not give DBADM to programmers. The DBA group controls creation of all development tables that will be moved to production. Programmers have all control over the data in the development/test version of the table, but not the deletion/creation/altering of their structure, indexes etc. [...] 21456 247 26_Re: ProEdit vs. RC/Update?15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Thu, 11 May 2000 17:46:50 -0400382_- Is there a time frame for the ProEdit series replacement? You sort of imply that you at least need RC/Query in addition to RC/Update to replace ProEdit. Is that true? What else would be needed? Does ProEdit really have the capability of creating scripts to do structure changes so that the DBA doesn't have to go find all the indexes, authority, etc before dropping a table? [...] 21704 191 25_Re: Performance of MODIFY0_18_mebert@AMADEUS.NET31_Thu, 11 May 2000 10:14:58 +0100530_iso-8859-1 Hi Per,

this has been discussed in the last days of December '99, look for subject "Re: Reorg DB2 catalog/MODIFY running time".

One solution would be to modify entries off one day (or a few days) at a time. This will not reduce the total CPU time, but will allow you to spread it out over a period of weeks, and it also won't block SYSCOPY for hours at a time. Of course this will mean hundreds of thousands or millions of MODIFY steps, but it's easy to write a REXX or SAS job to generate your JCL. [...] 21896 32 15_Re: Open cursor9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 11 May 2000 16:26:06 -0600405_us-ascii The cursor will remain open until an explicit close of the cursor or the application terminates/ends its thread/connection to DB2. You can verify this by adding another OPEN CURSOR after the fetch that returns no rows and you will see that you get an SQL error -501 stating the cursor is already open. Also with V6 functions, you may see -472 - Cursor was left open by an external function. [...] 21929 67 41_IBM Authorized DB2 Education and Training24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 11 May 2000 19:42:20 -0700822_us-ascii

Our Baltimore schedule of classes for May 2000 - January 2001 is listed on our revised web site at http://www.thefillmoregroup.com. Choose "Public Classes".

Thanks, Frank



+-------------------------------------+--------------------------------------+ | Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 | | The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs | | 3213-A Corporate Court | E-mail: fillmore@ws1.tfg-rdbms.com | | Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com | | USA | | +-------------------------------------+--------------------------------------+ | DB2 Family, Oracle, Client/Server, Distributed Database | | "Relational Database Solutions"(sm) | +----------------------------------------------------------------------------+ 21997 169 78_IN CORRECT RESULTS ON VERSION 6.1 - or are the incorrect results really in V5?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 12 May 2000 09:52:37 +1000430_iso-8859-1 Angelo,

What platform are you on? The way SQL actually works (as distinct from how it _should_ work) is different on different platforms.

However, I would suggest that it is the V5 results that are wrong.

Let me explain what I think you are talking about (because without actual data from the underlying tables, I can't be sure what results you should be getting), and we'll see what happens. [...] 22167 85 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 10 May 2000 23:31:48 -0500551_us-ascii True. We have the 1.6G max virtual pools now. That is not an issue for us.

Jim Lewandowski



Toine Michielse wrote: > > Jim, > > Haven't been following the thread for a while but here's one consideration. > If you keep dirty pages around until checkpoint then it will also take a > longer time for pages to be able to be moved to hiperpool. As a result you > will need a larger virtual pool. In a lot of installations I've worked > with, hiperpools are a good way to reduce the virtual storage requirement > of DBM1. [...] 22253 124 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 10 May 2000 23:37:38 -0500398_us-ascii DAVIS, RICK (SBCSI) wrote: > > Jim, > I tend to agree with you that, given the right circumstances, I > should exploit I/O subsystem capabilities. But again, this must be weighed > against OS390 overhead (which steals CPU clicks from all tasks including > DB2) and the suspended tasks waiting on those pages during the I/O. The > longer the I/O takes to complete the longer the wait. [...] 22378 63 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 10 May 2000 23:55:57 -0500511_us-ascii Mike Turner wrote: > > Let me add my two pence worth (about 3 cents at today's exchange rate). The > discussion about 128 pages seems to me to have missed one minor point. It > is my understanding that, when DB2 schedules an async write task, that task > will write up to 128 pages from its associated pageset. However this is > done by multiple Write I/Os, each of which can be for up to 32 pages. I > believe that the 150 CI boundary applies to the pages written in a single > write I/O and not [...] 22442 126 38_Re: Rejected posting to DB2-L@RYCI.COM15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 11 May 2000 00:00:04 -0500549_us-ascii again in case?

L-Soft list server at RYCI.COM (1.8d) wrote: > > > resending? > Unknown command - "RESENDING?". Try HELP. > > > L-Soft list server at RYCI.COM (1.8d) wrote: > Unknown command - "L-SOFT". Try HELP. > > >> > >> Your message is being returned to you unprocessed because it appears to have > >> already been distributed to the DB2-L list. That is, a message with identical > >> text (but possibly with different mail headers) has been posted to the list > >> recently, either by you or by someone else. If you have a [...] 22569 193 38_Re: Rejected posting to DB2-L@RYCI.COM15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 11 May 2000 00:00:30 -0500549_us-ascii again in case...

L-Soft list server at RYCI.COM (1.8d) wrote: > > > resending > Unknown command - "RESENDING". Try HELP. > > > L-Soft list server at RYCI.COM (1.8d) wrote: > Unknown command - "L-SOFT". Try HELP. > > >> > >> Your message is being returned to you unprocessed because it appears to have > >> already been distributed to the DB2-L list. That is, a message with identical > >> text (but possibly with different mail headers) has been posted to the list > >> recently, either by you or by someone else. If you have a [...] 22763 33 21_Performance of MODIFY28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 11 May 2000 14:02:42 PDT376_- Per,

Yes you will miss additional cleanup done by MODIFY. It also cleans up SYSLGRNX. Simply deleting SYSCOPY rows by whatever mechanism does *NOT* equate to MODIFY utility.

As I have posted before, adding new indexes to SYSCOPY does *NOTHING* to improve performance. The code uses an internal protocol which uses only the index it is told to use. Sorry. [...] 22797 39 41_MODIFY ISSUES - TO APAR OR NOT TO APAR???28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 11 May 2000 19:15:03 PDT501_- The two biggest problems with MODIFY performance require code changes.

First, an internal SQL-like protocol is used which is not optimal for the scan/locate/delete processing of modify. It is interesting that the DROP TABLESPACE equivalent code does *NOT* use this interface.

Second, locking was changed in Version 4 to improve concurrency on SYSCOPY and we paid a TERRIBLE price in performance. And to make matters worse, these two problems combine with even worse consequences. [...] 22837 41 62_See Database-GUYS coolest new DB2 UDB Tools at IDUG in Dallas!11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Thu, 11 May 2000 22:29:30 -0400494_us-ascii Dear IDUG Attendee,

It's a miracle! We can now predict the future! DB2 UDB UNIX users around the world are giving high praises to the Database-GUYS(TM) newest performance tool innovations.

Please be sure to visit our booth #205 and find out what all the excitement is about. While there, please take a peak at our DB2 UDB Performance Management Tool Suite, an integrated set of tools that can help you find any performance problem in 10 minutes or less! GUARANTEED! [...] 22879 18 37_Re: Pros and Cons of table/tablespace12_Raymond Bell20_raymondb@NZ1.IBM.COM31_Fri, 12 May 2000 15:02:55 +1200390_us-ascii Actually, Mike, I'm sure you'd have at least a dollar... (I know I would)



Raymond Bell DB2 DBA IBM New Zealand (contracting)

================================================ 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. 22898 31 8_SYSLGRNX28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 11 May 2000 20:21:57 PDT330_- Andreas,

The "Deleting SYSLGRNX" section in the DGREF has been removed. It is simply wrong. For as long as I can remember (and I checked code back thru V4) DB2 deletes obsolete SYSLGRNX records when a tablespace is dropped. If it isn't, its a bug.

I've asked the writers to correct all SYSLGRNX misspellings. [...] 22930 25 45_Re: MODIFY ISSUES - TO APAR OR NOT TO APAR???0_17_JTonchick@AOL.COM29_Thu, 11 May 2000 23:51:51 EDT549_US-ASCII I agree with Dan. If you believe that any part of DB2 is not performing as you believe it should, call the support center. If everyone that posts a note to this newsgroup agreeing with a common complaint, and no one reports the problem to IBM, the problem will never get fixed. IBM is not like Microsoft. You don't have to wait until the "next release" or "second edition" of a software product to get code fixes. SMP/E works much better than a web patch download, and it has a RESTORE function if a fix causes more problems. Try that [...] 22956 49 32_Re: Question about UQ18604 ( V5)0_27_uwe.haeberle@ROTO-FRANK.COM31_Fri, 12 May 2000 08:48:35 +0100612_us-ascii Hi,

we had a similar problem with a DB2 V6 PTF that needs DSNZPxxx and DSNHDECP, the two member that normaly resides in the SDSNEXIT library. The problem seems, that during installtion/migration DSNTIJUZ uses the suffix you speficy on panel DSNTIPA1 for your SDSNEXIT as the DD name in the actual SMP/E apply. For example one of our SDSNEXIT DSN is called DSN610.SDSNEXIT.C11 (C11 is the subsystem identifier). So SMP/E uses C11 as the DDNAME for the SMP/E APPLY! Maybe you misspelled SDSNEXIT in DSNTIPA1. Refer to Info-APAR II07177 where the actual solution via a SMP/E UCLIN REP LMOD Job [...] 23006 37 31_Re: Pager or Email Notification17_suthep thampranee18_suthepth@SCB.CO.TH31_Fri, 12 May 2000 14:17:04 +0700661_Windows-874 HI I've tried SMTP( Simple Mail Transfer Protocol) and AFOPER. My opinion,AFOPER is better than SMTP.

Regards, JOE

---------- > From: Edward(Ed) J. Finnell, III > To: DB2-L@RYCI.COM > Subject: Re: Pager or Email Notification > Date: 11 ¾ÄÉÀÒ¤Á 2543 3:38 > > We,re testing a similar model now. They're so fancy that can take > pages, eMail, or voice phone messages. Don't know if it's just us or > the service but there seems to be more dead spots than regular > beepers. > Edward(Ed) J. Finnell, III > Enterprise Systems/Proj. Mgr. > url:www.ua.edu > > ================================================ > [...] 23044 79 74_Re: Difference between IN and EXISTS predicates in a correlated subqueries10_Sanjeev ..24_ssethi@LOT.TATASTEEL.COM29_Fri, 12 May 2000 07:33:11 GMT355_us-ascii Hi harbry, I think we had this discussion before but just to refresh myself as well , As far as my idea ,if we take all the combinations :

Large Outer table + Large Inner table - EXISTS /JOIN Large Outer table + Small inner table - IN Small outer table + Large inner table - EXISTS / JOIN Small outer table + Small inner table - JOIN [...] 23124 166 34_Re: Performance of MODIFY/SYSLGRNX0_18_mebert@AMADEUS.NET31_Fri, 12 May 2000 09:40:06 +0100410_us-ascii The thing I would like to know (and I think Andreas too, if I understood correctly) is, how do you get rid of SYSLGRNX entries belonging to DROPped tablespaces? Can't run MODIFY on those!

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







From: "DAVIS, RICK (SBCSI)" on 11/05/2000 17:03 GMT [...] 23291 51 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 12 May 2000 03:48:52 -0400581_ISO-8859-1 Thanks for the confirmation Joel. I am sometimes afflicted by self-doubt!

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

Message text written by DB2 Data Base Discussion List >Right on the money Mike..... even with current exchange rates. Regards, Joel



Message text written by DB2 Data Base Discussion List >Let me add my two pence worth (about 3 cents at today's exchange rate). The discussion about 128 pages seems to me to have missed one minor point. It= [...] 23343 119 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 12 May 2000 10:38:54 +0100448_us-ascii Jim,

If you are seriously saying that you have maxed out your bufferpools to 1.6G then believe me, it *WILL* become an issue sooner or later.. I suspect sooner.

Regards,

Toine Michielse



Jim Lewandowski @RYCI.COM> on 05/11/2000 05:31:48 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 23463 128 37_Re: Pros and Cons of table/tablespace12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 12 May 2000 09:54:00 +0100379_iso-8859-1 There are indeed pros and cons, it all depends on the context, here's some issues off the top of my head for Multiple Tables:

Pro === Less dataset opens Faster system recovery to copy (less datasets) Less sensitive to space problems / wasted space Handy to put lots of unused tables from packages in (eg. SAP, Peoplesoft) Easy to recover a referential set [...] 23592 49 32_Re: HSM migrating data to level214_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 12 May 2000 11:14:30 +0200363_us-ascii Absolutely NO. In production ALL DB2 linear dataset MUST be out of HSM control.

IN previous shop where I worked HSM admin create an ad hoc management class to

avoid HSM migration to ML1 & ML2. You can migrate some DB2-related datasets (for

instance unload ds, DASD image copy datasets or GDGs, etc.). It's very dangerous to let [...] 23642 23 40_Re: Log only recovery of old static data14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 12 May 2000 11:50:09 +0200359_us-ascii I think that recover LOGONLY tests PGLOGRBA in header page and search for

log records having RBA > PGLOGRBA, without requesting any log or archive tape if

there were no update. In version 2.3 DB2 scanned ALL logs to find record, but with pseudo close

feature and RECOVER LOGONLY (since v 3) you can avoid this boring thing. [...] 23666 28 29_Re: DB2 for Quality assurance14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 12 May 2000 12:06:59 +0200317_us-ascii There are many ways/instrument to assure data quality, but from my personal experience one

of the main rule is: the probability of bad data or a real mess is directly proportional to the number

of people that can update data or can submit jobs. Try to keep this number as low as possible. [...] 23695 31 18_QMF command EXPORT14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 12 May 2000 12:42:47 +0200428_us-ascii I don't remember who asked for it, but below there's an example of EXPORT command

in a REXX execs using DSQCIX:

CALL DSQCIX "START" CALL DSQCIX "RUN QUERY MAX01" CALL DSQCIX "PRINT REPORT" CALL DSQCIX "DISPLAY CHART" CALL DSQCIX "EXPORT CHART (MEMBER=ICU0X ICUFORM=BAR" CALL DSQCIX "EXIT"

This REXX sample exports a CHART created by QMF for a subsequent display (in REXX exec) via GDDM bridge [...] 23727 22 25_Re: Performance of MODIFY11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Fri, 12 May 2000 06:18:20 -0500577_- Dan, In a recent post to DB2-L, you stated "...As I have posted before, adding new indexes to SYSCOPY does *NOTHING* to improve performance...".

Is it fair to say this performance reference relates to DB2 utility performance and not a user's SQL statement from SYSCOPY.

TIA.

Regards, John Rosser Duke Energy Corp

================================================ 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. 23750 176 31_REXX in the NT Operating System23_Sercombe, George W A13325_George.Sercombe@CIGNA.COM31_Fri, 12 May 2000 07:39:13 -0400535_iso-8859-1 DB2 Community,

Does anyone have experience in the development of REXX programs that interact with UDB NT for execution of simple SQL statements and also UDB commands like; RUNSTATS and REORG's. I attempted to migrate a "Visual REXX" routine from the OS/2 operating system to NT and was successful until a call to SQLDBS for the Runstat or Reorg statement execution. Then a -1650 SQLCODE error, API not supported. If you have a recommendation about resolving my problem I would truly appreciate hearing from you. [...] 23927 145 32_RES: DB2 Log records recovery !!25_Walter De Assis Guimaraes32_walter.guimaraes@UNIBANCO.COM.BR31_Fri, 12 May 2000 08:51:49 -0300703_iso-8859-1



Ed.

I am interested too. Please send it to walter.guimaraes@unibanco.com.br



Thanks.

Walter

-----Original Message----- From: Edward C. Benoit Jr. [mailto:DB2Automate@AOL.COM] Sent: Wednesday, May 10, 2000 6:58 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Log records recovery !!



Hello Vishy, Good news. We have a tool that will generate a summary of all your recovery points of a Tablespace by Timestamp and RBA. Be it a Quiese point by RBA, Image copy, or tablespaceset. It will also generate the complete Job JCL and Cntl cards by Pick and Chose. You simply key-in the tablespace and the application tool will display a list [...] 24073 25 8_SYSLGRNX17_Andreas Constanti24_andreas.constanti@AGI.CH31_Fri, 12 May 2000 14:03:48 +0100443_us-ascii Dan,

You mean the "Deleting SYSLGRNX" section in the SQL Ref., not DGREF ?

Here is one scenario about the "left behind" SYSLGRNX records:

1. Create a Tablespace and a Table in it. 2. Do some Inserts, Updates etc. 3. REPORT RECOVERY showed no rows in SYSCOPY and some rows in SYSLGRNX. 4. Drop the Tablespace. 5. A DSN1PRNT (FORMAT) of the SYSLGRNX shows me the entries are still there as RECORDs, not HOLEs. [...] 24099 165 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 12 May 2000 07:21:19 -0500500_ISO-8859-1 Hi Jim, Thanks for comments. And, as I told Michael, I'm not taking "cheap shots" at you or anyone else. I, like you, am trying to gain the knowledge I need to improve DB2 performance. I guess I still miss your point; its pretty early in the morning for me. When considering backwrites, why do you feel locality-of-reference moot in your environment? OS390 schedules and dispatches all work, including SRBs, SIOs, and I/O completion notification. Why do you feel this can be ignored? [...] 24265 49 35_AW: REXX in the NT Operating System0_20_mark.nicholls@TUI.DE31_Fri, 12 May 2000 14:22:59 +0200359_iso-8859-1 George,

the code looks fine. We migrated some similar scripts from OS/2 and now use the rexx that came with UDB/NT V5, this is packaged with the dll's necessary for the sqldbs call. The rexx and dll's are in sqllib\samples\rexx.

HTH. Mark Nicholls Certified DBA for UDB V5

Mark Nicholls Business Intelligence GmbH Germany [...] 24315 222 34_Re: Performance of MODIFY/SYSLGRNX19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 12 May 2000 07:46:21 -0500600_ISO-8859-1 Hi Doc, I think you could. Couldn't you simply DDL CREATE the TABLESPACEs you find with an empty table, Image Copy the empty table, run MODIFY (which should delete all the old rows in SYSLGRNX), then DROP the TABLESPACE?

Regards, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify [...] 24538 104 37_Re: Pros and Cons of table/tablespace4_IBM116_IBM1@UBIL.COM.TR31_Fri, 12 May 2000 15:32:12 +0300676_- todd,

dante's nothing to this!!

ciao!

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



> -----Original Message----- > From: Burch, Todd [SMTP:Todd_Burch@BMC.COM] > Sent: Thursday, May 11, 2000 10:49 PM > To: DB2-L@RYCI.COM > Subject: Re: Pros and Cons of table/tablespace > > In the beginning, IBM created DB2 by merging an algebra book and a > telephone > book. IBM looked at it and (their marketing department) said it was good. > > On the second day, IBM created simple tablespaces. IBM looked at them > and > said (from a storage administrators viewpoint) they are good. [...] 24643 47 34_Re: Performance of MODIFY/SYSLGRNX11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 12 May 2000 08:56:20 -0400643_ISO-8859-1 Rick

At the very least, you would have to create the tablespace with the same DBID, PSID, and OBID of the original. Not easy to do. Even then I would not be at all surprised if it did not do what you want.

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

Message text written by DB2 Data Base Discussion List >Hi Doc, I think you could. Couldn't you simply DDL CREATE the TABLESPACEs you find with an empty table, Image Copy the empty table, run MODIFY (which should delete all the old rows in SYSLGRNX), then DROP the TABLESPACE? [...] 24691 70 34_Re: Performance of MODIFY/SYSLGRNX19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 12 May 2000 08:19:09 -0500619_ISO-8859-1 Hi Mike, Yes, very difficult to do. Oh well, at least I tried. Regards, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly [...] 24762 253 34_Re: Performance of MODIFY/SYSLGRNX12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 12 May 2000 06:22:34 PDT665_- Doc, Be carefull with DBIDs and PSIDs and OBIDs as THAT is included in the SYSLGRNX. These rows are NOT stored by the Tablespace NAME....It appears you would have to create tablespaces with the SAME DBD information......Any thoughts on this from IBM???? HTH, Craig Patton



>From: "DAVIS, RICK (SBCSI)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Performance of MODIFY/SYSLGRNX >Date: Fri, 12 May 2000 07:46:21 -0500 > >Hi Doc, > I think you could. Couldn't you simply DDL CREATE the TABLESPACEs >you find with an empty table, Image Copy the empty table, run MODIFY (which [...] 25016 28 13_REXX question0_24_lightsey@ITS.STATE.MS.US31_Fri, 12 May 2000 08:13:52 -0500487_us-ascii Not really list relevant, but I am looking at using REXX as CGI scripts from Open Edition HTTP server on OS/390 to access DB2, Adabas and VSAM data. The provided documentation (such as it is) is pretty vague about what to do to get to programs on the TSO side from the unix side. I have TSO Rexx execs that will do what I want but I need some guidance on how to convert them to run on the unix side. Can anyone please point me to the references/ url / provide examples ??? [...] 25045 92 33_Re: Question about UQ18604 ( V5).9_Ted Pesta18_tpesta@AMQUEST.COM31_Fri, 12 May 2000 09:30:12 -0400593_iso-8859-1 Tom, I did as you suggested. The LMOD and MAC entries all had the correct SYSLIB names in the entries. Your suggestion reminded me that there is an "Element Summary Report" generated during the APPLY CHECK processing. Why I didn't recall this sooner is beyond me. I found a reference to DSNEXIT for the zparm member we use with one of the subsystems. Since this is a non-default name, I'm guessing it was added/modified so that is would automatically reassemble the zparm when DSN6SYSP was changed. It had both DSNEXIT and SDSNEXIT listed for its SYSLIB. I used the statements [...] 25138 23 8_DSNI009I16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Fri, 12 May 2000 10:33:39 -0400418_iso-8859-1 Hey Folks... We have a distributed application that is trying to insert into a table. The owner is BUSOBSYS. When we invoke the app, we receive a DSNI009I, which states, Data Base Edit Procedure BUSOBSYS Could Not Be Loaded. We don't have any edit procs on the tableand BUSOBSYS has SYSADM authority. We're at DB2 V5 and using DB2 Connect PE as the middleware. Any help would be appreciated. Thanks... [...] 25162 55 36_DYNAMICRULES(BIND) and RACF Security0_22_BILL_GALLAGHER@PHL.COM31_Fri, 12 May 2000 10:58:44 -0400422_us-ascii Hi,

We ran into a situation here earlier this week while converting the DB2 authorizations from one of our applications from native DB2 security to RACF. The problem has to do with dynamic SQL being issued from an application program and an apparent difference between the way native DB2 security is working and the way RACF/DB2 security is working with the DYNAMICRULES(BIND) bind package parameter. [...] 25218 24 8_SYSLGRNX17_Andreas Constanti24_andreas.constanti@AGI.CH31_Fri, 12 May 2000 17:04:20 +0100372_us-ascii Dan,

And here is another scenario about the "left behind" SYSLGRNX records:

- REPORT RECOVERY shows 1 row in SYSCOPY and 1 row in SYSLGRNX. - I drop the tablespace (without a prior MODIFY) - I QUIESCE the SYSLGRNX tablespace with WRITE YES to make sure changed pages are externalized to DASD. - DSN1PRNT shows the SYSLGRNX record still exists. [...] 25243 72 75_Re: Difference between IN and EXISTS predicates in a correlated s ubqueries20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 12 May 2000 10:00:45 -0400578_us-ascii Harbry,

The exists uses in-memory 4k wrap around table. This means that if you have duplicate results sets that could stay in that 4K in-memory than EXIST avoids getpages and thereby improves performance. On the other hand if you have a unique index on the correlated column then in-memory table has no use and probably DB2 will not even use it. The exist has no advantage in those situations. Also if in those situations (unique index available on the correlated column for the inner table) DB2 would even force your EXIST to convert to a JOIN internally. [...] 25316 75 8_Re: JDBC14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 12 May 2000 11:47:01 -0400268_- Larry, Thanks for the reply and phone call. I'm in vaction mode right now. I'm leaving for St. Maarteen tomorrow morning, so JDBC is on the back burner. I have done the setup but I do have some questions for you. I'll call you when I'm back. Thanks again, Dean [...] 25392 16 48_Passing the System Code From a DB2 batch Utility12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Fri, 12 May 2000 12:06:25 -0500279_iso-8859-1 Does anyone know how to pass the system code from a batch DB2 utility to a batch Rexx following that utility in the JCL. If I can get the SQLCODE to the next step I have a batch QW to list a description of that error.

Thanks for the help, I appreciate it! [...] 25409 43 52_Re: Passing the System Code From a DB2 batch Utility11_Burch, Todd18_Todd_Burch@BMC.COM31_Fri, 12 May 2000 12:46:07 -0500370_ISO-8859-1 You cannot influence this type of behavior with IBM utilities, but, taking another route, the solution is easy, and work with non-IBM utilities as well.

Write the rexx exec so that it runs unonditionally right after the batch utility and have it read and parse the utility SYSPRINT. Point the utility SYSPRINT to a member of a PDS or a seq. file. [...] 25453 79 37_Re: Long Running Query to Find "Gaps"13_Matheny, Bill25_bill.matheny@EXPERIAN.COM31_Fri, 12 May 2000 11:09:26 -0700547_- I can see why the query would run so long. Using an arithmetic function in your sub-select will result in tablespace (or index) scans each time that sub-select is utilized. The bottom line is that even so, the query as written is not going to give you what you need. Specifically, your select should be SELECT A.EMPLR_ID + 1; otherwise, you'll get the id that EXISTS on your table - not the one that's missing. The other problem I see is that at BEST you'll only get the FIRST id of any gap, because you're only checking the ID immediately [...] 25533 26 33_Another Archive log size question8_Bob Byrd14_BBYRD@PCMH.COM31_Fri, 12 May 2000 14:06:45 -0400590_US-ASCII This topic has come up before, but, just wondering what others have actually been able to size and fit on a 3490E tape device for archive.

We want near tape capacity on our archives.

We plan, next Wednesday, to increase our production db2 active logs from 288 (3390) cyls to 3112 cyls. We use 3390 model 3 dasd devices (RVA) so compression occurs at the hardware. We use 3490E tape devices, and compression occurs there also. I have tested DFSMS adrdssu logical backups of "initalized new logs" using alldata option and one tape is used. I am only attempting to [...] 25560 48 17_Re: REXX question14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Fri, 12 May 2000 11:08:35 -0700626_us-ascii Have you had a look at the Net.Data documentation? I have used REXX in that context. It works. HTH Roy





Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Roy Reynolds/SB/GAPINC) Subject: REXX question





Not really list relevant, but I am looking at using REXX as CGI scripts from Open Edition HTTP server on OS/390 to access DB2, Adabas and VSAM data. The provided documentation (such as it is) is pretty vague about what to do to get to programs on the TSO side from the unix side. I have TSO Rexx execs that will do [...] 25609 23 25_Remote Client conn. prob.13_Ken Martinson25_Ken.Martinson@SHAWINC.COM31_Fri, 12 May 2000 15:39:47 -0400575_us-ascii I'm a newby at DB2, so forgive me if this is elementary. I've just installed UDB for AIX. As an AIX user (db2inst1) connecting is no problem using the command format "db2 connect to sample". But, when I try to connect from an NT station or from an AIX session, using the command format "db2 connect to sample user db2inst1 using password" I get a SQL1402N error msg. Looking the error up, it says that the pgm "db2ckpw" may have the wrong permissions. They were at "400", I've changed them to "777". That didn't help. The database manager config authentication [...] 25633 20 29_Re: DB2 for Quality assurance10_Feeny, Jim23_Jim_Feeny@COMPUWARE.COM31_Fri, 12 May 2000 15:53:09 -0400453_iso-8859-1 Monica:

You may also want to consider DBA-XPERT for DB2 from Compuware.

With this you can clone your production environment easily and quickly.

Jim Feeny Product Manager Compuware

================================================ 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. 25654 13 33_Craig Mullins DBA Online Magazine0_20_bjnigh@HOUSEHOLD.COM31_Fri, 12 May 2000 14:28:30 -0700348_us-ascii Does anyone have the url address for the Craig Mullin DBA magazine? I accidentally missplaced it.

================================================ 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. 25668 29 37_Re: Craig Mullins DBA Online Magazine12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Fri, 12 May 2000 16:38:24 -0500649_iso-8859-1 FYI Folks... check out a new on-line magazine for DBAs at http://www.dbazine.com/



-----Original Message----- From: bjnigh@HOUSEHOLD.COM [mailto:bjnigh@HOUSEHOLD.COM] Sent: Friday, May 12, 2000 4:29 PM To: DB2-L@RYCI.COM Subject: Craig Mullins DBA Online Magazine



Does anyone have the url address for the Craig Mullin DBA magazine? I accidentally missplaced it.

================================================ 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. [...] 25698 27 37_Re: Craig Mullins DBA Online Magazine23_Mulkey, DW David (7091)21_MulkeyDW@GVL.ESYS.COM31_Fri, 12 May 2000 16:37:21 -0500553_- www.dbazine.com

> ---------- > From: bjnigh@HOUSEHOLD.COM[SMTP:bjnigh@HOUSEHOLD.COM] > Sent: Friday, May 12, 2000 4:28 PM > To: DB2-L@RYCI.COM > Subject: Craig Mullins DBA Online Magazine > > Does anyone have the url address for the Craig Mullin DBA magazine? I > accidentally missplaced it. > > ================================================ > 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. > [...] 25726 120 38_Re: DB2 Connect to MVS DB2 V.5 problem12_Dudley Moore16_dumoore@NMSU.EDU31_Fri, 12 May 2000 15:31:48 -0600568_iso-8859-1 Hello Kurt,

I'm using SNA, so I guess its not a problem. I read in the APPC, CPI-C, and Sense Codes on the web that a CPI-C return code of 1 causes the conversation to be placed into a 'reset' state, and the connection should not be tried again until corrected. I assumed restarting Communication Server, and DB2 Connect on AIX, and restarting DDF, and varying the lu on MVS would accomplish the 'reset' because it doesn't state how to reset the conversation. But this didn't change the abend code. CPI-C is a foreign object to me. I'm going to [...] 25847 42 45_New draft red book on the web V6 Tech. Update12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 12 May 2000 21:35:19 -0500610_- If you want more information about the functions provided in DB2 Version 6 after general availability, then the draft book is out on the web now. It's still a draft, so you can expect to find that it's not perfect.

DB2 UDB Server for OS/390 Version 6 Technical Update, SG24-6108-00

This redbook, in the format of a presentation guide, describes the changes introduced to date in DB2 UDB Server for OS/390 Version 6 since its general availability in June 1999. Several enhancements have been provided through service in order to meet the increasing demands of customers and vendors for new [...] 25890 40 47_Re: References to SDSNLOAD in link-edit SYSLIBs11_Thomas Berg16_thomas@TBERG.NET31_Sun, 14 May 2000 00:42:10 +0200606_us-ascii Why not use ALIAS in Your proc's ? (The alias should have an non-version dependent name, example: DB2.DB2x.SDSNLOAD where x = DB2-system.)

Thomas Berg

paul.packham@POSTOFFICE.CO.UK wrote: > > Hi, > > Currently we use non-version specific data set high level qualifiers for our DB2 > code. We are thinking of moving to using the standard IBM data set names which > contain a version specific HLQ. Because we do not change the HLQ between > versions we do not currently have to alter the link-edit SYSLIB concatenation in > our compile PROCs. I wondered how the change of HLQ was [...] 25931 27 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 13 May 2000 12:34:52 -0500525_us-ascii Toine Michielse wrote: > > Jim, > > If you are seriously saying that you have maxed out your bufferpools to > 1.6G then believe me, it *WILL* become an issue sooner or later.. I suspect > sooner. > > Regards, > > Toine Michielse

Please explain.

Jim Lewandowski

================================================ 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. 25959 56 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 13 May 2000 12:46:23 -0500408_us-ascii DAVIS, RICK (SBCSI) wrote: > > Hi Jim, > Thanks for comments. And, as I told Michael, I'm not taking "cheap > shots" at you or anyone else. I, like you, am trying to gain the knowledge I > need to improve DB2 performance. > I guess I still miss your point; its pretty early in the morning for > me. When considering backwrites, why do you feel locality-of-reference moot > in your environment? [...] 26016 37 24_DB2/Omegamon discrepancy15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 13 May 2000 13:12:12 -0500518_us-ascii I happened to be looking at thread history detail and found something interesting (option A).

ASYNCH read I/O 238 events, elapsed time approx 1 second.

Well, I was shocked to see this as we have ALL the data in buffers for this transaction.

Looking at the bufferpool detail (option I)

I see there were seq. prefetch requests but no prefetch pages read. There were hiperpool reads but that implies NOT having a physical I/O since you can't read directly into a hiperpool page. [...] 26054 30 45_Re: VERTICAL DEFERRED WRITE THRESHOLD SETTING15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 13 May 2000 13:14:14 -0500408_us-ascii DAVIS, RICK (SBCSI) wrote: > > Hi Jim, > Thanks for comments. And, as I told Michael, I'm not taking "cheap > shots" at you or anyone else. I, like you, am trying to gain the knowledge I > need to improve DB2 performance. > I guess I still miss your point; its pretty early in the morning for > me. When considering backwrites, why do you feel locality-of-reference moot > in your environment? [...] 26085 48 27_Re: Defragging DB2 Volumes?13_Dana Nicholis26_dana.nicholis@ZURICHUS.COM31_Sun, 14 May 2000 10:33:06 -0500418_us-ascii We did get burned with ADRDSSU on OS390/2.6 moving a multi-volume dataset, there was a fix but I don't have the doc anymore. Fortunately it was an index and we just recovered. We use FDR Compaktors for "defragging", and even better it can reduce dataset extents.















Scarlett McLaughlin on 05/11/2000 10:29:51 AM [...] 26134 83 45_Re: Extracting data in comma delimited format0_29_Greg.Palgrave@BANKWEST.COM.AU31_Mon, 15 May 2000 10:17:39 +0800624_us-ascii Only problem is that John said : "My shop uses OS/390 DB2 V5.1.", not UDB/NT..... Big DB2 vs. Little DB2 :)

Cheers,

Greg Palgrave



Please respond to DB2 Data Base Discussion List

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

Subject: Re: Extracting data in comma delimited format







John:

I run DB2 UDB 5.2 in NT. Surprised by your question I started the "control center" and clicked tables > oneTable > export and there I was offered an option to export in DEL format. It worked fine, see the output: [...]