1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2006, week 5 2 98 26_Stogroup question - DB2 v813_Hodgin, Scott19_shodgin@SCFBINS.COM31_Fri, 29 Dec 2006 01:28:56 -0500564_- This past weekend, I alter a bunch of indexes to use a different stogroup with a bunch of packs assigned to it, but I did not reorg the indexes.

I've recently had some jobs blowing up due to inability to extend datasets for various indexes.

I'm puzzled. So I have to reorg/rebuild the indexes to get db2 to tabke advantage of the new stogroup. The original stogroup that the index was assigned to was a single pack which is now full. I would have thought the extend request would have just looked on another pack assigned to the new stogroup. [...] 101 21 28_-904 on Open cursor with DDF15_Daniel Cremieux17_c300501@YAHOO.COM31_Fri, 29 Dec 2006 05:00:00 -0600294_- Dear all , A programmer reported me this problem , and after all checks , i cannot find the solution

-904 on an OPEN CURSOR , the SQL is a select with 2 tables from a Remote DB2 - the program display doesn't give other details

I ran manually the sql with QMF successfully, [...] 123 31 32_Re: -904 on Open cursor with DDF13_Ganesh Gosavi23_ganesh_gosavi@YAHOO.COM31_Fri, 29 Dec 2006 03:22:07 -0800580_ascii Make sure that you are closing the cursor once the task is finished which is done after opening the cursor. It would be good, if you provide more details. GANESH (IBM India) ----- Original Message ---- From: Daniel Cremieux To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, 29 December, 2006 4:30:00 PM Subject: [DB2-L] -904 on Open cursor with DDF Dear all , A programmer reported me this problem , and after all checks , i cannot find the solution -904 on an OPEN CURSOR , the SQL is a select with 2 tables from a Remote DB2 - the program display doesn't [...] 155 58 32_Re: -904 on Open cursor with DDF14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Fri, 29 Dec 2006 06:26:56 -0500298_us-ascii Hi Dan,

The query runs through qmf fine and through program gives you -904 during the cursor open. I had faced this scenario in the past and you need to look at the locks per thread exceeding the value. That is the program has taken more locks than specified value in NUMLKUS. [...] 214 50 32_Re: -904 on Open cursor with DDF13_Ganesh Gosavi23_ganesh_gosavi@YAHOO.COM31_Fri, 29 Dec 2006 03:36:40 -0800622_ascii You can use db2pd utility to determine which resource is locked a Dan, You can use db2pd utility to determine which resource is locked and which other transaction (pid) is waiting for the locks to release. You may also want to verify the isolation level set. Thanks and Regards, GANESH (IBM, India) ----- Original Message ---- From: "Dash, Sushanta" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, 29 December, 2006 4:56:56 PM Subject: Re: [DB2-L] -904 on Open cursor with DDF Hi Dan, The query runs through qmf fine and through program gives you -904 during the cursor open. I had faced this [...] 265 194 32_Re: -904 on Open cursor with DDF20_desiz db2 consultant20_desig@CONSULTANT.COM31_Fri, 29 Dec 2006 07:18:38 -0500403_ascii Are you working for IBM India. if you are interested for change please do reply with your resume for MNC and finacial giant. Desig.

----- Original Message ----- From: "Ganesh Gosavi" To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] -904 on Open cursor with DDF Date: Fri, 29 Dec 2006 03:36:40 -0800



You can use db2pd utility to determine which resource is locked a Dan, [...] 460 349 87_AW: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 29 Dec 2006 13:23:01 +0100757_iso-8859-1 >>>> You can use db2pd utility to determine which resource is locked <<<<

This utility is only for the UNIX & LINUX DB2's - isn't it ?

With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r Vice Chair GSE Workinggroups DB2 Nord und Sued ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- »"Next time you think you're perfect - try walk on water!"« [...] 810 40 31_DB2 Compare Tool error GOCC024E17_Mariusz Stakowski20_stakowskim@PROKOM.PL31_Fri, 29 Dec 2006 07:47:42 -0600472_- Hello list,

We have DB2 v7.

I have been working with DB2 Compare Tools for about two years and had no problems. But recently I'm getting GOCC024E error. In the simpliest case I compare two tables which are supposed to have identical structure. Both structures are in DB2 catalog. The comparison fails on index: Compare index source(ZUSSOS07.CXS2NOZ) and target (ZUSSOS0B.CXS2NOZ) GOCC024E - Unexpected catalog row on source file. Expected:IP found:TS [...] 851 54 32_Re: -904 on Open cursor with DDF14_Simpson, David22_DSIMPSO@TRANSUNION.COM31_Fri, 29 Dec 2006 09:20:05 -0600281_US-ASCII If your package is bound with DBPROTOCOL(DRDA), the default, then you need to bind the package on the remote system also. You can tell if this is the case by looking at the name of the unavailable resource... if it is the package name then this is probably the case. [...] 906 224 91_Re: AW: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam13_Ganesh Gosavi23_ganesh_gosavi@YAHOO.COM31_Fri, 29 Dec 2006 07:21:12 -0800595_iso-8859-1 Yes...this utility works on LUW(Linux, UNIX and WINDOWs) platform. GANESH (IBM, India Labs) ----- Original Message ---- From: "Peter, Georg" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, 29 December, 2006 5:53:01 PM Subject: [DB2-L] AW: [[SPAM]] - Re: [DB2-L] -904 on Open cursor with DDF - Bayesian Filter detected spam >>>> You can use db2pd utility to determine which resource is locked <<<< This utility is only for the UNIX & LINUX DB2's - isn't it ? With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r Vice Chair GSE Workinggroups DB2 Nord [...] 1131 85 49_Global change in a TSO SPUFI lib rary pos sible ?23_Mokshagundam, Venkatesh22_vmokshagun@CSSTARS.COM31_Fri, 29 Dec 2006 10:17:59 -0600617_US-ASCII If your SPUFI input library is a PDS, you can use the following JCL:

//* ADD YOUR JOB CARD //* //*------------------------------------------------------------------* //* PDS84: PDS UTILITY - MODIFY ALL / SELECTED MEMBERS //*------------------------------------------------------------------* //STEP01 EXEC PGM=IKJEFT1B,DYNAMNBR=30 //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * PDS 'GEORG.SPUFIDDL.CNTL' MEMLIST : REPLACE * /XYZ/ABC/ WRITE

If you omit the WRITE keyword, you'll get a report of everything that will be replaced, which you can verify to make sure it is doing what it is supposed to. [...] 1217 47 30_Re: Stogroup question - DB2 v813_Chuck Massaro20_chuck.massaro@CA.COM31_Fri, 29 Dec 2006 11:33:58 -0600648_- Scott,

Altering the stogroup is considered altering a storage attribute. As a general rule, changing a storage attribute requires the data to be moved, either manually or via one of three utilities (see below). One exception would be SECQTY.

From the DB2 for z/OS v8 SQL Reference manual, pg 462 states:



Altering storage attributes: The USING, PRIQTY, SECQTY, and ERASE clauses define the storage attributes of the index or partition. If you specify the USING or ERASE clause when altering storage attributes, the index or partition must be in the stopped state when the ALTER INDEX statement is executed. [...] 1265 68 50_DB2v8 zos Visual Explain and missing milliseconds.23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 29 Dec 2006 11:34:56 -0800701_us-ascii Hi all, when I use VEv8 'Retrieve Statements' from the 'List Static SQL Statements' window the statement list shows all of the milliseconds and service units as 0.

What I'm I missing.

thanks,

cliff:-)

--------------------------------------------------------------------------------- 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 1334 94 57_de-normalized table VS view of multiple normalizes tables23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 29 Dec 2006 13:46:51 -0800343_us-ascii Hi all,

I had a developer complain about needing to use multiple joins of normalized tables just to find the row he wants in just one table. He prefers de-normalized tables which make his queries easier.

I thought leave the tables normalized (to keep Cobb's spirit from haunting me) and create a view for the user. [...] 1429 186 61_Re: de-normalized table VS view of multiple normalizes tables12_McKown, John29_John.Mckown@HEALTHMARKETS.COM31_Fri, 29 Dec 2006 16:02:46 -0600497_US-ASCII Personal opinion time from someone who is not really a DBA (me).

To the extent possible, I like tables that I design (at home, for my own amusement) to be as normalized as possible. In your case, my only real question would be: "Will de-normalizing the table result in significant performance improvement?" And I don't mean 1 or 2 percent. I mean at least 5 percent. If not, then I'd go with the VIEW. That will stop the whining from the developer while retaining a "purer" set up. 1616 57 57_de-normalized table VS view of multiple normalizes tables12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Fri, 29 Dec 2006 16:22:12 -0600598_- Cliff, when others outside the database realm start trying to design tables for you, it is a bad sign..Like Craig Mullins, I'm not a fan of views, but better solution than going de-normalized when not absolutely necessary (and most times it is not necessary). Had a consulting firm when I was a lead DBA at a company, try and design our tables for us based on windows, drop down lists, radio buttons they needed to populate...so they wanted database design by drop down list, radio buttons instead of logical design for performance, scalabilty, data integrity, etc..Of course they were join [...] 1674 72 61_Re: de-normalized table VS view of multiple normalizes tables9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 29 Dec 2006 16:53:35 -0600603_us-ascii A long standing issue - because everyone has an SQL statement that would run faster if the tables looked like 'just so'. The full answer is dependent on lots of things - such as

1. Is it a transactional system or a data warehouse? Transactional systems almost always do better with normalized tables - data warehouse you don't need the normalized table to validate the data since that (should/might/would) have occurred in the transaction system. 2. What would the maintenance be required for a denormalized table - Who would write it? How do you validate it is correct? Nothing to [...] 1747 173 61_Re: de-normalized table VS view of multiple normalizes tables9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Fri, 29 Dec 2006 17:13:52 -0600320_US-ASCII We have used Views extensively for Web Focus applications in DB2 and Oracle. It simplifies the Web focus, and there are fewer places to change code. Views are Especially handy if end users are creating their own reports. Views make the database look like an excel spread sheet, which end users understand. [...] 1921 115 63_Re: Sendmail problem with db2 UDB v8.1 FP 12 and dasuser userid14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 30 Dec 2006 14:58:43 +1100804_US-ASCII Can you sendmail from any userid on this system? Is it possible that you haven't configured one of the /etc files to identify the hostname of your system?

eg http://www.google.com.au/search?q=sendmail+553+5.5.4&btnG=Search&hl=en http://forums.macosxhints.com/archive/index.php/t-3790.html

James Campbell

On 28 Dec 2006 at 20:42, Harold Pritchett wrote:

> I am getting this error from sendmail. It appears that the administrative > user is trying to send an error message, and sendmail is failing to send > it because the user name is not fully qualified. > > Dec 28 20:35:01 www sendmail[24715]: kBT1Z1Au024715: ruleset=check_mail, > arg1=, relay=www.benyshek-hough.com [10.0.2.40], reject=553 > 5.5.4 [...] 2037 261 30_Re: Stogroup question - DB2 v810_IBMsysProg25_IBMsysProg@GEEK-SITES.COM31_Fri, 29 Dec 2006 23:57:01 -0500557_iso-8859-1 Stogroup question - DB2 v8Recovering the index would also work.

This is a small snip from the SQL reference indicating when changes take place

Altering storage attributes: The USING, PRIQTY, SECQTY, and ERASE clauses define the storage attributes of the index or partition. If you specify the USING or ERASE clause when altering storage attributes, the index or partition must be in the stopped state when the ALTER INDEX statement is executed. A STOP DATABASE...SPACENAM... command can be used to stop the index or partition. [...] 2299 136 16_backup hangs db216_Harold Pritchett14_harold@UGA.EDU31_Sat, 30 Dec 2006 10:00:44 -0500349_ISO-8859-1 I am running db2 UDB v8.1 FP 12 on RedHat Enterprise Linux 3.

Everything has been running fine for months. The server hadn't been re-booted since early October. This morning, the server was hung, with db2 in a strange state. I was unable to stop the server, getting an SQL1072C Cannot restart deb2 "Inconsistant state" error. [...] 2436 42 54_Re: DB2v8 zos Visual Explain and missing milliseconds.12_Myron Miller22_myronwmiller@YAHOO.COM31_Sat, 30 Dec 2006 14:38:48 -0800426_iso-8859-1 I would strongly suspect that the package/plan has not been bound with explain for the sql userid that you're using. That's the only way that I've ever seen this happen. The plan/package has to have been bound explain (yes) with the specific userid that your using on the VE window. You either need to change the userid to the one that the package was bound with or rebind it with explain yes and your userid. [...] 2479 277 9_db2 abend16_Harold Pritchett14_harold@UGA.EDU31_Sun, 31 Dec 2006 15:55:13 -0500115_ISO-8859-1 Anyone have an idea why my db2 just died???

Attached is extract from the event file

Harold 2757 380 61_Re: de-normalized table VS view of multiple normalizes tables12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Sun, 31 Dec 2006 16:35:53 -0600562_us-ascii Hi Cliff,

In most cases your normalized design is going to be the best design for long term flexibility supporting design changes to your system. For performance reasons you may find it necessary to de-normalize. For example, you may decide to put an indicator on a table that tells your application program that you have some child rows on another table. I've seen this when 80% of the time you have no data so why go look for it 100% of the time. Another example is putting 12 monthly total columns on a row instead of having 12 rows with [...] 3138 479 23_Re: z/OS download fixes12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Sun, 31 Dec 2006 17:08:08 -0600685_us-ascii Hi Cathy,

Thanks for posting this. I was just looking for this myself.





Happy New Year!!!





Troy Coleman





_____

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Taddei, Cathy Sent: Friday, December 22, 2006 11:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] z/OS download fixes





Thanks, Max, and thanks to everyone else who sent links. I followed them all, and though I found various ways of obtaining PTF's, none were the page I was looking for. But I did submit a feedback to IBM, and Bill Stern came through for me with this link: [...]