1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2000, week 4 2 47 54_AW: Can a change in HPSEQT increase buffer pool paging12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 22 Aug 2000 08:25:02 +0200445_iso-8859-1 Yes, Joel,

see you in Geneva....

Regards, G e o r g



-----Ursprüngliche Nachricht----- Von: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM] Gesendet am: Montag, 21. August 2000 17:46 An: DB2-L@RYCI.COM Betreff: Re: Can a change in HPSEQT increase buffer pool paging

Les, I saw Georg Peter sent it to you (thanks Georg, but I'll repeat anyway. Are you coming to IDUG/Geneva? Regards, Joel [...] 50 14 35_Tom Reichardt is out of the office.0_17_treicha@SEARS.COM31_Tue, 22 Aug 2000 01:30:30 -0500365_us-ascii I will be out of the office from 08/22/2000 until 08/28/2000.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 65 18 31_Public access to Catalog tables20_Beighton-Dykes, Hugh27_hugh.beighton-dykes@EDS.COM31_Tue, 22 Aug 2000 09:27:01 +0100466_iso-8859-1 V5 OS390

Would any of you have any reservations about granting SELECT access to PUBLIC on all of the DB2 Catalog tables in a development subsystem? What about in a production one?

Hugh Beighton-Dykes

================================================ 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. 84 35 35_Re: Public access to Catalog tables19_Briggs, N. - Neil -25_N.Briggs@CANON-EUROPA.COM31_Tue, 22 Aug 2000 10:31:23 +0200512_iso-8859-1 We have the catalogue tables granted to public in both test and production.

Regards Neil

-----Original Message----- From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] Sent: Tuesday, August 22, 2000 10:27 AM To: DB2-L@RYCI.COM Subject: Public access to Catalog tables



V5 OS390

Would any of you have any reservations about granting SELECT access to PUBLIC on all of the DB2 Catalog tables in a development subsystem? What about in a production one? [...] 120 112 35_Re: Public access to Catalog tables0_18_mebert@AMADEUS.NET31_Tue, 22 Aug 2000 10:36:47 +02001593_us-ascii It's the same here - public access in P and T.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany







From: "Briggs, N. - Neil -" on 22/08/2000 08:31 GMT

Please respond to DB2 Data Base Discussion List









|---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> |To: | |---------> >---------------------------------------------------------------------------> |DB2-L@RYCI.COM | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> |cc: | |---------> >---------------------------------------------------------------------------> | (bcc: Michael Ebert/MUC/AMADEUS) | >---------------------------------------------------------------------------> >-------------------------------------------| | | | | >-------------------------------------------| |---------> | | |---------> >---------------------------------------------------------------------------> | | >---------------------------------------------------------------------------> >-------------------------------------------| | | >-------------------------------------------| |---------> [...] 233 56 35_AW: Public access to Catalog tables12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 22 Aug 2000 10:39:09 +0200668_iso-8859-1 Hugh,

should be no problem in pure development systems.

Granting SELECT access to PUBLIC on all of the DB2 Catalog tables in a PRODUCTION subsystem is not a good idea. Why should developers make the production catalog busy ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 290 80 35_Re: Public access to Catalog tables23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 22 Aug 2000 09:50:32 +0100439_iso-8859-1 good point .. could hurt your Virtual Pools .. and in our dynamic system things could get very interesting if people started scanning certain tables.

Leslie

-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Tuesday, August 22, 2000 9:39 AM To: DB2-L@RYCI.COM Subject: AW: Public access to Catalog tables



Hugh,

should be no problem in pure development systems. [...] 371 58 35_Re: Public access to Catalog tables0_22_The-Thanh.Luong@AGF.BE31_Tue, 22 Aug 2000 11:05:03 +0200383_- We avoid granting something to PUBLIC (and not to individuals either). Instead, we grant to a group of persons. For DB2 Catalog Tables, it's accessible in test but NOT in production. Developers or end-users have nothing to do there. Regards,

LUONG The-Thanh

===== Disclaimer: opinions expressed are strictly my own, etc... ===== [...] 430 60 35_Re: Public access to Catalog tables10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Tue, 22 Aug 2000 03:52:14 -0500601_- I would have reservations from a security standpoint about granting PUBLIC authority on Catalogue Authority tables (SYSDBAUTH, etc.).

As an example, if a user wishes to create a table or other DB2 object on a system where they do not have any specific authorities granted, but do have access to catalogue authority tables, then they can do a quick search of SYSDBAUTH, SYSRESAUTH, and SYSUSERAUTH, and will usually find a database / stogroup / etc. with enough authorities granted to PUBLIC to do it. If they do not have access to the Catalogue Authority tables, this is much harder (of [...] 491 77 0_10_Pete Coles28_peter.coles@SOMERFIELD.CO.UK31_Tue, 22 Aug 2000 11:29:14 +0100650_iso-8859-1 thanks, that's just what i wanted

-----Original Message----- From: Rohn.Solecki@MTS.MB.CA [mailto:Rohn.Solecki@MTS.MB.CA] Sent: Monday, August 21, 2000 10:01 PM To: DB2-L@RYCI.COM Subject:



Take a look at the V7 What's new doc, http://www-4.ibm.com/software/data/db2/os390/pdf/whatv7.pdf. The doc says that you can do a direct 1 step conversion from V5 to V7. But you have to be aware of incompatiblities introduced by V7 (and V6), that have to be resolved before doing the actual conversion ie: - Type 1 index no longer supported - password protection removed - host variable now MUST have a preceding colon etc [...] 569 70 29_Re: DB2 LOAD Utility with SAP23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 22 Aug 2000 11:14:20 +0100424_iso-8859-1 John hi.

Although I have not done what you are suggesting I am interested to know if you have SAP RI on your DB2 system?

Regards

Leslie DB2(v6 Datasharing) SAP(4.6c)

-----Original Message----- From: Higgins John [mailto:HigginsJohn@JOHNDEERE.COM] Sent: Monday, August 21, 2000 11:15 PM To: DB2-L@RYCI.COM Subject: DB2 LOAD Utility with SAP



Fellow DB2 list members: [...] 640 176 35_Re: Public access to Catalog tables29_Sireesh Chandra.M,J16 Chennai25_msireesh@MSDC.HCLTECH.COM31_Tue, 22 Aug 2000 16:03:51 +0530697_iso-8859-1 SIGNOFF DB2-L

-----Original Message----- From: John Hardy [mailto:john_j_hardy@CONSULTANT.COM] Sent: Tuesday, August 22, 2000 2:22 PM To: DB2-L@RYCI.COM Subject: Re: Public access to Catalog tables



I would have reservations from a security standpoint about granting PUBLIC authority on Catalogue Authority tables (SYSDBAUTH, etc.).

As an example, if a user wishes to create a table or other DB2 object on a system where they do not have any specific authorities granted, but do have access to catalogue authority tables, then they can do a quick search of SYSDBAUTH, SYSRESAUTH, and SYSUSERAUTH, and will usually find a database / stogroup / etc. with [...] 817 228 30_Re: LOAD LOG NO - Log activity9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 22 Aug 2000 11:42:28 +0100477_us-ascii I believe that logging (even though LOG NO) occurs during the ENFORCE and INDEXVAL phases when the RI violations and duplicates are deleted. Kind Regards, Andy Hunt - Scottish And Southern Energy







"Pillay, Venkat (PCA)" on 21/08/2000 17:09:11

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: LOAD LOG NO - Log activity [...] 1046 19 21_IDMS to DB2 migration17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Tue, 22 Aug 2000 16:22:56 +0500437_- Hello List, We are in the process of doing IDMS to DB2 migration of the data & the application. So is there any kind of a tool available for the data migration aspect.



TIA, VIJAY

================================================ 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. 1066 40 49_RE : DB2CODEPAGE :OS/390 V5.1 TO DB2 CONNECT V5.212_Andre Cupido22_wcacu@WOOLWORTHS.CO.ZA31_Tue, 22 Aug 2000 14:03:57 +0200401_US-ASCII Hi All

We just installed DB2 V5.1 for os/390 and DB2 Connect V5.2 on Nt.

After issueing the connect to my dbase the following error is displayed .



SQL0332N There is no available conversion for the source code page "1252" to the target code page "UNKWOWN". Reason Code "3".SQLSTATE 57017



I issued a a. db2set Codepage=1252 b. set codepage=1252 [...] 1107 27 25_Re: IDMS to DB2 migration14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 22 Aug 2000 08:06:36 -0400343_ISO-8859-1 Check with a company named Forecross.... they have a migration aid.

Regards, Joel



Message text written by DB2 Data Base Discussion List >Hello List, We are in the process of doing IDMS to DB2 migration of the data & the application. So is there any kind of a tool available for the data migration aspect. [...] 1135 26 8_New Book31_=?iso-8859-1?q?Silvia=20Motta?=21_silviamotta@YAHOO.COM31_Tue, 22 Aug 2000 05:27:13 -0700557_iso-8859-1 Hello, Where can i get the book 'DB2 High Performance Design & Tuning' by Richard Yevich and Susan Lauson ???

Thanks.



=====



__________________________________________________ Do You Yahoo!? Yahoo! Mail – Free email you can access from anywhere! http://mail.yahoo.com/

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 1162 156 35_Re: Public access to Catalog tables11_Pedro Cunha20_pplfilho@SUPER11.NET31_Tue, 22 Aug 2000 09:31:12 -0300653_iso-8859-1 Hello,

We have public access here in P, T and D.

Salutations,



---------------------------------------------------------------------------- ---- Pedro Paulo L. C. Filho Visite / Visit: Portfolio Fotografia Editorial Stock images Talentx

---------------------------------------------------------------------------- ---- Sexta-feira, 18 de Agosto de 2000 "Um sintoma de liberdade é o som de uma gargalhada" -- Anônimo ----- Original Message ----- From: Beighton-Dykes, Hugh Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Tuesday, August 22, 2000 5:27 AM Subject: Public access to Catalog tables [...] 1319 49 12_Re: New Book23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 22 Aug 2000 13:35:40 +0100511_iso-8859-1 www.amazon.com

-----Original Message----- From: Silvia Motta [mailto:silviamotta@YAHOO.COM] Sent: Tuesday, August 22, 2000 1:27 PM To: DB2-L@RYCI.COM Subject: New Book



Hello, Where can i get the book 'DB2 High Performance Design & Tuning' by Richard Yevich and Susan Lauson ???

Thanks.



=====



__________________________________________________ Do You Yahoo!? Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ [...] 1369 53 35_Re: Public access to Catalog tables4_IBM119_IBM1@EGEBANK.COM.TR31_Tue, 22 Aug 2000 16:05:25 +0300746_- We have the catalogue tables granted to public in both test and production.

ciao!

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

*std disclaimer* - my opinions are my own

> -----Original Message----- > From: Beighton-Dykes, Hugh [mailto:hugh.beighton-dykes@EDS.COM] > Sent: Tuesday, August 22, 2000 10:27 AM > To: DB2-L@RYCI.COM > Subject: Public access to Catalog tables > > > V5 OS390 > > Would any of you have any reservations about granting SELECT access to > PUBLIC on [...] 1423 28 25_Re: COBOL Copybook to DDL13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 22 Aug 2000 09:19:46 -0400489_iso-8859-1 Keith, What do you plan to do with the DDL built from DCLGEN? If you just want column names, datatypes and lengths, you are probably ok.

But the information in DCLGEN is missing several facts about the table definition. For instance the Declare table in the DCLGEN does not distinguish between NOT NULL and NOT NULL WITH DEFAULT. All the other exotic DDL parameters, such as IDENTITY clauses, PRIMARY KEY, UNIQUE and other constraints, are not documented in DCLGEN. [...] 1452 77 42_Re: New Book "DB2 High Performance Design"4_IBM119_IBM1@EGEBANK.COM.TR31_Tue, 22 Aug 2000 16:31:03 +0300789_- also www.fatbrain.com

ciao!

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

*std disclaimer* - my opinions are my own

> -----Original Message----- > From: Pendlebury-Bowe, Leslie [SMTP:Leslie.Pendlebury-Bowe@EU.SONY.COM] > Sent: Tuesday, August 22, 2000 3:36 PM > To: DB2-L@RYCI.COM > Subject: Re: New Book > > www.amazon.com > > -----Original Message----- > From: Silvia Motta [mailto:silviamotta@YAHOO.COM] > Sent: Tuesday, August 22, 2000 1:27 PM > To: DB2-L@RYCI.COM > Subject: New Book > > > Hello, > Where can i [...] 1530 57 25_Re: COBOL Copybook to DDL13_Keith Gilbert17_kgilbert@CSA1.COM31_Tue, 22 Aug 2000 08:36:04 -0500534_iso-8859-1 Dave,

I am currently in the middle of migrating our current systems to new products using DB2. Our current systems use IMS and VSAM. I am looking for quick and dirty ways to load a VSAM file into a DB2 table so I can run data analysis queries. The table isn't for production and I usually drop it after the queries answer my questions. I need a process that will take the COBOL copybook for these files and generate the DDL for a simple table (it doesn't even need a key) and the corresponding load statements. [...] 1588 89 29_Re: DB2 Connect on Peoplesoft14_Gary Bernhardt18_GBernhardt@CSI.COM31_Tue, 22 Aug 2000 09:01:27 -0500603_ISO-8859-1 Dave, The CPU time is being charged to DDF exactly as you state. We believe that the difference is overhead associated with thread allocation/de-allocation. Gary

---------- > From: David Williams > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect on Peoplesoft > Date: Friday, August 18, 2000 10:05 AM > > Can you determine where the extra CPU is being consumed? We have > noticed a huge amount of CPU being attributed to DDF enclave but as > yet are unable to determine the cause. It would be ineterseting to > hear if you have a similar problem. We are [...] 1678 51 29_Re: DB2 Connect on Peoplesoft14_Gary Bernhardt18_GBernhardt@CSI.COM31_Tue, 22 Aug 2000 09:08:04 -0500613_ISO-8859-1 Brian, In regard to 3-tier threads, we are not seeing them stay connected. We are running nearly 99% 3-tier. Are there any settings we missed to keep the 3-tier threads from disconnecting? TIA, Gary ---------- > From: brian_holroyd.consultant@PEOPLESOFT.COM > To: DB2-L@RYCI.COM > Subject: DB2 Connect on Peoplesoft > Date: Monday, August 21, 2000 11:21 AM > > > Gary, > > I'm surprised about your 15% increase in cpu converting to DB2 > Connect. That is usually not the story we hear. Centura does its > ASCII-ABCDIC conversion of incoming and outgoing messages in GTIMON on the > mainframe, DB2 [...] 1730 21 19_Scrollable Cursors.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 22 Aug 2000 10:12:37 -0400461_us-ascii Hi list, just a (hopefully) quick question.

Which version of DB2 (OS/390) has, or going to have scrollable cursors? If it's GA, what doc is available?

Thanks,

Martin Wolff, Global Crossing.

================================================ 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. 1752 57 42_Re: New Book "DB2 High Performance Design"0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 22 Aug 2000 09:16:29 -0500391_us-ascii Try www.addall.com it provides a comparison of various sources online (including shipping costs/options). For example it gives a price range of $70.11 to $105.80 ($Canadian) for this book



http://www.best.com/~arnoud/db2/ just to add to this there is a WEB site run by a few friends and I that identifies all the books currently available on DB2 (UDB and other). [...] 1810 109 29_Re: DB2 LOAD Utility with SAP12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Tue, 22 Aug 2000 09:18:30 -0500607_us-ascii Leslie,

We are dealing with SAP R/3 4.6C on DB2 v6 Datasharing.

As far as I know, SAP does not employ RDBMS RI, just application RI. I just verified this in the catalog.

In my question, I was referring to the application-level RI being verified in the "staging" system. I intend to iterate the loading into the "staging" system until it is clean (enough). I am hoping to accomplish several things: * Shift the majority of the critical path resource requirements off of the live system and onto the "staging" system * Shorten the cut-over critical path for each subsequent [...] 1920 17 29_Re: DB2 Connect on Peoplesoft11_John Wallin24_john.wallin@ZURICHUS.COM31_Tue, 22 Aug 2000 09:13:48 -0500462_us-ascii Boy those People Soft folks have a thin skin. This list is exactly where I would hope to get opinions on software products. Maybe even results from new installations. We are the people implementing this stuff. Suggesting that the DB2 Systems staff is unqualified to evaluate performance of a product that they have just implemented seems a little harsh. Maybe we should let managment tell us how it is working. Or maybe PeopleSoft marketing types. [...] 1938 35 30_Statement of work for services14_Steve Domarski26_sdom@PROPAPPR.MARION.FL.US31_Tue, 22 Aug 2000 10:14:44 -0400598_us-ascii Hi All, I'm attempting to establish a Statement of work for Services contract with the IBM Operational Support Services - Consult Line and found an interesting clause in the agreements section. It states "use of the information obtained under this service only for the support of the information processing requirements within your Enterprise." This implies that if they have a bug and I pay the toll to get it fixed I can't tell anybody so that they have to pay the toll to. What's wrong with this picture. I'm running into a mass of undocumented requirements for DB2 Connect [...] 1974 51 25_Re: IDMS to DB2 migration36_Enarson, Mike (CC-Database Services)24_Mike.Enarson@CONAGRA.COM31_Tue, 22 Aug 2000 09:17:35 -0500429_iso-8859-1 Hi Vijay.

About 8 years ago I had some conversations with a company called Forecross, I believe. They would not sell just the tool, but lease it on a per program conversion charge. I do not know if this has changed.

Also just this week I got a post card from a company called Xitec Software, Inc. saying they do or help with IDMS conversions to DB2 or Oracle. Their web address was quoted as being: [...] 2026 60 23_AW: Scrollable Cursors.12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 22 Aug 2000 16:28:25 +0200616_iso-8859-1 Martin,

you have to wait for DB2 for OS/390 Version 7 Release 1.

For more information take a look at http://www-4.ibm.com/software/data/db2/os390/pdf/whatv7.pdf

HTH.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 2087 74 25_Re: COBOL Copybook to DDL23_AITHA, BHEEMSEN (SBCSI)22_BA2984@MSG.PACBELL.COM31_Tue, 22 Aug 2000 07:36:29 -0700583_iso-8859-1 Venkat,

Can you please send me a copy of MS-ACCESS macro if you happen to find it.

Thanx.. -Bheem Aitha

-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Monday, August 21, 2000 12:41 PM To: DB2-L@RYCI.COM Subject: Re: COBOL Copybook to DDL



Once we had this big project going, to convert thousands of copybooks to DDL and import it to ERWIN. I was given the task for writing REXX-ISPF EDIT MACRO. I finally figured out the rules had many loop holes also I was nearly writing a COBOL parser. [...] 2162 160 29_Re: DB2 LOAD Utility with SAP10_Bill Disch23_bill.disch@GENMILLS.COM31_Tue, 22 Aug 2000 09:39:38 -0500565_iso-8859-1 John,

I am not familiar with the specifics of adding more factories, but I would caution you about using database utilities to insert or extract data in an SAP environment. In our world (R/2 6.1G and R/3 4.6C), we would use a BDC session to input the new data into the staging system to assure that all SAP checks are performed and the SAP RI is enforced. Since one rarely knows exactly which tables are affected when 1 factory is added (1 or 100?), using a BDC session eliminates the guesswork. The same reasoning leads us to repeat the BDC [...] 2323 60 27_Re: AW: Scrollable Cursors.12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 22 Aug 2000 10:41:14 -0400773_iso-8859-1 Thankyou Georg(e). I wonder if IBM will consider retro-fitting it to V6?

"Peter, Georg" wrote:

> Martin, > > you have to wait for DB2 for OS/390 Version 7 Release 1. > > For more information take a look at > http://www-4.ibm.com/software/data/db2/os390/pdf/whatv7.pdf > > HTH. > > With kind regards - mit freundlichen Grüssen, > G e o r g H . P e t e r > DB2 Data Base Administrator c/o > ------------------------------------------------------------------------ > Datenzentrale Baden-Wuerttemberg > Department Product Support > Krailenshaldenstrasse 44, 70469 Stuttgart, Germany > Phone 0049-711-8108-271 > PC-Fax 004971189696071 > ------------------------------------------------------------------------ > > -----Ursprüngliche Nachricht----- [...] 2384 160 29_Re: DB2 LOAD Utility with SAP13_Adrian Savory24_adrian.savory@ZURICH.COM31_Tue, 22 Aug 2000 15:40:49 +0100541_us-ascii John,

I would be very wary of doing this. How can you be sure that you know exactlythe data that needs to be unloaded from the staging system and loaded into the Production system? However you enter the data into the staging system (e.g. BDC, ALE), SAP is going to do a lot of DB2 work of a non-application nature e.g. logging the progress of batch jobs, performance info, etc. How are you going to get a definitive list of the tables that have 'real' application data, and how will you know that this list is complete? [...] 2545 21 25_Re: IDMS to DB2 migration19_Dhirendra Chaudhary27_dhirendra.chaudhary@WDR.COM31_Tue, 22 Aug 2000 09:34:09 -0500516_- Vijay,

I work for HPS ( HCL PEROT SYSTEMS ) and we recently did a similar migration i.e. IDMS TO DB2 . and guess the company we parterned with for the data migration

"XITEC SOFTWARE"

( Where have you been for the last two years ).

Rgds, Dhiren.

================================================ 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. 2567 100 29_Re: DB2 LOAD Utility with SAP12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Tue, 22 Aug 2000 09:52:46 -0500423_us-ascii Bill,

I am on the same page with you.

I want to use the "staging" system in exactly the way you describe: run the SAP transactions.

Yes, I would iterate the load until it is clean (enough).

Then, I would unload the rows from "staging" and load into the live system.

Part of the process would be to discover which tables needed to be copied, based on the actual data loaded. [...] 2668 41 30_Re: How is QUERYNO determined?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 22 Aug 2000 15:56:27 +0100494_iso-8859-1 Sorry

trying to carry too many versions around in my head at the same time!!

Phil G

-----Original Message----- From: Mike Turner [mailto:Michael_Turner@COMPUSERVE.COM] Sent: 21 August 2000 16:47 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] How is QUERYNO determined?



QUERYNO nnnnn is in Version 6 of DB2 for OS/390.

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner [...] 2710 75 34_Re: Statement of work for services12_Myron Miller22_myronwmiller@YAHOO.COM31_Tue, 22 Aug 2000 08:01:23 -0700589_us-ascii In a way I agree with you. I looked at getting a support contract for DB2 Connect ( a $300 product) because of all the problems I was having with it. However, the support contract was $5000. Somehow I just couldn't justify a $5000 contract for a $300 product. Or I could pay x dollars per hour to have IBM resolve bugs in their product. Again, there's something wrong with this picture. --- Steve Domarski wrote: > Hi All, I'm attempting to establish a > Statement of work for Services > contract with the IBM Operational Support Services [...] 2786 210 29_Re: DB2 LOAD Utility with SAP12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Tue, 22 Aug 2000 10:11:32 -0500458_iso-8859-1 Adrian,

I am indeed wary of doing this !!!

You make an excellent point that some of the "staging" DB2 work is not needed or even wanted in the live system.

I am sure I can find everything that was modified. But can I tell everything that could be ignored?

I am sure that "some" excess data will not be harmful. So, can I at least tell which modifications "must" be ignored? This will be a Critical Success Factor. [...] 2997 64 29_Re: DB2 Connect on Peoplesoft14_Gary Bernhardt18_GBernhardt@CSI.COM31_Tue, 22 Aug 2000 10:26:56 -0500375_ISO-8859-1 Roger, It is my understanding we are current on maintenance. I don't know what level we are at though.

We had DSC on prior to converting to DB2 Connect and had so many memory problems on DB2 we had to back it off. We just turned it back on last weekend. It is too soon to tell what the impact is but I am confident it will be a measurable improvement. [...] 3062 17 34_Re: DB2 OS390 Stored Proc Question12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 22 Aug 2000 10:12:43 -0500309_- Here are a couple of thoughts:

The simplest technique that would not degrade those with fewer than 1000 rows would be just to count on the fetch. Then you could even return the partial result, rather than none. If that works and you get to Version 7, then you have the FETCH n ROWS ONLY clause. [...] 3080 38 35_Re: Public access to Catalog tables15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Tue, 22 Aug 2000 10:34:00 -0500468_iso-8859-1 There may be many developers there who use the catalogs beneficially ...

With a stroke of a command (or rather, a lack of it) a conservative DBA may promote an unneccessarily closed environment. Unless justified, this can fustrate skilled developers, for after all, it is only occasionally that power developers look at the catalog data. This is aggravated if the site does not have a test (or model) database that closely resembles production. [...] 3119 177 29_Re: DB2 LOAD Utility with SAP23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 22 Aug 2000 16:36:07 +0100641_iso-8859-1 I agree with Adrian - should be careful with this kind of approach

Les

-----Original Message----- From: Adrian Savory [mailto:adrian.savory@ZURICH.COM] Sent: Tuesday, August 22, 2000 3:41 PM To: DB2-L@RYCI.COM Subject: Re: DB2 LOAD Utility with SAP



John,

I would be very wary of doing this. How can you be sure that you know exactlythe data that needs to be unloaded from the staging system and loaded into the Production system? However you enter the data into the staging system (e.g. BDC, ALE), SAP is going to do a lot of DB2 work of a non-application nature e.g. logging the progress [...] 3297 10 26_DB2 Connect Setup Question11_Tom Johnson25_new_to_db2@SPRINGMAIL.COM31_Tue, 22 Aug 2000 12:55:36 -0400338_- Ijust recently downloaded the current version of DB2 connect from the web. When I go into the Configuration Assistant, and select Add Database, select Manually Configure the Protocol screen does not allow me to select TCP/IP. I have verified that my pc has TCP/IP installed. What can I do to allow this selection to occur???? TIA. [...] 3308 77 34_Re: DB2 OS390 Stored Proc Question13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Tue, 22 Aug 2000 12:02:22 -0500395_iso-8859-1 Might want to look at your access path before just limiting the number of fetches performed, because you may not see that much benefit by just limiting fetches. Going back to the original message...

The issue is when thousands of batch transactions are input over time with the same 'type' (this has gotten > 1/2 million and caused EXTREME PAIN in the onlines!)... [...] 3386 53 50_Re: DB2 OS390 V5 READ ACCESS TO SQLSERVER DATABASE13_Terry Shockey30_Terry.Shockey@OCSE.STATE.AR.US31_Tue, 22 Aug 2000 12:43:22 -0500637_iso-8859-1 mike, thanks for the response and info, If I come up with something I will let you know.



-----Original Message----- From: Mike Evans [mailto:EVANSMP@CO.MECKLENBURG.NC.US] Sent: Monday, August 21, 2000 7:20 AM To: DB2-L@RYCI.COM Subject: Re: DB2 OS390 V5 READ ACCESS TO SQLSERVER DATABASE



Terry, we have a similar need. I talked with IBM and they suggested that we use Datajoiner to replicate the SQL Server data to a DB2 table and read the DB2 table from CICS. CICS works in 2 phase commit mode which prohibits a direct read to SQL Server. Another option we are exploring is using MQSeries. [...] 3440 46 37_Strobe Analysis shows lots of Commonx0_22_blyons2@CSCPLOENZKE.DE31_Tue, 22 Aug 2000 20:24:39 +0100424_us-ascii While performance-testing a large batch cobol db2 application on a test LPAR, I've noticed that a large proportion of the CPU cost is allocated by Strobe to .COMMONX (in the example below it's 22.43%). Can anybody tell me if it's possible to tweak this, and if so, how? Can I do something in the application, or do I need to look at things like dispatching priorities, whether its been swapped out a lot etc.? [...] 3487 102 35_Re: Public access to Catalog tables12_Hylton Tom P20_Tom.P.Hylton@IRS.GOV31_Tue, 22 Aug 2000 15:00:46 -0400526_iso-8859-1 No, we don't allow direct access to the PROD catalogs. Instead we clone the pertinent ones once a day and load this alternate version into TEST, where anyone can read it.

You risk some (or many) people tying up your catalogs, anytime they want to. If you're brave, try running the unoptimized DSNTESQ queries against the actual catalog without any additional indexes in place and see what kind of a negative impact unfettered access can do. (NOT RECOMMENDED!!! PLEASE DON'T DO IT!!! JUST AN EXAMPLE!!!) [...] 3590 28 17_Re: Load question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Tue, 22 Aug 2000 15:56:25 -0400308_iso-8859-1 Hey folks, I'm running a batch load job, executing DB2UPROC. Before running the job I check the table status and all are in RW status. The job abends with a message stating that the database and tablespace are in checkpending status. Does anyone have an idea on how I can correct this issue. [...] 3619 92 17_Re: Load question13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 22 Aug 2000 14:56:37 -0500406_US-ASCII Jeff, Run the check data utility. Kurt



>>> JKalman@UNCH.UNC.EDU 08/22/00 02:56PM >>> Hey folks, I'm running a batch load job, executing DB2UPROC. Before running the job I check the table status and all are in RW status. The job abends with a message stating that the database and tablespace are in checkpending status. Does anyone have an idea on how I can correct this issue. [...] 3712 70 34_DDF from DB2S OS/390 to AIX Server11_John Wallin24_john.wallin@ZURICHUS.COM31_Tue, 22 Aug 2000 14:53:28 -0500694_us-ascii Hello list, We are trying to set up a IP connection (for the first time) using DDF from a mainframe DB2 (DB2S)subsystem client to an AIX RS6000 box (UUGEUSCDB2S)also running IBM DB2. We are using native IP. The connection to IP from DB2S server seems to be working (ie. DB2 CONNECT can get to the mainframe). However when the Mainframe acts as a client it doesn't seem to get through. The error is 00d31057 LINKNAME not found SELECT * FROM UUGEUSCDB2S.SYSIBM.IPNAMES ---------+---------+---------+---------+---------+---------+---------+-------- DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D31057, TYPE OF RESOURCE 00001004, [...] 3783 48 17_Re: Load question9_Rob Crane22_racrane@CONCENTRIC.NET31_Tue, 22 Aug 2000 14:19:28 -0600407_us-ascii Are you doing a LOAD RESUME? If doing a LOAD REPLACE LOG NO you should be able to load data as long as the tablespace is not in recover pend. Are you sure the LOAD did not complete normally and the job is just telling you that you have RI and therefore leaves the object in checkpend? That would be normal, not really an abend though. Just add a checkdata step or repair step after your load. [...] 3832 59 17_Re: Load question12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Tue, 22 Aug 2000 16:05:54 -0400497_iso-8859-1 Thank you for your reply.



Jeffrey Kalman DataBase Administration UNC Health Care System 2nd Floor Carr Mill Mall Carrboro, NC 27510

(919) 966-4894 Voice (919) 966-2110 FAX mailto:jkalman@unch.unc.edu

-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Tuesday, August 22, 2000 3:57 PM To: DB2-L@RYCI.COM Subject: Re: Load question



Jeff, Run the check data utility. Kurt [...] 3892 102 38_Re: DDF from DB2S OS/390 to AIX Server36_Enarson, Mike (CC-Database Services)24_Mike.Enarson@CONAGRA.COM31_Tue, 22 Aug 2000 15:28:42 -0500492_iso-8859-1 Hi John.

Did you STOP and START DDF after making the change?

I was also thinking that the LINKNAME needed to be defined in both SYSIBM.LUNAMES and SYSIBM.IPNAMES, but it has been a while and I'm probably wrong about that.



Regards Mike Enarson





-----Original Message----- From: John Wallin [mailto:john.wallin@ZURICHUS.COM] Sent: Tuesday, August 22, 2000 2:53 PM To: DB2-L@RYCI.COM Subject: DDF from DB2S OS/390 to AIX Server [...] 3995 20 15_CPU usage in $$15_Kuashal Trivedi17_c_triveka@BAM.COM31_Tue, 22 Aug 2000 16:32:37 -0400317_iso-8859-1 Hi All, In some installations where systems are leased or the IS dept wants to keep track of their mainframe usage, I have seena $$ amount attached to either jobs or sessions, Is this dependent on the Model of the CPu and such, if so where can I find this information , if anyone can pass it onto me. [...] 4016 57 17_Re: Load question12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Tue, 22 Aug 2000 15:57:30 -0500459_- Are you running in the correct subsystem? Check the default in the DB2UPROC. Did you override it? Did you run the job on the correct LPAR?

Just the same questions I ask the application DBA's.

Carol Sutfin Corporate DBA AmSouth Bank N.A. (205)326-5214 csutfin@amsouth.com





"Kalman, Jeff" on 08/22/2000 02:56:25 PM



Please respond to DB2 Data Base Discussion List [...] 4074 27 18_CICS/DB2 Migration15_Jeffery A Price17_jprice@IPALCO.COM31_Tue, 22 Aug 2000 15:59:29 -0500510_us-ascii Hello all!

I am faced with a dilemma - who to upgrade first - CICS or DB2. Currently, we are at CICS 4.1, DB2 5.1, and OS/390 2.6. OS/390 2.9 goes in first, and then it's a toss-up between the two subsystems. I was planning on doing both concurrently (testing anyway - DB2 6.1 and CICS TS1.3), and then putting one at a time into production. Have any of you had any good/bad experiences upgrading both subsystems? Is there any certain order in which these two subsystems must be upgraded? [...] 4102 151 62_Timeouts related to a lock where MEMBER name is subsystem name15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Tue, 22 Aug 2000 17:49:10 -0400764_iso-8859-1 We had a problem this afternoon with timeouts. The following message was in the DB2 log --- 46 times -- related to these timeouts. BDSN is the subsystem name. Can anyone tell my what causes this type lock or where to go look for information on it?



DSNT376I -BDSN PLAN=DISTSERV WITH CORRELATION-ID=PSQCKSRV.exe CONNECTION-ID=SERVER LUW-ID=GA04040E.B406.027322193244=1307 THREAD-INFO=FS75P:CW8CH:D60952R:FS75PDB1 IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=DISTSERV WITH CORRELATION-ID=PSAPPSRV.exe CONNECTION-ID=SERVER LUW-ID=GA04040E.A406.023422191817=1289 THREAD-INFO=FS75P:019036:D97130S:FS75PDB1 ON MEMBER BDSN Andrea Milligan Database Administator BlueCross BlueShield of Tennessee Phone (423) 755-5928 Pager (423) 527-0970 [...] 4254 159 66_Re: Timeouts related to a lock where MEMBER name is subsystem name0_26_truman.g.brown@VERIZON.COM31_Tue, 22 Aug 2000 17:57:30 -0400555_us-ascii



It would appear that you have mulitple remote requests that are causing each other to time out. "DISTSERV" is the plan used at the remote server.

George







"Andrea Milligan" on 08/22/2000 05:49:10 PM

Please respond to "DB2 Data Base Discussion List"





To: DB2-L@RYCI.COM

cc: (bcc: TRUMAN G. BROWN/EMPL/MD/Bell-Atl)





Subject: Timeouts related to a lock where MEMBER name is subsystem name [...] 4414 77 67_Re: Timeouts related to a lock where MEMBER name is subsystem nam e23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 22 Aug 2000 18:05:15 -0400628_- Andrea,

There should be a message DSNT501I or DSNT500I following this message (DSNT376I), which would identify the resource in contention.

Sanjay Jain

> -----Original Message----- > From: Andrea Milligan [SMTP:Andrea_Milligan@BCBST.COM] > Sent: Tuesday, August 22, 2000 5:49 PM > To: DB2-L@RYCI.COM > Subject: Timeouts related to a lock where MEMBER name is subsystem > name > > We had a problem this afternoon with timeouts. The following message was > in the DB2 log --- 46 times -- related to these timeouts. BDSN is the > subsystem name. Can anyone tell my what causes this type lock or where to [...] 4492 93 66_Re: Timeouts related to a lock where MEMBER name is subsystem name11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Tue, 22 Aug 2000 17:05:51 -0500543_iso-8859-1 Here are some useful DB2 commands: -DISPLAY DB(*) SP(*) LIMIT(9999) LOCKS -DISPLAY DB(*) SP(*) LIMIT(9999) CLAIMERS -DISPLAY DB(*) SP(*) LIMIT(9999) USE

... : )





From: Andrea Milligan @RYCI.COM> on 08/22/2000 04:49 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject: Timeouts related to a lock where MEMBER name is subsystem name [...] 4586 45 19_Re: CPU usage in $$14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Tue, 22 Aug 2000 18:15:29 -0400565_ISO-8859-1 Every installation is different. When there are charges/chargebacks for CPU usage, it's usually based on a rate per minute. Installations typically re-calculate the service units of a processor so the rates charged to a customer remain mostly constant for a given amount of work no matter what the processor. Then then may adjust rates based on the cost of the datacenter and support staff they have to allocate. A common range for CPU charges in many installations is around $20 per CPU minute. Some may be much higher, and some may be much lower. [...] 4632 58 22_Re: CICS/DB2 Migration15_Wells, Davis B.21_davis.wells@TGSLC.ORG31_Tue, 22 Aug 2000 17:14:44 -0500402_iso-8859-1 I am in the middle of the same process. We are going from TS 1.2 to TS 1.3.

We've had to upgrade CA-90, ENF, Top Secret, Xpediter, IDMS, and Natural to work with TS 1.3. While waiting for the MVS group to upgrade these products I installed DB2 6.1. now DB2 6.1 needs it's own Top Secret upgrade so I am finishing up the CICS install. So it depends. What other products you have? [...] 4691 18 40_Any DB2 Maintenance required for SHARK ?12_Kirk Hampton16_khampto1@TXU.COM31_Tue, 22 Aug 2000 17:24:44 -0500438_us-ascii Does anyone know of required maintenance to DB2 v6.1 and/or any related software on OS/390 2.8 when moving onto SHARK (ESS) DASD ?

TIA, Kirk Hampton TXU Electric and Gas Dallas, TX

================================================ 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. 4710 222 68_Re: Timeouts related to a lock where MEMBER name is subsy stem nam e15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Tue, 22 Aug 2000 18:46:42 -0400492_iso-8859-1 Thanks. It was and for some reason I just got "hung" on the subsystem message.

-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Tuesday, August 22, 2000 6:05 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Timeouts related to a lock where MEMBER name is subsystem nam e



Andrea,

There should be a message DSNT501I or DSNT500I following this message (DSNT376I), which would identify the resource in contention. [...] 4933 113 38_Re: DDF from DB2S OS/390 to AIX Server12_tim malamphy20_timalamphy@YAHOO.COM31_Tue, 22 Aug 2000 15:45:09 -0700553_us-ascii One thing is that you haven't bound the spufi PACKAGE on the remote location. And don't use DSNESPRR. Use DSNESPCS (and remember to change the DB2 defaults for SPUFI when you test). RR is repeatable read and will tend to lock the heck out of whatever the user is going after. There's a long discussion on remote binds in the archives that took place over the last month or so. Tim --- John Wallin wrote: > Hello list, > We are trying to set up a IP connection (for > the first time) using DDF from > a mainframe [...] 5047 10 50_Re: cant connect to DB2 OS/390 v6 from DB2 Aix 6.115_Lynette Roberts21_llroberts@KSCABLE.COM31_Tue, 22 Aug 2000 18:10:24 -0500312_- You also need to catalog your databases on UDB AIX as DCS databases.

================================================ 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. 5058 67 41_Re: Strobe Analysis shows lots of Commonx15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Tue, 22 Aug 2000 19:04:03 -0500501_us-ascii I assume COMMONX is extended ECSA (31-bit common storage addressable by all address spaces) - it's a while since I perused a STROBE report.

No, this is basically MVS/OS390-like nucleus code that is being called indirectly on behalf of MVS providing the user/program-requested service/function. Like a byproduct of MVS managing your working set (4K pages needed in central to allow your program to run), paging on behalf of your program's storage requirements, that type of stuff. [...] 5126 96 55_Re: Strobe Analysis shows lots of Commonx ( -OOO Reply)11_Bill Happel22_WRHappel@US.FORTIS.COM31_Tue, 22 Aug 2000 18:53:30 -0600406_US-ASCII I will be at Out Of the Office from Wednesday, August 23nd to Thursady afternoon, August 24th. I will be back in the office on Thursday afternoon, August 24th. Please call the DBA Hotline at x5582.

>>> "DB2-L@RYCI.COM" 08/22/00 18:04 >>>

I assume COMMONX is extended ECSA (31-bit common storage addressable by all address spaces) - it's a while since I perused a STROBE report. [...] 5223 66 35_Re: Public access to Catalog tables12_Cianci, Nick28_Nick.Cianci@TEAM.TELSTRA.COM31_Wed, 23 Aug 2000 09:35:35 +1000535_-

Unless you want to be shackled to your development people, testers and users then I say PUBLIC (and would go a step further and say PUBLIC AT ALL LOCATIONS). From my point of view the Catalog is a tool, and to build things you need to use the tools you have available ( providing you don't throw a spanner into the works ). If you don't want people to see what access they have then consider restricting the access to only tables in SYSDBASE, SYSSTATS, SYSVIEWS, SYSSTR, SYSPLAN, and SYSPKAGE. [...] 5290 104 41_Re: Strobe Analysis shows lots of Commonx25_Robinson, Peter [IBM GSA]33_Peter.J.Robinson@TEAM.TELSTRA.COM31_Wed, 23 Aug 2000 10:07:12 +1000306_- Hi Brian

Jim's description reminds me of something we found a while back - I don't recall exactly what was in our strobe results. We found that the mvs overheads involved in managing external data with COBOL were large. Have a look and see how much you use externals for passing data around. [...] 5395 59 35_Re: Public access to Catalog tables9_jim.szabo22_jim.szabo@MCIWORLD.COM31_Tue, 22 Aug 2000 22:28:05 -0400380_iso-8859-1 Hugh,

I agree that PUBLIC access is usually best, but consider the statistics tables (SYSCOLDIST, SYSCOLDISTSTATS, SYSCOLSTATS) and the following example:

I have a BONUS table in my personnel database, where I insert a record for each employee bonus paid. Further assume that the table columns are SSN (social security number), DATE_PAID and AMOUNT. [...] 5455 104 29_Re: DB2 Connect on Peoplesoft11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Wed, 23 Aug 2000 13:21:21 +1000603_- Hear! Hear!

> -----Original Message----- > From: John Wallin [SMTP:john.wallin@ZURICHUS.COM] > Sent: Wednesday, August 23, 2000 12:14 AM > To: DB2-L@RYCI.COM > Subject: Re: DB2 Connect on Peoplesoft > > Boy those People Soft folks have a thin skin. This list is exactly where > I > would hope to get opinions on software products. Maybe even results from > new > installations. We are the people implementing this stuff. Suggesting > that the > DB2 Systems staff is unqualified to evaluate performance of a product > that they > have just implemented seems a little harsh. Maybe we should [...] 5560 46 21_Another Load question14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 23 Aug 2000 09:23:01 +0100345_iso-8859-1 Hello.

What's quicker?

1. To extract 5M records from a 21M record flat file using SORT, and LOAD REPLACE LOG NO into DB2, or.. 2. To "LOAD REPLACE LOG NO WITH field=value" the whole 21M row file, and let DB2 do the DISCARD of 16M rows?

I'd guess the former would be quicker, but I'm willing to be corrected. [...] 5607 206 29_Re: DB2 LOAD Utility with SAP15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Wed, 23 Aug 2000 03:39:07 -0500348_iso-8859-1 I too would be very wary of trying this and I suspect SAP will leave you on your own if you hit data integrity problems as a result!

If you must go ahead can I suggest doing it the SAP approved way first with either an SQL trace running or subsequent use of a log analysis tool. This will show you which tables are involved. [...] 5814 17 25_Re: Another Load question14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Wed, 23 Aug 2000 10:28:14 +0100375_us-ascii Use number 1. If you can , it's better to avoid too much work for DB2......it's a lazy boy.

Regards

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. 5832 35 69_off topic .... how to accomodate more than 24 lines in a cics sc reen25_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM31_Wed, 23 Aug 2000 15:34:32 +0530314_iso-8859-1 Dear list, We are trying to accommodate more than 24 lines (43 lines ) in one CICS screen . We have defined the mapset size as " size=(43,80)" The BMS is getting compiled without any error but when we are trying to send the map by "ceci send map(mainmap) maponly freekb " it is getting hanged out. [...] 5868 189 25_Re: Another Load question30_Karthigai Thirunal,J16 Chennai25_ekarthik@MSDC.HCLTECH.COM31_Wed, 23 Aug 2000 15:45:52 +0530580_- I think first choice is better than second,

Karthik



> -----Original Message----- > From: Davage, Marcus [SMTP:Marcus.Davage@LLOYDSTSB.CO.UK] > Sent: Wednesday, August 23, 2000 1:53 PM > To: DB2-L@RYCI.COM > Subject: Another Load question > > Hello. > > What's quicker? > > 1. To extract 5M records from a 21M record flat file using SORT, > and LOAD REPLACE LOG NO into DB2, or.. > 2. To "LOAD REPLACE LOG NO WITH field=value" the whole 21M row file, > and let DB2 do the DISCARD of 16M rows? > > I'd guess the former would be quicker, but I'm willing [...] 6058 63 74_Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen0_22_The-Thanh.Luong@AGF.BE31_Wed, 23 Aug 2000 14:20:47 +0200533_- (I am not a CICS expert, but,) doesn't it depend on the terminal type? If it only supports 24x80, there is a problem, I think. Regards,

LUONG The-Thanh

===== Disclaimer: opinions expressed are strictly my own, etc... =====





-----Original Message----- From: Sinha, Ranjay Kumar (CTS) [mailto:SRanjay@CAL.CTS-CORP.COM] Sent: Wednesday, August 23, 2000 12:05 PM To: DB2-L@RYCI.COM Subject: off topic .... how to accomodate more than 24 lines in a cics sc reen [...] 6122 84 74_Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Wed, 23 Aug 2000 07:43:18 -0500406_iso-8859-1 I seem to recall that you have to have the correct VTAM definition - MODETAB? Might be worth checking with your network guys.

Andy Lankester BMC Software Ltd

-----Original Message----- From: The-Thanh.Luong@AGF.BE [mailto:The-Thanh.Luong@AGF.BE] Sent: 23 August 2000 13:21 To: DB2-L@RYCI.COM Subject: Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen [...] 6207 111 74_Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen0_22_The-Thanh.Luong@AGF.BE31_Wed, 23 Aug 2000 14:43:46 +0200358_- I also remember some places where to look at, since BMS can handle the paging (left, right, up or down) via the PF keys: * check the parameters for BMS in your SIT table (SKRPFn - PGCHAIN - etc...) * in the program, be sure you are feeding all the fields of the screen before sending the whole map ("send map ACCUM", as far as I can recall). Regards, [...] 6319 87 66_Re: Timeouts related to a lock where MEMBER name is subsystem name12_troy Coleman20_Troy.Coleman@UAL.COM31_Wed, 23 Aug 2000 07:59:34 -0500484_- Hi Andrea, You have a PeopleSoft transaction comming through DB2 Gateway FS75P. The HOLDER of the resource is also a PeopleSoft transaction on the same gateway. The only way I've found the thread holding the lock is by using TMON. I look for the DSNT501I message showing the object being locked. Most of the time this has been the PS_INSTALLATION table. I pull up each thread in TMON and I cancel the thread holding the lock on PS_INSTALLATION. This will clear up the problem. [...] 6407 67 67_Re: Timeouts related to a lock where MEMBER name is subsystem nam e13_Crowley, Paul21_CrowleP@DIVINVEST.COM31_Wed, 23 Aug 2000 08:18:00 -0500409_iso-8859-1 We have come accross this message when programmers are running Visual Age in bebug mode and they don't exit. We see a status of WAIT-REMREQ in Omegamon. It may also be that the error handling in the application is not ending the transaction if there is an SQL error. We have seen this also. Sorry can't be more specific as we are just getting our feet wet(and hoping not to drown). Good Luck. [...] 6475 135 38_Re: DDF from DB2S OS/390 to AIX Server11_John Wallin24_john.wallin@ZURICHUS.COM31_Wed, 23 Aug 2000 08:24:43 -0500702_us-ascii Thanks Tim and all the rest of the replyers. Your help is priceless.









tim malamphy on 08/22/2000 05:45:09 PM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John Wallin/ZI/USA/Zurich)

Subject: Re: DDF from DB2S OS/390 to AIX Server





One thing is that you haven't bound the spufi PACKAGE on the remote location. And don't use DSNESPRR. Use DSNESPCS (and remember to change the DB2 defaults for SPUFI when you test). RR is repeatable read and will tend to lock the heck out of whatever the user is going after. There's a long discussion on [...] 6611 39 17_security question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 23 Aug 2000 08:21:32 -0500547_- I know that security has been discussed over and over again, but apparently I still don't understand it. My userid (user1) has no DB2 security, but I have a secondary racf group (group1) that has sysadm. If I try to create a tablespace, it fails. If I "set current sqlid = 'group1'", the create works (as expected). The owner is group1 and the creator is user1. I thought I would have to "set current sqlid = 'group1'" again to drop the tablespace, but I don't. So, I assumed that's because my id is associated with it as the creator. Next [...] 6651 52 19_Re: CPU usage in $$9_Wu, James13_jwu@KRAFT.COM31_Wed, 23 Aug 2000 08:56:59 -0500480_- You can get the CPU Usage from some performance monitoring products like MICS or IBM/Tivoli Performance Reporter. You have to do some homework because those tools give you only the CPU usage in Seconds which DO depend on the CPU Models.

In our shop we use Performance Reporter to collect CPU usage from SMF records, convert the CPU seconds to MI (Million Instructions) and use MI for chargeback and historical performance monitoring. The product works great for us. [...] 6704 65 21_Re: security question12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Wed, 23 Aug 2000 09:51:21 -0400379_iso-8859-1 Tina,

The SQLID will continue to be reused until either:

* it is reset to a different value using the "SET CURRENT SQLID" command * the current session is closed & a new one is subsequently opened (for example, exiting SPUFI completely & rentering it - ensure that the saved value on the panel is your TSO ID if that's what you'd like to use hence) [...] 6770 81 21_Re: security question0_19_mike.holmans@BT.COM31_Wed, 23 Aug 2000 14:51:06 +0100547_- The point about CREATE is that when you create something, a whole bunch of implicit privileges have to be recorded in the catalog. DB2 has to know that you have the authority to grant those privileges. And because you may have some fairly specialised ideas about exactly what you want to happen to this object once you've created it, DB2 requires that you make a decision as to which authority you are going to use for the purpose. That's why you have make sure that the CURRENT SQLID of the process is the one you want and has the correct [...] 6852 63 73_Re: off topic .... how to accomodate more than 24 lines in a cics sc reen11_John Wallin24_john.wallin@ZURICHUS.COM31_Wed, 23 Aug 2000 09:04:29 -0500472_us-ascii The Vtam Logmode determines whether or not 43 lines can be displayed. There should be an example in samplib.











"Sinha, Ranjay Kumar (CTS)" on 08/23/2000 05:04:32 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John Wallin/ZI/USA/Zurich)

Subject: off topic .... how to accomodate more than 24 lines in a cics sc reen [...] 6916 20 46_Converting Peoplesoft paycalc to parallel jobs15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Wed, 23 Aug 2000 10:29:49 -0400566_us-ascii Our large paycalc job sometimes runs longer than we would like and makes people nervous about exceeding the batch window. We are considering several things including changing from a single paycalc job to parallel jobs. We are concerned about contention if running multiple jobs against the same company code. Has anyone has broken a large company into smaller ones with different company codes to allow parallel jobs to run simultaneously against different companies? Would appreciate hearing about good experiences as well as things to watch out for. [...] 6937 25 29_Insert, problem using "STRIP"0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 23 Aug 2000 09:28:53 -0500453_us-ascii OS390 DB2 V5 A developer called me with a problem.

We have been having problems trying to use the STRIP function in a COBOL program. The precompiler keeps giving either "Illegal symbol ..." or "Undefined Host variable ..." syntax error messages (depending on how we try to setup the statement). However, we have been able to get it to work in SPUFI. The "SQL Reference" manual does not say that you cannot use functions in INSERTs. [...] 6963 112 21_Re: security question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 23 Aug 2000 09:31:07 -0500609_- So, are CREATE, GRANT, and REVOKE the only DDL that require a 'set current sqlid' to get the proper authority, and the others will work if the proper security is available from a secondary authid?

Tina

> -----Original Message----- > From: mike.holmans@BT.COM [SMTP:mike.holmans@BT.COM] > Sent: August 23, 2000 8:51 AM > To: DB2-L@RYCI.COM > Subject: Re: security question > > The point about CREATE is that when you create something, a whole bunch of > implicit privileges have to be recorded in the catalog. DB2 has to know > that > you have the authority to grant those privileges. And [...] 7076 149 74_Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 23 Aug 2000 09:38:02 -0500384_us-ascii Also check your terminal configuration.

Whether you are using a 3270 terminal directly or 3270 terminal emulator software, check the terminal configuration options.

When I was setting up a 132 character (wide) display I had to configure both my TSO session (on the mainframe) AND the terminal emulator. I suspect you may be running into a similar problem. [...] 7226 30 25_Partitioning Large Tables14_Craig McKellar29_craig.mckellar@BIGPOND.COM.AU31_Wed, 23 Aug 2000 09:10:27 -0500559_- I am looking for some feedback and to start some discussion about stategies that have worked at other sites to incorporate a partition key into a physical design. We are fortunate to still be at the physical design stage of a project. The project includes a number of related tables. About 6 of them would be in size bracket of 100-200GB of data. The application is to run 24 x 7 and is primarily random read and insert transactions. Transaction rate is expected to be quite high. the environment is likely to be V6 data sharing. Initial feedback I am [...] 7257 131 21_Re: security question11_Kwan, James18_James_Kwan@BMC.COM31_Wed, 23 Aug 2000 09:40:28 -0500559_iso-8859-1 Tina,

Why don't you try to create another table with owner id say user2 and try to drop it without set current sql?

James Kwan

-----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Wednesday, August 23, 2000 9:31 AM To: DB2-L@RYCI.COM Subject: Re: security question



So, are CREATE, GRANT, and REVOKE the only DDL that require a 'set current sqlid' to get the proper authority, and the others will work if the proper security is available from a secondary authid? [...] 7389 74 19_Re: CPU usage in $$22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 23 Aug 2000 10:55:42 -0400636_iso-8859-1 Another nice product is MXG http://www.mxg.com. It's cheap, however, it requires SAS.



Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com





-----Original Message----- From: Wu, James [mailto:jwu@KRAFT.COM] Sent: Wednesday, August 23, 2000 9:57 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] CPU usage in $$



You can get the CPU Usage from some performance monitoring products like MICS or IBM/Tivoli Performance Reporter. You have to do some homework because those tools give you only the CPU usage in Seconds which DO depend on the CPU Models. [...] 7464 152 21_Re: security question18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 23 Aug 2000 11:03:45 -0400268_- The simple answer is have your security area add your user1 id to the group1 group. This way you can eliminate the set current sqlid. That is why you don't have to set it with user2. User2 is part of the group1 group which either has sysadm or dbadm authority. [...] 7617 56 33_Re: Insert, problem using "STRIP"14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 23 Aug 2000 10:14:48 -0400726_iso-8859-1 Ron,

Check on this, but I do not believe that expressions can be used as values in INSERT statements until V7.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Rohn.Solecki@MTS.MB.CA > Sent: Wednesday, August 23, 2000 10:29 AM > To: DB2-L@RYCI.COM > Subject: Insert, problem using "STRIP" > > > OS390 DB2 V5 > A developer called me with a problem. > > We have been having problems trying to use the STRIP function in a [...] 7674 193 21_Re: security question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 23 Aug 2000 10:34:54 -0500572_iso-8859-1 Both user1 and user2 are set up exactly the same. They both are connected to group1, which has sysadm authority granted to it. It appears that CREATE and GRANT require the authorization granted to the current sqlid (your userid if you don't enter SET CURRRENT SQLID) and REVOKE requires your current sqlid is the same as the id that did the GRANT (or use of the BY clause?), but the rest only require the authority be granted to any of the secondary authids/racf groups you're connected to. I'd like to know for sure if there's any other DDL that requires [...] 7868 88 21_Re: security question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 23 Aug 2000 09:07:28 -0500548_- I ran the creates and drops from dsntep2 in batch, so I'm positive the sqlid was as stated in my email. I had no override on my job card, so the userid was my tsoid.

Tina

> -----Original Message----- > From: Nadir Doctor [SMTP:Nadir.Doctor@BGEHOME.COM] > Sent: August 23, 2000 8:51 AM > To: DB2-L@RYCI.COM > Subject: Re: security question > > Tina, > > The SQLID will continue to be reused until either: > > * it is reset to a different value using the "SET CURRENT SQLID" command > * the current session is closed & a new one [...] 7957 84 29_Re: Partitioning Large Tables14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Wed, 23 Aug 2000 16:32:52 +0100433_iso-8859-1 Craig,

I've recently gone through a small (compared to you) excercise of a similar nature. My findings for your questions are thus: 1) Try to let the application drive the partitioning keys as much as possible. 2) Haven't noticed any yet. 3) Don't do it! 4) A very good idea. Have used it before elsewhere. 5) Also a good idea, and one still under consideration for when our data grows. 6) Haven't been there. [...] 8042 334 67_Re: Timeouts related to a lock where MEMBER name is subsy stem name15_Andrea Milligan25_Andrea_Milligan@BCBST.COM31_Wed, 23 Aug 2000 11:52:08 -0400419_iso-8859-1 Thanks! I just totally ignored the ..501t message for some reason. It had been an extremely hectic day and I guess my "thinking" power just decided to take a leave of absence.

-----Original Message----- From: troy Coleman [mailto:Troy.Coleman@UAL.COM] Sent: Wednesday, August 23, 2000 9:00 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Timeouts related to a lock where MEMBER name is subsystem name [...] 8377 205 21_Re: security question13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 23 Aug 2000 08:53:00 -0700640_iso-8859-1 -----Original Message----- From: Hilton, Tina, BmS - NMI -PM [mailto:Tina.Hilton@BMSUS.COM] Sent: Wednesday, August 23, 2000 8:35 AM To: DB2-L@RYCI.COM Subject: Re: security question



Both user1 and user2 are set up exactly the same. They both are connected to group1, which has sysadm authority granted to it. It appears that CREATE and GRANT require the authorization granted to the current sqlid (your userid if you don't enter SET CURRRENT SQLID) and REVOKE requires your current sqlid is the same as the id that did the GRANT (or use of the BY clause?), but the rest only require the authority be granted [...] 8583 23 25_Re: IDMS to DB2 migration12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 23 Aug 2000 10:37:41 -0500477_- There are quite a few options, packages and services. This is an area where the experience is very useful. We have a Software Migration Project Office in IBM that has worked on a number of successful conversions. See the web ibm.com/solutions/softwaremigration/

About 8 years ago we had a guide with specifics about migration from IDMS, but it's out or date and out of print. The Software Migration Project Office may have an old copy or run it through a copier. [...] 8607 18 53_Re: RE : DB2CODEPAGE :OS/390 V5.1 TO DB2 CONNECT V5.212_Roger Miller19_millerrl@US.IBM.COM31_Wed, 23 Aug 2000 10:46:11 -0500296_- The discussion on these character codes is in the Installation Guide, Appendix B. I would suggest getting the latest one from the web, since many combinations have been added in the past three years. While the hard copy has not been updated, the web and CDROM versions have been modified. [...] 8626 18 45_Is it true comment? OS/390 V5 to V7 migrate??8_Bob Abad16_BobRabad@AOL.COM29_Wed, 23 Aug 2000 12:15:09 EDT291_US-ASCII A DBA peer made a comment that you can migrate from V5 to V7 as long as all indexes are converted to type-2? I didn't see a note or bullet in 'What's new in V7'. What are the ramifications of skipping the V6, and also has any Beta site or IBM tested this scenario(V5 to V7)??? [...] 8645 143 21_Re: security question0_19_mike.holmans@BT.COM31_Wed, 23 Aug 2000 16:10:30 +0100625_iso-8859-1 Yes.

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

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

> -----Original Message----- > From: Hilton, Tina, BmS - NMI -PM [SMTP:Tina.Hilton@BMSUS.COM] > Sent: Wednesday, August 23, 2000 3:31 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] security question > > So, are CREATE, GRANT, and REVOKE the only DDL that require a 'set current > sqlid' to get the proper authority, and the others will work if the proper > security is available from a secondary authid? > > Tina > > > [...] 8789 239 21_Re: security question12_Hall, Robert25_Robert.Hall@OCC.TREAS.GOV31_Wed, 23 Aug 2000 12:22:10 -0400576_iso-8859-1 Hi Tina,

I created a tablespace with userid A (which is connected to a group with sysadm) and I had to set current sqlid=sysadmauthid in order to do the create. I could do the drop if I set the current sqlid='A'. This I could probably explain away by the fact that there is a createdby column in sysibm.systablespace showing my "real" userid; the creator column lists the racf group with sysadmauthid as the creator of the object. Sooooo, not to be outdone, I logged onto userid B (no sysadm) and tried to drop the tablespace. Nothing doing, -551. So I [...] 9029 43 36_Re: Converting Peoplesoft paycalc to11_Robert Jans21_Jans.Robert@AMSTR.COM31_Wed, 23 Aug 2000 10:33:00 -0600781_- Mark, have you or do you run correlated runstats on this table? We've occassionally experienced that same type of problem and have found that the extra statistics makes a huge difference........... 11/2 minutes after versus 1 1/2 HOURS before and this was only for the checking paysheet query.

Robert Jans Albertsons, Inc 155 North 400 West Mail Drop 4427 Salt Lake City, UT 84103 (801) 961-3212 jans.robert@albertsons.com ------------------( Forwarded letter 1 follows )--------------------- Date: Wed, 23 Aug 2000 10:29:49 -0400 To: DB2-L@RYCI.COM From: mark.hardenburg@PRUDENTIAL.COM Sender: IMCEAX400-c=US+3Ba=+@gcs.alias Reply-To: DB2.Data.Base.Discussion.List[DB2-L]@RYCI.COM Subject: Converting Peoplesoft paycalc to parallel jobs [...] 9073 91 41_Re: Strobe Analysis shows lots of Commonx10_Mark Labby16_mlabby@PHEAA.ORG31_Wed, 23 Aug 2000 12:34:41 -0400549_us-ascii Check and see if you have which monitoring tools you may have running, it may not actually be the application itself that is using the CPU.

We had the same results when looking at Strobe results of our big batch jobs a few years ago. After digging into things for a while, everything we saw pointed to PTXMAN that was being run to collect statistics for the Platinum Detector and SubSystem Analyzer. In some cases, we saw in excess of 30% of the CPU being attributed to Commonx during very large batch jobs with PTXMAN running. [...] 9165 17 29_OT - IMS forum or listserve??8_Bob Abad16_BobRabad@AOL.COM29_Wed, 23 Aug 2000 12:36:36 EDT472_US-ASCII Is there a good IMS forum just like this one????? Be supporting an existing/old IMS application(on V5), a certain percentage of my DBA time, from outsource back to in-house....

Thanks in advance for your comments..

================================================ 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. 9183 15 23_Re: Scrollable Cursors.12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 23 Aug 2000 11:23:40 -0500286_- Version 7 of DB2 for OS/390 includes scrollable cursors. There is a very little bit of documentation in the What's New? book - out on the web. There is a session scheduled at the DB2 Technical Conference. V7 is not generally available, so most of the information is not yet out. [...] 9199 33 33_Re: OT - IMS forum or listserve??13_Thomas, Janis19_Janis.Thomas@CA.COM31_Wed, 23 Aug 2000 12:45:18 -0400586_iso-8859-1 Send an email to: listproc@lists.missouri.edu with the following command: subscribe IMS-L

Janis Thomas DB2 Product Management Computer Associates International, Inc. janis.thomas@ca.com 630-481-1830





-----Original Message----- From: Bob Abad [mailto:BobRabad@AOL.COM] Sent: Wednesday, August 23, 2000 11:37 AM Subject: OT - IMS forum or listserve??



Is there a good IMS forum just like this one????? Be supporting an existing/old IMS application(on V5), a certain percentage of my DBA time, from outsource back to in-house.... [...] 9233 104 73_Re: off topic .... how to accomodate more than 24 lines in a cics sc reen14_Jean W Stimmel25_jwstimmel@DUKE-ENERGY.COM31_Wed, 23 Aug 2000 12:49:32 -0400686_us-ascii From my Assembler/COBOL/CICS programmer-son:

The terminal must be defined to handle more than 24 lines. You can find out by using the INQUIRE TERMINAL command in CICS specifying that you need SCRNHT (there is also SCRNWD) and you should get the number of lines that terminal is capable of.







|--------+--------------------------> | | John Wallin | | | | | | | | | 08/23/00 10:04 | | | AM | | | Please respond | | | to DB2 Data Base| | | Discussion List | | | | |--------+--------------------------> >----------------------------------------------------------------------------| | | | To: DB2-L@RYCI.COM [...] 9338 17 27_Re: AW: Scrollable Cursors.12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 23 Aug 2000 11:33:45 -0500375_- I certainly don't speak for all of IBM, but I'll give my opinion. Late additions to Version 6 have caused too much disruption for customers already. The essence of the request is to have a few million dollars spent, with a larger potential from other customers, most of whom would not benefit. When it comes to retrofits this late in the cycle, I want to just say no. [...] 9356 277 21_Re: security question13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 23 Aug 2000 09:52:10 -0700547_iso-8859-1 Looking through the v6 SQL Reference, there does seem to be a consistency in the description of the required privileges. In the discussion for Privilege Set, when it says "union of the privileg sets that are held by each authorization ID of the process" (as it does for DROP), then you can get this privilege from a secondary authid. When it says "the privileges that are held by the SQL authorization ID of the process" (as it does for GRANT and REVOKE), then the current SQLID apparently must have the appropriate authorization. [...] 9634 13 33_Re: OT - IMS forum or listserve??8_Bob Abad16_BobRabad@AOL.COM29_Wed, 23 Aug 2000 13:03:02 EDT271_US-ASCII Thank you, Janis!!!!

================================================ 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. 9648 331 21_Re: security question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Wed, 23 Aug 2000 12:08:47 -0500596_iso-8859-1 Thanks to everyone who helped with this. I wish you HAD to use the SET CURRENT SQLID for DROPS, ALTERS, etc., but at least now I understand how it works.

Tina

> -----Original Message----- > From: OConner, John [SMTP:John.OConner@COURTS.WA.GOV] > Sent: August 23, 2000 11:52 AM > To: DB2-L@RYCI.COM > Subject: Re: security question > > Looking through the v6 SQL Reference, there does seem to be a consistency > in > the description of the required privileges. In the discussion for > Privilege > Set, when it says "union of the privileg sets that are held by each > [...] 9980 57 49_Re: Is it true comment? OS/390 V5 to V7 migrate??0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 23 Aug 2000 12:21:25 -0500555_us-ascii Take a look in Chapter 4, "Migrating earlier versions of DB2 ..." (pg 51) in the "DB2 V7 What's New". That section also mentions some other docs (DB2 v7 Program Directory) with explict info on differences between V5,V6 and V7.

ramifications: - we are still waiting to hear officially details of the change in pricing, where some (not yet specified?) utilites are no longer going to be part of the base price. - V6 (OS390) has been GA for over a year now and has had many patches/apars, V7 won't be GA till the end of the year (do you [...] 10038 132 29_Re: Partitioning Large Tables12_Susan Lawson22_lawson_susan@YAHOO.COM31_Wed, 23 Aug 2000 10:19:59 -0700571_us-ascii Craig,

We have built several of these large tables (3-6 billion rows) and are even currently doing a couple of 20 billion row tables and a 40 billion table. So I can give you a few comments based upon our experience.

When deciding on a partitioning strategy if you are talking about massive amounts of data being inserted and you are keeping historical data, I would not recommend going with a random key. You will end up with a maintenance nightmare, not to mention if you ever have a sequential batch process that needs to be run - you will [...] 10171 41 25_Re: IDMS to DB2 migration14_Susan Birgeles25_Susan.Birgeles@ALLTEL.COM31_Wed, 23 Aug 2000 13:50:00 -0500469_us-ascii A company called Tact also has a migration aid. It migrates ADSO code to CICS/COBOL as well. One way to reach them is thru Crystal Systems (www.crystal-sys.com)

No guarantees. We are looking for options ourselves and ran accross this product. ______________________________ Reply Separator _________________________________ Subject: Re: IDMS to DB2 migration Author: DB2-L@RYCI.COM (DB2 Data Base Discussion List) at INTERNET Date: 8/22/00 7:06 AM [...] 10213 118 27_table expressions and union15_Randall Barbour21_rbarbourbis@YAHOO.COM31_Wed, 23 Aug 2000 10:57:36 -0700502_us-ascii I have a question about nested table expressions and unions. Our table is defined such that a prev_amt and curr_amt are stored on each row. We are trying to retrieve the data so that current is on one row and previous is on another. We do this using a union and everything works fine. However, the reporting tool we use doesn't allow for a union (at least not easily), so we are trying to create a table expression in the From cluase. The tool allows us to create a custom 'From' clause. [...] 10332 63 50_Re: Converting Peoplesoft paycalc to parallel jobs13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Wed, 23 Aug 2000 13:06:27 -0500559_iso-8859-1 We have done this with our Peoplesoft time and labor processes. The key to this for us was partitioning the tables so that each parallel job processed a different partition (This ensured that no two jobs would be looking at data on the same page). We've been doing this for around 5 years with no problems. I haven't done it in a production environment with the paycalc, but about a year and a half ago I had experimented with parallel payroll jobs. I generated some extra rows in our test environment so that the volume was around 9X what we [...] 10396 15 17_STOSPACE Question10_Keith Kuhn21_Keith_Kuhn@WENDYS.COM31_Wed, 23 Aug 2000 14:08:09 -0400475_us-ascii Question regarding the STOSPACE utility. I understand that it updates the catalog with DASD usage statistics. Are these statistics used by the DB2 optimizer, or are the statistics simply used for catalog query and reporting?

================================================ 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. 10412 37 27_Re: OS/390 DB2 DBA POSITION13_Pranav Sampat21_psampat@PACIFICEX.COM31_Wed, 23 Aug 2000 11:10:48 -0700416_US-ASCII Hi Rick, I am interested in the DB2 DBA position. To summarize, I have a over 5 years of experience on mainframes with area of expertise being DB2 on OS/390. I have worked in DB2 at various levels starting with application programming, DBA, system administration and training. I would like to know if you process Work Permits for a non-US citizens. If yes, I can e-mail you a copy of my latest resume. [...] 10450 263 31_Re: table expressions and union11_Shigang Mai16_smai@METLIFE.COM31_Wed, 23 Aug 2000 14:19:24 -0400711_us-ascii

Try to create a view and select from the view using the tool. Sam







"Randall Barbour" @RYCI.COM> on 08/23/2000 01:57:36 PM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc: Subject: table expressions and union



I have a question about nested table expressions and unions. Our table is defined such that a prev_amt and curr_amt are stored on each row. We are trying to retrieve the data so that current is on one row and previous is on another. We do this using a union and everything works fine. [...] 10714 24 23_Recovering a DB2 Volume14_Dean Montevago18_DMonteva@VNSNY.ORG31_Wed, 23 Aug 2000 14:23:40 -0400525_- Hi, If by chance you loose a DASD volume that contains DB2 tables. Is there a way (within DB2) to list what belongs on that volume. Thanks Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax

dmonteva@vnsny.org

================================================ 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. 10739 19 74_Re: off topic .... how to accomodate more than 24 lines in a cic s sc reen26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 23 Aug 2000 13:29:08 -0500495_- The MAP has to be defined and the LOGMODE need to have PSERVIC that starts with X'028' and the RU sizes have to match and the emulator has to be set to use the larger screen size. Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ 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. 10759 60 17_DB2MOVE Questions10_Mike Wiles14_mwiles@UCG.COM31_Wed, 23 Aug 2000 14:35:17 -0400331_iso-8859-1 Hi List!

I am running DB2 UDB 6.1 on AIX. I've been trying to convert from DB2 UDB 6.1 on NT.

The first thing I did was get the DDL from DB2LOOK on the NT machine. Then I altered the create tablespace commands to reflect the AIX environment. The DDL runs fine, the tablespaces and tables are created. [...] 10820 286 31_Re: table expressions and union0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 23 Aug 2000 14:32:32 -0400523_us-ascii



You can't do unions in subselects or in this case nested tables.

Dean









Shigang Mai @RYCI.COM> on 08/23/2000 02:19:24 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: table expressions and union





Try to create a view and select from the view using the tool. Sam [...] 11107 149 31_Re: table expressions and union0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 23 Aug 2000 14:34:24 -0400739_us-ascii Union are not allowed in subquery's or nested tables (basically the same thing).

Dean









Randall Barbour @RYCI.COM> on 08/23/2000 01:57:36 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: table expressions and union



I have a question about nested table expressions and unions. Our table is defined such that a prev_amt and curr_amt are stored on each row. We are trying to retrieve the data so that current is on one row and previous is on another. We do this using a union and everything works fine. [...] 11257 127 19_Re: CPU usage in $$12_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 23 Aug 2000 11:42:55 -0700595_us-ascii If what you're looking for is the magic code that changes all the internal measurements (timerons, memory usage, etc) to the actual $$ amounts printed on the job's sysout, there is an MVS SMF exit (sorry I forget which one) which provides this function. Someone has to decide how much they want to charge for each component, and then plug the new values into the exit. Deciding what to charge for each component is usually more of a religious issue than a technical issue. Understanding what all the various components are, and how changing MVS tuning parameters effect what these [...] 11385 24 21_Re: DB2MOVE Questions13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Wed, 23 Aug 2000 13:29:32 -0500330_- I've got a Java program to drop the RI then set constraints later.

So I run another program to create all of my tables.

Then I run the program to set constraints off.

Then I DB2MOVE import the tables.

Then I run the program to set constraints on.

Then I run a script to reorg everything. [...] 11410 59 17_Re: DDF CPU Usage13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 23 Aug 2000 14:01:45 -0500440_iso-8859-1 Dave,

Do you happen to be using BMC's Apptune? We are currently struggling with huge CPU usage in DDF enclaves and have correlated this to the monitor (Apptune off, normal CPU, Apptune on, huge cpu usage). A bug has been tentatively identified.

-----Original Message----- From: David Williams [mailto:David-O.Williams@ubsw.com] Sent: Thursday, August 17, 2000 4:31 AM To: DB2-L@RYCI.COM Subject: DDF CPU Usage [...] 11470 96 21_Re: DB2MOVE Questions10_Leo Pedron19_lpedron@BOSCOVS.COM31_Wed, 23 Aug 2000 15:06:29 -0400555_iso-8859-1 Hi Mike,

Indexing mode is an option on the load utility. I have never encountered any problems with DB2MOVE and indexing, but I'm not sure how you could set this while using Db2MOVE either.

You could alter the db2move.lst file so that you load the parent tables first. This file is found in the directory where all the .ixf and .msg files are located. DB2 uses this file as a guide to all the tabXX.ixf files and the associated tables. They don't need to be in order, so you can stack them in order of your RI and the import [...] 11567 13 17_Re: DDF CPU Usage14_Philip Gunning18_pgunning@PHEAA.ORG31_Wed, 23 Aug 2000 15:11:07 -0400334_us-ascii Enclaves will take what CPU they can get unless they are workload managed. HTH Phil

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11581 89 21_Re: DB2MOVE Questions13_Fletcher, Jim21_jim.fletcher@BSIS.COM31_Wed, 23 Aug 2000 15:16:23 -0400605_iso-8859-1 I have done similar work from DB2 NT to AIX using db2move. I generated a file containing SET INTEGRITY .... OFF for each table before running db2move load. After db2move completes, I run a SET INTEGRITY ... IMMEDIATE CHECKED to re-enable referential checking. I used the -lo replace option for easier restart. Should db2move abnormally terminate during the load, it leaves the tablespace in load pending with no way to restart the utility that I know of...couldn't even the drop the tablespace with it in load pending. There is a section in the Data Movement Utilities Guide on db2move. I [...] 11671 32 24_Cross LPAR communication12_Vernon, John27_John.Vernon@TRS.STATE.TX.US31_Wed, 23 Aug 2000 14:39:22 -0500410_iso-8859-1 On DB2 v 5.1

I want to do a cross lpar select utilizing either QMF or SPUFI.

I have DB2D and DB2Q running on separate LPARS. Both have DDF running (DB2*DIST). In their respective SYSIBM.LOCATIONS it is defined for their LOCATION (DB2DDIST and DB2QDIST) while LINKNAME is (LUDB2Q AND LUDB2D). When I execute a select * from db2qdist.sysibm.locations I receive the following error: [...] 11704 124 27_Re: Recovering a DB2 Volume13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 23 Aug 2000 14:41:16 -0500539_US-ASCII Dean, Here's what we would do If it was one of our non SMS volumes.

SELECT SGNAME, SGCREATOR, VOLID, IBMREQD FROM SYSIBM.SYSVOLUMES WHERE VOLID = 'XXXXXX'

All our non SMS managed stogoups relate to a strict tablespace and index space naming convention, and the dasd volumes are all DBcuuu.

All are SMS managed objects get a LISTC LVL('DSN.DSNDBD.DBNAME') VOLUME after a reorg, or if for some reason an object(s) is manually moved another volume. We keep the output until the next completed reorg / move. [...] 11829 102 28_Re: Cross LPAR communication13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Wed, 23 Aug 2000 15:02:06 -0500545_US-ASCII John, The resource type 1003 is CNOS. Check your VTAM appl definitions. Kurt

>>> John.Vernon@TRS.STATE.TX.US 08/23/00 02:39PM >>> On DB2 v 5.1

I want to do a cross lpar select utilizing either QMF or SPUFI.

I have DB2D and DB2Q running on separate LPARS. Both have DDF running (DB2*DIST). In their respective SYSIBM.LOCATIONS it is defined for their LOCATION (DB2DDIST and DB2QDIST) while LINKNAME is (LUDB2Q AND LUDB2D). When I execute a select * from db2qdist.sysibm.locations I receive the following error: [...] 11932 24 43_Can you recommend a good advanced SQL book?13_Judi Westcott23_judi_westcott@YAHOO.COM31_Wed, 23 Aug 2000 14:51:28 -0500319_- Hello

We are a db2 v5 shop and recently I have had several programmer's ask if there are any good (recent) advanced SQL books that would be both a good reference and learning tool. (I know training would be beneficial however I do not believe that there is money in the budget for it in the near future.) [...] 11957 18 18_IBM Query monitor?0_19_Tim.Lowe@STPAUL.COM31_Wed, 23 Aug 2000 15:07:06 -0500491_us-ascii Does anyone have any opinions or advise on the IBM Query Monitor? I have been told that IBM just purchased it from another company. It has been recommended here for monitoring of dynamic SQL. I had not heard of it before.

Thanks, Tim

================================================ 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. 11976 21 47_Re: Can you recommend a good advanced SQL book?13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Wed, 23 Aug 2000 14:57:40 -0500430_- > I have had several programmer's ask if there are any good (recent) advanced > SQL books that would be both a good reference and learning tool.

http://www.mkp.com/books_catalog/catalog.asp?ISBN=1-55860-576-2

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition ... [...] 11998 54 27_Re: Recovering a DB2 Volume12_Bob Lawrence21_rlawrence@BOSCOVS.COM31_Wed, 23 Aug 2000 16:28:40 -0400595_us-ascii Dean, I would not trust using DB2 sysstogroup table to see what stogroup(s) the volume you are looking to recover is in. That will not tell you which specific datasets are catalogued on the specific volume. If you know REXX you could do a 'listc level(HLQ.DSNDBC) vol' and parse the listing for the specific volume in question. This will show all of the datasets that are catalogued and the volumes the datasets are catalogued on. A faster way than listcat is to use the CSI (catalogue search interface) requesting volsers for the dsname filter HLQ.DSNDBC.**. If you have not used [...] 12053 56 47_Re: Can you recommend a good advanced SQL book?9_Cam White20_cwhite@REVEALNET.COM31_Wed, 23 Aug 2000 16:25:00 -0400632_iso-8859-1 Judi,

You might want to point your developers to the RevealNet for DB2 Knowledge Base. It covers 1,700 topics from DB2 version 4 through 6 on OS/390.

30 day free trials are available from http://www.revealnet.com

Best wishes,

Cam White RevealNet

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Judi Westcott > Sent: Wednesday, August 23, 2000 3:51 PM > To: DB2-L@RYCI.COM > Subject: Can you recommend a good advanced SQL book? > > > Hello > > We are a db2 v5 shop and recently I have had several programmer's ask if > there [...] 12110 116 28_Re: Cross LPAR communication12_Kirk Hampton16_khampto1@TXU.COM31_Wed, 23 Aug 2000 16:42:49 -0500539_us-ascii



Hi John, The location name can be anything you want to make up, it's fine to have it be the same name as your DDF address space (DB2QDIST). However, the linkname must match the VTAM applid that the xxxxDIST address space is using, this will be displayed as LU in a DSNL004I message in the xxxxMSTR log when DDF is started. Also you may need to check the VTAM definition for that APPLID and make sure that the session limit is set high enough, and check your ZPARMS to see that MAXDBAT and/or CONDBAT are > 0. [...] 12227 62 27_Re: Recovering a DB2 Volume14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Wed, 23 Aug 2000 17:05:58 -0500316_- get the list of the high-level qualifiers that can go to that volume. Do listcats on the catalogs these aliases are found in. Do finds in the listcat output for the volume in question. Note: DB2 Dsns are cataloged, but if you had other non-cataloged dsns on the same volume listing the catalog will not help. [...] 12290 29 22_Re: IBM Query monitor?14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 23 Aug 2000 19:08:55 -0400474_ISO-8859-1 It's an excellent product. To put it in proper perspectives, I believe IBM did not "purchase" it - but is remarketing it under their own product name. Regards, Joel:



Message text written by DB2 Data Base Discussion List >Does anyone have any opinions or advise on the IBM Query Monitor? I have been told that IBM just purchased it from another company. It has been recommended here for monitoring of dynamic SQL. I had not heard of it before. [...] 12320 35 31_Bufferpool performance question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Wed, 23 Aug 2000 16:18:00 -0700358_iso-8859-1 What conclusions can be drawn, besides the obvious that this is a poor performing program, when the bufferpool report numbers read as follows: Getpage Requests = 8503 Synchronous Read I/O = 8 Getpage/Read I/O = 1062.87 Seq Prefetch and Dynamic prefetch requests both 0 List Prefetch Req = 2989 Prefetch Pg Reads = 8435 BP Hit Percentage = 1% [...] 12356 264 29_Re: DB2 LOAD Utility with SAP12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Wed, 23 Aug 2000 18:29:37 -0500376_iso-8859-1 Andy,

Thanks for the input.

We are in the process of obtaining a log analysis tool. This is an essential tool for us for many reasons: * Transaction backout (undo stupid user tricks, stupid programmer tricks, stupid DBA tricks) * Transaction analysis (what did it really do?) That would apply to this data load situation, as well. * Audits * etc [...] 12621 150 31_Re: table expressions and union14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 23 Aug 2000 19:34:54 -0400684_iso-8859-1 UNION in table expressions and views is not allowed on the OS/390 until Version 7.1, and this will include the ability to put UNIONS in subqueries.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Randall Barbour > Sent: Wednesday, August 23, 2000 1:58 PM > To: DB2-L@RYCI.COM > Subject: table expressions and union > > > I have a question about nested table expressions and unions. Our table is > defined such that a prev_amt and curr_amt are stored on each row. [...] 12772 21 40_Setting SPUFI to run across DB2 Releases12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Wed, 23 Aug 2000 20:10:00 -0500502_iso-8859-1 I am setting up a new release of DB2. SPUFI gives a message DSNE133E DSNECP12 release levels not compatible. I recall there is a method to do this, but can not remember.

Any suggestions?

Gerald Hodge HLS Technologies, Inc. 281-265-3004

================================================ 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. 12794 187 31_Re: table expressions and union14_Purcell, Terry30_Terry.Purcell@TEAM.TELSTRA.COM31_Thu, 24 Aug 2000 11:43:52 +1000547_iso-8859-1 Randall,

You can use a dummy join column and full outer join to simulate a union. This can be wrapped in a NTE. It's not pretty, but I've used it a couple of times with success.

SELECT COALESCE(A.PROCESS_CYM,B.PROCESS_CYM) ,COALESCE(A.REGION_ID,B.REGION_ID) ,COALESCE(A.AFO_ID,B.AFO_ID) ,COALESCE(A.PLAN_AREA_ID,B.PLAN_AREA_ID) ,COALESCE(A.STAT_PREV_AMT,B.STAT_PREV_AMT) ,COALESCE(A.TYPE,B.TYPE) FROM

(SELECT '1' AS JOIN_COL ,PROCESS_CYM ,REGION_ID ,AFO_ID ,PLAN_AREA_ID ,STAT_PREV_AMT AS AMT ,'PRIOR' AS TYPE [...] 12982 77 35_Re: Bufferpool performance question14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 23 Aug 2000 22:38:31 -0400339_ISO-8859-1 Sandi, You are providing only a small piece of bufferpool information, and this makes it rather difficult to offer any effective analysis. Which software product did you get the below information from, and was this from the system level pool statistics, or the application accounting information in the bufferpool section? [...] 13060 87 28_Re: V5 to V6 migration error0_14_mtdage@ATT.NET31_Mon, 14 Aug 2000 15:47:08 +0000435_- We had this experience and this is what we did:

* Brought DB2 down and brought it back up under V5. We did a dump volume backup before we started the migration so all we had to do is restore all DB2 datasets to its original state before the migration.

* Run DSNTIJPM This JCL queries your V5.1 catalog to identify objects that are incompatible with DB2 V6.1 and must be converted or eliminated prior to migration. [...] 13148 49 23_Re: Scrollable Cursors.14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 24 Aug 2000 14:14:31 +1000518_iso-8859-1 V7, it's not GA but see http://www-4.ibm.com/software/data/db2/os390/pdf/whatv7.pdf

-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Wednesday, August 23, 2000 12:13 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Scrollable Cursors.



Hi list, just a (hopefully) quick question.

Which version of DB2 (OS/390) has, or going to have scrollable cursors? If it's GA, what doc is available?

Thanks,

Martin Wolff, Global Crossing. [...] 13198 84 21_Re: security question14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 24 Aug 2000 14:27:25 +1000629_iso-8859-1 Tina,

Think of it this way: - if you are creating/granting/revoking something, the current sqlid is the only id that is checked for authority - if you are altering/droping something, the authority can be derived from the current sqlid, or any secondary sqlid.

There are many variations on this depending on whether the DDL is static (although I doubt that there is much static DDL outside declared temporary tables - which hardly count) or dynamic; DYNAMICRULES or BIND (!) or RUN; and what the actual statement is (read the 'Authorization' paragraph for each statement). But the above rule gets me [...] 13283 92 23_Repost: JustDB2Jobs.com13_Morrill, John12_JohnM@VP.NET31_Wed, 23 Aug 2000 22:37:50 -0600432_iso-8859-1 Dear DB2 Interested Parties,

If you haven't heard about the JustDB2Jobs.com Web site, you might want to check it out at http://www.justdb2jobs.com/ .

Regards, Mike Software is the soul of e-business Internet: dbswift@us.ibm.com IBM Silicon Valley Lab - 555 Bailey Avenue - San Jose, CA 95141 Phone: 408 463-4105, Fax: 408 463-4633, (IBM Tie Line: 543) Lotus Notes: Michael Swift/Santa Teresa/IBM@IBMUS [...] 13376 1534 160_Repost: White Paper: Detail of the TPC-C Audited Benchmark Featur ing DB2 (was: "IBM blows lid off the TPC-C" and other Press Coverage of the DB2 TPC-C Results)13_Morrill, John12_JohnM@VP.NET31_Wed, 23 Aug 2000 22:38:31 -0600473_iso-8859-1

Dear DB2 Interested Parties,

A white paper is now available about last month's record-setting DB2 UDB for Windows 2000 TPC-C benchmark, "Leading Vendors Validate Power of Clustering Architecture - Detail of the TPC-C audited benchmark, featuring IBM Netfinity, Pentium III Xeon servers, Windows 2000 Advanced Server and DB2 Universal Database".

I have a "PDF" copy of the report (2093 Kbytes) that I can send to you upon your request. [...] 14911 175 39_Repost: *NEW* "DB2 Skills Plus" Program13_Morrill, John12_JohnM@VP.NET31_Wed, 23 Aug 2000 22:40:07 -0600626_-

Dear DB2 Interested Parties,

Please find below a bulletin about a new program addressing the increasing requirements for skilled DB2 professionals, the DB2 Skills Plus program.

Regards, Mike + + + + + + +

IBM Launches the DB2 Skills Plus Program

In the wake of the worst Industry I/T job shortage world-wide (in the U.S. unfilled I/T shortages are estimated at 1 million), IBM is taking an aggressive lead on addressing the problem with a new initiative for its leading database product - DB2 Universal Database for Unix, Windows & OS/2, called the DB2 Skills Plus Program to ensure [...] 15087 65 35_Re: Bufferpool performance question7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Thu, 24 Aug 2000 11:36:34 +0530591_iso-8859-1 Hi Sandi, As pointed out by Joel, the statistics given by you looks quite unrelated to each other because the getpage request,total read request,getpage/read I/O and Hit Ratio is no way related in this data.Please look at the getpage request and total I/Os and find out the Hit ratio from the standard formula given in the article.If this is not the pool dedicated to the objects used by the mentioned program then there is no point thinking pool is filled twice with respect to the total prefetch request.Sometimes it may be or sometimes not and sometimes the reason may be [...] 15153 71 47_AW: Can you recommend a good advanced SQL book?12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 24 Aug 2000 08:52:16 +0200654_iso-8859-1 Judi,

two recommendations:

1. Joe Celko's "SQL FOR SMARTIES" (an andvanced SQL Programming Guide) ISBN 1-55860-323-9 2. Jim Melton's "Understanding the new SQL - a complete guide" ISBN 1-55860-245-3

HTH.

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ [...] 15225 25 22_AW: IBM Query monitor?12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 24 Aug 2000 08:58:22 +0200727_iso-8859-1 Joel, is a description of the IBM query monitor available on the web ?

With kind regards - mit freundlichen Grüssen, G e o r g H . P e t e r DB2 Data Base Administrator c/o ------------------------------------------------------------------------ Datenzentrale Baden-Wuerttemberg Department Product Support Krailenshaldenstrasse 44, 70469 Stuttgart, Germany Phone 0049-711-8108-271 PC-Fax 004971189696071 ------------------------------------------------------------------------ ===============================================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. 15251 56 20_Re: Plans-2-Packages12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 24 Aug 2000 08:44:00 +0100304_- Do you mean DB2 Packages: Implementation and Use (GG24-4001-00) ? We have a copy. I'm supprised it's not in Redbooks Online, but I can't find it, does this mean we need to download all new redguides just in case?

If you still want a copy mail me direct and we can come to some arrangement. [...] 15308 71 47_Re: Can you recommend a good advanced SQL book?10_John Hardy27_john_j_hardy@CONSULTANT.COM31_Thu, 24 Aug 2000 03:33:24 -0500589_- Hello Judi,

I am assuming that you are an OS/390 site. If not, then please disregard this Email.

I have often been approached by Programmers who are keen to increase the depth of their DB2 knowledge, and I have always loaned them my copy of Gabrielle Wiorkowski's 'Design and Development for Performance', which I acquired before attending a similarly named course run by her in the early nineties. It has usually been appreciated so much that I have had difficulty retrieving it; sometimes even having to re-purchase it if I cannot remember to whom I have loaned it! [...] 15380 67 70_Result sets returned from stored procedure don't return field names ??10_Ozan VAKAR19_ovakar@32BIT.COM.TR31_Thu, 24 Aug 2000 12:35:55 +0300353_iso-8859-9 I'm using DB2 UDB V7.1 on NT My problem is when I return a result set from a stored procedure, field names are 1,2,3,... A typical test proc is :

CREATE PROCEDURE TestProc () LANGUAGE SQL MODIFIES SQL DATA DYNAMIC RESULT SETS 1 PROC_BODY: BEGIN DECLARE qryData CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM TESTTABLE OPEN qryData; END 15448 89 41_FW: [DB2-L] Insert, problem using "STRIP"14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 24 Aug 2000 19:42:50 +1000548_iso-8859-1 Richard, actually it's V6. But that's still later than Rohn's V5.

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



-----Original Message----- From: Richard Yevich [mailto:ryevich@attglobal.net] Sent: Thursday, August 24, 2000 12:15 AM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Insert, problem using "STRIP"



Ron,

Check on this, but I do not believe that expressions can be used as values in INSERT statements until V7. [...] 15538 58 27_Re: Recovering a DB2 Volume14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 24 Aug 2000 19:56:48 +1000421_iso-8859-1 Try using DCOLLECT VOLUMES(....) NODATAINFO - if you're authorised for it. (It's an IDCAMS command.)

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Dean Montevago [mailto:DMonteva@VNSNY.ORG] Sent: Thursday, August 24, 2000 4:24 AM To: DB2-L@RYCI.COM Subject: [DB2-L] Recovering a DB2 Volume [...] 15597 25 18_DB2 for Windows NT13_Skelton Brian20_skelton.b@MELLON.COM31_Thu, 24 Aug 2000 06:23:35 -0400382_- I have just recently had DB2 for Windows for NT client software installed and I am having problems finding my way around the Command Centre, Command Line Processor and the Command Window.

I have looked in the archives and the IBM site but I couldn't find anything. I was wondering if anyone could point me in the direction of a site that would give me some more info. [...] 15623 63 22_Re: DB2 for Windows NT8_sncmonty18_sncmonty@YAHOO.COM31_Thu, 24 Aug 2000 04:25:44 -0700343_us-ascii Hi Brian,

If you installed Db2 properly, there is an online book information.

You get there by going to Start ->program ->Db2 for NT -> Information -> Db2 online books

In the search, if you type in Command Line Processor or command center, you'll get the information you need.

I hope this is helpful. [...] 15687 56 22_Re: DB2 for Windows NT23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 24 Aug 2000 12:31:53 +0100415_iso-8859-1 why not get a copy of a book called "DB2 NT FAST" .. go to Amazon.com

I must admit .. it is very easy to use though.

Go into the command centre and issue "db2 ?" and you will get all the help you need.

Les

-----Original Message----- From: Skelton Brian [mailto:skelton.b@MELLON.COM] Sent: Thursday, August 24, 2000 11:24 AM To: DB2-L@RYCI.COM Subject: DB2 for Windows NT [...] 15744 30 5_ODBC?0_19_mike.holmans@BT.COM31_Thu, 24 Aug 2000 13:56:17 +0100269_- I've just had a developer ask me if he can connect to an OS/390 DB2 from an NT4 box and use ODBC calls to access the data.

I've told him "yes".

Thing is, I'm not sure what we have to do to enable it, and I haven't got much time to do the research. [...] 15775 23 23_Recovering a DB2 Volume14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 24 Aug 2000 08:59:24 -0400319_- Thanks for all the responses. I am going with the LISTC approach for now, with some code to parse it out to a nice report. The Catalog Search Interface looks interesting, it's going to in handy. Dean

Dean Montevago MVS Systems Programming Visiting Nurses Service of NY (212) 290-0543 (212) 290-4777 - Fax [...] 15799 21 9_Re: ODBC?14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 24 Aug 2000 15:03:59 +0100472_us-ascii We installed CAE 5.2 on a NT workstation, we customized ODBC driver and we access to S/390 via

Microsoft ACCESS 97. That's all. Of course TCP/IP and DDF were already customized.



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. 15821 17 27_Re: Recovering a DB2 Volume14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 24 Aug 2000 15:05:10 +0100362_us-ascii There's NAVIQUEST to format DASD reports. Ask to your DASD admin, if you have SMS.

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. 15839 48 71_How to pass RESOLVER_CONFIG to DDF in multiple TCP/IP stack environment6_R. Lee15_rlee@BIZERS.COM31_Thu, 24 Aug 2000 07:39:58 -0500611_- Hi,

I'm setting up DDF (DB2 v6 OS/390) in a multiple TCP/IP stacks (OS/390 v2.9) environment. But I need to bind the DDF only to a specific stack with a specific resolver configuration. Is there any way to do that..? Any suggestions is very much appreciated... thanks..

Additional information: ======================

We have 2 TCP/IP stacks, TCPA (default) and TCPB, with its own resolver config (in an mvs seq dataset), each having different name server list. The name servers for TCPA do not have any entry for the ip address of TCPB, and vice versa. There also exist the hfs file [...] 15888 45 9_Re: ODBC?14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 24 Aug 2000 09:08:59 -0400513_- You need DB2 Connect and you need to configure DDF

> -----Original Message----- > From: mike.holmans@BT.COM [SMTP:mike.holmans@BT.COM] > Sent: Thursday, August 24, 2000 8:56 AM > To: DB2-L@RYCI.COM > Subject: ODBC? > > I've just had a developer ask me if he can connect to an OS/390 DB2 from > an > NT4 box and use ODBC calls to access the data. > > I've told him "yes". > > Thing is, I'm not sure what we have to do to enable it, and I haven't got > much time to do the research. > > The NT box is [...] 15934 41 9_Re: ODBC?0_19_mike.holmans@BT.COM31_Thu, 24 Aug 2000 14:09:35 +0100617_- Does it only work over TCP/IP? Can we go via SNA at all?

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: Massimo Scarpa [SMTP:Massimo_Scarpa@DEBIS.IT] > Sent: Thursday, August 24, 2000 3:04 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] ODBC? > > We installed CAE 5.2 on a NT workstation, we customized ODBC driver and we > access to S/390 via > > Microsoft ACCESS 97. That's all. Of course TCP/IP and DDF were already > customized. > [...] 15976 54 27_Re: Recovering a DB2 Volume15_Lankester, Andy22_Andy_Lankester@BMC.COM31_Thu, 24 Aug 2000 08:27:52 -0500355_iso-8859-1 Are you sure that this will find secondary extents of objects whose primaries are on other volumes? This is non-trivial. However recovering just those objects catalogued to the volume and then doing individual recoveries each time a subsequent missing extent gives a -904 or whatever maybe be acceptable for low availability applications. [...] 16031 17 9_Re: ODBC?14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 24 Aug 2000 15:17:16 +0100377_us-ascii You ask for the simplest method :-))) !!

But if I remember well you can, but I never used it.

Regards 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. 16049 49 44_Design of allowed value tables (Code tables)0_25_George_White@VANGUARD.COM31_Thu, 24 Aug 2000 09:32:34 -0400421_us-ascii Hi,

I would like some input regarding a design we are looking at implementing here for our allowed value tables.

Basically, the single code table will consist of an identifier that describes the referential constraint type (state, fee type, customer type, etc.) as well as all the values for those distinct constraint types. There is also a code table t used to validate the constraint types. [...] 16099 50 9_Re: ODBC?12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Thu, 24 Aug 2000 09:41:03 -0400439_iso-8859-1 Mike,

The Client Configuration Assistant (CCA) can be used to register the ODBC Data Sources.

Nadir



-----Original Message----- From: mike.holmans@BT.COM [mailto:mike.holmans@BT.COM] Sent: Thursday, August 24, 2000 8:56 AM To: DB2-L@RYCI.COM Subject: ODBC?



I've just had a developer ask me if he can connect to an OS/390 DB2 from an NT4 box and use ODBC calls to access the data. [...] 16150 65 9_Re: ODBC?12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 24 Aug 2000 06:51:02 -0700561_us-ascii DB2 Connect (CAE) will go over SNA but do you really want to go there. TCP/IP is much much faster, easier to setup, configure and use. --- mike.holmans@BT.COM wrote: > Does it only work over TCP/IP? Can we go via SNA at > all? > > 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: Massimo Scarpa > [SMTP:Massimo_Scarpa@DEBIS.IT] > > Sent: Thursday, August 24, 2000 3:04 PM > [...] 16216 17 9_Re: ODBC?14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 24 Aug 2000 09:49:54 -0400427_us-ascii Mike, you can use SNA but you need an SNA stack, like IBM Comm Server or MS SNA Server on the DB2 Connect Gateway server. Else you can get DB2 Connect Personal Editon which has an integrated SNA stack and is used for individual access directly from the workstation. Of course, VTAM needs to be configured along with DDF. See the DB2 Connect PE or EE Quick Beginnings for NT at www.software.ibm.com/data/db2. Phil [...] 16234 89 9_Re: ODBC?0_19_mike.holmans@BT.COM31_Thu, 24 Aug 2000 14:54:03 +0100350_- It may be easier to set up, configure, and use, but first I have to convince people that it is all right for DDF to be a superuser, and get them to set up the TCPIP stuff on the OS/390 box - and that's going to take time. That's why I was talking about the short-term, to get something going before we get to do something which is worthwhile. [...] 16324 80 48_Re: Design of allowed value tables (Code tables)19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 24 Aug 2000 09:02:39 -0500641_iso-8859-1 Hi George, You didn't mention your DB2 Version but have you considered column constraints?

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 [...] 16405 77 22_Re: DB2 for Windows NT13_Skelton Brian20_skelton.b@MELLON.COM31_Thu, 24 Aug 2000 10:11:25 -0400573_- Thanks for all the replies you were right it is quite straight forward. The only thing I can't work out how to load scripts from disk and save them in the command center.

Hope someone can help.

Brian

> -----Original Message----- > From: Pendlebury-Bowe, Leslie [SMTP:Leslie.Pendlebury-Bowe@EU.SONY.COM] > Sent: Thursday 24 August 2000 12:32 > To: DB2-L@RYCI.COM > Subject: Re: DB2 for Windows NT > > why not get a copy of a book called "DB2 NT FAST" .. go to Amazon.com > > I must admit .. it is very easy to use though. > > Go into the command [...] 16483 94 35_Re: Bufferpool performance question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Thu, 24 Aug 2000 07:18:47 -0700472_iso-8859-1 DB2 V5 OS/390 DB2 Omegamon, Accounting BufferPool Activity grouped by planname, all values not included in the original email were zeros, report does not include LP I/Os or SP I/Os. We do not use Raid or SMS. I/O Wait Time and Read Request information came from Omegamon reports Accounting Summary and Accounting Time Summary. Regularly visit the website; read, printed and reread the white papers; still have questions that can only be asked of the list. [...] 16578 122 48_Re: Design of allowed value tables (Code tables)0_18_damcon2@US.IBM.COM31_Thu, 24 Aug 2000 10:22:19 -0400578_us-ascii George,

Depending on version and platform, triggers are another option.

Cheers, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 801-7303, Tie Line 8-427-7303 ----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - BMW -----------------------------------------------------



"DAVIS, RICK (SBCSI)" @RYCI.COM> on 08/24/2000 10:02:39 AM

Please respond to DB2 Data Base Discussion List [...] 16701 107 9_Re: ODBC?14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 24 Aug 2000 10:25:51 -0400527_- You don't have IP configured on OS/390 ? You can also use VTAM to do the DDF piece.

> -----Original Message----- > From: mike.holmans@BT.COM [SMTP:mike.holmans@BT.COM] > Sent: Thursday, August 24, 2000 9:54 AM > To: DB2-L@RYCI.COM > Subject: Re: ODBC? > > It may be easier to set up, configure, and use, but first I have to > convince > people that it is all right for DDF to be a superuser, and get them to set > up the TCPIP stuff on the OS/390 box - and that's going to take time. > That's > why I was talking [...] 16809 86 35_Re: Bufferpool performance question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Thu, 24 Aug 2000 07:31:26 -0700437_iso-8859-1 I should have been more clear. The bufferpool information is for one pool only, 6 were used during the run of the program. The numbers were for the one that had the worst performance. It is used for three of our larger tables only. The Getpage Requests and I/O Wait Time used to calculate Average I/O elapsed time was from summary information that was for the entire run of the program. All numbers reported by planname. [...] 16896 51 79_What platform / DB2 / tools would you prefer to use for a >5 Tb D atawarehouse.15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 24 Aug 2000 16:37:03 +0200547_iso-8859-1 Hello all,

I would like some input on this question. In a project in my shop we'll redo a datawarehouse. I would like to know what you consider to be the best paltform and why, what DBMS would you prefer and why (DB2 on Os/390, DB2 UDB EE or DB2 UDB EEE or..?). What kind of tools are there available for moving data, extracting etc. We will have an ODS on OS/390 and Datamarts on a variety of platforms; Sybase, Windows NT, Tandem Non Stop SQL, OS/390, AIX, Access etc.We expect the datawarehouse to be at least > 5Tb. All [...] 16948 128 9_Re: ODBC?12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 24 Aug 2000 08:00:05 -0700520_us-ascii If you don't have DDF setup already, then to use DDF with either TCPIP or SNA, you've got a bit of effort and that is not the quicky short-term that you're looking for. If I remember correctly and its been a while since I looked at Centura, I seem to remember that it also has a way to allow ODBC calls to be issued . You might check it out. Its certainly not the best solution, but might be the quickest. --- mike.holmans@BT.COM wrote: > It may be easier to set up, configure, and use, but > first I have [...] 17077 134 9_Re: ODBC?0_19_mike.holmans@BT.COM31_Thu, 24 Aug 2000 15:39:00 +0100294_iso-8859-1 No. And it's not even a runner on the target machines at the moment, because they are still on OS/390 1.2. I'm working on getting it configured on the test machine I'm working with for something else, which is at OS/390 2.8, but that won't help my users in the very short term. [...] 17212 151 9_Re: ODBC?0_19_mike.holmans@BT.COM31_Thu, 24 Aug 2000 15:45:27 +0100278_iso-8859-1 We have DDF set up, because we use it to connect OS/390 DB2 subsystems. It's how to establish the connection from the NT box which is a bit of a mystery. The various bits of advice which are pouring in are most helpful, so thanks to everyone for the assistance. [...] 17364 26 35_Re: Bufferpool performance question14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Thu, 24 Aug 2000 10:50:13 -0400404_ISO-8859-1 Sandi, If you help with your performance question, you need to provide the complete set of performance data. Including I/Os. Unfortunately the accounting data does not provide this. Since I/Os are not shown here, where di you get the number of LP I/Os you used to calculate an I/O elapsed time? You need the System Statistics Buffer Pool information for the timeframe when your job runs. [...] 17391 20 83_Re: What platform / DB2 / tools would you prefer to use for a >5 Tb D atawarehouse.0_29_paul.packham@POSTOFFICE.CO.UK31_Thu, 24 Aug 2000 15:55:27 +0000540_us-ascii Jaap,

There is a excellent Redbook just published on this topic which covers DB2 on S/390 called "Business Intelligence Architecture on S/390 Presentation Guide". Ref SG24-5641-00. This can be viewed online at http://www.redbooks.ibm.com/abstracts/sg245641.html

Regards, Paul

================================================ 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. 17412 50 9_Re: ODBC?12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Thu, 24 Aug 2000 10:59:15 -0400479_us-ascii We went the SNA approach initially because of versions, hardware etc but moved over to TCP/IP as soon as was possible.

I know it's just for testing but ask your developers to keep their retrieved answer set sizes to a minimum (always a good idea anyway). As SNA sends data in frames, it will work OK for small answer sets but will 'dog' on larger ones. As (I assume) your SNA network is shared with everyone, large data packet traffic could impact everyone. [...] 17463 90 27_Re: Recovering a DB2 Volume23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 24 Aug 2000 10:59:37 -0400536_- I would say, Use IDCAMS to list all the entry of the MVS user catalog where your DB2 objects are cataloged. Make sure you only list the dataset name and all the volumes they are on. Don't try to list the allocation information because that is stored in the VTOC. Then search the job output for the vol ser, that was deleted, this should give you all the datasets whose primary/secondary extents were on the deleted volume. Ask you MVS or DASD admin to provide or run a IDCAMS job for you. I have done this several years ago when [...] 17554 22 15_Authid question18_Erringer, Keith M.24_Keith.Erringer@ALCOA.COM31_Thu, 24 Aug 2000 10:57:13 -0400451_- We are using DB2V5. We are also using DB2 for security. We are using TMON for DB2 reports to monitor DML execution. The report shows TABLE, DATABASE, PLAN, STMT TYPE, and AUTHID. For the most part the AUTHID is the USERID associated with the activity. There is some activity which shows SYSOPR as the AUTHID and no plan name. The STMT TYPE is UPDATE, DELETE, and INSERT on various tables. Can anyone tell me how SYSOPR is becoming the AUTHID ? [...] 17577 57 28_Re: Cross LPAR communication11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Thu, 24 Aug 2000 09:21:59 -0500337_- Looks like it may be a VTAM problem from the DB2 reason code. I would open a ticket with IBM on this one and see what they can do.

Tony Clark DB2 System Administrator Texas Workforce Commission 15th Congress Ave ADP Room 320 Austin, Texas 78778-0001 E-Mail: tclark@twc.state.tx.us Phone: (512) 463-3079 Fax: (512) 936-3190 [...] 17635 44 19_Re: Authid question12_Nadir Doctor24_Nadir.Doctor@BGEHOME.COM31_Thu, 24 Aug 2000 11:19:56 -0400680_iso-8859-1 Keith,

SYSOPR is the default installation authid for the SYSOPR privilege as specified in the ZPARM - My guess is that TMON or some other process is using this.

Hope this helps.

Nadir

-----Original Message----- From: Erringer, Keith M. [mailto:Keith.Erringer@ALCOA.COM] Sent: Thursday, August 24, 2000 10:57 AM To: DB2-L@RYCI.COM Subject: Authid question



We are using DB2V5. We are also using DB2 for security. We are using TMON for DB2 reports to monitor DML execution. The report shows TABLE, DATABASE, PLAN, STMT TYPE, and AUTHID. For the most part the AUTHID is the USERID associated with the activity. There is some [...] 17680 97 28_Re: Cross LPAR communication15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Thu, 24 Aug 2000 17:17:53 +0200567_iso-8859-1 Seems like CNOS problem to me. Is the Lu LUDB2Q activated on the other Lpar?

Jaap Slot DB2 DBA Rabofacet BV Office 0031 (0)30 215 2220 Mobile 0031 (0)6 5374 0167

Reserve your AGENDA for next DB2 Users Group Conference IDUG Geneva - 23/26 October 2000 -









-----Oorspronkelijk bericht----- Van: Clark, Tony [mailto:Tony.Clark@TWC.STATE.TX.US] Verzonden: donderdag 24 augustus 2000 16:22 Aan: DB2-L@RYCI.COM Onderwerp: Re: Cross LPAR communication [...] 17778 47 39_UDB V6.1 for AIX Control Centre problem8_Tam Kyle25_tam_kyle@STANDARDLIFE.COM31_Thu, 24 Aug 2000 17:22:44 +0100602_iso-8859-1 Howdi folks, wonder if anyone can shed some light on the following:

UDB personal edition V6, installed on my local machine, an NT V4 workstation. UDB EE V6 for AIX installed on 4 remote nodes.

I'm trying to use my local UDB instance to fully administer the remote ones. I've configured instances and I can connect (eventually), view objects and make changes. However: when I try to run the performance monitors I get an initial timeout (30 seconds) and then a message telling me that the db2admin server is not active (after 45 seconds - SQL4414N, SQLSTATE 08001). I know [...] 17826 38 50_Re: Converting Peoplesoft paycalc to parallel jobs0_39_brian_holroyd.consultant@PEOPLESOFT.COM31_Thu, 24 Aug 2000 09:34:15 -0700582_us-ascii Mike, Mark

That must be my cue to jump in here :)

Payroll runs best in parallel when you can set up your run cntls to process companies concurently, or process paygroups within companies concurrently. You can probably get away with little contention if you set all updated tables to row level locking. The only contention you may hit is with SQL that chooses to do a TS scan thru the table and hit X locks, (usually caused by correlated subqueries, although I haven't seen any of these in Payroll 7.5 and below). A better solution from a performance and [...] 17865 38 48_Re: Design of allowed value tables (Code tables)13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Thu, 24 Aug 2000 12:19:29 -0500302_- I was thinking about going star schema all the way through.

All Varchars would be banished off to separate string tables (by general length, to aid in page packing) and the data tables would have very small fixed length records of about a dozen integer foreign keys to the string tables. [...] 17904 14 20_DB2 Store Procedures17_Edward G. La Touf17_elatouf@YAHOO.COM31_Thu, 24 Aug 2000 12:31:23 -0500352_- When calling a stored procedure from client program written in COBOL, I have read that If you know the know the number of returned sets you can set your logic in a certain way. My question is, how would you know how many sets have been returned. Maybe I am reading the information incorrectly. Can someone explain this part of stored db2 procs? [...] 17919 116 27_Re: Recovering a DB2 Volume14_Patriquin, Tim21_Tim_Patriquin@BMC.COM31_Thu, 24 Aug 2000 13:51:12 -0500505_iso-8859-1 Sanjay,

SVC 26 will return extent information in the ENTVOLS field (defined in the catalog dictionary) returned from a catalog request. I've always used the undocumented SVC 26 interface directly to get this information, but I would assume IBM allows the information to be retrieved through their catalog interface utility as well. But you must go after the data & index components directly; no information is stored at the cluster component level in regards to extent information. [...] 18036 16 31_Who issued the command - DB2 V50_16_HesterRC@AOL.COM29_Thu, 24 Aug 2000 14:51:37 EDT430_ISO-8859-1 Is there any way to determine who issued a start or stop database command on DB2 for OS/390 V5? example: -STA DB(DB1234) SPACE(SP00001) ACCESS(RO) -STO DB(DB1234) SPACE(SP00001)

================================================ 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. 18053 74 27_Re: Recovering a DB2 Volume14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Thu, 24 Aug 2000 13:58:03 -0500304_iso-8859-1 The listcat will show all volumes the dsn is eligible to allocate to, whether or not the secondary has allocated to all the volumes. You have not indicated whether the volume is SMS managed. I am making the assumption the catalog the dsns are in was not on the volume you are rebuilding. [...] 18128 67 25_Partitioning Large Tables11_James Drewe20_James.Drewe@AEXP.COM31_Thu, 24 Aug 2000 12:05:31 -0700478_us-ascii Craig

I have partitioned tablespaces with requirements similar to what you described (heavy insert and select activity). My partitioning scheme was similar to what Susan Lawson described. It is based on the days of the month (i.e., 1 - 31) and timestamp. So depending on the day of the month, it is inserted into that particular partition (or on our very biggest ones, group of eight partitions for each "day"). Read activity is handled usually by the NPI. [...] 18196 23 18_Archive Log Issues16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 24 Aug 2000 15:14:50 -0400521_iso-8859-1 Hey Folks... We want to move our archive logs from tape to disk. We're concerned as to how we can remove the data set from disk after, say, 30 day's. We were able to use the retpd parm to manage the tapes. My question is, how do you manage archive logs created on disk? Also, does the retpd set in DSN6ARVP have to coincide with maxarch in DSN6LOGP.. That seems like apples & oranges to me. I want to make sure that we keep enough archive log entries in the BSDS, but still be able to use them from disk. [...] 18220 38 35_Re: Who issued the command - DB2 V511_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 24 Aug 2000 14:12:44 -0500445_us-ascii One way is to start a trace in advance of the command as follows: -START TRACE(P) CLASS(30) IFCID(90) DEST(SMF) AUTHID(*) PLAN(*)





From: HesterRC@AOL.COM@RYCI.COM> on 08/24/2000 01:51 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject: Who issued the command - DB2 V5 [...] 18259 97 24_Re: DB2 Store Procedures15_Johnson, Steven23_X2SJOHNS@SOUTHERNCO.COM31_Thu, 24 Aug 2000 14:20:41 -0500508_- Edward, Starting in DB2 V 5 there are some added functions to know how many results sets have been passed back from the SP. The RED book is very helpful with describing how this works. -- The DESCRIBE PROCEDURE statement gets information about the result sets returned by a stored procedure. The information, such as the number of result sets, is put into a descriptor. This statement was added with DB2 V5. EXEC SQL DESCRIBE PROCEDURE :STOREPROC INTO :SQLDA END-EXEC. IF SQLCODE > 0 PERFORM DBERROR. [...] 18357 40 22_Re: Archive Log Issues14_Dean Montevago18_DMonteva@VNSNY.ORG31_Thu, 24 Aug 2000 15:21:19 -0400541_- You can setup a management class in SMS, if you are using it. Also, you can archive them to tape with HSM or DMS and expire them from there.

> -----Original Message----- > From: Dempsey, Michael [SMTP:MDempse@UNCH.UNC.EDU] > Sent: Thursday, August 24, 2000 3:15 PM > To: DB2-L@RYCI.COM > Subject: Archive Log Issues > > Hey Folks... > We want to move our archive logs from tape to disk. We're concerned > as > to how we can remove the data set from disk after, say, 30 day's. We were > able to use the retpd parm to manage the [...] 18398 18 14_SPUFI Question12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Thu, 24 Aug 2000 14:40:25 -0500448_iso-8859-1 TO answer my own question about SPUFI. There is a required SPE level code support for the lower version to coexist with the higher. In my case it was not applied.

Gerald Hodge 281-265-3004

================================================ 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. 18417 38 26_More Archive Log Questions16_Dempsey, Michael20_MDempse@UNCH.UNC.EDU31_Thu, 24 Aug 2000 16:15:56 -0400545_iso-8859-1 Hey Folks.. Two part question....

We've changed our Archive Log output to DASD rather then tape. We noticed that when we forced an archive, that it created the following:

db22vsam.archlog1.d00237.t1537461.a0000782 db22vsam.archlog1.d00237.t1537461.b0000782

and

db22vsam.archlog2.d00237.t1537461.a0000782 db22vsam.archlog2.d00237.t1537461.b0000782

The "a" data set's are the amount of space defined in PRIQTY, but the "b" data set's are only 1 cyl. My question is , what are the "b" data set's? [...] 18456 159 27_Re: Recovering a DB2 Volume23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 24 Aug 2000 16:21:54 -0400340_iso-8859-1 Tim,

I have not used SVC 26, but it seems the source of information remains the same. i.e. ICF User catalog. You are right, the volume information can only be found against the data component (LDS) as cluster is merely an associative entry. However if you list cluster, it would give you data component info as well. [...] 18616 28 27_Reorg using Shrlevel Change13_Moss, William15_MossW@AETNA.COM31_Thu, 24 Aug 2000 16:28:24 -0400494_- My environment is DB2 V5.1, OS/390 2.8, and data sharing.

I have been testing online reorg with shrlevel change with a disorganized table (67% cluster ratio) and 7.4 million rows. The reorg runs for 66 minutes with the reload phase running for 60 minutes. Omegamon shows 48 minutes of wait for synchronous I/O during the reload phase. Does any one know what is causing all of this wait for I/O ? Is it the mapping table ? There is no activity against this table during the reorg. [...] 18645 63 30_Re: More Archive Log Questions11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Thu, 24 Aug 2000 15:30:48 -0500468_us-ascii what are the "b" data set's? That is a copy of the Bootstrap dataset... : )







From: "Dempsey, Michael" @RYCI.COM> on 08/24/2000 03:15 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc: Fax to: Subject: More Archive Log Questions



Hey Folks.. Two part question.... [...] 18709 58 31_Re: Reorg using Shrlevel Change11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM31_Thu, 24 Aug 2000 15:33:06 -0500500_us-ascii One guess. Do a -dis util(*) on it while it is doing the waiting. See if it is doing log apply. If so, it also gives you counts as to how much it has to do. Also, if it is in switch phase. We have a lot of multi-table tablespace. Each index has a physical file. So switch might be re-naming 100+ datasets TWICE. You can go to ispf 3.4 and watch the shadow dataset slowly go away and the temporary one's appear. then also go away while the rename to the online name occurs. Sort of fun. [...] 18768 251 30_Re: More Archive Log Questions13_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Thu, 24 Aug 2000 15:42:45 -0500782_US-ASCII Hello Michael,

The B* datasets are copies of your BSDS

Here is a listcat from our shop

LISTC ENT('DB2P.ARCHLOG1.A0002864') ALL NONVSAM ------- DSN3220.ARCHLOG1.A0002864 IN-CAT --- CATALOG.DB2P.VDB1B70 HISTORY DATASET-OWNER-----(NULL) CREATION--------2000.237 RELEASE----------------2 EXPIRATION------0000.000 ACCOUNT-INFO-----------------------------------(NULL) SMSDATA STORAGECLASS -----ARCLOG MANAGEMENTCLASS----DBLOG DATACLASS -------ARCLOG1 LBACKUP ---0000.000.0000 VOLUMES VOLSER------------DB0890 DEVTYPE------X'3010200F' FSEQN------------------0 ASSOCIATIONS--------(NULL) ATTRIBUTES

The creation is today and expiration is 0000.000. The datasets are managed by SMS and are deleted when the managementclass DBLOG expires in 7 days. [...] 19020 26 22_WLM and DB2 V6 Refresh11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 24 Aug 2000 15:46:04 CDT338_- We are a DB2 for OS/390 V5 shop, in the process of implementing V6 (May Refresh). It is my understanding that without WLM SPA's we will not be able to use external UDF's, SQL Procedures, or Stored Porcedures that access non-DB2 resources. Can someone verify this is accurate? Is there a complete list of features that require WLM? [...] 19047 48 26_Re: WLM and DB2 V6 Refresh20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 24 Aug 2000 16:50:43 -0400499_us-ascii Suresh

You are right. External UDF, SQL Procedures and Stored procedures, those need two phase commit need WLM. For two-phase commit on other non-DB2 resources, you may have to define resource manager in RRS. If you need to run utilities from Stored procedure then also you need WLM.

-Venkat Pillay

-----Original Message----- From: Suresh Sane [SMTP:data_arch@HOTMAIL.COM] Sent: Thursday, August 24, 2000 4:46 PM To: DB2-L@RYCI.COM Subject: WLM and DB2 V6 Refresh [...] 19096 28 41_SQL Server to DB2 UDB (Stored Procedures)19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Thu, 24 Aug 2000 14:10:13 -0700535_- Our DBA group has been asked by one of the application areas we support what the effort would be to convert a purchased application from SQL Server to DB2 UDB. There are apparently a number of stored procedures used in the product, although the application itself uses ODBC calls.

We don't have any experience with stored procedures yet, but from what I've seen posted on the list and elsewhere this seems to be a non-trivial task - especially for a purchased package where we would have to deal with vendor maintenance. [...] 19125 88 30_Re: More Archive Log Questions13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Thu, 24 Aug 2000 16:16:56 -0500624_iso-8859-1 Michael,

The 'b' dsn is a copy of your bsds corresponding to the log ('a') dsn. It is vital for recovery scenarios.

Check out the Installation Guide regarding arcretn, and the Admin guide for 'archive log retention':

".....The default for the retention period keeps archive logs forever. If you use any other retention period, it must be long enough to contain as many recovery cycles as you plan for. For example, if your operating procedures call for a full image copy every sixty days of the least-frequently-copied table space, and you want to keep two complete image copy cycles on [...] 19214 63 45_Re: SQL Server to DB2 UDB (Stored Procedures)23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Thu, 24 Aug 2000 17:25:43 -0400632_- Tim,

IBM has a free tool for converting SQL Server Stored Procedures to DB2 SP. Check out http://www-4.ibm.com/software/data/db2/

HTH

Sanjay Jain



> -----Original Message----- > From: Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] > Sent: Thursday, August 24, 2000 5:10 PM > To: DB2-L@RYCI.COM > Subject: SQL Server to DB2 UDB (Stored Procedures) > > Our DBA group has been asked by one of the application areas we support > what > the effort would be to convert a purchased application from SQL Server to > DB2 UDB. There are apparently a number of stored procedures used in the > product, [...] 19278 29 27_ROWID datatype in OS/390 V611_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 24 Aug 2000 16:52:44 CDT375_- We are DB2 os/390 V5, soon to be V6 (May Refresh).

A couple of questions regarding the ROWID:

1. I have read conflicting opinions as to whether or not this changes after a reorg. Gabrielle says it does change, I recall IDUG presentations that also said so while the IBM manuals now appear to say it does not change after a reorg. What is the real scoop? [...] 19308 82 45_Re: SQL Server to DB2 UDB (Stored Procedures)19_Ohling, Tim R - CNF18_Ohling.Tim@CNF.COM31_Thu, 24 Aug 2000 15:33:06 -0700618_- Thanks!

Tim

> -----Original Message----- > From: Jain, Sanjay (Exchange) [SMTP:sanjayjain@BEAR.COM] > Sent: Thursday, August 24, 2000 2:26 PM > To: DB2-L@RYCI.COM > Subject: Re: SQL Server to DB2 UDB (Stored Procedures) > > Tim, > > IBM has a free tool for converting SQL Server Stored Procedures to DB2 SP. > Check out http://www-4.ibm.com/software/data/db2/ > > HTH > > Sanjay Jain > > > > -----Original Message----- > > From: Ohling, Tim R - CNF [SMTP:Ohling.Tim@CNF.COM] > > Sent: Thursday, August 24, 2000 5:10 PM > > To: DB2-L@RYCI.COM > > Subject: SQL Server to DB2 UDB (Stored Procedures) [...] 19391 28 41_Re: Strobe Analysis shows lots of Commonx15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Thu, 24 Aug 2000 19:33:04 -0500353_us-ascii Robinson, Peter [IBM GSA] wrote: > > Hi Brian > > Jim's description reminds me of something we found a while back - I don't > recall exactly what was in our strobe results. We found that the mvs > overheads involved in managing external data with COBOL were large. Have a > look and see how much you use externals for passing data around. [...] 19420 28 24_Repost: Plans-2-Packages19_Freeling, Marv, ITD25_mfreelin@CO.ALAMEDA.CA.US31_Thu, 24 Aug 2000 17:50:04 -0700419_iso-8859-1 We have on our plate a plan to packages conversion. We have not yet assembled a plan to tackle this conversion, but I understand from the last IDUG that there was a redbook published on that topic many years ago, and it's currently out of print. We've been trying to locate a copy. Does anyone, perchance, have a copy they might be willing to lend us for just a little while? We promise to return it... [...] 19449 84 31_Re: ROWID datatype in OS/390 V614_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 25 Aug 2000 11:57:17 +1000384_iso-8859-1 There are actually: - a "stored_rowid", what is actually stored in the row - created when the row is inserted. Does not change with a reorg; and - a "select_rowid", what is returned to an application program. It is made up of the stored_rowid concatenated with the RID of the row. As the RID changes with a reorg, the select_rowid will also change. [...] 19534 48 21_Re: STOSPACE Question14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Fri, 25 Aug 2000 12:10:39 +1000626_iso-8859-1 The optimiser doesn't use them, they're just for catalog query purposes.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au -----Original Message----- From: Keith Kuhn [mailto:Keith_Kuhn@WENDYS.COM] Sent: Thursday, August 24, 2000 4:08 AM To: DB2-L@RYCI.COM Subject: [DB2-L] STOSPACE Question



Question regarding the STOSPACE utility. I understand that it updates the catalog with DASD usage statistics. Are these statistics used by the DB2 optimizer, or are the statistics simply used for catalog query and reporting? [...] 19583 164 31_Re: table expressions and union16_Stephen R. Young17_srycpa@SWBELL.NET31_Thu, 24 Aug 2000 21:30:06 -0500530_- Hey guys you got me on the wrong distribution list. Please take me off

srycpa@swbell.net

thanks

-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [SMTP:db46@DAIMLERCHRYSLER.COM] Sent: Wednesday, August 23, 2000 1:34 PM To: DB2-L@RYCI.COM Subject: Re: table expressions and union

Union are not allowed in subquery's or nested tables (basically the same thing).

Dean









Randall Barbour @RYCI.COM> on 08/23/2000 01:57:36 PM [...] 19748 14 44_Re: Any DB2 Maintenance required for SHARK ?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 24 Aug 2000 23:51:53 -0500498_- I don't know of any, unless you are asking about taking advantage of the ability to suspend and resume the log. I hope everyone moving to V6 gets to at least the level noted in APAR II12343, which includes that change.

Roger Miller, DB2 for OS/390

================================================ 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. 19763 94 30_Re: More Archive Log Questions23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 25 Aug 2000 06:15:58 +0100288_iso-8859-1 which I do belive gets sized the same size as your archive log when created then releases the storage down to about 1 cylinder. I asked here on the list and with IBM about how they size the bsds copy that goes with the archlog .. but as yet not answer .. (12 months ago). [...] 19858 42 49_Re: Is it true comment? OS/390 V5 to V7 migrate??12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 25 Aug 2000 00:19:20 -0500444_- The first question is your objective. I think the ability to skip from Version 5 to Version 7 will be a big help for customers who are running Version 3 or 4 today or have just migrated to Version 5. They can migrate to Version 5, and then skip Version 6. If you are running Version 5 today and thinking of migrating in the next year, then you should probably move to V6. You probably won't see any early customers moving from V5 to V7. [...] 19901 157 9_Re: ODBC?12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 25 Aug 2000 09:32:06 +0200302_x-user-defined Hi, If you have a USS LPAR then you can do it through it w/o DB2 CONNECT, you need just DDF. We give browser access that way (IE5), the URL points to the CGI on the USS. The CGI is REXX (!!!) calling DB2 and doing the HTML stuff. Response time elapsed is 1-2 sec including display. [...] 20059 18 44_Pamela Harris/IT/SEARS is out of the office.0_17_pharri1@SEARS.COM31_Fri, 25 Aug 2000 01:40:58 -0500537_us-ascii I will be out of the office from 08/24/2000 until 08/28/2000.

If you need assistance with DB2, please use the primary DB2 pager, for informix use the primary informix pager, for network issues please call Bill Pugh, PIN # 7270063.

DB2 pin # 7270526, Informix pin # 7270525

================================================ 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. 20078 59 45_Re: SQL Server to DB2 UDB (Stored Procedures)20_Pav Kumar-Chatterjee17_pavkc@HOTMAIL.COM29_Fri, 25 Aug 2000 07:41:06 GMT391_- Tim

I tried using the free stored procedure converter and gave up in the end!! It just didn't work - the product said that the stored procedures had been converted successfully, but the results set was empty. In the end we decided to rewrite the procedures by hand (luckily we only had a few to do) - obviously if you have a lot to do, then this will not be an option for you. [...] 20138 141 31_Re: Reorg using Shrlevel Change0_18_mebert@AMADEUS.NET31_Fri, 25 Aug 2000 09:44:09 +0200382_us-ascii Wrong. It was stated that the problem was in the RELOAD phase, and that there was no other tablespace activity. It's the building of the mapping table index. See my email dated 18.8.00, "Re: DB2 v5.1 Reorg shrlevel change on a single partition of a 10 partition table", and many other postings re OLR. I sometimes wish people would READ their emails... [...] 20280 21 20_DB2 Release Strategy0_29_paul.packham@POSTOFFICE.CO.UK31_Fri, 25 Aug 2000 10:13:29 +0000344_us-ascii Hi,

I am trying to complete a maintenance strategy for DB2 service & upgrades. I seem to remember hearing that the future release strategy from IBM was that a new release of DB2 would be available every year with a refresh being made available in between.

Can anyone confirm this for me or have I finally lost it !! [...] 20302 56 24_Re: DB2 Release Strategy23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Fri, 25 Aug 2000 10:20:23 +0100656_iso-8859-1 Paul

for what it is worth I remember the same thing being mentioned here some time back.

Maybe Roger might like to comment?

Les





-----Original Message----- From: paul.packham@POSTOFFICE.CO.UK [mailto:paul.packham@POSTOFFICE.CO.UK] Sent: Friday, August 25, 2000 11:13 AM To: DB2-L@RYCI.COM Subject: DB2 Release Strategy



Hi,

I am trying to complete a maintenance strategy for DB2 service & upgrades. I seem to remember hearing that the future release strategy from IBM was that a new release of DB2 would be available every year with a refresh being made available in between. [...] 20359 35 39_Emulating recursive SQL on DB2 OS390 V60_19_Sven.Heidorn@CSN.SE31_Fri, 25 Aug 2000 12:01:24 +0200379_ISO-8859-1 Hi all,

can anybody give me a hint on how to emulate recursive SQL on DB2 OS390. I need to convert the following SQL;

WITH TEMP (DAT, LVL) AS ( SELECT CURRENT DATE, 1 FROM SYSIBM.SYSDUMMY1 UNION ALL SELECT CASE WHEN DAYOFWEEK(DAT + 1 DAY) = 7 THEN DATE(DAT) + 3 DAYS ELSE DATE(DAT) + 1 DAY END, LVL + 1 FROM TEMP WHERE LVL < 10) SELECT * FROM TEMP; [...] 20395 37 91_IMAGE COPY UTILITY - Determining number of copied pages per table space (DB2 for OS/390 V5)12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 25 Aug 2000 13:00:42 +0200304_iso-8859-1 Hello list.

When I am running a full image copy against a tablespace (only ?) the job output shows me the number of pages copied.

Is there in the DB2 catalog or elsewhere a chance to determine this number per FIC - especially after the job output is gone through the roof ? [...] 20433 59 96_Re: IMAGE COPY UTILITY - Determining number of copied pages per t able space (DB2 for OS/390 V5)7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Fri, 25 Aug 2000 16:55:47 +0530493_iso-8859-1 I don't think so, Let's see what else have to say.

Regards

Sanjeev



-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Friday, August 25, 2000 4:31 PM To: DB2-L@RYCI.COM Subject: IMAGE COPY UTILITY - Determining number of copied pages per table space (DB2 for OS/390 V5)



Hello list.

When I am running a full image copy against a tablespace (only ?) the job output shows me the number of pages copied. [...] 20493 73 31_Re: ROWID datatype in OS/390 V623_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 25 Aug 2000 08:23:43 -0400425_- Suresh,

I had tried this couple of months ago.



1. Load data into an empty table that has ROWID column 2. Do a SELECT * 3. Alter FREEPAGE and PCTFREE substantially 4. REORG tablespace 3. Do another SELECT *

The rowid columns returned different value after the REORG. Aside for LOB related column, I haven't come across any usage for ROWID. Others on the list may have more to say about it. [...] 20567 63 19_Re: Authid question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Fri, 25 Aug 2000 07:30:35 -0500556_- This is strictly a guess, but could it be that when you issue DDL like create or drop, that sysopr is the id that updates the DB2 catalog and that's what TMON captures?

> -----Original Message----- > From: Nadir Doctor [SMTP:Nadir.Doctor@BGEHOME.COM] > Sent: August 24, 2000 10:20 AM > To: DB2-L@RYCI.COM > Subject: Re: Authid question > > Keith, > > SYSOPR is the default installation authid for the SYSOPR privilege as > specified in the ZPARM - My guess is that TMON or some other process is > using this. > > Hope this helps. > > Nadir > [...] 20631 164 31_Re: Reorg using Shrlevel Change11_Ray H Janes27_ray_h_janes@EMAIL.MOBIL.COM31_Fri, 25 Aug 2000 07:39:55 -0500418_us-ascii Thank you for pointing out my mis-reading of the question. Next time I have a GUESS, I'll keep it to myself and allow the good Dr. to answer it.







mebert@AMADEUS.NET on 08/25/2000 02:44:09 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes) Subject: Re: Reorg using Shrlevel Change [...] 20796 87 19_Re: Authid question18_Erringer, Keith M.24_Keith.Erringer@ALCOA.COM31_Fri, 25 Aug 2000 08:46:59 -0400592_- Thanks for the replies Tina and Nidar. Our default installation authid is IBMUSER. The activity in question is accessing / updating application DB2 tables. I've started a trace on SYSOPR to try and nail this thing down. I'm also in contact with Landmark.

Keith.

> ---------- > From: Hilton, Tina, BmS - NMI -PM[SMTP:Tina.Hilton@BMSUS.COM] > Reply To: DB2 Data Base Discussion List > Sent: Friday, August 25, 2000 8:30 AM > To: DB2-L@RYCI.COM > Subject: Re: Authid question > > This is strictly a guess, but could it be that when you issue DDL like > create or drop, that [...] 20884 115 19_Re: Authid question0_19_mike.holmans@BT.COM31_Fri, 25 Aug 2000 13:52:44 +0100656_- Just a thought - how would activity during rollback be recorded?

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

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

> -----Original Message----- > From: Erringer, Keith M. [SMTP:Keith.Erringer@ALCOA.COM] > Sent: Friday, August 25, 2000 1:47 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Authid question > > Thanks for the replies Tina and Nidar. Our default installation authid is > IBMUSER. The activity in question is accessing / updating application DB2 > tables. I've started a trace on SYSOPR to try and nail [...] 21000 16 51_Number of groups on DSNR profile. Is there a limit?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Fri, 25 Aug 2000 07:52:58 -0500365_- I know that this is RACF related, but I wanted to see if anyone had any imput on possible experience with about 275 groups listed in the BATCH profile in class DSNR. This profile controls who can connect to DB2 through batch or TSO. We have about 25 now, and have a request to add about 250. Has anyone got to this number? If so, any problems you can share? [...] 21017 42 55_Re: Number of groups on DSNR profile. Is there a limit?0_19_mike.holmans@BT.COM31_Fri, 25 Aug 2000 14:20:27 +0100267_- I don't know whether I can be any vaguer than this, but I have a memory of running into some funnies about three years ago when we wanted to connect some users to more than 254 groups. If my memory is at all reliable, then you'll be OK at 240, but not at 260. [...] 21060 113 19_Re: Authid question27_Hilton, Tina, BmS - NMI -PM21_Tina.Hilton@BMSUS.COM31_Fri, 25 Aug 2000 08:14:19 -0500287_- I do remember when I worked with TMON before and had trouble with excessive syslgrng activity that sysopr was assigned to that (that was in DB2 2.3 when we tried to use 'close yes' and had to switch to 'close no'). I think that's the id that shows up for system-related activity. [...] 21174 23 21_DSN3@ATH entry points21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Fri, 25 Aug 2000 09:28:52 -0400455_iso-8859-1 Hi all,

I need to link the DB2 authorization exit with customizations from 2 different products, Oracle's Transparent Gateway for DB2 and AICorp's KBMS/INTELLECT. Each of these products has their own uniquely defined entry point for the DSN3@ATH module. Is it safe to link each products version of the exit into separate load libraries and steplib these libraries in the startup proc for xxxxMSTR? Or is there an easier/better way? [...] 21198 13 49_Re: Is it true comment? OS/390 V5 to V7 migrate??8_Bob Abad16_BobRabad@AOL.COM29_Fri, 25 Aug 2000 09:40:21 EDT323_US-ASCII Thank you, Roger. Will decide on V6 target install date in 4-6 months...

================================================ 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. 21212 73 55_Re: Number of groups on DSNR profile. Is there a limit?12_Myron Miller22_myronwmiller@YAHOO.COM31_Fri, 25 Aug 2000 06:57:10 -0700502_us-ascii At one time RACF had a max of 254 groups. That was a number of years ago. I don't know if it has been increased with the new changes to RACF (Security Server). A quick check of the RACF manual should clear it up. --- mike.holmans@BT.COM wrote: > I don't know whether I can be any vaguer than this, > but I have a memory of > running into some funnies about three years ago when > we wanted to connect > some users to more than 254 groups. If my memory is > at all reliable, then > you'll [...] 21286 58 43_Re: Emulating recursive SQL on DB2 OS390 V614_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 25 Aug 2000 08:58:43 -0400426_iso-8859-1 Sven,

Since there is no support yet on OS/390, even in V7, for recursive SQL, to emulate your example would require using temp tables. There is an explanation of this in one of the papers in the first DB2 Performance Journal, which is available on our web site, http://www.ylassoc.com. Since up as a guest and download it. It is too length to repeat here, but it not only can be done, it is being done. [...] 21345 70 31_Re: ROWID datatype in OS/390 V614_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 25 Aug 2000 09:06:37 -0400585_iso-8859-1 Suresh,

1 - ROWID is permanent and does not change. SELECT ROWID can change as it also includes the RID and the RID could change.

2 - Uses: besides LOBs (1) direct update where large multi-level indexes are used. For example we have used it where the index had 6 levels. Using direct update saved the 6 GETPAGEs for the index, and generally 4 index I/Os. In a heavy volume OLTP, that is considerable. (2) the first 2 bytes are random and can be effectively used as a partitioning key for pure random distribution (where random distribution does not cause [...] 21416 64 26_Re: WLM and DB2 V6 Refresh14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Fri, 25 Aug 2000 09:12:13 -0400593_iso-8859-1 All UDF's in OS/390 V6 require WLM in Goal Mode. Some stored procedures will require it, and some won't. But the bigger issue is that WLM Goal Mode is the future, not DB2 managed SPAS.

Without WLM, you are limited to one address space, trying to run all stored procedures, without any individual priorities. That means that your critical stored procedures complete for resources on an equal basis with the non-critical stored procedures. Not a good solution. WLM alleviates that. There is a lot of information on this in the recent Redbooks on V6 and stored procedures. [...] 21481 61 94_Re: IMAGE COPY UTILITY - Determining number of copied pages per tablespace (DB2 for OS/390 V5)12_Tal Lifshitz21_Tal.Lifshitz@MSDW.COM31_Fri, 25 Aug 2000 10:24:16 -0400587_iso-8859-1 I am analyzing the copy outputs and storing the information about number of pages, average pctfree, percent of updated paged and elapsed time in a db2 table. I then can use this information to balance the image copy jobs, by separating tablespaces that take longer to copy, and also to detect read only tablespaces (with low percent of changed pages over time). With read only tablespaces, you might want to change the locksize to tablespace and change the pctfree and freepage to 0. I guess, it could be really nice if this information was kept in SYSCOPY or something. [...] 21543 158 55_Re: Number of groups on DSNR profile. Is there a limit?0_18_mebert@AMADEUS.NET31_Fri, 25 Aug 2000 16:21:10 +0200551_us-ascii We've had annoying problems with RACF groups at the beginning of this year and also last year. You can connect a user to more than 254 groups, but DB2 will only recognise (check) the first 254 (or 255?) - I think alphabetically. The effect we had was: a user was connected to a group, this group had SELECT privilege on a table, but the user could not do the SELECT because of missing authorisation - took us considerable time to find the problem. So, for DB2 purposes, the limit is 254 groups per user (We're DB2 V5.1, OS390 R2.8). I'm [...] 21702 17 55_Re: Number of groups on DSNR profile. Is there a limit?12_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Fri, 25 Aug 2000 09:13:55 -0500525_- I think my topic has been misunderstood. I am not talking about the limit of RACF groups that the DSN3@ATH exit will get from RACF, I am talking about the number of RACF Groups in a RACF profile in CLASS DSNR. Those of you that are using RACF to contol who connects to DB2 for OS/390 will have a RACF profile with the name of ssid.BATCH, where ssid is the DB2 Subsystem name. This profile will list userid's or groups that can connect to DB2 through Batch or TSO. This is what I am trying to address. Thanks and sorry [...] 21720 84 47_SV: Re: Emulating recursive SQL on DB2 OS390 V60_19_Sven.Heidorn@CSN.SE31_Fri, 25 Aug 2000 16:36:20 +0200287_ISO-8859-1 Richard,

thanks a lot. I had already found the paper on your site and also tried to sign up as a guest. I guess that I just didn't have the patience to wait for the password to get registered. I got the paper now and I'm a happy camper again.

Thanks again. [...] 21805 50 28_Re: Repost: Plans-2-Packages13_Horacio Villa17_hvilla@TTI.COM.AR31_Fri, 25 Aug 2000 11:41:44 -0300414_iso-8859-1 You can also find some REXX procedures to help with the conversion at www.xephon.com. Search the archives. Old stuff is free. Horacio Villa TTI S.A. Buenos Aires - Argentina

-----Mensaje original----- De: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]En nombre de Freeling, Marv, ITD Enviado el: Jueves 24 de Agosto de 2000 21:50 Para: DB2-L@RYCI.COM Asunto: Repost: Plans-2-Packages [...] 21856 68 17_DB2 Text Extender11_Carl Powers17_CDPowers@FHSC.COM31_Fri, 25 Aug 2000 10:48:46 -0400561_US-ASCII Does anyone have any practical experience with the DB2 Text Extender in an OS/390 environment? I am particularly interested in the "fuzzy search" capabilities of the tool. The basic requirement can be explained with simple example. I need to be able to search a name field and return hits that are close in spelling and sound (i.e. fuzzy). My project is looking into a product from Intelligent Search Technologies. Are there other products on the market that would be worth researching? Thanks in advance for any informative posts on the subject. [...] 21925 46 31_Re: ROWID datatype in OS/390 V69_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 25 Aug 2000 09:21:51 -0600428_us-ascii In read only situations ROWID could be used for scrolling, you could code one scroll routine and have all of your scrolling needs met by that routine. I would imagine that IBM has future plans for ROWID down the road, maybe with scrolling cursors?

Due to the reorg changing the value of ROWID, any reference tables used or scroll points saved would have to be rebuilt after the object(s) were reorged, etc. [...] 21972 23 21_Re: DB2 Text Extender9_Rob Crane22_racrane@CONCENTRIC.NET31_Fri, 25 Aug 2000 09:26:13 -0600305_us-ascii SOUNDEX is a technique that a lot of folks have used over the years in alpha search applications. You build another column that contains the SOUNDEX value for each name and then use that column in your alpha search. Also helpful in a limited role in determining things like households, etc. [...] 21996 10 34_Re: DB2 OS390 Stored Proc Question10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Fri, 25 Aug 2000 10:34:32 -0500244_-

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 22007 56 21_Re: DB2 Text Extender12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Fri, 25 Aug 2000 10:43:32 -0500451_- Carl

The SOUNDEX is an old CICS routine that was used to convert to a four character key (first letter and three numbers) for a fuzzy search key. The routine still exists in the DFHLOAD of CICS4.1 as DFHPHN. I can dig up the info on using the module.

If you do not have CICS, or would prefer to not count on IBM keeping this module around, I have a COBOL version that I wrote a while back. You contact me off-list, if you prefer. [...] 22064 15 31_Re: Reorg using Shrlevel Change9_Jim Ruddy18_jaruddy@US.IBM.COM31_Fri, 25 Aug 2000 10:32:39 -0500483_- The long elapsed time in the unload and reload phases is caused by the disorganization and the way the mapping table was built in V5. The design was changed in V6 to correct this. Time to upgrade to V6?

Jim Ruddy IBM DB2 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. 22080 83 96_Re: IMAGE COPY UTILITY - Determining number of copied pages per t able space (DB2 for OS/390 V5)14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Fri, 25 Aug 2000 11:04:26 -0500313_iso-8859-1 NACTIVE is SYSTABLSPACE lists the number of pages that have active rows, and I think full Image Copy backs up only pages that have been formatted ( or have active rows,which includes preformatted pages). Pre-formatting is done when expanding to a new cylinder. A (3390) cylinder has 180 4k pages. [...] 22164 83 9_Table UDF23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 25 Aug 2000 12:36:16 -0400319_- Hi all !

Has anyone on the list written an external table UDF in COBOL. There are no COBOL example in SDSNSAMP. We have been able to write external scalar UDF, but table UDF gives -440 on invocation. Can't seem to find anything wrong with the program or the UDF definition. Any help would be appreciated. [...] 22248 50 25_AW: DSN3@ATH entry points16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 25 Aug 2000 18:42:07 +0200637_iso-8859-1 We use the MVS dynamic exit facility to invoke multiple exists from one exit point.

Roland

> -----Ursprüngliche Nachricht----- > Von: Brown, James R. - DIT [SMTP:brownjr@CI.RICHMOND.VA.US] > Gesendet am: Freitag, 25. August 2000 15:29 > An: DB2-L@RYCI.COM > Betreff: DSN3@ATH entry points > > Hi all, > > I need to link the DB2 authorization exit with customizations from 2 > different products, Oracle's Transparent Gateway for DB2 and AICorp's > KBMS/INTELLECT. Each of these products has their own uniquely defined > entry point for the DSN3@ATH module. Is it safe to link each products > version of the [...] 22299 18 14_DB2 and Web39012_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Fri, 25 Aug 2000 11:33:51 -0500461_- We are planning to use IBM's WebSphere Application Server for OS/390 product. The Application Server will be using DB2 for OS/390 to contain the data for the server applet. Is anyone using these products to give access to data from the Internet? If so, I would like to talk and get pros and cons of this configuration. We are new to this product, and it will be the first time we set up datasharing for this. Any information will be greatly appreciated. [...] 22318 20 46_DB2 and WebSpere Application Server for OS/39012_Richard Pack23_rpack1@MAIL.STATE.MO.US31_Fri, 25 Aug 2000 11:36:10 -0500525_- Sorry, I had the wrong product name in the subject line.

We are planning to use IBM's WebSphere Application Server for OS/390 product. The Application Server will be using DB2 for OS/390 to contain the data for the server applet. Is anyone using these products to give access to data from the Internet? If so, I would like to talk and get pros and cons of this configuration. We are new to this product, and it will be the first time we set up datasharing for this. Any information will be greatly appreciated. [...] 22339 92 21_Re: DB2 Text Extender0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 25 Aug 2000 11:57:27 -0500474_us-ascii Do a web search for SOUNDEX. There are several sites/pages that describe it.

Basically SOUNDEX is an algorithm created for the US Census back in the late 1800's to convert surnames into 4 char codes so that names that generally sound alike have a similar code value. The original algorithm consists of 7 rules. Additional rules have been added at various times to extend it, ie treatment of sound alike prefix "Saint" "STE." "ST.", as in "Saint James". [...] 22432 28 9_Batch SQL8_DL Ragar28_nrragad@MAIL.DNR.STATE.MO.US31_Fri, 25 Aug 2000 12:01:28 -0500150_us-ascii Using DSNTEP2 to execute SQL statements, the output is "wrapped" to line size of 132. How can I execute SQL statements in batch with a longer 22461 300 13_Re: Batch SQL14_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Fri, 25 Aug 2000 12:47:48 -0500399_- If you use the PARMS('SQL') on the DSNTIAUL execute you can run batch spufi. This was introduced in Vers 4 the SYSREC00 will allocate the desired record length. SYSPUNCH will generate a load card

I only used / instead of // because the reply was formatting bad. Change all / to // for JCL. The IEFBR14 step is unnecessary if you are perfect and can get the query correct the 1st time. [...] 22762 100 90_Repost: Redbook Announcement: SG24-5486-00 DB2 UDB for OS/390 an d Continuous Availability13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Aug 2000 11:53:02 -0600545_iso-8859-1 Dear DB2 Interested Parties,

A new "DB2 UDB for OS/390 and Continuous Availability" redbook is now available, see the bulletin below. The book can be downloaded from the web in pdf format at http://www.redbooks.ibm.com/abstracts/sg245486.html

You may view/download Redbooks, Redpieces, Redpapers, and see ITSO* residencies currently open at http://www.redbooks.ibm.com/ (hint: search on "DB2") or you can view/download Redbooks at http://www.fatbrain.com/documentation/redbooks/home.html/ (again, search on "DB2"). [...] 22863 44 97_Repost: New technical report on "Leveraging DBMS Stored Procedure s through Enterprise JavaBeans"13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Aug 2000 11:53:59 -0600591_iso-8859-1 Dear DB2 Interested Parties,

A new IBM technical report by Cindy Saracco of IBM Silicon Valley Lab, "Leveraging DBMS Stored Procedures Through Enterprise JavaBeans," is now available via the IBM DB2 white paper Web site at http://www.ibm.com/software/data/pubs/papers/ or directly at http://www-4.ibm.com/software/data/pubs/papers/index.html#javabeans

The paper is designed to help users working with DB2, VisualAge, and WebSphere exploit existing business logic in stored procedures when working with WebSphere's EJB Server. Here is an abstract of the report: [...] 22908 87 87_Repost: Register for IDUG 2000 Europe Conference: 23-26 October, in Geneva, Switzerland13_Morrill, John12_JohnM@VP.NET31_Fri, 25 Aug 2000 11:54:35 -0600550_iso-8859-1 Dear DB2 Interested Parties,

Below is a bulletin about the IDUG 2000 Europe Conference to be held 23-26 October in Geneva. Don't miss this unparalleled event, the largest and most comprehensive DB2 conference offered in Europe.

Upcoming IDUG events in other regions include (see http://www.idug.org for details): o IDUG 2000 Technical Symposium, 6-7 November in Toronto, Canada o IDUG 2000 Asia Pacific conference, 15-17 November in Sydney, Australia o IDUG 2001 North American conference, 13-17 May in Orlando, Florida [...] 22996 120 77_Repost: Register for IDUG Technical Symposium, Toronto, Canada, N ovember 6-713_Morrill, John12_JohnM@VP.NET31_Fri, 25 Aug 2000 11:55:50 -0600575_iso-8859-1 Dear DB2 Interested Parties,

Below is a bulletin about the IDUG 2000 Technical Symposium to be held November 6-7 in Toronto. IDUG Technical Symposium offers a departure from the traditional IDUG conference format in that you sign up for 2 full-day seminars on the topic of your choice. The event also includes an IBM DB2 Developers Panel and a keynote presentation (this year by IBM Fellow, Dr. Patricia Selinger). The bulletin below describes the high quality seminars and instructors. Register for the symposium at the IDUG Web site (see URL below). [...] 23117 38 21_Re: DB2 Text Extender14_Wayne Driscoll24_Wayne.Driscoll@QUEST.COM31_Fri, 25 Aug 2000 11:10:14 -0700336_iso-8859-1 There was a good 2 part introduction to Soundex in the March and April 2000 issues of Technical Support Magazine. They were written by Jim Moore. Ask around, maybe you can come up with copy of the articles. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 23156 26 31_DB2 Systems Programmer Position16_Lamb, Ron (CORP)25_Ron.Lamb@CORPORATE.GE.COM31_Fri, 25 Aug 2000 14:20:05 -0400417_- We presently have an open position for a DB2 Systems Programmer, located in Cincinnati, Louisville or Schenectady. This position requires 3-5 years experience installing and supporting multiple DB2 sub-systems on multiple MVS LPARS for multiple internal GE customers.

Qualified candidates should send their resume to the address below.

P.S. We also have an opening for a CICS Systems Programmer. [...] 23183 12 21_DB2 Stored Procedures17_Edward G. La Touf17_elatouf@YAHOO.COM31_Fri, 25 Aug 2000 13:01:12 -0500409_- Other than the SQL statements not allowed in a store procedure. Are there Cobol commands which are not allowed. Such as write to a file or report, display, etc.....?

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23196 23 21_Re: DB2 Text Extender13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 25 Aug 2000 14:24:28 -0400366_iso-8859-1 >There was a good 2 part introduction to Soundex in the March and April 2000 >issues of Technical Support Magazine. They were written by Jim Moore.

You can get at these online at http://www.naspa.net/00articlesbymonth.htm and select March and April.

At least I could just get them and I believe my naspa membership has lapsed long ago. [...] 23220 43 51_LOAD Utility or codeset Puzzle? : UDB V5.2 AIX V4.315_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Fri, 25 Aug 2000 13:32:31 -0500619_iso-8859-1 Dear List,

I am in the process of testing a load process that will replace programmatic inserts in production. After the load in the test table, I am comparing the export dumps of production and test tables to verify if they are the same.

I find that some special characters in character fields gets transformed during the load process. Say for example a HEX(9B) in the input DEL (ASCII) file becomes HEX(B0) the DB2 tables. However the programmatic insert process in production keeps the input HEX(9B) as HEX(9B). I have verified that the database code page/code set/country code are the [...] 23264 37 25_Re: DB2 Stored Procedures15_Johnson, Steven23_X2SJOHNS@SOUTHERNCO.COM31_Fri, 25 Aug 2000 13:44:15 -0500340_- for DB2 V4 & V5 the following commands are not allowed: CALL (may be supported in the future versions) COMMIT CONNECT (may be supported in the future versions) RELEASE (may be supported in the future versions) ROLLBACK SET CONNECTION (may be supported in the future versions) SET CURRENT SQLID

Steven Johnson Applications DBA [...] 23302 10 32_SAS Calling DB2 Stored Procedure17_Edward G. La Touf17_elatouf@YAHOO.COM31_Fri, 25 Aug 2000 13:32:35 -0500283_- Can SAS PC call a DB2 Stored Procedure?

================================================ 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. 23313 25 31_Re: Reorg using Shrlevel Change13_john arbogast19_arbo@CP-DEMO.CP.NET31_Fri, 25 Aug 2000 12:02:34 -0700593_- If you enjoy applying PTFs like crazy.....

On Fri, 25 August 2000, Jim Ruddy wrote:

> > The long elapsed time in the unload and reload phases is caused by the > disorganization and the way the mapping table was built in V5. The design > was changed in V6 to correct this. Time to upgrade to V6? > > Jim Ruddy > IBM DB2 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. [...] 23339 20 20_Which DB2 on Windows12_Kirk Hampton16_khampto1@TXU.COM31_Fri, 25 Aug 2000 14:28:10 -0500447_us-ascii What is the easiest way to tell what version/components of DB2 you have installed on a particular Windows machine:

CAE only DB2 Connect PE DB2 Connect EE DB2 UDB PE DB2 UDB EE DB2 UDB EEE ?

================================================ 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. 23360 13 24_Re: Which DB2 on Windows14_Philip Gunning18_pgunning@PHEAA.ORG31_Fri, 25 Aug 2000 15:33:38 -0400343_us-ascii Use regedit from a dos prompt and look at hkey\local\mahcine software\ibm\db2 etc, etc. Phil

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23374 38 24_Re: Which DB2 on Windows13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Fri, 25 Aug 2000 15:03:58 -0500471_iso-8859-1 Kirk,

Issue a DB2LEVEL command from a dos command prompt.

Dave

-----Original Message----- From: Kirk Hampton [mailto:khampto1@TXU.COM] Sent: Friday, August 25, 2000 2:28 PM To: DB2-L@RYCI.COM Subject: Which DB2 on Windows



What is the easiest way to tell what version/components of DB2 you have installed on a particular Windows machine:

CAE only DB2 Connect PE DB2 Connect EE DB2 UDB PE DB2 UDB EE DB2 UDB EEE ? [...] 23413 27 32_How do you estimate insert time?0_25_George_White@VANGUARD.COM31_Fri, 25 Aug 2000 16:07:57 -0400304_us-ascii Hi,

I need to be able to estimate the clock time for a multi-million row SQL insert process.

Can someone explain the steps that occur for a write and where the longest time is spent. I know the row gets written to the buffer, and that it gets externalized at some point (LRU) [...] 23441 94 48_Re: Design of allowed value tables (Code tables)0_25_George_White@VANGUARD.COM31_Fri, 25 Aug 2000 16:11:55 -0400399_us-ascii Rick,

I can see your point, but have you implemented this idea? This would reuquire a DDL statemente to be executed. Which menas that we more than likely could not\be allowed to automate it.

George .





Date: Thu, 24 Aug 2000 09:02:39 -0500 From: "DAVIS, RICK (SBCSI)" Subject: Re: Design of allowed value tables (Code tables) [...] 23536 42 13_Re: Batch SQL0_24_Joseph_A._Lenzini@UP.COM31_Fri, 25 Aug 2000 15:27:07 -0600609_iso-8859-1 You can try modifying PAGEWIDTH in the source code and compiling it under another name.







DL Ragar @RYCI.COM> on 08/25/2000 11:01:28 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Batch SQL







Using DSNTEP2 to execute SQL statements, the output is "wrapped" to line size of 132. How can I execute SQL statements in batch with a longer LRECL on the output file? [...] 23579 87 24_Re: Which DB2 on Windows12_Kirk Hampton16_khampto1@TXU.COM31_Fri, 25 Aug 2000 16:19:58 -0500417_us-ascii Interesting. Phil's technique with REGEDIT seems to show what I wanted to know, which was whether I had the full UDB database or just DB2 Connect.

The DB2LEVEL command does display the release level, but not necessarily what component, and the command did not even exist on a DB2 Connect Enterprise Edition Version 5 machine. Is there really no way to tell at a glance what you're dealing with ? [...] 23667 27 12_REPLICATION!15_Amitabh Akolkar23_oxynet@MAILCITYASIA.COM31_Sat, 26 Aug 2000 11:31:02 +0530606_us-ascii Hi,

Can anyone please advice as to whether DB2 Personal Edition supports Replication or not.

Also it would be helpful if you could advice on how much data a DB2 Satellite Edition can hold.

Hope to recieve your help at the earliest.

Thanking you,

Amitabh.



Get your FREE Email at http://www.mailcityasia.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. 23695 15 47_Kimberlee Little/IT/SEARS is out of the office.10_Kim Little17_klittle@SEARS.COM31_Sat, 26 Aug 2000 01:41:43 -0500441_us-ascii I will be out of the office from 08/26/2000 until 09/05/2000.

I will respond to your message when I return. If an immediate response is necessary, please contact Pam Harris (PHARRI1).

================================================ 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. 23711 38 24_Re: DB2 Release Strategy12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Aug 2000 16:49:38 -0500409_- I'll venture my opinion, so long as it not taken for more than mine (nothing official and certainly nothing formal from my employer).

Our past history has been to deliver a generally available release every 18 to 24 months, and Version 7 still seems to be on that track. There is a lot more variability for announcements. We'd like to deliver on a shorter cycle, but that seems to be difficult. [...] 23750 14 25_Re: DSN3@ATH entry points12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Aug 2000 17:02:23 -0500501_- You only get one exit, so there is some work to do. My first step would be to call the vendors and ask them if they have experience or advice. It would be possible, but not likely, for one exit to conflict with the other.

Roger Miller, DB2 for OS/390

================================================ 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. 23765 16 55_Re: Number of groups on DSNR profile. Is there a limit?12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Aug 2000 17:13:28 -0500523_- The RACF limit was lifted quite a few releases ago, long enough that the release is out of service now, but the book has this.

The DB2 secondary id limit is 245, as it says in the Administration Guide appendix, but this is not for DSNR.

Roger Miller, DB2 for OS/390

================================================ 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. 23782 20 36_Re: How do you estimate insert time?12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Aug 2000 17:28:58 -0500573_- Your best bet for something like this is the red book on capacity planning or Estimator.

DB2 for OS/390 Capacity Planning , SG24-2244-00 1997-12-31 ibm/com/redbooks and search for SG24-2244

Estimator ibm.com/software/db2os390 Click on DB2 Estimator under the Features at a glance

Roger Miller, DB2 for OS/390

================================================ 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. 23803 28 16_Re: REPLICATION!12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 26 Aug 2000 17:52:33 -0500469_- I'm not an expert in this by any means, and not completely sure which one you mean, but there is an easy way to check. Start at

ibm.com/software/data/db2/udb/

Choose DB2 Personal Developer's Edition DB2 Universal Developer's Edition DB2 Universal Database Personal Edition DB2 Universal Database Workgroup Edition DB2 Universal Database Enterprise Edition DB2 Universal Database Enterprise-Extended Edition DB2 Universal Database Satellite Edition [...] 23832 126 13_Re: Table UDF14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Sun, 27 Aug 2000 17:38:35 +1100336_iso-8859-1 A -440 has nothing to do with the language the routine is written in or the actual code - the -440 is raised before the routine is invoked. You'll need to 1) ensure that the schema for the routine is in the bind path, and 2) check each parameter in the function invokation matches the parameters in CREATE FUNCTION DDL. [...] 23959 64 37_Links about DB2 for OS/390 (08/28/00)6_DB2usa18_db2usa@HOTMAIL.COM31_Sun, 27 Aug 2000 17:32:59 -0500807_ISO-8859-1 Hi,

Here is a non-profit website about DB2 for OS/390 (IBM mainframes):

- English : http://www.multimania.com/db2usa/eliendb2.htm - Français: http://www.multimania.com/db2usa/liendb2.htm

Last update on Monday August, 28th 2000 =======================================

- Links about DB2 for OS/390: http://www.multimania.com/db2usa/eliste.htm Take a look at DB2 availability summary page on IBM DB2 for OS/390 website.



- Technical papers: http://www.multimania.com/db2usa/earticle.htm Fall issue of DB2 Mag is available on line: - Ready For Anything by Gary Mordini, DB2 Mag, Fall 2000. - Seventh Heaven by Richard Yevich, DB2 Mag, Fall 2000. - Tuning Data Sharing Performance by Robert Catterall, DB2 Mag, Fall 2000. - Spatial Perception in DB2 for [...] 24024 124 31_Re: Reorg using Shrlevel Change0_18_mebert@AMADEUS.NET31_Mon, 28 Aug 2000 09:36:19 +0200478_us-ascii Hi Jim,

from a lecture I learned about a couple of REORG enhancements (runtime determination whether to run REORG, inline RUNSTATS, parallel Index build, parallel VSAM rename, improved LOGAPPLY) but nothing about improvements in the RELOAD phase. Can you specify? As for going to V6: we have had enormous problems with abending OLRs crashing DB2 (and many other things). That's better now, but we have postponed using V6 in production with no new date set. [...] 24149 51 16_-327 insert data17_Suthep Thampranee18_suthepth@SCB.CO.TH31_Mon, 28 Aug 2000 17:09:09 +0700166_windows-874 I just found this sql code when run program to insert data.Should I have to drop ts ,tb and ix?And then create new partitioned key? thank for any help joe 24201 38 20_Re: -327 insert data11_rick creech18_ykcirc@HOTMAIL.COM29_Mon, 28 Aug 2000 11:40:17 GMT289_- If you are version 6 or have the correct ptfs fro version 5 you might be able to simple use ALTER INDEX to change the limit key for the last partition. Note: an advantage to using LARGE or DSSIZE: the maximum possible value is always allowed to be inserted.

HTH, Rick Creech [...] 24240 42 27_Query reg dropping of Index17_R.V. Subrahmanian33_rv_subrahmanian@CHENNAI.TCS.CO.IN31_Mon, 28 Aug 2000 17:03:05 +0530520_us-ascii All,

I have a query related to dropping of Index.

Q: Let us assume that a program is compiled and bound in Developement environment and migrated to the production environment. Also, there are 2 indexes defined - one is the primary index and the other is an alternate index.

Let us assume that the SQL in the program uses the alternate index only. Now, when the program is in production environment, if the alternate index is dropped mistakenly, what will happen when the program runs? [...] 24283 158 19_Re: Authid question15_Slot, JP (Jaap)23_J.P.Slot@RF.RABOBANK.NL31_Mon, 28 Aug 2000 14:42:43 +0200338_iso-8859-1 Don't know, Like mileage on old cars, if you drive them for a while in reverse your mileage would become less. Ever heard of negative activity? That's a way to get better averages. Rollback is reversing activity that's been done, shouldn't it be substracted from the original activity? Just adding to your thoughts Mike.. [...] 24442 18 26_Estimating tablespace size17_Vijay Subramanyam33_vijay.subramanyam@HPSBLR.SOFT.NET31_Mon, 28 Aug 2000 18:32:13 +0500399_- Hello List, I would like to know what are the methods or ways of estimating the tablespace size. Is there any rule or formula for this???

TIA, VIJAY

================================================ 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. 24461 41 30_Re: Estimating tablespace size0_22_The-Thanh.Luong@AGF.BE31_Mon, 28 Aug 2000 15:26:07 +0200492_- (DB2 V4, OS/390). Have a look in the SQL Reference manual, Chapter 6: Create TableSpace, PRIQTY and SECQTY parameters. HTH,

LUONG The-Thanh

===== Disclaimer: opinions expressed are strictly my own, etc... =====





-----Original Message----- From: Vijay Subramanyam [mailto:vijay.subramanyam@HPSBLR.SOFT.NET] Sent: Monday, August 28, 2000 3:32 PM To: DB2-L@RYCI.COM Subject: Estimating tablespace size Importance: High [...] 24503 85 31_Re: Query reg dropping of Index19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Mon, 28 Aug 2000 09:08:56 -0500406_iso-8859-1 Hi R V, Dropping the index would mark the PLAN or PACKAGE as not operative (requiring a rebind) but still valid. If the installation parm for dynamic rebind is turned on, the PLAN or PACKAGE would be dynamically rebound the first time it was used. The above rebind would determine if a tablespace scan would then be used (based on your description, it seems a tablespace scan would occur). [...] 24589 103 31_Re: Query reg dropping of Index15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Mon, 28 Aug 2000 09:34:17 -0500517_iso-8859-1 The other way round, Rick. The package/plan will be invalidated first when on execution it does not find the index. If the dynamic rebind you mention fails, then the plan/package becomes inoperative requiring an explicit rebind/bind. However if the dynamic rebind succeeds, the plan/package becomes valid again.

-----Original Message----- From: DAVIS, RICK (SBCSI) [mailto:RD8246@MOMAIL.SBC.COM] Sent: Monday, August 28, 2000 9:09 AM To: DB2-L@RYCI.COM Subject: Re: Query reg dropping of Index [...] 24693 3334 13_Re: Table UDF23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Mon, 28 Aug 2000 11:05:01 -0400502_iso-8859-1 I know -440 has nothing to do with which language the routine is written in. Obviously the problem is somewhere in the definition of UDF and the COBOL code linkage section. That is the reason why I mentioned that there are no samples to show how parameters (both input and output columns) should be defined in the COBOL source code for a table UDF. I think I have defined them correctly. But you might spot what I am probably overlooking. Here is the sample definition and source code. [...] 28028 101 13_Re: Table UDF23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Mon, 28 Aug 2000 15:15:37 +0000502_iso-8859-1 I know -440 has nothing to do with which language the routine is written in. Obviously the problem is somewhere in the definition of UDF and the COBOL code linkage section. That is the reason why I mentioned that there are no samples to show how parameters (both input and output columns) should be defined in the COBOL source code for a table UDF. I think I have defined them correctly. But you might spot what I am probably overlooking. Here is the sample definition and source code. [...] 28130 64 44_IDUG 2001 Call for Presentations -- REMINDER14_Philip Gunning18_pgunning@PHEAA.ORG31_Mon, 28 Aug 2000 11:41:07 -0400514_us-ascii IDUG 2001 Call for Presentations

I am writing to you on behalf of the North America IDUG Conference Planning Committee to ask if you would please submit a presentation abstract to be considered for the 13th annual North America International DB2 User Group Conference. The event will be held May 13-17, 2001, at the Orlando World Center Marriott in Orlando, Florida. If the presentation is selected to be delivered in Orlando, the conference registration fee will be waived for the presenter. [...] 28195 394 48_Re: Design of allowed value tables (Code tables)27_Radonjic, Bora (Consultant)23_BRadonjic@ACNIELSEN.COM31_Mon, 28 Aug 2000 11:09:55 -0500312_- One option I can think off is defining View Wiht Check Option as a way of defining set of allowed values (domain) for a column. Something like Create View Vxxxxxxx ( STATE_CD , xxxxx, xxxx ) As Select (STATE_CD, yyyy, yyyy ) From DSNnnnn.TCODE WHERE STATE_CD IN ('AL',...'PA', ....'WY') WITH CHECK OPTION [...] 28590 47 30_Re: Estimating tablespace size14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Mon, 28 Aug 2000 11:16:37 -0400703_iso-8859-1 Use the DB2 Estimator. This is one of its best features.

Hope this helps, Richard Yevich +======+======+======+ Richard_Yevich@attglobal.net http://www.YLAssoc.com -- DB2 Performance Journal http://www.ryci.com -- RYC Knowledge Database http://www.DB2-Portal.com



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Vijay Subramanyam > Sent: Monday, August 28, 2000 9:32 AM > To: DB2-L@RYCI.COM > Subject: Estimating tablespace size > Importance: High > > > Hello List, > I would like to know what are the methods or ways of estimating the > tablespace size. > Is there any rule or formula for this??? > > TIA, > [...] 28638 32 19_UDB Certification..10_Radha Rani24_radha_rani@ALTAVISTA.COM31_Mon, 28 Aug 2000 11:32:56 -0700400_- Hello list ,

I am preparing for UDB certification (for Windows NT, Unix and Aix) , IBM Test Nos. 509 and 510. On the IBM website, I found information regarding the objectives and a Sample test paper for each of these.

Could someone in the list share their experiences with these tests...especially the number of questions asked, the passing percentage , degree of toughness etc. [...] 28671 63 23_Re: UDB Certification..14_Richard Yevich17_ryevich@YAHOO.COM31_Mon, 28 Aug 2000 12:48:05 -0700541_us-ascii

There is a large number of DB2 Certifrication for xxxx books, on the websites for overnight ordering from Amazon.Com, and others. They are extensive, have sample questions, and are the best source of information on the certification process.

Radha Rani wrote: Hello list ,

I am preparing for UDB certification (for Windows NT, Unix and Aix) , IBM Test Nos. 509 and 510. On the IBM website, I found information regarding the objectives and a Sample test paper for each of these. [...] 28735 15 23_Re: UDB Certification..13_Horacio Villa17_hvilla@TTI.COM.AR31_Mon, 28 Aug 2000 17:03:57 -0300334_iso-8859-1 You can go to http://certify.torolab.ibm.com for more sample tests. Horacio Villa

================================================ 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. 28751 23 21_DB2 for OS/390 to UDB0_18_Usregion10@AOL.COM29_Mon, 28 Aug 2000 18:55:45 EDT434_ISO-8859-1 Hi all!

I have been a DBA for Db2 on OS/390. My client here wants me to support a project that would use UDB (on RS/6000) . Questions: Do I need any training ? If yes, which one ? Will it be a big deal to grasp things on the fly ? Recommended reading ? UDB specific websites ? Useful books to buy ? Lastly, does anyone know what's the best way to order the IBM's manuals on CD. It's a whole collection. Thanks. [...] 28775 19 11_DB2 UDB DDL0_18_Usregion10@AOL.COM29_Mon, 28 Aug 2000 19:08:43 EDT421_ISO-8859-1 Hi all!

Can somebody give me a sample DDL (Storage group, DB, TS, TB, IX) for a application database created for DB2 UDB on Unix ? Thanks in advance.

Anil

================================================ 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. 28795 24 15_Re: DB2 UDB DDL13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Mon, 28 Aug 2000 17:58:10 -0500279_- > Can somebody give me a sample DDL > (Storage group, DB, TS, TB, IX) for a application database created for DB2 > UDB on Unix ?

Which Unix?

The nice thing about the Control Center is that you can take almost any action and save the script to do it to disk. [...] 28820 43 15_Re: DB2 UDB DDL9_Don Alden25_Don.Alden@I-STRUCTURE.COM31_Mon, 28 Aug 2000 17:16:17 -0600359_iso-8859-1 One of the nice features of if that the UDB Control Center uses "Smart Guides" to walk you though creation all of these objects so you may not need samples.

Don Alden

-----Original Message----- From: Henry J. Cobb [mailto:hcobb@CHEAPESTDEALS.COM] Sent: Monday, August 28, 2000 4:58 PM To: DB2-L@RYCI.COM Subject: Re: DB2 UDB DDL [...] 28864 128 13_Re: Table UDF8_LAM, Leo17_l.lam@IOOF.COM.AU31_Tue, 29 Aug 2000 13:51:31 +1000734_iso-8859-1 When you code TABLE (DB2DA.UDFPGM02('AD3111')) AS X, the input parm is a VARCHAR, I think you need to use

TABLE (DB2DA.UDFPGM02(CAST('AD3111' AS CHAR(6))) or TABLE (DB2DA.UDFPGM02(SUBSTR('ADS111',1,6)))





-----Original Message----- From: Jain, Sanjay (Exchange) [mailto:sanjayjain@BEAR.COM] Sent: Tuesday, 29 August 2000 1:16 To: DB2-L@RYCI.COM Subject: Re: Table UDF



I know -440 has nothing to do with which language the routine is written in. Obviously the problem is somewhere in the definition of UDF and the COBOL code linkage section. That is the reason why I mentioned that there are no samples to show how parameters (both input and output columns) should be defined [...] 28993 94 13_Re: Table UDF14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 29 Aug 2000 14:23:06 +1100496_iso-8859-1 Or, and this is what we do, recode the UDF (specification and code) to have a varchar parameter. If a fixed length char is provided, it will automatically be promoted to varchar.

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



-----Original Message----- From: LAM, Leo [mailto:l.lam@IOOF.COM.AU] Sent: Tuesday, August 29, 2000 2:52 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Table UDF [...] 29088 134 31_Re: Query reg dropping of Index17_R.V. Subrahmanian33_rv_subrahmanian@CHENNAI.TCS.CO.IN31_Tue, 29 Aug 2000 09:14:10 +0530321_us-ascii Thanks Tonmoy Dasgupta and Rick. This being the case,

If the Dynamic bind fails and the package/plan becomes inoperative and before explicit bind is done, what kind of failure will we be getting ( if any ), while running the program. i.e. if there are any SQLCODE associated to this type of problem. [...] 29223 177 31_Re: Query reg dropping of Index14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Tue, 29 Aug 2000 15:15:34 +1100410_iso-8859-1 SQLCODE-904 (from memory) with reason code 00E30302, 00E30305, 00E30306 or 00F30082.

(I've also got to say that this can be found by searching the Bookmanager Messages and Codes searching for 'automatic bind'. If you don't have the DB2 manuals in soft copy, I recommend you download them, or a PDF version, using the links from http://www-4.ibm.com/software/data/db2/os390/library.html) [...] 29401 24 18_Db2 subsystem name25_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM31_Tue, 29 Aug 2000 10:06:10 +0530603_- Hi list, I am working in in a db2 environemnt. I am not aware of the subsystem name in our env. How can I find the subsystem name .

Thanks in advance

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail [...] 29426 135 31_Re: Query reg dropping of Index25_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM31_Tue, 29 Aug 2000 09:58:13 +0530373_- Hi Davis, I understand that after dropping the index the plan or package will remain valid but why the plan or package will Will be marked inoperative.

Thanks Ranjay sinha

-----Original Message----- From: DAVIS, RICK (SBCSI) [SMTP:RD8246@MOMAIL.SBC.COM] Sent: Monday, August 28, 2000 7:39 PM To: DB2-L@RYCI.COM Subject: Re: Query reg dropping of Index [...] 29562 61 31_Re: Query reg dropping of Index7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Tue, 29 Aug 2000 10:32:34 +0530531_iso-8859-1 There are two columns related to this in SYSIBM.SYSPLAN i.e VALID and OPERATIVE(already discussed in the list, i think three times).So, when an index is dropped then plan is marked as INVALID i.e VALID=N, and automatic rebind attempts which depends on the DSNZPARM , if successful will mark it as Y and if automatic rebind fails DB2 mark plan as INOPERATIVE i.e OPERATIVE=N and it has to be bound(not rebound) again.If in DSNZPARM , Auto rebind is NO then plan has to be explicitly rebound(not neccessarily bound). [...] 29624 58 22_Re: Db2 subsystem name7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Tue, 29 Aug 2000 10:44:20 +0530585_iso-8859-1 Hi Ranjay, Easiest method(Non-Technical) is to go to SDSF panel and give PRE *MSTR and open the address space with INPUT ON.You will find out the subsystem name.There may be multiple MSTR Address space running if you have multiple DB2 subsystem in the same MVS.In that case some common sense and guesses are to be applied about which DB2 subsystem you are working in(Test,Development,Prodn,QA etc on the basis of naming conventions).If that not works then let us wait for some more ideas, i do not remember what i have been told in the IBM training to look for the DB2 [...]