1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2007, week 2
2 50 0_14_Linda Hagedorn26_linda.hagedorn@IRELAND.COM31_Sun, 12 Aug 2007 04:13:24 +0000551_iso-8859-1 If you're a subscriber to the DB2-L list, I'm sure you know by now that the list has been down for the last two weeks. Unfortunately, the service that host the DB2-L list server attempted to move it two weeks ago. That move turned into a disaster for us and a large number of their other customers. In spite of an extremely valiant effort by a few very dedicated IDUG volunteers, the DB2-L list is still not available. A longer than anticipated move to a new data center, the lose of a power supply, a crashed hard drive, missing tape [...]
53 122 28_ADMIN DB2-L Service Restored16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Sun, 12 Aug 2007 01:06:06 -0400632_iso-8859-1 DB2-L Service Restored
We are pleased to announce that the IDUG-sponsored DB2 Listserve (DB2-L) has been restored. A team of very dedicated volunteers has been working literally night and day to restore service following an outage that occurred Friday, July 27. The outage was caused when the organization that hosts the DB2-L moved the server to a new installation. Prior to the move, IDUG was informed the move would cause minimal disruption and therefore no warnings were posted to the list. Unfortunately, a significant disruption did occur and as a result the DB2-L was unavailable from July 27 - August [...]
176 63 0_21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Sun, 12 Aug 2007 01:12:23 -0400665_iso-8859-1 Hey, hey, hey.. the gang is back..
I just received a post distributed by the DB2-L list.. if this is true, you all have truly performed magic this week.
Congratulations...
Willie
Original Message: ----------------- From: Linda Hagedorn linda.hagedorn@IRELAND.COM Date: Sun, 12 Aug 2007 04:13:24 +0000 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L]
If you're a subscriber to the DB2-L list, I'm sure you know by now that the list has been down for the last two weeks. Unfortunately, the service that host the DB2-L list server attempted to move it two weeks ago. That move turned into a disaster for us and a [...]
240 106 32_ADMIN: Known errors within DB2-l16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Sun, 12 Aug 2007 01:35:03 -0400573_iso-8859-1 As of this moment the following areas of the IDUG DB-l Listerv is not running properly
Archive.
Right now the ability to access the archives is not available.
Web interface
The web interface is having some issues. What that means is for confirmation of messages to DB2-L-REQUESTS you will have to do the confirmation by email (instructions are within the email that you would have received when you post something to the DB2-L-RREQUEST list), rather then clicking on the URL that is enclosed within the confirmation request post [...]
347 74 34_DB2 for Windows - Restore Question0_18_haldur@ELEKTRON.FO31_Sun, 12 Aug 2007 14:16:34 +0100317_US-ASCII Dear list members!
I am on DB2 for Windows 8.2.
My question is: How do I restore a full image backup to a target database with a different name? -in zOS it would be easy :D
Let's say I have a source database SourceDB and a target database TargetDB, and backup is taken of SourceDB. [...]
422 58 38_Re: DB2 for Windows - Restore Question20_Stritzinger, David G25_david.stritzinger@EDS.COM31_Sun, 12 Aug 2007 09:32:07 -0400539_iso-8859-1 Does the target DB already exist? Even if it does, I believe you need to do a restore with the redirect option. Check out this link for some information about the details. It is from IBM DeveloperWorks site.
http://www.ibm.com/developerworks/db2/library/techarticle/0211melnyk/0211melnyk.html
________________________________
From: DB2 Data Base Discussion List on behalf of haldur@ELEKTRON.FO Sent: Sun 8/12/2007 9:16 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 for Windows - Restore Question [...]
481 100 13_ADMIN Request16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Sun, 12 Aug 2007 09:49:46 -0400314_iso-8859-1 As some of you are aware, IDUG supports/has a number of Listserv lists other then the DB2-L that we all know and love.
Some of these lists are for the various User Groups while others have other specific target areas that all generally deal with DB2.
That being said, the request is, [...]
582 86 0_15_Douwe van Sluis21_d.b.van.sluis@HOME.NL31_Sun, 12 Aug 2007 16:22:17 +0200466_us-ascii It's like all good things in live. You only appreciate it when it's not there... Thanks to all the guys that had to deal with a restore without "DB2's image copies". Keep up the good work
Vriendelijke groet, Douwe van Sluis
-----Oorspronkelijk bericht----- Van: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Namens wfavero@attglobal.net Verzonden: zondag 12 augustus 2007 7:12 Aan: DB2-L@WWW.IDUGDB2-L.ORG Onderwerp: [DB2-L] [...]
669 65 42_DB2 z/OS, locks on FOR UPDATE OF revisited11_Mike Turner29_michael_turner@COMPUSERVE.COM31_Sun, 12 Aug 2007 17:13:58 +0100567_iso-8859-1 Hi list
Last time I tried to post this, DB2-L died. Hope it doesn't have the same effect this time! Seriously, thanks to everyone who worked to get the service back.
I have at last managed to run some test traces to see what lock avoidance takes place for a cursor FOR UPDATE. The tests were conducted on a DB2 V9 NFM subsystem and involved a COBOL program with a single cursor defined FOR UPDATE with a WHERE clause that caused only a subset of rows to qualify. Of these qualifying rows, COBOL conditional logic was used to ensure that [...]
735 91 30_Reorg tablespace with SQL JOIN16_Michael Liberman18_mliberman@DTCC.COM31_Mon, 13 Aug 2007 11:08:55 +0100583_US-ASCII Good morning/Afternoon,
Has anyone have tried executing an SQL JOIN statement within a REORG TABLESPACE DISCARD statement. For example:
REORG TABLESPACE dba.tsa DISCARD FROM TABLE ownerA.tableA WHEN (tableA.columnA = tableB.columnB)
Is it possible to do that ? I did not find any reference in the manuals.
TIA,
------------------------------------------------------ Michael Liberman The depository Trust and Clearing corp. Broadgate West 1 Snowden street London EC2A 2DQ ------------------------------------------------------ [...]
827 248 34_Re: Reorg tablespace with SQL JOIN37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Mon, 13 Aug 2007 12:35:42 +0200798_iso-8859-2 syntax WHEN (DB2 UDB for z/OS V8 Utility Guide and Reference, 2.23.1.1 Syntax diagram) predicate:
>>-+-basic predicate---+--------------------------------------->< +-BETWEEN predicate-+ +-IN predicate------+ +-LIKE predicate----+ '-NULL predicate----'
basic predicate:
(1) >>-column-name--+- = --+----------------------------------------> +- <> -+ +- > --+ +- < --+ +- >= -+ '- <= -'
>--+-constant--------------------+----------------------------->< '-labeled-duration-expression-'
however am on z/os
regards, dusan [...]
1076 195 36_Re: ADMIN: Known errors within DB2-l0_19_mike.holmans@BT.COM31_Mon, 13 Aug 2007 12:14:38 +0100516_us-ascii Robert, Linda, and anyone else involved,
I'm sure I speak for all of us in saying thank you for the immense efforts you have been putting in to restore this service.
Mike Holmans Lead Professional, DB2 Support BT Operate mike.holmans@bt.com
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galambos, Robert Sent: 12 August 2007 06:35 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] ADMIN: Known errors within DB2-l [...]
1272 210 25_DB2 V9.1 FP2 on Solaris 913_Jeffery Price21_jeffery.price@AES.COM31_Mon, 13 Aug 2007 11:26:16 -0000616_us-ascii Hello List!
I am curious to see if anyone has experienced any issues installing FP2 on DB2 V9.1 on Solaris. We actually have WebSphere Federation Server V9.1 and Relational Wrappers, and are planning to use the Universal FixPack Install. Any problems experienced during the install? Post-install?
Also, we are considering upgrading from Solaris 9 to Solaris 10 using Live Upgrade. Is there anything special I need to do w/ DB2? I haven't looked @ infocenter yet - just wanted to see if any of the listers had experience and could point out some 'gotchas'. [...]
1483 160 38_Re: DB2 for Windows - Restore Question10_Gyau, Paul15_PGyau@GEICO.COM31_Mon, 13 Aug 2007 10:20:55 -0400648_us-ascii
Try this:
db2 restore db SourceDB from R:\SourceDB.0\DB2\NODE0000\CATN0000\20070703 taken at 20070703230015 INTO TargetDB
Paul Gyau
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of haldur@ELEKTRON.FO Sent: Sunday, August 12, 2007 9:17 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 for Windows - Restore Question
Dear list members!
I am on DB2 for Windows 8.2.
My question is: How do I restore a full image backup to a target database with a different name? -in zOS it would be easy :D [...]
1644 254 32_Re: ADMIN DB2-L Service Restored12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Mon, 13 Aug 2007 09:21:40 -0500336_us-ascii To Robert and the team of volunteers,
We all get busy in our work and lives and don't take the time to stop and say thank you to people who make a difference.
The DB2 List is a great resource that helps thousands of people and I think we take it for granted that it will always be available. [...]
1899 41 17_How many cursors?12_Buz Williams22_buz.williams@GMAIL.COM31_Mon, 13 Aug 2007 09:24:08 -0500720_UTF-8 How many cursors can I have in one COBOL program before the preprocessor dies?
I found the DB2 limits portion of my hand dandy reference guide, but didn't find an answer.
I need to know about v 7 & v 8.
Thanks, Buz
--------------------------------------------------------------------------------- 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
1941 225 32_Re: ADMIN DB2-L Service Restored23_BOLEY Maurice C * Cliff32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 13 Aug 2007 07:54:02 -0700333_us-ascii "Prior to the move, IDUG was informed the move would cause minimal disruption "
When will we ever learn. I've been burned by that statement more than once. I guess I like the taste of crow.
Its the nature of the business.
My thanks to everyone who keeps the list up and running. Its a great asset. [...]
2167 34 32_Re: ADMIN DB2-L Service Restored0_28_Massimo.Scarpa@PHOENIXSPA.IT31_Mon, 13 Aug 2007 17:01:50 +0200274_US-ASCII May I add my 'THANK YOU ALL' to people who worked hard to let us to chat about DB2 world using DB2-L ?
Max Scarpa Certified in whatever you need (no credit card allowed)
---------------------------------------------------------------------------------
2202 69 60_DB2 LUW V8 (Z/os 1.7) vs content manager Version 2 Release 315_Chris Hoelscher21_choelscher@HUMANA.COM31_Mon, 13 Aug 2007 11:13:29 -0400669_US-ASCII Good Day we are waaaaaaaaaaaaaaaaaay behind on Content Manager (currently we are running Content Manager Version 2 Release 3 for OS/3900 - has anyone used this release successfully with Db2 V8 ? any experiences would be greatly appreciated
thanks,
Chris Hoelscher Senior IDMS & DB2 Database Administrator Humana Inc 502-476-2538 choelscher@humana.com
The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. [...]
2272 78 59_Tablespace PAGESIZE for the tablespaces in AS TEMP database15_Attuluri, Vidya27_Vidya.Attuluri@MARRIOTT.COM31_Mon, 13 Aug 2007 11:06:04 -0400411_us-ascii Hello,
Environment: DB2 V7.1 for z/OS 1.8
For V8, the pagesize for the tablespaces defined in the database defined as AS TEMP (where Declared Temporary tables resides) should be atleast 8K?
Currently we have defined as 4K in V7 and that is large enough for our tables. So, for going to V8, what is the optimal size we can change it to from performance perspective? 8K or 32K? [...]
2351 302 32_Re: ADMIN DB2-L Service Restored12_Hepp Shery C21_Shery.Hepp@SRPNET.COM31_Mon, 13 Aug 2007 08:24:37 -0700545_us-ascii It's the same as saying the change will be 'transparent to the user'!
Glad to see this valuable resource is back up! Thanks to the many volunteers that assist in providing this list serve.
Regards, Shery
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of BOLEY Maurice C * Cliff Sent: Monday, August 13, 2007 7:54 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] ADMIN DB2-L Service Restored [...]
2654 33 11_Data Access13_Malik, Munwar31_munwar.malik@ASSOCIATES.DHS.GOV31_Mon, 13 Aug 2007 12:06:30 -0400339_US-ASCII Hello List:
I need to access data both on the P and Z platform. The program is going to be run on Z getting some data from p and some data some Z. The connevtivity between Z to P is already established via SYSIBM.LOCATIONS SYSIBM.IPNAMES SYSIBM.USERNAMES
I have also established connectivity between P to Z via [...]
2688 209 18_ADMIN: DB-l Update16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 13 Aug 2007 13:53:39 -0400439_iso-8859-1 List
Right now, the web interface is back up. It 'should be working' as it has in the past. HOWEVER we are not out of the woods yet. We are still working out some minor kinks.
You should also see that we have upgraded (not much of a choice mind you) to the latest version of the listserv software. The reason I am mentioning this, if you notice the change in the look/fee of the web interface this is normal. [...]
2898 143 79_[z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery0_26_MarkVickers@GROCERYBIZ.COM31_Mon, 13 Aug 2007 13:33:42 -0500561_US-ASCII Hi Folks, Long story short: Resized active logs and made them too big for the archive pri/sec qty's, so tried to downsize and then ran into all kinds of problems. Then it got worse and we lost the last 3 archive logs - both copies - (don't ask!). So we dropped the archive logs from the BSDS, did a conditional restart and truncated the logs. Then recovered the catalog to that same pit (last archive log available). The subsystem comes up OK and I ran DSN1COPY, DSN1CHKR and CHECK INDEX where applicable and all catalog objects checked out fine. [...]
3042 63 63_Re: Tablespace PAGESIZE for the tablespaces in AS TEMP database14_Kate Kavanaugh34_katherine_kavanaugh@MASTERCARD.COM31_Mon, 13 Aug 2007 14:39:50 -0400366_windows-1252 The Application Programming and SQL Guide states: There must be at least one table space with a 8-KB page size in the TEMP database to declare a temporary table.
So, you may keep your 4K tablespaces, but you will have to add one 8K tablespace to the Temp Database for Declared Temporary tables. DB2 will decide which tablespace size to use. [...]
3106 34 38_DB2 zOS v8 Compression Memory question14_Ramon Santiago28_ramon_santiago@SBCGLOBAL.NET31_Mon, 13 Aug 2007 11:50:34 -0700333_iso-8859-1 I am trying to understand some what how compression/decompression work. At this point, more so software compression.
From what I understand, the rows are compressed and then stored in a page within the bufferpool and then written to DASD. In some cases some of the rows may be stored in the page uncompressed. [...]
3141 188 13_ADMIN: update16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 13 Aug 2007 15:22:57 -0400409_iso-8859-1 In trying to provide updated information concerning the ongoing status of the DB2-L listserv,
The Archive function is not functioning properly. While some may be able to see the entries, the actual posting are not accessible at this time.
We are working on this and should have some updates shortly.
.
Robert Galambos CIPP/C [...]
3330 101 83_Re: [z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 13 Aug 2007 14:51:32 -0500503_windows-1250 Time to study REPAIR LEVELID - It isn't good to try to fool DB2. Treat it like a Disaster recover - sequence is important. check the admin guide for the correct sequence.
Mike
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of MarkVickers@GROCERYBIZ.COM Sent: Monday, August 13, 2007 1:34 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] [z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery [...]
3432 169 75_ADMIN: We need to bring up and down the listserv for about 20 to 30 minutes16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 13 Aug 2007 16:20:19 -0400500_iso-8859-1 I will send out another post as soon as we are stable again. This also included the web interface.
this is to fix the issue with the archive
thank you for your co-operation
Robert Galambos CIPP/C
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 Database Administration robert.galambos@compuware.com
Tel: +1 905 886 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 [...]
3602 170 14_ibm infocenter12_Hepp Shery C21_Shery.Hepp@SRPNET.COM31_Mon, 13 Aug 2007 13:26:55 -0700408_us-ascii
Is it just me- or does the 'new' IBM info center give you so much information for every version possible of DB2 that you can't easily find what you're looking for?
Sorry to vent- but since they changed things I can't seem to ever find what I'm looking for- or if I do it seems to take forever to go through what I don't want to find what I'm looking for. [...]
3773 201 40_ADMIN: ARCHIVE/fully functional listserv16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Mon, 13 Aug 2007 17:08:43 -0400331_iso-8859-1 I am happy to report that the archive function is up and ruining properly
With this , we now have a complete functioning Listserv service with all of its functions running correctly
So please let me know if you experience any issues going forward. I should not expect there will be any though [...]
3975 54 38_Re: DB2 for Windows - Restore Question12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 13 Aug 2007 14:11:12 -0700436_iso-8859-1 > > ________________________________ > > From: DB2 Data Base Discussion List on behalf of > haldur@ELEKTRON.FO > Sent: Sun 8/12/2007 9:16 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] DB2 for Windows - Restore Question > > > > Dear list members! > > I am on DB2 for Windows 8.2. > > My question is: > How do I restore a full image backup to a target > database with a different name? -in zOS it would be > easy :D [...]
4030 76 18_Re: ibm infocenter21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Mon, 13 Aug 2007 17:11:38 -0400532_iso-8859-1 You can limit your search to just on release. That will reduce the items returned to just the release you are interested in.
Willie
Original Message: ----------------- From: Hepp Shery C Shery.Hepp@SRPNET.COM Date: Mon, 13 Aug 2007 13:26:55 -0700 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] ibm infocenter
Is it just me- or does the 'new' IBM info center give you so much information for every version possible of DB2 that you can't easily find what you're looking for? [...]
4107 117 18_Re: ibm infocenter21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Mon, 13 Aug 2007 17:25:02 -0400444_iso-8859-1 This time without the typos...
You can limit your search to just one release. That will reduce the items returned to just the release you are interested in.
Right next to the search box is the phrase "search scope"... click on that then when hte box pops up, turn on the radial for "Search only the following topics" and click the baox "New". The click the boxes for what you want to search.. and click OK [...]
4225 59 44_DSNUTILS on z/OS db2 v8 - truncate emulation0_30_Bruce.Lightsey@ITS.STATE.MS.US31_Mon, 13 Aug 2007 16:39:37 -0500437_US-ASCII since I can't get to the archives yet ----
__________________
is it possible to call DSNUTILS from another ( Cobol ) stored procedure to allow for the emulation of the truncate table command ( available in V9 and O***) ? I have a new project where some very large work tables need to be cleared before use, none of the users will have TSO access, and there is no predictibility as to the timing or frequency. [...]
4285 37 18_Re: ibm infocenter14_Michael Wendel19_mawendel@US.IBM.COM31_Mon, 13 Aug 2007 17:53:15 -0400391_ISO-8859-1 Shery makes a good point, there is a lot of stuff to pick through when you are not doing a search.
To address this, we just implemented a filtering option for the Contents tree, so you can filter by Product and Version.
I'm attaching a screen shot of the contents filtering only DB2 Version 9. Hopefully this will make it easier to find the info that you need. [...]
4323 125 83_Re: [z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery0_24_carol.sutfin@REGIONS.COM31_Mon, 13 Aug 2007 17:09:19 -0500475_us-ascii Mark,
I haven't seen anyone else answer, so I will take a try.
There are a couple of things to check. 1. Look at your System Log to see if there were any SMS messages displayed. Sometimes these give you a clue as to what is wrong. 2. Check the STOGROUP for VOLSER's that don't exist or not * (asterisks) (SYSVOLUMES by SGNAME) 3. Check the VCATNAME against the ICF catalog to make sure something (or someone) has not changed (SYSSTOGROUP by NAME) [...]
4449 359 83_Re: [z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery0_26_MarkVickers@GROCERYBIZ.COM31_Mon, 13 Aug 2007 19:04:44 -0500554_US-ASCII Thanks Mike, DB2 fooled me - I was trying to save the subsystem from myself :-)
My problem on the 00D70001 was in SMS which we have resolved, finally. Thanks for the note on REPAIR LEVELID. I since found a few tables I thought would not have been updated which I repaired, but some are still inconsistent. If interested, I found them by copying EVERYTHING - have to read every page ! Busy fixing those with recovers now and since I have already truncated the log, I can do a recover to current. I may actually get some sleep tonight [...]
4809 190 37_DB2 for Windows Vista (compatibility)12_Cianci, Nick19_nick.cianci@EDS.COM31_Tue, 14 Aug 2007 12:03:39 +1000626_iso-8859-1 Dear ListServ,
essentially we are looking at the versions of DB2-Connect supported under Windows Vista; but the question could just as easily extend to the version of ESE (Enterprise Server Edition) as well.
Essentially our end goal is to establish an ODBC connection through DB2-Connect to DB2 on z\OS.
Now the literature says that DB2 v9.1 FP2 is Windows Vista compliant; but there is nothing that I can find that says v8 isn't. However I've installed v8.1 and applied the most recent fix-pack I can find (FP14). After this I can go in through CCA (Configuration Assistant) & define the [...]
5000 433 83_Re: [z/OS v7] 00D70001 unavailable resource on storage group after catalog recovery0_26_MarkVickers@GROCERYBIZ.COM31_Mon, 13 Aug 2007 21:39:25 -0500376_US-ASCII Thanks Carol, that was exactly what it was - a missing HLQ from the SMS rules which resulted in a NOT "*" for non SMS managed define error. Ciao, Mark.
carol.sutfin@REGIONS.COM Sent by: DB2 Data Base Discussion List 08/13/2007 05:09 PM Please respond to DB2 Database Discussion list at IDUG [...]
5434 29 53_Using Object Maintenance Policies from Control Center13_Tony Anzalone28_tony.anzalone@SUNCORP.COM.AU31_Mon, 13 Aug 2007 23:59:22 -0400322_windows-1252 Hi, We are currently experimenting with using object maintenance policies from Control Center. I am looking for a good "real world" reference/resource on the topic. I have not been able to find an appropriate Redbook. Could anyone suggest a good resource or like to share their experiences in this area? [...]
5464 70 38_Re: DB2 for Windows - Restore Question13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM31_Mon, 13 Aug 2007 23:42:45 -0700508_ISO-8859-1 On 8/13/07, tim malamphy wrote: > > > > ________________________________ > > > > From: DB2 Data Base Discussion List on behalf of > > haldur@ELEKTRON.FO > > Sent: Sun 8/12/2007 9:16 AM > > To: DB2-L@WWW.IDUGDB2-L.ORG > > Subject: [DB2-L] DB2 for Windows - Restore Question > > > > > > > > Dear list members! > > > > I am on DB2 for Windows 8.2. > > > > My question is: > > How do I restore a full image backup to a target > > database with a different name? -in zOS it [...]
5535 277 42_Re: DB2 zOS v8 Compression Memory question14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 14 Aug 2007 09:24:50 +0100575_us-ascii Hi Ramon
You don't specify, but I assume we're talking DB2 for z/OS
Let's follow the life of a row
A new row is "born" in an application which issues an INSERT statement to add it to a table in a compressed tablespace. Before the row is actually added to the page, DB2 uses the compression dictionary to see if the row compresses smaller than it's original length (yes, it IS possible for a compressed row to be bigger than its uncompressed version!). If the compressed row IS smaller, then the smaller version is placed in the DB2 page in [...]
5813 142 45_Dates for your diary - CA at IDUG Europe 200714_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 14 Aug 2007 09:31:36 +0100337_us-ascii Hi all,
If you are a customer of any of the CA DB2 tools and are considering attending European IDUG in Athens in November, please take a moment to look at www.ca.com/emea/idug2007 which summarises CAs activities at the conference as well as containing details of the pre-IDUG CA DB2 User Day on Sunday November 4th [...]
5956 243 38_Re: DB2 for Windows - Restore Question0_18_haldur@ELEKTRON.FO31_Tue, 14 Aug 2007 10:14:06 +0100681_US-ASCII Hi!
Thank you for the answers.
But I still have problems and this is what I have tried:
1. (first method using into): C:\>set db2instance=Target
C:\>db2 create db TargetDB DB20000I The CREATE DATABASE command completed successfully.
C:\>db2 restore db SourceDB from c: taken at 20070703230015 into TargetDB SQL2523W Warning! Restoring to an existing database that is different from the database on the backup image, but have matching names. The target database will be overwritten by the backup version. The Roll-forward recovery logs associate d with the target database will be deleted. Do you want to continue ? (y/n) y DB20000I [...]
6200 62 26_db2sysc process in DB2 LUW12_John Lendman27_lendman@PALMBEACH.K12.FL.US31_Tue, 14 Aug 2007 07:44:07 -0400434_us-ascii Why would I see this db2sysc process running from database a on database b?
Is there some type of remote access that would cause this db2 thread to run on the other database? If so do you know what it might be?
Thanks
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator IBM Certified Specialist Office 561-357-7523 Cell 561-644-5708 Email lendman@palmbeach.k12.fl.us [...]
6263 32 63_Re: Tablespace PAGESIZE for the tablespaces in AS TEMP database0_25_jacampbell@ACSLINK.NET.AU31_Tue, 14 Aug 2007 22:29:16 +1000337_US-ASCII As Kate said, depends on what works for you - what is the row width of your temporary tables going to be? I think the reason V8 requires an 8K pagesize is related to the 8K catalog and directory tablespaces rather than application usage. Or maybe they just liked the look of "8" in both the version number and pagesize 8-) [...]
6296 71 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation0_25_jacampbell@ACSLINK.NET.AU31_Tue, 14 Aug 2007 22:29:17 +1000303_US-ASCII You have actually run the definition job for SYSPROC.DSNUTILS, haven't you? That is, you can call it directly from, for example, Development Center on an LUW system - yes? (And set up the JCL as per the manual etc; but if you haven't defined it, then this is simply the next toe-stubber.) [...]
6368 95 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 14 Aug 2007 09:04:12 -0400392_us-ascii I hope nobody accidentally puts another table in the same tablespace as these work tables or they'll be blown away with the load. I suppose you've already ruled out putting your work tables in segmented tablespace? Mass deletes won't be logged.
Scott Hodgin Database Administrator, (MCITP-SQL Server 2005) South Carolina Farm Bureau Insurance Company shodgin@scfbins.com [...]
6464 94 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 14 Aug 2007 09:04:37 -0400598_us-ascii Hi Bruce.
Would a Rexx example help? I have one posted at the IBM DB2 trading post Examples site. http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg27005764
It calls Runstats, but would be easily modified to call Load.
Dave
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]
6559 361 38_Re: DB2 for Windows - Restore Question11_Davies, Ian31_Ian.Davies@CGI.HEALTH.GOV.AB.CA31_Tue, 14 Aug 2007 07:37:48 -0600530_us-ascii Hi Haldur,
Sounds like you are restoring from an online backup. In that case you will also need the log files from the start of the backup to the minimum recovery point.
Look at "overflow log path" on the rollforward command.
Cheers, Ian.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of haldur@ELEKTRON.FO Sent: August 14, 2007 03:14 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 for Windows - Restore Question [...]
6921 101 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 14 Aug 2007 14:50:55 +0100374_us-ascii Answering "the question before last" - does a mass delete of these tables (assuming they are in a segmented tablespace) not run fast enough?
I'm just wondering why you want to emulate TRUNCATE
Phil Grainger CA Product Management Director Phone: +44 (0)161 929 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 eMail: phil.grainger@ca.com [...]
7023 270 38_Re: DB2 for Windows - Restore Question12_John Lendman27_lendman@PALMBEACH.K12.FL.US31_Tue, 14 Aug 2007 09:52:22 -0400597_us-ascii If this is a offline backup , just add 'without rolling forward' to the end of your restore. That should work.
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator IBM Certified Specialist Office 561-357-7523 Cell 561-644-5708 Email lendman@palmbeach.k12.fl.us
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Davies, Ian Sent: Tuesday, August 14, 2007 9:38 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 for Windows - Restore Question [...]
7294 83 48_St. Louis MO DB2 Users Group Meeting - Sept 11th10_Tom Glaser14_tg5444@ATT.COM31_Tue, 14 Aug 2007 10:04:08 -0400318_windows-1252 The next general meeting of the St. Louis DB2 Users Group will be on Tuesday, Sept. 11, 2007. The meeting will be held at Maritz, 1355 N Highway Drive, in Fenton Mo.
Please send your reservation to the email address of stldug@idug.org so that an accurate count of attendees can be determined. [...]
7378 124 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation0_30_Bruce.Lightsey@ITS.STATE.MS.US31_Tue, 14 Aug 2007 09:22:21 -0500409_US-ASCII indeed - it is defined in the SDSNSAMP job DSNTIJSG and appears to be in place
PROC_NAME WLM_ENV PARM_COUNT LANGUAGE ---------+---------+---------+---------+---------+---------+ DSNUTILS DB8TUTIL 41 ASSEMBLE DSNE610I NUMBER OF ROWS DISPLAYED IS 1 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
guess I'll go back through my cobol and re-check the variable definitions [...]
7503 143 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation0_30_Bruce.Lightsey@ITS.STATE.MS.US31_Tue, 14 Aug 2007 09:25:04 -0500494_US-ASCII nope - it is pretty slow and fills up the logs too often. Several million records and a cpu-constrained lpar..........
"Grainger, Phil" To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List Re: [DB2-L] DSNUTILS on z/OS db2 v8 - truncate emulation
08/14/2007 08:50 AM
Please respond to DB2 Database Discussion list at IDUG [...]
7647 154 39_z/OS DB2v8 NFM ptf UK17189 apar PK2676017_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Tue, 14 Aug 2007 11:50:55 -0400330_us-ascii We are in the process of upgrading our DB2v8 subsystems from maintenance level RSU0610 to RSU0704. That will add about 6 months' PTFs to our DB2 software. It also gives us the opportunity to read through many thousands of lines of HOLDDATA looking for significant items. The following caught my eye for PTF UK17189. [...]
7802 214 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 14 Aug 2007 17:09:10 +0100302_us-ascii OK, so there is something else you are not telling us
If a mass delete in a segmented tablespace is causing lots of logging and cpu, then I assume you have triggers or RI (or both)?
Or you have Data Capture Changes, which you could turn off (and on again) around the delete [...]
8017 131 45_DB2 for z/OS V8 - Sequence Object cache lost?11_Mike Jessen22_jessenmike@HOTMAIL.COM31_Tue, 14 Aug 2007 11:34:24 -0500627_iso-8859-1
Can someone clarify how/when cached sequence values are lost. According to the manual, this could happen when there is a system failure, but that is not the case.
IBM manual: CACHE integer-constant Specifies the maximum number of values of the sequence that DB2 can preallocate and keep in memory. Preallocating values in the cache reduces synchronous I/O when values are generated for the sequence. The actual number of values that DB2 caches is always the lesser of the number in effect for the CACHE option and the number of remaining values within the logical range. Thus, the CACHE value is [...]
8149 162 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Tue, 14 Aug 2007 12:14:36 -0400404_us-ascii Maybe a simple solution would be best. Setup a load job for them to use or have run whenever they need it...Phil
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bruce.Lightsey@ITS.STATE.MS.US Sent: Tuesday, August 14, 2007 10:25 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DSNUTILS on z/OS db2 v8 - truncate emulation [...]
8312 89 42_Re: DB2 zOS v8 Compression Memory question14_Ramon Santiago28_ramon_santiago@SBCGLOBAL.NET31_Tue, 14 Aug 2007 11:11:27 -0700616_iso-8859-1 Thanks as suspected, it is part of the thread. Thanks for the breakdown.
"Grainger, Phil" wrote: Hi Ramon
You don't specify, but I assume we're talking DB2 for z/OS
Let's follow the life of a row
A new row is "born" in an application which issues an INSERT statement to add it to a table in a compressed tablespace. Before the row is actually added to the page, DB2 uses the compression dictionary to see if the row compresses smaller than it's original length (yes, it IS possible for a compressed row to be bigger than its uncompressed version!). [...]
8402 219 48_Re: DSNUTILS on z/OS db2 v8 - truncate emulation0_30_Bruce.Lightsey@ITS.STATE.MS.US31_Tue, 14 Aug 2007 13:27:14 -0500607_US-ASCII did that and their application dba has run it successfully - but the uesr(s) they want to do this have no direct mainframe access and the dba would rather not be called at 3am or Sundays or .....at all, for something like this when an automated process running off in the *x world should be able to see that "this batch of data is completely scrubbed and the appropriate master tables are populated - now empty the work tables so the next batch can get under way". This is a data-scrubbing/standardization/fuzzy-match/best-guess/just-freakin-magic app that will chew up much data from various [...]
8622 29 25_DB2 V7 ZOS INDEX DSN1COPY8_wtrovijo19_wtrovijo@UOL.COM.BR31_Tue, 14 Aug 2007 16:48:11 -0300605_iso-8859-1 Hi All,
I've been testing DSN1COPY to copy indexes and in some cases it in 00C90101 DSNKTRAV 2008. We use DSN1COPY for a while and just get 00C90101 for some tablespaces that have been changed and not reorganized. Is that true for indexspaces too? Should I reorg those indexes in source subsystem? Or is rebuild on target the only way to go? We need to get rid of rebuilds because we're processor constrained in the target (development) environment and last complete dsn1copy+rebuild took 50 hours to run. By the way, I'm copying vsam to vsam and the source tablespaces/indexes are [...]
8652 126 24_Data Sharing active logs13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 14 Aug 2007 13:04:53 -0700449_us-ascii Hello, listers. I'd like to ask people in data sharing shops about their active logs.
1) When you implemented data sharing, did you size each new member's active logs to be the same size as the originating member, or make them smaller? 2) Did you size them by the activity of the member, or make all of them the same as each other? 3) Did you do it one way in test and another way in production, or use the same method in both? [...]
8779 92 28_Re: Data Sharing active logs14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 14 Aug 2007 16:53:49 -0400442_windows-1252 Cathy DB2 Data Sharing offers major advantages in at least two areas 1. Capacity 2. Availability
Should the first case be true for a converting shop (desire for increased capacity) the shop would frequently be experiencing increased demand (hence the need for capacity). In such a case an increase in the total space available to active logs (and archives if done to DASD) should go hand in hand with the deployment. [...]
8872 117 28_Re: Data Sharing active logs13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 14 Aug 2007 14:03:49 -0700432_us-ascii Thanks, Avram. We are converting for availability. I can't see how data sharing is going to decrease availability in any way. Of course all active logs will be on spinning DASD, that is a requirement. I would like to know how people converting to data sharing have sized their active logs. The assumption is that DB2 activity on the day after conversion is going to be pretty darn close to activity on the day before. [...]
8990 67 18_Re: ibm infocenter12_Hepp Shery C21_Shery.Hepp@SRPNET.COM31_Tue, 14 Aug 2007 14:27:15 -0700341_us-ascii Michael thank you for the link- I was able to set up see where I can specify search scope to limit to only v8 docs. I must have had an old link saved in my favorites.
Willie- thanks for pointing out the search scope- which wasn't on my saved link-
I'm a much happier dba with being able to get to the doc I need. [...]
9058 207 28_Re: Data Sharing active logs0_22_TILKESR@NATIONWIDE.COM31_Tue, 14 Aug 2007 16:39:06 -0500375_US-ASCII Cathy,
I have to agree with other responses. Overall I believe it depends. We completed implementing DB2 Data Sharing in our development environment in APR 2007 and I am in a holding patterning pending a FIX from IBM PK33340 to implement into production (DB2 v.8 NFM). We replicated the active logs in the new member to same size as the existing member. [...]
9266 164 45_DB2 Peculiar Behavior - Need Some Expert Help15_Paulsen Bryan M27_PaulsenBryanM@JOHNDEERE.COM31_Tue, 14 Aug 2007 17:13:50 -0500608_iso-8859-1
Now that I have your attention... If I really did need some help, many subscribers would have rushed to share their experience and suggestions with me as they always do. Several of your colleagues attending the IDUG 2008 North America conference do need your help. Why not share your experience with them at IDUG? Your conference registration fee is waived and you get the recognition you deserve. All you have to do is submit your abstract with a short paragraph on your presentation idea and five bullet points. IDUG 2008 North America Call for Presentations is open now through 04 [...]
9431 44 27_PRIQTY = -1 and SECQTY = -112_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 14 Aug 2007 15:31:19 -0700358_iso-8859-1 I understand that having both priqty and secqty = -1 invokes the dynamic sliding scale allocation factors for dataset allocation.
But what I'm seeing is a wierd allocation factor which has nothing to do with increasing allocations. According to the manual, it's basically a doubling factor, going from 1, 2, 4, 8, 16,32, 64 until 127. [...]
9476 370 28_Re: Data Sharing active logs13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 14 Aug 2007 15:33:56 -0700702_us-ascii Thanks, Bob. I'll take you up on that offer. Cathy
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of TILKESR@NATIONWIDE.COM Sent: Tuesday, August 14, 2007 2:39 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: Data Sharing active logs
Cathy,
I have to agree with other responses. Overall I believe it depends. We completed implementing DB2 Data Sharing in our development environment in APR 2007 and I am in a holding patterning pending a FIX from IBM PK33340 to implement into production (DB2 v.8 NFM). We replicated the active logs in the new member to same size as the existing member. [...]
9847 113 28_Re: Data Sharing active logs14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Tue, 14 Aug 2007 20:01:26 -0400641_windows-1252 Hi Cathy, I have inserted my comments within the body of your note.
On Tue, 14 Aug 2007 14:03:49 -0700, Taddei, Cathy wrote:
>Thanks, Avram. We are converting for availability. I can't see how >data sharing is going to decrease availability in any way.
Datasharing is diffrent from single subsystem environments. Some of the diffrences are : Cross system locks Table space recovery may require logs / archives from several members A unit of work cqan run on several DB2s (sysplex parallism) Finding a record of a UOW can be tricky, as a user may connect to one of [...]
9961 90 49_Re: DB2 for z/OS V8 - Sequence Object cache lost?11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 14 Aug 2007 22:49:29 -0500334_- Mike,
(1) Is it posisble that the sequence is used by other processes? Obtaining the value will use it up whether or not the row was inserted. Even a "harmless" SPUFI query will use it up.
(2) Are you Data Sharing - each member gets its own cache of 20 and perhaps the transaction is scheduled on another member? [...]