1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2002, week 5 2 77 53_Re: DSNH310I W Host Variable Declared in File Section14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 29 Dec 2002 23:58:54 +1000347_US-ASCII Donnie,

If you add the statement MOVE ZERO TO SQL-INIT-FLAG immediately before _every_ sql statement that uses a host variable in the file section you should (which doesn't mean you always will) be OK. This does have the overhead of making the program re-resolve all addresses in parameter lists for every such SQL statement. [...] 80 72 31_Re: DB2 UDB List availability ?7_Dak Mac17_gdm_db2@YAHOO.COM31_Sun, 29 Dec 2002 07:56:25 -0800731_us-ascii

Thanks a million for this

Dak



Philip Nelson wrote:There is a UDB specific mailing list called DB2EUG

Subscribe to this by sending an e-mail to -

db2eug-request@lugwash.org

In the body of the message you should have -

subscribe email-address

More details are on the following website -

http://arnoud.best.vwh.net/db2eug/

HTH

Phil Nelson ScotDB Limited (teamdba@scotdb.com)

On Wed, 2002-12-25 at 13:01, Dak Mac wrote: > > Dear Gurus, > I see this list most talks here about DB2 on Mainframe systems (OS/390), MVS etc, > Does anyone knows any list which talks about DB2 UDB on open systems such as AIX, [...] 153 50 31_Re: DB2 UDB List availability ?7_Dak Mac17_gdm_db2@YAHOO.COM31_Sun, 29 Dec 2002 09:12:46 -0800492_us-ascii

Thanks a lot Marcel. Marcel Harleman wrote:Hi Dak,

try comp.databases.ibm-db2.

Marcel.

> >Dear Gurus, >I see this list most talks here about DB2 on Mainframe systems (OS/390), MVS etc, >Does anyone knows any list which talks about DB2 UDB on open systems such as AIX, Solaris, HP , MSFT OSes etc. >Best. >Dak' > > > >--------------------------------- >Do you Yahoo!? >Yahoo! Mail Plus - Powerful. Affordable. Sign up now [...] 204 45 22_Re: Next key locks....14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sun, 29 Dec 2002 17:15:08 -0600481_- Did you read the Admin Guide section on "Lock Attributes" (or "Attributes of Locks" - depending on the version) which discusses when they are applied (or only the Certification Guide - which is rather weak on when they are used)? eg http://www-3.ibm.com/cgi- bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report? fn=db2v7d0c5lock.htm#HDRATTLCK

James Campbell

On Sat, 28 Dec 2002 21:18:06 -0800, Raquel Rodriguez wrote: [...] 250 15 49_Phil Sevetson/CISD/WAKEFERN is out of the office.13_Phil Sevetson26_Phil.Sevetson@WAKEFERN.COM31_Mon, 30 Dec 2002 01:02:31 -0500403_us-ascii I will be out of the office starting 12/27/2002 and will not return until 01/02/2003.

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://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 266 108 36_Dispatching Priority of Db2 Monitors31_Tekin Yavuz (Garanti Teknoloji)21_TekinY@GARANTI.COM.TR31_Mon, 30 Dec 2002 11:32:39 +0200 375 40 21_Display trace details30_=?iso-8859-1?q?Vijay=20Salvi?=23_vithalvijay@YAHOO.CO.IN31_Mon, 30 Dec 2002 11:26:18 +0000231_iso-8859-1

Hi All,

I'm looking out for details of trace started - want to know which IFCIDs are activate ? What is the -dis trace option for that ....?

Thanks in advance...





Vijay

416 21 42_Re: Accessing SQLCA within a SQL procedure19_Theo van Westrienen36_theo.van.westrienen@NL.MARTINAIR.COM31_Mon, 30 Dec 2002 06:11:15 -0600455_- Thanks for all the info and the references to the IBM site. But: I still don't understand whether it is (in v7) or will be possible (in vNext) to access SQLCA or at least the message text from within a SQL Procedure. Earlier this year (july) there was a thread called "Stored Procedure Error Checking", in which there was a reference to a few PTFs (a.o. PQ56323). We installed these, but I still cannot find a way to access the error message text. [...] 438 167 25_Re: Identity Column, -80312_Hynes, Carol27_Carol.Hynes@DWD.STATE.WI.US31_Mon, 30 Dec 2002 06:39:26 -0600481_iso-8859-1 Hi Steve, Here's how we solved this problem. We defined the production tables using the default for the START WITH parm. We defined the development tables using START WITH 1000000 or some number millions higher than we expect production to be. That way we can load production data to the development environment because the numbers are lower. When the numbers start to get close, you just drop and recreate your development tables using a higher START WITH number. [...] 606 16 46_How to INSERT a julian date in a DATE column ?18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 30 Dec 2002 15:07:49 +0100427_iso-8859-1 Hi all, I need to make an SQL INSERT specifying for a DATE column a julian date. But seem not possible to use any function (DATE) during insert so ... TIA. Bye.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 623 170 25_Re: Identity Column, -80311_David Nance16_DWNance@FHSC.COM31_Mon, 30 Dec 2002 09:40:13 -0500335_US-ASCII Steve, Another way you can get around this is by recreating your table and specifying what number to start with. This is a simpler solution than running a million inserts and defining a trigger on this table in a development region that now doesn't match your production region. Here's an example from the SQL reference. [...] 794 61 50_Re: How to INSERT a julian date in a DATE column ?10_Hessel Rus13_H.Rus@OTRA.NL31_Mon, 30 Dec 2002 15:57:51 +0100524_us-ascii If you want to insert an juliandate into a date columns just use this:

INSERT INTO ( , other_cols) VALUES ( DATE('juldate' e.g '2002364'), other_values)

The juliandate is transformed into a regular date (2002-12-30 in this case) and can be transformed back into a juldat via:

SELECT ( YEAR()*1000+DAYOFYEAR() AS JULDATE (in numeric format) or inte SELECT CAST ( YEAR()*1000+DAYOFYEAR() as char(7)) AS JULDATE (in character format) [...] 856 48 50_Re: How to INSERT a julian date in a DATE column ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 30 Dec 2002 09:10:07 -0600343_iso-8859-1 If you want the date as CCYYDDD, then you can use an insert statement in the following way:

INSERT INTO MYTABLE VALUES (:col1, :col2, YEAR(CURRENT DATE) * 1000 + DAYOFYEAR(CURRENT DATE))

This implies at least V6 on OS/390 which introduced the DAYOFYEAR function and expressions in the VALUES clause of an INSERT. [...] 905 81 49_R: How to INSERT a julian date in a DATE column ?18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 30 Dec 2002 16:14:04 +0100400_Windows-1252 Is it possible also in DB2 v5 ? Bye.

-----Messaggio originale----- Da: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]Per conto di Hessel Rus Inviato: luned́ 30 dicembre 2002 15.58 A: DB2-L@LISTSERV.YLASSOC.COM Oggetto: Re: How to INSERT a julian date in a DATE column ?



If you want to insert an juliandate into a date columns just use this: [...] 987 159 53_Re: R: How to INSERT a julian date in a DATE column ?10_Hessel Rus13_H.Rus@OTRA.NL31_Mon, 30 Dec 2002 16:32:43 +0100511_iso-8859-1 The "forward" transformation (juldate ==> date) i think is was possible in V5. Just try is with SELECT DATE('2002364') FROM sysibm.sysdummy1. But the "backward" transformation is not possible since DAYOFYEAR (and also CAST) is not available in V5.









Di Franco Vincenzo To: DB2-L@LISTSERV.YLASSOC.COM Subject: R: How to INSERT a julian date in a DATE column ? Sent by: DB2 Data Base Discussion List [...] 1147 112 50_Re: How to INSERT a julian date in a DATE column ?13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 30 Dec 2002 09:38:39 -0600414_Windows-1252 INSERT INTO MYTABLE SELECT :col1, :col2, YEAR(CURRENT DATE) * 1000 + DAYS(CURRENT DATE) - DAYS(SUBSTR(DIGITS(YEAR(CURRENT DATE - 1 YEAR)),7,4) CONCAT '-12-31') FROM SYSIBM.SYSDUMMY1

Messy but effective in V5.

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 [...] 1260 15 25_Re: Identity Column, -8030_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 30 Dec 2002 09:53:19 -0600357_us-ascii Thanks all -- I think the "Start With" option is just what we need for this case!

Stg

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 1276 20 25_Stored data in upper case15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 30 Dec 2002 11:20:07 -0500390_iso-8859-1 Is there any character set or any other thing allow db2 to store the data always in upper case in a table. We are on DB2 version 6 on OS/390. Shortly going to version 7. There are data exist in upper and lower case, but we want to covert all the data to upper case and stored. Any new data should be stored in upper case always. Is there any way can we achieve this in DB2. [...] 1297 56 29_Re: Stored data in upper case16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 30 Dec 2002 11:52:53 -0500471_iso-8859-1 Change all the SQL for this table from: INSERT INTO table-name col1, col2,.... VALUES (:hv1, :hv2, ...) to: INSERT INTO table-name col1, col2,.... VALUES (UPPER(:hv1), UPPER(:hv2), ....) and do the same with the UPDATE statements.

You could encapsulate the INSERTs and UPDATEs in a Stored Procedure and require that all INSERTs and UPDATEs to this table use the Stored Procedure. This could reduce the coding effort and prevent future 'surprises'. [...] 1354 84 29_Re: Stored data in upper case13_Terry Purcell25_Terry_Purcell@YLASSOC.COM31_Mon, 30 Dec 2002 11:16:16 -0600387_iso-8859-1 Sibi,

For the data conversion, you can use Eric's suggestion if logging (or compression) is an issue because you can perform a LOAD REPLACE LOG NO.

If logging is not an issue then a simple UPDATE statement could be constructed that will convert all existing data such as:

UPDATE MYTABLE SET COL1 = UPPER(COL1) ,COL2 = UPPER(COL2) ,COL3 = UPPER(COL3) [...] 1439 106 29_Re: Stored data in upper case16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Mon, 30 Dec 2002 12:29:45 -0500502_iso-8859-1 Logging and locking were my reasons for LOAD rather than UPDATE. I can just imagine an UPDATE of a squillion row table getting cancelled at 1/2 squillion rows and going into ABORT for the rest of the programmer's brief remaining job tenure!

Regards, Eric Pearson





-----Original Message----- From: Terry Purcell [mailto:Terry_Purcell@YLASSOC.COM] Sent: Monday, December 30, 2002 12:16 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Stored data in upper case [...] 1546 18 43_Retrieving data from a for bit data column.10_Marco Poma21_marco.poma@UOL.COM.BR31_Mon, 30 Dec 2002 15:57:15 -0200404_UTF-8 Hello List, Does anybody knows how to retrieve the data stored ina column defined as for bit data?

Thanks in advance,

Marco Poma

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 1565 58 46_R: DBRM contoken check rexx on db2-l-documents18_Di Franco Vincenzo22_difrancov@ISIDE.BCC.IT31_Mon, 30 Dec 2002 19:01:26 +0100376_iso-8859-1 Hi Tina, I've been forced to make a correction to your rexx :

/* contokenx = substr(dbrm.1,29,4) || substr(dbrm.1,25,4) */ contokenx = substr(dbrm.1,25,4) || substr(dbrm.1,29,4)

I tested your rexx with DSNTIAD pgm and found that in load module contoken was like my correction. Do you have an idea ? I find your utility very nice. Thank you. Bye. [...] 1624 86 50_Re: R: DBRM contoken check rexx on db2-l-documents12_michael bell24_mbell11@WORLDNET.ATT.NET31_Mon, 30 Dec 2002 12:34:56 -0600339_iso-8859-1 The connection token is stored in the format specified by the precompiler/compiler combination. ASM and COBOL not RENT are different from COBOL compiled with RENT. The RENT COBOL compiler stores the value in the literal pool and the sequence is reversed. I suppose you could keep different versions for ASM and RENT COBOL. [...] 1711 81 47_Re: DBRM contoken check rexx on db2-l-documents12_Gerald Hodge20_ghodge@ATTGLOBAL.NET31_Mon, 30 Dec 2002 12:38:06 -0600531_iso-8859-1 Di Franco:

Many languages have a different representation of the consistency token in there object and load modules. The worse is C or C++. Within what language are you trying the match?

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

-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM]On Behalf Of Di Franco Vincenzo Sent: Monday, December 30, 2002 12:01 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: R: DBRM contoken check rexx on db2-l-documents [...] 1793 138 50_Re: R: DBRM contoken check rexx on db2-l-documents11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Mon, 30 Dec 2002 14:10:30 -0500371_iso-8859-1 It works with all our Cobol. If you have programs in other languages, then you can pass language to the rexx and have it use the version of the code that's correct for that language.

If lang = 'cobol' then contokenx = substr(dbrm.1,29,4) || substr(dbrm.1,25,4) else if lang = 'assembler' then contokenx = substr(dbrm.1,25,4) || substr(dbrm.1,29,4) [...] 1932 99 47_Re: DBRM contoken check rexx on db2-l-documents12_Isaac Yassin20_yassini@BEZEQINT.NET31_Mon, 30 Dec 2002 23:15:09 +0200470_- Hi, I've put the C structure months ago. It's somewhere in the DOC list

Isaac Yassin DBMS & IT Consultant IBM Certified Solution Expert DB2 V7.1 Database Administration for OS/390





-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Gerald Hodge Sent: Monday, December 30, 2002 8:38 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DBRM contoken check rexx on db2-l-documents [...] 2032 24 35_Pros and Cons of Federated Database15_Stephen Poulsen36_stephen.r.poulsen@CO.MULTNOMAH.OR.US31_Mon, 30 Dec 2002 15:58:03 -0600534_- What are the pros and cons of using "federated databases" and "nicknames"?

We have a small number of DB2/UDB databases that support different applications. All of the databases are in the same instance and on the same server. The applications are somewhat related and the data actually "belongs" to the same department. Developers are wanting to to join data from the different databases in a single SQL statement and so they have picked up on the idea of "nicknames". We did not initially install the federated option. [...] 2057 13 39_Re: Pros and Cons of Federated Database0_26_truman.g.brown@VERIZON.COM31_Mon, 30 Dec 2002 17:35:19 -0500309_us-ascii IMHO easier/simpler is almost always better.

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 2071 54 23_Can a Trigger do this ?10_Sysdba AHE18_Sysdba.AHE@TNT.COM31_Tue, 31 Dec 2002 08:37:12 +0000285_us-ascii I want to set a column on insert to a value retrieved from another table. I want to do it without the overhead of either calling DB2 with a preliminary SELECT to get the value, or the overhead of calling a stored procedure, i.e. I want to use a Trigger pure and simple:- [...] 2126 36 47_Re: Retrieving data from a for bit data column.14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 31 Dec 2002 19:35:36 +1000317_US-ASCII Treat it as a CHAR column. All the FOR BIT DATA does is prevent any translation when transferring the data between a client and server with different CCSIDs.

If you have an application program which has a different CCSID, you might need to use an SQLDA.SQLDATA value of x'0000FFFF' to insert it. [...] 2163 34 25_Re: Display trace details14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 31 Dec 2002 19:35:36 +1000327_US-ASCII looks like you'll have to start a trace to monitor -STA TRACE commands, because, no, -DIS TRACE does not report on individual IFCID numbers. There might be (don't have documentation handy) an IFCID that details active traces - have a look.

James Campbell

On 30 Dec 2002 at 11:26, Vijay Salvi wrote: [...] 2198 70 40_Re: Dispatching Priority of Db2 Monitors14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 31 Dec 2002 19:35:36 +1000619_US-ASCII I would suggest that if your monitor runs at a lower priority than a DB2 address space, events can happen within DB2 which your monitor will never see.

James Campbell

On 30 Dec 2002 at 11:32, Tekin Yavuz (Garanti Teknoloj wrote:

> Hi again, > Do you have any opinion about this topic.Any comment would be > appreciated. > Regards.. > > -----Original Message----- > From: Tekin Yavuz (Garanti Teknoloji) > Sent: Friday, December 27, 2002 7:06 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Dispatching Priority of Db2 Monitors > Hi all, > How or in what way lower dispatching priority [...] 2269 68 42_Re: Accessing SQLCA within a SQL procedure14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 31 Dec 2002 19:35:36 +1000436_US-ASCII I have a little experience with SQL Language Stored Procedures, but here goes:

V7 - not officially Vnext - supposedly GET DIAGNOSTICS will do the trick.

However, and here the hacker in me comes out of its shell, there is a technique that I believe (conceptually it should, but like a battle plan in war, I don't know if it will survive contact with reality) there is a way of getting the SQLCA - even in V6. [...] 2338 37 28_Re: Resizing LOB Tablespaces15_Patrick Hignett33_Patrick.Hignett@MORGANSTANLEY.COM31_Tue, 31 Dec 2002 09:34:13 +0000546_us-ascii Paul All you need to do is image copy, alter the PRIQTY and SECQTY and then recover. Do not do a recover to just a straight recover. This has worked fine for me.

Paul Packham wrote:

> Hi, > > We are installing the new release of SAP (WAS 620). This has introduced us LOB > tablespaces. A few of these tablespaces are in multi extents, so I tried to release > these extends with a Reorg, not realising that DB2 would not unload/reload the LOBs > and delete/redefine the underlying dataset. So my question is am I OK to [...] 2376 109 27_Re: Can a Trigger do this ?14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Tue, 31 Dec 2002 11:06:45 +0100242_us-ascii This can be done in DB2 for Linux, UNIX, Windows

In DB2 for z/OS and OS/390 you have to use an after trigger as follows

CREATE TRIGGER WMTQRT01 AFTER INSERT ON OS01.WMRQRT01 REFERENCING NEW AS N FOR EACH ROW MODE DB2SQL 2486 196 40_Re: Dispatching Priority of Db2 Monitors31_Tekin Yavuz (Garanti Teknoloji)21_TekinY@GARANTI.COM.TR31_Tue, 31 Dec 2002 12:20:04 +0200 2683 58 38_Performance impact of Identity Columns2_ED31_emaddanish@SAUDIAIRLINES.COM.SA31_Tue, 31 Dec 2002 14:48:51 +0300193_windows-1256 Hello everybody,

I need to read about the PERFORMANCE IMPACT of using IDENTITY COLUMNS. Do you have experience or know any reference I can refer to?

Thanks...

2742 101 42_Re: Performance impact of Identity Columns18_Fazal, Syed (TATA)39_Syed.Fazal@CONTRACTORS.NATIONALCITY.COM31_Tue, 31 Dec 2002 09:11:35 -0500688_windows-1256 You can check the following link to check out about Identity column in Chapter 3.1(DB2 UDB Server for OS/390 Version 6 Technical Update)

http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg246108.pdf

-----Original Message----- From: emaddanish@SAUDIAIRLINES.COM.SA [mailto:emaddanish@SAUDIAIRLINES.COM.SA] Sent: Tuesday, December 31, 2002 6:49 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Performance impact of Identity Columns



Hello everybody,

I need to read about the PERFORMANCE IMPACT of using IDENTITY COLUMNS. Do you have experience or know any reference I can refer to? [...] 2844 19 59_Image Copy appears to have data but cannot recover from it.13_Joel Pankonin26_joel.pankonin@ZURICHNA.COM31_Tue, 31 Dec 2002 08:15:20 -0600546_- The data bandit got us again... thankfully in test environment only. One of our programmers discovered a table that is missing 2.5 m rows, it's completely empty. The recovery job runs with a zero return code but when I go check the table and it's still empty. The catalog shows a partial recovery point and when I look at the image copy I can see it has 8000+ tracks of data in it. Why is the recovery process acting like everything worked? I tried this with the previous image copy and got same result. We have BMC Recovery Manager doing [...] 2864 18 27_runstats in UDB environment10_John Lantz23_john.lantz@ZURICHNA.COM31_Tue, 31 Dec 2002 08:39:18 -0600457_- I have an table in the UDB EE environment with 5 indexes on it and I'm having trouble running RUNSTATS. The syntax I'm using is "RUNSTATS ON TABLE xxx.xxx AND INDEXES ALL SHRLEVEL CHANGE" When I try to run RUNSTATS, I get the SQL2314W message. The error says that you should issue a runstats for both the table and index. I thought that was what I was doing. Is it because the tables are being updated as I run this command in the middle of the day? [...] 2883 78 63_Re: Image Copy appears to have data but cannot recover from it.12_David Wilson30_David_A_Wilson@JOHNLEWIS.CO.UK31_Tue, 31 Dec 2002 14:35:43 +0000421_us-ascii Have you rebuilt any indexes on your table?

Dave Wilson MS Tech Support DBA X4248





Joel Pankonin cc: Sent by: DB2 Data Subject: Image Copy appears to have data but cannot recover from it. Base Discussion List



31/12/02 14:15 Please respond to DB2 Data Base Discussion List [...] 2962 165 63_Re: Image Copy appears to have data but cannot recover from it.16_Tee, Christopher31_Christopher.Tee@LLOYDSTSB.CO.UK31_Tue, 31 Dec 2002 14:44:57 -0000502_iso-8859-1 Is the table in a multi-table tablespace? If so, check the image copy with DSN1PRNT to see if it has rows for the table in question. Maybe somebody did a load replace of one of the other tables.

Chris

PS Happy New Year (not sure why I'm still at work!)

-----Original Message----- From: Joel Pankonin [mailto:joel.pankonin@ZURICHNA.COM] Sent: 31 December 2002 14:15 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Image Copy appears to have data but cannot recover from it. [...] 3128 59 63_Re: Image Copy appears to have data but cannot recover from it.15_Marcel Harleman25_marcel.harleman@HCCNET.NL31_Tue, 31 Dec 2002 16:12:57 +0100456_us-ascii Hi,

Maybe there has been a drop/create of the table? Imagecopy acts on a tablespace partition level. Drop/create of a table does not invalidate the imagecopy by removing the registration form SYSCOPY. What drop/create does do is assigning new object-id's for the table (and the indexes and so on, but that's of minor importance here). And the recover simply replaces the contents of the tablespace partition without minding the table. [...] 3188 201 42_Re: Performance impact of Identity Columns24_Leblanc, Francis C - CNF23_Leblanc.Francis@CNF.COM31_Tue, 31 Dec 2002 07:15:41 -0800555_- We're using identity columns in a number of high insert tables, and ran into some contention on the SYSSEQUENCES table in the catalog. Once we increased the number of cached values for each table, the contention disappeared. Other than that, we've had no problems.





Good luck,





Fritz





-----Original Message----- From: ED [mailto:emaddanish@SAUDIAIRLINES.COM.SA] Sent: Tuesday, December 31, 2002 3:49 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Performance impact of Identity Columns [...] 3390 57 63_Re: Image Copy appears to have data but cannot recover from it.10_Hessel Rus13_H.Rus@OTRA.NL31_Tue, 31 Dec 2002 16:29:48 +0100421_us-ascii Joel,

In case you perform a recovery to current, perhaps the last executed sql statement was: delete from table..... Then try a tocopy recovery









Joel Pankonin cc: Sent by: DB2 Data Subject: Image Copy appears to have data but cannot recover from it. Base Discussion List [...] 3448 157 40_Re: Dispatching Priority of Db2 Monitors14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 31 Dec 2002 15:37:28 -0000321_windows-1254 Tekin (and everyone)

I had a brief chat with our Detector folks, and their comments follow (which I think echos what most people consider as "best practice" for monitors, but does stress the unfortunate events that can happen if you do NOT run your monitor AT LEAST at the same priority as DB2): [...] 3606 72 31_Re: runstats in UDB environment15_Jackson Reavill18_damcon2@US.IBM.COM31_Tue, 31 Dec 2002 10:48:31 -0500605_US-ASCII John,

Give this a try...

runstats on table with distribution and detailed indexes all shrlevel change;

Regards, 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 Contour (SVT) of the road. ----------------------------------------------------- The early bird gets the worm, but the second mouse gets the cheese. ----------------------------------------------------- [...] 3679 104 40_Re: Dispatching Priority of Db2 Monitors13_Martin Packer24_martin_packer@UK.IBM.COM31_Tue, 31 Dec 2002 16:20:49 +0000444_us-ascii Phil, thank goodness you said that! I was going to respond to the original comment that a monitor at a lower priority than a monitored address space could miss events. That could happen regardless of the "priority" hierarchy. Being higher "priority" won't GUARANTEE that doesn't happen.

Priority in quotations because in practice we're usually talking WLM and for that DP is not really under our control, most of the time. [...] 3784 17 27_Re: Can a Trigger do this ?0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 31 Dec 2002 11:50:35 -0600514_us-ascii I think you are stuck too. A UDF is another option, but would incur (I suppose) about the same overhead as an SP call. "Before" Triggers are the ideal place to enforce some business logic, but the options are, unfortunately, very limited.

Stg

================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com. 3802 18 31_Java Stored Procedures - DB2 V713_Peggy Donovan27_peggy.donovan@CITIGROUP.COM31_Tue, 31 Dec 2002 11:46:49 -0600340_- First - Happy New Year everyone.

Is anyone on the list doing mainframe Java Stored Procedures? & would you share your experience & thoughts? We're in the process of working out our migration procedures & standards. I would appreciate input. I'll be off a few days. But please e-mail me if I could ask a few questions. Thanks. [...] 3821 36 27_Re: Can a Trigger do this ?15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Tue, 31 Dec 2002 13:08:41 -0500653_- Do we pay only half the price for DB2 UDB on mainframe since only half the feature available compared to UDB on other platform and other DBMS.

Thanks..sibi



-----Original Message----- From: Steve_Grimes@AISMAIL.WUSTL.EDU [mailto:Steve_Grimes@AISMAIL.WUSTL.EDU] Sent: Tuesday, December 31, 2002 11:51 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Can a Trigger do this ?



I think you are stuck too. A UDF is another option, but would incur (I suppose) about the same overhead as an SP call. "Before" Triggers are the ideal place to enforce some business logic, but the options are, unfortunately, very limited. [...] 3858 45 35_Re: Java Stored Procedures - DB2 V70_18_IWANT2BEME@AOL.COM29_Tue, 31 Dec 2002 13:37:09 EST374_US-ASCII peggy.donovan asked:

> Is anyone on the list doing mainframe Java Stored Procedures? &would you > share your experience &thoughts?

Peggy,

Our shop considered Java Stored Procedures, but since COBOL is more efficient and since our system is primarily developed in COBOL, the decision was to develop the Stored Procedures in COBOL.

Jacquie 3904 22 37_NonSys tables in DSNDB06 tablespaces?11_Cliff Boley32_Maurice.C.BOLEY@ODOT.STATE.OR.US31_Tue, 31 Dec 2002 10:42:44 -0800417_iso-8859-1 Hi all, I came across something that I'm a little puzzled over. I found 2987 tables in my the SYSDBAUT tablespace other than the two I expected to find (SYSDATABASE & SYSDBAUTH).

Did DB2 put them in there? if so what are they there for? else Can I drop them? and/or do I need to slap my DBAs around for creating them? (should I slap myself around for authorizing CREATE in the system catalog)? [...] 3927 57 35_Re: Java Stored Procedures - DB2 V712_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Tue, 31 Dec 2002 13:15:26 -0600508_us-ascii We are doing our procedures in PLI at present. However, we are activating the C compiler for SQL procedures for the coming year. Long term direction is to move from PLI to C at some point. I would be interested in performance comments with Java on this thread.

Buzz







Peggy Donovan cc: Subject: Java Stored Procedures - DB2 V7 Sent by: DB2 Data Base Discussion List [...] 3985 54 29_Re: Stored data in upper case10_David Cohn16_davecohn@MSN.COM31_Tue, 31 Dec 2002 11:29:30 -0800546_iso-8859-1 Hi Sibi, You're pretty much limited to using the UCASE or UPPER function. The synatax is UCASE('character string or column with lower case characters') To change existing data you can use the SQL UPDATE statement. To insure that future data is all upper case you would best be served by writing a BEFORE TRIGGER to force the character columns to upper case. Hope this helps, David Cohn Senior Systems Advisor Themis Training IBM Certified Solutions Expert: DB2 V7.1 Database Administration DB2 V7.1 Family Application Development [...] 4040 66 41_Re: NonSys tables in DSNDB06 tablespaces?0_16_khampto1@TXU.COM31_Tue, 31 Dec 2002 14:14:00 -0600396_us-ascii Those table entries assigned to SYSDBAUT are probably Aliases (TYPE column in SYSTABLES = 'A'). If so, yes, DB2 put them there. If not, then you or one of your DBA's would need to be slapped for putting user tables in a catalog tablespace.











Cliff Boley @LISTSERV.YLASSOC.COM> on 12/31/2002 12:42:44 PM [...]