1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2009, week 2
2 147 41_Re: DB2 z/OS Code Samples - any requests?14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE30_Sun, 8 Nov 2009 09:38:39 +0100426_ISO-8859-1 I did that in PL/1 recently, and it worked. It's not undocumented.
I think the key is that in your example you need to identify the LK_APPL_ID definition with the pointer in the DBINFO structure. I don't know how this has to be done in COBOL, but it can be done. The APPL_ID is not passed as an extra pointer via USING in the PROCEDURE DIVISION, that is not the right way. Ask your local COBOL techies. [...]
150 91 41_Re: DB2 z/OS Code Samples - any requests?14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Mon, 9 Nov 2009 03:36:29 +0000371_utf-8 Seems a bit odd to me. This is the IDUG DB2-L listserv and the IDUG DB2 CODEPAGE is not under consideration for a place to post code samples.
I have no complaints with other locations for DB2 help but one should be aware of where they are at.
Regards Avram Friedman
On Fri, 6 Nov 2009 14:23:40 -0600, Todd Burch wrote: [...]
242 98 33_Re: Question on a DSNZPARM change14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Mon, 9 Nov 2009 03:44:29 +0000319_utf-8 Given that you are asking this procedure question we should assume that you are not an expert in the process
NO TRICKS FOR YOU.
Run the DB2 install CLIST Be sure to specify a new dataset name for NEW.SDSNSAMP or back up the old one first.
The install CLIST will generate the proper job. [...]
341 75 33_Re: Question on a DSNZPARM change16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM30_Mon, 9 Nov 2009 00:35:50 -0500302_UTF-8 If you happen to have a license for one CA DB2 product, you also have access to option TT which allows you to change any DB2 ZPARM parameter on the fly without assembling. If you have access to BMC Opertune, you will have the same opportunity (AFAIK) - which make the steps a little easier. [...]
417 173 34_Visiting DBA / SYSPROG suggestions14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM30_Mon, 9 Nov 2009 08:21:45 +0000597_utf-8 Ichanged the title of a thread started by bknight@REMOTEDBAEXPERTS.COM to address a slightly diffrent question than the one originally proposed.
If I am called upon to be a short term DBA or SYSPROG, in the absence of permament staff what general rules should guide me technically?
I would like to suggest 4 rules 1. Investigate and question every change. 2. Obtain shop standards and procedures in general and in the database area. Then follow them of course. 3. In the absence on shop standards / procedures do things by the book even if there is a better way. 4. Leave [...]
591 1215 36_Re: Changing limitkey on a Partition15_Patrick Hignett32_Patrick.Hignett@SSSWORLDWIDE.COM30_Mon, 9 Nov 2009 09:57:26 +0000287_us-ascii Even if the partition is empty it will still be set to REORP and start access force does not work in this situation. I have recently had to do this very thing. You have to alter the limit keys in reverse order and then you must reorg the partitions even if they are empty. [...]
1807 43 36_Re: Changing limitkey on a Partition14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Nov 2009 10:28:53 +0000377_UTF-8 The good news is that REORGing an empty partition won't take long, and it won't even interfere with other applications having "partition-specific" access paths.
Provided you use the PART keyword of REORG, of course. And be careful with the PART number, especially in case there has already been a ROTATE.
-- Peter Vanroose, ABIS Training & Consulting. [...]
1851 386 36_AW: Changing limitkey on a Partition35_Walter Jani=?WINDOWS-1252?Q?=DFen?=26_Walter.Janissen@ITERGO.COM30_Mon, 9 Nov 2009 12:58:31 +0100678_iso-8859-1 Hi Glenn
Did you ever talk about this problem to any IBM'er? There is undocumented option in the Repair-uitlity to get rid of this flag. I am not allowed to tell you, because it is somehow internal.
Mit freundlichen Grüßen Walter Janißen
ITERGO Informationstechnologie GmbH Anwendungsentwicklung Laufzeitarchitektur Victoriaplatz 2 40477 Düsseldorf mailto:walter.janissen@itergo.com
Vorsitzender des Aufsichtsrates: Jürgen Vetter Geschäftsführung: Dr. Bettina Anders (Vorsitzende), Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön. Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996 [...]
2238 43 37_Re: DB2 Stored Procedures (mainframe)7_Jan tje25_jan.moeyersons@ADELIOR.BE30_Mon, 9 Nov 2009 12:12:17 +0000585_utf-8 On Thu, 5 Nov 2009 13:18:41 -0500, Wolters, Jeff B. wrote:
> They want to streamline this because they are expecting a huge increase in > the number they generate (up til now, we've had a minimum of activity and > the DBAs have been able to handle it).
Caveat emptor... I read in this remark that you will be running many stored procs doing each very little actual work. That will bite you in overhead for the invocation of the stored procedures. You will end up with 10 times more CPU consumed in calling the stored procedures than [...]
2282 156 33_Re: Question on a DSNZPARM change13_Robert Knight28_bknight@REMOTEDBAEXPERTS.COM30_Mon, 9 Nov 2009 08:31:18 -0500520_us-ascii I want to thank all for the input on the ZPARM change.
Avram is correct on utilizing the proper procedures when performing this type of modification and his observations posted were relevant.
The reason for my question is as follows:
It's been 4-5 years since I performed a migration and for that matter any systems work. In that time frame I was accustomed to stopping DB2, make the necessary Zparm change, and restarting DB2. (I am relatively sure some of us have done that before). [...]
2439 84 36_Re: Changing limitkey on a Partition14_Lyon, Lockwood20_Lockwood.Lyon@53.COM30_Mon, 9 Nov 2009 09:00:25 -0500703_us-ascii Esteemed List,
The comment "REORGing an empty partition won't take long" is not precisely true.
We do regular (monthly) Reorgs of "empty" partitions followed by partition rotations. Here's sample output from a Reorg of a Partition:
UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR ... UNLOAD PHASE COMPLETE, ELAPSED TIME=00:05:54
- (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE ... (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0 (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:00 ... SORTBLD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX ... ... SORTBLD PHASE STATISTICS. NUMBER OF INDEXES = 8 SORTBLD PHASE COMPLETE, ELAPSED [...]
2524 464 37_Re: DB2 Stored Procedures (mainframe)14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Mon, 9 Nov 2009 15:26:16 +0100653_us-ascii Hi,
We developed the same rexx-procedure. It's a good idea
greetings,
Patrick Steurs
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of David Simpson Sent: vrijdag 6 november 2009 18:17 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Stored Procedures (mainframe)
The procedure does need to run in an authorized address space, so this is a concern. In one shop we wrapped the call to WLM_REFRESH in a REXX for the developers to use. If you do it this way you can control which WLMs they are allowed to refresh. [...]
2989 158 41_Re: DB2 z/OS Code Samples - any requests?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV30_Mon, 9 Nov 2009 09:53:25 -0500392_us-ascii Done.
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Todd Burch Sent: Friday, November 06, 2009 11:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 z/OS Code Samples - any requests?
Hi Phil.
I would suggest that since this something that you've done, or Suresh has done, that one of y'all post it out there. [...]
3148 379 52_Fw: New England DB2 User's Group Meeting November 197_Ed Long19_rdhm99a@PRODIGY.NET30_Mon, 9 Nov 2009 08:35:27 -0800568_utf-8 Our next meeting is scheduled for Thursday November 19 in Sturbridge Mass. We are delighted to have the following lineup of terrific speakers, Sheryl Larsen, Curt Cotner, and Phil Czacharowski. See below for details Seats are limited so sign up now. There will be sticky buns, fabulous prizes and no turkey! See you soon.  November 19, 2009 - Meeting Notice  The next meeting of the New England DB2 User's group will occur on Thursday November 19, 2009 in the Tap Room at the Publick House in Sturbridge Mass. As usual we will start at 0900 and wrap up [...]
3528 47 36_Re: Changing limitkey on a Partition14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Nov 2009 16:56:28 +0000397_UTF-8 Lock,
Any explanation of those > 5 minutes? Could it be that the JCL allocation size for SYSREC is too large? Or maybe for the DFSORT datasets? And what happens when you specify the following REORG options for that empty partition: SRHLEVEL NONE SORTDATA NO
-- Peter Vanroose.
On Mon, 9 Nov 2009 09:00:25 -0500, Lyon, Lockwood wrote: [...]
3576 79 36_Re: Changing limitkey on a Partition12_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 9 Nov 2009 19:53:54 +0200417_UTF-8 Hi,
It may be "empty" but physically BIG so DB2 reads all pages to look for records to be unloaded. How was it emptied? Can it be resized down to 1 track ?
Isaac Yassin -----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Vanroose Sent: Monday, November 09, 2009 6:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Changing limitkey on a Partition [...]
3656 46 36_Re: Changing limitkey on a Partition14_Peter Vanroose17_pvanroose@ABIS.BE30_Mon, 9 Nov 2009 22:13:32 +0000358_UTF-8 On Mon, 9 Nov 2009 19:53:54 +0200, Isaac Yassin wrote: > It may be "empty" but physically BIG so DB2 reads all pages to look for records to be unloaded.
Good point! Actually, that would be a very good reason to migrate the tablespace to UTS (partition by range) when on version 9, since a UTS partition is segmented. [...]
3703 72 36_Re: Changing limitkey on a Partition9_Mike Bell21_mbell11a1@VERIZON.NET30_Mon, 9 Nov 2009 17:10:35 -0600445_us-ascii If you shrink the partition, then you accept the overhead of formatting the space as you insert rows. Which is why we specified REUSE and PREFORMAT for our logging tables.
Mike HLS Technologies
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Peter Vanroose Sent: Monday, November 09, 2009 4:14 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Changing limitkey on a Partition [...]
3776 108 36_Re: Changing limitkey on a Partition12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 10 Nov 2009 06:50:19 +0200420_UTF-8 Hi,
You win some , you lose some. Anyway - you pay for it. Go UTS or shrink and enlarge before use or don't unload from BIG empty ... Your call :-)
Isaac Yassin
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Tuesday, November 10, 2009 1:11 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Changing limitkey on a Partition [...]
3885 52 46_Regarding usage of aliases in db2 across LPARs15_Sabarish Kannan26_sabarishkannan71@GMAIL.COM31_Tue, 10 Nov 2009 10:31:00 +0000384_utf-8 Hi
I have two LPARs(LPAR1 and LPAR2) and my requirement is to create an alias in db2 subsystem of one LPAR referring to another db2 subsystem which is residing in another LPAR.
DB2 subsystem in LPAR1 is db2v9 DB2 subsystem in LPAR2 is db2v8
in LPAR1:
i created the alias as follows:
'create alias db2own1.testa1 for db2l.db2own2.testtab' [...]
3938 43 66_REORG with DISCARDS issue whilst using Function. (DB2 V8 for z/OS)34_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Tue, 10 Nov 2009 11:12:48 +0000371_utf-8 Hi -
Below is reorg with discards card :
I want to archive data < 180 day from current timestamp.
But FILE_HIST_TS is of CHAR(26) type.
To compare i'd need to have both variables in TIMESTAMP or CHAR.
But while i conver FILE_HIST_TS to TIMESTAMP. It seems REORG WITH DISCARDS is not allowing Function to be used in the card. [...]
3982 211 50_Re: Regarding usage of aliases in db2 across LPARs28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Tue, 10 Nov 2009 17:27:01 +0530697_US-ASCII Sabarish,
As far as i know, you can not use aliases in SPUFI or QMFs (dynamic SQLs). But, will work in programs.
Rgds, Bala.
Sabarish Kannan Sent by: IDUG DB2-L 10/11/2009 16:01 Please respond to IDUG DB2-L
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] Regarding usage of aliases in db2 across LPARs
Hi
I have two LPARs(LPAR1 and LPAR2) and my requirement is to create an alias in db2 subsystem of one LPAR referring to another db2 subsystem which is residing in another LPAR. [...]
4194 96 50_Re: Regarding usage of aliases in db2 across LPARs13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 10 Nov 2009 09:03:27 -0500393_utf-8 Hi Sabarish
I believe the last sentence in this excerpt from the SQL reference explains your -204:
"When an application uses three-part name aliases for remote objects and DRDA access, the application program must be bound at each location that is specified in the three-part names. Also, you need to define the alias at the remote site as well as at the local site." [...]
4291 78 50_Re: Regarding usage of aliases in db2 across LPARs9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 10 Nov 2009 08:12:50 -0600545_us-ascii If you want to use the alias, the program MUST be bound on both subsystems with access to the other subsystem. SPUFI is just another program to DB2 so you would have to bind the plan as PKLIST(*.DSNESPCS.DSNESM68) and bind each version on the other subsystem.
Mike HLS Technologies
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sabarish Kannan Sent: Tuesday, November 10, 2009 4:31 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Regarding usage of aliases in db2 across LPARs [...]
4370 28 20_[zOS] Compress SPT0120_Cuneyt Goksu (Gmail)22_cuneyt.goksu@GMAIL.COM31_Tue, 10 Nov 2009 16:39:16 +0200630_US-ASCII PK80375 is closed... Applicable to V8 & V9.
You can compress DB2 directory space SPT01.
Regards, Cuneyt
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal Technical atricles from world famous authors in DB2's most prestigious, peer reviewed magazine now on-line! _____________________________________________________________________ [...]
4399 151 50_Re: Regarding usage of aliases in db2 across LPARs9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK31_Tue, 10 Nov 2009 15:18:08 +0000578_iso-8859-1
Sabarish
What was the object named in the -204 message?
Chris
> Date: Tue, 10 Nov 2009 10:31:00 +0000 > From: sabarishkannan71@GMAIL.COM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] Regarding usage of aliases in db2 across LPARs > > Hi > > I have two LPARs(LPAR1 and LPAR2) and my requirement is to create an > alias in db2 subsystem of one LPAR referring to another db2 subsystem > which is residing in another LPAR. > > DB2 subsystem in LPAR1 is db2v9 > DB2 subsystem in LPAR2 is db2v8 > > in LPAR1: > > i created the alias as [...]
4551 149 50_Re: Regarding usage of aliases in db2 across LPARs19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Tue, 10 Nov 2009 11:39:27 -0500491_us-ascii The first node of your target name needs to be a valid location in sysibm.locations. Is db2l there?
Larry Jardine Production DBA DBA Plan/Product Requests: https://wiki.aetna.com/confluence/display/dbaplan/Requests
________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Chris Tee Sent: Tuesday, November 10, 2009 10:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Regarding usage of aliases in db2 across LPARs [...]
4701 558 50_Re: Regarding usage of aliases in db2 across LPARs18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Tue, 10 Nov 2009 11:05:28 -0700402_us-ascii Sabarish,
After creating the ALIAS successfully, and did you check SYSIBM.SYSTABLES to see if there is an entry for the ALIAS that you created.
Satish
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jardine, Lawrence J Sent: Tuesday, November 10, 2009 9:39 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Regarding usage of aliases in db2 across LPARs [...]
5260 58 70_Re: REORG with DISCARDS issue whilst using Function. (DB2 V8 for z/OS)18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Tue, 10 Nov 2009 11:22:28 -0700473_utf-8 Tejas,
If possible why don't change the timestamp field as a character like.....
CHAR((CURRENT_TIMESTAMP - 180 DAYS)) but don't change the FILE_HIST_TS.
Satish
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of SUBSCRIBE DB2-L Tejas V Jadhav_IBM Sent: Tuesday, November 10, 2009 4:13 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] REORG with DISCARDS issue whilst using Function. (DB2 V8 for z/OS) [...]
5319 65 22_Amount of real storage21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Tue, 10 Nov 2009 17:23:57 -0500339_iso-8859-1 Ever sit around just wondering how stuff works..? or why some people do what they do to DB2? I do. All the time in fact. I mention this today because as a result of a comment someone made today in a meeting, I started wondering/thinking about how much real storage (memory) people have defined to their LPAR that runs DB2. [...]
5385 27 70_Re: REORG with DISCARDS issue whilst using Function. (DB2 V8 for z/OS)34_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Wed, 11 Nov 2009 04:21:46 +0000698_utf-8 Satish - None of the functions like : CHAR (), TIMESTAMP() , CAST(...AS data_type) are working in DISCARDS card.
I am not sure if there is some special syntax for doing this.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...]
5413 68 31_Cancel a postponed abort thread10_Srinivas G21_srinivasg@INFOSYS.COM31_Wed, 11 Nov 2009 05:37:53 +0000697_utf-8 One of my archive Log dataset is damaged. So DB2 was abnormally terminating. Now I have started DB2 in maintenance mode. However there is a POSTPONED ABORT thread that I want to cancel using NO BACKOUT option.
DSNR001I - RESTART INITIATED DSNR003I - RESTART...PRIOR CHECKPOINT RBA=006DDCEDC090 DSNR004I - RESTART...UR STATUS COUNTS 996 IN COMMIT=0, INDOUBT=0, INFLIGHT=0, IN ABORT=0, POSTPONED ABORT=1 DSNR007I - RESTART...STATUS TABLE 997 T CON-ID CORR-ID AUTHID PLAN S URID DAY TIME - -------- ------------ -------- -------- - ------------ --- -------- I SERVER psdmt.exe EHDEM88 DISTSERV P 006D77B5CCBA 314 14:28:31 DSNI023I - DSNIERST PAGESET P1HRSYS .PTTBL PART 001 [...]
5482 101 35_Re: Cancel a postponed abort thread11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 11 Nov 2009 07:44:35 +0000732_UTF-8 Hi,
had similar case once. Have you tried RECOVER POSTPONED CANCEL command? DB2 objects would probably be marked as RECP ....
Regards, Nenad
On Wed, 11 Nov 2009 05:37:53 +0000, Srinivas G wrote:
>One of my archive Log dataset is damaged. So DB2 was abnormally >terminating. Now I have started DB2 in maintenance mode. However there is >a POSTPONED ABORT thread that I want to cancel using NO BACKOUT >option. > > >DSNR001I - RESTART INITIATED >DSNR003I - RESTART...PRIOR CHECKPOINT RBA=006DDCEDC090 >DSNR004I - RESTART...UR STATUS COUNTS 996 >IN COMMIT=0, INDOUBT=0, INFLIGHT=0, IN ABORT=0, POSTPONED >ABORT=1 >DSNR007I - RESTART...STATUS TABLE [...]
5584 26 47_DB2 V9 z/OS - restarting LOAD with DUMMY SYSREC11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 11 Nov 2009 08:00:40 +0000460_UTF-8 Hello, does anybody use DUMMY SYSREC to restart ( complete ) a DB2 load utility that failed due to space shortage? We noticed that on V9 sometimes it leaves DB2 objects with restricted statues ( RECP). Regards,Nenad
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...]
5611 96 26_Re: Amount of real storage11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 11 Nov 2009 07:50:48 +0000604_UTF-8 16GB on our "legacy" LPARs ( CICS and batch) and 33GB on LPARs where we are running DB2 and WAS.
Regards, Nenad
On Tue, 10 Nov 2009 17:23:57 -0500, wfavero@attglobal.net wrote:
>Ever sit around just wondering how stuff works..? or why some people do >what they do to DB2? I do. All the time in fact. I mention this today >because as a result of a comment someone made today in a meeting, I started >wondering/thinking about how much real storage (memory) people have defined >to their LPAR that runs DB2. > >I'm not writing a paper or even [...]
5708 109 35_Re: Cancel a postponed abort thread9_SrinivasG21_SRINIVASG@INFOSYS.COM31_Wed, 11 Nov 2009 13:52:41 +0530592_utf-8 When I do RECOVER POSTPONED CANCEL , nothing much happens :
PROCESSING LOG RECORD AT RBA 006DD4E69000 TO RBA 006D77B5CCBA DSNV435I - CANCELLATION OF POSTPONED ABORT URS HAS BEEN SCHEDULED DSN9022I - DSNVRP 'RECOVER POSTPONED' NORMAL COMPLETION DSNR047I - DSNRBMON POSTPONED ABORT BACKOUT 773 PROCESSING LOG RECORD AT RBA 006DD4E69000 TO RBA 006D77B5CCBA DSNR047I - DSNRBMON POSTPONED ABORT BACKOUT 780 PROCESSING LOG RECORD AT RBA 006DD4E69000 TO RBA 006D77B5CCBA DSNR047I - DSNRBMON POSTPONED ABORT BACKOUT 785 PROCESSING LOG RECORD AT RBA 006DD4E69000 TO RBA 006D77B5CCBA [...]
5818 57 70_Re: REORG with DISCARDS issue whilst using Function. (DB2 V8 for z/OS)14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 11 Nov 2009 19:56:51 +1100381_US-ASCII At various times I've 1) used SQL to generate the character value of CURRENT_TIMESTAMP - 180 DAYS 2) written this in an 80 byte record to a temporary dataset 3) constructed JCL so the temporary dataset is concatenated into the REORG control statements at just the right point
James Campbell
On 10 Nov 2009 at 11:12, SUBSCRIBE DB2-L Tejas V Jadha wrote: [...]
5876 22 35_Re: Cancel a postponed abort thread11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 11 Nov 2009 09:20:29 +0000581_UTF-8 You can also consider LIMIT BACKOUT and BACKOUT DURATION zparms.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups, there is probably one near you! Regional User Groups are your local connection to the Worldwide DB2 User Community _____________________________________________________________________ [...]
5899 29 35_Re: Cancel a postponed abort thread11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Wed, 11 Nov 2009 09:02:26 +0000525_UTF-8 Can you check the DB2 service level? http://www-01.ibm.com/support/docview.wss?uid=swg1PQ88983 As far as I can remember RECOVER POSTPONED CANCEL solved the problem in my case where also a DB2 archive log was missing preventing DB2 to perform roll back successfully. Regards, Nenad
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...]
5929 53 59_SV: [DB2-L] DB2 V9 z/OS - restarting LOAD with DUMMY SYSREC13_Olle Brostrom25_olle.brostrom@SWEDBANK.SE31_Wed, 11 Nov 2009 10:29:12 +0100401_iso-8859-1 Hi, I recognize your problem, If I remember right there was something with KEEPDICTIONARY that caused this problem in a dummy load. Regards, Olle
-----Ursprungligt meddelande----- Från: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] För Nenad Vidak Skickat: den 11 november 2009 09:01 Till: DB2-L@WWW.IDUGDB2-L.ORG Ämne: [DB2-L] DB2 V9 z/OS - restarting LOAD with DUMMY SYSREC [...]
5983 48 35_Re: Cancel a postponed abort thread9_SrinivasG21_SRINIVASG@INFOSYS.COM31_Wed, 11 Nov 2009 15:33:10 +0530597_utf-8 Thanks Nenad. It works !!
Regards, Srinivas G
-----Original Message----- From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Nenad Vidak Sent: Wednesday, November 11, 2009 2:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Cancel a postponed abort thread
Can you check the DB2 service level? http://www-01.ibm.com/support/docview.wss?uid=swg1PQ88983 As far as I can remember RECOVER POSTPONED CANCEL solved the problem in my case where also a DB2 archive log was missing preventing DB2 to perform roll back successfully. Regards, Nenad [...]
6032 1642 35_Database Advisor | Colorado Springs52_Crane, Rob --- Sr Technical Manager Database --- CFS30_Robert.Crane@FREIGHT.FEDEX.COM31_Wed, 11 Nov 2009 09:31:49 -0600975_us-ascii Great Systems DBA opportunity for a seasoned, highly technical, talented and motivated individual.
Qualified applicants only please.
-Rob Crane
http://fedex.hodesiq.com/careers/job_search.aspx?User_ID=
Database Advisor CO-Colorado Springs
View Job Cart
Description
Tell A Friend
Position Information: Preferred Skills/Knowledge Includes:
Excellent DBMS and Database Product Installation, Maintenance and DBA skills:
* Software Implementation and Upgrades
* Documentation & automation tied to product implementation best practices and process improvement for reuse of procedures/processes across the enterprise [...]
7675 313 26_Re: Amount of real storage35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 11 Nov 2009 13:53:41 -0500319_iso-8859-1 Hi Willie,
It varies all over the lot naturally, and it'll be interesting to hear if there are any averages or medians.
My clients range from a low of 2 Gig to a high of 64 Gig for one LPAR.
Interestingly, the site with 64 Gig has more than 24 Gig of 4K pools, 28 Gig used by DBM1, [...]
7989 190 14_Re: DB2 Strobe10_Dave Barry14_dbarry@UPS.COM31_Wed, 11 Nov 2009 13:58:38 -0500568_us-ascii Strobe creates a TCB in the allied address space and dispatches it repeatedly at timed intervals. The Strobe routines record samples of the address space activity and locations of active program code. The samples are written to a data set for later formatting. How you use the formatted reports is up to you, but you would probably look for the DBRMs and SQL statements that execute most frequently and/or use the most CPU. If you have iStrobe, you use a utility to ship the sample data set to an HFS file and use a browser to run the reporting. iStrobe [...]
8180 44 67_AUTO: Mahesh Sugavanam2 is out of the office (returning 16/11/2009)17_Mahesh Sugavanam219_mahsugav@IN.IBM.COM31_Thu, 12 Nov 2009 10:02:04 +0530471_US-ASCII I am out of the office until 16/11/2009.
I will not be available at office starting from 11th November 2009 for this entire week on health reasons.
During this period , Amravati will be taking care of my roles and responsibilities for Datastar back office application , Jerald Philip will be taking care for Dialog Backoffice from offshore , and Anand Sankanarayanan will be helping for Datastar Mainframe database and infrastructure support. [...]
8225 55 33_any db2 tools for data migrations10_Zhang Ming16_db2sub@YAHOO.COM31_Thu, 12 Nov 2009 06:17:11 -0800404_iso-8859-1 deaa db2 expert, our shop plan to install a new application system to replace existing old applications running on z/os db2 V8. so we must plan existing data migrations. does anyone know any db2 tools or products which can be used in data migration in oeder to easy our job and reduce migration time.pls point the web address so we can study on it. tks in advance for help. best regards. [...]
8281 158 37_Re: any db2 tools for data migrations12_Weaver, Rick19_Rick_Weaver@BMC.COM31_Thu, 12 Nov 2009 09:17:36 -0700576_us-ascii Hi. I have embedded a link to my whitepaper on 12 ways to replicate data using BMC Software. Please let me know if you have any questions or need more detail.
http://documents.bmc.com/products/documents/16/62/71662/71662.pdf
Regards,
Rick Weaver Product Manager DB2 z/OS Solutions BMC Software
________________________________ From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Zhang Ming Sent: Thursday, November 12, 2009 8:17 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] any db2 tools for data migrations [...]
8440 124 55_Fw: Row Number function as replacement for Max Subquery12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 12 Nov 2009 09:23:13 -0800567_utf-8 Some time ago, someone posted the following query as a replacement for using a max function with a subquery: The problem I’ve found is that this basically only works if the Dbname, tsname combination is unique. If I try to return multiple tsnames under that DBNAME, this doesn’t work. In essence, the number of rows returned is in each case one and only one. If the query would return more than one row, then it doesn’t seem to work as a replacement. And thus, the where clause of row_num =1 really could be replace with FETCH FIRST row only without [...]
8565 97 59_Re: Fw: Row Number function as replacement for Max Subquery14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 13 Nov 2009 07:20:44 +1100586_ISO-8859-1 select dbname, tsname, ... from ( SELECT A.* , row_number () over(partition by dbname, tsname order by a.start_rba desc) as row_num FROM SYSIBM.SYSCOPY A ) as a where row_num = 1
James Campbell
On 12 Nov 2009 at 9:23, Myron Miller wrote:
> > Some time ago, someone posted the following query as a replacement for using a max function > with a subquery: The problem I´ve found is that this basically only works if the Dbname, tsname > combination is unique. If I try to return multiple tsnames under that DBNAME, this doesn´t > work. > > In essence, [...]
8663 845 45_Re: AW: [DB2-L] Virtual Indexes in DB2 9 z/os15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Thu, 12 Nov 2009 20:12:36 -0500410_iso-8859-1 HI Walter,
I've been very busy and just got a few minutes to try this out.
Yep it works great. I think when I had created this under my authid I didn't have the column order set correct.
It works great when you put the right data in J
Thanks.
Troy Coleman
CA, Inc.
Principal Product Manager [...]
9509 137 59_Re: Fw: Row Number function as replacement for Max Subquery12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 13 Nov 2009 07:24:18 -0800649_iso-8859-1 Thanks for the tip on partition by. I missed that. We've got our query to work great now. Do appreciate the help. Myron ________________________________ From: James Campbell To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Thu, November 12, 2009 3:20:44 PM Subject: Re: [DB2-L] Fw: Row Number function as replacement for Max Subquery select dbname, tsname, ... from ( SELECT A.* , row_number () over(partition by dbname, tsname order by a.start_rba desc) as row_num FROM SYSIBM.SYSCOPY A ) as a where row_num = 1 James Campbell On 12 Nov 2009 at 9:23, Myron Miller wrote: > > Some time ago, someone posted the following [...]
9647 39 47_Re: DB2 Control Center - very long connect time6_Bill M18_bmilam59@YAHOO.COM31_Fri, 13 Nov 2009 19:26:42 +0000563_UTF-8 Hi Michael, Can you let me know if you get a resolution from IBM on the long connect time? I took the traces you suggested and compared them to the other LPAR that connects almost immediately. I see the one that works getting a RECEIVE BUFFER (AR) after a SEND(AR) OBJDSS. The one that fails does a SEND BUFFER (AR) after the corresponding SEND(AR) OBJDSS. I also see what looks like a DB2 reason code of 00E7900C for SYSIBM.SQLPROCEDURECOLS in the one that works and a code of 00E79002 for SYSIBM.SQLPROCEDURECOLS in the one that takes a long time. I [...]
9687 173 47_Re: DB2 Control Center - very long connect time9_Chris Tee25_chris.tee@NOVAMAGIC.CO.UK31_Fri, 13 Nov 2009 21:04:00 +0000627_iso-8859-1
Bill
Going on what you see with regard to the reason codes on the two lpars, the one that gets the 00E7900C connects instantly because the call to SYSIBM.SQLPROCEDURECOLS fails immediately either because the WLM env is not defined or the WLM proc fails for some reason, the one that gets 00E79002 takes a while because the call to SYSIBM.SQLPROCEDURECOLS times out after the TIMEOUT VALUE on panel DSNTIPX (default is 3 mins but yours maybe set higher), i.e it doesn't fail immediately. There are various reasons why the proc couldn't be scheduled within the timeout period, they're explained in [...]
9861 30 37_Easy way to Connect from z/os to LUW?10_Jorg Lueke23_jorg_h_lueke@BCBSMN.COM31_Fri, 13 Nov 2009 21:04:35 +0000454_UTF-8 Is there an easier way to connect to UDB from z/os that doesn't involve the ipnames, locations, usernames set-up? Specifically is there a way to avoid putting the password in usernames when a password is required on the LUW server? Ideally DB2 would get the password from RACF so that DBAs don't have to enter or see the passwords in usernames. There is the RACF pass ticket option, but that requires RACF on the LUW side as well, or does it? [...]
9892 69 41_Re: Easy way to Connect from z/os to LUW?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 13 Nov 2009 17:17:00 -0500423_us-ascii Jorg,
Depends on what you're after. You could theoretically use an SSL connection from the z/OS Unix Systems Services (OMVS) to a Unix/Linux host, if you could set up a trusted connection to the UDB instance's server. But that won't get you a DB2-to-DB2 connection, you'd just be acting like another logged-on session on the UDB instance's server. It doesn't sound like that's what you're looking for. [...]
9962 149 31_Re: Security for Delete Cascade16_Robert Catterall21_rfcatterall@GMAIL.COM31_Fri, 13 Nov 2009 20:55:46 -0500425_ISO-8859-1 Sorry about the very late response, Kals.
The closest thing you may find to what you're looking for in the doc is the following, from the section on DELETE in the DB2 for z/OS *SQL Reference *(both V8 and V9):
"If the delete operation is not prevented by a RESTRICT or NO ACTION delete rule, the selected rows are deleted and any rows that are dependents of the selected rows are also deleted." [...]
10112 448 31_Re: Security for Delete Cascade13_David Simpson22_dsimpson@THEMISINC.COM31_Fri, 13 Nov 2009 22:36:32 -0500702_us-ascii Robert,
Just tested this out... it is as you say. DELETE authority on the child is not necessary.
________________________________________________________________________ ______ David Simpson | Senior Technical Advisor | Themis Education 123 South Avenue E, Westfield NJ, 07090 | phone 908-233-8900 | dsimpson@themisinc.com
For more information about Themis, visit www.themisinc.com
From: IDUG DB2-L [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Catterall Sent: Friday, November 13, 2009 7:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Security for Delete Cascade [...]
10561 33 28_New features in DB2 9 (z/OS)11_Steven Lamb23_stevenjlamb@HOTMAIL.COM31_Sat, 14 Nov 2009 11:21:09 +0000359_UTF-8 What do people think are the new features in DB2 9 that will really make a difference to them? I haven't had any experience of this version yet myself but I've seen mentions of virtual indexes and eliminating the BUILD2 phase for Reorgs. The (main) reason I'm asking is that I've got a technical interview on Monday with a company that uses DB2 9! [...]
10595 64 32_Re: New features in DB2 9 (z/OS)13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Sat, 14 Nov 2009 09:07:15 -0600708_UTF-8 If you are simply looking for list, check out http://it.toolbox.com/blogs/db2zos/db2-9-for-zos-how-could-this-not-be-in-your-plans-20829
If you are looking for details, read the DB2 9 Technical Overview.. http://www.redbooks.ibm.com/abstracts/sg247330.html
Of course, neither of the above is a good substitute for actual experience working on DB2 9....
Willie
Steven Lamb wrote: > What do people think are the new features in DB2 9 that will really make a > difference to them? > I haven't had any experience of this version yet myself but I've seen > mentions of virtual indexes and eliminating the BUILD2 phase for Reorgs. The > (main) reason I'm asking is that I've [...]