1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l April 2002, week 3 2 13 28_Re: DB2 OS/390 & UDB on UNIX10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 15 Apr 2002 08:40:11 +0200335_us-ascii Ok milk and eggs.....then you've to beat them for .....and what about cooking time ?

================================================ 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. 16 15 48_Kevin Mulcahy/GA/CheckFree is out of the office.0_22_KMulcahy@CHECKFREE.COM31_Mon, 15 Apr 2002 03:01:08 -0400389_us-ascii I will be out of the office starting 04/15/2002 and will not return until 04/22/2002.

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. 32 117 56_Re: Faltering at first step in UDB/Linux installation...14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 15 Apr 2002 09:24:26 +0100806_iso-8859-1 Have you read the Quick Beginnings manual? Click here: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document .d2w/report?fn=db2v7i4frm3toc.htm for the html, or here ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2i4e70.pdf for the acrobat file.

Make sure you have the pdksh package installed for ksh support.

Marcus



----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 150 54 28_Re: DB2 OS/390 & UDB on UNIX10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 15 Apr 2002 11:45:58 +0200321_us-ascii HI Cathy

I agree with you. I'm told that in Italy the main cause of mainframe decrese is the high cost of software (mainframe HW is 'cheap' nowadays even for IBM products) and this maybe true but I think that IBM could decrease the prices if this should be the main problem as it happened for DASDs. [...] 205 70 56_Re: Faltering at first step in UDB/Linux installation...19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Mon, 15 Apr 2002 11:49:54 +0100567_- Didn't catch your first note, but you should also check out the DB2-HOWTO from http://www.linuxdoc.org for some "gotchas".

The problems you will have will depend on which specific version of Linux you are running. If it is Red Hat 7.2 as well as needing the pdksh package installed (it isn't by default) you also will need to create a logical link for one of the base system libraries (can't remember off the top of my head which one, but the install fails saying it can't find lib*.version, and you need to create a link from this to the version which [...] 276 27 78_RC/Migrator: How can I have WHERE predicates automatically inserted for tables11_Linda Ayeni22_lindaayeni@HOTMAIL.COM31_Mon, 15 Apr 2002 02:53:36 -0700464_- Dear Listers, I have to migrate data for a lot of tables using RC/Migrator and I am wondering if there is an easier way to have a given WHERE clause and associated predicates automatically inserted for each table selected during the Strategy/Analysis phase. Currently, I have had to manually insert my WHERE clauses after the Analysis phase has completed and before executing the result through the Batch Processor. Any help will be appreciated and thanks. [...] 304 51 22_Re: Schema name in DB214_Richard Ruppel18_r_ruppel@YAHOO.COM31_Mon, 15 Apr 2002 04:00:33 -0700355_us-ascii Priya,

You will need an additional piece of software to make the connection from DB2 to Oracle.

To get from Oracle to DB2, we currently use an Oracle synonym and a DB Link pointing to DB2 (using Oracle's Gateway for OS/390). The Gateway product only allows data to move one way, Oracle to DB2 (calls must be made from Oracle). [...] 356 29 24_DB2 OS/390 & UDB on UNIX13_Kathy Czepiel30_KathleenCzepiel@GROCERYBIZ.COM31_Mon, 15 Apr 2002 07:41:19 -0500578_us-ascii Like many older established shops our "life blood" systems run on a mainframe. Third party vendor costs are causing a general hardening of the arteries when the time comes for processor upgrades and subsequent heart attacks when the bill comes due. MIP pricing would be a benefit but we are not there yet. In the past mainframe software was extremely robust and reliable so we could almost agree that the cost increase was worthwhile. Our UNIX software on the other hand was cheap and whatever problems would be fixed in release xx or yy or zz and for some reason [...] 386 24 18_IN LIST processing13_Wolfgang Hini35_letterbox@HIPERFORMANCE-SOFTWARE.DE31_Mon, 15 Apr 2002 07:12:59 -0500452_ISO-8859-1 Hallo,

can anybody tell me how DB2 processes an IN LIST predicate: 1. Are the IN LIST Variables sorted before evaluation? 2. Are duplicate values evaluated only once? 3. If I have an IN LIST with 500 Values in a static SQL, but only 100 different values, should I move the highest value of the given values to the leaving rest of 400 values in the list, or an ‘impossible’ value, or the lowest value to these ‘not used ‘ values? [...] 411 36 32_Re: What ERLY code am I running?14_DAVID PETERSEN27_dpetersen@KEYSPANENERGY.COM31_Mon, 15 Apr 2002 09:02:48 -0400560_us-ascii Raymond,

Why did you choose to go from v5 to v7? Any insight into this decsision would be appreciated as we are in the same situation.

Thanks, Dave Petersen

Raymond Bell wrote:

> Colleagues, > > I'm in the process of preparing to migrate from DB2 for OS/390 V5 to V7. > One of the steps is installing the V7 ERLY code. I think I've done it > (SYS1.DSN.LINKLIB's in the link list and we've IPL'd, and the 3 modules > involved are definitely different) but I was wondering if there's anything > I can do to ask DB2 what [...] 448 100 22_Re: Schema name in DB214_Manas Dasgupta25_manas.dasgupta@PFSFHQ.COM31_Mon, 15 Apr 2002 09:08:24 -0400546_iso-8859-1 Priya:

DB2 does not have PUBLIC SYNONYM. One way to avoid specifying the schema name is to use "SET CURRENT SQLID/SCHEMA".

Manas. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Priya Sent: Saturday, April 13, 2002 4:38 AM To: DB2-L@RYCI.COM Subject: Schema name in DB2



Is there any way of implementing public synonyms of Oracle in DB2..I tried using aliases..But again you need to specify the schema name along with the aliases ..so that din't help [...] 549 46 32_Re: What ERLY code am I running?11_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Mon, 15 Apr 2002 08:25:04 -0500342_US-ASCII Run Diagnose utility with the statement DIAGNOSE DISPLAY MEPL. In the character display to the right search on DSN3EPX. Also browse your SYS1.DSN.LINKLIB. Compare the dates and ptfs for each module in the listing and in the library. If they match, it is a good bet that DB2 is running with the modules in that linklist library. [...] 596 51 82_Re: RC/Migrator: How can I have WHERE predicates automatically inserted for tables5_chris22_hhardy1@HOUSTON.RR.COM31_Mon, 15 Apr 2002 08:18:39 -0500493_iso-8859-1 Not sure, its been a little bit, but was there a Copy Group or something like a copybook function???

I'm in left field... I could be mixed up with another product....

chris hardy, managing partner



----- Original Message ----- From: "Linda Ayeni" Newsgroups: bit.listserv.db2-l To: Sent: Monday, April 15, 2002 4:53 AM Subject: RC/Migrator: How can I have WHERE predicates automatically inserted for tables [...] 648 158 28_Long Varchar using MS Access11_Brazil, Pat27_PBrazil@MIDATLANTIC.AAA.COM31_Mon, 15 Apr 2002 09:16:28 -0400148_- Is it possible to read a long varchar from DB2 for OS/390 using MS Access? How about updating the same using MS Access?

Thanks, Pat

807 60 33_Re: LOAD DATA on DB2 ON MAINFRAME5_Priya17_deswalp@YAHOO.COM31_Mon, 15 Apr 2002 19:01:03 +0530567_iso-8859-1 Thanks for all the useful Inputs.

I have summarized following methods to load data from DB2 on Unix to DB2 on Mainframe.

I just wanted to know what would be the performance Statistics for inserting 1 million rows if I use

1. A java program to insert rows.(Is there a big performance overhead as compared to LOAD utility). 2.Use DB2 new feature Cross loader utility. 3.Initiate LOAD on mainframe itself after sending the file from Unix box to mainframe. 4.Replication from DB2 on Unix to DB2 on Mainframe using DB2 data propagator [...] 868 120 28_Re: DB2 OS/390 & UDB on UNIX15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 15 Apr 2002 09:56:43 -0400612_- Based on my observations, this is what I think the problem of migrating companies from Mainframe. I am learning SQLserver (look at the DTS capabilities, DB2 will charge separately for that) also as a backup and also some web development languages.

1. The difficulties to implement new functionality in OS/390 or Lack of functionality. Eg. a. E-mail facility from OS/390. I know there is some freeware, but how may companies are willing to install freeware on there production system. This should be activated as part of OS. Also we should allow other features of e-mail. b. Limited to green screen [...] 989 95 0_5_Priya17_deswalp@YAHOO.COM31_Mon, 15 Apr 2002 19:47:14 +0530348_iso-8859-1 Hi Manfred

To overcome the problem of removing differences between the file load structures,i came about to read something about DB2 Cross Loader..which loads data across all db2 platforms.It seems to be quite easy and reliable...But I am not sure about the performace impacts that it will have as compared to direct loading [...] 1085 55 16_DB2 Cross Loader5_Priya17_deswalp@YAHOO.COM31_Mon, 15 Apr 2002 19:49:53 +0530234_iso-8859-1 Has anyone got to work with DB2 Cross Loader ?? I am looking for its performace statistics as comapred to Direct DB2 load ..I want to transfer data from DB2 on Unix to DB2 on Mainframe at certain scheduled time Thanks Priya 1141 79 32_Re: What ERLY code am I running?11_Hayden, Lee18_Lee_Hayden@CSX.COM31_Mon, 15 Apr 2002 10:31:33 -0400332_iso-8859-1 Raymond,

I use the PDS shareware utility (www.cbttape.org). This will show the PTF that is applied on the modules. Below is a sample. Another way to get this same information is to use AMBLIST. DSN3EPX is the "active" module for changes and either of these methods will get you the PTF numbers in the module. [...] 1221 34 28_Re: DB2 OS/390 & UDB on UNIX0_19_Tim.Lowe@STPAUL.COM31_Mon, 15 Apr 2002 09:45:00 -0500583_us-ascii I think that a big problem is that there seems to be a natural tendency among people to fix problems by buying a new tool (rather than fix the existing tool). Several times, I have seen companies purchase new products to solve existing problems, only to have new, and even bigger problems with the new software. (in some cases, the new software does not even fix the existing problem!) It is pure politics at it's worst. New tools may cost hundreds of thousands of dollars, but often include "free" training. And, they come with "promises" from salesmen that they will [...] 1256 61 22_Re: IN LIST processing13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 15 Apr 2002 09:50:07 -0500389_iso-8859-1 Wolgang,

This is based on testing I performed on a P390 server running DB2 V6. I was able to get predictable results because I am the only user.

Answers: 1. No 2. If matched yes (first match causes an "early-out"), otherwise duplicates are checked multiple times. 3. You should code your in list in such a way that you will find a match as early as possible. [...] 1318 32 82_Plain-text password file for apply program in replication configuration: security?13_Igor Yakushin20_igory_1999@YAHOO.COM31_Mon, 15 Apr 2002 07:50:42 -0700425_us-ascii Hi everybody, I am rather concerned that when one configures a replication environment in DB2, one must provide a plain-text password file for the apply program to run. It looks very risky to me as far as security is concerned. Any good alternatives? If one uses SERVER_ENCRYPT authentication, one still has to provide unencrypted password in a plain-text file? What about Kerberos authentication? Thanks, Igor [...] 1351 112 27_Re: db2look,db2evmon errors14_Swamy Kanathur24_swamy.kanathur@QUEST.COM31_Mon, 15 Apr 2002 08:20:12 -0700454_iso-8859-1



Hi Ravi,

I assume that you are logged as instance owner.Make sure that the db2profile which is in the sqllib directory of the instance is sourced. Also run env to make sure that DB2INSTANCE,LIBPATH and PATH variables are right. Also can you let me whether you have V7.2 or V7.1 FP3 and give me a byte count of db2look and db2evmon executables. I have V7.1 FP3 and V7.1 FP6 and these work. I have pasted the output. [...] 1464 31 34_Question about transitive closure.0_25_George_White@VANGUARD.COM31_Mon, 15 Apr 2002 11:26:59 -0400383_us-ascii Hi,

I have a question regarding query rewrite in terms of transitive closure.

I have an SQL statement that contains a single host variable for two different tables. I was expecting a cartesian product, but instead saw a join between the two tables.

Given this example, can anyone verify that DB2 will rewrite the SQL statement to be an inner join? [...] 1496 16 33_Re: LOAD DATA on DB2 ON MAINFRAME12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 15 Apr 2002 10:17:29 -0500300_- If you want a job running under batch controls, then the task is JCL to a reader and output from queues, with little that's unique for DB2.

If you want to run the utility and wait for the return, then I suggest you check the DSNUTILS stored procedure.

Roger Miller, DB2 for z/OS [...] 1513 22 22_Re: RACF authorization12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 15 Apr 2002 10:25:30 -0500421_- I think my latest one is on the DB2 Support page.

http://www.ibm.com/support/manager.wss?rs=64&rt=0&org=SW&doc=7000147

For the more general technique, start on the DB2 for z/OS home page ibm.com/software/db2os390

Click on Support Click on Technical Presentations The search for RACF or look through the 25 to 30 presentations. Click on the entry at the bottom of the page to get the pdf file. [...] 1536 44 81_Re: RC/Migrator: How can I have WHERE predicates automaticallyinserted for tables9_Rob Crane22_racrane@CONCENTRIC.NET31_Mon, 15 Apr 2002 10:33:09 -0600504_iso-8859-1 If your where clause is the same for all of your tables you could add that where clause to the UNLOAD model you are using (go into Model services, select the model you are using and update the model to include your WHERE clause).

Sounds like you might get more benefit out of RC/Extract if you are dealing with a subset of related data. RC/Extract allows you to have a strategy that can pull a subset of related data, etc. tied to a Migration strategy (strat type R instead of M). [...] 1581 53 39_Re: Diagnosis manual equivalent for UDB14_Linda Hagedorn30_Linda.Hagedorn@EMBARCADERO.COM31_Mon, 15 Apr 2002 09:37:18 -0700473_iso-8859-1 Thanks everyone.

Linda

-----Original Message----- From: Gert van der Kooij [mailto:gkooij@XS4ALL.NL] Sent: Saturday, April 13, 2002 3:33 AM To: DB2-L@RYCI.COM Subject: Re: Diagnosis manual equivalent for UDB



Hi,

If you need to know the log record format you can find it in the Administrative API Reference, appendix F (UDB 7.1) or G (UDB 6.1). To read the logs you can use the sqlurlog API, described in the same manual. [...] 1635 38 41_On-Line Backups. UDB V7.2 FP3, Unix 4.3.322_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Mon, 15 Apr 2002 09:39:06 -0700577_iso-8859-1 Hi Listers,

We have a situation where our shop requires 7 X 24 access. We have been running for over a year with on-line backups running daily. The applications folks have been noticing a slow down during the last 5 minutes of the backups. The applications folks have noticed that on some occasions it takes 25 seconds for one open cursor statement. We believe that this is being caused by the Active log being closed and written to disk. The concern is that for those 5 minutes the accesses to the tables slows down considerably and causes a backlog of [...] 1674 76 38_Re: Question about transitive closure.13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 15 Apr 2002 12:07:17 -0500432_us-ascii George,

Assuming you have an index on cola in both tablea & tableb, I would expect to see a matchcols 1 for both, with a nested loop join between the two.

DB2 is not actually generating the join predicates, but instead taking the cartesian product of the two results. This will actually be the same as a join, since a cartesian product is just a join of every row from tablea with every row from tableb. [...] 1751 55 37_Re: performance issue - high sync i/o13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 15 Apr 2002 12:17:25 -0500441_iso-8859-1 Anil,

My last reply was cutoff (250 lines).

You have a lot of sync I/O (death by random I/O). Why? I have no idea. It would be preferable to see the offending SQL, explain output, indexes (column cardinalities, clusterratios etc).

Common cause of death by random I/O is a nested loop join (or outer cursor and singleton select within program loop) between two tables with different clustering sequences. [...] 1807 16 13_Re: CPU Usage12_Roger Miller19_millerrl@US.IBM.COM31_Mon, 15 Apr 2002 11:50:05 -0500372_- Is there another load running at 4 AM to take up the 2 percent? This is within the expectation for data sharing, going back to V4 performance books. You can also note that what you gain back tends to be some usable capacity when the machines are more heavily loaded. The work can run in more places and there can be some reduction in the multi-processor overheads. [...] 1824 14 17_Re: DB2 on AS/40012_Roger Miller19_millerrl@US.IBM.COM31_Mon, 15 Apr 2002 12:07:25 -0500359_- Here is one more, DB2 for iSeries home

http://www-1.ibm.com/servers/eserver/iseries/db2/

Roger Miller

================================================ 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. 1839 70 35_Re: Why do I get an additional sort13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 15 Apr 2002 12:27:32 -0500472_iso-8859-1 For those who are interested....

Mike Vaughan, Walter and myself (offline) have concluded that this is actually a bug, and IBM have requested the relevant information to investigate.

As Walter originally suspected, DB2 should be able to avoid the GROUP BY sort.

Regards Terry Purcell Yevich Lawson & Assoc Inc (YL&A) IBM Gold Consultant - DB2 IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 http://www.ylassoc.com [...] 1910 60 54_Re: [DB2EUG] On-Line Backups. UDB V7.2 FP3, Unix 4.3.311_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Mon, 15 Apr 2002 19:12:13 +0100297_us-ascii Marty,

I haven't had this problem. However, if you want to prove that it is down to the log being closed, there is a registry variable. Have a look at the v7.2 manuals and it is fairly obvious - but its name escapes me at the moment.

If you can't find it, let me know. [...] 1971 18 25_LOGONLY recovery of DBD0116_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Mon, 15 Apr 2002 13:03:37 -0500526_- Greetings List, Can anyone tell me how the LOGONLY option knows which Archive log file to start from? I was under the impression that db2 marks the pageset with some relevant RBA...

If this is documented I would appreciate hearing about that too...

thanx, phil godfrin

================================================ 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. 1990 20 29_UDB File headers, hex offsets14_Linda Hagedorn30_Linda.Hagedorn@EMBARCADERO.COM31_Mon, 15 Apr 2002 11:56:40 -0700535_iso-8859-1 I'm looking for UDB file header layouts - space map pages, partitioned tablespace headers, non-partitioned tablespace headers, page frames, index page frames, etc.

I cannot find it in the Troubleshooting Guide. Any hints to the location of the offset maps?

Thanks, Linda

===============================================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. 2011 45 33_Re: UDB File headers, hex offsets13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Mon, 15 Apr 2002 14:26:43 -0500479_iso-8859-1 My V6 and V7 diagnostic manuals has the following.

7.0 Section 7. Physical Formats and Diagrams

Subtopics 7.1 Chapter 7-1. File Page Set Formats 7.2 Chapter 7-2. Index Page Set Formats 7.3 Chapter 7-3. Directory Formats 7.4 Chapter 7-4. Database Descriptor (DBD) Formats 7.5 Chapter 7-5. Directory and Catalog Diagrams 7.6 Chapter 7-6. Catalog formats 7.7 Chapter 7-7. Catalog index formats 7.8 Chapter 7-8. Object Identifier (OBID) Cross-Reference [...] 2057 69 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Mon, 15 Apr 2002 15:31:56 -0400561_us-ascii Logonly recovery DOES NOT work against DBD01.

I got this information from IBM Development while I was having a problem with Logonly recovery. They suggest that you take a image copy of the DB2 catalog and recovery it using the image copy.

The way logonly recover is supposed to work, and does for the rest of DB2, with the exception of DBD01. Once a tablespace is updated and written to dasd, the RBA in the header page is updated with that RBA. There fore when you are doing a logonly recovery, DB2 checks to see what RBA is in the [...] 2127 49 33_Re: UDB File headers, hex offsets13_Larry Hubbard25_larry_hubbard@YLASSOC.COM31_Mon, 15 Apr 2002 15:31:05 -0500377_iso-8859-1 Linda,

In looking into my DB2 UDB Version 7.2 manuals in PDF format, Chapter 2 has a fairly indepth discussion of different tablespace formats and on page 21 there is a layout of pages in general. That may contain what you are looking for. Personally I have found bits of what the mainframe Diagnostic manaual has scattered amongst multiple UDB manuals. [...] 2177 56 28_Re: DB2 OS/390 & UDB on UNIX11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Mon, 15 Apr 2002 15:56:44 -0500402_iso-8859-1 I've already responded once, but I just got back from our weekly service level meeting. They read through all the NT failures, unix failures, and Oracle failures. DB2's availability - 100%. OS/390's availability - 100%. CICS's availability - 100%.

That should make the managers with mainframe applications ecstatic, but they still talk about moving off the mainframe. Oh well... [...] 2234 67 33_Re: UDB File headers, hex offsets14_Linda Hagedorn30_Linda.Hagedorn@EMBARCADERO.COM31_Mon, 15 Apr 2002 14:14:16 -0700454_iso-8859-1 Sorry, I should have said UDB for midrange - Unix/Linux/Nt, etc. I fell into using the old convention where DB2=MVS and UDB=midrange.

Thanks just the same. Any other ideas?

-----Original Message----- From: Jeremiah Eden [mailto:JEREMIAH.EDEN@RADIOSHACK.COM] Sent: Monday, April 15, 2002 12:27 PM To: DB2-L@RYCI.COM Subject: Re: UDB File headers, hex offsets



My V6 and V7 diagnostic manuals has the following. [...] 2302 19 33_Most recent Utility on Tablespace7_Su Arun22_subha_sivaji@YAHOO.COM31_Mon, 15 Apr 2002 15:26:50 -0500270_- Hi Lister,

Please help . I am in a situation to find out the most recent utility perform on a Tablespace ( segmented ) . Is there any way to do this . We are OS/390 , with DB2 6.1. We use BMC and DB2 ADMIN TOOL. Any help at this time will be a great help. [...] 2322 90 28_Re: DB2 OS/390 & UDB on UNIX13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Mon, 15 Apr 2002 16:43:44 -0500580_iso-8859-1 Just a few more observations:

>4. You need lot of third party software to maintain everything and so cost >is high. You COULD write it in-house, or do without it, but it must be cost efficient to buy it??

>5. New generation's Ignorance of mainframe technology, since it is not >easily accessible to common people. You have to get job in some company to >learn it. Every generation has to get a job in some company to learn it. And when they do, they get job security and/or market "value". My personal feeling is that company bean counters have long [...] 2413 84 31_Re: Why V5 to V7 and not to V6?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 16 Apr 2002 09:46:55 +1200531_us-ascii David,

Not much in the way of high-tech investigations here. Migrating is a pain. The fewer times you can get away with having to do it, the better. Also, this client seems to have a penchant for out-of-date software. We must move on DB2 before the end of this year, and I can see a time when we'll be in exactly the same situation as we are now with V6. It'll probably happen here with V7 too, but at least we get a bit more breathing space. Plus it puts the client in a better position if they suddenly want [...] 2498 56 37_Re: Most recent Utility on Tablespace12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 16 Apr 2002 10:04:44 +1200309_us-ascii Have a butchers (i.e. look) at Sysibm.Syscopy. It keeps a record of what utilities were run against what tablespaces. Pretty sure the ISV utility products update this also, so you should be able to tell when, for example, a BMC LoadPlus job was run.

Hope this is what you're looking for. [...] 2555 74 37_Re: Most recent Utility on Tablespace15_Sniderman, Karl21_ksniderman@BCBSOK.COM31_Mon, 15 Apr 2002 17:36:08 -0500606_iso-8859-1 Sorry Raymond, you can't just throw that out there and not explain it, can you now? Is that Cockney rhyming slang? But what's the rhyme? Karl

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Monday, April 15, 2002 5:05 PM To: DB2-L@RYCI.COM Subject: Re: Most recent Utility on Tablespace



Have a butchers (i.e. look) at Sysibm.Syscopy. It keeps a record of what utilities were run against what tablespaces. Pretty sure the ISV utility products update this also, so you should be able to tell when, for example, a BMC LoadPlus job was run. [...] 2630 39 11_Data Spaces24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Mon, 15 Apr 2002 16:05:48 -0700335_- Hi Everyone!

We've recently upgraded to Z/OS and have been running DB2 version 6 for some time. After the upgrade, we converted our buffer pools in one of our development subsystems from the use of hiperpools to data spaces. Since that change, we've had a number of image copies fail with a resource unavailable message. [...] 2670 75 37_Re: Most recent Utility on Tablespace10_Dale Smock20_Dale.Smock@BMSUS.COM31_Mon, 15 Apr 2002 18:05:01 -0500598_iso-8859-1 If you use BMC and have the options set to collect history, you can find utility run info in the BMCHIST table.

Dale Smock BMG

-----Original Message----- From: Raymond Bell [mailto:rbell@NZ1.IBM.COM] Sent: Monday, April 15, 2002 5:05 PM To: DB2-L@RYCI.COM Subject: Re: Most recent Utility on Tablespace



Have a butchers (i.e. look) at Sysibm.Syscopy. It keeps a record of what utilities were run against what tablespaces. Pretty sure the ISV utility products update this also, so you should be able to tell when, for example, a BMC LoadPlus job was run. [...] 2746 88 32_Re: What ERLY code am I running?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 16 Apr 2002 11:22:16 +1200521_us-ascii Hi Mark, Hayden, Carol,

Thanks for the info. Carol, your note spelt out most clearly to the ignorant Sysprog hidden deep inside me what I had to do but you were all on the money. I ran Diagnose, looked for DSN3EPX, paged right and found the most recent PTF applied (only one with a year of 2000 was a good clue) and confirmed via IBMLink that this was a V5 PTF. Will re-apply the V7 ERLY code (applied it and backed it out as a test - thorough, huh?) and do the above again for my own peace of mind. [...] 2835 98 37_Re: Most recent Utility on Tablespace11_Davies, Ian31_Ian.Davies@CGI.HEALTH.GOV.AB.CA31_Mon, 15 Apr 2002 17:28:33 -0600465_iso-8859-1 At last one I can help with!

The UK is probably sleeping now anyway.

Yes it is Cockney rhyming slang, Butchers Hook - Look.

Cheers, Ian

Brit who left the rain for the snow of Canada, now wishing that it would stop bl__dy snowing :(

-----Original Message----- From: Sniderman, Karl [mailto:ksniderman@BCBSOK.COM] Sent: Monday - April 15, 2002 16:36 To: DB2-L@RYCI.COM Subject: Re: Most recent Utility on Tablespace [...] 2934 72 37_Re: Most recent Utility on Tablespace12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 16 Apr 2002 12:18:19 +1200382_us-ascii Karl, Ian has done the needful and given you the answer. I thought about explaining it but thought just the meaning and not the etymology would be more of a tease. What a bounder, eh?



Raymond PS. Ian, take a point. I'm feeling generous again, after finally getting SQL*Net and the OTG to work on our test LPAR. It was down to USS authority, by the way. [...] 3007 25 52_Search Archives for DB2 V6 moving from OS/390 to zOS24_ANDERSON Margaret * IRMD29_Margaret.Anderson@STATE.OR.US31_Mon, 15 Apr 2002 17:47:56 -0700411_iso-8859-1 We're currently running DB2 V6.1 on OS/390 2.8 but preparing to move to zOS shortly. I tried doing a search on the DB2-L Archives to see if anyone had any issues or "gotchas" with doing this migration. I got no hits for combinations of DB2 and zOS!!?? I suspect I'm not doing the search correctly, since it doesn't seem likely that this topic hasn't been discussed at all in the past 6 months!! [...] 3033 104 37_Re: Most recent Utility on Tablespace13_David Chapman24_David_Chapman@CGU.COM.AU31_Tue, 16 Apr 2002 11:04:08 +1000543_us-ascii **************************************************************************

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.

************************************************************************** :

Su,

Here's some SQL: SELECT * FROM SYSIBM.SYSCOPY WHERE 1=1 AND DBNAME = 'database' AND TSNAME = 'tablespace' AND TIMESTAMP = (SELECT COALESCE(MAX(TIMESTAMP),CURRENT TIMESTAMP) FROM SYSIBM.SYSCOPY WHERE DBNAME = 'database' AND TSNAME = 'tablespace' ) WITH UR ; [...] 3138 13 29_WLM - Goal mode/compatability16_JOHN G. MATTHEWS26_HC#JGM@MVS.MEDCTR.UCLA.EDU31_Mon, 15 Apr 2002 19:54:00 -0700481_- In DB2 for OS/390 V6 I know I need WLM SPAS vs. DB2 managed SPAS in order to use SPB, UDFs, DSNUTILS, IMS access, etc. My question is, what, if any, features of DB2 Stored Procedures are available in GOAL mode but not Compatability mode?

================================================ 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. 3152 119 38_Re: Question about transitive closure.31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Tue, 16 Apr 2002 04:03:45 +0100399_iso-8859-1 Terry,

I think what you are telling is that this is a cartesian product only and depending on the result set or the simplicity of the query, it is performing good.



Can you please tell how can we say looking at the plan table whether a query is a cartesian product or not? If nested loop join is used then do we have any information available in the plan table. [...] 3272 49 49_Survey: What drives the cost of data integration?12_Len Seligman18_seligman@MITRE.ORG31_Tue, 16 Apr 2002 00:10:07 -0400492_us-ascii Do you have experience with pulling, pushing, or combining structured data among separately developed systems?

We are conducting a survey to gather information on the time and effort involved in data integration/interoperability projects. Results will help us:

o Help project managers estimate their work and staffing needs o Develop metrics for evaluating data integration tools o Determine whether researchers and tool builders are working on the right problems [...] 3322 33 36_What's the name of the SAS-DB2 plan?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Tue, 16 Apr 2002 16:32:13 +1200548_us-ascii Colleagues,

A sysprog buddy of mine is upgrading SAS here from 6.08 to 8.2. The current SAS plan name is SASDB2E, while the new SAS plan is called SAS82. My question is, do we have a say in what this plan is called?

I personally hate versions in names. Obvious as to what version you're at, certainly, but a pain come upgrade time. Probably not a big issue with SAS as you don't have to give the plan name, but initially I wanted to go for something like SASDB2. It seems SAS tries to find the package name that matches [...] 3356 165 56_Re: Faltering at first step in UDB/Linux installation...16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Mon, 15 Apr 2002 22:25:53 -0700485_us-ascii Hello Phil, Marcus,

Think you didn't get my question. 'Quick Beginnings', Linux Howto etc. describe what is to be done once ./db2setup program is started. My problem is that on cdrom, I CANNOT find db2setup program. When I list files/directories after mounting the UDB 7.1 CD, following is the list I get. It does NOT include db2setup. So, where am I supposed to execute ./db2setup from? The 'db2' listed below also does not contain db2setup file. This is RH 6.1. [...] 3522 222 56_Re: Faltering at first step in UDB/Linux installation...13_Abi Monoharan23_abi@PROTEOMESYSTEMS.COM31_Tue, 16 Apr 2002 17:31:33 +1100561_us-ascii Hi, I think you are not using the right DB2 CD for Linux. If not then contact IBM or where ever you bought the software. Usually in the CD you can see the following files:

-r-xr--r-- 1 root root 4088 Aug 15 2001 db2_deinstall* -r-xr--r-- 1 root root 10187 Aug 15 2001 db2_install* -r-xr-xr-x 1 root root 6326 Aug 15 2001 db2setup* drwxr-sr-x 11 root root 4096 Aug 15 2001 doc/ drwxr-sr-x 3 root root 4096 Aug 15 2001 doc.cmn/ -rw-r--r-- 1 root root 8860 Aug 15 2001 readme.cn -rw-r--r-- 1 root root 11599 Aug 15 2001 readme.jp -rw-r--r-- 1 [...] 3745 56 13_Re: CPU Usage15_Foweather, Iris30_Iris.Foweather@UK.EXPERIAN.COM31_Tue, 16 Apr 2002 08:22:53 +0100312_- This is on a development system with NOTHING happening most of the time. As it is a development system the LPAR is small and I have had to stop the 2 data sharing DB2 systems to improve performance! I was wondering if there was anything I could do, within DB2 rather than in WLM, to reduce the CPU usage. [...] 3802 181 56_Re: Faltering at first step in UDB/Linux installation...19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Tue, 16 Apr 2002 11:10:07 +0100298_- Raquel,

Either you don't have a DB2 disk at all or it's not for Linux. The fact you wave "demoinst.exe" suggests it is either for Windows or OS/2 (possibly a demo or "try-and-buy" version). What happens if you put the disk into a Windows PC ?

I'd get back to your supplier !!! [...] 3984 16 20_Re: DB2 Cross Loader15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Tue, 16 Apr 2002 04:52:50 -0500316_- Hi

I recently worked with Cross Loader, but only within one subsystem on a DB2 OS/390. I selected about 700,000 rows and loaded these rows into a new table in about 3 minutes elapsed time. Next I want to test it on a DB2 OS/390 but select rows in one subsystem and loading them into another subsystem. [...] 4001 34 56_Re: Search Archives for DB2 V6 moving from OS/390 to zOS13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 16 Apr 2002 06:59:36 -0400700_iso-8859-1 Hi Margaret,

Try your search again with z/OS.

We have been running versions of z/OS for a long time without significant problems that I am aware of. Our workloads probably aren't the same as yours.

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













The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...] 4036 36 56_Setting the CORRELATION_ID in a Visual Basic application19_Calleja Vilar, Juan22_jcallejav@IBERDROLA.ES31_Tue, 16 Apr 2002 13:06:58 +0200589_iso-8859-1 Hello list. I am interested in setting a specific CORRELATION_ID when connecting to DB2 V6 OS/390 through DB2 Connect from a Visual Basic application. In the DB2 Manual 'Reference for Remote DRDA Requesters and Servers' there's a chapter which deals with that matter (I think). It talks about the EXCSQLSET command and SQLSTT. Has anybody used this feature?. If so, could you show me an example of implementation in a Visual Basic application? I think that the specific command is: SET CLIENT APPLNAME 'xxxxxxxxx' but I cannot embed this sentence in the Visual Basic code. [...] 4073 150 38_Re: Question about transitive closure.11_David Nance16_DWNance@FHSC.COM31_Tue, 16 Apr 2002 07:42:50 -0400551_US-ASCII Sanjeev, I've yet to see anything that would tell you that your join is a cartesian product, other than knowing the data and seeing the resultset. How would DB2 know if your join on the first column of a two column foreign key is a cartesian product? That may be what you're requirement actually is, can't figure out why you would, but it is a valid SQL statement. Granted there are some things you can watch for as a DBA, such as tablespace scans in your online packages, matching on fewer columns of an index than you know they should [...] 4224 141 38_Re: Question about transitive closure.13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 16 Apr 2002 06:53:13 -0500368_iso-8859-1 Sanjeev,

Well it is a cartesian product, but the result is exactly the same as a join. Thus, if you changed one of the local predicates to a join predicate, you would receive the same output. For example, if there are 2 matching rows in tablea and 3 matching rows in tableb; the join would return you 6 rows, and so would the cartesian product. [...] 4366 15 51_Suzanne Alexander/STL/Peabody is out of the office.17_Suzanne Alexander28_SAlexander@PEABODYENERGY.COM31_Tue, 16 Apr 2002 07:01:35 -0500389_us-ascii I will be out of the office starting 04/16/2002 and will not return until 04/17/2002.

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. 4382 22 39_Refreshing DB2 database from MS SQL200015_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Tue, 16 Apr 2002 08:06:07 -0400372_iso-8859-1 Hi

I was wondering if it is possible to refresh database tables in DB2 from SQL2000 ? Are there any utilities that can do this, replication ? The DB2 database can be read only a it will be used as a reporting server, "This is the first step we are trying to do to convince management that DB2 is the way to go and get out of the MS SQLserver arena. [...] 4405 40 26_Database Marked as Damaged15_Katharine Brown25_kathrinebrown@HOTMAIL.COM31_Tue, 16 Apr 2002 12:13:18 +0000565_- This is one problem we are facing sometimes in DB2 V5.2 UDB for AIX while Loading a Table from VisualWarehouse.

The Messages displayed

In VisualWareHouse Repeated calls to the socket function connect () failed. The message could not be sent. Destination host and destination port connections attempted :10 This may mean that the partner process is not loaded or is not listening on the assumed port. System Message The attempt to connect was forcefully rejected. In DB2Diag.log The message DIA3727C says that the Database is marked as Damaged. [...] 4446 182 56_Re: Faltering at first step in UDB/Linux installation...9_Alex J.P.16_apaulia1@TXU.COM31_Tue, 16 Apr 2002 07:14:24 -0500361_- Hi Raquel,

I may be wrong but the fact that you have "setup.exe" in the directory would mean that you have a install disk for the mswindows operating system instead of a linux install disk. Could you please check if this is infact the case. Alex...

On Mon, 15 Apr 2002 22:25:53 -0700, Raquel Rodriguez wrote: [...] 4629 155 37_Re: Most recent Utility on Tablespace12_Subha Sivaji22_subha_sivaji@YAHOO.COM31_Tue, 16 Apr 2002 05:32:06 -0700694_us-ascii Thanks David,

The answer really helps. But is there any way you see to track the most recent utilities like Runstat , Check data , I do see the ICTYPE is blank for all of these . Any thoughts.

With regards, Su .







--- David Chapman wrote: > ************************************************************************** > > Note: This e-mail is subject to the disclaimer > contained at the bottom > of this message. > > ************************************************************************** > : > > Su, > > Here's some SQL: > SELECT * > FROM SYSIBM.SYSCOPY > WHERE 1=1 > AND DBNAME = 'database' > AND TSNAME = [...] 4785 69 30_Re: Database Marked as Damaged18_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Tue, 16 Apr 2002 08:49:58 -0400475_- That would be my first suggestion. From that you may have to call IBM Tech support for a solution. Make sure you keep your db2diag.log files as well.

Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2



-----Original Message----- From: Katharine Brown [mailto:kathrinebrown@HOTMAIL.COM] Sent: Tuesday, April 16, 2002 8:13 AM To: DB2-L@RYCI.COM Subject: Database Marked as Damaged [...] 4855 16 29_Re: LOGONLY recovery of DBD0116_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Tue, 16 Apr 2002 07:38:30 -0500409_- Howdy John,

Thank God for you! I thought I was going nuts! I had thought that this was the case (not working for DBD01 and requiring an fic).

thanx, pg

================================================ 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. 4872 22 28_Clist to calculate workspace4_Anil18_usregion10@AOL.COM31_Tue, 16 Apr 2002 07:46:27 -0500537_- Hi All!

Does anyone have a Clist that can be used to calculate the temp workspace for IBM and BMC utilities (load, unload, recover, reorg) ? Normally, I specify space so large that I am certain it has to be enough. But now that I want to submit many jobs in parallel, it has become important that I try to be more accurate in specifying the space for the temp datasets. By doing so, hopefully I will not overallocate for small tables and nor I underallocate for large tables. Any clists (to calc sortwrk space) out there ? [...] 4895 75 13_Re: CPU Usage16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 16 Apr 2002 09:03:23 -0400611_iso-8859-1 Maybe turn of Stastics Class 5 trace?

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Foweather, Iris [mailto:Iris.Foweather@UK.EXPERIAN.COM] Sent: Tuesday, April 16, 2002 3:23 AM To: DB2-L@RYCI.COM Subject: Re: CPU Usage



This is on a development system with NOTHING happening most of the time. As it is a development system the LPAR is small and I have had to stop the 2 data sharing DB2 systems to improve performance! I was wondering if there was anything I could do, within DB2 rather than in WLM, to reduce the CPU usage. [...] 4971 140 26_Aw: Re: IN LIST processing13_Wolfgang Hini35_letterbox@HIPERFORMANCE-SOFTWARE.DE31_Tue, 16 Apr 2002 08:03:54 -0500344_iso-8859-1 Hallo Terry,

My conclusions are:

Point 1.: - So, it would be best to arrange the IN LIST Values in the Index order DB2 uses, to have a bigger chance to get a good Buffer Pool hit ratio.

Point 2.: - so,if DB2 finds a row for the first duplicate value in the IN LIST, the follwoing duplicates are not checked [...] 5112 32 33_Re: WLM - Goal mode/compatability11_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Tue, 16 Apr 2002 08:23:38 -0500574_iso-8859-1 The only difference you have to start and stop the address spaces, whereas WLM willl do it for you in goal mode.

Tina

-----Original Message----- From: JOHN G. MATTHEWS [mailto:HC#JGM@MVS.MEDCTR.UCLA.EDU] Sent: April 15, 2002 9:54 PM To: DB2-L@RYCI.COM Subject: WLM - Goal mode/compatability



In DB2 for OS/390 V6 I know I need WLM SPAS vs. DB2 managed SPAS in order to use SPB, UDFs, DSNUTILS, IMS access, etc. My question is, what, if any, features of DB2 Stored Procedures are available in GOAL mode but not Compatability mode? [...] 5145 38 48_Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 16 Apr 2002 08:10:31 -0500577_- Esteemed List,

I made a rather rash decision a short while ago and now I would appreciate any help from you gurus that might help me resolve my (not very exciting) problem. I had UDB v5 installed on my pc (under Win95), which connected quite happily to DB2 OS/390 v5 via a direct TCP connection. I decided to download UDB v7.2 PE (as it was free). I've used the Client Config. Assistant to catalogue the mainframe systems, but I'm now unable to connect to them. I get the following messages: On the Client Config. Assistant - SQL10007N Message "1056567296" could [...] 5184 103 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v514_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 16 Apr 2002 14:37:32 +0100592_iso-8859-1 Easy peasy, Stevey!

Personal Edition doesn't come with OS/390 connectivity.

Sorry old friend, been bitten there myself!

Regards, Marcus



----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 5288 60 32_Re: Clist to calculate workspace13_Bright, Randy20_Randy_Bright@BMC.COM31_Tue, 16 Apr 2002 08:50:16 -0500662_iso-8859-1 Just a suggestion that might make your job easier. (Warning, vendor product plug follows!)

Why don't you utilize the dynamic work file allocation capabilities of BMC LoadPlus and Reorg Plus? Unload Plus does not yet have dynamic allocation available, but it will in the next release. Calculations are done for Reorg Plus based on analysis of the tablespace being reorged. LoadPlus does it's calculations based on the user supplied ENUMROWS parameter (and analysis in a RESUME YES case). All SYSUT1, SYSREC, SYSDISC, SYSERR, SORTWK, and COPY datasets can be dynamically allocated in LoadPlus, while Reorg Plus will dynamically allocate all [...] 5349 67 40_AW: What's the name of the SAS-DB2 plan?41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Tue, 16 Apr 2002 15:56:38 +0200428_iso-8859-1 Raymond,

I'm not sure whether you have a choice when it comes to naming your sas-plan, but I did look at the names of our respective sas-plans, and since your names matched ours (SASDB2E and SAS82) I should think that you are left with no choice; others might have different findings, though. And I leave the question whether you're going slightly mad or not to others to answer (sorry, couldn't resist). [...] 5417 43 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 16 Apr 2002 08:49:39 -0500709_ISO-8859-1 Hi Marcus!

Are you sure it doesn't? It's obviously "talking" to the mainframe, cos I can see an error message on the DB2 MSTR address space log! I also get the following in the db2.log file on my pc and it mentions DB2 Connect as the product to be installed! ---------------------------------------- Setup Log File Opened7-14-2000 14:43:01 ---------------------------------------- =>Querying the system... Windows 95 Version: 4.0 The DB2 Folder Name value for the Registry key SOFTWARE\IBM\DB2 cannot be retrieved. The DB2 Path Name value for the Registry key SOFTWARE\IBM\DB2 cannot be retrieved. Space requirements are being calculated... =>Checking for previous installations... The [...] 5461 118 32_Re: What ERLY code am I running?13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 16 Apr 2002 09:06:59 -0500403_iso-8859-1 If you want to know what version you are running you can do that in several ways. The easiest way is IEBEYEBALL module DSN3EPX in SDSNLINK and look for the RIB (Release Information Block). It will be followed by the component identifier (RIBCID) and release (RIBREL). Should look something like ....RIB 5740XYR01710 or ....RIB 5740XYR01610 or this ....RIB 5740XYR01510 if you are on V5. [...] 5580 106 32_Re: What ERLY code am I running?10_Andy Stein22_jbak2009@AMERITECH.NET31_Tue, 16 Apr 2002 09:39:33 -0500586_us-ascii Pleasew take me off the list.

Thank You

Andy Stein











>Hi Mark, Hayden, Carol, > >Thanks for the info. Carol, your note spelt out most clearly to the >ignorant Sysprog hidden deep inside me what I had to do but you were all on >the money. I ran Diagnose, looked for DSN3EPX, paged right and found the >most recent PTF applied (only one with a year of 2000 was a good clue) and >confirmed via IBMLink that this was a V5 PTF. Will re-apply the V7 ERLY >code (applied it and backed it out as a test - thorough, huh?) [...] 5687 127 49_Re: High CPU in DBM1, CICS waits - FINAL Analysis13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 16 Apr 2002 09:47:12 -0500347_iso-8859-1 Setting DDCONS=NO has corrected all of these performance problems. If you don't have this set and it is taking the default, you probably want to change it.

-----Original Message----- From: Jeremiah Eden Sent: Wednesday, February 13, 2002 7:54 AM To: DB2-L@RYCI.COM Subject: Re: High CPU in DBM1, CICS waits - FINAL Analysis [...] 5815 92 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v514_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 16 Apr 2002 15:48:33 +0100528_iso-8859-1 Isn't the db2.log saying you have to install DB2 Connect PE to get it working?

Marcus



----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 5908 93 32_Re: Clist to calculate workspace17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Tue, 16 Apr 2002 10:16:00 -0500626_iso-8859-1 Hi Anil,

I'll just add to Randy's response that in both 'BMC Reorg Plus for DB2' and 'BMC LoadPlus for DB2' if you submit a job with ANALYZE ONLY in your syntax then the utility will produce a workfile allocation report telling you how big the workfiles need to be. Likewise, as Randy already pointed out, if you use dynamic allocation you don't need to worry about it because we'll dynamically allocate the datasets for you (using the characteristics described in the workfile allocation report). You also have various controls on Max-Extent-Size, SMS DATACLAS, MGMTCLAS, STORCLAS and lots more stuff. [...] 6002 17 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 16 Apr 2002 09:51:22 -0500458_- Hi Marcus,

I've checked the IBM website and DB2 UDB v7.2 PE contains DB2 Connect PE, which can be used to connect to DB2 OS/390. I'm still checking if it works with v5 on the mainframe.

Regards, Steve

================================================ 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. 6020 118 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v518_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Tue, 16 Apr 2002 11:36:06 -0400337_iso-8859-1 Just for Info. I have DB2 Connect PE V7.2 running on my desktop and I've got all sorts of connections to our various DB2 Version 6 OS/390 subsystems. Works like a champ or at least some of the time.. In the past I've used DB2 Connect V6 with DB2 OS/390 V5. My understanding is that its backward and forward compatible... [...] 6139 40 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v516_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 16 Apr 2002 11:42:14 -0400401_iso-8859-1 V7.2 of DB2 connect (PE or not) will work with DB2/OS390 6.1 and 7.1. For DB2V5 you need an older (V6.?) DB2 connect.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Steve Lamb [mailto:steve.lamb@POWERGEN.CO.UK] Sent: Tuesday, April 16, 2002 10:51 AM To: DB2-L@RYCI.COM Subject: Re: Problem with UDB 7.2 connecting to DB2 OS/390 v5 [...] 6180 94 29_Re: LOGONLY recovery of DBD0110_Rick Foley22_rickfoley1@HOTMAIL.COM31_Tue, 16 Apr 2002 11:36:19 -0400588_- Can you shed more light on the problem that you encountered ? We have successfully recovered DBD01 using LOGONLY.

Thanks, Rick

-----Original Message----- From: John_Lendman@FPL.COM [mailto:John_Lendman@FPL.COM] Sent: Monday, April 15, 2002 3:32 PM To: DB2-L@RYCI.COM Subject: Re: LOGONLY recovery of DBD01



Logonly recovery DOES NOT work against DBD01.

I got this information from IBM Development while I was having a problem with Logonly recovery. They suggest that you take a image copy of the DB2 catalog and recovery it using the image copy. [...] 6275 32 33_Re: LOAD DATA on DB2 ON MAINFRAME12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 16 Apr 2002 10:43:31 -0500648_- performance guesstimates: There are so many variables that make the answer highly variable: row lengths, numbers of indexes, ... Here are some general direction comments. There are some performance measurements in the V7 Performance Topics redbook, SG24-6129.

1. A java program to insert rows. Java is generally slower (more cpu time) than C. C is generally slower than COBOL. Insert is substantially slower than LOAD RESUME SHRLEVEL(REFERENCE) or online LOAD. Online load is substantially slower than offline LOAD. 2. Use DB2 new feature Cross loader utility. This uses DRDA and DB2 Connect for the SELECT, with the LOAD utility for [...] 6308 25 56_Re: Search Archives for DB2 V6 moving from OS/390 to zOS12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 16 Apr 2002 11:03:19 -0500531_- There are a number of APARs for z/OS mentioned in the V7 performance redbook and redpaper, if you want to use those features. Most are not unique to V7.

V7 Performance Topics, SG24-6129 See chapter 10. V7 Selected Performance Topics, redpaper, Try section A.6 OS/390 and z/OS APARs.

Are you moving to z/OS V1R2? There is a draft redbook, SG24-6235, z/OS Version 1 Release 2 Implementation that may help, but I did not see any service mentioned specifically for DB2. I think that a book for R3 is in the works. [...] 6334 195 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Tue, 16 Apr 2002 12:39:27 -0400523_iso-8859-1 The problem I ran into was when I tried to do a LOGONLY recovery of DBD01, the archive log that was called for was already scratched. We only keep 14 days of archive log. When I address this with DB2 development, they told me that under some conditions they do not keep the RBA in the header page of the tablespace up to date. They said the only sure way to recovery DBD01 was to take an image copy and use that for recovery. Once I followed this method it worked fine. I still do a LOGONLY recovery of the [...] 6530 42 43_Re: Refreshing DB2 database from MS SQL200015_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 16 Apr 2002 12:48:52 -0400418_iso-8859-1 I think you can do this two way. 1. DB2 data joiner to replicate data from SQLserver to DB2. 2. Use SQLserver DTS to send the data to DB2 using odbc connection in a fixed interval.

thanks..sibi



-----Original Message----- From: Sharpe, Richard [mailto:rsharpe@AMHERST1.COM] Sent: Tuesday, April 16, 2002 07:06 AM To: DB2-L@RYCI.COM Subject: Refreshing DB2 database from MS SQL2000 [...] 6573 172 29_Re: LOGONLY recovery of DBD0110_Rick Foley22_rickfoley1@HOTMAIL.COM31_Tue, 16 Apr 2002 13:22:57 -0400647_- If this is the only problem you encountered then there is a solution.

A periodic (weekly) QUIESCE to DBD01 (and 6 other tablespaces that are not 'registered' in syslgrnx) solved the problem for us.

Take a look at APAR PN92371. Old but helpful...

Rick





>From: John_Lendman@FPL.COM >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: LOGONLY recovery of DBD01 >Date: Tue, 16 Apr 2002 12:39:27 -0400 > >The problem I ran into was when I tried to do a LOGONLY recovery of DBD01, >the archive log that was called for was already scratched. We only keep 14 >days [...] 6746 26 29_Re: LOGONLY recovery of DBD0116_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Tue, 16 Apr 2002 11:43:27 -0500568_- Hi Rick,

I am testing my D/R plan on a test LPAR, where nothing is cataloged for the subsystem I'm recovering. Knowing my FDR will lay down a post COPY image of my subsystem datasets, I presumed LOGONLY would use the high RBA information on the DBD01 pageset. I was wrong. The RECOVER LOGONLY was requesting archive logs from before the COPY. I knew this from the MSTR log showing requests for earlier archive logs I was not expecting. Since the archive logs were not cataloged the "sort of" failed. Actually the recovery got a zero condition code and I [...] 6773 62 43_Re: Refreshing DB2 database from MS SQL200015_Sharpe, Richard20_rsharpe@AMHERST1.COM31_Tue, 16 Apr 2002 13:59:45 -0400393_iso-8859-1 sibi

Thanks, I think we might try the data joiner as the DTS package looks like it will take too long to populate the tables, this is a 80 gig database.

Rich

-----Original Message----- From: Philip, Sibimon [mailto:SPhilip@CSXLINES.COM] Sent: Tuesday, April 16, 2002 12:49 PM To: DB2-L@RYCI.COM Subject: Re: [DB2-L] Refreshing DB2 database from MS SQL2000 [...] 6836 20 29_Re: LOGONLY recovery of DBD0116_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Tue, 16 Apr 2002 12:25:53 -0500353_- OK - I checked the APAR. I have two quiesce points one before the catalog COPY and one after. I then archive the logs and then I shut down and FDR the file system.

Still RECOVER LOGONLY blew right past the quiesce points and called for older archives.

Could this be a case of an old bug working it's way back into the release code? [...] 6857 56 29_Re: LOGONLY recovery of DBD0110_Rick Foley22_rickfoley1@HOTMAIL.COM31_Tue, 16 Apr 2002 14:19:18 -0400300_- Make sure you do a QUIESCE WRITE(YES).

I just did a quick test: 1 - Recycle my DB2 system (to make sure all buffers are flushed) 2 - DSN1PRNT to DBD01 with PRINT(0),FORMAT 3 - QUIESE WRITE(YES) to DBD01 4 - DSN1PRNT to DBD01 with PRINT(0),FORMAT

I did this with a DB2 V7 system. [...] 6914 181 32_Re: Clist to calculate workspace10_Bill Disch23_Bill.Disch@GENMILLS.COM31_Tue, 16 Apr 2002 13:19:40 -0500662_ISO-8859-1 RESEND after first attempt rejected for being over 250 lines.

Here are 2 QMF queries that I made available for all support personnel to use when creating the JCLs to reorganize their tablespaces. These are very old queries (pre-BMC dynamic allocation) which require accurate DB2 Catalog statistics, hence the inclusion of STATSTIME. The calculations were taken from the BMC and/or IBM documentation sometime in the early 1990's. As the gentleman from BMC stated, when dynamic allocation of all workfiles was delivered for the BMC tools, the JCL maintenance became much easier. Developers were only required to provide an ENUMROWS estimate [...] 7096 181 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v50_22_Alex.Chan@EBANCLLC.COM31_Tue, 16 Apr 2002 14:20:24 -0400586_us-ascii Steve.

You may want to check your c:\WINNT\system32\drivers\etc files ( open those host, services etc. files with NOTEPAD ) to ensure all the port numbers and TCP settings are correct. Verify them against your host's IP address, the system ID, various DB2 ports, DB2 resync ports ( if you are doing client server and two phase commits ) usually found in wherever your shop put those TCP parms ( usually in some SYSx.TCPPARMS, usually found in the PROFILE ) and you can further verify them against your DB2 MASTER LOG started task ( do a "found" on "port" will show [...] 7278 16 29_Re: LOGONLY recovery of DBD0116_Philippe Godfrin38_philippe.godfrin@JUDICIARY.STATE.NJ.US31_Tue, 16 Apr 2002 12:55:30 -0500333_- oops - I'm NOT quiesscing DBD01.

never mind,

miss emily litella

(pg)

================================================ 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. 7295 105 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Tue, 16 Apr 2002 14:46:56 -0400324_us-ascii One other point I forgot to mention, in version 7, IBM add a function to an existing zparm. The ZPARM of DLDFREQ. What ever number you put in the parm, DB2 will update the HPGRBRBA every n checkpoint taken. This also will help keep the HPGRBRBA up to date. But this does not apply if you are not on Version 7. [...] 7401 136 29_Re: LOGONLY recovery of DBD0110_Rick Foley22_rickfoley1@HOTMAIL.COM31_Tue, 16 Apr 2002 15:23:53 -0400361_- John -

Where is this functionality of the DFDFREQ documented? I couldn't find it.

BTW - I also have V6 here, and the QUIESCE did update the HPGRBRBA of DBD01. This functionality of the QUIESCE is in DB2 since V3 and it seems like it was added specifically to solve the problem that you described (you can read more about this in the APAR). [...] 7538 95 26_Db2 abend 04e. Help !!!!!!30_Monica Maria Pinheiro e Coelho36_monica.coelho@BRADESCOSEGUROS.COM.BR31_Tue, 16 Apr 2002 16:30:18 -0300330_iso-8859-1 Hi, list

I need help. Our Production Db2 begin to recieve 04e for every distributed connection, many, many, many times. Afeter a peiod, DB2 stopped to answer to any request. I stopped DB2 mode(force) and restarted, and everything seems ok now. Does anyone have a idea ? Where should I begin to search for ? [...] 7634 26 14_DB2 Time Stamp22_Hitzfelder, Stephen J.25_steve.hitzfelder@USAA.COM31_Tue, 16 Apr 2002 14:35:54 -0500406_iso-8859-1 I have looked at the doc, and can not find any reference to how DB2 handles Daylight Savings Time with its timestamps in tables.

Does anyone know where this is described? Thanks.





Stephen J. Hitzfelder, Ph.D.

Technical Fellow, Operations F-1-E (210)456-3774



The views discussed in this note do not necessarily reflect the opinion of USAA. [...] 7661 30 20_Installation of ODBC14_Judy Woodfield13_judyw@CAE.COM31_Tue, 16 Apr 2002 15:43:39 -0400346_iso-8859-1 Dear Listers:

When we have users requiring access to one of our DB2 databases, a DBA goes to the users location and installs Run Time Client 7.1 followed by fix pack 3.

The first question is: Is there a way to install just the ODBC drivers without including the Command Center, as this is really all the users need? [...] 7692 42 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v513_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 16 Apr 2002 16:11:06 -0400376_iso-8859-1 >V7.2 of DB2 connect (PE or not) will work with >DB2/OS390 6.1 and 7.1. >For DB2V5 you need an older (V6.?) DB2 connect.

I hate to disagree with you Eric (because you know what you're talking about and I almost always find myself agreeing with what you say).

But I am able, using DB2 Enterprise Edition 7.2 to connect to our OS/390 V5 subsystem. [...] 7735 161 30_Re: Db2 abend 04e. Help !!!!!!16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 16 Apr 2002 16:14:14 -0400556_iso-8859-1 1) Look in console log for abend of DSNDIST address space. If you see this, search IBMLINK for the dump title. 2) Look in DB2 job output for messages just before the onslaught of 04E. If you see something truly odd, look it up then search for it on IBMLINK. There is a good chance you will get your answer from the messages just before the 04E flood. 3) Print LOGREC for time starting about 1 hour before the problem and through the time you brought DB2 down. The LOGREC Software records will have titles. The TYPE: SOFTWARE RECORD reports [...] 7897 155 30_Re: Db2 abend 04e. Help !!!!!!13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Tue, 16 Apr 2002 16:17:27 -0400740_iso-8859-1 Hi Monica.

You need to find the reason code accompanying the 04E abend.

You can look that up at http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnmch11/CCONTENTS (that's the DB2 v7 doc for z/OS and os/390)

If you're not v7, go to

http://www-1.ibm.com/servers/s390/os390/bkserv/find_shelves.html and enter DB2 for OS/390 V? where ? is the version you're running.

If you don't find an explanation there, post the reason code here. Someone can probably help. Our friends over in Oz are probaby on now and they have all the reason codes memorized. [...] 8053 23 58_C++ compiler for SQL Procs on DB2/390 V7.1 still required?12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Tue, 16 Apr 2002 15:21:28 -0500520_us-ascii I am just going back to look at SQL stored procedure builder for DB2 V7.1 on OS/390. When I initially looked at the stored procedure builder in V6.1 it required the C compiler which was not turned on at our site. I am noticing REXX in some of the latest PTFs and wondered if this was only for external stored procedures or for SQL procedures as well. We are a PLI shop and have not needed the C compiler as of yet. I am getting the feeling that this is going to be a requirement for future releases of DB2 [...] 8077 24 19_DB2 sizing question10_Mandy Shaw22_Mandy.Shaw@HANDBAG.COM31_Tue, 16 Apr 2002 20:24:04 +0000431_- Hallo, I need to size a server (Win2000 or AIX - haven't decided yet) for DB2. I am puzzled because the sizing tools all talk about numbers of active users, without defining what an active user means. I have calculated numbers of DB2 transactions per second, with an idea of the breakdown of simple v. complex transactions - can anyone tell me how I should translate this into numbers of active users? Thank you. Mandy Shaw [...] 8102 65 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v516_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Tue, 16 Apr 2002 16:39:02 -0400482_iso-8859-1 We had a failure with DB2 V5 and DB2 Connect V7.something. The message pointed to release incompatabilities. When we went DB2 V7, our DB2 Connect pre 6.* (i.e. the CAE stuff mostly) had problems.

Regards, eric pearson NS ITO Database Support



-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Tuesday, April 16, 2002 4:11 PM To: DB2-L@RYCI.COM Subject: Re: Problem with UDB 7.2 connecting to DB2 OS/390 v5 [...] 8168 57 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v513_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 16 Apr 2002 15:40:10 -0500517_iso-8859-1 Dave, you are correct, the 2 up 1 down relationship applies to DB2 CONNECT client to DB2 Connect Server, not DB2 OS/390 Server version.

Dave



-----Original Message----- From: Seibert, Dave [mailto:Dave_Seibert@COMPUWARE.COM] Sent: Tuesday, April 16, 2002 3:11 PM To: DB2-L@RYCI.COM Subject: Re: Problem with UDB 7.2 connecting to DB2 OS/390 v5



>V7.2 of DB2 connect (PE or not) will work with >DB2/OS390 6.1 and 7.1. >For DB2V5 you need an older (V6.?) DB2 connect. [...] 8226 40 24_Re: Installation of ODBC12_Jim Harrison12_jimh@QIS.NET31_Tue, 16 Apr 2002 16:59:16 -0700417_us-ascii Choose the custom install - you should be able to de-select items you don't want installed and just install the drivers.

For remote installs, we use ZenWorks since we're a Novell shop. If SMS is similar I don't see why you couldn't use it. Our remote-install people require significant usage of the software though before they'll take the time to set it up. Apparently it's not a trivial effort. [...] 8267 80 25_DB2 LOAD using NOCOPYPEND14_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Wed, 17 Apr 2002 07:02:50 +1000389_iso-8859-1 Can someone explain the result of the following LOAD Utility ?

Looking at the DB2 UDB for OS/390 Version 6 Utilities manual, it appears as though I can code NOCOPYPEND to do the equivalent of a REPAIR SET NOCOPYPEND during the LOAD.

The odd thing is that there is a message at the end of my LOAD tells me that the Tablespace is still in a COPY Pending state. [...] 8348 41 62_Re: C++ compiler for SQL Procs on DB2/390 V7.1 still required?15_Russell Collins21_russell@ECTAUSTIN.COM31_Tue, 16 Apr 2002 16:19:01 -0700407_us-ascii If you are using SQL-PL you will need the C++ compiler. The only time that I have not needed the compiler is when I am doing Java Stored Procedures.

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Mark Buzzard Sent: Tuesday, April 16, 2002 1:21 PM To: DB2-L@RYCI.COM Subject: C++ compiler for SQL Procs on DB2/390 V7.1 still required? [...] 8390 67 60_Re: Setting the CORRELATION_ID in a Visual Basic application13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Tue, 16 Apr 2002 16:24:53 -0500406_iso-8859-1 Juan,

Looking at that section of the manual, it looks a lot like what we did with the accounting string API sample that IBM provides (see User Guide) for C, and that we customized for VB. So it looks like it may be possible, but IBM would probably want you to buy a consultant to figure out how to implement it, unless someone else on the list has done this and is willing to share. [...] 8458 92 29_Re: DB2 LOAD using NOCOPYPEND10_Andrew Pan19_andrew.pan@WAMU.NET31_Tue, 16 Apr 2002 14:25:42 -0700560_us-ascii Peter,

Check your tablespace before running the load. If it is in COPY pending state, NOCOPYPEND will not turn the pending flag off after the load.

Andrew

Peter Schwarcz wrote:

> Can someone explain the result of the following LOAD Utility ? > > Looking at the DB2 UDB for OS/390 Version 6 Utilities manual, it appears as > though I can code NOCOPYPEND to do the equivalent of a REPAIR SET NOCOPYPEND > during the LOAD. > > The odd thing is that there is a message at the end of my LOAD tells me that > the Tablespace [...] 8551 197 37_Re: Most recent Utility on Tablespace12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 17 Apr 2002 09:45:44 +1200615_us-ascii Su,

The time the most recent Runstats was run against an object will be in the Statstime column in Sysibm.Systablespace (if it's a tablespace) or Sysibm.Sysindexes (if it's an index). Not sure if the names change between DB2 releases - probably not - but it's easy enought to find out.

As David suggested, look in Sysibm.Syscopy, specifically the ICType column, for the execution dates/times of the other utilities. Check Data's utility type is not blank; it's D. A quick look (or 'butchers', if you prefer) in the excellent 'SQL Reference' will answer these questions and more for you. [...] 8749 94 30_Re: Database Marked as Damaged13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Wed, 17 Apr 2002 08:17:52 +1000419_us-ascii That might be a problem UDB 5.2 is out of service !

-----Original Message----- From: Krawetzky, Peter J [mailto:KrawetzkyPJ@AETNA.COM] Sent: Tuesday, April 16, 2002 10:50 PM To: DB2-L@RYCI.COM Subject: Re: Database Marked as Damaged



That would be my first suggestion. From that you may have to call IBM Tech support for a solution. Make sure you keep your db2diag.log files as well. [...] 8844 52 32_Re: Clist to calculate workspace10_Trinh Linh24_ltrinh@WOOLWORTHS.COM.AU31_Wed, 17 Apr 2002 08:32:23 +1000599_- Anil,

For the BMC utilities you can run the utility with analyse only which give you the info you need to allocate space. It tooks me 4 mins to run for a 990 M rows table.

Regards,

Linh Trinh *: 02 9843-1329 Database Analyst



> -----Original Message----- > From: Anil [SMTP:usregion10@AOL.COM] > Sent: Tuesday, April 16, 2002 10:46 PM > To: DB2-L@RYCI.COM > Subject: Clist to calculate workspace > > Hi All! > > Does anyone have a Clist that can be used to calculate the temp workspace > for IBM and BMC utilities (load, unload, recover, reorg) ? Normally, [...] 8897 66 32_Re: What ERLY code am I running?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Wed, 17 Apr 2002 09:59:36 +1200362_us-ascii Hi Jeremiah,

Even better. This was what I really wanted - something in one of the modules I can search for. Fortunately I always carry a couple of IEBEYEBALL utilities around with me, although they're only fully effective once I've put my contacts in. Found the RIB in DSN3EPX and it's consistent with what a) I'd hoped and b) you describe. [...] 8964 52 18_Re: DB2 Time Stamp13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Wed, 17 Apr 2002 08:38:59 +1000338_iso-8859-1 G'day Stephen,

Not sure of your platform here so I'll try and be generic.

DB2 doesn't handle daylight savings time. Generally the time is requested from the os on which it is running. This is therefore always local time. You need to talk to your sysprogs/sysadms/ntadmins to find out how the os handle this. [...] 9017 20 48_Oracle ROWID or ROWNUM equivalent in OS/390 DB2?14_Linda Hagedorn30_Linda.Hagedorn@EMBARCADERO.COM31_Tue, 16 Apr 2002 16:31:50 -0700505_iso-8859-1 Hello,

Does the Oracle ROWID or ROWNUM equivalent exist in OS/390 DB2 and I've just overlooked it all these years? If it isn't there, is there any talk of changes that might include these columns? I've found them to be useful.

Thanks, Linda

===============================================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. 9038 52 23_Re: DB2 sizing question11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Wed, 17 Apr 2002 09:30:46 +1000528_iso-8859-1 Mandy Shaw[SMTP:Mandy.Shaw@HANDBAG.COM] wrote: > >Hallo, > >I need to size a server (Win2000 or AIX - haven't decided yet) for DB2. > >I am puzzled because the sizing tools all talk about numbers of active > users, without defining what an active user means. > >I have calculated numbers of DB2 transactions per second, with an idea of > the breakdown of simple v. complex transactions - can anyone tell me how I > should translate this into numbers of active users? > This is usually distinguished as users who [...] 9091 227 37_Re: Most recent Utility on Tablespace13_David Chapman24_David_Chapman@CGU.COM.AU31_Wed, 17 Apr 2002 10:04:51 +1000520_us-ascii **************************************************************************

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.

************************************************************************** :

Su,

As Raymond suggested, check the statstime columns to see when runstats was run (with UPDATE ALL | ACCESSPATH | SPACE). However, this won't tell you if someone has update the catalog statistics.

What are you trying to find out? [...] 9319 48 61_Displaying database content with Java servlets and JavaScript16_Jeffrey I Condon19_jicondon@US.IBM.COM31_Tue, 16 Apr 2002 17:25:26 -0700631_iso-8859-1 This article was just launched on developerWorks. It uses a used car lot example to demonstrate. Cheer jeff

Displaying database content dynamically with Java servlets and JavaScript This article show how to make an interactive way to view up-to-date inventory online, using a powerful combination of server-centric Java servlets and client-centric JavaScript. Also provided is an in-depth example that relays inventory data to a Web site visitor, and ties together a relational database(example DB2) to a Java servlet using JDBC. http://www-106.ibm.com/developerworks/wireless/library/i-car/?open&l=327,t=gr [...] 9368 40 52_Re: Oracle ROWID or ROWNUM equivalent in OS/390 DB2?13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Wed, 17 Apr 2002 11:01:13 +1000419_iso-8859-1 Hi Linda, It depends on your version, checkout identity columns in the V7 manuals. Watch out for the gotchas though, little things like ROWID changes between reorgs.

HTH

Steve T

-----Original Message----- From: Linda Hagedorn [mailto:Linda.Hagedorn@EMBARCADERO.COM] Sent: Wednesday, 17 April 2002 9:32 AM To: DB2-L@RYCI.COM Subject: Oracle ROWID or ROWNUM equivalent in OS/390 DB2? [...] 9409 46 52_Re: Oracle ROWID or ROWNUM equivalent in OS/390 DB2?12_Higgins John25_HigginsJohn@JOHNDEERE.COM31_Tue, 16 Apr 2002 20:52:49 -0500509_iso-8859-1 DB2 added the ROWID data type in V6. It is similar to the Oracle ROWID, but certainly not identical.

The Oracle ROWID is the actual address of the row in an Oracle table. If you reorg the table, the Oracle ROWID changes.

The DB2 ROWID is the "logical" row address. If you reorg the table, you can still refer to the row by the same ROWID; however, it is more complicated than that. While the DB2 ROWID can still be used to access the row, direct access does not survive a reorg. [...] 9456 83 52_Re: Oracle ROWID or ROWNUM equivalent in OS/390 DB2?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 17 Apr 2002 12:22:45 +1000441_US-ASCII Linda,

Since V6, DB2 for OS/390 has had ROWID functionality. However it is slightly different from Oracle's implementation. A summary of the differences are: - (if I understand it correctly) Oracle's ROWID identifies where a row is stored; the ROWID for every row can be selected - DB2's ROWID provides a unique identifier for a row and also its current location; a row only has a ROWID if the table has a ROWID column. [...] 9540 42 37_Re: Most recent Utility on Tablespace14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 16 Apr 2002 21:18:08 -0500473_- Su,

If you really need to find the most recent utility and you've got the archive logs back to then, scan the archive logs (using DSN1LOGP) looking for updates to ts DSNDB01.SYSUTILX containing the db/tsname of your tablespace.

If you need to find when the tablespace (tablepart, tables etc) statistics were last updated, find the rids for the rows that hold that information and scan the logs looking for updates to ts DSNDB06.SYSDBASE at those rids. [...] 9583 66 62_DB2 V7 z/OS Certification Crammer Course to be held in Chicago13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Tue, 16 Apr 2002 22:38:39 -0500350_iso-8859-1 MWDUG (Midwest DB2 Users Group) is offering the UDB DBA V7 Certification Crammer Course taught by Susan Lawson of YL&A, the co-author of the IBM UDB DBA Certification Guide, on Thursday, May 2, 2002.

It will be held at:

Chicago Athletic Association Lakeshore Room, 7th Floor 12 S Michigan Avenue Chicago, Illinois 60603 [...] 9650 15 49_Nasira Latef/O&S/Prudential is out of the office.0_27_nasira.latef@PRUDENTIAL.COM31_Wed, 17 Apr 2002 01:04:05 -0400389_us-ascii I will be out of the office starting 04/17/2002 and will not return until 04/18/2002.

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. 9666 19 15_Re: Data Spaces10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 09:34:22 +0200377_us-ascii Hi

Did u try to set VPSEQT >0 ? There's no room for sequential pages and utilities use it.

HTH

MAx Scarpa

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 9686 18 50_Dave Raiman/Santa Teresa/IBM is out of the office.11_Dave Raiman17_raiman@US.IBM.COM31_Wed, 17 Apr 2002 01:57:08 -0600512_us-ascii I will be out of the office starting April 16, 2002 and will not return until April 19, 2002.

I am on vacation. I will not receive phone mail or email until I return. Please contact my manager, Annmarie O'donnell at 408-463-4280 for urgent issues. --Dave

================================================ 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. 9705 37 26_Re: Strange join sequence?12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Wed, 17 Apr 2002 10:42:06 +0200578_US-ASCII Mike, thanks for your answer.

You're right, table C is roughly the largest, but only about 2 % larger than table B.

We weren't using KEYCARD systematically, so I ran different combinations of KEYCARD and FREQVAL on these 4 tables without being able to change the accespath.

I found a solution by browsing through my old issues of DB2 magazine, in an article from Michael Hannan "hot on the tuning trail" from a 1997 issue. As described in the article, I disabled the filter factor on the new condition on table D by adding OR 0 <> 0. This did [...] 9743 39 28_Re: DB2 OS/390 & UDB on UNIX10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 11:37:20 +0200454_us-ascii Hi Tina

The same here: DB2/CICS availability 98%, UNIX /ORACLE 69%. But I'm told that UNIX/ORACLE costs are half than

host and 'customer satisfaction' is not 'so' important is some areas.

Moreover our managers are almost all from BULL (DPS or UNIX machines), programmers come from a UNIX world

where, if something goes wrong they switch OFF/ON button and all is resolved, they can do all they like as it's THEIR [...] 9783 165 59_Re: DB2 batch job falling over with Soc4 and 00C90101 error12_Noel O'Grady22_noelogrady@HOTMAIL.COM31_Wed, 17 Apr 2002 04:06:07 -0500642_ISO-8859-1 On Thu, 11 Apr 2002 20:20:56 -0500, John Hardy wrote:

>Take a look at APAR PQ58781. It isn't a perfect fit for your problem, but >it looks close (I currently have one very similar). There is a very recent >fix. > > >On Wed, 10 Apr 2002 07:34:08 -0500, Noel O'Grady >wrote: > >>We have a batch job running overnight that is failing with an Soc4 with the >>following error >> >>SYSTEM COMPLETION CODE=04E REASON CODE=00C90101 >>TIME=01.59.46 SEQ=46571 CPU=0044 ASID=0177 >>PSW AT TIME OF ERROR 077C1000 A961FBB6 ILC 2 INTC 0D >> NO ACTIVE MODULE FOUND >> NAME=UNKNOWN [...] 9949 237 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Wed, 17 Apr 2002 07:20:38 -0400385_iso-8859-1 The DFDFREQ parm was also told to me by DB2 development, and by Roger Miller. I do not have the version 7 doc.

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





"Rick Foley" cc: Sent by: "DB2 Subject: Re: LOGONLY recovery of DBD01 Data Base Discussion List" [...] 10187 145 51_Free Webcast live from CA-World in Orlando, Florida14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 17 Apr 2002 12:53:36 +0100648_iso-8859-1 A brief advertisement follows: The Future of Database Management Free Webcast live from CA-World in Orlando, Florida Can't make CA-World? You can still be part of the action. Attend CA's free Webcast and hear from top industry analyst explore the challenges of database management as well as the trends that are driving the double-digit growth in this market space. Mike Thompson, principal analyst from Butler Group, and Richard Bolesta, brand manager from Computer Associates, will provide insight into the future of database management, and how you can prepare for the changes in this dynamic market. We'll look at the Mainframe [...] 10333 89 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v59_Chu, Pius14_ChuP@CONED.COM31_Wed, 17 Apr 2002 08:22:27 -0400467_iso-8859-1 Our DB2 Connect EE Version 7.2 (fix pack 4) is currently working with our DB2 OS/390 Version 5.

The 2 up 1 down relationship is for the DB2 Connect CAE or the administrative client only. On the client you could use the V5.2 CAE or the 7.2 administrative client to go thru DB2 Connect to talk to OS/390 Version 5. If you have 7.2 administrative client and try to go thru DB2 Connect Version 5.2 (not supported), you will get this error message: [...] 10423 92 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Wed, 17 Apr 2002 08:28:45 -0400552_iso-8859-1

John Lendman To: "DB2 Data Base Discussion List" 04/17/02 07:51 AM cc: bcc: Subject: Re: LOGONLY recovery of DBD01









Rick here is the Roger Miller reference that I have









"Roger Miller" To: John_Lendman@fpl.com Subject: Re: HPGRBRBA Question

11/27/01 07:56 PM













One of the changes in V7 was more frequent updates, so that logonly recovery is faster. [...] 10516 18 29_Re: LOGONLY recovery of DBD0110_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 14:42:32 +0200456_us-ascii Is that parameter DFDFREQ (last post) or DLDFREQ (first post)?

I think you mean DLDFREQ (number of checkpoints between LEVELID update) , that is present in V6 as well.

Best 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. 10535 145 33_system catalog/directory recovery11_Daniel Adam16_dadam@GRATEX.COM31_Wed, 17 Apr 2002 07:09:26 -0500621_- Hi, I'm recovering the system catalog/directory in the test subsystem using TOLASTCOPY. I follow the steps described in DB2 Utility Guide and Reference, chapter "Recovering catalog and directory objects": (not in one step of course) RECOVER TABLESPACE DSNDB01.SYSUTILX TOLASTCOPY REBUILD INDEX (ALL) TABLESPACE DSNDB01.SYSUTILX RECOVER TABLESPACE DSNDB01.DBD01 TOLASTCOPY RECOVER TABLESPACE DSNDB06.SYSCOPY TOLASTCOPY REBUILD INDEX (ALL) TABLESPACE DSNDB06.SYSCOPY RECOVER TABLESPACE DSNDB01.SYSLGRNX TOLASTCOPY RECOVER TABLESPACE DSNDB06.SYSDBAUT TOLASTCOPY REBUILD INDEX (ALL) TABLESPACE DSNDB06.SYSDBAUT ...etc [...] 10681 74 37_Re: Most recent Utility on Tablespace13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Wed, 17 Apr 2002 07:53:01 -0500384_iso-8859-1 Hi,

This will not help you now, but if this is an ongoing requirements, you could consider putting a wrapper around DSNUTILB which would read SYSIN and write the control cards to a dataset, it then calls the real DSNUTLIB.

It went something like this ...

1. Rename current DSNUTILB to X 2. Write new program DSNUTILB to read SYSIN and then call X [...] 10756 59 24_Re: Installation of ODBC9_Alex J.P.16_apaulia1@TXU.COM31_Wed, 17 Apr 2002 07:20:08 -0500585_- Hi Judy,

1. We have not found a way to just install the ODBC drivers without installing the whole runtime client, I suppose you could hack it if you had the time and the inclination.

We have our PC support personell do the installation for the runtime client. What we have done is to provide them with a a detailed document on the installation and a small .bat file to perform the cataloging & ODBC registration functions. This proved more efficient as we have more than 1000 clients. This is only for the runtime client and not the Gateway code/Admin/Development [...] 10816 161 37_Re: system catalog/directory recovery11_Daniel Adam16_dadam@GRATEX.COM31_Wed, 17 Apr 2002 07:54:51 -0500340_- Hi, I forgot: this is DB2 V7 on OS/390 v2r10. Also, the job I posted recovers dsndb06.sysdbase as a first step (RECOVER0) - that was just an attempt to resolve the problem - unsuccessful, I might add. Disregard this step please. Thanks, Daniel



On Wed, 17 Apr 2002 07:09:26 -0500, Daniel Adam wrote: [...] 10978 112 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v516_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Wed, 17 Apr 2002 09:18:57 -0400522_iso-8859-1 Thanks for the clarification. That is the message we received. I am not sure what client/connect combination we had at the time as that is supported by one of the LAN or Client/Server groups (my group has no LAN or UNIX or non-mainframe administrative authorities).

Regards, eric pearson





-----Original Message----- From: Chu, Pius [mailto:ChuP@CONED.COM] Sent: Wednesday, April 17, 2002 8:22 AM To: DB2-L@RYCI.COM Subject: Re: Problem with UDB 7.2 connecting to DB2 OS/390 v5 [...] 11091 241 27_MVS error code 104-204 VSAM16_Fields, Janice G19_jfields@INDIANA.EDU31_Wed, 17 Apr 2002 08:19:50 -0500566_- We're recently upgraded to V6 and are a OS/390 shop. On the sdsf log, we're been receiving these 104-204 messages on various tables and indexes. None of these messages have made it to the DB2 production log. I'm curious if I need to be concerned with this message code. According to the MVS manual, this message for VSAM usually means an out-of-extent error or out-of-space error. Neither of these are the case, as I have other volumes allocated for the stogroup with space and the vsam files aren't in > 10 extents. Has anyone seen this message as a problem [...] 11333 58 29_Re: LOGONLY recovery of DBD010_20_John_Lendman@FPL.COM31_Wed, 17 Apr 2002 09:22:24 -0400463_us-ascii Yes

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





"Max Scarpa" cc: Sent by: "DB2 Subject: Re: LOGONLY recovery of DBD01 Data Base Discussion List"



04/17/02 08:42 AM Please respond to "DB2 Data Base Discussion List"











Is that parameter DFDFREQ (last post) or DLDFREQ (first post)? [...] 11392 239 37_Re: Most recent Utility on Tablespace13_Martin Packer24_martin_packer@UK.IBM.COM31_Wed, 17 Apr 2002 14:29:59 +0100292_us-ascii Funnily enough I'm just adding to our code the most recent time STOSPACE was run for a tablespace / index space. My brief research yesterday suggested that column STATSTIME in SYSSTOGROUP would give me that. Of course that implies a join to resolve it for a particular ts / is. [...] 11632 90 44_Re: AW: What's the name of the SAS-DB2 plan?13_D'hoine Frank19_Frank.Dhoine@NBB.BE31_Wed, 17 Apr 2002 15:31:54 +0200309_iso-8859-1 The plan name is in the DBRM pds member(SAS82), IMHO you must edit this at least to match your new planname. But SAS may have a difficulty, you need different plan names for different SAS versions if you want to run sas82 and sas609 side by side. (Your SAS support will know more about this.) [...] 11723 16 53_Restore TS with a Full Copy not referenced in SYSCOPY8_NguyenDT30_duc.nguyen@EUROCLEARFRANCE.COM31_Wed, 17 Apr 2002 08:22:12 -0500304_- This happens in my test environment and i can easily recreate the table so it is not a real problem , but i just want to know. I want to restore a partitioned table space , but what i have is just an old Full Image Copy not referenced anymore in SYSCOPY. I suppose that i can do nothing with it ? [...] 11740 51 36_Display thread, connection status TD12_Claude Birtz24_Claude.Birtz@CIE.ETAT.LU31_Wed, 17 Apr 2002 15:57:53 +0200446_US-ASCII Hi list,

I found a similar question, dated october 2001 in the archives, but no answer, so here I go:

System is DB2 V7, zOS 1.3. When I execute a display thread command on a test system I saw a TD connection status:

DSNV402I +DB2S ACTIVE THREADS - 267 NAME ST A REQ ID AUTHID PLAN ASID TOKEN RRSAF T 6 CB390 CBASRU2 ?RRSAF 0058 11 RRSAF TD 13 WASASR2S CBASRU2 DSNJDBC 0058 29 (... etc 6 threads with status TD) [...] 11792 22 31_Re: MVS error code 104-204 VSAM10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 16:04:03 +0200339_us-ascii It's a EOV message for DB2 LDS datasets under SMS, but the problems is self-managed and resolved without any intervention.

For sure you can see, executing a LISTCAT on LDS, that it's allocated on different volumes. Check the SECQTY of your

TSs, may be it's too large. I meet sometimes this error during reorgs. [...] 11815 14 29_Re: LOGONLY recovery of DBD0110_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 16:05:25 +0200310_us-ascii Thanks John for your reply & best 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. 11830 129 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 17 Apr 2002 14:56:03 +0100387_iso-8859-1 If you can re-create the tablespace EXACTLY the way it was when the copy was taken, then you can use DSN1COPY to do the restore of the data

Unfortunately, once things are removed from SYSCOPY they are gone from DB2 recovery mechanism forever. This is one of the reasons why CAs Merge/Modify product allows you to INSERT records into SYSCOPY as well as REMOVE them [...] 11960 31 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY0_22_Rohn.Solecki@MTS.MB.CA31_Wed, 17 Apr 2002 09:10:42 -0500366_us-ascii You can use DSN1COPY to load data from an old image copy, and use DSN1PRNT to extract the 'old' object ID numbers from the image copy to use as input in thte DSN1COPY job.









NguyenDT @RYCI.COM> on 2002/04/17 08:22:12 AM Subject: Restore TS with a Full Copy not referenced in SYSCOPY [...] 11992 66 31_Re: MVS error code 104-204 VSAM14_Richard Ruppel18_r_ruppel@YAHOO.COM31_Wed, 17 Apr 2002 07:13:35 -0700331_us-ascii Is it possible that there is a password on one of the VSAM files?

One of the changes for V6 was to stop supporting passwords on datasets. You can run these queries to check: SELECT CREATOR, NAME FROM SYSIBM.SYSINDEXES WHERE DSETPASS <> ‘ ‘; SELECT DBNAME, NAME FROM SYSIBM.SYSTABLESPACE WHERE DSETPASS <> ‘ ‘; [...] 12059 45 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY14_Richard Ruppel18_r_ruppel@YAHOO.COM31_Wed, 17 Apr 2002 07:19:48 -0700561_us-ascii If your OS/390, you can run DSN1COPY. Another option is to use a 3rd party tool (Platinum's FastUnload for example) to "unload" the image copy into a load format and then reload the data with a normal IBM load utility.

Richard Ruppel DBA Georgia Department of Revenue

--- NguyenDT wrote: > This happens in my test environment and i can easily > recreate the table so > it is not a real problem , but i just want to know. > I want to restore a partitioned table space , but > what i have is just an > [...] 12105 42 51_UDB - Authorizations for Load Utility with COPY YES14_Bill Gallagher28_BILL.GALLAGHER@PHOENIXWM.COM31_Wed, 17 Apr 2002 10:25:04 -0400527_us-ascii We're running UDB v7.2 fixpack 5 on AIX 4.3.3.

There's a little confusion on our part about exactly what level of UDB authority is required to run a LOAD utility with the COPY YES parameter.

We have a userid that is set up with LOAD authority on the database, and all the appropriate table authorities for all the tables in the database. The documentation specifies that this is the authorization that is required to run the load utility (as an alternative to possessing sysadm or dbadm authority). [...] 12148 71 43_recover directory and catalog with DSN1COPY41_=?iso-8859-9?Q?Serdar_Sabri_=D6ZKUBULAY?=29_Serdar.Ozkubulay@AKNET.COM.TR31_Wed, 17 Apr 2002 17:40:11 +0300367_iso-8859-9 I am trying to recover directory and catalog (DSNDB01 and DSNDB06 tablespaces and indexes) via DSN1COPY from full image copies. But when I run a rebuild or repair utility against directory and catalog tablespaces it fails with "REASON 00C20110" for DSNDB01.DSNLUX01.

Did anyone try this before? (Don't panic, it's for system programming DB2 :) [...] 12220 42 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Wed, 17 Apr 2002 09:41:59 -0500424_iso-8859-1 You can use the BMC RECOVER PLUS for DB2* DROPRECOVERY feature to recover the table space *and* apply any log records between the copy and the time it was dropped. There are several alternatives to restoring the data to the point of the image copy that others have already described. In a production environment, though, you may need to apply log records (especially if it was a SHRLEVEL CHANGE image copy). [...] 12263 185 37_Re: system catalog/directory recovery11_Daniel Adam16_dadam@GRATEX.COM31_Wed, 17 Apr 2002 09:19:32 -0500320_- Hi, I've said this before - it takes less than 1 hour to solve anything - just post the problem to a forum full of experienced & skilled people. :o)

I circumvented the problem with configuration parameter LEVEL UPDATE FREQ on the installation panel DSNTIPL - I set it to 0 to disable down-level detection. [...] 12449 114 37_Re: system catalog/directory recovery0_18_mebert@AMADEUS.NET31_Wed, 17 Apr 2002 16:55:07 +0200421_us-ascii You have to be Install SYSADM or Install SYSOPR to bypass authorisation checking in certain circumstances. This is the case if TSs SYSDBASE or SYSUSER are really unavailable because you've DELETE/DEFINEd the Cluster, or they're STOPped. See "Recovering Critical Catalog Table Spaces" in the Utility Guide.

Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany [...] 12564 61 47_Re: recover directory and catalog with DSN1COPY0_18_mebert@AMADEUS.NET31_Wed, 17 Apr 2002 17:01:08 +0200513_us-ascii Check the APAR database, especially PQ37806, or other hits (search for 00C20110 and/or RC00C20110).

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







I am trying to recover directory and catalog (DSNDB01 and DSNDB06 tablespaces and indexes) via DSN1COPY from full image copies. But when I run a rebuild or repair utility against directory and catalog tablespaces it fails with "REASON 00C20110" for DSNDB01.DSNLUX01. [...] 12626 125 47_Re: recover directory and catalog with DSN1COPY0_18_mebert@AMADEUS.NET31_Wed, 17 Apr 2002 17:05:06 +0200411_us-ascii PS. I really wouldn't recommend basing a Cat/Dir Recovery procedure on DSN1COPY. If you want to clone an existing system for test purposes, use a procedure based on e.g. ADRDSSU.

MfG, ME. ----- Forwarded by Michael Ebert/MUC/AMADEUS on 17/04/02 17:01 ----- From: Michael Ebert (ADP/DS/SO/SOD) on 17/04/2002 17:01





To : DB2 Data Base Discussion List - [...] 12752 15 47_Re: recover directory and catalog with DSN1COPY10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 17 Apr 2002 17:10:30 +0200372_us-ascii DSNLUX01 (and 02) is an index of SYSUTILX tablespace. Did you rebuild the indexes of that tablespace ??

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. 12768 16 43_Re: Refreshing DB2 database from MS SQL200012_Roger Miller19_millerrl@US.IBM.COM31_Wed, 17 Apr 2002 09:49:03 -0500343_- That is the design point for the DB2 family cross loader, being able to use DRDA to get the data and the LOAD utility to put it into DB2 tables. The DB2 Connect and Relational Connect or DataJoiner gets us to the SQL Server data. For z/OS and OS/390, you have this function in V7 utilities. For UNIX & Windows, it's coming fairly soon. [...] 12785 62 37_Re: system catalog/directory recovery11_Daniel Adam16_dadam@GRATEX.COM31_Wed, 17 Apr 2002 09:56:49 -0500683_- Michael, I ran the job under sysadm - that's our install SYSADM authority. Thanks, Daniel

On Wed, 17 Apr 2002 16:55:07 +0200, mebert@AMADEUS.NET wrote:

>You have to be Install SYSADM or Install SYSOPR to bypass authorisation >checking in certain circumstances. This is the case if TSs SYSDBASE or >SYSUSER are really unavailable because you've DELETE/DEFINEd the Cluster, >or they're STOPped. See "Recovering Critical Catalog Table Spaces" in the >Utility Guide. > >Dr. Michael Ebert >DB2 Database Administrator >aMaDEUS Data Processing >Erding / Munich, Germany > > > > >Hi, >I'm recovering the system catalog/directory in the test subsystem using >TOLASTCOPY. [...] 12848 59 32_Re: What ERLY code am I running?15_Peter Nancollis16_pnancoll@CSC.COM31_Wed, 17 Apr 2002 16:16:56 +0100332_us-ascii What ho ! Tried to follow J Eden's route through the SCOM, RIB route - Boing ! Dont know if this is any use...... but hey use and abuse ttfn



/* Rexx */ /* PROGRAM - DB2ERLY */ /* Coded - Nanc */ /* Date - April MMII */ /* PUPOSE - Mod level of DB2 ERLY code */ /* */ /* */ Arg db2ssid Numeric digits 10 [...] 12908 149 44_Re: AW: What's the name of the SAS-DB2 plan?13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Wed, 17 Apr 2002 10:44:36 -0500552_iso-8859-1 if there is a single place to specify the plan, you could consider creating a SAS plan and for each release either ... 1. Precompile and bind in the new DBRM with version(auto) (if possible) or

2. Create a SAS plan using packages via the PKLIST. Each new release alter the PLAN and add the new PKLIST collection which contains the new release, and bind the new DBRM into the new package. That will mean all versions can use the same PLAN name. After a while (or on next release) cleanup the PKLIST and remove old PKLIST entries. [...] 13058 77 31_Re: MVS error code 104-204 VSAM10_Missy Case28_Missy.Case@FIRSTDATACORP.COM31_Wed, 17 Apr 2002 10:57:04 -0500282_us-ascii Janice,

This is NOT a DB2 error, altho it will show up in the DB2 address space stuff. This is an OS/390 fix. I saw this many months ago & finally remembered what it was. It is end of volume algorithm processing that OS 390 needs a patch (or many patches) for. [...] 13136 31 14_SQL0805N error16_Iqbal Goralwalla26_igoralwalla@PHARMOLOGY.COM31_Wed, 17 Apr 2002 17:21:22 +0100483_iso-8859-1 Hi all:



We recently patched our db2 servers to 7.2.3 on AIX. I am having problems when trying to access the tables from an NT client with the following error:



SQL0805N Package "NULLID.SQLC2D01" was not found. SQLSTATE=51002

I had the same problem before, and I bound db2ubind.lst and db2cli.lst on the server. It worked that time. However, this time, the problem persists even after I successfully perform the bind on the server. [...] 13168 45 22_high service wait time16_Alison Pelletier17_ap84098@YAHOO.COM31_Wed, 17 Apr 2002 09:32:11 -0700589_us-ascii We are DB2 OS/390 V6. We have an online transaction that executes approx. 200K selects, 200K inserts, 5K updates and 2K open/fetch cursor per day. According to omegamon hist. stats, the in db2 time is 13,840 sec. Of that 6,243 sec. is attributed to service wait time and 7,143 sec is attributed to IO wait time. Is the service wait time considered high? I thought so, so I checked all mentioned reasons from history threads on this subject. No extents. No DFHSM recall. No open/close often. The inserts are random to 128 partitions. The TS is online reorged (with preformat) [...] 13214 70 18_Re: SQL0805N error12_Stan Goodwin29_STANLEY_GOODWIN@MECH.DISA.MIL31_Wed, 17 Apr 2002 13:16:25 -0400525_us-ascii Was the server checked to see if the package was there and if so what was it's status.

Stan Goodwin Defense Enterprise Computing Center (DECC) Mechanicsburg DB2 Support

Stanley_goodwin@mech.disa.mil DSN: 430-4335 Outside:- 717-605-4335







Iqbal Goralwalla cc: Sent by: DB2 Data Subject: SQL0805N error Base Discussion List



04/17/2002 12:21 Please respond to DB2 Data Base Discussion List [...] 13285 28 11_DDL Logging15_Mike Brauweiler22_MikeBrau@ALUMNI.ND.EDU31_Wed, 17 Apr 2002 12:18:29 -0500425_iso-8859-1 I am running DB2/UDB V6.1 on OS/390 R 2.8. I have a DDL deck that creates approx. 200 tables, and approx. 500 indexes, all using STOGROUPs and "DEFINE NO". When I run this as a batch job on OS/390 (using DSNTEP2 -or- DSNTIAD -or- SPUFI), I fill approx. 12% of my active DSLOG. If, on the other hand, I run this identical deck from a workstation using DB2 Connect (V7.1), I fill nearly 50% of my active DSLOG. [...] 13314 73 32_Re: What ERLY code am I running?13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 17 Apr 2002 12:28:49 -0500411_iso-8859-1 Love it. Tried it. But don't have your 'stg' function.

-----Original Message----- From: Peter Nancollis [mailto:pnancoll@CSC.COM] Sent: Wednesday, April 17, 2002 10:17 AM To: DB2-L@RYCI.COM Subject: Re: What ERLY code am I running?



What ho ! Tried to follow J Eden's route through the SCOM, RIB route - Boing ! Dont know if this is any use...... but hey use and abuse ttfn [...] 13388 69 18_Re: SQL0805N error0_20_John_Lendman@FPL.COM31_Wed, 17 Apr 2002 13:29:55 -0400430_us-ascii I received this same error on a DB2 6.1 NT version. But it only happen once to me, and then went away. If any one know what is happening please let us know.

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





"Iqbal Goralwalla" cc: Sent by: "DB2 Data Subject: SQL0805N error Base Discussion List" [...] 13458 87 26_Re: high service wait time13_Martin Packer24_martin_packer@UK.IBM.COM31_Wed, 17 Apr 2002 18:31:58 +0100409_us-ascii As you are on Version 6 you can break out the DB2 Services Wait time into a number of components. Look at the mapping of DSNDQWAX (I think they're in there rather than DSNDQWAC) for the buckets. That should narrow it down.

(I assume you haven't done yet as the tone of your contribution seemed like it was based on your understanding of the app rather than the numbers in these buckets.) [...] 13546 50 18_Re: SQL0805N error13_Shapiro, Dave26_Shapiro.Dave@PRINCIPAL.COM31_Wed, 17 Apr 2002 12:37:05 -0500368_iso-8859-1 Iqbal,

For host connectivity this package is somewhere in a bnd file within sqllib\bnd\ddcsmvs.lst. You don't mention where the tables are that you want to access, but if not the host, look inside the bnd files within the various available lst files for the package name. Or is it possible that your bind failed for the package for some reason? [...] 13597 29 9_CA Modify14_RICHARD MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Wed, 17 Apr 2002 12:38:58 -0500404_US-ASCII DB2 Mainframers,

Can anyone provide feedback (i.e., good, bad, or indifferent) on CA/Platinum's modify utility as a replacement for IBM's stellar tool?

I'm very interested in hearing from "large shop" types (e.g., those employing heavy datasharing, WLM - running on zOS and/or OS390).

Please, no vendor hyperbole wanted - True IT DB2 sysprog / DBA's, only, need reply! [...] 13627 53 30_NLS using UTF-8 inconsistences15_Jackson Reavill18_damcon2@US.IBM.COM31_Wed, 17 Apr 2002 14:16:22 -0400602_iso-8859-1 Hello everyone,

I'm wondering if we really have a problem or it's just an interface issue? We're running DB2 V7.2 on AIX using codeset UTF-8. Depending on what interface we use we get a different representation of some international symbols such as the Euro. When viewing thru a browser (Netscape or IE) after setting the JAVA character set to UTF-8 the Euro displays correctly, but when looking at the IE browser source we see a solid block in place of the Euro. Netscape source is fine. Also, when viewing thru the command center or telnet we see various representations, most [...] 13681 90 32_Re: What ERLY code am I running?21_Powers, Carol A - CNF20_Powers.Carol@CNF.COM31_Wed, 17 Apr 2002 11:25:53 -0700296_iso-8859-1 I tried it and it works great. What's nice about it is that you know for sure what you're really running instead of having to guess the library based on what's in the linklist. The ptr and stg functions are defined at the bottom of Peter's routine - did you clip the whole thing? [...] 13772 91 32_Re: What ERLY code am I running?15_Robert Lawrence21_rlawrence@BOSCOVS.COM31_Wed, 17 Apr 2002 14:28:46 -0400587_iso-8859-1 If you cut and pasted the code you missed the last line of code

> -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of > Jeremiah Eden > Sent: Wednesday, April 17, 2002 1:29 PM > To: DB2-L@RYCI.COM > Subject: Re: What ERLY code am I running? > > > Love it. Tried it. But don't have your 'stg' function. > > -----Original Message----- > From: Peter Nancollis [mailto:pnancoll@CSC.COM] > Sent: Wednesday, April 17, 2002 10:17 AM > To: DB2-L@RYCI.COM > Subject: Re: What ERLY code am I running? > > > What ho ! > Tried [...] 13864 26 34_Distributed address space cpu time8_Ron Root24_ron.root@CPA.STATE.TX.US31_Wed, 17 Apr 2002 13:45:56 -0500596_iso-8859-1 Does anyone understand the cpu time charged to the originating DB2DIST address space?

In our case we have adhoc users running queries in DSNQ against data in DSNP via a DDF connection. We see cpu time in the DSNPDIST address space (and in the DSNP accounting records) as expected. To our surprise,some queries show an almost equal amount of time in the DSNQ accounting records (and the DSNQDIST address space). When these queries are run directly against DSNP, about 60% of the cpu time from DSNQ is reclaimed. I expected almost 100% to go away. What is happening to cause [...] 13891 78 30_Re: Db2 abend 04e. Help !!!!!!30_Monica Maria Pinheiro e Coelho36_monica.coelho@BRADESCOSEGUROS.COM.BR31_Wed, 17 Apr 2002 16:03:29 -0300335_iso-8859-1 Thank you for all the replies. We were running out of memory in the private area. We increased our Region Size, and everything is ok now.

Thank you all.

Mônica Coęlho Depto Suporte Sistemas - DBDC Bradesco Seguros S/A Tel.: (0xx21) 2503-1422 Fax: (0xx21) 2503-1936 e-mail : monica.coelho@bradescoseguros.com.br 13970 41 46_Migration from DB2 V5 to V7 on OS/390 platform13_Judi Westcott23_judi_westcott@YAHOO.COM31_Wed, 17 Apr 2002 13:43:14 -0500338_- Hello

We are in the initial stages of investigating and costing the adventure of migrating from DB2 V5 to DB2 V7.

We are a midsize shop and do not run DB2 in an SMP/E environment.

From back postings it looks like it is a relatively smooth journey if V5 maintenance is up to date and instructions are followed. [...] 14012 49 13_Re: CA Modify9_Rob Crane22_racrane@CONCENTRIC.NET31_Wed, 17 Apr 2002 13:45:14 -0600358_iso-8859-1 Unicenter Merge/Modify has worked fine for me. Why not trial the product so you can do your own head to head comparison at your shop.

Incase you have not been able to play around with it here are some of the more useful things it can do in addition to the general goal of processing the logs and copies to speed up your recovery time. [...] 14062 16 53_Debra Jordan/Riverwoods/BT/DFSI is out of the office.15_Debra D. Jordan33_debrajordan@DISCOVERFINANCIAL.COM31_Wed, 17 Apr 2002 14:31:26 -0500467_us-ascii I will be out of the office starting 04/17/2002 and will not return until 04/18/2002.

I will be out of the office for the remainder of the day. For datamanagement assistance, please contact Dona Bell at x2822.

================================================ 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. 14079 22 26_Summary Tables and Logging16_Victor McDonnell31_victor_mcdonnell@FREDDIEMAC.COM31_Wed, 17 Apr 2002 15:57:11 -0400493_us-ascii Hello, List! A simple question, please. Does a refresh of a Summary table log? We're running UDB 7.2 on AIX.

tia,

Victor McDonnell Database Administration Data Architecture & Infrastructure Email: victor_mcdonnell@freddiemac.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 14102 124 30_Re: Db2 abend 04e. Help !!!!!!8_Ron Root24_ron.root@CPA.STATE.TX.US31_Wed, 17 Apr 2002 15:04:08 -0500646_iso-8859-1 Re: Db2 abend 04e. Help !!!!!!There is a good article in the IDUG Solutions Journal (Spring 2000 - Vol 7, numbre 1) titled DB2 UDB for Os/390 Storage Management. It discusses the private storage area issue and has some good suggestions for reducing private storage usage. Aimed at V6 as there are have been some things done in V7 to address the problem. www.idug.org/member/journal/mar00/storage.cfm. -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM]On Behalf Of Monica Maria Pinheiro e Coelho Sent: Wednesday, April 17, 2002 2:03 PM To: DB2-L@RYCI.COM Subject: Re: Db2 abend 04e. Help !!!!!! [...] 14227 43 15_Re: Data Spaces24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Wed, 17 Apr 2002 13:14:29 -0700447_- Hi Max!

Yes, we did try it, and the image copy completed successfully. However, the image copy had completed successfully twice since converting to data spaces. It also failed twice. Our software support people are looking for known problems with similar symptoms with IBM. And until we can get a reasonable understanding of the problem, we're not likely to move forward with using data spaces, since that was the last known change. [...] 14271 105 32_Re: What ERLY code am I running?13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Wed, 17 Apr 2002 15:18:07 -0500610_iso-8859-1 Thanks. I missed the last line. I guess it's because old Control Block Jockey Dump Dogs rarely see source of any kind.

-----Original Message----- From: Powers, Carol A - CNF [mailto:Powers.Carol@CNF.COM] Sent: Wednesday, April 17, 2002 1:26 PM To: DB2-L@RYCI.COM Subject: Re: What ERLY code am I running?



I tried it and it works great. What's nice about it is that you know for sure what you're really running instead of having to guess the library based on what's in the linklist. The ptr and stg functions are defined at the bottom of Peter's routine - did you clip the [...] 14377 103 44_Re: AW: What's the name of the SAS-DB2 plan?18_Ermanno Bertolotti30_ErmannoBertolotti@INTESABCI.IT31_Wed, 17 Apr 2002 22:35:30 +0200 14481 33 33_quote vs. apost in DB2 for OS/39011_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Wed, 17 Apr 2002 15:39:19 -0500559_iso-8859-1 Out of curiosity, how many people use quote and how many use apostrophe as the delimiter for their static SQL, and does that match your default setting in DSNHDECP? We have one application that uses quote and the others all use apostrophe. Yet we specify DEFAULT (which is quote) for the delimiter in DSNHDECP (keywords DELIM & SQLDELI). My previous employer used apostrophe even though the default was set to quote. It got me wondering how many other people have the default set to quote, but override it on the precompile to use apostrophe. [...] 14515 44 43_Re: Refreshing DB2 database from MS SQL200014_Edward P. Long19_RDHM99A@PRODIGY.NET31_Wed, 17 Apr 2002 16:47:25 -0500519_- We have the enabling PTF's on to get CS loader to work. However when we try to run the loader I get, DSNU82I Invalid keyword EXEC The cards look like EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM D42E2.DCMTABLE ENDEXEC LOAD LOG NO RESUME NO REPLACE INCURSOR(C1) INTO D42P2.DCMTABLE. We are 'entitled' to use the entire utility suite. Normal loads work fine. Any suggestions? --- Original Message --- From: Roger Miller To: DB2-L@RYCI.COM Subject: Re: Refreshing DB2 database from MS SQL2000 [...] 14560 50 64_Re: [DB2EUG] UDB - Authorizations for Load Utility with COPY YES16_Ian D. Bjorhovde23_ianbjor@MOBILEAUDIO.COM31_Wed, 17 Apr 2002 16:35:11 -0700571_us-ascii BILL.GALLAGHER@phoenixwm.com wrote: > We're running UDB v7.2 fixpack 5 on AIX 4.3.3. > > There's a little confusion on our part about exactly what level of UDB > authority is required to run a LOAD utility with the COPY YES parameter. > > We have a userid that is set up with LOAD authority on the database, and > all the appropriate table authorities for all the tables in the database. > The documentation specifies that this is the authorization that is required > to run the load utility (as an alternative to possessing sysadm or dbadm > authority). > [...] 14611 84 32_Re: What ERLY code am I running?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Thu, 18 Apr 2002 11:56:45 +1200454_us-ascii Tried it and loved it too. I've added it to the collection of small but useful little REXXs/Clists I've picked up on my travels. Good stuff.



Raymond







Jeremiah Eden cc: Sent by: DB2 Data Subject: Re: What ERLY code am I running? Base Discussion List



18/04/02 08:18 Please respond to DB2 Data Base Discussion List [...] 14696 44 19_UDB/NT Import error14_Randall Ibbott22_randall.ibbott@QBE.COM31_Thu, 18 Apr 2002 09:41:08 +1000437_us-ascii Guys, (I posted this the other day, but not sure if it actually made it to the list - if it did, my apologies!)

I have exported a number of LOBs in separate files in IXF format. I then attempt to load them using the following command:

DB2 IMPORT FROM E:\Database\TREPDETL OF IXF LOBS FROM e:\blob2 MODIFIED BY lobsinfile indexschema=TSDRMI MESSAGES e:\database\trepmsgi.txt INSERT INTO TSDRMI.TREPORT_DETAIL2 [...] 14741 82 15_Re: DDL Logging16_Swinski, Kenneth23_KSwinski@MASSMUTUAL.COM31_Wed, 17 Apr 2002 20:40:54 -0400590_iso-8859-1 I'll take a shot. Could it be that AUTOCOMMIT is off in db2cli.ini, even though the default is AUTOCOMMIT on? Here's the description from the ODBC Guide:

AUTOCOMMIT = 1 | 0 This keyword is placed in the data source section. To be consistent with ODBC, DB2 ODBC defaults with AUTOCOMMIT on, which means each statement is treated as a single, complete transaction. This keyword can provide an alternative default, but is only used if the application does not specify a value for AUTOCOMMIT as part of the program. 1 = on (default) 0 = off Most ODBC applications assume [...] 14824 15 49_Leon Katsnelson/Toronto/IBM is out of the office.0_15_leon@CA.IBM.COM31_Wed, 17 Apr 2002 21:18:49 -0400397_us-ascii I will be out of the office starting April 16, 2002 and will not return until April 22, 2002.

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. 14840 37 22_Can I stop a DB2 query13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Wed, 17 Apr 2002 22:59:28 -0500466_us-ascii Hi... we're are DB2 v6 on OS/390

We have a PC standalone application with the functionality of doing wildcard searches. This application is on the User's desktop, which connects to the mainframe via MQ Series channel tabs and a CICS bridge..

Now if a user requests a name search (i.e. FRANK****) This Transaction will invoke the 3rd level db2 program with the query... open cursor, and fetch row where last name like ('FRANK%%%%%) ...... [...] 14878 66 15_Re: DDL Logging14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Apr 2002 14:10:38 +1000318_US-ASCII Mike

I'll take the opposite shot: autocommit is on.

When a database is modified (eg any ALTER, CREATE or DROP on an object in the database), DB2 logs the entire DBD - before and after images. In V6 and later it does this once a transaction. (Prior to V6 it did this for each modification.) [...] 14945 58 23_Re: UDB/NT Import error14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Apr 2002 14:59:46 +1000614_US-ASCII DB2 IMPORT ... LOBS FROM e:\blob2\ ...

Note the trailing slash.

James Campbell



On 18 Apr 2002 at 9:41, Randall Ibbott wrote:

> Guys, (I posted this the other day, but not sure if it actually made it to the > list - if it did, my apologies!) > > I have exported a number of LOBs in separate files in IXF format. I then > attempt to load them using the following command: > > DB2 IMPORT FROM E:\Database\TREPDETL OF IXF LOBS FROM e:\blob2 MODIFIED BY > lobsinfile indexschema=TSDRMI MESSAGES e:\database\trepmsgi.txt INSERT INTO > TSDRMI.TREPORT_DETAIL2 > > and get [...] 15004 43 26_Re: Strange join sequence?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 18 Apr 2002 14:59:47 +1000410_US-ASCII Claude

The only officially recognised methods for disabling index usage are: - expression +/- 0 - expression *// 1 - expression concat '' (see V7 Admin Guide, 5.8.3.2 Summary of predicate processing, Note 9). Any others, such as "OR 0<>0", are liable (at some time in the future) to be recognised by the optimiser as never capable of being true and ignored - turning indexability back on. [...] 15048 48 26_Re: Strange join sequence?14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Thu, 18 Apr 2002 07:45:35 +0200 15097 38 17_DSN1COPY problems11_David Nance16_DWNance@FHSC.COM31_Thu, 18 Apr 2002 01:45:00 -0400664_US-ASCII I am trying to recover a table that was dropped. I have an image copy from a day before the drop. I am running DSN1COPY using the following parms 'CHECK,FULLCOPY,OBIDXLAT,RESET' this completes successfully(return code 0). I restart the tablespace and no matter what I do I recieve the following abend: DSNI014I -DBT1 DSNISNPG DATA IN USE DURING ABEND REASON 00C90101 ERQUAL 5010 TYPE 00000302 NAME DDSNCPY .SDSNCPY .X'00000001' CONNECTION-ID=UTILITY CORRELATION-ID=A9139IDX LUW-ID=* I have tried running rebuild on the index, not having the index then attempting to create one, repairing the levelid, and quite a few other attempts. Does anyone else [...] 15136 147 30_Re: Database Marked as Damaged11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Thu, 18 Apr 2002 09:25:49 +0300333_iso-8859-7 Hello Katharine! I once had that that problem with DB2 V6 (FP7 or 8) on NT and the solution was to recover the db. Our case was that we had our logfiles on a network drive and after some communication problems we experienced, the crash recovery of the db could not be performed and the db was marked as damaged. HTH, [...] 15284 73 21_Re: DSN1COPY problems13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Thu, 18 Apr 2002 16:35:30 +1000689_us-ascii Did you recreate SDSNCPY exactly as it was before it was dropped ? Make sure it has the correct tablespace type i.e. Simple or segmented or partitioned.

Shaun

-----Original Message----- From: David Nance [mailto:DWNance@FHSC.COM] Sent: Thursday, April 18, 2002 3:45 PM To: DB2-L@RYCI.COM Subject: DSN1COPY problems



I am trying to recover a table that was dropped. I have an image copy from a day before the drop. I am running DSN1COPY using the following parms 'CHECK,FULLCOPY,OBIDXLAT,RESET' this completes successfully(return code 0). I restart the tablespace and no matter what I do I recieve the following abend: DSNI014I -DBT1 DSNISNPG DATA [...] 15358 19 21_Re: DSN1COPY problems10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 18 Apr 2002 08:45:12 +0200462_us-ascii When do you get this error ? Executing an SQL on the table, rebuilding the index(es) ? Are you sure that there was not an

utility stopped when you drop the table ?

Just to know...

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. 15378 81 21_Re: DSN1COPY problems14_Palgrave, Greg31_greg.palgrave@UNISYSWEST.COM.AU31_Thu, 18 Apr 2002 17:03:45 +1000563_iso-8859-1 David,

The tablespace and table structures have to be recreated *exactly* as they were prior to the drop. Tablespace segsize etc must match. I don't think PRIQTY etc is critical.

A common error is to have a table that has been ALTERed to add a column, but has not yet been reorged. In this case you must recreate the table using the same sequence of events i.e. create a new table, ALTER ADD Column, and then DSN1COPY into it. If you were to instead create the new table with all columns initially, you would get the error you show. [...] 15460 91 23_Re: UDB/NT Import error14_Randall Ibbott22_randall.ibbott@QBE.COM31_Thu, 18 Apr 2002 16:55:56 +1000286_us-ascii James,

Thanks for that... I am actually trying to get LOBS to load to OS/390 and was attempting it on an NT flavour first. As you can't inport in the control centre I simply copied the command generated to run in the CLP and ended up with a very ambiguous message. [...] 15552 23 15_Re: Data Spaces10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 18 Apr 2002 09:49:29 +0200347_us-ascii Hi Fritz

I had this BP full problem sometimes in our test environment and when VPSEQT was 0; putting VPSEQT > 0 (30/40%) we resolved the problem. Sorry, I tried to help you.....

But what about lookaside BP ? Let me know if your software support people will find something about this problem. I never stop learning..... [...] 15576 200 59_Re: DB2 batch job falling over with Soc4 and 00C90101 error10_John Hardy25_john_hardy@ALLIANZ.COM.AU31_Thu, 18 Apr 2002 02:25:10 -0500575_ISO-8859-1 This one's just for the record (in case somebody searches the archives for an occurrence of this problem).

We have an application which updates a column in the partitioning keys of many tables, all but one being done by triggers. The 00C90101 always occurred after Lock Escalation occurred.

All the available fixes for APARs sounding close were applied, to no effect. Commit logic was introduced so that Lock Escalation was prevented, and the problem disappeared (to be replaced with mysterious 00C200EA abends, but that's a different problem). [...] 15777 30 34_Creating Database from backup file12_saima jelani19_saaiima@HOTMAIL.COM31_Thu, 18 Apr 2002 08:46:13 +0000557_- Hello I have created database in DB2 Server, and then took its backup using directories/tapes option using the Command Control Center Interface. Now i want to create a new database from this backup file into another DB2 Server not the same where original DB is created. I created the DB by clicking on create Database from backup , and specify the database name, in the Backup page i click on the Manualy check box and specify the name of directory where i have the back folder, which contain IIN.0, where IIN is the name of old DB and also speciied [...] 15808 13 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY8_NguyenDT30_duc.nguyen@EUROCLEARFRANCE.COM31_Thu, 18 Apr 2002 03:25:30 -0500474_- The thing i've mentioned is that it is a partitioned TS , and all i have is an all partitions Full Copy file . So i think that DSN1COPY won't work in this case because how to say that there is only one input and several output ...

================================================ 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. 15822 61 17_Query explanation13_Sandeep Simon33_Sandeep.S.Alumootil@UKTRANSCO.COM31_Thu, 18 Apr 2002 10:08:28 +0100769_- Dear All,

Could somebody explain what will be populated into the host variable WW-NULL-VALUE SELECT MIN(EFF_DT) INTO :DCLMSBADT.EFF-DT:WW-NULL-VALUE FROM MSBADT WHERE MEAS_STATN_NBR = :WW-NEW-MEAS-STATN-NBR AND EFF_DT > :PXCML001-EFF-DT shed some light on this..

Thanks and Regards,

Sandeep Simon Alumootil ATLink Application Support Mobile: 07785725302 Off: 01455 892062 (Internal 715 32062)



______________________________________________________________________

The views expressed in this email are not necessarily the views of Transco plc, and the company, its directors, officers or employees make no representation or accept any liability for its accuracy or completeness unless expressly stated to the contrary. [...] 15884 120 26_Re: high service wait time0_18_mebert@AMADEUS.NET31_Thu, 18 Apr 2002 11:34:08 +0200644_us-ascii SYSLGRNX (SYSLGRNG went away long time ago) gets updated each time a pageset (TS/partition) gets opened for Update and (pseudo-)closed (also by some utilities). In an active system, that's not likely to occur often, so SYSLGRNX normally won't be a bottleneck (the updates depend on the pageset activity, so threads cannot be "fighting over it"). That assumes that some ZPARMs are set reasonably, specifically DSMAX (6000 is a typical value), PCLOSET (I suggest 20-40), LOGLOAD (depends on your logging, try to have a checkpoint every 15-30 mins), and PCLOSEN. Here I suggest 32767, effectively disabling this parm. You don't want [...] 16005 147 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 18 Apr 2002 10:39:29 +0100468_iso-8859-1 Not correct

When you DSN1COPY an image copy of a partitioned tablespace (or even a single partition of a partitioned tablespace) it uses the page numbers/RIDs to determine which datasets to dynamically allocate.

Or, at least, it used to...... (see later)

You can test this simply by 'pointing' SYSUT1 at the image copy and SYSUT2 at partition #1. Now run DSN1COPY and look for dynamic allocation messages for the other partitions. [...] 16153 55 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY0_18_mebert@AMADEUS.NET31_Thu, 18 Apr 2002 11:37:47 +0200578_us-ascii Of course that works. Specify NUMPARTS(nn) in the option list, and the .A001 Dataset as SYSUT2. Also make sure you get the FULLCOPY/INLCOPY and possibly LARGE and 32K options right. See the Utilities Guide.

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







The thing i've mentioned is that it is a partitioned TS , and all i have is an all partitions Full Copy file . So i think that DSN1COPY won't work in this case because how to say that there is only one input and several output ... 16209 196 65_FW: [DB2-L] Restore TS with a Full Copy not referenced in SYSCOPY14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 18 Apr 2002 10:41:30 +0100353_iso-8859-1 Ooops - Almost forgot

You must also be sure to use the RIGHT value for the NUMPARTS parameter on DSN1COPY. This is how it works out which partition ach page belongs in.

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 16406 22 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Thu, 18 Apr 2002 04:04:20 -0500470_- Gurus,

Thanks for all the info - it seems that the UDB v7.2 should talk to OS/390 v5.1, but something don't seem to be quite right, in that when I try and connect I get the message SQL10007N Message "1056567296" could not be retrieved. Reason code: "4". Does anybody have any clues about this? How do I find out which FIXPACK my UDB system is at? I think I've seen it mentioned somewhere on the List before, so I shall start having a look in the Archives. [...] 16429 50 71_How to do Error handling in SQL SP when wrong packageset used. V7 OS39029_H=?ISO-8859-1?Q?=E5kan?= Roll18_hakan.roll@EDS.COM31_Thu, 18 Apr 2002 04:31:40 -0500534_- If I recieve a "normal" SQL-error example -180 (invalid date) this method with handler works as expected.

But how can I notify the program/trigger calling an SQL SP that the call was unsucessful due to incorrect PACKAGE used.

Why does the handler not call my error routine?

The error routine procedure: - Is written in cobol and logs when it is invoked through display and records in a vsam-file. - It has a fixed collection granted execute to public - The Cobol SP has also been granted to execute public [...] 16480 49 38_Re: Creating Database from backup file19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 18 Apr 2002 12:14:11 +0100349_- Saima,

Can't help on the Control Center front because I do everything with scripts and command line.

However I can send you a Perl script which will generate a "redirected restore" which you can run from the command line.

Or I can send you the commands that this would generate, which you can then modify as appropriate. [...] 16530 79 18_Re: SQL0805N error16_Iqbal Goralwalla26_igoralwalla@PHARMOLOGY.COM31_Thu, 18 Apr 2002 11:16:03 +0100711_iso-8859-1 Thanks to all who responded.

I fixed the problem by binding the db2clpcs.bnd in \sqllib\bnd directory on the client (NT).

Iqbal [feeling really good considering IBM Support are still trying to figure the problem out!]

-----Original Message----- From: Shapiro, Dave [mailto:Shapiro.Dave@PRINCIPAL.COM] Sent: 17 April 2002 18:37 To: DB2-L@RYCI.COM Subject: Re: SQL0805N error



Iqbal,

For host connectivity this package is somewhere in a bnd file within sqllib\bnd\ddcsmvs.lst. You don't mention where the tables are that you want to access, but if not the host, look inside the bnd files within the various available lst files for the package name. Or is [...] 16610 136 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v518_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 18 Apr 2002 06:30:11 -0400396_iso-8859-1 Steve: As for what fixpack your on; at the command window you can enter DB2LEVEL and this will tell you. You should see a 'WRxxxxx' number, in my case I have DB2 Connect PE V7.2 installed with fixpack 5 which is WR21294 .. As for the SQL error your getting the msg is a new one for me. Did you do your binds on your DB2 V5.1 OS/390 platform? Usually that is where I had problems. [...] 16747 98 38_Re: Creating Database from backup file12_saima jelani19_saaiima@HOTMAIL.COM31_Thu, 18 Apr 2002 10:37:14 +0000748_- can u please send me commmad line which u use to create backup file of database and then create anothoe Databse from this file

Thanks in advance

>From: "Philip Nelson (DBA)" >Reply-To: DB2 Data Base Discussion List >To: DB2-L@RYCI.COM >Subject: Re: Creating Database from backup file >Date: Thu, 18 Apr 2002 12:14:11 +0100 >MIME-Version: 1.0 >Received: from [207.200.4.42] by hotmail.com (3.2) with ESMTP id >MHotMailBE87EBC80046400431C9CFC8042A0DBD2; Thu, 18 Apr 2002 03:33:25 -0700 >Received: from jupiter (www.ryci.com) by ryci.com (LSMTP for Windows NT >v1.1b) with SMTP id <0.00388EBA@ryci.com>; Thu, 18 Apr 2002 5:22:16 -0500 >Received: from RYCI.COM by RYCI.COM (LISTSERV-TCP/IP [...] 16846 77 21_Re: Query explanation13_Boucher, Phil18_pbou2@ALLSTATE.COM31_Thu, 18 Apr 2002 05:37:50 -0500442_iso-8859-1 If the value for the column you retrieve is null, DB2 puts a negative value in the indicator variable. If it is null because of a numeric or character conversion error, or an arithmetic expression error, DB2 sets the indicator variable to -2.

-----Original Message----- From: Sandeep Simon [mailto:Sandeep.S.Alumootil@UKTRANSCO.COM] Sent: Thursday, April 18, 2002 10:08 AM To: DB2-L@RYCI.COM Subject: Query explanation [...] 16924 121 18_Re: SQL0805N error0_20_John_Lendman@FPL.COM31_Thu, 18 Apr 2002 07:29:38 -0400435_us-ascii Iqbal, how did you select db2clpcs to bind on the client?

I am having this problem to and was wondering what lead you to this one item to bind?

Thanks

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





"Iqbal Goralwalla" cc: Sent by: "DB2 Data Subject: Re: SQL0805N error Base Discussion List" [...] 17046 105 36_Fancy few days in Dubrovnik in June?14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 18 Apr 2002 12:34:25 +0100433_iso-8859-1 Don't worry - This is not a holiday advertisement (well, not really)

This year, Computer Associates is proud to be sponsoring the SQL Adria regional user group conference for Croatia and Slovenia, being held in Dubrovnik (Croatia) in June.

However, although it is a regional user group, attendance is not restricted to those regions and, subject to payment of the registration fee, everyone is welcome. [...] 17152 76 26_Re: Can I stop a DB2 query14_RICHARD MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Thu, 18 Apr 2002 06:35:32 -0500338_US-ASCII Derez,

You notice how SQL coders always code to spec without ever considering the type of environment the app will run in (e.g., online versus batch)?

You may consider re-writing the query to restrict the search using the BETWEEN clause, to limit the number of qualifying rows, instead of a blue sky wildcard. [...] 17229 171 21_Re: Query explanation14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 18 Apr 2002 12:38:59 +0100469_iso-8859-1 From the excellent IBM manuals......

It is an indicator variable and tells the program whether a valid result was returned from the SELECT.

In your case, SELECT MIN(xx) only returns a valid value when there are rows that match the WHERE clause.

If there are NO qualifying rows, then MIN(xx) will return NULL. DB2 will set the indicator variable to show whether the value in EFF-DT is a valid value or not - ignore it at your peril! [...] 17401 87 38_Re: Creating Database from backup file11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Thu, 18 Apr 2002 14:51:48 +0300591_iso-8859-7 Advice:Don't rely on Control Center! It doesn't always produce the right scripts.Usually,it doesn't include alias names...So , these are my guidelines

1.Create the new DB at the new instance(server) 2.Copy the back up to the local server at exactly the same path as it was on the backup server (e.g. D:\db2bkp\YOURDBNAME.0\db2\node0000\catn0000\......) 3.Run script from the SCRIPT or COMMAND CENTER RESTORE DATABASE FROM D:\\Db2bkp\\ TAKEN AT 20010702234523 TO D: INTO WITH 2 BUFFERS BUFFER 1024 WITHOUT ROLLING FORWARD WITHOUT PROMPTING [...] 17489 83 21_Re: Query explanation14_RICHARD MOLERA25_RICHARD.E.MOLERA@SLMA.COM31_Thu, 18 Apr 2002 06:56:03 -0500654_US-ASCII The answer to this, and many other strange phenomena, can be found in the Application Programming and SQL Guide. Please open the manual and peruse its contents before seeking guidance from others.

Hope that helps and good luck,

Rick Molera Mainframe DB2 DBA









>>> Sandeep.S.Alumootil@UKTRANSCO.COM 04/18/02 05:08AM >>> Dear All,

Could somebody explain what will be populated into the host variable WW-NULL-VALUE SELECT MIN(EFF_DT) INTO :DCLMSBADT.EFF-DT:WW-NULL-VALUE FROM MSBADT WHERE MEAS_STATN_NBR = :WW-NEW-MEAS-STATN-NBR AND EFF_DT > :PXCML001-EFF-DT shed some light on this.. [...] 17573 10 0_12_Thomas Weber23_thomas.weber@LDS.NRW.DE31_Thu, 18 Apr 2002 14:19:41 +0200253_iso-8859-1

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 17584 15 27_OS levels for Db2 V6 and V712_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 18 Apr 2002 08:33:59 -0400359_us-ascii Can someone point me to the link indication minimum OS levels required for Db2 V6 and V7(s/390). Thanks Amit

================================================ 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. 17600 148 18_Re: SQL0805N error16_Iqbal Goralwalla26_igoralwalla@PHARMOLOGY.COM31_Thu, 18 Apr 2002 13:48:38 +0100607_iso-8859-1 John,

Hopefully you have the package name which is causing the problem. There is a detailed table (Table 1) at: http://nscpcw.physics.upenn.edu/db2_docs/db2c0/db2c021.htm which tells you which packages are associated with which bind files. For example, the package in my case was SQLC2D01. From the table, the associated bind file for this package is db2clpcs.bnd (a clp bind file with isolation CS). So, on the NT client, from the \sqllib\bnd I connected to the db on the server, and then issued the command: db2 bind db2clpcs.bnd blocking all grant public. That solved the problem. [...] 17749 59 21_Re: Query explanation13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 18 Apr 2002 08:53:21 -0400401_iso-8859-1 Hi Sandeep,

To expand on what Phil quotes from the SQL reference with an example,

>SELECT MIN(EFF_DT) > INTO :DCLMSBADT.EFF-DT:WW-NULL-VALUE > FROM MSBADT > WHERE MEAS_STATN_NBR = :WW-NEW-MEAS-STATN-NBR > AND EFF_DT > :PXCML001-EFF-DT

If there are rows in MSBADT which qualify against your where clause criteria, your host variables should be populated as follows [...] 17809 56 37_Re: quote vs. apost in DB2 for OS/39015_Shields Michael28_ShieldsMichael@JOHNDEERE.COM31_Thu, 18 Apr 2002 07:58:58 -0500339_iso-8859-1 If I understand your question... you're asking double-quote vs. single-quote. To my knowledge there is no difference between a single-quote and an apostrophe. We use single-quote. When you have a string like "JOHN'S STADIUM" you need to write the SQL such that you are updating that text/char column with "JOHN''S STADIUM" [...] 17866 50 31_Re: MVS error code 104-204 VSAM11_Henry Boone16_hboone@GEICO.COM31_Thu, 18 Apr 2002 07:55:33 -0500443_- We have been experiencing a similar problem on several Storage Group defined non-SMS managed NPIs (PIECE SIZE= 4GB) on a table in a LARGE partitioned table space. I checked into APAR OW43724 but we are at DFSMS 1.6 and DB2 V7 both of which should have incorporated these fixes.

Our situation is the volume the dataset is on gets too full for a secondary extent, and we receive the following message(s) in the DBM1 address space: [...] 17917 134 38_Re: Creating Database from backup file19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 18 Apr 2002 15:50:31 +0100542_- Here's a typical script -

====== START OF SCRIPT ===============

restore database dpair001 from /tempdir taken at 20020418101524 into dtair001 redirect without rolling forward without prompting;

set tablespace containers for 0 using (path '/db2db/dtair001/syscatspace');

set tablespace containers for 1 using (path '/db2db/dtair001/tempspace1');

set tablespace containers for 2 using (path '/db2db/dtair001/userspace1');

set tablespace containers for 3 using (path '/db2db/dtair001/sair001'); [...] 18052 188 18_Re: SQL0805N error0_20_John_Lendman@FPL.COM31_Thu, 18 Apr 2002 09:53:12 -0400471_us-ascii Iqbal, thanks for the details. I do have the package name, SQL0805N Package "NULLID.SQLLF000". But for some reason it is not in the table you referred me to. Any ideas where I would find this package?

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





"Iqbal Goralwalla" cc: Sent by: "DB2 Data Subject: Re: SQL0805N error Base Discussion List" [...] 18241 75 50_Re: Migration from DB2 V5 to V7 on OS/390 platform0_16_khampto1@TXU.COM31_Thu, 18 Apr 2002 08:53:29 -0500371_us-ascii Hello Judi, I would consider us a mid-sized shop. I have 4 DB2 Subsystems with over 15000 tables each, and I migrated them from V5 to V6 in less than 1.5 hours each. I have heard that the v6 to v7 migration is minimal, so I would expect skipping from v5 to v7 would be only slightly longer than what I experienced. How do you install DB2 outside of SMP/E ? [...] 18317 58 21_Re: Query explanation13_Sandeep Simon33_Sandeep.S.Alumootil@UKTRANSCO.COM31_Thu, 18 Apr 2002 15:00:18 +0100357_- Dave,

Thanks for that..I things sure I was quite convinced before your post that if the column function did not return any rows, then I would get a SQLCODE 100, we were anyhow checking for that as part of start db2 programming,,,which is why I was a bit confused....thank you for your help....i shall refer the manuals and read more about it. [...] 18376 100 21_Re: DSN1COPY problems15_Murley, Michael22_Michael_Murley@BMC.COM31_Thu, 18 Apr 2002 09:10:37 -0500393_iso-8859-1





Dave,

There is an appendix in the Messages and Codes manual called 'ABEND codes associated with DSN1COPY misuse' that is sometimes helpful in analyzing such problems as these. It documents many of the reason code/CSECT name/ERQUAL values that result from an errant DSN1COPY job. It is on p 1045 in the DB2 V6 Messages and Codes Volume II manual. [...] 18477 35 31_FW: OS levels for Db2 V6 and V713_Gleason, Mike22_MGleason@UILLINOIS.EDU31_Thu, 18 Apr 2002 09:26:29 -0500419_iso-8859-1 Amit, The prereqs are in the release planning guides for V6 and V7, which can be found at http://www-4.ibm.com/software/data/db2/os390/library.html Note that V7 has hardware prereqs in addition to OS level. Mike

-----Original Message----- From: Amit Agarwal [mailto:amit_agarwal@STANDARDANDPOORS.COM] Sent: Thursday, April 18, 2002 7:34 AM To: DB2-L@RYCI.COM Subject: OS levels for Db2 V6 and V7 [...] 18513 37 18_Re: SQL0805N error13_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Thu, 18 Apr 2002 10:52:49 -0400420_iso-8859-1 John, Have a look at these APARs. Actually don't bother. They don't say much. One is cancelled; one has a target date of tomorrow. None have fixes available.

I'd contact IBM support & ask for the status of a fix.

JR16664 APPLICATION GETS SQL0805 ERROR ON SQLLF000 PACKAGE JR16665 APPLICATION GETS SQL0805 ERROR ON SQLLF000 PACKAGE JR16777 APPLICATION GETS SQL0805 ERROR ON SQLLF000 PACKAGE [...] 18551 19 31_Re: MVS error code 104-204 VSAM10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 18 Apr 2002 17:24:46 +0200458_us-ascii Can you take a a look to DATACLASS definition for that DB2 LDS ?

Maybe your DASD manager specifed EXTENDED FORMAT or some values for secondary space for that LDS.

Just an idea

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. 18571 34 45_Tutorials: DB2 User Certification Preparation16_Jeffrey I Condon19_jicondon@US.IBM.COM31_Thu, 18 Apr 2002 08:22:33 -0700476_us-ascii The DB2 Developer Domain released six tutorials designed to help prepare for the DB2 Fundamentals Certification (Exam 512). These tutorials provide a solid base for each section of the exam. http://www7b.software.ibm.com/dmdd/library/tutorials/db2cert/db2cert_tut.html?openl=327,t=gr



1. DB2 tools, data warehousing and OLAP 2. Security and instances 3. Creating and accessing DB2 databases 4. SQL usage 5. Database objects 6. Database concurrency [...] 18606 53 20_DB2 Storage question22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Thu, 18 Apr 2002 10:20:04 -0500541_- We'll soon start converting our Datacom Databases to DB2 in Prod. We were doing capacity planning and one of the questions that came up was, we have 96 3390-9 volumes (150,210 tracks each) available, since MVS has a 65,0000 track (approx) limit per Dataset, how will DB2 handle allocation if I want to use them for my large tablespaces, which my need more than 65,000 tracks? Or is it possible to have more than one large tablespace in a Stogroup with many of these MOD-9 Volumes? If not, what is the best way to utilize these MOD-9? [...] 18660 97 21_Re: DSN1COPY problems12_Tony Vermeer24_tony.vermeer@SAFEWAY.COM31_Thu, 18 Apr 2002 08:50:00 -0700540_us-ascii Don't forget 'LARGE' or DSSIZE as well. That one got me before.

"Palgrave, Greg" wrote:

> David, > > The tablespace and table structures have to be recreated *exactly* as they > were prior to the drop. > Tablespace segsize etc must match. I don't think PRIQTY etc is critical. > > A common error is to have a table that has been ALTERed to add a column, but > has not yet been reorged. In this case you must recreate the table using > the same sequence of events i.e. create a new table, ALTER ADD Column, and > [...] 18758 55 53_DB2 instance crash during rollforward using user exit19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 18 Apr 2002 17:55:41 +0100436_- DB2 V6.1 on AIX : fixlevel U473545.

I'm writing and testing a user exit for log handling.

It successfully is archiving logs, both to another directory and to TSM.

Now testing the retrieve processing.

Last backup needs logfile 68. Last log in archived set is 104. Ran restore of backup and then issued a rollforward to end of logs. It got as far as processing logfile 74 and then crashed the instance. [...] 18814 75 37_Re: quote vs. apost in DB2 for OS/39011_Tina Hilton21_Tina.Hilton@BMSUS.COM31_Thu, 18 Apr 2002 11:01:25 -0500408_iso-8859-1 Michael, You're right that apostrophe = single quote. That's what I really call it too, I was just trying to use IBM terminology.

What do you have set in your DSNHDECP as the default?

Tina

-----Original Message----- From: Shields Michael [mailto:ShieldsMichael@JOHNDEERE.COM] Sent: April 18, 2002 7:59 AM To: DB2-L@RYCI.COM Subject: Re: quote vs. apost in DB2 for OS/390 [...] 18890 129 22_Re: IN LIST processing13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Thu, 18 Apr 2002 11:27:09 -0500569_iso-8859-1 Wolfgang,

I forgot to mention that the testing I performed was on non-indexed columns. And therefore my answer was strictly applicable to non-indexed columns.

For indexed columns though, further tests I have performed suggests that DB2 does remove duplicates from the IN list (and I'm betting it sorts them into sequence to make this process easier - my getpage counts imply this also). And this makes sense, since it is the IN list which drives the index probes. So if duplicates were in the list, then you would retrieve duplicate rows. [...] 19020 48 16_Why is log full?14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Thu, 18 Apr 2002 11:31:52 -0500335_us-ascii One of our application developers has, on several occasions, run a transaction that got SQL0964C (transaction log full), even though the table involved was created with the NOT LOGGED INITIALLY attribute and he used ALTER TABLE ACTIVATE NOT LOGGED INITIALLY and performed his update in the same unit of work. [...] 19069 75 21_Re: DSN1COPY problems11_David Nance16_DWNance@FHSC.COM31_Thu, 18 Apr 2002 12:53:11 -0400659_US-ASCII Michael/Greg, Thanks for the help. The problem was the segsize original was 64, new one 4. Appreciate the help. The table has been copied and I am able to access the data. Thanks for the help.

Dave Nance First Health Services, Corp. (804)527-6841

>>> Michael_Murley@BMC.COM 04/18/02 10:10AM >>>





Dave,

There is an appendix in the Messages and Codes manual called 'ABEND codes associated with DSN1COPY misuse' that is sometimes helpful in analyzing such problems as these. It documents many of the reason code/CSECT name/ERQUAL values that result from an errant DSN1COPY job. It is on p 1045 in the DB2 [...] 19145 82 31_Re: MVS error code 104-204 VSAM24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Thu, 18 Apr 2002 09:52:40 -0700582_- Hi Henry!

We had a similar problem a few weeks ago, and opened incident reports with 3 separate groups at IBM. It was the media manager group that finally identified the situation.

Our problem was that the SMS DASD pool did not have any space on any volume that was large enough to satisfy the secondary quantity in 5 or fewer extents. When that happens, DB2 by design, will automatically trim the secondary allocation to 2 cylinders in an effort to keep the process going. Adding an additional volume to the pool, or reducing the size of the secondary request [...] 19228 10 31_Re: MVS error code 104-204 VSAM11_Henry Boone16_hboone@GEICO.COM31_Thu, 18 Apr 2002 11:41:24 -0500279_- These datasets are not SMS managed.

================================================ 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. 19239 65 35_Re: FW: OS levels for Db2 V6 and V712_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 18 Apr 2002 11:26:43 -0400605_us-ascii Thanks Mike.







"Gleason, Mike" on 04/18/2002 10:26:29 AM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: FW: OS levels for Db2 V6 and V7











Amit, The prereqs are in the release planning guides for V6 and V7, which can be found at http://www-4.ibm.com/software/data/db2/os390/library.html Note that V7 has hardware prereqs in addition to OS level. Mike [...] 19305 24 58_Question about replication between two DB2 UDB NT database0_20_John_Lendman@FPL.COM31_Thu, 18 Apr 2002 13:11:27 -0400335_us-ascii Does any one know where I can get information on how I can set up replication from one DB2 UDB/NT to another DB2 UDB/NT database. I am a DB2 OS/390 DBA trying to support DB2 UDB/NT. My customer wants to replicate all the data from one to the other and then when needed switch to the second copy. Any help would be great. [...] 19330 53 56_FW: Search Archives for DB2 V6 moving from OS/390 to zOS24_ANDERSON Margaret * IRMD29_Margaret.Anderson@STATE.OR.US31_Thu, 18 Apr 2002 10:20:25 -0700449_iso-8859-1 Thanks for the tip. The added slash helped once I also used the correct search area. I discovered that the Archives must represent REALLY OLD discussions because I still got no hits using z/OS in any combination of upper/lower case. When I changed the search to use the Discussion area - voila, I got plenty of hits. Apparently z/OS discussion is recent enough (like the last 18 months) that it isn't archived yet. Learning as I go. [...] 19384 45 56_FW: Search Archives for DB2 V6 moving from OS/390 to zOS24_ANDERSON Margaret * IRMD29_Margaret.Anderson@STATE.OR.US31_Thu, 18 Apr 2002 11:33:25 -0700314_- Thanks for the info. We are going to z/OS 1.2 and have checked IBM which reflects a couple of PTFs we need (confirmed by the doc for z/OS migration using DB2 V6.1). I was mostly checking here for anything folks might have come up against that had to do with operational problems rather than product issues. [...] 19430 60 20_Re: Why is log full?13_Daniel Rieger25_Daniel.Rieger@T-ONLINE.DE31_Thu, 18 Apr 2002 20:12:49 +0200633_iso-8859-1 Hi Steve,

I experienced the same behaviour.

It seems that:

If you run an '' followed by an insert/update or delete operation, db2 doesn't log the insert/update/delete-operation. But the 'alter table xx not logged initially' itself is registered in the db2 log and not committed. If you restore a partiton and rollforward to a pit or the end of logs, db2 invalidate all tables, for which it finds an in the log. If your 'unlogged' uow runs for awhile, you' re application will become the 'transaction holding the [...] 19491 39 41_open text passwords on DB2 Connect and NT12_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 18 Apr 2002 11:48:22 -0700378_us-ascii Has anyone else looked into DB2 Connect's open text storage of userid's and passwords in the DB2CLI.INI file? If you use a single signon solution for DB2 Connect EE (or PE) to allow multiple users to use a single userid to access OS/390 DB2 (or other UDBs), you need to set uid and pwd in the DB2CLI.INI file. However, this password (pwd) is stored in clear text. [...] 19531 28 54_Length of diagnostic message in an UDF (V6 for OS390 )13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Thu, 18 Apr 2002 13:52:18 -0500484_- Hi all Here is the description of this field that I found in "Application Programming and SQL Guide".

"Diagnostic message: This is a VARCHAR(70) value, which your user-defined function can set before exiting. Use this area to pass descriptive information about an error or warning to the invoker.

DB2 allocates a 70-byte buffer for this area and passes you the buffer address in the parameter list. Ensure that you do not write more than 70 bytes to the buffer." [...] 19560 26 52_Alter bufferpool Command for UDB V7.2 FP3 Unix 4.3.322_Killen, Martin W - CNF21_Killen.Martin@CNF.COM31_Thu, 18 Apr 2002 14:12:27 -0700367_iso-8859-1 Hi listers,

Can anyone tell me if an alter bufferpool on UDB takes affect immediately or do you have to do a stop & start?????

Marty Killen Sr. DB2 DBA CNF Inc. 503-450-2681 killen.martin@cnf.com IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for OS/390 DB2 UDB V7.1 Database Administration for UNIX, Windows & OS/2 [...] 19587 15 42_iI will return your note after I get back.15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Thu, 18 Apr 2002 18:14:33 -0400411_us-ascii I will be out of the office starting 04/18/2002 and will not return until 04/22/2002.

For DB2 help while I am out, contact Patrick Kelly at 973-548-3726.

================================================ 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. 19603 27 30_Stored Procedure set timestamp17_Robert J. Milonas20_xrjmbob@NETSCAPE.NET31_Thu, 18 Apr 2002 18:34:33 -0400510_iso-8859-1 I'm on DB2 os/390 V6. Anyone getting a -904 when using

EXEC SQL Set :HOSTVAR = CURRENT TIMESTAMP END SQL

in a stored procedure







__________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ [...] 19631 18 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v512_Mike Brennan31_michael.brennan@I-STRUCTURE.COM31_Thu, 18 Apr 2002 16:45:06 -0500516_- I just downloaded a copy of DB2 PE 7.2 (with DB2 Connect) with WR21254 as well and installed it on Windows 2000 and tried to connect to a DB2 v6 OS/390 subsystem and received the exact same error as you Steve. Before upgrading my PC to Windows 2K I had DB2 Connect 6.1 on Windows NT talking successfully with the same DB2 OS/390 subsystem. So I believe the problem is probably on the PC side somewhere. Tomorrow I hope to spend some time on this problem and if I find anything I'll let you know. Mike Brennan [...] 19650 16 18_Platinum detector.15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 18 Apr 2002 18:46:19 -0400389_iso-8859-1 Is documentation for Platinum detector available on Web. Please let me know if anybody has address for this.



thanks..sibi

================================================ 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. 19667 47 62_Re: Question about replication between two DB2 UDB NT database11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Fri, 19 Apr 2002 09:27:44 +1000530_iso-8859-1 John_Lendman@FPL.COM wrote: > >Does any one know where I can get information on how I can set up > >replication from one DB2 UDB/NT to another DB2 UDB/NT database. I am a > DB2 > >OS/390 DBA trying to support DB2 UDB/NT. My customer wants to replicate > all > >the data from one to the other and then when needed switch to the second > >copy. Any help would be great. > First, take a deep breath. Then read the online doco on DataPropagator (and the utilities Capture and Apply). I will warn you now - DB2 has the [...] 19715 22 23_Alternative GUI for DB211_Endy Lambey20_endyl@CENTRIN.NET.ID33_Fri, 19 Apr 2002 06:40:44 -0-1700379_- Dear all,

I just like to know if there is any alternative GUI for DB2 other than Control Center. Like TOAD for Oracle. Because the Java based Control Center is a bit slow, so maybe anyone can tell me if there is any other alternative GUI.

T.I.A

Cheers..

endy@lambey.net

"To the fool, he who speaks wisdom will sound foolish" - Euripides [...] 19738 44 62_Re: Question about replication between two DB2 UDB NT database18_Gert van der Kooij16_gkooij@XS4ALL.NL31_Fri, 19 Apr 2002 02:09:53 +0200636_iso-8859-1 Check the Replication Guide and Reference which is one of the manuals installed by default installation

----- Original Message ----- From: Newsgroups: bit.listserv.db2-l To: Sent: Thursday, April 18, 2002 7:11 PM Subject: Question about replication between two DB2 UDB NT database



> Does any one know where I can get information on how I can set up > replication from one DB2 UDB/NT to another DB2 UDB/NT database. I am a DB2 > OS/390 DBA trying to support DB2 UDB/NT. My customer wants to replicate all > the data from one to the other and then when needed [...] 19783 67 75_Re: How to do Error handling in SQL SP when wrong packageset used. V7 OS39014_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Apr 2002 13:55:44 +1000567_ISO-8859-1 PQ51954

James Campbell



On 18 Apr 2002 at 4:31, Hĺkan Roll wrote:

> If I recieve a "normal" SQL-error example -180 (invalid date) > this method with handler works as expected. > > But how can I notify the program/trigger calling an SQL SP that the > call was unsucessful due to incorrect PACKAGE used. > > Why does the handler not call my error routine? > > The error routine procedure: > - Is written in cobol and logs when it is invoked > through display and records in a vsam-file. > - It has a fixed collection granted [...] 19851 45 58_Re: Length of diagnostic message in an UDF (V6 for OS390 )14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Apr 2002 13:55:44 +1000591_US-ASCII Mohammad,

Have a look at the example code which is also in the Appl Prog and SQL Guide. That will give you your answer.

James Campbell



On 18 Apr 2002 at 13:52, Mohammad Khan wrote:

> Hi all > Here is the description of this field that I found in "Application > Programming and SQL Guide". > > "Diagnostic message: This is a VARCHAR(70) value, which your user-defined > function can set before exiting. Use this area to pass descriptive > information about an error or warning to the invoker. > > DB2 allocates a 70-byte buffer for this area [...] 19897 68 24_Re: DB2 Storage question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Apr 2002 13:55:44 +1000570_US-ASCII Venkatesh

The 65535 track limit is for sequential datasets (per volume). DB2 clusters are VSAM: their limit is 4Gb for normal clusters and 64Gb for extended clusters. These clusters can have extents occur across multiple volumes.

For segmented tablespaces (and simple tablespaces - which you wouldn't use apart from catalog and directory use), DB2 will allocate extentsion clusters when the first is full. Their names end with A002, A003 .... A0016. So they can use up to 16 x 4Gb = 64 Gb per tablespace. (They cannot use extended clusters.) [...] 19966 106 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v514_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Tue, 16 Apr 2002 14:37:32 +0100592_iso-8859-1 Easy peasy, Stevey!

Personal Edition doesn't come with OS/390 connectivity.

Sorry old friend, been bitten there myself!

Regards, Marcus



----------------------------------------------------------------------------------------------------------------------- This e-mail is intended only for the above addressee. It may contain privileged information. If you are not the addressee you must not copy, distribute, disclose or use any of the information in it. If you have received it in error please delete it and immediately notify the sender. [...] 20073 63 32_Re: Clist to calculate workspace13_Bright, Randy20_Randy_Bright@BMC.COM31_Tue, 16 Apr 2002 08:50:16 -0500662_iso-8859-1 Just a suggestion that might make your job easier. (Warning, vendor product plug follows!)

Why don't you utilize the dynamic work file allocation capabilities of BMC LoadPlus and Reorg Plus? Unload Plus does not yet have dynamic allocation available, but it will in the next release. Calculations are done for Reorg Plus based on analysis of the tablespace being reorged. LoadPlus does it's calculations based on the user supplied ENUMROWS parameter (and analysis in a RESUME YES case). All SYSUT1, SYSREC, SYSDISC, SYSERR, SORTWK, and COPY datasets can be dynamically allocated in LoadPlus, while Reorg Plus will dynamically allocate all [...] 20137 70 40_AW: What's the name of the SAS-DB2 plan?41_=?iso-8859-1?Q?=22Kurtz=2C_R=FCdiger=22?=28_Ruediger.Kurtz@HUK-COBURG.DE31_Tue, 16 Apr 2002 15:56:38 +0200428_iso-8859-1 Raymond,

I'm not sure whether you have a choice when it comes to naming your sas-plan, but I did look at the names of our respective sas-plans, and since your names matched ours (SASDB2E and SAS82) I should think that you are left with no choice; others might have different findings, though. And I leave the question whether you're going slightly mad or not to others to answer (sorry, couldn't resist). [...] 20208 58 53_DB2 instance crash during rollforward using user exit19_Philip Nelson (DBA)21_teamdba@ATTGLOBAL.NET31_Thu, 18 Apr 2002 17:55:41 +0100436_- DB2 V6.1 on AIX : fixlevel U473545.

I'm writing and testing a user exit for log handling.

It successfully is archiving logs, both to another directory and to TSM.

Now testing the retrieve processing.

Last backup needs logfile 68. Last log in archived set is 104. Ran restore of backup and then issued a rollforward to end of logs. It got as far as processing logfile 74 and then crashed the instance. [...] 20267 53 27_Re: Alternative GUI for DB211_Adnan Saeed27_asaeed@ITDIV.COMSATS.NET.PK31_Fri, 19 Apr 2002 09:04:23 +0500492_iso-8859-1 hi yes there is u can use "rapidsql" as gui with the db2,as well as oracle and other databases, but it is limited in some tasks as creating identity in db2 any how try it u can download it from the net

best wishes and regards adnan saeed software engineer comsats, pakistan ----- Original Message ----- From: "Endy Lambey" Newsgroups: bit.listserv.db2-l To: Sent: Friday, April 19, 2002 11:40 AM Subject: Alternative GUI for DB2 [...] 20321 46 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Tue, 16 Apr 2002 08:49:39 -0500709_ISO-8859-1 Hi Marcus!

Are you sure it doesn't? It's obviously "talking" to the mainframe, cos I can see an error message on the DB2 MSTR address space log! I also get the following in the db2.log file on my pc and it mentions DB2 Connect as the product to be installed! ---------------------------------------- Setup Log File Opened7-14-2000 14:43:01 ---------------------------------------- =>Querying the system... Windows 95 Version: 4.0 The DB2 Folder Name value for the Registry key SOFTWARE\IBM\DB2 cannot be retrieved. The DB2 Path Name value for the Registry key SOFTWARE\IBM\DB2 cannot be retrieved. Space requirements are being calculated... =>Checking for previous installations... The [...] 20368 46 34_Re: Stored Procedure set timestamp14_GARIMA_BILWANI23_GARIMA_BILWANI@INFY.COM31_Fri, 19 Apr 2002 10:08:49 +0530651_iso-8859-1 what is the datatype of ur HOSTVAR ?

-----Original Message----- From: Robert J. Milonas [mailto:xrjmbob@NETSCAPE.NET] Sent: Friday, April 19, 2002 4:05 AM To: DB2-L@RYCI.COM Subject: Stored Procedure set timestamp



I'm on DB2 os/390 V6. Anyone getting a -904 when using

EXEC SQL Set :HOSTVAR = CURRENT TIMESTAMP END SQL

in a stored procedure







__________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ [...] 20415 44 27_Re: Alternative GUI for DB214_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Fri, 19 Apr 2002 06:42:10 +0200 20460 109 32_Re: What ERLY code am I running?10_Andy Stein22_jbak2009@AMERITECH.NET31_Tue, 16 Apr 2002 09:39:33 -0500586_us-ascii Pleasew take me off the list.

Thank You

Andy Stein











>Hi Mark, Hayden, Carol, > >Thanks for the info. Carol, your note spelt out most clearly to the >ignorant Sysprog hidden deep inside me what I had to do but you were all on >the money. I ran Diagnose, looked for DSN3EPX, paged right and found the >most recent PTF applied (only one with a year of 2000 was a good clue) and >confirmed via IBMLink that this was a V5 PTF. Will re-apply the V7 ERLY >code (applied it and backed it out as a test - thorough, huh?) [...] 20570 121 32_Re: What ERLY code am I running?13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Tue, 16 Apr 2002 09:06:59 -0500403_iso-8859-1 If you want to know what version you are running you can do that in several ways. The easiest way is IEBEYEBALL module DSN3EPX in SDSNLINK and look for the RIB (Release Information Block). It will be followed by the component identifier (RIBCID) and release (RIBREL). Should look something like ....RIB 5740XYR01710 or ....RIB 5740XYR01610 or this ....RIB 5740XYR01510 if you are on V5. [...] 20692 55 34_DB2 Compression utility - DSN1COMP20_Vijayababu Sriramulu34_Vijayababu.Sriramulu@IN.EFUNDS.COM31_Fri, 19 Apr 2002 10:54:29 +0530580_us-ascii Hi List,

We are facing some problems in using this utility. We are getting the following error when we are treying to execute this util.

DSN1943I DSN1COMP DICTIONARY PAGE ENCOUNTERED DSN1941I DSN1COMP COMPRESSION ESTIMATE WAS NOT CALCULATED

When i look into the manuals it says, DSN1941I is issued if you have identical data in the table. I have millions of rows in the table and i am sure this cannot be of identical nature. I am sure there is something wrong with my understanding on identical data. Can someone please throw some light on it. [...] 20748 55 34_Re: Stored Procedure set timestamp14_Agrawal, Navin21_navin.agrawal@EDS.COM31_Fri, 19 Apr 2002 00:31:21 -0500455_iso-8859-1 Robert,

-904 indicates 'Unavailable Resource'. Look for the reason code in the error message which will tell you why the resource was unavailable. The error message also includes the name of the resource which is unavailable.

Regards Navin Agrawal -----Original Message----- From: Robert J. Milonas [mailto:xrjmbob@NETSCAPE.NET] Sent: Friday, April 19, 2002 4:05 AM To: DB2-L@RYCI.COM Subject: Stored Procedure set timestamp [...] 20804 42 23_Visual Explain SQL0805N13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Fri, 19 Apr 2002 16:45:22 +1000412_us-ascii Here is a question & answer from the IBM support site that does not help me.



"Question: What are the bind files associated with the following packages: SQLLF000 and SQLLC000? Answer: There are no bind files associated with these packages. These packages are used dynamically by DB2.

Further Explanation: These packages are found on the Windows NT and OS/2 operating systems." [...] 20847 97 55_Database Transfer from one DB server to other DB server12_Saima Jelani26_sjelani@ISB.COMSATS.NET.PK31_Fri, 19 Apr 2002 12:56:07 +0500436_iso-8859-1 Hello i have performed following steps

1) I have created database iin in DB2 dataserver(user/pass is mtahir/xxx) which is on machine ABC 2)Take backup of IIN database in folder d:/backup 3)Copy this folder to machine XYZ(user/pass is db2admin/yyyy) , where another DB2 server is installed 4)Created a database IINDB on XYZ machine 5)Restore IINDB from the back up file of IIN file (database restored sucessfully) [...] 20945 16 44_Larry Karl/Boulder/IBM is out of the office.10_Larry Karl16_lkarl@US.IBM.COM31_Fri, 19 Apr 2002 01:14:06 -0600473_us-ascii I will be out of the office starting April 19, 2002 and will not return until April 22, 2002.

I'll be out of the office on 4/19/02. For Dev DBA SUPPORT, please contact Jim Edmond(MVS) or Betty Kessock (AIX, WINDOWS)

================================================ 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. 20962 89 38_Re: DB2 Compression utility - DSN1COMP10_Ali OZTURK27_Ali.OZTURK@PAMUKBANK.COM.TR31_Fri, 19 Apr 2002 10:24:25 +0300523_iso-8859-9 Hi, Look at the first message code(DSN1943I). This indicates that your input dataset was already compressed.

Ali Ozturk





-----Original Message----- From: Vijayababu Sriramulu [mailto:Vijayababu.Sriramulu@IN.EFUNDS.COM] Sent: Friday, April 19, 2002 8:24 AM To: DB2-L@RYCI.COM Subject: DB2 Compression utility - DSN1COMP



Hi List,

We are facing some problems in using this utility. We are getting the following error when we are treying to execute this util. [...] 21052 124 38_Re: DB2 Compression utility - DSN1COMP0_18_mebert@AMADEUS.NET31_Fri, 19 Apr 2002 09:44:39 +0200590_us-ascii DSN1COMP is a utility designed to give you an estimate on how much you can save if you compress a tablespace. This more or less implies that it can (should) be run only on TSs that are uncompressed. In your case, obviously most TSs are already compressed. So you shouldn't run DSN1COMP, instead run RUNSTATS (if not done already) and check the PAGESAVE column in SYSTABLEPART. A report saying the saving is 0 in case of an already-compressed TS is simply wrong. The saving is PAGESAVE. DSN1COMP could of course be changed to handle compressed TSs (simply un-compress the rows [...] 21177 126 29_Re: DB2 LOAD using NOCOPYPEND14_Peter Schwarcz23_schwarcz@BIGPOND.NET.AU31_Fri, 19 Apr 2002 17:45:17 +1000369_us-ascii Thanks Andrew,

I have now had a chance to test the LOAD, and you are quite right, my tablespace was in a copy pending status before the load. My assumption was that the NOCOPYPEND on the LOAD would reset the COPY status irrespective of any previous condition.

Also thanks to Jeff L'Italien who replied off the list with the same suggestion. [...] 21304 76 24_Re: DB2 Storage question0_18_mebert@AMADEUS.NET31_Fri, 19 Apr 2002 10:03:09 +0200355_us-ascii Hi James,

since when can simple/segmented TSs use up to 16 4GB Datasets? I think that normal non-partitioned TSs can use up to 32 2GB Datasets (that's what the SQL ref for V6 and personal experience say). Note that LARGE and DSSIZE can only be used for partitioned TSs. LOB TSs can have up to 254 64GB Datasets (default DS size 4GB). [...] 21381 54 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v514_Adrian Collett27_adriancollett@TISCALINET.IT31_Fri, 19 Apr 2002 11:07:50 +0200573_iso-8859-1 Steve, This is not my strong point but.... I have had this problem in the past.

Installing DB2 Connect resolved the problem.

My understanding is that DB2 PE V7.2 does not connect to OS390 without a separate installation of DB2 Connect.

Does this help ?

Adrian Collett Milan, Italy.



-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@RYCI.COM] On Behalf Of Steve Lamb Sent: Thursday, April 18, 2002 11:04 AM To: DB2-L@RYCI.COM Subject: Re: Problem with UDB 7.2 connecting to DB2 OS/390 v5 [...] 21436 46 38_Re: DB2 Compression utility - DSN1COMP14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 19 Apr 2002 04:21:40 -0500409_iso-8859-1 Vijay,

DSN1941I has nothing to do with 'identical data'. The actual message description is "DSN1941I csect-name COMPRESSION ESTIMATE WAS NOT CALCULATED





Explanation: There is insufficient data to build a compression

dictionary. Either the input data set is empty, or the number of rows in

the input data set was insufficient to build the dictionary. [...] 21483 55 56_Re: Alter bufferpool Command for UDB V7.2 FP3 Unix 4.3.318_Krawetzky, Peter J21_KrawetzkyPJ@AETNA.COM31_Fri, 19 Apr 2002 06:03:39 -0400363_iso-8859-1 As a general rule of thumb, you must force all connctions off and stop/start your database. This is usually required whenever you make a significant change to the database configuration or database manager configuration.

Peter J. Krawetzky, DBA IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration For Unix, Windows and OS/2 [...] 21539 26 12_Re: DSNL511I13_Thomas Schulz20_thomas.schulz@SVI.DE31_Fri, 19 Apr 2002 04:32:01 -0500462_- hi dave

how can I set these parameter in Access ? I changed it global in the DB2CLI to zero. Now I don't get any Error Message in the DB2 Master. Access is just cloesing after 15 Minutes.

The query looks like

SELECT info_va1tab.va1_ppnr, info_va1tab.va1_ennr, info_va1tab.va1_oonr, first(info_va1tab.va1_stgr) AS ["erster Wert vom va1_stgr"] FROM info_va1tab GROUP BY info_va1tab.va1_ppnr, info_va1tab.va1_ennr, info_va1tab.va1_oonr; [...] 21566 32 31_DB2 OS/390 & CICS Web interface13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 19 Apr 2002 06:35:39 -0400380_iso-8859-1 We want to use CICS Web Interface to get at our DB2 OS/390 data for our internet applications. We have done a demo of this for our VP of IT and now he would like names of some companies that are actually doing this in production. If you work for a company that is currently using this solution could you please either E-mail me directly or reply to this LISTSERV? [...] 21599 16 15_Read Only Views9_Ali Akbar25_ali.akbar@CRESSOFT.COM.PK31_Fri, 19 Apr 2002 17:10:48 +0500367_us-ascii Hi list , Can anyone provide me the syntax for creating a read only view. I could not find any example

Thanks

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 21616 67 35_ADO Update with DateTime columns...11_Dimoka Popy24_dimokap@INTERAMERICAN.GR31_Fri, 19 Apr 2002 14:08:58 +0300398_- Hello List! I am trying to "migrate" an VB application from SQL Server to DB2 for OS/390.We use VB6,MDAC 2.6(2.7 also),DB2 Connect PE 7.2 and DB2 V6.1.1 for OS/390.There seems to be a problem when trying to update date,time,timestamp values through a Recordset Update(rs.update) or even when updating the non-datetime columns of a table that contains datetime columns.The errors vary from : [...] 21684 18 19_Re: Read Only Views15_Walter Janissen27_walter.janissen@VICTORIA.DE31_Fri, 19 Apr 2002 06:31:14 -0500323_- Hi

If you are looking for a special syntax, then I think there is none (at least I don't know any keyword to do so). A view is read only depending on the underlying SELECT. For instance, if the select is a join, contains a group by, a distinct, a constant, an aritmetic expression then the view is read only. [...] 21703 51 19_Re: Read Only Views0_20_John_Lendman@FPL.COM31_Fri, 19 Apr 2002 07:57:10 -0400420_us-ascii You just create the view as normal, then grant that view select only.



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





"Ali Akbar" cc: Sent by: "DB2 Subject: Read Only Views Data Base Discussion List"



04/19/02 08:10 AM Please respond to "DB2 Data Base Discussion List" [...] 21755 44 19_Re: Read Only Views13_BL.Tink Tysor16_tink@BLTYSOR.COM31_Fri, 19 Apr 2002 05:00:03 -0700527_us-ascii Ali,

After the view is created then:

GRANT SELECT ON view TO ......;

Tink --- Ali Akbar wrote: > Hi list , > Can anyone provide me the syntax for creating a read > only view. > I could not find any example > > Thanks > > ================================================ > To change your subscription options or to cancel > your subscription visit the DB2-L webpage at > http://www.ryci.com/db2-l. The owners of the list > can be reached at DB2-L-REQUEST@RYCI.COM. [...] 21800 56 19_AW: Read Only Views12_Peter, Georg15_G.Peter@DZBW.DE31_Fri, 19 Apr 2002 14:03:36 +0200339_iso-8859-1 Ali,

if you mean non-update-able views here are the rules:

The following types of views cannot insert, update or delete (found in Craig Mullins great DB2 book "DB2 Developers Guide") :

1. Views that join tables 2. Views that use DISTINCT 3. Views that use functions 4. Views with a GROUP BY and HAVING [...] 21857 40 19_Re: Read Only Views11_David Nance16_DWNance@FHSC.COM31_Fri, 19 Apr 2002 08:07:48 -0400430_US-ASCII Try "GRANT SELECT ON viewname TO ?(public, inividual userid or secondary auth group)"

Or if you are using other security package like ACF2 you can set up rules for the naming convention.

Dave Nance First Health Services, Corp. (804)527-6841

>>> ali.akbar@CRESSOFT.COM.PK 04/19/02 08:10AM >>> Hi list , Can anyone provide me the syntax for creating a read only view. I could not find any example [...] 21898 83 35_Re: DB2 OS/390 & CICS Web interface12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 19 Apr 2002 15:24:37 +0200398_iso-8859-1 Hi,

From SQL guide (v7)

Read-only views: A view is read-only if one or more of the following statements is

true of its definition:

v The first FROM clause identifies more than one table or view, or identifies a table

function

v The first SELECT clause specifies the keyword DISTINCT

v The outer fullselect contains a GROUP BY clause [...] 21982 65 19_Re: Read Only Views12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 19 Apr 2002 15:25:28 +0200415_iso-8859-1 Read-only views: A view is read-only if one or more of the following statements is

true of its definition:

v The first FROM clause identifies more than one table or view, or identifies a table

function

v The first SELECT clause specifies the keyword DISTINCT

v The outer fullselect contains a GROUP BY clause

v The outer fullselect contains a HAVING clause [...] 22048 54 35_Re: DB2 OS/390 & CICS Web interface12_Isaac Yassin20_yassini@BEZEQINT.NET31_Fri, 19 Apr 2002 15:26:01 +0200637_iso-8859-1 Hi, Sorry - sent the wrong reply

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390 yassini@bezeqint.net ----- Original Message ----- From: "Kenney, Marty" Newsgroups: bit.listserv.db2-l To: Sent: Friday, April 19, 2002 12:35 PM Subject: DB2 OS/390 & CICS Web interface



> We want to use CICS Web Interface to get at our DB2 OS/390 data for > our internet > applications. We have done a demo of this for our VP of IT and now > he would like > names of some companies that are actually doing this in [...] 22103 124 22_Re: Platinum detector.14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 19 Apr 2002 13:48:20 +0100373_iso-8859-1 Sibi,

If you are registered with StarTCC on the web, you should have access to all the CA documentation - including Detector.

Drop me a note off-list if you're still having problems

Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...] 22228 38 27_Re: Alternative GUI for DB211_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Fri, 19 Apr 2002 08:54:39 -0500429_US-ASCII I have had real good luck with granger sql. Check it out at: http://www.datatransformations.com/

Mark Ediger

>>> endyl@CENTRIN.NET.ID 04/19/02 06:40AM >>> Dear all,

I just like to know if there is any alternative GUI for DB2 other than Control Center. Like TOAD for Oracle. Because the Java based Control Center is a bit slow, so maybe anyone can tell me if there is any other alternative GUI. [...] 22267 63 62_Re: Question about replication between two DB2 UDB NT database15_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 19 Apr 2002 09:48:29 -0400346_iso-8859-1 It should be easy. I also am a OS390/DBA and recently have replication working between OS390/WINNT/ORACLE. To go from NT to NT make sure you can connect to both machines. Then you could use the CONTROL CENTER or download the DJRA to walk you through the replication defininition. The replication guide and reference has examples. [...] 22331 97 26_No new dataset with DSSIZE31_Douwe van Sluis, Infodemic B.V.26_d.b.van.sluis@INFODEMIC.NL31_Fri, 19 Apr 2002 16:02:07 +0200530_iso-8859-1 Dear List,

I am currently testing the DSSIZE parameter on the CREATE TABLESPACE. It was my expectation that one would get a new dataset after 8G if DSSIZE 8G was specified. This does not happen. The testload abends with X'00E40318', reason 00C90099 with the VSAM name of the partition I am loading. The HI-A_RBA is 8590049280 and the HI-U-RBA is 8589934592. So, extended addressability works. The VSAM is allocated using 12 Volumes, more candidate volumes are available. I use PRIQTY 720 and SECQTY 108000. [...] 22429 46 57_Re: refresh of table(s) in data prop without a cold start15_Neff, Stephen R16_NeffSR@STATE.GOV31_Fri, 19 Apr 2002 10:01:46 -0400388_iso-8859-1 I just saw this so you may already have a response. There is red book My Mother Thinks I'm a DBA! which has lots of good examples. Look at 5.6.3 Full Refresh on Demand.

-----Original Message----- From: Mark Buzzard [mailto:Mark_Buzzard@ARIC.COM] Sent: Monday, March 25, 2002 5:41 PM To: DB2-L@RYCI.COM Subject: refresh of table(s) in data prop without a cold start [...] 22476 51 27_Re: Alternative GUI for DB213_Keith Gilbert17_kgilbert@CSA1.COM31_Fri, 19 Apr 2002 09:27:13 -0500687_iso-8859-1 The same company that makes TOAD has one for DB2 called Quest Central for DB2. www.quest.com

Keith Gilbert Data Base Administrator Central Service Association Tupelo, MS (662) 842-5962 kgilbert@csa1.com www.csa1.com





-----Original Message----- From: Endy Lambey [mailto:endyl@CENTRIN.NET.ID] Sent: Friday, April 19, 2002 1:41 AM To: DB2-L@RYCI.COM Subject: Alternative GUI for DB2



Dear all,

I just like to know if there is any alternative GUI for DB2 other than Control Center. Like TOAD for Oracle. Because the Java based Control Center is a bit slow, so maybe anyone can tell me if there is any other alternative GUI. [...] 22528 101 23_V7 in Prod environments28_RICARDO ALEXANDRE LINO GOMES20_ricardo.gomes@BCP.PT31_Fri, 19 Apr 2002 15:26:11 +0100361_iso-8859-1 We're planning to move to V7.1 in the 3rd/4th Q this year. Our Production environment is a 4 Lpar Sysplex with two DB2 DataSharing Groups, one with 4 members, the other only two. Is there anyone out there with DB2 D.S on V7.1 in Production for time enough to feed me back some migration/daily-production experiences/hardships? Thanks in Advance [...] 22630 145 15_Re: DDL Logging15_Mike Brauweiler22_MikeBrau@ALUMNI.ND.EDU31_Fri, 19 Apr 2002 09:38:01 -0500506_iso-8859-1 RE: [DB2-L] DDL LoggingTo those who wish to know, the issue here was in fact one of having AUTOCOMMIT on. My thanks to Wayne Driscoll for supplying the command for turning it off:

UPDATE COMMAND OPTIONS USING C OFF

Curiously, setting autocommit=0 in the db2cli.ini file had no effect...

Mike

-----Original Message----- From: Mike Brauweiler [mailto:MikeBrau@ALUMNI.ND.EDU] Sent: Wednesday, April 17, 2002 12:18 PM To: DB2-L@RYCI.COM Subject: [DB2-L] DDL Logging [...] 22776 93 57_Re: refresh of table(s) in data prop without a cold start15_Jackson Reavill18_damcon2@US.IBM.COM31_Fri, 19 Apr 2002 10:47:10 -0400483_us-ascii There are multiple ways, but what I usually do is set the cd_old_syncpoint on asn.ibmsnap_register to null and then reinit Capture.

HTH, Jay



Jay Reavill damcon2@us.ibm.com IBM Global Services Tampa, Florida Tel: (813) 356-5317, Tie Line 8-697-5317

----------------------------------------------------- Happiness is not around the corner. Happiness is the corner. - Bavarian Motor Works ----------------------------------------------------- [...] 22870 34 77_Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility11_Leong, Werv24_wellington.leong@EDS.COM31_Fri, 19 Apr 2002 15:51:49 +0100459_iso-8859-1 Hi,

We are planning to upgrade from DB2 V5 to DB2 V7.

We are using Coolgen 4.1A and Oracle Transparent Gateway 4.01.1. with DB2 V5. However, both are no longer supported and are not certified for DB2 V7.

Will either of the above products still work with DB2 V7 ?

Cheerio

Werv Leong CI UK & Ireland Technical Services, Electronic Data Systems, 4 Roundwood Avenue, Stockley Park, Uxbridge, Middlesex, UB11 1BQ [...] 22905 207 30_Re: No new dataset with DSSIZE13_Bright, Randy20_Randy_Bright@BMC.COM31_Fri, 19 Apr 2002 10:15:11 -0500401_iso-8859-1 Reason code 00C90099 implies that you must be trying to load a partitioned object. Partitioned objects can never be extended to a second or subsequent dataset. If you did receive this on a non-partitioned object, you should report it to IBM support.

As far as APARs and PTFs, BMC Software, Inc. has issued a Technical Bulletin on this subject. Below is an excerpt from that TB: [...] 23113 22 52_Re: Problem with UDB 7.2 connecting to DB2 OS/390 v510_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Fri, 19 Apr 2002 10:09:42 -0500499_- Adrian/Marcus,

It looks like you're right!. I downloaded DB2 Connect PE as a separate option, installed it (it only took several hours) and I can now connect to the OS/390 subsystem. I was sure that it said Connect came with the UDB PE.... Why couldn't the error message be something nice and user-friendly, like "Oi, you haven't got Connect installed, so it won't work" Anyway, thanks for all the help from everyone. I'll try and read all the documentation more thoroughly next time. [...] 23136 12 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY9_Nguyen DT30_duc.nguyen@EUROCLEARFRANCE.COM31_Fri, 19 Apr 2002 10:11:44 -0500372_- Thank you Phil & Michael I should read the IBM documentation first. didn't think that dsn1copy could load dataset dynamically ..

================================================ 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. 23149 129 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 19 Apr 2002 17:01:56 +0100530_iso-8859-1 You know,

It never used to be documented all that well anyway, I only stumbled across it by accident once when I noticed more allocation messages in my job than DD cards!!

Also, I notice no-one has answered my related question about the 'J' instance datasets after an on-line reorg with Fastswitch. I'm assuming that DSN1COPY will just look for I0001 datasets and fail if they're not there. After all, it's a stand-alone utility so it can't look in SYSxxxPART for the correct instance letter to use! [...] 23279 16 30_Re: No new dataset with DSSIZE23_Jain, Sanjay (Exchange)19_sanjayjain@BEAR.COM31_Fri, 19 Apr 2002 11:58:40 -0400588_us-ascii **************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************

================================================ 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. 23296 127 19_FW: FULL OUTER JOIN10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 19 Apr 2002 10:13:10 -0600602_iso-8859-1 Hi List, Thanks all of you who answered my question. They all worked perfect.

Grace -----Original Message----- From: Grace Chen Sent: Wednesday, April 10, 2002 2:29 PM To: DB2 list (E-mail) Subject: FULL OUTER JOIN



Hi list, For the unpaired row of FULL OUTER JOIN result table, which value should I used to test? For example, I want to know if B.COST is an unpaired row then give me A.COST. If A.COST is unpaired row then give me B.COST otherwise give me A.COST+B.COST. Following statement has no syntax error, but the result always go to A.COST+ B.COST. If I use [...] 23424 144 59_Re: Database Transfer from one DB server to other DB server13_Larry Hubbard25_larry_hubbard@YLASSOC.COM31_Fri, 19 Apr 2002 11:12:35 -0500340_iso-8859-1 In the new system you could issue a "set schema" statement to the schema of the old before you issue your SQL statements. Or you could define aliases for each table object in the new database with each having the schema name that you desired to use.

HTH Larry Hubbard Yevich, Lawson and Associates, Inc. 217-744-0000 [...] 23569 22 27_UDB (midrange) Archive logs14_Linda Hagedorn30_Linda.Hagedorn@EMBARCADERO.COM31_Fri, 19 Apr 2002 09:15:05 -0700601_iso-8859-1 I'm looking for the UDB midrange equivalent for the os/390 DB2 components/utilities:

BSDS (location of the archive log files record and their dates/ranges) DSNJU004 (dumps the contents of the BSDS) DSN1LOGP (dumps the contents of the archive logs)

Is there an equivalent API to sqlurlog that reads the archive logs?

Thanks, Linda

===============================================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. 23592 40 37_Replication question on DB2 UDB V6 NT0_20_John_Lendman@FPL.COM31_Fri, 19 Apr 2002 12:27:53 -0400332_us-ascii Well I have started doing the replication from one UDB DB to another. And I followed the example in the book. I am still at the stage where I am working on SAMPLE. I seemed to have been successful in getting the replication to happen when I start and stop the CAPTURE AND APPLY, but not when I add data to the source. [...] 23633 53 81_Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility14_Harvey Puckett19_hpuckett@GTA.GA.GOV31_Fri, 19 Apr 2002 12:43:24 -0400401_us-ascii Dunno about CoolG but the OTG can be upgraded to the 8.1.x release which is V7 ready ...

-----Original Message----- From: Leong, Werv [mailto:wellington.leong@EDS.COM] Sent: Friday, April 19, 2002 10:52 AM To: DB2-L@RYCI.COM Subject: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility

Hi,

We are planning to upgrade from DB2 V5 to DB2 V7. [...] 23687 33 58_Re: Length of diagnostic message in an UDF (V6 for OS390 )13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Fri, 19 Apr 2002 11:44:27 -0500565_- James I did look at that and I've a few UDF's working fine with 72 byte definition but the problem is that once in a while I get a sqlcode -450 ( USER-DEFINED FUNCTION OR STORED PROCEDURE name, PARAMETER NUMBER parmnum, OVERLAYED STORAGE BEYOND ITS DECLARED LENGTH.) with parmnum pointing to message text parameter. I don't see how my code could do it as it's just moving a message less than 70 bytes to this field. Then looking through the manual I noticed the discrepency i.e. with a definition of VARCHAR(70) DB2 should allocate a 72 byte area instead of [...] 23721 82 19_DB2 tablespace size10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 19 Apr 2002 11:02:33 -0600401_iso-8859-1 Hi List, Does anyone there know why the SPACE column in SYSTABLESPACE and SYSTABLEPART is different even it is non-patitioned tablespace ? And I also found these two values are different with the value that calculated from VSAM catalog. Which one should I trust?

Grace Chen Technical Support Credit Union Central Alberta Ltd. Tel: (403) 258-5982 E-mail : gchen@cucentral-ab.com [...] 23804 90 42_connecting to distributed data base system10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 19 Apr 2002 11:15:32 -0600425_iso-8859-1 Hi! I am trying to setup DB2 connection between two OS/390 DB2 systems with TCP/IP. I setup SYSIBM.LOATIONS and SYSIBM.IPNAME tables on one of my DB2 system and trying to connect it to another DB2 system. Does anyone know how can I test it? I tested under SPUFI with command: CONNECT TO location name USER userid USING password I got error -104. If I didn't give it USER and I got unacceptable SQL statement. [...] 23895 27 31_Re: OS levels for DB2 V6 and V712_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Apr 2002 12:11:45 -0500419_- The minimum release levels are documented in the Release Guides. Start at ibm.com/software/db2os390

Click on Library, choose the version, choose the Release Guide, then look for an appendix on prerequisites.

Today, the more relevant factor is which versions of OS/390 are orderable or in service. You can click on OS/390 from the DB2 page above or start at http://www-1.ibm.com/servers/s390/os390/ [...] 23923 68 41_Re: Replication question on DB2 UDB V6 NT18_Gert van der Kooij16_gkooij@XS4ALL.NL31_Fri, 19 Apr 2002 19:24:51 +0200379_iso-8859-1 Hi,

It could be caused by the default time the apply waits before checking a subscription again. I used the DJRA tool to define my subscriptions and it defaulted to 60 minutes.

Check the SLEEP_MINUTES column in the ASN.IBMSNAP_SUB_SET table. If it is set to high you can alter it to any value you like and it will be picked up immediately by apply. [...] 23992 108 23_Re: DB2 tablespace size13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 19 Apr 2002 18:38:10 +0100498_iso-8859-1 I just spotted that yesterday! So I'd love a good explanation, too.

I think it depends on when you runstated or stospaced it. It might even be these things can be done at the partition level.

Suffice it to say I had such a headache when I couldn't get sense out of compression stats (which are at part level) versus SYSTABLESPACE view. Turns out I was using value in SYSTABLEPART with its corresponding compression % in the naive belief part and ts would be the same. [...] 24101 119 23_Re: DB2 tablespace size12_Amit Agarwal33_amit_agarwal@STANDARDANDPOORS.COM31_Fri, 19 Apr 2002 13:40:40 -0400636_us-ascii Is it true for all tables ? I queried a few tables and found the SPACE value in both SYSTABLESPACE and SYSTABLEPART to be the same. Amit







Grace Chen on 04/19/2002 01:02:33 PM



Please respond to DB2 Data Base Discussion List





To: DB2-L@RYCI.COM

cc: (bcc: Amit Agarwal/FIS)





Subject: DB2 tablespace size











This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. [...] 24221 115 41_Re: Replication question on DB2 UDB V6 NT0_20_John_Lendman@FPL.COM31_Fri, 19 Apr 2002 14:07:02 -0400407_us-ascii Gert thank you, my sleep time is set at 480 minutes. That has to be it. I will change it right away.

Thanks Again

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





"Gert van der Kooij" To: DB2-L@RYCI.COM Subject: Re: Replication question on DB2 UDB Sent by: "DB2 V6 NT Data Base Discussion List" [...] 24337 167 23_Re: DB2 tablespace size13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 19 Apr 2002 19:19:09 +0100489_us-ascii For me some were close some nowhere near. But my sample is small.

Martin

Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)





Amit Agarwal cc: Sent by: DB2 Data Base Subject: Re: DB2 tablespace size Discussion List



19/04/02 18:40 Please respond to DB2 Data Base Discussion List [...] 24505 114 41_Re: Replication question on DB2 UDB V6 NT0_20_John_Lendman@FPL.COM31_Fri, 19 Apr 2002 14:27:59 -0400467_us-ascii No I was wrong. I had changed the time to 480 minutes myself. I also changed it back to 1 minutes and when I update the source it does not replicate to the target. Any other ideas?

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





"Gert van der Kooij" To: DB2-L@RYCI.COM Subject: Re: Replication question on DB2 UDB Sent by: "DB2 V6 NT Data Base Discussion List" [...] 24620 152 23_Re: DB2 tablespace size13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 19 Apr 2002 14:32:58 -0400501_iso-8859-1 The STOSPACE utility updates the SPACE column of SYSIBM.SYSTABLESPACE. The STOSPACE utility or RUNSTATS TABLESPACE UPDATE(ALL) will both update the SPACE column of SYSIBM.SYSTABLESPACE.

Since you probably run both utilities and at different times you would most likely have different values in the two tables.

Since these utilities have to run be run to update those columns they would most likely never match the calculations done on the VSAM catalog for active tables. [...] 24773 75 66_Re: [DB2EUG] DB2 instance crash during rollforward using user exit11_Jeremy Dodd21_jeremy.dodd@WHICH.NET31_Fri, 19 Apr 2002 19:36:19 +0100564_us-ascii Phil,

I know that we had the same problem at V6.1 - but I couldn't tell you what fix level we were at. We had a special build made for us to solve the problem. Of course that was when V6 was supported!!

Cheers,

Jeremy



"Philip Nelson (DBA)" wrote:

> DB2 V6.1 on AIX : fixlevel U473545. > > I'm writing and testing a user exit for log handling. > > It successfully is archiving logs, both to another directory and to TSM. > > Now testing the retrieve processing. > > Last backup needs logfile 68. Last log in [...] 24849 32 36_Reasonable size for an LDAP database0_24_lightsey@ITS.STATE.MS.US31_Fri, 19 Apr 2002 13:39:12 -0500372_us-ascii As a soon-to-be user of LDAP in some way, shape, or form I could use some idea of how large I need to size the containers for the DB2 database that will back it. Guess-timated numbers of victims range from 200 in the pilot phase to potentially a couple of million with whatever kind of data that the LDAP/single-signon/e-signature/??? processes will entail. [...] 24882 107 10_C Cics Db230_Monica Maria Pinheiro e Coelho36_monica.coelho@BRADESCOSEGUROS.COM.BR31_Fri, 19 Apr 2002 15:51:57 -0300499_iso-8859-1 Hi, list

I wonder if someone could help me. The problem is there I don´t know even what to ask. We´re begining to test C with DB2. We have tested a COBOL BATCH problem that calls a C DB2 BATCH problem, and everything goes ok. We have a Cobol CICS program that calls a C CICS DB2 program, and nothing happens. When we do a CEDF in the first program, we could not even see the C CICS DB2 one. Do we have to do something on CICS ? Do we have to define the C CICS problem on CICS [...] 24990 138 57_Re: Restore TS with a Full Copy not referenced in SYSCOPY15_Murley, Michael22_Michael_Murley@BMC.COM31_Fri, 19 Apr 2002 14:34:38 -0500424_iso-8859-1 Phil,

I wondered about the I/J question, too, so I tried a test and found that it works OK if all data sets in a partitioned table space have the same 5th node (either I or J). It doesn't work if you have some I data sets and some J data sets (i.e. after a partition reorg with FASTSWITCH). I was about to whine that this should be noted in the doc, but then I discovered that it is noted in the doc: [...] 25129 112 46_Re: connecting to distributed data base system10_Grace Chen22_gchen@CUCENTRAL-AB.COM31_Fri, 19 Apr 2002 13:37:27 -0600354_iso-8859-1 Adam, Thanks for your reply. I think my TCP/IP configuration is correct since all incoming connection from DB2 Connect are TCP/IP. I also populated CDB tables. My problem is how can I test the connectivity from DB2 for OS/390 to another DB2 for OS/390. If I only issue CONNECT TO locationname and how can I supply my userid and password. [...] 25242 19 26_Text to all caps on INSERT9_Don Cross20_Don.Cross@TC.FAA.GOV31_Fri, 19 Apr 2002 09:11:38 -0400337_us-ascii What is the best way to have mixed case text changed to all caps on insert? Would this best be done on the application side? We are running v6 on os390v2.9. Our users are connecting thru ODBC on DB2 Connect and are using a Visual Basic application to insert,update,delete.

The DB2 manuals don't say much about case. [...] 25262 17 41_Re: Replication question on DB2 UDB V6 NT18_Gert van der Kooij16_gkooij@XS4ALL.NL31_Fri, 19 Apr 2002 21:59:31 +0200439_iso-8859-1 Hi John,

Did you check the ASN.IBMSNAP_APPLYTRAIL table in the apply database? Also some errors could be written to the log file within the ASNPATH directory which could help you.

================================================ 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. 25280 25 30_Visual Explain DSNWZP question12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Fri, 19 Apr 2002 15:07:32 -0500411_iso-8859-1 If you bring up Visual Explain, connect to your DB2 on Z/OS and then select the read of the ZPARMS, you will have a list of parameters in the list box. Select UMCCSID. The value and the other information is displayed with the exception of the description. The description reads "[DSNZPMsgs.] is not a valid number within DSNZPMsgs." Does anyone know where I can find documentation on DSNZPMsgs? [...] 25306 17 16_DB2 Data Sharing11_Barnes, Don16_Barnes@AAFES.COM31_Fri, 19 Apr 2002 15:06:43 -0500463_iso-8859-1 We are in the planning stages of Data Sharing for DB2 and I would like to know if anyone has already implemented Data Sharing for DB2 and how did they go about implementing Data Sharing.



D Barnes

================================================ 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. 25324 112 20_Re: Why is log full?14_Steve Westfall26_Steve.Westfall@EQUIFAX.COM31_Fri, 19 Apr 2002 15:50:33 -0500314_us-ascii Thanks for the feedback, Daniel. Sounds like this is an unexpected "feature" of DB2. If that is really what is happening, I would think that the "ALTER TABLE xx ACTIVATE NOT LOGGED INITIALLY" command should be redesigned so that it is somehow not a part of the unit of work that is not to be logged. [...] 25437 36 30_Re: Text to all caps on INSERT0_22_Rohn.Solecki@MTS.MB.CA31_Fri, 19 Apr 2002 16:02:27 -0500291_us-ascii Well, there are the TRANSLATE and UPPER or UCASE built in functions, but I don't see that they work on an insert. And since you are running the app front end not on the main frame (VB right), why not take this opportunity to 'off load' a couple of cycles from mainframe to PC. [...] 25474 29 48_How often should you image copy DSNDB06.SYSCOPY?0_34_L-IS.Kirkpatrick@MUTUALOFOMAHA.COM31_Fri, 19 Apr 2002 15:24:47 -0500521_us-ascii Does anyone have any thoughts on how often tablespace DSNDB06.SYSCOPY should be copied? We currently copy this daily. However, we began running a "REPORT RECOVERY" utility recently and specified the "CURRENT" option. Sometimes when this is done for tablespace DSNDB06.SYSCOPY, the report runs for almost two hours. Would this mean that an actual recovery of this tablespace would also run for almost two hours (since gathering the recovery information for a forward recovery is also done at recovery time)? [...] 25504 50 14_Re: C Cics Db216_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Fri, 19 Apr 2002 23:28:52 +0200601_ISO-8859-1 Several question:

1.How did you invoke the C-program (CALL, Exec Cics Link)? 2. Did you use the CICS LE interface (DFHELII) in your binder includes for both programs

Roland

> -----Original Message----- > From: Monica Maria Pinheiro e Coelho [SMTP:monica.coelho@BRADESCOSEGUROS.COM.BR] > Sent: Friday, April 19, 2002 8:52 PM > To: DB2-L@RYCI.COM > Subject: C Cics Db2 > > Hi, list > > I wonder if someone could help me. The problem is there I don> ´t know even what to ask. We´re begining to test C with DB2. We have tested a COBOL BATCH problem that calls a C DB2 [...] 25555 120 23_Please take me off list10_Andy Stein22_jbak2009@AMERITECH.NET31_Fri, 19 Apr 2002 16:55:44 -0500546_us-ascii At 03:50 PM 4/19/02 -0500, you wrote: >Thanks for the feedback, Daniel. Sounds like this is an unexpected >"feature" of DB2. If that is really what is happening, I would think that >the "ALTER TABLE xx ACTIVATE NOT LOGGED INITIALLY" command should be >redesigned so that it is somehow not a part of the unit of work that is not >to be logged. > >Steve > > > > > Daniel Rieger > ONLINE.DE> cc: > Sent by: DB2 Data Subject: Re: Why is log > full? > Base Discussion > List > > > [...] 25676 64 14_Re: C Cics Db213_Seibert, Dave26_Dave_Seibert@COMPUWARE.COM31_Fri, 19 Apr 2002 17:57:06 -0400503_iso-8859-1 Hi Monica,

My direct CICS experience is about 4 years rusty. So I'm counting on someone else to provide more current correction or update if I'm wrong on any of this. Let's clarify a couple things.

You say you have a COBOL CICS program which calls a C CICS program. 1) How does the COBOL program call the C program? a. EXEC CICS LINK ? b. Cobol Call statement? c. EXEC SQL Call ? 2) Does the C program use CICS facilities? In other words does it contain CICS instructions? [...] 25741 19 27_Re: Please take me off list14_Herring, Bobby19_BHerring@SFBCIC.COM31_Fri, 19 Apr 2002 17:00:27 -0500555_iso-8859-1 See the note at the bottom of the message:



> > ================================================ > > 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.

================================================ 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. 25761 52 27_Re: Alternative GUI for DB217_Robert J. Milonas20_xrjmbob@NETSCAPE.NET31_Fri, 19 Apr 2002 20:12:17 -0400657_iso-8859-1 We use a product called AQT. It can access several different releational databases (Oracle, DB2, SQL SVR, Sybase, MySQL, etc). And it works pretty much the same for all. It runs fast, has a lot of nice features. Costs $100 a copy from Cardett - http://www.querytool.com/



Mark Ediger wrote:

>I have had real good luck with granger sql. Check it out at: >http://www.datatransformations.com/ > >Mark Ediger > >>>> endyl@CENTRIN.NET.ID 04/19/02 06:40AM >>> >Dear all, > >I just like to know if there is any alternative GUI for DB2 other than >Control Center. Like TOAD for Oracle. Because the Java [...] 25814 17 27_Re: V7 in Prod environments12_Roger Miller19_millerrl@US.IBM.COM31_Fri, 19 Apr 2002 19:26:24 -0500420_- Roughly 20% of the US customers are running V7 now, but production hard to track. This has been the easiest release migration I have ever worked on. Be sure that the CCSIDs are set correctly, service levels are current, and you have not skipped some steps or ignored some incompatibilities. I put what customers told me into the foils on our web support page. Get the education - a transition class, if possible. [...] 25832 110 38_Re: DB2 Compression utility - DSN1COMP31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Sat, 20 Apr 2002 04:36:32 +0100580_iso-8859-1 I believe its more to do with DSN1COMP being stand along utility than the online utility.

Its interesting to say what IBMers have to say.

With Best Regards, Sanjeev

--- mebert@AMADEUS.NET wrote: > DSN1COMP is a utility designed to give you an > estimate on how much you can > save if you compress a tablespace. This more or less > implies that it can > (should) be run only on TSs that are uncompressed. > In your case, obviously > most TSs are already compressed. So you shouldn't > run DSN1COMP, instead > run RUNSTATS (if not done already) [...] 25943 25 38_Re: DB2 Compression utility - DSN1COMP31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Sat, 20 Apr 2002 08:24:04 +0100492_iso-8859-1 I am sorry, last e-mail was written in hurry.

I think the DSN1COMP is a stand alone utility and this is the reason it can't check the catalog whether a tablespace is already compressed or not. This is the reason it considers it as an error message.

With Best Regards, Sanjeev

________________________________________________________________________ For live cricket scores download Yahoo! Score Tracker at: http://in.sports.yahoo.com/cricket/tracker.html [...] 25969 17 54_Barbara Kilburn/Santa Teresa/IBM is out of the office.15_Barbara Kilburn19_bkilburn@US.IBM.COM31_Sat, 20 Apr 2002 01:24:10 -0600510_us-ascii I will be out of the office starting April 19, 2002 and will not return until April 29, 2002.

I will respond to your message when I return on Monday April 29, 2002. For management issues, see Norma Fries. For team and production issues see Mary Paquet.

================================================ 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. 25987 69 30_Re: Text to all caps on INSERT31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Sat, 20 Apr 2002 08:41:57 +0100593_iso-8859-1 What about

SELECT UCASE(:HV) FROM SYSIBM.SYSDUMMY1, before INSERT?

I think this should work.

With Best Regards, Sanjeev

--- Rohn.Solecki@MTS.MB.CA wrote: > Well, there are the TRANSLATE and UPPER or UCASE > built in functions, but I > don't see that they work on an insert. And since > you are running the app > front end not on the main frame (VB right), why not > take this opportunity > to 'off load' a couple of cycles from mainframe to > PC. > > > > > > Don Cross @RYCI.COM> on > 2002/04/19 08:11:38 AM > > Please respond [...] 26057 20 50_Reorg utility options (SORTDATA NOSYSREC SORTKEYS)17_Christophe Radier17_c300501@YAHOO.COM31_Sat, 20 Apr 2002 02:29:28 -0500446_- Hi all ,

I'm planning to put these 3 options in my Platinum Reorg. Model used in the Production environment , as i notice i don't need anymore SYSREC , SORTOUT , SYSUT1 DDnames - ( I use SORTDEVT and SORTNUM so no SORTWK DDs too ) But , i am a bit afraid about the performance issue when the reorg is applied on a big table space , which parameters allow to give more "rooms" to DB2 to achieve the reorg ? SORTNUM and REGION size ? [...] 26078 33 34_Hiperpools & fixed frames (in MVS)12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sat, 20 Apr 2002 11:04:45 +0200383_windows-1255 Hi,

Lately we started to have too many fixed frames in MVS (OS/390 V2.10), both above and blow the line.

Hiperpools definition is one of the contributors to this. I would like to collect some info about HP usage and fixed frames usage by xxxDBM1 (both above & below).

Please email me directly - I'll compile the results and put it on the list. [...] 26112 56 58_Re: Length of diagnostic message in an UDF (V6 for OS390 )14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 20 Apr 2002 19:20:50 +1000402_US-ASCII Mohannad

What is the actual code you use for parameter and the code used to move the message. If you have, for a COBOL example,

01 LK-MESSAGE 05 LK-MESSAGE-LEN PIC S9(4) COMP. 05 LK-MESSAGE-DATA PIC X(72). ... MOVE 'SHORT MESSAGE' TO LK-MESSAGE-DATA

you are moving 72 characters into LK-MESSAGE-DATA (includes the trailing spaces). Are you doing something like this? [...] 26169 52 24_Re: DB2 Storage question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 20 Apr 2002 19:20:50 +1000585_US-ASCII Michael

You are correct - obviously a corrupted memory cell needs replacing.

James



On 19 Apr 2002 at 10:03, mebert@AMADEUS.NET wrote:

> Hi James, > > since when can simple/segmented TSs use up to 16 4GB Datasets? I think > that normal non-partitioned TSs can use up to 32 2GB Datasets (that's what > the SQL ref for V6 and personal experience say). Note that LARGE and > DSSIZE can only be used for partitioned TSs. LOB TSs can have up to 254 > 64GB Datasets (default DS size 4GB). > > Dr. Michael Ebert > DB2 Database Administrator > [...] 26222 45 21_Re: DSN1COPY problems17_Robert J. Milonas20_xrjmbob@NETSCAPE.NET31_Sat, 20 Apr 2002 07:43:31 -0400667_iso-8859-1 You could try reorging the tablespace. This will correct or show up errors in the table.



David Nance wrote:

> I am trying to recover a table that was dropped. I have an image copy from a day before the drop. I am running DSN1COPY using the following parms 'CHECK,FULLCOPY,OBIDXLAT,RESET' this completes successfully(return code 0). I restart the tablespace and no matter what I do I recieve the following abend: >DSNI014I -DBT1 DSNISNPG DATA IN USE DURING ABEND > REASON 00C90101 > ERQUAL 5010 > TYPE 00000302 > NAME DDSNCPY .SDSNCPY .X'00000001' > CONNECTION-ID=UTILITY > CORRELATION-ID=A9139IDX > LUW-ID=* > [...] 26268 100 52_Re: How often should you image copy DSNDB06.SYSCOPY?0_18_mebert@AMADEUS.NET31_Sat, 20 Apr 2002 14:29:00 +0200572_us-ascii We copy the DB2 Catalog/Directory daily.

DSNDB01.DBD01, DSNDB01.SYSUTILX, and DSNDB06.SYSCOPPY Image copies are not recorded in SYSCOPY, instead the corresponding entry is written to the log stream. That means that if you do a RECOVER on these TSs, DB2 has to search the logs backward to find the recovery dataset information. Depending on the number of active logs and their sizes, this most likely means that archive logs have to be recalled. I guess that's where your two hours are mostly spent. Doing a manual HRECALL should speed the process up. [...] 26369 90 39_Re: ADO Update with DateTime columns...11_Grant Allen22_grant@TOWERSOFT.COM.AU31_Sat, 20 Apr 2002 23:41:02 +1000647_iso-8859-1 Dimoka Popy[SMTP:dimokap@INTERAMERICAN.GR] wrote: > >Hello List! > >I am trying to "migrate" an VB application from SQL Server to DB2 for > >OS/390.We use VB6,MDAC 2.6(2.7 also),DB2 Connect PE 7.2 and DB2 V6.1.1 > for > >OS/390.There seems to be a problem when trying to update > date,time,timestamp > >values through a Recordset Update(rs.update) or even when updating the > >non-datetime columns of a table that contains datetime columns.The errors > >vary from : > > > >1.[IBM][CLI Driver][DB2]SQL0181n The string representation of a datetime > >value is out if range.SQLSTATE 22007 > >2.Type mismatch > >3.The OLE DB Operation [...] 26460 47 54_Re: Reorg utility options (SORTDATA NOSYSREC SORTKEYS)31_=?iso-8859-1?q?Sanjeev=20....?=24_sanjeev_db2l@YAHOO.CO.IN31_Sat, 20 Apr 2002 17:30:47 +0100527_iso-8859-1 I believe both are important for efficient running. Which version of DB2 you are in?

With Best Regards, Sanjeev

--- Christophe Radier wrote: > Hi all , > > I'm planning to put these 3 options in my Platinum > Reorg. Model used in the > Production environment , as i notice i don't need > anymore SYSREC , > SORTOUT , SYSUT1 DDnames - ( I use SORTDEVT and > SORTNUM so no SORTWK DDs > too ) > But , i am a bit afraid about the performance issue > when the reorg is > applied on [...] 26508 16 14_DB2 DBA Wanted10_Rami Mohan21_pleniumcorp@YAHOO.COM31_Sat, 20 Apr 2002 11:22:36 -0500559_- Urgent requirement for a DBA with strong experience in DB2 for OS/390. This position is in the North East. Experience with enterprise software SAP, Siebel, Peoplesoft is a definite plus. Please send resume to pleniumcorp@yahoo.com with expected salary. No visa sponsorship possible.

Rami Mohan, Sr. Recruiter

================================================ 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. 26525 85 30_Re: Text to all caps on INSERT13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Sat, 20 Apr 2002 13:49:45 -0500481_iso-8859-1 Don,

Since you are V6, the simplest is merely to wrap the literals or hostvariables in the UCASE or LCASE function in the values clause dependant on whether you want upper or lower case. Such as:

INSERT INTO TABLE VALUES (UCASE(:HV1), LCASE(:HV2), UCASE('abc')) etc.....

Regards Terry Purcell Yevich Lawson & Assoc Inc (YL&A) IBM Gold Consultant - DB2 IBM Certified Solutions Expert DB2 V7 Database Administration OS/390 http://www.ylassoc.com [...] 26611 14 37_Software Symposium 2002 Agenda posted12_Roger Miller19_millerrl@US.IBM.COM31_Sat, 20 Apr 2002 14:11:11 -0500510_- The agenda for the Software Symposium 2002 to be held in Vienna, Austria, June 10 - 14 is posted on the web now. There are pdf files for the WebSphere, Data Management, & Tivoli tracks now.

http://www.ibm.com/services/learning/conf/europe/sfw_symp/tracks.html

================================================ 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. 26626 20 15_REVOKE BINDAUTH7_Su Arun22_subha_sivaji@YAHOO.COM31_Sat, 20 Apr 2002 18:50:03 -0500365_- Hi Listers,

I have a situation where the user bound a plan some time in 2000 with SYSPLAN table showing an entry . But when I try to query the SYSPLANAUTH table now , I cannot see his entry in the GRANTOR/GRANTEE column with BINDADD . Is it because of his BINDADD is being revoked . Is there any way to trace this . Any thoughts will be a great help. [...] 26647 10 54_Re: Reorg utility options (SORTDATA NOSYSREC SORTKEYS)17_Christophe Radier17_c300501@YAHOO.COM31_Sun, 21 Apr 2002 02:26:31 -0500302_- I'm running on DB2 V5.1 but we are going on 7.1 in a month

================================================ 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. 26658 20 50_How to know the current "CURRENT RULES" register ?17_Christophe Radier17_c300501@YAHOO.COM31_Sun, 21 Apr 2002 04:44:26 -0500306_- DB2 OS/390

Hi all, I've searched in the doc but have seen nothing on it - The doc says that it is set by the SQLRULES Bind option - But how to know when i am executing under SPUFI , QMF ..etc , how can i (easily , not have to check in the catalog ) know what Bind Option these products use ? [...] 26679 34 30_Re: Text to all caps on INSERT13_Mackey, Glenn21_GMackey@GUIDEMAIL.COM31_Sun, 21 Apr 2002 12:59:04 -0500560_iso-8859-1 You can setup a trigger to convert the data to upper case on INSERT and/or UPDATES.

-----Original Message----- From: Don Cross [mailto:Don.Cross@TC.FAA.GOV] Sent: Friday, April 19, 2002 8:12 AM To: DB2-L@RYCI.COM Subject: Text to all caps on INSERT



What is the best way to have mixed case text changed to all caps on insert? Would this best be done on the application side? We are running v6 on os390v2.9. Our users are connecting thru ODBC on DB2 Connect and are using a Visual Basic application to insert,update,delete. [...] 26714 55 58_Re: Length of diagnostic message in an UDF (V6 for OS390 )13_Mohammad Khan20_mkkhan88@HOTMAIL.COM31_Sun, 21 Apr 2002 13:26:21 -0500369_- James The COBOL definition is as follows : 01 LK-MESSAGE. 49 LK-MSG-LEN PIC S9(4) COMP. 49 LK-MSG-DATA PIC X(70).

I referred to it as 72 byte definition because of its being 2 (length prefix) + 70 ( data ). While in case of error my code did this : MOVE 70 TO LK-MSG-LEN. MOVE 'SHORT MESAGE' TO LK-MSG-DATA. otherwise my code left these parameters alone. [...] 26770 97 81_Re: Coolgen 4.1A and/or Oracle Transparent Gateway 4.01.1 - DB2 V7 co mpatibility12_Raymond Bell17_rbell@NZ1.IBM.COM31_Mon, 22 Apr 2002 09:43:08 +1200355_us-ascii Hi Werv (or is it Wellington?),

I dunno about CoolGen either, but we've got OTG 4.0.1.1 and SQL*Net 8.0.3.0.5 and we're also going to be upgrading DB2 from V5 to V7. Harvey's right in that you (and I) will have to upgrade the OTG (and SQL*Net, which apparently comes with the OTG) to 8.1.7, which is the version that supports DB2 V7. [...] 26868 71 46_Re: connecting to distributed data base system12_Raymond Bell17_rbell@NZ1.IBM.COM31_Mon, 22 Apr 2002 09:45:06 +1200505_us-ascii Grace,

If you want to query one subsystem from another, you could go into QMF and 'Select * from ssid.Sysibm.Sysdatabase' and see what happens. Or, in SPUFI, you could give the ssid at the '10 Connection Location' field and try to connect there.

Hope this helps,



Raymond





Grace Chen cc: Sent by: DB2 Data Subject: connecting to distributed data base system Base Discussion List [...] 26940 229 44_Re: AW: What's the name of the SAS-DB2 plan?12_Raymond Bell17_rbell@NZ1.IBM.COM31_Mon, 22 Apr 2002 09:51:00 +1200536_iso-8859-1 Hi Glenn (and others),

Sorry for not replying sooner - got caught up in stuff and then forgot this for awhile. Glenn, the solution you suggest won't work for SAS as SAS assumes the name of the package is the name of the plan. By which I mean it seems to take the program name from the plan name, and then go searching in Sysibm.Syspackage for a package of this name. The only answer if you wanna pick your own plan name is to edit the package to match your chosen name and bind that. Thanks to Ermanno and others [...] 27170 44 45_Andrew Leung/FBS/Fortis is out of the office.12_Andrew Leung23_Andrew_Leung@CGU.COM.AU31_Mon, 22 Apr 2002 08:02:20 +1000880_us-ascii **************************************************************************

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.

************************************************************************** : I will be out of the office from 22/04/2002 until 26/04/2002.

I will respond to your message when I return.



: ********************************************************************************

The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. [...] 27215 17 47_Richard Strong/MAN/Candle is out of the office.14_Richard Strong25_Richard_Strong@CANDLE.COM31_Mon, 22 Apr 2002 01:00:52 +0100467_us-ascii I will be out of the office starting 19/04/2002 and will not return until 29/04/2002.



If you require an update to a problem, or are providing an update for a problem, please email uk_support@candle.com

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-REQUEST@RYCI.COM. 27233 23 62_Re: Question about replication between two DB2 UDB NT database9_Eric Kwai18_Eric_Kwai@DTCC.COM31_Sun, 21 Apr 2002 21:48:19 -0500351_- John: There is a lot of reading and research for DPropR. Compare to Oracle and other relational DB. DB2 Replication is not a walk in the park.

There are two ways you can manage Data Replication in UDB. You can use control center or DJRA. I'll recommend you to first read the DB2 Replication Guide and review the following presentations. [...] 27257 15 33_John Ordman is out of the office.0_29_John_Ordman@READERSDIGEST.COM31_Mon, 22 Apr 2002 01:01:23 -0400389_us-ascii I will be out of the office starting 04/19/2002 and will not return until 04/29/2002.

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.