1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2006, week 3
2 134 16_Re: Online Reorg14_Andy Lankester26_alankester@CDBSOFTWARE.COM31_Wed, 15 Feb 2006 01:45:12 -0600371_windows-1250 What is certain is that during the fastswitch/rename phase DB2 MUST have exclusive control i.e. a DRAIN ALL. This is true for every on-line reorg vendor including IBM. Normal 'regularly committing' work will not be a problem - it will simply wait for the switch to complete. However if you have long-running non-committing readers your reorg will fail. [...]
137 45 32_Re: www.lazydba.com DBA Listserv14_Martin Flavell18_mflavell@I-TCS.COM31_Wed, 15 Feb 2006 08:07:41 +0000
183 109 26_DB2 Z/oS V7: Data Recovery21_Sriramulu, Vijayababu28_vijayababu.sriramulu@EDS.COM31_Wed, 15 Feb 2006 15:45:10 +0530579_us-ascii Dear List,
We have the following terrific situation on one of the tablespaces.
* LOAD REPLACE LOG NO done on a tablespace. Existing data lost. * Fully image copy taken about 4 months back as it looks in SYSCOPY. But dataset has been deleted and uncataloged * Only the last 2 weeks incremental copies are existing * Tried a BMC LOG MASTER LOGSCAN run with FROM TIME 01/01/2005. It said log dataset details not existing in BSDS. When I did a DSNJU004, BSDS contains log information only for this month. Not too sure where I can look for the information [...]
293 25 34_Alter Column length and Static SQL5_Patri32_patrizia.andreetta@ELECTROLUX.IT31_Wed, 15 Feb 2006 05:18:53 -0600320_- Hy, I'm working on Db2 for z/Os 7.1.
I have changed the column length of a column (by drop e create table) COL1 CHAR(35) to COL1 CHAR(100).
Do you Know if I have to recompile Cobol programs with static SQL that refers to this column also if I'm interesting only in the first 35 characters of COL1 ? [...]
319 154 30_Re: DB2 Z/oS V7: Data Recovery13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 15 Feb 2006 12:36:59 +0100840_US-ASCII You can't. It's gone.
Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
"Sriramulu, Vijayababu" Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 15-02-06 11:15
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] DB2 Z/oS V7: Data Recovery
Dear List, We have the following terrific situation on one of the tablespaces. LOAD REPLACE LOG NO done on a tablespace. Existing data lost. Fully image copy taken about 4 months back as it looks in SYSCOPY. But dataset has been deleted and uncataloged Only the last 2 [...]
474 169 16_Re: Online Reorg9_Dan Lamas22_dlamas@DUKE-ENERGY.COM31_Wed, 15 Feb 2006 07:17:13 -0600315_US-ASCII You can specify TIMEOUT TERM. This will let the REORG end with a CC008 and not place any of the objects in an unusable state. But it is as if the REORG never took place. You will have to rerun the REORG from the beginning. If your environment can not handle any downtime then this could work for you. [...]
644 89 42_Re: Getting Source of DB2 Stored Procedure13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 15 Feb 2006 08:42:09 -0500471_- Hello Deanna,
What platform are you using and what is the source language of your stored procedures? Are you looking for the CREATE PROCEDURE statements? Or those and the source code containing the logic of the SP?
It sounds like you are referring to z/OS. The source to Stored Procedures written in SQL Procedures Language are in the DB2 catalog. But for JAVA(in v6), COBOL, Rexx, PL/I, ASM procedures those will be in a source manager outside DB2. [...]
734 72 32_Re: www.lazydba.com DBA Listserv7_Ed Long19_rdhm99a@PRODIGY.NET31_Wed, 15 Feb 2006 06:57:23 -0800346_iso-8859-1 I signed up for the LazyDBA listserv a month or so ago in summary/digest form. I got their digests for about 10 days then got an email saying I had been dropped due to 'bandwidth' issues and had to reapply. I didn't. I also didn't send them any $. Probabily just a coincidence since they claim that the $ only gets you 'support'. [...]
807 83 30_Re: DB2 Z/oS V7: Data Recovery9_Mike Bell21_mbell11a1@VERIZON.NET31_Wed, 15 Feb 2006 09:00:34 -0600589_Windows-1252 From DB2 standpoint - you are unrecoverable. The only options left are any pack dumps that were taken by your storage group. Many shops exclude the DB2 pool from pack dumps because DB2 has it's own recovery but some dump the volumes anyway. If the pack dumps include your DB2 data, you will have to find the volume that contained the tablepsace before the LOAD REPLACE did the delete/define. (If the load specified REUSE, the delete define is skipped and it is the same volume). Restore the dataset using whatever dumped the volume (FDR and DFDSS are the normal products [...]
891 139 16_Re: Online Reorg12_Stone, Lynda29_Lynda.Stone@LIBERTYMUTUAL.COM31_Wed, 15 Feb 2006 10:02:29 -0500539_us-ascii Hi,
I would recommend running your online reorg at the tablespace level if possible, as the partition level reorgs will introduce a much higher outage during the build2 phase, as each NPI will be rebuilt serially, when they're rebuilt concurrently during the tablespace level reorg.
We support an active application (~ 30 million transactions per day) and reorg all our tablespaces online - many of which are partitioned heavily with from 2-12 NPI's each. We use the following control card (most of the time) - [...]
1031 49 38_Re: Alter Column length and Static SQL14_Bernd Oppolzer26_bernd.oppolzer@T-ONLINE.DE31_Wed, 15 Feb 2006 16:01:24 +0100366_iso-8859-15 Yes, I think so, because if not you would probably get a nonzero SQLCODE (or SQLSTATE) when the COBOL program first receives a col1 value longer than 35.
This is a warning, but some programs will probably handle it as an error. At our site, for example, every nonzero SQLSTATE (well, not 02000, of course) is treated as an error, by default. [...]
1081 38 27_COALESCE() rewrite question15_Nguyen Duc Tuan17_ndt.db2@GMAIL.COM31_Wed, 15 Feb 2006 09:25:27 -0600474_- Dear all,
The developers submitted to me this SQL ,
SELECT xxx WHERE (..) col1 = :hv0 AND COALESCE(coldate1,coldate2,'0001-01-01') between :hv1 and :hv2)
An index exists on (col1,coldate1)
I would like the query to be changed in order to have matching column =2 , i would rewrite it as :
(..) col1 = :hv0 AND ( (coldate1 is not null and coldate1 between :hv1 and :hv2) OR (coldate2 is not null and coldate2 between :hv1 and :hv2) ) [...]
1120 63 48_Re: Z/OS V7 Dynamic SQL, Parm markers and Unions11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 15 Feb 2006 09:43:50 -0600395_- Mathew,
Since your SQL works with literals, I assume the parm problem is with the WHERE clause, not the SELECT list.
You can issue DESCRIBE INPUT to see how many parms (and what type) DB2 thinks there are - it will be populated in the SQLDA.
For a detailed discussion, see ther Redbook - SG24-6418. Section 3.12 covers DESCRIBE INPUT and Chapter 6 has REXX examples. [...]
1184 24 48_Re: Z/OS V7 Dynamic SQL, Parm markers and Unions12_Matthew Rhea24_matthew_rhea@CONSECO.COM31_Wed, 15 Feb 2006 10:35:19 -0600415_- Well, well, well. I finally figured out my problem. It helps if you list the parms correctly.
"EXECSQL OPEN C1 USING :dbname1, :obj1, :dsnum1, :dbname2, :obj2, :dsnum2" is correct.
"EXECSQL OPEN C1 USING :dbname1, :obj1, :dsnum1, :dbname2:, :obj2, :dsnum2" is not correct.
I will definitely look at the red book and try out DESCRIBE INPUT. That would be a very helpful statement to use. [...]
1209 55 72_V8 Migration, Broken OBD, DSNTIJPM report 4, removed from migration path14_Mark McCormack27_mamccormack@STATESTREET.COM31_Wed, 15 Feb 2006 12:20:11 -0500348_US-ASCII < I have to tell someone about this .... After negotiating four months, < DSNTIJPM report 4 query will be removed from the z/OS UDB R710 -> < R810 migration path. PK15146. < < Linda Hagedorn
Linda,
After reading your short post to DB2-L, I just had to respond. I could read between the lines and feel your exasperation. [...]
1265 25 49_A caution for mixed mode (V8 COMPAT and V7) shops5_Larry34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Wed, 15 Feb 2006 11:33:15 -0600371_us-ascii We have encountered a problem as we migrate a package that was prepared on a V8 COMPAT mode platform as it is sent to a version 7 system. It appears that when you use the ^< predicate in a statement , your DBRM that was created on version 8 (compat mode) cannot be migrated to a version 7 platform. (this is the "not" sign above the six key on a key board) [...]
1291 88 53_Re: A caution for mixed mode (V8 COMPAT and V7) shops13_Keemle Joan T25_KeemleJoanT@JOHNDEERE.COM31_Wed, 15 Feb 2006 12:04:37 -0600590_iso-8859-1 Here is some additional information out of my IDUG presentation. This is definitely an issue for those using EBCDIC CCSID 37, but may not be a problem for other CCSIDs.
Beware the "Not" Sign Problem!
We experienced a compatibility issue associated with usage of the 'not' sign character, ^ (caret) or ¬ (sideways-L). The V8 precompiler parses SQL in Unicode, so it converts the not sign ^ (x'5F') from source code into Unicode, then back to EBCDIC (CM and ENFM only) not sign ¬ (x'B0) in the DBRM. This will bind just fine on the same release of DB2. However, [...]
1380 217 42_Re: Using subqueries in From clause in DB213_Terry Purcell18_tpurcel@US.IBM.COM31_Wed, 15 Feb 2006 11:58:19 -0600354_- Kaushal,
The zparm itself is online changeable (the ++HOLD info for the PMR will indicate this). The PTF itself introduces the zparm, but does NOT enable it. You will need to enable this yourself.
Just to clarify, this is for correlated nested table expressions (also known as sideways reference), rather than correlated subqueries. [...]
1598 80 31_Re: COALESCE() rewrite question13_Terry Purcell18_tpurcel@US.IBM.COM31_Wed, 15 Feb 2006 12:29:07 -0600375_- These are not equivalent.
The COALESCE will only evaluate the COLDATE2 column comparison if the COLDATE1 is NULL. Whereas the OR example will check COLDATE2 if COLDATE1 fails (regardless of whether it fails because it is NULL or it is outside the BETWEEN range). Also, you have ignored the 3rd check from the COALESCE (which kicks in if both columns are NULL). [...]
1679 174 16_Re: Online Reorg9_SAM HARVY23_db2_explore@HOTMAIL.COM31_Wed, 15 Feb 2006 13:42:06 -0600361_- Thanks to you all for your advice.
We have decided not to reorg partition wise and go for the Tablespace instead.
Does the fact that the runstats are not current on this TS with arouns 600 million rows hve any impact on the reorg?
The batch jobs and the onlines that run without retry logic during the switch phase will abend Right? [...]
1854 60 31_Connect from AS400 to DB2 OS39010_Kathy Long21_kathy.long@KROGER.COM31_Wed, 15 Feb 2006 15:01:13 -0600361_ISO-8859-1 We have a user who needs to connect from the AS400 and run a query on a table in DB2 on the OS390. We are DB2 V7. He is able to connect, but not able to complete the query. I believe it is because the package bind does not complete successfully. From reading, it sounds like this should happen automatically, the first time he tries to connect. [...]
1915 372 35_Re: Connect from AS400 to DB2 OS39024_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Wed, 15 Feb 2006 16:35:25 -0500446_iso-8859-1
Kathy, No, you don't need DB2 Connect. Distributed Relational Database Architecture (DRDA) is implemented via DB2 connect from Intel and RISC platforms. The reason for this is that IBM iSeries (AS/400) and zSeries platforms using the EBCDIC coding scheme (extra points for all of you out there who know what that stands for) must have their data streams translated into ASCII (ditto) for Intel and RISC... and vice versa. [...]
2288 58 30_Re: DB2 Z/oS V7: Data Recovery0_22_DB2information@AOL.COM29_Wed, 15 Feb 2006 17:49:40 EST490_US-ASCII Vijay, When you say the Full image copies are still recorded in the syscopy, but has been deleted and uncataloged, do you mean the image copies were on disk? If on tape and the tape has not been written on since the image you can use dsn1copy. You will have problems because you will have to manually get the DBID, PSID and all OBIDs. If you had the GENDB2 recovery tool installed it would automate the process of getting all the IDs and generating the job and control cards. [...]
2347 24 38_z/OS v7 DB2 and java stored procedures14_Bruce Lightsey30_Bruce.Lightsey@ITS.STATE.MS.US31_Wed, 15 Feb 2006 17:02:21 -0600315_US-ASCII My z/OS sysprog just came around to ask which JDK to order with our new server-pack 31-bit or 64-bit ?
I drew a blank ( and gave him that famous "dumb look" ) so I thought I'd ask.........
Does DB2 V7 on z/OS care which JDK is installed? And if it does, which is the preferred version ? [...]
2372 26 32_LOCK TABLE and COMMIT - DB2 z/OS9_Ken Paris20_KenParis17@GMAIL.COM31_Wed, 15 Feb 2006 17:07:12 -0600455_- We are on DB2 z/OS version 7. We have a SQL Stored Procedure which does a LOCK TABLE IN EXCLUSIVE MODE and sometimes does a subsequent COMMIT. We need to keep the table lock for the entire execution, so we added RELEASE (DEALLOCATE) to the bind parms.
However, in those cases where the input parms result in a COMMIT occurring, the program seems to release the table lock immediately, even though it keeps running for another minute or two. [...]
2399 258 42_Re: z/OS v7 DB2 and java stored procedures13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 15 Feb 2006 15:56:18 -0800700_us-ascii After reading the following, I decided on the 31-bit flavor. From http://www-03.ibm.com/servers/eserver/zseries/software/java/j5pcont31.ht ml
Who Should Use this SDK5 Product IBM 31-bit SDK for z/OS, Java 2 Technology Edition, V5 (5655-N98) will be attractive primarily to customers and ISVs whose Java applications are not constrained by 31-bit addressing and who wish to use Java SDK5. In contrast, Java applications that are storage constrained by 31-bit addressing should be able to execute in a 64-bit environment provided by the 64-bit product, IBM 64-bit SDK for z/OS, Java 2 Technology Edition, V5 (5655-N99). The two products are complementary, have the same SDK5 APIs, [...]
2658 209 22_ADMIN: Subject headers16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 15 Feb 2006 20:26:06 -0500553_iso-8859-1
As is my practice, once in a wile I send out a post suggesting/reminding posters about the subject header when they pose a new thread here.
As we all know there is a fairly high volume of new posts on a daily bases. And this listserv covers both the Z/OS and LUW environment. Now not everyone here is reading all the posts. We all have a lot on our plate. So the question is how can we get those people who have the experience in the arena that the question pertains read/respond to the question you have. [...]
2868 93 32_Re: www.lazydba.com DBA Listserv16_Galambos, Robert29_Robert.Galambos@COMPUWARE.COM31_Wed, 15 Feb 2006 20:45:42 -0500782_iso-8859-1
Very little on Z/OS.
Robert Galambos
Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 V7 Database Administration robert.galambos@compuware.com
Tel: +1 905 866 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888
Compuware Canada
Service is our best product Les renseignements contenus dans le présent message électronique sont confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il est strictement interdit de distribuer ou de copier ce message. Si vous avez reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et effacer ou détruire toutes les copies du présent message. [...]
2962 177 30_Re: DB2 Z/oS V7: Data Recovery21_Sriramulu, Vijayababu28_vijayababu.sriramulu@EDS.COM31_Thu, 16 Feb 2006 15:07:14 +0530465_us-ascii The image copy datasets were on tape with a retention period of 7 and 15 for local and remote. So obviously the datasets were lost after 2 weeks time. Also i am pretty sure the tapes are being reused which means potentially the datasets are unrecoverable.
S.Vijayababu DB2 DBA e India Pvt. Ltd. #4, Canal Bank Road, Taramani Chennai - 600113 India *: +91-44-22549650 Extn: 3027 Mobile: 98401 10909 * mailto:Vijayababu.Sriramulu@eds.com [...]
3140 34 15_Query Patroller15_Haldur Johansen18_haldur@ELEKTRON.FO31_Thu, 16 Feb 2006 04:31:35 -0600565_ISO-8859-1 Hi,
I am trying to set up a Query Patroller server on a specified DB2 database. (DB2 8.2 for Windows)
I am following the command syntax and write on my db2cmd prompt:
D:\>qpsetup DB dbname CONTROL_TABLESPACE qpc CONTROL_PATH 'R:/PATH' RESULT_TABLESPACE qpr RESULT_PATH 'R:/PATH' REPLACE
but I am getting this error:
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "CREATE REGULAR TABLESPACE QPCFB MANAGED BY" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "". SQLSTATE=42601 [...]
3175 160 63_Re: Backup tablespace V7 and restore in V8 DB2 ZOS is possible?13_Michael Ebert18_mebert@AMADEUS.COM31_Thu, 16 Feb 2006 11:46:57 +0100572_US-ASCII As far as I'm aware, any DB2 on zOS version can utilize all previous backups. I've been around since V4 (now V7), and no upgrade ever specified the requirement to re-take ICs.
Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
Luis Miguel Marti?nez Chavez Please respond to DB2 Database Discussion list at IDUG Sent by: DB2 Data Base Discussion List 15-02-06 03:29 [...]
3336 39 45_z/OS: DB2 V 7.1 Pagesets not found in catalog16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Thu, 16 Feb 2006 03:22:22 -0800384_iso-8859-1 Hi!!
We have Landmark/TMON installed and it is recording the following message:
TMDB00823I - PAGESETS NOT FOUND IN CATALOG(S) FOR DB3P = 0000364
DB3P is our Production subsystem. I beleive that the above message means that for some of the tablespaces defined in the DB2 catalog, there are no actual 'physical' datasets found. Can someone confirm? [...]
3376 55 19_Re: Query Patroller37_=?iso-8859-9?B?RmVyaGF0IN5lbmf2bvxs?=29_Ferhat.Sengonul@ISBANK.COM.TR31_Thu, 16 Feb 2006 15:10:05 +0200472_iso-8859-9 Hi, Create the tablespaces first; and then send the qpsetup command with only the names of the tablespaces.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Haldur Johansen Sent: Thursday, February 16, 2006 12:32 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Query Patroller
Hi,
I am trying to set up a Query Patroller server on a specified DB2 database. (DB2 8.2 for Windows) [...]
3432 52 20_Rebind Package Error15_Thomas Karlsson23_thkar1957@OPERAMAIL.COM31_Thu, 16 Feb 2006 16:12:39 +0100474_iso-8859-1 in Z/OS DB2 V8 Compability Mode.
We upgraded a DB2V7 to a DB2V8 Compability mode. All works as it should except one Package so far.
I can't find out why, it looks as other packages which works.
Any idea ?
DSN SYSTEM(DB2P) DSN REBIND PACKAGE (M90.M9W5110.(2001-01-26-13.27.52.047829) ) (CS); DSN ENDED DUE TO ERROR+ SYSTEM ABEND CODE 0C4 REASON CODE 00000038 PSW 077C30019A44C41E ASIDS: HOME = 005D PRIMARY = 0098 SECONDARY = 0098 [...]
3485 78 49_Re: z/OS: DB2 V 7.1 Pagesets not found in catalog9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Feb 2006 09:31:01 -0600349_Windows-1252 I would suggest you open a problem with TMON support. Since TMON put out the alert, I would assume it can find the detail.
The other alternatives that come to mind are things like 1. issue -start database for all the databases then issue -dis database restrict or 2. run runstats for all the tablespaces and look for abends [...]
3564 106 49_Re: z/OS: DB2 V 7.1 Pagesets not found in catalog14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 16 Feb 2006 15:37:53 -0000402_US-ASCII And whether this is indeed a problem or not depends on whether you have defined anything with "DEFINE NO"! (my reading of the message seems to say that there are 364 of them) - surely TMON will allow you to list them somewhere/somehow?
Phil Grainger CA Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
3671 128 35_Mainframes Staying at Merrill Lynch11_John Wynton21_jwynton@THEMISINC.COM31_Thu, 16 Feb 2006 10:44:32 -0500455_us-ascii Folks:
Posted on IBM-MAIN this morning: "Interesting article about Mainframes at Merrill Lynch
Merrill Lynch & Co.: Living Legacy
"We are making the mainframe strategic to our future. It's a fundamental decision," he says. "Back in the 1990s, it was trendy to say you were migrating off the mainframe. Now, I couldn't predict when the mainframe will go away. If anything, technologies like X4ML have given it new life." [...]
3800 212 37_Antwort: [DB2-L] Rebind Package Error11_Roy Boxwell16_R.Boxwell@SEG.DE31_Thu, 16 Feb 2006 16:39:11 +0100761_us-ascii Hi! I would look at APAR
PK07917: ABEND 0C4-00000038,LOC=DSNXGRDS.DSNXO1S +3CCE 0C4 DURING A REBIND PACKAGE IN R810
**************************************************************** * USERS AFFECTED: ALL DB2 R810 USERS. * **************************************************************** * PROBLEM DESCRIPTION: ABEND0C4 RC00000038 in DSNXO1S +3CCE * * may occur for query where the explain * * tables are accessed for the update * * symmetric view SQL statement. * * * * Note: * * symmetric view - create view with * * a check option. * **************************************************************** * RECOMMENDATION: * **************************************************************** [...]
4013 333 35_Re: Connect from AS400 to DB2 OS39014_Krnic, Ivan B.18_ikmrb@ALLSTATE.COM31_Thu, 16 Feb 2006 09:39:45 -0600739_iso-8859-1 EBCDIC = Extended Binary Coded Decimal Interchange Code ?
Ivan
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of The Fillmore Group, Inc. Sent: Wednesday, February 15, 2006 3:35 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Connect from AS400 to DB2 OS390
Kathy, No, you don't need DB2 Connect. Distributed Relational Database Architecture (DRDA) is implemented via DB2 connect from Intel and RISC platforms. The reason for this is that IBM iSeries (AS/400) and zSeries platforms using the EBCDIC coding scheme (extra points for all of you out there who know what that stands for) must have their data [...]
4347 37 8_db2exsrv10_John Lantz20_john.p.lantz@FRB.GOV31_Thu, 16 Feb 2006 09:40:42 -0600728_- I have DB2 personal edition (v8.1 fixpack 10) installed and trying to execute DB2EXPLN. I'm getting the following error. Has anybody else experienced this?
HERE IS THE COMMAND I'M EXECUTING... >db2expln -database sales_db -stmtfile c:\misc\explain_sql.txt - terminator ; -terminal
AND THIS IS THE ERROR I'M GETTING... Error during explain call. Message Text = SQL0444N Routine "explain" (specific name "SQL060216090633710") is implemented with code in library or path "\db2exsrv", function "explain" which cannot be accessed. Reason code: "4". SQLSTATE=42724 sqlcaid = SQLCA sqlcabc = 136 sqlcode = -444 sqlstate = 42724 sqlerrml = 46 sqlerrmc = "explain", "SQL060216090633710", "\db2exsrv", "explain", "4" [...]
4385 22 55_NEODBUG presents Daniel Luksetich March 23 in Cleveland11_James Szabo18_jim.szabo@CORE.COM31_Thu, 16 Feb 2006 11:01:03 -0500483_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) presents our annual educational meeting on March 23, 2006.
We are pleased to present Daniel Luksetich of Yevich, Lawson & Associates, who will speak on the topic "SQL and DB2 for z/OS Database Performance Analysis and Techniques".
The costs for this meeting are: $199 for pre-registered members, $225 at the door, $225 for pre-registered non-members, $250 at the door. Find out more at www.neodbug.org. [...]
4408 18 49_Re: z/OS: DB2 V 7.1 Pagesets not found in catalog10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 16 Feb 2006 16:57:42 +0100665_US-ASCII If the problem is missing a underlying LDS (in prod ?????? orror !) you could use the good old DIAGNOSE ICFCAT......
Max Scarpa Certified SRB (Salary Robber Bi-certified)
--------------------------------------------------------------------------------- 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
4427 20 63_Re: Backup tablespace V7 and restore in V8 DB2 ZOS is possible?28_Luis Miguel Marti?nez Chavez20_luismmch66@YAHOO.COM31_Thu, 16 Feb 2006 10:52:04 -0600767_- Thanks Michael,
But I was wondering for below:
1.- SYSCOPY CATALOG changes (Unicode) and the format of DB2 internal structures like OBID, PSID allows us to recover in V8 ?
2.- Does DSN1COPY works in this situation in a transparent fashion?
Thanks a lot again
--------------------------------------------------------------------------------- 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
4448 169 63_Re: Backup tablespace V7 and restore in V8 DB2 ZOS is possible?13_Michael Ebert18_mebert@AMADEUS.COM31_Thu, 16 Feb 2006 18:16:45 +0100501_US-ASCII The V8 Catalog/Directory is a different matter. In order to convert it to Unicode, and longer columns et al, you run REORGs on the tablespaces. You have to take a new IC during or after a REORG so it's a different situation. You can't recover "through" a REORG or LOAD REPLACE (whether it is LOG YES or NO) so ICs taken before that time become useless for a recovery to current. It is the same situation as for "normal" tablespaces; it has nothing to do with the DB2 version difference. [...]
4618 18 25_SQL question v7 on os/39014_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Thu, 16 Feb 2006 11:29:49 -0600688_us-ascii I have a: select distinct a, count(*), substr(b,1,40) from tbla;
The issue is b is a column that is varchar over 255 and I only need the first 40 characters so can anyone tell me how to get the result?
--------------------------------------------------------------------------------- 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
4637 50 29_Re: SQL question v7 on os/3909_Agus Kwee19_askwe@OPTONLINE.NET31_Thu, 16 Feb 2006 12:47:51 -0500408_us-ascii Allen,
I think the solution is:
select a, count(*), first_40 from ( select a, substr(b,1,40) as first_40 from tbla) as x group by a, first_40 ;
Regards, Agus Kwee Themis Training http://www.themisinc.com
----- Original Message ----- From: "Zobjeck, A. J." Date: Thursday, February 16, 2006 12:29 pm Subject: [DB2-L] SQL question v7 on os/390 [...]
4688 64 63_Re: Backup tablespace V7 and restore in V8 DB2 ZOS is possible?9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Feb 2006 11:29:33 -0600304_Windows-1252 1. SYSCOPY isn't unicode - you can run DSN1PRNT to see for yourself. It wouldn't matter if it was unicode because DB2 converts stuff from unicode to ebcdic all over the place. And after a migration all data in SYSCOPY and SYSLGRNG is still usable for recovery without new image copies. [...]
4753 51 23_DB2 v8 and CA Utilities13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Thu, 16 Feb 2006 10:57:06 -0800480_us-ascii Is anyone on the list running DB2 version 8 and using any CA DB2 utilities? Would you mind telling me, on or off list, which ones you have, and whether they work with DB2 version 8?
We are one of the last shops on the planet to not purchase IBM's "optional" DB2 tools, and we're trying to figure out what that means for our migration to version 8. We are getting conflicting data from CA sales folk, so I have been asked to find out what is really happening. [...]
4805 68 47_z/OS DB2 v7.1.1 Extending nonpartitioned spaces18_Dimitrios VALSAMIS20_valsamis.d@GMAIL.COM31_Thu, 16 Feb 2006 21:46:06 +0200336_ISO-8859-1 Hi All !
In DB2 Admin Guide (Chapter 4, section 'Extending DB2-managed data sets', paragraph 'Extending nonpartitioned spaces') we read:
"... When the end of the first piece is reached, DB2 defines a new piece (which is a new data set) and extends that new piece starting with a primary allocation space." [...]
4874 79 51_Re: z/OS DB2 v7.1.1 Extending nonpartitioned spaces9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Feb 2006 14:25:23 -0600456_Windows-1252 Umm, NO - the limit for non-partition table space is still 2GB - It is tied to the physical dataset access from media manager which allowed for 4 bytes RBA within the dataset. They avoided the problems with negative numbers by staying with 2GB max even though VSAM supports 4GB and has for a while. If you look at how the RID is made up, 64GB is the maximum number of 4K pages that can be addressed with the 3 bytes available in the RID. [...]
4954 45 51_Re: z/OS DB2 v7.1.1 Extending nonpartitioned spaces18_Dimitrios Valsamis20_valsamis.d@GMAIL.COM31_Thu, 16 Feb 2006 16:14:46 -0600465_- Mike hi -
Thanks a lot for the reply. Your explanation does make sense. However, what I don't understand is why the Admin Guide mentions that the maximum partition size for nonpartition tablespaces is 4GB. We have, for example, a non-partitioned table space that spans over 6 volumes (3390 type 3) occupying 43695 tracks (2GB) in the first 5 volumes and 41670 tracks in the last one. Doesn't this make makes the tablespace occupy a lot more than 4GB? [...]
5000 97 51_Re: z/OS DB2 v7.1.1 Extending nonpartitioned spaces9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Feb 2006 17:42:16 -0600328_Windows-1252 from the admin buide for V8 When a data set in a segmented or simple table space reaches its maximum size of 2 GB, DB2 might automatically create a new data set. The primary data set allocation is obtained for each new data set. It doesn't say but the maximum number of datasets for simple or segmented is 32. [...]
5098 85 51_Re: z/OS DB2 v7.1.1 Extending nonpartitioned spaces9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Feb 2006 17:54:43 -0600362_Windows-1252 Sorry - didn't answer both your questions - Check the high used rba for the dataset and check that it didn't create an A002 dataset. It may have been allocated with a large primary allocation on the last volume even though DB2 won't use more than 2 GB of the dataset. Thats why you need to be carefull of the priqty and secqty for allocations. [...]
5184 28 51_Re: z/OS DB2 v7.1.1 Extending nonpartitioned spaces18_Dimitrios Valsamis20_valsamis.d@GMAIL.COM31_Fri, 17 Feb 2006 00:14:45 -0600528_- Thanks a lot Mike! I'll do that.
Thanks again,
Dimitrios
On Thu, 16 Feb 2006 17:54:43 -0600, Mike Bell wrote:
>Sorry - didn't answer both your questions - >Check the high used rba for the dataset and check that it didn't create an >A002 dataset. It may have been allocated with a large primary allocation on >the last volume even though DB2 won't use more than 2 GB of the dataset. >Thats why you need to be carefull of the priqty and secqty for allocations. > >Mike > [...]
5213 107 35_Re: Z/Os DB2 V7 : DSSIZE alteration22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Fri, 17 Feb 2006 10:26:38 +0200655_iso-8859-1 I advise manual rebind instead of auto for rename process.
Before starting the procedure, record the dependent plans/packages somewhere and rebind them at the end.
Regards, Cuneyt Goksu
-----Original Message----- From: Sriramulu, Vijayababu [mailto:vijayababu.sriramulu@EDS.COM] Sent: Tuesday, February 07, 2006 2:04 PM Subject: Re: Z/Os DB2 V7 : DSSIZE alteration
Hi Larry,
After the RENAME's, will AUTO REBIND not take effect. Since there are no changes/alterations to the table structure, the auto rebinds are expected to go fine. Is that right ? Am I missing something here ? [...]
5321 177 42_Re: Crystal reports ODBC/JDBC connectivity22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Fri, 17 Feb 2006 11:14:58 +0200446_US-ASCII Crystal reports ODBC/JDBC connectivityMy client used it w/o Db2 connect. They downloaded some ODBC driver from MS web site for DB2.
It's working so far but I did not find a chance to look for it's performance.
Cuneyt Goksu
-----Original Message----- From: Agarwal, Amit [mailto:amit_agarwal@STANDARDANDPOORS.COM] Sent: Thursday, February 09, 2006 4:17 PM Subject: Crystal reports ODBC/JDBC connectivity [...]
5499 194 24_Re: Rebind Package Error15_Christopher Tee19_CHRISTEE@UK.IBM.COM31_Fri, 17 Feb 2006 09:07:10 +0000421_US-ASCII Thomas
Have a look at APAR PK16702 to see if you have similar symptoms.
Chris Tee DB2 Systems Programmer Database Team SSO IGA Technical Services Internal Tel: 250072 External Tel: 023 9256 0072
Thomas Karlsson Sent by: DB2 Data Base Discussion List 16/02/2006 15:12 Please respond to DB2 Database Discussion list at IDUG [...]
5694 282 24_Re: Rebind Package Error13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 17 Feb 2006 09:59:33 -0000553_iso-8859-1 Wow, a HIPER. I'll add it to the list of HIPERs we haven't got... :o(
On a slightly different tack, I'm assuming the (CS); bit after the REBIND PACKAGE line is simply a cut/paste issue, and it should say ISOLATION(CS) - whatever, just looked odd to me.
Raymond Bell Database Administrator
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Christopher Tee Sent: 17 February 2006 09:07 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Rebind Package Error [...]
5977 25 58_DB2810: ADB clist error: Program ADB2SYS failed with Rc=2013_Francis ANDRE24_francis.andre@EASYNET.FR31_Fri, 17 Feb 2006 11:13:17 +0100736_iso-8859-1 Hi Listeners
When activating the DB2ADMIN (Database Admin Tool) menu from the IBM Product Panel, I got this error:
ADB clist error: Program ADB2SYS failed with Rc=20
Any idea on how to fix this problem is welcome
TIA
FA
--------------------------------------------------------------------------------- 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
6003 65 26_Reminders from list owners22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Fri, 17 Feb 2006 13:38:55 +0200498_iso-8859-9 Hello DB2-L Subscribers,
This posting is something we (the list owners) are sending out about every couple of months. The purpose is to highlight information about DB2-L and also remind subscribers about certain information. Some information will be repeated to benefit new subscribers. We hope you will find the information useful, and save it for future reference. If you have feedback or suggestions, please contact us (the list owners) at DB2-L-Request@www.idugdb2-l.org [...]
6069 84 36_Re: LOCK TABLE and COMMIT - DB2 z/OS9_Ken Paris20_kenparis17@GMAIL.COM31_Fri, 17 Feb 2006 06:50:06 -0600377_ISO-8859-1 Actually, the V7 documentation says:
If LOCK TABLE is a static SQL statement, the RELEASE option of bind determines when DB2 releases a lock. For RELEASE(COMMIT), DB2 releases the lock at the next commit point. For RELEASE(DEALLOCATE), DB2 releases the lock when the plan is deallocated (the application ends).
And this is a static SQL statement. [...]
6154 31 46_z/OS v7 - To B or not to B (bind's / rebind's)14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 17 Feb 2006 08:11:32 -0600374_US-ASCII (Sorry, couldn't resist the pun - for those who remember Hamlet - must be Friday :-)
Looking for a tool/solution to help us with maintenance and/or migration rebinds etc. We would like to be proactive especially as we move towards v8. We already have some bad hogs out there as it is and cannot afford to be the one's to bring the system to it's knees. [...]
6186 79 58_AW: [DB2-L] z/OS v7 - To B or not to B (bind's / rebind's)12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 17 Feb 2006 15:17:46 +0100740_iso-8859-1 Mark,
take a look at Bind ImpactExpert for DB2 z/OS from Software Engineering - more under http://www.seg.de/englisch/products/db2/bndx/bndx.php
May be this solution can help you.
With kind regards - mit freundlichen Gruessen, G e o r g H . P e t e r ------------------------------------------------------------------- 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!"« [...]
6266 85 36_Re: LOCK TABLE and COMMIT - DB2 z/OS9_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 17 Feb 2006 08:28:51 -0600321_Windows-1252 One question - Is this program bound as a package? If so, the release behavior is specified by the BIND PACKAGE not the BIND PLAN that invoked the package. IBM did not do us any favors when they fixed the problems with BIND PLAN and gave us packages but left the options on bind plan just ignored them. [...]
6352 13 36_Re: LOCK TABLE and COMMIT - DB2 z/OS33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 17 Feb 2006 09:11:51 -0600590_- Mike
But if I omit the release-option on the BIND PACKAGE, then the release behaviour ofthe plan takes effect.
--------------------------------------------------------------------------------- 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
6366 20 50_Re: z/OS v7 - To B or not to B (bind's / rebind's)33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 17 Feb 2006 09:20:44 -0600305_- Mark
I think, there are a lot of threads and replies in this list dealing with this topic. In our company, we are on DB2 NFM, and didn't do any rebinds and we are still alife. Can't say, if the CPU overhead is measurable or if it vanishes in the daily variation. Up to now, nobody screamed. [...]
6387 211 36_Re: LOCK TABLE and COMMIT - DB2 z/OS9_Ken Paris20_kenparis17@GMAIL.COM31_Fri, 17 Feb 2006 11:35:56 -0600621_ISO-8859-1 It's a package (I think that's the only way SQL Stored Procedures work, although I'm not sure about that). SYSIBM.SYSPACKAGES has 'D' in the RELEASE column for this package, so it definitely noticed the RELEASE(DEALLOCATE) bind parm.
Maybe there's an issue with running SQL Procedures in Workload Manager?
On 2/17/06, Mike Bell wrote: > > One question - Is this program bound as a package? If so, the release > behavior is specified by the BIND PACKAGE not the BIND PLAN that invoked > the > package. IBM did not do us any favors when they fixed the problems [...]
6599 66 50_Re: z/OS v7 - To B or not to B (bind's / rebind's)12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 17 Feb 2006 09:52:56 -0800332_us-ascii Mark:
The Software Engineering product is the same one as offered by Neon. There is an IBM solution, Path Checker, but apparently no one from IBM reads the list server. There is our solution, Path Check, which can either be bought or rented for your conversion. Please see page 5 of the IDUG Solutions Journal. [...]
6666 77 50_Re: z/OS v7 - To B or not to B (bind's / rebind's)14_Mark E Vickers26_MarkVickers@GROCERYBIZ.COM31_Fri, 17 Feb 2006 14:17:18 -0600499_ISO-8859-1 Walter, thank you and everyone else for their valuable input. FYI: I am in JSTM for v8 (just started thinking about it mode).
For the record, we don't have a batch window problem, but we run billing 4 times a day and 3 of those are in prime time and we are fresh out of CPU right now and not planning any hardware upgrades in the near future. We are up 24 x 7 with a 3 hour maintenance window once a month, so I don't want to be any more in the limelight than I need to be. I [...]
6744 259 39_load TABLE from pd into test - DB2 z/OS9_Ali, Omar25_Omar.Ali@CITYOFBOSTON.GOV31_Fri, 17 Feb 2006 15:23:03 -0500483_- Hi all,
Just trying to get information on loads;
In my production system the column (Vendor_id) don't exist,
On my test environment the column (vendor_id) exist on the table,
My developers asked me to take pd data and load into a test table for testing,
This is what is did,
I unload the pd data, then when trying to load into the test table db2 is telling me that the - column (Vendor_id) is omitted, [...]
7004 247 43_Re: load TABLE from pd into test - DB2 z/OS13_Richard Fazio21_rfazio@TRANSUNION.COM31_Fri, 17 Feb 2006 14:40:49 -0600388_ISO-8859-1 What I would recommend is to change the definition in the NON-Production environment of the "VENDOR" column to "NULL" or "DEFAULT" able.
Then, if you use your original load cards, all rows will have the VENDOR_ID as null or defaulted to a given value.
Or, you can fabricate a default value during your unload...this would allow your second scenario to work. [...]
7252 61 50_Re: z/OS v7 - To B or not to B (bind's / rebind's)12_Gerald Hodge26_ghodge@HLSTECHNOLOGIES.COM31_Fri, 17 Feb 2006 12:46:41 -0800381_us-ascii Mark:
Binds comparisons are good, but you have to have exactly the same CPU, Buffer Pool setup, as well as statistics. Comparisons of plan table entries may also be confusing, e.g. everything is exactly the same, but for the cost entries in the DSN_STATEMNT_TABLE. V8 estimated costs usually go down when moving from V7 to V8. There are other items as well... [...]
7314 109 28_Feedback on DB2 retail books17_Katherine A Wheat17_kwheat@US.IBM.COM31_Fri, 17 Feb 2006 13:47:00 -0800707_US-ASCII
Dear DB2-L members,
The DB2 for z/OS User Experience team is looking for volunteers to give us feedback on possible retail books for DB2. The feedback you provide can play an important role in determining the types of DB2 for z/OS retail books that are published.
If you are interested, start by completing the survey at http://www-950.ibm.com/survey/oid/wsb.dll/studies/DB2retailbooks.htm. We will be giving away complimentary copies of the following books to survey respondents at random: - DB2 for z/OS Version 8 DBA Certification Guide - DB2 SQL PL, Second Edition - The Official Introduction to DB2 for z/OS, Second Edition After you [...]
7424 470 43_Re: load TABLE from pd into test - DB2 z/OS24_Bobade, Laxmi (Exchange)16_lbobade@BEAR.COM31_Fri, 17 Feb 2006 17:09:18 -0500601_us-ascii
********************************************************************** Please be aware that, notwithstanding the fact that the person sending this communication has an address in Bear Stearns' e-mail system, this person is not an employee, agent or representative of Bear Stearns. Accordingly, this person has no power or authority to represent, make any recommendation, solicitation, offer or statements or disclose information on behalf of or in any way bind Bear Stearns or any of its affiliates. ********************************************************************** [...]
7895 21 32_Webcast coming up on zIIP Feb 2212_Roger Miller19_millerrl@US.IBM.COM31_Fri, 17 Feb 2006 19:47:58 -0600352_- There is a webcast scheduled for 2 p.m. EST on February 22. Here is the outline of the content:
- brief overview of IBM's vision of the IBM System z9 as a data hub - description of the new IBM System z9 Integrated Information Processor - Potential price/performance improvements with the zIIP - preview of DB2 for z/OS vNext capabilities [...]
7917 12 3_AWK12_Eva Hutchens19_eahutche@US.IBM.COM31_Fri, 17 Feb 2006 19:38:59 -0600640_- I am working on a DB2 automation program that is written in AWK. Does anyone know how to call an AWK program from within another AWK program? If so how does this work?
--------------------------------------------------------------------------------- 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
7930 26 13_DB2 Migration8_Pkr Blog17_pkrblog@YAHOO.COM31_Sun, 19 Feb 2006 02:45:39 -0600553_- Hi,
In my shop, we have database in diverse platforms like mainframe, Linux, Windows 2000. We are planning to consolidate all iDB in a single platform and build one big monster DB, this monster DB is going be a DB2 UDD V8, running on Linux server. As a first step we are planning to migrate mainframe DB2 (v7) to Linux DB2 UDB (V8). I want to know the following 1. Are there any tools available for migrating the database from mainframe to Linux box, there is not going to be any functionality change during the migration? 2. What are the [...]
7957 73 26_problem with temp database14_bhaskar kalita22_db2questions@YAHOO.COM31_Mon, 20 Feb 2006 04:09:50 -0800366_iso-8859-1 Hi
Recently, I cancelled a Stored Proc with NOBACKOUT option in one of our dev environments. It was inserting data into a temp table and was in an infinite loop. The cancellation put the temp table spaces in RW,REFP, LPL. LPL was gone once I stopped and restarted the TS in RW mode. After that, I saw other threads using the temp tablespaces. [...]
8031 313 30_Re: problem with temp database14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 20 Feb 2006 13:57:48 -0000514_US-ASCII If I were you I'd:
1. Raise this with IBM and 2. DROP/RECREATE the temp tablespaces
Phil Grainger CA Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of bhaskar kalita Sent: 20 February 2006 12:10 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] problem with temp database [...]
8345 16 38_Determine file space taken by database9_Dan Alion19_dalion@CARREKER.COM31_Mon, 20 Feb 2006 08:03:51 -0600308_- What is the best way to determine approximately how much file space (specifically on AIX) a database is occupying? We have numerous databases on our development system, and knowing the size taken by each would help us decide which databases to remove when we need to free up space.
Thanks, Dan [...]
8362 222 30_Re: problem with temp database15_Christopher Tee19_CHRISTEE@UK.IBM.COM31_Mon, 20 Feb 2006 14:40:19 +0000445_US-ASCII Bhaskar
Have a look at APAR PK15000, it looks like it will fix your problem (PTF UK11147/UK11148)
Chris Tee DB2 Systems Programmer Database Team SSO IGA Technical Services Internal Tel: 250072 External Tel: 023 9256 0072
bhaskar kalita Sent by: DB2 Data Base Discussion List 20/02/2006 12:09 Please respond to DB2 Database Discussion list at IDUG [...]
8585 110 42_Re: Determine file space taken by database4_Peri19_peri.ncst@GMAIL.COM31_Mon, 20 Feb 2006 21:48:45 +0530505_ISO-8859-1 Dan, If u are on < V8.2 you could possibly get the required information from the snapshot function tables over tablespaces
For example:
select tablespace_id,tablespace_name,sum(cast(total_pages*page_size as bigint)) as total_space,sum(cast(usable_pages*page_size as bigint)) as usable_space, sum(cast(used_pages*page_size as bigint)) as used_space,sum(cast(free_pages*page_size as bigint)) as free_space from table( snapshot_tbs_cfg(' ',-1) ) as tbs group by tablespace_name [...]
8696 27 20_Upgrades to z/OS 1.717_Maxie Zinsmeister18_mzinsme@US.IBM.COM31_Mon, 20 Feb 2006 14:43:30 -0600297_- We are planning to begin moving to version 1.7 of z/OS. Does anyone know of any gotcha's or an informational APAR that may describe things to look out for? We will be migrating system's that are running both V7 and V8 of DB2. Found the following APARs on IBMLINK that looked "interesting": [...]
8724 22 63_z/OS 1.4 DB2 v7 -- IBM-supplied procedure for binding a package13_Fleming, Mark21_MFLEMING@ALLSTATE.COM31_Mon, 20 Feb 2006 15:21:49 -0600386_us-ascii Is there an IBM supplied stored procedure that can be called to bind a package? I know there's the SYSPROC.DSNTBIND used by Development Center, but I haven't had any success in calling it directly. Maybe it's not meant to be called directly. I didn't find anything in the Redbook (... Through the Call and Beyond) and a cursory glance through SDSNSAMP did glean anything. [...]
8747 480 43_Re: load TABLE from pd into test - DB2 z/OS18_Maniar, Saquib TCS27_saquib.maniar@IMPDIRECT.COM31_Tue, 21 Feb 2006 11:44:54 +0100444_us-ascii After CANCEL THREAD NOBACKOUT processing, DB2 marks all objects associated with the thread as refresh pending (REFP) and puts the objects in a logical page list (LPL).
The NOBACKOUT request might fail for either of the following two reasons:
DB2 does not completely back out updates of the catalog or directory (message DSNI032I with reason 00C900CC) & The thread is part of a global transaction (message DSNV439I). [...]
9228 147 30_Re: problem with temp database18_Maniar, Saquib TCS27_saquib.maniar@IMPDIRECT.COM31_Tue, 21 Feb 2006 12:06:06 +0100445_us-ascii Hi,
After CANCEL THREAD NOBACKOUT processing, DB2 marks all objects associated with the thread as refresh pending (REFP) and puts the objects in a logical page list (LPL).
The NOBACKOUT request might fail for either of the following two reasons - DB2 does not completely back out updates of the catalog or directory (message DSNI032I with reason 00C900CC) & thread is part of a global transaction (message DSNV439I). [...]
9376 24 24_Re: Upgrades to z/OS 1.710_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 21 Feb 2006 14:56:23 +0100646_US-ASCII I've found (from PSP docu):
II14047 - Db2 utilities and DFSORT (V8) OA12848 (if z/OS 1.4 or above) OA12793 OA13023 PQ91099
HTH
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
9401 42 50_FW: z/OS v7 - To B or not to B (bind's / rebind's)13_Gary Bronziet26_gary.bronziet@COGITO.CO.UK31_Tue, 21 Feb 2006 08:44:05 -0600621_- Hi Mark,
Yes, there are other solutions out there. EZ-Impact Analyzer from Tact/Cogito is the most comprehensive tool on the market and completely addresses the 2 main issues DBAs and Application Developers are facing: a) The impact on Access Path when an application is moved from Test/QA to Production (or another DB2 release). b) The impact on Access Path for existing production applications when a change is made to the production environment. In brief, you can use it to check for changes in access paths in any subsystems, using any combination of Catalog, DBRMLIBs, Plan Tables, EXPLAINs of SQL and [...]
9444 38 27_DB2 Express - where to now?12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 21 Feb 2006 10:18:28 -0600355_us-ascii Hopefully everybody here knows that IBM has a DB2 "free for the download" now. Well, since I like to learn (and we don't have DB2 where I work), I downloaded the Linux 2.6/64 bit version and actually got it to install. I'm now trying to figure out how to work with it. Any pointers to a web site that will help would be greatly appreciated. [...]
9483 41 67_Re: z/OS 1.4 DB2 v7 -- IBM-supplied procedure for binding a package0_28_jim_addison@STANDARDLIFE.COM31_Tue, 21 Feb 2006 16:19:18 +0000618_US-ASCII You can do this by attaching to DSNESM71 in a user written rexx stored procedure (which is what I think DSNTBIND uses). If this will be of any use I can provide more info.
Jim.
Jim Addison ISOS DBA&Middleware Data Centre 8 Glenogle Road
t: 0131 245 3206 e: Jim_Addison@Standardlife.com
This e-mail is confidential, if you are not the intended recipient, do not retain/disclose it and please return it to us. We virus scan and monitor all e-mails but are not responsible for any damage caused by a virus/alteration of our e-mail by a third party after sending. [...]
9525 110 26_recovery from missing vsam14_Jones, Trace R33_trace.jones@CENTERPOINTENERGY.COM31_Tue, 21 Feb 2006 10:49:55 -0600698_us-ascii Hi all,
We have partitioned table in which our part 51's vsam is missing. We have image copes. Can we just recreate the vsam and recover using the image copies?
TRJ
--------------------------------------------------------------------------------- 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
9636 148 30_Re: recovery from missing vsam13_Michael Ebert18_mebert@AMADEUS.COM31_Tue, 21 Feb 2006 17:54:48 +0100460_ISO-8859-1 Unless you have user-managed datasets (created USING VCAT instead of USING STOGROUP), which you normally only do for Catalog/Direcory/Workfiles/Tempfiles, then you don't even need to create the VSAM. Just say RECOVER TABLESPACE dbname.tsname DSNUM partnumber, and DB2 will create the file with the current PRIQTY/SECQTY for you. In fact, if you have DB2 managed files, then DB2 will always delete/define the VSAM unless you also specify REUSE. [...]
9785 228 30_Re: recovery from missing vsam16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 21 Feb 2006 11:55:45 -0500638_us-ascii Load Replace or Recover will allocate the VSAM dataset again if you are STOGROUP defined.
Kind regards Steen Rasmussen CA Senior Consultant
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jones, Trace R Sent: Tuesday, February 21, 2006 10:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] recovery from missing vsam
Hi all,
We have partitioned table in which our part 51's vsam is missing. We have image copes. Can we just recreate the vsam and recover using the image copies? [...]
10014 63 30_Re: recovery from missing vsam14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Tue, 21 Feb 2006 09:00:15 -0800361_iso-8859-1 Is the patitioned table space stogroup or vcat defined.
You would only need to reallocate VSAM if vcat defined.
Also recover to IC will not work by its self.
The Part can be recovered to current from IC and logs. If you are only going to recover to IC then Indexes need to be rebuilt Check utility run to find any RI issues [...]
10078 311 53_DB2 z/OS Version 7 - Number of DML statments per day.11_George Grix23_George.Grix@HAWORTH.COM31_Tue, 21 Feb 2006 11:58:13 -0500527_us-ascii
I was wondering if anyone would care to offer up the number of DML statements issued in their production subsystem for a normal workday.
We consider ourselves to be a small to medium sized shop but it is difficult to gauge. We are going through turning efforts and would like a little feedback on DML volume in other shops. While reviewing the counts we are surprised to see over 300 million statements a day. But that is probably small compared to some of the large shops. [...]
10390 120 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Tue, 21 Feb 2006 09:42:52 -0800593_iso-8859-1 The following is for the period of 02/05 7am to 02/21 noon
for insert update statements I would assume a 5 day workweek for your math. Weekends are mostly reporting and utilities
Its possible that some of the values may of wrapped or are otherwise miscollected.
SELECT : 1298.45M UPDATE : 51025057 DESCRIBE : 2948599 PREPARE : 22583980 CLOSE CURSOR : 1032.24M CALL STATEMENT : 4102506 TYPE2 CONNECT : 78281 SET CURRENT SQLID : 150 SET CONNECTION : 0 SET CURRENT RULES : 4 ASSOCIATE LOCATORS : 4001442 HOLD LOCATOR : 0 LOCK : 7314 HOST VARIABLE REOPT : N/A [...]
10511 51 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.0_28_jim_addison@STANDARDLIFE.COM31_Tue, 21 Feb 2006 17:45:07 +0000920_US-ASCII Our counts yesterday for prod subsystems only are:
---------+---------+---------+---------+---------+---------+---- SELECTS INSERTS UPDATES DELETES DESCRIBES ---------+---------+---------+---------+---------+---------+---- 299186993 8631400 14387710 15929626 563682
--+---------+---------+---------+---------+------+--------
PREPARES OPENS CLOSES FETCHES --+---------+---------+---------+---------+------ 1332865 38599790 37739746 254031815
HTH.
Jim.
Jim Addison ISOS DBA&Middleware Data Centre 8 Glenogle Road
t: 0131 245 3206 e: Jim_Addison@Standardlife.com
This e-mail is confidential, if you are not the intended recipient, do not retain/disclose it and please return it to us. We virus scan and monitor all e-mails but are not responsible for any damage caused by a virus/alteration of our e-mail by a third party after sending. [...]
10563 300 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Tue, 21 Feb 2006 12:52:55 -0500365_us-ascii Here are our low daily, high daily, and average daily values for each for the last month.
We only have the tools to generate on two of three members in our data sharing group, so
actually numbers are at least 30% higher:
SQL DML LOW VALUE HIGH VALUE AVERAGE VALUE
SELECT 155,330,992 333,492,128 248,399,988 [...]
10864 24 13_REORP Probelm4_Ravi23_Ravi.sankar@VERIZON.COM31_Tue, 21 Feb 2006 11:46:49 -0600574_- We are in DB2 V7 in Z/OS. Last friday I tried to alter the limitkeys of a partition table. After altering it placed both that Partiontioned Index and Tablespace in REORP status. At that time I was abled getrid that flags by START DATABASE ACCESS FORCE command. (first in index and then in Tablespace). But today in the same enviornment, when i tried to alter the LimitKey it placed only the tablespace in REORP. Not the Index. The original value of LK is '0000000192' ALTERED TO 'R000009999'. Becasue this did not place the Index In REORP. the command START DATABASE [...]
10889 61 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 21 Feb 2006 12:54:25 -0500403_US-ASCII from 2/4 to 2/21 production only legacy SELECT : 112714239 INSERT : 40699765
UPDATE : 2790283 DELETE : 1484855
peoplesoft fs SELECT : 55059900 INSERT : 11467152 UPDATE : 7100033 DELETE : 988245
peoplesoft hr SELECT : 56696017 INSERT : 23499023 UPDATE : 8834848 DELETE : 938868
---------------------------------------------------------------------------------
10951 252 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.14_David R Slocum22_drslocum@CMSENERGY.COM31_Tue, 21 Feb 2006 13:00:51 -0500345_US-ASCII I wouldn't consider our shop to be very big, either. (From the looks of things, we're probably smaller than you are.) We don't have DB2 Performance Expert, and I don't have numbers for DESCRIBE, but here are the numbers I do have for a typical day:
SELECT - 28,569,770 INSERT - 1,958,356 UPDATE - 1,208,476 DELETE - 122,939 [...]
11204 58 31_Re: DB2 Express - where to now?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 21 Feb 2006 13:02:57 -0500475_- Hello John
Isn't there a First Steps dialog that automatically starts up after the install? Look also for a web section called Quick Beginnings. There used to be in the other versions.
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of McKown, John Sent: Tuesday, February 21, 2006 11:18 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Express - where to now? [...]
11263 68 17_Re: REORP Probelm14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Tue, 21 Feb 2006 10:23:28 -0800579_iso-8859-1 Alter LIMITKEYS is not supported in DB2/zOS v7 Hope you did this on a test system and have a backup you can restore.
You might want to consider opening a PMR for DB2 allowing you to get as far as you did.
Ravi wrote: We are in DB2 V7 in Z/OS. Last friday I tried to alter the limitkeys of a partition table. After altering it placed both that Partiontioned Index and Tablespace in REORP status. At that time I was abled getrid that flags by START DATABASE ACCESS FORCE command. (first in index and then in Tablespace). But [...]
11332 57 17_Re: REORP Probelm19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Tue, 21 Feb 2006 10:33:24 -0800546_us-ascii Under V7, I believe the REORP stays until you do a REORG (shrlevel reference) of the two partitions affected by the limit key change to redistribute the data.
I've done this successfully several times and haven't seen that there's anyway to "force" around the status without doing the reorg.
HTH, Tim
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ravi Sent: Tuesday, February 21, 2006 9:47 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] REORP Probelm [...]
11390 474 30_Re: recovery from missing vsam14_Jones, Trace R33_trace.jones@CENTERPOINTENERGY.COM31_Tue, 21 Feb 2006 12:51:34 -0600564_us-ascii When I issue the recover tablespace (and it stogroup defined), I get the following everytime. It just won't recreate the vsam.
RESOURCE UNAVAILABLE
REASON 00D70025
TYPE 00000220
NAME CMRPRD.DSNDBC.DCMR01.TCMR10.I0001.A051
TRJ
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Ebert Sent: Tuesday, February 21, 2006 10:55 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] recovery from missing vsam [...]
11865 250 17_Re: REORP Probelm14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 21 Feb 2006 19:29:17 -0000466_US-ASCII Yes it is!!! In fact, I think it arrived with v6 (it's actually an ALTER INDEX function.....)
Anyway, Altering the limitkey DOES put the affected partition (and possibly adjacent partition) in REORP - this is a restrictive state to MAKE you reorg the partitions to ensure that any rows affected by the ALTER are relocated to their new home. I guess if you are 110% sure that NO rows are affected, you COULD do a -START ACCESS(FORCE), but....... [...]
12116 112 31_Re: DB2 Express - where to now?12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 21 Feb 2006 11:31:37 -0800435_iso-8859-1 It kind of depends how you install db2, what shape you're in. I highly recommend using the db2setup script usually found in the base directory of the install media. That will automagically set up an instance and database for you, and launch the First Steps dialog as well. But you're probably a manual kind-of-guy so look here for the IBM V8 library: http://www-306.ibm.com/software/data/db2/udb/support/manualsv8.html [...]
12229 183 30_Re: recovery from missing vsam9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 21 Feb 2006 13:38:31 -0600643_Windows-1252 It is really stupid to have to create a dataset just so DB2 can delete it, isn't it. I seem to remember hitting this problem myself but it has been a long time.
//IDCAMS EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSIN DD * DEFINE CLUSTER- (NAME(CMRPRD.DSNDBC.DCMR01.TCMR10.I0001.A051) - LINEAR - REUSE - VOLUMES(*) - TRACKS(45 45) - SHAREOPTIONS(3 3) ) - DATA - (NAME(CMRPRD.DSNDBD.DCMR01.TCMR10.I0001.A051)) will get you past that problem. It doesn't matter what the dataset looks like since DB2 RECOVER is going to rebuild it to the correct priqty and secqty anyway. The format to define a DB2 [...]
12413 366 17_Re: REORP Probelm19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Tue, 21 Feb 2006 14:37:37 -0500588_iso-8859-1 -START ACCESS (FORCE) should NOT work. From the manual:
APPENDIX1.3.10 REORG-pending status
The REORG-pending restrictive status indicates that a table space partition is broken and must be reorganized.
Refer to Table 140 for information about resetting the REORG-pending status.
Table 140. Resetting REORG-pending status Status Abbreviation Object Affected Corrective Action Notes REORG- pending [...]
12780 202 30_Re: recovery from missing vsam14_Jones, Trace R33_trace.jones@CENTERPOINTENERGY.COM31_Tue, 21 Feb 2006 13:39:17 -0600505_us-ascii Thanks for all the help, however I found out my my packs were out of space.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Tuesday, February 21, 2006 1:39 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] recovery from missing vsam
It is really stupid to have to create a dataset just so DB2 can delete it, isn't it. I seem to remember hitting this problem myself but it has been a long time. [...]
12983 279 17_Re: REORP Probelm10_Kim Larson18_Kim_Larson@ADP.COM31_Tue, 21 Feb 2006 14:44:09 -0500526_- I've been doing alters of partition keys since version 6, but I've never been able to do a START...ACCESS(FORCE) against a tablespace and/or index in REORP.
Kim Larson ID IT Database Administration Work: 909/592-6411 (x3142) Nextel: 909/917-9332 (Direct Connect 486) kim_larson@adp.com
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Tuesday, February 21, 2006 11:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] REORP Probelm [...]
13263 164 17_Re: REORP Probelm4_Ravi23_Ravi.sankar@VERIZON.COM31_Tue, 21 Feb 2006 13:47:47 -0600738_- On Tue, 21 Feb 2006 14:44:09 -0500, Kim Larson wrote:
>I've been doing alters of partition keys since version 6, but I've never >been able to do a START...ACCESS(FORCE) against a tablespace and/or index in >REORP. > > >Kim Larson >ID IT Database Administration >Work: 909/592-6411 (x3142) >Nextel: 909/917-9332 (Direct Connect 486) >kim_larson@adp.com > >-----Original Message----- >From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] >Sent: Tuesday, February 21, 2006 11:29 AM >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] REORP Probelm > > >Yes it is!!! In fact, I think it arrived with v6 (it's actually an ALTER >INDEX function.....) > >Anyway, Altering the limitkey [...]
13428 97 31_Re: DB2 Express - where to now?9_Eric Kwai14_ekwai@DTCC.COM31_Tue, 21 Feb 2006 14:58:12 -0500779_US-ASCII John:
Try this website. http://www.ibiblio.org/pub/Linux/docs/howto/other-formats/pdf/DB2-HOWTO.pdf
I personally like to use db2_install instead of db2setup.
Here is another link for using db2setup:
http://www.devx.com/ibm/Article/21635 ------------------------------------------------------------------------------------------------------
Thank You. Eric Kwai Data Management Depository Trust & Clearing Corporation 55 Water Street New York, New York 10041
Office: 212-855-3991 Fax: 212-855-2688 Email: ekwai@dtcc.com
"McKown, John" To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List [DB2-L] DB2 Express - where to now? [...]
13526 211 17_Re: REORP Probelm14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 21 Feb 2006 20:06:59 -0000576_US-ASCII APAR PQ57222 and PQ69710 add resetting REORP to the REPAIR utility (and, I guess, the -START command). For more details, take a look at http://www-1.ibm.com/support/docview.wss?uid=swg21212035
Phil Grainger CA Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ravi Sent: 21 February 2006 19:48 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] REORP Probelm [...]
13738 206 30_Re: recovery from missing vsam12_Levine, Mike29_Mike.Levine@DMS.MYFLORIDA.COM31_Tue, 21 Feb 2006 14:57:30 -0500517_us-ascii Looks like the STOGROUP or SMS storage group does not have enough space to create the dataset (or to get the primary allocation in four extents). I don't believe the dataset needs to exits prior to a recovery if it is not user defined.
Regards, Mike Levine
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mike Bell Sent: Tuesday, February 21, 2006 2:39 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] recovery from missing vsam [...]
13945 458 57_Re: DB2 z/OS Version 7 - Number of DML statments per day.11_George Grix23_George.Grix@HAWORTH.COM31_Tue, 21 Feb 2006 15:09:05 -0500707_us-ascii Thanks to all who provided counts.
George
George Grix Sent by: DB2 Data Base Discussion List
02/21/2006 11:58 AM
Please respond to DB2 Database Discussion list at IDUG
To
DB2-L@WWW.IDUGDB2-L.ORG
cc
Subject
[DB2-L] DB2 z/OS Version 7 - Number of DML statments per day.
I was wondering if anyone would care to offer up the number of DML statements issued in their production subsystem for a normal workday. [...]
14404 163 31_Re: DB2 Express - where to now?12_McKown, John26_john.mckown@UICIINSCTR.COM31_Tue, 21 Feb 2006 14:20:51 -0600221_us-ascii Thanks. I've poked around on the IBM sites and found a bunch of PDF formatted manuals. I have downloaded about 54 Mb worth so far! Now, as to reading all of that . Lucky for me that I'm on vacation!
14568 40 15_HADR and CLOB's0_28_BILL.GALLAGHER@PHOENIXWM.COM31_Tue, 21 Feb 2006 15:57:41 -0500553_us-ascii Hi,
We're considering utilizing HADR as our high-availability solution for a DB2 v8.2 fp10 database on Solaris. The database in question has a number of CLOB columns. In reading various sources of information about HADR (DB2 manuals, notes from IBM presentations, etc.) I'm getting conflicting information about whether or not CLOB's are supported and replicated in an HADR solution. I've also seen a question that came through the DB2-L archives on this topic with a fuzzy answer of "gee, maybe, I think so, but I'm not positive". [...]
14609 34 31_Re: DB2 Express - where to now?13_K.A.Rodriguez26_grnscrn-db2jan05@YAHOO.COM31_Tue, 21 Feb 2006 14:51:01 -0600445_- On Tue, 21 Feb 2006 10:18:28 -0600, McKown, John wrote:
>Hopefully everybody here knows that IBM has a DB2 "free for the >download" now. Well, since I like to learn (and we don't have DB2 where >I work), I downloaded the Linux 2.6/64 bit version and actually got it >to install. I'm now trying to figure out how to work with it. Any >pointers to a web site that will help would be greatly appreciated. [...]
14644 74 88_The Baltimore/Washington DB2 Users' Group---HEADS UP!!! BONNIE BAKER IS COMING TO TOWN!!14_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Tue, 21 Feb 2006 15:30:35 -0600653_ISO-8859-1 HEADS UP!!! BONNIE BAKER IS COMING TO TOWN!! The Baltimore/Washington DB2 Users' Group Special DB2 Course Offering - Wednesday, March 8, 2006 presenting...
Bonnie Baker International DB2 Consultant
• DBA Things a Programmer Should Know There are times when DBA issues and Developer issues overlap. What does the DBA know that a Developer should know? And how can this knowledge be used to make designing and writing programs easier? What DDL parameters impact program design and data integrity? And what DB2 roadblocks exist that can make the most perfect program perform poorly? These questions and more will be answered. [...]
14719 47 19_Re: HADR and CLOB's11_Grant Allen17_gxallen@GMAIL.COM31_Wed, 22 Feb 2006 13:28:01 +1100632_ISO-8859-1 On 2/22/06, BILL.GALLAGHER@phoenixwm.com wrote: > Hi, > > We're considering utilizing HADR as our high-availability solution for a > DB2 v8.2 fp10 database on Solaris. The database in question has a number > of CLOB columns. In reading various sources of information about HADR (DB2 > manuals, notes from IBM presentations, etc.) I'm getting conflicting > information about whether or not CLOB's are supported and replicated in an > HADR solution. I've also seen a question that came through the DB2-L > archives on this topic with a fuzzy answer of "gee, maybe, I think so, but > I'm [...]