1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2006, week 5
2 107 29_Re: New zIIP specialty engine12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Sun, 29 Jan 2006 10:13:13 -0500501_iso-8859-1 Roger,
So, you're asking us to be patient, eh? Get us all worked up and then leak the information S L O W L Y. Just kidding!
My capacity guy already did the math of $$$ per MIP versus general purpose CPs and wants at least one zIIP on every CEC. He is assuming, of course, that sufficient cycles will be freed up on those general purpose CPs that will make this a very good value proposition. Well, I'm not from Missouri, but you know the rest of THAT story line. [...]
110 67 38_Re: Sql update Performance problem....13_Terry Purcell18_tpurcel@US.IBM.COM31_Sun, 29 Jan 2006 17:32:01 -0600409_- FYI. Dee confirmed based upon my off-list question that there was a mismatch of datatypes between B.ID (INTEGER) & A.DESIGN_ID (DECIMAL(8,0)).
Therefore, the following should improve performance even further:
UPDATE CTCPDD.STRPT2 A SET (FORMATTED_ECCKT) = (SELECT ISS_ST_CDE FROM CTCPDD.TCPXERR B WHERE B.ID = INTEGER(A.DESIGN_ID)) WHERE A.DESIGN_ID > 2499900 AND A.DESIGN_ID < 3000000 ; [...]
178 52 42_Re: pattern-expression in a LIKE predicate11_Suresh Sane21_data_arch@HOTMAIL.COM31_Sun, 29 Jan 2006 21:06:43 -0600322_- Steve,
Clearly, col1 like '%col2%' etc is not possible.
Have you tried using the scalar functions LOCATE or POSSTR? I think these came in V6. May have to tweak things since varchar is aasumed - I recall running into issues whne the columns are char. I can send you sample SQL if you are really stuck. [...]
231 20 42_Re: pattern-expression in a LIKE predicate0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Mon, 30 Jan 2006 00:34:14 -0600740_US-ASCII Hello,
I was hoping for COL1 LIKE COL2, where COL2 already had imbeded underscores or percent signs. However, I am able to work around the current situation with the "between" predicate, so the quesion is now somewhat academic.
Thanks!
Stg
--------------------------------------------------------------------------------- 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
252 23 50_Re: Temporary table with data values in the select33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Mon, 30 Jan 2006 02:21:29 -0600398_- Hi
I don't know exactly what you mean, but a CREATE in between a Select in DB2 z/OS is not allowed. May be, you are looking for a statement like that:
SELECT A.DBNAME, NAME, NUMBER FROM SYSIBM.SYSTABLESPACE A, TABLE (SELECT DBNAME, COUNT(*) AS NUMBER FROM SYSIBM.SYSTABLESPACE B WHERE A.DBNAME = B.DBNAME AND A.NAME <= B.NAME GROUP BY B.DBNAME ) AS T ORDER BY A.DBNAME, NUMBER [...]
276 15 38_DB2 for LUW Static SQL Monitoring tool11_Paul Turpin34_pault@ALUMMAIL.SIMON.ROCHESTER.EDU31_Mon, 30 Jan 2006 05:09:05 -0600397_- If anyone has experience with a tool that gathers information about static SQL on the DB2 for Linux, Unix, Windows (LUW) platform, I would be interested in hearing about it. By gathering information, I mean number of times the static SQL statement has executed, execution times, CPU cost for the statement, etc. I know event monitors can capture data, but they don't aggregate the results. [...]
292 62 29_ALTER identity column options58_=?iso-8859-9?Q?Serdar_Sabri_=D6zkubulay_=28B.T.S.Y.G.=29?=27_Serdar.Ozkubulay@AKBANK.COM31_Mon, 30 Jan 2006 13:22:30 +0200983_iso-8859-9 Hi all,
It is not possible to ALTER identity column options in V7. What do you think about the consequences if I update the CACHE value from 0 to 20 on the SYSSEQUENCES catalog table manually?
Thanks
Serdar Sabri OZKUBULAY AKBANK, DB2 Systems programmer
*************************************************************************************
Bu e-posta ve muhtemel eklerinde verilen bilgiler kişiye özel ve gizli olup, yalnızca mesajda belirlenen alıcı ile ilgilidir.Size yanlışlıkla ulaşmışsa lütfen göndericiye bilgi veriniz, mesajı siliniz ve içeriğini başka bir kişiye açıklamayınız, herhangi bir ortama kopyalamayınız. Bu mesaj aksi sözleşme ile belirtilmedikçe herhangi bir finansal işlem teklifi, alımı, satımı veya herhangi bir havalenin teyidi gibi [...]
355 261 35_Off Topic - ACF2 to RACF Conversion15_Schade, Jeffrey15_JSchade@ISO.COM31_Mon, 30 Jan 2006 07:46:19 -0500536_US-ASCII I was asked to post this by my security group and I was hoping someone might be able to point me in the direction of a RACF discussion group:
"We want to migrate from the ACF2/DB2 interface to the IBM supplied DB2 exit that calls an external security product using RACROUTE calls. We want to implement that exit with as few modifications as possible. It is our understanding that our ACF2 rules will need to be modified. Has anyone built any software (REXX Preferred) to make such modifications???" [...]
617 99 33_Re: ALTER identity column options14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jan 2006 13:06:39 -0000435_iso-8859-9 The official answer is "You cannot do that so it is an irrelevant question"
The unofficial (Phil Grainger) answer is "Try it in a sandbox DB2 subsystem and see what happens". Don't forget you might want to consider whether you need to rebuild the DBD as well. Also, just because you have verified that it works on your maintenance level of DB2, don't assume it will work again in the same way at any other time. [...]
717 16 34_LOAD OD DECIAML INTO A CHAR COLUMN14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Mon, 30 Jan 2006 07:43:33 -0600592_US-ASCII In DB2 v6 on Z/OS I need to load a decimal column into a character column what is the load syntax?
Thanks
--------------------------------------------------------------------------------- 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
734 49 38_Re: LOAD OD DECIAML INTO A CHAR COLUMN14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jan 2006 13:48:34 -0000430_US-ASCII Don't forget CHAR is left justified, DECIMAL is right justified, aligned on the decimal point so.....
The easiest way is if your decimal data is a FIXED length, zero-padded, decimal-point aligned field, then you can load it as if it were a character column
Phil Grainger CA 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 [...]
784 68 38_Re: LOAD OD DECIAML INTO A CHAR COLUMN14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Mon, 30 Jan 2006 07:50:15 -0600366_US-ASCII Correct but the unloaded file is packed and I need it character. What can I use to get it to display?
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Grainger, Phil Sent: Monday, January 30, 2006 7:49 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] LOAD OD DECIAML INTO A CHAR COLUMN [...]
853 186 38_Re: LOAD OD DECIAML INTO A CHAR COLUMN13_Richard Fazio21_rfazio@TRANSUNION.COM31_Mon, 30 Jan 2006 08:01:08 -0600409_US-ASCII Not a lot of choices here. How about some more details?
How many records to be loaded? 100's, 1000's, Millions? What's the frequency of the load? What is the source of the data (what feeds the flat file)?
fa
Rich Fazio Information Architecture
TransUnion, LLC Marketing Services, 8th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-6453 [...]
1040 91 38_Re: LOAD OD DECIAML INTO A CHAR COLUMN14_Zobjeck, A. J.21_Allen_Zobjeck@TTX.COM31_Mon, 30 Jan 2006 08:01:51 -0600396_US-ASCII I think I have it.
Unload with an SQL statement with CHAR on the column and then load with decimal external.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Zobjeck, A. J. Sent: Monday, January 30, 2006 7:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] LOAD OD DECIAML INTO A CHAR COLUMN [...]
1132 106 38_Re: LOAD OD DECIAML INTO A CHAR COLUMN14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jan 2006 14:02:30 -0000340_US-ASCII Ahh - OK
It depends what you are unloading with
Most 3rd party unload tools (BMC, CA etc) allow you to CHANGE the datatype whilst you are unloading
If you are using IBM unload you can't
If you are using DSNTIAUL, use the DIGITS() function in a view definition over the table and "unload" from that [...]
1239 126 38_Re: LOAD OF DECIAML INTO A CHAR COLUMN14_Grainger, Phil20_Phil.Grainger@CA.COM31_Mon, 30 Jan 2006 14:05:16 -0000340_US-ASCII Except I just noticed that the DIGITS() function does NOT propagate the sign OR the decimal point into the character string. Seems a bit of a pointless function considering!
Phil Grainger CA 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 [...]
1366 118 39_Re: Off Topic - ACF2 to RACF Conversion0_26_wdavies@CO.EL-DORADO.CA.US31_Mon, 30 Jan 2006 06:22:15 -0800508_UTF-8 Here is the address for the Racf listserver RACF-L@LISTSERV.UGA.EDU Hope it helps.
Walter Davies DBA Racf Administrator El Dorado County, CA
"Schade, Jeffrey" Sent by: DB2 Data Base Discussion List 01/30/2006 04:46 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] Off Topic - ACF2 to RACF Conversion [...]
1485 53 25_Execute on Plan Privilege21_Deepak Gujaba Gaikwad24_deepakggaikwad@YAHOO.COM31_Mon, 30 Jan 2006 06:35:15 -0800544_iso-8859-1
Hello All,
Our latest security audit expressed concern over access to Plans to user. We have a single plan for cics and batch for every application. We perform sysprog/dba functions + security for application database/data.
We have granted execute access on plans (implementing packages) to all CICS Users. Executions of program thru cics is not a problem as all the programs are modified changeman (with 2-3 approvals) and in CICS' own libraries. Also the cics applications have their own security level. [...]
1539 154 29_Re: Execute on Plan Privilege13_Richard Fazio21_rfazio@TRANSUNION.COM31_Mon, 30 Jan 2006 08:58:37 -0600662_US-ASCII Why can't you have multiple plans?
Use the same package list with two permission styles.
Simple...no? faz
Rich Fazio Information Architecture
TransUnion, LLC Marketing Services, 8th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-6453
Talk to teach - Listen to learn
>>> deepakggaikwad@YAHOO.COM 2006-01-30 8:35:15 AM >>>
Hello All,
Our latest security audit expressed concern over access to Plans to user. We have a single plan for cics and batch for every application. We perform sysprog/dba functions + security for application database/data. [...]
1694 25 28_ODBC drivers and CLOBs > 32k16_Natalie Faulkner20_nfaulknr@WVADMIN.GOV31_Mon, 30 Jan 2006 09:20:18 -0600348_ISO-8859-1 I have a group of Visual Basic developers that are attempting to SELECT and INSERT CLOB/XML data into a DB2 v7 for z/OS table.
The problem arises when the CLOB/XML data is larger than 32k… They can SELECT the rows use an OLE driver but the INSERT will timeout. They can INSERT using an ODBC driver but the SELECT times out…. [...]
1720 130 29_Re: Execute on Plan Privilege9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 30 Jan 2006 09:28:10 -0600604_Windows-1252 You need to setup several things. 1. Take Rich's advice and setup separate plans for CICS, batch production, and user submitted batch. 2. use enable and disable parms on the BIND to make sure the batch users can't use the CICS plans without going through CICS security. 3. setup batch 'production' plans that are only executed by jobs submitted by production scheduler. 4. setup 'user' plans that only have a restricted list of packages neccessary to perform the business functions required. 5. Decide how you are going to lock down the dynamic SQL tools. This will be a combination of [...]
1851 163 39_DB2 V8 & Websphere 5.1 both on z/OS 1.610_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Mon, 30 Jan 2006 09:53:09 -0600537_US-ASCII Hi all,
I'm going to put in a question with IBM on this but I thought I'd throw it out here also. We have a relatively small J AVA application (it runs about (200,000 units of work per day) running on a Websphere using DB2 as the data store. In short, the Websphere app server is eating up to 7 engines on a 2084-B16 box with a zAAP engine turned on. I've run reports against the DB2 smf data and find that the in-DB2 elapsed time an cpu time are a small percentage of the total TCB elapsed time and [...]
2015 347 43_Re: DB2 V8 & Websphere 5.1 both on z/OS 1.60_20_simon.george@UBS.COM31_Mon, 30 Jan 2006 16:37:45 -0000489_US-ASCII Jim,
We run several million JAVA/CICS transactions a day and several 100,000 WAS ones and we don't burn that even without the zAAP's (and ours a very heavy complex transactions).
The only thing I can think of that will burn CPU at that rate is if you are continually re-JITing code due to the JVM's being binned. The most likely cause of that is the JVM going out of memory (should say that in the log). The three most common causes of that I can think of are: [...]
2363 104 29_Re: Execute on Plan Privilege14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Mon, 30 Jan 2006 09:58:08 -0800606_iso-8859-1 DSN3ATH has addressability to a the exit parameter list which is mapped by DSNDEXPL,
One of the fields in this list is EXPLTYPE that can be tested for the string BATCH If EXPLTYPE=BATCH and the authid is not your scheduler user id ABORT.
It has always been my personal view that reliability availability and serviceability / maintainability (what IBM once called RAS) are high level audit concerns. If RAS is a high lever objective for ones shop it is a good idea to avoid micromanaging things via difficult to support exits. Of course in some shops making sure that improper [...]
2468 43 24_Z/OS DB2 V7 SQL question12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Jan 2006 11:02:29 -0800414_iso-8859-1 I don't seem to understand some of the SQL results I'm getting:
There are about 529,000 rows in each table of which about 33,000 match on rowid.
If I have the following SQL, I get value for count > 0 (about 33,000):
SELECT COUNT(*) FROM TESTZU.RUATAUDT T WHERE T.BMW_ADDED_ROWID IN (SELECT BMW_ADDED_ROWID FROM TESTZU.RUAYAUDT Y WHERE T.BMW_ADDED_ROWID = Y.BMW_ADDED_ROWID ) ; [...]
2512 93 28_Re: Z/OS DB2 V7 SQL question14_Avram Friedman21_avramf@IBMSYSPROG.COM31_Mon, 30 Jan 2006 11:19:26 -0800433_iso-8859-1 Perhaps a damaged index.
SELECT COUNT(*) FROM TESTZU.RUATAUDT T
would normally be an index only operation.
The full statement could require base table access for either or both of the tables.
I am always question data and object quality for things with TEST in there name.
Myron Miller wrote: I don't seem to understand some of the SQL results I'm getting: [...]
2606 366 49_DB2 for Z/OS Version 8 and OS/VS Cobol and COBOL217_Gugel, Rich - DOA24_Rich.Gugel@WISCONSIN.GOV31_Mon, 30 Jan 2006 13:22:20 -0600597_us-ascii Here's a bit of SQL I wrote to identify package and plans running with old CobolDBRM's. I apologize in advance if someone has already posted this orpresented it at a conference "IBM Cobol" is the result you want to see. SELECT COLLID ,HOSTLANG ,COUNT(*) AS COUNT FROM (SELECT COLLID ,CASE HOSTLANG WHEN 'C' THEN 'OS/VS COBOL - CONVERT!' WHEN '2' THEN 'COBOL 2 - CONVERT! ' WHEN '3' THEN 'IBM COBOL ' ELSE 'UNKNOWN ' END AS HOSTLANG FROM SYSIBM.SYSPACKAGE WHERE HOSTLANG IN ('C', '2', '3') ) AS WHOCARES GROUP BY COLLID ,HOSTLANG ORDER BY COLLID ,HOSTLANG; SELECT PLCREATOR ,HOSTLANG [...]
2973 438 53_Re: DB2 for Z/OS Version 8 and OS/VS Cobol and COBOL214_Flatley, Lynne31_Lynne.Flatley@LIBERTYMUTUAL.COM31_Mon, 30 Jan 2006 14:49:20 -0500538_us-ascii Thanks! Worked great!
Lynne Flatley
"Good and evil both increase at compound interest. That is why the little decisions you and I make every day are of such infinite importance." --C. S. Lewis
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Gugel, Rich - DOA Sent: Monday, January 30, 2006 2:22 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 for Z/OS Version 8 and OS/VS Cobol and COBOL2 [...]
3412 415 53_Re: DB2 for Z/OS Version 8 and OS/VS Cobol and COBOL217_Gugel, Rich - DOA24_Rich.Gugel@WISCONSIN.GOV31_Mon, 30 Jan 2006 13:58:57 -0600633_us-ascii I realized after sending this that this was dependent on the proper language being passedto the precompiler, a quick test showed that you could get any of the three cobol variants through. Rich Gugel State of Wisconsin Department of Administration DB2 Systems Programmer From: Gugel, Rich - DOA [mailto:Rich.Gugel@Wisconsin.gov] Sent: Monday, January 30, 2006 1:22 PM To: DB2 Database Discussion list at IDUG Subject: DB2 for Z/OS Version 8 and OS/VS Cobol and COBOL2 Here's a bit of SQL I wrote to identify package and plans running with old CobolDBRM's. I apologize in advance [...]
3828 39 22_DB2V7 Z/os AUDIT Trace4_Paul19_the_baran@YAHOO.COM31_Mon, 30 Jan 2006 14:28:12 -0600428_- Hello all,
I was asked to propose the activation of DB2 AUDIT/Logging functionality of 'high privledged accounts' so the auditors can generate and review reports to show activites performed by these accounts withing DB2.
The AUDIT trace appears to capture the right information they are looking for, however I have some questions and concerns that I have not been able to satisfy by digging in the manuals. [...]
3868 114 28_Re: Z/OS DB2 V7 SQL question12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Jan 2006 13:01:26 -0800474_iso-8859-1 I know the indexes are all good. And one table is nothing more than a DSN1COPY of the other one.
Plus I don't understand why these two produce different results: SELECT COUNT(*) FROM TESTZU.RUATAUDT T WHERE T.BMW_ADDED_ROWID IN (SELECT BMW_ADDED_ROWID FROM TESTZU.RUAYAUDT Y WHERE T.BMW_ADDED_ROWID = Y.BMW_ADDED_ROWID ) ;
and SELECT COUNT(*) FROM TESTZU.RUATAUDT T WHERE T.BMW_ADDED_ROWID IN (SELECT BMW_ADDED_ROWID FROM TESTZU.RUAYAUDT Y ) ; [...]
3983 173 28_Re: Z/OS DB2 V7 SQL question9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 30 Jan 2006 15:21:07 -0600415_Windows-1252 The difference between the SQL's is simple. The first sql is restricted by correlation of WHERE T.BMW_ADDED_ROWID = Y.BMW_ADDED_ROWID. If you explain the 2 SQL's, you should find the difference is how many BMW_ADDED_ROWID are returned to evaluate.
The first query should run faster and the second should give the same results but slower unless there is a structural problem with the table. [...]
4157 201 28_Re: Z/OS DB2 V7 SQL question11_Suresh Sane21_data_arch@HOTMAIL.COM31_Mon, 30 Jan 2006 16:39:27 -0600678_- Myron,
Is the column in the subquery nullable by any chance? If it is, does at least one row with a value of null exist on the inner table?
Thanks, Suresh
>From: Mike Bell >Reply-To: DB2 Database Discussion list at IDUG >To: DB2-L@WWW.IDUGDB2-L.ORG >Subject: Re: [DB2-L] Z/OS DB2 V7 SQL question >Date: Mon, 30 Jan 2006 15:21:07 -0600 > >The difference between the SQL's is simple. The first sql is restricted by >correlation of WHERE T.BMW_ADDED_ROWID = Y.BMW_ADDED_ROWID. If you explain >the 2 SQL's, you should find the difference is how many BMW_ADDED_ROWID >are >returned to evaluate. > [...]
4359 219 28_Re: Z/OS DB2 V7 SQL question12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 30 Jan 2006 15:07:27 -0800596_iso-8859-1 Yes to both.
And I know that there are only 33,000 rows that match and at least one that doesn't match. I found that the hard way.
--- Suresh Sane wrote:
> Myron, > > Is the column in the subquery nullable by any chance? If it is, does at > least one row with a value of null exist on the inner table? > > Thanks, > Suresh > > > >From: Mike Bell > >Reply-To: DB2 Database Discussion list at IDUG > >To: DB2-L@WWW.IDUGDB2-L.ORG > >Subject: Re: [DB2-L] Z/OS DB2 V7 SQL question > >Date: [...]
4579 116 29_Re: Execute on Plan Privilege21_Deepak Gujaba Gaikwad24_deepakggaikwad@YAHOO.COM31_Mon, 30 Jan 2006 17:55:54 -0800413_iso-8859-1 Thank you everybody for your help. Looks like going for a separate CICS plan is the easiest way of doing this. Also these change won't require\affect developers and users; can be done within the sysprog team.
Thanks again for all your replies.
Avram Friedman wrote: DSN3ATH has addressability to a the exit parameter list which is mapped by DSNDEXPL, [...]
4696 58 45_Antwort: [DB2-L] ODBC drivers and CLOBs > 32k12_Rodney Krick15_rk@AFORMATIK.DE31_Tue, 31 Jan 2006 07:14:17 +0100
4755 115 33_Re: UDB LUW optimization guidence11_Grant Allen17_gxallen@GMAIL.COM31_Tue, 31 Jan 2006 21:44:59 +1100561_ISO-8859-1 Hodgin, Scott wrote: > > Hi list. > > > > We're UDB LUW FIX 10 > > > > I have a pretty complicated view under this definition: > UDBSCFBDM.VEHICLE_VERSION > > > > This statement: > > SELECT * FROM UDBSCFBDM.VEHICLE_VERSION > > where policy_control in ('1995-04-01-00.01.01.77422') > > > > Has a cost estimate of about 1100 and this query returns the results > in about 1 second against tables with millions of rows (hopefully > indexed properly) > > > > > > This statement > > SELECT * FROM UDBSCFBDM.VEHICLE_VERSION > > where policy_control in [...]
4871 136 33_Re: UDB LUW optimization guidence13_Hodgin, Scott19_shodgin@SCFBINS.COM31_Tue, 31 Jan 2006 07:27:44 -0500440_- Thanks for the reply. I tried setting the optimization level = 9 and this is the cost:
Estimated Cost = 3109360.250000
Scott Hodgin, Database Administrator South Carolina Farm Bureau Insurance Company shodgin@scfbins.com
-----Original Message----- From: Grant Allen [mailto:gxallen@GMAIL.COM] Sent: Tuesday, January 31, 2006 5:45 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] UDB LUW optimization guidence [...]
5008 47 26_DB2 for AIX, HADR and LOBs14_Martin Flavell18_mflavell@I-TCS.COM31_Tue, 31 Jan 2006 13:50:08 +0000
5056 20 32_Omegamon V540 on DB2 V8 for Z/os11_Asaf Meller17_db2-1@NIOI.GOV.IL31_Tue, 31 Jan 2006 08:05:05 -0600530_- Hello, 1. Has any one tried the configuration of : Omegamon V540 on DB2 V8 for Z/os ? If so , is there any intresting (or not intresting) problem that was encountered ? 2. The omegamon v540 online collector doesn't seem to support db2 tables instead of vsam files as the target for the collection (according to IBM) .Did any one take the risk of trying this method of collection ? what were its results ? 3. I would appreciate a general comment on omegamon V540 , especially after it had been bought by IBM. Thanks , Asaf. [...]
5077 45 36_Re: Omegamon V540 on DB2 V8 for Z/os13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 31 Jan 2006 10:00:15 -0500422_- I believe we were told by Candle (a long time ago) and by IBM that v450 does not support v8. I think we believed them and didn't try it.
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Asaf Meller Sent: Tuesday, January 31, 2006 9:05 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Omegamon V540 on DB2 V8 for Z/os [...]
5123 75 36_Re: Omegamon V540 on DB2 V8 for Z/os5_db2-117_db2-1@NIOI.GOV.IL31_Tue, 31 Jan 2006 17:12:52 +0200384_windows-1255 Hello Dave , I am regarding V540 (not 450) which is supposed to support DB2 V8 according to IBM. What did you use instead ?
----- Original Message ----- From: "Seibert, Dave" Newsgroups: bit.listserv.db2-l To: Sent: Tuesday, January 31, 2006 5:00 PM Subject: Re: [DB2-L] Omegamon V540 on DB2 V8 for Z/os [...]
5199 181 27_V7 end of support web page?15_Chris Hoelscher21_choelscher@HUMANA.COM31_Tue, 31 Jan 2006 10:28:52 -0500521_US-ASCII on http://www-306.ibm.com/software/data/db2/zos/support/plc/, IBM now asserts:
Ver/Rel OS/Platform PID EOM EOS 8 z/OS 5625-DB2 TBD TBD 7 OS/390, z/OS 5675-DB2 2Q2006* September, 2007* 6 OS/390 5645-DB2 30-Jun-02 30-Jun-05 5 OS/390 5655-DB2 31-Dec-01 31-Dec-02 4 MVS/ESA 5695-DB2 01-Dec-00 31-Dec-01 3 MVS 5685-DB2 29-Feb-00 31-Jan-01
* Indicates projected date. Actual end of marketing or end of service date has not been announced yet. [...]
5381 113 36_Re: Omegamon V540 on DB2 V8 for Z/os13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 31 Jan 2006 10:33:51 -0500473_- Sorry for my careless reading of your message, Asaf.
We have Omegamon XE for DB2 PM V3.1.0 according to the installer. and acc. to the classic panels. But the CUA screens show v540.
Dave
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of db2-1 Sent: Tuesday, January 31, 2006 10:13 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Omegamon V540 on DB2 V8 for Z/os [...]
5495 59 33_Re: ALTER identity column options12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jan 2006 09:49:45 -0600728_ISO-8859-1 If you just change the catalog or use other functions, the most likely result is that you break the sequence, discovering some new abend codes. The code in V8 is much more involved.
Roger Miller
On Mon, 30 Jan 2006 13:22:30 +0200, =?iso-8859-9?Q? Serdar_Sabri_=D6zkubulay_=28B.T.S.Y.G.=29?= wrote:
>Hi all, > >It is not possible to ALTER identity column options in V7. What do you think about the consequences if I update the CACHE value from 0 to 20 on the SYSSEQUENCES catalog table manually? > >Thanks > >Serdar Sabri OZKUBULAY >AKBANK, DB2 Systems programmer > > > >************************************************************************** *********** > > [...]
5555 15 22_Field level encryption36_Anne Stout-Delaware Valley UG Leader23_anne.stout@DOWJONES.COM31_Tue, 31 Jan 2006 09:51:11 -0600410_- I'm at DB2 V7, and need to be able to encrypt data on a field level. Does anyone have a method for doing this that they would be willing to share? I also need a solution for the IDMS db engine if anyone has something that would work for both that would be great! We are thinking of using an editproc to call ICSF (Integrated Cryptographic Service Facility) and Crypto hardware to minimize the overhead. [...]
5571 31 56_DB2 z/OS V7: Using Stored Procedure DBINFO to find LUWID17_Chris Worthington20_cworthi@AGRIBANK.COM31_Tue, 31 Jan 2006 10:59:05 -0600638_ISO-8859-1 One of the environment variables systematically passed to a stored procedure as a result of creating the procedure with the DBINFO option is the Unique application identifier (see following explanation cut from the DB2 UDB for OS/390 and z/OS V7 Application Programming and SQL Guide)…
Unique application identifier This field is a pointer to a string that uniquely identifies the application's connection to DB2. The string is regenerated for each connection to DB2. The string is the LUWID, which consists of a fully- qualified LU network name followed by a period and an LUW instance number. The LU network name [...]
5603 28 49_DB2 UDB V8 on AIX How to audit just a few tables?24_Ramachandran Subramanian16_rrnsss@YAHOO.COM31_Tue, 31 Jan 2006 10:59:05 -0600484_- Dear Gurus,
I have a DB2 Production Instance V8 on AIX. As a part of some audit requirement, all SQLs that are run against a set of 3 tables in a particular database, need to be monitored.
However , I need to exclude a particular userid from this audit process as it is a valid production websphere userid, say WEBPROD1 . All I want to audit is, any access attempts (select,insert,update,delete) on this table (s) made by anyone else other than WEBPROD1. [...]
5632 80 26_Re: DB2V7 Z/os AUDIT Trace12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jan 2006 11:09:30 -0600328_- >1) Is there a way to start a AUDIT trace (all classes)on a group of say > 40- 50 user ids?
There is a list of ids in -START TRACE (AUDIT). CLASS(*) or all is the default. I don't know the limit on numbers of ids. Key references Audit chapter in Administration Guide and -START TRACE chapter in Commond Reference. [...]
5713 131 36_Re: Omegamon V540 on DB2 V8 for Z/os12_Isaac Yassin20_yassini@BEZEQINT.NET31_Tue, 31 Jan 2006 19:13:30 +0200382_us-ascii Hi Dave,
AFAIK the XE is a wrapper around 540 engine. Ed woods - are you there? Any comment?
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Seibert, Dave Sent: Tuesday, January 31, 2006 5:34 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Omegamon V540 on DB2 V8 for Z/os [...]
5845 85 31_Re: V7 end of support web page?12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jan 2006 11:14:45 -0600313_- We have not provided projected dates on this page before, so I'd say we have a null result set or SQLCODE=100. Five years is the intended life cycle, and V7 reaches that mark in two months. After that, you're on borrowed time or paying additional for service, while not getting the benefits of later work. [...]
5931 114 29_Re: New zIIP specialty engine12_Roger Miller19_millerrl@US.IBM.COM31_Tue, 31 Jan 2006 11:47:25 -0600422_- With all of the variations in hardware situations, business situations and software charging, the work is complicated. The implementation is also complicated. So estimation is not simple. We'll probably have to stage in the information, with the most typical, simplest case first, DRDA access. We are working on a planning tool, but verifying the results means that we need the real product, with all of the parts. [...]
6046 69 30_Re: DB2 for AIX, HADR and LOBs12_Martin Hubel17_Martin@MHUBEL.COM31_Tue, 31 Jan 2006 13:03:00 -0500
6116 64 29_Re: New zIIP specialty engine12_Richards.Bob25_Bob.Richards@SUNTRUST.COM31_Tue, 31 Jan 2006 13:25:01 -0500723_iso-8859-1 Roger,
Understood. Thanks for replying. I'll try to be patient!
Bob
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Roger Miller Sent: Tuesday, January 31, 2006 12:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] New zIIP specialty engine
With all of the variations in hardware situations, business situations and software charging, the work is complicated. The implementation is also complicated. So estimation is not simple. We'll probably have to stage in the information, with the most typical, simplest case first, DRDA access. We are working on a planning tool, but verifying the results means that we [...]
6181 424 26_DB2 V8 LOAD RESUME Utility15_Schade, Jeffrey15_JSchade@ISO.COM31_Tue, 31 Jan 2006 13:49:56 -0500547_US-ASCII We have an application which inserts large amounts of data (1 million - 20 million new rows daily) using a LOAD utility with the RESUME YES SHRLEVEL NONE option. The table being loaded is partitioned and has a total of 9 indexes defined (I know this is way too many indexes). We have had two instances where the LOAD utility has failed in the SORTBLD phase and both times we could not restart the utility but had to REBUILD all the indexes that were in rebuild pending status. I want to know if a LOAD utility using these options is [...]
6606 175 29_Re: Execute on Plan Privilege7_troycci29_troycci@COLEMANCONSULTING.COM31_Tue, 31 Jan 2006 12:55:19 -0600588_us-ascii I agree with Mike and Rich on this. You did not mention web applications but you should consider dynamic threads also. You can implement the resource limit facility to manage dynamic SQL to keep out everyone except specific plan, collection, package or AuthID - remote or local.
The security exit is an option but IMHO it seems to be an extreme option. You are exposing your self to maintenance issues not only on DB2 upgrades but also with staff turn over. The options that Rich and Mike gave are using built in features within DB2 to control access. These features [...]
6782 89 28_Re: Z/OS DB2 V7 SQL question7_troycci29_troycci@COLEMANCONSULTING.COM31_Tue, 31 Jan 2006 13:31:28 -0600447_us-ascii It is rare but you may have an INCORROUT issue. That is given one access method you get "X ROWS" but with the same criteria using a different access path you get "Z ROWS". I would do an explain on the two statements and note the access method. Nested Loop Join versus Hybrid Join. When IBM first came out with Hybrid joins they had some incorrect output issues. Search for any APAR's and verify your DB2 subsystem maintenance level. [...]
6872 158 30_Re: DB2 V8 LOAD RESUME Utility9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 31 Jan 2006 13:33:31 -0600575_Windows-1252 Your problem is SORTKEYS
From the manual If you use the SORTKEYS option and the LOAD job terminates during the RELOAD, SORT, BUILD, or SORTBLD phases, then both RESTART and RESTART(PHASE) restart from the beginning of the RELOAD phase. However, restart of LOAD RESUME YES or LOAD PART RESUME YES in the BUILD or SORTBLD phase will result in message DSNU257I. Which says DSNU257I csect-name UNABLE TO RESTART BUILD PHASE Explanation: Restarting in the BUILD PHASE or the SORTBLD phase of the LOAD utility with the RESUME(YES) option is not permitted. [...]
7031 69 57_Re: [DB2 V8 z/OS NFM] complex join using VARCHAR and CHAR7_troycci29_troycci@COLEMANCONSULTING.COM31_Tue, 31 Jan 2006 13:52:38 -0600649_iso-8859-1 This was really cool. Thanks for the insight.
Troy Coleman, Support 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. [...]
7101 293 30_Re: DB2 V8 LOAD RESUME Utility13_Richard Fazio21_rfazio@TRANSUNION.COM31_Tue, 31 Jan 2006 14:20:04 -0600452_US-ASCII I've used SHRLEVEL CHANGE to load quite a bit. Much faster than INSERTs, Much less CPU (About 30% lower CPU consumption).
We regularly load 20-100MM rows at a time into a table with over 12Billion rows. Restart is GREAT! Concurrency is wonderful.
faz
Rich Fazio Information Architecture
TransUnion, LLC Marketing Services, 8th Floor 555 West Adams St. Chicago, IL 60661 Phone (312) 985-3270 Fax (312) 466-6453 [...]
7395 187 3_Re:12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Tue, 31 Jan 2006 14:36:13 -0600380_us-ascii I would code something like this: SELECT '1 INSERT INTO targetname.' CONCAT STRIP(NAME) FROM SYSIBM.SYSTABLES WHERE CREATOR = 'sourcename' AND TYPE = 'T' AND CARDF > 0 UNION ALL SELECT '2 SELECT * FROM ' CONCAT STRIP(CREATOR) CONCAT '.' CONCAT STRIP(NAME) CONCAT ';' FROM SYSIBM.SYSTABLES WHERE CREATOR = 'sourcename' AND TYPE = 'T' AND CARDF > 0 ORDER BY 1 WITH UR [...]
7583 293 30_Re: DB2 V8 LOAD RESUME Utility12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Tue, 31 Jan 2006 14:36:13 -0600388_us-ascii If you read the DB2 Utility Guide for Load Restart you will see that with RESUME YES you will get the following message: DSNU257I csect-name UNABLE TO RESTART BUILD PHASE
Explanation: Restarting in the BUILD PHASE or the SORTBLD phase of the
LOAD utility with the RESUME(YES) option is not permitted.
Severity: 8 (error) [...]
7877 455 52_Re: Antwort: [DB2-L] z/OS DB2 Security Configuration7_troycci29_troycci@COLEMANCONSULTING.COM31_Tue, 31 Jan 2006 14:38:49 -0600305_us-ascii Hi Kevin, I would agree with Roy however would add one more thing for item 3. Page 111 of the DB2 Administration Guide has a nice chart showing the levels of authority.
INSTALL SYSADM is "GOD" at the top. As Roy said this is need to for DB2 systems programmer installing the product. [...]
8333 50 68_Go Further at IDUG 2006 - North America, Schedule of Events Now Live35_Mike Skaff - Colorado zOS UG Leader28_mike.skaff@FIRSTDATACORP.COM31_Tue, 31 Jan 2006 14:37:25 -0600376_- Go Further with more than 180 technical sessions at IDUG 2006 - North America.
The IDUG 2006 - North America Schedule of Presentations and Events is now live. View this most comprehensive technical program featuring ontent selected by user-led planning committees from IDUG and the International Informix Users Group (IIUG). Start planning your itinerary today! [...]
8384 39 32_DB2 V7 z/os v1.4 data encryption12_Jeff Frazier26_Jeffrey_Frazier@WENDYS.COM31_Tue, 31 Jan 2006 15:48:17 -0500329_US-ASCII Hello,
We currently have an application running on DB2 UDB AIX that encrypts data. There is a requirement to move this to DB2 V7 z/os. We have plans to go to v8 but not near future. Are there products that anyone is using that will encrypt/decrypt the data within db2 v7 that we can currently use? TIA, Jeff [...]
8424 475 30_Re: DB2 V8 LOAD RESUME Utility13_Burgess Evans27_BMEvans@OHIOAUD.STATE.OH.US31_Tue, 31 Jan 2006 16:03:11 -0500286_US-ASCII Hi Jeff,
I don't know if this will help or not, you may have even tried it already, but the following LOAD statements have worked well for me over the years. Please note that we are still on DB2 V7 z/OS so I can only assume the LOAD syntax for V8 is similar to V7. [...]
8900 45 25_DMS tablespace size error3_lan18_lxw176@HOTMAIL.COM31_Tue, 31 Jan 2006 15:19:40 -0600564_- I tried to restore DB2 UDB two databases into two different instances on AIX server. the raw devices size of rShortSpace0 and rShortSpace1 on the two instances are the same. # lsvg -l datavg datavg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT db2templv jfs 52 52 1 open/syncd /db2temp loglv00 jfslog 1 1 1 open/syncd N/A RegSpace0 jfs 12 12 1 closed/syncd N/A RegSpace1 jfs 12 12 1 closed/syncd N/A RegSpace2 jfs 12 12 1 closed/syncd N/A RegSpace3 jfs 12 12 1 closed/syncd N/A ShortSpace1 jfs 12 12 1 closed/syncd N/A ShortSpace2 jfs 12 12 1 closed/syncd [...]
8946 395 30_Re: DB2 V8 LOAD RESUME Utility9_Mo, Don D12_donmo@BU.EDU31_Tue, 31 Jan 2006 16:36:05 -0500485_US-ASCII If the input/import data is from existing tables, I just wonder if people have tried "DB2MOVE export and import/load". I used it and felt it's a great utility to do export/imports on huge amount of data.
-Don
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Richard Fazio Sent: Tuesday, January 31, 2006 3:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 V8 LOAD RESUME Utility [...]
9342 72 29_Re: DMS tablespace size error9_Mo, Don D12_donmo@BU.EDU31_Tue, 31 Jan 2006 16:46:33 -0500643_US-ASCII What's the PP size of your raw devices?
-Don
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of lan Sent: Tuesday, January 31, 2006 4:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DMS tablespace size error
I tried to restore DB2 UDB two databases into two different instances on AIX server. the raw devices size of rShortSpace0 and rShortSpace1 on the two instances are the same. # lsvg -l datavg datavg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT db2templv jfs 52 52 1 open/syncd /db2temp loglv00 jfslog 1 1 1 open/syncd N/A RegSpace0 jfs 12 12 [...]
9415 280 39_bmc tools install question- db2 z/os v712_HEPP SHERY C17_schepp@SRPNET.COM31_Tue, 31 Jan 2006 16:28:13 -0700672_us-ascii Greetings: I have a general question regarding how different shops set up their db2 tools (specifically BMC).
Background:
For a long time we have owned BMC's recover plus and change accum. A few years ago we also purchased change manager from BMC. More recently we purchased catalog manager and apptune.
Since we had various sys progs installing the products we now have 3 BMC production loadlibs. It recently bit us because we were trying to use a component of recover plus via change manager, and the member didn't exist in the change manager loadlib and the recover plus loadlib wasn't [...]