1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2001, week 3
2 51 26_Re: SPB & COBOL Generation0_15_leon@CA.IBM.COM31_Sun, 15 Apr 2001 17:39:22 -0400492_us-ascii There are no immediate plans that I am aware of. If this is important to you then I suggest that you submit a requirement through your IBM database specialist or sales rep. This by no means guarantees that your requirement will be addressed but it does enter it in to the system and if there are others who have submitted the same requirement the chances of it being worked on will increase. on the other hand, if you do not ask the chances of it being done are pretty minimal. [...]
54 54 24_Re: Massive Lock Timeout12_rl_cotterill24_rl_cotterill@BIGPOND.COM31_Mon, 16 Apr 2001 10:02:56 +1000428_us-ascii Fernando, Have you got the environmental varaibale DB2_RR_TO_RS=ON, if not set it on it makes a huge difference to the way DB2 does its locking. This varaible is now documented so refer to the documents.
I did a test a number of years ago re the SELECT COUNT(*) and found that if someone had done an update on a non - indexed column and had not released the lock then it would lock out the SELECT COUNT(*). [...]
109 14 49_Peter Faller/HRD/Prudential is out of the office.12_Peter Faller27_peter.faller@PRUDENTIAL.COM31_Mon, 16 Apr 2001 01:12:07 -0400365_us-ascii I will be out of the office from 04/12/2001 until 04/19/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.
124 27 8_SQL4301N14_Hrishiraj Nair28_hrishirajnair@REDIFFMAIL.COM31_Mon, 16 Apr 2001 05:49:57 -0000654_- Hi,
I used to get an SQL4300N error which I resolved by
ln -s /usr/jdk118/lib/linux/native_threads/libjava.so /usr/lib
Now when I try to run the stored procedure sample Outcli.java I get an error SQL4301N.
PLease help Regards Raj
_____________________________________________________ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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.
152 16 47_Kimberlee Little/IT/SEARS is out of the office.10_Kim Little17_klittle@SEARS.COM31_Mon, 16 Apr 2001 01:32:49 -0500498_us-ascii I will be out of the office from 04/16/2001 until 04/17/2001.
I will respond to your message when I return. If an immediate response is necessary, please contact Pam Harris (PHARRI1) or the Logistics DB2 pager at 1-800-759-8888 PIN 7270322.
================================================ 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.
169 19 33_Kevin Davis is out of the office.11_Kevin Davis18_kevin.davis@DB.COM31_Mon, 16 Apr 2001 01:35:48 -0600139_us-ascii I will be out of the office from 04/16/2001 until 04/17/2001.
I will respond to your message when I return.
189 112 33_Re: EXISTS( SELECT 1 vs. SELECT *16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 16 Apr 2001 13:40:21 +0530575_- Terry,
What if there is some stage 2 predicate in the inner query. I hope it make sense what i am trying to say. May be wrong !!
Regards Sanjeev
> -----Original Message----- > From: Terry Purcell [SMTP:Terry_Purcell@YLASSOC.COM] > Sent: Saturday, April 14, 2001 2:25 AM > To: DB2-L@RYCI.COM > Subject: Re: EXISTS( SELECT 1 vs. SELECT * > > DT, > > You must have sent your explain output in an attachment.....and the list > does not allow attachments so we did not receive it. > > Daniel VN, > > There is no discernible difference between SELECT 1 [...]
302 21 19_new DB2 subsubsytem12_Rakesh Kumar21_rakesh457@HOTMAIL.COM31_Mon, 16 Apr 2001 09:36:35 -0000435_- All, In our installation , we would like to add a new DB2 subsystem DSN(X) in production . At present we have one test and one production subsystem.What are the prerequisites to do that apart from having shared libraries ? Anyone ready to help me out.
Regards Rakesh Kumar _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. [...]
324 20 32_storing objects in DB2 database.10_Do Duy Nam19_duynam@RIM-TECH.COM31_Mon, 16 Apr 2001 16:34:06 +0700467_us-ascii Hi all,
Please let me know whether can we store objects (COMponents for example) in the DB2 database. Is it the item: "User Defined Distinct Datatypes" with BLOB datatype?
Thanks in advance.
Nam.
================================================ 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.
345 122 33_Re: EXISTS( SELECT 1 vs. SELECT *13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 16 Apr 2001 05:18:43 -0500563_iso-8859-1 Sanjeev,
If both queries have stage 2 predicates in the WHERE clause of the correlated subquery, then still there is no difference as to whether I code SELECT * or SELECT 1. Both subqueries simply return a TRUE/FALSE.
Hope this answers your question. Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of S, Sanjeev (CTS) Sent: Monday, April 16, 2001 3:10 AM To: DB2-L@RYCI.COM Subject: Re: EXISTS( SELECT 1 vs. SELECT * [...]
468 157 45_Re: dynamic query performance problem with V613_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 16 Apr 2001 05:58:19 -0500480_iso-8859-1 Tina,
Unfortunately the access path looks fine to me, apart from the fact that your workfiles are not sized for this volume of data.
A merge scan join is the most effective join method for a large number of rows. Since there are no predicates which will restrict the number of rows (only value for CLIENT_ID is 1, and not equals predicates generally do little filtering), then I can only assume that majority of the table is retrieved by this query. [...]
626 57 35_Re: Stored Procedure accessing VSAM11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Mon, 16 Apr 2001 06:27:22 -0500
684 46 23_Re: new DB2 subsubsytem12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Mon, 16 Apr 2001 08:02:55 -0400675_us-ascii There is a section in the install guide that addresses adding another subsystem.
Rakesh Kumar @RYCI.COM> on 04/16/2001 05:36:35 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc:
Subject: new DB2 subsubsytem
All, In our installation , we would like to add a new DB2 subsystem DSN(X) in production . At present we have one test and one production subsystem.What are the prerequisites to do that apart from having shared libraries ? Anyone ready to help me out. [...]
731 17 14_PLAN & PACKAGE19_BALAJI Muthukishnan20_MBalaji@COVANSYS.COM31_Mon, 16 Apr 2001 08:30:02 -0400372_- Hi , Can any one help me in giving the clear difference between plan and package.
Thanks & Regards, Balaji Muthukrishnan.
================================================ 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.
749 196 17_Re: Select N rows0_26_JCameron@MSI-INSURANCE.COM31_Mon, 16 Apr 2001 07:34:35 -0500437_iso-8859-1 This works, but if the table is very large it might not be the best ...
select a.columna from tablea a where 10 <= (select count(*) from tablea b where a.columna <= b.columna) order by a.columna
John Cameron JCameron@msi-insurance.com
Terry Purcell cc: Sent by: DB2 Data Subject: Re: Select N rows Base Discussion List [...]
946 56 37_Possible Utility Serializatin Problem14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Mon, 16 Apr 2001 07:42:20 -0500652_us-ascii Hello list,
We had some reorg jobs abend this weekend, and I'm wondering if anyone can give further information....
Here is a snippet from our DB2 log.
-------------------------------------------------------------------------------------------------------------------------- 421 DSNT376I -D2D$ PLAN=DSNUTIL WITH CORRELATION-ID=AVRURW08 CONNECTION-ID=UTILITY LUW-ID=CHEMNET.A0SGD2D$.B5B00DED6A4B=2956 THREAD-INFO=CA7ICOM:*:*:* IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=DSNUTIL WITH CORRELATION-ID=AVRURW10 CONNECTION-ID=UTILITY LUW-ID=CHEMNET.A0SGD2D$.B5AFF53485A1=2899 THREAD-INFO=CA7ICOM:*:*:* ON MEMBER D2D$ [...]
1003 145 33_Re: EXISTS( SELECT 1 vs. SELECT *16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 16 Apr 2001 18:20:09 +0530617_iso-8859-1 Yes, It answered Terry !! I was worried about if DB2 passes column by column information to RDS to evaluate the stage 2 predicate for the inner query. Now i am clear that if EXISTS is specified, DB2 doesn't bother to do that.
Thanks for the clarifications.
Regards Sanjeev
> -----Original Message----- > From: Terry Purcell [SMTP:Terry_Purcell@YLASSOC.COM] > Sent: Monday, April 16, 2001 3:49 PM > To: DB2-L@RYCI.COM > Subject: Re: EXISTS( SELECT 1 vs. SELECT * > > Sanjeev, > > If both queries have stage 2 predicates in the WHERE clause of the > correlated subquery, then still [...]
1149 40 36_Re: storing objects in DB2 database.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 16 Apr 2001 18:23:27 +0530595_- Yes, i believe it can be stored subject to the condition of Versions and platforms. For more informations look at the What's New of the latest versions( 6 and 7)
Regards Sanjeev
> -----Original Message----- > From: Do Duy Nam [SMTP:duynam@RIM-TECH.COM] > Sent: Monday, April 16, 2001 3:04 PM > To: DB2-L@RYCI.COM > Subject: storing objects in DB2 database. > > Hi all, > > Please let me know whether can we store objects (COMponents for example) > in > the DB2 database. Is it the item: > "User Defined Distinct Datatypes" with BLOB datatype? > > Thanks in advance. [...]
1190 41 18_Re: PLAN & PACKAGE16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 16 Apr 2001 18:26:25 +0530316_- The exact difference !!
If package is not used, plan is the executable of your SQLs. If package is used, plan is only the reference to the packages and packages are the real executables.
Rest all are advantages and disadvantages i believe. For all the lists of advantages, go thru' IBM manuals. [...]
1232 29 27_Package vs Stored procedure9_Adi Cohen13_Adi@AYECA.COM31_Mon, 16 Apr 2001 16:07:20 +0200554_US-ASCII Hi All
I have lots of experience working with sql server but no experience at all working with DB2. My boss asked me to learn more about DB2, because we will work with it shortly. I have a question, that might be a very basic one. In SQL server there are no packages at all. The way that we work is with stored procedures. The front end's developers sometimes don't even know how the DB looks like. When we plan the application, we decide on a set of stored procedure with there parameters, and the developers work with those stored [...]
1262 77 36_Re: storing objects in DB2 database.10_Do Duy Nam19_duynam@RIM-TECH.COM31_Mon, 16 Apr 2001 20:13:19 +0700407_us-ascii Can you tell more detail about this? For example how can we manipulate with them, how to store them in the fields/tables etc? Now we have the DB2 UDB v7.1
Best regards,
Nam.
"S, Sanjeev (CTS)" cc: Sent by: DB2 Data Subject: Re: storing objects in DB2 database. Base Discussion List [...]
1340 56 12_Re: SQL4301N19_CHRISTOPHER STARNES14_b05cxs@FDS.COM31_Mon, 16 Apr 2001 09:50:25 -0400607_us-ascii What return code do you get with the SQL4301N message?
Hrishiraj Nair cc: Sent by: DB2 Data Subject: SQL4301N Base Discussion List
04/16/01 01:49 AM Please respond to DB2 Data Base Discussion List
Hi,
I used to get an SQL4300N error which I resolved by
ln -s /usr/jdk118/lib/linux/native_threads/libjava.so /usr/lib
Now when I try to run the stored procedure sample Outcli.java I get an error SQL4301N. [...]
1397 99 36_Re: storing objects in DB2 database.16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 16 Apr 2001 19:38:39 +0530314_- Look at the DB2-L archive for James Campbell e-mail on LOB titled "Regarding LOB" and dated 8th December 2000. This will give you some brief information about this. For more informations in detail, you have to look thru manuals.
I hope your question is --> Is DB2 become ORDBMS ?, the answer is YES. [...]
1497 60 19_Re: database design16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 16 Apr 2001 10:46:38 -0400391_iso-8859-1 Louise, Sounds like what we call 'System Assigned' or SA (I say SA stands for something else!). In a few cases there is no valid natural key so an SA key is required (a Purchase Order number, sequentially assigned, is an example). In most cases there is a valid natural key but some blankety-blank Harvard-trained DA who does not have a clue has chosen to go with an SA key. [...]
1558 17 16_Re: Job in Paris14_William Poston21_william.poston@DB.COM31_Mon, 16 Apr 2001 09:54:40 -0600131_us-ascii Is any one out using IBM DB ADMIN tools for DB2 on OS390 instead of the vender tools i.e. BMC or Platinum?
1576 62 18_Re: PLAN & PACKAGE11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 16 Apr 2001 09:57:30 -0500482_us-ascii PLAN - An executable module containing the access path logic. The executable form of the plan is called a SKELETON CURSOR TABLE. COLLECTION - A DB2 grouping specified for packages. PACKAGE - Optimized SQL from a single program. i.e. A single bound DBRM with optimized access paths.
Imagine a fisherman on a wharf catching fish and putting them in buckets. PLAN = the fisherman (Executable). COLLECTION = the buckets (Non-executable). PACKAGES = the fish (SQL). [...]
1639 105 18_Re: PLAN & PACKAGE13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Mon, 16 Apr 2001 20:34:09 +0530845_us-ascii See the DB2MAG latest issue, it has a lot of info on packages and how you can use it better than plan .
vishy
Jeff Faughn on 16/04/2001 08:27:30 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM
cc: (bcc: Viswanathan N/LTITL)
Subject: Re: PLAN & PACKAGE
PLAN - An executable module containing the access path logic. The executable form of the plan is called a SKELETON CURSOR TABLE. COLLECTION - A DB2 grouping specified for packages. PACKAGE - Optimized SQL from a single program. i.e. A single bound DBRM with optimized access paths. [...]
1745 67 31_Re: Package vs Stored procedure0_15_leon@CA.IBM.COM31_Mon, 16 Apr 2001 11:02:49 -0400516_us-ascii The way you would work with DB2 is exactly the same as the method you are using with MS SQL Server. Define your stored procedures and let the front end application programmers know what the stored procedures are and what parameters they take and return.
Packages is a concept that is most applicable to Embedded SQL programming (well, not exactly but it is good starting point). Your application programmers are not likely to be using Embedded SQL so they will not know anything about packages. [...]
1813 43 31_Re: Package vs Stored procedure13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 16 Apr 2001 11:09:43 -0400626_iso-8859-1 Hello Adi, It's not exactly as you understand it.
I'll try to explain, but I have negligible SQL server experience, so perhaps someone else will translate more effectively.
The Package in DB2 is not an alternative to the Stored Procedure. It is a required component of a stored procedure. When you prepare a DB2 program for execution, 2 things are needed: the executable code (.dll, .exe, load module on OS/390, or other...) and the package (or plan for other types of programs than Stored procedures). Every Stored Procedure will also have a package. Other types of programs also have packages, [...]
1857 55 16_Re: Job in Paris11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Mon, 16 Apr 2001 10:14:57 -0500452_us-ascii We are! And like DB2 ADMIN alot!... : )
William Poston cc: Sent by: DB2 Subject: Re: Job in Paris Data Base Discussion List
04/16/01 10:54 AM Please respond to DB2 Data Base Discussion List
Is any one out using IBM DB ADMIN tools for DB2 on OS390 instead of the vender tools i.e. BMC or Platinum?
1913 76 31_Re: Package vs Stored procedure15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 16 Apr 2001 10:21:02 -0500524_ISO-8859-1 Hi, Dave, I assume that this description is applicable to DB2 as it operates with SQL Server only? Because in the OS/390 environment a package is not necessary for a stored procedure. It is only necessary if you are actually accessing data stored in DB2. If the stored procedure is accessing data elsewhere like in a VSAM data set, then no package is necessary. Also, if the access is through DDF then packages do reside by themselves. They are executed directly by the application and no plans are created. [...]
1990 83 17_Re: New DB2 Tools14_William Poston21_william.poston@DB.COM31_Mon, 16 Apr 2001 10:25:00 -0600508_us-ascii Jeff faughn, How does it compare with BMC and Platinum. Are you using any of the other produces i.e. (Embedded image moved to file: pic07405.pcx)
---------------------------------------- Message History ----------------------------------------
From: Jeff Faughn @RYCI.COM> on 04/16/2001 10:14 AM EST
Please respond to DB2 Data Base Discussion List
DELEGATED - Sent by: DB2 Data Base Discussion List@RYCI.COM> [...]
2074 16 19_Re: database design12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Mon, 16 Apr 2001 10:26:29 -0500369_iso-8859-1 Thanks for all the responses - I won one battle - I am going to redesign the "design" that the highly paid consultant provided on one custom application. The bad news is he worked on the "design" since January and I'm sure I'll have to redesign in a short time frame since according to the schedule the programmers are supposed to be coding now........ [...]
2091 92 16_Trigger Question22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 16 Apr 2001 08:27:33 -0700819_iso-8859-1 Can someone tell me why the Begin Atomic does not work with this statement? I can create this without the Begin Atomic, but when I add it I get the following error.. TIA. This is how the statemet is coded;
CREATE TRIGGER CTS8.CIS03A01 AFTER INSERT ON CTS8.CIS_INVC_TYPE REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL WHEN (N.TYPE_OF_INVC_CD = 'S') BEGIN ATOMIC INSERT INTO CTS8.CIS_INVC_TYPE_S (KEY_NBR, TYPE_OF_BILL_CD, TYPE_OF_INVC_CD, EFF_START_TMST , EFF_END_TMST, INVC_ADDR_CD, HIST_RMKS, CRTE_TMST , CRTE_BY_ID, BIL2_CUST_NBR1, BIL2_CUST_NBR2 , PKUP_CUST_NBR, HOLD_IND) VALUES (N.KEY_NBR, N.TYPE_OF_BILL_CD, N.TYPE_OF_INVC_CD , N.EFF_START_TMST , N.EFF_END_TMST, N.INVC_ADDR_CD, N.HIST_RMKS, N.CRTE_TMST , N.CRTE_BY_ID, N.BIL2_CUST_NBR1, N.BIL2_CUST_NBR2 , N.PKUP_CUST_NBR, N.HOLD_IND); END [...]
2184 202 45_Re: dynamic query performance problem with V611_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Mon, 16 Apr 2001 10:34:45 -0500413_iso-8859-1 I did force a nested loop join, but cancelled it after running almost 3 hours (it only took 50 minutes before). I added more 4K space over the weekend and it's running okay now.
Thanks,
Tina
-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: April 16, 2001 5:58 AM To: DB2-L@RYCI.COM Subject: Re: dynamic query performance problem with V6 [...]
2387 34 36_DB2 TextExtender as Service on Win2K14_Harold Trammel19_hlt@NAPCC.ASPCA.ORG31_Mon, 16 Apr 2001 10:40:19 -0500454_us-ascii I am attempting to run DB2 TextExtender search and scheduling services as Windows 2000 services. Currently I have to open a command prompt on the server, run the "txstart.exe" , and stay logged in. This is not very practical.
I have been attempting to use ServiceMill to add this functionality. I can get the Scheduler (desdem.exe) to run as a service with ServiceMill, but the Search Service (desss.exe) starts and then terminates. [...]
2422 116 59_getting matching columns = 2, should be matching column = 315_Amy C Whitehead14_B06ACW@FDS.COM31_Mon, 16 Apr 2001 11:38:57 -0400452_us-ascii All, I have a tuning question...
I have a query joining 2 tables. The columns on the join predicates are the same data types. I get the expected number of matching columns on A table, but on the second table (C) I get mc=2 instead of mc=3. The second table (C) is joined with 3 columns which are column, 1, 2, 3 in the partitioned, clustered, unique key. The cluster ratio is 99%. Why does DB2 use a MC=2 when a MC=3 is available. [...]
2539 32 31_Re: Package vs Stored procedure13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 16 Apr 2001 13:08:26 -0400396_iso-8859-1 Hi Linda,
You're right about needing a package only if accessing DB2. I should have stated I assumed the S.P. would contain SQL -- obviously not necessarily the case.
Also, I'm not sure about your comment about plans. Or I should say I'm not sure what I said to give you the impression I was talking about plans. -- Perhaps when I used the generic term access plan. [...]
2572 49 31_Re: Package vs Stored procedure15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 16 Apr 2001 12:22:19 -0500531_ISO-8859-1 Thanks for the clarification, Dave. If I substitute "access path" in place of "plans" then your statement makes sense to me.
Linda
-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Monday, April 16, 2001 12:08 PM To: DB2-L@RYCI.COM Subject: Re: Package vs Stored procedure
Hi Linda,
You're right about needing a package only if accessing DB2. I should have stated I assumed the S.P. would contain SQL -- obviously not necessarily the case. [...]
2622 82 41_Re: Possible Utility Serializatin Problem12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 16 Apr 2001 21:31:22 +0200413_iso-8859-1 Hi, DBID=1 => dsndb01 (directory) As for 83 - I don't know (will check tomorrow). Looks like contention on your dsndb01
Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net ----- Original Message ----- From: "Richard Arnold" Newsgroups: bit.listserv.db2-l To: Sent: Monday, April 16, 2001 2:42 PM Subject: Possible Utility Serializatin Problem [...]
2705 21 23_block size for SDSNLOAD12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Mon, 16 Apr 2001 15:31:44 -0400539_us-ascii For years our blocksize for our sdsnload was 6144, now I see some coming out using 32760, What if anything seems the be the excepted normal for 3390 dasd. Stan Goodwin IBM Senior I/T Specialist DECC MBG DB2 Support
Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335
================================================ 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.
2727 57 27_Re: block size for SDSNLOAD13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Mon, 16 Apr 2001 13:23:49 -0700552_iso-8859-1 I do not have the definitive answer, but here's my take on it: The chief consideration in choosing a block size is efficient use of DASD, using the most bytes in the smallest number of blocks per track. 6144 was a good choice for shops that had a mixture of 3330 (2 blocks per 13030 byte track) and 3350 (3 blocks per 19069 byte track) devices. It also did okay for 3380's (24K track size?). 32760 is the largest block size MVS can handle, so when 3390's were introduced (56K tracks) we were finally able to choose that blocksize. That [...]
2785 219 45_Re: dynamic query performance problem with V612_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Mon, 16 Apr 2001 14:50:04 -0500499_iso-8859-1 Pardon my lack of knowledge, but what are the steps to increase the temporary work space? TIA, Louise -----Original Message----- From: Tina Hilton [mailto:Tina.Hilton@BMSUS.COM] Sent: Monday, April 16, 2001 10:35 AM To: DB2-L@RYCI.COM Subject: Re: dynamic query performance problem with V6
I did force a nested loop join, but cancelled it after running almost 3 hours (it only took 50 minutes before). I added more 4K space over the weekend and it's running okay now. [...]
3005 35 27_Re: block size for SDSNLOAD12_Jim Harrison17_jharrison@GMX.NET31_Mon, 16 Apr 2001 16:01:59 -0400477_us-ascii What a coincidence - there's been a long running thread on IBM-Main the past week or so debating load module block size. If you want details, search groups.google.com for those very keywords. The consensus according to the IBM folk there was 32760.
At 03:31 PM 04/16/2001 -0400, Stan Goodwin said: >For years our blocksize for our sdsnload was 6144, now I see some coming >out using 32760, What if anything seems the be the excepted normal for 3390 >dasd. [...]
3041 22 10_Datajoiner15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 16 Apr 2001 17:18:41 -0400374_iso-8859-1 We are looking at some replication tools from DB2 V6 on OS/390 to SQLserver and Oracle. If anybody has any experience on this, can I get some detail like
1. How is the cost of Datajoiner? 2. How is the speed of replication between cross platforms.
Also I would like to know how many companies use this product and what is the opinion about it. [...]
3064 44 14_Re: Datajoiner10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Mon, 16 Apr 2001 16:32:42 -0500591_- Hi Philip, Our shop is trying to replace StarSQL Replication tool with SQLServer DTS (data transformation services) to replicate data from OS/390 DB2 V5 to SQL Server. You may need ODBC driver for DTS to work with DB2. I think you already have it in your shop.
peavy
> ---------- > From: Philip, Sibimon[SMTP:SPhilip@CSXLINES.COM] > Reply To: DB2 Data Base Discussion List > Sent: Monday, April 16, 2001 4:18 PM > To: DB2-L@RYCI.COM > Subject: Datajoiner > > We are looking at some replication tools from DB2 V6 on OS/390 to > SQLserver > and Oracle. If anybody has any [...]
3109 65 14_Re: Datajoiner15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 16 Apr 2001 17:59:08 -0400295_- Peavy,
We have ODBC driver. In DTS I can put some select statement and bring down the data to SQLserver table, but how do I know what data is being changed, deleted and inserted. We have to do lot of compare. I think we can do a data movement with DTS, but not a true replication. [...]
3175 100 27_Re: database design, etc...14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Mon, 16 Apr 2001 20:09:41 -0500322_iso-8859-1 I've certainly noticed this in the client/server world!! I think it stems from the developers being given things like DBADM (db2), or DBO (SQL Server) so that they can "design" *cough, splutter* the tables for themselves. Since they're not DBA's and don't know the DBMS in any detail, you get bad designs. [...]
3276 17 31_Re: Package vs Stored procedure9_Adi Cohen13_Adi@AYECA.COM31_Tue, 17 Apr 2001 07:56:02 +0200330_US-ASCII Hi All
Thank you very much for your help regarding my question.
Adi
===============================================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.
3294 146 63_Re: getting matching columns = 2, should be matching column = 313_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 17 Apr 2001 00:45:30 -0500388_us-ascii Amy,
Since table C is accessed first in the table join sequence, then there are only 2 columns of index BUYLITMC which can be matched as indexable predicates before the join. Thus you receive a matchcols = 2, followed by matchcols = 4 on table A.
Had table A been accessed first then you would have achieved a matchcols = 3, and then matchcols = 3 to table C. [...]
3441 28 53_Ganesh Seetharaman/gseeth1/DFSI is out of the office.18_Ganesh Seetharaman39_ganeshseetharaman@DISCOVERFINANCIAL.COM31_Tue, 17 Apr 2001 01:02:24 -0500368_us-ascii I will be out of the office starting 04/17/2001 and will not return until 04/18/2001.
I will be working from Home tomorrow (04/17/01). You can contact me @847-331-8229. My Working hours will be the same as work (7.00 Am to 11.30 Am & 12.30 Pm to 4.00 Pm).
In case of Emergency or On site Issues, you can contact Concerned Secondary DBA's : [...]
3470 17 35_how to find a key of data using RID7_Soo Lee17_soo7lee@YAHOO.COM31_Tue, 17 Apr 2001 04:29:18 -0500392_- Hi, everyone..
I want to know how to find a key of data using RID . It's DB2 for OS/390 V5 system. please help me...
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.
3488 79 26_Unstable SERVICE WAIT TIME5_Pearl17_panidak@SCB.CO.TH31_Tue, 17 Apr 2001 17:22:41 +0700576_windows-874 Hi List, We test one Application Program that used CICS (COBOL-SQL) and DB2 V5.1 on OS/390. We test same transaction 10 times and used Omegamon for DB2 to monitor event. We found that one time (not first time) it have high Service Wait Time (0.45 Sec).While others time it have stable high service wait time (0.009 Sec).We observe high service wait time will occur in program that have WRITE activity only. We check all DB2 VSAM file that may entended but we don't found. We see DB2 VSAM file already open because we define tablespace CLOSE NO. So, We assume [...]
3568 38 39_Re: how to find a key of data using RID16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 17 Apr 2001 16:18:11 +0530527_- For finding out the rows for RID, you have to take the DSN1PRNT (with PRINT option) for the page which is identified by RID only and then locate the record from the output.
HTH Regards Sanjeev
> -----Original Message----- > From: Soo Lee [SMTP:soo7lee@YAHOO.COM] > Sent: Tuesday, April 17, 2001 2:59 PM > To: DB2-L@RYCI.COM > Subject: how to find a key of data using RID > > Hi, everyone.. > > > I want to know how to find a key of data using RID . > It's DB2 for OS/390 V5 system. > please help me... > > [...]
3607 52 23_Maximum Blob field size20_Yasas Mallawarachchi14_yasas@SLIIT.LK31_Tue, 17 Apr 2001 16:58:01 +0600250_windows-874 Hi All,
I am using DB2 database in our AS/400 using client access for NT. I get an error when I try to store an image file with 1MB of size saying invalid blob length. Is there a limitation in BLOB field size?
Yashas
3660 41 30_Re: Unstable SERVICE WAIT TIME16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 17 Apr 2001 16:30:52 +0530604_- Pearl,
It seems you explained everything. Now let's look at the DB2 PM accounting report(LONG). It should be able to say exactly what the problem is.
Regards Sanjeev
> -----Original Message----- > From: Pearl [SMTP:panidak@SCB.CO.TH] > Sent: Tuesday, April 17, 2001 3:53 PM > To: DB2-L@RYCI.COM > Subject: Unstable SERVICE WAIT TIME > > Hi List, > We test one Application Program that used CICS (COBOL-SQL) and DB2 > V5.1 on OS/390. We test same transaction 10 times and used Omegamon for > DB2 to monitor event. We found that one time (not first time) it have high > Service [...]
3702 243 45_Re: dynamic query performance problem with V611_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Tue, 17 Apr 2001 07:15:47 -0500412_iso-8859-1 1. Define the new VSAM file(s). 2. Stop DSNDB07. 3. Create new tablespace(s) in DSNDB07. 4. Start DSNDB07.
Of course, you'll want to do steps 2-4 when there's no activity in the system.
Tina
-----Original Message----- From: Reid, Louise [mailto:ReidL@CI.FORT-WORTH.TX.US] Sent: April 16, 2001 2:50 PM To: DB2-L@RYCI.COM Subject: Re: dynamic query performance problem with V6 [...]
3946 91 41_Re: Possible Utility Serializatin Problem19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 17 Apr 2001 07:28:12 -0500606_iso-8859-1 Richard, 83 is SYSUTILX. It appears AVRURW08 timed out because ...W10 was spending extra time in SYSUTILX for some reason. I'd look closer at ...W10 to see what its doing. With the extended time-out used by utilities, it would seem ...W10 was having serious problems.
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 [...]
4038 21 30_Stored Procedures in DB2/LINUX14_Hrishiraj Nair28_hrishirajnair@REDIFFMAIL.COM31_Tue, 17 Apr 2001 12:52:15 -0000368_- How do we write Stored Procedures in DB2 running on a Linux Machine?
I do not see a Stored Procedure Builder for DB2 on Linux, as there is for DB2 on NT.
I am using DB2EE 7.1 on a Suse 6.4 Box.
_____________________________________________________ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com [...]
4060 55 39_Re: how to find a key of data using RID64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Tue, 17 Apr 2001 08:38:36 -0500387_ISO-8859-1 You can use the REPAIR utility:
REPAIR LOCATE tablespace_spec RID X'nnnn' DUMP to dump the row and look at it.
See UGREF. (Utility Guide and Reference)
Todd Burch CDB Software, Inc.
-----Original Message----- From: soo7lee@YAHOO.COM Sent: Tuesday, April 17, 2001 5:07 AM To: DB2-L@RYCI.COM Subject: how to find a key of data using RID [...]
4116 43 30_Re: Unstable SERVICE WAIT TIME0_19_mike.holmans@BT.COM31_Tue, 17 Apr 2001 14:39:50 +0100630_- Of the three causes you've guessed, I would think that the preformat one is the most likely cause.
Mike Holmans BT ISE Database Services mike.holmans@bt.com
This post represents the views of the author and does not necessarily accurately represent the views of BT
> -----Original Message----- > From: Pearl [SMTP:panidak@SCB.CO.TH] > Sent: Tuesday, April 17, 2001 11:23 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] Unstable SERVICE WAIT TIME > > Hi List, > We test one Application Program that used CICS (COBOL-SQL) and DB2 > V5.1 on OS/390. We test same transaction 10 times and used Omegamon for > DB2 [...]
4160 54 34_Re: Stored Procedures in DB2/LINUX19_CHRISTOPHER STARNES14_b05cxs@FDS.COM31_Tue, 17 Apr 2001 09:52:34 -0400537_us-ascii I don't think the SPB is currently available for Linux. You can use the SPB provided with DB2 for NT to develop Java and SQL stored procedures for Linux. The SPB is part of the free download (with restrictions, read the license) of DB2 Developers Edition found at http://www-4.ibm.com/software/data/db2/udb/downloads.
Hrishiraj Nair cc: Sent by: DB2 Data Subject: Stored Procedures in DB2/LINUX Base Discussion List [...]
4215 43 11_Outer Join?11_David Nance16_DWNance@FHSC.COM31_Tue, 17 Apr 2001 10:17:12 -0400526_US-ASCII One of our developers is having some trouble with a query and I was wondering if anyone else has seen the same problem or if we are trying something that we shouldn't be. His requirement is to get data from tableA, matched with tableB, where data may or may not reside in tableB, along with some other data in tableC that may or may not be present(I know not a good idea, but its a month end report). We want to join to tableA, but data from tableC may be null, due to the outer join(see example below). We have [...]
4259 32 30_Re: Unstable SERVICE WAIT TIME10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 17 Apr 2001 16:38:58 +0200375_us-ascii As (I suppose) you are in a test environment it may happen that there are some 'burst' in I/O so it's not so strange a
'random' long wait in active log write: you can detect this via OMEGAMON SMS (if you have it) or some other DASD
monitor with some (realtime) response time monitor. Check if DFW is on. The same for delays due to SYSLGRNX insert [...]
4292 24 62_Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (0) - HELP!!!23_Luis Paulo Soares Dutra31_luispaulo@FABRICADIGITAL.COM.BR31_Tue, 17 Apr 2001 11:48:24 -0300318_iso-8859-1
Hi,
I am trying to access DB2 6.0 with ODBC Data Source, but my application fail. I got this message with the ODBC trace: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (0). My application run well with the DB2 7.0. I need to run my application with DB2 6.0 too... Can anyone help me? [...]
4317 106 15_Re: Outer Join?9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 17 Apr 2001 15:49:45 +0100464_us-ascii Dave, We have hit a similar problem with a full join. IBM recommended we should have the following maintenance on... pq30937 uq37188 (9911) pq35056 uq44724 (0007) pq30956 uq36162 (9911) pq36047 uq43668 (0006) pq37432 uq45753 (0008) pq40956 uq47462 (0010) pq42078 uq47882 (0011) pq42611 uq49127 pq43499 uq51248
Updated our maintenance but still had the problem. This is currently being investigated by IBM developers (problem - 79182,001,866). [...]
4424 62 19_HELP SQLAllocHandle10_Luis Paulo19_lupa@RURALRJ.COM.BR31_Tue, 17 Apr 2001 11:54:20 -0300351_iso-8859-1 Hi,
I am trying to access DB2 6.0 with ODBC Data Source, but my application fail. I got this message with the
ODBC trace: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (0). My application run well with the DB2 7.0.
I need to run my application with DB2 6.0 too...
Can anyone help me?
Tanks a lot, [...]
4487 23 33_Browsing index in both directions16_Sharon Zitterman24_Sharon.Zitterman@TRW.COM31_Tue, 17 Apr 2001 11:14:16 -0400363_US-ASCII Hi all,
Does anyone know if the capability for DB2 to browse in ascending and descending order - without requiring a corresponding index for each - exists? Research done so far does not show evidence that it does at this time, but any information regarding this would be greatly appreciated.
Our shop is currently at DB2 V6, OS390 2.5 [...]
4511 33 33_Quest Central for DB2 V1.1 now GA13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Tue, 17 Apr 2001 09:45:48 -0500338_- Quest Software is glad to announce the genral availability of Quest Central for DB2 V1.1 This release offers support of DB2 OS/390 from the main console and SQL tuning components. You now have the ability to browse objects, run queries, and use the SQL tuning lab for both the OS/390 and UNIX/NT platforms from one common console. [...]
4545 68 41_Re: Possible Utility Serializatin Problem9_Birk, Tim17_BirkT@DIEBOLD.COM31_Tue, 17 Apr 2001 11:38:14 -0400445_iso-8859-1 I believe 1.83 is SYSIBM.SYSUTILX. Being a directory table, you won't find it in SYSIBM.SYSTABLES.
-----Original Message----- From: Richard Arnold [mailto:Richard.Arnold@CHASE.COM] Sent: Monday, April 16, 2001 8:42 AM To: DB2-L@RYCI.COM Subject: Possible Utility Serializatin Problem
Hello list,
We had some reorg jobs abend this weekend, and I'm wondering if anyone can give further information.... [...]
4614 30 27_Selecting from result table23_THOLKAPPIAN Chidambaram21_CTholkap@COVANSYS.COM31_Tue, 17 Apr 2001 11:40:36 -0400426_iso-8859-1 Hi List,
I'm new to DB2. I have used the following type of query many times in Oracle. Can you please tell me how this transforms in DB2.
SELECT a.deptno "Department", a.num_emp/b.total_count "%Employees", a.sal_sum/b.total_sal "%Salary" FROM (SELECT deptno, COUNT(*) num_emp, SUM(SAL) sal_sum FROM scott.emp GROUP BY deptno) a, (SELECT COUNT(*) total_count, SUM(sal) total_sal FROM scott.emp) b [...]
4645 90 38_Re : Browsing index in both directions22_Boubakar Saim Haddache16_bsaim@OTOOBE.COM31_Tue, 17 Apr 2001 18:21:36 +0200645_iso-8859-1 try the "allow reverse scan" in the create index command.
Boubakar
"Sharon Zitterman" a écrit dans le message news: sadc2591.065@resva-gs1.resva.trw.com... > Hi all, > > Does anyone know if the capability for DB2 to browse in ascending and descending order - without requiring a corresponding index for each - exists? Research done so far does not show evidence that it does at this time, but any information regarding this would be greatly appreciated. > > Our shop is currently at DB2 V6, OS390 2.5 > > Thank you > Sharon.Zitterman@trw.com > > To change your subscription options or to [...]
4736 207 63_Re: getting matching columns = 2, should be matching column = 315_Amy C Whitehead14_B06ACW@FDS.COM31_Tue, 17 Apr 2001 12:21:35 -0400329_us-ascii Terry, I do not understand this. I do not have any other predicates on C except the join predicates. Sorry.... I thought I should get MC 3 and 4 without changing the query. Can you explain this more?
I added AND C.PO_LINE_ITM = > 0, and now get the following access path. Isn't this a version 2.x technique? [...]
4944 52 37_Re: Browsing index in both directions19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 17 Apr 2001 11:24:24 -0500600_iso-8859-1 Sharon, Scrollable cursors are available in DB2 for OS390/zOS V7. I don't know if its available on V6 as an APAR yet, or ever.
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, [...]
4997 35 27_Selecting from result table19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US29_Tue, 17 Apr 2001 12:30:16 EDT690_us-ascii Tholkappian
You insert an 'AS'.
e.g.
SELECT a.deptno as "Department", a.num_emp/b.total_count as "%Employees", a.sal_sum/b.total_sal as "%Salary" FROM (SELECT deptno, COUNT(*) num_emp, SUM(SAL) sal_sum FROM scott.emp GROUP BY deptno) a, (SELECT COUNT(*) total_count, SUM(sal) total_sal FROM scott.emp) b
Regards,
Rajeev P. Dhanawade Phone: 302-577-4659 ext. 221 Fax : 302-577-4454
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
5033 50 31_Re: Selecting from result table11_David Nance16_DWNance@FHSC.COM31_Tue, 17 Apr 2001 13:02:47 -0400422_US-ASCII It transforms pretty much as it is, except for coalescing your literals with your columns. Change your " to '. Lastly, convert your numbers to character(you might want to substr to avoid the leading zeroes)
SELECT a.deptno || 'Department', digits(a.num_emp/b.total_count) || '%Employees', digits(a.sal_sum/b.total_sal) || '%Salary'
Dave Nance First Health Services, Corp. (804)527-6841 [...]
5084 39 13_Locks UDB/AIX8_bharat r20_bharat_321@YAHOO.COM31_Tue, 17 Apr 2001 10:13:50 -0700631_us-ascii Hi All I have a small doubt regarding the Lock escalation in the db2diag.log *************************************************** 2001-04-15-14.21.00.029214 Instance:DB2INST1 Node:000 PID:22548(db2agent (DB2INST1)) Appid:D02740F1.055C.010415164923 data_management sqldEscalateLocks Probe:2 Database:SNDPROD
-- Lock Count, Target : 1148, 574 -- Table (ID) Name : (4;4) DB2INST1.ORDER -- Locks, Request Type : 1138, X -- Result (0 = success): 0 ************************************************** Pls explain me what is loc count and what is Locks.. If 1138 is non-table locks why LockEscalation is taking place.. [...]
5124 102 38_Re : Browsing index in both directions0_20_John_Lendman@FPL.COM31_Tue, 17 Apr 2001 13:19:08 -0400375_iso-8859-1 the "allow reverse scan" option does not work for DB2 UDB for OS/390. It only works for DB2 UDB for Windows or Unix.
John Lendman Florida Power and LIght
"Boubakar Saim To: DB2-L@RYCI.COM Haddache" cc: directions Sent by: "DB2 Data Base Discussion List" [...]
5227 46 38_SPUFI from DB2 OS390(V5) to DB2 UDB v615_Robert lawrence21_rlawrence@BOSCOVS.COM31_Tue, 17 Apr 2001 13:41:16 -0400529_iso-8859-1 Hello List, I am trying to bind spufi on DB2 OS390 to be able to access tables on UDB V6 on AIX and am not being successful. The Statements I use are :
DSN SYSTEM(DSNT) <<<==== DB2 OS390 subsystem BIND PACKAGE (INV_MCHT.DSNESPCS)<<<< === remote location and ction - OWNER (TSOSAD1) QUALIFIER (TSOSAD1) - MEMBER(DSNESM68) LIBRARY('DSN510D.SDSNDBRM') - SQLERROR(NOPACKAGE) VALIDATE(RUN) FLAG(I) - ISOLATION(CS) EXPLAIN(NO) - KEEPDYNAMIC(NO) NOREOPT(VARS) - CURRENTDATA(YES) - DEGREE(1) - ACTION(REPLACE) END [...]
5274 194 63_Re: getting matching columns = 2, should be matching column = 312_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Tue, 17 Apr 2001 14:06:07 -0400474_us-ascii My Name Is Not Terry, but if I may have a shot :
The predicate for pre-join selection on C is inferred from the values supplied for the matching (join) columns with A; where you have specified values for A that match columns in C's index BUYLITMC, the pre-join selection can use these index columns. Specifically, you have not specified a predicate value A.PO_LINE_ITM = :H, so the corresponding C.PO_LINE_ITM index cannot be used in the pre-join scan. [...]
5469 89 42_Re: SPUFI from DB2 OS390(V5) to DB2 UDB v615_Stacey L Waters23_WATERSS1@NATIONWIDE.COM31_Tue, 17 Apr 2001 13:07:42 -0500484_us-ascii Bob, Below is the explanation for SQLCODE 4930 on NT/UNIX.
Hope this helps. Stacey
Command To Lookup SQLCODE on NT/UNIX (using a db2 command line) D:\SQLLIB\BIN>db2 ? sql4930
Description Returned SQL4930N Bind or precompile option or option value "" is invalid.
Explanation: Either "" is an invalid bind or precompile option or the value specified for this option is invalid. The bind or precompile cannot continue. [...]
5559 80 42_Re: SPUFI from DB2 OS390(V5) to DB2 UDB v60_23_sjtoeniskoetter@AEP.COM31_Tue, 17 Apr 2001 14:17:19 -0400589_us-ascii The -4930 error is coming from DB2/AIX. Check the Message Reference there. It doesn't appear to like Validate Run.
Robert lawrence To: DB2-L@RYCI.COM Subject: SPUFI from DB2 OS390(V5) to DB2 UDB v6 Sent by: DB2 Data Base Discussion List
04/17/01 01:41 PM Please respond to rlawrence
Hello List, I am trying to bind spufi on DB2 OS390 to be able to access tables on UDB V6 on AIX and am not being successful. The Statements I use are : [...]
5640 28 53_RUNSTATS utility startup time - before utilinit phase12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 17 Apr 2001 21:30:30 +0200501_iso-8859-1 Hi,
Today I encountered something strange: A RUNSTATS job with 800+ runstats command took nearly 40 minutes of elapsed run time before starting to execute the commands, it was not in utilinit phase and nothing showed on the monitor (omegamon) and nothing on -dis util(*). Under TMON for MVS I saw i saw "dsnut510" gobbling time, I tried the same on V6 (different subsystem) and got the same result. If I lower the number of runstats cpmmands to < 100 it works fine (no delays). [...]
5669 69 42_Re: SPUFI from DB2 OS390(V5) to DB2 UDB v614_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Tue, 17 Apr 2001 14:26:54 -0400515_iso-8859-1 Hi Bob:
Its complaining about validate(run)....Following is the BIND statement that worked for me:
BIND PACKAGE(DB2PROD.DSNESPCS) - MEMBER(DSNESM68) - LIB('TS.DSN510.SDSNDBRM') - EXPLAIN(NO) - ACT(REPLACE) - VALIDATE(BIND) - OWNER(TSOOWN) - ISOLATION(CS) - DEGREE(ANY)
Manas.
========================================== Hello List, I am trying to bind spufi on DB2 OS390 to be able to access tables on UDB V6 on AIX and am not being successful. The Statements I use are : [...]
5739 94 42_Re: SPUFI from DB2 OS390(V5) to DB2 UDB v616_Sreedhar Bobbadi24_sbobbadi@DUKE-ENERGY.COM31_Tue, 17 Apr 2001 14:17:59 -0400538_us-ascii Try
DSN SYSTEM(DSNT) BIND PACKAGE (INV_MCHT.DSNESPCS) - QUALIFIER (TSOSAD1) - MEMBER(DSNESM68) LIBRARY('DSN510D.SDSNDBRM') - SQLERROR(NOPACKAGE) VALIDATE(BIND) FLAG(I) - ISOLATION(CS) EXPLAIN(NO) - CURRENTDATA(YES) - ACTION(REPLACE) END
Thanks and Regards Have a nice day Sreedhar Bobbadi (704-382--0540)
Robert lawrence To: DB2-L@RYCI.COM bcc: Sent by: DB2 Subject: SPUFI from DB2 OS390(V5) to DB2 UDB v6 Data Base Discussion List [...]
5834 81 46_Transient Data Table design questions (repost)12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Tue, 17 Apr 2001 15:27:02 -0400360_us-ascii I sent the query below at the end of last week, but didn't see any responses; just one repost, and a clarification of the primary question, then I'll leave you alone :
Transient data table - inserting blocks of data ("reports"), opening cursors on these reports for SELECT, deleting reports if not referenced for a certain period of time. [...]
5916 30 37_Extended Addressability.........again16_Christopher Matt14_cjm@US.IBM.COM31_Tue, 17 Apr 2001 15:27:37 -0400625_us-ascii Dear List, Has anyone had experience with assigning tablespaces to an SMS extended-addressability DATACLAS , where most TS's are defined with DSSIZE=8gig, but the VCAT that is used in the ACS routines for that DATACLAS, includes tablespaces defined earlier without the DSSIZE paramater . In other words , we have a mix of DSSIZE=8gig and 4-gig datasets associated with the EA dataclass. I've seen prior discussion on the negative results that certain vendor products have when attempting to extend , but has anyone experienced problems when , say the IBM load utility requires one of these <= 4-gig datasets to [...]
5947 163 61_North Carolina DBA positions (also ADABAS, Oracle and Sybase)13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Tue, 17 Apr 2001 15:45:51 -0400635_iso-8859-1 Hi, everyone! Just an update on some jobs that I am working on in the NC area. Again, to find out more about how I work as a recruiter, go to: http://members.tripod.com/kathrynsears/
If anyone can recommend good Sybase, ADABAS or Oracle groups, I'd appreciate it!
NEW* Position accessible from Charlotte, NC or Winston-Salem: DB2 DBA... Opportunity to step quickly into a technical lead over three other DB2 DBA's. Good-sized company with an extremely fast work pace. This position is for people who prefer dead to bored! This company has had people return to them after "being bored" at another company. [...]
6111 120 42_Re: SPUFI from DB2 OS390(V5) to DB2 UDB v615_Robert lawrence21_rlawrence@BOSCOVS.COM31_Tue, 17 Apr 2001 15:57:52 -0400709_iso-8859-1 Thanks all who replied. This worked but I removed sqlerror(nopackage) and explain(no) and let default
Bob Lawrence DBA Boscov's Dept Stores LLc
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Sreedhar Bobbadi > Sent: Tuesday, April 17, 2001 2:18 PM > To: DB2-L@RYCI.COM > Subject: Re: SPUFI from DB2 OS390(V5) to DB2 UDB v6 > > > Try > > DSN SYSTEM(DSNT) > BIND PACKAGE (INV_MCHT.DSNESPCS) - > QUALIFIER (TSOSAD1) - > MEMBER(DSNESM68) LIBRARY('DSN510D.SDSNDBRM') - > SQLERROR(NOPACKAGE) VALIDATE(BIND) FLAG(I) - > ISOLATION(CS) EXPLAIN(NO) - > CURRENTDATA(YES) - > ACTION(REPLACE) > END > > Thanks [...]
6232 25 52_Stored procedure debugging on OS390 using a COBOL SP12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 17 Apr 2001 15:29:00 -0400551_- I made a large assumption concerning debugging stored procedures on OS390. I have: MSGFILE(SYSPRINT,FBA,121,0,ENQ),RPTSTG(ON),RPTOPTS(ON)) in the run options and have put DD statements in the WLM started task procedure: //SYSPRINT DD SYSOUT=X //SYSOUT DD SYSOUT=X //SYSOUD DD SYSOUT=X
I was assuming that a stored procedure could write debugging messages to these DDs. I have used DISPLAY as well as WRITES in a COBOL SP and have yet to get it to work. The only thing in the DDs is output from the LE parms specified in the run options. [...]
6258 99 42_Re: Re : Browsing index in both directions13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 17 Apr 2001 15:26:22 -0500304_iso-8859-1 Sharon,
DB2 V7 OS/390 & Z/OS delivers the capability to retrieve the MAX from an ASC index using an index one-fetch, and MIN from a DESC index. But the capability for reverse scanning to avoid a sort for a ORDER BY DESC on an ASC index has not yet been delivered to mainframe DB2. [...]
6358 128 15_Re: Outer Join?19_K.Balaji (Exchange)19_K.Balaji@TARGET.COM31_Tue, 17 Apr 2001 15:32:58 -0500632_iso-8859-1 Hi Dave, Can you pl explain what maintenance is needed to make this sql work. SQL looks like it perfectly workable.
-----Original Message----- From: Andy Hunt [mailto:Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK] Sent: Tuesday, April 17, 2001 7:50 AM To: DB2-L@RYCI.COM Subject: Re: Outer Join?
Dave, We have hit a similar problem with a full join. IBM recommended we should have the following maintenance on... pq30937 uq37188 (9911) pq35056 uq44724 (0007) pq30956 uq36162 (9911) pq36047 uq43668 (0006) pq37432 uq45753 (0008) pq40956 uq47462 (0010) pq42078 uq47882 (0011) pq42611 uq49127 pq43499 uq51248 [...]
6487 241 63_Re: getting matching columns = 2, should be matching column = 313_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 17 Apr 2001 15:44:20 -0500633_us-ascii Amy,
As Gregg says, the predicates on C are inferred by those coded on A.
This is known as "Predicate Transitive Closure".
If A=B and A=1
Then DB2 will generate the predicate: B=1
This gives the optimizer two possible join sequences, which is what you have seen.
Yes, adding a redundant predicate such as AND C.PO_LINE_ITM = > 0 is a very old technique. Basically by "loading" a table or index with more predicates you can encourage DB2 to choose that table/index first. Although often the "loading" does not work, since DB2 simply transposes the predicate to the other table. [...]
6729 65 40_Checking DB2 Database/Table Availability9_Al Heiden31_alheiden@NORTHWESTERNMUTUAL.COM31_Tue, 17 Apr 2001 15:52:59 -0500618_ISO-8859-1 We currently are running DB2 for OS/390 Version 5.10, and we will be migrating to DB2 for OS/390 Version 6 in the near future.
We are trying to programmatically determine the availability of DB2 Databases/Tables in CICS and batch programs (tables Read/Write, Read Only, Utility, etc). We would like to do this up front in a transaction/program so that we can stop processing at the beginning of a transaction instead of half way through it (especially for a CICS function with multiple screens of data where the unavailable data may not be accessed until the client has entered multiple screens [...]
6795 55 56_Re: Stored procedure debugging on OS390 using a COBOL SP10_Rao, Peavy26_Peavy.Rao@TRANSAMERICA.COM31_Tue, 17 Apr 2001 16:53:57 -0500338_- Bob, You can DISPLAY debug messages from COBOL stored procedure. These messages show up in SYSOUT of the WLM Proc. You may have to add the SP name to each of the DISPLAY, so that you can make out which procedure is DISPLAYing what.
Most of our developers use this, we are just trying to use XPEDITER 7.0 to debug SPs. peavy [...]
6851 25 56_Re: Stored procedure debugging on OS390 using a COBOL SP10_Rob Wright17_rwright@LIC.CO.NZ31_Wed, 18 Apr 2001 09:57:15 +1200334_us-ascii Have you considered debugging your stored procedure as a straight forward external COBOL CALL, rather than using SPs? This way you remove the complexity of SPs/WLM etc. Once you are comfortable that your called program works as expected, then implement it as a SP. Unless, of course, that's where you're now up to ..... [...]
6877 107 41_Re: Possible Utility Serializatin Problem11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Tue, 17 Apr 2001 19:38:13 -0400460_ISO-8859-1 Richard
As Isaac says, DBID=1 is the Directory database DSNDB01. OBID=83 is table SYSUTILX. Directory objects are not recorded in the Catalog, which is why you couldn't find them. They are documented in the Diagnosis Guide and Reference manual.
The utilities are clashing when trying to update SYSUTILX. What version of DB2 are you on? I seem to remember some problems with V6 in this area. Make sure you are up to date on fixes. [...]
6985 149 15_Re: Outer Join?15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 18 Apr 2001 09:31:19 +1000400_iso-8859-1 Dave (and, I guess, Andy),
I'm not particularly au fait with the 'new' join syntax, but wouldn't something like:
select columns-from-table-a, colums-from-table-c (not sure if you actually want some colums from tablec) from tablea a left outer join tableb b on a.join-columns=b.join-columns left outer join tablec c on a.join-columns=c.join-columns where blah blah blah; [...]
7135 54 41_Re: Extended Addressability.........again15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 18 Apr 2001 09:43:32 +1000373_- Christopher,
Sorry, dude, but I can't help. Only used 'certain vendor products' to load my 'dssize 32G' 9 partition tablespace. Didn't try IBM's load utility 'cause it couldn't do what I wanted i.e. load a literal into my fabricated first partitioning key column. Always wondered what would happen in the situation you describe. If you find out, let me know. [...]
7190 28 52_05/03/01 - Cincinnati, OH - Fun with DB2 Performance14_Gill, Joseph G19_joseph.gill@EDS.COM31_Tue, 17 Apr 2001 21:23:41 -0400396_iso-8859-1 On Thursday May 3, the Greater Cincinnati DB2 Users Group will meet at Ohio Casualty in Fairfield, NW of Cincinnati, 1-4:30PM
Our Guest Speaker will be Willie Favero, BMC Corporation.
His topic is Fun with DB2 Performance.
Reservations are Required.
To make a reservation, send an email with your Name,Company name, phone number, and e-mail address to [...]
7219 73 34_Re: Stored Procedures in DB2/LINUX14_Hrishiraj Nair28_hrishirajnair@REDIFFMAIL.COM31_Wed, 18 Apr 2001 02:26:07 -0000613_- Looks like IBM has moved the page!
------------- Original Message -------------- CHRISTOPHER STARNES wrote: To:DB2-L@RYCI.COM From:CHRISTOPHER STARNES Date:Tue, 17 Apr 2001 09:52:34 -0400 Subject: Re: Stored Procedures in DB2/LINUX
I don't think the SPB is currently available for Linux. You can use the SPB provided with DB2 for NT to develop Java and SQL stored procedures for Linux. The SPB is part of the free download (with restrictions, read the license) of DB2 Developers Edition found at http://www-4.ibm.com/software/data/db2/udb/downloads. [...]
7293 18 40_Checking DB2 Database/Table Availability10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 18 Apr 2001 08:45:21 +0200468_us-ascii I used IFI to execute DB2 commands (like -START TRACE, -DIS DB) via REXX execs and it works. It's a little bit
complicated (but not 'so' complicated) but it's funny to develop control/checking execs.
HTH
================================================ 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.
7312 25 37_DB2 V6 Transition course in Melbourne15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 18 Apr 2001 17:06:39 +1000517_- Colleagues,
Those of you in Melbourne between 7th and 9th May 2001 may be interested to know IBM are (hopefully) running course CF37Y - DB2 UDB for OS/390 V6 Transition. I hope to attend, but there's a chance the course will be canned due to a lack of attendees. If anyone else wants to go, give Danielle Lofting at IBM Learning Services a call on (03) 9626 6123 before Monday 23rd May and book yourself. The more people register, the more likely IBM will run the course (and, of course, I get to go!). [...]
7338 147 36_Re: Trapping -ve SQLcodes with Exits14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 18 Apr 2001 11:07:45 +0100341_iso-8859-1 I'm a little surprised that no one has responded to this.
There are two solutions.
One is to buy (sorry) a tool like CAs Detector which can be set up to trap all -ve SQLCODES and the offending SQLCA. However, this will NOT affect the operation of the program - it just provides an audit trail of the bad stuff. [...]
7486 74 44_Re: Trigger Question - That semi-colon again14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 18 Apr 2001 11:37:48 +0100388_iso-8859-1 One thing that is not made clear is that the statement terminator in SPUFI and the statement seperator in BEGIN ATOMIC ...... END CANNOT both be semi colon. There is a new option on the SPUFI defaults panel to change the statement terminator. You must change this to something strange (how about { for example) and the recode your create trigger terminating it with END{. [...]
7561 83 20_Re: Trigger Question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 18 Apr 2001 05:37:34 -0500454_- Marty
You have left semi-colon as the statement delimiter. In other words, SPUFI is using the semi-colon to terminate the CREATE TRIGGER statement, so DB2 sees neither it, nor the END after it.
To correct this problem, you will need to change the statement delimiter. You use the SPUFI DEFAULTS options panel. Most people use a hash/pound character - #. Then change the CREATE TRIGGER statement to have the hash/pound after the END. [...]
7645 27 67_=?iso-8859-1?B?Uulm6XJlbmNl?=: Re: Trapping -ve SQLcodes with Exits13_Marcel Lepage28_marcellepage@MONCOURRIER.COM31_Wed, 18 Apr 2001 07:21:52 -0400
7673 21 44_Re: Checking DB2 Database/Table Availability16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 18 Apr 2001 07:26:29 -0400496_us-ascii Hi,
I have not tried using it, but I have noticed that there is a sample REXX stored procedure that can issue DB2 commands. It is found documented starting on page 17 in the IBM REXX Language Support manual.
hth,
Rick Creech
================================================ 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.
7695 180 15_Re: Outer Join?11_David Nance16_DWNance@FHSC.COM31_Wed, 18 Apr 2001 07:44:54 -0400504_US-ASCII Raymond, Yes that does work, but not for our particular requirement. I only want to see the rows from C that may match with table B. And I want to see the rows from the joined B & C tables where they match on A, but if the C column is null, due to the outer join, I would still like to see the matching column from B. Hope this is a little more understandable. We are checking our maintenance level with the list of PTF's from Andy, if that still doesn't work I guess we'll be going to IBM [...]
7876 161 108_=?iso-8859-1?Q?RE=3A_=5BDB2-L=5D_R=E9f=E9rence=3A_Re=3A_Trappi?= =?iso-8859-1?Q?ng_-ve_SQLcodes_with_Exits?=14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 18 Apr 2001 12:48:29 +0100605_iso-8859-1 Of course, EVERYTHING is resource consuming, so I guess you mean 'excessive' resource consuming??
Mind you, THAT is also a question of degrees.
It is true, Detector WILL consume more resources when tracking bad SQL codes, but the amount of resource will be broadly related to the number of bad SQL codes you trap. Every case is different, but the users we see using this feature generally agree that the minimal additional overhead is offset by the value of having the SQLCA and SQLCODE available. Gone are those annoying phone calls that start "We just had a failure with a [...]
8038 120 20_Re: Trigger Question14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 18 Apr 2001 07:02:38 -0500474_iso-8859-1 I believe you can also use the set terminator statement within SPUFI to change the terminator 'on the fly'.
Statement:
--# Set Terminator #
Will set to # (see UDB for Os/390, IBM Application Programming and SQL Guide - 2.5.2)
-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Wednesday, April 18, 2001 5:38 AM To: DB2-L@RYCI.COM Subject: Re: Trigger Question [...]
8159 42 56_Re: Stored procedure debugging on OS390 using a COBOL SP11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Wed, 18 Apr 2001 07:07:30 -0500
8202 25 76_Re: =?iso-8859-1?q?R=E9f=E9rence=3A_Re=3A_Trapping_-ve_SQLcodes_with_Exits?=16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Wed, 18 Apr 2001 08:13:10 -0400534_us-ascii Just to put in a good word for Detector: I worked at a company where we had Detector running all the time, and one of the nice features was having all of the negative sqlcodes neatly aligned, and being able to see what user and program received them and when. We did not consider the overhead of running Detector to be excessive. Where I am now we have the same capability with Apptune. I would not want to work in a DB2 environment where I did not have that capability. I kind of like being able to solve problems when [...]
8228 82 36_Re: Trapping -ve SQLcodes with Exits34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Wed, 18 Apr 2001 08:30:51 -0400648_us-ascii It doesn't have to be assembler program to trap negative sqlcode. My Dallas IDUG presentation last year has sample COBOL code. The appendices include sample codes for
- Trapping negative sql - Tracing SQL at will - One load module for various (CAF,RRSAF & TSO) attachments.
-Venkat Pillay
> -----Original Message----- > From: Grainger, Phil [SMTP:Phil.Grainger@CA.COM] > Sent: Wednesday, April 18, 2001 6:08 AM > To: DB2-L@RYCI.COM > Subject: Re: Trapping -ve SQLcodes with Exits > > I'm a little surprised that no one has responded to this. > > There are two solutions. > > One is to buy [...]
8311 19 56_Re: stored procedure debugging on os390 using a cobol sp26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Wed, 18 Apr 2001 05:53:06 -0700298_iso-8859-1 We are also issuing displays from stored procedures. If you put the following line at the very top of the SP, you can separate the sysout into DD's for each SP. Makes it much easier to then debug because each SP has its own sysout.(named the same as the SP) PROCESS OUTDD(SPRAM009) [...]
8331 28 12_PHP4 and DB214_Hrishiraj Nair28_hrishirajnair@REDIFFMAIL.COM31_Wed, 18 Apr 2001 12:51:58 -0000463_- Hi,
I have DB2 EE 7.1 running perfect on My Linux Machine (Thanks to Christopher Starnes).
I also have PHP4 running along with Apache 1.3.17, How do I get PHP4 to talk to DB2 without using ODBC?
I beleive there is some option called --with-ibm-db2...
Please help Thanks. Raj
_____________________________________________________ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com [...]
8360 64 37_DB2 for OS/390 Image Copy performance10_Steve Lamb25_Steve.Lamb@POWERGEN.CO.UK31_Wed, 18 Apr 2001 14:12:43 +0100700_us-ascii Hi List,
Can anybody explain why image copying a tablespace which has been partitioned takes longer and uses more CPU than copying the same tablespace before it was partitioned, even though there are fewer pages in the tablespace?
Using DB2 for OS/390 v6.1, with the normal IBM Copy utility
Before partitioning: CPU time 95sec DSNUGUTC - COPY TABLESPACE DWLKPRA.SCB5401 COPYDDN(C0001) SHRLEVEL CHANGE DSNUBBID - COPY PROCESSED FOR TABLESPACE DWLKPRA.SCB5401 NUMBER OF PAGES=616970 AVERAGE PERCENT FREE SPACE PER PAGE = 4.01 PERCENT OF CHANGED PAGES = 1.99 ELAPSED TIME=00:11:55 DSNUBBID - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE DWLKPRA.SCB5401 DSNUGBAC - UTILITY [...]
8425 72 31_Re: Selecting from result table13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Wed, 18 Apr 2001 06:52:55 -0700433_iso-8859-1 To make it work I changed two column names in EMP
WORKDEPT for DEPT SALARY for SAL
so this is what ran SELECT A.DEPT "DEPARTMENT" ,A.NUM_EMP/B.TOTAL_COUNT "%EMPLOYEES" ,A.SAL_SUM/B.TOTAL_SAL "%SALARY" FROM (SELECT WORKDEPT DEPT, COUNT(*) NUM_EMP, SUM(SALARY) SAL_SUM FROM DSN8610.EMP GROUP BY WORKDEPT) A, (SELECT COUNT(*) TOTAL_COUNT, SUM(SALARY) TOTAL_SAL FROM DSN8610.EMP) B
with this results [...]
8498 40 31_DB2 for Linux Stored Procedures19_CHRISTOPHER STARNES14_b05cxs@FDS.COM31_Wed, 18 Apr 2001 10:48:29 -0400359_us-ascii Raj, I'm glad it worked!
Since we worked on the solution outside of the list, I thought I'd provide the steps here for future reference. To get DB2 for Linux stored procedures to work with the JDK 1.1.8 on Red Hat 6.2 and SuSe 6.4, we performed the following steps:
1. Set the JDK11_PATH configuration parameter using the command: [...]
8539 37 56_Re: stored procedure debugging on os390 using a cobol sp13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 18 Apr 2001 11:15:22 -0400602_us-ascii Neat! Do you mean this should be the first line in the COBOL stored procedure program?
Thanks!
> -----Original Message----- > From: Johnson, Bill (Pittsburgh) [SMTP:bjohnson@RUSSELLMELLON.COM] > Sent: Wednesday, April 18, 2001 8:53 AM > To: DB2-L@RYCI.COM > Subject: Re: stored procedure debugging on os390 using a cobol sp > > We are also issuing displays from stored procedures. If you put the > following line at the very top of the SP, you can separate the sysout into > DD's for each SP. Makes it much easier to then debug because each SP has > its > own sysout.(named [...]
8577 150 20_Re: Trigger Question22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Wed, 18 Apr 2001 08:23:20 -0700434_iso-8859-1 Thanks to all who responded. Unfortunately We as DBA's here do not have access to SPUFI or I should say the SPUFI panel. I have forwarded your comments to our Sysprogs to see what options are open to us. Thanks again..
Marty Killen SR DB2 DBA \\\|///
CNF INC \ ~ ~ / Information Technology (\@ @/) 503-450-2681 - CNF INC +---oOOO (_) OOOo---+ 503-450-6038 - Conway | | | | e-mail - killen.martin@cnf.com [...]
8728 100 44_Re: Checking DB2 Database/Table Availability0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 18 Apr 2001 10:27:01 -0500549_us-ascii Are you sure that you want to do that in an online system? I understand your concern, we have an online system that is similar to what you describe, but we never worried about it. The assumption is that everything is available at the start of online processing. If it isn't, then we handle the sqlcode, and the user may have to do some re-entry. Commits of DB updates are done at the end of a logical transaction, not necessarily at the end of each screen, so that if something abends, the user can restart from the last commit point. [...]
8829 77 41_Re: DB2 for OS/390 Image Copy performance10_Linda Ball18_linda_ball@BMC.COM31_Wed, 18 Apr 2001 10:04:08 -0500340_- How many partitions? Allocating the data sets to read them takes seconds. So a lot of partitions could add many seconds to copy. This is also an issue in copying (or recovering) many, many table spaces. Just MVS allocate can be time-consuming.
On Wed, 18 Apr 2001 14:12:43 +0100, Steve Lamb wrote: [...]
8907 22 32_DB2 v6 OS/390 on IBM zSeries 90021_Rechsteiner, Tom (TH)20_trechsteiner@DOW.COM31_Wed, 18 Apr 2001 10:05:43 -0400312_iso-8859-1 Dear Gentle DB2-L User Group,
Anyone out there running the IBM (e-server) zSeries 900?
If so, what OS are you using and what version of DB2? I am doing some investigation leg work trying to find out what features of an IBM (e-server) zSeries 900 can DB2 v6 on OS/390 v2r10 exploit? [...]
8930 35 35_Excess Logging with SHRLEVEL CHANGE11_Ken Liberty29_Ken_Liberty@CONSULTEC-INC.COM31_Wed, 18 Apr 2001 11:46:33 -0400330_us-ascii I'm seeing an excess amount of logging when we REORG a large table using SHRLEVEL CHANGE LOG NO. Due to the fact that LOG NO is being used, I expected that logging of course would not occur. I have 2 theories on why I'm seeing this... Let me know your thoughts on each of these, if you some insight into this issue: [...]
8966 52 56_Re: stored procedure debugging on os390 using a cobol sp26_Johnson, Bill (Pittsburgh)26_bjohnson@RUSSELLMELLON.COM31_Wed, 18 Apr 2001 08:52:54 -0700415_iso-8859-1 Yes, that and add the DD statements to the SPAS startup proc. Bill Johnson Russell Mellon
-----Original Message----- From: Lynne Flatley [mailto:LFlatley@NEFN.COM] Sent: Wednesday, April 18, 2001 11:15 AM To: DB2-L@RYCI.COM Subject: Re: stored procedure debugging on os390 using a cobol sp
Neat! Do you mean this should be the first line in the COBOL stored procedure program? [...]
9019 59 39_Re: Excess Logging with SHRLEVEL CHANGE0_18_mebert@AMADEUS.NET31_Wed, 18 Apr 2001 18:15:26 +0200566_us-ascii Ken,
with REORG SHRLEVEL CHANGE only LOG NO is valid (and implied); see Util Guide. The reloaded data is not logged (strictly speaking, it is not loaded into a DB2 table - just a shadow copy of one). I don't know whether the mapping table (actually index only) data is logged - interesting question; I have wondered about logging when doing REORG SHRLEVEL CHANGE as well. Updates to SYSCOPY, SYSUTILX and SYSLGRNX as the utility progresses are certainly logged. What do you consider an "excessive amount", and are you sure it's caused by REORG? [...]
9079 65 39_Re: Excess Logging with SHRLEVEL CHANGE11_Kwan, James18_James_Kwan@BMC.COM31_Wed, 18 Apr 2001 11:20:13 -0500553_iso-8859-1 Ken
Are you seeing a lot of log reading or writing? And in what phase? I don't believe you can use SHRLEVEL CHANGE LOG YES and therefore it makes no sense that it will log changes on reload. What is going to be logged? The Rids or the actual rows (data)? Rids are updated to Mapping table and there is not update to the actual rows. I suspect your log has been archived or you have a lot of uncommited log activity during unload/reload phase. Reorg will scan the log from the beginning of LU of your uncommitted transactions. You [...]
9145 75 23_SET Terminator in spufi13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 18 Apr 2001 12:22:05 -0400278_iso-8859-1 Hello Scott, or anyone else,
Have you actually gotten this to work in SPUFI?
I looked for that in the doc last time this topic came up and couldn't find it for SPUFI. It is in the doc which you reference but it fails when I try to use it in SPUFI. [...]
9221 24 20_UDB Quick Reference?14_Steve Westfall22_steve.westfall@ATT.NET31_Wed, 18 Apr 2001 11:14:32 -0500348_iso-8859-1 I have searched the DB2-L archives, the IBM web site, and Amazon.com for this, but I haven't found it.
Is there a quick reference summary for DB2 UDB? I have my small, handy, spiral-bound reference summary for mainframe DB2 (version 4), and I'd like to get something similar now that I'll be working with DB2 UDB 7.1 on AIX. [...]
9246 95 41_Re: DB2 for OS/390 Image Copy performance13_Zessin, Peter25_Peter.Zessin@ATCOITEK.COM31_Wed, 18 Apr 2001 10:53:24 -0600437_- DB2 Version 6 introduced a bug to Image Copy Sharelevel Change, that degraded peformance (CPU and Elapsed) when copying Partitioned Tablespaces or LOBS.
See PTF UQ49619, APAR PQ43767
Peter Zessin PeterZessin@Atcoitek.com
-----Original Message----- From: Steve Lamb [SMTP:Steve.Lamb@POWERGEN.CO.UK] Sent: 18 April, 2001 7:13 AM To: DB2-L@RYCI.COM Subject: DB2 for OS/390 Image Copy performance
Hi List, [...]
9342 21 31_Migration from DB2 v5 to DB2 v711_Brown, Bill28_sgjwb@TECHMAIL.ADMIN.TTU.EDU31_Wed, 18 Apr 2001 11:47:22 -0500564_iso-8859-1 Hello list,
I'm a newcomer to DB2. We are considering migrating from DB2 version 5 straight to DB2 version 7. I saw Roger Millers comments about this idea and was wondering if anyone else has any thoughts concerning this path.
Thanks, Bill Brown University Computing Services Texas Tech University
================================================ 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.
9364 88 39_Re: Excess Logging with SHRLEVEL CHANGE34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Wed, 18 Apr 2001 12:59:49 -0400615_us-ascii It could be BUILD2 phase, where despite LOG NO logging is done to record the NPI structure changes. It can be pretty heavy too on certain occasions.
-Venkat Pillay
> -----Original Message----- > From: mebert@AMADEUS.NET [SMTP:mebert@AMADEUS.NET] > Sent: Wednesday, April 18, 2001 12:15 PM > To: DB2-L@RYCI.COM > Subject: Re: Excess Logging with SHRLEVEL CHANGE > > Ken, > > with REORG SHRLEVEL CHANGE only LOG NO is valid (and implied); see Util > Guide. > The reloaded data is not logged (strictly speaking, it is not loaded into > a DB2 > table - just a shadow copy of [...]
9453 36 28_db2 for os/390 and websphere29_Sherri Sterling DIGEST NOMIME29_Sherri.Sterling@BPD.TREAS.GOV31_Wed, 18 Apr 2001 13:05:26 -0400341_us-ascii Is anyone putting the websphere repository database in db2 for os/390 environment? If so what draw backs have you encountered. One was mentioned about Websphere having to go through db2 connect to the mainframe to get it's repository information returned and the overhead this makes.
Sherri Sterling Bureau of the Public Debt
9490 44 35_Re: Migration from DB2 v5 to DB2 v716_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 18 Apr 2001 13:07:41 -0400417_iso-8859-1 We are doing this for thre reasons 1) One outage rather than two. 2) V5 to V7 is about half the labor cost of V5 to V6 to V7. 2) V7 features.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Brown, Bill [mailto:sgjwb@TECHMAIL.ADMIN.TTU.EDU] Sent: Wednesday, April 18, 2001 12:47 PM To: DB2-L@RYCI.COM Subject: Migration from DB2 v5 to DB2 v7 [...]
9535 120 27_Re: SET Terminator in spufi21_Claypool, Alisa@HHSDC21_AClaypoo@HHSDC.CA.GOV31_Wed, 18 Apr 2001 10:34:46 -0700364_iso-8859-1 I was told the following by IBM:
. I am afraid that I have some bad news for you. I have done some extensive checking and it turns out that there is a documentation error in the DB2 V6.1 and DB2 V7.1 manuals. This control statement --#SET TERMINATOR character is not a feature of SPUFI. . I was able to confirm this from another ETR: [...]
9656 74 25_JDBC S806 abend On MVS OE17_KUSTERS, ED (TAO)30_ED.KUSTERS.tao@CCRA-ADRC.GC.CA31_Wed, 18 Apr 2001 13:39:00 -0400432_- Date: Wednesday, 18 April 2001 1:39pm ET To: db2-l@ryci.com, JUNEAU.JOE, WEBSTER.MURRAY From: KUSTERS.ED@RCT Subject: JDBC S806 abend On MVS OE
Did the attached abend ever get resolved or does anyone out there know how I might resolve it.
I am getting the same exact error.
When I execute the JDBC sample01 java program, it abends when it tries to register the jdbc driver using the following java code: [...]
9731 25 27_Re: SET Terminator in spufi10_Shery Hepp17_schepp@SRPNET.COM31_Wed, 18 Apr 2001 10:56:36 -0700409_iso-8859-1 Dave- I'm not sure if I'm coming into this discussion midstream and have missed something- but if you're referring to interactive spufi and changing the terminator I have successfully done this- under the defaults panel CURRENT SPUFI DEFAULTS SSID: DST ===>
Enter the following to control your SPUFI session:
1 SQL TERMINATOR .. ===> # (SQL Statement Terminator) [...]
9757 130 27_Re: SET Terminator in spufi14_Scott Trometer22_scott.trometer@RCI.COM31_Wed, 18 Apr 2001 12:30:35 -0500438_iso-8859-1 Dave,
Well, that'll teach a person to RTFM...I can't get it to work either. I had lost access to my V6 subsystem and thought that I had successfully tested this before. After your note, I got access back and re-tried...and failed miserably!
I am attaching the manual excerpts for all to enjoy...I also see what you mentioned regarding IBM using different terms (SET vs #SET). Has anyone got this to work???? [...]
9888 19 11_DB2 and WLM13_O'Neill, Mike19_Mike.O'Neill@53.COM31_Wed, 18 Apr 2001 15:29:05 -0400452_iso-8859-1 Is there a good book/procedure that gives details on how to setup a DB2 application environment in WLM?
<<...OLE_Obj...>> Mike O'Neill Assistant Vice President 513.744.8927 mike.o'neill@53.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.
9908 41 15_Re: DB2 and WLM12_Clark, Kevin15_KClark@FDIC.GOV31_Wed, 18 Apr 2001 16:07:52 -0400470_- 1) Check out the WLM site ..lots of related links and paper http://www.s390.ibm.com/wlm/ 2) MVS planning: WORKLOAD MANAGEMENT AND (GC28-1761-10) FOR 2.8 3) Red book : OS/390 WORKLOAD MANAGER IMPLEMENTATION AND EXPLOITATION sg24-5326-00
Kevin Clark
-----Original Message----- From: O'Neill, Mike [SMTP:Mike.O'Neill@53.COM] Sent: Wednesday, April 18, 2001 3:29 PM To: DB2-L@RYCI.COM Subject: DB2 and WLM [...]
9950 44 37_RACF and DB2 security setup questions13_Henry Fogwill17_fogwill.h@GHC.ORG31_Wed, 18 Apr 2001 13:29:34 -0700418_- Hi, We're a new DB2 shop and decided to implement RACF security right from the start. We also decided to do secondary authid's.
The 'problems' we are having is: (and this is only a few of the strangeness)
1. It looks like not every security request goes to RACF. I am in the access list for the SYSADM profile in RACF. Stopping RLIMIT facility failed until I granted myself SYSADM in the catalog. [...]
9995 105 41_Re: RACF and DB2 security setup questions17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Wed, 18 Apr 2001 16:00:54 -0500477_iso-8859-1 Hi Henry,
If you feel like snuggling up with a good book about RACF/DB2 check out the:
SG245158: Ready for e-business - OS/390 Security Server Enhancements (Chapter 4)
I'll bet there's a better book about this stuff since that was published but I haven't found it yet.
The part about prefixed DB2 commands explains your #1 problem. I'm not sure about your other issues, but did you try the GRANT without first setting SQLID? [...]
10101 27 27_Re: SET Terminator in spufi13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 18 Apr 2001 17:14:57 -0400461_iso-8859-1 Alisa, THanks for confirming what Scott and I experienced. Scott, Shery, I imagine you've seen Alisa's response by now.
Shery, in case it's still not clear, my post was in reply to Scott who quoted the SQL & Pgming guide which said, that in addition to changing the terminator on the Spufi Defaults screen, the #SET Terminator statement should work in a Spufi session to change the terminator more dynamically -- like it does in DSNTEP2. [...]
10129 55 24_DB2 v5 and os/390 v 2.1013_Walter Davies26_wdavies@CO.EL-DORADO.CA.US31_Wed, 18 Apr 2001 14:26:51 -0700268_iso-8859-1 Hi list: We are going to version 2.10 in OS/390 and are wondering if any one knows of any gotcha's since we are running v 5.1 of DB2. We seem to have run into a problem with LE so I was asked to check about DB2.
Walter Davies DBA El Dorado County, CA
10185 23 28_Re: DB2 v5 and os/390 v 2.1011_Brian Lynch19_Brian.Lynch@TRW.COM31_Wed, 18 Apr 2001 17:44:55 -0400392_US-ASCII We are making the migration to OS/390 v2.10 but are at db2 v6. Anybody know of gotchas with this combination?
>>> wdavies@CO.EL-DORADO.CA.US 04/18 3:26 PM >>> Hi list: We are going to version 2.10 in OS/390 and are wondering if any one knows of any gotcha's since we are running v 5.1 of DB2. We seem to have run into a problem with LE so I was asked to check about DB2. [...]
10209 128 41_Re: RACF and DB2 security setup questions13_Henry Fogwill17_fogwill.h@GHC.ORG31_Wed, 18 Apr 2001 15:41:01 -0700356_US-ASCII Kenneth, Thanks you very much for this information. I downloaded the redbook and am reading chapter 4 right now. Finding good info thesedays with tverthing changing as it is sure is helpful.
>>> Kenneth_Kornblum@BMC.COM 04/18/01 02:00PM >>> Hi Henry,
If you feel like snuggling up with a good book about RACF/DB2 check out the: [...]
10338 24 30_Multi Streaming of DB2 program23_Vivekananthan Ettiappan18_vivdb2@HOTMAIL.COM31_Wed, 18 Apr 2001 23:35:28 +0100371_- Hello,
We have a program which is taking around 4 HOURS to run. We are planning to reduce the running time by adopting to run the same program in several streams simultaneously each acting at different set of data.
Can anyone tell me how do DB2 respond in this scenario?.. If anyone have implemented the same concept, please let me know the details. [...]
10363 16 17_Adding Partitions0_20_bjnigh@HOUSEHOLD.COM31_Wed, 18 Apr 2001 16:43:15 -0700498_us-ascii Is there a way of adding partitions to an existing DB2 tablespace in OS/390 or do you have to drop and recreate the tablespace to add partitions? These are large tables and dropping and recreating would mean unloading and reloading alot of 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.
10380 34 34_Re: Multi Streaming of DB2 program13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 18 Apr 2001 20:41:40 -0400575_iso-8859-1 Hi Vivek,
I believe Chuck Hoover deals with that topic in his presentation: Batch Application Design for DB2 for OS/390
You can download a softcopy at:
http://www.compuware.com/products/hoover/index.asp
Among the issues you'll face are: Finding a way to separate the workloads between the multiple occurrences of your job, e.g., key ranges or better yet, sets partitions of partitioned tablespaces; Avoiding locking conflict between the multiple occurrences, an obvious by-product of the issue above; Appropriate commit frequency. [...]
10415 124 44_Re: Checking DB2 Database/Table Availability23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Thu, 19 Apr 2001 01:12:34 -0000397_iso-8859-1 Or you could use results of the utility program in batch to disable the cics transactions that used the "unavailable resource", so users were unable to enter anything cos something is busted, but is sounds like you are using a sledgehammer to crack open a peanut. We actually run a utility at cics startup to check that the tablespaces are in good shape but that is the only time. [...]
10540 38 21_Re: Adding Partitions10_Rob Wright17_rwright@LIC.CO.NZ31_Thu, 19 Apr 2001 13:24:24 +1200601_us-ascii DB2 V7 is the first DB2 on OS/390 that provides this functionality.
bjnigh@HOUSEHOLD.COM on 04/19/2001 11:43:15 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Rob Wright/ham/LIC)
Subject: Adding Partitions
Is there a way of adding partitions to an existing DB2 tablespace in OS/390 or do you have to drop and recreate the tablespace to add partitions? These are large tables and dropping and recreating would mean unloading and reloading alot of data... [...]
10579 41 21_Re: Adding Partitions12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Thu, 19 Apr 2001 12:30:16 +1000528_- V8 or V.next?
What you have in V6 is the ability to create (allocate) blank (min sized) partitions between your active partitions something like:-
0G , 2G , 0G , 2G , 0G , 2G , 0G , 2G , 0G ... and so on
You can then later rebalance the keys to spread data back into those ranges. Of course it's not as easy as that, to make use of the intervening partitions. You need to alter the index for the new partitioning key ranges, the intervening partitions become unavailable, and you need to reorg them. [...]
10621 21 44_List of plans where column is used in update12_Rakesh Kumar21_rakesh457@HOTMAIL.COM31_Thu, 19 Apr 2001 04:43:55 -0000567_- ALL, Can anyone give me the QUERY where I can get a list of plans for a particular column which is used in UPDATE in all those plans. Thanx.
Regards Rakesh Kumar
_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail 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.
10643 43 48_Re: List of plans where column is used in update16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 19 Apr 2001 11:38:48 +0530332_- Rakesh,
It seems you want SYSIBM.SYSPLANCOLDEP(with columns "almost" same as SYSPLANDEP). Presently this is not available. You have to write your own routine to parse the SYSSTMNT Sql statements and then print a report or load in a table. I believe there are tools available as well....Not sure as have not used them. [...]
10687 12 21_Re: Adding Partitions15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 19 Apr 2001 03:30:21 -0500307_- Rob
Are you sure. I never heard about that in Version 7.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM.
10700 26 41_Re: DB2 for OS/390 Image Copy performance10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Thu, 19 Apr 2001 04:18:10 -0500492_- Linda/Peter
Thanks for the info - I've had a quick look at the APAR and it sounds promising. All I need to do now is get the MVS guys to check if the PTF is on the system or not. There are 6 partitions in the tablespace, two of which are virtually empty (they will start filling up over the next few weeks). I've also checked with the applications people and it looks like we can change to SHRLEVEL REFERENCE, so that should speed things up, even if the PTF is already on :-) ! [...]
10727 62 44_Re: Checking DB2 Database/Table Availability14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Thu, 19 Apr 2001 04:57:08 -0500596_iso-8859-1 Having read your note and some of the responses, I keep coming back to the question - Why do you want to do this?
My experience in running a (almost) 24x7 DB2 shop is that table availability is the normal situation, and non-availability is an exception condition. It has long been considered good design practice that exception conditions are handled by exception logic, not be critical-path logic. If you perform availability tests as part of your critical-path logic in all your transactions, you will chew up a lot of CPU and elapsed time for NEGATIVE business benefit. [...]
10790 22 35_Re: Migration from DB2 v5 to DB2 v714_Vassie, Edward21_Edward_Vassie@BMC.COM31_Thu, 19 Apr 2001 05:02:36 -0500345_iso-8859-1 If you are a newcomer to DB2, then it is best to stick to the standard migration path of V5 to V6, then V6 to V7. Your relative lack of experience will mean that you will be more likely to cope with any problems that arise. Also, there are less likely to be problems using the standard path than by jumping from V5 direct to V7. [...]
10813 64 24_Re: help needed urgently14_Suparna Murthy19_msuparna@IN.IBM.COM31_Wed, 18 Apr 2001 15:32:49 +0530469_us-ascii Hi ,
We are trying to install DCF4.0 , on OS/390 v2.5 operating system .The installation goes through fine,but the IVP is not working. When we run IVP steps at command line ===> script 'script.r40.dcfsamp(dsmivc40)' mes(i) prof('script.r40.maclib(dsmprof4)' ) lib('script.r40.maclib')
We are getting a message as follows: IEA995I SYMPTOM DUMP OUTPUT SYSTEM COMPLETION CODE=0C1 REASON CODE=00000001 TIME=12.23.52 SEQ=00250 CPU=0000 ASID=0033 [...]
10878 49 62_FW: Help W/ Partition Table Rolloff Strategy Followup Question25_Cavanaugh, Michael S H07A27_Michael.Cavanaugh@CIGNA.COM31_Thu, 19 Apr 2001 07:17:08 -0400552_us-ascii > To All Who Replied, > > Thank you very much for your comments and suggestions. They were all > helpful. As we work toward a solution I came across another question that > perhaps one of you, or someone else might be able to answer. Just a quick > reiteration of our problem: > We have a tablespace containing approx. 2 years worth of data partitioned > in2 week blocks (60 partitions) by TIMESTAMP. Once full, the 2year+ data > willbe removed and stored on a separate archive table. As we near the > point offilling the last partition, [...]
10928 36 32_Re: db2 for os/390 and WebSphere13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 19 Apr 2001 07:28:52 -0400373_us-ascii Where is the Websphere App Server running, on OS/390, AIX, NT, ??? We have a Websphere app going into QA with the user data being stored on DB2 on OS/390. We will have 3 Websphere App Servers is running on AIX and it was architected to have the WAS repository (and the SESSIONS db) be on another AIX database server (with HACMP with another database server). [...]
10965 42 21_Re: Adding Partitions15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 06:51:48 -0500451_ISO-8859-1 I know that some vendors sell utilities that are supposed to do this but they really drop and recreate the tablespace anyway. I allocated a lot of partitions for use later and repartition once in a while.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"Imagine the Creator as a stand-up comedian - and at once the world becomes explicable." - H.L. Mencken [...]
11008 26 34_DB2/RACF Install SYSADM RACF GROUP13_Fons Heirbaut27_Alfons.Heirbaut@AXA-BANK.BE31_Thu, 19 Apr 2001 06:22:45 -0500462_- Hello,
Converting from native DB2-security to the DB2/RACF-interface, I noticed that in the DSNPARM-member one of the Install SYSADM's is assigned to a (RACF) GROUP. It is not clear to me whether: - it is possible to have a GROUP as Install SYSADM with native DB2-security; - it is possible to have a GROUP as Install SYSADM with the external security active; - implicit authorizations are required for users and/or groups assigned Install SYSADM. [...]
11035 24 29_DB2/RACF execute QMF-packages13_Fons Heirbaut27_Alfons.Heirbaut@AXA-BANK.BE31_Thu, 19 Apr 2001 06:33:02 -0500411_- Hello,
During the conversion from DB2 native security to the DB2/RACF-interface, I noticed that the execution of QMF requires EXECUTE-authority on the QMF-Plan and on a number of QMF-packages. This is not the case with other application Plans.
From the documentation I understood that the EXECUTE-authority on a PACKAGE is only validated during the BIND of a PLAN using the PKLIST-keyword. [...]
11060 88 56_Re: stored procedure debugging on os390 using a cobol sp9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Thu, 19 Apr 2001 06:36:53 -0500504_- Just a word of caution. We have COBOL and 'C' Stored Procedure in our shop, when the 'C' SP do printf to display the messages, it automatically spawn a new dd and it seems to be a limit of how many DD statements a DB2 SPAS can have. When we reached 300+ output dd, no more messages were displayed and the only solution we know of today is to bounce the SPAS address space (development only). We have hundreds of SPs developed already. We discourage the use of display in a production environment. [...]
11149 47 34_Re: Multi Streaming of DB2 program16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 19 Apr 2001 08:13:49 -0400639_iso-8859-1 We do this a lot. Works well, especially if you are using partitioned tablespaces and separate the jobs by partition boundary.
regards,
eric pearson NS ITO Database Support
-----Original Message----- From: Vivekananthan Ettiappan [mailto:vivdb2@HOTMAIL.COM] Sent: Wednesday, April 18, 2001 6:35 PM To: DB2-L@RYCI.COM Subject: Multi Streaming of DB2 program
Hello,
We have a program which is taking around 4 HOURS to run. We are planning to reduce the running time by adopting to run the same program in several streams simultaneously each acting at different set of data. [...]
11197 45 32_Re: db2 for os/390 and websphere12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 19 Apr 2001 05:16:16 -0700512_us-ascii I am assuming you're talking about running Websphere on some box such as AIX or NT and having the repository on OS/390 DB2. If so, you must have Data propagator and either DB2 UDB EE or DB2 Connect EE to accomplish this. Websphere sets up and initializes the repository with data propagator statements. Without it, you can't properly get the repository setup in OS/390. Or at least I was never able to get it setup totally correctly. Several intermediate tables are only setup via Data propagator. [...]
11243 54 33_Re: DB2/RACF execute QMF-packages0_19_mike.holmans@BT.COM31_Thu, 19 Apr 2001 13:30:44 +0100382_- It depends what's trying to execute. If you are invoking QMF as a directly-logged-on user of the OS/390 box, then the run-time authorisation check is at the plan level, so the users need EXECUTE on the QMF plan. However, if you are invoking QMF remotely, then the package-level authorisation is checked as each package is invoked. This applies to all programs, not just QMF. [...]
11298 74 32_Re: db2 for os/390 and websphere14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 19 Apr 2001 07:35:11 -0500435_iso-8859-1 Myron,
Are you saying that, in general, an architecture that includes a database server, whether it be 0s/390, NT, etc., incurs too much network overhead to be viable??
Or that this is true specifically for Websphere ??
-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Thursday, April 19, 2001 7:16 AM To: DB2-L@RYCI.COM Subject: Re: db2 for os/390 and websphere [...]
11373 66 33_Re: DB2/RACF execute QMF-packages15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 07:42:49 -0500589_ISO-8859-1 -----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Thursday, April 19, 2001 7:31 AM To: DB2-L@RYCI.COM Subject: Re: DB2/RACF execute QMF-packages
It depends what's trying to execute. If you are invoking QMF as a directly-logged-on user of the OS/390 box, then the run-time authorisation check is at the plan level, so the users need EXECUTE on the QMF plan. However, if you are invoking QMF remotely, then the package-level authorisation is checked as each package is invoked. This applies to all programs, not just QMF. [...]
11440 74 33_Re: DB2/RACF execute QMF-packages15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 07:45:03 -0500452_ISO-8859-1 Sorry about the previous empty posting....early morning.....no caffeine.....
When access is remote then the package is executed directly and is not invoked by a plan. That is why execute authority much granted on the package.
Linda
-----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Thursday, April 19, 2001 7:31 AM To: DB2-L@RYCI.COM Subject: Re: DB2/RACF execute QMF-packages [...]
11515 92 32_Re: db2 for os/390 and websphere15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 07:48:21 -0500304_iso-8859-1 I think that anytime you have the data residing in a place other than your application you can incur a lot of network traffic. It depends. That is one reason why stored procedures were implemented. It places part of the application logic on the server so that the traffic can be reduced. [...]
11608 28 29_Re: JDBC S806 abend On MVS OE10_Lisa Bates19_lbates@JHANCOCK.COM31_Thu, 19 Apr 2001 07:56:34 -0500367_- A few weeks ago I had a very similar error. It turned out it was a typo in the classlibpath variable. Does the system log give any clues? Do you need to steplib to the SDSNLOAD/SDSNEXIT?
Also double check that the DB2,SQLJ/JDBC environment variable in etc/profile DB2SQLJPROPERTIES=/somepath points to the same file that used to create the JDBC profile [...]
11637 113 50_Re: Transient Data Table design questions (repost)19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 19 Apr 2001 08:36:34 -0500573_iso-8859-1 Gregg, I'm not sure I understand entirely your post but I'll have a go at it. 1) I like your idea about using an IDENTITY column. 2) Will the "staging" table remain mostly empty? I'm not clear on its use.
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 [...]
11751 14 37_Alter colume to have new default vale14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Thu, 19 Apr 2001 08:49:50 -0500412_iso-8859-1 Can I alter a column in a table which now has NOT NULL WITH DEFAULT to have NOT NULL WITH DEFAULT zzzz. Where zzzz is a value. If so what is the syntax? 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.
11766 153 50_Re: Transient Data Table design questions (repost)12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Thu, 19 Apr 2001 09:56:56 -0400574_us-ascii Rick, Thanks for responding - I was beginning to think I was in Coventry...
The concern I have with IDENTITY is that it has a finite limit - what do I do when this limit is reached?
The staging table's primary purpose is to support scrolling/paging requests from the user interface (UI) - since any particular report is a dynamically defined subset of the data in the main report table, relative line numbers can only apply to a materialised report, so we build line numbers as we stage, and can then handle requests from the UI of the nature of [...]
11920 33 41_Re: Alter colume to have new default vale16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 19 Apr 2001 19:44:37 +0530597_- I don't think this is available with V6 for OS390.
Let's see what others have to say
Regards Sanjeev
> -----Original Message----- > From: Zobjeck, A. J. [SMTP:Al_Zobjeck@TTX.COM] > Sent: Thursday, April 19, 2001 7:20 PM > To: DB2-L@RYCI.COM > Subject: Alter colume to have new default vale > > Can I alter a column in a table which now has NOT NULL WITH DEFAULT to > have > NOT NULL WITH DEFAULT zzzz. Where zzzz is a value. If so what is the > syntax? Thanks > > ================================================ > To change your subscription options or to cancel your [...]
11954 47 41_Re: Alter colume to have new default vale11_Kwan, James18_James_Kwan@BMC.COM31_Thu, 19 Apr 2001 09:32:09 -0500380_iso-8859-1 NOT NULL WITH DEFAULT 'XYZ' is a correct syntax in V6.
-----Original Message----- From: S, Sanjeev (CTS) [mailto:SSanjeev@CAL.COGNIZANT.COM] Sent: Thursday, April 19, 2001 9:15 AM To: DB2-L@RYCI.COM Subject: Re: Alter colume to have new default vale
I don't think this is available with V6 for OS390.
Let's see what others have to say [...]
12002 52 38_Re: DB2/RACF Install SYSADM RACF GROUP17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Thu, 19 Apr 2001 09:37:15 -0500348_iso-8859-1 Group IDs certainly work with both native DB2 security as well as with the DSNX@XAC exit active. The ZPARM is honored ahead of other security checks, so RACF (or internal auth tables) is not even referenced if you are the Install SYSADM (or have one of the Install SYSADM IDs in your list-of-RACF-groups that you are connected to). [...]
12055 41 36_Re: DB2 v6 OS/390 on IBM zSeries 90014_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 19 Apr 2001 09:26:46 -0500401_- Well, I've neither a zSeries 900 nor OS/390 2.10. However, I do recall reading that 2.10 could exploit the >2Gb real memory feature of the zSeries processors. If so, you could - apply UQ29514 - use DATASPACEs for bufferpools and have more than 1.6 Gb of virtual bufferpools. (This is kinda nice, since having more than 2Gb real means you can't have expanded memory - so no hiper buffer pools.) [...]
12097 83 34_Re: Multi Streaming of DB2 program0_22_BILL_GALLAGHER@PHL.COM31_Thu, 19 Apr 2001 10:29:24 -0400617_us-ascii Vivek,
We've been able to do this successfully. You will want to partition your tables (or at least cluster them) according to the criteria for which your concurrent jobs will be running. If possible, set up your concurrent jobs to run against their own separate partitions of the data.
If you have some tables that you will be accessing that you cannot partition or cluster according to your job-processing scheme, then you will want to watch out for I/O contention on the tables or non-partitioning indexes that you will be accessing. If your program will be doing any update processing [...]
12181 136 32_Re: db2 for os/390 and websphere14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 19 Apr 2001 09:46:50 -0500356_iso-8859-1 Maybe this should go offline or as a seperate thread, but...what would the advantages be, then, of a 3-tier architecture??
I'm just trying to figure out where we are in the evolution of architectures these days. There has been more talk recently in my area of using os/390 as a data server, leveraging the existing DB2 systems/data. [...]
12318 24 41_Re: Alter colume to have new default vale15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Thu, 19 Apr 2001 09:31:56 -0500608_- This is definitely not possible in Version 6 and I don't know if it will be possible in Version 7. It may be a good idea to open a new requirement for that.
On Thu, 19 Apr 2001 08:49:50 -0500, Zobjeck, A. J. wrote:
>Can I alter a column in a table which now has NOT NULL WITH DEFAULT to have >NOT NULL WITH DEFAULT zzzz. Where zzzz is a value. If so what is the >syntax? 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 [...]
12343 162 32_Re: db2 for os/390 and websphere15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 10:01:36 -0500604_ISO-8859-1 I am certainly not an expert in this area but I think that the amount of network traffic is related not so much to what system configuration you use but the design of the application. That is why I always say that application designers need to be acquainted (but not necessarily experts) with the nuts and bolts underneath. The trend with OO design is to eliminate the need for this knowledge when designing an application. However, certain designs may not lend themselves well with the system configuration underneath. Designers need to understand that so that the techies don't have to [...]
12506 162 32_Re: db2 for os/390 and WebSphere13_Lynne Flatley17_LFlatley@NEFN.COM31_Thu, 19 Apr 2001 11:03:54 -0400645_iso-8859-1 I don't want to speak for Myron but I believe his point was that the WAS repository (the very small configuration database used by Websphere) shouldn't be placed on OS/390 if Websphere itself was not running on OS/390. I don't believe that Myron was referring to application's user data/database(s)...
> -----Original Message----- > From: Scott Trometer [SMTP:scott.trometer@RCI.COM] > Sent: Thursday, April 19, 2001 10:47 AM > To: DB2-L@RYCI.COM > Subject: Re: db2 for os/390 and websphere > > Maybe this should go offline or as a seperate thread, but...what would the > advantages be, then, of a 3-tier architecture?? > [...]
12669 192 36_Re: DB2 v6 OS/390 on IBM zSeries 90014_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 19 Apr 2001 16:14:26 +0100452_iso-8859-1 Be VERY careful with bufferpools in dataspaces.
To paraphrase IBM, "they will NOT perform as well as traditional virtual bufferpools"
Better to wait for V7+1 to get real support for VBPs > 2Gb (unless you are desperate and can handle the performance penalties)
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
12862 50 41_Re: Alter colume to have new default vale12_Wilson, Doug27_doug_wilson@STAR-SYSTEM.COM31_Thu, 19 Apr 2001 11:05:32 -0400340_- Third party vendors offer such functionality for DB2 for OS/390. CDB Software offers an Alter product to change column type, column length, Nulls, and default values. Perhaps other vendors do also. DB2 V6 allows the altering of a VARCHAR columns length, I hear more column altering functionality will trickle out in future versions. [...]
12913 22 24_DB2 Datasharing Question14_Richard Arnold24_Richard.Arnold@CHASE.COM31_Thu, 19 Apr 2001 10:27:37 -0500545_us-ascii Hello list,
We are going to a data sharing environment.
Does DB2 V6 come in a data share-able state? Or is there something additional we need to buy for it (software wise; we know that we will need additional hardware.
Thanks in advance for your help.
Richard Arnold
================================================ 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.
12936 47 28_Re: DB2 Datasharing Question15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Thu, 19 Apr 2001 10:34:58 -0500561_ISO-8859-1 Although a data-sharing DB2 can function fine without it, installing Workload Manager makes things run just a little better.
Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services
"Imagine the Creator as a stand-up comedian - and at once the world becomes explicable." - H.L. Mencken
-----Original Message----- From: Richard Arnold [mailto:Richard.Arnold@CHASE.COM] Sent: Thursday, April 19, 2001 10:28 AM To: DB2-L@RYCI.COM Subject: DB2 Datasharing Question [...]
12984 67 41_Re: Alter colume to have new default vale12_Liddell, Jim19_JLiddell@SFBCIC.COM31_Thu, 19 Apr 2001 10:24:35 -0500444_iso-8859-1 BMC offers a product which will allow a DBA to ALTER column definitions. It drops and rebuilds the table in the process, but it resets all GRANTS, indexes, RI, etc. I've used the BMC products for years and have had no problems.
-----Original Message----- From: Wilson, Doug [mailto:doug_wilson@STAR-SYSTEM.COM] Sent: Thursday, April 19, 2001 10:06 AM To: DB2-L@RYCI.COM Subject: Re: Alter colume to have new default vale [...]
13052 124 28_Re: DB2 Datasharing Question14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Thu, 19 Apr 2001 08:36:55 -0700332_iso-8859-1 Richard, As long as you have a parallel sysplex in place, and have DB2 licensed for to allow it to be run on multiple machines, the software is ready for datasharing out of the box as far as I am aware. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...]
13177 13 29_Re: Running utilities in REXX13_Marcus Davage29_marcus.davage@LLOYDSTSB.CO.UK31_Thu, 19 Apr 2001 10:35:28 -0500413_- I know this is an old chestnut, but once I've assembled these little gems, how do I call them?
Do I still have to allocate a SYSIN and SYSPRINT etc. as per usual?
================================================ 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.
13191 65 41_Re: Alter colume to have new default vale0_19_Tim.Lowe@STPAUL.COM31_Thu, 19 Apr 2001 11:04:20 -0500584_us-ascii At the DB2 technical conference last year, one of the items mentioned that might be in the next DB2 for OS/390 release (V8??) is "online schema changes", otherwise known as "online alter". I talked to one of the DB2 developers at that conference about the capability to alter a column default, and he thought that it would be included in that feature. Obviously, there are no guarantees, and I have certainly not seen any details of how this new feature would work, but I am hoping that it eliminates the necessity of dropping and recreating tables to make changes like [...]
13257 110 32_Re: db2 for os/390 and websphere13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 19 Apr 2001 11:03:58 -0500379_iso-8859-1 Linda,
I agree with your comment "it depends". We have a lot of distributed applications, including via Websphere (the repository is NOT on the application server)and we have minimal stored procedure implementations yet we have no problems regarding network traffic, and time spent in the network in terms of applications is imperceptible to the customer. [...]
13368 72 32_Re: db2 for os/390 and websphere0_15_leon@CA.IBM.COM31_Thu, 19 Apr 2001 12:16:35 -0400374_us-ascii Starting with WebSphere 3.5.3 on Windows and UNIX you can now have repository stored on DB2 for OS/390 without doing any of the replication or other clever stuff. I have not tried it myself but a group that we have that looks after DB2 - WebSphere integration did run this and they say that it works "quite well". That is all the details I have at this point. [...]
13441 101 29_Re: Running utilities in REXX16_Janak Brahmbhatt26_jbrahmbh@NOTES.STATE.NE.US31_Thu, 19 Apr 2001 11:08:03 -0500541_iso-8859-1 Here is a example of calling librarian utility in REXX/ si.0=3 si.1='-OPT UTILITY' si.2='-EXTRACT 'cpymemb si.3='/*' address TSO 'alloc dd(sysin) new tr sp(1,1) reuse delete'; 'execio * diskw sysin (stem si. finis'; address TSO 'alloc dd(sysprint) new tr sp(1,1) reuse delete'; address TSO 'alloc dd(index) new tr sp(1,1) reuse delete'; address TSO 'alloc dd(list) new tr sp(1,1) reuse delete'; address TSO "alloc dd(master) dsn('"strip(FROMDSN)"') shr reuse"; address TSO "alloc dd(osjob) dsn('"strip(PDSDSN)"') shr reuse"; [...]
13543 47 48_Re: List of plans where column is used in update17_Belfield, Alma G.21_Alma.Belfield@TWA.COM31_Thu, 19 Apr 2001 11:26:55 -0500557_iso-8859-1 You can at least see plans (and packages) that have STATIC updates for the TABLE, if not the particular COLUMN. You can find plans (and packages) that contain a static UPDATE for a TABLE in SYSIBM.SYSTABAUTH - GRANTEETYPE = 'P' and UPDATEAUTH IN ('G','Y'). Only if the GRANT was for UPDATE on specific columns rather than the table will you also find rows in SYSIBM.SYSCOLAUTH for the plans (and packages) for the static update of a COLUMN of a table - GRANTEETYPE = 'P' and PRIVELEGE = ' '. Not sure if you have to select rows just for the [...]
13591 18 36_Re: DB2 v6 OS/390 on IBM zSeries 90012_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 Apr 2001 11:26:44 -0500315_- Sorry Phil, but let me try to paraphrase IBM. Bufferpools in data spaces do not work well until you have the zSeries box and (OS/390 V2R10 or z/OS). The performance is not dependent upon V7.
I'm looking forward to IDUG session: E9 - Performance beyond 2GB Real Akiko Hoshikawa, IBM Silicon Valley Lab [...]
13610 68 32_Re: db2 for os/390 and websphere13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Thu, 19 Apr 2001 13:42:26 -0400380_iso-8859-1 Could someone please tell me which "Database connectors" are available to me if I am accessing application data from DB2 for OS/390 via an HP or AIX Websphere environment? Are the connectors DB2 Connect, JDBC, DB2 stored procedures, something else? What has your experience shown to be the preferred method in terms of reliability and performance? Any Trade-offs? [...]
13679 21 25_Access Oracle data in DB215_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Thu, 19 Apr 2001 11:12:55 -0700398_- Is there a way for a OS/390 DB2 to access Oracle databases on HP-UX? We are currently able to access the DB2 data on the HP-UX server using Oracle's Transparent Gateway product. I'm hoping that there is a product that can do the reverse. Thanks for any help.
Dave Schaeffer Database Administrator Bendix CVS (a division of Honeywell Inc.) E-Mail: Dave.Schaeffer@Honeywell.com [...]
13701 124 36_Re: DB2 v6 OS/390 on IBM zSeries 90014_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 19 Apr 2001 19:15:42 +0100472_iso-8859-1 No problem Roger,
It's never bad to be corrected by yourself! (and I was nearly right after all!!)
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: 19 April 2001 17:27 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 v6 OS/390 on IBM zSeries 900 [...]
13826 52 48_Re: List of plans where column is used in update13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Thu, 19 Apr 2001 13:15:43 -0500326_us-ascii Compuware's DBA X-pert has a component that builds a table that lists all this information. When we first got it, response on this table was slow through the product, but programmers queried the table all the time using QMF to rapidly obtain the information you are looking for.
"S, Sanjeev (CTS)" wrote: [...]
13879 26 35_Re: Migration from DB2 v5 to DB2 v712_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 Apr 2001 13:05:10 -0500380_- I'm very opinionated, since I was the designer for a lot of the migration code and still work on it. The key questions for me are the timing, the value, and your experience and comfort level with newer code. The situation will be changing as we get more customers smoothing out the path. I tend to be conservative, but I'm a DB2 developer. Your choice is likely to differ. [...]
13906 37 29_Re: Access Oracle data in DB218_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 19 Apr 2001 14:36:53 -0400542_iso-8859-1 IBM's Datajoiner can access many different relational databases.
-----Original Message----- From: Schaeffer, Dave [mailto:dave.schaeffer@HONEYWELL.COM] Sent: Thursday, April 19, 2001 2:13 PM To: DB2-L@RYCI.COM Subject: Access Oracle data in DB2
Is there a way for a OS/390 DB2 to access Oracle databases on HP-UX? We are currently able to access the DB2 data on the HP-UX server using Oracle's Transparent Gateway product. I'm hoping that there is a product that can do the reverse. Thanks for any help. [...]
13944 32 41_Re: RACF and DB2 security setup questions12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 19 Apr 2001 13:29:14 -0500293_- It will depend upon which version of DB2 you are using and which level of the Security Server. The old book is good for the old Version 5, but we made a few improvements in Version 6 and a few more in Version 7. There are dependencies upon RACF APARs too. Here is my primary book list: [...]
13977 181 48_Re: List of plans where column is used in update14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 19 Apr 2001 19:41:22 +0100519_iso-8859-1 and without wanting to turn this into a product plug thread, Index Expert from CA was originally called Dependency Analyzer as that is one of it's functions.
It builds a database of dependency information between plans/packages and tables/columns down to which programs update/select which columns and even which columns (and column patterns) are used in Group By, order By etc. This is all information that Index Expert needs to ascertain what is the best set of indexes for a particular table. [...]
14159 41 32_DB2 v6 OS/390 on IBM zSeries 90012_Chris Munson18_cmunson@US.IBM.COM31_Thu, 19 Apr 2001 11:45:43 -0700465_us-ascii Besides what was already said about bufferpools in dataspaces being backed by real frames, the following are other benefits that DB2 can enjoy from a zSeries 900:
Performance - Faster uni processor which means overall a more powerful system footprint More Engines - the zSeries can be configured with 16 CP's which means more DB2 parallelism Faster compression - (four times that of a G6) Faster coupling links - for our data sharing customers [...]
14201 30 41_DB2 v5 Index Copy using DFDSS or DSN1COPY16_Ralph Parada Jr.15_rparada@CSC.COM31_Thu, 19 Apr 2001 13:36:35 -0500567_us-ascii In DB2 v5, I have a large partitioned tablespace with 1 NPI. While attempting to do a point in time (TOCOPY) recovery, the table space and the partitioned indexes are recovered in a resonable amount of time. However, the NPI takes an inordinate amount of time to recover.
My questions are: 1). When initally backing up the data with a Full Image Copy, could I have also stopped the tablespace and run a queisce to externalize any data, and then run an external copy function such as DFDSS or DSN1COPY to save the NPI so that it could be restored [...]
14232 60 29_Re: Access Oracle data in DB20_23_sjtoeniskoetter@AEP.COM31_Thu, 19 Apr 2001 15:06:02 -0400457_us-ascii We currently access Oracle on AIX from DB2 OS/390. We use Datajoiner to do it.
From 20,000 feet, you need to first install Datajoiner and configure the connection to Oracle, and second configure the CDB on DB2 OS/390 to talk to Datajoiner. However, we were not able to get DB2 OS/390 to talk directly to Datajoiner, so we cataloged the Datajoiner database in a DB2 AIX instance, and configured the CDB to talk to that DB2 AIX instance. [...]
14293 87 48_FW: List of plans where column is used in update13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 19 Apr 2001 15:14:57 -0400359_iso-8859-1 This technology built in DBA-XPERT is also a component of File-AID for DB2.
As Helen implies, the column usage information from SYSSTMT and SYSPACKSTMT are parsed and DB2 tables are populated which can be queried to find which programs update, select, order by, group by.... which columns. Insert, Delete information is also available. [...]
14381 23 48_For MVS REXX: Where would I find docs on DB2/SQL11_Daryl Wells18_dwwell1@US.IBM.COM31_Thu, 19 Apr 2001 15:29:51 -0400432_us-ascii For MVS REXX, where would I be able to find documentation on DB2/SQL (which is now available with version 6 of DB2)? We would like to convert our RX/SQL in our REXX to DB2/SQL.
------------------------------------------------------------------ From: Daryl Wells DB/DC Support IBM Global Services Tie Line 427-7487 Phone (813) 801-7487 Pager (800) 759-8888 pin 1366198 or http://www.skytel.com/Paging/index.html [...]
14405 20 44_Re: Checking DB2 Database/Table Availability13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Thu, 19 Apr 2001 14:51:56 -0500536_- Seems to me that the problem isn't how to check the table availability in CICS, but why the table is unavailable in the first place. Maybe the real fix is coming up with something that tells you what tables are unavailable.
When I was a programmer, our IMS online came up at 6 AM. I wrote a procedure that ran a batch display on all of the tables that we used, and then parsed the reply. A utility status would trigger a condition code which would trigger an email to the operator having them call the DBA. Of course, the [...]
14426 23 20_User Exit for UDB/NT14_Picou, Michael33_picou.michael@MAIL.DC.STATE.FL.US31_Thu, 19 Apr 2001 16:24:15 -0400365_iso-8859-1 Where can I find FULL documentation on using/modifying a user exit for the NT platform? I'm trying to figure out how to copy off the logs as they fill up TIA....
Technical support has been informed of the problem are currently working on a solution.... |\ _,,,---,,_ ZZZzz /,`.-'`' -. ;-;;, |,4- ) )-,_. ,\ ( `'-' '---''(_/--' `-'\_) [...]
14450 20 29_Re: Access Oracle data in DB215_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Thu, 19 Apr 2001 13:37:37 -0700549_- An additional question:
Is Datajoiner bi-directional, OS/390 DB2 to Oracle and also Oracle to OS/390 DB2? I'm hoping that I can get rid of Oracle Transparent Gateway.
Dave Schaeffer Database Administrator Bendix CVS (a division of Honeywell Inc.) E-Mail: Dave.Schaeffer@Honeywell.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.
14471 47 24_Re: User Exit for UDB/NT20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM31_Thu, 19 Apr 2001 20:47:57 -0000677_- Hi Michael
The exit in SQLLIB/SAMPLES/C/DB2UEXT2.CDISK contains all the info you need on what to change to get the exit working.
THT
Pav
>From: "Picou, Michael" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: [DB2-L] User Exit for UDB/NT >Date: Thu, 19 Apr 2001 16:24:15 -0400 > >Where can I find FULL documentation on using/modifying a user exit for the >NT platform? I'm trying to figure out how to copy off the logs as they fill >up >TIA.... > > >Technical support has been informed of the problem are currently working on >a solution.... > |\ _,,,---,,_ [...]
14519 46 24_Re: UDB Quick Reference?20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM31_Thu, 19 Apr 2001 20:50:32 -0000654_- Hi Steve
I am not sure such a beast actually exists (although it would be nice!!)
HTH
Pav
>From: Steve Westfall >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: [DB2-L] UDB Quick Reference? >Date: Wed, 18 Apr 2001 11:14:32 -0500 > >I have searched the DB2-L archives, the IBM web site, and Amazon.com for >this, but I haven't found it. > >Is there a quick reference summary for DB2 UDB? I have my small, handy, >spiral-bound reference summary for mainframe DB2 (version 4), and I'd like >to get something similar now that I'll be working with DB2 [...]
14566 27 27_DB2 connect & shadow tables11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Thu, 19 Apr 2001 16:20:59 -0500563_iso-8859-1 We have shadow tables that we use with DB2 connect so the users only see the tables they want rather than everything. When the shadow tables were originally created, it was through trial and error to determine what columns of which tables were needed and no documentation could be found on how to do it. Originally, we had DB2 Connect 5.2 and DB2 OS/390 5.1. Now we're at DB2 OS?390 6.1 and a co-worker is upgrading DB2 Connect to 7.1. When he connects via the 7.1 server, it complains about columns not existing in the shadow tables. Is there an [...]
14594 27 44_Re: Adding Partitions: DB2 V7 OS/390 support10_Rob Wright17_rwright@LIC.CO.NZ31_Fri, 20 Apr 2001 09:20:45 +1200390_us-ascii I sent an email stating DB2 V7 provides support for adding partitions to a partitioned tablespace. For some reason,
I had it in my head that this was the case. A number of people have questioned this, and now I can't find any supporting
documentation. Not wanting to be the initiator of an incorrect 'rumour', I want to state that I cannot backup that statement [...]
14622 21 25_DB2 Connect and MS Access17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Thu, 19 Apr 2001 14:38:51 -0700299_us-ascii Does anyone know of a way through MS Access to specify the amount of rows to retrieve from a DB2 table (on OS/390). When we use 'Get External Data' to retrieve the contents of a DB2 table there doesn't appear to be anyway to limit the number of rows that are retrieved from the table. [...]
14644 61 31_Re: DB2 connect & shadow tables0_15_leon@CA.IBM.COM31_Thu, 19 Apr 2001 17:46:03 -0400523_us-ascii Download the new version (v1.3.1) of DB2OCAT from ftp://ftp.software.ibm.com/ps/products/db2/tools/db2ocat.exe. I will create the tables with all the right columns for you on any version of DB2. For DB2 for OS/390 we added a number of new features that allow you control which database and tablespace the shadow catalog gets created in as well as lots of options for creating both the database and tablespace. Read "What's new" section in the help file for additional info. The best part is it is still free. [...]
14706 40 29_Re: Access Oracle data in DB213_Tzachi Nissim21_tzachi@ATTUNITY.CO.IL31_Fri, 20 Apr 2001 00:35:36 +0200678_iso-8859-1 You have Oracle Transparent Gateway to db2/os390 and you want to get rid of it? Just curious - what's wrong with it?
----- Original Message ----- From: "Schaeffer, Dave" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 19, 2001 10:37 PM Subject: Re: Access Oracle data in DB2
> An additional question: > > Is Datajoiner bi-directional, OS/390 DB2 to Oracle and > also Oracle to OS/390 DB2? I'm hoping that I can get > rid of Oracle Transparent Gateway. > > > Dave Schaeffer > Database Administrator > Bendix CVS (a division of Honeywell Inc.) > E-Mail: Dave.Schaeffer@Honeywell.com > [...]
14747 21 29_Re: Access Oracle data in DB215_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM31_Thu, 19 Apr 2001 15:02:22 -0700390_- >>From: Tzachi Nissim >> >>You have Oracle Transparent Gateway to db2/os390 and you want >>to get rid of t? Just curious - what's wrong with it? >>
If I can find a product that will allow me to access both OS/390 DB2 and Oracle, either direction, I can rid myself of a redundant product. We have been using Oracle's gateway for 3+ years and haven't had any problems using it. [...]
14769 72 29_Re: Access Oracle data in DB20_36_doreenrowland@NORTHWESTERNMUTUAL.COM31_Thu, 19 Apr 2001 17:43:32 -0500344_ISO-8859-1 I had installed the Oracle Gateway in the past on OS/390 for Oracle traffic to get to OS/390 DB2 via TNS and we had it at that company for years and it is still there. It was far less desirable then the Neon odbc Gateway and it had a bad problem that the vendor could never fix so we had to put a "checking procedure" in place. [...]
14842 41 12_DB2 v5 to v70_14_DPetro@AOL.COM29_Thu, 19 Apr 2001 19:11:36 EDT231_US-ASCII
Hi,
I realize that v7 is only recently gone GA but does anyone have any experiences, good or bad, they'd be interested in sharing regarding upgrading from v5 directly to v7? Any gotchas?
Thanks. Dave.
14884 49 21_Re: Adding Partitions11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 19 Apr 2001 20:34:02 -0400397_ISO-8859-1 Rob
Adding partitions without dropping the tablespace is not in V7 for OS/390. All you can alter is the partition key ranges, which came in with V6.
Regards Mike Turner Email: michael_turner@compuserve.com Web: www.michael-turner.ltd.uk
Message text written by DB2 Data Base Discussion List >DB2 V7 is the first DB2 on OS/390 that provides this functionality. [...]
14934 75 21_Re: Adding Partitions16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Thu, 19 Apr 2001 20:56:18 -0400690_us-ascii Hi, you can also alter priqty secqty while changing key ranges which should help some. HTH. Tom F
IBM WEBSITES FOR THE FUTURE
http://www.ibm.com/stretch/mindshare/ http://www.ibm.com/stretch/eos/index.phtml
Mike Turner on 04/19/2001 08:34:02 PM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Adding Partitions
Rob
Adding partitions without dropping the tablespace is not in V7 for OS/390. All you can alter is the partition key ranges, which came in with V6. [...]
15010 33 24_DB2 OS/390 Backup Policy17_Demetris Kasheris19_DKasheris@LAIKI.COM31_Fri, 20 Apr 2001 07:06:57 +0300583_us-ascii Hi List.
I am interested in finding out the DB2 Backup Policy that other sites are using.
In our site we have the following:
1. Before batch window starts we suspend log update activity(DB2 V6.1), take BRS backups (snap all db2 volumes) using snapshot to corresponding volumes which later we dump to tapes. Then we resume update activity.(2 min duration) 2. After BRS finish we take full copy operational backups for all tablespaces. This takes 50 min. As data grows though, we need to apply a different method to minimize the time of the backups. [...]
15044 60 29_Re: DB2 Connect and MS Access0_15_leon@CA.IBM.COM31_Fri, 20 Apr 2001 01:16:11 -0400526_us-ascii You do not specify the number of rows to retrieve when you are linking an external table. The process of linking a table does not actually retrieve any data. All it does is establish a connection between a real DB2 table and an MS Access table that acts as a proxy for this real table. You can, however, limit the number of rows returned by a query. The way you would do this in Access 2000 is - open a query in design mode and - select View, Properties from the pull down menus. You will get a Query Properties [...]
15105 74 28_Re: DB2 OS/390 Backup Policy23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 20 Apr 2001 06:27:30 +0100283_iso-8859-1 Hi we are 1.2 TB in size and growing.
We use backups to tape (optimized based on time - rexx). Each job has ONSITE and OFFSITE copies and we have 12 drives. end to end the process takes 7.5 hours. We have a DR build phase after this which takes an hour or so. [...]
15180 67 56_Re: stored procedure debugging on os390 using a cobol sp15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Fri, 20 Apr 2001 09:00:18 +0200432_iso-8859-1 Eric, What if you use WLM, I guess there won't be a problem regarding the limited number of DD statements..
Regards,
Jaap Slot DB2 DBA
tel: 0031 (0)30 2152220 fax: 0031 (0)30 2153003 J.P.Slot@rf.rabobank.nl
------------- Date: Thu, 19 Apr 2001 06:36:53 -0500 From: Eric Kwai Subject: Re: stored procedure debugging on os390 using a cobol sp [...]
15248 64 24_Re: User Exit for UDB/NT15_Christopher Tee24_chris.tee@TOTALISE.CO.UK31_Fri, 20 Apr 2001 08:31:30 +0100702_ISO-8859-1 There is also documentation in Appendix C of the Administration Guide: Implementation.
Chris
>===== Original Message From DB2 Data Base Discussion List ===== >Hi Michael > >The exit in SQLLIB/SAMPLES/C/DB2UEXT2.CDISK contains all the info you need >on what to change to get the exit working. > >THT > >Pav > > >>From: "Picou, Michael" >>Reply-To: DB2 Data Base Discussion List >>To: DB2-L@RYCI.COM >>Subject: [DB2-L] User Exit for UDB/NT >>Date: Thu, 19 Apr 2001 16:24:15 -0400 >> >>Where can I find FULL documentation on using/modifying a user exit for the >>NT platform? I'm trying to figure out how [...]
15313 57 44_Re: Adding Partitions: DB2 V7 OS/390 support23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 20 Apr 2001 09:23:08 +0100436_iso-8859-1 Rob
are you getting confused with the ability to re align the partitioning key?
Les
-----Original Message----- From: Rob Wright [mailto:rwright@LIC.CO.NZ] Sent: Thursday, April 19, 2001 10:21 PM To: DB2-L@RYCI.COM Subject: Re: Adding Partitions: DB2 V7 OS/390 support
I sent an email stating DB2 V7 provides support for adding partitions to a partitioned tablespace. For some reason, [...]
15371 70 36_Running DB2 utilities online in REXX14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Fri, 20 Apr 2001 09:46:34 +0100535_iso-8859-1 In reply to Scott Goodell's post of Tue, 21 Dec 1999:
>I'm trying to run the runstats utility from a REXX exec on DB2 MVS by calling >DSNUTILB. > > I keep getting the reason code 00E40002, which indicates an APF auth problem. > I don't have any other libraries in my steplib than I do if I just run a > plain runstats through DSNUTILB. I suspect our system is setup somehow to > not allow any TSO (IKJEFT01) program run authorized. Has anyone tried > this with any success or do you have any suggestions to try? [...]
15442 28 40_Re: Running DB2 utilities online in REXX15_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Fri, 20 Apr 2001 07:06:00 -0400294_iso-8859-1 Hi
Has anyone done a MS-Sqlserver to DB2 migration ? We are just getting our DB2 instance up and the task is to start converting the databases over to DB2, the MS Sqlserver versions are V7 sp3 and SQL2000. I have a few years experience with DB2 but that was 6 years ago. [...]
15471 41 52_Re: For MVS REXX: Where would I find docs on DB2/SQL11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Fri, 20 Apr 2001 08:11:42 -0400545_iso-8859-1 There is quite a bit in the APG (see attached). I also have some examples out on the DB2L Documents archive at http://jupiter.ryci.com/archives/db2-l-documents.html (see December 2000, October 2000, March 2000)
DB2 Universal Database for OS/390 Application Programming and SQL Guide Version 6 Document Number SC26-9004-01 Program Number 5645-DB
-----Original Message----- From: Daryl Wells [mailto:dwwell1@US.IBM.COM] Sent: Thursday, April 19, 2001 3:30 PM Subject: For MVS REXX: Where would I find docs on DB2/SQL [...]
15513 25 39_MSsqlserver migration to DB2 any tips ?15_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Fri, 20 Apr 2001 08:36:04 -0400485_iso-8859-1 Hi Has anyone done a MS-Sqlserver to DB2 migration ? We are just getting our DB2 instance up and the task is to start converting the databases over to DB2, the MS Sqlserver versions are V7 sp3 and SQL2000. I have a few years experience with DB2 but that was 6 years ago. Rich Richard A Sharpe DBA Amherst Corporate Computer Sales and Solutions 40 Continental Blvd Merrimack, NH 03054 Phone: (603) 579-6180 / 800-431-8031 Fax: (603) 578-1072 Email: rsharpe@amherst1.com [...]
15539 22 8_Question15_Kannan, Perumal22_perumal.kannan@EDS.COM31_Fri, 20 Apr 2001 03:00:46 -0500474_- Hello list, We are using DB2 Version 5 plus running under S/390. I have a question, one of my SE team needs a program which should access tables residing on two different database. Both the databases are in the same site and SUBSYSTEM. What will be the criteria if it is a distributed database. What are the things that the SE team needs to take care about? What will be the action that a DBA needs to take care. Can anybody give some explanation? Thanks in advance. [...]
15562 79 31_Re: DB2 connect & shadow tables11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Fri, 20 Apr 2001 08:25:28 -0500390_windows-1252 It looks good, but for some reason the "Advanced Options" button is grayed out and I can't specify database, bufferpool, etc. I couldn't find anything in help about how to enable it either.
Tina
-----Original Message----- From: leon@CA.IBM.COM [mailto:leon@CA.IBM.COM] Sent: April 19, 2001 4:46 PM To: DB2-L@RYCI.COM Subject: Re: DB2 connect & shadow tables [...]
15642 194 19_FW: Triggers Again!12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Fri, 20 Apr 2001 09:35:05 -0500608_iso-8859-1 > -----Original Message----- > From: Mark Cassity > Sent: Friday, April 20, 2001 9:05 AM > To: Mark Cassity > Subject: Triggers Again! > > We are OS 390 v.6. Recently we dropped and recreated a table that had > triggers defined on it. This table was initially created prior to version > 6. This table/tablespace was dropped to change the partitioning columns > of the partitioning index. After the tablespace was created, the table > created, indexes created, grants issued, synonyms created, data reloaded, > runstats, and all programs bound we created the triggers as they existed > before [...]
15837 120 29_System/Product Specifications14_Scott, Matthew18_MScott@ALFAINS.COM31_Fri, 20 Apr 2001 09:35:38 -0500383_iso-8859-1 I work for an Insurance Company that does business primarily in the southeast. We have roughly 2500 employees and do $450M in written premium annually. We are in the process of upgrading our legacy systems to third party applications which include Peoplesoft HR 7.51 and FIN 7.53, CSC/MYND/S3+, and SOLCORP. We will be running on OS/390 v2.9 with a DB2 v6.1 backend. [...]
15958 63 52_Re: For MVS REXX: Where would I find docs on DB2/SQL16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Fri, 20 Apr 2001 10:31:58 -0400641_us-ascii try IBM/DB2 DOC http://www-4.ibm.com/software/data/db2/library/ http://www.devx.com/gethelp/ hth Tom F
"Hayden, Lee" on 04/20/2001 08:11:42 AM
Please respond to DB2 Data Base Discussion List
To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: For MVS REXX: Where would I find docs on DB2/SQL
There is quite a bit in the APG (see attached). I also have some examples out on the DB2L Documents archive at http://jupiter.ryci.com/archives/db2-l-documents.html (see December 2000, October 2000, March 2000) [...]
16022 59 29_Re: DB2 STORED PROD: NUMTCB=?24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Fri, 20 Apr 2001 09:40:10 -0500549_- No bad sql code is generated when TCB's max out for stored procedures when DB2 queues your request waiting for a TCB and runs your stored procedure after a delay.
If you do a -DISPLAY PROCEDURE(*) command you can see if any queuing occured for any stored procedure... if so, you did max out on TCB's at some time. But when you do max out, DB2 will try to wait for a TCB to become available before killing your request. There is an installation (DSNZPARM) parameter which tells DB2 how long it should wait for a TCB to become available [...]
16082 26 25_QMF Binds as UR/DB2 OS39010_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Fri, 20 Apr 2001 10:00:49 -0500394_us-ascii Listers,
We would like to bind all our test, develop, QA & prod DB2 region QMF packages as UR to keep the QMF users from impacting the onlines. Is this an accepted practice and we've just not been bit by it before? Are we safe doing ALL packages under our QMF330 plan? They are currently all CS - is this a recommendation in the QMF Install Guide? (unavailable to me ATT). [...]
16109 142 29_Re: JDBC S806 abend On MVS OE17_KUSTERS, ED (TAO)30_ED.KUSTERS.tao@CCRA-ADRC.GC.CA31_Fri, 20 Apr 2001 11:06:00 -0400385_- Date: Friday, 20 April 2001 11:06am ET To: db2-l@ryci.com, lbates@JHANCOCK.COM Cc: JUNEAU.JOE, WEBSTER.MURRAY, CARRIERE.ANDRE From: KUSTERS.ED@RCT Subject: Re: JDBC S806 abend On MVS OE
Thanks for the reply on this Lisa. The problem was related to a missing STEPLIB as you mentionned. Wasn't sure how/where to code it and ibm provided the syntax and location as follows: [...]
16252 35 29_Re: Access Oracle data in DB222_Ramesh Balasubramanyan15_RAMBAL@SAIF.COM31_Fri, 20 Apr 2001 08:07:31 -0700409_iso-8859-1 Dave, You can use IBM's Relational Connect or its predecessor DATAJOINER. Oracle has a product called MVS Client that runs on OS390. This requiires special recompilation of the programs. Let me know if you want to know more
-----Original Message----- From: Schaeffer, Dave [mailto:dave.schaeffer@HONEYWELL.COM] Sent: Thursday, April 19, 2001 11:13 AM Subject: Access Oracle data in DB2 [...]
16288 47 29_Re: QMF Binds as UR/DB2 OS39011_David Nance16_DWNance@FHSC.COM31_Fri, 20 Apr 2001 11:10:50 -0400477_US-ASCII Missy, We have done this at applications I was with before and did again as soon as moving here. You just have to make your development staff aware that they are doing a dirty read and things may have already changed. There were some folks at last application who did not like this idea, but like I told them, if someone were to want to update/delete rows that they have just selected, the locks they just had will have been released prior to that action anyway. [...]
16336 106 31_Re: DB2 connect & shadow tables0_15_leon@CA.IBM.COM31_Fri, 20 Apr 2001 12:16:28 -0400456_us-ascii What is the database that you are pointing DB2OCAT to? The "Advanced" button is enabled only for DB2 for OS/390.
Leon Katsnelson Product Manager, DB2 Application Development and DB2 Connect mailto:leon@ca.ibm.com
Tina Hilton @RYCI.COM> on 04/20/2001 09:25:28 AM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List [...]
16443 21 30_Long Varchar logging, recovery11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 20 Apr 2001 10:01:44 -0700577_iso-8859-1 Hi all, I've got some questions concerning varchars/long varchars. Are there any differences in the way they are handled with respect to Image copies, logging and recovery. Specially would/could we have any problems recovering a 16k varchar table from a image copy.
Any comments would be appreciated. thanks, cliff:-)
================================================ 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.
16465 17 42_Sending long varchars/LOBs over a network.11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 20 Apr 2001 10:04:06 -0700372_iso-8859-1 Hi all, has anyone had any experience/issues sending large objects over a network to DB2/OS390.
Thanks, cliff:-)
================================================ 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.
16483 43 29_Re: QMF Binds as UR/DB2 OS3909_Birk, Tim17_BirkT@DIEBOLD.COM31_Fri, 20 Apr 2001 13:22:54 -0400423_iso-8859-1 Missy,
Perhaps a better way to use UR in QMF would be to set the global variable DSQEC_ISOLATION=0. If you do this in the Q.SYSTEM_INI proc, it will be automatically set for all QMF users.
Tim Birk Diebold, Inc.
-----Original Message----- From: Missy Case [mailto:Missy.Case@FIRSTDATACORP.COM] Sent: Friday, April 20, 2001 11:01 AM To: DB2-L@RYCI.COM Subject: QMF Binds as UR/DB2 OS390 [...]
16527 101 56_Re: stored procedure debugging on os390 using a cobol sp10_Ben Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Fri, 20 Apr 2001 13:48:53 -0400305_us-ascii i have just added the run options 'msgfile.....' clause. i also specified within the msgfile option a ddname other than sysout. however my messages are still going to sysout. it seems that this run option is not taking effect. could it be because i am running by sproc under wlm? any ideas? [...]
16629 21 41_Is Any Function for AutoNumber Generation17_Rabindra Senapati21_rsenapati@HOTMAIL.COM31_Fri, 20 Apr 2001 13:03:19 -0500
16651 39 53_DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX15_Robert lawrence21_rlawrence@BOSCOVS.COM31_Fri, 20 Apr 2001 14:14:29 -0400423_iso-8859-1 Hello list, I now have another question. I have bound the DSNTIAUL program(DSNESPM68?) package on remote AIX UDB location. I am now trying to run it with the following SQL:
CONNECT TO INV_MCHT ; SELECT * FROM DB2COMMN.STORE;
and receive the following messages:
CONNECT TO INV_MCHT CONNECT SUCCESSFUL DSNT400I SQLCODE = 000, SQLSTATE = 00000, UNQUALIFIED SUCCESSFUL COMPLETION FROM OS/2 [...]
16691 141 56_Re: stored procedure debugging on os390 using a cobol sp14_Toppins, Smike21_smike.toppins@GWL.COM31_Fri, 20 Apr 2001 12:16:52 -0600661_iso-8859-1 I believe you need to -STOP the procedure and then -START it again to have the modifications take effect.
SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094
> ---------- > From: Ben Reches[SMTP:Benjamin.Reches@MORGANSTANLEY.COM] > Reply To: DB2 Data Base Discussion List > Sent: Friday, April 20, 2001 11:48 AM > To: DB2-L@RYCI.COM > Subject: Re: stored procedure debugging on os390 using a cobol sp > > i have just added the run options 'msgfile.....' clause. i also specified > within the msgfile option a ddname other than sysout. however my messages > are still going to sysout. it seems that > [...]
16833 16 39_Re: Excess Logging with SHRLEVEL CHANGE9_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 20 Apr 2001 13:07:58 -0500324_- REORG SHRLEVEL CHANGE only allows LOG NO. Since your tablespace is compressed it is likely that a new dictionary is being built and some special processing is required. Try running with KEEPDICTIONARY specified and see if the logging is more what you would expect.
Jim Ruddy DB2 fo z/OS and OS/390 Development [...]
16850 30 32_Trigger calling Stored Procedure0_26_mark.walker@CUNAMUTUAL.COM31_Fri, 20 Apr 2001 13:27:12 -0500566_us-ascii Hi all,
Our environment is DB2 V6 OS/390.
After hearing a number of sources indicate that a trigger calling stored procedures can be a good thing, we've come up with a situation where we want to try it. My problem is that I don't know how to handle errors. If the stored procedure gets an unexpected sqlcode, how do I let the trigger know that something bad happened? I don't want to make the stored procedure abend (thus causing the CALL that invoked it to fail) since that seems like kind of a harsh approach. Since I can't declare any [...]
16881 112 56_Re: stored procedure debugging on os390 using a cobol sp10_Mike Hsiao20_mike.hsiao@SABRE.COM31_Fri, 20 Apr 2001 13:39:29 -0500580_us-ascii Ben,
You need to specify the compiler option to write to that ddname when you compile your SP program. The default ddname is SYSOUT.
Thanks, Mike Hsiao
Ben Reches wrote:
> i have just added the run options 'msgfile.....' clause. i also specified within the msgfile option a ddname other than sysout. however my messages are still going to sysout. it seems that > this run option is not taking effect. could it be because i am running by sproc under wlm? any ideas? > > Eric Kwai wrote: > > > Just a word of caution. We have COBOL [...]
16994 70 45_Re: Is Any Function for AutoNumber Generation19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 20 Apr 2001 13:43:55 -0500611_iso-8859-1 Rabi, check out IDENTITY columns . . .
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." [...]
17065 52 57_Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Fri, 20 Apr 2001 14:47:02 -0400395_iso-8859-1 Bob:
I have not used dsntiaul from os390 going to AIX. I have used dsntep2 successfully. I am just guessing here but do you have PARMS(SQL) coded.
Manas. ===================================== Hello list, I now have another question. I have bound the DSNTIAUL program(DSNESPM68?) package on remote AIX UDB location. I am now trying to run it with the following SQL: [...]
17118 23 18_track all requests17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Fri, 20 Apr 2001 14:54:02 -0400293_iso-8859-1 Hello everyone,
We are using DB2 v6.1 on AIX.
The goal at our shop is to keep track of every request made to the database. We need to know who did what and when. Is anyone out there doing this?? If so, please let me know. I would like to ask you a few questions. [...]
17142 68 36_Re: Trigger calling Stored Procedure16_Charles F Creech24_cfcreech@DUKE-ENERGY.COM31_Fri, 20 Apr 2001 14:54:49 -0400501_us-ascii Looks like the Version 6 transition class might be of big help to you. There is a section in the Student Notebook that covers 35 pages about triggers, including how to handle error situations. Page 4-135 in Unit 4 states: "When a user-defined function or stored procedure is invoked from a trigger, and that function or procedure returns a negative SQLCODE, the trigger execution will terminate and all database changes performed as part of the triggering operation will be backed out." [...]
17211 71 57_Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX15_Robert lawrence21_rlawrence@BOSCOVS.COM31_Fri, 20 Apr 2001 15:17:34 -0400589_iso-8859-1 yes it is
> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Manas Dasgupta > Sent: Friday, April 20, 2001 2:47 PM > To: DB2-L@RYCI.COM > Subject: Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX > > > Bob: > > I have not used dsntiaul from os390 going to AIX. I have used dsntep2 > successfully. > I am just guessing here but do you have PARMS(SQL) coded. > > Manas. > ===================================== > Hello list, > I now have another question. I have bound the DSNTIAUL > program(DSNESPM68?) > [...]
17283 44 36_Re: Trigger calling Stored Procedure10_Ben Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Fri, 20 Apr 2001 15:36:05 -0400340_us-ascii my experience in this matter is both with C sprocs (written and compiled on os390) and with SPL sprocs BUILT by the S.P.B.
in both cases whenever an sql exception occurs, i issue a C abort() and this generates a negative sqlcode back at the client code. this requires that the sproc which issued an abort be restarted. [...]
17328 96 57_Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX0_23_sjtoeniskoetter@AEP.COM31_Fri, 20 Apr 2001 15:35:39 -0400532_us-ascii Bob,
I hate to possibly spread mis-information here and this is off the top of my head so I may be wrong, but I don't think you can use the connect statement with DSNTIAUL. Which version of DB2 are you running on OS/390? Version 5 only supports 3 part names in private protocol, and DRDA is needed to get to AIX. If I'm correct that you can't use the connect statement in DSNTIAUL then you can't use DSNTIAUL for this in version 5. Version 6 supports 3 part names in DRDA so you could use it to access AIX with [...]
17425 92 36_Re: Trigger calling Stored Procedure13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Fri, 20 Apr 2001 15:59:25 -0400512_iso-8859-1 I just attended a Trigger class from Claussen & Associates (It's a new class). Another alternative discussed there was storing the SQL code in a table and having the trigger store the SQL code result in a table. The table could then be accessed by the trigger and the results reviewed via a select.... You can set your own SQLSTATE and message text in the trigger also using RAISE_ERROR. This will result in a -438 SQL code being raised. Any negative SQL code will rollback all work performed... [...]
17518 95 57_Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX0_23_sjtoeniskoetter@AEP.COM31_Fri, 20 Apr 2001 16:41:28 -0400353_us-ascii Bob,
Regarding my earlier note where I said I didn't think the connect statement was allowed in DSNTIAUL, I was wrong. I found this in the manual:
| Because these three programs also accept the static SQL statements | CONNECT, SET CONNECTION, and RELEASE, you can use the programs to access | DB2 tables at remote locations. [...]
17614 28 34_Re: Multi Streaming of DB2 program11_Mark Harmon17_mhinnyc@YAHOO.COM31_Fri, 20 Apr 2001 15:36:32 -0500373_- Hello,
If the multiple streams access the same DB2 table (not the main table which you will partition) they will obviously contend with each other. Also, having multiple streams access the main partitioned table, increases the likelihood of lock contention on this table between your multiple streams (which will not contend with each other) and other users. [...]
17643 138 57_Re: DSNTIAUL running on DB2 OS390 V5 to access UDB on AIX9_Chris Tee24_chris.tee@TOTALISE.CO.UK31_Fri, 20 Apr 2001 23:09:22 +0100442_iso-8859-1 Bob,
I'm sure I've used DSNTIAUL to get data from AIX before (I'm not currently working in a mainframe environment so I can't test it). It looks like the problem is that AIX doesn't like the semicolon at the end of the SQL statement. The one at the end of the CONNECT will still be required as this is executing on OS/390. I'm a bit puzzled by your reference to DSNESPM68 (DSNESM68 perhaps?) as this is the SPUFI DBRM. [...]
17782 57 35_Re: Triggers / Before Trigger Issue11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Fri, 20 Apr 2001 15:35:09 -0700326_iso-8859-1 Brian, I'm very familiar with your problem, that APAR mine (I opened the ETR). The APAR didn't fix the problem. I just got a response back from IBM, they have another PTF to apply (apar PQ47080/ptf UQ53145) but it won't be available until May 30. If you need it now you can contact IBM and ask for a APAR FIX. [...]
17840 246 32_Re: db2 for os/390 and WebSphere12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 20 Apr 2001 16:45:00 -0700465_us-ascii Lynne, You can speak for me any time. You've made my point better than I could. Certainly having the application real data remotely is fine. In fact, it might in a number of cases be preferred.
Although Leon is now saying that you can "easily" put the WAS database remotely on OS/390 now with Websphere 3.5.3, I'm still not entirely convinced that that is necessarily a good design idea. As Linda says "It depends upon the application design." [...]
18087 78 56_Re: stored procedure debugging on os390 using a cobol sp9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Fri, 20 Apr 2001 20:06:11 -0500627_- Jaap: We are moving to WLM SPAS shortly. IBM had a suggestion which is to change the printf to fprintf, but I have not have a chance to test it yet. Eric
On Fri, 20 Apr 2001 09:00:18 +0200, Slot, JP (Jaap) wrote:
>Eric, >What if you use WLM, I guess there won't be a problem regarding the limited >number of DD statements.. > >Regards, > >Jaap Slot >DB2 DBA > >tel: 0031 (0)30 2152220 >fax: 0031 (0)30 2153003 >J.P.Slot@rf.rabobank.nl > > >------------- >Date: Thu, 19 Apr 2001 06:36:53 -0500 >From: Eric Kwai >Subject: Re: stored procedure [...]
18166 123 56_Re: stored procedure debugging on os390 using a cobol sp9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Fri, 20 Apr 2001 20:21:29 -0500327_- Ben: I think Mike Hsiao just answered your question, in order to change the sysout. You have to do it in the compile. The ENQ will only help DB2 to serialize the display to avoid 02A abend to your specific dd statement. HTH, Eric On Fri, 20 Apr 2001 13:48:53 -0400, Ben Reches wrote: [...]
18290 25 12_PHP4 and DB214_Hrishiraj Nair28_hrishirajnair@REDIFFMAIL.COM31_Sat, 21 Apr 2001 02:23:18 -0000392_- HI Chris,
How do I use DB2 with PHP4? I beleive there is an option to configure PHP4 as --with-ibm-db2. This is supposed to give a Unified ODBC support.
Can I have a sample code to demonstrate this.
Thanks. Raj
_____________________________________________________ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com [...]
18316 15 54_Barbara Kilburn/Santa Teresa/IBM is out of the office.15_Barbara Kilburn19_bkilburn@US.IBM.COM31_Sat, 21 Apr 2001 00:32:44 -0600397_us-ascii I will be out of the office starting April 20, 2001 and will not return until April 23, 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.
18332 42 45_Re: Is Any Function for AutoNumber Generation16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sat, 21 Apr 2001 07:48:34 +0100455_us-ascii Rabi,
IDENTITY columns may be the answer to your question, depending on what you have to do with your "counter" at a later date (not advisable to try and index those columns, for example, for a number of reasons).
HTH.
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 [...]
18375 99 43_Re: MSsqlserver migration to DB2 any tips ?16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sat, 21 Apr 2001 08:10:40 +0100276_us-ascii Richard,
in June of last year, Martin Spratt of IBM posted a note on GA Version of a Free DB2 v7 Migration Tool.
don't know if this could be of use to you, or even if it's still free! but in any case check his post out, also you can have a look at [...]
18475 15 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM31_Sat, 21 Apr 2001 02:17:52 -0500447_us-ascii I will be out of the office from 04/20/2001 until 04/23/2001.
If you need assistance with DB2, use PIN # 7270526, for informix/sqlserver use PIN # 7270525, network issues use PIN # 7271038.
================================================ 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.
18491 34 75_The right procedure to change CCSID from 500 to 420 of existing user data .24_Islam Abdelaleem Mohamed17_aleemi@EG.IBM.COM31_Sat, 21 Apr 2001 12:00:37 +0300554_us-ascii Hello list, Thanks for your time and I appreciate your help . ENV: VSE/ESA R241 and DB2 R610 Can someone guide me to the right procedure to change the CCSID from International 500 to Arabic 420 . I found I can't do that with UNLOAD DBSPACE nor UNLOAD TABLE and alter CCSID value during RELOAD DBSPACE , RELOAD TABLE . and IF the only way through DATAUNLOAD and DATALOAD (Could you please specify the right steps ) . as I think 1- Do DATAUNLOAD for all existing user data . 2- Change the SERVER startup option CHARNAME from INTERNATIONAL to [...]
18526 135 79_Re: The right procedure to change CCSID from 500 to 420 of existing user data .16_Aurora Dell'Anno28_Aurora_E_DellAnno@CANDLE.COM31_Sat, 21 Apr 2001 12:01:42 +0100484_us-ascii Islam,
the procedure to follow is the following (clearly detailed in chapter 12 of the DB2 Server for VSE and VM v. 6.1 System Administration Guide):
if you are trying to change the data format in an existing column:
UNLOAD with the DBSU's capabilities (DATAUNLOAD in your case) DROP the existing table re-CREATE the table specifying the new CCSID attribute for the column or columns that you want to change reLOAD the data (DATALOAD in your case). [...]
18662 64 34_Re: Multi Streaming of DB2 program13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Sat, 21 Apr 2001 08:31:34 -0500321_us-ascii We have are tables set up that they are partitioned by an indexed column..... The jobs are setup to process by segments, and we altered a key field on the restart db so that each segment has it's on row on the restart db... no problems with lock contention, because each program is in a different partition [...]