1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l September 2003, week 3
2 81 60_IDUG 2004 - North America: Call for Presentations - Reminder12_Joseph Burns25_joseph.burns@HIGHMARK.COM31_Thu, 11 Sep 2003 13:49:39 -0400557_UTF-8
Greetings,
Just a quick reminder. If you are interested in submitting an abstract for IDUG North America 2004, the deadline is September 19th, 2003.
For more information, visit http://conferences.idug.org/namerica/2004/index.cfm
- Select "Call for Presentation Application" from the drop down box to submit a presentation abstract.
- Select "Call for Presentation Submission Guidelines" from the drop down box for presentation guidelines, due dates, and additional information. [...]
84 17 35_db2 to db2 with racf pass tickets ?10_Tom Taylor17_ttaylor@CHUBB.COM31_Fri, 12 Sep 2003 09:50:22 -0400386_us-ascii Hi all
Anyone using RACF pass tickets for a DB2 to DB2 setup. Looking for information about any issues?
Tom
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
102 12 4_test15_Neff, Stephen R16_NeffSR@STATE.GOV31_Tue, 16 Sep 2003 08:44:54 -0400271_iso-8859-1 test
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
115 102 12_Testing Mail11_Jeremy Peck23_jeremy_peck@YLASSOC.COM31_Tue, 16 Sep 2003 15:43:48 -0500434_us-ascii Receipt of this message should confirm that the list server is back functioning again. Sorry for the inconvenience.
Jeremy Peck
YLA
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
218 28 21_Re: test <>15_Gaston, Raymond17_GastonRay@ORU.COM31_Tue, 16 Sep 2003 16:45:46 -0400732_iso-8859-1 <>
-----Original Message----- From: Neff, Stephen R [mailto:NeffSR@STATE.GOV] Sent: Tuesday, September 16, 2003 8:45 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: test
test
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
247 21 12_Server Down?18_Michael L McCawley20_mike_dba@HOTMAIL.COM31_Mon, 15 Sep 2003 13:22:07 +0000573_- No messages this week?
Michael L. McCawley DB2 for Z/OS SysProg/DBA (reply address altered to prevent spam, delete "nospam." to reply)
_________________________________________________________________ Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
269 12 20_Test - Please Ignore0_17_sjvagnier@AEP.COM31_Tue, 16 Sep 2003 13:41:27 -0400269_us-ascii Test
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
282 59 44_DB2 z/OS Systems Programmer position desired16_Charles Crockett24_cfcrockett_db2@YAHOO.COM31_Mon, 15 Sep 2003 16:12:18 -0700444_us-ascii I am seeking a DB2 Systems Programming position following a recent outsourcing and downsizing. I have been doing this function for well in excess of 10 years, with experience in Data Sharing and Disaster Recovery Procedures.
Resume available upon request.
Charles Crockett Phoenix, Arizona, USA cfcrockett_db2@yahoo.com 602-997-8643 (home) 602-803-0379 (cel) 602-224-6928 (office) 602-955-9262 (fax) [...]
342 74 45_Re: Request for help: searching papers.......14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 16 Sep 2003 19:45:08 +1000351_US-ASCII Max
Are you, or you organisation, a member of SHARE? If not, you might have to wait several months (typically 4 to 5 months) for them to become publically available. (If you are, there is a members only section which might have them. Not being a member I don't know.)
Of course you might get a response to your plea below. [...]
417 80 22_DISREGARD THIS MESSAGE16_Alexander Lawson23_alex_lawson@YLASSOC.COM31_Mon, 15 Sep 2003 18:26:32 -0500280_us-ascii TESTING
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
498 18 8_Question50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Mon, 15 Sep 2003 13:36:49 -0400379_iso-8859-1 What is the lowest version of DB2 that can run under ZOS 1.4.
V5, V6, V7
Thanks Bob Knight
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
517 14 14_DB2L working??14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 15 Sep 2003 12:04:55 -0400316_ISO-8859-1 Haven't gotten any emails for a couple of days...
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
532 96 37_DSNREXX V6 and V7 connection problems19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Tue, 16 Sep 2003 17:01:40 -0500384_- Just an observation on DSNREXX problems, I've noticed some installations complaining they had problems sharing DSNREXX application code being able to run between sub-systems.
We noticed problems ourselves when we converting between V7 and V6 and some of our DSNREXX applications stopped working. Note: we are using private protocol to connect the DB2 sub-systems w/DDF. [...]
629 81 73_DB2 Connect 8.1 - ODBC problem (error: SQL0440N, routine named SQLTABLES)2_ED31_emaddanish@SAUDIAIRLINES.COM.SA31_Sat, 13 Sep 2003 14:29:21 +0300413_windows-1256 Hello DB2-Lers,
Recently I installed DB2 Connect Personal Edition v8.1 with FixPak 2, in order to access DB2 OS/390. Whenever I try to connect from any ODBC application (such as MS Excel's Query, or MS Visio 2002), I receive the following error message:
SQL0440N No authorized routine named "SQLTABLES" of type "" having compatible arguments was found. SQLSTATE=42884 SQLCODE -440 [...]
711 32 13_MS SQL Server14_Bernd Oppolzer26_Bernd.Oppolzer@T-ONLINE.DE31_Wed, 10 Sep 2003 23:23:42 +0200333_- Hello DB2-Listers,
we are creating a new application, which should be able to run with several different databases. We do this by specifying the SQL statements separated from the C coding, and then we generate different "access modules" for the different DB engines. The application layer does not see the differences. [...]
744 12 27_Is this list still working?13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 16 Sep 2003 12:27:56 -0500285_- Is this list still working?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
757 19 37_INSERT Timeout with row-level locking12_Carlos Olson14_COlson@QRS.COM31_Sun, 14 Sep 2003 18:01:58 -0700352_- We are on DB2 V6 OS/390 2.6 and attempted to resolve -911 issues by implementing row-level locking on all tables. Surprisingly, we started to experience -911 timeouts on INSERT statements. If a row is being created with an INSERT statement, how is it possible for another thread to hold a lock on that same row with row-level locking in effect? [...]
777 41 33_DATALOAD and blank numeric fields13_Tom Duerbusch26_DuerbuschT@STLOUISCITY.COM31_Mon, 15 Sep 2003 13:31:34 -0500331_US-ASCII I'm not sure if there is an easy way around this....
I have data that I'm trying to load into a DB2 table. The data has some blanks for numeric fields. But I need the data to be loaded with zeros instead of blanks.
I see that I can specify Null when POS(23) = ' ', but I want to specify something like: [...]
819 12 23_Testing - please ignore14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 16 Sep 2003 03:57:39 -0500279_iso-8859-1 Test message
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
832 49 29_DB2 UDB for AIX upgrade to V814_Martin Flavell18_mflavell@I-TCS.COM31_Tue, 16 Sep 2003 13:39:46 +0100
882 52 27_Consolidating DB2 databases13_John Fletcher27_johnefletcher2000@YAHOO.COM31_Tue, 16 Sep 2003 16:47:09 -0700470_us-ascii Our company has recently undergone a reorganization and I have been assigned the project to consolidate our four regional DB2 databases into a single DB2 database under one instance. The four databases are identical structurally, in terms of tablespaces, tables, indexes etc., however the issue is that there is nothing logically to differentiate the data when I merge the data; additionally, some data is common to all databases (table lookup data etc.). [...]
935 49 29_DB2 UDB for AIX upgrade to V814_Martin Flavell18_mflavell@I-TCS.COM31_Mon, 15 Sep 2003 15:44:41 +0100
985 154 11_Re: DSNREXX19_Humphris,Richard P.24_Richard.Humphris@CNA.COM31_Tue, 16 Sep 2003 14:13:14 -0500521_- We have users using rexx across DB2 subsystems. But when we were migrating from V6 to V7 we encountered a problem when going from a V7 subsystem (thru ddf) to a V6 sub-system. The reverse path (a V6 subsystem to V7) still worked.
So as a temporary solution, we moved the V6 DSNREXX into the V7 sub-systems and then ran using DSNREXX at V6 in all sub-systems ... until all our sub-systems were at V7. Note: because DSNREXX at V7 uses new features, we were unable to bind the V7 version into a V6 sub-system. [...]
1140 49 37_Re: DATALOAD and blank numeric fields10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 16 Sep 2003 19:12:59 -0500578_- Hi Tom,
You could try setting a DEFAULT value for your column, and specifying DEFAULTIF parameter in your LOAD statement.
Regards, Kals
On Mon, 15 Sep 2003 13:31:34 -0500, Tom Duerbusch wrote:
>I'm not sure if there is an easy way around this.... > >I have data that I'm trying to load into a DB2 table. >The data has some blanks for numeric fields. >But I need the data to be loaded with zeros instead of blanks. > >I see that I can specify Null when POS(23) = ' ', but I want to >specify something like: > >Zero [...]
1190 30 23_Tivoli Identity Manager13_Steve Runtsch27_Steve.Runtsch@US.FORTIS.COM31_Tue, 16 Sep 2003 19:24:33 -0500713_US-ASCII Question for you all. Has anyone installed TIM successfully using DB2 OS/390 as the database server?
Steve Runtsch Fortis, Inc.
**************************************************************** Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you ***************************************************************** [...]
1221 60 8_DSNTIJTC13_David S Waugh16_dsw-dba@JUNO.COM29_Wed, 17 Sep 2003 01:24:56 GMT544_- As Tina says, sometimes a PTF will require some kind of special action. Occasionally, this takes the form of running a special non-migration CATMAINT.
The last one of these I remember was in V5. If I recall correctly, the PTF in question altered some of the Catalog tables' columns to add 255 character support for a new function. It also required dropping & re-creating some Catalog views and re-assembling and re-linking DSNHDECP. And if you didn't do this special CATMAINT, the migration from V5 to V7 would fail on you later. [...]
1282 43 41_Re: INSERT Timeout with row-level locking0_18_IWANT2BEME@AOL.COM29_Tue, 16 Sep 2003 21:52:41 EDT415_US-ASCII Carol,
You may be experiencing lock escalation. Also check to see if the indexes or table is in a significant number of extents.
Jacquie
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1326 60 45_Replication from DB2 for OS390 and IMS to UDB14_Matthews, John25_JMatthews@MEDNET.UCLA.EDU31_Tue, 16 Sep 2003 22:39:10 -0700514_iso-8859-1
I would like to contact offline anyone who has done comparison of replication tools for DB2 for OS390 and IMS to DB2 UDB between any of the following vendors - IBM,STRIVA,SQDATA,CA.
John Matthews 310-267-4561
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1387 54 41_Re: INSERT Timeout with row-level locking31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Wed, 17 Sep 2003 08:37:30 +0200579_us-ascii Carlos,
Did you make changes in the MAXLOCKS/NUMLKTS settings? With Rowlevel locking you are probably holding a lot more locks in your process. If inserts are taking place at the end, an empty page is build in the bufferpool and one pagelock is taken. Now with RLL 1 lock per row is taken, which is "records per page" times more. So, check if you are experiencing lock escalation. I would suggest to use a MAXLOCKS of zero and therewith not allowing for lock escalation. Check your NUMLKUS setting, because this will be the limit for your total thread. If a [...]
1442 23 20_Re: DB2 Connect v7.26_Daniel15_bufes@YAHOO.COM31_Wed, 17 Sep 2003 02:20:29 -0500365_- On Tue, 9 Sep 2003 17:33:04 -0700, Myron Miller wrote:
[snip] >You must have >local admin to use CCA and change any configs on that DB2 Connect box. [end of snip]
Myron, Isn't it sufficient to belong to a sysadmin group which you can set using db2 SYSADM_GROUP config parameter. Are you sure you must be a local admin? [...]
1466 14 41_Re: INSERT Timeout with row-level locking33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 17 Sep 2003 02:53:46 -0500491_- Carlos
One reason for timeout for insert and row level locking could be: you are inserting a row with a duplicate key. In order to be certain, that this really a duplicate DB2 has to wait for the other thread until it commits.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1481 25 45_Re: Request for help: searching papers.......10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Sep 2003 09:59:16 +0200351_us-ascii Hi James
Thank you for your reply.
I'm searching the listed papers because they are *totally* missing from SHARE proceedings,i.e. there is the summary page but there's no link to presentation (a .pdf file) in the same pages.
I was able to download many other useful papers from the same web site after registration. [...]
1507 140 33_Re: DB2 UDB for AIX upgrade to V814_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK31_Wed, 17 Sep 2003 10:12:04 +0100369_utf-8 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
1648 134 31_Re: Consolidating DB2 databases35_=?windows-1255?B?7unr4Owg7Onh+O7v?=25_mliberman@MIVTACHIM.CO.IL31_Wed, 17 Sep 2003 12:56:44 +0200451_windows-1255 Hi john,
Have you considered using DB2 schemas ?
Michael Liberman
Database Administrator
Mivtachim
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
1783 99 31_Re: Consolidating DB2 databases14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 17 Sep 2003 10:52:15 +0100346_iso-8859-1 Sounds good enough to me.
Marcus Davage CEng MBCS IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for UNIX, Linux, Windows and OS/2 DB2 UDB V7.1 Database Administration for OS/390 'The views expressed are my own and do not necessarily represent the views or policy of my employer, Lloyds TSB Bank plc.' [...]
1883 166 33_Re: DB2 UDB for AIX upgrade to V818_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 17 Sep 2003 06:28:18 -0400445_us-ascii
Yes you can. We are doing that right now. The only issue we had to deal with is moving some of our databases to new instances. They are vendor packages and not certified under V8. So there may be extra work involved. Everything works just fine.
Peter J. Krawetzky, DBA IBM Certified Solution Expert DB2 UDB V7.1 Database Administration for Unix, Windows and OS/2 (860) 273-0301 KrawetzkyPJ@aetna.com [...]
2050 21 43_DB2 V7 install using workstation installer?18_Barth, Steve (IHG)29_Steve.Barth@ICHOTELSGROUP.COM31_Wed, 17 Sep 2003 08:20:23 -0400412_iso-8859-1 Has anyone out there used the workstation installer to install V7 from a Servicepac? I've run into some problems with the SMP jobs it has generated. I've asked IBM about it and they're not sure either. I should be able to use the CPP dialog to install, but I wanted to get some experience with the workstation installer, since it's my understanding that V8 will use it exclusively. Any thoughts? [...]
2072 30 66_Re: Request for help: searching papers (actually only another one)10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Sep 2003 14:35:37 +0200433_us-ascii Nice to meet you again listers
Another small request: I'm looking for the paper:
DB2 Timers: Key Performance Tuning Indicators ** by Namik Hrle **
It was presented ad European IDUG in 2002, but the copy I have is corrupted/incomplete (every slide is missing the last rows of comment).
I'll be eternally grateful to the lady/gentleman who'll send me (offline) a good copy of this paper...... [...]
2103 13 20_Real Time Statistics13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 17 Sep 2003 07:48:53 -0500368_- Has anyone experienced any virtual storage problems in the DBM1 address space related to Real Time Statistics?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2117 232 31_Re: Consolidating DB2 databases12_Bob Galeotti22_bgaleotti@SOFTBASE.COM31_Wed, 17 Sep 2003 08:54:53 -0400465_iso-8859-1 John, As your good thought processes reflect, there will be need to review differentiation strategies, both database and application oriented. But first, openly collaborate the need and value itself with the stakeholders and put a schedule and cost on it so all stakeholders are cognizant and appreciative of the scope and benefits of this effort. Also see what added value you can incorporate into this project - performance, ease of testing, etc. [...]
2350 28 8_Question50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Wed, 17 Sep 2003 09:00:17 -0400356_iso-8859-1 I put this question out on the IMS List server and now DB2.
PID number (insert IASP pgmnr) must be ordered with this product. Customers are not entitled to any voice defect support or product updates without PID number (insert IASP pgmnr)
Basically when products are ordered and product with this paragraph they are required? [...]
2379 91 33_Re: DB2 UDB for AIX upgrade to V811_Ed Mullikin17_EMullikin@SCU.EDU31_Wed, 17 Sep 2003 06:18:34 -0700507_US-ASCII Martin,
Yes you can since DB2 V8 is installed in a different directory then V7. We have both versions active and are currently testing.
Ed Mullikin DBA Santa Clara University
>>> mflavell@I-TCS.COM 9/16/2003 5:39:46 AM >>>
Hi all, We are going to upgrade our DB2 UDB for AIX from v7.2 to v8.1 very soon. Is it possible to have both versions active on the same server, i.e. can I have some of my instances still at version 7, whilst others are at version 8? [...]
2471 67 41_Re: INSERT Timeout with row-level locking15_Cristian Molaro30_Molaro_Christian@EUROCLEAR.COM31_Wed, 17 Sep 2003 15:14:46 +0200462_us-ascii Hello Carlos, Have you checked if your DB2 is doing lock escalation? You can search for the message DSNI031I in the JESMSGLG of your master... Regards, Cristian
Carlos Olson To: DB2-L@LISTSERV.YLASSOC.COM Sent by: DB2 Data cc: Base Discussion Subject: INSERT Timeout with row-level locking List
09/15/2003 03:01 AM Please respond to DB2 Data Base Discussion List [...]
2539 53 32_Re: IMAGE COPY LARGE TABLESPACES31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Wed, 17 Sep 2003 15:31:15 +0200403_us-ascii I've used a two STEPs approach. 1st use REPORT ONLY with CHANGE LIMIT. 2nd FULL IMAGE COPY depending on the returncode of the previous step. We isolate our updates per day in a partition, so I need to backup only one partition a day. Make sure that if you need the logs to Recover that this scenario does not take to long to cycle. That is, how long can you keep your archive logs around. [...]
2593 67 33_Re: Partitions greater than 4 GIG31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Wed, 17 Sep 2003 15:31:15 +0200353_us-ascii Yes, several tablespaces with 254 parts and DSSIZE of 64G. There are some PTF's that you need with extended addressability and REORG's. We had a problem with DELETE/DEFINE's of the VSAM's in the REORG. Further from that it works fine. Depending on your settings (use of ZPARM or not) you need to set up some ACS routine changes. Have fun. [...]
2661 41 47_Re: DB2 V7 install using workstation installer?11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 17 Sep 2003 08:45:54 -0500326_iso-8859-1 When I was at IDUG in May, I attended a UFO session with IBM on their installer. The new one is supposed to bear no resemblence to the current one, so I wouldn't worry too much about using this one. Hopefully they will incorporate my suggestions, since what they currently had would not be usable in our shop. [...]
2703 196 32_Re: IMAGE COPY LARGE TABLESPACES13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 17 Sep 2003 10:00:32 -0400595_us-ascii Roger,
We have a time-partitioned fact table in our DB2/390 data warehouse. The rows are fairly long, and each partition contains about 55M-60M rows. Data is loaded to this table weekly, and a week's input contains data which may be as much as three weeks old (never more).
We have written a COBOL program which generates the COPY statement for the current week's data and the two previous weeks; we only run COPY on these three most recent partitions (each partition has a unique GDG for its image copies). We retain old partition image copies out to the time limit [...]
2900 22 33_Re: DB2 UDB for AIX upgrade to V813_Johnny Kruger23_dhspa43@DHS.STATE.IL.US31_Wed, 17 Sep 2003 09:13:40 -0500494_- The answer is "what is a headache?" The problems I encountered is I when I used v8 as a client it would not attach to the remote DB2 AIX 7.2 fixpak 9 databases.
I expect if you have DB2 UDB 7.2 and v8 AIX instances, you cant have both 7.2 and v8 as your client. I recommend you convert all of your AIX databases to DB2 UDB v8 for AIX unless you want to divide your shop into two groups. If you divide your shop into two groups then keep a jar of aspirin close by. My opinion only [...]
2923 48 15_FW: DB2 in CICS14_Schaeffer Dave25_Dave.Schaeffer@BENDIX.COM31_Wed, 17 Sep 2003 10:22:35 -0400318_utf-8 We are having a problem that we haven't been able to correct. We have a CICS program that has embedded DB2 SQL that is LINKing to subroutine that also have DB2 SQL in it. We have tried every combination of SYSPOINT and PACKAGE/PLAN to get this to work. Does anyone have any idea on how to get this to work? [...]
2972 55 33_Re: DB2 UDB for AIX upgrade to V818_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 17 Sep 2003 10:28:06 -0400371_us-ascii We decided to keep everyone on the V7 client until all databases have been upgraded to V8. We are going to upgrade one workstation to V8 so we can use the client tools to manage new V8 features.
Peter J. Krawetzky, DBA IBM Certified Solution Expert DB2 UDB V7.1 Database Administration for Unix, Windows and OS/2 (860) 273-0301 KrawetzkyPJ@aetna.com [...]
3028 59 28_DB2 and ROLLBACK discussion.15_Cristian Molaro30_Molaro_Christian@EUROCLEAR.COM31_Wed, 17 Sep 2003 16:32:18 +0200629_us-ascii Hello List,
In our team, we are discussing about the way DB2 manages its LOGs when doing ROLLBACK.
The case:
We are running an application performing a lot of updates in DB2, without doing COMMIT. DB2 fills its LOG BUFFERS and ACTIVE LOG (ACTLOG1). Then, we submit the command ARCHIVE LOG. As a consequence, the LOG BUFFERS are externalized, the ARCHLOG1 is created and the ACTIVE LOG used is the next available: ACTLOG2 During this time, the application continues to run, always without COMMITING. We resubmit an ARCHIVE LOG command, creating ARCHLOG2 and passing to ACTLOG3 After a while, we [...]
3088 61 32_Re: DB2 and ROLLBACK discussion.14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Wed, 17 Sep 2003 09:38:01 -0500385_us-ascii Christian, As long as ACTLOG1 and ACTLOG2 are still reusable, DB2 will read from them. There is logic in ROLLBACK processing to check for this. In addition, I believe that the RECOVER utility will also check for reusable actives before calling for archives. Wayne Driscoll Sr. Software Developer Quest Software wdriscoll@quest.com NOTE: All opinions are strictly my own. [...]
3150 133 39_DB2 PM FILE output loaded in DB2 tables13_RICARDO GOMES20_ricardo.gomes@BCP.PT31_Wed, 17 Sep 2003 15:43:11 +0100487_iso-8859-1 Hi all, Can anyone help me finding sql statements (other than the ones in PM's SDGOSAMP pds) to explore the information I am loading in the DB2PM tables ?
TIA, My best regards Cumprimentos, Ricardo Gomes ricardo.gomes@bcp.pt < mailto:ricardo.gomes@bcp.pt> DIS-Direcção Infraestruturas Sistemas e Comunicações DSC-Sistemas Bases de Dados Tel.:(351) 210 070 274 Fax:(351) 210 070 649 Ext: 161274 Servibanca, TAGUSPARK Edifício 11, Piso 1, Ala B 2784-511 Porto Salvo [...]
3284 19 26_Value D in prefetch column33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 17 Sep 2003 09:39:13 -0500315_- Hi
It's a long time ago, since I posted a question to the list, because there is hardly a day, that I have no trouble getting to it.
I just explained a statement and saw the value 'D' in the prefetch column of the plan table. Does D mean: dynamic prefetch? Until now, I only saw S, L or blank. [...]
3304 155 32_Re: DB2 and ROLLBACK discussion.13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 17 Sep 2003 10:50:24 -0400468_us-ascii Cristian:
Until IN-USE active logs write over a REUSABLE active log, the REUSABLE active logs can be/are used for ROLLBACK processing.
Note... if your ARCHIVE logs are on a 3490 type tape with hardware compression, you _will_ experience significant delays in backward-recovery processing against these tapes. If you know in advance that you will be rolling several tapes, it is worthwhile to move the archive logs to DASD for the recovery. [...]
3460 72 23_Apptune And Dynamic SQL9_Andy Hunt22_AndrewHunt@HBOSPLC.COM31_Wed, 17 Sep 2003 15:56:02 +0100598_iso-8859-1 Hi, We have an application that uses one package and dynamic SQL. I am trying to use BMC Apptune to identify the biggest hitting dynamic SQL that is worth tuning. We are capturing SQL Text through Apptune. Apptune provides summarised costs for each statement number (SQMCACTX panel). If you then select a particular statement number from the panel, then a panel is displayed showing a list of dynamic sql that has been generated through that statement number (SQMCACTT panel). And that is about as far as it goes really. The list is not sorted in 'resource cost' descending and you [...]
3533 79 27_Re: Apptune And Dynamic SQL11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 17 Sep 2003 10:08:02 -0500423_iso-8859-1 Have you tried calling BMC support? They're usually very good about helping you get the software to give you the information you need and you usually get an answer the same day. At least they are with the products that we have.
-----Original Message----- From: Andy Hunt [mailto:AndrewHunt@HBOSPLC.COM] Sent: September 17, 2003 9:56 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Apptune And Dynamic SQL [...]
3613 120 27_Re: Apptune And Dynamic SQL11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Wed, 17 Sep 2003 10:17:32 -0500576_us-ascii Andy
You should check to see if there is a filter profile created for this package. In the filter profile is an option to summarize by dynamic SQL text. The valid valuies are y,n, and h. Yes and no are hopefully obvious, the "h" says to summarize only if there are host variables present. The "h" is important, because if the statement has no host variables, then all the statements will summarize into one line item on the report. The only way to get summarization is through the presence of host variables. Assuming that you have host variables and get [...]
3734 44 23_MainView for DB2 output10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Sep 2003 17:16:09 +0200311_us-ascii Estimeed listers
We have MainView for DB2 as monitor. I'd like to print in a file some of the screen displays, in particular some displays you obtain entering in the 'Page set menu', where you can display various types of I/Os (sync, async,etc) for objects or for database. Below a sample: [...]
3779 85 15_Re: DB2 in CICS0_16_khampto1@TXU.COM31_Wed, 17 Sep 2003 10:31:07 -0500344_us-ascii We have many application that do this, what is the error you are getting ?
Did you: bind a package for the 1st (linking) program, bind a 2nd package for the 2nd (linked to) program bind a plan with a package list containing both packages make sure the CICS tran has a DB2Entry pointing to the plan containing both packages [...]
3865 94 27_Re: MainView for DB2 output9_Andy Hunt22_AndrewHunt@HBOSPLC.COM31_Wed, 17 Sep 2003 16:32:58 +0100394_iso-8859-1 Esteemed Max, I use the EXPORT command to export the screen contents to a file.
Kind Regards,
Andy Hunt, Production Database Administrator, IT Service Delivery, Database Services, HBOS Group Technology, Pudsey, West Wing 1st Floor, Tel: 0113 23(53429) Mobile: 07909 886035 Postal Ref PUD/W1/ITSD
Database Services Team Phone x53110 Team mailbox: $IT SD DB2 [...]
3960 123 15_Re: DB2 in CICS0_22_BRIAN_GOLDBERG@QVC.COM31_Wed, 17 Sep 2003 11:39:39 -0400418_us-ascii One other point to consider.
If the linking program has not yet issued a return with transid, the active plan is associated with the last program that did issue a return with transid.
Brian
khampto1@TXU.COM Ext: To: DB2-L@LISTSERV.YLASSOC.COM Sent by: DB2 Data cc: (bcc: BRIAN GOLDBERG/QVC) Base Discussion Subject: Re: DB2 in CICS List [...]
4084 120 27_Re: MainView for DB2 output13_Daley, Norman24_Norman.Daley@CINERGY.COM31_Wed, 17 Sep 2003 10:45:51 -0500304_iso-8859-1 Max, I run Mainview batch. You create a CLIST which sets variables for the screen names you want to capture. The output looks just like the online version. I think it might have come from some BBSAMP lib. I'm sure your friendly BMC person can find that for you.
Norm Daley Cinergy [...]
4205 124 27_Re: MainView for DB2 output22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Wed, 17 Sep 2003 11:01:32 -0500410_iso-8859-1 Recently, I had asked BMC this same question and they said I could use MV Batch Report to do this. The MV Batch doc is in 'Using MainView'.
HTH,
Venkatesh
----- Original Message ----- From: "Andy Hunt" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, September 17, 2003 10:32 AM Subject: Re: MainView for DB2 output [...]
4330 111 27_Re: Apptune And Dynamic SQL7_Ale Eba15_Ale.Eba@CGI.COM31_Wed, 17 Sep 2003 12:01:39 -0400388_us-ascii Hi Andy, Which version of APPTUNE are you running. Under version 3.1 it was working great. Under version 3.4, there is some confusion. Now selecting SQL text does not even give multiple occurrences of the one SQL statement rather different SQL statements. I have opened a problem with BMC more than six months ago. They provided me a ZAP but the ZAP didn't change anything. [...]
4442 117 15_Re: DB2 in CICS13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Wed, 17 Sep 2003 12:17:09 -0400368_utf-8 Dave,
What error are you getting? We have lots of CICS programs with SQL that LINK to other CICS program that have SQL. Do you have the COLLID of the 'linked' program in the same plan that the 'callling' program is running under?
Scott Hodgin, Database Administrator [...]
4560 194 27_Re: Apptune And Dynamic SQL9_Andy Hunt22_AndrewHunt@HBOSPLC.COM31_Wed, 17 Sep 2003 17:28:13 +0100811_iso-8859-1 Ale, Thank you for your comments. We are running V3.4.
I think I am seeing the opposite to you - I do see multiple occurrences of the same sql statement - as shown below (i.e. summarisation does not take place).
Subsys: AppGrp: User: N/P ConnID: CICSBAM1 Plan: P1IBNKPO CorrID: N/P
Execution Date and Time User Sample of Dynamic SQL Text ------------------------ -------- ------------------------------------------ 17/09/03 17:00:03.036452 IBNKPRD1 SELECT VALUE(MAX(ONE_PLAN_ID),0) FROM O_B 17/09/03 17:00:03.288137 IBNKPRD1 SELECT VALUE(MAX(ONE_PLAN_REF),'') FROM O <<<< same sql 17/09/03 17:00:03.974633 IBNKPRD1 SELECT VALUE(MIN(MORTGAGE),'') FROM M_ACF 17/09/03 17:00:04.142752 IBNKPRD1 SELECT COUNT(*) FROM M_ACF94 WHERE ONE_PL 17/09/03 17:00:04.155277 IBNKPRD1 SELECT [...]
4755 221 27_Re: Apptune And Dynamic SQL13_McKenny, John20_John_McKenny@BMC.COM31_Wed, 17 Sep 2003 12:00:11 -0500359_iso-8859-1 Andy,
From the data you posted I believe the option for APPTUNE to summarize like Dynamic SQL Statements is not turned on for the workload you are interested in. It should be pretty simple to turn this on and BMC Support would be happy to walk you through it.
Please let me know if you have any trouble after talking to support. [...]
4977 81 27_Re: Apptune And Dynamic SQL7_Ale Eba15_Ale.Eba@CGI.COM31_Wed, 17 Sep 2003 13:46:34 -0400424_us-ascii Hi Andy
Under version 3,4 we are getting exactly the same output as yours. For example we consider the statements
SELECT COUNT(*) and SELECT VALUE(MIN as different, whereas the following is from version 3.1. All statements are identical but we don't know which one is taking the most of the resources.
Subsys: DB2H AppGrp: User: FRR1XP1 ConnID: N/P Plan: DISTSERV CorrID: PSAPPSRV [...]
5059 133 78_Re: DB2 Connect 8.1 - ODBC problem (error: SQL0440N, routine name d SQLTABLES)11_Gugel, Rich26_Rich.Gugel@DOA.STATE.WI.US31_Wed, 17 Sep 2003 13:53:59 -0500574_windows-1256 Have your database adiministrator install PQ62965
APAR Identifier ...... PQ62695 Last Changed ........ 03/08/07 ADD STORED PROCEDURES AND VIEWS FOR USE BY ODBC AND JDBC DRIVERS
-----Original Message----- From: ED [mailto:emaddanish@SAUDIAIRLINES.COM.SA] Sent: Saturday, September 13, 2003 6:29 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Connect 8.1 - ODBC problem (error: SQL0440N, routine named SQLTABLES) [...]
5193 26 42_Doubt in DB2 Transaction related settings.12_Vamsi Charan27_Vamsi.Charan@GEDC.TCS.CO.IN31_Thu, 18 Sep 2003 00:35:00 +0530468_us-ascii Dear Listers,
We have an Application Server (J2EE based) which accesses the DB2 database (V6 on OS/390) using DB2 Connect. The App. Server has a connection pool which uses the same DB2 UserID and Password for all connections.
When many user's connect to the application, is it possible that 2 users view and update the same row in a table and also is it possible that the first user's updates are lost because of the second user's update ? [...]
5220 78 15_Job Opportunity11_Joe Timpani14_joe@AZJOBS.COM31_Wed, 17 Sep 2003 12:19:03 -0700596_iso-8859-1 DB2 DBA 390 ( Arizona / Permanent )
Mainframe 10 years experience Tuning, database design, database administration. Knowledge of distributed computing environment Unix and Windows Expert level SQL programming. Quality testing and performance testing.
Contact:
Joe Timpani 480-838-0333
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5299 51 46_Re: Doubt in DB2 Transaction related settings.14_Wayne Driscoll24_wayne.driscoll@QUEST.COM31_Wed, 17 Sep 2003 14:28:15 -0500561_us-ascii Each connection will be treated as a separate thread in DB2, regardless of the number of connections using the same userid. Each thread will takes locks as needed. If a user attempts to update a row, the an exclusive lock will be taken, which will prevent other threads from fetching or updating the row until the thread with the lock either commits or rolls back the transaction. If you want to ensure that a row that is being looked at by one user isn't updated by another during the duration of the first user's transaction, take a look at the [...]
5351 85 18_Re: Extend Failure16_Richard Humphris24_Richard.Humphris@CNA.COM31_Wed, 17 Sep 2003 14:31:05 -0500554_- On Wed, 10 Sep 2003 11:09:54 -0400, David Nance wrote:
> We ran into this issue a couple of days ago and still don't have an explanation for why it occured. We are Z/OS 1.2 running V7. Was wondering if anyone else mave have run across the reason code, 00C20049, because it doesn't exist anywhere, that we've been able to find. The dataset was in 183 extents so it hadn't hit the max yet. It had however, gone into 7 datasets due to the size of the table. To correct the issue, we stopped and started the tablespace. Then [...]
5437 79 46_Re: Doubt in DB2 Transaction related settings.12_michael bell24_mbell11@WORLDNET.ATT.NET31_Wed, 17 Sep 2003 14:42:19 -0500455_Windows-1252 If your question is can 2 programs running at the same time update the same row, the answer is no - DB2 locks the row during the update and prevents the second program from get the same row.
If your question is can 2 users sitting at a terminal looking at an account, and one makes a change to the address and another makes a change to the phone number - it depends on how it was coded but it is very possible to lose one update. [...]
5517 109 60_Developing High Performance DB2 Applications in the 24x7 Age14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 17 Sep 2003 21:37:02 +0100398_iso-8859-1 Developing High Performance DB2 Applications in the 24x7 Age
Computer Associates would like to invite you to attend a free seminar on Wednesday 1st October 2003. The event features a full day presentations and advice from Bonnie Baker - an expert in DB2 applications, Alex Kopac - DB2 Database Administrator for First Data Corp and our own Maria Sarikos - specialist in DB2. [...]
5627 105 41_-904 query error after v6 to y7 migration11_Brown, Bill18_BILL.BROWN@TTU.EDU31_Wed, 17 Sep 2003 15:42:26 -0500584_us-ascii Hi List,
I recently completed the v6 to v7 conversion. Everything went smoothly. After converting, one of our developers sent us a query that worked before the conversion but now does not. I've opened an issue with IBM and searched IBM link with no success, so I was wondering if anyone had seen anything like this. The error message is below followed by the query. Note that when the indicated subquery is commented out, the query does not get an error. Has anyone seen something like this and/or can you suggest an alternative way to code this that might avoid [...]
5733 155 15_Re: DB2 in CICS16_Julian Scharneck20_julian4@TELKOMSA.NET31_Wed, 17 Sep 2003 22:35:19 +0200514_iso-8859-1 Hi ,
Maybe irrelevant, but I remember having to code a "set current package set" in a Cobol batch environment. and then having to reset to the relevant package once control return to the calling program.
You can also see in CEDF(CICS) what the current plan is after the link.
----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, September 17, 2003 5:39 PM Subject: Re: DB2 in CICS [...]
5889 22 28_Question on REORG tablespace9_Dang, Tho16_tho.dang@EDS.COM31_Wed, 17 Sep 2003 17:01:00 -0400306_- Hi all,
Even I looked at the manual I still couldn't find the answer for my question : . Does all temporary datasets need for the REORG TABLESPACE such as SYSUT1, SYSREC, SORTOUT... have to be on DASD instead of tape ?
I hope somebody can give me the answer.
Thanks in advance. [...]
5912 136 32_Re: Question on REORG tablespace13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Wed, 17 Sep 2003 17:11:58 -0400521_us-ascii Tho,
No, those work datasets don't have to be written to DASD.
You can give the work datasets a "permanent" DSN, code (NEW,CATLG,CATLG) if I recall correctly, and specify whatever your installation requires (UNIT= and naming convention requirements are common) to write them to tape. However, unless you have _seriously_ fast tapes and a _really_ large tablespace, it's hardly ever worth while to do so; you sacrifice a lot of speed in writing and reading tapes vs. DASD in most environments. [...]
6049 49 32_Re: Question on REORG tablespace14_Riedel, Marcia26_MRiedel@TUCSONELECTRIC.COM31_Wed, 17 Sep 2003 14:18:58 -0700424_- Hello:
All three can be written to tape. If a two-phase REORG is run, the SYSUT1 and SORTOUT are not allocated until the RESTART step. If SYSUT1 and SORTOUT are allocated to tape in the first step and nothing is written to the tape, the dataset is not cataloged and the second step will error because SYSUT1 and SORTOUT are not found. Use DUMMY in the first step and allocate them in the second if using tape. [...]
6099 67 32_ABEND=S04E U0000 REASON=00E4034713_Horacio Villa17_hvilla@AR.IBM.COM31_Wed, 17 Sep 2003 18:26:12 -0300742_US-ASCII Hi,
I got this abend while running this Rebuild Index:
//SYSIN DD * OPTIONS PREVIEW TEMPLATE SUT1 UNIT(CARVTS3) VOLCNT(10) DISP(NEW,DELETE,DELETE) DSN(BKDS2T.CD0008.&DB..&SN..SUT1) LISTDEF LISTAX INCLUDE TABLESPACE C1ADSA.C1DXCMTE OPTIONS OFF REBUILD INDEX LIST LISTAX STATISTICS SORTDEVT DBATMP SORTNUM 5 WORKDDN(SUT1) /*
This causes SUT1 to go to tape (VTS), because I always got B37 on disk (have to try with VOLUMES and VOLCNT on the TEMPLATE). This is from SYSPRINT: DSNU1033I DSNUGULM - PROCESSING LIST ITEM: TABLESPACE C1ADSA.C1DXCMTE ==> STATS VALS || USMSRECL ADDR=X'16602F9C' LENGTH=X'04' || 0000 00000000 *.... * || || USMSIDXL ADDR=X'16602FA4' LENGTH=X'04' || 0000 00000000 *.... * || DSNU1038I [...]
6167 63 32_Re: Question on REORG tablespace0_19_csutfin@AMSOUTH.COM31_Wed, 17 Sep 2003 16:28:49 -0500480_us-ascii No SYSUT1, SYSREC, SORTOUT SYSDISC can be on tape or DASD or a mix of those, depending on size , etc.
Just be careful with the DISP parameters. They must match your device.
Carol Sutfin Corporate DBA AmSouth Bank (205)261-5214 csutfin@amsouth.com
"Dang, Tho" cc: Sent by: DB2 Data Subject: Question on REORG tablespace Base Discussion List [...]
6231 48 17_Re: MS SQL Server14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Sep 2003 08:16:25 +1000360_US-ASCII Do you have access to the MSDN Library. Use "precompiler" as the search term and get "[t]he nsqlprep precompiler creates a C program with the file extension .c from an Embedded SQL for C (ESQL/C) program".
Toddle over to, for example, http://www.openitx.com/g/sql-server- l.asp for a better forum for such questions.
James Campbell [...]
6280 32 12_Re: Question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Sep 2003 08:16:26 +1000342_US-ASCII I would be kinda surprised if, even, V3 didn't work on z/OS 1.4. However since support for V5 (and earlier) was withdrawn before z/OS 1.4 went GA you'll probably find it difficult to get a formal statement that "DB2 V5 runs under z/OS 1.4". DB2 V6 is the oldest version which would have a formal support statement for z/OS 1.4. [...]
6313 55 24_Tools & Utilities for V710_Trinh Linh24_ltrinh@WOOLWORTHS.COM.AU31_Thu, 18 Sep 2003 08:51:50 +1000479_iso-8859-1 Dear all,
This could be another old & boring topic but as I have few problems with searching the archive I need to ask for your help.
At the moment I am evaluating tools & utilities from 3 vendors (IBM, CA & BMC) to get ready for V7. I already got all the feedback some the vendors regarding they capability to support our needs. Currently we are on V6 (mainframe) & have BMC. I used Platinum tools before but not with V6 or since it changed to CA. [...]
6369 27 46_INFO : Security Patches for DB2 UDB for LUW V713_Philip Nelson18_teamdba@SCOTDB.COM31_Thu, 18 Sep 2003 00:05:00 +0100351_- Guys,
In case you've not noticed (I became aware through an article filtered for me by news.google.com) there is a Fixpack 10a out for DB2 UDB for LUW V7.
It fixes 4 APARs, including 3 security advisories which could cause a DOS or unauthorized root access to the DB2 server.
Time to get your Sysadmin "upgrading" hat on ? [...]
6397 13 47_Richard Strong/MAN/Candle is out of the office.14_Richard Strong25_Richard_Strong@CANDLE.COM31_Thu, 18 Sep 2003 01:00:38 +0100350_us-ascii I will be out of the office starting 16/09/2003 and will not return until 19/09/2003.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6411 62 47_Re: DB2 V7 install using workstation installer?12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 17 Sep 2003 17:16:27 -0700413_us-ascii I would agree with you about the usability of the IBM installer package on a PC. It failed multiple times when I tried to use it and I was never able to get it to work in our environment and IBM didn't seem to care that it repetitively failed as the PMR stated it was working as designed. So I gave up and used the old fashioned CLISTS. At least I could modify the code on them to get them to work. [...]
6474 45 20_Re: DB2 Connect v7.212_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 17 Sep 2003 17:20:39 -0700358_us-ascii Daniel, I'm not 100% sure. From the manuals and the install doc that I've seen, they all said that I must be a local admin. I've never tried the db2 SYSADM_GROUP config parameter. I do know that if the user doing this is not local admin (without trying your suggestion), that the changes will not be taken for CCA. Had that happen a few times. [...]
6520 115 45_DB2 Alert: Version 7 FixPak 10a now available14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM31_Wed, 17 Sep 2003 20:25:20 -0400451_us-ascii Does anybody know if these four APARs identified in FixPak 10a address only problems introduced by FixPak 10, or do these also apply to previous FixPaks? We're currently running fp7 on our DB2 UDB Servers (AIX).
------------------------------------------------------- Bill Gallagher Database Administrator Information Technology Infrastructure / Operations Phoenix Life Insurance Company 860-403-1773 bill.gallagher@phoenixwm.com [...]
6636 119 18_Re: Extend Failure19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Wed, 17 Sep 2003 21:14:25 -0400341_us-ascii Maybe you were trying to exceed the 2gig or 4gig limit (depending on whether segmented or partitioned, number of partitions, dssize, etc...). Also, remember that the first extent on a new volume will use the primary quantity (instead of secondary quantity) and maybe there were no volumes available with that primary quantity. [...]
6756 13 18_db2 trace overhead17_Db2System Process17_db2sysc@YAHOO.COM31_Wed, 17 Sep 2003 22:57:05 -0500356_- Can someone explain the different trace class overheads? and how it can be measured?
thanks
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6770 29 48_Oracle Transparent Gateway and Stored Procedures0_19_mike.holmans@BT.COM31_Thu, 18 Sep 2003 14:31:54 +0100330_iso-8859-1 Hi all,
I've got some people who are going to use the Oracle Transparent Gateway for DRDA to access DB2 for z/OS V7, and they intend to call DB2 SPs to perform work on the DB2 side. So far, so good.
Since they don't have particularly complicated needs, it looks like SQL procedures will be adequate. [...]
6800 100 36_Re: ABEND=S04E U0000 REASON=00E4034735_=?windows-1255?B?7unr4Owg7Onh+O7v?=25_mliberman@MIVTACHIM.CO.IL31_Thu, 18 Sep 2003 10:32:47 +0200558_windows-1255 Hi Horacio, We have experienced the same problem while trying to REORG a table that has 118,000,000 records. It seems that there is a problem with the SYNCSORT utility that probably cannot deal with such amount of data (we have 7 composite indexes on the table). IBM tech support didn’t help us figuring this out. Anyway, to solve this problem we dropped all the indexes, performed the REORG and than rebuild the indexes one by one. So maybe executing the rebuild index on one index at a time will help you to solve this problem. Good luck [...]
6901 71 28_Re: Tools & Utilities for V718_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 18 Sep 2003 06:32:32 -0400480_iso-8859-1 We just upgraded to DB2 v7 OS/390 and we've used CA/Platinum tools for a number of years and we continue to use them. All-in-all, in my opinion, they are good tools and in our environment they have proved to be very useful. But as any 3rd party tool you can have moments of great frustation but from the 'support' end they (CA) have come a long ways and to me this is a very important area. Again, just my opinion and nothing against IBM's tools or other vendors. [...]
6973 20 45_General question - converting IMS data to DB221_EXT-Richardson, Brian33_richardb@XCH-BSCO-01.KSC.NASA.GOV31_Thu, 18 Sep 2003 09:01:37 -0400600_iso-8859-1 Generally speaking, what's involved in converting an IMS table/view into a DB2 table/view. I'm not familiar with IMS, so I'm curious how much level of
effort is involved. Assume an experience IMS person is doing the work (not myself). Thanks in advance.
Brian Richardson The Boeing Company Kennedy Space Center, Florida
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6994 88 47_Re: DB2 V7 install using workstation installer?18_Barth, Steve (IHG)29_Steve.Barth@ICHOTELSGROUP.COM31_Thu, 18 Sep 2003 09:34:19 -0400662_iso-8859-1 I've given up too and now using the 'normal' serverpac install clist. Hope it works better!
Steve Barth InterContinental Hotels
-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Wednesday, September 17, 2003 8:16 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 V7 install using workstation installer?
I would agree with you about the usability of the IBM installer package on a PC. It failed multiple times when I tried to use it and I was never able to get it to work in our environment and IBM didn't seem to care that it repetitively failed as the PMR stated it was working as [...]
7083 22 7_formula12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Thu, 18 Sep 2003 08:20:57 -0400546_us-ascii Anyone out there work with a product called 'FORMULA', it is used to monitor various aspects of tasks running under OS/390. Specifically here is monitor status of DB2 and jobs running under DB2.
Thanks
Stan Goodwin DSN: 430-4335 Outside:- 717-605-4335
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
7106 40 19_Off topic question:19_Jayachandran, Anand26_anand.jayachandran@EDS.COM31_Thu, 18 Sep 2003 07:53:15 -0500427_iso-8859-1 Dear Listers,
When i tried to access the archive documents, I receive the following messages:
The requested URL could not be retrieved
While trying to retrieve the URL: The following error was encountered: We can not connect to the server you have requested. This means that:
* The server might be busy at this time. [...]
7147 83 74_Re: IDUG 2004 - North America: Call for Presentations - due date 9/19/200312_Joseph Burns25_joseph.burns@HIGHMARK.COM31_Thu, 18 Sep 2003 09:58:12 -0400462_UTF-8
There is still time to submit an abstract for the 2004 IDUG North America Conference. If you are considering submitting an abstract, the due date is quickly approaching.
The deadline is Friday September 19th, 2003.
For more information, visit http://conferences.idug.org/namerica/2004/index.cfm
- Select "Call for Presentation Application" from the drop down box to submit a presentation abstract. [...]
7231 56 21_RI implementation ...11_ANGOT HARRY18_harry.angot@CDN.FR31_Thu, 18 Sep 2003 10:53:21 +0200330_iso-8859-1 Hi gurus,
I'm about to migrate a database in Oracle to DB2 and it should be (1 for 1) , the problem is that in Oracle you can
implement RI and force the control of this integrity at commit point ... it allows the transaction to insert in different order,
I don't think DB2 would accept this . [...]
7288 128 49_Re: DB2 Alert: Version 7 FixPak 10a now available18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 18 Sep 2003 09:13:55 -0400425_iso-8859-1 I 2nd this question!!!! We are about to put Fixpak 10 on but like Bill has asked; does FP10 open up this security hole or was it found in an earlier Fixpak!!!
Thanks: --Steve....
-----Original Message----- From: Bill Gallagher [mailto:BILL.GALLAGHER@PHOENIXWM.COM] Sent: Wednesday, September 17, 2003 8:25 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Alert: Version 7 FixPak 10a now available [...]
7417 89 28_Re: Tools & Utilities for V710_Jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Thu, 18 Sep 2003 09:04:27 -0500558_iso-8859-1 Trinh,
In the past, some third party vendors' utilities require the existence of IBM utilities in order to function correctly. Check with your third party vendor to see if this is still true. Based on a previous message saying that IBM will only offer Utilities Suite in future, you will have no option but to buy IBM utilities regardless the choice you make. Unless you can convince your management that some functions from third party utilities are absolutely critical to your operation, you might have hard time to buy 2 utilities. [...]
7507 107 32_Re: DB2 and ROLLBACK discussion.15_Cristian Molaro30_Molaro_Christian@EUROCLEAR.COM31_Thu, 18 Sep 2003 11:39:04 +0200426_us-ascii Thanks for your comments, and thanks to Phil also. By the way, we have seen the same behavior in MQSERIES...
Wayne Driscoll cc: Sent by: DB2 Data Subject: Re: DB2 and ROLLBACK discussion. Base Discussion List
09/17/2003 04:38 PM Please respond to DB2 Data Base Discussion List [...]
7615 166 36_Re: ABEND=S04E U0000 REASON=00E4034713_Michael Ebert18_mebert@AMADEUS.NET31_Thu, 18 Sep 2003 16:13:49 +0200579_iso-8859-1 In my experience, this RC is usually due to two causes: 1. DB2 often underestimates (sometimes severely in the case of variable-length rows) the number of rows in a tablespace and passing this to the sort program. This leads to x37 abends when the dynamic sortworks run out of space. 2. DB2 creates too many subtasks. This leads to S878 abends (GETMAIN error). I've just had this trying to REORG the SYSOBJ TS in my new V7 subsystem (oddly enough, specifying SORTNUM 8 instead of SORTNUM 3 reduced the number of subtasks from 56 to 24, which solved the problem). [...]
7782 54 23_Re: Off topic question:11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Thu, 18 Sep 2003 09:19:32 -0500581_iso-8859-1 Works for me.
-----Original Message----- From: Jayachandran, Anand [mailto:anand.jayachandran@EDS.COM] Sent: September 18, 2003 7:53 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Off topic question:
Dear Listers,
When i tried to access the archive documents, I receive the following messages:
The requested URL could not be retrieved
While trying to retrieve the URL: The following error was encountered: We can not connect to the server you have requested. This means that: [...]
7837 14 47_Rusty Smith/ZI/USA/Zurich is out of the office.11_Rusty Smith24_rusty.smith@ZURICHNA.COM31_Thu, 18 Sep 2003 09:05:37 -0500385_US-ASCII I will be out of the office from 09/18/2003 until 09/24/2003.
I will respond to your message as soon as I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
7852 32 32_MainView for DB2 output - Thanks10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 18 Sep 2003 16:23:06 +0200447_us-ascii It's the third time I try to send this post.........
__________________
Estimeed listers
Thank you very much for your replies. The command EXPORT work perfectly for my needs.
I read about this command but I (wrongly) thought it exported only the part currently displayed on my screen, not the entire set of data. Now I'm exploring the MV batch report feature(s) (when I'll find the manual.......) [...]
7885 145 36_Re: ABEND=S04E U0000 REASON=00E4034718_Fazal, Syed (TATA)39_Syed.Fazal@CONTRACTORS.NATIONALCITY.COM31_Thu, 18 Sep 2003 10:01:20 -0400567_windows-1255 Hi Horacio~
We still get the same error ABEND=S04E U0000 REASON=00E40347 for online reorg. I used £ORTPARM DD statement in the jcl which was given by Steve Lamb but still it didn't helped me. I opened a ticked with Syncsort and they said their product works fine. Instructed me to open a ticked with IBM. We still have no luck with the problem. The database is not huge. You may use the option of dropping the indexes and performing the reorg. If you get a solution other than dropping the indexes and doing the reorg please share with me as [...]
8031 67 49_Re: General question - converting IMS data to DB213_Brendan Friel21_Brendan.Friel@UAL.COM31_Thu, 18 Sep 2003 09:24:51 -0500353_US-ASCII I've done a few IMS --> DB2 or VSAM --> to DB2 or miscellaneous database to DB2 conversions over the years.
There are at least two ways to go about it :
1) Take the fields in IMS and define a DB2 structure to exactly mirror this. 2) Go through a data modeling/database design process to come up with a real relational model. [...]
8099 41 52_Re: Oracle Transparent Gateway and Stored Procedures6_Daniel15_bufes@YAHOO.COM31_Thu, 18 Sep 2003 09:32:57 -0500583_- On Thu, 18 Sep 2003 14:31:54 +0100, mike.holmans@BT.COM wrote:
>Hi all, > >I've got some people who are going to use the Oracle Transparent Gateway for >DRDA to access DB2 for z/OS V7, and they intend to call DB2 SPs to perform >work on the DB2 side. So far, so good. > >Since they don't have particularly complicated needs, it looks like SQL >procedures will be adequate. > >If they want to use the stored procedure builder (ie the Application >Development Client), do they need to have DB2 Connect as well in order to >handle the workstation communications, or would [...]
8141 67 49_Re: General question - converting IMS data to DB210_Alice Frus16_FRUSA@BCBSIL.COM31_Thu, 18 Sep 2003 09:40:26 -0500278_us-ascii They are totally different parent child relationship models - you will end up with a lot of DB2 RI probably. Don't let them take one ims segment and convert it to one DB2 table - they need to do a datamodel to really do it right. Been there - done that- both ways [...]
8209 106 49_Re: General question - converting IMS data to DB213_Mark A. Doyle19_mdoyle@JCPENNEY.COM31_Thu, 18 Sep 2003 09:44:24 -0500448_iso-8859-1 Brian, I will echo all of Brendan's comments, and add that if you follow Brendan's option 1, you probably shouldn't have any problem converting the structure or data by yourself.
Mark ----- Original Message ----- From: "Brendan Friel" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, September 18, 2003 9:24 AM Subject: Re: General question - converting IMS data to DB2 [...]
8316 22 28_Re: Tools & Utilities for V711_Don Birrell31_donald.birrell@JDWILLIAMS.CO.UK31_Thu, 18 Sep 2003 09:45:40 -0500456_- Just thought I'd let you know that we recently swapped out the CA/Platinum Tools for the IBM equivalents. We had been using the CA/Platinum set for six years but went with IBM when the renewal of the contract was up. We do not have any 'go faster utilites' or log products, just the basic catalog and DASD management products. Any support that has been required has been dealt with well by IBM and the documentation for their proudcts is very good. [...]
8339 30 58_Re: Partitions greater than 4 GIG - Addendum to discussion10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 18 Sep 2003 17:01:42 +0200631_us-ascii Estimeed listers
A small add-on to the general discussion about partitions defined using SMS extended addressability and DSSIZE (for DB2 V6, not so current, but I see some PTFs for V7):
DSN1PRNT has some problems when printing pages ranges for tablespace in extended format. There are many PTFs (I've reached the number of 23 as PTF download via IBM Web sites seems not sending all pre-requisites for all PTFs), so before using extended format for TSs take a look to IBM's search database for DSN1PRNT (and some other program like DSN1COPY,DSN1COMP,DSN1CHKR as I see some PTFs changing these programs). [...]
8370 20 36_Re: ABEND=S04E U0000 REASON=00E4034716_Richard Humphris24_Richard.Humphris@CNA.COM31_Thu, 18 Sep 2003 10:16:56 -0500381_- Maybe SYNCSORT works fine with maintainence applied; but we had problems with SYNCSORT when we moved to a 64-bit machine... until SYNCSORT wrote some fixes.
Our MVS team was involved with this, so I don't know many of the details.
But if you moved to a 64-bit machine recently, I'd take a close look at SYNCSORT as a potential source of your problems as well. [...]
8391 24 36_Sample of repair job for broken page15_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Thu, 18 Sep 2003 11:25:22 -0400525_iso-8859-1 Does anyone have a sample to repair a broken page on a tablespace. I would like to just delete those pages.
Carol
Carol Goldberg TSG Database Administration ACS State Healthcare 770-829-1203 9040 Roswell Road Suite 700 Atlanta, GA 30350
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
8416 113 40_Re: Sample of repair job for broken page14_Nelson, Philip34_Philip.Nelson@SCOTTISHWIDOWS.CO.UK31_Thu, 18 Sep 2003 16:29:38 +0100374_iso-8859-1 This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
8530 139 40_Re: Sample of repair job for broken page15_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Thu, 18 Sep 2003 11:32:21 -0400699_iso-8859-1 This would be in a OS390 Mvs 2.10 environment for DB2 Version 7.
Carol
-----Original Message----- From: Nelson, Philip [mailto:Philip.Nelson@SCOTTISHWIDOWS.CO.UK] Sent: Thursday, September 18, 2003 11:30 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Sample of repair job for broken page
This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way. [...]
8670 25 17_out of the office16_Deborah L. Brown23_Deborah.Brown@PHILA.GOV31_Thu, 18 Sep 2003 11:53:16 -0400112_us-ascii I will be out of the office Sept. 19 - Sept 29.
================================================
8696 39 49_Re: General question - converting IMS data to DB214_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 18 Sep 2003 12:01:05 -0400332_ISO-8859-1 Message text written by DB2 Data Base Discussion List >Generally speaking, what's involved in converting an IMS table/view into a DB2 table/view. I'm not familiar with IMS, so I'm curious how much level of
effort is involved. Assume an experience IMS person is doing the work (not myself). Thanks in advance. [...]
8736 42 52_Re: Oracle Transparent Gateway and Stored Procedures10_Peter Wong21_peter.wong@ORACLE.COM31_Thu, 18 Sep 2003 09:35:55 -0700447_us-ascii Oracle Transparent Gateway for DRDA allows you to access DB2 (thru Oracle interface) on any platforms which includes invoking DB2 stored procedure. It provides Oracle application transparency such that SQL syntax/semantics difference, transaction 2pc support, etc for Oracle applications accessing DB2. It wouldn't provide the generic connectivity that you would need to use the stored procedure builder. You would need DB2 connect. [...]
8779 112 36_Re: ABEND=S04E U0000 REASON=00E4034712_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 18 Sep 2003 20:21:24 +0200613_- Hi,
Don't forget that if it's a compressed Tablespace then the following applies (from the Utility manual: Calculating the size of the unload data set: The size required for the unload data set varies depending on the options used for REORG.
1. If you use REORG with UNLOAD PAUSE or CONTINUE and with KEEPDICTIONARY (assuming a compression dictionary already exists), the size of the unload data set, in bytes, can be roughly calculated as the VSAM hi-used RBA for the table space. The hi-used RBA can be obtained from the associated VSAM catalog. For SHRLEVEL CHANGE, add (number of records [...]
8892 42 49_Re: General question - converting IMS data to DB212_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 18 Sep 2003 20:29:11 +0200351_- Hi,
In short: Each segment is turned into a table, Hierarchical structure is managed by using RI. In long: It's more complicated (for example - logical structures ...) I was involved in a such a project about 2 years ago (you can email me privately at: "yassini bezeqint dot net" (write it correctly - it's against harvesters :-) ) [...]
8935 27 24_Re: Real Time Statistics18_Sandra Lakenburger34_sandra.lakenburger@MAIL.SPRINT.COM31_Thu, 18 Sep 2003 13:00:13 -0500468_- On Wed, 17 Sep 2003 07:48:53 -0500, Jeremiah Eden wrote:
>Has anyone experienced any virtual storage problems in the DBM1 address >space related to Real Time Statistics? > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
8963 61 49_FW: General question - converting IMS data to DB212_Isaac Yassin20_yassini@BEZEQINT.NET31_Thu, 18 Sep 2003 21:09:18 +0200306_- Hi,
Sorry - pressed SEND too early ...
I'm working on another one nowadays - redesign for DB2.
There are many things to say on "direct conversion" (we used a tool), but performance is not one of them (in some cases it's ok. in others it's horrible and you have to tweak a lot). [...]
9025 17 23_Use of DSTATS in DB2 V718_Fazal, Syed (TATA)39_Syed.Fazal@CONTRACTORS.NATIONALCITY.COM31_Thu, 18 Sep 2003 14:46:36 -0400368_iso-8859-1 Hi All ~
Is it worth using DSTATS in DB2 V7 or just a regular runstat will suffice.
TIA
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
9043 171 15_Re: DB2 in CICS16_Julian Scharneck20_julian4@TELKOMSA.NET31_Thu, 18 Sep 2003 21:26:11 +0200610_iso-8859-1 Sorry if re-posted, but I don't see this message on the list.
----- Original Message ----- From: Julian Scharneck To: DB2 Data Base Discussion List Sent: Wednesday, September 17, 2003 10:35 PM Subject: Re: DB2 in CICS
> Hi , > > Maybe irrelevant, but I remember having to code a "set current package set" > in a Cobol batch environment. and then having to reset to the relevant > package once control return to the calling program. > > You can also see in CEDF(CICS) what the current plan is after the link. > > > ----- [...]
9215 133 36_Re: ABEND=S04E U0000 REASON=00E4034713_Horacio Villa17_hvilla@AR.IBM.COM31_Thu, 18 Sep 2003 17:04:32 -0300565_UTF-8
Thanks to y'all, but we aren't using SYNCSORT. So, may be SYNCSORT is not your problem either. As I see this problem, sort had already ended at the time the job abended. My original problem was a LOAD REPLACE that abended and lefted 2 indexes in REBUILD PENDING. Couldn't restart LOAD, so I tried REBUILD. Couldn't run REBUILD, so I went to LOAD REPLACE again (this time, with the necessary JCL so it don't abend when asking for the sixth cartridge). But I'd really would like to know why REBUILD abended (as other people in the list, as I see). [...]
9349 47 49_Re: General question - converting IMS data to DB218_Calvetti, Arthur B28_arthur.b.calvetti@BOEING.COM31_Thu, 18 Sep 2003 13:22:20 -0700362_US-ASCII One important consideration in converting an IMS DB to DB2 is the application code. The calls in IMS are very different then SQL. If the application can't be rewritten, other then changing the calls, than a segment to table conversion may be your only option. But as other have said, the best route is to redo the model and rework the application. [...]
9397 64 24_Re: Real Time Statistics13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Thu, 18 Sep 2003 15:59:16 -0500551_- I have been analyzing SOS conditions in our DB2 sysplex. On the last occurrence (which brought down DB2) I scrutinized all my storage and found 4 problems/leaks and we are at RSU0306++ on DB2 and z/OS. The main problem that brought us down was a stack storage (SKB) allocation for 5.8M that went below the line. The below line part, is supposed to be fixed with PQ74741. However, it went below the line, because above the line there was not a 5M slice to put it in. The allocation was for Real Time Statistics from an image copy job. According [...]
9462 77 75_[DB2 UDB V7.1 for OS/390 and z/OS] SUSPENDing in a Data Sharing environment13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Thu, 18 Sep 2003 17:12:26 -0400378_us-ascii Hey, datasharing DBAs! I'm going to be joining the ranks of y'all in about two weeks, and I have a concern...
-The SET LOG SUSPEND command is how we externalize all of our data to DASD for a weekly "flash" copy at present. However, the documentation (DB2 Universal Database for OS/390 and z/OS Command Reference Version 7, SC26-9934-03) says the following: [...]
9540 163 49_Re: DB2 Alert: Version 7 FixPak 10a now available12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 18 Sep 2003 14:25:21 -0700637_us-ascii From the research I did today, it seems that the 3 security holes identified existed earlier. Maybe even forever. Definitely one of the security holes was identified as existing from V5 onwards. So its not new to Fixpack 10.
Myron --- "Whittaker, Stephen" wrote: > I 2nd this question!!!! We are about to put Fixpak 10 on but like Bill has > asked; does FP10 open up this security hole or was it found in an earlier > Fixpak!!! > > Thanks: > --Steve.... > > -----Original Message----- > From: Bill Gallagher [mailto:BILL.GALLAGHER@PHOENIXWM.COM] > Sent: Wednesday, September 17, 2003 [...]
9704 76 25_Re: RI implementation ...12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 18 Sep 2003 14:31:04 -0700420_us-ascii If this is the only difference between DB2 and Oracle that you run into, consider yourself extremely fortunate. Just off the top of my head, I can think of major locking differences, roll-back segments, SQL syntax differences, bit mapped indexes, optimizer differences, hints, image copies, recovery and so forth. I won't say one is better than the other, only different. Each has its good and bad points. [...]
9781 121 28_Re: Tools & Utilities for V710_Trinh Linh24_ltrinh@WOOLWORTHS.COM.AU31_Fri, 19 Sep 2003 08:12:36 +1000352_iso-8859-1 Hi James,
I believe people may think IBM tools is still immature because only the last few years IBM really focus on developping TOOLS such as DB2 Automation, DB2 Change Accumulation Tool .. (equivalent to DASD Manager and Change Manager from BMC or PDA & RC/Migrator from CA (not utilities as IBM utilities were here for ages). [...]
9903 102 28_Re: Tools & Utilities for V710_Trinh Linh24_ltrinh@WOOLWORTHS.COM.AU31_Fri, 19 Sep 2003 08:14:26 +1000713_iso-8859-1 Steve,
Thanks for sharing your experience.
Regards,
Linh Trinh Senior Database Analyst *: 02 9843-1329
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Thursday, 18 September 2003 8:33 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Tools & Utilities for V7
We just upgraded to DB2 v7 OS/390 and we've used CA/Platinum tools for a number of years and we continue to use them. All-in-all, in my opinion, they are good tools and in our environment they have proved to be very useful. But as any 3rd party tool you can have moments of great frustation but from the 'support' end they (CA) have [...]
10006 39 40_Re: Sample of repair job for broken page13_Douglas Hecht14_dhecht@ATT.NET31_Thu, 18 Sep 2003 18:17:53 -0500609_- On Thu, 18 Sep 2003 11:25:22 -0400, Goldberg, Carol wrote:
>Does anyone have a sample to repair a broken page on a tablespace. I would >like to just delete those pages. > > >Carol > >Carol Goldberg >TSG Database Administration >ACS State Healthcare >770-829-1203 >9040 Roswell Road >Suite 700 >Atlanta, GA 30350 > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. [...]
10046 72 28_Re: Tools & Utilities for V714_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 18 Sep 2003 21:22:36 -0400325_ISO-8859-1 Linh,
You raise a good concern for DB2 V8, and certainly other future releases.
While I certainly can't speak for any of the (other) vendors, they all have access to the V8 code in one, or more, of several ways.
Some products are easy to move forward, and others require a larger effort. [...]
10119 120 31_Susan Lawson at SIRDUG, Oct. 1711_Kathy Lisle19_Kathy.Lisle@ATT.NET31_Thu, 18 Sep 2003 21:38:09 -0400357_us-ascii High performance is the holy grail of database professionals. Come see Susan Lawson, internationally recognized consultant and lecturer, show us how to design for top performance today and how to plan for top performance in a future Version 8 environment. In the afternoon, Susan will debunk some of the most persistent DB2 performance myths. [...]
10240 99 32_Re: Question on REORG tablespace13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 19 Sep 2003 03:06:07 GMT722_- Tho:
No, the temp datasets can be on either DASD or TAPE, in any combination.
My REORG step is set up so I can switch back & forth fairly easily between DASD and TAPE if I need to: //STEP040 EXEC DSNUPROC,UID=&JOBNAME..REORG, // SIZE=&SIZE,UTPROC=&UTPROCH, // UTP='*', // COND=(&RGCOND) //* SYSREC IS WHERE THE TABLESPACE DATA IS UNLOADED TO PRIOR TO RELOAD //* IT SHOULD BE THE SIZE OF THE LARGEST TABLESPACE PLUS 10% //SYSREC DD DSN=DBA.&JOBNAME..REORG.tablename.SYSREC, // DISP=(MOD,DELETE,CATLG), // DCB=BUFNO=30,UNIT=(SYSDA,3), <=== TO DASD //*** VOL=SER=(volser1,volser2), // SPACE=(CYL,(1300,260),RLSE) <=== TO DASD //* UNIT=TAPE, <=== TO TAPE //* DCB=(BLKSIZE=32760,BUFNO=30) //* SORTOUT IS A [...]
10340 50 47_Re: DB2 V7 install using workstation installer?13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 19 Sep 2003 03:16:52 GMT391_- I have to agree with Myron. I never could get the workstation installer to work correctly, and I started trying to use it during a V5 migration. Sad to say it hasn't gotten much better in V6 or V7... Too bad really - it has a lot of potential, but the bugs need to be fixed and it needs to be more intuitive and user-friendly to be really useful. I hope the new one for V8 is better. [...]
10391 56 49_Re: DB2 Alert: Version 7 FixPak 10a now available13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 19 Sep 2003 03:34:45 GMT521_- Hi Bill:
My understanding (from reading the DB2 Alert that was sent out about FixPak 10 on 8/28) is that the >4GB Log problem is the only one that was introduced by FixPak 10.
The other 3 (the Security exposures) sound like they've been around for awhile... Probably IBM has been scouring their UDB code for vulnerabilities ever since the virus/worm that attacked SQLServer was unleashed a couple months ago. If so, it's nice to see they're trying to be pro-active (unlike $ome companies we know...) [...]
10448 99 36_Re: ABEND=S04E U0000 REASON=00E4034713_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 19 Sep 2003 03:43:24 GMT565_- Michael/Horatio:
SYNCSORT has a parameter you can pass to allow it to handle very large sort files (there's also a special DDname you can add to your JCL, IIRC, but I don't remember exactly what it is). Check the archives over in IBM-MAIN for details.
Also, instead of specifying SORTNUM 5, it might be better if you allocate the SORTWK datasets specifically in your JCL. SYNCSORT and DFSORT sometimes mis-calculate the sizes & number of work datasets needed for a REORG (particularly if you have variable-length rows or use data compression). [...]
10548 50 25_Re: RI implementation ...44_=?utf-8?B?157Xmdeb15DXnCDXnNeZ15HXqNee158=?=25_mliberman@MIVTACHIM.CO.IL31_Fri, 19 Sep 2003 11:25:35 +0200308_utf-8 Hi Harry, Can you be more specific. DB2 has a good RI implementation (cascade and restrict for example) . Maybe if the IBM library is not good enough (and it is more than possible) you can check at the DB2 FOR Z/OS & OS/390 DEVELOPMENT FOR PERFORMACE by Gabrielle Wiorkowski for more information. [...]
10599 19 25_Re: RI implementation ...7_db2_dba21_db2_dba@BELLSOUTH.NET31_Fri, 19 Sep 2003 07:15:20 -0500545_- "it depends" on how you are planning on doing your migration of data to DB2. if you insert your data into your table programatically, then ri will be enforced and data will not be allowed if you have your constraints in place. so you could leave off the ri definitions and run a program with no problems. then afterwards define your ri and run check utilities on your tables. if you go the load route to populate the tables you can specify "ENFORCE NO" and the data will be loaded. the tablespace will be placed on a check pending status [...]
10619 132 25_Re: RI implementation ...11_ANGOT HARRY18_harry.angot@CDN.FR31_Fri, 19 Sep 2003 15:09:04 +0200401_iso-8859-1 Hi folks,
Thanks for your respone , explicitly the problem is this coding I' ve found in a Oracle DDL :
alter table TRCI_RVNU_DO add constraint FK01_RVNU_DO_OCTPHY foreign key (ID_OCTPHY) references TRCI_OCTPHY (ID_OCTPHY) INITIALLY DEFERRED;
this permits Oracle to check the constraint only before the commit or before leaving the transaction but not at insert . [...]
10752 169 28_Re: Tools & Utilities for V710_Jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Fri, 19 Sep 2003 08:28:07 -0500525_iso-8859-1 Trinh,
I was talking mostly the utilities. As far as IBM tools is concerned, I agree with you that many people still think IBM tools are immature. As V8 is concerned, one of the advantages of IBM tools is that they promise the product will support new IBM release from day 1. (I really sound like a salesperson now. For the record, I do work for IBM and I am not a salesperson. I don't have any financial gain other than my stock will worth may be 0.01 cent more if you buy IBM tools.) I have a lot of [...]
10922 226 28_Re: Tools & Utilities for V70_17_sjvagnier@AEP.COM31_Fri, 19 Sep 2003 09:40:29 -0400315_us-ascii I agree with James. I have been though this mess of swapping out tools so many times it's getting real tiresome. We are presently using IBM batch utilities and supplementing with BMC tools. When DB2 V8 becomes GA, it's going to be real interesting as far as tools compatibility with DB2 ...... again. [...]
11149 40 17_Corigin Extractor17_Sanfilippo, David34_David.Sanfilippo@GMACINSURANCE.COM31_Fri, 19 Sep 2003 10:46:52 -0500571_iso-8859-1 Does anyone have any experience with Corigin Extractor? It claims to provide fast read-only access to DB2 for OS/390 data (from a Unix or NT box) by completely by-passing the mainframe and DB2. It uses its own optimizer, which they claim is as fast as DB2's optimizer. We've got some folks here who think this may be the answer to freeing up some mainframe cycles. My fellow DBAs and I are skeptical (to say the least). Does anyone know more than the information available in the sales blurb? TIA. Kathy Lisle Kathy.Lisle@GMACInsurance.com (336) 770-8384 [...]
11190 23 27_RVA SNAPSHOT - OS/390 - DB22_Su22_subha_sivaji@YAHOO.COM31_Fri, 19 Sep 2003 12:39:09 -0500320_- Hi Listers,
I am working with OS390 - DB2 V6.1. We have been going through the process of using SNAP to clone a new subsystem. As per the procedure , I do SNAP at DD level to an intermediate DD and use DSN1COPY to create actual Data .Does this intermediate SNAP DD requires the same size as the Source DD. [...]
11214 15 32_Re: Question on REORG tablespace9_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 19 Sep 2003 13:03:49 -0500492_- The most common reason for a REORG to fail is running out of space in SYSUT1, SORTOUT, etc. If you specify SORTKEYS you can eliminate SYSUT1 and SORTOUT entirely plus the REORG will run faster.
Jim Ruddy DB2for z/OS Development
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
11230 84 31_Re: RVA SNAPSHOT - OS/390 - DB212_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Fri, 19 Sep 2003 14:04:58 -0500331_us-ascii Your subsystem is going to need the same size unless you SNAP at the dataset level instead of the volume level. If you SNAP at the dataset level, and are on SMS, you can stack it tighter per se than on your production storage group.
For example: Source=100 volumes 60% utilized Target=60 volumes 100% utilized [...]
11315 16 60_Katherine A Langdon/Silicon Valley/IBM is out of the office.19_Katherine A Langdon19_klangdon@US.IBM.COM31_Fri, 19 Sep 2003 18:38:45 -0600459_US-ASCII I will be out of the office starting September 19, 2003 and will not return until September 23, 2003.
If you have an urgent request, please contact Sue Sloan (408-463-4788). Thanks. -Kate
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
11332 13 37_Mark Hardenburg is out of the office.15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Sat, 20 Sep 2003 01:05:23 -0400350_us-ascii I will be out of the office starting 09/18/2003 and will not return until 09/22/2003.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
11346 32 57_Anita D N CHAN/SED IT APH/HBAP/HSBC is out of the office.10_Anita Chan23_anitadnchan@HSBC.COM.HK31_Sat, 20 Sep 2003 14:11:30 +0800635_us-ascii I will be out of the office from 09/19/2003 until 10/09/2003.
I will respond to your message when I return.
For urgent matter, please contact Fung Kam Yiu on ext 21555 (IDMS) or Vera Tang on ext 21807 (DB2).
********************************************************************** 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. [...]
11379 112 70_Re: JDBC and PC-based JAVA application connection problems to z/OS DB212_Gary Joehlin16_Gjoehlin@AOL.COM29_Sat, 20 Sep 2003 02:27:54 EDT532_US-ASCII Dear Listers:
I seek assistance from the folks that use JDBC application (ie PC-based, in JAVA) that is attempting to connect to DB2 z/OS. I have found a vast emptiness on documenation that has the complete picture and answers to step-by-step problems in this nether-world.
I have successfully compiled a JAVA (PC-based) application. However, when I run it, I am getting: "COM.ibm.db2.jdbc.DB2Exception: [IBM] [JDBC Driver] CLI0615E Error receiving from socket, server is not responding. SQLSTATE=08S01" [...]
11492 34 32_Re: Question on REORG tablespace12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 20 Sep 2003 10:16:12 +0200529_- Hi,
It means that SYNCSORT will abend faster :-)))
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Jim Ruddy Sent: Friday, September 19, 2003 8:04 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Question on REORG tablespace
The most common reason for a REORG to fail is running out of space in SYSUT1, SORTOUT, etc. If you specify SORTKEYS you can eliminate SYSUT1 and SORTOUT entirely plus the REORG will run faster. [...]