1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2009, week 5 2 78 46_Question about Linux scripting and db2 udb 9.50_18_RENUSHARMA@AOL.COM29_Thu, 28 May 2009 21:32:51 EDT622_US-ASCII Hello List

Please help me where can I find some documentation for linux scripting with db2 udb 9.5. Some examples will be nice to know.

Thanks in advance Renu **************Cooking Dinner For Two? Sign Up & Get Immediate Member-Only Savings. (http://pr.atwola.com/promoclk/100126575x1222652750x1201460983/aol?redir=http:%2F%2Fad.doubleclick.net%2Fclk%3B215225797%3B37274671%3Bq%3Fhttp:%2 F%2Frecipes.cookingfor2.pillsbury.com%2F%3FESRC%3D934)

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 81 66 39_Using CATMAINT to correct object owners19_Murari Selvakesavan21_murari_idug@YAHOO.COM31_Thu, 28 May 2009 20:32:03 -0700591_iso-8859-1 Hello List, We are on DB2 9 CM on z/OS and use RACF to control security. All of our production DBAs are connected to a RACF group that is granted with SYSADM authority. Mostly all objects are created after setting the SQLID to the RACF group. Recently we noticed that some of the Databases and Tablespaces are created using the individual DBAs' user-ids which is caused by not setting the SQLID to the RACF group. We are setting ourselves up to perform a cleanup activity to correct the impacted objects. Besides dropping and recreating the objects, to limit the application [...] 148 47 43_Re: Using CATMAINT to correct object owners14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 29 May 2009 17:55:26 +1000580_US-ASCII What exactly is the impact of this situation that you are trying to "correct"?

James Campbell



On 28 May 2009 at 20:32, Murari Selvakesavan wrote:

> > Hello List, > > We are on DB2 9 CM on z/OS and use RACF to control security. All of our production DBAs are > connected to a RACF group that is granted with SYSADM authority. Mostly all objects are created > after setting the SQLID to the RACF group. Recently we noticed that some of the Databases and > Tablespaces are created using the individual DBAs' user-ids which is caused by not [...] 196 36 37_SQL Programming Guideline - unleashed20_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM31_Fri, 29 May 2009 14:19:37 +0300410_us-ascii Dear DB2 Community,

As you remember, I'd requested contribution from the list to prepare SQL Programming Guideline weeks ago. There was a huge feedback arrived online / offline.

Here is all the information, I've collected; Please check the link below. http://sqlguideline.blogspot.com/

If you have modifications, suggestions etc. please use the comments section of the blog. [...] 233 76 43_Re: Using CATMAINT to correct object owners14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 29 May 2009 12:29:29 +0100385_iso-8859-1 Hi Murari

There is only one flaw in your plan if you were planning on using SCEMA SWITCH

To quote the Utility guide on CATMAINT

"new_schema_name specifies the new name for the owner, creator, or schema. The name cannot be a schema that qualifies existing objects. "

So you cannot switch a schema to ANYTHING that already qualifies an object [...] 310 106 43_Re: Using CATMAINT to correct object owners13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Fri, 29 May 2009 14:02:51 +0200326_us-ascii Hmmm... interesting... It also says it must be done while the subsystem is in Maint mode and, if you're data sharing, while all the other members are stopped. So even if you chose a completely new object qualifier/schema it's pretty invasive for all objects, not just the ones you want to change the creator of. [...] 417 69 57_Re: -254 SQLCODE on Multi-row insert V9.1 conversion mode9_Eric Long22_eric.long@HIGHMARK.COM31_Fri, 29 May 2009 12:12:03 +0000679_windows-1252 The following was received from IBM:

Action taken: Reviewed Dump and saw where the test was being made that caused this failure. Three conditions were being tested: 1) Is this a multi-row insert? Yes it is. 2) Is the SQLDA set up for a host variable array? Yes it is. 3) Is there an expression on the field? Yes there is. With that, I started searching the DB2 Documentation for any notes about multi-row insert and expressions, and I did find in the Application Programming and SQL Guide, Section 1.1, Application and SQL release incompatibilities... This paragraph: ------------------------------------------------------------------------ DB2 enforces [...] 487 168 43_Re: Using CATMAINT to correct object owners19_Murari Selvakesavan21_murari_idug@YAHOO.COM31_Fri, 29 May 2009 11:16:27 -0700661_iso-8859-1 Phil & Raymond, Thanks for your inputs. We plan to have our DB2 systems support group to check with IBM for any "quick fix" mechanisms to help resolve our issue in a less intrusive way. Thanks Murari Selvakesavan. ________________________________ From: "Bell, Raymond" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, May 29, 2009 8:02:51 AM Subject: Re: [DB2-L] Using CATMAINT to correct object owners Hmmm... interesting... It also says it must be done while the subsystem is in Maint mode and, if you're data sharing, while all the other members are stopped. So even if you chose a completely new object qualifier/schema it's [...] 656 113 43_Re: Using CATMAINT to correct object owners19_Murari Selvakesavan21_murari_idug@YAHOO.COM31_Fri, 29 May 2009 11:19:15 -0700643_iso-8859-1 A long story in short, we are trying to bring the DB objects in line with the standards. The object owners will need to be corrected from the individual user-ids to the RACF group id that has SYSADM authority. Thanks Murari Selvakesavan. ________________________________ From: James Campbell To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, May 29, 2009 3:55:26 AM Subject: Re: [DB2-L] Using CATMAINT to correct object owners What exactly is the impact of this situation that you are trying to "correct"? James Campbell On 28 May 2009 at 20:32, Murari Selvakesavan wrote: > > Hello List, > > We are on DB2 [...] 770 110 43_Re: Using CATMAINT to correct object owners9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 29 May 2009 14:58:40 -0500279_us-ascii How did the objects get created? I know that with normal DB2 security, DB2 requires that you do the SET CURRENT SQLID to an id that has the authority before you can do the create because DB2 needs to know how to cascade the revoke/drop if the authority is revoked. [...] 881 299 61_Re: z/OS DB2 V8. How to supress Leading zeroes/STRIP function13_Fleming, Mark21_MFLEMING@ALLSTATE.COM31_Fri, 29 May 2009 15:46:43 -0500427_iso-8859-1 Ray,

You may be past all this, but here are two solutions as well.

SUBSTR(' '||CHAR(C1),POSSTR(CHAR(C1),' ')-1,11)

and

CHAR(SUBSTR(' ',1,11-LENGTH(RTRIM(CHAR(C1)))) || CHAR(C1),11)

The column C1 is an INTEGER, so the CHAR(11) has a length of 11. The literal is 11 blanks. This literal needs to be the length of whatever you're converting. Use 6 if the datatype is a SMALLINT. [...] 1181 37 33_-553, Secondary Auth Id, and RACF7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 29 May 2009 13:51:58 -0700269_us-ascii I am trying to permit SET CURRENT SQLID without granting SYSADM to the world. This is for development. I get the -553 when I test access from an id who, if I read the DB2 admin book correctly, should be able to set current sqlid to the database owner ID. [...] 1219 319 61_Re: z/OS DB2 V8. How to supress Leading zeroes/STRIP function13_Fleming, Mark21_MFLEMING@ALLSTATE.COM31_Fri, 29 May 2009 16:09:41 -0500327_iso-8859-1 Perhaps an even simpler solution is:

CHAR(RIGHT(' '||RTRIM(CHAR(C1)),10),10)

You can use 11, which in my case the max due to the INTEGER data type of C1, or less if you're sure the data doesn't get truncated. This is shorter syntax and more flexible. The example above uses 10 and it worked fine. [...] 1539 87 37_Re: -553, Secondary Auth Id, and RACF12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 29 May 2009 22:49:41 +0000439_windows-1252 Are you trying to RACF access control, PERMIT, rather than GRANT and REVOKE? If not, then DSNXRXAC is not what you want.

Setting up secondary ids can be done with the connect and signon exits, a much smaller change for most situations. If you are trying to use RACF access control, then the folks on the service queue would want to see everything you did and the results. Can you get the IFCID 0314 trace records? [...] 1627 36 34_DB2 9 for z/OS books updated today12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 29 May 2009 22:59:00 +0000524_windows-1252 The following DB2 for z/OS information was updated today:

Introduction to DB2 for z/OS What's New? Planning for DB2 Version 9.1 for z/OS Installation and migration Managing performance IRLM messages and codes SQL Reference

This update applies to all softcopy formats.

Thank you,

http://publib.boulder.ibm.com/infocenter/imzic/

_____________________________________________________________________

* IDUG 09 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/NA * [...] 1664 77 43_Re: Using CATMAINT to correct object owners14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 30 May 2009 11:39:50 +1000410_US-ASCII I asked because, as I suspected, it is a "tick the box" reason. I think you will find that the cost of the effort exceeds the benefit.

I would recommend that you raise a PMR and ask IBM for assistance as I know of a technique that might work.

I am unwilling to put that technique into a public arena as it requires use of undocumented (for what will be obvious reasons) parameters. [...] 1742 79 37_Re: -553, Secondary Auth Id, and RACF7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 29 May 2009 19:03:33 -0700533_iso-8859-1 Silly me, I guessed that R Hi Roger and thank you for taking the time. Silly me, I guessed that RACF permits, connects, and SETROPTS would be less hassle than remembering my BAL from back when I really had hair. Near as I can tell, that, writing assembler, would be what was required to do it in the exits. I also noticed in the ADMIN guide that the overwhelming hints were to use RACF. Yes, I can start a trace with the IFCID(314) active. I will also open a PMR. Walt asked whether a set current SQLID could be done [...] 1822 25 41_Doug Holliday/Alcan is out of the office.13_Doug Holliday23_doug.holliday@ALCAN.COM31_Fri, 29 May 2009 22:28:45 -0400521_US-ASCII I will be out of the office starting 05/29/2009 and will not return until 06/03/2009.

I will respond to your message when I return.

_____________________________________________________________________

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

There is a discussion list for people who are going to IDUG NA09 in Denver - http://www.idug.org/cgi-bin/wa?A0=DB2-NA-IDUG-CONF-PARTICIPANT _____________________________________________________________________ [...] 1848 86 49_calling DB2 / COBOL stored procedure form web.net18_akram zein el-dein21_akramzein@HOTMAIL.COM31_Sat, 30 May 2009 12:36:18 +0000404_windows-1256

Hi listers ,it is my first particicpation to the group :-

In our company we have an important COBOL sub-routines that are called from other COBOL-programs.

Now we are looking for a method to call them from Windows/Web (MS.NET) applications.

One idea is to wrap the sub-routine call in a DB2 stored procedure and call the procedure from our Web application. [...] 1935 55 5_Tools36_=?ISO-8859-1?Q?Tor=2DRoger_L=F8ken?=18_torroger@GMAIL.COM31_Sat, 30 May 2009 14:55:44 +0200310_ISO-8859-1 Hi out there ! We have been dealing a long time with IBM DB2 tools. Query Monitor is the worst CPU consumer, and we can't keep it up in our production enviroment. Are any of you using this tool and what is your opinion ? Why we changed from BMC-tools ? Because of the "money people" of course. [...] 1991 78 53_Re: calling DB2 / COBOL stored procedure form web.net9_Mike Bell21_mbell11a1@VERIZON.NET31_Sat, 30 May 2009 09:49:30 -0500759_us-ascii Best starting point is the two redbooks. For DB2 V9

http://www.redbooks.ibm.com/abstracts/sg247604.html?Open

DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond

And the origional http://www.redbooks.ibm.com/abstracts/sg247083.html?Open

DB2 for z/OS Stored Procedures: Through the CALL and Beyond

The problems with stored procedures usually come from non-SQL processing - external files, etc.

Mike HLS Technologies





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of akram zein el-dein Sent: Saturday, May 30, 2009 7:36 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] calling DB2 / COBOL stored procedure form web.net [...] 2070 76 9_Re: Tools22_Leslie Pendlebury-Bowe21_db2dba@BTINTERNET.COM31_Sat, 30 May 2009 18:19:19 +0100380_iso-8859-1 Hi Tor, I use QM (a lot) and I have to say I disagree with you on CPU usage.

What version do you have in and more importantly what level of maintenance are you on. There is some recent maintenance which addresses cpu usage if I remember correctly.

Also, how do you have it configured I.e do you have it configured to capture every bit of the action? [...] 2147 95 66_z/OS DB2 V8, a question about DB2 disaster recover/restart and GBP0_24_hhuang@DCCSH.ICBC.COM.CN31_Sun, 31 May 2009 11:24:22 +0800568_US-ASCII Hi list,

We now have a question about DB2 disaster recover/restart and GBP.

Assume we are running DB2 data sharing with 2 stand-alone CFs. The SCA, LOCK1 and all primary GBPs reside on CF#1, and all secondary GBPs reside on CF#2. Say, we lose CF#1 and all DB2 member fail, but CF#2 is OK. Therefore, we need to play group restart. Does the survival secondary GBPs residing on CF#2 will help this group restart? I mean, is there any benefits we will get for keeping the survival secondary GBPs, such as elimination/reduce of LPL/GRECP time? [...] 2243 83 73_AUTO: Ashvin Amin/Dallas/IBM is out of the office. (returning 06/01/2009)11_Ashvin Amin17_ashvin@US.IBM.COM31_Sat, 30 May 2009 22:00:07 -0600477_US-ASCII



I am out of the office until 06/01/2009.

I will be out of the office on vacation until June 1. I will repsond to your messgaes when I return.

If you need immediate assistance, please contact Jack Mason at .... masonja@us.ibm.com or my manager, Maureen Kinard at ...mkinard@us.ibm.com



Note: This is an automated response to your message "DB2-L Digest - 30 May 2009 to 31 May 2009 (#2009-160)" sent on 5/30/09 19:00:13. [...] 2327 779 18_Re: DBM1 cpu usage13_Laila hosaini19_lshosaini@YAHOO.COM31_Sun, 31 May 2009 02:14:04 -0700650_utf-8 most of it is Other IO. Thanks In Adavance L.S.H

--- On Tue, 5/26/09, Joel Responsive Systems wrote:



From: Joel Responsive Systems Subject: Re: [DB2-L] DBM1 cpu usage To: DB2-L@WWW.IDUGDB2-L.ORG Date: Tuesday, May 26, 2009, 6:17 PM



 Laila,  The type of IO is determined by your design, catalog statistics, and sql coding. Thye CPU cost for Prefetch IO is charged to the DBM1 address space. Synch IO is charged to the application address space.  Class3 IO suspension - is this Synch IO or Other IO?  If there is a lot of Synch IO suspend [...]