1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l June 2001, week 4 2 115 24_Re: ACCESS PATH QUESTION13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Fri, 22 Jun 2001 00:05:55 -0500352_iso-8859-1 James,

I am not aware of any effort by IBM to disable the usage of "OR 0=1" as has been done with the non-OS/390 optimizer (which discards this). This technique has been well documented and therefore I would be surprised if suddenly IBM decided to alter it's effectiveness. Please let me know if you have heard otherwise though. [...] 118 17 41_Focus Database to DB2 conversion strategy29_ISRAEL SIRISH David Alexander20_DIsrael@COVANSYS.COM31_Fri, 22 Jun 2001 03:31:58 -0400388_- Hi all, Can you help me in giving the best approach to convert the Data from Focus 6.5 database to DB2 ver 5.1?

Thanks in advance, Sirish

================================================ 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. 136 20 17_DB2 versus ADABAS11_Mohamed Beg19_mohamedb@ABSA.CO.ZA31_Fri, 22 Jun 2001 10:23:55 +0200393_iso-8859-1 Hi.

Can anybody supply me with a benchmark between Adabas and DB2 on S390.

MOHAMED BEG DATABASE ADMIN AND SUPPORT DEPT DB2 DBA

================================================ 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. 157 33 21_AW: DB2 versus ADABAS12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 22 Jun 2001 10:46:28 +0200762_iso-8859-1 Mohamed,

which ADABAS do you mean ? Are you talking about ADABAS C (the "classic" ADABAS system that works with NATURAL) or ADABAS D (a newer SQL-like RDBMS from Software AG, that Software AG bought some years ago) ?

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 ---------------------------------------------------------------------- [...] 191 17 41_Focus Database to DB2 conversion strategy29_ISRAEL SIRISH David Alexander20_DIsrael@COVANSYS.COM31_Fri, 22 Jun 2001 04:55:51 -0400396_- Hi all, Can you help me in giving the best approach to convert the Data from Focus 6.5 database to DB2 ver 5.1 on S390?

Thanks in advance, Sirish

================================================ 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. 209 54 17_DB2 versus ADABAS11_Mohamed Beg19_mohamedb@ABSA.CO.ZA31_Fri, 22 Jun 2001 11:01:48 +0200572_iso-8859-1 Hi Peter

The ADABAS I was referring to was ADABAS C that works with NATURAL on S390.

Thanking you in advance. Mohamed Beg

----- Original Message ----- From: Peter, Georg Newsgroups: bit.listserv.db2-l To: Sent: 22 June 2001 10:46 Subject: AW: DB2 versus ADABAS



Mohamed,

which ADABAS do you mean ? Are you talking about ADABAS C (the "classic" ADABAS system that works with NATURAL) or ADABAS D (a newer SQL-like RDBMS from Software AG, that Software AG bought some years ago) ? [...] 264 18 18_Re: Sample Scripts9_Chris Tee23_chris.tee@UK.ZURICH.COM31_Fri, 22 Jun 2001 10:00:44 +0100495_us-ascii I've had a few requests to post the sample scripts from the UDB 7.1 Performance redbook that I've managed to get working, on DB2-L-DOCUMENTS. Could someone from IBM confirm that is is OK legally for me to do this.

Thanks

Chris Tee

================================================ 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. 283 118 38_Re: FW: Conditional Insert in triggers11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Fri, 22 Jun 2001 13:09:00 +0200455_us-ascii Hi Ritesh,

I hope I have understood correctly what you want ...

I worked out a solution, it is not very pretty, but it works for your case, and it is only one trigger, no udf/stored proc...

I constructed a working example, from which you can deduce the statement for your case.

Let the triggered table be T1(a char(1)). After an insert into T1 you want to insert some values into the table TRIG(a char(5), b int) [...] 402 28 34_Re: Conditional Insert in triggers15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 22 Jun 2001 06:19:40 -0500391_- Hi Shery

Here is an example of a trigger with a CASE-expression (I just created successfully)

CREATE TRIGGER DB2.ISTU0261 AFTER UPDATE ON DB2.ISTB0261 REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC INSERT INTO DB2.WJ (SPALTE_1) SELECT CASE WHEN N.PROGNAME = 'ISHA054' THEN '54' WHEN N.PROGNAME = 'ISHA074' THEN '74' ELSE '00' END FROM SYSIBM.SYSDUMMY1 ; END [...] 431 31 34_Re: Conditional Insert in triggers15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 22 Jun 2001 06:25:29 -0500313_- Hi Swmish

If that is the condition:

if (condtion1) then insert into t1 value v1 else ( if (condition2) - If condition2 then insert then insert into t1 value v2 endif insert into t1 value v3 - insert always if condition1 is false ) endif

then that will be the transformation into CASE: [...] 463 50 46_Re: Unsuccessful Call of DB2 Stored Procedures11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Fri, 22 Jun 2001 13:44:14 +0200373_us-ascii Hi Maryann,

Is your SP called with its qualified name (schema.SP-name) ? If yes, then I have no idea.

If not: Is its schema name included in the CURRENT FUNCTION PATH special register? If you do not set it explicitly, it contains the schema names SYSIBM, SYSFUN, and the userid under which the program runs (value of the USER special register). [...] 514 193 26_Re: Another Oracle barrage15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 22 Jun 2001 06:49:23 -0500557_iso-8859-1 So I can surmise from the discussion so far that Oracle uses a form of optimistic locking. Now am I understanding it correctly that the meaning of database in Oracle-land is different from the definition of a database in DB2-land? In DB2-land a subsystem can have several databases and in Oracle-land there is only one database? Is there one log per database and that is equivalent to DB2's log for the subsystem? It seems that there is a lot of reading of the logs going on in order to make sure that only committed data is read. Is that a [...] 708 30 52_Re: FW: Conditional Insert in triggers - Fix 1.0 :-)11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Fri, 22 Jun 2001 13:54:58 +0200400_us-ascii Ooops,

I made a mistake (a usual Copy&Paste-error) - Fix 1.0 is coming:

The text in error is:

v1 : cond_v1 := condition1 v2 : cond_v1 := (not condition1) and condition2 v3 : cond_v1 := not condition1

the correct one is (of course, the numbers):

v1 : cond_v1 := condition1 v2 : cond_v2 := (not condition1) and condition2 v3 : cond_v3 := not condition1 [...] 739 134 24_Re: ACCESS PATH QUESTION16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 22 Jun 2001 08:43:32 -0400674_iso-8859-1 We are at V7 maint level 150. The 'or 0=1' is still working for us.

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Friday, June 22, 2001 1:06 AM To: DB2-L@RYCI.COM Subject: Re: ACCESS PATH QUESTION



James,

I am not aware of any effort by IBM to disable the usage of "OR 0=1" as has been done with the non-OS/390 optimizer (which discards this). This technique has been well documented and therefore I would be surprised if suddenly IBM decided to alter it's effectiveness. Please let me know if you have heard otherwise though. [...] 874 57 26_Re: Another Oracle barrage12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Fri, 22 Jun 2001 07:45:33 -0500347_us-ascii Yes, there is one log per Oracle database and yes, that is equivalent to a DB2 subsystem.

No, the Oracle logs are write-only (except for recovery). Others have mentioned Oracle's "rollback segments". These have two purposes: 1) hold the "before" image of the changed data in case of rollback 2) provide the "read consistency" [...] 932 17 19_UDB on AIX 5L V5.1?11_Judy Kibler21_judith.kibler@TRW.COM31_Fri, 22 Jun 2001 07:52:49 -0500363_us-ascii Hello all!

Does anyone know if DB2 UDB is certified to run on AIX 5L V5.1 yet?

Thanks, Judy Kibler

================================================ 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. 950 33 39_DB2 7.1 Utilities - IBM or Third Party?0_22_BILL_GALLAGHER@PHL.COM31_Fri, 22 Jun 2001 09:04:16 -0400321_us-ascii A question/survey for the list:

Has anybody gone to DB2 v7.1 on OS/390 and NOT purchased the IBM DB2 utilities, which are now unbundled from the core DB2 product? Has anybody seriously looked at or considered going with a complete third-party set of utilities as an alternative to the IBM utilities? [...] 984 116 26_Re: Another Oracle barrage15_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Fri, 22 Jun 2001 09:25:02 -0400814_iso-8859-1 Here is some facts:

IBM Offers DB2 on Linux Supporting InfiniBand; Direct Access File Support; DB2 on Itanium Showcasing three new, database technology firsts, IBM offers DB2 database software running on Linux 2.4 and supporting the InfiniBand architecture for high-speed connections; database software running against the new, Direct Access File System; and DB2 support for new, Itanium-based systems. Database Software: Identical Tests on Same IBM Hardware Show DB2's Superior Results over Oracle Hardware vendors rarely use the same hardware configuration to provide benchmark results about competing database software. But an IBM eServer pSeries 620 (6 x 668 MHz) [...] 1101 56 43_Re: DB2 7.1 Utilities - IBM or Third Party?16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Fri, 22 Jun 2001 09:28:06 -0400538_iso-8859-1 We considered acquiring the additional utilities we would require from an OEM vendor rather than purchase the IBM ones. However, our unpleasant experiences with OEM utilities and the support thereof has made us commit to the use of IBM utilities only as our long term solution.

Regards. eric pearson





-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Friday, June 22, 2001 9:04 AM To: DB2-L@RYCI.COM Subject: DB2 7.1 Utilities - IBM or Third Party? [...] 1158 143 38_Re: FW: Conditional Insert in triggers13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Fri, 22 Jun 2001 18:39:25 +0500472_iso-8859-1 Hi Bela,

Thanks for you help. I think this is should resolve my problem.

regds, Ritesh

-----Original Message----- From: Hamar, Bela To: DB2-L@RYCI.COM Sent: 06/22/2001 4:09 PM Subject: Re: FW: Conditional Insert in triggers

Hi Ritesh,

I hope I have understood correctly what you want ...

I worked out a solution, it is not very pretty, but it works for your case, and it is only one trigger, no udf/stored proc... [...] 1302 76 43_Re: DB2 7.1 Utilities - IBM or Third Party?0_20_John_Lendman@FPL.COM31_Fri, 22 Jun 2001 09:38:01 -0400327_us-ascii Bill, something that I heard at SHARE it that a lot of the third party tools use some of the IBM tools under the covers. And if you do not purchase the IBM tools, that some of the third party tools stop working. I have not verified this, but this was mention more that once at SHARE in Longbeach. Just a thought. [...] 1379 142 43_Re: DB2 7.1 Utilities - IBM or Third Party?14_Johnson, Daryl28_Daryl.Johnson@PACIFICORP.COM31_Fri, 22 Jun 2001 06:45:38 -0700562_iso-8859-1 Eric,

What 3rd party tools did you have and what problems did you encounter?

I am currently experiencing problems with Platinum tools and I am also looking at IBM when we move to v7.?..

Thanks,

Daryl (DJ) Johnson DBA Work Phone: 503.813.5451 Cell Phone: 503.706.6391 Pager: 503.202.4775 Home Phone: 503.632.4719



-----Original Message----- From: Pearson, Eric L, [mailto:Eric.Pearson@NSCORP.COM] Sent: Friday, June 22, 2001 6:28 AM To: DB2-L@RYCI.COM Subject: Re: DB2 7.1 Utilities - IBM or Third Party? [...] 1522 22 29_Db2 Connect 6.1 AND code page14_Bilal YILDIRIM25_byildirim@HALKBANK.COM.TR31_Fri, 22 Jun 2001 16:50:53 +0300406_iso-8859-9 Hi,

I am using Db2 connect 6.1 and connect to db2 from visual basic with odbc but I have a problem with codepages Db2 connect language is english, but I cant see the turkish characters and I see translation dll and translation option in db2 connect properties can I change or insert another dll or Can I change the codepage to turkish without reinstalling db2 connect please help me [...] 1545 102 43_Re: DB2 7.1 Utilities - IBM or Third Party?24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Fri, 22 Jun 2001 07:46:10 -0700444_- Hi John!

The IBM utility suite only includes the utilities that are also available from a 3rd part vendor. The utilities for which there is no 3rd party equivalent are all still included in the base product. As I understand it, some of the 3rd party utilities do still call some IBM utilities under the covers, but it is generally only those that are included in the IBM DB2 version 7 upgrade, and not the separate utility suite. [...] 1648 77 24_one question about index5_larry17_elibs@NETEASE.COM31_Fri, 22 Jun 2001 23:11:58 +0800425_gb2312 hi,list: I have a question about index. I have a SQL: SELECT * FROM T1 WHERE COL1 = xxxxx AND COL2 = yyyy; and two indexes: TI2 on T1(COL1,COL2) ,TI1 on T1(COL2,COL3).When I use EXPLAIN TABLE to explain the SQL,I found that the MATCHCOL = 1 and the INDEXNAME=TI1 .I wonder why it doesn't use TI2 but TI1.Could someone kindly help me? The clusterratio of TI1 is 77 and TI2 is 99,I have no idea whether it matters. [...] 1726 123 43_Re: DB2 7.1 Utilities - IBM or Third Party?12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 22 Jun 2001 10:19:43 -0500419_iso-8859-1 What about modify? This is a purchase program from IBM and is called by third party programs to complete their processes.

Gerald Hodge HLS Technologies, Inc

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Leblanc, Francis C - CNF Sent: Friday, June 22, 2001 9:46 AM To: DB2-L@RYCI.COM Subject: Re: DB2 7.1 Utilities - IBM or Third Party? [...] 1850 47 25_DB2 Digest in HTML Format14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Fri, 22 Jun 2001 08:27:56 -0700109_- If anyone is having a problem with this please send me an email. Phil



Assoc List Owner DB2-L 1898 137 43_Re: DB2 7.1 Utilities - IBM or Third Party?15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 22 Jun 2001 10:28:58 -0500417_iso-8859-1 I think that one was a big OOOOPS. We found that out, too.

Linda

-----Original Message----- From: Gerald Hodge [mailto:ghodge@ATTGLOBAL.NET] Sent: Friday, June 22, 2001 10:20 AM To: DB2-L@RYCI.COM Subject: Re: DB2 7.1 Utilities - IBM or Third Party?



What about modify? This is a purchase program from IBM and is called by third party programs to complete their processes. [...] 2036 80 40_Re: DB2 7.1 Utilities - IBM or Third Par64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Fri, 22 Jun 2001 10:33:40 -0500307_ISO-8859-1 Fritz, what you said is what IBM said, and what IBM continues to say, but that is not what IBM did.

Specifically, the Modify utility, as provided by IBM, is not available from a 3rd party vendor. However, to get it, you have to buy it in the Diagnostic and Recovery Suite. Go figure. [...] 2117 139 43_Re: DB2 7.1 Utilities - IBM or Third Party?15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Fri, 22 Jun 2001 10:34:33 -0500354_iso-8859-1 Correct for BMC. We do the syscopy cleanup but rely on the IBM modify for the DBD and SYSLGRNGX cleanup.

Andy Lankester bmcsoftware My opinions are just that -----Original Message----- From: Gerald Hodge [mailto:ghodge@ATTGLOBAL.NET] Sent: 22 June 2001 16:20 To: DB2-L@RYCI.COM Subject: Re: DB2 7.1 Utilities - IBM or Third Party? [...] 2257 106 40_Re: DB2 7.1 Utilities - IBM or Third Par15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Fri, 22 Jun 2001 10:49:19 -0500414_iso-8859-1 My colleague, who is working on installing V7, is going to make the recommendation that we purchase the Diagnostic and Recovery Suite and the modify utility is one of the reasons. I don't know what the other reasons are. He hasn't shared yet.

(Hi, Todd, How is it going?)

Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services [...] 2364 93 28_Re: one question about index14_Earl Armstrong29_Earl.Armstrong@PROTECTIVE.COM31_Fri, 22 Jun 2001 10:52:30 -0500435_iso-8859-1 I'm a newbie, but my first question would be:

How are your columns defined and what do xxxx and yyyy look like? It's possible that one of your host variables doesn't match it's corresponding column definition.



Earl Armstrong







larry cc: Sent by: DB2 Subject: one question about index Data Base Discussion List [...] 2458 171 34_Re: Db2 Timeout & Deadlock Problem14_Scott Saunders20_ssaunders@SIEBEL.COM31_Fri, 22 Jun 2001 09:05:47 -0700326_iso-8859-1 Murphy; Are lock escalations taking place? You might look into increasing the size of LOCLIST. Is DB2_RR_TO_RS in place? Run db2set -all from the command line to find out.

There is a db2eug email group just for the Unix/NT/Linux/OS2 flavors of DB2. You might get additional responses if you post there. [...] 2630 28 15_Design question14_Kunjar Bhaduri28_Kunjar.Bhaduri@FIRSTDATA.COM31_Fri, 22 Jun 2001 11:41:18 -0400444_us-ascii Hello everybody, We are trying to redesign an existing "hierarchy" structure. What we have is set of tree-like structures with elements which are common and not common across the hierarchy types. Here's an explanation with a few dummy numbers & letters. Hope this explains the problem.

We have 4 hierarchy types in all. We need to fit all of them into a database design in DB2. (Embedded image moved to file: pic07711.pcx) [...] 2659 214 43_Re: DB2 7.1 Utilities - IBM or Third Party?12_tim malamphy20_timalamphy@YAHOO.COM31_Fri, 22 Jun 2001 09:15:48 -0700542_us-ascii Are we sure not including modify for free was an ooops? Or is it a strategic "let's see how the 3rd parties deal with this" type of trial balloon? It would be interesting to know the strategies of the 3rd party players. Would any of you gentlemen care to comment? Are you going to have your own "modify" facility? If not, you're going to have to provide even more benefits over IBM's than before to justify additional costs. If you do, it's a lot of R&D and maintanence costs that the customer isn't going to see a lot of value [...] 2874 25 15_DB2LOOK command10_Mathai Joy22_mathaijoydb2@YAHOO.COM31_Fri, 22 Jun 2001 09:24:22 -0700427_us-ascii Is it true DB2LOOK command only work from sever and not from the client. Here I am trying to generate DDL statement for one of my table. I did manage to create from server. But when I issue the same command from client it fails.

Thanks,

Mathai

__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ [...] 2900 13 34_Re: Db2 Timeout & Deadlock Problem15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Fri, 22 Jun 2001 11:17:14 -0500345_us-ascii How do you get on the db2eug e-mail group? I'd be interested. Or who do you send the email to?

================================================ 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. 2914 53 19_Re: Design question18_Pudukotai, Nagaraj35_Nagaraj.Pudukotai@BLR.HPSGLOBAL.COM31_Fri, 22 Jun 2001 21:56:15 +0500620_- Look at chapters 28, 29 and 30 in "SQL for smarties : Advanced SQL programming" by JOE CELKO.

Nagaraj

> -----Original Message----- > From: Kunjar Bhaduri [SMTP:Kunjar.Bhaduri@FIRSTDATA.COM] > Sent: Friday, June 22, 2001 9:11 PM > To: DB2-L@RYCI.COM > Subject: Design question > Importance: High > > Hello everybody, > We are trying to redesign an existing "hierarchy" structure. > What > we have is set of tree-like structures with elements which are common and > not common across the hierarchy types. Here's an explanation with a few > dummy numbers & letters. Hope this explains the problem. > > [...] 2968 31 26_DEADLOCK ON PACKAGE REBIND13_Doyle, Ingell21_DoyleI@UIHC.UIOWA.EDU31_Fri, 22 Jun 2001 12:54:29 -0500387_iso-8859-1 I'm having a deadlock problem with BIND, REBIND, DROP, FREE a package DSNT500I -DB2T DSNTBFR2 RESOURCE UNAVAILABLE REASON 00E30083 TYPE 00000801 NAME MVS .DBABB11 .16C0B743113C2D34 The package is executed from batch plan, and I know the pgm cannot be executing in order to BIND, REBIND, etc., but it is not. Any suggestions for freeing up this situation would be helpful [...] 3000 138 28_Re: one question about index22_Claudio Meluzzi Mendes18_p000002@BEG.COM.BR31_Fri, 22 Jun 2001 14:50:41 -0300476_gb2312 Larry,

Maybe the filter factor of T11 (COL2) is better than that of T12. Which one has more more distinct values, COL1 or COL2? If COL2 has the greatest amount of distinct values this can be the reason of DB2 choosing T11 as the index for your query.

Claudio ********************************************** * Claudio Meluzzi Mendes * claudio@beg.com.br * Banco do Estado de Goias * Goiania - GO - BRASIL ********************************************** [...] 3139 130 43_Re: DB2 7.1 Utilities - IBM or Third Party?0_21_db2_dba@BELLSOUTH.NET31_Fri, 22 Jun 2001 13:55:08 -0400594_us-ascii Also, you will be able to run IBM utilities on SYSIBM objects even if you don't pay for them. At 10:19 AM 6/22/01 -0500, you wrote: >What about modify? This is a purchase program from IBM and is called by >third party programs to complete their processes. > >Gerald Hodge >HLS Technologies, Inc > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of >Leblanc, Francis C - CNF >Sent: Friday, June 22, 2001 9:46 AM >To: DB2-L@RYCI.COM >Subject: Re: DB2 7.1 Utilities - IBM or Third Party? > > >Hi John! > > The IBM utility suite only [...] 3270 45 34_Re: Db2 Timeout & Deadlock Problem14_Scott Saunders20_ssaunders@SIEBEL.COM31_Fri, 22 Jun 2001 10:56:56 -0700267_iso-8859-1 Dan; Here is the trailer that we get with DB2EUG (enterprise users group). I think if you send 'subscribe' it's adds you but I've been a member for so long that I cannot remember. If none of this works, drop me a note and I'll ping the group for you. [...] 3316 76 30_Re: DEADLOCK ON PACKAGE REBIND0_20_John_Lendman@FPL.COM31_Fri, 22 Jun 2001 14:12:05 -0400482_us-ascii Could the deadlock be on the catalog. I know it says different on the error message, but it looks like this is a test system and it might be busy with binds/rebinds. Have you tried it a different times?



John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413





"Doyle, Ingell" To: DB2-L@RYCI.COM Subject: DEADLOCK ON PACKAGE REBIND Sent by: "DB2 Data Base Discussion List" [...] 3393 40 34_Re: Db2 Timeout & Deadlock Problem0_26_Steve.Westfall@EQUIFAX.COM31_Fri, 22 Jun 2001 13:16:07 -0500540_us-ascii There is info on db2eug at http://users.vnet.net/sirdug/db2links.html.

Steve Westfall Equifax, Inc.







Daniel Sullivan cc: Sent by: DB2 Data Subject: Re: Db2 Timeout & Deadlock Problem Base Discussion List



06/22/2001 11:17 AM Please respond to DB2 Data Base Discussion List









How do you get on the db2eug e-mail group? I'd be interested. Or who do you send the email to? [...] 3434 200 29_Re: Question on SQL procedure23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 22 Jun 2001 14:15:48 -0400338_iso-8859-1 Richard,

I am saving the SQLCODE immediately after execution of an SQL through handler. Something like

DECLARE CONTINUE HANDLER FOR SQLEXCEPTION IF (1=1) THEN SET sqlst = SQLSTATE; SET sqlcd = SQLCODE; /* I know that this SET statement will always return 0 */ SET sql_excp_ind = 1; SET returncd = 3; END IF; [...] 3635 22 43_Re: DB2 7.1 Utilities - IBM or Third Party?12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 22 Jun 2001 13:48:14 -0500582_- >Would anybody on the list from IBM (Roger Miller/Jim Ruddy?) be willing to >share any statistics about v7.1 customers and how many have or have not >purchased the utilities?

We don't have any reliable statistics on this yet. It may be easier to talk with your vendors about the specifics of the products you have, the functions of V7 you want to use, what you need to install for service and any other prerequisites. We don't know exactly what the vendors and business partners do. The complete picture is both complex and changing over time. Sometimes we find a few [...] 3658 12 34_Re: Db2 Timeout & Deadlock Problem15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Fri, 22 Jun 2001 14:11:08 -0500277_us-ascii Thanks I'll give it a try.

================================================ 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. 3671 72 12_DSNREXX -80512_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 22 Jun 2001 14:31:39 -0500364_us-ascii Hello, OS/390 V2R10 DB2 UDB 6.1 Refresh here.

I execute the following Rexx under TSO, (there's more, but this is the relavant part I think):

SQLSTMT = "CONNECT" ADDRESS DSNREXX SQLSTMT DBT1 IF SQLCODE < 0 THEN CALL SQLPROB;

SQLSTMT = "DECLARE C10 CURSOR FOR S10" ADDRESS DSNREXX EXECSQL SQLSTMT IF SQLCODE < 0 THEN CALL SQLPROB; [...] 3744 80 29_Re: Question on SQL procedure14_Richard Yevich26_Richard_Yevich@YLASSOC.COM31_Fri, 22 Jun 2001 15:03:18 -0500332_iso-8859-1 Instead of the if (1=1) change to a REPEAT and use the SELECT instead of the set to move the 2 values into your variables. It is not a bug on IBM's part, just what I consider poor example of how to do it in the Redbook.

Based on what others are doing, and using your example, something like this should work: [...] 3825 21 43_Re: DB2 7.1 Utilities - IBM or Third Party?0_17_JTonchick@AOL.COM29_Fri, 22 Jun 2001 16:21:16 EDT565_US-ASCII I tried asking our local BMC reps if they had a "package" that would substitutes for the basic default utilities that make up the DB2 Utility Suite, but they said that their products "extend" the default utilities and need them to execute. No cost savings there.

I think that a lot of the small-medium sized DB2 shops will stay on or migrate to V6 unless the "just have to have" a unique feature of V7. In the long run, IBM will probably be forced to rethink the "unbundling" of the basic utilities. We have until V6 gets dropped from support. [...] 3847 29 39_Effect of ZPARM=PARAMDEG on Parallelism0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 22 Jun 2001 16:07:44 -0500427_us-ascii DB2 V6 for OS390

I've been reading about ZPARM=PARAMDEG . As I understand it is supposed to limit number of parallel execution threads that DB2 will start on a given task. It takes effect when the program is bound with DEGREE=ANY. People on the list have suggested setting it at 1.5 or 2 times the number of CPU's you have available. We currently have only 2, so I was considering setting this value to 4. [...] 3877 88 29_Re: Question on SQL procedure10_Ben Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Fri, 22 Jun 2001 17:13:51 -0400553_us-ascii The purpose of putting the SELECT inside the REPEAT is to be able to do other 'cleanup/housekeeping activity' for the exception while sidestepping the 'no nested blocks' restriction of SPL.

If that is not needed, you can just code the DECLARE with the SELECT.

Richard Yevich wrote:

> Instead of the if (1=1) change to a REPEAT and use the SELECT instead of the > set to move the 2 values into your variables. It is not a bug on IBM's > part, just what I consider poor example of how to do it in the Redbook. > > Based [...] 3966 52 43_Re: DB2 7.1 Utilities - IBM or Third Party?12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 22 Jun 2001 16:11:55 -0500414_iso-8859-1 Linda:

Who's OOOOPS? Both CA and BMC presented themselves as having a Modify, either stand-a-lone or as part of another product. IBM's initial position was they would only move products to the purchase option that had competing products from ISVs. This makes both marketing and legal sense. I remember questioning the validity of the Modify decision and being presented with marketing cant. [...] 4019 94 43_Re: DB2 7.1 Utilities - IBM or Third Party?15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Fri, 22 Jun 2001 16:45:29 -0500318_iso-8859-1 Not sure this made it to the list - done from unregistered home id - apologies if duplicate.

Personal opinion: NO-ONE is going to buy anything exclusively from an ISV that zaps directory spaces to achieve equivalent IBM function. That's what we would have to do to provide full MODIFY RECOVERY. [...] 4114 119 32_Re: DDL Reverse-Engineering Tool8_Sam Park17_sangchoon@ATT.NET31_Fri, 22 Jun 2001 21:44:30 +0000494_- Can you please tell me in more detail how I can get the DDL from control center ??

TIA Sam Park > Check out IBM's Control Center, which I believe is now > part of the OS/390 family too (and free). It will > read the catalog and give you the DDL. It even has a > scheduling system to run the stuff when you want. > The db2look utility (UDB) will also generate DDL . > IBM seems to be adding a lot of functionality to their > tools these days, and as they come with the products, > [...] 4234 39 37_Re: Change tool for UDB on NT and AIX10_Deb Jenson20_deb.jenson@QUEST.COM31_Fri, 22 Jun 2001 16:56:43 -0500708_- On Wed, 20 Jun 2001 15:24:05 -0500, Fred Edgar wrote:

>I would like to have a tool to make changes to UDB objects on NT and AIX. >Something similar to CA's Migrator or BMC's Alter. Does anyone have any >advice or recommendations. I would prefer not to hear from >vendors right now. > Thanks. > > >_________________________________________________________________ >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. [...] 4274 188 40_Re: DB2 7.1 Utilities - IBM or Third Par64_Todd Burch *****************************************************22_tburch@CDBSOFTWARE.COM31_Fri, 22 Jun 2001 19:19:35 -0500649_ISO-8859-1 IBM's change for how they are packaging and pricing utilities, for whatever their motivation was (in no particular order: possible law suit settlement (no first hand knowledge here), attempt to capture additional I.S. dollars (highly suspect, in my opinion, having worked for IBM for several years), attempt to recapture development costs (I don't think they've been losing any money here), or whatever the reason), if it hasn't done anything else, the change certainly has caused a lot of concern and confusion for everybody involved. We're getting calls daily from existing customers, and from shops we haven't spoken to in months [...] 4463 215 34_Re: Db2 Timeout & Deadlock Problem13_Murali Kanaga19_murali@EPIPHANY.COM31_Fri, 22 Jun 2001 20:17:24 -0700600_iso-8859-1 Scott,

How I do I subscribe to db2eug list.

Thx, Murali

> -----Original Message----- > From: Scott Saunders [mailto:ssaunders@SIEBEL.COM] > Sent: Friday, June 22, 2001 9:06 AM > To: DB2-L@RYCI.COM > Subject: Re: Db2 Timeout & Deadlock Problem > > > Murphy; > Are lock escalations taking place? You might look into > increasing the size > of LOCLIST. Is DB2_RR_TO_RS in place? Run db2set -all from > the command > line to find out. > > There is a db2eug email group just for the Unix/NT/Linux/OS2 > flavors of DB2. > You might get additional responses if you post [...] 4679 18 22_On Demand Log Arhiving12_rl_cotterill24_rl_cotterill@BIGPOND.COM31_Sat, 23 Jun 2001 15:30:00 +1000408_us-ascii Hi, Does any one know if the On Demand Log Arhiving feature is to ne made available in UDB V6 (NT/AIX) or do we have to upgrade to V7.



Richard

================================================ 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. 4698 239 34_Re: Db2 Timeout & Deadlock Problem16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Sat, 23 Jun 2001 06:52:49 -0400519_us-ascii You are subscribed to the DB2EUG digest. To receive messages separately, send email to db2eug-request@lists.best.com containing the line: subsingle To unsubscribe, send: unsubscribe









Murali Kanaga on 06/22/2001 11:17:24 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Thomas E. Faglon/Telcordia) Subject: Re: Db2 Timeout & Deadlock Problem [...] 4938 143 26_Re: Another Oracle barrage15_Agarwal, Ashish28_Ashish.Agarwal@HPSGLOBAL.COM31_Sat, 23 Jun 2001 17:31:15 +0530603_- Hii Linda, let me tell what i know. As far as Oracle is concerned, u have one log per database which is equivalent to Db2's subsystem log but that doesnt mean that Oracle has only one database. U can hav multiple databases per instance and and multiple instances too in Oracle just like in DB2. Although Oracle gives more features for DBA's at the database level, but architecture wise I find Db2's heirarchy of Instance->Database better simply because Oracle has no parameters to control all the databases belonging to an Instance. But Db2's environment and configuration parameters both at the [...] 5082 57 43_Re: Effect of ZPARM=PARAMDEG on Parallelism15_Toine Michielse18_vndobtm@US.IBM.COM31_Sat, 23 Jun 2001 20:25:56 +0200765_us-ascii Hello Rohn,

No PARAMDEG will not have any effect on the number of parallel threads started for utilities.

Regards,

Toine Michielse



Rohn.Solecki@MTS.MB.CA@RYCI.COM> on 06/22/2001 11:07:44 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Subject: Effect of ZPARM=PARAMDEG on Parallelism





DB2 V6 for OS390

I've been reading about ZPARM=PARAMDEG . As I understand it is supposed to limit number of parallel execution threads that DB2 will start on a given task. It takes effect when the program is bound with DEGREE=ANY. People on the list have suggested setting [...] 5140 71 30_Re: DEADLOCK ON PACKAGE REBIND14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 24 Jun 2001 03:02:41 -0500611_- Check the xxxxMSTR job log. It will report one of the threads that the deadlock is against.

James Campbell



On Fri, 22 Jun 2001 14:12:05 -0400, John_Lendman@FPL.COM wrote:

>Could the deadlock be on the catalog. I know it says different on the error >message, but it looks like this is a test system and it might be busy with >binds/rebinds. Have you tried it a different times? > > >John C. Lendman >DBA >Jlendman@fpl.com >(561) 694-5085 >Beeper FPL 7413 > > > > "Doyle, > Ingell" To: DB2-L@RYCI.COM > UIOWA.EDU> Subject: DEADLOCK ON PACKAGE REBIND > Sent [...] 5212 15 50_Stig Kongshammer - U0053/SDC is out of the office.16_Stig Kongshammer10_sko@SDC.DK31_Sun, 24 Jun 2001 10:29:21 +0200365_us-ascii I will be out of the office from 24-06-2001 until 29-06-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. 5228 52 32_DB2 connect and stored procedure15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Sun, 24 Jun 2001 13:51:48 -0400481_iso-8859-1 The following stored procedure calls work fine with Grandvu ODBC driver for DB2, but do not work when we call it using DB2 connect odbc driver. Anybody has any idea. Basically I am bring down DB2 when I use Grandvu ODBC driver from WINDOWS 2000 while calling this SP. This does not happen on WINDOWS NT. I want to see the same thing happens with DB2 connect also. It looks like I am not even able to call SP from DB2 connect itself. The error I get on mainframe is [...] 5281 41 34_SQLJ/JDBC Error in Method Describe10_Ben Reches33_Benjamin.Reches@MORGANSTANLEY.COM31_Sun, 24 Jun 2001 14:39:41 -0400336_us-ascii One of our develpers is getting the following error:

Error in Method describe:SQLCODE==> -18 SQLSTATE ==> FFFFF Error Tokens ==> <> at COM.ibm.db2os390.sqlj.jdbc.DB2SQLJJDBCCursor.setError(DB2SQLJJDBCCursor.java:938)

Is there any doc available that explains what a sqlcode-18 means?? 5323 81 19_Re: DB2LOOK command14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Sun, 24 Jun 2001 19:58:20 -0500489_iso-8859-1 Mathai,

It should work fine - I suspect you aren't passing the -i or -w parms from the client.

Type "db2look /?" on the command line to get the syntax list:

db2look Version 5.0

Syntax: db2look -d DBname [-u Creator] [-s] [-g] [-a] [-t Tname1 Tname2...TnameN] [-p] [-o Fname] [-i userID] [-w password] db2look -d DBname [-u Creator] [-a] [-e] [-t Tname1 Tname2...TnameN] [-m] [-c] [-r] [-x] [-l] [-o Fname] [-i userID] [-w password] db2look [-h] [...] 5405 82 36_Re: DB2 connect and stored procedure10_teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 25 Jun 2001 11:15:37 +1000657_us-ascii Sibi,

Have u tried typing the procedure name in uppercase ? That was one of the oversights I had made in the beginning,

Cheers, Kals





-----Original Message----- From: Philip, Sibimon [SMTP:SPhilip@CSXLINES.COM] Sent: Monday, June 25, 2001 3:52 AM To: DB2-L@RYCI.COM Subject: DB2 connect and stored procedure

The following stored procedure calls work fine with Grandvu ODBC driver for DB2, but do not work when we call it using DB2 connect odbc driver. Anybody has any idea. Basically I am bring down DB2 when I use Grandvu ODBC driver from WINDOWS 2000 while calling this SP. This does not happen on [...] 5488 97 12_Linux Quirks11_Rolf Kramer23_RKramer@POWERLAN.COM.AU31_Mon, 25 Jun 2001 14:23:39 +1000448_iso-8859-1 List,

Anyone have a list of differences or recommendations for DB2 on Linux. Have come across a number of strange problems when called to help on Linux/DB2. Checking everything DB2, could not find any problems, and usually it turns out to be one of authority (these guys are using Turbo Linux). Have started on the path to understanding Linux and would appreciate any help to shortcut this process and assist our developers. [...] 5586 35 0_10_Andy Stein22_jbak2009@AMERITECH.NET31_Sun, 24 Jun 2001 00:35:41 -0500672_us-ascii Hi Everyone, I apologize in advance for any inconvenience I may cause. My name is Andy Stein and I am a Technical Recruiter representing a premier software company. I am aggressively recruiting talented consultants and software pros experienced in DB2, Oracle and Informix on multiple platforms and operating systems. This recently formed new division, the Services Group will provide consulting and implementation services around their product line. We are primarily seeking consultants, architects and DBA's with extensive knowledge ofDB2 in an IBM Z/OS environment. Consultants will be based out of home offices when not traveling, and will report to the [...] 5622 25 16_Synonym question13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Mon, 25 Jun 2001 11:04:18 +0500586_- Hi List Members,

Can you tell me if we can have synonyms for Stored Procs ?? I tried doing it but did not work out. I think DB2 allows synonyms for Tables, Views and UDT's only. Could you please confirm if I am right.

regds, RiteshWARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on [...] 5648 29 41_Steen Hansen/DMDATA is out of the office.12_Steen Hansen13_sth@DMDATA.DK31_Mon, 25 Jun 2001 01:01:30 +0200634_us-ascii I will be out of the office from 22-06-2001 until 09-07-2001.



I will respond, to your mail when I return.

Med venlig hilsen / Best Regards

Steen Hansen Systems Programmer Database & Middleware ---------------------------- DMdata a/s Bytoften DK-8240 Risskov Tlf.: +45 8673 5425 Fax: +45 8673 5301 E-mail: mailto:sth@dmdata.dk ----------------------------

================================================ 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. 5678 96 36_Re: DB2 connect and stored procedure0_24_markus.schaub@SYSTOR.COM31_Mon, 25 Jun 2001 08:40:53 +0200319_us-ascii hi sibi

the first thing i do if i', receiving a sqlcode -440 is to check if the user i use to connect to db2 is the same as the schema-name which qualifies the stored procedure name. another reason for the failing call could be a missing execute authorisation for the user on the stored procedure. [...] 5775 41 28_Re: one question about index16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 25 Jun 2001 12:40:24 +0530565_- Hi Larry,

You have to look into the UNIQUERULE and cardinality of the columns involved in both the index. Is the query meant to return one row only ?

Let us know the index stats to give some thoughts.

Regards Sanjeev > -----Original Message----- > From: larry [SMTP:elibs@NETEASE.COM] > Sent: Friday, June 22, 2001 8:42 PM > To: DB2-L@RYCI.COM > Subject: one question about index > > hi,list: > I have a question about index. > I have a SQL: > SELECT * FROM T1 WHERE COL1 = xxxxx AND COL2 = yyyy; > and two indexes: TI2 on T1(COL1,COL2) [...] 5817 52 30_Re: DEADLOCK ON PACKAGE REBIND16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Mon, 25 Jun 2001 12:40:23 +0530630_- If you look at the MSTR message, you can know which plan/packagage it has contention with.

If not, please send the MSTR message to the list.

Regards Sanjeev

> -----Original Message----- > From: Doyle, Ingell [SMTP:DoyleI@UIHC.UIOWA.EDU] > Sent: Friday, June 22, 2001 11:24 PM > To: DB2-L@RYCI.COM > Subject: DEADLOCK ON PACKAGE REBIND > > I'm having a deadlock problem with BIND, REBIND, DROP, FREE a package > DSNT500I -DB2T DSNTBFR2 RESOURCE UNAVAILABLE > REASON 00E30083 > TYPE 00000801 > NAME MVS .DBABB11 .16C0B743113C2D34 > The package is executed from batch plan, and I know the pgm cannot be > [...] 5870 46 29_UDB 6.1 and Online Copy Issue17_Richard Cotterill24_rl_cotterill@BIGPOND.COM31_Mon, 25 Jun 2001 19:29:35 +1000355_us-ascii Hi, I am not sure if I am missing something but I think there is a bit of a hole with the online copy process (it has been fixed in v7) where you have a user connected 24x7.

If you use online copy it is not possible to complete a recover processes using it unless you have the logs that were active at the time of the copy available. [...] 5917 237 17_DB2 versus ADABAS11_Danny Marom19_danny.m@MOSTEAM.COM31_Mon, 25 Jun 2001 12:51:28 +0200387_windows-1255 Hi Mohamed, My company offers migration tools and services from ADABAS to DB2 – we convert the application and the data. Some of our clients run benchmark between ADABAS and DB2 (before and after migration). In general the results were: CPU and DASD - were increased , batch jobs cycle – was decreased. If you need more information please contact us Best regards Danny [...] 6155 15 17_ADDRESS DSNREXX ?18_Robert Grzegorczyk26_rgrzegorczyk@SPINET.COM.PL31_Mon, 25 Jun 2001 12:47:29 +0200341_us-ascii Hi, can sombody tell me what should I do to enable runnig SQL satements from REXX ? Robert

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 6171 54 21_Re: ADDRESS DSNREXX ?17_Massimo Biancucci30_massimo.biancucci@T-SYSTEMS.IT31_Mon, 25 Jun 2001 13:11:24 +0100552_us-ascii Simply install REXX support for DB2 given with no charge on DB2 on OS390 (from DB2 V5 If I'm not wrong).









Robert Grzegorczyk @RYCI.COM> on 25/06/2001 11.47.29

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: ADDRESS DSNREXX ?



Hi, can sombody tell me what should I do to enable runnig SQL satements from REXX ? Robert [...] 6226 87 33_Re: UDB 6.1 and Online Copy Issue0_20_John_Lendman@FPL.COM31_Mon, 25 Jun 2001 07:31:21 -0400323_us-ascii There is an "Archive Log" command in V6. You could use it attached to your on-line image copy to be sure that you would have the most current logs archive.

I use the command "archive log mode quiesce". This will close and flush all the open datasets and create a log. This is part of our Dr procedure. [...] 6314 29 13_DB2 Version 618_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Mon, 25 Jun 2001 07:43:37 -0400459_iso-8859-1 We are currently upgrading our DB2 OS/390 from Version 5 to Version 6. Can anyone point me to some good reading on "Everything you ever wanted to know about IBM's DB2 Version 6 On-line Reorg but were afraid to ask your CA Rep"?? We had to fall back to CA/Platinums P97F because we could not get P99D to work in our shop so I'm know wondering how IBM's on-line reorg works in DB2 V6 and if anyone is using it. Feel free to contact me off-line. [...] 6344 76 21_Re: ADDRESS DSNREXX ?15_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Mon, 25 Jun 2001 08:20:00 -0400405_iso-8859-1 I used to use REXX on the mainframe many years ago, can it be used on SOLARIS or LINUX ? This would be great if a scripting language like REXX were available on those platforms..

Thanks

Rich

-----Original Message----- From: Massimo Biancucci [mailto:massimo.biancucci@T-SYSTEMS.IT] Sent: Monday, June 25, 2001 8:11 AM To: DB2-L@RYCI.COM Subject: Re: ADDRESS DSNREXX ? [...] 6421 84 16_Re: Linux Quirks17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 25 Jun 2001 08:16:57 -0500474_iso-8859-1 Hello Rolf.

We are running DB2 in NT and have also had memory problems as a result. It is so bad that we have to reboot the server almost once a day to clear them up. We opened up a problem with IBM and hopefully we will have a fix soon. As for Linux, we also are playing with it. I have found that anything GUI on linux is quirky, while the command line environment always works. I too have had problems finding good documentation for Linux and DB2. [...] 6506 61 35_SQL proc problem with DB2 v7, help?16_Dylan Vanderhoof20_DylanV@SEMAPHORE.COM31_Mon, 25 Jun 2001 06:34:12 -0700317_iso-8859-1 Ok, I have an issue with a SQL stored procedure and DB2 V7 and I'm at my wits end trying to debug this thing.

The idea is to do a large insert in the stored procedure and return the last generated id and the sqlcode. There's on input variable that gets put directly into the insert statements. [...] 6568 175 32_Re: DDL Reverse-Engineering Tool12_tim malamphy20_timalamphy@YAHOO.COM31_Mon, 25 Jun 2001 06:41:25 -0700514_us-ascii Use the "show sql" button, and then "save script" button. Ex: right click on a table name. right click on "alter". click on "show sql" button. click on "save as script" button, and point the output to a file.



--- Sam Park wrote: > Can you please tell me in more detail how I can get > the > DDL from control center ?? > > TIA > Sam Park > > Check out IBM's Control Center, which I believe is > now > > part of the OS/390 family too (and free). It will > > read the [...] 6744 87 26_Re: Another Oracle barrage11_Bill Happel22_WRHappel@US.FORTIS.COM31_Mon, 25 Jun 2001 09:05:52 -0500457_US-ASCII Hi Ashish. Just to correct a few things. I justed started administrating Oracle. From Oracle class: You can have ONLY ONE database per instance. But you can have multiple instances per database (this is known as Parallel Instances and it used in Oracle Parallel Server (OPS) architecture). You can also have multiple instances/databases per server. Hence: up to Oracle 7.x.y.z, the Oracle instance and database were considered the same thing. [...] 6832 27 49_Application failing with SQLCODE -104 in NET.DATA0_24_ujjwal@LOT.TATASTEEL.COM31_Mon, 25 Jun 2001 19:36:57 +0530556_us-ascii Hi ALL, I have developed an application in NET.DATA which accesses data from DB2 V5.0 .The display of the data is fine but when I tried to UPDATE the displayed data there was a SQL ERROR -104 and the SQLSTATE was 42601 : A character, token, or clause is invalid or missing. I am unable to find where the error lies. I have checked for all the commas , brackets ,date values , numeric values and everything is fine. Previously this data was pumped from LOTUS NOTES thru LOTUS PUMP into a DB2 Table.I have tested this Net.Data application with [...] 6860 123 36_Re: DB2 connect and stored procedure15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 25 Jun 2001 10:17:28 -0400312_- Our schema is TEST and we tried with TEST.MQ0011SP. We got the same error. Also I rebound the DB2 connect package with PATH = 'TEST', so this should enable DB2 to find the correct SP if I do not specify the Schema. I also I have given execute authority to all stored procedure with schema TEST to public. [...] 6984 37 35_Relational Connect and Federated DB20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Mon, 25 Jun 2001 16:02:07 +0200557_iso-8859-1 Hello, I'm working with Db2 UDB 7.1 fixpack3 on NT 4 server. I'm now playing with the Federated Database option of DB2 7.1. If I understood well even some of the features of Relational connect are now integrated in the Core code of the UDB. Am I wrong? Ok, now my problem is: I was able to create wrappers and nicknames from two different DB2 instances on two different platform (NT and AIX) it works perfectly, I can join tables from databases on the two different machines. The problem arose when I tried to create a wrapper to connect to [...] 7022 100 36_Re: DB2 connect and stored procedure15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 25 Jun 2001 10:31:40 -0400497_iso-8859-1 Thanks Kals. This was the problem. When I change the name to upper case it works fine. As usual this list is great.





Thanks to all.

-----Original Message----- From: teldb2kals [mailto:teldb2kals@TELSTRA.COM] Sent: Sunday, June 24, 2001 08:16 PM To: DB2-L@RYCI.COM Subject: Re: DB2 connect and stored procedure



Sibi,

Have u tried typing the procedure name in uppercase ? That was one of the oversights I had made in the beginning, [...] 7123 31 20_DB2 Connect question9_Pam Lynch25_plynch@HASTINGSMUTUAL.COM31_Mon, 25 Jun 2001 09:27:56 -0500505_- We are having trouble with duplicate result sets when calling a stored procedure from a web page through DB2 Connect. If we execute the stored procedure from the web page, and receive the expected results, then click on the web browser's "Back" button, and execute again using the same input parameters, we receive duplicate results. In other words, if the first call returned three rows, the second call will return six rows, executing again with the same input parameters will produce nine rows. [...] 7155 133 26_Re: Another Oracle barrage11_Mike Hately20_MHately@ETECH-UK.COM31_Mon, 25 Jun 2001 15:40:36 +0100378_us-ascii Just chipping in with a further clarification. In Oracle a database can be defined as being the data files which comprise the physical storage. An instance is best defined as the configuration files and (once the instance is started) memory structures used to open those datafiles. Hence a database and instance are usually synonymous to all intents and purposes. [...] 7289 19 0_15_Nadia Dimitrova17_dnady@HOTMAIL.COM31_Mon, 25 Jun 2001 09:35:40 -0500472_- Hi, I bviously came to the states at a time when the labor market is pretty tight. What I like to know is where someone with a 10 years experience on mainframe in DB2 and CICS( as an applications programmer and as a systems programmer) should go to get a job in this market. I asume east coast would be better than west coast? Nadia _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...] 7309 67 39_Re: Relational Connect and Federated DB18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Mon, 25 Jun 2001 10:46:17 -0400389_iso-8859-1 I may be talking apples and oranges here but I thought with DB2 UDB 7 that the Oracle part was not available yet! We have a product called Datajoiner in here and when I asked IBM what the replacement was they said DB2 Connect Version 7 but that it did not support the joins to Oracle yet.. Again, this may not pertain to your question but thought I'd throw it out there... [...] 7377 32 0_15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM31_Mon, 25 Jun 2001 09:36:27 -0500654_iso-8859-1 Midwest...banking.

-----Original Message----- From: Nadia Dimitrova [mailto:dnady@HOTMAIL.COM] Sent: Monday, June 25, 2001 9:36 AM To: DB2-L@RYCI.COM Subject:

Hi, I bviously came to the states at a time when the labor market is pretty tight. What I like to know is where someone with a 10 years experience on mainframe in DB2 and CICS( as an applications programmer and as a systems programmer) should go to get a job in this market. I asume east coast would be better than west coast? Nadia _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com [...] 7410 121 19_Re: DB2LOOK command10_Mathai Joy22_mathaijoydb2@YAHOO.COM31_Mon, 25 Jun 2001 08:13:34 -0700583_us-ascii Greg,

Thanks

Mathai



--- "Palgrave, Greg" wrote: > Mathai, > > It should work fine - I suspect you aren't passing > the -i or -w parms from > the client. > > Type "db2look /?" on the command line to get the > syntax list: > > db2look Version 5.0 > > Syntax: db2look -d DBname [-u Creator] [-s] [-g] > [-a] [-t Tname1 > Tname2...TnameN] > [-p] [-o Fname] [-i > userID] [-w password] > db2look -d DBname [-u Creator] [-a] [-e] [-t > Tname1 Tname2...TnameN] > [-m] [-c] [-r] [-x] [-l] > [-o Fname] [-i userID] [...] 7532 72 53_Re: Application failing with SQLCODE -104 in NET.DATA0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 25 Jun 2001 10:18:20 -0500555_us-ascii Take a look in SQLERRD.5 in SQLCA. It contains the character count from the start of your SQL to where DB2 finally identified a syntax error.

In the example below I mistyped the keyword "FROM". Value of SQLERRD.5, in the last row (DSNT416I) of the example, is '13'. Count 13 char from the start of the SQL (note there are 2 leading blanks) and 13 chars take you to letter "R" in the word "ROM". Note, this count just identifies where DB2 finally figures out there is a syntax error. The actual error may be at some point before that, [...] 7605 47 0_16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 11:22:14 -0400318_iso-8859-1 Labor market is not really tight. It is just that many of the jobs are being brokered via H1B suppliers and the salaries generally available are somewhat depressed as a result. Find a good recruiter. They still have a line on decent jobs. Just don't expect the rapid salary growth of the pre-H1B days. [...] 7653 61 0_10_Andy Stein22_jbak2009@AMERITECH.NET31_Sun, 24 Jun 2001 10:33:30 -0500672_us-ascii Hi Everyone, I apologize in advance for any inconvenience I may cause. My name is Andy Stein and I am a Technical Recruiter representing a premier software company. I am aggressively recruiting talented consultants and software pros experienced in DB2, Oracle and Informix on multiple platforms and operating systems. This recently formed new division, the Services Group will provide consulting and implementation services around their product line. We are primarily seeking consultants, architects and DBA's with extensive knowledge ofDB2 in an IBM Z/OS environment. Consultants will be based out of home offices when not traveling, and will report to the [...] 7715 77 0_15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 25 Jun 2001 10:34:22 -0500420_iso-8859-1 " Even Chicago if you do not mind extreme cold."

It's not THAT cold. Thanks(?) to global-warming the last 5 or so winters in Wisconsin have been pretty mild.

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



"The distance between insanity and genius is measured only by success." James Bond - Tomorrow Never Dies [...] 7793 23 23_Global Temporary Tables13_Keith Gilbert17_kgilbert@CSA1.COM31_Mon, 25 Jun 2001 10:48:17 -0500538_iso-8859-1 Hello All,

I have just begun working with Global Temporary Tables. I have an assumption that I can not confirm through the manuals. Is it true that GTT's are not associated with any specific database?

Thanks

Keith Gilbert DBA Central Service Association Tupelo, MS

================================================ 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. 7817 16 37_Using Visual Basic to Change Password9_Tim Burke21_Tim_Burke@PEPBOYS.COM31_Mon, 25 Jun 2001 10:35:11 -0500471_- Has anyone ever built into a Visual Basic application the capabililities to change a password for DB2 running on OS/390? If so, how was it done? ADO parameters, some kind of DLL, etc...

HELP!

Thank you in advance.

================================================ 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. 7834 66 40_Re: DB2 7.1 Utilities - IBM or Third Par0_17_JTonchick@AOL.COM29_Mon, 25 Jun 2001 11:54:28 EDT372_US-ASCII This (read below) might all be what IBM says to justify what was done, but they are inconsistent in the implementation. Why is it that only the OS/390 based utilities are marketed separately? If IBM wants to project to the marketplace that DB2 is truly the "universal" database, then why are utilities included with all other platforms EXCEPT the mainframe? [...] 7901 184 27_Re: Global Temporary Tables0_24_Bruce.Williamson@PSIR.IE31_Mon, 25 Jun 2001 16:59:16 +0100723_iso-8859-1 Howzit Keith?

Global Temporary Tables are created in DSNDB06.SYSPKAGE.

Cheers Bruce

__________________________________

Bruce Williamson DB2 Database Administrator

Perot Systems Information Resource Computer Centre Cabinteely Dublin 18 Ireland

Bruce.Williamson@psir.ie





-----Original Message----- From: Keith Gilbert [mailto:kgilbert@CSA1.COM] Sent: 25 June 2001 16:48 To: DB2-L@RYCI.COM Subject: Global Temporary Tables



Hello All,

I have just begun working with Global Temporary Tables. I have an assumption that I can not confirm through the manuals. Is it true that GTT's are not associated with any specific database? [...] 8086 37 0_13_Hanne Lyssand10_han@VPS.NO31_Mon, 25 Jun 2001 18:14:37 +0200462_us-ascii "Chicago if you do not mind extreme cold."

"It's not THAT cold. Thanks(?) to global-warming the last 5 or so winters in Wisconsin have been pretty mild."

And if you are from Russia (the name sonded like that ??) I can't expect that the temprature in Chicago is so extreme cold.

Best regards from Norway. (We have commen boarder with Russia and -30 C we is not uncommen. Altough today we have 25 C and is time to hit the beach) [...] 8124 121 41_Re: Using Visual Basic to Change Password13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM31_Mon, 25 Jun 2001 11:20:11 -0500454_iso-8859-1 Tim, if you are using Shadow Direct the way to change your password is to specify oldpassword/newpassword in the connection string of your application, example:

strDSN = "Data Source=NEON;UID=MYUID;PWD=oldpw/newpw"; ' set connection string Set oConnDB2 = Server.CreateObject("ADODB.Connection") oConnDB2.Open strDSN ' open database connection

If you are using DB2 Connect, I found the below information in the DB2 Archives. [...] 8246 57 0_16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 12:23:03 -0400445_iso-8859-1 25C??? You mean Norway has a non-Lutefisk season????

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Hanne Lyssand [mailto:han@VPS.NO] Sent: Monday, June 25, 2001 12:15 PM To: DB2-L@RYCI.COM Subject:



"Chicago if you do not mind extreme cold."

"It's not THAT cold. Thanks(?) to global-warming the last 5 or so winters in Wisconsin have been pretty mild." [...] 8304 52 27_Re: Global Temporary Tables13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Mon, 25 Jun 2001 10:24:15 -0600512_iso-8859-1 I get this from our GTT's. They are "CREATED" rather than "DECLARED". You need to say which flavor you mean.

DT





TYPE DBNAME TSNAME ---- -------- -------- - G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE G DSNDB06 SYSPKAGE

-----Original Message----- From: Keith Gilbert [mailto:kgilbert@CSA1.COM] Sent: Monday, June 25, 2001 9:48 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Global Temporary Tables [...] 8357 56 0_15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 25 Jun 2001 11:34:14 -0500408_iso-8859-1 To all of those Americans who don't get out of the country much (Shame on you): 25C is about 77F. -30 C is about -22F. The two scales converge at some point at lower temperatures and then the Celsius numbers are larger than the Fahrenheit.

Linda

-----Original Message----- From: Hanne Lyssand [mailto:han@VPS.NO] Sent: Monday, June 25, 2001 11:15 AM To: DB2-L@RYCI.COM Subject: [...] 8414 19 25_Transfer of RUNSTATS info14_Toppins, Smike21_smike.toppins@GWL.COM31_Mon, 25 Jun 2001 10:42:52 -0600469_- Does anyone have a way of transferring RUNSTATS information from one subsystem to another (e.g., Prod to Test) that they wouldn't mind sharing?



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

================================================ 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. 8434 42 38_Re: SQLJ/JDBC Error in Method Describe13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Mon, 25 Jun 2001 09:47:30 -0700579_iso-8859-1 ************ Text below copyright 2000 Computer Associates, Inc. *********** -18 CHECK OPTION IS NOT ALLOWED ON NON-UPDATABLE VIEWS

Explanation: You attempted to create a view containing the WITH CHECK OPTION clause to limit update activity against the view, but the view being created is not an updatable view.

User Response: Either remove the WITH CHECK OPTION clause from the CREATE VIEW statement or remove those parts of the CREATE VIEW that caused it to become nonupdatable. The view is nonupdatable if it contains any of the following items: [...] 8477 91 0_12_Mark Granger22_the_grange@MBOX.COM.AU31_Mon, 25 Jun 2001 11:49:03 -0500363_us-ascii Linda, The scales meet at -40. I found this out after (with wind chill) I encountered this in New York a couple of years ago. I must say though, that as an Australian working in Milwaukee last winter didn't feel that *mild* especially with 30 inches of snow on the ground. I suppose I'm just a wimp !!! I'm going somewhere warm this year; Africa !! [...] 8569 108 0_15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 25 Jun 2001 11:59:29 -0500402_iso-8859-1 That was December and that was unusual even by Wisconsin standards! That convinced my husband and I that we finally needed to buy a snowblower. All of our slave labor (the children) has grown up and moved out of the house.

Linda

-----Original Message----- From: Mark Granger [mailto:the_grange@MBOX.COM.AU] Sent: Monday, June 25, 2001 11:49 AM To: DB2-L@RYCI.COM Subject: [...] 8678 92 0_13_Hanne Lyssand10_han@VPS.NO31_Mon, 25 Jun 2001 19:02:07 +0200415_us-ascii Yes now we have "makrell" and strawberry season. And i can asure you that compared to "lutefisk" season it's much easier to axept.

("lutefisk" is for those of you who haven't been in Norway a kind of fish that have been destroyed in a cemical prossess so only Norwegians can eat it. This is together with "rakfisk" a test we put all over guest trough to see if any of their DNA is from Norway) [...] 8771 17 16_Re-sizing tables9_Don Cross20_Don.Cross@TC.FAA.GOV31_Mon, 25 Jun 2001 12:51:59 -0400337_us-ascii Hi all.. When you have defined a table and it is up against its 123 extents limit meaning the system default is too small for this table..what is the best way to handle this situation? Must you drop the table and change the system defaults? I can't find a clear explanation on making the physical size of the table larger. [...] 8789 44 29_Re: Transfer of RUNSTATS info10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Mon, 25 Jun 2001 12:03:24 -0500387_iso-8859-1 I use the Statistics Manager peice of the CA/DB2 Plan Analyzer (formerly known as Platinum Plan Analyzer.) This works pretty good if you are wanting to do just a small number of entities. I have not found a way to tell it a database name and it go get all the statistics associated with the entities in that database; you have to select each individual tablespace/index. [...] 8834 71 0_17_Jeremy Schleicher28_Jeremy_Schleicher@MAY-CO.COM31_Mon, 25 Jun 2001 11:06:02 -0500640_us-ascii What is H1B?





From: "Pearson, Eric L," @RYCI.COM on 06/25/2001 10:22 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject:



Labor market is not really tight. It is just that many of the jobs are being brokered via H1B suppliers and the salaries generally available are somewhat depressed as a result. Find a good recruiter. They still have a line on decent jobs. Just don't expect the rapid salary growth of the pre-H1B days. [...] 8906 55 17_Re: DB2 Version 612_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 25 Jun 2001 20:13:25 +0200470_iso-8859-1 Hi IBM OLR works ok since V5 (with all needed APARS ...) and is even better on V6 due to better parallel tasks. We use it a lot (no budget for 3rd party products) and are happy with it.

Isaac Yassin DBMS & IT Consultant yassini@bezeqint.net

----- Original Message ----- From: "Whittaker, Stephen" Newsgroups: bit.listserv.db2-l To: Sent: Monday, June 25, 2001 1:43 PM Subject: DB2 Version 6 [...] 8962 45 20_Re: Re-sizing tables15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Mon, 25 Jun 2001 12:30:47 -0500389_iso-8859-1 If you are on OS/390, and I assume that you are, you need to alter the primary quantity of the tablespace and then reorganize it. A quick and dirty way to calculate your new primary quantity is to take the number of tracks allocated and multiply by 48K.

Linda Billings Enterprise Systems Programmer State of Wisconsin Department of Administration Info-Tech Services [...] 9008 93 0_16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 13:34:40 -0400494_iso-8859-1 An immigration scam perpetrated by wealthy corporate blankety blanks to suppress salaries by issuing special work visas under the utterly false pretense that there is a shortage of high-tech workers rather than a shortage of high-tech workers willing to work for fast-food wages.

Regards. eric pearson



-----Original Message----- From: Jeremy Schleicher [mailto:Jeremy_Schleicher@MAY-CO.COM] Sent: Monday, June 25, 2001 12:06 PM To: DB2-L@RYCI.COM Subject: [...] 9102 48 20_Re: Re-sizing tables12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 25 Jun 2001 20:33:12 +0200517_iso-8859-1 Hi The size is based upon the parameters of of PRIQTY (primary quantity) and SECQTY (secondary) when you define a Tablespace or an index. You can use alter command to change the values ("alter tablespace mydb.myts priqty ?????? secqty ?????? ;") and run reorg to combine the small extents. You can use DFDSS or FDR or DSN1COPY or REPRO as well(don't forget to stop the TS/IX before and start it after), but you should change the priqty.secqty as well because you need to tell DB2 about the new sizes. [...] 9151 48 20_Re: Re-sizing tables11_Moore, Tony15_TMoore@IKON.COM31_Mon, 25 Jun 2001 13:36:33 -0400350_iso-8859-1 Don, Stop the tablespace. Execute ALTER TABLESPACE db.ts PRIQTY xxxx SECQTY xxxx to increase the size Restart the tablespace Reorg the tablespace

The ALTER will change the size definition of the tablespace in the catalog. The reorg will resize the underlying VSAM dataset to the size specified in the catalog (from the alter). [...] 9200 81 17_Re: DB2 Version 616_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 13:38:18 -0400373_iso-8859-1 We also have had problems with P99D. We are moving more and more to IBM utilities and hope to be off the CA ones before our contract is up for renewal.

We are very please with the IBM Online Reorg. It was good in V5 and is even better (faster, better info, etc.) under V7. Also, vendor support for the only Online Reorg problem we had was very good. [...] 9282 69 20_Re: Re-sizing tables0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 25 Jun 2001 12:45:17 -0500344_us-ascii What version of DB2 are you using and what OS.

For DB2 V6 on OS390

1 - determine current PRIQTY, SECQTY, FREEPAGE, PCTFREE settings, SELECT * FROM SYSIBM.SYSTABLEPART WHERE DBNAME = ???? AND TSNAME = ???;

2 - determine if the FREEPAGE and PCTFREE allocations are reasonable for the table(s) in the tablespace [...] 9352 102 7_Re: H1B11_John Wynton21_jwynton@THEMISINC.COM31_Mon, 25 Jun 2001 13:53:45 -0400438_windows-1252 Jeremy:

A type of visa used mostly by consulting companies to recruit experienced (sometimes not) IT Folks from outside the US. You may have read mention of the H1-B visa annual allocation being increased to counter the "IT Shortage".

Cheers,

John Wynton Senior Account Manager Themis, Inc. Specialists in DB2, CICS & MQSeries Education 1-800-756-3000; 908-233-8900 (Int'l) http://www.themisinc.com [...] 9455 29 16_DB2 V7 Utilities10_Ben Alford21_PA7280@UTKVM1.UTK.EDU29_Mon, 25 Jun 2001 14:14:08 EDT488_US-ASCII For what it's worth, I don't have as much a problem with IBM charging for the V7 utilities as I do with the fact that leasing is not an option. Any product which only comes with a OTC generates a lot more effort and debate in my shop than one which can be leased. Products with large OTC's must be budgeted and justified much differently than those which can be leased. Purchase-only products are mush more likely to be delayed until future budget years or denied outright. [...] 9485 108 27_Re: Global Temporary Tables19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 25 Jun 2001 13:30:01 -0500348_ISO-8859-1 Here's what the good book says, DB2 OS390 V6:

# Before you define a declared temporary table, at least one segmented table

# space must exist in a database that is defined AS TEMP (the TEMP database)

# for the current DB2 subsystem. DB2 does not implicitly create a table # space for declared temporary tables. [...] 9594 26 7_Re: H1B13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Mon, 25 Jun 2001 13:42:42 -0500270_- It's not limited to IT and can be used for any profession where an US employer can get INS to issue the visa. The latest trend has been for hiring maths / science teachers by public schools. Mohammad ( Writing from the no man's land between H1B and Green card !) [...] 9621 57 41_Re: DB2 Batch Checkpoint Restart Products17_nagaraju mudhelli18_mudhelli@LYCOS.COM31_Mon, 25 Jun 2001 12:20:38 -0700695_us-ascii Hi, We were evaluating a product from BMC Application restart control. Initially it looked good but it had lot of limitations. If you want more info. on this send me a email with what information you are looking for.

http://www.bmc.com/products/proddocview.html?id=2005&r=Americas&l=en

Bye Nagaraju Mudhelli

> >> -----Original Message----- >> From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of >> Iris Wilde >> Sent: Tuesday, April 10, 2001 11:45 AM >> To: DB2-L@RYCI.COM >> Subject: DB2 Batch Checkpoint Restart Products >> >> >> Hello List: We're in the process of looking at DB2 for OS/390 Batch >> Checkpoint Restart Products and were [...] 9679 21 31_Compuware Strobe - Stretch Time13_Glenn Andrews16_gandrew3@CSC.COM31_Mon, 25 Jun 2001 15:37:18 -0400462_us-ascii From the Strobe manual, Stretch time is defined as "the amount of time that the CPU was unavailable to process programs executing in the address space because of demands by higher-priority address spaces and by SRB processing time for all address spaces. It also includes CPU time used by the STROBE measurement task.". When the application program does a SQL call, it is waiting for a response from DB2. Is this 'wait' time really 'stretch time'? [...] 9701 28 34_Deletes with Referential Integrity13_Glenn Andrews16_gandrew3@CSC.COM31_Mon, 25 Jun 2001 15:44:58 -0400402_us-ascii I am working with a SQL Delete statement which is taking an extremely long time to execute. The Delete statement looks like:

DELETE FROM TBLA WHERE COL1 = 'ABC' AND COL2 = 'DEF'

TBLA has a Clustering Unique index on COL1/COL2. It also has many children and grandchildren. Each of these tables has a Clustering index with COL1 and COL2 as the first two columns of the index. [...] 9730 43 35_Re: Compuware Strobe - Stretch Time16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 15:46:55 -0400440_iso-8859-1 Separate. Stretch is when you are ready to do application instructions and MVS does not have both the memory and CPU resource to run you. Waits for SQL, MQ, I/O will be reported as such.

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Glenn Andrews [mailto:gandrew3@CSC.COM] Sent: Monday, June 25, 2001 3:37 PM To: DB2-L@RYCI.COM Subject: Compuware Strobe - Stretch Time [...] 9774 71 35_Re: Compuware Strobe - Stretch Time16_Galambos, Robert29_Robert_Galambos@COMPUWARE.COM31_Mon, 25 Jun 2001 15:54:09 -0400319_iso-8859-1 Stretch time is the time when STROBE tried to take a sample, but the measured address space was not being dispatched by OS/390. Any SQL wait would be attributed to the WAIT time component. Stretch time means that the address space is not executing at all.

Craig Hodgins Compuware Corp. Of Canada [...] 9846 50 35_Re: Compuware Strobe - Stretch Time12_Bajew, Andre25_Andre.Bajew@COMPUWARE.COM31_Mon, 25 Jun 2001 15:54:49 -0400536_iso-8859-1 Hi Glenn,

No, the (wait) time waiting for SQL to be processed is not Strobe stretch time. Are you diagnosing a problem or are you just asking for clarification?

Regards, Andre Bajew

Director of Product Development Compuware Corporation Application Performance & Measurement Center Andre.Bajew@Compuware.Com





-----Original Message----- From: Glenn Andrews [mailto:gandrew3@CSC.COM] Sent: Monday, June 25, 2001 2:37 PM To: DB2-L@RYCI.COM Subject: Compuware Strobe - Stretch Time [...] 9897 32 58_DB2 Stored Procedures, Output Parameters, and Powerbuilder16_Michael McKinney16_mmckinne@CSC.COM31_Mon, 25 Jun 2001 16:01:41 -0400361_us-ascii All,

Members of the application development team on my project are telling me that they can not get Powerbuilder to properly run a DB2 Stored procedure. Specifically Powerbuilder does not recognize output parameters when running a DB2 Stored Procedure. Input parameters are accepted and processed no problem, but not the output parameters. [...] 9930 50 38_Re: Deletes with Referential Integrity16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 25 Jun 2001 16:13:23 -0400399_iso-8859-1 How many is many? How unique is COL1-COL2? If COL1+COL2 has low cardinality and the RI is many levels deep, you will have a long elapsed time.

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Glenn Andrews [mailto:gandrew3@CSC.COM] Sent: Monday, June 25, 2001 3:45 PM To: DB2-L@RYCI.COM Subject: Deletes with Referential Integrity [...] 9981 30 36_SQL0444N error with Stored Procedure12_Phil Jackson21_PJackson@TXFB-INS.COM31_Mon, 25 Jun 2001 14:59:23 -0500370_- Hi, I am trying to call a COBOL stored procedure from an ASP page. I get the following error message, but notice that info such as reason code, specific name,library or path, and function are missing.Does anyone have any clues about this? As the stored procedure is a cobol program residing on an OS/390 mainframe, there is no function name! This is DB2 UDB 6.1. [...] 10012 58 38_Re: Deletes with Referential Integrity9_Sally Mir22_Sally.Mir@WACHOVIA.COM31_Mon, 25 Jun 2001 16:17:28 -0400362_us-ascii Make sure your child tables all have indexes on the foreign keys. When RI is involved in a delete, DB2 has to look at the related children rows to determine what should be done with them. There must be an index defined exactly like the foreign key in order for DB2 to use index access for the child-checking. Otherwise tablespace scans will occur. [...] 10071 59 38_Re: Deletes with Referential Integrity19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Mon, 25 Jun 2001 15:29:43 -0500576_ISO-8859-1 Hi Glenn, "An extremely long time" is relative ;-) Some quick guesses: 1) how many hits in tbla? 2) how many hits in all the kids and grandkids? 3) Contention? 4) You sure all the FKs are indexed?

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 [...] 10131 48 40_Re: SQL0444N error with Stored Procedure13_Davis, Ronald17_DavisRo@CONED.COM31_Mon, 25 Jun 2001 16:37:12 -0400394_iso-8859-1 Take a look at the Stored Procedure Address space on the mainframe. The load library specified on the steplib dd statement of the stored procedure address space should have a 'SPMBR01' member.

-----Original Message----- From: Phil Jackson [mailto:PJackson@TXFB-INS.COM] Sent: Monday, June 25, 2001 3:59 PM To: DB2-L@RYCI.COM Subject: SQL0444N error with Stored Procedure [...] 10180 36 7_OPTHINT16_Alison Pelletier17_ap84098@YAHOO.COM31_Mon, 25 Jun 2001 13:31:22 -0700549_us-ascii Hello Everyone,

We have an access path that changed from V5 to V6 optimizer. The V6 one is proving to cost more, so we want to use OPTHINT to revert back to old access path until we can figure out a way to get the situation properly resolved. The challenge is the program and queryno has changed since then. We are trying to avoid asking the programmer to add the QUERYNO = clause to SQL statement in program. We thought we would update plan_table on the old access path row with the OPTHINT name and also change the queryno of [...] 10217 94 38_Re: Deletes with Referential Integrity11_Tom Flesher13_TomF@ENET.COM31_Mon, 25 Jun 2001 13:48:19 -0700493_us-ascii Another thing that could add to elapsed time on deletes: if change data capture is turned on (perhaps for data propagation purposes?) then DB2 will log complete row images for all deletes ("cascading deletes") that happen as a result of referential integrity. So additional logging is done in this case and could contribute to your perception that it's taking a long time to execute the SQL..... HTH, Tom Flesher E-Net Corporation tomf@enet.com 415-835-8419 tel 415-433-3881 fax [...] 10312 44 46_Re: Unsuccessful Call of DB2 Stored Procedures11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 25 Jun 2001 16:58:25 -0400381_iso-8859-1 Could it be that these environments (MQ, Crystal) do not support the CALL part of ODBC. I saw similar errors using ODBC in TCL (a scripting language). I took it to mean that calls weren't supported in that ODBC implementation. The language interface has to set up the parameter sending and receiving areas. If you are using result sets, that is more complex still. [...] 10357 54 62_Re: DB2 Stored Procedures, Output Parameters, and Powerbuilder13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 25 Jun 2001 16:21:16 -0500335_iso-8859-1 It has been a while, but I recall we could not get OUT parameters AND resultsets together. We could get OUT parameters to work when no resultsets were used. I am talking DB2Connect V5.2 and DB2 V5.1/OS390. and PB V6

There were some power builder INI file settings we had to change. Something about Bind Support. [...] 10412 128 20_Re: Re-sizing tables15_Zander, Barb J.19_bzander@STATE.ND.US31_Mon, 25 Jun 2001 16:53:17 -0500579_iso-8859-1 Don, It depends, if this tablespace is user defined(not using stogroups). You can get done what you need without a reorg. Just stop the tablespace, run DFDSS(or similar) utility to move it to another location, then start tablespace again. I am not sure what other utilities do but I know that DFDSS combines all the extents when it moves the dataset and is fairly fast. This approach can be used with stogroup managed datasets you will just have to do the tablespace alter. Then the next time the tablespace is reorged or loaded it will use the new priqty secqty [...] 10541 130 29_Re: Query on Nested Loop Join25_Loganathan M Ramachandran41_loganathan.m.ramachandran@MAIL.SPRINT.COM31_Mon, 25 Jun 2001 17:32:12 -0500592_ISO-8859-1 Thanks Venkat, it worked like a charm. When we ported the code to integration we had another problem. The query in integration environment (similar query but instead of VMTL_CD the join was made to a different table) is choosing a different access path causing the query to be timed out. The same query works beautifully in development. The # of rows, indexes of each table used in the query are exactly the same in both the environments. How did the optimizer choose different access paths? What other factors influence the optimizer to choose the access path? How do I sync [...] 10672 11 0_14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 26 Jun 2001 20:39:28 +1000257_us-ascii logoff

================================================ 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. 10684 11 0_14_Michael Hannan24_mhannan@C031.AONE.NET.AU31_Tue, 26 Jun 2001 20:40:09 +1000257_us-ascii logout

================================================ 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. 10696 22 33_MODIFY PERFORMANCE PTFS AVAILABLE28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Mon, 25 Jun 2001 15:47:43 PDT586_- PTFs are available for IBM's DB2 MODIFY utility to fix the performance problem. This fix also eliminates many of the deadlock scenarios when running parallel MODIFY jobs.

Performance improvement in excess of 90% is common.

Version 5 - UQ54741 Version 6 - UQ54742 Version 7 - UQ54743



Dan DB2 Utilities Development.

================================================ 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. 10719 97 31_DB2 Server for VSE&VM Education24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Mon, 25 Jun 2001 19:13:58 -0700563_us-ascii

The July through December 2001 DB2 Server for VSE&VM Education schedule is available at The Fillmore Group's website http://www.thefillmoregroup.com Choose "Public classes".

DB2 Server for VSE&VM System Administration - Basic (U4501) US$990 July 17, 2001 DB2 Server for VSE&VM System Administration - Advanced (U4502) US$1,350 July 30, 2001 DB2 Server for VSE&VM Performance Monitoring and Tuning (U4505) US$1,650 September 17, 2001 DB2 Server for VSE&VM Application Designer and Programmer Workshop (U4510) US$1,750 October 15, 2001 [...] 10817 56 62_Re: DB2 Stored Procedures, Output Parameters, and Powerbuilder18_Linda F. Clausssen18_lindafc@NETINS.NET31_Mon, 25 Jun 2001 18:40:00 -0700554_iso-8859-1 The older versions of Powerbuilder did not support both parms + result sets retruned from a stored procedure. The newer versions do. I am not sure in which version of Powerbuilder the support was extened.

Cheers,

Linda F. Claussen Claussen & Associates, Inc. lindafc@netins.net

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Michael McKinney Sent: Monday, June 25, 2001 1:02 PM To: DB2-L@RYCI.COM Subject: DB2 Stored Procedures, Output Parameters, and Powerbuilder [...] 10874 69 0_10_teldb2kals22_teldb2kals@TELSTRA.COM31_Tue, 26 Jun 2001 09:38:34 +1000572_us-ascii Just in case anyone is wondering,

F = C*(9/5) + 32

At -40, they become equal. (-40 F = -40 C)

Cheers, Kals (Sorry, cdnt resist :-)

-----Original Message----- From: Billings, Linda [SMTP:linda.billings@DOA.STATE.WI.US] Sent: Tuesday, June 26, 2001 2:34 AM To: DB2-L@RYCI.COM Subject:

To all of those Americans who don't get out of the country much (Shame on you): 25C is about 77F. -30 C is about -22F. The two scales converge at some point at lower temperatures and then the Celsius numbers are larger than the Fahrenheit. [...] 10944 82 39_Re: Relational Connect and Federated DB11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Tue, 26 Jun 2001 07:07:06 +0700365_- Guys, Wity DB2 UDB 7.1, you still need to install DB2 Relational Connect to be able to create the Oracle Wrapper (although you've installed Fixpack 3). W/ DB2 7.1, you can only connect to SQL Server without Relational Connect.

In DB2 7.2 the drivers to connect to Oracle has been embedded to the DB2, so you won't need Relational Connect with DB2 7.2 [...] 11027 29 49_Re: Range v/s IN-list predicate ? CPU reduction ?6_Chenny39_solaiyappan_chenniappan@MAIL.AMSINC.COM31_Mon, 25 Jun 2001 18:55:42 -0500402_- All,

Thanks for all your response. Both year and month field is currently defined as character format.

Upon comparing the number of getpage request & getpage reads issued against the Index by Range and In-list predicate, i was able to confirm the Terry's response i.e,

#Getpage Reads (with range predicate) - 62526 pages #Getpage Reads (with in-list predicate) - 5426 pages [...] 11057 107 11_Who's next?10_John Hardy22_john_j_hardy@YAHOO.COM31_Mon, 25 Jun 2001 18:58:04 -0500705_- US : H1B UK : IR35 + easy working visas Aus: 80/20 rule

This is obviously a worldwide trend (conspiracy?).

On Mon, 25 Jun 2001 13:34:40 -0400, Pearson, Eric L, wrote:

>An immigration scam perpetrated by wealthy corporate blankety blanks >to suppress salaries by issuing special work visas under >the utterly false pretense that there is a shortage >of high-tech workers rather than a shortage of high-tech >workers willing to work for fast-food wages. > >Regards. >eric pearson > > >-----Original Message----- >From: Jeremy Schleicher [mailto:Jeremy_Schleicher@MAY-CO.COM] >Sent: Monday, June 25, 2001 12:06 PM >To: DB2-L@RYCI.COM >Subject: > > >What [...] 11165 133 15_Re: Who's next?15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Tue, 26 Jun 2001 10:51:10 +1000388_iso-8859-1 Obviously touched a nerve with the H1-B thing, eh Eric? As far as tax goes, seeing as how the world is ageing and there are less and less people to tax, I'd have thought that governments would have concentrated less on coming up with (dis?)ingenious ways to tax your income and looked at taxing your expenditure. Oh wait, we've got high taxes and VAT/GST/sales tax/etc... [...] 11299 65 15_Re: Who's next?12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Tue, 26 Jun 2001 11:26:30 +1000386_- Raymond, it's time to take a leaf out of the book of one of our media moguls (god bless his/her soul). Name suppressed to save the innocents (Me! I'm not paranoid one little bit!!). My personal hero of a couple of years ago. Have an untold fortune to your name, employ a legion of legal and accounting staff, and ..... (drum roll) pay only $30 tax (I think it was) for the year. [...] 11365 88 29_Re: Transfer of RUNSTATS info14_Basiaco, Lucio20_Lucio.Basiaco@CA.COM31_Tue, 26 Jun 2001 11:16:53 +1000697_iso-8859-1 If I may, here is a factoid about PSM (Subcomponent of PPA)

Statistics Manager(tm)s options let you view, calculate, manipulate, and migrate statistics to enhance your DB2 processing. Statistics Manager features include: The ability to migrate statistics from one subsystem to another, such as from PROD to TEST. The ability to migrate statistics from distributed locations and subsystem Ids. Help in creating statistics for a test environment when production statistics do not exist for modeling. A strategy-like feel to the statistics selection and optioning process, including the ability to select statistics by plan or package name. Automatic calculation of regression [...] 11454 28 17_DB2/AIX reference14_Frank Marchese16_ssmlpd@YAHOO.COM31_Mon, 25 Jun 2001 18:48:56 -0700366_us-ascii Hello everyone - can someone recommend a good text(s) and/or IBM material on DB2/AIX or whatever its official IBM name is....I am a DB2/DBA mainframer who would like to learn some of DB2 on Unix platforms including AIX. TIA.



--------------------------------- Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! 11483 55 21_Re: DB2/AIX reference14_Duncan Gardner23_dgardner@GESB.WA.GOV.AU31_Tue, 26 Jun 2001 10:15:44 +0800294_- Frank,

It is call DB2 UDB (Universal Database), and is the same code line on UNIX (AIX, Solaris etc) and WIndows. I've used the "DB2 Universal Database v6.1 Certification Guide" from IBM ITSO and that is OK. You can get the software and load it on a PC to get the hang of things. [...] 11539 50 53_Re: Application failing with SQLCODE -104 in NET.DATA16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 26 Jun 2001 09:53:30 +0530292_- Hi,

I am not sure if SQLCODE -104 have something to do with NET.DATA or not, provided IBM have some special fixes for that. But i have never heard of (missing many things). It would be better, if you could send the codeset for SQL to let us check the standard -104 on the same. [...] 11590 55 29_SEARCH dynamic plan switching14_Gurp, Juul van19_juul.van.gurp@CZ.NL31_Tue, 26 Jun 2001 08:04:18 +0200741_iso-8859-1 ================================================================== De informatie verzonden met dit e-mail bericht is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan. [...] 11646 159 26_Re: Another Oracle barrage15_Agarwal, Ashish28_Ashish.Agarwal@HPSGLOBAL.COM31_Tue, 26 Jun 2001 12:16:17 +0530564_- Hi William, thanks for correcting me.I was wrong in saying that u can have multiple databases per instance. Further, in addition to this, I would like to say that Oracle 8 i has this new parameter : Service_Name, which can have multiple databases/instances per service name. I guess u have worked on DB2 before and now shifted towards Oracle. I guess u r in a unique position to tell us a comparison of the two Databases from ur point of view(am sure, there will be differences of opinion). I guess Sir Mike Hately(who if I remember correctly, is an Oracle [...] 11806 14 26_Re: Another Oracle barrage10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jun 2001 08:48:53 +0200294_us-ascii Hi Bill ...

About Oracle's not-to-br

================================================ 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. 11821 111 38_R: Relational Connect and Federated DB20_Napolitano, Fabrizio22_fnapolitano@INSIRIO.IT31_Tue, 26 Jun 2001 08:39:07 +0200422_iso-8859-1 Thank yuou very much, Here is where I got confused, never understood if v7.1 + fixpack3 was exactly the same as v7.2 or not. Now I'm starting to understand the small differences. Thank you again. Fabrizio Napolitano

-----Messaggio originale----- Da: Endy Lambey [mailto:endyl@CENTRIN.NET.ID] Inviato: Tuesday, June 26, 2001 2:07 AM A: DB2-L@RYCI.COM Oggetto: Re: Relational Connect and Federated DB [...] 11933 86 53_Re: Application failing with SQLCODE -104 in NET.DATA0_24_ujjwal@LOT.TATASTEEL.COM31_Tue, 26 Jun 2001 12:39:51 +0530393_us-ascii Hi, The problem is it works with my test data.If I insert a row with all the data and then display it and modify it it works fine.

Regards Ujjal Bhattacharya





"S, Sanjeev (CTS)" cc: Sent by: DB2 Data Subject: Re: Application failing with SQLCODE Base Discussion -104 in NET.DATA List [...] 12020 242 51_Re: Stored Procedure produces duplicate results set8_LAM, Leo17_l.lam@IOOF.COM.AU31_Mon, 25 Jun 2001 10:06:09 +1000590_iso-8859-1 Pam, Is your cursor selecting rows from a GTT ? If so, I guess you need to initialise the GTT before inserting rows into the table. Leo

-----Original Message----- From: Lynch, Pam [mailto:PLynch@HASTINGSMUTUAL.COM] Sent: Friday, 22 June 2001 3:44 To: DB2-L@RYCI.COM Subject: Stored Procedure produces duplicate results set



Environment: DB2 for OS/390 Version 5 Stored Procedure on OS/390 written in COBOL for MVS DB2 Connect Enterprise Edition Version 7.1, Fixpack 2 Web application is using ASP (Active Server Page) code to call the stored procedure. [...] 12263 16 33_James Drewe is out of the office.11_James Drewe20_James.Drewe@AEXP.COM31_Tue, 26 Jun 2001 01:00:51 -0700436_us-ascii I will be out of the office from 06/25/2001 until 07/06/2001.

I will respond to your message when I return. For DBA assistance, please contact Duane Foss at 602-766-5662. Thanks!

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12280 24 14_Re: work in US10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jun 2001 10:06:03 +0200305_us-ascii Hi Eric...and to anyone who can provide the following informations (offline). Just a curiosity.

What can you tell me about the cost of living in US ? Where the living is less expensive and where is it too expensive ?

Can you tell me where is the labor market is quite lively ? [...] 12305 42 29_Re: Transfer of RUNSTATS info12_Robert Brock28_brock@KRYPTON-CONSULTING.COM31_Tue, 26 Jun 2001 03:39:49 -0500451_iso-8859-1 Another option would be InfoSimulation from Infotel. The product is designed specifically to do what you are looking for. InfoSimulation allows users to easily import existing DB2 catalog statistics or create a completely new set of values to simulate a situation that does not currently exist. Another nice thing is you won't break the bank purchasing the product. If you would like more information, feel free to contact me offline. [...] 12348 33 53_Re: Application failing with SQLCODE -104 in NET.DATA16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 26 Jun 2001 14:20:30 +0530561_- You mentioned,

>> The problem is it works with my test data.<<

It works in this case..........

>>If I insert a row with all the data and then display it and modify it it works fine.<<

It works with this case as well.....

I don't think i am clear with inserting a row with all the data, unless you mean all the columns. The problems seem to be there in UPDATE. It has nothing to do with the datatype you are inserting (everything else have its own SQLCODE), the problems are there with SQL syntax. I do not think either [...] 12382 69 53_Re: Application failing with SQLCODE -104 in NET.DATA0_24_ujjwal@LOT.TATASTEEL.COM31_Tue, 26 Jun 2001 14:54:41 +0530461_us-ascii Here is the exact stuff . The update works with the test data too.

(See attached file: query.txt)

With Regards Ujjal Bhattacharya







"S, Sanjeev (CTS)" cc: Sent by: DB2 Data Subject: Re: Application failing with SQLCODE Base Discussion -104 in NET.DATA List



06/26/01 02:20 PM Please respond to DB2 Data Base Discussion List [...] 12452 77 29_Re: Transfer of RUNSTATS info0_27_jim.leask@RS-COMPONENTS.COM31_Tue, 26 Jun 2001 11:03:03 +0100674_iso-8859-1 Hi,

We use SQL to generate SQL update/delete/insert statements, below is an example for updating tablespace statistics. If you want the updates for the other tables we do (SYSCOLUMNS, SYSINDEXES, SYSTABLES, SYSCOLDISTSTATS, SYSCOLSTATS and SYSTABSTATS), then let me know.



SELECT 'UPDATE SYSIBM.SYSTABLESPACE \', 'SET NACTIVE = ', NACTIVE, ',\', ' NACTIVEF = ', NACTIVEF, ',\', ' STATSTIME = CURRENT_TIMESTAMP\', 'WHERE NAME = ', ''''||NAME||'''\', ' AND DBNAME = ', ''''||SUBSTR(DBNAME,1,2)||'DEVL '||'''\', ';' FROM SYSIBM.SYSTABLESPACE WHERE DBNAME LIKE '__PROD%' ; SELECT 'COMMIT; \' FROM SYSIBM.SYSDATABASE WHERE NAME = 'DSNDB06' ; [...] 12530 27 7_Re: H1B13_Jimmy Willett13_JRLBW@AOL.COM29_Tue, 26 Jun 2001 06:16:55 EDT94_US-ASCII There is no longer an "IT shortage". Here in North Carolina there is an "IT surplus". 12558 89 53_Re: Application failing with SQLCODE -104 in NET.DATA16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 26 Jun 2001 16:35:36 +0530625_- I am sure attachment can't be sent thru' this id. So , we have not recieved your query.txt...

Regards Sanjeev

> -----Original Message----- > From: ujjwal@LOT.TATASTEEL.COM [SMTP:ujjwal@LOT.TATASTEEL.COM] > Sent: Tuesday, June 26, 2001 2:55 PM > To: DB2-L@RYCI.COM > Subject: Re: Application failing with SQLCODE -104 in NET.DATA > > Here is the exact stuff . The update works with the test data too. > > (See attached file: query.txt) > > With Regards > Ujjal Bhattacharya > > > > > "S, Sanjeev (CTS)" > IZANT.COM> cc: > Sent by: DB2 Data Subject: Re: Application [...] 12648 18 11_Re: OPTHINT15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 26 Jun 2001 07:09:39 -0500332_- Alison

I did the same as you did, but with success. I updated the QUERYNO- and the OPTHINT-Column and - I don't know, if you did that, because you didn't mentioned it - I updated the VERSION-Column, because the version changed as well. May be that's the reason, you got that message, which I've never got (up to now). [...] 12667 16 31_Logical/Physical Modeling Tools13_Shauna Hadden24_shauna.hadden@BCBSKS.COM31_Tue, 26 Jun 2001 07:29:06 -0500307_- We are looking for a tool (or set of tools) that does both logical and physical database modeling. We have been using Bachman/Cayenne/CoolDBA, but as you know CA bought it out and it has been terminated. We used this tool for Version 5 of DB2 (OS/390) and we are on Version 6...soon to be Version 7. [...] 12684 131 53_Re: Application failing with SQLCODE -104 in NET.DATA0_24_ujjwal@LOT.TATASTEEL.COM31_Tue, 26 Jun 2001 18:15:56 +0530455_us-ascii I have send it but it came back as rejected posting since it crossed 250 lines .But in the meanwhile the error is located .The error existed in the data . There was a column which had a value WIN'95 and this " ' " single quote in the WIN'95 was causing the UPDATE to fail . Since there were 168 columns in that table it was tough locating the error and I never anticipated that live data could be wrong. Thanx a lot Rohn Solecki and Sethi . [...] 12816 22 37_Racf Security in DB2-How many of you?11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Tue, 26 Jun 2001 15:42:43 +0300325_- Hello Listers, we are using the native DB2 security system and because we are thinking of using Racf instead ,we would just like to know how many of you use Racf to implement security in DB2.Any comments on both practises would be more than welcome!!!

Regards,

Popy A. Dimoka Interdata S.A Athens,Greece [...] 12839 35 35_Re: Logical/Physical Modeling Tools14_Zobjeck, A. J.18_Al_Zobjeck@TTX.COM31_Tue, 26 Jun 2001 08:25:53 -0500295_iso-8859-1 I've used Erwin which I think is a CA tool now. I like it because you can start new data models and you can import existing physical models from sybase, sql server, any DB version and then generate to whatever platform you like. Sometimes that helps. It's easy to use, low cost. [...] 12875 153 53_Re: Application failing with SQLCODE -104 in NET.DATA16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Tue, 26 Jun 2001 19:12:47 +0530594_iso-8859-1 That's great Ujjwal, it gave us the idea about one more thing to be checked once we get this kind of errors.

Regards Sanjeev

> -----Original Message----- > From: ujjwal@LOT.TATASTEEL.COM [SMTP:ujjwal@LOT.TATASTEEL.COM] > Sent: Tuesday, June 26, 2001 6:16 PM > To: DB2-L@RYCI.COM > Subject: Re: Application failing with SQLCODE -104 in NET.DATA > > I have send it but it came back as rejected posting since it crossed 250 > lines .But in the meanwhile the error is located .The error existed in the > data . There was a column which had a value > WIN'95 and this " [...] 13029 43 15_Re: Who's next?11_Jim Keohane19_jimkeo@LOCKSTAR.COM31_Tue, 26 Jun 2001 09:57:05 -0400623_us-ascii Methinks Eric must be jesting. Perhaps he can share with us what high-tech position(s) did he or others turn down and what salary/rate (around $6.50 an hour?) was being offered.

- Jim Keohane

> On Mon, 25 Jun 2001 13:34:40 -0400, Pearson, Eric L, > wrote: > > >An immigration scam perpetrated by wealthy corporate blankety blanks > >to suppress salaries by issuing special work visas under > >the utterly false pretense that there is a shortage > >of high-tech workers rather than a shortage of high-tech > >workers willing to work for fast-food wages. > > > >Regards. [...] 13073 75 38_Please Help "explain" the "Explain"...18_Gaston, Raymond J.17_GastonRay@ORU.COM31_Tue, 26 Jun 2001 09:57:08 -0400306_ISO-8859-1 Please take a brief look at this SQL and explain the explain. We are on OS/390 V5.

Why did db2 accessed the PAVG.PVTOTCUT (index only). This table was in the 'from' clause but all the columns in the SQL are from PAVG.PVTCUTAR and NO column from PAVG.PVTOTCUT is referred in the sql. [...] 13149 59 21_Re: DB2/AIX reference12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Tue, 26 Jun 2001 08:58:37 -0500555_US-ASCII When I first started with DB2 UDB on AIX, I thought it was important to understand how AIX stored it's data. The file system and logical volume manager are quite different from OS/390 and 3390 disk packs. I know, I know, from the DB2 perspective, the syntax is alittle different but you don't need to know this. Although, if you really want to understand how to tune your AIX database, you need to know how things operate at the AIX level. This would compare to understanding how VSAM stores it's data on OS/390. I just think it makes you a [...] 13209 18 13_DB2 Version 68_Dan Alex16_dalex@US.IBM.COM31_Tue, 26 Jun 2001 07:37:04 -0400397_us-ascii We recently upgraded from Version 5 to DB2 Version 6.1.

The only issue we had was using the WITH UR option. This was added to every select in our application. When version 6 was installed those places where we truly needed a record lock gave us some problems. It looked like we were getting duplicate records. We removed the with UR for those selects and everything was fine. [...] 13228 178 7_Re: H1B12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 26 Jun 2001 09:08:05 -0500460_us-ascii During the last few years we have moved completely out of contract programming because of the pricing issues created by the H1B flood. If you have to include Travel & Lodging then you are priced out of the market. Contracting is not consulting. And at best for us, it was a filler to gaps in activity. Somewhere in the 90s contract programming became a market in the US for immigrant labor. It had been a good source for meeting talented people. [...] 13407 54 35_Re: Logical/Physical Modeling Tools12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Tue, 26 Jun 2001 09:05:59 -0500612_US-ASCII ER/Win does both logical and physical. handles a lot of different database connection types. We've used it without problem on version 6 (os/390) and 6 & 7 (udb for AIX). ER/Win has nice feature of comparing databases to models, reverse and forward DDL generation and a powerful scripting language that allows you to generate code based on your objects within the model. Generally, the scripting language is used for stored procedures and triggers, but I have used it in past to generate source code (Delphi and Visual Basic). You could obviously use it to generate any language or documentation of [...] 13462 53 35_Re: Logical/Physical Modeling Tools0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 26 Jun 2001 09:13:59 -0500378_us-ascii We just had a 'show and tell' session from QUEST. I haven't actually used their stuff, but it looked interesting. They mentioned that you can download a lot of their products for 30 trials and that supposedly you can get full help desk support during the trial period. Here is a contact for them: Jim Wankowski DB2 Product Manager Quest Software WWW.QUEST.COM/DB2 [...] 13516 36 25_TCPIP connection with DB212_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Tue, 26 Jun 2001 10:19:26 -0400362_us-ascii I am trying to access ERWIN though one of our Db2 V5 subystems. This is how far I have got. In OS/390 1. Updated SYSIBM.IPNAMES, SYSLOCATIONS 2. BSDS was updated to show the port no and location names. This entry was already added by someone before. problem: I am supposed to get a DSNL400i message giving port information. No such message exists. [...] 13553 54 21_My view on H1's in US13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Tue, 26 Jun 2001 10:28:37 -0400340_iso-8859-1 As a recruiter, this is what I see: Most H1's come into this country (as many of us would do, if we lived elsewhere) with the expectations that they are going to stay and make a life here. It is difficult to make a living in their countries and they want to find a better life for themselves and their families, presumably. [...] 13608 19 16_Re: Linux Quirks13_Henry J. Cobb14_hcobb@SLIP.NET31_Tue, 26 Jun 2001 09:33:21 -0500550_- > I too have had problems finding good documentation for Linux and DB2. > Jeremy Schleicher

Have you read and provided feedback on http://www.linuxdoc.org/HOWTO/DB2-HOWTO/

Henry J. Cobb hcobb@io.com http://www.io.com/~hcobb Any sufficiently cool technology is indistinguishable from religion.

================================================ 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. 13628 189 35_Re: Logical/Physical Modeling Tools22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 26 Jun 2001 09:25:19 -0500320_iso-8859-1 We have Embarcadero's ER/Studio. I'm not a Data-Modeler, but the one that was working here had said it was a very good. She had done a comparative study between Erwin and ER/Studio and she felt ER/Studio could do a lot more than Erwin in terms of Logical Modeling. Check out http://www.embarcadero.com/. [...] 13818 68 29_Re: TCPIP connection with DB211_Bikash Paul19_bikash_db@YAHOO.COM31_Tue, 26 Jun 2001 07:37:16 -0700311_us-ascii Hi, First thing, check whether you can ping IP from your pc where you have set-up ODBC connection for DB2.

Once you have made entry in SYSIBM.IPNAMES and SYSIBM.LOCATION, You need to stop and start DDF to bring the changes in effect. If you have not done it, then you should do that first. [...] 13887 189 35_Re: Logical/Physical Modeling Tools22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 26 Jun 2001 09:29:45 -0500320_iso-8859-1 We have Embarcadero's ER/Studio. I'm not a Data-Modeler, but the one that was working here had said it was a very good. She had done a comparative study between Erwin and ER/Studio and she felt ER/Studio could do a lot more than Erwin in terms of Logical Modeling. Check out http://www.embarcadero.com/. [...] 14077 22 29_Re: TCPIP connection with DB210_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jun 2001 16:41:14 +0200497_us-ascii Hi Amit

Take a look at red book: 'WOW! DRDA Supports TCP/IP: DB2 Server for OS/390 and DB2 Universal Database'

Look appendix B 'Problem determination', there are few rows reporting your error (page 164).

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. 14100 37 16_Re: Linux Quirks11_Pedron, Leo18_lpedron@AKAMAI.COM31_Tue, 26 Jun 2001 10:41:00 -0400469_ISO-8859-1 You can find the revised Quick Beginnings manual that includes EEE installation and set up tips at

ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2v3e70.pdf

Leo

-----Original Message----- From: Henry J. Cobb [mailto:hcobb@SLIP.NET] Sent: Tuesday, June 26, 2001 10:33 AM To: DB2-L@RYCI.COM Subject: Re: Linux Quirks

> I too have had problems finding good documentation for Linux and DB2. > Jeremy Schleicher [...] 14138 73 25_Re: My view on H1's in US22_Lindsay, William (BIS)24_WLindsay@EXCHANGE.ML.COM31_Tue, 26 Jun 2001 10:52:59 -0400443_iso-8859-1 Having to pay your taxes, mortgage, and childs education (IMHO) is bitterness, not prejudice. US workers cannot compete with the wages. Everytime a job is sent to a contract agency they send resumes of 10 qualified (hmmmm...) candidates who work on H1B visas. Some work out well, some do not. They seem to be offered first crack. Why ? I dont know, (3rd base) Where are the US workers ? Those qualified, hungry college grads ? [...] 14212 81 25_Re: My view on H1's in US18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 26 Jun 2001 10:44:52 -0400541_iso-8859-1 Ok: I think this issue can be taken off-line from the DB2-L forum. I don't see this heading anywheres but downhill !!!! You know what they say about opinions!

Have a great day.

--Steve....

Steve Whittaker DB2/DBA Progress Energy, Inc. Mail stop:OHS 10- Raleigh Email: stephen.whittaker@pgnmail.com Phone: (919) 546-7267



-----Original Message----- From: kathryn sears [mailto:ksears@DPCONSULTANTS.COM] Sent: Tuesday, June 26, 2001 10:29 AM To: DB2-L@RYCI.COM Subject: My view on H1's in US [...] 14294 112 42_Re: Please Help "explain" the "Explain"...13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 26 Jun 2001 09:58:59 -0500477_iso-8859-1 Raymond,

It is in the FROM clause, so DB2 must access it. There are no predicates, and no columns returned from this table. DB2 can choose a tablespace scan or non-matching index scan to read the entire table. In this case (but not always) a non-matching (index-only) scan was chosen. DB2 should also choose the smallest index on this table too. It is also the inner table of a nested loop join, which means it is scanned completely for every outer row. [...] 14407 54 29_Re: TCPIP connection with DB211_Brian Lynch19_Brian.Lynch@TRW.COM31_Tue, 26 Jun 2001 10:59:35 -0400589_US-ASCII Have you started the Distributed Data Facility

From DB2 commands screen -STA DDF

If it is already started you will get a message telling you that.

>>> amit_agarwal@STANDARDANDPOORS.COM 06/26/01 08:19AM >>> I am trying to access ERWIN though one of our Db2 V5 subystems. This is how far I have got. In OS/390 1. Updated SYSIBM.IPNAMES, SYSLOCATIONS 2. BSDS was updated to show the port no and location names. This entry was already added by someone before. problem: I am supposed to get a DSNL400i message giving port information. No such message exists. [...] 14462 87 13_Re: DB2 & SMS0_19_mike.holmans@BT.COM31_Tue, 26 Jun 2001 15:53:15 +0100545_- > -----Original Message----- > From: Billings, Linda [SMTP:linda.billings@DOA.STATE.WI.US] > Sent: Wednesday, June 13, 2001 2:37 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DB2 & SMS > > Do all SMS people come from the same gene pool? Ours are the same way. > Even I can even code ACS rules and I don't know that much about it. It's > not > that hard. I always have to write it up for them and supply the test > plans > before they will do anything. > > Linda Billings > Enterprise Systems Programmer > State of Wisconsin > Department [...] 14550 102 25_Re: My view on H1's in US10_Raghu Kota21_raghukota@HOTMAIL.COM31_Tue, 26 Jun 2001 15:09:42 -0000661_- I think everybody paying their taxes!!If you have talent let them compete in the "free world"!! I saw many places prejudice!! No double standards!!! Let us the face music.



>From: "Lindsay, William (BIS)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: My view on H1's in US >Date: Tue, 26 Jun 2001 10:52:59 -0400 > >Having to pay your taxes, mortgage, and childs education (IMHO) is >bitterness, not prejudice. US workers cannot compete with the wages. >Everytime a job is sent to a contract agency they send resumes >of 10 qualified (hmmmm...) candidates who work on [...] 14653 67 29_Re: TCPIP connection with DB214_Dean Montevago18_DMonteva@VNSNY.ORG31_Tue, 26 Jun 2001 11:06:56 -0400404_windows-1252 did you reserve the ports in IP, you also have to create a userid/password to authenticate when you try and connect. If your are RACF and have DSNR active. this userid needa access to the subsys.DIST profile.

-----Original Message----- From: Brian Lynch [mailto:Brian.Lynch@TRW.COM] Sent: Tuesday, June 26, 2001 11:00 AM To: DB2-L@RYCI.COM Subject: Re: TCPIP connection with DB2 [...] 14721 100 25_Re: My view on H1's in US15_Visser, Michael11_mjv@HNC.COM31_Tue, 26 Jun 2001 08:13:30 -0700546_iso-8859-1 Where are the US workers? Those qualified, hungry college grads?

They're getting business, education, communication, nursing, etc. degrees. Specifically, they're NOT getting Computer Science, Engineering, Math, or "hard" science degrees. It's too hard for them. It's too much work. Our culture does not foster an attitude that will support the work ethic required by those disciplines. The qualified, hungry college grads are coming -- from universities and colleges in other countries. (And they're better educated, too). [...] 14822 78 46_Re: Unsuccessful Call of DB2 Stored Procedures13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM31_Tue, 26 Jun 2001 10:14:12 -0500600_iso-8859-1 The error message that you are getting: [IBM][CLI Driver][DB2] SQL0440N No function by the name "PROCEDURE" having compatible arguments was found in the function path. SQLSTATE=42884

is basicly the infamous SQLCode -440. Which could mean a varity of things. But the most likely error, since you seem to be able to execute it from other applications, is that the parameter list is incorrect. If your SP has any output parameters then tools like MS-Query and Crystal Reports cannot be used as they do not handle output parameters, however they can be used to return result sets. [...] 14901 18 25_Re: My view on H1's in US14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 26 Jun 2001 10:22:24 -0500351_iso-8859-1 Don't forget the many highly qualified (in many cases better qualified) people from outside the wonderful USofA who simply want to work abroad for the heck of it - an opportunity to explore a new country, experience a different lifestyle and get paid at the same time. Some of us even speak 'proper' English (I think we invented it !) [...] 14920 123 13_Re: DB2 & SMS15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Tue, 26 Jun 2001 10:25:08 -0500467_iso-8859-1 Sorry, Mike, I hope that you didn't take offense by my flippant remark about the lineage of SMS people. I was expressing some frustration on my part with dealing with a storage admin who is counting the days to retirement. I always have to supply the code for him because he has no programming background whatsoever. The code I have to supply him is for a project where I am migrating documents from OAM optical to DASD and the changes are necessary. [...] 15044 50 25_Use of GRAPHIC (Win/Unix)11_Hamar, Bela22_Bela.Hamar@VARETIS.COM31_Tue, 26 Jun 2001 17:28:17 +0200534_us-ascii I send my question again, maybe I get an answer, or no one uses graphic columns?

Hi gurus,

could anybody explain me, what the graphic data types (GRAPHIC, VARGRAPHIC, DBCLOB) are good for? I know only that they contain double-byte characters (DBCS).

Some questions from the practice:

(DB2 V7.1 AIX/Win2k)

According to my experience, graphic columns can be used only in MBCS databases (that have an MBCS codepage, for example 1363 - Korean) OK, I have a Korean db, with code page 1363. [...] 15095 100 29_Re: TCPIP connection with DB212_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Tue, 26 Jun 2001 11:36:40 -0400595_us-ascii Thanks Bikash and Brian for your help. After the DDF was brought up, I was able to establish connection.

Amit







Bikash Paul on 06/26/2001 10:37:16 AM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: Re: TCPIP connection with DB2











Hi, First thing, check whether you can ping IP from your pc where you have set-up ODBC connection for DB2. [...] 15196 127 25_Re: My view on H1's in US13_kathryn sears24_ksears@DPCONSULTANTS.COM31_Tue, 26 Jun 2001 11:37:03 -0400557_iso-8859-1 Sorry-- It was off-topic. Just want us all to get along! As someone just emailed to me, 1. A lot of other work is sourced offshore: manufacturing, etc. Companies just do whatever it takes to be profitable (and that, after all, is the job of companies). We do, after all buy things made for US companies outside the US in stores everywhere. 2. Many H1's are here to do jobs that are just too difficult to find in the US and are therefore very well-compensated. (and necessary). 3. Lastly, part of the problem was the Y2K issue. The market is [...] 15324 25 53_Message from the List Owners: End all H1-B discussion13_Morrill, John12_JohnM@VP.NET31_Tue, 26 Jun 2001 09:48:02 -0600547_iso-8859-1 Greetings!

For reasons that by now are obvious, topics not releated to DB2 are not permitted on DB2-L. A general discussion (fast becoming a flame war) on H1-B, is off topic.

Please stop posting on this subject now.



Cheers! J. Michael Morrill DB2-L Chief List Owner

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 15350 72 41_Re: Racf Security in DB2-How many of you?0_19_mike.holmans@BT.COM31_Tue, 26 Jun 2001 16:40:53 +0100568_- We've decided not to use RACF.

As DBAs, we find DB2's security structures complex enough to cope with, and we deal with them all the time. Our RACF people would not only have to understand what structures we wanted to implement for DB2, but they also have to deal with all the other things which run on the box. We don't believe that the RACF people would have the time or inclination to give the kind of service that we believe we require (because that's the level of service we currently provide). We believe that moving to RACF-managed security would [...] 15423 82 37_DSNTPSMP rc=-3 on Allocate of PRCDBRM12_David Booher22_David.Booher@QUEST.COM31_Tue, 26 Jun 2001 08:50:31 -0700436_iso-8859-1 Hello list,

In the archives, I saw a similar topic, but there was no response.

I have just implemented the DB2 Stored Procedures builder. During the execution of the REXX script DSNTPSMP in the WLM address space, an error is occurring during allocation of the member into the DBRM library. The DD associated with this allocation is PRCDBRM. The procedure sets an RC of -3 and terminates with an I/O error. [...] 15506 32 25_Re: My view on H1's in US22_Lindsay, William (BIS)24_WLindsay@EXCHANGE.ML.COM31_Tue, 26 Jun 2001 11:49:49 -0400300_iso-8859-1 The problem has nothing to do with ethnicity, or education. It's corporate welfare. No one prevents qualified workers as long as the price right. Yes...We all work hard, we all go to school, we all read the same books, and does it really matter what country someone was educated in ? [...] 15539 100 25_Re: My view on H1's in US16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 26 Jun 2001 11:52:19 -0400485_iso-8859-1 The H1Bs often get forwarded since the contract agency can get them cheaper and thus underbid those who are supplying US citizens. Many of the contract houses have a 'body shop' mentality - supply quantity not quality.

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Lindsay, William (BIS) [mailto:WLindsay@EXCHANGE.ML.COM] Sent: Tuesday, June 26, 2001 10:53 AM To: DB2-L@RYCI.COM Subject: Re: My view on H1's in US [...] 15640 188 13_Re: DB2 & SMS0_19_mike.holmans@BT.COM31_Tue, 26 Jun 2001 17:00:46 +0100291_iso-8859-1 I wasn't taking offence at all. I'm very well aware that there are SMS people out there who are brain-dead or worse. My post was trying to point out that it *needn't* be like that, and that *some* Storage Admin people are actually quite reasonable when you get to know them. [...] 15829 28 36_Re: My (personal) view on H1's in US10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 26 Jun 2001 18:09:10 +0200326_us-ascii And even more Playboy's Playmates are not from US !! They are all H1B !! Shame !! ;-)))

Sorry, I'd like to pour oil on troubled waters to cool some fiery temperament. I'll never do it again.

Well done Mr Morril.

Regards to all lister who put up with me

Max Scarpa Useless DB2 sysprog [...] 15858 52 35_Re: Logical/Physical Modeling Tools17_Rabindra Senapati21_rsenapati@HOTMAIL.COM31_Tue, 26 Jun 2001 11:10:57 -0500 15911 100 36_Re: DB2 connect and stored procedure15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 26 Jun 2001 12:11:28 -0400275_- I got another problem with DB2connect and DECIMAL(9, 2). Through ADO when we retrieve this field from the result set, the value is coming without decimal point. I mean 13.55 comes as 1355. Can we do something in VB, ADO or DB2 connect to get this in the right format. [...] 16012 48 41_Re: DSNTPSMP rc=-3 on Allocate of PRCDBRM12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 26 Jun 2001 09:15:18 -0700598_us-ascii Is there enough space in the PRCDBRM library, including enough members (ie has it been recently compressed)? Secondly, are you pretty current with REXX/DB2 PTFs. There are a number of moderately recent (end of last year and early this year) PTFs that resolved several errors with REXX in the DSNTPSMP clist. --- David Booher wrote: > Hello list, > > In the archives, I saw a similar topic, but there was no response. > > I have just implemented the DB2 Stored Procedures builder. During > the > execution of the REXX script DSNTPSMP in the WLM address space, [...] 16061 31 25_Re: My view on H1's in US14_Charles Heinze22_Programmer1969@AOL.COM29_Tue, 26 Jun 2001 12:19:06 EDT198_US-ASCII I never heard of a foreiner going to the University of Madras for an education. They go to Cal, or Stanford or Michigan or Harvard. Where are these "better educated" foreigners coming from. 16093 57 41_Re: DSNTPSMP rc=-3 on Allocate of PRCDBRM12_David Booher22_David.Booher@QUEST.COM31_Tue, 26 Jun 2001 09:24:38 -0700329_iso-8859-1 Believe it or not, you have to "poison" the STEPLIB concatenantion so that REXX will NOT run APF-authorized. I was in the habit of ensuring that all my STEPLIBs in WLMs WERE authorized, but this is not the case for REXX. By adding a non-APF authorized library to the STEPLIB concatenation, the problem goes away. [...] 16151 134 25_Re: My view on H1's in US15_Mohammed Nayeem25_Mohammed_Nayeem@MOMED.COM31_Tue, 26 Jun 2001 11:25:56 -0500674_us-ascii Many H1-B will be getting GreenCard because priority dates are CURRENT ..........Great news

----- Forwarded by Mohammed Nayeem/MoMedicaid/US on 06/26/01 11:31 AM ----- |--------+-------------------------> | | "Pearson, Eric | | | L," | | | | | | | | | 06/26/01 10:52 | | | AM | | | Please respond | | | to DB2 Data | | | Base Discussion| | | List | | | | |--------+-------------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: (bcc: Mohammed Nayeem/MoMedicaid/US) | | Subject: Re: My view on H1's in US | >--------------------------------------------------------| [...] 16286 71 29_Error when Starting the db2as15_Damien Ponthier27_d.ponthier@CASTSOFTWARE.COM31_Tue, 26 Jun 2001 18:37:37 +0200323_iso-8859-1 Hi all,

When I try to start the administration instance on db2 v7.1 (Linux RH 6.2), I get the following message : "SQL1042C An unexpected system error occurred".

Error from db2diag.log is : DIA3202C The TCP/IP call "bind" returned an errno="13".

Can anyone help ?

Thanks

Damien 16358 27 24_stopping a DB2 Role Back10_Fred Hanes17_f_hanes@YAHOO.COM31_Tue, 26 Jun 2001 09:40:57 -0700317_us-ascii All, do any of you know a method of stoping (killing) a Roleback of a very large insert (150 tapes) that was canceled after processing 145 tapes (by some operator) ithe system DB2 is in the process of rolling back all the data I know an IPL will flush but is there a method that would Kill the roleback [...] 16386 50 73_DB2 Connect Automated Install (was: how to report a DB2 Connect P roblem)12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Tue, 26 Jun 2001 12:43:21 -0400625_iso-8859-1 Thanks to all who replied. I decided to work around the issues (read: bugs) and was successful. My forehead has a big dent in it, but at least the task will be marked "fully successful" by manglement. For the record, the bugs I found were: 1. The FILE parameter in the response file would not work. Solution:Delete the file line and let the install default to the \program files\sqllib directory and it works fine. 2. On the invocation of the setup command, e.g., setup.exe /u u:\db2connectv7\occ.rsp /l "c:\temp\db2connect\db2log.txt" the second filename (where to put the db2log.txt file that indicates the [...] 16437 48 41_Re: Racf Security in DB2-How many of you?11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Tue, 26 Jun 2001 12:58:31 -0400440_us-ascii We use RACF security, administered by our DBA's. This lets us keep the responsibility, yet seriously diminish the amount of work. What we like about using RACF is:

1) Persistent definitions - RACF administered definitions don't go away simply because we dropped and recreated the object. Incidentally, this also allows us to make the definitions during the physical design stage - a long time before the objects exist. [...] 16486 35 25_Re: My view on H1's in US14_Sinha, Abhijit20_Abhijit.Sinha@GS.COM31_Tue, 26 Jun 2001 12:56:02 -0400338_iso-8859-1 Charles,

"Cal, or Stanford or Michigan or Harvard" are not the only institutions in the USofA. They are good, no doubt, but there are many other institutions in India (since you mention Madras !!) and other countries in the world, which are better than many instituions in the US. Hence the term "better educated". [...] 16522 50 11_Re: OPTHINT16_Alison Pelletier17_ap84098@YAHOO.COM31_Tue, 26 Jun 2001 09:58:30 -0700387_us-ascii Thank you for your response. I've figured out what I did wrong. I hadn't put the opthint name in quotes in my bind. So, to recap...

If you have a new version of the program where querynos have changed and you don't want to change the program to add QUERYNO=, you can update queryno of the access path you're trying to change to (old access path) to the new queryno. [...] 16573 46 28_Re: stopping a DB2 Role Back13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 26 Jun 2001 10:04:01 -0700623_us-ascii If it is a test subsystem, force stop (by cancelling IRLM) DB2 and then cold start it.

Thanks. Ashish. /***std.disclaimer***/

-----Original Message----- From: Fred Hanes [SMTP:f_hanes@YAHOO.COM] Sent: Tuesday, June 26, 2001 9:41 AM To: DB2-L@RYCI.COM Subject: stopping a DB2 Role Back

All, do any of you know a method of stoping (killing) a Roleback of a very large insert (150 tapes) that was canceled after processing 145 tapes (by some operator) ithe system DB2 is in the process of rolling back all the data I know an IPL will flush but is there a method that would Kill the roleback [...] 16620 52 28_Re: stopping a DB2 Role Back11_Moore, Tony15_TMoore@IKON.COM31_Tue, 26 Jun 2001 13:10:10 -0400521_iso-8859-1 Fred, You can knock the feet out from under DB2 by cancelling the IRLM proc. However, you will have to do a cold start of DB2 afterwards which will leave the inserted table (and any other tables being modified at the time) trashed. HOWEVER: The last time I had to do this was back around DB2 V2.1, I believe it was, and other than the table being backed out, I came out of it cleanly (I made sure there was no other activity at the time I killed it). However, DB2's come a long way since then so they may [...] 16673 49 25_Re: My view on H1's in US15_Visser, Michael11_mjv@HNC.COM31_Tue, 26 Jun 2001 10:16:36 -0700580_iso-8859-1 We Americans are a people of astounding arrogance.

-----Original Message----- From: Sinha, Abhijit [mailto:Abhijit.Sinha@GS.COM] Sent: Tuesday, June 26, 2001 9:56 AM To: DB2-L@RYCI.COM Subject: Re: My view on H1's in US



Charles,

"Cal, or Stanford or Michigan or Harvard" are not the only institutions in the USofA. They are good, no doubt, but there are many other institutions in India (since you mention Madras !!) and other countries in the world, which are better than many instituions in the US. Hence the term "better educated". [...] 16723 71 28_Re: stopping a DB2 Role Back12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 26 Jun 2001 13:20:18 -0400476_us-ascii I think if you are version 6 you can postpone the backout on restart by using parm(lbackout=yes) in zparms in conjunction with backodur.







"Mohan, Ashish" @RYCI.COM> on 06/26/2001 01:04: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: stopping a DB2 Role Back [...] 16795 72 46_Re: Unsuccessful Call of DB2 Stored Procedures10_Shery Hepp17_schepp@SRPNET.COM31_Tue, 26 Jun 2001 10:24:08 -0700590_ISO-8859-1 I'm having a similar problem. I'm trying to execute a stored procedure from a peoplesoft panel. The call statement doesn't qualify schema.stored proc and I don't want to qualify schema name on the call statement. I have an application trace and there is a command executed that sets the current path to SYSIBM. Is this coming from the db2 connect settings? How can I over ride to specify the current path is appropriate schema? I would prefer to not have to 'code' this in the program for obvious maintenance reasons. I want to be able to determine appropriate schema based [...] 16868 56 28_Re: stopping a DB2 Role Back19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Tue, 26 Jun 2001 12:27:07 -0500640_ISO-8859-1 Hi Fred, Have you thought of a conditional restart with BACKOUT=NO.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 16925 40 28_End all H1-B discussion Now!13_Morrill, John12_JohnM@VP.NET31_Tue, 26 Jun 2001 11:58:25 -0600439_iso-8859-1 Greetings Subscribers of DB2-L!

In my three years as list owner, I have never had the need to make a list wide threat.



Until now.............



Besides the messages that are going to the whole list, I am getting messages complaining about the unprofessional nature of the posts. When I said stop to posting on the subject of H1-B, I did not allow for a exception to get in the last word. [...] 16966 82 25_Re: My view on H1's in US18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 26 Jun 2001 13:54:11 -0400442_iso-8859-1 Hey, speak for yourself BUBBA... If I were you I wouldn't be using the word 'WE' so freely. This is a DB2 forum so let this thing drop like has been suggested. If you want to take it off line be my guest.. I'd much rather deal with DB2 issues then read about who likes what or who doesn't like what about H1B blah, blah, blah..... There's nothing you can do about it anyways. And a good joke once in awhile is nice to read... [...] 17049 124 41_Re: Racf Security in DB2-How many of you?13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Tue, 26 Jun 2001 11:16:59 -0700444_iso-8859-1 I've used both, and as a systems programmer I much prefer RACF. It's easier to query (although this may depend on what you're used to), and its wildcarding capabilities allows for fewer and simpler rules. It works best in shops with established and trained regional security administrators, so DBA's can still have direct control over security, or users themselves can administer their own security without bothering the DBA's. [...] 17174 22 32_Re: End all H1-B discussion Now!26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Tue, 26 Jun 2001 13:24:58 -0500523_- We use the LSoft exits for nefarious purposes. Setting profanity to noPOST, squish Out of office replies, "thread killer" for offensive posts and headhunters. Yep, we've got day jobs too. It's a good bit of work, but think the end result is justified.

My sympathies and regards for every list owner and administrator. CIA just reported before Senate Committee that they "couldn't keep up" with all the hackers. It's an ongoing struggle. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 17197 73 41_Re: Racf Security in DB2-How many of you?18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 26 Jun 2001 14:36:37 -0400307_iso-8859-1 We use CA's Top Secret (TS) here for security but I've used RACF at IBM in years past. Actually I think both are pretty easy to use, from a DB2/DBA's standpoint. We still have control over the security for the DB2 objects but we can turn over the administration of it to the security folks. [...] 17271 25 32_Re: End all H1-B discussion Now!14_Charles Heinze22_Programmer1969@AOL.COM29_Tue, 26 Jun 2001 14:41:53 EDT21_US-ASCII suspend away 17297 14 51_Re: Stored Procedure produces duplicate results set9_Pam Lynch25_plynch@HASTINGSMUTUAL.COM31_Tue, 26 Jun 2001 13:58:50 -0500335_- Yess!!! That was the problem. Thank you very much, Leo, for your response.

Pam Lynch

================================================ 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. 17312 58 28_RUNSTATS ON A PARTITIONED TS15_Backes, Michael26_BackeM@MAIL.OA.STATE.MO.US31_Tue, 26 Jun 2001 14:20:38 -0500672_iso-8859-1 perhaps someone can explain this to me.

I have run runstats on a partitioned tablespace using the following runstats command on all 9 partitions(ie 9 different jobs). RUNSTATS TABLESPACE dbname.tsname PART 1 TABLE INDEX all completed sucsessfully and all say they updated the catalog accordingly but looking at systablepart and sysindexpart has me very confused about what did or didnt get updated in reference to determining from nearoff,faroff, nearindref, farindref whether or not a particular partition needs to be reorged. the systablepart for this looks like this CARD FARINDREF NEARINDREF PERCACTIVE PERCDROP 3,124,792 0 0 85 0 2,579,254 0 0 [...] 17371 29 29_Cease fire --- back to Upsert13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Tue, 26 Jun 2001 12:35:32 -0600367_iso-8859-1 Lets change the subject. Its much more fun to invent new systax. And way more productive.

An obvious flaw with UPSERT is that it try's to UPDATE first and does an INSERT when that fails. We need the reverse, a verb that try's an INSERT first and if that fails on a duplicate, it sums the numeric fields with an UPDATE. We could call it INDATE. [...] 17401 84 32_Re: RUNSTATS ON A PARTITIONED TS11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 26 Jun 2001 14:52:06 -0500727_- Mike,

NEAROFFPOS and FAROFFPOS are obsolete as of V5 or later. Use NEAROFFPOSF and FAROFFPOSF.

Suresh



>From: "Backes, Michael" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: RUNSTATS ON A PARTITIONED TS >Date: Tue, 26 Jun 2001 14:20:38 -0500 > >perhaps someone can explain this to me. > >I have run runstats on a partitioned tablespace using the following >runstats >command on all 9 partitions(ie 9 different jobs). >RUNSTATS TABLESPACE dbname.tsname PART 1 TABLE INDEX >all completed sucsessfully and all say they updated the catalog accordingly >but looking at systablepart and sysindexpart has me very confused about [...] 17486 108 32_Re: RUNSTATS ON A PARTITIONED TS15_Backes, Michael26_BackeM@MAIL.OA.STATE.MO.US31_Tue, 26 Jun 2001 15:18:02 -0500356_iso-8859-1 okay, looking at the 'f' columns, indeed there are values there, however that leads me to a different question. why are partitioned ts treated differently than say a segmented ts?? thats what got me off on this tangent anyway, if those columns are obsolete, why are they updated for non-partitioned tablespaces? we are db2 v6 by the way... [...] 17595 66 19_SPACES ARE WILD !?!0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 26 Jun 2001 15:17:34 -0500379_us-ascii I'm doing some space management right now and have run into a puzzle. We have a bunch of training tables that are empty, 0 rows. So I decided to alter size down to 1 3390 track (12 DB2 pages) and reorg them. Yet after the reorg they consistently use enough extents to use 7 tracks, ie 7 ext if priqty = 12 and secqty = 12, 5 ext if priqty = 36 and secqty = 12, etc [...] 17662 105 23_Re: SPACES ARE WILD !?!17_Sanfilippo, David34_David.Sanfilippo@GMACINSURANCE.COM31_Tue, 26 Jun 2001 16:25:50 -0400597_iso-8859-1 What is the SEGSIZE on them?

-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Tuesday, June 26, 2001 3:18 PM To: DB2-L@RYCI.COM Subject: SPACES ARE WILD !?!



I'm doing some space management right now and have run into a puzzle. We have a bunch of training tables that are empty, 0 rows. So I decided to alter size down to 1 3390 track (12 DB2 pages) and reorg them. Yet after the reorg they consistently use enough extents to use 7 tracks, ie 7 ext if priqty = 12 and secqty = 12, 5 ext if priqty = 36 and secqty = [...] 17768 97 23_Re: SPACES ARE WILD !?!16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 26 Jun 2001 16:31:26 -0400648_iso-8859-1 Sounds like you have SEGSIZE=64. To get 1 track you will need SEGSIZE lower (4 I think).

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Tuesday, June 26, 2001 4:18 PM To: DB2-L@RYCI.COM Subject: SPACES ARE WILD !?!



I'm doing some space management right now and have run into a puzzle. We have a bunch of training tables that are empty, 0 rows. So I decided to alter size down to 1 3390 track (12 DB2 pages) and reorg them. Yet after the reorg they consistently use enough extents to use 7 tracks, ie 7 [...] 17866 92 23_Re: SPACES ARE WILD !?!24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 26 Jun 2001 13:34:01 -0700555_- You might want to look at your SEGSIZE values. 1 track on a 3390? holds 12 pages. If your SEGSIZE is 64, then this would imply a minimum of 6 tracks.

> -----Original Message----- > From: Rohn.Solecki@MTS.MB.CA [SMTP:Rohn.Solecki@MTS.MB.CA] > Sent: Tuesday, June 26, 2001 1:18 PM > To: DB2-L@RYCI.COM > Subject: SPACES ARE WILD !?! > > I'm doing some space management right now and have run into a puzzle. We > have a bunch of training tables that are empty, 0 rows. So I decided to > alter size down to 1 3390 track (12 DB2 pages) and reorg [...] 17959 141 23_Re: SPACES ARE WILD !?!0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 26 Jun 2001 15:55:24 -0500483_us-ascii segsize (defaults to) 64. That looks like the answer. We haven't bothered with segsize up to now, just left it at default. I'll have to discuss this with the rest of the DBA group.

Thanks David.









"Sanfilippo, David" @RYCI.COM> on 2001/06/26 03:25:50 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 18101 54 37_Re: MODIFY PERFORMANCE PTFS AVAILABLE14_Laredo, Andrew19_Andy_Laredo@BMC.COM31_Tue, 26 Jun 2001 16:29:44 -0500293_iso-8859-1 BMC has a high performing MODIFY in the Copy Plus product. In addition, it allows you to issue MODIFY with "WHERE" clause like selections on syscopy columns. It also allows you to Update, Delete and Insert rows into syscopy. It runs out of the box when Copy Plus is installed. [...] 18156 23 30_problem to connect to database9_Ming Wang17_mwang@FABGEAR.COM31_Tue, 26 Jun 2001 17:25:29 -0400563_iso-8859-1 We have db2 UDB V7.1 running on linux. The whole system was down abnormally during a database transaction. After the system came up, I can not connect to the database anymore ( it's ok to connect to other databases in the same instances). The error message follows: SQL1391N The database is already in use by another instance of the database manager. SQLSTATE=51023. I tried to restart the database manager, it did not work. db2 also refuse my request to drop the trouble database from a control center. Any suggestion will be highly appreciated. [...] 18180 28 52_SAP R3 on NT for OS/390 DB2 installation help needed13_Terry McCombs20_tmccomb@SEDGWICK.GOV31_Tue, 26 Jun 2001 17:12:42 -0500386_iso-8859-1 Is there anyone who has installed SAP R3 on NT using OS/390 DB2 as the database who is willing to talk to us about some problems we are having? A test of r3trans (prior to the DB install) is requiring a bunch of environment and/or profile variables that we have not been able to find the names and values for. If you can help, would you e-mail me your phone number? TIA [...] 18209 42 34_Re: problem to connect to database11_Pedron, Leo18_lpedron@AKAMAI.COM31_Tue, 26 Jun 2001 18:42:40 -0400310_ISO-8859-1 Try issuing a db2stop then use ps -ef | grep db2. If there are still any processes still left kill them. Then issue ipcs. Use ipcrm to remove any messages or semaphores left over and try and restart DB2.

Also check the permissions on all the files just to be sure nothing was corrupted. [...] 18252 78 46_Re: Unsuccessful Call of DB2 Stored Procedures10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 27 Jun 2001 09:53:09 +1000473_us-ascii Shery,

U cd set the path in the db2 connect database settings, (using the CCA).

Select the database, click on properties, then on settings, select the "environment" tab. U have the CURRENT FUNCTION PATH field. Type the schema name u want followed by SYSIBM,SYSPROC and SYSFUN. (For ex. "urschema","sysibm","sysproc","sysfun".)

The extra 3 schemas r actually the default. If u dont code those 3, then they get added in "before" ur schema. [...] 18331 19 26_Finding Record information7_db user20_dbuser75@HOTMAIL.COM31_Wed, 27 Jun 2001 00:41:39 -0000558_- Hi all, I need to find the record informatiom(i know the RID of it).Is there any way i can do it,if so will you please let me know the steps in doing it. Thanks in advance Raj

_________________________________________________________________ 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. 18351 21 18_DB2 - V6 Questions16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Tue, 26 Jun 2001 20:58:28 -0400466_us-ascii Hi, what is the limitation of open db2 vsam datasets per DB2.- does this cause performance problems



Is there any good reason to have two tables in the same tablespace? Env DB2 OS/390 V6 TIA Tom Faglon

================================================ 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. 18373 32 16_Re: DSNREXX -80512_Steve Grimes30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 26 Jun 2001 20:15:20 -0500373_us-ascii Hello All!

I found it! We had DSNREXX in multiple load libraries, so I semi-systematically renamed then one by one until my Rexx exec found the one it could match the consistency token for. I then copied the one that worked to the one's where I also wanted it to work. The tests from my TSO accounts look good -- It is updating DB2 from the Rexx exec. [...] 18406 133 32_Re: RUNSTATS ON A PARTITIONED TS10_teldb2kals22_teldb2kals@TELSTRA.COM31_Wed, 27 Jun 2001 11:26:31 +1000504_us-ascii Mike,

It think it doesnt depend on the fact whether it is a partitioned or non-partitioned tablespace. These columns r NOT populated only for LARGE tablespaces. (they r set to -1). They r populated for the other tablespaces for fallback purposes, but not meant to be used.

Cheers, Kals

-----Original Message----- From: Backes, Michael [SMTP:BackeM@MAIL.OA.STATE.MO.US] Sent: Wednesday, June 27, 2001 6:18 AM To: DB2-L@RYCI.COM Subject: Re: RUNSTATS ON A PARTITIONED TS [...] 18540 55 22_Re: DB2 - V6 Questions15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Wed, 27 Jun 2001 11:28:58 +1000558_- Thomas,

The maximum number of open DB2 datasets any one subsystem can have is set in the ZPARMs. DSMAX, to be specific. It can have a value from 1 to 32767. Most sites I've seen tend to have 10,000 specified.

Having multiple tables in a tablespace makes it easier to delete the rows from all tables by doing a Load Replace against just one of them. Although most people do this by mistake, rather than intention. The only use I've seen for multiple tables in a tablespace is if they're all real small and it's simply a convenient way of [...] 18596 72 21_Data loading-- urgent13_Emrah Çadýrcý20_emrca@KOCBANK.COM.TR31_Wed, 27 Jun 2001 08:50:42 +0300356_iso-8859-9 Hi, We work with DB2 7 on AIX.. I have text file. This file contains UPDATE statements like

UPDATE SRV_PYM SET PYM_AMT = 0 WHERE AR_ID = 662000000182913 AND INV_DT = DATE('2001-05-30') AND STATUS = 'X



I have 90000 Update staements in this text file... How can execute this staments from file .. Urgent please... Regards.... 18669 99 25_Re: Data loading-- urgent0_24_markus.schaub@SYSTOR.COM31_Wed, 27 Jun 2001 08:27:44 +0200477_iso-8859-1 try to use the clp. e.g.

db2 -f file.txt

regards markus





Emrah Çadýrcý cc: Sent by: DB2 Subject: [DB2-L] Data loading-- urgent Data Base Discussion List





27.06.2001 07:50 Please respond to DB2 Data Base Discussion List







Hi, We work with DB2 7 on AIX.. I have text file. This file contains UPDATE statements like [...] 18769 96 25_Re: Data loading-- urgent13_Emrah Çadýrcý20_emrca@KOCBANK.COM.TR31_Wed, 27 Jun 2001 11:03:59 +0300839_iso-8859-1 Thanks Markus

-----Original Message----- From: markus.schaub@SYSTOR.COM [mailto:markus.schaub@SYSTOR.COM] Sent: Wednesday, June 27, 2001 9:28 AM To: DB2-L@RYCI.COM Subject: Re: Data loading-- urgent



try to use the clp. e.g.

db2 -f file.txt

regards markus







Emrah Çadýrcý


COM.TR> cc:

Sent by: DB2 Subject: [DB2-L] Data loading-- urgent Data Base

Discussion List


>













27.06.2001

07:50

Please respond

to DB2 Data

Base Discussion

List













Hi, We work with DB2 7 on AIX.. I have text file. This file contains UPDATE statements like [...] 18866 89 21_Re: ADDRESS DSNREXX ?14_Vassie, Edward21_Edward_Vassie@BMC.COM31_Wed, 27 Jun 2001 03:29:25 -0500475_iso-8859-1 There is a product called Uni-Rexx. It is a Rexx that works on many flavours of Unix.

From Edward Vassie...



-----Original Message----- From: Sharpe, Richard [mailto:rsharpe@AMHERST1.COM] Sent: 25 June 2001 13:20 Subject: Re: ADDRESS DSNREXX ?



I used to use REXX on the mainframe many years ago, can it be used on SOLARIS or LINUX ? This would be great if a scripting language like REXX were available on those platforms.. [...] 18956 27 44_Ms Access 2000 returns "Record is too large"13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR31_Wed, 27 Jun 2001 11:36:08 +0300357_iso-8859-9 In our environment clients are accessing DB2 UDB for OS/390 data, via DB2 Connect / ODBC interface.

While accessing a 228 column table by using Ms Access 2000, "Record is too large" message returns. I created a similar table with CREATE LIKE, inserted two rows and the result is the same. Excell 2000 access the same table perfectly. [...] 18984 21 30_DB2 Access from Cics and Batch0_22_blyons2@CSCPLOENZKE.DE31_Wed, 27 Jun 2001 11:36:05 +0200532_us-ascii Hi List,

I have several hundred Os/390 Cobol DB2 Programs that need to run under CICS and from Batch. Do I have to have separate Load Modules for these, one set linked using DSNCLI, the other using DSNHLI, or is there a better way to do this?

thanks in advance, Brian

================================================ 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. 19006 32 30_DB2 Stored Procedures on Linux23_Eamonn Downey/DUB/Lotus23_Eamonn_Downey@LOTUS.COM31_Wed, 27 Jun 2001 10:48:32 +0100380_us-ascii Hi,



I applied Fixpack 3 to my RedHat Linux 7.0 version of DB2 V7.1 and since then I cannot run any Java sp's. The error I get is

[IBM][CLI Driver][DB2/LINUX] SQL4304N Java stored procedure or user-defined function "DB2TOPS .PROCEDURE1", specific name "SQL010627115436920" could not load Java class "Procedure1", reason code "1". SQLSTATE=42724 [...] 19039 48 30_Re: Finding Record information0_19_mike.holmans@BT.COM31_Wed, 27 Jun 2001 11:47:14 +0100326_- If you know the RID and you want to see the data, then you could use DSN1PRNT.

The first three bytes of the RID tell you which page within the tablespace the row is on (in hex), and the last byte tells you which row within the page.

Look up how to use DSN1PRNT to print off a database page in the manual. [...] 19088 79 19_How to set MINDVSCL12_Troy Coleman19_Colematr@MEIJER.COM31_Wed, 27 Jun 2001 06:57:36 -0400345_US-ASCII Hello List, I've seen some references to this new DB2 setting called MINDVSCL. It seems that PeopleSoft is requiring this to be set to 6. My understanding is that a DEC 15 shop would be using 6 of the 15 for precision. I cannot find any reference to this field in V6 manuals. Does anyone have an insight to were this field is SET? [...] 19168 48 11_View Puzzle11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Wed, 27 Jun 2001 18:29:53 +0700496_- Guys,

We have 1 tables (Tbl_A) with 3 keys adn 50 numeric fields. We want to create a view (Vw_A) that consist only 5 fields, with 3 keys from Tbl_A, one field (Col_Nm) with value for each 50 Tbl_A numeric fields, and one field for the value for each Tbl_A keys and numeric values for the spesific fields (for each Col_Nm). Right now I come up with a union of 50 sql that spesifically select each value from Tbl_A numeric fields. Do you guys have any other approach on this matter? [...] 19217 79 46_DB2 Connect V7.1 Client trashes DB2/AIX Server11_Moore, Tony15_TMoore@IKON.COM31_Wed, 27 Jun 2001 07:53:57 -0400486_iso-8859-1

Yo Listers, I've just upgraded DB2 Connect V5 to V7 on Windows 95 and attempted to connect to DB2/AIX V2.1.2. The DB2 window in Win95 brought back the following:

SQL30081N A communication error has been detected. Communication protocol being used "TCP/IP". Communication API being used "SOCKETS". Location where the error was detected: ''''. Communication function detecting the error: "recv". Protocol specific error code(s): "*","*","0". SQLSTATE=08001 [...] 19297 23 25_Transfer of RUNSTATS info16_Sharon Zitterman24_Sharon.Zitterman@TRW.COM31_Wed, 27 Jun 2001 07:54:47 -0400363_US-ASCII Good morning Smike,

We do this very thing in our shop. We created a unique RUNSTATS database in our test environment. Every week after production RUNSTATS is complete, we unload the statistical information (using BMC ADUUMAIN) from production and load that info (using BMC AMUUMAIN)into the RUNSTATS database in test.

Hope this helps. [...] 19321 207 13_Re: DB2 & SMS15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 27 Jun 2001 07:08:51 -0500289_iso-8859-1 Well, I wasn't sure so I thought I would apologize anyway just in case. I can get along with this guy otherwise but he seems to have a mental block where OAM is concerned. He doesn't understand it so he doesn't want anything to do with it. It is really not very difficult. [...] 19529 98 50_Re: DB2 Connect V7.1 Client trashes DB2/AIX Server9_Chu, Pius14_ChuP@CONED.COM31_Wed, 27 Jun 2001 08:17:02 -0400419_iso-8859-1 As far as I understand from IBM, DB2 Connect V7 client can only be downward to work with DB2 Connect Version 6 (one level down). While if you have the V5 client can work with DB2 Connect gateway Version 6 and 7 (2 level up). If these is not the case, I think you need to open the case up with DB2 Connect tech support in Toronto and send them your DB2DIAG.LOG and all your .trp (trap files). good luck. [...] 19628 161 23_Re: How to set MINDVSCL27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 27 Jun 2001 07:24:48 -0500597_iso-8859-1 Here's the scoop from IBMLINK from the apar that added this parameter - PQ44039. This fix also added the MULTIPLY_ALT scalar function, in case anyone is interested.





Minimum Divide Scale Opaque ZPARM A new subsystem parameter MINDVSCL will be introduced to allow the user to specify the minimum scale for the result of a decimal division. To change the default value, the user should update the MINDVSCL keyword of the DSN6SPRM macro invocation in the DSNTIJUZ job. The following example demonstrates how to change the value of the minimum divide scale to 6: [...] 19790 51 20_Re: Synonym question15_Billings, Linda30_linda.billings@DOA.STATE.WI.US31_Wed, 27 Jun 2001 07:30:38 -0500515_iso-8859-1 I have never heard of using synonyms for stored procedures.

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



"The distance between insanity and genius is measured only by success." James Bond - Tomorrow Never Dies



-----Original Message----- From: Swamy, Ritesh [mailto:Ritesh.Swamy@BLR.HPSGLOBAL.COM] Sent: Monday, June 25, 2001 1:04 AM To: DB2-L@RYCI.COM Subject: Synonym question Importance: High [...] 19842 78 15_Re: View Puzzle0_19_mike.holmans@BT.COM31_Wed, 27 Jun 2001 13:33:40 +0100392_- What do you want this view for?

This looks a lot more like a report formatting question than anything else, so it would be interesting to know what, if any, query/reporting tools you have available.

Mike Holmans BT ISE Database Services mike.holmans@bt.com

This post represents the views of the author and does not necessarily accurately represent the views of BT [...] 19921 45 29_Re: Transfer of RUNSTATS info34_Pillay, Venkat (USPC.PCT.Hopewell)20_venkat_pillay@ML.COM31_Wed, 27 Jun 2001 08:43:08 -0400398_iso-8859-1 I had a rexx with cdb-db2 interface. Let me check if I could quickly convert it to REXX-DB2 interface and put it on listserv documents. It is pretty handy to move stats from one database to other and takes care of all the float columns such as FIRSTKEYCARDF etc.

I will try to get back on this as soon as I get little relief from my current work-load. Regards, Venkat Pillay [...] 19967 39 23_Re: How to set MINDVSCL13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 27 Jun 2001 07:49:35 -0500523_iso-8859-1 It was delivered in an apar after V6 came out, so you may not find it in the manuals. Take a look at PQ44039 (the same one that delivered "multiply_alt"). The documentation with the apar mentions where this is set... http://techsupport.services.ibm.com/s390/390.uhuic_getrec?args=DVhuron.boulder.ibm.com+DB390+DA12758+STMINDVSC+USbin. I've got my own opinions on this zparm and the requirement from Peoplesoft, but I'll keep 'em to myself (I grumbled about this one on the psdb2os390 listserv awhile back). [...] 20007 21 20_Re: Synonym question13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 27 Jun 2001 09:05:21 -0400558_iso-8859-1 Hi Ritesh, Synonyms are valid for only tables or views. No Distict Type or Stored Procedure Synonyms.

What problem would you solve for Stored Procedures with Synonyms? Perhaps there's another solution.

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

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 20029 110 21_Re: ADDRESS DSNREXX ?15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Wed, 27 Jun 2001 09:13:19 -0400438_iso-8859-1 I'd also suggest that you check out Mark Hessling's site: http://www.lightlink.com/~hessling/ He maintains a freeware version of REXX, called Regina, which has been ported to various IXes as well as Winders. You'll also find various extensions for SQL and ISAM access, interfaces to other Unix-based packages, and an XEDIT clone called THE. You may also want to visit some of the sites that Mark has linked with his page. [...] 20140 179 50_Re: DB2 Connect V7.1 Client trashes DB2/AIX Server15_Zander, Barb J.19_bzander@STATE.ND.US31_Wed, 27 Jun 2001 08:23:23 -0500397_iso-8859-1 Tony, We had this problem too. I am not sure what level of software we were at on the AIX. But we had to upgrade the AIX software to a new version in order to use the V7 client.

Barb

-----Original Message----- From: Moore, Tony [mailto:TMoore@IKON.COM] Sent: Wednesday, June 27, 2001 6:54 AM To: DB2-L@RYCI.COM Subject: DB2 Connect V7.1 Client trashes DB2/AIX Server [...] 20320 63 10_s0c7 error0_22_Ajay.Gupta@BOIMAIL.COM31_Wed, 27 Jun 2001 14:53:39 +0100415_iso-8859-1 Friends,

I am getting s0c7 when I'm trying to run an IMS transaction which also uses DB2.

The same code is running fine in production . On looking at the footprint we found that the line where s0c7 is coming is the one generated by precompiler during the precompilation. These lines contains calls to DSNHLI Originally there is an OPEN CURSOR SQL which was replaced by the above call. [...] 20384 67 23_DB2 V7 offsite recovery10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Wed, 27 Jun 2001 07:58:59 -0600471_iso-8859-1 Hi! We just installed DB2 Version 7 and this is the first DB2 we have. Now we are planning offsite recovery(disaster recovery) for DB2 and would like to have experience from other DB2 shops.

Thanks! Grace Chen Technical Support Credit Union Central Alberta Ltd. Tel: (403) 258-5982 E-mail : gchen@cucentral-ab.com



_______________________________________________________ eSafe Protect Gateway has scanned this mail for viruses, vandals and 20452 66 26_Re: DB2 v6.1 and old dbrms12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 27 Jun 2001 09:15:58 -0500564_us-ascii Hello Tom, Looks like no one else answered this, So I'll bite... Auto-rebinds work fine on a DBRM that is missing the colons on host variables, because the autorebind works from the contents of SYSDBRM, which contains colons even for DBRMs that were missing them originally. I believe even a REBIND command will work on it, but we never tried it. What will fail is a new pre-compile, if the source has not been changed to include colons, this was getting a warning error in Version 5, which becomes a full failure in Version 6. So, if you don't make [...] 20519 94 14_Re: s0c7 error13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Wed, 27 Jun 2001 09:28:15 -0500422_us-ascii we were getting something simular ... it turns out that we were overlaying our working storage - sqlca, and when it goes back to check, it had invalid data.... so we moved some things around in working storage, and added the ssrange parm to the compile.







Ajay.Gupta@BOIMAI To: DB2-L@RYCI.COM L.COM cc: Sent by: DB2 Data Subject: s0c7 error Base Discussion List [...] 20614 58 11_SEARCH -87914_Gurp, Juul van19_juul.van.gurp@CZ.NL31_Wed, 27 Jun 2001 16:40:47 +0200768_iso-8859-1 SEARCH -879



================================================================== De informatie verzonden met dit e-mail bericht is vertrouwelijk en uitsluitend bestemd voor de geadresseerde. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. CZ staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mail, noch voor tijdige ontvangst daarvan. [...] 20673 64 50_Re: DB2 Connect V7.1 Client trashes DB2/AIX Server11_Moore, Tony15_TMoore@IKON.COM31_Wed, 27 Jun 2001 11:00:14 -0400523_iso-8859-1 Thanks Barb and Pius. I've uninstalled V7 and reinstalled V5.2 and it seems to be working well so far.

-----Original Message----- From: Zander, Barb J. [mailto:bzander@STATE.ND.US] Sent: Wednesday, June 27, 2001 9:23 AM To: DB2-L@RYCI.COM Subject: Re: DB2 Connect V7.1 Client trashes DB2/AIX Server





Tony, We had this problem too. I am not sure what level of software we were at on the AIX. But we had to upgrade the AIX software to a new version in order to use the V7 client. [...] 20738 83 48_Re: Ms Access 2000 returns "Record is too large"13_Andy Seuffert25_Andy.Seuffert@NEONSYS.COM31_Wed, 27 Jun 2001 10:21:23 -0500567_iso-8859-1 You may be hitting one of the below limits in MS-Access. The maximum number of fields in a table is suppose to be 255, much less than DB2. You may want to verify your number of columns since the values are close.

Table specifications for Access 97 and 2000:

Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 1,024. The actual number may be less because of tables open internally by Microsoft Access. 2048 with Access 2000 Table size 1 [...] 20822 58 50_Re: partition number for nonpartitioned tablespace12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 27 Jun 2001 10:23:26 -0500400_us-ascii Your first dataset has extended up to the 2 gigabyte VSAM limit, and DB2 automatically allocated a second dataset. This is not a partition, it is merely an extension. If you reorg and your space requirement becomes less than 2 gig, the second dataset will go away.











"Johnson, Daryl" on 06/12/2001 01:52:18 PM [...] 20881 40 35_Re: Logical/Physical Modeling Tools14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Wed, 27 Jun 2001 10:40:37 -0500774_iso-8859-1 If you are looking for data modeling tools check out the list of DM tool vendors on the TDAN.com site at:

http://www.tdan.com/companies.htm#Datamodel

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

>------------------------------ > >Date: Tue, 26 Jun 2001 07:29:06 -0500 >From: Shauna Hadden >Subject: Logical/Physical Modeling Tools > >We are looking for a tool (or set of tools) that does both logical and >physical database modeling. We have been using Bachman/Cayenne/CoolDBA, but >as you know CA bought it out and it has been terminated. We used this tool >for Version 5 of DB2 (OS/390) [...] 20922 19 17_CA Fast Utilities0_26_mmetcalf@NOTES.STATE.NE.US31_Wed, 27 Jun 2001 10:45:06 -0500298_us-ascii I'm in need of some information (good and bad) on the CA Fast utilities as far as performance problems, ease of use, benchmarking, etc. I searched the DB2-L archive logs and did get a few hits but they are dated a while back. Anyone willing to share any information and benchmarking? [...] 20942 25 12_SQL Question17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Wed, 27 Jun 2001 09:02:01 -0700324_us-ascii A table is defined with 5 columns - ACCNUM, FIELD1, FIELD2, FIELD3, FIELD4

What we would like to do is for every row in the table shift the value of each field to the right and insert a new value into the first field.

Therefore FIELD4 = FIELD3, FIELD3 = FIELD2, FIELD2 = FIELD1 and FIELD1 = 999. [...] 20968 35 33_Select Varchar groupby nonvarchar5_Chris17_isatcjk@YAHOO.COM31_Wed, 27 Jun 2001 09:09:56 -0700369_us-ascii | -134 IMPROPER USE OF LONG STRING COLUMN column-name OR AN EXPRESSION # THAT RESOLVES TO A LONG STRING



We're attempting to

Select cola, colb, varcharcolumnc from t group by cola, colb

And we get the -134. I can understand not allowing a group by on a varchar column, but what are the underlying reasons for this return code? [...] 21004 67 21_Re: CA Fast Utilities18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Wed, 27 Jun 2001 12:17:42 -0400533_iso-8859-1 Michelle: We use CA/Platinum fast utilities here in our shop with DB2 V5. Right now we have CA P97F installed but are trying to upgrade to P99D with major problems. We are also migrating up to DB2 Version 6 at the same time. I've used CA's fastunload and fastload jobs in the past and they work just fine. I've also used their 'recovery' tools. The only problem we have had is in getting adequate support! That is a big issue and concern to us. We were not getting PTF fixes in here in time and it was causing us all [...] 21072 18 12_SQL Question17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Wed, 27 Jun 2001 09:32:41 -0700321_us-ascii I found our problem with the SQL statement. It didn't work because FIELD3 and FIELD4 which are defined as SMALLINT NOT NULL and never updated gave us a -401 sql error code when attempting to move FIELD3 to FIELD4. Once FIELD3 was updated with a value from FIELD2 then the SQL statement worked successfully. [...] 21091 14 22_Overhead for IFCID 19813_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 27 Jun 2001 11:49:01 -0500421_- Hi Listers What's the overhead for a trace with IFCID 198 only ? I just want some rough numbers before starting this trace. We are on v6 / OS390 2.8 . Thanks in advance Mohammad

================================================ 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. 21106 19 23_4 hours time difference16_Robert Blackwell31_robert.blackwell@PIEDMONTNG.COM31_Wed, 27 Jun 2001 13:05:59 -0400567_us-ascii We have a c/s app that is connecting to DB2/OS390 and issues UPDATE statements to a table to post the current timestamp as EDT. The timestamp is also logged at the c/s app location. Both the c/s app and the DB2 table are in the same city. However, the timestamp logged by the c/s app will be the correct time while the time that gets updated in the DB2 table is exactly 4 hours later. If the c/s app logs a timestamp as 2001-06-27-12.57.28.290997, the timestamp that gets updated in the DB2 table is 2001-06-27-16.57.28.290997. Does anyone have an idea [...] 21126 60 27_Re: 4 hours time difference0_20_John_Lendman@FPL.COM31_Wed, 27 Jun 2001 13:42:43 -0400717_us-ascii GMT, all the time in DB2 is in Greenwich Mean Time



John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413





"Robert Blackwell" cc: Sent by: "DB2 Data Base Subject: 4 hours time difference Discussion List"



06/27/01 01:05 PM Please respond to "DB2 Data Base Discussion List"











We have a c/s app that is connecting to DB2/OS390 and issues UPDATE statements to a table to post the current timestamp as EDT. The timestamp is also logged at the c/s app location. Both the c/s app and the DB2 table are in the same city. However, [...] 21187 52 27_Re: 4 hours time difference19_DAVIS, RICK (SBCSI)14_rd8246@SBC.COM31_Wed, 27 Jun 2001 12:43:39 -0500633_ISO-8859-1 It appears the system clock is UTC/GMT on the OS390 machine.

HTH, Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 21240 53 27_Re: 4 hours time difference11_Randy Scott19_Randy_Scott@VFC.COM31_Wed, 27 Jun 2001 13:46:16 -0400715_us-ascii Robert,

Your DB2 computer must be on GMT and the other on EDT.

Randy







Robert Blackwell @RYCI.COM> on 06/27/2001 01:05:59 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: 4 hours time difference

We have a c/s app that is connecting to DB2/OS390 and issues UPDATE statements to a table to post the current timestamp as EDT. The timestamp is also logged at the c/s app location. Both the c/s app and the DB2 table are in the same city. However, the timestamp logged by the c/s [...] 21294 10 27_Re: 4 HOURS TIME DIFFERENCE16_Bernard Greenman27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 27 Jun 2001 13:45:00 -0400301_- Your installation is apparently using GMT as the default.

================================================ 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. 21305 44 27_Re: 4 hours time difference11_Robert Jans26_robert_jans@ALBERTSONS.COM31_Wed, 27 Jun 2001 10:50:21 -0700493_- Since DB2's CURRENT TIMESTAMP pulls the time from the system, I'd suggest asking your MVS people what time they run on the box or LPAR you're doing this on. I'd guess that 4 hours from EDT should be about GMT............. ie: your system is set to Greenwich time......

Robert Jans



-----Original Message----- From: Robert Blackwell [mailto:robert.blackwell@PIEDMONTNG.COM] Sent: Wednesday, June 27, 2001 11:06 AM To: DB2-L@RYCI.COM Subject: 4 hours time difference [...] 21350 47 26_Re: Overhead for IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 27 Jun 2001 14:03:49 -0400447_ISO-8859-1 If you run this to SMF, on an high activity system, you will have a severe peformance impact, will lose much trace data, including MVS system performance data, and run the risk of abending SMF... requiring a restart of the entire operating system to get it back.

If you run it to GTF, you avoid the above data loss and abend risks, but the overhead is even higher.... and you have to know GTF and be authorized to start it. [...] 21398 52 20_Re: Synonym question13_Swamy, Ritesh30_Ritesh.Swamy@BLR.HPSGLOBAL.COM31_Wed, 27 Jun 2001 23:37:13 +0500377_iso-8859-1 Hi Dave,

Its not a problem as such. Actually we were doing a migration from Oracle to DB2 and instead of explicitly giving the qualifier for the schema containing the stored procs or instead of using SET CURRENT FUNCTION PATH - I just wanted to know if we could create synonyms for users. Obviously, we have now decided to use SET CURRENT FUNCTION PATH. [...] 21451 108 16_Re: SQL Question0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 27 Jun 2001 14:27:58 -0400351_us-ascii Depending on the version of DB2 that you have, you cannot update a table from itself. I would recommend the user of temporary table as follows;

CREATE GLOBAL TEMPORARY TABLE X LIKE Y;

INSERT INTO X SELECT ACCNUM, 999, FIELD1, FIELD2, FIELD3 FROM Y WHERE ;

DELETE FROM Y WHERE ; [...] 21560 123 16_Re: SQL Question24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Wed, 27 Jun 2001 11:58:48 -0700568_- I was wondering if you could do this with a before trigger?

> -----Original Message----- > From: db46@DAIMLERCHRYSLER.COM [SMTP:db46@DAIMLERCHRYSLER.COM] > Sent: Wednesday, June 27, 2001 11:28 AM > To: DB2-L@RYCI.COM > Subject: Re: SQL Question > > Depending on the version of DB2 that you have, you cannot update a table > from itself. I would recommend the user of temporary table as follows; > > CREATE GLOBAL TEMPORARY TABLE X LIKE Y; > > INSERT INTO X > SELECT > ACCNUM, > 999, > FIELD1, > FIELD2, > FIELD3 > FROM Y > WHERE ; > > [...] 21684 16 16_Re: SQL Question17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Wed, 27 Jun 2001 12:08:21 -0700451_us-ascii Actually I have been able to do it. The problem earlier was that two of the fields were erroneously defined as null. Once we updated that to NOT NULL our SQL statement updated all the fields properly.

================================================ 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. 21701 36 29_Migrating DB2 to new hardware4_Ln S18_csc266@HOTMAIL.COM31_Wed, 27 Jun 2001 14:14:04 -0500373_- Does anyone have guidelines for migrating DB2 to new hardware ?

I'm looking at moving from a IBM RS/6000 ,Internal SCSI disks (holding O.S and DB2 directories) All data on a SSA-RAID(5) array

to another RS/6000 Internal disks are SSA



Planning on moving over the SSA tower, its controller card, RAID adapter card over to the new machine. [...] 21738 178 16_Re: SQL Question0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 27 Jun 2001 15:32:04 -0400474_us-ascii I imagine you could. But I thought you were doing a one-time update.

Dean







"Leblanc, Francis C - To: DB2-L@RYCI.COM CNF" cc: Sent by: DB2 Data Base Discussion List



06/27/01 02:58 PM Please respond to DB2 Data Base Discussion List











I was wondering if you could do this with a before trigger? [...] 21917 51 46_Re: Looking for a pure DB2 systems programmer.11_Bikash Paul19_bikash_db@YAHOO.COM31_Wed, 27 Jun 2001 12:42:35 -0700582_us-ascii Hi Jeff , I just called and thought of dropping a mail to check the status. Did u hear anything from American Express yet ?.. Looking forward to hear from you soon !

Thanks and Regards, Bikash



--- Jeff Wrightsell wrote: > The positions I have are strictly for DB2 Systems programmers. > This is not > an applications job. > > Location: Minneapolis, Phoenix > Rate: to 90K + 10-20% bonus + up to 10k sign-on bonus > > We can get feedback from our client within five minutes of sending > a > candidate. > > Interested [...] 21969 112 30_Re: Finding Record information14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Wed, 27 Jun 2001 13:05:36 -0700418_iso-8859-1 Decompose the RID, to get the page number, then use DSN1PRNT requesting just that page with the FORMAT option. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com

Note: All opinions are strictly my own. -----Original Message----- From: db user [mailto:dbuser75@HOTMAIL.COM] Sent: Tuesday, June 26, 2001 7:42 PM To: DB2-L@RYCI.COM Subject: [DB2-L] Finding Record information [...] 22082 35 29_Has Anyone modified DSNTPSMP?13_Kenski, David25_David.Kenski@MARRIOTT.COM31_Wed, 27 Jun 2001 16:14:14 -0400629_windows-1252 Hello List!

I am considering modifying the DSNTPSMP REXX of Stored Procedure Builder to separate "job" functions. In our shop, the DBA's wish to perform the registering function associated with stored procedures that way they know what the programmers are creating. The programmers develop, compile, link, and bind the code. I would also like to determine the feasibility of storing the source in Panvalet in addition to the catalog tables so that the SP source is with all of the other program source. We began using stored procedures about 6 months ago utilizing both COBOL and SQL procedures. We have [...] 22118 25 34_Re: , Finding, Record, information7_db user20_dbuser75@HOTMAIL.COM31_Wed, 27 Jun 2001 20:35:53 -0000316_- Thanks Mike & Wayne,

I know the page number and the offset ( Page no: 18 Offset : 44 0) and i got he DSN1PRNT with the format option,i dont know how to interpret the output.

Can you people help me out regarding this.

P.S: Tablespace is compressed,total number of RID's in the page : 201. [...] 22144 42 16_Re: SQL Question15_Nadia Dimitrova17_dnady@HOTMAIL.COM31_Wed, 27 Jun 2001 16:21:53 -0500603_- Wy aren't you do that true dataunload and datareload, it will be simple.



>From: Charles Jambrosic >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: SQL Question >Date: Wed, 27 Jun 2001 09:02:01 -0700 > >A table is defined with 5 columns - ACCNUM, FIELD1, FIELD2, FIELD3, >FIELD4 > >What we would like to do is for every row in the table shift the value of >each field to the right and >insert a new value into the first field. > >Therefore FIELD4 = FIELD3, FIELD3 = FIELD2, FIELD2 = FIELD1 and FIELD1 = >999. > >Is it [...] 22187 141 34_Re: , Finding, Record, information14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Wed, 27 Jun 2001 14:49:17 -0700446_iso-8859-1 Raj, In order to decode the row, for compressed tablespaces, use FORMAT,EXPAND. This will format the data out in uncompressed format, so it will be readable. Then you will need to look at the definition of the table, and use the diagnosis guide and reference to break the raw data into individual columns. Good luck, Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 22329 68 46_Re: Looking for a pure DB2 systems programmer.15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM31_Wed, 27 Jun 2001 15:24:42 -0500392_iso-8859-1 Sorry it took so long to respond, but unfortunately they will not transfer an H1 for this position.

Thanks for your time and be sure to keep in touch.

Jeff Wrightsell

-----Original Message----- From: Bikash Paul [mailto:bikash_db@YAHOO.COM] Sent: Wednesday, June 27, 2001 2:43 PM To: DB2-L@RYCI.COM Subject: Re: Looking for a pure DB2 systems programmer. [...] 22398 25 26_Re: Overhead for IFCID 19813_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Wed, 27 Jun 2001 16:51:52 -0500320_- Thank you Joel, I'll be running it to IFI and the program has been tested with very short duration runs. Could you give some ballpark figures for the overhead before I find it out the hard way. Thanks again Mohammad

On Wed, 27 Jun 2001 14:03:49 -0400, Joel Goldstein wrote: [...] 22424 37 65_Urgent : Need help with the estimating size of table and indexes.10_Umesh Apte19_apteumesh@YAHOO.COM31_Wed, 27 Jun 2001 15:13:08 -0700337_us-ascii Hi List,

We are on DB2/UDB version 7.2. I have run statistics on all the tables with distribution and indexes.

Is there a formula or sample sql to estimate the size (in bytes, KB or MB) of table and size of indexes? The goal would be finally to sum it up across all tables and indexes and get the size of db? [...] 22462 83 16_Re: SQL Question17_Charles Jambrosic22_CJambrosic@CSIHOME.COM31_Wed, 27 Jun 2001 15:29:15 -0700454_us-ascii Because you cannot put specific values into a field with a load which is what we want to do with field1 but with the sql statement run in a DSNTIAD batch job it is all accomplished with one simple statement which is actually less complex than a unload/load.









Nadia Dimitrova To: DB2-L@RYCI.COM Subject: Re: SQL Question Sent by: DB2 Data Base Discussion List [...] 22546 54 36_Re: [DB2 Access from Cics and Batch]13_Larry Findley17_llfindley@USA.NET29_Wed, 27 Jun 2001 18:41:35 CDT510_US-ASCII Hi, Brian.

Yes, load modules must be linked differently for CICS vs batch. Also, if these modules are MVS linkage (which I am presuming) they must be either linked into the CICS module which calls them, or the calling program must use dynamic call protocol. If it is being done dynamically (please note that NODYNAM is REQUIRED for CICS programs) there must be a program definition in the CICS resource definitions for every program to be called dynamically using MVS linkage conventions. [...] 22601 88 15_Re: View Puzzle11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Thu, 28 Jun 2001 07:40:49 +0700613_- >What do you want this view for? > >This looks a lot more like a report formatting question than anything else, >so it would be interesting to know what, if any, query/reporting tools you >have available. > >Mike Holmans >BT ISE Database Services >mike.holmans@bt.com > >This post represents the views of the author and does not necessarily > accurately represent the views of BT > >> -----Original Message----- >> From: Endy Lambey [SMTP:endyl@CENTRIN.NET.ID] >> Sent: Wednesday, June 27, 2001 12:30 PM >> To: DB2-L@RYCI.COM >> Subject: [DB2-L] View Puzzle >> >> Guys, >> >> We have 1 tables (Tbl_A) with [...] 22690 99 15_Re: View Puzzle11_Endy Lambey20_endyl@CENTRIN.NET.ID31_Thu, 28 Jun 2001 07:46:31 +0700458_- Mike,

We are in process of Data Warehousing. Tbl_A represents the structure of one of our sources, which is in text file, Vw_A represents the structure of our Table in DW. In ETL process, we load the text file into Tbl_A, and during the transformation process we only want to use one step to generate the structure like Vw_A, and the the values from Vw_A will be loaded/appended into the DW. We are using DB2 7.1, and DB2 Warehouse Manager 7.1 [...] 22790 18 31_tpcc benchmark for os390 db2 v625_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG31_Thu, 28 Jun 2001 09:49:21 +0800369_us-ascii Hi,

Can anybody please point me to a website where I can get the OLTP benchmark for db2 v6 on os390.

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. 22809 190 46_Re: Looking for a pure DB2 systems programmer.14_Philip Gunning24_Philip.Gunning@QUEST.COM31_Wed, 27 Jun 2001 19:13:26 -0700366_iso-8859-1 Bikash, Unfortunately, at least 3,000 people now know of your plans. In the future, try not to post this type of stuff to the list by accident. Phil



Phil Gunning Assoc List Owner DB2-L

-----Original Message----- From: Bikash Paul To: DB2-L@RYCI.COM Sent: 6/27/01 12:42 PM Subject: Re: Looking for a pure DB2 systems programmer. [...] 23000 112 27_Re: DB2 V7 offsite recovery0_24_ujjwal@LOT.TATASTEEL.COM31_Thu, 28 Jun 2001 10:02:04 +0530633_iso-8859-1 Hi Grace, You should have 1) The image copies of all the Catalog,directory and user tablespaces. 2) Archive Logs 3) Integrated Catalog Facility Catalog Export and list 4) BSDS lists

The DB2 Catalog and DIrectory tablespaces should be copied as frequently as you do for your most critical user tablespaces. Schedule your image copies when the online activity is minimal .If U allow concurrent updating when imagecopy is taking place then QUIESCE is a must for those set of Tablespaces because COPY is not necessarily consistent data and can include uncommited changes. Then again you have to consider the trade [...] 23113 16 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM31_Thu, 28 Jun 2001 01:01:19 -0400452_us-ascii I will be out of the office starting 06/26/2001 and will not return until 07/02/2001.

For DB2 OS/390 assistance contact your support DBA. For Datajoiner / DB2 connect support contact Chuck Krall

================================================ 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. 23130 14 51_Daniel Sullivan/ZI/USA/Zurich is out of the office.15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Thu, 28 Jun 2001 00:39:32 -0500365_us-ascii I will be out of the office from 06/28/2001 until 07/02/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. 23145 16 47_Kimberlee Little/IT/SEARS is out of the office.10_Kim Little17_klittle@SEARS.COM31_Thu, 28 Jun 2001 01:46:23 -0500497_us-ascii I will be out of the office from 06/28/2001 until 06/29/2001.

I will respond to your message when I return. If an immediate response is necessary, please contact Pam Harris (PHARRI1) or the Logistics DB2 pager at 1-800-759-8888 PIN 7270526

================================================ 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. 23162 36 26_Re: Overhead for IFCID 19810_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 28 Jun 2001 09:16:20 +0200566_us-ascii Hi Mohammad...

As Joels said, IFCID 198 is very expensive. Chuck Hoover defined this trace 'UGLY!' as it traces microevents and in general thousands of 198s are created per second. Using IFI is the best choice (as I think it's used in some BP toolz).

According Chuck Hoover (Proceeding of 5th Annual European IDUG Conference, Amsterdam 1996) with 25 thread running simultaneously you've a 4% of CPU overhead to thread paths. One processor in a multiprocessor machine was estimated to be necessary just for IFCID 198 in a australian site. [...] 23199 46 36_Re: DB2 connect and stored procedure10_teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 28 Jun 2001 17:32:57 +1000369_us-ascii Sibi,

I get the return values correctly without having to set anything. I am not sure if something does need to be set. Especially since the precision gets returned as part of the return set column attributes. It cd have something to do with the variable into which u r getting the value. Try displaying the field immediately after ur "call proc". [...] 23246 171 35_Re: tpcc benchmark for os390 db2 v60_24_Bruce.Williamson@PSIR.IE31_Thu, 28 Jun 2001 08:28:38 +0100637_windows-1252 Howzit Srirengan?

Try http://tpc.org/

Cheers Bruce



__________________________________

Bruce Williamson DB2 Database Administrator

Perot Systems Information Resource Computer Centre Cabinteely Dublin 18 Ireland

Bruce.Williamson@psir.ie



-----Original Message----- From: Srirengan Venkatesh Kumar [mailto:SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG] Sent: 28 June 2001 02:49 To: DB2-L@RYCI.COM Subject: tpcc benchmark for os390 db2 v6



Hi,

Can anybody please point me to a website where I can get the OLTP benchmark for db2 v6 on os390. [...] 23418 32 34_Re: DB2 Access from Cics and Batch15_Rene hendriksen23_rene.hendriksen@UBS.COM31_Thu, 28 Jun 2001 02:20:16 -0500467_ISO-8859-1 Hello Brian

WE've had a similar problem with subprograms we want to be called running under different LI's (DSNELI, DSNALI and DFSLI000) but only in batch.

The solution was an assembler program (DB2HLI with an DSNHLI entry point), which was linked into all modules or dynamically called from COBOL at run-time. Then the program finds out which environment it's running in at this time and transfers control to the appropriate LI-module. [...] 23451 46 26_Re: DB2 v6.1 and old dbrms10_Ising, Eva18_eva.ising@DATEV.DE31_Thu, 28 Jun 2001 07:53:42 -0000564_iso-8859-1 Hello Tom,

my experience with old DBRMs is the following: If you have very old dbrms in your system, the rebind will fail with an error message, because there is really no colon in the dbrm. Since a couple of years (I don't know the DB2 Version) the dbrms are created with colons at the host variables even if they had none in the source code. These packages can be rebound and your application will run. To be sure that all applications will run in Version 6 I scanned my DB2 catalog. IBM provides via Internet download a procedure DBRMCHK [...] 23498 24 28_Compression with access path8_duam lee16_duam_lee@USA.NET29_Thu, 28 Jun 2001 03:12:38 MDT374_US-ASCII Hi listers, here is a doubt I m posting about the comparison of access from the same table with same query and same amount of data in two cases . Case 1. Tablespace is compressed one and the case2 Tablespace is not compressed one. Here the compression I m asking is about the DB2 compression not the hardware compression.Waiting for your valuable suggestions. [...] 23523 16 31_Sql stored procedure size limit15_Priyanka Deswal19_prdeswal@IN.IBM.COM31_Thu, 28 Jun 2001 14:47:53 +0530354_us-ascii Has anyone encountered size limit problem of 64K in Db2 Sql stored procedures??

Regards Priyanka

================================================ 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. 23540 106 35_Re: Sql stored procedure size limit12_Aedan Molony20_Aedan.Molony@PSIR.IE31_Thu, 28 Jun 2001 11:45:38 +0100603_windows-1252 Hi list!

We are currently planning a migration of a production system from DB2 V5 to DB2 V6.1. This is a non data-sharing environment with DDF installed which is used for DataPropgator Apply. When defining the ZPARMS for previous migration of test systems to DB2 V6, we set the value of DBPROTCL to DRDA. On fallback testing to DB2 V5 no issues were identified regarding this setting. However, has anyone experienced any problems with plans or packages (are not used in a Data-Sharing environment & do not reference three-part names ) on fallback to DB2 V5 when DBPROTCL is set [...] 23647 87 21_Re: ADDRESS DSNREXX ?11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Thu, 28 Jun 2001 07:54:45 -0400507_iso-8859-1 I know that a version of rexx is installed with DB2 for Windows or AIX. You may want to check to see if one is there for other flavors of Unix.

-----Original Message----- From: Sharpe, Richard [mailto:rsharpe@AMHERST1.COM] Sent: Monday, June 25, 2001 8:20 AM Subject: Re: ADDRESS DSNREXX ?



I used to use REXX on the mainframe many years ago, can it be used on SOLARIS or LINUX ? This would be great if a scripting language like REXX were available on those platforms.. [...] 23735 24 37_Re: Select Varchar groupby nonvarchar20_Dr. Matthias Wehrens29_matthias.wehrens@AM-GRUPPE.DE31_Thu, 28 Jun 2001 06:51:28 -0500288_- I'm wondering about the intention of this SQL - perhaps you will sort the result set, but then you should use "order by" and not "group by". For "group by" you have to include column functions - such as COUNT - in the "select", all other expression must be in the group by clause. [...] 23760 62 26_Re: Overhead for IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 28 Jun 2001 08:07:22 -0400451_ISO-8859-1 Like many things, it is not only what you do, but how you do it, and the efficiency or your written code. We are currently dealing with some systems that generate > 1 million 198 records per minute. This can be very high overhead, or it can be manageable. As an example, the collector we use for Buffer Pool Tool, which also collects the 6-10 records in addition to the 198's, is typically less than 4% overhead for the entire system. [...] 23823 42 21_Re: CA Fast Utilities12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Thu, 28 Jun 2001 08:08:08 -0400409_US-ASCII We are also upgrading our Platinum suite and have had numerous problems. Every time we get one thing fixed, there is another bug found. We asked if CA had a maintenance tape with all known problems fixed and they said that they did not. So until we can get our Platinum products stabilized, we are holding off on going to version 6. We are also seriously considering going back to IBM utils.... [...] 23866 68 21_Re: CA Fast Utilities18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 28 Jun 2001 08:49:07 -0400295_iso-8859-1 Mark: I was in that same position here so we dropped back to our P97F and proceeded to move ahead with DB2 Verison 6. We had to apply some fixes to P97F but so far we have not run into any showstoppers with DB2 V6. I'll tackle another CA upgrade after we get DB2 V6 installed... [...] 23935 120 16_Re: SQL Question0_26_JCameron@MSI-INSURANCE.COM31_Thu, 28 Jun 2001 07:47:01 -0500685_us-ascii But you can put a specific value in on the unload by using the SQL option, then LOAD that file.









Charles Jambrosic To: DB2-L@RYCI.COM Subject: Re: SQL Question Sent by: DB2 Data Base Discussion List



06/27/01 05:29 PM Please respond to DB2 Data Base Discussion List











Because you cannot put specific values into a field with a load which is what we want to do with field1 but with the sql statement run in a DSNTIAD batch job it is all accomplished with one simple statement which is actually less complex than a unload/load. [...] 24056 25 26_Re: Overhead for IFCID 19810_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 28 Jun 2001 14:59:06 +0200414_us-ascii Of course: 'EST MODUS IN REBUS' as Romans said.

Unfortunately it's uncommon (as far as I know) to let a program (even if a performance program) to run at the same priority of certain address spaces (expecially a user program) . And it's sound strange (to me, useless DB2 sysprog) that a program with an high priority doesn't weigh on CPU, as there are DB2 traces with an overhead on CPU > 1%. [...] 24082 62 21_Re: CA Fast Utilities16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 28 Jun 2001 08:55:03 -0400448_iso-8859-1 We are at DB2 V7. We are more than 'seriously considering going back to IBM utilities'. We are committed to doing so before our OEM contract renewal so we can drop the non-IBM products. Too many problems with 'not IBM'.

Regards. eric pearson



-----Original Message----- From: Mark Anzmann [mailto:MAnzmann@DHR.STATE.MD.US] Sent: Thursday, June 28, 2001 8:08 AM To: DB2-L@RYCI.COM Subject: Re: CA Fast Utilities [...] 24145 107 52_DBPROTCL and DRDA - DB2 OS390 V6 (Repost, apologies)12_Aedan Molony20_Aedan.Molony@PSIR.IE31_Thu, 28 Jun 2001 14:05:35 +0100603_windows-1252 Hi list!

We are currently planning a migration of a production system from DB2 V5 to DB2 V6.1. This is a non data-sharing environment with DDF installed which is used for DataPropgator Apply. When defining the ZPARMS for previous migration of test systems to DB2 V6, we set the value of DBPROTCL to DRDA. On fallback testing to DB2 V5 no issues were identified regarding this setting. However, has anyone experienced any problems with plans or packages (are not used in a Data-Sharing environment & do not reference three-part names ) on fallback to DB2 V5 when DBPROTCL is set [...] 24253 27 9_Max Locks0_29_sflindsey@HIGHLIGHTS-CORP.COM31_Thu, 28 Jun 2001 09:05:57 -0400542_us-ascii Good morning listers! I am receving a max number of locks error on a program that has run a number of times before without any problems. I opens and closes the first 3 of 4 cursors and bombs on the open of the 4th cursor. The error message is as follows: DSNT501I - DSNILMCL RESOURCE UNAVAILABLE 005 CORRELATION-ID=HNPSWA01 CONNECTION-ID=BATCH LUW-ID=* REASON 00C90096 TYPE 00000302 NAME DSNDB01 .SCT02 .X'005046' I am on OS/390 and DB2 V5. Does anyone have any suggestions?? TIA, Scott Lindsey Sr. DBA, Highlights for Children [...] 24281 83 21_Re: CA Fast Utilities0_20_John_Lendman@FPL.COM31_Thu, 28 Jun 2001 08:50:02 -0400519_us-ascii We had a problem with 99D of Platinum also. But just we just received a fix tape. I test the fix and it seems to work. The rest of the testing has shown that we are ready to implement 99D. I will let you know as we move forward.

The problem that I received the fix for was when I was in the PDA product and I was generating Image copies for my SAP system. The product was not creating multiple image copies per step. It was also abending sometimes with an OC4. It seems that both of these problems [...] 24365 52 30_Re: Finding Record information14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 28 Jun 2001 08:10:39 -0500340_- As others have suggested, you could use DSN1PRNT - but depending on , the row might have been deleted by the time you run it.

Alternatively, in V6+, if the table has a rowid column you could SELECT ... WHERE HEX(SUBSTR(ROWID_COL,18,4)) = (or SUBSTR(...,5) for a large tablespace.) [...] 24418 56 13_Re: Max Locks16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 28 Jun 2001 09:29:36 -0400340_iso-8859-1 Suggestion #1 will probably fix this permanently: COMMIT after each OPEN/CLOSE CURSOR. Aside: Most DBAs *love* to see COMMITs. Most programmers are allergic to them. Suggestion #2 will work if you do not need to update this from other tasks while your task is running: LOCK TABLE... IN SHARE MODE before opening the cursor. [...] 24475 105 21_Re: CA Fast Utilities16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 28 Jun 2001 09:32:00 -0400289_iso-8859-1 Do you have any LARGE tablespaces (I mean created with the LARGE operand in the DDL)? We cannot run PDA against these at P99D - it gets GETMAIN errors. I would be interested in hearing if the maint fixes that too. In our shop it seems P99D has been a pretty sorry release. [...] 24581 13 13_Re: Max Locks15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Thu, 28 Jun 2001 08:42:14 -0500359_us-ascii You could try putting some commits in the program to release previous locks. Even though it's just a select.

================================================ 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. 24595 13 13_Re: Max Locks15_Daniel Sullivan28_daniel.sullivan@ZURICHNA.COM31_Thu, 28 Jun 2001 08:43:25 -0500329_us-ascii Has someone recently changed to plan to rr instead of cs? I'd alos check 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. 24609 39 20_Re: Synonym question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 28 Jun 2001 08:58:33 -0500400_- FWIW (given that you no longer have this problem) a "stored procedure" consists of two parts: - a SP definition which defines the SP name, parameters, and environmentals (including module name and (V6+) SPAS/WLM name) - the program that does all the work.

There is nothing to stop you having two SPs, with identical parameters and environmentals - ie they both invoke the same routine. [...] 24649 68 27_Re: 4 hours time difference0_19_mike.holmans@BT.COM31_Thu, 28 Jun 2001 15:05:54 +0100644_- All sysplex coupling facilities run on UTC/GMT.

Mike Holmans BT Affinitis Computing Partners mike.holmans@bt.com

This post represents the views of the author and does not necessarily accurately represent the views of BT

> -----Original Message----- > From: Robert Jans [SMTP:robert_jans@ALBERTSONS.COM] > Sent: Wednesday, June 27, 2001 6:50 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] 4 hours time difference > > Since DB2's CURRENT TIMESTAMP pulls the time from the system, I'd suggest > asking your MVS people what time they run on the box or LPAR you're doing > this on. I'd guess that 4 hours from EDT should [...] 24718 108 21_Re: CA Fast Utilities11_Moore, Tony15_TMoore@IKON.COM31_Thu, 28 Jun 2001 09:41:20 -0400337_iso-8859-1 P99E is now available. I was having some problems with maintenance on P99D and the CA guy I was working with suggested just skipping P99D all together and going with P99E. No telling how big a can of worms I've opened with this act, but I've took the advice and have backed off P99D and am going with P99E. We shall see. [...] 24827 148 21_Re: CA Fast Utilities0_20_John_Lendman@FPL.COM31_Thu, 28 Jun 2001 10:16:13 -0400438_us-ascii Eric, do we do not have any "Large" tablespace as yet, although we are looking at that right now. So it is good to know that we might have a potential problem. Thanks

John C. Lendman DBA Jlendman@fpl.com (561) 694-5085 Beeper FPL 7413





"Pearson, Eric L," To: DB2-L@RYCI.COM Subject: Re: CA Fast Utilities Sent by: "DB2 Data Base Discussion List" [...] 24976 64 56_Re: DBPROTCL and DRDA - DB2 OS390 V6 (Repost, apologies)14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 28 Jun 2001 10:20:17 -0400377_iso-8859-1 The problem that you may face is that if you have programs that refer to tables across DB2 subsystems with a 3-part name (or alias) the program will now expect a package on the remote subsystem and you will get a -805 if you do not have one.

With private protocol you do not need the package to be bound to the remote subsystem whereas with DRDA you do. [...] 25041 60 46_Re: Looking for a pure DB2 systems programmer.17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Thu, 28 Jun 2001 09:21:27 -0500188_iso-8859-1 >> Looking for a "pure" DB2 systems programmer.

Isn't this discriminatory against those who may have a questionable past?

:-)

Ken K.





25102 49 26_Re: Overhead for IFCID 19812_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 28 Jun 2001 09:23:53 -0500539_iso-8859-1 I'm going to agree with Joel ... If you want to monitor a DB2 subsystem, then the monitor HAS to run at the same or greater priority than the DB2 subsystem it is monitoring. What this also says is caveat emptor. Be careful about the monitor that you buy and insure that it will have the necessary controls to minimize the overhead of the collection process. I work for a company that provides monitors for DB2 and the one item that we struggle with the most is how to get enough information to do some good and at the same [...] 25152 77 34_Re: DB2 Access from Cics and Batch0_22_Rohn.Solecki@MTS.MB.CA31_Thu, 28 Jun 2001 09:25:03 -0500331_iso-8859-1 For some small common modules we created a copy member for the PROCEDURE DIVISION with all of the common code and calls to paragraphs that contained CICS/BATCH environment specific code. Then we coded 2 shell programs that copied the common procedure division and explicitly coded the CICS/BATCH env specific code. [...] 25230 59 13_Re: Max Locks13_Robert Tilkes22_TILKESR@NATIONWIDE.COM31_Thu, 28 Jun 2001 09:31:29 -0500344_us-ascii Check to make sure that the plan and the package binds are correct as mentioned before make sure the Isolation level is CS and the CURRENTDATA option is NO. If it is set to YES and you are doing read only applications it will take a X lock on those pages even if you qualify your SQL until either commit or end of program occurs. [...] 25290 53 35_Re: tpcc benchmark for os390 db2 v614_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 28 Jun 2001 09:22:07 -0500753_- You'll have to be a little more specific. There do not appear to be _any_ OS/309 (or z/OS) reults on tpc.org (not just no tpc-c results).

James

On Thu, 28 Jun 2001 08:28:38 +0100, Bruce.Williamson@PSIR.IE wrote:

>Howzit Srirengan? > >Try http://tpc.org/ > >Cheers >Bruce > > >__________________________________ > >Bruce Williamson >DB2 Database Administrator > >Perot Systems Information Resource >Computer Centre >Cabinteely >Dublin 18 >Ireland > >Bruce.Williamson@psir.ie > > >-----Original Message----- >From: Srirengan Venkatesh Kumar >[mailto:SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG] >Sent: 28 June 2001 02:49 >To: DB2-L@RYCI.COM >Subject: tpcc benchmark for os390 db2 v6 > > >Hi, > >Can anybody please point me to a [...] 25344 236 46_Re: Looking for a pure DB2 systems programmer.15_Jeff Wrightsell27_jwrightsell@RAPIDDEPLOY.COM31_Thu, 28 Jun 2001 09:23:15 -0500436_iso-8859-1 Not if you're interested in being "born again" as a "pure" Systems programmer.

-----Original Message----- From: Kornblum, Kenneth [mailto:Kenneth_Kornblum@BMC.COM] Sent: Thursday, June 28, 2001 9:21 AM To: DB2-L@RYCI.COM Subject: Re: Looking for a pure DB2 systems programmer.

>> Looking for a "pure" DB2 systems programmer.

Isn't this discriminatory against those who may have a questionable past? [...] 25581 22 19_Upper Case Function13_Keerthi Chegu18_lpbusobj@YAHOO.COM31_Thu, 28 Jun 2001 10:02:35 -0500347_- All Db2gurus:

I have been trying to convert all user entered values to upper case and tried the UCASE function. But, get an error against Db2 V5 on OS/390. The Db2 sql refrence manual fro v 5/0s390 does not have any upper case function.

In my query, users enter a country name and I would like to pass the value in uppercase. [...] 25604 50 26_Re: Overhead for IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 28 Jun 2001 11:09:24 -0400563_ISO-8859-1 Not uncommon at all, Max. Any performance monitor should be running at a HIGHER priority than the address space it monitors. The reason the IFI program MUST run at a high priority is quite simple. It sits there and waits until DB2 has filled 80% of the IFI buffer, then it has to get (empty) the buffer. If it can't get dispatched quickly enough, the buffer fills/overflows... and you lose data. A high dispatching priority does not necessarily mean a progam will use more CPU, it only means it will be dispatched quicker, and do its work faster. [...] 25655 48 13_Re: Max Locks16_S, Sanjeev (CTS)26_SSanjeev@CAL.COGNIZANT.COM31_Thu, 28 Jun 2001 19:56:29 +0530588_- Check that by any chance the tables involved have row locking in place. It will increase the number of locks....

HTH Regards Sanjeev

> -----Original Message----- > From: sflindsey@HIGHLIGHTS-CORP.COM [SMTP:sflindsey@HIGHLIGHTS-CORP.COM] > Sent: Thursday, June 28, 2001 6:36 PM > To: DB2-L@RYCI.COM > Subject: Max Locks > > Good morning listers! I am receving a max number of locks error on a > program > that has run a number of times before without any problems. I opens and > closes > the first 3 of 4 cursors and bombs on the open of the 4th cursor. The > error > [...] 25704 40 26_Re: Overhead for IFCID 19810_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 28 Jun 2001 17:49:29 +0200389_us-ascii Hi Tom, Hi Joel

Of course you and Joel are right, to avoid buffer problems a MONITOR program must run to higher or equal priority.

It's somehow similar to buffer underrun when you burn a CD ROM with a old CD writer (let me pass the example).

And of course this does not necessarily that this program consumes more CPU. If needed he can quickly work, but [...] 25745 60 37_Re: Select Varchar groupby nonvarchar5_Chris17_isatcjk@YAHOO.COM31_Thu, 28 Jun 2001 08:53:34 -0700333_us-ascii The table was created without a unique index or primary key, I guess in order to simplify a rather insignificant part of the system. A collegue was trying to clean up some duplicate data. He chose to make the assumption that two non-varchar columns were pretty much the unique key (losing some data was not a problem). [...] 25806 160 21_Re: CA Fast Utilities0_19_csutfin@AMSOUTH.COM31_Thu, 28 Jun 2001 11:06:42 -0500377_us-ascii Sounds like we all are having major problems with P99D. I have been working on getting this release to work since mid-February. We cannot move DB2V6 into our production DB2 subsystem until the problems are fixed. We did upgrade our application test subsystem to V6 and still have P97G there. I am constantly having compatibility problems between DB2 V6 and P97G. [...] 25967 54 33_Re: Migrating DB2 to new hardware11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Thu, 28 Jun 2001 17:46:47 +0100343_us-ascii The OS and DB2 directories will have be installed on the new box.

You will then need to shut down the instance(s) and export the volume groups.

When you move the disks to the new box, you need to import the volume groups. So long as you have the sameversion of DB2 on the different boxes, this will work correctly. [...] 26022 23 15_archive logging17_John Breidenstine31_JBreidenstine@LEGIS.STATE.PA.US31_Thu, 28 Jun 2001 12:47:26 -0400409_iso-8859-1 Hello Listserve,

DB2 V6.1 on AIX.

I am about ready to start archive logging on a database using the db2uext2.c user exit program. As of now the active logs are written to their own logical volume on separate disk then the database. I would like to know if would be OK to archive them to the same logical volume. Or is it best to create a separate one just for the archived logs? [...] 26046 72 26_Re: Overhead for IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 28 Jun 2001 12:53:22 -0400609_ISO-8859-1 Max, Unless you have both a stand-alone system, and a workload that you can drive at a consistent and repeatable level, any attempt at benchmarking performance traces is meaningless. There are some few (non-vendor) sites out there that have such environments, but I haven't heard of anyone trying to benchmark the overhead of the 198 trace. Then there is also the variability of the trace itself, versus the efficiency of the IFI code, manner of writing out the trace data... which can be of the higher overhead components. The results would still vary slightly from whatever you would get at [...] 26119 92 22_Create Trigger Problem9_Ray Potts23_potta56@DSS.STATE.MO.US31_Thu, 28 Jun 2001 11:56:34 -0500399_us-ascii Hi List,

I'm having a problem creating a trigger in DB2 V6 for OS390. I run the SQL below and get the error.

DSNT408I SQLCODE = -104, ERROR, ILLEGAL SYMBOL "". SOME SYMBOLS THAT MIGHT BE LEGAL ARE :

This error follows the semi-colon on the Insert statement. If I comment out the insert statement, I get the same error after the semi-colon on the update statement. [...] 26212 15 24_Archive log compression.12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Thu, 28 Jun 2001 11:54:03 -0500341_- Is anyone compressing their DB2 archive log datasets using Extended sequential datasets with compaction on? This is a feature of OS/390 software. I know of all the third party compression tools, but I would like to know of any issues using IBM's built in compression and DB2 reading those compressed archive logs for recovery. Thanks [...] 26228 112 26_Re: Create Trigger Problem11_Sinha, Amit19_Sinha.Amit@MBCO.COM31_Thu, 28 Jun 2001 12:12:57 -0500384_iso-8859-1 You are running it thru spufi then you will have to go in change defaults option make sql terminator as : and not ; and end your sql statement with : and that should work.

HTH

Amit

-----Original Message----- From: Ray Potts [mailto:potta56@DSS.STATE.MO.US] Sent: Thursday, June 28, 2001 11:57 AM To: DB2-L@RYCI.COM Subject: Create Trigger Problem [...] 26341 48 46_Re: Looking for a pure DB2 systems programmer.12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 28 Jun 2001 10:19:47 -0700589_us-ascii As in questionable, I assume you mean someone who installed Oracle before they knew better?

Actually, I kind of like it when people miss-post (get it) messages to db2-l. Now we all know AMEX is hiring in both hot and cold climates. Take your pick. Maybe if we all post our job search correspondence with head...um recruiters, we can form a big job swap bazaar and cut out the head...um middlemen. Something like "Hey- I'm looking for a DB2 job in Florida. Am willing to trade with anyone willing to move to Pittsburgh". With corporate sponsored finders fees, we could [...] 26390 74 33_Re: Migrating DB2 to new hardware12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 28 Jun 2001 10:26:25 -0700384_us-ascii I'd recommend you 1.Install DB2 on the new box 2.Backup the databases on the old box 3.Do a redirected restore to the new box 4.Move the disks to the new box. 5.Backup/redirect restore to the disks just moved.

Assuming you have adequate disk drives, of course. This leaves you with a smaller outage, when db2 is unavailable, and built in fallbacks along the way. [...] 26465 85 34_Re: DB2 Access from Cics and Batch12_Mark Anzmann24_MAnzmann@DHR.STATE.MD.US31_Thu, 28 Jun 2001 13:25:04 -0400371_ISO-8859-1 Another way that I have done this in the past is to make any module that is needed by both CICS and Batch a CICS program. Using stored procedures and EXCI, you can call these CICS programs from batch and it eliminates any duplication of coding. There is an article in the DB2 Magazine on this - http://www.db2mag.com/db_area/archives/1999/q4/db2dba.shtml [...] 26551 34 69_Re: Urgent : Need help with the estimating size of table and indexes.17_Walter Trovijo Jr22_wtrovijo@COELBA.COM.BR31_Thu, 28 Jun 2001 14:53:21 -0300155_us-ascii IF statistics are updated you can sum SPACE for all tablespaces and Indexes (SYSTABLEPART and SYSINDEXPART) .

HTH,

Walter Trovijo Jr 26586 115 26_Re: Create Trigger Problem11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 28 Jun 2001 13:18:22 -0500621_- Ray - assumimg you are running this via spufi, change the delimiter to something other than ";" e.g. "#". You should also have a # at the end after the last END - not required, good practice.

HTH.

Suresh



>From: Ray Potts >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Create Trigger Problem >Date: Thu, 28 Jun 2001 11:56:34 -0500 > >Hi List, > >I'm having a problem creating a trigger in DB2 V6 for OS390. I >run the SQL below and get the error. > >DSNT408I SQLCODE = -104, ERROR, ILLEGAL SYMBOL "". SOME SYMBOLS THAT [...] 26702 147 26_Re: Create Trigger Problem9_Ray Potts23_potta56@DSS.STATE.MO.US31_Thu, 28 Jun 2001 13:23:50 -0500568_us-ascii Thanks Amit,

I was able to create the trigger after a few other corrections.



"Sinha, Amit" cc: Sent by: DB2 Subject: Re: Create Trigger Problem Data Base Discussion List



06/28/2001 12:12 PM Please respond to DB2 Data Base Discussion List











You are running it thru spufi then you will have to go in change defaults option make sql terminator as : and not ; and end your sql statement with : and that should work. [...] 26850 67 70_Re: Urgent : Need help with the estimating size of table and inde xes.13_Keith Gilbert17_kgilbert@CSA1.COM31_Thu, 28 Jun 2001 13:23:38 -0500500_iso-8859-1 Umesh,

IBM provides the DB2 Estimator as a FREE DOWLOAD at this site....

http://www-4.ibm.com/software/data/db2/os390/estimate/

It should do the job for you.



Keith Gilbert DBA Central Service Association Tupelo, MS USA





-----Original Message----- From: Umesh Apte [mailto:apteumesh@YAHOO.COM] Sent: Wednesday, June 27, 2001 5:13 PM To: DB2-L@RYCI.COM Subject: Urgent : Need help with the estimating size of table and indexes. [...] 26918 57 19_Re: archive logging12_tim malamphy20_timalamphy@YAHOO.COM31_Thu, 28 Jun 2001 11:51:15 -0700558_us-ascii I think you want a separate disk drive to archive them to. Otherwise, your archival will get in the way of active logging. Of course, if all your active logs are on the same disk drive, the archival will still get in the way of active logging, because it's reading from the same place db2 will want to write log records to. Better to have (at least) 2 different physical drives for active logging, and then you can archive them to a different single drive which holds the archived logs. Of course it all comes down to resources vs performance. [...] 26976 171 21_Re: CA Fast Utilities9_Rob Crane22_racrane@CONCENTRIC.NET31_Thu, 28 Jun 2001 13:23:46 -0600511_us-ascii Having the necessary fix tapes ontop of P99D and P99E is important. Finding out about fix tapes outside of hiper items can be a challenge, I believe there is some work in the Esupport area at CA that should elevate some of this in the near future. If you are interested in seeing the list of fix tapes I have put on top of P99D, and the ones I am currently putting on top of P99E send me a note off line and I can send you some information that might be helpful. Currently have P99D plus 11 or so [...] 27148 97 19_Re: archive logging15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Thu, 28 Jun 2001 14:21:08 -0500500_us-ascii Another consideration: If logs are going to be used for recovery, you do not want the active logs and archive logs on the same volume/disk. If there is a disk failure, you would lose all logs. Not a good thing!



Debra Jordan Infrastructure Database Management Discover Financial Services (847) 405-1415





tim malamphy cc: Sent by: DB2 Subject: Re: archive logging Data Base Discussion List [...] 27246 25 26_Re: Overhead for IFCID 19813_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 28 Jun 2001 14:10:58 -0500541_- Thanks for all your input. I've tried to keep the program as efficient as I can. It waits on ECB and uses asynchronous read to get the data. I'm not moving this data to any "record definition" areas rather setting pointers to map the definitions in place. Each record's pageset is then binary searched in an in memory array (which was set up before the trace started) and a few counters are incremented. This array is written to a disk file only AFTER the trace has been turned off. If this gives me under 5% overhead I can live with [...] 27272 65 26_Re: Overhead for IFCID 19812_Moulder, Tom19_Tom_Moulder@BMC.COM31_Thu, 28 Jun 2001 14:40:35 -0500379_iso-8859-1 Just wondering ...

BMC's new product Pool Advisor does not use IFCID 198, but overhead is always a concern. So first is anyone trialing this product -- I sure do hope so -- and if so can you share your experiences with the overhead of the product. Our aim is to keep it low and it would be nice to know if we are meeting user expectations of low overhead. [...] 27338 34 22_create trigger problem16_Proctor, William25_william.proctor@TGSLC.ORG31_Thu, 28 Jun 2001 15:01:27 -0500519_iso-8859-1 Hello, I am trying to create a trigger that will when fired off will update another column in the row being updated. the table has only two columns (uid, process). When process is updated I want the trigger to fire off and get the max(uid) + 1 and update the uid column. I can get the update to work but it updates every row in the table. I'm new to DB2 and Sql and could use some help with this. Below is the code that I"m currently trying that causes every row to be updated. I can't get the max(uid) [...] 27373 69 26_Re: create trigger problem11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 28 Jun 2001 15:43:01 -0500381_- Bill,

Assuming you want to (a) update only the row you just updated (not entire table) (b) the max is over the entire table,

try (have not tested - may be sysntax errors):

CREATE TRIGGER MAX_UID AFTER UPDATE OF PROCESS ON WHSE.UID REFERENCING OLD AS O NEW AS N FOR EACH ROW MODE DB2SQL BEGIN ATOMIC UPDATE WHSE.UID SET UID = (SELECT MAX(UID) + 1 FROM ; [...] 27443 68 38_Re: create trigger problem - try again11_Suresh Sane21_data_arch@HOTMAIL.COM31_Thu, 28 Jun 2001 15:46:14 -0500345_- Sorry - last one got sent incomplete.

Assuming the row to be updated is 1 while max is over the entire table - try:

CREATE TRIGGER MAX_UID AFTER UPDATE OF PROCESS ON WHSE.UID referencing old as o FOR EACH ROW MODE DB2SQL BEGIN ATOMIC UPDATE WHSE.UID SET UID = (select max(UID) + 1 form whse.uid) where process = o.process ; [...] 27512 46 23_Re: Upper Case Function13_Daniel Turner28_daniel_turner@ALBERTSONS.COM31_Thu, 28 Jun 2001 14:46:37 -0600386_- No joy. the UPPER and LOWER functions come in version 6.

ASCII data can be case translated by XORing each character with a bit map that happens to be a space. EBCDIC may have a simular trick but it looks like something outside of DB2 for you for now. You say the "users enter a country name". Where do they do the dataentry, and can the conversion happen upstream of DB2? [...] 27559 81 23_Re: Upper Case Function12_Mark Granger22_the_grange@MBOX.COM.AU31_Thu, 28 Jun 2001 16:04:11 -0500456_us-ascii You can use the OR with blanks on EBCDIC as well. It works to convert lower case to upper case.

Mark Granger Independent Systems Integrators P/L Senior Technical Specialist - 2BDB2 Email: mgranger@isi.com.au Phone: +61 0416-012-262 (Australia) OR +1 617-306-7794 (USA)



----- Original Message ----- From: Daniel Turner Date: Thursday, June 28, 2001 3:46 pm Subject: Re: Upper Case Function [...] 27641 68 23_Re: Upper Case Function16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 28 Jun 2001 17:08:33 -0400419_iso-8859-1 V7 of DB2/390 has this. I suspect V6 does also since there are no 'change bars' next to the scalar function in SQL Reference. Any chance of a V6 or V7 upgrade?

Regards. eric pearson NS ITO Database Support



-----Original Message----- From: Daniel Turner [mailto:daniel_turner@ALBERTSONS.COM] Sent: Thursday, June 28, 2001 4:47 PM To: DB2-L@RYCI.COM Subject: Re: Upper Case Function [...] 27710 44 21_Re: CA Fast Utilities10_Alan Smith25_alancsmith@BTINTERNET.COM31_Thu, 28 Jun 2001 23:33:09 +0100575_us-ascii Fast Recover - removed it as couldn't see much point in having it as IBM recover works OK and it also brought down a subsystem a couple of times. Rapid Reorg - we found no appreciable improvement over IBM utilities in terms of speed, and a lot less robust (think this also brought down a subsystem). Fast Unload - a lot faster than REORG UNLOAD EXTERNAL and High Performance Unload. Four times faster than High performance Unload when unloading from image copies, but cannot handle inline image copies (from reorg or load). Fast Load - we use this because it's [...] 27755 49 23_Re: Upper Case Function12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Fri, 29 Jun 2001 09:14:51 +1000466_- KC, you can also get to all the DB2 manuals (in PDF & HTML format) by downloading off the site : http://www-4.ibm.com/software/data/db2/os390/library.html



Note to that UPPER or UCASE is a "new" V6 function, so you won't find it in V5.

Cheers, Nick Cianci DB2 DBA - CCRI Project 5th Floor (South) 484 StKilda Rd MELBOURNE 3004 * +613) 9865-8354 Work 0408-64 06 01 Mobile * MailTo:Nick.Cianci@team.telstra.com MailTo:NCianci@CPTglobal.com [...] 27805 57 13_Re: Max Locks15_Bell, Raymond W31_Raymond.W.Bell@TEAM.TELSTRA.COM31_Fri, 29 Jun 2001 10:43:02 +1000446_- Hi Scott,

I'm assuming the program hasn't changed and is now magically failing. Things you could look into include:

* Has the tablespace's LOCKSIZE clause been altered to be more granular? * Have the ZPARM value NUMLKUS been reduced for this subsystem?

It might also be a good time to send the program(mer?) to a therapy session to overcome, as I've heard it called here on the list, Bachelor Syndrome (can't commit). [...] 27863 85 26_Re: Overhead for IFCID 19814_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 28 Jun 2001 22:53:27 -0400593_ISO-8859-1 It depends on what you want to do with the data. If your intent is buffer pool tuning then you need tha ability to predict. If you can't predict, any tuning is a guessing game. You can't predict using system statistics, or summary data. The effective tuning scenario is to group objects together by access type and working set..... and the prediction part comes into play to determine both how large/small to make a pool, and to see the impact of moving (grouping) objects without actually doing it... and hurting your system performance. You don't want to play guessing games [...] 27949 152 29_Re: Query on Nested Loop Join13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 28 Jun 2001 23:42:07 -0500527_iso-8859-1 Loga,

There is a section in the Administration Guide dedicated to the statistics used for access path selection. Of particular interest will be two sections, "Understanding Statistics for Access Path Selection", and "Modelling Your Production System".

If all the catalog statistics are the same between the two environments (clusterratios, partition key ranges, cardinalities etc), then it could come down to differing processors, Buffer pool sizes (and hence prefetch quantities), RID pools etc. [...]