1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2001, week 3 2 39 34_Executing stored procedure from VB10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 15 Feb 2001 17:16:30 +1000469_ISO-8859-1 Hi,

We r currently trying to execute stored procedure on DB2 UDB for OS/390 v6 from a VB program thru DB2 connect.

We had the procedure before in v5, which got migrated into v6 under SYSPROC schema, and we r able to succesfully execute this. But if we try to call the same proc defined under any other schema, say MYUSERID, (using call MYUSERID.procname), the procedure doesnt seem to get executed. It returns with the following message : [...] 42 77 12_sqlcode -54014_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 15 Feb 2001 09:21:12 +0100398_us-ascii Peter & Ravi,

as I wrote yesterday, we did define a primary key on TAB1, but the package still wouldn't bind.

Troy,

we checked systables and found no other table-status 'I'

James,

here's the DDL:

CREATE TABLE PR.TADOKSEG (i.e., tab1) (ADOK_ID CHAR (16) NOT NULL, DOKSEG_ID SMALLINT NOT NULL, DSTYP_ID CHAR (10) NOT NULL) IN D00CM000.TMCMN005 [...] 120 32 20_DB2 UDB v7.1 and ESS20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Thu, 15 Feb 2001 10:39:34 +0100592_- Hi everyone, it's the first time I'm wirting to the group but reading some of the issues discussed here was really interesting, so I thought this could be the right place to share my doubts and curiousity. Did anyone already implemented a database using DB2 UDB EE v7.1 on AIX and the IBM ESS as storage system ? Reading the redbooks "DB2 UDB for AIX performance of Enterprise Storage Server" was very interesting and almost illuminating on how to get the best performances from SMS tabespaces, and other redbooks as "DB2 UDB v7.1 performance and tuning guide" gave inetresting advice [...] 153 99 28_Re: One Process - Many Users32_=?iso-8859-1?Q?St=E9phane?= COEZ23_scoez@HARRYSOFTWARE.COM31_Thu, 15 Feb 2001 11:00:22 +0100283_iso-8859-1 OK let's try to be more explicit.

I have a StartedTask wich is a server product. This product (HARRY2) is able to access DB2/OS390, it is write in APL2 wich can access to DB2, I do not have source code for this access (for people who knows APL2 this is AP127) [...] 253 59 22_Re: SQL reference book10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Thu, 15 Feb 2001 04:14:28 -0600307_- Yes indeed. Revealnet is very handy. Trouble is that if you can't afford to buy it, and nobody will buy it for you, then you'll miss it badly after the evaluation expires! ;)

I left my pc permanently switched on for weeks to squeeze every last ounce from my three free post-expiry sessions... [...] 313 52 27_AW: Graphical Relationships12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Thu, 15 Feb 2001 12:01:05 +0100710_iso-8859-1 Hi Mike,

have a look at microTool's www-sites (http://www.microtool.de/case40/de/index.htm). In version 5.0a the desired feature should be available.

HTH

Thomas



> -----Ursprüngliche Nachricht----- > Von: Brauweiler, Mike [mailto:MBrauweiler@ELCAMINO.COM] > Gesendet am: Mittwoch, 14. Februar 2001 23:59 > An: DB2-L@RYCI.COM > Betreff: Graphical Relationships > > First, let me freely state that I am a died-in-the-wool > heavy-iron bigot, > and largely PC-illiterate. Having gotten that off my chest, > I am looking > for a means of graphically depicting all the relationships > between all the > tables in a UDB database on a laptop (Windows 98), in much > [...] 366 219 69_2nd Notice SIRDUG (Charlotte, NC) Seminar with Sheryl Larsen, Feb. 2311_Paul Turpin32_pault@ALUMMAIL.SSB.ROCHESTER.EDU31_Thu, 15 Feb 2001 04:53:39 -0600450_- We had to change the meeting location, so I am resending this notice. There are still a few open spots for the meeting, so you can still register for the meeting.

--------------------------------------------------------------------- SIRDUG Southeastern Inter-Relational Database Users' Group P.O. BOX 34641 Charlotte, NC 28234

Website: http://users.vnet.net/sirdug Email: SIRDUG@VNET.NET Information/Message Line: (704) 556-6621 [...] 586 44 24_Re: DB2 MANAGED BY DFSMS10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Feb 2001 08:53:16 +0100326_us-ascii I have always used SMS to manage DB2 datasets, but I've never used only ONE pool.

In general, as data and indexes may have different behaviour, its a good choice to have at least TWO storage group,

expecially if you have no SHARK DASDs (if you've HDS 7700E for instance) with quasi-zero IOSQ time. [...] 631 28 22_Re: SQL reference book10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Feb 2001 09:56:24 +0100378_us-ascii I found use(w)ful the (cook)books (in PDF format) downloaded from:

http://ourworld.compuserve.com/homepages/Graeme_Birchall/HTM_COOK.HTM

They are clear, complete and (as my wage is so low I've to drill to got it) they are FREE. When I'll be a guru (and my wage will be adequate - which never will happen) I'll buy... DB2 books ? Nope, a Mercedes.... [...] 660 62 24_Re: DB2 MANAGED BY DFSMS16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 15 Feb 2001 07:23:30 -0500339_iso-8859-1 Having the BSDS and active LOGs be in one pool is an unsatisfactory exposure. You need at least two pools: One for everything else and one for BSDS/LOG. The BSDS/LOG pool needs to have 'guaranteed space' (which does not in fact guarantee space) so that you can control dataset placement and true duplexing of the log/bsds. [...] 723 84 24_Re: DB2 MANAGED BY DFSMS14_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Thu, 15 Feb 2001 13:39:24 +0100327_us-ascii Eric,

we let SMS manage our DB2-datasets and haven't had any problems so far. We put indizes and data into different pools, so we end up having 4 pools (it could be more, actually, I'm not that familiar with the implementation of SMS here), two for indizes and data respectively.

Hth Ruediger Kurtz [...] 808 31 17_Load A new Column14_Karthik Ganesh21_karthik_gus@YAHOO.COM31_Thu, 15 Feb 2001 05:53:41 -0800303_us-ascii List,

I have to laod a table where I added a new column in between. I want to load the table with the data (to the new column) that is already there in the table(Similar column, BUT A DIFFERENT NAME). I remember doing this by changing the control cards. Couldn't refresh my memory. [...] 840 45 22_Re: SQL reference book14_subrata mondal25_subratamondal@HOTMAIL.COM31_Thu, 15 Feb 2001 14:01:39 -0000 886 19 22_Re: SQL reference book10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Feb 2001 16:00:32 +0100426_us-ascii Hi Subrata, you're welcome....

Regards Max Scarpa DB2 sysprog (there's this rumor going around)

('I'm not a DB2 Sysprog, I'm just drawn that way') Jessica Rabbit

================================================ 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. 906 31 74_DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -5400_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 15 Feb 2001 10:12:50 -0500567_us-ascii To all,

We've run out of ideas on this one. Here's the situation:

Environment: DB2 OS/390 V6.1, Java Client calls Stored Procedure on OS/390

Problem: We added a 16th parameter to the Stored Procedure call. Once we did this, we started getting SQL -540 from the client java program. We can call this same SP from the mainframe and it works just fine. We've reviewed the entries in SYSROUTINES and SYSPARMs several times and it looks ok. We've stopped/started the SP, stopped/started DDF, etc and still we're having the same problem. [...] 938 234 38_Re: Executing stored procedure from VB14_Scott Trometer22_scott.trometer@RCI.COM31_Thu, 15 Feb 2001 10:16:07 -0500533_iso-8859-1 Kals,

Had the same problem with a little different scenario...and I'm not sure why we got the message we got (01503). Ours involved two external SPs with the same name, different schema, different load modules (different load libs concatenated in one SPAS)...called from a VB app.

We had to limit the SPAS' steplib to include only one of the loadlibs (the initial guess was that DB2 could magically distinguish the different programs in the concatenation by their schema names)...I think we were wrong. [...] 1173 75 78_Re: DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -5400_20_John_Lendman@FPL.COM31_Thu, 15 Feb 2001 10:22:50 -0500342_us-ascii The SQL -540 error message from the manual says and I quote:

"The table named was defined with a Primary key clause, a Unique clause, or with a rowid column with the generated by default attribute. Its(the table with this key definition) is incomplete, and it (the table) cannot be used until a unique index is defined." [...] 1249 91 21_Re: Load A new Column10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Thu, 15 Feb 2001 09:14:05 -0600362_- Kartik,

Assume you have this table:

CREATE TABLE CRAPTAB

(COL1 CHAR(1) NOT NULL, COL2 CHAR(1) NOT NULL, COL3 CHAR(1) NOT NULL);

..and you unload it to get these SYSPUNCH cards:

LOAD DATA LOG NO INDDN SYSREC00 INTO TABLE CRAPTAB ( COL1 POSITION( 1 ) CHAR( 1) , COL2 POSITION( 2 ) CHAR( 1) , COL3 POSITION( 3 ) CHAR( 1) ) [...] 1341 61 21_Re: Load A new Column16_Bhogale, Pushkar24_Bhogale.Pushkar@MBCO.COM31_Thu, 15 Feb 2001 09:27:29 -0600483_iso-8859-1 Kartik,

Even though I have just recently shifted to the DBA function from application side, I can certainly give you a hint.

When you edit your control card after unloading the table to add the new column, you can use the columns from your old existing column, while mentioning the columns for the newly added column. That way, the Load process will pick up whatever information is stored in the 'old column' position and load it into the 'new column'. [...] 1403 39 27_Re: Graphical Relationships0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 15 Feb 2001 09:37:47 -0600490_us-ascii I've used ERWin 3.5 (from Logic Works) to do that. It will generate diagrams from DDL. Unfortunately I've found that it sometimes had problems with relationships (but I'm guessing that's true for any app that tries to reverse engineer relationships). I've also found that the diagrams it generates for larger systems tend to look like 'a bowl of spaghetti and meatballs', blobs connected by lines that cross and re-cross. They require a lot of manual clean up to be readable. [...] 1443 45 87_CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -4400_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 15 Feb 2001 10:41:55 -0500482_us-ascii Correction -440; not -540. Working both problems today ---------------------- Forwarded by Ed Vetock/40/HQ/NFCU on 02/15/2001 10:35 AM ---------------------------



Ed Vetock 02/15/2001 10:12 AM

To: DB2 Data Base Discussion List cc:

Subject: DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -440 (Document link: Ed Vetock)

To all,

We've run out of ideas on this one. Here's the situation: [...] 1489 98 91_Re: CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -44025_Loganathan M Ramachandran41_loganathan.m.ramachandran@MAIL.SPRINT.COM31_Thu, 15 Feb 2001 09:55:50 -0600615_ISO-8859-1 Ed,

The problem is that the Stored procedure is not being called using the 3-part name Location.server.Procedure name from the Java program. From OS/390 the first 2 part are defaulted and therefore is not required when calling a stored procedure. We faced the same problem when we tried to invoke a new stored procedure created in V6.1 from an VB application. Somehow the DRDA application are looking for the procedure name in SYSPROCEDURES and not SYSROUTINES. Could be a problem with the existing drivers that is used to establish connection with DB2 and needs to be upgraded. When we gave [...] 1588 83 39_Re: DB2 Active logs-greater than 2 gigs23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 15 Feb 2001 15:50:35 -0000553_iso-8859-1 a nice eye opener

les

-----Original Message----- From: Douwe van Sluis [mailto:d.b.vansluis@KPN.COM] Sent: Friday, February 09, 2001 10:41 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Active logs-greater than 2 gigs



David,

Below is a snap from an email discussion we had with IBM in early 1999. Don't know if this is still the case. The official limit in the SQL Reference is still 2G. We decided the limit our logs to 2G, just in case. We actualy decreased the size even more. We fit 3 logs on one 3390-3. [...] 1672 66 20_Listserv for Netview22_Kennedy, Tom - Cendant23_Tom.Kennedy@CENDANT.COM31_Thu, 15 Feb 2001 10:59:30 -0500664_iso-8859-1 I'm writing on behalf of a colleague. Is there an equivalent listserv for people using Netview, or network folks in general? Responses are appreciated.



The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's employer is not liable for any loss or damage arising in any way from this message or [...] 1739 17 7_logging12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Thu, 15 Feb 2001 10:02:20 -0600498_iso-8859-1 Is there a way to temporarily turn off logging on a table when it is a COBOL program creating the inserts and updates to the table? I know you can set the logging off on the load utility but have a need for this outside of the load.

TIA !

================================================ 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. 1757 73 27_Re: Graphical Relationships19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 15 Feb 2001 10:02:09 -0600350_ISO-8859-1 Hi Rohn, Mike, I agree with Rohn that Visio is a nice tool to model DBs with, however, I can't find any "reverse engineering" capability in it. Anyone know if it does? I use ERwin, from CAI (formally Platinum) for reverse engineering. It does have the issues noted by Rohn but its certainly better than no reverse engineering at all. [...] 1831 64 24_Re: DB2 UDB v7.1 and ESS0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 15 Feb 2001 10:11:34 -0600511_us-ascii We've just moved over to ESS (on the OS390) so I don't have a lot of hard experience, but I've picked up a few concepts reading about it. With Shark, concern about physical placement is pretty much irrelevant. Shark takes care of that in the background for you. With the large cache (8 gig!), potentially much more data can be retrieved from cache rather than directly from disk, but as far as DB2 is concerned it is still a physical I/O because it is not part of DB2 virtual memory (buffer pool) [...] 1896 86 56_Re: Enterprise JAVA BEAN find by primary key extra calls13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Thu, 15 Feb 2001 09:57:30 -0600590_iso-8859-1 I'm going to try my hardest to stay out of "soapbox mode", but this topic has a tendency to get me a little riled up (and I should add that the following are my own opinions, not neccessarily shared by my employer. Not yet, anyway)... First of all let me say that I'm not familiar with the "findbyprimarykey" you mentioned, but I'm familiar with the approach (sounds similar to the "data access beans" that visualage generates). For some reason Java developers seem determined to make the same mistakes that others have already learned from (mainly that I/O modules for DB2 [...] 1983 62 27_Re: Graphical Relationships14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 15 Feb 2001 16:25:39 -0000481_iso-8859-1 Ron saved me from the obvious plug,

except to say that ErWin is now a Computer Associates product...

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: 15 February 2001 15:38 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Graphical Relationships [...] 2046 46 11_Re: logging14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 15 Feb 2001 16:27:29 -0000332_iso-8859-1 Nope

I have an outstanding enhancement for DB2 that asks for this very feature (don't hold your breath though - I raised it in 1987 or thereabouts!)

All I wanted was to be able to mass-update a table (or tables) and have DB2 set the copy pending flag after I was done (as you say, like a LOAD LOG NO). [...] 2093 103 24_Re: DB2 UDB v7.1 and ESS19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 15 Feb 2001 10:27:23 -0600568_ISO-8859-1 Hi Rohn,

Does anyone know if there is any advantage on Shark to defining 3390-3 vs 3390-9 logical disks? My thought is that going with 3390-9's would reduce number of logical disks you have to worry about.

Check the archives on this, especially those by Joel Goldstein. I believe the bottom line on the issue you mention above is that I/O scheduling is still done at the UCB level. Assuming the 3390-9s would hold datasets for many tables/applications, more UCBs would appear to be better even with PAV. [...] 2197 122 27_Re: Graphical Relationships15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 15 Feb 2001 17:31:25 +0100467_iso-8859-1 Just to put in my two cents..

You might try Power Designer, it does reverse engineering from a lot of different RDMBses. We use it in our shop and it helps out very good..

Regards,

Jaap Slot, Rabobank ICT Phone 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167 e-Mail mailto:J.P.Slot@rf.rabobank.nl

Reserve your AGENDA for next DB2 Users Group Conference IDUG Europe, 8-11 October 2001 in Florence, Italy. http://www.idug.org [...] 2320 23 27_Re: Graphical Relationships11_KATHY JONES26_JONESKS@GROUPWISE.CCSD.NET31_Thu, 15 Feb 2001 08:35:59 -0800278_US-ASCII I use Silverrun's RDM which does a good job of reverse engineering. It does tend to put the tables in the order it reverse engineers them so you do have a mess of lines if you have a lot of tables that you have to rearrange. Overall, I like the product very much. [...] 2344 29 11_Re: logging10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 15 Feb 2001 17:33:23 +0100290_us-ascii For DB2 for S390 and for a program: No (would to Heaven).

I asked this 2 year ago to mother IBM, but nothing. And when I sent a mail to DB2-l to hear if someone needed this

features I was reproached to try to create BIG internal inconsistency by some DB2 guruz. [...] 2374 17 29_Re: SyBase to UDB conversions12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 15 Feb 2001 10:51:53 -0600337_- Version 7 on Unix has been out since about June 2000. We put the SQL Procedures into Version 5 (see our web page ibm.com/software/db2os390

There are also some papers and a red book on conversion from Sybase that might be able to save you a lot of time. Here is the most recent one. DB2 UDB V7.1 Porting Guide, SG24-6128-00 [...] 2392 59 11_Re: logging20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 15 Feb 2001 12:08:59 -0500526_us-ascii I have to agree that not allowing "NO LOG" feature via SQL (no DTT/GTT but a normal table) occasionally is a bit irritant.

I have come across many applications, where we needed this but DB2 doesn't have it so we had to go for CICS UMT instead of DB2. Consider one example, which I am working right now - we are trying to create a real time (price etc) stock market data-base but I wouldn't put it on DB2 due to LOGGING fear. We ended up putting this in a CICS data table but lost the edge as SQL couldn't [...] 2452 65 25_SQL -20100 - TRIGGER BIND12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Thu, 15 Feb 2001 11:09:13 -0600490_iso-8859-1 Hi all,

We are having problems creating/binding a trigger. This is our first attempt and am not having much success. We are OS390 V6. Any help will be greatly appreciated.



SET CURRENT SQLID = 'DB2TEST';

CREATE TRIGGER TEST_1 AFTER UPDATE OF PO_STATUS ON TEST.PURCHASE_ORDER_HDR REFERENCING NEW AS N_ROW FOR EACH ROW MODE DB2SQL WHEN (N_ROW.PO_STATUS IN ('IP','PE')) INSERT INTO TEST.PURCHASE_ORDER_CTL VALUES (N_ROW.MI_LOC, N_ROW.PURCH_CTL_NO); [...] 2518 76 41_TRIDEX DB2 User Group NYC March 1st, 200111_Gerri Lloyd17_glloyd@US.IBM.COM31_Thu, 15 Feb 2001 12:19:50 -0500442_us-ascii Tridex Members,

This is just a reminder of the up Tridex meeting. You can visit our web site at www.db2tridex.org for the agenda details.

First Quarterly Meeting March 1, 2001 8:30 - 3:30 Sixth Floor Meeting Room IBM Corporation, 590 Madison Ave. (between 56th &57th) NY, NY

KEYNOTE PRESENTATION

Horacio Terrizzano, Consulting SE, DB2 Performance Dept, at IBM Silicon Valley Lab DB2 Parallelism 2001 [...] 2595 22 11_COPY output14_Toppins, Smike21_smike.toppins@GWL.COM31_Thu, 15 Feb 2001 10:27:42 -0700323_- Is there any methods of reading the SYSCOPY DD dataset from an image copy? I'd like to take the output of an image copy, create a load dataset, and load the data into another DB2 subsystem. I can't use DSN1COPY with XLAT.... because sometimes I need to LOAD REPLACE and sometimes I need to LOAD RESUME the table(s). [...] 2618 66 90_Re: CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure onOS/390 getting SQL -44013_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 15 Feb 2001 11:37:01 -0600307_US-ASCII Ed, Are you using the same authid on the client and the host ?. Did you re-grant execute on the procedure after making the change ?. Does the user's current path contain the schema to which the desired function belongs ? Or was an unqualified reference was used ? Just a couple thoughts. Kurt [...] 2685 93 11_Re: logging19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 15 Feb 2001 11:42:08 -0600415_ISO-8859-1 Hi Venkat, I must have missed your point. Putting up a stock market ticker DB, real-time, and constantly updated, in any RDBMS, logged or not, would present performance hurdles. If you were to entertain it, the DB you describe would be heavily indexed to support the queries you mention. Seems to me, with all that updating (tables and indexes) the cost of logging would be miniscule in comparison. [...] 2779 46 15_Re: COPY output13_Terry Shockey30_Terry.Shockey@OCSE.STATE.AR.US31_Thu, 15 Feb 2001 11:43:17 -0600368_iso-8859-1 Mike, ca's(platinum's)fast unload will unload the image copy for you into a load file.

if you don't have a product or the money to buy one then you could create temporary tables when you want to do a load resume, dsn1copy the image copy to the temporary table(s); unload the temporary table(s) and use them in you load utility with load resume. [...] 2826 74 91_Re: CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure on OS/390 getting SQL -4400_24_db46@DAIMLERCHRYSLER.COM31_Thu, 15 Feb 2001 12:43:35 -0500500_us-ascii You might want to update SYSIBM.SYSPROCEDURES also. Even though version 6 uses SYSROUTINES and SYSPARMS some things like net.data still refer to SYSIBM.SYSPROCEDURES even though you are on version 6.

Dean









Ed_Vetock@NAVYFEDERAL.ORG@RYCI.COM> on 02/15/2001 10:41:55 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: [...] 2901 35 17_Trigger Rollbacks22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 15 Feb 2001 09:48:32 -0800547_- Dear List,

We have started testing with triggers and I am trying to figure out if you can still do an insert to the table that triggers the trigger if the trigger fails.. Wow that's a mouth full.. The scenario is insert into table A, which triggers an insert into table B. Table B has the corresponding row already there and causes the Table A insert to rollback. My developer tells me this is a definite requirement. I am pretty sure we could probably handle this with a stored procedure, but before I go that route I would like to [...] 2937 35 21_FW: Trigger Rollbacks22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 15 Feb 2001 09:52:02 -0800531_- Dear List,

> We have started testing with triggers and I am trying to figure out if > you can still do an insert to the table that triggers the trigger if the > trigger fails.. Wow that's a mouth full.. The scenario is insert into > table A, which triggers an insert into table B. Table B has the > corresponding row already there and causes the Table A insert to rollback. > My developer tells me this is a definite requirement. I am pretty sure we > could probably handle this with a stored procedure, but before I [...] 2973 92 30_Technical Conference Resources12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Thu, 15 Feb 2001 12:46:59 -0500468_iso-8859-1 I was unable to attend the conference in October, but had intended upon subscribing to the online sessions described at http://www-3.ibm.com/services/learning/conf/db2/online/geninfo.html. I even have my original request for funds which had the link in it, so I know I'm not imagining it. However, the link is dead and I can find no mention of DB2 anywhere on the online conference pages (http://www-3.ibm.com/services/learning/conf/online/index.html) [...] 3066 80 11_Re: logging9_Bob Lewis23_BLewis@MICROGENERAL.COM31_Thu, 15 Feb 2001 09:51:36 -0800481_iso-8859-1 I think it's more an RDBMS integrity issue. You can't have people independently deciding what will and won't be logged and still guarantee recoverability. A better approach might be to improve logging performance through buffers, media, etc.

Just my opinion.

Bob Lewis



-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Thursday, February 15, 2001 11:09 AM To: DB2-L@RYCI.COM Subject: Re: logging [...] 3147 26 37_RESOURCE UNAVAILABLE, REASON 00C2011015_Knabach, Mark L20_mark.knabach@EDS.COM31_Thu, 15 Feb 2001 13:07:35 -0500638_iso-8859-1 Hi Everyone. I'm a bit confused and could use some input.

I'm running DB2 V5 and executed a DSN1COPY with a parm statement of ,PARM='OBIDXLAT,FULLCOPY,RESET' to recover data into a table from one subsystem to a second subsystem. The DB2 Catalog was restored on the second subsystem (we are completing special testing) but the physical tablespace dataset was not. I allocated a linear dataset, and ran DSN1COPY using an Image Copy from the first subsystem. Upon attempting to recover the index build on the table after running DSN1COPY, I received a "RESOURCE UNAVAILABLE, REASON 00C20110" on the tablespace. I have [...] 3174 48 29_Re: CORRUPTED DATA DICTIONARY23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 15 Feb 2001 18:04:43 -0000430_- we use it all the time and it works fine

leslie

-----Original Message----- From: Amy C Whitehead [mailto:B06ACW@FDS.COM] Sent: Wednesday, February 14, 2001 11:16 PM To: DB2-L@RYCI.COM Subject: Re: CORRUPTED DATA DICTIONARY



All, I have an application using both WITH UR and FOR FETCH ONLY. My understanding is they serve 2 totally different functions. Does anyone know of any problem with this? [...] 3223 62 21_Re: Trigger Rollbacks14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 15 Feb 2001 18:27:27 -0000394_iso-8859-1 What you are asking for is not a rollback (as such) but a rejected insert.

It is possible to create a BEFORE trigger that, when triggered (by an INSERT into TableA), does the check against TableB and either just returns (which will allow the TableA insert to stand) or return an error (with SIGNAL SQLSTATE for example) which will cause the TableA insert to be rejected. [...] 3286 51 41_Re: RESOURCE UNAVAILABLE, REASON 00C2011012_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Thu, 15 Feb 2001 13:28:16 -0500788_us-ascii Within IBMlink look at PQ33002 which introduced this code.







"Knabach, Mark L" @RYCI.COM> on 02/15/2001 01:07:35 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: RESOURCE UNAVAILABLE, REASON 00C20110



Hi Everyone. I'm a bit confused and could use some input.

I'm running DB2 V5 and executed a DSN1COPY with a parm statement of ,PARM='OBIDXLAT,FULLCOPY,RESET' to recover data into a table from one subsystem to a second subsystem. The DB2 Catalog was restored on the second subsystem (we are completing special testing) but the physical tablespace dataset was [...] 3338 89 92_SOLN: CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure onOS/390 getting SQL -4400_25_Ed_Vetock@NAVYFEDERAL.ORG31_Thu, 15 Feb 2001 13:33:45 -0500513_us-ascii Thanks to all who responded. The answer is we had to re-grant execute on the stored procedure.

R/..Ed







Kurt Sahlberg @RYCI.COM> on 02/15/2001 12:37:01 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: CORRECTION : DB2 V6.1 OS/390 : Java Calling Stored Procedure onOS/390 getting SQL -440 [...] 3428 95 27_Re: Graphical Relationships13_Terry McCombs20_tmccomb@SEDGWICK.GOV31_Thu, 15 Feb 2001 12:36:26 -0600564_iso-8859-1 I was researching Visio versions (it is now an MS product) a while back prior to ordering it, and I swear the literature said it reverse engineered from UDB on NT, but after the original post came out I tried to find that statement again, and couldn't. I don't yet have the product, so can't tell you for sure about UDB. The high level versions (professional and enterprise) will supposedly reverse engineer SQL Server and Access databases. Of course, those are also both MS products, so that's no guarantee it will reverse engineer anything else. [...] 3524 85 25_Re: FW: Trigger Rollbacks14_Richard Yevich17_ryevich@YAHOO.COM31_Thu, 15 Feb 2001 10:41:27 -0800365_us-ascii Marty,

Since the trigger is on TABLE A, the trigger cannot be bypassed. So if the Trigger fails, and since you are only a single thread, your insert process fails. You are not going to bypass the failure and insert the row.

You could do this with a standalone stored procedure call, since it could ingore the failed insert into TABLE B. [...] 3610 50 41_Re: RESOURCE UNAVAILABLE, REASON 00C2011015_Di Carlo, Donna23_Donna_Bermender@BMC.COM31_Thu, 15 Feb 2001 12:42:11 -0600457_iso-8859-1 Mark,

Check out PQ33002. It talks about a value in the header page used to check the validity of a page set. This value is not set with DSN1COPY, which can cause a problem. I believe there is an APAR that fixes this, but I can't seem to find it. To correct the situation, you will need to perform a REPAIR LEVELID. Unfortunately, you can't do this for an index in V5. I think your only choices are to rebuild or zap the header value. [...] 3661 18 9_Migration12_sathya kumar25_sathyakumar50@HOTMAIL.COM31_Thu, 15 Feb 2001 18:34:54 -0000535_- Hi, We are planning for migrating our applications from IMS to either SYBASE,ORACLE or DB2.Do you people know any vendors with any tools for doing this. Sathya _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.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. 3680 37 15_Re: COPY output13_Davis, Ronald17_DavisRo@CONED.COM31_Thu, 15 Feb 2001 13:45:17 -0500617_iso-8859-1 Platinum(CA) fastunload can take the image copy and create an unloaded flat file in DB2 load format.

-----Original Message----- From: Toppins, Smike [mailto:smike.toppins@GWL.COM] Sent: Thursday, February 15, 2001 12:28 PM To: DB2-L@RYCI.COM Subject: COPY output



Is there any methods of reading the SYSCOPY DD dataset from an image copy? I'd like to take the output of an image copy, create a load dataset, and load the data into another DB2 subsystem. I can't use DSN1COPY with XLAT.... because sometimes I need to LOAD REPLACE and sometimes I need to LOAD RESUME the table(s). [...] 3718 139 11_Re: logging20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 15 Feb 2001 13:59:18 -0500327_iso-8859-1 Rick

I have a different view on this. When we have the resources to put things on CICS UMT then we should also be able to do the same using DB2. The reason I would prefer RDBMS is that SQL opens up whole new range of queries one could do and imagine the possible reports one can generate with much ease. [...] 3858 131 27_Re: Graphical Relationships12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Thu, 15 Feb 2001 14:02:12 -0500451_iso-8859-1 I also did some research into Visio and the MS repository. Standard disclaimers, but IMHO a lot of smoke and not a lot of fire! VISIO will generate UML but apparently UML isn't UML isn't UML, in that the UML generated or converted wont' work with all products. Ok, stepping off soap box now. We abandoned the effort because VISIO was a less than perfect interface to the MS Repository (which MS seems to be abandoning last I heard???) [...] 3990 99 21_Re: Trigger Rollbacks22_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 15 Feb 2001 11:16:21 -0800628_- Yes it does help.. I'll give this a try.. Thanks for the quick response Phil..

Marty Killen SR DB2 DBA CNF INC Information Technology 503-450-2681 - CNF INC 503-450-6038 - Conway e-mail - killen.martin@cnf.com

"Kind words can be short and easy, but their echoes are truly endless" Mother Theresa

> -----Original Message----- > From: Grainger, Phil [SMTP:Phil.Grainger@CA.COM] > Sent: Thursday, February 15, 2001 10:27 AM > To: DB2-L@RYCI.COM > Subject: Re: Trigger Rollbacks > > What you are asking for is not a rollback (as such) but a rejected insert. > > It is possible to create a BEFORE trigger [...] 4090 28 13_Re: Migration13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 15 Feb 2001 13:26:59 -0600431_- Unless you have a toy system you should be more specific about your target platform. Though all three targets you mention are relational databases ( if that similarity is worth anything ), you must remember that "some animals are more equal than others". Each of the possible migration path has its own issues. IMHO first decide what you want to do and only then start looking for a product or service to help with the job. [...] 4119 44 13_Re: Migration9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Thu, 15 Feb 2001 12:44:24 -0700336_iso-8859-1 The only tools I can think about when it comes to migrating from IMS is a highly experienced DBA who has several years of IMS and DB2 background. The reason I say IMS DBA is because IMS is a Hieiricharcal Data Model that needs someone who understands it. Also, most IMS DBA's also have exposure to DB2 as well nowadays. [...] 4164 66 41_Re: RESOURCE UNAVAILABLE, REASON 00C2011015_Knabach, Mark L20_mark.knabach@EDS.COM31_Thu, 15 Feb 2001 14:49:06 -0500668_iso-8859-1 Thank you, Donna. Performing a REPAIR LEVELID resolved the problem!

Mark

-----Original Message----- From: Di Carlo, Donna [mailto:Donna_Bermender@BMC.COM] Sent: Thursday, February 15, 2001 12:42 PM To: DB2-L@RYCI.COM Subject: Re: RESOURCE UNAVAILABLE, REASON 00C20110



Mark,

Check out PQ33002. It talks about a value in the header page used to check the validity of a page set. This value is not set with DSN1COPY, which can cause a problem. I believe there is an APAR that fixes this, but I can't seem to find it. To correct the situation, you will need to perform a REPAIR LEVELID. Unfortunately, you can't do this [...] 4231 126 27_Re: Graphical Relationships19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Thu, 15 Feb 2001 13:51:29 -0600596_ISO-8859-1 Hi all, Well, persistence pays off. Visio Professional V5. I just successfully reverse engineered a DB2/OS390 V6 DB into Visio. Has all the same issues as if ERwin had done it, but it did work!

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 [...] 4358 41 24_Re: Listserv for Netview10_Hill, Dave14_DHill@FSCO.COM31_Thu, 15 Feb 2001 15:04:56 -0500549_iso-8859-1 Tom- Try this site. www.intnet.net/pub/LISTS/listserve.list

Dave Hill







-----Original Message----- From: Kennedy, Tom - Cendant [mailto:Tom.Kennedy@CENDANT.COM] Sent: Thursday, February 15, 2001 11:00 AM To: DB2-L@RYCI.COM Subject: Listserv for Netview





I'm writing on behalf of a colleague. Is there an equivalent listserv for people using Netview, or network folks in general? Responses are appreciated. [...] 4400 82 60_NT, AIX/UDB-6.1/Cross platform Backup and Recovery for BLOBs15_Agarwal, Ashish28_Ashish.Agarwal@HPSGLOBAL.COM31_Fri, 16 Feb 2001 01:54:49 +0530532_- Hi All, Thanks for answering my query earlier. But it seems the problem refuses to end. We will be using Blobs for storing images in our database running on Nt and AIX both. We came to know that Cross-platform backup and recovery is not possible when one is using blobs. We talked to IBM guys in India too but they are yet to respond to us. If anyone has come across such a problem, can u please throw some light on this problem and if possible, a workaround. Whatever it is, your comments are useful, so please do tell your [...] 4483 21 11_Buffer Pool12_sathya kumar25_sathyakumar50@HOTMAIL.COM31_Thu, 15 Feb 2001 20:34:55 -0000422_- Hi All, This is related to Buffer Pool.How to calculate the average pages per write,i read some time back in one of Joel's article mentioning if average pages/write is a significant single digit like 1.2,2.3 then set VDWQT = 0.how to find this average pages/write? TIA Sathya

_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...] 4505 27 31_Clustered Indexes in UDB/AIX V612_Jim Fletcher19_jfletch3@US.IBM.COM31_Thu, 15 Feb 2001 15:36:05 -0500614_us-ascii Hello, I am considering a migration to clustered indexes for a large production system(1300+ tables) in UDB V6 AIX. The CLUSTER option is new for V6 I believe. I am well aware of the advantages of having clustered indexes in OS/390, with that option being a standard since pre-historic days on that platform. I have seen few comments about clustered indexes on UDB though. It seems that this would be a major performance improvement for production systems that were implemented before V6. Migrating a large number of production tables, not to mention test databases, to use clustered indexes will be [...] 4533 26 32_DB2 V6 tablespace Define=no Parm0_20_John_Lendman@FPL.COM31_Thu, 15 Feb 2001 15:47:01 -0500387_us-ascii I thought I remembered this issue being discussed on this list before but I could not find it in the archives.

So my question is when you use the Define=no parm on the tablespace create. And then you have a system like SAP that creates it's own RUNSTATS cards. When we tried to run the RUNSTATS it came back with a DSNU012I saying that the VSAM dataset was missing. [...] 4560 21 36_Storing/Printing images on Mainframe9_Colin Fay13_cfay2@CSC.COM31_Thu, 15 Feb 2001 15:55:20 -0500512_us-ascii Hi,

I am looking for someone with experience storing MSWord Documents (or other image type documents) in DB2/MVS tables and then printing them in a Mainframe process.

Has it been done? Special software / hardware requirements?



Colin

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4582 153 21_Re: Trigger Rollbacks14_Richard Yevich17_ryevich@YAHOO.COM31_Thu, 15 Feb 2001 13:02:32 -0800283_us-ascii Yes, and in rethinking this over lunch, I would suggest the following. Leave it as an after trigger, and do a select first to see if the row is there in table B, after the insert into A has worked, and if not then issue the insert, else bypass the insert into TABLE B. [...] 4736 58 40_Re: Storing/Printing images on Mainframe15_Fred Occhipinti23_Fred_Occhipinti@FPL.COM31_Thu, 15 Feb 2001 16:15:45 -0500614_us-ascii PassPort (DB2/CICS/COBOL3) will store MSWord Documents, and a few other image type documents in DB2. What happens with the data is that there is an OLE link, so that the PassPort architecture (VIA Portal/G screen processing) will actually download the "binary" DB2 document data to the local PC, create a temporary file and open up the desired application that it applies to. PassPort maintains what software/version was used to produce the document. Also, a "text" version of the document is stored, so that prints can be done from the mainframe also. In the setting up the OLE processing flow, you [...] 4795 142 34_Re: Technical Conference Resources13_Bright, Randy20_Randy_Bright@BMC.COM31_Thu, 15 Feb 2001 15:17:16 -0600685_iso-8859-1 Try contacting Audio Excellence. The last known address I have is:

2501 22nd Avenue North Suite 1025 St. Petersburg, Florida 33713 (727) 360-6726





-----Original Message----- From: Hylton Tom P [mailto:Tom.P.Hylton@IRS.GOV] Sent: Thursday, February 15, 2001 11:47 AM To: DB2-L@RYCI.COM Subject: Technical Conference Resources





I was unable to attend the conference in October, but had intended upon subscribing to the online sessions described at http://www-3.ibm.com/services/learning/conf/db2/online/geninfo.html . I even have my original request [...] 4938 13 36_Re: DB2 V6 tablespace Define=no Parm15_Daniel Sullivan28_daniel.sullivan@ZURICHUS.COM31_Thu, 15 Feb 2001 15:26:13 -0600371_us-ascii You can create your own software like we did that checks the tables for data before it creates a runstat control record.

================================================ 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. 4952 24 14_Other DB2 Time0_28_Michael_Landry@PUTNAMINV.COM31_Thu, 15 Feb 2001 16:32:49 -0500439_us-ascii We are having a problem with one of our test DB2 systems. At different times during the day, a handful of our CICS transactions go into a wait state. When looking at Insight, over 99% of the wait is under the heading of 'Other DB2 Time'. The Insight help screen says the most common contributors are MVS Paging and Processor Wait Time. However, our systems guys are saying that we are not paging, and the CPU is not at 100%. [...] 4977 224 11_Re: logging14_Richard Yevich17_ryevich@YAHOO.COM31_Thu, 15 Feb 2001 13:46:15 -0800604_us-ascii Venkat,

Precisely what data sharing, member cluster, trackmod can support. But a couple of points:

(1) Your 50,000 updates per second has not occurred yet. (2) DB2 Logging is perceived to be a potential problem.

Workloads of this level exist, logging buffers and column ordering are a design issue. To simply back away, on an assumption that DB2 cannot handle it versus describing the platform that you would be running on, are 2 very different issues. If you did not have a large plex available, then I agree. But to build a system of this nature without a large plex [...] 5202 76 15_Re: COPY output10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Thu, 15 Feb 2001 13:38:35 -0600526_us-ascii SMike, It is terribly hard to use the flat image copy files into a program. Just a couple of the gottcha I remember when a user decided it was cheaper to read an IC file than a DB2 table: The deleted rows are still there until the reorg or reload reclaims the space, there are many flags & tags that you have to know about, and if you have compression turned on, it is out of the question. Also, if you are using Varchars, the row relocation algorithm can be pretty tough. If you are VERY determined to do this, [...] 5279 53 36_Re: DB2 V6 tablespace Define=no Parm14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 15 Feb 2001 21:57:00 -0000597_iso-8859-1 Hi John,

The discussion last time started when I pointed out that IBM weren't really supporting the deferred defined datasets in the way that most customers would have wanted them to.

As you found out, you cannot RUNSTATS a deferred object, neither can you COPY them.

The two alternatives are to make sure when you dynamically prepare your statements that you check the SPACE field in the relevant catalog table (-1 = deferred), OR (here's the plug!) use some third party software that works the way you want. i.e., automatically skipping the deferred objects [...] 5333 51 13_Re: Migration14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM31_Thu, 15 Feb 2001 17:08:57 -0500400_ISO-8859-1 Hello Sathya,

I am a Product Specialist (technical resource) for Princeton Softech. We have a range of tools Relational Tools for DB2 and Relational Tools for Servers (including Sybase and Oracle). These tools allow you to seamlessly migrate data between the supported DBMS types. Princeton Softech is about to release a version of the Relational Tools which will support IMS. [...] 5385 64 21_Re: Load A new Column14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM31_Thu, 15 Feb 2001 17:08:55 -0500362_ISO-8859-1 Hello Karthik,

I am a Product Specialist (technical resource not sales) for Princeton Softech. We have a tool, Move for DB2/Move for Servers, which will allow you to Load/Insert/Update data to different table/column structures. The tools allow fully functional Table Mapping and Column Mapping and will easily accomplish what you require. [...] 5450 49 18_Re: Other DB2 Time16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 15 Feb 2001 17:08:32 -0500362_iso-8859-1 Could you possibly be delayed waiting for an active log to offload to tape? That would give these symptoms. There should be console mesages showing that the last active log was x% full if this is the case. Is it possible you have some data objects eligible for DFHSM migration and they are being recalled? This would also cause similar symptoms. [...] 5500 51 35_Re: Clustered Indexes in UDB/AIX V611_Steve Mazer17_smazer@FMTUSA.COM31_Thu, 15 Feb 2001 17:12:25 -0500532_us-ascii Jim, Its somewhat of a complicated answer. It depends on what kind of data gets inserted or loaded into the table. Have you looked at reorging by an index that you would like to cluster on? Is the data being added to the table in some kind of time sequence? If so, altering the table and turning append mode on may be a better alternative. When in append mode, the free space search does not take place and the data being added is just appended to the end of the table. I have seen a very good performance boost using [...] 5552 162 52_Re: An old question : Why DB2 uses only 48K / track?0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 15 Feb 2001 16:42:42 -0600574_us-ascii I was just re-reading this older post, and I think I have the answer to the question: Unfortunately the gaps are not equal in size (no idea why)

It has to do with the relative speed of the disk at various distances from the center. Pulling some very simple numbers out of the air, lets say that the outside circumfrance (distance measured around the outside edge) of the disk is 10 inches. Draw a straight line from the centre of teh disk to the edge (this represents the disk read/write arm where the read/write head is posistioned). [...] 5715 51 9_105% CPU?11_Kwan, James18_James_Kwan@BMC.COM31_Thu, 15 Feb 2001 16:50:40 -0600175_iso-8859-1 Can someone tell me the meaning if cpu reading is over 100% in SDSF? We have a little disagreement here and I can't find it in any book.

Thanks.

James 5767 14 13_Re: 105% CPU?0_26_truman.g.brown@VERIZON.COM31_Thu, 15 Feb 2001 17:56:31 -0500325_us-ascii Probably means you're using more than one engine in the box.

George

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 5782 56 38_Re: Executing stored procedure from VB13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 15 Feb 2001 16:57:31 -0600592_US-ASCII Kals, Run a CLI trace to see what is happening under the covers. Kurt

>>> teldb2kals@TELSTRA.COM 02/15/01 01:16AM >>> Hi,

We r currently trying to execute stored procedure on DB2 UDB for OS/390 v6 from a VB program thru DB2 connect.

We had the procedure before in v5, which got migrated into v6 under SYSPROC schema, and we r able to succesfully execute this. But if we try to call the same proc defined under any other schema, say MYUSERID, (using call MYUSERID.procname), the procedure doesnt seem to get executed. It returns with the following message : [...] 5839 44 13_Re: 105% CPU?15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Thu, 15 Feb 2001 17:02:40 -0600601_iso-8859-1 Generally it means that in the last interval there were 5 tasks that were 'ready' but did not get dispatched. The amount over 100% is the number of tasks that did not dispatch when ready.



Chris Blaicher

BMC Software, Inc. Austin Research Labs 10415 Morado Circle Austin, TX 78759 512/340-6154

BMC Software, Inc. makes no representations or promises regarding the reliability, completeness, or accuracy of the information provided in this discussion; all readers agree not to rely on or take any action against BMC Software in response to this information. [...] 5884 174 28_Re: One Process - Many Users14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 16 Feb 2001 10:16:13 +1100591_iso-8859-1 Stéphane,

Since you must have some exit involved - in order to be able to use RACF validation, I would - use a name/token pair (IEANTCR) to store the userid. - modify the sign-on exit to -- retrieve the userid from the name/token. (note that you'll have to use cross memory services because the exit is is DB2's address space and the name/token is in HARRY2's address space) -- issue a RACROUTE VERIFY -- use the generated ACEE (rather than the ACEE supplied in the exit parameters) to generate the secondary auth-ids. -- use the retrieved userid for primary auth-id. [...] 6059 25 23_DB2 v Oracle data space12_Warren Homer17_whomer@CSC.COM.AU31_Fri, 16 Feb 2001 09:49:21 +1100308_us-ascii Hi all,

dont ask me why, but we are looking into migrating specific DB2 tables to Oracle into tables with virtually the same definition. These tables are currently compressed in DB2 V4. My question is does Oracle require the same, less, or more space to hold the same data as DB2 would. [...] 6085 85 11_Re: logging12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Fri, 16 Feb 2001 10:17:41 +1100477_- re: Bob Lewis's comment.:- Here Here ! (In a rousing British tone of voice{which is odd for an Aussie of Dutch/Italian extraction])

To me the most important things DB2 has on offer is reliability, availability, & performance. Take away the compulsory logging and you jeopardise the reliability. Besides if you are looking at throughput (performance), you may want to consider that the number of indices on the tables MAY be more of a bottleneck than the logging. [...] 6171 43 13_Re: 105% CPU?0_26_Gale.McGrath@COURTS.WA.GOV31_Thu, 15 Feb 2001 15:22:08 -0800554_iso-8859-1 James,

Reading out of the Landmark The Monitor for MVS. "the SRM reports a number greater than 100% whenever the CPU busy is 100% for an entire interval and at least one ready address space did not receive service at the CPU for the duration of the interval. In this case, the CPU busy percentage ranges from 100-128%, with the additional "percentage" actually representing the number of undispatched ready address spaces. A CPU that is reported as greater that 100% busy is not only saturated, but has a backlog of delayed work." [...] 6215 131 21_Re: peoplesoft tools-21_Smith, Ronald M - CNF20_smith.ronald@CNF.COM31_Thu, 15 Feb 2001 15:27:20 -0800584_iso-8859-1 Hi Shery,

Here our developers run Alter/Create for each database, comparing those scripts to the HRDEMO scripts after the DBA's perform database updates. They also run SYSAUDIT to identify "orphaned" PSoft objects, and DDDAUDIT to compare data structures defined in PTools tables against the underlying database to uncover inconsistencies.

The DBA's apply the P/S generated "scripts" only to the HRDEMO DB2 database. We then use mainframe tools (IBM and 3rd party) to actually maintain all other test and production HR databases for a number of reasons: [...] 6347 30 15_Re: Buffer Pool14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 15 Feb 2001 18:51:00 -0500452_ISO-8859-1 Divide the total pages written by the number of write I/Os.

Regards, Joel





Message text written by DB2 Data Base Discussion List >Hi All, This is related to Buffer Pool.How to calculate the average pages per write,i read some time back in one of Joel's article mentioning if average pages/write is a significant single digit like 1.2,2.3 then set VDWQT = 0.how to find this average pages/write? TIA Sathya< [...] 6378 112 29_Re: SQL -20100 - TRIGGER BIND14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 16 Feb 2001 12:03:35 +1100414_iso-8859-1 Mark,

I'm clutching at a straw here, but I notice that, in the error message PURCHASE_ORDER_HDR has apostrophes around it. My guess is that, when constructing the DBRM to be bound, DB2 is using apostrophes as the identifier escape character - instead of the more normal quotes. However, the bind process thinks that apostrophes are the string delimiter - and generating the error condition. [...] 6491 112 16_Re: sqlcode -54014_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 16 Feb 2001 12:12:24 +1100384_iso-8859-1 "If a list of column names is not specified [after the REFERENCES table-name], then T2 must have a primary key. Omission of a list of column names is an implicit specification of the columns of the primary key for T2." SQL Reference Manual

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...] 6604 58 15_Re: Buffer Pool16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 16 Feb 2001 11:00:43 +0530619_- Sathya,

This is just a single line of Joel's docs. Moreover, you should look into the LOGLOAD frequency as well. If checkpoint is taken frequently then VDWQT is not the reason for less writing with I/Os or more I/Os.

Joel and others, please correct me if i am wrong.

Regards, Sanjeev



> -----Original Message----- > From: Joel Goldstein [SMTP:joel_goldstein@COMPUSERVE.COM] > Sent: Friday, February 16, 2001 5:21 AM > To: DB2-L@RYCI.COM > Subject: Re: Buffer Pool > > Divide the total pages written by the number of write I/Os. > > Regards, > Joel > > > > Message text written [...] 6663 72 29_Re: CORRUPTED DATA DICTIONARY16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 16 Feb 2001 11:30:00 +0530304_- Amy,

FOR FETCH ONLY is used to make the cursor declaration non-ambiguous(which i have never been able to understand). FOR FETCH ONLY and FOR READ ONLY ensures to DB2 that the statement is read only but read locks will be taken. In case of WITH UR, only latches not the locks will be taken. [...] 6736 24 16_Trigger Rollback12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 16 Feb 2001 09:43:35 +0200410_iso-8859-1 Hi, If you check it in before trigger you can't use SQL to check table B unless you call a stored procedure to do the check, which means more work (for you and for DB2). If you check in an after trigger then you can insert into table B and catch the -803 response for duplicates exactly like you would do in a regular program, no need to issue select from B first and then insert if not found. [...] 6761 25 16_trigger creation12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 16 Feb 2001 09:49:02 +0200412_iso-8859-1 Hi, Sorry I can't find the original "create trigger" mail which failed. Can you check what us your definition for the delimiting character for a SQL command in SPUFI (usually it's ; ). I tend to change it into # when building triggers so the ; at end of the SQL command within the trigger won't disturb SPUFI. This way you use # for every ; except the one at the SQL commands within the trigger. [...] 6787 21 34_'Not account' in accounting report7_Soo Lee17_soo7lee@YAHOO.COM31_Fri, 16 Feb 2001 01:49:23 -0600454_- HI everybody ...

I found that the portion of 'not account' is very large in accounting report. It is almost 80% of class2_Elapsped time. 'Not account' is caused by MVS activities like as paging,swapping,dispatching and so on. But There are no paging, no swapping and no dispatching problem of DB2 subsystem in RMF report. I don't know which activities of system cause this problem. Have you ever experienced this problem? I need your help. [...] 6809 49 11_Re: logging10_Max Scarpa16_mscarpa@CESVE.IT31_Fri, 16 Feb 2001 09:40:22 +0100372_us-ascii Hi all listers

I agree that data consistency is the most important thing to consider, I think this is clear to all

sysprogs/DBAs/programmers but there are some ways to induce a 'data inconsistency state' (lato sensu) in DB2. And

there are many user who can destroy data with LOAD LOG NO executed without any warning or DSN1COPY etc (not [...] 6859 96 11_Re: logging16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Fri, 16 Feb 2001 14:56:39 +0530569_- Max,

This is the first time i am finding that you really want some features to be available in DB2 with comparision to other RDBMS. That's Great !!. Anyway, i would like to add some comments on your thoughts. Except for the Stand alone utilities, all other features(in all other online utilities) which can cause inconsistency, are somewhere indicated in DB2. For LOAD with LOG NO is indicated in SYSCOPY and if someone is finding during the course of work that some incosistency is there then atleast the SYSCOPY can be checked for getting it confirmed. [...] 6956 73 41_Unavailable resource on resource type 90614_Peacock Julian31_Julian_Peacock@LONDONELEC.CO.UK31_Fri, 16 Feb 2001 09:22:51 -0000780_iso-8859-1 Fellow DB2ers,

A batch job fell over last night with the following SQLCODE:

SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLLE RESOURCE. REASON 00E30100, TYPE OF RESOURCE 00000906, AND RESOURCE NAME ".t.Ë?\h

The batch job in question uses DSNTEP2 to run the following SQL:

SELECT A.MSID, B.SITE_ID FROM DB2LIVE.V_METER A, DB2LIVE.V_METERING_SYSTEM B, DB2LIVE.V_METER_REGISTER C WHERE A.INSTALLATION_DATE > '1998-01-01' AND A.REMOVAL_DATE IS NULL AND A.MSID = B.MSID AND A.MSID = C.MSID AND A.METER_SERIAL_NR = C.METER_SERIAL_NR AND C.REGISTER_TYPE = 'C' AND NOT EXISTS (SELECT * FROM DB2LIVE.V_READING D WHERE D.MSID = C.MSID AND D.METER_SERIAL_NR = C.METER_SERIAL_NR AND D.METER_REGISTER_ID = C.METER_REGISTER_ID) [...] 7030 95 38_Re: Executing stored procedure from VB10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 16 Feb 2001 19:29:59 +1000411_ISO-8859-1 Scott,

My problem is not with two different load modules. The same module is bound into two different COLLIDs, and the rrespective row in the SYSROUTINES table is pointing to the correct COLLID.

I am analysing the trace o/p. But at first look, it doesn't seem to be giving much more info than I already have. There seem to be a number of factors here that I am slightly perplexed. [...] 7126 95 38_Re: Executing stored procedure from VB10_teldb2kals22_teldb2kals@TELSTRA.COM31_Fri, 16 Feb 2001 19:30:31 +1000411_ISO-8859-1 Scott,

My problem is not with two different load modules. The same module is bound into two different COLLIDs, and the rrespective row in the SYSROUTINES table is pointing to the correct COLLID.

I am analysing the trace o/p. But at first look, it doesn't seem to be giving much more info than I already have. There seem to be a number of factors here that I am slightly perplexed. [...] 7222 165 28_Re: One Process - Many Users32_=?iso-8859-1?Q?St=E9phane?= COEZ23_scoez@HARRYSOFTWARE.COM31_Fri, 16 Feb 2001 10:37:58 +0100527_iso-8859-1 This help a lot. Thanks. I'm not a RACF specialist, not a DB2 spécialist, and not an asm specialist but I'll try. If you know someone who can do this for me (I can pay) tell me. Thanks

James Campbell wrote:

> Stéphane, > > Since you must have some exit involved - in order to be able to use RACF > validation, I would > - use a name/token pair (IEANTCR) to store the userid. > - modify the sign-on exit to > -- retrieve the userid from the name/token. (note that you'll have to use > cross memory [...] 7388 20 16_BMC exit routine25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Fri, 16 Feb 2001 17:44:37 +0800499_us-ascii Hi,

Is anybody out there using exit routines for BMC unload plus which is written in COBOL. Can you share a copy of the exit routine for us to tailor and code one. The example given in the manual seems to have problems at our end.

TIA

================================================ 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. 7409 133 16_Re: sqlcode -54014_Ruediger Kurtz28_ruediger.kurtz@HUK-COBURG.DE31_Fri, 16 Feb 2001 11:00:51 +0100452_us-ascii James (and all the others who lent a hand in solving the problem),

as we usually have primary keys defined on all tables that have dependent tables we never bothered checking the 'alter table add foreign key ...' statements. What or who caused this particular PK to be dropped will remain a mystery, but .. to quote Macbeth "for this relief much thanks" (and if memory serves me right Macbeth hadn't just paid a visit to the loo). [...] 7543 55 36_AW: DB2 V6 tablespace Define=no Parm16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 16 Feb 2001 11:42:36 +0100607_iso-8859-1 Check OSS Note 338706

Roland



> -----Ursprüngliche Nachricht----- > Von: John_Lendman@FPL.COM [SMTP:John_Lendman@FPL.COM] > Gesendet am: Donnerstag, 15. Februar 2001 21:47 > An: DB2-L@RYCI.COM > Betreff: DB2 V6 tablespace Define=no Parm > > I thought I remembered this issue being discussed on this list before but > I > could not find it in the archives. > > So my question is when you use the Define=no parm on the tablespace > create. > And then you have a system like SAP that creates it's own RUNSTATS cards. > When we tried to run the RUNSTATS it came back with a [...] 7599 187 28_Re: One Process - Many Users32_=?iso-8859-1?Q?St=E9phane?= COEZ23_scoez@HARRYSOFTWARE.COM31_Fri, 16 Feb 2001 11:43:25 +0100525_iso-8859-1 Hi again,

let's say that my customer do not want to do anything in DB2... :-(, no exit installation...

Is there a way from my point of view to do something ? Thanks.



Stéphane COEZ wrote:

> This help a lot. Thanks. > I'm not a RACF specialist, not a DB2 spécialist, and not an asm specialist > but I'll try. > If you know someone who can do this for me (I can pay) > tell me. > Thanks > > James Campbell wrote: > > > Stéphane, > > > > Since you must have some exit involved [...] 7787 129 45_Re: Unavailable resource on resource type 90614_Thomas, Steven21_Steven_Thomas@BMC.COM31_Fri, 16 Feb 2001 05:52:47 -0600467_iso-8859-1 Julian,

This is strange, 'cos as far as I'm aware you're not using Data Sharing. Code 00E30100 means that either a parallel task on a DB2 terminates abnormally, or that an assisting DB2 terminates abnormally. The 906 resource indicates at it's a DB2 member, which implies DS....

If you are using DS, check all your members are up and that one of them didn't fail at that time - but I think this is unlikely - you'd know if a DB2 failed. [...] 7917 15 11_Re: logging15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 16 Feb 2001 05:57:16 -0600316_- Hi all listers

I love it too, to be able to do updates without logging. For a table used as a scatch pad area, it seems to be feasable. I could imagine, I have a special kind of tablespace with no logging for every table defined in it. Then everybody knows, that there will be no backout, no recovery. [...] 7933 118 45_AW: Unavailable resource on resource type 90612_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Fri, 16 Feb 2001 12:10:44 +0100415_iso-8859-1 Hi Julian,

the manual says: System Action: The member name where the failure occurred is returned to the application as the resource name in SQLCODE -904. In a non-data-sharing environment, the member name is blank, and the failure occurrs on the local DB2.

Operator Response: Enter DISPLAY GROUP from an active DB2 to see if a DB2 subsystem is down. Restart the failed DB2 subsystem. [...] 8052 13 20_WITH UR and ORDER BY0_21_db2_dba@BELLSOUTH.NET31_Fri, 16 Feb 2001 08:01:35 -0500359_ISO-8859-1 An interesting question was just asked by a user. He states that on page 295 of Craig Mullins' book it states that if you use WITH UR and ORDER BY that you are not necessarily guaranteed that the data will be returned in the proper order. I have looked in the book and the statement is there. Anyone have any experience or opinions on this??? [...] 8066 191 49_Re: AW: Unavailable resource on resource type 9069_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Fri, 16 Feb 2001 13:00:54 +0000338_us-ascii

Julian, APAR PQ27967 (PTF V5-UQ40842, V6-UQ40843) may be related - same reason code, resource and type.

Local fix for this is to use DEGREE=1.

As well as parallelism, it says that the problem may also occur for 'Star' schema. Have the stats changed on your tables so that you are getting a star join ? [...] 8258 26 24_Re: WITH UR and ORDER BY10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Fri, 16 Feb 2001 07:17:52 -0600572_- I assume that you mean the 'DB2 Developers Guide'. Please could you quote a Chapter and Section Name. I have the Fourth Edition (the latest) and Page 295 of my copy talks about Views.



On Fri, 16 Feb 2001 08:01:35 -0500, db2_dba@BELLSOUTH.NET wrote:

>An interesting question was just asked by a user. He states that on page 295 of Craig Mullins' book it states that if you use WITH UR and ORDER BY that you are not necessarily guaranteed that the data will be returned in the proper order. I have looked in the book and the statement is there. [...] 8285 69 11_Re: logging20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 16 Feb 2001 08:45:43 -0500515_us-ascii Richard

You have very valid points. I appreciate your opinion.

I haven't ruled out DB2 completely but I was just expressing my wish list. We do have large sysplex,data sharing and the needed resources. Certainly we will look into design issues and system tuning issues but before we go there we also have rough numbers (based on our own statistics and also from Akira's presentation) at what point onwards the logging becomes a bottleneck while keeping the entire needed data in the VP. [...] 8355 80 24_AW: WITH UR and ORDER BY12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 16 Feb 2001 14:59:20 +0100682_iso-8859-1 John,

seems that that guy is using DB2 Developers Guide THIRD EDITION........,

With kind regards - mit freundlichen Grüssen, Georg H. Peter DB2 Data Base Administrator c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Disclaimer: All thoughts are mine and not of the company. [...] 8436 16 52_CA's PRA Disaster Recovery product. Anyone using it?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Fri, 16 Feb 2001 07:34:04 -0600418_- I have started setting up Disaster Recovery procedures using CA's PRA product. I have spent most of the week finding problems with the code it generates and have opened over a dozen issues with CA this week alone on this product. We are at the P99C RML level, SMP/E installed, with DB2 V6.1. Is anyone using this product for their DR strategy? If so, did you have major problems with the code it generates? TIA [...] 8453 16 6_test 310_Dave Detar29_dave.detar.cbnr@STATEFARM.COM31_Fri, 16 Feb 2001 07:52:41 -0600308_iso-8859-1 test

Dave DeTar Enterprise E-mail (309) 766-5310

================================================ 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. 8470 36 56_Re: CA's PRA Disaster Recovery product. Anyone using it?50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Fri, 16 Feb 2001 09:18:08 -0500672_iso-8859-1 Sorry if this sounds biased but you should have gotten BMC recovery manager.

Bob Knight (NBC) Not the Basketball Coach

-----Original Message----- From: Richard Pack [mailto:rpack1@MAIL.STATE.MO.US] Sent: Friday, February 16, 2001 8:34 AM To: DB2-L@RYCI.COM Subject: CA's PRA Disaster Recovery product. Anyone using it?



I have started setting up Disaster Recovery procedures using CA's PRA product. I have spent most of the week finding problems with the code it generates and have opened over a dozen issues with CA this week alone on this product. We are at the P99C RML level, SMP/E installed, with DB2 V6.1. Is anyone using [...] 8507 50 24_Re: WITH UR and ORDER BY15_Amy C Whitehead14_B06ACW@FDS.COM31_Fri, 16 Feb 2001 09:24:06 -0500419_us-ascii We had the same question here. We asked IBM development about. IBM said that this would be bug if it ever happened. Furthermore, IBM has never heard of this happening.





db2_dba@BELLS OUTH.NET To: DB2-L@RYCI.COM Sent by: DB2 cc: Data Base Subject: WITH UR and ORDER BY Discussion List



02/16/01 08:01 AM Please respond to DB2 Data Base Discussion List [...] 8558 63 59_Re: Comparisons between SAP on Oracle (AIX) and DB2(OS/390)10_Robert Ord21_robertord@HOTMAIL.COM31_Fri, 16 Feb 2001 14:29:03 -0000695_- I would like to thank everyone who responded with information on this question. I have a lot of reading to do.

Regards

Rob >-----Original Message----- >From: Robert Ord [mailto:robertord@HOTMAIL.COM] >Sent: Friday, February 09, 2001 2:43 PM >To: DB2-L@RYCI.COM >Subject: Comparisons between SAP on Oracle (AIX) and DB2(OS/390) > > >Dear All, > >Does anyone have or know of any papers on comparisons between SAP on Oracle >(AIX) and SAP on DB2(OS/390). > >I tried the cost of ownership tack, now I need something else. > >Obviously I am looking for objective viewpoint. > >Regards > >Rob > >_________________________________________________________________________ >Get Your [...] 8622 49 27_Re: DB2 v Oracle data space10_Robert Ord21_robertord@HOTMAIL.COM31_Fri, 16 Feb 2001 14:42:42 -0000629_- It depends on the type of data, but in general Oracle uses more space than DB2 and it doesn't support compression. So I would advise you to allocate a minimun of the uncompressed DB2 size plus another 40% and take it from there.

Regards

Rob



>From: Warren Homer >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 v Oracle data space >Date: Fri, 16 Feb 2001 09:49:21 +1100 > >Hi all, > >dont ask me why, but we are looking into migrating specific DB2 tables to >Oracle into tables with virtually the same definition. These tables are [...] 8672 30 27_Smallint/Integer vs Decimal16_Michael McKinney16_mmckinne@CSC.COM31_Fri, 16 Feb 2001 09:40:44 -0500596_us-ascii Can anyone offer up a situation where the Decimal datatype would offer more benefits when the value of a field could be stored in a Smallint or Integer datatype ? For example, any reason why I might want to use DECIMAL(3,0) as opposed to SMALLINT ?

I have a member of the Systems Development team on my project that is avidly stating that numeric data that is currently stored in SMALLINT fields would be better off in DECIMAL(3,0) fields. He is specifically stating that performance in COBOL will be better (especially with the COMPUTE statement) if the fields were defined [...] 8703 43 31_Re: Smallint/Integer vs Decimal13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM31_Fri, 16 Feb 2001 10:09:22 -0500401_us-ascii Mike, A decimal column allows you to know the range of the values that are stored in that column (i.e. -999 through 999). A smallint column does not give you this advantage. If you have that need, then I would go with decimal. I do not recall anything in the past pertaining to the performance of one data type being better than the other. Scott Lindsey Sr. DBA, Highlights for Children [...] 8747 42 20_Binding plans on UDB12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Fri, 16 Feb 2001 09:17:43 -0600336_iso-8859-1 We have DB2 v5.1 on the mainframe (3 lpars, 3 subsystems) and 3 instances of DB2 on the UDB server side of life. We want to be able to utilize SPUFI and QMF from the mainframe to query the UDB instances. We keep running into what looks like a unavailable resource problem with the plan. The error message is as follows: [...] 8790 30 31_Re: Smallint/Integer vs Decimal15_Blaicher, Chris22_Chris_Blaicher@BMC.COM31_Fri, 16 Feb 2001 09:20:48 -0600372_iso-8859-1 The answer depends on what else is in the COMPUTE statement.

If all the rest of the fields are packed decimal, then he may be correct. It has been a long time since I looked at the object code from a COBOL compile, thankfully, but that is what you will have to do. Look at the code generated, once when it is smallint, and once when it is DEC(3,0). [...] 8821 23 22_DB2 Version 6 SQLDSECT9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Fri, 16 Feb 2001 15:23:53 -0000398_us-ascii I think that this may be this is a question for you IBM guys.

APAR PQ32839 describes a change in DB2 Version 6 affecting SQLAVARS and SQLPVARS, and the effect of this change for IMS/ADF users. Can anyone shed any light on what is behind this change, and whether there is the possibility to revert to these structures as they were defined in releases of DB2 prior to Version 6. [...] 8845 40 31_Re: Smallint/Integer vs Decimal10_Roger Hecq19_roger.hecq@MSDW.COM31_Fri, 16 Feb 2001 10:22:20 -0500358_us-ascii The conversion from binary to decimal was always one of the slowest instructions in the standard instruction set. In theory, it would be more efficient if the conversion did not have to be performed. Is it going to make a tangible difference, in reality? I have never done a benchmark, but I doubt that it would unless the volume is very high. [...] 8886 55 31_Re: Smallint/Integer vs Decimal14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Feb 2001 15:29:38 -0000396_iso-8859-1 I hate to start a debate at THIS level,

but

last time I did look at object code, byte and word alignment had just as much to do with performance as binary vs. packed (mind you, that WAS a long time ago!).

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 8942 108 36_Re: DB2 V6 tablespace Define=no Parm0_20_John_Lendman@FPL.COM31_Fri, 16 Feb 2001 10:30:11 -0500362_us-ascii Hi, Phil.

I created a tablespace with define=no, then I looked at SYSIBM.SYSTABLESPACE. The SPACE column is 0 just like it is for all the tablespaces define=yes. The only column that is a -1 in the tablespace with the define=no is the LOCKMAX column. Is this the field that you can look at to determine if you have any VSAM datasets or not? [...] 9051 68 31_Re: Smallint/Integer vs Decimal13_Terry McCombs20_tmccomb@SEDGWICK.GOV31_Fri, 16 Feb 2001 09:28:13 -0600363_iso-8859-1 From the DB2 side, the filter factor for a Decimal(3,0) is smaller than a Smallint, 1999 to over 60,000. That makes a difference if the column is being used in the WHERE clause.

From the Cobol side, smallint would usually be better, but as another poster stated, if the rest of the statement is using decimal fields, decimal may be better. [...] 9120 28 27_Re: DB2 v Oracle data space14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Fri, 16 Feb 2001 09:59:33 -0600389_iso-8859-1 It depends...

DB2 supports hardware compression of tablespace data before the page is formatted. Oracle does not.

However, many disk subsystems support compression of any type of data as it is written to the disk. Therefore, if the RAID box used by your Oracle subsystem supports compression, you may find you end up using much the same amount of disk space. [...] 9149 69 56_Re: CA's PRA Disaster Recovery product. Anyone using it?23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 16 Feb 2001 10:59:15 -0500615_- Richard,

I have used the product in 1998 at a client site to setup their DR procedure and successfully used it to recover. It worked great. But that was obviously a different version and almost 3 yrs ago.

HTH

Sanjay

> -----Original Message----- > From: Knight, Robert A. (Cameron of Pittsburgh at Alcoa) > [SMTP:Robert.Knight@ALCOA.COM] > Sent: Friday, February 16, 2001 9:18 AM > To: DB2-L@RYCI.COM > Subject: Re: CA's PRA Disaster Recovery product. Anyone using it? > > Sorry if this sounds biased but you should have > gotten BMC recovery manager. > > Bob Knight (NBC) Not the [...] 9219 41 56_Re: CA's PRA Disaster Recovery product. Anyone using it?20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Fri, 16 Feb 2001 11:11:38 EST324_US-ASCII Richard, I have no experience with CA's PRA product but for sample ISPF Panels on DR visit: http://www.recoveryknowledge.bigstep.com You can do a PARTIAL DR test at your Local site and verify the generated jobs JCL, RBA Numbers, and Utility Control cards before going to your Off-site DR.

Hope this help. Ed. 9261 65 20_Binding plans on UDB15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Fri, 16 Feb 2001 10:16:27 -0600755_us-ascii Free (deletes) old version of packages/plans and I hope you wont' have problem in freeing them.

---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 02/16/2001 10:11 AM ---------------------------



"Vernon, John" on 02/16/2001 09:17:43 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Mohammed Nayeem/MoMedicaid/US)

Subject: Binding plans on UDB





We have DB2 v5.1 on the mainframe (3 lpars, 3 subsystems) and 3 instances of DB2 on the UDB server side of life. We want to be able to utilize SPUFI and QMF from the mainframe to query the UDB instances. We keep running into what looks [...] 9327 21 24_Re: WITH UR and ORDER BY11_KATHY JONES26_JONESKS@GROUPWISE.CCSD.NET31_Fri, 16 Feb 2001 08:15:16 -0800494_US-ASCII I have the 3rd edition and it is Chapter 7 Program Preparation - Use Uncommitted Read with Caution.

Kathy Jones Central Information Services Clark County School District Senior Database Analyst 702-799-5040 x366 jonesks@GroupWise.ccsd.net

===============================================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. 9349 20 22_DB2 OS/390 V6. SQL-4300_25_Ed_Vetock@NAVYFEDERAL.ORG31_Fri, 16 Feb 2001 11:26:14 -0500462_us-ascii To all,

Ay idea how to resolve the -430 on execution of a Stored Procedure? We created SP, granted execute on SP, created package and granted appropriate permissions. Still no luck

Thanks

Ed

================================================ 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. 9370 50 52_Group By in embedded dynamic SQL with host variable?12_John Donahue28_john.donahue@DONOVANDATA.COM31_Fri, 16 Feb 2001 09:58:58 -0600553_- I am trying to impement a an embedded dynamic SQL query that includes a host variable on DB2 UDB 6.1/NT. But the bind for the declare cursor fails when i use a host variable. Example:

SELECT T1.COL1, T1.COL2, CASE WHEN T1.COL3 = 'X' THEN T1.COL4 ELSE 'Hide Value1' END, CASE WHEN T1.COL3 = 'X' THEN T2.COL2 ELSE 'Hide Value2' END, SUM(T1.COL5) FROM TABLE1 T1, TABLE T2 WHERE T1.COL3=T2.COL3 GROUP BY T1.COL1, T2.COL2, CASE WHEN T1.COL3 = 'X' THEN T1.COL4 ELSE 'Hide Value1' END, CASE WHEN T1.COL3 = 'X' THEN T2.COL2 ELSE 'Hide Value2' END [...] 9421 21 24_Re: Binding plans on UDB11_Rick Creech24_cfcreech@DUKE-ENERGY.COM31_Fri, 16 Feb 2001 11:12:47 -0500521_us-ascii I have done this by taking the bind cards for the spufi package and adding the location name as: PACKAGE (xxxxxxxx.DSNESPCS)

(You may have to delete some of the bind parms that are used on mvs but not supported on otyher platforms.)

HTH,

Rick Creech

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9443 131 36_Re: DB2 V6 tablespace Define=no Parm14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Feb 2001 16:28:27 -0000455_iso-8859-1 You need to look at the SPACE column in SYSTABLEPART or SYSINDEXPART. This is a pageset attribute as, in a partitioned tablespace, some defer defined partitions may be created whilst some others may NOT be (makes copying at the tablespace level tricky!!)

and "was the third party formerly called PLATINUM?", well yes it was (surprise) but it need not have been. IBM are the only ones who seem to be missing the point at the moment! [...] 9575 75 15_Re: COPY output27_Walls, Lucious (Contractor)20_TCI1@BUPERS.NAVY.MIL31_Fri, 16 Feb 2001 11:32:26 -0500561_iso-8859-1 Terry, I liked your suggestion to Smike on how to use an image copy of a table to load data into another table on a different DB2 subsystem. I attempted to do this in our DB2 test system. Since we don't have CA's(Platinum's) fast unload I must use the IBM DSN1COPY utility with XLAT...as suggested. We are a OS/390 V5 shop so I created a Global Temporary Table in data base DSNDB06 and tablespace SYSPKAGE. The problem I'm having is setting up the DSN1COPY JCL. I don't know what to use for the output data set name(SYSUT2). Isn't this normally [...] 9651 116 24_Re: Binding plans on UDB7_TSVANDR20_TSVANDR@LANDSEND.COM31_Fri, 16 Feb 2001 10:49:42 -0600412_iso-8859-1 John, This is what I had to do to get Spufi access from our mainframes to AIX databases. Tami Van Dreese Lands' End Inc







Note: This must be done for each OS390 subsystem/AIX database combination. This example sets up access from DB2D subsystem to the Texttst database on lexxxx01.

TCPIP.V3R2.ETC.SERVICES needs entry: # Lexxxx01 server db2cdb2inst1 50000/tcp [...] 9768 55 41_Subject: Re: Smallint/Integer vs. Decimal11_Long, James19_c-jlong@STATE.PA.US31_Fri, 16 Feb 2001 11:51:30 -0500620_iso-8859-1 Mike,

I agree with Terry and Scott.

We have been examining this question here for the last few weeks and this is what we came up with so far.

The question of binary (integer/small integer) vs. decimal (packed decimal) is really several questions. Does your machine process packed decimal fields as fast as binary fields? Some machines it matters, others it doesn't really. Remember that most binary arithmetic can be done in registers instead of memory. If the way you manipulate the fields involves both binary and packed decimal, then you should do either all one or all the other [...] 9824 100 15_Re: COPY output14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Feb 2001 17:07:02 -0000371_iso-8859-1 Lucious,

You cannot DSN1COPY into a global temporary table.

You can only use a "real" tablespace defined in a user database. Then the dataset name for SYSUT2 is clear (as you say)

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 9925 97 15_Re: COPY output13_Terry Shockey30_Terry.Shockey@OCSE.STATE.AR.US31_Fri, 16 Feb 2001 11:12:21 -0600434_iso-8859-1 Lucious, I'm glad you like the suggestion, however as you point out the DSN1COPY UTILITY works at the tablespace level(physical VSAM dataset level); no way around that. So for the suggestion to work you need to create a temporary tablespace first and then create a temporary table within the temporary tablespace then use the underlying VSAM dataset associated with the temporary tablespace for the SYSUT2 DD dataset. [...] 10023 115 24_Java Dynamic Sql and DB215_Berte, Patricia34_Patricia.Berte@CENDANTMOBILITY.COM31_Fri, 16 Feb 2001 12:26:18 -0500608_iso-8859-1 Hi,

We are testing an application that was developed in Java (JDBC). It uses DB2 Connect Version 6.1 fix pack 4 to access DB2 6.1 for OS/390 from Websphere 3.52 on NT 4.0.

We experiencing severe performance problems and need assistance. When a transaction is issued it doesn't return. When we look in the monitor it appears that the sql is being prepared repeatedly. The thread continually stays there in the 'PREPARE' state. The dynamic sql cache counts indicate 1 statement found and the statement not found count is, for example, 85k and increments as fast as you hit enter. [...] 10139 122 15_Re: COPY output14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Feb 2001 17:38:49 -0000391_iso-8859-1 I think we all need to be careful with the word "temporary". It didn't have a meaning within DB2, but now it does with Global Temporary Tables and Declared Temporary Tables

In the context of this eMail, temporary means a real (i.e. not temporary) table that has been created for one purpose (copying data from an image copy) and will be deleted when no longer needed. [...] 10262 19 26_Re: DB2 Version 6 SQLDSECT13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Fri, 16 Feb 2001 11:56:54 -0600297_US-ASCII Stan, I believe this has to do with the byte count for each variable defined in the application. After migrating to V6 assembler programs now show SQLDLEN of 44 bytes for each variable. Prior to V6 it was 12 bytes. A work around is to steplib to the V5 precompiler loadlib. HTH Kurt [...] 10282 42 0_10_Dave Detar29_dave.detar.cbnr@STATEFARM.COM31_Fri, 16 Feb 2001 11:59:12 -0600640_- Any idea why IBM doesn't dynamically allocate these in the same stogroup as the object being reorged. Or allow the user to specify a stogroup? -----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: Friday, February 09, 2001 2:20 AM To: DB2-L@RYCI.COM Subject: Re: on line reorg mapping table

Hi Chris, this is one of those questions that get discussed periodically, always starting from square one... to summarise: 1) The mapping table/TS is not an issue. No rows get inserted into the table (it's a "phantom" table). So use PRIQTY 720 SECQTY 720 for the TS. Put as many mapping tables in there [...] 10325 17 24_Re: Binding plans on UDB12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Fri, 16 Feb 2001 12:06:30 -0600441_iso-8859-1 My sincerest THANKS to all who helped, we now have SPUFI accessing and issuing SQL to the UDB side of life, and there are a lot of smiling faces here at TRS!!!

Warmest regards, 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. 10343 49 26_Re: DB2 OS/390 V6. SQL-43019_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Fri, 16 Feb 2001 12:14:50 -0600589_ISO-8859-1 Ed, see PQ31846 . . . it appears you might be missing a library in your STEPLIB concatenation for the SPAS address space . . .

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any [...] 10393 46 56_Re: CA's PRA Disaster Recovery product. Anyone using it?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 16 Feb 2001 18:23:04 -0000643_- we use it here and are 3 way datasharing ...

works fine .. some quirks ... but that is all

Leslie

-----Original Message----- From: Richard Pack [mailto:rpack1@MAIL.STATE.MO.US] Sent: Friday, February 16, 2001 1:34 PM To: DB2-L@RYCI.COM Subject: CA's PRA Disaster Recovery product. Anyone using it?



I have started setting up Disaster Recovery procedures using CA's PRA product. I have spent most of the week finding problems with the code it generates and have opened over a dozen issues with CA this week alone on this product. We are at the P99C RML level, SMP/E installed, with DB2 V6.1. Is anyone [...] 10440 62 56_Re: CA's PRA Disaster Recovery product. Anyone using it?14_Steve Westfall25_steve.westfall@AQUILA.NET31_Fri, 16 Feb 2001 12:30:55 -0600513_iso-8859-1 This was probably a few releases ago (1996 - 1998), but I used PRA on several occasions at my previous employer to recover in various situations, including after the loss of several entire DASD volumes. It was great. It analyzed everything correctly, generated good code, and there were no problems. On at least one occasion it enabled us to have everything back in place and running in time for the next morning's beginning of business day. That one case probably more than paid for the product. [...] 10503 70 24_Re: DB2 UDB v7.1 and ESS20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Fri, 16 Feb 2001 19:24:56 +0100440_windows-1252 Hi again, Sorry but maybe I get confused and the document I was speaking of isn't really a redbook but some sort of other IBM document; I hope I didn't make alot of people lose their time . However here is all the information I can give you : this is the link to the .pdf file of the book I had cited. The title is exactly that one, but strangely I couldn't find it on IBM site again... at the end I found it with google: [...] 10574 28 50_DB2 vs Oracle - another DB2 edge? [semi-off-topic]12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 16 Feb 2001 12:51:25 -0600329_us-ascii Hey there,

I note that Bill Clinton is going to speaking for Oracle soon. I wonder if any of the fallout, similar to that experienced by Morgan Stanley will help DB2 in the DB wars. I note that Paine Webber has already decided not to hire BC to speak at their upcoming NY conference. Will Oracle get burned? [...] 10603 98 56_Re: Group By in embedded dynamic SQL with host variable?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 16 Feb 2001 13:07:01 -0600526_iso-8859-1 John,

Try encapsulating the query within a Nested Table Expression (or even a Common Table Expression should do) with the GROUP BY external, such as:

SELECT A.COL1, A.COL2, A.GROUP3, A.GROUP4, SUM(A.COL5) FROM ( SELECT T1.COL1, T1.COL2, CASE WHEN T1.COL3 = :X_Filter THEN T1.COL4 ELSE 'Hide Value1' END AS GROUP3, CASE WHEN T1.COL3 = :X_Filter THEN T2.COL2 ELSE 'Hide Value2' END AS GROUP4, T1.COL5 FROM TABLE1 T1, TABLE T2 WHERE T1.COL3=T2.COL3) AS A GROUP BY A.COL1, A.COL2, A.GROUP3, A.GROUP4 [...] 10702 44 54_Re: DB2 vs Oracle - another DB2 edge? [semi-off-topic]15_Visser, Michael11_mjv@HNC.COM31_Fri, 16 Feb 2001 11:13:12 -0800593_iso-8859-1 Bill who? Who gives a rat's ass?!

-----Original Message----- From: Steve Grimes [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Friday, February 16, 2001 10:51 AM To: DB2-L@RYCI.COM Subject: DB2 vs Oracle - another DB2 edge? [semi-off-topic]



Hey there,

I note that Bill Clinton is going to speaking for Oracle soon. I wonder if any of the fallout, similar to that experienced by Morgan Stanley will help DB2 in the DB wars. I note that Paine Webber has already decided not to hire BC to speak at their upcoming NY conference. Will Oracle get burned? [...] 10747 54 46_WHY??? should have gotten BMC recovery manager5_chris22_hhardy1@HOUSTON.RR.COM31_Fri, 16 Feb 2001 13:27:47 -0800719_iso-8859-1 Bob, help us out here.... Why should they have gotten BMC recovery manager?????

----- Original Message ----- From: "Knight, Robert A. (Cameron of Pittsburgh at Alcoa)" Newsgroups: bit.listserv.db2-l To: Sent: Friday, February 16, 2001 6:18 AM Subject: Re: CA's PRA Disaster Recovery product. Anyone using it?



> Sorry if this sounds biased but you should have > gotten BMC recovery manager. > > Bob Knight (NBC) Not the Basketball Coach > > -----Original Message----- > From: Richard Pack [mailto:rpack1@MAIL.STATE.MO.US] > Sent: Friday, February 16, 2001 8:34 AM > To: DB2-L@RYCI.COM > Subject: CA's PRA Disaster Recovery product. Anyone [...] 10802 150 35_Re: Clustered Indexes in UDB/AIX V611_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Fri, 16 Feb 2001 14:15:32 -0500370_us-ascii Jim,

Using clustering indexes to avoid sorts could pay off hugely for you, but you'll want to be sure to create the right clustering indexes. Of course, the trick is determining the "right indexes". The payoff from your efforts could make the difference in your application's ability to scale, or even deliver ongoing satisfactory business results. [...] 10953 30 26_admin client install error11_Gary Martin22_Gary_Martin@BCBSME.COM31_Fri, 16 Feb 2001 14:15:44 -0500394_us-ascii Hello listers, I've begun upgrading our Win98 runtime client from v6 FP3F to v6 FP5. The runtime client upgrade is fine. In order to run binds for: DDCSMVS, DB2CLI & DB2UBIND, I've attempted to install the v6 admin client. I have two questions: 1. Should I be concerned that the runtime is at WR21202 and the admin client is at WR21223 ? Will I be binding with the correct files? [...] 10984 58 0_0_18_mebert@AMADEUS.NET31_Fri, 16 Feb 2001 20:23:41 +0100393_us-ascii I'm not sure what you mean with "these" - if you refer to mapping table & -index, except for the "phantom" feature they're normal DB2 tables, so you can specify a STOGROUP; and you have to create them yourself as with any other database object. IBM probably could have created a special dynamic allocation mapping index, but why bother, if they can reuse existing SQL machinery? [...] 11043 66 3_Re:14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 16 Feb 2001 19:38:43 -0000773_iso-8859-1 or even use virtual storage/dataspaces or some other non-DASD alternative.....................

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com



-----Original Message----- From: Dave Detar [mailto:dave.detar.cbnr@STATEFARM.COM] Sent: 16 February 2001 17:59 To: DB2-L@RYCI.COM Subject: [DB2-L]



Any idea why IBM doesn't dynamically allocate these in the same stogroup as the object being reorged. Or allow the user to specify a stogroup? -----Original Message----- From: mebert@AMADEUS.NET [mailto:mebert@AMADEUS.NET] Sent: Friday, February 09, 2001 2:20 AM To: DB2-L@RYCI.COM Subject: Re: on line reorg mapping table [...] 11110 152 15_Re: COPY output27_Walls, Lucious (Contractor)20_TCI1@BUPERS.NAVY.MIL31_Fri, 16 Feb 2001 14:57:01 -0500357_iso-8859-1 Thanks Terry, Phil, Vincent.... for the clarification on "temporary" tables. I now know that when someone mentions a temporary table they are really referring to a real table created temporarily for a specific purpose. Unless of course they explicitly state that they are referring to a Global Temporary Table or a Declared Temporary Table. [...] 11263 12 56_Re: Group By in embedded dynamic SQL with host variable?12_John Donahue28_john.donahue@DONOVANDATA.COM31_Fri, 16 Feb 2001 14:05:54 -0600305_- This solved the problem, Thank you for the help.

-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. 11276 20 33_Easy Way to Compare Table Defs ??14_Linda Campbell30_Linda_Campbell@NEWYORKLIFE.COM31_Fri, 16 Feb 2001 17:13:36 -0500553_us-ascii I am new to this list and relatively new to DB2, although I've been an IDMS DBA for many years. We've got a situation here where there are multiple databases whose table definitions are supposed to match. However, we picked this up in a rather disorganized state and need to know what we've got. So, I'm looking for an easy way to compare the table definitions of the same table in different databases. There are hundreds of tables, so eyeballing isn't my first choice. We've got Platinum and not much else. Any and all ideas are welcome. [...] 11297 15 21_Detecting dirty reads12_Jim Harrison12_jimh@QIS.NET31_Fri, 16 Feb 2001 17:35:29 -0500436_us-ascii Here's a question I got today: When reading a table using isolation=UR, is there any way to determine when you land on a dirty page/row? Some obscure field or value buried in the SQLCA?

================================================ 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. 11313 38 37_Re: Easy Way to Compare Table Defs ??16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Fri, 16 Feb 2001 23:03:09 -0000317_- Linda - since you've got PLATINUM, see if RC/Migrator exists on the menu. If thats the case, you can use a Compare strategy to compare entire DB2-subsystems. Use MASKS to map source/target objects in case naming conventions are different. Go ahead and contact me off the server if you need further assistance. [...] 11352 29 10_website...8_ritu zee22_ritu_98_2000@YAHOO.COM31_Fri, 16 Feb 2001 15:19:17 -0800315_us-ascii Hi !

IBM has all it's 'manuals' available on the internet. Similarly, is there a site on the internet where I can read IBM redbooks? The site www.redbooks.ibm.com only has a 'list' of redbooks and an introduction into the contents of the redbooks but they are not available for online reading. [...] 11382 37 0_13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 16 Feb 2001 21:06:21 -0500389_- Dear DB2 Listers, I'm a little bafled..I want to add a new RI to existing tables but could not because of the following DB2 warning:

DSNT404I SQLCODE = 541, WARNING: THE REFERENTIAL OR UNIQUE CONSTRAINT CNMTLF1 HAS BEEN IGNORED BECAUSE IT IS A DUPLICATE.

ALTER TABLE DBTEST.CFF01MST FOREIGN KEY CFF01FK0 (CFF01_MSTR_ID ) REFERENCES DBTEST.CFF01ORD ON DELETE RESTRICT; [...] 11420 33 22_SQLCODE 541 irritation13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Fri, 16 Feb 2001 21:51:08 -0500384_- Dear DB2 Listers, I'm a little bafled..I want to add a new RI to existing tables (ALTER TABLE DBTEST.CFF01MST FOREIGN KEY CFF01FK0 (CFF01_MSTR_ID ) REFERENCES DBTEST.CFF01ORD ON DELETE RESTRICT;) but could not because of the following DB2 warning:

DSNT404I SQLCODE = 541, WARNING: THE REFERENTIAL OR UNIQUE CONSTRAINT CNMTLF1 HAS BEEN IGNORED BECAUSE IT IS A DUPLICATE. [...] 11454 22 46_WHY??? should have gotten BMC recovery manager12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 17 Feb 2001 10:39:45 +0200492_iso-8859-1 Hi,

With all due respect to all 3rd party suppliers - please don't start that kind of war in the list, we've had enough of that in the past.



Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.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. 11477 36 26_Re: DB2 Version 6 SQLDSECT12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 14:06:38 -0600537_- This is in the book, Installation Guide, chapter 2-7 under Make Adjustments for Release Incompatibilities, from an IBMer to an ex-IBMer.

"Because of the additional data types supported in Version 6,the host language statements generated by the precompiler for each SQL statement include a larger parameter list.As a result,the size of the object code that results from compiling the output of the precompiler increases. This increase varies according to the number of host variables that are specified in an SQL statement. [...] 11514 14 25_Re: Detecting dirty reads12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 14:11:25 -0600504_- Dirty read turns off the checking, so there is no way to know. If you can't handle the situation, try cursor stability currentdata no, which will be very close in performance, but won't hand you uncommitted changes.

Roger Miller, DB2 for OS/390 and z/OS

================================================ 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. 11529 25 18_Re: Other DB2 Time12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 14:31:38 -0600522_- Other DB2 time is outside of what we can chase down in DB2 - cpu time, various class 3 times like IO times, locking latching, ... The essence of the problem is generally outside of DB2 too. Here are a couple of thoughts.

CPU wait: If the cpu is busy 90% of the time for a single processor with exponential arrivals, then the queuing theory says that the time waiting for the cpu is about 8 times the cpu time. If you are running at 99%, then the cpu wait would be 98 times the cpu time. Multiprocessors do a [...] 11555 15 29_Re: SQL -20100 - TRIGGER BIND12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 14:42:17 -0600524_- That confuses me too. The -20100 is returning the original -104, but the SQLSTATE code 42601 is one we use for an illegal character. Could there be an unprintable character in there or a character translation glitch in the underscores?

Roger Miller, DB2 for OS/390 and z/OS

================================================ 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. 11571 86 11_Re: logging12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 16:00:18 -0600298_- It sounds as though it's time to dig out my soapbox script again. Here are some opinions from a VIP (Very opInionated Person). I don't have time to be super careful, so please excuse me. We have options to turn off logging when we don't compromise data and subsystem integrity. They include [...] 11658 25 14_Re: website...12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 17 Feb 2001 16:18:04 -0600414_- The red books are out there for reading online or downloading. I can't tell you all the techniques, but here is mine.

ibm.com/redbooks

Then type a subject, like DB2 or a specific book number into the Search field at the top left and click Go. I tried DB2 and got 216 results for the books, and 17 residencies to write new books. With that many, you may need to search for a word in the title. [...] 11684 15 21_U3042 - code 0506002016_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Sat, 17 Feb 2001 18:15:18 -0500331_us-ascii Hi, has anyone seen this in a v 6.1 os/390 environment. any help appreciated 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. 11700 143 11_Re: logging12_Kent Collins15_kcollins@WF.NET31_Sat, 17 Feb 2001 17:37:05 -0600315_iso-8859-1 I agree completely for the OS/390(Mainframe) world. I found that looking for example at logging as a performance bottleneck in most situations was a waste of time since there are other more likely sources of improvements to be made. Then I considered the liability and the decision was made for me. [...] 11844 55 41_DB2 Symposium St Louis - 200$ per Session12_Susan Lawson24_susan_lawson@YLASSOC.COM31_Sat, 17 Feb 2001 09:53:43 -0600342_iso-8859-1 YLA (Yevich, Lawson and Associates, Inc.) is offering their 3-day DB2 Symposium in St Louis, Mo on April 9-11. All sessions are priced at $200 per student, per session - each of which is a full day!

All attendees will also receive a free copy of Volume 1.1 of the "DB2 Performance Journal" and a free DB2 UDB trial CD. [...] 11900 82 26_NT/ UDB 7.1 - Backup times14_David Bargeron29_David.Bargeron@BTINTERNET.COM31_Sun, 18 Feb 2001 21:24:44 -0000282_iso-8859-1 Hi Listers,

We will be running UDB v7.1 on NT with TSM as the backup manager to magstar x 2 tape drives (fibre connected), database of around 300 Gb on SSA with LOBs. Our site is new to UDB on NT and are about to run some benchmarks for database backups etc. [...] 11983 53 37_Re: Easy Way to Compare Table Defs ??12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Mon, 19 Feb 2001 08:51:39 +1100392_- Linda, I caught the tail end of this. If you don't have the Platinum functionality to do this give me a shout. I've got a JCL deck that extracts catalogue table and then will "SuperC" compare the 2 environments. You'll need to hack and slash the JCL to fit, but it keeps me happy, if I'm working at a site that doesn't have a lot of tools. If I ever get the time I'll "REXX"ercise it. [...] 12037 69 31_Re: Smallint/Integer vs Decimal12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Mon, 19 Feb 2001 09:07:49 +1100507_- I would have thought that INT / SMALLINT would have had better performance. Even in Cobol?

I am certainly of the view that if it can be an INT / SMALLINT then "make it so"! A couple of reasons why from a DB2 perspective (for me ) would be: * you can save a byte in each case, which potentially means more data on a page and less I/O ( I know I'm splitting hairs) * ... and (although I'm not sure it's still an accurate statement to say) I was brought up being told that a word (4-bytes) based [...] 12107 86 28_Re: sqlcode -541 (was blank)14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 19 Feb 2001 10:09:44 +1100413_iso-8859-1 Carlton

I think the sqlcode might be saying that you already have this RI defined - albeit with a different name. try:

select * from sysibm.sysrels rel, sysibm.sysforeignkeys fk where rel.creator = 'DBTEST' and rel.tbname = 'CFF01MST' and rel.reftbcreator = 'DBTEST' and rel.reftbname = 'CFF01ORD' and fk.creator = rel.creator and fk.tbname = rel.tbname and fk.relname = rel.relname [...] 12194 91 24_Re: WITH UR and ORDER BY14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 19 Feb 2001 10:09:47 +1100466_iso-8859-1 My recollection is that this was raised here some time ago. The explanation was that if DB2 decides to use an index to satisfy the ORDER BY requirement and between the time the index was used to get the RID of a row and the time the row was actually fetched, the value of the of the ordered columns changed, then it was possible that the original ordering (ie based on the index) would be used, however the data would be the data in the fetched row. [...] 12286 64 14_Re: website...14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 19 Feb 2001 10:09:50 +1100704_iso-8859-1 You have to register (bottom item on the left hand side) to be able to read them.

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

-----Original Message----- From: ritu zee [mailto:ritu_98_2000@YAHOO.COM] Sent: Saturday, February 17, 2001 10:19 AM To: DB2-L@RYCI.COM Subject: [DB2-L] website...



Hi !

IBM has all it's 'manuals' available on the internet. Similarly, is there a site on the internet where I can read IBM redbooks? The site www.redbooks.ibm.com only has a 'list' of redbooks and an introduction into the contents of the redbooks but they are not available for online [...] 12351 75 38_Re: Executing stored procedure from VB8_LAM, Leo17_l.lam@IOOF.COM.AU31_Mon, 19 Feb 2001 10:30:01 +1000462_ISO-8859-1 Kals,

We got the same SQLSTATE when trying to invoke a DB2 V6 OS/390 SP from VB via DB2 Connect 5.2 FP14. We get around the problem after changing an IN parameter to INOUT. We didn't have the problem at FP13 or earlier.

Hope this helps

Leo

-----Original Message----- From: teldb2kals [mailto:teldb2kals@TELSTRA.COM] Sent: Thursday, 15 February 2001 17:17 To: DB2-L@RYCI.COM Subject: Executing stored procedure from VB [...] 12427 37 37_Online Reorg / Batch Memory Execution11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Sun, 18 Feb 2001 18:11:24 -0600426_iso-8859-1 Hi All,

Can someone help me to understand what is happening ? When I do online reorg for big tables the utility abends and the abend message and what I see in the log both I am enclosing.

Thanks.

Amit

414-931-4815



DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCE DSNU016I DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'0000' [...] 12465 50 25_Re: U3042 - code 0506002014_James Campbell29_James.Campbell@HANCORP.COM.AU31_Mon, 19 Feb 2001 11:19:09 +1100464_iso-8859-1 It is unlikely that this a db2 or system abend. It is probably generated by your run-time environment. (eg IMS or something similar)

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

-----Original Message----- From: Thomas E. Faglon [mailto:tfaglon@TELCORDIA.COM] Sent: Sunday, February 18, 2001 10:15 AM To: DB2-L@RYCI.COM Subject: [DB2-L] U3042 - code 05060020 [...] 12516 93 38_Re: Executing stored procedure from VB10_teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 19 Feb 2001 18:05:58 +1000423_ISO-8859-1 Hi all,

Thanx for ur inputs. I did run thru the trace, but found lots of confusing results which are too many to list here.

But, yes, I was finally successful in running the SP from my schema name, specifying 'CURRENTFUNCTIONPATH=mychema,SYSIBM,SYSPROC,SYSFUN' in my connection string.

ADO objects apparently handle Connects in a much different way than my simple direct CLI functions. [...] 12610 68 21_Re: logging - Why ???10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 19 Feb 2001 10:12:03 +0100592_us-ascii Hi Mr. Miller

I read with interest your reply, but I'm wondering why, if there are some requirements for disable logging, someone asks 'Why I have to improve the capability to turn logging off ? - They are wrong - dot.". It seems to me that is the usual distinction between who develops the product (and knows that product verrrry well) and who works with it (and knows the product not so well), a thing I often noted during some IBM's seminars, expecially in DB2 developers (people working in other departments, for instance in storage department, are more flexible). A [...] 12679 33 31_Re: Smallint/Integer vs Decimal14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Mon, 19 Feb 2001 04:06:18 -0600576_iso-8859-1 The point about COBOL performance also has the standard answer: It depends...

If the operands of a calculation are of different data types, COBOL has to convert them to the same data type before stating the calculation. In most cases, the data type of the result field is the model that is used for the remaining operands. The precision and scale of operands is not normally important, but the data type (integer, decimal, float, char, etc,) is. The exact rules of when a conversion is done are given in the COBOL LRM. Make sure you use the LRM for the [...] 12713 19 12_pumping data12_Rakesh Kumar21_rakesh457@HOTMAIL.COM31_Mon, 19 Feb 2001 12:11:08 -0000562_- All, How can I pump data from Lotus Notes to DB2 .I heard there is a utility called Lotus Pump.Could anyone elaborate on it or how is it done.

Regards Rakesh Kumar _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12733 21 26_Re: SQLCODE 541 irritation15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Mon, 19 Feb 2001 06:40:10 -0600399_- I don't know, what you haved look up, but the warning message tells, that there is already a connection between those two tables using taht columns a the foreign key. Have you looked up, if there is any row for those two tables in SYSRELS Following SQL:

SELECT * from sysibm.sysrels where CREATOR = 'DBTEST' and NAME = 'CFF01MST' and REFTBCREATOR = 'DBTEST' and REFTBNAME = 'CFF01ORD' [...] 12755 24 25_Re: U3042 - code 0506002013_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Mon, 19 Feb 2001 08:04:53 -0500314_iso-8859-1 Hello Thomas, I recall from many years ago that U3042 is an IMS user abend.

We used to get it in a development environment when a subordinate region, DLI or BMP, tried accessing DB2 but didn't have a proper DB2 environment -- I think the dd statement DFSESL for the DB2 loadlib was missing. [...] 12780 43 16_Re: pumping data16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 19 Feb 2001 08:10:04 -0500521_us-ascii Try this site its called SQLPUMP http://datamirror.com/products/sqlpump/ HTH ToM







Rakesh Kumar on 02/19/2001 07:11:08 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: pumping data







All, How can I pump data from Lotus Notes to DB2 .I heard there is a utility called Lotus Pump.Could anyone elaborate on it or how is it done. [...] 12824 51 31_Re: U3042 - code 05060020 fixed16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Mon, 19 Feb 2001 08:20:44 -0500432_us-ascii Dave,

That's what it was .The performance group was running with their own msg regions- this was an IMS/DB2 datasharing environment and they did not have their parms set up correctly.and could not connect to the correct DB2 thanks Tom F







"Seibert, Dave" on 02/19/2001 08:04:53 AM

Please respond to DB2 Data Base Discussion List [...] 12876 240 37_CONTROL CENTER on WIN98 Java problems12_Troy Coleman19_Colematr@MEIJER.COM31_Mon, 19 Feb 2001 11:21:16 -0500538_US-ASCII Hello List, Thank you everyone for your response. Unfortunately WIN98 seems to be a problem platform. I run this install on win95 and NT without any problems. Well I have a good IBM friend who sent me a fix that got me going. I'm including below the text that was sent to me. I tried all the steps and did not get the Control Center working until I tried the last option. Expand the Java Class Library using db2classes.exe. I now get the Control Center, however I have a new error that I am not worried about at this moment [...] 13117 158 29_Re: SQL -20100 - TRIGGER BIND12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Mon, 19 Feb 2001 10:27:38 -0600517_iso-8859-1 Hello James, Yes, I have verified the string delimiter and it is an apostrophe. I believe this problem to be environmental and have opened an issue with IBM. I will post the resolution when one comes.

I have been able to create a trigger to 'SIGNAL SQLSTATE' successfully. This trigger (listed below) did fire on update and issue the error code and message just as I expected. It appears only when I reference a transition variable from the 'REFERENCING NEW AS' clause do I receive the errors. [...] 13276 34 11_DB2 Editors30_Newnham, Richard R SSI-ISES-4230_Richard.R.Newnham@IS.SHELL.COM31_Mon, 19 Feb 2001 17:19:48 +0100438_iso-8859-1 Hi,

I wonder if anyone can tell me what other DB2 Data Editors there are on the market.

We are aware of ProEdit, FileAid/DB2 and Insync/DB2, but would like to know if there are any more of these products available so we could do a full trial. I don't want to start a discussion about which ones are better than which. We will do our trials here to ascertain this. I would just like to know which ones exist. [...] 13311 12 15_Re: DB2 Editors11_Rick Creech24_cfcreech@DUKE-ENERGY.COM31_Mon, 19 Feb 2001 11:36:20 -0500288_us-ascii Princeton Softech has Access for DB2.

================================================ 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. 13324 47 15_Re: DB2 Editors16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Mon, 19 Feb 2001 16:56:18 -0000588_- Richard -

You mentioned ProEdit - it has been replaced with RC/Edit within RC/Update - ex-PLATINUM now CA-tool.

> -----Original Message----- > From: Newnham, Richard R SSI-ISES-42 [SMTP:Richard.R.Newnham@IS.SHELL.COM] > Sent: Monday, February 19, 2001 5:20 PM > To: DB2-L@RYCI.COM > Subject: DB2 Editors > > Hi, > > I wonder if anyone can tell me what other DB2 Data Editors there are on the > market. > > We are aware of ProEdit, FileAid/DB2 and Insync/DB2, but would like to know > if there are any more of these products available so we could do a full > trial. > [...] 13372 50 15_Re: DB2 Editors10_john clark20_pak02449@PIXIE.CO.ZA31_Mon, 19 Feb 2001 19:49:03 +0530588_us-ascii Have a look at HOST/Edit from Relational Architects

www.relarc.com



Regards



john Clark

"Newnham, Richard R SSI-ISES-42" wrote:

> Hi, > > I wonder if anyone can tell me what other DB2 Data Editors there are on the > market. > > We are aware of ProEdit, FileAid/DB2 and Insync/DB2, but would like to know > if there are any more of these products available so we could do a full > trial. > I don't want to start a discussion about which ones are better than which. > We will do our trials here to ascertain this. I would just [...] 13423 19 19_DB2 monitor for AIX13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Mon, 19 Feb 2001 11:51:18 -0600464_us-ascii I'm looking for a good DB2 monitor for DB2 6.1 on AIX. Can anyone give any suggestions? I know that Database Guys has one as does Quest Software. Does anyone know of any others?

Thanks,

Helen Johnson

================================================ 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. 13443 20 23_Re: DB2 monitor for AIX18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM31_Mon, 19 Feb 2001 13:27:31 -0500398_us-ascii haven't tried it, but it looks interesting.

look at http://sqlpower.com





Richard McCutcheon, DBA, Honda of Canada Mfg.

================================================ 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. 13464 36 23_Re: DB2 monitor for AIX5_chris22_hhardy1@HOUSTON.RR.COM31_Mon, 19 Feb 2001 12:33:46 -0800717_iso-8859-1 CA has ManageIT Performance...... It will monitor dB & OS....





----- Original Message ----- From: "Helen Johnson" Newsgroups: bit.listserv.db2-l To: Sent: Monday, February 19, 2001 9:51 AM Subject: DB2 monitor for AIX



> I'm looking for a good DB2 monitor for DB2 6.1 on AIX. Can anyone > give any suggestions? I know that Database Guys has one as does Quest > Software. Does anyone know of any others? > > Thanks, > > Helen Johnson > > ================================================ > To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners [...] 13501 80 13_Re: 105% CPU?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 19 Feb 2001 13:34:22 -0500466_iso-8859-1 100% utilized + an average of 5 tasks ready and not being dispatched.



regards,

eric pearson NS ITO Database Support

-----Original Message----- From: Kwan, James [mailto:James_Kwan@BMC.COM] Sent: Thursday, February 15, 2001 5:51 PM To: DB2-L@RYCI.COM Subject: 105% CPU?



Can someone tell me the meaning if cpu reading is over 100% in SDSF? We have a little disagreement here and I can't find it in any book. [...] 13582 13 15_Re: DB2 Editors11_Mark Harmon17_mhinnyc@YAHOO.COM31_Mon, 19 Feb 2001 12:49:01 -0600403_- The direct URL for Host/Edit from Relational Architects is http://www.relarc.com/edit390.htm

Their web site navigation is not as obvious as it could be.

================================================ 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. 13596 42 23_Re: DB2 monitor for AIX15_Stacey L Waters23_waterss1@NATIONWIDE.COM31_Mon, 19 Feb 2001 14:29:57 -0600618_us-ascii BMC and IBM have tools also.







Helen Johnson @RYCI.COM> on 02/19/2001 11:51:18 AM

From: Helen Johnson @RYCI.COM on 02/19/2001 11:51 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: Subject: DB2 monitor for AIX

I'm looking for a good DB2 monitor for DB2 6.1 on AIX. Can anyone give any suggestions? I know that Database Guys has one as does Quest Software. Does anyone know of any others? [...] 13639 98 20_Help Needed A.S.A.P.11_Endy Lambey27_endyl@MITRAINFOSARANA.CO.ID31_Tue, 20 Feb 2001 04:19:07 +0700296_ISO-8859-1 Dear all,

I am having a trouble on connecting DB2 Connect PE to DB2 on AS/400. We have a AS/400 machine with DB2 Ver.4 Release 4. I have setup the connection from the DB2 Connect to the AS/400 with PCOM. But everytime I tried to test the connection, the same error occur : [...] 13738 18 23_Re: DB2 monitor for AIX14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Mon, 19 Feb 2001 16:19:32 -0500331_ISO-8859-1 Look at Database gys software.

www.database-guys.com

Regards, Joel

===============================================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. 13757 22 34_Re: Compact Data for Archive Logs?11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Mon, 19 Feb 2001 15:11:34 -0600561_- James Campbell, please respond with the results of your testing. I'm interested in your results.

We recently expanded the size of our active logs. We went from 800 cyliners to 1600. We have our active logs going to VTS. The tapes started to span two volumes. We elected to turn on compaction in DSNZPARM. This was wonderful to get back down to one volume. However, our DR copies are on 3490 tapes. They stayed at two volumes. All our DR procedures are setup to deal with one copy, not two. We are now considering putting these 3490 DR copies back [...] 13780 35 34_Re: Compact Data for Archive Logs?20_Edward C. Benoit Jr.19_DB2Automate@AOL.COM29_Mon, 19 Feb 2001 17:24:31 EST113_US-ASCII Hi Ruth, What utility do you use to create your DR copies of the Archive Logs?

Ed



13816 36 24_PACKAGE GETPAGE QUESTION16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Mon, 19 Feb 2001 14:39:32 -0700612_us-ascii DB2ers,

I had a question regarding the number of getpages accessed by the first statement within a package during plan invocation. In viewing the average number of getpages for the offending statement using BMC's apptune, it seemed fairly large (over 30). The statement is performing index-only access to return the data and resolve the predicate using 4 matching columns within the predicate. The index has been defined as non-unique and in our test environment consists only of the root page and 1 leaf page. At most, I would expect to see only 2 getpages for the statement. In running an [...] 13853 64 34_Re: Compact Data for Archive Logs?14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 20 Feb 2001 10:07:37 +1100374_iso-8859-1 Ruth,

All the testing I've done was done many (8 or 9?) years ago. I no longer (surprise, surprise) have any copy of any results. I decided then it was a "good thing" and nothing has happened to change my mind.

YMMV

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...] 13918 55 15_Re: DB2 Editors14_Michael Finnis28_MFinnis@PRINCETONSOFTECH.COM31_Mon, 19 Feb 2001 18:15:52 -0500718_ISO-8859-1 Richard,

Take a look at Access for DB2 from Princeton Softech... http://www.princetonsoftech.com/accessfordb2

Mike. Princeton Softech

-----Original Message----- From: Newnham, Richard R SSI-ISES-42 [mailto:Richard.R.Newnham@IS.SHELL.COM] Sent: Tuesday, February 20, 2001 2:50 AM To: DB2-L@RYCI.COM Subject: DB2 Editors



Hi,

I wonder if anyone can tell me what other DB2 Data Editors there are on the market.

We are aware of ProEdit, FileAid/DB2 and Insync/DB2, but would like to know if there are any more of these products available so we could do a full trial. I don't want to start a discussion about which ones are better than which. We will do our [...] 13974 19 6_DSSIZE0_20_bjnigh@HOUSEHOLD.COM31_Mon, 19 Feb 2001 15:23:11 -0800356_us-ascii Has anyone used the DSSIZE option on CREATE TABLESPACE? We are recreating a tablespace that has reached the 4 gig limit but I could not find any examples in the DB2 Version 6 manual. If I specify 64G and I don't need that much does it cause any problems? I am recreating a 64-partition tablespace and want to never have to recreate it again. [...] 13994 53 10_Re: DSSIZE15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 20 Feb 2001 10:48:35 +1100520_- Sure have. I've got a 9-partition tablespace with DSSIZE 32G. One partition went to around 13Gb no probs. Check the archives for DSSIZE 'cause I wrote a general 'eyes up' about it a few weeks ago. Basically if you stick with the IBM utilities you should be fine. If you use BMC's utilities and you a) don't go over 4Gb, but b) you want more space than is on a volume, you'll be in trouble. LoadPlus won't ask SMS to add a volume to the cluster definition. So if you fill the volume your cluster is on, that's it. [...] 14048 157 16_DB2/6000 problem18_Yosia Widi Nugroho20_yosia@CENTRIN.NET.ID31_Tue, 20 Feb 2001 10:30:47 +0700513_iso-8859-1 Dear all,

My friend, Tomy (tomyws@mitrainfosarana.co.id), has a problem with DB2/6000. Actually, this is his first experience with DB2/6000. Does anybody can help him? You can contact him directly to his e-mail address stated above, or via my e-mail address.

Thanks, Yosia

-----Original Message----- From: Tomy Widhartomo S [mailto:tomyws@mitrainfosarana.co.id] Sent: Monday, February 19, 2001 4:58 PM To: yosia@centrin.net.id Subject: Dari Tomy... minta tolong ASAP :) TIA.. [...] 14206 85 28_Re: PACKAGE GETPAGE QUESTION16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 20 Feb 2001 10:36:42 +0530441_- Hi Jeff,

As we know, DB2 loads the plan/package in EDM pool (if it is not there) for execution. It is either loaded from SCT02 or SPT01 for plan or package respectively. The other things loaded are DBD for the databases which are accessed, the PACKAUTH/PLANAUTH, USERAUTH and RESAUTH catalog tables to validate the authrization for the user executing this plan. These all required getpages to corresponding tablespaces/tables. [...] 14292 16 41_Paul H Bohannon/msi is out of the office.20_Paul H. Bohannon Jr.21_PBohannon@MSIINET.COM31_Tue, 20 Feb 2001 01:00:49 -0600480_us-ascii I will be out of the office starting 02/19/2001 and will not return until 03/05/2001.

I will be out of the office 02/19/01 until 03/05/01 I will be checking my mail periodically and will return your email as soon as I can.

================================================ 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. 14309 59 0_10_Wim Ruarus18_w.h.ruarus@KPN.COM31_Tue, 20 Feb 2001 09:04:31 +0100539_iso-8859-1 Carlton,

this SQLcode doesn't say there exists a constraint with the same name, it says that the constraint you are trying to define already exists with another name.

Regards,

Wim Ruarus.

-----Oorspronkelijk bericht----- Van: Carlton Enuda [mailto:carltonenuda@HOTMAIL.COM] Verzonden: zaterdag 17 februari 2001 3:06 Aan: DB2-L@RYCI.COM Onderwerp:



Dear DB2 Listers, I'm a little bafled..I want to add a new RI to existing tables but could not because of the following DB2 warning: [...] 14369 119 11_DB2 Editors30_CHRISTOPHER.KELLER@Vereinte.de30_CHRISTOPHER.KELLER@VEREINTE.DE31_Tue, 20 Feb 2001 09:11:00 +0100591_iso-8859-1 --- Erhalten von BG1.KELLERC 6785-2761 20-02-01 09.11 --------------------------------------------------------------------------------------------------------------

-> db2-l@ryci.com

Hello, here collection, dated: Regards, Chris

1. Princeton Softech Access for DB2 is a relational DB2 data editor that interfaces very nicely with BMC Catalog Manager. Here's the product's web address: http://www.princetonsoftech.com/index.asp

2. Compuware FileAid

3. CA/Platinum's RC/Update.

4. CA ProEdit (see below, will not be further developed) [...] 14489 24 28_Accessing XBASIC Arabic data14_Tariq Maghrabi19_stariq@KFUPM.EDU.SA31_Mon, 19 Feb 2001 11:09:10 +0300327_iso-8859-1 Hello, We are currently Using DB2 Client Application Enabler with Windows 2000. The DB2 Connect version which is currently installed on our machines is 5.2 . We are looking for an ODBC driver that supports accessing and manipulating Arabic XBASIC format data stored on DB2 from Windows 2000 based applications. [...] 14514 44 14_Re: Cold Start14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Tue, 20 Feb 2001 04:01:28 -0600511_iso-8859-1 UGHH! DR with no BSDS or logs...

I think you may have trouble doing a reliable DR. My understanding is that the details of the most recent image copy of SYSCOPY (and SYSUTILX) are held on the log file, not in SYSCOPY.

Obvious when you think about it... how do you register that you have just made a successful backup of SYSCOPY without updating SYSCOPY. If you update SYSCOPY then there are updates since the last backup, so you need a new backup to include those details, etc...) [...] 14559 25 46_Off Topic Post - OS390 JCL Flowchart Generator13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 20 Feb 2001 06:27:13 -0600442_iso-8859-1 Pardon the off topic post.

We are relatively new to OS390 and DB2. Our programming staff is looking for a software product (mainframe and/or PC) that will read OS390 JCL and generate flowcharts of system flow.

I would appreciate any suggestions.

Thanks,

Scott Hodgin, Database Administrator South Carolina Farm Bureau Insurance Company Phone: (803) 936-4311 Fax: (803) 936-4629 shodgin@scfbins.com [...] 14585 28 22_DB2 Version 6 SQLDSECT9_Stan Hoey24_stan_hoey@CIRCLE-DL2.COM31_Tue, 20 Feb 2001 13:03:40 -0000490_us-ascii I'll try this one again - is there an IBM'er that can shed any light on this? > >I think that this may be a question for you IBM guys. > >APAR PQ32839 describes a change in DB2 Version 6 affecting SQLAVARS and SQLPVARS, and the effect of this change for IMS/ADF >users. Can anyone shed any light on what is behind this change, and whether there is the possibility to revert to these structures as they were >defined in releases of DB2 prior to Version 6. > >Thanks >Stan Hoey [...] 14614 45 50_Re: Off Topic Post - OS390 JCL Flowchart Generator5_chris22_hhardy1@HOUSTON.RR.COM31_Tue, 20 Feb 2001 07:17:16 -0800692_iso-8859-1 Flowchart MVS JCL........

ADPAC in San Francisco ask for Joe Pierce... http://www.adpac.com/

just mention chris in houston, texas......

----- Original Message ----- From: "Hodgin, Scott" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, February 20, 2001 4:27 AM Subject: Off Topic Post - OS390 JCL Flowchart Generator



> Pardon the off topic post. > > We are relatively new to OS390 and DB2. Our programming staff is looking > for a software product (mainframe and/or PC) that will read OS390 JCL and > generate flowcharts of system flow. > > I would appreciate any suggestions. > > Thanks, > > Scott [...] 14660 46 34_Re: Compact Data for Archive Logs?11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Tue, 20 Feb 2001 07:09:23 -0600391_- Morning, We are using IEBGENER to copy from the VTS copy to the 3490 media for our DR offsite copy. Here is a sample of what the JCL looks like. You'll notice we are not cataloging the tape. We do this with a diferent job. We are currently attempting to address the problem with this copy going to two volumes. Our catalog job, as it currently is designed, cannot handle two volumes. [...] 14707 21 14_Delete Pending10_Lee Herbst29_lherbst@PROPAPPR.MARION.FL.US31_Tue, 20 Feb 2001 08:34:00 -0500436_us-ascii I have a table space in a delete pending state, and I can't figure out how to get it out of that state. Anyone know how to get the table space out of this state? Also, does anyone know if there are problems with running more than two applies on one server? This problem cropped up after starting the third apply on this machine - I'm am eventually going to need about 20 applies running. I'm running UDB 7 on NT Server 4. [...] 14729 62 26_Re: DB2 Version 6 SQLDSECT12_Michael Deer20_Michael.Deer@UAL.COM31_Tue, 20 Feb 2001 07:42:33 -0600551_- We dont use IMS/ADF, but you can hit this on any assembler program under the 'right' conditions. We hit this problem on one of our systems when we went to version 6. The problem is that the size of the dsect has changed and, if you have more than 91 columns, you need to add another base register. obviously this only affects assembler programs that access tables with more than 91 columns. Since it is an assembly error, programs that are already assembled, linked and bound to db2 will still work. You'll hit the error if you try to assemble [...] 14792 20 28_Re: PACKAGE GETPAGE QUESTION15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 20 Feb 2001 07:40:15 -0600465_- Hello Jeff

In all those years I think I traced a lot of plans using Omegamon application traces and I never (may be almost never) saw getpages against those catalog tables which you mentioned.

How was your plan bound: PKLIST(col.*). If you use this option you have to grant execute privelege to for the collection as a whole, not on package level. Is this a dynamic SQL? Did you revoke any priveleges the plan or any package were dependend on? [...] 14813 19 32_optimize for n rows in subselect20_Westcott-Dryer, Lisa32_Lisa_Westcott-Dryer@FOREMOST.COM31_Tue, 20 Feb 2001 09:03:05 -0500391_iso-8859-1 Can you put optimize for n rows in a subselect?



Lisa Westcott-Dryer Farmers/Foremost Database Administrator ph 616 956 2805

================================================ 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. 14833 10 36_Re: optimize for n rows in subselect15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 20 Feb 2001 08:02:37 -0600265_- No, you can't do that

================================================ 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. 14844 46 50_Re: Off Topic Post - OS390 JCL Flowchart Generator13_Keith Gilbert17_kgilbert@CSA1.COM31_Tue, 20 Feb 2001 08:26:39 -0600595_iso-8859-1 Revolve from Merant Systems will also provide you with system flow.

Keith Gilbert DBA Central Service Association Tupelo, MS





-----Original Message----- From: Hodgin, Scott [mailto:shodgin@SCFBINS.COM] Sent: Tuesday, February 20, 2001 6:27 AM To: DB2-L@RYCI.COM Subject: Off Topic Post - OS390 JCL Flowchart Generator



Pardon the off topic post.

We are relatively new to OS390 and DB2. Our programming staff is looking for a software product (mainframe and/or PC) that will read OS390 JCL and generate flowcharts of system flow. [...] 14891 29 32_DB2 V6 tablespace Define=no Parm0_27_Sharon.Stevens@WAKEFERN.COM31_Tue, 20 Feb 2001 09:52:47 -0500653_us-ascii John,

You have to look at the SPACE field in SYSIBM.SYSTABLEPART for the value of -1 or 0.











NOTICE TO RECIPIENT: THIS E-MAIL AND THE DOCUMENTS ACCOMPANYING THIS TRANSMISSION ARE CONFIDENTIAL AND MAY BE A COMMUNICATION PRIVILEGED OR PROTECTED BY LAW. IT IS MEANT FOR ONLY THE INTENDED RECIPIENT. IF YOU RECEIVED THIS E-MAIL IN ERROR, ANY REVIEW, USE, DISSEMINATION, DISTRIBUTION, OR COPYING OF THE E-MAIL IS STRICTLY PROHIBITED. PLEASE NOTIFY THE SENDER IMMEDIATELY OF THE ERROR BY RETURN E-MAIL AND PLEASE DELETE THE MESSAGE FROM YOUR SYSTEM. THANK YOU IN ADVANCE FOR YOUR COOPERATION. [...] 14921 67 28_Re: PACKAGE GETPAGE QUESTION16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Tue, 20 Feb 2001 10:19:56 -0500330_us-ascii Jeff,

Have you received any responses on this issue?

I doubt it, since this appears to be a complex issue that does not appear to have a straight forward answer....

Although, I am surprised you have not received any "....I think the sky is blue therefore it may not be raining." type responses! [...] 14989 14 6_test 810_Dave Detar29_dave.detar.cbnr@STATEFARM.COM31_Tue, 20 Feb 2001 09:41:25 -0600304_- last test

Dave DeTar Enterprise E-mail (309) 766-5310

================================================ 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. 15004 22 47_Any tool/SQL to generate DDLs from DB2 Catalog?13_Carlton Enuda24_carltonenuda@HOTMAIL.COM31_Tue, 20 Feb 2001 10:43:14 -0500473_- Goodday listers,

I will like to generate all DDLs - tablespaces, tables, Indexes, Aliases, Views...really everything - given a DATABASE name. Is there a way to do this with PLATINUM products(CA-DB2 Products). I will appreciate help as to how to do this with or without Platinum DB2 products.

Much obliged to all Carlton _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...] 15027 96 28_Re: PACKAGE GETPAGE QUESTION13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Tue, 20 Feb 2001 10:49:10 -0500447_US-ASCII Just a shot in the dark here, but is the plan bound with ACQUIRE(ALLOCATE)?

Also (another guess), the "first" execution of the SQL statement may be the first allocation of these objects (tablespace and index pagesets), so DB2 may require the header pages and space map pages. In addition, depending on the number of levels in the index, the query may need to search down through the index "tree" to get to an index leaf page. [...] 15124 14 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 20 Feb 2001 09:40:48 -0600441_- Hi

Did you try to put an 'A' in front of Database in Platinum's "Create Migration Strategy Panel". I think you will get all which is dependent of the database object. Is that what you meant?

================================================ 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. 15139 108 27_Broken page during DSN1COPY15_Sriram Sankaran27_ssgsriram@CHENNAI.TCS.CO.IN31_Tue, 20 Feb 2001 21:10:15 +0530765_us-ascii



Dear DB2 folks,

I am doing a DSN1COPY of a simple tablespace and I am getting a 'broken page' message. I have attached the SYSPRINT message below. (Below this message, I have mentioned the steps I have taken to repair the page)

1DSN1999I START OF DSN1COPY FOR JOB DSNCPY01 STEP010 DSN1989I DSN1COPY IS PROCESSED WITH THE FOLLOWING OPTIONS: NO CHECK/NO PRINT/ 4K/NO IMAGECOPY/NON-SEGMENT/NUMPARTS = 0/ OBIDXLAT/NO VALUE/ RESET/ /PIECESIZ= / DSN1998I INPUT DSNAME = DBZ2UAA.DSNDBC.UAA1T02.UAARTETS.I0001.A001 , VSAM DSN1997I OUTPUT DSNAME = DBZ2UAA.DSNDBC.UAA1T99.UAARTETS.I0001.A001 , VSAM DSN1990I DSN1COPY BROKEN PAGE. PAGENUMBER = 00000000. REASON: HEADER PAGE OR SPACEMAP:PGEND&PGBMF INCONSISTENT. SERVICE INFO: CODE= [...] 15248 41 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?0_27_Jeff.D.Jerry@WELLSFARGO.COM31_Tue, 20 Feb 2001 09:54:18 -0600296_iso-8859-1 We do it via CA RC/Migrator's strategy services. You can select a data base and all the objects within it including the security and the data within the tables. We also have BMC's catalog manager products that can do the same. I'm not as familiar with them, but it works as well. [...] 15290 51 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 20 Feb 2001 10:56:13 -0500331_iso-8859-1 Simple. Create a RC/Migrator strategy for the Database. If you do not haved RC/Migrator but only RC/QUERY, first list the Database then type DDL in the CMD column. Then do the same for the tablespaces, tables etc.

Without Platinum this would be quite tedious as you would need to write a log of catalog SQL. [...] 15342 42 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Tue, 20 Feb 2001 10:09:09 -0600473_iso-8859-1 Yes, using platinum: - set up an RC/M migration strategy. - select database and include your db name(s) - select 'a' on all explode options - run strategy analysis - "update options y" - under exclusive options bnd/data/stat/sql..... enter 's'



-----Original Message----- From: Carlton Enuda [mailto:carltonenuda@HOTMAIL.COM] Sent: Tuesday, February 20, 2001 9:43 AM To: DB2-L@RYCI.COM Subject: Any tool/SQL to generate DDLs from DB2 Catalog? [...] 15385 50 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 20 Feb 2001 09:10:41 -0700429_iso-8859-1 Carlton,

This can be accomplished very easy with Platinum RC Migrator. Once you are in this tool select Quick Migration Services. It will present you with a screen to enter DB2 DDL's.

If you enter the Database name you will have the option of selecting some or all of the objects associated with the selected database. I have used this tool to build large SAP DDL sets and it worked "like a charm". [...] 15436 66 28_Re: Stored Procedures survey10_Iris Wilde16_wildei@TDBANK.CA31_Tue, 20 Feb 2001 11:11:10 -0500351_iso-8859-1 We're using COBOL, but looking at SPL and Java. On DB2 V6.

My own question for the list -- what are people doing for error-handling? In particular how are you externalizing errors in SPL?

Todd, would you be so kind as to summarize your survey results for the list?



Thanks in advance

Iris Wilde, DBA [...] 15503 47 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 20 Feb 2001 16:11:39 -0000321_- You can do this using RC/Migrator. Just specify the DATABASE and all dependent onjects will be generated. If you need assistance - feel free to contact me offline.

Steen Rasmussen Computer Associates Senior Consultant tel: +45 45 47 43 63 fax: +45 45 47 41 10 mobile: +45 22 10 22 64 steen.rasmussen@ca.com [...] 15551 45 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?11_Pavan Borra26_pavan.borra@PRUDENTIAL.COM31_Tue, 20 Feb 2001 11:05:37 -0500435_us-ascii Use Platinum RC/Migrator - Strategy Services ; Create a strategy and mention the database name you want the DDLs for...









Carlton Enuda Tuesday February 20, 2001 10:43 AM

Please respond to DB2 Data Base Discussion List To: DB2-L@RYCI.COM cc: (bcc: Pavan Borra/O&S/Prudential) Subject: Any tool/SQL to generate DDLs from DB2 Catalog? [...] 15597 58 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 20 Feb 2001 10:14:15 -0600463_us-ascii We have "The Database 2 Administration Tool" (ADB) from IBM. All you need to do is type "GEN" next to the database name and you are lead through panels to submit a batch job which will generate the DDL's.

P.S. It works good!.... : )







Carlton Enuda cc: Sent by: DB2 Subject: Any tool/SQL to generate DDLs from Data Base DB2 Catalog? Discussion List [...] 15656 73 28_Re: Stored Procedures survey15_McClendon, Rick24_RMcClendon@ADMIN.FSU.EDU31_Tue, 20 Feb 2001 11:37:50 -0500413_iso-8859-1 We are using Cobol S.P.'s on DB2 V.5 OS/390. We have several different types - One is a simple pass-through procedure into C.I.C.S.-(We execute C.I.C.S. programs from any S.P. call supported appl. by passing the commarea through the S.P.) Another is used for our centralized address system - One stop for all appl. to find an address Another is used to provide easy ID updates accross all systems [...] 15730 56 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?11_patty rizzi19_patty_db2@YAHOO.COM31_Tue, 20 Feb 2001 08:40:18 -0800695_us-ascii Hi Carlton,

you can generate DDl very well with a product by Candle called :

DB/WORKBENCH

Hope this can help.

Regards,

Patrizia Rizzi





--- Carlton Enuda wrote: > Goodday listers, > > I will like to generate all DDLs - tablespaces, > tables, Indexes, Aliases, > Views...really everything - given a DATABASE name. > Is there a way to do this > with PLATINUM products(CA-DB2 Products). I will > appreciate help as to how to > do this with or without Platinum DB2 products. > > Much obliged to all > Carlton > _________________________________________________________________ > Get your FREE download [...] 15787 83 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?14_Toppins, Smike21_smike.toppins@GWL.COM31_Tue, 20 Feb 2001 09:33:45 -0700632_- I have a set of REXX/DSNREXX routines which will prompt you with a panel to list the starting place that you want to start the DDL hierarchy from. Contact me off-line if you're interested.



SMike Toppins Great-West Life smike.toppins@gwl.com (303) 737-5094



> ---------- > From: Jeff Faughn[SMTP:Jeff_Faughn@MAY-CO.COM] > Reply To: DB2 Data Base Discussion List > Sent: Tuesday, February 20, 2001 9:14 AM > To: DB2-L@RYCI.COM > Subject: Re: Any tool/SQL to generate DDLs from DB2 Catalog? > > We have "The Database 2 Administration Tool" (ADB) from IBM. All you > need to do is type "GEN" next to [...] 15871 75 53_DB2 DBA's, Product Developers, QA, System Programmers13_Ginger Duncan20_gingerd@TGA-JOBS.COM31_Tue, 20 Feb 2001 12:04:22 -0500535_Windows-1252 Good afternoon. Listed below are DB2 opportunities with software vendors and information solutions companies. I'll be happy to provide you with the details and answer questions you may have regarding these opportunities (864-473-1200). Thank you.

Systems Programmer:

Texas or California: 5-10 Yrs experience in DB2 Systems Support role with experience in performance tuning, SMPE, DB2 datasharing, parallel sysplex. Must have experience in a large mainframe environment. Salary range $80k+ (good range) [...] 15947 19 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 20 Feb 2001 18:01:27 +0100426_us-ascii I used CA Migrator, BMC CHANGE MANAGER and Workbench and the most simplest is WORKBENCH by CDB (it was

LET'S SEE for DB2 many century ago).

HTH

Max Scarpa

================================================ 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. 15967 37 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?11_Long, James19_c-jlong@STATE.PA.US31_Tue, 20 Feb 2001 12:09:07 -0500597_iso-8859-1 You can also do this with Import/Export using ErWin.



-----Original Message----- From: Carlton Enuda [mailto:carltonenuda@HOTMAIL.COM] Sent: Tuesday, February 20, 2001 10:43 AM To: DB2-L@RYCI.COM Subject: Any tool/SQL to generate DDLs from DB2 Catalog?



Goodday listers,

I will like to generate all DDLs - tablespaces, tables, Indexes, Aliases, Views...really everything - given a DATABASE name. Is there a way to do this with PLATINUM products(CA-DB2 Products). I will appreciate help as to how to do this with or without Platinum DB2 products. [...] 16005 97 31_Re: Smallint/Integer vs Decimal14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 20 Feb 2001 11:11:07 -0600618_iso-8859-1 The only reason I can think of would be to better enforce the domain within the DBMS. If you truly want to limit the numbers stored to -999 through 999, then using a DECIMAL(3,0) data type enables DB2 to do the checking. A SMALLINT can range from -32,768 to 32,767 and an INTEGER can range from -2,147,483,648 to 2,147,483,647. To limit either of these to the desired range (-999 to 999) additional constraint checking would need to be performed either in the application programs, or in a CHECK constraint or TRIGGER. Perhaps the additional overhead of the programmatic/CHECK/trigger constraint check [...] 16103 29 25_stored procedure question12_Le BD Nguyen20_lnguyen@AHOLDUSA.COM31_Tue, 20 Feb 2001 12:13:01 -0500610_us-ascii Good day all,

In section 7.2.4.10, Preparing a stored procedure of "DB2 UDB for OS/390 V6 Application Programming and SQL Guide", it was recommended that "if your stored procedure is a COBOL program, you must compile it with the option NODYNAM".

I prefer to have DYNAM option because it eliminates the relink process each time there is an upgrade to the software (especially when there are a lot of stored procedures to maintain). I have tested my (COBOL) stored procedure using option DYNAM and it seems to run fine (of course with the load libraries already define in the steplib [...] 16133 18 12_UDB Reorgchk11_Richard Yan23_dhspa3f@DHS.STATE.IL.US31_Tue, 20 Feb 2001 11:03:34 -0600441_- Hi List,

Is there any useful formulas to indicate which tale needs to be reorganized besides those formulas "reorgchk" provides.

Thanks

Richard Yan IL dept of Human serverices.

================================================ 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. 16152 44 29_Corrupted UDB Database on AIX11_JOHN KRUGER23_DHSPA3Q@DHS.STATE.IL.US31_Tue, 20 Feb 2001 11:26:33 -0600635_US-ASCII Corrupted UDB Database on AIX

Last week I received an early morning call from Operations that our AIX UDB DB2 v6.1 production database would not start. When I executed db2start, it appeared the database started successfully but as soon as the first connect attempt was made, it would crash again.

No useful information was found in the db2diag.log file to determine the cause of this fatal error. Why was there no information? Our Diagnostic capture level (DIAGLEVEL) was set to 1 (lowest setting) in the database manager configuration file. After resetting the Diaglevel to 3, and recreating the crash, we [...] 16197 46 32_Re: Accessing XBASIC Arabic data30_=?ISO-8859-1?Q?orhan_erg=FCn?=22_orhan.ergun@ESC.COM.TR31_Tue, 20 Feb 2001 19:06:31 +0200672_ISO-8859-1 Hello tariq, I suggest to you Hit software ODBC driver. web: www.hitsw.com regards orhan ----- Original Message ----- From: "Tariq Maghrabi" Newsgroups: bit.listserv.db2-l To: Sent: Monday, February 19, 2001 10:09 AM Subject: Accessing XBASIC Arabic data



> Hello, > We are currently Using DB2 Client Application Enabler with Windows 2000. The > DB2 Connect version which is currently installed on our machines is 5.2 . > We are looking for an ODBC driver that supports accessing and manipulating > Arabic XBASIC format data stored on DB2 from Windows 2000 based > applications. > > Any help / pointers [...] 16244 149 28_Re: Stored Procedures survey15_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Tue, 20 Feb 2001 12:39:29 -0500598_us-ascii DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SELECT SQLSTATE,SQLCODE INTO v_SQLSTATE, v_SQLCODE FROM sysibm.sysdummy1;

You can log error info to a log-table or have a 'C' utlity sproc that logs it to some log and/or spool.

ben

Iris Wilde wrote:

> We're using COBOL, but looking at SPL and Java. On DB2 V6. > > My own question for the list -- what are people doing for error-handling? > In particular how are you externalizing errors in SPL? > > Todd, would you be so kind as to summarize your survey results for the list? > > Thanks in [...] 16394 99 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?9_Rob Crane22_racrane@CONCENTRIC.NET31_Tue, 20 Feb 2001 10:56:49 -0700370_us-ascii 1) If you plan on pulling the DDL for all the objects tied to a Database(s) more than once it would be best to create a Migration Strategy. See example below for getting DDL tied to PTDB database.

Option 2.1 (RC/Migrator - Strategy Services)

RMS1 R06.01 ----- RC/M Strategy Services -------------- 02-20-01 12:33 COMMAND ===> SCROLL ===> CSR [...] 16494 57 28_IEE707I with any DB2 command27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Tue, 20 Feb 2001 12:56:43 -0500443_iso-8859-1 Does anyone know what would cause us to suddenly get message IEE707I after we issue a DB2 command from the MVS console? The command is executed, but this message has us concerned. The message description is:

Explanation: Before processing command cm yyy, MVS presented the command to all subsystems that monitor commands. Based on the response returned, MVS did not process the command for one of the following reasons: [...] 16552 55 15_Re: DB2 Editors14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Tue, 20 Feb 2001 12:11:26 -0600732_iso-8859-1 Just a quick post to make sure you consider BMC Catalog Manager, which also has a DB2 table editor feature.

Cheers, Craig S. Mullins Director, DB2 Technology Planning BMC Software http://www.bmc.com Craig_Mullins@bmc.com http://www.craigsmullins.com craig@craigsmullins.com

>-----Original Message----- >From: Newnham, Richard R SSI-ISES-42 >[mailto:Richard.R.Newnham@IS.SHELL.COM] >Sent: Tuesday, February 20, 2001 2:50 AM >To: DB2-L@RYCI.COM >Subject: DB2 Editors > >Hi, > >I wonder if anyone can tell me what other DB2 Data Editors there are on the >market. > >We are aware of ProEdit, FileAid/DB2 and Insync/DB2, but would like to know >if there are any more of these products available so we could [...] 16608 48 15_Re: DB2 Editors14_Stevens, Wayne21_Wayne_Stevens@BMC.COM31_Tue, 20 Feb 2001 12:24:02 -0600732_iso-8859-1 In BMCs Catalog Manager, there is an editor within it.

Wayne Stevens BMC Software, Inc. wayne_stevens@bmc.com (800) 537-1813

====================================================== BMC Software Proactive Notification will inform you via email of issues related to BMC Software products, such as, the provision of flashes, technical bulletins, product upgrades and release notes.

Access Hint: Go to www.bmc.com/support, select "Log in to Support," and enter your support login and password. If you do not have one, you may obtain one by clicking on "Request User ID." Once you've successfully logged in to the Technical Support Web page, select "Register for Proactive Notification." Fill out the [...] 16657 114 28_Re: PACKAGE GETPAGE QUESTION16_Jeff A L'Italien25_Jeff.A.L'Italien@AEXP.COM31_Tue, 20 Feb 2001 10:24:47 -0700570_us-ascii LL,

I checked the plan and it was bound with ACQUIRE(USE). However, I did speak with a buddy of mine about this problem and I think that we've isolated the cause. For whatever reason, the developer who created the plan bound it with CACHESIZE(0) which definitely DOES come into play when validating the authorizations and thus could potentially have to run up against the catalog during invocation. I've rebound with plan with CACHESIZE(256) and will keep an eye on it to see if it does drop the access to the catalog tables. Thanks for your input. [...] 16772 41 46_Error Handling in Triggers & Stored Procedures11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 20 Feb 2001 12:28:19 -0600601_- Listers, need some help on a specific error handling issue.

Environment: DB2 OS/390, V6 May Refresh, RRSAF, WLM.

Consider an AFTER TRIGGER that calls a Stored Procedure. This procedure will have some business logic and will generally write a message to MQ-series.

Question1: If the SP abends, will the updates made to the base table (that caused the trigger to be fired) be rolled back? I understand that the calling LUW is placed in a “must rollback” state, but is this true even when it is a Trigger? What if the calling application (that caused the Trigger to be fired) [...] 16814 61 10_Re: DSSIZE9_Saddy, Ed16_Ed_Saddy@BMC.COM31_Tue, 20 Feb 2001 12:33:26 -0600417_iso-8859-1 I don't think you'll have any problems with CREATE TABLESPACE (partitioned only) with DSSIZE 64G. The partitioning index always "inherits" the size limit from the tablespace's DSSIZE.

With DSSIZE 64 GB (or anything > 4GB), always make sure that your underlying VSAM datsets get allocated as EA-enabled. If you do a LISTCAT, you'll see EXTENDED and EXT-ADDR listed amongst the object's options. [...] 16876 139 28_Re: PACKAGE GETPAGE QUESTION16_RICHARD E MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Tue, 20 Feb 2001 13:59:30 -0500771_us-ascii Jeff,

Thanks for the follow-up! Please let me know what you find....

Rick











"Jeff A L'Italien" on 02/20/2001 12:24:47 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: RICHARD E MOLERA/SallieMae) Subject: Re: PACKAGE GETPAGE QUESTION





LL,

I checked the plan and it was bound with ACQUIRE(USE). However, I did speak with a buddy of mine about this problem and I think that we've isolated the cause. For whatever reason, the developer who created the plan bound it with CACHESIZE(0) which definitely DOES come into play when validating the authorizations and thus could potentially [...] 17016 48 23_Re: DB2 monitor for AIX13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Tue, 20 Feb 2001 12:59:39 -0600547_- On Mon, 19 Feb 2001 11:51:18 -0600, Helen Johnson wrote:

>I'm looking for a good DB2 monitor for DB2 6.1 on AIX. Can anyone >give any suggestions? I know that Database Guys has one as does Quest >Software. Does anyone know of any others? > >Thanks, > >Helen Johnson > >================================================ >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. [...] 17065 106 15_Job Opportunity12_Diane Barela28_Info@PALLADIANCONSULTING.COM31_Tue, 20 Feb 2001 11:23:23 -0800664_iso-8859-1

Dear Colleagues,

Palladian Consulting, a leader in the RDBMS consulting industry is currently seeking a DB2 DBA for a 6-month contract (with possible extensions) in CA. Our client is in need of a Sr. Level DBA with extensive experience/knowledge in large DB2 systems in a Client Server environment. The candidate must have excellent verbal and written communication skills, ability to work independently, strong trouble shooting skills, and UNIX background/experience would be considered a plus. US citizenship required. If this is something you would be interested in pursuing or hearing more about, please feel free to contact me. [...] 17172 96 32_Re: IEE707I with any DB2 command12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 20 Feb 2001 11:51:37 -0800571_us-ascii First thing I would check is to see if you have two subsystems with the same CRC character. This is where I've typically seen this message. --- "Hilton, Tina, BmS - NMI -PM" wrote: > Does anyone know what would cause us to suddenly get > message IEE707I after > we issue a DB2 command from the MVS console? The > command is executed, but > this message has us concerned. The message > description is: > > Explanation: Before processing command cm > yyy, MVS presented the > command > to all subsystems that monitor commands. > Based [...] 17269 38 28_SRTPOOL, Limiting the Use Of13_Lockwood Lyon19_Lockwool@MEIJER.COM31_Tue, 20 Feb 2001 15:24:04 -0500404_US-ASCII All,

In the DB2 for OS/390 V6 Admin Guide under "Estimating the size of the sort pool", it states:

"The maximum size of the sort work area allocated for each concurrent sort user depends on the value ... [of SRTPOOL] "

Okay, so in DSN6SPRM I set SRTPOOL=51200 (About 50 Mb).

Wild Guess and Question #1: Is this 50 Mb per concurrent sort user? Guess answer: Yes. [...] 17308 90 50_Re: Error Handling in Triggers & Stored Procedures14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 20 Feb 2001 12:30:02 -0800624_us-ascii Suresh,

Talk about some gray areas.....but...

(1) If Stored Procedure ABENDS, then you are in MUST ROLLBACK. If appl decideds not to ROLLBACK, and continues on, then at some point tires a COMMIT, COMMIT will fail, etc and so forth...

(2) If Stored Procedure does not "abend" or "abort", then it is up to "logic" to return the condition in an inout/output parm to the caller, the Trigger. The Trigger should then issue the SINGAL or RAISE ERROR, and hopefuly, the application is not bypassing that error checking as well. -- If app bypasses "logic" errors, not physical SQLCODE/SQLSTATE ro [...] 17399 27 54_Installation problem: DB2 PDE 7.1 on Red Hat Linux 7.014_Steve Westfall25_steve.westfall@AQUILA.NET31_Tue, 20 Feb 2001 14:45:10 -0600530_iso-8859-1 While installing DB2 Personal Developer's Edition 7.1 on Red Hat Linux 7.0, I got the following error message:

"error while loading shared libraries: libncurses.so.4: cannot open shared object file: No such file or directory."

It turns out that Red Hat Linux 7.0 has a newer version of that shared library: libncurses.so.5. My question is this: Does anyone know if DB2 really needs the older version of the library, or can I simply create a link named libncurses.so.4 that points to libncurses.so.5? [...] 17427 111 50_Re: Error Handling in Triggers & Stored Procedures13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Tue, 20 Feb 2001 15:47:41 -0500415_iso-8859-1 Question: With an SQL stored Procedure is there a way to access information from the SQLCA? For example, the SQL stored procedure receives a -204 (undefined name) SQL code. How can you easily tell which name is undefined? The information is typically available in SQLERMSG field of SQLCA, but SQLCA is not available in an SQL stored procedure? Can some other call be made to determine the resource? [...] 17539 114 50_Re: Error Handling in Triggers & Stored Procedures13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Tue, 20 Feb 2001 15:48:30 -0500591_iso-8859-1 > Question: With an SQL stored Procedure is there a way to access > information from the SQLCA? For example, the SQL stored procedure receives > a -204 (undefined name) SQL code. How can you easily tell which name is > undefined? The information is typically available in SQLERMSG field of > SQLCA, but SQLCA is not available in an SQL stored procedure? Can some > other call be made to determine the resource? > > Thanks, > > Dave > > -----Original Message----- > From: Richard Yevich [SMTP:ryevich@YAHOO.COM] > Sent: Tuesday, February 20, 2001 3:30 PM > To: DB2-L@RYCI.COM [...] 17654 13 32_Re: IEE707I with any DB2 command11_Ruth Sutlic24_ruth.sutlic@DILLARDS.COM31_Tue, 20 Feb 2001 14:30:17 -0600449_- There are displays you can do to see if another system is using your command recognition character. I use from MVS console or SDSF: D OPDATA. Or you can use: /D SSI (to get a list of all defined subsystems

================================================ 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. 17668 67 58_Re: Installation problem: DB2 PDE 7.1 on Red Hat Linux 7.014_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 20 Feb 2001 13:12:22 -0800410_us-ascii Easy to fix. Just link libncurses.so.5 to libncurses.so.4 , then reinstall. It will be just fine.

Redhat 7.0 is not yet listed as a fully supported version by IBM for DB2. Besides that, Redhat 7.0 has other problems.

We have successuflly installed DB2 UDB 7.1 on Redhat 7.0 - many times, in classes and workshops, but the libncurses is the only real different -- just use the link. [...] 17736 179 50_Re: Error Handling in Triggers & Stored Procedures14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 20 Feb 2001 13:17:03 -0800385_us-ascii No - rather not yet. SQL Procedure Language is an open standard (SQL-3), as such it works at the lowest common denominator. Since it supported by multiple vendors (IBM, Oracle), SQLCA is not part of the standard. However, it is a growing standard, just as SQLJ is. SQLJ also does not have a SQLCA yet, although it is being added and will be available with several weeks. [...] 17916 44 32_Re: SRTPOOL, Limiting the Use Of14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 20 Feb 2001 16:17:21 -0500401_ISO-8859-1 Lockwood, Going right to #2, you can't. If your sortpool size is 50 Meg, this is PER user, so 10 concurrent users could gobble up 500 meg.... You need to have a smaller value for the srtpool size....

Regards, Joel



Message text written by DB2 Data Base Discussion List >In the DB2 for OS/390 V6 Admin Guide under "Estimating the size of the sort pool", it states: [...] 17961 69 32_Re: SRTPOOL, Limiting the Use Of14_Richard Yevich17_ryevich@YAHOO.COM31_Tue, 20 Feb 2001 13:22:40 -0800569_us-ascii Sortpool is shared, not per concurrent user. Overflows are into DSNDB07. Too many concurrent users sorting, not enough sort area, then the BPool for DSNDB07, and not enough there, then workfiles and I/O.

--- Lockwood Lyon wrote: > All, > > In the DB2 for OS/390 V6 Admin Guide under "Estimating the size of > the sort pool", it states: > > "The maximum size of the sort work area allocated for each > concurrent sort user depends on the value ... [of SRTPOOL] " > > Okay, so in DSN6SPRM I set SRTPOOL=51200 (About 50 Mb). > > [...] 18031 61 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?18_Gerrit Groenendaal22_groenen@WORLDONLINE.NL31_Tue, 20 Feb 2001 22:33:07 +0100539_us-ascii Hi,

Are you all on DB2 V6?(os/390)

Gerrit

Don Alden wrote:

> Carlton, > > This can be accomplished very easy with Platinum RC Migrator. Once you are > in this tool > select Quick Migration Services. It will present you with a screen to enter > DB2 DDL's. > > If you enter the Database name you will have the option of selecting some > or all of the > objects associated with the selected database. I have used this tool to > build large SAP > DDL sets and it worked "like a charm". > > Good Luck, [...] 18093 83 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 20 Feb 2001 14:56:09 -0700652_iso-8859-1 We are getting ready to migrate our first customer to V6 in the next couple of months.

-----Original Message----- From: Gerrit Groenendaal [mailto:groenen@WORLDONLINE.NL] Sent: Tuesday, February 20, 2001 2:33 PM To: DB2-L@RYCI.COM Subject: Re: Any tool/SQL to generate DDLs from DB2 Catalog?



Hi,

Are you all on DB2 V6?(os/390)

Gerrit

Don Alden wrote:

> Carlton, > > This can be accomplished very easy with Platinum RC Migrator. Once you are > in this tool > select Quick Migration Services. It will present you with a screen to enter > DB2 DDL's. > > If you enter the Database name you [...] 18177 106 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 20 Feb 2001 15:09:25 -0700557_iso-8859-1 Don- Your comment about the SAP database struck my interest. I support a Peoplesoft application here- and I'm unable to use migrator to migrate all of the views. I have to break the jobs up per database (and I have 16 peoplesoft databases per instance). This causes a lot of problems due to the fact we have views created on views that cross databases. Needless to say- I have problems whenever I try and do this. How many objects are in SAP (I thought they had many more than peoplesoft) and are they in multiple databases? just wondering- [...] 18284 82 28_Re: Stored Procedures survey13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 20 Feb 2001 16:43:04 -0600543_iso-8859-1 Hi,

First a question from me:

wrt the Java, I too am looking at this, but DB2 V6.1 OS390 does not use the JVM. It requires the Java to be compiled and linked as a LE370 load module. We have IBM developers saying the compiler is free, while documentation and the sales guys say there is a cost. We have been told to purchase Visual Age for Java so we can use the compiler component. We explained we have VisualAge for Java Enterprise edition on NT, and we do not want to use the OS390 VisualAge for Java. But they [...] 18367 22 27_Rebinding files for Fixpak215_Benjamin Reches24_Benjamin.Reches@MSDW.COM31_Tue, 20 Feb 2001 18:01:52 -0500560_us-ascii I installed FP2 WR21246. When I attempt to rebind the bind files I get errors both for db2ubind.lst and db2cli.lst.

Specifically the errors in db2ubind.lst occur while processing db2ucktb.bnd and in db2cli.lst while processing db2cliv2.bnd.

Has anybody else come across these errors??

Ben

================================================ 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. 18390 62 31_Re: Broken page during DSN1COPY13_LOMBARD,Shaun27_Shaun.LOMBARD@DEWRSB.GOV.AU31_Wed, 21 Feb 2001 10:02:09 +1100293_- Sriram,

Step 1 - Verify that the object is simple and not partitioned or segmented Step 2 - Run DSN1COPY with CHECK option on the input dataset Step 3 - Run DSN1PRNT with PAGE(0),FORMAT

You might have to go through the printed page to verify if the page is broken or not. [...] 18453 39 28_Re: Java Dynamic Sql and DB213_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 20 Feb 2001 17:04:29 -0600536_iso-8859-1 Patricia,

Sounds like something is looping.......if you find the resolution, please share?

Thanks

Dave

-----Original Message----- From: Berte, Patricia [mailto:Patricia.Berte@CENDANTMOBILITY.COM] Sent: Friday, February 16, 2001 11:26 AM To: DB2-L@RYCI.COM Subject: Java Dynamic Sql and DB2





Hi,

We are testing an application that was developed in Java (JDBC). It uses DB2 Connect Version 6.1 fix pack 4 to access DB2 6.1 for OS/390 from Websphere 3.52 on NT 4.0. [...] 18493 135 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Tue, 20 Feb 2001 16:11:16 -0700569_iso-8859-1 My SAP application has approximately 14 thousand tables and supporting DB2 structures. SAP 4.5B arrived pretty well segregated into functional databases so the operation is fairly straight forward. It does come with several hundred Views but they are segregated within their functional databases.

I haven't forgot about the DB2 Performance Knowledge Base, it's just that one of our IMS DBA's resigned a few weeks ago so I had to switch to my IMS hat and pick-up her customer. Working for an outsourcing company can get somewhat chaotic at times. [...] 18629 82 31_Re: Broken page during DSN1COPY14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 21 Feb 2001 10:22:48 +1100354_iso-8859-1 Do you know what a broken page is? From your query I am presuming that you don't: There are bits in the first and last bytes of a page which must match. Each time a page is written the two bits are flipped. When the page is read, if they don't match the page is considered "broken" - ie a write started on the page and it did not finish. [...] 18712 77 32_Re: SRTPOOL, Limiting the Use Of12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 20 Feb 2001 16:23:47 -0800411_us-ascii Ok. I'll byte. :=) Yevich in another reply states: "From: Richard Yevich | Block address | Add to Address Book Subject: Re: SRTPOOL, Limiting the Use Of To: DB2-L@RYCI.COM Sortpool is shared, not per concurrent user. Overflows are into DSNDB07. Too many concurrent users sorting, not enough sort area, then the BPool for DSNDB07, and not enough there, then workfiles and I/O." [...] 18790 12 29_V6.1 Migration considerations12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Tue, 20 Feb 2001 12:52:00 -0500414_- Is there anyway to detect if a program will have a problem with complex SQL (-101) under V6.1? Will this problem appear at bind or execution time after migrating to V6.1?

================================================ 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. 18803 90 10_Re: DSSIZE9_Saddy, Ed16_Ed_Saddy@BMC.COM31_Tue, 20 Feb 2001 18:42:36 -0600370_iso-8859-1 Raymond,

The problem you're having has nothing to do with LoadPlus not asking "...SMS to add a volume to the cluster definition." It's probably because you're using a DSSIZE < or = 4GB and your VSAM dataset is EA-enabled.

What DSSIZE did you actually use? For your 9 part TS, the default is 4 GB for the TS part and the partitioning index. [...] 18894 31 67_FYI: S/390 database app wins scalability honors; Oracle cries fou l14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 21 Feb 2001 12:00:28 +1100562_iso-8859-1 A database running on IBM's S/390 recently took a Grand Prize for transaction processing in Winter Corp.'s 2000 Scalability Program.

http://search390.techtarget.com/search390_Original_Content_Item/0,4202,52407 2,00.html





********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. [...] 18926 26 15_DECIMAL and SUM17_Valerie J Traurig18_valeriet6@JUNO.COM31_Tue, 20 Feb 2001 19:32:23 -0500688_- Why is it necessary to include DECIMAL around the SUMs in order for this SQL to work?

SELECT DECIMAL(DECIMAL(SUM(BONUS),8,2) * 100.00 /

DECIMAL(SUM(SALARY+BONUS+COMM),8,2),8,2) FROM EMP

Thanks ________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/tagj.

================================================ 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. 18953 59 19_Re: DECIMAL and SUM14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 21 Feb 2001 14:06:24 +1100485_iso-8859-1 Valerie,

Please post your workings derived from using the SQL Reference to determine the precision and scale of the outcome of each stage (SUM, addition, multiplication and division of decimal(?) operands) of the operation.

/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Valerie J Traurig [mailto:valeriet6@JUNO.COM] Sent: Wednesday, 21 February 2001 11:32 To: DB2-L@RYCI.COM Subject: [DB2-L] DECIMAL and SUM [...] 19013 131 10_Re: DSSIZE15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 21 Feb 2001 14:15:37 +1100545_iso-8859-1 Now where were you 2-3 weeks ago when I was trying to sort out why LoadPlus was AbEnding trying to load up one of these tablespaces? Yes the DSSIZE was <=4Gb and yes the clusters were EA-enabled. Yes, the loads ran fine unless they wanted to extend beyond the volume they were already on. I had 9 TSs; one had DSSIZE 32G, the rest were DSSIZE 4. The 32G one worked fine, the others worked if they stayed on one volume, the rest failed if they filled the volume and wanted to extend. Doesn't look like DSSIZE and EA-enabling were [...] 19145 55 16_Re: UDB Reorgchk11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 20 Feb 2001 22:15:48 -0500350_us-ascii Hey Richard,

Check your notes from the DB2 Symposium DB2 UDB Performance Class in Springfield... Monitor table "overflows"... Overflows, more than any other indicator, should be a driving force behind when to reorg a table. Cluster Ratio is also important (from reorgchk) if you are relying on clustering indexes to avoid sorts. [...] 19201 14 33_John Ordman is out of the office.0_29_John_Ordman@READERSDIGEST.COM31_Wed, 21 Feb 2001 01:00:36 -0500365_us-ascii I will be out of the office from 02/20/2001 until 02/27/2001.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 19216 15 42_Sujesh Menon/FSG/CSC is out of the office.12_Sujesh Menon15_smenon2@CSC.COM31_Wed, 21 Feb 2001 01:01:00 -0500425_us-ascii I will be out of the office from 02/20/2001 until 02/22/2001.

If this is a JETS emergency please contact Ross Lancaster at 860-221-2209 or David Nadeau at 860-221-2225

================================================ 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. 19232 24 21_Bufferpool monitoring7_Sri Sri20_sri_db2l@HOTMAIL.COM31_Wed, 21 Feb 2001 00:07:39 -0600615_- Hi All,

I am trying to find out how most DB2 UDB for OS390 shops are monitoring bufferpools on a day to day basis to detect problems. I am interested in getting a daily or weekly statistics of any critical bufferpool thresholds exceeded, unwanted events occurring or any bufferpool performance problems. At the same time not get buried under tons of useless statistics. I only have access to Omegamon and Platinum. Is there any Omegamon historical reports against SMF trace records that will give such information easily(if so what are the control statements to be used and what ttrace classes/ifcids [...] 19257 22 31_Re: Broken page during DSN1COPY0_27_Tom.Decabooter@HONDA-EU.COM31_Wed, 21 Feb 2001 09:01:05 +0100439_us-ascii DSN1COPY reports a broken page if you copy a 32K tablespace without specifying the 32K parameter. I ran into this problem not so long ago. After recovering the tablespace, i still had the 'broken page' error message when using DSN1COPY to restore an image copy from that tablespace into another DB2 system. It took me some time before i realised this was a 32K tablespace. The DSN1COPY output in your message specifies "4K". [...] 19280 98 15_Re: DB2 Editors9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 21 Feb 2001 08:20:50 +0000356_us-ascii I believe that you can only get this table editing function in BMC Catalog Manager when you ALSO have Princeton's Access installed (and made the necessary changes to the Command Table- ACTCOMND).

Do latest releases (post V6.1.02) of Catalog Manager have the table editing function without having to have Princeton's Access installed ? [...] 19379 61 32_Re: IEE707I with any DB2 command9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 21 Feb 2001 08:36:35 +0000685_us-ascii Just a warning that D OPDATA (only) displays the comand recognition characters of ACTIVE sub-systems.

Kind Regards, Andy Hunt - Scottish And Southern Energy











Ruth Sutlic on 20/02/2001 20:30:17

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: IEE707I with any DB2 command





There are displays you can do to see if another system is using your command recognition character. I use from MVS console or SDSF: D OPDATA. Or you can use: /D SSI (to get a list of all defined subsystems [...] 19441 24 46_Is my Batch Processing really OLTP in disguise12_Paul Pennock35_paul.pennock@FRIENDSPROVIDENT.CO.UK31_Wed, 21 Feb 2001 02:25:13 -0600629_- Could someone please help me !!

My site uses a third party software tool called Genio, which is owned by Hummingbird, to develop batch applications. One of this products downfalls is it generates dynamic SQL statements which then hit the databases apart from the sql being dynamic it processes the sql as single statements against the database i.e if I there is a transaction table with 40,000 update rows in and the master table has 4,000,000 rows at best it will perform 40,000 update statements sequentially, if the developer(s) are being particularly vindictive they will sometimes attempt to sequentialy parse [...] 19466 33 32_Re: SRTPOOL, Limiting the Use Of10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 21 Feb 2001 10:15:28 +0100336_us-ascii I knew that SORTPOOL size is PER CONCURRENT USER and that may be a problem for storage, as stated in Admin. manuals.

According to G. Wiorkowski:

"A sort pool is allocated for each thread that requires a sort in working storage A SELECT statement can require multiple sorts (UNION and ORDER BY, for example)" [...] 19500 77 40_Re: Question for DB2 systems programmers15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 21 Feb 2001 07:08:04 -0600548_iso-8859-1 Hi, all! I know this is an old thread but I thought I would add my two cents worth. I was on vacation. In addition to the SMP/E work I think that it behooves a systems newbie to eventually take introductory type courses in other areas; i.e. network, operating system, storage, as possible. DB2 interacts with all of these and more. You need to be able to "speak the same language" as everyone else when you are discussing problems. This also helps to tell when someone is being less than truthful with you (Gasp! Say it ain't so!). [...] 19578 116 15_Re: DB2 Editors27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 21 Feb 2001 08:27:38 -0500492_iso-8859-1 Yes, the latest release of Catalog Manager has it's own editor/browser. It's great!

Tina

-----Original Message----- From: Andy Hunt [mailto:Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK] Sent: February 21, 2001 3:21 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Editors



I believe that you can only get this table editing function in BMC Catalog Manager when you ALSO have Princeton's Access installed (and made the necessary changes to the Command Table- ACTCOMND). [...] 19695 116 32_Re: IEE707I with any DB2 command27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 21 Feb 2001 08:35:15 -0500366_iso-8859-1 This started at 4pm on Monday, with no system changes made at all, so nothing uses the same CRCs. I did try the commands another lister suggested, and they don't show any conflicts either. This is for all DB2 subsystems on one LPAR. The other LPAR's don't have this problem. It's not a big issue since the commands are executed, it's just troubling. [...] 19812 71 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?5_chris22_hhardy1@HOUSTON.RR.COM31_Wed, 21 Feb 2001 08:12:09 -0800653_iso-8859-1 steve, would rc/extract, rc/merge and ri manager to some degree generate DDL???? thanks

----- Original Message ----- From: "Rasmussen, Steen" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, February 20, 2001 8:11 AM Subject: Re: Any tool/SQL to generate DDLs from DB2 Catalog?



> You can do this using RC/Migrator. Just specify the DATABASE and all dependent onjects will be generated. If you need assistance - feel free to contact me offline. > > Steen Rasmussen > Computer Associates > Senior Consultant > tel: +45 45 47 43 63 > fax: +45 45 47 41 10 > mobile: +45 22 10 [...] 19884 24 53_Websphere monitoring/tuning from a DBA's perspective?13_Lynne Flatley17_LFlatley@NEFN.COM31_Wed, 21 Feb 2001 09:16:56 -0500545_us-ascii We have several applications currently developing their applications using Websphere 3.5 on NT. Does anyone have any monitoring/tuning tips for either the WAS repository db or the SESSIONS db?

Thanks!



Lynne A. Flatley New England Financial (617) 578-4079 lflatley@nefn.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. 19909 48 23_Re: DB2 monitor for AIX0_29_Joseph_Esposito@PUTNAMINV.COM31_Wed, 21 Feb 2001 09:34:41 -0500464_us-ascii I would recommend Database-Guys.

SQL-GUY can identify you worst SQL in a matter of minutes.

We use SPACE-GUY and WISE-GUY to produce daily performance and database space HTLM reports.

We also use SPACE-GUY to monitor the Unix and Database space.













Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 19958 63 15_Recovery JCL...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Wed, 21 Feb 2001 17:21:46 +0200438_- Hello List,

We have developed a brand new DR Procedure. It creates Recovery Statements by checking DB2 Catalog with Optimum Tape Usage.

There are average 500 DDs and 500 Recover Statements for each JCL.

But JCL Abends with JCL Error after 30 min. run. We have also coded DYNAMNBR.DSNUPROC=3000.



2 IEFC001I PROCEDURE DSNUPROC WAS EXPANDED USI IEF197I SYSTEM ERROR DURING ALLOCATION ABEND0C4-0004 [...] 20022 118 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Wed, 21 Feb 2001 16:34:11 +0100401_iso-8859-1 Hello Steve,

You could use BMC Change Manager, just fill in the database and all dependent objects (also possible with full data and authorisations) will be included. And I guess others can do the same trick..;-)

Kind regards,

Jaap Slot, sr. DB2 DBA, Rabobank ICT

Phone 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167 e-Mail [...] 20141 40 13_SQLJ Question8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 21 Feb 2001 07:32:55 -0800473_us-ascii Hello !

I have written my first SQLJ on Windows and saved the file as App.sqlj. Then i used command SET JAVA_COMPILER=NONE and finally tried to compile the application by the command: sqlj App.sqlj

It gave me an error(a missing semicolon) but when i corrected the error and again tried to compile my program (by command sqlj App.sqlj), it simple 'hangs'. i.e. my cursor does not come back...no response , no success or failure messages nothing. [...] 20182 85 51_Re: Any tool/SQL to generate DDLs from DB2 Catalog?9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 21 Feb 2001 08:53:25 -0700505_us-ascii An RC/Extract strategy is a new type of strategy in Migrator, and a stand alone product as well. Allows you to get RI intact data and build the objects for the system, so yes you can get DDL out of RC/Extract as well. RC/Merger can also produce DDL, but is used primarily for consolidation of DB2 catalogs to prepare for a datasharing environment, and moving mass amounts of data, etc. If you just want Alter statements for FK then RI Manager/Editor can do this as well (system or user RI). [...] 20268 21 24_Re: DB2 UDB v7.1 and ESS9_Bob Lewis23_BLewis@MICROGENERAL.COM31_Wed, 21 Feb 2001 07:41:09 -0800450_iso-8859-1 Fabrizio -

Do you have a document number for "DB2 UDB for AIX performance of Enterprise Storage Server"?

I couldn't find it on the IBM Redbook site...

Thanks -

Bob Lewis

================================================ 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. 20290 142 32_Re: IEE707I with any DB2 command12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 21 Feb 2001 10:09:01 -0600299_us-ascii I think subsystem commands from the console are processed by the members in the SDSNLINK library, which is only read at IPL time. What level is this library on your system, V5 or V6, and if V5, did it get updated with the maintenance that went on Sunday ? Was there an IPL on Sunday ? [...] 20433 24 11_DR Question0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 21 Feb 2001 10:21:09 -0600369_us-ascii I'm in the process of setting up a mass quiese of one of our applications, to provide a single consistent point of recovery, mainly for DR purposes. My question has to do with recovery. At recovery time will I run into a DB2 catalog contention problem if I run 4 or 5 jobs in parallel recovering sets of TS from separate image copies all to the same RBA? [...] 20458 71 19_Re: Recovery JCL...14_David Williams30_David.Williams@DOL.STATE.GA.US31_Wed, 21 Feb 2001 11:25:18 -0500569_us-ascii I think at one time there was a limit of 255 DDs in a job step. I do not know if this is still true.



"Cuneyt Goksu (Garanti Teknoloji)" wrote:

> Hello List, > > We have developed a brand new DR Procedure. It creates Recovery Statements by checking DB2 Catalog with Optimum Tape Usage. > > There are average 500 DDs and 500 Recover Statements for each JCL. > > But JCL Abends with JCL Error after 30 min. run. We have also coded DYNAMNBR.DSNUPROC=3000. > > 2 IEFC001I PROCEDURE DSNUPROC WAS EXPANDED USI > IEF197I SYSTEM ERROR DURING [...] 20530 42 15_Trigger Unhappy10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 21 Feb 2001 10:22:04 -0600329_- DB2 for OS/390 V6 - Recent maintenance level.

I haven't used triggers so far, and now I want to be able to create a trigger something like this:

CREATE TRIGGER TRIG1 BEFORE INSERT ON MYTABLE REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SET COL1 = (SELECT COL1 FROM OTHERTAB WHERE KEY = N.KEY); [...] 20573 92 19_Re: Trigger Unhappy11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 21 Feb 2001 11:09:11 -0600670_- John,

I think what you are trying to do is not allowed in a BEFORE trigger. I have got around this issue by creating an AFTER trigger which does the same thing. Here is an example:

-- (RE-UPDATES THE ROW JUST INSERTED WITH THE PROPER VALUES FROM BW5)

CREATE TRIGGER BW6TR001 AFTER INSERT ON TRNTRT.BW6 REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC UPDATE TRNTRT.BW6 BW6 SET GPA_CMPY_LIN_1_NM = (SELECT GPA_CMPY_LIN_1_NM FROM TRNTRT.BW5 BW5 WHERE BW5.FUND_SPONSOR_ID = BW6.FUND_SPONSOR_ID AND BW5.GPA_COMPANY_ID = BW6.GPA_COMPANY_ID ) WHERE BW6.FUND_SPONSOR_ID = N.FUND_SPONSOR_ID AND BW6.GPA_COMPANY_ID = N.GPA_COMPANY_ID ; END# [...] 20666 47 15_Trigger unhappy12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 21 Feb 2001 19:22:24 +0200500_iso-8859-1 I can just resubmit my last response. I had the same problem at the beginning but changing the ; to # ( except for the internal sql coomads ) solved the problem. BTW, I always use begin atomic & end#



Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.com ----- Original Message ----- From: "Isaac Yassin" To: "DB2 Data Base Discussion List" Sent: Friday, February 16, 2001 9:49 AM Subject: trigger creation [...] 20714 28 14_sort pool size12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 21 Feb 2001 19:32:11 +0200444_iso-8859-1 Hi, As I understand it from the manual (admin guide -V6) - it's per user.

5.4.4 Controlling sort pool size and sort processing

Sort is invoked when a cursor is opened for a SELECT statement that requires sorting. The maximum size of the sort work area allocated for each concurrent sort user depends on the value you specified for the SORT POOL SIZE field on installation panel DSNTIPC. The default value is 1 MB. [...] 20743 65 19_Re: Trigger Unhappy12_Mark Cassity27_Mark.Cassity@MOTION-IND.COM31_Wed, 21 Feb 2001 11:39:44 -0600407_iso-8859-1 Hi John,

I think you need to include "END" when you have the "BEGIN ATOMIC" clause. According to the manuals, the "BEGIN ATTOMIC" and "END" are only needed if you execute more than one sql statement. Remember to change the termination character to something other than ";" if using spufi. Hope this works. Also, change the BEFORE to an AFTER. I too am one of those frustrated souls!! [...] 20809 54 15_Re: DR Question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Wed, 21 Feb 2001 09:37:23 -0800337_iso-8859-1 What has catalog to do with RBA? Am I missing something here? Catalog is only used to allocate the image copy just prior to the RBA to which you want to recover. So, recovering to different RBAs should be no different than recovering to same RBA as far as catalog is concerned. Is DR any different than a normal Recover? [...] 20864 20 7_OUT DDL12_Isaac Yassin20_yassini@BEZEQINT.NET31_Wed, 21 Feb 2001 19:41:33 +0200466_iso-8859-1 Hi, I used BMC , CA & Candle (WORKBENCH) The easisest to use is WORKBENCH which also works even if DB2 is down. >personal opinion only < Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net isaacyassin@yahoo.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. 20885 22 19_Re: Trigger Unhappy10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Wed, 21 Feb 2001 11:45:44 -0600568_- Thanks to all who have replied so far. I think that what is bugging me is that as a new Triggerer, it seems to me that the BEFORE INSERT function which I demonstrated (hashlessly and imperfectly as it happens!) would be the most useful possible function of a trigger. The (official) response to the many previous contributers with the same problem seems to have been something like 'whoooa there, you can't do that! What do you want to do that for!'. I suppose that there might be quite sound reasons why this construct is not feasible (although none spring to [...] 20908 83 19_Re: Trigger Unhappy16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Wed, 21 Feb 2001 09:59:12 -0800522_iso-8859-1 Try adding 'NO CASCADE' after the trigger name, so the beginning of the trigger would go:

CREATE TRIGGER TRIG1 NO CASCADE BEFORE INSERT ON MYTABLE etc...

IIRC, DB2 requires the use of a no cascade directive in a 'before insert' trigger.

-D

----------------------------------------------------------------------- Dylan C. Vanderhoof Internal Software Developer Semaphore Corporation http://www.semaphore.com/ perl -e "print(pack('h38','c6c616279616e604c6c616279616e6e2e65647'))" [...] 20992 37 24_Re: DB2 UDB v7.1 and ESS13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 21 Feb 2001 09:55:14 -0800463_iso-8859-1 It's not a red book. It does not appear to have a document number. The URL is http://www-4.ibm.com/software/data/db2/os390/pdf/db2aixess.pdf

-----Original Message----- From: Bob Lewis [mailto:BLewis@MICROGENERAL.COM] Sent: Wednesday, February 21, 2001 7:41 AM To: DB2-L@RYCI.COM Subject: Re: DB2 UDB v7.1 and ESS



Fabrizio -

Do you have a document number for "DB2 UDB for AIX performance of Enterprise Storage Server"? [...] 21030 33 15_Re: DR Question12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 21 Feb 2001 12:04:00 -0500555_- We do this every time we recover the apps. at DR time and haven't had any problems. DB2 V5.1 and OS/390 2.6. We also put the archive logs needed on DASD so there is no problem with tape contention.

>>> DB2-L@RYCI.COM@inter2 02/21/01 10:21AM >>> I'm in the process of setting up a mass quiese of one of our applications, to provide a single consistent point of recovery, mainly for DR purposes. My question has to do with recovery. At recovery time will I run into a DB2 catalog contention problem if I run 4 or 5 jobs in parallel recovering [...] 21064 75 15_Re: DR Question0_19_Tim.Lowe@STPAUL.COM31_Wed, 21 Feb 2001 12:10:50 -0600594_us-ascii Rohn, The answer to the question is NO, you will not have DB2 catalog contention. But, you may have tape contention on backup tapes or log tapes. And, since you are doing separate recovery jobs, hopefully you do not have Referential Integrity rules between them.

Since you are running DB2 V6, which allows for parallel backup and recovery when you don't use tape, have you considered backing up to dasd instead of tape? (you seem to have the ideal case for utilizing this enhancement) Then, you could run a single backup job, copying all of your tablespaces in parallel to [...] 21140 52 19_Re: Trigger Unhappy12_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Wed, 21 Feb 2001 12:27:35 -0600343_us-ascii Hello John,

I'm one of those unhappy folks too. It seems the only way to supply a value to a transitional variable in a "Before" trigger is with the UDF. I'm hoping IBM remedies this by eventually supporting the Set with subselect and (hopefully also) Stored Procedure manipulation of these same "transitional" variables. [...] 21193 90 15_Re: DR Question14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 21 Feb 2001 12:48:09 -0600589_iso-8859-1 If you are trying to read from the same archlog tape for different recoveries you may want to consider using IDCAMS to REPRO them to disk. This would involve doing 'DELETE ARCHDSN NOSCRATCH' 1st, hard-coding the input DSN, volser and label of the input tape version and cataloging the disk version during the repro. Use caution when doing this as DB2 may call for archive for data retrieval at any time and if archlog is uncataloged you will have problems. Recatalog the original tapes with correct label numbers after you are done with and have deleted the disk versions. [...] 21284 32 10_Query Help16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Wed, 21 Feb 2001 14:28:25 -0500329_iso-8859-1 Hey Folks... Have a question from a developer. We are running os/390 V5, hope you can help....

According to SQL-92 specs I should be able to run a correlated subquery like the one below, but I can't make it work in DB2. Are we SQL-92 compliant? I really need this functionality to create a crosstab report [...] 21317 56 14_Re: Query Help17_Wood, Christopher17_cwood@CAYENTA.COM31_Wed, 21 Feb 2001 12:01:16 -0800302_ISO-8859-1 I do not have access to a OS/390 v5 DB2, but I think the problem is that columns of the projection that are not specified in the group by (ie. the common table expression) is not really a summarizing function.

I believe the following will produce the results you are looking for [...] 21374 19 23_InDUG spring conference27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 21 Feb 2001 14:56:29 -0500489_iso-8859-1 InDUG (Indiana DB2 Users Group) will have its spring conference on March 20, 2001. If you'd like more information, please reply to Tina.Hilton@bmsus.com.

Tina Hilton Database Analyst Bertelsmann mediaSystems Tina.Hilton@bmsus.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. 21394 160 32_Re: IEE707I with any DB2 command27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 21 Feb 2001 14:58:37 -0500575_iso-8859-1 We IPL every Sunday. SDSNLINK is at V5, and none of the PTFs affected it.

Tina

-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: February 21, 2001 11:09 AM To: DB2-L@RYCI.COM Subject: Re: IEE707I with any DB2 command



I think subsystem commands from the console are processed by the members in the SDSNLINK library, which is only read at IPL time. What level is this library on your system, V5 or V6, and if V5, did it get updated with the maintenance that went on Sunday ? Was there an IPL on Sunday ? [...] 21555 127 40_Re: Question for DB2 systems programmers13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 21 Feb 2001 12:10:10 -0800555_iso-8859-1 Hi, I'm new to the list, but having been a systems programmer for 19 years, I wanted to add to this discussion. . I read the other responses, they mention the DB2 System Administration class, which I highly recommend. . SMP is easily learned from a mentor, but a class may be needed if you have a lot of usermods to deal with. Installing DB2 is one thing, then there are all the other related products you will be responsible to install and administer. Their SMP packaging may not be as straightforward, so it's best to have a good mentor [...] 21683 153 40_Re: Question for DB2 systems programmers15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 21 Feb 2001 14:35:02 -0600425_iso-8859-1 Well said! I have to agree with all of your points. A book that I recommend to people who are new to systems and OS/390 and all of its subsequent incarnations is Exploring IBM S/390 Computers by Jim Hoskins and George Coleman ($39.95). It is a nice overview of an IBM OS/390 system and all of its accoutrements. The 7th edition has just come out. If you want one you have to order quickly. It sells out fast. [...] 21837 14 14_Re: Cold Start14_Harvey Puckett25_HPUCKETT@DOAS.STATE.GA.US31_Wed, 21 Feb 2001 15:56:26 -0500385_US-ASCII ugggggghh is right ... and don't forget that DBD01 is also not in SYSCOPY, but in BSDS ... you'll miss that when it's gone! Talk to IBM.

===============================================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. 21852 86 19_Re: Trigger Unhappy14_Richard Yevich17_ryevich@YAHOO.COM31_Wed, 21 Feb 2001 13:44:28 -0800341_us-ascii All,

It is specifically stated in the manuals (though somewhat hidden), that the only way to SET a transition variable, is directly or via UDF. The UPDATE via SCALAR SUBSELECT is not supported. As well, transition varialbles can be passed to a Stored Procedure, but cannot be updated.

Put the SQL in a UDF, then: [...] 21939 89 14_Re: Query Help13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Wed, 21 Feb 2001 16:04:13 -0600461_iso-8859-1 Michael,

DB2 OS/390 V5, V6 or V7 - No. Non-OS/390 DB2 - Yes.

As Chris stated, the subquery MAY not be required at all. If the join to TCLINICC introduces duplicate C_DEPT records then these two queries are not equivalent.

Since OS/390 does not support this syntax, then it is generally coded as a Nested Table Expression in the FROM clause which is the right table of a LEFT join (or V6 Correlated Nested Table Expression). [...] 22029 80 31_Re: Broken page during DSN1COPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 21 Feb 2001 16:37:07 -0600500_iso-8859-1 Sriram,

Also, be sure to tell DSN1COPY if this is a 32K page.

Michael

-----Original Message----- From: LOMBARD,Shaun [mailto:Shaun.LOMBARD@DEWRSB.GOV.AU] Sent: Tuesday, February 20, 2001 5:02 PM To: DB2-L@RYCI.COM Subject: Re: Broken page during DSN1COPY



Sriram,

Step 1 - Verify that the object is simple and not partitioned or segmented Step 2 - Run DSN1COPY with CHECK option on the input dataset Step 3 - Run DSN1PRNT with PAGE(0),FORMAT [...] 22110 11 13_Signoff DB2-L17_Price, Jeff (EDS)14_jprice@NCL.COM31_Wed, 21 Feb 2001 18:01:28 -0500244_-

================================================ 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. 22122 82 19_Re: Trigger Unhappy11_Suresh Sane21_data_arch@HOTMAIL.COM31_Wed, 21 Feb 2001 17:20:17 -0600629_- Steve -

I think you are interpreting the "referenced below" incorrectly. You can can use it (via a correlation coefficient) - it just cannot be in a FROM clause. At least that's how I read it since the trigger does work very well for me.

Thanks, Suresh

>From: Steve Grimes >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Trigger Unhappy >Date: Wed, 21 Feb 2001 12:27:35 -0600 > >Hello John, > >I'm one of those unhappy folks too. It seems the only way to supply a >value to >a transitional variable in a "Before" trigger is [...] 22205 29 22_Dynamic Insert Program14_Mark McCormack27_mamccormack@STATESTREET.COM31_Wed, 21 Feb 2001 19:10:37 -0500573_us-ascii I am posting this for a co-worker. Any help would be appreciated.

Mark McCormack

-----------------------------------------------------------------------------------------------------------------------------------------------

Does anyone have a PL/1 program that reads an input file (i.e. in the format of a DSNTIAUL UNLOAD) , dynamically creates INSERT statements, then INSERTS each row from the input file.?

This program should be flexible to INSERT into any target table (the table name to be specified via a JCL PARM or SYSIN). [...] 22235 45 66_Re: S/390 database app wins scalability honors; Oracle cries fou l15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Wed, 21 Feb 2001 19:15:18 -0500456_iso-8859-1 Could anybody ready this. I could not? Is this URL correct?

-----Original Message----- From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] Sent: Tuesday, February 20, 2001 07:00 PM To: DB2-L@RYCI.COM Subject: FYI: S/390 database app wins scalability honors; Oracle cries fou l



A database running on IBM's S/390 recently took a Grand Prize for transaction processing in Winter Corp.'s 2000 Scalability Program. [...] 22281 134 50_Re: Error Handling in Triggers & Stored Procedures18_Bruce W Williamson26_Bruce.Williamson@NT.GOV.AU31_Wed, 21 Feb 2001 18:13:53 -0600675_- Howzit Dave?

Use EXEC SQL INCLUDE SQLCA to include SQLCA in your SP. Refer to "Diagnostic Handling and the SQLCA Structure" in the "Application Development Guide"

Cheers

Bruce



On Tue, 20 Feb 2001 15:47:41 -0500, Kenski, David wrote:

>Question: With an SQL stored Procedure is there a way to access information >from the SQLCA? For example, the SQL stored procedure receives a -204 >(undefined name) SQL code. How can you easily tell which name is undefined? >The information is typically available in SQLERMSG field of SQLCA, but SQLCA >is not available in an SQL stored procedure? Can some other [...] 22416 67 66_Re: S/390 database app wins scalability honors; Oracle cries fou l0_25_john.halloran@SGIO.COM.AU31_Thu, 22 Feb 2001 09:59:26 +0930490_us-ascii unfortunately the URL spans two lines put it togethor then it will work









"Philip, Sibimon" on 22/02/2001 10:45:18 am

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John HALLORAN/SGIOGRP) Subject: Re: [DB2-L] S/390 database app wins scalability honors; Oracle cries fou l





Could anybody ready this. I could not? Is this URL correct? [...] 22484 48 66_Re: S/390 database app wins scalability honors; Oracle cries fou l10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 22 Feb 2001 10:31:10 +1000466_ISO-8859-1 Philip,

The URL is correct. Its quite possible that the last bit got cut off (as it happened in my case). The last bit is

search390_Original_Content_Item/0,4202,524072,00.html.

Cheers, Kals.





-----Original Message----- From: Philip, Sibimon [SMTP:SPhilip@CSXLINES.COM] Sent: Thursday, February 22, 2001 11:15 AM To: DB2-L@RYCI.COM Subject: Re: S/390 database app wins scalability honors; Oracle cries fou l [...] 22533 74 66_Re: S/390 database app wins scalability honors; Oracle cries fou l12_Myron Miller22_myronwmiller@YAHOO.COM31_Wed, 21 Feb 2001 16:32:07 -0800611_us-ascii It is. You just have to add the "2,00.html" to the end of the highlighted URL and it works just fine. --- "Philip, Sibimon" wrote: > Could anybody ready this. I could not? Is this URL > correct? > > -----Original Message----- > From: James Campbell > [mailto:James.Campbell@HANCORP.COM.AU] > Sent: Tuesday, February 20, 2001 07:00 PM > To: DB2-L@RYCI.COM > Subject: FYI: S/390 database app wins scalability > honors; Oracle cries > fou l > > > A database running on IBM's S/390 recently took a > Grand Prize for > transaction processing in Winter Corp.'s 2000 > Scalability [...] 22608 28 66_Re: S/390 database app wins scalability honors; Oracle cries fou l13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 21 Feb 2001 19:33:22 -0500424_iso-8859-1 Hello Sibimon,

I can read it as long as I put the URL back together.

The copy of the message in my inbox from James had the URL split up. I suspect the listserv may have done that.

It should be: http://search390.techtarget.com/search390_Original_Content_Item/0,4202,52407 2,00.html

Alternately, go to http://search390.techtarget.com/ and click the link to S/390 Database app..... [...] 22637 36 29_Archive and Purge of DB2 data13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 21 Feb 2001 16:57:57 -0800586_iso-8859-1 Greetings, listers. We have one major and several lesser applications on our DB2 5.1 CICS 4.1 OS/390 2.7 system which were designed without any facility to archive and purge old data. Our DASD is growing at 20% per year, online response time is spotty at best, and our batch window is about to explode. We want to reduce the amount of data kept online, but our main obstacle is cost-justifying a project when there is no obvious problem. Princeton Softech has a model to cost-justify their product (Archive for DB2), but it is based on CPU upgrade avoidance, which will [...] 22674 43 66_Re: S/390 database app wins scalability honors; Oracle cries fou l15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Wed, 21 Feb 2001 20:03:52 -0500510_iso-8859-1 Thanks to everyone. It was some proxy setting problem.

-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Wednesday, February 21, 2001 06:33 PM To: DB2-L@RYCI.COM Subject: Re: S/390 database app wins scalability honors; Oracle cries fou l



Hello Sibimon,

I can read it as long as I put the URL back together.

The copy of the message in my inbox from James had the URL split up. I suspect the listserv may have done that. [...] 22718 65 66_Re: S/390 database app wins scalability honors; Oracle cries fou l15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 22 Feb 2001 11:26:29 +1100664_- Try adding 2,00.html to the URL. The last bit was chopped off. Interesting article. Go DB2!



Raymond

> -----Original Message----- > From: Philip, Sibimon [SMTP:SPhilip@CSXLINES.COM] > Sent: Thursday, 22 February 2001 11:15 am > To: DB2-L@RYCI.COM > Subject: Re: S/390 database app wins scalability honors; Oracle cries > fou l > > Could anybody ready this. I could not? Is this URL correct? > > -----Original Message----- > From: James Campbell [mailto:James.Campbell@HANCORP.COM.AU] > Sent: Tuesday, February 20, 2001 07:00 PM > To: DB2-L@RYCI.COM > Subject: FYI: S/390 database app wins scalability honors; Oracle cries > fou l > > > [...] 22784 226 40_Re: Question for DB2 systems programmers8_ritu zee22_ritu_98_2000@YAHOO.COM31_Wed, 21 Feb 2001 18:03:39 -0800560_us-ascii Thanks a lot Cathy, Linda and other esteemed listers for replying to my query.

Ritu.

--- "Billings, Linda" wrote: > Well said! I have to agree with all of your points. > A book that I > recommend to people who are new to systems and > OS/390 and all of its > subsequent incarnations is Exploring IBM S/390 > Computers by Jim Hoskins and > George Coleman ($39.95). It is a nice overview of > an IBM OS/390 system and > all of its accoutrements. The 7th edition has just > come out. If you want > one [...] 23011 54 44_questions for update / insert into db2 table9_Long Qian21_qianl@IHPC.NUS.EDU.SG31_Thu, 22 Feb 2001 09:56:26 +0800534_us-ascii Hello, everybody

I am a new comer for db2 and while doing my project I meet following problems which I hope I can get some help from your experiences.

I had a transaction database from a local retailer contains 2.85 million records and I try to load and process with db2 version 5 running on a 4 nodes IBM sp2 machine. I can load the db successfully but when I try to add one new column and set value to that column via update command, I got the prompt " transaction log full ". Actually I want to set the [...] 23066 60 29_Archive and Purge of DB2 data22_drdeath@ozemail.com.au22_drdeath@OZEMAIL.COM.AU31_Thu, 22 Feb 2001 02:45:43 "GMT"653_us-ascii Cathy,

Sorry I am not helping with this. We have exactly the same problem (except we are at V6.1). I'd be very keen to see any responses you get to this. And if we come up with anything, I'll let you know.

Cheers

Tony Mitchell Dinkum Software Solutions

---- original message ---- Sent: Wed, 21 Feb 2001 16:57:57 -0800 From: Cathy.Taddei@PACIFICORP.COM To: Cc: Subject: Archive and Purge of DB2 data -------------------------- Greetings, listers. We have one major and several lesser applications on our DB2 5.1 CICS 4.1 OS/390 2.7 system which were designed without any facility to archive and [...] 23127 75 10_Re: DSSIZE15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Thu, 22 Feb 2001 13:13:08 +1100582_- Dear list,

Please ignore if you've already received this. I got a message saying my original post was rejected because it had already been sent. Don't think it was, but you never know. Anyway, ignore if you wish.

Raymond





Now where were you 2-3 weeks ago when I was trying to sort out why LoadPlus was AbEnding trying to load up one of these tablespaces? Yes the DSSIZE was <=4Gb and yes the clusters were EA-enabled. Yes, the loads ran fine unless they wanted to extend beyond the volume they were already on. I had 9 TSs; one had DSSIZE [...] 23203 15 48_Re: questions for update / insert into db2 table11_Qinghua Cao20_cao_qh@HISUNTECH.COM31_Thu, 22 Feb 2001 11:15:20 +0800158_iso-8859-1 I'm not sure, but try to unload the data from the table first, then update the table structure, then load the data with LOG NO optionl.

Lily 23219 86 19_Re: Recovery JCL...14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 22 Feb 2001 15:23:25 +1100436_iso-8859-1 Why do you have DYNAMNBR.DSNUPROC=3000? TIOT(64) allows _at most_ 3273 DD statements, which allows only 273 after provision is made for the 3000 dynamic statements.

/* standard disclaimer */ James Campbell Hansen Corporation -----Original Message----- From: Cuneyt Goksu (Garanti Teknoloji) [mailto:CuneytG@GARANTI.COM.TR] Sent: Thursday, 22 February 2001 2:22 To: DB2-L@RYCI.COM Subject: [DB2-L] Recovery JCL... [...] 23306 172 50_Re: Error Handling in Triggers & Stored Procedures14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Wed, 21 Feb 2001 22:49:15 -0600731_iso-8859-1 Sorry Bruce, but that is not supported in the SQL Procedure Language, nor is it supported in SQLJ for Java (Yet).



Regards, Richard

Richard Yevich - Principal Yevich Lawson & Assoc. Inc. (YL&A) Richard_Yevich@YLAssoc.com 1-888-246-5049/1-217-744-0000 http://www.YLAssoc.com -- DB2 Performance Journal http://www.db2-symposium.com -- DB2 Symposiums



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Bruce W Williamson > Sent: Wednesday, February 21, 2001 6:14 PM > To: DB2-L@RYCI.COM > Subject: Re: Error Handling in Triggers & Stored Procedures > > > Howzit Dave? > > Use EXEC SQL INCLUDE SQLCA to include SQLCA in your SP. [...] 23479 87 19_Re: Recovery JCL...32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Thu, 22 Feb 2001 07:54:33 +0200484_- As far as i know, 255 Limit is for Step count for each JCL.



Cuneyt GOKSU Garanti Teknoloji Tel : 0090-212-4783210 mailto:Cuneytg@garanti.com.tr





-----Original Message----- From: David Williams [mailto:David.Williams@DOL.STATE.GA.US] Sent: Wednesday, February 21, 2001 6:25 PM To: DB2-L@RYCI.COM Subject: Re: Recovery JCL...



I think at one time there was a limit of 255 DDs in a job step. I do not know if this is still true. [...] 23567 85 14_Re: Query Help16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 22 Feb 2001 11:39:02 +0530517_- Terry, Sorry for again questioning on your answer but looking at the two queries given below and your response(rather a particular sentence of your response....i would not have asked otherwise) i.e "If the join to TCLINICC introduces duplicate C_DEPT records then these two queries are not equivalent" . If at all this is correct then what will be the difference in result ??. I think for understanding this i need to first understand what will be the result of this query in the enviornment in which it runs. [...]