1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l March 2001, week 1
2 15 52_William F Renfroe/GA/CheckFree is out of the office.15_William Renfroe22_WRenfroe@CHECKFREE.COM30_Thu, 1 Mar 2001 01:04:09 -0500389_us-ascii I will be out of the office starting 02/28/2001 and will not return until 03/05/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18 117 30_Re: Latin and the modern world14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 1 Mar 2001 17:28:08 +1100536_iso-8859-1 Perhaps it is a 'fun' topic which lightens the weary brow. Whereas someone who responds to a question but fails to get all his/her facts absolutely perfect get jumped upon. Not that I ever get any of my facts wrong.
Now what led us onto Latin quotations. :-)
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Jeff A L'Italien [mailto:Jeff.A.L'Italien@AEXP.COM] Sent: Thursday, 1 March 2001 16:19 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Latin and the modern world [...]
136 168 10_Re: Unload12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Thu, 1 Mar 2001 17:56:51 +1100547_iso-8859-1 Bala, looking at what goes into SYSREC I see * C831Z0DR00LP209157082 L......CASTILLO-GONZALEZ OFELIA.. * DL14F0T300LP211294376 L......DAVID L RUNNELLS TRUST..
I also note that the last 4 fields are all VARCHAR..
If you browse the DataSet and turn "HEX ON" you'll probably see the "......" come out as X'00' X'00 X'19' for the first record and X'00' X'00 X'17' (or there about) for the second. These are the field lengths for your VARCHAR fields. The X'00' length indicates no data hance no spaces (in a BMC Unload+). [...]
305 24 16_DB2/IMS and ODBA0_29_joop.ammerlaan@NL.ABNAMRO.COM30_Thu, 1 Mar 2001 07:03:19 +0100538_us-ascii Hello,
Is there someone out here who is able to run the ODBA part of the DB2 installation verfication procedures (DSNTEJ61/DSNTEJ62) with success. I'd like to learn about the compile/runtime environment of people who are able to run this part of the IVP with success. At ABN AMRO we experience returncodes/reasoncodes (x'108'/x'540') in the IVP indicating that no active IMS DB could be located. This is remarkable because a simple assembler program issuing the ODBA CIMS INIT call against the same IMSid works fine. [...]
330 22 27_DB2 for os/390 installation14_busayo adebayo15_bayo9@YAHOO.COM30_Thu, 1 Mar 2001 00:20:33 -0800501_us-ascii Hi All, Does anyone knows where I get an online guide for installing DB2 on os/390? Thanks
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
353 64 31_Re: DB2 for os/390 installation9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK30_Thu, 1 Mar 2001 08:42:16 +0000573_us-ascii Look at http://www-4.ibm.com/software/data/db2/os390/v5books.html for V5 Installation Guide and Program Directory (v6books.html for V6...) Kind Regards, Andy Hunt - Scottish And Southern Energy
busayo adebayo on 01/03/2001 08:20:33
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: DB2 for os/390 installation
Hi All, Does anyone knows where I get an online guide for installing DB2 on os/390? Thanks [...]
418 72 22_Re: DB2-Certification!15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Thu, 1 Mar 2001 09:45:02 +0100499_iso-8859-1 Hello,
All I can offer is this link.
http://www.ibm.com/certify
HTH,
Jaap Slot, sr. DB2 DBA, Rabobank ICT
Phone 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167 e-Mail
Reserve your AGENDA for next DB2 Users Group Conference IDUG Florence - 8/11 October 2001 -
No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...]
491 26 10_DB2 Select0_18_dsi.listsrv@DB.COM30_Thu, 1 Mar 2001 14:52:56 +0530422_us-ascii Hi
We are working on UDB 6.1 on NT. One of our table has values in 'Upper Case' and 'Lower case'. How do I retrieve rows( irrespective of upper case / lower case) using the select statement. Eg:
Select * from employee where name like '%Lo%'. This should retrieve rows irrespective of the case. I would like to know is there any function to ignore case(other than Functions Translate/UCASE.) ?? [...]
518 20 25_Moving to lare tablespace25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Thu, 1 Mar 2001 17:35:09 +0800312_us-ascii Hi,
I need to move one of the tablespaces to a large tablespace. I know unload and reload is one method. But can I just DSN1COPY back the tablespace after defining. Is there any header page in the tablespace that is updated when defining large tablespace which may be corrupted by dsn1copy. [...]
539 40 41_Moving to large tablespace - may be not!!25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG30_Thu, 1 Mar 2001 18:08:58 +0800443_us-ascii Hi,
DSN1COPY may not work. If I am not wrong the RID size is bigger to cater for large , so there will be error. Please confirm.
Thanks
---------------------- Forwarded by SRIRENGAN VENKATESH KUMAR/IRAS on 01/03/2001 06:05 PM ---------------------------
SRIRENGAN VENKATESH KUMAR(Tel: 351 2249) 01/03/2001 05:35 PM
To: db2-l@ryci.com cc: bcc: Subject: Moving to lare tablespace [...]
580 56 20_Re: Where's url.dll?0_19_mike.holmans@BT.COM30_Thu, 1 Mar 2001 10:16:29 -0000343_- Thanks very much, Lynette. That worked a treat.
(Thanks also to everyone else who replied by email - this just happened to be the one I tried first.)
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT [...]
637 16 17_table last access17_Silvia Bartolucci25_s.bartolucci@FONDIARIA.IT30_Thu, 1 Mar 2001 04:01:52 -0600271_- Hi, we have DB2 OS390 V5 , and a large number of tables . I am sure that a great number of this tables is no longer utilized. I've already found those tables that have no package depending on , but there is a way to find when the tables have been last accessed ?? [...]
654 73 21_AW: table last access12_Peter, Georg15_G.Peter@DZBW.DE30_Thu, 1 Mar 2001 12:06:45 +0100480_iso-8859-1 Silvia,
We have solved the problem "when was the last update/insert access to table xxxx ?" on the application side.
Every (really every !) app table has two columns named tablename_tabletst and tablename_opid. Both are defined as NOT NULL. So the application has to deliver values to the columns. The column "tablename_tabletst" stores the last update/insert and in the column "tablename_opid" we store the user who has done the last update/insert. [...]
728 43 31_Re: Traces and the OPx buffers.10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 1 Mar 2001 12:11:09 +0100424_us-ascii Hi Cliff, I get this message using Mainview for DB2.
DB2 issues the following message:
DSNW133I DSNWVSRV TRACE DATA LOST, OPx NOT ACCESSIBLE, RC=8
followed by:
DSNW123I DSNWVSRV TRACE RECORDING HAS BEEN RESUMED ON OPx
When viewing the trace displays (STRAC, DTRAC) some of the detail events are missing, and the following message may be displayed near the top of the screen: [...]
772 62 30_Re: Latin and the modern world18_Michael J. O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV30_Thu, 1 Mar 2001 06:02:25 -0500531_US-ASCII Si hoc legere scis nimium eruditionis habes.
______________________________ Reply Separator _________________________________ Subject: Latin and the modern world Author: "DB2 Data Base Discussion List" at smtplink Date: 2/28/01 5:51 PM
Dave,
Didn't know you had a classical education. Or was it just that latin happened to be the language of choice in classrooms all those centuries ago? If so, good to meet another dinosaur (please, Terry; no more age jokes...) [...]
835 26 21_Re: table last access10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 1 Mar 2001 12:19:10 +0100370_us-ascii Without auditing features or explicit AUDIT in table definition I think : no
You may use DSN1LOGP to search (better 'ravanare') xxIDs of the object you need to know if they are accessed for update/insert/deletes. It's better if u have any 3rd party log tools .
Take a look at Admin Manual vol 1, chapter 'Other sources of Audit information'. [...]
862 19 37_Re: Assembler program & SQL - Thanks!10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 1 Mar 2001 12:38:00 +0100457_us-ascii Thanks to all who replied to my request. I'm testing the samples.
THX again & regards
Max Scarpa
PS The request is still valid, so if you have other samples plz contact me offline. TIA.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
882 47 31_Re: Traces and the OPx buffers.22_SERDAR SABRI OZKUBULAY22_sozkubul@AKBANK.COM.TR30_Thu, 1 Mar 2001 13:41:06 +0200647_us-ascii Hi Cliff, We use TMONDB2 and I solved a similar problem by increasing the TMONDB2's detail READA buffer and its size.
If your monitor is same: MONITOR CONTROLS\\DB2 MONITORING OPTIONS Edit active DB2 connection and increase the number of Detail READA Buffers and its size.
Regards.
Serdar OZKUBULAY, AKNET
On Wednesday, February 28, 2001 11:42 PM, Cliff Boley [SMTP:Maurice.C.BOLEY@ODOT.STATE.OR.US] wrote: > I know that you can route traces to OPx buffers but can't find anything on > where they're at, how they're defined, who manages them, 8 buffers per LPAR > or 8 buffers > for each DB2 subsystem. > [...]
930 62 27_TableSpace in QUIESCE state13_Arora, Ashish26_ashish.arora@HPSGLOBAL.COM30_Thu, 1 Mar 2001 17:21:07 +0500442_- Hi all, My database is DB2 7.1 on NT. One of my tablespace has gone in "Quisced Share" mode, on its own (may be due to the restoration from the backup, which I did one day before). Now I want to make the status of that tablespace back to Normal. I'm not able to find any option to use/open Quisce Window on tablespaces window, in the Control Center. Pls tell me how shall I bring my tablespace back to normal from "Quisce Share" mode. [...]
993 58 31_Re: Traces and the OPx buffers.50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Thu, 1 Mar 2001 07:30:46 -0500353_iso-8859-1 I had this problem after our machine was moved to another site on a different sized box.
1) CHECK DISPATCHING PRIORITIES :: Using WLM LFS HIGHEST :: DB2TMDLP (this is TMON but reguardless of which monitor you are using it still has to log) MONITOR SECOND :: DB2TMDBP (the actual started task of the monitor) DB2 THIRD :: DBP2MSTR [...]
1052 86 31_Re: TableSpace in QUIESCE state15_Graham Whitmore19_graham@ABACUS.CO.UK30_Thu, 1 Mar 2001 12:46:30 -0000469_iso-8859-1 Ashish,
You can use the RESET option of the QUIESCE TABLESPACES FOR TABLE command or, alternatively, you can use the Control Centre (right-click the Table, select Quiesce and press the Quiesce Reset radio button).
Graham Whitmore -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Arora, Ashish Sent: Thursday, March 01, 2001 12:21 PM To: DB2-L@RYCI.COM Subject: TableSpace in QUIESCE state [...]
1139 32 31_Re: TableSpace in QUIESCE state13_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 1 Mar 2001 08:11:06 -0500566_us-ascii You want to do a quiesce reset for the table in that tablespace. So, from the Control Center, right click on the table that is in that tablespace...
> -----Original Message----- > From: Arora, Ashish [SMTP:ashish.arora@HPSGLOBAL.COM] > Sent: Thursday, March 01, 2001 7:21 AM > To: DB2-L@RYCI.COM > Subject: TableSpace in QUIESCE state > > Hi all, > My database is DB2 7.1 on NT. One of my tablespace has gone in > "Quisced Share" mode, on its own (may be due to the restoration from the > backup, which I did one day before). Now I want to make [...]
1172 118 31_Re: TableSpace in QUIESCE state12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Thu, 1 Mar 2001 08:21:28 -0500410_iso-8859-1 It's also been my experience that you have to issue the RESET commnand from the userid that performed the action that placed the tablespace in a quiesced mode ... has anyone else seen this?
Randy Wilson
-----Original Message----- From: Graham Whitmore [mailto:graham@ABACUS.CO.UK] Sent: Thursday, March 01, 2001 7:47 AM To: DB2-L@RYCI.COM Subject: Re: TableSpace in QUIESCE state [...]
1291 76 31_Re: TableSpace in QUIESCE state13_Lynne Flatley17_LFlatley@NEFN.COM30_Thu, 1 Mar 2001 08:53:17 -0500518_us-ascii I ran into that horrible situation a couple of months ago...
Here's what I learned...
To summarize, when a load fails and the tablespace is in a quiesced exclusive state (and some pending flag is set), the ID that submitted the load is the ID that MUST be used to do the quiesce reset command. This will take it out of the quiesce state. Then, depending on the pending flag further action may need to be taken. If the tablespace is in a backup pending state, for example, do a backup, etc. [...]
1368 32 22_Re: DB2-Certification!14_subrata mondal25_subratamondal@HOTMAIL.COM30_Thu, 1 Mar 2001 14:15:59 -0000
1401 96 31_Re: TableSpace in QUIESCE state15_Graham Whitmore19_graham@ABACUS.CO.UK30_Thu, 1 Mar 2001 14:44:20 -0000490_iso-8859-1 When a Connection is lost, the Quiesce becomes unowned (a 'phantom quiesce') - but still applies. The quiesce can be 'adopted' by a new id by connecting to the DB and re-quesceing the Tablespace, specifying the same quiesce state.
Graham Whitmore
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Lynne Flatley Sent: Thursday, March 01, 2001 1:53 PM To: DB2-L@RYCI.COM Subject: Re: TableSpace in QUIESCE state [...]
1498 42 21_Re: table last access10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Thu, 1 Mar 2001 08:55:34 -0600589_- Just a suggestion.....
When I've identified some tables which I see have no PLANDEPs or PACKDEPS, and I'm pretty sure that they're not being used (and the appropriate applications people say that they're absolutely certain that the tables are not used, but take the fifth when asked if it's ok to drop them!), then I STOP the tablespaces for a while to see what happens. You may soon have a phone call from some irate user complaining about 'a db2 error' they get issuing dynamic SQL against their favourite table! However, if after some reasonable period I find that nobody [...]
1541 35 19_SQL Doesn't Work???20_Westcott-Dryer, Lisa32_Lisa_Westcott-Dryer@FOREMOST.COM30_Thu, 1 Mar 2001 10:28:23 -0500702_iso-8859-1 All, Can you tell me why this doesn't work? DBKEY is fieldproc'd length of 40, POLNO is char(16). It looks like the JOIN won't perform a substring in the ON clause... I can't find it in the documentation... hmmm...
SELECT D.DBKEY, E.FICS FROM DEVL.TW4B0 E LEFT OUTER JOIN DEVL.TA200 D ON SUBSTR(D.DBKEY,1,16) = E.POLNO ---------+---------+---------+---------+---------+---------+---------+------ ---+ DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "1". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = 0 0 0 -1 315 0 SQL DIAGNOSTIC INFORMATION DSNT416I [...]
1577 28 21_Re: table last access10_Max Scarpa16_mscarpa@CESVE.IT30_Thu, 1 Mar 2001 16:31:45 +0100365_us-ascii Just other 0,2 cent. Pay attention to the tables I call 'long-period tables', i.e. tables referenced only for a brief (or very
brief) period during 1 or more years BUT very important, for instance, for yearly budget. Usually these are very small or
very big tables. In this case stopping tables or migrating them may be not significant. [...]
1606 26 25_Re: Peoplesoft Upgrade V815_Lynette Roberts21_llroberts@KSCABLE.COM30_Thu, 1 Mar 2001 09:25:20 -0600600_- Deb, There is an excellent service coordinated by Computer Associates that specifically addresses companies running PeopleSoft on DB2/OS390. You can find out more about it at the following link:
http://ca.com/products/ca_pdf/
They also have a separate listserv. Information on that service is contained at the following link:
http://www.cai.com/products/db2/email_forum.htm --------------------------------------------------------------------------
With all the challenges of a PeopleSoft V8 upgrade, there has been much discussion going on recently on that topic. [...]
1633 17 23_Re: SQL Doesn't Work???15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Thu, 1 Mar 2001 09:30:53 -0600434_- Lisa
Did you try SUBSTR(D.DBKEY, 1, 16) = E.POLNO.
In our installation we have to code a blank behind a comma, because we have decimal point is comma.
Just a quick guess
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1651 28 30_Re: Latin and the modern world15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Thu, 1 Mar 2001 09:43:32 -0600433_iso-8859-1 It was a little private school located in Connecticut in 1963.
Chris Blaicher
> -----Original Message----- > From: Mohammad Khan [mailto:mkkhan88@HOTMAIL.COM] > Sent: Wednesday, February 28, 2001 8:53 PM > To: DB2-L@RYCI.COM > Subject: Re: Latin and the modern world > > > And may I ask when was that ? Excuse my ignorance but I'm > from India and > I'm yet to catch up on local history. > Mohammad > > [...]
1680 39 36_DSN1COPY Full Imagecopy to Flat File11_Carl Nelson22_Carl.Nelson@ANTHEM.COM30_Thu, 1 Mar 2001 10:37:54 -0500558_us-ascii OK: I've searched the archives and could not find this. Doesn't mean its not there. I just didn't see it. We need a flat file version of an full imagecopy data set. The imagecopy is at the partition level created by IBM copy. The IBM manual Utility Guide and Reference does not discuss this but Craig Mullin's Developer's Guide 3rd ed for DB2 v4+v5 on page 888 states that we can "Create a sequential data set copy of an image copy data set produced using the DB2 copy utility, except for segmented tablespaces." I've been unsuccessful so far. [...]
1720 16 23_Re: SQL Doesn't Work???15_Walter Janissen27_walter.janissen@VICTORIA.DE30_Thu, 1 Mar 2001 09:36:01 -0600421_- Lisa
Another shot: What is your DB2 version. If it's version 5 in a join condition you are only allowed to use a column or the function COALESCE resp. VALUE
Walter
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
1737 141 21_Re: table last access7_Mark S.23_Mark_Sopczak@WENDYS.COM30_Thu, 1 Mar 2001 10:52:09 -0500448_us-ascii Another suggestion..... unless you are talking about a large number of rows. You COULD issue a rename table to the table name, keep it in the same tablespace name, wait a month or so and if no one complains about where is table '####', image copy/ddl save and drop it. If someone does complain simply rename the table back to its original name and you are back in business. I did this with quite a few tables here and it worked well. [...]
1879 50 45_Re: Moving to large tablespace - may be not!!15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Thu, 1 Mar 2001 09:53:12 -0600579_iso-8859-1 Yes you will get an error. The RID size in a non-large environment is 4 bytes, while in a large tablespace it is 5.
You have to UNLOAD the data and then LOAD it back.
Chris Blaicher
BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154
BMC Software, Inc. makes no representations or promises regarding the reliability, completeness, or accuracy of the information provided in this discussion; all readers agree not to rely on or take any action against BMC Software in response to this information. [...]
1930 72 23_Re: SQL Doesn't Work???13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 1 Mar 2001 09:55:22 -0600421_iso-8859-1 Lisa,
Is this V5? If so, easy to explain. No expressions in the ON clause. So you would need to code:
SELECT D.DBKEY, E.FICS FROM DEVL.TW4B0 E LEFT OUTER JOIN (SELECT SUBSTR(D.DBKEY,1,16) AS SUB_DBKEY, DBKEY FROM DEVL.TA200) AS D ON D.SUBDBKEY = E.POLNO
This will perform poorly unless a merge scan join is chosen by the optimizer though (let me know if you need a solution to that). [...]
2003 64 21_Re: table last access10_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Thu, 1 Mar 2001 09:57:43 -0600584_us-ascii Silvia,
If you are pretty sure no-one should be accessing the table - stop the tablespace.....as long as they SHOULDN'T be accessed, you are within the limits by being safe and dipping your toe in the water before dropping objects. I'd be pretty cautious doing this in production, but most shops have test or integration systems they can swing at first. You can also check the image copy jobs, they tell you the number of pages changed since the last image copy....syscopy will tell you the last time they were copied, and if you check the numbers it should shed [...]
2068 43 21_Re: table last access10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Thu, 1 Mar 2001 09:48:27 -0600368_- Good point. That's why I have to be pretty sure of myself before dropping absolutely anything at all, and even then I'm nervous. There are old DBAs, and there are bold DBAs, but there are no old, bold DBAs. (Ut humiliter opinor;).
Die dulci freure,
John Hardy
On Thu, 1 Mar 2001 16:31:45 +0100, Max Scarpa wrote: [...]
2112 76 23_Re: SQL Doesn't Work???0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 1 Mar 2001 11:03:07 -0500455_us-ascii Because you can't do column functions or anything else in the 'ON' part of a outer join. Try using the nested table as follows:
SELECT T1.DBKEY, E.FICS FROM DEVL.TW4B0 E LEFT OUTER JOIN (SELECT SUBSTR (D.DBKEY, 1, 16) AS DBKEY_CHECK, DBKEY FROM DEVL.TA200 D) AS T1 ON T1.DBKEY_CHECK = E.POLNO
"Westcott-Dryer, Lisa" @RYCI.COM> on 03/01/2001 10:28:23 AM [...]
2189 34 40_Re: DSN1COPY Full Imagecopy to Flat File14_Kurt Wickhorst28_Kurt.Wickhorst@METAVANTE.COM30_Thu, 1 Mar 2001 09:57:48 -0600676_us-ascii Here is how I do it with platinum:
//AAACCTT EXEC PGM=PTLDRIVM, // PARM='EP=UTLGLCTL/B2P8', // REGION=7M //STEPLIB DD DSN=B2N.OPER.PLAT.LOADLIB,DISP=SHR //PTILIB DD DSN=B2N.OPER.PLAT.LOADLIB,DISP=SHR //PTIPARM DD DSN=B2N.OPER.PLAT.PARMLIB,DISP=SHR //PTIXMSG DD DSN=B2N.OPER.PLAT.XMESSAGE,DISP=SHR //PTIMSG DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSCTL01 DD DSN=SSPSN.OPER.CNTL(AAACCTT),DISP=SHR //SYSIMAG DD DSN=AENG.R6.OPIC.AE0016D.AAACCTS(0),DISP=SHR //SYSREC01 DD DSN=&PREF..AAACCTT,&DSPFLAT.,&DSBFLAT //* //SYSIN DD * FASTUNLOAD LOAD-CONTROL DB2LOAD OUTPUT-FORMAT DSNTIAUL INPUT-FORMAT IMAGECOPY EXCP YES SELECT * FROM AE6.AAACCTT; [...]
2224 104 23_Re: SQL Doesn't Work???0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 1 Mar 2001 11:08:53 -0500318_iso-8859-1 Yes it is in the documentation. This is an except from our DB2 version five manual on outer joins:
A join condition:
~ Must begin with ON, which allows rows where the values in the joined columns do not match, as well as rows where the values in the joined columns match, to be included. [...]
2329 65 30_Re: Latin and the modern world0_19_mike.holmans@BT.COM30_Thu, 1 Mar 2001 16:12:17 -0000443_- "non" and "est" are perfectly good Latin words, but "illegitimi" and "carborundum" are not. It's "joke Latin", using Latin-like words which English speakers can easily guess the "meaning" of. If you actually wanted to say "don't let the bastards grind you down" or something similar in Latin, you'd have to say "Non conterendus est nothis". Its widespread popularity in the US probably originates from an article by HL Mencken in 1920. [...]
2395 14 39_Re: Assembler program & SQL - a request12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 1 Mar 2001 09:53:28 -0600437_- There are a couple of sample programs provided that might be useful on SDSNSAMP, DSNTIAD and DSNTIAUL. They don't have the static SQL, but the other code will probably work.
Roger Miller
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2410 38 48_HOA Users Group Host Terry Purcell - March 6-7th12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Wed, 28 Feb 2001 10:21:53 -0600374_iso-8859-1 Hello List,
The Heart of America DB2 Users group in Kansas City, MO is hosting two sessions given by popular SQL guru Terry Purcell.
The sessions are one day each:
March 6th - Advanced and Complex SQL March 7th - SQL Performance Design and Coding
You can contact the Heart Of America DB2 User Group via http://www.hoa-db2rug.org/ [...]
2449 47 29_Re: Java SP Problems On Linux15_Christopher Tee24_chris.tee@TOTALISE.CO.UK30_Thu, 1 Mar 2001 16:15:46 +0000725_ISO-8859-1 Try downloading and installing the latest fixpak 2. The specific APAR is IY09948. There is a workaround, move your SP into sqllib/function.
>===== Original Message From DB2 Data Base Discussion List ===== >I'm trying to use the DB2 Stored Procedure Builder on Windows NT to build >Java stored procedures on DB2 UDB V 7.1 for Linux. The Java SP is >successfully compiled, achieved, installed through sqlj.install_jar, and >created via DDL. When the Java SP is executed, I get the following >message: > >[IBM][CLI Driver][DB2/LINUX] SQL4304N Java stored procedure or >user-defined function "B05CXS .PROCEDURE1", specific name >"SQL010228153617340" could not load [...]
2497 27 74_A Program to Replace Host Variables with :H or ? in saved Dynamic SQL Text13_Brian Charles20_bcharles@RITEAID.COM30_Thu, 1 Mar 2001 11:33:20 -0500581_iso-8859-1 We are trying to step up our monitoring and tuning of dynamic SQL comming from various adhoc tools and Power Builder apps. Platinum detector is storing the SQL but it contains the host variable values and we SQL in history tables. If I want to combine CPU time for all like statements, this isn't possible when the only difference between 2 statements can be the host variable values. The same query executed by 2 different users with different WHERE criteria may show up as different statements. I figure that if I can normalize the sql text by replacing all host [...]
2525 109 26_Various DB2 Jobs Available4_Info28_info@PALLADIANCONSULTING.COM30_Thu, 1 Mar 2001 08:45:54 -0800428_iso-8859-1 Dear Colleagues, Palladian Consulting is a national IT consulting firm specializing in RDBMSs. We have a wide client base throughout the United States, which includes government, commercial, financial, healthcare, and industrial companies. Our clients are always seeking consultants with strong skills in DB2 and various other RDBMSs. We currently have the following positions available (requires US residency). [...]
2635 20 14_RENAME command14_Toppins, Smike21_smike.toppins@GWL.COM30_Thu, 1 Mar 2001 10:17:22 -0700506_- When you RENAME a table, does the command automatically take care of indexes and views (synonyms and aliases) that are based on the table or do those need to be corrected manually?
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
2656 206 10_Re: Unload10_Wim Ruarus18_w.h.ruarus@KPN.COM30_Thu, 1 Mar 2001 18:19:25 +0100335_iso-8859-1 Bala,
since you are usung BMC's UnloadPlus there is a very easy way to get the fields in a fixed position in your dataset. Just use the 'FIXEDVARCHAR YES'option:
> > //SYSIN DD * > > UNLOAD > > ORDER YES > > MAXSORTS 3 > > SORTNUM 12 > > ENUMROWS 100000 > > FIXEDVARCHAR YES > > DIRECT NO > > SELECT etc. [...]
2863 116 21_Re: table last access15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Thu, 1 Mar 2001 18:20:25 +0100470_iso-8859-1 What about stopping the tablespace/indexes (if you have one table per tablespace), does the trick also..
Regards,
Jaap Slot, sr. DB2 DBA, Rabobank ICT
Phone 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167 e-Mail < mailto:J.P.Slot@rf.rabobank.nl >
Reserve your AGENDA for next DB2 Users Group Conference IDUG Florence - 8/11 October 2001 - < http://www.idug.org > [...]
2980 63 18_Re: RENAME command0_19_Tim.Lowe@STPAUL.COM30_Thu, 1 Mar 2001 11:33:15 -0600423_us-ascii SMike, See the DB2 SQL reference manual under RENAME. Views (and synonyms) are restrictions, you must remove them before you can use the rename command. Indexes are transferred. I do not believe that aliases are changed.
Thanks, Tim
"Toppins, Smike" To: DB2-L@RYCI.COM Subject: RENAME command Sent by: DB2 Data Base Discussion List [...]
3044 89 24_Re: RENAME table command7_Mark S.23_Mark_Sopczak@WENDYS.COM30_Thu, 1 Mar 2001 12:48:38 -0500289_us-ascii I do know renaming the table does include the index. I can't speak to views, alias, or synonyms, we did not have any in our instance. I would say you would have to test that. I would venture to say that synonyms and alias would not work anymore... views probably not either. [...]
3134 50 77_Re: A Program to Replace Host Variables with :H or ? in saved DynamicSQL Text9_Rob Crane22_racrane@CONCENTRIC.NET30_Thu, 1 Mar 2001 11:30:50 -0700623_us-ascii The reason they show up as different statements is because they are, and the optimizer will treat them differently. Rolling it all up under one total and not paying attention to the predicate differences and the host variable cardinatilty differences will not give you a realistic figure.
Having the real values for the host variables will allow you to get a better understanding of why the optimizer selected the path it did based on the characteristics of those host variables. This also allows you to understand how many different statements where passed to the optimizer and which ones were passed [...]
3185 30 32_EMC DASD and SEQCACH and SEQPRES16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 1 Mar 2001 13:31:08 -0500389_iso-8859-1 Per a hardware vendor recommendation, we have been running with ZPARM paramter SEQCACH set to SEQ. I believe this is appropriate based on what I see in the manual. We have also been running with SEQPRES set to YES.
EMC wants us to use SEQCACH=BYPASS and SEQPRES=NO
Has anyone had any experience (positive or negative) for doing this on an EMC Symmetrix 9900? [...]
3216 54 28_Unavailable Resource Mystery12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Thu, 1 Mar 2001 12:53:04 -0600365_us-ascii Help! V6.1, OS/390 2.10 here.
We just restored our new production database tables with a To RBA recovery. (The database name is: FIDPBALN.) The return code was 04, which I assumed was the "informational copy pending" message on my indexes which I set to COPY YES a while back. (We don't do COPY's on them. We include a REBUILD in the restore.) [...]
3271 85 32_Re: Unavailable Resource Mystery12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Thu, 1 Mar 2001 14:12:35 -0500737_us-ascii did you display util(*)??
Steve Grimes @RYCI.COM> on 03/01/2001 01:53:04 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Unavailable Resource Mystery
Help! V6.1, OS/390 2.10 here.
We just restored our new production database tables with a To RBA recovery. (The database name is: FIDPBALN.) The return code was 04, which I assumed was the "informational copy pending" message on my indexes which I set to COPY YES a while back. (We don't do COPY's on them. We include a REBUILD in the restore.) [...]
3357 101 36_Unavailable Resource Mystery (Reply)0_22_scott.goodell@WCOM.COM30_Thu, 1 Mar 2001 13:13:15 -0600326_us-ascii The may is kind of an obvious question but you did not include the display database output.
The 00C90086 reason code states the object is started for utility access.
Is the tablespace or database on the display have a UT status instead of RW?
If so you need to start the DB or TS access(RW) [...]
3459 76 32_Re: Unavailable Resource Mystery16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Thu, 1 Mar 2001 14:14:19 -0500752_us-ascii 00C90086, TYPE OF RESOURCE 00000100, AND RESOURCE NAME FIDPBALN started utility access only?
Steve Grimes on 03/01/2001 01:53:04 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Unavailable Resource Mystery
Help! V6.1, OS/390 2.10 here.
We just restored our new production database tables with a To RBA recovery. (The database name is: FIDPBALN.) The return code was 04, which I assumed was the "informational copy pending" message on my indexes which I set to COPY YES a while back. (We don't do COPY's on them. We include a REBUILD in [...]
3536 85 32_Re: Unavailable Resource Mystery18_Teegarden, Stephen22_Teegarden@AEGONUSA.COM30_Thu, 1 Mar 2001 13:21:55 -0600651_- DO A DISPLAY UTILITY and a term if needed.....
00C90086
Explanation: An attempt was made to allocate a resource that is started for DB2 utility access only.
Steve Teegarden, DBA AEGON USA 319-398-8066
> -----Original Message----- > From: Steve Grimes [SMTP:Steve_Grimes@AISMAIL.WUSTL.EDU] > Sent: Thursday, March 01, 2001 12:53 PM > To: DB2-L@RYCI.COM > Subject: Unavailable Resource Mystery > > Help! V6.1, OS/390 2.10 here. > > We just restored our new production database tables with a To RBA > recovery. > (The database name is: FIDPBALN.) The return code was 04, which I > assumed was > the "informational copy [...]
3622 89 32_Re: Unavailable Resource Mystery12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Thu, 1 Mar 2001 14:24:04 -0500320_iso-8859-1 Since the unavailable resource is database (resource type 100), is it possible that all the tablespaces are in RW but the DATABASE is in UT? At the top of the display from -DIS DB(FI*) SPACE(*) LIMIT(*) RESTRICT you will see:
DSNT362I -DB2xx DATABASE = xxx STATUS = UT
if this is the case. [...]
3712 100 32_Re: Unavailable Resource Mystery18_Teegarden, Stephen22_Teegarden@AEGONUSA.COM30_Thu, 1 Mar 2001 13:25:17 -0600631_- ANOTHER THOUGHT !
You may only need to issue at START (RW) COMMAND
Steve Teegarden, DBA AEGON USA 319-398-8066
> -----Original Message----- > From: Teegarden, Stephen > Sent: Thursday, March 01, 2001 1:22 PM > To: 'DB2 Data Base Discussion List' > Subject: RE: Unavailable Resource Mystery > > DO A DISPLAY UTILITY and a term if needed..... > > 00C90086 > > Explanation: An attempt was made to allocate a resource that is started > for DB2 utility access only. > > Steve Teegarden, DBA > AEGON USA > 319-398-8066 > > -----Original Message----- > From: Steve Grimes [SMTP:Steve_Grimes@AISMAIL.WUSTL.EDU] [...]
3813 18 30_Re: Latin and the modern world26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Thu, 1 Mar 2001 13:25:36 -0600334_- Hmmm, I went to public schools and the college prep trail required 4 terms of "foreign language". I took six of latin, but about all I remember was translating something from the Odessy into "throwing stones in back of their rears." (Behind their backs). Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...]
3832 70 32_Re: Unavailable Resource Mystery15_David A. Zelmer25_david.zelmer@CITICORP.COM30_Thu, 1 Mar 2001 13:27:47 -0600565_us-ascii The 00C90086 indicates the database is in utility only status. Try to start the database for RW access. It is possible for all the tablespaces and indexspaces to be in RW status but the database to be in UT status.
HTH,
Dave
Steve Grimes wrote: > > Help! V6.1, OS/390 2.10 here. > > We just restored our new production database tables with a To RBA recovery. > (The database name is: FIDPBALN.) The return code was 04, which I assumed was > the "informational copy pending" message on my indexes which I set to COPY YES a > while [...]
3903 16 32_Re: Unavailable Resource Mystery12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Thu, 1 Mar 2001 13:27:59 -0600369_us-ascii Ooops -- go it. I needed to do a STOP DB before the START. That worked for me.
Sorry for the traffic.
Sg
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
3920 89 32_Re: Unavailable Resource Mystery15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Thu, 1 Mar 2001 13:29:38 -0600423_iso-8859-1 Hi, Steve, Try doing the display for restricted databases only. The resource type indicates that a database is unavailable. The reason code indicates that the database has been started for utility only access. This probably won't come up when you issue a command to look for tablespaces.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin [...]
4010 103 23_Re: SQL Doesn't Work???20_Westcott-Dryer, Lisa32_Lisa_Westcott-Dryer@FOREMOST.COM30_Thu, 1 Mar 2001 14:26:59 -0500340_iso-8859-1 Terry,
I don't see in the manual where you can have a subselect as your joined-table or part of a join-condition.
I tried it anyway and get DSNT408I SQLCODE = -206, ERROR: D.DBKEY IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE
Don't think that's possible. [...]
4114 27 32_Re: Unavailable Resource Mystery12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Thu, 1 Mar 2001 13:33:53 -0600345_us-ascii Hi - thank you for the suggestions.
I had done a -DIS UTIL(*), and didn't see any utilities. Also, I've also been used to seeing the UT status at the tablespace level, but indeed, the recovery job had a START DB ACCESS(UT) at the database level. I didn't see this until I removed the RESTRICT from my -DIS DATABASE command. [...]
4142 34 18_Structure of a RID11_Jeff Schade21_jschade@MAIL2.PCH.COM30_Thu, 1 Mar 2001 14:32:14 -0500366_US-ASCII I have what I hope is a simple question. How do I break down the following RID value into the page number & offset value so I can locate the actual row data:
RID OF INDEXED ROW = X'0003199E03'
I would have thought this was documented in one of the IBM manuals but I could not locate anything that specifically breaks down the 5 byte rid. [...]
4177 37 30_Re: Latin and the modern world12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Thu, 1 Mar 2001 11:59:24 -0800420_iso-8859-1 Mine only went as far as Caesar's Gallic Wars: Veni, vidi, vici. Of course, the guys in the class always proposed a different version for the benefit of the girls: Vidi, vici, veni. :-)
Wayne Kline
-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Thursday, March 01, 2001 11:26 AM To: DB2-L@RYCI.COM Subject: Re: Latin and the modern world [...]
4215 50 22_Re: Structure of a RID13_Pranav Sampat21_psampat@PACIFICEX.COM30_Thu, 1 Mar 2001 12:03:21 -0800277_US-ASCII RID for a tablespace (not Large) is four bytes in length, first 3 are for Page Number and the last byte denotes the row number within that page. For a TS created with large attribute RID is 5 bytes, 4 bytes for page number + 1 byte denoting row within that page. [...]
4266 68 22_Re: Structure of a RID12_Susan Lawson22_lawson_susan@YAHOO.COM30_Thu, 1 Mar 2001 12:05:02 -0800543_us-ascii Jeff,
Look in the DB2 Diagnostics manual for this information. Also, if you went to IDUG or IBM Tech last year Chris Skelnik of GBR gave a detailed presentation on this - "PAGEing All DBAs: Do you know where your data is".
Regards, Susan --- Jeff Schade wrote: > I have what I hope is a simple question. How do I > break down the following RID value into the page > number & offset value so I can locate the actual row > data: > > RID OF INDEXED ROW = X'0003199E03' > > I would have thought [...]
4335 133 41_Newbie Admin: Can't create DMS containers12_Bill Littman24_blittman@TOMOTHERAPY.COM30_Thu, 1 Mar 2001 14:08:53 -0600299_iso-8859-1 We are developing a product that includes a DB2 UDB 7.1 Database. Part of my task is to test the database on a number of different types of machines. I have successfully tested it on: Win NT Workstation 4.0 - 1 Processor Win NT Server 4.0 - 2 Processor Win 2000 Server - 1 Processor [...]
4469 138 23_Re: SQL Doesn't Work???13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 1 Mar 2001 14:21:31 -0600429_iso-8859-1 Lisa,
Sorry, there were two minor typos in my mail.....it should have been:
SELECT D.DBKEY, E.FICS FROM DEVL.TW4B0 E LEFT OUTER JOIN (SELECT SUBSTR(DBKEY,1,16) AS SUBDBKEY, DBKEY FROM DEVL.TA200) AS D ON D.SUBDBKEY = E.POLNO
That should work....once again, performance may not be acceptable, and what you would want is the optimizer to choose a merge scan join (contact me if you need this). [...]
4608 58 22_Re: Structure of a RID15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Thu, 1 Mar 2001 15:06:03 -0600352_iso-8859-1 Look in V5 or later Diagnosis Guide and Reference manual. In V5 manual it is in section 6.1.3.5.1.
It is not quite as simple as 3 or 4 bytes of page number and row number byte, at least for partitioned tables.
Chris Blaicher
BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154 [...]
4667 24 33_I/O Performance - Where to start?12_Dallas Focht21_dallas.focht@PMIC.COM30_Thu, 1 Mar 2001 15:09:45 -0600542_us-ascii I am not sure on where to go trying to solve a performance degradation issue. A nightly batch job ran for 2 hours one night and 3 and 1/2 hours the next. Looking a TMON statistics, the number of GET PAGES, number of SYNC READs, and number of ASYNC READS are near identical. CPU time and lock wait time are also the same. The only difference looks like the Class 3 Synchronous I/O time, 86 minutes one time, and 174 minutes the next. The application's table and index spaces are in separate buffer pools from other applications. [...]
4692 47 37_Re: I/O Performance - Where to start?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 1 Mar 2001 16:25:05 -0500519_iso-8859-1 First try looking at an RMF report for the DASD involved. Compare the intervals of the 2.5 hr job with the intervals of the 3.5 hr job. Look especially for more I/O against the devices, higher response time, and for 'disconnect' and 'reserve' times.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Dallas Focht [mailto:dallas.focht@PMIC.COM] Sent: Thursday, March 01, 2001 4:10 PM To: DB2-L@RYCI.COM Subject: I/O Performance - Where to start? [...]
4740 57 37_Re: I/O Performance - Where to start?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Thu, 1 Mar 2001 15:28:27 -0600385_us-ascii Make sure the access paths are okay by looking at the explain data for each run if you can... : )
Dallas Focht cc: Sent by: DB2 Subject: I/O Performance - Where to start? Data Base Discussion List
03/01/01 03:09 PM Please respond to DB2 Data Base Discussion List [...]
4798 16 37_Re: I/O Performance - Where to start?0_26_truman.g.brown@VERIZON.COM30_Thu, 1 Mar 2001 16:58:01 -0500473_us-ascii Get an I/O report from your DASD management people for the volumes involved and check the activity rates and allocations. It may have been I/O wait time if something else was hitting some of the same volumes.
George
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4815 13 47_Re: DB2 performance monitors for NT/Solaris ???13_Jim Wankowski23_jim.wankowski@QUEST.COM30_Thu, 1 Mar 2001 15:45:26 -0600541_- Check out Quest Software's Quest Central for DB2. This is a Windows based console for administration of DB2 running on UNIX/NT. It is comprised of 4 main components: database administration, SQL Tuning, space management, and performaqnce monitoring. Download a free trial copy at WWW.QUEST.COM/DB2
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4829 54 37_Re: I/O Performance - Where to start?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 1 Mar 2001 17:04:45 -0500546_ISO-8859-1 You certainly have a massive I/O problem. Just putting it into a quick perspective, Even your first batch run of 2 hrs, was 72% I/O wait time. The second job sounds like your dasd was clobbered by another job (s) while this was runing.
Now there are two paths you need to travel, both at the same time. a. Tune your buffer pools to reduce the I/O b. Look at the dasd performance. Divide the total synch I/O elapsed, by the number of synch I/Os.... this give you the Avg. In todays environments, you's like to see the avg < [...]
4884 28 74_My network admin changed my server's IP address, and now DB2 won' t start!10_Mike Wiles14_mwiles@UCG.COM30_Thu, 1 Mar 2001 17:06:54 -0500547_iso-8859-1 Hi List!
My subject line pretty much describes it all. My AIX admin had to change my server's IP Address to a different segment and now DB2 hangs on db2start. I've looked all over for configuration information regarding the ip address, but the only thing DB2 ever seems to use is the mnemonic (which has not changed). Does anyone have any idea what could be wrong? I'm not ruling out the possibility that my server just got whacked during the bounce, but I have never seen a reboot of _any_ kind affect my databases so far. [...]
4913 27 40_Re: DSN1COPY Full Imagecopy to Flat File14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 2 Mar 2001 11:00:18 +1100640_iso-8859-1 and BMC's Unload+ uses an INFILE control parameter.
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: Kurt Wickhorst [mailto:Kurt.Wickhorst@METAVANTE.COM] Sent: Friday, 2 March 2001 2:58 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DSN1COPY Full Imagecopy to Flat File
Here is how I do it with platinum:
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
4941 40 48_Stored Procedure Error Message DSNX962I DSNX9SER11_Karl Haynes20_karlhaynes@YAHOO.COM30_Thu, 1 Mar 2001 18:26:22 -0600440_- I have created a Stored Procedure which runs in the DB2 Managed address Space not WLM. I used the following syntax to create an entry in SYSROUTINES:
CREATE PROCEDURE UPDOMNIS LANGUAGE COBOL DETERMINISTIC EXTERNAL NAME 'UPDOMNIS' COLLID T1SEA ASUTIME NO LIMIT PARAMETER STYLE GENERAL WITH NULLS STAY RESIDENT NO RUN OPTIONS 'MSGFILE(OUTFILE),RPTSTG(ON),RPTOPTS(ON)' PROGRAM TYPE SUB EXTERNAL SECURITY DB2 COMMIT ON RETURN NO; [...]
4982 58 36_Re: EMC DASD and SEQCACH and SEQPRES12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM30_Thu, 1 Mar 2001 18:48:42 -0600551_- Eric:
I think they asking you to do that because those new dasd devices has the capability to use the benefits of cache with db2 without turnning on the SEQCACH zparm to SEQ. I wasn't aware of it but as soon I started to change one of our db2 subsystem Zparm from SEQCACH=BYPASS to SEQCACH=SEQ and then I started to see a good hit cache ratio (almost higher than 90) but then I started to do some monitoring to a different db2 subsystem with the SEQCACH zparm off (SEQCACH=BYPASS) and I got the same results (High hit cache ratio). Then [...]
5041 67 52_Re: Stored Procedure Error Message DSNX962I DSNX9SER10_teldb2kals22_teldb2kals@TELSTRA.COM30_Fri, 2 Mar 2001 11:38:52 +1000445_ISO-8859-1 Hi Karl,
Its quite possible that the stored procedure has not been compiled with LE.
Following is an extract from the DB2 messages manual. " If the values of func and rc are 'ADD_ENTRY' and X'0000000C', the error might be caused by using a compiler that is not Language Environment enabled to create the stored procedure. DB2 stored procedures must be compiled with a compiler that supports Language Environment. " [...]
5109 79 14_Re: DB2 Select13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Thu, 1 Mar 2001 19:49:52 -0600494_us-ascii Siva,
As far as I am aware, there is only the functions you mention (plus LCASE).
You can achieve what you want by forcing the column to one case rather than ignoring the case, such as:
WHERE UCASE(NAME) LIKE '%LO%'
With or without the UCASE function you will never get an index match (or index range delimiting), since the first '%' qualifies as a range predicate, therefore the predicate is index sargable (or index screening or index non-matching). [...]
5189 81 30_Re: Latin and the modern world15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Fri, 2 Mar 2001 11:21:44 +1100644_- Eh?
> -----Original Message----- > From: Michael J. O'Neill [SMTP:mike.oneill@customs.treas.gov] > Sent: Thursday, 1 March 2001 10:02 pm > To: DB2-L@RYCI.COM > Subject: Re: Latin and the modern world > > Si hoc legere scis nimium eruditionis habes. > > > ______________________________ Reply Separator > _________________________________ > Subject: Latin and the modern world > Author: "DB2 Data Base Discussion List" at smtplink > Date: 2/28/01 5:51 PM > > > Dave, > > Didn't know you had a classical education. Or was it just that latin > happened to be the language of choice in classrooms all those centuries [...]
5271 73 21_Re: table last access14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Fri, 2 Mar 2001 14:19:02 +1100433_iso-8859-1 To answer you question, unless you are keeping specific IFCID trace records - no.
If you are looking at dropping the tablespace I, personally, would take a multi-staged approach:
1) produce a general 'is anyone using this table' broadcast. This is pure CYA.
2) is the table updated by anyone? Use REPORT RECOVERY to see if it has been updated recently (ie since the oldest SYSCOPY entry for it). [...]
5345 97 21_Re: table last access15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Fri, 2 Mar 2001 15:59:36 +1100621_iso-8859-1 One minor enhancement. Option 6) below should in fact be the first action. Apart from that, I offer complete concurrence.
Raymond 'wasn't paying attention in Latin class' Bell PS: The fact that I don't know a single Latin expression should in no way reflect badly on my current client.
> -----Original Message----- > From: James Campbell [SMTP:James.Campbell@HANCORP.COM.AU] > Sent: Friday, 2 March 2001 2:19 pm > To: DB2-L@RYCI.COM > Subject: Re: table last access > > To answer you question, unless you are keeping specific IFCID trace > records > - no. > > If you are looking at dropping [...]
5443 34 13_Validate(RUN)18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH30_Fri, 2 Mar 2001 11:09:13 +0100439_iso-8859-1 Hi
With the VALIDATE(RUN) the Bind package checks the existence of objects and the authorization already at bind time. When not correct these checks are made at runtime. Is the conclusion right, that no Checks are made at runtime, when existence of objects and autorization have been already correct at Bindtime? Or with other words: Validate(RUN) doesn't mean, that Validations are made for every Run of a program? [...]
5478 15 30_Re: Latin and the modern world15_Lankester, Andy22_Andy_Lankester@BMC.COM30_Fri, 2 Mar 2001 04:41:55 -0600377_iso-8859-1 "A gentleman need not know Latin, but he should at least have forgotten it." Brander Matthews (attrib)
Andy Lankester
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5494 79 17_Re: Validate(RUN)16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 2 Mar 2001 16:22:59 +0530603_- Hi Hansueli,
If we look at the description of VALIDATE(RUN) closely, i think it is statement wise. As per the description, If you specify the bind option VALIDATE(RUN),and a "statement" in the plan or package is not bound successfully,that "statement" is incrementally bound at run time.
So my answer is, if authorization check of a particular SQL fails then only the checks are done at the run time, that too for that SQL only. But that check (statement wise) will occur for every run of the program because DB2 do not record that anywhere in the catalog/directory once the checks [...]
5574 31 30_Re: Latin and the modern world10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Fri, 2 Mar 2001 05:42:35 -0600326_- I hope that nobody takes umbridge at me for continuing this off-topic thread (nemo me impune lacessit;)) but it's Friday and I'm going to do it anyway...
This talk of ancient languages (ok, Latin in particular) reminds me of one of my favourite stories which came from the Readers Digest (so it must be true;)): [...]
5606 86 15_V6 Migration...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Fri, 2 Mar 2001 14:33:14 +0200409_windows-1254
Hello List,
I have a couple of questions about V6 Migration.
1. Did you have any performance problems with V5 after applying Toleration/Fallback PTFs ? 2. How long did you wait with V5 + Toleraton PTFs Until V6 Migration ? 3. Did you have any problems with CATMAINT ?
Regards,
Cuneyt GOKSU Garanti Teknoloji Tel : 0090-212-4783210 mailto:Cuneytg@garanti.com.tr
5693 83 30_Re: Latin and the modern world18_Michael J. O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV30_Fri, 2 Mar 2001 07:42:11 -0500489_ISO-8859-1
Go gcreime cúnna ifrinn do mhamaí.
Its Old Irish ... have fun!
______________________________ Reply Separator _________________________________ Subject: Re: Latin and the modern world Author: "DB2 Data Base Discussion List" at smtplink Date: 3/2/01 6:42 AM
I hope that nobody takes umbridge at me for continuing this off-topic thread (nemo me impune lacessit;)) but it's Friday and I'm going to do it anyway... [...]
5777 55 19_Re: V6 Migration...12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Fri, 2 Mar 2001 07:52:16 -0500693_iso-8859-1 1) no 2) 3 weeks 3) none at all
"Cuneyt Goksu (Garanti Teknoloji)" @RYCI.COM> on 03/02/2001 07:33:14 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: V6 Migration...
Hello List,
I have a couple of questions about V6 Migration.
1. Did you have any performance problems with V5 after applying Toleration/Fallback PTFs ? 2. How long did you wait with V5 + Toleraton PTFs Until V6 Migration ? 3. Did you have any problems with CATMAINT ? [...]
5833 58 19_Re: V6 Migration...0_17_sjvagnier@AEP.COM30_Fri, 2 Mar 2001 08:16:35 -0500739_iso-8859-1 1). NO 2). 2 weeks 3). NO (PUTlevel 12/2000 + Hipers)
"Cuneyt Goksu (Garanti Teknoloji)" @RYCI.COM> on 03/02/2001 07:33:14 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: V6 Migration...
Hello List,
I have a couple of questions about V6 Migration.
1. Did you have any performance problems with V5 after applying Toleration/Fallback PTFs ? 2. How long did you wait with V5 + Toleraton PTFs Until V6 Migration ? 3. Did you have any problems with CATMAINT ? [...]
5892 24 30_Re: Latin and the modern world13_Lockwood Lyon19_Lockwool@MEIJER.COM30_Fri, 2 Mar 2001 08:17:06 -0500406_US-ASCII Thanks to all for this thread. Sig updated; onward.
- - LL
Lockwood Lyon -- Meijer Technical Support (616) 735-7553 (office) (616) 791-5131 (fax)
Copyright (c) 2001 by Lockwood Lyon. All rights reserved. These opinions are mine and not necessarily those of my employer, Meijer, Inc. "Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?" [...]
5917 27 22_BMC on-line reorg tool18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Fri, 2 Mar 2001 08:27:20 -0500324_iso-8859-1 I'd like to get some info on BMC's on-line reorg tool. Is anyone out there in DB2-land using this vendor product and how do you feel about it? We're currently at DB2 Version 5 looking to go to DB2 V6 within the next year. Appreciate any info. (any BMCer's; if your out there feel free to email me directly). [...]
5945 25 11_WLM and DB20_19_mike.holmans@BT.COM30_Fri, 2 Mar 2001 14:08:45 -0000330_- I'm going to a meeting with our OS/390 people next week to discuss the implementation of WLM Goal Mode.
Is there a handy checklist of issues which I need to cover with them in order to make sure that we can do everything that the manual says DB2 can do? Assume DB2 for OS/390 V6, OS/390 2.10, for what that's worth. [...]
5971 39 0_32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Fri, 2 Mar 2001 15:53:32 +020025_windows-1254 review db2-l
6011 43 53_DB2 and real/virtual storage infos - may be off topic10_Max Scarpa16_mscarpa@CESVE.IT30_Fri, 2 Mar 2001 15:35:04 +0100393_us-ascii Estemeed list, sorry if this may be off-topic.
I won (how lucky I am) a brand new LPAR to use for DR tests, ATL tests applied to DB2 utility/data management (oh it's
only a 128 MB LPAR) and other performance tests, when this LPAR is available.
I would like to examine during ATL tests the use of central/virtual storage of DB2 under controlled condition and [...]
6055 35 39_Question about Control Center for OS39011_Jose' Gomez21_Jose_Gomez@WENDYS.COM30_Fri, 2 Mar 2001 09:42:25 -0500298_us-ascii Where are the following Procedures to enable the CC on OS/390?. Are they on any of the CD's delivered with DB2 UDB for OS390?
DSNACCMD (Control Center stored procedure result set server program) DSNACCQC (Control Center stored procedure result set server for query catalog) DSNACCMG
6091 13 3_WLM14_Philip Gunning26_philip_gunning@HOTMAIL.COM30_Fri, 2 Mar 2001 09:53:32 -0500
6105 80 43_Re: Question about Control Center for OS39015_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Fri, 2 Mar 2001 16:02:42 +0100610_iso-8859-1 Schema Specificname Collection Id ParmCtFncTypOriginLanguage
-v----1----v----2----v----3----v----4----v----5----v----6----v----7----v--- SYSPROC DSNACCAV DSNACC 11 E C
SYSPROC DSNACCMD DSNACC 8 E C
SYSPROC DSNACCMG DSNACC 13 E C SYSPROC DSNACCQC DSNACC 16 E C
They should be, they are within the intallation for DB2 UDB for OS/390 version 6.
Kind regards,
Jaap Slot, sr. DB2 DBA, Rabobank ICT
Phone 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167 e-Mail < mailto:J.P.Slot@rf.rabobank.nl > [...]
6186 78 43_Re: Question about Control Center for OS39011_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM30_Fri, 2 Mar 2001 09:25:00 -0600548_iso-8859-1 They are created by the install CLIST when the SAMPLIB dataset is created... : )
Jose' Gomez cc: Sent by: DB2 Subject: Question about Control Center for Data Base OS390 Discussion List
03/02/01 08:42 AM Please respond to DB2 Data Base Discussion List
Where are the following Procedures to enable the CC on OS/390?. Are they on any of the CD's delivered with DB2 UDB for OS390? [...]
6265 87 43_Re: Question about Control Center for OS39012_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Fri, 2 Mar 2001 10:39:43 -0500530_iso-8859-1 hi, doesnt it require fmid jdb661d on the mainframe? thats what is confusing us.
Jeff Faughn @RYCI.COM> on 03/02/2001 10:25:00 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Question about Control Center for OS390
They are created by the install CLIST when the SAMPLIB dataset is created... : ) [...]
6353 31 25_Space management Question14_Richard Arnold24_Richard.Arnold@CHASE.COM30_Fri, 2 Mar 2001 09:25:55 -0600377_us-ascii OS/390 V2.8; DB2 V6
Hello list,
A co-worker and I are have a discussion about space management.
He indicates that simple and partitioned table spaces do not reuse the space from deleted rows.
My view is that row space is always available for reuse. It's space from dropped tables in simple tablespaces that is not available for reuse. [...]
6385 38 30_Re: Latin and the modern world12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA30_Fri, 2 Mar 2001 11:00:59 -0500607_- Roma locuta causa finita... Rome has spoken, case closed.
Fred De Luca,DBA CCRA
> ---------- > From: Edward(Ed) J. Finnell, III[SMTP:efinnell@SEEBECK.UA.EDU] > Reply To: DB2 Data Base Discussion List > Sent: Thursday, March 01, 2001 2:25PM > To: DB2-L@RYCI.COM > Subject: Re: Latin and the modern world > > Hmmm, I went to public schools and the college prep trail required > 4 terms of "foreign language". I took six of latin, but about all I > remember was > translating something from the Odessy into "throwing stones in back of > their rears." (Behind their backs). > Edward(Ed) J. [...]
6424 75 31_Re: Traces and the OPx buffers.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US30_Fri, 2 Mar 2001 08:26:36 -0800465_iso-8859-1 I found where my trace problem was coming from, TMONDB, and how to fix it thanks to everyone's help. Thank again cliff:-)
-----Original Message----- From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa) [mailto:Robert.Knight@ALCOA.COM] Sent: Thursday, March 01, 2001 4:31 AM To: DB2-L@RYCI.COM Subject: Re: Traces and the OPx buffers.
I had this problem after our machine was moved to another site on a different sized box. [...]
6500 49 17_Re: Validate(RUN)9_Rob Crane22_racrane@CONCENTRIC.NET30_Fri, 2 Mar 2001 09:37:06 -0700489_us-ascii I am not a big fan of VALIDATE(RUN), I believe you should avoid it. Usually it becomes a topic when the DBA group and the Development group are not coordinating the propagation of DDL and SQL changes properly.
With VALIDATE(RUN) - All statements that referenced tables, views and their associated privileges that did not exist at bind time will be validated for each run. All statements whose objects/privileges existed at bind time will not be validated at run time. [...]
6550 17 30_Re: Latin and the modern world14_Harvey Puckett25_HPUCKETT@DOAS.STATE.GA.US30_Fri, 2 Mar 2001 11:30:19 -0500339_US-ASCII Labor omnia vincit Labour conquers everything. (Vergil, Georgica)
So what!?
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6568 44 29_Re: Space management Question11_Mike Turner29_Michael_Turner@COMPUSERVE.COM30_Fri, 2 Mar 2001 11:28:45 -0500443_ISO-8859-1 Richard
You are correct. Your co-worker is wrong.
Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk
Message text written by DB2 Data Base Discussion List >OS/390 V2.8; DB2 V6
Hello list,
A co-worker and I are have a discussion about space management.
He indicates that simple and partitioned table spaces do not reuse the space from deleted rows. [...]
6613 78 29_Re: Space management Question0_18_mebert@AMADEUS.NET30_Fri, 2 Mar 2001 17:44:08 +0100492_us-ascii Hi Richard,
to my knowledge, your view is correct. Two things to note: first, LOAD RESUME YES will not reuse space but always append at the end. The second point is an observation I made with a recently created set of tablespaces (partitioned), where data is inserted in ascending sequence only, by SQL. After 4 days of data are inserted, the oldest day is deleted. Thus, the TS (-partition) will hold between 3 and 4 days worth of data. Currently there is no REORG yet. [...]
6692 46 20_Re: DB2/IMS and ODBA14_Vassie, Edward21_Edward_Vassie@BMC.COM30_Fri, 2 Mar 2001 04:44:36 -0600413_iso-8859-1 There is an active discussion on this issue in the IMS-L@lists.missouri.edu forum. Dougie Lawson [Dougie.Lawson@UKOnline.co.uk] has done a lot of work in this area, including co-authoring a Redbook soon to be published.
It looks like you may need a //DFSRESLB DD DISP=SHR,DSN=IMS.RESLIB statement on the DB2 SPAS JCL. Dougie also suggests adding IMS.RESLIB to the end of the STEPLIB chain. [...]
6739 16 39_i cant find the sysibm.syscolumns table13_Juan Alvarado14_juan@GYSSA.COM30_Fri, 2 Mar 2001 11:53:08 -0600437_- i try to connect with a DB2/AS400 in a NT My program try to use the sysibm.syscolumns but cant find it. How can i create this or what can i do??
PD: i cant change the program.
TIA
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6756 29 39_Looking for help/assistance/suggestions13_Willie Favero21_wfavero@ATTGLOBAL.NET30_Fri, 2 Mar 2001 12:38:01 -0600497_us-ascii Hi all,
Now that we are well into 2001,, IDUG is coming, we may hear about Version 7, etc.... I am looking for a little help/assistance or suggestions..
In the world of DB2 for OS/390, what are the HOT issues right now. I am looking for ideas for seminars, articles and user group presentations. If you would like to make a suggestion, would you please drop me a PRIVATE e-mail so we do not clutter up the list. Please send your replies to mailto:wfavero@attglobal.net [...]
6786 19 34_DB2 Connect V7.1 fp2? experiences?13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Fri, 2 Mar 2001 12:43:27 -0600473_iso-8859-1 Hello List,
Can anyone provide feedback as to your experiences using DB2 Connect NT v7.1 fp2?
We have installed it into our test envirorment (not sandbox) and are being Dr. Watsoned to death (db2syscs.exe at 0x6d802650). It was initially sporadic and now happens 2-3 times a day. We are falling back to V6.1 fp5 which has proven very stable. We have an open problem with IBM but no fix so far. Even the "re-issued" 7.1 fp2 causes the problem. [...]
6806 58 30_Re: Latin and the modern world12_Dunn, Judith27_Judith.Dunn@INGRAMMICRO.COM30_Fri, 2 Mar 2001 13:53:40 -0500555_iso-8859-1 Wayne -
Tsk, tsk, tsk. I think maybe the ground is shaking too much on the West coast.
How about "Ixnay on the astardsbay."
Judy
-----Original Message----- From: Kline, Wayne [mailto:wayne.kline@INGRAMMICRO.COM] Sent: Thursday, March 01, 2001 2:59 PM To: DB2-L@RYCI.COM Subject: Re: Latin and the modern world
Mine only went as far as Caesar's Gallic Wars: Veni, vidi, vici. Of course, the guys in the class always proposed a different version for the benefit of the girls: Vidi, vici, veni. :-) [...]
6865 56 43_Re: i cant find the sysibm.syscolumns table11_Paul Murphy22_Paul_Murphy@MAY-CO.COM30_Fri, 2 Mar 2001 12:56:10 -0600393_us-ascii The tables you're looking for are actually under the collection/schema name for the collection. ie. if the collection/schema name is MYTESTDB then the syscolumns table is MYTESTDB.SYSCOLUMNS. This is the way the AS/400 deals with system tables since there is only one database manager. An SQL collection is referenced the same as a schema, but has it's own set of system tables. [...]
6922 18 13_db2 migration11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Fri, 2 Mar 2001 12:32:09 -0600469_- Hi List,
We have hundreds of workstations (98 & NT ) with CAE 5.1 needs to be upgraded to DB2 v6. Is there any easy way to do so other than upgrading pc by pc.
Thanks ahead Richard Yan IL dept of Human Services.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
6941 19 14_DB2 monitoring11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Fri, 2 Mar 2001 12:42:28 -0600301_- Hi List,
We'd like to have a daily report showing SQLs with the top response time & resource usage. We're considering turning on the event monitor and reformat 'db2evmon', but a little concerned about the overhead. Did anybody try the same thing or any other way to get monitor report ? [...]
6961 122 29_FW: Space management Question15_Hernandez, Hugo22_Hugo_Hernandez@BMC.COM30_Fri, 2 Mar 2001 13:00:00 -0600572_iso-8859-1 Hi Richard : Both of you are correct depending on the time when you want to reuse the space.
These are my points: 1) During normal operation for an application, new inserts will not use the space of deleted rows. This is one of the main reasons why a tablespace needs a reorganization after some time. This note apply for any kind of tablespace 2) The space of a dropped table without dropping the tablespace is not available for use until you drop the tablespace. 3) For segmented tablespaces with more than one table inside, you can use the space [...]
7084 21 16_VARCHAR question13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Fri, 2 Mar 2001 14:17:16 -0500407_- Hi listers, If I move spaces to a host variables and insert same into a table, what will this varchar column lenght become: zero or max-column-lenght? Secondly, what is the best way to keep unpopulated varchar columns zero lenght during insert process? Thanks Carlton _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...]
7106 49 18_Re: DB2 monitoring12_Jim Fletcher19_jfletch3@US.IBM.COM30_Fri, 2 Mar 2001 14:22:26 -0500454_us-ascii You might try experimenting with the GET SNAPSHOT FOR DYNAMIC SQL ON dbname command, if you are running V6 or later. My testing has shown the output to be unreliable though, with some statements showing CPU usage but no executions, very high number of compilations immediately after resetting monitor data in a test environment with no users, etc. This would be a powerful tool for identifying problem statements if it could be counted on. [...]
7156 79 30_Re: Latin and the modern world12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Fri, 2 Mar 2001 11:21:54 -0800323_iso-8859-1 You're the only one who noticed. Or at least mentioned it. Maybe nobody else really knows Latin, only pretending. :-)
Re: shaking ground. We didn't even feel it. But at least Gates & Co. gets to experience it as well. And you realize that a sizeable earthquake in Buffalo is only a question of time. [...]
7236 36 7_Re test12_abanis nayak16_abanis@LYCOS.COM30_Fri, 2 Mar 2001 11:21:42 -080020_us-ascii test ignore
7273 94 40_Re: DSN1COPY Full Imagecopy to Flat File12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA30_Fri, 2 Mar 2001 14:42:21 -0500959_iso-8859-1 Did you try just copying it with IEBGENER (or FASTGENR) instead?
//********************************************************************* //* D E L E T E S C R A T C H D A T A S E T S * //********************************************************************* //* //DDDSN EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSIN DD * DELETE DB.FLAT.FILE NONVSAM SCRATCH /* //* //********************************************************************** //* C O P Y D A T A S E T S //********************************************************************** //* //GENER1 EXEC PGM=FASTGENR,REGION=4M //SYSUT1 DD DSN=DB.BACKUP.BKVLT.S5ASSES.F01(0),DISP=SHR //SYSUT2 DD DSN=DB.FLAT.FILE, // DISP=(NEW,CATLG,CATLG), // SPACE=(CYL,(100,100),RLSE), // UNIT=SYSDA,VOL=(,,,5), // DCB=(DB.PR#1.DTGMTP#1.DSCB.BACKUP) //SYSPRINT DD SYSOUT=* //SYSIN DD DUMMY //* //GENER2 EXEC PGM=FASTGENR,REGION=4M //SYSUT1 DD DSN=DB.BACKUP.BKVLT.S5ASSES.F02(0),DISP=SHR //SYSUT2 DD [...]
7368 37 19_Re: V6 Migration...12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 2 Mar 2001 14:03:00 -0500403_- 1. Fallbacks and all Hipers up to 0011, no problems so far. 2. It is working out to be about a month in each environment. Dev, QA not in Prod yet. 3. No. Just make sure you have removed all of the incompatible objects (run job DSNTIJPM). And, review space for temp DSNs. We didn't have this problem with V6 but with V5 in our small test DB2s we ran out of space in the TEMP DSNs during CATMAINT. [...]
7406 19 11_UDB backups14_Toppins, Smike21_smike.toppins@GWL.COM30_Fri, 2 Mar 2001 13:10:05 -0700436_- Is it possible (via DB2 Connect or some other tool) to run an image copy and spool it off to a tape on OS/390?
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7426 38 21_Re: table last access20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 2 Mar 2001 15:17:00 -0500416_us-ascii One suggestion I could give is move those tablespaces to another bufferpool and then you could monitor bufferpool (DIS BUFFERPOOL(XX) LSTATS LIST....) to see if the tablespaces were ever accessed. You could even check the monitors to see how many I/Os were done on those bufferpool. Once your are sure that bufferpool had absolutely no activities for pre defined period you could stop the tablespaces. [...]
7465 55 18_DSN1COPY Help.....15_Amy C Whitehead14_B06ACW@FDS.COM30_Fri, 2 Mar 2001 15:48:29 -0500654_us-ascii Hi, A user deleted data from a table. They need for a second table to be created and to DSN1COPY the original data into the new table. The imagecopy that I am using is a Platinum Fullcopy with Shrlevel Reference. The tablespace is large with 15 partitions. I get the following error message when I try to access the table: DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C2010D, TYPE OF RESOURCE 00000220, AND RESOURCE NAME ANTBUY.DSNDBC.DBACWSTR.BUYTRIG.I0- 001.A001 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD [...]
7521 72 22_Re: DSN1COPY Help.....15_Murley, Michael22_Michael_Murley@BMC.COM30_Fri, 2 Mar 2001 14:55:06 -0600672_iso-8859-1 Amy,
Specify RESET on the DSN1COPY parm.
Michael Murley BMC
-----Original Message----- From: Amy C Whitehead [mailto:B06ACW@FDS.COM] Sent: Friday, March 02, 2001 2:48 PM To: DB2-L@RYCI.COM Subject: DSN1COPY Help.....
Hi, A user deleted data from a table. They need for a second table to be created and to DSN1COPY the original data into the new table. The imagecopy that I am using is a Platinum Fullcopy with Shrlevel Reference. The tablespace is large with 15 partitions. I get the following error message when I try to access the table: DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE [...]
7594 78 22_Re: DSN1COPY Help.....16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Fri, 2 Mar 2001 15:58:27 -0500459_iso-8859-1 Amy, Try a repair like: REPAIR LEVELID TABLESPACE DBACWSTR.BUYTRIG
You might need to do 15 of them like: REPAIR LEVELID TABLESPACE DBACWSTR.BUYTRIG PART 1 .... REPAIR LEVELID TABLESPACE DBACWSTR.BUYTRIG PART 15 regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Amy C Whitehead [mailto:B06ACW@FDS.COM] Sent: Friday, March 02, 2001 3:48 PM To: DB2-L@RYCI.COM Subject: DSN1COPY Help..... [...]
7673 12 22_Re: DSN1COPY Help.....15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM30_Fri, 2 Mar 2001 14:52:09 -0600281_us-ascii Run the utility REPAIR LEVELID
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
7686 73 22_Re: DSN1COPY Help.....12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA30_Fri, 2 Mar 2001 16:02:07 -0500574_- Run a REPAIR LEVELID on the tablespace.
Thanks,, Fred De Luca 946-3999
> ---------- > From: Amy C Whitehead[SMTP:B06ACW@FDS.COM] > Reply To: DB2 Data Base Discussion List > Sent: Friday, March 02, 2001 3:48PM > To: DB2-L@RYCI.COM > Subject: DSN1COPY Help..... > > Hi, > A user deleted data from a table. They need for a second table to be > created and to DSN1COPY the original data into the new table. The > imagecopy > that I am using is a Platinum Fullcopy with Shrlevel Reference. The > tablespace is large with 15 partitions. > I get the following [...]
7760 91 18_DSN1COPY Help.....15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Fri, 2 Mar 2001 15:01:46 -0600552_us-ascii Amy,
Instead of DSN1COPY you would have unloaded from source table and loaded into target. Even I had similar situation but I had time to unload from source and load into target one.
check this file : ANTBUY.DSNDBC.DBACWSTR.BUYTRIG.I0001.A001 might have migrated.
Regards Nayeem
---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 03/02/2001 02:53 PM ---------------------------
Amy C Whitehead on 03/02/2001 02:48:29 PM [...]
7852 81 18_DSN1COPY Help.....15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Fri, 2 Mar 2001 15:09:04 -0600782_us-ascii Amy,
Have you checked the status of DB, increase indexspace & rebuild indexes again.
Regards Nayeem
---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 03/02/2001 03:02 PM ---------------------------
Amy C Whitehead on 03/02/2001 02:48:29 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)
Subject: DSN1COPY Help.....
Hi, A user deleted data from a table. They need for a second table to be created and to DSN1COPY the original data into the new table. The imagecopy that I am using is a Platinum Fullcopy with Shrlevel Reference. The tablespace is large with 15 partitions. I [...]
7934 74 22_Re: DSN1COPY Help.....16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Fri, 2 Mar 2001 16:09:22 -0500696_us-ascii level id - u have to reset/obidxlat reset
Amy C Whitehead on 03/02/2001 03:48:29 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: DSN1COPY Help.....
Hi, A user deleted data from a table. They need for a second table to be created and to DSN1COPY the original data into the new table. The imagecopy that I am using is a Platinum Fullcopy with Shrlevel Reference. The tablespace is large with 15 partitions. I get the following error message when I try to access the table: DSNT408I SQLCODE = -904, ERROR: [...]
8009 41 23_Recovery Ends With RC=812_John Bucaria22_jbucaria@MAIL2.PCH.COM30_Fri, 2 Mar 2001 16:28:55 -0500620_US-ASCII Hello Folks,
I recently attempted a recovery of a DB2 V5 - 20 partition tablespace and its indexes (a nonunique partitioning and a unique non-partitioning) which ended with RC=8. I was running 5 jobs concurrently with each job attempting to recover 4 partitions. After each job successfully loaded a single data partition, they all terminated with RC=8 due to duplicate key errors (DSNU340I % DSNURBXC - ERROR LOADING INDEX, DUPLICATE KEY) on the build of the unique index (nonpartitioning). The successful solution to the problem was to rerun the jobs without a rebuild of the NPI, but with just a [...]
8051 124 47_HELP! How to reduce bufferpool size at startup?10_Bill Disch23_bill.disch@GENMILLS.COM30_Fri, 2 Mar 2001 15:54:20 -0600286_- 1) I mistyped some digits in an ALTER BUFFERPOOL statement. 2) DB2 abended about 30 minutes later. 3) DB2 will not start with following error 4) Doc says to issue ALTER BUFFERPOOL to reduce size 5) We are DB2 V5 OS/'390 V1R2
Any ideas how to start DB2 and get BP resized? [...]
8176 24 61_Unqualified table names in Power Builder using DB2 Connect v722_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM30_Fri, 2 Mar 2001 13:55:48 -0800598_iso-8859-1 Hello , I would like to know how we can use unqualified table names in powerbuilder (V7.0) using DB2 Connect (v7) to access DB2 (v6) on OS390. I have played with CURRENTSQLID to set it to the schema owner, but initially developers received -725 (improper SET value). I created the schema owner as a RACF group and included developers in it and it works, BUT...now the developers (since they part of the Owner RACF group) are able to DROP the object using dynamic DROP SQL statements. Has anybody experienced the same problem and solved the unnecessary authorization problem? Thanks [...]
8201 58 53_Re: Am I asking to much of my structure change tool ?14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Fri, 2 Mar 2001 16:13:26 -0600369_iso-8859-1 Phil:
I would say that you are NOT asking too much of the change tools, but that the change tools are delivering too little! Oh well, I guess those of us who are used to the mainframe caliber solutions will have to keep a keen eye about us and troubleshoot the "change stuff" created by Fisher-Price solutions... of course, I'm quite biased. [...]
8260 84 65_Re: Unqualified table names in Power Builder using DB2 Connect v70_19_Tim.Lowe@STPAUL.COM30_Fri, 2 Mar 2001 16:39:32 -0600604_us-ascii Ramesh, You might want to setup SYNONYMs on the table that you are want to get to. Then, grant the table authorities to an authid that the application then uses.
There are a lot of different naming conventions, and this can become a long discussion about the interrelated subjects. (synonyms, authorities and dynamic sql) For example, if the application was called AA, then you might grant select, insert, delete, update to AAPGM, setup SYNONYMS on the AA tables from AAPGM, and then the application uses AAPGM to access the table. But, if AAPGM is a secondary authid, then there is [...]
8345 69 22_Re: DSN1COPY Help.....16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Fri, 2 Mar 2001 15:46:20 -0700655_iso-8859-1 It looks like you forgot to say RESET on your DSN1COPY parms.
Duane
-----Original Message----- From: Amy C Whitehead [mailto:B06ACW@FDS.COM] Sent: Friday, March 02, 2001 1:48 PM To: DB2-L@RYCI.COM Subject: DSN1COPY Help.....
Hi, A user deleted data from a table. They need for a second table to be created and to DSN1COPY the original data into the new table. The imagecopy that I am using is a Platinum Fullcopy with Shrlevel Reference. The tablespace is large with 15 partitions. I get the following error message when I try to access the table: DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED [...]
8415 59 21_Re: table last access17_Belfield, Alma G.21_Alma.Belfield@TWA.COM30_Fri, 2 Mar 2001 16:45:59 -0600441_iso-8859-1 I've used this tactic and it works really well if you capture DB2 ACCTG trace - you get stats for each separate bufferpool used by the thread. You can tell exactly which user/job/plan etc accessed the tablespaces/indexes. (Not sure if anyone already mentioned that you need to monitor the indexes as well.) Also look for non-DB2 access to those datasets (e.g. vendor fast unloads) by checking the SMF 'dataset open' records. [...]
8475 58 65_Re: Unqualified table names in Power Builder using DB2 Connect v711_Suresh Sane21_data_arch@HOTMAIL.COM30_Fri, 2 Mar 2001 17:04:05 -0600411_- Bala,
This is not an easy problem when dynamic sql is involved. My opinion is that any attempt to handle it completely in DB2 is undesirable/impossible.
The best approach I have seen is one used by PeopleSoft. Essentially, the userid is validated against an application security table. If authorized, a second connect is issued with a "common" id. This gets the security mostly out of DB2. [...]
8534 65 51_Re: HELP! How to reduce bufferpool size at startup?17_Belfield, Alma G.21_Alma.Belfield@TWA.COM30_Fri, 2 Mar 2001 17:15:48 -0600591_iso-8859-1 I believe the bufferpool sizes are stored in the BSDS. And I believe that the ZPARM values are used when the BSDS doesn't contain the relevant records e.g. when you first create a brand new DB2 subsystem.
So you could create a new BSDS from scratch, using DSNJU003(change log inventory) to reproduce the info from your current BSDS w.r.t active logs, archive logs, DDF ports etc. based on the DSNJU004 (print log map) report. Then START DB2 with this new BSDS, then issue ALTER Bufferpool commands to get things back to the right sizes (I hope you remember what sizes [...]
8600 44 17_Re: db2 migration16_Gabrielle Friebe21_gfriebe@ATTGLOBAL.NET30_Sat, 3 Mar 2001 08:40:32 +0930434_iso-8859-1 Hi Richard
I can recommend Nortons GHOST software. You build one image and then can replicate this across your network if you have the network software. Fast and efficient from my experience.
regards Gabi
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Richard Yan Sent: Saturday, March 03, 2001 4:02 AM To: DB2-L@RYCI.COM Subject: db2 migration [...]
8645 78 51_FW: HELP! How to reduce bufferpool size at startup?17_Belfield, Alma G.21_Alma.Belfield@TWA.COM30_Fri, 2 Mar 2001 17:29:26 -0600460_iso-8859-1 I just remembered where I read about this...... Diagnosis Guide and Reference has a section titled 'Analyzing BSDS Dumps' which shows you the exact layout of the ONE record that contains the repeating group of info for each of the bufferpools.
-----Original Message----- From: Belfield, Alma G. Sent: Friday, March 02, 2001 5:16 PM To: 'DB2 Data Base Discussion List' Subject: RE: HELP! How to reduce bufferpool size at startup? [...]
8724 39 51_Re: HELP! How to reduce bufferpool size at startup?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 2 Mar 2001 16:57:00 -0500466_- Shots in the dark: --Bring down something else on your system to free up memory. --Change Zparms to reduce memory used by EDMPOOL, DSMAX, SORTPOOL, User Connect parms etc.
>>> DB2-L@RYCI.COM@inter2 03/02/01 03:54PM >>> 1) I mistyped some digits in an ALTER BUFFERPOOL statement. 2) DB2 abended about 30 minutes later. 3) DB2 will not start with following error 4) Doc says to issue ALTER BUFFERPOOL to reduce size 5) We are DB2 V5 OS/'390 V1R2 [...]
8764 118 55_Re: FW: HELP! How to reduce bufferpool size at startup?10_Bill Disch23_bill.disch@GENMILLS.COM30_Fri, 2 Mar 2001 18:27:29 -0600338_iso-8859-1 You're on the right track. Here is how I solved the problem.
Open a severity 1 problem with IBM since this is our production SAP R/2 subsystem. They transferred me immediately to a technician.
1) First option was to repro BSDS to sequential file, edit the value for BP0 VP, repro back to BSDS and start DB2. [...]
8883 40 12_DSSIZE Error0_20_bjnigh@HOUSEHOLD.COM30_Fri, 2 Mar 2001 16:25:44 -0800471_us-ascii After migrating to DB2 OS/390 Version 6, we created a partitioned tablespace with 64 parts using CREATE TABLESPACE ... DSSIZE 64 G. We used the IBM load utility to populate one of the partitions but ran into a problem with secondary allocation quantity being given in allocations of 2 cylinders and the load abended due to too many extents. After applying PQ36667 to fix the 2 cylinder allocation problem, the load is now abending with the following error: [...]
8924 49 20_Re: VARCHAR question14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Sat, 3 Mar 2001 18:10:06 +1100301_iso-8859-1 Carlton,
1) The length of the DB2 varchar will be the length of the host variable. - if the host variable is, say, PIC X(10), the varchar's length will be 10 - if the host variable is, say, 49 LEN PIC 9(4) COMP 49 DATA PIC X(??) the varchar's length will be whatever is in LEN. [...]
8974 13 40_Question About Control Center for OS/39014_Philip Gunning26_philip_gunning@HOTMAIL.COM30_Sat, 3 Mar 2001 11:57:58 -0500
8988 55 15_Re: WLM and DB218_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU30_Sun, 4 Mar 2001 18:17:36 -0600568_- Howzit Mike?
The following references may be of some use:
Redbook Getting Started with DB2 Stored Procedures (SG24-4693) for information to configure WLM and RSS to support DB2 stored procedures
For info on RSS: http://www.ibm.com/software/data/db2/os390/cc390/RRS.htm
For info on WLM: http://www.ibm.com/software/data/db2/os390/cc390/WLMIntro.htm
Altho' this is "Control Centre" centric it does have relevant information regarding the OS/390 environment: http://www-4.ibm.com/software/data/db2/os390/cc390/Minimumhwswreq.htm [...]
9044 17 54_Paul Packham/ITS/POSG/POSTOFFICE is out of the office.0_29_paul.packham@POSTOFFICE.CO.UK30_Mon, 5 Mar 2001 01:10:10 +0000449_us-ascii I will be out of the office from 05/03/2001 until 12/03/2001.
I will respond to your mail when I return, however please contact Neil Miller or Steve Humberstone if urgent.
Regards Paul
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9062 30 21_Changing primary keys15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Mon, 5 Mar 2001 12:18:28 +1100431_- Colleagues,
A quick question on DB2 for OS/390 V6. I'm changing the primary key of a table to add another column. I know I need a unique index on all the columns for this to ultimately work. I thought I'd drop the PK, create it how I want (marking the table definition as incomplete, as there's not currently a unique index on all the columns) and then drop and recreate the index on it to include the new PK column. [...]
9093 103 9_Rollbacks13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU30_Mon, 5 Mar 2001 12:23:54 +1100603_iso-8859-1 All,
DB2 OS/390 V6.
We have a production system that upon initial investigation seems to have a high number of rollbacks. A portion of the DB2PM report can be found below. There were 62940 rollbacks in 8 hours i.e. 131 per minute. The rollbacks are getting issued by CICS online programs. This application is a Coolgen generated system that mostly uses an exit state of rollback as opposed to normal. What this means is that any transaction that fails issues a DB2 rollback, even the read only transactions. All of these rollbacks are satisfied by either the buffer or the [...]
9197 75 54_Latin Phrases for every day use!- In a DBA environment16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM30_Sun, 4 Mar 2001 20:31:13 -0500334_us-ascii Continuing the discussion of very important latin phrases and their uses in our modern day I give you the following! PAX1
Handy Latin Phrases Non calor sed umor est qui nobis incommodat. It's not the heat, it's the humidity.
Di! Ecce hora! Uxor mea me necabit! God, look at the time! My wife will kill me! [...]
9273 74 43_Re: Question about Control Center for OS39018_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU30_Sun, 4 Mar 2001 19:59:42 -0600675_- Howzit Jeff?
DSNACCMD, DSNACCQC, DSNACCMG and DSNACCAV are packaged with FMID JDB551D (JDB661D for DB2 V6.1).
DSNWZP and DSNUTILS are packaged with DB2.
Check the Database Server for OS/390 390 Enablement Program Directory for additional information.
Cheers Bruce
On Fri, 2 Mar 2001 09:25:00 -0600, Jeff Faughn wrote:
>They are created by the install CLIST when the SAMPLIB dataset is >created... : ) > > > > Jose' Gomez > ENDYS.COM> cc: > Sent by: DB2 Subject: Question about Control Center for > Data Base OS390 > Discussion > List > OM> > [...]
9348 49 25_Re: Changing primary keys14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Mon, 5 Mar 2001 13:18:32 +1100657_iso-8859-1 Thought it was always that way. Was certainly so in V3, although the line in the manual is marked as a change.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Monday, 5 March 2001 12:18 To: DB2-L@RYCI.COM Subject: [DB2-L] Changing primary keys
Colleagues,
A quick question on DB2 for OS/390 V6. I'm changing the primary key of a table to add another column. I know I need a unique index on all the columns for this to ultimately work. I thought I'd drop the PK, create it how I want (marking the [...]
9398 62 33_FW: [DB2-L] Changing primary keys14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Mon, 5 Mar 2001 13:27:00 +1100420_iso-8859-1 Just found a V2.2 manual. Same requirement.
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: James Campbell Sent: Monday, 5 March 2001 13:19 To: 'DB2 Data Base Discussion List' Subject: RE: [DB2-L] Changing primary keys
Thought it was always that way. Was certainly so in V3, although the line in the manual is marked as a change. [...]
9461 87 25_Re: Changing primary keys15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Mon, 5 Mar 2001 13:45:29 +1100315_- Found it. You're right, James. The behaviour I (kind of) described occurs when you're creating the table for the first time. If you alter an existing table to add a primary key, the supporting index must already exist.
Thanks for the info. Looks like you can still sometimes be right after all... ;o) [...]
9549 141 13_Re: Rollbacks16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Mon, 5 Mar 2001 10:44:01 +0530384_iso-8859-1 I believe IBM people are best to reply because this leads to the marginal (over)loads. Still as per my opinion, if there are anything extra which is not required then we should not use that because "there nothing is to be rollbacked is to be checked by the system" and that might take some time. You can also try removing the rollback and then compare the difference. [...]
9691 19 18_Return Code on CAF12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Mon, 5 Mar 2001 06:50:18 -0600528_iso-8859-1 We suddenly have started to get a return code 8 on CAF. Does anyone have experience with this? The example code checks for 8, but we must be looking in the wrong place in the documentation because we are not finding it.
Gerald Hodge HLS Technologies, Inc. 888-494-9019
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9711 91 58_Re: Latin Phrases for every day use!- In a DBA environment15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 5 Mar 2001 07:04:17 -0600464_iso-8859-1 -----Original Message----- From: Thomas E. Faglon [mailto:tfaglon@TELCORDIA.COM] Sent: Sunday, March 04, 2001 7:31 PM To: DB2-L@RYCI.COM Subject: Latin Phrases for every day use!- In a DBA environment
Continuing the discussion of very important latin phrases and their uses in our modern day I give you the following! PAX1
Handy Latin Phrases Non calor sed umor est qui nobis incommodat. It's not the heat, it's the humidity. [...]
9803 20 55_Re: FW: HELP! How to reduce bufferpool size at startup?14_Harvey Puckett25_HPUCKETT@DOAS.STATE.GA.US30_Mon, 5 Mar 2001 08:18:45 -0500314_US-ASCII What do you set region size to in your DBM1 address space? Since the requested BP0 VPSIZE/HPSIZE is quite reasonable (2000/4000), I suspect your REGION=4M or less.
If so, talk with your OS/390 guy and see if you can use REGION=0M on your DBM1 (or something greater than what it is currently). [...]
9824 101 53_Re: Am I asking to much of my structure change tool ?14_Grainger, Phil20_Phil.Grainger@CA.COM30_Mon, 5 Mar 2001 13:28:23 -0000585_iso-8859-1 I think that this also is a good example of the robustness and functionally rich status of the DB2 tools from the 'traditional' vendors (BMC and PLATINUM/CA. Those of us that have 'been around' tend to know the strange things that users want to do to their databases!!
To be fair to the rest, it really is asking a lot for them to do everything first off, hence the usual phased approach, BUT there is never an excuse for allowing a change that invalidates the structure of the database. In Phil Nelsons example, a 'better' (though less complete) solution would [...]
9926 49 21_Re: table last access14_Grainger, Phil20_Phil.Grainger@CA.COM30_Mon, 5 Mar 2001 13:28:26 -0000458_iso-8859-1 I haven't looked in a while, but doesn't VSAM update the last opened/closed dates/times in the ICF catalog definitions of the tablespaces/indexspaces these days??
I can't check what these fields are actually called as I am temporarily disconnected form the mainframe world!
Phil Grainger Computer Associates 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 [...]
9976 17 58_Re: Latin Phrases for every day use!- In a DBA environment10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 5 Mar 2001 14:30:17 +0100339_us-ascii ................. and ....................
Max Scarpa DB2 Sysprog
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
9994 44 22_AW: Return Code on CAF16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE30_Mon, 5 Mar 2001 14:36:07 +0100638_iso-8859-1 Add a DD-Statement to trace the CAF calls
//DSNTRACE DD SYSOUT=*
Roland
> -----Ursprüngliche Nachricht----- > Von: Gerald Hodge [SMTP:ghodge@ATTGLOBAL.NET] > Gesendet am: Montag, 5. März 2001 13:50 > An: DB2-L@RYCI.COM > Betreff: Return Code on CAF > > We suddenly have started to get a return code 8 on CAF. Does anyone have > experience with this? The example code checks for 8, but we must be > looking > in the wrong place in the documentation because we are not finding it. > > Gerald Hodge > HLS Technologies, Inc. > 888-494-9019 > > ================================================ > To change [...]
10039 34 22_Re: Return Code on CAF20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 5 Mar 2001 08:42:57 -0500561_us-ascii What is the reason code? How does the messages on DD DSNACAF (CAF trace) looks ?
> -----Original Message----- > From: Gerald Hodge [SMTP:ghodge@ATTGLOBAL.NET] > Sent: Monday, March 05, 2001 7:50 AM > To: DB2-L@RYCI.COM > Subject: Return Code on CAF > > We suddenly have started to get a return code 8 on CAF. Does anyone have > experience with this? The example code checks for 8, but we must be > looking > in the wrong place in the documentation because we are not finding it. > > Gerald Hodge > HLS Technologies, Inc. > 888-494-9019 > > [...]
10074 76 65_Re: Unqualified table names in Power Builder using DB2 Connect v716_Michael McKinney16_mmckinne@CSC.COM30_Mon, 5 Mar 2001 08:42:43 -0500371_us-ascii Ramesh,
I am going through the same scenario right now. We are Implementing DB2 Connect (v7), Powerbulder (v7), and DB2 v6 for OS/390. We tried many different scenarios, tested the Set Current SQLID as you did. In the end we decided to create one Common ID and create and Alias on all necessary DB2 (those accessed by Powerbuilder code) for that ID. [...]
10151 18 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM30_Mon, 5 Mar 2001 08:03:54 -0600476_us-ascii I will be out of the office starting 03/05/2001 and will not return until 03/06/2001.
I will respond to your message when I return. If you require immediate attention, please contact Dona Bell at x2822.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10170 28 41_Quest Central for DB2 now Supports OS/39013_Jim Wankowski23_jim.wankowski@QUEST.COM30_Mon, 5 Mar 2001 08:07:46 -0600350_- Quest Software is glad to announce the availability of Quest Central for DB2 V1.1 for beta download. This release offers support of DB2 OS/390 from the main console and SQL tuning components. You now have the ability to browse objects, run queries, and use the SQL tuning lab for both the OS/390 and UNIX/NT platforms from one common console. [...]
10199 81 30_Inserting DB2 Data into Oracle13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Mon, 5 Mar 2001 09:50:07 -0500307_ISO-8859-7 Hi all,
We are installing Oracle for the first time. The Oracle version is 8i.
We are storing data in DB2 UDB OS/390 V6. We are installing Oracle database and Oracle Apps on a Sun Solaris box. We need to download new data from DB2 and insert it into Oracle on a nightly basis. [...]
10281 18 29_Re: Latin and other languages0_26_truman.g.brown@VERIZON.COM30_Mon, 5 Mar 2001 10:11:35 -0500409_us-ascii I prefer loose translations:
Sic transit Gloria (Latin: Gloria went home sick)
Je ne cest pas (French: I don't know my own father)
George
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10300 73 16_Re: DSSIZE Error0_19_Tim.Lowe@STPAUL.COM30_Mon, 5 Mar 2001 09:11:42 -0600722_us-ascii See PQ38466.
bjnigh@HOUSEH OLD.COM To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: DSSIZE Error Discussion List
03/02/2001 06:25 PM Please respond to DB2 Data Base Discussion List
After migrating to DB2 OS/390 Version 6, we created a partitioned tablespace with 64 parts using CREATE TABLESPACE ... DSSIZE 64 G. We used the IBM load utility to populate one of the partitions but ran into a problem with secondary allocation quantity being given in allocations of 2 cylinders and the load abended due to too many extents. After applying PQ36667 to fix the 2 cylinder allocation problem, the [...]
10374 14 34_Re: Inserting DB2 Data into Oracle10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 5 Mar 2001 16:13:49 +0100281_us-ascii Good luck !!
Max Scarpa
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10389 33 29_Re: Latin and other languages14_Shaul Bergfeld18_sbergfeld@TACT.COM30_Mon, 5 Mar 2001 10:30:58 -0500459_iso-8859-1 ...and speaking of "loose" things, did you know that "loose bits sink chips..." ???
-----Original Message----- From: truman.g.brown@VERIZON.COM [mailto:truman.g.brown@VERIZON.COM] Sent: Monday, March 05, 2001 10:12 AM To: DB2-L@RYCI.COM Subject: Re: Latin and other languages
I prefer loose translations:
Sic transit Gloria (Latin: Gloria went home sick)
Je ne cest pas (French: I don't know my own father) [...]
10423 18 29_Control center for DB2 OS/39016_Daniel Gillieron23_daniel.gillieron@AGI.CH30_Mon, 5 Mar 2001 16:37:26 +0100390_us-ascii Hi
I would like to know if it is necessary to install DB2 connect before using the control center for DB2 OS/390
Tanks Daniel
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10442 37 33_Re: Control center for DB2 OS/3909_Don Alden25_Don.Alden@I-STRUCTURE.COM30_Mon, 5 Mar 2001 09:05:55 -0700513_iso-8859-1 If you are using DB2 Version 6 DB2 Connect comes as a no-charge option. You
might check it out. It comes in the DB2 Management Tools Package.
Good Luck, Don Alden
-----Original Message----- From: Daniel Gillieron [mailto:daniel.gillieron@AGI.CH] Sent: Monday, March 05, 2001 8:37 AM To: DB2-L@RYCI.COM Subject: Control center for DB2 OS/390
Hi
I would like to know if it is necessary to install DB2 connect before using the control center for DB2 OS/390 [...]
10480 22 11_DB2 Connect27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Mon, 5 Mar 2001 11:14:37 -0500553_iso-8859-1 Does anyone have a web site for downloading fixpaks for DB2 Connect EE V7? We're ready to install it, but we want to make sure we have fixpak 2 and we're not sure what level is on the CD.
Thanks,
Tina Hilton Database Analyst Bertelsmann mediaSystems (317) 542-6891 Tina.Hilton@bmsus.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10503 49 29_Re: Latin and other languages12_Deluca, Fred27_Fred.Deluca@CCRA-ADRC.GC.CA30_Mon, 5 Mar 2001 11:41:47 -0500622_iso-8859-1 Actually, "Je ne cest pas" is not proper French. Maybe you meant to say, "Je ne sais pas" (I do not know).
In any case, "Je ne connais pas mon père" is the proper translation for "I don't know my father".
Fred De Luca DB2 Specialist CCRA
> ---------- > From: truman.g.brown@VERIZON.COM[SMTP:truman.g.brown@VERIZON.COM] > Reply To: DB2 Data Base Discussion List > Sent: Monday, March 05, 2001 10:11AM > To: DB2-L@RYCI.COM > Subject: Re: Latin and other languages > > I prefer loose translations: > > Sic transit Gloria (Latin: Gloria went home sick) > > Je ne cest pas (French: [...]
10553 44 15_Re: DB2 Connect14_Carroll, Ouida24_Ouida.Carroll@BCBSLA.COM30_Mon, 5 Mar 2001 10:43:07 -0600471_iso-8859-1 Here is the web site where the DB2 Connect fix packs are: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download .d2w/report
Ouida Carroll > Database Administration > Information Technology - Blue Cross of Louisiana > (225) 298-1469
-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Monday, March 05, 2001 10:15 AM To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 Connect [...]
10598 69 29_Re: Latin and other languages15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 5 Mar 2001 11:16:35 -0600419_iso-8859-1 I doubt very much that the Latin that has been fed to us so far is that accurate.
Linda
-----Original Message----- From: Deluca, Fred [mailto:Fred.Deluca@CCRA-ADRC.GC.CA] Sent: Monday, March 05, 2001 10:42 AM To: DB2-L@RYCI.COM Subject: Re: Latin and other languages
Actually, "Je ne cest pas" is not proper French. Maybe you meant to say, "Je ne sais pas" (I do not know). [...]
10668 20 18_Re: DB2 monitoring11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 11:22:41 -0600371_- Jim,
I also noticed snapshot for dynamic sql is not reliable. Sometime there's no execution time or cpu time. And since the snapshot pulls the information from statement cache which stores packages and statistics for frequently used SQL, so I doubt the snapshot can provide information for all the SQLs for a whole day (Usually 5 million SQLs in our shop). [...]
10689 66 18_Re: DB2 monitoring11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 11:22:42 -0600652_- On Fri, 2 Mar 2001 14:22:26 -0500, Jim Fletcher wrote:
>You might try experimenting with the GET SNAPSHOT FOR DYNAMIC SQL ON dbname >command, if you >are running V6 or later. My testing has shown the output to be unreliable >though, with some statements showing >CPU usage but no executions, very high number of compilations immediately >after resetting monitor data in a >test environment with no users, etc. This would be a powerful tool for >identifying problem statements if it could >be counted on. > >Richard Yan @RYCI.COM> on 03/02/2001 01:42:28 PM > >Please respond to DB2 Data Base [...]
10756 21 37_"SQL Solutions for a DBA's wish list"13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Mon, 5 Mar 2001 12:36:31 -0500282_- Hi Listers, Mr. Sane, I will like to get a copy of the May 2000 IDUG NA conference presentation titled "SQL Solutions for a DBA's wish List" by Suresh Sane. Could someone share with me a copy of the presentation? I do not yet have auth to get at it through the IDUG website. [...]
10778 115 58_Re: Latin Phrases for every day use!- In a DBA environment12_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 5 Mar 2001 19:36:49 +0200716_iso-8859-1 Either you know Latin or not - terzium non dator.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "Billings, Linda" Newsgroups: bit.listserv.db2-l To: Sent: Monday, March 05, 2001 3:04 PM Subject: Re: Latin Phrases for every day use!- In a DBA environment
> -----Original Message----- > From: Thomas E. Faglon [mailto:tfaglon@TELCORDIA.COM] > Sent: Sunday, March 04, 2001 7:31 PM > To: DB2-L@RYCI.COM > Subject: Latin Phrases for every day use!- In a DBA environment > > > Continuing the discussion of very important latin phrases and their uses in > our > modern [...]
10894 108 29_Re: Latin and other languages15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU30_Mon, 5 Mar 2001 12:47:00 -0500464_iso-8859-1 Hey - I have a dictionary here with some Latin in it(?!?) Well, maybe this falls under "Other" languages.
If You Do Not Understand Any of Them, Contact Your Closest Southern Bubba for an Explanation.....
Y'ALLBONICS/ENGLISH DICTIONARY
HEIDI - (noun) -Greeting.
HIRE YEW - Complete sentence. Remainder of greeting.
BARD - (verb) - Past tense of the infinitive "to borrow." usage "My brother bard my pickup truck." [...]
11003 124 19_Re: V6 Migration...12_Isaac Yassin20_yassini@BEZEQINT.NET30_Mon, 5 Mar 2001 19:46:31 +0200646_windows-1254 V6 Migration...1. No problems. 2. Two weeks 3. No.
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: Cuneyt Goksu (Garanti Teknoloji) Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, March 02, 2001 2:33 PM Subject: V6 Migration...
Hello List,
I have a couple of questions about V6 Migration.
1. Did you have any performance problems with V5 after applying Toleration/Fallback PTFs ? 2. How long did you wait with V5 + Toleraton PTFs Until V6 Migration ? 3. Did you have any problems with CATMAINT ? [...]
11128 128 29_Re: Latin and other languages14_Richard Yevich26_Richard_Yevich@YLASSOC.COM30_Mon, 5 Mar 2001 12:01:29 -0600626_iso-8859-1 What this thread reminds me of...
Logica defecta stercus tauri explorandus est!
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > McClendon, Rick > Sent: Monday, March 05, 2001 11:47 AM > To: DB2-L@RYCI.COM > Subject: Re: Latin and other languages > > > Hey - I have a dictionary here with some Latin in it(?!?) Well, maybe this > falls under "Other" languages. > > If You Do Not Understand Any of Them, Contact Your Closest Southern Bubba > for an Explanation..... > > Y'ALLBONICS/ENGLISH DICTIONARY > > HEIDI - (noun) -Greeting. > > [...]
11257 34 29_DB2 OS/390 V6 : SQL CODE -5310_25_Ed_Vetock@NAVYFEDERAL.ORG30_Mon, 5 Mar 2001 13:45:54 -0500420_us-ascii To all,
We're stumped. We've uncovered a probable error during updates of a table . We receive SQL -531. We understand what a -531 is but believe we should not be getting it. Let me exlain:
- Table A is parent table with a Primary Key on COLA - Table B is the child table. It has one index allowing duplicate values on COLA - The Referential Integrity is on COLA between Table A and Table B. [...]
11292 52 34_Re: Inserting DB2 Data into Oracle13_Olson, Carlos14_COlson@QRS.COM30_Mon, 5 Mar 2001 10:48:09 -0800435_iso-8859-7 There's a Redbook called 'My Mother Thinks I'm a DBA! Cross-Platform, Multi-Vendor, Distributed Relational Data Replication with IBM DB2 DataPropagator and IBM DataJoiner Made Easy!' It provides several case studies which may be similar to your scenario. Carlos Olson Database Administrator QRS Corporation 1400 Marina Way South Richmond, California 94804 email: colson@qrs.com http://www.qrs.com [...]
11345 22 32_DB2 and latin - an extrapolation10_Max Scarpa16_mscarpa@CESVE.IT30_Mon, 5 Mar 2001 18:08:54 +0100562_us-ascii I hope that the word 'sex ' would never appear in DB2-L..........then I think we'll see all sort of things and all sort of much
vaunted performance.......
Sorry list owners, I'll never do it again .....as I said some times ago....
Regards and enjoy latin......
Max Scarpa DB2 sysprog
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11368 27 14_CICS Deadlocks22_Ditchkus, Vincent, Jr.18_VDitchkus@FDIC.GOV30_Mon, 5 Mar 2001 13:57:30 -0500535_iso-8859-1 Lately, we've been experiencing a number of DB2 CICS transactions which are deadlocking with other transactions:
DSNT408I SQLCODE = -913, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C90088, TYPE OF RESOURCE 00000D01, AND RESOURCE NAME 00000308.00000255
As we step through the possible causes for the deadlocks, a question was raised which is: Is there anything significant about the fact that the Resource is **always** a DBID.OBID as opposed to a database.tablespace.page? [...]
11396 29 12_avg subquery13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM30_Mon, 5 Mar 2001 09:36:32 -0600389_us-ascii hi, we need to gather some information a table has the field ss_num which is a char(9) we need to find out the avg number of ss_num on the table. the avg function can only be performed numeric data
this query is invalid
SELECT AVG(SSCOUNT) FROM DB2TEST.CUSTOMER WHERE SS_NUM IN (SELECT COUNT(*) AS SSCOUNT,SS_NUM FROM DB2TEST.CUSTOMER GROUP BY SS_NUM) WITH UR; [...]
11426 55 29_Re: Latin and other languages14_subrata mondal25_subratamondal@HOTMAIL.COM30_Mon, 5 Mar 2001 19:24:17 -0000
11482 144 34_Re: Inserting DB2 Data into Oracle13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US30_Mon, 5 Mar 2001 14:45:08 -0500549_US-ASCII Thank you Carlos,
I will check into the Redbook.
Burge
>>> COlson@QRS.COM 03/05/01 01:48PM >>> There's a Redbook called 'My Mother Thinks I'm a DBA! Cross-Platform, Multi-Vendor, Distributed Relational Data Replication with IBM DB2 DataPropagator and IBM DataJoiner Made Easy!' It provides several case studies which may be similar to your scenario. Carlos Olson Database Administrator QRS Corporation 1400 Marina Way South Richmond, California 94804 email: colson@qrs.com http://www.qrs.com [...]
11627 52 16_Re: avg subquery12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 14:49:42 -0500555_US-ASCII I'm not sure what your doing. However, you need to use a table expression to get the results based on your query below:
SELECT AVG(STBL.sscount) FROM (SELECT ss_num, COUNT(*) AS sscount FROM db2test.customer GROUP BY ss_num) STBL WITH UR
Troy Coleman Coleman Consulting, Inc.
>>> ddlusk@HOUSEHOLD.COM 03/05/01 10:36AM >>> hi, we need to gather some information a table has the field ss_num which is a char(9) we need to find out the avg number of ss_num on the table. the avg function can only be performed numeric data [...]
11680 20 12_Image copies14_Toppins, Smike21_smike.toppins@GWL.COM30_Mon, 5 Mar 2001 13:06:28 -0700502_- Didn't get an answer last time so will re-phrase it. I've go some databases out on a AIX box that I'd like to image copy and store on 3480 tapes. Is it possible and if so, how?
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11701 29 45_Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Mon, 5 Mar 2001 12:29:47 -0800426_us-ascii Hello everybody, I have a query that should only get one meaningful row and is doing a SELECT DISTINCT for some strange reason.
In anycase, in general, if you only want to get one row, and your result set doesn't have to materialize, and all the rows in the result set are equal, is it faster to run a SELECT DISTINCT (on a small number of rows) or is it faster to simply open a cursor and fetch one row? [...]
11731 19 29_Re: Latin and other languages19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Mon, 5 Mar 2001 15:31:54 EST417_us-ascii I was beginning to think that the 'L' in 'DB2-L' stood for 'Latin'.
Regards,
Rajeev P. Dhanawade Phone: 302-577-4659 ext. 221 Fax : 302-577-4454
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
11751 63 15_Re: DB2 Connect27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Mon, 5 Mar 2001 15:44:06 -0500500_iso-8859-1 I see the fixpak for DB2/UDB, but not one for Connect. Or is it one of the clients? None of them sound like they would be for Connect.
TIA,
Tina
-----Original Message----- From: Carroll, Ouida [mailto:Ouida.Carroll@BCBSLA.COM] Sent: March 05, 2001 11:43 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
Here is the web site where the DB2 Connect fix packs are: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/download .d2w/report [...]
11815 51 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 15:55:10 -0500292_US-ASCII If you are expecting only one row then you are better off using a singleton select and handling the more than one row SQLCODE -811. Both cursor processing and sort processing is expensive. However, I alway try to avoid sorts as often as possible. If you must then use a cursor. [...]
11867 34 50_IBM TXSeries CICS to use DB2 as a resource manager11_Mike Fatula17_mfatula@PHEAA.ORG30_Mon, 5 Mar 2001 15:51:49 -0500384_us-ascii We are receiving some sql0918 with online transactions.
SQL0918N Application must execute a rollback.
Cause: The unit of work has already been rolled back in the database but other resource managers involved in this unit of work might not. To ensure integrity of this application, all SQL requests will be rejected until the application issues a rollback. [...]
11902 81 15_Re: DB2 Connect16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV30_Mon, 5 Mar 2001 14:21:09 -0700412_iso-8859-1 DB2 Connect's fixpak is included with the DB2 UDB fixpak. When you install the fixpak it will only install those items relating to the software you have installed, at least that is how it worked for me.
Duane
-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Monday, March 05, 2001 1:44 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect [...]
11984 23 19_db2 governor on AIX11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Mon, 5 Mar 2001 15:06:41 -0600548_- Hi List,
I'm looking for a way to prevent bad SQLs (in terms of cpu usage) from running on our production database. We're a little concerned about using DB2 governor for that purpose, since what the governor does is to limit the number of CPU seconds that can be consumed by an application instead of a SQL. The consequence of that is, Say, If one application has many simple queries, the total cost will eventually reach the CPU limit by the end of the day even though the cost of every single SQL is little. We want to capture only [...]
12008 64 49_Re: Select Distinct vs Open Cursor and Fetch Once10_Shery Hepp17_schepp@SRPNET.COM30_Mon, 5 Mar 2001 14:28:13 -0700456_iso-8859-1 Troy- I vaguely recall Roger Miller stating that this may work for now- but don't count on it always to work with future releases of DB2. Maybe if Roger is monitoring this thread he can jump in and clarify for all of us.
Regards, Shery
-----Original Message----- From: Troy Coleman [mailto:Colematr@MEIJER.COM] Sent: Monday, March 05, 2001 1:55 PM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once [...]
12073 68 16_Re: avg subquery0_24_db46@DAIMLERCHRYSLER.COM30_Mon, 5 Mar 2001 16:39:47 -0500481_us-ascii That's because it is in the subquery. If you have version 5 or higher try this:
SELECT AVG (T1.SSCOUNT) FROM (SELECT COUNT(*) AS SSCOUNT, SS_NUM FROM DB2TEST.CUSTOMER GROUP BY SS_NUM) AS T1 WITH UR;
Dean
"Derez D. Lusk" @RYCI.COM> on 03/05/2001 10:36:32 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
12142 48 23_Re: db2 governor on AIX19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Mon, 5 Mar 2001 21:46:24 +0000386_US-ASCII Richard,
Take a look at SQL-GUY from Database-GUYS Inc. (www.database-guys.com).
It allows you to very quickly spot the "bad" SQL. Maybe not prevent it from running, but certainly track bad SQL for tuning purposes.
Using it for a couple of months has had some impressive effects on our server.
HTH
Phil Nelson Senior DBA Scottish Widows [...]
12191 110 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 16:57:29 -0500521_US-ASCII Hi Shery, Yes I did hear Roger mention that for existence checks or just give me the first occurrence of a row then you may not get the data you are expecting. However, the question to ask is if you know you should only have one row then you should handle the error condition. If the business requirement is to report on this error then do so. If you must get valid data then you can perform a cursor to get one of the many rows. However, what is in the row when you have duplicates ??? The SELECT DISTINCT [...]
12302 22 22_Re: Return Code on CAF12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Mon, 5 Mar 2001 16:18:39 -0600313_us-ascii We identified the cause of the error. We run various level of DB2 for testing purposes. Hands got crossed and we executed the proc for one level on the another level of DB2. We still can not find the documentation for a return code 8.
Gerald Hodge HLS Technologies, Inc. 888-494-9019 [...]
12325 54 33_Re: DB2 OS/390 V6 : SQL CODE -53112_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM30_Mon, 5 Mar 2001 15:20:18 -0700449_- Ed
What RI do you have on Column D?
-----Original Message----- From: Ed_Vetock@NAVYFEDERAL.ORG [SMTP:Ed_Vetock@NAVYFEDERAL.ORG] Sent: Monday, 05 March, 2001 11:46 AM To: DB2-L@RYCI.COM Subject: DB2 OS/390 V6 : SQL CODE -531
To all,
We're stumped. We've uncovered a probable error during updates of a table . We receive SQL -531. We understand what a -531 is but believe we should not be getting it. Let me exlain: [...]
12380 116 49_Re: Select Distinct vs Open Cursor and Fetch Once10_Shery Hepp17_schepp@SRPNET.COM30_Mon, 5 Mar 2001 15:29:22 -0700379_iso-8859-1 Hi Troy- Glad my memory hasn't totally gone down the drain. And yes we both agree that a select distinct is expensive- especially if the app doesn't really care what is returned. However if the app is dependent on the result set a cursor may be the best way to go. And yes if IBM decides to close that loop hole it would be great if they let us know before hand. [...]
12497 25 67_What are the Requirements, Tips & Tricks for monitoring Dynamic SQL13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Mon, 5 Mar 2001 17:38:51 -0500531_- Hi DB2 Listers, We are about to begin a process to give a measure of quality assurance to a large set of "Dynamic" SQL statements( SQL fired from a powerbuilder application) by explaining and tunning. I don't even know if we have a problem with the SQLs the way there are now. Anyway, my question is: What needs to be in place to monitor Dynamic SQL? Are there any special tips and tricks specific to dynamic SQL? How can you go about measuring performance or any other kind of improvement? Any and all will be appreciated. [...]
12523 30 24_Performence Issue - Help16_Santha Narayanan25_santha@GWMAIL.STATE.NV.US30_Mon, 5 Mar 2001 14:32:34 -0800336_US-ASCII Hello Everybody,
I have a simple query and when i do a SQL EXPLAIN the ACCESSTYPE is 'R'. How do i make my sql to be Indexed. Alternate Index created on this Table (table1) is: Index Name Column Name ------------------ ------------------ IA00390A STS
SQL : select * from db25.table1 where sts in ('DB','EV') [...]
12554 173 13_Re: Rollbacks13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU30_Tue, 6 Mar 2001 09:57:33 +1100463_iso-8859-1 Thanks for the reply Sanjeev. I also believe that if the rollback is not needed it should not be performed, but unless I can provide some evidence that it is an overhead it won't be changed.
Are there other Coolgen sites that have a high number of rollbacks?
Shaun
-----Original Message----- From: S, Sanjeev (CTS) [mailto:SSanjeev@CAL.COGNIZANT.COM] Sent: Monday, 5 March 2001 16:14 To: DB2-L@RYCI.COM Subject: Re: Rollbacks [...]
12728 58 54_Re: IBM TXSeries CICS to use DB2 as a resource manager18_Gert van der Kooij15_geko@WANADOO.NL30_Mon, 5 Mar 2001 23:55:24 +0100323_iso-8859-1 Hi,
(Assuming you are running on Unix or NT ) If you have your CICS queues managed in DB2 you can run the XA interface in One Phase Commit. Check the cicsdb2conf command for the right option or define it using the TXSeries Administration Tool. If you're running on OS/390 Im afraid I can't help you. [...]
12787 115 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 5 Mar 2001 17:18:49 -0600480_us-ascii Troy/Shery/Chris,
It is explicitly coded in the DB2 manuals that when more than one row qualifies from a singleton select, then the retrieved result is unpredictable and cannot be relied upon. This is not a recent addition to the manual....therefore IBM has already told DB2 users not to use this "feature". I liked one of Roger's quotes so much, that I have forgotten it....it was something about "we can't tell people not to stick something in their ears". [...]
12903 69 28_Re: Performence Issue - Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Mon, 5 Mar 2001 17:36:05 -0600295_us-ascii Santha,
There are a number of techniques, such as using OPTIMIZE FOR n ROWS, or ORDER BY STS, or fiddling the catalog stats. I am not a fan of any of those techniques, unless the OPTIMIZE clause states the required number of rows required by the program (and not simply 1). [...]
12973 158 49_Re: Select Distinct vs Open Cursor and Fetch Once12_Troy Coleman19_Colematr@MEIJER.COM30_Mon, 5 Mar 2001 18:38:42 -0500632_US-ASCII Thanks Terry, I had forgot about the Fetch For 1 Row. Maybe they "IBM" know not to setup a CURSOR and invoke the extra API calls with this option.
Troy Coleman
Coleman Consulting, Inc.
>>> Terry_Purcell@YLASSOC.COM 03/05/01 06:18PM >>> Troy/Shery/Chris,
It is explicitly coded in the DB2 manuals that when more than one row qualifies from a singleton select, then the retrieved result is unpredictable and cannot be relied upon. This is not a recent addition to the manual....therefore IBM has already told DB2 users not to use this "feature". I liked one of Roger's quotes so much, that I [...]
13132 87 28_Re: Performence Issue - Help16_Santha Narayanan25_santha@GWMAIL.STATE.NV.US30_Mon, 5 Mar 2001 16:00:50 -0800380_US-ASCII Thanks, Terry
>>> Terry Purcell 03/05 3:36 PM >>> Santha,
There are a number of techniques, such as using OPTIMIZE FOR n ROWS, or ORDER BY STS, or fiddling the catalog stats. I am not a fan of any of those techniques, unless the OPTIMIZE clause states the required number of rows required by the program (and not simply 1). [...]
13220 15 49_Alfonso Alonso/Production/Unicible est absent(e).14_Alfonso Alonso26_alfonso.alonso@UNICIBLE.CH30_Tue, 6 Mar 2001 01:00:29 +0100343_iso-8859-1 Je serai absent(e) du 03/05/2001 au 03/09/2001.
Je répondrai à votre message dès mon retour. ===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13236 194 49_Re: Select Distinct vs Open Cursor and Fetch Once14_Richard Yevich17_ryevich@YAHOO.COM30_Mon, 5 Mar 2001 16:32:04 -0800393_us-ascii All,
(1) When you get a -811, the results of the singleton query cannot be depended upon. It has been this way since 1.1, and will not change since it is a negative return code, and by definition, you can never depend on the results being accurate when there is a negative SQLCODE. IBM has stated many times, that it will not change the meaning of a negative return code. [...]
13431 17 18_CCA Config Problem15_Benjamin Reches24_Benjamin.Reches@MSDW.COM30_Mon, 5 Mar 2001 19:46:53 -0500489_us-ascii What configuration parameter can you specify with a CUSTOM install of DB2 7.1 that would cause the "3.Protocol" tab NOT to display the checkbox on the bottom regarding 'host or AS400 machines', even after selecting radio-button 'TCP/IP'??
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
13449 129 29_Re: Latin and other languages11_Robert Jans26_robert_jans@ALBERTSONS.COM30_Mon, 5 Mar 2001 13:22:38 -0700495_iso-8859-1 Well, I say this crosses the line of any taste......... Isn't it time this thread dies????
Robert Jans Albertsons, Inc.
-----Original Message----- From: McClendon, Rick [mailto:RMcClendon@ADMIN.FSU.EDU] Sent: Monday, March 05, 2001 10:47 AM To: DB2-L@RYCI.COM Subject: Re: Latin and other languages
Hey - I have a dictionary here with some Latin in it(?!?) Well, maybe this falls under "Other" languages. [...]
13579 45 15_Re: UDB backups14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Mon, 5 Mar 2001 18:58:35 -0600658_iso-8859-1 Hi,
We run our backups to disk, and then use ADSM to copy this to tape (VTS really) on OS/390. I think with the right vendor software you can do this directly in the backup, but don't quote me!
Regards,
Greg Palgrave Database Administrator Unisys WEST eMail : greg.palgrave@unisyswest.com.au
> -----Original Message----- > From: DB2 Data Base Discussion List @BANKWEST On > Behalf Of "Toppins, Smike" @BANKWEST > Sent: Saturday, 3 March 2001 04:10 > To: DB2-L@RYCI.COM > Subject: UDB backups > > Is it possible (via DB2 Connect or some other tool) to run an image copy > and [...]
13625 46 41_Re: "SQL Solutions for a DBA's wish list"11_Suresh Sane21_data_arch@HOTMAIL.COM30_Mon, 5 Mar 2001 20:48:40 -0600665_- Carlton - you can download it from my website:
www.database-architects-inc.com
If you any trouble, send me an email offline and I will send you a ppt.
Thanks for your interest.
Suresh
>From: Carlton Enuda >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: "SQL Solutions for a DBA's wish list" >Date: Mon, 5 Mar 2001 12:36:31 -0500 > >Hi Listers, Mr. Sane, >I will like to get a copy of the May 2000 IDUG NA conference presentation >titled "SQL Solutions for a DBA's wish List" by Suresh Sane. Could someone >share with me a copy of the presentation? [...]
13672 61 33_Re: DB2 OS/390 V6 : SQL CODE -53114_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 6 Mar 2001 14:54:26 +1100500_iso-8859-1 Ed,
Could, by any chance, COLD be defined as the parent of a different relationship?
That is SELECT * FROM SYSIBM.SYSFOREIGNKEYS WHERE CREATOR = '???' AND TBNAME = 'TABLEA' AND COLNAME = 'COLD' produces a row.
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Ed_Vetock@NAVYFEDERAL.ORG [mailto:Ed_Vetock@NAVYFEDERAL.ORG] Sent: Tuesday, 6 March 2001 5:46 To: DB2-L@RYCI.COM Subject: [DB2-L] DB2 OS/390 V6 : SQL CODE -531 [...]
13734 44 34_Re: Inserting DB2 Data into Oracle14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 6 Mar 2001 14:56:57 +1100431_iso-8859-7 I believe you might be able to do this with DataJoiner.
/* standard disclaimer */ James Campbell Hansen Corporation
-----Original Message----- From: Burgess Evans [mailto:BMEVANS@AUDITOR.STATE.OH.US] Sent: Tuesday, 6 March 2001 1:50 To: DB2-L@RYCI.COM Subject: [DB2-L] Inserting DB2 Data into Oracle
Hi all,
We are installing Oracle for the first time. The Oracle version is 8i. [...]
13779 103 33_Re: DB2 OS/390 V6 : SQL CODE -53116_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 09:38:04 +0530479_- Ed,
I just looked at the definition of -531 in the manual and found some difference in its explaination for V5 and above and prior to V5. Is this something related to this ?. I am not sure because COLD is not the part of the key. Otherwise, is this a bug because of this difference in implementation ? But why is this only with COLD(Doesn't like it !!). I believe there is nothing better than rechecking it otherwise someone will share his/her experience with you. [...]
13883 61 18_Re: CICS Deadlocks16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 09:49:43 +0530348_- Vince,
Have you tried looking, which table corresponds to this DBID and OBID combination ?. Similar case had been discussed in December, which was indicating DBID.OBID combination for the deadlock/timeout. You may look into the archive for the same. Thread Name starts with --> Timeouts / Deadlocks on resource type D01.(DBID, OBID). [...]
13945 140 33_Re: DB2 OS/390 V6 : SQL CODE -53114_James Campbell29_James.Campbell@HANCORP.COM.AU30_Tue, 6 Mar 2001 15:39:18 +1100306_iso-8859-1 Sanjeev
The reason for the different wording is because, until V4, "if a column to be updated [was] part of a primary key, the number of rows selected for update [could] not be greater than one." This meant that it was impossible to later the primary key of a row that was a parent. [...]
14086 106 28_Re: Performence Issue - Help16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 6 Mar 2001 10:08:25 +0530557_- Terry,
It seems you were returning after delivering some lectures on the SQL tuning and wrote everything out here. All the contents are mentioned quite nicely. Thanks a lot !
Santha,
As Terry mentioned, i would just like to see the cardinality of the column involved in the WHERE predicate i.e "sts". I am sure it must be having very less distinct value. If that is not the case, then RUNSTAT is not at all run. I am 90% sure problems will be solved by this time. If not, apply the tricks given by Terry and then go for tweaking [...]
14193 165 28_Re: Performence Issue - Help11_Olga Naidis18_olga.n@MOSTEAM.COM30_Tue, 6 Mar 2001 09:38:21 +0200593_windows-1255 It seems that the ACCESSPATH may be changed to I if the predicate will be indexable: SQL : select * from db25.table1 where sts>='DB' and sts <='EV'
> -----Original Message----- > From: S, Sanjeev (CTS) [SMTP:SSanjeev@CAL.COGNIZANT.COM] > Sent: â îøõ 06 2001 6:38 > To: DB2-L@RYCI.COM > Subject: Re: Performence Issue - Help > > Terry, > > It seems you were returning after delivering some lectures on the SQL > tuning and wrote everything out here. All the contents are mentioned quite > nicely. Thanks a lot ! > > Santha, > > As Terry mentioned, i would just [...]
14359 64 34_Re: Inserting DB2 Data into Oracle10_Robert Ord21_robertord@HOTMAIL.COM30_Tue, 6 Mar 2001 11:23:42 -0000712_- If the volumes aren't too high you can use Oracle's DRDA gateway.
Rob
>From: James Campbell >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Inserting DB2 Data into Oracle >Date: Tue, 6 Mar 2001 14:56:57 +1100 > >I believe you might be able to do this with DataJoiner. > >/* standard disclaimer */ >James Campbell >Hansen Corporation > >-----Original Message----- >From: Burgess Evans [mailto:BMEVANS@AUDITOR.STATE.OH.US] >Sent: Tuesday, 6 March 2001 1:50 >To: DB2-L@RYCI.COM >Subject: [DB2-L] Inserting DB2 Data into Oracle > > >Hi all, > >We are installing Oracle for the first time. The Oracle version is [...]
14424 97 15_Re: DB2 Connect27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM30_Tue, 6 Mar 2001 06:46:54 -0500451_iso-8859-1 Thanks. We didn't know it worked that way.
Tina
-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: March 05, 2001 4:21 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect
DB2 Connect's fixpak is included with the DB2 UDB fixpak. When you install the fixpak it will only install those items relating to the software you have installed, at least that is how it worked for me. [...]
14522 225 49_Re: Select Distinct vs Open Cursor and Fetch Once14_Scott Trometer22_scott.trometer@RCI.COM30_Tue, 6 Mar 2001 07:01:05 -0500652_iso-8859-1 What about select count(*) for existance checking in singelton selects VS cursor processing ??
-----Original Message----- From: Richard Yevich [mailto:ryevich@YAHOO.COM] Sent: Monday, March 05, 2001 7:32 PM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once
All,
(1) When you get a -811, the results of the singleton query cannot be depended upon. It has been this way since 1.1, and will not change since it is a negative return code, and by definition, you can never depend on the results being accurate when there is a negative SQLCODE. IBM has stated many times, that it will [...]
14748 180 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 06:06:57 -0600310_iso-8859-1 Scott,
A SELECT COUNT(*) requires every qualifying row to be read to determine the count. Whereas a standard singleton SELECT does one FETCH, plus one "LOOK" (since it is not exactly a FETCH as it does not return the row). The cursor with a single FETCH only selects one qualifying row. [...]
14929 171 28_Re: Performence Issue - Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 06:17:30 -0600450_windows-1255 Olga,
Both the IN predicate, and the range predicate (>= and <=) are indexable.
These two statements, however, are very different since the "IN" returns values that equal 'DB' or 'EV'; whereas the range predicate will also return any rows with values 'DC', 'DD', 'EA', 'ED' (for example).
If due to data specificity, then there are no other values between the two ranges, then they are functionally equivalent. [...]
15101 59 52_Re: Stored Procedure Error Message DSNX962I DSNX9SER8_Rob Lake29_robert.q.lake@PAC.ERICSSON.SE30_Tue, 6 Mar 2001 06:34:53 -0600406_- Hi,
I notice that your COBOL stored procedure is defined as a SUB-program.
In order to run in a DB2-managed SPAS you can only run stored procedures as type MAIN (see chapter 5-13 DB2 UDB for OS/390 V6 Administration Guide for differences between DB2- and WLM- managed SPAS).
Cheers,
Rob
On Thu, 1 Mar 2001 18:26:22 -0600, Karl Haynes wrote: [...]
15161 18 26_Input to Stored Procedures11_Tom Koerner25_Tom.Koerner@METAVANTE.COM30_Tue, 6 Mar 2001 06:53:38 -0600501_us-ascii We are currently using Stored Procedures to send data from the mainframe to a Powerbuilder client application. Now we want to be able to send update transactions from the client into a stored procedure. To minimize the number of trips to the host, we are looking for a way to send 1 to n records as input to a stored procedure (similar to a cursor input) but have not been able to find a way to do that. If there is way, we would be interested in hearing about it. Thanks for your help. [...]
15180 220 49_Re: Select Distinct vs Open Cursor and Fetch Once14_Scott Trometer22_scott.trometer@RCI.COM30_Tue, 6 Mar 2001 08:23:56 -0500569_iso-8859-1 Terry,
Thanks for the feedback...this thread has been most helpful. So, to take it a step further, is there any benefit to the following cursor for existance checking?
SELECT 1 (or any other literal instead of column values) FROM TABLE_A WHERE whatever = whatever_else Optimize for 1 row
Regards, Scott
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Tuesday, March 06, 2001 7:07 AM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once [...]
15401 28 43_any tools for moving InterBase data to DB2?12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 6 Mar 2001 06:14:24 -0800534_us-ascii Anyone out there loading or propagating InterBase (Borland) data into UDB tables? What do you use?
tia, Tim > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The owners of the list > can be reached at DB2-L-REQUEST@RYCI.COM.
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ [...]
15430 63 23_Re: db2 governor on AIX11_Richard Yan23_dhspa3f@DHS.STATE.IL.US30_Tue, 6 Mar 2001 08:06:27 -0600307_- I'm sure SQL-GUY is a very good tool and actually I'll install a trial version to check it out. Since the tool can not prevent bad SQL from running, do you know any ways doing so ?
Thanks Richard Yan
On Mon, 5 Mar 2001 21:46:24 +0000, Philip Nelson (DBA) wrote: [...]
15494 114 28_UDB V7.1 ... Export Question12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Tue, 6 Mar 2001 09:40:12 -0500353_iso-8859-1 Hi Listers, I'm trying to find a way to export a table to a comma delimited flat file and eliminate the CHARDEL of " .... in other words .. in this sample table: CREATE TABLE SAMP.TABLE ( NAME CHAR(10), ADDRESS CHAR(20), AGE SMALLINT, ) in TBSPC01
exporting with this command : export to /file.out of del select * from SAMP.TABLE [...]
15609 151 51_Re: HELP! How to reduce bufferpool size at startup?10_Bill Disch23_bill.disch@GENMILLS.COM30_Tue, 6 Mar 2001 08:43:45 -0600410_- Mail system returned this today as undelivered so I am resending.
Additional info: After looking at the Diagnosis Guide V5 - Analyzing BSDS Dumps, it is easy to find all the bufferpool settings in the BSDS. All I would need next time is a way to edit the BSDS and fix everything without having to worry about data or index recovery. Of course, I'd like to think there will not be a next time ;-) [...]
15761 66 49_Re: Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Tue, 6 Mar 2001 06:59:18 -0800347_us-ascii Hello Everyone, Since there seems to be a lot of interest in existence checking queries here's a twist. I've copied my latest finding on the topic...
I've conferred with the original designer, and one of the three tables in the join is optional. If the two other tables provide a match, the third doesn't have to be examined. [...]
15828 23 38_It's here >>> DB2 v7 for z/OS & OS/39013_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 6 Mar 2001 10:07:35 -0500531_iso-8859-1 See http://www.ibmlink.ibm.com/ibmlink?xu=guest&xh=logon&request=usa.announcemen ts&parms=Q and select IBM DB2 UDB Server....
Planned Availability Date
March, 30, 2001
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
15852 67 33_Re: Control center for DB2 OS/39012_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 6 Mar 2001 09:22:35 -0600518_iso-8859-1 We are paying for DB2 Connect V6 and yes we have a contract for it. DB2 V6 does come with DB2 Connect but it is not as robust version of Connect as DB2 Connect EE that we are paying for separate from UDB DB2 V6. Are you talking about DB2 V6 on the mainframe? If so I would also question how well it performs vs DB2 Connect EE since the DB2 Connect on UDB V5 performs poorly with alot of users and is only a Personal edition meaning we could not distribute it on separate servers. I would be interested [...]
15920 78 71_Re: What are the Requirements, Tips & Tricks for monitoring Dynamic SQL10_Missy Case28_Missy.Case@FIRSTDATACORP.COM30_Tue, 6 Mar 2001 09:21:24 -0600541_us-ascii Carlton, If you have Platinum Detector, you can turn it on to capture your Dynamic SQL, ours comes in under a 'plan' so we can restrict our gathering to the dynamic plan & we also only capture them as exceptions when they exceed a certain # of getpages. It works really well for that and you can explain the SQL individually or jeu eyeball it & see what/where the improvements could be made in the indexes or SQL. The only drawback is that it is one statement at a time. There are no 'groupings' or anything, so you will spend [...]
15999 30 21_DB2 Bind error in CAE16_Daniel Gillieron23_daniel.gillieron@AGI.CH30_Tue, 6 Mar 2001 16:44:45 +0100488_us-ascii Hello
I want to bind the utilities of the CAE, and I receive the following errors message :
LINE MESSAGES FOR db2clisn.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0805N Package "LOCDE02.NULLID.SQLABC6N.44424A3154664B51" was not found. SQLSTATE=51002
does somebody know to which operating system belongs last three characters "C6N"
I work with the CAE version 6.1 [...]
16030 35 47_Stranded Utility from 5.1 but system is now 6.113_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Tue, 6 Mar 2001 09:42:17 -0600576_US-ASCII Hello, We are running v6.1 (about one month) on our DB2 test system on OS/390. Apparently there is a batch job that had blown up just prior to our migration and no one was notified so we migrated to v6.1... now we have found that job has continued to abend weekly since and again no one was notified...but it is now abending because it cannot terminate the utility. We have tried to terminate the utility with commands but receive message DSNU115I >DB2T DSNUGTER - STOSPACE UTILITY WITH UTILID = HDTIR50E.STOSPAC CAN ONLY BE TERMINATED BY A MEMBER WITH THE SAME [...]
16066 58 51_Re: Stranded Utility from 5.1 but system is now 6.115_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 6 Mar 2001 09:56:57 -0600562_iso-8859-1 You might need to blow away SYSUTIL and recreate it again. There are postings for this procedure in the archives.
Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin
"Any sufficiently advanced technology is indistinguishable from magic." - Arther C. Clarke
-----Original Message----- From: Mike Lawrence [mailto:mlawrence@ASCENSIONHEALTH.ORG] Sent: Tuesday, March 06, 2001 9:42 AM To: DB2-L@RYCI.COM Subject: Stranded Utility from 5.1 but system is now 6.1 [...]
16125 56 51_Re: Stranded Utility from 5.1 but system is now 6.10_18_mebert@AMADEUS.NET30_Tue, 6 Mar 2001 17:12:30 +0100365_us-ascii Hi Mike,
I searched the archives with "SYSUTILX" and got 5 hits. The first one from Dan Courter titled "No need to re-initialize SYSUTILX" should help you; it is in response to a different thread titled "Unable to TERM a stopped Utility" that will have more info (even if the situation described is somewhat different if I remember correctly). [...]
16182 32 18_Test Please ignore10_Ian Potter51_ian_potter/manserv/jlp_at_johnlewis@JOHNLEWIS.CO.UK28_Tue, 6 Mar 2001 16:01:19 GMT476_US-ASCII Ian Potter DBA Team Technical Support Tel. 020 7307 4735 Email: Ian_Potter@JohnLewis.co.uk
*********************************************************************
Notice: This email is confidential and may contain copyright material of the John Lewis Partnership. If you are not the intended recipient, please notify us immediately and delete all copies of this message. (Please note that it is your responsibility to scan this message for viruses). [...]
16215 35 41_Accessing DB2 on OS/390 vs Oracle on AIX?14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Tue, 6 Mar 2001 10:28:49 -0600401_iso-8859-1 We currently run Business Objects against both Oracle and DB2 Mainframe databases. Within Business Objects, I can tell Business Objects to only return (for example) 200 rows.
When running a query against Oracle, my query finishes as soon as soon as I get my first 200 rows. When running against DB2, my query returns ALL the rows, then Business Objects uses the first 200 rows. [...]
16251 72 51_Re: Stranded Utility from 5.1 but system is now 6.112_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL30_Tue, 6 Mar 2001 11:35:44 -0500310_us-ascii Looks like to me some failed to read step 9 in the installation migration V6.1 guide. But you will need to take DB2 down,
blow the sysutilx and rebuild and initialize, There are procedures to do this somewhere, but when I did it I contacted level 2 support and they stepped us through it. [...]
16324 28 65_Re: Unqualified table names in Power Builder using DB2 Connect v712_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 6 Mar 2001 10:37:13 -0600390_us-ascii Hello, per our PB guy...
You can use can use unqualified table names in Powerbuilder with DB2 Connect to access DB2 on OS390. Just add a key to the section in your pbodb70.ini file that relates to your DB2 database. The key string should be "PBTableOwner=NO". Set the CURRENTSQLID in your ODBC configuration under the Enterprise tab for the CLI/ODBC advanced settings. [...]
16353 19 58_Re: Latin Phrases for every day use!- In a DBA environment0_24_John_McComb@VANGUARD.COM30_Tue, 6 Mar 2001 11:38:01 -0500449_us-ascii I've been in this business so long my first Cobol manual was in Latin. It began:
"Cobolum est omnis divisa in divortium quattuor."
John McComb (with apologies to Julius Caeser)
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16373 18 19_DB2 UDB and Connect11_Paul Murphy22_Paul_Murphy@MAY-CO.COM30_Tue, 6 Mar 2001 10:48:28 -0600336_us-ascii Hello List,
I know that DB2 UDB v7.1 EE contains Connect. However, our environment consists of DB2 UDB v7.1 Workgroup Edition on one server and DB2 Connect EE v7.1 on another server. My question to the group is, is it possible for both of these products to reside on the same machine (at the same version/release)? [...]
16392 42 44_Onl reorg termed but shadow datasets remain.15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Tue, 6 Mar 2001 11:04:57 -0600636_iso-8859-1 DB2 V6.1 on OS390.
An on-line reorg job terminated. It conflicted with a long running read program. It appears to be a controlled DB2 termination as a result of the parms "LONGLOG TERM DELAY 1200". What puzzles us are the following... 1) The shadow datasets remain along with the regular 2) SYSPRINT has the message DSNU387I DSNURSWT - SWITCH PHASE COMPLETE, ELAPSED TIME = 00:00:01 Followed by the failure messages with X'00C9008E'. 3) the DB2 LOG shows that at the time of the reorg termination there was a series of failures to delete datasets of the form SS.DSNDB*.DBNAME.SPACNAM.T001.A001....note the fourth [...]
16435 24 26_Platinum Tools With DB2 V610_Wong, S.P.15_sp.wong@HBC.COM30_Tue, 6 Mar 2001 11:51:35 -0500332_- Hi Listers:
We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack dated Feb 9, 2001.
We also use Platinum DB2 tools for OS/390 at P99C level going to P99D level.
I would like to have some comments from all listers who also use Platinum about their experience in Platinum with DB2 V6. [...]
16460 14 7_Varchar12_Aditya Narra31_Aditya.Narra@NYCBOE.NYCENET.EDU30_Tue, 6 Mar 2001 12:04:00 -0500418_- Hi All How do i define a table with varchar.I have a table in SQL server with varchar and I want to create a similar table in DB2.Any help would be appreciated. Regards, Audi
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
16475 51 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?0_18_mebert@AMADEUS.NET30_Tue, 6 Mar 2001 18:10:14 +0100501_us-ascii I've never used or even seen BO myself, but BO queries are a known pain... In DB2 on OS390, you can of course OPEN a cursor, FETCH 200 times, then CLOSE the cursor. But it seems from your description that BO simply passes the SQL to DB2, then FETCHes in a loop until it sees an SQLCODE of +100 (buffering all rows somewhere), and only then passes the rows on to the end user, now limiting the number of rows. Thus, I would say that BO is too stupid. I bet it has a GUI (joke - I know it [...]
16527 31 11_Re: Varchar13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 6 Mar 2001 12:23:07 -0500277_iso-8859-1 Hi Audi, If my answer is too simple and I missed a part of your question, please post back. Here is an example of a table containing a varchar column. Were you looking for more advice on the complexities of varchar ? Perhaps if you show us the SQLserver DDL... [...]
16559 32 30_Re: Platinum Tools With DB2 V69_Rob Crane22_racrane@CONCENTRIC.NET30_Tue, 6 Mar 2001 10:35:02 -0700554_us-ascii Need to get on P99D..
"Wong, S.P." wrote: > > Hi Listers: > > We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack > dated Feb 9, 2001. > > We also use Platinum DB2 tools for OS/390 at P99C level going to P99D level. > > I would like to have some comments from all listers who also use Platinum > about their experience in Platinum with DB2 V6. > > TIA. > > S.P. > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at [...]
16592 41 30_Re: Platinum Tools With DB2 V624_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 6 Mar 2001 09:40:44 -0800575_- We've had a problem with the 99c level of Platinum on the Fastload utility. If the primary allocation is insufficient to hold the rows being loaded, the secondary allocation is ignored, and the platinum utility uses a 1 track secondary.
> -----Original Message----- > From: Wong, S.P. [SMTP:sp.wong@HBC.COM] > Sent: Tuesday, March 06, 2001 8:52 AM > To: DB2-L@RYCI.COM > Subject: Platinum Tools With DB2 V6 > > Hi Listers: > > We are going to upgrade DB2 for OS/390 from R5.1 to R6.1 using ServerPack > dated Feb 9, 2001. > > We also use Platinum DB2 tools for [...]
16634 76 48_Re: Onl reorg termed but shadow datasets remain.0_19_Tim.Lowe@STPAUL.COM30_Tue, 6 Mar 2001 11:43:11 -0600556_us-ascii I believe that the original datasets (.I0001) are renamed to temporary datasets (.T0001), Then the shadow datasets (.S0001) are renamed to the original (.I0001). This completes the "switch" phase, then the "temporary" datasets (.T0001) are deleted. This makes rollback possible. If I am wrong, perhaps someone can correct me?
Tonmoy Dasgupta cc: Sent by: DB2 Data Base Subject: Onl reorg termed but shadow datasets Discussion List remain. [...]
16711 41 57_=?iso-8859-1?B?Uulm6XJlbmNl?=: Platinum Tools With DB2 V613_Marcel Lepage28_marcellepage@MONCOURRIER.COM30_Tue, 6 Mar 2001 12:37:27 -0500
16753 32 25_DB2 V7 GA Announced Today14_Richard Yevich17_ryevich@YAHOO.COM30_Tue, 6 Mar 2001 09:57:32 -0800373_us-ascii DB2 for OS/390 and z/OS general availability was announced today by IBM. Product available March 30. The library on the IBM site has been updated with all the new manuals, and there are several new ones.
===== Regards, Richard +====+ DB2 UDB OS/390 & z/OS Certified DBA richard_yevich@ylassoc.com YL&A -- 1-217-744-0000 www.ylassoc.com [...]
16786 77 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?14_Jessen Michael27_JessenMichael@JOHNDEERE.COM30_Tue, 6 Mar 2001 12:12:01 -0600344_iso-8859-1 I also think this is what is happening (only at the end are the rows being passed back)... but I'm still wanting to understand why. Is this a limitation in DB2 connect/DRDA, or is this a limitation in Business Objects? What would be needed for a client app (in my case, BO) to control the # rows being returned by DB2 (OS/390)? [...]
16864 61 33_DB2 V6 upgrade - Tolerance LPARS?13_Laura Hendrix16_lhendrix@BCO.COM30_Tue, 6 Mar 2001 11:26:15 -0800280_ISO-8859-1 Recently on the listserv I've seen mention of Tolerance PTFs for V5 that are applied prior to a V6 upgrade. My systems programmer would like to know what those PTFs are, so that he can ensure that we have them on our system prior to the V6 upgrade (this weekend). [...]
16926 106 45_Re: Accessing DB2 on OS/390 vs Oracle on AIX?11_David Nance16_DWNance@FHSC.COM30_Tue, 6 Mar 2001 14:37:53 -0500291_US-ASCII Mike, Currently, you can not do a fetch first n rows. That becomes available in V7(as we've seen on the list today that will be available on 3/30). In the meantime your app would have to open a cursor and fetch rows until ws-counter >= n to limit it to what n is in your case. [...]
17033 81 32_Re: UDB V7.1 ... Export Question15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM30_Tue, 6 Mar 2001 11:34:18 -0800728_-
"WorldSecure Server " made the following annotations on 03/06/01 11:32:37 ------------------------------------------------------------------------------ Warning: All e-mail sent to this address will be received by the Safeway corporate e-mail system, and is subject to archival and review by someone other than the recipient. This e-mail may contain information proprietary to Safeway and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this [...]
17115 76 55_DB2 UDB for OS/390 and z/OS V7 Announcement Letter URLs24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Tue, 6 Mar 2001 14:49:45 -0800908_us-ascii
Base product: http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=201-054
the dreaded utilities announcement: http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=201-050
At least now we'll have something to talk about besides Latin... ;-)
Frank
+-------------------------------------+--------------------------------------+ | Frank C. Fillmore, Jr. | Voice/Fax: 410.465.6335 | | The Fillmore Group, Inc. (TFG) | Class registration: 800-TFG-RDBMs | | 3213-A Corporate Court | E-mail: fillmore@tfg-rdbms.com | | Ellicott City, Maryland 21042-2247 | URL: http://www.thefillmoregroup.com | | USA | | +-------------------------------------+--------------------------------------+ | DB2 Family, Oracle, Client/Server, Distributed Database | | "Relational Database Solutions"(sm) | +----------------------------------------------------------------------------+
17192 77 37_Re: DB2 V6 upgrade - Tolerance LPARS?13_Gleason, Mike22_MGleason@UILLINOIS.EDU30_Tue, 6 Mar 2001 13:55:19 -0600536_iso-8859-1 Laura, The ptfs are listed in IBM info apar II11442.
-----Original Message----- From: Laura Hendrix [mailto:lhendrix@BCO.COM] Sent: Tuesday, March 06, 2001 1:26 PM To: DB2-L@RYCI.COM Subject: DB2 V6 upgrade - Tolerance LPARS?
Recently on the listserv I've seen mention of Tolerance PTFs for V5 that are applied prior to a V6 upgrade. My systems programmer would like to know what those PTFs are, so that he can ensure that we have them on our system prior to the V6 upgrade (this weekend). [...]
17270 52 32_Re: UDB V7.1 ... Export Question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 6 Mar 2001 12:05:14 -0800493_iso-8859-1 Havn't tried it, but how about:
export to /file.out of asc select NAME CONCAT "," , ADDRESS CONCAT ",", AGE from SAMP.TABLE Please check the exact syntax.
Ashish.
-----Original Message----- From: Donna O'Connell [SMTP:donna.oconnell@SAFEWAY.COM] Sent: Tuesday, March 06, 2001 11:34 AM To: DB2-L@RYCI.COM Subject: Re: UDB V7.1 ... Export Question
"WorldSecure Server " made the following annotations on 03/06/01 11:32:37 [...]
17323 100 32_Re: UDB V7.1 ... Export Question12_Randy Wilson22_Randy_Wilson@BCBST.COM30_Tue, 6 Mar 2001 15:16:42 -0500448_iso-8859-1 Thanx for the reply Donna :o) I just tried to use ASC, again and according to my understanding of what I've read ... that isn't an available option with export :o( ... I wish it were. So far the only thing I've been able to get to work, is to extract the data... 'massage' it, removing the quote marks.. creating a 'clean' comma delimited file... It looks like there should be a way to retrieve this data without having to do this. [...]
17424 54 32_Re: UDB V7.1 ... Export Question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 6 Mar 2001 12:31:52 -0800400_iso-8859-1 CONCAT will work with DEL too to give you the result that you want.
export to /file.out of del select NAME CONCAT "," CONCAT ADDRESS CONCAT "," CONCAT AGE from SAMP.TABLE
Ashish.
-----Original Message----- From: Randy Wilson [SMTP:Randy_Wilson@BCBST.COM] Sent: Tuesday, March 06, 2001 12:17 PM To: DB2-L@RYCI.COM Subject: Re: UDB V7.1 ... Export Question [...]
17479 26 40_Moving Data from Sybase 11 to UDB 6 or 70_24_db46@DAIMLERCHRYSLER.COM30_Tue, 6 Mar 2001 15:42:29 -0500565_us-ascii Well folks, the possibility of getting a third party tool to do this conversion from Sybase 11 to UDB 6.1 or 7.1 is not very likely at the moment.
I presently am using SQLAdvantage to manually create the DDL. But what I need some help on is migrating the actualy data from the Sybase tables to the newly created UDB tables. In other words has anyone 'exported' data from a Sybase tool (like SQLAdvantage) and then using the DB2 client on the unix box,'imported' the data directly into the UDB tables. One can assume that the tables in UDB will [...]
17506 21 50_Porting from DB2 v5 on OS/390 to DB2 UDB v6 on AIX11_Judy Kibler21_judith.kibler@TRW.COM30_Tue, 6 Mar 2001 15:10:21 -0600365_us-ascii Hello,
We are trying to figure out how to migrate our Baan DB2 v5 database (stored with CCSID ASCII) on OS/390 to DB2 UDB v6 on AIX safely and most efficiently. We have about 60 GB of data to transfer. We have a 100 Mbps Ethernet link between the mainframe and the AIX environment. We also have DB2 Connect that could play a part. Suggestions? [...]
17528 61 44_Re: Moving Data from Sybase 11 to UDB 6 or 713_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL30_Tue, 6 Mar 2001 23:26:12 +0200349_iso-8859-1 Hi Dean,
You can use Attunity Connect (www.attunity.com) to move your data from Sybase to DB2. Attunity Connect is a distributed heterogeneous middleware product that covers most databases and platforms out there - including the ones you are interested in. You can then move your data in one SQL statement like the following: [...]
17590 12 30_Re: Platinum Tools With DB2 V612_Richard Pack23_rpack1@MAIL.STATE.MO.US30_Tue, 6 Mar 2001 15:36:50 -0600454_- We are at the P99C level and have found many problems. Specifically in PRA for the Disaster Recovery part that has resulted in fixes for P99D and P99E. Highly recommend P99D at least with all the lastest PTF's.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17603 17 19_Chicago opportunity9_Mike Mays18_MMays@NOLLJOBS.COM30_Tue, 6 Mar 2001 15:46:44 -0600487_- Dear Listers: An opportunity has become available in the Chicagoland area for a UDB-DBA. If there is any interest and for more details, please contact the number or email below. Thanks.
Mike Mays mmays@nolljobs.com 800-798-7736 ext 3450
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17621 28 42_Database Creation scripts for UDB V7 on NT10_CC Harvest19_ccharvest@YAHOO.COM30_Tue, 6 Mar 2001 13:58:20 -0800413_us-ascii Hi,gurus: I am new to DB2 world, could anyone send me a scripts to create a database on the command line (I want to manage tablespace inside the database, the script should be like the one in Oracle, if possible).
TIA,
Chris
__________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ [...]
17650 24 22_DB2 DBA- Charlotte, NC13_Kathryn Sears24_ksears@DPCONSULTANTS.COM30_Tue, 6 Mar 2001 16:09:08 -0600396_- I am looking for a DB2 DBA in Charlotte, NC for a client of mine that is seeing MAJOR GROWTH in its DB2 area and will continue to expand in the future (they are an OS390 shop, with many other platforms). This is HUGE, GROWING company and the manager is looking for SELF-STARTERS who LOVE learning about NEW TECHNOLOGY- they work quite a bit with REPLICATION, WEB ACCESS, DATABASE SHARING. [...]
17675 90 43_Re: end of service dates - db2 connect v5.x12_Kirk Hampton16_khampto1@TXU.COM30_Tue, 6 Mar 2001 16:16:42 -0600454_us-ascii I forwarded this around our shop, and I was asked: "does the service end date include everything to do with version 5.2, including the CAE-only clients, or does it mostly pertain to Personal Edition or the EE gateway code ? " My initial reaction was that all of it is considered DB2 Connect, even a CAE-only installation on a desktop, so we needed to upgrade those clients also, to stay supported. Can anyone tell me if I am wrong ? Leon ? [...]
17766 24 25_Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 18:50:21 -0500452_iso-8859-1 I am drawing a blank ... can anyone assist with an SQL statement that would query the DB2 catalog and detect any tablespace that has not been Image Copied within the last 7 days? Your help is appreciated. Thanks, in advance.
Mark Knabach EDS - Chicago Solution Centre 1900 S. Springer Drive Lombard, IL 60148 *phone: +01-630-495-3229 (8-520) *fax: +01-630-691-5303 (8-520) * mailto: mark.knabach@eds.com *pager: +01-888-617-2796 [...]
17791 54 29_Re: Image Copy in Last 7 Days13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 6 Mar 2001 16:05:48 -0800494_us-ascii SELECT DBNAME,NAME FROM SYSIBM.SYSTABLESPACE T1 WHERE NOT EXISTS ( SELECT DBNAME,TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY T2 WHERE ICTYPE = 'F' AND T1.DBNAME = T2.DBNAME AND T1.NAME = T2.TSNAME GROUP BY DBNAME,TSNAME HAVING DATE(MAX(TIMESTAMP)) > CURRENT DATE - 7 DAYS )
Thanks. Ashish.
-----Original Message----- From: Knabach, Mark L [SMTP:mark.knabach@EDS.COM] Sent: Tuesday, March 06, 2001 3:50 PM To: DB2-L@RYCI.COM Subject: Image Copy in Last 7 Days [...]
17846 117 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 18:14:23 -0600387_us-ascii Chris,
What about something like:
SELECT 1 FROM SYSIBM.SYSDUMMY1 WHERE EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND A.DATE1 = TODAY) OR EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND B.DATE1 = TODAY) OR EXISTS (SELECT 1 FROM TABLE1 A, TABLE2 B, TABLE3 C WHERE B.PART = A.PART AND C.PART = B.PART AND C.DATE1 = TODAY) [...]
17964 49 29_Re: Image Copy in Last 7 Days15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM30_Tue, 6 Mar 2001 16:20:24 -0800608_us-ascii It should be something like this
SELECT DBNAME, TSNAME, ICDATE, ICTIME, DSNAME FROM SYSIBM.SYSCOPY WHERE ICDATE < CURRENT-DATE - 7 ;
"Knabach, Mark L" wrote:
> I am drawing a blank ... can anyone assist with an SQL statement that would > query the DB2 catalog and detect any tablespace that has not been Image > Copied within the last 7 days? Your help is appreciated. Thanks, in > advance. > > Mark Knabach > EDS - Chicago Solution Centre > 1900 S. Springer Drive > Lombard, IL 60148 > *phone: +01-630-495-3229 (8-520) > *fax: +01-630-691-5303 (8-520) > * mailto: [...]
18014 67 29_Re: Image Copy in Last 7 Days13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 18:24:58 -0600436_iso-8859-1 Mark,
Try either of these:
SELECT DBNAME, TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE ICTYPE = 'F' GROUP BY DBNAME, TSNAME HAVING MAX(TIMESTAMP) < CURRENT TIMESTAMP - 7 DAYS
or
SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE A WHERE NOT EXISTS (SELECT 1 FROM SYSIBM.SYSCOPY B WHERE B.DBNAME = A.DBNAME AND B.TSNAME = A.NAME AND B.ICTYPE = 'F' AND B.TIMESTAMP < CURRENT TIMESTAMP - 7 DAYS) [...]
18082 234 77_Re: Select Distinct vs Open Cursor and Fetch Once - Reply to Scott's question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 18:29:07 -0600496_iso-8859-1 Scott,
Yes....you've hit the nail on the head. As we've said this is the perfect technique for the majority of existance checks.
Glad the thread has been of assistance. Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Scott Trometer Sent: Tuesday, March 06, 2001 7:24 AM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once [...]
18317 21 17_RECOVER TS TO RBA16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU30_Tue, 6 Mar 2001 17:23:00 -0800472_- Assume Tablespace A has single Table A and that a full image copy is made on Monday. On Tuesday a column is dropped from Table A so we LOAD Tablespace A LOG YES to reload Table A after redefining Table A.
Prior discussions on listserve indicate DB2 can RECOVER TS A to current where current is after the reload of TS A by processing the image copy taken before the new definition of Table A and log records taken both before and after Table A was redefined. [...]
18339 79 29_Re: Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 20:58:40 -0500444_iso-8859-1 Ahh, yes. Thank you so much Terry.
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Tuesday, March 06, 2001 6:25 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy in Last 7 Days
Mark,
Try either of these:
SELECT DBNAME, TSNAME, MAX(TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE ICTYPE = 'F' GROUP BY DBNAME, TSNAME HAVING MAX(TIMESTAMP) < CURRENT TIMESTAMP - 7 DAYS [...]
18419 74 29_Re: Image Copy in Last 7 Days15_Knabach, Mark L20_mark.knabach@EDS.COM30_Tue, 6 Mar 2001 20:59:40 -0500673_iso-8859-1 Thanks, Donna!
-----Original Message----- From: Donna O'Connell [mailto:donna.oconnell@SAFEWAY.COM] Sent: Tuesday, March 06, 2001 6:20 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy in Last 7 Days
It should be something like this
SELECT DBNAME, TSNAME, ICDATE, ICTIME, DSNAME FROM SYSIBM.SYSCOPY WHERE ICDATE < CURRENT-DATE - 7 ;
"Knabach, Mark L" wrote:
> I am drawing a blank ... can anyone assist with an SQL statement that would > query the DB2 catalog and detect any tablespace that has not been Image > Copied within the last 7 days? Your help is appreciated. Thanks, in > advance. > > Mark Knabach > [...]
18494 170 49_Re: Select Distinct vs Open Cursor and Fetch Once15_Corrigan, David31_David.Corrigan@TEAM.TELSTRA.COM30_Wed, 7 Mar 2001 13:46:58 +1100327_iso-8859-1 Terry,
Correct me if I am wrong, the SQL you have written includes 3 non-correlated subqueries which when the SQL is executed would be preformed first returning all rows which match the predicates. Only after the Subselects are performed will DB2 look at the outer sql and evaluate the Existence clause. [...]
18665 21 28_DBLINKS DB2 UDB / DB2 os/39025_RAUL GILDARDO ROSAS LOPEZ23_rrosasl@MAIL.TELCEL.COM30_Tue, 6 Mar 2001 21:11:14 -0600468_us-ascii Hi....
I try to do some links between db2udb and db2 the problem is that i try to see one view in db2udb but the view is one object in de db2 os/390
Someone know how do that... ?????
Thanks.......
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
18687 179 49_Re: Select Distinct vs Open Cursor and Fetch Once13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 6 Mar 2001 21:17:15 -0600490_iso-8859-1 David,
Excellent pickup.....I was only saying in a class today how a lot of people forget this....and now I can include myself.
Thanks for the correction.
Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Corrigan, David Sent: Tuesday, March 06, 2001 8:47 PM To: DB2-L@RYCI.COM Subject: Re: Select Distinct vs Open Cursor and Fetch Once [...]
18867 51 21_Re: RECOVER TS TO RBA20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM28_Tue, 6 Mar 2001 22:22:33 EST583_US-ASCII John, The documentation that I send to you a few days about the recovery tool will display all the recovery points of a tablespace. You would type in the tablespace name and you will get an ISPF panel listing of recovery points by RBA with Timestamp and all other Tablespaces names that were quiesced with the specified tablespace. You can also get a panel listing of all recovery points of a tablespace by valid Image Copies dsnames and Timestamps and all Tablespaces in a specified Database. From the ISPF Display Panel the user just Pick and Chose and everything is [...]
18919 58 21_Re: RECOVER TS TO RBA14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 7 Mar 2001 15:39:33 +1100563_iso-8859-1 My understanding is that the recovery process doesn't know anything about the meaning of the contents of a tablespace. It will happily recover data for a dropped table (ie one with an OBID that is not used by any current table). But this does absolutely nothing to recover the catalog information for the dropped table - the only way to do this is to recover the catalog and directory tablesspace back to the same RBA (:-(). In fact, a "SELECT * FROM " will not suffer a failure due to all the 'unknown rows' in the tablespace, but it [...]
18978 32 32_Authorizations for DB2 on NT 4.016_Trevor Kingsbury31_Trevor_Kingsbury@COMPUSERVE.COM30_Wed, 7 Mar 2001 00:49:44 -0500395_ISO-8859-1 Hi all,
The DB2 for NT literature (especially the '97 Redbook, chapter 3) indicates that the only way to manage authorization at the group level is to have the DB2 server as a BDC (or PDC).
I have verified that this scenario will work. But - my question is : is this (undesirable!) configuration the only option available to do group-level authorization on DB2-NT? [...]
19011 30 28_Re: One Process - Many Users15_Shabtai Shatsky22_shabtai@ATTUNITY.CO.IL30_Wed, 7 Mar 2001 03:16:34 -0600375_ISO-8859-1 The approach we took for handling this problem is that instead of the named/token pair being passed to the exit, our client program (a started task similar to Harry2 mentioned in the archive) issues a RACROUTE VERIFY (with user ID and PSWD) to establish an ACEE security block with the client’s name and password. The routine which does it is APF authorized. [...]
19042 37 42_Re: It's here >>> DB2 v7 for z/OS & OS/39010_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 7 Mar 2001 03:44:28 -0600857_- V7 Manuals! http://www-4.ibm.com/software/data/db2/os390/v7books.html
To see the announcement mentioned by Dave, you will need to append the last bit of the address, which is trimmed off when the URL spreads over one line. In this case: 'ts&parms=Q'
On Tue, 6 Mar 2001 10:07:35 -0500, Seibert, Dave wrote:
>See >http://www.ibmlink.ibm.com/ibmlink?xu=guest&xh=logon&request=usa.announceme n >ts&parms=Q >and select IBM DB2 UDB Server.... > >Planned Availability Date > >March, 30, 2001 > >David Seibert >Compuware Corporation File-AID Product Architect >Dave.Seibert@Compuware.com > >================================================ >To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached [...]
19080 46 35_String constant too long (SQL0102N)10_Ron Parker15_sysop@SCBBS.COM30_Wed, 7 Mar 2001 02:46:54 -0800543_us-ascii Hello,
I'm running java 1.2.2 on aix 4.3. Using DB2 05.01.0001 with OpenLink opljdbc2 driver 3.20.10.22. Using Jakarta-Tomcat 3.2.1 servlet engine, default settings.
I have a column defined in database "table" as MESSAGE LONG VARCHAR.
"message" is a java String which is 1043 characters long. Begins with "blah, blah".
I execute:
sql = "insert into table (MESSAGE) values ('" + message + "')"; Statement s = dbCon0.createStatement(); s.setMaxFieldSize(5000); ResultSet r = s.executeQuery(sql); [...]
19127 39 22_Dataspace vs hiperpool16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 7 Mar 2001 08:30:35 -0500585_iso-8859-1 Weare installing DB2/390 V7 soon. One of the things we want to consider is replacing our current VPOOL + Hiperpool with dataspace. However, we do not have the 64-bit 'Z' hardware. Thus we cannot fully exploit dataspaces and may have as documented in IBMLINK item RTA000165584 'additional CPU cost'.
The reason we want to look at dataspaces is as a way to eliminate the need for ADMF. Our disaster recovery site cannot support ADMF since they run OS/390 as a VM guest. Don't suggest killing off VM. I would love to do this but the config people insist their jobs [...]
19167 48 46_Re: Database Creation scripts for UDB V7 on NT12_tim malamphy20_timalamphy@YAHOO.COM30_Wed, 7 Mar 2001 05:33:35 -0800676_us-ascii how about:
create database mydatabase
--- CC Harvest wrote: > Hi,gurus: > I am new to DB2 world, could anyone send me a > scripts to create a database on the command line > (I want to manage tablespace inside the database, > the script should be like the one in Oracle, if > possible). > > TIA, > > > Chris > > __________________________________________________ > Do You Yahoo!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/ > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L [...]
19216 116 43_Re: end of service dates - db2 connect v5.x0_15_leon@CA.IBM.COM30_Wed, 7 Mar 2001 15:09:54 +0100530_us-ascii Everything V5.2 is comming pout of service. You need to make plans to upgade all workstations that have DB2 CAE V5.2 installed.
Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com
Kirk Hampton @RYCI.COM> on 03/06/2001 11:16:42 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: end of service dates - db2 connect v5.x [...]
19333 146 49_Re: Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Wed, 7 Mar 2001 06:51:17 -0800309_us-ascii The bad news is, I need a list of Names from table1.
The latest good news is, it sounds like I can use a trigger on the various date columns and have that insert into a 'log' table. Or as an update of a column in table1, perhaps is perferable, since I have to look at it to get the Name. [...]
19480 54 51_Re: Stranded Utility from 5.1 but system is now 6.113_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Wed, 7 Mar 2001 08:54:44 -0600384_US-ASCII Hello, I just wanted to send a quick thanks to everyone for their help... I tried using a procedure in the archives that someone pointed me to...but it didnt work... so I ended up deleting and redefining/initing the sysutilx with good results..thanks again for your help.
Michael S. Lawrence Systems Programmer Ascension Health, ISD MLawrence@Ascensionhealth.org [...]
19535 226 49_Re: Select Distinct vs Open Cursor and Fetch Once5_Chris17_isatcjk@YAHOO.COM30_Wed, 7 Mar 2001 07:01:23 -0800603_us-ascii Oh, in addition to my last post... Unfortunately, this query wants a list of qualifying names.
So, is it possible to somehow replace sysibm.sysdummy1 with table1, and instead of a Exists clause, perhaps use a In clause?
Something like the following clumsy cutting and pasting...
select name from table1 x where part in (SELECT a.part FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND A.DATE1 = TODAY AND X.part = X.part) **** to make it correlated OR a.part in (SELECT a.part FROM TABLE1 A, TABLE2 B WHERE B.PART = A.PART AND B.DATE1 = TODAY AND X.part = X.part) **** [...]
19762 73 21_FW: DB2 Identity Cols23_Scarcella, Gary V (ING)23_ScarcellaGV@ING-AFS.COM30_Wed, 7 Mar 2001 11:20:14 -0500491_iso-8859-1 Does anyone know if this IDENTITY_VAL_LOCAL function or something similar is available for DB2 UDB on UNIX? We need to know what the value of an 'identity' column is upon insert.
Thanks, Gary.
Gary Scarcella ING-AFS/IT/IM/DBA - TSB2 Email: mailto:ScarcellaGV@ING-AFS.com
-----Original Message----- From: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] Sent: Wednesday, November 22, 2000 11:31 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Identity Cols [...]
19836 19 42_Re: It's here >>> DB2 v7 for z/OS & OS/39014_Toppins, Smike21_smike.toppins@GWL.COM30_Wed, 7 Mar 2001 09:43:35 -0700441_- Now that DB2 V7 for OS/390 has been announced, I'm curious as to how many sites will be going to V7 by this summer?
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
19856 41 42_Re: It's here >>> DB2 v7 for z/OS & OS/39016_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 7 Mar 2001 11:54:55 -0500418_iso-8859-1 We have a target date well before Aug 23. If no problems, we would like to upgrade all our subsystems from V5 to V7 by the end of June.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Toppins, Smike [mailto:smike.toppins@GWL.COM] Sent: Wednesday, March 07, 2001 11:44 AM To: DB2-L@RYCI.COM Subject: Re: It's here >>> DB2 v7 for z/OS & OS/390 [...]
19898 21 18_DB2 Control Center13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Wed, 7 Mar 2001 11:20:03 -0600615_iso-8859-1 I was told by the instructors in the IBM DB2 Connect advanced class that DB2 Connect EE comes with DB2 UDB (for NT in our case), although you can only legally use it for two databases (a two-phase commit database and a federated database) unless you also purchased a license for UDB. I reading various IBM publications about UDB performance tuning, administration and other topics, I see references to various functional capabilities available through the Control Center. However, when I go into the Control Center I can't find some of these options where they are described as being located. Could [...]
19920 43 39_UCLA spring short courses by Chris Date12_Goodin, Bill21_bgoodin@UNEX.UCLA.EDU30_Wed, 7 Mar 2001 09:20:34 -0800766_iso-8859-1 > This spring, UCLA Extension will present the following short courses on > the > UCLA campus in Los Angeles. > > April 2-3, 2001, "Relational Remodeled". The instructor is Chris Date, > MA, Independent Consultant and Author, $895. > http://uclaextension.org/shortcourses/spring2001/relational_remodeled_sp01 > .htm > > April 4-6, 2001, "Objects, Relations, and Object/Relational: The > Future of Database Management". The instructor is Chris Date, MA, > Independent Consultant and Author, $1295. > http://uclaextension.org/shortcourses/spring2001/future_of_database_sp01.h > tm > > April 23-26, 2001, "Software Project Planning and Management". The > instructor is Dennis J. Frailey, PhD, Principal Fellow, Raytheon > Company and Adjunct Professor, [...]
19964 23 30_DB2 Connect EE NT V4 to VM/ESA14_Michael Bedard28_michael_p_bedard@HOTMAIL.COM30_Wed, 7 Mar 2001 12:21:26 -0500381_- Fellow list members,
We have installed DB2 Connect EE V6.1 on a Windows NT 4.0 desktop linked via TCP/IP to DB2 for VM V6.1 on the host S/390 VM/ESA 2.4. When we bind the utilities as part of the instalation on the host, the Owner ID of the packages becomes(NULLID) and the grant to public fails. Does anyone know how we get the "owner" to be the installers user ID? [...]
19988 64 39_Re: String constant too long (SQL0102N)13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Wed, 7 Mar 2001 11:26:55 -0600695_iso-8859-1 There's a couple different ways to resolve this. My suggestion would be to use a host variable instead of a literal for the long-field. For example, In place of what you currently have, you could try...
sql = "insert into table (MESSAGE) values (?)"; PreparedStatement s = dbCon0.prepareStatement(sql); s.setString(1,message); s.executeQuery(sql);
Don't quote me on the exact syntax, but that should be pretty close. Other options involve breaking the text down into smaller chunks (each under 254 characters) and putting it back together in the insert statement using "CONCAT". In general I've always tried to advocate using "PreparedStatment" with host variables [...]
20053 72 46_Re: Database Creation scripts for UDB V7 on NT10_CC Harvest19_ccharvest@YAHOO.COM30_Wed, 7 Mar 2001 10:08:28 -0800580_us-ascii Thanks for the reply. Actually, I want to know how do you specify the datafiles for those tablespaces, the buffer pool, etc. A script like Oracle has. Create database fool datafile 'dsfh.dbf' ....; create tablespace bar; etc.
Chris
--- tim malamphy wrote: > how about: > > create database mydatabase > > > > > --- CC Harvest wrote: > > Hi,gurus: > > I am new to DB2 world, could anyone send me a > > scripts to create a database on the command line > > (I want to manage tablespace inside the database, > > [...]
20126 89 20_Index not being used10_Wang.James24_Wang.James@AAA-CALIF.COM30_Wed, 7 Mar 2001 10:28:18 -0800496_iso-8859-1 Help ... Why ...
We have a batch program that accesses one DB2 table with index. It takes excessive time.
When job is running, DB2 Activity Monitor shows it's doing tablespace scan which conflict with result from EXPLAIN.
From Explain, it shows the chosen access path is through index.
Thank in advance.
James Wang ESD-Technical Services Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com
20216 21 22_Re: DB2 Control Center13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 7 Mar 2001 13:39:29 -0500530_iso-8859-1 Hi Gerry, What are you missing?
You won't see any of the OS/390 (z/OS) admin choices available if the Stored Procedures supporting them are not installed on your OS/390 DB2.
David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20238 32 38_Create Tablespace/Index with DEFINE NO12_Troy Coleman19_Colematr@MEIJER.COM30_Wed, 7 Mar 2001 13:39:01 -0500443_US-ASCII Hi list, I implemented an ERP database with DEFINE NO on the create tablespace and index. I was running a QUIESCE TABLESPACE and received the following error:
DSNU185I -DST1 DSNUGSRI - THE VSAM DATA SET DOES NOT EXIST FOR INDEXSPACE PSMADMO.PSRAERUN
Two questions: 1) Has IBM fixed this yet? 2) Can I query the catalog to find tablespace and indexspace objects that do not have an associated VSAM file defined yet? [...]
20271 48 21_Stored Procedure Help15_Morris, Deborah20_DMorris@UNCH.UNC.EDU30_Wed, 7 Mar 2001 14:11:47 -0500546_iso-8859-1 I developed a simple Cobol Stored procedure (DB2 V6 OS390 using WLM) and receive the following sqlcode after calling the sp :
-430 routine-type routine-name (SPECIFIC NAME specific-name) HAS | ABNORMALLY TERMINATED. Here are the particulars on the sp: - called from a cobol batch program - 7 parms passed to sp - result set produced in sp and passed to the calling program Does anyone have suggestions on how I can debug this stored procedure? I am at a loss with this generic -430 message. Thanks in advance for any help. [...]
20320 13 22_DB2 v5 to V7 migration14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM30_Wed, 7 Mar 2001 13:08:57 -0600337_iso-8859-1 Is there a direct migration path from V5 to V7 or is it necessary to go to V6 first?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20334 57 24_Re: Index not being used19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM30_Wed, 7 Mar 2001 13:21:21 -0600640_iso-8859-1 Hi James, Some things to check. The PLAN/PACKAGE has been rebound (maybe autoBIND) since the EXPLAIN output was produced. It uses REOPTVARS.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, [...]
20392 66 42_Re: Create Tablespace/Index with DEFINE NO15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 7 Mar 2001 13:24:19 -0600545_iso-8859-1 Hi, Troy, I am a bit perplexed as to the reason why you think this is a problem. It seems to be working as designed. When you use DEFINE NO on a tablespace create that means that you don't want the underlying VSAM data set allocation delayed until a row is inserted in the table. It makes sense that a QUIESCE would fail when executed against such a tablespace before any rows are inserted. What is the purpose of a QUIESCE but to flush data from bufferpools to create a point of consistency? If there is no underlying VSAM then [...]
20459 59 42_Re: Create Tablespace/Index with DEFINE NO19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM30_Wed, 7 Mar 2001 13:25:35 -0600573_iso-8859-1 Hi Troy, Don't know if IBM has "fixed" this yet. The new V7 manuals are suppose to be at the IBM website -- haven't checked yet. You can check the SPACE column on SYSINDEX and TABLEPART for -1, meaning they are DEFINE NO.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message [...]
20519 41 24_Re: Index not being used11_Moore, Tony15_TMoore@IKON.COM30_Wed, 7 Mar 2001 14:15:28 -0500404_iso-8859-1 Sounds like possibly your batch program is doing dynamic prefetch. I'm not sure if this'll do it, but you might try adding OPTIMIZE FOR 0 ROWS to the query.
-----Original Message----- From: Wang.James [mailto:Wang.James@AAA-CALIF.COM] Sent: Wednesday, March 07, 2001 1:28 PM To: DB2-L@RYCI.COM Subject: Index not being used Importance: High
Help ... Why ... [...]
20561 36 26_Re: DB2 v5 to V7 migration12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Wed, 7 Mar 2001 14:36:47 -0500465_us-ascii no u can go directly to 7 from 5.
"Zobjeck, A. J." @RYCI.COM> on 03/07/2001 02:08:57 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: DB2 v5 to V7 migration
Is there a direct migration path from V5 to V7 or is it necessary to go to V6 first? [...]
20598 35 26_Re: DB2 v5 to V7 migration16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Wed, 7 Mar 2001 14:40:52 -0500413_iso-8859-1 The V7 manuals tell how to go directly from V5 to V7. That will be what we do. Be aware that there is some 'pre-conditioning' maintenance required for V5.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Zobjeck, A. J. [mailto:Al_Zobjeck@TTX.COM] Sent: Wednesday, March 07, 2001 2:09 PM To: DB2-L@RYCI.COM Subject: DB2 v5 to V7 migration [...]
20634 21 31_AIX 4.3 Manuals - PDF documents9_Anil Kale18_Usregion10@AOL.COM28_Wed, 7 Mar 2001 14:40:36 EST513_ISO-8859-1 Hi all!
Does anyone know of a site, where I can download AIX manuals in PDF format. I have seen many sites that have the manuals, but don't have any link to click for download. I am specifically looking for the Command reference.
TIA.
Anil
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20656 41 26_Re: DB2 v5 to V7 migration19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM30_Wed, 7 Mar 2001 13:42:41 -0600600_iso-8859-1 Yes, see announcement . . .
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
20698 196 42_Re: Create Tablespace/Index with DEFINE NO10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM30_Wed, 7 Mar 2001 14:54:47 -0500309_us-ascii Troy, I also would like to know the answer to your question. We have a few "automated" procedures (like Quiesce) that we will have to update to ignore the objects created with DEFINE NO. We have PeopleSoft and have some 5000+ indexes that are never used.
Thanks for bringing it up, Keith [...]
20895 34 29_DB2 OS/390 V6 : SQL CODE -53114_Mark McCormack27_mamccormack@STATESTREET.COM30_Wed, 7 Mar 2001 15:02:45 -0500532_us-ascii Ed,
We encountered a problem which led to -531 sqlcode in error. It may or may not be related to your situation.
Our symptoms: 1. table A is parent, table B is child. 2. A particular row in table A has no children in table B. 3. Under DB2v6 an attempt to change a column in the primary key in the table A row failed with sqlcode -531. -531 would have been appropriate had there been children row(s) in table B. Since the table A row had no children, the -531 is an error. 4. Under DB2v5 the change would [...]
20930 114 42_Re: Create Tablespace/Index with DEFINE NO15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 7 Mar 2001 14:04:26 -0600458_iso-8859-1 Hi, all, Ahhhh, now I see. You have my complete sympathy. We will have Siebel installed here someday... sometime, who knows when? I think that we will encounter that problem ourselves. Then I will be interested to the solution as well.
Linda
-----Original Message----- From: Keith Kuhn [mailto:Keith_Kuhn@WENDYS.COM] Sent: Wednesday, March 07, 2001 1:55 PM To: DB2-L@RYCI.COM Subject: Re: Create Tablespace/Index with DEFINE NO [...]
21045 13 26_Read Oracle DB from OS/39014_Terri Tompkins27_Terri.Tompkins@EXPERIAN.COM30_Wed, 7 Mar 2001 13:44:26 -0600414_- Hello DB2 List! I have been asked if it is possible to read data from an Oracle DB on Unix from a process running on OS/390. Any related information is appreciated. Terri
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21059 41 26_Re: DB2 v5 to V7 migration0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:16:59 +0000465_us-ascii no u can go directly to 7 from 5.
"Zobjeck, A. J." @RYCI.COM> on 03/07/2001 02:08:57 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: DB2 v5 to V7 migration
Is there a direct migration path from V5 to V7 or is it necessary to go to V6 first? [...]
21101 53 21_Stored Procedure Help0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:16:56 +0000544_us-ascii I developed a simple Cobol Stored procedure (DB2 V6 OS390 using WLM) and receive the following sqlcode after calling the sp :
-430 routine-type routine-name (SPECIFIC NAME specific-name) HAS | ABNORMALLY TERMINATED. Here are the particulars on the sp: - called from a cobol batch program - 7 parms passed to sp - result set produced in sp and passed to the calling program Does anyone have suggestions on how I can debug this stored procedure? I am at a loss with this generic -430 message. Thanks in advance for any help. [...]
21155 46 24_Re: Index not being used0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:03 +0000402_us-ascii Sounds like possibly your batch program is doing dynamic prefetch. I'm not sure if this'll do it, but you might try adding OPTIMIZE FOR 0 ROWS to the query.
-----Original Message----- From: Wang.James [mailto:Wang.James@AAA-CALIF.COM] Sent: Wednesday, March 07, 2001 1:28 PM To: DB2-L@RYCI.COM Subject: Index not being used Importance: High
Help ... Why ... [...]
21202 66 42_Re: Create Tablespace/Index with DEFINE NO0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:01 +0000571_us-ascii Hi Troy, Don't know if IBM has "fixed" this yet. The new V7 manuals are suppose to be at the IBM website -- haven't checked yet. You can check the SPACE column on SYSINDEX and TABLEPART for -1, meaning they are DEFINE NO.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message [...]
21269 75 42_Re: Create Tablespace/Index with DEFINE NO0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:09 +0000543_us-ascii Hi, Troy, I am a bit perplexed as to the reason why you think this is a problem. It seems to be working as designed. When you use DEFINE NO on a tablespace create that means that you don't want the underlying VSAM data set allocation delayed until a row is inserted in the table. It makes sense that a QUIESCE would fail when executed against such a tablespace before any rows are inserted. What is the purpose of a QUIESCE but to flush data from bufferpools to create a point of consistency? If there is no underlying VSAM then [...]
21345 63 24_Re: Index not being used0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:05 +0000638_us-ascii Hi James, Some things to check. The PLAN/PACKAGE has been rebound (maybe autoBIND) since the EXPLAIN output was produced. It uses REOPTVARS.
HTH, Rick Davis
"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, [...]
21409 18 22_DB2 v5 to V7 migration0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:17 +0000577_us-ascii Is there a direct migration path from V5 to V7 or is it necessary to go to V6 first?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
21428 41 26_Re: DB2 v5 to V7 migration0_20_owner-db2-l@RYCI.COM30_Wed, 7 Mar 2001 20:17:15 +0000411_us-ascii The V7 manuals tell how to go directly from V5 to V7. That will be what we do. Be aware that there is some 'pre-conditioning' maintenance required for V5.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Zobjeck, A. J. [mailto:Al_Zobjeck@TTX.COM] Sent: Wednesday, March 07, 2001 2:09 PM To: DB2-L@RYCI.COM Subject: DB2 v5 to V7 migration [...]
21470 154 42_Re: Create Tablespace/Index with DEFINE NO12_Isaac Yassin20_yassini@BEZEQINT.NET30_Wed, 7 Mar 2001 22:23:19 +0200350_iso-8859-1 Hi, According to V7 SQL manual: SYSIBM.SYSTABLEPART field SPACE = -1 when DEFINE NO is used. " The value is -1 if the table space was defined
with the DEFINE NO clause, which defers the physical creation of
the data sets until data is first inserted into one of the partitions,
and data has yet to be inserted. " [...]
21625 152 42_Re: Create Tablespace/Index with DEFINE NO0_19_Tim.Lowe@STPAUL.COM30_Wed, 7 Mar 2001 14:22:24 -0600412_us-ascii Does anyone know if the new DB2 V7 utilities with pattern matching (ie. COPY dbname.*) will check for DEFINE NO tablespaces/indexes before they attempt to run each utility?
Thanks, Tim
"Billings, Linda" cc: Sent by: DB2 Data Base Subject: Re: Create Tablespace/Index with Discussion List DEFINE NO [...]
21778 32 22_RUNSTATS Privilege Bug19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM30_Wed, 7 Mar 2001 09:55:40 -0800649_- DB2 V6.1 put level 8
We're running RUNSTATS on tablespaces (table (all) index (all) sample report yes update none) to obtain pre-reorg object stats without updating the catalog.
The utility ends "normally", but we see a DSNU619I message consistently on the DSNU624I SYSTABSTATS catalog statistics section for the first partition of every partitioned tablespace that the runtime "USER xxxxxxxx DOES NOT HAVE PRIVILEGE ON TABLE .". Most of the detail under that section of the report comes up with 0. This tends to cause a problem when we were using the NACTIVE page count to determine work and image copy [...]
21811 43 35_Re: AIX 4.3 Manuals - PDF documents9_Bob Lewis23_BLewis@MICROGENERAL.COM30_Wed, 7 Mar 2001 12:39:16 -0800595_iso-8859-1 Hi Anil -
Take a look here:
http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d 2w/en_main
Bob
-----Original Message----- From: Anil Kale [mailto:Usregion10@AOL.COM] Sent: Wednesday, March 07, 2001 1:41 PM To: DB2-L@RYCI.COM Subject: AIX 4.3 Manuals - PDF documents
Hi all!
Does anyone know of a site, where I can download AIX manuals in PDF format. I have seen many sites that have the manuals, but don't have any link to click for download. I am specifically looking for the Command reference. [...]
21855 40 22_Re: DB2 Control Center13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Wed, 7 Mar 2001 14:46:15 -0600321_iso-8859-1 It was 3 or 4 weeks ago that I experienced this, and I don't remember specifics. The only one that comes to mind off-hand is I couldn't find an "event analyzer" icon. I'll look at it again and come up with some more specifics. We've been told that the stored procedures have been installed on OS/390 DB2. [...]
21896 59 26_Re: RUNSTATS Privilege Bug12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Wed, 7 Mar 2001 15:59:01 -0500549_us-ascii See uq46597.
"Ohling, Tim R - CNF" @RYCI.COM> on 03/07/2001 12:55:40 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: RUNSTATS Privilege Bug
DB2 V6.1 put level 8
We're running RUNSTATS on tablespaces (table (all) index (all) sample report yes update none) to obtain pre-reorg object stats without updating the catalog. [...]
21956 46 30_Re: Read Oracle DB from OS/39014_Richard Yevich17_ryevich@YAHOO.COM30_Wed, 7 Mar 2001 13:05:11 -0800625_us-ascii Release dependent but yes - using DB2 Relational Connect. Check out info on www.software.ibm.com/data/db2
--- Terri Tompkins wrote: > Hello DB2 List! > I have been asked if it is possible to read data from an Oracle DB > on Unix > from a process running on OS/390. Any related information is > appreciated. > Terri > > ================================================ > To change your subscription options or to cancel your subscription > visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of > the list can be reached at DB2-L-REQUEST@RYCI.COM. > > > [...]
22003 19 30_Re: Read Oracle DB from OS/3900_18_Richar3749@AOL.COM28_Wed, 7 Mar 2001 16:13:00 EST349_ISO-8859-1 It is possible to read Oracle from OS/390, but I cannot provide many details. Look on Oracle Technet - at technet.oracle.com(think you may need to sign up but it is free/ also no www).
Look for Pro*cobol - least that is the language I used on OS390.
Can not provide many specifics....... other than that it is possible [...]
22023 23 30_Re: Read Oracle DB from OS/39011_Jose' Gomez21_Jose_Gomez@WENDYS.COM30_Wed, 7 Mar 2001 16:16:32 -050078_us-ascii I think you would need a product like Datajoiner which is designed to
22047 26 38_BLOB columns versus VARGRAPHIC columns0_32_Gordon.P.PROUTY@ODOT.STATE.OR.US30_Wed, 7 Mar 2001 13:39:39 -0800395_iso-8859-1 We are currently in the beginnings of a project that will move our customer photo's and related data from OS/2 WARP 3 running DB2 for OS/2 V6.1 to the mainframe using DB2 V6 OS/390.
The questions that are being raised are related to the photos (16KB) and the use of BLOB columns versus VARGRAPHIC columns. The only real user requirement so far is a 24/7 read only access. [...]
22074 26 22_-911 Cursor with hold.11_Tom Marcano23_marcano_db2@HOTMAIL.COM30_Wed, 7 Mar 2001 21:44:09 -0000418_- Hello All,
Does anyone know if there is any way to avoid -911 sql error using in my program CURSOR WITH HOLD, I have a program (with declare a cursor with hold) on my table PPP , and my program B try to select some records on the same table , and my program B got -911 sql error (contention with program A) , both programs are bounded with (CS) , so I can not have both program running at the same time. [...]
22101 92 46_Re: Database Creation scripts for UDB V7 on NT19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 7 Mar 2001 15:39:49 -0600784_us-ascii CREATE DATABASE DTPRC001 ON /usr/local/data/db2db CATALOG TABLESPACE MANAGED BY SYSTEM USING ('/usr/local/data/db2db/dtprc001/sprccat') USER TABLESPACE MANAGED BY SYSTEM USING ('/usr/local/data/db2db/dtprc001/sprcdft') TEMPORARY TABLESPACE MANAGED BY SYSTEM USING ('/usr/local/data/db2db/dtprc001/sprctmp') ;
HTH
Phil
On Wed, 7 Mar 2001 10:08:28 -0800, CC Harvest wrote:
>Thanks for the reply. Actually, I want to know how >do you specify the datafiles for those tablespaces, >the buffer pool, etc. A script like Oracle has. >Create database fool >datafile 'dsfh.dbf' >.....; >create tablespace bar; >etc. > >Chris > >--- tim malamphy wrote: >> how about: >> >> create database mydatabase >> >> >> >> >> --- CC Harvest [...]
22194 91 42_Re: Create Tablespace/Index with DEFINE NO14_Grainger, Phil20_Phil.Grainger@CA.COM30_Wed, 7 Mar 2001 21:56:14 -0000460_iso-8859-1 Of course,
The reason for define no in the first place is that with big ERP systems you don't know which datasets are created and which ones are not - end neither should you care!!
You should (in my opinion, and CAs and BMCs!!) you should be able to run utilities like QUIESCE, COPY etc against undefined objects purely because you are running against a SET of objects and really DB2 should handle whether they are defined or not [...]
22286 56 35_Re: AIX 4.3 Manuals - PDF documents13_Sunil Venkata27_SVENKATA@GWMAIL.STATE.NV.US30_Wed, 7 Mar 2001 13:56:39 -0800654_US-ASCII >>> Bob Lewis 03/07/01 12:39PM >>> Hi Anil -
Take a look here:
http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d 2w/en_main
Bob
-----Original Message----- From: Anil Kale [mailto:Usregion10@AOL.COM] Sent: Wednesday, March 07, 2001 1:41 PM To: DB2-L@RYCI.COM Subject: AIX 4.3 Manuals - PDF documents
Hi all!
Does anyone know of a site, where I can download AIX manuals in PDF format. I have seen many sites that have the manuals, but don't have any link to click for download. I am specifically looking for the Command reference. [...]
22343 27 52_data uploading from oracle to db2...immediate reply.17_ravi kumar hassan18_ravibh@HOTMAIL.COM30_Wed, 7 Mar 2001 15:57:13 -0600478_- Hi Folks,
In our shop we are using DB2 V6 on OS390. we have a table in oracle with four columns..... c1, c2, c3, c4. i have the text file from oracle. so i upload into DB2 Table. but db2 table as only three columns. like K1, K2, K3. so i need to combined C1 and C2 of text file and then i need to upload into k1, k2, k3. c1 and c2 of same datatype. is there anyway i can combine C1 and C2, considered as one column and then i can try to upload into db2 table. the [...]
22371 48 42_Re: BLOB columns versus VARGRAPHIC columns9_Bob Lewis23_BLewis@MICROGENERAL.COM30_Wed, 7 Mar 2001 14:09:14 -0800638_iso-8859-1 Gordon -
Check out this little-known IBM product called Datalinks. I'm not sure if it's S390-compliant yet, but it's a pretty neat tool:
http://www.almaden.ibm.com/cs/datalinks/
Bob
-----Original Message----- From: Gordon.P.PROUTY@ODOT.STATE.OR.US [mailto:Gordon.P.PROUTY@ODOT.STATE.OR.US] Sent: Wednesday, March 07, 2001 3:40 PM To: DB2-L@RYCI.COM Subject: BLOB columns versus VARGRAPHIC columns
We are currently in the beginnings of a project that will move our customer photo's and related data from OS/2 WARP 3 running DB2 for OS/2 V6.1 to the mainframe using DB2 V6 OS/390. [...]
22420 144 42_Re: Create Tablespace/Index with DEFINE NO0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 7 Mar 2001 16:16:20 -0600515_us-ascii I'll toss in my "2 cents worth" in with Phil. In my (not so humble ) opinion, the best solution is to generate a non fatal warning, informing you that the TS has not yet been physically created (there is no data and dataset to work with) but the utitlity should ignore those empty TS and continue to successful completion. Abending negates most of the value (to DBA at least) of this option because it requires to much manual intervention from DBA to keep up with status changes in various tables. [...]
22565 76 30_-911 Cursor with hold. (Reply)0_22_scott.goodell@WCOM.COM30_Wed, 7 Mar 2001 16:20:25 -0600486_us-ascii I would suspect one of the two programs would have to be doing updates. I would assume that since you are coding WITH HOLD that this program would also be doing updates. The key would be that you COMMIT often enough to free locks held on the PPP table. Does your program do commits? If not, that would be the first place to start. If you do but still get DEADLOCKs and not just TIMEOUTS then you may have to look into row level locking or doing COMMITS after each update. [...]
22642 128 42_Re: Create Tablespace/Index with DEFINE NO17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM30_Wed, 7 Mar 2001 16:20:00 -0600356_iso-8859-1 Hi Phil!
Since you've chimed in on this, then I'll feel free to as well.
One of the big hits here is for a multi-table tablespace with indexes on multiple tables. If at least one table has had inserts then the Tablespace will be materialized as will all indexes for THAT table, but any other indexes will NOT be materialized. [...]
22771 21 35_Re: AIX 4.3 Manuals - PDF documents9_Anil Kale18_Usregion10@AOL.COM28_Wed, 7 Mar 2001 17:24:00 EST481_ISO-8859-1 Hi Bob!
Nice to hear from you. Guess what ? for the second time, I got sucked into this UDB on AIX thing. First, at Salt lake City and now in Dallas, with IBM. I have all the UDB manuals - that is the link you send me. What I don't have here are the AIX manuals. Now I do access the AIX manuals online, but then I tie up the phone line. So I was looking for some place wher I can download the AIX PDF files. By the way, are you working on UDB on AIX as well [...]
22793 128 42_Re: Create Tablespace/Index with DEFINE NO13_Bright, Randy20_Randy_Bright@BMC.COM30_Wed, 7 Mar 2001 16:32:07 -0600535_iso-8859-1 I agree. In my opinion (emphasize opinion), you should be able to REORG an object that is DEFINE NO when no VSAM object exists. If you do a SELECT against the table, you get SQLCODE100, no rows returned. Why not get "zero rows unloaded, zero rows reloaded", end with condition code zero when you REORG the same object? Same with QUIESCE. Why not just end with condition code zero "it's QUIESCED!" and not worry that the reason it happened so fast was that there is no VSAM dataset to flush the non-existent buffers to. [...]
22922 16 42_Re: BLOB columns versus VARGRAPHIC columns26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU30_Wed, 7 Mar 2001 16:34:21 -0600472_- Down at the bottom of the webpage is "supported platforms". So far, AIX and NT with support for SCO late in 2000? Other platforms on an "as demanded" basis. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
22939 53 26_Re: -911 Cursor with hold.13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU30_Thu, 8 Mar 2001 09:36:06 +1100621_- Tom,
Have a look at the DSNZPARM setting for RELCURHL, the default of YES provides the best concurrency and might help in your situation.
Shaun
-----Original Message----- From: Tom Marcano [mailto:marcano_db2@HOTMAIL.COM] Sent: Thursday, 8 March 2001 8:44 To: DB2-L@RYCI.COM Subject: -911 Cursor with hold.
Hello All,
Does anyone know if there is any way to avoid -911 sql error using in my program CURSOR WITH HOLD, I have a program (with declare a cursor with hold) on my table PPP , and my program B try to select some records on the same table , and my program B got [...]
22993 51 22_-911 Cursor with hold.15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Wed, 7 Mar 2001 16:42:21 -0600738_us-ascii Tom, Add COMMIT command.
Regards
---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 03/07/2001 04:34 PM ---------------------------
Tom Marcano on 03/07/2001 03:44:09 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)
Subject: -911 Cursor with hold.
Hello All,
Does anyone know if there is any way to avoid -911 sql error using in my program CURSOR WITH HOLD, I have a program (with declare a cursor with hold) on my table PPP , and my program B try to select some records on the same table , and my program B got -911 sql [...]
23045 58 26_Re: -911 Cursor with hold.0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 7 Mar 2001 16:50:54 -0600471_us-ascii What level of locking are you using on the table(s). You should be using row level locking. If you are using row locking and 2 programs try to update rows with the same key, then you have a problem and you would want the -911! As someone else pointed out, more frequent commits would definitely help, but you may also want to add code to specifically handle -911, ie retry the update x times before abending, rather than abend immediately after first -911. [...]
23104 61 30_Re: Read Oracle DB from OS/39017_Belfield, Alma G.21_Alma.Belfield@TWA.COM30_Wed, 7 Mar 2001 16:54:59 -0600571_iso-8859-1 I researched this 'product' in Dec, but we haven't installed it. So all this info is based on reading the manuals and discussions with Oracle reps. This product may do more than you need it to - we have IMS online transactions that need to access the Oracle database.
Oracle has a 'product' called Oracle for OS/390 Client which lets you code and run programs on OS/390 with embedded oracle SQL statements to access the Oracle database running on the Unix box. You can't mix DB2 and Oracle SQL in one program because the program has to go thru the [...]
23166 76 42_Re: BLOB columns versus VARGRAPHIC columns0_19_Tim.Lowe@STPAUL.COM30_Wed, 7 Mar 2001 17:03:22 -0600282_us-ascii Gordon, If you are comparing storing data in a VARGRAPHIC column and a BLOB, then a couple of things we have recently been talking about are: With a LOB, there is only 1 row per page (with a minimum 4K page size), and Compression is not supported for LOB tablespaces. [...]
23243 17 56_Re: data uploading from oracle to db2...immediate reply.15_Sydney Brereton21_sbrereton@MMAL.COM.AU30_Thu, 8 Mar 2001 09:41:33 +1030432_US-ASCII Can you get the columns combined on the Oracle side before the text file is created? Either via an Oracle view or by concatenating the columns in the Oracle unload process? HTH Syd.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
23261 20 56_Re: data uploading from oracle to db2...immediate reply.15_Sydney Brereton21_sbrereton@MMAL.COM.AU30_Thu, 8 Mar 2001 09:56:08 +1030457_US-ASCII Oops, I hit the reply key early. Can you write a SAS/REXX/ program to combine the columns from the file? Or build a 4 column table and load that and then combine the columns in DB2 via unload/load, or insert ...select cal1 CONCAT col2... etc.. Many ways to skin this cat, but it depends on the situation. Is this a one-off problem or will it happen often? Are we talking a few hundred rows or millions? HTH Syd [...]
23282 129 40_Re: BLOB columns versus VARGRAPHIC colum64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Wed, 7 Mar 2001 18:12:07 -0600359_ISO-8859-1 Why vargraphic and not varchar? Vargraphic is designed for "DBCS", not "photo"graphic data. If you used vargraphic, you would need to make sure you had an even number of bytes all the time, and everytime you referenced the length field of a vargraphic column, you would have to halve or double it, depending on which way you were moving data. [...]
23412 61 20_Table Comparison SQL11_James Drewe20_James.Drewe@AEXP.COM30_Wed, 7 Mar 2001 16:49:13 -0700466_iso-8859-1 Dear listers
I have an SQL challenge that maybe one of you SQL gurus can help me with.
I have a DB2 application that runs on an OS390 test sub-system that contains many look-alike application environments, or regions. The DB2 structures are the same but there is different data in the regions for various test scenarios. In other words, I have different CREATOR names for the regions (that would be TABSCHEMAs for you mid-range folks). [...]
23474 44 26_Re: -911 Cursor with hold.14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Wed, 7 Mar 2001 19:40:20 -0500639_iso-8859-1 I assume it is a Timeout situation, rather than a Deadlock, since you say Program B is doing selects - so I can only suggest you check & increase the COMMIT frequency for Program A as a first step.
HTH, Greg Palgrave Database Administrator Unisys WEST eMail : greg.palgrave@unisyswest.com.au
> -----Original Message----- > From: DB2 Data Base Discussion List @BANKWEST On > Behalf Of Tom Marcano @BANKWEST > Sent: Thursday, 8 March 2001 05:44 > To: DB2-L@RYCI.COM > Subject: -911 Cursor with hold. > > Hello All, > > Does anyone know if there is any way to avoid -911 [...]
23519 58 25_Re: Stored Procedure Help18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU30_Wed, 7 Mar 2001 18:40:33 -0600367_- Howzit Deborah?
Call DSNTIAR in the SP and print the output to SYSOUT or a dedicated DD in the application environment.
For information, have a look for DSNTIAR in "Application Programming and SQL Guide". Let me know if you need some sample code.
Cheers
Bruce Williamson DB2 Database Administrator DCIS NT Government Darwin NT 0800 [...]
23578 76 24_Re: Table Comparison SQL13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Wed, 7 Mar 2001 16:57:40 -0800693_iso-8859-1 Don't think you can perform joins 'across' subsystems anyway.....except with the a Data joiner.
Ashish.
-----Original Message----- From: James Drewe [SMTP:James.Drewe@AEXP.COM] Sent: Wednesday, March 07, 2001 3:49 PM To: DB2-L@RYCI.COM Subject: Table Comparison SQL
Dear listers
I have an SQL challenge that maybe one of you SQL gurus can help me with.
I have a DB2 application that runs on an OS390 test sub-system that contains many look-alike application environments, or regions. The DB2 structures are the same but there is different data in the regions for various test scenarios. In other words, I have different CREATOR names for the [...]
23655 69 42_Re: Create TableSpace/Index with DEFINE NO12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM30_Thu, 8 Mar 2001 11:58:31 +1100586_- Troy, Yet another voice of agreement, I feel that QUIESCE should be able to cope with this; and issue a warning message rather than abend.
btw:- We down here generate our Quiesces by running a Catalogue query (for a DataBase(s)) through DSNTIAUL, and then massaging the output into a quiesce statement, this way we dynamically pick up the correct set of TableSpaces each time we run quiesce. I am assuming that you are doing something similar. If you need a work-a-round, you could write a REXX to generate a set of quiesce statements from a LISTCAT LEVEL from within the [...]
23725 77 24_Re: Table Comparison SQL23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU30_Thu, 8 Mar 2001 00:59:38 -0000713_iso-8859-1 How about an unload followed by superc compares????-
Andrew Puddy
-----Original Message----- From: James Drewe [mailto:James.Drewe@AEXP.COM] Sent: Thursday, 8 March 2001 9:49 To: DB2-L@RYCI.COM Subject: Table Comparison SQL
Dear listers
I have an SQL challenge that maybe one of you SQL gurus can help me with.
I have a DB2 application that runs on an OS390 test sub-system that contains many look-alike application environments, or regions. The DB2 structures are the same but there is different data in the regions for various test scenarios. In other words, I have different CREATOR names for the regions (that would be TABSCHEMAs for [...]
23803 18 24_Re: Table Comparison SQL15_Sydney Brereton21_sbrereton@MMAL.COM.AU30_Thu, 8 Mar 2001 11:36:17 +1030450_US-ASCII Hi Jim, you could do the compare outside of DB2...unload both tables and get dfsort or PDS or whatever file compare programs you have available to tell you what is different? Just a thought. HTH Syd.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
23822 105 42_Re: Create TableSpace/Index with DEFINE NO12_Troy Coleman19_Colematr@MEIJER.COM30_Wed, 7 Mar 2001 20:30:40 -0500528_US-ASCII Hi Nick, No I don't need your REXX routine. If fact I just wrote a REXX routine to add up all the tracks being used by database for a space report. I needed to wild card the dataset name based on part of the third qualifier. In PeopleSoft I have created a logical database made up of 30+ databases. I needed to know the total per logical instance. The MVS DASD management people did not have such a report. So yes I agree REXX can be handy. As for the imagecopy, quiesce and other utilities Meijer has an in house [...]
23928 85 32_Re: UDB V7.1 ... Export Question18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU30_Wed, 7 Mar 2001 19:07:17 -0600462_- Howzit Randy?
Try this:
EXPORT TO /file.out OF DEL MODIFIED BY chardel coldel, decpt. MESSAGES /Export.msg SELECT * FROM SAMP.TABLE;
Search for chardel in the Command Reference for more info and using ascii/ebcdic codes.
HTH.
Cheers
Bruce Williamson
DB2 Database Administrator DCIS NT Government Darwin NT 0800
On Tue, 6 Mar 2001 12:31:52 -0800, Mohan, Ashish wrote: [...]
24014 87 24_Re: Table Comparison SQL17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT30_Thu, 8 Mar 2001 02:39:12 +0100474_us-ascii Hi, I suppose the owner X of table A in region j as a fixed counterpart in table A of region k, with owner Z; in other words if you have X.A in subsystem j, the you must have Z.A in region k. If you have DDF active in all yours DB2 regions, and CLI is installed, you can write a CLI program (C or C++) doing the job for all the table in this two regions: get all the tables in k order by owner, name; get all the tables in j by owner, name; for every table of [...]
24102 141 40_Re: BLOB columns versus VARGRAPHIC colum12_Philip Dumas15_pdumas@HOME.COM30_Wed, 7 Mar 2001 20:40:21 -0500532_iso-8859-1 The problem with DEFINE NO is that when you run a reorg on a tablespace that has multiple tables that have indexes that have no dataset, the REORG fails. That is our experience with a SAP installation of BW installed on a version 6 os/360 ----- Original Message ----- From: "Todd Burch *****************************************************" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, March 07, 2001 7:12 PM Subject: Re: [DB2-L] BLOB columns versus VARGRAPHIC colum [...]
24244 96 32_Re: UDB V7.1 ... Export Question14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Wed, 7 Mar 2001 20:30:44 -0600481_iso-8859-1 Bruce,
If only it was so easy. From the V7 Command Reference (EXPORT) manual:
Delimiter Restrictions ..... * A delimiter cannot be binary zero, a line-feed character, a carriage-return, or a blank space.
I'd love to know why IBM decided we can't *explictly* turn off the character delimiter. We're DBA's, we know what we're doing - most of the time. :) It may invalidate the file for a DB2 IMPORT, but there *are* other uses for exported data. [...]
24341 23 21_IMPACT-dB methodology5_chris22_hhardy1@HOUSTON.RR.COM30_Wed, 7 Mar 2001 20:48:41 -0800581_iso-8859-1 Hi Folks, http://home.swbell.net/hhardy
We promised several people material on IMPACT-dB, well here it is..... This is our first (public) publication of IMPACT-dB... if you have any questions forward them to me......
Hope this provides enough info as to what IMPACT-dB is and what it is not...
Chris
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
24365 70 25_Re: Stored Procedure Help14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 8 Mar 2001 13:43:54 +1100539_iso-8859-1 Ah, the great "how do I debug an SP" question!
Is there a CEEDUMP in the WLM SPAS and lots of DISPLAY statements? Ah, me, looks like you'll have to click on http://www-4.ibm.com/software/data/db2/os390/spb/exciting/ and follow the link to "How do I debug my stored procedures?"
/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Morris, Deborah [mailto:DMorris@UNCH.UNC.EDU] Sent: Thursday, 8 March 2001 6:12 To: DB2-L@RYCI.COM Subject: [DB2-L] Stored Procedure Help [...]
24436 100 24_Re: Table Comparison SQL14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Thu, 8 Mar 2001 13:57:55 +1100363_iso-8859-1 Princeton have a product named 'Compare for DB2'.
Alternatively, I have an edit macro REXX that can exclude sets of duplicate lines based on various (but simple) criteria. In your case it could be "a duplicate row exits in each of the 16 sources". You then have to make your own judgement about the lines that are not excluded. Interested? [...]
24537 32 42_S04E - error while creating Partitioned IX7_Sri Sri20_sri_db2l@HOTMAIL.COM30_Wed, 7 Mar 2001 20:58:04 -0600427_- Dear List ,
We are @ DB2 OS/390 V6.
The following is the error message i got while creating a partitioned index.
The system or user abend S04E R=00E50013 was issued. From compile unit DSNTEP2 at entry point DSNTEP2 at compile unit offset +0000131
It is a segmented table earlier. I am trying do 10 partitions. Create tablespace is successful. This error message i got at index creation time. [...]
24570 54 24_Re: Index not being used16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 8 Mar 2001 09:37:48 +0530603_- James,
It seems this is the case of data type/length mismatch of your WHERE predicate. I saw cases like this, if i remember correctly. Which version DB2 UDB(if not V4 or below) for OS/390 you are running.
HTH Regards, Sanjeev
> -----Original Message----- > From: Wang.James [SMTP:Wang.James@AAA-CALIF.COM] > Sent: Wednesday, March 07, 2001 11:58 PM > To: DB2-L@RYCI.COM > Subject: Index not being used > Importance: High > > Help ... Why ... > > We have a batch program that accesses one DB2 table with index. It takes > excessive time. > > When job is running, DB2 Activity [...]
24625 117 46_Re: Database Creation scripts for UDB V7 on NT10_CC Harvest19_ccharvest@YAHOO.COM30_Wed, 7 Mar 2001 21:18:10 -0800697_us-ascii Phil, Thanks a lot for the script.
Chris
--- "Philip Nelson (DBA)" wrote: > CREATE DATABASE DTPRC001 ON /usr/local/data/db2db > CATALOG TABLESPACE MANAGED BY SYSTEM > USING ('/usr/local/data/db2db/dtprc001/sprccat') > USER TABLESPACE MANAGED BY SYSTEM > USING ('/usr/local/data/db2db/dtprc001/sprcdft') > TEMPORARY TABLESPACE MANAGED BY SYSTEM > USING ('/usr/local/data/db2db/dtprc001/sprctmp') > ; > > HTH > > Phil > > On Wed, 7 Mar 2001 10:08:28 -0800, CC Harvest wrote: > > >Thanks for the reply. Actually, I want to know how > >do you specify the datafiles for those tablespaces, > >the buffer pool, etc. A script like Oracle has. > >Create [...]
24743 82 39_Re: String constant too long (SQL0102N)10_Ron Parker15_sysop@SCBBS.COM30_Wed, 7 Mar 2001 21:47:21 -0800647_us-ascii Thank you, thank you, thank you. This does the trick.
-ron
"Vaughan, Mike" wrote:
> There's a couple different ways to resolve this. My suggestion would be to use a host variable instead of a literal for the long-field. For example, In place of what you currently have, you could try... > > sql = "insert into table (MESSAGE) values (?)"; > PreparedStatement s = dbCon0.prepareStatement(sql); > s.setString(1,message); > s.executeQuery(sql); > > Don't quote me on the exact syntax, but that should be pretty close. Other options involve breaking the text down into smaller chunks (each under 254 characters) and [...]