1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2006, week 3
2 145 13_Re: uploading13_Mertens, Bart18_bart.mertens@CZ.NL31_Thu, 15 Jun 2006 13:18:17 +0200487_us-ascii Jerome,
You can use the db2 cross loader.
Regards, Bart Mertens
________________________________
Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens jerome vinoth Verzonden: donderdag 15 juni 2006 7:05 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] uploading
We have certain tables in the DB2 UDB 8.1 on Windows. We need to upload these data into DB2 UDB 8.1 on Z/OS. Is there any easy ways available? Thanks, [...]
148 424 13_Re: uploading55_=?iso-8859-9?Q?Kadir_G=FCray_Meri=E7_=28B.T.S.Y.G.=29?=22_Kadir.Meric@AKBANK.COM31_Thu, 15 Jun 2006 14:59:19 +0300496_iso-8859-9 Hi,
the easiest method to do this is to use MS ACCESS.
In MS Access open tables part. Right click, choose import, then chose the ODBC drivers for DB2 for ZOS and DB2 UDB 8.1 and go on importing.
regards,
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mertens, Bart Sent: Thursday, June 15, 2006 2:18 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] uploading [...]
573 208 13_Re: uploading55_=?iso-8859-9?Q?Kadir_G=FCray_Meri=E7_=28B.T.S.Y.G.=29?=22_Kadir.Meric@AKBANK.COM31_Thu, 15 Jun 2006 15:05:32 +0300313_iso-8859-9 Hi, in Ms Access, instead of "choose import", I must say "link tables" .
Use link tables feature, then copy all the rows you want to copy from one table, then paste them to the other linked table.
You can also load your data by a third party tool, like "Advanced Query Tool", etc... [...]
782 69 13_Re: uploading17_Gugel, Rich - DOA24_Rich.Gugel@WISCONSIN.GOV31_Thu, 15 Jun 2006 07:26:26 -0500348_us-ascii I'd agree with Bart, Cross loader is what I'd look at first. Version 8 also supports loading delimited files, that would be worth a peek as well. Delimited files would involve a few more steps: unload, ftp, load Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer [...]
852 18 22_Re: IDENTITY_VAL_LOCAL10_Bill Brown21_db2_dba@BELLSOUTH.NET31_Thu, 15 Jun 2006 07:54:11 -0500774_- if you are on v8 you can use the FROM FINAL TABLE option. for example:
SELECT EMPNO INTO :EMPNO_VAL FROM FINAL TABLE (INSERT INTO TABLE1 (NAME,SALARY,LEVEL) VALUES('NEW EMP','25000.00,'ASSOCIATE')
the column EMPNO is the identity column and will be placed in the host variable :EMPNO_VAL
--------------------------------------------------------------------------------- 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
871 40 69_Request for examples of COBOL/DB2 programs calling a Java application12_George Palko16_gpalko@OPERS.ORG31_Thu, 15 Jun 2006 08:33:18 -0500364_- Hello List,
We have a need to call a Java application from a COBOL/DB2 application. We have not had much success at getting it to work.
Although, we were successful calling a Java application via a COBOL program that did not contain DB2.
My question would be- is there in special JCL considerations that we are not taking into account? [...]
912 66 13_Re: SQL ERROR10_Grace Chen20_grace.chen@CELERO.CA31_Thu, 15 Jun 2006 07:53:17 -0600365_us-ascii Hi James,
This is happening on the job that defines lots of tables, indexes and views. If you define 50 tables, it might have 10 errors and then the job terminate. It didn't terminate on the first error or finish all DDL no matter how many errors it encountered. It seems that there is a limit on the number of errors before the job terminate. [...]
979 103 13_Re: SQL ERROR12_Levine, Mike29_Mike.Levine@DMS.MYFLORIDA.COM31_Thu, 15 Jun 2006 10:19:39 -0400462_us-ascii Hi Grace,
You may be using DSNTEP2 sample dynamic SQL program. The program has a default of ten errors before terminating. You can modify the source to have a higher limit or use a different dynamic SQL program. I'm not sure if the default can be overridden.
Regards, Mike
Michael Levine - Database Administration Department of Management Services Enterprise Information Technology Services Mainframe Platform Services [...]
1083 42 22_Re: IDENTITY_VAL_LOCAL14_Ramon Santiago28_ramon_santiago@SBCGLOBAL.NET31_Thu, 15 Jun 2006 07:31:35 -0700813_iso-8859-1 Thanks...this works great..
Bill Brown wrote: if you are on v8 you can use the FROM FINAL TABLE option. for example:
SELECT EMPNO INTO :EMPNO_VAL FROM FINAL TABLE (INSERT INTO TABLE1 (NAME,SALARY,LEVEL) VALUES('NEW EMP','25000.00,'ASSOCIATE')
the column EMPNO is the identity column and will be placed in the host variable :EMPNO_VAL
--------------------------------------------------------------------------------- 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 [...]
1126 131 13_Re: SQL ERROR10_Grace Chen20_grace.chen@CELERO.CA31_Thu, 15 Jun 2006 08:50:03 -0600362_us-ascii Hi Make, You are right, we do use DSNTEP2 sample dynamic SQL program. I'll check if I can override the default. Thanks! Grace
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Levine, Mike Sent: Thursday, June 15, 2006 8:20 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] SQL ERROR [...]
1258 144 30_CDUG July 20th - DB2 Education54_Crane, Rob --- Manager Database Administration --- CFS27_rob.crane@FREIGHT.FEDEX.COM31_Thu, 15 Jun 2006 09:46:25 -0600411_us-ascii Calling all SQL Enthusiasts in the Mountain West
The Colorado DB2 Regional User Group for z/OS has a great event lined up for Thursday July 20th in Denver. We have lined up three outstanding presenters for this free day of DB2 education centered on SQL and applications.
The morning will start with Sheryl Larsen delivering her "Top Application Impacts on Performance" presentation. [...]
1403 66 33_Re: Critical steps to monitor DB212_Phil Gunning22_pgunning@GUNNINGTS.COM31_Thu, 15 Jun 2006 12:50:39 -0400568_us-ascii First things are make sure you are backing up your data and that you can recover it...(image copies, logs, subsystem). These are key. Phil
www.gunningts.com/db2zone.htm 610.451.5801 Fax 636.216.8192 Visit us at IDUG Europe, Vienna, Austria 2-6 Oct 2006 and IBM Information on Demand, Oct 15-20, Anaheim, Ca DB2 UDB Handbook DB2 UDB ESE non-DPF High Performance Design for OLTP and BI ITgain:http://www.itgain.de AIM: db2luw Get DB2 Viper Info at: http://www-306.ibm.com/software/data/db2/udb/viper/ [...]
1470 39 29_PCTFREE and FREEPAGE for NPIs15_Barbara Jo Nigh26_barbara.j.nigh@US.HSBC.COM31_Thu, 15 Jun 2006 10:59:35 -0700294_US-ASCII Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the data in a partition is replaced each time it is loaded?
Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the data in a partition is loaded using a LOAD RESUME YES SHRLEVEL CHANGE? [...]
1510 59 33_Re: PCTFREE and FREEPAGE for NPIs47_Luis Miguel Marti=?ISO-8859-1?Q?=ADnez?= Chavez20_luismmch66@YAHOO.COM31_Thu, 15 Jun 2006 13:25:37 -0500620_- On Thu, 15 Jun 2006 10:59:35 -0700, Barbara Jo Nigh wrote:
>Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the >data in a partition is replaced each time it is loaded? > >Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the >data in a partition is loaded using a LOAD RESUME YES SHRLEVEL CHANGE? > >Index REORGS on the NPIs are executed on a regular basis (weekly). > >Barbara J. Nigh - CAL261 >Consultant, Database Management Systems - North America >Phone: 831.754.1400 Ext. 2048 >Pager: 877.406.7868 >barbara.j.nigh@us.hsbc.com > > [...]
1570 40 19_Bufferpool Question14_Richard Atkins16_rratkp@YAHOO.COM31_Thu, 15 Jun 2006 11:48:14 -0700313_iso-8859-1 Dear Listers,
Any pointers on how to make a program use the bufferpool that has a lot of Synch I/O and Asynch I/O and almost zero bufferpool usage (without redesigning the program). What else I should look for?
The EXPLAIN stats look great on the SQL and so does the getpage counts. [...]
1611 329 13_Re: uploading11_Arun Thilak20_arunthilak@GMAIL.COM31_Fri, 16 Jun 2006 00:28:16 +0530457_us-ascii Hai,
I have once tried cross platform replication using only db2look and db2move. will this cross loader do both the steps automatically (i.e. generate DDL and move data) ?
Regards, Arun Thilak
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA Sent: Thursday, June 15, 2006 5:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] uploading [...]
1941 34 20_Drop trigger failure11_Lori Bewley19_lori.bewley@YUM.COM31_Thu, 15 Jun 2006 13:58:00 -0500350_- I had a situation this morning that I need help figuring out. A distributed thread was failing with an 00E30305 on a trigger, indicating that the trigger package was not operational. It turns out that one of our DBAs made one attempt to drop this trigger yesterday but received an 00E70081 (object referenced by a statement in the dyn cache). [...]
1976 92 33_Re: PCTFREE and FREEPAGE for NPIs47_Luis Miguel Marti=?ISO-8859-1?Q?=ADnez?= Chavez20_luismmch66@YAHOO.COM31_Thu, 15 Jun 2006 14:37:49 -0500620_- On Thu, 15 Jun 2006 10:59:35 -0700, Barbara Jo Nigh wrote:
>Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the >data in a partition is replaced each time it is loaded? > >Does anyone know how to determine PCTFREE and FREEPAGE for an NPI if the >data in a partition is loaded using a LOAD RESUME YES SHRLEVEL CHANGE? > >Index REORGS on the NPIs are executed on a regular basis (weekly). > >Barbara J. Nigh - CAL261 >Consultant, Database Management Systems - North America >Phone: 831.754.1400 Ext. 2048 >Pager: 877.406.7868 >barbara.j.nigh@us.hsbc.com > > [...]
2069 80 33_Re: Critical steps to monitor DB29_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 15 Jun 2006 15:12:27 -0500557_us-ascii Sysprog considerations - Single biggest issue - migration to new DB2 version - more work and testing that any other single activity. other items are
1. SMP maintenance - includes looking at all the holddata for stuff that has to be rebound. usually every 3-6 months - and yes there are places that do it every couple of years - usually just before they get ready to try to upgrade to the next release. 2. bufferpool settings - if you have enough memory to just make them big, check every couple of months. make sure you have at least 4 [...]
2150 179 23_Re: Bufferpool Question35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 15 Jun 2006 16:08:59 -0400321_iso-8859-1 Richard,
Bufferpool usage, in your case is determined by object placement. You will use whatever pool(s) the objects are assigned to.
There isn't any way you can tell if a buffer pool is large enough from an explain, but I don't know if that's where you were trying to get your information. [...]
2330 284 31_DBM1 Storage - negative number?10_Brian Bear23_Brian.Bear@CHARMING.COM31_Thu, 15 Jun 2006 17:35:56 -0400595_US-ASCII Something odd. Using BMC's Mainview, I am looking at the DBM1's storage usage for each of my sub-systems. The one subsystem shows a negative amount available?
Any ideas why?
15JUN2006 17:26:55------ MAINVIEW WINDOW INTERFACE (V4.2.02) COMMAND ===> S CURR WIN===>1 ALT WIN===> >W1 =DB2STOR==========(ALL======*=======)15JUN2006==17:26:55=== DB2 Available Total DBM1 Total Storage Target < 2GB In Use Storage Cushion DSNA -165.75 992.34 826.59 104.35 DSNY 1613.40 104.49 1717.89 100.68 DSNZ 1285.85 268.18 1554.04 106.16 [...]
2615 129 33_Re: Critical steps to monitor DB29_Ford Wong14_fordie@SHAW.CA31_Thu, 15 Jun 2006 16:00:00 -0600609_us-ascii Further,
1. Monitor your the underlying VSAM datasets used for DIRECTORY/CATALOG tablespaces/indexspaces to ensure that they never run out of space. The last thing you want is to have your catalog become unavailable due to space.
2. If you have time, reorg the CATALOG/DIRECTORY as needed to improve performance. When I was a SYSPROC, I used to REORG twice a year (well, at least once), whether it needed it or not. On occasion, also run a health CHECK agaist the DB2 Catalog/Directory (eg run PGM=DSN1COPY,PARM=(CHECK)and PGM=DSN1CHKR against the CATALOG/DIRECTRY datasets, etc). [...]
2745 361 44_Re: DBM1 Storage - negative number? - Update10_Brian Bear23_Brian.Bear@CHARMING.COM31_Thu, 15 Jun 2006 18:24:14 -0400565_US-ASCII It seems my DSNA subsystem is only GETMAINing 870mb of storage instead of the full 1.6gb.
The other two subsytems GETMAIN over 1.5gb.
Any thoughts on what could be limiting the DSNA subsystem from GETMAIN of the full 1.6gb?
Brian Bear Charming Shoppes.
Brian Bear/Charm 06/15/2006 05:35 PM
To DB2 Database Discussion list at IDUG cc DB2 Data Base Discussion List , DB2-L@WWW.IDUGDB2-L.ORG Subject DBM1 Storage - negative number? [...]
3107 78 31_Tablespace definition DEFINE NO7_J Anand34_AnandJayachandran@FREIGHTLINER.COM31_Thu, 15 Jun 2006 15:35:38 -0700378_us-ascii Dear Listers,
There are some tablespaces with DEFINE NO, the VSAM dataset will be created only when any records are inserted into it.
Of late we are facing situations during data migration from one subsystem to another. The target TS are left in check pending, when we do execute a check on the TS, the check fails indicating VSAM dataset not found. [...]
3186 172 44_Re: DBM1 Storage - negative number? - Update9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 15 Jun 2006 17:36:37 -0500335_US-ASCII The getmain size is dependent on multiple things, the biggest one is buffer pool specifications. If you don't define them, DB2 doesn't allocate them.
I can't remember who does the presentation at IDUG on DB2 memory utilization. It is in the archives multiple times because other people have memory just like mine. [...]
3359 53 24_Re: Drop trigger failure11_Lori Bewley19_lori.bewley@YUM.COM31_Thu, 15 Jun 2006 17:35:03 -0500419_- I found the cause of this problem. It was not related to the attempted drop of the trigger, it was caused by a revoke of SYSADM from the original trigger creator. Using much appreciated advice from Ken McDonald of BMC, I looked for other log records with the same URID as the SYSPACKAGE update log record and found that it was part of a SYSADM revoke which the revoker then admitted to doing. Thanks again Ken!! [...]
3413 58 33_Re: Critical steps to monitor DB219_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Thu, 15 Jun 2006 18:36:50 -0500617_us-ascii Just a few other tidbits: - monitor the EDMPOOL usage (the smaller the EDM pool, the more critical monitoring becomes). - monitor the storage usage for DBM1. - monitor paging (you want low or zero paging for Bufferpools); a high paging rate implies over commitment of real storage (maybe by DB2 and/or some other subsystem and/or started task). - monitor how often datasets are physically being opened (and/or closed). It may be the zparm needs to be changed to keep more datasets open to prevent dataset thrashing (although keeping more files open may also have storage and checkpoint implications). - [...]
3472 73 13_Re: uploading47_Luis Miguel Marti=?ISO-8859-1?Q?=ADnez?= Chavez20_luismmch66@YAHOO.COM31_Thu, 15 Jun 2006 20:29:22 -0500482_ISO-8859-1 Here is a link where I explained the major tools for this activitie:
http://www.idugdb2-l.org/adminscripts/wa.exe?A2=ind0605B&L=DB2- L&P=R9406&D=0&I=-3&T=0&X=14175A157BEC64B6DD&Y=luismmch66%40yahoo.com :
Tom if you move a lot of ddl/table here is some of the tools information:
ZOS:
* Unload * Load * Cross Loader * Import * Export
LUW:
* Export * Import * Load * Cross Loader * db2move * db2look * Restore Redirect [...]
3546 144 73_Re: Request for examples of COBOL/DB2 programs calling a Java application14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 16 Jun 2006 11:54:36 +1000285_US-ASCII Hmm, no, never done it, but as DB2 zOS Java seems designed to only work from a USS environment, I think it will become very messy. At a minimum, I think you'll find the COBOL and Java code will execute in different threads - which could lead to "interesting" situations. [...]
3691 46 33_Re: PCTFREE and FREEPAGE for NPIs14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Thu, 15 Jun 2006 21:58:57 -0700565_us-ascii Barbara, I think you'll have to give us more information. Is it a single partition you are trying to replace, or many parts [perhaps in parallel]? Assuming you are V7, is the NPI in a totally different order or is it in partial partitioning sequence [part-key + more columns]. What cardinality: Is it a huge table [100 million rows +] or a just a big table? Then how many partitions, or what percent of the table is in each part? In what order are you replacing table rows: in part-key sequence [sorted]? in NPI key sequence? in random sequence? What [...]
3738 104 33_Re: PCTFREE and FREEPAGE for NPIs15_Barbara Jo Nigh26_barbara.j.nigh@US.HSBC.COM31_Thu, 15 Jun 2006 19:04:18 -0700505_US-ASCII Yes, it is a single partition that we are replacing. The NPI is in a totally different order than the partitioning index.
Barbara J. Nigh - CAL261 Consultant, Database Management Systems - North America Phone: 831.754.1400 Ext. 2048 Pager: 877.406.7868 barbara.j.nigh@us.hsbc.com
Larry Kintisch To: DB2-L@www.idugdb2-l.org Sent by: DB2 Data cc: Base Discussion List Subject: Re: [DB2-L] PCTFREE and FREEPAGE for NPIs [...]
3843 34 52_Manfred MOSSBAUER ist au=?ISO-8859-1?Q?=DFer?= Haus.17_Manfred MOSSBAUER16_mossbauer@GRZ.AT31_Fri, 16 Jun 2006 05:14:07 +0200558_ISO-8859-1 Ich werde ab 15.06.2006 nicht im Büro sein. Ich kehre zurück am 19.06.2006.
Die Rückmeldung bezieht sich auf ein Mail mit folgendem Thema: Re: [DB2-L] PCTFREE and FREEPAGE for NPIs
____________________________________________________________________________________________ Gesendet (c) GRZ/RACON Linz 2001 Agent 'Abwesenheit'
Der Austausch von Nachrichten mit o.a. Absender via e-mail dient ausschließlich Informationszwecken. Rechtsgeschäftliche Erklärungen dürfen über dieses Medium nicht ausgetauscht werden. [...]
3878 34 52_Manfred MOSSBAUER ist au=?ISO-8859-1?Q?=DFer?= Haus.17_Manfred MOSSBAUER16_mossbauer@GRZ.AT31_Fri, 16 Jun 2006 05:45:39 +0200556_ISO-8859-1 Ich werde ab 15.06.2006 nicht im Büro sein. Ich kehre zurück am 19.06.2006.
Die Rückmeldung bezieht sich auf ein Mail mit folgendem Thema: [DB2-L] DBM1 Storage - negative number?
____________________________________________________________________________________________ Gesendet (c) GRZ/RACON Linz 2001 Agent 'Abwesenheit'
Der Austausch von Nachrichten mit o.a. Absender via e-mail dient ausschließlich Informationszwecken. Rechtsgeschäftliche Erklärungen dürfen über dieses Medium nicht ausgetauscht werden. [...]
3913 147 35_Re: Tablespace definition DEFINE NO13_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 16 Jun 2006 10:38:39 +0200362_US-ASCII INSERT INTO creator.table VALUES (some values); ROLLBACK;
DEFINE YES/NO is not an attribute of the TS, it is just a way it is created, so you can't directly change it. Thus there is also no way to re-undefine an empty TS by e.g. running REORG, you'd have to DROP/CREATE. If CHECK DATA doesn't properly deal with undefinded TSs, it is a bug. [...]
4061 213 33_Re: Critical steps to monitor DB213_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 16 Jun 2006 10:53:42 +0200640_US-ASCII Oh my goodness. Now I've been administering up to a dozen DB2 subsystems (now quickly dropping to 0) without ever spending much time on most of these things. How did I manage, I wonder... Many issues are of the set-once, then-forget type. E.g. PCLOSET=35, PCLOSEN=32767, CHKFREQ=15, VDWQT(0)...
The one thing which I'd consider critical is to ensure that you've got backups of all TSs (TS-partitions) to allow a to-current recovery without applying too many logs. That is already quite an interesting challenge if you want to be more sophisticated than "full ICs of everything weekly, incrementals daily" (the Unix way [...]
4275 49 33_Re: PCTFREE and FREEPAGE for NPIs19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Fri, 16 Jun 2006 07:41:20 -0400420_us-ascii If you are reorging your NPIs every week, then I don't see much value in spending time determining pctfree and freepage.
Larry Jardine Production DBA
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Barbara Jo Nigh Sent: Thursday, June 15, 2006 2:00 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] PCTFREE and FREEPAGE for NPIs [...]
4325 197 33_Re: Critical steps to monitor DB20_25_LL581@DAIMLERCHRYSLER.COM31_Fri, 16 Jun 2006 08:31:49 -0400743_US-ASCII Blake,
I have a different outlook than many responders to this thread (I guess).
I see it this way: Your primary responsibility is DB2 System Recoverability (a major part of "stability" as you put it). To accomplish this you must confirm that all DB2 "system things" are recoverable. This includes:
o The Catalog and Directory datasets; o The Bootstrap Dataset(s), Active Logs, (potentially) the Archive Logs; o All datasets with DB2 executables (.SDSNLOAD, .SDSNLOD2, .SDSNLINK,.SDXRRESL,.SDSNEXIT, and so forth); o Any runtime libraries required by production processes (.SRCLIB.DATA, .RUNLIB.LOAD, etc.); o Any security or other exits, and anything your shop customized [...]
4523 70 24_Re: Drop trigger failure14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Jun 2006 15:00:21 +0100395_us-ascii I think I would talk to IBM - this sounds backwards to me
Unless the statement in the cache was actually IN USE when the DROP was attempted, I'd expect a DROP TRIGGER to invalidate the statement not the other way around !
Phil Grainger CA Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
4594 77 17_DSN1LOGP question6_larsen19_billarsen@YAHOO.COM31_Fri, 16 Jun 2006 07:50:31 -0700431_iso-8859-1 Dear all,
Something strange , please advice .
1/ Report recovery on a tablepsace to have the log point where there is something
DSNU583I DB01 DSNUPPLR - SYSLGRNX ROWS FROM REPORT RECOVERY FOR TABLESPACE GC UCDATE UCTIME START RBA STOP RBA START LRSN STOP LRSN 061406 03115953 0F645105D504 0F645105D504
2/Then with the given RBA , i use DSN1LOGP to display what the log records : [...]
4672 250 21_Re: DSN1LOGP question13_Michael Ebert18_mebert@AMADEUS.COM31_Fri, 16 Jun 2006 17:40:36 +0200498_US-ASCII Note that STARTRBA=STOPRBA. This is a LEVELID check caused by a utility. Check SYSCOPY what utility was running at the time.
Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
larsen Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 16-06-06 16:50 [...]
4923 123 21_Re: DSN1LOGP question9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 16 Jun 2006 10:59:16 -0500310_iso-8859-1 Summary basically requests restart information - Ie work in flight at a checkpoint and what has not been externalized - ie what has to be reapplied from the log. You may not have had a checkpoint during your log range. If you retry with dataonly(yes), you will get only the update log records. [...]
5047 111 33_Re: PCTFREE and FREEPAGE for NPIs14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Fri, 16 Jun 2006 12:10:55 -0700592_us-ascii Barbara & Listers,
Larry may be partially correct. In our $660 course, "Cost-Saving Database Index Design," Tapio Lahdenmaki has a section on designing index freespace. If you are just doing a single row index probe via the NPI Larry J is correct. Just use the defaults.
But if the NPI access is via an index scan [matching or non-matching] of multiple NPI keys and RIDs, then the non-sequential sync reads in the index [due to splits] will double response time for just 1% of split pages! Then you need to do some careful analysis. See Tapio's book; it's part of [...]
5159 31 44_Column protection/encryption in DB2 for z/OS13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM31_Fri, 16 Jun 2006 11:10:29 -0500354_- Hello,
We have several tables that contain SSN. One of our applications would like to be able to encrypt or protect this data in some way with the following rules:
First, when the SSN column is displayed, it should be displayed as a series of **** or some other character unless the person has been authorized to see the actual SSN. [...]
5191 357 33_Re: Critical steps to monitor DB214_David S. Waugh16_dswaugh@LANL.GOV31_Fri, 16 Jun 2006 10:42:04 -0600600_US-ASCII EXCELLENT list, Lock!
I'd just like to add, Blake, that you should not assume that your recently-departed predecessor has everything set up correctly & efficiently.
In my various wanderings as a travelling DB2 SysProg, I've worked at quite a few places where I found that someone made an assumption (which may have either been incorrect to begin with, or was once correct but is no longer) about the way DB2 objects should be backed up, recovered and otherwise tended to. Some things may just flat have been missed - I've been at a couple places where some of the Catalog [...]
5549 269 13_Re: SQL ERROR14_David S. Waugh16_dswaugh@LANL.GOV31_Fri, 16 Jun 2006 11:17:46 -0600393_US-ASCII Grace:
If you're on V8, you can override the DSNTEP2 MAXERRORS value with a "--#SET" statement in the input stream:
--#SET MAXERRORS n where n is the number of errors allowed before the program should continue. Use -1 to indicate that the program should tolerate an unlimited number of errors. Severe SQL errors will cause program termination whenever encountered. [...]
5819 72 48_Re: Column protection/encryption in DB2 for z/OS9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 16 Jun 2006 12:20:25 -0500351_us-ascii That is a half solution - If you can specify the ssn in a where clause without the encryption key, then someone can still collect all the neccessary information for identity theft. The V8 solution is a full solution - you must have the passcode to use the column in any way - where clause, select data column, join to other tables, etc. [...]
5892 80 33_Re: Critical steps to monitor DB215_Carol L Broyles30_carol.broyles@MEADWESTVACO.COM31_Fri, 16 Jun 2006 13:38:57 -0400416_US-ASCII I think David meant SYSUTILX and SYSLGRNX. For a minute there, I thought I might be missing a backup!
Carol
<> [...]
5973 65 80_v8.3 LUW: APAR IY84124 Union predicates return incorrect results - not just MDC?13_Brian Stewart23_briankstewart@GMAIL.COM31_Fri, 16 Jun 2006 12:03:32 -0600594_ISO-8859-1 Hello -
Running a query that UNIONs three select statements in v8.1.7 FP 7 on Windows XP produces one set of results (correct results), but running the same query against the same data in another environment v8.2.3 on HP-UX 11.11 produces another set of results (incorrect).
There is an APAR IY84124 that addresses this problem in an MDC environment but the situation I have does not use MDC. Is this same type of problem possible in a non-MDC environment with the versions listed? The APAR suggests that you apply v8.2 FP 5 to fix the problem and to use runstats [...]
6039 209 33_Re: Critical steps to monitor DB214_David S. Waugh16_dswaugh@LANL.GOV31_Fri, 16 Jun 2006 13:43:11 -0600461_US-ASCII Yep, you're right - that should have been SYSUTILX, not DSNUTILX. My bad - sorry...
You should probably add to the list DSNDB06.SYSDDF (which replaced DSNDDF.SYSDDF)
And there are a few others that have been added with each version/release that you need to verify are being backed up: SYSGRTNS SYSHIST SYSJAVA SYSJAUXA SYSJAUXB SYSOBJ SYSSEQ SYSSEQ2 SYSSTATS SYSSTR (I may have missed one or two - and there are more for V8 as well) [...]
6249 47 40_Rebinding an Operative=Y Valid=N package13_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 16 Jun 2006 18:12:52 -0300737_US-ASCII Hi list,
I always thought that if an Operative=Y Valid=N package fails in REBIND, then it became OPERATIVE=N. Is this true? Because I found an example where this didn't happened. Is this a bug or I'm wrong?
Cheers,
Horacio Villa
--------------------------------------------------------------------------------- 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
6297 27 18_KEYCARD statistics30_Mark Labby-AES-PHEAA UG Leader21_mlabby@AESSUCCESS.ORG31_Fri, 16 Jun 2006 17:45:55 -0400587_us-ascii Where are the various statistics stored when they KEYCARD parm is used with gathering index statistics? I can find the traditional FIRSTKEYCARD and FULLKEYCARD in the catalog tables, but haven't found where in the catalog they are putting the partial key statistics.
============================================================================= This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. [...]
6325 59 44_Re: Rebinding an Operative=Y Valid=N package9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 16 Jun 2006 16:56:51 -0500484_us-ascii The V8 manual still says that --
DB2 marks a plan or package as inoperative if an automatic rebind fails. Whether a plan or package is operative is recorded in column OPERATIVE of SYSPLAN and SYSPACKAGE.
The only question I would have is the the difference between automatic rebind and manual (ie specified in JCL or TSO) rebind. Didn't think that OPERATIVE was set if a jcl or tso REBIND failed but haven't had occasion to test it for a long time either. [...]
6385 24 19_Deadlock Toleration12_John Piccoli18_jpiccoli@COGECO.CA31_Fri, 16 Jun 2006 21:06:04 -0400810_US-ASCII Hello,
I am searching for "industry standards/best practices" on the number of acceptable/tolerated deadlocks within a pre-defined timeline in well designed/tuned DB2 for z/OS mission critical applications.
Does anyone have any guidelines or rules-of-thumb? Is there any documentation on the subject?
John CDS
--------------------------------------------------------------------------------- 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
6410 173 48_Re: Column protection/encryption in DB2 for z/OS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 17 Jun 2006 11:31:59 +1000342_US-ASCII If you are doing the lookup in a program using static sql it should be easy - just some appropriate IF statements.
If you are using dynamic SQL the easiest way would be to move the actual SELECT into a table UDF. People then have to code the table UDF in the their FROM clause. The table UDF does the appropriate things. [...]
6584 34 52_Manfred MOSSBAUER ist au=?ISO-8859-1?Q?=DFer?= Haus.17_Manfred MOSSBAUER16_mossbauer@GRZ.AT31_Sat, 17 Jun 2006 05:48:28 +0200558_ISO-8859-1 Ich werde ab 15.06.2006 nicht im Büro sein. Ich kehre zurück am 19.06.2006.
Die Rückmeldung bezieht sich auf ein Mail mit folgendem Thema: Re: [DB2-L] Critical steps to monitor DB2
____________________________________________________________________________________________ Gesendet (c) GRZ/RACON Linz 2001 Agent 'Abwesenheit'
Der Austausch von Nachrichten mit o.a. Absender via e-mail dient ausschließlich Informationszwecken. Rechtsgeschäftliche Erklärungen dürfen über dieses Medium nicht ausgetauscht werden. [...]
6619 46 23_Re: Deadlock Toleration12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 18 Jun 2006 21:10:12 +0200422_us-ascii Hi, As deadlocks are caused by application it's the same answer as "how many bugs are you ready to tolerate in your application code, that causes it to abend?"
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of John Piccoli Sent: Saturday, June 17, 2006 3:06 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Deadlock Toleration [...]
6666 61 23_Re: Deadlock Toleration14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 19 Jun 2006 14:08:39 +1000433_US-ASCII I disagree with this. It's not the deadlock, as such, which is the problem - but rather what happens next. If you (or rather the program) throw your hands up and die (aka abend), then yes it is the same thing. Been there - although it was the burnt smart card that had to be discarded in front of the customer which was the nasty bit. (Which isn't quite as bad as the bug where you don't abend or deadlock you ignore!) [...]
6728 86 23_Canberra DB2 User group0_28_steve.tennant@CUSTOMS.GOV.AU31_Mon, 19 Jun 2006 16:29:20 +1000481_iso-8859-1 Dear Canberra DB2 & UDB Professionals ,
The Canberra DB2 Users Group (C-DUG) would like to invite you to a FREE presentation by Savio SALDANHA (CA) on DB2 Cloudscape; a small footprint DB2 but packing a big punch. The meeting is scheduled for Thursday 6th July 2006 from 4pm until ~6pm at Computer Associates House, 10 National Circuit, Barton ACT 2600; and is open to anyone with an interest in the DB2 UDB family of Databases or just Databases in general. [...]
6815 24 11_DB2 v7 z/OS35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Mon, 19 Jun 2006 12:59:23 +0200781_iso-8859-1 Hi everyone out there,
the other day we got bitten real badly by increasing the number of collections in our single CICS-plan, response-times were totally inacceptable. Now we wonder whether the number of packages per collection might also have an impact on response-times. Any suggestion anyone ?
TIA
Ruediger
--------------------------------------------------------------------------------- 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 [...]
6840 32 14_Data Warehouse15_Haldur Johansen18_haldur@ELEKTRON.FO31_Mon, 19 Jun 2006 12:25:46 +0100440_ISO-8859-1 Dear listmembers.
I am running both DB2 Data Warehouse Center 8.2 (8.1.10) and the new DB2 Data Warehouse Edition 9.1 (Design Studio) on different servers. I would like to use a MS Access (.mdb) or a MS Excel (.xls) as source. Does anyone know how?
I have made an ODBC for Microsoft Access Driver (*.mdb) and an ODBC for Microsoft Excel Driver (*.xls). But how do I make it work as a source in Data Warehouse? [...]
6873 110 23_Re: Deadlock Toleration11_Suresh Sane21_data_arch@HOTMAIL.COM31_Mon, 19 Jun 2006 07:23:10 -0500523_- James,
While I agree with your ROT and the analysis of retry logic performance, I think you seem to be glossing over the issue of Data Integrity. I would like to elaborate on that aspect.
"gracefully rollback and retry" meaning starting from where? Certainly not the statement level itself. Back to start of the program? OK - what about an environment with several subroutines/triggers/stored procedures? The -911 rolls back all work in the LUW and that means the application must re-do all this work. [...]
6984 85 23_Re: Deadlock Toleration12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 19 Jun 2006 17:13:42 +0200536_us-ascii Hi, We'll disagree on some and agree on some. The cheapest way to prevent is at design. However, deadlocks are solved (forced rollback to an application) at run time, by DB2 according to the time specified at IRLM (usually 5 seconds, but can be as low as 0.1sec) the longer it takes, the more locks your deadlocked transactions hold and more wait for others that wait for those resources. The delay can be few seconds at best (2-3 to detection, another 1 for rollback & error handling ). If you can live with that - fine. [...]
7070 26 19_Archive Server Up ?14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Mon, 19 Jun 2006 09:59:03 -0500429_US-ASCII Anyone having problems searching the archives ?
I am getting Error during command authentication Error - unable to initiate communication with LISTSERV (errno=10054, phase=RECEIVE, target=127.0.0.1:2306). The server is probably not started. Cache-Control: no-cache, must-revalidate Pragma: no-cache
thank you, Mark Vickers Grocers Supply Co 3131 E. Holcombe Blvd. Houston, TX 77021 Tel (713) 842-6541 [...]
7097 76 54_Calling Mainframe User Defined Function via Federation0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Mon, 19 Jun 2006 12:43:31 -0400409_us-ascii First, our environment: DB2 v8.2 (fp11 64-bit) on Solaris, and DB2 v7.1 on z/OS.
We're working on invoking a mainframe DB2 user defined function (UDF) via federation from a DB2 database that resides on a Solaris database server. We're running into something that appears (to me) to be a problem with the way federation is "rewriting" an SQL statement as it sends it from Solaris to z/OS. [...]
7174 421 44_Re: DBM1 Storage - negative number? - Update10_Brian Bear23_Brian.Bear@CHARMING.COM31_Mon, 19 Jun 2006 13:01:38 -0400282_US-ASCII Per the report shown earlier, I guess my actual concern is that MVS is not appearing to be giving DBM1 1.6gb to use. Since for the DSNA subsystem, GETMAIN for BP and EDM, etc, totals 873 mb and when added to the Variable, Fixed and Stack allocations it totals 992 mb. [...]
7596 485 48_Re: Column protection/encryption in DB2 for z/OS15_Campbell, Wayne28_Wayne.Campbell@COURTS.WA.GOV31_Mon, 19 Jun 2006 10:27:47 -0700378_us-ascii Getting off the subject, my understanding that is that SSN, Last Name, and Date of Birth are required for it to be unique. This is from "common knowledge" which may not be so common since it seems there's a lot of people don't realize that a SSN is not unique. Is there anyone out there who knows fore sure and where it's documented what is required to be unique? [...]
8082 105 40_conditional getpage requests have failed20_ARCHER, MARY-ELLEN H17_MARCHER@SCANA.COM31_Mon, 19 Jun 2006 14:01:25 -0400729_us-ascii I keep seeing 'conditional getpage requests have failed' in my monitor. What is a conditional getpage and why would it fail? Should I be worried about this? I am running v8 of DB2 z/os.
Thanks,
Mary-Ellen Archer
--------------------------------------------------------------------------------- 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
8188 107 33_Re: Critical steps to monitor DB214_Wayne Driscoll25_wdriscoll@JMESOFTWARE.COM31_Mon, 19 Jun 2006 13:11:16 -0500455_us-ascii Mike, On point 3 below, I wouldn't set the Install SYSADM to my TSO ID, instead I would have my security admin create a DB2SYSP group in the security system, connect me, and at least one sysprog that will learn with me as backup to this group, then set the group ID to be install SYSADM, that way the backup can do things when I am out of the office. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. [...]
8296 101 23_Re: Deadlock Toleration16_Philip K.Gunning22_pgunning@GUNNINGTS.COM31_Mon, 19 Jun 2006 13:36:25 -0400603_ISO-8859-1 Seems like we have it covered. I prefer to fix it during the design or else as you know, they pay later which is manifested in production problems. Don't forget about the resources used for deadlock detection..Cheers, Phil > > From: Isaac Yassin > Date: 2006/06/19 Mon PM 05:13:42 EDT > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] Deadlock Toleration > > Hi, > We'll disagree on some and agree on some. > The cheapest way to prevent is at design. > However, deadlocks are solved (forced rollback to an application) at run time, by DB2 according to the time [...]
8398 112 27_Upgrade to Fix Pak 12 fails16_Harold Pritchett14_harold@UGA.EDU31_Mon, 19 Jun 2006 14:27:51 -0400668_ISO-8859-1 I am trying to install db2 UDB Fix Pack 12 in a test environment. I installed a new server with Red Hat Enterprise Linux, and installed db2 v8.1, Fix Pak 7 from a distribution CD. This system started fine.
The db2diag.log file contains the following identification:
2006-06-19-12.09.36.168962-240 I1G1222 LEVEL: Event PID : 7703 TID : 3054571648 PROC : db2flacc INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, RAS/PD component, _pdlogInt, probe:120 START : New db2diag.log file DATA #1 : Build Level, 124 bytes Instance "db2inst1" uses "32" bits and DB2 code release "SQL08020" with level identifier "03010106". Informational tokens are [...]
8511 45 20_DSNWZP -471 00E7900C9_Joe Huang16_tzs61x@YAHOO.COM31_Mon, 19 Jun 2006 11:59:54 -0700630_iso-8859-1 We upgraded DB2 to V8.1. Received the following error
messages when running IVP job DSNTEJ6Z. Any similiar experience? Thanks Joe
DSN8ED7: Error calling stored procedure DSNWZP
DSNT408I SQLCODE = -471, ERROR: INVOCATION OF FUNCTION OR PROCEDURE SYSPROC.DSNWZP FAILED DUE TO REASON
DSNT418I SQLSTATE = 55023 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9WCA SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...]
8557 19 25_DB2 V7 z/OS Index logging14_Matthews, John25_JMatthews@MEDNET.UCLA.EDU31_Mon, 19 Jun 2006 12:05:17 -0700676_iso-8859-1 I have noticed significant logging of index entries when loading rows with LOAD utility. Could I avoid some of the logging by dropping the NPI prior to the LOAD util and doing a REBUILD of the NPI or does REBUILD NPI also log index records?
---------------------------------------------------------- IMPORTANT WARNING: This email (and any attachments) is only intended for the use of the person or entity to which it is addressed, and may contain information that is privileged and confidential. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. Unauthorized redisclosure or failure to maintain confidentiality [...]
8577 145 48_Re: Column protection/encryption in DB2 for z/OS9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 19 Jun 2006 14:32:57 -0500333_us-ascii Two different questions - 1. What does the social security expect for it to be unique? I believe your statement was the same as I used for a system approximately 20 years ago. 2. With the number of "fake" ssn out there, what do you have to do to handle multiple people with the same ssn? I don't have any idea anymore. [...]
8723 51 64_recover 1 table from a multiple tables segmented tablespace copy6_larsen19_billarsen@YAHOO.COM31_Mon, 19 Jun 2006 13:04:30 -0700525_iso-8859-1 dear all ,
An user lost his table (DROP TABLE) and asked me to recover it . Unfortunately, this is a table from a multiple tables segmented tablespace. I didn't have this situation before, just dsn1copy from single table tablepsace. My question is : Do i have to do OBIDXLAT for all the tables , or it is just ok if i mention only the object i want to recover ? What i want to do is : Create tablespace TSN , table TBN DSN1COPY with just obid transalation for TBN => i suppose that i will get the data [...]
8775 157 23_Re: Deadlock Toleration14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Mon, 19 Jun 2006 15:25:55 -0500475_windows-1250 I could not disagree more. A rolled back transaction/LUW MUST BE atomic and should never cause integrity problems however many 'processes', triggers, etc to which it gives birth or is transferred. That is the the definition of a transaction. This IS absolutely an application design (and, where applicable, a platform distributed commit) issue. Therefore retry should always be perfectly acceptable: 'I am sorry, the data is currently in use, please retry' [...]
8933 101 33_Re: Critical steps to monitor DB215_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Mon, 19 Jun 2006 16:39:10 -0400717_ISO-8859-1 Wow. without attempting to add anything specific to the excellent lists by LL and DSW, I'd just say that I think taking the DB2 z/OS System Administration course which is offered periodically by IBM wouldn't be a bad idea... in the United States, the course number is CF850 (Search through the IBM Education Website for that course number if you want to take the course in the US), or you could use this URL to try to find it elsewhere: http://www-304.ibm.com/jct03001c/services/learning/ites.wss/tp/en?pageType=tp_search_results&rowStart=0&rowsToReturn=20&sortBy=&sortDirection=&searchString=DB2+for+z%2FOS+Administration&countryGeo=&provider=&freeFee=&offeringType=Classroom&Search.x=37&Search.y=10 [...]
9035 216 13_Re: SQL ERROR15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Mon, 19 Jun 2006 16:50:30 -0400580_ISO-8859-1 How come nobody mentions doing DDL with DSNTIAUL? That works, as long as you define SYSPUNCH...
On 6/16/06, David S. Waugh wrote: > > > Grace: > > If you're on V8, you can override the DSNTEP2 MAXERRORS value with a > "--#SET" statement in the input stream: > > --#SET MAXERRORS n > where n is the number of errors allowed before the > program should continue. Use -1 to indicate that the > program should tolerate an unlimited number of > errors. Severe SQL errors will cause program > termination whenever encountered. > > If you're on [...]
9252 54 23_Re: Archive Server Up ?13_David S Waugh16_dsw-dba@JUNO.COM29_Mon, 19 Jun 2006 23:13:56 GMT503_- I get a CGI Timeout message when I try to search the archives... I'd say it's dead.
David Waugh DSW Consulting & Services
-- Mark E Vickers wrote: Anyone having problems searching the archives ?
I am getting Error during command authentication Error - unable to initiate communication with LISTSERV (errno=10054, phase=RECEIVE, target=127.0.0.1:2306). The server is probably not started. Cache-Control: no-cache, must-revalidate Pragma: no-cache [...]
9307 45 22_Re: KEYCARD statistics13_David Simpson22_DSIMPSO@TRANSUNION.COM31_Mon, 19 Jun 2006 18:25:54 -0500674_US-ASCII Look in SYSIBM.SYSCOLDIST.
>>> mlabby@AESSUCCESS.ORG 6/16/06 4:45 PM >>> Where are the various statistics stored when they KEYCARD parm is used
with gathering index statistics? I can find the traditional FIRSTKEYCARD and FULLKEYCARD in the catalog tables, but haven't found where in the catalog they are putting the partial key statistics.
============================================================================= This message contains privileged and confidential information intended for the above addressees only. If you receive this message in error please delete or destroy this message and/or attachments. [...]
9353 193 44_Re: DBM1 Storage - negative number? - Update35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Mon, 19 Jun 2006 19:50:15 -0400335_iso-8859-1 Brian,
Maybe it's semantics - but MVS doesn't GIVE the memory to DB2. DB2 asks for the memory from MVS. DB2 will get what it needs - up to 1.6 gig for pools, and up to 2 gig for DBM1 address space.
If the system isn't using more than you see allocated, then it has not requested it, and does not need it. [...]
9547 64 23_Re: Archive Server Up ?13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 19 Jun 2006 19:51:20 -0500783_us-ascii I will check it out.
Willie
David S Waugh wrote:
>I get a CGI Timeout message when I try to search the archives... >I'd say it's dead. > >David Waugh >DSW Consulting & Services > >-- Mark E Vickers wrote: >Anyone having problems searching the archives ? > >I am getting >Error during command authentication >Error - unable to initiate communication with LISTSERV (errno=10054, >phase=RECEIVE, target=127.0.0.1:2306). The server is probably not >started. >Cache-Control: no-cache, must-revalidate Pragma: no-cache > >thank you, >Mark Vickers >Grocers Supply Co >3131 E. Holcombe Blvd. >Houston, TX 77021 >Tel (713) 842-6541 > >----------------------------------------------------------------------- >---------- >Welcome [...]
9612 82 68_Re: recover 1 table from a multiple tables segmented tablespace copy9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 19 Jun 2006 21:33:45 -0500454_us-ascii from memory - you have to specify all the obid's for the source tablespace in DSN1COPY - the target obid doesn't have to be anything valid but the pair has to exist for DSN1COPY to run cond code=0. ie xlat old dbid, new dbid old tsid, new tsid old table you want, new table you want old tables to ignore, 3333 or any valid value less than 64K the tables to ignore can all specify the same garbage id but they have to be in the xlat stream. [...]
9695 414 48_Re: Column protection/encryption in DB2 for z/OS15_Mike Hutchinson24_mike.hutchinson@JNLI.COM31_Mon, 19 Jun 2006 22:51:30 -0400469_US-ASCII Can someone request a new SSN after an identity theft? If so, the person-SSN relationship might be many-to-many.
Mike Hutchinson Sr Applications DBA 517-367-3488 Jackson National Life
Mike Bell Sent by: DB2 Data Base Discussion List 06/19/2006 07:17 PM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc [...]
10110 313 48_Re: Column protection/encryption in DB2 for z/OS0_18_iwant2beme@AOL.COM31_Mon, 19 Jun 2006 23:09:09 -0400778_us-ascii Here's some info from www.socialsecurity.gov:
Identity Theft and Assumption Deterrence Act of 1998 (P.L. 105-318) Makes identity theft (transferring or using another person's means of identification) a crime, subject to penalties. Defines "means of identification" to include name, social security number, date of birth, official State or government issued driver's license or identification number, alien registration number, government passport number, and employer or taxpayer identification number; and Establishes the Federal Trade Commission as a clearinghouse to receive complaints, provide informational materials to victims, and refer complaints to appropriate entities, which may include credit bureaus or law enforcement agencies. Vice President [...]
10424 46 18_Re: Data Warehouse14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Jun 2006 13:35:32 +1000382_ISO-8859-1 As it's a server, you have to push the data into it. What I have seen people do is create a DB2 ODBC data source for their DB2 database, and then use MS Access to copy data from one ODBC source to another - the destination being DB2.
Alternatively you could use Webshere Information Integrator to make to make your ODBC sources appear as federated databases. [...]
10471 45 15_Re: DB2 v7 z/OS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Jun 2006 13:35:32 +1000385_ISO-8859-1 DB2 uses an index look-up on .. If that fails it tries .. if that fails .... and so on.
In an ideal world, you'ld keep all your production packages in the first collection, and only use the second and so on for backup, emergency and the like. [...]
10517 136 29_Re: DB2 V7 z/OS Index logging13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 20 Jun 2006 06:18:47 +0200497_US-ASCII The logging comes from the BUILD2 phase where the NPIs are updated in an SQL-like manner. The REBUILD action when you drop & recreate the NPIs has only a limited amount of logging (for tracking the progress of the utility) so you would gain there. However, you might use much more CPU if you've got more than a few partitions, and your applications/users might be affected, since the NPI will be gone/unavailable for the entire table - and presumably it exists because it is needed. [...]
10654 142 23_Re: Deadlock Toleration13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 20 Jun 2006 06:26:16 +0200537_US-ASCII That was true in the Good Old Days when people knew what they were doing, and did it themselves. Nowadays, when people assemble jobs from predefined objects or beans or whatever out of commercial class libraries using a drag-and-drop generator, going through an application and/or web server with shared, reusable, persistent connections, the relationship between a business and a database transaction is gone. I know that is the case for SAP. So you can't handle deadlock/timeout toleration on the DB level alone anymore. [...]
10797 204 24_Re: DSNWZP -471 00E7900C13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 20 Jun 2006 06:43:39 +0200561_US-ASCII The explanation for 00E7900C seems pretty clear: the WLM environment you specified for procedure DSNWZP "is not defined or is currently not available for DB2 use in the active WLM policy".
D. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
Joe Huang Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 19-06-06 20:59 [...]
11002 13 32_Re: DB2 Physical Delete Sequence33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 20 Jun 2006 03:52:50 -0500595_- Grahame
I am not sure, but I think, DB2 will check ist in the sequence of the creation timestamp, the oldest first.
--------------------------------------------------------------------------------- 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
11016 39 26_DB2-CICS protected threads10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 20 Jun 2006 11:05:30 +0200546_US-ASCII Esteemed listers
I've implemented protected threads in our (?) shop. The % of reuse is nice, ranging from 65 to 90%. I tested 2/3 values for protected thread but I saw that 2 is enough for that cics workload.
My boss said there's no difference in CICS cpu usage and there's no saving using protected threads. I've to check monthly usage but it seems strange to me that a POOL cics (ie where all transaction go to POOL so no reuse) cpu usage is equal to a cics with protected threads, if so there'd be something wrong. [...]
11056 20 44_Re: Rebinding an Operative=Y Valid=N package33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 20 Jun 2006 04:20:14 -0500428_- Hi
I don't know, if a failing manual REBIND sets the OPERATIVE-column to 'N'. What I did (DB2 V7): I altered a table by adding a column and rebind a package, having an insert without column-specification. The rebind failed, but the package remained executable. If I dropped and recreatet the table, the package got invalid. Unfortunately, I didn't looked up the column OPERATIVE after having done a second rebind. [...]
11077 19 15_Re: DB2 v7 z/OS33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 20 Jun 2006 04:32:04 -0500483_- James
It's not just the look-up in the directory. AFAIK, before doing this, DB2 checks, whether the required package is already in the EDM-pool. The more packages in a collection, the longer will be the chain in the pool and the more CPU will be necessary to find the package.
I must admit, that we, as I think many other installations do, use one collection for nearly all packages. So we never measured, how much CPU is needed to find a package in that chain. [...]
11097 58 50_DB2 Version 8 - Multi-row fetch and Host Structure13_Wolfgang Hini39_wolfgang.hini@HIPERFORMANCE-SOFTWARE.DE31_Tue, 20 Jun 2006 05:31:28 -0500364_- Hi all,
testing this new function with cobol and the employee sample table, I remarked that the definition of the host structure, based on the output of DCLGEN can cause some problems. In my test program LASTNAME was defined as:
05 HV-LASTNAME-ARRAY OCCURS 100 TIMES. 49 HV-LASTNAME-LEN PIC S9(4) USAGE COMP. 49 HV-LASTNAME PIC X(15). [...]
11156 173 23_Re: Deadlock Toleration11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 20 Jun 2006 06:01:05 -0500362_- Andy,
I don't think we are in a disagreement that this is a application design issue. Transaction is always atomic - agreed. What I am saying is that scope of that "transaction" is easy for the programmer to be ignorant of. The question is not whether it will be rolled back - but will the programmer correctly determine whether or not this is OK. [...]
11330 73 68_Re: recover 1 table from a multiple tables segmented tablespace copy6_larsen19_billarsen@YAHOO.COM31_Tue, 20 Jun 2006 04:13:25 -0700499_iso-8859-1 Thank you mike , i ended the task , with a lot of patience ...
In fact , all OBIDs must be in OBIDXLAT , the tables you don't need don't have to be created For those that i don't need to recover , I did : 3,3 4,4 5,5
In my case , i have hundred OBIDs (i suppose that the tablespace was not reorganized for a long time , so all the pages are still here) !!! Just submit DSN1COPY , then it told "OBID xxx not found in OBXLAT file" , then just add it and resubmit [...]
11404 169 30_Re: DB2-CICS protected threads0_25_LL581@DAIMLERCHRYSLER.COM31_Tue, 20 Jun 2006 07:19:17 -0400679_US-ASCII Max,
Aren't you certified anymore?
:)
Lock Lyon Compuware Corp
Max Scarpa Sent by: DB2 Data Base Discussion List 06/20/2006 05:05 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] DB2-CICS protected threads
Esteemed listers
I've implemented protected threads in our (?) shop. The % of reuse is nice, ranging from 65 to 90%. I tested 2/3 values for protected thread but I saw that 2 is enough for that cics workload. [...]
11574 64 24_Re: DSNWZP -471 00E7900C14_Sniatecki, Jim31_Jim.Sniatecki@ERIEINSURANCE.COM31_Tue, 20 Jun 2006 07:49:40 -0400574_us-ascii You need to alter the stored procedure to use your correct WLM environment:
For example in our environment, we did the following:
SET CURRENT SQLID = 'SYSADM'; ALTER PROCEDURE SYSIBM.SQLCAMESSAGE WLM ENVIRONMENT DSN1SPW6 ; ALTER PROCEDURE SYSIBM.SQLCOLPRIVILEGES WLM ENVIRONMENT DSN1SPW6 ; ALTER PROCEDURE SYSIBM.SQLCOLUMNS WLM ENVIRONMENT DSN1SPW6 ; ALTER PROCEDURE SYSIBM.SQLFOREIGNKEYS WLM ENVIRONMENT DSN1SPW6 ; ALTER PROCEDURE SYSIBM.SQLGETTYPEINFO WLM ENVIRONMENT DSN1SPW6 ; ALTER PROCEDURE SYSIBM.SQLPRIMARYKEYS WLM ENVIRONMENT DSN1SPW6 ; [...]
11639 20 37_Dat warehouse for insurance companies12_Robert Smith24_robert.smith@NCFBINS.COM31_Tue, 20 Jun 2006 07:09:24 -0500525_- While this is clearly not the proper place to ask this question, I am hoping that the list members could direct me to the correct list for this question. I have been asked to research the existing companies, and their offerings, that have developed and are selling pre-built data warehouses for the insurance industry, in particular P&C companies. Any help you could give me in the way of directions to a source of information, especially discussion groups (where I can get the true story), would be most appreciated. [...]
11660 52 30_Re: DB2-CICS protected threads14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Jun 2006 22:51:31 +1000300_US-ASCII I have seen some workings which were based on STROBE reports of the CPU consumption of the DB2 modules. There was a point at which the overheads of maintaining the threads was greater than the saving of reuse.
Don't have a copy, but I think that's the sort of detail you'd need. [...]
11713 180 54_Re: DB2 Version 8 - Multi-row fetch and Host Structure14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 20 Jun 2006 22:51:31 +1000294_US-ASCII > Is there a documentation how to transfer the DCLGEN output to a rowset > structure No, but Appl Prog and the SQL Guide section 2.4.3.6 Declaring host variable arrays has the format of the result. > or what is the rule? SYNC (or SYNCHRONIZED) is a required option on the length. [...]
11894 51 23_Re: Deadlock Toleration14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Tue, 20 Jun 2006 07:54:36 -0500408_windows-1250 Suresh,
I accept what you say. It is ultimately the analyst who specified what the programmer should do who is responsible and he should always understand transaction scope across as many platforms/processes as are involved. At bottom you either pay more once up front to get the design right or you pay down the line every time to detect/fix the resultant inconsistencies manually. [...]
11946 17 48_Re: Column protection/encryption in DB2 for z/OS13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM31_Tue, 20 Jun 2006 08:17:51 -0500318_- James mentioned that a table UDF may be able to provide the functionality our application is requesting (ie query on the SSN but don't display it). Unfortunately, we really don't have any experience with UDF. Does anyone have an example that can help us get started?
Thanks for any help you can provide. [...]
11964 284 44_Re: DBM1 Storage - negative number? - Update10_Brian Bear23_Brian.Bear@CHARMING.COM31_Tue, 20 Jun 2006 09:28:48 -0400400_US-ASCII Thanks for your response Joel. The reason I bring this up is that BMC Mainview was reporting only this one subsystem as not allocating enough storage to cover it's BP, EDM, etc. allocations. I am working with BMC on this.
Additionally, RMF is showing 138k slots of Aux Storage being used which I can't reconcile. Again, according to Mainview, DBM1 is using 988.57 mb of storage. [...]
12249 59 23_DB2 V6.1 with z/OS V1.715_Foweather, Iris30_Iris.Foweather@UK.EXPERIAN.COM31_Tue, 20 Jun 2006 15:02:13 +0100388_iso-8859-1 Hello, We are still running DB2 V6.1 on a few subsystems because of 3rd party product problems. We are planning to go z/OS V1.7. IBM state 'the minimum level of DB2 that will run with z/OS 1.7 is DB2 V7 R1 with PTF UQ77014. DB2 V6 is unsupported under z/OS 1.7'. Question is has anyone out there tried to use DB2 V6.1 with z/OS V1.7 either successfully or unsuccessfully? [...]
12309 94 27_Re: DB2 V6.1 with z/OS V1.712_Daniel Allen17_DAllen@SERENA.COM31_Tue, 20 Jun 2006 07:21:38 -0700448_us-ascii As a software vendor, we have successfully run DB2 v6.1 under z/OS 1.7.
Daniel Allen Sr. System Programmer Serena Software, Inc. 13713 Pinto Lane Lodi, CA 95240 800-699-6850 ext. 11241
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Foweather, Iris Sent: Tuesday, June 20, 2006 7:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V6.1 with z/OS V1.7 [...]
12404 123 27_Re: DB2 V6.1 with z/OS V1.712_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 20 Jun 2006 09:35:05 -0700349_US-ASCII HLS Technologies runs V6 on ZOS 1.7, as we still have customers on V6.
However, as someone who once had a "real job" in the "real world," I would not want to stay in production longer than needed. IBM normally offers support, at a price, for people in this situation. Have you asked them about what they will do to support you? [...]
12528 103 27_Re: DB2 V6.1 with z/OS V1.719_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Tue, 20 Jun 2006 09:35:56 -0500503_us-ascii Hi Iris,
I can't answer your real question but because DB2 V6 is unsupported period, IBM wouldn't bother to verify if it could run on newer versions of the operating system. But that doesn't mean that DB2 V6 wouldn't be able to run there.
And DB2 V6 has a twin ptf (UQ77013) to UQ77014; so I'd think you'd have a good chance of being able to run DB2 V6 there if you have that applied (note: UQ77013/UQ77014 appear to be in error, so you may need additional service as well). [...]
12632 141 27_Re: DB2 V6.1 with z/OS V1.712_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Tue, 20 Jun 2006 10:11:09 -0700365_US-ASCII Rich:
IBM has told us that you can purchase support for down level versions of DB2. I believe you are charged a monthly fee, and then or a cost basis if you use the support.
This question came up because of issues with V7 support after the next release of DB2 comes out. We were told that IBM was offering support well down level of V6. [...]
12774 85 15_Re: DB2 v7 z/OS13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 20 Jun 2006 10:18:42 -0500535_iso-8859-1 We've got a mixture of regions using a mixture of settings, but all of our CICS plans contain more than 1 collectionid, most have around 6-7, but some have as many as 20 collection-id's and we have not experienced the issues you mention (although they are for the most part structured where the one hit most is listed first). Do you happen to have SMF records from the timeframe that experienced the response time degredation? Just wondering if they point to anything specific (increased package requests, loads, etc). [...]
12860 126 15_Re: DB2 v7 z/OS9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 20 Jun 2006 10:51:47 -0500573_iso-8859-1
The known issues are fairly simple - 1. DB2 has to find the PKLIST information - Could be either in the SCT02 skeleton or SYSPACKLIST. Haven't looked at that - don't remember anyone ever saying anything. 2. The program name and contoken are part of the PLIST so DB2 already has those. 3. Take the first collection from PKLIST and see if the program is already in EDM pool (cheap hashed lookup) - this is the normal path length and it has been optimized. 4. IF not in EDMPOOL, then take first collection and add program name and contoken and [...]
12987 90 30_Re: DB2-CICS protected threads13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 20 Jun 2006 11:09:10 -0500563_us-ascii I'll admit I've been kind of lurking in the shadows watching this one -- I've gone through this whole circle myself quite a few times and have always come back to the opinion that thread reuse just doesn't end up giving you a measurable buyback. In the past I usually attributed this to the fact that we run accountrec(uow) (I think this used to be called TOKENI?) to get an accounting record for each transaction, so we were still forcing a signon for every transaction. I was told that this signon got much cheaper with some newer release of CICS [...]
13078 452 44_Re: DBM1 Storage - negative number? - Update35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 20 Jun 2006 11:07:15 -0400336_iso-8859-1 Maybe you had it earlier.... What version of z/OS and DB2 do you have? Are all the systems at the same maintenance levels? Are you using HPs, or Dataspaces?
Does BMC have any thoughts at this point? Is the Mainview report from the same (15min?) period as the RMF report, or is this just a snapshot from mainview? [...]
13531 133 30_Re: DB2-CICS protected threads35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Tue, 20 Jun 2006 12:59:22 -0400371_iso-8859-1 Unfortunately, this is one of those areas where you can't measure the difference using a production workload. The only way to measure differences like this is by having a complete stand-alone benchmark systems, with a defined and totally repeatable transaction workload. If we had instruction pathlengths for functions, we could calculate - but we don't. [...]
13665 183 105_Starting db2cc on AIX 5.2L gives me a: "CLI0622E Error accessing JDBC administration service extensions."6_Nam Wu14_Nam_Wu@GAP.COM31_Tue, 20 Jun 2006 10:37:56 -0700425_us-ascii Hi,
I have recently installed DB2 UDB v8.1 on AIX 5.2L. I tried to start up the Control Center (db2cc) and it gives me this error message: CLI0622E Error accessing JDBC administration service extensions.
Has anyone seen this error before? Can you please help me troubleshoot this?
Thank you very much!
_________________________________ Nam Wu [...]
13849 77 24_DB2 8.2.2 backup problem17_Travis Bindenagel31_Travis.Bindenagel@EAC-EASCI.ORG31_Tue, 20 Jun 2006 14:24:12 -0500583_us-ascii We're running ESE on Windows '03. When I installed the fixpack to get up to 8.2.2, my backups started failing. We are backing up to a separate server, and we get the following return error:
SQL2036N The path for the file or device "\\Server\DB2_Backups\ " is not valid.
It appears to be a rights issue, and we were able to remedy it starting the instance under the system administrator user ID. Our security team isn't all that thrilled with that solution, though, so am wondering if anyone else has run into this problem? [...]
13927 104 17_SQL Consolidation12_Steve DeGiso16_sdegiso@TACT.COM31_Tue, 20 Jun 2006 15:33:06 -0400431_iso-8859-1
Join our Webinar about SQL Consolidation. These 60 minute online interactive sessions allow you to gain insight, and ask questions about how the EZ-DB2 family of Products allow massive savings in DB2 CPU, and will help you determine the real impact of Dynamic SQL on your DB2 Performance.
Sign up for June 26th or 28th sessions at http://www.tact.com/software/docs/emailerForm06.html [...]
14032 58 42_v8.2 LUW: Data Error with UNION and EXISTS13_Brian Stewart23_briankstewart@GMAIL.COM31_Tue, 20 Jun 2006 16:16:09 -0600504_ISO-8859-1 Hello -
Running a query that UNIONs three select statements in v8.1.7 FP 7 on Windows XP produces one set of results (correct results), but running the same query against the same data in another environment v8.2.3 on HP-UX 11.11 produces another set of results (incorrect).
There is an APAR IY46296 that addresses this problem. The APAR suggests that you apply v8.2 FP 3 to fix the problem, however this FixPak has already been applied and the results are still incorrect. [...]
14091 30 31_Re: Upgrade to Fix Pak 12 fails13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Tue, 20 Jun 2006 16:03:01 -0700346_ISO-8859-1 On 6/19/06, Harold Pritchett wrote: > [...] > I then downloaded the Fix Pack 12 update for linux from the db2 > developer's site. The file is FP12_MI00154.tar. I un-tarred it, and > ran the installFixPak script. It appeared to run OK. I then > rebooted the system, and it hung with the following tasks running: > [...]
14122 88 20_Reorg/DFSORT problem10_Paul Fegan33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Wed, 21 Jun 2006 09:53:51 +1000490_us-ascii Hi All,
I have a problem with the reorg of a partition of a compressed tablespaces. The one partition (part 32 the last partition) consistently fails in the unload phase with a DFSORT out of memory condition. We are currently in CM mode on V8. The weird thing is I've tried to reproduce the error in an environment where I can run the reorgs at my leisure but the reorg refuses to die on anything but the original. We get the following error on our development system. [...]
14211 37 31_Re: Upgrade to Fix Pak 12 fails16_Harold Pritchett14_harold@UGA.EDU31_Tue, 20 Jun 2006 20:53:52 -0400564_ISO-8859-1 Ian Bjorhovde wrote: > On 6/19/06, Harold Pritchett wrote: >> [...] >> I then downloaded the Fix Pack 12 update for linux from the db2 >> developer's site. The file is FP12_MI00154.tar. I un-tarred it, and >> ran the installFixPak script. It appeared to run OK. I then >> rebooted the system, and it hung with the following tasks running: >> > > Did you follow the instructions in FixPakReadme.txt file that comes > with the FixPack -- it doesn't sound like you ran db2iupdt or the other > required steps after applying a fixpack. [...]
14249 67 46_Re: v8.2 LUW: Data Error with UNION and EXISTS14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Jun 2006 12:53:32 +1000587_US-ASCII Personally I would have thought that "details of the query" would include at least the SQL and structure of the tables being accessed. But that's just me.
James Campbell
On 20 Jun 2006 at 16:16, Brian Stewart wrote:
> Hello - > > Running a query that UNIONs three select statements in v8.1.7 FP 7 on > Windows XP produces one set of results (correct results), but running > the same query against the same data in another environment v8.2.3 on > HP-UX 11.11 produces another set of results (incorrect). > > There is an APAR IY46296 that addresses this [...]
14317 81 28_Re: DB2 8.2.2 backup problem14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Jun 2006 12:47:40 +1000321_US-ASCII Are you using "TO \\Server\DB2_Backups\" in the backup command? Then you have a no- no: "TO dir/dev A list of directory or tape device names. ... This target directory or device must exist on the database server. "
Been this way since V2, and still the same in V9. Perhaps you were exploiting a bug. [...]
14399 160 35_Antwort: [DB2-L] KEYCARD statistics11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 21 Jun 2006 07:39:36 +0200555_us-ascii Hi Mark, Sorry about the late posting but I just got back from holiday! and of course England are though......anyway back to the question: The stats you are looking for are all stored in the SYSCOLDIST table which is one of the most misunderstood and least exploited of all the catalog tables that the DB2 Optimizer uses for access path selection. If you would like more details of what is stored where, and why, I can send you a presentation I do called "Are you a RUNSTATS master?" which includes lots of notes about why I say what I say! [...]
14560 258 37_Antwort: [DB2-L] Reorg/DFSORT problem11_Roy Boxwell16_R.Boxwell@SEG.DE31_Wed, 21 Jun 2006 07:49:19 +0200488_us-ascii My guess is that there is a PTF that has not or then perhaps *has* been applied to one of the systems. There are a whole bunch of APARs about DB2 getting the AVGRLEN hopelessy wrong and/or compress problems. Check your TABSTATS as well, bear in mind that V8 got "better" with rolling up partition statistics so that could explain the NFM working and finally check your compression factors as this can also be a part of the problem....so the anser is "it depends" - again... [...]
14819 146 24_Re: Reorg/DFSORT problem14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Wed, 21 Jun 2006 02:05:37 -0400406_us-ascii Hi Paul,
Are u using the SORTDEVT and sortnum ?
After v8 the primary sort product becomes the DFSORT and DFSORT prefers the fewer and larger sortwork datsets where as other sort product prefers more and small work datasets for parallel sort.
So I hope if you have any SORTWKnn then remove those and go with SORTDEVT/SORTNUM. I am hopeful that this combination will work. [...]
14966 139 23_AW: [DB2-L] DB2 v7 z/OS35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Wed, 21 Jun 2006 08:11:31 +0200556_iso-8859-1 Mike,
the problem arose because we went to v8 and increased the number of collections at the very same time. I do not have SMF data handy, but ...
PLAN/PACKAGE PROCESSING QUANTITY /SECOND /THREAD /COMMIT --------------------------- -------- ------- ------- ------- INCREMENTAL BINDS 0.00 0.00 0.00 0.00
PLAN ALLOCATION ATTEMPTS 3111.00 1.15 1.03 0.02 PLAN ALLOCATION SUCCESSFUL 3126.00 1.16 1.04 0.02 PACKAGE ALLOCATION ATTEMPT 4676.1K 1732.47 1554.02 31.82 PACKAGE ALLOCATION SUCCESS 333.1K 123.42 110.71 2.27 [...]
15106 309 47_AW: [DB2-L] Antwort: [DB2-L] KEYCARD statistics35_=?iso-8859-1?Q?Kurtz=2C_R=FCdiger?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Wed, 21 Jun 2006 08:18:57 +0200652_iso-8859-1 Mark,
make sure to have the following applied:
IBM APAR
PK02390: RUNSTATS TABLESPACE..PART X INDEX( AAAA PART X KEYCARD )..REPORT YES UPDATE NONE UPDATES CATALOG WITH INCORRECT VALUES.
since we had an issue with incorrect catalog statistics, you may want to search the archive for "DB2 V7 for z/os 1.7, Runstats"
Best regards
Ruediger
________________________________
Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Roy Boxwell Gesendet: Mittwoch, 21. Juni 2006 07:40 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: [DB2-L] Antwort: [DB2-L] KEYCARD statistics [...]
15416 35 30_Re: DB2-CICS protected threads10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 21 Jun 2006 10:05:06 +0200424_US-ASCII Thank you all for replies.
It sounds strange to me that you cannot measure savings - if any - using protected threads. Maybe during years the improvements become so small that where's no difference using or not protected threads.
Anyway someone (a MXGer) suggested: Look at the capture ratio in type72 vs CMF CPUTM. The number of instructions saved per thread is to small to get captured in CMF. [...]
15452 78 30_Re: DB2-CICS protected threads15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Wed, 21 Jun 2006 10:58:46 +0200555_iso-8859-1 We recently introduced protected threads for some high used transaction and saw reduction in CPU time per transaction from 5 to 20%. The huge difference in results depends on how much CPU consumes a single transaction. The higher the value, lower the savings. Since the saving is an (almost) fixed quantity per transaction (thread creation, plan/packages allocation...), its weight is higher when trasactions do less work. Unless your transactions consume seconds of CPU, I think you should see some savings in the CPU/transaction figure. [...]
15531 24 30_Re: DB2-CICS protected threads10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 21 Jun 2006 11:24:47 +0200355_US-ASCII Hi Mauro
Ok we did all what you suggested as is a well known part of protected thread implementation......but how did you measure the savings ? I've only the total CPU used by that CICS and it seems the same even if I suspect the workload is increased due to protected threads. For many reason (mainly a boss) I've no DB2 accounting. [...]
15556 66 30_Re: DB2-CICS protected threads15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Wed, 21 Jun 2006 11:46:41 +0200383_iso-8859-1 Hi Max, I don't know where figures come from, but we have, from CICS point of view, CPU usage for each transaction id and the number of transaction per day, so it's easy to obtain CPU/transaction. I think they come from CICS accounting or statistics (or whatever the name is) SMF records. We have historical data so can check previous and next week average CPU/tran. [...]
15623 140 24_Re: Reorg/DFSORT problem0_22_sally.mir@WACHOVIA.COM31_Wed, 21 Jun 2006 08:57:25 -0400547_US-ASCII Could you post your reorg control cards?
We've just gone through extensive testing with DFSORT vs. Syncsort in our utilities, so we might have seen something similar.
Sally A. Mir, AVP Wachovia Enterprise Data Management IBM Certified Database Administrator DB2 Universal Database V8.1 for Z/OS (336) 773-4011
Paul Fegan DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject [...]
15764 24 30_Re: DB2-CICS protected threads17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Wed, 21 Jun 2006 08:44:51 -0500360_us-ascii Hi Max
Have you looked at http://www.redbooks.ibm.com/redbooks/SG246894.html? It has a nice section on CICS tuning including how to measure. When we did some tuning on a thread a couple of years ago we saw the saving show up in the DB2 SMF by subtracting QWACBJST from QWACEJST and summing that. See the thread on the DB2 list serv titled [...]
15789 62 30_Re: DB2-CICS protected threads35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 21 Jun 2006 10:23:09 -0400405_iso-8859-1 Hi Rich,
Guess you missed the part in one of Max's posts - the boss will not let them turn on acctg traces. So he does not have any data to measure.....
That's certainly one way his boss can prevent Max from proving he's right - don't allow him to have any data. From the boss perspective - the boss doesn't have to prove he's right, only prevent Max from proving him wrong. [...]
15852 168 32_Re: AW: [DB2-L] DB2 v7 z/OS - OT6_Tzachi20_yassini@BEZEQINT.NET31_Wed, 21 Jun 2006 17:48:51 +0200395_utf-8 Hi Ruediger,
Are you sure about the name SPRMKFC ? - I think it has to do with Kentucky Fried Chicken :-)
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kurtz, Rdiger Sent: Wednesday, June 21, 2006 8:12 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] AW: [DB2-L] DB2 v7 z/OS [...]
16021 161 24_Re: Reorg/DFSORT problem12_Backes, Mike21_Mike.Backes@OA.MO.GOV31_Wed, 21 Jun 2006 10:11:07 -0500564_us-ascii Paul, from experience, the only thing I have found that will work with any type of consistency is to manually add sortwk datasets to your jcl, and to massivly overallocate it. It goes against anything IBM will tell you, however when you let Dfsort look at available system resources to determine things, you get inconsistent results. A utility that runs fine week to week will suddenly fail with this problem when the system is under some kind of load. Or if you try to run more than one utility at a time you can kill yourself. Somewhere there is a [...]
16183 71 44_Search the DB2-L archives failing. CGI error10_Brian Bear23_Brian.Bear@CHARMING.COM31_Wed, 21 Jun 2006 11:05:08 -0400399_US-ASCII Trying to find details on how to use DSN1LOGP against archive logs to find culprit of a suspected delete against a table. I ran DSN1LOGP against one of the archive logs and successfully produced the report. Used SUMMARY(YES) DATAONLY(YES).
But unclear of the output page format to determine which one is the delete. DIagnosis guide doesn't have Archive Log Page Format details. [...]
16255 38 41_VERB '-ALTER' REQUIRED KEYWORD IS MISSING9_Joe Huang16_tzs61x@YAHOO.COM31_Wed, 21 Jun 2006 08:29:27 -0700904_iso-8859-1 Am I missing something ? Thanks Joe
DSN SYSTEM(D2W1)
DSN
-ALTER PROCEDURE SYSPROC.DSNWZP WLM ENVIRONMENT D2W1WLM
DSN9021I # VERB '-ALTER' REQUIRED KEYWORD IS MISSING
DSN9023I # DSN9SCND '-ALTER ' ABNORMAL COMPLETION
DSN
END
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--------------------------------------------------------------------------------- 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 [...]
16294 92 46_Re: v8.2 LUW: Data Error with UNION and EXISTS9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 21 Jun 2006 11:08:02 -0500436_US-ASCII I agree with James. So that would be me too.
If this is not perspicuous please let me know. Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Tuesday, June 20, 2006 7:54 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] v8.2 LUW: Data Error with UNION and EXISTS [...]
16387 131 24_Re: Reorg/DFSORT problem14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Wed, 21 Jun 2006 12:02:35 -0500687_windows-1250 CDB has a very high performance reorg that never sorts anything. Visit www.cdbsoftware.com
Andy Lankester -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Paul Fegan Sent: Wednesday, June 21, 2006 12:54 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Reorg/DFSORT problem
Hi All,
I have a problem with the reorg of a partition of a compressed tablespaces. The one partition (part 32 the last partition) consistently fails in the unload phase with a DFSORT out of memory condition. We are currently in CM mode on V8. The weird thing is I've tried to reproduce the [...]
16519 56 30_Re: DB2-CICS protected threads17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Wed, 21 Jun 2006 12:08:16 -0500365_us-ascii Greetings Max
What release of DB2 and CICS are you running? Does the Boss have CICS 110's shut off as well?
The reason I ask is that after CICS/TS 2.2 the accounting changed a bit. You may be able to see a difference at the SMF 110 records. See the note following from the MXG site thread Re: Accounting of DB2 cpu-usage, some Questions [...]
16576 191 24_Re: Reorg/DFSORT problem9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 21 Jun 2006 12:15:12 -0500346_US-ASCII I have had to manually allocate sortwk datasets to get around this problem. I figure it was the easy way out. I don't have undocumented features abend the reorg's during the weekend. I like my sleep.
Dee
If this is not perspicuous please let me know. Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell [...]
16768 64 48_Re: Search the DB2-L archives failing. CGI error9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 21 Jun 2006 12:34:00 -0500402_US-ASCII archive log is exact same format as regular log - In your case, you are looking for a before image without an after image.
Mike
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brian Bear Sent: Wednesday, June 21, 2006 10:05 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Search the DB2-L archives failing. CGI error [...]
16833 63 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING11_Greuter, Al18_Al.Greuter@SSA.GOV31_Wed, 21 Jun 2006 13:37:28 -0400440_us-ascii I think you have a space before the '-'. Try removing it.
Thanks,
Al Greuter Lockheed Martin DB2 Database Administrator (410) 496-9547
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Sent: Wednesday, June 21, 2006 11:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING
Am I missing something ? Thanks Joe [...]
16897 118 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING13_Richard Fazio21_rfazio@TRANSUNION.COM31_Wed, 21 Jun 2006 12:44:40 -0500434_US-ASCII -ALTER PROCEDURE does not exist.
It's not a command.
It's an SQL Statement "ALTER PROCEDURE". faz
Rich Fazio Information Architecture
TransUnion, LLC Marketing Services, 8th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-6453
Talk to teach - Listen to learn
>>> tzs61x@YAHOO.COM 2006-06-21 10:29 AM >>> Am I missing something ? Thanks Joe [...]
17016 97 24_Re: Reorg/DFSORT problem9_Ali, Omar25_Omar.Ali@CITYOFBOSTON.GOV31_Wed, 21 Jun 2006 13:46:56 -0400467_us-ascii We are having the same problem with the dfsort, Trying to load 24 million row table, with out using sort works Currently our system programmers have cases open with ibm,
For a work a round you'll need to add sort works in your jcl
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(900,200),RLSE) //SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(900,200),RLSE) //SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(900,200),RLSE) //SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(900,200),RLSE) [...]
17114 58 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING14_Sniatecki, Jim31_Jim.Sniatecki@ERIEINSURANCE.COM31_Wed, 21 Jun 2006 13:43:00 -0400689_us-ascii SET CURRENT SQLID = 'SYSADM'; This worked for me from spufi:
SET CURRENT SQLID = 'SYSADM'; ---------+---------+---------+---------+---------+---------+---------+ DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+---------+ ALTER PROCEDURE SYSIBM.SQLUDTS WLM ENVIRONMENT DSN1SPJ6 ; ---------+---------+---------+---------+---------+---------+---------+ DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ---------+---------+---------+---------+---------+---------+---------+ ---------+---------+---------+---------+---------+---------+---------+ DSNE614I AUTOCOMMIT IS NO; NO CHANGES COMMITTED [...]
17173 80 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 21 Jun 2006 13:56:46 -0400479_us-ascii Joe,
Check your log for security messages. I had a similar problem and it turned out my security group had to grant additional access. The error message from my ACF2 log was:
ACF04056 ACCESS TO RESOURCE DSNAG0.WLMENV.DB2AWLMX TYPE RDSN BY I71012 NOT AUTHORIZED
I believe this is for the WLM application environment.
Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering [...]
17254 197 24_Re: Reorg/DFSORT problem13_David Simpson22_DSIMPSO@TRANSUNION.COM31_Wed, 21 Jun 2006 12:57:11 -0500450_US-ASCII This will give you consistency, but not necessarily the best performance. As a previous post mentioned, there are lots of PTFs for both DFSORT and DB2 in the works.
One problem we have had repeatedly (could be what you are seeing) deals with DFSORTs use of hiperspaces. It causes the sort to fail when the space DFSORT needs is not available. The following DFSORT override turns off the use of hiperspaces and fixes the problem. [...]
17452 167 27_DB2 UDB LUW Log Miner tools11_Robert Jans26_robert.jans@ALBERTSONS.COM31_Wed, 21 Jun 2006 12:06:55 -0600448_us-ascii We've had one of our application teams tell us they have a requirement the we be able to back out individual transactions. To me, this means I'll need a log miner tool that can construct undo/redo SQL from the DB2 logs. Since I don't have a lot of knowledge of the LUW versions of DB2, I'm open to recommendations of tools to look at. Of course, if any will access DB2 z/OS too, that would be a huge bonus but it's not a requirement. [...]
17620 111 46_Re: v8.2 LUW: Data Error with UNION and EXISTS6_Tzachi20_yassini@BEZEQINT.NET31_Wed, 21 Jun 2006 21:13:33 +0200449_us-ascii Hi,
According to information supplied up to now the culprit is the hardware vendor :-)
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dee Reins Sent: Wednesday, June 21, 2006 6:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] v8.2 LUW: Data Error with UNION and EXISTS
I agree with James. So that would be me too. [...]
17732 195 69_DSN1COPY to restore dropped objects using Full and Incremental copies20_Bruzdzinski, Michael27_Michael.Bruzdzinski@SSA.GOV31_Wed, 21 Jun 2006 14:19:50 -0400695_us-ascii I need some help in understanding how DSN1COPY works when using INCREMENTALS as input.
We recently had a situation where a TABLESPACE was dropped at the request of the applications staff. After a day or two of real production, they wanted it back.
The sequence of events was:
DAY1 IMAGECOPY FULL DAY2 IMAGECOPY INCREMENTAL DAY3 IMAGECOPY INCREMENTAL DAY4 IMAGECOPY INCREMENTAL DAY5 Tablespace dropped. New object definitions added DAY6 IMAGECOPY FULL DAY7 IMAGECOPY INCREMENTAL DAY8 IMAGECOPY INCREMENTAL DAY9 Applications group wants objects back DBA tries to load back from IMAGECOPY datasets using DSN1COPY w/OBIDXLAT starting with the DAY1 Full and DAY2-4 [...]
17928 60 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Wed, 21 Jun 2006 11:30:36 -0700410_us-ascii Alter is not a command, it is a DDL statement. You don't need the '-' in front of it.
Vic
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joe Huang Sent: Wednesday, June 21, 2006 8:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING
Am I missing something ? Thanks Joe [...]
17989 157 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 21 Jun 2006 14:48:07 -0400477_US-ASCII Joe, V7 or V8? Wasnt it created under V7 as NO WLM ENVIRONMENT?
Joe Huang Sent by: DB2 Data Base Discussion List 06/21/2006 11:29 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING
Am I missing something ? Thanks Joe [...]
18147 87 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING0_22_sally.mir@WACHOVIA.COM31_Wed, 21 Jun 2006 15:28:37 -0400474_US-ASCII Isn't that an SQL statement? You're trying to execute it as a DB2 command under the DSN processor.
Sally A. Mir, AVP Wachovia Enterprise Data Management IBM Certified Database Administrator DB2 Universal Database V8.1 for Z/OS (336) 773-4011
Joe Huang To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING [...]
18235 90 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 21 Jun 2006 21:01:58 +0100414_iso-8859-1 It's an SQL statement not a DSN subcommand so it should executed in SPUFI
Phil G CA
________________________________
From: DB2 Data Base Discussion List on behalf of Greuter, Al Sent: Wed 21/06/2006 18:37 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING
I think you have a space before the '-'. Try removing it. [...]
18326 198 24_Re: Reorg/DFSORT problem0_22_sally.mir@WACHOVIA.COM31_Wed, 21 Jun 2006 16:20:55 -0400331_US-ASCII But if you want parallel index build, do not name them SORTWKnn.
Instead, allocate them in pairs, like SW01WK01 and SW01WK02, SW02WK01 and SW02WK02, etc. Each parallel sort task will use a pair of sort works. The number of concurrent parallel tasks will never be greater than the number of pairs of sortworks. [...]
18525 178 54_NE/IA Great Plains DB2 Forum RUG Meeting July 19, 200615_Andersen, Cindy18_candersen@FNNI.COM31_Wed, 21 Jun 2006 16:20:25 -0500364_us-ascii WHAT: Great Plains DB2 Forum Summer Meeting WHEN: Wednesday, July 19, 2006, 8:30 AM - 4:00 PM WHERE: Peter Kiewit Lodge, Eugene T. Mahoney State Park, (Interchange 426 from Nebraska Interstate 80)
COST: Registration fee is $50.00 per person. Registrations must be received by Wednesday, July 12, 2006 to guarantee seating and class materials. [...]
18704 175 45_Re: VERB '-ALTER' REQUIRED KEYWORD IS MISSING11_Joe Lenzini25_joe_lenzini@AHM.HONDA.COM31_Wed, 21 Jun 2006 11:06:45 -0700473_US-ASCII ALTER PROCEDURE is an SQL statement, not a command. Try using SPUFI or DSNTEP2.
Joe Lenzini ISD Mainframe - DB2 Systems
Joe Huang Sent by: DB2 Data Base Discussion List 06/21/2006 08:29 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] VERB '-ALTER' REQUIRED KEYWORD IS MISSING [...]
18880 152 24_Re: Reorg/DFSORT problem19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Wed, 21 Jun 2006 18:25:09 -0400495_us-ascii You need to have DFSORT set We went through all of this...
You need to have DFSORT set up properly to dynamically allocate the workfiles and then you specify SORTDEVT and SORTNUM in your REORG. In our environment, we (finally) got DFSORT setup to make its allocations with a small primary and very large secondary quantity. Beware of the default for dynamic allocations in DFSORT! From the original note below, I see it was only allocating 2 datasets (DYNALOC=(SYSDA,002)). [...]
19033 16 31_Re: DB2 UDB LUW Log Miner tools13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Wed, 21 Jun 2006 16:03:17 -0700564_ISO-8859-1 DB2 Recovery Expert does this. I don't know of any non-IBM tools that can do this.
--------------------------------------------------------------------------------- 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
19050 100 24_Re: Reorg/DFSORT problem10_Paul Fegan33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Thu, 22 Jun 2006 09:26:06 +1000511_us-ascii Thanks All,
Roy, We've found a couple of PTF's that look close to the problem we are seeing but we're not really in a position to put them on. We're in the middle of the V8 upgrade currently CM and about to start the NFM rollout. So at the moment I was hoping to find a work around or a way of reproducing the problem so we can at least we can test the PTF's on the test LPAR. I guess that's the bit that cheeses me off the most a complete inability to lock down exactly what's causing the [...]
19151 423 73_Re: DSN1COPY to restore dropped objects using Full and Incremental copies13_William Huang24_hhuang@DCCSH.ICBC.COM.CN31_Thu, 22 Jun 2006 10:27:06 +0800463_GB2312 Michael,
I think it is expected, if you used COPY SHRLEVEL CHANGE (in fact, I think even SHRLEVEL REFERENCE could make this, but SHRLEVEL CHANGE more suspicious) . DSN1COPY is designed for stand-alone, that is off-line operation, you need to protect data consistency yourself out of DB2 control. Suppose, some data rows changed their resident page, or some dirty rows got copied. I suggest you run CHECK first, and decide which one to discard. [...]