1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2006, week 5 2 38 41_URGENT :: Strange behaviour. Can't insert16_Squeak Smalltalk20_wallenberg@GMAIL.COM31_Wed, 29 Nov 2006 09:12:41 +0100431_ISO-8859-1 Hi,

- Linus - Db2 8.1.6

(We run reorg inplace on the table just before this happends)

ADM5511E The object "0" of table "App1.journal" has reached the maximum possible size. (Table size 64gb)





I can insert in the table with db2 on the machine but we can't insert with our application running jdbc.

We have delete a lot of rows from the table and we have append off. [...] 41 42 47_UDB and the new daylight savings time schedule.0_29_Sherri.Sterling@BPD.TREAS.GOV31_Wed, 29 Nov 2006 08:46:21 -0500332_US-ASCII We are on UDB 8.2 fixpack 5 and it looks like we might have to go to fixpack 14 in order to get the DST patch for UDB and db2 connect. But the apar list for fixpack 14 does not contain the DST patch apar number, IY90463. Has anyone already applied the fixpack 14 and know for sure that the DST patch has been applied. [...] 84 179 51_Re: UDB and the new daylight savings time schedule.12_Travis, John25_john.travis@CAPGEMINI.COM31_Wed, 29 Nov 2006 14:11:21 -0000531_us-ascii

From the Download page :-

Note: Flash! 8.1 FixPak 14 for Windows contains the Daylight Saving Time (DST) 2007 fix. FixPak 14 for Linux and UNIX does not contain the fix for changes to Daylight Saving Time in 2007. Please refer to this flash for additional information.

PTF number: WR21377 Build level: s061108 Prerequisite: V8.1 GA Signature: 8.1.13.271 Release Date:Nov 28 2006 [...] 264 48 23_DB2CC Security Concerns13_Arnold, Kevin17_karnold@OPERS.ORG31_Wed, 29 Nov 2006 09:23:14 -0500551_iso-8859-1 First of all, I'm a security guy not a DBA (so don't use Hello,

First of all, I'm a security guy not a DBA (so don't use any big words, ok? :-) ). We are trying to find alternatives to using a Windows local DB2ADMIN on both workstations and UDB servers (v8.x) for the sake of DB2 Control Center. When DB2CC is installed, it creates a local user and group that has tremendous authorities (local admin, act as part of the operating system, run as service, etc.). Our DBA's tell us that "they HAVE to user this specific user-ID to [...] 313 111 27_Re: DB2CC Security Concerns8_Dan Tuck18_dan.tuck@GMAIL.COM31_Wed, 29 Nov 2006 08:32:30 -0600328_ISO-8859-1 In our shop, our individual userid is a member of a DB2 SYSADMIN group. This allows us the required privileges while not using the generic ID. This seems to work on Windows and UNIX.

We do revert to the generic ID for some operations due to specific file permission issues, like UNIX directory ownership. [...] 425 44 62_Re: DB2 UDB on AIX - How to interpret db2diag.log error codes?9_Lydia Lee20_Lydia.Lee@SCO.CA.GOV31_Wed, 29 Nov 2006 09:19:06 -0800476_- Hi James,

Thanks a lot for the reply. Looks like the database is up as there are normal messages right before and after the error. I wonder what is iter_action?

2006-11-26-23.02.17.899937-480 I2064811A344 LEVEL: Event PID : 843786 TID : 1443 PROC : db2hmon 0 INSTANCE: db2dss NODE : 000 FUNCTION: DB2 UDB, Automatic Table Maintenance, AtmTable::runstats, probe:900 STOP : Automatic Runstats: runstats completed successfully on table "SAPDSS "."AGR_AGRS2" [...] 470 117 62_Re: DB2 UDB on AIX - How to interpret db2diag.log error codes?12_Derez D Lusk24_derez.d.lusk@US.HSBC.COM31_Wed, 29 Nov 2006 11:25:17 -0600396_US-ASCII Based on the last two days, the job executed in CA7 using the previous day's file, before the file was NDM'ed.

Can you verify if the time trigger overrided the DSN trigger ? yesterday and today





DEREZ LUSK ENTERPRISE DATA LAYER / MARS HTSU Corporate CIM 1501 Feehanville Drive Mount Prospect, IL 60056 (0) 847-824-2871 (P) 866-203-3513 (F) 847-824-3171 [...] 588 69 38_Visual Explain against a Z/OS database17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Wed, 29 Nov 2006 11:38:15 -0600524_us-ascii Is there a way from within Visual explain to qualify a plan table owned by somone other than the primary id?



Background: The plan table is owned by DBA's, programmers want to use it, but they can't set the secondary because they are not in the DBA group Sql code -553. The are plaing on using the explain with stored procedure feature. I think we can work around this by using an alias to point to the DBA's plan table from the programmers authid. Just seems like there should be an easier way. [...] 658 47 42_Re: Visual Explain against a Z/OS database15_Patrick Bossman18_bossman@US.IBM.COM31_Wed, 29 Nov 2006 12:14:50 -0600444_- Hi Rich, This isn't purely a VE issue, this is a "use of explain table" issue. The only way to allow developers to dynamically "explain into" the DBA explain tables without connecting them to the secondary authid is the ALIAS route.

Another solution is to create a set of explain tables for the application developer group. Create their own set of tables under a schema for their own (possibly already existing) secondary authid. [...] 706 34 23_Spufi authorization ???9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 29 Nov 2006 12:35:09 -0600327_us-ascii We have a problem with our spufi in our DB2 subsystem. We went to DB2 V8 new function mode last night. Now the programmers are not authorized to use Spufi. We did not change any of the authorizations.

This is the error message.. DSNE106E PLAN DSNESPCS NOT AUTHORIZED FOR SUBSYSTEM DB2P AND AUTH ID TSXVBUB [...] 741 108 27_Re: DB2CC Security Concerns10_Gyau, Paul15_PGyau@GEICO.COM31_Wed, 29 Nov 2006 13:48:58 -0500573_us-ascii Arnold: You can do the following for Windows: A) Have the DBAs user-ids created in the domain group so that they can use their own logon credentials to logon on to the UDB Servers to perform dba functions and this will provide audit trails for SOX. Their user-ids in the domain group will be part of the administrator group on the Windows server so definetely they have the sysadam authority. B) You can also create need an id, example: db2admin, on the server which should be part of the administrator group and will be used to perform database installs and [...] 850 101 29_DB2 DBA POSITION AT BANGALORE20_desiz db2 consultant20_desig@CONSULTANT.COM31_Wed, 29 Nov 2006 13:46:00 -0500442_iso-8859-1 Dear Listers,

Below listed are the requirement for DB2 DBA for Z/OS at Banglore for a finalcial giant.

Ø Must be team-oriented, and should possess excellent oral and written communication skills, strong interpersonal skills, and the ability to interact effectively with a demanding user community. Ø Should have 3 to 5 years work experince as DB2 DBA along with hands on experinces on programming prior to this. [...] 952 21 42_Re: Visual Explain against a Z/OS database17_Gugel, Rich - DOA24_rich.gugel@WISCONSIN.GOV31_Wed, 29 Nov 2006 12:58:14 -0600286_us-ascii Thanks Pat

It's just to bad there isn't a place in the product that lets you specify the plan table (and it's buddies) qualifier that you want to work with.

I could not find where to set the schema on the tune SQL panel. I'm on the August 2006 version of VE [...] 974 103 27_Re: Spufi authorization ???0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Wed, 29 Nov 2006 14:36:28 -0500510_US-ASCII Dee,

In general, at least at my shop, DSNESPCS is granted to PUBLIC.

We restrict DSNESPRR to prevent folks from inadvertently locking tables for long periods of time (i.e. run a query in SPUFI, leave the results screen open, and go to a four-hour meeting).

------------------------------------------------------- Bill Gallagher, Logical DBA IT / Infrastructure and Common Services Phoenix Life Insurance Company (W) 860-403-6327 (C) 860-539-5576 bill.gallagher@phoenixwm.com [...] 1078 162 27_Re: Spufi authorization ???11_Gene Renico33_generenico@NORTHWESTERNMUTUAL.COM31_Wed, 29 Nov 2006 13:46:17 -0600424_us-ascii We do the same... CS is open to the PUBLIC but RR is very restricted.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of BILL.GALLAGHER@PHOENIXWM.COM Sent: Wednesday, November 29, 2006 1:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Spufi authorization ???

Dee,

In general, at least at my shop, DSNESPCS is granted to PUBLIC. [...] 1241 160 33_Re: DB2 DBA POSITION AT BANGALORE19_VIDYASAGAR ATTULURI19_vattuluri@GMAIL.COM31_Wed, 29 Nov 2006 14:51:35 -0500632_ISO-8859-1 Hi,

May i know the range of salary that can be expected. My Profile exactly matches with the requirement. I have a total of 10 Years of Experience Under Mainframe of which 6 years as DB2 DBA.



Regards VidyaSagar



On 11/29/06, desiz db2 consultant wrote: > > Dear Listers, > > Below listed are the requirement for DB2 DBA for Z/OS at Banglore for a > finalcial giant. > > > > Ø Must be team-oriented, and should possess excellent oral and written > communication skills, strong interpersonal skills, and the ability to > interact effectively with a demanding [...] 1402 67 51_Re: UDB and the new daylight savings time schedule.18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 29 Nov 2006 14:17:01 -0500350_iso-8859-1 The last I read from IBM was that IY90463 was going to be in v8.2 FP14 and to my knowledge I didn't see FP14 out there yet. But I may have missed it...And the below says its 'still not available'... Very confusing because I keep getting emails from IBM to apply this apar.. Here's the latest I got from the IBM web page on this Apar: [...] 1470 21 42_Re: Visual Explain against a Z/OS database15_Patrick Bossman18_bossman@US.IBM.COM31_Wed, 29 Nov 2006 13:56:39 -0600351_- Hi Rich, The SCHEMA should be there. It's on the TUNE SQL panel above the categorized SQL on the right of QUERYNO and SQLID. It was added in Feb. 2006. I want to add that you can only exploit the SET CURRENT SCHEMA after you go to NFM.

v1.0.9 (2006/02/27):

* Tune SQL: Provide a field to enable SET CURRENT SCHEMA for V8 NF mode. [...] 1492 188 27_Re: Spufi authorization ???9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Wed, 29 Nov 2006 15:28:56 -0600450_us-ascii Thank you for your reply's. It was exactly what I needed to know.

If this is not perspicuous please let me know. Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gene Renico Sent: Wednesday, November 29, 2006 11:46 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Spufi authorization ??? [...] 1681 74 49_Job Offer DB2 DBA / Consultant in Hamburg Germany12_Per Stricker22_per.stricker@ITGAIN.DE31_Wed, 29 Nov 2006 23:05:15 +0100443_iso-8859-1 Hi,

ITGAIN is currently looking for DB2 DBAs/Consultants (LUW as well as z/OS) in Germany (primarily Hamburg). We offer an interesting job, adequate payment and a great team to work with. Everyone how is interested to apply for the job is invited to contact me at per.stricker@itgain.de .

Thanks

Per Stricker itgain GmbH Vahrenwalder Str. 269 a 30179 Hannover Tel.: +49 511 9666 817 Fax.: +49 511 9666 701 [...] 1756 60 25_DSNTEP2 failed with -805.13_Sabeer Meeran20_sabeerm48@IN.IBM.COM31_Thu, 30 Nov 2006 12:28:28 +0530689_US-ASCII Hello,

We are experiencing a problem in the DSNTEP2 program failed with SQL Code -805.. The detail error message is below :

READY DSN SYSTEM(DB2C) DSN RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('SYS1.DSNDB2C.RUNLIB.LOAD') DSN END RESULT OF SQL STATEMENT: DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME EUHADB2A..DSN@EP2L.17B37EBB0AC33DC9 NOT FOUND IN PLAN DSNTEP2. REASON 02 DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -250 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF06' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION [...] 1817 88 34_Result Set processing alternatives11_Mike Jessen22_jessenmike@HOTMAIL.COM31_Thu, 30 Nov 2006 09:37:22 -0600518_iso-8859-1 Environment: DB2 z/OS v8.

We've taken the general approach for our non result set processing stored procedures: For a single source, create separate 3 load mods (1 for cics, 1 for batch, 1 for stored procedures).

If I'm calling a stored procedure (that doesn't return result sets) from CICS - instead of making the cross memory jump to execute the stored procedure in the WLM - don't call the stored procedure and just issue a call to the load module that runs in the same address space. [...] 1906 241 29_Re: DSNTEP2 failed with -805.15_Christopher Tee19_CHRISTEE@UK.IBM.COM31_Thu, 30 Nov 2006 15:53:31 +0000515_US-ASCII Sabeer

DSN@EP2L was rebound at 20:41 GMT last night due to a code refresh. In future, you may want to raise this internally first, through a PR.

Chris Tee DB2 Systems Programmer Database Team SSO IGA Technical Services Internal Tel: 250072 External Tel: 023 9256 0072





Sabeer Meeran Sent by: DB2 Data Base Discussion List 30/11/2006 06:58 Please respond to DB2 Database Discussion list at IDUG [...] 2148 18 6_Rebind14_Rambabu Vanama29_rambabu.x.vanama@JPMCHASE.COM31_Thu, 30 Nov 2006 09:43:17 -0600304_- Is it necessary to do the REBIND after performing the REORG or RUNSTATS? I have always been thinking that we should perform Rebind after the Reorg/Runstats to see the effect of Reorg/Runstats. But I recently heard that it is not necessary to do the Rebind and could have negative impact if we do. [...] 2167 117 34_DB2 V8 Windows Runtime Client Lite13_Ohling, Tim R22_Ohling.Tim@CON-WAY.COM31_Thu, 30 Nov 2006 08:01:55 -0800359_us-ascii We're supporting a purchased application that uses DB2 V8.2 Express on Windows as the server, and is configured with DB2 V8 Runtime Client Lite on Citrix servers for the application runtime.

The version originally installed is V8 FP7.

We're trying to update the Citrix clients to the latest fixpack (FP12 for Runtime Client Lite). [...] 2285 73 33_Re: DB2 DBA POSITION AT BANGALORE4_Fred18_fredgarx@YAHOO.COM31_Thu, 30 Nov 2006 08:26:42 -0800608_iso-8859-1 I think I might be qualified. Is that Bangalore, Maine?

Thanks --- desiz db2 consultant wrote:

> Dear Listers, > > Below listed are the requirement for DB2 DBA for Z/OS at Banglore for a > finalcial giant. > > Ø Must be team-oriented, and should possess excellent oral and written > communication skills, strong interpersonal skills, and the ability to > interact effectively with a demanding user community. > Ø Should have 3 to 5 years work experince as DB2 DBA along with hands on > experinces on programming prior to this. > > Duties would include: > [...] 2359 105 33_Re: DB2 DBA POSITION AT BANGALORE10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Thu, 30 Nov 2006 10:36:04 -0600440_iso-8859-1 Would the ability to spell "financial" be an example of the excellent written communication skills required for this job?

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Fred Sent: Thursday, November 30, 2006 10:27 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 DBA POSITION AT BANGALORE

I think I might be qualified. Is that Bangalore, Maine? [...] 2465 91 42_Re: Visual Explain against a Z/OS database11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 30 Nov 2006 10:48:12 -0600598_- Patrick,

We have done exactly what you describe (a set of plan tables for a developer group) and VE handles this well when you use the "explain with stored procedure option" for an individual statement.

I do have concerns with the usability aspects, however.

When using this scheme, you cannot just explain the statement after it is retrived from a packge. You need to use the sql option, and then add the right qualifier (VE wipes it out and sets the sqlid to equal the package qualifier). This has to happen for each statement. Attempting the normal explain fails but [...] 2557 11 33_Re: DB2 DBA POSITION AT BANGALORE12_Adam Baldwin19_y0027528@ES.IBM.COM31_Thu, 30 Nov 2006 11:11:08 -0600573_- I think that I might be qualified too..... Are the expenses for travelling to the interview covered?

--------------------------------------------------------------------------------- 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 2569 172 38_Re: DB2 V8 Windows Runtime Client Lite15_Byron C. Pierce27_byron.pierce@PRUDENTIAL.COM31_Thu, 30 Nov 2006 12:23:52 -0500375_US-ASCII It's probably still in your system registry.

Do 'regedit' and check in:

HKEY_LOCAL_MACHINE ==> SOFTWARE ==> IBM ==> DB2 ==> DB2 Runtime Client

If you can remove ALL that needs to be removed in there, you should be OK... but caution,,,, you're messing with the registry so you might want to get a sysadm to confirm what needs to be removed. [...] 2742 333 38_Re: DB2 V8 Windows Runtime Client Lite14_Chad A. Walmer19_Cwalmer@RITEAID.COM31_Thu, 30 Nov 2006 13:11:45 -0500474_US-ASCII

Tim,

I recently found a Technote on uninstalling UDB for Windows due to a problem we were having with the uninstall of V8.1 Fixpak 11:





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





It contains detailed instructions on how to manually remove the product. I know it doesn't answer your original question but should get you around the problem.





HTH,

Chad Walmer [...] 3076 309 33_Re: DB2 DBA POSITION AT BANGALORE13_Horacio Villa17_hvilla@AR.IBM.COM31_Thu, 30 Nov 2006 17:00:15 -0300566_ISO-8859-1 If that's not "politeness", where has it gone?

Horacio





"Irwin, Jim" Sent by: DB2 Data Base Discussion List 30/11/2006 13:36 Please respond to DB2 Database Discussion list at IDUG



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

Subject Re: [DB2-L] DB2 DBA POSITION AT BANGALORE











Would the ability to spell "financial" be an example of the excellent written communication skills required for this job? [...] 3386 104 49_Re: Invoking legacy cobol - db2 program from JAVA19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Thu, 30 Nov 2006 18:03:08 -0600466_us-ascii Perhaps you can run the cobol program as a stored procedure (you've already linked it with DSNRLI).

Then instead of invoking the COBOL program directly, you can just "CALL" the stored procedure (with the unchanged cobol code) and have the cobol program run in some DB2WLM stored procedure address space.

Richard Humphris Business: 312-822-5193 Text Pager: 877-814-2246 To send short email to pager... send email to: 8778142246@skytel.com [...] 3491 242 38_Re: DB2 V8 Windows Runtime Client Lite14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Fri, 1 Dec 2006 11:30:52 +1100477_US-ASCII Try "db2licm -l" - this should tell you what DB2 thinks is licensed.

Now try HKEY_LOCAL_MACHINE ==> SOFTWARE ==> IBM ==> DB2

There should be "product name" ==> CurrentVersion ==> Modification entries that tells you the PTF level for installed products.

Some licensed "things" are not separate products (eg HADR), and some products don't have specific licenses (eg Infomation Center), but between the two you should see the "unknown" product" [...] 3734 42 10_Re: Rebind14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Fri, 1 Dec 2006 11:30:53 +1100377_US-ASCII Necessary - in that will you get incorrect results if you do not rebind - no. (Bugs excepted.)

Necessary - in that will you get improved performance - depends. There are some situations where people have carefully crafted binds to get optimal response and a rebind would undo the care; however it is also possible to get better performance after a rebind. [...] 3777 61 10_Re: Rebind19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Thu, 30 Nov 2006 19:56:32 -0500530_us-ascii REBIND (o Sometimes working backwards is easier to understand.

REBIND (only) when you want access paths to change. Otherwise, why bother? Before you REBIND, make sure statistics are current: do RUNSTATS. Before you do RUNSTATS, make sure you will get "good" statistics: REORG.

Put another way, for a heavy-loaded transaction environment with mostly static SQL: - REORG frequently. - Do RUNSTATS only after reorgs (or inline with the REORG). - REBIND rarely (only when you want different access paths). [...] 3839 18 45_How many test subsystem is good for a company10_Mark Kassa20_ayalakassa@YAHOO.COM31_Thu, 30 Nov 2006 19:10:07 -0600390_- The company I work for has three test subsystems (unit, system and quality). Most of the application developers test their programs in the unit and quality subsystems and then prompt their program to the production subsystem. The system subsystem is rarley used. I am just wondering how many test subsystems each of you have. Is the company I work for has too many test subsystems ? [...] 3858 211 27_Re: Spufi authorization ???12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Thu, 30 Nov 2006 22:54:41 -0600523_us-ascii When ever I install DB2 I FREE DSNESPRR and wait for the phone calls for people asking why they can't get SPUFI to work since RR is the default. Usually new employees who have never logged in and executed SPUFI. I also always grant EXECUTE on DSNESPCS to PUBLIC.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dee Reins Sent: Wednesday, November 29, 2006 3:29 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Spufi authorization ??? [...] 4070 54 49_Re: How many test subsystem is good for a company14_Galeos Antonis19_AGaleos@EUROBANK.GR30_Fri, 1 Dec 2006 07:55:04 +0200434_us-ascii In our shop we have 1 unit test subsystem and 4 user's acceptance subsystems. Always we asked for more test subsystems in order different applications do their tests

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mark Kassa Sent: Friday, December 01, 2006 3:10 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] How many test subsystem is good for a company [...]