1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2000, week 2 2 93 20_Re: high bsds access7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Tue, 8 Aug 2000 13:23:39 +0530476_iso-8859-1 Tom, WRTHRSH is used for Log OUTBUF and externalization of Output buffers takes place in the cases mentioned by Ashish i.e reaching WRTHRSH(Asynchronous) ,Application Commit(Synchronous) and full output buffers(Synchronous).

However, the case of full output buffers can only be reached if there is very less gap between the WRTHRSH and OUTBUF i.e while the buffers are externalized asynchronously more log records are written and output buffer is full. [...] 96 36 51_Implementation strategies for triggers in companies18_Blumer Hans-Ulrich32_Hans-Ulrich.Blumer@WINTERTHUR.CH30_Tue, 8 Aug 2000 12:06:37 +0200395_iso-8859-1 Answers to the following questions help us in implementation strategies for the environment of DB2/OS390, but experience may come from DB2/2 or Oracle or anywhere. 1. How and where do companies document their information about triggers? 2. What kind of arguments do companies use to limit the implementation of triggers. Again I ask companies who already cope with this subject. [...] 133 43 18_RDS LIMIT EXCEEDED13_Othman Kidwai22_kidwaiom@ARAMCO.COM.SA30_Tue, 8 Aug 2000 05:17:34 -0500465_- HI,

our BMC/AM reports the following

[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[

----RID Pool Processing --- Current Changed Minimum Maximum Current RID Blocks 0 0 0 0 Maximum RID Blocks Allocated 402 402 402 402 Invalid SELECT Procedure 3959K 3959K 3959K 3959K List Has Too Many RIDS 0 0 0 0 List Exceeded Storage Limit 0 0 0 0 List Exceeded RDS Limit 15918 15918 15918 15918 List Exceeded DM Limit 0 0 0 0 [...] 177 254 73_AW: UNICODE data in a DB2 for OS/390 Version 5 table - here's an idea ...12_Peter, Georg15_G.Peter@DZBW.DE30_Tue, 8 Aug 2000 13:21:18 +0200518_iso-8859-1 Stephen an all other people who had answered: Thank you very very much for all the help.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 432 36 19_Question on indices14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE30_Tue, 8 Aug 2000 13:54:05 +0100321_us-ascii Esteemed List,

has anyone out there ever coded a query to filter out duplicate indices ? For example: There are two indices on one table, index one has col1 and col2, index two has col1, col2 and col3 which makes index nr. one superfluous.

TIA Ruediger Kurtz









469 29 33_File/Working Storage Var. Diff ??19_Sarosh Mathew Koshy22_sarosh.koshy@WIPRO.COM30_Tue, 8 Aug 2000 17:41:53 +0530336_us-ascii Hi,

Some time back, I experienced weird unexplainable problems when I used a variable declared in a FILE layout of a COBOL program in a DB2 cursor. The cursor wouldn't fetch the right rows from the table. MOV(E)ing the file variable value to working storage and using that variable in the cursor cured the problem. [...] 499 30 37_Re: File/Working Storage Var. Diff ??13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 8 Aug 2000 08:36:58 -0400465_iso-8859-1 >Any pointers on this would be helpful. Thanks in advance,

How about a pointer to the Application Programming and SQL Guide http://www.s390.ibm.com:80/bookmgr-cgi/bookmgr.cmd/Shelves/DSNSH0G2 (then open the above book. The quote below is in section 3.4.3.4)

where it says:

"You must explicitly declare all host variables used in SQL statements in the WORKING-STORAGE SECTION or LINKAGE SECTION of your program's DATA DIVISION." [...] 530 32 22_Re: RDS LIMIT EXCEEDED14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT30_Tue, 8 Aug 2000 14:39:16 +0100378_us-ascii Did you (recently) migrate from DB2 V4 to DB2 V5 ? Just a curiosity (high value in "Invalid SELECT Procedure" field).

Anyway it may be not sufficient to increse MAXRBLK, we had some Multiple Index Access access causing RID failures and

we had to modify SQL to avoid RID failures (may be you need only (reorg)+runstats+rebind of some plans/packages). [...] 563 60 18_Insert performance0_19_david.a.owen@BT.COM30_Tue, 8 Aug 2000 13:47:43 +0100543_- Mike, I gave a presentation on this at IDUG in Dallas in May. If you want a copy of the presentation I can make it available.

The effects on CPU time could be down to a No of things.

* The frequency of commits will have a direct impact on the CPU time, the more frequent you commit the more likely this will increase the CPU time. This is down to 2 things: * the loss of the Index Lookaside control blocks, the Dynamic Prefetch counters being refreshed and the IPROC needing to be rebuilt. Index Lookaside helps to reduce [...] 624 102 44_Re: -508 or When is cursor positioning lost?17_William R. Miller32_william.miller@DRESDNER-BANK.COM30_Tue, 8 Aug 2000 07:41:14 -0500566_- Venkat, I, too, think that we've come across a DB2 bug. The sysprogs updated to the latest maintenance on the system last weekend, so I'm hopeful the bug is no longer around.

I can only guess as to why someone would want to update a cursor multiple times (It's not my program). The schematic of the logic was somewhat simplified. In the overwhelming majority of the time, the first update is the only one needed. Following that is some complex logic. Then, based on what was inserted and selected, the status would be set to another value. If you look [...] 727 260 29_Re: Stored Procedure Question0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Tue, 8 Aug 2000 08:11:50 -0500352_us-ascii Hi Carlton, The request form we have programmers submit to DBAs for table , index or stored procedure request is in a Lotus Notes database (soon to be changed and stored on the web) For some reason I'm unable to copy the request form and paste it so I'll just list the items we ask for. This is geared for V5 and is being changed for V6. [...] 988 288 21_Re: Help asap please.9_Harish P.21_emailharish@YAHOO.COM30_Tue, 8 Aug 2000 07:58:28 -0500628_- Firstly, to all, thanx very much for all the responses.

Rajeev,

We have been doing some investigation on your solution. Just to recheck that this is exactly what you mean, heres what we have understood.

A table will have a new column "GroupID" added to it. This GroupID column will have values say COLLECTIONIDA, COLLECTIONIDB... A view will be created on the table based on the value of the GroupID, and that hides this new column from the application. A new table of GroupID (COLLECTIONIDA, COLLECTIONIDB..) versus UserID (TSOID1, TSOID2..) will be created so that the GroupID can be transparently [...] 1277 10 15_Re: DB2 Locking10_Bill Brown25_bill_brown@SPRINGMAIL.COM30_Tue, 8 Aug 2000 09:17:17 -0400451_- Word of caution when you allow lock escalation to occur. If you are running batch and online concurrently, a batch program could have a severe impact on your online system when escalation goes to tablespace.

================================================ 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. 1288 10 23_To commit or not commit11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM30_Tue, 8 Aug 2000 09:27:29 -0400331_- We have a hated battle going on in our shop over issing commits in read only programs. We are v5 os/390 with 2 way data sharing. some dbas say that we should issue commits in read only programs to allow utilities to drain properly. other dbas say that this is not necessary. Anyone have the real answer?????? Thanks to all. [...] 1299 324 21_Re: Help asap please.19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 8 Aug 2000 08:32:44 -0500352_ISO-8859-1 Harish, I REPEAT: The best solution, and I think the only viable one, is using different ownerid/creator names. It could be suggested that the DBAs and ENDEAVOR folks could use a little training in how to support a multi-ownerid/creator name environment that would encourage productivity rather than 'shade tree mechanic' work-arounds. [...] 1624 28 18_Package Privileges13_Michael Fleck14_m.fleck@LVR.DE30_Tue, 8 Aug 2000 15:26:34 +0100348_ISO-8859-1 Hello everybody,

maybe that's a simple question, but we're working with packages for the first time and we have some problems with user authorizations. Which privilege does a user need to bind or to add a package to a collection when he's not the owner of the package.

Thanks in advance and best regards Michael Fleck [...] 1653 78 22_Re: Package Privileges16_Thirumal Valavan31_thirumal.valavan@PRUDENTIAL.COM30_Tue, 8 Aug 2000 09:40:38 -0400685_us-ascii



Hai,

He needs BIND and EXECUTE authority on the package without grant option



Thirumal





Michael Fleck Tuesday August 8, 2000 10:26 AM

Please respond to DB2 Data Base Discussion List To: DB2-L@RYCI.COM cc: (bcc: Thirumal Valavan/IIG/Prudential) Subject: Package Privileges





Hello everybody,

maybe that's a simple question, but we're working with packages for the first time and we have some problems with user authorizations. Which privilege does a user need to bind or to add a package to a collection when he's not the owner of the package. [...] 1732 77 25_Re: Can I backout a bind?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Tue, 8 Aug 2000 08:45:02 -0500264_iso-8859-1 No, there is no way to back out a bind. In V6 you could have saved your access path and told the optimizer to use it again, if desired, using hints. I don't know much about it but that is a direction you can look for next time whenever you get V6. [...] 1810 359 21_Re: Help asap please.0_19_mike.holmans@BT.COM30_Tue, 8 Aug 2000 14:43:30 +0100342_iso-8859-1 ME TOO. It is actually pretty easy to manage an environment with multiple copies of the same database. We have a project which had at the height of development and testing activity had 63 database images representing four versions of the database schema, all running in the same subsystem, serviced by about ten CICS regions. [...] 2170 56 22_Re: Package Privileges0_19_mike.holmans@BT.COM30_Tue, 8 Aug 2000 14:45:04 +0100359_iso-8859-1 The package owner needs to grant BINDAGENT to the user so that the user can then specify OWNER(xyz) and the bind process will bind as though the user was the owner.

Mike Holmans BT ISE Technical Design mike.holmans@bt.com

This post represents the views of the author and does not necessarily accurately represent the views of BT [...] 2227 39 29_db2 V6 crashed using DSNTIAUL23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Tue, 8 Aug 2000 14:49:43 +0100336_iso-8859-1 Just to let you all know that I have just had DB2 crash using DSNTIAUL in V6.

DB2 Crashed immediately after a thread terminated due to unavailable resource type 700 .. 8K pool.

I was unloading a table that was in an 8K pageset and the vpsize of the pool was 0 - by accident .. and boomb .. no db2 anymore. [...] 2267 58 23_Re: Question on indices11_Suresh Sane21_data_arch@HOTMAIL.COM28_Tue, 8 Aug 2000 08:52:28 CDT634_- I presented 2 sql solutions to this at the last IDUG (Dallas) - session titled "SQL Solutions for a DBA's Wish List". If you cannot get to it or would like the sql text, send me an email offline.

HTH

Suresh Sane



>From: Ruediger Kurtz >Reply-To: ruediger.kurtz@huk-coburg.de >To: DB2-L@RYCI.COM >Subject: Question on indices >Date: Tue, 8 Aug 2000 13:54:05 +0100 > >Esteemed List, > >has anyone out there ever coded a query to filter out duplicate indices >? >For example: There are two indices on one table, index one has col1 and >col2, index two has col1, col2 and [...] 2326 28 44_DB2 ODBC (optimized) Catalog tables - "OCAT"0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Tue, 8 Aug 2000 09:08:06 -0500568_us-ascii Does anyone know where I can go to find DETAIL information about the DB2 ODBC (optimized) Catalog tables. Sometimes these are known as OCAT. I notice that CAE can be configured so that information can be retrieved from the OCAT catalog in a way that makes several ODBC functions much more efficient. I went to the IBM site and downloaded the tool that they have available for the DB2 optimized catalog. When I ran this, it went ahead and defined the optimized tables in DB2 but something failed and it did not populate the tables. I would really like to [...] 2355 86 22_Re: Insert performance13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Tue, 8 Aug 2000 10:20:48 EDT584_- Hi Mike, Please include this mail address as one of the recipient for a copy of IDUG presentation.. Thanks Carlton



>From: david.a.owen@BT.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Insert performance >Date: Tue, 8 Aug 2000 13:47:43 +0100 > >Mike, > I gave a presentation on this at IDUG in Dallas in May. >If you want a copy of the presentation I can make it available. > >The effects on CPU time could be down to a No of things. > >* The frequency of commits will have a direct impact on the CPU time, >the more [...] 2442 921 11_DB2 Connect10_Lee Herbst29_lherbst@PROPAPPR.MARION.FL.US30_Tue, 8 Aug 2000 10:07:03 -0400531_iso-8859-1 I have DB/2 on VM (MCPADB) and DB/2 on NT (OASIS) (all are version 6). I have Capture running on VM, I have a source and subscription defined. When I run apply, I get an error getting the timestamp from the VM side with a 551 SQLCODE (not authorized), however the userid and password I am using has DBA authority. Below you will find a trace of the apply attempt. I have gone through book after book, including redbooks and I can't find an answer to my problem. Does anybody have any idea of what is wrong? Thanks. [...] 3364 47 22_Re: Package Privileges17_Fiorese Giampaolo29_Fiorese.Giampaolo@GENERALI.IT30_Tue, 8 Aug 2000 16:32:47 +0200502_iso-8859-1 Look at the bindagent privilege. Regards

-----Original Message----- From: Michael Fleck [SMTP:m.fleck@LVR.DE] Sent: Tuesday, August 08, 2000 3:27 PM To: DB2-L@RYCI.COM Subject: Package Privileges

Hello everybody,

maybe that's a simple question, but we're working with packages for the first time and we have some problems with user authorizations. Which privilege does a user need to bind or to add a package to a collection when he's not the owner of the package. [...] 3412 79 23_Re: Question on indices13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Tue, 8 Aug 2000 10:31:46 EDT603_- Hi Suresh, Was following this thread and will like to get a copy of your IDUG (Dallas) presentation - "SQL Solutions for a DBA's Wish List" Thanks CArlton





>From: Suresh Sane >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Question on indices >Date: Tue, 8 Aug 2000 08:52:28 CDT > >I presented 2 sql solutions to this at the last IDUG (Dallas) - session >titled "SQL Solutions for a DBA's Wish List". If you cannot get to it or >would like the sql text, send me an email offline. > >HTH > >Suresh Sane > > [...] 3492 65 37_Re: File/Working Storage Var. Diff ??20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 8 Aug 2000 10:40:03 -0400523_us-ascii Sarosh

The story of differences between file variable and Working storage variables starts from the pre-compiler. The pre-compiler has to replace the SQL with calls to Language Interface (LI) and also it includes many working storage variables with group name SQL-PLIST for its own use. The host variables used in your SQL are passed to DB2 as addresses. The working storage variables have same addresses during multiple executions while your file variables keep changing their addresses or locations. [...] 3558 26 52_Help!! How to Refresh Store Procedure in Prime Time!13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Tue, 8 Aug 2000 10:41:59 EDT468_- Hi List, I'm new at this and will like top know how I can refresh a Stored Procedure that I have just been modified. I have changed the stored procedure, so that it prints to a file, but after calling the stored proc the file has not been updated. Everything looks okay when I issue the CALL command from the client program because it returns a SQLCODE of 0. However, the host variables that I passed to the stored procedure do not have the appropriate values. [...] 3585 72 60_-102 trying to insert and/or update pamlist in SYSPROCEDURES13_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Tue, 8 Aug 2000 09:37:19 -0500763_US-ASCII Hello, We are Db2 v5.1 OS390 2.8 ... We are very new to stored procedures and have a small problem.

I was trying to run the following SQL to add a procedure :

INSERT INTO SYSIBM.SYSPROCEDURES (PROCEDURE, AUTHID, LUNAME, LOADMOD, LINKAGE, COLLID, LANGUAGE, ASUTIME, STAYRESIDENT, IBMREQD, RUNOPTS, PARMLIST) VALUES ('SS001L20','','','SS001L20','', 'SS001L20','COBOL',0,'','N','', 'SYSNAME CHAR(008) IN, PROGNAME CHAR(008) IN, CICSRESP INTEGER OUT, IOAREA01 CHAR(254) INOUT, IOAREA02 CHAR(254) INOUT, IOAREA03 CHAR(254) INOUT, IOAREA04 CHAR(254) INOUT, IOAREA05 CHAR(254) INOUT, IOAREA06 CHAR(254) INOUT, IOAREA07 CHAR(254) INOUT, IOAREA08 CHAR(254) INOUT, IOAREA09 CHAR(254) INOUT, IOAREA10 CHAR(254) INOUT, IOAREA11 CHAR(254) INOUT'); [...] 3658 133 28_Re: Data Propagator question20_Alvarez, Maximiliano20_MAXIMILIANO@IADB.ORG30_Tue, 8 Aug 2000 10:47:35 -0400320_iso-8859-1 I would like to add one more point to the discussion. On DB2 OS/390 v5.1, If I attempt to change a primary key value in a parent table, DB2 as expected doesn't commit the change. But... still the attempted change is replicated to the target table (user copy) as if it were committed on the source table. [...] 3792 77 56_Re: Help!! How to Refresh Store Procedure in Prime Time!12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU30_Tue, 8 Aug 2000 09:51:51 -0500499_us-ascii Here's a thought:

-STOP PROCEDURE(name here) ACTION(QUEUE) -START PROCEDURE(name here)

This is what I do after I change any resident Stored Procedure. (I actually don't use the ACTION(QUEUE), but I'm not working in a production environment.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Steve Grimes Washington University Information Systems OS/390 V2R6 DB2 UDB 6.1 W: 314-935-4376 H: 636-928-5005 Isa.64:6 Steve_Grimes@aismail.wustl.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [...] 3870 21 18_Insert performance0_19_david.a.owen@BT.COM30_Tue, 8 Aug 2000 15:53:44 +0100475_- I have received a No of requests for this presentation.

Can anyone tell me where is the best place to post the presentation.

Dave

Technical Architect * 02920 724004 Mob 07802 238421 *E-Mail: david.a.owen@bt.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. 3892 20 66_DB2 OS/390 V5.1: All subsystems abended on TEST LPAR with 00E507050_25_Ed_Vetock@NAVYFEDERAL.ORG30_Tue, 8 Aug 2000 11:04:23 -0400514_us-ascii Hi,

We had several DB2 subsystems crash on our TEST LPAR within a few hours of each other with 00E50705. We are in contact with IBM but if anyone has had this experience and are willing to share it I would be grateful.

Respectfully,

Ed Vetock

================================================ 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. 3913 61 15_Re: TCP/IP DRDA12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 8 Aug 2000 08:03:17 -0700558_us-ascii You may want to verify #2 with IBM. It is my understanding that DB2 OS/390 v5.1 will only FULLY support 2 phase commits (ie with OS/390 starting the UOW)via SNA. If you're just configured for TCP/IP connections, then another non-OS/390 DB2 will have to initiate the request.

Tim --- Nick Nur wrote: > Hi everyone. I hope you can help me. > I am in the process of planning for the > implementation of LEVEL II > DRDA using DB2 OS/390 v5.1, TCPIP and DB2 Connect EE > on AIX machine > and two phase commit. > Here is [...] 3975 128 64_Re: -102 trying to insert and/or update pamlist in SYSPROCEDURES0_18_damcon2@US.IBM.COM30_Tue, 8 Aug 2000 11:05:00 -0400627_us-ascii Mike,

The method we use is to do an insert/select. It allows you to concat strings together to form a string that's greater than 254. Here's an example:

INSERT INTO SYSIBM.SYSPROCEDURES SELECT 'GET_SP_PLAN_DET', ' ', ' ', 'REGGPLD', ' ', 'CRS_PROD', 'PLI', 0, ' ', 'N', ' ', 'CHAR(08) OUT, CHAR(254) OUT, CHAR(20) IN, CHAR(8) IN, CHAR(4) IN, CHAR(240) OUT, CHAR(16) OUT, CHAR(16) OUT, CHAR(3) OUT, CHAR(30) OUT , CHAR(1) OUT, CHAR(9) OUT, CHAR(9) OUT, CHAR(3) OUT, VARCHAR(499) OUT, VARCHAR(849) OUT,'||' VARCHAR(549) OUT, VARCHAR(99) OUT, CHAR(1) OUT', 0, ' ', 'M', 'N', 'N' FROM SYSIBM.SYSDUMMY1; [...] 4104 42 22_Re: Insert performance14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM30_Tue, 8 Aug 2000 08:10:13 -0700498_iso-8859-1 There is a mailing list DB2-L-DOCUMENTS@RYCI.com that was designed for just this purpose. You could send the document there, then post a message here once the presentation is available. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own.

-----Original Message----- From: david.a.owen@BT.COM [mailto:david.a.owen@BT.COM] Sent: Tuesday, August 08, 2000 9:54 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Insert performance [...] 4147 181 28_Re: Data Propagator question0_18_damcon2@US.IBM.COM30_Tue, 8 Aug 2000 11:11:21 -0400526_us-ascii Max,

Interesting! Doesn't make since to me. I would have thought since the change was not allowed, it wouldn't be logged and therefore, no propagation. Maybe someone else has some insight?

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW ----------------------------------------------------- [...] 4329 39 22_Re: Insert performance13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM30_Tue, 8 Aug 2000 11:18:17 -0400665_us-ascii How about putting it on the DB2-L Document list??? The email address is: DB2-L-Documents@RYCI.COM Please let everyone know via the normal list that your document has been posted.

Scott

david.a.owen@BT.COM wrote: > > I have received a No of requests for this presentation. > > Can anyone tell me where is the best place to post the presentation. > > Dave > > Technical Architect > * 02920 724004 > Mob 07802 238421 > *E-Mail: david.a.owen@bt.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 [...] 4369 117 64_Re: -102 trying to insert and/or update pamlist in SYSPROCEDURES12_John Cameron26_JCameron@MSI-INSURANCE.COM30_Tue, 8 Aug 2000 10:29:42 -0500600_us-ascii First I did the insert, then I used this :

update sysibm.sysprocedures set parmlist = 'SP03I CHAR(208) IN, ' CONCAT 'SP03O1 CHAR(240) OUT, ' CONCAT 'SP03O2 VARCHAR(32002) OUT, ' CONCAT 'SP03O3 VARCHAR(32002) OUT, ' CONCAT 'SP03O4 VARCHAR(32002) OUT, ' CONCAT 'SP03O5 VARCHAR(32002) OUT, ' CONCAT 'SP03O6 VARCHAR(32002) OUT, ' CONCAT 'SP03O7 VARCHAR(32002) OUT, ' CONCAT 'SP03O8 VARCHAR(32002) OUT, ' CONCAT 'SP03O9 VARCHAR(32002) OUT, ' CONCAT 'SP03O10 VARCHAR(32002) OUT, ' CONCAT 'SP03O11 VARCHAR(32002) OUT, ' CONCAT 'SP03O12 VARCHAR(32002) OUT' where procedure = 'CLMSPT3' ; [...] 4487 27 46_Limit in VB for Stored Procedure row results ?12_John Cameron26_JCameron@MSI-INSURANCE.COM30_Tue, 8 Aug 2000 10:46:18 -0500352_us-ascii Does anyone know ... Is there a limit (around 32K) in Visual Basic (or ADO) when getting a result set from a stored procedure ? When we call the stored procedure from another mainframe program, we get all the data in the result set. When we try from VB, it stops at around 32K. Is there a parameter somewhere that needs to be increased ? [...] 4515 81 22_Re: RDS LIMIT EXCEEDED23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Tue, 8 Aug 2000 12:59:28 +0100365_iso-8859-1 Your peer is sport on - well my understanding after reading the manuals is that increasing MAXRBLK will not assist you.

I do belive there are limits at play that I predefined by IBM and you have no direct control over these.

Not an expert answer I know but I do remember reading all the books and thinking what waste of time that was. [...] 4597 139 64_Re: -102 trying to insert and/or update pamlist in SYSPROCEDURES13_Mike Lawrence29_mlawrence@ASCENSIONHEALTH.ORG30_Tue, 8 Aug 2000 10:52:08 -0500761_US-ASCII Thanks for the response... this did the trick. Have a GREAT DAY!!



Michael S. Lawrence Systems Programmer Ascension Health ISD MLawrence@Ascensionhealth.org



>>> JCameron@MSI-INSURANCE.COM 10:29:42 AM Tuesday, August 08, 2000 >>> First I did the insert, then I used this :

update sysibm.sysprocedures set parmlist = 'SP03I CHAR(208) IN, ' CONCAT 'SP03O1 CHAR(240) OUT, ' CONCAT 'SP03O2 VARCHAR(32002) OUT, ' CONCAT 'SP03O3 VARCHAR(32002) OUT, ' CONCAT 'SP03O4 VARCHAR(32002) OUT, ' CONCAT 'SP03O5 VARCHAR(32002) OUT, ' CONCAT 'SP03O6 VARCHAR(32002) OUT, ' CONCAT 'SP03O7 VARCHAR(32002) OUT, ' CONCAT 'SP03O8 VARCHAR(32002) OUT, ' CONCAT 'SP03O9 VARCHAR(32002) OUT, ' CONCAT 'SP03O10 VARCHAR(32002) OUT, ' CONCAT [...] 4737 475 21_Re: Help asap please.12_Myron Miller22_myronwmiller@YAHOO.COM30_Tue, 8 Aug 2000 08:52:54 -0700541_us-ascii I fully concur. I've had to setup lots of environments for testing. At one client, we had 21 copies of Peoplesoft financials (about 2500 tables) plus 10 copies of Indus Passport (about 1600 tables). We setup different databases and owner/creators for each environment and it was very easy to migrate the changes from each environment to the next one. Plus using tools such as Platinum or BMC, it was fairly simple for the DBAs to create new environments quickly. And the users were able to access each environment very easily. [...] 5213 510 21_Re: Help asap please.0_22_Rohn.Solecki@MTS.MB.CA30_Tue, 8 Aug 2000 11:16:58 -0500409_us-ascii I'll add my agreement to the argument for multiple devel DBs. We see multiple devel DB's as the only way to go. It is just a cost of doing development. (And DBA vigorously avoids 'responsiblity' for assigning use of the devel DBs. We let the development Senior Analysts and Managers fight it out. If they can cost justify it to management, we will reluctantly create a new Devel DB/environment) [...] 5724 59 22_Re: Package Privileges19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US30_Tue, 8 Aug 2000 11:22:52 -0500585_ISO-8859-1 To bind an existing package without changing the owner ID and the qualifier, a person needs to have the BINDAGENT privilege granted by the owner of the package. To be able to add a new package, a person needs BINDADD privilege with the CREATE in COLLECTION privilege. There is also the option of granting a user PACKADM, which is a very powerful privilege for binding packages, etc. However, there is an installation setting for BIND NEW PACKAGE which could make PACKADM to be limited or even useless. In which case, the CREATE IN and BINDADD together will do the job. [...] 5784 31 27_Re: To commit or not commit19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US30_Tue, 8 Aug 2000 11:32:20 -0500368_- Have you tried Isolation UR in your bind? And also the CURRENTDATA(NO) options? This might solve the issue. Further, you programs should not have any cursor with HOLD as this will take locks even if you are not updating anything.

Hope this helps.

...Jaiwant

On Tue, 8 Aug 2000 09:27:29 -0400, Tom Johnson wrote: [...] 5816 83 44_Re: -508 or When is cursor positioning lost?19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US30_Tue, 8 Aug 2000 11:35:03 -0500643_- Pillay & Bill, I just saw something on CURRENTDATA(NO) and the DELETE WHERE CURRENT OF ... being incompatible in the manual. It talks about a negative SQL code being issued. Refer to the COMMAND Reference under BIND options.

...Jaiwant

On Fri, 4 Aug 2000 11:18:32 -0400, Pillay, Venkat (PCA) wrote:

>Bill > > Sounds like bug in DB2 software, because I was able to do it here >without any problem. But I still wonder, why do you need to update the same >cursor position twice? > >-Venkat > > -----Original Message----- > From: William R. Miller [SMTP:william.miller@DRESDNER-BANK.COM] > Sent: [...] 5900 52 50_Re: Limit in VB for Stored Procedure row results ?12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV30_Tue, 8 Aug 2000 13:01:44 -0400480_iso-8859-1 Hi John,

Did you check for an error message in MSTR? We had a similar problem and the stored procedure was getting an 0C4 on the host and the thread was terminated after the first 32k block was sent. (So it looks like only 1 block is sent to the pc appl). The problem we had is that the collection ID for the stored procedure was more than 8 characters in length. IBM has an information APAR for this problem- apparently this has been fixed in DB2 Conn V7. [...] 5953 125 44_Re: -508 or When is cursor positioning lost?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 8 Aug 2000 13:14:59 -0400319_us-ascii Hi Jaiwant

The negative SQLCODE you have mentioned is for ambiguous cursors, which means that if you don't specify "FOR FETCH ONLY" and/or you don't have DISTINCT, GROUP BY or ORDER BY etc. then cursor could be ambiguous cursor. The moment one defines "FOR UPDATE OF" clause there is no ambiguity. [...] 6079 30 72_Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized12_Dudley Moore16_dumoore@NMSU.EDU30_Tue, 8 Aug 2000 10:23:08 -0600572_us-ascii Hello everybody,

I'm attempting to install DB2/UDB v6.1 on Windows/NT and getting a msg about the userid not being recognized. The SETUP program then asks if I would like it to define it for me. Which I reply, 'yes', and then it displays that it can't define the user. I read in the manual the user must be defined 'as part of the operating system' along with a few other specifics, which I did while defining the user, but the same msg comes up, even after rebooting. I'm using the default userid of 'db2admin', but changed the default password. Any [...] 6110 10 64_Re: -102 trying to insert and/or update pamlist in SYSPROCEDURES0_27_Bud.Greenman@ONONDAGA.NY.US30_Tue, 8 Aug 2000 13:29:25 -0400279_- try taking out the ' before sysname

================================================ 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. 6121 90 22_Re: RDS LIMIT EXCEEDED20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 8 Aug 2000 13:31:12 -0400606_iso-8859-1 Othman

You could check for following possibilities:

- Sometimes packages bound with old runstats could cause this problem as DB2 thinks that 25% of table rows limit has reached (based on old stats when pkg was bound) while in reality it could be much less than 25%. A runstats + rebind may solve this problem. - If you are on older version of DB2, where index screening with list-prefetch was not allowed then RID failure could because of that. There is an APAR which allows index screening with list-prefetch and could possibly cut down the RID qualified and thereby reduces [...] 6212 24 76_Re: Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Tue, 8 Aug 2000 12:24:53 -0500428_- I've found that eNp-Ty is really just a single user Multitasking OS, like OS/2.

So I always just dedicate a server to running DB2 and use the same login for NT admin, and the DB2 admin and I have many fewer problems.

If I have another program to run, I get another NT server and install that on it. Running multiple different programs on the same box is just asking for problems with DLL version conflicts. [...] 6237 15 76_Re: Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 8 Aug 2000 13:49:39 -0400463_us-ascii Dudley, If you are installing on a backup domain controller you have to create the userid first on the primary domain controller then specify the domain followed by the userid, example: bosdom2\db2admin. hth Phil

================================================ 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. 6253 21 28_COBOL reserved word question12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 8 Aug 2000 13:21:28 -0500444_iso-8859-1 One of our programmers came across a problem that might prove to be a real stinker for us. She is coding some batch COBOL routines and found that she could not compile a program because is has a column named TITLE, which is a COBOL 'reserved word'. We also have one other instance of a COBOL reserved word being - CODE. This could cause us to change a number of tables. Any ideas or suggestions on another way to approach this? [...] 6275 43 13_help required14_subrata mondal25_subratamondal@HOTMAIL.COM28_Tue, 8 Aug 2000 18:19:43 GMT313_- I have a table which has these columns

Member code Start date End Date Amt IND May 10, 2000 May 17,2000 1000.00 IND May 18, 2000 May 29, 2000 5000.00 IND Jun 30, 2000 Jun 30, 2000 2000.00 PAK Jul 20, 2000 Aug 9, 2000 500.00 PAK Aug 10, 2000 Aug 10, 2000 1000.00 AFG Oct 10, 2000 Oct 10, 2000 600.00 [...] 6319 38 44_Sizing requirements for multiple bufferpools12_Lisle, Kathy29_Kathy.Lisle@GMACINSURANCE.COM30_Tue, 8 Aug 2000 14:20:00 -0400614_iso-8859-1 We are in the processing of bringing up this shop's first production DB2 application: a small, 3rd-party batch application. Because it is so small, we are currently using only two bufferpools: BP0 with 2000 buffers, and BP32K with 100 buffers (used for 5 small 32K-page tablespaces). I am considering breaking out BP0 into 4 separate 4K bufferpools: one for catalog/directory, one for tablespaces, one for indexes, and one for DSNDB07. This is on general principles and in preparation for eventual greater use of DB2 here -- the existing tables haven't yet got enough data in them for me to detect [...] 6358 58 32_Re: COBOL reserved word question13_Samuel, David26_David_Samuel@COMPUWARE.COM30_Tue, 8 Aug 2000 14:28:15 -0400464_iso-8859-1 John-

I ran into this problem several years ago. We needed to change the column name. However, I don't know if DB2 has since adapted to the issue.





David R. Samuel Compuware Corporation Systems Engineer 510.768.5449





-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Tuesday, August 08, 2000 11:21 AM To: DB2-L@RYCI.COM Subject: COBOL reserved word question [...] 6417 45 32_Re: COBOL reserved word question14_Arnold, Mark S20_Mark.Arnold@BNSF.COM30_Tue, 8 Aug 2000 13:30:18 -0500512_iso-8859-1 A couple of options:

1.) Change the column name to somthing more specific and meaningful (JOB_TITLE, PERSON_TITLE, etc).

2.) Easier way out - create a view with the column names prefixed (so instead of TITLE you can have TRS_TITLE, etc.) Provide a DCLGEN of this view....







-----Original Message----- From: Vernon, John [mailto:John.Vernon@TRS.STATE.TX.US] Sent: Tuesday, August 08, 2000 1:21 PM To: DB2-L@RYCI.COM Subject: COBOL reserved word question [...] 6463 41 32_Re: COBOL reserved word question24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 8 Aug 2000 11:28:05 -0700314_- Assuming that you don't want to change the tables, you could create a view with alternative names for the columns. You might also try including the "AS name" for the offending columns. Generally speaking, it is not a good idea to use such generic titles as column names. But I'm sure you already know that. [...] 6505 46 32_Re: COBOL reserved word question20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 8 Aug 2000 14:40:22 -0400393_us-ascii How about using COLSUFFIX keyword during generation of the DCLGEN. As a standard use table-name or some other word as for suffixing the DCLGEN generated column name/definition.

I have seen many shops who always use some kind of suffix such as unique number or unique three letter name for a table. Use this unique identifier to suffix the DCLGEN definition of the column. [...] 6552 125 25_Re: Can I backout a bind?16_Alison Pelletier26_alison_pelletier@YAHOO.COM30_Tue, 8 Aug 2000 11:46:18 -0700404_us-ascii Thanks everyone who responded for your advice. The sequential caching I wrote about was implemented after the bind happened, so I don't want to leave an impression that this could be a problem with list prefetch being turned off. Statistics were set back to what they were and still no list prefetch in plan_table. Looking into RID pool size for now. Any other suggestions are appreciated. [...] 6678 103 48_Re: Sizing requirements for multiple bufferpools24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM30_Tue, 8 Aug 2000 11:44:46 -0700437_iso-8859-1 Short answer: Use a single buffer pool with the 2000 pages.

Longer answer: You might want to check the administration guide on Tuning Buffer Pools. There is a sub-section of Buffer Pool Size Guidelines. This section included the following information:

Reasons to Choose a Single Buffer Pool: If your system has any or all of the following conditions, it is probably best to choose a single 4KB buffer pool: [...] 6782 526 21_Re: Help asap please.12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Tue, 8 Aug 2000 21:54:04 +0200318_x-user-defined Hi, I had to deal many times with people who worked on ORACLE before and used to do nearly everything by themselves. Giving the separate DB is the best way to lead them to continue working in DB2 as they really hate to wait for DBA to do some definitions for them. They don't feel so "centralled". [...] 7309 54 32_Re: COBOL reserved word question19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Tue, 8 Aug 2000 13:49:46 -0500317_ISO-8859-1 Hi John, I think changing the names is in your future! In the perfect relational world you'd just use the table name as a prefix, e.g. CUSTOMER_CODE and CUSTOMER_TITLE? This also works well for columns that will be inherited like PK columns. I would not arbitrarily prefix all columns with tablename. [...] 7364 21 19_Field name prefixes13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Tue, 8 Aug 2000 14:01:54 -0500337_- We always prefix field names by a few letter acronym of the native table for the field.

So PR_ID is the Product ID. It is a primary key in the PRODUCTS table and a foreign key to the PRODUCTS table in other tables.

Anytime I see a join that isn't on the same field name in the different tables I take a closer look. [...] 7386 19 48_Re: Sizing requirements for multiple bufferpools14_Philip Gunning18_pgunning@PHEAA.ORG30_Tue, 8 Aug 2000 15:25:55 -0400584_us-ascii Cathy, I would only have the catalog and directory in BP0, put DSNDB07 in another BP, and put tablespaces and indexes in two separate BPs. If is very difficult to provide efficient access to the cat/dir if not in separate BPs. Plus you can't tune for specific performance with everything in one BP. This is my honest opinion, based on experience. Then monitor your BPs using the -display bufferpool(BPX) detail(*) command or use your monitoring tool to gauge performance. Having properly tuned bufferpools is one the most important performance "knobs" for DB2. HTH Phil [...] 7406 50 27_Re: To commit or not commit20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Tue, 8 Aug 2000 15:42:30 -0400328_us-ascii I wouldn't force the application programmers to issue commits just because we the DBAs want to run utilities. It is true that CLAIMS are released at commit point regardless of read or write operation. Also they are not dependent on RELEASE parameter of bind command. Data sharing also does not play any role here. [...] 7457 53 48_Re: Sizing requirements for multiple bufferpools14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM30_Tue, 8 Aug 2000 15:55:37 -0400541_ISO-8859-1 If all you can afford is 2000 buffers for the entire system leave them in in one pool. However, you will need much more than this to get any decent performance. Your initial shotgun approach of splitting out indexes, tablespaces, and sort into other pools and leaving BP0 for the catalog & directory is correct. You may be able to get away with 1000 pages for BP0 if you are running only one batch job at a time, but probably plan on at least 2000. You'll need to get a handle on how the objects are really accessed to start [...] 7511 102 50_Re: Limit in VB for Stored Procedure row results ?12_John Cameron26_JCameron@MSI-INSURANCE.COM30_Tue, 8 Aug 2000 14:59:15 -0500549_us-ascii Robert,

I didn't see an 0C4 in MSTR, or any other errors for that matter on either the mainframe or our DB2 Connect server. It looks like the VB program "loops" on the last record before it goes beyond 32K. We should be sending back 18 - 2062 byte rows, but once we get to the 15th one, each subsequent getnext shows the 15th row again. No EOF. We have another SP with 49 byte records that does the same thing when it reaches 32K. I tried creating another collection (ours was 10 characters), but that didn't change the result. [...] 7614 17 30_DataJoiner and Classic Connect11_Trace Jones31_Trace_R_Jones@RELIANTENERGY.COM30_Tue, 8 Aug 2000 15:44:48 -0500432_us-ascii Hi everyone,

Does anyone use DataJoiner with Classic Connect to access VSAM files? If someone does, can they comment on the ease of installation, setup, and use?

Trace

================================================ 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. 7632 97 27_Re: To commit or not commit12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 8 Aug 2000 13:58:44 -0700552_us-ascii I think there should be commit processing for reads. As a thread increases the number of pages locked (they're share locks, which allow everyone to read, but no one else can update)due to a lot of reads, it is increasingly difficult for other threads which want to update data to get an exclusive lock. And if a thread reads (and locks) more than a certain amount, it is likely that the lock will escalate and lock the whole table from anyone updating it. Of course you've converted all your indexes to type 2 so they don't lock as well. [...] 7730 33 76_Re: Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 8 Aug 2000 14:02:01 -0700593_us-ascii And you might want to give db2admin NT DOMAIN admin rights. --- Philip Gunning wrote: > Dudley, If you are installing on a backup domain > controller you have to > create the userid first on the primary domain > controller then specify the > domain followed by the userid, example: > bosdom2\db2admin. hth Phil > > ================================================ > 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. [...] 7764 119 27_Re: To commit or not commit13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Tue, 8 Aug 2000 14:20:15 -0700435_iso-8859-1 As per my understanding (I could be wrong though, please correct me if I am ) , this is not correct. For any plan/package bound with CS, the lock is held only at the page which is being read (where the cursor is positioned) and the moment cursor moves to next page, the S lock on previous page is released. So, lock escalation is not a possibility unless plan/package is bound with RR/RS or LOCKMAX is too low. Thanks. [...] 7884 16 32_Re: COBOL reserved word question12_Vernon, John27_John.Vernon@TRS.STATE.TX.US30_Tue, 8 Aug 2000 16:27:10 -0500447_iso-8859-1 My sincerest Thanks! to all who responded, I think we shall be renaming in the very near future, fix it properly now, establish standards to prevent its reoccurrence, and move on....

john

================================================ 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. 7901 161 27_Re: To commit or not commit0_19_Tim.Lowe@STPAUL.COM30_Tue, 8 Aug 2000 16:14:38 -0500400_us-ascii Tim, It sounds to me like you are describing using an isolation of repeatable read, which in my experience is rarely needed. With an isolation of cursor stability, it is hard to imagine a situation where many pages are locked, or where a read would cause lock escalation. And, with lock avoidance (current data=no), I would hope that the issues that you mention would not be a problem. [...] 8063 50 76_Re: Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Tue, 8 Aug 2000 16:53:56 -0500433_iso-8859-1 We've found that the id must be a local admin, and that even though it is defined, the install still asks if it should create it. Although it is curious, we just say yes and continue on....

-----Original Message----- From: tim malamphy [mailto:timalamphy@yahoo.com] Sent: Tuesday, August 08, 2000 4:02 PM To: DB2-L@RYCI.COM Subject: Re: Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized [...] 8114 178 27_Re: To commit or not commit13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM30_Tue, 8 Aug 2000 16:59:31 -0500477_iso-8859-1 At the installations where I've worked we have never issued commits for read only work, and have never had any problems which caused us to re-think this. It's been a while, but I believe the answer does lie in using the isolation level CS and possibly currentdata=no as well??

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Tuesday, August 08, 2000 4:15 PM To: DB2-L@RYCI.COM Subject: Re: To commit or not commit [...] 8293 27 38_C program and Store procedure problem!13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Tue, 8 Aug 2000 18:06:48 EDT378_- Hi List, I have a C program that calls a store procedure that inserts a value into a one column table. The store procedure returns a zero return code to the calling program but does no insert to the table...just empty table. Is there any way we can trap SQLCODE in store procedure and bring it back to the calling program? Our store procedure environment is DB2 managed. [...] 8321 204 27_Re: To commit or not commit12_tim malamphy20_timalamphy@YAHOO.COM30_Tue, 8 Aug 2000 15:16:57 -0700600_us-ascii Tim - You're right. Now that I think about it, all the read locking problems I've had to chase were RR type applications, that supposedly couldn't stand "dirty data". Something mission-critical ...like dsnesprr.

--- Tim.Lowe@STPAUL.COM wrote: > Tim, > It sounds to me like you are describing using an > isolation of repeatable > read, which in my experience is rarely needed. > With an isolation of cursor stability, it is hard to > imagine a situation > where many pages are locked, or where a read would > cause lock escalation. > And, with lock avoidance (current data=no), I [...] 8526 25 26_ACF2 and DSN3@ATH/DSN3@SGN17_Belfield, Alma G.15_AGBELFI@TWA.COM30_Tue, 8 Aug 2000 17:56:25 -0500302_iso-8859-1 Does anyone know whether the address of ACF2 control blocks is passed into DSN3@ATH and DSN3@SGN ? The AIDLACEE parameter is (sometimes) the address of the ACEE structure in a RACF environment, I was wondering whether it is set in an ACF2 environment, and if so, what does it point to? [...] 8552 43 21_Re: VSAM odbc drivers0_15_leon@CA.IBM.COM30_Tue, 8 Aug 2000 19:49:52 -0400392_us-ascii Have you considered providing access to VSAM files by using Stored Procedures on DB2 for OS/390? This way you will not need to have an ODBC driver for VSAM. You would be using your DB2 ODBC driver instead.

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



"Brown, James R. - DIT" on 08/07/2000 11:04:19 AM [...] 8596 68 54_Re: Trimming fixed-length char columns during the load0_29_Greg.Palgrave@BANKWEST.COM.AU30_Wed, 9 Aug 2000 08:04:36 +0800277_us-ascii I'm not sure what you are driving at here - fixed-length char columns will be space filled by DB2 if the value you supply is shorter than the defined length of the field, so if you somehow strip them off and get the load job to work, DB2 will just put them back. [...] 8665 272 27_Re: To commit or not commit12_Higgins John25_HigginsJohn@JOHNDEERE.COM30_Tue, 8 Aug 2000 19:49:55 -0500475_iso-8859-1 IBM advises users of SAP R/3 on DB2/OS390 to be sure to commit their long-running read-only transactions at least once per minute.

To an extent, this is due to the special environment in effect with SAP. However, many of these conditions CAN occur in other environments.

Quoting SAP Note 0105737:



Typical problems that can be expected in an environment with long running transactions and reports that do not commit regularly are: [...] 8938 86 17_Re: help required14_James Campbell29_James.Campbell@HANCORP.COM.AU30_Wed, 9 Aug 2000 11:21:07 +1000502_iso-8859-1 Subrata

What you want cannot be done in a single update statement - or, at least on DB2 OS/390, not until V7 (don't know about other platforms). The reason that it cannot be done is that you would need a subselect on the table to determine which rows are to be updated. There is a restriction on the UPDATE statement that "[t]he search condition must not include a subquery where the base object of both the UPDATE and the subquery is the same table." So you can't do it in one. [...] 9025 38 26_OAM and recovery questions14_Peter McKellar32_peter.mckellar@CENTRELINK.GOV.AU30_Wed, 9 Aug 2000 12:03:21 +1000379_us-ascii hi,

thanks to all that replied to my initial OAM posting.

the programming group were wondering what sort of recovery options exist with OAM. i noted there is a 'deleted objects' exit (as objects on tape or optical are not actually deleted from the media, just flagged as such). I assume that if they are left on the media, they can be recovered, but: [...] 9064 63 27_Re: To commit or not commit13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Tue, 8 Aug 2000 22:25:29 -0400615_iso-8859-1 How 'bout this for an outrageous opinion (part of which, Tim Lowe already voiced, but not as outrageously):

Back in my DBA dictator days, I always insisted that ALL batch programs be designed with commit logic included and with an external parameter (usually a PDS member, although DB2 table can be used also) controlling how frequently commits are taken. The control was 2-pronged: number of seconds between commits or number of units of work between commits -- whichever came first. Commits were never taken within a unit of work, of course. Care was taken during design to get as granular [...] 9128 624 61_Repost: eWeek Analyst's Choice for DB2: "TOP-FLIGHT DATABASE"13_Morrill, John12_JohnM@VP.NET30_Tue, 8 Aug 2000 20:54:00 -0600538_iso-8859-1 Dear DB2 Interested Parties,

DB2 Universal Database 7.1 has earned eWeek Labs' "Analyst's Choice Award" (eWeek, August 7). In a review headlined: "TOP-FLIGHT DATABASE", Timothy Dyck says that IBM DB2 is "the first product that combines all the right ingredients for enterprise computing."

Find eWeek online at http://www.zdnet.com/eweek/ and the report at http://www.zdnet.com/eweek/stories/general/0,11011,2610819,00.html . I've cut/pasted the review, executive summary, and "Lab's Eye View" for you below. [...] 9753 46 35_Fw: Varchar(32672) vs. Long Varchar11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Tue, 8 Aug 2000 23:03:41 -0400342_us-ascii In addition to the comments from others, remember that LONG and LOB columns are not buffered through bufferpools and instead use "Direct I/O". So, one advantage of the varchar(32672) is that it CAN be assigned to a 32K page size bufferpool. What is actually appropriate will depend on the nature of the application and the SQL. [...] 9800 74 44_Fw: Re: TEMPSPACE1 is full on UDB 5.2 on AIX11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM30_Tue, 8 Aug 2000 23:07:43 -0400366_us-ascii Hi Helen,

Our SQL-GUY(TM) tool will tell you in a heartbeat which queries have used the most resources, sort, CPU, or otherwise. SQL-GUY(TM) will also tell you estimated remaining run time durations and forecasted completion times, so you can tell your users when their queries will be "done".

Learn more at http://www.database-guys.com/ [...] 9875 73 22_Re: RDS LIMIT EXCEEDED12_Gerald Hodge20_ghodge@ATTGLOBAL.NET30_Tue, 8 Aug 2000 22:37:21 -0500461_iso-8859-1 I realize I am behind several other observations, but based on your Invalid Select Procedures count I believe you need to rebind. If you are getting logical failures rather than physical then the failure is because of the RID Number stored during the bind.

Rebinding should also remove your Invalid Select Procedures issue. For more detailed information go to http://eanalysis.hlstechnologies.com/websample select the RID Analysis entry. [...] 9949 73 35_Re: Varchar(32672) vs. Long Varchar7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Wed, 9 Aug 2000 11:18:00 +0530565_iso-8859-1 Hi Scott, I am not sure whether the LONG VARCHAR column can be buffered or not.However, i do not find any reason for it to be not buffered.Regarding the LOB and other new object data types available from DB2 V6 i believe it is buffered in certain cases.The basis of my information is an article on Object Relational Database by Richard Yevich and Susan Lawson which says : You'll only need bufferpools for caching LOBs in certain situations. For example, if you use SQL INSERT to insert a LOB in a program without an extender, the LOB must be moved [...] 10023 88 48_Re: Sizing requirements for multiple bufferpools7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Wed, 9 Aug 2000 11:43:20 +0530587_iso-8859-1 Hi Kathy, As you mentioned it is your first production application using DB2 and it is small, i would suggest leaving everything to BP0 for the time being.However, I do not find any guidelines that if you have short on storage you should not try and split if you can get the better performance because the storage requirements is directly related to the workload you process(if you are not restricted from buying more memory for the heavy workload processing due to cost or some other reasons).However, we should try and get things done in the less cost + most efficient [...] 10112 57 27_Re: To commit or not commit7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Wed, 9 Aug 2000 12:04:22 +0530575_iso-8859-1 In addition to all the replies in this thread i want to ask which is better from the performance and cost point of view ?.To Commit or not to Commit.I do think our first aim is to make the life easier for the customers by giving close to 24/7 availability with least failures ,for which either application programmers or the DBA has to suffer. In this case the availability of the applications which is related to the availability for the customers can be maximised by NOT TO COMMIT the read only processing (with some exceptions of the RR bound applications [...] 10170 631 28_Re: Data Propagator question11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Wed, 9 Aug 2000 17:20:21 +1000563_iso-8859-1 Looks like DB2 started making the change (and logging it) before it realised that it was not allowed, and then backed it out and wrote undo records. And I can understand that Capture inserted a record into the CD table since it simply reads the log and does not care whether updates get committed or not. However, Apply should not have replicated this change since there should have been no corresponding record in the UOW table - Apply is supposed to join the CD table to the UOW table, and since the uow never got committed, the join should not [...] 10802 285 35_Re: Varchar(32672) vs. Long Varchar11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Wed, 9 Aug 2000 17:24:57 +1000612_iso-8859-1 Ah, the fun of different DB2s... Again, both are right - Sanjeev is referring to DB2 OS/390, whereas Scott is talking about little DB2, UNO.

No, I won't go on about terminology again :-)

Cheers, Ulrich

> -----Original Message----- > From: Sanjeev [SMTP:Sanjeev@INTERRAIT.COM] > Sent: Wednesday, August 09, 2000 3:48 PM > To: DB2-L@RYCI.COM > Subject: Re: Varchar(32672) vs. Long Varchar > > Hi Scott, > I am not sure whether the LONG VARCHAR column can be buffered or > not.However, i do not find any reason for it to be not buffered.Regarding > the LOB and other new object [...] 11088 47 25_Re: Can I backout a bind?7_Sanjeev21_Sanjeev@INTERRAIT.COM30_Wed, 9 Aug 2000 13:11:12 +0530575_iso-8859-1 Hi Alison, Is the access path and join sequence exactly same as it was, except that no list prefetch currently ?.As you said the index is still unclustered, have you checked the CLUSTERRATIO in catalog(might be manually updated by someone) ? .If all the things are exactly same then there is no alternative other than to check the RID pool size but i get a feeling that there is something in the Catalog which is making it choose accesspath without list prefetch. I hope we can get some more information on how list prefetch will be disabled by the optimizer [...] 11136 17 22_Re: Insert performance10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 9 Aug 2000 02:57:30 -0500518_- Dave,

I'm also interested, and I suspect that there are many others out there who would be as well. If you are happy to share it: is the presentation too big to post to the list, or are there other means by which you could make it broadly available?

John Hardy

================================================ 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. 11154 20 22_Insert performance doc0_19_david.a.owen@BT.COM30_Wed, 9 Aug 2000 09:13:08 +0100452_- I have now posted the Insert performance doc on the document site. Hopefully it should be there later today.

Dave

Technical Architect * 02920 724004 Mob 07802 238421 *E-Mail: david.a.owen@bt.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. 11175 33 8_AMS CACS12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Wed, 9 Aug 2000 09:51:00 +0100544_- Anyone out there have this application? We are just installing it and would appreciate any quick tuning tips specific to the application.

Thanks

Colin Allen Abbey National



Important:

Internet communications are not necessarily secure and may be intercepted or changed after they are sent. The Abbey National Group does not accept liability for any such changes. If you wish to confirm the origin or content of this communication, please contact the sender using an alternative means of communication. [...] 11209 278 27_Re: To commit or not commit11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU30_Wed, 9 Aug 2000 19:29:30 +1000574_iso-8859-1 Just to throw in my 2 cents worth - I agree. In fact, at most sites where I worked previously, every batch program (or any other potentially long-running program) had to have commit logic in it, usually achieved by reading a table with commit frequencies (elapsed time and units of work - just like in Dave's DBA dictator days). Admittedly there were quite a few RR packages around which made this approach mandatory, but even with CS I feel this is the better design, for the same reasons that Dave and John mentioned. And to keep the commit overhead down, [...] 11488 80 49_Re: Problems inserting LOB data greater than 16MB15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK30_Wed, 9 Aug 2000 10:37:13 +0100355_iso-8859-1 From an ignorant view, can you not read the first 16MB into your array, do the insert with that and then do a loop reading in the next 16MB and doing updates using LOB Locators.

I'm afraid I am not very up on this but that was my basic understanding - I'm sure someone will shoot this down in flames. Answers on a postcard to ..... [...] 11569 41 42_Re: C program and Store procedure problem!12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Wed, 9 Aug 2000 07:57:01 -0400398_us-ascii We have an OUT variable set to the length of the SQLCA. If there is an error in the stored procedure, the content of the stored procedure SQLCA is put in it and control is passed back. In the calling program, you first check the SQLCA in the calling program then, if there is an error, the variable that held the stored procedure is moved into your current SQLCA and that is checked. [...] 11611 138 27_Re: To commit or not commit19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 9 Aug 2000 07:44:27 -0500555_ISO-8859-1 Hi All, I'm in the commit strategy camp agreeing with Ulrich, Dave, John, and Tim. If you're in a busy shop, please consider designing for maximum concurrency. Using a variation of the 80 -- 20 ROT; 20% of the data gets 80% of the access, and 20% of that on the same page. And, ever notice that all those 20%s end up being your most critical transactions and batch jobs. The CPU cost of a commit is measured in ms or less on most processors, (2 to 3ms, see DB2 Capacity Planning, SG24-2244-00). With the correct 'commit frequency' and the [...] 11750 26 12_DB2 Recovery14_Dean Montevago18_DMonteva@VNSNY.ORG30_Wed, 9 Aug 2000 08:50:06 -0400307_- Hi, If I have a problem with my active log datasets and I have to delete and redefine them. What will happen when DB2 is restarted ? Will it use data in the latest archive log to recover ? What about the data that was in the active logs when the problem occured, is it lost ? Please advise. TIA Dean [...] 11777 69 48_Re: Sizing requirements for multiple bufferpools12_Lisle, Kathy29_Kathy.Lisle@GMACINSURANCE.COM30_Wed, 9 Aug 2000 09:01:08 -0400439_iso-8859-1 Thanks -- I was hoping that you would respond. I am recommending to my manager that we leave the buffer pool as it is for now, monitor, and start campaigning for more buffer pool space. Thanks for the ammunition.

-----Original Message----- From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Sent: Tuesday, August 08, 2000 3:56 PM To: DB2-L@RYCI.COM Subject: Re: Sizing requirements for multiple bufferpools [...] 11847 65 16_Re: DB2 Recovery23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 9 Aug 2000 14:11:27 +0100313_iso-8859-1 Dean

...err I do belive the following is true

1. All current data form your active logs is now lost forever (as you deleted them). 2. DB2 needs a cold start (conditional restart record with start and end RBA being the same (1 on from end of the end rBA of the last Archive log cut). [...] 11913 29 56_DSNJ111E - Out of Space in Active Log Data Sets Question13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Wed, 9 Aug 2000 09:18:12 EDT365_- Hi List, I am trying to shut down DB2 with no luck. I found the DSNJ111e message in the syslog. Ok, the DB@ ADMIN GUIDE says ...Use IDCAMS Define command to define new active log data sets and run util DSNJLOGF to init new active datasets. Further more, it says to Define the new log datasets in the BSDS by using the change log inventory util (DSNJU003)... [...] 11943 127 27_Re: To commit or not commit12_craig patton21_prgpatton@HOTMAIL.COM28_Wed, 9 Aug 2000 13:20:16 GMT549_- Perhaps I missed something in this thread, but has the ISOLATION parameter been discussed?? If using CS, then there is a minimum of PAGES held with an 'S' lock during the actual read. You do NOT lock ALL the pages to be read at the same time and then hold them until a commit (as you WOULD with an 'RR' isolation). WITH HOLD would NOT change this, BUT it would hold LOCKs across a COMMIT, in order to maintain Cursor Positioning. Also, most REGULAR running utilities ARE compatible with an 'S' lock (copy and runstats AND the UNLOAD phase of [...] 12071 323 27_Re: To commit or not commit0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Wed, 9 Aug 2000 08:19:12 -0500507_us-ascii



I agree as well, that its worthwhile to encourage use of commits on long running RO applications. With most shops looking to become 24 x 7 environments, issuing commits is more important than ever. I know for our shop, we have programmers worldwide working around the clock, as well as web access that is continuously available so it makes it even more challenging for DBAs to find a convenient times to run utilities in the off hours if locks are being held for long periods. [...] 12395 261 27_Re: To commit or not commit20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM30_Wed, 9 Aug 2000 09:36:32 -0400322_iso-8859-1 I think all of us are ignoring the basic question, which is more to do with claims and drains rather than locks. I guess the original question was

>>" some dbas say that we should issue commits in read only programs to allow utilities to drain" <<

LOCKS are different than CLAIMS and DRAINS. [...] 12657 81 42_Re: C program and Store procedure problem!0_54_Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM30_Wed, 9 Aug 2000 08:43:29 -0500314_us-ascii To switch from DB2 stored procedures to WLM managed Stored Procedures You might try looking at "Getting Started with DB2 Stored Procedures , Give them a call through the network" manual. SG24-4693-01 Chapter 3 goes into lots of detail with good step by step instructions of how to get set up for V5. [...] 12739 66 60_Re: DSNJ111E - Out of Space in Active Log Data Sets Question12_Sue Janowitz18_SJanowitz@NEFN.COM30_Wed, 9 Aug 2000 09:47:36 -0400331_us-ascii Carlton, what version of DB2 are you on?

It is recommended to only update the BSDS when DB2 is down, otherwise 'results can be inconsistent'. I've always done it that way.

If all your active logs are full, there might be a problem with offloading to the archives. Can you approach the problem that way? [...] 12806 101 61_Re: DSNJ111E - Out of Space in Active Log Data Sets Quest ion12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK30_Wed, 9 Aug 2000 14:54:00 +0100453_- Are you archiving to tape or DASD ?

You will probably find that you are archiving to DASD and HSM is not working, so you have run out of DASD for new archives, or you are archiving to tape and having problems with your tape system. Check if the operators have any mount requests outstanding. If your Ops report a problem with a tape stuck in a drive then issue the ARCHIVE LOG CANCEL OFFLOAD command and DB2 should then try another drive. [...] 12908 73 32_Re: COBOL reserved word question16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM30_Wed, 9 Aug 2000 06:52:58 -0700582_iso-8859-1 We had a problem like this with a package that we bought, but the column name itself didn't cause the problem, just the working-storage definition named after the column, in our case created by a DCLGEN. We just changed the working-storage name and our problem was solved.

This DIDN'T work: EXEC SQL DECLARE ddddd.ttttt TABLE ( SYSTEM_ID CHAR(4) NOT NULL, DB2_SS_ID CHAR(4) NOT NULL, DATE DATE NOT NULL, TIME TIME NOT NULL ) END-EXEC. 01 DCLttttt. 10 SYSTEM-ID PIC X(4). 10 DB2-SS-ID PIC X(4). 10 DATE PIC X(10). <=== reserved 10 TIME PIC X(8). <=== reserved [...] 12982 87 30_Re: OAM and recovery questions15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 9 Aug 2000 08:56:50 -0500616_iso-8859-1 Hi, Peter,

I haven't had much experience in this area of OAM since we haven't really deleted anything yet. I would suggest that you look at DFSMS/MVS OAM Application Programmer's Reference, if possible. I believe that many of your questions would be answered there. My assumptions would be that the objects on DASD would be physically deleted. Objects on optical would for all intents and purposes be deleted if the directory information is deleted. If there is no address information for an object then OAM wouldn't know where it was. I suspect that you shouldn't be accessing OAM outside of [...] 13070 88 32_Re: COBOL reserved word question19_Rajeev P. Dhanawade22_rdhanawade@STATE.DE.US28_Wed, 9 Aug 2000 10:00:17 EDT608_us-ascii All these reserved word problems are strictly to do with the DCLGEN variables. COBOL does not care about your column names.

HTH.

Rajeev P Dhanawade Phone : 302-577-4659 Ext. 221 ++ Fax : 302-577-4454 ++ ------------- Original Text From: "Provenzola, Tony" , on 08/09/2000 9:52 AM: We had a problem like this with a package that we bought, but the column name itself didn't cause the problem, just the working-storage definition named after the column, in our case created by a DCLGEN. We just changed the working-storage name and our problem was solved. [...] 13159 27 15_DB2 Date Format13_Fisher, Larry30_Larry.Fisher@GMACINSURANCE.COM30_Wed, 9 Aug 2000 09:50:43 -0400465_iso-8859-1 We are contemplating changing our date format from ISO, yyyy-mm-dd, to USA, mm/dd/yyyy. This change is for compatibility with another DB2 from a merge of two organizations. The Installation Guide recommends that this parameter, specified on panel DSNTIP4, not be updated. I would like to know if anyone on this list has changed date formats and if they have what have been the results or problems from such a change. We are running DB2 Version 5.1. [...] 13187 140 23_Ole DB provider for DB211_Emery, Matt19_matt.emery@JNLI.COM30_Wed, 9 Aug 2000 09:59:59 -0400532_iso-8859-1 I have a developer with the following question. Any suggestions???

Matthew J. Emery Jackson National Life Insurance Company Technology Department - Database Administrator voice: 517-367-3715 fax: 517-394-0986 pager: 517-232-1617 email: Matt.Emery@jnli.com e-page: 5172321617@epage.arch.com







-----Original Message----- From: Ganguly, Dev Sent: Friday, August 04, 2000 2:27 PM To: Emery, Matt Cc: Dearman, Robert Subject: Ole DB provider for DB2 [...] 13328 79 16_Re: DB2 Recovery12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM30_Wed, 9 Aug 2000 10:09:22 -0400485_us-ascii I agree with the above (below actually!) but would like to add that you will have a hole in the log. What this means is that your ability to do a point-in-time recovery to now will not be possible. You should consider doing full image copies of all your data and catalog/directory at the earliest possible opportunity if the data is important/critical. If the data is test, the catalog/directory should still be done. The user data? that depends on your siter standards. [...] 13408 116 16_Re: DB2 Recovery14_Dean Montevago18_DMonteva@VNSNY.ORG30_Wed, 9 Aug 2000 10:20:02 -0400496_- Thanks for the responses. I have been reading the Admin Guide, it got alot of good info. I didn't explain what I was trying to accomplish. We are considering making a copy of our archive log tape and sending it to our recovery site. On our sysprog system I forced an archive and created a copy of the "A" version of the tape. I did a CLI to add my log to the BSDS to be the most recent archive log. I used the same start and end RBA's as the one created by the archive log, since they are [...] 13525 88 19_AW: DB2 Date Format12_Peter, Georg15_G.Peter@DZBW.DE30_Wed, 9 Aug 2000 16:22:48 +0200661_iso-8859-1 Larry,

if you do not want to change all your stored date data, try this:

SELECT CHAR(PGEBDAT,EUR) result is 09.12.1999 , CHAR(PGEBDAT,ISO) result is 1999-12-01 , CHAR(PGEBDAT,USA) result is 12/01/1999 ....

HTH.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 13614 119 19_Re: DB2 Date Format14_Laredo, Andrew19_Andy_Laredo@BMC.COM30_Wed, 9 Aug 2000 09:29:51 -0500416_iso-8859-1 I'd worry more about ALL the program code and view code which substrings and concatenates existing data column data based on current settings...

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Wednesday, August 09, 2000 10:23 AM To: DB2-L@RYCI.COM Subject: AW: DB2 Date Format

Larry,

if you do not want to change all your stored date data, try this: [...] 13734 83 15_view problem...14_Backes,Michael26_BackeM@MAIL.OA.STATE.MO.US30_Wed, 9 Aug 2000 09:29:28 -0500306_iso-8859-1 list, i have the following view, in platinum's interactive sql it returns 11,000 rows. in spufi or batch, it returns 0. sql 100, not found...etc..

can anyone shed some light as to why? os390/db2v5. suspect it is something to do with the where clause, but do not know any reason why. [...] 13818 293 27_Re: To commit or not commit19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 9 Aug 2000 09:17:48 -0500347_ISO-8859-1 Hi Venkat, Agreed, 'commit frequency' implies it is chosen appropriately and considers your points about index look-aside and sequential detection. However, I feel any discussion about DB2 Utility jobs is moot. If it has been correctly determined to dispatch the job, it should be allowed to acquire access to any object it needs. [...] 14112 113 19_Re: view problem...19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 9 Aug 2000 09:48:11 -0500594_ISO-8859-1 Hi Michael, If there are indexes on the table, I would first run a CHECK INDEX. You might find a bad index and different access paths for each method.

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 [...] 14226 136 34_Re: view problem... thanks anyway.14_Backes,Michael26_BackeM@MAIL.OA.STATE.MO.US30_Wed, 9 Aug 2000 10:00:04 -0500300_iso-8859-1 list thanks anyway, have narrowed the problem down to the way platinum is returning the current date. it is not retuning it in the same format as spufi/db2 batch. etc.. why at this time i do not know. if there are any platinum experts out there that know how to fix this let me know. [...] 14363 167 34_Re: view problem... thanks anyway.12_Lisle, Kathy29_Kathy.Lisle@GMACINSURANCE.COM30_Wed, 9 Aug 2000 11:24:45 -0400457_iso-8859-1 Seems like a solution might be found in a note from Georg Peter earlier this morning: try this:

SELECT CHAR(PGEBDAT,EUR) result is 09.12.1999 , CHAR(PGEBDAT,ISO) result is 1999-12-01 , CHAR(PGEBDAT,USA) result is 12/01/1999

-----Original Message----- From: Backes,Michael [mailto:BackeM@MAIL.OA.STATE.MO.US] Sent: Wednesday, August 09, 2000 11:00 AM To: DB2-L@RYCI.COM Subject: Re: view problem... thanks anyway. [...] 14531 15 22_Re: RDS LIMIT EXCEEDED12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 9 Aug 2000 10:14:36 -0500303_- There are quite a few good suggestions in the list. If you are running V5 and don't have APAR PQ15670 on, then that can help a lot. The biggest improvement will be finding the plans that are trying to use list prefetch or multiple index access and not succeeding, then getting the proper access. [...] 14547 22 27_Re: To commit or not commit12_Roger Miller19_millerrl@US.IBM.COM30_Wed, 9 Aug 2000 10:38:38 -0500375_- As others noted, most of the work can proceed, but there is a significant caveat.

If you want to run your utilities online now, and the utility must drain readers, like online reorg, and you don't commit for hours, then you have a conflict. It does not matter which isolation level you use. We don't have a technique that can switch while you're still running. [...] 14570 20 19_Re: DB2 Date Format14_Clayton, Colin21_Colin_Clayton@BMC.COM30_Wed, 9 Aug 2000 11:14:30 -0500445_iso-8859-1 Hi fellow nit-pickers.

does Georg's test show conclusively that Europe is ahead of the rest of the world ?



Colin

(My views only, don't blame my employer etc..etc..

================================================ 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. 14591 947 11_DB2 Connect10_Lee Herbst29_lherbst@PROPAPPR.MARION.FL.US30_Wed, 9 Aug 2000 12:03:28 -0400300_iso-8859-1 I sent this message yesterday, but I have not had a response. Can anyone point me to a list or resource that could help me with this problem? I've gone through most of the documentation and most of the redbooks that cover this subject, but I have not been able to resolve my problem. [...] 15539 66 22_Re: TSO attach problem15_Billings, Linda30_linda.billings@DOA.STATE.WI.US30_Wed, 9 Aug 2000 11:18:15 -0500355_iso-8859-1 Are you sure that DB2 wasn't rolling back changes that your batch job made? Rollback may have completed when DB2 was brought down.

Linda Billings Enterprise Systems Programmer Info-Tech Services Department of Administration State of Wisconsin

"People who know everything are a great annoyance to those of us who do." - Anon. [...] 15606 956 15_Re: DB2 Connect4_IBM119_IBM1@EGEBANK.COM.TR30_Wed, 9 Aug 2000 19:20:11 +0300603_ISO-8859-9 try the list for DB2 Server for VSE/VM, which is read and followed also by poeple from TOROLAB.

you will find the link for it at the following URL:

http://www-4.ibm.com/software/data/db2/vse-vm/

and click on:

Click here to join the DB2 Server for VSE & Vm Forum

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 16563 60 25_Re: Can I backout a bind?14_Mullins, Craig21_Craig_Mullins@BMC.COM30_Wed, 9 Aug 2000 11:25:12 -0500332_iso-8859-1 Alison:

Just a "thought" in the dark, but do you happen to use packages? And if so, do you keep multiple versions of the package? If the answers to both are yes

you should have the "old" version of the package available. You can drop the

latest version and BIND the older version into the plan. [...] 16624 20 15_Re: DB2 Connect13_Horacio Villa17_hvilla@TTI.COM.AR30_Wed, 9 Aug 2000 13:30:28 -0300415_iso-8859-1 Lee, I think -551 is also "the object does not exist". Do you have a table named ASN.IBMSNAP_CRITSEC? Hope it helps. Horacio Villa TTI SA Buenos Aires - Argentina

================================================ 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. 16645 96 60_Re: DSNJ111E - Out of Space in Active Log Data Sets Question11_Steve Evans20_evans036@MC.DUKE.EDU30_Wed, 9 Aug 2000 12:27:40 -0400373_us-ascii carlton,

if your active logs are full, i believe you cannot shut db2 down normally (ie you will need to cancel the irlm). i think this is becuase the shutdown is itself a logged event.

but as sue (below) says, the root of the problem is with your archive process. go to the MSTR jes log & look for messages that may reflect failed log archival. [...] 16742 75 25_Re: Can I backout a bind?15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US30_Wed, 9 Aug 2000 11:41:06 -0500522_iso-8859-1 For this to work, you would require the previous package version's load module. Otherwise you would get sqlcode -818 (timestamp mismatches).

-----Original Message----- From: Mullins, Craig [mailto:Craig_Mullins@BMC.COM] Sent: Wednesday, August 09, 2000 11:25 AM To: DB2-L@RYCI.COM Subject: Re: Can I backout a bind?



Alison:

Just a "thought" in the dark, but do you happen to use packages? And if so, do you keep multiple versions of the package? If the answers to both are yes [...] 16818 22 24_connecting MTS to OS/39010_Tom Taylor17_ttaylor@CHUBB.COM30_Wed, 9 Aug 2000 12:39:30 -0400426_us-ascii Hi ALL

Trying to configure and connect using Microsoft transaction manager (MTS) on NT to a DB2 CONNECT EE V5.2 on a AIX box via SNA up to DB2 for OS/390. 1) does db2 for os/390 need any configuration? (Already running many distributed connections) 2) recieving the following error in the db2 diag log: DIA4701E database could not be opened for distributed transaction process 3) Any VTAM configurations? [...] 16841 51 17_Re: help required10_John Hardy27_john_j_hardy@CONSULTANT.COM30_Wed, 9 Aug 2000 11:50:49 -0500639_- Subrata,

As James said, you can't do it with a single query. If I was you, I would do the following:

1. Run DSNTIAUL PARM(SQL) with the following query:

SELECT A.MEMBER_CODE, A.START_DATE, B.START_DATE - 1 DAY, A.AMT FROM USERTAB A, USERTAB B WHERE A.MEMBER_CODE = B.MEMBER_CODE AND A.START_DATE < B.START_DATE AND B.START_DATE = (SELECT MIN(START_DATE) FROM USERTAB WHERE MEMBER_CODE = A.MEMBER_CODE AND START_DATE > A.START_DATE) UNION ALL SELECT MEMBER_CODE, START_DATE, START_DATE, AMT FROM USERTAB A WHERE NOT EXISTS (SELECT 1 FROM USERTAB WHERE MEMBER_CODE = A.MEMBER_CODE AND START_DATE > A.START_DATE); [...] 16893 15 28_Re: connecting MTS to OS/39014_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 9 Aug 2000 13:32:54 -0400472_us-ascii Tom, You need to configure the sna stack on your local server and configure the independent lus in VTAM on OS/390. IF you look in the DB2 Connect Quick Beginnings for your platform the basic procedures are there. HTH Phil

================================================ 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. 16909 159 16_Re: DB2 Recovery15_Murley, Michael22_Michael_Murley@BMC.COM30_Wed, 9 Aug 2000 12:40:24 -0500280_iso-8859-1 Dean,

I may not be following your scenario exactly. When you say that you did a CLI to add a copy of the archive log to the BSDS, do you mean that you added it to the existing BSDS, which also had the original archive log registered for that range of RBAs? [...] 17069 158 34_Re: view problem... thanks anyway.21_Smith, Ronald M - CNF20_smith.ronald@CNF.COM30_Wed, 9 Aug 2000 10:53:51 -0700620_iso-8859-1 Hi Mike, When using Platinum's ISQL - you need to select option "P" - for profile.. Then - check and modify the RC/Edit Profile Variables. There are two: one for DATE format, and the other for TIME format. Set them to be: ISO,USA,EUR,JIS or LOCAL , as appropriate

> -----Original Message----- > From: Backes,Michael [SMTP:BackeM@MAIL.OA.STATE.MO.US] > Sent: Wednesday, August 09, 2000 8:00 AM > To: DB2-L@RYCI.COM > Subject: Re: view problem... thanks anyway. > > list thanks anyway, have narrowed the problem down to the way platinum is > returning the current date. it is not retuning it in the [...] 17228 40 27_Re: To commit or not commit12_Kline, Wayne27_wayne.kline@INGRAMMICRO.COM30_Wed, 9 Aug 2000 11:01:35 -0700622_iso-8859-1 Steve: Do you have this paper?

Wayne

-----Original Message----- From: Roger Miller [mailto:millerrl@US.IBM.COM] Sent: Wednesday, August 09, 2000 8:39 AM To: DB2-L@RYCI.COM Subject: Re: To commit or not commit



As others noted, most of the work can proceed, but there is a significant caveat.

If you want to run your utilities online now, and the utility must drain readers, like online reorg, and you don't commit for hours, then you have a conflict. It does not matter which isolation level you use. We don't have a technique that can switch while you're still running. [...] 17269 52 27_Re: To commit or not commit12_Isaac Yassin23_yassin@NETVISION.NET.IL30_Wed, 9 Aug 2000 21:13:27 +0200533_x-user-defined Hi,

This is really the main problem with OLR (onLine Reorg). You can't do the switch phase if you don't get the claim and any long running job without commits can hold you back. It is not nice to have your OLR job terminate after 3 hours and it is not nice to make it run till eternity while waiting for the resource to be released. You may even have to revert to the (not) "good ol'days" when you didn't have OLR and use the "start access(ut)" .... Maybe we do need a way to switch while others are still [...] 17322 56 28_Re: connecting MTS to OS/39010_Tom Taylor17_ttaylor@CHUBB.COM30_Wed, 9 Aug 2000 14:06:39 -0400718_us-ascii Phil Can you be a little more specific Tom













Philip Gunning on 08/09/2000 01:32:54 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Thomas G Taylor/ChubbMail)





Subject: Re: connecting MTS to OS/390















Tom, You need to configure the sna stack on your local server and configure the independent lus in VTAM on OS/390. IF you look in the DB2 Connect Quick Beginnings for your platform the basic procedures are there. HTH Phil [...] 17379 22 28_Re: connecting MTS to OS/39014_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 9 Aug 2000 14:34:20 -0400557_us-ascii Tom, IF you want to communicate with a DB2 for OS/390 DB2, then you need to provide an SNA stack like E-Network Server on AIX or IBM Comm Server on AIX. DB2 Connect EE then uses this stack to connect to DB2 for OS/390. Of couse you can use TCP/IP for this, but you may be using SNA for other reasons. After your SNA stack is configured on the server and OS/390(VTAM), then you have to catalog the database using either the Client Configuration Assistant or command line. Step by step procedures are in the DB2 Connect Quick Beginnings manuals [...] 17402 18 19_SMALLER active logs10_Tom Taylor17_ttaylor@CHUBB.COM30_Wed, 9 Aug 2000 15:03:38 -0400475_us-ascii Hi all

I Want to make the active log datasets SMALLER. The activity on the system they are apart of has dropped considerably. I would like to get back some Dasd. What are the procedures to accomplish this.?

Tom

================================================ 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. 17421 124 30_Re: OAM and recovery questions12_Kirk Hampton16_khampto1@TXU.COM30_Wed, 9 Aug 2000 14:06:47 -0500576_us-ascii Hello Peter, I am not familiar with duplexing of objects, but as far as I know, if you issue an OSREQ to delete an object that resides on DASD (in the DB2 GROUPnn tables) when that OSREQ completes successfully, that object is physically gone, forever, sayonara, no rollback , no recovery. Unless there is a Unit-of-Work parameter on the OSREQ macro, (and I don't believe there is) the DB2 work done by OAM is committed when a single instance of the OSREQ macro completes successfully. And since the DB2 operations are being done by the OAM address space on your [...] 17546 48 23_Re: SMALLER active logs13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM30_Wed, 9 Aug 2000 12:15:37 -0700348_iso-8859-1 Make sure all other active logs except the current one being used are archived. Stop DB2 and do an IDCAMS DELETE/DEFINE of these 'other' active logs with smaller sizes . Start DB2 and issue an Archive log command so that the current active log also gets archived. Again stop DB2 and repeat IDCAMS DELETE/DEFINE for this active log. [...] 17595 21 37_List of abbreviations and/or acronyms15_Schaeffer, Dave28_dave.schaeffer@HONEYWELL.COM30_Wed, 9 Aug 2000 12:14:36 -0700303_- We are putting together a data dictionary of approved abbreviations and/or acronyms and was trying to get a starting list. I have searched the military sites for such a list and have come up empty handed. Does anyone know of a site where I could download or possibly send me such a list? Thanks. [...] 17617 53 41_Re: List of abbreviations and/or acronyms19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM30_Wed, 9 Aug 2000 14:35:31 -0500586_ISO-8859-1 Dave, I believe the national bureau of standards, or the commerce department use to publish what you're looking for -- been some time since I've looked. Don't know if there's a website . . . sorry

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 [...] 17671 103 47_DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP11_Emery, Matt19_matt.emery@JNLI.COM30_Wed, 9 Aug 2000 15:37:00 -0400311_iso-8859-1 I am trying to get DB2 OS/390 version 5.1 to talk to DB2/UDB version 7.1 on AIX via a TCP/IP connection. The documentation says that I should be able to use SPUFI to test the connection. It is not working. Has anyone done this? What is needed on the OS/390 side? What is needed on the AIX side? [...] 17775 944 15_Re: DB2 Connect10_Mike Paris14_MPARIS@TUC.COM30_Wed, 9 Aug 2000 14:44:48 -0500308_ISO-8859-1 Lee,

For AIX to MVS replication we set up the AIX DB2 Instance Owner as a DBADM on the mainframe database containing the ASN tables for apply access. Then individual grants are performed for select access on the source and CD tables. I do not know if this applies to your environment. [...] 18720 234 41_Re: List of abbreviations and/or acronyms0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM30_Wed, 9 Aug 2000 14:44:33 -0500438_us-ascii Here is a list from a newspaper article. Enjoy!!





Techno-Geeks Scramble English; Here's a Primer

THE NEW YORK TIMES



For linguistic purists, the world at the dawn of the 21st century is, well, a mess. Management consultants, marketing experts, lawyers and, especially in recent years, techno-geeks have cluttered American English with shorthand indecipherable to all but insiders. [...] 18955 16 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Philip Gunning18_pgunning@PHEAA.ORG30_Wed, 9 Aug 2000 15:57:13 -0400317_us-ascii Matt, You need to configure the communication database on OS/390 (sysibm.ipnames,usernames), grant authorization in DB2 on AIX, and bind the SPUFI packages from OS/390 to DB2 V7 on AIX. Packages are DSNECP68 DSNESM68, I believe. If not, check back with me I can check my notes tonight at home. HTH Phil [...] 18972 15 41_Re: List of abbreviations and/or acronyms13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM30_Wed, 9 Aug 2000 14:40:51 -0500382_- Why not base your field names on one of the many competing XML standards for your field, like: http://www.commerceone.com/xml/

-HJC

================================================ 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. 18988 178 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Wed, 9 Aug 2000 16:09:11 -0400560_iso-8859-1

On the OS390 side:

1. You need to insert rows in IPNAMES, LOCATIONS and USERNAMES (if you want outbound ID translation). 2. Bind SPUFI package to the AIX DB.

On the AIX side: 1. Set AUTHENTICATION parameter on your AIX DBM CFG to CLIENT 2. and TRUST_ALLCLNTS to DRDAONLY.



Manas. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Emery, Matt Sent: Wednesday, August 09, 2000 3:37 PM To: DB2-L@RYCI.COM Subject: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP [...] 19167 112 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM30_Wed, 9 Aug 2000 16:28:55 -0400307_iso-8859-1 We have OS/390 SPUFI talking to DB2 v 5.2 on AIX. The oddest part of the setup to me was populating SYSIBM.LOCATIONS and using the UDB database alias as the LOCATION. For example, if you want to select some rows from the SAMPLE database distributed with DB2 for AIX, SAMPLE is the LOCATION. [...] 19280 197 26_JDBC from Win 95 to OS/39011_Chad Walmer19_cwalmer@RITEAID.COM30_Wed, 9 Aug 2000 16:43:33 -04001245_- @ECHO OFF SET CLASSPATH=.;C:\SQLLIB\JAVA\DB2JAVA.ZIP;C:\SQLLIB\JAVA\RUNTIME.ZIP;C:\JAVA SET PATH=C:\SQLLIB\JAVA\DB2JAVA.ZIP;C:\SQLLIB\BIN;C:\JDK1.3\BIN;C:\ORAWIN95\BIN; SET PATH=%PATH%;%PATH%;C:\IBMVJAVA\EAB\BIN;C:\IBMVJAVA\HPJ\BIN;C:\NOVELL\CLIENT32;%PATH%;C:\READIBMW;C:\IBMCON~1\CICS\BIN IF EXIST C:\IMNNQ_95\IMNENV.BAT CALL C:\IMNNQ_95\IMNENV.BAT set NWLANGUAGE=ENGLISH SET LIB=%LIB%;C:\IBMVJAVA\EAB\LIB;C:\SQLLIB\LIB SET INCLUDE=C:\SQLLIB\INCLUDE;%INCLUDE%;C:\IBMVJAVA\EAB\INCLUDE;C:\JDK1.3\INCLUDE SET BOOKSHELF=C:\IFOR\WIN\BIN\EN_US SET HELP=C:\IBMVJAVA\EAB\C:\IFOR\WIN\BIN;C:\IFOR\WIN\BIN SET IPF_PATH32=C:\SQLLIB\;C:\IFOR\WIN\BIN\EN_US SET DB2CODEPAGE=850 SET INOCULAN=C:\PROGRA~1\CHEYENNE\ANTIVI~1 C:\PROGRA~1\CHEYENNE\ANTIVI~1\EXAMINE.EXE Set NWLANGUAGE=ENGLISH SET IVJ_DBG_LANG=CPP SET IVJ_DBG_IOCRESFILE=IVJZUR20 SET IMNINST=help SET LOCPATH=C:\IBMVJava\eab\locale; SET NLSPATH=C:\IBMVJava\eab\msg\%N; SET LANG=en_us SET PATH=%PATH%;%PATH%;%PATH%;C:\IBMCON~1\ENCINA\BIN;C:\SQLLIB\BIN;C:\SQLLIB\HELP;C:\IFOR\WIN\BIN;C:\IFOR\WIN\BIN\EN_US SET NLSPATH=%NLSPATH%;C:\IBMCON~1\ENCINA\%%L\%%N;C:\IFOR\LS\MSG\%%L\%%N SET I4_LANG=EN_US SET I4_INSTALL_DRIVE=C: CALL C:\PROGRA~1\PERSON~1\PCSVARS.BAT SET DB2INSTANCE=DB2 SET DB2PATH=C:\SQLLIB 19478 50 15_Re: DB2 Connect10_Lee Herbst29_lherbst@PROPAPPR.MARION.FL.US30_Wed, 9 Aug 2000 16:39:26 -0400511_us-ascii Mike,

That is basically the way we have it setup. The userid we are using is a DBADM on NT and on the mainframe. We can log on to the mainframe database using this userid and password and are able to access all of the needed tables. However when we run apply, we get the 'Get Timestamp Failed error' and we can't seem to find out why. I think we have one configuration error somewhere, but I have been over them with a fine-tooth comb and can't see any problems. Thanks, I'll keep digging. [...] 19529 145 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP0_22_BILL_GALLAGHER@PHL.COM30_Wed, 9 Aug 2000 16:58:27 -0400516_iso-8859-1 I've been wanting to try this for some time, but haven't had the opportunity until now:

When I try to bind the SPUFI package to AIX using the following BIND syntax on OS390, I'm getting the following error:

Bind Syntax:

BIND PACKAGE(SAMPLE.DSNEDCL) MEMBER(DSNECP68) - LIBRARY('SYSD1.DSN610.SDSNDBRM') - OWNER(TECWRG ) QUALIFIER(TECWRG ) CURRENTDATA(YES) - EXPLAIN(NO ) ACTION(REPLACE) - SQLERROR(NOPACKAGE) ISOLATION(CS) - DEGREE(1 ) - NOREOPT(VARS) - KEEPDYNAMIC(NO ) - FLAG(I) [...] 19675 120 30_Re: JDBC from Win 95 to OS/39010_Mike Evans28_EVANSMP@CO.MECKLENBURG.NC.US30_Wed, 9 Aug 2000 17:02:56 -0400476_US-ASCII Chad, I've attached a simple java program to connect to DB2 that works with db2 connect. DB2T is the name of the subsystem. Give it a try.

Mike Evans Data Manager Mecklenburg County Information Services & Technology 704-336-2906 phone 704-336-7219 fax evansmp@co.mecklenburg.nc.us

>>> Chad Walmer 08/09/00 04:43PM >>> When trying to run a simple jdbc app which connects to DB2 OS/390, I'm getting the following error message: [...] 19796 112 30_Re: JDBC from Win 95 to OS/39023_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM30_Wed, 9 Aug 2000 17:06:48 -0400390_- Chad,

Both the net and app DB2 drivers are included in DB2JAVA.ZIP. I have had no problem running both JDBC and SQLJ applications. I had received the same error message once when I had specified the 'net' driver instead of the 'app' driver. I have JDBC drivers installed as part of UDB/NT ver 6. What is your source of JDBC drivers. Also, are you loading the driver as follow [...] 19909 173 30_Re: JDBC from Win 95 to OS/39011_Chad Walmer19_cwalmer@RITEAID.COM30_Wed, 9 Aug 2000 17:25:05 -0400542_iso-8859-1 Sanjay, Here is a copy of the java source I was using:

import java.sql.*;

public class TestConnect {

static { try { Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); } catch(ClassNotFoundException e) { e.printStackTrace(); } }



public static void main(String argv[]) { try { String url = "jdbc:db2os390:lsysd";

Connection con = DriverManager.getConnection(url);

Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM SYSIBM.LOCATIONS WITH UR"); [...] 20083 71 30_Re: JDBC from Win 95 to OS/39011_Chad Walmer19_cwalmer@RITEAID.COM30_Wed, 9 Aug 2000 17:25:06 -0400398_iso-8859-1 Mike, I tried the java program that you attached but received the same error. It seems that the error is probably in my pc's set-up somewhere.

Thanks... Chad

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Mike Evans Sent: Wednesday, August 09, 2000 5:03 PM To: DB2-L@RYCI.COM Subject: Re: JDBC from Win 95 to OS/390 [...] 20155 165 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM30_Wed, 9 Aug 2000 17:32:13 -0400614_iso-8859-1 Bill:

Looks like its complaining about one of the options. Try removing NOREOPT(VARS) ...

Manas.

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > BILL_GALLAGHER@PHL.COM > Sent: Wednesday, August 09, 2000 4:58 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP > > > I've been wanting to try this for some time, but haven't had the > opportunity until now: > > When I try to bind the SPUFI package to AIX using the following > BIND syntax > on OS390, I'm getting the following error: > [...] 20321 446 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM30_Wed, 9 Aug 2000 16:33:43 -0500355_US-ASCII Bill, Try adding VALIDATE(BIND) to the bind statement. HTH Kurt



>>> BILL_GALLAGHER@PHL.COM 08/09/00 03:58PM >>> I've been wanting to try this for some time, but haven't had the opportunity until now:

When I try to bind the SPUFI package to AIX using the following BIND syntax on OS390, I'm getting the following error: [...] 20768 28 72_Installing DB2 UDB 6.1 on Windows/NT, Administrative user not recognized12_Dudley Moore16_dumoore@NMSU.EDU30_Wed, 9 Aug 2000 14:34:39 -0600484_us-ascii Hello everybody,

I sent out a question about installing DB2/UDB v6.1 on NT and having a problem with the install user not existing to the SETUP program. The problem was the server is a domain server, rather than a member server, and the default domain the SETUP program was supplying was different from where the user list file was located. So, once I prefixed the install user with the 'domain name' it was able to verify its existence and complete the install. [...] 20797 131 27_Re: To commit or not commit0_19_Tim.Lowe@STPAUL.COM30_Wed, 9 Aug 2000 17:29:41 -0500624_us-ascii Isaac, Reading the white-paper that Roger mentioned, it appears to me that this is already a known requirement. (see page #12, under "submit requirements to IBM for quadrant C objects to improve availability": "tolerate CS applications which do not commit frequently".)

I remember hearing (long ago) that online reorg was "moved forward" in the schedule to version 5 due to the amount of customer interest. But I also remember hearing that this was partially done by not implementing some of the "bells and whistles", which might then be added in the future. (some of which have been added since then). [...] 20929 25 51_DB2 Connect attempting talk to OS390 protocol error13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Wed, 9 Aug 2000 19:52:08 EDT377_- Hi List,I am trying to get DB2 Connect on NT to talk to DB2 OS/390 version 6.1 TCP/IP connection. First, we had authentication problem, then protocol error problem. I fiddled around with it but nothing seems to work. Is there a checlist I can use as a step by step to accomplish this type of connection? What is needed on the OS/390 side? What is needed on the NT side? [...] 20955 71 61_Re: DSNJ111E - Out of Space in Active Log Data Sets Quest ion14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 10 Aug 2000 11:05:10 +1000308_iso-8859-1 I have found that if db2 is unable to generate the archive log, it will retry several times and then just stop trying. This usually happens if the archives are to disk and then they are HSM migrated. If the migrates aren't done quickly enough, there are space problems creating the archives. [...] 21027 49 55_Re: DB2 Connect attempting talk to OS390 protocol error0_15_leon@CA.IBM.COM30_Wed, 9 Aug 2000 22:28:07 -0400435_us-ascii Most setup errors are a result of customers failing to follow setup process outlined in the DB2 Connect Quick Beginnings manual. Have you looked at this book? Have you followed the steps?

Leon Katsnelson, DB2 Connect Development Manager mailto:leon@ca.ibm.com



Carlton Enuda on 08/09/2000 07:52:08 PM

Please respond to DB2 Data Base Discussion List [...] 21077 51 55_Re: DB2 Connect attempting talk to OS390 protocol error13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 9 Aug 2000 22:34:14 -0400612_iso-8859-1 Hi Carlton, As I recall, the TCP/IP enabling of a subsystem is well-documented in a set of steps in the DB2 Install guide.

Once that's enabled and you've restarted DB2, the NT side of it is extremely simple. 1) On OS/390 look in the JES log for the MSTR address space for the subsystem. Find the "TCP/IP Services Available" message Following that message are the values for the configuration you need on NT. In the DSNL004I message you'll see LOCATION, DOMAIN, and TCPPORT values. 2) In the Client configuration assistant dialog, Select Add database 3) Select Manually configure 4) Select [...] 21129 19 55_Re: DB2 Connect attempting talk to OS390 protocol error13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM30_Wed, 9 Aug 2000 22:35:37 -0400429_iso-8859-1 Whoops. Do what Leon says.

Then let me know what I told you incorrectly.

David Seibert Compuware Corporation File-AID Product Architect Dave.Seibert@Compuware.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 21149 169 19_Re: view problem...23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Thu, 10 Aug 2000 02:14:33 -0000503_iso-8859-1 ARE THE VALUES RETURNED FROM SELECT SUBSTR (CHAR (CURRENT_DATE),1,4) || SUBSTR (CHAR (CURRENT_DATE),6,2) || SUBSTR (CHAR (CURRENT_DATE),9,2)) (FROM A TABLE WITH A SINGLE ROW IN IT ) THE SAME FROM BOTH SOURCES.

Andrew Puddy IBMGSA (onsite at Comalco) Phone 07 3867 1747 Mobile 0419 824 076





-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Thursday, 10 August 2000 0:48 To: DB2-L@RYCI.COM Subject: Re: view problem... [...] 21319 141 16_Re: DB2 Recovery23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM30_Wed, 9 Aug 2000 15:29:47 +0100488_iso-8859-1 I would say that you are trying to do a Conditional Restart????????????????????????



If so then you do not want the start abd end RBA as the same .. but instead a Conditional Restart record created ..

Once again this is well documented int he Manual ..

regards

Leslie

-----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Wednesday, August 09, 2000 3:20 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Recovery [...] 21461 15 32_DB2 Trigger calling UDF in COBOL14_Essy Nokhodian15_dbaen@TEXAS.NET31_Thu, 10 Aug 2000 02:17:49 -0500387_- Hi,

I am looking for a working example of DB2/Trigger calling a UDF in Cobol. Please list all the objects(Trigger,Cobol).

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. 21477 58 41_Re: List of abbreviations and/or acronyms4_IBM119_IBM1@EGEBANK.COM.TR31_Thu, 10 Aug 2000 11:39:11 +0300813_- have you tried

http://www.tsproviders.com/scrabble/

???

the only place I look for acronyms is the SCRABBLE admitted wordlist!!

:-)

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced.

*std disclaimer*

> -----Original Message----- > From: Schaeffer, Dave [SMTP:dave.schaeffer@HONEYWELL.COM] > Sent: Wednesday, August 09, 2000 10:15 PM > To: DB2-L@RYCI.COM > Subject: List of abbreviations and/or acronyms > > We are putting together a data dictionary of approved abbreviations and/or > acronyms > and was trying to get a [...] 21536 92 41_Re: List of abbreviations and/or acronyms12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 10 Aug 2000 10:26:00 +0100490_- Try this:

http://www.acronymfinder.com/

for IT specific:

http://www.whatis.com/

Colin Allen Abbey National ---------- From: DAVIS, RICK (SBCSI) To: DB2-L@RYCI.COM Subject: Re: [DB2-L] List of abbreviations and/or acronyms Date: 09 August 2000 08:35PM

Dave, I believe the national bureau of standards, or the commerce department use to publish what you're looking for -- been some time since I've looked. Don't know if there's a website . . . sorry [...] 21629 170 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 10 Aug 2000 07:02:49 -0400663_iso-8859-1 Bill,

I got this to work using the following (DB2 V5.1 OS/390 2.7):

BIND PACKAGE (BG1TO1DB.DSNESPCS) OWNER (OSS02) QUALIFIER (OSS02) MEMBER(DSNESM68) LIBRARY('DB2SMPE.V51.DB2TZT1.SDSNDBRM') SQLERROR(NOPACKAGE) VALIDATE(BIND) ISOLATION(CS) CURRENTDATA(YES) ACTION(REPLACE)

R/...

Ed Vetock







BILL_GALLAGHER@PHL.COM@RYCI.COM> on 08/09/2000 04:58:27 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP [...] 21800 56 55_Re: DB2 Connect attempting talk to OS390 protocol error0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 10 Aug 2000 07:06:28 -0400529_us-ascii Carlton,

If you have access to the REDBOOK , "The Universal Connectivity Guide to DB2" , there are detailed checklists in there.

R/...

Ed Vetock







Carlton Enuda @RYCI.COM> on 08/09/2000 07:52:08 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: DB2 Connect attempting talk to OS390 protocol error [...] 21857 25 55_Re: DB2 Connect attempting talk to OS390 protocol error14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 10 Aug 2000 08:12:13 -0400417_us-ascii Carlton, Use the Quick Beginnings book for your Windows NT, that has step by step procedures. Tells you how to setup OS/390 sysibm.locations and usernames. For additional info on setting up TCP/IP, RACF, Open Edition, and DB2 for OS/390, see the redbook, WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database. SG24-2212-00. Also, see info APARS II11164, II11263, II10962. HTH Phil [...] 21883 15 55_Re: DB2 Connect attempting talk to OS390 protocol error14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 10 Aug 2000 08:17:12 -0400481_us-ascii Carlton, Also see the DB2 Connect Users Guide, www.software.ibm.com/data/dba/udb, it has specific common protocol errors documented with suggested action. It is also a good book to have when supporting DB2 connect in general. Phil

================================================ 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. 21899 27 91_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP(Binding SPUFI to DB2 on AIX or NT, etc)14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 10 Aug 2000 08:37:04 -0400618_us-ascii Srinivas, This is really not documented anywhere. I did this at my previous employer. Basically you have to create a userid on NT or AIX, grand connect to database, create in schema, bindadd authorities. Then in DB2 for OS/390 you need to setup sysibm.ipnames with the DB2 UDB location, ip address, and port # for Db2 on AIX//NT,etc. (50000). Setup sysibm.usernames for outbound userid translation if required. Then bind the SPUFI packages from OS/390 to DB2 on AIX/NT. Packages are DSNECP68,DSNESM68. You can then run SPUFI against UDB on AIX/NT, etc. Just remember to specify the location on the SPUFI [...] 21927 108 17_Re: DB2 Utilities16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Thu, 10 Aug 2000 09:24:48 -0400384_iso-8859-1 What I heard from IBM was a new set of tools (like Plat. or BMC ) was the "additional cost" . A lite version was delivered with DB2. Steve Cockerill National Gypsum Co Charlotte, NC (704) 365-7342

-----Original Message----- From: Andrea Milligan [mailto:Andrea_Milligan@BCBST.COM] Sent: Friday, August 04, 2000 5:18 PM To: DB2-L@RYCI.COM Subject: DB2 Utilities [...] 22036 76 17_Re: DB2 Utilities4_IBM119_IBM1@EGEBANK.COM.TR31_Thu, 10 Aug 2000 16:33:04 +0300416_- please look in the archives :-)

we went on for weeks about this back right after IDUG, if I am not wrong

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 22113 95 17_AW: DB2 Utilities12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 10 Aug 2000 15:35:47 +0200373_iso-8859-1 Steve,

there was an announcement at the last IDUG conference concerning just that. From my point of view IBM will unbundle some or all of the DB2 utilities. There was a discussion of just that right also in the list. You may want to look at the archives under http://jupiter.ryci.com/archives/db2-l.html [...] 22209 90 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 10 Aug 2000 10:01:08 -0400416_iso-8859-1 Srinivas:

Other than IBM's CF411 course I haven't seen a single document that says it all. You can however look at Installation Guide (DB2 OS/390) Chapter 3 for more info on how to populate the Communications Database and Admin Guide: Design & Implementation Chap. 6(DB2/AIX) for setting up DB2/AIX authentications. Just remember LOCATION in CDB is actually a database name in DB2 for AIX/NT. [...] 22300 116 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP0_23_sjtoeniskoetter@AEP.COM31_Thu, 10 Aug 2000 10:07:50 -0400470_us-ascii I think the book The DB2 Universal DRDA Certification Guide does a nice job of documenting this.









Manas Dasgupta @RYCI.COM> on 08/10/2000 10:01:08 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP [...] 22417 370 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP11_Emery, Matt19_matt.emery@JNLI.COM31_Thu, 10 Aug 2000 10:12:21 -0400481_iso-8859-1 Thanks for all the help. We are close but still have a problem. When binding the spufi packages and plans to the AIX Location we can access the AIX database through Spufi, but when we try to access the DB2 OS/390 subsytem we get an error. How can we get spufi to work with local DB2 OS/390 subsystem and with remote AIX databases without having to rebind all the time? Specifying the connection location in Spufi doesn't solve the problem. What are we doing wrong? [...] 22788 19 22_PSW:CAE NT to DB2 V51019_ESTRIBEAU Christian40_Christian.ESTRIBEAU@AIRBUS.AEROMATRA.COM31_Thu, 10 Aug 2000 16:10:27 +0200540_iso-8859-1 I'd like to be able to change my password which was revoked by RACF, from a CAE personal connect NT which accesses to DB2 V5110 0S/390 in TCP/IP. Can you tell me what kind of softwares must be installed and which versions ? Thanks.



christian.estribeau@airbus.aeromatra.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. 22808 470 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 10 Aug 2000 10:38:26 -0400589_iso-8859-1 Matt:

You shouldn't have to rebind - What error are you getting ?

Manas. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Emery, Matt Sent: Thursday, August 10, 2000 10:12 AM To: DB2-L@RYCI.COM Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP



Thanks for all the help. We are close but still have a problem. When binding the spufi packages and plans to the AIX Location we can access the AIX database through Spufi, but when we try to access the DB2 OS/390 subsytem we get an error. [...] 23279 150 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 10 Aug 2000 09:43:14 -0500634_ISO-8859-1 You sure you had the correct location entered on the SPUFI panel?



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." [...] 23430 984 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP11_Emery, Matt19_matt.emery@JNLI.COM31_Thu, 10 Aug 2000 10:54:49 -0400582_iso-8859-1 Here is a synopsis from our System Programmer... JUNK is the database name on AIX.

We are currently running DB2 OS/390 version 5.1 ESO9905 on OS/390 2.7 ESO 9912 and want to use SPUFI to connect to and perform queries on our UDB 6.1 on AIX 4.3.3. We have made the appropriate entries in sysibm.locations,sysibm.ipnames,sysibm.usernames and it seems to work quite well. We are a TCPIP shop only (we do NOT have SNA on the RS/6000 so we do not have LU6.2 available for this connection) The problem now is that SPUFI no longer works for the OS/390 DB2 subsytem. [...] 24415 12 6_Thanks14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 10 Aug 2000 11:01:44 -0400298_- to those who helped me out with my Recovery questions.

================================================ 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. 24428 220 30_Re: JDBC from Win 95 to OS/39023_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 10 Aug 2000 11:18:03 -0400693_iso-8859-1 I could run your program after making following changes.

1) String url = "jdbc:db2:lsysd"; <===== change db2os390 to db2

2) Add userid and password while connecting

String userid = "xxxxxxx"; String passwd = "yyyyyy"; Connection con = DriverManager.getConnection(url,userid,passwd); <==== add userid and pasword

Give it a try.



Sanjay Jain 8-226-7069

> -----Original Message----- > From: Chad Walmer [SMTP:cwalmer@RITEAID.COM] > Sent: Wednesday, August 09, 2000 5:25 PM > To: DB2-L@RYCI.COM > Subject: Re: JDBC from Win 95 to OS/390 > > Sanjay, > Here is a copy of the java source I was using: > > import java.sql.*; > > public [...] 24649 1165 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 10 Aug 2000 11:24:37 -0400468_iso-8859-1 Matt:

You need a single BIND PLAN and include both the packages in your PKLIST. If you have many locations you may want to code as PKLIST(*.DSNESPCS.DSNESM68) (I haven't tried this but should work).

Manas. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Emery, Matt Sent: Thursday, August 10, 2000 10:55 AM To: DB2-L@RYCI.COM Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP [...] 25815 780 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP11_Emery, Matt19_matt.emery@JNLI.COM31_Thu, 10 Aug 2000 11:41:41 -0400542_iso-8859-1 It works. It works. Thanks to all, for your time and help. Manas and Rick, you are my heroes.

-----Original Message----- From: Manas Dasgupta [mailto:manas.dasgupta@PFSFHQ.COM] Sent: Thursday, August 10, 2000 11:25 AM To: DB2-L@RYCI.COM Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP



Matt:

You need a single BIND PLAN and include both the packages in your PKLIST. If you have many locations you may want to code as PKLIST(*.DSNESPCS.DSNESM68) (I haven't tried this but should work). [...] 26596 244 30_Re: JDBC from Win 95 to OS/39011_Chad Walmer19_cwalmer@RITEAID.COM31_Thu, 10 Aug 2000 11:52:47 -0400386_iso-8859-1 Thanks for the response Sanjay. Unfortunately, even with the changes you suggested below I'm still getting the 'no suitable driver' message. Is there a book or manual which outlines all of the different autoexec.bat settings for DB2 Connect. I've read the "Configuring the Environment" section in the Quick Beginnings book but it only references the CLASSPATH variable. [...] 26841 15 70_Re: DB2 OS/390 V5.1: All subsystems abended on TEST LPAR with 00E5070517_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM31_Thu, 10 Aug 2000 10:30:29 -0500464_- I would probably guess this to ba an issue with IRLM. Look at the IRLM status on the LPAR. If the IRLM caused ECSA overload, it could spill into ECSA and cause an abend. You can see more info with a EREP. Regards, Venkat

================================================ 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. 26857 67 41_DRAIN LOCK on changing a partitioning key15_Stovall, Martin16_MStovall@USG.COM31_Thu, 10 Aug 2000 11:03:16 -0500549_iso-8859-1 We have a batch process that updates the partitioning key and we have been receiving -904 with A 00C200EA reason code which is a drain lock timeout. I understand that DB2 takes a drain lock On the partitions when moving rows due to the partitioning key being updated. Does the DRAIN In this situation wait the same as a lock timeout (IRLMWRT DSNZPARM) or the same as the utility DRAIN time which is the UTIMOUT DSNZPARM. We have IRLMWRT set to 60 but the UTIMOUT is set to 6. Is there any risk Involved in changing the UTIMOUT to be [...] 26925 16 45_Re: DRAIN LOCK on changing a partitioning key17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM31_Thu, 10 Aug 2000 11:05:19 -0500400_- The UTIMOUT affects only utility processing. It does not have any effect on other programs. The cover letter for the APAR that lifted this restriction provides more information on the effects of concurrency when you update partitioning key. It tries to drain the range of all NPIs as well. we have found that concurrency can't be achieved if you let a process update the partition key. Venkat [...] 26942 268 51_Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP17_Necessary, Cheryl31_Cheryl.Necessary@INGRAMBOOK.COM31_Thu, 10 Aug 2000 11:15:22 -0500379_iso-8859-1 Matt, Include both the local and remote packages in your package list for the plan binds. Thanks, Cheryl L. Necessary MIS DBA Ingram Book Company





-----Original Message----- From: Emery, Matt [mailto:matt.emery@JNLI.COM] Sent: Thursday, August 10, 2000 9:55 AM To: DB2-L@RYCI.COM Subject: Re: DB2 OS/390 talking to DB2/UDB on AIX via TCP/IP [...] 27211 10 45_Re: DRAIN LOCK on changing a partitioning key10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Thu, 10 Aug 2000 12:46:19 -0400543_- At this point in time it might be a good idea to change the partitioning key update to a delete and an insert. Allowing the update to occur could cause some serious timeouts. For example if you have a large tablespace with 254 partitions and a programs changs a key to move a row from partition 1 to partition 254, DB2 will issue a drain for every partition in the tablespace. Not a good thing. We currently disallow partition key updates. Allowing the update as long as the row stays in the same partition might be ok, but could cause [...] 27222 14 50_Experiences with DB2 OS/390 v6 Predictive Governor18_Kimball, William P19_KimballWP@AETNA.COM31_Thu, 10 Aug 2000 12:55:28 -0400426_- I was wondering if anyone out there has used the new v6 predictive governor and what experiences, plus or minus, they might have had? Thanks in advance.

regards - Bill Kimball

================================================ 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. 27237 27 29_Db2 Rexx book URL required...23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 10 Aug 2000 10:34:11 +0100518_iso-8859-1 Anybody have the url to the Rexx/Db2 book(s)?

thanks

Leslie



********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Sony cannot accept liability for statements made which are clearly the sender's own and not made on behalf of Sony. (01) ********************************************************************** [...] 27265 14 55_ESTHER CENG LAY BIAN/AUDIT/IA/SGX is out of the office.0_28_lbceng@SINGAPOREEXCHANGE.COM31_Fri, 11 Aug 2000 01:01:59 +0800365_us-ascii I will be out of the office from 11/08/2000 until 14/08/2000.

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. 27280 101 35_Re: Varchar(32672) vs. Long Varchar0_18_damcon2@US.IBM.COM31_Thu, 10 Aug 2000 13:37:51 -0400552_us-ascii Hi Scott,

Along the same lines... I've been wrestling with the pro's and con's of this issue. I had settled on long varchar thinking that it would be better to have the long data separate from the rest of the row so the larger pages wouldn't have to be moved around unless the long data was actually accessed. However, I did not know that long data only used physical i/o. I assumed it would use the bufferpool that the long tablespace is assigned to. One thing that I did notice about long varchars that I didn't like was the way [...] 27382 53 33_Re: Db2 Rexx book URL required...9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Thu, 10 Aug 2000 11:56:06 -0600550_iso-8859-1 Howdy Les,

Attached is the URL you want. By the way what do you think about Larry Ellison making moves to make Oracle "an island unto itself" by ticking-off the 'big four' (SAP, Seible, Peoplesoft and I2).

http://www-4.ibm.com/software/ad/obj-rexx/ibmrexxp.html

Cheers, Don Alden (-o: Senior DB2 Consultant

-----Original Message----- From: Pendlebury-Bowe, Leslie [mailto:Leslie.Pendlebury-Bowe@EU.SONY.COM] Sent: Thursday, August 10, 2000 3:34 AM To: DB2-L@RYCI.COM Subject: Db2 Rexx book URL required... [...] 27436 293 29_Re: Stored Procedure Question13_Carlton Enuda24_carltonenuda@HOTMAIL.COM28_Tue, 8 Aug 2000 10:28:24 EDT646_- To Shan_Leatherman, Thanks for the response Carlton



>From: Shan_Leatherman/MO/americancentury@AMERICANCENTURY.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Stored Procedure Question >Date: Tue, 8 Aug 2000 08:11:50 -0500 > >Hi Carlton, > The request form we have programmers submit to DBAs for table , index >or >stored >procedure request is in a Lotus Notes database (soon to be changed and >stored on >the web) >For some reason I'm unable to copy the request form and paste it so I'll >just >list the items >we ask for. This is geared for V5 and is being changed for V6. > [...] 27730 41 26_Disaster recovery strategy41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Thu, 10 Aug 2000 16:36:32 -0300656_iso-8859-1 Esteemed list,

During last few days, we DBAs have been facing a problem regarding disaster recovery in our company. We have made a procedure for disaster recovery based on DB2 manuals' guideline (DB2 V5 Administration Guide Section 4.6.8.1.2 - Essencial Disaster Recovery Elements). The manual says it is necessary to make additional copies for disaster recovery using COPY with RECOVERYDDN option. Then, at recovery time, a new site should be installed using the RECOVERYSITE option. However, our DB2 system programmers do not want to make copies using RECOVERYDDN option. Instead, they want to take a second image copy with option [...] 27772 18 64_Can I change DB2 table CREATOR column ID w/o Dropping the table?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Thu, 10 Aug 2000 16:08:34 EDT528_- Hi List, Is there a way to change SYSTABLES CREATOR column-id without drop/recreate the table? Any tips will be appreciated Carlton

________________________________________________________________________ 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. 27791 56 68_Re: Can I change DB2 table CREATOR column ID w/o Dropping the table?0_22_BILL_GALLAGHER@PHL.COM31_Thu, 10 Aug 2000 16:14:29 -0400489_us-ascii Carlton,

Unfortunately, no you cannot change the creator of a table without dropping and recreating it.

Bill Gallagher, DBA Phoenix Home Life Enfield, CT







Carlton Enuda cc: Sent by: DB2 Subject: Can I change DB2 table CREATOR column ID w/o Dropping the Data Base table? Discussion List



08/10/00 04:08 PM Please respond to DB2 Data Base Discussion List [...] 27848 56 56_DB2 Connect Version Mismatch in a PeopleSoft Environment19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Thu, 10 Aug 2000 13:23:27 -0700555_- This question concerns the ability to handle various versions and fixpacks of DB2 Connect on client machines when mixed into a PeopleSoft (V7.02 Human Resources) database on DB2 OS/390 environment. We're wondering who else might have seen this issue and if/how you were able to address it.

Configuration: DB2 V5.2 OS/390 at 9911 handling the database PeopleSoft Application Server running DB2 Connect V5.2 EE Client PC (developer w/ Windows NT sp 5) with both 2-tier (PC to OS/390 DB) and 3-tier (PC to App Server to OS/390 DB) connections. [...] 27905 99 60_Re: DB2 Connect Version Mismatch in a PeopleSoft Environment12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 10 Aug 2000 13:31:44 -0700592_us-ascii I can't speak about a Peoplesoft environment. But my client is currently running with DB2 Connect clients at 5.2, 5.2 fixpack 10, fixpack 12, fixpack 12e, 6.1, 6.1 fixpack 4, and 7.1 without any problems. They are connecting to both DB2 V5.1 and DB2 V6.1. --- "Ohling, Tim R - CNF" wrote: > This question concerns the ability to handle various > versions and fixpacks > of DB2 Connect on client machines when mixed into a > PeopleSoft (V7.02 Human > Resources) database on DB2 OS/390 environment. > We're wondering who else > might have seen this issue and [...] 28005 296 30_Re: JDBC from Win 95 to OS/39023_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 10 Aug 2000 16:44:55 -0400440_iso-8859-1 Chad,

I don't know about any books or article that outlines db2 connect setting (I am sure there is one). I didn't use any to set up server definition on my PC. My guess would be to check db2 server definition under CCA. I assume you are using TCPIP protocol to connect to DB2/os390 ? Attached is my classpath definition, which might give you some clue. As far as I know, all you need is DB2JAVA.zip and RUNTIME.zip. [...] 28302 48 33_Re: Db2 Rexx book URL required...17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Thu, 10 Aug 2000 16:51:55 EDT763_- Here is my two cents..... http://lindy.stanford.edu/~pjg/Stanford/IBMdoc.html Book mark this link, that has almost all manuals we normally want. For REXX, scroll down the list and u will hit the reference and user guide. Regards, Venkat



>From: "Pendlebury-Bowe, Leslie" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Db2 Rexx book URL required... >Date: Thu, 10 Aug 2000 10:34:11 +0100 > >Anybody have the url to the Rexx/Db2 book(s)? > >thanks > >Leslie > > >********************************************************************** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom [...] 28351 287 30_Re: JDBC from Win 95 to OS/39024_Peter_Schwarcz (Bigpond)26_Peter_Schwarcz@BIGPOND.COM31_Fri, 11 Aug 2000 07:41:40 +1000510_iso-8859-1 Chad,

In the same manual GC09-2830-00, DB2 Connect Personal Edition Quick Beginnings V6, chapter 10 Running Your Own Applications there is a specific section on configuring UNIX clients.

On UNIX platforms: * v CLASSPATH includes ².² and the file sqllib/java/db2java.zip * On AIX, Linux, Silicon Graphics IRIX, and Solaris: LD_LIBRARY_PATH includes the directory sqllib/lib; on HP-UX: SHLIB_PATH includes the directory sqllib/lib * On Solaris only: THREADS_FLAG is set to ²native² [...] 28639 81 25_Re: Can I backout a bind?16_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Thu, 10 Aug 2000 15:00:24 -0700604_us-ascii The RID appears to be sufficient as far as I calculate. Can anyone think of anything else besides the clusterratio of the chosen index to convince the optimizer to turn off LP? I continue to search.

Thanks,

Alison Pelletier Discover Financial Services --- Sanjeev wrote: > Hi Alison, > Is the access path and join sequence exactly same > as it was, except that > no list prefetch currently ?.As you said the index > is still unclustered, > have you checked the CLUSTERRATIO in catalog(might > be manually updated by > someone) ? .If all the things are [...] 28721 90 30_Re: Disaster recovery strategy15_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Thu, 10 Aug 2000 17:44:47 -0500599_iso-8859-1 Personally, I don't think it matters which copies you use. Prior to DB2 V4, it may have been important because you could only use the copies your subsystem was genned for. If the subsystem was defined as a local site, the RECOVER utility could only use the LP (local primary) and LB (local backup) image copies. If the subsystem was defined as a recovery site, the RECOVER utility could only use the RP (remote primary) and RB (remote backup) image copies. With DB2 V4, the RECOVER utility introduced the LOCALSITE/RECOVERYSITE parameters. This meant that a local site could use the [...] 28812 94 60_Re: DB2 Connect Version Mismatch in a PeopleSoft Environment0_15_leon@CA.IBM.COM31_Thu, 10 Aug 2000 19:34:07 -0400538_us-ascii What you have described should never happen. I am not going to try to address the PeopleSoft certification issue. I am speaking strictly about ability to run multiple versions of DB2 Connect and DB2 CAE at the same time.

Every time we ship a new FixPack, release or version of any of our products we create new packages. In other words, you should be able to run any number versions, releases or FixPacks of DB2 Connect and DB2 CAE against the same DB2 for OS/390 subsystem and never have any collisions of any kind. [...] 28907 18 47_Off topic - Update of MS SQL Server from OS/39010_Pat Brazil27_pbrazil@MIDATLANTIC.AAA.COM31_Thu, 10 Aug 2000 19:38:32 -0400272_iso-8859-1 I have been asked if there was a way to update a MS SQL Server data base in a batch OS/390 program.

I know this has nothing to do with DB2, but I thought you folks would be most likely to know. (By the way, we do have DB2 and TCP on the mainframe). [...] 28926 52 23_Problem with Image Copy13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Thu, 10 Aug 2000 20:14:22 EDT316_- Hi list, I need to backup our test DB and having trouble setting up the TS backup jobs. Specifically, I'll like some guidance on what steps to take in creating the necessary JCL, allocating required datasets if any, and perhaps backup naming standards. Answers to the following question will be very helpful: [...] 28979 114 27_Re: Problem with Image Copy23_Puddy, Andrew (CALBRIS)36_Andrew.PUDDY@COMALCO.RIOTINTO.COM.AU31_Fri, 11 Aug 2000 01:18:57 -0000334_iso-8859-1 need to define a gdg base DEF GDG(NAME('IPU.FCSLCO.FCSLC01.FCLC001') LIMIT(40) SCRATCH NOEMPTY) which will put 40 entries in the catalog and uncat them when they drop off. however it is customary to have the db subsystem name in it somewhere to differentiate it.

the parm is the db subsystem and a utility name [...] 29094 70 30_Re: Disaster recovery strategy19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Fri, 11 Aug 2000 00:25:08 -0400395_iso-8859-1 One of the advantages of specifying COPYDDN and RECOVERYDDN in the same Image Copy step is that you make one pass of the tablespace to create two image copy data sets - one for local site and one for recovery site. Assuming the RECOVERYDDN data sets are on tape, you can specify a data set name HLQ that your tape management system can use to mark the tapes for offsite storage. [...] 29165 77 33_Re: Db2 Rexx book URL required...23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 11 Aug 2000 06:15:15 +0100328_iso-8859-1 Don Hi.

I was close with the URL. The archives had a slightly different url - I scanned up and down the url's to try and find .. searched the IBM web site .. not an easy boy to find when you are blind.

In my opinion anything that keeps those companies(SAP) dedicated to using DB2 make me smile ... [...] 29243 30 23_TMM for DB2 Imagecopies14_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM31_Fri, 11 Aug 2000 02:00:55 -0400439_ISO-8859-1 Hello,

our OS390 Sysprogs suggested use of SMS TMM (Tape Mount Management) for DB2 Image Copies. As far as I understand, the ACS routines intercept the tape mounts, and redirect some allocations to a TMM disk pool. From there, normal HSM migration takes place controlled by special threshold values. Any considerations using this mechanism for Image Copies ? Comments, experiences and remarks would be very welcome. [...] 29274 59 41_Re: List of abbreviations and/or acronyms10_Colin Page17_PAGECJ@UK.IBM.COM31_Fri, 11 Aug 2000 09:17:41 +0100535_us-ascii Dave,

For IT related issues you might want to check out http://www.networking.ibm.com/nsg/nsgmain.htm - possibly a definitive guide..!



Colin J Page ESW SAP DBA UK Server Systems Operations S/390 UK Technical Assurance Specialist IBM Global Services. (GEOMAR) -------------------------------------------------- Notes: Colin J Page@IBMGB Internal Tel: 258608 External Tel: 44 (0)2392 568608 Email: pagecj@uk.ibm.com Mail Point: FGU (North Harbour) S/390 Intranet Site: http://w3.s390-team.uk.ibm.com/ [...] 29334 85 33_Re: Db2 Rexx book URL required...13_McDonald, Ian32_Ian.McDonald@ABBEYNATIONAL.CO.UK31_Fri, 11 Aug 2000 09:39:00 +0100397_- Don no man's an island except Fred Madagascar!! Ian ---------- From: Don Alden To: DB2-L@RYCI.COM Subject: Re: Db2 Rexx book URL required... Date: 10 August 2000 06:56PM

Howdy Les,

Attached is the URL you want. By the way what do you think about Larry Ellison making moves to make Oracle "an island unto itself" by ticking-off the 'big four' (SAP, Seible, Peoplesoft and I2). [...] 29420 77 30_Re: Disaster recovery strategy11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Fri, 11 Aug 2000 05:19:27 -0400597_ISO-8859-1 Claudio

There is one potential problem with using COPYDDN(copy1dd,copy2dd) and using the copy2dd as a disaster recovery copy. This copy will be sent offsite. When you do a recovery at your original site, RECOVER will call for the copy1dd. If this cannot be read, then it will call for the copy2dd copy. This will be offsite. To bring that second copy back onsite invalidates your disaster recovery procedure. Murphy's Law says that it is just after you bring the offsite copy back on site that the 747 lands on the data centre. Any copy created by RECOVERYDDN will never be [...] 29498 138 27_Re: To commit or not commit12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 11 Aug 2000 13:20:49 +0200392_x-user-defined Hi,

I hope it won't be too late...

I'm a believer of DB2. However it becomes harder to sell it to upper management. When we push for projects on the DB2/MF instead of using ORACLE/UNIX and use OLR as an example of better service we can't explain the "switch" problem (doesn't matter that in ORACLE it is much more problematic to reorg). [...] 29637 38 51_Re: Off topic - Update of MS SQL Server from OS/39031_Cagdas Ucar (Garanti Teknoloji)22_cagdasu@GARANTI.COM.TR31_Fri, 11 Aug 2000 13:37:21 +0300523_- If you only have a several types of updates which most likely won't change, than I can offer the following solution:

Find the port number that SQL server listens to. From a Windows client on a network try to connect to SQL server, bu the listening entity will be a dummy server that you're going to write. So, get the connect string. Also do the same stuff for updates, and by examining the message find where the data is placed and how. So send these messages from an OS/390 TCPIP batch program accordingly. [...] 29676 99 27_Re: Problem with Image Copy13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Fri, 11 Aug 2000 07:40:16 EDT666_- Thanks to you esteemed list members who responded to this mail Phillips



>From: "Puddy, Andrew (CALBRIS)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Problem with Image Copy >Date: Fri, 11 Aug 2000 01:18:57 -0000 > >need to define a gdg base >DEF GDG(NAME('IPU.FCSLCO.FCSLC01.FCLC001') LIMIT(40) SCRATCH NOEMPTY) >which will put 40 entries in the catalog and uncat them when they drop off. >however it is customary to have the db subsystem name in it somewhere to >differentiate it. > >the parm is the db subsystem and a utility name > >the use of a proc is [...] 29776 29 51_Re: Off topic - Update of MS SQL Server from OS/39012_Jim Harrison12_jimh@QIS.NET31_Fri, 11 Aug 2000 08:50:20 -0400572_us-ascii I thought DataJoiner had a SQL Server interface. I don't know enough about it, but from what I heard, it might enable you to do that. Just did a quick search and turned up this URL:

http://www-4.ibm.com/software/data/datajoiner/





At 07:38 PM 8/10/00 -0400, Pat Brazil said: >I have been asked if there was a way to update a MS SQL Server data base in >a batch OS/390 program. > >I know this has nothing to do with DB2, but I thought you folks would be >most likely to know. (By the way, we do have DB2 and TCP on the mainframe). [...] 29806 15 60_Re: DB2 Connect Version Mismatch in a PeopleSoft Environment14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 11 Aug 2000 08:59:25 -0400477_us-ascii Tium, We ran Peoplesoft Financials 6.0 and 7.5 for a couple of years with various versions/tyupes of DB2 Connect, PE and EE, V5.0 WR9044, V6.1 no fixpack with no problems. Seems like you have some unique problem here. HTH Phil

================================================ 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. 29822 62 32_IDUG 2001 Call for Presentations14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 11 Aug 2000 09:10:34 -0400474_us-ascii I am writing to you on behalf of the North America IDUG Conference Planning Committee to ask if you would please submit a presentation abstract to be considered for the 13th annual North America International DB2 User Group Conference. The event will be held May 13-17, 2001, at the Orlando World Center Marriott in Orlando, Florida. If the presentation is selected to be delivered in Orlando, the conference registration fee will be waived for the presenter. [...] 29885 48 27_Re: TMM for DB2 Imagecopies17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Fri, 11 Aug 2000 09:11:49 EDT629_- That depends on how the ACS is written. you could have problem if the data to be copied is rather too huge to be put on a DASD pool. The ACS should include filters based on the size before redirection is attempted. Regards, Venkat



>From: Ulf-Otto Cihak >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: TMM for DB2 Imagecopies >Date: Fri, 11 Aug 2000 02:00:55 -0400 > >Hello, > >our OS390 Sysprogs suggested use of SMS TMM (Tape Mount Management) for DB2 >Image Copies. >As far as I understand, the ACS routines intercept the tape mounts, and [...] 29934 119 27_Re: Problem with Image Copy13_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Fri, 11 Aug 2000 10:21:27 EDT562_- Thanks Mr. A. Puddy of Australia and to the list, may I followup with these questions:

1. How do you create a model DSCB needed to create new GDGs?

2. When I started in this position, I inherited a subsystem with just about evrything done with DB2 default parameters(e.g., the underlying VSAM DB2 dataset with a HLQ of DSN610.*). An alias should have been created, GDG created for these datasets. Now, I have data I want to keep in some of my tables and I know I can still create an alias, create the correct table, unload data from current [...] 30054 114 60_Re: DB2 Connect Version Mismatch in a PeopleSoft Environment13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Fri, 11 Aug 2000 09:38:59 -0500702_iso-8859-1 same here, we have different versions without problems. Perhaps the problem lies elsewhere.

-----Original Message----- From: Myron Miller [mailto:myronwmiller@YAHOO.COM] Sent: Thursday, August 10, 2000 3:32 PM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect Version Mismatch in a PeopleSoft Environment



I can't speak about a Peoplesoft environment. But my client is currently running with DB2 Connect clients at 5.2, 5.2 fixpack 10, fixpack 12, fixpack 12e, 6.1, 6.1 fixpack 4, and 7.1 without any problems. They are connecting to both DB2 V5.1 and DB2 V6.1. --- "Ohling, Tim R - CNF" wrote: > This question concerns the ability to handle various [...] 30169 61 27_Re: TMM for DB2 Imagecopies16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Fri, 11 Aug 2000 07:51:06 -0700360_iso-8859-1 We've been using TMM for a while with most of our Test Image Copies, and we're in the process of doing the same with Production.

The primary benefit is the speed since you're writing to DASD instead of tape, and, in our case, a secondary benefit is that our HSM files are duplicated for onsite and offsite storage, after the IC is done. [...] 30231 26 13_DB2 Education14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 11 Aug 2000 11:36:00 -0400386_- Hi, Are there any classes that specifically deal with DB2 Recovery ? I've been reading the Admin Guide and Utiity Guide but would like some formal education on this subject. I'm having trouble grasping the Conditional Restart stuff. Any good books on DB2 ?? TIA Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax [...] 30258 52 27_Re: TMM for DB2 Imagecopies15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 11 Aug 2000 11:47:03 -0500527_iso-8859-1 Using TMM for image copies works wonderfully well except for one case. When the size of the image copy exceeds the upper limit for a data set defined by your sysprogs. That upper limit is based on the largest size data set that can fit on one tape, as I recall. If your image copy data set exceeds this limit it goes directly to tape. This is no problem unless you want an off-site copy. Our set-up doesn't make an off-site copy in this case. If we have a very large image copy then we set up a different image [...] 30311 24 16_DB2 Archive Logs14_Dean Montevago18_DMonteva@VNSNY.ORG31_Fri, 11 Aug 2000 13:00:26 -0400322_- Hi AGAIN !!! If I have a 1000 cylinder active log and let's say I do 2 uipdates and force an archive, does DB2 only offload those 2 updates or does the whole 1000 file get offloaded. Please advise. Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax [...] 30336 56 27_Re: TMM for DB2 Imagecopies12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 11 Aug 2000 20:16:26 +0200455_x-user-defined Hi,

We use it, no problems, migrate is to VTS.

You need big enough TMM pool, and well timed L2 migration policy so you won't find yourself stuck without space. Try to split the TMM disks into few SMS groups (and not one) as they are very busy when the L2 migration works and their response time can become high. Use correct DCB model so you'll get good blocksize (half-track on 3390 type = 6*4096=24576) and bufno=60-80. [...] 30393 23 5_DB2-l14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 11 Aug 2000 13:28:21 -0400345_us-ascii TO ALL SUBSCRIBERS: We had a problem with the list this morning, but everything is back to nornal now. Cheers!

Phil



Phil Gunning DB2 DBA IBM Certified Advanced Technical Expert -- DB2 UDB DRDA IBM Certified Solutions Expert -- DB2 UDB V6 IBM Certified Solutions Developer -- DB2 UDB V6 Assoc List Owner DB2-L [...] 30417 110 25_Re: Can I backout a bind?18_Ganesh Seetharaman23_SEETHARAMANG@BCBSIL.COM31_Fri, 11 Aug 2000 09:25:26 -0500544_US-ASCII Allison,

From what ever you say it seems that you have checked all the scenarios. But I thought of letting you know that the only one RID block(4096 RIDS) is allowed per SQL statement I mean that 16 KB. Make sure that this query hasn't reached that limit. I hope it might not since you told that this query was using LP earlier. Even if there is a shortage the SQL can process 4096 RIDS before it turns of the Tablespace scan. You can make sure that the LP is not converted to Tablespace scan. You can get these statistics [...] 30528 91 27_Re: Problem with Image Copy13_Olson, Carlos14_COlson@QRS.COM31_Fri, 11 Aug 2000 09:13:15 -0700620_iso-8859-1 Carlton, Here's some SQL you can model after to generate the IDCAMS SYSIN input to create the GDG datasets:

SELECT NAME, '1', ' DEFINE GENERATIONDATAGROUP - ' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'CCDBDSSP' UNION SELECT NAME, '2', ' (NAME(BKUP.DAILY.FIC.' || NAME || ') -' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'CCDBDSSP' UNION SELECT NAME, '3', ' LIMIT(05) -' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'CCDBDSSP' UNION SELECT NAME, '4', ' NOEMPTY -' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'CCDBDSSP' UNION SELECT NAME, '5', ' SCRATCH)' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME = 'CCDBDSSP' [...] 30620 10 21_os390 v6 ICOPY status10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Fri, 11 Aug 2000 13:39:23 -0400380_- I have been looking through the doc and would like to knw if anyone has a real good definition of the status ICOPY (Informational Copy)?

================================================ 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. 30631 54 51_Re: Off topic - Update of MS SQL Server from OS/39024_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Fri, 11 Aug 2000 13:58:04 -0700323_us-ascii Pat, You can accomplish what you want with a combination of DB2Connect, DataJoiner, and the MS SQL Server client - the equivalent of Sybase Open Client. You can install these middleware products on a Unix, Linux, or NT gateway server or install all of them directly on the NT server where SQL Server resides. [...] 30686 44 20_Re: DB2 Archive Logs17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Fri, 11 Aug 2000 13:59:18 EDT638_- Both the archive copies will be truncated if you archive before end of dsn. Regards, Venkat

>From: Dean Montevago >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 Archive Logs >Date: Fri, 11 Aug 2000 13:00:26 -0400 > >Hi AGAIN !!! >If I have a 1000 cylinder active log and let's say I do 2 uipdates and >force >an archive, does DB2 only offload those 2 updates or does the whole 1000 >file get offloaded. Please advise. >Dean > >Dean Montevago >MVS Systems Programming >Visiting Nurses Service of NY >(212) 290-0543 >(212) 290-4777 - Fax > >dmonteva@vnsny.org [...] 30731 148 27_Re: Problem with Image Copy24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 11 Aug 2000 10:59:04 -0700628_iso-8859-1 Regarding question # 2.

If you're happy with the database, tablespace, and index names, and only want to change the high level qualifier of the datasets, it's not necessary to unload, drop create, reload, etc. You can simply create a storage group which uses the VCAT name you want, stop the tablespaces and indexes, alter them to use the newly defined storage group, rename the VSAM cluster and data components for the tablespaces and indexes using the new high level qualifier, and then restart the tablespaces and indexes. Voila! Complete. No fuss, no muss. No unloads, drops, creates, loads, rebinds, [...] 30880 38 23_DB2 subsystem CSA usage14_Mark McCormack27_mamccormack@STATESTREET.COM31_Fri, 11 Aug 2000 14:16:07 -0400350_US-ASCII I am posting the following for a colleague. Any information will be appreciated. Thanks. Mark McCormack State Street Bank ------------ Running db2 V6 on os/390 v2.7. OS/390 CSA usage (below line) is at 95 %. We are researching options for reducing DB2 CSA usage if possible. Currently the DB2 utilization (per subsystem) is as follows: [...] 30919 12 5_DB2-L14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 11 Aug 2000 14:18:08 -0400285_us-ascii I guess it was a little 'nornal'.!

================================================ 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. 30932 26 25_Stuck w/Quiesce Exclusive16_Victor Mcdonnell17_vmcdon@US.IBM.COM31_Fri, 11 Aug 2000 14:27:47 -0400361_us-ascii So, WebSphere Catalog Architect was loading some data, apparently, and left USERSPACE1 in QUIESCE EXCLUSIVE (I presume this is a result of the HOLD QUIESCE parm in the LOAD utility. However something wnet wrong(!) and left the t-space in Q-E. All attempts to reset / disconnect / force apps all / Quiesce the phantom as my own, etc., have failed. [...] 30959 91 30_Re: Disaster recovery strategy41_=?iso-8859-1?Q?Cl=E1udio_Meluzzi_Mendes?=18_P000002@BEG.COM.BR31_Fri, 11 Aug 2000 15:47:11 -0300648_iso-8859-1 >Why do your systems programmers NOT want to use RECOVERYDDN? Is there a >rational reason?

There are reasons, you will see wether they are rational or not. Following IBM's procedures for DR, we would have to catalog copies and take additional RECOVERYDDN copies. System Programmers's first claim is that, during their tests with our development subsystem, the copying time for catalogued copies was much longer than the time needed for non-catalogued ones. Then, they have decided it would be better not to take catalogued copies. The second drawback, they state, is that using RECOVERYDDN doubles the amount of tape needed. [...] 31051 70 26_FW: OS/390 V6 ICOPY Status38_Andersen, Cindy (CC-Database Services)26_Cindy.Andersen@CONAGRA.COM31_Fri, 11 Aug 2000 14:01:56 -0500568_iso-8859-1 Bill,

I attended a DB2 UDB for OS/390 V6 Transition class held by IBM and they have a good description of the status & the situations that cause it. HTH:

The informational copy pending, ICOPY, state indicates that a copy of the index should be taken. It is set on an index when an "unrecoverable from the log event" has occurred on the index or on its underlying table space. This is an advisory state only and DOES NOT prohibit read or write access to the index. The status ICOPY only prevents a RECOVER INDEX from being run because the [...] 31122 55 44_Using Text Extender with DB2V6 on OS390 V2R613_Olson, Carlos14_COlson@QRS.COM31_Fri, 11 Aug 2000 12:19:43 -0700611_iso-8859-1 We're having a problem enabling the Text Extender for a column. The commands and responses are shown below. Any insight would be greatly appreciated.

> DB2 V6 running on OS390 V2R6 > > db2tx => get environment > > Current database manager instance (DB2INSTANCE) = Undefined > variable > Default database name (DB2DBDFT) = QMP1_QRSD > > Instance name (DB2TX_INSTOWNER) = qrsdtxs > > Instance directory (DB2TX_INSTOWNERHOMEDIR) = /u/qrsdtxs > > > db2tx => get status > > The database is enabled for DB2 Text Extender > > > For DB2TX sample table: > db2tx => enable text column db2tx.sample [...] 31178 45 29_Re: Stuck w/Quiesce Exclusive10_Mike Paris14_MPARIS@TUC.COM31_Fri, 11 Aug 2000 14:27:21 -0500625_US-ASCII Victor,

Issue 'quiesce tablespaces for table tbname exclusive'. You may have to issue the command multiple times before the database will let you get ahold of it. We have run into this problem here before in our AIX.

HTH

Mike

>>> vmcdon@US.IBM.COM 08/11 1:27 PM >>> So, WebSphere Catalog Architect was loading some data, apparently, and left USERSPACE1 in QUIESCE EXCLUSIVE (I presume this is a result of the HOLD QUIESCE parm in the LOAD utility. However something wnet wrong(!) and left the t-space in Q-E. All attempts to reset / disconnect / force apps all / Quiesce the phantom [...] 31224 16 27_Re: DB2 subsystem CSA usage17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM31_Fri, 11 Aug 2000 14:20:37 -0500332_- Most certainly, when you changed to PC= No, you did not adjust ECSA, and hence IRLM caused a spill over to CSA. If not addressed immediately, it could potentially disrupt MVS. You need to alter ECSA, unless you have found the problem to be elsewhere. This is most common when you change from PC=YES to PC=No. Regards, Venkat [...] 31241 144 25_Re: Can I backout a bind?16_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Fri, 11 Aug 2000 14:56:46 -0700344_us-ascii Well now there's an enlightening thought! I did look at OMEGAMON and see several failures because of limit exceeded. This app. isn't running now, but thanks for pointing out that we have a bigger problem than I thought!! Just kidding. Would the optimizer be able to calculate # of RIDS by statistics and turn LP off at bind time? [...] 31386 40 18_test please ignore15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Sat, 12 Aug 2000 12:40:35 +030018_-



31427 384 27_Re: Problem with Image Copy12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Sat, 12 Aug 2000 19:06:24 +0200668_x-user-defined Hi,

It took me some time to find my favorite REXX for handling DB2 Backup. I'm attaching it here, it is a pure text file.

Isaac Yassin





Carlton Enuda wrote: > > Thanks to you esteemed list members who responded to this mail > Phillips > > >From: "Puddy, Andrew (CALBRIS)" > >Reply-To: DB2 Data Base Discussion List > >To: DB2-L@RYCI.COM > >Subject: Re: Problem with Image Copy > >Date: Fri, 11 Aug 2000 01:18:57 -0000 > > > >need to define a gdg base > >DEF GDG(NAME('IPU.FCSLCO.FCSLC01.FCLC001') LIMIT(40) SCRATCH NOEMPTY) > >which will put 40 entries in [...] 31812 124 39_Fw: Re: Varchar(32672) vs. Long Varchar11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Sat, 12 Aug 2000 22:56:59 -0400644_us-ascii Jay,

If it's rarely accessed, use the LONG and put it into a LONG tablespace. That way, the remaining non-long columns will yield a table with a smaller row width, which means more rows per page, and fewer physical I/O's to access the more "popular" columns in the table.

Regards, Scott

Drive DB2 UDB UNIX Faster with Database-GUYS(TM). Optimize, Monitor, and Track your DB2 UDB for UNIX Databases... See http://www.database-guys.com/ Many of our customers report dramatic performance improvements. 98% of our trials have become customers. 100% of our customers have renewed maintenance. How can we help you? [...] 31937 150 38_Detecting Redundant Indexes - Solution11_Suresh Sane21_data_arch@HOTMAIL.COM29_Sun, 13 Aug 2000 00:21:52 CDT421_- Ruediger & several other who requested it:

Shown below are 2 solutions to the problem of detecting redundant indexes extracted from my IDUG Dallas presentation "SQL SOLutions for a DBA's Wish List". Hope you find it useful. I will be posting others of interest (indexes defined as duplicate when they should be unique, foreign keys w/o supporting indexes, CRUD matrix etc) on my website in the near future. [...] 32088 135 49_Re: Problems inserting LOB data greater than 16MB14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 13 Aug 2000 18:07:17 +1000385_iso-8859-1 Keith,

Close, but not clear.

Two Host variables

HV-DATA is SQL TYPE IS CLOB/BLOB HV-LOC is SQL TYPE IS LOCATOR

put first into HV-DATA EXEC SQL SET :HV-LOC = :HV-DATA

put next into HV-DATA EXEC SQL SET :HV-LOC = :HV-LOC || :HV-DATA

repeat until all data has been read in [...] 32224 124 19_Re: view problem...14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 13 Aug 2000 18:31:52 +1000601_iso-8859-1 Do you have a consistant date format? If not, try rewriting the CHAR(CURRENT_DATE)'s as CHAR(CURRENT_DATE,ISO)

Otherwise, try running

SELECT ASGN_EFF_DATE, ASGN_EXP_DATE FROM BKG_ASGN

in spufi and batch and verify that their format are what you expect

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au

-----Original Message----- From: Backes,Michael [mailto:BackeM@MAIL.OA.STATE.MO.US] Sent: Thursday, August 10, 2000 12:29 AM To: DB2-L@RYCI.COM Subject: [DB2-L] view problem... [...] 32349 85 30_Re: Disaster recovery strategy11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Sun, 13 Aug 2000 05:06:33 -0400626_ISO-8859-1 Hi Claudio

I suspect from your answer that there is more to this than you have told us so far.

First, the statement that RECOVERYDDN copies double the amount of tape needed. Only if you take extra copies. Switching from COPYDDN(copy1, copy2) to COPYDDN(copy1) RECOVERYDDN(copy2) requires no extra tape. As I mentioned before, using the second COPYDDN copy for disaster recovery will either require you to bring the copy back onsite if an error is detected in the first copy (bad for disaster recovery) or will cause operational problems when recovering at the original site if the second copy is [...] 32435 173 42_Re: Detecting Redundant Indexes - Solution10_DANIEL CYR19_DCYR@EMAIL.USPS.GOV31_Sun, 13 Aug 2000 19:09:24 -0500438_iso-8859-1

Ruediger & several other who requested it:

Shown below are 2 solutions to the problem of detecting redundant indexes extracted from my IDUG Dallas presentation "SQL SOLutions for a DBA's Wish List". Hope you find it useful. I will be posting others of interest (indexes defined as duplicate when they should be unique, foreign keys w/o supporting indexes, CRUD matrix etc) on my website in the near future. [...] 32609 27 51_Data Sharing: Non-stop services during DB2 Upgrade?21_Li, Chak Lung Dominic19_seddba@HK.SUPER.NET31_Mon, 14 Aug 2000 14:44:10 +0800532_us-ascii A question on data sharing -

Suppose we have 2 DB2 V5 members in the same Data Sharing group and are planning for an upgrade from DB2 V5 to V6. In order to provide 24X7 services to our customers, we would like to know if it is possible for us to perform upgrade on one of the member first while the other one is still up and running under V5. This is to ensure that at least one DB2 subsystem in the Data Sharing group is functional and continue to provide services to our customers. In particular, we doubt if [...] 32637 198 42_Re: Detecting Redundant Indexes - Solution14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Mon, 14 Aug 2000 08:59:54 +0100308_iso-8859-1 Hi Suresh,

thanks a lot for your help; as I'm always looking out for stuff that makes my life a lot easier (or, as one of my former colleagues used to say, 'a good programmer is always a lazy one' meaning why invent stuff over and over again ...) .... what is your website's-address ? [...] 32836 156 49_Re: Problems inserting LOB data greater than 16MB15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Mon, 14 Aug 2000 09:07:54 +0100452_iso-8859-1 Can I ask a blindingly obvious question - where's the INSERT? Does this method not require an insert or were you assuming that the first insert has already happened? Regards thickly Keith



----- Original Message ----- From: "James Campbell" Newsgroups: bit.listserv.db2-l To: Sent: Sunday, August 13, 2000 9:07 AM Subject: Re: Problems inserting LOB data greater than 16MB [...] 32993 178 49_Re: Problems inserting LOB data greater than 16MB14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 14 Aug 2000 18:40:24 +1000514_iso-8859-1 Sorry, yes, I saw the references to 'updates' and just continued. If you're inserting, then you'ld EXEC SQL INSERT INTO ... VALUES (... :HV-LOC ...)

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au

-----Original Message----- From: Keith Phimister [mailto:keith.phimister@virginnet.co.uk] Sent: Monday, August 14, 2000 6:08 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Problems inserting LOB data greater than 16MB [...] 33172 51 17_Re: DB2 Education12_Susan Lawson26_susan_lawson@ATTGLOBAL.NET31_Mon, 14 Aug 2000 05:46:33 -0500522_iso-8859-1 Hello Dean,

At our DB2 Symposium in Chicago on Sept 14th - we are offering DB2 Backup, Recovery and Restore. It is a very intensive 1-day class and it is being taught by international consultant Klaas Brant. Go to www.db2-symposium.com for information on the session.

Regards, Susan Lawson

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Dean Montevago Sent: Friday, August 11, 2000 10:36 AM To: DB2-L@RYCI.COM Subject: DB2 Education [...] 33224 220 49_Re: Problems inserting LOB data greater than 16MB15_Keith Phimister31_keith.phimister@VIRGINNET.CO.UK31_Mon, 14 Aug 2000 11:52:41 +0100317_iso-8859-1 Thanks for that James, that sorts out the DB2 side. The other side to this is more achitectural - how would I get the Blob data into the program in the first place??

If I take the example of trying to put bitmaps onto mainframe DB2 - I'm stuffed at part one. For raw text data it's no problem: [...] 33445 116 30_Re: Disaster recovery strategy11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 14 Aug 2000 08:31:40 -0400571_iso-8859-1 I agree that we should create local and recovery site copies. We do NOT catalog them for many reasons but one of the main ones is the requirement to catalog them at the recovery site (if that catalog is not recovered to the same point-in-time). From the SYSCOPY documentation...

+---------------+---------------+----------------------------------+-----¦ ¦ DSVOLSER ¦ VARCHAR(1784) ¦ The volume serial numbers of the ¦ G ¦ ¦ ¦ NOT NULL ¦ data set. A list of 6-byte ¦ ¦ ¦ ¦ ¦ numbers separated by commas. ¦ ¦ ¦ ¦ ¦ Blank if the data set is ¦ ¦ ¦ ¦ ¦ [...] 33562 31 30_Re: Disaster recovery strategy11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Mon, 14 Aug 2000 08:42:05 -0400374_ISO-8859-1 If you recover the VSAM User Catalog containing the entries at the disaster recovery site, then you do not need to re-catalog the image copy datasets. It is only if the DB2 recovery is to a later point in time than the VSAM Catalog that you will have problems. If that is the case, why not create another VSAM Catalog backup just after the DB2 image copies? [...] 33594 57 22_OS/390 certification??16_Eric van Leeuwen23_eric.van.leeuwen@CMG.NL31_Mon, 14 Aug 2000 15:47:28 +0200282_iso-8859-1 Hello all,

I've heard some rumours about the Certification on OS/390.

It is said it will be available on next European IDUG.

Are these just rumours or did any of you heard something about this too?

Kind Regards,

Eric van Leeuwen

33652 21 24_V5 to V6 migration error16_Skrivanek, David28_David.Skrivanek@DOWJONES.COM31_Mon, 14 Aug 2000 11:10:41 -0400309_iso-8859-1 All,

I have received an error in the V6 catmaint job due to catalog tablespaces containing dataset passwords. The installation guide is unclear as to whether I need to fallback to V5 to correct this, and if so, are the catalog changes backed out or do I have to recover the V5 catalog. [...] 33674 38 14_Sizing DSNDB070_19_mike.holmans@BT.COM31_Mon, 14 Aug 2000 16:16:56 +0100356_- I've had a look through the archives, but I can't find anything very helpful on a question I was asked earlier today - how do we know whether our DSNDB07 datasets are bigger than they need to be?

We've got some subsystems around the place which have five whole-volume DSNDB07 datasets, and we have a distinct suspicion that this is overkill. [...] 33713 32 19_FLASHCOPY for SHARK4_IBM119_IBM1@EGEBANK.COM.TR31_Mon, 14 Aug 2000 18:24:38 +0300525_- Hi list,

just a quick note to inform you that Flashcopy for Shark has FINALLY arrived.

we are apparently going to receive it tomorrow and - as promised a LOOOONG time ago, I'll keep you posted on progress!!

ciao!

Aurora Dell'Anno Systems Engineer IBM Software Support e-mail: ibm1@egebank.com.tr aurora.dellanno@sistinf.it _____________________________________________ No trees were killed in the sending of this message. However - a large number of electrons were terribly inconvenienced. [...] 33746 60 28_Re: V5 to V6 migration error15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 14 Aug 2000 10:28:26 -0500578_iso-8859-1 Without looking at your output, I would say to remove the passwords from the datasets in question and retry your catmaint job. According to the doc below from the install guide all V5 changes are rolled back except for index alters.

"If job DSNTIJTC fails, save the output and verify that you are at the correct maintenance level. If you are not, you need to install the appropriate maintenance. If you are at the correct maintenance level, correct the problem and run the job again. If you run the job again and the job still fails, return to Version 5. [...] 33807 13 26_Re: OS/390 certification??14_Philip Gunning18_pgunning@PHEAA.ORG31_Mon, 14 Aug 2000 11:32:01 -0400339_us-ascii I've heard it will be available but have not seen any official publication yet. HTH Phil

================================================ 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. 33821 71 28_Re: V5 to V6 migration error15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 14 Aug 2000 10:32:36 -0500478_iso-8859-1 Correction, I meant V6 changes.

Linda

-----Original Message----- From: Billings, Linda Sent: Monday, August 14, 2000 10:28 AM To: 'DB2 Data Base Discussion List' Subject: RE: V5 to V6 migration error



Without looking at your output, I would say to remove the passwords from the datasets in question and retry your catmaint job. According to the doc below from the install guide all V5 changes are rolled back except for index alters. [...] 33893 41 26_Re: OS/390 certification??11_Bill Happel22_WRHappel@US.FORTIS.COM31_Mon, 14 Aug 2000 10:41:00 -0600334_US-ASCII This is what I was told during IDUG back in May when I took a shot at the Certification on Client/Server. I have not heard or seen anything about it since. When it becomes available, I expect to see it advertised on "IBM iSource -- U.S. Announcements".

>>> eric.van.leeuwen@CMG.NL 08/14/00 07:47AM >>> Hello all, [...] 33935 40 0_32_David Oberstadt/Santa Teresa/IBM17_davido@US.IBM.COM31_Mon, 14 Aug 2000 10:01:28 -0600395_us-ascii Dean,

You can find the DB2 for OS/390 education page at this address:

www.ibm.com/software/db2os390/education.html

I know only of one DB2 for OS/390 recovery class--DB2 for OS/390 System Recovery Workshop, CF910. This class is linked from the list in "DB2 for OS/390 course catalog". I have not taken the class, so all I know is what the page says. Good luck! [...] 33976 76 28_Re: V5 to V6 migration error16_Skrivanek, David28_David.Skrivanek@DOWJONES.COM31_Mon, 14 Aug 2000 12:09:37 -0400362_iso-8859-1 My situation seems to be consistent with what Linda is describing. I am going to try to restart in V5. I will update the list on whether it works or not.

-----Original Message----- From: Billings, Linda [mailto:linda.billings@DOA.STATE.WI.US] Sent: Monday, August 14, 2000 11:28 AM To: DB2-L@RYCI.COM Subject: Re: V5 to V6 migration error [...] 34053 75 0_4_IBM119_IBM1@EGEBANK.COM.TR31_Mon, 14 Aug 2000 19:12:46 +0300345_- dean,

try and find out if your "local friendly" IBM have set up course CA81 (DB2 OS/390 for DBAs Advanced).

some IBM educations provide this 4-day course - and it focuses mainly on recovery and backup, with all the new stuff for v 6 included!!

I have done it some time ago and it's good, if a bit.... rare to find!!! [...] 34129 117 26_Re: OS/390 certification??22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Mon, 14 Aug 2000 12:58:10 -0400412_iso-8859-1 I received this from IBM re: The Tech Conference in Las Vegas NV on 10/16/2000. Checkout HIGHLIGHTS...

From: IBM-Conferences@ibmguide.com Sent: Friday, August 11, 2000 15:09 To: Piontkowski Michael ML Subject: DB2 and Business Intelligence Technical Conference

DB2 and Business Intelligence Technical Conference

October 16 - 20, 2000 Las Vegas Hilton Hotel Las Vegas, Nevada [...] 34247 53 18_Re: Sizing DSNDB0713_Lockwood Lyon19_llyon@POWER-NET.NET31_Mon, 14 Aug 2000 12:53:36 -0400574_us-ascii Mike:

A common trick is to create one of the DSN4Kxx datasets with some minimal SECQTY. Then, using your favorite DASD analyzer (I use ISPF 3.4), check periodically (weekly) to see if this dataset ever extends. If not, I'd say you have too much DASD dedicated to DSNDB07.

-- Lockwood Lyon

mike.holmans@BT.COM wrote: > > I've had a look through the archives, but I can't find anything very helpful > on a question I was asked earlier today - how do we know whether our DSNDB07 > datasets are bigger than they need to be? > > We've got some [...] 34301 35 44_Help with Stored Procedures in UDB 6.1 on NT15_Joel Zigelstein20_jzigel1@HALLMARK.COM31_Mon, 14 Aug 2000 11:49:23 -0500604_- HI everyone ...

We currently have a single box running a Test and a Production instance. In each instance we have a database with identical names BUT with different aliases. We have 7 identical (except for comments) stored procedures for each database in each instance (or so we believe because we can open a project in the SPB and differentiate database and see differences). The Stored procedure names are identical for both databases. To our test instance/database we modified an existing view and saved it with a new name. We then changed a stored procedure to reference this new view. [...] 34337 30 18_Re: Sizing DSNDB070_17_JTonchick@AOL.COM29_Mon, 14 Aug 2000 13:06:37 EDT364_US-ASCII Another trick is to NOT allocate secondary extents on all but one of the DSNDB07 datasets. Then any task that has a need for more space, will go to the "overflow" work file. This way you only need to manage one file.

Jim Tonchick Fiserv, Inc.

In a message dated 08/14/2000 12:01:49 PM Central Daylight Time, llyon@POWER-NET.NET writes: [...] 34368 42 28_Re: V5 to V6 migration error17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Mon, 14 Aug 2000 13:41:05 EDT636_- Could you please post what kind of error messages you recd, with the DB2 reason codes?.... Regards, Venkat



>From: "Skrivanek, David" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: V5 to V6 migration error >Date: Mon, 14 Aug 2000 11:10:41 -0400 > >All, > >I have received an error in the V6 catmaint job due to catalog tablespaces >containing dataset passwords. The installation guide is unclear as to >whether I need to fallback to V5 to correct this, and if so, are the >catalog >changes backed out or do I have to recover the V5 catalog. > [...] 34411 42 28_Re: V5 to V6 migration error17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Mon, 14 Aug 2000 13:44:56 EDT652_- On a second thought, During migrations, at Catmaint step for any failure, you should be able to resubmit the failing job. So a correction outside DB2 at the VSAM level for the passwords, should help you clear thru this issue. Venkat



>From: "Skrivanek, David" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: V5 to V6 migration error >Date: Mon, 14 Aug 2000 11:10:41 -0400 > >All, > >I have received an error in the V6 catmaint job due to catalog tablespaces >containing dataset passwords. The installation guide is unclear as to >whether I need to fallback to [...] 34454 56 32_DDF - Distribution Data Facility21_Helio Pimpinato Rocha20_hrocha@TELESP.COM.BR31_Mon, 14 Aug 2000 15:53:25 -0300340_us-ascii Hi folks

I'm needing some help.

I installed the DDF in my site, but I'm having some problens when I try to access the data from other sites, and occurs the abend "sense=800a0000". The manual said that is problem of VTAM parameters and we changed , only, the MAXBFRU from 1 to 2, but the problem is still occurs. [...] 34511 27 40_Shutting Down Instances on AIX at Reboot0_22_BILL_GALLAGHER@PHL.COM31_Mon, 14 Aug 2000 16:46:14 -0400406_us-ascii Hi,

What are other shops doing to cleanly shutdown your UDB instances on AIX when you need to reboot your nodes? We are currently rebooting our development and stage nodes about once a week, and I don't believe that we have anything in our shutdown procedures for cleanly stopping the instances. As a result, we sometimes do not get a clean startup of the instances on Monday morning. [...] 34539 32 26_SQL 1336N w/DB2 Connect V613_Carlton Enuda24_carltonenuda@HOTMAIL.COM29_Mon, 14 Aug 2000 16:53:18 EDT371_- Dear List, I installed Db2 Connect V6 today following steps outlined in the Quick Beginings for DB2 Connect. Somewhere along the steps, I must have done something wrong and now I'm receiveing the following error messages when I tried to connect to the host DB2 subsystem:

1.) DBA0102 - Unable to detect NODETYPE fro Instance 'DSN1(DSN1)', Reason Code "-1". [...] 34572 23 35_NT DB2 UDB - Which way do you RAID?13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 14 Aug 2000 19:25:20 -0500391_- I'm working with a NT server with six disks with a RAID-5 spread evenly over them and I'm thinking of switching to three independent RAID-1s.

The first pair of RAID controller mirrored disks would hold NT, the DB2 instance and the DB2 log files.

The second pair would hold half the user, temp and long tablespace containers and the third pair would hold the other half. [...] 34596 14 52_Cathy L Peck/ISG/CORP/Highmark is out of the office.10_Cathy Peck23_cathy.peck@HIGHMARK.COM31_Tue, 15 Aug 2000 01:01:11 -0400365_us-ascii I will be out of the office from 08/14/2000 until 08/16/2000.

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. 34611 15 50_Susan Zweighaft/IRM/FRBOG/US is out of the office.15_Susan Zweighaft23_Susan.Zweighaft@FRB.GOV31_Tue, 15 Aug 2000 01:00:54 -0400389_us-ascii I will be out of the office starting 08/11/2000 and will not return until 08/16/2000.

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.