1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l October 2009, week 3
2 39 31_OSC stats are suddenly all zero12_Roy Reynolds17_royr@BERKELEY.EDU31_Thu, 15 Oct 2009 01:23:23 +0000547_UTF-8 Running z/OS (1.9) DB2 V8 NFM and OSC 1.1 fp6. I was using this until about a month ago to list all the dynamic SQL and rank it by the number of getpages. I used this to infer the high impact SQL running in my z/OS subsystem. I installed this OSC version / fixpack in March 2009 and used it successfully for several months. Suddenly all the stats are zero all the time though the SQL statements still appear. The timestamp columns are accurate but the metrics are now zeros, making ranking of an SQL statement impossible. Any ideas why [...]
42 354 46_Re: DB2 V9 z/OS - how to get rid of claimers ?28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Thu, 15 Oct 2009 10:18:52 +0530337_US-ASCII Thank you. I also read from the DB2 command manuals that START ACC(UT) takes effect after completion of applications that already started when the command was issued. Yes, STOP and then a START with ACC(UT) would place the TS in STOPP until the UOW is done.
Thanks once again. I got what I was looking for ! [...]
397 142 35_Re: OSC stats are suddenly all zero11_Dirk Johann20_dirkjohann@GMAIL.COM31_Thu, 15 Oct 2009 08:18:00 +0200579_ISO-8859-1 Roy,
the stats are actually gathered from the Dynamic Statement Cache (DSC) from OSC. Stats are only filled, if statistics trace with IFCIDs 316, 317 and 318 are started at the time the statements are executed.
Maybe before those IFCID traces had been started for monitoring purposes, e.g., monitors like Omegamon are using this information as well. Please check if any traces are running on your system(s). If not, you can easily start them with the -START TRACE command and you will get all statistics plus complete statement text in full length. [...]
540 66 35_Re: OSC stats are suddenly all zero6_Leslie21_db2dba@BTINTERNET.COM31_Thu, 15 Oct 2009 09:12:20 +0100462_us-ascii Hi Roy I expect somebody has messing with the traces on the z/Os side. Have they upgrade from PE to XE recently? Get them to switch on IFCID 318, which will fire 316/317 pairs. This will then give you what you need. Leslie
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roy Reynolds Sent: 15 October 2009 02:23 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] OSC stats are suddenly all zero [...]
607 99 28_Re: Plan Management Question11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 15 Oct 2009 11:10:01 +0200563_iso-8859-1 Hi List!
A bit late but hey it *was* my birthday after all!! But back to the point...this topic came up a lot at the IDUG in Rome last week and also in connection with normal DB2 maintenance (APARs, PTFs and REBINDS after DB2 database maintenance REORGs, RUNSTATS etc.) and not just DB2 release migration checks. We also looked and looked and looked and could find no way of cross referencing to the current used access path. It is only stored in the SPT01 and that, as you all know, is a directory tablespace....so what what did we do? We [...]
707 113 65_[AD] NEODBUG Quarterly Meeting TH 11/19 in Independence, Ohio USA11_James Szabo24_jim.szabo@ROADRUNNER.COM31_Thu, 15 Oct 2009 08:38:20 -0400535_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) will hold their quarterly meeting on Thursday November 19, 2009 at the Skyline Hotel and Conference Center in Independence, Ohio USA. www.skylinehotelindependence.com
Our first speaker is Paul Wirth of IBM Corporation, whose topic is "Exploring IBM Downloadable No-charge Features for Databases".
Our second speaker is Robert Andresen of Computer Associates, whose topics are "Using Native SQL Procedures" and "Excelling at DB2 Monitoring and Reporting". [...]
821 255 35_Re: OSC stats are suddenly all zero13_Palko, George16_gpalko@OPERS.ORG31_Thu, 15 Oct 2009 13:39:36 +0100515_us-ascii Hi Roy,
I think you can also activate the traces within the product by clicking on the (start collecting dyn. Trace) icon at the bottom of the SQL statements window. When the "stop collecting" icon is pressed, you will no longer get dyn. Stat info.
Regards, George
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dirk Johann Sent: Thursday, October 15, 2009 2:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OSC stats are suddenly all zero [...]
1077 229 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Thu, 15 Oct 2009 11:40:48 -0500547_us-ascii Yes,
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Wednesday, October 14, 2009 3:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics
Is CICS version (2.3) correct in your message ?
Max Scarpa ________________________________
[cid:~WRD000.jpg]
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. [...]
1307 60 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Thu, 15 Oct 2009 11:44:19 -0500554_utf-8 Our cics guy is working with ibm now....looking at all db2conn,db2entry and db2tran. Did not change anything for release commit/deallocate. Did change apps to be current data - no and isolation cs. Everything has been rebound. We have z\os 1.9 and zip/zap processing available.
Thanks for comments. diana
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tony Saul Sent: Wednesday, October 14, 2009 3:39 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics [...]
1368 451 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Thu, 15 Oct 2009 11:46:49 -0500366_us-ascii Yes....our cpu was running 100% for the test
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ted MacNEIL Sent: Tuesday, October 13, 2009 3:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics
LU6.2 -- a change in the MCT? Did CPU go up as well?
- Too busy driving to stop for gas! [...]
1820 192 26_Re: db2 9 install and cics11_Diana Nagel16_dknagel@BEPC.COM31_Thu, 15 Oct 2009 12:13:28 -0500602_us-ascii Correction it is 3.2
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Wednesday, October 14, 2009 3:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2 9 install and cics
Is CICS version (2.3) correct in your message ?
Max Scarpa ________________________________
[http://www.idug.org/images/M_images/idug%20forums3.jpg]
The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. [...]
2013 43 24_SQL Sever to DB2 z/OS v816_Natalie Faulkner25_natalie.w.faulkner@WV.GOV31_Thu, 15 Oct 2009 18:38:36 +0000318_utf-8 I have a DBA group attempting to access DB2 for z/os V8 nfm via SQL Server 2008 and Visual Studio 2008.
They need to accomplish two objectives….
1) Call a stored procedure via a Linked Server They currently have to place the DB2 stored procedure call within a SQL Server stored procedure… [...]
2057 61 21_Long-running INSERT ?14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Thu, 15 Oct 2009 14:51:03 -0400439_us-ascii Esteemed List,
I'm puzzled. We're DB2z V8 NFM, 6-way data sharing. I have a distributed transaction connecting through RRSAF attempting to execute an INSERT statement:
INSERT INTO () VALUES ()
The originating transaction sets a timer at the beginning of the request to measure response time. Recently we have seen response times in the neighborhood of 5 seconds. [...]
2119 128 28_Re: SQL Sever to DB2 z/OS v810_Mark Stone17_mastone@GMAIL.COM31_Thu, 15 Oct 2009 11:52:32 -0700552_windows-1252 I had to install DBConnect on my SQL Server to achieve a connection to DB2 from SSIS, DTS, etc.
On Thu, Oct 15, 2009 at 11:38 AM, Natalie Faulkner < natalie.w.faulkner@wv.gov> wrote:
> I have a DBA group attempting to access DB2 for z/os V8 nfm via SQL > Server 2008 and Visual Studio 2008. > > They need to accomplish two objectives. > > 1) Call a stored procedure via a Linked Server > They currently have to place the DB2 stored procedure call > within a > SQL Server stored procedure > > 2) IMPORT into SQL Server [...]
2248 69 25_Re: Long-running INSERT ?15_Kalena, Michael27_Michael.Kalena@JPMORGAN.COM31_Thu, 15 Oct 2009 15:18:34 -0400578_us-ascii Are there any Triggers?
Michael Kalena 973-793-2133 Michael.Kalena@jpmorgan.com
DB2 Info Page at hBSC (http://whsysops1.is.bear.com/db2/)
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood Sent: Thursday, October 15, 2009 2:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Long-running INSERT ?
Esteemed List,
I'm puzzled. We're DB2z V8 NFM, 6-way data sharing. I have a distributed transaction connecting through RRSAF attempting to execute an INSERT statement: [...]
2318 24 18_DB2 and volcount=27_Glen R.27_glen.richeson@CAREFIRST.COM31_Thu, 15 Oct 2009 19:16:01 +0000620_utf-8 Has anyone set DB2 system databases(datasets) with volcount=2 in SMS. So the datset can expand to more that one volume.
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings, Webcasts, Conferences- what is going on next? RUG leaders- get your events on the calendar today! _____________________________________________________________________ [...]
2343 108 25_Re: Long-running INSERT ?14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Thu, 15 Oct 2009 16:06:47 -0400367_us-ascii Nope, no triggers.
Also (as a colleague pointed out to me) there exists an Identity Column on the table defined as follows:
I_TR_SEQ INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, NO CYCLE, NO ORDER, MAXVALUE 2147483647, MINVALUE 1)
Possible culprits for the 5-second delay are (so far): [...]
2452 70 25_Re: Long-running INSERT ?13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Thu, 15 Oct 2009 15:06:52 -0500444_us-ascii Migrated dataset?
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood Sent: Thursday, October 15, 2009 1:51 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Long-running INSERT ?
Esteemed List,
I'm puzzled. We're DB2z V8 NFM, 6-way data sharing. I have a distributed transaction connecting through RRSAF attempting to execute an INSERT statement: [...]
2523 66 28_Need Ventyx Passport DB2 DBA11_Robin Marsh21_robin.marsh@GMAIL.COM31_Thu, 15 Oct 2009 20:04:49 +0000657_utf-8 Palladian Consulting, a leader in IT Services is seeking a Ventyx / Indus Passport Database Administrator for a contract opportunity in Long Island, NY.
Length of contract: 18 months
Start Date: Nov 19, 2009
Candidate must have the following experiences:
1. Minimum 5 years experience with large scale integrated systems and DB2 database administration. 2.The candidate must have in-depth knowledge of the Ventyx EAM named “Passport” (Versions 9 and 10), “Asset Suite” (Version 6) and its proprietary installation methodology. 3. Must have knowledge of CICS, VSAM, Unix systems services, SQL, QMF and Platinum [...]
2590 120 25_Re: Long-running INSERT ?13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 15 Oct 2009 15:35:19 -0500575_us-ascii We occasionally see very bad insert performance with some apps that perform a high volume of inserts if we start to run low on free space. This would be for non-segmented tablespaces (either simple or partitioned). If you look at the insert algorithm, one of the steps before the object is extended is an exhaustive search of all of the spacemap pages which can take quite awhile. If you are normally seeing good performance but then sporadically seeing spikes on some inserts, this may be the culprit. Do you see a high number of getpages on the slow inserts? [...]
2711 105 27_Re: Stored Procedure Limits10_Todd Burch17_toddburch@MAC.COM31_Thu, 15 Oct 2009 15:49:08 -0500475_US-ASCII Dean,
I did some research last night, and it appears we don't document the max limit for user parms in a stored procedure. I'm now on a mission to get that changed, or at least get a statement that helps to clear it up.
The actual count of parms built can be (will be) different from what you code as a user - but by how much it changes will vary depending on what type of parm format you use and what options you specify on the CREATE PROCEDURE. [...]
2817 239 25_Re: Long-running INSERT ?15_Chris Hoelscher21_choelscher@HUMANA.COM31_Thu, 15 Oct 2009 18:59:46 -0400850_US-ASCII we ran into a similar (but more extreme) problem - as it turns out - we had the fix staged into test - the fix is now in production:
PROBLEM DESCRIPTION(S): PK85539 - **************************************************************** * USERS AFFECTED: ALL DB2 for z/OS non-segmented table space * * users with PK76544/UK45207/UK45208 applied. * **************************************************************** * PROBLEM DESCRIPTION: INSERT LOOP FOR NONSEGMENTED * * TABLESPACE WITH PK76544 APPLIED * **************************************************************** * RECOMMENDATION: * **************************************************************** When formatting a new space map page during insert and if this new space map page could cause physical extend, the space search algorithm triggers exhaustive search before physical [...]
3057 341 25_Re: Long-running INSERT ?35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 15 Oct 2009 19:19:04 -0400465_iso-8859-1 Did you ever get the accounting report for the transaction?
Joel
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
3399 112 12_EMC V-Max ??35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 15 Oct 2009 19:45:34 -0400577_iso-8859-1 Anybody running this dasd?
Results, experiences, opinions?
Reply off line if you wish to remain anonymous. joel@responsivesystems.com
Thanks, Joel
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
3512 356 30_Re: AW: [DB2-L] Happy Birthday13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 15 Oct 2009 18:55:54 -0500503_ISO-8859-1 Cathy, Happy belated Birthday....
Willie
Taddei, Cathy wrote: > > Zoe, you are a breath of fresh air. Since I'm never going to retire, > you and I will be raking in the big bucks when all these other old > guys retire. > > > > I'd like to thank everyone for posting on this thread. I know it > wasn't meant for me, but I just turned 50 last Friday, and it was nice > to see all the happy birthday wishes from DB2-L! > > > > Cathy Taddei > > > > *From:* IDUG DB2 Discussion [...]
3869 26 37_Srinivas K Raju is out of the office.15_Srinivas K Raju19_srinraju@IN.IBM.COM31_Fri, 16 Oct 2009 08:04:49 +0530792_US-ASCII I will be out of the office starting 16/10/2009 and will not return until 21/10/2009.
Please contact Gnansekaran thiyagarajan in case of any issues.Thanks
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations! DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you! Whether you are an old hand or a DB2 newbie, we have presentations for every level. _____________________________________________________________________ [...]
3896 418 178_Upcoming IDUG Webcasts - "The DB2Night Show Episode #4" and "DB2 LUW Index Design Best Practices and Case Studies" - Thursday October 22 2009 at 9:00 am USA Central Daylight Time13_David Chapman24_David.Chapman@IAG.COM.AU31_Fri, 16 Oct 2009 17:13:09 +11001031_us-ascii
_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________
Hello DB2 List,
There are two webcasts running on Thursday October 22nd as follows:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The DB2Night Show Episode #4 - DB2 LUW 9.8 "pureScale" - Scott Hayes, DBI Software
The International DB2 Users Group (IDUG) is pleased to partner with DBI to deliver a free Webcast by renowned presenter Scott Hayes, President & CEO, DBI. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the presenter. Capacity is limited, so register early. [...]
4315 518 35_Re: OSC stats are suddenly all zero6_Leslie21_db2dba@BTINTERNET.COM31_Fri, 16 Oct 2009 07:55:13 +0100391_us-ascii hi George I did this the other dasy, it fired the traces but nothing was received in OSC .. when I did it the other way around it worked. I found it kinda strange .. but I will have another play with it today and see if maybe something local had become corrupt ... all too possible with Java taking 1.5gb of memory on my machine. :-( ...don't get me started on java :-) Leslie [...]
4834 225 25_Re: Long-running INSERT ?12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 16 Oct 2009 12:33:25 +0200741_iso-8859-1 Hi
How many CF ? How many ICF per CF ? Missing ICF power may kill your environment.
Isaac Yassin
---- Original message ---- >Date: Thu, 15 Oct 2009 15:06:52 -0500 >From: Johnny Wilder >Subject: Re: [DB2-L] Long-running INSERT ? >To: DB2-L@WWW.IDUGDB2-L.ORG > >Migrated dataset? > >-----Original Message----- >From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lyon, Lockwood >Sent: Thursday, October 15, 2009 1:51 PM >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: [DB2-L] Long-running INSERT ? > >Esteemed List, > >I'm puzzled. We're DB2z V8 NFM, 6-way data sharing. I have a >distributed transaction connecting through RRSAF attempting to execute >an INSERT [...]
5060 147 66_(zOS DB2 9) ALTER TABLESPACE ERASE YES on a partitioned tablespace16_Laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Fri, 16 Oct 2009 14:56:03 +0200446_us-ascii Hello,
I want to change the ERASE option from NO to YES. Therefore I generated the statements that looks like:
ALTER TABLESPACE DATABASE.TABLESPACE ERASE YES
After executing this I receive: DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
However, when i look at the catalog the tablespace remains ERASE NO.
I ran an reorg on that tablespace, but still the catalog of the tablespace remains ERASE NO. [...]
5208 56 40_Re: Long-running INSERT - Summary so far14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Fri, 16 Oct 2009 09:00:33 -0400445_us-ascii Esteemed List,
Some answers to ideas/questions so far.
1. Not a migrated dataset. Happens 30-40 times per hour during peak activity. 2. Tablespace is Segmented. 3. Due to high-volume of INSERTs, haven't been able to localize GETPAGE counts (or other stats) to just the problem INSERTs 4. Ran the Acct Report (Long) for the transaction. 5. 2 CFs, implemented in their own boxes. Haven't looked at CF or GBP stats yet. [...]
5265 391 70_Re: (zOS DB2 9) ALTER TABLESPACE ERASE YES on a partitioned tablespace14_Leblanc, Fritz27_fritz.leblanc@SALLIEMAE.COM31_Fri, 16 Oct 2009 09:31:20 -0400455_us-ascii I believe you'll need to alter each partition individually.
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Laurens Zwanepol Sent: Friday, October 16, 2009 8:56 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] (zOS DB2 9) ALTER TABLESPACE ERASE YES on a partitioned tablespace
Hello,
I want to change the ERASE option from NO to YES. Therefore I generated the statements that looks like: [...]
5657 214 70_Re: (zOS DB2 9) ALTER TABLESPACE ERASE YES on a partitioned tablespace16_Robert Catterall21_rfcatterall@GMAIL.COM31_Fri, 16 Oct 2009 11:15:10 -0400463_ISO-8859-1 Interesting. The DB2 for z/OS V9 SQL Reference indicates that the value of the ERASERULE column of SYSTABLESPACE "is meaningless if the table space is partitioned." Given that the ERASE specification is not recorded in SYSTABLEPART, I don't see an obvious means of verifying the ERASE specification for a partitioned tablespace. Looks like a "hole" in the catalog information (the same holds true for a partitioned index). An APAR-able situation? [...]
5872 189 40_Re: Long-running INSERT - Summary so far9_Ford Wong14_fordie@SHAW.CA31_Fri, 16 Oct 2009 11:03:08 -0600299_us-ascii Hello,
This may be a long shot but if you are using STOGROUPs and specifying volumes and your tablespace needs to expand. Are the volumes at the front of the storage group "FULL". DB2 may be spending it's time searching the full volumes at the front to get the dataset extents. [...]
6062 358 70_DB2V8- How to restore only a few tables at DR, are there BSDS issues ?12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Fri, 16 Oct 2009 13:20:05 -0400408_us-ascii All,
I have a DB2 Disaster recovery test next week and will be recovering DB2 V8 for the first time.
This is my sequence.
* Shutdown DB2 (locally). * DUMP FULL Volumes to TAPE (everything using DFDSS. * Restore FULL Volumes from TAPE, all DB2 SYSTEM Datasets (catalog, directory, BSDS) etc..... * Restore a few USER TABLES from FULL Volume tapes. * Start DB2 ( at DR site) [...]
6421 601 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 16 Oct 2009 14:13:20 -0400619_us-ascii You don't have to restore everything - just the objects you need to operate on to verify if the system is working as expected.
Steen Rasmussen
This e-mail message is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. [...]
7023 679 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 16 Oct 2009 14:27:07 -0400527_us-ascii Fine print follows!
In the ZPARMs there's a list of databases to be automatically STARTed. I think you could encounter messages on the log if the datasets for those aren't present. That would be the worst I'd expect.
________________________________ From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rasmussen, Steen Sent: Friday, October 16, 2009 2:13 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8- How to restore only a few tables at DR, are there BSDS issues ? [...]
7703 459 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?13_Hampton, Kirk26_kirk.hampton@CAPGEMINI.COM31_Fri, 16 Oct 2009 14:36:15 -0400391_windows-1252 Kevin, as long as the Catalog and Directory tablespaces are there before you start DB2, it will come up without the other tablespaces restored. You do not have to DROP anything. Any tablespaces you don't restore, as long as no one tries to access those tables, DB2 is fine with. If someone does try to access one that is not restored, they simply get a -904 (unavailable). [...]
8163 1019 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Fri, 16 Oct 2009 14:55:12 -0400434_us-ascii Awesome....thanks that kind what I expected...I can get my special, "get ready for an unexepected disaster" backups done this weekend. :-)
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Sevetson, Phil Sent: Friday, October 16, 2009 2:27 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8- How to restore only a few tables at DR, are there BSDS issues ? [...]
9183 458 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?17_Mortensen, Danial29_danial.mortensen@NEBRASKA.GOV31_Fri, 16 Oct 2009 14:12:29 -0500321_us-ascii If you haven't done a Recovery before you may want to look at an old Redbook Disaster Recovery with DB2 UDB for z/OS SG24-6370. It still has good information in it. Also Judy Ruby-Brown's DB2 for z/OS Disaster Recovery A smorgasbord of solutions presentation is good, I think you can Google it and find it. [...]
9642 28 35_Re: OSC stats are suddenly all zero12_Roy Reynolds17_royr@BERKELEY.EDU31_Fri, 16 Oct 2009 19:27:03 +0000840_UTF-8 I clicked on the cache trace button in OSC and started getting the numbers I sought. Clicking responded with 'successfully started IFCID 318' message. thanks to everyone for a quick solution. I'm happy again. Roy
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations! DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you! Whether you are an old hand or a DB2 newbie, we have presentations for every level. _____________________________________________________________________ [...]
9671 94 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 16 Oct 2009 14:51:38 -0500572_US-ASCII The biggest issue is outstanding units of work that can exists after a shutdown. This would result in error messages when you come back up and LPL and other kinds of errors.
Possible choices are 1. quiesce write(yes) to force write all updated pages from the buffer pools 2. stop all application tablespaces and index spaces before shutdown. 2a. Possible - start all the application tablespaces and indexspaces so when you restart db2 they are available but don't allow any work to schedule. 3. archive log mode(quiesce) 4. combinations of the above. [...]
9766 135 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 16 Oct 2009 16:04:47 -0400462_us-ascii Mike,
Kevin was positing an orderly shutdown of DB2 before doing a full-volume copy of the subsystem. So inflight/indoubt UOWs should not be an issue.
--Phil
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Friday, October 16, 2009 3:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8- How to restore only a few tables at DR, are there BSDS issues ? [...]
9902 201 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 16 Oct 2009 15:24:42 -0500636_US-ASCII From the v9 admin guide page 135-136
Stopping DB2 when no activity is outstanding In this step, make sure the subsystem does not have any outstanding activity, such as outstanding units of recovery or pending writes. This ensures that DB2 does not need to access the data sets on restart through the log, which contains the old data set qualifiers. To stop DB2 when no activity is outstanding: 1. Stop DB2 by entering the following command: -STOP DB2 MODE(QUIESCE) This command allows DB2 to complete processing currently executing programs. 2. Start DB2 by entering the following command: -START DB2 ACCESS(MAINT) [...]
10104 119 40_Re: Long-running INSERT - Summary so far14_Larry Kintisch17_LKint@VERIZON.NET31_Fri, 16 Oct 2009 16:52:42 -0400493_us-ascii Hi Lock,
It looks like you've done your homework checking various things. As a review I refer you to the RedBook "Design for High Perf..." SG24-7134. The section in the PDF [document page #'s, not PDF page numbers] from pp138-148 has most of the information you need; also there is mention of preformatting on p265: "Make sure you have applied PK05644 for preformatting the correct amount of space" but that is unclear if it is only used during LOAD and REORG extensions. [...]
10224 39 37_Panwar, Manoj S is out of the office.15_Manoj S. Panwar26_manoj.s.panwar@US.HSBC.COM31_Fri, 16 Oct 2009 20:24:43 -0500578_US-ASCII I will be out of the office starting 10/16/2009 and will not return until 10/19/2009.
I will respond to your message when I return. Han is OIC.
----------------------------------------- ****************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
10264 663 30_Re: AW: [DB2-L] Happy Birthday12_Michal Peleg23_michal_peleg@MOD.GOV.IL31_Sun, 18 Oct 2009 09:39:09 +0200344_windows-1255 Hello young girls and guys,
You just made my day.
I'm going to turn 50 next week, and consider myself an old dinosaur comparing to some people I work with
(I started at 1978), after reading all the mail, besides the fact that I laughed for half an hour or so, it feel good [...]
10928 29 28_Re: Plan Management Question15_Norbert Schuech23_norbert.schuech@R-IT.AT31_Sun, 18 Oct 2009 16:56:09 +0000708_utf-8 Hello List,
We have the same problem and are looking for a solution? Is reading SPT01 available or is it just "for internal use" ???
Thanks Norbert Schuech Raiffeisen Informatik
_____________________________________________________________________
* 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 _____________________________________________________________________ [...]
10958 90 40_Runstats to remove column statistics ???9_Dee Reins21_rcwingman@COMCAST.NET31_Sun, 18 Oct 2009 23:28:29 +0000498_utf-8
I am trying to remove column stats from a column in a table, but I can not seem to get the syntax correct.
Any help would be appreciated.
thank you.
//UTIL0001 EXEC PGM=DSNUTILB,REGION=4096K,PARM='DB3P' //STEPLIB DD DISP=SHR,DSN=DB2.P.DSNEXIT // DD DISP=SHR,DSN=DB2.P.DSNLOAD //SYSPRINT DD SYSOUT=* //UTPRINT DD SYSOUT=* //SYSIN DD * RUNSTATS TABLESPACE DBMR06.TSMR257 TABLE(CTMR06.VMR257VID_FACS) REPORT YES SHRLEVEL CHANGE COLGROUP(XRV_ID) FREQVAL COUNT 0 [...]
11049 269 44_Re: Runstats to remove column statistics ???16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Mon, 19 Oct 2009 08:28:24 +0800484_utf-8 It’s been a while since I did DB2 on a real computer, but this is fairly simple:
DSNU047I DSNUSDRB - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=RNPRIN01
A quick search on RNPRIN01 suggests a number of solutions, the basic one being to add a DD card:
//RNPRIN01 DD SYSOUT=*
This link may be useful as well (for V9.1): http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.ugref/db2z_datasetsrunstats.htm [...]
11319 98 44_Re: Runstats to remove column statistics ???14_Larry Kintisch17_LKint@VERIZON.NET31_Sun, 18 Oct 2009 20:35:00 -0400743_us-ascii Hi Dee, A search at www.ibm.com came up with a PUT which included a reference [below] to the missing DD: http://dtsc.dfw.ibm.com/MVSDS/'HTTPD2.DB2810.PUBLIC.PDF(PUT0503)'
(Appandix B of Utility Guide and Reference, will be changed: Modifying the WLM-established address space for DSNUTILS(U) Add DSSPRINT, SYSIN, and SYSPRINT to the JCL procedure for starting the WLM-established address space, in which DSNUTILS/DSNUTILU runs. | If you plan to invoke RUNSTATS and collect distribution | statistics for column group, you also need to allocate | RNPRIN01. . . . Use JCL similar to the following sample PROC: . . . //DSNWLM PROC RGN=0K,APPLENV=WLMENV1,DB2SSN=DSNSN //IEFPROC EXEC PGM=DSNX9WLM,REGION=&RGN,TIME=NOLIMIT,T, // [...]
11418 246 55_Re: DB2 for LUW, Recommended datatypes for partitioning8_Xu Chang20_xcoolwinds@GMAIL.COM31_Mon, 19 Oct 2009 10:26:29 +0800515_UTF-8 Hi Rüdiger,
The partitioning column be based on a regular data type, except any of the following:
-
XML -
LONG VARCHAR, LONG VARGRAPHIC -
BLOB, CLOB, DBCLOB -
User-defined distinct and structured data types -
DATALINK (also not supported as a data type in DB2 9)
All other standard data types are valid. Most typical usages of table partitioning would use DATE or TIMESTAMP columns, although character and numeric columns are also regularly used. [...]
11665 313 40_Re: Long-running INSERT - Summary so far8_duam lee20_duam_lee@HOTMAIL.COM31_Mon, 19 Oct 2009 03:20:31 +0000364_Windows-1252
Hi Larry,
This is a great explanation and how lucky I am to be here in this group. Really really great causes explained. I could not understand one part though. How it is different for inserting into temp tables. is there some thing different search alorithm when we insert to regular tables than temporary tables. [...]
11979 54 28_Re: Plan Management Question36_Stephan Terhorst, LVM Versicherungen17_s.terhorst@LVM.DE31_Mon, 19 Oct 2009 05:11:20 +0000608_UTF-8 We've done some investigations on the new plan stability feature and implemented procedures that keep us in control of our access paths to insure good SQL performance during V9 migration, refresh pack apply and daily DB2 database maintenance. The methodology is to precheck the access paths changes of all static and dynamic SQL and rate these as better, worsened or equal – b e f o r e having V9 in production. 2% were not decidable automatically.IBM Package Stability feature in combination with our precheck method allowed us to do a secure Global REBIND: the identified 2% are backuped with [...]
12034 423 30_Re: AW: [DB2-L] Happy Birthday16_Bednarz, Michael24_michael.bednarz@CITI.COM31_Mon, 19 Oct 2009 06:30:08 +0100521_utf-8 Hallo Michal,
It's easy to state your age in HEX! than.
I will turn 30 next year!
Regards
Michael Bednarz
Citicorp Operations Consulting GmbH Düsseldorfer Str. 71 b 40667 Meerbusch Tel. +49 2132 74 259 mailto:michael.bednarz@citi.com
________________________________ From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michal Peleg Sent: Sonntag, 18. Oktober 2009 09:39 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] Happy Birthday [...]
12458 158 41_z/Journal (August - September 2009 issue)10_DB2usa !!!19_db2usa3@HOTMAIL.COM31_Mon, 19 Oct 2009 01:53:30 -0400504_iso-8859-1
Hi DB2 user,
Here is a non-profit Blog about DB2 for z/OS (IBM mainframes): http://db2usa.blogspot.com
Last update on Monday, October 19th 2009
Articles from August - September 2009 issue of z/Journal are available online:
- Avoiding Application Bottlenecks in a Dynamic Environment by Lockwood Lyon and Lisa Westcott-Dryer
- Initial Project Analysis: An IMS to DB2 Conversion Example by Shirley Huhtanen [...]
12617 468 30_Re: AW: [DB2-L] Happy Birthday12_Michal Peleg23_michal_peleg@MOD.GOV.IL31_Mon, 19 Oct 2009 09:14:07 +0200540_utf-8 Hi Michael,
Any way I look at it, I'll be 2 years older than you.
By the way, did my prev. mail got to the forum as well?
I'm not sure, I haven't received it.
Thanks and regards,
Michal Zellermayer-Peleg
Israel
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bednarz, Michael Sent: Monday, October 19, 2009 7:30 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] AW: [DB2-L] Happy Birthday [...]
13086 38 55_Re: DB2 for LUW, Recommended datatypes for partitioning14_Peter Vanroose17_pvanroose@ABIS.BE31_Mon, 19 Oct 2009 07:54:31 +0000356_UTF-8 On Mon, 19 Oct 2009 10:26:29 +0800, Xu Chang wrote: > [...] > *Generated columns* The column that is used to define the partitioning > can be a regular or a generated column. A generated column is sometimes used > to create a smaller set of values when the partitioned column doesn't > provide a convenient set of ranges. [...]
13125 65 55_Re: DB2 for LUW, Recommended datatypes for partitioning16_Frederik Engelen25_engelenfrederik@GMAIL.COM31_Mon, 19 Oct 2009 10:35:39 +0200625_ISO-8859-1 Peter,
I don't think that's possible yet for DB2 LUW.
Kind regards,
Frederik Engelen
On Mon, Oct 19, 2009 at 9:54 AM, Peter Vanroose wrote: > On Mon, 19 Oct 2009 10:26:29 +0800, Xu Chang wrote: >> [...] >> *Generated columns* The column that is used to define the partitioning >> can be a regular or a generated column. A generated column is sometimes used >> to create a smaller set of values when the partitioned column doesn't >> provide a convenient set of ranges. > > > You even don't need to create that column: just create [...]
13191 38 28_DB2 on z/OS 1.10 - unicode ?11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Mon, 19 Oct 2009 10:30:05 +0000347_UTF-8 Hello, a bit off topic:
"Starting in z/OS® V1R7, the Unicode environment can be dynamically updated. Callers can invoke Unicode services and the tables required for respective service will be loaded as they are referenced. The operator can also update the environment with the SETUNI command to add, delete, or replace tables." [...]
13230 34 51_Re: Plan Management Question now [AD] by the way...11_Roy Boxwell16_R.Boxwell@SEG.DE31_Mon, 19 Oct 2009 12:45:40 +0200339_US-ASCII Hi List!
Yes it is available as it is one of our little "pocket" tools - Think along the lines of the swiss army penknife. Lots of different functions for a modest price...oops I better change the subject line to [AD] or I will get into trouble... Anyone interested then zap me an email, off list!!!, for details etc. [...]
13265 149 32_Re: DB2 on z/OS 1.10 - unicode ?10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 19 Oct 2009 12:58:46 +0200434_UTF-8 Hi Nenad
When I was migrating from V7 to V8 I discovered it (we were in z/OS 1.9).. Anyway we asked it to IBM support and we were told we had to build UNI image.
Actually I'm not sure you have to do it, in our sandbox we had UNICODE services even without building any UNI image, but we decided to follow IBM's suggestions. Take a look in DB2-L archives, I sent a post about this topic this year or last year. [...]
13415 49 32_Re: DB2 on z/OS 1.10 - unicode ?15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Mon, 19 Oct 2009 07:00:01 -0400288_utf-8 Your MVS Sysprog should be able to verify that you have all the parts setup in PARMLIB and LINKLST to make this work. There has been a lot of discussion on this topic over in IBM-MAIN. If you search the IBM-Main archives you will be able to find the details on how this works. [...]
13465 90 32_Re: Need Ventyx Passport DB2 DBA11_Diana Nagel16_dknagel@BEPC.COM31_Mon, 19 Oct 2009 07:50:19 -0500495_utf-8 I have someone that might be interested....we have used Passport/Asset Suite for 10 plus years now and are presently on AS 6.1. Anyway the consultant we have used in the past is: Erik Eriksen - see attached contact info.
Diana
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robin Marsh Sent: Thursday, October 15, 2009 3:05 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Need Ventyx Passport DB2 DBA [...]
13556 957 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Mon, 19 Oct 2009 09:26:16 -0400554_us-ascii Just a note on auto starting. I would setup a separate ZPARM that you use offsite that does not autostart user databases. I remember years ago not having this setup and having to perform manually a start force on everything.
Also, you mention you are only going to restore a few of the user tables. Years ago when I used to do offsite DR testing we wanted to time how long it would take to get the entire production system up. In doing that we found we had a couple missing tapes which caused us to fail the test. We [...]
14514 38 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Mon, 19 Oct 2009 14:02:03 +0000370_utf-8 Kevin, you also need to make sure that your DR planning can and will cope with an unclean stop of DB2. Making sure that you have no inflight URs etc is all well and good when it comes to facilitating a subsystem wide copy/backup but that is very, very rarely the case in a DR scenario. You need to know that if your DB2 goes belly up you are able to recover. [...]
14553 141 44_XML and Zos Universal Driver v3.53.104 error13_Palko, George16_gpalko@OPERS.ORG31_Mon, 19 Oct 2009 18:18:58 +0100479_us-ascii List,
We have opened a IBM ticket pertaining to a XML Zos Universal Driver issue, but while we're waiting for traces to be captured, I thought I would throw it out to the List to see if anyone else has encountered a similar problem.
We are on DB2 V9.1 RSU0905. zOS 1.8 and we are migrating our LOB's to XML via a JAVA batch program. However, when executing the JAVA program with the zOS DB2 Universal Driver v3.53.104, we receive the following error: [...]
14695 44 23_Re: Long-running INSERT14_Peter Vanroose17_pvanroose@ABIS.BE31_Tue, 20 Oct 2009 07:13:03 +0000546_UTF-8 On Mon, 19 Oct 2009 03:20:31 +0000, duam lee wrote: > [...] > How it is different for inserting into temp tables. is there some different search > algorithm when we insert to regular tables than temporary tables?
For one, you won't have the locking issues with temporary tables, since only one "thread" is accessing the table. Also, you typically don't have indexes on temp tables, hence no index page split issues etc. Finally, no clustering sequence on a temp table, hence inserts always go at the end. [...]
14740 63 45_DB2 9 for z/OS: Add Partition with XML-column14_Peter Backlund21_BacklundDB2@TELIA.COM31_Tue, 20 Oct 2009 11:08:33 +0200
14804 1343 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Tue, 20 Oct 2009 09:17:10 -0400517_us-ascii Troy,
You have validated my fears as they relate to the tapes. We are even having them delivered directly from our offsite storage. Won't fell good until I see those "Lovely Blue containers" :-)
Thanks all.
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Coleman, Troy L Sent: Monday, October 19, 2009 9:26 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V8- How to restore only a few tables at DR, are there BSDS issues ? [...]
16148 645 43_[AD] BMC UK's DB2 Customer Days in November13_Bell, Raymond20_Raymond_Bell@BMC.COM31_Tue, 20 Oct 2009 17:45:00 +0200440_us-ascii Greetings all,
Not sure if [AD] is the right 'tag' but you'll soon get the idea. BMC UK's annual Customer Day is being held in two places this year; Whittlebury Hall (near Northampton) on Tuesday 2nd November and in Edinburgh on Friday 6th November. There are multiple streams on both days covering different subject matter but I'm guessing this group may only be interested in the DB2 one, so that's all I'll mention. [...]
16794 146 64_When the truth hurts Oracle and Sun fingered for Sidekick fiasco11_Dave Beulke19_dave@DAVEBEULKE.COM31_Tue, 20 Oct 2009 11:42:51 -0400707_us-ascii Being a DBA is a public occupation
http://www.theregister.co.uk/2009/10/19/sidekick_rac/
See you at IOD!!
All the Best,
Dave Beulke IBM Gold Consultant DB2 Data Champion
email: Dave@DaveBeulke.com Blog: www.DaveBeulke.com Office: 703 751-4348 Cell: 703 798-3283
Dave Beulke & Associates a division of Pragmatic Solutions, Inc Syspedia - Find, understand and integrate your data faster!
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________ [...]
16941 68 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 20 Oct 2009 12:18:08 -0400388_us-ascii I disagree with this. Not all DB2 systems require up-to-the-minute recovery. If your system cannot afford to lose any transactions, this is correct; but if your system can fall back to the previous night's datastores and rerun batch, or just preserve data entry from the last full backup to the current time, then a clean stop is a perfectly acceptable recovery assumption. [...]
17010 129 103_Reminder - IDUG Regional Forums - Novemeber (Camp Hill PA, Dallas, Austin, Minneapolis and Kansas City)11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 20 Oct 2009 12:37:24 -0500398_Windows-1252
If you live near Camp Hill PA, Dallas, Austin, Minneapolis or Kansas City...
Travel budgets down? IDUG is bringing training to your home-town with the top-notch speakers you've come to know and trust from IDUG!
Two days of valuable training for z/OS and LUW - right in your neighborhood!
Please check this out for an exceptional training opportunity: [...]
17140 282 68_Re: When the truth hurts Oracle and Sun fingered for Sidekick fiasco14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Tue, 20 Oct 2009 14:00:50 -0400464_us-ascii ...and aren't we all glad that IBM was firmly on the sidelines during this episode? It would have been used as a bludgeon about the unreliability of mainframes and/or DB2...
________________________________ From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dave Beulke Sent: Tuesday, October 20, 2009 11:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] When the truth hurts Oracle and Sun fingered for Sidekick fiasco [...]
17423 87 32_db2/zos v9.1: new index features24_Sorensen Henrik (KCED 2)33_henrik.sorensen@CREDIT-SUISSE.COM31_Tue, 20 Oct 2009 21:29:29 +0200768_us-ascii Dear List,
I have a question regarding expiriences with compressed indexes and indexes with keyexpressions.
How mature are these features ?
Is anybody using them with good results ?
thanks for your help Henrik Sorensen
_____________________________________________________________________
* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________
http://www.idug.org/db2-videos.html has hundreds of video presentations! Did you miss out on attending an IDUG conference? Many of the presentations were recorded and are available on our website! _____________________________________________________________________ [...]
17511 193 39_What outage does "Create index" entail?15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Tue, 20 Oct 2009 15:49:51 -0500382_us-ascii We are DB2 V8 NFM on z/OS 1.9.
I have a large table for which I need to create a small non-unique index. The table is exposed to the web and should be in RW status 24X7.
What kind of outage does a CREATE INDEX with DEFER NO entail?
I know that DEFER YES will put the underlying tablespace in UTRO status when I rebuild it and that is undesirable. [...]
17705 56 30_Re: AW: [DB2-L] Happy Birthday10_Juan Lanus21_db2.globant@GMAIL.COM31_Tue, 20 Oct 2009 18:45:35 -0200405_ISO-8859-1 Incredible thread! Humorous. I work in a software factory in Buenos Aires where those in the 30s feel old. The age average is near 25. I'm the oldest, hired because they needed a DB2 type. See my picture at 18 with my first IBM 1620 computer, in 1963: http://tecnosol.com.ar/images/JML_1620_01b.jpg I think I'm older than Zoe and everybody else in the thread, happy many birthdays to everybody!
17762 517 28_Why not Index Only? (DB2 V7)13_Jose de Bedos20_josedebedos@LIVE.COM31_Tue, 20 Oct 2009 19:40:45 -0200480_iso-8859-1
Hi list,
I have 3 indexes on Plan_table:
I1:
Sel Column Name Seq No O Col Type Length Scale Null Def FP Col Card * * * * * * * * * * --- ------------------ ------ - -------- ------ ------ ---- --- -- ----------- APPLNAME 1 A CHAR 8 0 N N N 1 PROGNAME 2 A CHAR 8 0 N N N 1856 VERSION 3 A VARCHAR 64 0 N Y N 512 COLLID 4 A CHAR 18 0 N Y N 2 BIND_TIME 5 A TIMESTMP 10 0 N Y N 16591 [...]
18280 398 62_Baltimore/Washington DB2 Users Group - December 2009 Meeting!!14_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Tue, 20 Oct 2009 21:42:30 +0000426_- The Baltimore/Washington DB2 Users' Group Meeting Schedule for December 9, 2009 (Wednesday)
When? Wednesday, December 9, 2009 9:00 AM-3:30 PM (Registration at 8:30 AM)
Where? Sheraton Columbia, 10207 Wincopin Circle Columbia, MD (410) 730-3900
Meeting Fees (please note changes): Pre-registered members $30 Pre-registered non-members $40 At-the-door for members $40 At-the-door for non-members $50 [...]
18679 467 32_Re: Why not Index Only? (DB2 V7)15_Kalena, Michael27_Michael.Kalena@JPMORGAN.COM31_Tue, 20 Oct 2009 18:31:49 -0400725_us-ascii With VarChar in v7, DB2 has to go to data page to get the length as it's fully expanded in the index (no length).
In v8 you can create a Not Padded index and get index only.
Michael Kalena 973-793-2133 Michael.Kalena@jpmorgan.com
DB2 Info Page at hBSC
(http://whsysops1.is.bear.com/db2/ )
_____
From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jose de Bedos Sent: Tuesday, October 20, 2009 5:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Why not Index Only? (DB2 V7) [...]
19147 660 32_Re: Why not Index Only? (DB2 V7)13_Jose de Bedos20_josedebedos@LIVE.COM31_Tue, 20 Oct 2009 20:47:43 -0200509_Windows-1252
Michael,
thanks a lot!
Jose
Date: Tue, 20 Oct 2009 18:31:49 -0400 From: Michael.Kalena@JPMORGAN.COM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Why not Index Only? (DB2 V7)
With VarChar in v7, DB2 has to go to data page to get the length as its fully expanded in the index (no length).
In v8 you can create a Not Padded index and get index only. [...]
19808 49 43_Re: What outage does "Create index" entail?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 21 Oct 2009 10:07:15 +1100517_US-ASCII Try DEFER YES, followed by a REORG SHRLEVEL CHANGE.
James Campbell
On 20 Oct 2009 at 15:49, Tonmoy Dasgupta wrote:
> > We are DB2 V8 NFM on z/OS 1.9. > > I have a large table for which I need to create a small non-unique index. The table is exposed to > the web and should be in RW status 24X7. > > What kind of outage does a CREATE INDEX with DEFER NO entail? > > I know that DEFER YES will put the underlying tablespace in UTRO status when I rebuild it and > that is undesirable. [...]
19858 43 74_Re: DB2V8- How to restore only a few tables at DR, are there BSDS issues ?12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Wed, 21 Oct 2009 06:29:34 +0000394_utf-8 I quite agree with you Phil - sometimes a PIT restore and batch re-run etc. will work fine.
In the scenario in the first posting: -Shutdown DB2 (locally). -DUMP FULL Volumes to TAPE (everything using DFDSS. -Restore FULL Volumes from TAPE, all DB2 SYSTEM Datasets (catalog, directory, BSDS) etc….. -Restore a few USER TABLES from FULL Volume tapes. -Start DB2 ( at DR site) [...]
19902 407 32_Re: Why not Index Only? (DB2 V7)12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 21 Oct 2009 08:44:16 +0200393_iso-8859-1 Hi,
To be more exact - the DSNZPARM parameter RETVLCFK controls whether you get the varchar data from the index or from the data page (YES means from the index, NO means from data page).
Howevwer - it is a system wide parameter and affects all varchar columns in all indexes. In V7 when you get it from the index the length is always the maximum for that column. [...]
20310 105 10_DB2 Strobe13_Vikram_Maingi32_Vikram_Maingi@MAHINDRASATYAM.NET31_Wed, 21 Oct 2009 14:16:27 +0530699_iso-8859-1 Hi,
Can anyone please guide me how Strobes are inserted in IBM DB2 for monitoring the performance of application database? How can we use strobes for identifying the areas where optimization is required.
Best Regards, Vikram Maingi
________________________________ DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the [...]
20416 313 14_Re: DB2 Strobe13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 21 Oct 2009 08:02:53 -0400471_utf-8 Hello Vikram,
There's not a simple answer to your questions.
I'll try, anyway.
Strobe takes samples of the activity in your program as it executes and produces reports of where you are spending resources.
If you or your shop is new to Strobe, I recommend having a read through sections of the doc.
Start with Strobe MVS concepts & facilities and the User Guide and then dive into the DB2 doc. [...]
20730 74 43_Re: What outage does "Create index" entail?15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Wed, 21 Oct 2009 07:59:03 -0500455_us-ascii Sorry... that's possible in DB2 V9, James. We are V8.
-----Original Message----- From: IDUG DB2 Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Tuesday, October 20, 2009 6:07 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] What outage does "Create index" entail?
Try DEFER YES, followed by a REORG SHRLEVEL CHANGE.
James Campbell
On 20 Oct 2009 at 15:49, Tonmoy Dasgupta wrote: [...]
20805 36 55_DB2 UDB V9.1 on Solaris 9 1MB CLOB export takes 3 hours13_Jerry W. Howe22_jerry.howe@VERIZON.NET31_Wed, 21 Oct 2009 12:51:45 +0000335_utf-8 Hi
I am supporting a DB2 UDB V9.1 on Solaris 9 environment. I have a table with a 1MB CLOB and when I do the export it takes over 3 hours to finish. This tables has less than 750 thousand rows.
export to /bu/MYLOBTABLE.del of del LOBS TO /bu LOBFILE MYLOBTABLE modified by lobsinfile select * from MYLOBTABLE; [...]
20842 28 15_DB2 UDB backups18_McBride, Catherine18_CMcbride@KABLE.COM31_Wed, 21 Oct 2009 12:00:00 -0500347_iso-8859-1 I'd like to hear what folks are using for backups hardware/software for DB2 UDB. Right now we're using Tivoli but it is very expensive. It does archive log files nicely and has many great features, but it is very pricey and very complicated to adminstrate. What are other shops using? We're DB2 UDB V9.5 and going to HADR shortly. [...]
20871 155 36_Re: db2/zos v9.1: new index features11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 21 Oct 2009 12:36:21 -0500666_iso-8859-1
Henrik,
Admittedly, real experience in prod for some period of time is probably sketchy.
Index on expression - we are starting to use and our experience has been very positive (e.g. last 4 characters of SSN). Lack of tool support by some prominent vendors is an issue.
Index compression - unless you have high compression ratios (use dsn1comp to estimate), I would discourage. The main issue is that it is NOT free - you may increase storage requirements if you guess wrong. Contact me offline if you would like to see simulated numbers of how much is wasted. Currently we [...]
21027 255 36_Re: db2/zos v9.1: new index features24_Sorensen Henrik (KCED 2)33_henrik.sorensen@CREDIT-SUISSE.COM31_Wed, 21 Oct 2009 20:24:38 +0200387_us-ascii Suresh,
This is also my impression, that using the keyexpresions can give very good results.
How high should the compression ratios be before compression is useful ?
We have an application that is scanning alot of indexes and is IO-bound, so I was thinking that Index compression would reduce the amount of IO necessary. Some indexes are 8GB and more. [...]
21283 52 43_Identifying client applications on DB2 z/OS9_Ajay Sahu20_ajay_sahu@JBHUNT.COM31_Wed, 21 Oct 2009 23:13:22 +0000401_utf-8 Greetings! I would like to poll the list.
Like everyone else, we have distributed applications that run on web/app servers and connect to our DB2 z/OS version 8 subsystems. To DB2, they all look something like: Corrid=JAVA.EXE Authid=WEBUSR1 WorkstationName=WEBSRV91 This makes it hard to distinguish between different threads because they all have the same identifying information. [...]