1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l November 2009, week 5 2 148 53_Re: DB2 for z/OS Version 8 - lost DSNTIDxx parameters0_17_jtonchick@AOL.COM31_Sat, 28 Nov 2009 21:17:40 -0500569_us-ascii

You always have the default member that is in your SMP target library, SDSNSAMP. If you have a monitor like Mainview, Omegamon, Insight or TMON, these monitors can display the settings from the compiled modules in SDSNEXIT. A lot of other OEM software can also list these values.

In the instance that you do not have any product that can easily display these members, you can always dump the zparm module to get the hex values and offsets and match it to the macros that make up the module. I've done this. It's not easy, but it does work. [...] 151 303 22_Re: Space issue in DB20_24_hhuang@DCCSH.ICBC.COM.CN31_Mon, 30 Nov 2009 10:55:30 +0800351_GB2312 Srinivas G,

For a 8G table in ORACLE, the space allocation parameter PRIQTY 3600 and SECQTY 1800 is too small for DB2. And I just wonder, you mean 28 3390-9 volumes are used up, or the vsam data set across 28 volumes? It's big difference. I believe there must be some difference in your DDL or related stuff between DB2 and ORACLE. [...] 455 28 46_Re: Allowed to have V9 Trigger using XMLPARSE?11_Paul Bartak18_pbartak@US.IBM.COM31_Mon, 30 Nov 2009 03:55:18 +0000788_utf-8 Check out this posting on the DeveloperWorks Exchange site: http://www.ibm.com/developerworks/exchange/dw_entryView.jspa? externalID=711&categoryID=52

This sample uses a trigger (with XMLPARSE) for an XML column. You likely can modify it to meet your requirements.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.IDUG.org membership is now free. Do you have people in your office who are not an IDUG member? Show them how to access the information and help train the next generation of DB2 Users! _____________________________________________________________________ [...] 484 43 43_Question on OPTIM tool for DB2 data masking23_Parvathavardhini Kannan21_pkannan@INAUTIX.CO.IN31_Mon, 30 Nov 2009 19:35:39 +0530337_US-ASCII Hi all,

We are using OPTIM tool for data masking / de-identification of sensitive customer data. Have any of you used this tool for de-identification of customer name, address etc in DB2 tables in test environment ?

I have a few questions on this tool, like can this tool take care of referential integrity ? [...] 528 46 21_IDENTITY COLUMN ISSUE25_SUBSCRIB DB2-L sumanthdb220_sumanthdb2@GMAIL.COM31_Mon, 30 Nov 2009 15:49:59 +0000311_UTF-8 Hi ,

In our environment DB2 V8 CM z/os, we have a table having identity column defined as GENERATED BY DEFAULT. Also, it is the primary key and Unique index is defined on this identity column alone..whenever i am trying into insert a row without specifying the value for the identity coulmn.. [...] 575 339 65_Re: ICF Catalog how to Split into Sub-Systems per IBM Recommended16_Robert Catterall21_rfcatterall@GMAIL.COM31_Mon, 30 Nov 2009 11:21:35 -0500544_ISO-8859-1 Hello, Anil -- sorry about the delayed response.

It may be that you've been asked to put the BSDS and active log data sets in a separate ICF catalog so as to enable your organization to utilize the BACKUP SYSTEM and RESTORE SYSTEM utilities that were introduced with DB2 for z/OS V8. I wrote a blog entry on BACKUP SYSTEM and RESTORE SYSTEM a few weeks ago, and near the end of that entry I provided an outline of the process by which you'd move the BSDS and active log data sets to a separate ICF catalog. Here's a link [...] 915 182 34_Odp: [DB2-L] IDENTITY COLUMN ISSUE17_Mariusz Stakowski27_Mariusz.Stakowski@ASSECO.PL31_Mon, 30 Nov 2009 17:28:00 +0100313_US-ASCII Helllo,

You have not defined the identity column value, so DB2 does it. However the record (identified by x'00000c6f10') with that value already exists in your table. You have to try to modify the definition of your column by changing the START WITH value, or get rid of the existing record. [...] 1098 51 25_Re: IDENTITY COLUMN ISSUE14_Leblanc, Fritz27_fritz.leblanc@SALLIEMAE.COM31_Mon, 30 Nov 2009 11:57:50 -0500578_utf-8 Hi Sumanth.

Is the table in production or test/development? Has all previous data been inserted, or was some of the data loaded via a utility? If some of the data may have been loaded, I would check the values in SYSIBM.SYSSEQUENCES for columns start, increment, and possible minvalue and maxvalue. You may need to determine the maximum current value in the table containing the identity column and alter the identity column with a new "start with" value that is higher than the highest existing value (assuming that the increment value is greater than zero). [...] 1150 77 25_Re: IDENTITY COLUMN ISSUE14_Peter Vanroose17_pvanroose@ABIS.BE31_Mon, 30 Nov 2009 17:55:08 +0000340_UTF-8 Sumanth,

My impression is that the start value of the identity column is wrong, or better said, its default (1) is not what you want when you add the "identity, generated by default" property to an existing column (with existing data). Be sure to set the START value to (at least) 1 more than the highest occurring value. [...] 1228 118 25_Re: IDENTITY COLUMN ISSUE13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Mon, 30 Nov 2009 13:14:37 -0500398_utf-8 Hello Sumanth,

Do you know why the column has the GENERATED BY DEFAULT attribute? Do you know how the key value is handled? e.g., does the application ever insert a value for this column or is it always generated? Do you run the LOAD utility against the table? Are you or your DBAs in the practice of dropping/recreating/LOADing the table - to accomplish table structure changes? [...] 1347 222 53_Approximate "break-even" when using Rowset processing13_Joehlin, Gary26_Gary.Joehlin@SALLIEMAE.COM31_Mon, 30 Nov 2009 16:22:04 -0500490_us-ascii Hello Listers:



Has anyone derived an approximate break-even point, rule of thumb, when considering coding options: a regular cursor (open - fetch loop) and using Rowset processing in a regular batch (read COBOL) program that is not a stored procedure?

I'm sure that there is a 'price' to pay for setting up and calling DB2 using ROWSET processing. But, where (within a range) would that be a better pay off against a regular cursor and fetch-loop logic? [...] 1570 89 14_SQLCODE = -43812_Ayalew Kassa20_ayalakassa@YAHOO.COM31_Mon, 30 Nov 2009 14:45:28 -0800347_iso-8859-1 I am trying to drop a view that is referenced in an MQT. When I try to drop the view using a CA tool (RC migrator) , I am getting the following error message

DROP VIEW Z1CI001$.CI_DT_LBL_V; DSNT408I SQLCODE = -438, SQLSTATE = 00000, UNQUALIFIED SUCCESSFUL COMPLETION FROM ? TOKENS PTABDBS: PTLBDBC subtask has abended: S04E [...]