1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 1999, week 1
2 58 29_Re: Compression Dictionary...15_Douwe van Sluis23_dbvsluis@WORLDONLINE.NL30_Wed, 1 Dec 1999 09:17:56 +0100634_us-ascii Here's the reply I gave on an earlier question like this....
This is how we handle the creation of the compression dictionaries. Because there is one compression dictionary per partition, we where faced with the creation of over a 1,200 compression dictionaries for a similar situation like yours. I developed the following. I have created a 'mother' compression dictionary tablespace by loading some samples in and than followed by a reorg, to create a better dictionary. Reorg uses all the rows to create the compression dictionary, load only so many to fill the compression dictionary. Did a load replace with [...]
61 128 54_SMS tablespaces on DB2/UDB for Unix (Sun Solaris) V6.111_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU30_Wed, 1 Dec 1999 19:17:52 +1100488_- Posted for a colleague.
Hi All, We are proposing to run a 24*7 Internet based application and database on a Sun cluster configuration. We are currently planning the database layout on disk, and are looking at SMS versus DMS (file) tablespaces.
Busiest tables are random access, no scanning queries; no long varchar nor other data outside regular tablespace; One table projected 10 Gbytes in size, and 6 tables around 1 Gbytes. Other tables are smaller and less busy. [...]
190 12 7_Signoff0_17_wgcruz@BPI.COM.PH30_Wed, 1 Dec 1999 17:09:43 +0800265_us-ascii SIGN-OFF DB2-L
================================================ 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.
203 20 51_DB2 dilemma: From SCOM to current table name / user13_Elliott Yagod19_elliott@ARESHET.COM30_Wed, 1 Dec 1999 04:17:51 -0800495_ISO-8859-1 We have a universal editproc program that may be associated with various tables. We want of derive the current table name and sqlid / authid. We have traced our way to the DB2 “SCOM” block. Where to now?
elliott yagod elliott@areshet.com
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
224 152 48_Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility13_John Schluter24_john.schluter@SWIPNET.SE30_Wed, 1 Dec 1999 04:47:21 -0800459_- Hi!
This is long and divided into:
1. Client versions 2. JAVA type 4 and ODBC type 3
1. Client versions: ---------------
We have been testing 6.1 clients in preparation for upgrading Connect gateways from 5.2 to 6.1.
First, you should note that the 6.1 clients are composed of three different types (or packaging). There are the Runtime, Admin and SDK varieties. The packageing for 5.2 clients is not quite the same. [...]
377 125 23_Re: need help with drda22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Wed, 1 Dec 1999 10:48:43 +0000450_ISO-8859-1 Marg do you have DDF setup etc?
check VTAM as Phil suggests ..
ODBC into OS390 is a breeze normally .. PC -> ODBC -> TCP/IP -> WAN - > OS390 TCP/IP -> DDF -> OS390 .
Leslie Pendlebury-Bowe DB2 OS390 SAP
______________________________ Reply Separator _________________________________ Subject: Re: need help with drda Author: Philip Gunning at Internet Date: 11/30/99 5:25 PM [...]
503 14 20_ODBC Driver for DB2?13_Smith, Glynne20_SmithGly@NABISCO.COM30_Wed, 1 Dec 1999 07:12:34 -0500376_- Does anyone know of an ODBC driver for DB2 on MVS that will support 'bookmarks'? I am trying to transfer data from SQL Server 7.0 to DB2/MVS. In order for SQL Server to perform an UPDATE or DELETE to data in a DB2 table the ODBC driver must support something called 'bookmarks'. SELECT and INSERT work fine with the StarPipes ODBC driver I have, but not UPDATE/DELETE. [...]
518 169 48_Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 1 Dec 1999 08:03:49 -0500590_iso-8859-1 Wow, I guess that answered my questions! Thank goodness for this listserv and the folks who respond. Thanks again!
> -----Original Message----- > From: John Schluter [SMTP:john.schluter@SWIPNET.SE] > Sent: Wednesday, December 01, 1999 7:47 AM > To: DB2-L@RYCI.COM > Subject: Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility > > Hi! > > This is long and divided into: > > 1. Client versions > 2. JAVA type 4 and ODBC type 3 > > 1. Client versions: > --------------- > > We have been testing 6.1 clients in preparation for upgrading > Connect gateways from 5.2 to 6.1. [...]
688 210 48_Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM30_Wed, 1 Dec 1999 13:06:50 +0000509_iso-8859-1 Hi,
I am new to LISTSERV. Could someone please tell me on what mail-id should I post a query to.
Thanks, Dhirendra.
______________________________ Reply Separator _________________________________ Subject: Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility Author: LFlatley (LFlatley@NEFN.COM) at unix,mime Date: 01/12/99 13:03
Wow, I guess that answered my questions! Thank goodness for this listserv and the folks who respond. Thanks again! [...]
899 231 48_Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility26_Uppuluri, Sreenivasa (CTS)25_USreeniv@CHN.CTS-CORP.COM30_Wed, 1 Dec 1999 08:19:46 -0500646_ISO-8859-1 Welcome! You did it right, the very first time. Nice time ,,
> -----Original Message----- > From: Dhirendra Chaudhary [SMTP:Dhirendra.Chaudhary@WDR.COM] > Sent: Wednesday, December 01, 1999 6:37 PM > To: DB2-L@RYCI.COM > Subject: Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility > Importance: High > > Hi, > > I am new to LISTSERV. Could someone please tell me on what mail-id > should I post a query to. > > > Thanks, > Dhirendra. > > > ______________________________ Reply Separator > _________________________________ > Subject: Re: UDB NT 6.1 and DB2 Connect 5.2 compatibility > Author: LFlatley (LFlatley@NEFN.COM) at [...]
1131 51 41_DB2 UDB 6.1 for Windows NT Authentication12_Adam, Daniel15_dadam@GRATEX.SK30_Wed, 1 Dec 1999 14:45:29 +0100604_- Hi all, My first attempts with new 6.1. Seems to me Control Center treats user authentication somehow different than db2cmd.
1. Running Control Center - providing username & pwd is required. Any way around this ? How come implicit attachment through db2cmd works and not with Control Center ?
2. I provide my domain account user&pwd - Control Center accepts that and displays the systems. I try to look at my local instance ( clicking on plus sign next to my system name ) and Control center shows dialog with title "Attach - DB2DAS00", saying "SQL1403N The username and/or password [...]
1183 76 45_Re: DB2 UDB 6.1 for Windows NT Authentication14_Philip Gunning20_pgunning@BOSCOVS.COM30_Wed, 1 Dec 1999 08:57:09 -0800357_us-ascii Daniel, Your userid and password are different for your lan logon versus your NT server logon it appears, at least from my experience. The requirement to logon to the control center is going away in v7 as Leon indicated. You should use your NT server id and password at the second logon and that should be what is defined as sysadm.. HTH Phil [...]
1260 17 16_File Aid for DB250_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM30_Wed, 1 Dec 1999 09:17:53 -0500380_- Has anyone experienced 04c abends with File Aid for DB2 when using another 3rd party s/w product concurrently.
Bob Knight
================================================ 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.
1278 36 23_File Aid for DB2 -Reply11_Jeff Schade15_JSCHADE@PCH.COM30_Wed, 1 Dec 1999 09:32:24 -0500511_- YES. We had this problem with File-Aid DB2 and BMC Catalog and Change Manager. We simply chalked this up to both products using CAF routines to connect to DB2 and we avoid split screen when in File-Aid.
Jeffrey Schade Publishers Clearing House (516) 944-2673 jschade@pch.com
>>> "Knight, Robert A. (Cameron of Pittsburgh at Alcoa)" 12/01/99 09:17am >>> Has anyone experienced 04c abends with File Aid for DB2 when using another 3rd party s/w product concurrently. [...]
1315 87 58_Re: SMS tablespaces on DB2/UDB for Unix (Sun Solaris) V6.19_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM30_Wed, 1 Dec 1999 08:38:52 -0800623_us-ascii Allen,
We're running something similar, with a few larger tablespaces being DMS and the rest SMS, on a Solaris server. So far, we're pleased. I've done some SMS tablespace bufferpool isolation to help performance.
Good luck,
"ALLEN,Bruce" wrote:
> > > Posted for a colleague. > > Hi All, > We are proposing to run a 24*7 Internet based application and database > on a Sun cluster configuration. We are currently planning the database > layout on disk, and are looking at SMS versus DMS (file) tablespaces. > > Busiest tables are random access, no scanning queries; no long varchar [...]
1403 142 34_FW: -905 - exceeds resource limit.14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM30_Wed, 1 Dec 1999 08:41:38 -0600664_iso-8859-1 > Can anyone help me find a better way to set this query up - so that I can > get it this thing to run...? (This is DB2 v5.1 on OS390). > The query runs fine until I try to join the tables based on the substring > of 2 columns. Without building additional columns, I'm not sure how to > get around this... > > Here's the Query: > SELECT > T2.DLRSHP_RATING_ID, > SUBSTR(T3.CORP_DEALER_ID,3,4) AS DEALER, > SUBSTR(T3.CORP_DEALER_ID,1,2) AS BRANCH, > T3.CORP_DLRSHP_STATUS, > T4.TA_AREA_NBR, > T4.TA_TTYPE_IDENT_NBR, > T5.ADDR_CITY, > T5.GL_LOC_ABBR_TEXT, > T6.GROSS_CONTRACT_AMT, > T6.GROSS_FINANCE_AMT, > T6.CURRENT_BALANCE, > T6.GROSS_RESID_VALUE, [...]
1546 41 37_MAXROWS 1 - LOCKS held : Implications19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM30_Wed, 1 Dec 1999 14:50:46 +0000632_US-ASCII Hi All,
A query :
What are the implications of MAXROWS = 1 on the locks ( DDF and all ) and concurrency. I know that it improves the concurrency but am unsure as to the effects of this on the lock management issues.
Any replies would be appreciated.
Regards, Dhiren.
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from [...]
1588 19 11_revoke auth17_Bartolucci Silvia25_S.Bartolucci@FONDIARIA.IT30_Wed, 1 Dec 1999 15:43:43 +0100454_- Is there anyone who have ready made queries to perform revoke of db2 os/390 auths ?
(ex : i must revoke all the auths of an user , on database , on tables , on collection and so on)
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.
1608 66 41_Re: MAXROWS 1 - LOCKS held : Implications20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 1 Dec 1999 10:02:51 -0500341_- MAXROWS 1 has the same implication as ROW LEVEL locking. In comparison with row level locking - Number of locks are same but there is extra I/Os because number of pages = number of rows (with MAXROWS=1).
In datasharing environment, this has high CF overheads. You have to see the break-even between concurrency & CF overheads. [...]
1675 90 45_Re: DB2 UDB 6.1 for Windows NT Authentication11_Daniel Adam15_dadam@GRATEX.SK30_Wed, 1 Dec 1999 09:30:35 -0800621_- Philip,
There is no NT server id, I use only domain account. Still, I don't see why should Control Center behave different from db2cmd.
Thanks Daniel
On Wed, 1 Dec 1999 08:57:09 -0800, Philip Gunning wrote:
>Daniel, Your userid and password are different for your lan logon versus >your NT server logon it appears, at least from my experience. The >requirement to logon to the control center is going away in v7 as Leon >indicated. You should use your NT server id and password at the second >logon and that should be what is defined as sysadm.. HTH Phil [...]
1766 145 26_Re: -905 exceeds limit....14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM30_Wed, 1 Dec 1999 09:36:47 -0600641_iso-8859-1 My apologize if this posted 2x.
> Can anyone help me find a better way to set this query up - so that I can > get it this thing to run...? (This is DB2 v5.1 on OS390). > The query runs fine until I try to join the tables based on the substring > of 2 columns. Without building additional columns, I'm not sure how to > get around this... > > Here's the Query: > SELECT > T2.DLRSHP_RATING_ID, > SUBSTR(T3.CORP_DEALER_ID,3,4) AS DEALER, > SUBSTR(T3.CORP_DEALER_ID,1,2) AS BRANCH, > T3.CORP_DLRSHP_STATUS, > T4.TA_AREA_NBR, > T4.TA_TTYPE_IDENT_NBR, > T5.ADDR_CITY, > T5.GL_LOC_ABBR_TEXT, > T6.GROSS_CONTRACT_AMT, [...]
1912 51 27_Re: File Aid for DB2 -Reply12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Wed, 1 Dec 1999 15:40:00 -0000429_- We have never had any problem with using BMC Cat Manager and File-Aid DB2 concurrently.
Colin. ---------- From: Jeff Schade To: DB2-L@RYCI.COM Subject: File Aid for DB2 -Reply Date: 01 December 1999 14:32
YES. We had this problem with File-Aid DB2 and BMC Catalog and Change Manager. We simply chalked this up to both products using CAF routines to connect to DB2 and we avoid split screen when in File-Aid. [...]
1964 42 20_Re: File Aid for DB211_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US30_Wed, 1 Dec 1999 09:38:53 -0600348_- We have also had this problem. I now advise my BMC Catalog and Change Manager users to exit File_Aid and then they can use the BMC products.
Tony Clark DB2 System Administrator Texas Woirkforce Commission 15th Congress Ave ADP Room 320 Austin, Texas 78778-0001 E-Mail: tclark@twc.state.tx.us Phone: (512) 463-3079 Fax: (512) 936-3190 [...]
2007 74 20_Re: File Aid for DB213_Greg Myers-GB15_myers.gb@PG.COM30_Wed, 1 Dec 1999 10:54:27 -0500480_us-ascii I used to have a problem accessing these products at the same time until I upped the amount of region available to my TSO session.
Greg Myers
Internet Mail Message Received from host: [208.225.214.81] [208.225.214.81]
Envelope Sender: owner-db2-l@ryci.com
From: "Clark, Tony" on 12/01/99 10:38 AM
Please respond to DB2 Data Base Discussion List [...]
2082 62 20_Re: File Aid for DB216_Rasmussen, Steen23_steen.rasmussen@CAI.COM30_Wed, 1 Dec 1999 15:58:32 -0000595_- If the message being displayed, is mentioning recursive use, then there is an open IBM APAR for this problem. As far as I remember, it has been released but withdrawn again.
Hope this is usefull. Steen D. Rasmussen Computer associates Denmark
> -----Original Message----- > From: Clark, Tony [SMTP:Tony.Clark@TWC.STATE.TX.US] > Sent: 01 December 1999 16:39 > To: DB2-L@RYCI.COM > Subject: Re: File Aid for DB2 > > We have also had this problem. I now advise my BMC Catalog and Change > Manager users > to exit File_Aid and then they can use the BMC products. > > Tony Clark [...]
2145 49 15_Re: revoke auth13_Chuck Hinchey22_chinchey@RJCONSULT.COM30_Wed, 1 Dec 1999 10:14:36 -0600363_iso-8859-1 Silvia,
I have recently completed many such revokes for a client and can give you some pointers. Since my work was for a client, I don't actually have the SQL, but I will check with them and see if I can get it for you. In the mean time, I can help you create the SQL you need, it isn't too complex, but does require a little manipulation. [...]
2195 36 39_Re: DATE function to reduce CPU time???14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Wed, 1 Dec 1999 10:23:24 -0600369_ISO-8859-1 The reference in my book regarding using the DATE function is outdated and should have been removed. I am currently updating the book for V6 and will make sure that it is removed for the new 4th edition...
Sorry for the confusion this caused...
Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software Craig_Mullins@bmc.com [...]
2232 58 20_Re: File Aid for DB217_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM30_Wed, 1 Dec 1999 10:35:31 -0600311_ISO-8859-1 In a previous life (i.e. former employer) we modified the Catalog Manager command tables to invoke File-Aid DB2 directly for EDit and BRowse of DB2 tables. The CatManager doc describes how to set up custom commands for stuff like this. We never had any problem with those two products together. [...]
2291 179 38_Re: FW: -905 - exceeds resource limit.9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Dec 1999 11:42:22 -0500728_us-ascii I'd like to see if adding this ++ into the predicate and ommitting xxx speeds it up....
Do you have an option of adding an index on corp_dealer_id only ?
WHERE T2.ENT_IDENT_NBR = T3.ENT_IDENT_NBR > AND T2.EA1_IDENT_NBR = T7.IDENTIFICATION_NBR > AND T2.ENT_IDENT_NBR = T4.DEA_ENT_IDENT_NBR > AND T5.ENT_IDENT_NBR = T2.ENT_IDENT_NBR ++ AND T3.CORP_DEALER_ID = SUBSTR(T6.BRANCH,1,2)||SUBSTR(T6.DEALER_NBR,7,4) xxx AND SUBSTR(T3.CORP_DEALER_ID,3,4) = SUBSTR(T6.DEALER_NBR,7,4) xxx AND SUBSTR(T3.CORP_DEALER_ID,1,2) = SUBSTR(T6.BRANCH,1,2) > AND T3.DEALER_TYPE = 'A' > AND T3.CORP_DLRSHP_STATUS = 'ACTIVE ' > AND T7.BLS_SS_IDENT_NBR = 1 > AND T4.TA_TTYPE_IDENT_NBR = 3 > AND T6.DISPOSITION_DATE IS NULL > [...]
2471 47 28_create table with 'index in'20_BREIDENSTINE JOHN L.21_jlb@LEGIS.STATE.PA.US30_Wed, 1 Dec 1999 12:08:42 -0500252_us-ascii Hello all,
What is the purpose of creating a table using 'index in'? Is it for performance reasons? If so, what criteria is used to determine when to and when not to create the indexes in a seperate tablespace?
Thanks in advance.
2519 31 59_Using Microsoft Transaction Server to access DB2 for OS/39012_Lisle, Kathy19_KLLISLE@INTEGON.COM30_Wed, 1 Dec 1999 12:13:09 -0500464_ISO-8859-1 We have some developers who are firmly in the Microsoft camp, and they want to use MTS 2.0 transactions to update DB2 for OS/390 (version 5, for now). Microsoft says:
A transactional Microsoft Transaction Server application on Windows NT that needs to connect to an IBM DB2 database on AS/400, MVS, OS/390, VM, and VSE must use DB2 Connect Enterprise Edition V5 (DB2 Connect EE) and the IBM Communication Server on Windows NT, OS/2, or AIX. [...]
2551 99 41_Re: MAXROWS 1 - LOCKS held : Implications19_Dhirendra Chaudhary27_Dhirendra.Chaudhary@WDR.COM30_Wed, 1 Dec 1999 17:16:06 +0000467_- thanks Venkat.
______________________________ Reply Separator _________________________________ Subject: Re: MAXROWS 1 - LOCKS held : Implications Author: venkat.pillay (venkat_pillay@ML.COM) at unix,mime Date: 01/12/99 15:02
MAXROWS 1 has the same implication as ROW LEVEL locking. In comparison with row level locking - Number of locks are same but there is extra I/Os because number of pages = number of rows (with MAXROWS=1). [...]
2651 64 31_DB2 Version 5 Stored Procedures16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM30_Wed, 1 Dec 1999 12:17:11 -0500500_iso-8859-1 Hi, We are starting to dabble with stored procedures and seem to be having some trouble executing them. The program making the call seems to execute without error, however, receives no return information. DB2 stats show that the stored procedure was never even called. Are there any tricks to this? Is it possible that the stored procedure does not work because it was coded in COBOL for OS390? Does anyone have any thoughts on this? Thanks, Mike Friedlander friedlander@firstinvestors.com
2716 35 32_Re: create table with 'index in'13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 1 Dec 1999 12:31:19 -0500457_- Not to confuse folks, this is a UDB question, i.e. UDB running on NT, UNIX, etc.
Yes, creating your indices in a separate tablespace will help performance in that it will enable you to easily separate the indices from the tables both on the DASD and in the bufferpool. I have tended to use this technique on the larger tables in a database. This means you must define the tablespaces as DMS (database-managed) instead of SMS (system-managed). [...]
2752 209 38_Re: FW: -905 - exceeds resource limit.14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM30_Wed, 1 Dec 1999 11:58:36 -0600635_iso-8859-1 Still abending with a -905... Any other ideas???
Thanks! Mike
> -----Original Message----- > From: Colin Fay [SMTP:cfay2@CSC.COM] > Sent: Wednesday, December 01, 1999 10:42 AM > To: DB2-L@RYCI.COM > Subject: Re: FW: -905 - exceeds resource limit. > > I'd like to see if adding this ++ into the predicate and ommitting xxx > speeds > it up.... > > Do you have an option of adding an index on corp_dealer_id only ? > > WHERE T2.ENT_IDENT_NBR = T3.ENT_IDENT_NBR > > AND T2.EA1_IDENT_NBR = T7.IDENTIFICATION_NBR > > AND T2.ENT_IDENT_NBR = T4.DEA_ENT_IDENT_NBR > > AND T5.ENT_IDENT_NBR = T2.ENT_IDENT_NBR > ++ [...]
2962 13 38_Re: FW: -905 - exceeds resource limit.0_22_Rohn.Solecki@MTS.MB.CA30_Wed, 1 Dec 1999 12:03:52 -0600341_us-ascii Looking at the write up for the -905 error, the error message is supposed to tell you what resource is causing the error, the limit amount that was exceeded and the source of the limit. Have you investigated any of these? Have you increased the time parameter on the JCL job or step? How about posting the whole error message. [...]
2976 66 63_Re: Using Microsoft Transaction Server to access DB2 for OS/3900_15_leon@CA.IBM.COM30_Wed, 1 Dec 1999 13:11:07 -0500521_us-ascii IBM Communication Server is required ONLY is you are using SNA. DB2 Connect Enterprise Edition does support and works very well with MTS applications connected to S/390 over TCP/IP. Use TCP/IP if there is any chance that you can.
DB2 Connect V7 which will go into beta test soon will be adding support for Microsoft SNA Server for those of you who are not able to move to TCP/IP and don't want or can't use IBM Communication Server. I want to emphasise thought that TCP/IP is by far a better choice. [...]
3043 272 38_Re: FW: -905 - exceeds resource limit.9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Dec 1999 15:00:19 -0500773_us-ascii If it runs fine without the 'substr' in the predicate , how about this?
Maybe your resource liinit is too low
SELECT * FROM ( SELECT > > T2.DLRSHP_RATING_ID, > > SUBSTR(T3.CORP_DEALER_ID,3,4) AS DEALER, > > SUBSTR(T3.CORP_DEALER_ID,1,2) AS BRANCH, SUBSTR(T6.DEALER_NBR,7,4) AS DEALER_NBR > > SUBSTR (T6.BRANCH,1,2) AS BRANCH_NBR > > T3.CORP_DLRSHP_STATUS, > > T4.TA_AREA_NBR, > > T4.TA_TTYPE_IDENT_NBR, > > T5.ADDR_CITY, > > T5.GL_LOC_ABBR_TEXT, > > T6.GROSS_CONTRACT_AMT, > > T6.GROSS_FINANCE_AMT, > > T6.CURRENT_BALANCE, > > T6.GROSS_RESID_VALUE, > > T6.EQUIPMENT_COST, > > T2.LME_ACT_CNTRCT_CNT, > > T2.LME_TOTAL_PRIN_BAL > > FROM > > SIDBP01.R_DLRSHP_ACCOUNT T2, > > SIDBP01.R_DLRSHP T3, > > SIDBP01.R_DEERE_DLRSHP_ACT T4, > [...]
3316 273 38_Re: FW: -905 - exceeds resource limit.9_Colin Fay13_cfay2@CSC.COM30_Wed, 1 Dec 1999 15:38:58 -0500772_us-ascii If it runs fine without the 'substr' in the predicate , how about this?
Maybe your resource limit is too low
SELECT * FROM ( SELECT > > T2.DLRSHP_RATING_ID, > > SUBSTR(T3.CORP_DEALER_ID,3,4) AS DEALER, > > SUBSTR(T3.CORP_DEALER_ID,1,2) AS BRANCH, SUBSTR(T6.DEALER_NBR,7,4) AS DEALER_NBR > > SUBSTR (T6.BRANCH,1,2) AS BRANCH_NBR > > T3.CORP_DLRSHP_STATUS, > > T4.TA_AREA_NBR, > > T4.TA_TTYPE_IDENT_NBR, > > T5.ADDR_CITY, > > T5.GL_LOC_ABBR_TEXT, > > T6.GROSS_CONTRACT_AMT, > > T6.GROSS_FINANCE_AMT, > > T6.CURRENT_BALANCE, > > T6.GROSS_RESID_VALUE, > > T6.EQUIPMENT_COST, > > T2.LME_ACT_CNTRCT_CNT, > > T2.LME_TOTAL_PRIN_BAL > > FROM > > SIDBP01.R_DLRSHP_ACCOUNT T2, > > SIDBP01.R_DLRSHP T3, > > SIDBP01.R_DEERE_DLRSHP_ACT T4, > [...]
3590 41 35_Y2K 31 Dec 1999 - Are you working ?14_Max 'Guderian'16_mocion@LIBERO.IT30_Wed, 1 Dec 1999 22:02:53 +0100336_iso-8859-1 Dear collegues
The last day of 1999 I'll be working to check our DB2 and all system & applications.
I don't know if any of you will be working at midnight, but I would like to suggest to use this DB2-
list as a check or, better, as a 'warning list' for DB2 and/or problems in Y2K applications or in [...]
3632 39 35_Re: DB2 Version 5 Stored Procedures13_Lynne Flatley17_LFlatley@NEFN.COM30_Wed, 1 Dec 1999 16:37:48 -0500623_- It could be any number of things but stored procedures must be compiled and linked with COBOL for OS390 (a.k.a. LE/370). The stored procedure was bound into a package and its collection name was specified in the stored procedure's row in SYSIBM.SYSPROCEDURE? The procedure was started using the DB2 START command? You're sure that the calling program checked its SQLCODE and is displaying any erroneous SQLCODEs? You might want to put displays into the stored procedure too, ensuring that the stored procedure address space has a SYSOUT DD statement. Is this running in a DB2-managed or a WLM-managed address space? [...]
3672 192 39_Re: Y2K 31 Dec 1999 - Are you working ?12_McKown, John21_JMckown@INSURDATA.COM30_Wed, 1 Dec 1999 15:36:47 -0600520_- That sounds good to me, but remember: 1. the list is dependant on the listserver at ryci.com staying up 2. your access is dependant on all the routers along the line staying up - yours and others 3. your access is dependant on the telephone system staying up 4. your access is dependant on your ISP staying up (or whatever connects you to the Internet backbone). 5. your access is dependant on your PC staying up. (I assume you're on a PC of some sort) 6. your access is dependant on your mail server staying up. [...]
3865 63 42_COBOL - DB2 access from Open Edition (USS)16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM30_Wed, 1 Dec 1999 16:51:33 -0500448_iso-8859-1 How about this.... I have posted this to the OE and IBM-MAIN listservs, however, received no responses. Has anyone been able to access DB2 files with a COBOL for OS390 program running in OE. All other structures work just fine, PDS, VSAM, QSAM, but DB2 seems problematic. I have linked in module DSNALI, but to no avail. Does anyone have any thoughts? Can or should this even work? Thanks, Mike Friedlander friedlander@firstinvestors.com
3929 47 39_Re: Y2K 31 Dec 1999 - Are you working ?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Wed, 1 Dec 1999 15:38:00 -0500347_- This was brought up sometime ago, and it is an excellent idea!
>>> DB2-L@RYCI.COM@inter2 12/01/99 03:19PM >>> Dear collegues
The last day of 1999 I'll be working to check our DB2 and all system & applications.
I don't know if any of you will be working at midnight, but I would like to suggest to use this DB2- [...]
3977 72 39_Re: Y2K 31 Dec 1999 - Are you working ?0_22_dhonea@TOTALSYSTEM.COM30_Wed, 1 Dec 1999 17:28:31 -0500456_us-ascii I would like to participate. This idea could alert all list members of any problems, possibly before the date change in our respective time zones.
BOB JEANDRON on 12/01/99 03:38:00 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Darrell Honea/Northchase/TotalSystem) Subject: Re: Y2K 31 Dec 1999 - Are you working ? [...]
4050 57 39_Re: Y2K 31 Dec 1999 - Are you working ?12_Marcia Waite17_waite@ACC.FAU.EDU30_Wed, 1 Dec 1999 17:24:06 -0500565_us-ascii Interesting gloom and doom from the DB2 list.
At 03:36 PM 12/01/1999 -0600, you wrote: > That sounds good to me, but remember: >1. the list is dependant on the listserver at ryci.com staying up >2. your access is dependant on all the routers along the line staying up - >yours and others >3. your access is dependant on the telephone system staying up >4. your access is dependant on your ISP staying up (or whatever connects >you to the Internet backbone). >5. your access is dependant on your PC staying up. (I assume you're on a PC >of some [...]
4108 225 38_Re: FW: -905 - exceeds resource limit.12_Terry Spikes21_terryspikes@YAHOO.COM30_Wed, 1 Dec 1999 13:47:26 -0800608_us-ascii Did this work? I think you're in a "Catch-22", Don't Column Functions make it a "Stage 2" predicate (i.e. Non-Indexable i.e. Tablespace scans)? I noticed one of the tabels was 1.3 million rows.
--- Colin Fay wrote: > If it runs fine without the 'substr' in the > predicate , how about this? > > Maybe your resource limit is too low > > > > SELECT * FROM ( > SELECT > > > T2.DLRSHP_RATING_ID, > > > SUBSTR(T3.CORP_DEALER_ID,3,4) AS DEALER, > > > SUBSTR(T3.CORP_DEALER_ID,1,2) AS BRANCH, > SUBSTR(T6.DEALER_NBR,7,4) AS DEALER_NBR > > > SUBSTR (T6.BRANCH,1,2) AS BRANCH_NBR [...]
4334 232 38_Re: FW: -905 - exceeds resource limit.13_John Arbogast16_jfarbo@YAHOO.COM30_Wed, 1 Dec 1999 12:11:14 -0800285_us-ascii Increase your limit in the RLF table or stop it for a moment while your query completes. -sto rlimit. Don't know if you will have the auth. you will want to restart it when you are done. All of this depends on your auth and the rules in your shop about charge back, etc. [...]
4567 14 9_Sort Pool0_20_bjnigh@HOUSEHOLD.COM30_Wed, 1 Dec 1999 16:07:44 -0800369_us-ascii Does anyone know what the sort pool is and how to tune it?
Also, how does tuning DSNDB07 help with performance?
================================================ 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.
4582 50 71_How Can EXPLAIN(YES) be automated in a typical program migration path??16_Christine Sawyer20_cosawyer@HOTMAIL.COM28_Wed, 1 Dec 1999 19:21:04 EST476_- Hi everyone,
We have a decent size programming staff writing code that access DB2 subsytems. We need to define a plan to implement an automated Explain(YES) process in our shop to help the DBA staff (which I'm one) be proactive in supporting our users need for efficient access/retrieval of DB2 data . We have in our shop the following tools: OMEGAMON/DB2, (good ol')DB2PM, PLATINUM suite of Tools (eg DB2 Analyzer, Detector, Log & Plan analyzer, RC/Query etc). [...]
4633 67 15_Re: revoke auth20_AITHA, BHEEMSEN (PB)23_B4AITHA@MSG.PACBELL.COM30_Wed, 1 Dec 1999 16:36:31 -0800654_iso-8859-1 Chuck,
Can you please include me also in your discussion (cc).
Thanx.. Bheemsen Aitha b4aitha@msg.pacbell.com
-----Original Message----- From: Chuck Hinchey [mailto:chinchey@RJCONSULT.COM] Sent: Wednesday, December 01, 1999 8:15 AM To: DB2-L@RYCI.COM Subject: Re: revoke auth
Silvia,
I have recently completed many such revokes for a client and can give you some pointers. Since my work was for a client, I don't actually have the SQL, but I will check with them and see if I can get it for you. In the mean time, I can help you create the SQL you need, it isn't too complex, but does require a [...]
4701 30 34_Dummy 'numbers' in CHAR key column0_14_DPetro@AOL.COM28_Wed, 1 Dec 1999 20:42:16 EST595_us-ascii Hi,
We have many tables keyed by a CHAR(08) column. The values for this column are generated by a program that uses the timestamp to generate a unique, random number. Of course when put in the CHAR(08) column, the value is unreadable. One of our DBAs has raised the suggestion that this column would be more efficient from an access perspective if the column were defined as FLOAT. There is a line in Craig Mullins' book alluding to the use of Base37 arithmetic for accessing CHAR columns and the concern is that because the generated number produces characters outside the [...]
4732 50 13_Re: Sort Pool9_SrinivasG17_SRINIVASG@INF.COM30_Thu, 2 Dec 1999 08:37:47 +0530597_iso-8859-1 Hi,
Sort is invoked when a cursor is opened for a SELECT statement that requires sorting. The maximum size of the sort work area allocated for each concurrent sort user depends on the value you specified for the SORT POOL SIZE field on installation panel DSNTIPC.
The default is 10% the sum of Virtual Bufferpools BP0 , BP1 ...BP32K It is possible for a sort to complete in the buffer pool without I/Os. This is the ideal situation, but it might be unlikely, especially if the amount of data being sorted is large.Segregating work file activity enables you to better [...]
4783 72 38_Re: Dummy 'numbers' in CHAR key column14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Thu, 2 Dec 1999 14:19:14 +1000508_us-ascii Dave,
1) You have to enter a large number of characters. If you use 8 byte float, you have 14 hexadecimal digits in the mantissa, requiring at least 17 decimal digits to represent accurately. (That is, if you have less than 17 decimal digits, the conversion to float may be different in the 14th hex digit. And it might be that you need an 18th digit.) Add an 'E' character, two sign characters and two exponent digits and you may have to have 22 characters to define your search field. [...]
4856 31 15_Re: revoke auth13_Marcel Lepage13_iml@COLBA.NET30_Wed, 1 Dec 1999 22:34:13 -0700604_iso-8859-1 Hi Silvia,
Do you have Platinum RC/Secure tool, it can help you do what you asking for.
Marcel Lepage DBSYS Technologies Inc.
Bartolucci Silvia a écrit :
> Is there anyone who have ready made queries to perform revoke of db2 os/390 > auths ? > > (ex : i must revoke all the auths of an user , on database , on tables , on > collection and so on) > > 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 [...]
4888 69 13_Re: Sort Pool10_Bill Welch27_spgwdw@UCLINK4.BERKELEY.EDU30_Wed, 1 Dec 1999 21:36:14 -0800410_us-ascii >At 04:07 PM 12/1/99 -0800, you wrote: >Does anyone know what the sort pool is and how to tune it? > >Also, how does tuning DSNDB07 help with performance? > >================================================ >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. [...]
4958 21 25_Y2k overtime compensation0_17_JTonchick@AOL.COM28_Thu, 2 Dec 1999 00:45:47 EST323_us-ascii Most of us have already been told that we're celebrating the New Year at our desks watching Sysplex timers roll into the New Year instead of Dick Clark in Times Square. I was wondering what "special" compensation employers have promised employees for the "pleasure" of celebrating at work instead of at home? [...]
4980 29 29_Re: Y2k overtime compensation16_Daniel Boulanger19_dboulang@CA.IBM.COM30_Thu, 2 Dec 1999 01:25:33 -0500423_us-ascii As of now, nothing specific was mentioned.
In our "shop", we had meetings to plan and determine who would be where and when, but during these exchanges the Human Resources was very silent.
Even if they would pay double or triple time, what's the gain. The income taxes will swallow most of it, leaving us with something that was not even worth to ask for. I'd rather have some time off instead. [...]
5010 219 34_Re: -905 - exceeds resource limit.14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU30_Thu, 2 Dec 1999 18:17:43 +1100377_iso-8859-1 Mike,
It has been mentioned, quite correctly, that the issue with this query is that the join been T6 & T3 is stage 2, and therefore not indexable. The access path indicated by your explain shows a nested loop join to T6 via a tablespace scan. For every row retrieved from the joins of the other 5 tables, DB2 must tablespace scan all 82,000 rows of T6. [...]
5230 69 11_ODBC(?) SQL0_29_Greg.Palgrave@BANKWEST.COM.AU30_Thu, 2 Dec 1999 15:20:40 +0800329_us-ascii Just looking for some enlightenment from any ODBC gurus out there.
We have an application connecting to UDB V5.2 on NT using dynamic SQL, and we are seeing a lot of this particular SQL, which I guess from the package name is from the ODBC driver itself, as it is not part of the application that is running. [...]
5300 18 17_change ISO to JIS14_Robert Niemiec23_rniemiec@KRAKOW.TPSA.PL30_Thu, 2 Dec 1999 09:41:46 +0100523_US-ASCII Our installation has TIME FORMAT = ISO in the installtion parameters. We would like to change it to JIS (10:00:00) format. Can I simply stop DB2 change this parameter and start DB2 again? What about consequences of this operation for DB2 system and our application? Robert
================================================ 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.
5319 20 39_AW: Y2K 31 Dec 1999 - Are you working ?13_Raabe, Stefan30_Stefan.Raabe@DRESDNER-BANK.COM30_Thu, 2 Dec 1999 09:43:26 +0100440_- theres also a ibm site for "y2k-alert", you may want to check that one on 12/31/1999 or the days before.....
http://www.ibm.com/software/year2000/alert/
regards
stefan
================================================ 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.
5340 62 39_Re: DATE function to reduce CPU time???24_praveen Kumar komaragiri21_kpkumar@WIPHYD.GE.COM30_Thu, 2 Dec 1999 15:03:49 +0930674_iso-8859-1 Hi Craig, In our shop we are using DB2v4.1, Is 'DATE' Clause is outdated for our use?.
Thanx in advance Praveen Kumar K mailto:kpkumar@wiphyd.ge.com
----- Original Message ----- From: Mullins, Craig Newsgroups: bit.listserv.db2-l To: Sent: Thursday, December 02, 1999 1:53 AM Subject: Re: DATE function to reduce CPU time???
> The reference in my book regarding using the DATE function is outdated and > should have been removed. I am currently updating the book for V6 and will > make sure that it is removed for the new 4th edition... > > Sorry for the confusion this caused... [...]
5403 104 76_Re: How Can EXPLAIN(YES) be automated in a typical program migrat ion path??13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Thu, 2 Dec 1999 09:38:09 -0000660_iso-8859-1 Hi Christine
I've implemented a similar procedure to yours in several places (where tools may or may not have been available). When a program gets migrated from development to test, it's bound EXPLAIN(YES), with a step immediately before it which does: DELETE FROM PLAN_HISTORY WHERE PROGRAM='program' AND BIND_TIME > CURRENT TIMESTAMP - n DAYS ; --where PLAN_HISTORY is a larger copy of V5 PLAN_TABLE, --and n is the number of days worth of access --path history you want to keep) INSERT INTO PLAN_HISTORY SELECT * FROM PLAN_TABLE WHERE PROGRAM='program'; DELETE FROM PLAN_TABLE WHERE PROGRAM='program'; --to keep PLAN_TABLE up to date [...]
5508 83 75_Re: How Can EXPLAIN(YES) be automated in a typical program migration path??9_Colin Fay13_cfay2@CSC.COM30_Thu, 2 Dec 1999 06:41:24 -0500565_us-ascii HI,
One easy way is to place Plan Analyzer into the compile/bind jobstep. I can even be set up to run based on 'as if' it were compiled production - what paths woudl be selected. The difficult part is to get application folks to review the printed output report and look at the high-cost statements and table scans. It also create recommendations , which need to be reviewed for appropriateness. If you want to get Draconian about it you can even set rules in the Plan Analyzer step that would set a higher return code to disallow a bind based [...]
5592 67 35_Re: DB2 Version 5 Stored Procedures18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Thu, 2 Dec 1999 06:25:36 -0600607_iso-8859-1 Mike, check to see that the NODYNAM parm was used if your using a COBOL II SP.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of [...]
5660 41 29_Re: Y2k overtime compensation11_Hilton Tina15_HiltonT@TCE.COM30_Thu, 2 Dec 1999 07:35:23 -0500363_iso-8859-1 We get 2 extra vacation days to be taken any time during 2000. You get that whether you work 1 hour or 36 hours during the 3 day weekend (Monday, January 1st, is supposed to be a holiday for us). That's fine if you work 16 hours or less, since at least it's an even trade of your time. Not so fine if you're unlucky enough to work more than that. [...]
5702 47 29_Re: Y2k overtime compensation15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM30_Thu, 2 Dec 1999 07:43:15 -0500357_iso-8859-1 We are receiving a nice little bonus (expensed it so no taxes) and a day off to help compensate for the work we have to do that weekend. Hopefully all the testing we've done will have paid off to where we have to fix nothing to very little - but we will still have to be onsite waiting for things to break until managers give the all clear. [...]
5750 68 39_Re: Y2K 31 Dec 1999 - Are you working ?14_James R. Brown25_brownjr@CI.RICHMOND.VA.US30_Thu, 2 Dec 1999 07:48:13 -0500304_iso-8859-1 I think this is a good idea also. It may be worthwhile to have a "volunteer" from each time zone to post to the list on an hourly basis any problems encountered or just to say "all's well".
I am willing to volunteer for Eastern time (U.S & Canada, GMT-5:00)
Just my opinion [...]
5819 52 39_Re: Y2K 31 Dec 1999 - Are you working ?32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Thu, 2 Dec 1999 14:58:50 +0200440_- It's a good idea. If all the way through from my PC to listserv works, i want to see the roll-over responses..
Good luck. -----Original Message----- From: Max 'Guderian' [mailto:mocion@LIBERO.IT] Sent: Wednesday, December 01, 1999 11:03 PM To: DB2-L@RYCI.COM Subject: Y2K 31 Dec 1999 - Are you working ?
Dear collegues
The last day of 1999 I'll be working to check our DB2 and all system & applications. [...]
5872 106 35_Re: DB2 Version 5 Stored Procedures9_SrinivasG17_SRINIVASG@INF.COM30_Thu, 2 Dec 1999 18:55:46 +0530589_iso-8859-1 Hi ,
Make sure the Stored Procedure Loadlibs are made available to the SP Startup JCL as part of Steplib as follows :
//DSNASPAS PROC RGN=0K,TME=NOLIMIT,DB2SSN=DSNA,NUMTCB=20 //IEFPROC EXEC PGM=DSNX9STP,REGION=&RGN,TIME=&TME, // PARM='&DB2SSN,&NUMTCB' //STEPLIB DD DISP=SHR,DSN=DSN510.RUNLIB.LOAD // DD DISP=SHR,DSN=CEE.SCEERUN // DD DISP=SHR,DSN=OPERN.STORPRO.LOADLIB // DD DISP=SHR,DSN=CEE.SCEELKED // DD DISP=SHR,DSN=DSN510.SDSNLOAD
Then link DSNALI with the Stored Procedure and DSNELI module with the calling program in the Linkedit Clist or JCL. [...]
5979 328 38_Re: FW: -905 - exceeds resource limit.14_Mark R. Walker26_mark.walker@CUNAMUTUAL.COM30_Thu, 2 Dec 1999 07:38:14 -0600431_us-ascii
I don't think stopping RLF after the query has started will do any good. It is my understanding that when the query begins executing, DB2 queries RLF to determine the appropriate limit. Any changes made after the query is running won't affect it.
Mark Walker
(Embedded image moved John Arbogast to file: 12/01/99 02:11 PM pic25474.pcx) [...]
6308 61 74_Re: How Can EXPLAIN(YES) be automated in a typical program migrationpath??9_Sally Mir16_smir@BCBS-GA.COM30_Thu, 2 Dec 1999 09:31:15 -0500348_us-ascii Since you have Platinum Plan Analyzer, why not take advantage of its functionality? It can be run in batch, and can produce any number of current and future explain reports. I believe it also has a way to store historical access paths and compare them, reporting on any changes.
Sally Mir DBA Blue Cross Blue Shield of Georgia [...]
6370 228 38_Re: FW: -905 - exceeds resource limit.13_John Arbogast16_jfarbo@YAHOO.COM30_Thu, 2 Dec 1999 06:50:15 -0800552_us-ascii I meant to stop it before starting the query. Sorry for the confusion.
--- "Mark R. Walker" wrote: > > > I don't think stopping RLF after the query has > started will do any good. It is > my understanding that when the query begins > executing, DB2 queries RLF to > determine the appropriate limit. Any changes made > after the query is running > won't affect it. > > Mark Walker > > > > > > (Embedded > image moved John Arbogast > to file: 12/01/99 02:11 PM > pic25474.pcx) > > > > [...]
6599 26 20_Redefine a partition11_Fred Grasso16_fgrasso@FBFS.COM30_Thu, 2 Dec 1999 09:10:32 -0600418_us-ascii We are in the process of redefining partitioned tablespaces for the first time on DB2 version 5. We are going to use the following steps to accomplish this task:
1) Unload the tablespaces using Reorg utility Unload Only 2) Drop the tablespace 3) Create tablespace with new partitions 4) Create table 5) Create indexes with new index values 6) Load tables using the Load utility with Format Unload [...]
6626 49 24_Re: Redefine a partition14_Wayne Driscoll19_WDriscoll@QUEST.COM30_Thu, 2 Dec 1999 07:38:24 -0800450_iso-8859-1 Before dropping the tablespace, make sure you get the definition of any views on the table, any RI that the table is involved with and all security on the table and views. In addition, you will need to find all plans and packages that will be invalidated by the drop so you can re-run binds of these plans and packages. Wayne Driscoll Software Developer Quest Software Inc. wdriscoll@quest.com NOTE: All opinions are strictly my own. [...]
6676 18 8_Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 10:44:36 -0500408_us-ascii Hello List,
Is there a "max_rows_per_page" option in DB2 like any other sane database? If yes, whatz should be the optimum value..
TIA, -- Nash
================================================ 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.
6695 80 12_ODBC Catalog9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM30_Thu, 2 Dec 1999 09:48:13 -0800565_us-ascii Hi,
We're using the DB2 ODBC Catalog Optimizer to create, and occasionally rebuild, optimized tables for ODBC applications to access DB2 OS/390 databases. The DB2OCAT utility ran fine from a DB2 Connect 5.2 fixpack 8 Windows NT workstations against DB2 OS/390 V5 PUT9906 instance. However, since we recently upgraded our client PC's to DB2 Connect 6.1 fixpack 1, the process abends in the update tables process without producing an error message. The process rolls back and the tables are empty. The last three entries from the ODBC trace are: [...]
6776 79 24_Re: Redefine a partition18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Thu, 2 Dec 1999 09:47:44 -0600595_iso-8859-1 Fred, One other point, and don't ask me why -- its just experience, DSNTIAUL seems to unload faster than REORG UNLOAD PAUSE. Some 3rd party UNLOAD software may be even faster.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message [...]
6856 25 37_Specific BMC and CA/Platinum products11_mark tucker21_tucker_mark@YAHOO.COM30_Thu, 2 Dec 1999 07:40:59 -0800460_us-ascii I am looking for some information on three specific CA/platinum products and whether BMC has something that matches the functionality.
The products are Detector, Subsystem analyzer, and Plan Analyzer. Do the BMC monitor products work similarly ?
__________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one place. Yahoo! Shopping: http://shopping.yahoo.com [...]
6882 43 12_Re: Max rows13_Martin Kenney25_martin.kenney@RAILINC.COM30_Thu, 2 Dec 1999 10:56:49 -0500305_us-ascii If you checked the SQL reference manual, page 235 you can use (now this is really convenient) the MAXROWS part of the create or alter tablespace command. As for the optimum value, I will use the ever popular answer of "it depends". I guess that DB2 is now a sane database in your opinion!!! [...]
6926 105 24_Re: Redefine a partition11_Fred Grasso16_fgrasso@FBFS.COM30_Thu, 2 Dec 1999 10:01:11 -0600549_us-ascii Rick,
I did try DSNTIAUL and it seemed to run slower.
"DAVIS, RICK (SWBT)" on 12/02/99 09:47:44 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Fred Grasso/FBFS)
Subject: Re: Redefine a partition
Fred, One other point, and don't ask me why -- its just experience, DSNTIAUL seems to unload faster than REORG UNLOAD PAUSE. Some 3rd party UNLOAD software may be even faster. [...]
7032 53 24_Re: Redefine a partition18_Erringer, Keith M.24_Keith.Erringer@ALCOA.COM30_Thu, 2 Dec 1999 10:51:23 -0500521_- Fred,
Check the Administration Guide for V5 page 4-189. It does not suggest your method. You may have to use SQL to unload your table before using the LOAD utility due to the fact that you are dropping the tablespace (OBID's may change when re-creating).
On another note you may want to create additional dummy partitions with negative key values for future use. These would come in handy if re-partitioning needs to be done again. The dummy partitions could be used without dropping the tablespace. [...]
7086 48 12_Re: Max rows12_craig patton21_prgpatton@HOTMAIL.COM28_Thu, 2 Dec 1999 08:21:06 PST542_- Nash, In version 5 there is a maxrows parameter when creating the base tablespace. There is no optimal value. As in all things in DB2 'it depends'. The max value is '255'. One general rule of thumb is to fit as many rows on a page as possible to reduce I/O. Unfortunately, contention can be increased with this philosophy. I personally view this parameter as a way of limiting the number of rows per page as DB2 (during load and reorg) will place as many rows per page as will fit (minus any freespace amounts) up to the MAXROWS value [...]
7135 142 76_Re: How Can EXPLAIN(YES) be automated in a typical program migrat ion path??0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Dec 1999 10:38:15 -0600551_us-ascii We are still in the process of implementing a similar process for production binds but we only use one plan table.
We have panels that generate compile and bind jcl so when doing a production bind some extra steps are added: - SQL delete from plan table by program name and remarks = "old" - SQL update plan table by program name, set remarks = "old" - bind, EXPLAIN(YES) - SQL update plan table by program name set remarks = "new" - REXX to parse thru new explain looking for areas of concern ie Table space scan --> Access type [...]
7278 21 25_JAVA Stored Procedure JAR14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 2 Dec 1999 12:00:51 -0800350_us-ascii I am currenlty setting up our DB2 EE NT V6.1 environment to run JAVA stored procedures and came across a JAVA JAR. I'm not sure what this is at this point, can anyone shed some light on this. TIA, Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner [...]
7300 49 12_Re: Max rows18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Thu, 2 Dec 1999 10:58:32 -0600278_iso-8859-1 Nash, Of course you can specify number of rows, in DB2 for OS/390 V5 and up, its MAXROWS. The value is based on some sane idea of concurrency needs or to just use the max for concurrency -- row level locking, in which case jam as many rows on a page as you can. [...]
7350 56 19_ftp and packed data9_Kenny Yip26_kydas@UCLINK4.BERKELEY.EDU30_Thu, 2 Dec 1999 09:02:37 -0800555_us-ascii I am running into some problems in using the IBM DB2 LOAD utility. I hope you can help me. . The data was unloaded from DB2/OS390 using the unload program DSNTIAUL. . The unloaded data was sent to the NT server using FTP. . On the NT server, DB2 UDB load utility was used to load the data into a table. So far, I can only load CHAR rows successfully. When I tried to load tables with DECIMAL or SMALLINT columns, I got messages like SQL3016N, SQL3114W, SQL3116W, SQL3118W, SQL3124w etc.. Either the process stopped or all rows got processed [...]
7407 75 12_Re: Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 12:02:33 -0500357_us-ascii Martin/Craig.. Where can I can find the MAXROWS parameter. I looked thru the SQL Reference manual of UDB v5.0(we are on AIX) and couldn't find it in the Create/Alter tablespace command.. Also the db and dbm configuration files show no such parameter...
Thanks! - Nash
craig patton on 12/02/99 10:21:06 AM [...]
7483 53 41_Load of Zero Rows - NPI Build Performance10_Kite Allan28_Allan.Kite@BARCLAYCARD.CO.UK30_Thu, 2 Dec 1999 17:06:33 -0000603_- Hi,
I was wondering if anyone out there has an explanation for why the build phase of a LOAD INTO.. REPLACE PART n can take a substantial amount of time despite zero rows being loaded?
This weekend as part of some database updates we had to drop/recreate a 64-partition tablespace (each part about 35 Cylinders and around 1.5million rows) with two non-unique NPIs. The original data was reloaded using IBM Load utilities run eight-wide (eight partitions per job) and as we should have realised the build times for the NPIs became quite shocking as more parts were loaded (we should [...]
7537 65 23_AW: ftp and packed data17_Schreiber, Ursula34_Ursula.Schreiber@DRESDNER-BANK.COM30_Thu, 2 Dec 1999 18:13:25 +0100417_iso-8859-1 DSNTIAUL doesn't convert packed (DECIMAL) and binary (INTEGER, SMALLINT) columns into character format.
During FTP processing all the unloaded data is treaded as character data and converted from EBCDIC to ASCII.
You must unload all the data in character format. We therefore create a view which selects every column in character format and use this view in DSNTIAUL to unload the data. [...]
7603 109 23_Re: ftp and packed data9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM30_Thu, 2 Dec 1999 11:17:36 -0800446_us-ascii Kenny,
The ftp options ascii/binary come into play. Ascii works when downloading character data from dsntiaul datasets to NT, but may have problems with binary data, integer, smallint. The binary option works for such data. I've had situations when it was easier to two files, character data with the ascii option, and integer with the binary option and put the files together for the load, or load one and import the other. [...]
7713 98 12_Re: Max rows14_Wayne Driscoll19_WDriscoll@QUEST.COM30_Thu, 2 Dec 1999 09:17:42 -0800414_iso-8859-1 Nash, The MAXROWS parm is only available on DB2 for OS/390, not on UDB for Windows, Unix etc. On UDB for Windows, page level locking is not available, only row, table and tablespace. Since limits on the number of rows per page is a concurrency feature, it really isn't needed for UDB. Wayne Driscoll Software Developer Quest Software Inc. wdriscoll@quest.com NOTE: All opinions are strictly my own [...]
7812 97 12_Re: Max rows12_craig patton21_prgpatton@HOTMAIL.COM28_Thu, 2 Dec 1999 09:25:48 PST647_- Sorry Nash, my reply was to DB2 for OS/390. I am not aware of the parameters for UDB on AIX. Craig Patton
>From: Nash Gupta >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Max rows >Date: Thu, 2 Dec 1999 12:02:33 -0500 > >Martin/Craig.. >Where can I can find the MAXROWS parameter. I looked thru the SQL Reference >manual of UDB v5.0(we are on AIX) and couldn't find it in the Create/Alter >tablespace command.. >Also the db and dbm configuration files show no such parameter... > >Thanks! >- Nash > >craig patton on 12/02/99 10:21:06 [...]
7910 80 27_Re: AW: ftp and packed data8_Helen Tu28_spghct@SOCRATES.BERKELEY.EDU30_Thu, 2 Dec 1999 09:28:59 -0800612_US-ASCII Ursula,
How do you select a SMALLINT or DECIMAL column in character format?
Thank you.
Helen Tu
On Thu, 2 Dec 1999, Schreiber, Ursula wrote:
> DSNTIAUL doesn't convert packed (DECIMAL) and binary (INTEGER, SMALLINT) > columns into character format. > > During FTP processing all the unloaded data is treaded as character data and > converted from EBCDIC to ASCII. > > You must unload all the data in character format. We therefore create a view > which selects every column in character format and use this view in DSNTIAUL > to unload the data. > > Best Regards [...]
7991 124 12_Re: Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 12:39:19 -0500364_us-ascii Howz this concurrency feature used to get around the MAXROWS parameter?? I really need this feature for one table where I could just assign one row per page... I know this can be done in Sybase..
- Nash
craig patton on 12/02/99 11:25:48 AM
Please respond to DB2 Data Base Discussion List [...]
8116 40 29_Re: JAVA Stored Procedure JAR13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM30_Thu, 2 Dec 1999 11:52:17 -0600476_iso-8859-1 Phil, JAR is a JAVA Archive File. It is a single file containing many classes. Instead of having 100's of classes occupying a file each, you can put them in a single archive file. JAVA will search through the file for what it needs to resolve references to classes.
glenn
-----Original Message----- From: Philip Gunning [mailto:pgunning@BOSCOVS.COM] Sent: Thursday, December 02, 1999 2:01 PM To: DB2-L@RYCI.COM Subject: JAVA Stored Procedure JAR [...]
8157 149 27_AW: AW: ftp and packed data17_Schreiber, Ursula34_Ursula.Schreiber@DRESDNER-BANK.COM30_Thu, 2 Dec 1999 19:02:24 +0100529_iso-8859-1 Suppose CDEC ist a DECIMAL Column, CINT is a INTEGER column and CSMINT is a SMALLINT column.
Then the following SELECT will return all character values:
SELECT CHAR(CDEC) , CHAR(DECIMAL(CINT)) , CHAR(DECIMAL(CSMINT)) ...
The CHAR and DECIMAL functions are described in the SQL Reference manual.
You will also get problems with data types DATE, TIME and TIMESTAMP because DSNTIAUL unloads columns of these types also in internal format. Use the CHAR function to convert into character. [...]
8307 176 12_Re: Max rows12_Myron Miller22_myronwmiller@YAHOO.COM30_Thu, 2 Dec 1999 10:34:19 -0800546_us-ascii If all locking is at the row level, why would you need to put one row per page? I don't understand why you feel the need for assigning one row per page on UDB. What problem are you attempting to solve via this mechanism?
--- Nash Gupta wrote: > Howz this concurrency feature used to get around the > MAXROWS parameter?? > I really need this feature for one table where I > could just assign one row > per page... > I know this can be done in Sybase.. > > - Nash > > craig patton [...]
8484 77 23_Re: ftp and packed data0_20_evans036@MC.DUKE.EDU30_Thu, 2 Dec 1999 13:44:51 -0500668_us-ascii kenny,
if you used 'char' mode to do the ftp, all non ebcdic fields would be trashed.
good luck,, steve
Kenny Yip on 12/02/99 12:02:37 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: ftp and packed data
I am running into some problems in using the IBM DB2 LOAD utility. I hope you can help me. . The data was unloaded from DB2/OS390 using the unload program DSNTIAUL. . The unloaded data was sent to the NT server using FTP. . On the NT server, DB2 UDB load utility was used to load [...]
8562 64 41_Re: Specific BMC and CA/Platinum products18_Martinson, Barbara25_Barbara_Martinson@BMC.COM30_Thu, 2 Dec 1999 12:46:21 -0600469_ISO-8859-1 Subsystem Analyzer - Analyzes DB2 object activity and resource usage BMC's ACTIVITY MONITOR is considered the most technically complete DB2 monitor on the market. In addition, the integration of OPERTUNE for DB2 and XBM with ACTIVITY MONITOR provide a robust suite of DB2 functionality.
Plan Analyzer - Analyzes DB2 plan and package use; reports on access path choices, SQL syntax, etc. BMC's PATROL SQL-Explorer provides a suitable replacement. [...]
8627 65 23_Re: ftp and packed data14_Patriquin, Tim21_Tim_Patriquin@BMC.COM30_Thu, 2 Dec 1999 12:58:52 -0600358_ISO-8859-1 Add the following statement before your get command: binary
This will cause all subsequent data to be transferred as binary, therefore any EBCDIC data will be trashed. You can reset to character mode by specifying ASCII instead of binary. (BTW, all FTP commands are case sensitive, so you must specify ebcdic and ascii as lower case). [...]
8693 210 12_Re: Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 13:58:59 -0500448_us-ascii Myron, Heres' what I am trying to do...I have these 70 tables which use a stored proc to grab a last number that was used as an id and add one t o it ..This becomes a new id for the tables...The reason for this was avoid locking (page lock) up of the table incase of an insert...I thought assigning 70 row to 70 different pages could resolve this problem...I am not sure if this is the right way...So far we hadn't had any problem... [...]
8904 61 23_DB2 version 5 CAF calls16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM30_Thu, 2 Dec 1999 14:01:49 -0500437_iso-8859-1 Hey folks, We are migrating from version 4 to version 5 and seem to be unable to get the Implicit CAF calls to work. Everything works just as in version 4: prepare program, precomp/comp/lked with DSNALI. Bind packages and plans, however, the CAF facility does not seem to work in version 5. We are unable to establish a connection to DB2. Any thoughts or places to look? Thanks, Mike Friedlander friedlander@firstinvestors.com
8966 231 12_Re: Max rows0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Dec 1999 13:34:12 -0600446_us-ascii We have a single table to do that. It currently has about 50 rows. Prior to OS390 DB2 V5 we forced 1 row per page by padding end of row with spaces to 4K (or at least 2K + 1 byte). At V5 we removed the padding and went to Row level locking. Since you apparently have Row level locking in UDB you should have no problem. The key on our table is a Relative Row number 1 thru 50. We just add the next row number when we add a new key. [...]
9198 62 29_Re: JAVA Stored Procedure JAR14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 2 Dec 1999 14:40:08 -0800455_us-ascii Thanks Glenn. I discoverd it in th Application Development Guide, page 563 after I sent out the request. Thanks again. Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner
-----Original Message----- From: Mackey, Glenn [SMTP:GMackey@GUIDEMAIL.COM] Sent: Thursday, December 02, 1999 9:52 AM To: DB2-L@RYCI.COM Subject: Re: JAVA Stored Procedure JAR [...]
9261 261 12_Re: Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 14:44:58 -0500346_us-ascii Rohn, how was the row level locking achieved in that case...I need to know the process for doing that... Is there any good reference for it... I think we have a very similar situation here.. Thanks! - Nash
Rohn.Solecki@MTS.MB.CA on 12/02/99 01:34:12 PM
Please respond to DB2 Data Base Discussion List [...]
9523 19 32_DB2 UDB V6.1 Certification Guide14_Philip Gunning20_pgunning@BOSCOVS.COM30_Thu, 2 Dec 1999 14:55:54 -0800497_us-ascii FYI. The guide is out an available thru amazon.com. It should also be available from IBM and other sources. Phil
Philip K. Gunning DB2 DBA IBM Certified Solutions Expert -- DB2 UDB IBM Cetfified Solutions Expert -- CICS TS Assoc List Owner
================================================ 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.
9543 130 23_Re: ftp and packed data14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Thu, 2 Dec 1999 14:58:41 -0500407_iso-8859-1 If you have DB2 Connect setup you can connect to OS390 database and use EXPORT in IXF format to unload OS/390 DB2 data on your NT and then load DB2 on NT using LOAD. DB2 Connect will take care of the conversion.
If you do not have DB2 Connect you can use DIGITS function in your DSNTIAUL SQL to convert numeric data and unload into an external format and then FTP using ASCII option. [...]
9674 144 45_Re: DB2 UDB 6.1 for Windows NT Authentication15_Mohammed Nayeem21_db2udbxpert@YAHOO.COM30_Thu, 2 Dec 1999 11:51:43 -0800599_us-ascii Hi Folks
Users with NT Administrator authority will inherit SYSADM Authority in DB2.
Thanks
Nayeem
--- Daniel Adam wrote: > Philip, > > There is no NT server id, I use only domain account. > Still, I don't see why should Control Center behave > different from db2cmd. > > Thanks > Daniel > > > On Wed, 1 Dec 1999 08:57:09 -0800, Philip Gunning > > wrote: > > >Daniel, Your userid and password are different for > your lan logon versus > >your NT server logon it appears, at least from my > experience. The > [...]
9819 290 12_Re: Max rows0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Dec 1999 14:10:10 -0600555_us-ascii In DB2 V5 OS390 it is specified as a parameter on the TS create, ie CREATE TABLESPACE .... LOCKSIZE ROW ... ;
From reading in my "Sam's Teach Yourself UDB" it seems that row level locking is default in UDB. It says "DB2 locks a single row as it's accessed, meaning that only the rows being UPDATEd, INSERTed, DELETEd or read (unless the isolation level is is cursor stability or uncommitted read) are locked" and the "Performance Configuration Smartguide, Isolation Tab" allows you to specify number of locked rows and lock duration. [...]
10110 18 37_DB2/SQL Programming Manuals and Books17_Martinez, Shelley22_SNMartinez@STATE.NM.US30_Thu, 2 Dec 1999 13:04:28 -0700309_- Our MIS shop is looking for good DB2/SQL programming manuals and books. Can anyone make recommendations of books or manuals that they thought were really helpful? There are a slew of titles available on Amazon but who knows if any of those books are any good. Please send any personal recommendations. [...]
10129 315 12_Re: Max rows10_Nash Gupta19_nashgupt@US.IBM.COM30_Thu, 2 Dec 1999 15:18:03 -0500405_us-ascii Rohn, is this applicable to only OS/390 ?? I am using UDB v.2 on AIX...
Rohn.Solecki@MTS.MB.CA on 12/02/99 02:10:10 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: Max rows
In DB2 V5 OS390 it is specified as a parameter on the TS create, ie CREATE TABLESPACE .... LOCKSIZE ROW ... ; [...]
10445 71 41_Re: DB2/SQL Programming Manuals and Books0_15_sokeefe@VCU.EDU30_Thu, 2 Dec 1999 15:19:29 -0500511_us-ascii Here's a short list: 1) DB2 Answers! Certified Tech Support, Richard Yevich, Osborne 2) Joe Celko's SQL For Smarties, Advanced SQL Programming, Morgan Kaufmann 3) DB2/UDB V5 SQL Cookbook, Graeme Birchall (On the WEB, PDF, FREE!)
bookpool.com is cheaper across the board than amazon.com.
Good luck,
Sean
Sean O'Keefe Virginia Commonwealth University Administrative Systems/Applications Technical Services Operating Systems Analyst (804) 828-8415 sokeefe@vcu.edu [...]
10517 31 63_R:Re: Y2K 31 Dec 1999 - Are you working ? (It was only an idea)14_Max 'Guderian'16_mocion@LIBERO.IT30_Thu, 2 Dec 1999 21:10:03 +0100366_us-ascii Yes, of course, the existence of this list depends on many factors, as all IBM/BMC/Playboy Alert
sites in all the world........:-))) but if Y2k bug will destroy the world I would prefer to learn this news
from this list ....
And the prize for New Year at work is ....my job (plus a little bonus $$) so they said.....:-(((( [...]
10549 115 75_Re: How Can EXPLAIN(YES) be automated in a typical program migration path??13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM30_Thu, 2 Dec 1999 14:28:56 -0600605_us-ascii I've done a similar thing, except that my plan history table keeps the last 3 days that a given plan was bound. We keep the current plan plus the two previous histories. A COBOL program is used to maintenance this table.
Helen
Marcus Davage wrote:
> Hi Christine > > I've implemented a similar procedure to yours in several places (where tools > may or may not have been available). When a program gets migrated from > development to test, it's bound EXPLAIN(YES), with a step immediately before > it which does: > DELETE FROM PLAN_HISTORY WHERE PROGRAM='program' > AND [...]
10665 39 46_Re: COBOL - DB2 access from Open Edition (USS)12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 2 Dec 1999 22:31:50 +0200148_x-user-defined Hi, I do it with PL/1 (with CAF). Works fine. Moreover - it is a URL for the WEB so can be called directly, no need for ODBC.
10705 90 27_Re: AW: ftp and packed data12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Thu, 2 Dec 1999 22:45:11 +020089_x-user-defined Hi, You do it by "select DIGITS(smallint/decimal number) from ...)
10796 21 41_Re: Specific BMC and CA/Platinum products10_Feeny, Jim23_Jim_Feeny@COMPUWARE.COM30_Thu, 2 Dec 1999 15:36:36 -0500604_iso-8859-1 Another view .... Compuware offers a solution that encompasses two of the mentioned needs, Detector and Plan Analyzer, in a single tool, File-AID for DB2. Compuware also offers Strobe as a replacement for Subsystem Analyzer.
For further details, please contact your local Compuware office.
Jim Feeny Product Manager Compuware Corporation
================================================ 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.
10818 326 12_Re: Max rows0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Dec 1999 14:51:18 -0600434_us-ascii As I said, it appears the UDB on AIX handles things differently than OS390. One of the AIX guru's will have to confirm
Nash Gupta on 99/12/02 02:18:03 PM
Rohn, is this applicable to only OS/390 ?? I am using UDB v.2 on AIX...
Rohn.Solecki@MTS.MB.CA on 12/02/99 02:10:10 PM
Please respond to DB2 Data Base Discussion List [...]
11145 26 27_Order of primary key fields15_Backes, Michael26_BackeM@MAIL.OA.STATE.MO.US30_Thu, 2 Dec 1999 14:58:06 -0600270_iso-8859-1 this may be a pretty lame question but does the order of the columns in a primary key make a difference in the access path. ie. primary key on a table is a,b,c with a unique index on in.
does it make a difference if the tables are in b,c,a order? [...]
11172 27 31_OS390 Stored Proc -444 SQL Code10_Park, Stan17_SPark@STATE.NM.US30_Thu, 2 Dec 1999 14:49:17 -0700497_iso-8859-1 Hi DB2-L,
On OS390 V2.5 DB2 V5 DB2-established SPAS am getting -444 SQLCODE and IEW4008I FETCH FAILED FOR MODULE SP1BMS FROM DDNAME STEPLIB BECAUSE OF AN ERROR IN CONVERTING A TTR.
Have already determined that the cause was an increase in the number of extents in the SPAS Runlib DSN.
Will (re)allocate the Runlib DSN for one Large Primary Extent - but wanted to ask if there is a way to Purge and Start ONLY the SPAS without Cycling the entire DB2 subsystem? [...]
11200 22 27_Re: DB2 version 5 CAF calls12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 2 Dec 1999 15:45:00 -0500591_- Have you tried to include the DSNTRACE DD name in you process? This will show what it is trying to do.
>>> DB2-L@RYCI.COM@inter2 12/02/99 12:57PM >>> Hey folks, We are migrating from version 4 to version 5 and seem to be unable to get the Implicit CAF calls to work. Everything works just as in version 4: prepare program, precomp/comp/lked with DSNALI. Bind packages and plans, however, the CAF facility does not seem to work in version 5. We are unable to establish a connection to DB2. Any thoughts or places to look? Thanks, Mike Friedlander friedlander@firstinvestors.com [...]
11223 132 28_Balt./Wash. DB2 Users' Group0_19_valeriet@US.IBM.COM30_Thu, 2 Dec 1999 16:45:10 -0500697_us-ascii Baltimore/Washington DB2 Users' Group
Meeting Date: December 8, 1999
Location: Sheraton Columbia Inn 10207 Wincopin Circle Columbia, MD (410) 730-3900
Meeting Schedule:
8:30 - 9:00 Registration
9:00 - 10:15 DB2 UDB for UNIX/Intel V6.1 Technical Overview David Seibert, Compuware Corporation
DB2 UDB for UNIX, Windows, and OS/2 V6.1 is an evolution of the DB2 product line. IBM continues to enhance DB2 to position it as the premier database for all distributed platforms--which includes Java support for e-business applications. This presentation provides an introduction to the new features found in this release of DB2 UDB for UNIX/Intel. [...]
11356 94 27_Re: DB2 version 5 CAF calls0_19_Tim.Lowe@STPAUL.COM30_Thu, 2 Dec 1999 15:50:08 -0600442_us-ascii Mike, What error message are you getting? Did use the compile parm NODYNAM? Is the SDSNEXIT library concatenated before your SDSNLOAD library in your steplib? Does your SDSNEXIT library contain a DSNHDECP module that points to the DB2 subsystem that you are trying to connect to?
Thanks, Tim
Mike Friedlander on 12/02/99 01:01:49 PM [...]
11451 111 41_Re: DB2/SQL Programming Manuals and Books0_19_Tim.Lowe@STPAUL.COM30_Thu, 2 Dec 1999 15:53:29 -0600763_us-ascii I would highly recommend Gabrielle Wiorkowski's book "DB2 for OS/390 Development for Performance".
sokeefe@VCU.EDU on 12/02/99 02:19:29 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Tim Lowe/sfm/spc)
Subject: Re: DB2/SQL Programming Manuals and Books
Here's a short list: 1) DB2 Answers! Certified Tech Support, Richard Yevich, Osborne 2) Joe Celko's SQL For Smarties, Advanced SQL Programming, Morgan Kaufmann 3) DB2/UDB V5 SQL Cookbook, Graeme Birchall (On the WEB, PDF, FREE!) [...]
11563 36 27_Re: DB2 version 5 CAF calls20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Thu, 2 Dec 1999 16:54:22 -0500624_- You have mention the correct subsystem name while assembling DSNHDECP. CAF implicit connection picks up SSID from here. If you are running data-sharing then you must make sure that your job runs in correct LPAR.
These are the most common errors.
HTH Pillay
> -----Original Message----- > From: Mike Friedlander [SMTP:friedlander@FIRSTINVESTORS.COM] > Sent: Thursday, December 02, 1999 2:02 PM > To: DB2-L@RYCI.COM > Subject: DB2 version 5 CAF calls > > Hey folks, > We are migrating from version 4 to version 5 and seem to be unable to get > the Implicit CAF calls to work. Everything works just [...]
11600 59 32_DB2 UDB V5.2 AIX SMS tablespaces20_BREIDENSTINE JOHN L.21_jlb@LEGIS.STATE.PA.US30_Thu, 2 Dec 1999 16:58:56 -0500395_us-ascii Hello everyone,
We have a question regarding the utililization of space within AIX for SMS tablespace.
Lets say we have an AIX 8meg file system with a mount point of /udb/tablespaces. And we create a tablespace called TESTSPACE1 with /udb/tablespaces as its container.
1 year from now the tables that use TESTSPACE1 fill up the entire 8meg of the file system. [...]
11660 78 17_TSOLIB and ALTLIB22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM30_Thu, 2 Dec 1999 17:09:16 -0500626_iso-8859-1 Currently whenever we have two subsystems on the same lpar that are at different releases, service levels, etc., we create a separate logon proc for access to each subsytem. Each logon proc has the STEPLIB statement pointing to the load library required for that subsystem. In addition, each logon proc has the SYSPROC statement pointing to the required clist library needed for that subsystem. Has anyone had any success using the TSOLIB command instead of the STEPLIB DD statement? How about the ALTLIB command instead of SYSPROC DD statements? Both of these commands can be executed prior to starting ISPF. [...]
11739 24 41_Re: DB2/SQL Programming Manuals and Books12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Thu, 2 Dec 1999 16:12:00 -0500427_- DB2 Developer's Guide by Mullins (3rd Edition) is good as well.
>>> DB2-L@RYCI.COM@inter2 12/02/99 02:04PM >>> Our MIS shop is looking for good DB2/SQL programming manuals and books. Can anyone make recommendations of books or manuals that they thought were really helpful? There are a slew of titles available on Amazon but who knows if any of those books are any good. Please send any personal recommendations. [...]
11764 39 35_Re: OS390 Stored Proc -444 SQL Code13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Thu, 2 Dec 1999 16:18:59 -0600428_US-ASCII Just issue the stop proc(*) command. Kurt
>>> "Park, Stan" 12/02/99 03:49PM >>> Hi DB2-L,
On OS390 V2.5 DB2 V5 DB2-established SPAS am getting -444 SQLCODE and IEW4008I FETCH FAILED FOR MODULE SP1BMS FROM DDNAME STEPLIB BECAUSE OF AN ERROR IN CONVERTING A TTR.
Have already determined that the cause was an increase in the number of extents in the SPAS Runlib DSN. [...]
11804 57 11_CAF failure16_Mike Friedlander30_friedlander@FIRSTINVESTORS.COM30_Thu, 2 Dec 1999 17:21:39 -0500391_iso-8859-1 Thanks to all, Problem with the CAF calls not working was due to the wrong linklist order of both SDSNEXIT and SDSNLOAD. I needed EXIT, kept getting LOAD (wrong DSNHDECP module). For those of you that were following my stored procedure problem that too went away with this "fix". Once again, my thanks to all for the assist. Thanks, Mike Friedlander friedlander@firstinvestors.com
11862 83 34_DSN1COPY and Segmented Tablespaces16_Brian F. Patella25_patellab@WORLDNET.ATT.NET30_Thu, 2 Dec 1999 17:33:41 -0500632_iso-8859-1 Hi!
I am working with PeopleSoft, which delivers several thousand of tables with hundreds of these tables in multiple segmented tablespaces. The delema I have is that if there is a table mod performed in the tablespace, the tablespace is no longer recoverable with the previous Image Copy. I was planning to use DSN1COPY for the recovery on those tablespaces until I read the following in section 4.6.6 Recovery of Dropped Objects in the DB2 V5 Administration Guide. Subtopic Limitations of the Procedures reads as follows: "These procedures do not reclaim a dropped table in a segmented table space. Because [...]
11946 40 31_Re: Order of primary key fields0_22_Rohn.Solecki@MTS.MB.CA30_Thu, 2 Dec 1999 16:56:51 -0600460_us-ascii You are correct, having index columns in a different sequence than the table will not impact performance. Many shops will tend to put unique index key columns in correct sequence at start of table just as a convience (probably left over from older DBMS requirements).
You were probably thinking about different access path due to different sequence of columns in an index, ie index a,b,c will have a different access path than index c,b,a [...]
11987 130 38_Re: DSN1COPY and Segmented Tablespaces16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM30_Thu, 2 Dec 1999 18:19:54 -0500336_- I, too, work with PeopleSoft. We developed scripts that use DSNTIAUL to unload all tables that have data in the tablespace, then do the mod. This provides two things. The ability to recover the data as it was since it is in true flat record format and I have load control statements that I can use if I have to un-mod the table. [...]
12118 36 14_RE : Sort Pool0_16_acaldwe2@CSC.COM30_Fri, 3 Dec 1999 09:51:45 +1000411_us-ascii The other respondents are correct in that you are trying to achieve a sort ONLY in memory without any paging to datasets. This problem involves a different tuning approach to your other buffer pools.
Richard Yevich in his book DB2 Answers gives some first cut threshhold guidelines, as does Chuch Hoover in his book Tuning DB2 for OS390. Yevich suggests DWQT = 90%, VDWQT = 90%, VPSEQT 95% [...]
12155 156 36_Re: DB2 UDB V5.2 AIX SMS tablespaces11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU30_Fri, 3 Dec 1999 11:21:34 +1100436_- Hi John, Yes. We more usually hit this situation in test environments.
My understanding is any disk in the same AIX logical volume group can be used for expanding the file system.
We use the tablespace name as the low level directory name to keep track, since UDB allows only one tablespace per directory (or SMS container). eg. CREATE TABLESPACE testspace1 MANAGED BY SYSTEM USING ('/udb/tablespaces/testspace1'); [...]
12312 259 15_Re: ODBC(?) SQL11_ALLEN,Bruce37_bruce.allen@EMPLOYMENTNATIONAL.COM.AU30_Fri, 3 Dec 1999 11:32:13 +1100615_- Hi Greg, From what I have seen is the SQL from the drivers is usually static. Your SQL sample looks typical of a gui application which gives the user a selection list of the tables (very user friendly...).
HTH, Bruce > -----Original Message----- > From: Greg.Palgrave@BANKWEST.COM.AU [SMTP:Greg.Palgrave@BANKWEST.COM.AU] > Sent: Thursday, 2 December 1999 18:21 > To: DB2-L@RYCI.COM > Subject: ODBC(?) SQL > > Just looking for some enlightenment from any ODBC gurus out there. > > We have an application connecting to UDB V5.2 on NT using dynamic SQL, and > we are seeing a lot of this particular SQL, [...]
12572 77 14_RE : Sort Pool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Thu, 2 Dec 1999 21:12:08 -0500468_ISO-8859-1 Message text written by DB2 Data Base Discussion List >The other respondents are correct in that you are trying to achieve a sort ONLY in memory without any paging to datasets. This problem involves a different tuning approach to your other buffer pools.
Richard Yevich in his book DB2 Answers gives some first cut threshhold guidelines, as does Chuch Hoover in his book Tuning DB2 for OS390. Yevich suggests DWQT = 90%, VDWQT = 90%, VPSEQT 95% [...]
12650 57 35_Re: OS390 Stored Proc -444 SQL Code14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU30_Fri, 3 Dec 1999 14:51:46 +1100414_- Stan,
Another option we use is to compress the dataset with the use of IEBCOPY. There is not need to stop/start anything. eg.
//COPY01 EXEC PGM=IEBCOPY //SYSPRINT DD SYSOUT=* //IN DD DSN=JPPTSDB.PRODN.SPRCLOAD,DISP=SHR //SYSIN DD * COPY INDD=IN,OUTDD=IN
Regards Terry Purcell DBA & Environments Manager Product DBoR - Telstra Phone: +613 98657164 Fax: +613 98045368 Mobile: 0416 221582 [...]
12708 48 21_Re: change ISO to JIS14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Fri, 3 Dec 1999 15:05:03 +1000323_us-ascii Robert,
I AM GUESSING HERE.
You should be able to stop/change/start db2. Probably no effect. The only problem I can see is if application programs are looking for a decimal-point in time fields. Data in the data base is stored in a fixed format that is not dependant on the default time format. [...]
12757 81 18_Re: RE : Sort Pool16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Thu, 2 Dec 1999 23:46:01 -0500334_iso-8859-1 The important aspect to understand here for sorting is that if pages are unnecessarily written out to the work tablespace and the pages in the pool are used for something else before being referenced, then when they are needed for intermediate or final sort merges, I/Os would have to be issued to bring them back in. [...]
12839 25 34_DB2 Utilities waiting for services22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM28_Thu, 2 Dec 1999 21:40:45 PST360_- I have not been able to identify a db2 utility cause for this wait state. There is very little happening between the create thread and the registry of information which would show on a DIS UTIL command. So, we need to gether information and take console dumps of both the utility job address space and the DBM1 address space. Two PMRs are open on this. [...]
12865 156 45_Re: DB2 UDB 6.1 for Windows NT Authentication11_Daniel Adam15_dadam@GRATEX.SK30_Fri, 3 Dec 1999 01:55:46 -0800589_- Mohammed, sorry, but even that is not true for my domain account. My domain account is in local administrators group of the computer. D.
On Thu, 2 Dec 1999 11:51:43 -0800, Mohammed Nayeem wrote:
>Hi Folks > >Users with NT Administrator authority will inherit >SYSADM Authority in DB2. > >Thanks > >Nayeem > > >--- Daniel Adam wrote: >> Philip, >> >> There is no NT server id, I use only domain account. >> Still, I don't see why should Control Center behave >> different from db2cmd. >> >> Thanks >> Daniel >> >> >> On Wed, 1 [...]
13022 34 21_Re: TSOLIB and ALTLIB14_Tom Decabooter27_Tom.Decabooter@HONDA-EU.COM30_Fri, 3 Dec 1999 09:35:04 +0100518_us-ascii We do not use the TSOLIB command, because you can only use it before starting ISPF. Once ISPF is started, you cannot switch to another DB2-subsystem without restarting ISPF.
We use another 'dynamic steplib' program called TLIB. It was published in the september 1996 issue of MVS UPDATE (Xephon). The coding (assembler source) can be downloaded from http://www.xephon.com. We are currently running OS/390 2.6 with DB2 5.1 and the TLIB program is still working (original version, no modification). [...]
13057 14 49_Y2K on DB2 390 V2.2 or prior??? Ignore otherwise.22_Dan Courter (543-3870)27_daniel_courter@VNET.IBM.COM28_Thu, 2 Dec 1999 22:09:14 PST434_- If any of you are running DB2 390 V2.2 or earlier (yes, there are a handful out there) send me a private email and I'll outline the MODIFY utility issues and work-arounds for you.
Dan
================================================ 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.
13072 74 23_AW: ftp and packed data17_Schreiber, Ursula34_Ursula.Schreiber@DRESDNER-BANK.COM30_Fri, 3 Dec 1999 11:10:06 +0100610_iso-8859-1 Be careful with DIGITS, because you loose the sign and the decimal point. Best Regards / Mit freundlichen Gruessen
Ursula Schreiber
Dresdner Bank AG KS Organisation und Informatik IT Research und Standards Consulting und Architektur Datenmanagement D-60301 Frankfurt
* email : ursula.schreiber@dresdner-bank.com * voice : +49 (0)69/263-6966 * fax : +49 (0)69/263-13704
-----Ursprüngliche Nachricht----- Von: Manas Dasgupta [mailto:manas.dasgupta@PFSFHQ.COM] Gesendet am: Donnerstag, 2. Dezember 1999 20:59 An: DB2-L@RYCI.COM Betreff: Re: ftp and packed data [...]
13147 116 14_RE : Sort Pool13_Adrian Savory24_adrian.savory@ZURICH.COM30_Fri, 3 Dec 1999 10:13:40 +0000557_us-ascii The last site I worked at had problems with their sorting. We had sorts of various sizes going on all the time, there was already a large dedicated VP assigned to DSNDB07, and we were suffering from bad performance due to the amount of I/O activity. We tried raising the write thresholds to reduce the amount of I/O, and whilst this worked OK most of the time, there were occasions when we hitting DMTH. We couldn't anticipate when this was going to happen, and we couldn't increase the size of the VP due to storage constraints, so we had to [...]
13264 144 12_Re: Max rows20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM30_Fri, 3 Dec 1999 11:49:35 -0000548_iso-8859-1 Nash,
You could use PCTFREE to force one row per page.
That's assuming your version of DB2 ("DB2 Lite"?) has such a parameter!
Bear with a sore head.
-----Original Message----- From: Nash Gupta [mailto:nashgupt@US.IBM.COM] Sent: 02 December 1999 17:39 To: DB2-L@RYCI.COM Subject: Re: Max rows
Howz this concurrency feature used to get around the MAXROWS parameter?? I really need this feature for one table where I could just assign one row per page... I know this can be done in Sybase.. [...]
13409 25 15_DSMAX Questions14_Paul A Walters23_Paul.A.Walters@SLMA.COM30_Fri, 3 Dec 1999 07:32:55 -0500304_us-ascii We are a DB2 V5 datasharing site with two subsystems. Over the Thanksgiving weekend we expanded the number of partitions for some of our DB2 tablespaces to the max of 254. This change took us to about 11,000 datasets for the PLEX.
Our current DSMAX is set a 4000 on both subsystems. [...]
13435 30 21_Re: change ISO to JIS11_Steck, Dave16_Steckd@ABCBS.COM30_Fri, 3 Dec 1999 07:03:11 -0600342_iso-8859-1 When we went from USA to ISO as our default date format we identified any programs that were sensitive to date format and re-compiled them. When we did that, we used the pre-compiler option to set the date format for that program to remain USA.
We didn't have a single problem with the change once we actually made it. [...]
13466 168 19_Re: DSMAX Questions22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 3 Dec 1999 12:24:00 +0000329_ISO-8859-1 Paul interesting question.
We are going DS in January ... wehave our set to 6000 .. but we are a SAP site (lots of Index datasets and only a few partitioned pagesets).
I have just looked up DSMAX and there is a 1.5K overhead for each single unit of DSMAX. So in our case .. 9000K or just under 9Mb. [...]
13635 68 37_Re: Another Data Compression question0_15_lchau@ITI.QC.CA30_Fri, 3 Dec 1999 08:29:37 -0500688_us-ascii LISTCAT information is updated when the dataset closes. I would think the same for a linear dataset used for DB2 VSAM clusters, but not able to verify due to the use of CLOSE YES for the tablespace specification.
Loc Chau
At 12:36 11/29/1999 -0500, you wrote: >Is LO-RBA and HI-RBA current or is it based on the last file close? > >Sibimon Philip >972-702-2515 - Office >972-417-3597 - Residence >E-mail - Sibimon_philip@sealand.com > > > >-----Original Message----- >From: Daniel Boulanger [mailto:dboulang@CA.IBM.COM] >Sent: Monday, November 29, 1999 11:22 AM >To: DB2-L@RYCI.COM >Subject: Re: Another Data Compression question > > >One easy [...]
13704 76 15_DSMAX Questions14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 3 Dec 1999 08:36:23 -0500303_ISO-8859-1 Message text written by DB2 Data Base Discussion List > We are a DB2 V5 datasharing site with two subsystems. Over the Thanksgiving weekend we expanded the number of partitions for some of our DB2 tablespaces to the max of 254. This change took us to about 11,000 datasets for the PLEX. [...]
13781 35 35_Re: OS390 Stored Proc -444 SQL Code13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Fri, 3 Dec 1999 08:41:20 -0500586_iso-8859-1 Terry's right of course that you can compress the library as shown.
But you want to be careful when compressing a library with DISP=SHR. Under normal circumstances, you should always have exclusive control(DISP=OLD) when compressing a library. There is the danger of some other job writing to the library and corrupting the directory while you are compressing. When I have had to resort to DISP=SHR to compress a library, I always back it up first in case I need to recover. And then I use a monitor to watch the jobs and tasks using the library to try to insure [...]
13817 56 19_RE. DSMAX Questions13_Adrian Savory24_adrian.savory@ZURICH.COM30_Fri, 3 Dec 1999 13:33:23 +0000408_us-ascii Paul,
Use your DB2 monitor to confirm this - all (good) monitors would report on #time DSMAX limited reached, #dataset open/close requests, etc.
One other possibility may be related to your coupling facility. A large number of additional partitions would place a bigger strain on the lock structure - is it possible you are getting locking problems, maybe false contention, etc.? [...]
13874 163 19_Re: DSMAX Questions12_Chao Terry F23_Terry.F.Chao@M1.IRS.GOV30_Fri, 3 Dec 1999 09:07:18 -0500486_iso-8859-1 Paul,
How have you been ?
If I remember correctly, your B&B DB2 monitor history data captured should remain viewable online for at least 10 days, and all the necessary DB2 traces to support your analysis were always turned on. Subsystem open/close activities were part of the captured history data that you should have handy. I believe you guys have a standard of defining tablespaces and indexes using CLOSE NO and it does come into play in the equation. [...]
14038 18 14_RE : Sort Pool0_31_truman.g.brown@BELLATLANTIC.COM30_Fri, 3 Dec 1999 09:10:05 -0500536_us-ascii We have a couple of large, active databases that have large dedicated BPs for 4K work datasets, and each of them has thirteen (13) 4K work datasets on dedicated volumes. One database has the "sort" BP backed with a hiperpool; both use VPSEQT 98, VPPSEQT 50 we get some paralellism), DWQT 65, VDWQT 35. Occasionally one of the DBs will have some heavy hits on DMTH but there's not much we can about that except try to 1) get certain batch jobs rescheduled and 2) ask the application developers to rework some of their SQL. [...]
14057 87 38_Re: DSN1COPY and Segmented Tablespaces9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM30_Fri, 3 Dec 1999 08:23:35 -0800339_us-ascii We use DSNTIAUL to unload PeopleSoft as well. However, I have used DSN1COPY to restore a segmented tablespace with multiple tables (yes, a PeopleSoft TS before I started building unload scripts). As long as you have the old object id's to do the translation it should work.
Good Luck,
"Milligan, Andrea" wrote: [...]
14145 13 19_Re: DSMAX Questions0_22_Bob_Yoder@ILLINOVA.COM30_Fri, 3 Dec 1999 08:24:10 -0600385_us-ascii You may want to look a PCLOSEN and PCLOSET also, if these numbers are too small, ie: the default will cause performance problems also.
================================================ 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.
14159 37 19_Re: DSMAX Questions22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 3 Dec 1999 13:47:52 +0000465_ISO-8859-1 Bob
I am sure Horacio Terrizano gave a presentation on this at IDUG in Nice .. let me see ... yes he did .. Session C5 ... DB2 Datasharing Application Tuning .. do you want the details from the presentation?
Leslie Pendlebury-Bowe DB2 SAP OS390
______________________________ Reply Separator _________________________________ Subject: Re: DSMAX Questions Author: Bob_Yoder@ILLINOVA.COM at Internet Date: 12/3/99 8:24 AM [...]
14197 29 19_On-Line Reorg tools18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM30_Fri, 3 Dec 1999 08:33:10 -0500403_iso-8859-1 We are currently at DB2 V 5 OS/390 and probably going to V6 sometime early in 2000. I'd like to start looking at some 'online reorg' tools and was wondering if anyone has any good feedback on any that they are currently using? Also if you know of any web pages that I could look at that might give me some further information about this subject I would appreciate it. Thanks in advance. [...]
14227 64 14_RE : Sort Pool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 3 Dec 1999 09:52:00 -0500574_ISO-8859-1 Message text written by DB2 Data Base Discussion List >We have a couple of large, active databases that have large dedicated BPs for 4K work datasets, and each of them has thirteen (13) 4K work datasets on dedicated volumes. One database has the "sort" BP backed with a hiperpool; both use VPSEQT 98, VPPSEQT 50 we get some paralellism), DWQT 65, VDWQT 35. Occasionally one of the DBs will have some heavy hits on DMTH but there's not much we can about that except try to 1) get certain batch jobs rescheduled and 2) ask the application developers to rework [...]
14292 54 19_Re: DSMAX Questions14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Fri, 3 Dec 1999 10:00:07 -0500568_ISO-8859-1 Message text written by DB2 Data Base Discussion List > I have just looked up DSMAX and there is a 1.5K overhead for each single unit of DSMAX. So in our case .. 9000K or just under 9Mb.<
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Just to be sure we all have the right perspective here... The 1.5K is the memory requirement for an opened dataset. Only .3K of this is 'below the line (16M)' usage, assuming the SWA has been moved above the line by the MVS sysprogs. So all you are really concerned about is the 1.8M of memory. [...]
14347 47 23_Re: On-Line Reorg tools13_Thomas, Janis20_JANIS.THOMAS@CAI.COM30_Fri, 3 Dec 1999 10:06:15 -0500727_iso-8859-1 More information on OnlineReorg from Computer Associates (a former Platinum product) can be found here:
http://www.cai.com/products/db2/onlinereorg/overview.htm
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Friday, December 03, 1999 7:33 AM To: DB2-L@RYCI.COM Subject: On-Line Reorg tools
We are currently at DB2 V 5 OS/390 and probably going to V6 sometime early in 2000. I'd like to start looking at some 'online reorg' tools and was wondering if anyone has any good feedback on any that they are currently using? Also if you know of any web pages that I could look at that might give me some further information about this [...]
14395 95 19_Re: DSMAX Questions22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 3 Dec 1999 14:18:48 +0000479_ISO-8859-1 Indeed if we do assume above line and below then yes this is true.
Joel I thought you had discussed PCLOSET and PCLOSEN in one of your presentations at IDUG .. but the only thing I can find is by Horacio .. ???
Leslie Pendlebury-Bowe
______________________________ Reply Separator _________________________________ Subject: Re: DSMAX Questions Author: Joel Goldstein at Internet Date: 12/3/99 10:00 AM [...]
14491 64 23_Re: On-Line Reorg tools22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 3 Dec 1999 14:26:42 +0000534_ISO-8859-1 Steve
my suggestion would be to wait until you get V6 .. "apparently" the V6 IBM on-line reorg code is "supposed" to perform a lot quicker than the V5 on-line Reorg code and in addition at the switch phase there is meant to be some "new" method of switching the dataset names in the DB2 catalog such that the switch will only take a matter of micro seconds .. I think that the internal DB2 code will "hold up" all claimers on the Catalog so that they do not time out .. and then it will change the dataset name [...]
14556 17 14_RE : Sort Pool0_31_truman.g.brown@BELLATLANTIC.COM30_Fri, 3 Dec 1999 10:33:36 -0500416_us-ascii Joel,
I know the problem is I/O subsystem, but I can't get a whole lot of assistance from our SMS people at placing the logical volumes.
Thanks, 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.
14574 60 39_Re: Y2K 31 Dec 1999 - Are you working ?7_Gustavo26_lozano@BANDEIRANTES.COM.BR30_Fri, 3 Dec 1999 13:38:33 -0300639_iso-8859-1 Hi folks... I'll be working at midnight. I'm in Sao Paulo - Brazil (GMT -4). Gustavo Lozano (lozano@bandeirantes.com.br)
-----Mensagem original----- De: Max 'Guderian' Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Data: Quarta-feira, 1 de Dezembro de 1999 19:26 Assunto: Y2K 31 Dec 1999 - Are you working ?
>Dear collegues > >The last day of 1999 I'll be working to check our DB2 and all system & >applications. > >I don't know if any of you will be working at midnight, but I would like to >suggest to use this DB2- > >list as a check or, better, as [...]
14635 26 60_DB2 UDB 6.1 NT Server 4.0 SP 5 Java Stored Procedure Problem14_Philip Gunning20_pgunning@BOSCOVS.COM30_Fri, 3 Dec 1999 10:43:47 -0800539_us-ascii I am getting an SQL 4301N "Java interpreter startup or communication failed, reason code "2" SQLSTATE 58004." when trying to run the DB2SpCli sample client application. Anyone else have this problem? I'm using JDK 1.1. I'm working with support but no luck as of yet. Has anyone else run this on a server where the stored procedure and client app are on the same machine? I'm thinking that might be the problem or DB2 is not finding the right driver or I need to specify it on the procedure definition. TIA for any help. Phil [...]
14662 97 23_Re: On-Line Reorg tools13_Adrian Savory24_adrian.savory@ZURICH.COM30_Fri, 3 Dec 1999 15:45:55 +0000493_us-ascii Les,
My understanding is that the new functionality allows the online reorg to proceed without having to drain read claims at the end of the log apply phase. The readers will continue to use the 'old' copy of the data until they commit or complete. Both the old and the new datasets will be registered in the catalog, presumably the old copy will be removed some time after the last read claim has gone. There are also enhancements to make the switch phase a lot quicker. [...]
14760 18 19_NPI on Load by Part12_Bill Bennett19_bbenn1@JCPENNEY.COM30_Fri, 3 Dec 1999 09:36:08 -0800371_- We have several DB2 V5 large partitioned tablespaces that have about 100 million rows in each table. The tables have 32 parts and 2 or 3 NPI's on each table. We need to load each of the tables as quickly as possible for a system conversion. We run several loads at the same time. Unfortuantly it appears that as the NPI's become populated the slower they perform. [...]
14779 22 42_Segmented TS uses freespace out of cluster12_Bill Bennett19_bbenn1@JCPENNEY.COM30_Fri, 3 Dec 1999 09:46:31 -0800331_- We have a DB2 V5 segmented tablespaces with one tables that has several million rows in it. We have a lot of insert activity to the table. Freespace is set at 20.
I thought the inserts would insert into the "proper" clustered part of the table if their was room. If their was no room then it would extend at the end. [...]
14802 34 18_Re: RE : Sort Pool13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK30_Fri, 3 Dec 1999 15:47:00 -0000369_- Tell me about it !!!!!!!
Ian McDonald DB2 DBA Abbey National ---------- From: truman.g.brown@BELLATLANTIC.COM To: DB2-L@RYCI.COM Subject: RE : Sort Pool Date: 03 December 1999 15:33
Joel,
I know the problem is I/O subsystem, but I can't get a whole lot of assistance from our SMS people at placing the logical volumes.
Thanks, George [...]
14837 19 20_NPI on Reorg by Part12_Bill Bennett19_bbenn1@JCPENNEY.COM30_Fri, 3 Dec 1999 09:38:41 -0800342_- We have several DB2 V5 large partitioned tablespaces that have about 80 million rows in each table. The tables have 32 parts and 2 or 3 NPI's on each table.
We need to reorg each of the tables as quickly as possible. We have run several reorg parts at the same time. Unfortuantly it appears that the NPI's slow the reorgs down. [...]
14857 119 23_Re: On-Line Reorg tools22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Fri, 3 Dec 1999 15:00:41 +0000267_ISO-8859-1 As far as I know .. they come in with Version 6 .. but I thihk it may be an APAR .. well it was mentioned at IDUG in Nice .. but like all things V7 functionality is now being pushed .. so maybe it will be in the base release of v7 .. I will ask John. [...]
14977 20 29_OS390 Table Browse/Edit Tools13_Greg Myers-GB15_myers.gb@PG.COM30_Fri, 3 Dec 1999 11:10:46 -0500582_us-ascii Does anyone have any thoughts around the various browse/edit tools that are available? The three I'm aware of are File-Aid for DB2 by CompuWare, Access for DB2 by Princeton Softech, and RC/Edit from CA/Platinum.
What are your experiences and likes/dislikes? Are there other good products out there?
Thanks, Greg Myers
================================================ 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.
14998 105 23_Re: On-Line Reorg tools13_John Arbogast16_jfarbo@YAHOO.COM30_Fri, 3 Dec 1999 08:10:48 -0800584_us-ascii Does IBM still require a seperate translation table for each tablespace reorged?? Why can't the reorg utility be smart enough to create these tables on the fly?
--- Leslie Pendlebury-Bowe wrote: > Steve > > my suggestion would be to wait until you get V6 > .. "apparently" the V6 > IBM on-line reorg code is "supposed" to perform > a lot quicker than the > V5 on-line Reorg code and in addition at the > switch phase there is > meant to be some "new" method of switching the > dataset names in the > DB2 catalog such [...]
15104 36 33_Re: OS390 Table Browse/Edit Tools14_O'Conner, John26_john.oconner@COURTS.WA.GOV30_Fri, 3 Dec 1999 08:24:24 -0800464_iso-8859-1 We use ProEdit from CA. It works ok for us.
-----Original Message----- From: Greg Myers-GB [mailto:myers.gb@PG.COM] Sent: Friday, December 03, 1999 8:11 AM To: DB2-L@RYCI.COM Subject: OS390 Table Browse/Edit Tools
Does anyone have any thoughts around the various browse/edit tools that are available? The three I'm aware of are File-Aid for DB2 by CompuWare, Access for DB2 by Princeton Softech, and RC/Edit from CA/Platinum. [...]
15141 34 33_Re: OS390 Table Browse/Edit Tools17_Lobenstein, Jerry30_Jerry_Lobenstein@COMPUWARE.COM30_Fri, 3 Dec 1999 11:16:10 -0500414_iso-8859-1 -----Original Message----- From: Greg Myers-GB [mailto:myers.gb@PG.COM] Sent: Friday, December 03, 1999 11:11 AM To: DB2-L@RYCI.COM Subject: OS390 Table Browse/Edit Tools
Does anyone have any thoughts around the various browse/edit tools that are available? The three I'm aware of are File-Aid for DB2 by CompuWare, Access for DB2 by Princeton Softech, and RC/Edit from CA/Platinum. [...]
15176 37 24_Re: NPI on Reorg by Part12_Lisle, Kathy19_KLLISLE@INTEGON.COM30_Fri, 3 Dec 1999 11:29:23 -0500521_ISO-8859-1 In my experience (which was with SHRLEVEL NONE), the biggest gain is made by adding PIECESIZE to the NPIs. The SORTKEYS option on the reorg helped, too.
-----Original Message----- From: Bill Bennett [mailto:bbenn1@JCPENNEY.COM] Sent: Friday, December 03, 1999 12:39 PM To: DB2-L@RYCI.COM Subject: NPI on Reorg by Part
We have several DB2 V5 large partitioned tablespaces that have about 80 million rows in each table. The tables have 32 parts and 2 or 3 NPI's on each table. [...]
15214 58 33_Re: OS390 Table Browse/Edit Tools9_Jim Jones33_jim.jones@INGRAMENTERTAINMENT.COM30_Fri, 3 Dec 1999 10:33:44 -0800512_us-ascii Greg,
I've used File-Aid/DB2 and RC/Edit. Both are good tools, but I prefer FA/DB2. If your shop has other File-Aid products the DB2 component may be a good fit. The ISPF like functions to edit, browse and copy data are easy to use. Also, FA/DB2 has a SQL Analysis component to work with explains, so you get the equivalent of RC/Edit and Plan Analyzer. The DBA staff installs and maintains DBMS and related software, as well as build and manage databases, so we like having fewer products. [...]
15273 59 8_00E3008318_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Fri, 3 Dec 1999 10:34:51 -0600311_iso-8859-1 Hi all, your assistance please. Receiving the following every attempt to BIND REPLACE an existing PLAN. I've checked to make sure the PLAN was not executing during the BIND attempt. I did -DIS THREAD(*) during the attempt and only a single DSNBIND thread is active. In other words, I'm stumped. [...]
15333 51 33_Re: OS390 Table Browse/Edit Tools16_Robin Willoughby27_robin_willoughby@UK.IBM.COM30_Fri, 3 Dec 1999 16:33:27 +0000406_us-ascii I'm rather fond of FILE-AID for DB2 - it does a lot more than just browsing tables - create/alter objects, analyse access paths (translates explain output into english), handy for GRANTS, loading and unloading tables - the one word of warning I would give is get the standard defaults right, especially for edit mode - you may mistype and want not want to commit the change you just made.... [...]
15385 57 33_Re: OS390 Table Browse/Edit Tools17_Lobenstein, Jerry30_Jerry_Lobenstein@COMPUWARE.COM30_Fri, 3 Dec 1999 11:49:23 -0500412_iso-8859-1 Greg,
If your looking beyond just Edit and Browse functions. File-Aid DB2 supports various other programmer activities. Such as Explain, Column Impact Reporting for program dependency, ability to extract and load data between test and production. All catalog information can information can be display quickly and easily. File-Aid for DB2 also supports RI and AR editing for related data. [...]
15443 74 39_Re: Y2K 31 Dec 1999 - Are you working ?15_Benedito Galvao24_bgalvao@BBVBRASIL.COM.BR30_Fri, 3 Dec 1999 14:46:40 -0200653_iso-8859-1 Camarada Gustavo,
Se Vc fosse o único, seria o ideal. Aqui, virada de noite, trabalhar em feriados, domingos etc é default...
Um abraço,
B.: Galvão BBV Brasil (Bahia)
Gustavo wrote:
> Hi folks... > I'll be working at midnight. I'm in Sao Paulo - Brazil (GMT -4). > Gustavo Lozano (lozano@bandeirantes.com.br) > > -----Mensagem original----- > De: Max 'Guderian' > Grupos de notícias: bit.listserv.db2-l > Para: DB2-L@RYCI.COM > Data: Quarta-feira, 1 de Dezembro de 1999 19:26 > Assunto: Y2K 31 Dec 1999 - Are you working ? > > >Dear collegues > > > >The last day of [...]
15518 26 23_Re: On-Line Reorg tools12_Roger Miller19_millerrl@US.IBM.COM30_Fri, 3 Dec 1999 09:03:24 -0800333_us-ascii Do you remember which session talked about this? It sounds as though there was a communication glitch. Sorry.
There is a good summary of the Version 6 online reorg improvements in the Version 6 Performance Topics red book, SG24-5351. My suggestion is to go out to the red books web site, search and download it. [...]
15545 99 39_Re: Y2K 31 Dec 1999 - Are you working ?7_Gustavo26_lozano@BANDEIRANTES.COM.BR30_Fri, 3 Dec 1999 15:12:54 -0300661_iso-8859-1 Great, Galvao! I'll be here. If you need anything, just "call" me. Best regards. Gustavo.
-----Mensagem original----- De: Benedito Galvao Grupos de notícias: bit.listserv.db2-l Para: DB2-L@RYCI.COM Data: Sexta-feira, 3 de Dezembro de 1999 14:49 Assunto: Re: Y2K 31 Dec 1999 - Are you working ?
>Camarada Gustavo, > >Se Vc fosse o único, seria o ideal. Aqui, virada de noite, trabalhar >em feriados, domingos etc é default... > >Um abraço, > >B.: Galvão >BBV Brasil (Bahia) > >Gustavo wrote: > >> Hi folks... >> I'll be working at midnight. I'm in Sao Paulo - Brazil (GMT -4). >> [...]
15645 39 46_Re: Segmented TS uses freespace out of cluster20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Fri, 3 Dec 1999 13:03:38 -0500588_- This happens when the candidate page is locked. DB2 inserts somewhere else. Otherwise the entry goes to page based on clustering
> -----Original Message----- > From: Bill Bennett [SMTP:bbenn1@JCPENNEY.COM] > Sent: Friday, December 03, 1999 12:47 PM > To: DB2-L@RYCI.COM > Subject: Segmented TS uses freespace out of cluster > > We have a DB2 V5 segmented tablespaces with one tables that has several > million rows in it. We have a lot of insert activity to the table. > Freespace is set at 20. > > I thought the inserts would insert into the "proper" clustered part of the [...]
15685 24 29_Reporting tool for DB2 on AIX10_Nash Gupta19_nashgupt@US.IBM.COM30_Fri, 3 Dec 1999 13:21:14 -0500418_us-ascii Hello List!
I am in the process of evaluating reporting tool for DB2 UDB (we are on v5.2 on AIX)... Can somebody pls give recommendation on the basis of their experience with the tool.. Pls include any necessary pros and con of the tool...This tool will be installed on few Win 98/NT machines and end users should be able to work without having any problem related to connection or what so ever.. [...]
15710 60 46_Re: Segmented TS uses freespace out of cluster18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Fri, 3 Dec 1999 12:25:18 -0600544_iso-8859-1 Bill, A brief, 30,000 ft. explanation. DB2 never has guaranteed clustering during INSERT. For a segmented TS, it will try to put the record in either the correct page if there's room and the page isn't locked, or a page close to the right page within the segment where it should go that isn't locked and has space, or a page in the next segment where there's room and not locked. The only time a table can be expected to be in perfect clustering order is immediately after a reorg, or you reLOAD a table with an input file that [...]
15771 72 31_Re: Order of primary key fields0_20_evans036@MC.DUKE.EDU30_Fri, 3 Dec 1999 13:34:24 -0500711_us-ascii i would generally put the most selective column first so that you optimize retrieval in the event that you need to select data via a partial key.
good luck,
steve
Rohn.Solecki@MTS.MB.CA on 12/02/99 05:56:51 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: Subject: Re: Order of primary key fields
You are correct, having index columns in a different sequence than the table will not impact performance. Many shops will tend to put unique index key columns in correct sequence at start of table just as a convience (probably left over from older DBMS requirements). [...]
15844 35 23_Re: On-Line Reorg tools12_Greg Popwell27_greg.popwell@MOTION-IND.COM30_Fri, 3 Dec 1999 13:21:30 -0600587_iso-8859-1 Speaking of IBM's Online Reorg, can anyone offer any guidelines or experiences on how to set up such parms as MAXRO, LONGLOG, and DELAY, not to mention the Mapping tables? I know that with CA's product, you don't have to worry about these things. Unfortunately, my limited testing with the CA product has shown it to have some problems. One of CA's limitations is that you can only reorg individual tablespace partitions if you don't have any NPI's on it. All of our big partitioned tablespaces have at least one NPI. Does IBM have this limitation? I haven't come across [...]
15880 66 12_Re: 00E3008312_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Fri, 3 Dec 1999 13:51:00 -0500453_- Have you tried looking at SYSLOG or JES output from DB@@MSTR to see who you are contending with?
>>> DB2-L@RYCI.COM@inter2 12/03/99 10:35AM >>> Hi all, your assistance please. Receiving the following every attempt to BIND REPLACE an existing PLAN. I've checked to make sure the PLAN was not executing during the BIND attempt. I did -DIS THREAD(*) during the attempt and only a single DSNBIND thread is active. In other words, I'm stumped. [...]
15947 108 12_Re: 00E300830_25_joseph.burns@HIGHMARK.COM30_Fri, 3 Dec 1999 15:02:21 -0500535_us-ascii Rick,
We had a slightly different problem with packages, that may or may not be related.
Binding online CICS packages would timeout becuase packages were supposedly in use. However, our performance monitor did not show that the package was executing. We found out that the packages were bound with RELEASE(DEALLOCATE), and the the CICS threads using the packages were set up for thread reuse. So it seems that even though the monitor could not see the package executing, the package was technically in use. [...]
16056 103 12_Re: 00E3008318_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Fri, 3 Dec 1999 14:28:10 -0600622_iso-8859-1 Bob, thank you very much for the info and that's the aggravating thing about this problem. ****MSTR SYSLOG doesn't identify the source of the deadlock. All you get is: DSNT500I DBA3 DSNTBCM1 RESOURCE UNAVAILABLE REASON 00E30083 TYPE 00000800 NAME DTN1011A Which to me indicates its deadlocking on itself.
Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that [...]
16160 139 12_Re: 00E3008318_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Fri, 3 Dec 1999 14:31:06 -0600629_iso-8859-1 Joe, thank you very much for the info. However, we're not CICS, we're IMS and have checked for similar things.
Regards, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, [...]
16300 170 12_Re: 00E3008311_rick creech18_ykcirc@HOTMAIL.COM28_Fri, 3 Dec 1999 18:03:29 PST586_- I had this same problem a couple of months ago, and I contacted IBM DB2 support about it. Once I convinced IBM support that this was really happening,(initially they assumed I was not giving them all of the information because they expected more info to be output with the 00E30083). When they became interested in pursuing it further I could no longer re-create. Fortunately it was only happening with a couple of packages. (I got around it by changing the collection name). If you can re-create this consistently, contact IBM support - this appears to be an IBM software bug.) [...]
16471 168 45_Re: DB2 UDB 6.1 for Windows NT Authentication17_Jeff B Schumacher29_jeffschumacher@SPRINTMAIL.COM30_Fri, 3 Dec 1999 23:35:46 -0800602_- Daniel Adam
Starting with v6.1 the NT DB2 Control Center is running under the account associated with the NT Service called something like "JAVA Applet Control Center Service". The NT DB2 Command Line Processor is not. When I did an upgrade install the NT service was installed to run under the NT SYSTEM account. The SYSTEM account does not have SYSADM authority. Try changing the "JAVA Applet Control Center Service" (on the client) to run under the db2admin account of the server. Changing to this account should fix the problem of implicit Attach for that server. The Client Login ID [...]
16640 49 33_Re: OS390 Table Browse/Edit Tools12_craig patton21_prgpatton@HOTMAIL.COM28_Sat, 4 Dec 1999 06:26:33 PST360_- Greg, I have been using RC/EDIT for over 11 years and have never had any problems. The combination of RC/COPY and RC/EDIT competes with every other product on the market that I am aware of. My ONLY concern is that RC/EDIT is now a CA tool and we still cannot be sure that CA will maintain the development quality that Platinum had prior to the sellout. [...]
16690 53 46_Re: Segmented TS uses freespace out of cluster16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Sat, 4 Dec 1999 14:23:49 -0500386_iso-8859-1 That is the way it works. There are a lot of fine points in the way the inserts are applied if there is no room in the correct segment. But essentially, it is governed by the space map pages and eventually will start at the beginning of the segmented table space, using available space as it works towards the end. No need to extend and create new segment until needed. [...]
16744 51 33_Re: OS390 Table Browse/Edit Tools14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Mon, 6 Dec 1999 13:40:26 +1000356_us-ascii I've got to put in a good word for Access from Princeton.
I think that, in the end, it will be a case of which tool set you already have (Princeton is aligned to the BMC camp) and what you personally like. I think (without experience of File-Aid or RC/Edit) that the market place is so competitive that they will all do what you want. [...]
16796 25 17_Cluster missing..10_ajay kumar19_db2v5r1@HOTMAIL.COM28_Mon, 6 Dec 1999 15:16:33 IST296_- hi all,
We have a DB2 tablespace with missing cluster. We have got only the data component. We are on DB2V5.1(SMS managed). We dont have the latest backups to restore the cluster. Is there any way by which we can create a new cluster which can point to the existing data component. [...]
16822 44 21_Re: Cluster missing..0_23_Mike_Levine@TEKHELP.NET30_Mon, 6 Dec 1999 08:10:58 -0500728_us-ascii Hi,
I believe you can do a IDCAMS DEFINE RECATALOG. Check the syntax in the IDCAMS manual.
Regards,
Michael Levine Premier Data Services, Inc.
>hi all, > >We have a DB2 tablespace with missing cluster. >We have got only the data component. >We are on DB2V5.1(SMS managed). We dont have the latest backups to restore >the cluster. >Is there any way by which we can create a new cluster which can point to the >existing data component. > >TIA. >Ajay. > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > >================================================ >To change your subscription options or to cancel your [...]
16867 201 12_Re: 00E3008318_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Mon, 6 Dec 1999 07:10:43 -0600314_iso-8859-1 Rick, very interesting. We simply changed the PLAN name to get around the problem. I think I can recreate the problem at will. So, I'll contact IBM support and let them have a look at it. I'll let DB2-L know of any fixes/issues/work-arounds. Was an APAR opened I could refer to, or problem number? [...]
17069 55 21_Re: Cluster missing..18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Mon, 6 Dec 1999 07:19:39 -0600604_iso-8859-1 Ajay, seems to me you could simply IDCAMS DEFINE the CLUSTER (hilvl.DSNDBC.dbname.tsname.I0001.A00n) and relate the data component to it. Be sure you put the CLUSTER on the same VOLSER as the data component. The job will need permissions to update the VVDS on that VOLSER.
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received [...]
17125 19 18_DB2 Reporting Tool10_Nash Gupta19_nashgupt@US.IBM.COM30_Mon, 6 Dec 1999 09:12:19 -0500418_us-ascii Hello List!
Can somebody pls recommend a reporting tool for DB2?? Also pls include the necessary pros/cons for it...
Help is appreciated...
- Nash
================================================ 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.
17145 229 12_Re: 00E3008311_rick creech18_ykcirc@HOTMAIL.COM28_Mon, 6 Dec 1999 06:25:41 PST625_- Yes, the problem number I opened with them was: 42523,005; but no fix because I eventually got to the point where I was not able to re-create.
>From: "DAVIS, RICK (SWBT)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: 00E30083 >Date: Mon, 6 Dec 1999 07:10:43 -0600 > >Rick, very interesting. We simply changed the PLAN name to get around the >problem. I think I can recreate the problem at will. So, I'll contact IBM >support and let them have a look at it. I'll let DB2-L know of any >fixes/issues/work-arounds. Was an APAR opened I [...]
17375 25 22_Re: DB2 REPORTING TOOL18_Ray.Turpen@WOODMEN19_rturpen@WOODMEN.COM28_Mon, 6 Dec 1999 09:34:32 EST386_US-ASCII In-Reply-To: The letter of Monday, 6 December 1999 8:13am CT
We evaluated COGNOS Impromtptu, Business Objects, and BRIO. COGNOS won out by a mile for the following reasons: 1 - Easy to use. 2 - Uses DB2 Connect which we already had in place. 3 - Easy to administer. We installed 115 clients and have had no problems for 10 months. 4 - Oustanding technical support. [...]
17401 38 35_Another curious Rexx Compiler error13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Mon, 6 Dec 1999 13:24:48 -0000383_iso-8859-1 Hello again!
I run a Rexx from my SYSPROC. It calls a function "A" which calls ISPF and DB2's DSNTEP2 via "DSN S("ssid)". It works fine. If I run it compiled from an ISPLLIB, I get a RC(-196) from DSN and the function abends S0C4.
I have a similar function, "B" which calls DB2's DSNTIAUL in a similar way which works fine both compiled and uncompiled. [...]
17440 24 19_Re: DSMAX Questions12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 6 Dec 1999 07:45:44 -0800315_us-ascii Having DSMAX much smaller than you need can cause problems. There is not much penalty for having 10,000, as long as you have SWA above the line. Your performance monitor should be able to format the statistics records, which tell you how many opens are being performed and how often DSMAX is reached. [...]
17465 42 32_Version 5 Upgrade Rebind Problem13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Mon, 6 Dec 1999 10:48:09 -0500431_us-ascii We just upgraded to version 5 over the weekend. Whenever we upgrade we have made a habit of rebinding all plans and packages. I have one plan that is receiving a -101, which says: -101 THE STATEMENT IS TOO LONG OR TOO COMPLEX
Explanation: The statement cannot be executed because it exceeds the system limits for either length or complexity. Enabling parallelism will increase the complexity of the statement. [...]
17508 28 43_Recall: Another curious Rexx Compiler error13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Mon, 6 Dec 1999 14:21:40 -0000421_- Marcus Davage would like to recall the message, "Another curious Rexx Compiler error".
--------------------------------------------------------------------------- This Email is intended for the exclusive use of the addressee only. If you are not the intended recipient, you should not use the contents nor disclose them to any other person and you should immediately notify the sender and delete the Email. [...]
17537 30 39_Re: Another curious Rexx Compiler error13_Marcus Davage29_Marcus.Davage@LLOYDSTSB.CO.UK30_Mon, 6 Dec 1999 14:22:55 -0000488_iso-8859-1 Sorry - please ignore my last message! My fault! You'd be daft to call a compiled Rexx the same name as the DB2 program, DSNTEP2!!
Marcus
--------------------------------------------------------------------------- This Email is intended for the exclusive use of the addressee only. If you are not the intended recipient, you should not use the contents nor disclose them to any other person and you should immediately notify the sender and delete the Email. [...]
17568 56 23_Re: On-Line Reorg tools11_Kwan, James18_James_Kwan@BMC.COM30_Mon, 6 Dec 1999 10:03:43 -0600551_ISO-8859-1 Steve,
If you are looking for an alternative to IBM's online reorg, then you might want to check out the following BMC web site. http://www.bmc.com/products/proddocview.html?id=2186&l=en&r=Americas&c=
Please feel free to send me a message if you have any question.
Regards,
James Kwan
BMC Software Consultant
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@CPLC.COM] Sent: Friday, December 03, 1999 7:33 AM To: DB2-L@RYCI.COM Subject: On-Line Reorg tools [...]
17625 122 23_Re: On-Line Reorg tools11_Kwan, James18_James_Kwan@BMC.COM30_Mon, 6 Dec 1999 10:06:45 -0600514_ISO-8859-1 As far as I know, each online reorg still requires a separate RIDMAP table. May be in version X, they will automate the process :)
James Kwan
-----Original Message----- From: John Arbogast [mailto:jfarbo@YAHOO.COM] Sent: Friday, December 03, 1999 10:11 AM To: DB2-L@RYCI.COM Subject: Re: On-Line Reorg tools
Does IBM still require a seperate translation table for each tablespace reorged?? Why can't the reorg utility be smart enough to create these tables on the fly? [...]
17748 22 13_COBOL DSNTEP211_Tim Blewitt22_timblewitt@HOTMAIL.COM28_Mon, 6 Dec 1999 16:23:55 GMT532_- Fellow DB2ers,
I am sure that I have seen a COBOL version of the PL1 utility DSNTEP2. Can anybody please advise me where to find it?
Much obliged.
Tim
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
17771 40 17_Re: COBOL DSNTEP211_rick creech18_ykcirc@HOTMAIL.COM28_Mon, 6 Dec 1999 08:42:41 PST726_- Starting with db2 udb v6.1 dsntep2 is delivered in object form so that everyone can use it whether they have pl1 or not.
>From: Tim Blewitt >Reply-To: tim.blewitt@bigfoot.com >To: DB2-L@RYCI.COM >Subject: COBOL DSNTEP2 >Date: Mon, 6 Dec 1999 16:23:55 GMT > >Fellow DB2ers, > > I am sure that I have seen a COBOL version of the PL1 utility >DSNTEP2. Can anybody please advise me where to find it? > >Much obliged. > >Tim > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > >================================================ >To change your subscription options or to cancel your subscription visit >the DB2-L webpage [...]
17812 61 17_Re: COBOL DSNTEP217_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM30_Mon, 6 Dec 1999 11:54:22 -0500441_iso-8859-1 And for the rest of us not at V6 yet, http://www.gseukdb2.org.uk/ has a nice program called Darwin in the shareware section that does everything that dsntep2 does and more.
Craig Snoeyenbos Starwood Hotels all usual and most unusual disclaimers apply
-----Original Message----- From: rick creech [mailto:ykcirc@HOTMAIL.COM] Sent: Monday, December 06, 1999 11:43 AM To: DB2-L@RYCI.COM Subject: Re: COBOL DSNTEP2 [...]
17874 68 36_Re: Version 5 Upgrade Rebind Problem12_Kirk Hampton16_khampto1@TXU.COM30_Mon, 6 Dec 1999 11:14:41 -0600354_us-ascii Hi Scott, there is a fairly recent fix (PQ21786/UQ34979) that sounds like your problem. It is in PUT 9909, do you know what maintenance level your V5 is ? We had a similar situation after we applied some V5 maintenance early this year, and had to back off one PTF that was causing it. Sorry, I can't find the number for that one right now. [...]
17943 108 39_Re: Y2K 31 Dec 1999 - Are you working ?13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM30_Mon, 6 Dec 1999 09:56:30 -0700383_iso-8859-1 I thought this was an english speaking listserv?
From: bgalvao%BBVBRASIL.COM.BR@Internet on 12/03/99 10:07 AM To: DB2-L%RYCI.COM@Internet cc: (bcc: Dan S Brogdon) Subject: Re: Y2K 31 Dec 1999 - Are you working ?
Camarada Gustavo,
Se Vc fosse o único, seria o ideal. Aqui, virada de noite, trabalhar em feriados, domingos etc é default... [...]
18052 141 39_Re: Y2K 31 Dec 1999 - Are you working ?22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM30_Mon, 6 Dec 1999 13:11:22 -0500654_iso-8859-1 Where is it stated that this is an English language listserv?
Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com
> ---------- > From: Dan S Brogdon[SMTP:Dan.S.Brogdon@AEXP.COM] > Sent: Monday, December 06, 1999 11:56 AM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Y2K 31 Dec 1999 - Are you working ? > > I thought this was an english speaking listserv? > > > From: bgalvao%BBVBRASIL.COM.BR@Internet on 12/03/99 10:07 AM > To: DB2-L%RYCI.COM@Internet > cc: (bcc: Dan S Brogdon) > Subject: Re: Y2K 31 Dec 1999 - Are you working ? > > Camarada Gustavo, > > Se Vc fosse o único, seria o [...]
18194 44 19_Re: DSMAX Questions12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 6 Dec 1999 20:11:10 +0200103_x-user-defined Hi, If my memory serves me right there is an apar to get more then 10000 datasets in mvs
18239 43 22_Re: DB2 REPORTING TOOL12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Mon, 6 Dec 1999 20:14:57 +0200101_x-user-defined Hi,
Impromptu (COGNOS) has been chosen lately at two sites that I know.
18283 56 39_Re: Y2K 31 Dec 1999 - Are you working ?14_Masone, Franco24_F.Masone@CEDACRIOVEST.IT30_Mon, 6 Dec 1999 19:20:40 +0100508_- English : I will be at work as you. Italian : Io saro' al lavoro come te
> -----Messaggio originale----- > Da: Max 'Guderian' [SMTP:mocion@LIBERO.IT] > Inviato: Wednesday, December 01, 1999 10:03 PM > A: DB2-L@RYCI.COM > Oggetto: Y2K 31 Dec 1999 - Are you working ? > > Dear collegues > > The last day of 1999 I'll be working to check our DB2 and all system & > applications. > > I don't know if any of you will be working at midnight, but I would like > to > suggest to use this DB2- > > list [...]
18340 73 25_SQL Equivalent statements15_Luis J. Redondo23_ljredond@SOUTHERNCO.COM30_Mon, 6 Dec 1999 12:50:46 -0800451_- I have two SQL statements and I wanted to make sure that both of them were equivalent:
Original SQL:
SELECT A.KY_BA , A.DT_BILL , A.CD_RDG_SRCE_ELE , A.AT_TOT_NET , A.QY_DA_USE , A.CD_BILL_TYPE , A.QY_BILL_SEQ_NO , A.QY_RUN_SEQ_NO , A.DT_EXTN_TO , A.DT_DUE FROM BILL_INFO_HDR A WHERE ( A.KY_BA = :WV-LO-KY-BA ) AND NOT ( ( ( A.DT_BILL > :WV-LO-DT-BILL ) ) OR ( ( A.DT_BILL < :WV-HI-DT-BILL ) ) ) ORDER BY A.KY_BA , A.DT_BILL DESC [...]
18414 75 25_SQL Equivalent statements16_Redondo, Luis J.23_LJRedond@SOUTHERNCO.COM30_Mon, 6 Dec 1999 12:58:01 -0600480_- > I have two SQL statements and I wanted to make sure that both of them were > equivalent: > > Original SQL: > > SELECT A.KY_BA , A.DT_BILL , A.CD_RDG_SRCE_ELE , A.AT_TOT_NET , > A.QY_DA_USE , > A.CD_BILL_TYPE , A.QY_BILL_SEQ_NO , A.QY_RUN_SEQ_NO , A.DT_EXTN_TO , > A.DT_DUE > FROM BILL_INFO_HDR A > WHERE > ( > A.KY_BA = :WV-LO-KY-BA > ) > AND NOT > ( > ( > ( > A.DT_BILL > :WV-LO-DT-BILL > ) > ) > OR > ( > ( > A.DT_BILL < :WV-HI-DT-BILL > ) > ) > ) > ORDER BY A.KY_BA , [...]
18490 33 21_Re: change ISO to JIS16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM30_Mon, 6 Dec 1999 14:42:09 -0500594_us-ascii The Time Format is stored in the DBRM at precompile time, so even if you change the ZPARM, the format will remain ISO until you precompile the program and do a bind.
> -----Original Message----- > From: Robert Niemiec [SMTP:rniemiec@KRAKOW.TPSA.PL] > Sent: Thursday, December 02, 1999 3:42 AM > To: DB2-L@RYCI.COM > Subject: change ISO to JIS > > Our installation has TIME FORMAT = ISO in the installtion parameters. > We would like to change it to JIS (10:00:00) format. > Can I simply stop DB2 change this parameter and start DB2 again? > What about consequences of this [...]
18524 39 35_Y2K 31 Dec 1999 - Are you working ?14_Max 'Guderian'16_mocion@LIBERO.IT30_Fri, 3 Jan 1997 08:33:04 +0100387_us-ascii I see that there aren't so many senior systems administrators in DB2.....:-))). Works slave !!
OK next year we'll be all drunk in Time Square, if we'll conserve our job...
Now serious arguments: I offer myself to post any troubles in my time zone.
I'm in Italy (-1 GMT) so if my system will not crash, if my ISP will survive, if Listserv will work and [...]
18564 54 21_Re: change ISO to JIS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 6 Dec 1999 15:41:38 -0500328_- Is that right ? I double checked DSNXDBRM macro. There is no field in DBRM which specify date/time format. Unless some one is using local date exit which could change the length. DBRM contains data type code and length.
Could you point how DBRM stores time format ? At least DSNXDBRM macro does not indicate that. [...]
18619 46 39_Re: Y2K 31 Dec 1999 - Are you working ?14_William Gannon41_wgannon@INET-SERVICES.PALMBEACH.K12.FL.US30_Mon, 6 Dec 1999 15:41:47 -0500515_us-ascii According to the date of your email - you have another three years to prepare ! ;-)
Max 'Guderian' wrote:
> I see that there aren't so many senior systems administrators in > DB2.....:-))). Works slave !! > > OK next year we'll be all drunk in Time Square, if we'll conserve our > job... > > Now serious arguments: I offer myself to post any troubles in my time > zone. > > I'm in Italy (-1 GMT) so if my system will not crash, if my ISP will > survive, if Listserv will work and > > if [...]
18666 75 21_Re: change ISO to JIS11_rick creech18_ykcirc@HOTMAIL.COM28_Mon, 6 Dec 1999 13:15:02 PST629_- The parameters for default date and time format are in the decp module.
>From: "Pillay, Venkat (PCA)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: change ISO to JIS >Date: Mon, 6 Dec 1999 15:41:38 -0500 > >Is that right ? I double checked DSNXDBRM macro. There is no field in DBRM >which specify date/time format. Unless some one is using local date exit >which could change the length. DBRM contains data type code and length. > >Could you point how DBRM stores time format ? At least DSNXDBRM macro does >not indicate that. > >Regards [...]
18742 90 21_Re: change ISO to JIS16_Swinski, Kenneth32_KSwinski@INTERNAL.MASSMUTUAL.COM30_Mon, 6 Dec 1999 16:19:12 -0500626_us-ascii Check out DSNMACS(DSNXOPT).
POPT DSECT PARSER OPTIONS POPTHOST DS C OPTIONS AND HOST LANGUAGE POPTQUOT EQU X'80' APOST(0) OR QUOTE(1) POPTCOMM EQU X'40' PERIOD(0) OR COMMA(1) POPTQUOS EQU X'20' APOSTSQL(0) OR QUOTESQL(1) POPTGRA EQU X'10' MIXED YES|NO POPTPOPT EQU X'08' USE POPT YES|NO POPTHST EQU X'07' HOST LANGUAGE POPTCHAR DS C CHARACTER SET BEING USED POPTHST2 DS C V2 R1 HOST LANGUAGE POPTTDT DS C DATE/TIME OPTIONS, 0 = NONE POPTTLOC EQU X'80' LOCAL TIME POPTTJIS EQU X'40' JIS TIME POPTTISO EQU X'20' ISO TIME POPTTEUR EQU X'20' EUR TIME POPTTUSA EQU X'10' USA TIME POPTDLOC EQU X'08' LOCAL DATE [...]
18833 44 24_Re: Redefine a partition11_Kwan, James18_James_Kwan@BMC.COM30_Mon, 6 Dec 1999 15:24:13 -0600543_ISO-8859-1 Don't forget to regrant all the authorities, perform a runstats and rebind all packages/plans. Use a third party change management tool will automate the process.
James Kwan
-----Original Message----- From: Fred Grasso [mailto:fgrasso@FBFS.COM] Sent: Thursday, December 02, 1999 9:11 AM To: DB2-L@RYCI.COM Subject: Redefine a partition
We are in the process of redefining partitioned tablespaces for the first time on DB2 version 5. We are going to use the following steps to accomplish this task: [...]
18878 113 21_Re: change ISO to JIS20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Mon, 6 Dec 1999 16:25:45 -0500627_- Cool.
Thanks Venkat Pillay > -----Original Message----- > From: Swinski, Kenneth [SMTP:KSwinski@INTERNAL.MASSMUTUAL.COM] > Sent: Monday, December 06, 1999 4:19 PM > To: DB2-L@RYCI.COM > Subject: Re: change ISO to JIS > > Check out DSNMACS(DSNXOPT). > > POPT DSECT PARSER OPTIONS > POPTHOST DS C OPTIONS AND HOST LANGUAGE > POPTQUOT EQU X'80' APOST(0) OR QUOTE(1) > POPTCOMM EQU X'40' PERIOD(0) OR COMMA(1) > POPTQUOS EQU X'20' APOSTSQL(0) OR QUOTESQL(1) > POPTGRA EQU X'10' MIXED YES|NO > POPTPOPT EQU X'08' USE POPT YES|NO > POPTHST EQU X'07' HOST LANGUAGE > POPTCHAR DS C CHARACTER SET BEING USED > POPTHST2 DS [...]
18992 120 29_Re: SQL Equivalent statements0_24_db46@DAIMLERCHRYSLER.COM30_Mon, 6 Dec 1999 16:21:27 -0500440_us-ascii No they are not equivalent. This is based on DeMorgans therom as follows: When you reverse the outside you must reverse (or not) all of the inside to include all boolean operators:
Not ((A > B) or (A < C)) Becomes => ((A <= B) and (A >= C))
Test case A = 1, B = 2, C = 0 Not ((1 > 2) or (1 < 0)) is true ((1 <= 2) and (1 >= 0)) is true Not (False False) (True True) Test case A = 1, B = 2, C = 3 Not ((1 > 2) or [...]
19113 138 29_Re: SQL Equivalent statements16_Redondo, Luis J.23_LJRedond@SOUTHERNCO.COM30_Mon, 6 Dec 1999 15:47:02 -0600542_- Thanks for the response. That helps a lot!
> -----Original Message----- > From: db46@DAIMLERCHRYSLER.COM [SMTP:db46@DAIMLERCHRYSLER.COM] > Sent: Monday, December 06, 1999 4:21 PM > To: DB2-L@RYCI.COM > Subject: Re: SQL Equivalent statements > > No they are not equivalent. This is based on DeMorgans therom as follows: > When you reverse the outside you must reverse (or not) all of the inside > to > include all boolean operators: > > Not ((A > B) or (A < C)) Becomes => ((A <= B) and (A >= C)) > > Test case A = 1, B = 2, C = [...]
19252 32 14_Use of Aliases16_Dunlap, Bruce E.23_X2DUNLAP@SOUTHERNCO.COM30_Mon, 6 Dec 1999 16:05:58 -0600469_- All,
We have several user acceptance databases which contain many static tables. These tables are loaded from production down to UA once each week. The static tables in production are only updated once every 1 or two weeks. The UA static tables are only used for retrieval only.
We believe that creating aliases, in the UA environment, to the production tables would serve the same purpose and eliminate the need to reload the UA tables each week. [...]
19285 54 18_Re: Use of Aliases9_Wu, James13_jwu@KRAFT.COM30_Mon, 6 Dec 1999 16:31:47 -0600639_- One more issue: with aliases on a separate DB2 subsystem you can not join or union the remote tables (through aliases) with the local tables.
James Wu :-)
james@xetor.com
> From: Dunlap, Bruce E. [SMTP:X2DUNLAP%southernco.com@internet.kraft.com] > Sent: Monday, December 06, 1999 4:06 PM > To: DB2-L%ryci.com@internet.kraft.com > Subject: Use of Aliases > > All, > > We have several user acceptance databases which contain many static > tables. > These tables are loaded from production down to UA once each week. The > static tables in production are only updated once every 1 or two weeks. > The > UA [...]
19340 19 41_How can I access DB2 directly from ReXX??18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM30_Mon, 6 Dec 1999 17:31:18 -0500416_us-ascii Hi!
Is there a way in which I can access DB2 from my ReXX without having to build up and execute a JCL wherein I use say IKJEFT01.
Thanks
Kartik
================================================ 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.
19360 59 18_Re: Use of Aliases0_22_Rohn.Solecki@MTS.MB.CA30_Mon, 6 Dec 1999 16:39:38 -0600580_us-ascii This is an issue we continue to fight with, because we have applications that have to access data in different production subsystems.
When going across subsystems DB2 has to jump thru some extra hoops. Either the SQL is dynamic (access path calculated at every execution) or you have to create a separate module that is statically bound, but then you have to do a DB2 CONNECT to the remote subsystem (and back). So using and ALIAS to cross Subsystems can be done, but it will give you a very different access path (and response time) than using a table, view [...]
19420 36 45_Re: How can I access DB2 directly from ReXX??11_Kwan, James18_James_Kwan@BMC.COM30_Mon, 6 Dec 1999 17:13:10 -0600514_ISO-8859-1 DB2 V6 comes with a REXX interface or if you have a BMC utility, you can have a light version of RxD2 REXX interface.
James Kwan -----Original Message----- From: Kartik Subramanian [mailto:kartik.k.subramanian@BELLATLANTIC.COM] Sent: Monday, December 06, 1999 4:31 PM To: DB2-L@RYCI.COM Subject: How can I access DB2 directly from ReXX??
Hi!
Is there a way in which I can access DB2 from my ReXX without having to build up and execute a JCL wherein I use say IKJEFT01. [...]
19457 70 49_Re: How can I access DB2 directly from ReXX?? (2)18_Kartik Subramanian37_kartik.k.subramanian@BELLATLANTIC.COM30_Mon, 6 Dec 1999 18:38:41 -0500640_us-ascii James,
My installation has DB2 V5 so guess this won't be possible. Is there any other way out?
Kartik
"Kwan, James" on 12/06/99 06:13:10 PM
Please respond to "DB2 Data Base Discussion List"
To: DB2-L@RYCI.COM
cc: (bcc: KARTIK K. SUBRAMANIAN/EMPL/VA/Bell-Atl)
Subject: Re: How can I access DB2 directly from ReXX?? (2)
DB2 V6 comes with a REXX interface or if you have a BMC utility, you can have a light version of RxD2 REXX interface. [...]
19528 129 49_Re: How can I access DB2 directly from ReXX?? (2)13_Chie, Jim (C)17_chiej@CONNEXT.COM30_Mon, 6 Dec 1999 15:50:11 -0800371_iso-8859-1 In the past I've used DSNTEP2 for this. The guts of the routine in REXX is:
Address TSO "Allocate File(SYSIN) Dataset('"dataset"') Shr ReUse" /* SQL */ "ALLOC F(SYSPRINT) SP(20 5) NEW DSORG(PS)", "TRACKS RECFM(V B) LRECL(137) REUSE"
/* Write DB2 commands to TSO Stack */ "NewStack" Queue "RUN PROGRAM("DSNTEP2") PLAN("DSNTEP2")" Queue "END" [...]
19658 60 45_Re: How can I access DB2 directly from ReXX??14_O'Conner, John26_john.oconner@COURTS.WA.GOV30_Mon, 6 Dec 1999 16:00:15 -0800330_iso-8859-1 I've been hearing that DB2 V6 comes with a REXX interface. How does it get installed? Is it ordered separately? Where's the documentation? We ordered V6 a week after it was GA. Was this added after that?
I feel kinda dumb for having to ask these questions.
Thanks for any assistance you can provide. [...]
19719 39 21_Re: change ISO to JIS14_Campbell James30_James.Campbell@ENERGYIS.COM.AU30_Tue, 7 Dec 1999 11:15:14 +1000325_us-ascii This is only true if you explicitly specify a time format during the precompile. If you don't the value of POPTTDT is zero (see the note DSNXOPT). So a rebind across a change in the default format will certainly cause a change in format: you'll have to experiment to see if the change happens without a rebind. [...]
19759 101 45_Re: How can I access DB2 directly from ReXX??15_Shaun Z Lombard36_Shaun.Z.Lombard@TRANSPORT.QLD.GOV.AU30_Tue, 7 Dec 1999 10:12:18 +1000379_us-ascii The REXX DB2 interface is available for DB2 for OS/390 Version 5. It can be ordered from IBM at no cost. The documentation is available at the IBM DB2 website. For DB2 version 5 it is a separate book called REXX Language Support, for version 6 - I think it is incorporated in the Application Programming and SQL Guide, the installation guide and the SQL reference. [...]
19861 23 36_Re: Version 5 Upgrade Rebind Problem12_Roger Miller19_millerrl@US.IBM.COM30_Mon, 6 Dec 1999 08:07:31 -0800325_us-ascii What level of service are you running? Some of the -101 errors are a result of a customer pressing to the absolute limit of V4, and having the sizes be a little bigger. I think that the V5 documentation has a paragraph on this in the incompatibility section - soft copy. What is the module finding the problem? [...]
19885 110 49_Re: How can I access DB2 directly from ReXX?? (2)11_Paul Elliot27_pelliot@MAIL.FAIRFAX.COM.AU30_Tue, 7 Dec 1999 11:28:30 +1100405_iso-8859-1 All
Actually, the Rexx DB2 interface is available for DB2 V5, we already have it at one of my client's sites.
It has been released as a separately orderable feature (no cost) for V5. (Feature Number 5862 - 3480 cart)
The announcement letter for the recent refresh for DB2 OS/390 Version 5 (Sept 7, 1999) is available on the IBM web site. www.software.ibm.com/db2os390 [...]
19996 33 14_A question????12_Dinesh Kumar15_DKUMAR@AARP.ORG30_Mon, 6 Dec 1999 20:06:38 -0500456_US-ASCII heres the problem i m facing.. i wanted to squeze the column length (defined as decimal 15)to 5 in a spufi run report. we are on version 4 release 1.0 of DB2. i tried this sql
SELECT SUBSTR((STRIP(DIGITS(CHG_TO_COUNT),L,'0')),1,5) CHGCNT FROM KONNEX.ACCT_STAT_CTL
The error was: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "STRIP". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: AVG, SUBSTR, MAX, HEX, FLOAT, DATE, YEAR, ETC. [...]
20030 49 21_Re: Cluster missing..0_23_tbalakri@HEITECH.COM.MY30_Tue, 7 Dec 1999 09:41:44 +0800712_US-ASCII Hi, I think you have to create a new cluster without index pointing to old cluster name,specify recatlg parameter when you are creating.Let me know if you need any further info.
regards, bala
db2v5r1@HOTMAIL.COM on 12/06/99 09:46:33 AM
Please respond to DB2-L@RYCI.COM
To: DB2-L@RYCI.COM cc: (bcc: T Balakrishna/DATA_CENTRE/PNBIT) Subject: Cluster missing..
hi all, We have a DB2 tablespace with missing cluster. We have got only the data component. We are on DB2V5.1(SMS managed). We dont have the latest backups to restore the cluster. Is there any way by which we can create a new cluster which can point to the [...]
20080 92 45_Re: How can I access DB2 directly from ReXX??11_Paul Elliot27_pelliot@MAIL.FAIRFAX.COM.AU30_Tue, 7 Dec 1999 12:46:43 +1100357_iso-8859-1 John,
I don't remember if REXX DB2 support came out in V6 at GA or later.
It's a separately orderable feature for V5, (you don't get it unless you specifically request it). This may be true for V6 as well.
Roger Miller, are you there? Can you confirm?
Cheers,
Paul Elliott ADC Consultants Sydney Australia [...]
20173 65 18_Re: A question????14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU30_Tue, 7 Dec 1999 13:17:00 +1100391_- Dinesh,
The simplest approach to obtain the last 5 digits is: SELECT SUBSTR(DIGITS(CHG_TO_COUNT),11,5) But that will still return you the leading zeros if the value is less than 5 digits. Alternatively, use SELECT DECIMAL(CHG_TO_COUNT,5) This will fail if the original value is greater than 5 digits (which the substr would truncate anyway), but it does remove leading zeroes. [...]
20239 80 16_SQL in a Trigger12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Mon, 6 Dec 1999 20:52:30 -0600445_us-ascii Hello.
I've been playing with triggers for a few days now, and attempting to learn SQL in the process. Here is something I've been unable to accomplish, although it seems like it would be a simple thing to do. We're running DB2 V6, OS/390.
In a "before" Insert trigger, I want to set one (actually 5) of the columns to values in another table. (I use the colon delimiter in SPUFI to get past another syntax problem.) [...]
20320 13 12_(no subject)0_16_afifi@UQU.EDU.SA30_Tue, 7 Dec 1999 08:34:05 +0300271_x-user-defined SIGN-OFF DB2-L
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
20334 25 25_DB2 SQL STORED PROCEDURES10_Ozan VAKAR19_ovakar@32BIT.COM.TR30_Tue, 7 Dec 1999 08:59:37 +0200424_iso-8859-9 I try to develop SQL Stored Procedures for DB2 UDB for AS/400 V4R3 I have trouble about finding enough documentation. I use SQL Reference and SQL Programming books + Two redbooks Advanced Database Functions and Developing Cross-Platform DB2 Stored Procedures: SQL Procedures and the DB2 Stored Procedure Builder
Does any one know a better information source because most of the examples doesn't work. [...]
20360 59 39_Re: Y2K 31 Dec 1999 - Are you working ?32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR30_Tue, 7 Dec 1999 10:23:32 +0200449_- I'm in Turkey, GMT-2. If anything happens strange i'll post it to the list.
Good luck to everybody. Cuneyt Goksu
-----Original Message----- From: William Gannon [mailto:wgannon@INET-SERVICES.PALMBEACH.K12.FL.US] Sent: Monday, December 06, 1999 10:42 PM To: DB2-L@RYCI.COM Subject: Re: Y2K 31 Dec 1999 - Are you working ?
According to the date of your email - you have another three years to prepare ! ;-) [...]
20420 21 39_Re: Y2K 31 Dec 1999 - Are you working ?7_Gustavo26_lozano@BANDEIRANTES.COM.BR30_Tue, 7 Dec 1999 09:11:47 -0300497_iso-8859-1 I'll be in Sao Paulo - Brazil (GMT -4) on Dec 31. I'll post to the list if something wrong or curious happens.
Best regards. Good luck. Boa sorte.
Gustavo Lozano (lozano@bandeirantes.com.br) - Banco Bandeirantes São Paulo - Brazil
================================================ 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.
20442 174 39_Re: Y2K 31 Dec 1999 - Are you working ?17_Barbosa, Odimir J22_odimir.barbosa@EDS.COM30_Tue, 7 Dec 1999 05:13:14 -0600715_ISO-8859-1 Michael,
I agree with you on this one.
Odimir Jamas Barbosa EDS - Brazil (DBA Team) mailto:odimir.barbosa@eds.com
> -----Original Message----- > From: Piontkowski Michael ML [SMTP:michael.piontkowski@ASTRAZENECA.COM] > Sent: Monday, December 06, 1999 4:11 PM > To: DB2-L@RYCI.COM > Subject: Re: Y2K 31 Dec 1999 - Are you working ? > > Where is it stated that this is an English language listserv? > > > Mike Piontkowski > Voice/Fax: 302.886.4612 > mailto:michael.piontkowski@astrazeneca.com > > > ---------- > > From: Dan S Brogdon[SMTP:Dan.S.Brogdon@AEXP.COM] > > Sent: Monday, December 06, 1999 11:56 AM > > To: DB2-L@RYCI.COM > > Subject: Re: [DB2-L] [...]
20617 28 33_OS/390 rather than DB2 question ?10_Robert Ord21_robertord@HOTMAIL.COM28_Tue, 7 Dec 1999 11:55:52 GMT326_- I don't think this is a DB2 question but I wonder if anyone can suggest why applications should be taking 5 or 6 times longer elapse than normal but the same cpu time. It seems to be a CPU issue rather than IO.We are running OS/390 02.06.00 in goal mode and we do have DDF running which seems to be using a lot of CPU. [...]
20646 49 18_Re: A question????13_Lynne Flatley17_LFlatley@NEFN.COM30_Tue, 7 Dec 1999 07:31:53 -0500622_- STRIP isn't available till Version 5.1
> -----Original Message----- > From: Dinesh Kumar [SMTP:DKUMAR@AARP.ORG] > Sent: Monday, December 06, 1999 8:07 PM > To: DB2-L@RYCI.COM > Subject: A question???? > Sensitivity: Confidential > > heres the problem i m facing.. > i wanted to squeze the column length (defined as decimal 15)to 5 in > a spufi run report. > we are on version 4 release 1.0 of DB2. > i tried this sql > > > SELECT SUBSTR((STRIP(DIGITS(CHG_TO_COUNT),L,'0')),1,5) CHGCNT > FROM KONNEX.ACCT_STAT_CTL > > The error was: > DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "STRIP". SOME SYMBOLS THAT [...]
20696 26 45_Re: How can I access DB2 directly from ReXX??13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 7 Dec 1999 07:40:33 -0500319_iso-8859-1 Actually, the Rexx interface to DB2 was delivered for DB2 V5 before it was available for V6. I have been using it for about a month on V5 and don't have it yet on v6(but maybe just because I haven't bothered the right people lately.
It is a no-cost feature but must be ordered. See your IBM rep. [...]
20723 30 60_DB2 Connect Enterprise Edition - Successful CREATE DATABASE?11_Kurt Rompot21_RompotK@SCHNEIDER.COM30_Tue, 7 Dec 1999 07:27:05 -0600389_us-ascii We have DB2 Connect Enterprise Edition V6.1 installed on Sun Solaris. While installing another product, we were surprised to be able to successfully create a local DB2 database and tables. I didn't expect this capability to be included in DB2 Connect EE. I'm guessing that remote users will be unable to connect to this local database but haven't had time to test my theory. [...]
20754 65 14_SAP R/3 OS/3909_Jo K.Nash17_jo.k.nash@USA.NET28_Tue, 7 Dec 1999 08:47:02 EST319_US-ASCII Has anyone else seen this? This was forwarded to me and I wasn't sure if this was an attempt to gain my email address or was this valuable. Does anyone remember this from the past? and are you going to participate Wednesday? I wouldn't mind expanding my knowledge, but don't want to waste my time either. [...]
20820 67 14_SAP R/3 OS/3909_Jo K.Nash17_jo.k.nash@USA.NET28_Tue, 7 Dec 1999 08:51:43 EST392_US-ASCII I'm having email problems, so apologies if this gets posted twice
Has anyone else seen this? This was forwarded to me and I wasn't sure if this was an attempt to gain my email address or was this valuable. Does anyone remember this from the past? and are you going to participate Wednesday? I wouldn't mind expanding my knowledge, but don't want to waste my time either. [...]
20888 70 18_Re: SAP R/3 OS/39011_Ball, Linda18_Linda_Ball@BMC.COM30_Tue, 7 Dec 1999 08:07:01 -0600295_ISO-8859-1 We (BMC) have held a couple of these in the past on this topic and they were beneficial in my opinion. It will be as good as the participants make it with their comments and questions. In the past, it has been enlightening for both developers of software and the users, I think. [...]
20959 13 18_Re: SAP R/3 OS/39012_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM30_Tue, 7 Dec 1999 08:08:50 -0600395_us-ascii I've been involved in BMC Conference calls in the past. Not a waste of time. I received the same e-mail and I will be participating in this one.
================================================ 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.
20973 61 64_Re: DB2 Connect Enterprise Edition - Successful CREATE DATABASE?0_15_leon@CA.IBM.COM30_Tue, 7 Dec 1999 09:44:21 -0500375_us-ascii Technically, DB2 Connect does contains a portion of the whole DB2 UDB database engine. The reason it is there is to support 2-phase commit function. You will need an ability to create database whenever you need to create a TM database. This is described in our manuals. If you try to connect to this database from a remote machine you will get a license error. [...]
21035 92 39_Re: DB2 Connect Enterprise Edition - Su11_Kurt Rompot21_RompotK@SCHNEIDER.COM30_Tue, 7 Dec 1999 08:54:01 -0600545_us-ascii Thanks for the prompt follow-up, Leon. It was not our intent to use DB2 Connect for anything other than connectivity. We were just really surprised to find the create database functionality intact.
-------------------- Kurt Rompot DB2 Database Analyst Schneider National, Inc. rompotk@schneider.com
DB2-L@RYCI.CO M To: Janet Kubsh/Schneider@Schneider, Kurt Rompot/Schneider@Schneider, DB2-L@DB2-L@RYCI.COM@SMTP@exchange 12/07/2010 cc: 08:45 AM Subject: Re: DB2 Connect Enterprise Edition - Su [...]
21128 21 30_Unsuccessful RID Pool Accesses15_Brian Zamborski18_bzamborski@USS.COM30_Tue, 7 Dec 1999 10:49:03 -0500564_us-ascii All, I am a relatively new application DBA, and in our system we are having a large number of RID pool accesses that are unsuccessful due to MAX LIMIT (number of RIDS?) being exceeded. We do not have any problems due to the lack of storage, however. Is this a common problem? It seems to occur mostly when a multiple index access takes place, and it causes a failure and the system reverts to a tablespace scan. Is this easily solvable (i.e. is there a parameter that can be changed to increase the maximum number of RIDS? Any help/suggestions would [...]
21150 33 22_Erwin and index names?15_Backes, Michael26_BackeM@MAIL.OA.STATE.MO.US30_Tue, 7 Dec 1999 10:10:44 -0600603_iso-8859-1 in our shop we have a standard of numbering tablespaces within a database, ie db001.ts0001, etc. with one table per tablespace. along with that we have maintained an index naming standard that incorporates that tablespace number into the index names for the table within that tablespace, keeping the index names to 8 chars to avoid db2 intervention in naming the vsam file behind the scenes. our problem is, we have started using erwin, and while generating the tablespace commands etc is no problem, we are unable to generate the create index commands in such a way as to maintain this [...]
21184 160 18_Re: SAP R/3 OS/39022_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP30_Tue, 7 Dec 1999 15:14:29 +0000527_ISO-8859-1 Jo Like Dan I would suggest that you get involved .. If I were working at a site with BMC products I would be chomping at the bit to get involved in them.
Jo - incidently I have created a spreadhseet containing performance data collected from DB2 and SAP that can be used to show how you compare to ther SAP OS390 sites (lots of good info).. IBM have contacted me already to say that they had been informed that I was doing this and would I mind allowing them to help out (which is great news for all of [...]
21345 77 18_Re: A question????18_Andrade, Alexander25_alexander.andrade@CAI.COM30_Tue, 7 Dec 1999 16:21:17 -0000421_- If You have SAS and especially the ACCESS to DB2 interface then you can use a multitude of SAS functions to achieve this. Otherwise its V5.1 or upwards for you or programming solution
Alex Andrade
-----Original Message----- From: Lynne Flatley [SMTP:LFlatley@NEFN.COM] Sent: Tuesday, December 07, 1999 12:32 PM To: DB2-L@RYCI.COM Subject: Re: A question???? Sensitivity: Confidential [...]
21423 49 34_Re: Unsuccessful RID Pool Accesses12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 7 Dec 1999 08:30:16 PST495_- Brian There are a couple of RID POOL rules you should be aware of. First, If a single process uses more than 50% of the available space, then it reverts to a TS scan. If your application cannot acquire a 64k block of space in the pool, it will revert to a TS scan. Take a look at how much of the RID pool is being used by these processes. More than likely, it would be the 50% rule that could be causing your problem and you will need to look at the process or increase the RID pool. Let [...]
21473 39 37_Re: OS/390 rather than DB2 question ?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV30_Tue, 7 Dec 1999 10:41:00 -0500352_- In Goal mode, The DDF enclaves' default goal type is discretionary (almost the lowest). You have to create goals for the enclaves. Glenn Anderson, of IBM, gave a very good presentation on WLM at the DB2 Tech Conference in New Orleans, "Implementing OS/390 WLM and DB2".
No Warrantee, either explicit or implied, is included in this info. [...]
21513 13 21_Re: Cluster missing..11_Bernie Watt19_BWATT_TS@KEYFIN.COM30_Tue, 7 Dec 1999 12:04:18 -0500349_us-ascii Running a RECOVER INDEX will cause DB2 to recreate the VSAM file and build the index off the data.
================================================ 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.
21527 34 21_Re: Cluster missing..0_23_Mike_Levine@TEKHELP.NET30_Tue, 7 Dec 1999 13:10:17 -0500308_us-ascii Hi,
I don't believe this will work because DB2 will be unable to delete the data component and you will probably receive some sort of IDCAMS error on the DELETE/DEFINE. The best way to correct this is with a DEFINE RECATLG. Also, the original post indicated a problem with a tablespace. [...]
21562 44 36_SQL - Eight Steps for Coding Queries11_John Wynton21_jwynton@THEMISINC.COM30_Tue, 7 Dec 1999 13:20:27 -0500547_- Dear DB2 List:
We have expanded the "Technical Tips" section of our web site to include an 8-part series on coding SQL Queries.
This series was written by Gary Joehlin, a developer, consultant and instructor of DB2 SQL programs and queries among other topics. He has included in this series a set of tools that have helped him and his many students develop SQL statements. Even if you are a non-DB2 user, you may find many of the techniques and ideas useful as they can easily be used on most if not all relational platforms. [...]
21607 37 44_SQL2071N on ADSM DB Backup on UDB 6.1 on AIX0_22_BILL_GALLAGHER@PHL.COM30_Tue, 7 Dec 1999 13:53:10 -0500428_us-ascii We've just installed UDB 6.1 on AIX, and are trying to do an ADSM backup of the SAMPLE database for the first time. Here is the command we are issuing:
db2 backup database sample use adsm open 1 sessions with 2 buffers buffer 1024
We are experiencing the following error:
SQL2071N: An error occurred while accessing the shared library "/home/db2inst1/sqllib/adsm/libadsm.a". Reason code: "1". [...]
21645 22 25_Rebuild DBRM from Catalog13_Andre Serrano25_ANDRE.SERRANO@GUYCARP.COM30_Tue, 7 Dec 1999 13:01:50 -0800344_- There was a posting a few weeks ago about a REXX which would rebuild the source DBRM from the catalog. Does anyone know where I can find this Rexx?
We have lost a production DBRM and do not have the source and are desperately looking to rebuild it quickly. We are currently on DB2 V5.1 running on OS 390. Any help is appreciated. [...]
21668 26 38_R: Y2K 31 Dec 1999 - Are you working ?14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 4 Jan 1997 07:57:38 +0100548_us-ascii Thanks for....... what ?
I hope nobody has been offended, it was only a way to exorcise the millenium bug and to give
aid each other (I found many useful suggestions here !!)
Greetings
Max Scarpa System Administrator Cesve S.p.A Standards disclaimers apply.....
================================================ 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.
21695 57 42_Re: R: Y2K 31 Dec 1999 - Are you working ?12_craig patton21_prgpatton@HOTMAIL.COM28_Tue, 7 Dec 1999 11:53:12 PST378_- 1 further suggestion.
I think we should all have a toast at exactly midnight (in your time zone of course). We should all toast each other for being the warriors that will be in place, should anything go awry.
** NOTE ** While it is traditional for a toast to be alcoholic, in deference to the non-drinking populace, ANY beverage can be used for the toast. [...]
21753 52 29_Re: Rebuild DBRM from Catalog18_DAVIS, RICK (SWBT)21_RD8246@MOMAIL.SBC.COM30_Tue, 7 Dec 1999 13:48:40 -0600636_iso-8859-1 Check the archives at url: http://jupiter.ryci.com/archives/db2-l.html
HTH, Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...]
21806 39 20_REXX & DB2 interface14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 4 Jan 1997 08:48:31 +0100340_iso-8859-1 I don't know if someone posted this information (I didn't see anywhere the post) before, but other
then QMF and 3.rd party pgms there's a IBM program (DB2WWWX) which is an interface
between DB2 and REXX.
I use it very very extensively to generate recoveries and it works fine and it's free. You can use [...]
21846 37 45_Re: How can I access DB2 directly from ReXX??14_Max 'Guderian'16_mocion@LIBERO.IT30_Sat, 4 Jan 1997 08:53:02 +0100301_us-ascii I don't know if someone posted this new, but other then QMF and 3.rd party pgms there's a IBM
program (DB2WWWX) which is an interface between DB2 and REXX. I use it very very
extensively and it works fine and it's free. You can use almost any sql statement. I find it with [...]
21884 74 34_Re: Unsuccessful RID Pool Accesses14_Richard Yevich17_ryevich@YAHOO.COM30_Tue, 7 Dec 1999 14:20:59 -0800341_us-ascii Brian,
You have exceeded 16 million RIDS and there is no way to change that limit. If you really need to qualify over 16 million rids, then disallow list prefetch and use another index access as long as you are not going to exceed 25% of the tablespace. If more than 25% of the tablespace, then use sequential prefetch. [...]
21959 78 14_DBD Corruption10_Paul Fegan23_Paul.Fegan@CITEC.COM.AU30_Wed, 8 Dec 1999 08:52:59 +1000533_US-ASCII Hi,
I have a question about DBD corruption. We reciently had a problem with QMF temporay table (ie the QMF proc erases the last set of data using ERASE .... and runs a query and save the new set). The table could not be erased in QMF and could not be dropped using normal means. After a lot of stuffing around I ran a REPAIR DBD TEST ... and found that the DBD was stuffed or at least the catalog and DBD nolonger matched. Since the DBD contained OBD's that weren't present in the catalog I figured there was no [...]
22038 92 49_Re: How can I access DB2 directly from ReXX?? (2)18_COLLINS, BUFF (PB)23_EACOLLI@MSG.PACBELL.COM30_Tue, 7 Dec 1999 15:23:36 -0800442_iso-8859-1 Hello. REXX Language Support is a no-cost function of DB2 V5 as well as V6. You simply need to order FMID JDB551H from your IBM rep.
E. A. Collins DB2 System Support EACOLLI@.PACBELL.COM
-----Original Message----- From: Kartik Subramanian [mailto:kartik.k.subramanian@BELLATLANTIC.COM] Sent: Monday, December 06, 1999 3:39 PM To: DB2-L@RYCI.COM Subject: Re: How can I access DB2 directly from ReXX?? (2) [...]
22131 78 48_Re: SQL2071N on ADSM DB Backup on UDB 6.1 on AIX13_Umair Hussain25_umair_hussain@HOTMAIL.COM28_Tue, 7 Dec 1999 18:47:19 CST288_- You should also be gettin an ADSM error code in dsmerror file. I would first resync ADSM password with DB2 and then give it a shot. The second thing that maybe happening is libadms.a that db2 is using is newer than the ADSM client on your system.....maybe they are not compatible. [...]
22210 70 29_Re: Rebuild DBRM from Catalog10_Leo Flores23_leoflores@EARTHLINK.NET30_Tue, 7 Dec 1999 17:22:02 -0800288_us-ascii Hi Andre,
When you say "We have lost a production DBRM" I'm presuming that you have lost the DBRM in the PDS and not the copy of the DBRM in the DB2 catalog. Am I guessing correct?
If you lost the DBRM, have you lost the LOAD also? Was A precompile performed? [...]
22281 73 31_Re: SAP Question using SNAPSHOT9_Jo K.Nash17_jo.k.nash@USA.NET28_Tue, 7 Dec 1999 21:49:39 EST352_US-ASCII John,
Sorry for the late reply. I took a month vacation before Y2K halts all vacations for a while. Oh well..
I started to answer your questions with a yes, but then realized that you were not talking about BMC's snapshot rather hardware snapshot. It gets confusing with BMC and hardware competing for use of the same term. [...]
22355 243 29_Re: Y2k overtime compensation14_Harvey Wachtel22_HWachtel@UAPC.CUNY.EDU30_Tue, 7 Dec 1999 22:01:01 -0500452_us-ascii
It seems from your reply that you might appreciate the attached poem by Goethe on the subject of overworking for money. (See attached file: Goethe00.wpd).
Daniel Boulanger To: dboulang@CA.IBM.COM Subject: Re: Y2k overtime compensation Sent by: DB2 Data Base Discussion List
1999-12-02 01:25 Please respond to DB2 Data Base Discussion List [...]
22599 110 24_Re: [Re: SAP R/3 OS/390]9_Jo K.Nash17_jo.k.nash@USA.NET28_Tue, 7 Dec 1999 22:05:22 EST603_US-ASCII Thanks Linda. From the responses I got this sounds interesting and beneficial. Has anyone seen the topic yet? With all the messages I got it probably doesn't matter, we could all probably provide endless amounts of useful tips and techniques.
Jo
"Ball, Linda" wrote: We (BMC) have held a couple of these in the past on this topic and they were beneficial in my opinion. It will be as good as the participants make it with their comments and questions. In the past, it has been enlightening for both developers of software and the users, I think. [...]
22710 115 20_Re: SQL in a Trigger16_Richard A Yevich21_ryevich@ATTGLOBAL.NET30_Tue, 7 Dec 1999 23:28:05 -0500412_iso-8859-1 Actually what you need follows this. However, the scalar subquery delivering the value for the set has not been implemented in OS/390 yet, although an APAR on UPDATE/SET has been recently closed.
SET NROW.COL1 = SELECT COL1 FROM DBATEST.MASTER_TABLE WHERE MASTER_KEY = NROW.MASTER_KEY OPTIMIZE FOR 1 ROW FOR READ ONLY;
Regards, Richard +===+===+===+===+====+ richard_yevich@ibm.net [...]