1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 1999, week 2
2 34 60_REXX & DB2 interface : a link to download DB2WWWx (+ TASID).14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 4 Jan 1997 19:33:49 +0100527_us-ascii I told about a link for a REXX interface (DB2WWWX) and someone ask me more info, so I
search the page and I found it. The links are:
http://www.s390.ibm.com/nc/sntc/DB2IMSRX.html download page of pax file with instructions
http://www.s390.ibm.com/nc/download.html Main page
The following link:
http://www-4.ibm.com/software/ad/ispf/downloads/
is a page containig mini-monitor TASID for MVS-S/390, very useful.db2
Greetings Max Scarpa Data & system Admin Cesve SpA [...]
37 127 34_Re: Unsuccessful RID Pool Accesses14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU30_Wed, 8 Dec 1999 18:30:45 +1100334_iso-8859-1 Brian,
Alternatively, if index screening is the issue and you are unlikely to apply the V5 APAR or upgrade to V6 in the near future, then you may want to consider converting index screening predicates to index matching predicates. Therefore, the number of RIDs will be reduced before the RID sort is attempted. [...]
165 144 20_Re: SQL in a Trigger0_24_markus.schaub@SYSTOR.COM30_Wed, 8 Dec 1999 09:00:11 +0100465_us-ascii hi richard
we are migrating an application from udb v5.2 to os390 v6 and got the same sql-error. we have found the apar nr. pq30383. is this the one you mentioned ?
thanks and regards markus
Richard A Yevich on 08.12.99 05:28:05
Please respond to ryevich@ibm.net
To: DB2-L@RYCI.COM cc: (bcc: Markus Schaub/T084271/SYSTOR) Subject: Re: SQL in a Trigger [...]
310 103 9_Reg - CWI27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM30_Wed, 8 Dec 1999 15:47:58 +0530366_iso-8859-1 Hi Gurus! I am working on a prototype where I am Web Enabling a CICS transaction. I am using 3270 bridge with Cics Web Interface.
If I need to just call a transaction from a Web Browser, I connect to the mainframe like this... http://ip:port/cics/cwba/dfhwbtta/transactionid
It works fine and throws the green screen onto the HTML page [...]
414 18 20_Is the list working?17_Jose D. Lora-Diaz14_jjlora@IBM.NET30_Wed, 8 Dec 1999 07:25:37 -0500401_us-ascii Hi, I would like to know is the discussion list is working, because I am not receiving any post since december 3,1999. Thanks Jose Lora jjlora@ibm.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.
433 63 26_Re: Erwin and index names?18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Wed, 8 Dec 1999 07:03:02 -0600601_iso-8859-1 Mike, you can modify the create index naming macro within Erwin. First select TARGET on the toolbar, then TARGET SERVER from the menu. The dialog box where you can edit the macro is labeled: Index Name Macro. The Reference Guide provides all syntax requirements and available macros.
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 [...]
497 23 8_ICTYPE B0_18_mebert@AMADEUS.NET30_Wed, 8 Dec 1999 14:13:27 +0100379_us-ascii Hello all,
I just discovered that we have two entries in our SYSIBM.SYSCOPY with ICTYPE='B', for DSNDB01.DSNLLX01 & DSNLLX02 (Indexes on DSNDB01.SYSLGRNX). These entries obviously come from a RECOVER INDEX (during a Cat/Dir Reorg), but this ICTYPE is not described in our SQL Reference (Appendix D). Can someone provide me with a description for ICTYPE='B'? [...]
521 52 12_Re: ICTYPE B18_Martinson, Barbara25_Barbara_Martinson@BMC.COM30_Wed, 8 Dec 1999 07:24:36 -0600523_ISO-8859-1 A point-in-time recovery is recorded in SYSIBM.SYSCOPY. The SYSCOPY row defines the range of log logically eliminated by a point-in-time recovery. The values recorded are: ICTYPE = 'P' for a table space, 'B' for an index space PIT_RBA (an LRSN) defines the low end of the range and corresponds to the LRSN in the TOLOGPOINT request or the LRSN of the image copy named in a TOCOPY request. START_RBA (an LRSN) defines the high end of the range and corresponds to the execution of the point-in-time recovery. [...]
574 321 31_FW: SAP Chooses DB2 Over Oracle16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Wed, 8 Dec 1999 08:17:53 -0500643_iso-8859-1 FYI
> -----Original Message----- > From: dbswift@us.ibm.com [mailto:dbswift@us.ibm.com] > Sent: Wednesday, December 08, 1999 12:57 AM > To: DB2_Interested_Parties@us.ibm.com > Subject: SAP Chooses DB2 Over Oracle > > Dear DB2 Interested Parties, > > Below is the joint SAP AG and IBM press release announcing that DB2 would > be the preferred database platform for SAP's solutions, and that SAP will > use DB2 as the database for its own internal development and production > systems. > > This significant announcement was picked up by numerous news and analyst > reports. Two of them are included below, and the others [...]
896 52 12_Re: ICTYPE B0_18_TEECHRI@UK.IBM.COM30_Wed, 8 Dec 1999 13:26:24 +0000780_us-ascii The rows are put there by a RECOVER INDEX(ALL) on SYSLGRNX, see PQ25931
Regards
Chris Tee
DB2 Systems Programmer IBM UK DB/DC Systems Support North Harbour
mebert@AMADEUS.NET on 08/12/99 13:13:27
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Chris Tee/UK/Contr/IBM) Subject: ICTYPE B
Hello all,
I just discovered that we have two entries in our SYSIBM.SYSCOPY with ICTYPE='B', for DSNDB01.DSNLLX01 & DSNLLX02 (Indexes on DSNDB01.SYSLGRNX). These entries obviously come from a RECOVER INDEX (during a Cat/Dir Reorg), but this ICTYPE is not described in our SQL Reference (Appendix D). Can someone provide me with a [...]
949 66 12_AW: ICTYPE B17_Schreiber, Ursula34_Ursula.Schreiber@DRESDNER-BANK.COM30_Wed, 8 Dec 1999 14:35:17 +0100603_iso-8859-1 Hello,
according to V6 SQL Reference ICTYPE = 'B' means REBUILD INDEX.
Best Regards / Mit freundlichen Gruessen
Ursula Schreiber
Dresdner Bank AG KS Organisation und Informatik IT Research und Standards Consulting und Architektur Datenmanagement D-60301 Frankfurt
email : ursula.schreiber@dresdner-bank.com voice : +49 (0)69/263-6966 fax : +49 (0)69/263-13704
-----Ursprüngliche Nachricht----- Von: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Gesendet am: Mittwoch, 8. Dezember 1999 14:13 An: DB2-L@RYCI.COM Betreff: ICTYPE B [...]
1016 28 20_Archive Active Logs?12_Bajew, Andre20_Bajew@PROGRAMART.COM30_Wed, 8 Dec 1999 08:41:42 -0500555_iso-8859-1 Hi,
had a situation last night where the DB2 I was using was unable to archive active log. Loads and loads of B37s. Why? Primarily - some enormous objects had been created for testing a problem that a user was experiencing. Secondarily - fairly big logs. What I wound up doing was a) trying to get a hold of the space hogs then when that didn't work, b) I tried to hmigrate everything and that failed due to not enough space (will take that up with sysprog later then c) being a desperate source I then deleted these large datasets [...]
1045 68 48_Re: SQL2071N on ADSM DB Backup on UDB 6.1 on AIX0_22_BILL_GALLAGHER@PHL.COM30_Wed, 8 Dec 1999 08:50:27 -0500337_us-ascii FYI . . . we've been able to resolve this problem with the help of IBM. Apparently, this function needs to have api support installed for ADSM on AIX. We did not have api support installed at our site. Our AIX systems programmer installed api support for ADSM, and now the backups (and restores) are working as advertised. [...]
1114 86 18_Re: DBD Corruption12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 8 Dec 1999 08:17:00 -0500455_- We had this problem about 2 months ago...with a production system. We, and IBM, believe the problem was caused when someone attempted to use REPAIR to remove recover pending from an index after it was converted to TYPE 2. We ran the DBD REBUILD and have been ok ever since. There are several APARs in early V5 regarding DBD corruption. Take a look at IBMLINK, I don't have the APAR numbers handy. >>> DB2-L@RYCI.COM@inter2 12/07/99 04:53PM >>> Hi, [...]
1201 46 29_Re: Rebuild DBRM from Catalog20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 8 Dec 1999 09:27:52 -0500308_- Andre
I wrote a rexx to rebuild DBRM from catalog for DB2 V4. Later David troutman ( I hope I haven't misspelled the name) has enhanced (rewritten may be) for DB2 V5. If he is still on list, may be he can help you.
Send me mail, if you need more help. I can definitely help you in this. [...]
1248 89 12_Re: ICTYPE B0_18_mebert@AMADEUS.NET30_Wed, 8 Dec 1999 15:38:28 +0100388_us-ascii Thanks - it's a bug (I should have said that we are DB2 V5, OS/390 R2.6). The appearance of the V6 ICTYPE 'B' in a V5 SYSCOPY is just a nuisance, but there can be ABENDs in certain circumstances when doing a RECOVER INDEX on SYSLGRNX. When you're doing that, you probably don't want another problem. So in case anyone is interested, here's the PTFs that have to be applied: [...]
1338 69 24_Re: Archive Active Logs?18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Wed, 8 Dec 1999 08:49:10 -0600373_iso-8859-1 Andre,
Three things come to mind.
One, you could have stopped DB2, changed DSNZPARM to archive to tape, and started DB2 again. Once the archiving was caught up, go back to DASD archiving again.
Two, if you had the time, you might have added a few active logs, grown those you had, and added some more archiving space prior to the test. [...]
1408 68 12_Re: ICTYPE B18_Martinson, Barbara25_Barbara_Martinson@BMC.COM30_Wed, 8 Dec 1999 08:52:36 -0600436_ISO-8859-1 Sorry - too earlier in the morning for me to respond. The other responders are correct.
ICTYPE = B is for a rebuild, not a PIT recovery. PIT recovery rows are ICTYPE = P for both indexes and table spaces.
Barb Martinson barbara_martinson@bmc.com
-----Original Message----- From: Martinson, Barbara Sent: Wednesday, December 08, 1999 7:25 AM To: 'DB2 Data Base Discussion List' Subject: RE: ICTYPE B [...]
1477 22 28_DB2 V6.1 Certification Guide14_Philip Gunning20_pgunning@BOSCOVS.COM30_Wed, 8 Dec 1999 10:02:10 -0800381_us-ascii In regards to my post last week, I spoke too soon. The guide is not yet available via IBM publications. It is available via other online book stores. IBM indicates it will be available through them soon. SC 09-2915-00. Regards, Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner [...]
1500 27 45_Using UDB NT to load UDB/DB2/OS390 Load files11_Robert Hall25_robert.hall@OCC.TREAS.GOV28_Wed, 8 Dec 1999 10:00:48 EST325_us-ascii Hello,
Has anyone used UDB on the NT platform to load data from either an image copy or unload format from OS390? We want to port an OS390 database (from an external source, comes into us on 3480 tape cartridges) to SQL Server or possibly UDB/NT.
Has anyone tried anything like this? Suggestions? [...]
1528 53 15_Quiesce Problem15_Arnold, Richard29_Richard.P.Arnold@FRITOLAY.COM30_Wed, 8 Dec 1999 09:18:13 -0600332_- All,
Yesterday I got a call about a BMC Copy Image failing.
On review, we determined that the reason for the failure is that the pre-image quiesce gave return code 4. The quiesce gave return code 4 because DB2 was "unable to externalize" some index pages.
I isolated the quiesce, and here is the output: [...]
1582 46 19_Testing methodology9_John Reid14_jreid@FBFS.COM30_Wed, 8 Dec 1999 09:49:59 -0600468_us-ascii Hi List, enjoy the threads, I have a question ....
Environment: DB2 OS/390 v5.1, Security managed by Top Secret for DB2.
Business requirement: Business developers require that they have the ability to run read only programs from TEST loadlibs against production data. This is to verify compliance to specifications and insure results are as expected (Business Users want to see and compare test version against current production version). [...]
1629 27 62_Passing negative numbers to DB2 SP using StartSQL ODBC driver.10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM30_Wed, 8 Dec 1999 09:49:29 -0600363_- Hello List,
I am having problem sending negative numbers as a parameters to DB2 SP. When the parameter reaches the SP, it's losing it's sign. I confirmed it by displaying the number in SP.
When I use DB2 Connect ODBC driver, the sign is intact ( I get negative numbers across).
Did anybody face this problem with StarSQL ODBC driver ? [...]
1657 27 72_UDB V6.1 NT Control Center error while trying to view connections on AIX12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Wed, 8 Dec 1999 10:22:05 -0600524_iso-8859-1 Any ideas what causes this error? _____________________________________________________________ DBA4090 Connection to the JDBC server has ended abnormally. Close the Control Center and retry the operation. If the problem persists, take a trace at the JDBC server and contact support personnel.
Explanation: An unexpected error has occurred.
User Response: Close the Control Center and retry the operation. If the problem persists, take a trace at the JDBC server and contact support personnel. [...]
1685 28 67_DB2 V5.1 OS/390 Programs Accessing remote DB2 UDB 6.1 on NT and AIX14_Philip Gunning20_pgunning@BOSCOVS.COM30_Wed, 8 Dec 1999 12:41:20 -0800553_us-ascii I would like to know if any colleaques have experience accessing UDB from mainframe DB2 batch programs. We determined that UDB 6.1 NT or AIX does not support the bind option (sqlerror continue) so we cannot do distributed unit of work. We determined it can be done with dynamic sql, but our programmers here have a lot to learn when it comes to that. Does anyone have a way around this or do you know of any forthcoming changes to UDB on NT and AIX platforms that will support DUOW via static SQL. Any info would be appreciated. TIA, Phil [...]
1714 29 33_Abbreviations for BIND parameters0_27_mamccormack@STATESTREET.COM30_Wed, 8 Dec 1999 12:44:51 -0500533_US-ASCII It appears that parameters on BIND commands can be abbreviated. For example, ACTION can be abbreviated ACT. The DB2 Commands Reference manual does not, however, list the abbreviations. Does anyone know where I can find a documented list of acceptable abbreviations ?
We have a vendor product which processes BIND commands. We are trying to use a user exit off the vendor product, but the vendor's code passes information to our exit only when the BIND parameter is fully spelled out, not when it is abbreviated. [...]
1744 78 23_Re: Testing methodology15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Wed, 8 Dec 1999 11:56:15 -0600626_us-ascii The owner of the private plan must only have select access to the production tables. Otherwise the developer could code update SQL in the test program and successfully update production. Since the developer can bind into a collection of the plan, have the developer bind the production support modules into the same collection. Use validate(run) as a bind package option. This way the owner of the package (select only access) will get warning messages for each SQL update statement in the support module indicating the owner does not have sufficient access to execute the update statement. The bind will create [...]
1823 38 23_Operating System & DBMS17_Price, Jeff (EDS)14_jprice@NCL.COM30_Wed, 8 Dec 1999 13:12:04 -0500633_- Does anyone have any documentation on the availability of NT as opposed to UNIX as opposed to OS/390?
Also, does anyone know when DB2's SQL/PSM will be available and for which platforms first, etc.. I was given the task of collecting information comparing Microsoft SQL/Server, Oracle and DB2 UDB (NT/UNIX). A customer is considering migrating from SQL/Server to Oracle. The application relies heavily on stored procedures..... so a translation from Transact SQL to PL/SQL is feasible. I would like to suggest DB2 as a possibility, but don't know when SQL/PSM will be available or how closely it resembles Transact SQL [...]
1862 67 27_Re: Operating System & DBMS14_Philip Gunning20_pgunning@BOSCOVS.COM30_Wed, 8 Dec 1999 13:25:48 -0800562_us-ascii Jeff, DB2 UDB EEE for AIX is very reliable and extremely scalable. We have a major application being developed on DB2 UDB EEE AIX and several other business applications on DB2 UDB NT EE. We chose AIX for the high end as the analysis we did pointed to AIX. The way the NT OS uses threads versus task control blocks can lead to high performance and we like NT but would like to see better availability and reliability; notwithstanding, we do have 2 or 3 production applications being developed on NT (Gift Registry and Invoice Processing). HTH Phil [...]
1930 72 72_Re: DB2 V5.1 OS/390 Programs Accessing remote DB2 UDB 6.1 on NT a nd AIX13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 8 Dec 1999 13:25:51 -0500469_- Yes, I've had experience in accessing UDB from mainframe batch programs (both read and update). However, the bind option, sqlerror continue, only refers to whether or not the package will actually be created if there are sql erors. It doesn't have anything to do with executing a distributed unit of work. Here's the description of SQLERROR from the UDB 6.1 Command book; SQLERROR Indicates whether to create a package or a bind file if an error is encountered. [...]
2003 25 22_Change in Plan Runtime13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Wed, 8 Dec 1999 13:27:23 -0500474_us-ascii We just upgraded to version 5 over the weekend. One of our batch plans has started running extremely long in all areas (development, test and production). It is spending its time in a cursor that according to our explains does not have any real access problems. Has anyone experienced any similar problems after upgrading to version 5? We have rebound this plan and ran reorgs and runstats on the tables involved. Any suggestions would be greatly appreciated. [...]
2029 42 26_Re: Change in Plan Runtime15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Wed, 8 Dec 1999 13:30:47 -0500462_iso-8859-1 Just a suggestion, but during the upgrade were you buffers reconfigured to match or better what you had before or your internal sort tablespaces for DSNDB07 (if your plan shows that it's performing internal sorts). Look at those areas too.
Susan Loria
-----Original Message----- From: Scott Lindsey [mailto:sflindsey@HIGHLIGHTS-CORP.COM] Sent: Wednesday, December 08, 1999 1:27 PM To: DB2-L@RYCI.COM Subject: Change in Plan Runtime [...]
2072 44 26_Re: Change in Plan Runtime20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 8 Dec 1999 13:48:33 -0500315_- Few of the many reasons could be -
- If you have CPU busy and after moving to V5, you have CPU parallelism kicking in, It could be really bad. - Access paths have changed ? - Runstats have not been done at column statistics level (certain syntax of runstats does collect column stats) - RID failures. [...]
2117 59 27_Re: Operating System & DBMS12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Wed, 8 Dec 1999 21:56:05 +0200631_x-user-defined Hi, I presume you confused someone else (probably Richar Yevich) with me as I didn't give this presentation.
Isaac Yassin
"Price, Jeff (EDS)" wrote: > > Does anyone have any documentation on the availability of NT as opposed > to UNIX as opposed to OS/390? > > Also, does anyone know when DB2's SQL/PSM will be available and for which > platforms first, etc.. > I was given the task of collecting information comparing Microsoft > SQL/Server, Oracle and DB2 UDB (NT/UNIX). A customer is considering > migrating from SQL/Server to Oracle. The application relies > heavily on stored procedures..... [...]
2177 23 13_-526 question14_Arnold, Mark S20_Mark.Arnold@BNSF.COM30_Wed, 8 Dec 1999 13:55:16 -0600550_iso-8859-1 Folks,
I have a developer trying to use Global Temp. Tables in a program. All was fine until he tried to delete a row, whereupon he recieved a -526 with the message "SQLCODE = -526, ERROR: THE REQUESTED FUNCTION DOES NOT APPLY TO GLOBAL TEMPORARY TABLES". I have looked through the manuals, but cannot find any list of restrictions which says that you cannot delete from a GTT. In fact, if mentions delete statements as one of the type that instanciates a GTT. Can anyone shed some light on this for me? We're on DB2V5, OS390. [...]
2201 78 27_Re: Operating System & DBMS17_Price, Jeff (EDS)14_jprice@NCL.COM30_Wed, 8 Dec 1999 15:28:43 -0500567_- Yes, you are correct, my apologies to you and Richard Yevich.
> -----Original Message----- > From: Isaac Yassin [SMTP:yassin@NETVISION.NET.IL] > Sent: Wednesday, December 08, 1999 2:56 PM > To: DB2-L@RYCI.COM > Subject: Re: Operating System & DBMS > > Hi, > I presume you confused someone else (probably Richar Yevich) with me as I > didn't give this presentation. > > Isaac Yassin > > "Price, Jeff (EDS)" wrote: > > > > Does anyone have any documentation on the availability of NT as opposed > > to UNIX as opposed to OS/390? > > > > Also, does anyone [...]
2280 40 17_Re: -526 question13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Wed, 8 Dec 1999 14:30:17 -0600648_iso-8859-1 you can only do a mass delete (DELETE FROM GTT), you cannot do a searched DELETE with a WHERE clause hth gm
-----Original Message----- From: Arnold, Mark S [mailto:Mark.Arnold@BNSF.COM] Sent: Wednesday, December 08, 1999 1:55 PM To: DB2-L@RYCI.COM Subject: -526 question
Folks,
I have a developer trying to use Global Temp. Tables in a program. All was fine until he tried to delete a row, whereupon he recieved a -526 with the message "SQLCODE = -526, ERROR: THE REQUESTED FUNCTION DOES NOT APPLY TO GLOBAL TEMPORARY TABLES". I have looked through the manuals, but cannot find any list of restrictions [...]
2321 45 17_Re: -526 question15_Neill, Thomas W17_NeillTW@AETNA.COM30_Wed, 8 Dec 1999 15:38:30 -0500377_- The reference you're looking for is a few pages further from the Creating Temporary Tables on p.2-37 of the Application Programming and SQL Guide (SC26-8958-00). The Deleting Rows: DELETE subtopic on p.2-46 covers what that command can do with temporary tables.
Tom Neill DBA, ASD/Architecture Aetna U.S. Healthcare Phone: (860) 636-5281 Email: NeillTW@aetna.com [...]
2367 56 37_Re: Abbreviations for BIND parameters14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Thu, 9 Dec 1999 09:45:05 +1000454_us-ascii To quote the V5 Command Reference "2.5.1 Abbreviations: The names of the DSN command and its subcommands cannot be abbreviated. For compatibility with prior releases of DB2, abbreviations for some keywords are allowed. However, to avoid potential problems, it is recommended that keywords never be abbreviated."
/* standard disclaimer */ James Campbell DBA Hansen Corporation, Tooronga +61 3 9261 1802 james.campbell@energyis.com.au [...]
2424 75 26_Re: Change in Plan Runtime0_29_Greg.Palgrave@BANKWEST.COM.AU30_Thu, 9 Dec 1999 08:47:58 +0800414_us-ascii Scott,
Just check if the plan/package has been bound with DEGREE(ANY), and rebind as DEGREE(1) - we had some problems with this in early V5, we thought it would be really useful, but in many cases we were getting MUCH higher run times/cpu times. We now turn it on for carefully selected plans/pkgs only. There were a lot of PTFs for this area, you may want to check if any need to be applied. [...]
2500 40 14_SIGN-OFF DB2-L29_Sireesh Chandra.M,J16 Chennai25_msireesh@MSDC.HCLTECH.COM30_Thu, 9 Dec 1999 10:21:38 +053025_iso-8859-1 SIGN-OFF DB2-L
2541 25 40_Unload from OS390 and Load using DB2 UDB15_Mohammed Nayeem21_db2udbxpert@YAHOO.COM30_Wed, 8 Dec 1999 19:47:58 -0800590_us-ascii Today's Clue :
If you have DB2 Connect setup you can connect to OS390 database and use EXPORT in IXF format to unload OS/390 DB2 data on your NT and then load DB2 on NT using LOAD. DB2 Connect will take care of the conversion. If you do not have DB2 Connect you can use DIGITS function in your DSNTIAUL SQL to convert numeric data and unload into an external format and then FTP using ASCII option. __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one place. Yahoo! Shopping: http://shopping.yahoo.com [...]
2567 287 29_Re: Rebuild DBRM from Catalog9_Dan Vogel19_dan_vogel@YAHOO.COM30_Wed, 8 Dec 1999 20:01:10 -0800398_us-ascii The following is the REXX to re-engineer the DBRM out of the DB2 Catalog. The only field that is missing it the TSO Userid of the person who ran the pre-compile
The only problem, I've run into with this is when I change the SQL around and did a OUTER JOIN between SYSDBRM and SYSPACKAGE DB2 added a NULL indicator to the name field which through off my field positions by one. [...]
2855 25 14_SIGN-OFF DB2-L11_Paolo Bruni17_pbruni@US.IBM.COM30_Wed, 8 Dec 1999 22:48:16 -0800600_us-ascii SIGN-OFF DB2-L
Regards Paolo e-mail: pbruni@us.ibm.com
Paolo Bruni IBM Corp. - ITSO San Jose Almaden Research Center, E2-418 650 Harry Road, San Jose CA 95120 phone: T/L457-3624 or (408)-927-3624 fax: T/L457-3616 or (408)-927 -3616 external ITSO site: http://www.redbooks.ibm.com/ IBM internal page: http://wtscpok.itso.ibm.com/~paolo/
================================================ 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.
2881 154 23_Re: Testing methodology0_22_The-Thanh.Luong@AGF.BE30_Thu, 9 Dec 1999 11:17:44 +0100363_- Our environment: DB2 V4, security via exits (not TSS nor ACF2). The rule here is No test program can be run against Production data. Developers must take a copy of it and put it in an Acceptance (or a Test) environment. This is done by sending a request (which is logged) to the Operational personnel who actually run the unload/reload utilities. Regards, [...]
3036 47 26_Re: Change in Plan Runtime0_19_mike.holmans@BT.COM30_Thu, 9 Dec 1999 10:39:49 -0000430_- We had two programs which went from acceptable to catastrophic after we upgraded to V5. Both of them were down to changed accesspaths. Both were cured by changing our RUNSTATS syntax to include KEYCARD on each index with more than two columns in it. Since you say your EXPLAIN output does not show a nasty accesspath, this is probably of no help to you, but maybe you're ready to try almost anything just in case it helps. [...]
3084 33 34_Use of DB2 online reorg product(s)18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Thu, 9 Dec 1999 08:57:42 -0500554_iso-8859-1 Is anyone out there using either of these products for online reorgs? (We're at V5 DB2/OS390 for now)
--Platinum/CA online reorg --CDB R/W-reorg
If anyone is I would appreciate any feedback as to how y'all like the product(s) and if there are any horror stories or tips you'd like to share. I'd like to get some feedback from the real world since I'm going to be looking at at least 2 of these companies and how their product works or doesn't work. Feel free to respond to my email address to avoid cluttering up the forum. [...]
3118 25 23_Re: Testing methodology13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Thu, 9 Dec 1999 10:05:10 -0500394_iso-8859-1 Hi John, Good luck finding a manageable way to grant read-only access to production update-intent programs.
There are products which provide capabilities to extract referentially intact data subsets. The products I know providing this capability are File-AID/RDX from Compuware and Princeton Softech's Move for DB2.
You can probably guess which I might recommend. [...]
3144 51 21_Multiple Index Access15_Brian Zamborski18_bzamborski@USS.COM30_Thu, 9 Dec 1999 10:21:07 -0500555_us-ascii Hi all, Thanks for all of your help on the RID pool MAX question. To eliminate the RID pool max problem, we have created another index (and used the optimize for 1 row clause in the select).This now causes the optimizer to use a single index (even prior to creating the new index, the optimize for 1 row clause caused the use of a single index rather than the multiple index access), However, we are confused as to why the optimizer selected a multiple index access path in the first place, based on what the 2 indexes in question consisted [...]
3196 67 25_Re: Multiple Index Access20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 9 Dec 1999 10:24:57 -0500583_- What is fullkeycardf & clusterratios for both the indexes ? If you could mention colcardf for all 9 columns, even better.
> -----Original Message----- > From: Brian Zamborski [SMTP:bzamborski@USS.COM] > Sent: Thursday, December 09, 1999 10:21 AM > To: DB2-L@RYCI.COM > Subject: Multiple Index Access > > Hi all, > Thanks for all of your help on the RID pool MAX question. To eliminate the > RID pool max problem, we have created another index (and used the optimize > for 1 row clause in the select).This now causes the optimizer to use a > single index (even prior to [...]
3264 19 0_13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK30_Thu, 9 Dec 1999 15:43:00 -0000385_- Folks
has anyone converted from Oracle MVS to DB2 OS/390?
If so how was it achieved?
Ian McDonald DB2 DBA Abbey National
================================================ 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.
3284 63 19_Re: Quiesce Problem11_John Rosser24_jhrosser@DUKE-ENERGY.COM30_Thu, 9 Dec 1999 10:21:57 -0800617_- On Wed, 8 Dec 1999 09:18:13 -0600, Arnold, Richard wrote:
>All, > >Yesterday I got a call about a BMC Copy Image failing. > >On review, we determined that the reason for the failure is that the >pre-image quiesce gave return code 4. The quiesce gave return code 4 >because DB2 was "unable to externalize" some index pages. > >I isolated the quiesce, and here is the output: > >------ >DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = PS.QUIESCE > > > >DSNU050I DSNUGUTC - QUIESCE TABLESPACE PSHLHRS3.PLA WRITE YES > >DSNU479I -TDB2 DSNUQUIA - UNABLE TO EXTERNALIZE [...]
3348 52 62_DB2 Connect - Binding Database Utilities for multiple releases16_Charles Stansell19_cfstansell@JUNO.COM30_Thu, 9 Dec 1999 10:23:53 -0600372_- Problem :
In each release of DB2 Connect Personal Edition, I am able to bind the utilities and it uses the current '\DB2\SQLLIB\bnd' library on my Win'98. In this case, however, I am at 5.2 level and I have a client at a different location trying to use 6.1 level. The binds need to be done for 6.1 but I can't figure out how to do that from my workstation. [...]
3401 22 21_INSERT with subselect12_Bill Bennett19_bbenn1@JCPENNEY.COM30_Thu, 9 Dec 1999 10:43:57 -0800489_- We have some large S390 DB2 V5 tables that we have a lot of insert activity. Each table has over 90 million rows and some have several NPIs. Performance is slow on the NPI inserts.
One idea I had was having the COBOL program insert the rows one at a time to a smaller table during normal processing when time is critical. (Small and clean NPIs and maybe even get rid of a few of the NPIs.) Then nightly use a INSERT with subselect to copy the data to the normal large table. [...]
3424 67 67_Re: DB2 Connect - Binding Database Utilities for multiple release s12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Thu, 9 Dec 1999 10:53:34 -0600642_iso-8859-1 We tell our user to logon with user-id DBPROD (and we tell him the temp password), he/she can then do the bind for us.
-----Original Message----- From: Charles Stansell [mailto:cfstansell@JUNO.COM] Sent: December 09, 1999 10:24 AM To: DB2-L@RYCI.COM Subject: DB2 Connect - Binding Database Utilities for multiple releases
Problem :
In each release of DB2 Connect Personal Edition, I am able to bind the utilities and it uses the current '\DB2\SQLLIB\bnd' library on my Win'98. In this case, however, I am at 5.2 level and I have a client at a different location trying to use 6.1 level. The binds [...]
3492 45 25_Re: INSERT with subselect20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 9 Dec 1999 11:58:01 -0500544_- DB2 inserts one row at a time like a nomal insert would have done this. Best thing would be to do (fast) UNLOAD and LOAD LOG NO on to big table ( You could afford down time & 24x7).
> -----Original Message----- > From: Bill Bennett [SMTP:bbenn1@JCPENNEY.COM] > Sent: Thursday, December 09, 1999 1:44 PM > To: DB2-L@RYCI.COM > Subject: INSERT with subselect > > We have some large S390 DB2 V5 tables that we have a lot of insert > activity. > Each table has over 90 million rows and some have several NPIs. > Performance > is slow [...]
3538 24 28_DB2 Compression on RVA boxes15_Michael Bancale21_mbancale@TXFB-INS.COM30_Thu, 9 Dec 1999 11:08:21 -0600576_iso-8859-1 I have hundreds of decision support tables which are defined with DB2 compression. These objects reside on IBM RVA and EMC dasd. Do I need to turn off DB2 compression if I am using RVA dasd?
Thanks,
Michael Bancale mbancale@txfb-ins.com Texas Farm Bureau Insurance Company www.txfb-ins.com Waco, Texas
================================================ 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.
3563 70 19_Chargeback Software24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Thu, 9 Dec 1999 09:37:10 -0800417_- Hi!
Not sure if this is appropriate for this forum, but does anyone know of any chargeback software that can handle both DB2 and Oracle access information from multiple platforms, including the WEB? We've been looking for a while at Komand from PACE Technologies, and they seem to be able to handle most of our requirements except web access. We haven't stumbled across any other software vendors, yet. [...]
3634 24 23_Re: Testing methodology12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 9 Dec 1999 19:46:51 +020093_x-user-defined Hi, Sorry - but NO test access to prod. Our rules are - copy the data.
3659 21 26_When was Instance Started?0_22_BILL_GALLAGHER@PHL.COM30_Thu, 9 Dec 1999 13:16:31 -0500333_us-ascii Hopefully, a simple question: is there a way to determine when (date/time) an instance was started? We're dealing with UDB 6.1 on AIX, but I would guess that if there's a way to get this information, it should apply across platforms and releases.
Thanks,
Bill Gallagher, DBA Phoenix Home Life Enfield, CT [...]
3681 36 23_Re: Testing methodology22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR30_Thu, 9 Dec 1999 16:17:28 -0200618_x-user-defined >Sorry - but NO test access to prod. >Our rules are - copy the data. >
I would like to say that, in our particular case, a banking company, the production data is property from the client, not the bank. Analyst/programmers cannot test their programs with client's data, so they must create their own test data. I agree with this approach because if you have consistent testing methods you won't need production data in testing environment or test programs in production environment. The result is a smaller test environment (all our test tablespace are default size) and a secure production [...]
3718 52 30_Re: When was Instance Started?16_Michael McCarthy24_Michael_McCarthy@DTC.ORG30_Thu, 9 Dec 1999 13:38:12 -0500511_us-ascii Bill,
At the command line enter:
prompt> db2 get snapshot for dbm
In windows, you will need to be in a db2 command window. The Database manager start timestamp is one piece of the information returned.
-Mike.
BILL_GALLAGHER@PHL.COM on 12/09/99 01:16:31 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Michael McCarthy/DTC) Subject: [DB2-L] When was Instance Started? [...]
3771 15 23_Re: Testing methodology12_Beth Walters21_Beth_Walters@GLIC.COM30_Thu, 9 Dec 1999 13:38:55 -0500397_us-ascii Also, production data may or may not (will probably not) cover all exception and error conditions needed for adequate testing.
Beth Walters
================================================ 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.
3787 30 37_Re: Abbreviations for BIND parameters12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 9 Dec 1999 10:59:31 -0800534_us-ascii The DSN command and its subcommands use the TSO parser, which is described in TSO/E book shelf in the OS/390 library. OS/390 V2R8.0 TSO/E Programming Services, SC28-1971-03 is a good example, with the parser described in chapter 6.
The external is described in OS/390 V2R8.0 TSO/E Command Reference, SC28-1969-03. You can enter keywords spelled exactly as they are shown or you can use an acceptable abbreviation. You can abbreviate any keyword by entering only the significant characters; that is, you must type [...]
3818 74 8_Re: TIME0_20_Gary_Desmond@FPL.COM30_Thu, 9 Dec 1999 14:08:57 -0500335_us-ascii I apologize for the lateness of the post on this topic, but I get the messages in digest format and as an overworked DBA I am always weeks behind in my reading.
Anyway, here is another thought, on the difference of the two times '24.00.00' & '00.00.00' and their special meanings. Think of precision and duration. [...]
3893 57 32_Re: DB2 Compression on RVA boxes18_Sundaresan, Sundar33_Sundar.Sundaresan@SEA.SIEMENS.COM30_Thu, 9 Dec 1999 14:20:48 -0500471_- Michael
I do not know about EMC. But for the RVA and SVA refer to redbook DB2 for OS/390 and Data Compression, SG24-5261-00
It has what you need. Also refer to comparisions between Db2 compression, RVA compression and RVA + Db2 compression on DASD savings etc. in the redbook Using RVA and SnapShot for BI with OS/390 and DB2, SG24-5333-00 ( Specifically chapter 3 ) which should put to rest many an argument between DBAs and Storage Administrators. [...]
3951 31 32_UDB v6.1 - db2istrt and dlfmstrt0_22_BILL_GALLAGHER@PHL.COM30_Thu, 9 Dec 1999 14:30:00 -0500325_us-ascii Can anybody shed some light on what the following programs do? There is a "db2" startup script in our AIX startup procedures which indicates that it will automatically start all UDB instances on the server, as well as the DB2 Admin Server. The following two programs are being invoked:
db2istrt dlfmstrt [...]
3983 15 38_Re: Use of DB2 online reorg product(s)0_25_Clint.Taylor@AUTOZONE.COM30_Thu, 9 Dec 1999 13:38:20 -0600287_us-ascii We tested the CDB products in our shop and it was a horror. If you have large tables, this software is not for you. It does not use disk space for work as advertised, but uses tons of storage. There tech support is extremely weak and there documentation was not very good. [...]
3999 135 8_Re: TIME14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Thu, 9 Dec 1999 14:52:40 -0500340_us-ascii Ah, just when everyone thought it was safe to go back in the water....
Of course your observation about the dependence of half-open-on-the-left intervals on precision gets right to the crux of why we usually define them the other way, and why the old-style idea of the day ending with 12 PM (midnight) was a dumb idea. [...]
4135 45 23_Re: Testing methodology12_Lisle, Kathy19_KLLISLE@INTEGON.COM30_Thu, 9 Dec 1999 16:01:52 -0500649_windows-1252 This is a good reason for requiring extensive tests with a test system. However, I have too much experience with input data that contains undocumented values in a code field, combinations of data that no one could have reasonably anticipated, etc. Generated test data won't catch these problems. Also, some problems simply don't show up until volume testing is performed. Of course, the prefered solution is a full-sized, frequently updated test or QA database, perhaps with some sort of scrambling of customer names, account numbers, and other sensitive data. However, not all companies will spring for that much DASD, especially [...]
4181 40 33_Re: OS390 Table Browse/Edit Tools26_Relational Architects Inc.16_admin@RELARC.COM30_Thu, 9 Dec 1999 16:12:59 +0000736_us-ascii Dear Greg,
One further product you might consider is Host/EDIT from Relational Architects. It's versatile RI editor for DB2 data, VSAM files and ISPF tables. Descriptive literature for Host/EDIT is available at www.relarc.com
Best regards, Carl Feinberg Feinberg.C@relarc.com
At 11:10 AM 12/3/99 -0500, you wrote: >Does anyone have any thoughts around the various browse/edit tools that are >available? The three I'm aware of are File-Aid for DB2 by CompuWare, >Access for >DB2 by Princeton Softech, and RC/Edit from CA/Platinum. > >What are your experiences and likes/dislikes? Are there other good >products out >there? > >Thanks, >Greg Myers > >================================================ >To [...]
4222 78 37_Re: Distributed threads holding locks17_Price, Jeff (EDS)14_jprice@NCL.COM30_Thu, 9 Dec 1999 17:13:35 -0500559_- We also had this problem, but with PeopleSoft and DB2 Connect EE. The Application people told us that we couldn't use the time thresholds to terminate threads because it was common for users to have multiple panels open, and some threads may be inactive for some time. But also had the problem that if they turned off their PC or walked away, then the thread would be there to throw the whole production schedule out of wack. There are two solutions that amount to the same thing: 1) -stop DDF MODE(FORCE), then restart it 2) write a REXX program that [...]
4301 100 37_Re: Distributed threads holding locks13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 9 Dec 1999 16:55:06 -0600645_US-ASCII I suggest looking at the IDTHTOIN and CMTSTAT zparms. Set correctly for your environment, they should eliminate most of your inactive thread problems. Assuming your transactions are committing. HTH Kurt
>>> "Price, Jeff (EDS)" 12/09/99 04:13PM >>> We also had this problem, but with PeopleSoft and DB2 Connect EE. The Application people told us that we couldn't use the time thresholds to terminate threads because it was common for users to have multiple panels open, and some threads may be inactive for some time. But also had the problem that if they turned off their PC or walked away, [...]
4402 77 26_Help with Abend 00E4002E ?21_Smith, Ronald M - CNF20_Smith.Ronald@CNF.COM30_Thu, 9 Dec 1999 15:59:26 -0800613_- Hi folks, Hope we can get some help with abends we experienced last weekend.. Environment: DB2 for OS/390 V5.1, also Platinum Utilities R97G, When executing various IBM utilities (Full Image Copies (concurrent), Runstats, and Quiesces), we experienced multiple abends: IEF450I CQ55AP2 DB2OPROC Q55AP020 - ABEND=S04E U0000 REASON=00E4002E accompanied by: DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E4002E' This reason code is not documented in DB2V4, V5, or V6 Messages & Codes. Our Sysprog could only suggest that we retry the jobs, which *DID* then execute OK.... [...]
4480 21 29_Re: Rebuild DBRM from Catalog12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 9 Dec 1999 16:45:59 -0800332_us-ascii The one I talked about comes from IBM service. The basic information is in APAR II12100. The REXX code has been tried by several customers and supports old (prior to DB2 V2.3), and later release formats. You could call the service number and ask them for the REXX code, ready to work with the new REXX to DB2 support. [...]
4502 44 30_Re: When was Instance Started?13_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Thu, 9 Dec 1999 18:56:14 CST630_- Run the command.. db2 get snapshot for database manager This will tell ya when the manager was last started. Can also do ps -ef |grep db2sysc (look at the date of the process for your instance).
>From: BILL_GALLAGHER@PHL.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: When was Instance Started? >Date: Thu, 9 Dec 1999 13:16:31 -0500 > >Hopefully, a simple question: is there a way to determine when (date/time) >an >instance was started? We're dealing with UDB 6.1 on AIX, but I would guess >that >if there's a way to get this information, it should apply across [...]
4547 20 19_Re: DSMAX Questions12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 9 Dec 1999 17:39:26 -0800338_us-ascii If you need more than 10,000 dd's then the official support is in OS/390 V2R6 and the DB2 V5 APAR is PQ18543. You do need to be careful about storage, so please check the Installation Guide book, particularly the data set control block discussion and virtual storage below the 16M line, page 2-47 and 2-48 in the hard copy. [...]
4568 58 36_Re: UDB v6.1 - db2istrt and dlfmstrt10_Marc Baime23_mbaime1@TAMPABAY.RR.COM30_Thu, 9 Dec 1999 22:07:32 -0500334_iso-8859-1 I would quess db2istrt is the db2 instance starter and dlfmstrt is the data links file manager process startup but I'm just making that up as I'm not really sure. Does anyone have a detailed chart of the startup sequences and associated processes. Any information on internals would be fun and useful to have. Thanks. [...]
4627 155 28_Re: Field Procedure Glitches14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Thu, 9 Dec 1999 22:30:32 -0500646_us-ascii As you predicted, we have encountered glitches trying to use a field procedure to remediate our academic-year-2000 problems. So far, the following two have reared their ugly respective heads: UNION of a fieldprocked character column with a character expression (usually the constant ' ' (blank), used in pre-inner/outer-join UNIONs) is erroneously rejected. The QMF SAVE DATA command does not copy the field procedure attribute when creating a new table. The second problem is killing us. Myron, you mentioned using triggers and said they could do everything we wanted to do, which is to get these character strings that begin with [...]
4783 22 34_DB2 Image Copies, catalog'd or not29_Sand, Sverre (FUNDI at Alcoa)24_Sverre.Sand@ALCOA.COM.AU31_Fri, 10 Dec 1999 11:27:03 +0800453_- Hi all, anybody having any (strong) feelings regarding to catalogue or not to catalogue the DB2 Image Copies?
Regards Sverre K. Sand
Alcoa of Australia Ltd ACN 004 879 298
================================================ 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.
4806 20 37_Why am I not getting DB2-L items ????11_Tom Gleason15_tagleas@IBM.NET30_Thu, 9 Dec 1999 22:51:17 -0500446_us-ascii This past week, since about 12/3 I have received nothing from the DB2 list. I did not initiate any commands to stop mail or unsubscribe.
Please advise !!
Tom Gleason tagleas@ibm.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.
4827 13 11_Bufferpools12_Canvas Botha18_vzbotha@MWEB.CO.ZA30_Thu, 9 Dec 1999 23:08:28 -0800469_- When a threshold on a bufferpool is exceeded, does it apply to that indivdual bufferpool or to all the bufferpools system wide (IWTH in particular)? Does this also apply to the group bufferpools in a data sharing environment?
================================================ 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.
4841 33 15_Re: Bufferpools11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 10 Dec 1999 05:04:34 -0500393_ISO-8859-1 The thresholds only affect the one bufferpool for which they are triggered. Other bufferpools within the member DB2 subsystem are not affected. Local bufferpools in other member DB2 subsystems are not affected. Group bufferpools are not directly affected, though the processing against them may be impacted by the different processing pattern in the affected local bufferpool. [...]
4875 121 37_Re: Distributed threads holding locks14_David Williams24_David-O.Williams@WDR.COM31_Fri, 10 Dec 1999 10:53:14 +0000352_- I have encontered this problem with users leaving their terminals on over night when using People Soft. The shop was bringing DB2 down every night to perform a system wide dump for DR. DB2 would not shut down due to the DDF threads. The solution was to use a REXX job to identify the threads and then suggest an action for the operator to take. [...]
4997 25 25_Is the List Server dead ?13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Fri, 10 Dec 1999 11:36:30 +0000491_us-ascii I've not had anything from the list for about a week now ?
Is it dead or is it something at my end ?
Please reply by direct e-mail.
Thanks.
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.
5023 42 38_Re: DB2 Image Copies, catalog'd or not0_23_Mike_Levine@TEKHELP.NET31_Fri, 10 Dec 1999 08:04:07 -0500634_us-ascii Hi,
I most cases, it is a good idea to catalog all datasets, including image copies.
Regards,
Michael Levine Premier Data Services, Inc.
>Hi all, >anybody having any (strong) feelings regarding to catalogue or not to >catalogue the DB2 Image Copies? > >Regards >Sverre K. Sand > > > > >Alcoa of Australia Ltd ACN 004 879 298 > >================================================ >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. > > [...]
5066 55 32_Re: DB2 Compression on RVA boxes16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 10 Dec 1999 07:53:41 -0500370_iso-8859-1 Michael,
No. Two entirely different technologies, not competing but complementary. The RVA compression is algorithmic, internal to the hardware, and can be viewed as just DASD. The DB2 Compression is row level, allows more rows per page, better hit ratios in the bufferpools etc. The RVA compression has nothing to do with DB2 or its performance. [...]
5122 56 38_Re: DB2 Image Copies, catalog'd or not11_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Fri, 10 Dec 1999 08:15:33 -0500560_us-ascii If you catalog your image copies and use them for offsite recovery, then I would strongly suggest that you make sure that all of the DB2 subsystem datasets, including cataloged image copies are in their own ICF and you export the ICF each cycle and take that offsite with the tapes. The reason is because if you catalog image copies, DB2 will not include the VOLSER of the image copy dataset in SYSCOPY. DB2 expects that during a recover, the image dataset is cataloged and it can the VOLSER from there. That is fine if you are just recovering a [...]
5179 81 43_Re: DB2 Connect - Binding Database Utilitie11_Kurt Rompot21_RompotK@SCHNEIDER.COM31_Fri, 10 Dec 1999 07:53:28 -0600307_us-ascii I ran into this problem. I believe that you need to install the DB2 V6.1 Software Developer's Kit as well before you get all the bind files necessary for binding ddcsmvs.lst.
In fact, if you look at the base DB2 V6.1 Run-Time Client install, it doesn't even contain a ddcsmvs.lst file. [...]
5261 186 37_Re: Distributed threads holding locks11_Brown, Alan20_Alan_Brown@BCBST.COM31_Fri, 10 Dec 1999 08:56:15 -0500372_iso-8859-1 Another way to handle it is to do one of the following:
1. DB2STOP FORCE on the DB2 Connect EE server. You will also need to issue a DB2START after the backups are completed. 2. FORCE APPLICATION ALL on the DB2 Connect EE server. This will kill all your active connections and threads into DB2. However, users will be able to immediately reconnect. [...]
5448 80 38_Re: DB2 Image Copies, catalog'd or not0_23_Mike_Levine@TEKHELP.NET31_Fri, 10 Dec 1999 09:09:22 -0500363_us-ascii Hi,
It may be advisable to create separate ICF catalog alias' (high level qualifiers) for off-site datasets. These alias' would all point to a single ICF catalog. This ICF catalog is then the last item backed up and sent offsite (after all other backups, image copies, etc. are complete) and one of the first to be recovered at the D/R site. [...]
5529 46 38_Re: DB2 Image Copies, catalog'd or not12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 10 Dec 1999 06:32:59 PST354_- Absolutely catalog the copies. It makes recovery easier and guarantees(ok nothing is REALLY guaranteed, but it's close) that the files will be there when needed. I have been working with backups in different environments for over 16 years and I would NOT consider NOT cataloging ANY copies.
Craig Patton DB2 DBA Patton Research Group, Inc. [...]
5576 45 15_Re: Bufferpools12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 10 Dec 1999 06:38:28 PST381_- Canvas,
In the deep past of DB2, when 1 bufferpool went critical, all bufferpools went critical. This was changed many releases ago (back when we only had 4 bufferpools). In todays DB2, when a single bufferpool goes critical, the other pools do NOT go critical with it.
I am mostly sure that Group bufferpools do not go critical when a local BP goes critical. [...]
5622 131 37_Re: Distributed threads holding locks9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM31_Fri, 10 Dec 1999 08:57:25 -0800605_us-ascii We use DB2 Connect with PeopleSoft and have taken care of the thread problems with zparm changes:
CMTSTAT=INACTIVE, IDTHTOIN=7200,
and using the Resource Limit Facility to stop very long running dynamic SQL statements.. Now that we're using DB2 Connect this seldom happens but we used to experience some kind of client problem where the user would reboot the PC and leave an active DB2 thread which would finally hit the RLF limit. I did have to play with the idthtoin value to find the happy medium. And the fact that we have a dedicated DB2 subsystem for PeopleSoft helps us [...]
5754 57 38_Re: Use of DB2 online reorg product(s)14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Fri, 10 Dec 1999 09:48:19 -0600826_ISO-8859-1 Steve:
Just a quick note to add that BMC offers online reorganization and I would suggest that you include BMC's Concurrent Reorg solution in your evaluation of DB2 online reorg products...
For more information: http://www.bmc.com/products/proddocview.html?id=2040&r=Americas&l=en
Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software Craig_Mullins@bmc.com
>>>>>>>>>>>>>>>>>>>>>>Original Message<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< >Date: Thu, 9 Dec 1999 08:57:42 -0500 >From: "Whittaker, Stephen" >Subject: Use of DB2 online reorg product(s) > > Is anyone out there using either of these products for online reorgs? >(We're at V5 DB2/OS390 for now) > >--Platinum/CA online reorg >--CDB R/W-reorg > > If anyone is I would appreciate [...]
5812 23 32_Re: DB2 Compression on RVA boxes0_22_kmulcahy@CHECKFREE.COM31_Fri, 10 Dec 1999 11:16:26 -0500545_us-ascii If you are not CPU-constrained then use DB2 compression. Your data gets compressed before it is externalized to the DASD subsystem -- all the benefits of DB2 compression, like reduced I/O, still apply.
With DASD subsystem products like EMC you get a further "structural" compaction of the logical record, such as elimination of interrecord gaps, end-of-track waste, and unused allocated tracks. You also get further data compression of compressed data, plus DB2 catalog, directory, indexes, and work files data compression. [...]
5836 66 39_Re: Use of DB2 online reorg product (s)22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 10 Dec 1999 16:40:37 +0000522_ISO-8859-1 Steve We have had problems with the Platinum Product here with claimers and can confirm that Platinum have addressed a whole bunch of these issues.. but I can say that IBM will be doing things in the very near future with their on-line reorg which should and I repeat "should" make it stand out for all the other vendors .. In my opinion on-line reorg should work - no ifs or buts about it .. I do not care how they get it to work with claimers (write / read) it should work .... but at the moment all the [...]
5903 67 25_Sequential Key Generation0_18_damcon2@US.IBM.COM31_Fri, 10 Dec 1999 12:44:01 -0500346_us-ascii Hello everyone,
The question of whether it is necessary to have a separate table for sequential key generation or can it just be generated from the main table it will be used in, has come to my attention and I'm wanting to gather pro's and con's. The following are thoughts that I have come up with. I'm sure there are more. [...]
5971 25 38_DB2 5.0 stored procedures and servlets12_Daniel Kirby25_daniel.kirby@CITICORP.COM31_Fri, 10 Dec 1999 11:42:56 -0800599_- Dear All, I am trying to call a DB2 5.0 (mainframe) stored procedure from a java servlet. I am using driver COM.ibm.db2.jdbc.app.DB2Driver on a NT server using servletexpress. The stored procedure returns one result set. Trying to call a stored procedure with IN parameters fails on "executeQuery". I tried to call a new stored procedure with no IN or OUT parameters. This time the executeQuery worked, but I get a CLI failure on rs.next(), telling me that I have executed something out of sequence. What else can you do after an executeQuery other than rs.next()?? There is a problem either [...]
5997 133 29_Re: Sequential Key Generation0_19_Tim.Lowe@STPAUL.COM31_Fri, 10 Dec 1999 12:13:12 -0600291_us-ascii Jay, As I am sure that you have heard, IBM will be putting in a feature in DB2 version 6 called "identity columns" that will be able to automatically increment to build sequential keys. I am looking forward to this to solve some of these types of problems. (in March of 2000?) [...]
6131 65 32_Re: DB2 Compression on RVA boxes22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Fri, 10 Dec 1999 17:12:17 +0000334_ISO-8859-1 Michael It all depends .. why are you doing compression?
- an exmaple is that you may wish to obtain more addresses in your RVA .
i.e you do not have the x.82 fix to obtain 1024 addresses .. and have hit the sealing on use of available space .. then you may wish to compress the DB2 storage and obtain : [...]
6197 49 32_Re: DB2 Compression on RVA boxes12_craig patton21_prgpatton@HOTMAIL.COM29_Fri, 10 Dec 1999 11:05:17 PST418_- One small comment on being CPU constrained, DB2 compression, when done with 'hardware microcode', costs in the range of about .5% additional CPU (yes that is 'point' 5%). I would use compression even if CPU constrained as the I/O savings (GETPAGE uses cpu cycles) will more than make up for the additional CPU cycles. If your processor does NOT support hardware compression, then I would be much more cautious. [...]
6247 21 27_Archive Log Process & waits15_Michael Bancale21_mbancale@TXFB-INS.COM31_Fri, 10 Dec 1999 13:24:37 -0600504_iso-8859-1 If the a DB2 log becomes full and there are no devices for DB2 to archive to DB2 waits. The questions is just how long will DB2 wait?
Michael Bancale mbancale@txfb-ins.com Texas Farm Bureau Insurance Company www.txfb-ins.com Waco, Texas
================================================ 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.
6269 127 30_Re: Help with Abend 00E4002E ?13_Thomas, Janis20_JANIS.THOMAS@CAI.COM31_Fri, 10 Dec 1999 14:41:05 -0500469_iso-8859-1 This problem looks like it is fixed by the hiper below. If you have any questions on this, please contact tech support at 800-833-7528.
To: PLATINUM Fast Load and Rapid Reorg Users
From: Technical Support PLATINUM technology, inc.
Date: 26 July, 1998
Subject: Potential DB2 v5 Problem on Tablespaces with Dictionaries Created by PLATINUM Utilities ==================================================================== [...]
6397 41 31_Re: Archive Log Process & waits0_23_Mike_Levine@TEKHELP.NET31_Fri, 10 Dec 1999 14:50:07 -0500284_us-ascii Hi,
DB2 will continue running and filling up the active logs until eventually it goes into single log mode writing over copy one of the full, un-off loaded log(s). When all logs fill up in single log mode, then I believe the time it will wait is forever + 1 day. [...]
6439 17 33_Abbreviations for BIND parameters0_27_mamccormack@STATESTREET.COM31_Fri, 10 Dec 1999 15:05:16 -0500391_US-ASCII To James Campbell and Roger Miller,
Thanks for your replies to my question. I now understand what is happening.
Mark McCormack
================================================ 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.
6457 115 31_Re: Archive Log Process & waits0_23_Mike_Levine@TEKHELP.NET31_Fri, 10 Dec 1999 15:22:13 -0500706_us-ascii Hi Tim,
If you using dual mode logging, DB2 will write over copy one of the un-archived active logs until they too fill up, then it will stop.
Regards,
Michael Levine Premier Data Services, Inc.
>From: Tim.Lowe@stpaul.com >X-Lotus-FromDomain: SPC >To: Mike_Levine@TEKHELP.NET >Date: Fri, 10 Dec 1999 14:04:43 -0600 >Subject: Re: Archive Log Process & waits >Content-Disposition: inline >X-UIDL: 061b309bb9080adb05cb182d1ab16e9f > >Mike, >I did not think that DB2 would ever write over an "un-archived" log. From my >experience, when all of the logs fill; DB2 (OS/390) simply will wait for an >archive to occur. Am I missing something? > >Thanks, > [...]
6573 162 30_Re: Help with Abend 00E4002E ?21_Smith, Ronald M - CNF20_Smith.Ronald@CNF.COM31_Fri, 10 Dec 1999 13:05:15 -0800603_iso-8859-1 Thanks Pat, Miguel, and Janis... We've looked into the suggestions you gave us and this is what we come up with:
1. Compression and mixed IBM and Platinum utilities with KEEPDICTIONARY may definitely be a factor. These do occur here. 2. APAR PQ16677 sure looks like a good hit, but our Sysprogs assure me that PTF UQ19290 has indeed already been applied. 3. NO -Display Util command was executing at the time - we didn't get any 00E40030 messages - just the 00E4002E abends. 4. There were no utilities running concurrently against the tablespaces in question. These jobs were our [...]
6736 87 29_Re: Sequential Key Generation15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Fri, 10 Dec 1999 15:59:58 -0500364_- Depending on how big the field is, will the value ever reach the max value and wrap around? If it wraps around how to keep from cycling through all of the possible values(i.e. all values being used)? These are problems that we ran into. We also used a 1 record VSAM file to hold the next key value and updated that HTH Bob Lawrence DBA BOSCOV'S Dept Stores [...]
6824 26 26_Help with Abend 00E4002E ?22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM29_Fri, 10 Dec 1999 13:05:38 PST520_- Ronald,
I suspect you have loaded these tables with a vendor LOAD, which built its own compression dictionary and you are missing a required PTF.
DB2 Utilities checkpoints restart information in SYSUTIL, including compression dictionary control blocks. When a checkpointed block is encountered that it doesn't recognize, the 00E4002E abend is issued. Some vendor LOAD products put their own control block ID in their compression dictionary, it gets checkpointed by utilities and this abend results. [...]
6851 43 18_FW: SIGN-OFF DB2-L13_Cain, James E14_CAINJE@SCE.COM31_Fri, 10 Dec 1999 15:31:47 -0800686_- > SIGN-OFF DB2-L > > Pax 4-6365 Fax 4-6956
> ---------- > From: Paolo Bruni[SMTP:pbruni@US.IBM.COM] > Sent: Wednesday, December 08, 1999 10:48 PM > To: DB2-L@RYCI.COM > Subject: SIGN-OFF DB2-L > > > > Regards > Paolo > e-mail: pbruni@us.ibm.com > > Paolo Bruni > IBM Corp. - ITSO San Jose > Almaden Research Center, E2-418 > 650 Harry Road, San Jose CA 95120 > phone: T/L457-3624 or (408)-927-3624 > fax: T/L457-3616 or (408)-927 -3616 > external ITSO site: http://www.redbooks.ibm.com/ > IBM internal page: http://wtscpok.itso.ibm.com/~paolo/ > > ================================================ > To change your subscription options or to cancel your subscription visit [...]
6895 89 38_Re: DB2 Image Copies, catalog'd or not10_Leo Flores23_leoflores@EARTHLINK.NET31_Fri, 10 Dec 1999 23:02:40 -0800584_us-ascii Don't forget to backup your TMS and send a copy offsite also, along with your various copies of DB2 objects, User Catalogs and System ICF Catalog.
Leo Flores
Mike_Levine@TEKHELP.NET wrote:
> Hi, > > It may be advisable to create separate ICF catalog alias' (high level > qualifiers) for off-site datasets. These alias' would all point to a > single ICF catalog. This ICF catalog is then the last item backed up > and sent offsite (after all other backups, image copies, etc. are > complete) and one of the first to be recovered at the D/R site. > > [...]
6985 45 39_REXX & DB2 interface - repost addresses14_Max 'Guderian'16_mocion@LIBERO.IT31_Sat, 11 Dec 1999 11:12:24 +0100393_us-ascii I had some troubles with e-mail so I repost addresses where you can find a program and
installation notes, DB2WWWX, which is a interface with DB2 and REXX. You can use any SQL
statement. I use it extensively and, my collegues say, is faster than other 3.rd part utility we are
using. If needed I can post in this estimeed list some examples. The address is: [...]
7031 53 38_Re: DB2 Image Copies, catalog'd or not14_Max 'Guderian'16_mocion@LIBERO.IT31_Sat, 11 Dec 1999 11:12:44 +0100431_us-ascii In my opinion, after 10 years of IMS/DB2/VSAM CICS backups, reorgs and recoveries (and data
admin in general) it's a BIG ERROR NOT to catalog backups, expecially if used with hardware
tape mover ('robots' like STORAGETEK and similar, I do not recomend VTS for this type of
work) for many reasons.
It's a good idea to have a dedicated ICF catalog because, in general and if you use GDGs (I [...]
7085 31 31_Re: Archive Log Process & waits14_Max 'Guderian'16_mocion@LIBERO.IT31_Sat, 11 Dec 1999 11:13:41 +0100338_us-ascii We run in this condition 4 months ago (fortunately I was employed in another shop...) and DB2
waits for 12 hours....a disaster !!! Until a tape mount or more DASD space for archives DB2 is
eternally freeze....
The cause was a BIG delete/insert activity in some huge tables done by non-expert people. So [...]
7117 66 32_Re: DB2 Compression on RVA boxes15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Fri, 10 Dec 1999 19:34:12 -0600371_us-ascii As stated before, my MVS TCB inspect monitoring shows between 33% - 67% MORE CPU than non-compressed (this is hardware compression via X'B263' instruction CMPSC).
Remember, compression was designed primarily for DASD savings. If you are already getting 99% (for example) buffer hit ratio on non-compressed, compressed will buy you virtually nothing. [...]
7184 136 32_Re: DB2 Compression on RVA boxes14_Richard Yevich17_ryevich@YAHOO.COM31_Sat, 11 Dec 1999 12:45:51 -0800404_us-ascii Jim
Your statement that DB2 Compression is 33% to 67% CPU overhead is ludicrous and incredibly misleading. Regardless of what your monitor showed, you need to be much more specific. Was that on compressing data, or on decompressing the data? And if so, on what level of compression, and how many rows and pages. Also, what was the cpu reduction due to the reduction of physical I/O? [...]
7321 32 27_Install Net.Data for MS IIS13_George Peters22_gpeters@COMPUSERVE.COM31_Sat, 11 Dec 1999 16:10:40 -0500577_iso-8859-1 Hi - does anyone know the correct names for the CGI-BIN and HTML (standard) directories used by Miscrosoft Internet Information Server (IIS)? This is required for installation of Net.Data which comes with DB2 UDB (NT) V6.1, I am pretty sure thet they are somewhere under the InetPub directory, but the MS documention is voluminous but less than helpful on this pint. Perhaps MSFT and IBM are not the best of friends...don't know why....they were both the target of Anti-trust suits . All help appreciated. Running IIS 3.0 under NTS V4, SP5. Thanks George [...]
7354 182 30_Re: Help with Abend 00E4002E ?13_Paul Matthews19_pgmatthews@HOME.COM31_Sat, 11 Dec 1999 12:52:58 -0800581_us-ascii Hi Ron, when you tried running your RUNSTATS and REORG were you experiencing space problems as well? I'm not sure of all of the details of your problem but I recently ran into something similar. I received the same abend message trying to preform a RUNSTATS against certain tables. I discovered that somehow the physical data cluster had been deleted but there was still an entry discription on the catalog. I had to load a single dummy record to the table which resulted in the physical cluster being reallocated. I was then able to run against these tables with no [...]
7537 50 23_Re: ftp and packed data14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Sat, 11 Dec 1999 17:57:08 -0500359_us-ascii If you regularly send files of mixed binary and character data in a standard format, it seems that you could write a quickie program to translate the character fields from EBCDIC to ASCII and transmit the resulting file as binary. Has anyone tried that? Maybe there's a utility to do that kind of translation, or maybe someone should write one. [...]
7588 26 51_Porting C language stored procedures from NT to MVS10_Mark Doyle23_markdoyle@EARTHLINK.NET31_Sat, 11 Dec 1999 18:38:35 -0800538_- We are trying port some some C-Language stored procedures from an NT platform to DB2 UDB for MVS (V6). In the NT versions, there are a couple of include modules (sqlenv.h & sqlutil.h) that are not present in the MVS C libraries. There are other modules (stdio.h, strings.h, etc.) that are present. Are there MVS versions of these "missing" modules? If so, what are they called? If not, can we safely move the NT versions of the modules into the MVS C library and use them? Or is there another way that this is accomplished in MVS? [...]
7615 219 30_Re: Help with Abend 00E4002E ?8_rsmith2419_rsmith24@USWEST.NET31_Sat, 11 Dec 1999 21:05:41 -0800308_us-ascii Hi Paul, We were not experiencing any (known) space problems...these were just routine Runstats, IC's, and Quiesces being run against some of our normal Production DB's... I'll check some of our victims out on Monday to see if any such condition as bit you applies. Thanks for the idea :-) Ron [...]
7835 50 30_Re: Help with Abend 00E4002E ?8_rsmith2419_rsmith24@USWEST.NET31_Sat, 11 Dec 1999 22:51:59 -0800406_us-ascii My apologies to all if you received this already - DB2-L indicated I needed to retry the post...
Hi Paul, We were not experiencing any (known) space problems...these were just routine Runstats, IC's, and Quiesces being run against some of our normal Production DB's... I'll check some of our victims out on Monday to see if any such condition as bit you applies. Thanks for the idea :-) Ron
7886 74 32_Re: DB2 Compression on RVA boxes15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 11 Dec 1999 17:46:57 -0600356_us-ascii Richard Yevich wrote: > > Jim > > Your statement that DB2 Compression is 33% to 67% CPU > overhead is ludicrous and incredibly misleading.
I had stated in the past, this is what Candle's MVS monitor showed during TCB inspect sampling. I would like to have a product like STROBE active to see how its results compare with MVS Omegamon. [...]
7961 49 19_Unlimited Hierarchy0_14_DPetro@AOL.COM29_Sun, 12 Dec 1999 15:45:45 EST317_us-ascii We have a need to establish a table that defines an unlimited hierarchy. This hierarchy also needs to be flexible such that each user may define their own hierarchy in terms of number of levels, meanings, etc. The lowest level is always account number. So for example we might have a hierarchy that is: [...]
8011 94 23_Re: Unlimited Hierarchy16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Sun, 12 Dec 1999 16:25:04 -0500462_iso-8859-1 Dave,
What platform as there are simple solutions for OS/390 and simpler solutions for non-OS/390 platforms. Recursive SQL on non-OS/390, relatively simple in this case. On the OS/390, it will depend on the number of levels, etc. There are 2 different solutions on the OS/390, one in SQL, limited to a number of levels. The other uses multiple SQL statements and a global temp table and can handle almost anything. Which platform are you? [...]
8106 48 31_Re: Install Net.Data for MS IIS10_Ozan VAKAR19_ovakar@32BIT.COM.TR31_Mon, 13 Dec 1999 10:15:49 +0200650_iso-8859-1 ----- Original Message ----- From: George Peters Newsgroups: bit.listserv.db2-l To: Sent: 11 Aralýk 1999 Cumartesi 23:10 Subject: Install Net.Data for MS IIS
> Hi - does anyone know the correct names for the CGI-BIN and HTML > (standard) directories used by Miscrosoft Internet Information Server (IIS)? > This is required for installation of Net.Data which comes with DB2 UDB (NT) > V6.1, > I am pretty sure thet they are somewhere under the InetPub directory, but > the MS documention is voluminous but less than helpful on this pint. > Perhaps MSFT and IBM are not the best [...]
8155 77 31_Re: Install Net.Data for MS IIS10_Ozan VAKAR19_ovakar@32BIT.COM.TR31_Mon, 13 Dec 1999 10:16:30 +0200720_iso-8859-1 Hi,
IIS default directory tree is as such
\Inetpub \Inetpub\wwwroot --------------------- for html's \Inetpub\wwwroot\cgi-bin \Inetpub\wwwroot\_private \Inetpub\wwwroot\_vti_bin \Inetpub\wwwroot\_vti_cnf \Inetpub\wwwroot\_vti_log \Inetpub\wwwroot\_vti_pvt \Inetpub\wwwroot\_vti_txt \Inetpub\wwwroot\images \Inetpub\scripts \Inetpub\ftproot \Inetpub\gophroot
The default directory is \Inetpub\wwwroot
Good lock Ozan VAKAR
----- Original Message ----- From: George Peters Newsgroups: bit.listserv.db2-l To: Sent: 11 Aralýk 1999 Cumartesi 23:10 Subject: Install Net.Data for MS IIS [...]
8233 139 32_Re: DB2 Compression on RVA boxes0_18_mebert@AMADEUS.NET31_Mon, 13 Dec 1999 11:08:25 +0100686_us-ascii Hello all,
there have been many exchanges about DB2 compression (look in the archives), and there are two factions. I'm on record as belonging to the "con-Compression"-faction. Of course there are many possible scenarios, each with their own "right" answers. If you only access your data in an OLTP-way, i.e. reading/updating/inserting on the single-record (or few-record) level, with a key that allows you to directly access the record, then the added overhead of compression/decompression may be lost in all the other computations for setting up/maintaining the connection, accessing the desired row, do data formatting, data transmission and whatnot. Also, here [...]
8373 168 32_Re: DB2 Compression on RVA boxes22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 13 Dec 1999 09:58:08 +0000370_ISO-8859-1 >"If you think compression is so good, why aren't all your tablespaces >compressed?".
one reason is becuase you do not wish to bloat your DBM1 address space with Compression Dictionaries (4K to 64K each) if you are DBM1 (max 2032Mb allowed for the address space) constrained .. and 64bit addressing is not coming for another 12/24 months or so .. [...]
8542 177 32_Re: DB2 Compression on RVA boxes13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 13 Dec 1999 07:07:59 -0500383_iso-8859-1 It's my opinion that you wouldn't want to compress 'everything' because some tablespaces are so small, the compression dictionary would be larger than the space required to hold the data. I have seen compression cut a batch cycle in half, (two hours to one) in an application's database that contained multi-million row tables with insert, update, delete processing. [...]
8720 215 32_Re: DB2 Compression on RVA boxes13_Adrian Savory24_adrian.savory@ZURICH.COM31_Mon, 13 Dec 1999 12:10:32 +0000586_us-ascii A few more reasons....
First and foremost compression is used to make the object smaller, either to save DASD, or for performance reasons i.e. better coverage within your buffer pools. (If you are using RAID then you may not be so concerned about the former, though you can still save more space than if you just use RAID compression - see Chapter 2 of the 'Using RVA and Snapshot...' redbook (SG24-5333-00) for some figures for RVA.) This may be stating the obvious but it is possible to implement compression and end up using more space as you need to accomodate [...]
8936 202 32_Re: DB2 Compression on RVA boxes22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 13 Dec 1999 11:40:58 +0000506_ISO-8859-1 >By the way, DB2 for AS400 automatically compresses data. One has no >choice in turning it on or off.
oooooooouuuuuuuuuuuuuuch
never worked ont his platform - but I have on Unix/NT/OS2 etc .. and this would be a real pain.
Leslie Pendlebury-Bowe
______________________________ Reply Separator _________________________________ Subject: Re: DB2 Compression on RVA boxes Author: Lynne Flatley at Internet Date: 12/13/99 7:07 AM [...]
9139 37 47_DB2 moving from OS390 to NT or UNIX for example0_24_James_Hughes@MANDG.CO.UK31_Mon, 13 Dec 1999 12:52:45 +0000561_us-ascii Hello all Has anyone reviewed or implemented a move as above, or similar and could give me some pointers on the best areas/publications to gain more information. We are currently DB2 v4.1 and will be upgrading to v5 by June 2000. I have a preference to then perform a further upgrade to OS390 version 6, but the company direction may be taking us away from OS390 and onto another platform/operating system. Hence I anticipate trying to move from version 5 to DB2 UDB on the alternative platform then. Thanks in advance for your help. James Hughes [...]
9177 11 11_Query db2-l18_Andrade, Alexander25_alexander.andrade@CAI.COM31_Mon, 13 Dec 1999 13:29:31 -0000244_-
================================================ 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.
9189 103 33_Re: Reply to Re: DB2 Image Copies0_23_Mike_Levine@TEKHELP.NET31_Mon, 13 Dec 1999 08:31:05 -0500322_us-ascii Hi,
Most shops (unless the image copy jobs are generated dynamically with unique dataset names) use GDGs to set up a 'cycle' of image copies that roll off after so many generations. GDGs have to be cataloged. The GDG tape datasets are under catalog control so they uncatalog and expire automatically. [...]
9293 69 6_DARWIN7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Mon, 13 Dec 1999 11:31:50 -0300237_iso-8859-1 Hi, folks...
Is anyone using "DARWIN" (an alternative to DSNTEP2 developed by GSE UK DB2 Working Group)? Thank you very much.
Gustavo Lozano (lozano@bandeirantes.com.br) - DBA Banco Bandeirates Sao Paulo - Brazil
9363 89 32_Re: DB2 Compression on RVA boxes13_John Arbogast16_jfarbo@YAHOO.COM31_Mon, 13 Dec 1999 05:39:05 -0800638_us-ascii If your processor doesn't support hardware compression, call your electrical supplier and have them start their reserve power generating capacity before using software compression. Your data center lights might dim like a B grade prison movie.
:)
--- craig patton wrote: > One small comment on being CPU constrained, DB2 > compression, when done with > 'hardware microcode', costs in the range of about > .5% additional CPU (yes > that is 'point' 5%). I would use compression even > if CPU constrained as the > I/O savings (GETPAGE uses cpu cycles) will more than > make up for [...]
9453 29 55_Autostarting the JDBC Applet Server for UDB v6.1 on AIX0_22_BILL_GALLAGHER@PHL.COM31_Mon, 13 Dec 1999 08:46:53 -0500398_us-ascii Hi,
We are trying to automate the starting of the JDBC Applet Server for UDB v6.1 on AIX. There does not seem to be anything that I can find in the UDB documentation for how to do this. Right now, we have to do this manually after each AIX reboot. We tried inserting the following command as the last line in our /etc/inittab startup procedures, but it did not appear to work: [...]
9483 86 23_Re: Unlimited Hierarchy13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Mon, 13 Dec 1999 09:15:47 -0500412_us-ascii See March 1996 (and later articles in the series) by Joe Celko from the DBMS magazine archives at:
http://www.dbmsmag.com/artin301.html
for a discussion of how to implement tree structures in SQL, which seems to be one possible answer to your question.
-- Lockwood Lyon Amway Corp
Please respond to DB2 Data Base Discussion List [...]
9570 66 16_DB2 Image Copies11_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Mon, 13 Dec 1999 09:11:36 -0500541_us-ascii The topic of whether to catalog or not seems to be a hot topic the past few day in this discussion list. I think the important thing to keep in mind with this topic, or any other topic, such as compression is that you have many choices, so you have to find what works best for your shop. No single technique is always the correct technique for every shop. I catalog my localsite image copies, but I do not catalog my image copies that I take offsite to use for disaster recovery. Having the image copies cataloged is great for [...]
9637 84 10_Re: DARWIN12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Mon, 13 Dec 1999 10:25:45 -0500332_iso-8859-1 Yes, I recently started using it. There were a couple of minor hicups in the beginning (which I reported to the author -- he responded that some folks had the same problems, others didn't). Those were quickly resolved, though, and it seems to be working well. It's a godsend for those of us on systems without PL/I. [...]
9722 103 10_Re: DARWIN11_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Mon, 13 Dec 1999 10:29:11 -0500693_us-ascii I have not used Darwin, but DB2 Version 6 comes with DSNTEP2 as an object module, so you will no longer need the PL/I compiler.
"Lisle, Kathy" on 12/13/99 10:25:45 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Jim Knisley/TFG/HII) Subject: Re: DARWIN
Yes, I recently started using it. There were a couple of minor hicups in the beginning (which I reported to the author -- he responded that some folks had the same problems, others didn't). Those were quickly resolved, though, and it seems to be working well. It's a godsend for [...]
9826 34 32_Re: DB2 Compression on RVA boxes12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 13 Dec 1999 07:46:12 -0800376_us-ascii When we ran our first tests for reorg with keepdictionary back in V3, we found that the savings in handling the shorter files for input and output more than made up for the cost of decompression for extracting keys. The range for the runs was in the range of no difference to about 10% less cpu time. Our runs are in the red book on DB2 performance - GG24-4284. [...]
9861 137 10_Re: DARWIN9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Mon, 13 Dec 1999 15:50:53 +0000440_us-ascii
Do you still get the DSNTEP2 source at V6 (we increase the SYSPRINT blocksize to improve performance for large reports) ? Kind Regards, Andy Hunt - Scottish And Southern Energy
Jim Knisley on 13/12/99 15:29:11
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: DARWIN [...]
9999 19 26_Compression & Online Reorg16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Mon, 13 Dec 1999 10:51:06 -0500489_iso-8859-1 Hey Folks. Can someone tell me when I use online reorg of a tablespace that is compressed, if the 'B' data sets are compressing the data also? thanks...
Michael Dempsey Data Base Administration UNC Health Care System 919.966.4696
================================================ 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.
10019 82 20_Contract Opportunity11_Chris Beaty20_cbeaty@EARTHLINK.NET31_Mon, 13 Dec 1999 08:52:14 -0800511_iso-8859-1 Our client in southern Illinois is seeking two experienced DB2 UDB DBA's. You will need to have experience with DB2 and NT. Will be performing DBA functions; Implementation, tuning, support, knowledge transfer, consult client on DB2 issues, software, etc. Rate is open. H-1B's are ok. We will only work however with those firms who directly hold an employees visa. This is at the moment a one year contract. Send resumes in confidence to cbeaty@earthlink.net or call the toll free number below. [...]
10102 115 24_Re: Contract Opportunity11_sanjay jain25_sanjay_jain@EMAIL.MSN.COM31_Mon, 13 Dec 1999 11:26:26 -0800706_iso-8859-1 I can not relocate to Illinois. -----Original Message----- From: Chris Beaty Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Monday, December 13, 1999 8:03 AM Subject: Contract Opportunity
Our client in southern Illinois is seeking two experienced DB2 UDB DBA's. You will need to have experience with DB2 and NT. Will be performing DBA functions; Implementation, tuning, support, knowledge transfer, consult client on DB2 issues, software, etc. Rate is open. H-1B's are ok. We will only work however with those firms who directly hold an employees visa. This is at the moment a one year contract. Send resumes in confidence to [...]
10218 58 50_DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Mon, 13 Dec 1999 11:31:30 -0500353_- We are coding DB2 COBOL/LE stored procedures that are called from a Visual Basic 6 client application. In the stored procedure, a cursor is declared WITH RETURN and left open. In the VB app, we are looping through an ADO recordset to retrieve the result set. Offsets are used in the recordset object to reference the returned columns as follows: [...]
10277 284 6_DARWIN7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Mon, 13 Dec 1999 14:56:19 -0300522_- 1 J E S 2 J O B L O G -- S Y S T E M S Y S 2 -- N O D E B A N D M V S 0 14.54.05 JOB09959 ---- MONDAY, 13 DEC 1999 ---- 14.54.05 JOB09959 IRR010I USERID STX06 IS ASSIGNED TO THIS JOB. 14.54.05 JOB09959 ICH70001I STX06 LAST ACCESS AT 14:53:20 ON MONDAY, DECEMBER 13, 1999 14.54.05 JOB09959 $HASP373 STX06JOB STARTED - INIT S2 - CLASS 2 - SYS SYS2 14.54.05 JOB09959 IEF403I STX06JOB - STARTED - TIME=14.54.05 14.54.06 JOB09959 IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=04E REASON CODE=00E7000C TIME=14.54.06 [...]
10562 50 37_Re: Distributed threads holding locks0_39_brian_holroyd.consultant@PEOPLESOFT.COM31_Mon, 13 Dec 1999 09:17:14 -0800401_us-ascii Jim,
It has been my experience that IDTHTOIN should not be applicable for INACTIVE threads, so I would be interested to know if I am wrong.
Threads defined as active (CMTSTAT=ACTIVE) that have completed a UOW (idle active threads) will get cancelled when they hit the IDTHTOIN value. The idea is to free up those threads so that they don't contribute to the MAXDBAT limit. [...]
10613 14 31_Heads up-Top Secret Y2K problem12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 13 Dec 1999 11:01:00 -0500330_- If you have Top Secret at your shop, you might want to check APAR LO39229 (That's an O like Ohio) and solution # 1562 from CA. This is a password expiring issue that occurred during our testing regarding CICS and Top Secret. In some specific circumstances, passwords that worked on Dec 31,1999 did not work on Jan 1, 2000. [...]
10628 285 12_STILL DARWIN7_Gustavo26_lozano@BANDEIRANTES.COM.BR31_Mon, 13 Dec 1999 15:26:24 -0300522_- 1 J E S 2 J O B L O G -- S Y S T E M S Y S 2 -- N O D E B A N D M V S 0 14.54.05 JOB09959 ---- MONDAY, 13 DEC 1999 ---- 14.54.05 JOB09959 IRR010I USERID STX06 IS ASSIGNED TO THIS JOB. 14.54.05 JOB09959 ICH70001I STX06 LAST ACCESS AT 14:53:20 ON MONDAY, DECEMBER 13, 1999 14.54.05 JOB09959 $HASP373 STX06JOB STARTED - INIT S2 - CLASS 2 - SYS SYS2 14.54.05 JOB09959 IEF403I STX06JOB - STARTED - TIME=14.54.05 14.54.06 JOB09959 IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=04E REASON CODE=00E7000C TIME=14.54.06 [...]
10914 105 29_Re: Sequential Key Generation11_James Drewe20_James.Drewe@AEXP.COM31_Mon, 13 Dec 1999 09:51:42 -0700579_- Jay
As a matter of routine for OS/390 DB2 (OLTP), I attempt to avoid generated numbers -- either on a single table or a separate table. Perhaps there is another solution.
One consideration that you have to keep in mind if you use the number generator is the select max(key) with ur. You avoid locking, but you may increase the integrity exposure if you have a fairly active system. That is, you may find duplicate generated numbers (assuming that you are incrementing the max(key) by one) because your uncommitted read may not truly be getting the max(key). [...]
11020 31 47_DB2 Connect new install - apply maint-- in use?0_14_dcreed@CSC.COM31_Mon, 13 Dec 1999 11:33:34 -0600376_us-ascii I have new installation of DB2 CONNECT. Everything goes ok. I stop the DB2 -DB2 in the Settings --> Control Panel --> Services. When I run the setup program for the upgrade I get DB2 is in use. I cannot find any db2**** tasks in the task manager to end process on. There are also no NTVDM running. Any clues as to what else is running that I need to get rid of? [...]
11052 140 10_Re: DARWIN12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Mon, 13 Dec 1999 12:42:12 -0500381_iso-8859-1 It's been a few weeks since I started using DARWIN, so I don't remember the precise problems I was having. However, here are the "fixes" I made:
* In BA-MAIN SECTION, initialize DATA-LEN to 0 (probably unrelated to this problem, but might prevent another one). * In FC-FORMAT-VARCHAR SECTION, change the IF SMALLINT-R < COL-OUTLEN(COL-SUB) . . . as follows: [...]
11193 21 23_SQLCODE or SQLSTATE ???14_Theisen, Craig22_CTheisen@GUIDEMAIL.COM31_Mon, 13 Dec 1999 12:11:38 -0600390_iso-8859-1 We are a fairly new 0S/390 DB2 rel 5.1 shop with a clean slate and we are still establishing our applications standards and common routines. Are any other newer IBM mainframe shops willing to share some info on what they are using: ANSI- SQLSTATE or IBM's SQLCODE and why? I expect that either to work equally well, but are there some subtle advantages of 1 over the other? [...]
11215 24 39_how can I create a full db by db2batch?8_Giuseppe18_dedonno@ARIADNE.IT31_Mon, 13 Dec 1999 19:28:10 +0100325_us-ascii Hi, I need to create a db by db2batch command or similar from a file ddl created by db2look command. The file ddl contains the connect instruction "connect to ...", how can
I create the same db on another machine without the db descript in this command? How can I create the complete db by the ddl file? [...]
11240 37 43_Re: how can I create a full db by db2batch?13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 13 Dec 1999 12:53:02 -0600420_US-ASCII I Assume the database does not exist on the other machine, change the "connect to" statement to a "create database" command. and the ddl should run fine. HTH Kurt
>>> Giuseppe 12/13/99 12:28PM >>> Hi, I need to create a db by db2batch command or similar from a file ddl created by db2look command. The file ddl contains the connect instruction "connect to ...", how can [...]
11278 38 26_Suppress DSNU406I Messages11_Carl Nelson20_Carl_Nelson@AICI.COM31_Mon, 13 Dec 1999 14:12:09 -0600557_US-ASCII List,
I am getting "DSNU406I %DSP DSNUBACP - FULL IMAGE COPY SHOULD BE TAKEN FOR BOTH LOCAL SITE AND RECOVERY SITE" messges. I understand why and how I am getting them. Our imagecopy steps have a return code checking step which are getting triggered because the return code is greater than zero. The return code checking step abends the job if the return code is greater than zero and the DBA staff gets a phone call in the night to look at the job. I do not want to change all imagecopy jobs to produce both local and off-site copies. [...]
11317 18 10_Re: DARWIN12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 13 Dec 1999 11:06:32 -0800478_us-ascii You still get the source, but you get an object module too.
For the first time in V6, we have a prerequisite level of OS/390 which includes the LE 370 code needed to support shipping an object module.
Roger Miller
================================================ 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.
11336 33 43_Re: how can I create a full db by db2batch?8_Giuseppe18_dedonno@ARIADNE.IT31_Mon, 13 Dec 1999 20:21:26 +0100399_us-ascii Kurt Sahlberg wrote:
> I Assume the database does not exist on the other machine, > change the "connect to" statement to a "create database" command. > and the ddl should run fine. > HTH > Kurt >
Ok, but I have this error:
C:\tmp>db2batch -f fileCreateddl ERROR!!! -> No database name has been specified on thecommand line nor in the environment variable DB2DBDFT [...]
11370 62 43_Re: how can I create a full db by db2batch?16_Michael McCarthy24_Michael_McCarthy@DTC.ORG31_Mon, 13 Dec 1999 14:38:10 -0500378_us-ascii Giuseppe,
If you're going to use db2batch, you must first create the database you will be connecting to. If you have modified your command file as per Kurt's suggestion, just enter db2 -vtf > from the command line( DB2 Command Window for Win NT).
This will execute the command file and place the results in . [...]
11433 78 54_Re: DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets14_Steven Camitta30_steven.camitta@INGRAMMICRO.COM31_Mon, 13 Dec 1999 11:35:15 -0800496_iso-8859-1 Joseph, In using CLI, we were not able to obtain the column names on the stored procedure results until we changed our ZPARM to use DESCSTAT=YES. It's within the DSN6SPRM macro. I'm not familiar with the VB access but making this change is probably a prerequisite. Rgds, Steve
-----Original Message----- From: DeMarco, Joseph [mailto:DeMarcoJ@CONED.COM] Sent: Monday, December 13, 1999 8:32 AM To: DB2-L@RYCI.COM Subject: DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets [...]
11512 244 28_Re: Field Procedure Glitches12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 13 Dec 1999 11:15:25 -0800322_us-ascii I'm not sure how to handle the QMF SAVE DATA for new table situation. I don't know QMF that well or exactly what it does.
The trigger should handle the UNION situation just fine. It should be able to invoked whenever (either before or after) you request the data and then perform the sort as desired. [...]
11757 46 42_Re: DB2 5.0 stored procedures and servlets14_Steven Camitta30_steven.camitta@INGRAMMICRO.COM31_Mon, 13 Dec 1999 11:49:30 -0800707_iso-8859-1 Daniel, Are you closing the result set? rs.close() Rgds, Steve
-----Original Message----- From: Daniel Kirby [mailto:daniel.kirby@CITICORP.COM] Sent: Friday, December 10, 1999 11:43 AM To: DB2-L@RYCI.COM Subject: DB2 5.0 stored procedures and servlets
Dear All, I am trying to call a DB2 5.0 (mainframe) stored procedure from a java servlet. I am using driver COM.ibm.db2.jdbc.app.DB2Driver on a NT server using servletexpress. The stored procedure returns one result set. Trying to call a stored procedure with IN parameters fails on "executeQuery". I tried to call a new stored procedure with no IN or OUT parameters. This time the executeQuery worked, but I [...]
11804 123 32_Re: DB2 Compression on RVA boxes24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Mon, 13 Dec 1999 13:02:46 -0600585_iso-8859-1 Hi Jim,
I think there are a lot of ways of running DB2 benchmarks which can skew the results and/or have different cpu ratio's. The primary way to skew a test is by using a small amount of data which has already been read and therefore resides in the bufferpool.
Even if a test is controlled to eliminate buffer pool effects (either both benchmarks use pre-loaded data or neither does) there may be other factors which might interfer with a benchmark. The load on DB2; did a checkpoint occur during a benchmark; did a buffer pool threshold hit during the [...]
11928 71 30_Re: Suppress DSNU406I Messages17_Scarcella, Gary V21_ScarcellaGV@AETNA.COM31_Mon, 13 Dec 1999 15:04:01 -0500604_- We only abend our image copy jobs if the RC > 4.
Gary Scarcella Internet address: ScarcellaGV@aetna.com
> ---------- > From: Carl Nelson[SMTP:Carl_Nelson@AICI.COM] > Reply To: DB2 Data Base Discussion List > Sent: Monday, December 13, 1999 3:12 PM > To: DB2-L@RYCI.COM > Subject: Suppress DSNU406I Messages > > List, > > I am getting "DSNU406I %DSP DSNUBACP - FULL IMAGE COPY SHOULD BE TAKEN FOR > BOTH > LOCAL SITE AND RECOVERY SITE" messges. I understand why and how I am > getting > them. Our imagecopy steps have a return code checking step which are > getting > [...]
12000 53 43_Re: how can I create a full db by db2batch?13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 13 Dec 1999 14:13:28 -0600329_US-ASCII Just issue db2 -tvf path:\your ddl > output.file from the command line.
Your input file ddl should have a "create db xxxxxxx" followed by a "connect to db" and then the rest of your ddl. If you want to run the db2batch program you will have to create the database first, and then run your ddl file. HTH Kurt [...]
12054 54 59_Answer to : DB2 Connect new install - apply maint-- in use?0_14_dcreed@CSC.COM31_Mon, 13 Dec 1999 14:20:33 -0600420_us-ascii I asked for help with the following:
I have new installation of DB2 CONNECT. Everything goes ok. I stop the DB2 -DB2 in the Settings --> Control Panel --> Services. When I run the setup program for the upgrade I get DB2 is in use. I cannot find any db2**** tasks in the task manager to end process on. There are also no NTVDM running. Any clues as to what else is running that I need to get rid of? [...]
12109 80 63_Re: Answer to : DB2 Connect new install - apply maint-- in use?12_Rakesh Madan22_rmadan@CYVEILLANCE.COM31_Mon, 13 Dec 1999 15:26:26 -0500574_iso-8859-1 click on startup options and click manual or disable and reboot....do it for both db2admin and db2
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On > Behalf Of > dcreed@CSC.COM > Sent: Monday, December 13, 1999 3:21 PM > To: DB2-L@RYCI.COM > Subject: Answer to : DB2 Connect new install - apply maint-- in use? > > > I asked for help with the following: > > I have new installation of DB2 CONNECT. Everything goes ok. > I stop the DB2 -DB2 in the Settings --> > Control Panel --> Services. > When I run the [...]
12190 99 54_Re: DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Mon, 13 Dec 1999 15:26:10 -0500614_- Steve,
Thanks for the reponse, but we changed DESCSTAT=YES and still were not able to reference the column names.
Joe
> -----Original Message----- > From: Steven Camitta [SMTP:steven.camitta@INGRAMMICRO.COM] > Sent: Monday, December 13, 1999 2:35 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets > > Joseph, > In using CLI, we were not able to obtain the column names on the stored > procedure results until we changed our ZPARM to use DESCSTAT=YES. It's > within the DSN6SPRM macro. I'm not familiar with the VB access but making > this change [...]
12290 20 51_Re: DB2 Connect new install - apply maint-- in use?14_C. L. Phillips25_clphillips@MINDSPRING.COM31_Mon, 13 Dec 1999 15:32:37 -050054_us-ascii Are you Running Netfinity, perchance?
12311 39 27_Re: SQLCODE or SQLSTATE ???32_Kumar, Hemant (CORP, Consultant)29_Hemant.Kumar@CORPORATE.GE.COM31_Mon, 13 Dec 1999 15:37:55 -0500504_- In my previous project which was a huge development endeavor, the standards prescribed the use of SQLSTATE rather than SQLCODE. There were some points mentioned in favour of SQLSTATE but can't remember all of them right away. One of the things was for compatibility with ANSI SQL standard.
Hemant Kumar
-----Original Message----- From: Theisen, Craig [mailto:CTheisen@GUIDEMAIL.COM] Sent: Monday, December 13, 1999 1:12 PM To: DB2-L@RYCI.COM Subject: SQLCODE or SQLSTATE ??? [...]
12351 80 54_DB2 Image Copies: a consideration on catlog or not....14_Max 'Guderian'16_mocion@LIBERO.IT31_Mon, 13 Dec 1999 22:42:07 +0100328_us-ascii All cataloged dataset depends on a ICF catalog (it was my first job..), and for this reason in our
disaster recovery plan we have sequential files containing a LISTCAT and a list of all tablespaces
& indexes (+ a print copy) of all catalogs, as I wrote in a previous post. It costs very little and I [...]
12432 84 27_Re: Operating System & DBMS10_Deb Jenson17_DJenson@QUEST.COM31_Mon, 13 Dec 1999 14:28:34 -0800451_iso-8859-1 Jeff, There is a web site referencing PSM and stored procedure builder:
http://www-4.ibm.com/software/data/db2/os390/sqlproc/
I have not gotten a date from IBM, but this is beta for OS/390, not sure about Unix, NT. Also the URL references a white paper previewing PSM and it looks similar to PL/SQL.
Deb Jenson Director DB Tools Quest Software 4320 Winfield Rd., Suite 200 Warrenville, IL 60555 Tel: 630/ 836-8428 [...]
12517 51 76_Re: UDB V6.1 NT Control Center error while trying to view connections on AIX0_25_Pierre.Evans@AUTOZONE.COM31_Mon, 13 Dec 1999 16:09:46 -0600411_us-ascii Paul, did you get any further with this ? I've just run into it here as well. Pierre
"Martin, Paul" on 12/08/99 10:22:05 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Pierre Evans/STS/AUTOZONE) Subject: UDB V6.1 NT Control Center error while trying to view connections on AIX [...]
12569 16 24_DB2 V4 Lifespan question12_Tony Babonas14_Asbdb2@AOL.COM29_Mon, 13 Dec 1999 18:45:54 EST424_us-ascii Has IBM annnounced a date at which support for DB2 version 4 will stop? We are just now planning an upgrade to V5/V6.
Is an upgrade from V4 to V6 (directly) possible?
================================================ 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.
12586 96 51_Re: DB2 Connect new install - apply maint-- in use?0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 14 Dec 1999 08:51:57 +0800419_us-ascii Danny,
This can be caused by any NT monitoring program (amongst other things) and it can even be someone on another workstation with a monitor running against your machine.
There's a couple of ways around it. Ages ago on the (old) list, someone posted an answer about a LISTDLLS.EXE module which lets you see what processes may be attached to your DB2 - and then you can kill them yourself. [...]
12683 46 28_Re: DB2 V4 Lifespan question12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 13 Dec 1999 17:19:38 -0800364_us-ascii At this point, there is no announced date for end of V4 support. My guess for the end of support would be some time in 2001, roughly 6 years of general availability. Most customers have already migrated to V5.
From V4, the only direct migration is to V5, and you can only migrate to V6 from V5, so there is not upgrade directly from V4 to V6. [...]
12730 15 15_Quiesce Problem22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM29_Mon, 13 Dec 1999 17:16:10 PST465_- This messages means there was some type of "resource unavailable" condition on the index. Look for a DSNT500 message or similar message to the console. The REBUILD INDEX would have corrected many such problems.
Dan
================================================ 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.
12746 17 21_The cost of a getpage0_22_kmulcahy@CHECKFREE.COM31_Mon, 13 Dec 1999 20:28:03 -0500461_us-ascii What is a good, standard, in general, all-purpose estimate for the overhead of a getpage from a DB2 buffer? I scanned the "capacity" red book quickly and nothing popped out!
Kevin Mulcahy CheckFree 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.
12764 95 59_Re: Autostarting the JDBC Applet Server for UDB v6.1 on AIX11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Mon, 13 Dec 1999 22:04:48 -0500425_iso-8859-1 db2jstrt takes a port number argument, and I don't see that specified in your example.
You might also change your /etc/inittab so that it runs script named /etc/rc.jdbc_startup
Script /etc/rc.jdbc_startup should do a switch user to the instance owner:
su - db2inst1 -c "db2jdbc_start NNNN"
Where NNNN is the port number and db2jdbc_start is a script on db2inst1's path containing: [...]
12860 23 30_Servlets, Methodology, JDBC...22_Leonardo Kenji Shikida16_kenji@PIB.COM.BR31_Tue, 14 Dec 1999 13:48:38 -0200554_us-ascii Is there any DB2 Servlets samples ? Is there any metodology to develop using them ? Something like design patterns to databases or a kind of UML for Databases ? Of course, I'll use a ER to model, but what about the software (application) process ?
Suggestions ?
Thanks in advance
K.
================================================ 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.
12884 50 32_Re: DB2 Compression on RVA boxes15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Mon, 13 Dec 1999 01:36:25 -0600434_us-ascii Since the DBAs think I'm just a "DASD guy", I was never involved in the benchmarks. I am ONLY able to look at it post-compression-decision. Here is the pertinent info:
LARGE table (about 1000 cyls - I don't know exactly as it is ptn'ed, I believe)
90+% buffer hit (neither randomr or seq. access is far away from the other - i.e. both are high as we have/had about 60,000 pages for this compressed) table. [...]
12935 40 25_Re: The cost of a getpage14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Tue, 14 Dec 1999 15:17:11 +1100659_- Kevin,
The only reference I've got is 0.11 millisec on a 3090J (does not include additional cost required for physical I/O). The reference is from one of Michael Hannan's IDUG presentations, which he would have sourced from Akira Shibamiya (IBM Santa Teresa Lab).
Regards Terry Purcell CPT Consulting
> -----Original Message----- > From: kmulcahy@CHECKFREE.COM [SMTP:kmulcahy@CHECKFREE.COM] > Sent: Tuesday, 14 December 1999 12:28 pm > To: DB2-L@RYCI.COM > Subject: The cost of a getpage > > What is a good, standard, in general, all-purpose estimate for the > overhead of a getpage from a DB2 buffer? I scanned the "capacity" red [...]
12976 71 28_Re: DB2 V4 Lifespan question14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Tue, 14 Dec 1999 06:28:25 -0000300_- Although true migration from V4 to V6 is not possible, it IS possible to install a new V6 subsystem and migrate the contents of a V4 subsystem to it. This is not as bad as it sounds as there are third-party tools to help with migration of objects WITHOUT unloading and reloading all the data. [...]
13048 18 43_Re: how can I create a full db by db2batch?8_Giuseppe18_dedonno@ARIADNE.IT31_Tue, 14 Dec 1999 09:38:56 +0100382_us-ascii Very well. Thank you, it works fine. Last question: how can I create un user in this ddl file? Bye and thank you very much giuseppe
================================================ 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.
13067 62 21_Re: Cluster missing..14_Grainger, Phil21_Phil.Grainger@CAI.COM31_Tue, 14 Dec 1999 10:13:50 -0000334_- I'm just getting caught up with all my eMails so......
Db2 is pretty smart (but we knew that already).
if it ever tries to delete a cluster and gets an error from IDCAMS saying that the cluster isn;t there to delete, it just shrugs it's shoulders, says "well, I didn't want it to be there anyway" and presses on. [...]
13130 77 30_Re: Compression & Online Reorg0_18_mebert@AMADEUS.NET31_Tue, 14 Dec 1999 12:35:34 +0100562_us-ascii Hello,
assuming that with 'B' datasets you mean the shadow datasets, yes they're compressed also, by necessity: after all, they replace the original datasets during the SWITCH phase.
I have just mass-OLR'd our Test DB2 subsystem over the weekend as a kind of pre-2000 cleanup. The subsystem contains 28 GB of data in 4.500 TS, 30.000 VSAM files in toto. This took 47 hours, running two job streams in parallel (I didn't have more initiators), 36 jobs total. Here's some OLR timings from this (there was no other work on the machine): [...]
13208 40 27_V5 for OS/390 list prefetch4_vcei14_vcei@CEGEKA.BE31_Tue, 14 Dec 1999 12:32:49 +0100391_iso-8859-1 First, thanks to Micheal Hannan and Isaac Yassin for their answer on our MLT IX email, some weeks ago. We haven`t had time yet to implement the "Multi-Column Cardinalities" statistics, trying to get rid of some stupid multi-index access.
Even with single index access, we have some badly performing IMS transactions. Though usage is made of the best possible index... [...]
13249 20 4_-55914_MARINO SAVOLDI23_db2dba@TECHNOLOGIST.COM31_Tue, 14 Dec 1999 12:53:07 +0100411_iso-8859-1 Hallo, where i can found some info about a sqlcode -559 in a DLI/DB2 batch ?
THANKS Marino Savoldi db2dba@technologist.com BANCA LOMBARDA Brescia Italy
================================================ 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.
13270 76 77_Re: UDB V6.1 NT Control Center error while trying to view connect ions on AIX12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Tue, 14 Dec 1999 05:59:57 -0600428_iso-8859-1 NO! It only occurs on when we select connections so we just don't use it.
-----Original Message----- From: Pierre.Evans@AUTOZONE.COM [mailto:Pierre.Evans@AUTOZONE.COM] Sent: Monday, December 13, 1999 4:10 PM To: DB2-L@RYCI.COM Subject: Re: UDB V6.1 NT Control Center error while trying to view connections on AIX
Paul, did you get any further with this ? I've just run into it here as well. Pierre [...]
13347 44 8_Re: -5590_20_John_Lendman@FPL.COM31_Tue, 14 Dec 1999 07:37:15 -0500418_us-ascii The message mean that someone disabled the authorization mechanism in DB2. You need to turn this on if you want to be able to GRANT or REVOKE DB2 authority. This is in the ZPARMS.
John
MARINO SAVOLDI on 12/14/99 06:53:07 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: -559 [...]
13392 79 21_Re: Cluster missing..0_23_Mike_Levine@TEKHELP.NET31_Tue, 14 Dec 1999 07:51:01 -0500582_us-ascii Sorry Phil, but the fatal error would be on the define (catalog error). DB2 may continue on the delete error but would not be able to define the new cluster.
Regards,
Michael Levine Premier Data Services, Inc.
>I'm just getting caught up with all my eMails so...... > >Db2 is pretty smart (but we knew that already). > >if it ever tries to delete a cluster and gets an error from IDCAMS saying >that the cluster isn;t there to delete, it just shrugs it's shoulders, says >"well, I didn't want it to be there anyway" and presses on. > >So, [...]
13472 74 38_Re: Use of DB2 online reorg product(s)0_29_Joseph_Esposito@PUTNAMINV.COM31_Tue, 14 Dec 1999 07:48:14 -0500349_us-ascii I could not disagree more about CDB. We have been using CDB RW Reorg for more that 2 years and have been extremely happy with the quality and performance of the product, and the support has been excellent. If we have any technical question it has been answered very quickly and have spoken to the developers of the product many times. [...]
13547 22 8_Re: -5590_27_Bud.Greenman@ONONDAGA.NY.US31_Tue, 14 Dec 1999 08:19:49 -0500456_- -559 ALL AUTHORIZATION FUNCTIONS HAVE BEEN DISABLED
Explanation: The authorization mechanism has been disabled in the DB2 subsystem. Consequently, GRANT and REVOKE statements are ignored.
System Action: The statement cannot be executed. No privileges were granted or revoked.
Programmer Response: Do not attempt to execute GRANT or REVOKE statements unless and until the authorization mechanism is enabled in the DB2 subsystem. [...]
13570 41 28_Re: DB2 V4 Lifespan question0_20_evans036@MC.DUKE.EDU31_Tue, 14 Dec 1999 09:23:48 -0500479_us-ascii tony,
you can do v4->v5->v6 but you cannot then fall back to v4.
good luck,
steve
Tony Babonas on 12/13/99 06:45:54 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: DB2 V4 Lifespan question
Has IBM annnounced a date at which support for DB2 version 4 will stop? We are just now planning an upgrade to V5/V6. [...]
13612 60 31_Re: V5 for OS/390 list prefetch20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 14 Dec 1999 09:36:35 -0500354_- List prefetch is mostly good if it can find atleast 2-3 pages in 150 page range. List prefetch is especially good for badly clustered index. If you have doubt about access path then disable list-prefetch (by using optimize for 1 row etc.) and compare performance with random I/O. Make sure pages are flushed out of buffers when you do comparison. [...]
13673 61 25_Re: The cost of a getpage16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 14 Dec 1999 08:34:38 -0600452_iso-8859-1 Kevin,
It is very difficult due to the following: 1 - In a buffer pool, with VPSEQT=0, the overhead of prefetch staging for a getpage is turned off. Could be as much as 5 to 10% of the overhead of a getpage. 2 - In V6, if using FIFO, another 10% overhead of managing hash and control blocks that occur with LRU, is turned off. 3 - If the page is in a hiperpool, there is a millisecond cost for bringing back to the virtual pool. [...]
13735 74 25_Re: The cost of a getpage20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 14 Dec 1999 09:49:38 -0500371_- Additionally:-
Cost of getpage varies with situation. Tim Lenahan's presentation last IDUG has excellent estimation -
Basic fetch in program - 3500 Instructions Each contiguous columns - 90 instructions Each non contiguous columns - 120 instructions Stage 1 - 500 instructions Stage 2 - 900 instructions Row not qualifying stage 1 - 200 instructions [...]
13810 28 54_Re: DB2 5.1, OS/390 2.5, VB 6 - Retrieving Result Sets15_DeMarco, Joseph18_DeMarcoJ@CONED.COM31_Tue, 14 Dec 1999 09:50:51 -0500594_- Thanks for the input Steven and Tim.
The DESCSTAT parameter was changed to YES, but I neglected to rebind the package for the stored procedure. Once I rebound, it worked!
Mea culpa.
Joe
Joseph DeMarco demarcoj@coned.com Con Edison Information Resources Database Administration 4 Irving Place, Room 428 212.460.3392
================================================ 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.
13839 67 28_Re: DB2 V4 Lifespan question12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 14 Dec 1999 07:00:22 PST276_- Tony, It is possible to skip V5 when going to V6 from V4. Ca/Platinum has a tool (I believe it is called RC/MERGER) that can do this. I haven't gone from V4 to V6 with the tool, but I have gone from V3 to V5, skipping V4. IT is VERY fast and relatively easy to set up. [...]
13907 16 43_DB2 OS/390 Version 5 to version 6 migration12_Martin, Paul22_Paul.Martin@ECOLAB.COM31_Tue, 14 Dec 1999 09:18:06 -0600446_iso-8859-1 I'm doing a migration from version 5 to 6 and when the clist (dsntins0)is building the new jobs it errors out building DSNTIJMV with "IKJ52506I TEXT NOT FOUND".
Anyone run into this yet?
================================================ 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.
13924 76 30_DB2 ERROR CODE and system dump8_Paul May14_dbas@CWCOM.NET31_Tue, 14 Dec 1999 15:13:58 -0000399_iso-8859-1
Running DB2 V4.1 OS390 2.7
We had a TSO batch update process running which caused a SVC system dump and the following DB2 error message. We cannot understand why we are getting this message, does anyone have any idea's what could possibly cause this. There was also a CICS transaction running at the time but the Dump and CICS monitor shows no errors in that process. [...]
14001 40 43_Re: how can I create a full db by db2batch?14_Wayne Driscoll19_WDriscoll@QUEST.COM31_Tue, 14 Dec 1999 07:23:48 -0800448_iso-8859-1 In UDB, users are not created in the database, instead the UDB process uses the native operating system security system to perform authentication. In addition, system wide authorizations (SYSADM, SYSCTRL and SYSMAINT) are maintained by virtue of the user being a member of the appropriate group in the security system. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
14042 41 23_Total Virtual Pool Size9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 14 Dec 1999 15:24:09 +0000389_us-ascii How big are your Virtual Pools ?
Ive heard from an IBM source that problems can occur if you allocate > 500-600 Mb total and that it is recommended total virtual pool allocation is below this (futher expansion should use hiperpools). Ive trawled through the DB2 Storage Informational APARs II04309(II10817) but cant find anything that indicates this problem/strategy. [...]
14084 24 21_Display Thread output12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Tue, 14 Dec 1999 09:29:45 -0600516_- We are on DB2 ver 5.1 When I execute the following command -DIS THREAD(*) TYPE(*) DETAIL I receive the following output: TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F 29757 V436-PGM=BNXO100C.BNXCEHN0, SEC=5, STMNT=654
The first line of output I consider "normal", but I am unfamiliar with the second line. I have looked in the Command Reference and ReferenceSummary books for Ver 5, and have not found a satisfactory explanation.....Has anyone else experienced this output and know what it means??? [...]
14109 38 47_Re: DB2 OS/390 Version 5 to version 6 migration0_23_Mike_Levine@TEKHELP.NET31_Tue, 14 Dec 1999 10:30:33 -0500321_us-ascii Hi,
Yup, ran into this before. Looks like you (or someone you know), modified the SMP/E library SDSNSAMP. You are only permitted to modify the NEW.SDSNSAMP that gets created. The clist must find unmodified text in the original SDSNSAMP library exactly as it expects to find it or you get this error. [...]
14148 87 27_Re: Total Virtual Pool Size13_Adrian Savory24_adrian.savory@ZURICH.COM31_Tue, 14 Dec 1999 15:40:45 +0000459_us-ascii Andy,
I've worked at a site where we had a total virtual pool size of 720Mb and we did experience storage problems (this was an SAP site though - SAP is very hungry on the storage side). We did a number of things to reduce storage requirements, one of which was to reduce the virtual pools to 400Mb and back them with big hiperpools. The hiperpools coped with the load extremely well, so much so that our response times actually dropped. [...]
14236 73 27_Re: SQLCODE or SQLSTATE ???14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 14 Dec 1999 09:44:33 -0600627_ISO-8859-1 SQLCODE contains the SQL return code, which indicates the success or failure of the last SQL statement executed. SQLSTATE performs a similar function as SQLCODE but is consistent across DB2 (and ANSI-compliant SQL) platforms. Always code an IF statement in your programs immediately after every SQL statement to check the value of the SQLCODE or SQLSTATE. In general, when gearing your application programs to check for SQLCODE you can simply check for negative values (that is, SQLCODE < 0). This takes into account that positive SQLCODE values are warnings and SQLCODE = 0 means no rows found. Of course, you [...]
14310 25 43_Re: how can I create a full db by db2batch?8_Giuseppe18_dedonno@ARIADNE.IT31_Tue, 14 Dec 1999 16:56:05 +0100372_us-ascii Wayne Driscoll wrote:
> In UDB, users are not created in the database, instead the UDB process uses > the native operating system security system to perform authentication. In > addition, system wide authorizations (SYSADM, SYSCTRL and SYSMAINT) are > maintained by virtue of the user being a member of the appropriate group in > the security system. [...]
14336 41 25_Re: Display Thread output20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 14 Dec 1999 11:05:32 -0500625_- That is the collection.pkg getting executed at local subsystem. The current sql is section 5 and statement # 654 of that package.
For DRDA the DETAIL options is described in the reference manual but it is not described for LOCAL accesses.
> -----Original Message----- > From: Vernon, John [SMTP:John.Vernon@TWC.STATE.TX.US] > Sent: Tuesday, December 14, 1999 10:30 AM > To: DB2-L@RYCI.COM > Subject: Display Thread output > > We are on DB2 ver 5.1 > When I execute the following command > -DIS THREAD(*) TYPE(*) DETAIL > I receive the following output: > TPTXA07 T * 28796 POOLBNI00008 TX1 BNXO100P 001F [...]
14378 23 27_Re: Total Virtual Pool Size12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 08:01:05 -0800426_us-ascii There are very few absolutes about the sizes. With only 2 GB in the address space as one absolute, some customers who have lots of dynamic statement cache or very large numbers of threads (e.g. query parallelism) found that they needed to reduce their virtual buffer pool sizes.
If you do have large pools and large numbers of users, then it's time to start watching out for the 2 GB address space limit. [...]
14402 41 30_-904 error on DSNDB06.DSNADX0115_Robert Reynolds19_rreynol@INDIANA.EDU31_Tue, 14 Dec 1999 11:05:20 -0500510_us-ascii Using DB2 5.1 under OS/390 2.7. While trying to drop a test database we get a -904. Ran a successful recovery on database and all indexes but -904 persists.
Any ideas on what to do next? Below is full text of error from SPUFI.
SET CURRENT SQLID = 'SYSADM'; ---------+---------+---------+---------+---------+---------+---------+---------
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+---------+--------- [...]
14444 42 47_Re: DB2 OS/390 Version 5 to version 6 migration12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 08:18:46 -0800404_us-ascii The service group can manage this type of problem better than a list server. They often need you to get the list, so that they know which edit command is failing. Do you have the APARs PQ26675, PQ24720, PQ26325 and PQ23724?
Roger
"Martin, Paul" @RYCI.COM> on 12/14/99 07:18:06 AM
Please respond to DB2 Data Base Discussion List [...]
14487 67 27_Re: Total Virtual Pool Size22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 14 Dec 1999 15:23:26 +0000527_ISO-8859-1 Andy I have the calculations infront of me as to how to size your DBM1 Address space (inludes the Virtual Pools).
It is interesting when you do the calculations as to what you have to play with for your Virtual Pools...
Leslie Pendlebury-Bowe DB2 SAP OS390 DB2 UDB Certified etc
______________________________ Reply Separator _________________________________ Subject: Total Virtual Pool Size Author: Andy Hunt at Internet Date: 12/14/99 3:24 PM [...]
14555 60 28_Re: Total Virtual Pool Size122_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 14 Dec 1999 15:24:12 +0000705_ISO-8859-1 me again .. give me an hour and I will post the details to here ..
Leslie
______________________________ Reply Separator _________________________________ Subject: Total Virtual Pool Size Author: Andy Hunt at Internet Date: 12/14/99 3:24 PM
How big are your Virtual Pools ?
Ive heard from an IBM source that problems can occur if you allocate > 500-600 Mb total and that it is recommended total virtual pool allocation is below this (futher expansion should use hiperpools). Ive trawled through the DB2 Storage Informational APARs II04309(II10817) but cant find anything that indicates this problem/strategy. [...]
14616 17 34_Re: -904 error on DSNDB06.DSNADX0112_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 08:24:02 -0800433_us-ascii The next step is generally to look up the reason code in the Messages & Codes. That looks like your catalog index is in trouble. Start with a REBUILD of DSNADX01.
Roger Miller
================================================ 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.
14634 94 32_Re: DB2 Compression on RVA boxes24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Tue, 14 Dec 1999 09:31:50 -0600506_- Hi Jim,
I'm just going to throw out a couple of thoughts. I don't know what DB2's compression looks like or the internals of DB2. But I'll make some statements and ask some questions that you (or someone else) may be able to answer.
Is think the following statement is true: When the administrator guide says "The Corresponding index data is NOT compressed.". I think this means that the the index columns in the data table will be compressed; but the index table will not compressed. [...]
14729 76 31_Re: V5 for OS/390 list prefetch12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 08:48:59 -0800434_us-ascii Two points to consider:
150 CI's is a bit less than 1 cylinder on 3390 or 1 cylinder on 3380. There are 15 tracks per cylinder on both, 12 records per track on 3390, 10 on 3380.
This limit is most useful if the device is physical, like the old 3390, but the RAID disks are virtual. Still, there are situations where the disk controller performance can take advantage of the smaller size, as in prestaging. [...]
14806 62 25_Re: Display Thread output12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Tue, 14 Dec 1999 11:15:07 -0600628_- Venkat, Many Thanks for the response, however, I'm not sure that I understand "why" this information is being displayed. It is displayed in a random fashion, not for all threads executing, and not consistently (in my opinion)....any idea why?
> -----Original Message----- > From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] > Sent: Tuesday, December 14, 1999 10:06 AM > To: DB2-L@RYCI.COM > Subject: Re: Display Thread output > > That is the collection.pkg getting executed at local subsystem. The > current > sql is section 5 and statement # 654 of that package. > > For DRDA the DETAIL options is described [...]
14869 14 21_SQLCODE information..18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM31_Tue, 14 Dec 1999 12:24:41 -0500467_us-ascii I was wondering if there is the description for corresponding SQLCODEs and SQLSTATEs somewhere in the system say in some file ot table where we could pull it up from instead of looking up at Manuals and Book Manager.
================================================ 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.
14884 131 28_Re: DB2 V4 Lifespan question0_25_joseph.burns@HIGHMARK.COM31_Tue, 14 Dec 1999 12:30:16 -0500380_us-ascii We used the RC/MERGER tool about a year ago, and it was a big help. Our situation came from a company merger where we wanted to merge the two DB2 shops into a data-sharing enviroment.
We had a datashare running at V5 in one shop, and a non-data sharing subsystem running at V4 in the other shop. The goal was to add the non-data share V4 to the V5 datashare. [...]
15016 33 25_Sequential Key Generation0_27_mamccormack@STATESTREET.COM31_Tue, 14 Dec 1999 12:27:57 -0500374_US-ASCII To Tim Lowe,
Last Friday you posted a reply on this thread that included:
As I am sure that you have heard, IBM will be putting in a feature in DB2 version 6 called "identity columns" that will be able to automatically increment to build sequential keys. I am looking forward to this to solve some of these types of problems. (in March of 2000?) [...]
15050 19 29_Re: Sequential Key Generation12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 09:40:55 -0800312_us-ascii The What's New? for Version 6 was updated in November and indicates the key content for V6 improvements after GA, as best we know it.
The identity column APAR PQ30652 is closed now, so the closing text has a page or two describing the new function, even though the PTF is not yet available. [...]
15070 46 25_Re: SQLCODE information..11_Jim Knisley27_Jim_Knisley@FORETHOUGHT.COM31_Tue, 14 Dec 1999 12:53:08 -0500548_us-ascii Kartik, Not that I am aware of. We use a product called MVS Quickref. It contains codes and messages for a variety of IBM and non-IBM products, including OS/390 and DB2. Under TSO, you just put your cursor on the message and press a predefined key (we use Shift+F1) and it will bring up the complete description of the message, plus any solutions to the problem as they are described in the IBM manuals. It's really useful for those 2AM calls at home so that I don't have to have a set of messages manuals at home. You could probably [...]
15117 22 27_Re: Total Virtual Pool Size12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 14 Dec 1999 20:02:44 +020082_x-user-defined Hi, I'm on 350Mb-400MB for VBP. 32MB EDM. Don't remember the other.
15140 20 21_Multiple Index Access15_Brian Zamborski18_bzamborski@USS.COM31_Tue, 14 Dec 1999 13:02:46 -0500533_us-ascii Hi all!! I've asked a similar question before, but the same problem keeps cropping up. If a table has 2 indexes defined on it, with one having 3 columns and the other 6 columns, with the 3 columns all being encompassed by the 6 column index as well, and a program needs the other 3 columns in the 6 column index, why is a multiple index access path being selected? The data will be identical since the exact same columns that are in the smaller index are in the larger one. Doesn't it seem to be a time consuming waste [...]
15161 23 7_DSNDB070_20_bjnigh@HOUSEHOLD.COM31_Tue, 14 Dec 1999 10:03:58 -0800335_us-ascii We have heard that the workfiles in DSNDB07 should be defined the same size and without extents. Does anyone have any information as to why the workfiles should be defined this way? We are trying to get the sort workfiles changed by our DB2 system programmer and need solid information to give him regarding this matter. [...]
15185 74 23_Re: Unlimited Hierarchy12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Tue, 14 Dec 1999 20:13:31 +0200443_x-user-defined Hi, I have something similar with Endeavor data about programs and subroutines. I use a table in the following layout: "father_name","father_type","son_name","son_type" per row. each son can be a father as well and to many sons too. A small PL/1 program reads the file an builds a vector with the hierarchy and then displays it. takes sub-second to most problems. The biggest (6000+ rows per root element) takes < 3 sec. elapse.
15260 55 25_Re: SQLCODE information..12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 14 Dec 1999 10:37:06 -0800314_us-ascii I want to have the latest information and need multiple releases most of the time, so I download the PDF files from the DB2 web. That way, I have the updates in the diagnosis information.
I just noted the latest white paper on DB2 performance for the Enterprise Storage Server (a.k.a. Shark). [...]
15316 147 32_Re: DB2 Compression on RVA boxes12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 14 Dec 1999 10:52:30 PST540_- In response to the indexes, you are correct, data in the index is in 'uncompressed' format, ONLY the data in the table get's compressed. Tablespace scans are normally MORE efficient with compression as fewer GETPAGE requests are needed resulting in FEWER I/O's. In my experience, the savings in I/O processing more than makes up for the additional CPU required for the data compression/decompression. Keep in mind as well, DB2 Decompression is extremely fast and efficient. Compression is FAST, but more involved than Decompression. [...]
15464 70 25_Re: SQLCODE information..14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US31_Tue, 14 Dec 1999 13:58:45 -0500670_us-ascii Or -
You could use the following REXX code (I 'acquired' - original author noted) in the TSO environment: Simply copy the following exec to the appropriate concatenation an invoke it with - TSO SQLERR ###
--start cut here-- /* REXX Show a description of an SQLCODE */ /* The message returned will not be complete as I have just set the */ /* SQLCA to initial values (apart from the sqlcode). */ /* Paul Fletcher @ Paul_L_Fletcher@BISCUITS.COM */ ARG SQLCODE SQLC = D2X(SQLCODE,8) SQLC = X2C(SQLC) SQLCA = 'SQLCA 'X2C(00000088)SQLC||X2C(0000)||COPIES(' ',78) SQLCA = SQLCA||COPIES(X2C(00),24)COPIES(' ',16) TIAR_MSG = X2C(0190)COPIES(' ',400) [...]
15535 53 11_Re: DSNDB0712_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 14 Dec 1999 11:03:21 PST325_- The problem with secondary space allocations with the workfiles is that the secondary extents are NOT reusable by new processes and are a waste of DASD. It is NOT uncommon however, to have secondary allocation for the LAST workfile, in order to prevent a large process from failing due to lack of workfile dasd space. [...]
15589 88 11_Re: DSNDB0715_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 14 Dec 1999 14:20:16 -0500559_iso-8859-1 In our environment, the original environment was created with secondary space allocations to all our DSNDB07 work files. Over time, I have seen where they get into maximum extents. So periodically, I delete/define these during our maintenance windows to clean up the extents. I run this process about once a quarter. My vote is to at provide at least one of each type of work tablespace with secondary extents so as not to cause an outage in case the application really needs more room and if it is not monitored regularly for ongoing growth. [...]
15678 20 11_Re: DSNDB070_31_truman.g.brown@BELLATLANTIC.COM31_Tue, 14 Dec 1999 14:20:22 -0500346_us-ascii Re partitioning 4K work datasets:
This sounds a little weird. DB2 may place multiple 4K work page sets in a single work dataset. Would this be an attempt to locate different parts on different volumes in the hope that DB2 might use them and reduce volume contention (place page sets for one 4K dataset on different volumes)? [...]
15699 56 11_Re: DSNDB0714_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 14 Dec 1999 14:22:47 -0500346_ISO-8859-1 Message text written by DB2 Data Base Discussion List >Also, our system programmer was told by IBM to partition the sort workfiles but DB2 does not seem to want to use the second part during sorting. Does anyone know any reason why these workfiles should be partitioned and if so, how can we get DB2 to use the additional parts?< [...]
15756 38 20_DRDA re-bind problem15_Philip, Sibimon19_PhilipS@SEALAND.COM31_Tue, 14 Dec 1999 14:34:57 -0500724_iso-8859-1 We are testing DRDA from SQLserver using Grandview ODBC driver to DB2 V5.1 on OS/390 V2.6. After I execute the package from client/server, it looks like the thread is still active. Display thread shows as follows
DSNV401I = DISPLAY THREAD REPORT FOLLOWS - DSNV402I = ACTIVE THREADS - NAME ST A REQ ID AUTHID PLAN ASID TOKEN SERVER RA * 7 ws-dal-l3728 L3728 DISTSERV 004A 26342 V437-WORKSTATION=SYSB, USERID=l3728 , APPLICATION NAME=ws-dal-l3728_317_l3728 V445-SEANETA.JBDX.07CF0C0E2646=26342 ACCESSING DATA FOR :JBDX V447--LOCATION SESSID A ST TIME V448-- F0000000000017EC W R2 9934814191741 DISPLAY ACTIVE REPORT COMPLETE DSN9022I = DSNVDT '-DIS THREAD' NORMAL COMPLETION *** Even though [...]
15795 37 26_When is Fast Load Neither?8_Long, Ed15_Ed.Long@FMR.COM31_Tue, 14 Dec 1999 14:35:23 -0500319_- Hi all. I was wondering whether anyone else has had a problem with Ca/Platinum Fast Load similar to the following.
We have 2 DB2 systems on the same image, lets call them X and J. X is non-Datasharing, J is in a 2way datasharing relationship. Both systems are DB2 V5.1, quite up to date maintenance wise. [...]
15833 85 25_Re: Display Thread output20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 14 Dec 1999 14:51:10 -0500645_- John
Any Thread which is active and in DB2 should show you this information.
Status "T" means allied, non-distributed thread and next field is act-ind, an "*" (asterisk) indicates that it is in DB2 and blank indicates otherwise.
> -----Original Message----- > From: Vernon, John [SMTP:John.Vernon@TWC.STATE.TX.US] > Sent: Tuesday, December 14, 1999 12:15 PM > To: DB2-L@RYCI.COM > Subject: Re: Display Thread output > > Venkat, > Many Thanks for the response, however, I'm not sure that I > understand "why" this information is being displayed. It is displayed in > a > random fashion, not for all threads executing, [...]
15919 63 24_Re: DRDA re-bind problem12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 14 Dec 1999 11:56:24 PST698_- Philip,
What values in the BIND were specified for Connect/Disconnect? If defined as EXPLICIT, and the application is NOT specifying DISCONNECT, I believe the thread would stay active until a timeout threshold (if defined).
HTH Craig Patton DB2 DBA
>From: "Philip, Sibimon" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DRDA re-bind problem >Date: Tue, 14 Dec 1999 14:34:57 -0500 > >We are testing DRDA from SQLserver using Grandview ODBC driver to DB2 V5.1 >on OS/390 V2.6. After I execute the package from client/server, it looks >like the thread is still active. Display thread shows as follows [...]
15983 30 25_Re: Display Thread output12_Vernon, John27_John.Vernon@TWC.STATE.TX.US31_Tue, 14 Dec 1999 14:30:33 -0600613_- Venkat, What you have indicated is not happening on our system here, so we are contacting IBM to see if maintenance needs to be added, or if additional steps need to be taken. Many Thanks for the feedback and information, I'll let you know what IBM says.....
Best Regards,
John Vernon DB2 System Administrator Texas WorkForce Commission 101 East 15th Street Austin, Texas 78778 Vice-President, Heart of Texas DB2 Users Group Email: john.vernon@twc.state.tx.us jvernonrr@aol.com Phone: 512-936-3170 Fax: 512-936-3190 "Ability may get you to the top, but it takes character to keep you there." [...]
16014 72 48_Application Change Management for DB2 for OS/39010_Iris Wilde16_wildei@TDBANK.CA31_Tue, 14 Dec 1999 15:52:44 -0500628_iso-8859-1 Our current system to manage the migration of DB2 object changes into production is a (sometimes error-prone) mix of manual procedures, clists and COBOL programs. Several co-workers have proposed developing a better in-house solution that would employ CA-Endevor (our source management system). Before we get started, I'd like to ask you all about your experiences with DB2 Change Management. What products or in-house solutions do you use? What's your experience and/or advice about different approaches? Just curious: is anyone out there using the CA-Endevor for DB2 product? Thanks in advance for your input! [...]
16087 80 34_Re: -904 error on DSNDB06.DSNADX0111_Hilton Tina15_HiltonT@TCE.COM31_Tue, 14 Dec 1999 15:49:34 -0500490_iso-8859-1 Robert,
Sounds like you have a problem in your catalog (DSNDB06.DSNADX01). Have your sysprog check it out. It probably needs to be recovered.
00C90094
Explanation: A data set is in a state that is different from what DB2
expects. Possible causes are:
o A data set was deleted and redefined without DB2's knowledge.
o A previous DB2 failure involving the data set might have occurred. [...]
16168 68 30_Re: When is Fast Load Neither?0_19_csutfin@AMSOUTH.COM31_Tue, 14 Dec 1999 15:03:50 -0600442_- Ed, Is FASTLOAD using the OBID of the object it's loading into? Was the data unloaded using FAST UNLOAD and with the load control parameter set to FASTLOAD?
This would account for the entire input being discarded.
Carol Sutfin AmSouth Bank NA Corporate DBA
"Long, Ed" on 12/14/99 01:35:23 PM
Please respond to DB2 Data Base Discussion List [...]
16237 198 32_Re: DB2 Compression on RVA boxes14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 14 Dec 1999 13:18:09 -0800636_us-ascii Richard,
First, DB2 compression is a "dictionary" style algorithm, very similar to PKZIP -- compressions builds a dictionary, decompression is a lookup. It is also row level, which means some rows do not get compressed. It is not "page level compression".
Table spaces only are compressed, never index spaces. Compression in the table is a "dictionary match" level, and not column level - pure data only - so any reference to index columns regarding what is or is not compressed is meaningless. Understand that when I say 'dictionary match' I am greatly simplifying the tree structure used to implement this [...]
16436 56 11_Re: DSNDB0714_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 14 Dec 1999 13:47:01 -0800411_us-ascii Comments embedded.
--- bjnigh@HOUSEHOLD.COM wrote: > We have heard that the workfiles in DSNDB07 should > be defined the same size and > without extents. Does anyone have > any information as to why the workfiles should be > defined this way? We are > trying to get the sort workfiles changed by > our DB2 system programmer and need solid information > to give him regarding this > matter. [...]
16493 64 52_Re: Application Change Management for DB2 for OS/39014_O'Conner, John26_john.oconner@COURTS.WA.GOV31_Tue, 14 Dec 1999 14:15:13 -0800419_iso-8859-1 We are using BMC Change Manager. We are pleased with it. It remembers to do those things that are easy to forget (rebind packages, regrant privileges, image copy, etc.). It knows when table changes require a Drop/Create and it remembers to unload/reload that table. It's flexible enough, it's reliable, and we get good support. These things are probably true for comparable products from other vendors. [...]
16558 101 30_Re: When is Fast Load Neither?8_Long, Ed15_Ed.Long@FMR.COM31_Tue, 14 Dec 1999 17:15:33 -0500333_- Hi All.
After several adventures we found the problem.
The DISCARDS were because of a DATE field, essentially the input dataset and column disagreed; but this is actually a clever Platinum error message that the subsystem your running on is not defined in the SETUP member of the Platinum parmlib. Neat message. [...]
16660 39 24_SQL SELECT with GROUP BY20_fderrick@scfbins.com20_fderrick@SCFBINS.COM31_Tue, 14 Dec 1999 17:16:06 -0500602_iso-8859-1 In the following SQL query
SELECT Product, Year(Order_Date) as Year_Ordered, Sum(Cost_Amount) as Total FROM PRODUCT_ORDERS GROUP BY Product, ? <-- After Product, I would like to group by the Order_Date year only.
I know that an inline view could be used as well as a traditional view definition. By the way, I am already coding this as an inline view where the columns selected are being joined with another table in an outer select statement. The problem is getting my inner sub-select to group by just the year and not the entire date field. I have tried the following; [...]
16700 23 22_Table Usage statistics12_Kirk Hampton16_khampto1@TXU.COM31_Tue, 14 Dec 1999 17:45:03 -0600359_us-ascii Hi All, I have a request to gather usage statistics on one of our large DB2 tables (who is accessing and how often). I think I can get this by turning on the Security Audit trace for the subsystem, then running a DB2PM report. Anyone have any other ideas for an easier way to extract this info ? BTW, this is DB2 for OS/390 V5.1 on OS/390 V2.6. [...]
16724 41 29_How many parameters in a UDF?14_Campbell James30_James.Campbell@ENERGYIS.COM.AU31_Wed, 15 Dec 1999 10:56:10 +1000410_us-ascii We have started to write UDF's in DB2 UDB for OS/390. One problem we are finding is how to determine the number of parameters passed to one. This is a problem when we want to have the same program receive differing numbers of parameters.
There is an example in SDSNSAMP, but it is written in C (and hence can use (argc, argv) to specify parameters). We want something that works in COBOL. [...]
16766 15 22_Updating System Tables14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 14 Dec 1999 19:04:46 -0500471_us-ascii Somebody here claims he heard from somebody outside (I think from BMC) that there is a system option that allows you to update any column of any catalog table. Does such a thing exist? In what versions? How do you do 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.
16782 77 33_Re: How many parameters in a UDF?14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU31_Tue, 14 Dec 1999 19:14:49 -0500620_us-ascii I don't know much about COBOL, but from my general programming experience, I'd say that chasing save area chains is a dangerous pursuit. What if someone changes the way the compiler works in the future, say to use BAKR instead of STM?
I know nothing about UDFs, so I have to assume that the obvious solution, passing the number of parameters as the first parameter, is not available. If nothing else comes up, I'd suggest that instead of writing the dangerous-to-maintain assembler subroutine, you might consider an assembler front end that analyzes the parameter list and somehow passes the number [...]
16860 72 26_Re: Updating System Tables0_29_Greg.Palgrave@BANKWEST.COM.AU31_Wed, 15 Dec 1999 08:56:48 +0800314_us-ascii Harvey,
Yes, it exists - I believe in all versions of DB2 MVS. There is a 'hidden' ZPARM option that needs to be changed to allow it. It is documented somewhere on the web - I think maybe on BMC or Platinum websites. Alternatively, you can dig through all the zparm macros to try and find it. [...]
16933 14 26_Suppress DSNU406I Messages22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 14 Dec 1999 17:53:51 PST398_- Both the DSNU406I and the DSNU402I will cause this RC=4 and there is no product external to supress the RC=4 for one or both of these messages.
Dan
================================================ 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.
16948 49 26_Re: Updating System Tables16_Richard A Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 14 Dec 1999 21:10:43 -0600614_iso-8859-1 Harvey,
A bigger is question is why would you want to or need to? There are generally ways of accomplishing access path tuning without altering cat stats.
Richard Yevich +=====+======+ Information Technology Consulting, Data Modeling, Advanced Education RYC® Inc. USA: 1-800-664-2421 Int'l: 1-305-361-8585 Fax: 1-512-476-3930 Web: Email: info@ryci.com Offices: USA and Europe DB2® Family and Oracle® Specialists - Parallel Technologies VLDB and Data Sharing Technologies (specialties SAP®, Peoplesoft®) Authors of "DB2 Answers" by Osborne-McGraw Hill, May, 1999 [...]
16998 29 26_UDB on NT - NETBIOS errors0_30_Milorad_Cerovac@TAC.VIC.GOV.AU31_Wed, 15 Dec 1999 14:48:37 +1000462_us-ascii Dear Listers, we've been experiencing a number of problems this morning with our DB2 UDB v 5 production system running on NT. The following messages are being displayed:
DIA3419C "NETBIOS" protocol support error: unexpected return code from the NetBIOS "RESET" command. rc = 0x"23" for adapter "2".
DIA3427C "NETBIOS" protocol support: None of the specified adapters are useable. The "NETBIOS" protocol support cannot be initialized. [...]
17028 89 28_Re: SQL SELECT with GROUP BY0_24_ssethi@LOT.TATASTEEL.COM29_Wed, 15 Dec 1999 04:02:34 GMT410_us-ascii As all of us know that the sequence of the (hypothetical) operations is:
1. FROM clause 2. WHERE clause 3. GROUP BY clause 4. HAVING clause 5. SELECT clause
you can code ur query like this which will be an inline views query ..........................
select product,year_ordered,sum(cost_amount) as total from ( SELECT Product, Year(Order_Date) as Year_Ordered, Cost_Amount [...]
17118 47 15_Re: Bufferpools0_24_ssethi@LOT.TATASTEEL.COM29_Wed, 15 Dec 1999 04:03:01 GMT346_us-ascii I am not sure about any other thresholds except DMTH as i have not found about this in any documents. However all the thresholds are maintained separately (DMTH as well) but reaching DMTH in one pool causes pages not to be released from other pools as well.
I hope some other answers will give new information to me as well. [...]
17166 156 30_Re: UDB on NT - NETBIOS errors11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU31_Wed, 15 Dec 1999 15:09:44 +1100681_- Hi Milorad, UDB/NT Messages manual has NETBIOS errors in Appendix A (x23 is invalid adapter). It suggests: <> Unfortunately, nothing for the DIA error messages.
HTH, Bruce
> -----Original Message----- > From: Milorad_Cerovac@TAC.VIC.GOV.AU [SMTP:Milorad_Cerovac@TAC.VIC.GOV.AU] > Sent: Wednesday, 15 December 1999 15:49 > To: DB2-L@RYCI.COM > Subject: UDB on NT - NETBIOS errors > > Dear Listers, we've been experiencing a number of problems this morning > with our DB2 UDB v 5 production system running on NT. The following > messages are being displayed: > > [...]
17323 82 34_Re: -904 error on DSNDB06.DSNADX0110_Leo Flores23_leoflores@EARTHLINK.NET31_Tue, 14 Dec 1999 22:08:01 -0800572_us-ascii DSNDB06.DSNADX01 is an index (Grantor,Name) to the SYSDBAUTH DB2 Catalog table.
HTH Leo Flores
Hilton Tina wrote:
> Robert, > > Sounds like you have a problem in your catalog (DSNDB06.DSNADX01). Have > your sysprog check it out. It probably needs to be recovered. > > 00C90094 > > Explanation: A data set is in a state that is different from what DB2 > > expects. Possible causes are: > > o A data set was deleted and redefined without DB2's knowledge. > > o A previous DB2 failure involving the data set might have occurred. > > Tina > [...]