1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l August 2000, week 5 2 27 31_Re: Reorg using Shrlevel Change9_Jim Ruddy18_jaruddy@US.IBM.COM31_Tue, 29 Aug 2000 00:44:19 -0500375_- When we put together the first presentations on V6 enhancements we did not mention that we had changed part of the architecture of OLR to process the mapping table exactly as you describe. The change did not improve the availability of the data but we were thoroughly chastised by the QPP customers for not telling them of the big improvement in overall elapsed time. [...] 30 24 23_Maximum Tablespace Size7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Tue, 29 Aug 2000 01:05:17 -0500344_- Hi everyone,

UDB 6 Admin. Guide indicates that:

"The maximum size of the different types of table spaces:

- Regular table and index data: 64 GB(for 4kb pages); 128 GB(for 8 KB pages); 256 GB(for 16kb pates); 512 GB(for 32kb pages)



Does this mean that you cannot have a tablespaces larger that 512 GB? [...] 55 30 22_unable to open dsndb0114_Bilal YILDIRIM25_byildirim@HALKBANK.COM.TR31_Tue, 29 Aug 2000 10:17:22 +0300411_windows-1254 We were trying to redefine active logs and bsds,after we opened the db2, db2 said to us resourse unavailable to dsndb01, so we restore all tablespace in dsndb01 and again reopened db2 and again the same problem



DSNIDBET RESOURCE UNAVAILABLE 429 CORRELATION-ID=DDB2 CONNECTION-ID=DDB2 LUW-ID=* REASON 00C90081 TYPE 00000100 NAME DSNDB01

I am waiting for your responses!!! [...] 86 48 33_Precompiled on or before DB2 V2.27_Sanjeev21_Sanjeev@INTERRAIT.COM31_Tue, 29 Aug 2000 13:04:37 +0530543_iso-8859-1 Hi All, In DB2 UDB V6 for OS/390 Technical Update Redbooks, I have found these comments.

" BIND and REBIND on DB2 V6 can also fail for DBRMs that were created prior to DB2 Version 2 Release 3. For example, if you drop an index that is used in a package or plan, then the package or plan must be rebound, either by explicit command or automatic BIND. If the DBRM was produced on DB2 Version 2 Release 2 or earlier, then the BIND or REBIND will fail.DBRMs produced by the DB2 Version 2 Release 3 or later precompiler have [...] 135 92 26_Re: unable to open dsndb010_29_Greg.Palgrave@BANKWEST.COM.AU31_Tue, 29 Aug 2000 15:46:52 +0800456_us-ascii From the messages manual:

00C90081 Explanation: An attempt was made to allocate a resource that is stopped for all access.

You've got DSNDB01 STOPped - presumably at some stage you issued a STOP DB command - you need to issue a corresponding START command to regain access. Check the jobs you ran and/or the DB2MSTR log for any other messages that may help pinpoint whether you stopped a specific tablespace, or all of DSNDB01. [...] 228 62 15_Re: DB2 UDB DDL13_Jimmy Willett24_Jimmy.Willett@NCMAIL.NET31_Tue, 29 Aug 2000 07:12:53 -0400277_us-ascii This is not my question, but someone please tell me how to save the script in the control center using unix....on win/nt client... the system on the script center is blank and I do not know how to get the system name from the unix into the drop down box...thanks [...] 291 101 37_Re: Precompiled on or before DB2 V2.215_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Tue, 29 Aug 2000 07:56:19 -0400402_iso-8859-1 Sanjeev,

When we migrated our PL/I application to use DB2 V6 for OS/390, we did rerun all the precompile/compile/link and bind processes so that we knew what we had to deal with in order to not only get DB2 V6 up and running, but also the application to use DB2 V6. In most of the hold data from the installation, there are references that document BINDs should be done anyways. [...] 393 75 22_Re: Db2 subsystem name12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Tue, 29 Aug 2000 08:26:24 -0400426_us-ascii Here is the way that will always work. Ensure you are logged onto the correct MVS image. Brouse SYS1.PARMLIB and look for the members that start IEFSSN*. Each IPL can invoke a different one (or more than one) of these but default one is called IEFSSN00. Search for "DSN3INI" and somewhere on that line (or lines above) will be something like "SUBSYS SUBNAME(DB2T)". The thing in brackets is the DB2 system name. [...] 469 55 22_Re: Db2 subsystem name8_Kurian B23_Bejoy_Kurian@MAY-CO.COM31_Tue, 29 Aug 2000 07:52:16 -0500579_us-ascii Use DB2 command -DISPLAY GROUP you can see the current version of DB2 running. Thanks Bejoy





From: "Sinha, Ranjay Kumar (CTS)" @RYCI.COM> on 08/28/2000 11:36 PM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



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



Hi list, I am working in in a db2 environemnt. I am not aware of the subsystem name in our env. How can I find the subsystem name . [...] 525 123 22_Re: Db2 subsystem name9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Tue, 29 Aug 2000 14:04:27 +0100452_us-ascii I find the /D OPDATA (or /D O) console command a quick way for displaying sub-systems. This also shows the command prefix. Kind Regards, Andy Hunt - Scottish And Southern Energy







MARTIN WOLFF on 29/08/2000 13:26:24

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Andy Hunt/HAV/SSE) Subject: Re: Db2 subsystem name [...] 649 10 29_Any Experiences With Triggers10_Bill Brown25_bill_brown@SPRINGMAIL.COM31_Tue, 29 Aug 2000 09:41:58 -0400558_- We are currently testing v6 on OS/390. Seems like this y2k thing really slowed us down. We created a copy of one of our production tables (segmented tablespace) with three indexes. We have a program that will insert 100,000 rows into the table so we can test various things. Ran this job three times. All data was deleted prior to each run. No triggers at this point. Then created an exact copy of the table and a trigger on the original to insert a row into the second table based on insert activity. We measured approx 265% additional overhead with [...] 660 55 28_DDF won't come up - DSNL512I19_Elmer J. Valenzuela18_elmer@KFUPM.EDU.SA31_Tue, 29 Aug 2000 17:00:40 +0300322_Windows-1252 Hi, On OS/390 2.4, DB2V5.1. We stopped DDF yesterday to refresh stop TCPIP and start a modified TCPIP stack. The only change on the TCPIP profile was the addition of the definitions for the OSA-2 ATM card (DEVICE/LINK/HOME/GATEWAY statements). TCPIP started fine but DDF won't start up giving an error : [...] 716 20 38_SQL Help requested for DB2 OS/390 V5.10_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 29 Aug 2000 10:07:31 -0400452_us-ascii Hi,

We have a table T1. We'd like to identify any rows where the values are the same in COL A, COL B, COL C, and COL D. Is there a query that will produce this result?

Thank You

Ed

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 737 46 42_Re: SQL Help requested for DB2 OS/390 V5.115_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Tue, 29 Aug 2000 09:32:02 -0500261_iso-8859-1 This can get ugly if your table is large (and if so, have no indexes on a, b, c and d)...but you could toy with this till something better comes along...

select p.* from t1 p, t1 q, t1 r, t1 s where p.a = q.b and q.b = r.c and r.c = s.d; [...] 784 48 42_Re: SQL Help requested for DB2 OS/390 V5.10_20_John_Lendman@FPL.COM31_Tue, 29 Aug 2000 10:30:28 -0400425_us-ascii I think this is would work unless I missed something

Select * from t1 where (COL A = COL B and COL A=COL C and COL A = COL D)









Ed_Vetock@NAVYFEDERAL.ORG@RYCI.COM> on 08/29/2000 10:07:31 AM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc: [...] 833 49 42_Re: SQL Help requested for DB2 OS/390 V5.10_20_John_Lendman@FPL.COM31_Tue, 29 Aug 2000 10:33:52 -0400503_us-ascii If you are saying the four COLS are different values then I think this would work

Select * from T1 where (COLA|COLB|COLC|COLD|= COLA|COLB|COLC|COLD)









Ed_Vetock@NAVYFEDERAL.ORG@RYCI.COM> on 08/29/2000 10:07:31 AM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List"



To: DB2-L@RYCI.COM cc:

Subject: SQL Help requested for DB2 OS/390 V5.1 [...] 883 48 42_Re: SQL Help requested for DB2 OS/390 V5.10_19_mike.holmans@BT.COM31_Tue, 29 Aug 2000 15:34:58 +0100405_- Ed,

What's wrong with the following?

SELECT result-columns FROM T1 WHERE COLA = COLB AND COLA = COLC AND COLA = COLD

If that's not the right answer, then perhaps you could explain the problem again.

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

This post represents the views of the author and does not necessarily accurately represent the views of BT [...] 932 58 42_Re: SQL Help requested for DB2 OS/390 V5.111_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 29 Aug 2000 09:35:53 CDT346_- Ed,

You obviously don't mean something simple like:

WHERE A = B AND B = C AND C = D

(or some combination like that)

I am assuming you want to know if the combination of values A, B, C and D occur in more than one row. If so, try:

SELECT A, B, C, D, COUNT(*) FROM ... GROUP BY A,B,C,D HAVING COUNT(*) > 1 [...] 991 82 25_Re: DB2 for OS/390 to UDB0_22_BILL_GALLAGHER@PHL.COM31_Tue, 29 Aug 2000 10:34:55 -0400589_us-ascii Jim,

Having made the same transition almost a year ago, I would definitely recommend some training. Conceptually, almost all the things you are familiar with from OS/390 are implemented on AIX, such as tablespaces, bufferpools, etc., but the way in which they are physically implemented can be very different from what you are used to. I would recommend the "DB2 Universal Database Administration Workshop for UNIX (CF211)" as a good course to start with, and the "DB2 Universal Database Performance Tuning and Monitoring Workshop (CF411)" for more advanced training. [...] 1074 99 33_Re : DDF won't come up - DSNL512I19_Elmer J. Valenzuela18_elmer@KFUPM.EDU.SA31_Tue, 29 Aug 2000 17:32:48 +0300487_Windows-1252 Thanks Dean. How do I check if if the AF_INET socket provider is active? And how do I restart it? The BPXparmlib shows

/*FILESYSTYPE TYPE(INET) ENTRYPOINT(BPXTCINT) NETWORK DOMAINNAME(AF_INET) DOMAINNUMBER(2) MAXSOCKETS(64) TYPE(INET) INADDRANYPORT(2000) INADDRANYCOUNT(325) */

FILESYSTYPE TYPE(INET) ENTRYPOINT(BPXTIINT) NETWORK DOMAINNAME(AF_INET) DOMAINNUMBER(2) MAXSOCKETS(64) TYPE(INET)

I don't see any OMVS error after the refresh of TCP/IP. [...] 1174 27 47_A question about datasharing & group bufferpool14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Tue, 29 Aug 2000 16:36:22 +0100506_us-ascii We have 43 DB2 in our shop and we have a datasharing group with 2 DB2. We are planning a BP tuning for the most important DB2s, implementing multiple bufferpools for each DB2. The problem is datasharing: is it a good idea to have the same BP we have in a 'normal' DB2 ? Our S390 sysprogs don't like to allocate too many GBPs in the coupling facility, they think it's a waste of storage. For a two-members ds group may be good, but if you have many members it may be useful to have more GBPs. [...] 1202 42 42_Re: SQL Help requested for DB2 OS/390 V5.113_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 29 Aug 2000 09:36:44 -0500579_iso-8859-1 Ed,

You might try something like this:

SELECT COLA, COLB, COLC, COLD, COUNT(*) FROM T1 GROUP BY COLA, COLB, COLC, COLD HAVING COUNT(*) > 1;

Dave

-----Original Message----- From: Ed_Vetock@NAVYFEDERAL.ORG [mailto:Ed_Vetock@NAVYFEDERAL.ORG] Sent: Tuesday, August 29, 2000 9:08 AM To: DB2-L@RYCI.COM Subject: SQL Help requested for DB2 OS/390 V5.1



Hi,

We have a table T1. We'd like to identify any rows where the values are the same in COL A, COL B, COL C, and COL D. Is there a query that will produce this result? [...] 1245 88 48_SOLUTION: SQL Help requested for DB2 OS/390 V5.10_25_Ed_Vetock@NAVYFEDERAL.ORG31_Tue, 29 Aug 2000 10:55:06 -0400500_us-ascii Thanks to all that responded. The SQL solution was :

SELECT A, B, C, D, COUNT(*) FROM ... GROUP BY A,B,C,D HAVING COUNT(*) > 1;











Suresh Sane @RYCI.COM> on 08/29/2000 10:35:53 AM

Please respond to DB2 Data Base Discussion List

Sent by: DB2 Data Base Discussion List



To: DB2-L@RYCI.COM cc:

Subject: Re: SQL Help requested for DB2 OS/390 V5.1 [...] 1334 26 62_Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?19_Donald A. Smith, JR18_dsmithj@US.IBM.COM31_Tue, 29 Aug 2000 10:53:03 -0400592_us-ascii To DB2 DBA's: Has anyone had any experience with the IBM SNAPSHOT product? It has been advertised for a while as a product for creating fast back up copies of VSAM cluster's underlying DB2 objects. I see a problem in that all recoveries would have to be done OUTSIDE of DB2 thus negating the features of DB2 RECOVERY and the DB2 product itself (logging features, SYSIBM.SYSCOPY table keeping track of image copies, etc.). There appears to be another option related to SNAPSHOT called CONCURRENT COPY FOR DB2. The CONCURRENT copy seems to be DB2 friendly in that all backups are [...] 1361 32 25_Re: DB2 for OS/390 to UDB0_18_Usregion10@AOL.COM29_Tue, 29 Aug 2000 11:02:21 EDT496_ISO-8859-1 Hi Bill!

Thank you for your response to Jim's question on the listserv. Here is the deal on my side. My client has order DB2 UDB V7 on Unix (RS/6000). In the mean time, the client wants me to work with the datamodel and prepare the DDL. So once the UDB software is in place, all I have to do is create the objects using the DDL. So, my question to you is: 1. What would be the equivalent of SPUFI that I would use to run the DDL ? 2. How do you define STOGROUPS ? 3. Can I [...] 1394 50 67_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2 ?18_Sundaresan, Sundar33_Sundar.Sundaresan@SEA.SIEMENS.COM31_Tue, 29 Aug 2000 11:05:28 -0400451_iso-8859-1 Don

We have been using Snapshot in production for over a year and are quite happy with it. Please email me if you have any questions.

Sundar Sundaresan sundar.sundaresan@sea.siemens.com





-----Original Message----- From: Donald A. Smith, JR [mailto:dsmithj@US.IBM.COM] Sent: Tuesday, August 29, 2000 10:53 AM To: DB2-L@RYCI.COM Subject: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2? [...] 1445 45 33_Re : DDF won't come up - DSNL512I19_Elmer J. Valenzuela18_elmer@KFUPM.EDU.SA31_Tue, 29 Aug 2000 18:01:34 +0300235_Windows-1252 Dean, I checked and found that I did get the following messages when the system was brought up :

BPXF203I DOMAIN AF_UNIX WAS SUCCESSFULLY ACTIVATED. BPXF203I DOMAIN AF_INET WAS SUCCESSFULLY ACTIVATED.

thanks. 1491 72 66_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?0_20_John_Lendman@FPL.COM31_Tue, 29 Aug 2000 11:10:11 -0400481_us-ascii I use SNAPSHOT with the SAP system that I manage. Most of the SAP shops who have the time to quiesce their systems for 5 or 10 minutes use this method to back up. We do volume dumps, and then if we have to restore we use volume restores. We include the DB2 catalog in the dump along with the MVS user catalog. So it is a all or nothing approach. It is the way we do DR and if we need to put the entire system back for some reason it is the method we will use. By the [...] 1564 70 51_Re: A question about datasharing & group bufferpool12_Susan Lawson22_lawson_susan@YAHOO.COM31_Tue, 29 Aug 2000 08:19:04 -0700568_us-ascii Hello Max,

You need to have GBPs for any data/indexes you intend to share between the DB2 subsystems. How many you have is going to depend on how you have your objects separated out in the virtual BPs on DB2 subsystem(s). Remember, objects in each GBPs will all be using the same thresholds of individual the GBPs (such as CASTOUT (CLASST and GBPOOLT) and GBPCACHE(V6)). You will want to tune each GBP like you tune in a normal virtual pool (by usage of the objects by the applications). So it is important to have at least enough GBPs to support [...] 1635 100 66_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?0_22_Rohn.Solecki@MTS.MB.CA31_Tue, 29 Aug 2000 10:27:40 -0500322_us-ascii John, could you tell us approximately how many disk (3390?) packs you do daily. Recently we asked our service provider about doing a full system backup, presumeably using volume level dumps of one sort or another (primarily for disaster recovery). They told us the run time would be too long to be feasible. [...] 1736 52 66_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?0_29_TimHolland@ALLIEDHOLDINGS.COM31_Tue, 29 Aug 2000 11:15:50 -0400481_us-ascii I have also been using it in production for about a year as well. It works great. If you have any questions e-mail me.

Tim Holland









"Donald A. Smith, JR" on 08/29/2000 10:53:03 AM

Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Tim Holland/Link/Allied Holdings)

Subject: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2? [...] 1789 128 66_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?0_20_John_Lendman@FPL.COM31_Tue, 29 Aug 2000 11:31:31 -0400407_us-ascii I snap 64 volumes daily with about 90GB of data and the SNAP takes 7 minutes. I then take it off to tape at an offsite location this takes 1 1/2 hours.

John







Rohn.Solecki@MTS.MB.CA@RYCI.COM> on 08/29/2000 11:27:40 AM

Please respond to "DB2 Data Base Discussion List"

Sent by: "DB2 Data Base Discussion List" [...] 1918 241 33_Re : DDF won't come up - DSNL512I19_Elmer J. Valenzuela18_elmer@KFUPM.EDU.SA31_Tue, 29 Aug 2000 18:47:48 +0300691_Windows-1252 Dean, I found out that I cannot even start a new process in OMVS. I'm trying to start WebConnect but I get the message

Aug 29 11:48:32 - wcdÝsvr:module.c,381¨ >>> 'gethostname' failed, errno = 112 (EDC5112I Resource temporarily unavail able.)

Maybe the OMVS space is corrupted? Unfortunately, there's no way for me to refresh the OMVS space except thru IPL? thanks ---------------------------------------------------------------------------- --------------------------------------- I don't think the rename did it. Can you bring down DDF again, refresh IP and restart DDF to see if that clears, to avoid an IPL. What levels are we talking about OS/390 ? IP ? [...] 2160 103 51_Re: A question about datasharing & group bufferpool23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 29 Aug 2000 17:36:23 +0100416_iso-8859-1 Max

Hi. My advice would be NOT go with the one GBP approach(assuming one BP per local member).

My reasons for this are many and you will get many bits of advice from people on this list as to why a multiple BP approach will help.

The only reason why I think your sysprogs would not want your policy defined with multiple GBPs is because they are lazy and do not need the hassle. [...] 2264 131 13_Re: Table UDF23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Tue, 29 Aug 2000 12:43:18 -0400362_- James/Leo,

The CAST or SUBSTRING function did not work, however changing the INPUT parm to VARCHAR in UDF DDL and modifying the code to reflect the same, did the trick. I remember reading somewhere to always use a higher data type in UDF definition for input/output parameters so that actual data type during the invocation can always be promoted. [...] 2396 124 33_TR: bad access on SELECT MIN(xxx)12_MADAR Gilles32_gilles.madar@AXA-GLOBALRISKS.COM31_Tue, 29 Aug 2000 19:06:17 +0200443_iso-8859-1 Hi everyone,

I have a performance question to ask you.

I want to do this :

SELECT MIN (DECIMAL_COLUMN) INTO :W-GN01-IN.W-IN-ID :IND1-NULL , FROM TLOG1

But it leads to a Non Matching Index Scan as shown in the report hereafter.

DBRM/Package Statement Type DB2 Cost Access Type ------------ --------- ------ --------- ------------------------ SGNLC1 1200 SELECT 10995 * Non-Matching Index Scan [...] 2521 78 11_Re: DB2 UDB0_22_BILL_GALLAGHER@PHL.COM31_Tue, 29 Aug 2000 13:29:08 -0400352_us-ascii Anil,

1) You can use the CLP (command line processor) that comes with UDB to execute a text file of DDL.

2) UDB on UNIX does not have STOGROUPS . . . this is one of the differences between UDB on OS/390 and UDB on UNIX. As I previously mentioned, most of the OS/390 constructs can be found in the UNIX version, but not all. [...] 2600 43 43_Grant use of STOGROUP & RACF group question14_Westphal, Carl27_Carl_Westphal@COMPUWARE.COM31_Tue, 29 Aug 2000 13:48:14 -0400355_iso-8859-1 I granted use of a STOGROUP to a RACF group that a user was connected to. When he tried to create a tablespace within the STOGROUP, he got the following:

DSNT408I SQLCODE = -551, ERROR: PASPXF0 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION CREATE TABLESPACE ON OBJECT STG028

DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE [...] 2644 68 47_Re: Grant use of STOGROUP & RACF group question13_Mohan, Ashish21_Ashish.Mohan@NIKE.COM31_Tue, 29 Aug 2000 11:06:15 -0700406_iso-8859-1 Did you try doing 'SET CURRENT SQLID = ' and then creating tablespace ? I believe current sqlid needs to have all privileges in Create statement.

Thanks.

Ashish.

-----Original Message----- From: Westphal, Carl [SMTP:Carl_Westphal@COMPUWARE.COM] Sent: Tuesday, August 29, 2000 10:48 AM To: DB2-L@RYCI.COM Subject: Grant use of STOGROUP & RACF group question [...] 2713 71 47_Re: Grant use of STOGROUP & RACF group question12_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 29 Aug 2000 18:23:51 GMT298_- Carl,

When CREATEing a DB2 object it is ONLY the authority of the CURRENT SQLID that is considered, DB2 does NOT look at their GROUP authority. If the person had SET CURRENT SQLID = 'groupid', THEN ran the CREATE DDL, it (assuming the groupid is allowed to create) would have worked. [...] 2785 88 25_Re: DB2 for OS/390 to UDB13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Tue, 29 Aug 2000 13:33:55 -0500413_us-ascii Jim,

Another thing you need to look at is the operating system. If you are using UNIX for your UDB, be aware that it is nothing like MVS. Try to get an ISPF type editor for it. That will make the transition easier, since the vi editor, although powerful, is extremely cryptic and has a long learning curve. Also a class in UNIX would help. Control Center can ease some of the administration. [...] 2874 131 25_Re: DB2 for OS/390 to UDB0_22_BILL_GALLAGHER@PHL.COM31_Tue, 29 Aug 2000 14:36:55 -0400682_us-ascii The best description of the vi editor on UNIX . . . vi = "vicious interface"







Helen Johnson cc: Sent by: DB2 Data Subject: Re: DB2 for OS/390 to UDB Base Discussion List



08/29/00 02:33 PM Please respond to DB2 Data Base Discussion List











Jim,

Another thing you need to look at is the operating system. If you are using UNIX for your UDB, be aware that it is nothing like MVS. Try to get an ISPF type editor for it. That will make the transition easier, since the vi editor, although powerful, is extremely [...] 3006 48 26_Re: unable to open dsndb0132_Cuneyt Goksu (Garanti Teknoloji)22_CuneytG@GARANTI.COM.TR31_Tue, 29 Aug 2000 22:14:30 +0300603_- Did you issue Stop command for DSNDB01 ?



Cuneyt GOKSU GARANTI TEKNOLOJI Tel : 0090-212-4783210 mailto:Cuneytg@garanti.com.tr Visit : http://www.kultur.gov.tr





-----Original Message----- From: Bilal YILDIRIM [mailto:byildirim@HALKBANK.COM.TR] Sent: Tuesday, August 29, 2000 10:17 AM To: DB2-L@RYCI.COM Subject: unable to open dsndb01



We were trying to redefine active logs and bsds,after we opened the db2, db2 said to us resourse unavailable to dsndb01, so we restore all tablespace in dsndb01 and again reopened db2 and again the same problem [...] 3055 30 31_DB2 OS/390 Modify question - V610_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Tue, 29 Aug 2000 14:29:22 -0500420_us-ascii All,

We are creating a program to build modify statements to clean the catalog off in all our DB2 regions.

Since we have put V6 in place and we do a quiesce on a tablespace does an implicit quiesce on the indexes. We routinely quiesce & image copy our catalogs so.... Our troubles start there as we would like to modify the old SYSCOPY entries off for SYSUTILX's indexes DSNLUX01 & DSNLUX02. [...] 3086 85 47_Re: Grant use of STOGROUP & RACF group question14_Westphal, Carl27_Carl_Westphal@COMPUWARE.COM31_Tue, 29 Aug 2000 15:33:48 -0400438_iso-8859-1 Ashish,

Thanks for your help.

Carl

-----Original Message----- From: Mohan, Ashish [mailto:Ashish.Mohan@NIKE.COM] Sent: Tuesday, August 29, 2000 2:06 PM To: DB2-L@RYCI.COM Subject: Re: Grant use of STOGROUP & RACF group question



Did you try doing 'SET CURRENT SQLID = ' and then creating tablespace ? I believe current sqlid needs to have all privileges in Create statement. [...] 3172 90 47_Re: Grant use of STOGROUP & RACF group question14_Westphal, Carl27_Carl_Westphal@COMPUWARE.COM31_Tue, 29 Aug 2000 15:34:03 -0400569_iso-8859-1 Craig,

Thanks for your help.

Carl

-----Original Message----- From: craig patton [mailto:prgpatton@HOTMAIL.COM] Sent: Tuesday, August 29, 2000 2:24 PM To: DB2-L@RYCI.COM Subject: Re: Grant use of STOGROUP & RACF group question



Carl,

When CREATEing a DB2 object it is ONLY the authority of the CURRENT SQLID that is considered, DB2 does NOT look at their GROUP authority. If the person had SET CURRENT SQLID = 'groupid', THEN ran the CREATE DDL, it (assuming the groupid is allowed to create) would have worked. [...] 3263 59 35_Re: DB2 OS/390 Modify question - V612_craig patton21_prgpatton@HOTMAIL.COM29_Tue, 29 Aug 2000 19:41:09 GMT298_- Missy,

Why do you have entries in syscopy for sysutlx??? You might want to consider NOT running UTILS against that particular TS as the ONLY time it contains data, is when there is a utility active. I can't think of anyway to help get rid of the rows already there.

HTH, Craig [...] 3323 182 25_Re: DB2 for OS/390 to UDB12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Tue, 29 Aug 2000 14:59:22 -0500453_iso-8859-1 Helen,

I learned vi in the early '90's, after many years using PDF edit on the mainframe.

I fought it. Finally, I quit fighting vi and forced myself to really learn it.

Now I love vi. I also love PDF edit. They are radically different. But both have strengths and weaknesses.

By the way, PDF edit line commands are as cryptic as anything in vi. They are familiar only because we learned them a long time ago. [...] 3506 238 25_Re: DB2 for OS/390 to UDB14_Laredo, Andrew19_Andy_Laredo@BMC.COM31_Tue, 29 Aug 2000 15:08:18 -0500311_iso-8859-1 I hate to argue over edit commands, but here goes.

As far as I am concerned the pdf editor is the most consistent, standard, easiest editor to use hands down. And powerful. And consistent to the point of boredom. Vi should be compared with the old, still existent, ready mode tso editor. [...] 3745 19 35_db2 connectivity to other platforms10_Tom Taylor17_ttaylor@CHUBB.COM31_Tue, 29 Aug 2000 16:15:43 -0400557_us-ascii hi all

I need some help understanding remote connection setup. Is it correct that db2 for os/390 CLI enables db2 to make odbc/cli calls to other platforms? And this has nothing to do with other platforms making calls TO db2 for os/390? If not could you please correct my misunderstanding.

Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 3765 24 48_setting secondary authid(s) in DB2 for OS/390 V616_Bachi Allamsetty22_BachiA@RENEWAL-IIS.COM31_Tue, 29 Aug 2000 16:17:01 -0400383_iso-8859-1 Hello All !

Can anyone explain or point me in the right direction to enable secondary authid(s) defined in RACF for DB2 FOR OS/390 V6?

I checked Admn. guide 3.4 chapter. It did give some info.

I am wondering if there is any step-by-step kind of documentation I can lay my hands on or anybody's personal experiences with regards to this exercise. [...] 3790 25 37_DB2 UDB Mission Critical Applications0_18_Usregion10@AOL.COM29_Tue, 29 Aug 2000 17:11:16 EDT505_ISO-8859-1 Hi all!

In the past, I have always worked at clients where all the mission critical applications with done using DB2 for OS/390 (or MVS land) and other non-mission critical (or maybe some small mission-critical systems) done using UDB. Since my client here is on the verge of finalizing DB2 UDb as the database platform for one of their main applications, I was wondering if I could get a feel for how many folks in here have seen UDB being used of a large mission critical system. [...] 3816 146 25_Re: DB2 for OS/390 to UDB13_Horton, Libby20_Libby_Horton@BMC.COM31_Tue, 29 Aug 2000 16:26:06 -0500542_iso-8859-1 A long time Unix user told me it's "virtually impossible"

-----Original Message----- From: BILL_GALLAGHER@PHL.COM [mailto:BILL_GALLAGHER@PHL.COM] Sent: Tuesday, August 29, 2000 1:37 PM To: DB2-L@RYCI.COM Subject: Re: DB2 for OS/390 to UDB



The best description of the vi editor on UNIX . . . vi = "vicious interface"







Helen Johnson cc: Sent by: DB2 Data Subject: Re: DB2 for OS/390 to UDB Base Discussion List [...] 3963 159 37_Re: TR: bad access on SELECT MIN(xxx)11_Suresh Sane21_data_arch@HOTMAIL.COM29_Tue, 29 Aug 2000 16:56:46 CDT656_- Madar,

Matchcols is meaningful only for accesstype I and N (and MX, I suppose). You have I1 which is a one-fetch index access - root-->first leafpage and out. Doesn't get much better than this. I would suggest leaving the query as is. Why mess with something good?

HTH

Suresh



>From: MADAR Gilles >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: TR: bad access on SELECT MIN(xxx) >Date: Tue, 29 Aug 2000 19:06:17 +0200 > >Hi everyone, > >I have a performance question to ask you. > >I want to do this : > >SELECT MIN (DECIMAL_COLUMN) >INTO [...] 4123 31 16_DB2 Connect pkgs13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 29 Aug 2000 16:53:58 -0500661_iso-8859-1 Hello List,

Does anyone know where DB2 Connect packages are documented?

i.e. the naming convention as documented in Quick Beginnings v6 appendix G doesn't match our package names after binding v6.

I'm looking to indentify precisely which packages are associated with each version/fixpack that we support, and what the package function is.

For example, specifically for packages SQLLC400 and SQLLF400, I want to change the release attribute from deallocate to commit, in hopes of allowing some Websphere java.exe threads to go inactive on the host (DB2 V5), but I would feel better if I knew that the change would not [...] 4155 49 52_Re: setting secondary authid(s) in DB2 for OS/390 V611_Brian Lynch27_blynch@GRPWISE-EAST.TRW.COM31_Tue, 29 Aug 2000 18:49:11 -0400499_US-ASCII Hey Bachi, Check the installation guide migration step 15: Define User Authorization Exit Routines.

Job DSNTIJEX builds the sample authorization exits, DSN3@SGN and DSN3@ATH from the source code in prefix.SDSNSAMP and places them in the prefix. SDSNEXIT library.

The sample authorization exits are not the same as the default authorization exits supplied by DB2. By implementing the sample authorization exits, you can provide group names as secondary authorization IDs. [...] 4205 33 21_Stored Procedure Help13_Matheny, Bill25_bill.matheny@EXPERIAN.COM31_Tue, 29 Aug 2000 15:51:23 -0700585_iso-8859-1 We're just beginning to develop stored procedures using DB2 version 5. As a first step, we've written a simple Cobol program to call a stored procedure, passing data to the procedure and getting data back. We've run into a problem which we haven't been able to solve: even though we are able to start the procedure and get a "successful" return code, we get a -204 when calling the procedure which indicates that there's a mismatch between the parameters being passed in the call and those the stored procedure is expecting. Our only theory at this point is that we've [...] 4239 23 25_Re: Stored Procedure Help12_Jim Harrison12_jimh@QIS.NET31_Tue, 29 Aug 2000 19:05:05 -0700513_us-ascii Can you post the callers parameters & the call statement along with the SP linkage section and the SYSPROCEDURES table entry for the SP?

At 03:51 PM 8/29/2000 -0700, you wrote:

>start the procedure and get a "successful" return code, we get a -204 when >calling the procedure which indicates that there's a mismatch between the >parameters being passed in the call and those the stored procedure is >expecting. Our only theory at this point is that we've defined our >variables wrong. [...] 4263 85 26_Re: unable to open dsndb0114_Jack O'Connell26_jack.oconnell@MCMASTER.COM31_Tue, 29 Aug 2000 18:32:24 -0500581_- I Think you need to be defined as INSTALL SYSADM to issue stop / start commands against the DB2 catalog & directory.

before attempting this next process make sure you are authorized to make youself INSTALL SYSADM. No anarchy please.

You may have to rerun the most recent version of the DSNTIJUZ job to make yourself INSTALL SYSADM ( I don't think it can be a racf group name ). Make sure that the parms in the DSNTIJUZ parm reflect the current definition 1st. Also, backup (or rename ) the current module assembled in the LINK-LISTED or STEPLIB'd library that [...] 4349 58 22_Re: Db2 subsystem name14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Wed, 30 Aug 2000 11:57:28 +1100732_iso-8859-1 However, with parmlib concatenations, the IEFSSNxx member might not be in SYS1.PARMLIB.

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

-----Original Message----- From: MARTIN WOLFF [mailto:martin_wolff@GLOBALCROSSING.COM] Sent: Tuesday, August 29, 2000 11:26 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Db2 subsystem name



Here is the way that will always work. Ensure you are logged onto the correct MVS image. Brouse SYS1.PARMLIB and look for the members that start IEFSSN*. Each IPL can invoke a different one (or more than one) of these but default one is called IEFSSN00. Search for "DSN3INI" and somewhere on [...] 4408 16 22_Re: Db2 subsystem name26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Tue, 29 Aug 2000 20:06:34 -0500391_- With SETSSI available with OS/390 it might not be in any parmlib! ===>d ssi Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 4425 88 22_Re: Db2 subsystem name17_Venkat Srinivasan28_venkatsrinivasan@HOTMAIL.COM29_Tue, 29 Aug 2000 21:24:28 EDT298_- It is defined in many places including the Parmlib. But seriously the easiest way is to pick up that phone and ask the help desk. All roads lead to a dead end because everywhere u will find multiple SSN., SDSF, Parmlib concats, logs etc.. Looks like a grim situation.

Regards, Venkat [...] 4514 39 22_Re: Db2 subsystem name27_Thakral, Deepak Kumar (CTS)24_TDeepak@CHN.CTS-CORP.COM31_Wed, 30 Aug 2000 00:14:51 -0400507_iso-8859-1 Hi Ed,

I have seen SETSSI beeing used in my shop , but never really understood how it affects the behaviour of the COBOL-DB2 Program.

And why should using SETSSI cause the subsystem not to appear in any parmlib (if that is what I understand you are trying to say)

Thanks Deepak

-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Wednesday, August 30, 2000 6:37 AM To: DB2-L@RYCI.COM Subject: Re: Db2 subsystem name [...] 4554 28 33_DBD'S CHAIN LOCKS IN THE EDM POOL12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 30 Aug 2000 04:46:20 GMT361_- Hi folks:



I've got a quick enquire about the EDM behavior. When the DBD'S are require in the EDM POOL and the DBD'S is too big and it is compound of many DBD'S blocks, all those DBD'S has to be taken to from dasd (if not already there) and placed to the EDM POOL or just the DBD block with the information requested. Thanks for your help, [...] 4583 156 33_Re: bad access on SELECT MIN(xxx)7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Wed, 30 Aug 2000 10:34:29 +0530571_iso-8859-1 Hi Gilles, First of all i want to ask which performance monitoring tool or the query running tool has given you the information about DB2 Cost ?.I have never believed on the cost given by these tools because what i think is these tools gives the cost i.e DB2 Cost without consulting the optimizer i.e before the query is optimized and on the basis of the standard patterns.I have seen many times QMF's estimated cost of 5000+ query runs faster than Cost=1.I do not know what is the concept they use for estimating the cost.May someone in the list explain [...] 4740 31 18_TURNING ON SEQCACH12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 30 Aug 2000 05:05:59 GMT318_- Hi Folks:



I would like to know if anyone in your shop has found any problems turnning on SEQCACH , allowing to use the sequential mode to read cached data from a 3990 controller. I would like to hear your comments about it and drawbacks or improvement , if any came up. Thanks for your comments, [...] 4772 54 37_Re: DBD'S CHAIN LOCKS IN THE EDM POOL7_Sanjeev21_Sanjeev@INTERRAIT.COM31_Wed, 30 Aug 2000 10:52:13 +0530409_iso-8859-1 Hi Harbry, If i understood your question correctly then it is not the DBD's which are compound of many blocks but it is the directory tablespace(DBD01) which are compound of many blocks and each block is called as the DBD of the corresponding database.For any object accessed in that database, complete DBD or "we can call" just that block of DBD01(tablespace) will be loaded in the EDM pool. [...] 4827 59 35_Re: DB2 OS/390 Modify question - V67_Sanjeev21_Sanjeev@INTERRAIT.COM31_Wed, 30 Aug 2000 11:00:25 +0530540_iso-8859-1 Hi Missy, I am not sure how you get the rows for SYSUTILX in SYSCOP but it seems your COPY control card which runs with your automated jobs have got this included by mistake(may be).SYSUTILX contains data only when your utility is running ,so no need to take the image copy. I am not sure how to remove this entry for SYSUTILX from SYSCOPY, infact i don't think there is any other way out than going thru' the wrong route and update SYSCOPY. So, look at your COPY control cards so that you may not get the rows for SYSUTILX [...] 4887 99 35_Re: DB2 OS/390 Modify question - V619_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Wed, 30 Aug 2000 01:30:13 -0400505_iso-8859-1 The "SYSCOPY" information for SYSUTILX is contained in the log.

The "Remote Site Recovery from Disaster at a Local Site" section of the DB2 for OS/390 V5 Admin guide lists the recovery sequence for BSDS, logs, catalog/directory objects are recovered. The sequence is BSDS, logs, SYSUTILX and the remainder of the catalog/directory objects. SYSUTILX is recovered before SYSCOPY. Since SYSCOPY has not been recovered, the recovery information for SYSUTILX must be in the log or BSDS. [...] 4987 15 23_UDB AIX Discussion List7_Db2 Dba24_data_analyst@HOTMAIL.COM31_Wed, 30 Aug 2000 00:23:15 -0500382_- Hi everyone,

I am looking for an active discussion list that focuses on UDB/AIX. Can someone recommend one?

Thanks very much

================================================ 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. 5003 42 27_Re: UDB AIX Discussion List19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Wed, 30 Aug 2000 01:43:49 -0400795_iso-8859-1 Sign up for DB2EUG at http://people.mn.mediaone.net/scottrmcleod/index.htm







Mike Piontkowski mailto:michael_piontkowski@compuserve.com



-----Original Message----- From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of Db2 Dba Sent: Wednesday, August 30, 2000 01:23 To: DB2-L@RYCI.COM Subject: [DB2-L] UDB AIX Discussion List



Hi everyone,

I am looking for an active discussion list that focuses on UDB/AIX. Can someone recommend one?

Thanks very much

================================================ 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. [...] 5046 171 27_Re: UDB AIX Discussion List11_KUHN,Ulrich37_ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU31_Wed, 30 Aug 2000 17:04:22 +1100741_- Also the comp.databases.ibm-db2 newsgroup. Much more active than the DB2EUG list server, and with frequent direct feedback from the Toronto lab.

> -----Original Message----- > From: Michael Piontkowski [SMTP:michael_piontkowski@compuserve.com] > Sent: Wednesday, August 30, 2000 3:44 PM > To: DB2-L@RYCI.COM > Subject: Re: UDB AIX Discussion List > > Sign up for DB2EUG at > http://people.mn.mediaone.net/scottrmcleod/index.htm > > > > > Mike Piontkowski > mailto:michael_piontkowski@compuserve.com > > > -----Original Message----- > From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of Db2 > Dba > Sent: Wednesday, August 30, 2000 01:23 > To: DB2-L@RYCI.COM > Subject: [DB2-L] UDB AIX Discussion List > > > Hi [...] 5218 223 27_Re: UDB AIX Discussion List19_Michael Piontkowski34_michael_piontkowski@COMPUSERVE.COM31_Wed, 30 Aug 2000 02:13:02 -0400569_iso-8859-1 RE: UDB AIX Discussion ListYes, I forgot about that newsgroup. Also, IBM sponsors newsgroups. Check out ibm.software.db2.* newsgroups. The news server is news.software.ibm.com. Not very active but it is monitored by the IBM lab.







Mike Piontkowski mailto:michael_piontkowski@compuserve.com





-----Original Message----- From: owner-db2-l@RYCI.COM [mailto:owner-db2-l@RYCI.COM]On Behalf Of KUHN,Ulrich Sent: Wednesday, August 30, 2000 02:04 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] UDB AIX Discussion List [...] 5442 89 22_Re: Db2 subsystem name9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Wed, 30 Aug 2000 07:46:39 +0100524_us-ascii SETSSI allows you to dynamically add (or deactivate) a sub-system definition (e.g. DB2) to OS390 without having to carry out an IPL. If you want to add a sub-system definition using SYS1.PARMLIB, then you will require an IPL to activate it. If you add a sub-system using SETSSI and you want that definition to remain active after an IPL, then you should also ensure that you add the definition to SYS1.PARMLIB or the definition will be subsequently lost. Kind Regards, Andy Hunt - Scottish And Southern Energy [...] 5532 259 25_Re: DB2 for OS/390 to UDB0_18_mebert@AMADEUS.NET31_Wed, 30 Aug 2000 09:10:11 +0200436_us-ascii The vi belongs to the "YAFIYGI" ("you asked for it, you got it") type of programs... which I prefer to today's pervasive "Are you sure?" any time.

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







From: Higgins John on 29/08/2000 19:59 GMT

Please respond to DB2 Data Base Discussion List [...] 5792 128 35_Re: DB2 OS/390 Modify question - V60_18_mebert@AMADEUS.NET31_Wed, 30 Aug 2000 09:36:06 +0200399_us-ascii Hi Missy,

you might check APAR PQ25931/PTF UQ31538 which adresses a bug in V6 toleration code on V5 and V6 where DB2 inserts ICTYPE='B' type records when performing a REBUILD INDEX on directory tablespaces. After application of this PTF and being on V6, you can get rid of the index entries by performing a MODIFY on the underlying tablespace, according to the PTF description. [...] 5921 85 37_Re: DBD'S CHAIN LOCKS IN THE EDM POOL17_William R. Miller32_william.miller@DRESDNER-BANK.COM31_Wed, 30 Aug 2000 03:28:32 -0500536_- Hi all, When DB2 executes SQL, it requires that all DBDs referenced by the executing SQL be competely (and in v5 and before - contiguously) loaded into the EDM pool before SQL execution can begin. The layout of the DBD is different in the EDM Pool as it is on disk. One of these differences is a use counter, which DB2 increments for active SQL access and decrements when the SQL is complete. In an overload situation, that is, when a SQL references a database which does not have a DBD already contained in the EDM pool - AND - [...] 6007 20 22_Re: TURNING ON SEQCACH14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Wed, 30 Aug 2000 11:11:33 +0100327_us-ascii Turn it only if you have a cache size greater than 64 MB.....they said. But I used SEQCACHE with a cache size of 256 Mb (an old 3990-3) and it was not so good (we had a lot of bypass cache).

If you have RAID devices (we use it now, but we have a cache size > 2 Gb) and/or a large cache size it works well. [...] 6028 33 0_8_wuaizhen22_wuaizhen@MAIL.DCAC.COM31_Wed, 30 Aug 2000 17:06:20 +080040_gb2312 SUBSCRIBE DB2-L AIZHEN WU

6062 47 0_14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Wed, 30 Aug 2000 12:25:15 +0100393_us-ascii Hi Susan & Leslie and many many thanks for your suggestions.

I use multiple BPs since I installed the first DB2 Version 3 'cause I was warned by Horacio Terrizzano it was the right way to tune DB2 subsystem (with an appropriate use of accounting and statistic traces, this is Horacio's beloved arguments, along with the use of color green for TCBs, and red for SRBs....). [...] 6110 52 41_Re: DB2 UDB Mission Critical Applications13_Philip Nelson21_teamdba@ATTGLOBAL.NET31_Wed, 30 Aug 2000 11:51:09 +0100368_us-ascii Anil,

We use DB2 UDB (AIX) for two mission critical applications within our organisation - one for processing mortgage applications, the other for call centre workflow management (approx 700 clients).

Developers simply use Visual Basic. As DBAs we use Perl scripts and are currently looking at the Embarcadero DBA toolset (DBArtisan etc.). [...] 6163 113 41_Re: DB2 UDB Mission Critical Applications18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Wed, 30 Aug 2000 07:18:09 -0400606_- Our Environment: Unix running Solaris 2.6.

We are presently converting our help desk application from Oracle to UDB. We currently have 100 users but that is going to increase significantly after the conversion to about 500. The application is available from 6am - midnight 7 days a week. So far, things are looking great in the QA environment but you won't really know the results until Production. The biggest difference I have noticed is the backup/restore process. Oracle takes 1.25 hours to backup and about 2.5 to restore. UDB takes 8 minutes to backup and 10 minutes to restore without [...] 6277 45 25_Re: Stored Procedure Help12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Wed, 30 Aug 2000 08:15:36 -0400571_us-ascii Do you have a blank or an 'N' in the linkage column? I guess I am saying, if you using the 'SIMPLE WITH NULLS' convention ('N' in the linkage column), are you handling the null variables right?

Martin Wolff.

"Matheny, Bill" wrote:

> We're just beginning to develop stored procedures using DB2 version 5. As a > first step, we've written a simple Cobol program to call a stored procedure, > passing data to the procedure and getting data back. We've run into a > problem which we haven't been able to solve: even though we are able to > [...] 6323 273 33_Re : DDF won't come up - DSNL152I19_Elmer J. Valenzuela18_elmer@KFUPM.EDU.SA31_Wed, 30 Aug 2000 15:13:52 +0300659_Windows-1252 Did an IPL and everything's now working fine. Also have taken note of the low maxsockets value, increased that . Thanks for the help. regards.. ===================================================================





What happens when you do a ps -ef ? Yes, it appears that USS is hosed. Looks like an IPL is forthcoming.

> -----Original Message----- > From: Elmer J. Valenzuela [SMTP:elmer@KFUPM.EDU.SA] > Sent: Tuesday, August 29, 2000 11:48 AM > To: DB2-L@RYCI.COM > Subject: Re : DDF won't come up - DSNL512I > > Dean, I found out that I cannot even start a new process in OMVS. I'm > trying to start WebConnect [...] 6597 39 44_Re: Setting SPUFI to run across DB2 Releases13_Tierney, Mark20_mtierney@FIRSTAM.COM31_Wed, 30 Aug 2000 07:30:55 -0500583_- Hi Gerry,

The level of DSN (in TSO) is probably still at the lower level. What we do to avoid this is to LIBDEF the SDSNLOAD to the userid doing the SPUFI. Use the same one that the subsystem is using.

Regards, Mark

> -----Original Message----- > From: Gerald Hodge [SMTP:ghodge@ATTGLOBAL.NET] > Sent: Wednesday, August 23, 2000 8:10 PM > To: DB2-L@RYCI.COM > Subject: Setting SPUFI to run across DB2 Releases > > I am setting up a new release of DB2. SPUFI gives a message DSNE133E > DSNECP12 release levels not compatible. I recall there is a method to [...] 6637 43 24_Re: write enginesMessage14_Joel Goldstein29_joel_goldstein@COMPUSERVE.COM31_Wed, 30 Aug 2000 08:41:39 -0400644_ISO-8859-1 Max, If you are running out of write engines frequently, you have DASD performance problems, and your VDWQT is too high. And you also need a much better separation of objects to acheive decent performance.

Regards, Joel +++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Message text written by DB2 Data Base Discussion List >Now we have 3 GBP (one for catalog and 'utilities' tables (!!!), another for TS & IX that's to say a billion of objects, another for 32k pages) but I hope to use some others GBPs. By the way the run out of write engines almost every day.......so please Leslie, if you have [...] 6681 35 24_Re: write enginesMessage14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Wed, 30 Aug 2000 15:11:21 +0100587_us-ascii First of all, let me say how I appreciate your 'White Papers' in Responsive System's Web site and your e-mails in DB2-l. I started the study of BP tuning by reading your articles about BP and DASD tuning, they are a real good guideline.

And yes, I'm well aware that the problems are poor DASD performance (some of our 43 DB2 have DASD problems, mainly due to 'hot spot' or spikes in daily activities....so the problem is dataset placement that is STILL important,as you said a lot of times) and VDWQT should be lower......but according our DASD manager the response [...] 6717 12 27_segmented to partitioned ts0_27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 30 Aug 2000 09:15:35 -0400239_- I need to convert a segmented ts to partitioned and move the current data into one of the partitions. Can I use a file from a full backup to reload with or do I need an UNLOADed file for the reload. We are on os390 r 5 and db2 v4.1 [...] 6730 77 25_Re: Stored Procedure Help9_Cam White20_cwhite@REVEALNET.COM31_Wed, 30 Aug 2000 09:26:44 -0400461_iso-8859-1 Bill,

For a better understanding of Stored Procedures with examples, download the 30-day trial version of the RevealNet Knowledge Base for DB2. Just type "Stored" and the Knowledge Base will return 47 topics on Stored Procedures.

Sample topics include:

* Stored Procedures - Coding Rules * Stored Procedures - Parameters * Stored Procedures Calling * Java and DB2 Stored Procedures * Stored Procedures - JCL for Preparation [...] 6808 45 31_Re: segmented to partitioned ts12_craig patton21_prgpatton@HOTMAIL.COM29_Wed, 30 Aug 2000 13:27:05 GMT308_- Bud,

You need the UNLOADed type of file, unless you have one of the 3rd party LOAD tools that can use the IC as input. You can't use DSN1COPY as you are changing the tablespace. The normal process is to unload, drop TS, recreate TS and all dependent objects, then load, runstat and image copy. [...] 6854 10 31_Re: segmented to partitioned ts0_27_Bud.Greenman@ONONDAGA.NY.US31_Wed, 30 Aug 2000 09:36:51 -0400294_- Thanks. That is what I thought I would have to do.

================================================ 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. 6865 61 25_Re: Stored Procedure Help14_Laredo, Andrew19_Andy_Laredo@BMC.COM31_Wed, 30 Aug 2000 08:55:02 -0500670_iso-8859-1 Remember to start and stop the procedures anytime you change the definitions in sysibm.sysproce...

-----Original Message----- From: Matheny, Bill [mailto:bill.matheny@EXPERIAN.COM] Sent: Tuesday, August 29, 2000 6:51 PM To: DB2-L@RYCI.COM Subject: Stored Procedure Help

We're just beginning to develop stored procedures using DB2 version 5. As a first step, we've written a simple Cobol program to call a stored procedure, passing data to the procedure and getting data back. We've run into a problem which we haven't been able to solve: even though we are able to start the procedure and get a "successful" return code, we get a -204 when [...] 6927 62 22_Re: Db2 subsystem name11_Conlin, Ron19_ron.conlin@JNLI.COM31_Wed, 30 Aug 2000 11:02:04 -0400458_iso-8859-1 You can use the MVS command 'D SSI,L' to get a list of subsystems and whether they are dynamic or not. The SETSSI command allows you to dynamically add and remove subsystems without requiring an IPL (the normal requirement for IEFSSNxx in Parmlib).

Best Regards.

Ronald L. Conlin Jackson National Life Insurance Company Technology Department - Systems Programmer voice: 517.367.3931 fax: 517.394.0986 email: ron.conlin@jnli.com [...] 6990 26 29_I/O support for DB2 Utilities12_MARTIN WOLFF31_martin_wolff@GLOBALCROSSING.COM31_Wed, 30 Aug 2000 11:07:25 -0400391_us-ascii Here is a possibly complex problem.

Does DSNUTILB ie DB2 support multi-volume datasets for its internal datasets? What I am specifically saying is can the SYSUT1 (the sort input dataset) handle 'multi-voluming' using something such as Stop X37. I can see that the dataset is being built by using Note Point I/O rather than EXCP but DSNUTILB has to be able to handle it? [...] 7017 164 41_Re: DB2 UDB Mission Critical Applications12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Wed, 30 Aug 2000 10:08:03 -0500338_iso-8859-1 My experience with Oracle backups would indicate 4 minutes to backup 4GB to disk.

If you backup to DAT, well 4GB/hour is as good as the tape gets.

There is no reason that restore would take any longer than backup.

I don't mean to defend Oracle here, but those timings must be related to your methods. [...] 7182 119 35_Re: DB2 OS/390 Modify question - V622_Piontkowski Michael ML35_michael.piontkowski@ASTRAZENECA.COM31_Wed, 30 Aug 2000 11:20:12 -0400515_iso-8859-1 Ooops - I referenced V5 books. The same sections in the V6 books have similar information.



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





-----Original Message----- From: Michael Piontkowski [mailto:michael_piontkowski@COMPUSERVE.COM] Sent: Wednesday, August 30, 2000 1:30 To: DB2-L@RYCI.COM Subject: Re: [DB2-L] DB2 OS/390 Modify question - V6



The "SYSCOPY" information for SYSUTILX is contained in the log. [...] 7302 59 33_Re: I/O support for DB2 Utilities12_Carol Sutfin19_csutfin@AMSOUTH.COM31_Wed, 30 Aug 2000 10:30:34 -0500551_- Martin,

Yes, SYSUT1 and SORTOUT can handle multi-vol datasets. I have used both tape and dasd as multi-vol for both of these in V3, V4 and V5.

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









MARTIN WOLFF on 08/30/2000 10:07:25 AM



Please respond to DB2 Data Base Discussion List

To: DB2-L@RYCI.COM cc: (bcc: Carol Sutfin/BIRMINGHAM/AL/AMSOUTH BANK) Subject: I/O support for DB2 Utilities [...] 7362 106 33_Re: I/O support for DB2 Utilities0_18_mebert@AMADEUS.NET31_Wed, 30 Aug 2000 17:38:42 +0200338_us-ascii I have never heard about Stop X37 or Note Point, but I routinely use multi-volume datasets for SYSREC and SYSUT11 (allocated using ISPF 3.2 "M" option). Nothing to it. I'm not aware of any size limitations (neither are the MVS guys I just asked) and a quick check of the JCL reference guide didn't reveal any (OS/390 R2.8). [...] 7469 183 27_Re: UDB AIX Discussion List17_McDonnell, Victor22_vmcdonnell@CAYENTA.COM31_Wed, 30 Aug 2000 08:56:47 -0700504_iso-8859-1 How would one go about accessing, say, the 'comp.databases.ibm-db2' newsgroup. (I need the book 'Newsgroups for Dummies')

Thanks, Victor McDonnell Database Architecture and Administration

1900 Campus Commons Dr Reston, VA 20191 phone: 703.390.4826 email: vmcdonnell@cayenta.com

-----Original Message----- From: KUHN,Ulrich [mailto:ulrich.kuhn@EMPLOYMENTNATIONAL.COM.AU] Sent: Wednesday, August 30, 2000 2:04 AM To: DB2-L@RYCI.COM Subject: Re: UDB AIX Discussion List [...] 7653 78 47_A question about datasharing & group bufferpool29_Chris Munson/Santa Teresa/IBM18_cmunson@US.IBM.COM31_Wed, 30 Aug 2000 10:09:39 -0600554_us-ascii Max, Unless you are CF storage constrained I find it hard to accept that CF storage for GBP's is a 'waste' as your sysprog puts it (unless they are grossly over allocated). A GBP is an essential part of a data sharing group and shouldn't be taken lightly. This is of course unless you are not concerned with performance or availability. Too small of a GBP can lead to performance issues as perfectly good pages in virtual pools may be unnecessarily invalidated or worse, pages may be added to LPL if the GBP fills up, requiring a STA DB to [...] 7732 272 27_Re: UDB AIX Discussion List10_Park, Stan17_SPark@STATE.NM.US31_Wed, 30 Aug 2000 10:12:06 -0600527_iso-8859-1 try htt p://www.dejanews.com/home_ps.shtml and enter *db2 for the archive

-----Original Message----- From: McDonnell, Victor [mailto:vmcdonnell@CAYENTA.COM] Sent: Wednesday, August 30, 2000 9:57 AM To: DB2-L@RYCI.COM Subject: Re: UDB AIX Discussion List



How would one go about accessing, say, the 'comp.databases.ibm-db2' newsgroup. (I need the book 'Newsgroups for Dummies')

Thanks, Victor McDonnell Database Architecture and Administration [...] 8005 430 25_Re: DB2 for OS/390 to UDB13_Helen Johnson25_helen_johnson@RAC.RAY.COM31_Wed, 30 Aug 2000 11:48:34 -0500403_us-ascii John,

I learned vi too. And I can do anything I need to in it, sometimes with the help of the vi book from Nutshell. But there is no way that it can compare to ISPF. Even if a person knew both equally well, it just takes a lot more key strokes in vi than in ISPF. For example, to save in ISPF is PF3 and in vi, it is ESC-:-w-q. Vi is just typing intensive as well as being cryptic. [...] 8436 69 25_Re: DB2 for OS/390 to UDB13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Wed, 30 Aug 2000 13:00:02 -0400288_iso-8859-1 >But there is no way that it can compare to ISPF. >Even if a person knew both equally well, >it just takes a lot more key strokes in vi than in ISPF.

But Helen, Those people who cut their editting teeth on vi and know and love it have it hardwired in their brains. [...] 8506 24 29_DB2 Stored procedure and EXCI21_Brown, James R. - DIT25_brownjr@CI.RICHMOND.VA.US31_Wed, 30 Aug 2000 14:04:53 -0400395_iso-8859-1 Hi all,

I am having a security problem connecting to a CICS region thru the EXCI interface from a DB2 stored procedure. The DB2 stored procedures address space has been given read authority on the DFHAPPL.applid facility thru RACF and I have followed the guidelines in the Stored procedures Redbook, but I get an IRC_CONNECTION_FAILURE when I call the open_pipe function. [...] 8531 57 24_Stored procedure problem15_Stovall, Martin16_MStovall@USG.COM31_Wed, 30 Aug 2000 13:07:41 -0500429_iso-8859-1 In testing stored procedures for the first time with version 5, I've encountered a problem will calling a stored procedure: when I use a literal as an input parameter the call works ; when I change the literal to be a host variable of the same length, the call abends with what looks like a storage violation. Has anyone encountered this? Any ideas what could be causing this? Any help is definitely appreciated. [...] 8589 20 25_Re: DB2 for OS/390 to UDB26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 30 Aug 2000 13:09:59 -0500390_- I was ISPF project manager for SHARE back in the eighties and editor preference falls into the politics/religion categories. Think Bill Joy in his recent article on ethics in programming/system's design( www.sun.com ) said it best. "When I wrote vi 27 years ago I never dreamed anyone would still be using it." Edward(Ed) J. Finnell, III Enterprise Systems/Proj. Mgr. url:www.ua.edu [...] 8610 43 25_Re: DB2 for OS/390 to UDB15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Wed, 30 Aug 2000 15:36:23 -0400419_- Just for information

There is PC editor called TEXTPAD,(Not free, but can get the trial version from TEXTPAD.COM). This is the best editor I used in the PC.

Thanks Sibimon Philip







-----Original Message----- From: Edward(Ed) J. Finnell, III [mailto:efinnell@SEEBECK.UA.EDU] Sent: Wednesday, August 30, 2000 1:10 PM To: DB2-L@RYCI.COM Subject: Re: DB2 for OS/390 to UDB [...] 8654 293 25_Re: DB2 for OS/390 to UDB12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Wed, 30 Aug 2000 14:44:45 -0500503_iso-8859-1 Helen,

You can map PF3 to ESC-:-w-q in vi.

etc.

You can store your key mappings in a .exrc file in your home directory. This is automatically read by vi for every edit.

For example, here is a screen dump of a vi of my .exrc from an HP box: 1 set number autoindent autowrite showmatch wrapmargin=0 report=1 2 map ^W :set wrapmargin=8 3 map ^X {!}sort -b 4 map ^[h 1G 5 map ^[H 1G 6 map ^[F G 7 map ^[V ^B 8 map ^[U ^F 9 map ^[T ^Yk 10 map ^[S ^Ej 11 map ^[Q i [...] 8948 13 27_UDB DB2 in an editor buffer13_Henry J. Cobb23_hcobb@CHEAPESTDEALS.COM31_Wed, 30 Aug 2000 14:37:48 -0500359_- Has anybody adapted SQL-mode for Emacs to run under NT Emacs connecting to UDB CLI on the same machine?

-HJC

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 8962 96 84_Repost: Redbook Announcement: DB2 UDB for OS/390 Version 6 Manage ment Tools Package13_Morrill, John12_JohnM@VP.NET31_Wed, 30 Aug 2000 16:30:36 -0600582_iso-8859-1 Dear DB2 Interested Parties,

A new "DB2 UDB for OS/390 Version 6 Management Tools Package" redbook is now available, see the bulletin below. The book can be downloaded from the Web in pdf format, or hardcopy can be ordered at http://www.redbooks.ibm.com/abstracts/sg245759.html .

You may view/download Redbooks, Redpieces, Redpapers, and see ITSO* residencies currently open at http://www.redbooks.ibm.com/ (hint: search on "DB2") or you can view/download Redbooks at http://www.fatbrain.com/documentation/redbooks/home.html/ (again, search on "DB2"). [...] 9059 306 25_Re: DB2 for OS/390 to UDB13_OConner, John26_John.OConner@COURTS.WA.GOV31_Wed, 30 Aug 2000 15:30:56 -0700469_iso-8859-1 What ever happened to TECO? Now there's a "peach" of an editor.

-----Original Message----- From: Higgins John [mailto:HigginsJohn@JOHNDEERE.COM] Sent: Wednesday, August 30, 2000 12:45 PM To: DB2-L@RYCI.COM Subject: Re: DB2 for OS/390 to UDB



Helen,

You can map PF3 to ESC-:-w-q in vi.

etc.

You can store your key mappings in a .exrc file in your home directory. This is automatically read by vi for every edit. [...] 9366 24 27_UDB v5.2 --> v7.1 Migration17_Kevin Gottfredsen23_kgottfredsen@HUMANA.COM31_Wed, 30 Aug 2000 17:14:06 -0500568_- Does anybody know what changed in the system catalog between UDB v5.2 and v7.1 (NT)?

I ran the db2ckmig command and received several warnings stating that " references a system entity that has changed - this may affect the migration". The views listed in the warning messages were created by a purchased package and access SYSIBM tables (systables, syscolumns, and systabauth). I would like to look at the views and determine whether or not they will work after the migration, but need to know what changed in the system catalog to determine this. [...] 9391 51 24_Re: write enginesMessage15_Jim Lewandowski22_jlewand@STARNETINC.COM31_Wed, 30 Aug 2000 18:15:19 -0500582_us-ascii Didn't you get a copy of IOSPY for DB2 from me which can be used to help prove your case on DASD response to the appropriate groups? DSN-level I/O response times can be quite eye-opening vs. the SMF-averaged, typical 15-minute numbers.

Jim Lewandowski





Massimo Scarpa wrote: > > First of all, let me say how I appreciate your 'White Papers' in Responsive > System's Web site and your e-mails in DB2-l. > I started the study of BP tuning by reading your articles about BP and DASD > tuning, they are a real good guideline. > > And yes, I'm [...] 9443 41 43_Naming conventions for triggers, UDF and SP11_Suresh Sane21_data_arch@HOTMAIL.COM29_Wed, 30 Aug 2000 18:23:52 CDT392_- List memebers,

We are DB2 OS/390 V5, about to be V6. Would appreciate advice on some naming conventions.

For a specific platform xxx here is the proposal:

Triggers Ext UDF Ext SP SCHEMA xxxTRIG1 xxxEUDF1 xxxESTP1 OWNER xxxBINDT xxxBINDF xxxBINDS COLLID xxxTRIG1 xxxEUDF1 xxxESTP1 WLM ENV wlmenv1 wlmenv1 wlmenv1 NAME tbname + T01, program program tbname + T02 etc [...] 9485 31 24_CREATE STOGROUP QUESTION12_HARBRY ARIZA20_harbry_a@HOTMAIL.COM29_Wed, 30 Aug 2000 23:57:37 GMT601_- Hi folks:



Thanks for your comments in my previous questions but I've got another quick question. I used to use the statement CREATE STOGROUP VOLUMES ("*") to create our STOGROUP's and I never had problems before but recently I'm having problems with the allocations of tablespaces that wants grow (to do extents) in another volume. I've been reading the db2 admin guide and it seems to me that I have to alter my STOGROUP's and then specifie the clause VOLUMES('*','*','*','*'), that will allow me to extents my db2 datasets on four volumes. I just want your comments about it , [...] 9517 76 24_Re: write enginesMessage16_Duane Lee - ATCX22_DLee@MAIL.MARICOPA.GOV31_Wed, 30 Aug 2000 18:06:45 -0700564_- How does one get a copy of IOSPY?

> -----Original Message----- > From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > Sent: Wednesday, August 30, 2000 4:15 PM > To: DB2-L@RYCI.COM > Subject: Re: write enginesMessage > > Didn't you get a copy of IOSPY for DB2 from me which can be used to help > prove your case on DASD response to the appropriate groups? DSN-level > I/O response times can be quite eye-opening vs. the SMF-averaged, > typical 15-minute numbers. > > Jim Lewandowski > > > > Massimo Scarpa wrote: > > > > First of all, let me say how [...] 9594 48 31_Re: segmented to partitioned ts25_Sinha, Ranjay Kumar (CTS)24_SRanjay@CAL.CTS-CORP.COM31_Thu, 31 Aug 2000 09:43:01 +0530646_- Hi Greenman, Can u shed some light why u are converting segmented TS to partition tablespace. This may help me carry this sort of exercise at my installation also.

TIA

Regards Ranjay



-----Original Message----- From: Bud.Greenman@ONONDAGA.NY.US [SMTP:Bud.Greenman@ONONDAGA.NY.US] Sent: Wednesday, August 30, 2000 6:46 PM To: DB2-L@RYCI.COM Subject: segmented to partitioned ts

I need to convert a segmented ts to partitioned and move the current data into one of the partitions. Can I use a file from a full backup to reload with or do I need an UNLOADed file for the reload. We are on os390 r 5 and db2 [...] 9643 14 55_Daryl G Spletzer/Pr/Consumers/CMS is out of the office.16_Daryl G Spletzer24_dgspletzer@CMSENERGY.COM31_Thu, 31 Aug 2000 02:25:07 -0400365_us-ascii I will be out of the office from 08/30/2000 until 09/05/2000.

I will respond to your message when I return.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9658 109 47_Re: Naming conventions for triggers, UDF and SP14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 31 Aug 2000 17:29:00 +1100332_iso-8859-1 Why use lots of names?

What we do is:

In a given environment, names for the schema and owner are the same for triggers, UDFs, SPs and is the same as the table-creator id (of any unqualified used in the UDFs/SPs). This means that the BIND ... PATH option contains the same name as the QUALIFIER option. [...] 9768 58 28_Re: Stored procedure problem14_James Campbell29_James.Campbell@HANCORP.COM.AU31_Thu, 31 Aug 2000 17:42:29 +1100420_iso-8859-1 Martin,

Have you read the archives for the last week? We have just had what I think is exactly the same problem - although the symptoms related to a V6 UDF.

A literal character string is a VARCHAR, not a fixed length string - ie, it starts with a binary length.

/* standard disclaimer */ James Campbell DBA Hansen Corporation, Doncaster +61 3 9843 8442 James.Campbell@Hancorp.com.au [...] 9827 79 28_Re: CREATE STOGROUP QUESTION9_Andy Hunt33_Andy.Hunt@SCOTTISH-SOUTHERN.CO.UK31_Thu, 31 Aug 2000 07:58:38 +0100408_us-ascii Harbry, It depends what fix level you are on. Multiple "*" used to be allowed until UQ05560 (V4) and UQ05561 (V5) - see PQ01849. After this fix is applied, then you can only use one "*". If you are having problems extending your pagesets then I would go and wake up your Storage Managemet guys and ask them to look at their ACS routines. Kind Regards, Andy Hunt - Scottish And Southern Energy. [...] 9907 117 28_Re: CREATE STOGROUP QUESTION12_Allen, Colin31_Colin.Allen@ABBEYNATIONAL.CO.UK31_Thu, 31 Aug 2000 08:29:00 +0100375_- Although you CAN use multiple '*' prior to these fix levels it has never been necessary to do so. I have always used a single '*', if it doesn'twork, as Andy says, get your Storage Management guys to sort it out.

Colin Allen Abbey National ---------- From: Andy Hunt To: DB2-L@RYCI.COM Subject: Re: [DB2-L] CREATE STOGROUP QUESTION Date: 31 August 2000 07:58AM [...] 10025 348 25_Re: DB2 for OS/390 to UDB0_19_mike.holmans@BT.COM31_Thu, 31 Aug 2000 12:20:24 +0100682_iso-8859-1 edlin! edlin!

But if you really want a good editor, you need Ben Bradlee.

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

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

> -----Original Message----- > From: OConner, John [SMTP:John.OConner@COURTS.WA.GOV] > Sent: Wednesday, August 30, 2000 11:31 PM > To: DB2-L@RYCI.COM > Subject: Re: [DB2-L] DB2 for OS/390 to UDB > > What ever happened to TECO? Now there's a "peach" of an editor. > > -----Original Message----- > From: Higgins John [mailto:HigginsJohn@JOHNDEERE.COM] > Sent: Wednesday, August 30, 2000 12:45 PM > To: [...] 10374 11 31_Re: segmented to partitioned ts0_27_Bud.Greenman@ONONDAGA.NY.US31_Thu, 31 Aug 2000 08:05:42 -0400365_- I am doing this because the data is going to be loaded by year and it will be easier to maintain it as a partitioned ts .

================================================ 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. 10386 20 44_Oracle Heterogeneous Services to OS/390 DB2?11_Jim Medlock24_jmedlock@ALLIANCESYS.COM31_Thu, 31 Aug 2000 07:17:19 -0600 10407 23 48_Re: Oracle Heterogeneous Services to OS/390 DB2?14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 31 Aug 2000 08:24:14 -0400344_us-ascii Jim, when you are using ODBC to access DB2 for OS/390 you are either using DB2 Connect or some other product. DB2 Connect implements the DRDA protocol which is what DB2 understands. IF you are using ODBC and going against a DB2 UDB on NT, AIX you are just using the IBM ODBC driver and private protocol to DB2 on NT/AIX. HTH Phil [...] 10431 27 24_Coding Stored Procedures11_Maria Rossi18_marossi@US.IBM.COM31_Thu, 31 Aug 2000 07:39:17 -0500550_us-ascii Hi, List,

I have worked with Sybase. Now, we're switching to DB2. Currently, we have DB2 V5 for OS/390. At Sybase, we create stored procedures using the 'CREATE PROCEDURE' command and Transact-Sql. It has control flow (IF-ELSE), CASE statements, etc so we don't need a host language. I was told that we need a host language (such as Cobol, PL/1, C, or Rexx) to code DB2 stored procedures. Is this true? Is there something similar to T-SQL for DB2 (SQL Procedures Language perhaps??) so that we don't have to use a host language? [...] 10459 65 28_Re: Coding Stored Procedures15_Loria, Susan C.27_Susan_C_Loria@TVRATINGS.COM31_Thu, 31 Aug 2000 09:04:35 -0400531_iso-8859-1 Maria,

There are two available IBM redbooks on DB2 stored procedures:

* Getting Started with DB2 Stored Procedures: Give Them A Call through the Network # SG24-4693-01 * Developing Cross-Platform DB2 Stored Procedures: SQL Procedures and the DB2 Store Procedure Builder #SG24-5485-00

Both can be located at IBM Redbook website: http://www.redbooks.ibm.com in the search filed type in Stored Procedures and it will provide links to get directly to them. They are also located on IBM CDROMs too. [...] 10525 59 28_Re: Coding Stored Procedures12_Raj, Dominic25_DRaj@FALLSCHURCH.ESYS.COM31_Thu, 31 Aug 2000 09:05:57 -0400388_iso-8859-1 Maria,

As you mentioned you can use SQL Procedures if you have the right APARS on V5. YOU can use Stored Procedure Builder to Develop.

You also require REXX support ,WLM enabled SP region and C++ compiler on the host.

Please look into the redbook 'Developing Cross-Platform DB2 Stored Procedures : SQL Procedures and the DB2 Stored Procedure Builder' [...] 10585 24 28_Re: Coding Stored Procedures14_Philip Gunning18_pgunning@PHEAA.ORG31_Thu, 31 Aug 2000 09:11:21 -0400386_us-ascii Maria, In DB2 V6.1 IBM is providing a Stored Procedure Language consistent with Persistent Store Modules. It is very similar to Transact SQL and Oracle's PL SQL. IIBM has partnered with Mantech to provide a tool that will convert Sybase Stored Procedures to DB2 UDB Store procedures. The languages are very similar. Go to www.software.ibm.com/data/db2 for more info. Phil [...] 10610 51 28_Re: Coding Stored Procedures0_19_mike.holmans@BT.COM31_Thu, 31 Aug 2000 14:11:26 +0100342_- What you really want is DB2 V6, which contains the support for SQL/PSM stored procedures (the equivalent of T-SQL). It also gives you the ability to CREATE PROCEDURE, whereas at V5 you still have to go through all the palaver of inserting rows into SYSIBM.SYSPROCEDURES.

Mike Holmans BT ISE Technical Design mike.holmans@bt.com [...] 10662 77 96_Re: IMAGE COPY UTILITY - Determining number of copied pages per t able space (DB2 for OS/390 V5)19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 31 Aug 2000 08:14:36 -0500345_iso-8859-1 Georg, NACTIVE in SYSIBM.SYSTABLESPACE could be used with the two following caveats: 1) the accuracy depends on RUNSTATS updating it and, 2) the count includes empty pre-formatted pages created by either the LOAD utility or DB2 pre-formatting. It might help if we knew why, when, etc. you need this data and how it will be used. [...] 10740 60 28_Re: Coding Stored Procedures11_Suresh Sane21_data_arch@HOTMAIL.COM29_Thu, 31 Aug 2000 08:18:26 CDT485_- Maria:

1. In V5, there is no CREATE PROCEDURE but you need to manually insert a row in SYSPROCEDURES. The procedure is called an external procedure and it needs to be in a host laguage. 2. In V6 you use the ddl form - CREATE PROCEDURE. 3. In V6 (or in V5 with proper APARs), the sql procedure is available that allow more logic to be coded there. I think it is still limited in terms of functionality so you may end up having to write an external procedure, in any case. [...] 10801 102 24_Re: write enginesMessage23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Thu, 31 Aug 2000 14:51:58 +0100688_iso-8859-1 indeed ... how .. sounds interesting.

Leslie

-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Thursday, August 31, 2000 2:07 AM To: DB2-L@RYCI.COM Subject: Re: write enginesMessage



How does one get a copy of IOSPY?

> -----Original Message----- > From: Jim Lewandowski [SMTP:jlewand@STARNETINC.COM] > Sent: Wednesday, August 30, 2000 4:15 PM > To: DB2-L@RYCI.COM > Subject: Re: write enginesMessage > > Didn't you get a copy of IOSPY for DB2 from me which can be used to help > prove your case on DASD response to the appropriate groups? DSN-level > I/O response times can be quite eye-opening vs. [...] 10904 66 33_Re: I/O support for DB2 Utilities14_Larry D Bolick24_ldbolick@DUKE-ENERGY.COM31_Thu, 31 Aug 2000 10:06:35 -0400666_us-ascii You can eliminate the use of SYSUT1 and SORTOUT datasets for REORG and LOAD by using the SORTKEYS parameter (V5). However, restart is limited because no data is written to SYSUT1 and SORTOUT.

Regards, Dean Bolick



|--------+---------------------------------> | | MARTIN WOLFF | | | | | | | | | 08/30/00 11:07 AM | | | Please respond to DB2 | | | Data Base Discussion | | | List | | | | |--------+---------------------------------> >--------------------------------------------------------| | | | To: DB2-L@RYCI.COM | | cc: | | bcc: Larry D Bolick/Corp/DukePower | | Subject: I/O support for [...] 10971 32 51_Re: A question about datasharing & group bufferpool14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 31 Aug 2000 16:55:56 +0100600_us-ascii Hi Chris and thanks for you reply.

We are doing a big effort to improve our datasharing environment and for this reason we are collecting all available information. Our environment is rapidly growing and this is the right time to do tuning. It's important for us to work with MVS sysprog and to explain our needs, but sometimes there are differents points of view. They prefere to have a simple CFRM policy, but we need something different and a little bit complicated. Luckily our situation is becoming clear, our database are well defined (all RW interest), our BPs tuning has [...] 11004 33 52_SQL Stored Procedure Problem (returning result sets)10_Ozan VAKAR19_ovakar@32BIT.COM.TR31_Thu, 31 Aug 2000 18:11:44 +0300483_iso-8859-9 Hello List,

I'm using DB2 UDB V7.1 on NT My problem is : When I return a result set from a stored procedure, field names appear to be 1,2,3,... in the client application. Is anyone able to return field names ?

Thanks a lot.

A typical test proc is :

CREATE PROCEDURE TestProc () LANGUAGE SQL MODIFIES SQL DATA DYNAMIC RESULT SETS 1 PROC_BODY: BEGIN DECLARE qryData CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM TESTTABLE OPEN qryData; END [...] 11038 137 24_Re: write enginesMessage11_Jerry, Jeff27_Jeff.D.Jerry@WELLSFARGO.COM31_Thu, 31 Aug 2000 10:12:36 -0500546_iso-8859-1 This is of interest to me as well. I would like to know where I could get a copy as well.

-----Original Message----- From: Pendlebury-Bowe, Leslie [SMTP:Leslie.Pendlebury-Bowe@EU.SONY.COM] Sent: Thursday, August 31, 2000 8:52 AM To: DB2-L@RYCI.COM Subject: Re: write enginesMessage

indeed ... how .. sounds interesting.

Leslie

-----Original Message----- From: Duane Lee - ATCX [mailto:DLee@MAIL.MARICOPA.GOV] Sent: Thursday, August 31, 2000 2:07 AM To: DB2-L@RYCI.COM Subject: Re: write enginesMessage [...] 11176 16 24_Re: write enginesMessage14_Massimo Scarpa23_Massimo_Scarpa@DEBIS.IT31_Thu, 31 Aug 2000 17:22:51 +0100333_us-ascii Yes Jim, and it works well....!!!

Tanks again and regards

Max Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11193 92 41_Re: DB2 UDB Mission Critical Applications13_Jim Wankowski23_jim.wankowski@QUEST.COM31_Thu, 31 Aug 2000 11:44:54 -0500640_- On Wed, 30 Aug 2000 11:51:09 +0100, Philip Nelson wrote:

>Anil, > >We use DB2 UDB (AIX) for two mission critical applications within our organisation - one for processing mortgage applications, the other for call centre workflow >management (approx 700 clients). > >Developers simply use Visual Basic. As DBAs we use Perl scripts and are currently looking at the Embarcadero DBA toolset (DBArtisan etc.). > >Phil > >On Tue, 29 Aug 2000 17:11:16 EDT, Usregion10@AOL.COM wrote: > >>Hi all! >> >>In the past, I have always worked at clients where all the mission critical applications with done using DB2 [...] 11286 118 62_Modifying code or sql to solve PeopleSoft Performance problems18_Gray, Gary R - CFC18_Gray.Gary@CFWY.COM31_Thu, 31 Aug 2000 10:59:47 -0700591_iso-8859-1 List, I would like to get comments from other shops who have PeopleSoft applications running DB2 on MVS OS/390 as the database platform. We have been running PeopleSoft HRMS and Financials, version 7 for a year and a half now. During this time, we have found numerous performance problems, mainly with batch jobs. The dba staff has done the majority of the tuning, with index tuning being the main solution most of the time. We did some tuning of bufferpools, but didn't see a significant gain. We are very current with the db2 upgrades for version 5 (including some patches [...] 11405 15 21_Datajoiner and Sybase0_24_db46@DAIMLERCHRYSLER.COM31_Thu, 31 Aug 2000 14:13:05 -0400389_us-ascii Okay, I have the following problem. Can datajoiner be used to extract information from Sybase tables stored on a local server?

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. 11421 22 31_Visual Explain for db 0s/390 v610_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 31 Aug 2000 14:23:33 -0400512_us-ascii Hi all

I just downloaded visual explain for db2 os/390 V6 and have a question. Under what circumstances will "Cost Milliseconds" and "Cost Service Units" get filled in



How do you report problems to visual explain support



Tom

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 11444 18 66_Re: Modifying code or sql to solve PeopleSoft Performance problems19_Donald A. Smith, JR18_dsmithj@US.IBM.COM31_Thu, 31 Aug 2000 14:29:19 -0400487_us-ascii You need to establish a position in your organization that deals specifically with performance problems and can put a dollar cost on the existing problem and present the cost involved to management. This would get some action fast. Some type of cost/benefit analysis could be done. At that point, the bad SQL code gets fixed or the company will live with the expense associated with the performance problem. Money is important to management so something will get done. Don [...] 11463 39 66_Re: Any experiences with IBM SNAPSHOT and CONCURRENT COPY for DB2?19_Jaiwant K. Jonathan25_jkjonath@DOAS.STATE.GA.US31_Thu, 31 Aug 2000 13:17:19 -0500640_- On Tue, 29 Aug 2000 10:53:03 -0400, Donald A. Smith, JR wrote:

Don, Please be aware that DSN1COPY, DSN1COMP and DSN1PRNT will not work with concurrent copy datasets.

...Jaiwant



>To DB2 DBA's: > Has anyone had any experience with the IBM SNAPSHOT product? It has >been advertised for a while as a product for creating fast back up copies >of VSAM cluster's underlying DB2 objects. I see a problem in that all >recoveries would have to be done OUTSIDE of DB2 thus negating the features >of DB2 RECOVERY and the DB2 product itself (logging features, >SYSIBM.SYSCOPY table keeping track [...] 11503 60 67_Re: Modifying code or sql to solve PeopleSoft Performance problem s13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 31 Aug 2000 13:28:47 -0500306_iso-8859-1 I have no answer for your specific question, but version 8.1 of PeopleSoft is out now/soon. You may want to evaluate how much effort you want to spend tuning V7.x if your site has plans to move to V8.1 soon. I think V8 will be a new ball game and may make some of the V7.x effort obsolete. [...] 11564 136 67_Re: Modifying code or sql to solve PeopleSoft Performance problem s18_Gray, Gary R - CFC18_Gray.Gary@CFWY.COM31_Thu, 31 Aug 2000 11:46:09 -0700534_iso-8859-1 Don, That's the strategy our group is using. We have identified the 15 worst performing jobs, and how much it's costing the company. Our costs are not just "accounting costs". We contract with a service provider for machine resources, so cpu cost is very real! The problem is that we can't get the applications group to budge from their position of not changing code. If I could show them a precedent for other shops considering this (changing sql or code) as an option, it might move them off their current position. [...] 11701 240 67_Re: Modifying code or sql to solve PeopleSoft Performance problem s18_Gray, Gary R - CFC18_Gray.Gary@CFWY.COM31_Thu, 31 Aug 2000 11:50:44 -0700424_iso-8859-1 Glenn, I appreciate this comment. However, I don't know that we will be going to version 8 any time soon. Plus, I would like have applications consider this option of changing code or sql regardless of what version we end up with. But yes, work we have done so far will have to be evaluated in any future release. I'm inticipating that version 8 will improve some areas, but not all (just a guess, however). [...] 11942 41 25_Re: Datajoiner and Sybase24_The Fillmore Group, Inc.18_fillmore@CLARK.NET31_Thu, 31 Aug 2000 14:58:00 -0700658_us-ascii Dean, Yes, no problem. DataJoiner uses the native Sybase client software, Sybase OpenClient, to attach to a server. Anything OpenClient can talk to, DataJoiner can talk to.

Frank

On Thu, 31 Aug 2000 14:13:05 -0400, db46@DAIMLERCHRYSLER.COM wrote:

>Okay, I have the following problem. Can datajoiner be used to extract >information from Sybase tables stored on a local server? > >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. [...] 11984 39 35_Re: Visual Explain for db 0s/390 v68_Dan Tuck18_dan_tuck@YAHOO.COM31_Thu, 31 Aug 2000 12:11:22 -0700614_us-ascii Those columns do not show for version 5 plan_tables.

--- Tom Taylor wrote: > Hi all > > I just downloaded visual explain for db2 os/390 V6 > and have a question. Under > what circumstances will "Cost Milliseconds" and > "Cost Service Units" get filled > in > > > How do you report problems to visual explain support > > > Tom > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The owners of the list > can be reached at DB2-L-REQUEST@RYCI.COM. [...] 12024 64 66_Re: Modifying code or sql to solve PeopleSoft Performance problems12_craig patton21_prgpatton@HOTMAIL.COM29_Thu, 31 Aug 2000 19:07:20 GMT 12089 79 35_Re: Visual Explain for db 0s/390 v610_Tom Taylor17_ttaylor@CHUBB.COM31_Thu, 31 Aug 2000 15:12:10 -0400834_us-ascii how about v6 and/or v7 ?















Dan Tuck on 08/31/2000 03:11:22 PM

Please respond to DB2 Data Base Discussion List















To: DB2-L@RYCI.COM

cc: (bcc: Thomas G Taylor/ChubbMail)





Subject: Re: Visual Explain for db 0s/390 v6















Those columns do not show for version 5 plan_tables.

--- Tom Taylor wrote: > Hi all > > I just downloaded visual explain for db2 os/390 V6 > and have a question. Under > what circumstances will "Cost Milliseconds" and > "Cost Service Units" get filled > in > > > How do you report problems to visual explain support > > [...] 12169 287 66_Re: Modifying code or sql to solve PeopleSoft Performance problems14_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Thu, 31 Aug 2000 15:16:52 -0400579_iso-8859-1 Gary:

Let me give you an example of a typical Peoplesoft SQL that you would have to re-write to get any performance improvement:

select col1,..... from a million_row_table a (typically PS_JRNL_LN) where exists( select '1' from one_row_table (or a small table, typically PS_JRNL_LN_TMP) b where b.keys = a.keys)

No matter what tuning you do , DB2 is going to do a tablespace scan on the million row table and match against the one_row_table. This query can run from several seconds to few minutes depending on how huge your million row table. [...] 12457 27 27_Delaying Archive Log Copies0_21_ANTHONY_ZOLNA@QVC.COM31_Thu, 31 Aug 2000 15:20:28 -0400582_us-ascii Hello list, We are upgrading our tape units on Monday and are preparing for an 8 hour outage from using our tape drives. My question is, will DB2 activity stop when switching to new active logs if there are no tape drives available for the archiving process. I was under the impression that we could use all active log files but let the mount messages accumulate until tape drives became available as long as we had enough active logs allocated. We have provided 8 active log datasets large enough to cover this time frame. We had many resource unavailable conditions [...] 12485 67 31_Re: Delaying Archive Log Copies19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 31 Aug 2000 14:41:46 -0500560_iso-8859-1 Tony, I think your plan would work if everything goes as planned. Remember, when DB2 fills the last available log all activity is suspended until a successful archive is done. I'd make sure I knew what was going to run during the 8 hour period to ensure nothing ran that would tend to cause extra active log records to be written. You didn't mention your DB2 Version. I'd test the situation if you can, maybe on some test subsystem, by vary offline all the drives and see what kind of messages and the required replies to expect. Its been some [...] 12553 50 31_Re: Delaying Archive Log Copies19_DAVIS, RICK (SBCSI)21_RD8246@MOMAIL.SBC.COM31_Thu, 31 Aug 2000 14:49:37 -0500634_iso-8859-1 Whoever is sending out the following message in response to posts from the DB2-L listserver, please stop.

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 [...] 12604 37 31_Re: Delaying Archive Log Copies13_john arbogast19_arbo@CP-DEMO.CP.NET31_Thu, 31 Aug 2000 12:52:10 -0700492_- DB2 won't stop unless you run out of ACTIVE logs. I have seen tape problems cause archiving delays for hours. Almost enough to fill our active logs! Be aware you might have to issue the cancel offload command to resume archiving when you bring your new tape units online. I say this because I have seen DB2 request a mount on a silo that was having problems and then just sit and wait. Varying the device offline then issuing the cancel offload command got the archives rolling again. [...] 12642 38 36_Fwd: RE: Delaying Archive Log Copies13_john arbogast19_arbo@CP-DEMO.CP.NET31_Thu, 31 Aug 2000 12:56:28 -0700634_- Yes, please stop this. ------- Start of forwarded message -------

Subject: RE: Delaying Archive Log Copies To: john arbogast From: MSDW AutoReply Date: Thu, 31 Aug 2000 16:04:14 -0400

This is an auto-generated system message. Please do not reply to this address.

*** E-Mail Acknowledgment/Important Notice *** Receipt of this acknowledgment confirms that the e-mail message you sent to an employee of Morgan Stanley Dean Witter has been received. Please be advised, however, that it is not an indication that the message was opened and read by the recipient. [...] 12681 66 31_Re: Delaying Archive Log Copies17_Snoeyenbos, Craig35_Craig.Snoeyenbos@STARWOODHOTELS.COM31_Thu, 31 Aug 2000 16:08:51 -0400432_iso-8859-1 I've had the "pleasure" of watching a DB2 system lock itself at 100% due to silo issues under V3 without the cancel command. (Normal IPL scheduled for 03:00 Sunday, DB2 filled at about 01:45.) No other problems due to letting it fill.

In Anthony's case, I'd recommend haveing the operators reply no to the mount requests and then just issueing a normal archive command as soon as the new tapes are available. [...] 12748 744 67_Re: Modifying code or sql to solve PeopleSoft Performance problem s12_HEPP SHERY C17_schepp@SRPNET.COM31_Thu, 31 Aug 2000 13:14:12 -0700569_ISO-8859-1 Gary-

Brian Holroyd has published whitepapers on performance tuning for peoplesoft on db2 os/390. You should be able to find them out on customer connection. He also was holding a 2 day peoplesoft performance tuning for db2 os/390 seminar. I attended it last January and one thing he said was "80% of the performance gains is in is in tuning <5% of the SQL 90% of those 5% can be tuned without changes to the SQL." We're v 7.5 financials and when we first implemented our mips tripled. By applying some of his suggestions we were able to get our [...] 13493 58 19_move DB2 v4.1 to v619_Lisa Westcott-Dryer32_lisa_westcott_dryer@FOREMOST.COM31_Thu, 31 Aug 2000 16:25:39 -0400302_iso-8859-1 Hello, I'm on MVS r2v4 and DB2 v4.1 and would like to know can I directly move to v6? Or do I have to move to 5 first? I understand there will be issues with the stored procedures, optimizer etc.

Lisa Westcott-Dryer Database Administration Foremost Insurance 616 956 2805 cel 490 3380 13552 74 23_Re: move DB2 v4.1 to v60_22_BILL_GALLAGHER@PHL.COM31_Thu, 31 Aug 2000 16:40:34 -0400433_iso-8859-1 Lisa,

You have to move to v5 before you can go to v6. The only release that I'm aware of that IBM is letting you skip is the move from v5 to v7.

Bill Gallagher, DBA Phoenix Home Life Enfield, CT 06083 (860) 403-1773





Lisa Westcott-Dryer cc: Sent by: DB2 Data Base Subject: move DB2 v4.1 to v6 Discussion List [...] 13627 42 34_JAVA, DB2 and varchar/fixed length13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Thu, 31 Aug 2000 15:49:29 -0500323_iso-8859-1 Hi,

We have an issue with JAVA programs accessing DB2 which returns CHAR data padded to the length as defined in the catalog. Also, when shipping data to DB2 (insert, where predicates, Stored procedure parameters etc) from JAVA the data is not padded with blanks and the results are not as expected. [...] 13670 36 23_Re: move DB2 v4.1 to v69_Jim Jones33_Jim.Jones@INGRAMENTERTAINMENT.COM31_Thu, 31 Aug 2000 15:42:18 -0500405_iso-8859-1 No shortcut with DB2 OS/390, V4 to V5 to V6. We were okay with our SP, but had plenty of optimizer issues, bugs and performance problems with joins.

Jim Jones Sr. DBA Ingram Entertainment Inc

-----Original Message----- From: Lisa Westcott-Dryer [mailto:lisa_westcott_dryer@FOREMOST.COM] Sent: Thursday, August 31, 2000 3:26 PM To: DB2-L@RYCI.COM Subject: move DB2 v4.1 to v6 [...] 13707 33 29_check data control statements16_Alison Pelletier26_alison_pelletier@YAHOO.COM31_Thu, 31 Aug 2000 14:01:23 -0700542_us-ascii I need to create control statements for "check data tablespace" with "for exception in" parameter. I believe I need a recursive sql statement(s) to SYSRELS joined to TABLES and TABLEPART. I was successful somewhat, but it only returns one level deep of dependents.

Does anyone have a process already to do what I need? I'd like to furnish the database or creator and get all tablespaces that have checkflag = 'c' along with their dependents and their dependents, etc. I can file tailor the control statements from there. [...] 13741 35 26_UDB 7.1 Instance Migration9_Jim Jones33_Jim.Jones@INGRAMENTERTAINMENT.COM31_Thu, 31 Aug 2000 16:43:24 -0500505_iso-8859-1 After installation of DB2 UDB 7.1 on Linux, I ran the db2imigr command to migrate a 6.1 instance. After migration, remote clients can't connect, although local clients can. The v6.1 instance did not use default port 50000, and the db2icrt command that db2imigr issued used the default port. That port is in use by another instance, so I prefer to use the port that I defined in V6. DBM CFG and /etc/services point to the correct port of 50008. The only way I can think to redo this is to: [...] 13777 39 54_Employment Opportunities for DB2 Systems Programmer(s)10_Maria Shum28_maria.shum@BANKOFAMERICA.COM31_Thu, 31 Aug 2000 18:46:06 -0400418_us-ascii Employment opportunities !

Two DB2 Systems Programmer (full time) positions available at Bank of America.

If you have DB2 Systems Programming experience with - installation of DB2 UDB for OS/390 (V5 & V6) - Data Sharing - DB2 PM - Omegamon - system performance and tuning

and interested in working at one of these locations: Richmond, Virginia, Richardson, Texas Concord, California [...] 13817 28 12_udb instance0_18_Usregion10@AOL.COM29_Thu, 31 Aug 2000 18:56:30 EDT341_ISO-8859-1 Hi all!

We just the initial install of UDB. It created two instances db2as and websphere. Now,

1. Do I create a new instance before I start creating my test databases or do I work with one of the intially created instances.

2. How and why is db2as used anyways ?

Looking forward to hear from you. [...] 13846 56 16_Re: udb instance9_Jim Jones33_Jim.Jones@INGRAMENTERTAINMENT.COM31_Thu, 31 Aug 2000 18:07:26 -0500489_iso-8859-1 Anil,

1. Create another instance for test database by either running db2setup again selecting the create instance option only, or use the db2icrt command.

2. DB2AS is the admin services instance, used for remote administration with DB2 Control Center, Client Configuration Assistant, etc.

HTH, Jim Jones Database Administrator Ingram Entertainment Inc. IBM Certified Solutions Expert DB2 UDB Administration Distributed Relational Database Architecture [...] 13903 89 13_DB2 SQL codes14_Ashish Mahajan25_blue_sky@WORLDNET.ATT.NET31_Thu, 31 Aug 2000 19:09:56 -0600513_iso-8859-1 Hi!

I am writing this note from beautiful Denver, Colorado. I joined this list just a few minutes ago, in hopes of establishing communication with the DB2 user community. I teach a database course in an e-commerce/IT program here in Denver. One of my former students posed a question today via email. Her original email and my response are posted below. I would love to hear any responses on this thread. I will learn something and hopefully I can pass that on to my students. Thanks much! [...] 13993 63 27_DSNL512I : DDF CANNOT START10_Michale Yu19_yubin@MAIL.DCAC.COM30_Fri, 1 Sep 2000 11:09:14 +0800593_iso-8859-1 I have started DRDA and conected to DB2 for OS/390 from WINDOWS through SNA; now I try to do the same thing through TCPIP.

I have completed most of the customization according to IBM's document, but I cannot start DDF correctly when I issue command follow: -DSN1 START DDF DSNL021I -DSN1 START DDF COMMAND ACCEPTED DSNL003I -DSN1 DDF IS STARTING DSNL512I -DSN1 DSNLILNR TCP/IP GETHOSTID FAILED WITH 624 RETURN CODE=134 AND REASON CODE=110A0216 DSNL004I -DSN1 DDF START COMPLETE 625 LOCATION WHGL0001 LU DCAC.NYM2DB2 GENERICLU -NONE DOMAIN -NONE TCPPORT 446 RESPORT 5001 [...] 14057 119 17_Re: DB2 SQL codes17_Andrew Karandjeff17_eak3rd@SWBELL.NET31_Thu, 31 Aug 2000 22:45:56 -0500619_iso-8859-1 0 - good return 100 - no row found 803 - dupe row 805 - bad bind on dbrm package or plan 904 - resource unavailable

----- Original Message ----- From: "Ashish Mahajan" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, August 31, 2000 8:09 PM Subject: DB2 SQL codes



> Hi! > > I am writing this note from beautiful Denver, Colorado. I joined this list > just a few minutes ago, in hopes of establishing communication with the DB2 > user community. I teach a database course in an e-commerce/IT program here > in Denver. One of my former [...]