1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2001, week 1
2 106 34_Re: Data manipulation during load?18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM30_Wed, 1 Aug 2001 11:03:41 +0530322_- Hi James,
If the table is loaded with 9 chars for the 10 char column then the first char would be space, followed by the 9 chars from the i/p file. Now,the update you suggest would be....
Update table set col = '0'||col
would result in col => '0 abcdefghi'
right? Space is a valid char. [...]
109 98 36_Re: How many relations are too many?15_Regan Galbraith28_Regan.Galbraith@SANLAM.CO.ZA30_Wed, 1 Aug 2001 08:56:34 +0200545_us-ascii In my experience , the real killer has been when you add an extra level of children. That is to say, Grandparent to Parent to Child, as it were, all with cascade delete. One of the DB's we have 68 tables connected via cascade delete, with acceptable response ( to that business unit). However, when they're guys added 2 more tables, "down a level" as it were - i.e. cascade delete children of cascade delete children to the major table. I attach a quote from the db2 manuals for OS/390 (v5 I think) that I quoted in an analysis of [...]
208 105 34_Re: Data manipulation during load?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 1 Aug 2001 12:43:21 +0530271_- I have been following this thread right from the first mail but i had only one idea of loading it and the updating the record preceeding with '0' but that will write the huge amount of logs as total no. of rows are 15M. This did not look efficient solution to me. [...]
314 65 28_Re: Global temporary tables.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 1 Aug 2001 12:48:49 +0530338_- Rick,
GTB dies after application commit, so i presume you must have taken care of all its functionalities. As far as using the method explained below is concerned, i believe GTB is quite stable (which version you are in ?). Just ensure you have sufficient space in the workfile tablespace to store the intermediate results. [...]
380 92 36_Siebel and DB2 on OS/390 Experiences15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Wed, 1 Aug 2001 09:44:49 +0200556_iso-8859-1 Philip,
Is there a Siebel DB2 listserve out ther too? I would be very much interested.
Kind regards,
Jaap Slot,
Data Service Center Rabobank ICT
tel: 030 215 2220 fax: 030 215 3003 mob: 06 5374 0167 mailto:J.P.Slot@rf.rabobank.nl
-----Original Message----- From: Philip Gunning [mailto:Philip.Gunning@QUEST.COM] Sent: Wednesday, August 01, 2001 3:40 AM To: DB2-L@RYCI.COM Subject: Re: Peoplesoft on DB2 on OS/390 Experiences [...]
473 49 33_Re: How do I do Date Arithmetic ?16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 1 Aug 2001 13:18:49 +0530363_- You need to identify what is your requirement...
i) Difference of hours/minutes/seconds ii) Difference in hours/minutes/seconds
For finding out i), you can simply use scalar function like HOUR, MINUTE and SECOND but for ii) you need to apply some mathematical standard conversions after finding out the difference between number of days like [...]
523 32 26_Re: Amazing -204 error !!!14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 Aug 2001 03:19:19 -0500623_- Can you drop tablespace Z100STST.DBTICMZ?
BTW (since you're still on DB2 V4) are you aware that V5 is being withdrawn from marketing on 31 Dec 2001 http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=901-184
James Campbell
On Tue, 31 Jul 2001 19:46:02 -0700, Manish Lall wrote:
>Hi All , > > I checked everything , The VSAM Dataset is not >migrated , it's there and the high level qualifier etc >is correct , believe me there is no error on these >aspect ,I'm having the sysadm right and that i have >done the -dis db and the tablespace is in RW mode , i >did select [...]
556 20 26_Re: Amazing -204 error !!!14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Wed, 1 Aug 2001 03:40:23 -0500392_- Idle curiosity, but is the result of SELECT LENGTH(NAME) FROM SYSIBM.SYSTABLES WHERE NAME='DBTICMT_ZAP'; equal to 11? My wondering is along the lines of: did someone create the table as CREATE TABLE Z100STST."DBTICMT_ZAP " (... (note the space at the end of the table's name). In which case it would appear that the code for DML ignores the space at the end, but code for DDL doesn't. [...]
577 46 32_Re: Monitoring DB2 on NT servers14_Vassie, Edward21_Edward_Vassie@BMC.COM30_Wed, 1 Aug 2001 04:42:25 -0500378_iso-8859-1 The BMC Patrol product line includes a knowledge module for comprehensive monitoring of DB2 on NT.
There are also knowledge modules for many raid subsystems, transaction monitors, web server, etc etc. Thresholds can be set for error conditions that are relevant to your business. Automatic responses can cure many problems before your users are impacted. [...]
624 24 18_Connection Pooling21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET30_Wed, 1 Aug 2001 19:02:09 +0800358_big5 Dear all,
I find that the term 'Connection Pooling' appears in DB2 for OS/390, Websphere and DB2 Connect. Therefore, I am very confused. Can someone advise me the difference or inter-relationship of 'Connection Pooling' implemented in these 3 software? In addition, what is the relationship between 'Connection Pooling' and inactive thread? [...]
649 53 22_AW: Connection Pooling12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 1 Aug 2001 13:19:22 +0200887_big5 Try the following:
What is the connection manager? Tips for using connection pooling: WebSphere Application Server URL: http://www-4.ibm.com/software/webservers/appserv/doc/v35/ae/...
HTH.
With kind regards - mit freundlichen Grüssen, Georg H. Peter ----------------------------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Li, Chak Lung Dominic [mailto:seddba@HK.SUPER.NET] Gesendet am: Mittwoch, 1. August 2001 13:02 An: DB2-L@RYCI.COM Betreff: Connection Pooling
Dear all,
I find that the term 'Connection Pooling' appears in DB2 for OS/390, Websphere and DB2 Connect. Therefore, I am very confused. Can someone advise me the difference or inter-relationship of 'Connection Pooling' implemented in these 3 software? In addition, what is the relationship between 'Connection Pooling' and inactive [...]
703 51 32_Re: Monitoring DB2 on NT servers19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Wed, 1 Aug 2001 12:20:39 +0100321_iso-8859-1 On Wed, 1 Aug 2001 04:42:25 -0500, Vassie, Edward wrote:
I believe the latest version of the Database-GUYS tools allow you to remotely monitor DB2 on NT, assuming you have a Unix server to run the software on it the first place.
We have got the complete set of GUYS and find them excellent. [...]
755 108 38_Re: UDB and Archive Logging (USEREXIT)11_Hamar, Bela22_Bela.Hamar@VARETIS.COM30_Wed, 1 Aug 2001 13:25:27 +0200699_us-ascii Hi Bill,
the user exit program is called by DB2 as a normal program with several parameters. So, you can execute it from a command shell (or command interpreter). The parameters are (see the db2uext2.cadsm):
db2uext2 -OS -RL -RQ -DB -NN -LP -LN [-LSlogsize -SPstartingpage] [-AP]
where: os = operating system release = DB2 release request = 'ARCHIVE' or 'RETRIEVE' dbname = database name nodenumber = node number logpath = log file path logname = log file name logsize = log file size (optional) startingpage = starting offset in 4K page unit (optional) adsmpasswd = ADSM password (optional) [...]
864 50 26_Re: Amazing -204 error !!!16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 1 Aug 2001 17:02:58 +0530262_- Hi James,
I did think about some control characters (can be looked with HEX ON) but never thought about blanks but still its hard to believe. I am not sure but if you are telling, then it can be. If it is like that, i have added a new thing today. [...]
915 94 32_Re: Monitoring DB2 on NT servers15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL30_Wed, 1 Aug 2001 13:31:46 +0200589_iso-8859-1 Edward,
Do you have some information about a tool to monitor DB2 Connect? (PolarSentinel if I am correct). Is ti possible to only use that tool or do I need a bundle?
Kind regards,
Jaap Slot
Data Service Center Rabobank ICT
tel: 030 215 2220 fax: 030 215 3003 mob: 06 5374 0167 mailto:J.P.Slot@rf.rabobank.nl
-----Original Message----- From: Vassie, Edward [mailto:Edward_Vassie@BMC.COM] Sent: Wednesday, August 01, 2001 11:42 AM To: DB2-L@RYCI.COM Subject: Re: Monitoring DB2 on NT servers [...]
1010 40 39_Re: DB2 Version 5 end of service coming12_McKown, John22_JMckown@HEALTHAXIS.COM30_Wed, 1 Aug 2001 08:04:11 -0500299_- Roger, Did they announce end-of-support as well? If so, when? Of course, I think the proper time to start planning a migration is when the next release is announced and sufficient information is make available. Even if you don't need or actually plan to upgrade. It is better to be prepared. [...]
1051 59 39_Re: DB2 Version 5 end of service coming50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Wed, 1 Aug 2001 09:17:42 -0400622_iso-8859-1 It would be helpful to know the costs of going from v5 to v6 or from v5 to v7.
Bob Knight
-----Original Message----- From: McKown, John [mailto:JMckown@HEALTHAXIS.COM] Sent: Wednesday, August 01, 2001 9:04 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Version 5 end of service coming
Roger, Did they announce end-of-support as well? If so, when? Of course, I think the proper time to start planning a migration is when the next release is announced and sufficient information is make available. Even if you don't need or actually plan to upgrade. It is better to be prepared. [...]
1111 18 26_Re: Amazing -204 error !!!0_26_truman.g.brown@VERIZON.COM30_Wed, 1 Aug 2001 09:20:58 -0400435_us-ascii Manish,
This may sound dumb, but if you haven't already tried it STOP the application's logical database (not the dependent objects), then try to DROP the objects.
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.
1130 65 39_Re: DB2 Version 5 end of service coming21_Rechsteiner, Tom (TH)20_trechsteiner@DOW.COM30_Wed, 1 Aug 2001 09:23:03 -0400362_iso-8859-1 DB2 Version PID Generally Available Withdrawn from marketing End of service Version 3 5685-DB2 17 December 1993 29 February 2000 01 January 2001 Version 4 5695-DB2 30 November 1995 01 December 2000 31 December 2001 Version 5 5655-DB2 27 June 1997 31 December 2001 31 December 2002 Version 6 5645-DB2 25 June 1999 Version 7 5675-DB2 30 March 2001 [...]
1196 104 36_DB2 Control Center and PluginEx.java15_Donnie Woodruff30_dwoodruf@CI.NEWPORT-NEWS.VA.US30_Wed, 1 Aug 2001 09:44:08 -0400582_Windows-1252 DB2L'ers,
I am looking at extending the DB2 Control Center v7.1. IBM has provided sample source code with the PluginEx.java file, but I am unable to get this working. The documentation provided with the sample code is not too helpful...so I am looking for some help.
Has anyone tried to extend the DB2 Control Center using JAVA? What I am trying to do is add an object to the ToolBar, but after I have compiled to a PluginEx.class file, stored it in the db2plug.zip file, and copied to a directory in my classpath -- then fire up the Control Center, [...]
1301 119 39_Re: DB2 Version 5 end of service coming17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Wed, 1 Aug 2001 09:05:12 -0500578_us-ascii This was sent to me from a coworker, which he found in one of the IBM news letters.
IBM Service for DB2 UDB Version 5.2 has Ended
As of June 30, 2001, IBM is no longer providing entitled support for DB2 UDB Version 5.2. The implications of this are that IBM service representatives will no longer handle Version 5.2 problems, and no new Version 5.2 FixPaks will be released after 2001. In the mean time, FixPak 16 is scheduled for release on July 17, 2001, and FixPak 17 (the final Version 5.2 FixPak) is scheduled for release on October 26, [...]
1421 30 26_DB2 Performance monitoring17_jennifer jennifer22_jenni_jeni@HOTMAIL.COM30_Wed, 1 Aug 2001 14:20:35 +0000513_- Hi All , this is Jennifer again with the doubts. This is the area where I m facing challenge as a novice and seeking all your support and advice as a novice. I got responses from Vijay, Sanjeev, Roger, Terry , Trodd and all others. I m thankful to them also. I requested in my previous mail to the list about this. I m elaborating the doubt below. I m in the process of loading the data in the production sub system. There will be a need to monitor the performance of the system once the system runs for a [...]
1452 72 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM30_Wed, 1 Aug 2001 07:25:08 -0700340_us-ascii Hi All,
i tried everything the group suggested ,querying the length , trying todrop the corresponding tablespace and also bystopping the application logical database and not its object and trying to drop the object , nothing works. pasting the output below.
Really no clue at all what to do next. Thanks, Manish [...]
1525 137 34_Re: Data manipulation during load?9_Wu, James13_jwu@KRAFT.COM30_Wed, 1 Aug 2001 09:30:40 -0500529_iso-8859-1 Not necessary. It depends on how you load the table. if the 9-char string in the input file is at position 101, and if you specify the load control card as
COL POSITION(101) CHAR(9) (you can use CHAR(10) if position 110 is blank)
then after the load, the blank is at the end of the 10-char column, not the beginning, e.g. '123456789' will be loaded as '123456789 '. SET col = '0'||col will become '0123456789'. The blank at the end will be truncated because character string is always LEFT-JUSTIFY. [...]
1663 92 26_Re: Amazing -204 error !!!11_Jeff Schade21_JSCHADE@MAIL2.PCH.COM30_Wed, 1 Aug 2001 10:42:39 -0400490_US-ASCII Just a stab in the dark but have you verified that the table name does not contain an lower-case characters?
Jeff Schade PCH 516-944-2673 jschade@pch.com
>>> db2list@YAHOO.COM 08/01/01 10:25AM >>> Hi All,
i tried everything the group suggested ,querying the length , trying todrop the corresponding tablespace and also bystopping the application logical database and not its object and trying to drop the object , nothing works. pasting the output below. [...]
1756 113 26_AW: Amazing -204 error !!!12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 1 Aug 2001 16:57:41 +0200621_iso-8859-1 Manish,
I did not follow this -204-thread in the past days. And therefore i apologize if someone had asked the following already....
What did you get when you SELECT CREATOR, NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'DBTICMT_ZAP';
Really the value Z100STST.DBTICMT_ZAP ?
With kind regards - mit freundlichen Grüssen, Georg ----------------------------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Manish Lall [mailto:db2list@YAHOO.COM] Gesendet am: Mittwoch, 1. August 2001 16:25 An: DB2-L@RYCI.COM Betreff: Re: Amazing -204 error !!! [...]
1870 55 54_Visual Studio, DB2 Connect, and DB2 on OS/390 anybody?14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US30_Wed, 1 Aug 2001 11:01:32 -0400591_us-ascii Anybody out there using DB2 Connect to talk from PC applications written using VMS Visual Studio to DB2 on OS/390?
We have the freebie developer's edition of DB2 Connect (latest version) and routinely experience 5-10 seconds lag times conencting to DB2. I wonder if the problem is with Db2 Connect, DB2 on OS/390 or Visual Studio. Is it possible that the pay-for DB2 Connect seats don't have a connect time lag problem? If this time-lag problem is inherent in DB2 Connect, then how does anybody write C/S apps using DB2 Connect? Would it be better to use MS' DB2 driver [...]
1926 121 26_Re: Amazing -204 error !!!9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Aug 2001 11:15:16 -0400493_us-ascii Hi,
Couldit be that DBTICMT_ZAP is a view or alias , hence confusing your drop syntax?
Try:
SELECT LENGTH(NAME), TYPE FROM SYSIBM.SYSTABLES WHERE NAME='DBTICMT_ZAP';
Colin
Manish Lall cc: Sent by: DB2 Subject: Re: Amazing -204 error !!! Data Base Discussion List
08/01/2001 10:25 AM Please respond to DB2 Data Base Discussion List [...]
2048 154 26_Re: Amazing -204 error !!!14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Wed, 1 Aug 2001 16:20:51 +0100482_iso-8859-1 Rather, what do you get when you SELECT CREATOR, NAME, TYPE FROM SYSIBM.SYSTABLES WHERE NAME = 'DBTICMT_ZAP' ?
Are you certain the table is not an alias?
Marcus 'The views expressed are my own and do not necessarily represent the views or policy of my employer, Lloyds TSB Bank plc.'
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: 01 August 2001 15:58 To: DB2-L@RYCI.COM Subject: AW: Amazing -204 error !!! [...]
2203 53 58_Re: Visual Studio, DB2 Connect, and DB2 on OS/390 anybody?12_Myron Miller22_myronwmiller@YAHOO.COM30_Wed, 1 Aug 2001 08:25:56 -0700439_us-ascii I don't know about VMS Visual Studio connections. But I have users and programmers using DB2 Connect with VB, Access, JAVA, Powerbuilder, EXCELL and none of them experience connection times more than a fraction of a second. And from what I know about DB2 connect, it doesn't make any difference if you have the "freebie" version or the paid for version, the connection mechanism is the same. Just different licensing issues. [...]
2257 166 26_Re: Amazing -204 error !!!15_BARCLAY RICHARD30_richard.barclay@FORTISBANK.COM30_Wed, 1 Aug 2001 17:28:00 +0200611_iso-8859-1 Is this a table? could it be an ALIAS?
Try
> SELECT CREATOR, NAME, TYPE FROM SYSIBM.SYSTABLES > WHERE NAME = 'DBTICMT_ZAP'; > Richard
> -----Original Message----- > From: Peter, Georg [SMTP:G.Peter@DZBW.DE] > Sent: woensdag 1 augustus 2001 16:58 > To: DB2-L@RYCI.COM > Subject: AW: Amazing -204 error !!! > > Manish, > > I did not follow this -204-thread in the past days. And therefore i > apologize if someone had asked the following already.... > > What did you get when you > SELECT CREATOR, NAME FROM SYSIBM.SYSTABLES > WHERE NAME = 'DBTICMT_ZAP'; > > Really the value [...]
2424 148 58_Re: Visual Studio, DB2 Connect, and DB2 on OS/390 anybody?12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Wed, 1 Aug 2001 11:36:18 -0400539_iso-8859-1 Greg,
I'm not sure about the visual studio product, but a lot of the tools bring down huge chunks of the DB2 catalog as meta data. You can check the thread on the host to see what kind of activity is being generated. A while ago, I ran runstats on the DB2 Catalog and response time in MSquery went from the 10-12 second range down to 1-2 seconds. After I ran runstats, I noticed that the queries were using indices (instead of TS scans on each catalog table). If you have a large catalog you might want to look into [...]
2573 97 58_Re: Visual Studio, DB2 Connect, and DB2 on OS/390 anybody?15_Philip, Sibimon20_SPhilip@CSXLINES.COM30_Wed, 1 Aug 2001 11:34:26 -0400331_- I too see DB2 connect take few seconds to connect to OS/390 first time. Once it is connected then it runs O.K. We have another ODBC driver which connect very fast. I think DB2 connect has more functionality and so it takes some time to load into memory. I can see my hard drive spins for few seconds when I use DB2 connect. [...]
2671 36 30_Need 2 DB2 Systems Programmers15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM30_Wed, 1 Aug 2001 10:35:47 -0500380_iso-8859-1 Hi all. Thank you for allowing me to post within your group.
If you or anyone you may be an acquaintance with is a DB2 Systems Programmer and is looking, I have two opportunities open with my client.
Position - DB2 Systems Programmer Type - Full-time Where - On-site/Phoenix, AZ Start Date - ASAP Pay - up to 90k for top candidates + bonus + sign-on [...]
2708 17 26_Re: Amazing -204 error !!!9_Jim Ruddy18_jaruddy@US.IBM.COM30_Wed, 1 Aug 2001 11:03:11 -0500319_- Looks like you have a serious problem here. Open a problem with the support center - from the SQLERRD1 info it looks like you are trying to drop a child table but the parent table is missing in the catalog.
V4 goes out of service the end of this year.
Jim Ruddy DB2 for z/OS and OS/390 Development [...]
2726 194 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM30_Wed, 1 Aug 2001 09:08:13 -0700456_us-ascii Hi all,
As u all have suggested tried all that ,but still i stand where i was. did the following test and their results are pasted below.I also ran check Index on both the Indexes on systables and found no problem with them No lower case in tablename also .Please see the output of both the query below.Any more suggestions. Thanks, Manish Lall SELECT CREATOR, NAME,LENGTH(NAME),TYPE FROM SYSIBM.SYSTABLES WHERE NAME = 'DBTICMT_ZAP' ; [...]
2921 23 38_Stored Porcedure Builder & Schema Name11_jim keister22_jkeister@ALTAVISTA.NET30_Thu, 2 Aug 2001 00:10:19 +0800210_iso-8859-1 Can I pass an SQL SET CURRENT SQLID = 'schemaname' statement within a stored procedure to qualify all unqualified tables? If not, is there another statement that I should be using?
Thanks, Jim
2945 58 49_Data manipulation in LOAD - Next problem: Varchar0_20_Jones.H@GRAINGER.COM30_Wed, 1 Aug 2001 11:16:00 -0500298_- V5 DB2 for OS/390 using IBM load Utility. THANKS for the ideas on appending '0' to the front of a character input load field. The consensus is: Nope. Can't do it using SYSPUNCH. Best solutions were to use IEBGENER or SORT to read the tapes and write out a load file with the modified field. [...]
3004 123 38_Re: [Fwd: BMC to pay for v7 utilities]14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Wed, 1 Aug 2001 11:18:48 -0500561_iso-8859-1 Gerry:
Obviously, we have a difference of opinion. I agree that reducing TCO (as a general concept) is not baloney, but IBM is trying to have it both ways. First they say let IBM offer you some tools for DB2 that cost less than the leading ISVs (BMC and CA). But this is definitely not a TCO discussion, this is an initial cost of ownership (ICO) discussion. Sure, the IBM tools are cheaper - but they are also a lot less functional than the leading ISVs today. Meaning that DBAs are less productive using the IBM "stuff" than they would [...]
3128 29 16_Buffer Pool Tool24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Wed, 1 Aug 2001 09:44:20 -0700612_- Hi Everyone!
I'm trying to run the Buffer Pool Tool from Responsive Systems on a production system during our peak load time. When I specify MAXDATA=2000, the collector stops after 13 minutes and displays the following statistics: Number of records collected is..... 33715074 Number of records lost is.......... 6520
I'd like the collector to run for 1 hour, but whenever I try to set MAXDATA to a value greater than 2000, the collector immediately ends with the message: *** Invalid MAXDATA specified . I've set the SYSDATA to go directly to tape, and I need to know how to override [...]
3158 84 53_Re: Data manipulation in LOAD - Next problem: Varchar15_Robert Lawrence21_rlawrence@BOSCOVS.COM30_Wed, 1 Aug 2001 12:55:54 -0400626_iso-8859-1 yes sort can look at the inrec/outrec parameters hth and good luck Bob Lawrence DBA Boscov's Dept Stores LLc
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jones.H@GRAINGER.COM > Sent: Wednesday, August 01, 2001 12:16 PM > To: DB2-L@RYCI.COM > Subject: Data manipulation in LOAD - Next problem: Varchar > > > V5 DB2 for OS/390 using IBM load Utility. > THANKS for the ideas on appending '0' to the front of a character > input load field. The consensus is: Nope. Can't do it using SYSPUNCH. > Best solutions were to use IEBGENER [...]
3243 43 15_Reg Index usage22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM30_Wed, 1 Aug 2001 12:56:46 -0400442_us-ascii Hi Everybody:::
Can anyone help me out with this simple SQL:
SELECT COUNT ( * )
FROM TABLE1 WHERE ( COL2 = :WS-OUT AND COL1 IN ('CC','SS'))
The index on table called Table1 which is DEFINED in the following order COL1 COL2 COL3
I wanted to know how db2 accesses the index during execution (ie In which ORDER)? Will it be - FIRST COL1 then COL2 or FIRST COL2 then COL1. [...]
3287 17 53_Re: Data manipulation in LOAD - Next problem: Varchar13_Harry Woelfer27_Harry_Woelfer@MCCORMICK.COM30_Wed, 1 Aug 2001 13:21:50 -0400448_us-ascii Using INREC or OUTREC, the sort utility can reformat the record to put a two-byte length value in front of each VARCHAR field. But it can only insert a constant length value -- presumably, the maximum length for the field. What you'd really like to do is set the length to reflect how much data is actually in the field. I don't know how you'd do that without writing a program. I'll be curious to see what other suggestions you get. [...]
3305 90 19_Re: Reg Index usage22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM30_Wed, 1 Aug 2001 13:31:44 -0400288_us-ascii I ran the explain and it says that it matches the 2 existing index columns but does not specify which order it matches. Also dont you think that as the where predicate is using col2 first, so is there a POSSIBILITY that DB2 accesses table with COL2 first. Please suggest... [...]
3396 24 49_Data manipulation in LOAD - Next problem: Varchar13_Jaydeep Ghosh29_Jaydeep_Ghosh@PROGRESSIVE.COM30_Wed, 1 Aug 2001 13:36:05 -0400332_us-ascii Hello Hayden ,
Is SAS an option ? If so , then it can be handled easily and efficiently . The SAS job would ; - read the input file into respective vars - get the length for the 'variable length field' - put that two byte binary field ( containing the length ) before the actual field , and create the output . [...]
3421 117 34_DB2 DBA job DALLAS - NO H1-B or F19_Sue Young20_sueyoung@AIRMAIL.NET30_Wed, 1 Aug 2001 13:13:35 -0500603_iso-8859-1 JOB OPPORTUNITY
DB2 DBA - Technical Specialist
* Develop and enhance Customer Warehouse systems in distributed MVS environment * Provide technical support for Corporate Database in a DB2 environment * Review maintenance procedures * Evaluate and determine proper technical solutions * Interface effectively with other IT groups
Skills required: COBOL ( 7 years) DB2, SQL, Platinum and/or IBM DB2 utilities Work experience with large databases MVS, JCL, TSO/ISPF and mainframe utilities able to assume DBA role immediately Stong analytical and problem solving skills [...]
3539 52 20_Re: Buffer Pool Tool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Wed, 1 Aug 2001 13:56:48 -0400314_ISO-8859-1 Fritz, First, you are running an older version of the software that has a max collection size of 2 Gig. The current version has a max collection size of 16 Gig. This max size of 2000 for your older version cannot be over-ridden. If you have any additional question please call us at (732) 972-1261 [...]
3592 46 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM30_Wed, 1 Aug 2001 11:00:29 -0700536_us-ascii Hi Ruddy ,
Thanks for pointing that out , As u said will open a ticket with IBM regarding this . Once the error is rectified will inform the group what actually was wrong.
Rgds, Manish Lall --- Jim Ruddy wrote: > Looks like you have a serious problem here. Open a > problem with the support > center - from the SQLERRD1 info it looks like you > are trying to drop a child > table but the parent table is missing in the > catalog. > > V4 goes out of service the end of this year. [...]
3639 68 26_Re: Amazing -204 error !!!12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Wed, 1 Aug 2001 14:24:50 -0400572_us-ascii look at II08219 on IBMlLINK. Maybe your problem.
Manish Lall @RYCI.COM> on 08/01/2001 02:00:29 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Amazing -204 error !!!
Hi Ruddy ,
Thanks for pointing that out , As u said will open a ticket with IBM regarding this . Once the error is rectified will inform the group what actually was wrong. [...]
3708 20 16_Read only cursor15_Randall Barbour19_rbarbour@HUMANA.COM30_Wed, 1 Aug 2001 13:04:54 -0500537_- I need a clarification of the use of FOR FETCH ONLY in a COBOL program with no dynamic SQL. I have previously thought that I should always code my cursors with this. However, I've recently been told it doesn't matter in a program where the SQL is static. The optimizer knows it's a read-only cursor and will treat it as such. I need the real answer and can not find it in the manuals. Will changing COBOL programs that do not have this clause to include it, improve performance and reduce locking etc? We are on version 5 of DB2. [...]
3729 54 22_Re: Connection Pooling13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Wed, 1 Aug 2001 13:38:34 -0500593_big5 Connection pooling can be used for distributed apps (which uses DAT's - database access threads). Basically, when a remote UOW concludes it's work (does a commit or disconnect), the thread is no longer active. If connection pooling is enabled, the thread becomes inactive and waits for some other transaction that needs a thread. Saves a lot of thread creation overhead. There are some ZPARM parameters that need to be set to use this. CMTSTAT in panel DSNTIPR should be set to "inactive". Also make sure the idle thread timeout and pool thread timeout parms are set to a low number [...]
3784 62 58_Re: Visual Studio, DB2 Connect, and DB2 on OS/390 anybody?13_McHugh, Gerry21_MchughG@DIVINVEST.COM30_Wed, 1 Aug 2001 13:48:15 -0500485_iso-8859-1 There are some parms you can plug into the DB2 CLI/ODBC file on the DB2 Connect side to either limit the amount of catalog data sifted through. Check out CLISCHEMA, SCHEMALIST, TABLETYPE, SYSCHEMA, DBNAME in the UDB & DB2 Connect Install and Config Guide GC09-2857-00, Chapter 11. Or create a subset of the catalog with DB2OCAT, a GUI utility you can download from the IBM website. Read Appendix G in the DB2 Connect Users Guide SC09-2838-00. Explains the whole thing. [...]
3847 18 20_Re: Buffer Pool Tool12_Brian Kerber19_bkkerber@US.IBM.COM30_Wed, 1 Aug 2001 19:24:00 +0100462_us-ascii Fritz,
Try setting the TIMEOUT parm for the number of minutes you want to run. I generally run mine with 90 in TIMEOUT(90 minutes) with a MAXDATA=900 and run it off to disk without a problem.
brian
================================================ 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.
3866 100 53_Re: Data manipulation in LOAD - Next problem: Varchar15_Blaicher, Chris22_Chris_Blaicher@BMC.COM30_Wed, 1 Aug 2001 14:00:42 -0500452_iso-8859-1 My goodness, you are going through a lot of hoops that you could avoid.
If this is a one time thing, I do not have much help for you, but if you are going to do this often, you might want to look at the BMC LOADPLUS for DB2 utility. It supports a standard input type of CHAR TRIM which truncates the trailing blanks from the input string value before assigning the value to the column and setting the length for VARCHAR columns. [...]
3967 89 20_Re: Read only cursor14_Richard Yevich26_Richard_Yevich@YLASSOC.COM30_Wed, 1 Aug 2001 14:18:55 -0500391_iso-8859-1 Technically, all cursors should be coded as FOR FETCH ONLY or FOR UPDATE OF. Be precise!
However, that is not generally done. The problem is with ambiguous cursors, which you can find in the manual - when DB2 cannot truly determine that a cursor is read only.
Bottom line: with static SQL, it can make a difference with lock avoidance depending on many things. [...]
4057 41 20_Re: Buffer Pool Tool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Wed, 1 Aug 2001 16:03:00 -0400362_ISO-8859-1 No, this is not correct. If the 2 gig limit has been reached (maxdata=2000), the timeout value has no effect. setting maxdata=900 will terminate the collector even sooner than the current 2000 Fritz used.
Since this is a Responsive Systems product, I believe my previous answer to Fritz is correct
Joel Goldstein Responsive Systems [...]
4099 17 38_Re: [Fwd: BMC to pay for v7 utilities]0_17_JTonchick@AOL.COM28_Wed, 1 Aug 2001 16:40:19 EDT368_US-ASCII What makes this whole V7 utility separate cost item a real sham, is that if you buy DB2 UDB for UNIX, the utilities are still included in the cost of the database! Only for DB2 for OS/390 & z/OS is this pricing experiment being attempted. We're V5 now, and will probably migrate to V6 and stay there until the V& utility pricing issue has been resolved. [...]
4117 66 20_Re: Buffer Pool Tool24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Wed, 1 Aug 2001 14:07:33 -0700601_- Thanks, Joel.
I've been told that we're running with version 6.0. I've asked the folks in software to order the latest version. In the meantime, I'm reluctant to do any tuning base on 13 minutes of activity.
Fritz
> -----Original Message----- > From: Joel Goldstein [SMTP:joel_goldstein@COMPUSERVE.COM] > Sent: Wednesday, August 01, 2001 10:57 AM > To: DB2-L@RYCI.COM > Subject: Re: Buffer Pool Tool > > Fritz, > First, you are running an older version of the software that has a max > collection size of 2 Gig. The current version has a max collection size > of > 16 Gig. [...]
4184 132 26_Re: Amazing -204 error !!!16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Wed, 1 Aug 2001 22:20:46 +0100659_us-ascii Mannish,
I had a gander through IBMLink - I finally managed to login after weeks of frustration, and I found the following:
APAR#: II08219
Abstract
SQLCODE -204 ON DROP TABLE (TABLE EXISTS IN SYSIBM.SYSTABLES)
Error Description DROP TABLE received SQLCODE204 sqlcode = -204 error: vwvdb2.tncbse is an undefined name sqlstate = 52004 sqlerrp = dsnxidtb sql procedure detecting error sqlerrd = 72 0 0 1 0 0 ... ... select CHILDREN from sysibm.systables showed that the child count contains a .6. but there were only 5 related records in SYSIBM.SYSRELS. ... User did not know what lead up to this [...]
4317 42 36_Re: How many relations are too many?16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Wed, 1 Aug 2001 22:33:54 +0100330_us-ascii if it was Friday,
I could probably get away with the joke that even one is far too many, especially if it's a mother-in-law... in Italy we say "parents + serpents" but parents actually means relations, and not mummy and daddy ;-)
unfortunately, it being only Wednesday, I'd better not say anything :-) [...]
4360 91 27_Re: Performance and the web16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Wed, 1 Aug 2001 22:40:37 +0100397_us-ascii Steve,
sounds like you could have a chat with your local friendly Candle rep, for a talk about our End-user Measurement Solutions (Candlenet eBA*Service Monitor and Candlenet ETEWatch).
Please feel free to contact me offline, if you want more details about this, or for any other info.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
4452 89 38_Re: [Fwd: BMC to pay for v7 utilities]12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Wed, 1 Aug 2001 17:00:10 -0500578_iso-8859-1 Craig:
You deserve a better response than I believe I can give between planes, but I'll try. I am deleting the previous contents to preserve space so let me briefly restate the argument with my response. 1.)We agree that we disagree.
2.) At issue is the cost of ownership vs. the cost of entry. The IBM argument, as I understand it, is that they need to decrease the cost of upgrading processors or adding additional processors to the floor. They have done that if one goes with an IBM solution. The contracts that I see from the vendors inflict a [...]
4542 33 58_Column names of CURSOR not being returned to OLE DB Client22_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM30_Wed, 1 Aug 2001 15:10:53 -0700601_iso-8859-1 Gurus, I am going anywhere tacking this issue from a VB Developer. The column names are not being returned to the OLE DB Client's result set. He was expecting the Column names from the CURSOR that was defined in the DB2 stored procedure.
Here's a summary of the DB2 Stored Procedure Column Name issue: * Using a Visual Basic program, I connect to DB2 using the DB2 Client 7.2 OLE DB Provider. * The VB program then calls a DB2 stored procedure D11.CMU009_GET_CLM_ACT, passing 2 parameters. * The stored procedure returns a cursor select from the GTT_CMU009 table. * The [...]
4576 58 62_Re: Column names of CURSOR not being returned to OLE DB Client13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Wed, 1 Aug 2001 17:21:15 -0500522_iso-8859-1 Ramesh, ensure that you have DESCSTAT=YES in your DB2 DSNZPARM. You will then need to rebind your packages to have the change take effect.
Andy Seuffert NEON Systems, Inc. (Nasdaq:NESY)
support@neonsys.com http://www.neonsys.com
Tel: (281) 491-4200 Fax: (281) 242-3880
-----Original Message----- From: Ramesh Balasubramanyan [mailto:RAMBAL@SAIF.COM] Sent: Wednesday, August 01, 2001 5:11 PM To: DB2-L@RYCI.COM Subject: Column names of CURSOR not being returned to OLE DB Client [...]
4635 99 62_Re: Column names of CURSOR not being returned to OLE DB Client0_19_Tim.Lowe@STPAUL.COM30_Wed, 1 Aug 2001 17:29:24 -0500554_us-ascii Ramesh, This sounds like a problem that we had with DB2 V5 in 1999. See the DB2 install guide:
If this DB2 subsystem services requesters that support extended dynamic SQL, such as SQL/DS, set the DESCSTAT subsystem parameter to YES in the DSNTIJUZ installation job. This allows applications from the requesting system to execute SQL DESCRIBE statements that appear as extended dynamic SQL statements in the requesting system, but appear as static SQL in the DB2 package. The package must be bound while DESCSTAT=YES. [...]
4735 133 19_Re: Reg Index usage13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Wed, 1 Aug 2001 17:30:53 -0500615_us-ascii Sirish,
Indexed predicates are applied in the order of the index columns, not the order they are coded. Non-indexed are applied as Stage 1 first, within that: equals, then range, then other; and within that, the order of coding. Same for Stage 2.
This means COL1 is first.
Consider the example of a telephone book (my standard example): Index on LASTNAME, FIRST_INITIAL. If I have equals predicates LASTNAME = 'PURCELL' AND FIRST_INITIAL = 'T'. Every lastname in the phone book may have a FIRST_INITIAL = 'T', so I must first apply the LASTNAME predicate, then the FIRST_INITIAL. [...]
4869 19 40_UDB 7.x (UNIX) and next version features12_Roy Reynolds15_royr@INCYTE.COM30_Wed, 1 Aug 2001 17:28:04 -0700453_us-ascii Does anyone have a 'quite likely to see, but no guarantees' list of UDB Ver 8 features?
Does anyone know if there is there any plan to mimic the Oracle 'tablespace transport' feature? Thanks, Roy
================================================ 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.
4889 19 25_DB2 (OS/390) Architecture14_Kunjar Bhaduri28_Kunjar.Bhaduri@FIRSTDATA.COM30_Wed, 1 Aug 2001 21:01:35 -0400529_us-ascii Could anyone please point me to some good articles/whitepapers on DB2 for OS/390 (V6) architecture? I've been looking for reading material on the Net but have not really come across any authoritative and well-explained guide to the architecture.
Thanks in advance, Kunjar
================================================ 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.
4909 71 11_DB2 Connect0_14_DPetro@AOL.COM28_Wed, 1 Aug 2001 21:20:16 EDT380_US-ASCII Hi,
We are in the beginning stages of evaluating DB2 connect for web-based front ends. We have also been asked to evaluate the possibility of using dynamic SQL in this configuration. I would be interested in any experiences, positive or negative, that anyone might have with this. Some specific questions we have right now are mostly in the area of security: [...]
4981 23 39_Re: DB2 Version 5 end of service coming12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 1 Aug 2001 21:34:29 -0500482_- We have some customers who start their migration planning when a new version is announced. Others wait until some number of months or years after general availability. Some customers like to be one release behind. Some customers defer moving to accomodate their workload.
Still others seem to wait years or only move to a new release when they no longer have support. For these customers, there are 5 months left for Version 4. There are 17 months left for Version 5. [...]
5005 110 20_Re: Buffer Pool Tool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 2 Aug 2001 07:56:58 +0100458_- Fritz
we run ours for an hour most times .. settings are :
//COLLIT PROC COLLNUM='MAY08A11',STIME=60 COLLNUM= MMMDD{O|B}NN //* //COLLECT EXEC BFTCOLL,REGION=0M, // DB2=PRC, DB2 SS NAME // TIMEOUT=&STIME, TIMEOUT (MINUTES) // MAXDATA=16000, MAX DATA COLLECTED (MEGABYTES) // DB2LIB='DSN610' APPL LOAD LIBRARIES FOR DB2
We collect an hour of data or 16mig .. whatever is the first to blow (an hour is always what goes in our case). [...]
5116 61 29_Re: DB2 (OS/390) Architecture23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Thu, 2 Aug 2001 08:01:41 +0100339_- Kunjar
I am sure you will get many replies to this mail, however, I think a lot of people are going to ask the same things - can you be a little more specific. The subject you talk about is massive and I am sure many of the experts on this list could quite easily talk about DB2 390 Architecture for many weeks or months ... [...]
5178 51 52_FW: Changing OS/390 password via DB2 Connect Clients13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR30_Thu, 2 Aug 2001 10:22:30 +0300615_iso-8859-9 Hi all, I sent this mail last week, but i could not get any answer.
Any comments about this subject?
> -----Original Message----- > From: Murat Umurhan > Sent: Friday, July 27, 2001 3:23 PM > To: DB2-L@RYCI.COM > Subject: Changing OS/390 password via DB2 Connect Clients > > Hello listers, > > We have a problem about changing passwords via DB2 Connect clients. > Our environment is: > Windows 2000 Client ===> Windows 2000 Server ===> OS/390 v2.6. > > DB2 Connect Client v6.1 is installed on clients using gateway server(Windows 2000 Server: DB2 Connect EE v6.1 and Microsoft [...]
5230 66 53_AW: Data manipulation in LOAD - Next problem: Varchar0_20_Gerhard.Heiss@RUV.DE30_Thu, 2 Aug 2001 09:48:05 +02001025_iso-8859-1 Hayden,
load fixed length data. Then update your column using STRIP function to remove trailing blanks:
UPDATE owner.VAR1 SET VAR80=STRIP(VAR80)
//SYSREC00 DD * 1234567890 12345678901234567890 123456789012345678901234567890 /* //* //SYSIN DD * LOAD DATA LOG YES REPLACE INDDN SYSREC00 INTO TABLE owner.VAR1 ( VAR80 POSITION( 1 ) CHAR(80) )
Unload before update: ----------------------------------------------- .&1234567890 05FFFFFFFFFF444444444444444444444444444444444444 001234567890000000000000000000000000000000000000 ----------------------------------------------- .&12345678901234567890 05FFFFFFFFFFFFFFFFFFFF44444444444444444444444444 001234567890123456789000000000000000000000000000 ----------------------------------------------- .&123456789012345678901234567890 05FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF4444444444444444 001234567890123456789012345678900000000000000000 ----------------------------------------------- ******************************** Bottom of Data [...]
5297 16 16_Intent Locks....18_Rajendra Deshpande30_rajendra_deshpande@HOTMAIL.COM30_Thu, 2 Aug 2001 03:13:09 -0500443_- Hi Friends,
I am not able to fully appreciate the concept of INTENT LOCKS(IS, IX). Could you kindly shed some light and drive away my ignorance on the topic.
thanks & regards, Rajendra.
================================================ 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.
5314 29 32_Re: Monitoring DB2 on NT servers11_Phil Button18_BUTTONP@UK.IBM.COM30_Thu, 2 Aug 2001 09:19:53 +0100506_us-ascii If you want detailed stats and perfromance info about each of the 100 or so DB2's then the various third party tools will provide that, at the cost of all the licences.
On the other hand, if you just want to be alerted that everything's up and working, have you thought about running a script on an independent server to access a dummy table on each server, and alert someone if there is no response in a given time? Perl lends itself to this sort of thing rather well and is free ... [...]
5344 30 21_Problem with Resulset30_Pablo Gomez de la Parra Garcia14_pgp@IESPANA.ES30_Thu, 2 Aug 2001 10:31:56 +0200289_iso-8859-1 Hi there!
This is my first msg to the group.
I have a incredible problem. I am working with WebSphere 3.5 and DB2 7.1. When I open 2 resultset in a jsp page I only can read once the data that resultset contains. If I try to read them again I read only nulls. [...]
5375 74 52_Re: Changing OS/390 password via DB2 Connect Clients10_teldb2kals22_teldb2kals@TELSTRA.COM30_Thu, 2 Aug 2001 18:52:12 +1000516_us-ascii Hi Murat,
Can't say I can help u much, but we have a v6.1 system on OS390, and Db2 Connect 5.2 EE, and able to change passwords successfully, both from Win2000 and a WinNT machines. We use TCPIP for the connection, and we have EXTSEC=NO in our ZPARM.
Cheers, Kals
-----Original Message----- From: Murat Umurhan [SMTP:Murat.Umurhan@TCMB.GOV.TR] Sent: Thursday, August 02, 2001 5:23 PM To: DB2-L@RYCI.COM Subject: FW: Changing OS/390 password via DB2 Connect Clients [...]
5450 36 30_Archive log read - suspensions15_Piotr Tarnowski20_TarnowskiP@PROKOM.PL30_Thu, 2 Aug 2001 11:27:49 +0200304_us-ascii Hallo Listers,
I have a simple 'delete from t1 where col1 = :h1' running in loop, path uses index(col1, col2) with matching columns 1. t1 has 20M rows, col1 has cardinality of 10M All reads are async. (after some time only from table, index is in bufferpool) The query is very slow. [...]
5487 44 19_BMC's HDDL in Batch10_BRUCE ALAN25_alan.bruce@FORTISBANK.COM30_Thu, 2 Aug 2001 11:28:50 +0200381_- Hi,
Does anybody run Catalog manager's HDDL in batch against a shadow catalog ? Is this possible ?
Below are the input cards we are using against the system catalog but there is limited information about this option in the manuals.
//SYSTSIN DD * ISPSTART PGM(ACTBMAIN),PARM(O=ACTDB2D,S=DB2D) //SYSIN DD * HDDL TS DBname.TSname
Can anyone help ? [...]
5532 20 20_Re: Read only cursor13_Thomas Schulz20_thomas.schulz@SVI.DE30_Thu, 2 Aug 2001 04:39:33 -0500320_- Hi Randall
The result table will be read only. This is suggestive by remote access in shared Database Systems. Instead of providing the Data line by line the system can use the Block-Fetch mode which is much better from the performance. The system moves pages between the Servers instead of current lines. [...]
5553 65 34_Re: Archive log read - suspensions16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Thu, 2 Aug 2001 15:42:19 +0530438_- Piotr,
Class 3 suspension have many reasons but your case says it is because of Archive log read. Does this particular snapshot had ROLLBACK ? If not, how many rows are deleted in this execution of the program ? How frequently do you use commit.
I think you need frequent commits. As far as the performance of the query for accessing the rows is concerned, i think identifying the rows might not be taking much time. [...]
5619 41 44_Re: UDB 7.x (UNIX) and next version features17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Thu, 2 Aug 2001 05:57:50 -0500529_us-ascii The only thing that I know of is the ability to manipulate data via a federated database.
From: Roy Reynolds @RYCI.COM on 08/01/2001 07:28 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: UDB 7.x (UNIX) and next version features
Does anyone have a 'quite likely to see, but no guarantees' list of UDB Ver 8 features? [...]
5661 77 20_Re: Read only cursor0_24_db46@DAIMLERCHRYSLER.COM30_Thu, 2 Aug 2001 08:04:50 -0400296_us-ascii Many times cursors without FOR FETCH/READ ONLY end up being as such because many cursors have an order by, group by, or distinct clause. When you add any of these clauses, then the cursor is no longer ambiguous and you end up with CURRENTDATA (NO) which allows for the block fetch. [...]
5739 23 20_Re: Intent Locks....10_Ian Thorne17_ian.thorne@DB.COM30_Thu, 2 Aug 2001 07:03:55 -0500351_- Rajendra
You might find the description of INTENT Locks in the DB2 Admin Guide (v6) very useful. See Chap5-7 Improving Concurrency - Aspects of transaction locks (p797). This guide along with many other DB2 guides is downloadable from the IBM website. It might be worth starting there and then asking more specific questions afterwards. [...]
5763 75 32_Re: Monitoring DB2 on NT servers11_Phil Button18_BUTTONP@UK.IBM.COM30_Thu, 2 Aug 2001 13:26:00 +0100615_us-ascii try
http://www.perl.com/pub/a/language/info/software.html#stable
or
http://aspn.activestate.com/ASPN/Downloads/ActivePerl/index/
Phil Button Mailpoint 6N LEED UK DB Team UK TS solutions IBM Global Services 6th Floor North, Albion Tower, 11 Albion Street, Leeds LS1 5EU 0113-235 5974 (ext) 685974 (internal) email BUTTONP@uk.ibm.com
"Martin, Paul" on 02-08-2001 12:47:31
Please respond to "Martin, Paul"
To: Phil Button/UK/IBM@IBMGB cc: Subject: RE: Monitoring DB2 on NT servers [...]
5839 39 21_DB2 & Data Dictionary10_Joan Green22_Joan.Green@BOIMAIL.COM30_Thu, 2 Aug 2001 14:04:25 +0100737_us-ascii List,
Any suggestions for a Data Dictionary? I notice some discussions about home-grown ones in the archive but has any one any experience of off-the-shelf?
TIA
Joan Green 'My opinions are my own'
******************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately at MailManager@psir.ie and delete this E-mail from your system. Thank you. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For [...]
5879 48 0_32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR30_Thu, 2 Aug 2001 16:29:47 +0300210_ISO-8859-9 Hi all, Is there a way to define DDF thread priority through WLM for the RACF user groups? I know it is possible with primary auth ids but I wan't to know if there is a way to use secondary auth ids.
5928 30 25_Re: DB2 & Data Dictionary12_Jim Harrison17_jharrison@GMX.NET30_Thu, 2 Aug 2001 10:01:46 -0400342_us-ascii We use CA Platinum Repository/MVS (yeah, they kept the Platinum name). Not bad, but be prepared for a lot of work customizing it, not to mention $$$. If we had it to do over, we'd have probably opted for their OE version. Before that we used Datamanager which was a great mainframe product but wasn't keeping up with the times. [...]
5959 206 26_Re: Amazing -204 error !!!11_Manish Lall17_db2list@YAHOO.COM30_Thu, 2 Aug 2001 07:14:16 -0700474_us-ascii Hi All,
Finally with the help of the group i have identified the reason for the error .The Select Parents from sysibm.systables for that table shows the value 32767 which is obviously not correct and i checked in sysibm.sysrels and there is no row for the said table . So I need to reset the value for the parent column for this table to zero . Any idea how to do that ??Please give me some ideas ?. here is the output of the query. Thanks, Manish Lall [...]
6166 113 28_Partitioning Recommendations14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 2 Aug 2001 15:18:13 +0100387_iso-8859-1 Dear Listers,
I have just read Robert Cotterill's article on partitioning in DB2 Magazine. In it he makes recommendations regarding partitioning keys, and the benefits gained through parallelism. He mentions partitioning the data according to natural clustering key, and spreading the data evenly across partitions with a "random" key.
Here is my scenario: [...]
6280 62 38_Re: [Fwd: BMC to pay for v7 utilities]14_Grainger, Phil20_Phil.Grainger@CA.COM30_Thu, 2 Aug 2001 15:41:11 +0100391_iso-8859-1 and if you think you have a choice about whether to buy the Operational bundle OR the Diagnostic/Recovery bundle, have a look at where they put RUNSTATS (operational) and MODIFY STATISTICS (diagnostic/recovery).........
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
6343 81 52_Re: Changing OS/390 password via DB2 Connect Clients10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM30_Thu, 2 Aug 2001 10:08:42 -0500466_ISO-8859-1 You can change it using ODBC connect string, here is the syntax
DbParm = "ConnectString='DSN=StarS;UID=QDP0274;PWD='XXX';NWPWD='YYY'"
-----Original Message----- From: Murat Umurhan [mailto:Murat.Umurhan@TCMB.GOV.TR] Sent: Thursday, August 02, 2001 2:23 AM To: DB2-L@RYCI.COM Subject: FW: Changing OS/390 password via DB2 Connect Clients
Hi all, I sent this mail last week, but i could not get any answer. [...]
6425 88 21_UDB for Unix Training14_Scott Trometer22_scott.trometer@RCI.COM30_Thu, 2 Aug 2001 10:28:27 -0500430_iso-8859-1 Listers,
Our shop will be implementing UDB for Unix soon and we need to begin some basic training. Our current skill-sets include DB2 V5/6 on Os/390.
We are really looking for a good Unix class and a good UDB V6 or V7 Administration class to get started. Can anyone recommend a vendor(s) for these classes? In the past, we have used Platinum/CA , but I haven't found what I am looking for as of yet. [...]
6514 16 30_Re: DB2 Performance monitoring12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 2 Aug 2001 10:27:46 -0500359_- For much of the monitoring, you can look in the DB2 Administration Guide, volume 2. For example, chapter 5-2 is Analyzing Performance Data, and it talks through the key reports from DB2 PM - accounting and statistics. There are good classes at IDUG, DB2 Technical Conference, Share and standard education. The Share foils are easy to get from the web. [...]
6531 23 29_Re: DB2 (OS/390) Architecture12_Roger Miller19_millerrl@US.IBM.COM30_Thu, 2 Aug 2001 10:36:23 -0500411_- One of the best short sections on architecture is the Introduction to DB2 for OS/390 book by Susan Graziano Sloan and An Kilty Hernandez, Prentice Hall and IBM order number SC26-9937. Chapter 3 is the architecture discussion.
The Administration Guide, volume 1, chapter 2, has some of the same information.
You can get this information from the web by starting at ibm.com/software/db2os390 [...]
6555 39 36_SET assignment in a before trigger ?19_Hittle, Ken J - CNF18_Hittle.Ken@CNF.COM30_Thu, 2 Aug 2001 08:33:22 -0700350_iso-8859-1 I'm trying to create a before trigger which will set a new column to the value of a column from another table in the same database. Is there a way to use SET with a subselect? This is for DB2 OS/390 V6. I have tried variations on the following, but no luck. The table and column do exist in DB1. Any help will be greatly appreciated. [...]
6595 139 32_Re: Partitioning Recommendations13_Daniel Turner28_daniel_turner@ALBERTSONS.COM30_Thu, 2 Aug 2001 10:04:03 -0600502_iso-8859-1 Skewing is an admin problem that doesn't directly affect the users, however deadlocks and time out contention is a very public problem.
runstats can give different stats for each partition. REOPT(VARS) lets db2 use different access paths for different partitions for the same plan/package based on runtime :hv values. the downside to this is you need to remove sewing machine code (millions of singleton selects) to a different plan/package to avoid the reoptimization overhead. [...]
6735 96 40_Re: SET assignment in a before trigger ?12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Thu, 2 Aug 2001 11:16:00 -0500537_us-ascii Hello,
I'm afraid your only option is the UDF. Here are two things that aren't available in OS/390 V6.1 BEFORE triggers:
Set with Sub-select. Using transitional variables as OUT or INOUT stored procedure parameters. (Recognizing their values, that is.)
Bummer, ain't it!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R10 DB2 UDB 6.1 W: 314-935-4376 H: 636-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [...]
6832 136 37_Other's experience with ONLINE REORG?13_Laura Hendrix16_lhendrix@BCO.COM30_Thu, 2 Aug 2001 09:26:13 -0700569_iso-8859-1 We have just upgraded to MF DB2 V6.1 and I have been tasked with making use of Online Reorg.
Anyone out there willing to share their experience with Online Reorg, and how they have made use of it in their shop? In particular I am interesting in:
A) Are you using it for very large tablespaces? B) How does performance compare to conventional reorg with one, two, three and/or four indexes per table. C) What did you do to prepare? I have heard that we should count on leaving our packs at 50% full. Has anyone gone out before implementing [...]
6969 31 38_identifying rouge weblogic connections15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Thu, 2 Aug 2001 11:38:29 -0500542_- Environment: UDB V7.1, AIX 4.3, Weblogic 5.1.0, java programs using JDBC.
Occasionally we get an offending application freezing up the system. We are trying to find ways we can identify the offending one. Executing "list applications" gives us the following...
Auth Id Application Appl. Application Id
Name Handle -------- -------------- ---------- ------------------------------ OMISUSER java 108 AA5E2FC2.9E8D.010801143534 OMISUSER java 18 AA5E2FC2.9F8F.010801144211 OMISUSER java 185 AA5E2FC2.9F91.010801144213 [...]
7001 240 41_Re: Other's experience with ONLINE REORG?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 2 Aug 2001 12:41:33 -0400565_iso-8859-1 A) We use it for most of our tablespaces. We decide not based on size, but based on availability requirements. B) Performance similar to regular reorg plus however long log apply takes (very short if little update, very long if much). Why worry? The problem we address is availability. So what if the REORG takes longer. The users have more access. C) We tested a lot. A very very lot. We run with our vols 75-80% full. Just make sure that each STOGROUP has enough room to duplicate the objects being reorged while the reorgs are running. D) We run [...]
7242 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM30_Thu, 2 Aug 2001 11:44:16 -0500447_us-ascii I will be out of the office starting 08/02/2001 and will not return until 08/03/2001.
I will be out of the office for the remainder of the day. 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.
7259 168 41_Re: Other's experience with ONLINE REORG?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM30_Thu, 2 Aug 2001 13:02:53 -0400399_iso-8859-1 Laura, Sorry I left off an answer {to your 2nd D) } We run with *very* high CICS update activity but try to sched reorgs around large batch runs. As for best time - see if you can get by with doing this while you are there and awake. Of course, we rarely have an Online Reorg problem. Maybe one out of every several hundred has an abend. Of course, we did and do test *extensively*. [...]
7428 66 42_Re: identifying rouge weblogic connections14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 2 Aug 2001 13:07:36 -0400385_us-ascii Tonmoy:
What exactly do you mean by 'freeze up'? Do you need to reboot the box or can you just kill the application to fix it?
What does vmstat show as far as CPU consumption goes when you experience 'freeze up'? Check what the locktimeout parameter is set at the database? I have seen applications 'hanging' because the default value had not been changed. [...]
7495 46 19_IEC999I with 0C4-1111_Brown, Bill28_sgjwb@TECHMAIL.ADMIN.TTU.EDU30_Thu, 2 Aug 2001 12:17:45 -0500361_iso-8859-1 I just migrated to DB2 61 and one of our developers is having difficulty binding some applications. Most things bind with no problem. Actually, he says the error occurs when trying to free the package before rebinding. Just curious if anyone has seen this.
IEC999I IFG0TC0A,IFG0TC0B,SKBA3858,BIND ,DEB ADDR = A38E0C,DSN = TTU.DBT.DBRMLIB [...]
7542 149 39_Making Tablespaces implicit vs explicit13_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Thu, 2 Aug 2001 12:17:43 -0500550_US-ASCII Hello, I think I may have asked this before, but I cannot find the answer in archives (or the question for that matter) I have 8 QMF tablespaces that are explicitly managed.
I have been told by one of our experienced sysprogs that he thinks all I have to do to make this implicitly managed is to change the column IMPLICIT in SYSIBM.SYSTABLESPACE so that it is Y instead of N and all will be well. so that I wont have to redefine these at Disaster Recovery. I can't find documentation to back up his suggestion... and if this is [...]
7692 156 41_Re: Other's experience with ONLINE REORG?11_Robert Jans26_robert_jans@ALBERTSONS.COM30_Thu, 2 Aug 2001 11:27:57 -0600441_iso-8859-1 Hi, Laura. Sorry to say we've tested it fairly extensively in our environment and find it way to unreliable for production and much too slow for us.
Robert Jans Albertson's, Inc
-----Original Message----- From: Laura Hendrix [mailto:lhendrix@BCO.COM] Sent: Thursday, August 02, 2001 10:26 AM To: DB2-L@RYCI.COM Subject: Other's experience with ONLINE REORG? [...]
7849 122 25_Re: UDB for Unix Training13_Terry McCombs20_tmccomb@SEDGWICK.GOV30_Thu, 2 Aug 2001 12:27:48 -0500542_iso-8859-1 IBM has a course, "CF281: Fast Path to DB2 UDB for Experienced Relational DBAs", which I believe is also available as a CBT. I didn't take this one, but took a complete UDB administration class, and think the "fast path" would have been better for me (since I didn't need to relearn a lot of the basic concepts). I actually didn't take that UDB class, either, until I'd been doing it for a while. Your mainframe DBA's will be surprised what they already know how to do. I also picked up the unix I needed from a book. I'm not [...]
7972 60 25_Re: UDB for Unix Training14_Michele Payton18_paytonm@US.IBM.COM30_Thu, 2 Aug 2001 11:46:00 -0600638_iso-8859-1 I have taken several classes here and they have all been good:
http://www.mux-ed.com/
Michele Payton
Scott Trometer @RYCI.COM> on 08/02/2001 09:28:27 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: UDB for Unix Training
Listers,
Our shop will be implementing UDB for Unix soon and we need to begin some basic training. Our current skill-sets include DB2 V5/6 on Os/390. [...]
8033 88 42_Re: identifying rogue weblogic connections15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Thu, 2 Aug 2001 12:51:33 -0500477_- The weblogic applications freeze up, not the machine or DB2. We force all the weblogic applications out and then there is a spurt of new weblogic connections and all is back to normal. We want to identify the problem connection and force out that alone, not all of them as we are doing now. We would then look at the offending bean/applet for correction. Snapshot of applications does not give me enough information that would help the programmers identify the problem. [...]
8122 45 42_Re: identifying rouge weblogic connections12_David Booher22_David.Booher@QUEST.COM30_Thu, 2 Aug 2001 11:13:51 -0700103_iso-8859-1
The rouge connection would be the RED one....sorry, couldn't resist!
8168 91 43_Re: Making Tablespaces implicit vs explicit0_19_Tim.Lowe@STPAUL.COM30_Thu, 2 Aug 2001 13:16:54 -0500403_us-ascii Mike, You should alter the tablespaces to use a stogroup and supply a priqty and secqty. You will need to do a stop before and a start afterward.
I hope this helps.
Thanks, Tim
Mike Lawrence cc: Sent by: DB2 Data Subject: Making Tablespaces implicit vs Base Discussion List explicit [...]
8260 15 25_Re: UDB for Unix Training13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Thu, 2 Aug 2001 13:25:17 -0500428_us-ascii There is a self-study course that can be downloaded free from IBM for DB2 fast path for experienced DBAs at the following site: http://www-4.ibm.com/software/data/db2/selfstudy/
================================================ 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.
8276 54 41_Re: Other's experience with ONLINE REORG?12_Isaac Yassin20_yassini@BEZEQINT.NET30_Thu, 2 Aug 2001 21:31:06 +0200513_iso-8859-1 Hi, As an add-on: If you have long running batch jobs without commits (@#$%) then DON'T run OLR with them ! We're using OLR since it's started on V5 and are happy with it. We added some disk space, but only enough to let us handle the amount running concurrently (in terms of size - not number of jobs). We do OLR for indexes (that need it) on a weekly base at most, some are done even more often, for TS it's on a monthly (more or less). No problem in doing it during online time as well (but we [...]
8331 216 42_Re: identifying rouge weblogic connections15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Thu, 2 Aug 2001 13:53:41 -0500395_- Good one...:-), David....Linda caught me with that and I quietly tried to change the spelling on further replies.
-----Original Message----- From: David Booher [mailto:David.Booher@QUEST.COM] Sent: Thursday, August 02, 2001 1:14 PM To: DB2-L@RYCI.COM Subject: Re: identifying rouge weblogic connections
The rouge connection would be the RED one....sorry, couldn't resist!
8548 97 38_Re: [Fwd: BMC to pay for v7 utilities]12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Thu, 2 Aug 2001 14:09:49 -0500598_iso-8859-1 An interesting analogy Gerald, but let me pursue this a little farther. Currently, the IBM utilities package includes the MODIFY utility where there has never been a third party equivalent and to my knowledge there is no equivalent anticipated at any time in the future. There is something about third party utilities mucking with you application data and I guess the safety net is that you can always recover if the information in the catalog is correct. However, the MODIFY utility changes the catalog and if that fails then you are looking at a catalog recovery which is for all [...]
8646 93 41_Re: Other's experience with ONLINE REORG?32_Atalay Tanis (Garanti Teknoloji)22_AtalayT@GARANTI.COM.TR30_Thu, 2 Aug 2001 22:15:58 +0300292_iso-8859-1 We use OLR but with caution:
- It does noit always obey the MAXRO value. I saw several times a reorg go into last log iteration with current esitmate of 2 or 3 minutes though MAXRO was set to 5 seconds.
- With drain all parameter the above fact is more painful. [...]
8740 96 20_Re: Trigger question15_Benjamin Reches33_Benjamin.Reches@MORGANSTANLEY.COM30_Thu, 2 Aug 2001 15:25:16 -0400519_us-ascii so what was the final answer. how do we/ can we code a case statement in the before trigger??
Robert Wright wrote:
> Have you tried using a CASE statement, as opposed to a CASE expression. This > would lok like: > > case > when ... > else ... > end CASE; > > ie, put the END CASE in and see how it goes. > > Rob > > On Wed, 4 Apr 2001 07:56:59 +1000, Mallett, Steven > wrote: > > >Walter, so you mean something like this should work? > > > > CREATE TRIGGER [...]
8837 37 14_-30090 sqlcode10_Tod Julius21_tod_julius@JBHUNT.COM30_Thu, 2 Aug 2001 14:49:01 -0500366_- I have the following situation and need advice.
I have CICS transactions updating DB2 tables (OS/390 V6.1), these tables have Triggers which call Stored Procedures. The Stored Procedures connect to a remote database (DB2 UDB AIX V6) and attempt to insert into a table. I am doing this using dynamic sql and receiving a -30090 on the prepare statement. [...]
8875 59 29_DB2 DBA needs a job - Citizen9_Sue Young20_sueyoung@AIRMAIL.NET30_Thu, 2 Aug 2001 15:55:27 -0500277_iso-8859-1 Hello,
Does anyone know of a company in Dallas, Texas that is looking for a Senior DB2 DBA? Has worked in large database environment. Contract or full time
Sue Young Technology Solutions (972) 463-6300 - Office (972) 463-6301 - Fax sueyoung@airmail.net
8935 12 18_Re: -30090 sqlcode11_Mike Fatula17_mfatula@PHEAA.ORG30_Thu, 2 Aug 2001 16:41:05 -0400305_us-ascii Is the Client DBM parameter TP_MON_NAME equal to CICS?
================================================ 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.
8948 96 33_Re: DB2 DBA needs a job - Citizen10_Moden, Jim17_jim.moden@EDS.COM30_Thu, 2 Aug 2001 16:05:36 -0500401_iso-8859-1 Sue:
You might try MBNA. One of their DBAs just left about a month ago. She was a contract DBA. EDS might have openings too. You'll have to get into EDS.com and look around.
Regards, Jim Moden
-----Original Message----- From: Sue Young [mailto:sueyoung@AIRMAIL.NET] Sent: Thursday, August 02, 2001 3:55 PM To: DB2-L@RYCI.COM Subject: DB2 DBA needs a job - Citizen [...]
9045 26 27_DB2 OS390 LARGE Tablespaces11_James Drewe20_James.Drewe@AEXP.COM30_Thu, 2 Aug 2001 17:14:37 -0700412_us-ascii Listers
I am sure I saw something earlier this week from an IBM source indicating that sometime in the future (yet unannounced) IBM will require LARGE tablespaces to migrate to DSSIZE tablespaces. I went back to confirm this and cannot find the reference.
I know I get wacked out at times, but I am sure that I saw this. Could anybody provide information (and hopefully a reference)? [...]
9072 88 38_Re: [Fwd: BMC to pay for v7 utilities]12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Thu, 2 Aug 2001 23:50:09 -0500482_iso-8859-1 Tom:
An interesting response and directly to the most critical point. The fact is that at least two vendors present themselves as having a MODIFY facility. In truth I believe they front end the IBM Utility for most of its function and in so doing they make MODIFY easier to use. I am more concerned about changes to the Directory than I am to the Catalog when it comes to vendor tools because the Directory is nowhere as clearly documented as is the Catalog. [...]
9161 16 48_Michael J McKinney/HCG/CSC is out of the office.16_Michael McKinney16_mmckinne@CSC.COM30_Fri, 3 Aug 2001 01:05:21 -0400450_us-ascii I will be out of the office starting 08/03/2001 and will not return until 08/07/2001.
Will have very limited access to voice mail and e-mail. Will get back to you when I return on Tuesday 8/7.
================================================ 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.
9178 67 18_out of the office.33_=?iso-8859-9?Q?R.Teoman_KO=C7ER?=22_tkocer@HALKBANK.COM.TR30_Fri, 3 Aug 2001 08:34:34 +0300136_iso-8859-9 I will be out of the office starting 08/06/2001 and will not return until 08/20/2001.
9246 15 45_Brian Hopper/Austin/IBM is out of the office.12_Brian Hopper18_bhopper@US.IBM.COM30_Fri, 3 Aug 2001 02:28:34 -0400397_us-ascii I will be out of the office starting August 3, 2001 and will not return until August 7, 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.
9262 16 54_Barbara Kilburn/Santa Teresa/IBM is out of the office.15_Barbara Kilburn19_bkilburn@US.IBM.COM30_Fri, 3 Aug 2001 00:57:47 -0600451_us-ascii I will be out of the office starting August 2, 2001 and will not return until August 13, 2001.
I will respond to your message when I return. Continue sending eCare documents to my id this week.
================================================ 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.
9279 57 72_SMART: A paradigm shift in the way IBM thinks about database mana gement12_Peter, Georg15_G.Peter@DZBW.DE30_Fri, 3 Aug 2001 09:42:20 +0200693_iso-8859-1 Hi listers,
just strolled through some IBM web pages and I think I have found an information that is interesting for the most of you....
Under http://www-4.ibm.com/software/data/highlights/smartdba.html IBM talks about a self-managing technology with an effort called SMART -- Self Managing And Resource Tuning databases.
They say that SMART is not a product, or a single feature. It's a collection of features, and a paradigm shift in the way IBM thinks about database management: "Imagine a future database world where the database is completely self-optimizing, never needs adjusting or maintenance, perfect right out of the box, and should anything go [...]
9337 92 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 3 Aug 2001 13:43:46 +0530404_iso-8859-1 Georg,
Real good information for all of us. So few more questions i want to add other than "When and How SMART will come?".
Another question -->
i) Will something like SMART Administrator be required for this 'collection of features', which would probably be embedded with the database.
ii) Will it be there with all the databases or only with IBM databases ? [...]
9430 20 15_urgent question13_Wolfgang Wolf17_wolferl69@GMX.NET30_Fri, 3 Aug 2001 03:00:19 -0500556_- Hi folks, for a decision I need some important informations if it is possible to call from a STORED PROC, running on s/390 another Stored Proc at Oracle Win/NT?
It is DB2 V610 on OS/390 2.9 and Oracle 8.1.7 on Win/NT
Does anyone have any experiences here? Thanks for your input.
Wolf
================================================ 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.
9451 15 43_Sean M O'Keefe/AC/VCU is out of the office.21_Sean M O'Keefe/AC/VCU15_sokeefe@VCU.EDU30_Fri, 3 Aug 2001 05:02:29 -0400389_us-ascii I will be out of the office starting 08/03/2001 and will not return until 08/13/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.
9467 107 25_Re: UDB for Unix Training16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM30_Fri, 3 Aug 2001 10:31:02 +0100692_us-ascii Hi Scott,
as IBM recently mentioned in one of their weekly updates,
"Candle Corporation has been providing technical expertise and training to customers for 20+ years. Its extensive line of Websphere* MQ and MQSI training spans more than 30 offerings, including live classroom, CBT and eLX live Internet training sessions. As the authors and support arm for Websphere MQ on Tandem NSK, Candle also is an excellent--and possibly the only--choice for system administration training, consulting and implementation support. In addition to Websphere MQ, they offer training on Candle monitoring and management solutions for Tandem NSK and many other platforms. (Please [...]
9575 167 32_Re: Partitioning Recommendations16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 3 Aug 2001 15:21:04 +0530385_iso-8859-1 Marcus,
Your scenario is practical and the situations described by Robert in his article has always mentioned that partitioning is to be decided by the practical requirement.
So, the way you have chosen the partitioning key in your case looks perfectly OK to me as per the batch job which access the data on the basis of PRODUCTs and it process PRODUCTs. [...]
9743 90 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET30_Fri, 3 Aug 2001 10:00:35 +0100434_us-ascii There was some discussion about this at IDUG in Orlando in May. It was mentioned in passing in Janet Perna's keynote. It also caused a lot of concern among "real DBAs" who have seen the problems self-tuning databases give (e.g. MS SQL Server where the latest versions have taken away most of the "tuning knobs" because "the database is self tuning" - which is fine until something doesn't fit into the hardcoded tuning. [...]
9834 240 26_Re: Amazing -204 error !!!16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 3 Aug 2001 15:38:03 +0530546_iso-8859-1 > Upto V6 on OS390 PARENT column in the SYSIBM.SYSTABLES is not Updateable. > So, you may need to go via ZPARM route. Or use the same method described > by Aurora which use REPAIR to get the relation count to 32767 and then > drop the table so that its entry will be removed from catalog tables. > > HTH > Regards > Sanjeev > > -----Original Message----- > From: Manish Lall [SMTP:db2list@YAHOO.COM] > Sent: Thursday, August 02, 2001 7:44 PM > To: DB2-L@RYCI.COM > Subject: Re: Amazing -204 error !!! > > Hi All, > > Finally with [...]
10075 52 41_For Update Of-Cursor referencing 2 Tables13_Patric Becker25_Patric_Becker@SIS-WEST.DE30_Fri, 3 Aug 2001 05:05:00 -0500662_- Hi Everyone !
Right before the beginning of the weekend another short problem :
We have two tables with the following columns :
Table_A : CUST_NO, ACCOUNT_NO, BALANCE, VALID_FROM, VALID_UNTIL Table_B : CUST_NO, CUST_NAME, VALID_FROM, VALID_UNTIL
The following cursor has to update the column VALID_UNTIL in Table_B :
DECLARE Name CURSOR FOR SELECT T2.CUST_NAME ,T1.BALANCE ,T1.VALID_FROM ,T1.VALID_UNTIL FROM Table_A T1 ,Table_B T2 WHERE T1.CUST_NO = :HVa AND T1.ACCOUNT_NO = :HVb AND T1.VALID_FROM >= :TIMESTAMP AND T2.CUST_NO = T1.CUST_NO AND T2.VALID_UNTIL >= :TIMESTAMP FOR UPDATE OF VALID_UNTIL OPTIMIZE FOR 2 ROWS [...]
10128 89 0_22_Bertolino, Salvatore S26_SBertolino@MAIL.SBIC.CO.ZA30_Fri, 3 Aug 2001 12:18:23 +0200528_iso-8859-1 SET NOMAIL
Regards
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law.\ Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. [...]
10218 232 26_Re: Amazing -204 error !!!16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 3 Aug 2001 14:50:16 +0530304_iso-8859-1 Upto V6 on OS390 PARENT column in the SYSIBM.SYSTABLES is not Updateable. So, you may need to go via ZPARM route. Or use the same method described by Aurora which use REPAIR to get the relation count to 32767 and then drop the table so that its entry will be removed from catalog tables. [...]
10451 186 26_Re: Amazing -204 error !!!16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM30_Fri, 3 Aug 2001 11:38:03 +0100349_us-ascii Manish,
depends on what flavour of DB2 you're on, I think you said v 4???
Other than fiddling with ZPARMs (I don't even know if what you need is hidden in v4), the only thing I can think of is REPAIR as detailed in the PMR...
HTH.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
10638 24 39_Install DB2 not in /usr/lpp and fixpaks14_Eddie W Spaeny20_ed_spaeny@NL.IBM.COM30_Fri, 3 Aug 2001 12:57:23 +0200434_us-ascii Hi everyone,
We would like to install the db2 (EE) software not in /usr/lpp but on a shared filesystem. This is because the primary host can be taken over by HACMP in case of problems.
However, I have understood that fixpaks always assume that the software is installed in /usr/lpp.
Does anybody have any experience with this? Is there a procedure how to install fixpaks in a non-standard location? [...]
10663 129 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT30_Fri, 3 Aug 2001 12:55:33 +0200549_iso-8859-1
Hi Philip, I agree with you, don't know if it's for pride or with reason, but I don't trust so much self tuning. I know it's still a growing technology but will you trust a self tuning DB that doesnt keep in count the limitation given by the surrounding environment? What I do mean is have you tried to use the DB configuration assistant on AIX (UDB v7.1 )? Well, I was working with a big warehouse amd the reccomandarion was to set 2 of the BPs at 528000 pages (2GB) each, perfect if you are reasoning with teorethic values [...]
10793 94 45_Re: For Update Of-Cursor referencing 2 Tables16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Fri, 3 Aug 2001 16:03:23 +0530344_- Patric,
You can not use FOR UPDATE OF clause with a DECLARE which contains join of two or more tables because that makes the result table as READ-ONLY. If you want to use the same you can incorporate the EXISTS but you may not be able to select the columns from second table, second table column can be selected in another query. [...]
10888 76 24_Couple of Join questions12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 3 Aug 2001 05:18:25 -0700285_us-ascii I ran into a couple of interesting anomalies with the programmers yesterday that I'd like some of the SQL guru's out there to explain to me.
We have a query such as SELECT col1, col2 from tablea A, tableb B where a.col3 = b.col3 and a.col4 = b.col5 and a.col5 = 0 [...]
10965 55 65_OS/390 as Enterprise Database Server for Distributed Architecture14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM30_Fri, 3 Aug 2001 08:37:58 -0400517_us-ascii Hi,
I'd like to take a quick survey and also get some feedback on the following situation:
We are looking to implement a high-availability, fault tolerant database architecture for a handful of database applications which have currently been implemented using UDB on AIX as their database platform. Our architecture group is in the process of designing an infrastructure that includes multiple UDB AIX database servers that are tied together via HA-CMP in a mutual failover configuration. [...]
11021 27 13_Reg DBA EXAMS22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM30_Fri, 3 Aug 2001 09:25:39 -0400470_us-ascii Hi ALL,
I wanted to have all your INPUTS big or small as most of you are veterans in this area? I want to get myself some good certification to go the level of DB2 dba ADMINISTRATION. Right now my job requires that.I have been working with DB2 all along but from the application side. So I know the basics. Please pass on some information what are the EXAMS required online etc ? ,WEBSITES to register? and BOOKS/material ? for achieving this goal. [...]
11049 125 25_Re: UDB for Unix Training24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Fri, 3 Aug 2001 09:39:54 -0700354_us-ascii
Scott, I can make two suggestions:
1) My company, The Fillmore Group, offers a proprietary DB2 UDB for Unix Administration class. It tracks the DB2 UDB Certification Guide (you receive a copy of the Guide during class) and can be scheduled on-site at your location *or* via the Internet using our Distance Learning facility. [...]
11175 25 20_DB2 UDB Connect time15_Larry G Rydberg21_Larry_Rydberg@AAL.ORG30_Fri, 3 Aug 2001 08:37:51 -0500417_us-ascii We are running DB2 UDB for AIX V7.1. The tables in our Operational Data Store are updated with IBM's DpropR. We have about 30 subscriptions that process every 5 minutes. Source data is located in our production DB2/MVS subsystem.
Event Monitor reports show about 150,000 connects to our ODS per week. Most of these connects are from DpropR. We do ACTIVATE the database to reduce connection time. [...]
11201 35 31_Re: DB2 OS390 LARGE Tablespaces14_Craig McKellar26_craig.mckellar@BIGPOND.COM30_Fri, 3 Aug 2001 23:57:30 +1000399_us-ascii I have seen this as well. I believe it was in the V6 release guide but I may be wrong. What I have read is that the DSSIZE is replacing the use of LARGE. LARGE was introduced in V5 and is superseded by using DSSIZE in V6. LARGE only catered for 4GB datasets where DSSIZE gives you more options dependant on EA enablement. Setting DSSIZE to 4GB by default sets the tablespace to large. [...]
11237 149 38_Re: [Fwd: BMC to pay for v7 utilities]12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Fri, 3 Aug 2001 09:08:59 -0500554_iso-8859-1 To your first point, would a vendor be accused of offering a replacement for the Modify utility if the product had Modify in the name? Or if the vendor provided a front-end to the Modify utility that allowed for easier specification of requests? It is interesting that I find you as the defender of IBM on this whole point. Why did IBM package the utilities the way they did? To give the customer more options? If so then could they be listed in a complex sentence? It appears to me that the options chosen are made to increase the value [...]
11387 42 31_Data Replication Problem. Help!20_Alvarez, Maximiliano20_MAXIMILIANO@IADB.ORG30_Fri, 3 Aug 2001 10:44:20 -0400531_iso-8859-1 Db2 list members
Has anyone seen this before?
ASN1001E: The Apply program encountered an SQL error. ERRCODE is 8B0107, SQLSTATE is 07001, SQLCODE is -313, SQLERRM is , SQLERRP is SQLRIBNI, SQLERRP is SQLRIBNI, server name is SRV, table name is RPP.RPP.
I assumed the SQLCODE comes from the Apply program so that I checked all the columns for tables and CD tables in source and target as well as table asn.ibmsnap_subs_cols but didn't find anything wrong. What can be the cause of this problem? [...]
11430 194 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement0_22_Rohn.Solecki@MTS.MB.CA30_Fri, 3 Aug 2001 09:31:28 -0500574_iso-8859-1 I agree also. "Self tuning" is a nice starting point, but at some point the real world will always throw a curve that the self tuning algorithm can't handle and intelligent human intervention is required solve the resulting problems. If you think about it, DB2 already has some 'self tuning', it is also known as the optimizer. It is one of the advantages of DB2 over IMS, the programmer no longer has to worry about selecting the right best index(s) for data access, the optimizer takes care of access path. It looks at an SQL and the catalog and 'decides' [...]
11625 57 17_Re: Reg DBA EXAMS17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Fri, 3 Aug 2001 10:12:14 -0500709_us-ascii What platform? For UDB I have the DB2 Universal Database v7.1 Certification Guide. It worked for me.
From: "Vadavalli, Sirish B230" @RYCI.COM on 08/03/2001 08:25 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Reg DBA EXAMS
Hi ALL,
I wanted to have all your INPUTS big or small as most of you are veterans in this area? I want to get myself some good certification to go the level of DB2 dba ADMINISTRATION. Right now my job requires that.I have been working with DB2 all along [...]
11683 19 31_SQL stored procedures on OS/3903_AAM19_aam_db2@HOTMAIL.COM30_Fri, 3 Aug 2001 09:57:48 -0500305_- Hi, I would like to know how to return a result from a cursor in a SQL procedure created on OS/390 (DB2 udb 6.1) ? THe documentation manual says that "return to client" is not supported on OS/390. I am writing Stored Procs now ... and need to send result sets (from a cursor) to some applications. [...]
11703 48 38_Re: [Fwd: BMC to pay for v7 utilities]12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 3 Aug 2001 08:18:00 -0700431_us-ascii I don't think us customers have to stand for it and "live with it." We ought to be able to complain and maybe if IBM gets enough complaints and it costs them some money, they'll be forced into changing the pricing scheme to something reasonable. Remember Oracle tried to force a new pricing scheme down its customers throats and was eventually forced to back off. The same type of thing can and should happen to IBM. [...]
11752 22 38_DB2 Consultant / DBA looking for a job13_Edward Vassie20_E.Vassie@BIGFOOT.COM30_Fri, 3 Aug 2001 16:12:27 +0100584_iso-8859-1 Does anybody want a mainly house-trained consultant or DBA?
Due to a reorganisation at BMC, I am now looking for a job. My preference is England, but failing that will consider anywhere.
Please contact me on e.vassie@bigfoot.com for my career details.
Many thanks for any help anyone can give.
Ed Vassie
================================================ 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.
11775 25 27_Peoplesoft on os/390 vs AIX13_Helen Johnson25_helen_johnson@RAC.RAY.COM30_Fri, 3 Aug 2001 10:19:41 -0500473_us-ascii Hi,
One of the divisions of our company has Peoplesoft on DB2 on the mainframe. Because of the high cost of out-sourcing this application, they are considering shifting the application to DB2 on AIX. What are the pros and cons of one platform over the other. Does one cost less, perform better, etc.? Has anyone moved Peoplesoft from one platform to the other? What was the effort? Which platform did you like better? Any opinions will be appreciated. [...]
11801 58 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 3 Aug 2001 08:23:09 -0700585_us-ascii I agree 100%. Until IBM or anyone else repeals the law of "IT DEPENDS", us humans will have to be involved. Having "self-tuning" will make most of our lives easier. Then we can spend more time working on the more difficult tuning issues rather than fixing dumb defaults and basic common sense tuning. --- Rohn.Solecki@MTS.MB.CA wrote: > I agree also. "Self tuning" is a nice starting point, but at some > point > the real world will always throw a curve that the self tuning > algorithm > can't handle and intelligent human intervention is required solve the > resulting [...]
11860 83 35_Re: Data Replication Problem. Help!15_Jackson Reavill18_damcon2@US.IBM.COM30_Fri, 3 Aug 2001 11:26:30 -0400578_us-ascii Have any changes taken place recently? Could it be that column IMBSNAP_LOGMARKER got left off of the target table after being dropped and recreated? It doesn't show up in ASN.IBMSNAP_SUBS_COLS, but make sure it's on the target table.
HTH, Jay
Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - Bavarian Motor Works ----------------------------------------------------- [...]
11944 33 35_Re: SQL stored procedures on OS/39010_Ben Reches33_Benjamin.Reches@MORGANSTANLEY.COM30_Fri, 3 Aug 2001 11:33:12 -0400533_us-ascii with return will return the result set to the next highre level program in the calling hierarchy; regardless if it's a client program (c, java, cobol) or if it is a sproc. the doc is ambiguous
ben
AAM wrote:
> Hi, > I would like to know how to return a result from a cursor in a SQL > procedure created on OS/390 (DB2 udb 6.1) ? > THe documentation manual says that "return to client" is not supported on > OS/390. > I am writing Stored Procs now ... and need to send result sets (from a > cursor) [...]
11978 83 31_Re: DB2 OS390 LARGE Tablespaces16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM30_Fri, 3 Aug 2001 16:32:34 +0100516_us-ascii Jim,
try this link:
http://www-4.ibm.com/software/data/db2/udb/ad/v61/release.htm
HTH. Have a nice weekend, everybody!
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com
1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK
* std. disclaimer * MY OPINIONS ARE MY OWN AND NOT THOSE OF MY EMPLOYER [...]
12062 83 17_Re: Reg DBA EXAMS22_Vadavalli, Sirish B23026_Sirish.Vadavalli@CIGNA.COM30_Fri, 3 Aug 2001 11:32:52 -0400639_us-ascii Thanks, jeremy, Is it available online ?.or if it is available as a book where I can order it from.
Thanks Sirish Vadavalli
> -----Original Message----- > From: Jeremy Schleicher [SMTP:Jeremy_Schleicher@MAY-CO.COM] > Sent: Friday, August 03, 2001 11:12 AM > To: DB2-L@RYCI.COM > Subject: Re: Reg DBA EXAMS > > What platform? For UDB I have the DB2 Universal Database v7.1 > Certification Guide. It worked for me. > > > > From: "Vadavalli, Sirish B230" @RYCI.COM on > 08/03/2001 08:25 AM > > Please respond to DB2 Data Base Discussion List > > Sent by: DB2 Data Base [...]
12146 110 28_Partitioning Recommendations11_James Drewe20_James.Drewe@AEXP.COM30_Fri, 3 Aug 2001 08:34:02 -0700486_us-ascii Marcus
I am making an assumption that this application is OLTP and not data warehouse. Since the access is by product, I think it would be best if you continued to partition by product. You could tighten up on the skewing by adjusting the range of your partitioning keys. Prior to doing this, I would do some checking to see if the access to a particular product is more prevalent than others. That would help you in repartitioning with a new product/policy range. [...]
12257 118 17_Re: Reg DBA EXAMS17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Fri, 3 Aug 2001 10:48:00 -0500430_us-ascii I got mine from amazon.com for like 60$ It comes with a copy of DB2 7.1 personal edition. You might find it cheaper else where.
From: "Vadavalli, Sirish B230" @RYCI.COM on 08/03/2001 10:32 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: [...]
12376 38 21_Create Thread Problem15_Morris, Deborah20_DMorris@UNCH.UNC.EDU30_Fri, 3 Aug 2001 12:05:33 -0400515_iso-8859-1 All,
I am receiving a sqlcode -981and reason code 00C12219
Explanation: The application program issued an SQL or IFI function request without completing CREATE THREAD processing. SQL or IFI requests cannot be issued until CREATE THREAD processing is complete. User Response: You can continue processing with a corrected request.
when trying to invoke a Cobol batch program that creates a thread to DB2 using RRS/AF and then makes a call to a DB2 Cobol Stored Procedure. [...]
12415 97 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement24_The Fillmore Group, Inc.18_fillmore@CLARK.NET30_Fri, 3 Aug 2001 12:11:38 -0700343_us-ascii I've seen a number of posts going back and forth and before more folks work themselves into a lather, here are some things to keep in mind:
1) DB2 UDB on Intel and RISC has seven levels of optimization vs. one for MVS-OS/390-z/OS. There's a published API with several ways to select the appropriate level of optimization. [...]
12513 148 17_Re: Reg DBA EXAMS15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM30_Fri, 3 Aug 2001 11:03:11 -0500564_us-ascii Sirish , Just go to Border's book shop and get it..... or go to www.redbooks.com and search for DB2 books.
Jeremy Schleicher cc: Sent by: DB2 Data Subject: Re: Reg DBA EXAMS Base Discussion List
08/03/01 10:48 AM Please respond to DB2 Data Base Discussion List
I got mine from amazon.com for like 60$ It comes with a copy of DB2 7.1 personal edition. You might find it cheaper else where. [...]
12662 24 38_Re: [Fwd: BMC to pay for v7 utilities]9_Rob Crane22_racrane@CONCENTRIC.NET30_Fri, 3 Aug 2001 10:08:36 -0600351_us-ascii Seems like a great opportunity to have DBA's go to their CIO and dazzle them with all these figures and point out how beneficial a Hummer would be for the oncall DBA in a DR situation.
Have the Hummer rotate with the on-call DBA, so regardless of peril the DBA could navigate to the office in the worst disaster and save the day. [...]
12687 103 48_DB2v5 /mvs : Foreign key references unique index17_Jean-Luc Loubeyre25_jean-luc.loubeyre@BRED.FR30_Fri, 3 Aug 2001 17:55:11 +0200390_iso-8859-1 DB2v5 /mvs : Foreign key references unique index ================================== Hello,
I believed that it was possible with DB2 releave v5 (OS=MVS), to declare a foreign key referencing only a unique index : without declaring in the parent table a primary key. It is interesting when the unique index contain column(s) allowing null values (in the parent table). [...]
12791 25 17_Re: Reg DBA EXAMS14_Charles Heinze22_Programmer1969@AOL.COM28_Fri, 3 Aug 2001 12:20:49 EDT74_US-ASCII I came into this discussion late. What book are we talking about?
12817 63 35_Re: SQL stored procedures on OS/3900_24_markus.schaub@SYSTOR.COM30_Fri, 3 Aug 2001 18:21:15 +0200475_us-ascii hi
in your stored proc do:
- add the with return clause to the declare cursor - open the cursor
- do not fetch any rows because these will then not be returned to the caller and do not close the cursor, just leave the stored proc.
regards markus
AAM cc: Sent by: DB2 Subject: [DB2-L] SQL stored procedures on OS/390 Data Base Discussion List [...]
12881 23 38_Re: [Fwd: BMC to pay for v7 utilities]12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Fri, 3 Aug 2001 11:32:32 -0500319_us-ascii Myron:
Do you believe that if MODIFY was a "no cost" utility that this would end? Or, do you believe that each utility would have to be priced separately? This is not a question of what is best, but of what is achievable. I am interested in finding out what change would make this more acceptable. [...]
12905 43 38_Re: [Fwd: BMC to pay for v7 utilities]12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Fri, 3 Aug 2001 11:52:45 -0500326_iso-8859-1 And while you are at it Rob, could you convince BMC to use the Hummer as the company issued car? Since its paying for the customers as well ... I'd even allow the bumper sticker on the back ...
Tom Moulder (BMC Software, Inc.) my opinions, with tongue firmly implanted in my cheek, not my employers ... [...]
12949 78 38_Re: [Fwd: BMC to pay for v7 utilities]12_Myron Miller22_myronwmiller@YAHOO.COM30_Fri, 3 Aug 2001 10:37:43 -0700574_us-ascii Modify is only one of the issues. Personally, I think that each utility should be priced separately. Then each could stand on its own merits. And the customer can pick or choose which they need. Or compare easily with third party. That way they could buy some from IBM that are more critical to overall data integrity, ie Modify. And be able to choose based upon a true competitive analysis considering price, features, ease of use, etc the others such as reorg, image copy, load, unload. Then just to get some of the critical ones, they wouldn't be forced to [...]
13028 114 38_Re: [Fwd: BMC to pay for v7 utilities]12_tim malamphy20_timalamphy@YAHOO.COM30_Fri, 3 Aug 2001 11:28:22 -0700578_us-ascii Interesting exchange going one, but bogging down with who's doing what to who, getting into technical details, and forgetting about the customer. As an actual customer who had to calculate the bill for any upgrade, hardware or software, and get it approved by corporate bean counters, I was always at a loss to explain why ISV's wanted a bucket of money for doing nothing. The last upgrade I did, for an additional CPU on an existing box, (we were adding a new workload) totalled roughly 1.75 million. 250K of that was for the hardware and 1.5M was [...]
13143 67 17_Re: Reg DBA EXAMS12_Susan Lawson24_susan_lawson@YLASSOC.COM30_Fri, 3 Aug 2001 13:42:53 -0500581_US-ASCII Sirish,
You need to go to http://www.ibm.com/certify to get the information regarding each exam and the requirements.
There are several books out there that can help and there are links to them from this site. The books necessary will depend on the Certification desired (OS/390 or other platforms).
Regards, Susan
******************************************** * Susan Lawson * * DB2 for OS/390 Certified Solutions Expert* * IBM DB2 and S/390 Gold Consultant * * YL&A, Inc * * www.ylassoc.com * ******************************************** [...]
13211 34 17_Re: Reg DBA EXAMS17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Fri, 3 Aug 2001 13:44:43 -0500416_us-ascii DB2 Universal Database v7.1 for Unix, Linux, Windows adn OS/2 Database Administration Certification Guide. It was written by 2 guys from IBM's Toronto Lab. It is what I used to get ready for my certification exams.
Jeremy
From: Charles Heinze @RYCI.COM on 08/03/2001 11:20 AM
Please respond to DB2 Data Base Discussion List [...]
13246 49 22_Parsing employee names14_Charles Heinze22_Programmer1969@AOL.COM28_Fri, 3 Aug 2001 14:56:48 EDT545_US-ASCII Here is my problem: The employee name in our database is one 55 character field in the format of latname,firstname middlename (with commas and spaces where indicted). We have to send a file to one of our vendors and they want last ame, first name and middle initial in separate fields. We have software that can execute a query and produce a file outside of a program. I can produce all of the other data in a query. We do not have platimum or most other commonly used utilities. Is there any way I can parse that field outside of [...]
13296 112 24_V6 Triggers, CCSID, Help8_Ken Kane24_kkane@UBSPAINEWEBBER.COM30_Fri, 3 Aug 2001 14:50:31 -0400520_iso-8859-1
Hello , I had a problem trying to set up a simple trigger upon a table which was created under DB2 V4. The trigger was going to write the before image of each updated row to a new table created under V6. When I run the create for the trigger, I receive the following. -189 CCSID ccsid IS UNKNOWN OR INVALID FOR THE DATA TYPE OR SUBTYPE SYStablespace tells me that the SBCS_CCSID of the old TS to be 0 as it was created pre V5. The new TS has a SBCS_CCSID of 37. Both are EBCDIC. The manual seems [...]
13409 24 76_Re: SMART: A paradigm shift in the way IBM thinks about database mana gement0_17_JTonchick@AOL.COM28_Fri, 3 Aug 2001 15:15:37 EDT456_US-ASCII SMART is already in the latest release of IMS. With V7 of IMS DB, they introduced a new database structure called HALDB (High Availability Large Database). It does "self healing" of pointers and secondary indexes. Check out the IMS page for more details.
http://www-1.ibm.com/support/techdocs/atsmastr.nsf/PubAllNum/PRS185
As for when this come to DB2, my guess is after DB2 development has "digested" the Informix acquisition. [...]
13434 44 63_Controlling column width in CLP output (DB2 UDB EEE 7.1 on AIX)0_26_Steve.Westfall@EQUIFAX.COM30_Fri, 3 Aug 2001 14:19:45 -0500329_us-ascii I have noticed when running queries using the Command Line Processor that there doesn't seem to be any relationship between the width of a column in the database and the display width that the CLP uses. For example, in the query below:
db2 "select schemaname, owner from syscat.schemata order by schemaname" [...]
13479 75 26_Re: Parsing employee names12_McKown, John22_JMckown@HEALTHAXIS.COM30_Fri, 3 Aug 2001 14:29:54 -0500264_- CAUTION! I am not really very DB2 literate, I mainly "lurk" here to learn & hope. But I am fairly familiar with SQL (PostgreSQL at home, to be more exact). Perhaps the following query will help (the name of the table is EMP, the name of the field is NAME). [...]
13555 158 26_Re: Parsing employee names13_Daniel Turner28_daniel_turner@ALBERTSONS.COM30_Fri, 3 Aug 2001 13:42:31 -0600613_- select substr(col1,1,(posstr(col1,",")-1)) as last_name ,substr(col1,(posstr(col1,",")+1),(posstr(col1," ")-posstr(col1,","))) as first_name ,substr(col1,(posstr(col1," ")+1)) as middle_initial
This may come across in this font but you can get the idea.
POSSTR is used to find the comma and that is used for the end of the last name and beginning of the first name POSSTR is used to find the blank and that is the end of the first name and the start of the middle initial. the + or - 1 is so you don't pick up the blank or the comma in the answer. SUBSTR does the rest but you could use LEFT [...]
13714 70 28_Re: V6 Triggers, CCSID, Help15_Steven Morrison33_steven.morrison@FIRSTDATACORP.COM30_Fri, 3 Aug 2001 14:34:03 -0500290_us-ascii I believe there is a fix for your problem. We had a similar problem. The text of the problem was something like: If sysstrings data set was created prior to Version4...... I don't remember all the details or the fix PTF number. Have your sysprog do a search on -189 sysstings [...]
13785 31 19_DB2 Sr. DBA Opening14_Pete McQuillen19_pete@OSG-GLOBAL.COM30_Fri, 3 Aug 2001 15:03:02 -0500353_iso-8859-1 Job Opening in the North Suburbs of Chicago, Full-Time and non-consulting position.
Looking for a strong individual who are able to perform lead DBA duties and hands on DBA duties. Assist with architecture and design of large DB2 EEE for object maintenance and creation, backups, Unix databases and tuning. Data warehouse design. [...]
13817 29 18_UDB for OS/390, NT13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM30_Fri, 3 Aug 2001 15:06:23 -0500311_us-ascii We are using the mainframe to access a table on UDB/NT v6.1. If we do not give DBADMIN authority to the userid we get a -551. We are not comfortable giving that kind of access to our programmers.
Is there a way to give CONNECT with SIDU access only to this userid and not receive the -551? [...]
13847 54 43_Re: Install DB2 not in /usr/lpp and fixpaks20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM30_Fri, 3 Aug 2001 20:36:45 +0000333_- Hi Ed
If you are using HACMP, then you need to install the DB2 code on both machines - on filesystems that are not shared between the machines. Only the DB2 data is on "shared" disk. Therefore you have to install any fixpaks twice.
(I don't think that you can install DB2 in any other filesystem than /usr/lpp.) [...]
13902 27 33_Re: DB2 DBA needs a job - Citizen13_Mohammad Khan20_mkkhan88@HOTMAIL.COM30_Fri, 3 Aug 2001 16:07:09 -0500527_- What's going on ? In another thread you are looking for a person to fill a similar position. Can't you match the two or it's something more complicated than that ?
On Thu, 2 Aug 2001 15:55:27 -0500, Sue Young wrote:
>Hello, > >Does anyone know of a company in Dallas, Texas that is looking for a Senior DB2 DBA? >Has worked in large database environment. Contract or full time > >Sue Young >Technology Solutions >(972) 463-6300 - Office >(972) 463-6301 - Fax >sueyoung@airmail.net > [...]
13930 54 33_Re: DB2 DBA needs a job - Citizen9_Sue Young20_sueyoung@AIRMAIL.NET30_Fri, 3 Aug 2001 17:39:48 -0500481_iso-8859-1 I have a great DB2 DBA that is looking but he hasn't got current Cobol.
I need someone that programms in Cobol and can also be a DB2 DBA.
Sue
Sue Young Technology Solutions (972) 463-6300 - Office (972) 463-6301 - Fax sueyoung@airmail.net ----- Original Message ----- From: Mohammad Khan Newsgroups: bit.listserv.db2-l To: Sent: Friday, August 03, 2001 4:07 PM Subject: Re: DB2 DBA needs a job - Citizen [...]
13985 159 75_Re: DB2EUG: Controlling column width in CLP output (DB2 UDB EEE 7.1 on AIX)0_26_Steve.Westfall@EQUIFAX.COM30_Fri, 3 Aug 2001 17:35:40 -0500512_us-ascii Patrick,
Serves me right for using an old reference book!
I was looking at Don Chamberlin's book, "A Complete Guide to DB2 Universal Database," which was published in 1998. It's Appendix D gives the system catalog layouts, and he shows those columns as CHAR(8). Don's book is still very useful, but it came out when version 5 was current, so I guess IBM has changed those columns since then. I wish he would put out a revised edition, but he told me he's not working on one. Too bad. [...]
14145 135 32_Nonpartitioned TS with DSNUM > 012_Scott Jewell21_sjewell@FREDMEYER.COM30_Fri, 3 Aug 2001 15:38:25 -0700392_iso-8859-1 Hi,
Does anyone know how/where DB/2 keeps track of the files associated with a nonpartitioned tablespace that has extended into multiple datasets?
Our DBAs have a process for ensuring every tablespace has a current entry in SYSCOPY and it's having trouble figuring out whether or not every file associated with the tablespace does in fact have a current backup. [...]
14281 25 33_Re: DB2 DBA needs a job - Citizen13_Jimmy Willett13_JRLBW@AOL.COM28_Fri, 3 Aug 2001 21:46:41 EDT25_US-ASCII i can do that...
14307 40 63_People Soft Financial Product on DB2 V5 for OS/390 and Runstats13_John Davidson21_jdadmin@IDATATECH.NET30_Fri, 3 Aug 2001 22:47:24 -0400
14348 175 67_Re: People Soft Financial Product on DB2 V5 for OS/390 and Runstats12_Isaac Yassin20_yassini@BEZEQINT.NET30_Sat, 4 Aug 2001 11:36:34 +0200378_iso-8859-1 Hi, I'm not familiar with peoplesoft but have a gut feeling that it has to do with the temp and work file growing all the time. I would look at how they are definded (segmented or simple) and how do they get cleaned before each process ("delete from" or "load dummy record"). Reorg of those files (while empty) can help as well the get rid of those extra pages. [...]
14524 54 53_Db2 dba/Unix job opportunity in Quincy, Massachusetts13_Hopkins, John20_JMHopkins@KFORCE.COM30_Sat, 4 Aug 2001 14:18:19 -0400518_- > Hi Everyone: > I am actively seeking an experience DB2DBA/ on UNIX to work in a large > financial services company in Quincy, MA. I am working directly with the > hiring manager who I placed in his position. The candidate will learn > ORACLE and work with a team of 4. The position will pay up to $85K + > Bonus + 4 weeks vacation. Let me know if you can think of anyone that > might be interested. > > John Hopkins > John Hopkins > Sr. SEARCH CONSULTANT > KFORCE.COM- BOSTON OFFICE > Formerly SOURCE/ROMAC > [...]
14579 165 68_Re: People Soft Financial Product on DB2 V5 for OS/390 and Runsta ts14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Sat, 4 Aug 2001 13:07:27 -0700637_iso-8859-1 John, The optimizer is aware of the index and without runstats default filter factors tend to favor index access. Phil
-----Original Message----- From: John Davidson To: DB2-L@RYCI.COM Sent: 8/3/01 7:47 PM Subject: People Soft Financial Product on DB2 V5 for OS/390 and Runstats
Hi:
We are running DB2 V5 on OS/390 People Soft FS7.51. Runstats are running regularly except for temp and work type tables which have statistics plugged for 70,000 rows. The AP Matching process has been running longer and longer. This process is running on MVS as a batch job. People Soft sent someone to help us. Their [...]
14745 89 72_Application Developers,IDUG North America 2002, May 12-16, San Di ego,Ca14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Sat, 4 Aug 2001 19:09:45 -0700674_- Are you an Application Developer or involved with developing applications that access DB2 on any platform? If so we are interested in having you present at IDUG NA 2002. Attendee feedback indicates that more sessions on Application Devlopment are needed. If you are a developer that is developing applications that access DB2, I urge you to submit an abstract for consideration for presentation at IDUG 2002. IDUG is interested in applications developed with Visual Basic, PowerBuilder, C/C++, CLI, JAVA, COBOL, IDE environments, Websphere, etc. that access DB2. Presentations on the use, configuration and implementation of triggers, stored procedures, User Defined [...]
14835 95 41_Re: Other's experience with ONLINE REORG?10_Alan Smith25_alancsmith@BTINTERNET.COM30_Sun, 5 Aug 2001 10:57:07 +0100574_us-ascii Only starting to use it in production, and not when other things are running, but have found this:
For non-partitioned tablespaces, it's a lot faster - this is because it's like using NOSYSREC which we feel is too dangerous to use normally. Safer when things fall over - no recovery. The BUILD2 phase for NPIs on partitioned tablespaces slows things down a lot. The non-persistent shadow tablespaces built for the logical partitions of NPIs take up a lot of space - e.g., if you have an NPI with a PRIQTY of 2 gig and you are reorging ten partitions at [...]
14931 167 28_Re: V6 Triggers, CCSID, Help16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Sun, 5 Aug 2001 20:59:59 +0100758_us-ascii Ken,
this looks like APAR UQ49651. From IBMLink:
"APAR NUMBER: PQ42601 RESOLVED AS: PROGRAM ERROR
ABSTRACT: PQ42601: SQLCODE189 ON CREATING TRIGGER WITH WHEN CLAUSE IN DATABASES CREATED PRE-V5.
ORIGINATING DETAILS: DSNT408I SQLCODE = -20100, ERROR: AN ERROR OCCURRED WHEN BINDING A TRIGGERED SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER :2 SQLCODE -189, SQLSTATE 22522, AND MESSAGE TOKENS 00000 DSNT418I SQLSTATE = 56059 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXEASC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -200 0 0 -1 0 0 SQL DIAGNOSTIC INFORM DSNT416I SQLERRD = X'FFFFFF38' X'00000000' X'00000000' X'F X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION Additional serach arguments: SQLCODE20100 [...]
15099 43 27_Re: another Siebel question16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Sun, 5 Aug 2001 21:06:56 +0100371_us-ascii Bruce,
I asked an ex-colleague who's now at Siebel, and he replied that DB2 7.1 is supported by Siebel 2000. He is currently using this on his own machine. Fixpack to be installed is fixpack 3C, to be installed on top of fixpack 3.
Sorry about the delay, HTH.
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd. [...]
15143 124 23_Re: IEC999I with 0C4-1116_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM30_Sun, 5 Aug 2001 23:37:55 +0100681_us-ascii Bill,
there is an interesting APAR in IBMLink, II10937. there are also other hits, but this one mentions specifically the binder, and lists a series of ISV fixes.
"APAR NUMBER: II10937 RESOLVED AS: (still in transit)
ABSTRACT: II10937: OEM BUGS IN DFP DATA MANAGEMENT - O/C/EOV, ACCESS METHODS, PDSE, LINKEDIT, BINDER
ORIGINATING DETAILS: See also II08212 II07438 II07757 II08264 II08762 II09608 II10937 . This info APAR lists known third-party (OEM) problems in DFP data management components: non-VSAM o/c/eov, sequential access methods, linkage editor, CMM, PDSE and HFS. Where possible, OEM fix numbers are listed. It is by no means a [...]
15268 22 22_OS/390 2.10 and db2 v612_HARBRY ARIZA20_harbry_a@HOTMAIL.COM30_Sun, 5 Aug 2001 19:39:58 -0500
15291 20 28_DISP STAT DISPLAY INCORRECT.23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU30_Mon, 6 Aug 2001 01:21:51 -0000502_iso-8859-1 on OS390 2.8 , db2 v5 and CICS ts 1.3.
after migrating from CICS v4.1 to TS1.3 the DSNC DISP STAT cmd fails to display more the 9,999,999 CALLS. It drops off the 10 or 100 million values.
anyone know where to fix this????
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.
15312 16 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM30_Mon, 6 Aug 2001 01:00:32 -0400452_us-ascii I will be out of the office starting 08/03/2001 and will not return until 08/13/2001.
For DB2 OS/390 assistance contact your support DBA. For Datajoiner / DB2 connect support contact Chuck Krall
================================================ 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.
15329 21 40_-904 and sqlstate 00E7009E. How to solve9_john king24_john_king@REDIFFMAIL.COM30_Mon, 6 Aug 2001 05:16:26 -0000547_- Hi All here is probelm faced by me due to fall back from release 7 to 6. The objects on selection and alteration are giving me sqlcode -904 with reason code 00E7009E. The manual says to notify the system programmer. The system tables have all the entries with for tables and tablespace. I have DBADM authority. Can any body tell me how I will solve the probelm. I have no requirements for data. I can very well delete/drop and recreate with version 6. Is there any method so that I can do without contacting system programmer. If I have to [...]
15351 16 44_Rue V. Pham/IRM/DST/US is out of the office.0_21_RVPham@DSTSYSTEMS.COM30_Mon, 6 Aug 2001 01:10:19 -0500439_us-ascii I will be out of the office starting 08/06/2001 and will not return until 08/13/2001.
Please contact Todd Carmichael 435-4925 or Tracy Hutton while I'm away for immediate attentions
================================================ 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.
15368 80 44_Re: -904 and sqlstate 00E7009E. How to solve17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT30_Mon, 6 Aug 2001 08:14:33 +0100499_us-ascii 00E7009E
Explanation: Object depends on facilities of a release of DB2from which fall back that is later than you are currently running.
System Programmer Response: In order to perform the operation on the object, you must use the release of DB2 that supports the new facilities.
Problem Determination: The requested operation is not performed. An SQLCODE -904 and/or message DSNT501I is issued. Message DSNT501I describes which object has the release dependency. [...]
15449 15 39_Asher Lemel/NYLIC is out of the office.11_Asher Lemel27_Asher_Lemel@NEWYORKLIFE.COM30_Mon, 6 Aug 2001 02:11:02 -0400389_us-ascii I will be out of the office starting 08/06/2001 and will not return until 08/13/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.
15465 110 44_Re: -904 and sqlstate 00E7009E. How to solve9_john king24_john_king@REDIFFMAIL.COM30_Mon, 6 Aug 2001 08:46:48 -0000953_- Hello Massimo , below I m giving the details I got. =======================================================
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E7009E, TYPE OF RESOURCE 00000A00, AND RESOURCE NAME K.DBCDBA .TBTRM21 DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -650 0 0 0 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFD76' X'00000000' X'00000000' X'00000000' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ---------+---------+---------+---------+---------+---------+---------+---------+ DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0 DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 ============================================================= ------------- Original Message -------------- Massimo Biancucci wrote: To:DB2-L@RYCI.COM From:Massimo [...]
15576 84 44_Re: -904 and sqlstate 00E7009E. How to solve16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM30_Mon, 6 Aug 2001 09:57:13 +0100363_us-ascii John,
there are several records for this kind of problem, but really you should contact your sysprog, and tell him/her to have a look in IBMLink or similar, to determine which hit matches your problem most closely.
It may be due, for example, to object having been re-bound with a newer version of SPUFI. BTW, are you in Data-sharing? [...]
15661 104 44_Re: -904 and sqlstate 00E7009E. How to solve9_john king24_john_king@REDIFFMAIL.COM30_Mon, 6 Aug 2001 09:18:46 -0000346_- Hi I have no idea about the IBMLINK. Could you elaborate it. Also I need to delete those objects and recreate fresh. I mean shall I ask the SYSPROTG to delete all the vsam files crated by the objects. If this is the case then how to delete the entries from System tables. I m seeking all your valuable suggestions. Thanks in advance. John [...]
15766 120 44_Re: -904 and sqlstate 00E7009E. How to solve16_Aurora Dell'Anno26_Aurora_DellAnno@CANDLE.COM30_Mon, 6 Aug 2001 10:45:31 +0100492_us-ascii Hi John,
IBMLink is a database that you can access from the web, with a listing of all open and closed problem reports to IBM - you insert search words and it brings out any "hits".
what your sysprog must do, is probably change some JOBLIB statements to point to older versions of software, compatible with v5 - I am assuming they were kept for rollback purposes, but somehow they pointers did not get updated... and now the LIB concatenation has to be put right! [...]
15887 161 44_Re: -904 and sqlstate 00E7009E. How to solve17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT30_Mon, 6 Aug 2001 12:40:31 +0100389_us-ascii About the resource type: 00000A00 Table RD.CR.TB
I don't know what RD is but CR=Creator and TB=Table
Of course you already know the problem is on the table DBCDBA.TBTRM21, the question is why ?
Did you fall back immediatly after the CATMAINT or after several time (for example after creating or altering a table with a datatype or similar born with V7?) [...]
16049 46 31_Re: DB2 V7.1 + CA/EZTRIEVE Plus14_Winston Mangum26_Winston_Mangum@LABCORP.COM30_Mon, 6 Aug 2001 07:38:18 -0400695_US-ASCII Roger, I got an early ship of this APAR. I applied it; refreshed LLA; stopped/started DB2. I then successfully re-ran the job.
Thanks for your help.
Winston Mangum
Winston L. Mangum Laboratory Corporation of America 1912 Alexander Drive RTP, North Carolina 27709 919-572-7509 mangumw@labcorp.com
>>> millerrl@US.IBM.COM 07/31/01 07:35PM >>> I think this looks like APAR PQ50494. Before V7, we did not check to see that the declared host variable length is larger than the length being passed for the PREPARE statement text. The missing check causes a problem for some customers. Having the check causes problems for others. APAR PQ50494 [...]
16096 143 44_Re: -904 and sqlstate 00E7009E. How to solve15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 6 Aug 2001 06:44:11 -0500490_iso-8859-1 Hi, John, I sense a great reluctance to talk to your friendly(?) neighborhood systems programmer on this problem. Why? You should not have to tell the systems programmer how to resolve this problem. Just tell him/her what error messages you are getting and the scenario that is happening when this error comes up. You might also want to supply a short history on the life of this object or what you are trying to do. The sysprog figures out what to do. That is his/her job. [...]
16240 139 62_Re: -904 and sqlstate 00E7009E. How to solve - Another thought15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Mon, 6 Aug 2001 06:47:07 -0500472_iso-8859-1 Hi, John, I am assuming in my previous comment that the systems programmer you are talking about is the one who installed the new version of DB2 and then performed the fallback.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic." - someone named Taylor, www.bookoftruths.com [...]
16380 18 13_Column change14_Karen Campbell16_kcampbe8@CSC.COM30_Mon, 6 Aug 2001 07:46:57 -0400488_us-ascii Hi everyone,
I have a table with a few columns that are described with "not null". I would like them to be "not null with default". Is there any way to change the column without dropping and recreating?
Thanks for any help.
================================================ 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.
16399 26 25_Re: Create Thread Problem15_Rene hendriksen23_rene.hendriksen@UBS.COM30_Mon, 6 Aug 2001 07:01:36 -0500382_ISO-8859-1 Hello Deborah
Is your cobol program doing an explicit "create thread" call to the DSNRLI module and receives a return-code of zero or are you trying to do an implicit connection when executing some SQL ? RRSAF requires explicit connection steps "Identify, Signon and Create thread". In the Create thread function you don't specify any SSID in the parameters. [...]
16426 46 67_Re: People Soft Financial Product on DB2 V5 for OS/390 and Runstats13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM30_Mon, 6 Aug 2001 08:28:11 -0500561_iso-8859-1 I haven't worked with the financials side of Peoplesoft, but I'll take a guess that the issues are similar to HRMS... In general there are some temp/work tables that you do not want to run runstats on -- these tables can grow very large in a short period of time and get emptied out just as fast, so it becomes luck of the draw on what your runstats collects (full vs empty). You want to run runstats when these tables have a full load of data (or manually manipulate the statistics to indicate representative "full" amounts of data). In short, [...]
16473 29 33_Database history time line needed10_john clark20_pak02449@PIXIE.CO.ZA30_Mon, 6 Aug 2001 15:29:41 +0530388_us-ascii Hi all,
Does anyone have a nice document on the above, showing the features that have been introduced into DBMS, going from the days of simple insulation
from access method intricacies to the proposed "Federated" database approach IBM are now talking of.
This would obviously go through first DML, Optimization, RI etc.
Thanks in advance [...]
16503 48 29_Re: DB2 (OS/390) Architecture14_Kunjar Bhaduri28_Kunjar.Bhaduri@FIRSTDATA.COM30_Mon, 6 Aug 2001 09:40:18 -0400615_us-ascii Thanks a lot everybody for your help.
Roger Miller @RYCI.COM> on 08/02/2001 11:36:23 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: DB2 (OS/390) Architecture
One of the best short sections on architecture is the Introduction to DB2 for OS/390 book by Susan Graziano Sloan and An Kilty Hernandez, Prentice Hall and IBM order number SC26-9937. Chapter 3 is the architecture discussion. [...]
16552 85 33_Re: DB2 DBA needs a job - Citizen9_Sue Young20_sueyoung@AIRMAIL.NET30_Mon, 6 Aug 2001 10:05:22 -0500376_iso-8859-1 Call me or send me your private email. Thanks Sue
Sue Young Technology Solutions (972) 463-6300 - Office (972) 463-6301 - Fax sueyoung@airmail.net ----- Original Message ----- From: Jimmy Willett Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, August 03, 2001 8:46 PM Subject: Re: DB2 DBA needs a job - Citizen
i can do that...
16638 37 15_Re: DB2 Connect12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Mon, 6 Aug 2001 10:15:00 -0400583_- There are some good discussions in the archives http://jupiter.ryci.com/archives/db2-l.html. Especially look for Leon Katsnelson's responses to similar ?s.
>>> DB2-L@RYCI.COM@inter2 08/01/01 08:20PM >>> Hi,
We are in the beginning stages of evaluating DB2 connect for web-based front ends. We have also been asked to evaluate the possibility of using dynamic SQL in this configuration. I would be interested in any experiences, positive or negative, that anyone might have with this. Some specific questions we have right now are mostly in the area of security: [...]
16676 19 33_Kevin Davis is out of the office.11_Kevin Davis18_kevin.davis@DB.COM30_Mon, 6 Aug 2001 11:27:07 -0600139_us-ascii I will be out of the office from 08/06/2001 until 08/13/2001.
I will respond to your message when I return.
16696 21 36_Access to DB2 V5 for OS/390 from IIS13_Villa Horacio17_hvilla@TTI.COM.AR30_Mon, 6 Aug 2001 14:37:46 -0300387_iso-8859-1 We are evaluating a web application and I've asked if it's possible to access data on DB2 v5 for OS/390 from Internet Information Server on Windows 2000 Server (or Advanced Server), programmed with ASP. Anybody has some experience with this? I asume I need DB2 Connect (Enterprise?). Any help will be appreciated. Regards, Horacio Villa TTI S.A. Buenos Aires - Argentina [...]
16718 29 40_Re: Access to DB2 V5 for OS/390 from IIS22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR30_Mon, 6 Aug 2001 15:10:25 -0300428_iso-8859-1 > We are evaluating a web application and I've asked if it's possible to > access data on DB2 v5 for OS/390 from Internet Information Server on Windows > 2000 Server (or Advanced Server), programmed with ASP.
Here we have DB2 V5.1 on OS/390 being accessed by IIS on Windows NT. We use the Client Application Enabler V5 (and the ancient V3.2 on some NT machines). Programmes are written in ASP (VBScript). [...]
16748 49 17_Re: Column change64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM30_Mon, 6 Aug 2001 14:12:54 -0600553_ISO-8859-1 You can do that with CDB/AutoConvert. See www.cdbsoftware.com
Todd Burch
-----Original Message----- From: kcampbe8@CSC.COM Sent: Monday, August 06, 2001 10:50 AM To: DB2-L@RYCI.COM Subject: Column change
-------------------------------------------------------------------------- -- Hi everyone,
I have a table with a few columns that are described with "not null". I would like them to be "not null with default". Is there any way to change the column without dropping and recreating? [...]
16798 43 40_Licensing question - DB2 UDB V6.1 on AIX14_Marshall Fuqua19_marcfuqua@YAHOO.COM30_Mon, 6 Aug 2001 13:09:46 -0700495_us-ascii I have a question regarding licensing for DB2 UDB V6.1 running under AIX.
We have 2 instances on the server - one for the DAS (instance owner: db2admin) & another instance for the applications databases (instance owner: db2was3). When I execute the 'db2licm -l' command for db2was3, the licenses for DB2 EE & DB2 Connect EE show as permanent, which is good. When I execute db2licm -l for db2admin, the licenses for DB2 EE & DB2 Connect EE show as expired, which isn't good. [...]
16842 49 23_Re: DB2 Sr. DBA Opening16_Richard Hagedorn27_Richard_Hagedorn@EXCITE.COM30_Mon, 6 Aug 2001 14:13:04 -0700667_us-ascii Sorry, contract only.
On Fri, 3 Aug 2001 15:03:02 -0500, DB2 Data Base Discussion List wrote:
> Job Opening in the North Suburbs of Chicago, Full-Time and > non-consulting position. > > Looking for a strong individual who are able to perform lead DBA duties > and hands on DBA duties. Assist with architecture and design of large > DB2 EEE for object maintenance and creation, backups, Unix databases and > tuning. Data warehouse design. > > SKILLS NEEDED: Analysis, Technical documentation, Maintenance, Design, > Programming, Implementation, Project Lead, Verbal skills, Writing > skills, Client interface. DB2EEE for Unix DB/2, [...]
16892 32 66_UDB ver. 7.2 - authority question - SYSADM and START/STOP DATABASE14_Jeffrey Benner29_Jeffrey_Benner@NOTES.NTRS.COM30_Mon, 6 Aug 2001 11:38:34 -0500386_us-ascii Does anyone know a way to grant a consulting DBA SYSADM authority but prevent her from being able to START/STOP the instance? This question arises in the case of a consultant who has been brought in to do detailed performance monitoring (who therefore needs sysadm authority) but the client would like to block consultants in general from being able to stop/start the database.
16925 35 25_Re: UDB for Unix Training14_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 6 Aug 2001 21:12:08 -0500682_- http://www-4.ibm.com/software/data/db2/skills/
find "Self-Study Course DOWNLOAD AVAILABLE AT NO CHARGE!", and follow the links.
While this course is, perhaps, not "great", it is "great value for money"
James Campbell
On Thu, 2 Aug 2001 10:28:27 -0500, Scott Trometer wrote:
>Listers, > >Our shop will be implementing UDB for Unix soon and we need to begin some >basic training. Our current skill-sets include DB2 V5/6 on Os/390. > >We are really looking for a good Unix class and a good UDB V6 or V7 >Administration class to get started. Can anyone recommend a vendor(s) for >these classes? In the past, we [...]
16961 70 36_Re: Nonpartitioned TS with DSNUM > 014_James Campbell25_jacampbell@ACSLINK.NET.AU30_Mon, 6 Aug 2001 21:47:38 -0500359_- >Does anyone know how/where DB/2 keeps track of the files associated with a >nonpartitioned tablespace that has extended into multiple datasets?
I think the only accessible place is HPGHPREF (which is in the header page (ie first page in the A001 dataset) at offset x'10'), which contains "High preformatted page in page set (or in partition)." [...]
17032 16 47_Frank Yao/CACI/Prudential is out of the office.9_Frank Yao24_frank.yao@PRUDENTIAL.COM30_Tue, 7 Aug 2001 01:01:47 -0400436_us-ascii I will be out of the office starting 08/06/2001 and will not return until 08/13/2001.
If this is an emergency, please contact Eileen Bennett at 716-6451 or Pat Kelly at 716-1559.
================================================ 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.
17049 43 26_Partitioned table recovery13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM30_Tue, 7 Aug 2001 07:01:20 -0500395_us-ascii Our shop has several partitioned tables each in its own space, one of which is so large it must be imagecopied by partition or it runs out of storage. After the imagecopy of all partitions is made, a quiesce point is taken for the tablespace. This weekend we had a situation where we had to recover the table. When the recover was issued for the entire table to the quiesce point: [...]
17093 77 30_Re: Partitioned table recovery16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Tue, 7 Aug 2001 18:06:14 +0530462_- Kathy,
Just a quick interpretation of thoughts (which may be wrong).
Let's assume there is a tablespace with 5 parts P1 to P5. All the partitions are image copied at time T1 to T5 respectively. Where, T1
Anyone know how I can capture the high water mark on remote connections to an OS/390 DB2 V6 system?
================================================ 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.
17188 129 30_Re: Partitioned table recovery11_Bikash Paul19_bikash_db@YAHOO.COM30_Tue, 7 Aug 2001 06:37:39 -0700440_us-ascii Kathy, What you are doing is right. If image copy is taken partition wise, then recovery needs to be done partition wise also. If you use DSNUM ALL, then it will look for image copy dataset in SYSIBM.SYSCOPY with partition as 0, and it does not find as image copy was taken partition wise. If quiesce point is taken after the image copy of all the partitions, then all the partition could be recovered till the quiesce point. [...]
17318 44 40_Re: Access to DB2 V5 for OS/390 from IIS11_Bikash Paul19_bikash_db@YAHOO.COM30_Tue, 7 Aug 2001 06:43:19 -0700605_us-ascii Yeah .. U have use to DB2 connect and do ODBC programming to connect to DB2 on OS/390. It could be Enterprise Edition OR person Edition depending upon need.
Regards, Bikash
--- Villa Horacio wrote: > We are evaluating a web application and I've asked if it's possible > to > access data on DB2 v5 for OS/390 from Internet Information Server > on Windows > 2000 Server (or Advanced Server), programmed with ASP. > Anybody has some experience with this? > I asume I need DB2 Connect (Enterprise?). > Any help will be appreciated. > Regards, > Horacio [...]
17363 63 70_Re: UDB ver. 7.2 - authority question - SYSADM and START/STOP DATABASE11_Bikash Paul19_bikash_db@YAHOO.COM30_Tue, 7 Aug 2001 06:46:02 -0700355_us-ascii Hi Jeffrey, SYSADM will have DB2 start and Stop authority. I am not sure whether anything could be done from DB2 side.
But i have some wild idea !! .. You can mobe "db2start" and "db2stop" executables into a separate folder and dont allow execute priviledge to these two modules to SYSADM users groups. I mean usix CHMOD will do it.. [...]
17427 87 69_Re: OS/390 as Enterprise Database Server for Distributed Architecture10_Tom Taylor17_ttaylor@CHUBB.COM30_Tue, 7 Aug 2001 09:48:25 -0400469_us-ascii Bill
side question about your connect from aix to os/390 via ddcs. are you using SNA or IP. Are there any advantages/ disadvantages
Tom
Bill Gallagher cc: Sent by: DB2 Data Subject: OS/390 as Enterprise Database Server for Distributed Base Discussion List Architecture
08/03/01 08:37 AM Please respond to DB2 Data Base Discussion List [...]
17515 67 40_Re: Access to DB2 V5 for OS/390 from IIS13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Tue, 7 Aug 2001 09:41:22 -0500311_iso-8859-1 ... Ensure you get the facts on the licensing for DB2 Connect. As stated, you will need DB2 Connect. If you do not know the number of users, which is often the case for internet web applications and possibly intranet applications, then you need to purchase the unlimited edition of the product. [...]
17583 130 70_Re: UDB ver. 7.2 - authority question - SYSADM and START/STOP DATABASE14_Jeffrey Benner29_Jeffrey_Benner@NOTES.NTRS.COM30_Tue, 7 Aug 2001 09:48:21 -0500603_us-ascii Bikash wrote:
"But i have some wild idea !! .. You can mobe "db2start" and "db2stop" executables into a separate folder and dont allow execute priviledge to these two modules to SYSADM users groups."
I had that idea too, but since the CLP command DB2 START DATABASE MANAGER seems to be a synonym for db2start, I do not know whether behind the scenes DB2 START DATABASE MANAGER directly executes db2start or whether both the CLP command and db2start don't both call underlying libraries which would be unaffected by a chmod to the main db2start executable. So even if you did [...]
17714 23 26_Partitioned table recovery19_José Ignacio Ossuna16_jiossuna@ATCA.ES30_Tue, 7 Aug 2001 16:58:22 +0200584_us-ascii Kathy,
if you make image copies separately by partition or data set, you must recover the partitions or data sets by separate RECOVER operations.
RECOVER TABLESPACE DATAWHS.BIHSTS DSNUM 1 TABLESPACE DATAWHS.BIHSTS DSNUM 2 TABLESPACE DATAWHS.BIHSTS DSNUM 3 TABLESPACE DATAWHS.BIHSTS DSNUM n
Hope this helps Nacho.
================================================ 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.
17738 86 40_Re: Access to DB2 V5 for OS/390 from IIS13_Villa Horacio17_hvilla@TTI.COM.AR30_Tue, 7 Aug 2001 12:01:31 -0300390_iso-8859-1 I think there aren't so many IBM reps here in Argentina to get the same answer from them...
Now more seriously, thanks for your suggesting. Regards, Horacio
-----Mensaje original----- De: DB2 Data Base Discussion List En nombre de Mackey, Glenn Enviado el: Martes 7 de Agosto de 2001 11:41 Para: DB2-L@RYCI.COM Asunto: Re: Access to DB2 V5 for OS/390 from IIS [...]
17825 14 31_Re: DB2 V7.1 + CA/EZTRIEVE Plus12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 7 Aug 2001 10:02:52 -0500439_- I'm happy that it works. Several of your managers were at Silicon Valley Lab in June. Please press on the CA folks to fix their coding, so this won't catch them the next time.
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.
17840 61 70_Re: UDB ver. 7.2 - authority question - SYSADM and START/STOP DATABASE14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Tue, 7 Aug 2001 11:32:43 -0400553_us-ascii Jeffrey:
By giving SYSADM to a person you are giving him lot more potentially destructive power than START/STOP database. I guess my question is why is the client apprehensive about START and STOP when the consultant will have powers to DROP the entire database.
Manas.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Jeffrey Benner Sent: Monday, August 06, 2001 12:39 PM To: DB2-L@RYCI.COM Subject: UDB ver. 7.2 - authority question - SYSADM and START/STOP DATABASE [...]
17902 69 42_Re: Stored Porcedure Builder & Schema Name11_Rick Rogers21_Rick.Rogers@TELUS.COM30_Tue, 7 Aug 2001 09:49:52 -0600603_iso-8859-1 Hi Jim,
We had significant problems with this. We found that neither the CURRENT SQLID, nor the CURRENT SCHEMA registers were able to give us the qualification of our unqualified tables we sought.
What ended up being the qualifier was, believe it or not, the schema of the stored procedure. The IBM lab worked hard for us but was unable to correct this behavior in the time we had available. If you have the flexibility (that our environment didn't have) to create the stored procedures in the schema that you want the unqualified tables to be qualified with, perhaps that [...]
17972 71 40_Re: Access to DB2 V5 for OS/390 from IIS13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM30_Tue, 7 Aug 2001 11:21:23 -0500357_iso-8859-1 You can also use NEON Systems Shadow Direct. Shadow Direct not only provides access to DB2 via ODBC, but virtually all other data residing on your OS/390 platform. This includes IMS, CICS transactions, Adabas, VSAM, M204 and more. Since our Server runs on your OS/390 system, we do not have any requirements for additional gateway hardware. [...]
18044 16 37_Re: Database history time line needed12_Roger Miller19_millerrl@US.IBM.COM30_Tue, 7 Aug 2001 12:06:38 -0500484_- The SQL Reunion paper has a lot of history in it. http://www.research.digital.com/SRC/personal/Paul_McJones/System_R/
The web still seems to have some kinks in it, but I did not see what you seem to be asking for.
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.
18061 61 38_Re: [Fwd: BMC to pay for v7 utilities]10_CEI, Bruno20_Bruno.CEI@SEMA.CO.UK30_Tue, 7 Aug 2001 18:25:44 +0100548_iso-8859-1 Certainly an interesting debate, and there is something that I would like to add.
As a matter of fact, I can't believe that a commercial company is giving away anything, let alone giving you money that will end up in their competitor's pocket !
I haven't a clear idea (yet) of what it will financially mean to have the utilities unbundled from DB2 V7 and to buy them separately, but what appears to me to be major problem is that from now on we will need to make either IBM or an ISV our first choice, and that, if we [...]
18123 84 30_Re: Partitioned table recovery13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 7 Aug 2001 10:35:35 -0700479_iso-8859-1 Because what you are expecting DB2 to do is to perform 'n' SEPARATE recoveries (n= no. of partitions) with a single RECOVER statement as DB2 will have to allocate image copy datasets for partitions which were image copies at different times in the past; so one Recovery for each partition; 'n' recoveries for 'n' partitions all with ONE recover statement !!! Well DB2 says sorry.....and I think rightly so. On Recovery statement is meant to perform one recovery. [...]
18208 29 27_Stored Procedures in DB2 V618_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM30_Tue, 7 Aug 2001 13:47:10 -0400394_iso-8859-1 When Stored Procedures are created is anyone controlling the naming convention of SP's or doesn't one really care? I'm curious as to if any shops are setting any standards for naming SP's and if they use a particular SCHEMA. We are just entering this world and I'm wondering if we need any controls like this in place or just open it up and let-er-rip. Appreciate any feedback. [...]
18238 18 8_DB2 TMON12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM30_Tue, 7 Aug 2001 14:07:41 -0400476_us-ascii Hi All, We have been experiencing CPU spikes where 2 of our DB2's jump to about 30% each of CPU usage. This is reported thru TMON/MVS. This happens every minute give ot take a few seconds. WE are currently Version 6 OS/390 2.9. What we found out is that if we disconnect and diable TMON/DB2 from the 2 DB2's the spike goes away. Has anyone else seem this within your shop? Any ideas on where we can investigate why every minute this seems to trip something? TIA [...]
18257 74 38_Re: [Fwd: BMC to pay for v7 utilities]0_21_db2_dba@BELLSOUTH.NET30_Tue, 7 Aug 2001 14:52:29 -0400339_us-ascii To follow up on one of Bruno's points, the IBM utilities will be there. They will function on SYSIBM objects. You will be able to backup your catalog and directory using good old dependable, reliable, getting faster and more functional IBM. Also, if you get into a jam IBM should be able to enable the utilities in a crunch. [...]
18332 49 31_Re: Stored Procedures in DB2 V612_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 7 Aug 2001 11:56:04 -0700608_us-ascii My client has a complete set of standards, including valid Schemas. They've modified DSNTPSMP to enforce these standards. I'll grant that modifying DSNTPSMP is not the best in the world, but there were too many areas in it that didn't work correctly when they got into SPB so they were forced into some modifications. --- "Whittaker, Stephen" wrote: > When Stored Procedures are created is anyone controlling the naming > convention of > SP's or doesn't one really care? I'm curious as to if any shops are > setting > any standards > for naming SP's and if they [...]
18382 84 31_Re: Stored Procedures in DB2 V612_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 7 Aug 2001 14:29:25 -0500329_us-ascii Hello.
We have naming conventions for Stored Procedures. One weakness I'm seeing is the relationship (or lack thereof) between the long procedure name and the short "external" name. I almost wish we had standardized to always use the short name, because we often forget the long name and have to look it up. [...]
18467 29 27_A Nifty Tool -- WinZip Lite12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 7 Aug 2001 14:44:15 -0500614_us-ascii Here's part of a note I got recently from our PowerBuilder guy. I'm using this product and liking it a lot. And, the price is right.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
I've found a free SQL utility that works great with DB2 and SQL Server. It reminds me of the SQL Server ISQL_w program, but has an additional tab that presents the database catalog (tables, views, etc.) in a graphical tree view, like PowerBuilder. WinSQL Lite has a small footprint, so installing it on your home or work computer shouldn't be a problem. It does require an ODBC driver, so you'll have to install [...]
18497 23 29_Attention all you UNIX gurus!17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Tue, 7 Aug 2001 14:58:09 -0500473_us-ascii Hello listers. I need some help with something. I have been told it is possible to run multiple versions of DB2 on the same machine. Not multiple instances but versions. Here is the situation; We have one AIX box. We want to have a production, development and test environment where we could have 3 different versions of DB2 running. Does anyone know how I would go about doing this? Can someone point me to a book or a manual that mentions how this is done? [...]
18521 16 31_Re: A Nifty Tool -- WinZip Lite12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 7 Aug 2001 15:05:09 -0500303_us-ascii Ooops. I meant WinSQL Lite!
Sorry.
Stg
================================================ 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.
18538 60 33_Re: Attention all you UNIX gurus!12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 7 Aug 2001 13:38:57 -0700579_us-ascii It's pretty simple once you've done it. Just install (not upgrade!) the new version, and let it install into the default library it wants. Version 6 will go into db2_06_01 libraries, Version 7 will go into db2_07_01 libraries, etc. Use smitty and it will show you the fileset names for each product. Your admin server (of which you can have only one) will have to be at the newest level though. If a single user wants to toggle between new and old versions, you have to set up separate ".profile"s or "db2profile"s that they execute before they switch instances so [...]
18599 148 69_Re: OS/390 as Enterprise Database Server for Distributed Architecture12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 7 Aug 2001 13:51:09 -0700481_us-ascii Go with IP. But upgrade to DB2 Connect instead of using the old DDCS... 1.Easier to set up 2.WAY faster 3.Offloads work from your expensive 3725/3745 front end onto the "cheaper" net gear. 4.Gets the VTAM guy out of the loop...he'll owe you a lunch.
As far as AIX HA vs OS/390... I think it's mostly a religious issue at this time. Go with whatever expertise you have in house. If I had a full blown datasharing environment already in place, I'd put it there. [...]
18748 81 33_Re: Attention all you UNIX gurus!17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM30_Tue, 7 Aug 2001 16:01:40 -0500713_us-ascii Ok how do I have 3 different "Copies" of the same version?
From: tim malamphy @RYCI.COM on 08/07/2001 03:38 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: Re: Attention all you UNIX gurus!
It's pretty simple once you've done it. Just install (not upgrade!) the new version, and let it install into the default library it wants. Version 6 will go into db2_06_01 libraries, Version 7 will go into db2_07_01 libraries, etc. Use smitty and it will show you the fileset names for each product. Your [...]
18830 18 10_One volume14_Rowell, Dean A19_dean.rowell@EDS.COM30_Tue, 7 Aug 2001 16:00:29 -0500497_iso-8859-1 I am trying to encourage our customer to leave an older shop standard of 1 volume per stogroup. Is there any reason that I may be missing on keeping 1 volume or diskpack per stogroup?
Dean Alan Rowell Work (219)675-0227 HQ (219)273)-7328
================================================ 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.
18849 61 31_Re: Stored Procedures in DB2 V611_Rick Rogers21_Rick.Rogers@TELUS.COM30_Tue, 7 Aug 2001 15:16:49 -0600417_iso-8859-1 We are just completing a project that was developed 50% - 60% with stored procedures.
We laid down some very simple naming conventions. They are differentiated by the system, and by whether they are common modules or process modules. Looking back, I would have preferred to include a subsystem designation as well. Our client had already determined which schema we would use for building them. [...]
18911 45 21_Index access question24_Mahadevan Krishnamoorthy45_mahadevan.krishnamoorthy@FARMERSINSURANCE.COM30_Tue, 7 Aug 2001 14:15:25 -0700423_us-ascii Hi List,
I have a query like this
SELECT adj_desc, adj_amt, adj_comments, applied_dtstmp FROM TWEB_FOLIO_ADJ WHERE eff_yr_mth BETWEEN :range1 AND :range2 AND agent_num = ? AND adj_category_cd = '1' AND adj_cd not in ('L','P') ORDER BY applied_dtstmp
Its a partitioned table with only one index , partitioned on eff_yr_mth.
The partiton index key have eff_yr_mth, agent_num [...]
18957 104 33_Re: Attention all you UNIX gurus!12_Lorraine Yan22_lorraine.yan@TELUS.COM30_Tue, 7 Aug 2001 15:37:15 -0600382_iso-8859-1 Why do you need 3 copies of the same version. Would it not be simplier to have 3 db2 instance owners (say db2prd,db2dev,db2tst) ? Are you concerned about being able to run different patch levels of the same version ? Lorraine Yan
TELUS Enterprise Solutions Database Services Email: lorraine.yan@telus.com Phone: (604) 432-5720 [...]
19062 191 25_Re: Index access question14_Grainger, Phil20_Phil.Grainger@CA.COM30_Tue, 7 Aug 2001 22:54:54 +0100344_iso-8859-1 You will not get a MATCHCOLS 2 with this whilst you have a range predicate on the first column.
DB2 will be scanning from :range1 to :range2 and looking at the values for the second column in each case. This is as good as it will get.
For matchcols 2 you would need a simple predicate on the first column (like =) [...]
19254 24 20_Insert Performance ?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Tue, 7 Aug 2001 17:00:00 -0400342_- We have a large process (selects, updates but mostly inserts) that runs for approx 10 hours. The data is partitioned/clustered by random key into 3 partitions. The input data is not sorted by this random key...Death by random synchronous I/O.
Due to time constraints for the programming staff, the sort is not soon forthcoming. [...]
19279 84 25_Re: Index access question0_19_mike.holmans@BT.COM30_Tue, 7 Aug 2001 23:29:41 +0100575_iso-8859-1 MATCHCOLS always stops when you reach a range predicate.
If you are desperate to see MATCHCOLS = 2, then you would have to write it as WHERE eff_yr_mth IN (v1, v2, v3) AND agent_num = ?, or you could partition on (agent_num, eff_yr_mth).
The fact that agent_num isn't a "matched" column isn't a disaster, though. DB2 will still screen the index using the subsequent column, and it will not go to the data for rows where agent_num <> ?. All you're losing is a little bit of time scanning index entries, and even then it's not much. It's going to [...]
19364 34 23_Binding for DRDA access13_Villa Horacio17_hvilla@TTI.COM.AR30_Tue, 7 Aug 2001 19:57:50 -0300420_iso-8859-1 Hi everybody,
I set up the CDB to access a remote database from OS/390. I can run queries from SPUFI and is working OK. But then I want to access it from a Cobol program which also access data on my local subsystem. I coded: (some sql to my local DB) ... EXEC SQL CONNECT TO SAMPLE END-EXEC ...... (select to my remote database) EXEC SQL CONNECT RESET END-EXEC ... (some other sql to my local DB) [...]
19399 106 31_Re: OS/390 as Enterprise Server14_Philip Gunning24_Philip.Gunning@QUEST.COM30_Tue, 7 Aug 2001 16:24:18 -0700451_- Bill, I think it depends. To decide if you have a highly available DB2 Unix
Cluster or use an existing DB2 OS/390 datasharing or non-datasharing environment, I think you need to look at quite a few criteria, as well as Total Cost of Ownership, including organizational changes required to implement either solution, operating and support costs, changes in the company culture, skill requirements, etc, etc. HACMP is excellent but can be [...]
19506 16 36_Available Space for a storage volume13_Carlton Enuda24_carltonenuda@HOTMAIL.COM30_Tue, 7 Aug 2001 19:43:18 -0400
19523 84 42_Re: Stored Procedure Builder & Schema Name10_teldb2kals22_teldb2kals@TELSTRA.COM30_Wed, 8 Aug 2001 10:04:38 +1000586_us-ascii Wdn't the QUALIFIER parameter of the BIND for the stored procedure package take care of the unqualified tables ? Thats what we normally do.
Cheers, Kals
-----Original Message----- From: Rick Rogers [SMTP:Rick.Rogers@TELUS.COM] Sent: Wednesday, August 08, 2001 1:50 AM To: DB2-L@RYCI.COM Subject: Re: Stored Porcedure Builder & Schema Name
Hi Jim,
We had significant problems with this. We found that neither the CURRENT SQLID, nor the CURRENT SCHEMA registers were able to give us the qualification of our unqualified tables we sought. [...]
19608 23 54_Paul Packham/ITS/POSG/POSTOFFICE is out of the office.12_Paul Packham26_paul.packham@CONSIGNIA.COM30_Wed, 8 Aug 2001 01:03:35 +0000534_us-ascii I will be out of the office from 08/08/2001 until 14/08/2001.
I will respond to your mail when I return, however please contact Tim Hayes or Neil Miller if urgent.
Regards Paul
This email and any attachments are confidential and intended for the addressee only. If you are not the named recipient, you must not use, disclose, reproduce, copy or distribute the contents of this communication. If you have received this in error, please contact the sender and then delete this email from your system. [...]
19632 50 56_DDF TCPIP insert Performanace & Blocking or not blocking31_=?iso-8859-1?q?Alex=20Andrade?=22_alexdandrade@YAHOO.COM30_Wed, 8 Aug 2001 01:44:56 +0100353_iso-8859-1 I am at a site that are using DB2 connect V7 on NT and UDB v6 on OS390 v 2.8 connection is via TCPIP.And mainframe connection is an OSA card straight into the Ethernet LAN.
The distributed applications sole purpose is to insert and update massive amounts of data into DB2 segmented and partitioned tables.....so now the question. [...]
19683 118 24_Re: Insert Performance ?14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU30_Wed, 8 Aug 2001 11:17:52 +1000349_iso-8859-1 Hi Bob,
Does the phrase "page split" ring any (alarm) bells?
I think you may experience "Death by random synchronous I/O" + a few squillion page splits if you do that. The idea of Freespace/freepage is to leave room for the inserts. From the manuals (V5):
"5.3.1.2 Reserve Free Space in Table Spaces and Indexes [...]
19802 28 42_Re: identifying rouge weblogic connections15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Aug 2001 11:44:24 +1000419_- Oh, very droll, Dave. ;o)
Raymond PS. Possibly would have sent something similar myself, but I've been away lately.
> -----Original Message----- > From: David Booher [SMTP:David.Booher@QUEST.COM] > Sent: Friday, August 03, 2001 4:14 AM > To: DB2-L@RYCI.COM > Subject: Re: identifying rouge weblogic connections > > > > The rouge connection would be the RED one....sorry, couldn't resist! > [...]
19831 32 38_Re: [Fwd: BMC to pay for v7 utilities]15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Aug 2001 13:06:02 +1000581_- I would think having your tongue implanted in your employer's cheek would be a bit difficult. ;o)
Raymond PS. To all you stunt-DBAs out there; please don't try this at work.
> -----Original Message----- > From: Moulder, Tom [SMTP:Tom_Moulder@BMC.COM] > Sent: Saturday, August 04, 2001 2:53 AM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > And while you are at it Rob, could you convince BMC to use the Hummer as > the > company issued car? Since its paying for the customers as well ... I'd > even allow the bumper sticker [...]
19864 48 38_Re: [Fwd: BMC to pay for v7 utilities]12_Moulder, Tom19_Tom_Moulder@BMC.COM30_Tue, 7 Aug 2001 22:37:18 -0500441_iso-8859-1 ROTFL
Tom
-----Original Message----- From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] Sent: Tuesday, August 07, 2001 10:06 PM To: DB2-L@RYCI.COM Subject: Re: [Fwd: BMC to pay for v7 utilities]
I would think having your tongue implanted in your employer's cheek would be a bit difficult. ;o)
Raymond PS. To all you stunt-DBAs out there; please don't try this at work. [...]
19913 63 27_Re: Binding for DRDA access15_Janardhan Ragam16_sragam@YAHOO.COM30_Tue, 7 Aug 2001 20:55:17 -0700387_us-ascii Ideally you would bind the program (create packages) on both databases (use "sqlerror continue" bind option if necessary). Then, create a plan on os/390 with a pklist that includes remote location/s, for example ..* or *..*. We have implemented several applications this way and have had no issues. Let me know if you need more help in setting this up. [...]
19977 70 25_Re: Index access question16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 8 Aug 2001 09:36:47 +0530332_- Maha,
Phil and Mike have described almost everything. One more thing to look at what is the PAGE_RANGE in EXPLAIN. It should be individual partition scan depending on the range specified by you. You do not have to bother about matchcols to be 2 because screening will take care of that. How is this query performing ? [...]
20048 58 37_Help - Partition Performance Problems12_Marcus Green18_mgreen@AAPT.COM.AU30_Wed, 8 Aug 2001 14:05:32 +1000677_US-ASCII Hi,
I've just gone through a process of changing a 64 Partitioned table into a 156 partitioned table and expanding the partition key, and now appear to have major performance issues on queries that need to touch the data pages!
The partition key is for example as follows:
Decimal(2,0) Char(30) Time
PART 1 VALUES(01.,'04 '), PART 2 VALUES(01.), PART 3 VALUES(02.,'04 '), PART 4 VALUES(02.), PART 5 VALUES(03.,'04 '), PART 6 VALUES(03.), . . PART 132 VALUES(61.,'03 '), PART 133 VALUES(61.,'07123 '), PART 134 VALUES(61.,'07123 ','11:59:59'), PART 135 VALUES(61.,'07123 ','15:59:59'), PART 136 VALUES(61.,'07 '), PART 137 VALUES(61.), [...]
20107 63 38_Re: [Fwd: BMC to pay for v7 utilities]15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Aug 2001 14:22:13 +1000593_- ROTFL?
> -----Original Message----- > From: Moulder, Tom [SMTP:Tom_Moulder@BMC.COM] > Sent: Wednesday, August 08, 2001 1:37 PM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > ROTFL > > Tom > > -----Original Message----- > From: Bell, Raymond W [mailto:Raymond.W.Bell@TEAM.TELSTRA.COM] > Sent: Tuesday, August 07, 2001 10:06 PM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > > I would think having your tongue implanted in your employer's cheek would > be > a bit difficult. ;o) > > > Raymond > PS. To all you stunt-DBAs out [...]
20171 74 41_Re: Help - Partition Performance Problems15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Aug 2001 14:21:42 +1000628_- Run runstats yet? Got partition-level statistics? Done your rebinds? Just an idea...
Raymond
> -----Original Message----- > From: Marcus Green [SMTP:mgreen@AAPT.COM.AU] > Sent: Wednesday, August 08, 2001 2:06 PM > To: DB2-L@RYCI.COM > Subject: Help - Partition Performance Problems > > Hi, > > I've just gone through a process of changing a 64 Partitioned table into a > 156 partitioned table and expanding the partition key, and now appear to > have major performance issues on queries that need to touch the data > pages! > > The partition key is for example as follows: > > Decimal(2,0) Char(30) [...]
20246 79 38_Re: [Fwd: BMC to pay for v7 utilities]15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM30_Wed, 8 Aug 2001 14:24:40 +1000609_- Never mind. Found it on Whatis.com. Glad you appreciated it. Unless you're being sarcastic, in which case, knobs to you!
Raymond
> -----Original Message----- > From: Bell, Raymond W > Sent: Wednesday, August 08, 2001 2:22 PM > To: 'DB2 Data Base Discussion List' > Subject: RE: [Fwd: BMC to pay for v7 utilities] > > ROTFL? > > -----Original Message----- > From: Moulder, Tom [SMTP:Tom_Moulder@BMC.COM] > Sent: Wednesday, August 08, 2001 1:37 PM > To: DB2-L@RYCI.COM > Subject: Re: [Fwd: BMC to pay for v7 utilities] > > ROTFL > > Tom > > -----Original Message----- > From: Bell, [...]
20326 80 41_Re: Help - Partition Performance Problems16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM30_Wed, 8 Aug 2001 10:07:36 +0530344_- Marcus,
One of the sample explain will help looking if the complete tablespace scan is done and why. What about the cardinality of the partitioning index columns and other columns included in the index. It seems optimizer is finding the usage of other columns first cheaper.
So, send a sample query and its explain report. [...]
20407 149 69_Re: OS/390 as Enterprise Database Server for Distributed Architecture15_Janardhan Ragam16_sragam@YAHOO.COM30_Tue, 7 Aug 2001 21:36:26 -0700404_us-ascii Answers to your questions: 1. Which environment to use - best answer is: It depends. However I would also say that you have to consider application requirements and which environment best meets the needs of the application? If either env works for the app and os/390 env is already in place then I would use an existing system and not waste resources, money on setting up a new system/env. [...]
20557 99 25_Re: Index access question13_Terry Purcell25_Terry_Purcell@YLASSOC.COM30_Tue, 7 Aug 2001 23:37:10 -0500493_us-ascii Mahadevan,
If the 2nd matchcols is doing significant filtering, then getting matchcols = 2 can be a VERY BIG deal....if the between is a large date range then you can't recode as an IN. Thus you are going to scan a huge range of rows to return a small resultset.
You can create a small table which holds all possible date ranges (and that is all), and code the BETWEEN on the small date table, and then join to the larger table. This will give you a matchcols = 2. [...]