1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2009, week 1 2 254 40_Re: DB2 connect problem on DB2 z/OS V8CM10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 30 Jun 2009 18:50:18 -0700613_iso-8859-1 Martin, We just upgraded to V8 CM in March and had same kind of errors. The problem was, also, that a lot of the clients were actually various fixpacks of V7. We found that upgrading our servers to V8 Fix pack 14 resolved those issues. Though we are holding off on NFM til we get all clients and connect servers up to 9.5. David Nance ________________________________ From: Myron Miller To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Tuesday, June 30, 2009 4:52:42 PM Subject: Re: [DB2-L] DB2 connect problem on DB2 z/OS V8CM Unless you're at least fp10 on DB2 Connect 8.1, these type [...] 257 43 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM30_Wed, 1 Jul 2009 06:02:41 +0000430_windows-1252 Hi Chris,

Thanks for the response. When I am trying to bind package DSNUGSQL to windows DB2, I am getting below error;

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABL 4, AND RESOURCE NAME DESAHASR.DESAHAS.DSNBIND DSNT233I -DM11 UNSUCCESSFUL BIND FOR PACKAGE = DESAHASR.DSNUTIL.DSNUGSQL.() and I am sorry. I mistakenly entered DB2 V8. Actually I am working on DB2 V9. [...] 301 66 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF9_Chris Tee23_Chris.Tee@SENTENIAL.COM30_Wed, 1 Jul 2009 09:10:29 +0100480_us-ascii Devyani

The message looks a bit strange, is it the complete error message? Are there any related messages in the MSTR log? Perhaps you could paste in your bind JCL as well.

Chris

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Devyani R Sahasrabudhe Sent: 01 July 2009 07:16 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF [...] 368 73 36_Re: SQL0968C The File System is Full14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 Jul 2009 21:39:14 +1000438_US-ASCII In different contexts I sometimes get 'filesystem full' messages because I (or the id I'm using) lacks the authority to update the directory I'm writing into.

For other places to ask DB2 LUW questions http://groups.google.com.au/group/comp.databases.ibm-db2/topics (monitored by some folks who write the LUW code)

http://www.ibm.com/developerworks/data/community/#dms lists a few DB2 LUW fora supported by IBM [...] 442 121 40_[DB2 9 CM] problems after using DSN1COPY35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Wed, 1 Jul 2009 13:44:02 +0200394_iso-8859-1 Hi all

I just restored a table in our test-system using an image-copy-dataset from production. I did all the OBID-translation stuff and did a repair levelid. Select * just works fine, but Select count(*) doesn't. So I rebuild the primary index on that table. Rebuild told me, that about 100,000 index-entries were loaded, but select count(*) remains the same, just zero. [...] 564 50 48_Re: [DB2 v9 z/OS] OPTIONS PREVIEW and INDEX COPY9_Sam Orner21_sorner@AESSUCCESS.ORG30_Wed, 1 Jul 2009 07:45:35 -0400569_us-ascii Phil,

I ran an OPTIONS PREVIEW test. We are on V8 NFM.

Here is my syntax in a LISTDEF:

INCLUDE INDEXSPACE D@@@@@@@.I@@@@*

Here is what shows in the output SYSPRINT

DSNU1021I + DSNUILSA-PROCESSING INCLUDE CLAUSE INDEXSPACE D@@@@@@.I@@@@* DSNU1001I + DSNUILSA-LISTDEF OBJLIST CLAUSE IDENTIFIES NO NEW OBJECTS:INCLUDE INDEXSPACE DAACQLCS.ILN36%



In this case, I know that none of the indexes in the database are defined as COPY YES, so knowing that, the message does indicate that no index will be backed up. [...] 615 79 48_Re: [DB2 v9 z/OS] OPTIONS PREVIEW and INDEX COPY13_Bell, Raymond20_Raymond_Bell@BMC.COM30_Wed, 1 Jul 2009 13:57:09 +0200385_us-ascii Guys, guys, guys... Not being able to copy an index just because it's inconweeniently defined as Copy No is soooo last century...

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sam Orner Sent: 01 July 2009 12:46 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [DB2 v9 z/OS] OPTIONS PREVIEW and INDEX COPY [...] 695 83 35_Re: DB2 Connect V8 Error CLI Driver28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Wed, 1 Jul 2009 17:54:37 +0530658_UTF-8 Hi Kevin,

Have you specified the CLASSPATH to include the license file - db2jcc_license_cisuz.jar ?

Regards, Bala.









Kevin Sent by: DB2 Data Base Discussion List 01/07/2009 03:59 Please respond to DB2 Database Discussion list at IDUG



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

Subject [DB2-L] DB2 Connect V8 Error CLI Driver











Has anyone seen this error '[IBM][CLI Driver] SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=42968' [...] 779 22 44_Re: [DB2 9 CM] problems after using DSN1COPY35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_walter.janissen@ITERGO.COM30_Wed, 1 Jul 2009 12:29:36 +0000497_windows-1252 Sorry guys, I have rebuilt the wrong index. Acces Path picked up a different one.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG Europe Attendee Testimonial- "Conference was superb! Couldn’t fault anything. Very impressed." _____________________________________________________________________ 802 123 43_Fw: [DB2-L] DB2 Connect V8 Error CLI Driver28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Wed, 1 Jul 2009 18:40:26 +0530466_UTF-8 Hi Kevin,

Sorry, I read that mistakenly to be JDBC. Did you copy in the license file db2consv_zs.lic from db2/license directory ?





----- Forwarded by Balachandran Chandrasekaran1/India/IBM on 01/07/2009 18:41 -----

Balachandran Chandrasekaran1/India/IBM@IBMIN Sent by: DB2 Data Base Discussion List 01/07/2009 17:54 Please respond to DB2 Database Discussion list at IDUG [...] 926 445 36_Re: SQL0968C The File System is Full15_Russell Collins28_Russell.Collins@MCLANEAT.COM30_Wed, 1 Jul 2009 09:18:40 -0500421_us-ascii Tim,

Thank you for your help. When you say file system, are you basically saying that the machine specs need to be the same? Example if Machine A has a 250 gig hard drive, then Machine B needs to have a 250 gig hard drive as well. If this is the case, then the two machine would have different specs. However, the backup file is not that big. It is about 100meg and fits comfortably on both systems. [...] 1372 45 44_Implications of Revoking DBADM (DB2 z/OS v8)13_Graham O'Hara32_graham.ohara@NORWICH-UNION.CO.UK30_Wed, 1 Jul 2009 14:29:53 +0000473_windows-1252 I am having a tidy-up of our database level authorizations and privileges. Most of these are not a problem, but revoking DBADM can have some unexpected consequences.

The ones I can think of are listed below - can you think of any others that I might have missed?

1. If DBADM was used to grant table/view privileges to other users, these may be cascade revoked. Further implications of the table/view privileges being revoked may then apply. [...] 1418 245 30_DB2 Connect v7.1 compatibility17_Kaminski, Michael39_Michael.Kaminski@TRUSTMARKINSURANCE.COM30_Wed, 1 Jul 2009 09:33:22 -0500447_us-ascii

Does anyone have any knowledge of DB2 Connect v7.1 having any compatibility issues with zOS Db2 v8?

I was able to successfully run queries directly from Db2 Connect and via an Db2 ODBC connection (in CM mode)

Thanks in advance,



Michael A. Kaminski Systems/DBA Trustmark Insurance 847-283-4050 michael.kaminski@trustmarkins.com

P Please consider the environment before printing this e-mail [...] 1664 325 47_Re: Fw: [DB2-L] DB2 Connect V8 Error CLI Driver15_Anderson, Kevin27_Kevin.Anderson@MARRIOTT.COM30_Wed, 1 Jul 2009 10:50:06 -0400532_us-ascii Hi,

No I did not. Where should that be copied?

Thanks



________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Balachandran Chandrasekaran1 Sent: Wednesday, July 01, 2009 9:10 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Fw: [DB2-L] DB2 Connect V8 Error CLI Driver





Hi Kevin,

Sorry, I read that mistakenly to be JDBC. Did you copy in the license file db2consv_zs.lic from db2/license directory ? [...] 1990 47 48_Re: Implications of Revoking DBADM (DB2 z/OS v8)17_Dell'Anno, Aurora22_Aurora.Dellanno@CA.COM30_Wed, 1 Jul 2009 17:22:35 +0100584_UTF-8 Graham,

Recently at SQLAdria, Mirna Kos of Zagrebska (sorry Mirna I can never remember the proper name :-) gave a very interesting presentation on how they changed their environment for auditor's compliance, including revoking DBADM...

You can find the presentation at http://www.ctk-rijeka.hr/SQLAdria/6-2005/agenda.htm - just click on the download abstracts link!

Thanks.







Aurora Emanuela Dell'Anno CA Sr Engineering Services Architect Tel: Â Â Â Â +44 (0)1753 577 733 Mobile: +44 (0)7768 235 339 Aurora.Dellanno@ca.com [...] 2038 184 47_Re: Fw: [DB2-L] DB2 Connect V8 Error CLI Driver28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Wed, 1 Jul 2009 22:49:37 +0530684_UTF-8 Hi,

I found this page for you from IBM Infocenter. Hope this helps.

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

Regards, Bala.









"Anderson, Kevin" Sent by: DB2 Data Base Discussion List 01/07/2009 20:20 Please respond to DB2 Database Discussion list at IDUG



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

Subject Re: [DB2-L] Fw: [DB2-L] DB2 Connect V8 Error CLI Driver











Hi,

No I did not. Where should that be copied? [...] 2223 361 36_Re: SQL0968C The File System is Full12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 1 Jul 2009 10:32:38 -0700373_iso-8859-1 no, I mean something like /home/instanceid if a unix system.... or D:\databasefolder if it's windoze.

if you issue the "get dbm cfg" and look for something like DFTDBPATH, it will tell db2 will tell you the default path.

When you create a database,

CREATE DATABASE TESTDBASE

without specifying where, it goes into the DFTDBPATH. [...] 2585 208 34_Re: DB2 Connect v7.1 compatibility28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM30_Wed, 1 Jul 2009 23:15:50 +0530519_US-ASCII It would be best to raise the question with IBM and see how far (tolerable or fully compatible) compatibility goes. We had a situation where we "made" a choice (on a vendor product and DB2 v8 though) and got stuck in the middle.













"Kaminski, Michael" Sent by: DB2 Data Base Discussion List 01/07/2009 20:03 Please respond to DB2 Database Discussion list at IDUG [...] 2794 737 36_Re: SQL0968C The File System is Full15_Russell Collins28_Russell.Collins@MCLANEAT.COM30_Wed, 1 Jul 2009 13:57:39 -0500454_us-ascii Ok. I understand this concept. Thank you. Here is what I have

OS: Windows or should I say Windoze. Machine A: When running the command DFTDBPATH is the C:\. However the database is located on the "D:\". The "D:\" has 250 gigs on it. The database is not using all of this drive. It is using 224megs of information. Machine B: When running the command DFTDBPATH is the C:\. The database is located on "C:\". The C:\ has 25 gigs on it. [...] 3532 466 34_Re: DB2 Connect v7.1 compatibility14_Stevens, Wayne29_Wayne.Stevens@DHR.ALABAMA.GOV30_Wed, 1 Jul 2009 14:11:36 -0500545_US-ASCII It works, but it has to be at a certain FixPack Level. I don't remember what that level is.





Wayne Stevens

Wayne.Stevens@dhr.alabama.gov





From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kaminski, Michael Sent: Wednesday, July 01, 2009 9:33 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 Connect v7.1 compatibility









Does anyone have any knowledge of DB2 Connect v7.1 having any compatibility issues with zOS Db2 v8? [...] 3999 182 34_Re: DB2 Connect v7.1 compatibility20_George H Lewandowski29_george.lewandowski@ABBOTT.COM30_Wed, 1 Jul 2009 14:20:06 -0500731_UTF-8 The fixpack level is 4 and we had it working with DB2 V8 but we are retiring that server and no longer using it..





George H Lewandowski Database Administrator GIS 7x24 Operations GA-25, J46-2E

Work (847) 938-5526 Pager (800) 209-1305 george.lewandowski@abbott.com







This communication may contain information that is proprietary, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his [...] 4182 135 13_The year 202523_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Wed, 1 Jul 2009 14:15:06 -0500379_ISO-8859-1 Just wanted to share an oddity. I am on Gnu/Linux running running DB2 9.1 Fixpack 6. I just did a restore today from today's backup, and the restore and rollforward both demanded stoptime which timestamp used the year 2025, even though my operating system date seems correct. The restore seems to have gone fine but DB2 logging appears confused about timestamps. [...] 4318 523 34_Re: DB2 Connect v7.1 compatibility17_Kaminski, Michael39_Michael.Kaminski@TRUSTMARKINSURANCE.COM30_Wed, 1 Jul 2009 14:25:03 -0500507_us-ascii Thanks, I've heard that it may not work at maintenance level 0509. I've sent an ETR to IBM to inquire.





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Stevens, Wayne Sent: Wednesday, July 01, 2009 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect v7.1 compatibility





It works, but it has to be at a certain FixPack Level. I don't remember what that level is. [...] 4842 151 17_Re: The year 202523_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Wed, 1 Jul 2009 14:37:33 -0500353_ISO-8859-1 Sorry I dropped this on the list too quickly. The clock on the server got set, by perpetrators yet to be determined, to a bad value for about a two minute period, resulting in the bizarre rollforward stoptime. DSE - Defective Systems Engineer

On Wed, Jul 1, 2009 at 14:15, Jeffrey Benner, DB2 DBA < consulting@ebenner.com> wrote: [...] 4994 452 17_Re: The year 202514_Fazio, Richard21_RFAZIO@TRANSUNION.COM30_Wed, 1 Jul 2009 14:52:06 -0500495_us-ascii Be glad your job scheduler is not on this server. That happened to a former employer and several thousand jobs came into the queue....the schedule was 7 years behind and had to catch up!





faz





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeffrey Benner, DB2 DBA Sent: Wednesday, July 01, 2009 2:38 PM To: DB2-L@www.idugdb2-l.org Subject: Re: [DB2-L] The year 2025 [...] 5447 177 17_Re: The year 202512_Jeff Frazier31_Jeffrey.Frazier@WENDYSARBYS.COM30_Wed, 1 Jul 2009 15:57:39 -0400622_UTF-8 Wasn't there a song 'in the year 2025' or was that 2525. :) Jeff





"Fazio, Richard" Sent by: DB2 Data Base Discussion List 07/01/2009 03:52 PM Please respond to DB2 Database Discussion list at IDUG



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

Subject Re: [DB2-L] The year 2025











Be glad your job scheduler is not on this server. That happened to a former employer and several thousand jobs came into the queue….the schedule was 7 years behind and had to catch up! [...] 5625 77 0_13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Wed, 1 Jul 2009 13:19:42 -0700599_ISO-8859-1 You need to figure out which file system is filling up. You can look in the db2diag.log (or use the db2diag command) to look for messages at the time you executed the restore database command.

Once you determine that, you can take any corrective action(s) necessary to free up space.







On Tue, Jun 30, 2009 at 1:57 PM, Russell Collins wrote: > I am having some issue with the restore command on DB2 Express so I may be > on the wrong list. I have done a search for this issue but there has not > been a solution that [...] 5703 614 30_[OT] RE: [DB2-L] The year 202514_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Wed, 1 Jul 2009 16:23:42 -0400427_us-ascii Yup, 2525 was the year. Zager and Evans - "In the Year 2525"





________________________________

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeff Frazier Sent: Wednesday, July 01, 2009 3:58 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] The year 2025







Wasn't there a song 'in the year 2025' or was that 2525. :) Jeff [...] 6318 324 17_Re: The year 202523_Jeffrey Benner, DB2 DBA22_consulting@EBENNER.COM30_Wed, 1 Jul 2009 15:34:22 -0500588_windows-1252 Zager and Evans: ""In the year 2525, If man is still alive, If woman can survive . . . "

On Wed, Jul 1, 2009 at 14:57, Jeff Frazier wrote:

> > Wasn't there a song 'in the year 2025' or was that 2525. :) > Jeff > > > *"Fazio, Richard" * > Sent by: DB2 Data Base Discussion List > > 07/01/2009 03:52 PM > Please respond to > DB2 Database Discussion list at IDUG > > To > DB2-L@WWW.IDUGDB2-L.ORG cc > Subject > Re: [DB2-L] The year 2025 > > > > > Be glad [...] 6643 29 17_Re: The year 202516_mocion@libero.it16_mocion@LIBERO.IT30_Wed, 1 Jul 2009 23:05:35 +0200460_windows-1252 Ehy John Titor's fans, is it friday ?

Max Scarpa

IDUG European 2008 Attendee Testimonial

"The technical content of the conference was excellent and useful. But in Rome it'll be even better, Max Scarpa will held 'Baldness camouflage performance and tuning' seminar :-) 8-)

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 6673 456 34_Re: [OT] RE: [DB2-L] The year 20257_Ed Long19_rdhm99a@PRODIGY.NET30_Wed, 1 Jul 2009 19:55:35 -0700513_utf-8 Not the most hopeful song I ever heard. Apocalyptic mumbo jumbo that swell Mel Gibson might admire.

Edward Long

--- On Wed, 7/1/09, Sevetson, Phil wrote:



From: Sevetson, Phil Subject: [DB2-L] [OT] RE: [DB2-L] The year 2025 To: DB2-L@WWW.IDUGDB2-L.ORG Date: Wednesday, July 1, 2009, 4:23 PM















Yup, 2525 was the year. Zager and Evans – “In the Year 2525† [...] 7130 26 35_Franco Vitale is out of the office.13_Franco Vitale19_VITALEFR@UK.IBM.COM30_Thu, 2 Jul 2009 08:01:21 +0100379_US-ASCII I will be out of the office starting 02/07/2009 and will not return until 03/07/2009.

For urgent matters, please email the taskid UK SD-TE DB2 Support/UK/IBM. For problems/changes please use our Manage Now group EGBNR_MFDSIGADB. My mail will not be monitored in my absence. If you need any assistance while I am out of the office please contact Pete Lickiss [...] 7157 24 48_Re: Implications of Revoking DBADM (DB2 z/OS v8)13_Graham O'Hara32_graham.ohara@NORWICH-UNION.CO.UK30_Thu, 2 Jul 2009 08:31:56 +0000645_windows-1252 Thanks for the link Aurora - looks like some interesting presentations there. However, the abstract docs only seem to give a very brief description of each one.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 7182 81 61_Re: [zOS DB2 V9 NFM] Size and config of a MainFrame DBA team?7_M McCoy35_Maria.mccoy@LANDREGISTRY.GSI.GOV.UK30_Thu, 2 Jul 2009 12:55:32 +0000435_windows-1252 Thank you all for you responses, much appreciated. This has given me some history, insight and references that will support the current size and configuration on the DB2 DBA team.

Replies:

Roger – yes, do not be too shocked…. A 37 hour week! That is what you get for working for the british government, they have this outmoded concept of caring for staff and making sure they do not work too hard… (?!) [...] 7264 52 28_Re: [zOS DB2] Sort Hexa data3_duc17_ndt.db2@GMAIL.COM30_Thu, 2 Jul 2009 17:33:29 +0200745_ISO-8859-1 Dear all,

Do you know how to sort these LSRN (with DFSORT) , to have them in the right sequence . I have some samples but they deal only with Characters ...

C46C9ED20FE5 C46C9ED20EA9 C46C9ED211E8 C46C9ED211E8 C46C9ED210B5



Thank you .

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________ 7317 478 34_Re: DB2 Connect v7.1 compatibility17_Kaminski, Michael39_Michael.Kaminski@TRUSTMARKINSURANCE.COM30_Thu, 2 Jul 2009 10:41:13 -0500529_us-ascii for anyone interested, here's IBM response to the question about compatibility.

DB2 Connect 7.x went out of support Sept. 30, 2004. Any updates to DB2 R810 for z/OS will not have been tested with an out of support product. While it may appear to work for you, if you run into problems you will need to purchase an End Of Support (EOS) contract to receive support for this product. Please note that DB2 Connect 8.x is also out of support as of April 30, 2009. The only supported version of DB2 Connect is 9.x [...] 7796 556 36_Re: SQL0968C The File System is Full12_tim malamphy20_timalamphy@YAHOO.COM30_Thu, 2 Jul 2009 09:35:49 -0700460_utf-8 I would agree that the backup should fit on C:  If you look in the db2diag.log file in use, it should have a message as to exactly which file system is running out of space.

--- On Wed, 7/1/09, Russell Collins wrote:



From: Russell Collins Subject: Re: [DB2-L] SQL0968C The File System is Full To: DB2-L@WWW.IDUGDB2-L.ORG Date: Wednesday, July 1, 2009, 11:57 AM [...] 8353 28 50_Six DB2 9 for z/OS product manuals updated in June13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Thu, 2 Jul 2009 14:07:51 -0500183_ISO-8859-1 For all the details, check out my latest blog entry.....

http://it.toolbox.com/blogs/db2zos/more-db2-9-for-zos-product-publications-update-in-june-2009-32678

8382 51 28_Re: [zOS DB2] Sort Hexa data14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Fri, 3 Jul 2009 08:00:57 +1000570_ISO-8859-1 use ALTSEQ CODE=(C1FA,C2FB,C3FC,C4FD,C5FE,C6FF) SORT FIELDS=(p,m,AQ,s)

James Campbell



On 2 Jul 2009 at 17:33, duc wrote:

> > Dear all, > > Do you know how to sort these LSRN (with DFSORT) , to have them in the right sequence . I > have some samples but they deal only with Characters ... > > C46C9ED20FE5 > C46C9ED20EA9 > C46C9ED211E8 > C46C9ED211E8 > C46C9ED210B5 > > > Thank you . > > > > > The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an > IDUG.org member, please register here. [...] 8434 37 42_Omegamon DB2 Performance Expert question ?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM30_Fri, 3 Jul 2009 07:27:52 +0000563_ISO-8859-1 Hello, does anyone know how to create a process in the PE client/PWH that would collect accounting data and create a report at data sharing group level. I configured one instance of PE server to monitor entire DS and data for all members can be seen in the PE client, but in the PWH, processes collect data only for member on the same LPAR. I'm aware of "for all members" option in the process definition window but it doesn't help. Do I have to change trace/reports commands manually (like adding SCOPE(GROUP)) to achieve reporting at DS level ? [...] 8472 53 27_Migrate Oracle to DB2 z/OS?15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM30_Fri, 3 Jul 2009 10:52:23 -0600502_us-ascii As you might know, DB2 9.7 for Linux, UNIX and Windows has significant enhancements intended to help you migrate databases and applications from Oracle to DB2/LUW. Since Oracle has "stabilized" (weasel word!!) their z/OS products I am curious if DB2 for z/OS has any intentions of implementing the same type of enhancements as DB2/LUW. Seems to me there could be a large interest in migrating from Oracle on z/OS to DB2 for z/OS. Anyone out there have any inside knowledge on this issue? [...] 8526 209 63_ADMIN RE: OT The end of an era .... and the start of a new one!16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM30_Fri, 3 Jul 2009 18:36:18 -0400583_iso-8859-1 This thread has gone on long enough as it has very little, or nothing concerning DB2. And in an attempt to minimize OT threads, lets get back to the 'topic du choix'











Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de l'information pouvant être confidentielle. Vous ne devez ni le copier ni l'utiliser ni le divulguer à qui que ce soit à moins que vous soyez le destinataire ou une personne désignée autorisée. Si vous le receviez par erreur, veuillez nous aviser immédiatement et le détruire. [...] 8736 257 67_Re: ADMIN RE: OT The end of an era .... and the start of a new one!13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Fri, 3 Jul 2009 19:59:46 -0400631_us-ascii That's nonsense, Robert.





This thread is short compared to many others about which no complaint was made.

Sure the London/Chicago stuff was superfluous, but the recognitions of the great contributions Phil has made were completely appropriate.

AND You got a lotta nerve trying to curtail this on a Friday.





Dave

From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert Sent: Friday, July 03, 2009 6:36 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] ADMIN RE: OT The end of an era .... and the start of a new one! [...] 8994 178 67_Re: ADMIN RE: OT The end of an era .... and the start of a new one!14_Fazio, Richard21_RFAZIO@TRANSUNION.COM30_Fri, 3 Jul 2009 19:20:43 -0500519_UTF-8 No habla "French"...

Viva le non-sequitor :) Faz

________________________________

From: DB2 Data Base Discussion List To: DB2-L@www.idugdb2-l.org Sent: Fri Jul 03 17:36:18 2009 Subject: [DB2-L] ADMIN RE: OT The end of an era .... and the start of a new one!



This thread has gone on long enough as it has very little, or nothing concerning DB2. And in an attempt to minimize OT threads, lets get back to the 'topic du choix' [...] 9173 23 50_Wayne Goodwin/CIS/TJX/TJXCOS is out of the office.0_21_Wayne_Goodwin@TJX.COM30_Fri, 3 Jul 2009 22:08:52 -0400601_US-ASCII I will be out of the office starting 07/03/2009 and will not return until 07/13/2009.

I will respond to your message when I return.

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG Europe Attendee Testimonial- "The clear and high level technical information of some of the sessions makes the conference a value for the money." _____________________________________________________________________ 9197 306 12_Re: DSNU032E13_Laila hosaini19_lshosaini@YAHOO.COM30_Sat, 4 Jul 2009 22:44:22 -0700589_iso-8859-1 Hi Dear ACCORDING TO you previous mail; last week i found this message in LOG

IOS000I F581,05,IOE,01,0600,,**,SATDAY,BKFPSAT 332 024410C050305650 0001FF0000000000 0331003118333690 43042300B1C11312 POSITIONING LOST IEA043I SVC DUMP REACHED MAXSPACE LIMIT - MAXSPACE=00000500 MEG IEA794I SVC DUMP HAS CAPTURED: 334 DUMPID=066 REQUESTED BY JOB (BKFPSAT ) DUMP TITLE=DSNM,ABND=04E-00E40071,U=SOMAYEH ,C=XYR00.910.UTIL-D SNUT910,M=DSNUGSAT,LOC=DSNUT910.DSNUGSDA+458C





THEN i change tape AND take a new tape ;today we have this message in LOG again; [...] 9504 56 50_Luis Henrique Maciel da Rosa is out of the office.0_16_luish@BR.IBM.COM30_Sun, 5 Jul 2009 04:02:12 -0300507_US-ASCII

I will be out of the office starting 04/07/2009 and will not return until 27/07/2009.

GDF Dispatcher: mfdb2iga@br.ibm.com

Any severity 1 issue, please ask OPS to contact DB2 Support Oncall.

For IGA DB2 Support my backup is "jngarcia@br.ibm.com"

For WHIRLPOOL IDMS Support my backup is "rodneihe@br.ibm.com".

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...] 9561 89 60_AUTO: Alan Brown is out of the office (returning 07/13/2009)10_Alan Brown20_alanbrown@US.IBM.COM30_Sun, 5 Jul 2009 04:00:15 -0400413_US-ASCII



I am out of the office until 07/13/2009.

I am on vacation. You will receive this notification once.

If you need immediate technical assistance, please contact Pete Kohler (pkohler@us.ibm.com) at (203) 486-5716.

I will respond to your message when I return. You will receive this message only once.





You will receive this message only once. [...] 9651 59 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM30_Mon, 6 Jul 2009 09:28:36 +0000831_windows-1252 Hi Chris,

Below is the part of JCL which I have been trying out.

DSN SYSTEM (DB2Z) BIND PACKAGE(DESAHASR.DSNUTIL) - COPY(DSNUTIL.DSNUGSQL) - CURRENTDATA(NO) ISOLATION(CS) - ACTION(REPLACE) OPTIONS(COMMAND)

and below is the error message which I am getting.

BIND PACKAGE(DESAHASR.DSNUTIL) COPY(DSNUTIL.DSNUGSQL) CURRENTDATA (NO) ISOLATION DSNE932I WARNING, ONLY IBM-SUPPLIED COLLECTION-IDS SHOULD BEGIN WITH "DSN" DSNE932I WARNING, ONLY IBM-SUPPLIED COLLECTION-IDS SHOULD BEGIN WITH "DSN" DSNE932I WARNING, ONLY IBM-SUPPLIED PACKAGE-IDS SHOULD BEGIN WITH "DSN" DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D31039, TYPE OF RESOURCE 0000100 4, AND RESOURCE NAME DESAHASR.SDEVYAN.DSNBIND DSNT233I -DB2Z UNSUCCESSFUL BIND FOR PACKAGE = [...] 9711 110 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF12_Travis, John25_john.travis@CAPGEMINI.COM30_Mon, 6 Jul 2009 11:47:45 +0100543_us-ascii 00D31039

Explanation: The requested VTAM function to allocate a conversation was not performed because the SYSIBM.USERNAMES table at the requesting site did not contain a row describing the remote authorization ID to be used for this DB2 authorization ID. When the USERNAMES column in SYSIBM.LUNAMES specifies 'O' or 'B', outbound name translation is in effect. The SYSIBM.USERNAMES table must contain entries describing the remote authorization ID to be used for each DB2 authorization ID communicating with that LUNAME. [...] 9822 186 12_Re: DSNU032E14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 6 Jul 2009 21:07:00 +1000724_ISO-8859-1 It is a hardware problem. Give it to your hardware people.

James Campbell



On 4 Jul 2009 at 22:44, Laila hosaini wrote:

> > Hi Dear > ACCORDING TO you previous mail; > last week i found this message in LOG > > IOS000I F581,05,IOE,01,0600,,**,SATDAY,BKFPSAT 332 > 024410C050305650 0001FF0000000000 0331003118333690 43042300B1C11312 > POSITIONING LOST > IEA043I SVC DUMP REACHED MAXSPACE LIMIT - MAXSPACE=00000500 MEG > IEA794I SVC DUMP HAS CAPTURED: 334 > DUMPID=066 REQUESTED BY JOB (BKFPSAT ) > DUMP TITLE=DSNM,ABND=04E-00E40071,U=SOMAYEH ,C=XYR00.910.UTIL-D > SNUT910,M=DSNUGSAT,LOC=DSNUT910.DSNUGSDA+458C > > > THEN i change tape AND take a new tape;today we have this message [...] 10009 85 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF9_Chris Tee23_Chris.Tee@SENTENIAL.COM30_Mon, 6 Jul 2009 13:36:50 +0100567_us-ascii Devyani

The id doing the bind (SDEVYAN in this case) will need an outbound translation entry in the USERNAMES table. The id it is translated to will need at least BINDADD, and IMPLICIT_SCHEMA or CREATEIN on schema DSNUTIL on the Windows server.

Regards

Chris

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Devyani R Sahasrabudhe Sent: 06 July 2009 10:47 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF [...] 10095 36 26_Joins / Predicate location13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Mon, 6 Jul 2009 08:28:44 -0700584_ISO-8859-1 In Robert Catterall's latest blog post (http://www.catterallconsulting.com/2009/07/outer-join-get-predicates-right.html), he makes the point that it matters where predicates are coded in your statement. He wrote:

"For a left outer join, a WHERE-clause predicate that references a column of the left-side table will filter rows from that table. That same predicate, if coded in the ON-clause of the SELECT statement, will NOT filter left-side table rows. Instead, that predicate will just affect the matching of left-side table rows with right-side table rows." [...] 10132 33 30_Re: Joins / Predicate location14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 6 Jul 2009 16:24:04 +0000432_ISO-8859-1 > shouldn't the optimizer pull the predicate out of the ON clause and use it for filtering?

Of course, the optimizer might move around predicates, as long as the semantics remain the same. The point here is that a LEFT JOIN guarantees all rows from the "left" table to be kept intact (at least, before any WHERE condition is applied). So the ON condition effectively does not filter rows from the left table. [...] 10166 43 20_DB2 9 Upgrade Issues10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Mon, 6 Jul 2009 19:13:43 +0000414_windows-1252 A cople of things we came across that others may want to avoid.

RRF (Reordered row format) causing utility abends due to incorrect calculations. This happened both with SAP and legacy environments. Tables that had Varchar(20) or smaller are at risk for having utilities abend due to incorrect sizing calculations. Since the PTF is PE'd we turned on a hidden zparm to turn off RRF for now. [...] 10210 85 24_Re: DB2 9 Upgrade Issues13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Mon, 6 Jul 2009 13:10:48 -0700528_us-ascii Hi Jorg. Thank you for sharing your experience. We are a little skittish about problems right now, and are considering turning off RRF. Would you mind expanding a bit more: which utilities, the impact of the abends, and how you recovered from them? Thanks very much!

Regards, Cathy Taddei

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jorg Lueke Sent: Monday, July 06, 2009 12:14 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 9 Upgrade Issues [...] 10296 28 49_New DRDA with DB2 for z/OS draft Redbook released13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Mon, 6 Jul 2009 18:57:19 -0500164_ISO-8859-1 Details on my blog...

http://it.toolbox.com/blogs/db2zos/a-new-draft-ibm-redbook-is-available-db2-9-for-zos-distributed-architecture-32762

10325 329 67_Re: ADMIN RE: OT The end of an era .... and the start of a new one!16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM30_Mon, 6 Jul 2009 20:50:25 -0400417_us-ascii I had no issues on Phil contribution and I did not make a comment when the thread was dealing with, remarking about Phil contribution (and the extraordinary contribution he has done). But the thread drift was evident

And on a Friday. The thread had run its course. And it does not matter on what day of the week that becomes true. Given that this volunteer job is not a 9 to 5 5 days a week job. [...] 10655 127 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF22_Devyani R Sahasrabudhe22_devyani.sah@IN.IBM.COM30_Tue, 7 Jul 2009 10:32:56 +0000339_windows-1252 Hi Chris,

thanks for your response. I am sorry to ask stupid question but please can you bit elaborate on last sentence "The id it is translated to >will need at least BINDADD, and IMPLICIT_SCHEMA or CREATEIN on schema >DSNUTIL on the Windows server.". also do we need to restart DDF everytime after updating CDB? [...] 10783 153 67_Re: SQLCODE -904 while accessing Windows DB2 Data on Z/OS using DDF9_Chris Tee23_Chris.Tee@SENTENIAL.COM30_Tue, 7 Jul 2009 12:34:02 +0100379_us-ascii Devyani

To be able to bind the DSNUGSQL package on the Windows server, the id being used will require those privileges on the server. With regard to recycling DDF, it depends on what changes are being made, e.g. USERNAMES changes wouldn't require a recycle but a change of IPADDR in IPNAMES would. Maybe speak to the sysprog who supports your DB2 subsystem. [...] 10937 69 53_Re: New DRDA with DB2 for z/OS draft Redbook released14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Tue, 7 Jul 2009 10:21:15 -0400389_us-ascii Willie, Toolbox isn't responding for me -- could you post the link here? --Phil Sevetson

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Willie Favero Sent: Monday, July 06, 2009 7:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] New DRDA with DB2 for z/OS draft Redbook released

Details on my blog... [...] 11007 135 24_Re: DB2 9 Upgrade Issues10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 7 Jul 2009 14:45:50 +0000462_windows-1252 Hi Cathy,

The RRF related abends affected Reorgs and Unloadss. One issue on SAP was that the compression was worse with RRF so that the reorg would fail because of the 4GB limit on a partition. More often both reorgs and unloads would fail with a ABND=0C4-00000010 because the internal calculations were off. There were local fixes/patches but in the end we decided to leave off RRF because there were too many failures to easily patch. [...] 11143 205 53_Re: New DRDA with DB2 for z/OS draft Redbook released11_Dirk Johann20_dirkjohann@GMAIL.COM30_Tue, 7 Jul 2009 16:47:03 +0200899_windows-1252 Here it is - on behalf of Willie:

http://www.redbooks.ibm.com/redpieces/abstracts/sg246952.html

Regards, Dirk



On Tue, Jul 7, 2009 at 16:21, Sevetson, Phil wrote:

> Willie, Toolbox isn't responding for me -- could you post the link here? > --Phil Sevetson > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Willie Favero > Sent: Monday, July 06, 2009 7:57 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] New DRDA with DB2 for z/OS draft Redbook released > > Details on my blog... > > http://it.toolbox.com/blogs/db2zos/a-new-draft-ibm-redbook-is-available- > db2-9-for-zos-distributed-architecture-32762 > > -- > Willie > My DB2 blog [...] 11349 47 53_Re: New DRDA with DB2 for z/OS draft Redbook released13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 7 Jul 2009 09:56:16 -0500626_ISO-8859-1 http://www.redbooks.ibm.com/redpieces/abstracts/sg246952.html

Willie

Sevetson, Phil wrote: > Willie, Toolbox isn't responding for me -- could you post the link here? > --Phil Sevetson > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Willie Favero > Sent: Monday, July 06, 2009 7:57 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] New DRDA with DB2 for z/OS draft Redbook released > > Details on my blog... > > http://it.toolbox.com/blogs/db2zos/a-new-draft-ibm-redbook-is-available- > db2-9-for-zos-distributed-architecture-32762 > > 11397 83 26_Two-Phase commit from Z/OS14_Thomas Heckman19_theckman@SYSCOM.COM30_Tue, 7 Jul 2009 16:57:34 +0000354_windows-1252 Running a batch program on Z/OS. The program has two modules each with their own package. The driver module reads and updates a table that resides on Z/OS, then call the second module that attempts to insert a row to a table that resides on a Windows server.

The Insert return a SQLCODE -919 (SQLSTATE 57045). The manual says... [...] 11481 20 30_Re: Two-Phase commit from Z/OS10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM30_Tue, 7 Jul 2009 18:48:30 +0000474_windows-1252 Is the Insert getting a return code on the windows server?

_____________________________________________________________________

* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

_____________________________________________________________________

IDUG Europe Attendee Testimonial- "Conference was superb! Couldn’t fault anything. Very impressed." _____________________________________________________________________