1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2006, week 1
2 40 30_Re: xLOBs and daily management33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Sun, 1 Jan 2006 23:58:52 +0100516_iso-8859-1 Max,
we have several BLOB tablespaces. Some of them are about 36GB. A FC takes more then an hour. In the begining it was a challange because there had been some bugs in DB2 code. This application was portet from DB2 LUW to the DB2 z/OS.
Roland
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Max Scarpa Sent: Saturday, December 31, 2005 10:36 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] xLOBs and daily management [...]
43 26 30_Re: xLOBs and daily management10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 2 Jan 2006 10:33:18 +0100405_US-ASCII HI Roland and thank you for your reply
Can you tell me what is your maintenance level or what PTF(s) did you apply to your system for managing blobs ? How big is your BP for xLOBs (and dataspace) ?
Actually the only problem I can see is LOG NO for recovery due to a wrong application update. I presume you use LOG NO which (as Avram pointed out) give some additional problems. [...]
70 69 30_Re: xLOBs and daily management33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Mon, 2 Jan 2006 11:16:01 +0100422_iso-8859-1 Max,
seperate BP for all Lob's about 5000 Pages and because of DB2 V8 no dataspace. It was a dataspace same size while running V7. I don't believe it makes sense to use a large BP for those type of data.
Currently all of them are LOG YES but we will change some to LOG NO this year. Only LOBs with updates will remain as LOG Yes. Those with just insert/read/delete will be changed to LOG no. [...]
140 16 40_Need sample IFI program using C language15_Daniel Cremieux17_c300501@YAHOO.COM30_Mon, 2 Jan 2006 07:12:26 -0600672_- Dear all,
First of all , i would like to wish you all a healthy and successful 2006. I am looking for some samples of IFI program using C language, please send to me if you have
Regards
--------------------------------------------------------------------------------- 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
157 80 44_Re: Need sample IFI program using C language15_nguyen duc tuan17_ndt.db2@GMAIL.COM30_Mon, 2 Jan 2006 14:43:32 +0100646_ISO-8859-1 Daniel , SDSNSAMP(DSN8ED2) seems to have C code calling dsnwli , if you have extra codes , i am also interested
On 1/2/06, Daniel Cremieux wrote: > > Dear all, > > First of all , i would like to wish you all a healthy and successful 2006. > I am looking for some samples of IFI program using C language, please send > to me if you have > > Regards > > > --------------------------------------------------------------------------------- > 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 > [...]
238 64 30_Re: xLOBs and daily management14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Mon, 2 Jan 2006 14:54:12 +0100456_us-ascii Look for pmr 06838 : reuse of lob-space after REORG is not O Hi,
Look for pmr 06838 : reuse of lob-space after REORG is not OK !
greetings,
Patrick Steurs.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schiradin,Roland HG-Dir itb-db/dc Sent: maandag 2 januari 2006 11:16 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] xLOBs and daily management [...]
303 19 30_Re: xLOBs and daily management10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 2 Jan 2006 16:14:57 +0100568_US-ASCII Hi all
Thank you for your new replies.
With best regards
Max Scarpa
--------------------------------------------------------------------------------- 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
323 147 30_Re: xLOBs and daily management33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Tue, 3 Jan 2006 00:40:40 +0100387_iso-8859-1 Hi Patrick,
there are still several open APAR's open for LOB tablespaces. If I follow Roger Miller these are existing never reported problems running older version of DB2.
However we never run any REORG for our LOB tablespaces as it makes no bif sense for us. What benefit did you see running REORG let's say tiwice a month in term of performance or space? [...]
471 46 53_[DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE30_Tue, 3 Jan 2006 03:31:42 -0600326_- Hi all
The new year begins as the old ended, with a mystery of the DB2 optimizer. When I read through the manuals, I learned that in V8 CHAR-column compared with VARCHAR-column is stage1 and indexable. If I use that comparison in a join, it is indexable since V7. Now here is a piece of a somehow complex query: [...]
518 207 70_Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 3 Jan 2006 11:50:23 +0100405_iso-8859-1 Hi !
I had roughly the same problem and found that adding an ELSE to the end of the CASE stops the "output expression" being NULLable and then everything worked great! HTH !
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...]
726 38 22_Strange SQLSTATE 5100212_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 3 Jan 2006 13:00:46 +0100525_- Environment: DB2 for z/OS V7
Collegues,
we are dealing with a strange SQLSTATE 51002:
SQLABC = 136 SQLCODE = -805 SQLERRML = 045 SQLERRMC = 'A03DB2..DTBIN2DC.consistencytoken.PLDACIC9' SQLERRP = 'DSNXEPM' SQLERRD(1-6)= -250, 000, 00000, -1, 00000, 000 SQLWARN(0-A)='_ _ _ _ _ _ _ _ _ _ _ ' SQLSTATE = 51002
But: The mentioned plan PLDACIC9 is still there/valid/operative, also the program DTBIN2DC (bound into a collection). And this collection is really associated with the plan PLDACIC9. [...]
765 17 74_Re: Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE30_Tue, 3 Jan 2006 06:11:42 -0600707_- Roy
Thank you for your response. I just checked it, but it didn't work. Same explain.
But if it did, that wouldn't be the explanation, because comparison between NULLABLE and NOT NULLABLE is indexable (I think since V7).
--------------------------------------------------------------------------------- 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
783 161 91_Antwort: Re: [DB2-L] Antwort: [DB2-L] [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR11_Roy Boxwell16_R.Boxwell@SEG.DE30_Tue, 3 Jan 2006 13:34:11 +0100544_iso-8859-1 Hi Walter! I just checked and the problem with the ELSE was to do with the DSNTIAUL program adding a strange extra byte and nothing to do with index access or not! Whoops!...guess I need a coffee.... but back to the problem...what is the column def of the D.GJ_SL column? What does it have in the SYSCOLDIST and how does the index look? (Cluster, Leafs etc) I have seen in V8 that it changes its access path for the WEIRDEST reasons... I had one query where it insisted on using a rubbish index just to avoid an ORDER BY, after [...]
945 155 29_Re: DB2 V8 NFM/ENFM migration9_Joe Burns25_joseph.burns@HIGHMARK.COM30_Tue, 3 Jan 2006 08:01:24 -0600558_- Hi George,
We have a similar setup to what you described for your program migration process. My guess is many people do. We pre-compile, compile and bind on the development environment. Then we "move" the load and DBRM to prod and do a bind in the prod system.
We are not at v8 yet, but will begin our migration this month. So we've had to look at some of the same things you've talked about. According to everything I've seen, you should definitely be able to take the DBRM that was created in the V8 ENFM system (development) and bind [...]
1101 56 29_Re: DB2 V8 NFM/ENFM migration13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Tue, 3 Jan 2006 08:43:26 -0600626_us-ascii Hi George
I have a short write-up on ENFM at http://blogs.ittoolbox.com/database/db2zos/archives/006862.asp that you may want to take a look at.
Willie
George Palko wrote:
>Hi List, > >We are in the process of migrating from DB2 V8 CM to NFM. However, we've >encountered an issue where a number of our third-party vendors are not yet >ready to exploit V8 NFM. To expedite the process of migrating, we've >decided to migrate to NFM and then convert back to ENFM, thus disabling new >functions. My question is: is it possible for a DBRM that was created >within ENFM with NEWFUN set to [...]
1158 161 32_Re: Access path and index choice14_Larry Kintisch19_lkint@IX.NETCOM.COM30_Tue, 3 Jan 2006 10:55:17 -0800539_us-ascii Adam,
Something Terry said made me review the RUNSTATS options and something you did not reply to us on my earlier response still is a mystery.
In RUNSTATS use INDEX(.... KEYCARD FREQVAL NUMCOLS 6 COUNT 10) or some other COUNT number. This will help determine [as Terry says, if the optimizer is coded to check] whether there is correlation amongst the columns of your predicates [as would be in MAKE = 'FORD' and MODEL = 'TAURUS']. Similarly for the other index try a (....KEYCARD FREQVAL NUMCOLS 3 COUNT 10). [...]
1320 181 33_LOB info - the good, bad and UGLY16_Lemaire, Nigel B21_nigel.lemaire@EDS.COM30_Tue, 3 Jan 2006 10:14:13 -0600341_us-ascii There is an excellent Red Book - Large Objects with DB2 for z/OS and OS/390 SG24-6571 that you might want to review.
Having LOG YES will probably drive the SS Logging crazy IMHO.
We have an "adventurous application" that will be using 2g LOBs, *and* moving them over our network! That will be interesting to see! [...]
1502 31 10_Encryption14_Toppins, Smike21_smike.toppins@GWL.COM30_Tue, 3 Jan 2006 09:58:00 -0700681_us-ascii I'm wondering what options other admins are using for DB2 data encryption. The concern that an image copy tape may get "lost" from our disaster recovery storage facility.
SMike Toppins Great-West Life 8525 E. Orchard Road Englewood, CO 80111 smike.toppins@gwl.com ----Statement of Confidentiality---- This e-mail, and any attachments thereto, is intended for the exclusive use of the addressee(s) named herein and may contain information that is privileged or confidential or otherwise legally exempt from disclosure. If you are not a named addressee or an employee or agent responsible for delivering this message to a named addressee, you are not authorized [...]
1534 84 35_Rollforward pending for tablespaces12_Matthew Rhea24_matthew_rhea@CONSECO.COM30_Tue, 3 Jan 2006 11:05:15 -0600615_ISO-8859-1 Hi, List. DB2 V8.1.4 for Windows here.
I restored two tablespaces using this command:
RESTORE DATABASE RPS01 TABLESPACE (TRABCNM, TRQSRC) ONLINE FROM "E:\db2_backups" TAKEN AT 20051229205621 WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT ROLLING FORWARD WITHOUT PROMPTING;
I thought using the phrase WITHOUT ROLLING FORWARD would indicate that I only wanted to restore to the backup. When I issued a get db cfg command, I got the message that the database is not consistent and tablespaces are in a rollforward pending status. The tablespaces are unavailable with the message [...]
1619 76 26_Re: Strange SQLSTATE 510029_Agus Kwee19_askwe@OPTONLINE.NET30_Tue, 3 Jan 2006 12:30:36 -0500590_iso-8859-1 Peter,
I did a test to produce sqlcode = -805 I received similar sqlerrmc text that exclude the collection-id. The sqlerrml contained 40 which is 5 less than the one you received because my location-d is 2 bytes shorter than your location-id and my dbrm-name is 3 bytes shorter than your dbrm-name. The difference is the last 2 bytes returned in my sqlerrmc contains '03' the 'REASON' that further explained the -805 sqlcode. How long is the consistency-token in your sqlerrmc? If you add all the returned text in sqlerrmc does it add up to the 45 value in sqlerrml? [...]
1696 77 29_Re: DB2 V8 NFM/ENFM migration13_Keemle Joan T25_KeemleJoanT@JOHNDEERE.COM30_Tue, 3 Jan 2006 11:43:29 -0600331_us-ascii The answer to your question is Yes: DBRMs generated with NEWFUN NO can be bound in CM. There may be a few minor exceptions.
As regards going to NFM and then "converting back to ENFM", why not stop at ENFM? Just don't run that final job DSNTIJNF until you're ready for NFM, and keep NEWFUN=NO in your DSNHDECP. [...]
1774 98 30_Re: xLOBs and daily management13_Robert Tilkes22_TILKESR@NATIONWIDE.COM30_Tue, 3 Jan 2006 12:10:47 -0600494_US-ASCII We currently have an application that has BLOBS from 1K to 3M in size. It is populated from a distributed environment. We wrote a COBOL application that would unload all of the rows and would accept a specific file format and load the rows back in. There is a lot more the program can do, but as someone earlier stated use the LOB-LOCATORS when possible. Follow the Redbook on how to use locators and you should be alright. This application has been running for about a year now. [...]
1873 128 39_Re: Rollforward pending for tablespaces12_Matthew Rhea24_matthew_rhea@CONSECO.COM30_Tue, 3 Jan 2006 12:22:42 -0600308_ISO-8859-1 I was able to access the tables in the tablespaces. I dropped and recreated the tables and tablespaces. It didn't work the first time because I was dropping the table, not the tablespace. (Blush)
Now when I issue a get db cfg for the database, it shows the rollforward pending status: [...]
2002 167 39_Re: Rollforward pending for tablespaces12_John Lendman27_lendman@PALMBEACH.K12.FL.US30_Tue, 3 Jan 2006 13:53:30 -0500557_iso-8859-1 I would run a "rollforward" with the complete option. That should make it OK
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator DB2 Universal Database V8.1 for zOS Office 561-357-7523 Cell 772-485-1592 Email lendman@palmbeach.k12.fl.us
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Matthew Rhea Sent: Tuesday, January 03, 2006 1:23 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Rollforward pending for tablespaces [...]
2170 186 39_Re: Rollforward pending for tablespaces12_Matthew Rhea24_matthew_rhea@CONSECO.COM30_Tue, 3 Jan 2006 13:00:55 -0600527_- Thanks for the response.
Here's the command I issued along with the results:
ROLLFORWARD DATABASE RPS01 COMPLETE TABLESPACE ONLINE SQL1261N Database "RPS01" is not in rollforward pending state on node (s) "0", so it does not need to be rolled forward on these nodes.
My get db cfg command is still showing tablespaces in rollforward status. The database appears to be behaving, so I guess I'll just see how it goes. I sure would like to get a "warm fuzzy" about this, but I'll just keep monitoring. [...]
2357 239 39_Re: Rollforward pending for tablespaces12_John Lendman27_lendman@PALMBEACH.K12.FL.US30_Tue, 3 Jan 2006 14:12:50 -0500424_iso-8859-1 Any chance that this tablespace is in Rollforward pending on another node, different from the one you are running the rollforward on? I do believe that you are OK on that node where you received this message.
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator DB2 Universal Database V8.1 for zOS Office 561-357-7523 Cell 772-485-1592 Email lendman@palmbeach.k12.fl.us [...]
2597 77 14_Re: Encryption13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Tue, 3 Jan 2006 11:32:41 -0800566_us-ascii Hi SMike. That issue has been debated here, but so far we have not made any changes to our processes, meaning that if we lost a tape today, we would have to determine whether any of our California customer or employee data was on that tape, and if so, report the loss to them. Those were the requirements for a non-financial services company last time I checked, but legislation may have since been passed to widen our responsibilities. We have discussed using FDR to encrypt our backups, but at the time, I believe FDR was unable to encrypt DB2 image [...]
2675 237 39_Re: Rollforward pending for tablespaces12_Matthew Rhea24_matthew_rhea@CONSECO.COM30_Tue, 3 Jan 2006 14:11:38 -0600701_- No, it's only on one node. Thanks for your help. On Tue, 3 Jan 2006 14:12:50 -0500, John Lendman wrote:
>Any chance that this tablespace is in Rollforward pending on another node, different from the one you are running the rollforward on? I do believe that you are OK on that node where you received this message. > >John C. Lendman >IBM Certified Solutions Expert >IBM Certified Database Administrator >DB2 Universal Database V8.1 for zOS >Office 561-357-7523 >Cell 772-485-1592 >Email lendman@palmbeach.k12.fl.us > > > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On >Behalf Of Matthew Rhea >Sent: Tuesday, [...]
2913 102 14_Re: Encryption12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 3 Jan 2006 12:32:16 -0800652_iso-8859-1 Cathy, I seriously doubt any reasonably competent auditor if they required data to be encrypted would accept compression as an acceptable substitute. It's still readable directly for the most part and easily decoded by any competent techie without any external keys.
From what I've been reading about DB2 V8 encryption and the hardware assists, it doesn't seem to be that much of a performance penalty, provided (and here's a major assumption) the programmers access the encrypted data correctly. The actual process of encryption/decryption isn't that expensive. It only depends on how much and when it's done. But bear in mind, [...]
3016 117 14_Re: Encryption13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM30_Tue, 3 Jan 2006 13:55:45 -0800530_us-ascii Hi Myron. So far as backup tapes are concerned, it's not auditors we're concerned with, it's legislators. I believe that the current hype surrounding backup tape encryption is our nations 500th most important problem, so naturally that's what our legislators are addressing. I believe that virtually all identity theft is carried out by other means besides stealing backup tapes from courier services. That said, I want to protect my employer with as little pain and expense as possible. What are other shops doing? [...]
3134 117 34_AW: [DB2-L] Strange SQLSTATE 5100212_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 4 Jan 2006 10:08:28 +0100474_iso-8859-1 Agus,
the consistency token is '17AAF2EE195DD03E'.
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ----------------------------------------------------------------------
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Agus Kwee Gesendet: Dienstag, 3. Januar 2006 18:31 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: [DB2-L] Strange SQLSTATE 51002 [...]
3252 20 32_Re: Access path and index choice12_Adam Baldwin19_y0027528@ES.IBM.COM30_Wed, 4 Jan 2006 04:04:43 -0600352_- Larry:
Re the literals/hostvars - the access path chosen by the optimizer is the same in both scenarios. We've tracked down some maintenance to apply which should resolve the issue.
Re my location - I work for IBM in Spain.
Fellow Listers - Thanks for all of the replies and suggestions.
Regards, and Happy New Year. [...]
3273 22 41_Quick question about CA product LMP codes10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 4 Jan 2006 11:15:34 +0100359_US-ASCII Esteemed listers
DEaling with CA products.
I need a table to check what is product code for a given product name of database management suite, that is for example product code P9 is PLAN ANALYZER. I'm not able to see this table (I found it for other CA's products...but not for DB2) in any appendixes I serached. Any help ? Phil ? [...]
3296 66 53_AW: [DB2-L] Quick question about CA product LMP codes12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 4 Jan 2006 11:22:47 +0100687_iso-8859-1 Hallo Max.
Yes, P9 is plan analyzer. The other LMP code I know is DT for Detector.
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r Asst. Chairman GSE Workinggroups DB2 Nord und Sued ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- »"Next time you think you're perfect - try walk on water!"« [...]
3363 21 57_Re: AW: [DB2-L] Quick question about CA product LMP codes10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 4 Jan 2006 11:28:50 +0100332_US-ASCII Hi Peter
yes I need a table to find corrispondence between a product name (PLAN ANALYZER for instance) and the LMP code (P9 for instance) inserted in the KEYS member of PPOPTION file and activated in CAIRIM, but I'm not able to find this table of corrispondence....
Thank you for reply
Max Scarpa [...]
3385 56 65_AW: [DB2-L] AW: [DB2-L] Quick question about CA product LMP codes19_Weber, Thomas (LDS)23_Thomas.Weber@LDS.NRW.DE30_Wed, 4 Jan 2006 11:42:05 +0100714_US-ASCII Hi Max,
found a list in SupportConnect: http://supportconnectw.ca.com/public/ca_common_docs/tlckeyreg/tlc-topscodes.asp
Is that what you wanted?
Regards
Thomas
> -----Ursprungliche Nachricht----- > Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]Im > Auftrag von Max Scarpa > Gesendet: Mittwoch, 4. Januar 2006 11:29 > An: DB2-L@WWW.IDUGDB2-L.ORG > Betreff: Re: [DB2-L] AW: [DB2-L] Quick question about CA product LMP > codes > > > Hi Peter > > yes I need a table to find corrispondence between a product name (PLAN > ANALYZER for instance) and the LMP code (P9 for instance) > inserted in the > KEYS member of PPOPTION file and activated in CAIRIM, [...]
3442 17 69_Re: AW: [DB2-L] AW: [DB2-L] Quick question about CA product LMP codes10_Max Scarpa16_mscarpa@CESVE.IT30_Wed, 4 Jan 2006 11:50:34 +0100596_US-ASCII Perfect ! It's what I needed (even for non DB2 products)
Thank you very nuch & best regards
Max Scarpa
--------------------------------------------------------------------------------- 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
3460 176 30_Re: xLOBs and daily management14_Steurs Patrick21_Patrick.Steurs@NBB.BE30_Wed, 4 Jan 2006 13:11:30 +0100421_us-ascii Hi Roland,
Problem: after a reorg of a LOB on second level of high level spacemap page does not seem to be consumed; he just gets bigger and bigger taking extends. ( we are on db2 v7 sp1 ) For us, this is a problem, as we do lot of inserts & deletes of tables containing lobs. To avoid extending these lob-tablespaces, we created a drop-recreate-procedure for these lob-tablespaces. This works fine. [...]
3637 133 14_Re: Encryption17_Travis Bindenagel31_Travis.Bindenagel@EAC-EASCI.ORG30_Wed, 4 Jan 2006 07:34:51 -0600510_us-ascii I believe Marriott Vacation Club members would argue that backup tape security is very important. We are currently in the process of eliminating backup tapes and piping everything to a secure SAN where the backups are then encrypted, even though they remain on our LAN.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Taddei, Cathy Sent: Tuesday, January 03, 2006 3:56 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Encryption [...]
3771 70 36_DB2 V7 on z/OS - Question about view15_Alex, Aristotle21_db2_learner@YAHOO.COM30_Wed, 4 Jan 2006 05:58:04 -0800482_iso-8859-1 Hello list, The problem is kind of big. I try to explain as much as i can. I have two views A, B with the same definition. Both are running ok if not very fast. It is a join with 5 tables accessing 80 mil, 20 mil, 10 mil, 20 mil rows in each table. The access path seems to be ok and when i query from these two views its ok. I am getting the result in a quick time. The third view C has the union of these two with UNION (not union all) something like this: create [...]
3842 156 14_Re: Encryption12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 4 Jan 2006 06:18:59 -0800608_iso-8859-1 Cathy, I'll agree with you that identity theft from backup tapes isn't that major. But the loss of backup tapes and the associated data from them from couriers and other supposed secure transport mechanisms has happen to several major companies in the last 6 months to a year. And the issues and concerns of the customers of those companies is very real. As someone else mentioned, the Marriot Vacation Club members were not happy about the potential exposure. And there were literally hundreds of thousands of people exposed to these issues. I personally had exposure due to Bank of America [...]
3999 71 33_Client-Server ==> FUNNY SITUATION12_Anurag Kumar22_kumaranurag@HSBC.CO.IN30_Wed, 4 Jan 2006 20:11:11 +0530519_US-ASCII ___________________________________________ ENVIRONMENT ___________________________________________
(1) Server = DB2 UDB DPF, 8.2.3 on AIX, 64-bit instance. (2) Client = DB2 RTC 8.1 FP10 on AIX, 64-bit instance.
___________________________________________ PROBLEM ___________________________________________ (1) 1st, 3rd, 5th....attempts to connect to server database are successful. (2) 2nd, 4th, 6th...attempts to connect to server database return tcp/ip error. Error Message is as below: [...]
4071 92 37_Re: Client-Server ==> FUNNY SITUATION12_Martin, Paul22_Paul.Martin@ECOLAB.COM30_Wed, 4 Jan 2006 08:46:35 -0600429_us-ascii Could it be the ports\channels on the mainframe servicing this have two assigned and it is doing something like load balancing and one works and the other doesn't? Paul
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Anurag Kumar Sent: Wednesday, January 04, 2006 8:41 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Client-Server ==> FUNNY SITUATION [...]
4164 98 37_Re: Client-Server ==> FUNNY SITUATION50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Wed, 4 Jan 2006 09:47:25 -0500489_us-ascii I have had similar problems in the past: Could be incorrect I/P address or port or both; One resolution was to recycle the server. The Sqlstate was 08001/08003
I would be interested in the final solution
Bob Knight
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Anurag Kumar Sent: Wednesday, January 04, 2006 9:41 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Client-Server ==> FUNNY SITUATION [...]
4263 51 32_Re: Access path and index choice15_Patrick Bossman18_bossman@US.IBM.COM30_Wed, 4 Jan 2006 09:04:56 -0600640_ISO-8859-1 Hello, I want to make sure a few things are clear based on Larry's response.
1) Multi-column cardinalities collected with KEYCARD (and/or COLGROUP) helps the optimizer with uniform correlation. The MAKE and MODEL example is generally used as a correlation example, because only Toyota makes 4-Runners trucks.
2) Frequencies are similiar to histograms, and they are very useful for data skew situations. (Eg. A lot more people live in Los Angeles, CA than Fargo, ND. Frequencies would indicate that the value "Los Angeles, CA" has more occurences than "Fargo, ND" if frequencies were collected on CITY, STATE). [...]
4315 129 37_Re: Client-Server ==> FUNNY SITUATION11_Jay Reavill23_Jay.Reavill@CERTEGY.COM30_Wed, 4 Jan 2006 10:32:38 -0500458_us-ascii The only time I've seen a similar situation is when a connection is forced off. After the force it typically would take 2 connect attempts to be successful. Could it be that the connections are somehow being forced off or not terminating cleanly?
---------------------------------------- Jay Reavill DBA Certegy Card Services 11601 Roosevelt Blvd. St. Petersburg, FL. 33716 Office (727) 227-2144 ---------------------------------------- [...]
4445 28 15_working with v810_Bill Brown21_db2_dba@BELLSOUTH.NET30_Wed, 4 Jan 2006 09:38:21 -0600323_- we have v8 new function mode installed on a test lpar and i started playing around with it. i updated my plan table for all of the new column lengths and new columns and started playing around with explain. now the fun part. just using one column in my example, progname, which changed from char(8) to varchar(128). [...]
4474 71 19_Re: working with v89_Mike Bell21_mbell11a1@VERIZON.NET30_Wed, 4 Jan 2006 10:08:38 -0600471_Windows-1252 What I did was change all my selects to substr(progname,1,8) as progname ,etc SPUFI and TEP2 all space the columns based on the maximum size defined for the table. The SUBSTR changes the maximum size returned. STRIP removes the trailing blanks (which mostly don't exist) but won't change the maximum size. At some point, progname, creator id's etc will exist with lengths greater than 8 but by then who knows what version of DB2 and Z/OS we will be on. [...]
4546 45 16_DB2LOOK question27_DB2 Database Solutions Port26_db2dba_certified@YAHOO.COM30_Wed, 4 Jan 2006 08:17:29 -0800384_iso-8859-1 List: Happy New Year.
Ref: UDB V8.2/Win2003
db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch of views and indexes.
Even I tried from control-center (gui) to generate DDLs for entire Database specifying user all-users and creator schema1.(I generate auth statements etc too)
What am I missing here. Please advise. [...]
4592 138 20_Re: DB2LOOK question13_Crissy, Frank28_Frank_N_Crissy@HOMEDEPOT.COM30_Wed, 4 Jan 2006 11:21:36 -0500405_US-ASCII I use -d -a -e -x -l -o and get everything except stored procs and triggers. I don't think db2look supports those yet. Frank
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2 Database Solutions Port Sent: Wednesday, January 04, 2006 10:17 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2LOOK question [...]
4731 82 20_Re: DB2LOOK question19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM30_Wed, 4 Jan 2006 08:46:26 -0800741_us-ascii On DB2 V8.2 Win2003, I use "db2look -d -a -e -l -x -f >> " and it generates stored procedures and triggers.
Mike ----- Original Message ---- From: "Crissy, Frank" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, January 04, 2006 11:21:36 Subject: Re: [DB2-L] DB2LOOK question
I use -d -a -e -x -l -o and get everything except stored procs and triggers. I don't think db2look supports those yet. Frank -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2 Database Solutions Port Sent: Wednesday, January 04, 2006 10:17 AM To: DB2-L@www.idugdb2-l.org Subject: [DB2-L] DB2LOOK question [...]
4814 118 19_Re: working with v89_Agus Kwee19_askwe@OPTONLINE.NET30_Wed, 4 Jan 2006 12:14:24 -0500560_us-ascii I think the reason for SPUFI for instance to define the output size for substr(progname,1,length(progname)) as the maximum size (128) is because it already has to reserve an output area to print the columns of first result row, while it still doesn't know the length of the values of progname column of the subsequent result rows that it has not fetched yet. Substr(progname,1,8) tells SPUFI that we are only interested to see the first 8 characters of the progname column regardless of the actual size in the progname column of all result rows. [...]
4933 34 20_Re: DB2LOOK question13_Ian Bjorhovde23_ian.bjorhovde@GMAIL.COM30_Wed, 4 Jan 2006 09:59:30 -0700367_ISO-8859-1 On 1/4/06, DB2 Database Solutions Port wrote: > List: > Happy New Year. > > Ref: UDB V8.2/Win2003 > > db2look -d dbname -e -u db2admin -z schema1 -o filename -a is missing bunch > of views and indexes.
That's because you are effectively querying for objects
WHERE creator = 'DB2ADMIN' AND schema = 'SCHEMA1' [...]
4968 114 16_Partitioning ROT16_Trivedi, Kaushal34_Kaushal.J.Trivedi@CITIZENSBANK.COM30_Wed, 4 Jan 2006 13:25:58 -0500546_us-ascii Hi All,
I would like to know some ROT's for partitioning. While a partitioning column need to be one that provides a good partitioning is this the only criteria to be used ?, I have a table created that is partitioned on a column that gives it a good distribution of data across its partitions. Its is neither a unique column nor one that is used for clustering . Also its not a frequently used column either. The NPI defined on it is a unique and clustering index and is the one that is used frequently. My question is will [...]
5083 87 20_Re: Partitioning ROT14_Avram Friedman21_avramf@IBMSYSPROG.COM30_Wed, 4 Jan 2006 12:52:02 -0800407_iso-8859-1 My personal favorites would be 1. Choose a partitioning key that will randomly place any insert across the expanse of partitions. This will give better space usage, I/O performance, Parallelism potential etc.
2. Never make up an artificial key for the high level part of a partitioning index. PART-NUMBER or the like tend to very popular for a reason that has never been clear to me. [...]
5171 109 20_Re: DB2LOOK question19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM30_Wed, 4 Jan 2006 13:00:24 -0800477_us-ascii Forgot the [-td x] option... "db2look -d -a -e -l -x -f -td ? >> "
From db2look -h: -td: Specifies x to be statement delimiter (default is semicolon(;)) Should be used with -e option if triggers or SQL routines present
Mike
----- Original Message ---- From: Michael Piontkowski To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Wednesday, January 04, 2006 11:46:26 Subject: Re: [DB2-L] DB2LOOK question [...]
5281 86 57_Re: [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR13_Terry Purcell18_tpurcel@US.IBM.COM30_Wed, 4 Jan 2006 16:52:16 -0600392_- Hi Walter,
If you read the section in the Admin Guide, "Summary of predicate processing":
| Predicate Type | Index-|Stage | Notes | | | able? 1? | | ----------------------------------------------------------------- | T1.COL = T2 col expr | Y | Y | 6, 9, 11, 12, 14, 15 |
Note 15 refers to:
15. Under either of these circumstances, the predicate is stage 2: [...]
5368 42 54_ Determining updated columns in a trigger14_Wayne Driscoll34_wdriscoll@WESTERN-METAL-SUPPLY.COM30_Wed, 4 Jan 2006 19:31:29 -0600411_us-ascii I am trying to implement a trigger that will cause a column to be set UNLESS that column is being updated in the triggering statement.
Is this possible, or am I out of luck? I tried using old and new transitional variables and checking for the values being the same, but that wouldn't help in the situation where I am including the column in the update statmement just to avoid the update. [...]
5411 16 57_Re: [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE30_Thu, 5 Jan 2006 02:09:47 -0600724_- Hi Terry
Thanks for your explanation. It's amazing, I make a predicate more complex - encase a CASE-expression with a SUBSTR - and the predicate becomes stage1 and indexable.
And the quality of your analyses and responses is amazing too.
--------------------------------------------------------------------------------- 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
5428 15 58_Re: Determining updated columns in a trigger33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE30_Thu, 5 Jan 2006 02:16:39 -0600676_- Wayne
I think one option would be, to restrict the trigger on all but one column. And the only column excluded would be col4.
CREATE TRIGGER AFTER UPDATE of col1, col2, col3, col5 and so on
--------------------------------------------------------------------------------- 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
5444 78 40_Visual Explain 1.0.8 - download problems11_Roy Boxwell16_R.Boxwell@SEG.DE30_Thu, 5 Jan 2006 11:20:28 +0100368_us-ascii Hi Listers!
I am more of a mainframe guy than a PC guy so I have a question for you all. Has anyone successfully downloaded the 1.0.8 visual explain ? On the web site it says:-
DOWNLOAD: DB2 Visual Explain Version 8 (v.1.0.8, 2005/12/16)
and then after clicking through oodles of screens I finally get a screen that contains this :- [...]
5523 52 59_Visual Explain 1.0.8 - download problems - resolved - PBKAC11_Roy Boxwell16_R.Boxwell@SEG.DE30_Thu, 5 Jan 2006 11:39:20 +0100393_us-ascii Hi all!
IBM had indeed updated the download (Last week I guess) but have simply not updated the size of the download...Now I have 1.0.8 and all is OK in the world!
Roy Boxwell SOFTWARE ENGINEERING GMBH -Product Development- Robert-Stolz-Strasse 5 40470 Duesseldorf/Germany Tel. +49 (0)211 96149-0 Fax +49 (0)211 96149-35 E-mail r.boxwell@seg.de Homepage www.seg.de [...]
5576 77 50_Important Information Regarding IDUG 2006 - Europe32_=?iso-8859-1?q?Marcel=20L=E9vy?=24_marcel_idug_db2@YAHOO.FR30_Thu, 5 Jan 2006 14:29:19 +0100631_iso-8859-1 Important Announcement! IDUG 2006 - Europe Location and Dates Have Changed!
Due to a schedule conflict with IBM's recently announced consumer conference "Information On Demand Global Conference," IDUG 2006 - Europe has made the important decision to change the dates and location of its 2006 conference.
IDUG's desire to deliver an event of maximum value to participants, speakers and vendors serves as the primary reason for this change. The IDUG 2006 - Europe conference will continue to serve as the region's premier venue for training and peer networking for DB2 Universal Database professionals. [...]
5654 18 54_Re: Important Information Regarding IDUG 2006 - Europe10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 5 Jan 2006 14:45:11 +0100657_US-ASCII WOW ! Maybe it's a good occasion for some DB2er to beat me 'live' !!! :-)))
Very nice news ! But why not in Venice....?:-))) Oh well, it's the same.....
Max Scarpa
--------------------------------------------------------------------------------- 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
5673 61 62_AW: [DB2-L] Important Information Regarding IDUG 2006 - Europe12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 5 Jan 2006 14:54:02 +0100696_iso-8859-1 No, Max.
It is THE great chance to have a good glas of wine or beer or champagne together !
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r Asst. Chairman GSE Workinggroups DB2 Nord und Sued ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Development and Product Support (E3) Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- »"Next time you think you're perfect - try walk on water!"« [...]
5735 279 70_Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.13_Mackey, Glenn20_GMackey@GUIDEONE.COM30_Thu, 5 Jan 2006 07:46:07 -0600612_us-ascii
Hello,
Does anyone know of a method to access SQLServer from the z/OS environment.
One suggestion was a direct ODBC connection via "mainframe" DB2Connect - but I am unfamiliar with such a beast at this point. Second option was to use "Websphere Information Integrator. Basic steps involve installing Websphere II, federate to SQL Server, then you can access from z/OS just like the data was on DB2 UDB using DRDA calls. You could also do bidirectional replication between the DB2/390 and SQL Server. " I have never done this - but has anyone else. ------------------- [...]
6015 20 66_Re: AW: [DB2-L] Important Information Regarding IDUG 2006 - Europe10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 5 Jan 2006 15:03:53 +0100364_US-ASCII MMMhhhh at Unione Sarda in Basento Street ? Be aware,you've to skip noon meal....It's a pity it'll be far from Venice (well only 4 hours of train) otherways we could eat some good fish and excellent Prosecco.....
I asked to my boss for IDUG partecipation and there's a good possibility to be there to be beaten. The line is loonnngggg.....:-( [...]
6036 28 14_Re: Encryption13_Arnold, Kevin17_karnold@OPERS.ORG30_Thu, 5 Jan 2006 09:07:29 -0500423_Windows-1252 >From what I've been reading about DB2 V8 encryption and the hardware assists, >it doesn't seem to be that much of a performance penalty, provided (and here's >a major assumption) the programmers access the encrypted data correctly.
Myron,
What would you consider to be the "correct" means to access the data in this context? Wouldn't developers generally have access to the encryption key? [...]
6065 86 34_converting SPAS to WLM - thoughts?15_Chris Hoelscher21_choelscher@HUMANA.COM30_Thu, 5 Jan 2006 09:19:34 -0500447_US-ASCII we are currently on DB2 7.x - in preparation for migration to release 8, we are moving from an SPAS address space to WLM address space(s) for stored procedures I have recommendations from IBM and my own thoughts on how to split up the existing SPs into WLM environments, but I hope never to be too arrogant to not to ask for (or refuse) advise from others - generally - what criteria have others used to set up the WLM environments? [...]
6152 84 14_Re: Encryption14_Andy Lankester26_alankester@CDBSOFTWARE.COM30_Thu, 5 Jan 2006 08:24:44 -0600374_Windows-1250 This is a much wider question. Editproc/Fieldproc based encryption is transparent to users/developers since when the row is in its page it is encrypted (i.e. in the buffer pool, DASD cache, DASD, image copy etc). The moment the row/column needs to be processed to apply predicates etc it must be decrypted and is passed across the SQL interface decrypted. [...]
6237 211 38_Re: converting SPAS to WLM - thoughts?0_25_LL581@DAIMLERCHRYSLER.COM30_Thu, 5 Jan 2006 09:51:15 -0500451_US-ASCII Chris,
There are several different ways of support WLM-managed stored procedures. A lot depends on the numbers of SPs that you support, how CPU- and I/O-intensive they are, and how confident you are that they are written well :)
For what it's worth, here is what I have always recommended -- you can start with this as a base, and customize from there. ("# Appl Env" is the number of defined WLM Application Environments.) [...]
6449 70 41_runstats columns faroffpos& zos/390 db2v714_Neff Stephen R22_Stephen.R.Neff@IRS.GOV30_Thu, 5 Jan 2006 09:52:37 -0500562_- Hello,
Here is my situation. I run runstats with the following syntax RUNSTATS TABLESPACE database.tablespace INDEX(ALL) TABLE(ALL) SAMPLE 25 SHRLEVEL(CHANGE). I then check the index statistics in SYSIBM.SYSINDEXPART. Certain columns still have a -1 and these columns are CARD FAROFFPOS & NEAROFFPOS. The STATSTIME is populated with the time the runstats job was run. Why would these columns not have stats? I do the same syntax with other table spaces and the columns do have stats. Does RUNSTATS populate these columns differently and if so why. [...]
6520 113 58_Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v711_Roy Boxwell16_R.Boxwell@SEG.DE30_Thu, 5 Jan 2006 15:56:43 +0100340_us-ascii very simply put - These columns are no longer supported. You should use the F columns eg CARDF, FAROFFPOSF etc If you look in the manual SQL Reference you will see that these field names no longer exist in the table descriptions. This means that the contents "might be ok" or "might be rubbish" or "might be 10 years old".... [...]
6634 332 74_Re: Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM30_Thu, 5 Jan 2006 08:31:07 -0700520_us-ascii We currently use Information Integrator to access SQLServer data from z/OS applications and it works well. I don't know all the details of setting up the II instance, as I do the DB2 z/OS support and not the LUW, but yes, if you set up the nicknames in the II instance to point to the SQLServer data, then you can access that data from z/OS just as if it was data in a DB2 LUW instance. I get involved in this because I put the location information in the z/OS DDF tables to point down to the II instance. [...]
6967 96 21_Settle a "discussion"18_McBride, Catherine18_CMcbride@KABLE.COM30_Thu, 5 Jan 2006 09:32:26 -0600488_iso-8859-1 Hi, DB2 people,
Please help me settle a "discussion". We are DB2 UDB 8.1 running under AIX 5.2. I am of the belief that in order to restore an individual table from backups, we first need to restore the database to another disk area and then grab the table from there. We do not use individual table spaces for each table, and we do not back up at the table space level. We back up at the database level. Someone won't believe me. Am I at least marginally correct? [...]
7064 464 74_Re: Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.58_=?iso-8859-9?Q?Serdar_Sabri_=D6zkubulay_=28B.T.S.Y.G.=29?=27_Serdar.Ozkubulay@AKBANK.COM30_Thu, 5 Jan 2006 17:50:01 +0200434_iso-8859-9 Barbara, Do you know does II support two phase commit between z/OS DB2 v7.1 and SQL Server 2000 or SQL Server 2005?
Serdar
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Barbara Koenen Sent: Thursday, January 05, 2006 5:31 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Access SQLServer from z/OS: And a word on DB2 - SQLServer performance. [...]
7529 163 25_Re: Settle a "discussion"12_John Lendman27_lendman@PALMBEACH.K12.FL.US30_Thu, 5 Jan 2006 10:47:39 -0500522_iso-8859-1 You have two options when restoring. Database or Tablespace
John C. Lendman IBM Certified Solutions Expert IBM Certified Database Administrator DB2 Universal Database V8.1 for zOS Office 561-357-7523 Cell 772-485-1592 Email lendman@palmbeach.k12.fl.us
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of McBride, Catherine Sent: Thursday, January 05, 2006 10:32 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Settle a "discussion" [...]
7693 173 25_Re: Settle a "discussion"31_Owens, Craig, CTR, OASD(HA)/TMA27_Craig.Owens.ctr@TMA.OSD.MIL30_Thu, 5 Jan 2006 08:52:49 -0700706_us-ascii Cathy,
Yes, you are correct.
I'm sure you're aware that export could be used on the individual table for restores.
Regards, Craig Owens.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McBride, Catherine Sent: Thursday, January 05, 2006 8:32 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Settle a "discussion"
Hi, DB2 people,
Please help me settle a "discussion". We are DB2 UDB 8.1 running under AIX 5.2. I am of the belief that in order to restore an individual table from backups, we first need to restore the database to another disk area and then grab the table [...]
7867 55 25_Re: Settle a "discussion"13_Tim Brumfield23_brumfit@DFA.STATE.MS.US30_Thu, 5 Jan 2006 09:38:49 -0600287_US-ASCII I'm running DB2 8.1 under AIX 5.1 and am using "circular logging" as I think you are. You are entirely correct that in order to restore a single table from such a backup you have to restore the entire database and then grab that table from there. I've had to do it myself. [...]
7923 201 62_Re: Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v714_Neff Stephen R22_Stephen.R.Neff@IRS.GOV30_Thu, 5 Jan 2006 11:04:34 -0500301_- Hello , Thank you for your response. I looked at the stats that were populated and compared the columns CARD FAROFFPOS & NEAROFFPOS with CARDF FAROFFPOSF & NEAROFFPOSF and they were equal. It appears that RUNSTATS did populate stats correctly for these non F columns when it did populate them. [...]
8125 356 38_Re: converting SPAS to WLM - thoughts?12_Phil Gunning22_pgunning@GUNNINGTS.COM30_Thu, 5 Jan 2006 11:52:36 -0500497_us-ascii Chris, The Administration Guide has some good recommendations and there is a Workload Management manual that will describe how to setup WLM. Also, some old redbook that will help to describe the WLM concept. Of course some things have changed with V8. Cheers, Phil
www.gunningts.com/db2zone.htm
610.451.5801 Fax 514-509-6886
"We help people succeed with DB2" [...]
8482 376 62_Re: Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v712_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM30_Thu, 5 Jan 2006 10:53:58 -0600391_us-ascii Hi Steve,
We are DB2 V7 on z/OS as well. We have seen something like this,
and I thought that RUNSTATS was leaving some of the stats columns
un-populated on tables where we specify SAMPLE 25. But I just found this
little gotcha in the V7 Utility Guide manual,
RUNSTATS sets the following columns to -1 for large table spaces. [...]
8859 115 28_UDB V8.2 on AIX 5.2 question14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM30_Thu, 5 Jan 2006 13:10:30 -0500383_- To folks using UDB V8.2 (FP 7 or higher) on AIX 5.2, I have a question.
Are you folks using the "NO FILE SYSTEM CACHING" option for DMS tablespaces defined on filesystems (not raw devices) ? This option is available from V8 FP7 onwards.
We recently migrated from a 4-node database (pre- v8 fp7) using raw devices to a 8-node database (v8 fp9) using filesystems. [...]
8975 107 19_Re: working with v813_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Thu, 5 Jan 2006 14:12:18 -0500496_- I created views with
substr(xxx,1,??) as xxx
as Mike mentioned for all the catalog tables I use heavily. You could do the same for plan_table.
When I need to see > 8 or 30, I use the underlying tables.
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Wednesday, January 04, 2006 11:09 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] working with v8 [...]
9083 36 47_Un-validated Transaction Table requiring update14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM30_Thu, 5 Jan 2006 13:18:41 -0600492_US-ASCII Folks, There are always these unexpected requests....
"We need to store an orders transaction file which the user may want to update."
After asking the obvious questions :- this file could contain invalid data there are related tables, but since the data has not been validated, I could not have any RI they also want an update log file (I haven't offered any solution here yet as I am still grappling with the idea of having something dirtying up my creation :-) [...]
9120 224 62_Re: Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v714_Avram Friedman21_avramf@IBMSYSPROG.COM30_Thu, 5 Jan 2006 11:56:40 -0800369_iso-8859-1 At one time in DB2 history there was quite a diffrence between RUNSTATS TABLESPACE db.ts TABLE ALL INDEX ALL vs RUNSTATS INDEX (ALL) TABLESPACE db.ts
There are many stats that the second case updates but the first case does not. In the V8 utility manual this appears to be still documented in section 2.27.24 Reviewing RUNSTATS output Table 101. [...]
9345 81 51_Re: Un-validated Transaction Table requiring update9_Mike Bell21_mbell11a1@VERIZON.NET30_Thu, 5 Jan 2006 14:03:51 -0600452_Windows-1252 A couple of business questions how much effort is it to recreate the order information? how critical is the data if an order gets dropped and doesn't get completed.
I had a design where we had an incomplete transaction table that could be processed multiple times as the order entry collected the data. As you would expect all fields were nullable, no RI , and the actual completed transaction had a completely different home. [...]
9427 414 32_Re: UDB V8.2 on AIX 5.2 question13_Dan Pamintuan24_Dan.Pamintuan@PUBLIX.COM30_Thu, 5 Jan 2006 15:06:20 -0500330_iso-8859-1 We are using DMS tablespaces with SAP on AIX. We also have "NO FILE SYSTEM CACHING" turned on. In our case, we have the mount option set to CIO. This is the same thing. There is a great white paper out there in cyberspace on CIO and DB2 at http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408lee/ [...]
9842 318 74_Re: Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM30_Thu, 5 Jan 2006 13:40:59 -0700474_us-ascii Another lister asked if II supports two phase commit between DB2 on z/OS and SQLServer. My sources say no, but I would assume the manuals for II would verify that.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mackey, Glenn Sent: Thursday, January 05, 2006 7:46 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Access SQLServer from z/OS: And a word on DB2 - SQLServer performance. [...]
10161 432 48_Re: DB2/UDB Datawarehouse specialist(headhunter)14_Michael Mantel21_MichaelM@EDPWORLD.COM30_Thu, 5 Jan 2006 16:01:30 -0500612_-
Location Employment Type
New York Full Time Regular
Requirements
Department Description
The Business Solutions group is responsible for all data aggregation and MIS reporting for Global Sales across multiple divisions including Fixed Income, Foreign Exchange, Commodities, Investment Banking and Equities. This includes processing data feeds as well as reporting across salespeople, clients, and products back to the business and the Executive Office. The team is global in nature [...]
10594 128 51_Re: Un-validated Transaction Table requiring update14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM30_Thu, 5 Jan 2006 15:20:07 -0600475_US-ASCII Mike, It is critical, and we need a log of any changes to the original transaction. I will make sure there is a purge process in place too.
These and the recovery options are reason enough to allow this into DB2. thanks, Mark.
Mike Bell Sent by: DB2 Data Base Discussion List 01/05/2006 02:03 PM Please respond to DB2 Database Discussion list at IDUG [...]
10723 428 32_Re: UDB V8.2 on AIX 5.2 question14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM30_Thu, 5 Jan 2006 16:21:52 -0500377_- This is indeed a very good document. We just had a conf call with IBM and they confirmed much of this. Thanks for the info.
Abhijit
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dan Pamintuan Sent: Thursday, January 05, 2006 3:06 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] UDB V8.2 on AIX 5.2 question [...]
11152 142 39_Re: Encryption (db2v7 z/OS perspective)15_Philip Sevetson22_db2.dba.guru@GMAIL.COM30_Thu, 5 Jan 2006 16:37:30 -0500354_ISO-8859-1 Smike and all,
We're going with two types of encryption. For our backup tapes and other media which go offsite, we're encrypting at the volume level. For the PCI (Personal Card Industry) standard, we're going with a vendor who offers column-level strong encryption to protect customer-confidential data from remote hacker attacks. [...]
11295 114 30_Re: xLOBs and daily management31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL30_Thu, 5 Jan 2006 22:43:42 +0100641_us-ascii Max,
Make sure you have the latest Redbook version. There is only a small change in the old one, with huge consequences for space management.
Below some snaps from my other replies concerning LOB's:
>>>>>>>>>>>>>>> Some other considerations: Be aware that REORG of LOB Tablespaces works different. Because of this you might want to consider using a small number for DSSIZE. Also check the PTF's concerning LOB's, there are some still open. Consider using VIEW's with UNION for the LOB Table(s) and for better maintenance separate your meta data from the LOB data. We are using LOB's intensively, 2,5 Tbyte [...]
11410 64 25_DB2 Template for Tape GDG12_Smith, Allan23_Allan_Smith@KYFBINS.COM30_Thu, 5 Jan 2006 16:57:18 -0500479_us-ascii We have a job that has been creating tape full image copy GDG's. The GDG is defined with a limit of 30. Since using the template, the GDG have been expiring after 5 days (system default), instead of rolling off after the 30th generation. Does anyone have a sample Template so that the GDG will roll off after 30 generations? We have tried the EXPDL '9999000' and got a dynamic allocation error. We have no problem with GDG's on DASD. Any ideas will be appreciated. [...]
11475 132 29_Re: DB2 Template for Tape GDG14_Allen, Susan A24_susan.a.allen@BOEING.COM30_Thu, 5 Jan 2006 14:02:02 -0800335_us-ascii the tape retention is for 5 days; increase it to 31 Or 30 or some number closer to the frequency of generations to days -- if you create 6 generations per week; then you require 30/6 = 5 weeks leading to 5*7 = 35 days
Susan
I love comparing generations to retention periods; messes folks up all of the time [...]
11608 185 74_Re: Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.9_Tony Saul30_generalemaillists@YAHOO.COM.AU30_Fri, 6 Jan 2006 09:05:46 +1100639_iso-8859-1 Glenn,
I was looking for similar information for a project coming up and found this article http://www.databasejournal.com/features/mssql/article.php/10894_1756161_1 . I haven't had a chance to try it out yet, and the date looks a little old, but it may offer some insights.
--- "Mackey, Glenn" wrote:
> > > Hello, > > Does anyone know of a method to access SQLServer > from the z/OS > environment. > > One suggestion was a direct ODBC connection via > "mainframe" DB2Connect - > but I am unfamiliar with such a beast at this point. > Second option was to use "Websphere [...]
11794 308 29_Re: DB2 Template for Tape GDG12_Marcia Crisp16_MA-Crisp@WIU.EDU30_Thu, 5 Jan 2006 16:17:45 -0600652_US-ASCII Allan,
Do you have GDGLIMIT(30) specified in your TEMPLATE?
Here is a sample of what I use. It works for me here!
TEMPLATE ICDAILY
UNIT TAPE
DSN 'XXX.YY.&DB..&TS..D&PA(2)..DB2(+1)'
DISP (NEW,CATLG,CATLG)
STACK YES
MODELDCB SYST.MODEL.DSCB
GDGLIMIT(30)
Regards,
Marcia Crisp
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smith, Allan Sent: Thursday, January 05, 2006 3:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Template for Tape GDG [...]
12103 23 28_Displaying SQL when Abending17_No Name Available27_Neeraj.Peddu@CA.FUJITSU.COM30_Thu, 5 Jan 2006 17:19:21 -0500
12127 64 29_Re: DB2 Template for Tape GDG0_18_cristian@MOLARO.BE30_Fri, 6 Jan 2006 02:32:46 -0600407_- Hi Allan,
We have an automatic process that generates SYSIN for Full or Incremental copies based on RTS. Here you have an extract showing our Template where copies are going to tape. We don't use a GDG, but we control the retention period with the RETPD parameter...
"RETPD integer Specifies the retention period in days for the data set. The # integer value must be between 0 to 9999" [...]
12192 145 47_SOLUTION TO "Client-Server ==> FUNNY SITUATION"12_Anurag Kumar22_kumaranurag@HSBC.CO.IN30_Fri, 6 Jan 2006 14:28:11 +0530393_US-ASCII For the benefit of all, I am posting the resolution (which was ridiculously easy) __________________________________________ SOLUTION _______________________________________ I do not know how, but there were two NIC's configured to the same DNS and one of them was not cabled into the network. The connection was doing a round robin type connection and failing every other time. [...]
12338 42 29_Re: DB2 Template for Tape GDG13_William Huang24_hhuang@DCCSH.ICBC.COM.CN30_Fri, 6 Jan 2006 17:01:59 +0800381_US-ASCII Allan
There are some parameters, inside or outside of DB2, can impact your retain period, including your GDG base definition, DB2 TEMPLATE RETPD/EXPDL, GDGLIMIT, and your tape management software config, ... The first arrival one takes effect, so you may check all.
HTH
---------------------------------------------------------------------------------
12381 25 32_Re: Displaying SQL when Abending15_Cristian Molaro18_cristian@MOLARO.BE30_Fri, 6 Jan 2006 03:16:06 -0600297_- Hi Neeraj,
Found in the Admin Guide V7: " You can use the subroutine DSNTIAR to convert an SQL return code into a text message. DSNTIAR takes data from the SQLCA, formats it into a message, and places the result in a message output area that you provide in your application program" [...]
12407 28 45_Re: runstats columns faroffpos& zos/390 db2v710_Alan Smith20_alancsmith@GMAIL.COM30_Fri, 6 Jan 2006 03:34:05 -0600674_- The columns all have floating point equivalents - if you look at CARDF, FAROFFPOSF, and NEAROFFPOSF, they should all be populated.
Alan
On Thu, 5 Jan 2006 09:52:37 -0500, Neff Stephen R wrote:
>Hello, > > Here is my situation. I run runstats with the following syntax >RUNSTATS TABLESPACE database.tablespace INDEX(ALL) TABLE(ALL) SAMPLE 25 >SHRLEVEL(CHANGE). >I then check the index statistics in SYSIBM.SYSINDEXPART. Certain columns >still have a -1 and these columns are CARD FAROFFPOS & NEAROFFPOS. The >STATSTIME is populated with the time the runstats job was run. Why would >these columns not have stats? I do the [...]
12436 158 37_DB2 V7.1 on ZOS 1.6 Visual Explain V816_Proctor, William25_william.proctor@TGSLC.ORG30_Fri, 6 Jan 2006 07:15:18 -0600445_us-ascii Thanks for all replies in advance. I have an sql statement in a SAS job that when I first Explained it show to use 250,000 CPU MS and was doing a table space scan on a table with 51 million rows. I modified the sql in visual expain and got the cost down to 51,000 CPU MS and then made a further change and got it down to 7.000 CPU MS. This sounds real good but when we run the job it actually runs a lot longer. Why would this be? [...]
12595 39 28_[z/OS] Unload & LIMIT option22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET30_Fri, 6 Jan 2006 15:28:48 +0200613_iso-8859-9 Hello List,
I tried to use the LIMIT option of UNLOAD utility.
According to the manual, I expected that the utility will be completed after it has reached the LIMIT since the TS has only one table. vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv vvvvvv If the number of unloaded rows reaches the specified limit, message DSNU1201 is issued for the table and no more rows are unloaded from the table. The process continues to unload qualified rows from the other tables. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^ [...]
12635 200 41_Re: DB2 V7.1 on ZOS 1.6 Visual Explain V812_Isaac Yassin20_yassini@BEZEQINT.NET30_Fri, 6 Jan 2006 15:52:25 +0200462_us-ascii Hi,
It teaches you that the price is not always the best way to decide :-) You need to compare the access paths (before / after) to understand what's going on.
Isaac Yassin
_____
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Proctor, William Sent: Friday, January 06, 2006 3:15 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V7.1 on ZOS 1.6 Visual Explain V8 [...]
12836 100 29_Re: DB2 Template for Tape GDG19_Jardine, Lawrence J19_JardineLJ@AETNA.COM30_Fri, 6 Jan 2006 09:04:50 -0500713_US-ASCII Try...
EXPDL '1999000' GDGLIMIT(30)
Larry Jardine Production DBA
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smith, Allan Sent: Thursday, January 05, 2006 4:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Template for Tape GDG
We have a job that has been creating tape full image copy GDG's. The GDG is defined with a limit of 30. Since using the template, the GDG have been expiring after 5 days (system default), instead of rolling off after the 30th generation. Does anyone have a sample Template so that the GDG will roll off after 30 generations? We have tried [...]
12937 479 41_Re: DB2 V7.1 on ZOS 1.6 Visual Explain V816_Proctor, William25_william.proctor@TGSLC.ORG30_Fri, 6 Jan 2006 08:14:11 -0600343_us-ascii I have 3 tables involved. Table 1 has 51 million rows, Table 2 has 6 million rows and then Table 3 has 500 rows. In the original sql it shows to be doing a table scan on table 1 then using a nested loop join using an index matching columns 1 with table 3 and then doing a hybrid join using an index matching 1 column on table 2. [...]
13417 215 29_Re: DB2 Template for Tape GDG12_Smith, Allan23_Allan_Smith@KYFBINS.COM30_Fri, 6 Jan 2006 09:29:39 -0500699_us-ascii We just tried that on our test system; it appears to be working.
Thanks
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jardine, Lawrence J Sent: Friday, January 06, 2006 9:05 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Template for Tape GDG
Try...
EXPDL '1999000' GDGLIMIT(30)
Larry Jardine Production DBA
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smith, Allan Sent: Thursday, January 05, 2006 4:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Template for Tape GDG [...]
13633 37 21_DB2 V8 ENFM migration12_George Palko16_gpalko@OPERS.ORG30_Fri, 6 Jan 2006 08:38:42 -0600557_- Hi,
I'd like to thank everyone who answered my previous question concerning DBRM mode compatibility within V8.
I have an additional question concerning the V8 migration. As I stated in my previous post, we're in a situation where a number of our third-party vendors are not willing, yet, to give us a date, as far as, when they will be exploiting V8 NFM. This has made us very reluctant to migrate to NFM. But, because of the time that is involved in migrating, we feel that we should begin the ENFM migration sooner rather than later. [...]
13671 71 25_Re: DB2 V8 ENFM migration13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Fri, 6 Jan 2006 09:11:14 -0600580_ISO-8859-1 I don't think there is a technical reason for quickly moving from ENFM to NFM. ENFM converts the catalog (Unicode and long names) and the recommendation is to test the conversion and move on so you can take advantage of the new SQL and other features of V8. NFM essentially mean the NEWFUN switch in DSNHDECP has been flipped from NO to YES and changes DBRMs from EBCDIC to Unicode. (Take a look at http://blogs.ittoolbox.com/database/db2zos/archives/007155.asp) So your migration is really completed in ENFM, you are just not letting anyone use any new features. [...]
13743 80 25_Re: DB2 V8 ENFM migration13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Fri, 6 Jan 2006 10:16:20 -0500360_- I think you'd be better off staying in Compatibility mode.
What is the motivation to get to ENFM where things are more complicated if you're not going to move into NFM? Why get all the long names in the catalog and unicode and virtually none of the benefits?
I don't think it is as if you are going to save any time getting to ENFM early. [...]
13824 138 66_DB2LOG Question - DB2UDB 8.1 FixPak 5 for LUW on AIX 5.2 using TSM23_Baskerville, Mark {PBG}26_Mark.Baskerville@PEPSI.COM30_Fri, 6 Jan 2006 10:22:11 -0500314_US-ASCII List;
We are running DB2 UDB 8.1 FP5 on AIX 5.2 using the userexit to archive logs to TSM. We have been working with IBM on correcting a communication problem with our TSM server that has prohibited us from archiving logs and taking backups for about a week (this is not a production system). [...]
13963 93 25_Re: DB2 V8 ENFM migration50_Costa, Marc --- Sr. Database Administrator --- CFS28_Marc.Costa@FREIGHT.FEDEX.COM30_Fri, 6 Jan 2006 08:31:28 -0700525_us-ascii George,
To my knowledge there is no issue of staying in ENFM for an extended period of time. At the tech conference I heard about one company that was planning on staying in CM for 6 months and ENFM for six months before going to NFM.
The real question I have is why are you migrating right now to V8 if it isn't to take advantage of the new features in version 8? Until you run DSNTIJNF, you aren't going to get the new features. Wouldn't you wait 6 months to a year to do this if you don't need [...]
14057 240 25_Re: DB2 V8 ENFM migration0_25_LL581@DAIMLERCHRYSLER.COM30_Fri, 6 Jan 2006 10:39:56 -0500371_US-ASCII George,
I'm fascinated by your comment, "a number of our third-party vendors are not willing, yet, to give us a date, as far as, when they will be exploiting V8 NFM." Uh, DB2 UDB for z/OS Version 8 went GA in March 2004. Most third-party vendors were given early versions of the code as early as January 2003. Isn't almost three years enough time ?! [...]
14298 39 25_Re: DB2 V8 ENFM migration12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM30_Fri, 6 Jan 2006 07:49:48 -0800426_us-ascii George:
The main reason for not completing the V8 conversion is that many 3rd party vendors can not support it. The only tools vendor, I am aware of, that has a complete set of fully functional and exploitive V8 tools is IBM. (Obviously I would not say this if our tools did not support and exploit V8.) You need to weigh input on this topic based on the economic position of the person giving the input. [...]
14338 91 32_Re: Displaying SQL when Abending17_Kumar Vaddadi/EIG37_Kumar.Vaddadi@ECONOMICALINSURANCE.COM30_Fri, 6 Jan 2006 10:50:57 -0500557_us-ascii
Hi,
You can also look at Db2 Application Programming & SQL guide (SC26 - 9933-05) Chapter 6 under the topic "Handling the SQL return codes" .
************* Thanks & Regards ******************* Vaddadi Shyam Kumar IBM Db2 Certified Database Administrator Data Management Group The Economical Insurance Group, Waterloo. Reach me @ 519-570-8500 ext 2242 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
14430 25 68_"SHRLEVEL REFERENCE" reorg of the SPT01 directory - message 00C201125_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Fri, 6 Jan 2006 09:59:09 -0600382_us-ascii We have version 8 in COMPAT mode installed and are expermenting with the catalog and directory reorganization (hopefully going forward fairly soon with NF mode).
When we ran a reorganization on SPT01, we encountered a 00C20112 return code. I see that this is a new code in the latest codes manual but I cannot find an explanation for this return code anywhere. [...]
14456 271 22_Question on DAS userid12_Levine, Mike29_Mike.Levine@DMS.MYFLORIDA.COM30_Fri, 6 Jan 2006 10:53:13 -0500374_us-ascii Hi,
I am setting up the DB2 Admin Server on zOS 1.6 and DB2 V7.1. Does anyone know if the DAS userid 'dasuser' needs to be a 'logonable' id or is there a way to 'switch' to this id from within OMVS as implied in the program directory? In other words do I need to actually logon to TSO with this id then get into OMVS and run the script? [...]
14728 473 56_Re: sql30081- Db2 v7 on Z/OS - db2udb v8 on Windows 200312_Rosina Porco17_rporco@UOTTAWA.CA30_Fri, 6 Jan 2006 11:51:01 -0500449_us-ascii Hi,
I have been looking for the answer for over a week and am really stuck. Your insight would be appreciated.
Mainframe z/os db2 v7
Windows 2003 Server : db2 udb V8.2 ( webpshere)
I am issuing a simple Select statement from the mainframe to Db2udb server
select * from Maadv.adminsys.address
The query works at times and other times I get the following error. [...]
15202 361 62_Re: Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v714_Neff Stephen R22_Stephen.R.Neff@IRS.GOV30_Fri, 6 Jan 2006 11:51:04 -0500364_- Hello, thank you for your response. The table I saw this in has a Maximum row length : 32714 and uses a 32k buffer pool. The table is partitioned. It was not defined as large table. We do have stats for CARD in SYSTABLES and FIRSTKEYCARD, FULLKEYCARD in sysindexes. But no stats for CARD in SYSINDEXPART FAROFFPOS in SYSINDEXPART NEAROFFPOS in SYSINDEXPART [...]
15564 136 74_Re: Access SQLServer from z/OS: And a word on DB2 - SQLServer performance.12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 6 Jan 2006 10:48:09 -0600575_- Just a minor comment on the performance. We don't optimize much for single thread performance, but rather for the more typical load of hundreds of tasks, with robust integrity and instrumentation. The power and value of a mainframe is in the ability to share the data, share the resources, be highly available, scalable and to take less time for people because the work is shared. I've been spending quite a bit of time doing the system maintenance on my pc, installing changes, ... that does not need to be done thousands of times on a mainframe. The more you share, [...]
15701 270 56_Re: sql30081- Db2 v7 on Z/OS - db2udb v8 on Windows 200312_McKown, John26_john.mckown@UICIINSCTR.COM30_Fri, 6 Jan 2006 11:00:22 -0600718_us-ascii Any chance that this is it? From IBMLink:
APAR Identifier ...... JR20108 Last Changed ........ 04/08/26 SVCENAME changed from db2cDB2 to db2c_DB2 (silent install of FP)
Symptom ...... IN INCORROUT Status ........... CLOSED PER Severity ................... 3 Date Closed ......... 04/08/26 Component .......... 5765F4101 Duplicate of ........ Reported Release ......... 810 Fixed Release ............ 999 Component Name DB2 UDB ESE WIN Special Notice Current Target Date .. Flags SCP ................... WIN Platform ............ WIN31/95 [...]
15972 122 32_Re: Displaying SQL when Abending13_Richard Fazio21_rfazio@TRANSUNION.COM30_Fri, 6 Jan 2006 11:03:58 -0600335_US-ASCII You may want to try adding a diagnostic output coupled with an SQLTRACE. Got a DB2 Monitor? Most monitors have some form of SQL capture...otherwise you could turn on some heinous SMF traces and try to pick out the detail yourself from GTF.
This should dump out connection / return code doc. //DSNTRACE DD SYSOUT=* [...]
16095 99 25_Re: DB2 V8 ENFM migration12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 6 Jan 2006 11:42:45 -0600431_- There is quite a bit of good information in the other responses. I'd like to twist on a couple of points. Vendors generally got the first code in October 2002, so that's more than 3 years ago. The customers started their early program in Feb 2003 for 14 months. V8 general availability is at 21 months now and counting. In ENFM, you have almost exactly the same function as in CM, since any new function DBRM will not BIND. [...]
16195 33 27_DB2 Z/os V8 Package Rebinds13_Dawn Kastelic26_dawn.kastelic@HIGHMARK.COM30_Fri, 6 Jan 2006 13:11:22 -0500554_us-ascii We will be moving to Compatibility Mode within the next few weeks with a target for ENFM in April We do not plan on rebinding all of our packages in Compatibility Mode. While in ENFM mode, if the packages have not been re-bound, when they get executed will they need to be expanded or converted to a version 8 format (since the catalog is now unicode?) Does this expansion need to take place every time the package gets executed and what type of overhead could this incur? If this is a concern, then we will consider re-binding a subset of [...]
16229 87 14_Re: Encryption12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 6 Jan 2006 12:15:45 -0600638_ISO-8859-1 We've added IBM Encryption Facility for z/OS, 1.1 lately and provided a statement of direction for more. The Encryption Services feature supports encrypting and decrypting of data at rest (tapes, disk) and supports either Public Key/Private keys or passwords to create highly secure exchange between partners. The Encryption Facility Client is Java™ technology-based code that allows client systems to decrypt and encrypt data for exchange with z/OS systems. The DFSMSdss Encryption feature allows encryption and compression of DUMP data sets created by DFSMSdss™. It supports decryption and decompression during RESTORE. [...]
16317 309 25_Re: DB2 V8 ENFM migration13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Fri, 6 Jan 2006 12:34:35 -0600454_us-ascii It seems that I mis-stated another thing in my post, sorry , typing too fast... I should know better than answer an e-mail before my first cup of coffee... LOL However, my blog has it stated correctly...
My last sentence is completely off base. Once you migrate to NFM, you can toggle back and forth between ENFM and NFM, but you do have to get to NFM first... CATENFM with COMPLETE does do a few "special" things when entering NFM. [...]
16627 27 25_Re: DB2 V8 ENFM migration11_Joan Keemle25_keemlejoant@JOHNDEERE.COM30_Fri, 6 Jan 2006 12:43:56 -0600429_- (OK, Willie, here is the post!)
For clarifiction -
If the DSNTIJNF job is not executed (DSNUTILB with CATENFM COMPLETE), you will not be able to precompile with NEWFUN=YES or use new function in dynamic SQL.
If DSNTIJNF has been executed, you can precompile with NEWFUN=YES or NEWFUN=NO and depending on what is specified, the DBRM is in EBCDIC or UNICODE. (Regardless of system default in DSNHDECP.) [...]
16655 61 31_Re: DB2 Z/os V8 Package Rebinds13_Keemle Joan T25_KeemleJoanT@JOHNDEERE.COM30_Fri, 6 Jan 2006 13:05:24 -0600332_us-ascii V8 uses a new format for plans and packages. Once in V8, whether CM, ENFM, or NFM, if the plan/package is in old V7 format, it will be expanded or "puffed" to the new format the first time accessed. A rebind would save this from happening at execution. It might also alleviate surprises with access path changes, etc. [...]
16717 172 48_DB2 z/os SQL stored procs without the C compiler13_Hodgin, Scott19_shodgin@SCFBINS.COM30_Fri, 6 Jan 2006 14:07:44 -0500337_- We just upgraded our DB2 for z/os to V8 CM.
Is the ability to create SQL stored procs for DB2 without needing a C compiler available in CM or do I have to be in ENFM?
I've tried creating an SQL stored proc on DB2 via Development Center, but it keeps stopping my WLM on the mainframe. [...]
16890 197 52_Re: DB2 z/os SQL stored procs without the C compiler13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM30_Fri, 6 Jan 2006 14:18:22 -0500497_- That's not until VNext, Scott. I think it's in v8.2 for Linux, Unix, & Windows but not until VNext on z/OS. That's according to Curt's presentation on VNext.
See Roger's links in the NFM/ENFM discussion.
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Hodgin, Scott Sent: Friday, January 06, 2006 2:08 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 z/os SQL stored procs without the C compiler [...]
17088 229 62_Re: Antwort: [DB2-L] runstats columns faroffpos& zos/390 db2v715_Philip Sevetson22_db2.dba.guru@GMAIL.COM30_Fri, 6 Jan 2006 15:47:01 -0500599_ISO-8859-1 Kirk,
the CREATE TABLESPACE statement includes the option LARGE which is required for tablespaces which need to contain more than 64 partitions.
--Phil
On 1/5/06, Kirk Hampton wrote: > > Hi Steve, > We are DB2 V7 on z/OS as well. We have seen something like this, > and I thought that RUNSTATS was leaving some of the stats columns > un-populated on tables where we specify SAMPLE 25. But I just found this > little gotcha in the V7 Utility Guide manual, > > > RUNSTATS sets the following columns to -1 for large table spaces. > > [...]
17318 209 20_Re: Partitioning ROT15_Philip Sevetson22_db2.dba.guru@GMAIL.COM30_Fri, 6 Jan 2006 16:03:06 -0500523_ISO-8859-1 Avram, we have successfully and routinely violated both of these rules at my place of work.
I particularly caution the unwary that *a random partitioning key will lead to random inserts, forcing synchronous reads and heavy I/O activity during insert and subsequent access.* High-volume INSERTs to large tables should never be random if it can be avoided, as the likelihood of the desired page being in the bufferpool is correspondingly small. This is a good way to learn about "Death by Random I/O." [...]
17528 116 20_Re: Partitioning ROT15_Philip Sevetson22_db2.dba.guru@GMAIL.COM30_Fri, 6 Jan 2006 16:26:28 -0500580_ISO-8859-1 I should add that we consider ourselves to be processor-constrained. IBM mainframes consist of a relatively small number of powerful processors, multitasking, and we're out to get the most bang for every buck we spend on 'em, juggling datawarehousing and OLTP tasks in fenced environments.
If you have: 1) A large number of not very powerful processors, which you can dedicate to the task of supporting this table: 2) plenty of memory Then Avram's rules about randomizing inserts work just fine, taking advantage of the cheapness of buying more processors. [...]
17645 101 31_Re: DB2 Z/os V8 Package Rebinds14_Grainger, Phil20_Phil.Grainger@CA.COM30_Fri, 6 Jan 2006 21:40:34 -0000511_iso-8859-1 Joan
A quick clarification please as I think I am confused....
You say "Once in V8, whether CM, ENFM, or NFM, if the plan/package is in old V7 format, it will be expanded or "puffed" to the new format the first time accessed" and later say "A rebind would save this from happening at execution. It might also alleviate surprises with access path changes" - I hope this DOESN'T mean that ALL plans and packages will be rebound by DB2 at v8. This is news to me if it does mean that! [...]
17747 137 31_Re: DB2 Z/os V8 Package Rebinds9_Mike Bell21_mbell11a1@VERIZON.NET30_Fri, 6 Jan 2006 15:58:33 -0600517_Windows-1252 REBIND has been specified for plans older than v2.3.
But the expanded format occurs for plans, packages and DBD's. I seem to remember it occurs on the first load to EDM pool but isn't saved until rebind or alter to DBD.
Mike HLS Technologies
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Friday, January 06, 2006 3:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Z/os V8 Package Rebinds [...]
17885 126 31_Re: DB2 Z/os V8 Package Rebinds13_Keemle Joan T25_KeemleJoanT@JOHNDEERE.COM30_Fri, 6 Jan 2006 16:08:26 -0600316_us-ascii I'm sorry, and thanks for correcting me! They are not rebound by V8, but are only expanded.
And yes, the expansion happens in CM as well as ENFM/NFM. V7 knows enough about it to recognize the V8 format, and it will re-format back to V7 format (after fallback, for instance).
Thanks Phil. [...]
18012 74 31_Re: DB2 Z/os V8 Package Rebinds33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Sat, 7 Jan 2006 02:16:57 +0100466_iso-8859-1 DB2 V8 production in CM mode since Nov 2004. SAP-DB2 V8 in NFM since several months.
We did this and I also recommend to rebind all plans/packages. One package cause an abend which was fixed with a DB2 ptf.
One of about 2000 packages got a bad access path because of the OPTIMZE FOR ONE ROW clause. I recommend to have Visual Explain installed as this helps to provide the data requested by IBM support. As a workaround we use OPTHINT. [...]
18087 136 20_Re: Partitioning ROT14_Avram Friedman21_avramf@IBMSYSPROG.COM30_Fri, 6 Jan 2006 17:20:08 -0800498_iso-8859-1 Hi Phil, Most shops I have been associated with don't follow my rules either. I would like to stress the fact that I am not a DBA. I am a systems programmer who kind of remembers how to wire unit record equipment plug panels.
However I do strongly believe The basic activity of data processing is processing data. Any scheme that proposes to eliminate the processing of data or is intolerant to the processing of data is fundamentally flawed and subject to eventual failure. [...]
18224 392 25_Re: DB2 V8 ENFM migration33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE30_Sat, 7 Jan 2006 02:31:52 +0100298_iso-8859-1 I also wonder about the ISV as DB2 V8 is in the market since about two years !!!! We had/have some issue with ASG-TMON/DB2 4.0 but mostly not related to V8 only. Perhaps we had a deeper look for application and ISV after the upgrade to V8. The TMON-DB2 SQL-Analyzer was very buggy. [...]
18617 124 41_Re: DB2 V7.1 on ZOS 1.6 Visual Explain V814_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sat, 7 Jan 2006 15:54:44 +1100411_US-ASCII In the revised SQL, table 3 is accessed twice and table 2 isn't - I presume that it actually goes table 3 -> table 1 -> table 2.
The way to do this sort of thing is a each step calculate/guestimate - how many rows/index entries are scanned and how many I's (well it would be IOs but I presume there's not much O'ing going on) - how many candidate rows are found to feed into the next step. [...]
18742 148 41_Re: DB2 V7.1 on ZOS 1.6 Visual Explain V812_Isaac Yassin20_yassini@BEZEQINT.NET30_Sat, 7 Jan 2006 10:02:50 +0200445_us-ascii Hi,
Just to expand a little. Look at the clustering ratio of the index used to access TABLE1 after the SQL change. The lower it is, the more a-sync I/O you'll have (James is right - it's only I, but we are used to the term I/O :-) ). Second question - how many rows are filtered by going to TABLE3 first? - if all (or near all) of them qualify then you gain nothing by going there first. The same goes for accessing TABLE2. [...]
18891 106 37_Load Failed due the space alloaction.5_tsp l19_tspdba001@GMAIL.COM30_Sat, 7 Jan 2006 14:45:35 -0500302_ISO-8859-1 Hi Everybody,
Below is the copy of SDSF for load job, It says it needs more space for this dataset. How to calculate the space required by dataset, is there a way to calculate it? If so can anybody explain it to me? How do you extend space for a VSAM Dataset? Thanks in advance. [...]
18998 217 41_Re: Load Failed due the space alloaction.13_Michael Ebert18_mebert@AMADEUS.COM30_Sat, 7 Jan 2006 21:00:30 +0100555_US-ASCII DB2 tried to allocate a dataset which is either the 3rd dataset in a very big segmented Table- or Indexspace, or a dataset belonging to a 3rd partition in a partitioned TS - I suspect the latter (because the LOAD job is called LOAD3). The file allocation request is not handled directly by DB2 but passed to AMS. The requested size is 415 MB, but there is not enough free space in your storage group to fulfill the request. This could be either because your disk pack is really nearly 100% full, or because the free space is too fragmented. [...]
19216 111 41_Re: Load Failed due the space alloaction.9_Mike Bell21_mbell11a1@VERIZON.NET30_Sat, 7 Jan 2006 14:11:38 -0600501_Windows-1252 The error message says that you don't have any volumes with at least 415MB in space in less than 5 extents. That is about 400+ cylinders of space. You need to talk to your DASD people about SMS storage group SGAITDB.
The normal problem I used to see is someone took the DDL from prod for a big partitioned table and wants to load a small test file. The problem is that prod is sized for prod and you need to change the priqty and secqty to match what you are actually loading [...]
19328 26 19_DSNREXX performance13_Horacio Villa17_hvilla@AR.IBM.COM30_Sat, 7 Jan 2006 18:20:25 -0300463_US-ASCII Hi list,
what can be wrong in a REXX using PREPARE, OPEN, FETCH & CLOSE with a SELECT statement that takes .3 minutes to complete in DSNTIAUL, to take 90 minutes with the DSNREXX interface? I don't think other REXX I'm using are that slow. Don't know what else to look at. Performance Report says it's in Application 99% of the time & lots of IO waits. The REXX doesn't do anything else but OPEN, FETCH (32xxx times) & CLOSE. Any good ideas? [...]
19355 50 23_Re: DSNREXX performance14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Sun, 8 Jan 2006 14:07:12 +1100601_US-ASCII Due to the nature of REXX interpretation, it will always be significantly slower than a compiled program.
Somewhere I read that one of the enhancements in V8 is DSNREXX performance. From fallible memory a 30 min to 2 min reduction in elapsed times were observed for one program.
Some time ago I read an analysis of V6 DSNREXX behavoir - apparently it invoked IRXEXCOM for every variable/column; I presume V8 invokes IRXEXCOM only once per fetch. (IRXEXCOM is the module that puts a program's data item into a REXX variable. The switch into and out of REXX space makes this [...]