1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2006, week 5
2 158 81_Antwort: [DB2-L] v8 db2 z/os migration to save or not save critical access paths.11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Sep 2006 07:34:57 +0200357_iso-8859-1 it depends...........also check out Bind Impact Expert from my software house (Like other vendors we also support all types of SQL) as it is especially done for migration from Vnow to Vnext. We all know that things change, sometimes for the better, sometimes for the worse and DB2 migrations are no exception. You must simply "Be Prepared!" [...]
161 21 44_Interruption of Long Running Queries by User13_Wolfgang Hini39_wolfgang.hini@HIPERFORMANCE-SOFTWARE.DE31_Fri, 29 Sep 2006 00:56:55 -0500540_- Hallo,<br><br>in QMF we have the possibility to interrupt a query (but how is it done), in TSO or Batch a Job or TSO-user can be canceled (not nice but possible). Now we have a lot of Web applications and sometimes it would be nice to stop a query by the user himself, because it is never ending or the query was startet by mistake. Often people close the browser window thinking all was good, but the request is still running in DB2. Is there an application driven possibility to stop such a query by any other than 'cancel thread' [...]
183 34 21_Index Rebuild Pending10_Paul Fegan33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Fri, 29 Sep 2006 16:19:03 +1000509_us-ascii Anyone seen this before??<br><br>We had an index on a partitioned table in rebuild pending status after changing the piecesize and priqty. We did an online reorg of the tablespaces which completed successfully reallocated the index pageset using the new priqty but didn't reset the pending flag on the index. If we issue the reorg SHRLEVEL REFERENCE it again completes successfully but does reset the pending flag. This seems a little strange to me. Am I missing something or this really weird. [...]
218 62 48_Re: Interruption of Long Running Queries by User13_Mertens, Bart18_bart.mertens@CZ.NL31_Fri, 29 Sep 2006 08:21:38 +0200681_us-ascii Wolfgang,<br><br>DB2 V8 z/OS supports the Statement.cancel() method.<br><br>Regards, Bart<br><br>-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Wolfgang Hini Verzonden: vrijdag 29 september 2006 07:57 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] Interruption of Long Running Queries by User<br><br>Hallo,<br><br>in QMF we have the possibility to interrupt a query (but how is it done), in TSO or Batch a Job or TSO-user can be canceled (not nice but possible). Now we have a lot of Web applications and sometimes it would be nice to stop a query by the user himself, because it is never ending or the query [...]
281 33 68_db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure23_Parvathavardhini Kannan19_pkannan@INAUTIX.COM31_Fri, 29 Sep 2006 12:45:25 +0530302_US-ASCII Hi all,<br><br>When calling a CICS from a COBOL DB2 stored procedure do we need to use any special call statements ? Any special preparation steps (compilation parameters etc) ?<br><br>I saw in one of the old DB2lISTSERV threads a mention that " use EXCI interface to call CICS from SP " [...]
315 101 34_[ADMIN] Reminders from list owners12_Cuneyt GOKSU19_cuneytgoksu@USA.NET31_Fri, 29 Sep 2006 10:43:53 +0300498_ISO-8859-1 Hello DB2-L Subscribers,<br><br>This posting is something we (the list owners) are sending out about every couple of months. The purpose is to highlight information about DB2-L and also remind subscribers about certain information. Some information will be repeated to benefit new subscribers. We hope you will find the information useful, and save it for future reference. If you have feedback or suggestions, please contact us (the list owners) at DB2-L-Request@www.idugdb2-l.org [...]
417 78 25_Re: Index Rebuild Pending14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Fri, 29 Sep 2006 04:12:01 -0400487_us-ascii Hi Paul,<br><br>This is true for non portioning index of partitioned table space. It is not strange. Once you alter the piecesize of nonparty index it goes to PSRBD status like<br><br><INDEX NAME> IX L* RW,PSRBD.<br><br>Only rebuilt is needed for this to reset for portioned table space.<br><br>When you alter the same for nonparty tablespace index's piecesize the status would be <INDEX NAME> IX RW,RBDP. In this case simply doing a reorg tablespace also sets the status. [...]
496 91 38_Re: A technique for storing small LOBs12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 29 Sep 2006 13:50:43 +0200505_us-ascii Hi,<br><br>I tend to use a regular VC32K for LOBS up to 200K (with a sequence number column). It helps a lot with the shorter LOBs. If the design says that a LOB can be 200K + then we turn to the pray mode :-) (using LOB)<br><br>Isaac Yassin<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Larry Sent: Thursday, September 28, 2006 3:09 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] A technique for storing small LOBs [...]
588 211 50_Re: DB2 v8 Reclength field in the SYSIBM.SYSTABLES12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 29 Sep 2006 13:56:00 +0200402_us-ascii Hi,<br><br>Agus - your assumption is correct, the other 2 bytes are ID-MAP contents at end of page<br><br><br><br>Isaac Yassin<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Agus Kwee Sent: Thursday, September 28, 2006 5:07 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 v8 Reclength field in the SYSIBM.SYSTABLES [...]
800 42 38_Re: A technique for storing small LOBs10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 29 Sep 2006 13:14:18 +0200655_US-ASCII Hi Isaac<br><br>I'm in pray mode as well due to LOBs.....but until now only some space problems...<br><br>Max Scarpa<br><br>Recovering from z/OS 1.7 test (and relative bosses)<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
843 16 34_Re: Date exit DSNXVDTX and friends11_Joan Keemle25_keemlejoant@JOHNDEERE.COM31_Fri, 29 Sep 2006 07:55:02 -0500334_- We tailored the ASCII version when ASCII came along (V6?), and the Unicode version when Unicode came along in V7. We always exercise our local date routine in all data storage formats, so when a new format was added, we went looking for the exits. This is just one more thing we have on our checklist for verification testing. [...]
860 20 17_Tablespace Limits13_Lee Robertson24_lee_robertson@FSMAIL.NET31_Fri, 29 Sep 2006 07:56:38 -0500674_- UDB EEE v7.2 AIX 5.1<br><br>Hi,<br><br>Is there anyway of limiting the amount of space a user can take up in a given tablespace. The tablespace would have many users accessing it.<br><br>TIA<br><br>Lee<br><br>--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
881 54 21_Re: Tablespace Limits13_Mark Horrocks22_agentlease@HOTMAIL.COM31_Fri, 29 Sep 2006 13:31:54 +0000328_- Lee,<br><br>Identify the users using up large space and allocate a default tablespace to that user via the GRANT USE for tablespace command.<br><br>Have more than one tablespace and allocate to groups of users i.e. small,medium and large.<br><br>Then you can ensure that all users are not being affected by a rogue user. [...]
936 92 21_Re: Tablespace Limits23_Baskerville, Mark {PBG}26_Mark.Baskerville@PEPSI.COM31_Fri, 29 Sep 2006 10:11:53 -0400432_us-ascii Lee,<br><br>What we did to address a similar requirement was to define a DMS tablespace with the amount of storage we were willing to allocate to the application. This ensures that if they try to load or insert data that could potentially go beyond what we want them to use, they will simply get a "SQL0289N Unable to allocate new pages in table space 'xxx'", without bringing our production environment to its knees. [...]
1029 29 21_Re: Tablespace Limits28_=?UTF-8?B?UGhpbCBndW5uaW5n?=22_pgunning@GUNNINGTS.COM31_Fri, 29 Sep 2006 14:15:01 +0000394_- No. You could make it DMS and keep the container artificially small or use SMS and keep disk available small. Neither very good solutions. Better to write a purge. Phil Sent via BlackBerry from Cingular Wireless<br><br>-----Original Message----- From: Lee Robertson <lee_robertson@FSMAIL.NET> Date: Fri, 29 Sep 2006 07:56:38 To:DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Tablespace Limits [...]
1059 45 21_Re: Tablespace Limits23_Baskerville, Mark {PBG}26_mark.baskerville@PEPSI.COM31_Fri, 29 Sep 2006 09:21:56 -0500714_- On Fri, 29 Sep 2006 07:56:38 -0500, Lee Robertson <lee_robertson@FSMAIL.NET> wrote:<br><br>>UDB EEE v7.2 >AIX 5.1 > >Hi, > >Is there anyway of limiting the amount of space a user can take up in a >given tablespace. The tablespace would have many users accessing it. > >TIA > >Lee > >--------------------------------------------------------------------------------- >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences [...]
1105 229 44_DB2 for Z/Os Version 8 Thread Resource Usage15_Schade, Jeffrey15_JSchade@ISO.COM31_Fri, 29 Sep 2006 10:43:51 -0400593_us-ascii I have been asked to quantify the resources required for DB2 thread definitions so that we can make an informed decision on increasing the total threads supported by DB2. We currently have CTHREAD=400 and I was asked how many more threads DB2 can support. I am hoping for a formula that I could apply and come up with some rough estimate of the minimum storage and CPU overhead these additional threads would require. I know the maximums will depend on what processing is being done using the threads. I am searching all the documentation (redbooks, manuals and text books) that [...]
1335 39 47_DB2 z/OS & UDB Support Staffing question/survey10_Tom Glaser14_tg5444@SBC.COM31_Fri, 29 Sep 2006 13:07:55 -0500547_- DB2 users, I have a question I'd like to run by you on the topic of providing support for DB2. We are a large DB2 on z/OS shop; we also have DB2 in the midrange environment, with a limited number of instances.<br><br>DB2 on z/OS has always been supported out of the mainframe technology group and DB2 UDB out of the midrange group; two separate groups. We are looking at the idea of bringing DB2 UDB support into the mainframe group, making both groups into one. Most of our main-framers don't know LUW and most of our midrange folks don't [...]
1375 37 33_UDB V8 on Linux upgrade to 64 bit10_Dave Nance16_dav1mo@YAHOO.COM31_Fri, 29 Sep 2006 11:31:45 -0700404_iso-8859-1 Hi all, Thanks for any replies. We are in the midst of upgrading our DB2 systems to 64 bit and fixpack12. Was hoping someone might be willing to share some info.<br><br>1. Anything that you missed in planning and found in testing or production. 2. How large did you make bufferpools. We will have several gig(10 -12) available and are thinking about how large we should go. Thanks again. [...]
1413 64 72_Re: db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Fri, 29 Sep 2006 12:28:07 -0700505_us-ascii <br><br>Vardhini,<br><br>Put a card like this in front of your program before you run it thru the CICS preprocessor<br><br>CBL XOPTS(EXCI)<br><br>See the CICS External Interfaces Guide<br><br>Victor<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Parvathavardhini Kannan Sent: Friday, September 29, 2006 12:15 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure [...]
1478 58 37_Re: UDB V8 on Linux upgrade to 64 bit12_Martin Hubel17_Martin@MHUBEL.COM31_Fri, 29 Sep 2006 16:08:40 -0400
1537 166 51_Re: DB2 z/OS & UDB Support Staffing question/survey13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 29 Sep 2006 21:07:55 GMT383_- Tom:<br><br>I've worked at places where all DB2 support was in a single department, and I've worked at places where they were separate. In each case, the decision to have everyone together or have the groups separate was more a political decision than a technical one, influenced more by turf wars than by anything else. Usually the turf battles kept the two groups separate. [...]
1704 460 51_Re: DB2 z/OS & UDB Support Staffing question/survey9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Fri, 29 Sep 2006 16:36:36 -0500407_US-ASCII I would say this it would be best to combine the groups. Eventually the two types of systems will need to communicate with each other. For example IBM's MQ series will connect almost anything to anything. We have Oracle, and Mainframe DB2 communicating with MQ series. I have worked in Oracle for 5 years as an Oracle DBA, and 4 years as a DB2 DBA. Knowing both sides makes you more valuable. [...]
2165 45 72_Re: db2 V.7 : calling a CICS+COBOL program from a COBOL Stored procedure14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 30 Sep 2006 13:52:44 +1000528_US-ASCII You can also use the DSNCICS stored procedure (as documented in Appl Prog and SQL Guide).<br><br>James Campbell<br><br>On 29 Sep 2006 at 12:45, Parvathavardhini Kannan wrote:<br><br>> Hi all, > > When calling a CICS from a COBOL DB2 stored procedure do we need to use any > special call statements ? > Any special preparation steps (compilation parameters etc) ? > > I saw in one of the old DB2lISTSERV threads a mention that " use EXCI > interface to call CICS from SP " > > I am not sure how to do this. > > Can [...]
2211 19 48_Re: DB2 for Z/Os Version 8 Thread Resource Usage17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Sat, 30 Sep 2006 08:38:39 -0500390_- Thread level storage can vary to a great extent depending on the type of processing. For estimation purposes each concurrent active thread can be averaged to 700K and 1M for a conservative estimation.<br><br>You can format your DBM1 dump using DSNWDMP with SM=5,DS=3 and find out info such as the average, peak and what type of threads demaand more storage etc in your workload mix. [...]
2231 43 48_Re: DB2 for Z/Os Version 8 Thread Resource Usage15_Schade, Jeffrey15_JSchade@ISO.COM31_Sat, 30 Sep 2006 17:57:33 -0400529_iso-8859-1 Thankk you Venkat. This information is very helpful.<br><br>________________________________<br><br>From: DB2 Data Base Discussion List on behalf of Venkat Srinivasan Sent: Sat 9/30/2006 9:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 for Z/Os Version 8 Thread Resource Usage<br><br><br><br><br><br>Thread level storage can vary to a great extent depending on the type of processing. For estimation purposes each concurrent active thread can be averaged to 700K and 1M for a conservative estimation. [...]