1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2008, week 2 2 20 35_Re: [DB2 z/OS] Optimizer Hint Issue9_Eric West25_ewest@HLSTECHNOLOGIES.COM30_Fri, 8 Feb 2008 00:03:29 +0000292_UTF-8 Lyon, Would you be interested in scheduling a WebEx meeting with our Technical Staff to discuss Optimizer Hints? We have a lot of experience in this area and would be more than glad to help you in anyway we can. You can reach me at ewest@hlstechnologies.com if you are interested. [...] 23 49 12_Re: DSN1SDMP25_jacampbell@acslink.net.au25_jacampbell@ACSLINK.NET.AU30_Fri, 8 Feb 2008 15:54:15 +1100624_iso-8859-1 It is certainly normal to get various 00E608xx errors. What happens is that when you issue the -stop trace, DB2 de-allocates the buffer and OPx, but dsn1sdmp doesn't know, so dsn1sdmp issues another READA. It is this reada that has failed.

James Campbell

> I am trying to run DSN1SDMP and I am receiving this error > when I stop the trace. > DSN1712I START TRACE RETURN_AREA FOLLOWS: > DSNW130I -DB2C P TRACE STARTED, ASSIGNED TRACE > NUMBER 07 : DSN9022I -DB2C DSNWVCM1 '-START TRACE' > NORMAL COMPLETION: > > DSN1713E READA ERROR, REASON=00E60827 > DSN1718E STOP TRACE ERROR, REASON=00E60820 [...] 73 93 35_Re: [z/OS] Problems with COMMENT ON12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 8 Feb 2008 06:20:53 +0000422_utf-8 Until V7 with the zparm, you could not create the view for someone else. The classic technique for creating a view and having some authority on it, without administrative authority, is using a secondary id. Using groups for a security subsystem is the same. The next technique on this path is using ROLE ownership in DB2 9. There are a number of interesting suggestions for reworking authorization beyond that. [...] 167 17 50_Tim Baker/Corporate/Manulife is out of the office.0_22_Tim_Baker@MANULIFE.COM30_Fri, 8 Feb 2008 01:49:39 -0500362_US-ASCII I will be out of the office starting 02/08/2008 and will not return until 02/11/2008.

I'm currently out of the office. Send any DBA requests to E-mail id 'CDN DBAS Team'. In case of emergency, page CDN DBA DB2 Team, CDN DBA SQLServer team, CDN DBA Sybase team or CD DBA ORACLE Team through PACE or by contacting operations or the Help Desk. [...] 185 94 28_Re: REORG vs REBUILD indexes11_Nick Cianci19_ncianci@AU1.IBM.COM30_Fri, 8 Feb 2008 18:22:41 +1100374_ISO-8859-1 Rao

Depends on size but I'd generally do a "CREATE INDEX ... DEFER YES" and then REBUILD Index. It's generally faster and you get a good index out of it.

In v7 We specified SORTKEYS and got a "turbo boost" on PI rebuilds make use of parallelism. In v8 the key word goes and the implications are that you now get the parallelism auto-magically. [...] 280 57 55_A quick question about DB2 catalog and version - Thanks0_28_Massimo.Scarpa@PHOENIXSPA.IT30_Fri, 8 Feb 2008 09:40:21 +0100678_US-ASCII

I wish to thank Mr. J. Campbell for his reply to my quick question.

Max Scarpa

























The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 338 31 35_Robert Badger is out of the office.0_24_robert.badger@AURORA.ORG30_Fri, 8 Feb 2008 04:04:53 -0600171_US-ASCII

I will be out of the office starting Fri 02/08/2008 and will not return until Mon 02/11/2008.

I will respond to your message when I return.

370 121 28_Re: REORG vs REBUILD indexes5_Rao A17_a.rao08@YAHOO.COM30_Fri, 8 Feb 2008 04:09:49 -0800463_us-ascii I am sorry for not being clear. You are right. I meant CLUSTERING index. Also I did check the accesspath and it is index only access on that index. Hence, REORG on tablespace might not really do any good to reduce index getpages.





----- Original Message ---- From: Andy Lankester To: DB2-L@www.idugdb2-l.org Sent: Thursday, February 7, 2008 1:20:51 PM Subject: Re: [DB2-L] REORG vs REBUILD indexes [...] 492 60 45_Re: Refresh Table with Compression dictionary14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 8 Feb 2008 13:16:32 -0000400_us-ascii A refresh of an MQT is really just a "delete" followed y a load of "inserts" so once you HAVE a compression dictionary it will be reused

Getting the FIRST one (or rebuilding one due to changing circumstances) does require a LOAD though



Phil Grainger CA Product Management Director Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com [...] 553 245 28_Re: REORG vs REBUILD indexes13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Fri, 8 Feb 2008 09:00:49 -0500415_us-ascii Sounds to me like for this particular process, you don't need to reorg the tablespace.

BUT, assuming you have other processes which will benefit from the order of the data being in the new, correct clustering index order, you will sooner or later need to reorg the tablespace. As I understand the scene as you describe it, the data now is in clustering order by the OLD wrong clustering index. [...] 799 64 43_AW: [DB2-L] [DB2 z/OS] Optimizer Hint Issue0_26_Walter.Janissen@ITERGO.COM30_Fri, 8 Feb 2008 15:09:05 +0100369_iso-8859-1 Hi Lock

I had a similar problem with optimizer hints and even raised a problem with IBM, until they detected that the correlation names are as important than the real names. So check, if you use different correlation names for your tables or if tables are materialized, they must have the same creator as those in the statement you want to tune. [...] 864 75 45_Re: Refresh Table with Compression dictionary10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 8 Feb 2008 15:06:45 +0000373_utf-8 That may still present some challenges. I'd like to use table based partitioning by month for the MQT. Unfortunately the date field on the tables is a six byte character which makes relative SQL difficult. Although perhaps doing an ALTER DROP followed by ALTER ADD may work.

On Fri, 8 Feb 2008 13:16:32 -0000, Grainger, Phil wrote: [...] 940 118 45_Re: Refresh Table with Compression dictionary14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 8 Feb 2008 15:20:48 -0000456_us-ascii Sorry Jorg - you lost me

"ALTER DROP" and "ALTER ADD" of what?

Phil Grainger CA Product Management Director 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. [...] 1059 139 45_Re: Refresh Table with Compression dictionary10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 8 Feb 2008 15:39:40 +0000331_utf-8 Phil,

I mean do an alter on the table with the DROP MATERIALIZED QUERY command. That'll make the table normal. Then I alter the table with ADD MATERIALIZED query with the updated SQL (same columns new range). That way when I refresh I get the new data wihtout losing the compression dictionary on the tablespace. [...] 1199 322 45_Re: Refresh Table with Compression dictionary14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 8 Feb 2008 15:42:55 -0000683_iso-8859-1 OK, now I understand

but - "As long as rotate partition doesn't junk the compression dictionary." - I think you'll find it does :(

Phil G

________________________________

From: DB2 Data Base Discussion List on behalf of Jorg Lueke Sent: Fri 08/02/2008 15:39 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Refresh Table with Compression dictionary





Phil,

I mean do an alter on the table with the DROP MATERIALIZED QUERY command. That'll make the table normal. Then I alter the table with ADD MATERIALIZED query with the updated SQL (same columns new range). That way when I refresh I get the new data wihtout [...] 1522 116 45_Re: Refresh Table with Compression dictionary13_David Simpson22_dsimpson@THEMISINC.COM30_Fri, 8 Feb 2008 10:49:04 -0500479_iso-8859-1 We actually had a similar scenario (not an MQT, but a table that would expand into new parts). We built a few thousand rows of dummy data based on real production data with the higher keys and loaded it into ALL parts to get each dictionary built. We then emptied the parts using the load utility with the KEEPDICTIONARY option. So... the dictionaries were there when the data got there. This was probably not optimal for the actual data but better than nothing. [...] 1639 69 33_[z/OS] CA DB2 Tools & Screen Size9_Sam Baugh24_Sam.Baugh@MOTION-IND.COM30_Fri, 8 Feb 2008 09:49:15 -0600275_us-ascii Has anyone found a way to get CA Detector and/or RC Query tool to take advantage of screen/panel size with more than 80 columns? I know the RC Update tool does this, but we don't have that one. Just hoping there is a way to do this outside of the tool. Thanks! [...] 1709 27 45_Re: Refresh Table with Compression dictionary10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 8 Feb 2008 16:11:00 +0000409_utf-8 Hmm, well what I did for this initial load was to run a subset query to load a few thousand rows. I then ran a reorg to build the dictionary. Then I altered the table to drop the MQT definition and then I added the full select I wanted.

I suppose I could do this each month by manually loading the changed partion building the dictionary and then reactivating the MQT and running a refresh. [...] 1737 72 45_Re: Refresh Table with Compression dictionary14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 8 Feb 2008 16:18:09 -0000386_us-ascii Indeed, and don't forget all the fun you'll get into when you start ROTATING.... If you do partition loads, PLEASE get the partition number right - it's always the PHYSICAL number (the Annn bit of the dataset name) NOT the logical partition

In other words, when you start, the first part is PART 1. After the first ROTATE, the first part is PART 2 and so on....... [...] 1810 37 4_test11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU30_Fri, 8 Feb 2008 09:40:27 -0700491_iso-8859-1

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 1848 88 45_Re: Refresh Table with Compression dictionary10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 8 Feb 2008 17:28:58 +0000346_utf-8 I may just use inserts in this statement to build the dictionary. While it is a bunch of work, because these are analytical tables utilized by inexperienced users (in terms of DB2) the potential savings are likely worth the effort.





On Fri, 8 Feb 2008 16:18:09 -0000, Grainger, Phil wrote: [...] 1937 31 40_Migrating CLOBS from DB2 LUW to DB2 z/OS13_Palko, George16_gpalko@OPERS.ORG30_Fri, 8 Feb 2008 13:20:26 -0500550_iso-8859-1 Hi List,

We're in the process of migrating all our DB2 LUW data to the mainframe. We've run into an issue with CLOBS. The size of the CLOBS are 50,000K. Because of the size of these CLOBS, the traditional methods of migrating the data is insufficient. Does anyone have any suggestions as to how we might migrate these CLOBS over to the mainframe. Currently, our only option is writing a batch extract program. We've also tried, without success to bind the DSNTIAUL program remotely in an attempt to use it to migrate the data. [...] 1969 82 44_Re: Migrating CLOBS from DB2 LUW to DB2 z/OS15_Kalena, Michael16_MKALENA@BEAR.COM30_Fri, 8 Feb 2008 13:41:07 -0500501_us-ascii Hi George,

You can use DB2 Connect to connect from your LUW side to DB2 z/OS and do inserts. DB2 Connect is a subset of DB2 LUW software. This is a manual way to do it.

For a more automated way, you can use the Export command to get the data from DB2 LUW to files. Then use Import to get the data into DB2 z/OS. The DB2 z/OS side only supports IXF format (or least used to only support that format). We've done this in the past and it's not bad for one time data movement. [...] 2052 40 26_Compatibility of utilities13_Horacio Villa17_hvilla@AR.IBM.COM30_Fri, 8 Feb 2008 16:49:31 -0200205_US-ASCII Hi list,

I wonder why LOAD is not compatible with COPYTOCOPY (if it's not SHRLEVEL CHANGE). Have been thinking about it but don't see the reason.

Cheers,

Horacio Villa

2093 39 30_Re: Compatibility of utilities14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Fri, 8 Feb 2008 18:54:01 +0000364_utf-8 Load uses a logical input file were a record often represent a row.

Copy uses an image copy file where a record represents a VSAM CI. There are other things in VSAM CIs besides user data and some CIs may contain no user data at all.

Regards Avram Friedman

On Fri, 8 Feb 2008 16:49:31 -0200, Horacio Villa wrote: [...] 2133 57 44_Re: Migrating CLOBS from DB2 LUW to DB2 z/OS7_Ed Long19_rdhm99a@PRODIGY.NET30_Fri, 8 Feb 2008 11:23:06 -0800619_iso-8859-1 Hi George. The programmatic route is your best option. Remember you need two, one to unload and one to insert.



"Palko, George" wrote: Hi List,

We're in the process of migrating all our DB2 LUW data to the mainframe. We've run into an issue with CLOBS. The size of the CLOBS are 50,000K. Because of the size of these CLOBS, the traditional methods of migrating the data is insufficient. Does anyone have any suggestions as to how we might migrate these CLOBS over to the mainframe. Currently, our only option is writing a batch extract program. We've also tried, [...] 2191 192 30_Re: Compatibility of utilities13_Horacio Villa17_hvilla@AR.IBM.COM30_Fri, 8 Feb 2008 17:37:22 -0200515_US-ASCII Hi Avram,

I think I wasn't clear enough with my question. We were running COPYTOCOPY from LASTCOPY on a tablespace, and at the same time wanted to LOAD the same tablespace. We got an error saying that the utilities are incompatible.

Cheers,

Horacio Villa





Avram Friedman Sent by: DB2 Data Base Discussion List 08/02/2008 16:54 Please respond to DB2 Database Discussion list at IDUG [...] 2384 72 44_Re: Migrating CLOBS from DB2 LUW to DB2 z/OS14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Fri, 8 Feb 2008 19:45:22 +0000664_utf-8 Take a look at the following IBM TECHNOTE concerning using the Cross Loader.

http://www-1.ibm.com/support/docview.wss?uid=swg21163210

Regards Avram Friedman

On Fri, 8 Feb 2008 11:23:06 -0800, Ed Long wrote:

>Hi George. > The programmatic route is your best option. Remember you need two, one to unload and one to insert. > > >"Palko, George" wrote: > Hi List, > >We're in the process of migrating all our DB2 LUW data to the mainframe. We've run into an issue with CLOBS. The size of the CLOBS are 50,000K. Because of the size of these CLOBS, the traditional methods of migrating the [...] 2457 23 35_Re: [DB2 z/OS] Optimizer Hint Issue15_Patrick Bossman18_bossman@US.IBM.COM30_Fri, 8 Feb 2008 20:01:05 +0000442_UTF-8 Willie, you can call me "Pay Bossman" any time you want - especially when talking to my manager.

I would just add, the slides in the URL Willie had are from 2004 and include a Visual Plan Hint prototype.

Visual Plan Hint was delivered in DB2 Optimization Service Center, and there's a section on it in this Optimization Tools redbook. http://www.redbooks.ibm.com/redbooks/SG247421/wwhelp/wwhimpl/java/html/wwhelp.htm [...] 2481 20 37_Accounting for Long Connected Threads10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Fri, 8 Feb 2008 20:02:10 +0000557_utf-8 In my previous job the CICS transactions would gdenerate DB2 accounting records for every execution on sign-on. Here I get one record at the end of the day. Also, other accesses such as Neon, DB2 Connect, and other JDBC accesses tend to be day long resulting in single accounting records per user. This makes it difficult to see what is happpening over the course of the day. Is there a way I can easily get at least hourly accounting data from DB2? If anyone knows a good reference where I can see what settings control this, because I am still [...] 2502 192 30_Re: Compatibility of utilities12_Riley, Irene21_Irene.Riley@FEPOC.COM30_Fri, 8 Feb 2008 14:52:35 -0500479_us-ascii It may be because the LOAD and COPYTOCOPY both have to update SYSCOPY for the object.

Irene Riley Database Administrator FEP Operations Center(r) (202) 203-2383 irene.riley@fepoc.com







________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Friday, February 08, 2008 1:50 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Compatibility of utilities [...] 2695 260 30_Re: Compatibility of utilities13_Horacio Villa17_hvilla@AR.IBM.COM30_Fri, 8 Feb 2008 18:14:02 -0200425_ISO-8859-1 I thought about that. But then realized that LOAD SHRLEVEL CHANGE also has to update SYSCOPY for the object but still it's compatible (see the matrix in UG).

Cheers,

Horacio





"Riley, Irene" Sent by: DB2 Data Base Discussion List 08/02/2008 17:52 Please respond to DB2 Database Discussion list at IDUG [...] 2956 57 35_Re: [DB2 z/OS] Optimizer Hint Issue14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Fri, 8 Feb 2008 15:15:01 -0500349_us-ascii All,

Thank you very much for the *flood* of feedback on this issue. Thanks to all of your help, I think we're rolling.

The only remaining odd thing ... We implemented a PLAN_TABLE and EXPLAINed our query into it, resulting in six rows of access path information. We then UPDATEd the OPTHINT column(s) with our Hint Name. [...] 3014 100 40_Converting from Image Plus to Documentum12_Smith, Tamea22_tamea.smith@ITS.NC.GOV30_Fri, 8 Feb 2008 15:05:46 -0500677_us-ascii Has anyone converted their Image Plus system to Documentum? If so, could you please let me know what your experience was like? You can respond directly to my email address. Thanks.

PLEASE NOTE MY NEW EMAIL ADDRESS: Tamea.Smith@its.nc.gov



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 [...] 3115 20 35_Re: [DB2 z/OS] Optimizer Hint Issue15_Patrick Bossman18_bossman@US.IBM.COM30_Fri, 8 Feb 2008 21:43:35 +0000629_UTF-8 Hi Lockwood, Check the TIMESTAMP column. Do they all have the same timestamp? (Checking if they are the result of the same explain).

You should not be getting double explain output, and I've never seen or heard of this happening.

Regards, Pat

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 [...] 3136 14 47_USPTO - Patent Trademark Office Database - link14_Linda Hagedorn26_linda.hagedorn@IRELAND.COM30_Fri, 8 Feb 2008 22:02:17 +0000665_utf-8 The US Patent Trademark Office patents are publicly available. You can read patents here: http://www.uspto.gov/patft/ BMC, Computer Associates, Platinum, etc. Interesting reading.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 3151 21 35_UUENCODing - DB2 for z/OS version 79_Ken Paris20_kenparis17@GMAIL.COM30_Fri, 8 Feb 2008 23:04:31 +0000349_UTF-8 We have images stored in DB2 for z/OS BLOBs and we need to UUENCODE them for inclusion in an XML message.

We'd like to do it in a SQL stored procedure (we don't currently have availability to Java stored procedures).

If anyone's done this or knows someone who has, we'd love to talk or, even better, get a copy of the code. [...] 3173 104 36_Re: OT - Hiring DB2/CICS/IMS Sysprog6_keyRho16_keyrho@GMAIL.COM30_Fri, 8 Feb 2008 19:22:35 -0500619_ISO-8859-1 Gary

I wish this message won't bother you.

I could not locate your URL.

Hiring Ad was cancelled or it's still live .... !

Key, ex Bell and IBM er from Toronto









On 2/7/08, Gary Jacek wrote: > > Sorry for the intrusion. I'll keep this short. > > We have an opening at our Whalley office (suburb of Vancouver, BC) for a > DB2/CICS/DATACOM/MQ/IMS/ADABAS Sysprog. > > Vancouver is on the west coast of Canada, a 2 hour drive north of Seattle, > Washington. The climate is similar to Seattle. > > Here is the long URL > [...] 3278 239 36_Re: OT - Hiring DB2/CICS/IMS Sysprog10_Gary Jacek20_Gary.Jacek@TELUS.COM30_Fri, 8 Feb 2008 16:47:25 -0800497_us-ascii You're right.

Just go to www.monster.ca and key in a search argument of "Whalley DB2".

Gary Jacek TSDOSS - TELUS 250-413-8217



________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of keyRho Sent: Friday, February 08, 2008 4:23 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] OT - Hiring DB2/CICS/IMS Sysprog







Gary

I wish this message won't bother you. [...] 3518 338 45_DSNT108I Message when migration from v7 to v821_=?GB2312?B?0e6GtA==?=21_yang.zhe@BANKCOMM.COM30_Sat, 9 Feb 2008 10:56:41 +0800444_gb2312 HI LIST:





Just wondering if someone can help me with the CCSID problems I am having.





Our Migration to Version 8 was going very well until I wanted to start the new DB2





Our DB2 started but then abended because it found a diffence in the CCSID in DSNHDECP,

see message below ...





DSNT108I -DSNY DB2 HAS DETECTED A DIFFERENCE BETWEEN 439 [...] 3857 67 49_Re: DSNT108I Message when migration from v7 to v80_25_jacampbell@ACSLINK.NET.AU30_Sat, 9 Feb 2008 22:46:10 +1100340_ISO-8859-1 1) print the contents of the BSDS to verify the CCSIDs recorded there

2) reassemble your dsnhdecp - which library did it go into?

3) check the steplib concatenation for your MSTR address space to verify that you are loading the dsnhdecp module that you think you should be. Look in each library - don't guess. [...] 3925 29 41_Re: Accounting for Long Connected Threads0_25_jacampbell@ACSLINK.NET.AU30_Sat, 9 Feb 2008 22:46:10 +1100579_US-ASCII see the RDO DB2ENTRY and DB2CONN ACCOUNTREC value. Your CICS sysprog should be able to give you these values.

James Campbell

On 8 Feb 2008 at 20:02, Jorg Lueke wrote:

> In my previous job the CICS transactions would gdenerate DB2 accounting > records for every execution on sign-on. Here I get one record at the end of > the day. Also, other accesses such as Neon, DB2 Connect, and other JDBC > accesses tend to be day long resulting in single accounting records per user. > This makes it difficult to see what is happpening over the course of [...] 3955 429 57_SV: [DB2-L] DSNT108I Message when migration from v7 to v816_Krakowski Henrik26_henrik.krakowski@VOLVO.COM30_Sat, 9 Feb 2008 15:31:30 +0100585_iso-8859-1 Hi We had the similar problem with one of our subsystems during migration to version 8. What happened was: 1. we put the wrong value for ascii ino our migration clist (500) which was used as well by DSNTIJUZ batch resulting in unproper DSNHDECP in SDSNEXIT. 2. Starting DB2 subsystem resulted in "DSNT109I..." complaing about invalid CCSID for Ascii.This (wrong) value is written into BSDS at that time. 3. If you change (correct) this value into the right one (1252 in our case) and rerun DSNTIJUZ it will change DSNHDECP ,but not the value in the BSDS file. 4. Start [...] 4385 394 30_Re: Compatibility of utilities37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Sun, 10 Feb 2008 20:37:40 +0100458_iso-8859-2 It seems to me that LOAD SHRLEVEL CHANGE need not write into syscopy. Recovery is not influenced by it (in the same way as it is not influenced by inserts, both are loged) regards, dusan

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Friday, February 08, 2008 9:14 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Compatibility of utilities [...] 4780 376 49_Re: DSNT108I Message when migration from v7 to v823_Tino Manganaro (DHL US)22_Tino.Manganaro@DHL.COM31_Mon, 11 Feb 2008 05:34:47 -0700390_us-ascii I would recommend running DSNJU004 to list the CCSIDS in your current BSDS and compare to what coded in DECP. Also did you compare the V71 DECP to V81 DECP and check for changes to the CCSIDs?













DSNT108I -DSNY DB2 HAS DETECTED A DIFFERENCE BETWEEN 439

THE RECORDED SYSTEM CCSIDS AND THE CCSIDS SPECIFIED BY DSNHDECP [...] 5157 69 12_Re: DSN1SDMP12_Joe Hartmann22_joe.hartmann@OA.MO.GOV31_Mon, 11 Feb 2008 16:45:49 +0000348_utf-8 Thank you James and thanks to every one who responded. I thought that was the case but being this was the first time I had run this utility, I was uncertain. It never hurts to ask for a second opinion.

Thanks again Joe



On Fri, 8 Feb 2008 15:54:15 +1100, jacampbell@acslink.net.au wrote: [...] 5227 100 50_[DB2 Z/OS] V8 Setting Current SQLID in dynamic sql19_Melvin Schellenberg33_Melvin.Schellenberg@SALLIEMAE.COM31_Mon, 11 Feb 2008 12:43:19 -0500423_US-ASCII Listers:

Using batch spufi I would like to store the user Id from the job card when I update a control table. The SQL is similiar to:

INSERT INTO TABLE1 A SELECT COLA ,COLB , SUBSTR(DIGITS(SMALLINT_PART +1),8,3) AS PARTITION ,USER_ID ,CURRENT_TIMESTAMP ,COLC FROM TABLE1 A WHERE A.COLA = 'ABCD' AND A.DBNAME = 'XYZ' AND A.PARTITION = (SELECT MAX(PARTITION) FROM TABLE1 B WHERE A.COLA = B.COLA); [...] 5328 192 54_Re: [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 11 Feb 2008 13:00:26 -0500475_us-ascii Hey Mel,

Unless I'm missing something, you should be able to use the special regiser USER.

Dave







The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 5521 185 54_Re: [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql15_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM31_Mon, 11 Feb 2008 13:02:34 -0500496_us-ascii Have the column defined with DEFAULT USER and dont specify the column in the column list of Insert statement, then the owner of the job will be used as the value of USER.

Regards Vidya



________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Melvin Schellenberg Sent: Monday, February 11, 2008 12:43 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql [...] 5707 433 54_Re: [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql12_Hepp Shery C21_Shery.Hepp@SRPNET.COM31_Mon, 11 Feb 2008 11:08:50 -0700471_us-ascii Maybe I'm missing the obvious- but is the user_id column on the table defined as not null with default of current sqlid? Wouldn't that give you what you need?





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Melvin Schellenberg Sent: Monday, February 11, 2008 10:43 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql [...] 6141 45 54_Re: [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql19_Melvin Schellenberg33_Melvin.Schellenberg@SALLIEMAE.COM31_Mon, 11 Feb 2008 13:33:32 -0500608_US-ASCII Thanks Dave and all that responded did not realize that 'USER' was a special register. Worked great.

Mel



The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 6187 14 53_Roy J Cornford/Santa Teresa/IBM is out of the office.14_Roy J Cornford23_roy_cornford@UK.IBM.COM31_Mon, 11 Feb 2008 20:21:26 +0000631_US-ASCII I will be out of the office starting 11/02/2008 and will not return until 18/02/2008.

I am away travelling with limited access to mail.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 6202 66 35_Re: [DB2 z/OS] Optimizer Hint Issue14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Mon, 11 Feb 2008 15:43:47 -0500368_us-ascii All,

I tried a test for QueryNo 77, a SELECT * FROM SYSIBM.SYSDUMMY1. Did the EXPLAIN, Updated HINTUSED and PROGNAME. The result is row #1 below.

I then executed [Program DSNTIAUL / Plan DSNTIB71] with the following input:

SET CURRENT OPTIMIZATION HINT = 'LOCK '; EXPLAIN PLAN FOR SELECT * FROM SYSIBM.SYSDUMMY1 WITH UR QUERYNO 77 ; [...] 6269 123 80_DB2 for z/OS V9 - pureXML XMLEXISTS question "[" and "]" getting(mis) translated10_Ken Whelan11_ken@KWA.NET31_Mon, 11 Feb 2008 06:12:05 -0800415_iso-8859-1 DB2 for z/OS V9 - pureXML XMLEXISTS question "[" and "]" getting(mis) translatedHello Listserve

I'm running a query that I ran OK in DB2 V9 for Windows, but NOT on DB2 for z/OS V9.





Works on DB2 for Windows V9 - OK ------------------------------------------------- select id, comments from items where xmlexists('$c/[comment="COMMENT 2"]' passing items.comments as "c") [...] 6393 90 84_Re: DB2 for z/OS V9 - pureXML XMLEXISTS question "[" and "]" getting(mis) translated14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 12 Feb 2008 06:55:27 -0000507_iso-8859-1 I had this problem when my terminal CCSID and DB2s were different such that the "[" and "]" were being translated to something else

I'm not sure it matters which CCSID you use, providing they are consistent

Phil G CA

________________________________

From: DB2 Data Base Discussion List on behalf of Ken Whelan Sent: Mon 11/02/2008 14:12 To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2 for z/OS V9 - pureXML XMLEXISTS question "[" and "]" getting(mis) translated [...] 6484 52 83_Re DB2 for z/OS V9 - pureXML XMLEXISTS question "[" and "]" getting(mis) translated14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Tue, 12 Feb 2008 08:46:33 +0100370_iso-8859-1 > I key in those characters and they get "translated: for me into > x'AD' and x'BD' respectively. > > Do I need a different CCSID or something else?

Could indeed be a CCSID problem: those encodings are for CCSID=87 (the "US" EBCDIC mapping), while e.g. CCSID=500 (the "international" EBCDIC mapping) has "[" and "]" on x'4A' and x'' respectively. [...] 6537 107 43_More IBM Technotes (FAQ) about DB2 for z/OS9_DB2usa!!!19_db2usa3@HOTMAIL.COM31_Tue, 12 Feb 2008 04:53:05 -0500411_iso-8859-1

Hi DB2 user, Here is a non-profit Blog about DB2 for z/OS (IBM mainframes):http://db2usa.blogspot.com Last update on Monday, February 11th 2008 Here are more Technotes (FAQ), available on IBM DB2 for z/OS website:

- Is it necessary to increase the size of DB2 group buffer pools?- Attempting to load more data than fits into the data set- Unicode data is converted to hex strings [...] 6645 75 35_Re: [DB2 z/OS] Optimizer Hint Issue0_25_jacampbell@ACSLINK.NET.AU31_Tue, 12 Feb 2008 21:43:01 +1100593_US-ASCII I would not be surprised if DSNTIAUL had executed your explain statement twice. It has some "interesting" techniques.

But I would have to track through the source code to be sure.

James Campbell



On 11 Feb 2008 at 15:43, Lyon, Lockwood wrote:

> All, > > I tried a test for QueryNo 77, a SELECT * FROM SYSIBM.SYSDUMMY1. Did the > EXPLAIN, Updated HINTUSED and PROGNAME. The result is row #1 below. > > I then executed [Program DSNTIAUL / Plan DSNTIB71] with the following > input: > > SET CURRENT OPTIMIZATION HINT = 'LOCK '; > EXPLAIN PLAN FOR [...] 6721 27 54_Re: [DB2 Z/OS] V8 Setting Current SQLID in dynamic sql0_25_jacampbell@ACSLINK.NET.AU31_Tue, 12 Feb 2008 21:43:02 +1100422_US-ASCII Just for completeness, SQL USER is not necessarily the same as the USER on the Jobcard. SQL USER is set by the connection or sign-on exit and, depending on your site, could be a different value.

James Campbell



On 11 Feb 2008 at 13:33, Melvin Schellenberg wrote:

> > Thanks Dave and all that responded did not realize that 'USER' was a special register. > Worked great. > > Mel > [...] 6749 272 52_Antwort: Re: [DB2-L] [DB2 z/OS] Optimizer Hint Issue0_16_R.Boxwell@SEG.DE31_Tue, 12 Feb 2008 11:58:04 +0100369_iso-8859-1 I have "vague" memories that this is how it should work..I think that IAUL does a prepare to see if the SQL is correct and then if all is OK it dynamically executes it hence with EXPLAIN(YES) you will indeed get two rows for each SQL

Remember that this is from "vague" memories that have been steeped in Beer and Sausages for a long long time... [...] 7022 39 51_Aus=?ISO-8859-1?Q?=EAncia_-_12/02/08_=E0?= 27/02/080_15_maub@BR.IBM.COM31_Tue, 12 Feb 2008 09:14:41 -0200643_ISO-8859-1



I will be out of the office starting 12/02/2008 and will not return until 27/02/2008.

Estarei ausente no período de 12/02/07 à 27/02/08. The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 7062 105 35_Re: [DB2 z/OS] Optimizer Hint Issue14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Tue, 12 Feb 2008 09:45:00 -0500364_iso-8859-1 Aha! This makes sense (so it should be immediately suspect ... but what the hey). A PREPARE of an EXPLAIN and an EXECUTE of the EXPLAIN might generate two EXPLAINs, especially since they are only 1 ms. apart.

My thanks again to all who provided input and feedback! If we encounter any additional excitement, I'll be sure to inform the List. [...] 7168 24 21_The Magic of Indexing10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 12 Feb 2008 14:54:29 +0000537_utf-8 DATE DB2TIME DB2CPU IO ---------+---------+---------+---------+---------+---------+----- 2008-02-05 5319.217336 1612.305908 2681.604727 2008-02-06 7203.782835 1651.473924 3364.234181 2008-02-07 5406.657498 1631.527145 2507.934727 2008-02-08 6339.982845 1594.397760 1426.443705 2008-02-09 6682.987614 1579.222170 3793.058155 2008-02-10 4.644406 3.220454 .682519



A definite argument for including DBA sign-off before production implementation. 1600 CPU second * 5 days/week * 52 week * $0.xx per CPU/second = $$$ [...] 7193 44 41_Re: Accounting for Long Connected Threads10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 12 Feb 2008 15:12:55 +0000594_utf-8 ACCOUNTREC says per UOW

On Sat, 9 Feb 2008 22:46:10 +1100, jacampbell@ACSLINK.NET.AU wrote:

>see the RDO DB2ENTRY and DB2CONN ACCOUNTREC value. Your CICS sysprog should >be able to give you these values. > >James Campbell > >On 8 Feb 2008 at 20:02, Jorg Lueke wrote: > >> In my previous job the CICS transactions would gdenerate DB2 accounting >> records for every execution on sign-on. Here I get one record at the end of >> the day. Also, other accesses such as Neon, DB2 Connect, and other JDBC >> accesses tend to be day long resulting in single accounting records [...] 7238 40 25_Re: The Magic of Indexing10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 12 Feb 2008 15:41:35 +0000300_utf-8 I should add that the benefits of the index were enhanced because the code used two separate cursors instead of a join. So each row fetched resulted in an index scan (209 in total). Had they coded a join it would have gone to a single tablespace scan, bad but not as bad as what they got. [...] 7279 64 41_Re: Accounting for Long Connected Threads10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Tue, 12 Feb 2008 17:36:29 +0000322_utf-8 I have discovered that the default for the SAVE feature in DB2 PM appears to be the whole interval. So the tool was summarizing for me. I added Interval (60) and Reduce(Interval) commands and now I get my hourly accounting.

On Tue, 12 Feb 2008 15:12:55 +0000, Jorg Lueke wrote: [...] 7344 23 40_APL2 and AP127 with DB2 z/OS experience?14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Tue, 12 Feb 2008 12:45:03 -0500374_us-ascii Hi Listers,

If anyone has some experiences with APL2 and the Associate Processor AP127 [for DB2 access], could you please contact me off-list: LKint@ix.netcom.com

I'm looking for Windows APL2 connecting to DB2 z/OS. Issues and results; reasons for perhaps discontinuing usage.

My plan is to experiment with APL2 in the area of SQL tuning. [...] 7368 24 16_Trigger question0_26_arrinwapinhead@VERIZON.NET31_Tue, 12 Feb 2008 12:17:32 -0600321_UTF-8 We are attempting to create a trigger in DB2 z/OS V 8.1 that performs the following function.

After a row is inserted in table T and only on column C. Check to see if the column value changed and only react if the column value was changed to "C1 , C2 or C3". Then insert that row into another table T2. [...] 7393 59 20_Re: Trigger question14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 12 Feb 2008 13:44:54 -0500649_us-ascii Your language is confusing. How can a column value be "changed" if the row is newly inserted? Do you mean, "Check for values 'C1', 'C2', 'C3' in Column C, when a row is inserted to table T"?

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of arrinwapinhead@VERIZON.NET Sent: Tuesday, February 12, 2008 1:18 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Trigger question [...] 7453 22 41_z/OS v7 - limit access using IP addresses16_Natalie Faulkner25_Natalie.W.Faulkner@WV.GOV31_Tue, 12 Feb 2008 21:17:36 +0000645_utf-8 I am looking for a way to limit our ad-hoc users and application servers to use our DB2 Connect Gateway...

Is there a way to specify which IP addresses can connect to our various subsystems ???

Any other suggestions on how to accomplish this task??

Thanks in advance!

Natalie

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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, [...] 7476 295 13_[JOB POSTING]15_Ian Stevanovich25_istevanovich@SIPERIAN.COM31_Tue, 12 Feb 2008 13:30:10 -0800 7772 114 26_[UNIX] HPU Format DSNTIAUL11_Gerard News24_gerard.le.roy@WANADOO.FR31_Tue, 12 Feb 2008 22:42:49 +0100324_iso-8859-1 Hi the list,

Using HPU(3.2) for DB2 V9 what about the output when the SELECT is « too complex » to be supported by HPU .

As far I understood, it will be taken by Export DB2.

But Export DB2 does’nt support FORMAT DSNTIAUL.

What FORMAT is delivered by DB2 EXPORT (DEL,IXF or WSF) ? [...] 7887 155 31_Db2 Stored Pocedure input array12_Rosina Porco17_rporco@UOTTAWA.CA31_Tue, 12 Feb 2008 18:17:01 -0500372_iso-8859-1

We are DB2 v7.1 on Z/OS

I would like to know if a DB2 SQL stored procedure can receive an array as input parameter and treat each occurrence . how would this be achieved. I suppose the IN parm could be a varchar with each occurence having a delimeter character

or possibly an insert into a temporary table which then SP would process [...] 8043 168 17_Re: [JOB POSTING]20_Luis Miguel Martinez20_luismmch66@YAHOO.COM31_Tue, 12 Feb 2008 17:22:26 -0600718_iso-8859-1 Good afternoon Ian.

I attached my resume and briefly describe my experience.

Contact number 04455 23598343 011 521 55 23598343



-- IBM, Telephony, Banking, Financials,Insurance, Government consultant for Mexico, Costa Rica and Puerto Rico clients. -- DB2 System programmer/DBA DB2 MVS/OS390/ZOS ver 4, 5, 6, 7, 8,9. -- DB2 DBA for Solaris, AIX, Linux y Windows versions 5, 6, 7.x, 8.x, 9. -- ZOS system programmer ZOS 1.4, 1.5, 1.7,1.8 -- Project Leadership and personnel management. IT projects related to implementation/migration of Operating System, Data bases, Applications, CRM, ERP, BI, Web. Several technologies: Mainframe MVS/ZOS, Unix, Linux and Windows. Planning, [...] 8212 35 45_Re: z/OS v7 - limit access using IP addresses0_25_jacampbell@ACSLINK.NET.AU31_Wed, 13 Feb 2008 20:38:54 +1100320_US-ASCII I'm not sure if you can limit access to specified IP addresses. I'm not sure you can have sufficient control over IP addresses to make it worth-while.

What you might be able to do is control access to the .DIST profile in the DSNR class. Then only recognised users could use a DDF connection. [...] 8248 168 41_DB2 for z/OS V7 - DB2 Administration Tool12_Jim McAlpine29_Jim.McAlpine@COASOLUTIONS.COM31_Wed, 13 Feb 2008 15:06:02 -0000306_us-ascii I have a need to unload and reload lots of tables at once and would like to be able to generate the JCL required automatically. Before I go and RTFM can anyone tell me if the DB2 Admin Tool is able to do this.

Jim McAlpine Email: jim.mcalpine@cedar.com Direct Dial: +44 (0)191 4827856 [...] 8417 49 53_FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 13 Feb 2008 10:31:56 -0500517_utf-8 I dunno about the admin tool, but have you considered writing out the statements you need using REXX?

Alternately, there's a technique using DSNTIAUL which writes out an extremely long record containing the JCL and UNLOAD statements, then reformats them using IEBGENER to read the "Unload" data as 80-byte records. I can't find my copy of the SQL, though. However, I can rebuild from memory and send you a sample of the SQL if you'll send me a copy of the UNLOAD statement in the format you want. [...] 8467 138 45_Re: DB2 for z/OS V7 - DB2 Administration Tool15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 13 Feb 2008 10:33:22 -0500811_us-ascii I used the DB2 Unload utility to unload a large number of tables and this generated a SYSREC and SYSPCH file for each table unloaded. The Control cards looked like:

LISTDEF UNLDLIST INCLUDE TABLESPACE DWC0002P.TWC0260P INCLUDE TABLESPACE DWC0002P.TWC0261P INCLUDE TABLESPACE DWC0002P.TWC0262P INCLUDE TABLESPACE DWC0002P.TWC0263P INCLUDE TABLESPACE DWC0002P.TWC0264P INCLUDE TABLESPACE DWC0002P.TWC0265P INCLUDE TABLESPACE DWC0002P.TWC0266P INCLUDE TABLESPACE DWC0002P.TWC0267P INCLUDE TABLESPACE DWC0002P.TWC0268P INCLUDE TABLESPACE DWC0002P.TWC0269P INCLUDE TABLESPACE DWC0002P.TWC0270P INCLUDE TABLESPACE DWC0002P.TWC0271P INCLUDE TABLESPACE DWC0002P.TWC0272P INCLUDE TABLESPACE DWC0002P.TWC0273P INCLUDE TABLESPACE DWC0002P.TWC0274P INCLUDE TABLESPACE DWC0002P.TWC0275P TEMPLATE WCDATA [...] 8606 53 47_DB2 for Z/OS V8 subquery to join transformation16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Wed, 13 Feb 2008 15:36:07 -0000390_us-ascii Hi All, I wonder if any of you have seen what I am experiencing or could point out what I'm doing wrong.

When I explain the SQL below using SPUFI the plan table reveals that the correlated subquery has been transformed to a nested loop join. However when the same code is included within a package and bound EXPLAIN(YES) the plan table contains no such transformation. [...] 8660 78 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool12_Jim McAlpine29_Jim.McAlpine@COASOLUTIONS.COM31_Wed, 13 Feb 2008 15:40:03 -0000392_iso-8859-1 Phil,

I was hoping the Admin Tool would create the UNLOAD statement for me along with the JCL

Jim McAlpine

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: 13 February 2008 15:32 To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool [...] 8739 75 45_Re: DB2 for z/OS V7 - DB2 Administration Tool14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Wed, 13 Feb 2008 15:42:40 +0000390_utf-8 Generate a table list via option 1.T On the indivual table lines use commands U.L Load Utility (input created by U) U.LO Load Utility (w/user-specified options) U.LX Load Utility (input created by UL or UX) U.TU Specify template usage (DB2 V7 and higher U.U Unload Utility (using DSNTIAUL) U.UL Unload Utility (DB2 V7 and higher U.UX Unload Utility (using REORG UNLOAD EXTERNAL) [...] 8815 91 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool26_RP, Venkatesh, (Coretechs)41_Venkatesh.RP@CONTRACTORS.NATIONALCITY.COM31_Wed, 13 Feb 2008 10:50:23 -0500285_iso-8859-1 The DB2 Admin tool does for you. Type the Database name and then type T next to the DB name. Once you see all the tables under the DB, type UTIL at the command prompt, you should be able to see unload and load options. Choose which you want and its all easy to submit. [...] 8907 157 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool0_22_sally.mir@WACHOVIA.COM31_Wed, 13 Feb 2008 10:51:26 -0500382_ISO-8859-1 It can. Just use the MIG command as if you are going to migrate the objects, and select 'No' for DDL and 'YES' for Data.



Sally A. Mir, AVP Wachovia Enterprise Data Management (336) 773-4011 IBM Certified Database Administrator DB2 9 DBA for Z/OS DB2 Universal Database V8.1 for Z/OS IBM Certified Database Associate DB2 Universal Database V8.1 Family [...] 9065 117 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool12_Jim McAlpine29_Jim.McAlpine@COASOLUTIONS.COM31_Wed, 13 Feb 2008 15:54:11 -0000450_iso-8859-1 Thanks for the reply. Do I need to have the Object Comparison Tool installed to do this. It's not at all obvious from what I have read so far.

Jim McAlpine

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of RP, Venkatesh, (Coretechs) Sent: 13 February 2008 15:50 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool [...] 9183 64 22_(z/OS) Real Time Stats0_21_mlabby@AESSUCCESS.ORG31_Wed, 13 Feb 2008 10:50:44 -0500397_us-ascii We are looking to start gathering the Real Time stats, but before getting into this project, I was wondering if anyone had an easy way to get the tables populated with the initial row. From what I am seeing it looks like the initial row for existing objects can be done using a query of the catalog to pull out the DBNAME, TSNAME, PARTITION, OBID, PSID, etc. and then some counters. [...] 9248 121 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool26_RP, Venkatesh, (Coretechs)41_Venkatesh.RP@CONTRACTORS.NATIONALCITY.COM31_Wed, 13 Feb 2008 11:03:16 -0500446_iso-8859-1 You don't need to have any other tool. Type Dbname at the 1st panel. Then Type T next to the Dbname. As said once you see all tables, type UTIL next to COMMAND line at the top. You all set.



Thanks & Regards, Venkatesh RP | NCC | Database Adminstrator | Mail Loc:16-0955 | Work:614-856-5408 | Pager: 877.203.1958 <8772031958@archwireless.net> | Fax: 614.856.5222 | Email: venkatesh.rp@contractors.nationalcity.com | [...] 9370 47 26_Re: (z/OS) Real Time Stats14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 13 Feb 2008 11:15:11 -0500545_utf-8 Last place that did this while I was there... ran REORGs of everything.

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov ________________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of mlabby@AESSUCCESS.ORG Sent: Wednesday, February 13, 2008 10:51 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] (z/OS) Real Time Stats [...] 9418 102 51_Re: DB2 for Z/OS V8 subquery to join transformation14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Wed, 13 Feb 2008 10:18:11 -0600387_US-ASCII Pursuant to the constant: " WHERE INT_FSA_PTYROL_RLP = 'AD' " Is a constant ('AD') in batch too...yes? i.e. not host variables.

Also, look at the bind options chosen in batch.

Relative to DSNHDECP...and, I'm thinking out loud here, but could the code-page have an impact? Do you execute spufi under one code page (the constant again) and another in the bind. [...] 9521 62 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool0_22_DB2information@AOL.COM29_Wed, 13 Feb 2008 11:27:10 EST461_US-ASCII Jim, You may wish to visit _www.recoveryknowledge.com_ (http://www.recoveryknowledge.com) and review the GENDB2 automated tool. It will give you several options and generate the JCL and CNTL with options to (2) change owner-id, (2) skip certain tables, ETC.

Ed.





**************The year's hottest artists on the red carpet at the Grammy Awards. Go to AOL Music. (http://music.aol.com/grammys?NCID=aolcmp00300000002565) [...] 9584 60 18_Data Load question19_Suresh Chimalakonda29_chimalakonda.suresh@GMAIL.COM31_Wed, 13 Feb 2008 11:28:36 -0500431_ISO-8859-1 Esteemed Listers

I have an input file which contains amount fields in the following format.

' -23.46' ' 33.45' ' 233.45'

Is there any option in the LOAD card that I can use to load the format listed above into a Decimal column in a DB2 table ? I am working with this on the mainframe DB2, the actual data does not contain the quotes, I just put them in them to indicate my data format clearly. [...] 9645 379 22_Re: Data Load question9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 13 Feb 2008 11:53:41 -0600443_us-ascii I don't know of a DB2 load utility, but sync sort, or the IBM sort may convert the data format. I remember using sort to convert data going the other direction.





Dee





_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Suresh Chimalakonda Sent: Wednesday, February 13, 2008 8:29 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Data Load question [...] 10025 21 22_Re: Data Load question0_30_Timothy_Brocke@NAVYFEDERAL.ORG31_Wed, 13 Feb 2008 12:54:41 -0500673_US-ASCII Try DECIMAL EXTERNAL in LOAD utility

LWLB_OUTSTAND_BAL POSITION( 57: 72) DECIMAL EXTERNAL ,

Tim Brocke Lead Sr. Database Administrator Navy Federal Credit Union 703-255-8382 (office) 703-206-3543 (fax)

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 [...] 10047 176 26_Re: (z/OS) Real Time Stats0_21_mlabby@AESSUCCESS.ORG31_Wed, 13 Feb 2008 13:04:10 -0500453_us-ascii That works after the initial row is populated to reset some of the counters, but what did they use to get the initial row created?













"Sevetson, Phil" Sent by: "DB2 Data Base Discussion List" 02/13/2008 11:15 AM Please respond to "DB2 Database Discussion list at IDUG"



To DB2-L@www.idugdb2-l.org cc [...] 10224 58 26_Re: (z/OS) Real Time Stats14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 13 Feb 2008 13:16:13 -0500627_utf-8 Hmm! I wasn't the guy who actually ran it, but I was given to understand that a REORG would cause the INSERT of the initial row. Is that not the case?

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov ________________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of mlabby@AESSUCCESS.ORG Sent: Wednesday, February 13, 2008 1:04 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] (z/OS) Real Time Stats [...] 10283 118 26_Re: (z/OS) Real Time Stats14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Wed, 13 Feb 2008 18:18:36 +0000303_utf-8 My experience with this issue is some of the mesurements in RTS like activity since the last REORG do not get updated until the corresponding utility is run.

My point is the RTS rows get created if the object is referenced in the mesurement cycle but the cumm stats are not collected. [...] 10402 102 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool9_Ali, Omar25_Omar.Ali@CITYOFBOSTON.GOV31_Wed, 13 Feb 2008 13:32:00 -0500337_iso-8859-1 I use a Rexx for my unload/loads and it's the best program that ibm have out there it works wonders if you'll I can send a sample for you

Omar Ali Senior Data Processing Systems Analysis City of Boston - Room 806 BAIS/MIS DB2 UDB for z/OS Database Administrator E-Mail Omar@cityofboston.gov Phone # (617) 635-0729 [...] 10505 125 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 13 Feb 2008 13:35:46 -0500634_utf-8 Personally, I'd love a copy. If it's more than a couple hundred lines, send it to me off-list or post it somewhere I can read (as HTML or a saved file?)

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ali, Omar Sent: Wednesday, February 13, 2008 1:32 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool [...] 10631 73 22_Re: Data Load question19_Suresh Chimalakonda29_chimalakonda.suresh@GMAIL.COM31_Wed, 13 Feb 2008 14:06:14 -0500643_ISO-8859-1 Tim I tried this in the past but I do not remember this working. But I gave this another shot on seeing your e-mail and it works, may be I did something wrong last time around.

Thank you



Thanks Suresh



On 2/13/08, Timothy_Brocke@navyfederal.org wrote: > > Try DECIMAL EXTERNAL in LOAD utility > > LWLB_OUTSTAND_BAL POSITION( 57: 72) > DECIMAL EXTERNAL , > > Tim Brocke > Lead Sr. Database Administrator > Navy Federal Credit Union > 703-255-8382 (office) > 703-206-3543 (fax) > > The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L > list [...] 10705 41 41_z/OS DB2 V8 Migration Access Path Changes13_Walter Eachus15_walt@LEHMAN.COM31_Wed, 13 Feb 2008 20:26:48 +0000439_utf-8 I know we are late to the DB2 V8 for z/OS party but we are trying to upgrade and manage the risk of DB2 Access Path Changes.

We are currently investigating a product of IBM called DB2 Path Checker and after about a week of investigation find that there is still a lot of manual checking that has to go on to "slim" the list of packages to investigate for access path changes for the worse (e.g. Service Units increased). [...] 10747 75 45_Re: z/OS DB2 V8 Migration Access Path Changes7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 13 Feb 2008 17:17:36 -0800507_iso-8859-1 Short answer to your question is yes, there are several good products that do what you want.

Name a vendor with a big booth at IDUG, and some with small booths as well, and they have a product that does what you want.

The heart of the matter is the compare function. Given a set of V7 access paths and a set of V8 paths, only show me a list of the packages and statements within those packages that are different in access path. CA nee Platinum's Plan analyzer does this well. [...] 10823 52 22_Re: Data Load question7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 13 Feb 2008 17:21:29 -0800304_iso-8859-1 Hi Suresh. If there really is only 1 column that you need to replace blanks with zeros consider writing a quick Sas program that reformats the data the way you wish. Keep the load cards simple. Obviously, you could accomplish the same thing in many Q&D languages. Q&D => Quick and Dirty. [...] 10876 84 51_Re: DB2 for Z/OS V8 subquery to join transformation13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 14 Feb 2008 01:29:09 +0000668_utf-8 Hello Stephen,

Is the package bound with DEGREE(ANY)?

Regards Terry

On Wed, 13 Feb 2008 15:36:07 -0000, Wallace, Stephen wrote:

>Hi All, >I wonder if any of you have seen what I am experiencing or could point >out what I'm doing wrong. > >When I explain the SQL below using SPUFI the plan table reveals that the >correlated subquery has been transformed to a nested loop join. However >when the same code is included within a package and bound EXPLAIN(YES) >the plan table contains no such transformation. > >SELECT DISTINCT FRST_FSA_ID , > SCND_FSA_ID , > INT_FSA_PTYROL_RLP >FROM DB2SEC2.VIA0075001 [...] 10961 76 45_Re: z/OS DB2 V8 Migration Access Path Changes12_Troy Coleman21_troy@TROYLCOLEMAN.COM31_Wed, 13 Feb 2008 22:14:19 -0600496_UTF-8 Hi Walter, SoftBase Systems is the US Reseller for Insoft DB/IQ QA. You can learn more about DB/IQ QA at the following URL: http://www.softbase.com/sbprod2a.php You can analyze all your packages and ask for only the packages that have a negative change or positive change or a specific type of access change. It is very flexible in what and how you want to report. It will also allow you to gather and analyze and compare dynamic SQL if you are concerned with your distributed applications. 11038 221 29_Inline copy of Load and reorg19_Vanitha_Subramaniam30_Vanitha_Subramaniam@SATYAM.COM31_Thu, 14 Feb 2008 09:58:32 +0530463_us-ascii Hi all,





I have used inline copy in Reorg and Load utilities instead of Load or Reorg in one step and Imagecopy in the next step. This reduces the CPU time taken in the Imagecopy step.





I am planning to propose this for production. So I like to know whether this approach will cause any problems in the future or is it having any disadvantages. I have read the following from the DBA Certification Guide. [...] 11260 133 33_Re: Inline copy of Load and reorg0_24_hhuang@DCCSH.ICBC.COM.CN31_Thu, 14 Feb 2008 15:06:12 +0800382_GB2312 Vanitha,

If you are using IBM DB2 utilities for recovery purpose, inline-copy should be OK, or you can call IBM tech support to report a bug. And as recommended generally, inline copy is NOT a good source for RECOVER TO COPY. We usually take an inline copy as a method to remove COPYP restrictions, that is, you'd better still need to do regular full image copy. [...] 11394 153 45_Re: z/OS DB2 V8 Migration Access Path Changes0_24_hhuang@DCCSH.ICBC.COM.CN31_Thu, 14 Feb 2008 15:32:56 +0800452_GB2312 Walter,

1.DB2 PATH CHECKER is not in my site now, but we tested it years ago. As you mentioned, "there is still a lot of manual checking", so we gave up that version and it seems that there are not a lot of improvements these days.

2.Many softwares, from BMC,CA, etc. They have functions like PATH CHECKER, and with minor difference each. But no one is PERFECT. They are just lines of codes, not knowing your packages at all. [...] 11548 42 47_Best method to reorg DSNDB06.SYSCOPY tablespace12_ratna iriani21_ratnairiani@YAHOO.COM31_Wed, 13 Feb 2008 23:27:35 -0800450_iso-8859-1 Hi all,

I am just assigned to maintain DB2 system (DB2 V8 running on z/OS 1.7). I found that the vsam dataset of DSNDB06.SYSCOPY has secondary extent around 139. My colleague that previously supported the DB2 system reported that he has altered the vsam dataset using ADDVOLUME after the vsam of SYSCOPY reached 128 of secondary extent. Currently the vsam secondary extent has reached 139 and the records is around 7 millions. [...] 11591 40 31_Java Frameworks & DB2 Design...19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET31_Thu, 14 Feb 2008 09:50:53 +0200481_iso-8859-9 Esteemed Members,

I receive a lot of pressure from App. Dev. Department creating PKs to each table in my DB2 Subsystem. There is NO DB2 Managed RI. All RI is Application Managed.

I have some thousands of tables, designed many years ago for legacy applications. App. Dev. is rewriting most of the applications in Java. But there is no remodeling effort. They'll use the existing design. They want PK to each table no matter if it's necessary or not... [...] 11632 52 45_Re: z/OS v7 - limit access using IP addresses19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET31_Thu, 14 Feb 2008 09:51:04 +0200615_utf-8 Natalie,

You can filter your IP addresses in the Network layer. Talk to your network guys. They do some magic and limit/filter some IPs on the router/switch level...

Regards, Cuneyt

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On > Behalf Of Natalie Faulkner > Sent: Tuesday, February 12, 2008 11:18 PM > To: DB2-L@www.idugdb2-l.org > Subject: [DB2-L] z/OS v7 - limit access using IP addresses > > > I am looking for a way to limit our ad-hoc users and application > servers to use > our DB2 Connect Gateway... > > Is there a way to [...] 11685 176 30_Re: [UNIX] HPU Format DSNTIAUL19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET31_Thu, 14 Feb 2008 09:51:06 +0200442_iso-8859-1 If you want to Export in IXF format from DB2 9 for z, use DB2 PE/EE or Connect. Run Export from your client and do select from z. It works and use your IXF file anywhere...

Regards, Cuneyt -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Gerard News Sent: Tuesday, February 12, 2008 11:43 PM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] [UNIX] HPU Format DSNTIAUL [...] 11862 122 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace0_24_hhuang@DCCSH.ICBC.COM.CN31_Thu, 14 Feb 2008 15:56:22 +0800384_GB2312 Ratna,

REORG utility is strongly recommended, image copy before and after is also recommended, and SHRLEVEL REFERENCE.

Before you REORG SYSCOPY, make it confirm that you have done ALTER SECQTY and MODIFY RECOVERY.

Years ago, in V6, I used REPRO to reorg SYSCOPY, and REBUILD INDEX, it worked well. Maybe MIGRATE and RECALL could make it too, I guess. [...] 11985 260 26_Re: (z/OS) Real Time Stats0_28_Massimo.Scarpa@PHOENIXSPA.IT31_Thu, 14 Feb 2008 08:58:54 +0100434_US-ASCII I didn't run all reorg of all objects, if I remember well I started RTS populating RORGLASTTIME with a conventional date, something like:

UPDATE SYSIBM.TABLESPACESTATS SET REORGLASTTIME = '2007-01-01-01.00.00.000000' WHERE DBNAME NOT LIKE 'DSN%' AND REORGLASTTIME IS NULL;

The same for COPY and RUNSTATS (and indexes). After that it RTS starts to collect numbers (for updates,inserts,deletes after reorg). [...] 12246 205 39_Antwort: [DB2-L] (z/OS) Real Time Stats0_16_R.Boxwell@SEG.DE31_Thu, 14 Feb 2008 09:09:17 +0100425_iso-8859-1 If you want I have an "intitalize" RTS query that is valid for V7, V8 and 9. Please contact me off-list for the code! It gets as much data from the catalog as possible (NACTIVE, NLEVELS, SPACE, EXTENTS,TOTALEROWS/ENTRIES, last STATSTIME etc.) and sets all counters to zero Then I have a set of update queries that go against SYSIBM.SYSCOPY to extract all the last Reorg, Last Load replace and COPY timestamps [...] 12452 331 43_Re: Antwort: [DB2-L] (z/OS) Real Time Stats0_28_Massimo.Scarpa@PHOENIXSPA.IT31_Thu, 14 Feb 2008 09:16:02 +0100368_ISO-8859-1 Forgot: updating all RTS tables in one shot COULD generate a peak of reorg that couldn't be managed by your system. For this reason I decided to 'initialize' RTS by steps, starting from smaller tablespaces/indexes and then going upwardIn this way I had many reorg of small object and reorgs of big objects occurred with disks/initiators ecc. not busy. [...] 12784 232 48_Antwort: [DB2-L] Java Frameworks & DB2 Design...0_15_rk@AFORMATIK.DE31_Thu, 14 Feb 2008 09:25:28 +0100621_ISO-8859-1



Cuneyt,

this is a requirement from the Java Persistence API. If they want to use it, they need them. The frameworks (among other hybernate) need them to make the mapping between classes and tables.

JSR 220: Enterprise JavaBeansTM,Version 3.0 Java Persistence API

2.1.4 Primary Keys and Entity Identity Every entity must have a primary key. The primary key must be defined on the entity that is the root of the entity hierarchy or on a mapped superclass of the entity hierarchy. The primary key must be defined exactly once in an entity hierarchy. (...) [...] 13017 111 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool15_Patrick Hignett32_Patrick.Hignett@SSSWORLDWIDE.COM31_Thu, 14 Feb 2008 08:32:49 -0000455_iso-8859-1 I would also love a copy of this please

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ali, Omar Sent: 13 February 2008 18:32 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool

I use a Rexx for my unload/loads and it's the best program that ibm have out there it works wonders if you'll I can send a sample for you [...] 13129 114 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool12_Jim McAlpine29_Jim.McAlpine@COASOLUTIONS.COM31_Thu, 14 Feb 2008 08:55:52 -0000466_iso-8859-1 Yes please Omar.

Thanks

Jim McAlpine

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ali, Omar Sent: 13 February 2008 18:32 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool

I use a Rexx for my unload/loads and it's the best program that ibm have out there it works wonders if you'll I can send a sample for you [...] 13244 130 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool9_SrinivasG21_SRINIVASG@INFOSYS.COM31_Thu, 14 Feb 2008 14:44:34 +0530635_us-ascii So would I.

Regards, Srinivas G



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Patrick Hignett Sent: Thursday, February 14, 2008 2:03 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool

I would also love a copy of this please

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ali, Omar Sent: 13 February 2008 18:32 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool [...] 13375 117 51_Re: DB2 for Z/OS V8 subquery to join transformation16_Wallace, Stephen25_stephen.wallace@LANDG.COM31_Thu, 14 Feb 2008 09:43:12 -0000542_us-ascii Thanks Terry, Our appliction packages are bound DEGREE(ANY) but SPUFI etc. are bound DEGREE(1). When the static package is rebound DEGREE(1) the subquery is rewritten.

Thanks, Steve Wallace Mainframe DBA Legal & General Assurance Society Work: 01737 374308 (7100 4308)

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Terry Purcell Sent: 14 February 2008 01:29 To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 for Z/OS V8 subquery to join transformation [...] 13493 212 33_Re: Inline copy of Load and reorg11_Bill Gannon26_gannon@PALMBEACH.K12.FL.US31_Thu, 14 Feb 2008 06:21:57 -0500443_US-ASCII Never experienced any problems using inline copy

- And while you are saving time, look into collecting and populating RUNSTATS at the same time as you do the REORG/LOAD.





The cards are something like "STATISTICS REPORT YES UPDATE ALL"









William B. Gannon - IBM Certified Solutions Expert - IBM Certified Database Administrator DB2 Universal Database V8.1 for zOS [...] 13706 310 52_Re: Antwort: [DB2-L] Java Frameworks & DB2 Design...19_Cuneyt Goksu (.NET)19_cuneytgoksu@USA.NET31_Thu, 14 Feb 2008 15:22:27 +0200552_iso-8859-1 Great explanation thank you. And the 2nd Question is;

Is "Java Persistence API" Mandatory ? Is there any other "Java Something API" that does not need this requirement? If the question is silly, I'm sorry for that, I'm not a "Java Type" person :)

Thank you, Cuneyt -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of rk@AFORMATIK.DE Sent: Thursday, February 14, 2008 10:25 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] Antwort: [DB2-L] Java Frameworks & DB2 Design... [...] 14017 113 57_Re: FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 14 Feb 2008 13:25:47 +0000315_utf-8 Omar Thank you for your kind offer to share your load / unload job REXX code. If I could make a suggestion. Part if IDUG free membership includes something called the CODE PLACE where programs, SQL snipets etc can be posted and retrived. It might be a good idea for all concerned to put your REXX there. [...] 14131 69 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 14 Feb 2008 13:40:44 +0000319_utf-8 Hello Ratna I would just like to point out that the two methods you discuss produce diffrent results. REORG will return the rows in the object to cluster sequence and evenly distribute free space. What you propose with ADRDSSU will consolidate extents but the data will remain in the same physical sequence. [...] 14201 435 31_Java Frameworks & DB2 Design...0_15_rk@AFORMATIK.DE31_Thu, 14 Feb 2008 14:48:00 +0100339_ISO-8859-1



Cuneyt,

yes, there are lots of possible implementations: - you can implement your own solution using JDBC - you can put your persistence layer on the host and call your modules from java (no limits: CICS, Stored Procedures, COBOL stuff, etc.) - you can buy another persistence API - and, and, and... [...] 14637 61 45_Re: z/OS DB2 V8 Migration Access Path Changes10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Thu, 14 Feb 2008 13:55:17 +0000335_utf-8 We didn't really worry about it. Heck the shop didn't use explains until very recently.

We did have a couple of issues with big queries, BI type stuff. Here the access path with regular runstats in V8 was worse than in V7. V8 required the correlated stats on these tables in order to go back to the best access path. [...] 14699 308 53_FW: [DB2-L] DB2 for z/OS V7 - DB2 Administration Tool9_Ali, Omar25_Omar.Ali@CITYOFBOSTON.GOV31_Thu, 14 Feb 2008 09:03:30 -0500531_us-ascii Hi Group,

I have upload the Rexx program to refresh QA Environments from PD

Its under the code place, Categories: DB2 for os390 and z/OS, Title: REXX to Refresh QA Environments,

The Code Place

Submit an article













Categories:

Application Development and SQL DB2 for LUW DB2 for OS390 and zOS Other







SubTab Category:

App Dev BI-DW LUW DBA zOS DBA Control + Click to select multiple categories. [...] 15008 130 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 14 Feb 2008 08:40:33 -0600350_windows-1250 This comes up every so often - DB2 has two modes for command processing - 1. TSO originated commands run asyncronusly. This means DB2 comes back to the user and you have to check if the command was processed. 2. BATCH originated commands run syncronusly. This means DB2 not respond to the command until it has completed processing. [...] 15139 145 52_Re: Antwort: [DB2-L] Java Frameworks & DB2 Design...0_24_Mohammad_Khan@BCBSIL.COM31_Thu, 14 Feb 2008 08:38:54 -0600522_us-ascii As far as I know "Java Persistence API" also know as Container Managed Persistance is not mandatory but it is definitely a favorite with Java type people. This API is latest incarnation of I/O modules which turn an relational databases into a indexed file systems. Set processing is discarded in favor of row at a time processing. The other option is Bean Managed Persistance which forces them to write SQL which of course is considered absurd in this day and age. You are living in interesting times Khalid [...] 15285 300 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace0_17_jtonchick@AOL.COM31_Thu, 14 Feb 2008 09:46:23 -0500325_utf-8 Don't forget that if you REORG SYSCOPY, you must also REORG SYSLGRNX. If you have the time available in your production environment, and you want to be extra safe, you could perform your REORG with the DB2 subsystem in MAINT mode. This would gurantee that no application work will be going on during your REORG. [...] 15586 98 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 14 Feb 2008 09:56:43 -0500638_utf-8 Jim, I'm confused -- this is the first I've heard of a required linkage between REORGs of SYSCOPY and SYSLGRNX. Is this documented somewhere?

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov ________________________________________ From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of jtonchick@AOL.COM Sent: Thursday, February 14, 2008 9:46 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Best method to reorg DSNDB06.SYSCOPY tablespace [...] 15685 137 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 14 Feb 2008 15:01:50 -0000444_utf-8 Not just me then :)

Looking in the DB2 V8 Util Guide (as I was just to make sure I wasn't missing something) it says:

When statistical information indicates that DSNDB06.SYSDBASE, DSNDB06.SYSPLAN, or DSNDB06.SYSPKAGE requires reorganization, you should also reorganize the corresponding directory table space. These catalog table spaces and their corresponding directory table spaces are listed in Table 78 on page 430 [...] 15823 74 45_Re: z/OS DB2 V8 Migration Access Path Changes12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Thu, 14 Feb 2008 09:15:17 -0600484_UTF-8 Walt:

I was not going to respond to this, but based on some of the replies and IBM's failure to respond, I feel I must. In interest of disclosure we make both Path Check and Path Checker.

I believe that the underlining question needs to be restated as, "Using programming methods, please tell me when the DB2 Optimizer has not given us the best Access Path." I submit that if this was doable then the DB2 Optimizer would do it and the question would be moot. [...] 15898 66 33_Re: Inline copy of Load and reorg11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Thu, 14 Feb 2008 10:29:27 -0500303_iso-8859-1 I really hope the image copy created during a reorg or load is a valid copy.

Vanitha, where did you get the impression you shouldn't rely on it to recover to copy?

If it's not a valid copy then why do it? Just FORCE it open with a START DB command and reduce the overhead. [...] 15965 185 20_Re: Trigger question11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 14 Feb 2008 09:35:55 -0600320_iso-8859-1

Wayne - I assume you meant to say when a new row is inserted with C = C1, C2 or C3. If so:

CREATE TRIGGER MYTRIG AFTER INSERT ON T1REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.C IN (C1,C2,C3)) BEGIN ATOMIC INSERT INTO T2VALUES ( .. ) ; END# Perhaps the same logic on update also. [...] 16151 82 33_Re: Inline copy of Load and reorg13_Fung, Chi-Yun23_Chi-Yun.Fung@UNISYS.COM31_Thu, 14 Feb 2008 09:58:38 -0600366_us-ascii If I remember correctly, the inline COPY during a LOAD happens after the reload phase and before the index build. If the data being loaded has dups and discarded while index building, then the inline copy will contain those dups. When you recover to that copy you will have the dups as well. You will have trouble to build the index after the recover. [...] 16234 216 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 14 Feb 2008 16:17:38 +0000330_utf-8 The issue is not when SYSCOPY gets REORGed also do SYSLGRNX. The issue is the relationship between SYSCOPY size and SYSLGRNX size.

If SYSCOPY has grown out of control, say because of lack of use of the MODIFY command, then SYSLGRNX has grown as well and merits a Peek.

Peek is not the same word as REORG. [...] 16451 57 51_Re: Best method to reorg DSNDB06.SYSCOPY tablespace14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 14 Feb 2008 16:24:09 -0000455_us-ascii And also bear in mind there will be orphan records in SYSLGRNX that you cannot get rid of

Until V9 (I think) dropping a tablespace DOES clean out SYSCOPY but DOESN'T clean out SYSLGRNX......

IBM suggest doing a MODIFY DELETE AGE(*) before a DROP TABLESPACE as Modify does do SYSLGRNX cleanup

Phil Grainger CA Product Management Director Phone: +44 (0)1753 577 733 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com [...] 16509 150 51_Re: DB2 for Z/OS V8 subquery to join transformation13_Terry Purcell18_tpurcel@US.IBM.COM31_Thu, 14 Feb 2008 16:28:46 +0000621_utf-8 Steve and I had a discussion offline regarding this topic, but I wanted to update the list with a summary.

This correlated subquery to join transformation is disabled in V7 & V8 if parallelism is enabled. This limitation does not exist in DB2 9.

Steve was able to confirm this by binding the application with DEGREE(1) to enable the transformation (originally it was DEGREE(ANY)). He used SET CURRENT DEGREE = 'ANY' in SPUFI to show that the transformation would be disabled Without setting this special register, CURRENT DEGREE defaults to the value of ZPARM CDSSRDEF. SPUFI did not disable the [...] 16660 239 33_Re: Inline copy of Load and reorg12_Paul Ogborne19_paulogborne@AOL.COM31_Thu, 14 Feb 2008 11:41:43 -0500403_us-ascii

Using FORCE will reset all pending flags and so is dangerous.

You can just add NOCOPYPEND to the load card and this will reset only the copy pending (advise not in production!).

Incidentally, the REUSE is also a time-saver if the volume of data being loaded (REPLACE) is around the same size as is already there.? This bypasses the delete define of the VSAM cluster. [...] 16900 146 33_Re: Inline copy of Load and reorg15_Joehlin, Gary L34_gary.l.joehlin@VERIZONBUSINESS.COM31_Thu, 14 Feb 2008 16:47:03 +0000337_US-ASCII Vanitha,

Your comment on the quote from the DBA Certification Guide has many of us at my shop raising eyebrows.

We are in the process of updating and then executing an actual Disaster Recovery (DR) test.

Would you be so kind to pass along the IBM Manual number, page and exact title of your reference? [...] 17047 223 33_Re: Inline copy of Load and reorg12_Paul Ogborne19_paulogborne@AOL.COM31_Thu, 14 Feb 2008 11:48:53 -0500533_us-ascii

Forgot to mention that for compressed objects?I generally KEEPDICTIONARY on LOADs as you can get a better compression dictionary on REORGs if running these reasonably frequently.



Regards, Paul.



-----Original Message----- From: Bear, Brian To: DB2-L@www.idugdb2-l.org Sent: Thu, 14 Feb 2008 15:29 Subject: Re: [DB2-L] Inline copy of Load and reorg







I really hope the image copy created during a reorg or load is a valid copy. [...] 17271 41 42_Retrieve Package name and/or collection id11_Lyn Maberry17_llmaberry@GFB.ORG31_Thu, 14 Feb 2008 16:53:15 +0000 17313 175 33_Re: Inline copy of Load and reorg11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Thu, 14 Feb 2008 12:09:17 -0500407_US-ASCII I see it in my hardcopy V7 Util Guide and Reference sc26-9945-00 page 155. It's buried in the COPYDDN parameter description. Good find Angela!

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joehlin, Gary L Sent: Thursday, February 14, 2008 11:47 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Inline copy of Load and reorg [...] 17489 197 33_Re: Inline copy of Load and reorg15_Joehlin, Gary L34_gary.l.joehlin@VERIZONBUSINESS.COM31_Thu, 14 Feb 2008 17:39:13 +0000402_US-ASCII I appreciate the reference from the IBM manual very much. That said, we are a bit more interested in the "DBA Certification Guide" reference.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bear, Brian Sent: Thursday, February 14, 2008 10:09 AM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Inline copy of Load and reorg [...] 17687 234 33_Re: Inline copy of Load and reorg16_Lavoie, Frederic29_Frederic.Lavoie@CRA-ARC.GC.CA31_Thu, 14 Feb 2008 12:43:16 -0500461_us-ascii Hello,

It is also written into the on-line V8 of DBU for z/OS

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/ com.ibm.db2.doc.ugref/chload.htm



COPYDDN (ddname1,ddname2) Specifies the DD statements for the primary (ddname1) and backup (ddname2) copy data sets for the image copy. ddname is the DD name.

The default is SYSCOPY for the primary copy. No default exists for the backup copy. [...] 17922 164 33_Re: Inline copy of Load and reorg14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Thu, 14 Feb 2008 13:20:34 -0500831_us-ascii Gary, I speculate that she's referring to one of two books, one for DB2 for z/OS V9: http://www.amazon.com/DB2-OS-Database-Administration-Certification/dp/15 83470743/ref=sr_1_1?ie=UTF8&s=books&qid=1203013074&sr=8-1 one for V8: http://www.amazon.com/Version-Certification-Guide-Information-Management /dp/0131491202/ref=sr_1_2?ie=UTF8&s=books&qid=1203013148&sr=8-2

--Phil Sevetson, NYCAPS DBA Support Financial Information Services Agency of The City of New York 450 West 33rd Street, 4th Floor New York, NY 10001 phone: (212) 857-1688 mailto: psevetson@fisa.nyc.gov -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Joehlin, Gary L Sent: Thursday, February 14, 2008 12:39 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] Inline copy of Load and reorg [...] 18087 32 25_DB2 V7 dsndb232i messages12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 14 Feb 2008 15:23:52 -0500106_US-ASCII Hello, When does the levelid of a tablespace get updated in syslgrnx?

Thanks, Jeff

18120 39 29_Re: DB2 V7 dsndb232i messages14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Thu, 14 Feb 2008 20:38:49 +0000705_utf-8 When level ID is updated is discussed in an old article by active list member Willie Favero

http://www.drj.com/drworld/content/w4_054.htm

after a header titled Down Level Page Detection.

The article was written at DB2 V4 and is still an interesting read.

Regards Avram Friedman

On Thu, 14 Feb 2008 15:23:52 -0500, Jeff Frazier wrote:

>Hello, >When does the levelid of a tablespace get updated in syslgrnx? > >Thanks, >Jeff > >The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, [...] 18160 39 29_Re: DB2 V7 dsndb232i messages13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 14 Feb 2008 14:42:17 -0600589_ISO-8859-1 I may be misreading your question.. however, the LEVELID is in the header portion of a page, not in SYSLGRNX. It's frequency of update is controlled by a DSNZPARM (or an install panel)

Willie

Jeff Frazier wrote: > > Hello, > When does the levelid of a tablespace get updated in syslgrnx? > > Thanks, > Jeff > The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L > list archives, the FAQ, and delivery preferences are at _ www.idug.org > _ under the Listserv tab. While at the > site, you can also access the IDUG [...] 18200 112 26_Re: (z/OS) Real Time Stats0_21_mlabby@AESSUCCESS.ORG31_Thu, 14 Feb 2008 15:55:21 -0500358_us-ascii I want to thank everyone for their help. In addition to the helpful comments on the list, Theresa Ryan sent me the SQL to pull out stats from the catalog and before I even had a chance to even test if I could do an Insert Into... using them, Roy Boxwell submitted a full set SQL to the IDUG Code Place this morning to do exactly that and more! [...] 18313 106 46_Re: Retrieve Package name and/or collection id11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 14 Feb 2008 15:21:12 -0600649_iso-8859-1

Lyn,

You will get the right plan name (that of the invoker) but the package name will be name of the trigger package (not very useful). See GETVARIABLE for a list of session vars you can get. I had a post on this a few months back.

Thx Suresh



Date: Thu, 14 Feb 2008 16:53:15 +0000From: llmaberry@GFB.ORGSubject: [DB2-L] Retrieve Package name and/or collection idTo: DB2-L@www.idugdb2-l.orgWe currently use a Trigger to populate columns on our table with USER, and Current_Timestamp. I would like to be able to do the same by retreiving Package name and/or collection id. Any suggestions would be [...] 18420 31 18_"0 = 1" vs. CONCAT0_24_dpetronella@PERSHING.COM31_Thu, 14 Feb 2008 16:38:29 -0500330_US-ASCII Hi,

We typically use the "OR 0 = 1" technique to discourage index access. Someone suggested that it would be better to use CONCAT because the "0 = 1" technique causes the predicate to be stage 2 while the CONCAT allows the predicate to be stage 1. Is this in-fact the case? Thanks in advance for any replies. [...] 18452 189 29_Re: DB2 V7 dsndb232i messages12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 14 Feb 2008 16:23:06 -0500563_US-ASCII We had a problem last week with syslgrnx and with ibm's aid got it back. When it was back they had us take full image copies of all objects on the subsystem plus set zparm dldfreq=0 disable downlevel checking. This system has not been down since and objects have not been stopped. We want to turn dldfreq=5 like it was before to check for downlevel checking. My concern is if we turn dldfreq back on we will start getting dsnb232i messages on objects as syslgrnx has not been updated with current rbas. We plan on stopping, set dldfreq=5, and bring [...] 18642 26 46_Re: Retrieve Package name and/or collection id17_Chris Worthington30_chris.worthington@AGRIBANK.COM31_Thu, 14 Feb 2008 21:42:09 +0000373_utf-8 I had a similar question that Suresh helped with a while back. Here's a sample trigger where I'm using the invoking plan name in an audit column on the table being updated...

CREATE TRIGGER abcdefg.aaaaaaa NO CASCADE BEFORE UPDATE ON abcdefg.abc_def_ghijk REFERENCING NEW AS UPDROW FOR EACH ROW MODE DB2SQL SET TEXT1_X = GETVARIABLE('SYSIBM.PLAN_NAME') ; [...] 18669 118 22_Re: "0 = 1" vs. CONCAT11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 14 Feb 2008 16:13:27 -0600598_iso-8859-1

Yes.. as docuemnted in the DB2 manuals. Conact for char cols, +0, (or -0, *1, /1) for numeric.

Thx Suresh> Date: Thu, 14 Feb 2008 16:38:29 -0500> From: dpetronella@PERSHING.COM> Subject: [DB2-L] "0 = 1" vs. CONCAT> To: DB2-L@www.idugdb2-l.org> > Hi,> > We typically use the "OR 0 = 1" technique to discourage index access.> Someone suggested that it would be better to use CONCAT because the "0 => 1" technique causes the predicate to be stage 2 while the CONCAT allows the> predicate to be stage 1. Is this in-fact the case? Thanks in advance> for any replies.> > > [...] 18788 18 10_Containers13_Tracy Rahmlow22_tracy.rahmlow@AMPF.COM31_Thu, 14 Feb 2008 22:03:42 +0000627_utf-8 Are there any views available in 9 that indicate the container associated to a tablespace?

Also, is there a method to determine which table is associated to a sql*.dat file?

Thanks

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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 [...] 18807 87 26_Weird behavior of db2ckbkp9_Barry Leb17_bjleb@HOTMAIL.COM31_Thu, 14 Feb 2008 17:23:44 -0500422_iso-8859-1

Has anyone seen this?

If I backup a database using uppercase letters for the dbname and then check the backup I get the following error when I use db2ckbkp against the backup image:

[1] Buffers processed: ################################################## ERROR - Unable to migrate media header from image





ERROR: Failed to verify media header. Cannot continue. [...] 18895 123 29_Re: DB2 V7 dsndb232i messages9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 14 Feb 2008 16:48:15 -0600490_windows-1250 It is the details that catch you. When you cloned the DB2E, did you copy BSDS and log's also? Levelid is in the checkpoint records on the log.

Your options are REPAIR LEVELID DSN1COPY with RESET

Mike HLS Technologes

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeff Frazier Sent: Thursday, February 14, 2008 3:23 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] DB2 V7 dsndb232i messages [...]