1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2003, week 5
2 112 93_DB2 UDB V8 Lnux, UNIX, and Windows Performance and Tuning Course, Chicago, IL 16-20 June 200312_Phil Gunning22_pgunning@GUNNINGTS.COM31_Sat, 29 Mar 2003 03:30:23 -0500612_iso-8859-1 FOR IMMEDIATE RELEASE:
(Gunning Technology Solutions, LLC, Reading, PA)
Gunning Technology Solutions, LLC a leading DB2 Consulting and Education firm, announces a new course that will be held at several locations in the US and UK for the remainder of 2003. The title of the course is DB2 UDB V8 Performance and Tuning for Linux, UNIX, and Windows. The next course is scheduled for June 16-20, at the Westin on Michigan Avenue, Chicago, IL. Course materials consist of a course book and a copy of the DB2 UDB V8 Handbook for Linux, UNIX, and Windows, IBM Press, May 2003 (by [...]
115 16 49_Leon Katsnelson/Toronto/IBM is out of the office.15_Leon Katsnelson15_leon@CA.IBM.COM31_Sat, 29 Mar 2003 03:49:58 -0500473_us-ascii I will be out of the office starting March 29, 2003 and will not return until April 7, 2003.
I will be away on vacation. I will have have no access to email or telephone. Shili Yang will be my back up.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
132 175 26_Re: DB2 OS/390 to DB2 UDB?0_23_sjtoeniskoetter@AEP.COM31_Sat, 29 Mar 2003 07:49:09 -0500394_us-ascii Dave,
A couple years ago I fought with this same error message. I looked and looked in IPNAMES and LOCATIONS, trying to find something that didn't look right. Eventually an IBMer clued me in that the message was useless, and what the real problem was. By then I had D31057 imprinted on my brain I think, because I see that message and I immediately think private protocol. [...]
308 36 34_Re: DB2 log switches/checkpointing12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 29 Mar 2003 10:03:07 -0600525_- This is a good discussion, and everything looks very reasonable. The biggest change for LOGLOAD came with fast log apply in V6. Before that, reading and applying the log took two to ten times longer. So LOGLOAD of 100,000 to 200,000 in V5 meant longer restarts, while V6 and up can tolerate half a million or a million. For me, the key to LOGLOAD is how long can the restart be. In V5, the rule of thumb I used was each extra 100,000 in LOGLOAD meant an extra 5 minutes for restart. Some of the foils and notes are on [...]
345 89 34_Re: DB2 log switches/checkpointing16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Sat, 29 Mar 2003 09:32:28 -0800383_us-ascii Thanks Mike, Juan, Issac. I think I was not clear about what I wanted to know. I do know that all the restart information (including oldest URs, pending database writes, restrictive statuses etc.) has to be in the log as a part of checkpoint or otherwise. As I understand, checkpoint merely writes this information about pending writes that it obtains rom 'somewhere'. [...]
435 70 42_Re: Explain for OS/390 from Command Center7_Ed Long19_rdhm99a@PRODIGY.NET31_Sat, 29 Mar 2003 17:10:49 -0800590_us-ascii My experience has been that very little of the V7 Control center or Stored Procedure Builder works very well when dealing with OS/390.
I'd suggest either, 1: try V8 or 2: Get something like Quest which works smoothly against either UDB or 390.
--- Teldb2kals wrote: > Hi, > > Does Explain work for OS/390 connections from the > Control Center or Command > Center ? > > The Explain SQL button in Command Center seems to > generate some CREATE > TABLE DDLs which are valid only on Win/Unix UDB, and > the explain fails, > with the [...]
506 83 47_Re: New Cross-Platform SQL Reference on the web12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Sun, 30 Mar 2003 13:00:31 -0600510_us-ascii You know I came in today to get some work done on getting this new development center up and running and I left my reference manual at home. So low and behold you posted this. I actual found the syntax for the IF statement I needed. How timely.
Thanks.
Buzz
Roger Miller cc: Subject: New Cross-Platform SQL Reference on the web Sent by: DB2 Data Base Discussion List [...]
590 34 32_Dominic Li is out of the office.10_Dominic Li21_dominicli@HSBC.COM.HK31_Mon, 31 Mar 2003 15:20:40 +0800646_us-ascii I will be out of the office from 03/31/2003 until 04/21/2003.
For any urgent matters, please send your mail to Alice Cheng (Alice Y Y Cheng) or my boss Fung Kam Yiu (Kam Yiu K Y Fung).
Thanks & Regards, Dominic
********************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
625 36 23_Re: Info on TCS Company10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 31 Mar 2003 10:34:23 +0200389_us-ascii Hi
I read the article........TATA is using (It seems legally) a 'hole/bug' in the law made in '90 (and many big US companies
use this law without any problem) and so exploiting a 'business opportunity' as some US experts called it. I think that
many IT companies would have done the same. No one, all over the world, is free from this trend in IT field. [...]
662 56 34_Re: DB2 log switches/checkpointing11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 31 Mar 2003 04:00:25 -0500626_ISO-8859-1 Raquel
The information is not in the buffer pool. DB2 has many in-memory control blocks which it uses to control its processing, most allocated in the DBM1 address space. There is not much published information about these control blocks, but there is some description of the linkage between them in the Diagnostic Guide and Reference manual. There will be (at least) one control block for each pageset that records information about the status of that pageset. There will be (at least) one control block for each UR that records information about that UR. The control blocks are continually updated by [...]
719 14 29_Re: DB2 UDB 8.1 and Linux/39013_Thomas Schulz20_thomas.schulz@SVI.DE31_Mon, 31 Mar 2003 04:06:47 -0600323_- Hello
what kind of x-term client did you use
Thomas
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
734 20 23_Dynamic SQL help needed10_praveen_kj22_praveen_kj@INFOSYS.COM31_Mon, 31 Mar 2003 18:06:36 +0530490_iso-8859-1 Hi,
Any pointer to any code / document / books that explains how to set pointer variables for SQLDA which is used to execute Varying-List Select Dynamic SQL statements ( Type 4 ) by a COBOL program.
TIA, Praveen
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
755 29 34_Re: DB2 log switches/checkpointing10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 31 Mar 2003 14:55:37 +0200359_us-ascii HI Raquel
I think that Chuck Hoover's paper
'Everything you ever wanted to know about DB2 buffering'
at page 22 and following, could be an answer to your question, where Hoover deals with how DB2 tracks and
writes modified pages to disk, using buffers headers,anchor points in page sets control blocks to track page, [...]
785 79 25_Re: DB2 Archive Logging??16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 31 Mar 2003 08:57:20 -0500485_iso-8859-1 We did things that way for a while. No particular problems. Only real consideration is that you pick a BLKSIZE which works for DASD. That BLKSIZE is less thatn 100% efficient for tape, but the best tape BLKSIZE is *HORRID* for DASD.
Regards, Eric Pearson NS ITO DB2 support
-----Original Message----- From: Carlos Olson [mailto:COlson@QRS.COM] Sent: Friday, March 28, 2003 9:15 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 Archive Logging?? [...]
865 32 29_Re: DB2 UDB 8.1 and Linux/39013_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Mon, 31 Mar 2003 08:30:14 -0600608_iso-8859-1 cygwin is what we use. See http://www.cygwin.com/ Glenn
-----Original Message----- From: Thomas Schulz [mailto:thomas.schulz@SVI.DE] Sent: Monday, March 31, 2003 4:07 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 UDB 8.1 and Linux/390
Hello
what kind of x-term client did you use
Thomas
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
898 51 38_Re: Roger Miller DB2 Developer's Guide31_Poston, William L (COMFIN, VFS)21_william.poston@GE.COM31_Mon, 31 Mar 2003 10:58:02 -0500461_iso-8859-1 Does anyone know if Roger Miller has published his DB2 Developer's Guide for Version 7?
-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Friday, March 28, 2003 4:57 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: New Cross-Platform SQL Reference on the web
The update is called Version 1.1, reflecting the common SQL available on DB2 UDB for: z/OS V7, iSeries V5R2, and Linux, UNIX & Windows V8. [...]
950 37 25_Stored Procedure question0_19_csutfin@AMSOUTH.COM31_Mon, 31 Mar 2003 10:04:34 -0600496_us-ascii I am running is OS390 2.20 with DB2 V6 maintenance level is about 6 months old. and am trying to implement non-WLM stored procedures.
I have changed the zparms from STORMXAB=0, to STORMXAB=5, and STORPROC=, to STORPROC=DB2ISPAS, The DB2ISPAS started task is running.
I am attempting to the steps of DSNTIJSG that create the stored procedures DSNWZP and DSNUTILS making sure that my CURRENT SQLID is set to an install SYSADM. I keep receiving a return SQLCODE of -592. [...]
988 28 21_RID Failures - Repost24_Harry Samuel Vijayakumar23_harry_vijay@HOTMAIL.COM31_Mon, 31 Mar 2003 10:45:55 -0600451_- Hi all,
This is a repost since I did not receive any responses last time:
We are in DB2 v7.1. We are facing 'RID failure storage' problems very frequently. The SQL that causes the failure uses 100% of the RID pool and although it fails with 'RID failure storage' it does not release the pool for other sqls that come in later. the sqls that come in later fail as well eventhough they need a very small percentage of the rid pool. [...]
1017 62 38_Re: Roger Miller DB2 Developer's Guide11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Mon, 31 Mar 2003 12:05:08 -0500566_iso-8859-1 Do you mean Craig Mullins book?
-----Original Message----- From: Poston, William L (COMFIN, VFS) [mailto:william.poston@GE.COM] Sent: March 31, 2003 10:58 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Roger Miller DB2 Developer's Guide
Does anyone know if Roger Miller has published his DB2 Developer's Guide for Version 7?
-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Friday, March 28, 2003 4:57 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: New Cross-Platform SQL Reference on the web [...]
1080 71 29_Re: Stored Procedure question18_Jose Ramon Vazquez17_jrvazquez@ATCA.ES31_Mon, 31 Mar 2003 19:21:11 +0200706_us-ascii Hi,
Make sure you are using WLM ENVIRONMENT NO WLM ENVIRONMENT to run these Stored Procedures in the SPAS.
Regards.
csutfin@AMSOUTH.COM@LISTSERV.YLASSOC.COM> con fecha 31/03/2003 18:04:34
Por favor, responda a DB2 Data Base Discussion List
Enviado por: DB2 Data Base Discussion List
Destinatarios: DB2-L@LISTSERV.YLASSOC.COM CC: Asunto: Stored Procedure question
I am running is OS390 2.20 with DB2 V6 maintenance level is about 6 months old. and am trying to implement non-WLM stored procedures. [...]
1152 39 20_Database Tools Fairs11_Lee Mandell16_DBMSUser@AOL.COM29_Mon, 31 Mar 2003 12:22:53 EST227_US-ASCII Hi All, Do anyone on the list know of a web site or any information on Database Tools Fairs around the country, or for that matter out of the country. Any leads would be appreciated.
Regards, Lee Mandell
1192 85 38_Re: Roger Miller DB2 Developer's Guide31_Poston, William L (COMFIN, VFS)21_william.poston@GE.COM31_Mon, 31 Mar 2003 12:23:08 -0500508_iso-8859-1 yes I mean Craig Mullins
-----Original Message----- From: Tina Hilton [mailto:Tina.Hilton@ARVATOSYSTEMS.COM] Sent: Monday, March 31, 2003 11:05 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Roger Miller DB2 Developer's Guide
Do you mean Craig Mullins book?
-----Original Message----- From: Poston, William L (COMFIN, VFS) [mailto:william.poston@GE.COM] Sent: March 31, 2003 10:58 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Roger Miller DB2 Developer's Guide [...]
1278 13 29_Re: Stored Procedure question9_Jim Ruddy18_jaruddy@US.IBM.COM31_Mon, 31 Mar 2003 12:12:36 -0600339_- DSNUTILS MUST run in a WLM environment.
Jim Ruddy DB2 for z/OS Development
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1292 41 24_Re: Database Tools Fairs13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 31 Mar 2003 14:45:44 -0500388_utf-8 Hi Lee,
I don't know of any.
There used to be one annually here in Michigan, USA which was sponsored by our local DB2 User Group -- MDUG (see www.mdug.org). But, as I recently learned, member interest & attendance had decreased drastically over the past several years and it ceased to take place. I personally blame that on inadequate & poor quality trinketware. [...]
1334 26 25_Re: Sample INSIGHT report12_Fay, Colin M22_cfay@UNUMPROVIDENT.COM31_Mon, 31 Mar 2003 15:18:51 -0500384_us-ascii Hi,
I have a difficult deadlock situation that requires detailed analysis.
Is anyone out there willing to share an ISQL report written for INSIGHT (CA) Monitor to report on IFCID 172 records, which report on Deadlock information.
I would otherwise be interested in any other language extract going against the SMF records to pull off the same data. [...]
1361 53 29_Re: Stored Procedure question0_19_csutfin@AMSOUTH.COM31_Mon, 31 Mar 2003 14:31:18 -0600506_us-ascii Jim
I realize that. But what about DSNZWP. I get the -592 on that CREATE PROCEDURE statement also.
Carol Sutfin Corporate DBA AmSouth Bank (205)326-5214 Fax:(205)326-5613 csutfin@amsouth.com
Jim Ruddy cc: Sent by: DB2 Data Subject: Re: Stored Procedure question Base Discussion List
03/31/03 12:12 PM Please respond to DB2 Data Base Discussion List [...]
1415 77 29_Re: Stored Procedure question15_Andersen, Cindy18_candersen@FNNI.COM31_Mon, 31 Mar 2003 15:18:10 -0600356_iso-8859-1 Have you Granted Execute on the SYSPROC.DSNZWP Procedure to Public or whoever you want to run it? Yes, I know you are Install Sysadm, but you may need an explicit grant to execute. We have ACF2 for DB2 and we set up a PRC rule (Stored Procedure rule) to Allow Execute on SYSPROC.DSNZWP to Public. Try it and see if it makes any difference. [...]
1493 30 36_The maximum number of Stroage volume13_Tsai Laurence22_ltsai85613@HOTMAIL.COM30_Tue, 1 Apr 2003 06:07:06 +0800310_big5 hi listers, I would like to know if there is limitation of volume numbers of db2 storage group. Namly,what is the maximum number of volumes of DB2 STORAGE Group ? I was told that the number is around 126 volumes per storage group. Is it true ? Is it related to the litmitation of the DATABASE size ? [...]
1524 75 40_Re: The maximum number of Stroage volume22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Mon, 31 Mar 2003 16:45:06 -0600311_- From the manuals:
Number of volumes: There is no specific limit on the number of volumes that can be defined for a storage group. However, the maximum number of volumes that can be managed for a storage group is 133. Thus, there is no point in creating a storage group with more than 133 volumes. [...]
1600 14 43_Check Data Utility and Parent Table Updates12_Eva Hutchens19_eahutche@US.IBM.COM31_Mon, 31 Mar 2003 19:58:39 -0600324_- I have to drop and recreate a very large table that is connected to other tables with referential integrity. This table has multiple parents. My question is this: Can the parent tables be updated via CICS or Batch while the check data utility is running on the child? All of these tables are in separate tablespaces. [...]
1615 28 0_12_Emperor King23_EmperorKing@TEAMDB2.COM31_Mon, 31 Mar 2003 22:45:45 -0600563_us-ascii I have a test DB2 test program that Declares the cursor 'with hold' & the select is 'with UR'.
I open the cursor & proceed to fetch, committing every 2500 fetches.
At the same time I execute an IBM 'online reorg' on the table's tablespace.
The reorg abends with a reason code of 00C9008E, which a timeout: 00C9008E Explanation: A lock request for the resource identified by NAME could not be granted, and the request waited for a period longer than the maximum specified by the installation. The NAME lists the database.tsname. [...]
1644 55 8_SQL0902C13_yogesh kansal19_yogesh@DAVLIN.CO.IN30_Tue, 1 Apr 2003 11:03:32 +0530356_us-ascii Hello List, I am using Db2 V 7.2 on Linux 7.2 Recently i restored one of the database from another server with the same configuration as stated above . But while running any create or drop statement i get a error .....
SQL0902C A system error (reason code = "9") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 [...]