1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2010, week 5
2 68 18_Re: NUMLKTS Survey10_Joe Geller21_joerg6666@HOTMAIL.COM31_Thu, 28 Jan 2010 23:06:13 +0000370_UTF-8 If you increase NUMLKTS from its default, you will likely need to also increase NUMLKUS (number of locks for the transaction), which defaults to 10,000. For example, if you set NUMLKTS to 5000 and update 3 tables with 4000 locks each, you will exceed NUMLKUS.
Joe
On Tue, 26 Jan 2010 03:36:38 -0800, Dave Nance wrote: [...]
71 242 54_Re: Mathematician wanted - number of potential indexes10_Joe Geller21_joerg6666@HOTMAIL.COM31_Thu, 28 Jan 2010 23:04:29 +0000346_UTF-8 It's fairly easy to calculate. If you have n columns, then if you have m columns in the index, the number of permutations is n!/(n-m)!. Therefore the total number of index possibilities is the sum of m=1 to n of n!/(n-m)!
So, for n=4 you would have
4!/3! + 4!/2! + 4!/1! + 4!/0! 24/6 + 24/2 + 24/1 + 24/1 4+12+24+24 = 64 [...]
314 92 45_What is wrong with this db2 delete using rexx0_16_DBMSUser@AOL.COM29_Fri, 29 Jan 2010 00:44:09 EST380_US-ASCII Hello all,
I can not seams to find anything wrong with this delete statement, yet I get -104 I am using rexx.
>>> "EXECSQL DELETE FROM ABC.ABCDEFGROUP WHERE DB2ID = 'DB9G', AND GGROUP = 'GROUP1'" +++ RC(-1) +++
323 *-* /**/ 324 *-* /**/ 325 *-* /**/ 326 *-* ADDRESS TSO
327 *-* SAY 'SQLCODE = 'SQLCODE >>> "SQLCODE = -104" SQLCODE = -104 [...]
407 56 49_Re: What is wrong with this db2 delete using rexx15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Fri, 29 Jan 2010 09:09:42 +0200372_us-ascii On Fri, 29 Jan 2010 00:44:09 EST DBMSUser@AOL.COM wrote:
:> I can not seams to find anything wrong with this delete statement, yet I :>get -104 :>I am using rexx.
:>>>> "EXECSQL DELETE FROM ABC.ABCDEFGROUP WHERE DB2ID = 'DB9G', AND :>GGROUP = 'GROUP1'" :>+++ RC(-1) +++
:>323 *-* /**/ :>324 *-* /**/ :>325 *-* /**/ :>326 *-* ADDRESS TSO [...]
464 356 49_Re: What is wrong with this db2 delete using rexx14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Fri, 29 Jan 2010 10:04:17 +0200503_us-ascii I see a coma before AND. If that's written in your Rexx that's the error
________________________________
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DBMSUser@AOL.COM Sent: Friday, January 29, 2010 7:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] What is wrong with this db2 delete using rexx
Hello all,
I can not seams to find anything wrong with this delete statement, yet I get -104 [...]
821 176 46_Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jan 2010 09:30:49 +0100606_ISO-8859-1 Hi!
I have this little SQL
--DROP TABLE BOXWELL.BADTAB ; --COMMIT ; CREATE TABLE BOXWELL.BADTAB (COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL ,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL ,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL ,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL ,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL ,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL ,COLD CHAR(8) NOT NULL ,COLE CHAR(8) NOT NULL ,COLF CHAR(8) NOT NULL ,COLG CHAR(8) NOT NULL) ; COMMIT ; SELECT COUNT(*) FROM BOXWELL.BADTAB WHERE COL1 NOT LIKE '&%' OR COL2 NOT LIKE '&%' OR COL3 NOT LIKE [...]
998 84 49_Re: What is wrong with this db2 delete using rexx13_Mick P Graley16_mgraley2@CSC.COM31_Fri, 29 Jan 2010 08:48:57 +0000287_US-ASCII I'm guessing the comma before AND is for REXX continuation onto a new line as this statement doesn't fit into 72 columns. I would add a double quote (") before the comma and another one before the AND on the next line. This is the correct way to continue a string in REXX. [...]
1083 304 23_Group Buffer Pools Size12_Jose Antonio17_jamorcillo@CAM.ES31_Fri, 29 Jan 2010 09:59:42 +0100820_iso-8859-1 Hi!
We are going to increase Group Buffer Pools size from 75Mb to 150Mb each. I think it is not a very big size. In your experience
which sizes are you having in your installations??
Thanks a lot!!!!
__________________________ José A Morcillo Valenciano Tfno.: +34 965 90 51 43 747-Producción Informática
__________________________
Este correo electrónico es confidencial. Si lo ha recibido por error, por favor contacte con el remitente y destruya su contenido. Toda la información relativa a la Protección de Datos de Carácter Personal, se encuentra a su disposición en la página web www.cam.es , en el apartado [...]
1388 128 49_Re: What is wrong with this db2 delete using rexx11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jan 2010 10:13:24 +0100381_ISO-8859-1 Continue your REXX like this
Command ===> 000176 aa = Left(dsname,Length(dsname)-4) ; 000177 dsmtst = aa!!".G%" ; 000178 ADDRESS EXECSQL "DECLARE C1 CURSOR FOR ", 000179 "SELECT DBNAME, TSNAME, DSNAME ", 000180 "FROM SYSIBM.SYSCOPY ", 000181 "WHERE DSNAME LIKE '"dsmtst"'", 000182 "ORDER BY DSNAME" ; 000183 000184 sql_RC = Check_sqlcode("DECLARE CURSOR") ; [...]
1517 438 27_SV: Group Buffer Pools Size13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Fri, 29 Jan 2010 12:44:51 +0100385_iso-8859-1 In a 4-way DS-system we have the following configuration for the largest pools:
Each BP2 is 200,000 buffers. GBP2 is 1GB Each BP3 is 300,000 buffers. GBP3 is 3GB
The workload is equal balanced by WLM over the 4 systems, there are no affinities . The size of your GBP's is very dependent on the amount of updates in the systems and the workload balancing. [...]
1956 242 49_Re: What is wrong with this db2 delete using rexx15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Fri, 29 Jan 2010 08:22:59 -0500385_us-ascii When continuing lines in REXX you need to have all of the statement within the double quotes followed by a comma and
the next line needs to start with double quotes, the remainder of the REXX line ending in double quotes
For your line
"EXECSQL DELETE FROM ABC.ABCDEFGROUP WHERE DB2ID = 'DB9G', AND GGROUP = 'GROUP1' " [...]
2199 155 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE10_Todd Burch17_toddburch@MAC.COM31_Fri, 29 Jan 2010 07:59:35 -0600645_US-ASCII What module? What offset? Can you post the full dump title?
(Or, just open a PMR!)
Thanks, Todd DB2 Level 2
On Jan 29, 2010, at 2:30 AM, Roy Boxwell wrote:
Hi!
I have this little SQL
--DROP TABLE BOXWELL.BADTAB ; --COMMIT ; CREATE TABLE BOXWELL.BADTAB (COL1 CHAR(8) NOT NULL ,COL2 CHAR(8) NOT NULL ,COL3 CHAR(8) NOT NULL ,COL4 CHAR(8) NOT NULL ,COL5 CHAR(8) NOT NULL ,COL6 CHAR(8) NOT NULL ,COL7 CHAR(8) NOT NULL ,COL8 CHAR(8) NOT NULL ,COL9 CHAR(8) NOT NULL ,COLA CHAR(8) NOT NULL ,COLB CHAR(8) NOT NULL ,COLC CHAR(8) NOT NULL ,COLD CHAR(8) NOT NULL ,COLE CHAR(8) [...]
2355 60 49_Re: What is wrong with this db2 delete using rexx9_Don Leahy19_don.leahy@LEACOM.CA31_Fri, 29 Jan 2010 09:20:13 -0500321_ISO-8859-1 If you are using the ISPF Editor, the HILITE REXX command can be a big help.
The comma, when used for continuation, should show up green. If if is white, then Rexx is interpreting it as part of your quoted literal.
I use this all the time to help me keep my quotes and apostrophes in order. [...]
2416 353 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE11_Roy Boxwell16_R.Boxwell@SEG.DE31_Fri, 29 Jan 2010 15:49:02 +0100410_ISO-8859-1 sadly as a"partner developer" I cannot open a pmr for DB2 V9 - It does not dump it just does this online SPUFI
Abend 0C4000 hex occurred processing command 'DSN '. ***
and in batch when the module is bound
IKJ56641I DSN ENDED DUE TO ERROR+ IKJ56641I SYSTEM ABEND CODE 0C4 REASON CODE 00000038 PSW 077C00018EFE5F9E ASIDS: HOME = 002F PRIMARY = 0062 SECONDARY = 0062 [...]
2770 32 54_Re: Mathematician wanted - number of potential indexes15_Patrick Bossman25_patrick.bossman@GMAIL.COM31_Fri, 29 Jan 2010 15:06:19 +0000830_UTF-8 You could create both NPI vs DPSI. RANDOM / NOT RANDOM UNIQUE, UNIQUE WHERE NOT NULL, non-unique.
You can only have 64 columns in an index. The length of indexed columns is also limited. http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.ugref/db2z_limits.htm
Regards, Pat
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.IDUG.org membership is now free. Do you have people in your office who are not an IDUG member? Show them how to access the information and help train the next generation of DB2 Users! _____________________________________________________________________ [...]
2803 241 54_Re: Mathematician wanted - number of potential indexes10_Joe Geller21_joerg6666@HOTMAIL.COM31_Fri, 29 Jan 2010 15:25:36 +0000326_utf-8 And, the SQL to get the answer is:
with nx (nxc,n) as (select 1, 2 from sysibm.sysdummy1 union all select n * nxc + n, n+1 from nx where n <= 12) select n-1, nxc from nx;
Note that while an index can have 64 columns, I only generate the answers up to 12, because of overflow on the integer data type. [...]
3045 475 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE13_David Simpson22_dsimpson@THEMISINC.COM31_Fri, 29 Jan 2010 10:44:15 -0500638_iso-8859-1 This works fine on my V9 system in SPUFI... no errors.
______________________________________________________________________________ David Simpson | Senior Technical Advisor | Themis Education 123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
For more information about Themis, visit www.themisinc.com
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Boxwell Sent: Friday, January 29, 2010 2:31 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE [...]
3521 63 47_Final Week to register for z/OS On line classes16_Angelo Corridori27_Angelo.Corridori@MARIST.EDU31_Fri, 29 Jan 2010 10:46:54 -0500543_UTF-8 Hello everyone,
This is the final week to register for z/OS On Line classes at the Marist Institute for Data Center Professionals. Spring classes include: • z/OS Associate Certificate Program (Systems Programming Track) • DB2 Application Programming Track- Discounted Introductory Pricing Available! • Assembler Language Application Programming Track- Discounted Introductory Pricing Available! • AIX on Power Certificate Program-Discounted Introductory Pricing Available! • Various Data Center Operations Programs [...]
3585 631 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK31_Fri, 29 Jan 2010 16:00:01 +0000413_iso-8859-1
Roy
have you tried running an EREP report to see if anything was written to LOGREC?
Date: Fri, 29 Jan 2010 15:49:02 +0100 From: R.Boxwell@SEG.DE Subject: Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE To: DB2-L@WWW.IDUGDB2-L.ORG
sadly as a"partner developer" I cannot open a pmr for DB2 V9 - It does not dump it just does this online SPUFI [...]
4217 256 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE12_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM31_Fri, 29 Jan 2010 11:01:43 -0500467_UTF-8 Just a stab in the dark but is it going parallel ? Jeff
David Simpson Sent by: IDUG DB2-L 01/29/2010 10:46 AM Please respond to IDUG DB2-L
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
This works fine on my V9 system in SPUFI… no errors. [...]
4474 234 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE14_Bruce Lightsey25_Bruce.Lightsey@ITS.MS.GOV31_Fri, 29 Jan 2010 10:13:41 -0600430_ISO-8859-1 Last time I had this, the region for my TSO session was too small - changed it to 8M and have not repeated that particular error since ( lots of others but, not that particular one )
Roy Boxwell To Sent by: IDUG DB2-L@WWW.IDUGDB2-L.ORG DB2-L cc Subject Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE 01/29/2010 08:49 AM [...]
4709 678 50_Re: Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE13_Phil Grainger34_phil@GRAINGERDATABASESOLUTIONS.COM31_Fri, 29 Jan 2010 16:13:14 -0000428_iso-8859-1 Sorry Roy, but it works fine for me too…..
Phil Grainger
Grainger Database Solutions Ltd
_____
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson Sent: 29 January 2010 15:44 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Abend S0C4 in DB2 z/OS V9 with OR and NOT LIKE
This works fine on my V9 system in SPUFI… no errors. [...]
5388 384 62_AW: [DB2-L] Mathematician wanted - number of potential indexes12_PUSCH Othmar27_Othmar.Pusch@IT-AUSTRIA.COM31_Fri, 29 Jan 2010 17:23:18 +0100386_utf-8 Hi Phil, dear out there !
From my point of view ya get the MAXIMUM number of candidate indexes (Ignoring the ascending/descending choice) by means of a “variation_without_retry†(= a permutation of all elements of all combinations of a given class) … the simple formula:
∑ nPk = ∑ (n! / (n-k)!) … for k = 1 and k_has_to_run_till_n …. n ε N / (0) [...]
5773 403 27_Re: Group Buffer Pools Size35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 29 Jan 2010 11:30:51 -0500538_iso-8859-1 Jose,
Are you having performance problems with your GBP's? That's the only reason to make them bigger, if size alone is the issue.
They are ways to calculate the required size of theGBP's instead of guessing, and just doubling them.
Regards, Joel
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com [...]
6177 112 68_Final Week to Register for DB2 On Line classes at Introductory Price16_Angelo Corridori27_Angelo.Corridori@MARIST.EDU31_Sat, 30 Jan 2010 10:15:31 -0500614_ISO-8859-1 Hello everyone, I'm resending this as the first post did not display correctly.....
This is the final week to register for DB2 and z/OS On Line classes at the Marist Institute for Data Center Professionals. Spring classes include: ? z/OS Associate Certificate Program (Systems Programming Track) ? DB2 Application Programming Track- Discounted Introductory Pricing Available! ? Assembler Language Application Programming Track- Discounted Introductory Pricing Available! ? AIX on Power Certificate Program-Discounted Introductory Pricing Available! ? Various Data Center Operations Programs [...]
6290 530 23_ADMIN reports of issues16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Sat, 30 Jan 2010 18:59:20 -0500439_utf-8 I have been receiving reports that some people have not been receiving posts from the listserv for a couple of weeks
1) If you or someone you know are having issues like this, please report it to the following address listadmin@idug.org. This email is to be used ONLY for reporting issues of non accessibility of the listserv (when you think it is down). All other requests to this email will be ignored. [...]
6821 706 27_Re: ADMIN reports of issues12_Phil Gunning19_pkgunning@GMAIL.COM31_Sun, 31 Jan 2010 01:09:12 -0500466_utf-8 Recommend you also point subscribers to the FAQ, that should answer most of these type of questions. Phil
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert Sent: Saturday, January 30, 2010 6:59 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] ADMIN reports of issues
I have been receiving reports that some people have not been receiving posts from the listserv for a couple of weeks [...]
7528 579 27_Re: ADMIN reports of issues23_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM31_Sun, 31 Jan 2010 00:41:08 -0600595_windows-1252 If there is a FAQ, recommend link to it be part of the footer of for all DB2-L messages. I manage other lists, and that is where I keep essential links.
On Sun, Jan 31, 2010 at 00:09, Phil Gunning wrote:
> Recommend you also point subscribers to the FAQ, that should answer most > of these type of questions. Phil > > > > *From:* IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] *On Behalf Of *Galambos, > Robert > *Sent:* Saturday, January 30, 2010 6:59 PM > *To:* DB2-L@WWW.IDUGDB2-L.ORG > *Subject:* [DB2-L] ADMIN reports of issues > > > > I have [...]