1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2004, week 3
2 19 50_Re: z/os websphere/db2 jdbc db2 cpu by transaction17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Thu, 15 Jul 2004 00:13:19 -0500292_- Ed, If your WAS applications post the client information (sqleseti api) to DB2 then the client program id / end user name etc are avlbl as part of the headers in 101 record.
If you don't post the information the default is the calling process name which is always java / javaw. [...]
22 130 39_Re: Accesspath alteration due to Rebind15_Rama K. Vaddadi26_rama.vaddadi@UKTRANSCO.COM31_Thu, 15 Jul 2004 09:35:18 +0100464_us-ascii The tables has cluster index and the data was not fully clustered. When I load the data, I have loaded with RECLUSTER YES option. Would it be sufficient to RECLUSTER the Index or the Data also need to be clustered for the LOAD.
Rama Vaddadi
Roger Miller To: DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc: Base Discussion Subject: Re: Accesspath alteration due to Rebind List [...]
153 230 31_Re: Error Dropping a tablespace19_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Thu, 15 Jul 2004 05:48:57 -0400709_us-ascii Maybe you need to REPAIR DBD?
| Larry Jardine | Production DBA | Aetna |
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Smith, Allan Sent: Wednesday, July 14, 2004 1:41 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Error Dropping a tablespace
Listers,
I have recently inherited a DB2 system and am having a problem trying to drop a tablespace. I have issued a 'DROP TABLESPACE PCM390.AVT14TS'; And get the following error; Abend Code 04e Reason Code 00c90110. I have then just tried to drop a table or index in the tablespace and get the same error. Also ran [...]
384 45 62_CICS (only SELECT) versus BATCH ( SELECT/INSERT/UPDATE/DELETE)12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 15 Jul 2004 13:58:43 +0200434_- LIST'ers,
we have to handle the following situation in a DB2 Mainframe V6 environment:
Given is a 24 ours each day running CICS/DB2 application. During each night runs a batch job that is updating some of the application tables.
During this batch time it must be forbidden that the CICS part of the application can INSERTERT/UPDATE/DELETE the table data - but SELECT's from the CICS side must be possible. [...]
430 54 51_Accessing an Oracle Database from CICS Transactions15_Dirk Herzhauser16_dherzhau@CSC.COM31_Thu, 15 Jul 2004 13:52:33 +0200331_US-ASCII Hello ,
we need to access an Oracle Database (V 9.2) installed on an UNIX ( a RAC Installation) from an CICS . The CICS Transactions accesses also DB2 (V 7) on the MVS and VSAM. Up to now I "know" only 2 Products, which let us, access Oracle Database. 1.Oracle Access Manger for CICS 2. Information Integrator [...]
485 96 31_FW: z/os websphere/db2 jdbc db217_KUSTERS, ED (TAO)30_ED.KUSTERS.tao@CCRA-ADRC.GC.CA31_Thu, 15 Jul 2004 08:20:00 -0400616_- Date: Thursday, 15 July 2004 8:20am ET To: db2-l@www.idugdb2-l.org From: KUSTERS.ED@RCT Subject: FW: z/os websphere/db2 jdbc db2
Thanks for the tip on accounting for ddf threads Karthik. It's not ddf I need this for though. It's for websphere transactions running on the mainframe host. I have asked ibm the same question and they are helping me with this now. Thanks for your help /Ed --------------------------( Forwarded letter 1 follows )--------------------- Date: Thursday July 15, 2004 06:37:49 AM To: "KUSTERS.ED" From: "KUSTERS.ED" Subject: FW: z/os websphere/db2 jdbc db2 cpu [...]
582 99 66_Re: CICS (only SELECT) versus BATCH ( SELECT/INSERT/UPDATE/DELETE)14_Seth Bienstock17_seth2@SKARVEN.NET31_Thu, 15 Jul 2004 08:49:49 -0400453_us-ascii Georg,
The "LOCK TABLE" solution will work. The CICS programs (and any other) would still have SELECT access to the data while the batch program will be allowed to update. Just be aware of the effect of COMMITs and use appropriate BIND (i.e. RELEASE()) parameters.
The biggest pitfall I can see to this is that, depending upon your environment, you might wind up with very unhappy end users. You might want to also consider: [...]
682 93 55_Re: Accessing an Oracle Database from CICS Transactions12_Treven Roman19_Roman.Treven@PBS.SI31_Thu, 15 Jul 2004 14:58:56 +0200575_- Hello,
there are also other options to do the job:
- you can write your own programs in C program language for which Oracle has an translator/precompiler(Pro*C); I also heard that it supports COBOL but not for sure, PL/I is not supported - you can access Oracle database throgh ODBC interface from different languages - if you would have TXSeries (CICS for UNIX)on the UNIX box then you can simply LINK (DPL) the program on TX from your CICS program on mainframe - if your Oracle is remote to your CICS then you probably need AIX Oracle Client to access [...]
776 151 67_AW: CICS (only SELECT) versus BATCH ( SELECT/INSERT/UPDATE/DELETE )12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 15 Jul 2004 15:26:28 +0200541_iso-8859-1 Tahn you, Set.
With kind regards - mit freundlichen Gruessen, Georg ---------------------------------------------------------------------- In nature, nothing is ever right. Therefore, if everything is going right ... something is wrong.
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Seth Bienstock Gesendet: Donnerstag, 15. Juli 2004 14:50 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: Re: CICS (only SELECT) versus BATCH ( SELECT/INSERT/UPDATE/DELETE) [...]
928 144 55_Re: Accessing an Oracle Database from CICS Transactions15_Dirk Herzhauser16_dherzhau@CSC.COM31_Thu, 15 Jul 2004 16:03:29 +0200360_UTF-8
Thank you for your answer,
we are writing our own programs with Cobol so we need to precompile them (yes it supports cobol if we are using the Oracle Access Manger) but in my opinion you can connect within 1 program only to oracle, so we have to use different programs to access db2 and oracle and do the joins in the program, right? [...]
1073 86 21_Content manager Books11_April Wells17_AWells@CSEDGE.COM31_Thu, 15 Jul 2004 09:36:51 -0500715_iso-8859-1
are there any decent books, other than the manuals, on content manager?
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas @>-->-->-- "Few people really enjoy the simple pleasure of flying a kite" Adam Wells age 11 "Imagination is the highest kite one can fly." Lauren Bacall
The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended [...]
1160 52 26_Re: DB2 MAINFRAME JOBS.C/O50_Knight, Robert A. (Cameron of Pittsburgh at Alcoa)23_Robert.Knight@ALCOA.COM31_Thu, 15 Jul 2004 10:36:37 -0400551_iso-8859-1 Is there a possibility that I could discuss these issues with you prior to submitting a resume?
robert.knight@alcoa.com
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Dave Jones Sent: Wednesday, July 14, 2004 3:59 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DB2 MAINFRAME JOBS.
DB2 listeners:
Pardon this notice. But in the event one of your colleagues is in need of employment or wants to learn about an new opportunity. [...]
1213 162 39_Re: Accesspath alteration due to Rebind12_Roger Miller19_millerrl@US.IBM.COM31_Thu, 15 Jul 2004 10:17:56 -0500410_- Answers to these would help clarify the situation.
Are you thinking about migration to a later version? RECLUSTER is not a keyword for the IBM utilities, so did you use a third party LOAD product? Otherwise explain recluster. Did you use a third party RUNSTATS as well? What did you use to determine the problem was access paths? Do you have before and after accounting reports and explain data? [...]
1376 44 22_File Sharing Violation16_Vinicius Gumiero24_vinicius.gumiero@EDS.COM31_Thu, 15 Jul 2004 11:22:43 -0500871_- Hi Everybody
Someone had this problem before in UDB for Windows platform:
2004-07-15-04.02.38.390000 Instance:DB2 Node:000 PID:1015(db2syscs.exe) TID:572 Appid:*LOCAL.DB2.040715070228 buffer_pool_services sqlbDMSDoContainerOp Probe:810 Database:GMDW DIA3819C A file sharing violation has occurred, filename was "".
ZRC=0xFFFFF616
2004-07-15-04.02.38.515000 Instance:DB2 Node:000 PID:1015(db2syscs.exe) TID:572 Appid:*LOCAL.DB2.040715070228 buffer_pool_services sqlbDMSDoContainerOp Probe:810 Database:GMDW
Error checking container 0 (d:\gmdw\gmdwadtd\CONT1) for tbsp 19. Rc = FFFFF616
2004-07-15-04.02.38.609000 Instance:DB2 Node:000 PID:1015(db2syscs.exe) TID:572 Appid:*LOCAL.DB2.040715070228 buffer_pool_services sqlbDMSStartPool Probe:800 Database:GMDW DIA3819C A file sharing violation has occurred, filename was "". [...]
1421 137 31_DB2 Connect / diaglog.file info18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 15 Jul 2004 12:50:34 -0400431_us-ascii Wonder if anyone can help me out here. I'm seeing these msgs in the diag file on our DB2 Connect NT server. We are running DB2 Connect EE v7.2 with Fixpak5:
2004-07-13-01.21.55.756002 Instance:DB2 Node:000 PID:1352(db2syscs.exe) TID:1500 Appid:none common_communication sqlcctcpconnmgr_child Probe:125 DIA3003E Error encountered in "TCPIP" protocol support. Return code from
"sqleGetAgent" was "-1226". [...]
1559 11 35_Re: DB2 Connect / diaglog.file info17_Venkat Srinivasan32_venkat_lserv@HEWITTANDLARSEN.COM31_Thu, 15 Jul 2004 13:12:53 -0500527_- Probably you are reaching maxagents limit???... Venkat
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1571 130 35_Re: DB2 Connect / diaglog.file info33_Schiradin,Roland HG-Dir itb-db/dc28_SchiradinR@ALTE-LEIPZIGER.DE31_Thu, 15 Jul 2004 21:10:06 +0200509_iso-8859-1 Check APAR IY42291. Verify number of max agents.
Roland
-----Ursprüngliche Nachricht----- Von: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Whittaker, Stephen Gesendet: Donnerstag, 15. Juli 2004 18:51 An: DB2-L@WWW.IDUGDB2-L.ORG Betreff: DB2 Connect / diaglog.file info
Wonder if anyone can help me out here. I'm seeing these msgs in the diag file on our DB2 Connect NT server. We are running DB2 Connect EE v7.2 with Fixpak5: [...]
1702 210 25_Re: Content manager Books11_Grant Allen28_Grant.Allen@TOWERSOFT.COM.AU31_Fri, 16 Jul 2004 09:48:33 +1000562_iso-8859-1 Hi April,
I've searched, but haven't found any. Maybe you and I could write one :-). You could check www.redbooks.ibm.com, as there are 20-odd redbooks on CM, with several focused on AIX (your platform, from memory). There are also four residencies being held later this year ... always tempting. Last but not least, if you are a member of developerWorks, IBM is offering the one-week certification preparation course for free at their ISV partnership centres, instead of $$$$$ (at least here in Sydney ... fancy a trip down under? :-) ). [...]
1913 18 40_Search text for nondisplaying characters13_Steve Mallett23_smallett@OZEMAIL.COM.AU31_Thu, 15 Jul 2004 19:09:04 -0500694_- Esteemed List,
Has anyone some nifty SQL for determining value and location of non- displaying text characters (without prior knowledge of their exact values)
The database is DB2 V7 on z/OS
TIA Stefan
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1932 77 26_Re: File Sharing Violation14_Dieter Schwarz45_dieter.schwarz@SCHWARZ-INFORMATIONSSYSTEME.DE31_Fri, 16 Jul 2004 08:35:55 +0200334_iso-8859-1 Vinicius,
probably your backup software has caused a lock on your table space containers while DB2 was trying to gain access to it. Two Options: a) make sure, your backup does not touch your containers (use "backup db" to create backup images) b) make sure there is no database activity while backup is running [...]
2010 38 44_Re: Search text for nondisplaying characters15_Binyamin Dissen26_bdissen@DISSENSOFTWARE.COM31_Fri, 16 Jul 2004 10:55:29 +0300410_us-ascii On Thu, 15 Jul 2004 19:09:04 -0500 Steve Mallett wrote:
:>Esteemed List, :> :>Has anyone some nifty SQL for determining value and location of non- :>displaying text characters (without prior knowledge of their exact values)
If you do not know either the values of the displaying characters or the values of the non-displaying characters, how can DB2 know? [...]
2049 23 36_How much protection is really needed15_Michael Rennick31_Michael_Rennick@TAX.STATE.NY.US31_Fri, 16 Jul 2004 10:10:56 -0400351_US-ASCII Dear Fellow Listserve Members: __________________
We have ESS (Enterprise Storage System) DASD devices with Raid 5+ protection at our site. We currently have our 4 DB2 logs placed on these devices. We are not currently set for TWOACTV on our logs.
The question we have is having the active logs set for duplexing overkill? [...]
2073 61 40_Re: How much protection is really needed12_Hilton, Tina23_thilton@RANDOMHOUSE.COM31_Fri, 16 Jul 2004 09:33:11 -0500279_us-ascii That's what we thought too, and so we didn't have dual active logs. Then we ran into a microcode problem with our DASD that affected a few of our log datasets and made them unusable to DB2, luckily after they had been archived. We switched to dual logs after that. [...]
2135 94 40_Re: How much protection is really needed0_25_LL581@DAIMLERCHRYSLER.COM31_Fri, 16 Jul 2004 10:33:42 -0400478_US-ASCII Michael,
I'd say that as long as you run the Update Resume command frequently, there shouldn't be a problem :)
But seriously, this is a question that should be addressed between your management and IBM. The issue: Are you willing to bet your entire DB2 subsystem (and all its data) on a DB2 log that is anything less than 100.00% available? On the 0.000n% chance that there's a problem with one of your logs, are you prepared to Recover your system? [...]
2230 189 40_Re: How much protection is really needed15_Carol L Broyles30_carol.broyles@MEADWESTVACO.COM31_Fri, 16 Jul 2004 10:37:20 -0400316_US-ASCII Not only is it NOT overkill, to ensure no single point of failure, you should have both logs placed on separate DASD boxes if possible. In your present setup, if you lose that log, you will not be able to perform a current restart or recovery.
Carol Broyles Sr. IT Consultant MeadWestvaco Corp. [...]
2420 68 40_Re: How much protection is really needed20_Friedman, Avram (IT)32_Avram.Friedman@MORGANSTANLEY.COM31_Fri, 16 Jul 2004 11:04:04 -0400571_us-ascii The classic measurements are called MTBF (Mean Time Between Failures) MTTR (Mean Time To Repair)
You should compare both of these values to your SLAs (Service Level Agreements)
You should beable to obtain MTBF data from your hardware vendor.
MTTR is a bit more complicated. For a log loss only MTTR is either the length of time to the next full image copy cycle or the length of time it takes to image copy everything. The reason for the two options in this case is the next some what rare issue ... The risk of a double loss, both the [...]
2489 61 40_Re: How much protection is really needed35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 16 Jul 2004 11:04:59 -0400497_iso-8859-1 Michael, You can never have too much protection. DASD is cheap compared to the effect of losing data, and the effect of having your systems down for an extended period. You also need to separate them onto different controllers to really cover yourself.
Regards, Joel
----- Original Message ----- From: "Michael Rennick" To: Sent: Friday, July 16, 2004 10:10 AM Subject: How much protection is really needed [...]
2551 100 40_Re: How much protection is really needed35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Fri, 16 Jul 2004 11:23:57 -0400382_iso-8859-1 Also think about MCTR (mean cost to repair), which has a direct relationship to MTTR, and also the possible cost/value of losing data. Regards, Joel
----- Original Message ----- From: "Friedman, Avram (IT)" To: Sent: Friday, July 16, 2004 11:04 AM Subject: Re: How much protection is really needed [...]
2652 49 40_Re: How much protection is really needed14_Barbara Koenen33_barbara.koenen.bgit@STATEFARM.COM31_Fri, 16 Jul 2004 10:30:57 -0500369_- We had DASD in place that was not supposed to fail unless it had over 5 distinct errors occur at the same time. This situation statistically was not suppose to happen more than once every 50 years. We had two such failures within one year.
Luckily our DB2 subsystem data was not on these subsystems, and we do have log duplexing on ALL of our subsystems. [...]
2702 72 44_Re: Search text for nondisplaying characters13_Charles Greer24_CGREER@SONOMA-COUNTY.ORG31_Fri, 16 Jul 2004 08:55:17 -0700507_US-ASCII Have you looked into using regular expressions? I don't know if that's an option on z/OS, but here's an articule that shows how to implement regular expressions using the pcre library.
http://www-106.ibm.com/developerworks/db2/library/techarticle/0301stolze/0301stolze.html
Charles
Charles Greer Software Systems Analyst County of Sonoma, Geographic Information Systems 2615 Paulin Drive Santa Rosa, CA 95403 707-565-3991 FAX 707-565-2187 cgreer@sonoma-county.org [...]
2775 64 40_Re: How much protection is really needed14_Andy Lankester30_andy.lankester@CDBSOFTWARE.COM31_Fri, 16 Jul 2004 17:40:00 +0100666_Windows-1252 Think of it as life insurance, or at least job insurance! Your directors are PERSONALLY liable if they fail to secure valuable company assets. It's a powerful justification at higher management levels.
Andy Lankester CDB Software
> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Michael Rennick > Sent: 16 July 2004 15:11 > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: How much protection is really needed > > > Dear Fellow Listserve Members: > __________________ > > We have ESS (Enterprise Storage System) DASD devices with > Raid 5+ protection at our site. We currently have [...]
2840 100 40_Re: How much protection is really needed15_Billings, Linda30_Linda.Billings@DOA.STATE.WI.US31_Fri, 16 Jul 2004 11:44:27 -0500361_- "Your directors are PERSONALLY liable if they fail to secure valuable company assets."
It looks like Michael works for the state government in New York. I'd say that the Governor would have something to say if the financial data isn't accessible. Maybe the citizens of New York would make sure he didn't have a job when the next election is held. [...]
2941 31 25_SQL -164 in DB2 V7.1 z/OS0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Fri, 16 Jul 2004 12:50:24 -0400364_US-ASCII Hi,
We are DB2 V7.1 RSU 0312 on z/OS:
(1) User ICMADMN has DBADM authority granted to database ICMMLSDU. ICMADM tries to create a view TECHU.XXXXXXXX on a base table TECHU.ZZZZ and receives SQL -164. See message below.
DSNT408I SQLCODE = -164, ERROR: ICMADMN DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION TECHU [...]
2973 123 29_Re: SQL -164 in DB2 V7.1 z/OS11_David Nance16_DWNance@FHSC.COM31_Fri, 16 Jul 2004 13:13:07 -0400342_US-ASCII Ed, You either have to set your sqlid to techu or have sysadmin privileges. We have the same type issues here. There was some discussion on the topic here on the listserv a coupld months back. I, think, its kind of hokey that I can create a table(x.table), but I can't create a view on that same table, with my DBADM authority. [...]
3097 76 29_Re: SQL -164 in DB2 V7.1 z/OS13_Fung, Chi-Yun23_Chi-Yun.Fung@UNISYS.COM31_Fri, 16 Jul 2004 11:24:49 -0600385_iso-8859-1 Ed,
Check your Zparm see if DBACRVW=NO. Change it to YES.
From installation guide:
13. DBADM CREATE AUTH
Specify whether an authorization ID with DBADM authority on a database can:
create a view for another authorization ID on that database's tables create an alias for itself or another authorization ID for a table in that database [...]
3174 114 29_Re: SQL -164 in DB2 V7.1 z/OS0_25_Ed_Vetock@NAVYFEDERAL.ORG31_Fri, 16 Jul 2004 13:53:41 -0400435_US-ASCII Angela,
thanks. that was it. I changed the ZPARM DBACRVW from NO to YES and it worked great!!!
Thanks again
Ed
"Fung, Chi-Yun" cc: Sent by: DB2 Subject: Re: SQL -164 in DB2 V7.1 z/OS Data Base Discussion List
07/16/2004 01:24 PM Please respond to DB2 Database Discussion list at IDUG [...]
3289 43 19_question on trigger9_Le Nguyen20_lbnguyen@METLIFE.COM31_Fri, 16 Jul 2004 13:52:38 -0500342_- Lister,
Let's say that I have a table with the following columns: Table ACCOUNT (STAT_CD char(5), ACTV_DT date, .....)
I want to create a trigger such that when the STAT_CD column in a table changes from "OPN" to "CLS" or "INACT", set the ACTV_DT to current date.
Here is trigger that I initially tried to create: [...]
3333 125 66_Re: CICS (only SELECT) versus BATCH ( SELECT/INSERT/UPDATE/DELETE)12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Fri, 16 Jul 2004 14:14:20 -0500563_us-ascii You have several options. 1) You could bind all the packages into another collection with isolation UR. This would give all the select statements read authority even though the batch jobs have exclusive access to the tables. However, with a lock table exclusive you would return errors if the transaction tries to do an update. 2) Do you have a Data Warehouse that can be used? You can handle this with views that are granted to SELECT only for the CICS authorization ID or use a set of table like a data warehouse that are in Read Only mode. Using [...]
3459 139 64_Re: JDBC application SQL -805 for NULLID.SYSLN203 -- Help please14_Gonella, Vamsi22_Vamsi.Gonella@21ST.COM31_Fri, 16 Jul 2004 12:15:19 -0700603_iso-8859-1 Hi Mark and all who replied,
Thanks for your valuable information.
We have decided to do a code review and mean while bump up the package count to 20.
We hope this gives us some time before we completely understand and arrive at an optimum code and package number.
Regards Vamsi
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Mark Ediger Sent: Wednesday, July 14, 2004 9:17 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: JDBC application SQL -805 for NULLID.SYSLN203 -- Help please [...]
3599 88 23_Re: question on trigger12_Brill, Steve22_Steve.Brill@ECOLAB.COM31_Fri, 16 Jul 2004 14:16:52 -0500479_us-ascii Try this:
CREATE TRIGGER CHNGDT AFTER UPDATE OF STAT_CD ON ACCOUNT REFERENCING OLD AS O_ACCT NEW AS N_ACCT FOR EACH ROW MOD DB2SQL WHEN ( O_ACCT.STAT_CD = 'OPN' AND N_ACCT.STAT_CD IN ('CLS','INACT') ) UPDATE ACCOUNT SET ACTV_DT = CURRENT DATE ;
You don't need to use the BEGIN ATOMIC and END keywords unless you are triggering more than one action, so you don't need to worry about changing the SQL termination characters when you create the trigger. [...]
3688 85 25_Re: XML Extender DB2 z/OS12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Fri, 16 Jul 2004 14:53:34 -0500451_us-ascii I have not had a chance to work with the extenders on z/OS but I have presented on this subject at IDUG Asia in 2001 with windows as the platform. I found that North America was not even interested in the subject. When I was in Australia I found the interest to be much higher. However, it has been 3 years and I have not seen much growth in this area. With the lack of response from the list I'm sure not many are using these features. [...]
3774 88 55_Re: SQL JOIN observation -- is NULL not equal to NULL ?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Fri, 16 Jul 2004 14:53:34 -0500722_us-ascii I would clarify your work around with brackets. ...AND (A.DOC_DATE = B.DOC_DATE OR ( A.DOC_DATE IS NULL AND B.DOC_DATE IS NULL ) )
Troy Coleman, Sales Engineer IBM Certified Solutions Expert
SoftBase Systems, Inc. 847-776-0618 828-670-9900 ext. 334 troy.coleman@softbase.com
Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/
The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message. [...]
3863 175 55_Re: SQL JOIN observation -- is NULL not equal to NULL ?11_David Nance16_DWNance@FHSC.COM31_Fri, 16 Jul 2004 16:14:31 -0400510_US-ASCII Steve, The answer to your subject line is no. A null value is not equal to anything, it is a non-value. That is why you do not get the rows when your SQL says the columns = each other. Also, I think you may have your parens in the wrong spot in your SQL. Lastly, what if one of the data values is null and the other is not? Would you still want to see the row? If so, your SQL should look like: ...AND (A.DOC_DATE = B.DOC_DATE OR A.DOC_DATE IS NULL OR B.DOC_DATE IS NULL) Otherwise, I think this [...]
4039 159 64_Re: JDBC application SQL -805 for NULLID.SYSLN203 -- Help please10_Shyam Peri22_shyamperi@DAVLIN.CO.IN31_Sat, 17 Jul 2004 01:12:06 +0530566_iso-8859-1 1:37, Hi vamsi, We some time back had faced this problem. It happened because we left too many open statement unclosed(say abt 50-60-depeding on other parameters) . So a little bit a code optimization helped us in resolving this issue.
Warm regards Shyam Peri.
> Hi Mark and all who replied, > > Thanks for your valuable information. > > We have decided to do a code review and mean while bump up the package > count to 20. > > We hope this gives us some time before we completely understand and > arrive at an optimum code and [...]
4199 88 55_Re: SQL JOIN observation -- is NULL not equal to NULL ?12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Fri, 16 Jul 2004 15:17:04 -0500508_us-ascii Hi Steve, I just thought of another option for you. You could try the COALESCE function. I have not tested this but it should work: ...AND COALESCE(A.DOC_DATE, DATE('0001-01-01')) = COALESCE(B.A.DOC_DATE, DATE('0001-01-01'))
Troy Coleman, Sales Engineer IBM Certified Solutions Expert
SoftBase Systems, Inc. 847-776-0618 828-670-9900 ext. 334 troy.coleman@softbase.com
Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/ [...]
4288 55 28_Re: Job timeouts with itself7_db2sysc17_db2sysc@YAHOO.COM31_Fri, 16 Jul 2004 15:50:49 -0500609_- It resurfaced today. UNLOAD with DEGREE 'ANY'
Here is the MSTR log
02.47.47 STC06695 DSNT376I - PLAN=DSNTIAUL WITH CORRELATION-ID=XXXDLS5 CONNECTION-ID=BATCH LUW-ID=PISNETA.LUDBXP.BB8607745611=28115 THREAD-INFO=PRODXXX:*:*:* IS TIMED OUT. ONE HOLDER OF THE RESOURCE IS PLAN=DSNTIAUL WITH CORRELATION-ID=XXXDLS5 CONNECTION-ID=BATCH LUW-ID=PISNETA.LUDBXP.BB8607745611=28116 THREAD-INFO=PRODXXX:*:*:* ON MEMBER DBXP
The job ouput had
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE 00000201, AND RESOURCE NAME XXXDPDWB.XXXIPCW0 [...]
4344 28 55_Re: SQL JOIN observation -- is NULL not equal to NULL ?0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Fri, 16 Jul 2004 15:55:11 -0500453_us-ascii Troy offered:
Hi Steve, I just thought of another option for you. You could try the COALESCE function. I have not tested this but it should work: ...AND COALESCE(A.DOC_DATE, DATE('0001-01-01')) = COALESCE(B.A.DOC_DATE, DATE('0001-01-01'))
To which I reply -- AH HA!
My attempt at coalesce failed because I had COALESCE(A.DOC_DATE, 0) and got some sort of data type mismatch error. I gave up to quickly on it, I guess. [...]
4373 73 28_Re: Job timeouts with itself13_Solecki, Rohn19_Rohn.Solecki@GWL.CA31_Fri, 16 Jul 2004 16:14:35 -0500561_iso-8859-1 I did a quick scan through the zOS V7 Utility guide and didn't notice any mention of a "degree" option (but it is late Friday afternoon ... ;-) ) for UNLOAD or DSNTIAUL. Since you are apparently having problems with parallel processing (same plan and sequential LUW-ID), have you considered restricting the degree? Set it to 1 to see if you can get it to finish that way. It may not work because since V6 (or possibly V7) some of the utilities started spawning multiple threads for a single task (got caught by that during a DR test running out [...]
4447 30 19_Timeout zparm value19_Steve Toeniskoetter34_Steve.Toeniskoetter@HUNTINGTON.COM31_Fri, 16 Jul 2004 18:27:15 -0400419_us-ascii Listers,
DB2 z/OS V7, with the timeout zparm set to 180 seconds. It was set this way prior to any of my current staff being here. We're having some locking issues and I'm thinking of lowering this but am wondering what to lower it to. I searched the archives and IDUG/Tech Conference presentations, and didn't find much discussion on it. Mostly I found references to shops using the default of 60. [...]
4478 145 23_Re: question on trigger14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Sat, 17 Jul 2004 08:23:28 +0200
4624 38 44_Re: Search text for nondisplaying characters13_Steve Mallett23_smallett@OZEMAIL.COM.AU31_Sat, 17 Jul 2004 01:44:14 -0500481_- We can pretty easily use the translate function to find the existence of non-displaying characters along the lines of the following (sorry about the syntax as i'm currently offsite)
select key, 'Number of nondisp char=', length( strip( translate(upper(charcolumn) , ' ' ,'ABCDEF...(i.e all the displayable chars)...''!"&*()' ))) from table
but not their exact location. I guess to continue along these lines we'd need something like the following for counts=1 [...]
4663 26 32_Long Runtime for DSNTIAUL Unload11_Henry Boone16_hboone@GEICO.COM31_Sun, 18 Jul 2004 05:31:36 -0500374_- We have a job that performs a daily DSNTIAUL (no WHERE or ORDER BY clauses) unload of a table just before a Load (REPLACE) SYSREC DD DUMMY is perform on its table space. Usually, the number of rows fetched is around 7.5 million, GETPAGEs are around 1.5 million, SYNCRDs are around 38, SEQ Prefetch is invoked around 50,000 times, and the runtime is under 10 minutes. [...]
4690 26 70_Performance impact when package valid status changes from 'Y' to 'A' ?11_kumar karra24_kumarkarra2000@YAHOO.COM31_Sun, 18 Jul 2004 07:14:36 -0700445_us-ascii Is there any performance impact when the package's 'valid' status changes to 'A' because of an ALTER (eg. alter table data capture none )? Does it cause any additional overhead in executing the package? Is there any documentation that explains it?
Tia,
Kumar
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [...]