1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2005, week 5
2 170 20_Multi Site Update...14_ISMAIL CETINER19_icetiner@SSK.GOV.TR31_Fri, 29 Jul 2005 12:28:21 +0300391_us-ascii Greetings All,
I have a requirement for an application to do a multi-site updates.
1'st hop is to an OS/390 - Z/OS DB2 V7.1 database. (works fine) From Z/os 1.4V7.1
2'nd hop is to a DB2 LUW 8.2 server running on Windows. (receives -919 on the first update statement)
I have bound remote packages at the Application Servers and using CONNECT TYPE 2. [...]
173 31 30_Force Application doesn't work13_Lee Robertson24_lee_robertson@FSMAIL.NET31_Fri, 29 Jul 2005 05:55:03 -0500549_- Hi all,
AIX 5.1 DB2 UDB EEE v7.2
Yesterday we had an application that needed forcing off. When attempting to do so it wouldn't. It didn't show that it was rolling back in the list apps.
I know in Oracle you can link back from the dynamic performance tables to see which UNIX process belongs to the database session and as a last resort kill that process which drops the connection but thus far I cannot see how to do this in DB2. I know of the db2_kill command and have used this in the past (under IBMs supervision) but [...]
205 64 16_Re: Load Utility12_Cuneyt GOKSU19_cuneytgoksu@USA.NET31_Fri, 29 Jul 2005 14:02:02 +0300465_ISO-8859-1 Hi,
I assume you pass RELOAD phase.
after the abend Data is there with copy pending status and indexes are in rebuild pending.
Rebuild them one by one.
Regards, cuneyt
--- Date: Thu, 28 Jul 2005 12:08:11 -0500 From: Steve_Grimes@AISMAIL.WUSTL.EDU Subject: Load Utility
Hello, DB2 v7.1, z/OS here.
I'm trying to load a large (for us) 12 partition table, (20 million rows or so) with 13 NPI's. [...]
270 14 27_Re: PUNC bit and Page Reorg24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Fri, 29 Jul 2005 06:21:21 -0500579_- Name less person ,
In my opinion you should keep quiet if you cannot answer my question.
Ram
--------------------------------------------------------------------------------- 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
285 79 16_Re: Load Utility13_Gurmeet Singh21_singhg@MAHINDRABT.COM31_Fri, 29 Jul 2005 12:50:33 +0100327_iso-8859-1 Hi,
We also faced a similar sort of problem while we tried to load data on a tablespace with 10 partitions.
We could manage to load the data with a low amount of sort space when we loaded 1 partition at a time.
You can use UNLOAD TABLESPACE Tablespace name PART 01.
Regards, Gurmeet [...]
365 54 35_AW: [DB2-L] PUNC bit and Page Reorg12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 29 Jul 2005 13:45:06 +0200628_- Ram,
may be this is what you are looking for (copied from http://www.dbazine.com/db2/db2-mfarticles/mullins-lockavoidence/):
...... When determining if lock avoidance techniques will be practical, DB2 first scans the page to be accessed to determine whether any rows qualify. If none qualify, a lock is not required.
For each data page to be accessed, the RBA of the last page update (stored in the data page header) is compared with the log RBA for the oldest active unit of recovery. This RBA is called the Commit Log Sequence Number, or CLSN. If the CLSN is greater than the last page update RBA, [...]
420 140 34_Re: Force Application doesn't work4_Peri19_peri.ncst@GMAIL.COM31_Fri, 29 Jul 2005 18:02:42 +0530530_ISO-8859-1 Hello, The following link can help one understand when does the force signal on any agent be ignored. http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB540&dc=DB510&dc=DB550&q1=FORCE&uid=swg21108336&loc=en_US&cs=utf-8&lang=en And, if it is not a either a production database or you can bear the expense of giving a try then db2 list applications show detail | grep -i agentid -> would give you a *PID * associated with the database agent. kill -36 *PID* [...]
561 25 38_Re: Crystal Enterprise edition and DB213_Jaydeep Ghosh29_jaydeep_ghosh@PROGRESSIVE.COM31_Fri, 29 Jul 2005 08:12:48 -0500430_- Steve,
The ID to the crystal server allows the user to access and submit the Crystal Report for execution. Once submitted, the report can be set to use a default mainframe id/password , or can prompt the submitter for one.
You can use a generic id/password for the DB2 and grant the neceaary privileges to this userid. The report could be set up to use this generic user/password from the Management console. [...]
587 26 28_LISTDEF/TEMPLATE and RESTART10_Bill Brown21_db2_dba@BELLSOUTH.NET31_Fri, 29 Jul 2005 10:14:29 -0500557_- I have been using the LISTDEF and TEMPLATE control statements in DB2 utilities since they became available. However, our shop has continued to use previously set up procs that did not take advantage of these statements. Recently a developer came and asked about using them in production and the question arose as to what actions to take if a utility using a TEMPLATE and LISTDEF were to abend. To test out the process I set up an image copy utility with a short list of tablespaces and a template that specified files to be stacked on tape. I let it [...]
614 72 58_Re: Continuing saga - RE: Loading data from re-org archive0_25_Dave.Schaeffer@BENDIX.COM31_Fri, 29 Jul 2005 11:49:39 -0400466_koi8-r Hello Horacio,
Thank you very much for this information!! This is exactly what I was looking for. Which manual did you get this information?
Dave Schaeffer
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Horacio Villa Sent: Thursday, July 21, 2005 9:21 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Continuing saga - RE: Loading data from re-org archive [...]
687 108 16_Re: Load Utility0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 29 Jul 2005 10:54:07 -0500320_US-ASCII Hello,
Thank you all for the useful input! The task is finished! (For now.) From here on I'll tackle this a partition at a time. That is an option for us because, at any given time of year, only 2 or 3 of the partitions will have changes.
Now to address some of the other specific advice.... [...]
796 22 39_Re: AW: [DB2-L] PUNC bit and Page Reorg24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Fri, 29 Jul 2005 11:18:41 -0500402_- Sir,
Thank you for the answer. I understand that the PUNC bits get set when a row is read for update and the bits remain set even after the updated row is written back into the page.
I have heard that the PUNC bits get reset only during (a) There is an exclusive lock on the page (b) More than 25 % of the rows in a page need to have their PUNC bits reset (c) During a page reorg. [...]
819 57 39_Re: AW: [DB2-L] PUNC bit and Page Reorg9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 29 Jul 2005 11:40:59 -0500435_windows-1250 page reorg occurs when the free space in a page is scattered in multiple places and DB2 has a record to insert or replace.
Mike Bell HLS Technologies -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ramachandran Subramanian Sent: Friday, July 29, 2005 11:19 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] PUNC bit and Page Reorg [...]
877 73 39_Re: AW: [DB2-L] PUNC bit and Page Reorg13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Fri, 29 Jul 2005 12:34:12 -0500479_windows-1250 Too add just a few more words to Mike's explanation, which by the way is correct... .
When DB2 does an insert, it knows from the page header if the row will fit on the the page. Once it has determined that it will fit, it attempts to do the insert. If there is not enough free space in one chunk (technical term... LOL), DB2 will reorganize the page to get all of the free space in once place, thus being able to complete the insert to the correct page. [...]
951 88 58_Re: Continuing saga - RE: Loading data from re-org archive13_Horacio Villa17_hvilla@AR.IBM.COM31_Fri, 29 Jul 2005 16:50:05 -0300579_KOI8-R
Hello Dave,
directly from the manual:
DB2 Universal Database for OS/390 and z/OS
Administration Guide
Version 7
Document Number SC26-9931-03
Cheers,
Horacio Villa
Dave.Schaeffer@BE NDIX.COM To: DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc: Base Discussion Subject: Re: [DB2-L] Continuing saga - RE: Loading data from re-org archive List
29/07/2005 12:49 Please respond to DB2 Database Discussion list at IDUG [...]
1040 76 23_Re: DB2 Z/os reorg ????9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Fri, 29 Jul 2005 16:11:51 -0500307_iso-8859-1 I have a DB2 reorg with a LISTDEF, and a template. It looks like the selection process works okay, but when the tablespace is to be processed, the Database name and tablespace name are run together. Then the qualifier for the tablespace is too long.
Has anyone else seen this happen. [...]
1117 162 23_Re: DB2 Z/os reorg ????12_Theresa Ryan27_Theresa.Ryan@HUNTINGTON.COM31_Fri, 29 Jul 2005 17:17:35 -0400581_iso-8859-1 Your syntax is a little off; you need two periods between &DB and &TS just as you have between &TS and D&DATE:
'TMCP.I.CPY.&DB..&TS..D&DATE..T&TIME.'
Theresa L. Ryan DB2 DBA - Enterprise Database Management Team Huntington National Bank 7 Easton Oval (EA3C22); Columbus, OH 43219 Phone: (614) 331-9957 Cell: (614) 402-0949 Email: Theresa.Ryan@huntington.com
Dee Reins To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] DB2 Z/os reorg ???? [...]
1280 104 23_Re: DB2 Z/os reorg ????10_Kim Larson18_Kim_Larson@ADP.COM31_Fri, 29 Jul 2005 17:22:53 -0400539_- You need 2 dots after the &DB in the TEMPLATE card.
Kim Larson
-----Original Message----- From: Dee Reins [mailto:dee.reins@CENTURYTEL.COM] Sent: Friday, July 29, 2005 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Z/os reorg ????
I have a DB2 reorg with a LISTDEF, and a template. It looks like the selection process works okay, but when the tablespace is to be processed, the Database name and tablespace name are run together. Then the qualifier for the tablespace is too long. [...]
1385 138 23_Re: DB2 Z/os reorg ????9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Fri, 29 Jul 2005 16:36:13 -0500575_iso-8859-1 That was it. Thank you very much
Dee Reins
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Kim Larson Sent: Friday, July 29, 2005 2:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Z/os reorg ????
You need 2 dots after the &DB in the TEMPLATE card.
Kim Larson
-----Original Message----- From: Dee Reins [mailto:dee.reins@CENTURYTEL.COM] Sent: Friday, July 29, 2005 2:12 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Z/os reorg ???? [...]
1524 29 48_Re: DB2 v7 to v8 migration - application scripts12_David Nobles19_dnobles@DNOBLES.COM31_Fri, 29 Jul 2005 22:09:04 -0400365_us-ascii I just wanted to thank everybody for their informative replies.
It was the information I was looking for, plus more. Just what I've come to expect from this group.
David Nobles
>No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.338 / Virus Database: 267.9.5/58 - Release Date: 7/25/2005
1554 93 34_Re: Force Application doesn't work13_Lee Robertson24_lee_robertson@FSMAIL.NET31_Sat, 30 Jul 2005 03:55:13 -0500762_- Many thanks for the response on this
Regards
Lee
On Fri, 29 Jul 2005 18:02:42 +0530, Peri wrote:
>Hello, >The following link can help one understand when does the force signal on any >agent be ignored. >http://www-1.ibm.com/support/docview.wss? rs=71&context=SSEPGG&dc=DB520&dc=D600&dc=DB530&dc=D700&dc=DB500&dc=DB540&dc =DB510&dc=DB550&q1=FORCE&uid=swg21108336&loc=en_US&cs=utf-8&lang=en > And, if it is not a either a production database or you can bear the >expense of giving a try then >db2 list applications show detail | grep -i agentid -> would give you a *PID >* associated with the database agent. >kill -36 *PID* > > > > On 7/29/05, Lee Robertson wrote: >> >> Hi all, [...]
1648 23 39_Re: AW: [DB2-L] PUNC bit and Page Reorg24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Sat, 30 Jul 2005 07:20:13 -0500323_- Kind Sirs,
Thank you so much for explaining to me what a page reorg is. In essense even if the space map page says there is x bytes of space in a particular page where db2 is looking to insert a row , these x bytes may not be contigous. At that point db2 does a page reorg so that it can insert this new row. [...]
1672 156 23_Re: Sort BP question???12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 31 Jul 2005 08:47:43 +0200552_us-ascii Hi,
I guess you mean that the nu,ber of changed pages does no go down.
That's WAD (Works As Designed) - there's no need to actually keep DSNDB07 pages after the work is done so there's no need to externalize them to disk. Externalization may take place if the sort needs more space in the BP than the VDWQT/DWQT, those pages will be read back later on during the sort, however when the last phase of the sort is done, and the data is passed back to the requesting task, there's no more need for those pages and writing them [...]
1829 129 61_Re: Moving DB2 dataset to another disk drive (outside of DB2)19_Michael L. McCawley20_Mike_DBA@HOTMAIL.COM31_Sun, 31 Jul 2005 13:31:51 -0500331_iso-8859-1
Dave -
Yes, the ALLMULTI is definitely a requirement to safely move multi-volume datasets.
Also, if you remove the TOL(ENQF) parameter, then the utility will fail (skip to the next dataset) on any dataset that is open to DB2. I believe that is a more prudent method of using the move utility. [...]