1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2001, week 5
2 14 35_Re: JCL for running SPUFI in Batch.14_Michael Barton14_mikeba@VSP.COM31_Sun, 29 Apr 2001 01:38:29 -0500333_- You could also use the DSNTIAUL sample program, using the same JCL that Richard Molera sent you. The difference between the two is the output. DSNTEP2 gives you a formatted output (column names, page numbers, etc.), where as DSNTIAUL gives you a flat file format suitable for further processing by LOAD utilities or programs. [...]
17 70 33_Re: Offline Backup on AIX Problem11_Endy Lambey27_endyl@MITRAINFOSARANA.CO.ID31_Sun, 29 Apr 2001 15:54:34 +0700674_ISO-8859-1 Thank you John, Philip, and others for giving your answers to me. Thank you...
*********** REPLY SEPARATOR ***********
On 4/26/2001 at 6:52 AM jlf4@daimlerchrysler.com wrote:
>I do not remember which parameter it is, but in /etc/security there is a >parameter that sets how larger a file a particular log on can create. We >have to have the UNIX System Administrators change it to unlimited every >time a new server is installed. > > > > > >Endy Lambey @RYCI.COM> on 04/25/2001 11:40:15 >PM > >Please respond to endyl@mitrainfosarana.co.id > >Sent by: DB2 Data Base Discussion List > > >To: [...]
88 85 29_Re: Codepage & Backup Problem11_Endy Lambey27_endyl@MITRAINFOSARANA.CO.ID31_Sun, 29 Apr 2001 15:54:49 +0700619_ISO-8859-1 Thank you Gert,Greg, Jim, and others for giving your answers to me. Thank you...
*********** REPLY SEPARATOR ***********
On 4/23/2001 at 7:09 PM Palgrave, Greg wrote:
>I've run into this a couple of times on NT when servers have been set up >with different codepage defaults. > >When you create a database you can specify which codepage it should use >(either via the GUI or command line "USING CODESET codeset "). SO if you >CREATE a database "FRED" with the codepage 1252 on your DB2 server (with a >different codepage), then restore your backup to this database, you should >get [...]
174 36 39_Re: Image Copy Registration in syscopy.15_Murley, Michael22_Michael_Murley@BMC.COM31_Sun, 29 Apr 2001 12:33:49 -0500483_iso-8859-1 Lee,
SYSCOPY records many kinds of events that affect recoverability. The type of event is denoted by the ICTYPE column. You can look at the SYSCOPY definition in the back of the SQL Reference to see what the various ICTYPE values mean.
Michael Murley BMC
-----Original Message----- From: Lee Mandel [mailto:DBMSUser@AOL.COM] Sent: Saturday, April 28, 2001 11:14 AM To: DB2-L@RYCI.COM Subject: Image Copy Registration in syscopy. [...]
211 89 19_Re: from IMS to DB216_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sun, 29 Apr 2001 19:42:25 +0100400_us-ascii Ajay,
although I see you already have had enough replies, a little more food for thought from IMS-L....
Ciao!
Aurora Emanuela Dell'Anno Systems Engineer Candle Service Ltd.
Office: +44 (0) 1276 41 4752 Mobile: +44 (0) 7881 818 867 Fax: +44 (0) 1276 41 4777 email: aurora_dellanno@candle.com
1 Archipelago Lyon Way Frimley Camberley Surrey GU16 7ER UK [...]
301 43 47_Re: Large VSAM extended datasets/ SMS dataclass15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Mon, 30 Apr 2001 10:18:45 +1000404_- James,
Off on a tangent here, but what would do the mangling to get names >8 characters to end in a '$'? TS names can only be <=8 chars, while IX names can be longer but have a randomly scrambled 4th qualifier (as close to the original as possible) if the resultant DS name is already used. Don't mean to teach you how to suck eggs (I believe is the Americanism) but you've got me curious. [...]
345 77 38_Re: DB2 SP WLM application environment18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Mon, 30 Apr 2001 10:28:48 +0930591_us-ascii Howzit Barbara?
We have implemented the following startegy to minimise administration overhead but allow flexibility to support any stored procedure development needs:
Proc STC Description db2ssnSPAS db2ssnSPAS DB2 managed stored procedure address space
DB2SP0 db2ssnSP0 Default stored procedure WLM application environment
DB2SP1 db2ssnSP1 APF stored procedure WLM application environment eg DSNUTILS
DB2SPn db2ssnSPn Specialised stored procedure WLM application environment with specific performance, service class, processing, etc. needs. [...]
423 33 39_Re: Image Copy Registration in syscopy.10_Lee Mandel16_DBMSUser@AOL.COM29_Sun, 29 Apr 2001 23:07:20 EDT243_US-ASCII Michael, I understand what you are saying. But can I create a record in the syscopy of an Image Copy without executing the Image Copy Utility. I would like to manually create this entry with the image copy dsname, Timestamp, etc. Lee.
457 15 50_Michael Shaughnessy/RICH/FRS is out of the office.0_32_Michael.Shaughnessy@RICH.FRB.ORG31_Mon, 30 Apr 2001 01:02:04 -0400389_us-ascii I will be out of the office starting 04/27/2001 and will not return until 05/01/2001.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
473 44 31_Re: DB2 connect & shadow tables0_15_leon@CA.IBM.COM31_Mon, 30 Apr 2001 01:23:37 -0400390_us-ascii Thsi problem will appear on certain maintenance levels of DB2 for OS/390. We have a fix for this and we are testing it. We should be able to release it very soon (a few days).
Leon Katsnelson Product Manager, DB2 Application Development and DB2 Connect mailto:leon@ca.ibm.com
Marcelo Silveira @RYCI.COM> on 04/27/2001 10:50:19 PM [...]
518 27 53_Ganesh Seetharaman/gseeth1/DFSI is out of the office.18_Ganesh Seetharaman39_ganeshseetharaman@DISCOVERFINANCIAL.COM31_Mon, 30 Apr 2001 01:02:55 -0500348_us-ascii I will be out of the office starting 04/30/2001 and will not return until 05/07/2001.
I will be out of Office from 04/30/01 to 05/04/01.
In case of Emergency or On site Issues, you can contact Concerned Secondary DBA's :
Jang Lee x1281 - Debt Manager/ Collections Atwal Sukhmel X1190 - NCS Raimond X3561 - Falcon [...]
546 76 47_Re: Large VSAM extended datasets/ SMS dataclass14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 30 Apr 2001 01:48:35 -0500412_- Raymondo
1) If you use CREATE TABLE xxxxxxxxxxxxxxxxxx IN DATABASE yyyyyyyy, then the generated tablespace name will be a mangle of the table name.
If you - create an index named, say, ALONGINDEXNAME, this will be mangled to create the qualifier, perhaps, ALON1DWQ - if you now try to create a tablespace named ALON1DWQ, this will have to be mangled because the qualifier is already in use. [...]
623 25 39_Re: Image Copy Registration in syscopy.14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 30 Apr 2001 01:59:13 -0500524_- If you are desperate to do this there is a DSNZPARM flag that makes the catalog (but not directory) updateable via SQL. USE AT YOUR OWN RISK.
/* standard disclaimer */ James Campbell
On Sun, 29 Apr 2001 23:07:20 EDT, Lee Mandel wrote:
>Michael, >I understand what you are saying. But can I create a record in the syscopy >of an Image Copy without executing the Image Copy Utility. I would like to >manually create this entry with the image copy dsname, Timestamp, etc. >Lee. > [...]
649 111 19_Mangled space names15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Mon, 30 Apr 2001 17:45:48 +1000372_- James,
I had a think about your original post. I got the impression (incorrectly, I'm assuming) that you were saying mangled qualifier names ended in $. Patently not the case, which is why I asked. Good spot on the mangled (you know, I'm really getting to like that word) TS names. Not that anyone would create a table without giving a TS name, of course... [...]
761 139 47_Re: Large VSAM extended datasets/ SMS dataclass9_Ray Price18_Ray.Price@DRKW.COM31_Mon, 30 Apr 2001 09:01:13 +0100294_iso-8859-1 Hi James.
This is interesting. I recently had a CREATE TABLESPACE fail because DB2 had used the same name as the "mangled" version of an index name. I had to drop and recreate the index so it got another "mangled" name. Is this a recent change to DB2? We are running V5. [...]
901 38 35_Re: JCL for running SPUFI in Batch.18_Michael J. O'Neill29_mike.oneill@CUSTOMS.TREAS.GOV31_Mon, 30 Apr 2001 06:13:53 -0500490_US-ASCII //SPUFI EXEC PGM=IKJEFT1B,REGION=4M,DYNAMNBR=50 //SYSTSPRT DD DUMMY //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(DVAB) RUN PROGRAM(DSNTEP2) PLAN(DSNTEP61) - LIB('DB2.RUNLIB.LOAD') //SYSIN DD * your SQL goes here
______________________________ Reply Separator _________________________________ Subject: JCL for running SPUFI in Batch. Author: "DB2 Data Base Discussion List" at smtplink Date: 4/28/01 10:21 AM [...]
940 57 82_June 6th-7th - Central PA User Group - Bonnie Baker - EXPLAIN Explained & Things I10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Mon, 30 Apr 2001 07:05:48 -0400277_us-ascii Hi everyone! Since we can't get enough of a good thing, we're having Bonnie Baker come back to teach 2 days of classes in June. Not only is Bonnie coming back to teach Part III of her Series, but she's also teaching a class on helping to read DB2 EXPLAIN output. [...]
998 172 36_Re: CPU Utilization on FETCH Command16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Mon, 30 Apr 2001 07:29:24 -0400491_us-ascii Terry, Thanks for the correction. As taken from the DB2 Admin Guide:
| If no sorts are required, then OPEN CURSOR does not access any data.
| It is at the first fetch that data is returned.
| If a sort is required, then the OPEN CURSOR causes the materialized | result table to be produced. Control returns to the application after | the result table is materialized. If a cursor that requires a sort is | closed and reopened, the sort is performed again. [...]
1171 45 47_Re: DSN3@SGN setup for use of secondary authids15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 30 Apr 2001 06:48:54 -0500414_ISO-8859-1 Thanks, Roger. My colleague was able to get an exit to work with the secondary authids. He did start with the samples that were provided but wasn't sure what to do after that. We are not exactly assembler jockeys over here. Given enough time we could have figured it out, I suppose. Bill Disch sent their version over to us and my colleague was able to figure out what he needed to code from that. [...]
1217 79 35_Re: JCL for running SPUFI in Batch.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 30 Apr 2001 08:31:01 -0400552_iso-8859-1 Install job DSNTEJ1P is a compile/lked/bind for DSNTEP2. DSNTEP2 is 'batch SPUFI'.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Harry William [mailto:NRv893@AOL.COM] Sent: Saturday, April 28, 2001 11:21 AM To: DB2-L@RYCI.COM Subject: JCL for running SPUFI in Batch.
Hi All, I have to run SPUFI to retrieve data over a period of 3 years.If i have to execute it takes considerable amount of time.Is there any JCL to execute the SQL in the back ground. [...]
1297 93 35_Re: DB2 Utilities Evaluation Advice14_Hickman, Mindy29_Mindy.Hickman@DOA.STATE.WI.US31_Mon, 30 Apr 2001 07:32:26 -0500548_ISO-8859-1 I've found with the CDB utilities that the tech support folks usually get me a fix usually within a day or two, sometimes a week. If you are getting that many S0C3's, I would call their tech support and check to see if you have some parms set up wrong. I rarely have any problems and I have some very large tables. As far as ASCII support, I know they will be having a new release coming out early this summer that will provide full ASCII support(the current version handles copies and reorgs) and the new version will also provide [...]
1391 22 48_Re: CA/Platinum P99D - No Bashing - reality/fact9_Colin Fay13_cfay2@CSC.COM31_Mon, 30 Apr 2001 08:56:57 -0400545_us-ascii Hi,
Those interested in viewing an analyst's view of CA might try this link
http://www.nytimes.com/2001/04/29/technology/29COMP.html?searchpv=site01
titled "A Software Company Runs Out of Tricks"
I would be interested in hearing CA's response to the article.
================================================ 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.
1414 27 39_Disaster Recovery W/O copy of SYSUTILX?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Mon, 30 Apr 2001 08:09:09 -0500401_- We are planning to implement CA's Disaster Recovery Strategy, when they have it so all of the jobs will run sucessfully :-(, for our DR procedure. We are having problems getting a copy of SYSUTLIX because there is frequently some utiltities running at the time of our image copy job. Customers have commited to the time slot but don't always honor it due to a shortening batch window at night. [...]
1442 76 8_Triggers17_Panicker, Lethika26_LPanicker@FSSA.STATE.IN.US31_Mon, 30 Apr 2001 08:47:39 -0500706_iso-8859-1 Hi ,
Can someone tell me how I can use my SET CURRENT SQLID while creating a Trigger . I am using SPUFI and the statement delimiter is # . While using my current SQLID I am receiving the following error code:
TIA Lethika
SET CURRENT SQLID='WEADBAFS'; CREATE TRIGGER CASEAUDT AFTER UPDATE OF CASFIPS, CASNUM, CASEFTST, CASEFTSTDT, CASCPNAM, CASCAUSE, CASCOFREQ, CASCOWHAMT, CASCOARAMT ON ISETSD.WEASCASE REFERENCING OLD AS oldtab NEW AS newtab FOR EACH ROW MODE DB2SQL BEGIN ATOMIC INSERT INTO ISETSD.WEAHCASE ( CASTS, CASSEQID, CASFIPS, CASNUM, CASEFTST, CASEFTSTDT, CASCPNAM, CASCAUSE, CASCOFREQ, CASCOWHAMT, CASCOARAMT, CASLCDT, CASLCID ) VALUES ( CURRENT TIMESTAMP, [...]
1519 42 39_Re: Image Copy Registration in syscopy.15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 30 Apr 2001 08:49:09 -0500371_iso-8859-1 Lee,
You can use BMC C+/Modify (which is now part of the COPY PLUS product) to perform a wide range of INSERT, UPDATE and DELETE activity on SYSCOPY records, and it includes checking to try to prevent illegal operations. For example, it won't let you delete a full image copy without also deleting subsequent incremental copies based on that full. [...]
1562 169 36_Re: Access Path Selection Statistics14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Mon, 30 Apr 2001 07:05:12 -0700326_iso-8859-1 Roger,
Thanks for the advise. We are currently on DB2 V5.1 and will be moving to v6 in June 2001. I have been using Graig Mullins "DB2 3rd Edition" & "DB2 High Performance Design & Tuning" which you seem to know about, as a reference. The version 5 manuals have the same information you refer to in v7. [...]
1732 79 39_Re: Image Copy Registration in syscopy.16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 30 Apr 2001 10:06:33 -0400423_iso-8859-1 There is a way since Platinum/CA Quick Copy registers its Image Copies in SYSCOPY. However, it may be an unpleasant way requiring native media manager I/O.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Lee Mandel [mailto:DBMSUser@AOL.COM] Sent: Sunday, April 29, 2001 11:07 PM To: DB2-L@RYCI.COM Subject: Re: Image Copy Registration in syscopy. [...]
1812 61 43_Re: Disaster Recovery W/O copy of SYSUTILX?19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 30 Apr 2001 09:40:08 -0500289_iso-8859-1 Richard, I'm not familiar with the CA, DR method. Can you help out somewhat on the basic method. I would think rolling SYSUTILX as far forward as you can would put you in a position to have the least amount of problems that could then be dealt with.
HTH, Rick Davis [...]
1874 50 26_Using CASE in where clause12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Apr 2001 07:42:00 -0700419_us-ascii One of the application programmers at my client's is trying to build a stored procedure using SPB that passes a couple of variables, NEWVAR and MINIVAR. These variables are used to determine some specific search test conditions and are either 'Y' or 'N'. Currently he has 4 cursors (one for each possible condition) and does some IF checking after declaring the cursors to determine which cursor to open. [...]
1925 116 12_Re: Triggers13_Larry Hubbard29_Larry_Hubbard@CMS.STATE.IL.US31_Mon, 30 Apr 2001 09:32:06 -0500501_us-ascii Lethika,
I believe you need to change your ";" to a "#" as the delimiter to your SET SQLID... statement. Also it appears that your Create Trigger .... statement worked for whatever SQLID you were running under prior to change.
Larry
Larry Hubbard CMS-BCCS-ISD Tel. 217-785-8848 Fax. 217-782-8126
"Panicker, Lethika" To: DB2-L@RYCI.COM Subject: Triggers Sent by: DB2 Data Base Discussion List [...]
2042 87 30_Re: Using CASE in where clause11_David Nance16_DWNance@FHSC.COM31_Mon, 30 Apr 2001 11:37:26 -0400442_US-ASCII Myron, You might want to have him try something along the lines of:
SELECT var1, var2, ... from table1 where cond1 = 'xxxx' and cond2 = 'xxyyy' and (Case WHEN newvar = 'Y' and minivar = 'y' and DTOP.TOPIC_DELETED = 'N' and LDSC.LINE_MAKE_ID ^= 4 THEN 1 WHEN newvar = 'Y' and minivar = 'N' and LDSC.LINE_MAKE_ID in (1,2,3) THEN 1 WHEN newvar = 'N' and minivar = 'N' and LDSC.LINE_MAKE_ID in (1,2,3) THEN 1 ELSE 0 END) = 1 [...]
2130 23 39_Usage of IDENTITY columns - pitfalls ??14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Mon, 30 Apr 2001 11:49:41 -0400351_iso-8859-1 Hi List,
I would like to hear opinions from you, both for and against, including potential future problems, regarding the usage of IDENTITY columns as primary keys in tables in a database. Please assume that the IDENTITY columns are defined as GENERATED BY DEFAULT AS IDENTITY.
Your opinions would be highly appreciated. [...]
2154 104 30_Re: Using CASE in where clause11_Bill Happel22_WRHappel@US.FORTIS.COM31_Mon, 30 Apr 2001 11:03:56 -0500522_US-ASCII I did not think you could use CASE in the WHERE clause. I have always used it in the SELECT clause. In the below example, I would replace CASE WHEN's with ANDs and ORs. For example:
SELECT var1, var2, ... from table1 where cond1 = 'xxxx' and cond2 = 'xxyyy' and ( ( newvar = 'Y' and minivar = 'y' and DTOP.TOPIC_DELETED = 'N' and LDSC.LINE_MAKE_ID ^= 4 ) or ( newvar = 'Y' and minivar = 'N' and LDSC.LINE_MAKE_ID in (1,2,3) ) or ( newvar = 'N' and minivar = 'N' and LDSC.LINE_MAKE_ID in (1,2,3) ) ) ; [...]
2259 60 43_Re: Usage of IDENTITY columns - pitfalls ??19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 30 Apr 2001 11:18:38 -0500523_iso-8859-1 Abhijit, So far I'm for 'em with some reservations I've not had a chance to work on yet. PROs: Hopefully less/no contention getting a PK. Don't have to code up a PK generator/table. IBM handles uniqueness (kinda, see CONs). CONs: LOADing tables (RESUME or REPLACE) with IDENTITY columns GENERATED AS DEFAULT requires more effort. Will need a unique index on the IDENTITY column. Have to fetch assigned PK value via a function (within same UOW) if it will be used in a FK. An alternative would be TIMESTAMP. [...]
2320 16 43_Re: Disaster Recovery W/O copy of SYSUTILX?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Mon, 30 Apr 2001 11:00:24 -0500478_- There method is image copy cat and dir nightly, make copies of logs, BSDS, and archive logs and send offsite. Restore all using JCL built by their product. There is much more detail but I don't need to go into that. It's basically the method for 24X7 DB2 regions. I believe I could restore SYSUTLIX from a good copy and roll forward in the logs to a Point in time, but it may have been days since a good copy, that could take a long time. Hope that answers you question. [...]
2337 27 29_DB2 UDB Container Information14_Adrian Collett27_adriancollett@TISCALINET.IT31_Mon, 30 Apr 2001 18:27:02 +0200573_iso-8859-1 Dear List,
Where does DB2 UDB V7.1 for Win/Unix store information about a Tablespace's Containers ?
I can't find it in the catalog, and would like to get the information without having to use the DB2 List command.
Is this possible ?
Thanks,
Adrian Collett, DB2 Consultant Milan, Italy.
================================================ 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.
2365 20 19_DB2 Connect and RLF11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Apr 2001 09:30:24 -0700306_iso-8859-1 Hi all, It looks like queries coming in from db2 connect bypass the RLF?? No matter how I try to trap the query (authid,plan,lu=public etc) it always runs. If I run the query in TSO, same authid and SQL, the rlimit works as advertised.
How can this be or what am I missing? cliff:-) [...]
2386 133 35_Re: DB2 Utilities Evaluation Advice11_Carl Nelson22_Carl.Nelson@ANTHEM.COM31_Mon, 30 Apr 2001 11:29:21 -0500547_us-ascii We have 5 BMC products supporting OS/390 DB2 (v5) but not necessarily the same products you are looking for. We do have the REORG utility and their advances RUNSTATS functionality. I am the primary user and abuser of their products in our shop. My experience with BMC has been very good. Most of the time they have the fix already in the database and can immediately mail it to your systems program to be applied. Most of their products that we have never need any fixes - maybe one product per year needs a zap. About once a year I [...]
2520 51 23_Re: DB2 Connect and RLF0_19_Tim.Lowe@STPAUL.COM31_Mon, 30 Apr 2001 11:45:57 -0500298_us-ascii Cliff, We have no problems using RLF to govern DB2 connect work. We did encounter a problem once where we were limiting only packages, but not plans with dbrms in them due to the rows in the RLF table. What is specified in your RLF table?
I hope this helps.
Thanks, Tmi [...]
2572 38 23_Re: DB2 Connect and RLF13_Terry McCombs20_tmccomb@SEDGWICK.GOV31_Mon, 30 Apr 2001 11:45:06 -0500447_iso-8859-1 I'm limiting queries coming in from DB2 Connect; I know because I get calls asking me to increase the limit ;). I use the luname and an rlffunc of '2'. My DB2 Connect is still SNA, however, not yet TCP/IP, so could be a different environment.
-----Original Message----- From: Cliff Boley [mailto:Maurice.C.BOLEY@ODOT.STATE.OR.US] Sent: Monday, April 30, 2001 11:30 AM To: DB2-L@RYCI.COM Subject: DB2 Connect and RLF [...]
2611 250 35_Re: DB2 Utilities Evaluation Advice64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Mon, 30 Apr 2001 11:51:45 -0500503_ISO-8859-1 Hi Larry1260 @ yahoo.com
Do you work for Yahoo? We don't have any active trials at Yahoo.
Perhaps I can address some of your concerns and advise you on some points that might help your evaluation.
Since you are a 24X7 shop, and since you are evaluating CDB products, you will be pleased to know that you've made a good choice, since CDB is the only vendor that has true 24X7 support for REORG, COPY and UNLOAD. No other vendor can do this, not IBM, not BMC, not CA. [...]
2862 128 43_Re: Usage of IDENTITY columns - pitfalls ??12_Susan Lawson22_lawson_susan@YAHOO.COM31_Mon, 30 Apr 2001 09:52:45 -0700474_us-ascii Abhijit,
We have been implementing IDENTITY COLUMNS for some time now in several client applications. There are pitfalls and performance issues in the current implementation of these columns.
Richard Yevich and I wrote an article on this that will be in the IDUG Solutions Journal in May....if you want an advanced copy please e-mail me privately. We also have a white paper in the YL&A DB2 Performance Journal detailing experinces with these... [...]
2991 175 35_Re: DB2 Utilities Evaluation Advice16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Mon, 30 Apr 2001 12:56:27 -0400352_us-ascii I concur. We use the BMC utilities as well as other BMC products. With version 6, BMC is still 3 times or more faster than IBM in many situations. They consistenlt remain ahead of the curve with multi-tasking, dynamic allocation, and other bells and whistles that save many man-hours of admin time. BMC support has been excellent for us. [...]
3167 210 48_Re: CA/Platinum P99D - No Bashing - reality/fact11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Apr 2001 09:56:35 -0700437_iso-8859-1 We're pleased with the plat products and I've always found their tech support folks very helpful and prompt. Its unfortunate that we may have to give up the tools because of CA's lease costs. cliff:-(
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Friday, April 27, 2001 9:35 AM To: DB2-L@RYCI.COM Subject: Re: CA/Platinum P99D - No Bashing - reality/fact [...]
3378 104 30_Re: Using CASE in where clause12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Apr 2001 09:59:01 -0700506_us-ascii Thanks David. It works great.
Myron --- David Nance wrote: > Myron, > You might want to have him try something along the lines of: > > SELECT var1, var2, ... from table1 > where cond1 = 'xxxx' > and cond2 = 'xxyyy' > and > (Case WHEN newvar = 'Y' > and minivar = 'y' > and DTOP.TOPIC_DELETED = 'N' > and LDSC.LINE_MAKE_ID ^= 4 > THEN 1 > WHEN newvar = 'Y' > and minivar = 'N' > and LDSC.LINE_MAKE_ID in (1,2,3) > THEN 1 > WHEN newvar = 'N' > and minivar = 'N' > and [...]
3483 106 51_Question: Web Development - accesing DB2/OS390 data9_JANA BONE25_JANA.BONE@TLC.STATE.TX.US31_Mon, 30 Apr 2001 11:02:13 -0500334_US-ASCII Our applications development staff is currently looking into trends in Web development and they are trying to decide how to retool. They are currently big into MS Visual Basic. They want to use the Web to develop more internal applications. So, we are wondering what are people are using and what are their experiences? [...]
3590 66 23_Re: DB2 Connect and RLF0_19_csutfin@AMSOUTH.COM31_Mon, 30 Apr 2001 12:14:42 -0500376_us-ascii Cliff
I have this working in DB2 V5.
ASUTIME is non zero LUNAME = name from VTAM RLFFUNC = 2 RLFCOLLN, RLFPKG, AUTHID and PLANNAME are blank.
I have the LU name because I am trying to limlit only one LU but have multiple LU's connected.
Hope this helps
Carol Sutfin Corporate DBA AmSouth Bank csutfin@amsouth.com (205)326-5214 [...]
3657 42 34_'Commit on Return Yes' lives again12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Mon, 30 Apr 2001 13:15:51 -0400405_us-ascii Folks, Thought the following, prepared by a colleague, might be of interest to the list; maybe others have encountered a similar problem and developed an alternative solution, or maybe we are just doing something "non-standard" - couldn't find any specific discussion of this problem in the literature.
Comments?
Gregg Sawyer
Subject: 'Commit on Return Yes' lives again [...]
3700 24 30_Help on REORG of tables spaces23_Vivekananthan Ettiappan18_vivdb2@HOTMAIL.COM31_Mon, 30 Apr 2001 18:23:35 +0100452_- Hello group,
When you do a re-org of tablespaces, what are all the follow up activities to be completed?. We did a re-org of a tablespaces, which has only one table?... One of our program which uses the table has been running for more than 6 hours after re-org, which normally takes two hours. I was wondering whether we missed any of the activities to be carried out before and after re-org. Your suggesstion will be highly appreciated. [...]
3725 35 23_Re: DB2 Connect and RLF13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Mon, 30 Apr 2001 12:26:20 -0500512_iso-8859-1 Cliff,
Try RLFCOLLN=NULLID, LUNAME=PUBLIC, RLFFUNC=2
Dave -----Original Message----- From: Cliff Boley [mailto:Maurice.C.BOLEY@ODOT.STATE.OR.US] Sent: Monday, April 30, 2001 11:30 AM To: DB2-L@RYCI.COM Subject: DB2 Connect and RLF
Hi all, It looks like queries coming in from db2 connect bypass the RLF?? No matter how I try to trap the query (authid,plan,lu=public etc) it always runs. If I run the query in TSO, same authid and SQL, the rlimit works as advertised. [...]
3761 41 34_Re: Help on REORG of tables spaces11_David Nance16_DWNance@FHSC.COM31_Mon, 30 Apr 2001 13:45:57 -0400615_US-ASCII Did you update the runstats, and rebind the programs using those tablespaces? You may have changed the access path for that particular program and have to play with it a little to get a better path.
Dave Nance First Health Services, Corp. (804)527-6841
>>> vivdb2@HOTMAIL.COM 04/30/01 01:23PM >>> Hello group,
When you do a re-org of tablespaces, what are all the follow up activities to be completed?. We did a re-org of a tablespaces, which has only one table?... One of our program which uses the table has been running for more than 6 hours after re-org, which normally takes [...]
3803 47 34_Re: Help on REORG of tables spaces16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 30 Apr 2001 13:45:07 -0400703_us-ascii Hi, runstats before image copy after. HTH Tom
Vivekananthan Ettiappan on 04/30/2001 01:23:35 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Help on REORG of tables spaces
Hello group,
When you do a re-org of tablespaces, what are all the follow up activities to be completed?. We did a re-org of a tablespaces, which has only one table?... One of our program which uses the table has been running for more than 6 hours after re-org, which normally takes two hours. I was wondering whether we missed any of [...]
3851 42 48_Re: CA/Platinum P99D - No Bashing - reality/fact11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Apr 2001 11:06:47 -0700407_iso-8859-1 Interesting article. Looks like now would be a good opportunity to start a competing software business. Tech staff is available since CA canned them and they're creating new customers every day. cliff:-)
-----Original Message----- From: Colin Fay [mailto:cfay2@CSC.COM] Sent: Monday, April 30, 2001 5:57 AM To: DB2-L@RYCI.COM Subject: Re: CA/Platinum P99D - No Bashing - reality/fact [...]
3894 60 23_Re: DB2 Connect and RLF11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Mon, 30 Apr 2001 11:18:54 -0700504_iso-8859-1 Dave, that worked thanks. I still don't know why my other attempts failed. I was using examples from the Admin guide. I tried LUNAME=PUBLIC, AUTHID=(blank), PLANNAME=(blank), RLFFUNC=(blank) ASUTIME=0 via Command Center and TCPIP. I also tried using specific AUTHIDs, Plans and packages. ?? cliff:-)
-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: Monday, April 30, 2001 10:26 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect and RLF [...]
3955 63 14_Declarative RI11_James Drewe20_James.Drewe@AEXP.COM31_Mon, 30 Apr 2001 10:34:06 -0700585_us-ascii Walter
On the system I designed, I are not using declarative RI. Instead, we are using programmatic RI. Some believe that this is risky. For the most part, I agree with them -- unless you understand the risk.
The biggest problem with programmatic RI is the end user being able to bypass the program and perform an ad hoc update that violates RI rules. The next biggest problem is an application program that performs updates in violation of the RI rules. The last problem deals with the DBA. Hopefully, the DBA is aware of the issues in backup and recovery [...]
4019 232 19_Re: from IMS to DB216_Peddycoart, Judy22_peddycoa@UILLINOIS.EDU31_Mon, 30 Apr 2001 13:23:19 -0500402_iso-8859-1 The vendor we used was out of Fort Wayne, Indiana, here in the States. The name was Business Information Systems (shortened to 'BIS'), but I don't know if they're still in business or not. If you can't find them, I may be able to contact some colleagues that would have more information. I'm not sure the tool had a formal name; we referred to the programs as having been "biss-ified". [...]
4252 40 33_regarding SET host-variables.....17_ravi kumar hassan18_ravibh@HOTMAIL.COM31_Mon, 30 Apr 2001 13:19:59 -0500428_- Hi Folks,
We are using DB2 V6, on os390. i have a doubt on SET host-variable syntax. can i use series of variables to set for one set command in cobol db2 application prog.
EXAMPLE:
EXEC SQL SET :XTIME = CURRENT TIME :XDATE = CURRENT DATE :XTIMESTAMP = CURRENT TIMESTAMP END EXEC
is this is ok or do i need to use only one host variable to set like EXEC SQL SET :XTIME = CURRENT TIME END EXEC [...]
4293 48 48_Re: CA/Platinum P99D - No Bashing - reality/fact0_22_BILL_GALLAGHER@PHL.COM31_Mon, 30 Apr 2001 14:39:41 -0400334_us-ascii I wish my shop could be "unfortunate" enough to give up the CA tools. We became victim's of CA's "Rescue" program about a year ago, but I've felt more like a hostage since then.
"I want my BMC" (sung to the tune of Dire Strait's "Money For Nothing")
Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083 [...]
4342 63 23_Re: DB2 Connect and RLF0_17_sjvagnier@AEP.COM31_Mon, 30 Apr 2001 14:41:33 -0400589_us-ascii Hello Cliff, I had a similar problem. Try specifying luname = PUBLIC and rlffunc = 2. You will have to stop/start RLIMIT after making the change.
Regards...
***************************************** Steve Vagnier Principal IT Systems Administrator American Electric Power Shared Services One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-223-3677
Cliff Boley cc: Sent by: DB2 Data Base Subject: DB2 Connect and RLF Discussion List [...]
4406 62 48_Re: CA/Platinum P99D - No Bashing - reality/fact23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Mon, 30 Apr 2001 15:02:17 -0400554_iso-8859-1 I read the article and it merely outlines a practice followed by all the software vendors in the industry. Its called the "residual value" model of reporting earning. It is done by almost all s/w companies due to poorly defined GAAP standards for software revenue recognition in the past? Wall Street's near-sighted focus on quarterly results and the lack of a well-defined SEC regulation defining software revenue recognition policies encouraged all software companies to take advantage, and most did (just like CA). CA isn't the first. [...]
4469 51 43_Re: Disaster Recovery W/O copy of SYSUTILX?19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 30 Apr 2001 14:23:54 -0500399_iso-8859-1 In that case I'll stick with my original statement; try to roll SYSUTILX as far forward as you can. If you're image copying daily this shouldn't be too much problem (given no fallback processing during recovery and the archives on DASD). This way you will at least be aware of any utility jobs that were running at the time and be able to better handle dealing with them if need be. [...]
4521 38 34_Upgrade CA DB2 Tools: P97G to P99D0_22_BILL_GALLAGHER@PHL.COM31_Mon, 30 Apr 2001 15:30:44 -0400324_us-ascii Hello list,
I'm in the process of trying to upgrade our set of CA DB2 tools from the P97G tape to the P99D tape. After the recent threads that many of you have posted over the past week, I'm trying to be a little more cautious in my upgrade since the general consensus seems to be "it isn't that easy". [...]
4560 70 37_Re: regarding SET host-variables.....14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 30 Apr 2001 13:02:02 -0700524_us-ascii EXEC SQL SET (:XTIME, :XDATE, :XTIMESTAMP) = (CURRENT TIME, CURRENT DATE, CURRENT TIMESTAMP)
--- ravi kumar hassan wrote: > Hi Folks, > > We are using DB2 V6, on os390. i have a doubt on SET host-variable > syntax. > can i use series of variables to set for one set command in cobol > db2 > application prog. > > EXAMPLE: > EXEC SQL > SET :XTIME = CURRENT TIME > :XDATE = CURRENT DATE > :XTIMESTAMP = CURRENT TIMESTAMP > END EXEC > > is this is ok or do i need to use only one host [...]
4631 60 48_Re: CA/Platinum P99D - No Bashing - reality/fact15_Donna O'Connell26_donna.oconnell@SAFEWAY.COM31_Mon, 30 Apr 2001 13:26:43 -0700639_us-ascii Quest Central hired many of the former Platinum employees. They opened a development site in Chicago. Quest is offering competing products. They do not have all the functionality of the old Platinum products; but Quests is adding more functions with each new release of their products.
Cliff Boley wrote:
> Interesting article. > Looks like now would be a good opportunity to start a competing software > business. > Tech staff is available since CA canned them and they're creating new > customers > every day. > cliff:-) > > -----Original Message----- > From: Colin Fay [mailto:cfay2@CSC.COM] > Sent: Monday, [...]
4692 88 38_Re: Upgrade CA DB2 Tools: P97G to P99D0_19_csutfin@AMSOUTH.COM31_Mon, 30 Apr 2001 15:29:20 -0500531_us-ascii Bill I did my upgrade from P97G to P99D in the same subsystem using the same database and did run into problems, Fortunately I did this in our "Install" DB2 subsystem so the only I hurt was myself.
My biggest problem now is when I startup the Clist I need to remember to check to see which DB2 subsystem I am pointing to. We run our test and install subsystems on the same lpar so my TSO profile for CA/Platinum is set to the last subsystem regardless of which clist I use. If I am using the wrong subsystem I [...]
4781 70 35_Re: DB2 Utilities Evaluation Advice5_Larry19_larry1260@YAHOO.COM31_Mon, 30 Apr 2001 13:48:44 -0700533_us-ascii Thank you all for your replies on and offline. They have been most helpful.
Now, Todd, to address your concerns.
First, obviously I do not work for Yahoo. The reason I used my Yahoo account is that I met a DBA at a DB2 User Group who had answered a question on the list-server about CDB products. He felt he had answered it factually. He was called into his office by his boss because somebody named Jay Hadley(spelling?) from CDB Software had called his boss and stated that this DBA was slandering CDB. [...]
4852 33 18_Re: Declarative RI14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Mon, 30 Apr 2001 16:04:36 -0500309_iso-8859-1 James,
Regarding what you said: > "My applications are doing heavy "child" > insert activity with the same parent. Declarative RI will continue to > check for the existence of the parent for each child insert. In my case, > that would be like a speed boat having to drag a boat anchor. [...]
4886 84 38_Re: Upgrade CA DB2 Tools: P97G to P99D10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Mon, 30 Apr 2001 16:13:45 -0500371_us-ascii Bill,
We did the install that way for the 99C tape so we can drop the PTDB database and create a new one, freeing all the old plans & packages and cleaning the rest of the extra stuff up along the way was the reason we decided to do it that way. Platinum's cleanup process has always been almost entirely manual, so we decided to do it the easy way. [...]
4971 87 35_Re: DB2 Utilities Evaluation Advice14_Shelton, Glenn21_Glenn_Shelton@BMC.COM31_Mon, 30 Apr 2001 16:11:37 -0500413_iso-8859-1 Do you have Todd's original response, I just joined the listserv today so I don't have the history.
Regards, Glenn
-----Original Message----- From: Larry [mailto:larry1260@YAHOO.COM] Sent: Monday, April 30, 2001 3:49 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Utilities Evaluation Advice
Thank you all for your replies on and offline. They have been most helpful. [...]
5059 98 35_Re: DB2 Utilities Evaluation Advice15_Murley, Michael22_Michael_Murley@BMC.COM31_Mon, 30 Apr 2001 16:23:23 -0500448_iso-8859-1 Larry,
I know that you asked for customer responses instead of ISV commercials, but your post seems to suggest that the BMC utilities support LOBs, and I thought it was important that you have accurate information to make your decision. Those products do not support LOBs (BLOBs, CLOBs etc) at this time. The next version of COPY PLUS (planned GA end of May) will support LOBs, but only if the DB2 Copy Utility is available. [...]
5158 13 36_Transfer data between Oracle and DB20_29_WilliamsByron@RUSSELLCORP.COM31_Mon, 30 Apr 2001 16:26:05 -0500352_ISO-8859-1 What is the best way to transfer data between DB2 v5 running on os/390 and Oracle running on NT v4?
================================================ 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.
5172 91 38_Re: Upgrade CA DB2 Tools: P97G to P99D0_19_Tim.Lowe@STPAUL.COM31_Mon, 30 Apr 2001 16:58:37 -0500540_us-ascii Bill, When we installed P99E here a few months ago, I used different plans and different collection names, sharing the same database as you suggest. (sorry, I don't remember what release we were at before) It took quite a bit more time, but I was able to test rolling back to the old version without a major problem. The biggest database change was the change to the PTGL400_RESTART table, moving it to the 32K bufferpool in order to expand the GLRS_DATA column to varchar(32619). But, this did not effect the my old release. [...]
5264 160 47_Re: Large VSAM extended datasets/ SMS dataclass14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 30 Apr 2001 16:34:16 -0500419_- Ah well, that's what happens when you don't have a system to actually check your ravings against. As I lay in bed last night I realised that, of course, my second item was untrue - because, unlike indexes (where there is a separate column for the qualifier's name), for tablespaces the tablespace name is used as the qualifier - which is one of the things that will have to change for 128 byte tablespace names. [...]
5425 96 63_Re: (fix solution) CA/Platinum P99D - No Bashing - reality/fact5_chris22_hhardy1@HOUSTON.RR.COM31_Mon, 30 Apr 2001 17:07:08 -0500477_iso-8859-1 this process needs to be fixed... no marketing for competing components or dropping salt on anyone.....
this is an issues with quality, delivery and responsiveness and they the particular vendor must come through.....
----- Original Message ----- From: "Donna O'Connell" Newsgroups: bit.listserv.db2-l To: Sent: Monday, April 30, 2001 3:26 PM Subject: Re: CA/Platinum P99D - No Bashing - reality/fact [...]
5522 59 37_Re: regarding SET host-variables.....13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Mon, 30 Apr 2001 16:04:27 -0600417_iso-8859-1 The systax diagram in my hardcopy manual says you can do it the way you coded if you put a comma between the items.
SET :XTIME = CURRENT TIME , :XDATE = CURRENT DATE , :XTIMESTAMP = CURRENT TIMESTAMP
-----Original Message----- From: ravi kumar hassan [mailto:ravibh@HOTMAIL.COM] Sent: Monday, April 30, 2001 12:20 PM To: DB2-L@RYCI.COM Subject: [DB2-L] regarding SET host-variables..... [...]
5582 35 21_Update statement help15_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Mon, 30 Apr 2001 15:04:10 -0700438_- Is there a way to issue a update statement that refers back to itself? We are getting this data from an outside firm and the "name" keeps changing month to month. The table has the following columns:
shipto Integer name CHAR(35) incentive_date DATE amount DEC(12,2)
What I would like to do is take the most recent "incentive_date" for each "shipto", take that "name" and update all of the "shipto"s with this "name". [...]
5618 13 46_Demetris Kasheris/LT/CPB is out of the office.17_Demetris Kasheris19_DKasheris@LAIKI.COM30_Tue, 1 May 2001 01:00:21 +0300336_us-ascii I will be out of the office starting 30/04/2001 and will not return until 02/05/2001.
================================================ 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.
5632 123 33_Re: DB2 UDB Container Information14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 30 Apr 2001 15:24:35 -0700425_iso-8859-1 Adrian, The infomation listed by the List tablespaces containers show detail command is available via API calls. Look at the Administrative API Reference manual. In particular, look at the sqlbotcq, sqlbftcq and sqlbctcq (Open, Fetch Close Tablespace container query) functions. Hope this helps. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
5756 124 33_Re: DB2 UDB Container Information14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Mon, 30 Apr 2001 15:24:35 -0700425_iso-8859-1 Adrian, The infomation listed by the List tablespaces containers show detail command is available via API calls. Look at the Administrative API Reference manual. In particular, look at the sqlbotcq, sqlbftcq and sqlbctcq (Open, Fetch Close Tablespace container query) functions. Hope this helps. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
5881 174 38_Re: Upgrade CA DB2 Tools: P97G to P99D12_Steve Howell23_HOWELLS@STGEORGE.COM.AU30_Tue, 1 May 2001 08:48:30 +1000485_us-ascii Hi Bill,
You should be aware that the procedure for adding the P99D products to an ISPF menu has changed. The command is now something like this
'CMD(%RSPMAIN HIGHLVL(highlvl) PARMLIB(highlvl.parmlib) SUFFIX(nn)' instead of 'CMD(%RSPMAIN)' that is used in P97G.
We have upgraded development to P99D using the standard Upgrade process and have had only a few problems. All issues so far were resolved in less than 24 hours by CA support staff [...]
6056 176 38_Re: Upgrade CA DB2 Tools: P97G to P99D12_Steve Howell23_HOWELLS@STGEORGE.COM.AU30_Tue, 1 May 2001 08:48:30 +1000485_us-ascii Hi Bill,
You should be aware that the procedure for adding the P99D products to an ISPF menu has changed. The command is now something like this
'CMD(%RSPMAIN HIGHLVL(highlvl) PARMLIB(highlvl.parmlib) SUFFIX(nn)' instead of 'CMD(%RSPMAIN)' that is used in P97G.
We have upgraded development to P99D using the standard Upgrade process and have had only a few problems. All issues so far were resolved in less than 24 hours by CA support staff [...]
6233 46 35_Re: DB2 Utilities Evaluation Advice64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Mon, 30 Apr 2001 18:00:13 -0500520_ISO-8859-1 Larry,
I went back and checked with the actual developers, and you are correct, I was given bad information and I did misspeak regarding CDB's support for non-EBCDIC and non-ASCII CCSIDs. Apparently, non-ASCII and non-EBCDIC CCSIDs are not supported, and no error message is produced if you attempt to LOAD with any of the other CCSIDs. I have opened an internal problem report for this blatant and inexcusable bug. Perhaps this is the reason for your ABENDS. The LOGPDS members should show this. [...]
6280 64 25_Re: Update statement help11_David Nance16_DWNance@FHSC.COM31_Mon, 30 Apr 2001 19:03:08 -0400378_US-ASCII Dave, You cannot refer to the same table within a set clause. We have a similar process, what we are currently doing is using a global temporary table, Insert into global select * from table1;
update table1 set col = (select col from global where ....) where ....
Hope this helps.
Dave Nance First Health Services, Corp. (804)527-6841 [...]
6345 36 40_Re: Transfer data between Oracle and DB214_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Mon, 30 Apr 2001 20:34:30 -0400664_iso-8859-1 You could unload from OS390 in CSV format (which might take some engineering) and use sqlloader to put it in Oracle.
Why you'd *want* to do it is another question..... :)
Cheers Greg Palgrave Database Administrator Unisys WEST eMail : greg.palgrave@unisyswest.com.au
> -----Original Message----- > From: DB2 Data Base Discussion List @BANKWEST On > Behalf Of WilliamsByron@RUSSELLCORP.COM@BANKWEST > Sent: Tuesday, 1 May 2001 05:26 > To: DB2-L@RYCI.COM > Subject: Transfer data between Oracle and DB2 > > What is the best way to transfer data between DB2 v5 running on os/390 and > Oracle running on NT v4? > > [...]
6382 57 44_DB2 PM online monitor function abend in ISPF8_Rush Yan14_db2-l@21CN.COM30_Tue, 1 May 2001 12:58:52 +0800695_us-ascii Hello gentle listers,
Pls help me out here:
When I use DB2 PM online monitor function, I got the following message,
1st screen: ISPS118L SERVICE NOT INVOKED. A VALID ISPF ENVIRONMENT DOES NOT EXIST. IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=0C2 REASON CODE=00000002 TIME=21.45.34 SEQ=00024 CPU=0000 ASID=0032 PSW AT TIME OF ERROR 078D2000 8140AC2C ILC 4 INTC 02 NO ACTIVE MODULE FOUND NAME=UNKNOWN DATA AT PSW 0140AC26 - F1F0ACFC 02795080 08FC0580 GPR 0-3 00000014 0006603C 00066180 00062820 GPR 4-7 85E2302C 007AC510 00000000 000627E0 GPR 8-11 8140AC28 0006617C 0006603C 00000000 GPR 12-15 8007D7F8 0007DD08 8007DC88 8140AC28 END OF SYMPTOM DUMP *** [...]
6440 14 51_Michael Armour/GL/KSC/KeyCorp is out of the office.17_Michael T. Armour26_Michael_Armour@KEYBANK.COM30_Tue, 1 May 2001 01:00:42 -0400386_us-ascii I will be out of the office from 04/30/2001 until 05/03/2001.
All questions/concerns should be forwarded to Jim Szabo at 2-5865.
================================================ 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.