1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2008, week 3 2 38 50_USING TEMPLATE TO EXPRESS A PDS WITH VARIABLE &TS.12_Weishine Kao16_wskao@CPC.COM.TW31_Mon, 15 Sep 2008 10:38:44 +0800400_US-ASCII To whom may concern:

When I tried to unload LOBs, I used TEMPLATE to express a pds with tablespaces as its members for the PUNCHDDN . It looks as below:

TEMPLATE PUNCHDS DSN '&US..&DB..PUNCH(&TS.)' .....

However, it does not work. The jcl will give me the message something like below:

DSNU1032I DSNUGTDS - INVALID QUALIFIER PUNCH(tsname IN TEMPLATE PUNCHDS [...] 41 1023 45_DB2 V9 on Z/OS SQL Stored Procedures Problems22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM31_Mon, 15 Sep 2008 05:15:35 +0000926_-

03SEP08 DB2 APPLICATION TRACE END TIME PLAN AUTHID CONNECT ELAPSED CPU # STMTS GETPAGE REASON ----------- -------- -------- -------- -------- -------- ------- ------- ------ 10:23:28 DISTSERV GENEVAWB SERVER 2,527 ms 301 ms 157 5,639 OK 10:23:47 DISTSERV GENEVAWB SERVER 655 ms 213 ms 111 3,267 OK

STOP.....03SEP 10.23.28.67 PLAN..............DISTSERV TYPE................DBAT START....03SEP 10.23.26.14 AUTHID............GENEVAWB CONNECT......SERVER/DRDA ELAPSED...........2,527 ms ORIG PRIM AUTH....GENEVAWB CORR ID.....db2bp.exe TERM.......DDF TYPE2 INACT COMMITS..................0 ROLLBACKS..............1 ------------------------------------------------------------------------------ RUNTIME ANALYSIS IN DB2 IN APPL. TOTAL %IN DB2(=) TOTAL(*) ---------------- -------- -------- -------- 0 ...25...50...75..100% ELAPSED TIME 1,076 ms 1,451 ms 2,527 ms | ========************ | CPU TIME 290 ms 11 ms [...] 1065 471 94_Antwort: Re: [DB2-L] Antwort: Re: [DB2-L] Looking for tuning paper on DFSORT for DB2 utilities11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 15 Sep 2008 11:42:32 +0200530_iso-8859-1 Hi!

You are, of course, correct, sort technology has not changed but with the forced use of DFSORT for V8 and above suer has changed the picture! If you were a SYNCSORT shop for years and years then all the tuning that you did there was now worthless and the R13 / R14 DFSORT contains a *lot* of extra bells and whistles. In regard to V8 some are critical and some are a waste of time...as always in this business "It Depends".. and as I mentioned the REXX and the IO Tuning bits are still absolutely true! [...] 1537 183 49_Re: DB2 V9 on Z/OS SQL Stored Procedures Problems0_19_askwe@OPTONLINE.NET31_Mon, 15 Sep 2008 11:18:58 +0000363_us-ascii Devyani,

I have just tested the if ( EXISTS (SELECT ...)) then statement1 ... end if; in a native SQL Procedure using our DB2 z/OS V9 and it worked as it was supposed to be: 1. If the result of the EXISTS subquery is non-empty, then statement1 was executed. 2. If the result of the EXISTS subquery is empty, then statement1 was not execited. [...] 1721 23 29_DB2 z/OS Load Delimited file.11_Brian Maday19_maday15@HOTMAIL.COM31_Mon, 15 Sep 2008 08:36:39 -0400 1745 60 29_DB2 z/OS Load Delimited file.11_Brian Maday19_maday15@HOTMAIL.COM31_Mon, 15 Sep 2008 08:36:39 -0400 1806 142 23_Lock-Duration: COMMIT+10_26_Walter.Janissen@ITERGO.COM31_Mon, 15 Sep 2008 15:52:02 +0200416_iso-8859-1 Hi

My monitor (MAINVIEW) tells me, that the lock duration is COMMIT+1:

Database Object Page / Part - Wait Type State Duration XSD39028 XSTSP043 24 NO PART EXCL COMMIT+1

The program issued a dynamic LOCK-statement in exclusive mode. The exclusive lock seems to be kept regardless any commit. The plan is bound with RELEASE DEALLOCATE So i expected a lock-duration of DEALLOCATION [...] 1949 346 33_Re: DB2 z/OS Load Delimited file.13_Bright, Randy20_Randy_Bright@BMC.COM31_Mon, 15 Sep 2008 09:42:31 -0500404_us-ascii Actually, I think the IBM load utility does view an "un-delimited" blank as a null. Try putting single quotes around the blank. Any string in a delimited file that contains a blank should be enclosed in quotes, including a string that is composed entirely of blanks.

Randy Bright Solution Architect DB2 Utilities BMC Software, Inc. Randy_Bright@bmc.com [...] 2296 138 33_Re: DB2 z/OS Load Delimited file.17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Mon, 15 Sep 2008 09:39:14 -0500611_us-ascii Brian

Have you looked at the strip setting for your load? It's default is to remove leading and trailing spaces.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brian Maday Sent: Monday, September 15, 2008 7:37 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2 z/OS Load Delimited file.

Hi all, I am currently on DB2 Version 8 for z/OS (NFM). I am trying to load a delimited file to DB2, the problem I am having is on columns that are NOT NULL I cannot load a blank. For example my file looks similar to this - [...] 2435 91 33_- DB2 and the mystery of IEFSDPPT10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Mon, 15 Sep 2008 17:02:24 +0200342_US-ASCII Esteemed listers It seems that at the end of my DB2 career I found strange things. After UNICODE on demand I discovered that, even if in installation manual is stated differently (you MUST have these modules in PPT ie in SCHEDxx, pag 253 Installation manual, february 2008 edition), you don't need in SCHEDxx following modules: [...] 2527 174 33_Re: DB2 z/OS Load Delimited file.17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Mon, 15 Sep 2008 09:39:14 -0500611_us-ascii Brian

Have you looked at the strip setting for your load? It's default is to remove leading and trailing spaces.

________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Brian Maday Sent: Monday, September 15, 2008 7:37 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2 z/OS Load Delimited file.

Hi all, I am currently on DB2 Version 8 for z/OS (NFM). I am trying to load a delimited file to DB2, the problem I am having is on columns that are NOT NULL I cannot load a blank. For example my file looks similar to this - [...] 2702 298 33_Re: DB2 z/OS Load Delimited file.13_Bright, Randy20_Randy_Bright@BMC.COM31_Mon, 15 Sep 2008 09:42:31 -0500403_us-ascii Actually, I think the IBM load utility does view an "un-delimited" blank as a null. Try putting single quotes around the blank. Any string in a delimited file that contains a blank should be enclosed in quotes, including a string that is composed entirely of blanks.

Randy Bright Solution Architect DB2 Utilities BMC Software, Inc. Randy_Bright@bmc.com [...] 3001 116 58_DB2 z/OS V8 NFM - Security for preparing SQLJ applications11_Hardy, Dale14_DHardy@MIB.COM31_Mon, 15 Sep 2008 12:09:18 -0400596_US-ASCII Greetings,

We are in the process of converting from the JDBC driver for z/OS to the new driver for JDBC and SQLJ in preparation to migrating to V9.

The Application Programming Guide and Reference for Java has a section on Security and allowing users to customize only in which it recommends 3 techniques 1. Create a separate DB2 subsystem for customization only, and then copy the java byte code and serialized profiles to the target system and do the binds. 2. Write a Java stored procedure to do the customizations and binds, or 3. Write a stand-alone program to do [...] 3118 117 54_Re: USING TEMPLATE TO EXPRESS A PDS WITH VARIABLE &TS.11_Nick Dordea20_ndordea@COMPUTER.ORG31_Mon, 15 Sep 2008 11:09:49 -0500603_us-ascii Check if PK28882 applies to your case. nd

PK28882: AL/RDEF TEMPLATE NAME NOT RESOLVING &JO / &JOBNAME RESULTS IN DSNU1032I DSNUGTDS INVALID QUALIFIER RC=8

A fix may be available

Obtain the fix for this APAR



APAR status Closed as program error.

Error description

The DB2 Administration Tool AL/RDEF command builds a TEMPLATE statement without resolving the &JO / &JOBNAME variable which results in a message: DSNU1032I DSNUGTDS - INVALID QUALIFIER aaa IN TEMPLATE aaa DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8 [...] 3236 244 33_Re: DB2 z/OS Load Delimited file.14_Guido Verbraak19_VERBRAAK@NL.IBM.COM31_Mon, 15 Sep 2008 18:33:21 +0200332_US-ASCII Brian,

What you can do to tackle this issue is to use a 2 phase strategy. First you define a table with all columns with default null, this is were you initially load your data into. In the second step you 'fix' the blank issue by using a load from a cursor or an unload and load the data into the final table. [...] 3481 194 58_DB2 z/OS V8 NFM - Security for preparing SQLJ applications11_Hardy, Dale14_DHardy@MIB.COM31_Mon, 15 Sep 2008 12:09:18 -0400494_us-ascii Greetings,

We are in the process of converting from the JDBC driver for z/OS to the new driver for JDBC and SQLJ in preparation to migrating to V9.

The Application Programming Guide and Reference for Java has a section on Security and allowing users to customize only in which it recommends

3 techniques 1. Create a separate DB2 subsystem for customization only, and then copy the java byte code and serialized profiles to the target system and do the binds. [...] 3676 352 33_Re: DB2 z/OS Load Delimited file.14_Guido Verbraak19_VERBRAAK@NL.IBM.COM31_Mon, 15 Sep 2008 18:33:21 +0200340_us-ascii

Brian,

What you can do to tackle this issue is to use a 2 phase strategy. First you define a table with all columns with default null, this is were you initially load your data into. In the second step you 'fix' the blank issue by using a load from a cursor or an unload and load the data into the final table. [...] 4029 326 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Mon, 15 Sep 2008 20:26:36 +0200530_US-ASCII Dale,

In our shop, SQLJ customization is part of the Websphere Deployment process. The deployers install new versions of the Websphere applications and also perform the SQLJ Customization. We have setup a procedure to unpack, customize and repack the customized .ser-files in a .jar. The .jar needs to be installed in the appropriate LIB path in Websphere. The deployers do not have to have any other authorization than BINDAGENT on behalf of the owner/creator of the packages and tables. Works great for us. [...] 4356 320 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Mon, 15 Sep 2008 20:26:36 +0200530_us-ascii Dale,

In our shop, SQLJ customization is part of the Websphere Deployment process. The deployers install new versions of the Websphere applications and also perform the SQLJ Customization. We have setup a procedure to unpack, customize and repack the customized .ser-files in a .jar. The .jar needs to be installed in the appropriate LIB path in Websphere. The deployers do not have to have any other authorization than BINDAGENT on behalf of the owner/creator of the packages and tables. Works great for us. [...] 4677 119 57_Delete from parent causing full-table scan of child table15_Bruce MacDonald24_Bruce.MacDonald@BCAA.COM31_Mon, 15 Sep 2008 15:01:28 -0700338_us-ascii Hi all,

We're running 9.1.4 on AIX. We're finding cases where deleting a single row by PK in the parent table causes a full-table scan of the child table (which, alas, has 16 million+ rows), even though the FK column in the child table is indexed. In most cases there wouldn't be any matching row in the child table. [...] 4797 85 61_Re: Delete from parent causing full-table scan of child table14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Mon, 15 Sep 2008 22:59:46 -0400350_us-ascii Hi Bruce, Just checking. DB2 needs to have the FK index START with the FK column(s):

If parent PK is T1.A, then foreign key index should be on T2(A) or on T2(A,B,C) but NOT on T2(B,A,C).

If compound parent PK is T1.A,B, then foreign key index should be on T2(A,B) or on T2(A,B,C) but NOT on T2(B,A,C) or NOT on T2(C,A,B). [...] 4883 270 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications11_Hardy, Dale14_DHardy@MIB.COM31_Tue, 16 Sep 2008 09:52:03 -0400615_US-ASCII Your procedure sounds similar to how we did it with the legacy driver.

But our experience with the new driver, we found BINDAGENT was insufficient because the deployer also had to have privileges on the tables just for the customization step.

I should add that used to bind our DBRMs to multiple packages and found this was no longer possible with the new driver because the customization step embeds the collection name into the .ser and DBRMs. Then the DBRM could only be bound to collection specified in the customization and then copybind to other collections. Since the DBRMs could [...] 5154 48 27_Bookmanager CDs and readers12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Tue, 16 Sep 2008 17:28:26 +0100351_ISO-8859-1 I access all IBM manuals through the internet these days but colleagues who are out on site somtimes don't have that available. They are currently using very old copies of the CDs and the library reader. Where can we get hold of up to date copies of the Bookmanager manuals and what is the best software to read the CDs with nowadays. [...] 5203 210 43_DB2 UDB LUW on Windows - Fixpack 16 Upgrade15_Schade, Jeffrey15_JSchade@ISO.COM31_Tue, 16 Sep 2008 12:29:23 -0400405_US-ASCII We recently upgraded our DB2 UDB Version 8 software on a windows platform from Fix pack 8 to Fix pack 16 and we have noticed that all our backups (full and incremental) are taking much longer. It appears that in all cases the kilobytes being processed has more than doubled. I am not sure where to look and was hoping that someone on the list might be able to shed some light on this issue. [...] 5414 97 31_Re: Bookmanager CDs and readers16_Michael A Wendel19_mawendel@US.IBM.COM31_Tue, 16 Sep 2008 10:26:00 -0700384_US-ASCII Hi Jim,

Beginning October 6, you'll be able to order an installable Information Center that will have product documentation for DB2 for z/OS Version 8 and Version 9, IMS Version 9 and Version 10, a very large number of IBM DB2 and IMS Tools, DB2 QMF Version 8 and Version 9, and the current versions of WebSphere Replication Server and WebSphere Event Publisher. [...] 5512 299 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade20_Stritzinger, David G25_david.stritzinger@EDS.COM31_Tue, 16 Sep 2008 13:29:29 -0400336_us-ascii Jeff,

Not sure if this is your issue or not. Check out APAR IY73645. It talks about backups taking longer when going from V8.1 (fix pack 6 or earlier) to V8.2. I went to the DB2 support page and did a search for terms "backup v8". The APAR has a "key" in front of it, so you will need a IBM customer id to view it. [...] 5812 87 31_Re: Bookmanager CDs and readers10_Dave Churn19_davechurn@GMAIL.COM31_Tue, 16 Sep 2008 13:06:42 -0500137_ISO-8859-1 Jim,

Would it be easier to have your colleagues download the .pdf versions of the manuals and use Adobe Reader?

5900 157 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade0_22_pgunning@GUNNINGTS.COM31_Tue, 16 Sep 2008 18:26:33 +0000377_utf-8 If you have db2_parallel_io enabled try unsetting it and try again. I saw this problem with 9.5. Might not be same issue though. Pg Sent via BlackBerry by AT&T

-----Original Message----- From: "Schade, Jeffrey"

Date: Tue, 16 Sep 2008 12:29:23 To: Subject: [DB2-L] DB2 UDB LUW on Windows - Fixpack 16 Upgrade [...] 6058 188 30_SQL Update problem DB2 v8 Z/os10_Mark Stone17_mastone@GMAIL.COM31_Tue, 16 Sep 2008 11:42:07 -0700701_ISO-8859-1 Morning everyone, I'm looking for some guidance on how to solve this problem. I have a complex subquery that identifies rows for update, it uses a materialized join to identify items (duplicate items inserted due to an invalid primary key).



select y*.*CLAIM_ID*,* y*.*LINE_NBR*,* y*.*PRIORITY*,* max*(*y*.*LASTUPDT*)*as LASTUPDT from fdbmd*.*reason Y INNER JOIN *(* select CLAIM_ID*,* LINE_NBR*,* PRIORITY*,* COUNT*(*)* from fdbmd*.*reason group by CLAIM_ID*,* LINE_NBR*,* PRIORITY having count*(*)* *>* 1*)* AS X ON Y*.*CLAIM_ID *=* X*.*CLAIM_ID AND Y*.* LINE_NBR *=* X*.*LINE_NBR AND Y*.*PRIORITY *=* X*.*PRIORITY group by y*.*CLAIM_ID*,* y*.*LINE_NBR*,* y*.*PRIORITY [...] 6247 135 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade15_Schade, Jeffrey15_JSchade@ISO.COM31_Tue, 16 Sep 2008 14:57:41 -0400559_US-ASCII Thanks David I will check out this APAR.

Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering

ISO 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Stritzinger, David G Sent: Tuesday, September 16, 2008 1:29 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 UDB LUW on Windows - Fixpack 16 Upgrade [...] 6383 403 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade15_Anupama Chiluka29_achiluka@REMOTEDBAEXPERTS.COM31_Tue, 16 Sep 2008 14:55:50 -0400482_us-ascii Hi Jeff, I had a similar issue but not after upgrading.

The issue I had was the backup image file (last modified timestamp for example 3.15am) and backup script successfully finished time (from db2diag.log for example 4.00am) were different and were about 25min apart. If that is the similar situation you might to look at the history file (how big it is ) and purge the history file using PRUNE HISTORY. By doing so that brought the backup time down by 30min. [...] 6787 519 34_Re: SQL Update problem DB2 v8 Z/os13_David Simpson22_dsimpson@THEMISINC.COM31_Tue, 16 Sep 2008 15:01:56 -0400516_us-ascii DB2 V7 introduced row value expressions for this...





UPDATE FDBMD.REASON

SET

WHERE (CLAIM_ID, LINE_NBR, PRIORITY, LASTUPDT) IN

< insert your select here >





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Stone Sent: Tuesday, September 16, 2008 1:42 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] SQL Update problem DB2 v8 Z/os [...] 7307 153 31_Re: Bookmanager CDs and readers14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 16 Sep 2008 20:08:40 +0100430_us-ascii Ooh ooh

He said "Version 10" :)

Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com

Ditton Park Riding Court Road Datchet Slough SL3 9LL

CA plc a company registered in England and Wales under company registration number 1282495 with its registered office at the address set out above. VAT number 697904179. [...] 7461 20 31_Re: Bookmanager CDs and readers0_19_zmeyer@BEZEQINT.NET31_Tue, 16 Sep 2008 22:17:39 +0300771_us-ascii But only for IMS ... DB2 is still VX ...

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________





The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms 7482 184 31_Re: Bookmanager CDs and readers14_Peter Backlund21_BacklundDB2@TELIA.COM31_Tue, 16 Sep 2008 21:21:08 +0200 7667 180 31_Re: Bookmanager CDs and readers12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 16 Sep 2008 22:26:44 +0300539_UTF-8 Hi

He said it for IMS - however, IMS V11 has been announced now :-)

Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Tuesday, September 16, 2008 10:09 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Bookmanager CDs and readers

Ooh ooh

He said "Version 10" :)

Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com [...] 7848 559 31_Re: Bookmanager CDs and readers14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 16 Sep 2008 20:41:30 +0100499_us-ascii Apologies to all

Not reading eMails properly tonight :(

Time to stop work for the day I think

Phil Grainger CA Senior Principal Product Manager Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com

Ditton Park Riding Court Road Datchet Slough SL3 9LL

CA plc a company registered in England and Wales under company registration number 1282495 with its registered office at the address set out above. VAT number 697904179. [...] 8408 39 25_DB2 Java Universal Driver27_peggy.donovan@citigroup.com27_peggy.donovan@CITIGROUP.COM31_Tue, 16 Sep 2008 19:54:17 +0000627_utf-8 I've set up a test application for the jcc driver & java 5.0. I can get everything to work using collection NULLID for both the appication & driver. Am trying to define separate collection by application. But then the jcc driver pacages default to application collection as package ....ACMDB2T.SYSSTAT... not found; instead of looking for ....NULLID.SYSSTAT..... currentPackageSet seems to be a java code thing. I want a driver default/override. I set up a unicode DB2JccConfiguration.properties in the folder where I build the jar. & the WLM JAVAENV JVMPROPS option is set. The compile / jar batch job now seems to [...] 8448 20 31_Re: Bookmanager CDs and readers27_peggy.donovan@citigroup.com27_peggy.donovan@CITIGROUP.COM31_Tue, 16 Sep 2008 19:56:30 +0000773_utf-8 I've downloaded the necessary manuals to our LAN for everyone's use. Would that work in your site?

______________________________________________________________________

* IDUG 08 Warsaw, Poland * 13-17 October 2008 * http://IDUG.ORG/lsEU * ______________________________________________________________________





The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no [...] 8469 194 31_Re: Bookmanager CDs and readers11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Tue, 16 Sep 2008 16:18:35 -0400430_us-ascii I still say it should be version A

bb x6674





For manuals, papers, sample docs, tips and coding standards for databases please visit Database Depot. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Tuesday, September 16, 2008 3:09 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Bookmanager CDs and readers [...] 8664 226 31_Re: Bookmanager CDs and readers14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Tue, 16 Sep 2008 15:31:15 -0500421_us-ascii Sorry, but "REAL" programmers code in binary.

Should be - V00001010

Faz (hoping for Friday)

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bear, Brian Sent: Tuesday, September 16, 2008 3:19 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Bookmanager CDs and readers

I still say it should be version A

bb x6674 [...] 8891 258 39_Fw: [DB2-L] Bookmanager CDs and readers16_Michael Z Mandes25_Michael.Z.Mandes@AEXP.COM31_Tue, 16 Sep 2008 13:35:51 -0700457_us-ascii That reminds me.

There are 10 kinds of people in the World, those who undersdand BINARY and those who don't.



Thanks,

Mike Mandes 1 602 537 2310 ----- Forwarded by Michael Z Mandes/NonAEXP/TRS/AEXP on 09/16/2008 01:34 PM -----

"Bear, Brian" To Sent by: DB2 Data DB2-L@www.idugdb2-l.org Base Discussion cc List Re: [DB2-L] Bookmanager CDs and readers [...] 9150 247 31_Re: Bookmanager CDs and readers11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Tue, 16 Sep 2008 17:13:33 -0400662_us-ascii OR

V11000001 (ebcdic letter A)



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Fazio, Richard Sent: Tuesday, September 16, 2008 4:31 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Bookmanager CDs and readers

Sorry, but "REAL" programmers code in binary.

Should be - V00001010

Faz (hoping for Friday)

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bear, Brian Sent: Tuesday, September 16, 2008 3:19 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Bookmanager CDs and readers [...] 9398 100 31_Re: Bookmanager CDs and readers0_25_jacampbell@ACSLINK.NET.AU31_Wed, 17 Sep 2008 08:11:59 +1000363_US-ASCII To nail my colours to the mast, phasing out the BookManager format for DB2 for z/OS publications is a retrograde move. There is a area of information gathering where Book Manager beats PDF hands down. Because Information Centers are such large beasts [sic] I am not yet convinced that they will not have their own problems compared to Book Manager. [...] 9499 130 31_Re: Bookmanager CDs and readers13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 16 Sep 2008 16:18:14 -0700569_us-ascii Hear hear! 99% of my searches in bookmanager are for multiple words in the same topic but not necessarily together -- when is acrobat going to be able to do that? People I've talked to like PDF because they like to print manuals. Bookmanager discourages that by using such an ugly print format -- perhaps we should force all publishers to use Bookmanager and save untold forests. As for the Information Center, I cannot say anything nice about it so I won't say anything at all; I especially won't complain about how slow it is and how it returns useless [...] 9630 363 34_Re: SQL Update problem DB2 v8 Z/os10_Mark Stone17_mastone@GMAIL.COM31_Tue, 16 Sep 2008 16:54:40 -0700653_WINDOWS-1252 David, thanks for illuminating me, that does the trick perfectly.

On Tue, Sep 16, 2008 at 12:01 PM, David Simpson wrote:

> DB2 V7 introduced row value expressions for this… > > > > UPDATE FDBMD.REASON > > SET > > WHERE (CLAIM_ID, LINE_NBR, PRIORITY, LASTUPDT) IN > > < insert your select here > > > > ------------------------------ > > *From:* DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] *On > Behalf Of *Mark Stone > *Sent:* Tuesday, September 16, 2008 1:42 PM > *To:* DB2-L@www.idugdb2-l.org > *Subject:* [DB2-L] SQL Update problem DB2 v8 Z/os > [...] 9994 75 31_Re: Bookmanager CDs and readers9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Tue, 16 Sep 2008 17:18:57 -0700440_utf-8 I prefer Bookmanager to PDF or InfoCenter, I think the search capabilities a far superior. I have been to a lot of sites where Internet is not readily available, so you need a copy of the manuals on your laptop.

Here is the web site to download the Java Softcopy reader http://www-01.ibm.com/support/docview.wss?doc=4001220&org=SW&rs=4 This is pretty good as you can use Bookmanager (boo) or PDF manuals (extended shelf). [...] 10070 142 43_Re: Fw: [DB2-L] Bookmanager CDs and readers13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Wed, 17 Sep 2008 08:52:22 +0100328_us-ascii I like it! Pity I don't get it. I guess I'm one of the 5 kinds wot don't get binary...

And Phil, don't feel so bad. I listened in on John Campbell's DB2 9 Migration Experiences teleconference call. If he said, 'DB2 version 10' once he said it 5 times. So, sooner or later, the code 'DB2 X' will be cracked. [...] 10213 47 50_Luis Henrique Maciel da Rosa is out of the office.0_16_luish@BR.IBM.COM31_Wed, 17 Sep 2008 10:01:10 -0300516_US-ASCII

I will be out of the office starting 17/09/2008 and will not return until 22/09/2008.

ITIL training duirng the day. I will read and answer the messages at night.

Please, contact ellendf@br.ibm.com, mariojs@br.ibm.com, yahel@br.ibm.com

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA * ______________________________________________________________________





10261 40 23_HOADB2UG Training Offer18_Sandra Lakenburger27_sandra.lakenburger@USDA.GOV31_Wed, 17 Sep 2008 13:56:06 +0000480_utf-8 Fellow DB2 Users,

The Heart of America DB2 Users Group is proud to offer training with Sheryl Larsen next week, on Monday and Tuesday (September 22-23). This training is being held at the IBM office at 2345 Grand Ave, Kansas City, MO. The class titles are listed below. If there is a topic that you would like Sheryl to cover during the training, please send the topic to president@hoadb2ug.org and I will pass it along. The price for each day of class is $325. [...] 10302 221 31_Re: Bookmanager CDs and readers11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Wed, 17 Sep 2008 10:24:43 -0400325_US-ASCII I am running "Google Desktop" on my XP laptop. It indexes .pdf files (among everything else including emails) for you. So I can key in any search term and it will find it on my local disks as well as the internet. You can limit the search via the advanced option to just specific directories or file types, etc [...] 10524 46 42_[DB2z] Granting SYSADM to a Vendor Product14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 17 Sep 2008 10:34:30 -0400424_us-ascii Dear Esteemed List:

I couldn't find a good answer in the archives, so I am asking the List for their experiences.

We have installed several IBM Portal products on AIX that access DB2z. The product has an "authoring" function (among others) that (simplified) issues CREATEs for hundreds of objects. The documentation specifies that the auth-ID used by the product should be GRANTed SYSADM access. [...] 10571 128 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 17 Sep 2008 10:56:36 -0400591_US-ASCII Hi Anupama,

I am checking the history file and we do have archive log information that goes back to September 2007 so the PRUNE command may help.

I checked the backups and since the upgrade the KILOBYTES being backed up has seriously increased for both incremental and full backups so that explains why the runtimes have extended. The question is what caused the additional bytes in the backup. We have also noticed that the number of logs files being generated has increased so the backup timings may be a symptom for some other issue. I have to keep looking to [...] 10700 40 23_Cloning a DB2 Subsystem0_29_Pat.Mcmanus@MUTUALOFOMAHA.COM31_Wed, 17 Sep 2008 10:16:01 -0500565_us-ascii In preparation for DB2 9 I would like to clone my production subsystem to a test lpar. The thought behind this is to be able to perform binds and check the optimizer for access path changes, run queries, etc... What I need to do is basically clone the directory and catalog only without moving all of the application related objects. I would like to be able to do this renaming the subsystem and the VSAM datasets if possible. I've never attempted this and so I'm looking for anyone who can lend some of the experiences they have gone through getting [...] 10741 163 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 17 Sep 2008 12:08:01 -0400552_us-ascii Jeff, sounds like you have seriously increased the amount of data being backed up, which would cause increase in backup time, all things being equal. Of course there are many ways to tune backup so you might need to do that after figuring out your increase in data problem. What was the size in GB before and what is it now? In a lot of field experience, I have not seen any problems with backup whether using 8.1 or 8.2 any fixpak. The problem that I found in 9.5 related to db2_parallel_io probably doesn't apply in this case since you [...] 10905 99 46_Re: [DB2z] Granting SYSADM to a Vendor Product7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 17 Sep 2008 10:07:30 -0700373_us-ascii I can see the need for DBADM. The only object, off the top of my head, that SYSADM can do that DBADM can't, is create database.

Do these guys want to create databases on the fly - as in CREATE DATABASE Loser etc.?

Can you compromise by offering DBADM? Edward Long



--- On Wed, 9/17/08, Lyon, Lockwood wrote: [...] 11005 192 45_DB2 Version 8 - z/OS - Access path difference15_Moss, William R15_MossW@AETNA.COM31_Wed, 17 Sep 2008 13:26:01 -0400422_us-ascii I have this simple SQL that gives me two different access paths depending on how it's bound.



SELECT A.RXSY_MEMBER_ID ,A.PIN FROM GRX5P0BD.T502400 A WHERE A.EOB_PER_START_DT = :H AND EXISTS (SELECT B.RXSY_MEMBER_ID FROM GRX2P0BD.T200600 B WHERE A.RXSY_MEMBER_ID = B.RXSY_MEMBER_ID AND (B.CLIENT_ID = 904 OR B.CLIENT_ID = 400) AND B.EFFECTIVE_DATE <= :H AND B.TERM_DT >= CURRENT DATE - 2 YEARS) [...] 11198 88 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 17 Sep 2008 13:31:14 -0400398_us-ascii Ed,

Thanks for your reply.

The product does CREATE everything: DB, TS, Table, and VIEWs. If I recall correctly (not completely sure, just after lunch here, getting sleepy) even with DBADM you can't CREATE a View even if you are the Owner/Creator of the Table.

At any rate, we tried DBADM and it wasn't enough. IBM insists that "SYSADM is required". Unbelievable. [...] 11287 22 46_Re: [DB2z] Granting SYSADM to a Vendor Product11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 17 Sep 2008 18:00:46 +0000760_- >At any rate, we tried DBADM and it wasn't enough. IBM insists that "SYSADM is required". Unbelievable.

Ask them to document why, and take that to the auditors. - Too busy driving to stop for gas!

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA * ______________________________________________________________________





The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG [...] 11310 226 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 17 Sep 2008 14:01:38 -0400572_US-ASCII Hi Phil,

The full backup Kilobytes went from 67 million to 117 million and the incremental backups went from between 1 and 5 million to 26 to 66 million kilobytes. This happened immediately after the upgrade and has remained consistently higher and we are having trouble staying in our backup window. I am trying to find something that changed with regards to logging or the backup utility. I figure if something in the tables changed with the upgrade then after the first full backup was run the incremental would return to normal but they have not. [...] 11537 77 46_Re: [DB2z] Granting SYSADM to a Vendor Product16_Lance D Ziegler125_Lance.D.Ziegler1@AEXP.COM31_Wed, 17 Sep 2008 11:23:14 -0700 11615 57 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 17 Sep 2008 14:34:53 -0400657_us-ascii Ted,

Good point, and that appeases the auditors. (Has your shop installed this product?)

Now, how about the aesthetics? As other posters have pointed out, there appear to be workable authority solutions that don't require SYSADM. Why can't IBM document these requirements instead?

Personally, I categorically *refuse* to allow SYSADM access to anything issuing SQL I don't see or control. There's too much of a potential for creating objects we haven't planned for or can't support. What about SMS storage groups in place? DASD allocation? VPool assignments? Object naming Standards? Approved use of objects (like LOBs)?. [...] 11673 66 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 17 Sep 2008 14:47:59 -0400585_us-ascii Lance,

Yes, I've been through this before as well. Your point(s) about alternative authorization strategies are well-taken.

The question remains: Has anyone on the list installed the IBM Portal product, encountered the "SYSADM is required" issue, and dealt with it?

Lock Lyon Fifth Third Bancorp





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lance D Ziegler1 Sent: Wednesday, September 17, 2008 2:23 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] [DB2z] Granting SYSADM to a Vendor Product [...] 11740 254 47_Re: DB2 UDB LUW on Windows - Fixpack 16 Upgrade12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Wed, 17 Sep 2008 15:23:27 -0400531_us-ascii Ok, sounds like you are on the right track. I have had many experiences with non-SQL related problems initially reported as being related to upgrades/migrations/64-bit but after a lot of work have usually not found that to be the case. Good luck, Phil

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schade, Jeffrey Sent: Wednesday, September 17, 2008 2:02 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 UDB LUW on Windows - Fixpack 16 Upgrade [...] 11995 49 49_Re: DB2 Version 8 - z/OS - Access path difference13_Jack Campbell23_jackrcampbell@YAHOO.COM31_Wed, 17 Sep 2008 19:36:24 +0000340_utf-8 Bill

it would appear that the access path is been changed due to the available statistics - in this case for column (B.CLIENT_ID). DB2 holds both cardinality (number of unique values) and distribution stats (top 10 values). As B.CLIENT_ID is the first column of the index DB2 will have distirubtion stats for this column. [...] 12045 105 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Avram Friedman25_IBMsysProg@GEEK-SITES.COM31_Wed, 17 Sep 2008 19:55:35 +0000532_utf-8 Granting a Portals authid systems administrator authority for DB2 on z/os does not seem unreasonable to me.

Making the system administrator the systems administrator is a very simple identy function.

Portals is designed to administor may diffrent data store environments with the objective of developing and maintaining applications..

Perhaps a group in the firm chose a product that performs a service that the firm really does not want. If you want the service then SYSADM authority is reasonable. [...] 12151 26 46_Re: [DB2z] Granting SYSADM to a Vendor Product0_24_carol.sutfin@REGIONS.COM31_Wed, 17 Sep 2008 14:56:32 -0500 12178 98 27_Re: Cloning a DB2 Subsystem14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 17 Sep 2008 16:06:47 -0400369_us-ascii Pat, Simple, then -- you need to have non-shared DASD and catalogs for your test LPAR -- essentially a whole different box. Do a backup which captures all your DB2 catalog, directory, ZPARM, and vendor code, and load it to the target LPAR, don't forget to duplicate the subsystem definitions that your system programmer laid down in the z/OS environment. [...] 12277 30 27_Re: Cloning a DB2 Subsystem18_Sandra Lakenburger27_sandra.lakenburger@USDA.GOV31_Wed, 17 Sep 2008 20:13:08 +0000449_utf-8 Pat,

Do you really need to rename the new subsystem? If not, your DR procedures may allow you to restore the subsystem to another lpar and effectively clone it that way. If you do, I've got some procedures that I used several years ago in v7 to do a subsystem rename that didn't use any of the vendor products that are out on the market today that do this. Let me know if you'd like to see them and I'll send what I've got to you. [...] 12308 29 47_Offloading the Archive log to high density Tape11_Mukesh Jain21_jain.mukesh@AOINS.COM31_Wed, 17 Sep 2008 20:09:09 +0000410_utf-8 Hi, I would like to offload the DB2 log to High Density tape for sending it to offsite. Currently we are offloading it to 3480 and sending it to offsite. But since the high density tapes are 100 GB or more. How can we merge all the DB2 archive log(for all the DB2 subsytems) onto one tape and send it to offsite. Because we don't have HSM so we can't offload it to disk and then migrate it to tape. [...] 12338 79 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Wed, 17 Sep 2008 16:41:33 -0400507_us-ascii Avram,

You note that "Making the system administrator the systems administrator is a very simple identy function.". I don't think this is happening. I think this is "making the application the systems administrator".

I agree that GRANTing "the authority to create required objects for the application/product" is reasonable.

I also believe that GRANTing "the authority to CREATE *any* object, DROP *any* object, and GRANT SYSADM to *any* auth-ID" is utterly unreasonable. [...] 12418 51 51_Re: Offloading the Archive log to high density Tape13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 17 Sep 2008 13:42:18 -0700349_us-ascii Hi Mukesh. Every day, we copy the previous day's archive log files onto a single high density tape to ship off site. At the D/R hot site, if an archive log were needed, we would copy the two files to a physical 3490 tape that was relabeled with the correct volser. So far we've never needed to access an archive log at a D/R exercise. [...] 12470 26 46_Re: [DB2z] Granting SYSADM to a Vendor Product11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Wed, 17 Sep 2008 21:51:54 +0000443_- >Good point, and that appeases the auditors. (Has your shop installed this product?)

No. But, any product that needs greater than normall access has to have two things documented:

1. The business justification, and corporate sponsor. 2. The vendor's explanation as to why the special priviledges are required. This is regardless of whether it's SYSADM, RACF Operations, Trusted, etc... - Too busy driving to stop for gas! [...] 12497 178 46_Re: [DB2z] Granting SYSADM to a Vendor Product7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 17 Sep 2008 15:15:59 -0700394_utf-8 After reading Avram's review, may I suggest you consider, if forced to provide SYSADM, that, at a minimum, you require that they have their own subsystem(s).

Even though, in Avram's and others' view, sysadm might be ok; I can see a SOX audit item every visit. Why does IBM's product need to be able to drop my production payroll database? What controls exist to prevent this? [...] 12676 126 51_Re: Offloading the Archive log to high density Tape0_24_carol.sutfin@REGIONS.COM31_Wed, 17 Sep 2008 17:54:38 -0500339_US-ASCII I have a cobol program that actually generates the JCL to use DFDSS to copy the archive logs and bootstrap datasets from DASD to tape for the last 24 hours. It uses a print of the BSDS and a single entry table to store the last copied archive file. It also generates the JCL to copy the datasets back to DASD at the DR site. [...] 12803 92 51_Re: Offloading the Archive log to high density Tape0_24_carol.sutfin@REGIONS.COM31_Wed, 17 Sep 2008 18:14:49 -0500330_US-ASCII I have a cobol program that generates the JCL to use DFDSS to copy the archive logs and bootstrap datasets from DASD to tape for the last 24 hours. It uses a print of the BSDS and a single entry table to store the last copied archive file. It also generates the JCL to copy the datasets back to DASD at the DR site. [...] 12896 263 46_Re: [DB2z] Granting SYSADM to a Vendor Product14_Avram Friedman25_IBMsysProg@GEEK-SITES.COM31_Thu, 18 Sep 2008 00:57:06 +0000359_utf-8 I think I did not express my self clearly.

There is a class of problems in logic that include the following True or false the big striped elephant in the corner is eating red white and blue penuts. What does false mean that there is a big stripped elephant in the corner but it is not eating ....? That is there is an elephant in the corner [...] 13160 221 27_Re: Cloning a DB2 Subsystem13_Michael Ebert18_mebert@AMADEUS.COM31_Thu, 18 Sep 2008 09:29:44 +0200371_ISO-8859-1 I have placed a JCL to do a "Homogeneous System Copy" (SAP terminology for a subsytem clone&rename) in The Code Place on www.idug.org some years ago (for V7). You probably won't be able to use it 1:1, but it should be enough to get you started.

Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 13382 366 62_Antwort: [DB2-L] DB2 Version 8 - z/OS - Access path difference11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 18 Sep 2008 10:43:26 +0200406_iso-8859-1 I would also suspect "bad" syscoldist data could be involved. Remember that nothing gets deleted from SYSCOLDIST anymore unless you do a 0 0 type runstats. Do a select from SYSCOLDIST for this table and check the timestamps...if you see anything horrible then simply delete *all* the data from syscoldist for this table and re-run a full runstats with KEYCARD etc etc and then try again... [...] 13749 64 46_Re: [DB2z] Granting SYSADM to a Vendor Product0_25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Sep 2008 20:55:55 +1000318_US-ASCII To play a little Devil's Advocacy - do you have products like RC/Migrator or Change Manager? Why do you think they sit in an APF authorised library? It's so they can tell RACF/ACF2/TopSecret to create a security environment for any userid they want to be. SYSADM? No password? No problems - I trust you. [...] 13814 580 49_Re: DB2 Version 8 - z/OS - Access path difference0_25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Sep 2008 20:55:55 +1000504_ISO-8859-1 Basic problem is the AND (... OR ...) predicate.

Try

AND B.CLIENT_ID IN (904,400)

or

AND EXISTS (SELECTB.RXSY_MEMBER_ID FROM GRX2P0BD.T200600 B WHERE A.RXSY_MEMBER_ID = B.RXSY_MEMBER_ID AND B.CLIENT_ID = 904 AND B.EFFECTIVE_DATE <= :H AND B.TERM_DT >= CURRENT DATE - 2 YEARS UNION SELECTB.RXSY_MEMBER_ID FROM GRX2P0BD.T200600 B WHERE A.RXSY_MEMBER_ID = B.RXSY_MEMBER_ID AND B.CLIENT_ID = 400 AND B.EFFECTIVE_DATE <= :H AND B.TERM_DT >= CURRENT DATE - 2 YEARS) [...] 14395 37 163_ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy14_Vineet Chauhan25_chauhan.vineet1@GMAIL.COM31_Thu, 18 Sep 2008 11:17:01 +0000426_UTF-8 Hi I have enabled the trackmod using the following steps

db2 update db cfg for using trackmod on db2 backup db online to db2 backup db online incremental to

But i m getting the following error

ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy [...] 14433 81 167_Re: ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy20_Stritzinger, David G25_david.stritzinger@EDS.COM31_Thu, 18 Sep 2008 08:49:16 -0400545_us-ascii You do not have the "immediate" clause on the update statement, therefore the change will not take effect till the data base is stopped and started. I am not sure if trackmod can be done immediate or not.

You should not have to re-start the whole DB2 instance. Just stop all connections to the data base and if you did a db2 activate database , then make sure you do a db2 deactivate database . Once the database is deactivate, the first connection will activate the database and the change should now be in effect. [...] 14515 125 46_Re: [DB2z] Granting SYSADM to a Vendor Product0_19_mike.holmans@BT.COM31_Thu, 18 Sep 2008 14:27:12 +0100347_us-ascii Well, we have had RC/Migrator installed for years, but you don't have to allow it permanent SYSADM.

We don't allow it to use the .AUTH facility to switch userids - it always has to do a SET CURRENT SQLID to switch, and can therefore only do so if the userid running the thing has permission to switch to whatever SQLID it is. [...] 14641 166 46_Re: [DB2z] Granting SYSADM to a Vendor Product11_Chris White18_crick616@YAHOO.COM31_Thu, 18 Sep 2008 13:53:26 +0000535_utf-8 I think Mike is on the right track here. We have a similar approach with Migrator. Here’s another thing to consider… many of these super-powerful tools are almost absolutely necessary in a development environment, but less necessary in a production environment. One can make a strong case for creating ONLY in the first stage development environment (sometimes called Unit Test) and then migrating those objects to the higher environments. With this kind of methodology, you might NEVER create a database in Production. [...] 14808 158 46_Re: [DB2z] Granting SYSADM to a Vendor Product13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 18 Sep 2008 09:08:36 -0500580_us-ascii Just a couple thoughts...

For starters I've had to fight this battle a handful of times in the past - not with this particular product, but with other vendor products. It's not all that uncommon for a vendor product to not want to spend the time working to understand what minimal security might be needed and it's easier to just say "we need SYSADM" - then they don't need to worry about it. In the past we have been successful at pushing back on this due to the potential impact from an availability standpoint. Setting security aside (ignoring data access [...] 14967 447 57_AW: [DB2-L] DB2 Version 8 - z/OS - Access path difference0_26_Walter.Janissen@ITERGO.COM31_Thu, 18 Sep 2008 16:19:56 +0200485_iso-8859-1 Bill

I wonder, if the replacement of the literals was the only change, you did. When I look at your explain, is it correct that the header M_T means: method. And if this is right, then 1 in the the second line means nested loop. That makes sense, because DB2 changed the correlated subquery into a join. But in the second explain, the join disappeared, so that it seems to me, the correlated subquery disappeared, may be, it was changed to a non-correlated one. [...] 15415 58 167_Re: ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy15_Anupama Chiluka29_achiluka@REMOTEDBAEXPERTS.COM31_Thu, 18 Sep 2008 10:22:05 -0400448_us-ascii Yes it requires restart.

Thanks Anupama Chiluka

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Vineet Chauhan Sent: Thursday, September 18, 2008 7:17 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy [...] 15474 29 46_Re: [DB2z] Granting SYSADM to a Vendor Product11_Ted MacNEIL18_eamacneil@YAHOO.CA31_Thu, 18 Sep 2008 14:21:13 +0000414_- >The impact of an uncontrolled SYSADM ID doing "whatever it wants" in our environment would be very unappealing.

You make it sound like the vendor is going to do something malicious with their code & authority! No reputable vendor is going to do that.

But, you are right about one thing. Always push back when the vendor says "I must have that priviledge". At least get the reason documented! [...] 15504 106 49_Re: DB2 Version 8 - z/OS - Access path difference13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 18 Sep 2008 14:37:01 +0000395_utf-8 Hi Bill,

There is a discrepancy in the explain outputs you have below. In the 2nd explain, you can't have 2 separate steps for the same query block (QB=1) with the same plan number (PLNO=1) and METHOD=0. Also, you can't access T200600 first in the join sequence (as the 2nd explain shows) and get 3 matching columns - since the 2nd matching column comes from a join predicate. [...] 15611 38 24_Drain on Index for Alter15_Steve Schuering31_steven.schuering@EXELONCORP.COM31_Thu, 18 Sep 2008 15:20:38 +0000293_utf-8 We are on DB2 v7. Recently we attempted to turn the copy flag on for a set of indexes. Some of the Alters failed with a -904 when the drain timed out. Why does it need a Drain on the Index?

ALTER INDEX P.C03T06X1 COPY YES ;

SQLERROR ON ALTER COMMAND, EXECUTE FUNCTION [...] 15650 537 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Thu, 18 Sep 2008 20:17:28 +0200521_us-ascii Do you use ONLINECHECK YES at customization? If so ONLINECHECK NO should perhaps do the trick. Also makes sure that your javaprogrammers use DB2 compatable hostvariables.



Vriendelijke groet, Douwe van Sluis



-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens Hardy, Dale Verzonden: dinsdag 16 september 2008 15:52 Aan: DB2-L@www.idugdb2-l.org Onderwerp: Re: [DB2-L] DB2 z/OS V8 NFM - Security for preparing SQLJ applications [...] 16188 95 46_Re: [DB2z] Granting SYSADM to a Vendor Product13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 18 Sep 2008 13:51:48 -0500592_us-ascii No, I don't think a vendor is going to do something "malicious" with their code, it's more just getting an understanding of the assumptions they have made about the environment they are going to run in, and what decisions they have made based on those assumptions. Many times in the past I've found myself scratching my head wondering why a vendor did thing-x, and occasionally have gotten an explanation that makes sense when viewed in the context of some assumptions that are not valid for our environment. There are a lot of "bad" things that could be done unintentionally - [...] 16284 103 29_Re: DB2 Java Universal Driver15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Thu, 18 Sep 2008 21:08:23 +0200550_us-ascii Package have no role in the java compile, so no need for the properties file to be in the CLASSPATH for that.

We use a DB2 Plan with a PKLIST. One for the application, the other one is NULLID.SYSSTAT if we use SQLJ (Static) or in case of Dynamic SQL just NULLID.*. Just the SYSSTAT package assures that the driver will not go dynamic because someone messed up the customization or installation. Now you can use a driver propertie called db2.jcc.sqljUncustomizedWarningOrException to warn for uncustomized SQLJ at execution time. [...] 16388 43 44_Distributed access: Is DB2 Connect required?15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Thu, 18 Sep 2008 17:03:38 -0600492_us-ascii I have some questions about DB2 Connect:

Where does DB2 Connect reside? On the client? On the database server? On a platform in between the client and the database server? If so, what platform?

Is DB2 Connect required when connecting to DB2 on z/OS from a distributed platform? If so, why? Distributed platforms can connect to a Linux, UNIX, and Windows database server without DB2 Connect. Why is DB2 Connect required when connecting to a "host" database server? [...] 16432 70 46_Re: [DB2z] Granting SYSADM to a Vendor Product0_17_JTonchick@AOL.COM29_Thu, 18 Sep 2008 21:37:13 EDT477_US-ASCII On z/OS there is a zparm that deals with DBADM authority and the ability to create views. The default is no. I don't have assecc to a manual right now, so I can't give you the parm name. Hope this helps.

Jim Tonchick





**************Looking for simple solutions to your real-life financial challenges? Check out WalletPop for the latest news and information, tips and calculators. (http://www.walletpop.com/?NCID=emlcntuswall00000001) [...] 16503 63 46_Re: [DB2z] Granting SYSADM to a Vendor Product7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 18 Sep 2008 19:55:31 -0700648_us-ascii Ted, there is no intent necessarily implied. Accidents and Ah Shucks (the polite version) happen.

Edward Long



--- On Thu, 9/18/08, Ted MacNEIL wrote:

> From: Ted MacNEIL > Subject: Re: [DB2-L] [DB2z] Granting SYSADM to a Vendor Product > To: DB2-L@www.idugdb2-l.org > Date: Thursday, September 18, 2008, 10:21 AM > >The impact of an uncontrolled SYSADM ID doing > "whatever it wants" in our environment would be > very > unappealing. > > You make it sound like the vendor is going to do something > malicious with their code & authority! > No reputable vendor is [...] 16567 296 122_Upcoming IDUG Webcast - "UNDERSTANDING EXPLAIN TABLES IN DB2 9" - Wednesday September 24 at 11 am US Central Daylight Time13_David Chapman24_David.Chapman@IAG.COM.AU31_Fri, 19 Sep 2008 13:11:47 +1000749_us-ascii

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________



Hello DB2 List,

"UNDERSTANDING EXPLAIN TABLES IN DB2 9" - SUSAN LAWSON AND DAN LUKSETICH (YL&A)

The International DB2 Users Group (IDUG) is pleased to partner with BMC to deliver a free Webcast by renowned presenters Susan Lawson and Dan Luksetich of YL&A. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenters. Capacity is limited, so register early. [...] 16864 29 46_Re: SV: [DB2-L] DSNRTSDB after migration to V915_Martin Ketterer31_martin.ketterer@DE.KAERCHER.COM31_Fri, 19 Sep 2008 06:03:18 +0000555_UTF-8 Hej Olle tack för svaret / thanks for your answer. It's a bit funny, but as I wrote it's not a problem. After migrating to NFM the tablespace and the indexes are in RO state, database in RW, that was misunderstanding how I wrote it. I just went through the catalog and noticed that let's say more than 3 years ago I must have created them explicitly (stortype=E) and afterwards changed to implicitly (stortype=I). Oh I am getting older and seem to forget things I have done in the past (sometimes better?). Hälsningar and best regards Martin [...] 16894 26 167_Re: ADM8004W Incremental backup was not enabled for table space "SYSCATSPACE" (ID "0") because the TRACKMOD configuration parameter was not enabled.in hte db2inst1.nfy14_Vineet Chauhan25_chauhan.vineet1@GMAIL.COM31_Fri, 19 Sep 2008 06:57:37 +0000779_UTF-8 HI david

I think immediate option is the default in the update command.

vineet

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA * ______________________________________________________________________





The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click [...] 16921 83 48_Re: Distributed access: Is DB2 Connect required?12_Jim McAlpine22_jim.mcalpine@GMAIL.COM31_Fri, 19 Sep 2008 09:38:13 +0100597_ISO-8859-1 On 9/19/08, Frank Swarbrick wrote:

> I have some questions about DB2 Connect: > > Where does DB2 Connect reside? On the client? On the database server? On > a platform in between the client and the database server? If so, what > platform? > > Is DB2 Connect required when connecting to DB2 on z/OS from a distributed > platform? If so, why? Distributed platforms can connect to a Linux, UNIX, > and Windows database server without DB2 Connect. Why is DB2 Connect > required when connecting to a "host" database server? > > If DB2 Connect is [...] 17005 435 48_Re: Distributed access: Is DB2 Connect required?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 19 Sep 2008 09:59:36 -0400518_us-ascii Jim and Frank

Couple of corrections: as of DB2 LUW v8, the LUW server editions could be priced per user or per processor. I don't believe this has changed with V9.





DB2 Connect is required when connecting to DB2 z/OS, DB2 for VM/VSE, and DB2 for iSeries (the AS400s, for those of you as old as me) from any DB2 on the LUW platform, except that it is either included free or not needed with DB2 ESE. (Understanding DB2: Learning Visually with Examples, IBM Press, 2005, p.13) [...] 17441 190 30_DB2 z/OS XML CLOB select query15_Gantz, Denise M22_denise.m.gantz@EDS.COM31_Fri, 19 Sep 2008 10:30:46 -0400522_us-ascii

> I am a DBA supporting an application which is implementing XML > technology in a DB2 database. We are on version 8 NFM, and we have > installed XML extenders in the environment. > My customer is trying to perform selects on the data in an LOB table > with a CLOB data type. > Here is the issue: > > I have a .NET Windows client which is reading data from the DB2 Table > "dscmkcyc.ipp_msg". I have no problem reading other fields from this > table but I run into problems when I read data from the [...] 17632 383 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications11_Hardy, Dale14_DHardy@MIB.COM31_Fri, 19 Sep 2008 14:20:25 -0400485_US-ASCII That did it.

Our programmers say they still want on-line checking turned on during development and then turn it off for deployment.

Thank you for your help.



________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Douwe van Sluis Sent: Thursday, September 18, 2008 2:17 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 z/OS V8 NFM - Security for preparing SQLJ applications [...] 18016 170 31_Re: Bookmanager CDs and readers12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 20 Sep 2008 07:35:46 -0700384_iso-8859-1 What a step backwards towards non-user-friendly. Sounds like IBM is at it again. BookManager is seriously more usuable that info-center. 90% of the time that I use Info-center for a search, it returns garbage and totally unrelated data. I get so frustrated that I go to google to search the entire net rather than use info-center if I can't get access to bookmanager. [...] 18187 132 31_Re: Bookmanager CDs and readers12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 20 Sep 2008 15:59:29 +0000476_utf-8 I'm sure that IBMers would love to keep selling BookManager, but your experience is relatively rare. What IBM keeps doing is stopping work where customers are not buying. Acrobat reader is free, and the dominant demand has been for PDFs, so we have those. We have access from the web. We have BookManager now, but customers are not buying. Producing the books in three formats is very challenging, and getting out all the updates in all of the formats is daunting. [...] 18320 77 48_Re: Distributed access: Is DB2 Connect required?0_25_jacampbell@ACSLINK.NET.AU31_Sun, 21 Sep 2008 09:25:26 +1000492_US-ASCII 1) The fingers tapping the the keyboard are the ultimate client, the disk drives the ultimate server. Everything else is both a server (on the fingers side) and a client (on the disk side).

In the case of DB2 Connect, it resides on a Linux, Unix or Windows platform. (Or, if you are running out of support software, OS/2). As it connects to DB2 on z/OS or iSeries, this is obviously not the database server. It might be the same platform as its client - or it might not. [...] 18398 751 62_Re: DB2 z/OS V8 NFM - Security for preparing SQLJ applications15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Sun, 21 Sep 2008 14:57:34 +0200392_US-ASCII Just had a problem with a query which chooses a wrong accesspath when using ONLINECHECK NO. With ONLINECHECK NO, it chooses a tablescan, with YES an indexscan. In the output of db2sqljprint I see that with NO a VARCHAR(32768) is used and with YES a VARCHAR(19) equal to the indexkeycolumn is used. I am still investigating why this is. When I find the answer, I will post it... [...]