1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2007, week 4 2 25 39_RID pool not used due to limit exceeded21_Subscribe Db2-L Tspat23_patrickclchau@GMAIL.COM31_Sun, 22 Apr 2007 08:07:08 -0500337_- Hi, We got RID pool max set to 48M byte size. Buffer pool total at over 800M. Have a online which shown in Omegamon historical report that the RID pool access is not used due to limit exceeded=1.

The total number of record processed is around 2.4millions. I estimate the RID size required should be 2.4m x 10byte=24M only. [...] 28 50 43_Re: RID pool not used due to limit exceeded11_Tom Moulder21_tom_moulder@1SCOM.NET31_Sun, 22 Apr 2007 17:09:44 -0500306_windows-1250 DB2 will also consider the number of rows in the table, figuring that if more than 25% of the table qualifies it is cheaper to scan the table with sequential prefetch than to synchronous read the qualified rows. How many rows are in the table and how many qualify based on the predicate? [...] 79 80 43_Re: RID pool not used due to limit exceeded9_Mike Bell21_mbell11a1@VERIZON.NET31_Sun, 22 Apr 2007 17:16:20 -0500531_us-ascii and the value DB2 uses to calculate more than 25% is from the RUNSTATS data from the last BIND.

So if the last bind occurred when there were 100K rows in the table, DB2 will stop at 25K rids even if there are millions of rows now.

Mike HLS Technologies

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tom Moulder Sent: Sunday, April 22, 2007 5:10 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] RID pool not used due to limit exceeded [...] 160 215 43_Slow LOAD SHRLEVEL CHANGE for renamed table37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Mon, 23 Apr 2007 01:09:02 +0200459_iso-8859-2 Hi, We are in z/os db2 ver.7.1. I had to change values of partitionig index for 12 part. TS. To avoid the outage i created another TS with appropriate values, copied data to the new table and renamed the tables. No problems, but now LOAD SHRLEVEL CHANGE to the new table works very slowly. From Performance Monitor statistics it seems to me as if DB2 doesn't recognize that it has usefull pages in buffers (sorry for my loose interpretation). [...] 376 233 47_Re: Slow LOAD SHRLEVEL CHANGE for renamed table8_Bob Kota23_bob.kota@EXELONCORP.COM31_Mon, 23 Apr 2007 06:56:11 -0500576_iso-8859-2 Since a "Load Shrlevel Change" behaves like an insert, all your changes are getting logged. Also, how did you copy the data? Did you collect stats on the table before or during the copy?

Bob Kota Information Technology - Database Services CHQ 46/NE/010/01 Office: (312)-394-7523 Pager: (877)-396-9345

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Pospí¹il Du¹an Sent: Sunday, April 22, 2007 6:09 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Slow LOAD SHRLEVEL CHANGE for renamed table [...] 610 21 16_Re: BLOB columns13_Patric Becker21_Patric_Becker@GMX.NET31_Mon, 23 Apr 2007 08:51:34 -0500719_- Nick,

see if you can find the CD-ROM from IDUG 2006 in Vienna, there was a presentation held by Davy Goethals regarding utilities and LOBs, he's dealing intensively with them.

Hope this helps.

Have a great day !

Patric

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 632 63 45_High Volume Insert Activity - DB2 V7 for z/OS11_Jay Reavill23_Jay.Reavill@CERTEGY.COM31_Mon, 23 Apr 2007 10:14:53 -0400426_us-ascii Hello everyone,

One of our application's volume is going to be increasing significantly in the near future. We will be going from around 200,000 records processed daily to around 2 - 3 million. Obviously, this is going to cause a significant increase in the amount of insert activity on our tables. This is a realtime process with CICS transactions feeding off of MQ queues and inserting into DB2 tables. [...] 696 412 47_Re: Slow LOAD SHRLEVEL CHANGE for renamed table37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Mon, 23 Apr 2007 16:21:47 +0200428_iso-8859-2 Thank for your answer. I have supposed that when I run reorg and runstats after the data was copied into new table, that it is not important how I got the date into new table. However I used utility cursors to load all 12 parts in parallel.

Another strange thing is that when I now run load into the old-table in old original TS the load also does a synchronous read I/O for nearly every getpage requests [...] 1109 366 49_Re: High Volume Insert Activity - DB2 V7 for z/OS20_Maxie Zinsmeister Jr18_mzinsme@US.IBM.COM31_Mon, 23 Apr 2007 09:43:20 -0500525_US-ASCII

Jay, There was a session at IDUG in 2005 on insert performance...most of the info was related to V8, but it did cover some V7 considerations as well...

___________________________________________________ Maxie Zinsmeister IMS/DB2 DBA, DBA Services, Dept LJQD IBM Global Services, Americas Service Delivery IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS Internet: MZINSME@us.ibm.com Phone: (877) 224-6560 t/l 273-0684 Cell: (210) 219-3704 or 2102193704@cingularME.com [...] 1476 249 16_Re: BLOB columns10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Mon, 23 Apr 2007 16:48:31 +0200391_US-ASCII

Blobs....an headache.

I'm working hard with them and there are still some issue (see the APAR II3767) ...anyway..With reorg and IC (FULL SHRLEVEL REFERENCE) no problem until now,.We checked new PTF for UNLOAD/LOAD of xLOBS via unload utility and they work ok as it came from tests. This evening will start a new procedure to unload some histrical table in prod. [...] 1726 409 47_Re: Slow LOAD SHRLEVEL CHANGE for renamed table11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Mon, 23 Apr 2007 07:49:11 -0700304_iso-8859-2 At this point you have two sets of OBIDs for the same TS and Table names. One set is in RID Pool but the other is not.

When DB2 starts processing your load for the new set some how it does not put the new OBIDs in the RID Pool (may be because of the identical TS and Table names). [...] 2136 118 54_Re: DB2 SQL Stored Procedures - Code migration process15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Mon, 23 Apr 2007 10:51:45 -0400401_ISO-8859-1 Darsh,

We're using VSS instead of Endevor to store our SQL Stored Procedures and deploying them with DB2 Developer Workbench (free) which allows us to specify deployment parameters such as WLM, Schema (Collid), and SP Parameters such as STAY RESIDENT at deploy time. This works reasonably well for us, at the cost of some agita for me, a (previously) nearly-100% mainframe DBA. [...] 2255 26 33_ODBC transaction scope within DB211_Lyn Maberry17_llmaberry@GFB.ORG31_Mon, 23 Apr 2007 11:20:06 -0500597_- VB.Net and ODBC connect to DB2: What is the transaction scope for the following issue...??

We are using z/OS v1.4 and DB2 v7, VB.Net and ODBC by Data Direct.

We want to use VB.NET and ODBC to connect to DB2 and execute 4 Cobol Stored Procedures (Commit On Return NO), and then upon successfully execution of ALL four Stored Procedures the VB.Net program would execute a Commit or Rollback. Depending upon successful execution of ALL, the .NET application will execute an SQL Commit, or if there is a failure within the .NET or DB2 Stored Procedure application, then execute a [...] 2282 66 37_Re: ODBC transaction scope within DB211_John Miller26_John.L.Miller@ATCOITEK.COM31_Mon, 23 Apr 2007 10:55:35 -0600384_us-ascii All 4 will COMMIT/ROLLBACK assuming all the DB2Commands were assigned and executed under to the same DB2Transaction object.

If you do not use a DB2Transaction then a COMMIT will occur after every DB2 call (i.e. ODBC attribute SQL_ATTR_AUTOCOMMIT will be turned on). Using a DB2Transaction turns off AUTOCOMMIT.

Let me know if you need further explanation, [...] 2349 23 55_Re: DB2 V8 (ENFM) z/OS 1.7 - Long running Index Rebuild14_Jeff L'Italien18_azdb2dba@YAHOO.COM31_Mon, 23 Apr 2007 12:51:29 -0500553_- Bill,

Is the tablespace compressed? If so, it's possible that if rows had been updated then they could have possibly been relocated to different pages causing the unload process to have to jump around through a number of pages within the tablespace which would be evidenced by a large amount of sync I/O processing during the unload phase of the utility. You can see if this is the case by checking the farindref/nearindref values within SYSIBM.SYSTABLEPART assuming that your statistics were fairly up to date prior to the index rebuild. [...] 2373 148 47_Re: Slow LOAD SHRLEVEL CHANGE for renamed table37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Mon, 23 Apr 2007 20:30:21 +0200365_iso-8859-2 Many thanks for your advice. When I have now drop the the old table it doesn't help. Also the drop of old table and rename in the same UOW doesn't help. Only when I have created the similar table, loaded data into it and rename it to the new name, load works properly. I also don't think than OBIDs for the TS are the same - TS have different names [...] 2522 22 34_DB2 LUW v9 Advanced Certification?13_Brian Stewart23_briankstewart@GMAIL.COM31_Mon, 23 Apr 2007 12:43:31 -0600700_ISO-8859-1 Hello -

Is anyone aware of IBM having/creating a DB2 LUW v9 Advanced DBA Certification as they had for v8? I am only able to see one level of DBA certification in this regard for v9.

Thanks -

Brian

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2545 53 38_Re: DB2 LUW v9 Advanced Certification?14_Sanders, Roger24_Roger.Sanders@NETAPP.COM31_Mon, 23 Apr 2007 14:48:15 -0400428_US-ASCII Yes, work on the DB2 9 Advanced DBA Certification Exam (Exam 734) was completed recently - I was part of the team that developed this exam. It should be available soon.



Roger E. Sanders Senior Manager - IBM Alliance Engineering

Network Appliance, Inc. 7301 Kit Creek Road P.O. Box 13917 Research Triangle Park, NC 27709 Phone: (919) 476-5733 Mobile: (919) 215-8352 Email: rsanders@netapp.com [...] 2599 92 16_Re: BLOB columns10_Nicola Nur17_nick_nur@YAHOO.CA31_Mon, 23 Apr 2007 15:01:39 -0400570_iso-8859-1 Thank you Patrick Becker and Max Scarpa and Fred Orosco for your advice. Thanks Fred for the Redbook sg247270 on blobs. Nick Nur

Max Scarpa wrote: Blobs....an headache.

I'm working hard with them and there are still some issue (see the APAR II3767) ...anyway..With reorg and IC (FULL SHRLEVEL REFERENCE) no problem until now,.We checked new PTF for UNLOAD/LOAD of xLOBS via unload utility and they work ok as it came from tests. This evening will start a new procedure to unload some histrical table in prod. [...] 2692 47 39_[ADMIN] North American IDUG 2007 update13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 23 Apr 2007 14:10:08 -0500535_ISO-8859-1 In just two weeks, a bunch of us on this list will be visiting San Jose, CA for the 19th North American IDUG Conference. For those of you attending IDUG this year, here is my "Things To Do" list for you all:

1. When you register, make sure you pick up a Brown DB2-L ribbon 2. Once you get a Brown DB2-L ribbon, remember to wear it. This is the first step at letting everyone know you participate on the DB2-L list. 3. If you are in San Jose for the Sunday evening Welcome Reception (7:30-9:00 PM), we (the DB2-L [...] 2740 20 37_Re: ODBC transaction scope within DB211_Lyn Maberry17_llmaberry@GFB.ORG31_Mon, 23 Apr 2007 14:41:17 -0500792_- Is this an accurate explanation of what happens;

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp? topic=/com.ibm.db2.udb.dndp.doc/htm/frlrfIBMDataDB2DB2TransactionClassTopic .htm

but this publication is for DB2 LUW v8, would SQL Transaction management be a term used for z/OS..??

--Lyn

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 2761 58 37_Re: ODBC transaction scope within DB211_John Miller26_John.L.Miller@ATCOITEK.COM31_Mon, 23 Apr 2007 14:51:21 -0600279_us-ascii Lyn,

Yes this is accurate. The code on the link will work as indicated when connecting to either DB2 for z/OS (v7+) and on LUW. I'm not sure if SQL Transaction Management is an official term used for either LUW or z/OS but it does sum up what you are doing. [...] 2820 123 49_Re: High Volume Insert Activity - DB2 V7 for z/OS9_Tony Saul30_generalemaillists@YAHOO.COM.AU31_Tue, 24 Apr 2007 08:49:07 +1000332_iso-8859-1 Jay,

Check into the MEMBER CLUSTER option for adding to the end. Someone asked about this a few months ago and got little or no feedback (that I saw). One thing I have found is that regular REORGs and RUNSTATS should be used.

With the CICS look at the number of Threads and Protected threads may help. [...] 2944 128 49_Re: High Volume Insert Activity - DB2 V7 for z/OS15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Mon, 23 Apr 2007 20:09:11 -0500582_us-ascii You may want to think about V9 and using a partition by growth tablespace. The write-ups on this make it sound like it is designed for what you are doing.

Christopher Y. Blaicher BMC Software, Inc. Austin Development Labs (512) 340-6154 The comments made are my personal opinions. BMC Software, Inc. makes no representations or promises regarding the reliability, completeness, or accuracy of the information provided in this discussion; all readers agree not to rely on this information or take any action against BMC Software in response to this information. [...] 3073 454 59_DB2 Forum Second Quarter Meeting - Thursday April 26, 2007!9_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Tue, 24 Apr 2007 00:30:46 -0500623_iso-8859-1



DB2 Forum





Second Quarter Meeting

Thursday, April 26, 2007

8:00 AM - 12:00 PM









Location: Dallas Marriott Suites Market Center Hotel

2493 N. Stemmons Freeway

Dallas, TX 75207

214-905-0050





Breakfast Sponsor: Database-Brothers Inc. (DBI)

08:00 - 09:00 Registration and Breakfast

09:00 - 09:10 Business and Announcements

09:10 - 10:10 Accelerate Your DB2 Business On Demand Autonomically!

Scott Hayes, DBI





10:10 - 10:30 Break [...] 3528 128 49_Re: High Volume Insert Activity - DB2 V7 for z/OS14_Michael Kaplan25_micaelkp@NETVISION.NET.IL31_Tue, 24 Apr 2007 09:27:04 +0200567_us-ascii Jay,

We have about 600,000 rows inserted daily from CICS and 1.5 million from BATCH.

Some thoughts and recommendations:

1. From CICS point of view, it is better to treat as much inputs( from MSQ) as possible to perform group of SQL inserts within one CICS transaction. In my site, the average is about 130 inserts/per trans, and we run slot of 50 inserts, commit, then next slot. From CICS 2.2 ( better CICS 3.1) all CICS/DB2 transactions are executed in L8 OTE TCB and this provides some kind of parallelism in running CICS trans. [...] 3657 29 24_AD -- Join us at IDUG NA12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Tue, 24 Apr 2007 12:59:52 -0500464_- For all of you attending IDUG NA in San Jose, stop by the booth when you get a chance and enter one of several drawings and pick up one of our signature t-shirts. Drawings will be for books and other GTS gear, including my new book which contains many scripts and tuning secrets from our latest DB2 experiences. Attend my presentation if you get a chance to learn about the latest XML support in DB2 9. Or if all else fails, just stop by and say hi....Phil [...] 3687 19 29_DB2 Plan and Package question2_Su22_subha_sivaji@YAHOO.COM31_Tue, 24 Apr 2007 15:18:02 -0500657_- Hi,

We have DB2 ZOS with plans set to VALID=N OR OPERATIVE =N.

ARE THEY STILL BE LOADED INTO THE EDMPOOL AT STARTUP TIME?

Any help will be great.

Thanks, Su

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 3707 48 33_Re: DB2 Plan and Package question11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Tue, 24 Apr 2007 13:46:31 -0700480_iso-8859-1 OPERATIVE =N says: An explicit Bind or Rebind is required before plan can be allocated.

But if you have only VALID=N and AUTO BIND (ABIND parameter of Zparm)

is set to Yes, it will automatically Bind it for you at run time.



----- Original Message ----- From: "Su" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, April 24, 2007 1:18 PM Subject: [DB2-L] DB2 Plan and Package question [...] 3756 44 33_Re: DB2 Plan and Package question12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Tue, 24 Apr 2007 16:06:47 -0500439_us-ascii No

Troy Coleman IBM Certified Solutions Expert

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Su Sent: Tuesday, April 24, 2007 3:18 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Plan and Package question

Hi,

We have DB2 ZOS with plans set to VALID=N OR OPERATIVE =N.

ARE THEY STILL BE LOADED INTO THE EDMPOOL AT STARTUP TIME? [...] 3801 62 31_CALL DSNWSPM (stored procedure)16_laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Wed, 25 Apr 2007 12:05:23 +0200300_us-ascii Hello,

Does anyone know what input the stored procedure DSNWSPM needs?

Ik have imbedded the call in a COBOL programm but i can't find anywhere what de DSNWSPM needs as input. When i provide no input all i get back are zeroes. The PA and PB are I/O fields, rest is output. [...] 3864 112 35_Re: CALL DSNWSPM (stored procedure)13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 25 Apr 2007 07:30:14 -0400479_us-ascii Hi Laurens,

Have you looked at APAR II12845? That's the only place I've found any description of the procedure in question.

Stored Procedure builder Cost estimate button needs to have procedure dsnwspm created an enabled for the button to function User's need to apply ptf uq28282. for the procedure. Set up the DBRM alias. Check the DBRMLIB where you installed DSN@SPM. It may already contain a member named DSNWSPM which is an alias of DSN@SPM. ... [...] 3977 58 33_Re: DB2 Plan and Package question2_Su22_subha_sivaji@YAHOO.COM31_Wed, 25 Apr 2007 08:01:37 -0500628_- On Tue, 24 Apr 2007 16:06:47 -0500, Troy Coleman wrote:

>No > >Troy Coleman >IBM Certified Solutions Expert > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf >Of Su >Sent: Tuesday, April 24, 2007 3:18 PM >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: [DB2-L] DB2 Plan and Package question > >Hi, > >We have DB2 ZOS with plans set to VALID=N OR OPERATIVE =N. > >ARE THEY STILL BE LOADED INTO THE EDMPOOL AT STARTUP TIME? > >Any help will be great. > >Thanks, >Su > >-------------------------------------------------------------------------- 4036 228 24_DB2 and RACF not talking14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 25 Apr 2007 09:27:40 -0500588_US-ASCII We are moving all security out of DB2 over to RACF. I don't seem to be getting these two to talk to each other.

I have set up and activated RACF class DSNR: ACTIVE CLASSES = DATASET USER GROUP ACCTNUM ACICSPCT APPL BCICSPCT CCICSCMD DCICSDCT DSNR ECICSDCT ....

I have assembled the exits into SDSNEXIT: DSLIST TEST.DB2.SDSNEXIT Command ===> Name Prompt A _________ DSNHDECP _________ DSNTWR _________ DSNTZPRM _________ DSNX@XAC (unchanged from supplied exit) _________ DSN3@ATH (unchanged from supplied exit) _________ DSN3@SGN (unchanged from supplied exit) [...] 4265 28 24_DB2 and RACF not talking12_Ulrich Boche19_ulrich.boche@SVA.DE31_Wed, 25 Apr 2007 16:42:55 +0200381_ISO-8859-1 On Wednesday, 25.04.2007 at 09:27 EST, Mark E Vickers wrote: > We are moving all security out of DB2 over to RACF. > I don't seem to be getting these two to talk to each other. > > I have set up and activated RACF class DSNR: > ACTIVE CLASSES = DATASET USER GROUP ACCTNUM ACICSPCT APPL BCICSPCT CCICSCMD > DCICSDCT DSNR ECICSDCT .... > [...] 4294 137 28_Re: DB2 and RACF not talking14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 25 Apr 2007 09:44:23 -0500743_US-ASCII Sorry, DB2 v7, z/OS v1.7







Ulrich Boche Sent by: DB2 Data Base Discussion List 04/25/2007 09:42 AM Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject DB2 and RACF not talking











On Wednesday, 25.04.2007 at 09:27 EST, Mark E Vickers wrote: > We are moving all security out of DB2 over to RACF. > I don't seem to be getting these two to talk to each other. > > I have set up and activated RACF class DSNR: > ACTIVE CLASSES = DATASET USER GROUP ACCTNUM ACICSPCT APPL BCICSPCT CCICSCMD > DCICSDCT [...] 4432 98 28_Re: DB2 and RACF not talking15_Schade, Jeffrey15_JSchade@ISO.COM31_Wed, 25 Apr 2007 10:52:57 -0400613_us-ascii Mark,

What security product are you moving from to get to RACF and has that been disabled for the DB2 sub-system?

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 Mark E Vickers Sent: Wednesday, April 25, 2007 10:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 and RACF not talking [...] 4531 280 28_Re: DB2 and RACF not talking14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 25 Apr 2007 09:54:45 -0500589_US-ASCII None, only used internal DB2 security. RACF was only controlling access on entry to DB2.







"Schade, Jeffrey" Sent by: DB2 Data Base Discussion List 04/25/2007 09:52 AM Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject Re: DB2 and RACF not talking











Mark,

What security product are you moving from to get to RACF and has that been disabled for the DB2 sub-system? [...] 4812 174 50_Betr.: Re: [DB2-L] CALL DSNWSPM (stored procedure)16_laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Wed, 25 Apr 2007 16:40:44 +0200414_us-ascii Dave,

The installation of DSNWSPM is already done. I can call the procedure and i get an SQLCODE 000 back. So i supose that the call was excecuted fine.

I want to call the DSNWSPM procedure to get some information about the GET DIAGNOSTICS statement. I can not find any informatie about that statement in an application trace. (I see all the SQL statements except the get diagnostics). [...] 4987 288 28_Re: DB2 and RACF not talking11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Wed, 25 Apr 2007 08:32:51 -0700318_iso-8859-1 1- To move security from DB2 to RACF first you need to set AUTH parameter of Zparm to YES (Installation panel DSNTIPP).

2- I do not know why you have DSNX@XAC in SDSNEXIT library, following is from installation guide also:

This exit allows you to bypass some or most of DB2 authorization [...] 5276 240 28_Re: DB2 and RACF not talking11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Wed, 25 Apr 2007 09:06:24 -0700444_iso-8859-1 Update to my previous note:

You need both IRR@XACS (RACF exit) and DSNXRXAC (DB2 exit).

----- Original Message ----- From: Mark E Vickers Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, April 25, 2007 7:27 AM Subject: [DB2-L] DB2 and RACF not talking





We are moving all security out of DB2 over to RACF. I don't seem to be getting these two to talk to each other. [...] 5517 82 28_Re: DB2 and RACF not talking14_Wayne Driscoll25_wdriscoll@JMESOFTWARE.COM31_Wed, 25 Apr 2007 12:12:17 -0400555_us-ascii Mark, To get DB2 to use RACF for object access checking (at the DB2 V7 level), you must assemble the IRR@XACS member of SYS1.SAMPLIB. For DB2 V8 this changes, and the exit is shipped in SDSNSAMP, member DSNXRXAC. This module must be linked into SDSNEXIT as DSNX@XAC. For DB2 V7, the details are in the RACF Security Admin Guide manual, for DB2 V8 there is a separate manual on the use of the Access Control Exit. This exit does not check the DSNR class, this check is done at DB2 connection time, not at object access time. The classes used [...] 5600 457 54_Re: Betr.: Re: [DB2-L] CALL DSNWSPM (stored procedure)9_Agus Kwee19_askwe@OPTONLINE.NET31_Wed, 25 Apr 2007 16:33:52 +0000417_us-ascii Laurens,

What GET DIAGNOSTICS information was supposed to be returned by SYSPROC.DSNWSPM? Following are the results of my 2 tests calling DSNWSPM without knowing what values should I put in the I/O parameters:

Test1: Prior to the call: PA: x'0000000000000001' PB: x'0000000000000001' After the call: PA, PB: spaces P1: 00:00:00.008444 P2:INCONCLUSIVE P3, P4, P6, P7: 00000000 P5: 00000006 [...] 6058 102 28_Re: DB2 and RACF not talking14_Wayne Driscoll25_wdriscoll@JMESOFTWARE.COM31_Wed, 25 Apr 2007 12:35:57 -0400397_us-ascii Moe, IRR@XACS is in SYS1.SAMPLIB and is for DB2 V7 and lower, it contains a CSECT name of DSNX@XAC. DSNXRXAC is the DB2 V8 and above version of DSNX@XAC and resides in the DB2 V8 SDSNAMP library. You only need one or the other, and you MUST use the correct version, or the exit will not work. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. [...] 6161 416 28_Re: DB2 and RACF not talking15_Chris Hoelscher21_choelscher@HUMANA.COM31_Wed, 25 Apr 2007 12:42:39 -0400325_US-ASCII

can both run at the same time within the same LPAR? we support a site with test and prod on the same LPAR (subsystems using RACF) and would want to stagger implementation - so can V7 and V8 using RACF co-exist on the same LPAR?

thanks,

This is Chris Hoelscher and I approved this message! [...] 6578 198 28_Re: DB2 and RACF not talking14_Wayne Driscoll25_wdriscoll@JMESOFTWARE.COM31_Wed, 25 Apr 2007 13:03:15 -0400382_us-ascii Chris, As long as you link the exits into SDSNEXIT and steplib to them, they will coexist. The exit as shipped by DB2/RACF allows you to either put the subsystem ID in the profile name (the default) or in the class name, so you will still have separate test/prod authorization. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions are strictly my own. [...] 6777 122 28_Re: DB2 and RACF not talking11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Wed, 25 Apr 2007 10:29:54 -0700670_iso-8859-1 Wayne,

Many Thanks for update. Moe.

----- Original Message ----- From: "Wayne Driscoll" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, April 25, 2007 9:35 AM Subject: Re: [DB2-L] DB2 and RACF not talking



Moe, IRR@XACS is in SYS1.SAMPLIB and is for DB2 V7 and lower, it contains a CSECT name of DSNX@XAC. DSNXRXAC is the DB2 V8 and above version of DSNX@XAC and resides in the DB2 V8 SDSNAMP library. You only need one or the other, and you MUST use the correct version, or the exit will not work. Wayne Driscoll Product Developer JME Software LLC NOTE: All opinions [...] 6900 368 28_Re: DB2 and RACF not talking14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Wed, 25 Apr 2007 12:36:51 -0500328_US-ASCII Thanks all y'all - Wayne and Moe. I finally got my first IRR msg, DSNX@XAC was missing. Not the messages I wanted - I forgot to activate and refresh the RACF classes !! I also have some errors in my RACF definitions and activations which I still have to work out. I will holler if I get stuck. thanks again. Mark. [...] 7269 20 7_DB2 OSC33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 25 Apr 2007 19:42:34 +0200776_iso-8859-1 IBM Optimization Service Center for z/OS is now generally available for free download from the DB2 for z/OS Web site! You can check it out here: http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html

Unfortunally I don't have the license file for JAVA :-((

Regards Roland

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 7290 53 11_Re: DB2 OSC12_McKown, John29_John.Mckown@HEALTHMARKETS.COM31_Wed, 25 Apr 2007 12:58:23 -0500564_us-ascii > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schiradin,Roland > HG-Dir itb-db/dc > Sent: Wednesday, April 25, 2007 12:43 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] DB2 OSC > > > IBM Optimization Service Center for z/OS is now generally > available for free download from the DB2 for z/OS Web site! > You can check it out here: > http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html > > Unfortunally I don't have the license file for JAVA :-(( > > Regards > Roland [...] 7344 79 11_Re: DB2 OSC13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 25 Apr 2007 14:08:33 -0400693_us-ascii I believe it's the License for DB2 connect's JDBC Drivers.

Dave

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McKown, John Sent: Wednesday, April 25, 2007 1:58 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 OSC

> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schiradin,Roland HG-Dir > itb-db/dc > Sent: Wednesday, April 25, 2007 12:43 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] DB2 OSC > > > IBM Optimization Service Center for z/OS is now generally available > for free download from the DB2 for z/OS Web site! > You [...] 7424 125 11_Re: DB2 OSC12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Wed, 25 Apr 2007 15:10:11 -0400671_US-ASCII Says it is for V9 only. will it work with earlier releases? Thanks, Jeff





"Schiradin,Roland HG-Dir itb-db/dc" Sent by: DB2 Data Base Discussion List 04/25/2007 01:42 PM Please respond to DB2 Database Discussion list at IDUG



To DB2-L@WWW.IDUGDB2-L.ORG cc

Subject [DB2-L] DB2 OSC











IBM Optimization Service Center for z/OS is now generally available for free download from the DB2 for z/OS Web site! You can check it out here: http://www-306.ibm.com/software/data/db2/zos/downloads/osc.html [...] 7550 80 11_Re: DB2 OSC13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 25 Apr 2007 16:39:53 -0500681_ISO-8859-1 I did a little write up on OSC.. with demo and instructions if you want to run it with DB2 V8 NFM.

http://blogs.ittoolbox.com/database/db2zos/archives/osc-optimization-made-easy-well-at-least-easier-15662

Willie

Jeff Frazier wrote: > > Says it is for V9 only. will it work with earlier releases? > Thanks, > Jeff > > > *"Schiradin,Roland HG-Dir itb-db/dc" * > Sent by: DB2 Data Base Discussion List > > 04/25/2007 01:42 PM > Please respond to > DB2 Database Discussion list at IDUG > > > > To > DB2-L@WWW.IDUGDB2-L.ORG > cc > > Subject > [DB2-L] DB2 OSC > > > > > > [...] 7631 92 11_Re: DB2 OSC3_Les21_db2dba@BTINTERNET.COM31_Wed, 25 Apr 2007 23:39:45 +0100527_windows-1250 John I have to say that VE is a very good product and OSC looks to be taking things a step further on. Unless we embrace these technologies (as best you can windows based ones) then how will we move forward? I remember when I worked on version 2 of UDB (well it was not called that then) ... The gui crashed all the time .. Infact even the version 5 (z/Os) gui (pm) crashed regularly, v6 (z/Os) was better but still crashed, v7 was even better and v8 has seen a huge leap forward. Reading Willie's blog I see [...] 7724 86 11_Re: DB2 OSC15_Barbara Jo Nigh26_barbara.j.nigh@US.HSBC.COM31_Wed, 25 Apr 2007 16:44:00 -0700447_US-ASCII Does anyone know if this tool is available for DB2 V7 or V8?

Barbara J. Nigh - CAL261 Consultant, Database Management Systems - North America Phone: 831.754.1400 Ext. 2048 Pager: 877.406.7868 barbara.j.nigh@us.hsbc.com





"Schiradin,Roland HG-Dir itb-db/dc" DB2-L@www.idugdb2-l.org Sent by: DB2 Data cc Base Discussion List Subject [...] 7811 136 11_Re: DB2 OSC7_J Anand34_AnandJayachandran@FREIGHTLINER.COM31_Wed, 25 Apr 2007 16:52:06 -0700520_us-ascii Looks like OSC can execute only on DB2 V8 NFM or higher.

This is mentioned in Willie Favero's blog - http://blogs.ittoolbox.com/database/db2zos/archives/osc-optimization-mad e-easy-well-at-least-easier-15662

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Barbara Jo Nigh Sent: Wednesday, April 25, 2007 16:44 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 OSC

Does anyone know if this tool is available for DB2 V7 or V8? [...] 7948 345 22_Re: db2 crash on linux0_28_steve.tennant@CUSTOMS.GOV.AU31_Thu, 26 Apr 2007 12:47:26 +1000531_iso-8859-1 Can't help with the stack trace but.....

nothing is =NULL it can only be IS NULL or IS NOT NULL



-----Original Message----- From: Paul Chang [mailto:pyfchang@YAHOO.COM] Sent: Friday, 20 April 2007 05:02 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] db2 crash on linux



Hi, we have a sql which constantly make db2 server crash.

SELECT "A"."D96_CHAR0" AS "P220065_1","A"."D96_VARCHAR0" AS "D96_VARCHAR0" FROM "QA1"."D96" "A" WHERE YEAR("A"."D96_DATE0") = CAST(NULL AS double) [...] 8294 340 69_Betr.: Re: [DB2-L] Betr.: Re: [DB2-L] CALL DSNWSPM (stored procedure)16_laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Thu, 26 Apr 2007 08:12:54 +0200364_us-ascii Agus

The SYSPROC.DSNWSPM will return the following: CPU time Latch/Lock wait time Getpages Read I/O's Write I/O's

For the get diagnostics i hear people say that it is an expensive statement. On my part i would like to know how expensive. And why is it an expensive statement, is it just the CPU or does ik cause some kind of lock wait. [...] 8635 39 11_Re: DB2 OSC33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 26 Apr 2007 09:44:11 +0200515_iso-8859-1 John,

for JDBC Type4 (direct connection to DB2 z/OS instead of DB2-Connect gateway) you need a db2jcc_license_cisuz.jar file.

As it is written (?) in Java it may run also on other plattforms. (50 billion blowflies can't be wrong:-))

Roland





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McKown, John Sent: Wednesday, April 25, 2007 7:58 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 OSC [...] 8675 48 42_DB2 Express 9 and XQuery Update Facilities13_Essam Mansour23_essam.mansour@GMAIL.COM31_Thu, 26 Apr 2007 09:03:15 +0100447_ISO-8859-1 Hi everybody,

I am using DB2 Express-C 9, which provides a good support for managing XML. However, it does not support the XQuery Update Facilities.

My project demands facilities to update the XML database not only at the level of XML document, but also at the level of nodes.

I would like to know whether IBM will produce a new version of DB2 Express-C, which supports the XQuery Update Facilities, and when? [...] 8724 121 11_Re: DB2 OSC3_Les21_db2dba@BTINTERNET.COM31_Thu, 26 Apr 2007 11:46:18 +0100441_windows-1250 Hi, Willie was quite clear in his blog .. Little to no chance of it being made available for anything below v8 NFM.

Thanks

Leslie

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Barbara Jo Nigh Sent: 26 April 2007 00:44 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 OSC

Does anyone know if this tool is available for DB2 V7 or V8? [...] 8846 62 46_[zos] DSNUTILS stored procedure and LOAD DUMMY11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Thu, 26 Apr 2007 13:01:13 +0200625_us-ascii Hi, listers

Someone know how to specify a SYSREC DUMMY dataset, when doing a LOAD REPLACE using DSNUTILS stored procedure???

Thanks,

Regards



Banco de España - Aviso legal

Este mensaje, su contenido y cualquier fichero transmitido con él está dirigido únicamente a su destinatario y es confidencial. Por ello, se informa a quien lo reciba por error o tenga conocimiento del mismo sin ser su destinatario, que la información contenida en él es reservada y su uso no autorizado, por lo que en tal caso le rogamos nos lo comunique por la misma vía o por teléfono (+ 34 91 [...] 8909 88 35_Re: CALL DSNWSPM (stored procedure)9_Agus Kwee19_askwe@OPTONLINE.NET31_Thu, 26 Apr 2007 11:33:59 +0000647_iso-8859-1 Laurens,I wrote the call statement in cobol with parameter definitions based on information from sysibm.sysparms. This is the code: working-storage section.* pa and pb are char columns which specified for bit data. 01 pa pic x(8) value x'00000002'. 01 pb pic x(8) value x'00000000'. 01 p1 pic x(16) value space. 01 p2 pic x(16) value space. 01 p3 pic s9(8) binary value 0.* p4, p5, p6, p7 are defined exactly like p3. procedure division. exec sql call sysproc.dsnwspm (:pa,:pb,:p1,:p2,:p3,:p4,:p5,:p6,:p7) end-execI hope this helps. I will be very interested to see how you pass the GET DIAGNOSTICSexecution data to this procedure [...] 8998 18 14_DB2 Connect v610_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Thu, 26 Apr 2007 06:23:08 -0500704_- Does anybody know if the INTERUPT_ENABLED parameter exists in DB2 Connect v6.1?

We have a client using this that would like to set it (if it exists), but I haven't got access to their box to find out.

TIA

Steve

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 9017 194 46_Re: DB2 Express 9 and XQuery Update Facilities15_Pradeep Gunjala31_Pradeep_Gunjala@TAX.STATE.NY.US31_Thu, 26 Apr 2007 09:45:52 -0400594_US-ASCII Essam,

We are using DB2 UDB V9.1 on AIX.

We had the similar requirement and we found out that updating XML column at node and element level is not available in V9.1 it will be available in coming releases.

Searching the internet we found the following article from IBM website which basically gives you a generic Java Stored proc to update the XML column at node level. We have customized the Java stored proc for our requirement and it is working fine. It is not straight forward solution like you are expecting through XQUERY. But thought this may give you [...] 9212 79 50_Re: [zos] DSNUTILS stored procedure and LOAD DUMMY11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Thu, 26 Apr 2007 07:32:30 -0700438_iso-8859-1 How are you calling DSNUTILS?

----- Original Message ----- From: "Ivan Losada" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 26, 2007 4:01 AM Subject: [DB2-L] [zos] DSNUTILS stored procedure and LOAD DUMMY



Hi, listers

Someone know how to specify a SYSREC DUMMY dataset, when doing a LOAD REPLACE using DSNUTILS stored procedure??? [...] 9292 126 37_Websphere and DB2 V8 both on z/OS 1.710_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Thu, 26 Apr 2007 09:41:19 -0500600_us-ascii We have a Websphere server that runs two applications pointed to two different DB2 datasources on two different DB2 subsystems (DB1Z and DBT4) but the Websphere started task only contains the DB2 loadlibs for DB1Z. As long as they were both using the Type 4 driver (using DDF) everything worked fine. Yesterday they tried to change the application running on DBT4 to use the Type 2 driver (using RRSAF). After the change the DBT4 application could not make a connection to the datasource receiving a -922 error. The Websphere folks decided that they needed to add the loadlibs for DBT4 [...] 9419 192 41_Re: Websphere and DB2 V8 both on z/OS 1.711_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Thu, 26 Apr 2007 07:57:36 -0700703_iso-8859-1 -922 AUTHORIZATION FAILURE: error-type ERROR. REASON reason-code Explanation: Authorization failed because of the error indicated by error type

----- Original Message ----- From: Irwin, Jim Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thursday, April 26, 2007 7:41 AM Subject: [DB2-L] Websphere and DB2 V8 both on z/OS 1.7



We have a Websphere server that runs two applications pointed to two different DB2 datasources on two different DB2 subsystems (DB1Z and DBT4) but the Websphere started task only contains the DB2 loadlibs for DB1Z. As long as they were both using the Type 4 driver (using DDF) everything worked fine. Yesterday they tried [...] 9612 187 29_DB2 Plan and Package question17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Thu, 26 Apr 2007 11:10:57 -0400378_US-ASCII Snip

Su,

Let me take a crack at this. Are you asking what plan and package skeletons are loaded to the EDM pool when the DB2 subsystem is started? The answer to that question is nothing. Plan or package skeletons are put in the EDM pool only when one tries to execute the plan or package. [...] 9800 251 41_Re: Websphere and DB2 V8 both on z/OS 1.710_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Thu, 26 Apr 2007 11:33:51 -0500547_us-ascii We have researched the error......it is saying that the location can't be found. We believe that is because the thread it is trying to use has a connection to the DB2. The Type 2 connection should not be using the location table ....... it should be a local connection.

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Moe Safiari Sent: Thursday, April 26, 2007 9:58 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Websphere and DB2 V8 both on z/OS 1.7 [...] 10052 19 29_ADBTEP2 rexx and dsn-commands37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Thu, 26 Apr 2007 18:51:53 +0200682_iso-8859-2

Hi all, Could you be so kind and tell mi how to call my rexx or perform for example REBIND PLAN(xx) from ADBTEP2 sysin? So far i can only execute sql and DB2 commands. Thanks in advance, dusan

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 10072 278 41_Re: Websphere and DB2 V8 both on z/OS 1.713_McGrath, Gale26_Gale.McGrath@COURTS.WA.GOV31_Thu, 26 Apr 2007 09:43:29 -0700476_us-ascii Hi Jim,

We have WebSphere and DB2 V8 on z/OS 1.7 also. When using the type two driver, there is a property that points to the DB2 subsystem for the server. It is called db2.jcc.propertiesFile. That points to the file that has the db2.jcc properties. In it, it will have a property that tells what DB2 subsystem this server can use, using the type 2 driver. In our test servers, they use: db2.jcc.ssid=DB2D In our prod servers, they use: db2.jcc.ssid=DB2P [...] 10351 44 61_[Checked: H-STA] cs RE: [DB2-L] ADBTEP2 rexx and dsn-commands33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 26 Apr 2007 18:57:17 +0200575_iso-8859-2 *** INPUT STATEMENT: REBIND PACKAGE(CALF0.Z0AAPSB4); *** Implicit commit performed, number: 26

DSNX200I -DB2S REBIND SQL ERROR USING #ALEF0AD AUTHORITY PLAN=(NOT APPLICABLE) DBRM=Z0AAPSB4 STATEMENT=1314 SQLCODE=-204 SQLSTATE=42704 TOKENS=#ALEF0AD.TVTPSBM1 CSECT NAME=DSNXOTL RDS CODE=-500

Roland



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Pospí¹il Du¹an Sent: Thursday, April 26, 2007 6:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] ADBTEP2 rexx and dsn-commands [...] 10396 205 33_Re: ADBTEP2 rexx and dsn-commands14_Roy J Cornford23_roy_cornford@UK.IBM.COM31_Thu, 26 Apr 2007 18:05:57 +0100514_ISO-8859-1 For REXX (or CLISTS)

The format is REXX execname parameters

for a rebind, it's just

REBIND parameters



Regards, Roy

DB2 for z/OS European SWAT Team DB2 Development Galileo Centre MP135 Hursley Winchester SO21 2JN UK

+44 1962 816016





Pospí?il Du?an Sent by: DB2 Data Base Discussion List 26/04/2007 17:51 Please respond to DB2 Database Discussion list at IDUG [...] 10602 50 43_DB2 Express 9 AIX and XML Update Facilities12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Thu, 26 Apr 2007 12:38:49 -0500587_- Its not that DB2 9 doesn't support it, XQuery does not support it.

DB2 9 supports the XQuery 1.0 specification which does not provide for updating elements however, DB2 9 takes it a step further and supports updating elements at the document level, however only the elements to be updated need to be provided and under the covers the document is replaced. You can use the XMLUPDATE supplied stored procedure to do this, or use an UPDATE statement which requires you specify the full document. XQuery 2.0 is planned to support updates. And I suspect the next release of DB2 [...] 10653 30 31_iSeries (OS/400) DB2 Federation24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 26 Apr 2007 14:39:12 -0400914_iso-8859-1 Hi Listers, Is there any equivalent on the iSeries to DB2 for z/OS Three Part Names? That is: can I access tables on different iSeries servers *without* federation middleware like WebSphere Federation Server (formerly WebSphere Information Integrator)?

Thanks, Frank



+-------------------------------------+--------------------------------------+ | Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 | | The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs | | 3213-A Corporate Court | E-mail: fillmore@tfg-rdbms.com | | Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com | | USA | | +-------------------------------------+--------------------------------------+ | DB2 Family, Oracle, Client/Server, Distributed Database | | "Relational Database Solutions"(sm) | +----------------------------------------------------------------------------+ [...] 10684 32 62_Simplified DB2 9 LUW Installation and Updates Across a Network24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 26 Apr 2007 14:43:36 -0400298_iso-8859-1 Listers, If I have multiple DB2 servers that I want to maintain at the same software level, is there any tooling which would enable me to deploy DB2 across a network or LAN. I know I could use a "Silent Install" with a response file, but I would still have to log onto each server. [...] 10717 61 35_Re: iSeries (OS/400) DB2 Federation11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Thu, 26 Apr 2007 13:15:11 -0700447_iso-8859-1 Yes, if you are using all DB2 UDBs that are connected through DRDA and CDB (Communication Database) is populated correctly, you can use just three part name to issue SQL against any of them.

----- Original Message ----- From: "The Fillmore Group, Inc." Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 26, 2007 11:39 AM Subject: [DB2-L] iSeries (OS/400) DB2 Federation [...] 10779 24 33_DB2 for z/OS utilities comparison13_Donna Domovic28_Donna.Domovic@EXELONCORP.COM31_Thu, 26 Apr 2007 15:41:49 -0500414_- Hello,

We are in the process of determining which vendor's DB2 utilities (ie CA, CDB, BMC, IBM, etc.) would fit best in our environment. We're evaluating all of them in house but would also like to see what experts or other users think.

Does anyone have or know where a comparison of the various vendor's products could be found? I'm hoping to find information on performance and/or features. [...] 10804 45 53_Dynamic SQL access path analysis for v8 CM migrations3_Les21_db2dba@BTINTERNET.COM31_Thu, 26 Apr 2007 22:09:16 +0100474_windows-1250 Hi All,

I would like to ask if anybody has built a system for analysing and determining access path regression for Dynamic SQL?

My feelings are this can be "fairly" easily achieved using plan_tables(etc) pre and post v8 cm and rexx, however, I was wondering if any kind soul out there might be prepared to share their knowledge with me on this? It might save me a few key strokes .. and time is something I do not have at this point in time. [...] 10850 70 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Thu, 26 Apr 2007 14:39:10 -0700521_windows-1250 Of-course after creating Plan_table you can use EXPLAIN with QUERYNO against your SQL to populate Plan_Table, then analyze the row.

To me the easiest way is to use Visual Explain (Great Product), of-course it needs DB2 Connect to connect to a database.

----- Original Message ----- From: "Les" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 26, 2007 2:09 PM Subject: [DB2-L] Dynamic SQL access path analysis for v8 CM migrations [...] 10921 36 38_Re: DB2 LUW v9 Advanced Certification?13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Thu, 26 Apr 2007 14:45:52 -0700788_ISO-8859-1 This was just announced:

http://www-03.ibm.com/developerworks/blogs/page/SusanVisser?entry=advanced_dba_exam_now_available

Good luck,





On 4/23/07, Brian Stewart wrote: > Hello - > > Is anyone aware of IBM having/creating a DB2 LUW v9 Advanced DBA > Certification as they had for v8? I am only able to see one level of > DBA certification in this regard for v9. > > Thanks - > > Brian > > --------------------------------------------------------------------------------- > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG [...] 10958 39 57_DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails13_Brian Stewart23_briankstewart@GMAIL.COM31_Thu, 26 Apr 2007 16:36:17 -0600376_ISO-8859-1 Hello -

I have created a number of MQTs with staging tables and have been using the 'incremental' refresh option without any problems until now.

I have created the MQT and the staging table, both have a 32K pagesize, tablespace and bufferpools. I refresh the MQT and all is fine, but when I do an incremental refresh of the MQT, I get the error: [...] 10998 80 46_Re: DB2 Express 9 and XQuery Update Facilities15_Leon Katsnelson15_leon@CA.IBM.COM31_Thu, 26 Apr 2007 19:46:35 -0400448_US-ASCII Obviously you are not expecting us to preannounce anything, right! However, you can be rest assured that subdocument update is a well known and well understood high priority requirement and, we pride ourselves on being very responsive to our client's needs.

Leon Katsnelson Program Director, Technical Marketing. IBM Toronto Lab http://blogs.ittoolbox.com/database/talk/ http://DB2onRails.com/ http://db2expressc.blogspot.com/ [...] 11079 100 35_Re: iSeries (OS/400) DB2 Federation15_Leon Katsnelson15_leon@CA.IBM.COM31_Fri, 27 Apr 2007 00:19:52 -0400530_US-ASCII Frank, DB2 Connect servers contain homogeneous federation function i.e. it is included as part of DB2 Connect for iSeries (yes, we have a product like that), DB2 Connect Application Server Edition, DB2 Connect Unlimited Edition and DB2 Connect Enterprise Edition. So, if what you need to do is access multiple DB2 for i5/OS databases or DB2 for i5/OS and say DB2 for z/OS or DB2 fro AIX server in the same SQL statement you can do this with DB2 Connect. You do not need to purchase WebSphere Information Integrator. [...] 11180 103 50_Re: [zos] DSNUTILS stored procedure and LOAD DUMMY11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Fri, 27 Apr 2007 08:18:42 +0200594_us-ascii I'm using DSNREXX:

ADDRESS DSNREXX EXECSQL , "CALL SYSPROC.DSNUTILS(:UID, :RESTART,", ":UTSTMT, ", ":RETCODE, ", ":UTILITY, ", ":RECDSN ,:RECDEVT ,:RECSPACE , ", ":DISCDSN ,:DISCDEVT ,:DISCSPACE , ", ":PNCHDSN ,:PNCHDEVT ,:PNCHSPACE , ", ":COPYDSN1,:COPYDEVT1,:COPYSPACE1, ", ":COPYDSN2,:COPYDEVT2,:COPYSPACE2, ", ":RCPYDSN1,:RCPYDEVT1,:RCPYSPACE1, ", ":RCPYDSN2,:RCPYDEVT2,:RCPYSPACE2, ", ":WORKDSN1,:WORKDEVT1,:WORKSPACE1, ", ":WORKDSN2,:WORKDEVT2,:WORKSPACE2, ", ":MAPDSN ,:MAPDEVT ,:MAPSPACE , ", ":ERRDSN ,:ERRDEVT ,:ERRSPACE , ", ":FILTRDSN,:FILTRDEVT,:FILTRSPACE) " [...] 11284 146 33_Re: ADBTEP2 rexx and dsn-commands37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Fri, 27 Apr 2007 08:37:09 +0200532_iso-8859-2 many thanks; rexx is now ok. however ADBTEP2 for rebind is complaining with DSNE110E O NOT VALID SUBSYSTEM ID, COMMAND TERMINATED I have supposed that subsystem is known from SYSTSIN where I have DSN SYSTEM(DBZ0) Thanks in advance for any suggestions, dusan

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy J Cornford Sent: Thursday, April 26, 2007 7:06 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] ADBTEP2 rexx and dsn-commands [...] 11431 82 84_[zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening)10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 27 Apr 2007 08:53:05 +0200430_US-ASCII Esteemed listers

We are facing a problem causing a DB2 crash due to storage problems. It happens during night batch window and the clues point to a job (a new procedure) unloading some LOBs (CLOB) tables after

apply of PTFs UK13720 and UK14185 via IBM UNLOAD utility.

The job abended with error:

ABND=04E-00E20016,U=STCCTM ,C=XYR00.710.LOBM-DSNOPGNX,M=DSNTFRCV,LOC=DSNSLD1 .DSNSVSTK+050C [...] 11514 293 33_Re: ADBTEP2 rexx and dsn-commands33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 27 Apr 2007 09:27:27 +0200654_iso-8859-2 How do you invoke ADBTEP2?

SYSTSIN: DSN SYSTEM(DB2S) RUN PROGRAM(ADBTEP2) PLAN(ADBTEP2) - LIB('SYS5.DAD.SADBLLIB') - PARMS('/WORKLIST(SVTPSB#7) SSID(DB2S) - RESTART(YES),MAXE(-1)') END

SYSIN contains among others

RUNSTATS INDEX ( "#ALEF0AD"."IVTPSB0M1" ); REBIND PACKAGE(CALF0.Z0AAPSB1); REBIND PACKAGE(CALF0.Z0AAPSB2); REBIND PACKAGE(CALF0.Z0AAPSB4);

Roland



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Pospí¹il Du¹an Sent: Friday, April 27, 2007 8:37 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] ADBTEP2 rexx and dsn-commands [...] 11808 110 57_Re: Dynamic SQL access path analysis for v8 CM migrations3_Les21_db2dba@BTINTERNET.COM31_Fri, 27 Apr 2007 08:30:11 +0100301_windows-1250 Hi Moe

Thanks for this. VE I use a lot (and the new OSC when I get my hands on it). But it is not going to help me with 6000 Dynamic Statements , or does it do something I never new?

Also VE is not perfect in its analysis but that is off topic for this discussion. :-) [...] 11919 115 88_Re: [zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening)11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Fri, 27 Apr 2007 09:40:54 +0200676_us-ascii HI

we've test this new features, unload & load of lobs bigger than 32k, and get abends:

ABND=04E-00E40350 (with UNLOAD) or DSNU017I-REASON=X'00E40350' CAUSE=X'00000001' (with LOAD)

talk to IBM, and now we're waiting to apply maintenance, and then we'll test again.

Take a look at apar's II13767 and PK27125.

Regards

________________________________

De: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Max Scarpa Enviado el: viernes, 27 de abril de 2007 8:53 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: [DB2-L] [zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening) [...] 12035 61 88_Re: [zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening)10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 27 Apr 2007 09:58:38 +0200323_US-ASCII Hi Ivan & thank you for your reply.

I checked the APAR but it's not close to our problem.

I had some errors as well after installing new features with LOAD and we applied PTF UK14185 (if you haven't istalled it yet) which resolved the issue. But the last is a bigger problem DB2 crashed twice). [...] 12097 32 57_Re: Dynamic SQL access path analysis for v8 CM migrations12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 27 Apr 2007 03:06:37 -0700350_US-ASCII Leslie:

If you are looking for access path regression then you have to obtain the EXPLAIN from each time the SQL is placed in the cache. If you get the SQL from the cache and then explain it you will have the problem that there is no insurance that the EXPLAIN you get matches EXPLAIN the SQL received when it entered the cache. [...] 12130 72 57_Re: Dynamic SQL access path analysis for v8 CM migrations3_Les21_db2dba@BTINTERNET.COM31_Fri, 27 Apr 2007 09:14:33 +0100316_windows-1250 Gerald Yes thanks for that, you are 100% correct about that, I have seen it myself when I built/ran a very large SAP Datasharing system.

I may well concentrate on the static unload jobs with SQL in them as it might be achievable in the short time frame.

Thanks for the offer as well. [...] 12203 187 88_Re: [zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening)33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 27 Apr 2007 10:14:54 +0200311_iso-8859-1 Max,

I would open a PMR with IBM or look at the DUMP via VERBX DSNWDMP to check which area might cause the 00E20016. Sounds like a storage problem. Is you DB2 storage constraint? What is your ZPARM setting for LOBVALA LOBVALS? Perhaps you may also check the regionsize of your batch job. [...] 12391 263 88_Re: [zos] UNLOAD utility of LOBs and abend 00E20016 (+DB2 crash+sysprog hunting opening)10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 27 Apr 2007 10:31:49 +0200385_US-ASCII We did it and they suggested to apply all maintenance in APAR II10817 (still waiting PTFs pack). It's the first time we have storage problems but I saw many problems with LOBs and storage.

Actually we thinks it's a problem of LOB UNLOAD, but there's no profs, only clues, but it's the only new thing in production apart RTS (but for RTS we are current with PTFs). [...] 12655 301 41_Re: Websphere and DB2 V8 both on z/OS 1.710_Sysdba AHE18_Sysdba.AHE@TNT.COM31_Fri, 27 Apr 2007 09:44:07 +0100514_US-ASCII Jim,

Despite what Gale says, which is correct as far as it goes, we successfully connect to multiple DB2 systems through RRSAF from a single WebSphere AS (WAS) on z/OS and have done so for years.

What's required is a DRDA connection from the "primary" subsystem (in the properties file), which for the Type 2 driver acts as the DRDA AR (Application Requester), to each target DB2 (DRDA AS = Application Server). Note that the primary subsystem must be on the same MVS image as the WAS. [...] 12957 25 37_Re: DB2 for z/OS utilities comparison12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Fri, 27 Apr 2007 06:06:04 -0500453_- My, that's a big question. I'm sure that everyone has their pet favourites and their "loyalties" - I could answer wearing my IBM hat, as could Raymond in his BMC cricket cap or Phil sporting a sprightly CA number....

I'm not aware of a definitive study - each vendor has test results to prove the superiority of their product. Now that the IBM package is no longer bundled with DB2 the biggest factor is often pounds, shillings and pence. [...] 12983 142 54_Re: [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002)10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 27 Apr 2007 13:27:30 +0200323_US-ASCII Esteemed listers

I'm trying to restore in test a LOB tablespace fron an IC. In test it's only 1 vsam dataset, in prod it has 2 datasets. It happened to me in the past. I defined the second vsam via IDCAMS but when I run DSN1COPY I'm not able to use this second dataset (I'm sure I did it in the past). [...] 13126 336 0_37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Fri, 27 Apr 2007 13:29:38 +0200548_iso-8859-2 many thanks, I omitted SSID(DB2S) parameter dusan

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schiradin,Roland HG-Dir itb-db/dc Sent: Friday, April 27, 2007 9:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] ADBTEP2 rexx and dsn-commands



How do you invoke ADBTEP2?

SYSTSIN: DSN SYSTEM(DB2S) RUN PROGRAM(ADBTEP2) PLAN(ADBTEP2) - LIB('SYS5.DAD.SADBLLIB') - PARMS('/WORKLIST(SVTPSB#7) SSID(DB2S) - RESTART(YES),MAXE(-1)') END [...] 13463 31 50_Re: [zos] DSNUTILS stored procedure and LOAD DUMMY14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 27 Apr 2007 21:52:46 +1000419_US-ASCII create a dataset with zero records and specify that for SYSREC. Since there are no records, there are no records to have a wrong length, so the DCB doesn't matter.

James Campbell

On 26 Apr 2007 at 13:01, Ivan Losada wrote:

> Hi, listers > > Someone know how to specify a SYSREC DUMMY dataset, when doing a LOAD > REPLACE using DSNUTILS stored procedure??? > > Thanks, > > Regards > > [...] 13495 89 37_Re: DB2 for z/OS utilities comparison0_17_sjvagnier@AEP.COM31_Fri, 27 Apr 2007 08:20:57 -0400465_US-ASCII Hi Donna, we just went through this about 6 months ago. I am not aware of any comparison study of vendor's products. Although, I would imagine each vendor has a study of the competitors products. One of the big questions you need to answer is how soon after a new Version of DB2 is released and installed at your site do you want to take advantage of new features? Some of the non-IBM vendor's utilities only support compatibility for several months. [...] 13585 76 28_DB2 V7 Z/os v1.4 Bufferpools12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Fri, 27 Apr 2007 08:24:31 -0400495_US-ASCII Hi All,

I have a bufferpool on one of my subsystems that doesn't seem to be releasing inuse/updated pages and is staying at 85% utilization. UTILIZATION PCT : 85.4 # BUFFERS IN POOL : 30000 ALLOCATED BUFFERS : 25647 This is an index pool for us as only indexes are assigned to it. The pool has been at 85% since yesterday morning. I had to raise it to 30000 as it went into DMTH yesterday morning. I tried lowering it down this morning but then it showed 106% used/updated. [...] 13662 141 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Hugh Lapham26_hugh.lapham@RCMP-GRC.GC.CA31_Fri, 27 Apr 2007 08:38:53 -0400366_US-ASCII Check the archive for references to DSNZSCH -- I find it invaluable and have created procedures to do the following: extract the "top n" statements from the cache explain the statements report everything to an internal web site All of the above using nothing but raw utilities (DSNZSCH, DSNTIAUL etc) and a tiny bit of base SAS for the HTML reporting. [...] 13804 103 27_Unloading DB2 data from SMF11_Mark Kerner18_Mark.Kerner@PB.COM31_Fri, 27 Apr 2007 08:45:44 -0400345_US-ASCII Hi folks,

Does anyone know of a DB2 SMF data unload utility similar to the RACF SMF unload utility IRRADU00? The purpose of the utility being to create a sequential file from the DB2 SMF records which can be viewed and used for reporting and auditing.

Would you please include Lisabeth.Weber@pb.com in your response? [...] 13908 350 54_Re: [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002)33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 27 Apr 2007 15:49:38 +0200730_iso-8859-1 Max,

it's been a while ago. I believe we create a new AUX tablespace and just use.

//SAAAR1L1 EXEC PGM=DSN1COPY,PARM='FULLCOPY,LOB,OBIDXLAT,RESET' //SYSUT1 DD DISP=SHR,DSN=DB2PDBS.DALP0AA0.SAAAR1L1.P0.D05208.T170506 //SYSUT2 DD DISP=SHR,DSN=DB2PDB.DSNDBD.DALP0AA0.SAAAR2L1.I0001.A001 //SYSPRINT DD SYSOUT=* //SYSXLAT DD * 0284,0284 0055,0071 0057,0075

In no case did we specify NUMPARTS

If memory serve me right

Roland

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Friday, April 27, 2007 1:28 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002) [...] 14259 288 54_Re: [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002)8_Bob Kota23_bob.kota@EXELONCORP.COM31_Fri, 27 Apr 2007 09:02:52 -0500534_iso-8859-1 We encounter this all the time. We code the step for the A00n datasets as follows:







Bob Kota Information Technology - Database Services CHQ 46/NE/010/01 Office: (312)-394-7523 Pager: (877)-396-9345



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Schiradin,Roland HG-Dir itb-db/dc Sent: Friday, April 27, 2007 8:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002) [...] 14548 452 41_Re: Websphere and DB2 V8 both on z/OS 1.710_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Fri, 27 Apr 2007 09:04:54 -0500429_us-ascii Thanks for the responses. Looks like we will just need to set up locations on the primary subsystem. I was hoping for some type of Websphere "magic'' connection. ________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sysdba AHE Sent: Friday, April 27, 2007 3:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Websphere and DB2 V8 both on z/OS 1.7 [...] 15001 46 54_Re: [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002)10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 27 Apr 2007 16:10:37 +0200358_US-ASCII Hi Roland and Bob

There's an example in IBM site that uses NUMPARTS. If you don't code it is NUMPARTS(0) so I think it doesn't matter.

Bob I don't see your attach, probably DB2-L rejected it. Could you reporst it ?

Thank you all

Max

--------------------------------------------------------------------------------- 15048 203 54_Re: [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002)8_Bob Kota23_bob.kota@EXELONCORP.COM31_Fri, 27 Apr 2007 09:19:36 -0500970_iso-8859-1 I apologize..

//X081A EXEC PGM=DSN1COPY,

// PARM='OBIDXLAT,RESET,NUMPARTS(000),PAGESIZE(4K)'

//STEPLIB DD DSN=APF.DB2P.PRD02TP.SDSNLOAD,DISP=SHR

//SYSPRINT DD SYSOUT=*

//SYSUT1 DD DSN=DB2D.DSNDBC.PDPPLERD.TISTMSTR.I0001.A002,DISP=SHR,

// AMP=('BUFND=20')

//SYSUT2 DD DSN=DB2E.DSNDBC.PDITLERD.TISTMSTR.I0001.A002,DISP=SHR,

// AMP=('BUFND=20')

//SYSXLAT DD *

0397,0666

0044,0044

0074,0074

/*



Bob Kota Information Technology - Database Services CHQ 46/NE/010/01 Office: (312)-394-7523 Pager: (877)-396-9345



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Max Scarpa Sent: Friday, April 27, 2007 9:11 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [zos] DSN1COPY & LOB with 2 vsam (.A001 and .A002) [...] 15252 66 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 07:21:58 -0700727_iso-8859-1 Check to see if you have temp database, something like:

CREATE DATABASE TEMPDB AS TEMP;

CREATE TABLESPACE TEMPTS IN TEMPDB ........................





----- Original Message ----- From: "Brian Stewart" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 26, 2007 3:36 PM Subject: [DB2-L] DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails



> Hello - > > I have created a number of MQTs with staging tables and have been > using the 'incremental' refresh option without any problems until now. > > I have created the MQT and the staging table, both have a 32K > pagesize, tablespace and bufferpools. [...] 15319 264 57_Re: Dynamic SQL access path analysis for v8 CM migrations3_Les21_db2dba@BTINTERNET.COM31_Fri, 27 Apr 2007 15:22:59 +0100484_windows-1250 ok brilliant will do. I worked on DSNSZCH when it first came out so I know the developer quite well.

Will have a word with him and see how the land lays with any new modifications to the pgm. thanks for your help Leslie

_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hugh Lapham Sent: 27 April 2007 13:39 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Dynamic SQL access path analysis for v8 CM migrations [...] 15584 67 31_Re: Unloading DB2 data from SMF9_Ford Wong14_fordie@SHAW.CA31_Fri, 27 Apr 2007 08:27:16 -0600601_us-ascii Hello,

I use the program SMFUTIL which I believe comes with SMF.

Ford

----- Original Message ----- From: Mark Kerner Date: Friday, April 27, 2007 6:45 am Subject: [DB2-L] Unloading DB2 data from SMF

> Hi folks, > > Does anyone know of a DB2 SMF data unload utility similar to the > RACF SMF > unload utility IRRADU00? The purpose of the utility being to > create a > sequential file from the DB2 SMF records which can be viewed and > used for > reporting and auditing. > > Would you please include Lisabeth.Weber@pb.com in your response? [...] 15652 240 32_Re: DB2 V7 Z/os v1.4 Bufferpools35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 27 Apr 2007 10:45:58 -0400442_iso-8859-1 Jeff,

Some of your data does not compute. Where are you getting this from? Maybe your data source is wrong.....???

Buffers are always 100% allocated, so if your pool is 30K buffers, that's the number you have. What is Utilization %? Is this Buffers in Use (updated and/or unavailable)? How many objects do you have in the pool? How many are updated, and what is the update rate per sec, per minute for the pool? [...] 15893 122 50_Re: [zos] DSNUTILS stored procedure and LOAD DUMMY11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 07:49:38 -0700477_iso-8859-1 You need to construct RECDSN within your REXX program (the same way that you are handling UTSTMT or other parameters), take a look at DSN8EE1 (part of DSNTEJ6V - DB2 IVP Sample program and do a Find on RECDSN).

----- Original Message ----- From: "Ivan Losada" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 26, 2007 11:18 PM Subject: Re: [DB2-L] [zos] DSNUTILS stored procedure and LOAD DUMMY [...] 16016 153 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 08:14:34 -0700553_windows-1250 Hi Leslie,

I hope you are not going to analyze access path for 6000 SQL (if you are I do not know why), I usually think about analyzing of one SQL statement that I have performance problem with.

When you use EXPLAIN YES within your BIND statement DB2 is going to create one row in Plan_table for each SQL statement of that program (Plan) at execution time, so if there are 6000 SQL in one program you will see 6000 rows in Plan_table, then you can use what ever product or in-house developed method to analyze 6000 rows. [...] 16170 44 38_[z/OS v7]QMF Mass Export/Import needed15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Fri, 27 Apr 2007 11:26:01 -0400242_ISO-8859-1 Anyone know of an easy way to export/import large numbers of QMF objects? We're faced with copying a bunch ("hundreds", according to the analyst) of QMF objects from production on one LPAR/SSID to test on another LPAR/SSID.

16215 80 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails13_Brian Stewart23_briankstewart@GMAIL.COM31_Fri, 27 Apr 2007 09:29:23 -0600670_ISO-8859-1 Hello -

I have tried the suggested action (fails) and have looked through the documentation re: creating a temporary database. As far as I can see, this is unavailable in v9 for LUW.

Brian

On 4/27/07, Moe Safiari wrote: > Check to see if you have temp database, something like: > > CREATE DATABASE TEMPDB AS TEMP; > > CREATE TABLESPACE TEMPTS > IN TEMPDB ........................ > > > > ----- Original Message ----- > From: "Brian Stewart" > Newsgroups: bit.listserv.db2-l > To: > Sent: Thursday, April 26, 2007 3:36 PM > Subject: [DB2-L] DB2 LUW v9: [...] 16296 337 42_Re: [z/OS v7]QMF Mass Export/Import needed13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 27 Apr 2007 16:31:11 +0100537_us-ascii Hey Phil,

It's pretty clunky, but you could just DSNTIAUL Q.OBJECT_DATA, Q.OBJECT_REMARKS AND Q.OBJECT_something_or_other_DIRECTORY? And load resume them into your target subsystem. Think it works - haven't done it for awhile.

Cheers,



Raymond

________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Philip Sevetson Sent: 27 April 2007 16:26 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [z/OS v7]QMF Mass Export/Import needed [...] 16634 309 42_Re: [z/OS v7]QMF Mass Export/Import needed21_Williams, Ray [WHQKO]23_Ray.Williams@UNITED.COM31_Fri, 27 Apr 2007 09:34:08 -0600380_us-ascii Dynamically build your export/import commands using QMF. Save the output (import/export commands) to a dataset. Edit a proc and copy the output (import/export commands) into the proc. Execute the proc.





The only "gotcha" is the "export to name" must be eight characters. You can build a XREF during the export that can be used with the import. [...] 16944 230 42_Re: [z/OS v7]QMF Mass Export/Import needed15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Fri, 27 Apr 2007 11:35:48 -0400619_WINDOWS-1252 If I do, I'll make a serious point of taking an imagecopy of the target tablespaces first. You sure there aren't identifiers or other nonduplicatable crap in the table specs for these? Don't answer, I'll go off and look for myself. Thanks, Ray.

--Phil



On 4/27/07, Bell, Raymond wrote: > > Hey Phil, > > > > It's pretty clunky, but you could just DSNTIAUL Q.OBJECT_DATA, > Q.OBJECT_REMARKS AND Q.OBJECT_something_or_other_DIRECTORY? And load > resume them into your target subsystem. Think it works – haven't done it > for awhile. > > > > Cheers, > > > > > [...] 17175 20 27_v7 z/OS - DSNACCOR and -20416_Natalie Faulkner21_nfaulkner@WVADMIN.GOV31_Fri, 27 Apr 2007 10:26:31 -0500743_- Attempting to call procedure DSNACCOR from a batch COBOL program and receive the following error:

DSNT408I SQLCODE=-204, error: SESSION.DSNACCTMSG_TBL is an undefined name.

Any and all suggestions are appreciated...

Thanks in advance,

Natalie

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 17196 364 42_Re: [z/OS v7]QMF Mass Export/Import needed13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 27 Apr 2007 16:57:15 +0100366_us-ascii Ah, hell, Phil, I can't resist...

If you've got Log Master/Recover Plus you can use the former to retrospectively create a Quiesce point prior to the potentially vandalising load and use Recover Plus to create an image copy at that point, which you can either unload from or recover to if needed. [...] 17561 140 62_Re: Referential Integrity and other db constraint perspectives15_Tonmoy Dasgupta19_tkdasgupta@UALR.EDU31_Fri, 27 Apr 2007 16:00:37 +0000667_windows-1252 To all those who have participated in the survey “Perspectives on referential integrity & other database constraints”, I express my sincere gratitude. And to those who have not, I once again beseech participation at http://www.ualr.edu/tkdasgupta/dbquality.htm

Every response is precious. It is a short survey and depending on your answers, could actually take as little as one minute, and at most six. Any database developer who has been involved in the implementation of a new relational database, qualifies – not just the DBA. I am seeking broad based perspectives, from practices in shops large and small. The topic of database integrity [...] 17702 23 30_Data Encryption Key Management12_Susan Gudell28_susan.gudell@CPA.STATE.TX.US31_Fri, 27 Apr 2007 10:54:18 -0500594_- Esteemed listers. We are running DB2 V8 NFM on z/OS 1.6 (in process of going to 1.8) on a z900 series mainframe and are now exploring encryption via the built-in functions made available in V8. We have the manuals, Redbooks, etc. that discuss how to implement this. What we're looking for now are ideas from folks currently using this functionality on how you've implemented a key management process for encryption. How do you manage the passwords/keys? Are you encrypting them also? Do you store them outside of DB2? Did you develop your own programs to generate and retrieve the keys? [...] 17726 24 22_Matching on mixed case11_Carl Nelson22_carl.nelson@ANTHEM.COM31_Fri, 27 Apr 2007 11:04:10 -0500396_- DB2 v8 on z/OS

I have a client java application inserting mixed cased name into DB2 on the mainframe. Then they want to search the names. They currently are using

SELECT first_name from xxxxx WHERE UPPER(first_name) like 'XXXX%'

This is a very slow search. My understanding is that this becomes non-indexable. How can I speed this up? Can I match without using UPPER? [...] 17751 52 31_Re: v7 z/OS - DSNACCOR and -20433_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 27 Apr 2007 18:17:33 +0200498_iso-8859-1 In our system it's a temporary table

SESSION.DSNACCTMP_TBL SESSION.DSNACCTMSG_TBL in DSNDB06

Roland





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Natalie Faulkner Sent: Friday, April 27, 2007 5:27 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] v7 z/OS - DSNACCOR and -204



Attempting to call procedure DSNACCOR from a batch COBOL program and receive the following error: [...] 17804 53 31_Re: v7 z/OS - DSNACCOR and -2049_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 27 Apr 2007 11:22:50 -0500465_US-ASCII Well, anything with SESSION. is a temp table. If you look at DSN710.SDSNDBRM(DSN@CCOR) you will find that it is declared global temp.

Is your subsystem setup for temp tables?

Mike HLS Technologies

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Natalie Faulkner Sent: Friday, April 27, 2007 10:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] v7 z/OS - DSNACCOR and -204 [...] 17858 201 31_Re: v7 z/OS - DSNACCOR and -20414_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 27 Apr 2007 11:22:55 -0500383_US-ASCII Do you have a TEMP database ? If not..... CREATE DATABASE DSNTEMP BUFFERPOOL BP1 INDEXBP BP2 STOGROUP SYSDEFLT AS TEMP ; CREATE TABLESPACE TEMPTS01 IN DSNTEMP USING STOGROUP SYSDEFLT PRIQTY 10800 SECQTY 10800 ERASE NO FREEPAGE 0 PCTFREE 5 GBPCACHE CHANGED COMPRESS NO TRACKMOD NO SEGSIZE 64 DEFINE YES BUFFERPOOL BP1 LOCKSIZE ANY LOCKMAX SYSTEM CLOSE YES MAXROWS 255 ; [...] 18060 91 26_Re: Matching on mixed case13_FRITZ LEBLANC27_FRITZ.LEBLANC@SALLIEMAE.COM31_Fri, 27 Apr 2007 12:27:03 -0400421_US-ASCII You could consider adding a column UPPER_FIRST_NAME, populating it with a before trigger, creating an index on it, and using the new column in the selection criteria.

>>> Carl Nelson 04/27/07 12:04 PM >>> DB2 v8 on z/OS

I have a client java application inserting mixed cased name into DB2 on the mainframe. Then they want to search the names. They currently are using [...] 18152 90 34_Re: Data Encryption Key Management15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Fri, 27 Apr 2007 12:33:09 -0400650_ISO-8859-1 Umm... you might consider purchasing packaged solutions instead, as provided by IBM, Protegrity, MegaCryption... I think there are a couple of others. If you need certified high-reliability encryption solutions, that is.

--Phil, who went through the falls in a barrel on this topic, at a former employer



On 4/27/07, Susan Gudell wrote: > > Esteemed listers. We are running DB2 V8 NFM on z/OS 1.6 (in process of > going to 1.8) on a z900 series mainframe and are now exploring encryption > via the built-in functions made available in V8. We have the manuals, > Redbooks, etc. that [...] 18243 51 26_Re: Matching on mixed case11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 09:35:59 -0700652_iso-8859-1 Hi,

What is the data type for first_name column? and what is the CCSID of the table? and why do you think that column is non-indexable?



----- Original Message ----- From: "Carl Nelson" Newsgroups: bit.listserv.db2-l To: Sent: Friday, April 27, 2007 9:04 AM Subject: [DB2-L] Matching on mixed case



> DB2 v8 on z/OS > > I have a client java application inserting mixed cased name into DB2 on > the mainframe. Then they want to search the names. They currently are > using > > SELECT first_name > from xxxxx > WHERE UPPER(first_name) like 'XXXX%' > > [...] 18295 12 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails9_Jeff DeBo18_jd6306@HOTMAIL.COM31_Fri, 27 Apr 2007 11:16:03 -0500667_- I haven't worked with DB2 on Linux, but with DB2 for z/OS V9, the TEMP databases will no longer be used. Only the workfiles will be used. You might want to check the size of your 32K work files.

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 18308 350 26_Re: Matching on mixed case13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 27 Apr 2007 17:41:04 +0100351_us-ascii That's the normal/easy way of doing it. It's the difference between the Presentation layer and the Data layer. If I'm remembering my 'onion skin' model correctly. Triggers made folding the value much easier, so all those hard-worked developers have one less task to do. Gives them time to remember to call DSNTIAR, right? Yeah, right... [...] 18659 103 50_Re: [zos] DSNUTILS stored procedure and LOAD DUMMY17_Shockey, Terry L.26_TLShockey@ARKBLUECROSS.COM31_Fri, 27 Apr 2007 11:42:32 -0500444_iso-8859-1 Ivan the following works , you are not required to actually define a physical dataset . I use this method often to initialize DB2 tables:



//SYSREC00 DD DUMMY

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ivan Losada Sent: Thursday, April 26, 2007 6:01 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [zos] DSNUTILS stored procedure and LOAD DUMMY [...] 18763 382 56_Are you in Sync-o de Mayo with your DB2 Connect Systems?15_Nicole Kloeppel20_nkloeppel@ESISOFT.US31_Fri, 27 Apr 2007 10:46:09 -0600889_US-ASCII





Let the fiesta begin! Get better reporting, real-time alerts and notifications, and start managing your DB2 Connect systems like a pro.









ManageWare for DB2 Connect Webinar 5.3.2007













Thursday, May 3, 2007 9:00 AM MDT (Denver)

FREE REGISTRATION! Reply to this e-mail or call 877.638.7033 No Registration Fee RSVP requiredhttp://www.esisoft.us/images/cactus.bmp.jpg





ESI Software's ManageWare for DB2 Connect ITIL compliant solutions are designed to increase productivity and performance by enabling operators to manage their systems 24x7. With out of the box availability, easy reporting features, and automated recovery actions, ESI Software's ManageWare for DB2 Connect solution provides maximum capabilities for your IT business [...] 19146 47 23_MQT Incremental Refresh12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Fri, 27 Apr 2007 11:55:31 -0500598_- Looks like you are reaching a maximum number of columns problem with the temp table being created. Else you are doing something else wrong:). Phil

> ----- Original Message ----- > From: "Brian Stewart" > Newsgroups: bit.listserv.db2-l > To: > Sent: Thursday, April 26, 2007 3:36 PM > Subject: [DB2-L] DB2 LUW v9: Incremental Refresh of MQT Inexplicably > Fails > > > > Hello - > > > > I have created a number of MQTs with staging tables and have been > > using the 'incremental' refresh option without any problems until now. > > > [...] 19194 55 26_Re: Matching on mixed case11_Carl Nelson22_carl.nelson@ANTHEM.COM31_Fri, 27 Apr 2007 11:59:49 -0500654_- CHAR EBCDIC(37)

I could not find in the manual where the optimzier would use an index on a function. The predicate might still be stage 1 though.



On Fri, 27 Apr 2007 09:35:59 -0700, Moe Safiari wrote:

>Hi, > >What is the data type for first_name column? and what is the CCSID of the >table? and why do you think that column is non-indexable? > > >----- Original Message ----- >From: "Carl Nelson" >Newsgroups: bit.listserv.db2-l >To: >Sent: Friday, April 27, 2007 9:04 AM >Subject: [DB2-L] Matching on mixed case > > >> DB2 v8 on z/OS >> [...] 19250 194 57_Re: Dynamic SQL access path analysis for v8 CM migrations3_Les21_db2dba@BTINTERNET.COM31_Fri, 27 Apr 2007 18:21:17 +0100316_windows-1250 Hi Moe Yes been here many times before with explains .. Fairly experienced on that front. :-) Thanks for the advice though. Plan is to look for access path change in any type of dynamic .. Dsntiaul, tep2, true dynamic over drda etc ..

But looking a bit tight to get it done in two weeks :-) [...] 19445 425 30_StoreProcedures - output parms12_Rosina Porco17_rporco@UOTTAWA.CA31_Fri, 27 Apr 2007 13:39:42 -0400524_us-ascii Hi.

We are DB2 V7, on Z/OS .Using Db2connect v 8.2





I am trying to understand why an SQL stored procedure is behaving differently when executed within

the Development Center And when Executed within the Command Editor





Here is the situation :

SP1

CREATE PROCEDURE XXX.GET_PGM820 (

in I_ATTR1_CD char(6),

in I_ATTR2_CD char(8),

OUT O_MIN_CREDIT NUMERIC(2,1),

OUT O_MAX_CREDIT NUMERIC(2,1))

RESULT SETS 0 [...] 19871 91 26_Re: Matching on mixed case11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 10:42:34 -0700344_iso-8859-1 Well, I do not know if optimizer is going to use index for UPPER Function or not, I would try it, and if not that is weak portion of DB2.

But let's say Optimizer would not use Index, it means it is going to read entire table (sequential prefetch) row by row and convert first_name to Upper case then compare with 'XXXX'. [...] 19963 465 41_Re: Websphere and DB2 V8 both on z/OS 1.713_McGrath, Gale26_Gale.McGrath@COURTS.WA.GOV31_Fri, 27 Apr 2007 10:42:35 -0700413_us-ascii Neil,

We mix type Type 2 and Type 4 drivers in the same WebSphere Application Server with no problems. WAS 6.0.2.13 and WAS 6.1.0.7,

Gale

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sysdba AHE Sent: Friday, April 27, 2007 1:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Websphere and DB2 V8 both on z/OS 1.7 [...] 20429 235 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 10:54:25 -0700372_windows-1250 Hi Again,

Every program (DSNTIAUL, DSNTEP2, SPUFI, over DRDA,...etc) has to have a Plan/Package to Bind and with every BIND you can use EXPLAIN YES which is recommended for the production environment.

Else you need to come-up with a product to be able to capture plan information interactively (from Control Blocks) that I am not aware of. [...] 20665 72 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Fri, 27 Apr 2007 12:56:48 -0500323_us-ascii Based on the fact that you said you have a 32k bufferpool and the reasons given below for this message. I would assume the total row length is exceeding the page size. Split your table into two tables.



You can find more information on sql1585n by enter the following command: db2 => ? sql1585n [...] 20738 82 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Hugh Lapham26_hugh.lapham@RCMP-GRC.GC.CA31_Fri, 27 Apr 2007 13:58:47 -0400528_US-ASCII Moe -- we're talking about DYNAMIC SQL here, and that's what DSNZSCH handles. Binding a plan is dealing with STATIC SQL.

>>> From: Moe Safiari To: Date: 2007-04-27 13:56 Subject: Re: [DB2-L] Dynamic SQL access path analysis for v8 CM migrations Hi Again,

Every program (DSNTIAUL, DSNTEP2, SPUFI, over DRDA,...etc) has to have a Plan/Package to Bind and with every BIND you can use EXPLAIN YES which is recommended for the production environment. [...] 20821 182 57_Re: Dynamic SQL access path analysis for v8 CM migrations11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 11:21:59 -0700519_iso-8859-1 Thanks for correcting me.

I do not know about DSNZSCH and I should have said EXPLAIN could be for any SQL from a Dynamic Application (DSNTEP2,...etc) but as Leslie mentioned before it is not going to work for her, it looks she needs a vendor product.

Thanks again. Moe. ----- Original Message ----- From: Hugh Lapham Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, April 27, 2007 10:58 AM Subject: Re: [DB2-L] Dynamic SQL access path analysis for v8 CM migrations [...] 21004 127 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails13_Brian Stewart23_briankstewart@GMAIL.COM31_Fri, 27 Apr 2007 12:58:07 -0600511_ISO-8859-1 Hello -

I have a row size of about 30,000 bytes plus overhead (under the 32K limit):

[instei@db-001 instei]$ db2 "select sum(length) from syscat.columns where tabname = 'S_MQT_TAKS'"

1 ----------- 30001

1 record(s) selected.



and a column count of 140:

[instei@db-001 instei]$ db2 "select count(colname) from syscat.columns where tabname = 'S_MQT_TAKS'"

1 ----------- 140

1 record(s) selected.

And the temporary tablespaces: [...] 21132 125 26_Re: Matching on mixed case13_Terry Purcell18_tpurcel@US.IBM.COM31_Fri, 27 Apr 2007 15:03:27 -0500342_- I would like to address the comment "if not that is weak portion of DB2".

To perform an exact match on a mixed case string (of which you don't know which characters are upper and which are lower), then you need to equalize either the column value to a single case, or generate the possible combinations of the comparison value. [...] 21258 171 61_Re: DB2 LUW v9: Incremental Refresh of MQT Inexplicably Fails16_Dave Stritzinger19_davestr@COMCAST.NET31_Fri, 27 Apr 2007 16:58:36 -0400517_iso-8859-1 Brian,

We you run the refresh, can you tell which TEMP table space DB2 is using? I am not sure if a snapshot for tablespaces while the refresh is running will give this to you or not. You should see activity in the some TEMP tablespace. The reason I asked is a had an issue, and the details in my mind are somewhat fuzzy, where DB2 was picking a temp tablespace that was not the one I expected it to use. Also in the back of my mind I seem to remember that between V7 and V8 the algorithm used [...] 21430 152 26_Re: Matching on mixed case11_Moe Safiari26_msafiari@EMAIL.ARIZONA.EDU31_Fri, 27 Apr 2007 14:35:13 -0700643_iso-8859-1 Hi Terry,

I do appreciate when I learn something, Thank you very much for update.

Moe.

----- Original Message ----- From: "Terry Purcell" Newsgroups: bit.listserv.db2-l To: Sent: Friday, April 27, 2007 1:03 PM Subject: Re: [DB2-L] Matching on mixed case



>I would like to address the comment "if not that is weak portion of DB2". > > To perform an exact match on a mixed case string (of which you don't know > which characters are upper and which are lower), then you need to equalize > either the column value to a single case, or generate the [...] 21583 24 31_Re: Unloading DB2 data from SMF15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Fri, 27 Apr 2007 18:08:05 -0400745_us-ascii Actually SMFUTIL is sold by ASPG and does not come with SMF. However, I highly recommend SMFUTIL. It is much easier to maintain your SMF data with this product.

Lizette



--Hello, -- --I use the program SMFUTIL which I believe comes with SMF. --

--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm 21608 243 57_Re: Dynamic SQL access path analysis for v8 CM migrations12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Fri, 27 Apr 2007 23:40:08 -0500375_us-ascii Hi Leslie,

There are many products on the market that can capture your performance data and report on the top 10 or 20 that need to be looked at from a performance CPU usage or elapse time. These are the problem statements you want to look at first to support the production slow downs. However, it is always better to be proactive rather than reactive. [...] 21852 378 42_Re: [z/OS v7]QMF Mass Export/Import needed12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 28 Apr 2007 11:27:34 +0300635_us-ascii Hi,

BTDT, works fine. Good for mass transfer. IC of target is a must ;-)



Isaac Yassin

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Philip Sevetson Sent: Friday, April 27, 2007 6:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [z/OS v7]QMF Mass Export/Import needed



If I do, I'll make a serious point of taking an imagecopy of the target tablespaces first. You sure there aren't identifiers or other nonduplicatable crap in the table specs for these? Don't answer, I'll go off and look for myself. Thanks, Ray. [...] 22231 34 42_Re: [zos] DSNUTILS stored procedure and LO14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 28 Apr 2007 19:01:35 +1000513_US-ASCII Does RECDSN="NULLFILE" work?

James Campbell ------------------------------------------ create a dataset with zero records and specify that for SYSREC. Since there are no records, there are no records to have a wrong length, so the DCB doesn't matter.

James Campbell

On 26 Apr 2007 at 13:01, Ivan Losada wrote:

> Hi, listers > > Someone know how to specify a SYSREC DUMMY dataset, when doing a LOAD > REPLACE using DSNUTILS stored procedure??? > > Thanks, > > Regards > > [...]