1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2000, week 5
2 50 23_Miscellaneous questions24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Sun, 29 Oct 2000 17:03:13 -0800469_us-ascii I have a series of relatively arcane, unrelated questions regarding DB2 Universal Database for Linux, Unix, and Windows. The customer(s) are on Solaris, but the answers should be broadly applicable. Please respond to any and all that strike your fancy.
TIA, Frank
1) What exactly is happening when a database is "activated"? Is there any difference between what happens during a first-connect activation versus an explicit ACTIVATE? [...]
53 34 29_no mail since setting mail on12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Sun, 29 Oct 2000 17:19:57 -0500443_ISO-8859-1 List Manager,
I have not received any messages since I switched my mail back on after a vacation. I did recieve the listserv message indicating that my request to switch mail backon had been successfully processed, but not a single message has come through since then. With the volume on this list that doesn't seem possible. Could you please check and confirm that I have mail back on and that digest is not turned on. [...]
88 41 43_DB2 (OS390) V5.1, DB2 Connect and MS Access12_Marcus Green18_mgreen@AAPT.COM.AU31_Mon, 30 Oct 2000 11:24:11 +1100344_US-ASCII Hi,
Anyone out there played with the above? I have some users who have data in an MS Access database which I want to upload to an OS390 DB2 lookalike table on the mainframe. The process I'm using is driven from MS Access to perform a table Export, and using the ODBC driver from DB2 Connect, export to the OS390 DB2 table. [...]
130 63 21_Re: DSTATS bind error0_31_greg.palgrave@UNISYSWEST.COM.AU31_Mon, 30 Oct 2000 08:18:27 +0800329_us-ascii I have had this when I tried to use a copy of a DBRM for testing and gave it a different name in the PDS - the problem is, the DBRM *must* have the same member name i.e. DBRM for PROGA must be called member PROGA in your PDS dataset. If you have called your DSTATS dbrm a different name, try renaming it to DSTATS. [...]
194 216 27_Re: Miscellaneous questions11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Mon, 30 Oct 2000 16:00:40 +1100410_- Frank,
let's see where my fancy takes me:
1) When a database is activated, DB2 allocates all the resources it needs for that database (e.g. memory, files). No difference between explicit and implicit activation. Of course, with explicit activation, those resources stay allocated even if no users are currently connected to the database (that is exactly the point of explicit activation). [...]
411 126 27_Re: Row Increment Retrieval16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Mon, 30 Oct 2000 12:04:49 +0530580_iso-8859-1 Hi , Block Fetch and Optimize for N rows for retrieving the pre-identified set of number of rows can be called as more costly and complicated method once V7 is there(not full fledged now). I believe the application logic are still to be coded for getting the first 25 and then next 25 if using Block Fetch or OPTIMIZE FOR clause.There are two methods in V7 i.e scrollable cursor or FETCH FOR n ROWS ONLY.I believe retrieving NEXT 25 will not be possible with FETCH FOR n ROWS ONLY(without program logic) ,so scrollable cursor looks the only solution for Michael's [...]
538 19 15_database cache'7_sompong17_sompong@SCB.CO.TH31_Mon, 30 Oct 2000 15:22:33 +0700520_windows-874 Someone asked me about "CAHE' " DBMS like DB2 ,Oracle,Sybase ,but I never heard aboutt it before .Who know about this CACHE' (DBMS) please reply me . Another questions are "what company is its vendor? " and " What kind of work that is suitable for" best regards, AOR
================================================ 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.
558 32 25_DB2/OS390 Remote recovery14_Marilyn Millar31_marilyn.millar@SOMERFIELD.CO.UK31_Mon, 30 Oct 2000 09:50:55 -0000404_iso-8859-1 Dear List,
after several occasions during which we were unable to perform an ARCHIVE LOG(QUIESCE), we have attempted to recovery our test DB2 to a previous point in time.We have faithfully followed the Admin guide's recovery scenario instructions,ie, recover BSDS, determine ENDRBA of previous archlog, found ARCHLOG last to supply ENDRBA+1 to give current active log etc. [...]
591 82 29_Re: DB2/OS390 Remote recovery14_Thomas, Steven21_Steven_Thomas@BMC.COM31_Mon, 30 Oct 2000 04:11:04 -0600493_iso-8859-1 Hi Marilyn,
Just out of interest, if the subsystem isn't very busy, why couldn't you run an archive log mode quiesce?
I suspect that when you restored the BSDS, you forgot to add the archive log that was taken at the time when the BSDS was backed up. The BSDS on the archive tape does not contain information on the archive log that's backed up at the same time. If you system wasn't very busy, then you may have gone back a LONG way to get your last checkpoint. [...]
674 111 29_Re: DB2/OS390 Remote recovery14_Marilyn Millar31_marilyn.millar@SOMERFIELD.CO.UK31_Mon, 30 Oct 2000 10:25:18 -0000376_iso-8859-1 Hi Steve,
thanks for your interest. Yes we did add the latest archive log to the BSDS. We deliberately avoided the quiesce to emulate what happens in production. Our last DR fell over because our existing strategy depends on a successful log(quiesce). Whilst this remains our preferred method, cunning plan B has to be tested to get round the timeout ! [...]
786 39 34_Database Restore on UDB 6.1 for NT0_18_dsi.listsrv@DB.COM31_Mon, 30 Oct 2000 16:20:25 +0530446_us-ascii --------------------------------------------------------------------------------------------------------------------------------- Hi,
I have few problems related to restore of backup on UDB 6.1 on NT. I have taken an offline backup(Entire database backup) to E:\ Now I want to restore the same Database into D: drive using the 'Redirect' option. I have used the following command to restore the backup with option 'redirect' [...]
826 156 29_Re: DB2/OS390 Remote recovery14_Thomas, Steven21_Steven_Thomas@BMC.COM31_Mon, 30 Oct 2000 05:57:58 -0600569_iso-8859-1 Hi Marilyn,
Sorry, as far as I know there is no way to get DB2 to avoid accessing the latest checkpoint as part of it's warmstart apart from avoiding the warmstart altogether and doing a coldstart. If you do that, then the database integrity is your responsibility :-(
Have you printed off the BSDS using DSNJU004 to see when the last checkpoint took place to see if DB2 is looking for the correct one? If there are others later than this, then it may be that you've mistyped the RBA in the conditional restart record. If not, I fear your [...]
983 10 0_10_Sanjeev ..25_SSanjeev@CAL.CTS-CORP.COM29_Mon, 30 Oct 2000 12:00:50 GMT244_-
================================================ 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.
994 102 27_Re: Control Center / DSNWZP19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 30 Oct 2000 06:31:41 -0600608_iso-8859-1 Ron, Alfred, Please note that QMF/Win is case sensitive -- I've been caught on this. Matt, Please see below about x'00' issue -- any ideas?
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other [...]
1097 15 29_Re: DB2/OS390 Remote recovery14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Mon, 30 Oct 2000 13:41:54 +0100374_us-ascii Hi Marylin, sorry but I cannot understand what type of (DR ?) remote recovery you're doing.
If u want to restore DB2
================================================ 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.
1113 74 38_Re: Database Restore on UDB 6.1 for NT0_22_rmadan@CYVEILLANCE.COM31_Mon, 30 Oct 2000 07:47:03 -0500735_iso-8859-1 Two things
1)issue a list tablespace containers from the commnad line.
2) Do a refresh of your control center.
> -----Original Message----- > From: dsi.listsrv@DB.COM [mailto:dsi.listsrv@DB.COM] > Sent: Monday, October 30, 2000 5:50 AM > To: DB2-L@RYCI.COM > Subject: Database Restore on UDB 6.1 for NT > > > -------------------------------------------------------------- > ------------------------------------------------------------------- > Hi, > > I have few problems related to restore of backup on UDB 6.1 > on NT. I have taken an offline backup(Entire database > backup) to E:\ > Now I want to restore the same Database into D: drive using > the 'Redirect' option. I [...]
1188 74 15_Re: AW:DSNTIAUL10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Mon, 30 Oct 2000 06:50:06 -0600612_ISO-8859-1 The copies will be Serial, not Parallel, i.e. SYSREC00 will be unloaded before SYSREC01.
On Fri, 27 Oct 2000 16:17:31 +0200, Klaus Treibl wrote:
> Hi Cunyet, > > Sorry, I was wrong ... did'nt really think about it !! > > You get up to hundred copies of the same table, if you code n-times >in the SYSIN and provide SYSREC00 to SYSREC99 DD-Statements for the output. > Unfortunately you will have as much Load-Statements for that table >in the SYSPUNCH since it can only be specified once ... > > best regards, > > Klaus T. > [...]
1263 55 29_Re: DB2/OS390 Remote recovery14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Mon, 30 Oct 2000 13:53:03 +0100300_us-ascii Hi Marilyn. Just a question..
Are u doing an off-site Disaster Recovery starting from last log archive ( I did this some days ago for a data sharing group and as you we cannot do ARCHIVE LOG(QUIESCE)) or something else ? I'm afraid you need a CRC restart (and a log truncation). [...]
1319 15 29_Re: DB2/OS390 Remote recovery14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Mon, 30 Oct 2000 14:00:55 +0100332_us-ascii Sorry for my mistake, the good mail is the second......
Regards Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1335 21 29_Re: DB2/OS390 Remote recovery13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM31_Mon, 30 Oct 2000 07:24:08 -0600454_us-ascii Marilyn -
The situation you are going thru is near and dear to my heart as I am positive we will be doing something very similar very soon. Did you try using the alter log (DSNJ003) to remove the missing archived log dataset from the bootstrap. I have not done this yet, but supposedly you can delete the missing archive log from the bootstrap, restart your system to the gap point, create a restart record and restart past the gap. [...]
1357 90 27_AW: Control Center / DSNWZP16_Alfred Abplanalp32_Alfred.Abplanalp@GS-VBS.ADMIN.CH31_Mon, 30 Oct 2000 14:26:50 +0100553_iso-8859-1 No, i haven't.
I tried via Visual Explain and id did not return a Result. I have Cobol samples for other Stored Procedures wich return results on OS/390 but not when called via ODBC. Can you send me your sample in COBOL or REXX?
Thank you very much ______________________________________________________________________ Alfred Abplanalp Direktion Informatik VBS Papiermühlestr. 20 CH-3003 Bern Tel +41 31/324 67 77 Fax +41 31/324 67 21 Email alfred.abplanalp@gs-vbs.admin.ch X400 G=alfred;S=abplanalp;O=gs-vbs;A=admin;C=ch [...]
1448 115 27_Re: Miscellaneous questions13_Lynne Flatley17_LFlatley@NEFN.COM31_Mon, 30 Oct 2000 09:10:59 -0500614_iso-8859-1 Question #5 is a favorite of mine...
1. ensure that the instance-level monitor switches are on (at least STATEMENT and UOW) 2. create the explain tables contained in sqllib\misc\explain.ddl 3. after the switches have been turned on and some dynamic SQL has been executed, attach to the instance and enter this snapshot command, GET SNAPSHOT FOR DYNAMIC SQL ON WRITE TO FILE 4. populate the ADVISE_WORKLOAD table (contained in explain.ddl) with the data obtained from step #3. ADVISE_WORKLOAD is really used by the Index Advisor so you're killing 2 birds with one stone here. [...]
1564 24 32_Help with preparing SQLJ program13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 30 Oct 2000 08:51:55 -0600574_- Platform : Win95, DB2 Connect EE on NT, DB2/390 v5
I'm having problems with bldsqlj script. First it starts with "File not found" message though I was able to compile and run a program inspite of the message. On the second program it strats with the "File not found" message but hangs after compiling. It does create new classes but doesn't go any further. Running the class file results in a message "Can't find class Query or something it requires". These are the only differences between the two programs : * the first has only a singleton select while the [...]
1589 58 25_PeopleSoft OS390 Printing13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 30 Oct 2000 09:04:29 -0600425_iso-8859-1 Hi,
This is related to PeopleSoft OS390 printing, not DB2. I did cross-post this on two lists (PeopleSoft & DB2-L) because I know there seems to be a good mix of PeopleSoft users on the DB2-L list. Anyway ...
I have 2 questions regarding printing:
1. We want to be able to get our mainframe executed SQRs to print to a LAN printer and use the fonts available on the LAN printers. [...]
1648 23 22_Control center - SQLID15_Pierre Dagenais19_pdagenai@UOTTAWA.CA31_Mon, 30 Oct 2000 10:33:07 -0500421_us-ascii Hi
How do we change our sqlid from within the UDB control center accessing db2\os390 v6.
Any help will be appreciated.
Thanks
Pierre Dagenais,
================================================ 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.
1672 39 36_Reducing Memory Usage on Sun Solaris19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Mon, 30 Oct 2000 09:47:22 -0600295_us-ascii I'm used to using DB2 on AIX, but recently have been working with a Sun Solaris server.
When I run ps -Al, I see 25 db2sysc processes running with between 4000 and 18000 pages of virtual memory each (Sun has 8k pages). The total virtual memory allocated is over 1.5 Gbytes. [...]
1712 43 26_Re: Control center - SQLID13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 30 Oct 2000 09:55:43 -0600522_iso-8859-1 Hi, Have a look at the client configuration assistant. For the alias/Database .... Select Properties-->ODBC/CLI settings(No need to logon)-->Advanced. Enterprise tab, CURRENTSQLID.
That may have a setting. HTH gm
-----Original Message----- From: Pierre Dagenais [mailto:pdagenai@UOTTAWA.CA] Sent: Monday, October 30, 2000 9:33 AM To: DB2-L@RYCI.COM Subject: Control center - SQLID
Hi
How do we change our sqlid from within the UDB control center accessing db2\os390 v6. [...]
1756 74 70_Repost: IDUG 2000 Technical Symposium - Toronto, Canada, 6-7 Nove mber13_Morrill, John12_JohnM@VP.NET31_Mon, 30 Oct 2000 09:07:02 -0700530_- Dear DB2 Interested Parties,
Below is a bulletin about the upcoming 4th annual IDUG 2000 Technical Symposium, November 6-7 in Toronto.
The IDUG Technical Symposium is a departure from the classical IDUG conference. It offers two days of in-depth seminars by leading DB2 experts and IBM DB2 developers. In addition, IBM Fellow and Director of Database Integration, Dr. Patricia Selinger, will deliver a keynote presentation providing insights to the latest developments in DB2 technology across all platforms. [...]
1831 202 55_Repost: UPDATE: DB2 Skills News, Programs and Resources13_Morrill, John12_JohnM@VP.NET31_Mon, 30 Oct 2000 09:14:42 -0700595_- Note:
This post was edited to fit within the size limit for DB2-L posts.
---------------------------------------------
Dear DB2 Interested Parties,
Below are the following recent items relating to DB2 skills. An updated DB2 skills resource list is also included:
o "IBM Lures DBAs to "Bluer" Pastures" - Press release regarding IBM's "DB2 Skills Plus" program, which accelerates the delivery of DB2 training, hiring and services by linking DB2 skills with industry requirements. More information at http://www.ibm.com/software/data/db2/skills/prog.html [...]
2034 94 87_Repost: NEW BOOK: "An Introduction to DB2 for OS/390 Version 7" b y Sloan and Hernandez13_Morrill, John12_JohnM@VP.NET31_Mon, 30 Oct 2000 09:53:06 -0700417_- Dear DB2 Interested Parties,
"DB2 Universal Database for OS/390: An Introduction to DB2 for OS/390 Version 7" is a new book that will be of interest to all DB2 for OS/390 users, and is specially designed for new users. The book is written by Susan Graziano Sloan and Ann Kilty Hernandez of IBM's User Technology team at the IBM Silicon Valley Laboratory. See the bulletin below for a brief description. [...]
2129 43 29_Re: DB2/OS390 Remote recovery12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 30 Oct 2000 11:21:00 -0500304_- What phase of startup are you in when you have the problem? Have you deleted and reinserted the active logs in the BSDS? Have you tried "FORWARD and BACKOUT = NO" on your Conditional Restart?
Without knowing exactly what you are doing, it is difficult to give (for what it's worth) advice. [...]
2173 100 15_Re: AW:DSNTIAUL12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Mon, 30 Oct 2000 19:33:57 +0200509_iso-8859-1 Hi, If you want it in parallel, you need 2 jobs running in parallel (pay attention to the names of the files for SYSREC00 and SYSPUNCH in that case).
Isaac Yassin DBMS & IT Consultant
Email: yassin@netvision.net.il
Tel : +972 9 9505172 Cell: +972 54 452793 Fax : +972 9 9560803 ----- Original Message ----- From: "John Hardy" Newsgroups: bit.listserv.db2-l To: Sent: Monday, October 30, 2000 2:50 PM Subject: Re: AW:DSNTIAUL [...]
2274 149 47_Re: DB2 (OS390) V5.1, DB2 Connect and MS Access16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Mon, 30 Oct 2000 13:31:19 -0500485_iso-8859-1 IBM has a free software tool available on their website which converts MS Access to DB2 OS/390 and establishes the connectivity needed. I converted over 375 users from Access to DB2 OS/390 without any problems or any visible difference to the end-user. Why duplicate the data?
-----Original Message----- From: Marcus Green [mailto:mgreen@AAPT.COM.AU] Sent: Sunday, October 29, 2000 6:24 PM To: DB2-L@RYCI.COM Subject: DB2 (OS390) V5.1, DB2 Connect and MS Access [...]
2424 31 15_Re: AW:DSNTIAUL10_Rob Wright17_rwright@LIC.CO.NZ31_Tue, 31 Oct 2000 08:08:22 +1200518_us-ascii Why not run it once using DSNTIAUL, then use IEBGENER (or ICEGENER) to get the extra copy? You could also use DFDSS COPY, FDR COPY,.... ask your DASD manager or systems programmer.
Here's some IEBGENER JCL that you could use after the DSNTIAUL STEP:
// IF DSNTIAUL.RC=0 THEN // EXEC PGM=IEBGENER //SYSUT1 DD DISP=SHR,DSN=*.DSNTIAUL.SYSREC00 //SYSUT2 DD DISP=(NEW,CATLG),DSN=DSNTIAUL.COPYDSN, // DCB=*.DSNTIAUL.SYSREC00, // SPACE=(CYL,(X,Y)) //SYSPRINT DD SYSOUT=* //SYSIN DD DUMMY // ENDIF [...]
2456 127 27_Re: Control Center / DSNWZP11_Matt Kelley18_mgk333@HOTMAIL.COM31_Mon, 30 Oct 2000 12:57:50 -0600688_ISO-8859-1 The problem in QMF for Windows where data that contains null bytes (x'00') is truncated was fixed starting with CSD 6.1.1j and is also handled correctly in version 7. The latest maintenance is available from http://www.rocketsoftware.com/qmf.
Columns that contain mixed binary and character data is problematic in a distributed environment. If you define the column for character data, the entire contents undergo code page conversion, which corrupts the binary portions. If you define it for bit data, nothing gets converted, which effectively corrupts the character portions. We've seen this situation frequently with CICS commarea dumps being stored in DB2, but [...]
2584 30 39_DB2 V6 for OS/390 - Alter Partition Key9_Wu, James13_jwu@KRAFT.COM31_Mon, 30 Oct 2000 13:28:34 -0600471_- I altered a partitioned key values, DB2 put a 'REORGP' status against the corresponding tablespace partitions, say partition 1 and 2. When I tried to reorg partition 1, I got a message
'DSNU271I -DB2DSN1 DSNURFIT - REORG PENDING ON TABLE SPACE dbname.tsname PART 2 PROHIBITS PROCESSING'.
When I tried to reorg partition 2, I got a similar message complaining partition 1. Eventually I had to reorg the whole tablespace to remove the 'REORGP' status. [...]
2615 72 47_Re: DB2 (OS390) V5.1, DB2 Connect and MS Access11_Wang, Jason29_jason.wang@CHECKSOLUTIONS.COM31_Mon, 30 Oct 2000 13:33:27 -0600640_iso-8859-1 Hi Gerald,
What's name of the free software and do you happen to have the URL for it ? Thanks
-----Original Message----- From: Brookman, Gerald [mailto:gerald.brookman@US.ORIGIN-IT.COM] Sent: Monday, October 30, 2000 12:31 PM To: DB2-L@RYCI.COM Subject: Re: DB2 (OS390) V5.1, DB2 Connect and MS Access
IBM has a free software tool available on their website which converts MS Access to DB2 OS/390 and establishes the connectivity needed. I converted over 375 users from Access to DB2 OS/390 without any problems or any visible difference to the end-user. Why duplicate the data? [...]
2688 137 43_Re: DB2 V6 for OS/390 - Alter Partition Key14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 30 Oct 2000 11:41:44 -0800395_iso-8859-1 REORG PART 1:2 Which was added in DB2 V6 in support of ALTER INDEX PARTITION. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.
-----Original Message----- From: Wu, James [mailto:jwu@KRAFT.COM] Sent: Monday, October 30, 2000 1:29 PM To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 V6 for OS/390 - Alter Partition Key [...]
2826 204 40_Re: Reducing Memory Usage on Sun Solaris14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 30 Oct 2000 11:47:44 -0800597_iso-8859-1 Phil, One thing to look at is the INTRA_PARALLEL database manager config parm. If it is set to YES, then the SHEAPTHRES value is allocated out of a shared memory segment for each database allocated (required for SHARED SORTS). However, for PRIVATE sorts (only type available if INTRA_PARALLEL is NO) SORTHEAP pages is allocated from the private heap until SHEAPTHRES is reached (for all sorts in instance) then memory is allocated in smaller chunks. I'm not sure where BLOB data gets read into, but there must be some area in the DBHEAP used, since LOBS bypass the buffer pools. A [...]
3031 82 47_FW: DB2 (OS390) V5.1, DB2 Connect and MS Access16_Brookman, Gerald32_gerald.brookman@US.ORIGIN-IT.COM31_Mon, 30 Oct 2000 14:56:57 -0500428_iso-8859-1
Scriptoria - http://www-4.ibm.com/software/data/db2/udb/scriptoria.html
-----Original Message----- From: Wang, Jason [mailto:jason.wang@CHECKSOLUTIONS.COM] Sent: Monday, October 30, 2000 1:33 PM To: DB2-L@RYCI.COM Subject: Re: DB2 (OS390) V5.1, DB2 Connect and MS Access
Hi Gerald,
What's name of the free software and do you happen to have the URL for it ? Thanks
3114 19 29_Re: DB2/OS390 Remote recovery10_Lee Mandel16_DBMSUser@AOL.COM29_Mon, 30 Oct 2000 15:06:25 EST539_US-ASCII Hi Marilyn, It appears that the list members gave you some good information. If you wish to have some sample ISPF panels on automating the recovery process look at www.recoveryknowledge.bigstep.com and select REQUEST FREE INFO than on Pick a Subject select Request Sample ISPF Panels. Lee
================================================ 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.
3134 24 18_buffer pool tuning27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Mon, 30 Oct 2000 15:08:33 -0500424_- At my previous job, I'd downloaded some rexx code that parsed the output from a -display bufferpool and extracted data to monitor buffer pool statistics. I thought I'd gotten it from DB2-L, but if I did it must have been before it switched listserv hosts because I couldn't find any mention of it in the archives. If anyone remembers this and can send me a copy or tell me where I can find it, I would appreciate it. [...]
3159 41 34_Index use for unequal char fields.0_24_Ray.Price@DRESDNERKB.COM31_Mon, 30 Oct 2000 20:11:19 -0000388_iso-8859-1 Hello world.
We've just put DB2 OS/390 V5 into production, with the "refresh" PTF's. PQ22046 claims to allow index scan using varchar or fixed char that have different lengths. I've tried a REBIND on a package that has a wrong length host variable, expecting it to use the index, but it doesn't. Has anyone got this feature to work? Am I missing something obvious? [...]
3201 48 22_Re: buffer pool tuning17_Anand Thippeswamy19_Thippesa@MEIJER.COM31_Mon, 30 Oct 2000 15:28:39 -0500170_US-ASCII Hello Tina, Check out http://www.xephon.com/archives/b050a02.txt If this isn't the one you are looking for, check other articles.
Regards Anand Meijer Inc
3250 22 22_utilities-CDB Software11_Pat Daniels20_patd0327@HOTMAIL.COM29_Mon, 30 Oct 2000 14:25:31 CST482_- At the Tech Conference last week I was very impressed with CDB Software, especially their online reorg with no downtime. I would like to hear about any experiences with this company or any of their products. Thanks, Pat
_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at http://profiles.msn.com. [...]
3273 20 53_How can youtell if an index is approaching 100% full?12_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US31_Mon, 30 Oct 2000 15:37:42 -0500446_us-ascii Hi, listers!
We're a DB2 for OS/390 shop. Our tablespaces and indexspaces are created with SECQTY=0. We monitor tablespace growth and ALTER PRIQTY/REORG/RUNSTATS tablespaces that are getting full.
Is there a way to monitor indexspaces in the same manner? We already keep an eye on cluster ratio and nearoff/faroff stats, but haven't figured out a way to tell if an indexspace is approaching it's PRIQTY. Any thoughts? [...]
3294 50 26_Re: utilities-CDB Software11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM31_Mon, 30 Oct 2000 14:47:55 -0600373_us-ascii We have CDB Reorg and we absolutely love it. With the help of some parameters, it automatically decides when to reorg and when not to. The no downtime is the absolute truth. Restarts are simple and there is no destruction if the utility fails.
Trace
Pat Daniels @RYCI.COM> on 10/30/2000 02:25:31 PM [...]
3345 49 26_Re: utilities-CDB Software15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 30 Oct 2000 14:48:54 -0600286_iso-8859-1 We use CDB utilities and have found the utilities to be very reliable and the tech support to be intelligent and responsive. If you want more details please email me offline and I can get you in touch with the guy who has worked with these utilities the most over here. [...]
3395 28 22_Re: buffer pool tuning27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Mon, 30 Oct 2000 15:57:01 -0500454_- I do believe that's it. Thanks Anand. I'd forgotten about the Xephon subscription I had there.
> -----Original Message----- > From: Anand Thippeswamy [SMTP:Thippesa@MEIJER.COM] > Sent: October 30, 2000 3:29 PM > To: DB2-L@RYCI.COM > Subject: Re: buffer pool tuning > > Hello Tina, > Check out > > If this isn't the one you are looking for, check other articles. > > Regards > Anand > Meijer Inc [...]
3424 42 57_Re: How can youtell if an index is approaching 100% full?12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Mon, 30 Oct 2000 16:09:05 -0500613_us-ascii Bob, I believe you will have to query the ICF catalog for the underlying vsam dataset using HI used RBA / HI allocated RBA to give a percent used. I do not know offhand if there are any Stats in SYSIBM.SYSINDEXPARTs HTH Bob Lawrence DBA Boscov's Dept Stores Inc
On Monday, October 30, 2000 3:38 PM, Bob LaCerais [SMTP:Bob_LaCerais@TAX.STATE.NY.US] wrote: > Hi, listers! > > We're a DB2 for OS/390 shop. Our tablespaces and indexspaces are created > with SECQTY=0. We monitor tablespace growth and ALTER > PRIQTY/REORG/RUNSTATS tablespaces that are getting full. > > Is there a way to [...]
3467 159 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Mon, 30 Oct 2000 22:19:54 +0100794_us-ascii Hi all, a customer of us need to access data on DB2/VM v5.1 from MS-Access; according to Microsoft, we need to use MS SNA-Server: is this true or we can do the same via DB2 Connect?
As somebody experienced this?
Any suggestion will be very appreciated.
TIA Alessandro
>Scriptoria - >http://www-4.ibm.com/software/data/db2/udb/scriptoria.html > >-----Original Message----- >From: Wang, Jason >[mailto:jason.wang@CHECKSOLUTIONS.COM] >Sent: Monday, October 30, 2000 1:33 PM >To: DB2-L@RYCI.COM >Subject: Re: DB2 (OS390) V5.1, DB2 Connect and MS Access > > >Hi Gerald, > >What's name of the free software and do you happen to have the URL for it ? >Thanks
3627 56 52_Why do you have to have an PLAN_TABLE when using QMF0_23_edie.richardson@SRS.GOV31_Mon, 30 Oct 2000 16:44:47 -0500366_us-ascii When I have a user trying to use QMF and they do not have a PLAN_TABLE they get an error stating so.
DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE X4200.PLAN_TAB LE DOES NOT EXIST
For some users it just gives the messages and then continues to return the results back from the query, other it doesn't return the results. [...]
3684 44 52_How do you handle change requests to your DBA staff?13_Todd Peterson23_toddpeterson2@YAHOO.COM31_Mon, 30 Oct 2000 13:38:31 -0800426_us-ascii Our DBA staff currently accepts change requests from our applications programmers via email. As the volume of requests has increased so has the frequency of errors (accidently deleted messages, mail sent to an individual instead of the group where the individual is on vacation or has left the company, etc.). I'd like to find out what others are doing -- if anything -- to formalize the change request process. [...]
3729 159 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access13_Jeff Jennings25_Jeff_Jennings@FSAFOOD.COM31_Mon, 30 Oct 2000 13:49:36 -0800412_us-ascii We are accessing DB2/VM V6.1 from MS-Access. We are using DB2 Connect to accomplish this over TCP/IP. By using TCP/IP for communications (we have enabled TCP/IP for VM), we are able to bypass our MS-SNA servers.
Alessandro Brezzi on 10/30/2000 01:19:54 PM
Please respond to DB2 Data Base Discussion List [...]
3889 83 56_Re: How do you handle change requests to your DBA staff?0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 30 Oct 2000 16:00:59 -0600585_us-ascii We created a simple Lotus Notes DB/workflow application with some predefined request forms. Developers pick the form, then fill in the blanks to provide us with the (minimum) required info in a standard format. When they save the request, Notes automatically sends an email to a designated DBA who reviews the request then assigns it to a DBA to handle. DBA can edit the request and put comments and working notes into the request. When the request is complete, the DBA hits a button, enters amount of time used to fill request, and Notes sends an email to the developer [...]
3973 68 56_Re: How do you handle change requests to your DBA staff?24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Mon, 30 Oct 2000 14:02:02 -0800324_- 1. We accept e-mail sent to a distribution list, and we ask that verbal requests be confirmed via e-mail.
2. No packages are used, although we keep a manual log of changes.
3. We send a reply to the e-mail to the original requestor and to any additional names on the original request (except managers). [...]
4042 87 56_Re: How do you handle change requests to your DBA staff?0_20_John_Lendman@FPL.COM31_Mon, 30 Oct 2000 17:04:35 -0500504_us-ascii We are in the process of moving to REMEDY a product for change management. Once we complete the ticket it will send an email back to the person who created it. We are not there yet, but it looks like this is what we will use. We will ask for our customers to fill out a ticket for each request that falls in to the normal support role, and if they do not know how to fill out the ticket, or they do not have the software, then we will create the ticket for them. The only exception that we [...]
4130 62 56_Re: Why do you have to have an PLAN_TABLE when using QMF15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 30 Oct 2000 16:05:16 -0600517_iso-8859-1 Hi, Edie,
I am afraid that I don't know much about installing QMF but a plan table is used in DB2 when a plan or package is bound with EXPLAIN(YES). The access path that DB2 is going to use to access the data is inserted into the plan table at this time. I do know that QMF executes dynamic SQL which means that a sort of "bind on the fly" is issued when the SQL is executed. If something in the QMF installation says to do an explain everytime an SQL is "bound on the fly" then you would need [...]
4193 73 57_Re: How can youtell if an index is approaching 100% full?0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 30 Oct 2000 16:07:31 -0600344_us-ascii Just out of curiosity, why would allocate TS/IS with SECQTY=0?
I thought the idea of a secondary allocation is to allow you flexibility to go into extents without abend. From previous discussion on list I gathered that having a TS/IS with a few extents, ie less than 10-20, causes no significant overhead during TS/IS use. [...]
4267 63 38_Re: Index use for unequal char fields.13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Mon, 30 Oct 2000 16:09:38 -0600595_US-ASCII Ray, If you are trying to retrieve data "index only access" from a variable length column make sure you have ZPARM RETVLCFK=YES enabled. (PQ10465) Kurt
>>> Ray.Price@DRESDNERKB.COM 10/30/00 02:11PM >>> Hello world.
We've just put DB2 OS/390 V5 into production, with the "refresh" PTF's. PQ22046 claims to allow index scan using varchar or fixed char that have different lengths. I've tried a REBIND on a package that has a wrong length host variable, expecting it to use the index, but it doesn't. Has anyone got this feature to work? Am I missing something obvious? [...]
4331 69 59_How do you handle change requests to your DBA staff? -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM31_Mon, 30 Oct 2000 17:09:23 -0500595_US-ASCII Hi Todd, We have a series of change request forms which are available to programmers on the LAN. Each form is specific to the type of change requested like table, index, foreign key add / revise etc. The form, when properly completed, contains all pertinent info relative to the action being requested and serves as documentation for all the DBAs in the future. The completed form is forwarded either by E-mail or hardcopy to the Manager of Database Services or his designee for assignment to the next available or most appropriate DBA. Once the request is fulfilled, an E-mail is [...]
4401 28 56_Re: Why do you have to have an PLAN_TABLE when using QMF11_Matt Kelley18_mgk333@HOTMAIL.COM31_Mon, 30 Oct 2000 16:16:23 -0600470_- With only the base QMF product installed, users should NOT need a PLAN_TABLE in order to run queries.
However, the optional QMF High Performance Option includes a Query Analyzer feature (as part of the HPO/Manager component) that automatically traps the queries submitted by users before they get to DB2, and performs analysis on them, including running an EXPLAIN. A customizable exit can display the analysis results to the user and/or cancel the query. [...]
4430 16 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access13_Jeff Jennings25_Jeff_Jennings@FSAFOOD.COM31_Mon, 30 Oct 2000 14:44:48 -0800462_us-ascii Hi List, Second try at replying.
We are accessing DB2/VM V6.1 from MS-Access here. We are using DB2 Connect over TCP/IP to do this. We have enabled TCP/IP fro VM and are able to bypass our MS-SNA Servers.
================================================ 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.
4447 33 56_Re: Why do you have to have an PLAN_TABLE when using QMF12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Mon, 30 Oct 2000 17:02:00 -0500330_- You probably have explain = y on the QMF packages....collid = Q.
>>> DB2-L@RYCI.COM@inter2 10/30/00 02:49PM >>> When I have a user trying to use QMF and they do not have a PLAN_TABLE they get an error stating so.
DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE X4200.PLAN_TAB LE DOES NOT EXIST [...]
4481 159 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access0_15_leon@CA.IBM.COM31_Mon, 30 Oct 2000 18:30:33 -0500592_us-ascii
You can use DB2 Connect.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
Alessandro Brezzi on 10/30/2000 04:19:54 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access
Hi all, a customer of us need to access data on DB2/VM v5.1 from MS-Access; according to Microsoft, we need to use MS SNA-Server: is this true or we can do the same via DB2 Connect? [...]
4641 41 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Tue, 31 Oct 2000 01:08:12 +0100622_us-ascii Hi Jeff, thank for your suggestion; for our custoner is impossible to use TCP/IP for access DB2/VM v5.1, SNA is the only choice.
Thanks Alessandro
>Hi List, Second try at replying. > >We are accessing DB2/VM V6.1 from MS-Access here. We are using DB2 >Connect over >TCP/IP to do this. We have enabled TCP/IP fro VM and are able to bypass our >MS-SNA Servers. > >================================================ >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.
4683 39 57_Re: How can youtell if an index is approaching 100% full?11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Oct 2000 16:16:05 -0800282_iso-8859-1 I run a batch job that looks at the ICF cat for space problems. I also have a job that looks at all of stogroups and volumes to report stogroups with total volume capacity less than 5% free space. My work is public domain I'll give them to you if you want. cliff:-) [...]
4723 30 28_Re: LRSN to timestamp format11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 30 Oct 2000 22:26:18 -0500460_ISO-8859-1 I have posted an Excel worksheet to convert an LRSN to a timestamp to the documents archive. The time part is only approximate.
Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner
Message text written by DB2 Data Base Discussion List >Hi
Has anyone a formula or a little program to get the timestamp format = out of the Log Record Sequence Number.=20 [...]
4754 120 27_Re: Miscellaneous Questions11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 31 Oct 2000 00:22:45 -0500470_us-ascii Hi Frank,
#1) Activate was created so that nobody would have to be the first connection. They're the same essentially. A few processes get started, and the logs get formatted/allocated.
#2) Clever idea, but wouldn't a START ACCESS(MAINT) command be nice? Another trick would be to disable TCPIP services so no remote clients can get in. And yet another trick, revoke all the connect privileges... easy to do if granted via groups or scripts. [...]
4875 97 38_Re: Index use for unequal char fields.14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM31_Tue, 31 Oct 2000 17:15:47 +1100598_- Ray,
APAR PQ22046 does not apply to local predicates with a mismatching length, but only to join columns (of type CHAR or VARCHAR).
The only unequal length character local predicate that can utilise a matching index scan is when a literal value is shorter than the column: ie. CHAR5 = 'ABC'. DB2 will pad the remaining spaces and utilise an index match. If the literal character value is longer than the column, ie. CHAR5 = 'ABCDEF'; DB2 cannot utilise an index match. When the predicate length is forced, ie. CHAR5 = :ws-char4 or CHAR5 = substr('xxxx',1,4), and the length is [...]
4973 56 18_Re: DB2 on Solaris14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Tue, 31 Oct 2000 14:19:44 +0800583_- Thomas,
We use UDB v6.1 on Solaris, due to go into production next February. Personally I prefer UDB over Oracle.
Duncan
> ---------- > From: Thomas Karlsson[SMTP:thkar97@HOTMAIL.COM] > Reply To: DB2 Data Base Discussion List > Sent: 26 October 2000 08:05 > To: DB2-L@RYCI.COM > Subject: DB2 on Solaris > > Hi! > --------- > Is there anybody out there using UDB on the Solaris OS. > Is there any litterature or white paper which says anything > about comparison with oracle on Solaris. > > We have a project who uses Solaris with Oracle but want to > use [...]
5030 23 7_Queries25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Tue, 31 Oct 2000 14:21:28 +0800381_us-ascii Hi,
One of users has uploaded data into the DB2 tables with lower case. Is it possible to convert this to upper case while retriving. If this column was indexed, how this problem be addressed.
To avoid this problem in future, is there a way to check the file using an automation or auto convert the data to caps using a easytrieve or sas or cobol or ?. [...]
5054 120 40_Re: Reducing Memory Usage on Sun Solaris11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 31 Oct 2000 01:31:05 -0500655_us-ascii Hi Phil,
Answers within your original message....
Cheers, Scott
>>I gather that Solaris allocates memory differently from AIX and in particular that I should >>watch the SHEAPTHRES parameter (set to the default of 20000 pages).
Several parameters warrant careful consideration, but the key is actually how and when memory is freed up or "disclaimed". It seems only AIX does a proper job of disclaiming memory when DB2 wishes to abandon it. The problem is particularly severe for DB2 Sun shops that: 1) Have INTRA_PARALLEL = NO (private memory is used for sorting) 2) Make extensive use of sortheap memory (Number [...]
5175 58 11_Re: Queries16_S, Sanjeev (CTS)25_SSanjeev@CAL.CTS-CORP.COM31_Tue, 31 Oct 2000 01:50:35 -0500458_- Hi Venkatesh, It depends on the version of DB2 you are in.If you are with DB2 UDB V6 for OS/390 then it is possible to use functions like UCASE or UPPER.For automating it you have to run the utility in the whole file which depends on the size of the file. I think( but not sure) it is possible to use the ISPF edit commands from JCL after editing the file.This can be a good idea by which UC on the command line will convert everything in upper case. [...]
5234 97 11_Re: Queries25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Tue, 31 Oct 2000 14:58:32 +0800674_us-ascii Hi,
We are on os390 1.3 and db2 v5.1.
Regards
(Embedded image moved DB2 Data Base Discussion List to file: (Tel: ) pic02625.pcx) 31/10/2000 02:50 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: bcc: Subject: Re: Queries
Hi Venkatesh, It depends on the version of DB2 you are in.If you are with DB2 UDB V6 for OS/390 then it is possible to use functions like UCASE or UPPER.For automating it you have to run the utility in the whole file which depends on the size of the file. I think( but not sure) it [...]
5332 45 18_Re: DB2 on Solaris11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 31 Oct 2000 02:12:48 -0500375_us-ascii Yes, DB2 on Solaris seems to be gaining in popularity quite rapidly, about 1/3 of our customers are running DB2/Sun. Some very impressive applications and large databases have been built upon it.
Performance comparisons with Oracle will be tough to find; Oracle's license terms prohibit disclosure of numbers that prudent folks would otherwise consider. [...]
5378 19 51_Re: FW: DB2 (OS390) V5.1, DB2 Connect and MS Access14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Tue, 31 Oct 2000 08:58:34 +0100455_us-ascii It's not true. We connected to DB2 on S390 via MS-ACCESS using IBM ODBC driver and DDF. Be sure to pick up the latest version of CAE.
HTH
Max Scarpa Non-certified nor expert/specialist......
================================================ 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.
5398 53 56_Re: How do you handle change requests to your DBA staff?14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 31 Oct 2000 09:22:49 -0000649_iso-8859-1 In our OS/390 system, we run multiple "instances" of the same database. (Same table and package names, just different creators and collections.)
We have a home-grown ISPF/DB2 application where developers put in their change requests, and the dates they want them implemented in each environment.
We DBAs then create a "model" change in BMC Change Manager, and attach it to the change request. Each time we implement the change in an environment, we action it from the panel, sit back and wait. When it has been actioned, it updates the status to "complete." We're considering implementing SMTP email notification, too. [...]
5452 46 38_Re: Database Restore on UDB 6.1 for NT11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 31 Oct 2000 11:39:59 -0800500_us-ascii Hi Siva,
I am not sure of what you mean with
> DB2 SET TABLESPACE CONTAINERS FOR 7 USING ( FILE > 'D:\' 5000, FILE 'D:\' > 10000,......(totally 7 containers))
did you issue the "SET TABLESPACE" command 7 times (each with different tablespace-id) or only once (using 7 containers) ?
How did you get the number 7 for the "FOR " clause? (It is a little suprising me that the tablespace #7 had exactly 7 containers ... ) [...]
5499 53 57_Re: How can youtell if an index is approaching 100% full?41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Tue, 31 Oct 2000 08:55:04 -0200575_iso-8859-1 DB2 Installation Guide (chapter 2 - estimating storage needs) shows a formula for calculating index size. That formula uses CARD as one of the variables, so that you can use it with the current CARD and compare the size suggested by the formula (PRIQTY) with the one you have in catalog. I have never done that, but I think it would work fine. I would suggest you to allow some secondary extents in order not to be so concerned about indexes getting full. The number of secondary extents is a good indicator for index increase in size. Secondary extents here [...]
5553 49 56_Re: How do you handle change requests to your DBA staff?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 31 Oct 2000 07:14:35 -0500619_iso-8859-1 I see several good ideas and methods of tracking change, but I don't see any discussion of the most difficult aspect I used to find in managing changes to DB2 objects for large projects.
That is impact analysis and negotiation of implementation schedules.
In most of the development projects I supported, we had multiple project teams and many developers and analysts. Impact analysis as far as the programs and applications affected by changes to an object can be automated fairly well. (This has been discussed here previously and I have proudly touted the Compuware products solution.) [...]
5603 129 25_R: Oracle vs DB2 question18_MARCOTULLI ARMANDO25_AMarcotulli@GRUPPOSIAC.IT31_Tue, 31 Oct 2000 13:13:32 +0100649_iso-8859-1 I completely agree with Peter and Rob. We moved some mission critical applications from DB2 OS/390 to ORACLE/SUN 3 years ago and we are still fighting with it. Waste of time, waste of money. It isn't true that the mid-range environment is less expensive than Mainframe. Absolutely false.
Armando
> -----Messaggio originale----- > Da: Peter Van Eeuwen [mailto:pvaneeuwen@ALTAVISTA.COM] > Inviato: venerdì 27 ottobre 2000 17.11 > A: DB2-L@RYCI.COM > Oggetto: Re: Oracle vs DB2 question > > > My experience has not been migrating from DB2 to Oracle; but > having worked on both platforms, DB2 OS/390 and Oracle on [...]
5733 125 57_Re: How can youtell if an index is approaching 100% full?12_Bob LaCerais28_Bob_LaCerais@TAX.STATE.NY.US31_Tue, 31 Oct 2000 08:16:25 -0500538_us-ascii We basically use SECQTY=0 to allow us a greater control of disk space utilization (which, despite it's relatively low cost, remains a scarce resource here). With SECQTY=0 on all of out TS/IS we don't have to allow for potential growth of those objects when allocating them, and can therefore physically fill a disk without having to worry about an out-of-space condition on the pack when an object attempts to get an extent. Essentially, we don't have to leave 'free space' on our packs to accommodate unanticipated growth. [...]
5859 25 39_DB2 SPs and updating non-DB2 resources.0_25_George_White@VANGUARD.COM31_Tue, 31 Oct 2000 08:24:17 -0500317_us-ascii Hi everyone,
I am exploring the possibility of using WLM managed DB2 stored procedures to control the unit of work from mid-tier (NAS) applications. The data sources are mixed ; primarily DB2, but also VSAM and MQSeries. We are using DB2 V6, so we would use the commit and rollback from the SPs. [...]
5885 53 43_Re: DB2 SPs and updating non-DB2 resources.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 08:35:55 -0500445_iso-8859-1 We are doing similar without the MQ and VSAM. We will be doing non-DB2 functions in SP in the near future. So far our SP experience has been quite positive. We intend to exploit SP extensively over the next year or so.
Be cautious about the 'COMMIT ON RETURN' feature. It does a commit for DB2 resources only. You will need to coordinate the commit for non-DB2 resources in your code (perhaps just before leaving the SP?) [...]
5939 78 18_Re: DB2 on Solaris14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 31 Oct 2000 08:53:03 -0500474_us-ascii Thomas, Solaris uses lighweight threads which do not require a context switch versus traditional processes which do. Therefore increased throughput and performance can be gained. DB2 takes advantage of this on Solaris. HTH Phil
Phil Gunning DB2 DBA
Scott Hayes cc: Sent by: DB2 Data Base Subject: Re: DB2 on Solaris Discussion List [...]
6018 43 56_Re: Why do you have to have an PLAN_TABLE when using QMF13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 31 Oct 2000 07:51:00 -0600406_iso-8859-1 Just another thought -- do you by chance have QMF bound with reopt(vars)? I'm not completely sure if it would cause this situation, but I've heard binding explain=y, reopt(vars) will cause an explain/plan-table insert every time static SQL in that package is executed. The part I'm not sure about is if this would carry over to dynamic SQL as well as static, but it wouldn't hurt to check. [...]
6062 69 49_Problems introduced with CAE 6.1 using MSAccess??17_Hipenbecker, Doug25_Hipenbecker.Doug@MBCO.COM31_Tue, 31 Oct 2000 08:06:54 -0600643_iso-8859-1 Greetings!
I was wondering if anyone else had experienced problems which were introduced when upgrading Windows CAE client software from V5.2FP9 to V6.1FP4 for MSAcess97 clients accessing DB2/MVS V6 through a DB2Connect V5.2FP10 AIX gateway server
Problem #1 I have MSAccess clients regularly generating SQL "group by expression". With 5.2CAE, if the SQL was "group by column", the "group by" was passed along the DB2/MVS. If the SQL was "group by expression", it was stripped off of the SQL being passed to DB2/MVS and (I assume) the client would do the group filtering in that case (which worked). With 6.2CAE, [...]
6132 18 13_EDF trace SQL8_Rush Yan14_db2-l@21CN.COM31_Tue, 31 Oct 2000 22:19:34 +0800300_us-ascii Hello,
I'm not sure it's the right place to post this question, any thought will be appreciated:
I have two program A and B, A is a COBOL program and B is C, both embeded SQL, I can use EDF to trace the SQL in A, but EDF bypass the SQL statment in B, any clue? Thank you. [...]
6151 24 31_Damaged history file - SQL2161N13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 31 Oct 2000 08:57:26 -0600532_us-ascii Hi, I hope someone can help me. I am using UDB on AIX 4.1. I am trying to restore a new test database from an existing backup and I get the following error: "SQL2161N A damaged recovery history file could not be fixed. The specified action failed." The backup is from a version 5.2 database which I am trying to restore to a version 6.1 instance. I have done this suscessfully with a redirected restore on another box with no problems. A new box and instance were set up for me to use for a testing server. I tried to [...]
6176 54 11_Re: Queries0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 31 Oct 2000 09:05:01 -0600453_us-ascii in COBOL you can use the command: INSPECT var REPLACING "a" BY "A" "b" BY "B" ... "z" BY "Z" OR
INSPECT var CONVERTING "abc ... xyz" TO "ABC ... XYZ"
Srirengan Venkatesh Kumar @RYCI.COM> on 2000/10/31 12:21:28 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
6231 87 33_More thoughts on index monitoring14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 31 Oct 2000 14:09:54 -0000406_iso-8859-1
Just to further muddy the waters a bit.
Imagine that you have just reorganised your index and it now occupies 75% of the indexspace.
You now perform many updates on it such that any freespace and freepages that are specified are used up.
Now, your index may only look 80% full, but when you reorganise it - WHAM - it now needs more than the primary allocation! [...]
6319 34 56_Large Tablespaces Management and Maintenance !!! HOW ???17_Pantazis Pantazis20_zakis@CYTANET.COM.CY31_Tue, 31 Oct 2000 04:32:05 +0200385_iso-8859-1 I am a new DBA in DB2 for OS390 and since I do not have much experience, I would like your advice on one matter.
How do you handle tablespaces of more than 80000 tracks????
Especially if you have a problem with the volume capacity. Is compression an option?, and if it is what will the impacts be in other database operations, i.e. backup recover, e.t.c. [...]
6354 59 35_Re: Damaged history file - SQL2161N11_Jakobs, Jef18_JJakobs@HARTIC.COM31_Tue, 31 Oct 2000 09:19:08 -0600370_iso-8859-1 Hi Helen,
Once ran into a damaged history file myself (on AIX), and I think I remember using "prune history" with a date that made sure nothing would really be deleted from the history file (that's what prune does). This found the history file damaged, but replaced it.
The risk you take is that you start out with an empty history file... [...]
6414 58 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 10:18:15 -0500348_iso-8859-1 First partition the tablespace. You can have up to 254 partitions in V5. This will allow up to 1 TB. You can have 254 datasets each of which is about 81380 tracks of 3390 DASD.
Also, compression may be a good idea. We compress almost everything. Very few of our tablespaces show less than a 20% savings. 50% is more typical. [...]
6473 63 35_Re: Damaged history file - SQL2161N10_Leo Pedron19_lpedron@BOSCOVS.COM31_Tue, 31 Oct 2000 10:32:19 -0500509_iso-8859-1 It's true that DB2 will create a new history file every time that a recovery is performed to log the recovery. It sounds like your history file has somehow become corrupted. You need to perform a restore of just the history file before you can recover the database.
I have run into this situation before, but I had multiple backups available, and I used the history file from an earlier image. After performing the restoration of the history file I was able to restore my backup image. [...]
6537 75 57_Re: How can youtell if an index is approaching 100% full?0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 31 Oct 2000 09:38:54 -0600581_us-ascii Sounds reasonable. Wish we could set up a process that good. It also sounds like you have to be very much on your toes, or you (DBA) gets blamed for production failures.
From what I've read, it seems that estimating manually (using system info, ie high RBA) or via tools, amount of space really used in an extent of a TS/IS is pretty tricky: - does the space have FREESPACE/FREEPAGES defined - How much have they been used since last re-org - how much insert/delete activity since last reorg, - type of insert/delete activity (is it random or sequential) (I'm [...]
6613 142 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???0_18_mebert@AMADEUS.NET31_Tue, 31 Oct 2000 16:53:15 +0100607_us-ascii There are many things to consider & several options:
1. With a TS that large, using FREEPAGE 0 PCTFREE 0 (and REORGing from time to time) is probably a good idea unless there is a very high change activity. In our installation, these big TSs are usually updated by LOAD RESUME (appending data in ascending cluster sequence) only. 2. Try compression (make sure it's HW assisted; in the archives you can find a REXX to determine whether your machine supports it). Especially with large row lengths and long CHAR columns (dozens or more characters), you might get high compression ratios. [...]
6756 142 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???0_18_mebert@AMADEUS.NET31_Tue, 31 Oct 2000 16:53:15 +0100607_us-ascii There are many things to consider & several options:
1. With a TS that large, using FREEPAGE 0 PCTFREE 0 (and REORGing from time to time) is probably a good idea unless there is a very high change activity. In our installation, these big TSs are usually updated by LOAD RESUME (appending data in ascending cluster sequence) only. 2. Try compression (make sure it's HW assisted; in the archives you can find a REXX to determine whether your machine supports it). Especially with large row lengths and long CHAR columns (dozens or more characters), you might get high compression ratios. [...]
6899 18 21_Re: DSTATS bind error14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Tue, 31 Oct 2000 10:02:47 -0600312_iso-8859-1 I did submit this last week and had one response which didn't help. I downloaded DSTATS for www.idug.org/member/journal/mar99
I don't know if anyone else has done this but maybe this will help. I think the DBRM is bad and that is why I'm getting "DBRM DSTATS IS IN AN INCONSISTENT STATE". [...]
6918 24 18_Storage procedures0_27_vinhaes@CAIXASEGUROS.COM.BR31_Tue, 31 Oct 2000 14:09:03 -0300524_us-ascii Hi everyone
The table sysibm.sysprocedures has two storage procedures called dsnwzp and dsnutils.
And I could not find any information about it. (DB2 V5.01)
Thanks for any information you may have on this.
Luiz Cesar Caixa Seguros Brazil
================================================ 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.
6943 62 57_FW: How can youtell if an index is approaching 100% full?11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 31 Oct 2000 08:09:01 -0800358_iso-8859-1 -----Original Message----- From: BOLEY Maurice C * Cliff Sent: Tuesday, October 31, 2000 8:03 AM To: 'Scott Lindsey' Subject: RE: How can youtell if an index is approaching 100% full?
Yikes, I guess I opened a Pandora's box when I offered some freeware. I'll see about getting the jobs out on DB2-L-Documents@RYCI.COM cliff:-) [...]
7006 30 13_DETAIL OS/39016_Aurora Dell'Anno26_aurora.dellanno@SISTINF.IT31_Tue, 31 Oct 2000 16:33:06 +0100453_us-ascii hi list,
can anyone give me some feedback on a product called DETAIL for DB2 / IMS Data Warehousing on MVS / OS/390?
anything will be of help, thanks very much.
Aurora Emanuela Dell'Anno Systems Programmer Sistemi Informativi S.p.A. e-mail: aurora.dellanno@sistinf.it tel. +39 335 7429486
no trees were killed in the sending of this message. however - a large number of electrons were seriously inconvenienced. [...]
7037 102 20_Example calls DSNWZP11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Tue, 31 Oct 2000 11:36:38 -0500566_iso-8859-1 I posted Cobol and rexx examples to the DB2L documents site.
(http://jupiter.ryci.com/archives/db2-l-documents.html)
-----Original Message----- From: Alfred Abplanalp [mailto:Alfred.Abplanalp@GS-VBS.ADMIN.CH] Sent: Monday, October 30, 2000 8:27 AM Subject: AW: Control Center / DSNWZP
No, i haven't.
I tried via Visual Explain and id did not return a Result. I have Cobol samples for other Stored Procedures wich return results on OS/390 but not when called via ODBC. Can you send me your sample in COBOL or REXX? [...]
7140 23 30_Scrollable Cursor Presentation11_Robert Jans21_Jans.Robert@AMSTR.COM31_Tue, 31 Oct 2000 08:37:00 -0700368_- For all who asked for a copy of this presentation, this has been posted to the DB2-L-DOCUMENTS list at RYCI. Many thanks to the author, Kalpana Shyam, and IBM for permission to post this.
Robert Jans Albertsons, Inc 155 North 400 West Mail Drop 4427 Salt Lake City, UT 84103 (801) 961-3212 jans.robert@albertsons.com [...]
7164 13 4_Test14_Philip Gunning18_pgunning@PHEAA.ORG31_Tue, 31 Oct 2000 11:58:57 -0500271_us-ascii Phil Gunning DB2 DBA
================================================ 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.
7178 43 22_Re: Storage procedures16_Peter Van Eeuwen24_pvaneeuwen@ALTAVISTA.COM31_Tue, 31 Oct 2000 09:11:07 -0800760_- dsnutils - http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNUG0F4/APPENDIX1.2
dsnwzp - http://www-4.ibm.com/software/data/db2/os390/v6facts/db2ve.html
On Tue, 31 October 2000, vinhaes@CAIXASEGUROS.COM.BR wrote:
> > Hi everyone > > The table sysibm.sysprocedures has two storage procedures called dsnwzp and > dsnutils. > > And I could not find any information about it. (DB2 V5.01) > > Thanks for any information you may have on this. > > > Luiz Cesar > Caixa Seguros > Brazil > > ================================================ > 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. [...]
7222 67 22_Control center - SQLID15_Pierre Dagenais19_pdagenai@UOTTAWA.CA31_Tue, 31 Oct 2000 12:13:54 -0500479_us-ascii Hi
I have tried what you have suggested but the problem remains.
Any more clues?
Pierre Dagenais
Subject: Re: Control center - SQLID Date: Mon, 30 Oct 2000 09:55:43 -0600 From: "Mackey, Glenn"
Hi, Have a look at the client configuration assistant. For the alias/Database .... Select Properties-->ODBC/CLI settings(No need to logon)-->Advanced. Enterprise tab, CURRENTSQLID. [...]
7290 51 48_Date range processing - an idea to pass your way0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Tue, 31 Oct 2000 11:11:56 -0600321_us-ascii I had a thought about a method of giving the DB2 optimizer a bit more flexibility on date range predicates. I pass this technique your way for what it is worth. Of course, you use this technique at your own risk and as always on the list server, this is open to the scrutiny of all list server subscribers. [...]
7342 34 34_Re: Scrollable Cursor Presentation13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 31 Oct 2000 12:27:09 -0500623_us-ascii Robert,,, Have to ask a dumb question,,,,what do I use to see the presentation???
Robert Jans wrote:
> For all who asked for a copy of this presentation, this has been posted to the > DB2-L-DOCUMENTS list at RYCI. Many thanks to the author, Kalpana Shyam, and > IBM for permission to post this. > > Robert Jans > Albertsons, Inc > 155 North 400 West > Mail Drop 4427 > Salt Lake City, UT > 84103 > (801) 961-3212 > jans.robert@albertsons.com > > > ================================================ > To change your subscription options or to cancel your subscription [...]
7377 41 17_DB2 XML Extenders13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 31 Oct 2000 11:38:51 -0600459_iso-8859-1 Hi,
I would like to know if anyone has successfully called the DB2 XML extenders stored procedures, dxxInsertXML and dxxRetrieveXML, to work when called via Java and JDBC.
If so, I would appreciate a copy of some code and perhaps some experience stories.
We have successfully tested the supplied samples, which invoke the via C-modules. The Java samples execute the dxxGenXML and dxxShredXML which we want to avoid using. [...]
7419 86 22_Re: Storage procedures0_27_vinhaes@CAIXASEGUROS.COM.BR31_Tue, 31 Oct 2000 15:39:25 -03001054_us-ascii Thanks Peter
Peter Van Eeuwen em 31/10/2000 14:11:07
Favor responder a DB2 Data Base Discussion List
Para: DB2-L@RYCI.COM
cc: (bcc: Vinhaes C Luiz/MATRIZ/SASSE)
Assunto: Re: Storage procedures
dsnutils - http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNUG0F4/APPENDIX1.2
dsnwzp - http://www-4.ibm.com/software/data/db2/os390/v6facts/db2ve.html
On Tue, 31 October 2000, vinhaes@CAIXASEGUROS.COM.BR wrote:
> > Hi everyone > > The table sysibm.sysprocedures has two storage procedures called dsnwzp and > dsnutils. > > And I could not find any information about it. (DB2 V5.01) > > Thanks for any information you may have on this. > > > Luiz Cesar > Caixa Seguros > Brazil > > ================================================ > To change [...]
7506 80 43_Re: DB2 SPs and updating non-DB2 resources.11_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 31 Oct 2000 11:41:10 CST636_- Eric: with RRSAF, would there not be 2-phase commit across all such resources (MQ and VSAM, specifically)? Are you not using it? Or is there a difference when you COMMIT ON RETURN v/s a normal COMMIT withinn the calling application?
Suresh
>From: "Pearson, Eric L," >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: DB2 SPs and updating non-DB2 resources. >Date: Tue, 31 Oct 2000 08:35:55 -0500 > >We are doing similar without the MQ and VSAM. >We will be doing non-DB2 functions in SP in the near future. >So far our SP experience has been quite [...]
7587 42 32_Re: Scrollable Cursor Presentati11_Robert Jans21_Jans.Robert@AMSTR.COM31_Tue, 31 Oct 2000 11:04:00 -0700733_- Acrobe Reader works just fine................ ------------------( Forwarded letter 1 follows )--------------------- Date: Tue, 31 Oct 2000 12:27:09 -0500 To: DB2-L@RYCI.COM From: Jimmy.Willett@NCMAIL.NET Sender: IMCEAX400-c=US+3Ba=+@gcs.alias Reply-To: DB2.Data.Base.Discussion.List[DB2-L]@RYCI.COM Subject: Re: Scrollable Cursor Presentation
Robert,,, Have to ask a dumb question,,,,what do I use to see the presentation???
Robert Jans wrote:
> For all who asked for a copy of this presentation, this has been posted to the > DB2-L-DOCUMENTS list at RYCI. Many thanks to the author, Kalpana Shyam, and > IBM for permission to post this. > > Robert Jans > Albertsons, Inc > 155 North 400 West > Mail Drop [...]
7630 35 26_DB2 connect with SQLserver15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 31 Oct 2000 13:42:28 -0500365_iso-8859-1 To all,
I am using DB2 connect personal edition 7 to connect to DB2 V5.1 on OS/390 2.6. I have created a link server call DB2T_IBM in SQLserver 7.0. Also I created a DB2 stored procedure SP01 on mainframe. My question is can I executed the following query from SQLserver
Select * from openquery(db2t_ibm, "call sp01 (123223)") [...]
7666 113 43_Re: DB2 SPs and updating non-DB2 resources.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 13:39:06 -0500322_iso-8859-1 Suresh, I wish we could use RRSAF. However, our MVS staff has not yet implemented WLM. I hope they soon do as we have several critical applications which use both DB2 and MQ heavily. We also have several imminent (client-server) applications which need to do this and are likley to be great SP candidates. [...]
7780 56 30_Re: DB2 connect with SQLserver16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 13:44:00 -0500695_iso-8859-1 I think the 'from clause' of an SQL SELECT must be specified as FROM table-spec where table-spec is a table, view, or subselect.
eric pearson ITO DB2 support Eric.Pearson@nscorp.com
-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Tuesday, October 31, 2000 1:42 PM To: DB2-L@RYCI.COM Subject: DB2 connect with SQLserver
To all,
I am using DB2 connect personal edition 7 to connect to DB2 V5.1 on OS/390 2.6. I have created a link server call DB2T_IBM in SQLserver 7.0. Also I created a DB2 stored procedure SP01 on mainframe. My question is can I executed the following query from SQLserver [...]
7837 23 68_DB2 OS/390 Stored procedures submitting jobs to the internal read er13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 31 Oct 2000 14:02:54 -0500338_us-ascii Can they do that? We are at V5.1 using DB2-managed stored procedures and one of our development groups may have a need to submit a job to the JES internal reader. Thanks for any info/opinions you may have...
Lynne A. Flatley New England Financial (617) 578-4079 (work) (781) 718-0919 (cell) lflatley@nefn.com [...]
7861 20 34_Re: Scrollable Cursor Presentation17_Valerie J Traurig18_valeriet6@JUNO.COM31_Tue, 31 Oct 2000 13:23:46 -0500406_- I tried to use Adobe and was only able to see a written summary of the presentation. I got errors trying to see the contents. Has anyone been able to view it? ________________________________________________________________ YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. [...]
7882 39 72_Re: DB2 OS/390 Stored procedures submitting jobs to the internal read er13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 31 Oct 2000 13:08:17 -0600358_iso-8859-1 We do that via our DB2 managed SPAS. We have a DD statement setup in our SPAS and our Cobol SP's write directly to that DD.
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Tuesday, October 31, 2000 1:03 PM To: DB2-L@RYCI.COM Subject: DB2 OS/390 Stored procedures submitting jobs to the internal read er [...]
7922 29 34_Re: Scrollable Cursor Presentation13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 31 Oct 2000 14:11:57 -0500672_us-ascii yes, after the response to my message,,,I used Adobe 4.0 and all went well. Good presentation.
Valerie J Traurig wrote:
> I tried to use Adobe and was only able to see a written summary of > the presentation. I got errors trying to see the contents. > Has anyone been able to view it? > ________________________________________________________________ > YOU'RE PAYING TOO MUCH FOR THE INTERNET! > Juno now offers FREE Internet Access! > Try it today - there's no risk! For your FREE software, visit: > http://dl.www.juno.com/get/tagj. > > ================================================ > To change your subscription options or to cancel your [...]
7952 50 72_Re: DB2 OS/390 Stored procedures submitting jobs to the internal read er16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 14:06:28 -0500466_iso-8859-1 Should be fairly easy. In the SP, embed logic to do SVC99 dynamic allocation of the internal reader. Write to the internal reader. Or if SVC99 is considered too risky by management, just add a DD statement to the SP address space. Open the DCB for the DD, write the job stream, close the DCB. Where you might run into confusion is when there are multiple concurrent callers of the SP. Then you would need to add some serialization logic for the DCB. [...]
8003 40 22_db2set return code -1012_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 31 Oct 2000 11:24:07 -0800510_us-ascii Esteemed listmembers,
Our AIX box was rebuilt with the incorrect hostname, and DB2 6.1 EE fp5 was installed, and an instance created. I could not get Control Center to connect. I got a DBA0102N message with a -1 rc. Looking at the registry variables, I see that the DB2SYSTEM name is still set to the old, incorrect name. I dropped the instance, then I changed the AIX hostname to "sp-f4n3e" and rebooted. I recreated the instance. The old system name still appears as the DB2SYSTEM name. [...]
8044 127 37_Re: More thoughts on index monitoring0_18_mebert@AMADEUS.NET31_Tue, 31 Oct 2000 17:10:51 +0100361_us-ascii For a long time I have in place a process that uses the BMCSTATS Historical database for tracking space requirements and generating ALTER statements. Essentially, I used to update the PRIQTY to the maximum of (Space needed if REORGed, Space used) over the past 30 days. In our production environment, that generated maybe 500-1000 ALTERs per day. [...]
8172 30 35_Column update on key of part. index0_22_Thomas_Abbott@HESC.COM31_Tue, 31 Oct 2000 14:28:08 -0500555_us-ascii I have a question concerning the update of a column which is defined as the key of a partitioned index. We are currently at DB2 V5. We have a partitioned table defined with a primary key (integer, not null with default). We then created a type 2 unique index which is clustered and partitioned. Data was loaded and/or DSN1COPY'ed and indexes recovered. I would expect that the column named as the primary key could not be updated since it is the key of a partitioned index. On some of our test databases we can update the column. A check of [...]
8203 87 26_Re: Control center - SQLID10_Rob Wright17_rwright@LIC.CO.NZ30_Wed, 1 Nov 2000 08:28:55 +1200617_us-ascii Try changing the SYSSCHEMA name on the same tab.
Pierre Dagenais on 11/01/2000 05:13:54 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rob Wright/ham/LIC)
Subject: Control center - SQLID
Hi
I have tried what you have suggested but the problem remains.
Any more clues?
Pierre Dagenais
Subject: Re: Control center - SQLID Date: Mon, 30 Oct 2000 09:55:43 -0600 From: "Mackey, Glenn" [...]
8291 21 56_Request: URL for DB2 REXX language support documentation14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Tue, 31 Oct 2000 13:29:28 -0600463_us-ascii Hello all,
Can someone give me a URL for DB2 REXX language support online documentation?
I've been searching for it for a while now, and haven't found it.
TIA
Richard Arnold Chase Bank
================================================ 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.
8313 54 39_Re: Column update on key of part. index16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 31 Oct 2000 14:50:56 -0500507_iso-8859-1 Thomas, If you have applied PTF UQ20575 you can update these columns. You can get the full detail on IBMLINK by looking at APAR PQ16946. You may well have this PTF applied since it has been available since 98/09/17.
eric pearson ITO DB2 support Eric.Pearson@nscorp.com
-----Original Message----- From: Thomas_Abbott@HESC.COM [mailto:Thomas_Abbott@HESC.COM] Sent: Tuesday, October 31, 2000 2:28 PM To: DB2-L@RYCI.COM Subject: Column update on key of part. index [...]
8368 39 60_Re: Request: URL for DB2 REXX language support documentation11_Jerry, Jeff27_Jeff.D.Jerry@WELLSFARGO.COM31_Tue, 31 Oct 2000 14:01:05 -0600581_- http://www-4.ibm.com/software/data/db2/os390/v5books.html
Look under Application and Programming Guide for an example.
-----Original Message----- From: Richard Arnold [SMTP:Richard.Arnold@CHASE.COM] Sent: Tuesday, October 31, 2000 1:29 PM To: DB2-L@RYCI.COM Subject: Request: URL for DB2 REXX language support documentation
Hello all,
Can someone give me a URL for DB2 REXX language support online documentation?
I've been searching for it for a while now, and haven't found it. [...]
8408 70 60_Re: Request: URL for DB2 REXX language support documentation10_Kathy Culp21_Kathy_Culp@BCBSTX.COM31_Tue, 31 Oct 2000 14:11:31 -0600643_us-ascii This one looks to be chock full of goodies...
http://www2.hursley.ibm.com/rexx/rexx.html
"Jerry, Jeff" cc: Sent by: DB2 Data Subject: Re: Request: URL for DB2 REXX language support documentation Base Discussion List
10/31/2000 02:01 PM Please respond to DB2 Data Base Discussion List
http://www-4.ibm.com/software/data/db2/os390/v5books.html
Look under Application and Programming Guide for an example. [...]
8479 88 33_Moving Tablespaces to another DB222_Fernando Sampaio - BMS16_nando@BMS.COM.BR31_Tue, 31 Oct 2000 18:15:55 -0300430_iso-8859-1
Hi,
Someone knows the best way to move the tables from one DB2 (one OS/390 installation) to another DB2 (in another CPU), without having to recreate them manually? DSNTIAU / Load could do the job automatically?
Atenciosamente,
Fernando Silveira Sampaio
Consultor de TI Sênior SAP R/3 Certified Technical Consultant BMS - Belgo Mineira Sistemas Ltda *(31)-2174169 - * nando@bms.com.br
8568 81 22_Re: Storage procedures14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 31 Oct 2000 14:35:28 -0600622_iso-8859-1 While there is some published information available, there is much more in the way of stored procedures delivered with DB2, about 7+ of them.
All the documentation on them that I have available will be on our web site, in a couple days (maybe Wednesday 11/1 or Thursday 11/2). The are some that are packaged with Visual Explain, some in support of Control Center, and others that serve specific functions. Check out http://www.ylassoc.com and there will be a menu selection on the left for Publications and Presentations. On that page you will find the documentation on all these stored procedures, [...]
8650 32 31_Mirror'd DASD Recovery Scenario12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 31 Oct 2000 15:36:53 -0500426_us-ascii Dear List Members,
We are looking at a mirrored DASD recovery scenario where DB2's system datasets, logs, BSDS's, catalog and directory are on mirrored DASD.
When it comes to the applications tables, some are critical while others are not so and so we would consider not mirroring all of them. So, we would attempt to bring DB2 up without some of the tablespace files available on the remote site. [...]
8683 49 60_Re: Request: URL for DB2 REXX language support documentation14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 31 Oct 2000 14:38:57 -0600702_us-ascii It is now incorporated into all the normal DB2 manuals. Look on the http://www.software.ibm.com/data/db2/os390 web site for the current manuals. The updated V6 are very helpful in this area.
Regards, Richard +======+======+======+ Richard_Yevich@YLAssoc.com http://www.YLAssoc.com -- DB2 Performance Journal
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Richard Arnold > Sent: Tuesday, October 31, 2000 1:29 PM > To: DB2-L@RYCI.COM > Subject: Request: URL for DB2 REXX language support documentation > > > Hello all, > > Can someone give me a URL for DB2 REXX language support online > documentation? > > I've been [...]
8733 57 37_Re: Moving Tablespaces to another DB217_Anand Thippeswamy19_Thippesa@MEIJER.COM31_Tue, 31 Oct 2000 15:38:24 -0500318_US-ASCII BMC Alter with Migrate features does the job pretty good. For copying the data DSN1COPY ( again a feature in BMC) is the best way but we ran into problems where > 500 tables (mostly empty & courtesy : peoplesoft) were defined in a single tablespace and we hit the Max OBID array size (IBM restrictions). [...]
8791 49 42_Column update on key of part. index -Reply12_John Bucaria22_JBUCARIA@MAIL2.PCH.COM31_Tue, 31 Oct 2000 15:38:11 -0500292_US-ASCII Thomas, It is my understanding that if a foreign key is defined but no "child" rows exist, then an update to the primary key of the "parent" table can take place. If however, child rows do exist updates are not allowed. Is it possible your Production table has "children"? John [...]
8841 38 37_Re: Moving Tablespaces to another DB29_Rob Crane22_racrane@CONCENTRIC.NET31_Tue, 31 Oct 2000 13:51:53 -0700375_iso-8859-1 Check out the Data Sharing planning and administration guide. It describes how you can merge the catalogs. You could use the same procedure to "move" your selected objects without the downtime normally associated with having to using utilities to do unloads/loads. You might want to check the archives as there have been many posts on this topic in the past. [...]
8880 87 60_Re: Large Tablespaces Management and Maintenance !!! HOW ???0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 31 Oct 2000 09:46:01 -0600440_us-ascii Also take a look in the archives. A few months back there were discussions about space management and compression including the differences between H/W and S/W compression and how to ID if H/W compression is available on your system.
"Pearson, Eric L," @RYCI.COM> on 2000/10/31 09:18:15 AM
Please respond to DB2 Data Base Discussion List [...]
8968 68 37_Re: More thoughts on index monitoring12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Wed, 1 Nov 2000 09:38:48 +1100360_- Phil, I've seen the reciprocal with type 2. The case in point was where on a large partitioned TableSpace there were lots of NPI's. There was also a fair amount insert and delete activity on the table, and updates against these indices. In some instance the indices had grown in to a 5th or 6th 2G dataset, through the pseudo-deleted RIDs in the index. [...]
9037 68 39_Re: Column update on key of part. index15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 1 Nov 2000 09:40:33 +1100360_- Thomas,
Someone else mentioned being able to update the primary key values if that particular primary key value has no children. This is true, however I don't think it's what you're finding because that ability depends on specific data values, not a total ban (or acceptance) on updating the column, as you say is specified in Sysibm.Syscolumns. [...]
9106 121 32_rexx sql/db2 with column decimal14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 1 Nov 2000 09:51:50 +1100472_iso-8859-1 Anyone care to comment on the following?
-----Original Message----- From: James Campbell Sent: Tuesday, October 31, 2000 7:15 PM To: 'TSO REXX Discussion List' Subject: RE: [TSO-REXX] rexx sql/db2 with column decimal
Alex,
Having checked, I've found the same problem. Possibly PQ31316 covers the problem you describe ("Other problems fixed: ...Incorrout of FLOAT and DECIMAL columns on both input and output") but it's for V5. [...]
9228 178 37_Re: More thoughts on index monitoring16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 31 Oct 2000 22:56:19 -0000417_- Nick - I have seen this too. TYPE-2 indexes does not physically delete the entries during a DELETE operation, but marks it as pseudo deleted. I must admit I dont know WHEN these pseudo deleted entries are removed - except during REORG. Long time ago when I heard about TYPE-2 for the first time, the response from IBM was that DB2 decided when it find it convenient to get rid of these pseudo deleted entries. [...]
9407 83 37_Re: More thoughts on index monitoring15_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Tue, 31 Oct 2000 17:29:11 -0600436_iso-8859-1 I thought I would add a few tidbits of information for the curious (or the seriously twisted).
You can force DB2 to physically delete the rid by locking the table in EXCLUSIVE MODE prior to the delete. A SELECT with a REPEATABLE READ cursor will eliminate the pseudo deleted rids. When DB2 decides on its own to remove the pseudo deleted rids, it will not remove uncommitted pseudo deleted rids, so commit often. [...]
9491 52 37_Re: Moving Tablespaces to another DB213_Purnima Patel18_ppatel@METLIFE.COM31_Tue, 31 Oct 2000 16:42:22 -0500666_iso-8859-1 If you have BMC you could just migrate the database anywhere.
"Fernando Sampaio - BMS" @RYCI.COM> on 10/31/2000 04:45:55 PM
Please respond to "DB2 Data Base Discussion List"
Sent by: "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM cc: Subject: Moving Tablespaces to another DB2
Hi,
Someone knows the best way to move the tables from one DB2 (one OS/390 installation) to another DB2 (in another CPU), without having to recreate them manually? DSNTIAU / Load could do the job automatically? [...]
9544 105 47_Re: DB2 (OS390) V5.1, DB2 Connect and MS Access12_Marcus Green18_mgreen@AAPT.COM.AU30_Wed, 1 Nov 2000 11:55:21 +1100354_US-ASCII Gerald,
Yes, I had a quick look at that product a little while ago. Does it also convert all the MS Access queries and forms as well?
Without going into too much detail, this is a little mini standalone system in MS Access. I just needed to get the data out and up on the mainframe for other processes to run against it...... [...]
9650 51 3_Hi,12_Marcus Green18_mgreen@AAPT.COM.AU30_Wed, 1 Nov 2000 13:34:15 +1100295_US-ASCII Hi,
I looking for a product for DB2 V5 (OS390) that will allow multiple users to have their own virtual copy of a table, which they can read and update, but operates from a single base image that is non updatable (by those users).
ie Base table has 1,000 rows in it. [...]
9702 124 52_Re: Date range processing - an idea to pass your way14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM30_Wed, 1 Nov 2000 15:04:37 +1100509_iso-8859-1 Larry,
Firstly, let me applaud you in presenting such an idea to the list to be critiqued by vultures like myself. The following are therefore my opinions and up for critique also.
You are correct, the date range using BETWEEN will effect the matchcols of subsequent index columns. The issue is not really the number of matchcols, but rather, at which level of the index provides the most significant filtering. Non-matchcols predicates will still be index screening predicates. [...]
9827 15 9_DB2 tools8_Rush Yan14_db2-l@21CN.COM30_Wed, 1 Nov 2000 13:27:18 +0800341_us-ascii Hi, Would you pls give me some comments about the DB2 products? Thank you.
Rush Yan
================================================ 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.