1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l July 2009, week 3
2 338 56_DV2 V8: Disable logging for duration of Batch Purge Job.12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Tue, 14 Jul 2009 21:08:32 -0400363_us-ascii All,
I have requirements to purge a large amount of data from db2 tables.
I want to follow these steps,
1. Unload/Backup the targeted tables. 2. Disable logging to the targeted tables 3. Execute Batch IMS/DB2 Purge job. ( I know another story) 4. If job execute successful, reactivate DB2 logging to the recently purged tables. [...]
341 71 29_Re: Monitors for DB2 on z/OS.12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Tue, 14 Jul 2009 21:25:36 -0400574_us-ascii Carol,
BMC's Mainview for DB2 is my choice.
ZiiP eligible collection process, 50% reduction possible.
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of carol.sutfin@REGIONS.COM Sent: Monday, July 13, 2009 2:47 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Monitors for DB2 on z/OS.
It's time again for us to review our Mainframe tools I have been asked to look at replacements for Omegamon for DB2 Yes, I still have it, in all of it's splendid glory, Classic interface even. [...]
413 72 30_Re: Joins / Predicate location15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Tue, 14 Jul 2009 22:29:47 -0400623_iso-8859-1 If you want to filter the left table then you need to move the ON CLAUSE predicate up into a table expression and the result of that will be processed by predicates at the ON CLAUSE level.
Troy Coleman CA Principal Product Manager Tel: +1-630-505-6025 Mobile: +1-224-343-0073 Troy.Coleman@ca.com
Blog: http://ibmsystemsmag.blogs.com/db2utor/
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ian Bjorhovde Sent: Monday, July 06, 2009 10:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Joins / Predicate location [...]
486 75 29_Re: Monitors for DB2 on z/OS.15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Tue, 14 Jul 2009 23:14:01 -0400442_iso-8859-1 Hi Carol, I started out using INSIGHT back in the late 80's and have always thought of it as one of the best DB2 performance monitoring tools on the market. It has changed hands a few times and now is owned by CA. It has a lot of cool features but one that I've always liked is the IQL language. You can customize the on-line panels and the same member used to display that online panel can be used to generate batch reports. [...]
562 391 54_Re: db2v9 z/OS: Stored Procedure examples (Java, C++)?16_Robert Catterall21_rfcatterall@GMAIL.COM31_Tue, 14 Jul 2009 23:20:18 -0400730_ISO-8859-1 Phil,
The DB2 9 for z/OS Application Programming and SQL Guide ( http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_apsg.htm) contains a lot of references to C++. The support is there.
Robert
On Tue, Jul 14, 2009 at 1:05 PM, Sevetson, Phil wrote:
> Wait. > Crap. > I got C++ up and running, but DB2V9 appears only to support C, not C++. > Am I right? > > --Phil Sevetson > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Mike Bell > Sent: Tuesday, July 14, 2009 12:28 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] db2v9 z/OS: Stored [...]
954 214 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.0_17_jtonchick@AOL.COM31_Wed, 15 Jul 2009 01:40:22 -0400510_us-ascii I've never heard that DB2 for z/OS allows you to "turn off" logging.? Several utilities have a LOG NO option, but not application programs.
You might want to try this sequence:
1. Use DSNTIAUL or the DB2 UNLOAD utility to unload the data from the target tables.? You can use SQL to select only the rows you want to retain. 2. Use LOAD REPLACE LOG NO COPYDDN STATISTICS?to reload the smaller set of data.? This also take an in-line image copy and performs RUNSTATS at the same time. [...]
1169 161 29_Re: Monitors for DB2 on z/OS.0_17_jtonchick@AOL.COM31_Wed, 15 Jul 2009 01:56:14 -0400602_utf-8 Carol, DB2 for z/OS you have several choices in real-time monitors. BMC Mainview for DB2, CA-Insight for DB2 and TMON-DB2 are all competitors to Omegamon for DB2. TMON is usually the least expensive. Mainview, TMON & Omegamon offer additional benefits if you also have other monitors from the same company such as the ability to cross from DB2 to other monitors, like CICS or IMS following the same unit of work. I've seen applications get into cross database deadlocks with both DB2 & IMS data. CA-Insight by itself cannot do this, but it does have a more "user friendly" interface. [...]
1331 34 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Wed, 15 Jul 2009 06:20:43 +0000355_utf-8 Kevin, in V9 there is functionality to allow turning logging off at individual tablespace level - the LOGGED / NOT LOGGED parameter of CREATE and ALTER tablespace.
Have you considered using a REORG with the DISCARD option? That way you can achieve your "purge" in a controlled way and, if you need to, keep a copy of the discarded data. [...]
1366 120 35_Re: COBOL stored procs & Batch jobs14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 15 Jul 2009 21:05:31 +1000685_US-ASCII Do either of these help
http://www-01.ibm.com/support/docview.wss?uid=isg1II13698 http://www-01.ibm.com/support/docview.wss?uid=swg1PK45599 - this gives the new, improved, names for the stored procedures
James Campbell
On 14 Jul 2009 at 10:07, michael.j.lynch@US.HSBC.COM wrote:
> > > Robert, > > Sure can. > > The client side is a legacy powerbuilder app calling COBOL/DB2 stored procs through a DB2 > connect server. The client doesn't connect directly to CICS. We have a CICS started task that > kicks off every 15 seconds in our CICS region that checks for the existence of a row in a table. If > that row is present, we write JCL [...]
1487 60 54_Re: db2v9 z/OS: Stored Procedure examples (Java, C++)?14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 15 Jul 2009 21:05:31 +1000455_ISO-8859-1 For SP code, might I suggest implementing DB2 LUW Express, and looking in the created /SQLLIB/samples/ subdirectories: java/sqlj/SpServer.sqlj java/jdbc/SpServer.java cpp/spserver.sqx
The associated spcreate.db2 files have the create procedure sql FOR LUW.
Together these might (I haven't used them) indicate some coding techniques.
No idea about debugging.
DB2 V9.1 z/OS Appl Prog & SQL Guide talks about C++. [...]
1548 91 31_Subquery problem z/os 1.7 db2v80_21_BudGreenman@ONGOV.NET31_Wed, 15 Jul 2009 08:09:34 -0400630_US-ASCII I wrote an insert statement that uses a subquery to get the inserted values. When I run it in spufi it is successful, but when I tried to compile a program with it the bind comes back with a -412 . the statement is;
EXEC SQL INSERT INTO DTDELTAX.DELINQUENCIES (PROPID,TXYEAR,SEQNO,OLD_PRTKEY,OWNER, UNPAID_AMT,TAX_SALE,PARTIAL_PAYMENT, MTIMESTAMP,DIP_FLAG,CERTIFICATE,CERT_DATE, DISC,TOWN,APPORT) VALUES (SELECT :NWSPRP,TXYEAR,SEQNO,OLD_PRTKEY, OWNER,UNPAID_AMT,TAX_SALE,PARTIAL_PAYMENT, CURRENT_TIMESTAMP,DIP_FLAG,CERTIFICATE, CERT_DATE,DISC,TOWN,APPORT FROM DTDELTAX.DELINQUENCIES WHERE PROPID = :ODSWPRP); [...]
1640 51 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Wed, 15 Jul 2009 08:39:11 -0400526_UTF-8 Adam has a very good point - using the DISCARD option of reorg as opposed to turning off logging for the tablespaces. If you want to see some of the "dark sides" of using NOT LOGGED tablespaces, I did a presentation at IDUG this year, so you can get the presentation from the IDUG web site. The challenge is - if your application gets into a situation where DB2 needs to backout / rollback - since you don't get REDO and UNDO records, you might end up in a scenario where you have to either RECOVER to a prior full [...]
1692 194 35_Re: Subquery problem z/os 1.7 db2v80_33_armando.jorge.arranja@BANCOBPI.PT31_Wed, 15 Jul 2009 14:15:48 +0100705_utf-8
AVISO DE CONFIDENCIALIDADE
Esta mensagem e quaisquer ficheiros anexos a ela são confidenciais e destinam-se a uso exclusivo da pessoa ou entidade a quem são dirigidos. Se não é o destinatário da mensagem ou a pessoa responsável pelo seu encaminhamento ao respectivo destinatário, fica informado de que recebeu esta mensagem por engano, e de que qualquer utilização, distribuição, reencaminhamento ou outra forma de revelação a outrem, impressão, ou cópia desta mensagem é expressamente proibida. Se recebeu esta mensagem por engano deverá destrui-la, eliminá-la do sistema, e informar o remetente ou o Banco BPI,SA. O Banco BPI, SA utiliza software anti-virus. [...]
1887 77 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Wed, 15 Jul 2009 09:21:50 -0400354_us-ascii Adam,
Yes. Logging overhead for this once a year purge that will reduced the large tables by 28%.
We also use a Software VTS solution that is CPU intensive processing the virtual 3490 to 3590. I am looking into native 3590 processing.
We are weeks away from V9 in that subsystems so I am looking into your suggestions. [...]
1965 263 35_Re: Subquery problem z/os 1.7 db2v80_21_BudGreenman@ONGOV.NET31_Wed, 15 Jul 2009 09:29:37 -0400504_ISO-8859-1 Thanks. Of course that did it. I am not sure why I put that in in the first place, possibly because I was getting other errors when using an older compiler that needed a precompiler step.
Bud Greenman Applications Programming Manager
From: armando.jorge.arranja@BANCOBPI.PT To: DB2-L@WWW.IDUGDB2-L.ORG Date: 07/15/2009 09:18 AM Subject: Re: [DB2-L] Subquery problem z/os 1.7 db2v8 Sent by: DB2 Data Base Discussion List [...]
2229 51 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.15_Coleman, Troy L19_Troy.Coleman@CA.COM31_Wed, 15 Jul 2009 09:40:01 -0400561_UTF-8 In my consulting days I've setup purge processing at some companies just as Adam has pointed out below. Depending on what inter-application needs are the purge criteria can change over time. These changes are easy without having to write code, however, I've seen mistakes where one team decided to purge some production data not realizing another part of the business needs that data. Having the purged "DISCARD" data in a file that can be loaded into a separate history table is a nice way of being able to get that data back if a mistake was made. [...]
2281 591 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Wed, 15 Jul 2009 08:58:25 -0500350_us-ascii Jim, Not logged tablespace has been introduced in DB2 V9 where you can turn on/off logging at will.
ALTER TABLESPACE DB.TS LOGGED/NOT LOGGED (not to be confused with LOG YES/NO option earlier versions which was tied to LOBs)
What confuses me is that Kevin says that he is on V8... where the above switch is not available. [...]
2873 237 67_[AD] Seafood Lovers: DB2 Connect Tuning and SQL Replication Classes12_Kimberly May28_kim.may@THEFILLMOREGROUP.COM31_Wed, 15 Jul 2009 10:26:01 -0400430_US-ASCII The Fillmore Group is scheduled to deliver the IBM DB2 Connect tuning course starting August 10th. This course runs infrequently and unfortunately, since it is an IBM class I cannot offer a price discount as an incentive to join us.
I CAN, however, offer to treat students to a Baltimore summer seafood dinner. Crabs, Chincoteague oysters, sweet corn.my treat. Details on the class are below. [...]
3111 112 21_Re: Off Topic - Wipro11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Wed, 15 Jul 2009 11:15:09 -0400342_us-ascii We too have used WiPro for our application development staff. I don't know any details like Cathy regarding the company's philosophies.
However we were just informed our company has decided to utilize Wipro across the board and that we would all be replaced with a Wipro person.
I was the sole DB2 DBA in my shop. [...]
3224 115 21_Re: Off Topic - Wipro13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Wed, 15 Jul 2009 08:55:57 -0700354_us-ascii Ouch...sorry to hear that, Brian. I once joked around with one of our Wipro contractors that my job was safe because I am a systems programmer. He replied that Wipro has systems programmers. I've never seen one, but if their marketing people can convince my management that they have systems programmers, then I guess nobody's job is safe. [...]
3340 699 54_Re: db2v9 z/OS: Stored Procedure examples (Java, C++)?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Wed, 15 Jul 2009 12:22:47 -0400519_us-ascii My apologies, Robert: I was imprecise. DB2 Stored Procedure programming is available only for C. Calling DB2 from C++; good. Calling C++ from DB2 z.OS SP: not available.
--Phil Sevetson
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Catterall Sent: Tuesday, July 14, 2009 11:20 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2v9 z/OS: Stored Procedure examples (Java, C++)? [...]
4040 242 34_Re: DSN1COPY from DB2 v8 to DB2 v914_Tommy Petersen30_tommy_petersen@NEWYORKLIFE.COM31_Wed, 15 Jul 2009 17:05:05 +0000457_utf-8 Quite interesting.
We have a much larger problem, as we have up to 7 years of image copies from various versions of DB2 which we may need to restore and produce reports from for legal or regulatory reasons.
We do this by saving the DDL and the PSIDs and OBIDs. When we need the old data we create a database with the tables and tablespaces from the old backups then use DSN1COPY to restore the data and convert the PSIDs and OBIDs. [...]
4283 999 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Wed, 15 Jul 2009 14:18:42 -0400482_us-ascii This is a significant enough feature to perhaps wait for DB2 V9 which has been staged for production next month. We have not done this purge in over 2 years, another month won't impact us.
Kevin -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Tonmoy Dasgupta Sent: Wednesday, July 15, 2009 9:58 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DV2 V8: Disable logging for duration of Batch Purge Job. [...]
5283 528 30_Re: DB2 Connect error CLI0002W18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Wed, 15 Jul 2009 16:58:52 -0700507_us-ascii Hi Jeff,
Thank you for the suggestion. But, unfortunately we are still having the problem.
One most important information that I forgot to mention is that we are in DB2 V8 on z/OS. We are using DB2CONNECT server V9.7 and DB2CONNECT client V9.7.
Thanks, Satish
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Jeff Frazier Sent: Tuesday, July 14, 2009 12:49 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2 Connect error CLI0002W [...]
5812 84 54_z/OS v9 - JDBC Type 4 connections and Trusted Contexts0_33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Thu, 16 Jul 2009 13:15:04 +1000518_ISO-8859-1 Hi All,
I trying for the longest post in history award, hopefully you guys don't fall asleep before you get to the end.
I have created the following set of trusted contexts for development and more sets for test, UAT and PROD
CREATE TRUSTED CONTEXT USERD1 BASED UPON CONNECTION USING SYSTEM AUTHID USERD1 DEFAULT ROLE USERD1_ROLE ENABLE ATTRIBUTES (ADDRESS 'dev01was.gov.au', ADDRESS 'dev02was.gov.au', ADDRESS 'dev03was.gov.au', ENCRYPTION 'HIGH' ) WITH USE FOR USERD1; . . . . . [...]
5897 32 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.12_Adam Baldwin22_adambaldwin@ES.IBM.COM31_Thu, 16 Jul 2009 06:32:31 +0000299_utf-8 Kevin, I would - as others have stressed - be wary of switching off logging to achieve the purge. The discard option of reorg allows you to be very specific about what you want to purge, it gives you a ready made back up of the data, and you get to reorg the tablespace at the same time. [...]
5930 267 34_Re: DSN1COPY from DB2 v8 to DB2 v913_McDonald, Ken20_Ken_McDonald@BMC.COM31_Thu, 16 Jul 2009 08:43:44 -0500432_us-ascii Hi Tommy,
The row format is actually stored in the header page of each partition.
So, by querying the copy, we know if it is in BRF even though the new table is in RRF.
You can use BMC's RECOVER PLUS with INCOPY syntax along with the OBIDXLAT (instead of DSN1COPY) and it will properly reset the catalog and directory to indicate that the recovered space is in BRF (or vice versa). [...]
6198 29 12_SQLCODE -49717_Darren Kilpatrick31_darren.kilpatrick@WELLPOINT.COM31_Thu, 16 Jul 2009 14:40:08 +0000401_utf-8 We are running a Cobol program on DB2 9 NFM for z/OS and we are getting a -497 return code, the maximum limit od internal identifiers has been exceeded. Is there any more info on this error message? It is running Selects, Inserts, and Updates, and gets 1 lock escalation. They do use an Insesitive Scrollable cursor with no delcared temp tables in the program. Anything else I can look at? [...]
6228 60 8_DSNTIAUL28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Thu, 16 Jul 2009 20:13:19 +0530450_US-ASCII Hello All:
I am just wondering if the DSNTIAUL prepared out of DB2 v7 libraries, would work fine on a DB2 v8 system (provided, I bind on the v8 system with the v7's DBRM). Has anyone experienced or tried it ?
Appreciate the responses. Thanks.
Regards, Bala.
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
6289 86 16_Re: SQLCODE -49714_Galeos Antonis19_AGaleos@EUROBANK.GR31_Thu, 16 Jul 2009 17:47:48 +0300645_us-ascii From DB2 UDB for z/OS V8 Codes manual
-497 THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE database-name
Explanation: The SQL statement cannot be executed because an internal identifier limit has been exceeded for the database. The cause of this error is due to one of the following: On a CREATE DATABASE statement, the limit of 65279 DBIDs has been exceeded. | For all other statements, the limit of 32767 OBIDs has been exceeded | for that database. System Action: The SQL statement cannot be executed. Programmer Response: Take the appropriate action as described in the following [...]
6376 249 12_Re: DSNTIAUL14_Stevens, Wayne29_Wayne.Stevens@DHR.ALABAMA.GOV31_Thu, 16 Jul 2009 10:07:46 -0500680_US-ASCII It works fine with or without the bind as long as the v7 and v8 are in different libraries.
Wayne Stevens
Wayne.Stevens@dhr.alabama.gov
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Balachandran Chandrasekaran1 Sent: Thursday, July 16, 2009 9:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: DSNTIAUL
Hello All:
I am just wondering if the DSNTIAUL prepared out of DB2 v7 libraries, would work fine on a DB2 v8 system (provided, I bind on the v8 system with the v7's DBRM). Has anyone experienced or tried it ? [...]
6626 315 12_Re: DSNTIAUL9_Chris Tee23_Chris.Tee@SENTENIAL.COM31_Thu, 16 Jul 2009 16:10:10 +0100330_us-ascii Bala
Yes it works, in fact you have to run V7 DSNTIAUL in V8 CM as the V8 version uses multirow fetch which is V8 NFM functionality. Also, if you are using DSNTIAUL to unload data from a remote V7/ V8 CM subsystem, then you will need to keep a V7 version of DSNTIAUL on your V8 NFM subsystem. [...]
6942 56 12_Re: DSNTIAUL9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Jul 2009 10:13:52 -0500335_US-ASCII that's what I do - actually I bind the old DSNTIAD, DSNTEP2 and DSNTIAUL - sometimes even spufi so I don't have to change logon procs to work with a new subsystem. If you are migrating the subsystem from an existing v7, it may still be there. The normal migration clist doesn't generate drops for the old plans/packages. [...]
6999 214 12_Re: DSNTIAUL28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Thu, 16 Jul 2009 20:55:29 +0530757_US-ASCII Thanks to the replies. I certainly assumed it. Still, it is assuring to hear from you all.
Regards, Bala.
Mike Bell Sent by: DB2 Data Base Discussion List 16/07/2009 20:43 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] DSNTIAUL
that's what I do - actually I bind the old DSNTIAD, DSNTEP2 and DSNTIAUL - sometimes even spufi so I don't have to change logon procs to work with a new subsystem. If you are migrating the subsystem from an existing v7, it may still be there. The normal migration clist [...]
7214 307 12_Re: DSNTIAUL28_Balachandran Chandrasekaran119_balaccha@IN.IBM.COM31_Thu, 16 Jul 2009 21:03:46 +0530596_US-ASCII Please read that as : "Thanks for the replies". I was just too fast to end my day.
Cheers, Bala.
Balachandran Chandrasekaran1/India/IBM@IBMIN Sent by: DB2 Data Base Discussion List 16/07/2009 20:55 Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] DSNTIAUL
Thanks to the replies. I certainly assumed it. Still, it is assuring to hear from you all. [...]
7522 529 12_Re: DSNTIAUL15_Tonmoy Dasgupta28_tonmoy.dasgupta@ARKANSAS.GOV31_Thu, 16 Jul 2009 10:36:42 -0500360_us-ascii When I migrate, I avoid the version imprint on the plan name for DSNTIAUL which is DSNTIB. As part of the migration I bind the plan name as DSNTIAUL also (as this helps in avoiding making changes in the existing DSNTIAUL jobs....
This the following never needs to be changed and folks are automatically switched onto the new DSNTIAUL. [...]
8052 306 61_Speculation on Information On Demand Conference Entertainment22_Frank C. Fillmore, Jr.19_tfgpublic@GMAIL.COM31_Thu, 16 Jul 2009 14:27:08 -0400614_us-ascii In a bit of whimsy, I posted my guess as to the entertainment that will be at the IOD conference this year.
http://www.thefillmoregroup.com/blog/?p=188
Looking for your feedback.
All the best,
Frank
+-------------------------------------+------------------------------------- --------+
| Frank C. Fillmore, Jr. | Office: 410.465.6335 Mobile: 410.963.0416 |
| The Fillmore Group, Inc. (TFG) | Facsimile: 888.828.4717 |
| 8501 LaSalle Road; Suite 318 | IBM Training: 800-TFG-RDBMs (800.834.7326) | [...]
8359 383 65_Re: Speculation on Information On Demand Conference Entertainment10_Roger Hecq18_Roger.Hecq@UBS.COM31_Thu, 16 Jul 2009 14:36:30 -0400382_us-ascii Visit our website at http://www.ubs.com
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. [...]
8743 361 65_Re: Speculation on Information On Demand Conference Entertainment17_Janes, Ray {PBSG}18_ray.janes@PBSG.COM31_Thu, 16 Jul 2009 13:40:12 -0500374_us-ascii I attempted to post a rebuttal. It is Kukla, Fran and OLLIE. Or maybe you meant Willie F? http://kukla.tv/
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Frank C. Fillmore, Jr. Sent: Thursday, July 16, 2009 1:27 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Speculation on Information On Demand Conference Entertainment [...]
9105 545 65_Re: Speculation on Information On Demand Conference Entertainment23_Joel Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Thu, 16 Jul 2009 14:50:13 -0400526_iso-8859-1 Yes, but Ollie wasn't happy, left the group and went out on his own...
Laurel & Hardy?
Jimmie Durante?
Joel Goldstein Responsive Systems IBM Gold Consultant Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts IO Rate !! Predicts Group Buffer Pool performance too www.responsivesystems.com
Buffer Pool Tool for DB2 on www.LinkedIn.com Watch the 3-Minute Buffer Pool Tool Movie at: www.responsivesystems.com/Movie1 [...]
9651 77 65_Re: Speculation on Information On Demand Conference Entertainment7_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 16 Jul 2009 12:18:53 -0700625_utf-8 - yes I was an anarchist at 5 -
"Pluck your magic Or my favorite: - yes I was an anarchist at 5 - "Pluck your magic twanger, Froggy"! Froggy had to be the most malevolent TV character until House or Sipowicz. Perhaps Steve Mills could appear in a cloud of smoke, after Larry Ellison says the above words, to announce IBM is purchasing Oracle! Edward Long --- On Thu, 7/16/09, Janes, Ray {PBSG} wrote: > From: Janes, Ray {PBSG} > Subject: Re: [DB2-L] Speculation on Information On Demand Conference Entertainment > To: DB2-L@WWW.IDUGDB2-L.ORG > Date: Thursday, July [...]
9729 120 65_Re: Speculation on Information On Demand Conference Entertainment0_24_carol.sutfin@REGIONS.COM31_Thu, 16 Jul 2009 14:19:52 -0500541_UTF-8 I think Frank was referring to Willie F. instead of Ollie
Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com
Joel Responsive Systems DB2-L@WWW.IDUGDB2-L.ORG Sent by: DB2 Data cc Base Discussion List Subject Information On Demand Conference Entertainment
07/16/2009 01:50 PM
Please respond to DB2 Database Discussion list at IDUG [...]
9850 100 32_UDF Standards and Best Practices12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Thu, 16 Jul 2009 15:18:38 -0500426_US-ASCII We are exploring some opportunities for UDF's on z/OS v8 NFM, so we have WLM definitions in goal mode etc..
The first UDF in development is a simple scalar function, but I am having trouble deciding on naming standards and definition/usage standards.
I have some notes from a class I took years ago on performance issues such as searching the path, use of FENCED, DETERMINISTIC, STAY RESIDENT etc. [...]
9951 78 34_Re: DSN1COPY from DB2 v8 to DB2 v911_Rob Barbour22_rbarbour@ESAIGROUP.COM31_Thu, 16 Jul 2009 17:30:02 -0400307_ISO-8859-1 Hi Tommy,
Regarding your DSN1COPY issue, the BCV5 product will work and handles the simple to segmented issue. The BCV5 capability is called ICEBOX which can help you with your version issue and DSN1COPY.
See web page for more info http://www.esaigroup.com/products/bcv5.htm
10030 85 16_New DB2 DDF user15_Frank Swarbrick30_frank.swarbrick@EFIRSTBANK.COM31_Thu, 16 Jul 2009 16:25:17 -0600316_utf-8 DB2 9.1 for z/OS. Trying to start DDF for the first time so we can communicate with a remote database. We're getting this:
DSNL004I - DDF START COMPLETE 896 LOCATION ZOSD LU .LU1 GENERICLU -NONE DOMAIN -NONE TCPPORT 446 SECPORT 448 RESPORT 450 IPNAME -NONE DSNL007I - DDF IS ABNORMALLY TERMINATING [...]
10116 115 20_Re: New DB2 DDF user9_Mike Bell21_mbell11a1@VERIZON.NET31_Thu, 16 Jul 2009 17:49:01 -0500469_us-ascii what do you show when you do a -dis ddf? You have to specify either a luname or ipadress in the BSDS step of DSNTIJUZ so DB2 knows who the subsystem is. DSNL080I -db2 subsys name DSNLTDDF DISPLAY DDF REPORT FOLLOWS:
DSNL081I STATUS=STARTD DSNL082I LOCATION LUNAME GENERICLU DSNL083I locname from UZ -NONE -NONE DSNL084I TCPPORT=xxx SECPORT=xxx RESPORT=xxx IPNAME=ipname of the local mvs DSNL085I IPADDR=:xxx.xxx.xxx.xxx the local ip address of mvs [...]
10232 70 60_Re: DV2 V8: Disable logging for duration of Batch Purge Job.12_Clark, Kevin22_Kevin.Clark@BCBSDE.COM31_Fri, 17 Jul 2009 10:37:57 -0400416_us-ascii Adam and LIST;
Thanks for the words of caution.
I was leaning towards this option and leaving logging on.
Kevin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Adam Baldwin Sent: Thursday, July 16, 2009 2:33 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DV2 V8: Disable logging for duration of Batch Purge Job. [...]
10303 979 54_Re: db2v9 z/OS: Stored Procedure examples (Java, C++)?14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Fri, 17 Jul 2009 10:11:34 -0400466_us-ascii Yeah, I had it wrong. Someone here corrected me, too. I was jumping to conclusions based on the Redbook not explicitly mentioning C++.
--Phil Sevetson
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Robert Catterall Sent: Friday, July 17, 2009 1:24 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] db2v9 z/OS: Stored Procedure examples (Java, C++)? [...]
11283 73 36_Re: UDF Standards and Best Practices10_Dave Churn19_davechurn@GMAIL.COM31_Fri, 17 Jul 2009 07:45:40 -0500418_ISO-8859-1 Mark and Listers,
Our z/OS (DB2 9) UDFs are written in COBOL.
They are all called by triggers and perform NOT DETERMINISTIC functions.
To get the fastest performance, we use PROGRAM TYPE SUB and STAY RESIDENT YES. We save time on loading the program into WLM storage and program start tasks (in the operating system). All UDFs reinitialize their working-storage before processing. [...]
11357 78 38_Re: DB2 for z/OS to Other Databases...12_Peter Suhner24_peter_suhner@HOTMAIL.COM31_Fri, 17 Jul 2009 19:54:31 +0000449_UTF-8 Hi Cuneyt,
we are using the IBM Replication products between DB2 z/OS, DB2 LUW and Oracle (on Unix). The approach requires certain additional products (which don't come for free - how unexpected!): - DB2 Data Propagator for z/OS (a z/OS port of the DB2 LUW replication feature running in the USS environment) - DB2 Federation with Relational Wrappers on the Unix side (required for interaction with 3rd party products like Oracle) [...]
11436 36 38_Kuhr, Richard L. is out of the office.0_13_RLKUHR@UP.COM31_Fri, 17 Jul 2009 20:04:18 -0500636_US-ASCII I will be out of the office starting 07/17/2009 and will not return until 07/21/2009.
I will respond to your message when I return. If this is an emergency please contact Computer Scheduling.
**
This message and any attachments contain information from Union Pacific which may be confidential and/or privileged. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited by law. If you receive this message in error, please contact the sender immediately and delete the message and any attachments. [...]
11473 48 10_AD2U Abend25_SUBSCRIBE DB2-L Anonymous23_poojamishra48@GMAIL.COM31_Sun, 19 Jul 2009 13:39:56 +0000719_UTF-8 I am getting following error for the transaction FPFI defined in H135Q1VC region.
As per the CMAC description AD2U means: EXPLANATION: An attempt to create a DB2 thread by the TCB servicing the DB2 request failed. The installed DB2CONN specifies THREADERROR(N906D) or THREADERROR(ABEND). SYSTEM ACTION: If THREADERROR(N906D) is specified in the DB2CONN, processing continues. A -906 sqlcode is returned to the application and a transaction [...]
11522 134 14_Re: AD2U Abend12_jim harrison24_jimh_listsub@VERIZON.NET31_Sun, 19 Jul 2009 10:13:15 -0400608_UTF-8 Check the job log on the DB2 side - there should be something there either in MSTR or DIST.
On 7/19/2009 9:39 AM, SUBSCRIBE DB2-L Anonymous wrote: > I am getting following error for the transaction FPFI defined in H135Q1VC > region. > > EDBSHELL at compile unit offset +00001002 at entry offset +00001002 at address > > As per the CMAC description AD2U means: > EXPLANATION: An attempt to create a DB2 thread [...]
11657 117 21_Re: Off Topic - Wipro16_mocion@libero.it16_mocion@LIBERO.IT31_Sun, 19 Jul 2009 20:09:58 +0200657_ISO-8859-1 Cathy,
Nowadays no job can be considered 'safe', expecially in countries where sysprogs speak english. Luckily few sysprogs from other countries speak italian...but who knows ?
Max Scarpa Certified clone of a DB2 sysprog
Taddei, Cathy ha scritto: > Ouch...sorry to hear that, Brian. I once joked around with one of our Wipro contractors that my job was safe because I am a systems programmer. He replied that Wipro has systems programmers. I've never seen one, but if their marketing people can convince my management that they have systems programmers, then I guess nobody's job is safe. > > By [...]
11775 56 26_Expand compressed rows ...6_keyRho16_keyrho@GMAIL.COM31_Mon, 20 Jul 2009 08:11:39 -0400724_ISO-8859-1 Hello lists,
I am looking for some helps, tips who had an experiences how to expand rows which're compressed with an option 'compress yes' from outside of DB2(z/OS) system using macro CSRCMPSC CBLOCK=CMPSC ...
thanks in advance
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG DB2-L FAQ and e-mail settings are located on the IDUG.org Listserv page. If you are not already an IDUG.org member, please register at http://www.idug.org/register _____________________________________________________________________
11832 172 18_Using D-GTT in QMF13_Joehlin, Gary26_Gary.Joehlin@SALLIEMAE.COM31_Mon, 20 Jul 2009 09:02:13 -0400494_us-ascii Hello Listers:
Has anyone had experience in using D-GTT in QMF followed create Index, insert and then a query, in the same input stream?
It seems that only the D-GTT is being defined then the QMF process ends w/o executing the rest of the in-line DDL and DML.
TIA, Gary Joehlin
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
12005 42 35_QMF Workstation (v9.1) Edit in Grid12_Bill Cummins18_brcummin@ILSTU.EDU31_Mon, 20 Jul 2009 14:55:36 +0000369_utf-8 Last week I asked IBM-Mail readers this question, but perhpas this is a better forum.
QMF 8.1 allowed (given DB2 permissions) users to manually edit values in the grid cell by double-clicking and editing.
As we try to move to QMF for Workstation (v9.1 FP 2), one difficulty is that we don't appear to be able to edit values in the result grid. [...]
12048 169 38_Re: DB2 for z/OS to Other Databases...16_Mark Labby - AES21_mlabby@AESSUCCESS.ORG31_Mon, 20 Jul 2009 13:45:32 -0400
12218 99 22_Re: Using D-GTT in QMF10_Dave Nance16_dav1mo@YAHOO.COM31_Mon, 20 Jul 2009 11:49:04 -0700668_iso-8859-1 Gary, Your probably having issues due to commits being issued by QMF. David Nance ________________________________ From: "Joehlin, Gary" To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Monday, July 20, 2009 9:02:13 AM Subject: [DB2-L] Using D-GTT in QMF Hello Listers: Has anyone had experience in using D-GTT in QMF followed create Index, insert and then a query, in the same input stream? It seems that only the D-GTT is being defined then the QMF process ends w/o executing the rest of the in-line DDL and DML. TIA, Gary Joehlin ________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. If you [...]
12318 228 59_IBM DB2 and Cloud Computing: Learning Opportunity/Beta Test14_Sevetson, Phil22_PSevetson@FISA.NYC.GOV31_Mon, 20 Jul 2009 16:14:46 -0400604_us-ascii Has everyone seen the IBM Cloud Computing offering they opened up today? Nothing is being provisioned yet, but we're being told that it's in beta - it's possible to create a virtual system with SUSE Linux running DB2 Express-C on IBM's cloud. Further information here: http://www-949.ibm.com/cloud/developer/dashboard
Registration is free. Looks to me like a good way to learn about IBM Cloud computing and DB2 UDB (for those of us who are still mainframe geeks). (Maybe this should be discussed on the DB2 Express-C Mailing list? But very few are subscribed to it.) [...]
12547 55 30_Re: Expand compressed rows ...9_Mike Bell21_mbell11a1@VERIZON.NET31_Mon, 20 Jul 2009 18:40:50 -0500466_us-ascii I do NOT know of any utility that will apply an arbitrary dictionary to a compressed file and expand it. Usually the program that compressed the file has an uncompress function also since I don't know of many application programs that can read compressed format file.
If you are talking about normal SMS compression that is very different because z/os and SMS keep the dictionary and any program that reads the file gets back uncompressed data. [...]
12603 329 63_Re: IBM DB2 and Cloud Computing: Learning Opportunity/Beta Test16_Gregory Palgrave28_gpalgrave@STAFF.IINET.NET.AU31_Tue, 21 Jul 2009 09:20:05 +0800482_us-ascii Looks interesting, but currently only open to those based in the US:
Today, we're opening the provisioning functionality of the Technology Preview web site to a select group of our US-based customers and partners. Please register, and we'll email you once we are able to offer you access.
If there are any IBM'ers watching - other people would like to play too... [...]
12933 47 45_Mike Dupuis/Ontario/IBM is out of the office.11_Mike Dupuis18_mdupuis@CA.IBM.COM31_Mon, 20 Jul 2009 23:40:45 -0400304_US-ASCII
I will be out of the office starting 07/20/2009 and will not return until 07/21/2009.
I will respond to your message when I return. If this is an urgent matter please call the Heldesk and ask that an IGS DB2 support person be paged. For less urgent matters pls email SLCDB2. [...]
12981 63 41_SDSNEXIT on the LINK list it to small ...11_Nenad Vidak21_Nenad.Vidak@GMAIL.COM31_Tue, 21 Jul 2009 08:48:54 +0000532_UTF-8 Hello, SDSNEXIT load library containing zparm modules, DSNHDECP, DSNHMCID and customized DB2 auth. exits is on the LINK list. It has been allocated to small at DB2 SMP/E installation time and now, from time to time, my zparm update jobs end with:
D37-04,IFG0554P,DB3PINSE,DSNTIZL,SYSLMOD,8B02,DBPR06,DSN910.SDSNEXIT
I can solve this by compressing SDSNEXIT but then I have to refresh LLA on all systems (SDSNEXIT is shared among all SYSTEMS in the sysplex) or our DB2 related (utility) jobs start to abend: [...]
13045 31 65_ALTER ADD COLUMN TYPE DATE, TIMESTAMP , PACKAGE REBIND REQUIRED ?34_SUBSCRIBE DB2-L Tejas V Jadhav_IBM17_tejasvj@GMAIL.COM31_Tue, 21 Jul 2009 09:08:53 +0000462_utf-8 Hi All-
While ALTERING TABLE to add column of type :-> Date , Time or TimeStamp. I need REBIND packages . I am wondering the reason why packages become INVALID after adding column of above mentioned datatype.
Please can someone elaborate on this ?
Thank You , Tejas Jadhav
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU * [...]
13077 92 69_Re: ALTER ADD COLUMN TYPE DATE, TIMESTAMP , PACKAGE REBIND REQUIRED ?14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Tue, 21 Jul 2009 12:34:26 +0300345_us-ascii From DB2 UDB for z/OS V8 SQL Reference
Invalidation of plans and packages: When a table is altered, all the | plans, packages, and dynamic cached statements that refer to the table are invalidated if any one of the following conditions is true:
| The table is a created temporary table or a materialized query table. [...]
13170 88 86_Antwort: Re: [DB2-L] ALTER ADD COLUMN TYPE DATE, TIMESTAMP , PACKAGE REBIND REQUIRED ?11_Roy Boxwell16_R.Boxwell@SEG.DE31_Tue, 21 Jul 2009 11:46:17 +0200376_ISO-8859-1 nice cut and paste job however I think he wants to know why date and times have this affect! I really do not know but my guess is it is to do with Formats (EUR, ISO, JIS and LOCAL) as I say - I do not know but it seems to make a little bit of sense that the package must "know" the format of the output data - it can only do this if it is rebound (I think...) [...]
13259 257 45_Re: SDSNEXIT on the LINK list it to small ...12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 21 Jul 2009 07:00:38 -0500462_US-ASCII Nenad, Sounds like you need a SDSNEXIT.NEW with bigger allocation on the same volume and then from another LPar you can bring that volume online and rename SDSNEXIT to SDSNEXIT.OLD and .NEW to SDSNEXIT.
However, to answer your question... If you have changed a dynamic ZParm you can refresh all your DB2's with /-SSID SET SYSPARM RELOAD and optionally () Otherwise you really need to bounce DB2 to get the new ZParms picked up. [...]
13517 239 45_Re: SDSNEXIT on the LINK list it to small ...12_Mark Vickers26_MarkVickers@GROCERYBIZ.COM31_Tue, 21 Jul 2009 07:03:20 -0500375_US-ASCII Nenad, retraction - I missed the SYSPLEX part, so the rename is not going to work unless you get to an LPar where it is not enqued.
Nenad Vidak Sent by: DB2 Data Base Discussion List 07/21/2009 03:52 AM Please respond to DB2 Database Discussion list at IDUG [...]
13757 80 45_Re: SDSNEXIT on the LINK list it to small ...15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Tue, 21 Jul 2009 08:22:56 -0400362_utf-8 You could work with your MVS Sys Prog and setup an individual CSVLLAxx member so that only the library where your SDSNEXIT lives is refreshed. The command can then be entered that will only refresh that library.
When working with linklst'd datasets, you will have to do either an LLA REFRESH or an IPL to pick up the new version of the module. [...]
13838 142 30_Re: Expand compressed rows ...6_keyRho16_keyrho@GMAIL.COM31_Tue, 21 Jul 2009 09:46:43 -0400613_ISO-8859-1 Mike ...
thanks for your comments.
I am not looking any utilities for ... I am simply trying to expand rows which were ccompressed using 'compress yes' option in tablespace, outside of DB2 system, from macro CSRCMPSC .
On Mon, Jul 20, 2009 at 7:40 PM, Mike Bell wrote:
> I do NOT know of any utility that will apply an arbitrary dictionary to a > compressed file and expand it. Usually the program that compressed the file > has an uncompress function also since I don't know of many application > programs that can read compressed format file. [...]
13981 117 69_[AD] NEODBUG Presents Roger Miller TH 08/20 in Independence, Ohio USA11_James Szabo24_jim.szabo@ROADRUNNER.COM31_Tue, 21 Jul 2009 10:15:19 -0400414_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) is pleased to present IBM's ROGER MILLER at our quarterly meeting, Thursday August 20 at the DoubleTree Hotel Cleveland South, in Independence, Ohio USA.
Roger will be speaking on the following topics:
"What's New in DB2 9 for z/OS and Beyond?" "DB2 X for z/OS" "DB2 for z/OS Selected Performance Topics" "DB2 9 for z/OS XML and SQL" [...]
14099 117 69_[AD] NEODBUG Presents Roger Miller TH 08/19 in Independence, Ohio USA11_James Szabo24_jim.szabo@ROADRUNNER.COM31_Tue, 21 Jul 2009 10:19:33 -0400414_iso-8859-1 The Northeast Ohio Database Users Group (NEODBUG) is pleased to present IBM's ROGER MILLER at our quarterly meeting, Thursday August 19 at the DoubleTree Hotel Cleveland South, in Independence, Ohio USA.
Roger will be speaking on the following topics:
"What's New in DB2 9 for z/OS and Beyond?" "DB2 X for z/OS" "DB2 for z/OS Selected Performance Topics" "DB2 9 for z/OS XML and SQL" [...]
14217 118 30_Re: Expand compressed rows ...9_Mike Bell21_mbell11a1@VERIZON.NET31_Tue, 21 Jul 2009 10:23:39 -0500414_US-ASCII You know that there are 3rd party products that do that right?
If you want to get into some deep ASM coding, on my system SYS1.MACLIB(CSRCMPSC) has sample code in the comments for the macro. There are also some REXX exec's in SYS1.SAMPLIB that implement compression in REXX code not ASM - I do NOT know if the dictionaries are compatable with CSRCMPSC. I found them by searching for CSRCMPSC. [...]
14336 366 26_DB2 V8on ZOS 1.10 SQL help16_Proctor, William25_William.Proctor@TGSLC.ORG31_Tue, 21 Jul 2009 13:00:36 -0500573_us-ascii Hello, thanks for all replies in advance. We have the following SQL that we are trying to modify to get the output shown below. We are not having much luck at this point. Is it possible to suppress the exit_source column to get the desired results?
SELECT DISTINCT EXIT_SOURCE, COUNT(*) AS TOT_OCCUR, DATE(INSERT_TIMESTAMP) AS CREATE_DATE FROM CXQ4.table1 WHERE INSERT_TIMESTAMP BETWEEN '2009-05-01-00.00.00.000000' AND '2009-07-31-00.00.00.000000' AND EXIT_SOURCE LIKE '%' GROUP BY EXIT_SOURCE, DATE(INSERT_TIMESTAMP) ORDER BY CREATE_DATE ASC WITH UR [...]
14703 553 30_Re: DB2 V8on ZOS 1.10 SQL help13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 21 Jul 2009 14:20:51 -0400485_us-ascii I can't think of a way with SQL only.
I'm sure you know that with QMF, this is very simple. Make that field a control break in the rpt def.
You could do it with Rexx logic also.
Pure SQL, dunno.
Dave
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Proctor, William Sent: Tuesday, July 21, 2009 2:01 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V8on ZOS 1.10 SQL help [...]
15257 244 30_Re: DB2 V8on ZOS 1.10 SQL help0_20_Mark.Doyle@WPSIC.COM31_Tue, 21 Jul 2009 13:27:42 -0500627_US-ASCII Bill,
There's a disconnect somewhere; the output cannot be produced from the SQL given. Specifically, the order by clause appears wrong, or not followed in the output. I'll assume that the order by clause is supposed to be ORDER BY EXIT_SOURCE ASC, CREATE_DATE ASC.
The general solution to your problem is to left join the supplied SQL to the result set of SELECT EXIT_SOURCE, MIN(INSERT_TIMESTAMP) "MIN_TS" FROM CXQ4.table1B . . . (same where clauses). Your outer select will have a case expression CASE WHEN A.INSERT_TIMESTAMP = B.MIN_TS THEN A.EXIT_SOURCE ELSE ' ' (blank) END . . . You may have [...]
15502 155 53_DB2 Select problem with LIKE - What am I doing wrong?0_22_DB2information@AOL.COM29_Tue, 21 Jul 2009 14:56:46 EDT296_US-ASCII Hello List I have a problem with this select. I do not get what I expect. I get IBM tables from this SELECT not the the tables that start with RKI% Below is the code of my REXX
SRCTBID = 'ECB%' /* this is the tables I am attempting to select, but I get other tables names */ [...]
15658 598 57_Re: DB2 Select problem with LIKE - What am I doing wrong?13_David Simpson22_dsimpson@THEMISINC.COM31_Tue, 21 Jul 2009 15:00:37 -0400700_us-ascii Logic error??? Mixing ANDs and ORs without bracketing is bad news...
David Simpson
Senior Technical Advisor
Themis Training
dsimpson@themisinc.com
http://www.themisinc.com
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of DB2information@AOL.COM Sent: Tuesday, July 21, 2009 1:57 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Select problem with LIKE - What am I doing wrong?
Hello List
I have a problem with this select. I do not get what I expect. I get IBM tables from this SELECT not the the tables that start with RKI% [...]
16257 292 57_Re: DB2 Select problem with LIKE - What am I doing wrong?0_17_db46@CHRYSLER.COM31_Tue, 21 Jul 2009 15:10:17 -0400455_ISO-8859-1 Try NAME LIKE ? AND TYPE IN ('T', 'V')
Dean J. Burchill 248-576-3957 (8) 776-3957
David Simpson Sent by: DB2 Data Base Discussion List 07/21/2009 03:06 PM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject Re: [DB2-L] DB2 Select problem with LIKE - What am I doing wrong? [...]
16550 160 30_Re: DB2 V8on ZOS 1.10 SQL help0_17_db46@CHRYSLER.COM31_Tue, 21 Jul 2009 15:12:44 -0400484_US-ASCII Yes, but it will be ugly. To my knowledge this is best left to a programming language.
That might point you in the way of a language based stored procedure where you would use a few 'if' statements to compare the last EXIT_SOURCE value.
Also unless this forces the use of on index, the predicate EXIT_SOURCE LIKE '%' doesn't do much unless the column can be null. If so, then where EXIT_SOURCE IS NOT NULL. Also with the count you don't need the distinct. [...]
16711 602 30_Re: DB2 V8on ZOS 1.10 SQL help12_Fay, Colin M13_CFay@UNUM.COM31_Tue, 21 Jul 2009 15:12:53 -0400540_us-ascii Perhaps you can use a common table expression (red) with muliple selects for each different row format
Here is a sameple of a that prduces the similar report below
WITH DTOTAL (WORKDEPT, STARTYR,TOTALPAY) AS
( SELECT WORKDEPT, CHAR(YEAR(HIREDATE)), SUM(SALARY+BONUS)
FROM DSN8710.EMP
GROUP BY WORKDEPT ,YEAR(HIREDATE))
SELECT WORKDEPT, STARTYR,TOTALPAY,1 AS LEVEL
FROM DTOTAL
UNION ALL
SELECT WORKDEPT, '**TOT**', SUM(TOTALPAY),2 AS LEVEL [...]
17314 363 30_Re: DB2 V8on ZOS 1.10 SQL help0_17_db46@CHRYSLER.COM31_Tue, 21 Jul 2009 14:56:59 -0400484_US-ASCII Yes, but it will be ugly. To my knowledge this is best left to a programming language.
That might point you in the way of a language based stored procedure where you would use a few 'if' statements to compare the last EXIT_SOURCE value.
Also unless this forces the use of on index, the predicate EXIT_SOURCE LIKE '%' doesn't do much unless the column can be null. If so, then where EXIT_SOURCE IS NOT NULL. Also with the count you don't need the distinct. [...]
17678 69 57_Re: DB2 Select problem with LIKE - What am I doing wrong?0_22_DB2information@AOL.COM29_Tue, 21 Jul 2009 15:40:50 EDT823_US-ASCII
Thanks to all: The IN ('T', 'V') did the trick.
Thanks again to all.
Ed.
**************What's for dinner tonight? Find quick and easy dinner ideas for any occasion. (http://food.aol.com/dinner-tonight?ncid=emlcntusfood00000009)
_____________________________________________________________________
* IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *
_____________________________________________________________________
IDUG Europe Attendee Testimonial- "I had my first experience with certifications (and passed)! I learned a lot about DB2 version 9 (LUW) that hopefully will enable me to convince management a timely migration will be of benefit for the business." _____________________________________________________________________
17748 531 38_Re: DB2 for z/OS to Other Databases...18_Satish Srikakulapu26_Satish.Srikakulapu@APS.COM31_Tue, 21 Jul 2009 12:54:25 -0700428_us-ascii Mark,
The analysis document that I created is not an elaborative one but a small document. I will be more than happy to share it with others if this can help others.
Regards, Satish
From: mlabby@aessuccess.org [mailto:mlabby@aessuccess.org] Sent: Monday, July 20, 2009 10:46 AM To: Srikakulapu, Satish (ZP6066) Cc: DB2 Data Base Discussion List Subject: Re: DB2 for z/OS to Other Databases... [...]
18280 80 45_Re: SDSNEXIT on the LINK list it to small ...14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 22 Jul 2009 07:43:30 +1000507_US-ASCII Have two "SDSNEXIT" libraries. Both, of course, need APF authorisation.
One has ZPARMs and exit routines which are only used by DB2 address spaces. This is explicitly included into DB2 address space JCL. It does not have LLA enabled - because DB2 rarely reads from it.
One has DSNHDECP, DSNHMCID and sample routines which can be used by anyone and is in the linklist. This will be rarely updated and then only in situation where you should be able to manage the refresh problem. [...]
18361 380 73_Baltimore / Washington DB2 User Group September 2009 Meeting Announcement14_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Tue, 21 Jul 2009 23:03:43 +0000523_- The Baltimore/Washington DB2 Users' Group Meeting Schedule for September 9, 2009 (Wednesday)
When? Wednesday, September 9,2009 9:00 AM-3:30 PM (Registration at 8:30 AM)
Where? Sheraton Columbia, 10207 Wincopin Circle Columbia, MD (410) 730-3900
Meeting Fees (please note changes): Pre-registered members $30 Pre-registered non-members $40 At-the-door for members $40 At-the-door for non-members $50
To pre-register, please mail the appropriate fee with attendee's and employer's name to: [...]