1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2000, week 3 2 17 6_LOGOFF9_tio vital20_tiovital@HOTMAIL.COM29_Tue, 15 Feb 2000 08:34:48 IST400_- LOGOFF DB/2-L Tio Vital





______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 20 19 14_Isolation (UR)14_Rowell, Dean A19_dean.rowell@EDS.COM31_Tue, 15 Feb 2000 01:48:37 -0600524_x-user-defined Is it ever possible to get a -911 on a program whose sql is read only and is bound for 'Dirty reads' Isolation (UR)? Thank you in advance for your help.

Dean Alan Rowell Dean.Rowell@eds.com Work phones(219)675-0227 or (219)273-7328

================================================ 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. 40 267 30_Re: DB2 V5.1 & Parallelism....0_18_mebert@AMADEUS.NET31_Tue, 15 Feb 2000 10:24:01 +0100564_us-ascii Hello Mr. Hynes,

thanks for this info. I looked at it but I am afraid I am not drawing the same conclusions from your EXPLAIN et al. as you do. First of all, an omission from my part - I did not specify I was talking about CPU parallelism specifically; that's where we had all our problems. Your example provides only I/O parallelism (as you say in your letter and as is indicated in the PARALLELISM_MODE='I') - a much simpler thing where (even) I don't expect real problems. Your example is the most simple case of all, a parallel tablespace [...] 308 382 55_Re: Listing Databases for an Instance (UDB v6.1 on AIX)13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Tue, 15 Feb 2000 09:40:44 +0000613_us-ascii I don't think I'll even bother posting my Perl scripts to automatically examine and add space to tablespaces or to process the db2evmon output !!!

Unless anyone really wants them !!







On Mon, 14 Feb 2000 21:26:00 -0500, Scott Hayes wrote:

>You know Bill, between our sample scripts, I think we've just >about got all the DB2 OS/390 people thinking that UNIX is >indeed a scary place. > >For those in the studio audience wanting to run runstats for >each table in a database schema: > >$ db2 connect to DBNAME >$ db2 list tables [for all] | grep SCHEMANAME [...] 691 31 14_RRSAF Query !!13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Tue, 15 Feb 2000 14:37:40 +0530553_us-ascii hi !! I am writting a Resource Manager using RRSAF . This uses the context services .I use the context services to switch threads between multiple tasks . My problem is that ... for using context services , or to begin_context the Resource manager has to be in "set" state. The RM goes into set state only when its exits are set.. There are five exits for context services. This can be set using call to 'CRGSEIF' . set_exit_information is the function name. In this call I have to provide the PC Number / entry point address of the exit. [...] 723 14 8_UDB V6.111_Roland Chua32_rolandchua@SINGAPOREEXCHANGE.COM31_Tue, 15 Feb 2000 18:10:26 +0800333_us-ascii Hi, Could anyone tell me how stable is UDB V6.1 on NT platform. Thanks in advance.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 738 37 19_OS/390 DB2 & Oracle32_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Tue, 15 Feb 2000 13:29:16 +0200397_- Hello List,

Has anybody experienced to configure DB2 for OS/390 as AR to comunicate with a non-DB2 DRDA Server, such as Oracle for NT. I did this config. for other platforms for DB2 and it worked. Bu now I have an assignment to do it for non-DB2 DRDA server.

. CDB is populated with locations and IP names. . Both systems are in the same IP Network . Oracle Listeners are on. [...] 776 67 30_Re: DB2 V5.1 & Parallelism....0_19_mike.holmans@BT.COM31_Tue, 15 Feb 2000 11:14:47 -0000569_- Michael Ebert wrote:

"So let's wait for a "significant" (e.g. involving subqueries, joins) example > using CPU parallelism to come in. By the way, I keep harping about CPU > times > because elapsed times can vary wildly, unlike CPU times (from long > experience in > a mainframe environment). Elapsed times are to a great part determined by > contention for CPUs and I/O (disk, controller); the latter can be a > problem even > in a lightly loaded systems (for example, two parallel threads or jobs > trying to > read from two different files that are on [...] 844 37 37_DB2 (AIX and Solaris) and SNMP Alerts13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Tue, 15 Feb 2000 11:29:25 +0000325_us-ascii I've been tasked with investigating setting up DB2 to provide SNMP alerts in the event of problems.

We have DB2 for AIX (V5.2) and want to send alerts to BMC's Patrol.

We also have DB2 for Solaris (V6.1) servers running our Web services, and these are managed by a third party.

Questions - [...] 882 104 61_Re: Grafton DB2 audit tool (was Re: DB2 hardware compression)4_DBAS14_dbas@CWCOM.NET31_Tue, 15 Feb 2000 11:45:48 -0000364_iso-8859-1 Hi, We use Grafton Audit tool v 3.3.1. I have found it to be horrendously DASD intensive as it does not apply the filters until after it as extracted and sorted the data from the the logs for the RBA range selected. It is not the easiest piece of software to debug and re-run. We will be looking into BMC logmaster as a more efficient alternative. [...] 987 151 30_Re: DB2 V5.1 & Parallelism....0_18_mebert@AMADEUS.NET31_Tue, 15 Feb 2000 13:00:45 +0100559_us-ascii Well if you reread what I wrote you will discover that we're in full agreement. I am also saying that the long-running, I/O-bound, parallelisable, simple query is a rare beast indeed (I don't know of any in our environment) and so the usage of parallelism will (should) be also. Actually, if you've got more than one or two of these, running the jobs in parallel might gain you more than sequentially running parallelised jobs. In our CSC, the DSS-type queries - which one would expect to be the prime beneficiaries - are the worst CPU hoggers. [...] 1139 457 55_Re: Listing Databases for an Instance (UDB v6.1 on AIX)13_Lynne Flatley17_LFlatley@NEFN.COM31_Tue, 15 Feb 2000 07:25:39 -0500478_iso-8859-1 Philip, Scott, and Bill, Actually, it would be REALLY neat(!) if you guys would post your scripts on our DB2-L-DOCUMENTS web site (by emailing your scripts as attachments with a file extension other than .txt) to db2-l-documents@ryci.com.

Thanks!

-----Original Message----- From: Philip Nelson [SMTP:teamdba@ATTGLOBAL.NET] Sent: Tuesday, February 15, 2000 4:41 AM To: DB2-L@RYCI.COM Subject: Re: Listing Databases for an Instance (UDB v6.1 on AIX) [...] 1597 45 36_Re: QUery on clustering of DB2 on NT0_21_FNovak@SCHOLASTIC.COM31_Tue, 15 Feb 2000 07:56:23 -0500590_- We just started looking into it also. According to IBM DB2 UDB EE or EEE is MSCS aware.

Frank Novak Scholastic, Inc. Ph. (201) 372-2475 Beeper: (917) 380-9126 e-mail FNovak@scholastic.com



> -----Original Message----- > From: Pramod S ( Benchmark) [SMTP:pramods@WIPRO.CO.IN] > Sent: Monday, February 14, 2000 11:59 PM > To: DB2-L@RYCI.COM > Subject: QUery on clustering of DB2 on NT > > Hi, > I am a new member to the list. I want to know if it is possible to > use DB2 in a Microsoft clustering(wolfpack) scenario. I.e. Is DB2 on NT, > cluster aware. If so can [...] 1643 46 18_Re: Isolation (UR)19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 15 Feb 2000 07:28:58 -0600622_x-user-defined Dean, Yes, any Utility that drains all claimers could cause a -911/913, i.e. LOAD REPLACE. See DB2 for OS/390 V5, Admin. Gde., bookmanager ref. 5.7.5.4.4 Advantages and Disadvantages of the Isolation Values

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 [...] 1690 367 30_Re: DB2 V5.1 & Parallelism....20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 15 Feb 2000 08:54:23 -0500464_iso-8859-1 >>..(Also I'm curious - how can your machine run at "over 100%"?? Impossible, I'd say) Dr.Ebert

I have seen some monitor show m/c run over 100%. The reason for this they extrapolated CPU as if there was a single processor. For example if you look at TMON MVS and add %CPU utilized you will see that the sum can exceed 100%. However if you count the services units they don't exceed the limit. It is just the way monitors project their data. [...] 2058 50 36_Re: QUery on clustering of DB2 on NT14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 15 Feb 2000 09:12:55 -0500340_iso-8859-1 Pramond, DB2 UDB can use Microsoft Cluster Server (MSCS) Wolfpack clustering. I know Merrill Lynch was using Wolfpack in their UDB NT application that was presented at last year's tech conference. The details are covered in Chapter 14 of the DB2 V6 UDB Adminstration Guide: Design and Implementation, SC09-2839-00. HTH Phil [...] 2109 86 48_DB2 upgrade to V6 cause resources' usage change?12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Tue, 15 Feb 2000 16:27:41 +0200382_x-user-defined Hello.

Does migration (same workload and same operating system) from DB2 for MVS V4 to UDB for OS/390 V6 (via V5) cause increasing (or perhaps decreasing) of OS/390 resources such as CPU usage, virtual memory, dasd I/O etc. ?

What has been customer experience?

Is there any documentation on resource utilization after migration experiences? [...] 2196 75 49_Re: Where to find good benchmarking info for UDB?11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Tue, 15 Feb 2000 09:36:39 -0500610_iso-8859-1 Richard,

Bruce Allen gave some good general guidelines from the doc. Actual memory usage, as his experience showed, varies by application and the DB2 UDB features in use.

As for tracking and trending memory use, CPU usage, and paging, you could carefully monitor the output from 'vmstat' or maybe 'sar'. On vmstat, look at 'avm', multiply by 4096, then divide by 1048576 for an idea of how much memory is in use. If you track average use by hour/period and average number of connections by hour/period, you should get a real good feel for your memory requirements per connection. [...] 2272 34 41_How to update a column having length 390020_Baskaran Subramaniam27_subramaniam.baskaran@DB.COM31_Tue, 15 Feb 2000 20:08:40 +0530351_us-ascii Hi All

We are an OS/390, DB2v5 site and we have a table with a varchar column length of 3900 and we want to update this column.

The problems we have faced

1. Since this column contains non-displayable values(special characters), we are unable to update using QMF.When tried with QMF we are getting the following msg [...] 2307 52 16_SQR0263(SQR0253)16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Tue, 15 Feb 2000 10:08:00 -0500437_iso-8859-1 I need another set of eyes from all the experts.

Background PeopleSoft Financials two subsystems 4 instances in SS 1 (DBFD) 1 instances in SS 2 (DBFP) Versions SQR = 4.1 DB2 = 5.1 9811 PeopleTools = 7.54 PS App = 7.52



SS DBFD all SQR programs are running ok. SS DBFP all SQR programs tested run ok EXCEPT SYSAUDIT (an audit job comparing Peoplesoft and DB2 objects, ensuring all objects were built) [...] 2360 12 20_Re: SQR0263(SQR0253)18_Richard Mccutcheon32_Richard_McCutcheon@HCM.HONDA.COM31_Tue, 15 Feb 2000 10:12:11 -0500290_us-ascii Steve please resend the error..........

================================================ 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. 2373 181 25_Re: Can anyone EXPLAIN...17_Linda F. Claussen18_lindafc@NETINS.NET31_Tue, 15 Feb 2000 09:11:03 -0600467_ISO-8859-1 Sorry, thanks for the catch Terry.

---------- From: Purcell, Terry To: DB2-L@RYCI.COM Subject: Re: Can anyone EXPLAIN... Date: Monday, February 14, 2000 8:29 PM

Linda,

That's incorrect. The COALESCE solved the mismatch of nullability, thereby making the statement stage 1 and indexable (for a non-correlated subquery). This is exactly how Peter had explained it in his original mail below. [...] 2555 70 45_Re: How to update a column having length 390012_John Cameron26_jcameron@MSI-INSURANCE.COM31_Tue, 15 Feb 2000 09:11:08 -0600496_us-ascii I've used SPUFI for updating varchars. You can 'wrap' the text from columns 1 through 72, up to a length of 254. When you exceed 254, CONCAT strings together. It does work !

John Cameron jcameron@msi-insurance.com









Baskaran Subramaniam @RYCI.COM> on 02/15/2000 08:38:40 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List [...] 2626 30 18_Re: Isolation (UR)14_Wayne Driscoll19_wdriscoll@QUEST.COM31_Tue, 15 Feb 2000 07:34:34 -0800355_x-user-defined Dean, Yes, this is possible, because the UR isolation level only applies to the data in the objects being accessed. Locks are still acquired on the objects DBD as well as on the plans and packages in use. Hope this helps. Wayne Driscoll Product Developer Quest Software Inc. wdriscoll@quest.com Note: All opinions are strictly my own. [...] 2657 17 25_Limiting resources in DB212_Andy Wheeler25_Andy.Wheeler@GRIZZARD.COM31_Tue, 15 Feb 2000 10:32:02 -0500465_iso-8859-1 Does anyone have (or know where I can find) a comprehensive plan that can detect and limit problems with DB2 that might take over a system (runaway tasks)?. We are a V5 shop on an OS/390.

TIA, Andy Wheeler

================================================ 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. 2675 31 45_Re: How to update a column having length 390013_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 15 Feb 2000 10:55:40 -0500375_iso-8859-1 Hello Baskar,

As John Cameron pointed out, you can use Spufi with concatenation to update it.

If you have File-AID for DB2, you can use the full-screen ISPF-like edit capabilities to enter or update columns. To confirm that we have no problems with columns of that size, I added a varchar(3900) column and added a row using the File-AID editor. [...] 2707 99 52_Re: DB2 upgrade to V6 cause resources' usage change?22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Tue, 15 Feb 2000 15:05:41 +0000525_ISO-8859-1 Jacob from what I have seen there is an increase in Virtual Memory usage from V5 to V6 (DB2 Storage) as follows :

V5 Non DS - 213Mb V5 DS - 294Mb V6 Non DS - 231Mb V6 DS - 312Mb

Thought this might be a start for you ..

regards

Leslie Pendlebury-Bowe



______________________________ Reply Separator _________________________________ Subject: DB2 upgrade to V6 cause resources' usage change? Author: Jacob Ganzel at Internet Date: 2/15/00 4:27 PM [...] 2807 29 17_DB2 Connect - SNA15_Michael Bancale21_mbancale@TXFB-INS.COM31_Tue, 15 Feb 2000 09:57:37 -0600395_iso-8859-1 We have a DB2 Connect server running V6 of the Enterprise edition of DB2 connect. We have a Visual Basic application being developed which will return around 300,000 rows. When this application runs the LU 6.2 terminal sessions die anywhere from 2 seconds into the application up to 7 minutes into the application. This application has completed one time and it took 10 minutes. [...] 2837 30 12_Lock problem9_Sally Mir15_smir@BCBSGA.COM31_Tue, 15 Feb 2000 11:09:13 -0500380_us-ascii We have a strange situation -- A -DIS DB(dbname) SPACE(tsname) LOCKS command shows locks being held on a tablespace page by a CICS transaction. However, a -DIS THREAD() command shows no active threads in that CICS region.

Any idea how I can resolve this? We're getting timeouts in other transactions trying to access this tablespace. Thank goodness it's only [...] 2868 54 45_Re: How to update a column having length 390011_rick creech18_ykcirc@HOTMAIL.COM29_Tue, 15 Feb 2000 08:09:50 PST322_- Hi, With Platinum RC/UPDATE you can enter the command EXPLODE on the command line and put the cursor on the column to edit and you will get all of the column when it it larger than 255. Also, you can enter HEX on the command line to get an edit block that works just like the HEX command in TSO/ISPF. Regards, Rick [...] 2923 74 16_Re: Lock problem0_19_Tim.Lowe@STPAUL.COM31_Tue, 15 Feb 2000 10:13:15 -0600767_us-ascii Sally, Could the locks be held by an indoubt thread? Try -DIS THREAD(*) TYPE(*)

I hope this helps.

Thanks, Tim













Sally Mir on 02/15/2000 10:09:13 AM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Tim Lowe/sfm/spc)





Subject: Lock problem















We have a strange situation -- A -DIS DB(dbname) SPACE(tsname) LOCKS command shows locks being held on a tablespace page by a CICS transaction. However, a -DIS THREAD() command shows no active threads in that CICS region. [...] 2998 46 21_Re: DB2 Connect - SNA14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 15 Feb 2000 11:18:35 -0500671_iso-8859-1 Michael, Can you provide any reason codes from the MSTR address space or aren't you getting any? What is IDTHTOIN and CMTSTAT set to? Phil

----- Original Message ----- From: Michael Bancale Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, February 15, 2000 10:57 AM Subject: DB2 Connect - SNA



We have a DB2 Connect server running V6 of the Enterprise edition of DB2 connect. We have a Visual Basic application being developed which will return around 300,000 rows. When this application runs the LU 6.2 terminal sessions die anywhere from 2 seconds into the application up to 7 minutes into [...] 3045 61 16_Re: Lock problem17_Hynes, Kenneth J.17_khynes@TRIGON.COM31_Tue, 15 Feb 2000 11:22:20 -0500343_iso-8859-1 Sally,

If you review your "history" on the transaction or CICS region you'll probably find that you had some ABEND or outage that left the thread in an "indoubt" status. Issue a "-RECOVER INDOUBT" Command with the appropriate fields and choices filled in -- probably ACTION (ABORT) on the CICS connection name involved. [...] 3107 98 45_Re: How to update a column having length 390019_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Tue, 15 Feb 2000 09:48:43 -0600577_iso-8859-1 Baskar, Set CHANGE DEFAULTS in SPUFI to YES. Set RECORD LENGTH to 3900 and BLOCK SIZE to 4096. This will allow you to edit the 3900 char. row. 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 [...] 3206 74 16_Re: Lock problem9_Sally Mir15_smir@BCBSGA.COM31_Tue, 15 Feb 2000 11:36:47 -0500582_us-ascii Thank you all! I knew it was something like that, but my monitor didn't show any INDOUBT threads. Once I displayed the threads by using the DB2 command, I saw it.

Thanks again for the quick help!

Sally Mir BCBS Ga

"Hynes, Kenneth J." wrote:

> Sally, > > If you review your "history" on the transaction or CICS region > you'll probably find that you had some ABEND or outage that left the thread > in an "indoubt" status. Issue a "-RECOVER INDOUBT" > Command with the appropriate fields and choices filled in -- probably > ACTION (ABORT) on [...] 3281 71 16_Re: Lock problem15_Rene Hendriksen16_reh@NOTES.BEC.DK31_Tue, 15 Feb 2000 17:29:43 +0100343_iso-8859-1 Check MSTR address for messages during forward and backward recovery in startup. Probably you'll not find anything there. Then try this cmd -DIS THD(*) TYPE(INDOUBT). If you succeed in finding your "lost" thread, notice the token for the thread and terminate it with the -RECOVER INDOUBT command or the -CANCEL THREAD command. [...] 3353 102 21_Re: DB2 Connect - SNA14_Philip Gunning20_pgunning@BOSCOVS.COM31_Tue, 15 Feb 2000 11:51:00 -0500530_iso-8859-1 Michael, I see it's the old gather the Pd info and contact your systems programmer or IBM type of error message. See if someone can look at sys1.logrec and see if you can glean any more info from that. Also, check the db2diag.log on the server or workstation, and have you run a ddcs trace? Check the PCOM log and see what you get out of that. I would suggest doing all of this plus checking IBMlink for the DSNL032I messages to see if there are any hits out there. I have found some on IBMlink in the past. After [...] 3456 17 27_DB2 Version 4 - Reorg Index0_19_PDOBBRAT@WAUSAU.COM31_Tue, 15 Feb 2000 10:46:48 -0600269_us-ascii What are the phases of a REORG INDEX utility? Is there a SORT phase and if so, when is the sort phase used? I have an old Redbook that indicates that the REORG INDEX includes a sort phase, however when running the reorg, I never see a sort phase invoked. [...] 3474 31 29_Re: Limiting resources in DB213_Kurt Sahlberg26_Kurt.Sahlberg@EXPERIAN.COM31_Tue, 15 Feb 2000 10:46:38 -0600380_US-ASCII Andy, take a look at RLF (resource limit facility) in DB2. it is documented in the ADMIN guide. HTH Kurt

>>> Andy Wheeler 02/15/00 09:32AM >>> Does anyone have (or know where I can find) a comprehensive plan that can detect and limit problems with DB2 that might take over a system (runaway tasks)?. We are a V5 shop on an OS/390. [...] 3506 21 37_Re: Selection of data off of tape GDG12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Tue, 15 Feb 2000 11:53:38 -0500358_iso-8859-1 Hi all, One of our daily jobs copies a table using CDBUTIL to a tape gdg. I am searching for a specific row of data and would like to avoid unloading the entire tape to disk. Does anyone know if you can code selection criteria in the unload JCL or do I need to unload the entire tape to disk? The JCL that I am using is listed below: <<...>> [...] 3528 53 16_Re: Lock problem14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Tue, 15 Feb 2000 12:01:41 -0500368_us-ascii I had a similar thing happen. The only resolution we could come up with was the bring the sub-system down and back-up then do a recover thread indoubt as the thread that could not be terminated came back up in an indoubt status. I would try all the other options of display thread before using this option. Do you see the thread in any monitor you have? [...] 3582 37 37_Re: Selection of data off of tape GDG15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Tue, 15 Feb 2000 12:07:40 -0500587_- THe JCL did not listed in your message, but did you try SORT with include options with your search criteria. HTH Bob Lawrence

-----Original Message----- From: Kalman, Jeff [SMTP:JKalman@UNCH.UNC.EDU] Sent: Tuesday, February 15, 2000 11:54 AM To: DB2-L@RYCI.COM Subject: Re: Selection of data off of tape GDG

Hi all, One of our daily jobs copies a table using CDBUTIL to a tape gdg. I am searching for a specific row of data and would like to avoid unloading the entire tape to disk. Does anyone know if you can code selection criteria in the unload JCL or do I need [...] 3620 26 35_Moving OS/390 DB2 catalog/directory11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 15 Feb 2000 09:37:37 -0800351_iso-8859-1 I need to move my OS/390 DB2 catalog and directory files off of 3380s to 3390s. I'm thinking of stopping DB2 and then using IDCAMS EXPORT/IMPORT to move the files. I used DSN1COPY to move my test DB2 files but for my production/devel subsystems I think using export/import will be quicker and involve less steps (renaming files etc.). [...] 3647 138 29_Re: Limiting resources in DB213_Brunner Don J21_Don.J.Brunner@IRS.GOV31_Tue, 15 Feb 2000 12:57:50 -0500428_ISO-8859-1 Speaking of the RLF, does anyone know if there is an accounting field which indicates that a thread terminated due to reaching an RLF limit? These type of threads don't appear on our timeout reports.

Thanks



-----Original Message----- From: Kurt Sahlberg [mailto:Kurt.Sahlberg@EXPERIAN.COM] Sent: Tuesday, February 15, 2000 11:47 AM To: DB2-L@RYCI.COM Subject: Re: Limiting resources in DB2 [...] 3786 30 30_Re: DB2 V5.1 & Parallelism....24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Tue, 15 Feb 2000 12:35:47 -0600587_- The problem with DEGREE=ANY is that it's an easy way to cause performance problems.

Shops that are already CPU constrained (running at or near 100% cpu) means that users are already experiencing CPU delays. Adding only a few users using DEGREE=10, for example, will mean that those users have, in effect, upped their priority on the system significantly. This enables a individual user to force their way thru a CPU bottleneck; but it is at the cost of every other DB2 user running at DEGREE=1. And not only have they punished others, for their own benefit, but if this is [...] 3817 21 14_Dynamic ZPARMs20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 15 Feb 2000 13:50:25 -0500535_us-ascii Dear list

Does any one know a way to use different ZPARM setting (or ZPARM from different library) valid just for one job step using a DB2 subsystem? I heard Frank Ingrassia has done this for Super explain by dynamically setting the bit.

Thanks in advance -Venkat Pillay

================================================ 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. 3839 24 47_DB2 NT V6.1 Install problem - Net Logon Service12_Mckay, Wayne24_Wayne.Mckay@ATCOITEK.COM31_Tue, 15 Feb 2000 11:57:02 -0700350_iso-8859-1 After Installing DB2 NT V6.1 Workgroup Edition we receive the following error when attempting to logon with either a local or domain user id, including the Administrator id:

'Unable to log you on because the netlogon service is not running on this machine'

Same error is received, even if an invalid user id is entered. [...] 3864 79 29_Re: Limiting resources in DB222_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 15 Feb 2000 14:04:18 -0500746_- I've used DFDSS to move the catalog/directory

//DFDSMOVE EXEC PGM=ADRDSSU,REGION=6M ,PARM='TYPRUN=NORUN' . //SYSPRINT DD SYSOUT=* . //SYSIN DD * COPY OUTDYNAM(tarvol) DATASET(INCLUDE( - hlq.DSNDBC.DSNDB01.** - hlq.DSNDBC.DSNDB06.** - )) - CATALOG - ALLDATA(*) ALLEXCP - SPHERE - DELETE



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

> ---------- > From: Brunner Don J[SMTP:Don.J.Brunner@IRS.GOV] > Sent: Tuesday, February 15, 2000 12:57 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Limiting resources in DB2 > > Speaking of the RLF, does anyone know if there is an accounting field > which indicates that a thread terminated due to reaching an RLF limit? > These type of [...] 3944 33 29_Re: Limiting resources in DB222_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 15 Feb 2000 14:16:21 -0500599_- Looks like the JCL statements & control cards were removed before posting to the list.

If your interested I can send it off-list or post it to DB2-L-Documents at > http://jupiter.ryci.com/archives/db2-l-documents.html > > Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com

> ---------- > From: Piontkowski Michael ML > Sent: Tuesday, February 15, 2000 2:04 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Limiting resources in DB2 > > I've used DFDSS to move the catalog/directory > > //DFDSMOVE EXEC PGM=ADRDSSU,REGION=6M ,PARM='TYPRUN=NORUN' > [...] 3978 41 20_Re: SQR0263(SQR0253)16_Cockerill, Steve30_SLCockerill@NATIONALGYPSUM.COM31_Tue, 15 Feb 2000 14:18:54 -0500398_windows-1252 Sorry the error screen shot didn't make it- this was the error. ( -TBZ -MDDN:MAXIN -DEBUGHV -S')

IKJ56641I DSN ENDED DUE TO ERROR+

IKJ56641I SYSTEM ABEND CODE 04E REASON CODE 00E20005 PSW 077C1000898C91BC ASI LSCX041 **** ERROR ****

ABEND occurred in line 966 of SQR0263(SQR0253),offset 0008FE

Program terminated by operating system. ABEND code = S04E [...] 4020 66 29_Re: Limiting resources in DB222_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 15 Feb 2000 14:22:42 -0500507_- Trying again, replacing the 2 forward slashes (//) with a ? in the JCL statements.

> I've used DFDSS to move the DB2 for OS/390 catalog/directory > ?DFDSMOVE EXEC PGM=ADRDSSU,REGION=6M ,PARM='TYPRUN=NORUN' . ?SYSPRINT DD SYSOUT=* . ?SYSIN DD * > COPY OUTDYNAM(tarvol) > DATASET(INCLUDE( - > hlq.DSNDBC.DSNDB01.** - > hlq.DSNDBC.DSNDB06.** - > )) - > CATALOG - > ALLDATA(*) ALLEXCP - > SPHERE - > DELETE > > > Mike Piontkowski Voice/Fax: 302.886.4612 mailto:michael.piontkowski@astrazeneca.com [...] 4087 31 29_Re: Limiting resources in DB222_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 15 Feb 2000 14:41:53 -0500516_- Rats - blocked again...



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

> ---------- > From: Piontkowski Michael ML > Sent: Tuesday, February 15, 2000 2:22 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Limiting resources in DB2 > > Trying again, replacing the 2 forward slashes (//) with a ? > in the JCL statements. > > > I've used DFDSS to move the DB2 for OS/390 catalog/directory > > > ?DFDSMOVE EXEC PGM=ADRDSSU,REGION=6M ,PARM='TYPRUN=NORUN' > [...] 4119 51 18_Re: Dynamic ZPARMs12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Tue, 15 Feb 2000 14:04:17 -0600408_iso-8859-1 ZPARM's can be changed dynamically. BMC has a product that does this. Frank's solution does change one bit in the zparm, but to my knowledge this change is in effect for the entire DB2 subsystem. The reason this works is because of uniqueness in how the additional explain tables are allocated, thus allowing normal explains to occur without knowledge of the Super Explain additional tables. [...] 4171 113 16_Re: Lock problem13_John Arbogast16_jfarbo@YAHOO.COM31_Tue, 15 Feb 2000 12:08:04 -0800546_us-ascii Sally -

Which monitor are you using. We have had some trouble seeing indoubt threads with OmegamonII/DB2 from candle. Just curious...



--- Sally Mir wrote: > Thank you all! I knew it was something like that, > but my monitor didn't show any INDOUBT threads. > Once I displayed the threads by using the DB2 > command, I saw it. > > Thanks again for the quick help! > > Sally Mir > BCBS Ga > > "Hynes, Kenneth J." wrote: > > > Sally, > > > > If you review your "history" on the > transaction or [...] 4285 129 16_Re: Lock problem20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Tue, 15 Feb 2000 15:10:53 -0500600_us-ascii Just in case you have data-sharing then -DIS THREAD has scope member. This means that a in-doubt thread from member_a can't be viewed from member_b of data sharing group.

> -----Original Message----- > From: John Arbogast [SMTP:jfarbo@YAHOO.COM] > Sent: Tuesday, February 15, 2000 3:08 PM > To: DB2-L@RYCI.COM > Subject: Re: Lock problem > > Sally - > > Which monitor are you using. We have had some trouble > seeing indoubt threads with OmegamonII/DB2 from > candle. > Just curious... > > > --- Sally Mir wrote: > > Thank you all! I knew it was something like [...] 4415 84 30_Re: DB2 V5.1 & Parallelism....14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 15 Feb 2000 14:35:32 -0500362_iso-8859-1 DEGREE=ANY does not cause performance problems by itself, nor does it automatically enable parallelism for that particular bind. When required, parallelism can alleviate performance problems by getting long running processes out of the way quicker, even at 100% CPU. This is a classic case of analysis and performance dependencies -- it depends. [...] 4500 17 25_UDB Log space calculation11_Paul Mayhew15_mayhewp@CIBC.CA31_Tue, 15 Feb 2000 15:41:16 -0500353_us-ascii Does anyone out there have a good calculation for estimating log requirements?



TIA 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. 4518 89 42_Re: Using the DB2 log for billing purposes22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Tue, 15 Feb 2000 15:58:53 -0500655_- MXG (http://www.mxg.com), can process DB2 IFCID accounting records. You might be able to use MXG for billing based on the DB2 IFCID accounting records. Keep in mind that MXG requires SAS.



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

> ---------- > From: Leblanc, Francis C - CNF[SMTP:Leblanc.Francis@CNF.COM] > Sent: Friday, February 11, 2000 4:09 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] Using the DB2 log for billing purposes > > Actually, it's not CA. It separated from Platinum about a week before > Platinum sold out to CA. CA also has a product in this area, but I did > not [...] 4608 29 27_DB2 High Performance Unload13_Burgess Evans27_BMEVANS@AUDITOR.STATE.OH.US31_Tue, 15 Feb 2000 16:27:44 -0500353_US-ASCII Hi All,

I was just reading about IBM's DB2 High Performance Unload and I was wondering if anyone is using it. We have been looking for an easy way for our programming staff to populate test tables with current production data or old production data from a specific image copy. Up until now I have done this for them using DSN1COPY. [...] 4638 110 31_Left outer join not consistant?14_Jessen Michael29_JessenMichel@JDCORP.DEERE.COM31_Tue, 15 Feb 2000 15:39:58 -0600590_iso-8859-1 I'm stumped & humbled... This is DB2 v5.1 on OS/390. Basically, my query is simple:

select table1.fielda, sum(lease_info.fieldb) from table1 left outer join lease_info on table1.field1 = lease_info.field1 where lease_info.field2 is null group by table1.fielda.

tablea is actually a select from multiple tables. for certain dealers, I get the expected results - values for table1 when values for lease_info do not exist. on other dealers, I can run the table1 query standalone and get a value, but when I left outer join on lease_info, no results are returned. [...] 4749 66 31_Re: DB2 High Performance Unload0_22_BILL_GALLAGHER@PHL.COM31_Tue, 15 Feb 2000 16:50:05 -0500566_us-ascii Burgess,

We have the product in house, and I have played with it a little. You should have no problem unloading from an image copy on one subsystem and loading into another. It just creates a sequential unload file, just as if you were running DSNTIAUL against the live tablespace.

The only real restriction that I have found in using the product (compared to DSNTIAUL) is that you can only unload from one tablespace at a time . . . you cannot unload a join of more than one table, even if both tables reside in the same tablespace. But [...] 4816 143 35_Re: Left outer join not consistant?14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Tue, 15 Feb 2000 17:02:45 -0500313_us-ascii Try removing the WHERE clause and see if you get any data back from the query. The WHERE clause in your query is applied after the outer join of table1 and lease_info. If you need the WHERE clause to be applied before the outer join of table1 and lease_info, then code the query like the following: [...] 4960 23 21_Pro for DB2 by Legent14_Bistricer, Avi20_BistricerA@CONED.COM31_Tue, 15 Feb 2000 16:52:55 -0500535_windows-1252 Years ago we got from Legent, a free windows based software which is a quick reference for DB2, called ‘PRO For DB2’.

Does anyone know how to get the DB2 V5 upgrade of this (or similar software)

It looks like this. Thanks



Avi Bistricer, DBA 212.460.6695

===============================================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. 4984 40 39_Re: Moving OS/390 DB2 catalog/directory13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Tue, 15 Feb 2000 15:54:01 -0600616_iso-8859-1 I have used DFDSS to do this. It works very well.

-----Original Message----- From: Cliff Boley [mailto:Maurice.C.BOLEY@ODOT.STATE.OR.US] Sent: Tuesday, February 15, 2000 11:38 AM To: DB2-L@RYCI.COM Subject: Moving OS/390 DB2 catalog/directory



I need to move my OS/390 DB2 catalog and directory files off of 3380s to 3390s. I'm thinking of stopping DB2 and then using IDCAMS EXPORT/IMPORT to move the files. I used DSN1COPY to move my test DB2 files but for my production/devel subsystems I think using export/import will be quicker and involve less steps (renaming files etc.). [...] 5025 154 35_Re: NFS mounted drives and UDB v5.212_Janet Rolsma12_janet@NM.NET31_Tue, 15 Feb 2000 15:34:03 -0700270_us-ascii I haven't tried the DB2 backup and restore.

As you say, just because you can do something doesn't mean you should. That's why I was hoping someone else out there had tried this before. Oh well. I guess I'll just be a pioneer.

Thanks, Janet

5180 216 25_Re: Can anyone EXPLAIN...14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Wed, 16 Feb 2000 11:02:25 +1100398_iso-8859-1 Don't worry Linda, in my haste to shoot you down I didn't adequately answer Peter's question.

Peter,

Pre-V5 the optimizer favoured primary key indexes, even if an index-only alternative was available.

Since both indexes have the same two primary columns, it seems obvious that ICPV2 is the better choice as it is indexonly (that's why you raised the question). [...] 5397 44 31_Re: DB2 High Performance Unload12_INFO_SYSTEMS26_INFO_SYSTEMS@EMAIL.MSN.COM31_Tue, 15 Feb 2000 16:07:41 -0800399_- I haven't used IBM's Unlaod but I do use Infotel's Unload. You can unload from an image copy and reload this data into another system.

Donald Jackson 310-605-3458 -----Original Message----- From: Burgess Evans Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: Tuesday, February 15, 2000 1:29 PM Subject: DB2 High Performance Unload [...] 5442 19 39_Re: Moving OS/390 DB2 catalog/directory0_17_JTonchick@AOL.COM29_Tue, 15 Feb 2000 19:15:31 EST350_US-ASCII If you just need to move the vsam files from one pack to another while the DB2 is down, try DFDSS. You can set up control cards to mask the dataset names to move from one volser to another. I used it when we moved from IBM 3390's to EMC. Worked like a champ, and I didn't need to use DB2 utilities that are unfamiliar to DASD managers. [...] 5462 30 22_NEW INDEXES ON SYSCOPY28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Tue, 15 Feb 2000 15:09:35 PST570_- It turns out that user defined indexes over SYSCOPY will *NOT* help the performance of MODIFY. The internal protocols we use to access SYSCOPY are not sensitive to user defined indexes. They are ignored.

So until we fix MODIFY internally, your best course of action is to:

1) Increase PCTFREE on SYSCOPY and its indexes DSNUCH01 and DSNUCX01 It is shipped at 5%...try 10%. REORG after the ALTER for it to take affect. 2) Run MODIFY regularly so that SYSCOPY size does not get out of hand. 3) If you must delete a large number of SYSCOPY rows, do it [...] 5493 151 35_Re: Left outer join not consistent?14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 15 Feb 2000 18:41:58 -0500544_iso-8859-1 Yes, that is probably correct for your query in DB2 V5. All WHERE clauses are after join step predicates, applied after the join is finished which is essence can remove some of the rows you are looking for. The WHERE predicate is not local in V5. (NOTE: In V6, it would be correct and you would not have to rewrite it). Your where predicate basically only accepts rows that don't have a match in table lease_info as well as those where field2 is actually null, and it does not appear that is the result you want. If it is, then [...] 5645 32 17_regarding locking17_ravi kumar hassan18_ravibh@HOTMAIL.COM29_Tue, 15 Feb 2000 17:20:21 PST353_- Hello Everybody,

I have a problem in running a job, actually my job is just reading a data from the production tables. my job is already started running on the prod. tables. but one more job started running after two hour for updating, loading the data to same tables. now this job got abended. they said because of my job it got abended. [...] 5678 62 21_Re: regarding locking14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Tue, 15 Feb 2000 19:50:47 -0500292_iso-8859-1 Ravi,

Help us out a little please. What are the isolation levels? Are the others utilities? If utilities, whose IBM or vendors? What caused the abend -- was it abend or a SQL code? If it was a SQL code, what was it? For example, were the others abended with a timeout? [...] 5741 274 25_Re: Can anyone EXPLAIN...13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 16 Feb 2000 08:22:28 +0530479_us-ascii I would like to a dd few of me observations. In DB2 Version 5 I saw something new as compared to DB2 V 2.3 .

The table has a primary key and has a unique index on C1 and C2 , I write a query select c1,c2,c3,c4 from t1 where c1 = :hostvar , and if I explain this it does not use and index fetch. I does a tablespace scan. At the same time If I add "where c1 = :hostvar1 and c2 = hosvar2 " it changes to indexonly access. Now the same query was doing an index [...] 6016 20 44_Datacom/DB and DB2 in the same Cobol program10_John Clark20_pak02449@PIXIE.CO.ZA31_Wed, 16 Feb 2000 08:53:14 +0530413_iso-8859-1 Has anyone out there managed to achieve this and if so any pointers on funnies on compiling/linking etc.

Regards



John Clark - Connection42

================================================ 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. 6037 56 37_FW: JAVA with DB2 Version 6 on OS/39014_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Tue, 15 Feb 2000 23:26:44 -0800347_- Hari,

There's not a huge amount of information on this right now.

I'm currently co-authoring a Red Book specifically on this subject which should be out in a month or two, but in the meantime there's some excellent background information in another recent Red Book called The Java Programming Guide for OS/390 (SG24-5619-00). [...] 6094 19 39_Re: Moving OS/390 DB2 catalog/directory14_Massimo Scarpa16_mscarpa@CESVE.IT31_Wed, 16 Feb 2000 08:42:01 +0100462_us-ascii Why don't use ADRDSSU (DFDSS) program ? We use DFDSS to move all DB2 object from a DASD to another. It's the standard utility to move physical files.

Regards Max Scarpa Data & System Admin CESVE SpA Italy

================================================ 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. 6114 310 25_Re: Can anyone EXPLAIN...14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Wed, 16 Feb 2000 18:45:09 +1100590_iso-8859-1 Vishy,

The optimizer is actually improving every release of DB2 (barring any optimizer bugs for which there are PTFs).

I assume your statement "changes to index-only access", should be index access (matchcols 2) with data access; as you are selecting some non-indexed columns.

What are the firstkeycard and fullkeycard values for that index? If the cardinality of C1 is such that it does very little filtering, then the V5 optimizer may recognise this and revert to a tablespace scan, whereas in V2.3 it did not (I'm not on V2.3 so I cannot test this). [...] 6425 356 25_Re: Can anyone EXPLAIN...13_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Wed, 16 Feb 2000 13:20:39 +0530369_us-ascii Terry ! Its nothing related to the cardinality as the columns are all unique columns so filtering will take place max . Its how the optimiser behaves. After migration we had to fine tune a lot of applications which use to access using partial index in db2 v 2.3 . but now we have to give the full key as in the where clause , to force it to index access. [...] 6782 52 48_Re: Datacom/DB and DB2 in the same Cobol program9_Chris Tee18_TEECHRI@UK.IBM.COM31_Wed, 16 Feb 2000 08:42:15 +0000365_us-ascii John,

We had programs calling both Datacom and DB2 at Southern Life. Are you running in a batch or CICS environment? I'm not sure whether there is anybody left at Southern that you can contact. Drop me a note off-list if you want.



Regards

Chris Tee

DB2 Systems Programmer IBM UK DB/DC Systems Support North Harbour [...] 6835 89 31_Re: DB2 High Performance Unload9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 16 Feb 2000 08:47:05 +0000567_us-ascii David Stritzinger (another contributor to this list) did find slow response for certain 'unload' SQL. He raised the problem with IBM and determined the following,

We have two open issues with IBM on this product: > > 1) To get the "high performance" out of the unload, the Where and > Order By clauses must reference FIXED length columns. The unload can NOT > deal with VARCHAR without using DB2 to do the extract. IBM can back and > confirmed this "feature" and have created APAR PQ35117 to resolve this > issue. > > 2) The unload can only work [...] 6925 93 35_merge scan join vs nested loop join29_Sand, Sverre (FUNDI at Alcoa)24_Sverre.Sand@ALCOA.COM.AU31_Wed, 16 Feb 2000 17:03:11 +0800330_- Hi, I have two queries where the only difference is:

Q1: AND A.ACCOUNT BETWEEN 'R000' AND 'R999'

Q2: AND ( A.ACCOUNT BETWEEN 'R000' AND 'R999' OR A.ACCOUNT BETWEEN 'Q000' AND 'Q999')



Q1 is doing a nested loop join, while Q2 is doing a merge scan join. Obviously Q2 is "a million times" faster. [...] 7019 15 18_QSP Universal OLAS15_MAHSOUN, KHALID29_kmahsoun@SAUDIAIRLINES.COM.SA31_Wed, 16 Feb 2000 11:08:54 +0300423_- Hi We about to implement QSP financial package universal OLAS ( OS/390/DB2 V4) when we tested it we have some performance concern dose any one Using it if so please help with tips

================================================ 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. 7035 114 31_Re: DB2 High Performance Unload24_Marchese, Frank D, CSCIO18_fdmarchese@ATT.COM31_Wed, 16 Feb 2000 08:36:33 -0500304_iso-8859-1 Hi folks - I am intrigued reading about IBM's hiperf unload. We use current DSNTIAUL heavily and would love something that could be significantly quicker. We are DB2 V5 OS/390. Is this an add'l cost product ? Is it GA right now ? Anyone out there know ? Is it DB2 release dependent ? TIA [...] 7150 304 25_Re: Can anyone EXPLAIN...19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 16 Feb 2000 07:37:46 -0600413_iso-8859-1 Vishy, I'm confused. First, if you are selecting c1, c2, c3, and c4 from a table and the index selected by the Optimizer contains only c1 and c2, you cannot achieve index-only access. Don't you mean MATCHCOLS=2. Second, what is FIRSTKEYCARDF and FULLKEYCARDF for the index(es)in question? Related questions. RUNSTATS been performed on table/indexes? Does RUNSTATS update all columns in the table? [...] 7455 25 4_Help14_subrata mondal25_subratamondal@HOTMAIL.COM29_Wed, 16 Feb 2000 13:42:59 GMT417_- Can anyone help me in deciding which is a better tool - Business Objects or some other reporting tool.

well I have to handle at leats 800 reports for my client and I am booged down. I heard that there are a lot of reporting tools.

Pl enlighten.

Thanks and Regards subrata

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com [...] 7481 15 20_Primary Key Question0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 16 Feb 2000 08:51:50 -0500361_us-ascii Can someone give me a query against the SYSIBM catalog tables to find the primary key for a table?

Dean

================================================ 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. 7497 122 24_Re: Primary Key Question0_22_The-Thanh.Luong@AGF.BE31_Wed, 16 Feb 2000 15:00:22 +0100273_- Hi,

We are in V4 of DB2. I use this query:

SELECT TBCREATOR ,TBNAME ,NAME ,KEYSEQ FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR = 'owner' AND TBNAME = 'tablename' AND KEYSEQ > 0 ORDER BY TBNAME ; -- NOTE THAT KEYSEQ = COLUMN'S RELATIVE POSITION WITHIN TABLE'S P.K. 7620 14 24_Re: Primary Key Question16_Thomas E. Faglon21_tfaglon@TELCORDIA.COM31_Wed, 16 Feb 2000 09:03:53 -0500342_us-ascii Try this one select name, tbname , uniquerule from sysibm.sysindexes wher uniquerule = 'p';

================================================ 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. 7635 34 24_Re: Primary Key Question13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR31_Wed, 16 Feb 2000 15:58:21 +0200461_windows-1254 Hello Dean,

in sysibm.syscolumns the keyseq number is the sequence number of the primary key of the selected table(tbname)



-----Original Message----- From: db46@DAIMLERCHRYSLER.COM [mailto:db46@DAIMLERCHRYSLER.COM] Sent: Wednesday, February 16, 2000 3:52 PM To: DB2-L@RYCI.COM Subject: Primary Key Question



Can someone give me a query against the SYSIBM catalog tables to find the primary key for a table? [...] 7670 157 31_Re: DB2 High Performance Unload9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 16 Feb 2000 14:07:16 +0000445_us-ascii I believe it is available (at additional cost) - program number 5697-F44. V1.1.0 supports DB2 V3 onwards. Kind Regards, Andy Hunt - Scottish And Southern Energy







"Marchese, Frank D, CSCIO" on 16/02/2000 13:36:33

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: DB2 High Performance Unload [...] 7828 143 35_Re: Left outer join not consistant?14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 16 Feb 2000 09:31:17 -0500694_iso-8859-1 Try rewriting it as follows:

select table1.fielda, sum(a.fieldb) from table1 left outer join (select * from join lease_info where lease_info.field2 is null) as a on table1.field1 = a.field1 group by table1.fielda.



Manas.

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jessen Michael > Sent: Tuesday, February 15, 2000 4:40 PM > To: DB2-L@RYCI.COM > Subject: Left outer join not consistant? > > > I'm stumped & humbled... This is DB2 v5.1 on OS/390. > Basically, my query is simple: > > select table1.fielda, sum(lease_info.fieldb) > from table1 left outer join lease_info > on table1.field1 [...] 7972 43 24_Re: Primary Key Question19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 16 Feb 2000 08:31:01 -0600596_iso-8859-1 Dean, SELECT CREATOR, NAME, UNIQUERULE FROM SYSIBM.SYSINDEXES WHERE UNIQUERULE = 'P' AND DBNAME = 'dbname' ORDER BY CREATOR, NAME; Leave out DBNAME = 'dbname' if you wish to see all PKs in a subsystem. Or use TBCREATOR and TBNAME for a specific table.

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 [...] 8016 66 29_Re: UDB Log space calculation11_Scott Hayes34_faster.databases@DATABASE-GUYS.COM31_Wed, 16 Feb 2000 09:41:51 -0500584_iso-8859-1 Paul,

I waited to see if anyone else was going to chime in on this... no takers yet, so here's some thoughts:

1) Large total quantity, separate file system, mirrored 2) It depends 3) Monitor usage carefully and religiously 4) Understand how large your units of work are, DML / commit. 5) Understand average and high water mark for concurrent connections 6) Understand which tables are the most frequently written, ranked by 'rows written', and find the average row width of the top 75% 7) Multiply average row width x 2 x #4 x #5, then add at least 500% [...] 8083 29 34_Why use primary keys in Version 5?12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Wed, 16 Feb 2000 09:48:24 -0500602_iso-8859-1 I'm installing a new release of 3rd-party software for mainframe DB2 (we're on V5, but I'm the software is good at V4, maybe earlier). In this release, for the first time, primary keys are included on roughly half the tables. However, no foreign keys are defined. Do primary keys without foreign keys accomplish anything significant? I noticed in a recent posting that, pre-V5, the indexes associated with primary keys were preferred over other indexes. But do they affect anything in V5 and/or V6? For that matter, in V5 and later, since foreign keys can refer to any unique index, is [...] 8113 59 38_Re: Why use primary keys in Version 5?14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Wed, 16 Feb 2000 10:24:13 -0500381_iso-8859-1 I like primary keys because it forces you to have a unique key on the table. If you did not have a primary key you could accidentally drop the unique index and not know about it and populate the table with duplicate data. With primary index, if you dropped the index supporting the primary key you would get "incomplete table definition" or something of that sort. [...] 8173 27 27_Reorg Plus - duplicate keys13_Karen Broskey20_kbroskey@METLIFE.COM31_Wed, 16 Feb 2000 10:15:48 -0500438_us-ascii Hi all! I'm new to this list and I have a quick question regarding BMC's Reorg Plus that I'm hoping someone can help answer.

I'm running a reorg against all partitions of a table and duplicate keys were found in one of the partitions. What does the utility do with these duplicates? Is one row loaded and the rest discarded or are all discarded?? I don't care which keys were duplicates, as long as one was retained. [...] 8201 34 48_Re: Datacom/DB and DB2 in the same Cobol program10_Pat Brazil27_pbrazil@MIDATLANTIC.AAA.COM31_Wed, 16 Feb 2000 10:17:58 -0500426_iso-8859-1 We have done this with no problem that I know of.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of John Clark Sent: Tuesday, February 15, 2000 10:23 PM To: DB2-L@RYCI.COM Subject: Datacom/DB and DB2 in the same Cobol program



Has anyone out there managed to achieve this and if so any pointers on funnies on compiling/linking etc. [...] 8236 232 35_Re: Left outer join not consistent?0_18_mebert@AMADEUS.NET31_Wed, 16 Feb 2000 16:38:52 +0100410_us-ascii You may have stumbled upon a bug in DB2 which I encountered about 5 months ago: when DB2 joins the tables by the MERGE SCAN method, the LEFT OUTER JOIN effectively degenerates to an INNER JOIN, i.e. no rows are returned if the right table has no entry for the join condition (I think I even posted this to the list). Check for APAR PQ27273, PTF UQ31440 (available 07/07/99) which fixes this bug. [...] 8469 66 31_Re: Reorg Plus - duplicate keys15_Toine Michielse18_vndobtm@US.IBM.COM31_Wed, 16 Feb 2000 07:35:54 +0000466_us-ascii Hello Karen,

I don't know what BMC's REORG+ would do. I suggest you check the manual....But I would certainly want to know why you have duplicates in there???? I'm assuming that you have a unique index defined and that you have violations of the UNIQUE index.

Regards,

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 8536 55 19_CSP V3.3 and DB2 V54_DBAS14_dbas@CWCOM.NET31_Wed, 16 Feb 2000 15:47:38 -0000304_iso-8859-1

We are currently running CSP V3.3 and plan to upgrade to V5 of DB2 in the very near future. Unfortunately we are not able to upgrade CSP before the DB2 V5 upgrade. Does anyone know whether this old release of CSP will run under DB2 V5, if not what sort of problems can we expect. [...] 8592 26 16_DSNL511I Message15_Jones, Scott A.15_scjones@CSW.COM31_Wed, 16 Feb 2000 09:53:43 -0600676_- Has anyone out there experienced this error using DB2 Connect? Thanks.

DSNL511I : DSNLIENO TCP/IP CONVERSATION FAILED TO LOCATION 161.235.9.148 IPADDR=161.235.9.148 PORT=1627 SOCKET=READ RETURN CODE=1121 REASON CODE=00000000

Scott Jones Data Base Consultant

Central and South West Services, Inc. Voice: (918) 594-2624 Fax: (918) 594-3877 www.csw.com scjones@csw.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. 8619 51 27_FW: DB2 Row Archive Manager14_David, Osborne27_Osborne_David@COMPUWARE.COM31_Wed, 16 Feb 2000 11:08:30 -0500671_iso-8859-1 Scott, If you already own File-AID/RDX you can use it to Archive your Data. There is a description of the archival process on http://www.compuware.com/products/file/.

Osborne David Product Planner - File-AID/RDX. Compuware Corporation

-----Original Message----- From: Jones, Scott A. [mailto:scjones@CSW.COM] Sent: Friday, February 11, 2000 9:13 AM Subject: DB2 Row Archive Manager



Has any one out there had any experiece with IBM's DB2 Row Archive Manager? Have you looked at it and decided to go with a competitor? Are there other products that function the same, i.e. Archive for DB2 from Princeton/SOFTECH, other vendors? [...] 8671 27 15_BufferPool Tool18_Whittaker, Stephen26_stephen.whittaker@CPLC.COM31_Wed, 16 Feb 2000 07:19:42 -0500322_iso-8859-1 We currently purchased this tool from IBM and its Version 1 Release 1 and I'm trying to use this tool on our DB2 V5 OS/390 system. Has anyone out there been using this tool and if so could I ask you a few questions on the inner workings of this product? We can take it off-line from this discussion group. [...] 8699 34 29_Re: Limiting resources in DB211_Hayden, Lee18_Lee_Hayden@CSX.COM31_Wed, 16 Feb 2000 08:16:30 -0500374_iso-8859-1 Andy,

DB2 has a simple limit facility for dynamic SQL only (RLF) but it only acts on CPU and cannot mask selection criteria.

I have used Relational Architects products Thread Stopper and Thread Sentry. These are very powerful and flexible products and can monitor many metrics with very flexible rules. See www.relarc.com for more information. [...] 8734 50 25_Re: Pro for DB2 by Legent14_Mullins, Craig21_Craig_Mullins@BMC.COM31_Wed, 16 Feb 2000 10:31:30 -0600533_iso-8859-1 I remember this 'product' and as far as I know it was never updated by Computer Associates after they acquired Legent. For a more comprehensive product that offers similar, but much more in-depth information about DB2 for OS/390, check out RevealNet at http://www.revealnet.com

The RevealNet Knowledge Base for DB2 should give you what you are looking for and much more. I believe you can download a free trial right over the web. (Of course, this product is not free, like the Legent software you mentioned.) [...] 8785 98 29_Re: UDB Log space calculation13_Umair Hussain25_umair_hussain@HOTMAIL.COM29_Wed, 16 Feb 2000 10:31:51 CST314_- just to add to scott's list ..... here are my few thoughtless thoughts -logs on a separate disk would be much better. -depending on your transaction type adjust your log filesize....too big a log filesize with not so heavy transaction activity is not good. -logging on a raw device can help (except linux). [...] 8884 48 39_Re: Moving OS/390 DB2 catalog/directory13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Wed, 16 Feb 2000 10:49:05 -0600469_us-ascii On suggestion from several of the list members last year, I used DFDSS to move tables, indexes, catalog, directory and BSDS from 3380 to 3390 pack. It worked great. Here is sample jcl for the catalog and directory moving from pack IM000E to DP070C.

//COPYDMP EXEC PGM=ADRDSSU,REGION=5M //SYSPRINT DD SYSOUT=* //SYSIN DD * COPY INDYNAM(IM000E) OUTDYNAM(DP070C) - DELETE - CATALOG - ALLDATA(*) - ALLEXCP - DATASET(INCLUDE(DSNP.DSNDBC.DSNDB0*.**)) // [...] 8933 64 20_Re: DSNL511I Message0_24_lightsey@ITS.STATE.MS.US31_Wed, 16 Feb 2000 10:50:47 -0600358_us-ascii We see this from time to time - my IP guy tells me that the 1121 means "connection reset by peer" which usually implies that there was a hiccup somewhere on the network between the client and the host OR that the client simply was timed out by one of the routers or the IP stack on os390. "Try again" seems to be all that he can tell me to do. [...] 8998 28 23_Question about SYSLGRNX0_20_John_Lendman@FPL.COM31_Wed, 16 Feb 2000 12:01:12 -0500569_us-ascii The SYSLGRNX has a bad RBA in it and this table keeps stoping with a status of STOPE.

Does anyone know how to fix this problem.

DB2 V5

Here is the message you get when you display SYSLGRNX

DSNT360I |R3T1 *********************************** DSNT362I |R3T1 DATABASE = DSNDB01 STATUS = RW DBD LENGTH = 8000 DSNT397I |R3T1 NAME TYPE PART STATUS PHYERRLO PHYERRHI CATALOG PIECE -------- ---- ---- ------------------ -------- -------- -------- ----- SYSLGRNX TS STOPE ******* DISPLAY OF DATABASE DSNDB01 ENDED ********************** [...] 9027 58 22_DB2 V6 upgrade problem16_Amy C. Whitehead14_B06ACW@FDS.COM31_Wed, 16 Feb 2000 12:15:52 -0500598_us-ascii Has anyone run into this problem on V6 Datasharing? I tried this with DEGREE(ANY) and DEGREE(1) with the same results.

Here is the sqlca for the -904 in NRT 02 SQLCODE | FFFFFC78 | .... 02 SQLERRM | | 03 SQLERRML | 001A | .. 03 SQLERRMC | F0F0C5F3 F0F1F0F0 FFF0F0F0 | 00E30100.000 | F0F0F9F0 F6FFC1C4 C4F14040 | 00906.ADD1 | 4040E534 114D95D8 7A12D7F0 | V..(nQ:.P0 | 14E9BFEE 79BFE55C 14DAA2E0 | .Z..`.V*..s. | 14E9AFC9 94DA8F00 79BFE978 | .Z.Im...`.Z. | 79E2E000 94DA8F00 0000 | `S..m..... 02 SQLERRP | C4E2D5E3 E3D9E4D5 | DSNTTRUN 02 SQLERRD | FFFFFF9C | .... 02 SQLWARN | | [...] 9086 85 39_Re: Moving OS/390 DB2 catalog/directory22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 16 Feb 2000 12:09:16 -0500522_- You can omit the INDYNAM parm & DFDSS will use the ICF catalog to locate the data sets specified in the DATASET(INCLUDE(...)).

Another DFDSS option used with VSAM clusters is SPHERE. I don't think it's required for the DB2 catalog/directory (which are VSAM Linear clusters).

SPHERE is used to include all related objects of a VSAM cluster (e.g. alternate indexes, alternate index path names, etc...). I've gotten in the habit of specifying SPHERE all the time. DFDSS ignores it for non-VSAM clusters. [...] 9172 18 17_FREE PLAN/PACKAGE0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 16 Feb 2000 11:14:55 -0600518_us-ascii PLANS and PACKAGES are only logically connected, no RI or physical connection. So when you do a FREE PLAN (ie program is obsolete, being removed from production) you also have to do a separate FREE PACKAGE to clean up the associated packages. Correct?

TIA Rohn

================================================ 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. 9191 49 19_Re: BufferPool Tool22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Wed, 16 Feb 2000 15:35:11 +0000662_ISO-8859-1 we have used it here .. but I am not the expert .. what questions do you have?

We have used it quite a bit here ..

Leslie Pendlebury-Bowe



______________________________ Reply Separator _________________________________ Subject: BufferPool Tool Author: "Whittaker; Stephen" at Internet Date: 2/16/00 7:19 AM



We currently purchased this tool from IBM and its Version 1 Release 1 and I'm trying to use this tool on our DB2 V5 OS/390 system. Has anyone out there been using this tool and if so could I ask you a few questions on the inner workings of this product? We can take [...] 9241 164 30_Re: DB2 V5.1 & Parallelism....24_Humphris,Richard P.(NXI)24_Richard.Humphris@CNA.COM31_Wed, 16 Feb 2000 11:14:12 -0600509_iso-8859-1 I agree that in some instances, DEGREE > 1 is needed in order to get something done in a reasonable amount of time. But the implication, in this thread, is if you are at 100% cpu there is no latent CPU demand. If you're running at 100%, how do you know if the CPU needed to run your system without CPU delays would be 1% more cpu, 50% more, or 500% more (etc). My point is if your running at 100% cpu then users running w/DEGREE > 1 will have some impact on the other tasks in the system; the [...] 9406 27 20_Re: DSNL511I Message14_Roy R Reynolds20_Roy_Reynolds@GAP.COM31_Wed, 16 Feb 2000 09:12:21 -0800570_us-ascii This is a result of TCP/IP identifying that there is a communication failure. The TCPIP parm:

KEEPALIVEOPTIONS INTERVAL n ENDKEEPALIVEOPTIONS

is instumental in determining that a communication 'failure' has occured. For a useful description of when this is passed to DB2 for creation of the DSNL511I message, read the Redbook SG24-2212-00 starting with page 47. The chapter discusses TCPIP services name definition and additional considerations. A scenario is presented that is pertinent to your situation. "usual disclaimers" Good Luck, Roy [...] 9434 14 24_Re: Primary Key Question0_24_db46@DAIMLERCHRYSLER.COM31_Wed, 16 Feb 2000 12:59:29 -0500323_us-ascii Thanks everyone, my co-worker got the information he needed.

Dean

================================================ 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. 9449 34 18_EXCI CICS with DB212_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Wed, 16 Feb 2000 18:00:05 +0000559_us-ascii I have a batch application where I am trying to call some online CICS routines where some design wizard has lodged all of the company's pricing logic for a particular customer.

I've adjusted my compile and link JCL to add the stubs listed in the manuals, set the options as best I can, and I get a successful translate, compile, link and bind. About the only thing annoying that I can't seem to eradicate is a level 4 Information message about the EXCI option being in conflict with the CICS option, but I haven't been able to get rid of [...] 9484 19 48_Re: Datacom/DB and DB2 in the same Cobol program0_33_WAYNE.ARRINGTON@CUSTOMS.TREAS.GOV31_Wed, 16 Feb 2000 13:04:46 -0500540_US-ASCII John, Are you talking Datacom/DB SQL and DB2 SQL co-existing in the same program? That answer is no, however, if you are using Native Programming you can. What I've seen is a DB2 program calling a Datacom/DB SQL subprogram or Datacom/DB calling a DB2 program. Hope this helped

Wayne

================================================ 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. 9504 67 28_Re: DB2 hardware compression12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Wed, 16 Feb 2000 20:20:08 +0200594_x-user-defined Hi,

It was done with DSNTEP2. Output directed to DD DUMMY with dcb=bufno=80.



Isaac Yassin



Jim Lewandowski wrote: > > I began to think more about this today. The CPU timings below are > not simply SQL entrance/exit, correct? We have tons of other CPU > wrapped around all this DB2 SQL-related nucleus code. > > That is why I wanted a single SQL COUNT(*) statement to be resolved > since it will only be 1 instance of SQL entrance/exit into DB2. > > It still was helpful regarding relative timings but I wish I had > something "closer" to [...] 9572 67 22_Re: EXCI CICS with DB20_22_Rohn.Solecki@MTS.MB.CA31_Wed, 16 Feb 2000 12:24:46 -0600601_us-ascii I'd be interested to hear if you get it working (it would simplify our environment greatly), maybe things (OS Software) have changed enough since our initial achitecture design.

In the sort of situation you describe, we had to setup duplicate programs, one compile for batch the other for CICS. (I think it was mainly because batch and CICS handle passed info in incompatible fashions ) For example we either have duplicate hard code in both programs or put most of WS and Procedure division into COPYLIB members and code separate batch & cics shell programs that copy the WS and [...] 9640 55 38_Re: Why use primary keys in Version 5?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Wed, 16 Feb 2000 12:27:45 -0600612_iso-8859-1 Kathy, Since you seem to be going to great lengths to avoid using Primary Keys perhaps you might share why with us?

Regards, 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, [...] 9696 144 30_Re: DB2 V5.1 & Parallelism....14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 16 Feb 2000 13:29:43 -0500325_ISO-8859-1 Everything is relative. Depends on which address space is invoking parallelism. If it's a batch job, so you have some more TCBs competing for cycles - at a LOW dispatching priority. So only those tasks at the same and lower priority will suffer.

This also increases the possibility for pool thrashing. [...] 9841 14 27_Optimization Hints - DB2 V60_20_bjnigh@HOUSEHOLD.COM31_Wed, 16 Feb 2000 10:36:49 -0800412_us-ascii Has anyone used the new Optimization Hints feature in DB2 Version 6? If so, are there any ramifications to setting the OPTHINTS parameter in the DSNZPARM to YES?

================================================ 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. 9856 76 38_Re: Why use primary keys in Version 5?14_Greg DiGiorgio29_gdigior@CI.NEWPORT-NEWS.VA.US31_Wed, 16 Feb 2000 14:11:44 -0500338_us-ascii Am I not right in making the following statement:

Primary keys exist solely to allow a table to be a parent in a table relation

And I seem to recall way back (not sure if still or ever was true) that if you do not specify a clustering index, DB2 will, by default, cluster to the primary key if one is defined. [...] 9933 17 16_Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 16 Feb 2000 14:11:46 -0500503_iso-8859-1 Would anyone have any suggestions regarding a -805 SQLCODE when I execute a CICS DB2 program.I checked the SYSIBM.SYSPACKAGE table and everything appears to be there. Before executing I did a NEWCOPY on the program in CICS. Any suggestions?

JK

================================================ 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. 9951 38 16_Re: -805 SQLCODE15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Wed, 16 Feb 2000 11:20:15 -0800510_iso-8859-1 We get bit by this occasionally because our subprograms don't capture the error messages and return them to the calling program very well. You may need to rebind any subprograms that your program is calling. The other thing we have found are executables hanging out in a library that we didn't expect them to be in. Check the order of libraries in the steplib of the execution JCL, or startup deck for CICS, and look for modules of the same name in those libraries that shouldn't be there. HTH [...] 9990 53 16_Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 16 Feb 2000 14:21:49 -0500672_iso-8859-1 Thank you for your response.



-----Original Message----- From: Mitchell, Sandi [mailto:Sandi.Mitchell@AVISTACORP.COM] Sent: Wednesday, February 16, 2000 2:20 PM To: DB2-L@RYCI.COM Subject: Re: -805 SQLCODE



We get bit by this occasionally because our subprograms don't capture the error messages and return them to the calling program very well. You may need to rebind any subprograms that your program is calling. The other thing we have found are executables hanging out in a library that we didn't expect them to be in. Check the order of libraries in the steplib of the execution JCL, or startup deck for CICS, and look for [...] 10044 137 38_Re: Why use primary keys in Version 5?11_Kurt Rompot21_RompotK@SCHNEIDER.COM31_Wed, 16 Feb 2000 13:21:54 -0600547_us-ascii I like to use primary keys whenever possible for the following reasons:

1. It ensures that a unique index is always present on the table. 2. It is self-documenting and encourages good relational design. 3. It is useful if you ever reverse engineer your tables back into a data modeling tool such as Erwin. 4. When using a tool such as BMC's Catalog Manager, I can display the columns for a table and immediately know what columns comprise the primary key. It makes it that much easier to understand the table and its purpose. [...] 10182 49 16_Re: -805 SQLCODE27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Wed, 16 Feb 2000 14:23:48 -0500505_- Jeff,

An -805 happens when your plan is not bound . That means that if there are several collection IDs , then all of them need to be included in your plan. When creating your package make sure that you bind your application program to the relevent collection Ids.

Usually in my personal experience I have faced -805 when I have not bound to all the relevent collection Ids or when my application program has a SET CURRENT PACKAGESET statement in it for validating the collection id. [...] 10232 91 38_Re: Why use primary keys in Version 5?13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Wed, 16 Feb 2000 13:30:01 -0600532_us-ascii I have avoided using primary keys when there is no RI for the convenience of the programmers. They often use QMF in creating test data or in testing their programs. If there is a primary key, QMF will not let you update the row. This is because QMF wants to update every column in the row and the primary key can not be updated. The row must be deleted and reinserted. If the index is unique and no primary key is defined, the row can be updated in QMF. DB2 handles the changing of the index without programmer coded. [...] 10324 55 30_Re: DB2 V5.1 & Parallelism....17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM31_Wed, 16 Feb 2000 14:31:09 -0500628_iso-8859-1 Comments below

>-----Original Message----- >From: Joel Goldstein [mailto:joel_goldstein@COMPUSERVE.COM]. > >Everything is relative. Depends on which address space is invoking >parallelism. >If it's a batch job, so you have some more TCBs competing for cycles - at a >LOW dispatching >priority. So only those tasks at the same and lower priority will suffer. > >This also increases the possibility for pool thrashing. > >If any online application/address space invokes parallelism... you're in >deep trouble because it has >a high dispatching priority and will really impact the rest of the world. > [...] 10380 11 38_Re: Why use primary keys in Version 5?0_27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 16 Feb 2000 14:39:14 -0500348_- I have a program that updates the primary key in a table - it does not do a delete add. We are on DB2 v4

================================================ 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. 10392 64 44_Resubmit: IDUG Europe Call for Presentations13_Morrill, John12_JohnM@VP.NET31_Wed, 16 Feb 2000 12:55:55 -0700375_iso-8859-1 Dear DB2 Interested Parties,

Please find below a bulletin from the International DB2 Users Group 2000 European conference planning committee calling for submission of presentation abstracts for this year's conference, October 23-26 in Geneva. Abstracts can be submitted via the IDUG web site at www.idug.org. The submission deadline is on February 25. [...] 10457 115 72_Resubmit: DB2 Now Available for NUMA-Q and HP-UX Operating Enviro nments13_Morrill, John12_JohnM@VP.NET31_Wed, 16 Feb 2000 12:57:46 -0700462_iso-8859-1 Dear DB2 Interested Parties,

After successful beta testing in demanding, parallel environments, IBM announced today the general availability on March 31, 2000 of DB2 UDB EE and EEE for NUMA-Q, DB2 Connect EE for NUMA-Q, and DB2 UDB EEE for HP-UX. Below is an excerpt from the announcement. For more information, please see your IBM representative and the full announcement at http://isource.ibm.com/cgi-bin/goto?it=usa_annred&on=200-020 . [...] 10573 136 38_Re: Why use primary keys in Version 5?12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 16 Feb 2000 11:58:28 PST506_- I just have to add a comment to this question.

Why would anyone NOT use the PRIMARY KEY function of DB2? This enables a CENTRAL location for defining your company's business rules. As opposed to having 50 different programmers having 50 different interpretations of that same rule. The choice to myself (and Murphy), is to reduce or eliminate points of error. Thus, I believe relationships identified in your logical model SHOULD be defined in your physical model and in your implementation. [...] 10710 46 16_Re: -805 SQLCODE12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 16 Feb 2000 12:03:26 PST403_- JK,

In the past, when doing a NEWCOPY in a CICS region, if the application happened to be running at that moment, teh NEWCOPY command returned a good RTN CODE, but did NOT work and then we would get the -805. It is also possible that the NEWCOPY did work and that the new package bind was unsuccessful. In my experience, cycling the region or executing NEWCOPY again resolved the problem. [...] 10757 60 16_Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Wed, 16 Feb 2000 15:04:59 -0500628_iso-8859-1 Thank you for your response.

-----Original Message----- From: craig patton [mailto:prgpatton@HOTMAIL.COM] Sent: Wednesday, February 16, 2000 3:03 PM To: DB2-L@RYCI.COM Subject: Re: -805 SQLCODE



JK,

In the past, when doing a NEWCOPY in a CICS region, if the application happened to be running at that moment, teh NEWCOPY command returned a good RTN CODE, but did NOT work and then we would get the -805. It is also possible that the NEWCOPY did work and that the new package bind was unsuccessful. In my experience, cycling the region or executing NEWCOPY again resolved the problem. [...] 10818 62 30_Re: DB2 V5.1 & Parallelism....14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 16 Feb 2000 15:05:24 -0500470_ISO-8859-1 No arguement with what you say. You are obviously one of the fortunate installations with spare processing capacity. At the same time, you summarize quite well in your first paragraph. If the app was designed right you might be running on a smaller less expensive machine, and if the app was fixed you'd probably avoid (for a long time) your next 7 figure upgrade cost. Regards, Joel +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [...] 10881 25 23_SV: CSP V3.3 and DB2 V511_Arne Nilsen18_Arne.Nilsen@SDS.NO31_Wed, 16 Feb 2000 21:09:01 +0100476_- We have run CSP V3.3 under DB2 V5 from oct.98 - nov.99 without problems. After this we have migrated all CSP-applications to VAG.

Arne Nilsen



> > We are currently running CSP V3.3 and plan to upgrade to V5 of DB2 in the > very near future. Unfortunately we are not able to upgrade CSP before the > DB2 V5 upgrade. Does anyone know whether this old release of CSP will run > under DB2 V5, if not what sort of problems can we expect. > > Paul May > [...] 10907 80 38_Re: Why use primary keys in Version 5?0_19_Tim.Lowe@STPAUL.COM31_Wed, 16 Feb 2000 14:23:22 -0600350_us-ascii Kathy, I had thought that if you defined a "primary key", then you could not update multiple rows with a single SQL statement. But, I did just try it, and it worked. Therefore, something has changed to ease this restriction.

Other than for foreign keys, the only other reason I like to define a primary key is for documentation. [...] 10988 61 38_Re: Why use primary keys in Version 5?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 16 Feb 2000 15:41:45 -0500418_iso-8859-1 Hello Craig. >So, if defining RI (PRIMARY KEYs) in DB2 reduces the chances for DATA >INTEGRITY ERRORS and does NOT cost a significant loss of performance, why is >it NOT being used????

>I hope I have not offended anyone.

I don't know if you've offended anyone, but you may have confused some. Your post seems to ignore Kathy's real question. (Or maybe you just intended to go beyond it?) [...] 11050 154 38_Re: Why use primary keys in Version 5?22_Ditchkus, Vincent, Jr.18_VDitchkus@FDIC.GOV31_Wed, 16 Feb 2000 15:26:51 -0500733_iso-8859-1 Vince Ditchkus FDIC/DB2 Database Administration Phone: (703)845-3160 Page: (703)705-9550



-----Original Message----- From: craig patton [mailto:prgpatton@HOTMAIL.COM] Sent: Wednesday, February 16, 2000 2:58 PM To: DB2-L@RYCI.COM Subject: Re: Why use primary keys in Version 5?



I just have to add a comment to this question.

Why would anyone NOT use the PRIMARY KEY function of DB2? This enables a CENTRAL location for defining your company's business rules. As opposed to having 50 different programmers having 50 different interpretations of that same rule. The choice to myself (and Murphy), is to reduce or eliminate points of error. Thus, I believe relationships identified in [...] 11205 212 38_Re: Why use primary keys in Version 5?14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Wed, 16 Feb 2000 14:34:57 -0500461_iso-8859-1 Couple of statements that need correction:

> Primary keys exist solely to allow a table to be > a parent in a table relation

Not purely that. It also forces a unique key to insure the relational rule of entity integrity -- uniqueness.

> And I seem to recall way back (not sure if still > or ever was true) that if you do not specify > a clustering index, DB2 will, by default, cluster > to the primary key if one is defined [...] 11418 131 22_Re: EXCI CICS with DB212_Greg P Mucha24_Greg_P_Mucha@CARADON.COM31_Wed, 16 Feb 2000 20:39:36 +0000316_us-ascii Well, Rohn, from what I can tell there are significant compilation and link differences between batch/CICS and online/CICS. You literally have to pull the COB2UCL proc apart and insert an IEBGENER step in between the compile and link to make sure that the EXCI stub gets inserted into the object code. [...] 11550 22 4_-91123_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Wed, 16 Feb 2000 15:57:43 -0500409_iso-8859-1 Hi All. I would Like some input with a -911 situation. I am getting this on a Delete operation on lets say table A. There is also another process thats trying to insert rows into this table. The Reason code is 00C9008E and the resource type is 304 (a RID). The Locksize on this table is ROW and the Isolation level is CS. Please do let me know if you would require any additional information. [...] 11573 30 46_DB2 Control Center (Stored Procedure DSNUTILS)15_Jeffery A Price17_jprice@IPALCO.COM31_Wed, 16 Feb 2000 16:27:26 -0500563_us-ascii Hello all,

I'll get right to it - does the stored procedure DSNUTILS have to run in a WLM-established SPAS adress space? Or can it run in a DB2 SPAS adress space? If it has to be WLM-established, does the OS/390 piece RRS have to be active? What does teh RRS peice comprise? I know these questions are numerous, but hearing from someone who has experiece with these products sure would make things clearer. I can get the Control Center to connect, and most of the functions work, but whenever I try to use a utility through Control Center, I [...] 11604 44 50_Re: DB2 Control Center (Stored Procedure DSNUTILS)20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 16 Feb 2000 16:31:21 -0500545_us-ascii > I'll get right to it - does the stored procedure DSNUTILS have to run in a > WLM-established SPAS adress space? [Pillay, Venkat (PCA)] Yes > Or can it run in a DB2 SPAS adress space? [Pillay, Venkat (PCA)] No > If it has to be WLM-established, does the OS/390 piece RRS have to be > active? [Pillay, Venkat (PCA)] Yes RRS must be active. > What does teh RRS peice comprise? [Pillay, Venkat (PCA)] It does two phase commits if needed. > I know these questions are numerous, but > hearing from someone who has experiece with these [...] 11649 49 8_Re: -91114_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Wed, 16 Feb 2000 16:32:09 -0500519_us-ascii Check the access path for the DELETE statement. If the access path is TABLESPACE Scan, then row level locking will not prevent the -911 on the delete. You can also have a similar situation where the access path for the delete uses an index/data access path and the insert process inserts a row that the delete will evaluate in the index and disqualify the row at the data level. If the insert happens without a commit just prior to the delete operation selecting the row, this could cause a -911 timeout. [...] 11699 15 32_Authorization to TERM Utilities?11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Wed, 16 Feb 2000 15:48:29 -0600380_us-ascii Hello DB2 Land!

Can anyone tell me the authorization required to "TERM" a utility that is running other than SYSADM... : )

================================================ 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. 11715 233 38_Re: Why use primary keys in Version 5?11_GOSE PAUL M17_pmgose@SRPNET.COM31_Wed, 16 Feb 2000 14:47:15 -0700491_iso-8859-1 My shop has a policy of assigning primary keys to all tables for a couple of the reasons previously posted, i.e., entity integrity and mirroring the business rules from the logical model. However, I'm not quite comfortable with defining primary keys, and the accompanying index, on small tables w/o RI. I've read that indexes on tables under 10 pages in size are detrimental to performance. Do any "primary key" shops out there make exceptions for small tables not using RI? [...] 11949 19 13_CDB Utilities16_Marcelo Silveira22_mardb2ques@HOTMAIL.COM29_Wed, 16 Feb 2000 21:40:55 GMT506_- Hello,

We are about to test CDB SuperUtilities. Someone has any experience with these DB2 utilities, benchmarks, concerns, etc... Thanks, Marcelo ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11969 58 50_Re: DB2 Control Center (Stored Procedure DSNUTILS)16_Marcelo Silveira22_mardb2ques@HOTMAIL.COM29_Wed, 16 Feb 2000 21:45:07 GMT682_- Hi,

There is one address: http://www-4.ibm.com/software/data/db2/udb/db2cc/readme.html

It seems if you want to use the "utility" part of control center , you will have to define a WLM-based stored procedure.



>From: Jeffery A Price >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: DB2 Control Center (Stored Procedure DSNUTILS) >Date: Wed, 16 Feb 2000 16:27:26 -0500 > >Hello all, > >I'll get right to it - does the stored procedure DSNUTILS have to run in a >WLM-established SPAS adress space? Or can it run in a DB2 SPAS adress >space? >If it has to be WLM-established, does the OS/390 [...] 12028 54 31_Re: Reorg Plus - duplicate keys13_John Arbogast16_jfarbo@YAHOO.COM31_Wed, 16 Feb 2000 13:54:59 -0800284_us-ascii If memory serves, BMC will discard all dups. How would reorg plus know which row is the correct one? If I am incorrect, someone from BMC will correct me I hope. Then again, thats what free advice is usually worth. How/why you have dups would be a greater concern to me. [...] 12083 31 36_Re: Authorization to TERM Utilities?20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Wed, 16 Feb 2000 16:55:55 -0500680_us-ascii Other than SYSADM you need either of them SYSOPR, SYSCTRL , (DBADM,DBMAINT or DBCTRL) on the database, on whose object utility is operating.

> -----Original Message----- > From: Jeff Faughn [SMTP:Jeff_Faughn@MAY-CO.COM] > Sent: Wednesday, February 16, 2000 4:48 PM > To: DB2-L@RYCI.COM > Subject: Authorization to TERM Utilities? > > Hello DB2 Land! > > Can anyone tell me the authorization required to "TERM" a utility that is > running other than SYSADM... : ) > > ================================================ > 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 [...] 12115 42 36_Re: Authorization to TERM Utilities?17_Patricia Candella21_pcandella@METLIFE.COM31_Wed, 16 Feb 2000 17:01:34 -0500587_us-ascii Jeff, As of DB2 V4 (os/390) you need to be dbadm over the database on which the utility is running. Hope this helps.

Patty









"Jeff Faughn" on 02/16/2000 04:48:29 PM

Please respond to "DB2 Data Base Discussion List"

To: DB2-L@RYCI.COM cc: (bcc: Patricia Candella/Bsg/MetLife/US) Subject: Authorization to TERM Utilities?





Hello DB2 Land!

Can anyone tell me the authorization required to "TERM" a utility that is running other than SYSADM... : ) [...] 12158 75 8_Re: -91123_Trivedi, Kaushal J, BGM17_kjtrivedi@ATT.COM31_Wed, 16 Feb 2000 17:01:40 -0500662_iso-8859-1 Larry, The Access path does show a TS . could you please expand a bit on your previous answer and how to get around it.

Thanks

regards

Kaushal Trivedi

-----Original Message----- From: Larry D Bolick [mailto:ldbolick@DUKE-ENERGY.COM] Sent: Wednesday, February 16, 2000 4:32 PM To: DB2-L@RYCI.COM Subject: Re: -911



Check the access path for the DELETE statement. If the access path is TABLESPACE Scan, then row level locking will not prevent the -911 on the delete. You can also have a similar situation where the access path for the delete uses an index/data access path and the insert process inserts a [...] 12234 65 36_Re: Authorization to TERM Utilities?0_19_Tim.Lowe@STPAUL.COM31_Wed, 16 Feb 2000 16:09:48 -0600308_us-ascii Jeff, Take a look at the DB2 command reference under -TERM. From that manual: To execute this command, the primary or some secondary authorization ID of the process must be the ID that originally submitted the utility job, or the privilege set of the process must include one of the following: [...] 12300 102 38_Re: Why use primary keys in Version 5?12_Lisle, Kathy19_KLLISLE@INTEGON.COM31_Wed, 16 Feb 2000 17:11:54 -0500484_windows-1252 Soon after I sent my question, our mail server went down, so I only saw the responses when I checked the archives a few minutes ago. To respond to Rick, I'm not going to great lengths to avoid primary keys; I just wondered why I should make any effort to create them, particularly since the writers of this 3rd-party product chose not to implement RI. Sounds like protection of a unique key and documentation are the main (non-RI) reasons. Thanks for the responses. [...] 12403 37 36_Re: Authorization to TERM Utilities?12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 16 Feb 2000 16:09:00 -0500364_- Don't know if this is still true or not, but when we were testing this under V4.1- If the utility was in the INIT Phase, DBADM,DBMAINT of DBCTRL could not terminate it. >>> DB2-L@RYCI.COM@inter2 02/16/00 03:54PM >>> Other than SYSADM you need either of them SYSOPR, SYSCTRL , (DBADM,DBMAINT or DBCTRL) on the database, on whose object utility is operating. [...] 12441 127 39_Re: merge scan join vs nested loop join14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Thu, 17 Feb 2000 09:18:02 +1100329_iso-8859-1 Sverre,

It's funny that you say "obviously Q2 is a million times faster", as it depends totally on the number of qualifying rows to be joined. A nested loop join is best performing for a small number of rows, but merge scan exponentially outperforms nested loop as the number of qualifying rows increases. [...] 12569 109 8_Re: -91114_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Wed, 16 Feb 2000 17:25:16 -0500436_us-ascii The TS scan access path must evaluate every row in the table. If a row is inserted (with no commit) into the table on a page that the delete process has not yet accessed, then the inserted row is locked with a X lock and is now on a collision path with the delete. The delete process will not be able to "read" the newly inserted row (or get past it) to determine if it qualifies for deletion. Possible solutions include: [...] 12679 13 20_Visual Age Generator12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Wed, 16 Feb 2000 16:18:00 -0500373_- We are looking into getting VA as a replacement for CSP. Any comments/experiences would be appreciated.

Thanks in advance.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 12693 25 20_access path question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Wed, 16 Feb 2000 14:32:54 -0800533_iso-8859-1 > The following query is set up as a cursor in a program and only ever > fetches one row, over and over and over. The table had two indexes, one on > srv_addr_ky and a second one on customer_ky, srv_addr_ky. Srv_addr_ky is > the primary key on the table and the second index is unique also. The > cursor was using the first index defined on the srv_addr_ky. > I changed the cursor to a select and added a third unique index on > srv_addr_ky, customer_ky in an attempt to make the query index only and > ran runstats. [...] 12719 43 24_Re: access path question15_Mallett, Steven38_Steven.Mallett@CORPMAIL.TELSTRA.COM.AU31_Thu, 17 Feb 2000 09:41:20 +1100579_- Did you re-bind after creating the new index?

regards, Steve

> -----Original Message----- > From: Mitchell, Sandi [SMTP:Sandi.Mitchell@AVISTACORP.COM] > Sent: Thursday, 17 February 2000 9:33 am > To: DB2-L@RYCI.COM > Subject: access path question > > > The following query is set up as a cursor in a program and only ever > > fetches one row, over and over and over. The table had two indexes, one > on > > srv_addr_ky and a second one on customer_ky, srv_addr_ky. Srv_addr_ky is > > the primary key on the table and the second index is unique also. The > > [...] 12763 78 28_Re: DB2 hardware compression15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Sat, 12 Feb 2000 16:30:56 -0600528_us-ascii I would still like to see the SQL COUNT(*) test to see how that fits with your results.

Jim Lewandowski



Isaac Yassin wrote: > > Hi, > > It was done with DSNTEP2. Output directed to DD DUMMY with dcb=bufno=80. > > Isaac Yassin > > Jim Lewandowski wrote: > > > > I began to think more about this today. The CPU timings below are > > not simply SQL entrance/exit, correct? We have tons of other CPU > > wrapped around all this DB2 SQL-related nucleus code. > > > > That is why I wanted a single [...] 12842 51 24_Re: access path question14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Thu, 17 Feb 2000 10:30:32 +1100339_- Sandi,

Hopefully you're on V4, which means this is easy to explain. DB2 will use the primary key index if it can, ignoring any other index-only alternatives. This was improved in V5.

Are you V5? If so, then I'm at a loss. Stats shouldn't be a problem, but have you rebound?

Regards Terry Purcell CPT Consulting [...] 12894 32 24_Re: Visual Age Generator10_Park, Stan17_SPark@STATE.NM.US31_Wed, 16 Feb 2000 16:41:56 -0700498_iso-8859-1 We are looking at doing this along with the multi-platform security, support, connectivity, training, etc. issues that are involved. Probably this summer timeframe.

-----Original Message----- From: BOB JEANDRON [mailto:BOB.JEANDRON@USDA.GOV] Sent: Wednesday, February 16, 2000 2:18 PM To: DB2-L@RYCI.COM Subject: Visual Age Generator Sensitivity: Personal



We are looking into getting VA as a replacement for CSP. Any comments/experiences would be appreciated. [...] 12927 65 24_Re: access path question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Wed, 16 Feb 2000 15:43:19 -0800466_iso-8859-1 OS/390 V4 and I'm running the explain in spufi

-----Original Message----- From: Purcell, Terry [mailto:Terry.Purcell@CORPMAIL.TELSTRA.COM.AU] Sent: Wednesday, February 16, 2000 3:31 PM To: DB2-L@RYCI.COM Subject: Re: access path question



Sandi,

Hopefully you're on V4, which means this is easy to explain. DB2 will use the primary key index if it can, ignoring any other index-only alternatives. This was improved in V5. [...] 12993 98 24_Re: access path question14_Purcell, Terry37_Terry.Purcell@CORPMAIL.TELSTRA.COM.AU31_Thu, 17 Feb 2000 11:21:51 +1100734_- Sandi,

Unfortunately my two suggestions for you may not be too attractive:

A) Upgrade to V5

OR

B) Change the primary key of the table to SVR_ADDR_KY, CUSTOMER_KY (index 3). Uniqueness will still be maintained with index 1 on SVR_ADDR_KY. (Note: I haven't tested this myself).

Regards, Terry Purcell CPT Consulting

> -----Original Message----- > From: Mitchell, Sandi [SMTP:Sandi.Mitchell@AVISTACORP.COM] > Sent: Thursday, 17 February 2000 10:43 am > To: DB2-L@RYCI.COM > Subject: Re: access path question > > OS/390 V4 and I'm running the explain in spufi > > -----Original Message----- > From: Purcell, Terry [mailto:Terry.Purcell@CORPMAIL.TELSTRA.COM.AU] > Sent: Wednesday, February [...] 13092 112 24_Re: access path question15_Mitchell, Sandi29_Sandi.Mitchell@AVISTACORP.COM31_Wed, 16 Feb 2000 16:35:11 -0800597_iso-8859-1 Thanks Terry. As it turns out we are scheduled for V5 in March.

-----Original Message----- From: Purcell, Terry [mailto:Terry.Purcell@CORPMAIL.TELSTRA.COM.AU] Sent: Wednesday, February 16, 2000 4:22 PM To: DB2-L@RYCI.COM Subject: Re: access path question



Sandi,

Unfortunately my two suggestions for you may not be too attractive:

A) Upgrade to V5

OR

B) Change the primary key of the table to SVR_ADDR_KY, CUSTOMER_KY (index 3). Uniqueness will still be maintained with index 1 on SVR_ADDR_KY. (Note: I haven't tested this myself). [...] 13205 19 0_9_Jo K.Nash17_jo.k.nash@USA.NET29_Wed, 16 Feb 2000 20:08:47 EST608_US-ASCII I missed BMC's SAP Tech Talk today, due to silly application errors. Did anyone listen in and was there any new revelations revealed about SAP? Of course, other than that SAP 4.6 object quantity is sky rocketing.

____________________________________________________________________ Get free email and a permanent address at http://www.amexmail.com/?A=1

===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 13225 109 21_Re: FREE PLAN/PACKAGE25_Srirengan Venkatesh Kumar42_SRIRENGAN_VENKATESH_KUMAR/IRAS@IRAS.GOV.SG29_Thu, 17 Feb 2000 02:31:09 GMT698_us-ascii

Hi,

If u use collections the answer is yes, you have to free them seperately.

Regards







(Embedded image moved DB2 Data Base Discussion List to file: (Tel: ) pic23477.pcx) 17/02/2000 01:14 AM







Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: bcc: Subject: FREE PLAN/PACKAGE



PLANS and PACKAGES are only logically connected, no RI or physical connection. So when you do a FREE PLAN (ie program is obsolete, being removed from production) you also have to do a separate FREE PACKAGE to clean up the associated packages. Correct? [...] 13335 17 16_Re: -805 SQLCODE12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 16 Feb 2000 22:14:16 -0600312_- What is the reason code in the -805? The Messages and Codes book has about one and a half pages of description for the analysis of -805, with many suggestions of what could be wrong in the various situations. If the situation you have is not there, then please send in a request for a change to the book. [...] 13353 30 20_Re: SQR0263(SQR0253)12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 16 Feb 2000 22:47:20 -0600376_- You're encountering a storage problem, and the base DB2 service level is about 14 months back level. You are missing many fixes for storage problems. In addition, you're missing some major improvements for access path selection with PeopleSoft. It will take some time to work up to a more current level of DB2, but that work is almost certain to be needed in any case. [...] 13384 34 26_Re: extent numbers and SMS12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 16 Feb 2000 23:10:57 -0600273_- I tend to agree with what I'm reading, but have a couple of thoughts to add. If the suggestion is 30, 30, then they must mean cylinders to get up to the 2 GB size. If you are on DFSMS 1.5 and use multivolume data sets, then the number of extents can be even larger. [...] 13419 43 16_Re: -805 SQLCODE10_John Clark20_pak02449@PIXIE.CO.ZA31_Thu, 17 Feb 2000 07:44:55 +0530446_iso-8859-1 JK

Have a look at my REXX at WWW.CONNECTION42.CO.ZA under IEFSHARE. It uses RLX to access DB2, but you should now be able to use the IBM REXX/DB2 interface to check the consistency tokens.

Regards



John Clark

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Kalman, Jeff Sent: 17 February 2000 00:42 To: DB2-L@RYCI.COM Subject: Re: -805 SQLCODE [...] 13463 55 21_Re: FREE PLAN/PACKAGE15_Rene Hendriksen16_reh@NOTES.BEC.DK31_Thu, 17 Feb 2000 07:33:36 +0100660_iso-8859-1 Right you are Rohn. Remember the "*" in version of FREE PACKAGE to clean up all versions of the package.

Regards René







Rohn.Solecki@MTS.MB.CA on 16-02-2000 18:14:55

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Rene Hendriksen/reh/usr/becint) Subject: FREE PLAN/PACKAGE





PLANS and PACKAGES are only logically connected, no RI or physical connection. So when you do a FREE PLAN (ie program is obsolete, being removed from production) you also have to do a separate FREE PACKAGE to clean up the associated packages. Correct? [...] 13519 13 14_SIGN-OFF DB2-L20_Robert CONS:McNamara17_DBAS007@MBUSA.COM31_Wed, 16 Feb 2000 15:51:01 -0500263_US-ASCII SIGN-OFF DB2-L

===============================================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. 13533 20 30_Re: DB2 V5.1 & Parallelism....14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 17 Feb 2000 08:48:34 +0100428_us-ascii Ahhh... so the paradise exists !!!

You lucky man....



Max Scarpa Data & System Admin (and bad programmers fighter)

All disclaimer you cam image apply

================================================ 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. 13554 27 13_DYNAMIC QUERY0_49_PRAKASH_UPRETI/ITS_-_Tata_Steel@LOT.TATASTEEL.COM29_Thu, 17 Feb 2000 08:27:41 GMT384_us-ascii i'm trying to execute a dynamic query from a NT workstation by using a REXX program. DB2 connection part is going through very smoothly, but at prepare stage i'm getting following error.

--- error report --- ERROR occurred : PREPARE SQLCODE : -805 SQL0805N Package "TISDB2T.NULLID.SQLA18N5.5041476858654A4F" was not found. SQLSTATE=51002 --- end error report --- [...] 13582 53 29_Data externalisation question14_Ian McCullough27_Ian.McCullough@CITEC.COM.AU31_Thu, 17 Feb 2000 18:32:01 +1000286_US-ASCII Dear List, This is a hypothetical question that has been bugging us for awhile. Maybe its simple and I have just missed something.

Assumption: I am the only one using DB2 and I am running a batch job. The job simply reads some rows and updates a field in that row. [...] 13636 88 29_Data externalisation question11_Mike Turner29_Michael_Turner@COMPUSERVE.COM31_Thu, 17 Feb 2000 05:04:33 -0500393_ISO-8859-1 Ian

The bit that is missing from your decription is called the Log Write Ahead Protocol. Before DB2 writes a page back to DASD from the buffer pool it will write all log records that contain updates to that page to the active log on DASD.

Regards Mike Turner Email: michael_turner@compuserve.com Home Page: http://ourworld.compuserve.com/homepages/michael_turner [...] 13725 26 16_Re: -805 SQLCODE16_Robin Willoughby27_robin_willoughby@UK.IBM.COM31_Thu, 17 Feb 2000 10:39:23 +0000462_us-ascii Hi, may I suggest that you CEMT SET prog PHASEIN rather than NEWCOPY ? - that way you avoid thethe program in use problem - CICS simplies lets any existing executing copies use the old version while any new invocations use your new version

cheers,

Robin

Robin Willoughby Internet: robin_willoughby@uk.ibm.com PeopleSoft Practice - BMS/ERP IBM Global Services Tel: +44 (0)207 202 3017 Internal: 433017 mail point: OSU14 WARW UK [...] 13752 41 24_Re: Visual Age Generator13_Scott Lindsey29_sflindsey@HIGHLIGHTS-CORP.COM31_Thu, 17 Feb 2000 06:24:32 -0500386_us-ascii Good Luck! Make sure you get it for an evaluation period first. It is really good for developing screens but that's just about where it stops. Creating reports is really a pain. Switching between DB2 qualifiers is very difficult. These are just a couple of problems that we've had. I can check with our developers to see if they can put together others if you would like. [...] 13794 156 43_Replace Into option for Simple Tablespace !27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Thu, 17 Feb 2000 17:09:37 +0530481_iso-8859-1 Hi !

I accidently used a REPLACE INTO option for loading a table ,say XXXYYYY into a tablespace say YYYYZZZZ which had multiple tables in the same tablespace(its a SIMPLE TABLESPACE), (6 tables), thus deleting the data related to other tables . Later realized that 7 collection Ids (High level qualifiers )(say TXX1, TXX2....TXX8 ) for this particular table also have the same tablespace, YYYYZZZZ. The replace into Control Card looked something like this : [...] 13951 58 8_Re: Help12_Jacob Ganzel19_jacobg@SEMECH.CO.IL31_Thu, 17 Feb 2000 13:42:01 +0200705_x-user-defined Hello Subrata. A good solution is using BRIO products. Look at www.brio.com for: Brio Enterprise for desktop reports. Brio Report for production reports. Brio Portal for Enterprise Information Portal - help you managing your needs.

Regards. Jacob. --------------------------------------------------------------- Jacob Ganzel Database Products Mgr. SEMECH Software Marketing Ltd.

3b Netanyahu St., OR YEHUDA, ISRAEL Email: jacobg@semech.co.il Tel.: +972-3-5333144 Fax.: +972-3-5333132 ----- Original Message ----- From: subrata mondal Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 16, 2000 3:42 PM Subject: Help [...] 14010 49 47_Re: Replace Into option for Simple Tablespace !14_Massimo Scarpa16_mscarpa@CESVE.IT31_Thu, 17 Feb 2000 13:05:48 +0100456_us-ascii Look (or say to your system admin to do that) at sysibm.systables to find the names of

tablespace containing the TXX3 table(s), say TXX3.TSDEAD.

With REPLACE option (not after INTO) an implicit IDCAMS delete /define happens so deleting all rows of all tables in TS (i.e. the VSAM file TXX3.DSNDBC.your_dbname.TSDEAD.i0001.a001

IS CANCELED and redefined, if i correctly interpretate your message, TXX3 is vcat name....and [...] 14060 91 12_Re: DSNV086E13_Lourdes Kishi14_lkishi@BKB.COM31_Thu, 17 Feb 2000 05:57:06 -0600367_- Hello Joe,

We received this message too! What I can tell you... is that you are really in trouble :-) as we are, cause it is not solved yet!. It started after we applied some PSP's to SHARK Disk. Could you tell us about your enviroment?

It seens like that it happens when DB2 needs create another extent and there is no space in the same volume. [...] 14152 100 38_Re: Why use primary keys in Version 5?19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 17 Feb 2000 06:34:00 -0600360_iso-8859-1 Kathy,

Snip>> For that matter, in V5 and later, since foreign keys can refer to any unique index, is there any reason to define new primary keys at all, even if foreign keys are defined? Maybe for documentation, clarity, etc.? <
Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14405 36 12_Re: MQSeries18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Thu, 17 Feb 2000 08:34:00 -0500494_- Go to http://www.lsoft.com/lists/listref.html which has a complete list of listserve sites.





Peter J. Krawetzky, Database Administrator Aetna, Inc. Hartford, CT 06156 Email: KrawetzkyPJ@aetna.com Phone: (860) 273-0301





-----Original Message----- From: Joe Abbagnaro [mailto:Joe_Abbagnaro@PRAXAIR.COM] Sent: Thursday, February 17, 2000 8:30 AM To: DB2-L@RYCI.COM Subject: MQSeries



Anyone know of a forum like this for MQseries ? [...] 14442 57 17_Re: DYNAMIC QUERY16_Michael McCarthy18_mmccarthy@DTCC.COM31_Thu, 17 Feb 2000 08:42:07 -0500507_us-ascii You need to connect to your DB2 For OS/390 in a DB2 Command Window. Change to your \SQLLIB\BND directory and issue the following:

DRIVE:\SQLLIB\BND> db2 bind @ddcsmvs.lst blocking all sqlerror continue grant public

This will create the packages needed for your remote access.

-Mike.









"PRAKASH_UPRETI/ITS_-_Tata_Steel"@LOT.TATASTEEL.COM on 02/17/2000 03:27:41 AM

Please respond to DB2 Data Base Discussion List [...] 14500 16 23_Re: CSP V3.3 and DB2 V513_Darrel Schumm23_dschumm@TOTALSYSTEM.COM31_Thu, 17 Feb 2000 08:37:00 -0500319_us-ascii Paul , unfortunately we too are still using CSP 3.3 with no plans to upgrade. We have been running CSP strictly on TSO with DB2 5.1 for about a year with no reported problems concerning CSP and DB2. We will upgrading our DB2 's that use CSP to DB2 6.1 in April if something goes awry I will let you know. [...] 14517 165 54_FW: FW: [DB2-L] Using the DB2 log for billing purposes22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Thu, 17 Feb 2000 09:09:37 -0500696_iso-8859-1 A response from an MXG-L poster re: using MXG to process DB2 accounting records for billing.



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

> ---------- > From: Gary Morris[SMTP:gary.morris@centrelink.gov.au] > Sent: Wednesday, February 16, 2000 6:54 PM > To: MXG-L@PEACH.EASE.LSOFT.COM > Subject: Re: FW: [DB2-L] Using the DB2 log for billing purposes > > We are producing billing reports from the DB2ACCT dataset. Its quite > straightforward the way we are doing it, just billing TCB CPU minutes > summarised > by the job name (which is available in DB2ACCT). Its quite simple, but > then > thats all the DBA's wanted. [...] 14683 26 23_DB2 rebinds from where?14_Rowell, Dean A19_dean.rowell@EDS.COM31_Thu, 17 Feb 2000 08:17:20 -0600399_x-user-defined Could anyone tell me, where does DB2 get its parmlist to do rebinds when object changes invalidate a plan - forcing a one time rebind? E.G. 1) Program A is rebound with new parms 2) Objects accessed by program A are altered 3) Progam A is invalidated 4) At execution time program A is rebound using defaults/parms from where? 5) Currently we are loosing binds from step 1 above. [...] 14710 81 47_Re: Replace Into option for Simple Tablespace !12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 17 Feb 2000 06:35:28 PST580_- HI!

If I understand the question, you have 1 simple tablespace, several tables (with different 'creators') and then you performed a LOAD REPLACE. If this is the case, then the answer is YES, you have deleted ALL of the data in the TABLESPACE! And that means ALL of the tables, regardless of their 'CREATOR' ids. The reason for this is that the first phase of a LOAD REPLACE either performs a DELETE/DEFINE of the TABLESPACE VSAM file (if using STOGROUPs) or sets the RBA=0 (if user defined VSAM files). ANY TABLE THAT STORES IT'S DATA IN THIS FILE (TABLESPACE) WILL [...] 14792 41 24_db2 manual in pdf format14_khalid mahsoun19_kmahsoun@DMP.NET.SA31_Thu, 17 Feb 2000 17:29:01 +030076_windows-1256 hi dose any one know where I can find db2 manuals in pdf format 14834 44 48_DB2 Replication Questions from a dripping newbie12_Michael Best12_mbest@GR.COM31_Thu, 17 Feb 2000 08:18:48 -0600664_- Hello all,

First, my apologies for any and all embarrasing ignorance displayed in the following.

I am totally inexperienced with DB2/UDB, but am faced with the following challenge:

Develop a remote, disconnected-user system that will occasionally synchronize itself with a corporate database via the internet.

My questions center around DB2 replication.

I am assuming from what I read that I will use either DB2 Personal or DB2 Satellite for the remote database. From what I can gather, the Satellite version is merely a scaled-down version of the Personal edition. (If I am wrong on this assumption, please let me know.) [...] 14879 147 17_Re: Shark Concern9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Thu, 17 Feb 2000 14:43:52 +0000375_us-ascii Hi, I would be grateful if any Shark users could be specific about their maintenance levels and the problems they have had with the DASD. That is, - is there a known microcode/ptf level where this error occurs ? - do you know of specific maintenance which has introduced this problem ? - is there a known microcode/ptf level where the DASD appears error free ? [...] 15027 32 28_Re: db2 manual in pdf format15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 17 Feb 2000 09:46:31 -0500876_windows-1256 They are at the following locations:

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

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

http://www-4.ibm.com/cgi-bin/software/db2www/library/pubs.d2w/report





-----Original Message----- From: khalid mahsoun [mailto:kmahsoun@DMP.NET.SA] Sent: Thursday, February 17, 2000 9:29 AM To: DB2-L@RYCI.COM Subject: db2 manual in pdf format



hi dose any one know where I can find db2 manuals in pdf format

================================================ 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. 15060 27 28_Re: db2 manual in pdf format17_Bruzdzinski, Mike24_MIKE.BRUZDZINSKI@SSA.GOV31_Thu, 17 Feb 2000 09:44:08 -0500413_windows-1256 The IBM website has them in both HTML and PDF

Michael Bruzdzinski Social Security Administration Usual disclaimers apply!



-----Original Message----- From: khalid mahsoun [mailto:kmahsoun@DMP.NET.SA] Sent: Thursday, February 17, 2000 9:29 AM To: DB2-L@RYCI.COM Subject: db2 manual in pdf format



hi dose any one know where I can find db2 manuals in pdf format [...] 15088 49 24_Re: Visual Age Generator12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 17 Feb 2000 09:20:00 -0500574_- Thanks for the info. And, any other facts you have time to put together would be great.

What are the alternatives?

Thanks in advance. >>> DB2-L@RYCI.COM@inter2 02/17/00 05:33AM >>> Good Luck! Make sure you get it for an evaluation period first. It is really good for developing screens but that's just about where it stops. Creating reports is really a pain. Switching between DB2 qualifiers is very difficult. These are just a couple of problems that we've had. I can check with our developers to see if they can put together others if you would like. [...] 15138 150 53_Repost: RE: Interest in DB2 Spatial Extender Solution13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:25 -0700499_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



J. Michael,

Reference your note below, for questions/discussion about DB2 Spatial Extender, please contact: [...] 15289 96 39_Repost: DB2 ERP Focus Sessions at SHARE13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:26 -0700612_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is a bulletin from our DB2 colleague, Merv Freeling of the County of Alameda, regarding sessions organized by the SHARE DB2 project at the upcoming conference in Anaheim, California, March 5-10. [...] 15386 193 31_Repost: Issue VIII of DB2 Today13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:25 -0700710_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is the latest issue of "DB2 Today". DB2 Today, published monthly, summarizes key IBM data management related news that has occurred since the last issue. News items are very short with links back to details on the IBM Data Management WWW site. Subscribers can define a "My DB2 Today" [...] 15580 924 23_Repost: DB2 In The News13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:27 -0700600_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below are recent DB2-related articles that I've seen in the press, the first few of them from reporters who attended a press briefing here at the Santa Teresa Lab on February 2nd: [...] 16505 121 76_Repost: Correction: META Group: "Data Warehousing for the Masses" (9/22 /99)13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:29 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:12 PM --------------------------- [...] 16627 185 55_Repost: New Book: "DB2 Answers! Certified Tech Support"13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:29 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:12 PM --------------------------- [...] 16813 118 48_Repost: DB2 Now Available on SGI's Linux Servers13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:28 -0700568_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is a press release from SGI made at last week's LinuxWorld Conference regarding the availability of DB2 UDB for Linux on SGI's Linux servers. [...] 16932 233 72_Repost: IBM, SAS Institute Enter Key Business Intelligence Relati onship13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 08:45:28 -0700712_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below is a recent press release regarding a new partnership of SAS Institute with IBM Global Services and IBM Software Group for Business Intelligence systems. A key aspect of this partnership will be even closer integration of SAS solutions and DB2. See the URLs below for more information. [...] 17166 20 24_Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 17 Feb 2000 10:47:50 -0500432_iso-8859-1 Would anyone have any other suggestions regarding a -805 SQLCODE when I execute a CICS DB2 program.I checked the SYSIBM.SYSPACKAGE table and everything appears to be there. Before executing I did a NEWCOPY on the program in CICS. I tried binding the program to each package that appears in the SYSIBM.SYSPACKAGE table as well as compile all of the other programs that make up this sub-system. Any other suggestions? [...] 17187 28 40_V6 Host Variables no colons and Platinum8_Long, Ed15_Ed.Long@FMR.COM31_Thu, 17 Feb 2000 10:55:10 -0500617_- As part of our preparation for V6 we have embarked on the search for host variable references without colons.

The question for you all is has anyone come up with a way to identify the programs and SQL that have this problem?

Platinum Plan Analyzer (2.1.5) provides a report that ostensibly lists this occurrences; presently it refuses to respond to our gentlest entreaties to work producing only the PP028E message. "No data was found for your selection criteria". We have tried 30 or 40 different sets of criteria and literally hundreds of different requests besides the Host variable query and [...] 17216 43 28_Re: Repost: Re: -805 SQLCODE14_John P Shipley24_jpshiple@DUKE-ENERGY.COM31_Thu, 17 Feb 2000 10:59:49 -0500725_us-ascii Is the program in the LLA by chance. If so the LLA needs to be refreshed by the systems programs. Just a wild guess.









"Kalman, Jeff" on 02/17/2000 10:47:50 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: John P Shipley/Corp/DukePower) Subject: Repost: Re: -805 SQLCODE







Would anyone have any other suggestions regarding a -805 SQLCODE when I execute a CICS DB2 program.I checked the SYSIBM.SYSPACKAGE table and everything appears to be there. Before executing I did a NEWCOPY on the program in CICS. I tried binding the program to each package that appears [...] 17260 94 41_Jave SQL Error when attempting to connect11_Clark, Tony26_Tony.Clark@TWC.STATE.TX.US31_Thu, 17 Feb 2000 10:24:48 -0600394_- Hello:

I am trying to help an outside contractor working on a project here to be able to connect to a DB2 subsystem. We are OS/390 Open Edition and DB2 V5. This is the first request I've had in an area of which I know nothing. We have WEBSERV installed on the mainframe. I am almost entirely ignorant of how to manage DB2 connections coming from workstations up to the mainframe. [...] 17355 69 28_Re: Repost: Re: -805 SQLCODE0_27_BoSDBA@BANKOFSCOTLAND.CO.UK31_Thu, 17 Feb 2000 16:23:17 +0000354_us-ascii Jeff, We had a similar kind of problem, though I don't know whether it applies to you . We looked in the CICS RCT and found that the transaction was calling the wrong plan! Just a thought. Claire Rooney DBA Bank of Scotland Usual disclaimers apply







"Kalman, Jeff" on 17/02/2000 15:47:50 [...] 17425 68 39_Re: Moving OS/390 DB2 catalog/directory11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Thu, 17 Feb 2000 08:31:11 -0800536_iso-8859-1 Looks like DFDSS is the way to go. Thanks all. cliff:-)

-----Original Message----- From: Helen Johnson [mailto:Helen_Johnson@RAC.RAY.COM] Sent: Wednesday, February 16, 2000 8:49 AM To: DB2-L@RYCI.COM Subject: Re: Moving OS/390 DB2 catalog/directory



On suggestion from several of the list members last year, I used DFDSS to move tables, indexes, catalog, directory and BSDS from 3380 to 3390 pack. It worked great. Here is sample jcl for the catalog and directory moving from pack IM000E to DP070C. [...] 17494 66 44_Re: V6 Host Variables no colons and Platinum20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 17 Feb 2000 11:39:28 -0500293_us-ascii Ed

The host variables without colon will only pose a problem for a new pre-compile. In other words a "new & fresh" precompile will fail in V6. The binds and rebinds will never have problem. So if you have old package or dbrm sitting in catalog will not pose any problems. [...] 17561 48 0_13_De Jonge, Jan20_Jan_De_Jonge@BMC.COM31_Thu, 17 Feb 2000 10:32:42 -0600501_iso-8859-1 Jo,

just send an email to:

Terry Kraft Product Management Manager RESOLVE Recovery Management for OS/390 Terry_Kraf@bmc.com

She must be able to send you a recording from the session.

Regards,

Jan de Jonge OS/390 Software Consultant Jan_de_Jonge@bmc.com +31 (0)30 6085500 BMC Software http://www.bmc.com

-----Original Message----- From: Jo K.Nash [mailto:jo.k.nash@USA.NET] Sent: Thursday, February 17, 2000 2:09 AM To: DB2-L@RYCI.COM Subject: [...] 17610 36 28_Re: db2 manual in pdf format19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 17 Feb 2000 10:59:17 -0600688_windows-1256 http://www-4.ibm.com/software/data/db2/os390/library.html



Rick Davis "This e-mail and any files transmitted with it are the property of SBC, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender at 314-235-6854 and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited." [...] 17647 36 17_SQL/PL in DB2 v5?13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Thu, 17 Feb 2000 12:38:00 -0500496_iso-8859-1 Folks, Excuse the ignorance behind this question, but that's what I am trying to address. I have been doing some reading, and am still unclear on a particular facet of Stored Procedures in DB2 for MVS - any clarification appreciated.

Under DB2 v5, is it possible to code stored procedures in SQL procedure language (a la Oracle SQL/PL), or must they be implemented as standard SQL queries within 3GL code (i.e. conditional logic must be handled outside the SQL processes)? [...] 17684 67 28_Re: Repost: Re: -805 SQLCODE0_19_Tim.Lowe@STPAUL.COM31_Thu, 17 Feb 2000 11:56:17 -0600438_us-ascii Jeff, When the sqlcode -805 occurs, does the program call DSNTIAR to format the error message? If so, what is the message? (which version of which package is missing from what plan?) If not, can you add this call?

Thanks, Tim













"Kalman, Jeff" on 02/17/2000 09:47:50 AM

Please respond to DB2 Data Base Discussion List [...] 17752 59 31_Stored Proc abend by Buffer Man11_Robert Jans21_Jans.Robert@AMSTR.COM31_Thu, 17 Feb 2000 11:00:00 -0700326_- Hi, Listers! we're having a problem here and wonder if someone recognizes it. Environment is OS/390, DB2V5 plus some V6 enhancements. This is a single DB2 region with 5 copies of the application. The stored proc runs fine in 4 of the 5 systems. In the 5th, the stored proc abends as follows: (from the log of the SPAS) [...] 17812 86 28_Re: Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 17 Feb 2000 13:06:42 -0500515_iso-8859-1 Tim, The program does not call DSNTIAR, how can I add it?

Thank you. Jeff

-----Original Message----- From: Tim.Lowe@STPAUL.COM [mailto:Tim.Lowe@STPAUL.COM] Sent: Thursday, February 17, 2000 12:56 PM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE



Jeff, When the sqlcode -805 occurs, does the program call DSNTIAR to format the error message? If so, what is the message? (which version of which package is missing from what plan?) If not, can you add this call? [...] 17899 113 12_Re: MQSeries10_Wang.James24_Wang.James@AAA-CALIF.COM31_Thu, 17 Feb 2000 10:12:19 -0800733_us-ascii Yes, there is one. Try this address MQSERIES@AKH-WIEN.AC.AT

James Wang Sr. Systems Programmer Automobile Club of Southern California (714) 850-2851 Wang.James@aaa-calif.com

-----Original Message----- From: Joe Abbagnaro [SMTP:Joe_Abbagnaro@PRAXAIR.COM] Sent: Thursday, February 17, 2000 05:30 AM To: DB2-L@RYCI.COM Subject: MQSeries

Anyone know of a forum like this for MQseries ?

Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18013 155 28_Re: Repost: Re: -805 SQLCODE0_20_ddlusk@HOUSEHOLD.COM31_Thu, 17 Feb 2000 12:12:39 -0600616_us-ascii jkalman@unch.unc.edu

in your working storage: 01 DSNTIAR-MESSAGE. 05 DSNTIAR-LEN PIC S9(4) COMP VALUE +1320. 05 DSNTIAR-TEXT OCCURS 10 TIMES INDEXED BY DSNTIAR-IND PIC X(132). 01 DSNTIAR-TEXT-LEN PIC S9(8) COMP VALUE +132.

the code to call this puppy:

MOVE SQLCODE TO DB2-SQL-CODE. MOVE DB2-SQL-CODE TO DISPLAY-SQL-CODE.

IF REC-IS-OK ....<>) ELSE DISPLAY 'SQL RETURN CODE: ' DISPLAY-SQL-CODE <> PERFORM X00000-ERROR-HANDLING THRU X00000-EXIT MOVE DISPLAY-SQL-CODE TO WS-ABEND-CODE PERFORM Z006-ROLLBACK THRU Z006-EXIT CALL 'ILBOABN0' USING WS-ABEND-CODE END-IF. [...] 18169 169 28_Re: Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 17 Feb 2000 13:21:21 -0500462_iso-8859-1 thank you.

-----Original Message----- From: ddlusk@HOUSEHOLD.COM [mailto:ddlusk@HOUSEHOLD.COM] Sent: Thursday, February 17, 2000 1:13 PM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE



jkalman@unch.unc.edu

in your working storage: 01 DSNTIAR-MESSAGE. 05 DSNTIAR-LEN PIC S9(4) COMP VALUE +1320. 05 DSNTIAR-TEXT OCCURS 10 TIMES INDEXED BY DSNTIAR-IND PIC X(132). 01 DSNTIAR-TEXT-LEN PIC S9(8) COMP VALUE +132. [...] 18339 19 40_QMF for Windows (www.Rocketsoftware.com)10_Park, Stan17_SPark@STATE.NM.US31_Thu, 17 Feb 2000 11:25:41 -0700509_iso-8859-1 We are looking at doing this DB2 product along with the multi-platform security, support, connectivity, training, etc. issues that are involved. Any comments from current users would be welcome.

Thanks, Stan Park State of New Mexico Santa Fe, NM USA

================================================ 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. 18359 38 11_Spufi query0_20_ddlusk@HOUSEHOLD.COM31_Thu, 17 Feb 2000 12:25:32 -0600490_us-ascii hi we're on OS/390 DB2 V5

We have a table, that has the customer number (dec 11) primary key, account number (char 19) primary key business unit (char 3) primary key

we want to retrieve the customer's on this table that has more than one account

the query

SELECT customer_number, ACCT_NUM, BUS_unit FROM D2DMA.customer_table WHERE 1 < (SELECT COUNT(DISTINCT customer_number) FROM D2DMA.customer_table) GROUP BY customer_number, ACCT_NUM, BUS_unit; [...] 18398 22 15_Re: Spufi query13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Thu, 17 Feb 2000 13:36:58 -0500524_iso-8859-1 HAVING ?

-----Original Message----- From: ddlusk@HOUSEHOLD.COM [mailto:ddlusk@HOUSEHOLD.COM] Sent: Thursday, February 17, 2000 1:26 PM Subject: Spufi query

...

is there a way to modify this query to only return the customers with 2 or more accounts??

================================================ 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. 18421 56 15_Re: Spufi query20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 17 Feb 2000 13:38:09 -0500635_us-ascii SELECT CUSTOMER_NUMBER,COUNT(*) FROM D2DMA.customer_table GROUP BY CUSTOMER_NUMBER HAVING COUNT(*) > 1



> -----Original Message----- > From: ddlusk@HOUSEHOLD.COM [SMTP:ddlusk@HOUSEHOLD.COM] > Sent: Thursday, February 17, 2000 1:26 PM > To: DB2-L@RYCI.COM > Subject: Spufi query > > hi > we're on OS/390 DB2 V5 > > We have a table, that has > the customer number (dec 11) primary key, > account number (char 19) primary key > business unit (char 3) primary key > > we want to retrieve the customer's on this table that > has more than one account > > the query > > SELECT customer_number, ACCT_NUM, BUS_unit [...] 18478 15 22_DB2 UDB Communications12_Dan Sullivan28_daniel.sullivan@ZURICHUS.COM31_Thu, 17 Feb 2000 12:46:11 -0600434_us-ascii If I telnet to a Unix box, can I use the DB2 Control Center GUI to manage DB2 remotely, or do I need some kind of client software or a third party tool to manage DB2 remotely? Thanks.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 18494 82 21_Re: SQL/PL in DB2 v5?0_24_lightsey@ITS.STATE.MS.US31_Thu, 17 Feb 2000 12:45:49 -0600600_us-ascii Our users are calling DB2 ( os/390 ) stored procedures from Powerbuilder apps on the client stations. The stored procedures are written in Cobol for MVS. There is no process/task outside of db2 or the operating system involved - the cics region previously associated with this application has been eliminated. The non-db2 parts are, from my perspective, parts of the operating system - tcp/ip, unix system services, workload manager. With my version - db2 v5 - there is no equivalent to sql/pl, but that isn't really a drawback for us. There is also the benefit of being able to access [...] 18577 68 21_Re: SQL/PL in DB2 v5?14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 17 Feb 2000 14:04:34 -0500409_iso-8859-1 You can use either SQL Procedures language or a 3GL (COBOL, C etc) to write stored procedures in DB2 V5 or above in OS/390. I had to download a zip file from IBM's homepage for the SQL Procedures support. The 3GL support is built in.

Whether you build your Stored Procedures using 3GL or SQL Procedures language you can always invoke it from client program either on MVS or AIX,NT etc. [...] 18646 171 28_Re: Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 17 Feb 2000 14:05:37 -0500538_iso-8859-1 This probably would work fine in batch, you cannot have display's in CICS.

Jeff

-----Original Message----- From: ddlusk@HOUSEHOLD.COM [mailto:ddlusk@HOUSEHOLD.COM] Sent: Thursday, February 17, 2000 1:13 PM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE



jkalman@unch.unc.edu

in your working storage: 01 DSNTIAR-MESSAGE. 05 DSNTIAR-LEN PIC S9(4) COMP VALUE +1320. 05 DSNTIAR-TEXT OCCURS 10 TIMES INDEXED BY DSNTIAR-IND PIC X(132). 01 DSNTIAR-TEXT-LEN PIC S9(8) COMP VALUE +132. [...] 18818 182 15_Re: Spufi query16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Thu, 17 Feb 2000 14:17:24 -0500677_- Try this

SELECT distinct customer_number, ACCT_NUM, BUS_unit, count(*) FROM D2DMA.customer_table group by customer_number, ACCT_NUM, BUS_unit having count(*) > 1

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: ddlusk@HOUSEHOLD.COM [SMTP:ddlusk@HOUSEHOLD.COM] > Sent: Thursday, February 17, 2000 1:26 PM > To: DB2-L@RYCI.COM > Subject: Spufi query > > hi > we're on OS/390 DB2 V5 > > We have a table, that has > the customer number (dec 11) primary key, > account number (char 19) primary key > business unit (char 3) primary key > > we want to retrieve the customer's on this table that [...] 19001 39 26_Re: DB2 UDB Communications14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 17 Feb 2000 14:17:48 -0500554_iso-8859-1 You don't need to Telnet to a Unix box to use DB2 Control Center. DB2 Control center runs on your PC (win95,NT) and it comes with DB2 CAE. As far as I know thats all you need to manage databases on AIX or NT remotely.



> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Dan Sullivan > Sent: Thursday, February 17, 2000 1:46 PM > To: DB2-L@RYCI.COM > Subject: DB2 UDB Communications > > > If I telnet to a Unix box, can I use the DB2 Control Center GUI > to manage DB2 > [...] 19041 204 28_Re: Repost: Re: -805 SQLCODE14_Arnold, Mark S20_Mark.Arnold@BNSF.COM31_Thu, 17 Feb 2000 13:31:24 -0600575_iso-8859-1 in cics:

CALL 'DSNTIAR' USING SQLCA, W-DSNTIAR-SQLCODE-MSG, W-DSNTIAR-TEXT-LTH END-CALL

IF (RETURN-CODE EQUAL ZERO) MOVE +7 TO WS-JUST-SUB PERFORM VARYING DSNTIAR-INDEX FROM 1 BY 1 UNTIL DSNTIAR-INDEX > W-DSNTIAR-MSG-LINES EXEC CICS SEND TEXT FROM (W-DSNTIAR-MSG-TEXT(DSNTIAR-INDEX)) JUSTIFY (WS-JUST-SUB) END-EXEC ADD 1 TO WS-JUST-SUB END-PERFORM END-IF



-----Original Message----- From: Kalman, Jeff [mailto:JKalman@UNCH.UNC.EDU] Sent: Thursday, February 17, 2000 1:06 PM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE [...] 19246 95 44_Re: V6 Host Variables no colons and Platinum8_Long, Ed15_Ed.Long@FMR.COM31_Thu, 17 Feb 2000 14:33:09 -0500617_- Thanks for the info.

Our rule for such transitions, since there is a cost associated with it even if your interpretation is correct, is to present that fact to management as early in the project as possible. That way we have enough time to plan etc.

Stated another way, no surprises.





> -----Original Message----- > From: Pillay, Venkat (PCA) [SMTP:venkat_pillay@ML.COM] > Sent: Thursday, February 17, 2000 11:39 AM > To: DB2-L@RYCI.COM > Subject: Re: V6 Host Variables no colons and Platinum > > Ed > > The host variables without colon will only pose a problem for a > new [...] 19342 98 21_FW: SQL/PL in DB2 v5?13_Brendan Friel18_b.friel@PECORP.COM31_Thu, 17 Feb 2000 13:22:33 -0600381_iso-8859-1 One thing to bear in mind is that stored procedures for DB2 V5 can only be written in LE versions of the IBM programming languages. These are the 'language environment' versions. You may also hear them referred to as the OS/390 or 'for MVS and VM' versions.

If you are in a big shop, they probably have the latest and greatest versions, so you should be OK. [...] 19441 218 28_Re: Repost: Re: -805 SQLCODE12_Kalman, Jeff20_JKalman@UNCH.UNC.EDU31_Thu, 17 Feb 2000 14:36:32 -0500610_iso-8859-1 Thank you for your reply.

-----Original Message----- From: Arnold, Mark S [mailto:Mark.Arnold@BNSF.COM] Sent: Thursday, February 17, 2000 2:31 PM To: DB2-L@RYCI.COM Subject: Re: Repost: Re: -805 SQLCODE



in cics:

CALL 'DSNTIAR' USING SQLCA, W-DSNTIAR-SQLCODE-MSG, W-DSNTIAR-TEXT-LTH END-CALL

IF (RETURN-CODE EQUAL ZERO) MOVE +7 TO WS-JUST-SUB PERFORM VARYING DSNTIAR-INDEX FROM 1 BY 1 UNTIL DSNTIAR-INDEX > W-DSNTIAR-MSG-LINES EXEC CICS SEND TEXT FROM (W-DSNTIAR-MSG-TEXT(DSNTIAR-INDEX)) JUSTIFY (WS-JUST-SUB) END-EXEC ADD 1 TO WS-JUST-SUB END-PERFORM END-IF [...] 19660 38 26_Re: DB2 UDB Communications14_Philip Gunning20_pgunning@BOSCOVS.COM31_Thu, 17 Feb 2000 14:48:27 -0500499_iso-8859-1 Dan, You if you have an NT workstation, etc available, you can install the Control center on that and administer the unix instance from there. HTH Phil Philip K. Gunning DB2 DBA IBM Certified Advanced Technical Expert - DB2 DRDA IBM Certified Solutions Expert -- CICS TS

----- Original Message ----- From: Dan Sullivan Newsgroups: bit.listserv.db2-l To: Sent: Thursday, February 17, 2000 1:46 PM Subject: DB2 UDB Communications [...] 19699 98 28_Re: DB2 hardware compression12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Thu, 17 Feb 2000 21:51:36 +0200490_x-user-defined Hi, I'll try to the whole test again + count(*) and more changes and mail a report again. It will take some time to arrange.

Isaac Yassin

Jim Lewandowski wrote: > > I would still like to see the SQL COUNT(*) test to see how that fits > with your results. > > Jim Lewandowski > > Isaac Yassin wrote: > > > > Hi, > > > > It was done with DSNTEP2. Output directed to DD DUMMY with dcb=bufno=80. > > > > Isaac Yassin > > > > Jim Lewandowski wrote: > > > > > > [...] 19798 40 28_db2 irlm csa inconsistencies10_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 17 Feb 2000 15:05:24 -0500532_us-ascii HI all

can some one clear up some inconsistencies with irlm storage.

I changed from pc=yes to pc=no with a maxcsa =6m. I then waited 4 days and issued the 'modify db2tirlm,status,stor' command with the following results.

DXR100I DX2T001 STOR STATS PC: NO MAXCSA: 6M CSA USE: ACNT: 324K AHWM: 1092K CUR: 800K HWM: 1568K ABOVE 16M: 19 795K BELOW 16M: 3 5K CLASS TYPE SEGS MEM TYPE SEGS MEM TYPE SEGS MEM ACCNT T-1 4 256K T-2 1 64K T-3 1 4K PROC WRK 5 30K SRB 1 1K OTH 1 1K MISC VAR 7 417K N-V 6 22K [...] 19839 139 44_Re: V6 Host Variables no colons and Platinum20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 17 Feb 2000 15:10:27 -0500384_iso-8859-1 Nice plan, But scan through the source codes of programs. Don't look at the DB2 catalog. Because DB2 catalogs are perfect. You won't find it there.

This is how it works.

The precompiler recognizes that host var is missing semi-colon but it generates the DBRM the same way it would have done with semi-colon. The precompiler then issues message DSNH315I. [...] 19979 18 58_INSYNC from MACRO 4 vs. FILEAID for DB2/MVS from Compuware12_Gorse, Darry20_Darry_Gorse@AFCC.COM31_Thu, 17 Feb 2000 14:32:17 -0600389_us-ascii Greetings, We have been asked to look at INSYNC/DB2 and DUMPMASTER from MACRO 4. Can anyone share any experiences with MACRO 4? TIA, Darry

================================================ 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. 19998 193 44_Re: V6 Host Variables no colons and Platinum20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 17 Feb 2000 15:54:19 -0500557_iso-8859-1 Oops.. Did I say semi-colon ? I meant colon. Sorry about that.

> -----Original Message----- > From: Long, Ed [SMTP:Ed.Long@fmr.com] > Sent: Thursday, February 17, 2000 3:33 PM > To: 'Venkat_Pillay@ml.com' > Subject: RE: V6 Host Variables no colons and Platinum > > Thanks for the extra info. > > I think we are talking about a colon ":" and not a semi-colon ";". > I will report to the group what we come up with. > Precompiling 2,000 modules doesn't sound too pretty though; as you noted > it > may turn out to be the best option. > [...] 20192 82 24_Repost: Re: -805 SQLCODE12_BOB JEANDRON21_BOB.JEANDRON@USDA.GOV31_Thu, 17 Feb 2000 14:55:00 -0500489_- This is a guideline I use for -805s in CSP: Some of this has already been said. Problems: - When get a -805, dbrm not found in PLAN / Timestamp mismatch



FIRST: - Select * from sysibm.syspacklist where planname = 'PLANNAME'; Check that the packages were bound into the correct plan with the correct collection id. Verify that the package exist in the collection. Check for Os and 0s everywhere including the RCT. Check for misplaced commas and incorrect parms in RCT. [...] 20275 18 27_:LOCKPART Tablespace option13_Moss, William15_MossW@AETNA.COM31_Thu, 17 Feb 2000 15:58:13 -0500543_- Does anyone have any opinions about using the LOCKPART option for partitioned tablespaces in DB2 Version 5.1 (OS/390) ? I've read about it in the SQL Reference manual and I can't think of a reason not to set it to YES for all partitioned tablespaces.

TIA,

Bill Moss Aetna/US Healthcare

================================================ 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. 20294 47 31_Re: :LOCKPART Tablespace option20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Thu, 17 Feb 2000 16:12:41 -0500673_us-ascii This has been discussed earlier probably when list was under American university. Chris Munson has explained it very well.

To recap the gist ---> If you are on non-datasharing environment then use LOCKPART YES when you expect Lock escalation. Don't use it otherwise.

If you are on data-sharing environment then LOCKPART plays a role. The Coupling Facility(CF) overheads could be reduced by specifying LOCKPART yes. It all depends how applications are accessing the various partitions and from which members. It is also possible that overheads could increase due to LOCKPART YES. Blindly setting LOCKPART YES for all the partitioned tablespaces, [...] 20342 41 28_Basic UDF Question - I think12_Chris Miller24_Chris_Miller@PAYLESS.COM31_Thu, 17 Feb 2000 15:18:48 -0600446_us-ascii Platform: DB2 UDB 5.2 AIX and NT (I understand UDFs are now available on OS/390 version 6.x as well)



I have not created any UDFs before and am not quite sure how to proceed. Any feedback would be appreciated. Here's the situation:

I would like to create a UDF that would use only built in DB2 functions. Essentially, all I would like to do is calculate a date that is 'x' weeks from a given date. For example: [...] 20384 27 30_unload db2 table to flat files17_ARUN SWARNABADRAN21_s_arun111@HOTMAIL.COM29_Thu, 17 Feb 2000 13:51:57 PST355_- What is the efficient way to unload multiple tables to flat file?.

our batch application requires snap shot(point in time) of DB2 tables in a flat file for the process. The window available for the download is very limited.

Details: 1. 8 tables with each 120 million records. 2. Our batch can not read DB2, expects in flat file only. [...] 20412 50 34_Re: unload db2 table to flat files12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 17 Feb 2000 14:08:18 PST632_- With the quantity of data you are working with, I strongly suggest a 3rd party unload tool. Both CA/Platinum and BMC have VERY GOOD products in this area. I have not worked with any of the others.

HTH, Craig Patton Independent DB2 DBA



>From: ARUN SWARNABADRAN >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: unload db2 table to flat files >Date: Thu, 17 Feb 2000 13:51:57 PST > >What is the efficient way to unload multiple tables to flat file?. > >our batch application requires snap shot(point in time) of DB2 tables in a >flat file for [...] 20463 66 34_Re: unload db2 table to flat files24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 17 Feb 2000 14:11:50 -0800586_- IBM's new unload utility should also work for this.

> -----Original Message----- > From: craig patton [SMTP:prgpatton@HOTMAIL.COM] > Sent: Thursday, February 17, 2000 2:08 PM > To: DB2-L@RYCI.COM > Subject: Re: unload db2 table to flat files > > With the quantity of data you are working with, I strongly suggest a 3rd > party unload tool. Both CA/Platinum and BMC have VERY GOOD products in > this > area. I have not worked with any of the others. > > HTH, > Craig Patton > Independent DB2 DBA > > > >From: ARUN SWARNABADRAN > >Reply-To: DB2 Data [...] 20530 54 34_Re: unload db2 table to flat files14_Maxfield, John21_John_Maxfield@BMC.COM31_Thu, 17 Feb 2000 16:13:37 -0600375_iso-8859-1 Sorry for the plug... but I couldn't resist.

Are you looking for a 3rd party solution? If not... ignore the remainder of this response.

BMC Software's UNLOAD PLUS for DB2 can unload multiple tables from multiple tablespaces to a single file. If the tables reside in a single tablespace, all tables are unloaded in a single pass over the object. [...] 20585 31 20_resizing active logs10_Mike Evans28_Evansmp@CO.MECKLENBURG.NC.US31_Thu, 17 Feb 2000 17:14:07 -0500313_US-ASCII We need to increase the size of our active logs and want to make sure this is done correctly. Our take is:

1) bring down db2 subsystem 2) define new vsam datasets with larger size 3) repro current logs to new logs 4) delete old logs 5) rename new logs to old name 6) bring subsystem back up. [...] 20617 66 34_Re: unload db2 table to flat files0_19_Tim.Lowe@STPAUL.COM31_Thu, 17 Feb 2000 16:25:15 -0600726_us-ascii And, of course REORG UNLOAD EXTERNAL......













ARUN SWARNABADRAN on 02/17/2000 03:51:57 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Tim Lowe/sfm/spc)





Subject: unload db2 table to flat files















What is the efficient way to unload multiple tables to flat file?.

our batch application requires snap shot(point in time) of DB2 tables in a flat file for the process. The window available for the download is very limited. [...] 20684 68 34_Re: unload db2 table to flat files27_Lin, Josefina S (Jo), CSCIO12_jlin@ATT.COM31_Thu, 17 Feb 2000 17:15:48 -0500466_iso-8859-1 If this unload process needs to be done frequently, he UNLOAD PLUS would definitely justify the cost. The UNLOAD time can be cut significantly. I don't know if the IBM UNLOAD utility DSNTIAUL can be done with the DEGREE option to speed up the unload? JL - AT&T

-----Original Message----- From: craig patton [mailto:prgpatton@HOTMAIL.COM] Sent: Thursday, February 17, 2000 5:08 PM To: DB2-L@RYCI.COM Subject: Re: unload db2 table to flat files [...] 20753 53 24_Re: resizing active logs11_rick creech18_ykcirc@HOTMAIL.COM29_Thu, 17 Feb 2000 14:52:37 PST319_- Mike, I would not delete the old logs where you did..but rename them to .old and they will be available as a backup if something goes wrong. I would also do a print log map with DSNJU004 just after bringing DB2 down to have a nice clean document of all the correct RBAs in each of the logs. Regards, Rick Creech [...] 20807 139 28_Re: DB2 hardware compression14_Richard Yevich21_ryevich@ATTGLOBAL.NET31_Thu, 17 Feb 2000 17:06:07 -0500612_x-user-defined Curious. At what point does SELECT COUNT(*) decompress data?

Regards, Richard +===+===+===+===+====+ ryevich@attglobal.net

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On > Behalf Of Isaac Yassin > Sent: Thursday, February 17, 2000 2:52 PM > To: DB2-L@RYCI.COM > Subject: Re: DB2 hardware compression > > > Hi, > I'll try to the whole test again + count(*) and more changes and > mail a report > again. > It will take some time to arrange. > > Isaac Yassin > > Jim Lewandowski wrote: > > > > I would still like to see the SQL [...] 20947 84 34_Re: unload db2 table to flat files14_Maxfield, John21_John_Maxfield@BMC.COM31_Thu, 17 Feb 2000 17:23:28 -0600448_iso-8859-1 Arun,

To reemphasize, IBM's new unload utility and the REORG UNLOAD EXTERNAL option do not provide an outageless solution. BMC's UNLOAD PLUS for DB2 does.

-----Original Message----- From: Leblanc, Francis C - CNF [mailto:Leblanc.Francis@CNF.COM] Sent: Thursday, February 17, 2000 4:12 PM To: DB2-L@RYCI.COM Subject: Re: unload db2 table to flat files



IBM's new unload utility should also work for this. [...] 21032 43 27_Re: DB2 rebinds from where?10_Leo Flores23_leoflores@EARTHLINK.NET31_Thu, 17 Feb 2000 17:58:38 -0800635_us-ascii Just Guessing here.

For Plans: SYSIBM.SYSPLAN and SYSIBM.SYSPACKLIST(if Packages are involved)

For Packages: SYSIBM.SYSPACKAGES

HTH and hope someone validates this.

Leo Flores

Rowell, Dean A wrote:

> Could anyone tell me, where does DB2 get its parmlist to do rebinds when > object changes invalidate a plan - forcing a one time rebind? > E.G. 1) Program A is rebound with new parms > 2) Objects accessed by program A are altered > 3) Progam A is invalidated > 4) At execution time program A is rebound using defaults/parms from > where? > 5) Currently we are loosing binds from [...] 21076 25 33_Re: Data externalisation question12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Feb 2000 20:36:05 -0600312_- The process is not simple, and all of the processes are related. Here is a deliberate oversimplification. The two phase commit protocol means that we have written the log before you are told the work is committed. So you can't have work that needs to be written without having the information in the log. [...] 21102 23 21_Re: SQL/PL in DB2 v5?12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 17 Feb 2000 20:48:46 -0600517_- I think the best web page to answer your question is yes, see http://www.ibm.com/software/db2os390/sqlproc

It's titled IBM DB2 SQL Procedures & IBM DB2 Stored Procedure Builder It has variations for V5 and V6.

You can download the support or get the Adobe Acrobat (PDF)description of the standard SQL Procedures Language in the document called Preview for SQL Procedures for DB2 Version 5. Here's where my browser was pointed: http://www-4.ibm.com/software/data/db2/os390/pdf/sqlproc_oct1999.pdf [...] 21126 195 77_Repost: DB2 acheives world record performance in first ever SAP B W Benchmark13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:46 -0700726_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

In another demonstration of the power and scalability of DB2, IBM announced on February 15, 2000 the first ever SAP Business Information Warehouse (SAP BW) benchmark using DB2 and IBM RS/6000 S80 Server. IBM also announced that customers implementing SAP BW can now choose the "IBM Solution Series for SAP [...] 21322 292 101_Repost: IBM and Siebel Systems Form Global Strategic Alliance to Deliver CRM Solutions for e-business13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:50 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:12 PM --------------------------- [...] 21615 398 96_Repost: CORRECTION: IBM DB2 OLAP Server for OS/390, Version 1.1 ( Preview Announcement, 11/2/99)13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:50 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:11 PM --------------------------- [...] 22014 137 55_Repost: S/390 and ESS Lead the Way with DB2 Performance13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:50 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:11 PM --------------------------- [...] 22152 451 62_Repost: Red Herring Feature Story on IBM, "New Shades of Blue"13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:51 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:10 PM --------------------------- [...] 22604 165 37_Repost: Recent Analyst Reports on DB213_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:52 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:10 PM --------------------------- [...] 22770 133 74_Repost: IBM Redbook: "Selecting A Server - Value of S/390" (SG24- 4812-01)13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:51 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:11 PM --------------------------- [...] 22904 290 38_Repost: DB2 Skills and Training Update13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:52 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:10 PM --------------------------- [...] 23195 148 71_Repost: "IBM Adds Fuel to its Data Management File" (PC Week 12/0 3/99)13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:53 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:09 PM --------------------------- [...] 23344 380 35_Repost: SAP Chooses DB2 Over Oracle13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:53 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:09 PM --------------------------- [...] 23725 255 99_Repost: IBM Enterprise Information Portal Version 6.1 Raises the Bar for Corporate Portal Solutions13_Morrill, John12_JohnM@VP.NET31_Thu, 17 Feb 2000 20:43:52 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:09 PM --------------------------- [...] 23981 15 24_db2 manual in pdf format28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Thu, 17 Feb 2000 20:13:13 PST374_- Khalid, Here you go:

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

Dan Courter DB2 Utilities Development

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 23997 28 39_Re: QUALIFIER option of BIND going away13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 17 Feb 2000 23:34:18 -0500381_iso-8859-1 Greg,

Go ON!!!!

Which MORON told you this lie?!!!

I'm not privy to IBM's future plans, but it's inconceivable to me that DB2 development would risk the havoc this would cause.

Please entertain us all with the source of this nonsense.

(If Compuware were cool enough to share these opinions, they'd be different than they(we) are.) [...] 24026 16 17_Re: DYNAMIC QUERY14_Prakash Upreti26_pcupreti@LOT.TATASTEEL.COM29_Fri, 18 Feb 2000 04:43:29 GMT303_us-ascii mike

thanx for the suggestion

-prakash

================================================ 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. 24043 105 34_Re: unload db2 table to flat files12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 18 Feb 2000 08:18:18 +0200618_x-user-defined Hi, That's correct as for now. BUT you have to buy two products: "UNLOAD PLUS" & "XBM".

Isaac Yassin



"Maxfield, John" wrote: > > Arun, > > To reemphasize, IBM's new unload utility and the REORG UNLOAD EXTERNAL > option do not provide an outageless solution. BMC's UNLOAD PLUS for DB2 > does. > > -----Original Message----- > From: Leblanc, Francis C - CNF [mailto:Leblanc.Francis@CNF.COM] > Sent: Thursday, February 17, 2000 4:12 PM > To: DB2-L@RYCI.COM > Subject: Re: unload db2 table to flat files > > IBM's new unload utility should also work for this. > > > -----Original [...] 24149 133 45_Re: Java SQL Error when attempting to connect14_Julian Stuhler27_julian.stuhler@TRITON.CO.UK31_Thu, 17 Feb 2000 22:54:36 -0800520_- Hi Tony.

The last part of the URL on a JDBC connect string needs to be the subsystem location name, as defined in the BSDS.

Take a look at your BSDS - is the location name set to DB2XLOC?

Good luck,

Julian



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

Julian Stuhler DB2 Specialist, IBM Gold Consultant Triton Consulting

E-mail: julian.stuhler@triton.co.uk Web: http://www.triton.co.uk Mobile: +44 (0)7768 446927 Office Tel: +44 (0)1603 693517 Office Fax: +44 (0)1603 693531 [...] 24283 19 34_Re: unload db2 table to flat files14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 18 Feb 2000 08:36:44 +0100441_us-ascii Sorry for the plug... but I couldn't resist: IT cost too much.....try to low prices.

Regard Max Scarpa Data & System Admin

Personal opinion & all disclaimer you can image apply

================================================ 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. 24303 40 24_Re: resizing active logs14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 18 Feb 2000 08:47:05 +0100293_us-ascii Pay attention !!

If logs are of an old version of DB2 (say a migration from v 2.3 to 3 to 4 and so on without a

redefine of all logs) your REPRO may terminate with an error. It happened some time ago when

we resized our production log to fit a 36-trks tape. [...] 24344 91 20_Re: DB2 SQL Analysis5_Pearl17_panidak@SCB.CO.TH31_Fri, 18 Feb 2000 15:09:35 +0700778_windows-874 Select CUSTOMER_NUMBER,COUNT(*) AS TOT_ACCT FROM (SELECT CUSTOMER_NUMBER,ACCT_NUM,COUNT(*) AS TOT_BUS_UNIT FROM D2DMA.CUSTOMER_TABLE GROUP BY CUSTOMER_NUMBER,ACCT_NUM) AS TB_TEMP GROUP BY CUSTOMER_NUMBER HAVING COUNT(*) > 1

-----Original Message----- From: Suresh Sane Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Date: 12 ˇŘÁŔҾѹ¸ě 2543 0:54 Subject: Re: DB2 SQL Analysis



>Platinum has a host of products - Plan Analyzer, SQl-Ease and an Index >Analyzer. I have used Plan Analyzer extensively and use it to weed out the >trivial and focus on the real problem SQL. I think BMC also has a simila >product (Explorer?). Candle's DB explain, Landmark's explain within TMON >are some of the other [...] 24436 43 20_Daylight Saving Time12_Ian Skellern27_ian.skellern@BARCLAYS.CO.UK31_Fri, 18 Feb 2000 08:37:46 +0000486_US-ASCII Does anyone have any experience of making the clock change for daylight savings dynamically using the sysplex timer whilst DB2 is up and running ?

I understand that DB2 is using GMT/UCT times for it's internal processing and in theory it should, therefore, be able to take this in it's stride. I am, however, interested to see if anyone has actually done this with a busy system active and to give me any advice on any potential problems that I should be aware of. [...] 24480 33 18_RACF/DB2 Interface11_Nigel McRoe26_nigel.mcroe@BARCLAYS.CO.UK31_Fri, 18 Feb 2000 09:13:10 +0000514_US-ASCII Has anyone implemented the RACF/DB2 interface DSNX@XAC in production on DB2/OS390. I would be grateful to hear of any experiences or pitfalls encountered etc.

Nigel McRoe Barclays Bank Plc nigel.mcroe@barclays.co.uk



Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group. 24514 171 47_Re: Replace Into option for Simple Tablespace !15_Rene Hendriksen16_reh@NOTES.BEC.DK31_Fri, 18 Feb 2000 10:25:28 +0100405_iso-8859-1



Hi Deepak From all the other answers, you can se your data is gone for all tables. But I didn't find any advise in recovering the data, but here is a way. 1) get the right HEX(CONTOKEN) from SYSIBM.SYSCOPY. 2) Use this as input to your RECOVER TORBA X'contoken' and all your data for all tables in the tablespace will be the same as prior to your unfortunate load replace. [...] 24686 56 22_Re: QSP Universal OLAS0_24_James_Hughes@MANDG.CO.UK31_Fri, 18 Feb 2000 10:11:59 +0000603_us-ascii Just picked up your question, surprised that no one has commented yet as there are users out there. Agree with you that performance in certain areas are a concern. Am I right in thinking that the main culprit's are QED's? Have already discussed with QSP some index changes and/or additional indexes, but I am awaiting responses. As this is a change to the product they may be reluctant to do so. Alternatively I have looked into creating addition indexes on certain tables TEDTRAN/TEBBALS as examples, but this means I will maintain them independent of upgrades etc. Haven't had much time [...] 24743 82 22_Re: QSP Universal OLAS13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Fri, 18 Feb 2000 10:38:41 +0000356_us-ascii James,

I replied (private e-mail) a few days ago - I've not had a reply yet.

It's good to know who else is running OLAS in the UK. Do you go to GSE meetings - perhaps we can talk there ?

Our performance problems were mainly due to deadlocks on the TZ series of tables - but V5's better lock avoidance fixed most of that. [...] 24826 29 16_DB2 on Linux 6.113_Viswanathan N33_Viswanathan.N@POWAIMAIL.LTITL.COM31_Fri, 18 Feb 2000 18:04:23 +0530499_us-ascii hi !!

I was installing DB2 V 6.1 on Linux 6.1 . I ran short of space and had to cancel the process of installation during the creation of sample database. It was waiting for a long time here ... 30 mins . Then we had to cancel it. after it recovered Since the services had started during the installation initial phase. ,It did'nt do the cleanup. The log told that it had not configured the administration server. So we are trying to re-install it again , after manual cleanup. [...] 24856 13 24_Re: resizing active logs11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Fri, 18 Feb 2000 06:46:44 -0600346_- Speaking sizing for 36-trk tape, what size are your active logs? Regards, John Rosser Duke Energy Corp

================================================ 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. 24870 106 47_Re: Replace Into option for Simple Tablespace !15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 18 Feb 2000 05:03:42 +0000447_iso-8859-1 Hello Deepak,

Many moons ago I wrote a program that runs as a preprocessor to the DB2 load utility. It will prevent the situation you describe from happening. I sold it to DB2 update so I guess you'd be able to find it in their archive...

Regards,

Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 24977 34 24_Re: Daylight Saving Time12_Jim Harrison12_jimh@QIS.NET31_Fri, 18 Feb 2000 08:17:32 -0500609_us-ascii Not sure about the DB2 side of the question, but daylight savings time changes have been the topic of extensive discussions on IBM-Main in the past. Try searching http://www.deja.com for the archives.

At 08:37 AM 2/18/00 +0000, you wrote: >Does anyone have any experience of making the clock change for daylight >savings dynamically using the sysplex timer whilst DB2 is up and >running ? > >I understand that DB2 is using GMT/UCT times for it's internal >processing and in theory it should, therefore, be able to take this in >it's stride. I am, however, interested to see if anyone has [...] 25012 79 31_Re: :LOCKPART Tablespace option19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Fri, 18 Feb 2000 07:16:01 -0600467_iso-8859-1 Hi all, LOCKPART isn't guarantee of partition level locking, note following from DB2 for OS/390 V5 Admin Gde:

"Restrictions: If any of the following conditions are true, DB2 must lock all partitions when LOCKPART YES is used:

- A type 1 index is used in the access path - The plan is bound with ACQUIRE(ALLOCATE) - The table space is defined with LOCKSIZE TABLESPACE - When LOCK TABLE IN EXCLUSIVE MODE is used (without the PART option) [...] 25092 110 47_Re: Replace Into option for Simple Tablespace !12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 18 Feb 2000 07:30:42 -0600574_iso-8859-1 Tonie:

Who is DB2 update and how are they contacted?

GSH ----- Original Message ----- From: "Toine Michielse" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, February 17, 2000 11:03 PM Subject: Re: Replace Into option for Simple Tablespace !



Hello Deepak,

Many moons ago I wrote a program that runs as a preprocessor to the DB2 load utility. It will prevent the situation you describe from happening. I sold it to DB2 update so I guess you'd be able to find it in their archive... [...] 25203 53 24_Re: resizing active logs50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Fri, 18 Feb 2000 08:56:26 -0500577_- KEEP IN MIND WHEN RESIZING YOUR LOGS THAT WHEN THEY ARCHIVE TO TAPE YOU DO NOT GO ONTO TWO TAPES. AVOID THIS. IN DB2 V4 D/R WE HAD PROBLEMS WITH A LOG THAT SPANNED 2 TAPES, DUE TO SHORT TAPES BEING USED.

BOB KNIGHT (NOT THE BASKETBALL COACH)



> ---------- > From: Mike Evans[SMTP:Evansmp@CO.MECKLENBURG.NC.US] > Reply To: DB2 Data Base Discussion List > Sent: Thursday, February 17, 2000 5:14 PM > To: DB2-L@RYCI.COM > Subject: resizing active logs > > We need to increase the size of our active logs and want to make sure this > is done correctly. [...] 25257 130 47_Re: Replace Into option for Simple Tablespace !12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Fri, 18 Feb 2000 14:04:00 -0000414_- Try www.xephon.com/db2update.html.

They publish monthly in booklet form on a paid subscription basis but articles older than 12 months can be viewed on their web site free of charge.

Colin Allen, DB2 DBA Abbey National

Colin.Allen@AbbeyNational.Co.Uk ---------- From: Gerald Hodge To: DB2-L@RYCI.COM Subject: Re: Replace Into option for Simple Tablespace ! Date: 18 February 2000 13:30 [...] 25388 104 22_Re: QSP Universal OLAS12_Greg Popwell27_greg.popwell@MOTION-IND.COM31_Fri, 18 Feb 2000 08:10:27 -0600319_iso-8859-1 Just saw your OLAS email today. We are running QSP/OLAS in the USA at Motion Industries. We also had contention problems on the TZ* tables, even with Row Level Locking. Adding some rows to spread out the access has helped. Haven't had any problems with TEDTRAN/TEBBALS tables.

Greg Popwell - DBA [...] 25493 33 27_Re: DB2 rebinds from where?13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 18 Feb 2000 09:17:05 -0500326_iso-8859-1 I agree with Leo Flores's guess that they come from the catalog. I had a quick gander through the Admin guide and didn't find anything. But it seems all the parms needed are in the catalog.

What do you mean by >Currently we are loosing binds from step 1 above.< ? Are the rebinds failing? What SQLcode? [...] 25527 54 24_Re: resizing active logs14_Massimo Scarpa16_mscarpa@CESVE.IT31_Fri, 18 Feb 2000 15:26:30 +0100323_us-ascii Mmmm... it was some years ago.....and in a previous shop to use STK & HSC.

Obviously 'it depends' on DB2 activity (I know that a big bank uses a log size of one 3390-3 DASD per EACH log). Our update was during night time & batch; during day were was less (but critical) update. We followed these step: [...] 25582 148 28_Re: DB2 hardware compression15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Mon, 14 Feb 2000 03:55:25 -0600592_us-ascii Upon the WHERE data_column = 'garbage' clause I suppose.



Richard Yevich wrote: > > Curious. At what point does SELECT COUNT(*) decompress data? > > Regards, > Richard > +===+===+===+===+====+ > ryevich@attglobal.net > > > -----Original Message----- > > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On > > Behalf Of Isaac Yassin > > Sent: Thursday, February 17, 2000 2:52 PM > > To: DB2-L@RYCI.COM > > Subject: Re: DB2 hardware compression > > > > > > Hi, > > I'll try to the whole test again + count(*) and more changes and > > mail a report [...] 25731 109 20_Opinons and comments16_Mary Ann Pickett24_pickettm@DOT.STATE.AL.US31_Fri, 18 Feb 2000 08:56:29 -0600404_iso-8859-1 Good morning All,

We are planning to purchase the Human Resources module of Peoplesoft and we are undecided whether to install it on an NT Server or on DB2 on the mainframe.

We are on version 5.1 of DB2 , OS390 with 119 mips and 2 processors. We currently have test, user and production databases running in one subsystem. We also have NT Servers and some Oracle databases. [...] 25841 119 34_Re: unload db2 table to flat files20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 18 Feb 2000 10:07:11 -0500453_us-ascii I don't know about High performance unload from IBM. DB2 has following choices.

As a utility: REORG UNLOAD EXTERNAL is only allowed with SHRLEVEL NONE. This takes DW (Drain the write claims) and UTRO (Utility restrictive read only). The tablespace is allowed any read only accesses.

As DSNTIAUL: "WITH UR" , "WITH CS", "WITH RR" along with SQL('PARM') essentially provides dirty read, cursor stability or read only accesses. [...] 25961 42 22_Re: RACF/DB2 Interface11_Jeff Faughn22_Jeff_Faughn@MAY-CO.COM31_Fri, 18 Feb 2000 09:13:32 -0600569_us-ascii We did! It was the plain version of the exit. It was easy and seems to be working great!.... : )







From: Nigel McRoe on 02/18/2000 03:13 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Jeff Faughn/MDSC/MAYCO)

Subject: RACF/DB2 Interface







Has anyone implemented the RACF/DB2 interface DSNX@XAC in production on DB2/OS390. I would be grateful to hear of any experiences or pitfalls encountered etc. [...] 26004 64 22_Re: RACF/DB2 Interface0_22_BILL_GALLAGHER@PHL.COM31_Fri, 18 Feb 2000 10:13:38 -0500549_us-ascii Nigel,

We are currently in the process of moving all of our DB2 security from native DB2 to RACF. At the moment, we have migrated about half of our applications to RACF, i.e. they are being fully administered under RACF. We hope to complete this project by mid-2000. To date, we have only encountered one problem in which the DSNX@XAC exit was crashing with an 0C4. This problem was subsequently identified and correct by IBM in APAR PQ23197. Other than that, everything has been working as advertised and we are quite pleased. [...] 26069 109 34_Re: unload db2 table to flat files11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 18 Feb 2000 07:28:46 PST697_- John, What does "outageless' mean? Regards, Rick Creech

>From: "Maxfield, John" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: unload db2 table to flat files >Date: Thu, 17 Feb 2000 17:23:28 -0600 > >Arun, > >To reemphasize, IBM's new unload utility and the REORG UNLOAD EXTERNAL >option do not provide an outageless solution. BMC's UNLOAD PLUS for DB2 >does. > >-----Original Message----- >From: Leblanc, Francis C - CNF [mailto:Leblanc.Francis@CNF.COM] >Sent: Thursday, February 17, 2000 4:12 PM >To: DB2-L@RYCI.COM >Subject: Re: unload db2 table to flat files > > >IBM's new unload utility should also work for [...] 26179 134 34_Re: unload db2 table to flat files14_Maxfield, John21_John_Maxfield@BMC.COM31_Fri, 18 Feb 2000 09:30:49 -0600390_iso-8859-1 Which one do you consider to be cheaper and reliable? Is the one you consider cheaper cheap in terms of the cost to purchase the product or cheap in terms of resource consumption?

-----Original Message----- From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] Sent: Friday, February 18, 2000 9:07 AM To: DB2-L@RYCI.COM Subject: Re: unload db2 table to flat files [...] 26314 51 24_Re: Opinons and comments30_Szeszycki, Matthew (WTC/Lisle)22_mszeszycki@WALLACE.COM31_Fri, 18 Feb 2000 09:36:07 -0600561_iso-8859-1 We are running Financials 7, Ptools 7.04 on DB2 v5/OS390 . We are looking to install HR 7.57 and the upgarde of ptools and Financials to 7.57 in the coming year. Our MF is a RD6 Quad processor with 415 mips. Along with our other DB2 apps. and future conversions of IMS applications to DB2, we needed to upgrad from 9672 R45 CMOS 200 MIPs. We found we were maxing out in prod during the day. We have roughly 150 concurrent psoft users and felt that for scalability, security and stability, the mainframe provides, this was platform of choice for [...] 26366 161 34_Re: unload db2 table to flat files20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 18 Feb 2000 10:41:49 -0500611_iso-8859-1 I agree with you to a greater extent that this is not just as simple as just the one time cost of product.



> -----Original Message----- > From: Maxfield, John [SMTP:John_Maxfield@BMC.COM] > Sent: Friday, February 18, 2000 10:31 AM > To: DB2-L@RYCI.COM > Subject: Re: unload db2 table to flat files > > Which one do you consider to be cheaper and reliable? Is the one you > consider cheaper cheap in terms of the cost to purchase the product or > cheap > in terms of resource consumption? > > -----Original Message----- > From: Pillay, Venkat (PCA) [mailto:venkat_pillay@ML.COM] > [...] 26528 14 57_Re: DB2-L Digest - 17 Feb 2000 - Special issue (#2000-51)14_Jennifer Libby23_jennifer@ICIAMERICA.COM31_Fri, 18 Feb 2000 10:39:32 -0500289_US-ASCII Please take me off of your e:mail list

================================================ 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. 26543 125 34_Re: unload db2 table to flat files14_Maxfield, John21_John_Maxfield@BMC.COM31_Fri, 18 Feb 2000 09:43:44 -0600402_iso-8859-1 "Outageless" means that to capture a consistent, point in time image, access to the object is not restricted to read-only or no access. The object is available for processing while the utility executes.

-----Original Message----- From: rick creech [mailto:ykcirc@HOTMAIL.COM] Sent: Friday, February 18, 2000 9:29 AM To: DB2-L@RYCI.COM Subject: Re: unload db2 table to flat files [...] 26669 129 22_Re: QSP Universal OLAS13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Fri, 18 Feb 2000 15:46:50 +0000334_us-ascii Greg,

We tried changing the free space parameters to space things out a bit, but that wasn't successful. Eventually we partitioned some of the tablespaces (if I remember correctly into about 12 partitions). I've just checked what the current state of play is, after we installed a new release about 6 months ago. [...] 26799 54 25_Re: Opinions and comments24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Fri, 18 Feb 2000 10:52:04 -0500644_- Mary Ann

We run P/S financials and P/S HR in separate subsystems. On our first implementation, they were in the same subsystem. Some problems arose (I can't remember the details), but these problems may have been resolvable technically if we had pursued that course. Instead, we separated the applications by subsystems. Our HR and Financial DBAs are separated departmentally and geographically, and they have developed some different styles, thus it probably has been more peaceful keeping them separate. It hasn't been a problem having them in separate subsystems although it creates some more support work at the system level. [...] 26854 159 34_Re: unload db2 table to flat files0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 18 Feb 2000 09:59:12 -0600495_us-ascii The Dilbert answer is 1, "purchase cost". Resources like DBA time and CPU are "free" because someone else (or another accound code) paid for them! !

Ok, that's kind of cynical









"Maxfield, John" on 2000/02/18 09:30:49 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Rohn Solecki/MTSCommunications/MTS) Subject: Re: unload db2 table to flat files [...] 27014 187 34_Re: unload db2 table to flat files12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 18 Feb 2000 17:58:47 +0200417_x-user-defined Hi,

It's not only one time charge. There is a yearly maintenance payment as well for those products which can go up faster then a speeding bullet... We once had a product (no names will be given) that was bought due to 40% reduction of purchase price. Comes next year and the bill of 15% of the FULL PRICE came in. It was the minute it was thrown out. As the old saying goes: Caveat Emptor [...] 27202 132 34_Re: unload db2 table to flat files12_Isaac Yassin23_yassin@NETVISION.NET.IL31_Fri, 18 Feb 2000 18:01:11 +0200609_x-user-defined Hi,

Comes from OUTAGE + LESS -> means there is no need to force an outage of the resource (table data) while working on it.

Isaac Yassin



rick creech wrote: > > John, > What does "outageless' mean? > Regards, > Rick Creech > > >From: "Maxfield, John" > >Reply-To: DB2 Data Base Discussion List > >To: DB2-L@RYCI.COM > >Subject: Re: unload db2 table to flat files > >Date: Thu, 17 Feb 2000 17:23:28 -0600 > > > >Arun, > > > >To reemphasize, IBM's new unload utility and the REORG UNLOAD EXTERNAL > >option do not provide [...] 27335 49 36_CA Acquires Itself In Freak Accident9_Ray Potts23_rpotts@MAIL.STATE.MO.US31_Fri, 18 Feb 2000 10:06:36 -060053_us-ascii

CA Acquires Itself In Freak Accident 27385 183 24_Re: Opinons and comments17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Fri, 18 Feb 2000 17:06:24 +0100572_us-ascii >Good morning All, > >We are planning to purchase the Human Resources module of Peoplesoft and >we are undecided whether to install it on an NT Server or on DB2 on >the mainframe. > >We are on version 5.1 of DB2 , OS390 with 119 mips and 2 processors. >We currently have test, user and production databases >running in one subsystem. We also have NT Servers and some >Oracle databases. > >I have heard if you run peoplesoft with DB2 on the >mainframe, Peoplesoft should run in its own subsystem. > >Any comments or suggestions from anyone who has experience [...] 27569 73 22_Re: RACF/DB2 Interface17_Alessandro Brezzi28_brezzi.isac@INTERBUSINESS.IT31_Fri, 18 Feb 2000 17:25:39 +0100565_us-ascii Hi, we did also, and it work ... only a minor complaint: when accessing DB2 from external database machine (DB2 V5 VM), using the userid translation of CDB, we find a problem: it seem we have to define the real-external name to RACF as a generic user; i.e. my UId under VM is BREZZI, and under OS390 is ISACA01, so I insert a row to trasnlate incoming BREZZI request to the internal ISACA01 userid, to gain the right privilege. The first connection RACF stated to the master console "BREZZI as no privilege". I defined an empty userid BREZZI, and all [...] 27643 24 42_UPPER or UCASE functions in DB2 6.1 on VSE10_Jiang Tong30_jiang@INTREPID.CDG-HARGRAY.COM31_Fri, 18 Feb 2000 10:06:31 -0600316_us-ascii Greetings all! Pardom me if this is a newbie question.

Is there a function in DB2 6.1 for VSE that is equivalent to UPPER or UCASE in DB2 for OS390? I checked the documentations and couldn't locate one.

Our platform - VSE 2.3.0, DB2 6.1, going to 6.2 beta soon.

Thanks in advance. [...] 27668 169 34_Re: unload db2 table to flat files11_rick creech18_ykcirc@HOTMAIL.COM29_Fri, 18 Feb 2000 08:24:04 PST635_- John and Isaac, Thanks for the explanations. No wonder I could not figure it out. I was pronouncing it OUT-AGELESS. Hey, I was thinking that that sounds important and really hightech...an ageless unload. grin... Regards, Rick Creech



>From: Isaac Yassin >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: unload db2 table to flat files >Date: Fri, 18 Feb 2000 18:01:11 +0200 > >Hi, > >Comes from OUTAGE + LESS -> means there is no need to force an outage of >the >resource (table data) while working on it. > >Isaac Yassin > > >rick creech wrote: [...] 27838 15 21_Re: SQL/PL in DB2 v5?13_Sawyer, Gregg20_Gregg_Sawyer@CSX.COM31_Fri, 18 Feb 2000 11:26:30 -0500397_iso-8859-1 Thanks to lightsey, Manas, Brendan and Roger for their responses. I can now add "DB2 Stored Procedure expertise" to my CV (resume).

Gregg

================================================ 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. 27854 37 40_Re: CA Acquires Itself In Freak Accident22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 18 Feb 2000 11:34:26 -0500616_- Hilarious. Great laugh to start the holiday weekend!



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

> ---------- > From: Ray Potts[SMTP:rpotts@MAIL.STATE.MO.US] > Sent: Friday, February 18, 2000 11:06 AM > To: DB2-L@RYCI.COM > Subject: [DB2-L] CA Acquires Itself In Freak Accident > > > CA Acquires Itself In Freak Accident > -- > Ray Potts > State of Missouri > Department of Social Services > Computer Information Technical Specialist II > E-mail: rpotts@mail.state.mo.us > > IBM Certified Solutions Expert > DB2 UDB V5 Database Administration > > [...] 27892 70 24_Re: Opinons and comments24_Gendron, Dave (Exchange)28_Dave.Gendron@COASTALCORP.COM31_Fri, 18 Feb 2000 11:38:57 -0500587_- In reference to the peoplesoft listserver, the latest info I have received (12/20) is:

...This list server is still operating at the same address, PSDB2OS390@platinum.com. However, it will soon be moving off the platinum site and onto a yet-to-be-determined area of cai.com. For the time being, to subscribe, please send an email to majordomo@platinum.com and type "Subscribe PSDB2OS390" in the text of the email (you can leave the Subject line blank). When the location of the list server moves, you will be notified of it's new location and subscription information..... [...] 27963 39 17_sql problem in V611_Kenneth Lam14_klam@BTMNA.COM31_Fri, 18 Feb 2000 11:41:21 -0500736_us-ascii We have trouble with the result set from left out join. It seems that that we can not get the result we wanted? Does anyone have this problem? We ever apply some PTF when we talked to IBM but we still have trouble. Can anyone help us to resolve this SQL. Here is the following query. SELECT T4.CD_VALU_TYP, T4.ID_INSTRU, CHAR(T4.DT_AS_OF,ISO) AS DT_AS_OF, T4.CD_VALU_CCY, T1.ID_CUST, T1.CD_RL_TYP, T4.ID_COA, T4.ID_GL, T4.AM_VALU, T4.TMS_INSRT, T4.TMS_LST_CHNG, T4.ID_LST_CHNG_USR, T2.ID_SUBDIV, T2.ID_ORG, T3.ID_ORG, T3.ID_SUBDIV FROM DB2ADM.TODS_FINV T4 LEFT OUTER JOIN DB2ADM.TODS_FINI T3 ON T4.ID_INSTRU = T3.ID_INSTRU AND T4.DT_INSTRU = T3.DT_INSTRU LEFT OUTER JOIN DB2ADM.TODS_CUIR T1 ON T4.ID_INSTRU = T1.ID_INSTRU [...] 28003 42 46_Re: UPPER or UCASE functions in DB2 6.1 on VSE23_Mulkey, DW David (7091)21_MulkeyDW@GVL.ESYS.COM31_Fri, 18 Feb 2000 10:43:43 -0600588_- See if you have a TRANSLATE function. I have used this in DB2 for VM to translate the contents of a field to uppercase: SELECT TRANSLATE(employee_name) ....

David Mulkey

> ---------- > From: Jiang Tong[SMTP:jiang@INTREPID.CDG-HARGRAY.COM] > Sent: Friday, February 18, 2000 10:06 AM > To: DB2-L@RYCI.COM > Subject: UPPER or UCASE functions in DB2 6.1 on VSE > > Greetings all! Pardom me if this is a newbie question. > > Is there a function in DB2 6.1 for VSE that is equivalent > to UPPER or UCASE in DB2 for OS390? I checked the > documentations and couldn't locate [...] 28046 130 24_Re: Opinons and comments22_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Fri, 18 Feb 2000 11:50:02 -0500717_iso-8859-1 To subscribe to psdb2os390 send an email message to mailto:LISTSERV@LISTSERV.CA-NETHAVEN.COM with the text "subscribe psdb2os390"

The last message I received about the psdb2os390 list is

---------- From: Thomas, Janis[SMTP:JANIS.THOMAS@cai.com] Sent: Friday, January 14, 2000 9:55 AM To: psdb2os390@platinum.com Subject: PSDB2OS390: ***Important message from the list owner

The PSDB2OS390 email list is moving today to a different server and different listserv software will be used. I will move all current subscribers to the new list today. If, for some reason, you do not wish to move to the new list, please contact me directly at janis.thomas@cai.com, and I will remove you. [...] 28177 54 21_Re: sql problem in V69_Birk, Tim17_BirkT@DIEBOLD.COM31_Fri, 18 Feb 2000 11:59:56 -0500618_iso-8859-1 Ken,

You didn't say what it was that you're not getting. I noticed your last clause AND T2.DT_CUST = T2.DT_CUST. Did you intend to have T2 on both sides?



-----Original Message----- From: Kenneth Lam [mailto:klam@BTMNA.COM] Sent: Friday, February 18, 2000 11:41 AM To: DB2-L@RYCI.COM Subject: sql problem in V6



We have trouble with the result set from left out join. It seems that that we can not get the result we wanted? Does anyone have this problem? We ever apply some PTF when we talked to IBM but we still have trouble. Can anyone help us to resolve this SQL. [...] 28232 110 24_Re: Opinons and comments13_Thomas, Janis19_Janis.Thomas@CA.COM31_Fri, 18 Feb 2000 12:07:53 -0500467_iso-8859-1 Here is how to subscribe to the PeopleSoft (DB2 for OS/390) listserv, now hosted at CA (formally hosted on a Platinum server):

Address an email to: LISTSERV@LISTSERV.CA-NETHAVEN.COM

Include the following command as the text of the email (blank subject): subscribe psdb2os390

If you are interested in subscribing to the SAP (DB2 for OS/390) listserv, send the following command to the above listserv address: subscribe sapdb2os390 [...] 28343 40 21_Re: sql problem in V611_Kenneth Lam14_klam@BTMNA.COM31_Fri, 18 Feb 2000 12:20:34 -0500733_us-ascii Hi Tim, Sorry it should be T1.DT_CUST = T2.ID_CUST.

Here is the some result from the query . The ID_SUBDIV , T2.ID_ORG, T3.ID_ORG and ID_SUBDIV don't have any value. These columns should have data instead nulls.

ID_LST_CHNG_USR ID_SUBDIV ID_ORG ID_ORG ID_SUBDIV -------+--------- +---------+---------+---------+---------+---- MMDLPP4 500056 3110 3110 500056 MMDLPP1 500056 3110 3110 500056 MMDLPP7 500056 3110 3110 500056 MMDLPP6 500056 3110 3110 500056 500056 3110 3110 500056 MMDLPP3 500056 3110 3110 500056 MMDLPP5 500056 3110 3110 500056 MMDLPP2 500056 3110 3110 500056 MMDLPP0 500056 3110 3110 500056 MMDLPP9 500056 3110 3110 500056 MMDLPP4 --------- ------ ------ --------- MMDLPP1 --------- ------ [...] 28384 54 53_Rebuilding Large Partitioned TS w/One Secondary Index0_19_Mark_Lang@AMWAY.COM31_Fri, 18 Feb 2000 12:11:59 -0500561_us-ascii I need some advice and counsel on a procedure we just went through and I'd like to know if there are better ways to accomplish it.

We needed to change some of the column lengths in a partitioned tablespace with one secondary index. Configuration as follows:

75 partitions with 52 actually populated. average of 7.8 million rows/partition ...........total of 458.6 million rows. High order column in partitioning index and the secondary index is the partiton number (01, 02, etc) Secondary is unique and is defined with PIECESIZE 1GB [...] 28439 19 65_CAF Considerations - DB2 V5 and V6 Coexistance ,n-way datasharing13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Fri, 18 Feb 2000 10:39:08 -0700467_- Can anyone point out how they handle CAF(Call Attach Facility) when attempting n+1 (V5, V6 coexistance) in a data sharing environment? We want the ability to float batch in the plex. Dan Brogdon DB2 Systems American Express

================================================ 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. 28459 80 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index15_Murley, Michael22_Michael_Murley@BMC.COM31_Fri, 18 Feb 2000 12:10:21 -0600384_iso-8859-1 Mark,

If you use BMC RECOVER PLUS for DB2*, you can unload the keys for the secondary index from each partition in parallel jobs, sorting them as they are unloaded. The sorted keys are written to a data set. Then a subsequent BUILDINDEX job can merge the unloaded keys to build the secondary index. This can result in a really dramatic savings in elapsed time. [...] 28540 104 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index0_19_Tim.Lowe@STPAUL.COM31_Fri, 18 Feb 2000 12:32:29 -0600357_us-ascii Mark, In step #5, why did you rebuild the secondary index "one job at a time recovering 4 logical partitions/job...to recover the partitons in sequence"? Why not rebuild the entire secondary index at once, in one scan of the database?

And, are you looking for a procedure with DB2 V5, or can you use DB2 V6 with parallel index rebuild? [...] 28645 114 42_DB2 Connect Bind Utilities Authority error16_Galluzzo, Lori A21_lori.galluzzo@EDS.COM31_Fri, 18 Feb 2000 13:38:03 -0500382_iso-8859-1 Hi List Members, I am installing DB2 Connect to access MVS DB2 V5 region and have encountered a problem. I did review the DB2 List Serve archives & have not found a similar issue. I hope someone can help shed some light on it. I am able to 'add the database' and test out the connection fine; but when I go to bind the DB2 utilities I hit bind authorization errors. [...] 28760 12 11_Re: Signoff0_39_jayashree.sampathkumar@BELLATLANTIC.COM31_Fri, 18 Feb 2000 13:43:38 -0500266_us-ascii sign off DB2-L.

================================================ 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. 28773 137 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index0_19_Mark_Lang@AMWAY.COM31_Fri, 18 Feb 2000 13:46:36 -0500563_us-ascii Tim:

We are at V5 at present........

regarding the 'all at once' method.......I was concerned about extracting & sorting all that data in one piece.....resources used, time required, etc......









Tim.Lowe@STPAUL.COM@RYCI.COM> on 02/18/2000 01:32:29 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: Rebuilding Large Partitioned TS w/One Secondary Index [...] 28911 171 47_Re: Replace Into option for Simple Tablespace !15_Toine Michielse18_vndobtm@US.IBM.COM31_Fri, 18 Feb 2000 11:20:19 +0000485_us-ascii Hello,

Colin, thanks for jumping in and providing the URL. I checkes. It's out there undert the tile 'a safer DB2 load utility' I noticed only the code it out there. If you;re interested I should be able to digup the whole article.

If so, contact me offline......

Regards,



Toine Michielse DB2 S/390 Advocate Santa Teresa Laboratory Mobile: +31 6 537 23 256 Email: vndobtm@us.ibm.com Lotus: Toine Michielse/Santa Teresa/Contr/IBM@IBMUS [...] 29083 396 24_Re: Opinons and comments16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Fri, 18 Feb 2000 14:36:01 -0500640_iso-8859-1 I tried to send the "subscribe" message for psdb2os390 and it came back saying it was not found. can you help me please? Being a little uneducated here, what is the difference in this list and th sapdb2os390 list?

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Thomas, Janis [SMTP:Janis.Thomas@CA.COM] > Sent: Friday, February 18, 2000 12:08 PM > To: DB2-L@RYCI.COM > Subject: Re: Opinons and comments > > Here is how to subscribe to the PeopleSoft (DB2 for OS/390) listserv, now > hosted at CA (formally hosted on a Platinum server): > > Address [...] 29480 144 24_Re: Opinons and comments11_Craig Otway16_otwayc@TENET.EDU31_Fri, 18 Feb 2000 13:56:20 -0600462_iso-8859-1 Ask PeopleSoft to let you vist a site that has their software running on 390. ----- Original Message ----- From: Mary Ann Pickett Newsgroups: bit.listserv.db2-l To: DB2-L@RYCI.COM Sent: Friday, February 18, 2000 8:56 AM Subject: Opinons and comments



Good morning All,

We are planning to purchase the Human Resources module of Peoplesoft and we are undecided whether to install it on an NT Server or on DB2 on the mainframe. [...] 29625 197 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index0_19_Tim.Lowe@STPAUL.COM31_Fri, 18 Feb 2000 14:19:32 -0600542_us-ascii Mark, By rebuilding a new secondary index by logical partition in parallel jobs, I would think that you would be doing redundant scans of the tablespace, and then each job would contend with the other jobs for each page as you updated the index to build it. And, once you are done, the index may be in such bad shape that it would need to be reorged. The resources and time required to do this in 1 job would be substantially less since you would only scan the tablespace once, and then the data would be sorted into the proper [...] 29823 72 24_Re: Opinons and comments13_Vaughan, Mike26_Vaughan.Mike@PRINCIPAL.COM31_Fri, 18 Feb 2000 14:27:17 -0600561_iso-8859-1 We currently have Peoplesoft HRMS running on DB2 V5 in the same DB2 as the rest of our production applications. I know we are probably in the minority on this one since the trend seems to be to not let Peoplesoft play in the same sandbox as rest your applications, but it definitely can be done. Personally, I would encourage you to look at what you hope to gain by putting the application in an isolated subsystem, and also look at the long-term costs of isolating that data. In my opinion, you can resolve alot of future data-access issues by [...] 29896 40 70_Re: CAF Considerations - DB2 V5 and V6 Coexistance ,n-way datasha ring20_Pillay, Venkat (PCA)20_venkat_pillay@ML.COM31_Fri, 18 Feb 2000 15:54:16 -0500624_us-ascii Dan

I am not sure I understood your question correctly. The CAF supports GROUP ATTACH. Mentioning group name is sufficient during CONNECT and your batch job can run anywhere.

> -----Original Message----- > From: Dan S Brogdon [SMTP:Dan.S.Brogdon@AEXP.COM] > Sent: Friday, February 18, 2000 12:39 PM > To: DB2-L@RYCI.COM > Subject: CAF Considerations - DB2 V5 and V6 Coexistance ,n-way > datasharing > > Can anyone point out how they handle CAF(Call Attach Facility) when > attempting > n+1 (V5, V6 coexistance) in a data sharing environment? We want the > ability to > float > batch in the plex. [...] 29937 30 67_UDB - errors when running scripts from the script center or journal0_23_john.lantz@ZURICHUS.COM31_Fri, 18 Feb 2000 15:53:09 -0500553_us-ascii I'm running UDB v5.2 (fixpack 12) on NT. I have several scripts set up in the script center and want to run them. Whenever I try to run them, I see the following error when looking at the journal:

"DBA2078E An unexpected error occurred. There is no job output."

And interestingly enough, if I create a script that is a type of "OS Command" that is nothing more than just a dos command, those work fine. It's just the ones that are "DB2 Command" that don't work. I've seen this same type of error if the script file is empty, [...] 29968 84 38_Re: Why use primary keys in Version 5?14_Ulf-Otto Cihak23_UlfCihak@COMPUSERVE.COM31_Fri, 18 Feb 2000 16:06:28 -0500521_ISO-8859-1 As far as I know, there is also a semantic difference between a primary key, and a unique key (protected by an unique index): every key field in a primary key cannot be null, whereas a unique key allows one null per key field. Ulf Cihak Nuernberg, Germany

Nachricht geschrieben von DB2 Data Base Discussion List >Hello Craig. >So, if defining RI (PRIMARY KEYs) in DB2 reduces the chances for DATA >INTEGRITY ERRORS and does NOT cost a significant loss of performance, why is >it NOT being used???? [...] 30053 250 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index0_19_Mark_Lang@AMWAY.COM31_Fri, 18 Feb 2000 16:16:32 -0500462_us-ascii Tim:

I agree, the idea of running parrallel jobs to rebuild the s/ix would really mess it up. I didn't do this....I ran the jobs serially each run recovering four partitions. I don't think each run of the RECOVER INDEX utility would scan the ENTIRE tablespace as it was setup to recover only 4 of the partitions.....it would scan only the partitions being recovered. The UNLOAD and SORT phases ran quite fast, the BUILD phase took the time. [...] 30304 96 38_Re: Why use primary keys in Version 5?10_Mike Wiles14_mwiles@UCG.COM31_Fri, 18 Feb 2000 16:19:17 -0500433_iso-8859-1 Another reason for primary keys: This may not be the case any more, but I've had many problems accessing _any_ RDBMS's data with ODBC when there was no primary key set. Personally, I've seen Delphi, MS Access, and VFP return #ERROR for field values, and a table that contained only 10 rows on the server, mystically became 16,000+ rows on the client side. Once the primary keys were made, all the problems went away. [...] 30401 22 15_Re: Spufi query9_Luis Sosa19_lsosa@TRIGER.COM.MX31_Fri, 18 Feb 2000 15:35:50 -0600620_- This query will return only the customers with more than one account, but maybe yuo can improve it.

SELECT customer_number, ACCT_NUM, BUS_unit FROM D2DMA.customer_table WHERE customer_number IN (SELECT customer_number, ACCT_NUM, COUNT(*) FROM D2DMA.customer_table GROUP BY customer_number, ACCT_NUM HAVING COUNT(*) > 1) ORDER BY customer_number, ACCT_NUM

Regards

================================================ 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. 30424 26 69_Re: CAF Considerations - DB2 V5 and V6 Coexistance ,n-way datasharing13_Dan S Brogdon22_Dan.S.Brogdon@AEXP.COM31_Fri, 18 Feb 2000 14:54:24 -0700446_- Thanks for the reply Venkat, As usual I end up answering my own questions. In the V6 Sharing and Planning Guide the following reads:

While you are in a coexistence environment, you can attach to either release of DB2 with your existing TSO logon procedures or JCL. After you migrate all members of the group to the latest level of DB2, be sure to update those procedures and jobs to point to the latest level of DB2 load libraries. [...] 30451 167 24_Re: Opinons and comments0_28_Roy_Bertossi@ABERCROMBIE.COM31_Fri, 18 Feb 2000 17:45:15 -0500436_us-ascii I can't comment on having a DB2 subsystem supporting PeopleSoft and other applications since PeopleSoft is our only DB2 app right now. I will say that if you have other apps running on the machine and you will allow the users to use nVision, with just a two engine machine you could have some problems. Until we implemented WLM and added a third engine, we had several occasions were nVision took over the entire machine. [...] 30619 21 38_DSNUTILS must run in WLM address space28_Dan Courter (1-408-463-3870)27_daniel_courter@VNET.IBM.COM29_Fri, 18 Feb 2000 16:00:19 PST355_- DSNUTILS must run in a WLM-established address space. The OS/390 recovery service (RRS) is required for stored procedures that run in a WLM-established address space. The Redbook SG24-4693-01, Getting Started with DB2 Stored Procedures, 3.14 outlines how to implement RRS.

Information about CC 390 installation can be found at this address: [...] 30641 27 14_DB2 I/O issues16_Staci Stephenson28_staci_stephenson@ACS-INC.COM31_Fri, 18 Feb 2000 18:13:38 -0600586_US-ASCII Currently our shop supports several DB2 subsystems (for OS/390). We have one customer in particular that is far larger than the rest. This DB2 (V4.1) uses approximately 250 3390 DASD volumes, connects to 6 CICS's and a DB2 on a RS6000 via DDF, and has over 200 million SQL calls per day. Recently this customer had a 20% increase in volume, and now has several online and batch response time issues that (so far) appear to be largely due to I/O contention. We're researching this using Insight for DB2 and have been working with bufferpool and volume isolation. If anyone [...] 30669 35 17_Trapping SQL Text0_14_DPetro@AOL.COM29_Fri, 18 Feb 2000 20:22:46 EST542_US-ASCII Hi,

Our data warehouse group has a need to trap dynamic SQL statements and other various pieces of information and we're trying to determine the best alternative. If at all possible, we don't want to turn on expensive traces to capture the SQL to SMF. We have Apptune, Omegamon, DB2PM. Our collector is currently configured for Omegamon and as we understand, only one product at a time can use a collector so it's not available to Apptune. The front-end to the warehouse is Business Objects using DB2 Connect. Questions: [...] 30705 10 26_Re: DB2 UDB Communications15_Lynette Roberts21_llroberts@KSCABLE.COM31_Fri, 18 Feb 2000 19:25:24 -0600284_- The Control Center does not run on Unix.

================================================ 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. 30716 66 18_Re: DB2 I/O issues14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Sat, 19 Feb 2000 10:16:46 -0500583_ISO-8859-1 Staci, You have already homed in on your problem - poor buffer pool performance, and dataset placement. While the number of SQL statements may be large, it is not really relevant to the problem.... the 209% increase just made a problem that was already there much worse. The proper grouping of objects into pools based on access characteristics and working set size will alleviate the I/O workload. You also need to look at the components of your I/O time, where IOSQ is a dataset placement issue, and high DISC times are the actual data access when you have a cache [...] 30783 59 3_sql12_Reid, Louise25_ReidL@CI.FORT-WORTH.TX.US31_Sat, 19 Feb 2000 11:15:07 -0600284_iso-8859-1 I hope someone can help. I need to be able to create a query that will provide a result set in a long string instead of the way you would normally expect a result set. I am told this is the way the statistical package requires the results in order to import the data. [...] 30843 110 15_Re: Spufi query16_Peter G Backlund15_pbacklu@IBM.NET31_Sat, 19 Feb 2000 21:26:43 +0100444_us-ascii Andrea,

why are you using "distinct"

1/ It is unnecessary

2/ It forces DB2 to do an extra sort

Peter



"Milligan, Andrea" wrote:

> > > Try this > > SELECT distinct customer_number, ACCT_NUM, BUS_unit, count(*) > FROM D2DMA.customer_table > group by customer_number, ACCT_NUM, BUS_unit > having count(*) > 1 > > Andrea Milligan > DataBase Administrator > BlueCross BlueShield of Tennessee 30954 151 45_I can EXPLAIN... or the Optimizer knows best!16_Peter G Backlund15_pbacklu@IBM.NET31_Sat, 19 Feb 2000 21:28:15 +0100497_us-ascii About a week ago I sent a question to the DB2-L; I was confused over what seemed to be a performance degradation using COALESCE in a COL=(SELECT MAX(COL) construct.

Without the COALESCE my EXPLAIN looked like this,

+-------------------------------------------- ! QB PL MT TABLE ! AC COL INDEX ! IX ! CF ! +-------------------------------------------- 1_! 1 1 0 TCPV ! I 1 ICPV2 ! Y ! ! 2_! 2 1 0 TCPV ! I 1 ICPV2 ! Y ! R ! +-------------------------------------------- [...] 31106 30 7_Re: sql11_trav leippi16_trav@INORBIT.COM31_Sat, 19 Feb 2000 16:11:15 -0600415_us-ascii At 11:15 AM 02/19/2000 -0600, you wrote:

>Select Distinct A.PROJNO, A.PROJNAME, B.ACTNO, C.EMPNO, D.FIRSTNME, >D.MIDINIT, > D.LASTNAME, D.WORKDEPT, D.SALARY, D.BONUS >>From DSN8410.PROJ A, DSN8410.PROJACT B, DSN8410.EMPPROJACT C, DSN8410.EMP D >Where ((A.PROJNO = 'AD3111')) > And (A.PROJNO = B.PROJNO) > And (B.PROJNO = C.PROJNO) > And (C.EMPNO = D.EMPNO) >Order By 1 Asc, 2 Asc, 3 Asc, 4 Asc [...] 31137 74 29_Re: UDB Log space calculation10_Bob Harbus18_rharbus@CA.IBM.COM31_Sat, 19 Feb 2000 18:39:56 -0600490_- On Tue, 15 Feb 2000 15:41:16 -0500, Paul Mayhew wrote:

>Does anyone out there have a good calculation for estimating log >requirements?



Hello Paul: Not sure if you are referring to the OS/390 or UNIX, Windows and OS/2 platforms, but for what it is worth, this is the information I have on log space calculations on the latter platforms. I obtained this from the data protection team in the Toronto lab who deal with this piece of the product: [...] 31212 142 46_Re: DB2 Connect Bind Utilities Authority error12_Troy Coleman29_troycci@COLEMANCONSULTING.COM31_Sat, 19 Feb 2000 20:18:45 -0600607_iso-8859-1 One way is to give yourself SYSADM. The other is to give yourself PACKADM on COLLECTION NULLID.

Troy Coleman IBM Certified Solutions Expert DB2 UDB V5 Database Administration Coleman Consulting, Inc. 907 W. Dorset Ave. Palatine, IL 60067 V: 847-705-1468 F: 847-705-1468 mailto:troycci@colemanconsulting.com http://www.colemanconsulting.com/~troycci

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Galluzzo, Lori A Sent: Friday, February 18, 2000 12:38 PM To: DB2-L@RYCI.COM Subject: DB2 Connect Bind Utilities Authority error [...] 31355 27 57_Please help with Master's thesis by taking a short survey15_Kevin Daugherty23_steelerkev@PAONLINE.COM31_Sat, 19 Feb 2000 23:10:11 -0500636_iso-8859-1 Dear IS professional. In partial fulfillment of the requirements of the Master of Science in Information Systems (MSIS) program at Pennsylvania State University, I am writing a thesis entitled “Assessing Issues Related to the Development of an Effective Data Warehouse System in Organizations”. The purpose of the document is to explore how companies design effective data warehouses. If you have some knowledge of databases (not just data warehouses) and would be willing to take a short (29 question) survey, please send me a response to this message and I'll forward you a little more detail about the thesis and the [...] 31383 63 21_Re: sql problem in V617_Linda F. Claussen18_lindafc@NETINS.NET31_Sun, 20 Feb 2000 09:27:57 -0600310_ISO-8859-1 Ken,

Are you absolutely sure there is a match between T4 AND T1? If that match is not found you will not find the data for T2 and the T2.ID_SUBDIV and T2.ID_ORG will show as null? The same is true with the T4 AND T3 match.

Try the individual join and make sure the matches exist. [...] 31447 141 57_Repost: New Redbooks: VLDB for OS/390 and DB2 Performance13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 12:52:40 -0700580_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below are some recent IBM International Technical Support Organization (ITSO) Redbooks/Redpaper relating to the DB2 environment that may be of interest to you. [...] 31589 92 61_Repost: ITSO Redbook Residencies found with search string db213_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 12:52:40 -0700648_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Below are recent projectd residency announcements from the IBM International Technical Support Organization (ITSO...the "Redbook" writers). I thought some of you might be interested. (The date listed is the start date of the residency.) [...] 31682 92 30_Repost: Tsuki Dashi BackOffice13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 12:52:39 -0700604_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



Dear DB2 Interested Parties,

Some of you may be interested in a recent consultant report entitled, "Tsuki Dashi BackOffice" by industry analyst group, Illuminata (see http://www.illuminata.com/abstracts/tsukidashi.html ). [...] 31775 82 42_Repost: DB2 XML Extender Is Now Available!13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:00:17 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:08 PM --------------------------- [...] 31858 193 68_Repost: ESCON Adapter for DB2 Connect (Bus-Tech Inc. Press Releas e)13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:00:17 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:08 PM --------------------------- [...] 32052 143 51_Repost: Are you ready for e-transaction processing?13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:00:18 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:07 PM --------------------------- [...] 32196 72 92_Repost: Rapidly and Efficiently Unload DB2 Databases with "IBM DB 2 High Performance Unload"13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:00:18 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:07 PM --------------------------- [...] 32269 194 51_Repost: IBM and Oracle in Marketing Battle of Words13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:00:17 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:07 PM --------------------------- [...] 32464 119 57_Repost: Free DB2 Certification Testing at IDUG Conference13_Morrill, John12_JohnM@VP.NET31_Sun, 20 Feb 2000 13:03:13 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:03 PM --------------------------- [...] 32584 27 20_bind agent authority12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Sun, 20 Feb 2000 16:25:06 -0500545_ISO-8859-1 I could use some clarification on the bind agent authority in DB2 V5. My understanding was that if a person was granted this authority that any binds they did would be done under the authority of the grantor of their bind agent authority. It doesn't appear to be working this way. I granted an analyst this authority, since he did not have access to some of the tables in the package he was binding, and yet he still gets the same -551 SQL error on the statements to those tables. What am I missing in the use of this authority? [...] 32612 45 24_Re: bind agent authority17_Linda F. Claussen18_lindafc@NETINS.NET31_Sun, 20 Feb 2000 16:43:02 -0600376_ISO-8859-1 Did you make sure that OWNER(auth-id) was the original package owners id and not the analysts id? What ever id is in the OWNER bind option must have access to the tables.

Cheers, Linda F. Claussen Claussen & Associates DB2 Consulting and Training lindafc@netins.net http://www.netins.net/showcase/lclaussen/ Phone: (319) 343-3216 Office: (319) 847-1985 [...] 32658 35 50_Differences 'tween Unix and OS/390 versions of DB212_Raymond Bell20_raymondb@NZ1.IBM.COM31_Mon, 21 Feb 2000 13:02:50 +1300530_us-ascii Dear DB2 flag-wavers,

A question for you. Can anyone tell me where I might find information on the differences between DB2 UDB V6 on a Unix platform (type unknown) and DB2 for MVS (OS/390) V5 (V6)?

I've found a really nice-sounding red book called 'Rightsizing the Database Environment: DB2 for MVS to DB2/6000' GG24-4431-00 but it was published in '95. If anyone knows of any other redbooks, white papers, case studies, web sites, etc., that have more up-to-date information I'd be very appreciative. [...] 32694 25 20_bind agent authority12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Sun, 20 Feb 2000 21:24:54 -0500420_ISO-8859-1 Hi Linda,

If I understand your comments correctly, Bind Agent authority uses the access authority of the OWNER/AUTHID of the package to do the bind. If this is true then I understand why it is not working. I thought it was the authority of the AUTHID that granted the bind agent privledge that was used. Thank you for clearing this up. I guess I will have to find another solution to the problem. [...] 32720 46 24_Re: bind agent authority17_Linda F. Claussen18_lindafc@NETINS.NET31_Sun, 20 Feb 2000 20:48:44 -0600459_ISO-8859-1 Dennis,

There may still be a misunderstanding. Syntax of BIND:

BIND PACKAGE (collection-id) OWNER(auth-id) -- must have table access authority QUALIFIER(qulaifier-name) -- table qualifier MEMBER(dbrm-member-name)

As long as the OWNER in the bind syntax has table access then BINDAGENT should work. The auth-id of the BINDAGENT who is performing the BIND does not have to be the same as the auth-id in the OWNER parameter. [...] 32767 19 41_Contents of COBOL host variable when NULL0_14_whomer@CSC.COM31_Mon, 21 Feb 2000 15:40:07 +1000423_us-ascii We are on DB2 V4.

Could anyone tell me what the contents a COBOL (COBOL 2.1 for MVS LE1.5) host variable would be when it is NULL.

Many thanks.

Warren.

================================================ 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. 32787 29 13_error message11_Ellen Chiem21_ellen@NETTRACK.COM.AU31_Sun, 20 Feb 2000 23:43:01 -0600769_- Hi All,

Can anyone out there tell me what these error mean? The system administrator keep getting this in his syslog and is getting abit fedup with it.

2000-02-17-12.44.05.295139 Instance:archive Node:000 PID:22942(db2sysc) Appid:none oper_system_services sqlorque Probe:9

0000 0016

2000-02-15-15.59.22.748539 Instance:archive Node:000 PID:14354(db2agent (ARCHIVE)) Appid:*LOCAL.archive.000215055913 database_utilities sqlubcka Probe:11 Database:ARCHIVE

ffff fbf5

thanks

Ellen

================================================ 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. 32817 29 45_Re: Contents of COBOL host variable when NULL13_Helen Johnson25_Helen_Johnson@RAC.RAY.COM31_Mon, 21 Feb 2000 00:16:40 -0600609_us-ascii It would be garbage (whatever was in that variable before the call). You must check the Null Indicator variable for a -1 to know if the database has a NULL value for that column.

Helen

whomer@CSC.COM wrote:

> We are on DB2 V4. > > Could anyone tell me what the contents a COBOL (COBOL 2.1 for MVS LE1.5) host > variable would be when it is NULL. > > Many thanks. > > Warren. > > ================================================ > 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 [...] 32847 30 57_Re: Rebuilding Large Partitioned TS w/One Secondary Index14_Massimo Scarpa16_mscarpa@CESVE.IT31_Mon, 21 Feb 2000 09:15:39 +0100407_us-ascii I agree with Tim Lowe. I recovered many & many times logical partitions and it's very

sllloooowww.

It's better if you re-create tablespace(s) to recover the entire index not logical partion because it's

somewhat similar to an delete-and-insert procedure like an SQL program.

We had a table with 118 million rows and every time it was modified we rebuilt the entire [...] 32878 40 39_DB2PM R610 convert Save Statistics File12_Alberto Aldi19_Alberto.Aldi@SSB.IT31_Mon, 21 Feb 2000 09:31:39 +0100320_us-ascii Good morning ALL.! I have a problem with job DGOPJSCO of DB2PM V6R1M0 . When i run it whit PARM=CONVERT i receive a system abend code 0c1 reason 01. I think that there is an error in the lrecl and blksize paramiter in the jcl DD OUTPUT. In the IBM manual DB2 PM Report Reference there is this description: [...] 32919 61 45_SV: Contents of COBOL host variable when NULL0_19_Sven.Heidorn@CSN.SE31_Mon, 21 Feb 2000 10:18:34 +0100336_ISO-8859-1 Warren & Helen,

I would check for < 0 in the indicator variable instead of -1, this is because the indicator vaiable can contain -2 if the null value comes from a numeric or character conversion error, or an arithmetic expression error. When checking for < 0 (less than zero) you would be home free in all cases. [...] 32981 30 24_Re: Opinons and comments11_John Rosser24_jhrosser@DUKE-ENERGY.COM31_Mon, 21 Feb 2000 07:48:02 -0600294_- Reasons to put PS in its own DB2 for OS390:

1. Storage contention and 2Gig limitation in DBM1 address space. Given the number of open objects used by PS & other apps, plus increases to edmpool, and a host of other control blocks in DBM1, DB2 will be at risk. No storage = No DB2. [...] 33012 127 24_Re: Opinons and comments22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 21 Feb 2000 13:24:19 +0000535_ISO-8859-1 Mary I work with SAP - similar product to Peoplesoft.

my few pence worth are ..

1. Avoid NT (at the moment depending on your workload and if you wish to have the system stay up for any period of time) 2. Oracle .. what can I say about this product that has not been said before. 3. Own DB2 susbsystem - depending on the other types of workload going through the system it may be that you decide to performance tune the PS app differently to the non-PS .. in which case you may find that one works against [...] 33140 68 24_Re: Opinons and comments13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Mon, 21 Feb 2000 09:32:45 -0500394_us-ascii To John's point (1) below: Interestingly, we've got five (yes 5!) PeopleSoft instances installed in a single DB2 subsystem (Test). These include the various Demo, test, development, and training instances. DSMAX = 8000, EDMPOOL = 7 Mb. We haven't seen any storage problems.

Of course, your mileage may vary. We only have HR installed, and we're a relatively small company. [...] 33209 205 15_Re: Spufi query16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Mon, 21 Feb 2000 10:32:16 -0500573_- Oops, thanks for catching that. I copied the query from another e-mail and forgot to take it out. No, I don't use distinct in that type of query when I run them. Sorry for the confusion.

Andrea Milligan DataBase Administrator BlueCross BlueShield of Tennessee

> -----Original Message----- > From: Peter G Backlund [SMTP:pbacklu@IBM.NET] > Sent: Saturday, February 19, 2000 3:27 PM > To: DB2-L@RYCI.COM > Subject: Re: Spufi query > > Andrea, > > why are you using "distinct" > > 1/ It is unnecessary > > 2/ It forces DB2 to do an extra sort > > Peter > [...] 33415 78 22_Re: RACF/DB2 Interface0_19_mike.holmans@BT.COM31_Mon, 21 Feb 2000 13:54:03 -0000581_- We haven't considered it seriously here. The reason being that we don't see how we could sensibly get the RACF people trained to be DBAs, and we don't think they would appreciate the extra workload it would involve anyway.

I've not heard anything to suggest that the technical interface is faulty or doesn't work as advertised, but what I don't quite see is how the idea works organisationally. Some people seem to have switched their security setups to the RACF team from the DBA team, and I'd be very interested in hearing about the good and bad things involved in [...] 33494 73 24_Re: bind agent authority0_19_mike.holmans@BT.COM31_Mon, 21 Feb 2000 14:08:50 -0000550_- To amplify a bit further, the id which has been granted BINDAGENT need not have any other ability. If the OWNER authid is a RACF group, the BINDAGENT authid does not have to be connected to that group.

What BINDAGENT means is that the grantee can, for the purposes of binding a plan or package *and for those purposes only*, masquerade as the OWNER of the plan by specifying the OWNER parm (which you might not do if you were submitting a BIND using as many defaults as possible). All the other BIND parms have to be specified (or not) [...] 33568 67 24_Re: Opinons and comments13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Mon, 21 Feb 2000 09:47:34 -0600469_iso-8859-1 Hi, We are in the progress of installing PeopleSoft HR, Payroll & Benefits on DB2 OS390 V5.1. We had to decide from SQLServer or Oracle or DB2 OS390.

We went with OS390 for the scalability and reliability of that environment. This shop has procedures for backup, recovery and have a lot of mainframe experience. We simply used in place procedures. We would have had to do a lot of training etc. to get things going for the non-OS390 environment. [...] 33636 91 35_Re: Stored Proc abend by Buffer Man11_Robert Jans21_Jans.Robert@AMSTR.COM31_Mon, 21 Feb 2000 08:57:00 -0700448_- Update on this problem.

We have discovered the cause of this . It appears this is an undocumented 'feature'. Turns out the tablespace was in copy pending. We found this when the application was ran showing the SQLCODE after each query. The application received a -904 but the Buffer Manager abended the task. BTW, all our apps and stored procs are all written with error handling routines. We are currently talking to IBM about this. [...] 33728 94 49_Re: SV: Contents of COBOL host variable when NULL0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 21 Feb 2000 10:08:25 -0600554_us-ascii



I'd like to clarify Helen's comment a little re "It would be garbage...". The key point she made is that host variable contains "(whatever was in that variable before the call)". If your call is multiple fetches on a cursor, the value may be valid in your application (not random 'garbage'), it just does not apply the current row. The apparently 'valid' value can make it very difficult to spot visually when you are debugging or reviewing output data (reports). I'm willing to bet that is why you are asking the question. [...] 33823 99 24_Re: Opinons and comments22_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 21 Feb 2000 15:50:03 +0000348_ISO-8859-1 Interesting that you only have an EDMPOOL of 7Mb .. I take it then that your Global Cache in PS is used very lightly ... or that you are happy to perform a high number of FULL Prepares(very very costly to your CPU) ... or that your Local Cache is able to store all the prepared Statements that are needed for the PS Threads ... ??? [...] 33923 66 54_Re: Differences 'tween Unix and OS/390 versions of DB214_Mullins, Craig21_Craig_Mullins@BMC.COM31_Mon, 21 Feb 2000 10:53:54 -0600633_ISO-8859-1 Raymond:

Unfortunately I do not have an impartial publication to recommend on this subject. The Unix/NT flavor of DB2 and the OS/390 flavor of DB2 are indeed different. However, from an SQL perspective, they are very close. OS/390 does not yet have recursive SQL but other than that, with V6 of each respective platform the SQL is very close. IBM used to publish a document known as FRED (Formal Register of Extensions and Differences). FRED outlined the differences between the different DB2 flavors (OS/390, VM/VSE, NT/Unix, and AS/400). This document was great for DB2 users but unfortunately could be used [...] 33990 58 54_Re: Differences 'tween Unix and OS/390 versions of DB222_Leslie Pendlebury-Bowe43_Leslie.Pendlebury-Bowe@CCMAIL.EU.SONY.CO.JP31_Mon, 21 Feb 2000 16:09:32 +0000410_ISO-8859-1 Raymond are you not able to speak with the Labs direct - seeing as you work for IBM?

I "may" know somebody who can help .. get back to you ..

Les



______________________________ Reply Separator _________________________________ Subject: Differences 'tween Unix and OS/390 versions of DB2 Author: Raymond Bell at Internet Date: 2/21/00 1:02 PM [...] 34049 28 17_Query Performance0_24_db46@DAIMLERCHRYSLER.COM31_Mon, 21 Feb 2000 12:26:54 -0500347_us-ascii Before I have the joyeous experience of digging through a IBM manual, can someone confirm what I think I heard about the use or non-use of indexes. I have the task of making this query run faster and cannot add any indexes. Here is part of the where clause:

AND DATE(A.T_STMP_PROB_RSLVD) BETWEEN '$(begdate)' AND '$(enddate)' [...] 34078 105 22_Re: RACF/DB2 Interface11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Mon, 21 Feb 2000 12:43:31 -0500587_us-ascii At 01:54 PM 2/21/00 -0000, you wrote: >We haven't considered it seriously here. The reason being that we don't see >how we could sensibly get the RACF people trained to be DBAs, and we don't >think they would appreciate the extra workload it would involve anyway. >

We are approaching this problem as a RACF delegation issue. Currently, the two DBAs have some SPECIAL privileges. This is not so scary since one of them (me) was the MVS systems programmer for 17 years, and backup RACF administrator for 10. I believe it works best when DB2 folks administer the RACF [...] 34184 124 35_Re: Left outer join not consistant?12_Dudley Moore16_dumoore@NMSU.EDU31_Mon, 21 Feb 2000 11:05:31 -0700403_us-ascii There have been a lot of PTF's for outer joins in v5. I would check IBMLINK for maintenance. We had a left outer join query, run from Crystal Reports through DB2 Connect that would slow the whole OS/390 system down. We would kill the thread before if ever finished because of this. I'm not sure which PTF's specifically, but it seems like they were at the PUT9906 or 07 maintenance level. [...] 34309 150 24_Re: Opinons and comments13_Lockwood Lyon23_Lockwood_Lyon@AMWAY.COM31_Mon, 21 Feb 2000 13:11:03 -0500297_us-ascii Good question from LP-B. (BTW, not sure what you mean re: Global and Local cache ... are these IBM terms? Got a manual page reference? I think I know what you mean.)

Anyway, I checked the EDM Pool on our "Type B" online monitor, which displays "% Efficient" numbers, and got: [...] 34460 140 22_Re: RACF/DB2 Interface0_22_Rohn.Solecki@MTS.MB.CA31_Mon, 21 Feb 2000 14:04:16 -0600615_us-ascii Joe, this sounds interesting. Let see if I understand you correctly (given your example)...

Actually, this is the best selling point of using RACF. I can make the RACF definitions both 1) before the DB2 object exists; and 2) with wild carding to handle multiple DB2 objects. For example RDEFINE MDSNTB *.DEVP.S*.SELECT UACC(NONE) DATA('Select privilege for SIS tables') PERMIT *.DEVP.S*.SELECT CLASS(MDSNTB) ID(grp1 grp2) ACCESS(READ) This gives select privilege to all existing and future tables/views qualified by 'DEVP' and beginning with the letter 'S' for groups 'grp1' and 'grp2'. [...] 34601 276 24_Re: Opinons and comments16_Milligan, Andrea25_Andrea_Milligan@BCBST.COM31_Mon, 21 Feb 2000 16:08:05 -0500604_- We have PS HR/Payroll/Benefits and Financials AP/Purch/Inv/GL. We run all of these in the same production DB2 subsystem. While there were some tuning opportunities, we haven't had to split them yet. In the test arena, we have 6 Financial instances and 5 HR instances. The biggest performance degradation there is trying to do run things like Platinum Strategy Analyses. Image Copies, Runstats, and Reorgs run fine. We have found that for the applications we use, of the 3300 HR tables, only about 600 tables have data and of the 4900 Financial tables, only about 1000 have data. We currently only [...] 34878 57 22_Re: RACF/DB2 Interface11_Joe Luthman22_jluthma@BGNET.BGSU.EDU31_Mon, 21 Feb 2000 16:30:10 -0500435_us-ascii Rohn, Yes, RACF will enable you to no longer worry about re-GRANT. And the predictive nature of the RACF definitions makes planning easier (covers future new tables and views). There are some exceptions to RACF coverage for all DB2 constructs. Most notably, commands such as DISPLAY/CANCEL THREAD still need to be controlled by internal DB2 security. See Chapter 4 in this redbook for more explicit savings for RACF/DB2. [...] 34936 21 29_DB2 Disaster Recovery Options19_Marcia D Marthaller32_Marcia.Marthaller@CENTURYTEL.COM31_Mon, 21 Feb 2000 13:38:00 -0800566_- We are a DB2 4.1 Datasharing shop. We currently IPL about every 3 months, and usually that is the only time we take DB2 down. We are preparing for the first Disaster test since our shop went parallel sysplex. I am pondering different options and have to give a somewhat intelligent sounding list of options to my Vice President later this week. Every time I look at the doc for recovering using standard IBM/DB2 utilities, I shudder and think there must be a better way. Other options we have tossed around are using SNAPSHOT or BMC Resolve. Does anyone have [...] 34958 30 22_Re: RACF/DB2 Interface11_Kurt Rompot21_RompotK@SCHNEIDER.COM31_Mon, 21 Feb 2000 15:54:26 -0600496_us-ascii The RACF/DB2 interface is not a complete port of the native DB2 security implementation. Our shop had several issues related to BIND security that the RACF/DB2 interface handled differently than native DB2 security. Off the top of my head, I believe the issues were related to the use of secondary auth ID's for binding. Also, I think the RACF/DB2 interface didn't support BINDAGENT, but I'm not sure of that one.. The end result was that we cancelled our plans for implementation. [...] 34989 61 33_Re: DB2 Disaster Recovery Options11_Ron Haupert23_rhaupert@GOLDENGATE.NET31_Mon, 21 Feb 2000 16:13:10 -0600619_iso-8859-1 The best disaster recovery plan for DB2 may be to perform a disaster "restart" rather than perform disaster recovery. Disaster restart is based on concepts of remotely mirrored data. Data is mirrored to a restart site using remote mirroring products like IBM PPRC, IBM XRC, or EMC SRDF. Some of these products allow synchronous remote mirroring such that when a local site is lost, the database and its associated applications can be restarted at the restart site. The restart procedures at the restart site are the same as when restarting from a local system power failure. These techniques can reduce [...] 35051 44 11_Db2 Connect12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Mon, 21 Feb 2000 18:38:20 -0500524_ISO-8859-1 I hope someone can shed some light on a problem I am having. I have been trying to determin what causes some VB connections through DB2 Connect to DB2 V5 OS-390 to release their threads while a second query in the same job hangs on to it. Through some testing I have determined that if the SQL returns very few rows the thread is dropped as soon as the data is returned, while an SQL that returns a large number of rows hangs on to the thread, even after all the rows have been returned. The test job uses a [...] 35096 33 23_Your opinion on explain15_Randall Barbour21_rbarbourbis@YAHOO.COM31_Mon, 21 Feb 2000 16:02:24 -0800564_us-ascii I'm curious about who requires an explain be done on all or most of an application SQL before it goes into production? Does anyone out there that allow things to go into production without anyone (dba or developer) doing an explain?

I have told people that I believe most shops require someone to do this or use some other method of determining the access path before SQL goes to production. No one believes me though. I just want to know. Our area has no requirement or standard regarding this at all. I feel as we move to more client server [...] 35130 82 21_Re: Query Performance0_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 22 Feb 2000 08:19:52 +0800346_us-ascii Dean,

You are correct - using DATE or other functions generally (may change in future releases...) prevents the use of an index. Also adds overhead for each row retrieved, as DB2 has to apply the function. Not a problem for a few hundred rows, but if you hit the thousands or millions, you will notice a big performance hit. [...] 35213 18 20_bind agent authority12_Dennis Raher27_Dennis_Raher@COMPUSERVE.COM31_Mon, 21 Feb 2000 19:37:14 -0500333_ISO-8859-1 Hi Linda,

I got it and it now works. Thanks for all the help.

Dennis

===============================================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. 35232 20 44_Re: V6 Host Variables no colons and Platinum12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 21 Feb 2000 18:53:21 -0600273_- This is just a bit trickier. If you have old (prior to V2.3) DBRMs, then they do not have the colon in them. There is an information APAR II12100 that describes this. If you call for service, we have a REXX program which looks through the catalog for the old DBRMs. [...] 35253 96 69_Repost: IDUG Solutions Journal Publishes IBM Study on DB2 for OS/ 39013_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:40 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:06 PM --------------------------- [...] 35350 139 81_Repost: "Watch Out, Oracle: IBM has Gotten its Act Together" (PC Week, 12 /20/99)13_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:40 -0700564_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================









To: DB2 Interested Parties cc: From: Michael Swift/Santa Teresa/IBM@IBMUS Subject: "Watch Out, Oracle: IBM has Gotten its Act Together" (PC Week, 12/20/99) [...] 35490 96 71_Repost: IDUG Update: 2000 North American Conference Schedule Avai lable13_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:41 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:05 PM --------------------------- [...] 35587 107 44_Repost: DB2 Certification Announcement: CATE13_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:42 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:05 PM --------------------------- [...] 35695 138 52_Repost: Recent Redbooks Relating to DB2 Environments13_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:41 -0700493_- Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:06 PM --------------------------- [...] 35834 185 65_Repost: An open letter: IBM's position on open standards and J2EE13_Morrill, John12_JohnM@VP.NET31_Mon, 21 Feb 2000 19:09:42 -0700502_iso-8859-1 Greetings!

Below is a posting from Mike Swift's DB2 Interested Parties mailing list. If you would like to join his list, you can e-mail him at dbswift@us.ibm.com. Not all posting to DB2 Interested Parties are re-posted here.

Cheers!

J. Michael Morrill Chief DB2-L List Owner

=================================================



---------------------- Forwarded by Michael Swift/Santa Teresa/IBM on 02/05/2000 02:04 PM --------------------------- [...] 36020 67 37_DB2 audit - UDB 5.2 on an NT platform0_30_Milorad_Cerovac@TAC.VIC.GOV.AU31_Tue, 22 Feb 2000 14:25:33 +1000661_iso-8859-1 Dear Listers,

We're trying to come up with some way of providing an audit trail for our clients, but we're having trouble coming up with a suitable strategy. We need to be able to report on the following sort of information:

|--------------------------------------------------------------------------| | | |Changes to production data by the Database Administrators using database | |tools are not recorded in audit logs. Such changes may include the | |following: | | | |§ Manipulation of existing data within fields | |§ Deletion of records | |§ Creation of new records | |§ Any activity performed by Database Administrators | |§ [...]