1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l January 2007, week 3
2 412 15_Re: RI problems10_Paul Fegan33_Paul.Z.Fegan@TRANSPORT.QLD.GOV.AU31_Mon, 15 Jan 2007 09:26:11 +1000436_us-ascii All,<br><br>We got a fix for the problem from IBM (PK34002/UK19884). The PTF in question reads as a problem to do with on the check data utility but it's a bit more painful than that. If you have RI defined on your tables and the table was created under V6 of DB2 (maybe V7 as well) and you need to drop and recreate one of the parents then you may hit this problem. This is process we followed which exposed the problem. [...]
415 42 51_AW: [DB2-L] Is there a list like this for SQL Sever19_Weber, Thomas (LDS)23_Thomas.Weber@LDS.NRW.DE31_Mon, 15 Jan 2007 09:32:58 +0100826_iso-8859-1 Hi Kent,<br><br>here's the official list of listservers:<br><br>http://www.lsoft.com/lists/listref.html<br><br>HTH<br><br>Thomas<br><br>>-----Ursprüngliche Nachricht----- >Von: DB2 Data Base Discussion List >[mailto:DB2-L@IDUGDB2-L.ORG] Im Auftrag von Kent Collins >Gesendet: Montag, 15. Januar 2007 04:43 >An: DB2-L@WWW.IDUGDB2-L.ORG >Betreff: [DB2-L] Is there a list like this for SQL Sever > >Does anyone know of a list like this one for SQL Server? > >--------------------------------------------------------------- >------------------ >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 [...]
458 22 43_Re: Is there a list like this for SQL Sever11_Grant Allen17_gxallen@GMAIL.COM31_Mon, 15 Jan 2007 21:55:19 +1100706_ISO-8859-1 Kent Collins wrote: > Does anyone know of a list like this one for SQL Server?<br><br>The sql2k and sql2k5 lists from SSWUG (SQL Server Worldwide User Group) are the equivalent. check out www.sswug.org.<br><br>Ciao Fuzzy :-)<br><br>--------------------------------------------------------------------------------- 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
481 113 55_Re: Owner can't DROP TABLE in DB2 v8 compatibility mode12_Alex Andrade26_alex.andrade@EUROCONEX.COM31_Mon, 15 Jan 2007 04:36:35 -0600451_- (According to DB2 RACF Guide)To use the CREATETMTAB DB2 keyword in DB2 the process id "TST" needs authority to one of the following if RACF is employed<br><br>CREATETMTAB (DB2 Auth) The user must have sufficient authority to: One of these RACF profile: in this RACF CLass<br><br>DB2-subsystem.CREATETMTAB Class MDSNSM or GDSNSM DB2-subsystem.CREATETAB Class MDSNDB or GDSNDB DB2-subsystem.SYSCTRL Class DSNADM DB2-subsystem.SYSADM Class DSNADM [...]
595 32 43_Re: Is there a list like this for SQL Sever14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 15 Jan 2007 21:58:17 +1100865_US-ASCII Other mailing lists have a web front end at http://www.lazydba.com/ http://database.ittoolbox.com/groups/technical-functional/sql-server-l<br><br>there are some newsgroups: comp.databases.ms-sqlserver microsoft.public.sqlserver (you can use google groups to see these, and others)<br><br>http://www.dbforums.com/<br><br>James Campbell<br><br>On 14 Jan 2007 at 21:42, Kent Collins wrote:<br><br>> Does anyone know of a list like this one for SQL Server? > > --------------------------------------------------------------------------------- > 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 [...]
628 27 21_REORG sharelevel NONE37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Mon, 15 Jan 2007 15:39:16 +0100562_iso-8859-2 Hi all, My environment is DB2 v.7 z/OS I have a compressed TS, 12 partitions, 8GB each, but last one is now about 11GM and growing. In test environment I have tried to change PART 1 VALUES(...) and to run REORG sharelevel NONE part 1:2, but reorg crashed on sysrec (my estimation of appropriate sysrec is about 100GM). When I used SORTDATA and NOSYSREC, reorg worked. My first question: do the rows go to the reload phase in some small amounts? (jcl region was 8M) The second question: do you think that the method of changing one value of index [...]
656 47 25_Re: REORG sharelevel NONE7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 15 Jan 2007 08:17:04 -0800385_iso-8859-1 I suspect that SYSREC in this context would compress very nicely using DFSMS compression. Ask your storage admin or MVS system programmer if they can make it available to you. The idea is to reduce the size of the intermediate datasets. I get 3 or 4 to one compression on typical sequential datasets. Your 100gb file should be at least cut in half if not a lot better. [...]
704 138 25_Re: REORG sharelevel NONE36_=?utf-8?B?UG9zcMOtxaFpbCBEdcWhYW4=?=17_DPospisil@CSAS.CZ31_Mon, 15 Jan 2007 17:40:30 +0100306_utf-8 Thank you for your answer. However I looked at failed sysrec and all records was in full length (more then 600B each row). I thought that it was due to that every partition had its own dictionary. Probably you mean some other kind of compression (DFSMS?) which I know nothing about. Regards, dp [...]
843 20 18_DB2 Platinum LOADS15_Lizette Koehler23_starsoul@MINDSPRING.COM31_Mon, 15 Jan 2007 12:08:47 -0500300_UTF-8 Is there a way to setup platinum tool so it does not require the DEL/DEF at the beginning of its process? We are having issues when the data base is migrated and it takes hours to recall due to its size.<br><br>Is there a way to do an HDEL and then have platinum do the def/load function? [...]
864 71 25_Re: REORG sharelevel NONE7_Ed Long19_rdhm99a@PRODIGY.NET31_Mon, 15 Jan 2007 09:35:05 -0800601_iso-8859-1 That is exactly the compression I am alluding to. Check with your storage administrator or system programmer. With SMS compression assigned, which can be done with jcl, the LRECL remains the same but the actual space used is reduced.<br><br>PospÃ&shy;Å¡il DuÅ¡an <DPospisil@CSAS.CZ> wrote: Thank you for your answer. However I looked at failed sysrec and all records was in full length (more then 600B each row). I thought that it was due to that every partition had its own dictionary. Probably you mean some other kind of compression (DFSMS?) which I know nothing about. Regards, dp [...]
936 44 22_Re: DB2 Platinum LOADS14_Simpson, David22_DSIMPSO@TRANSUNION.COM31_Mon, 15 Jan 2007 11:34:50 -0600395_US-ASCII If you are talking about FastLoad, including the keyword "SPACE-DEFN NO" will prevent it from reallocating the underlying files if they are present.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Lizette Koehler Sent: Monday, January 15, 2007 11:09 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 Platinum LOADS [...]
981 187 25_Re: REORG sharelevel NONE36_=?utf-8?B?UG9zcMOtxaFpbCBEdcWhYW4=?=17_DPospisil@CSAS.CZ31_Mon, 15 Jan 2007 18:41:01 +0100531_utf-8 Thank you very much<br><br><br><br>________________________________<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Ed Long Sent: Monday, January 15, 2007 6:35 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] REORG sharelevel NONE<br><br><br><br>That is exactly the compression I am alluding to. Check with your storage administrator or system programmer. With SMS compression assigned, which can be done with jcl, the LRECL remains the same but the actual space used is reduced. [...]
1169 46 25_Elaine Mascuilli - GENDB20_22_DB2information@AOL.COM29_Mon, 15 Jan 2007 15:36:48 EST649_US-ASCII Elaine, You requested sample panels of GENDB2 but you did not enter a valid email address. Please send valid email address and we will send the sample panels.<br><br>Ed.<br><br>--------------------------------------------------------------------------------- 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
1216 21 55_Re: AW: [DB2-L] Is there a list like this for SQL Sever16_Craig S. Mullins23_craig@CRAIGSMULLINS.COM31_Mon, 15 Jan 2007 16:17:49 -0500656_ISO8859-1 Try here:<br><br>http://database.ittoolbox.com/groups/technical-functional/Sql-server-l<br><br>Cheers, Craig S. Mullins NEON Enterprise Software, Inc. http://www.neonesoft.com<br><br>--------------------------------------------------------------------------------- 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
1238 119 12_IBM Omegamon14_Galeos Antonis19_AGaleos@EUROBANK.GR31_Tue, 16 Jan 2007 10:58:03 +0200675_us-ascii Hello listers<br><br>Has anyone any experience with IBMs Omegamon ? I need some feed back from people that they using it<br><br><br><br>Disclaimer: This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system. EFG Eurobank Ergasias S.A. is not responsible for, nor endorses, any opinion, recommendation, conclusion, solicitation, offer or agreement or any information contained in this communication. EFG Eurobank Ergasias S.A. cannot accept any responsibility for the accuracy or completeness of [...]
1358 89 22_Re: DB2 Platinum LOADS14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 16 Jan 2007 10:16:53 -0000579_us-ascii Specifying SPACE-DEFN NO will indeed stop Fast Load from deleting and redefining the datasets, but Lizette will still have to wait for them all to be recalled.<br><br>I think what she is asking for is for Fast Load to do an HDELETE/Define instead of a Delete/Define<br><br>This is currently not supported, however if you do an HDELETE (through ISPF 3.4 perhaps) and then run Fast Load with SPACE-DEFN YES, then it should NOT fail just because the datasets are missing - it will just allocate new ones, which I think is what is needed here. To quote the manual "For [...]
1448 133 16_Re: IBM Omegamon13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Tue, 16 Jan 2007 06:42:26 -0500463_us-ascii I have used Omegamon for almost as long as I have been using DB2 (19.4 years or so).<br><br>I have had my issues with it over the years, but I haven't used a better realtime monitor.<br><br>Dave<br><br><br><br><br><br>________________________________<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Galeos Antonis Sent: Tuesday, January 16, 2007 3:58 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] IBM Omegamon [...]
1582 215 28_Re: DB2 v.8 z/OS DR Question13_Carol Broyles21_clbroyles55@YAHOO.COM31_Tue, 16 Jan 2007 05:19:59 -0800574_ascii Bob, I've cleaned up ICF catalogs using a series of ISPF commands like the following. First, save a 3.4 listing of your datasets with a command like "SAVE DB2". A dataset called "<your-profile-prefix>.DB2.DATASETS will be created. Edit this dataset and issue the following commands: X ALL F DSNDBC ALL DEL ALL X RESET BNDS 45 * Issue the following block command: )) <This is on the first line of your dataset names.> ))100 <This is on the last line of your dataset names.> This should leave the dataset name only on the line. Now issue command BNDS to reset your [...]
1798 13 55_Re: Owner can't DROP TABLE in DB2 v8 compatibility mode15_Maciej Poraszka19_poraszkam@GMAIL.COM31_Tue, 16 Jan 2007 07:17:29 -0600554_- OK, Alex but CREATE works fine for user TST. Problem is with DROP .<br><br>Maciej<br><br>--------------------------------------------------------------------------------- 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
1812 13 16_Re: IBM Omegamon12_Adam Baldwin19_y0027528@ES.IBM.COM31_Tue, 16 Jan 2007 07:58:09 -0600740_- Although somewhat biased I agree with Dave - in 19 years with DB2 I haven't used a better monitor. Yes, there is a CPU overhead associated with Omegamon (as with any realtime monitor) but the potential gains that can be achieved by it's prudent use far outweigh this.<br><br>--------------------------------------------------------------------------------- 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
1826 254 17_DB2 V8 Load Issue11_Mohit Tyagi18_mztyagi@KANBAY.COM31_Tue, 16 Jan 2007 19:36:00 +0530419_us-ascii Hi<br><br><br><br><br><br>I am a new DB2 Version 8 user. I have been working in V7 all this time<br><br><br><br><br><br>I am trying to load a table having 4 indexes but am facing problem in the sort step.<br><br><br><br><br><br>The error is<br><br>DSNU395I DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS = 8<br><br>DSNU016I DSNUGSAT - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'016D' [...]
2081 277 21_Re: DB2 V8 Load Issue14_Simpson, David22_DSIMPSO@TRANSUNION.COM31_Tue, 16 Jan 2007 09:15:01 -0600489_US-ASCII <br><br><br><br>You may be hitting a little known feature of Version 8. The sort tool used by utilities changes from whatever your shop commonly uses (perhaps Syncsort) in V7 to IBM's DFSORT in V8.<br><br><br><br><br><br>In my case, I had spent 6 years tuning Syncsort for my utilities... had to start over. I have spent the last 18 months making large utilities work again under DFSORT. If you can send me the entire output of the job privately, I would love to look at it. [...]
2359 157 54_Re: Passing result set through nested stored procedure11_Suresh Sane21_data_arch@HOTMAIL.COM31_Tue, 16 Jan 2007 10:19:35 -0600320_- James,<br><br>You are correct in that this would be simpler.<br><br>It does mean the client has a connection to the server (other than a CALL), which may not be desirable. Some front-ends will process the FETCH from aresult set easily, but the logic to code a cursor as you suggest would need to be custom-built. [...]
2517 63 28_Re: DB2 v.8 z/OS DR Question8_wtrovijo19_wtrovijo@UOL.COM.BR31_Tue, 16 Jan 2007 14:22:24 -0200398_iso-8859-1 The simple rexx below does generate idcams delete and rename commands on datasets selected by mask using a modified version of iggcsirx from sys1.samplib. Just modify iggcsirx to return result in stack instead of displaying it, or modify code below to trap iggcsirx display. Resulting idcams comands are written in sysut2 data which in turn can be passed to a idcams step sysin dd. [...]
2581 15 25_DSNTPSMP V7.1 on Z/os 1.40_21_BudGreenman@ONGOV.NET31_Tue, 16 Jan 2007 11:28:21 -0500606_US-ASCII How (where) can the defaults for the bind options be changed in dsntpsmp?<br><br>Bud Greenman Applications Programming Manager<br><br>--------------------------------------------------------------------------------- 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
2597 50 21_Re: DB2 V8 Load Issue7_Ale Eba15_aeba@CA.IBM.COM31_Tue, 16 Jan 2007 12:11:51 -0500613_US-ASCII Hello, DB2 8.1 uses DFSORT. There is no need to specify SORTWKxx datasets in the JCL. Without sort work datasets, DFSORT will allocate the datasets dynamically will perform parallel index rebuild. The number of sort work datasets will depend on SORTNUM and SORTDEVT parameter. If you don't specify SORTNUM and SORTDEVT, DFSORT will take it from sort installation default parameter DYNALOC. There is a lot of detail about tuning DFSORT parameter. See APAR II14047. You can print sort installation default parameter using ICETOOL. A sample job to print the default parameters is in DFSORT user guide. [...]
2648 31 29_z/OS DB2 7.1 DSNL032I message11_Chris Bowen22_chris.bowen@MACRO4.COM31_Tue, 16 Jan 2007 11:10:40 -0600443_- Hi all,<br><br>Wwhen one of my colleagues attempts to use an ODBC connection I'm getting a<br><br>DSNL032I - DSNLIRTR DRDA EXCEPTION CONDITION IN 750 REQUEST FROM REQUESTOR LOCATION=10.9.1.65 FOR THREAD WITH LUWID=XXXXXXXXXXXXXXXXXXXXXXXXXXXX REASON=00D3101C ERROR ID=DSNLIRTR0003 IFCID=0192 SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001<br><br>The trace record should go to where STATS class 4 goes and in our case that is SMF. [...]
2680 29 45_DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT19_Luiz Roberto Foroni27_lforoni@CAIXASEGUROS.COM.BR31_Tue, 16 Jan 2007 16:43:40 -0200425_iso-8859-1 Hi listers,<br><br>I would like to know if there is a way to disable cached dynamic statement for some queries, when I use option CACHE DYNAMIC SQL = YES. I don´t want queries from dsntep2 cached.<br><br><br><br>thanks in advance<br><br><br><br>Luiz Foroni Administrador de Banco de Dados GEINF - Gerência de Engenharia das Infras-estruturas Tecnológicas CAIXA SEGUROS TEL 55-61-2192-2939 FAX 55-61-3328-2108 [...]
2710 64 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT16_Rasmussen, Steen22_Steen.Rasmussen@CA.COM31_Tue, 16 Jan 2007 14:02:04 -0500509_iso-8859-1 Hello Roberto,<br><br>I know the BIND/REBIND statement has a parameter named KEEPDYNAMIC(YES/NO), so you can rebind the DSNTEP2 package using this parameter. The dynamic statement will still go into the dynamic statement cache, but it will go away once the statement has been committed (as far as I remember).<br><br>Steen Rasmussen CA Senior Consultant DB2 tools Tel : +1-630-505-6673 (US direct) Tel : +1-815-274-9589 (US mobile) Tel : +45-22 15 44 98 (Europe mobile) Steen.Rasmussen@ca.com [...]
2775 62 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT21_wfavero@attglobal.net21_wfavero@ATTGLOBAL.NET31_Tue, 16 Jan 2007 15:04:07 -0500412_iso-8859-1 The dynamic statement cache (global cahce) that you establish at installation is a system wide value. It is either on for everything or off for everything.<br><br>Willie<br><br>Original Message: ----------------- From: Luiz Roberto Foroni lforoni@CAIXASEGUROS.COM.BR Date: Tue, 16 Jan 2007 16:43:40 -0200 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT [...]
2838 252 16_Re: IBM Omegamon13_Petersen, Jim26_Jim_Petersen@HOMEDEPOT.COM31_Tue, 16 Jan 2007 15:46:12 -0500496_us-ascii I like the TMON/DB2 monitor far more than the Omegamon monitor. Much easier to use and in navigates to the MVS, CICS, MQ, TCPIP, and Web monitors much easier than Omegamon.<br><br><br><br><br><br><br><br><br><br><br><br>___________________________________________ Jim Petersen MVS - Lead Systems Engineer Home Depot Technology Center 1300 Park Center Drive, Austin, TX 78753 www.homedepot.com email: jim_petersen@homedepot.com 512-977-2615 direct 512-977-2930 fax 210-859-9887 cell [...]
3091 49 16_Elaine Mascuilli0_22_DB2information@AOL.COM29_Tue, 16 Jan 2007 17:35:51 EST665_US-ASCII <br><br>Elaine, You requested sample panels of GENDB2 but you did not enter a valid email address. Please send valid email address and we will send the sample panels.<br><br>Ed.<br><br><br><br>--------------------------------------------------------------------------------- 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
3141 67 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Tue, 16 Jan 2007 16:58:00 -0600368_ISO-8859-1 This response is from Suresh..<br><br>Luiz,<br><br>As Willie has explained this is a all-or-nothing option - for a zparm.<br><br>However, by binding dsntep2 as reopt(vars), you will disable dynamic statement caching for all sql it runs. Normally, this adds overhead for static sql but here, there should be no added overhead, just the loss of caching. [...]
3209 49 14_SQL Query help5_tsp l19_tspdba001@GMAIL.COM31_Tue, 16 Jan 2007 19:49:02 -0500401_ISO-8859-1 Hi,<br><br>Please look at the query below , could anybody please tell me is this a valid query. When I execute this via spufi I get -4700 sql code. could anybody help me in understand this. Thanks. SELECT MAX (EFF_DT) FROM PNY.VGEN_CD_DET B WHERE B.MKT_ID = ? AND B.GRP_CD = ? AND B.VAL_CD = ? ) AND ((SELECT SUM(PAY_AMT) FROM PNY.VPAYMENT WHERE MKT_ID ='RNY')>=1) OPTIMIZE FOR 1 ROW; [...]
3259 195 18_Re: SQL Query help14_Rob Adams-Kane18_rkane@WAHCO-IT.COM31_Tue, 16 Jan 2007 16:56:33 -0800706_us-ascii If you've copied this accurately, it may simply be a matter of mis-matched parenthesis.<br><br><br><br>Rob Adams-Kane<br><br><br><br>W.A. Hynes & Company, Inc. (800) 823-1470 (707) 586-2222 fax (888) 562-1471 rkane@waHco-it.com www.waHco-it.com<br><br>This email, and any files attached, contains information intended only for the use of the addressee and may include information that is privileged, confidential or exempt from other disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, copying, printing or other use of this email is prohibited. If you have received this email in error, please delete it from you computer. [...]
3455 156 18_Re: SQL Query help5_tsp l19_tspdba001@GMAIL.COM31_Tue, 16 Jan 2007 20:16:42 -0500312_ISO-8859-1 I am sorry, it was a typo. Below is the query again and I am getting the same sql code as -4700<br><br><br><br>SELECT MAX (EFF_DT) FROM PNY.VGEN_CD_DET B WHERE B.MKT_ID = ? AND B.GRP_CD = ? AND B.VAL_CD = ? AND ((SELECT SUM(PAY_AMT) FROM PNY.VPAYMENT WHERE MKT_ID ='RNY')>=1) OPTIMIZE FOR 1 ROW; [...]
3612 102 18_Re: SQL Query help10_Dave Nance16_dav1mo@YAHOO.COM31_Tue, 16 Jan 2007 17:23:27 -0800428_iso-8859-1 I can't find any reference to a -4700 or even a 4700 in the manuals, so can't help you with that, but your query presents a few questions. I don't understand the need for that subselect as it has nothing to do with the rest of the query. Is some column from your VGEN_CD_DET table supposed to be joined to it? Is it possible that subselect would return more than 1 row? And could that query return a null value? [...]
3715 347 14_SQL Query help7_J Anand34_AnandJayachandran@FREIGHTLINER.COM31_Tue, 16 Jan 2007 17:45:21 -0800511_US-ASCII Are you in DB2 V8 New Function Mode? You are attempting to use a NFM function in CM or ENF mode.<br><br>-4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE<br><br><br><br><br><br>Explanation: Functions that this release of DB2 introduces cannot be used before new function mode has been enabled. An attempt was made to execute one of these functions. In addition, support for extending the length of a VARCHAR (supported in V7) is restricted in V8 until new function mode has been enabled. [...]
4063 167 18_Re: SQL Query help5_tsp l19_tspdba001@GMAIL.COM31_Tue, 16 Jan 2007 20:52:59 -0500570_ISO-8859-1 We are still in CM mode. But that was the error I got when I try to execute it.<br><br>On 1/16/07, AnandJayachandran@freightliner.com < AnandJayachandran@freightliner.com> wrote: > > Are you in DB2 V8 New Function Mode? You are attempting to use a NFM > function in CM or ENF mode. > > -4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE > > > > Explanation: Functions that this release of DB2 introduces cannot be used > > before new function mode has been enabled. An attempt was made to execute > > one of these functions. In addition, support [...]
4231 118 18_Re: SQL Query help14_Larry Kintisch19_lkint@IX.NETCOM.COM31_Tue, 16 Jan 2007 21:26:08 -0500719_us-ascii Hi List, I'd suggest you try reversing the Subselect predicate to be AND 1<= (SELECT SUM(...)...) The reason it fails is that as coded it is a "Scalar subselect", not supported without NFM. Larry Kintisch ABLE Information Services 845-353-0885 www.DBIndex Design.com<br><br><br><br>At 08:52 PM 1/16/2007, tsp l wrote: >We are still in CM mode. But that was the error I got when I try to >execute it. > >On 1/16/07, ><mailto:AnandJayachandran@freightliner.com>AnandJayachandran@freightliner.com ><<mailto:AnandJayachandran@freightliner.com> >AnandJayachandran@freightliner.com> wrote: > >Are you in DB2 V8 New Function Mode? You are attempting to use a NFM >function in CM or ENF mode. > >-4700 ATTEMPT TO [...]
4350 179 18_Re: SQL Query help5_tsp l19_tspdba001@GMAIL.COM31_Tue, 16 Jan 2007 21:45:47 -0500617_ISO-8859-1 Thanks a lot. It works.<br><br>On 1/16/07, Larry Kintisch <lkint@ix.netcom.com> wrote: > > Hi List, > I'd suggest you try reversing the Subselect predicate to be > AND 1<= (SELECT SUM(...)...) > The reason it fails is that as coded it is a "Scalar subselect", > not supported without NFM. Larry Kintisch ABLE Information > Services 845-353-0885 www.DBIndex Design.com > > > At 08:52 PM 1/16/2007, tsp l wrote: > >We are still in CM mode. But that was the error I got when I try to > >execute it. > > > >On 1/16/07, > ><mailto:AnandJayachandran@freightliner.com> > AnandJayachandran@freightliner.com > [...]
4530 16 43_Copy Production Data to Test using DSN1COPY5_Srini16_sinu99@YAHOO.COM31_Wed, 17 Jan 2007 02:30:20 -0600641_- Hi,<br><br>I need to copy data from production to test database using DSN1COPY. Does anyone have a utility to generate the DSN1COPY JCL?<br><br>Thanks in advance, Srini<br><br>--------------------------------------------------------------------------------- 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
4547 27 50_Copy one db from one machine to an other one 8.1.416_Squeak Smalltalk20_wallenberg@GMAIL.COM31_Wed, 17 Jan 2007 13:25:50 +0100302_ISO-8859-1 Hi,<br><br>I have copy all files from one machine to an other one ( newer HW). When I start the db2 database on the new machine I have some troubles.<br><br>I thought that copy the files should be enough.<br><br>Do I need to catalog again ?<br><br>Is it possible to move a db like this [...]
4575 25 29_[z/OS] MV for DB2 / Easy Menu22_Cuneyt Goksu (Usa.net)19_cuneytgoksu@USA.NET31_Wed, 17 Jan 2007 14:42:30 +0200296_iso-8859-9 Hello DB2 Users,<br><br>This is for BMC guys.<br><br>How do you change the Subsystem in Easy Menu for MV for DB2.<br><br>There are more than one DB2s here and In window Mode it shows all but if I switch to Easy Menu it shows One of them.<br><br>How this default is set and where? [...]
4601 20 54_Re: Copy one db from one machine to an other one 8.1.48_wtrovijo19_wtrovijo@UOL.COM.BR31_Wed, 17 Jan 2007 10:48:34 -0200713_iso-8859-1 I'd put all my $0.02 that copy messed up filesystem permissions. I don't know if it's the best way, but what I normally do is offline backup at the source and restore at the target.<br><br>Walter Trovijo Jr.<br><br><br><br><br><br><br><br>--------------------------------------------------------------------------------- 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
4622 104 33_Re: [z/OS] MV for DB2 / Easy Menu15_Moschelli Mauro34_mauro.moschelli@INTESASANPAOLO.COM31_Wed, 17 Jan 2007 13:53:04 +0100663_iso-8859-9 I don't know how the default is set but you can change the selected db2 subsystem following the ". Set Target Context" hyperlink or typing the command "CONTEXT ssid" on the command line<br><br>HTH<br><br><br><br><br><br>Mauro Moschelli Intesa Sanpaolo S.p.A.<br><br>IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS<br><br><br><br>> -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of Cuneyt Goksu (Usa.net) > Sent: Wednesday, January 17, 2007 1:43 PM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: [DB2-L] [z/OS] MV for DB2 / Easy Menu > > > Hello DB2 Users, > > This is for BMC guys. [...]
4727 12 47_Re: Copy Production Data to Test using DSN1COPY10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Wed, 17 Jan 2007 07:07:49 -0600629_- WHy not use the UNLOAD utility, from the actual tablespaces or from image copies? That way you don't have to mess about with OBID translation, NUMPARTS etc.<br><br>--------------------------------------------------------------------------------- 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
4740 114 47_Re: Copy Production Data to Test using DSN1COPY13_Michael Ebert18_mebert@AMADEUS.COM31_Wed, 17 Jan 2007 14:27:21 +0100650_US-ASCII The obvious answer is that this would take about a hundred times as much CPU (it's the LOAD that is costly).<br><br>Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany<br><br><br><br><br><br><br><br>Steve Lamb <steven.lamb@CAPGEMINI.COM> To DB2-L@WWW.IDUGDB2-L.ORG cc<br><br>bcc<br><br>Subject Re: [DB2-L] Copy Production Data to Test using DSN1COPY<br><br><br><br><br><br><br><br><br><br>Steve Lamb <steven.lamb@CAPGEMINI.COM> Please respond to DB2 Database Discussion list at IDUG <DB2-L@WWW.IDUGDB2-L.ORG> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 17-01-07 14:07 [...]
4855 12 33_Re: z/OS DB2 7.1 DSNL032I message10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Wed, 17 Jan 2007 07:33:07 -0600584_- Should that be type 102? "STATISTICS TRACE IS 102 (DEC) FOR ALL IFCIDS OTHER THAN 0001, 0002, 0202, AND 0230. "<br><br>--------------------------------------------------------------------------------- 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
4868 105 33_Re: z/OS DB2 7.1 DSNL032I message35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 17 Jan 2007 09:34:38 -0500513_iso-8859-1 Statistics is type 100. IFCID's 1 and 2 are part of the Statistics record. Type 102 is for performance traces.<br><br>Regards, Joel<br><br>Joel Goldstein Responsive Systems Buffer Pool Tool for DB2, the worldwide industry standard Performance software that works...... Predicts Group Buffer Pool performance too! www.responsivesystems.com tel. (732) 972-1261 fax.(732) 972-9416<br><br>Should that be type 102? "STATISTICS TRACE IS 102 (DEC) FOR ALL IFCIDS OTHER THAN 0001, 0002, 0202, AND 0230. " [...]
4974 10 47_Re: Copy Production Data to Test using DSN1COPY10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Wed, 17 Jan 2007 08:24:34 -0600539_- Yep, but it's all relative - your time against the machine's time!<br><br>--------------------------------------------------------------------------------- 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
4985 31 33_Re: z/OS DB2 7.1 DSNL032I message10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Wed, 17 Jan 2007 08:47:54 -0600585_- On Wed, 17 Jan 2007 09:34:38 -0500, Joel Goldstein - Responsive Systems <joel@RESPONSIVESYSTEMS.COM> wrote:<br><br>>Statistics is type 100. >IFCID's 1 and 2 are part of the Statistics record. >Type 102 is for performance traces. ><br><br>Joel,<br><br>In my DSNWMSGS member in SDSNSAMP (v7) it says<br><br>"SM100LEN LENGTH OF SMF RECORD. SM100SGD SEGMENT DESCRIPTOR FOR VARIABLE BLOCK SPANNED RECORDS. SM100FLG SYSTEM INDICATOR. SM100RTY SMF RECORD TYPE: SM100RTY STATISTICS TRACE IS 100 (DEC) FOR IFCIDS 0001 AND 0002. SM100RTY OTHER STATISTICS IFCIDS ARE IN SMF 102 RECORDS. " [...]
5017 21 16_Re: IBM Omegamon15_Jonathan Miller29_millerjonathanm@JOHNDEERE.COM31_Wed, 17 Jan 2007 09:04:47 -0600562_- We've had experience with both BMC's and Candle/IBM Omegamon. In my previous job 10 years ago we used the TMON one. So overall they are all decent monitors. BMC's had a customizable-interface that you could alter but took time, Omegamon and TMON had ease of use but not customizable. Depends on what you value and want. Each one has it's own niche in a monitor but all do essentially the same basic DB2 monitoring functions. We've had some support issues with Omegamon since the IBM takeover but I beleive that will take some time to work out as they are [...]
5039 146 29_z/OS DB2 7.1 DSNL032I message35_Joel Goldstein - Responsive Systems26_joel@RESPONSIVESYSTEMS.COM31_Wed, 17 Jan 2007 10:30:14 -0500586_iso-8859-1 Steve,<br><br>The IBM docs like MSGS can be rather confusing at times, and this may be related to a lack of space to write long explanations. Some times they doc is not kept up to date with the real macro expansions.<br><br>First, having IFCIDs activated, for example, Accounting class 3, does not automatically externalize all the IFC data. But many of the IFCs must be specifically started as a performance trace to a specific destination to get the data. I've never used the 192 record, so I don't know if that is externalized by turning on Statistics trace class 4. [...]
5186 86 17_DB2 V8 Load Issue17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Wed, 17 Jan 2007 10:46:45 -0500752_us-ascii <You want to allocate a lot of memory. This was the most common failure for us.> I wish to reinforce David Simpson's suggestion. The change from Syncsort to DFSORT caused us to make serious changes to our reorg procs. We increased region size from 6M to 256M. Mark<br><br><br><br>--------------------------------------------------------------------------------- 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
5273 230 27_DB2 V7 IBM Admin Tool Issue12_Kirk Hampton28_khampto1@CAPGEMINIENERGY.COM31_Wed, 17 Jan 2007 10:42:36 -0600373_us-ascii We have run into a few situations with the IBM DB2 Admin Tool v7,<br><br>running on DB2 v7 on z/OS 1.7,<br><br>where it abends with a memory failure.<br><br><br><br><br><br>We have the vast majority of our TSO users still set at a late-80's size<br><br>of 4096K. Increasing that to<br><br>8192K gets us around the abends. I know that many batch jobs run with [...]
5504 56 47_Re: Copy Production Data to Test using DSN1COPY10_Doyle Mark19_Mark.Doyle@WUSH.COM31_Wed, 17 Jan 2007 10:55:54 -0600600_us-ascii Srini,<br><br>I have something close (I think)<br><br>Contact me off-line & we'll see if there is a match<br><br>Mark Doyle Database Administrator Information Services Telephone:(608) 825-5621 Fax: (608) 825-5098 E-mail: mark.doyle@wush.com<br><br>General Casualty One General Drive Sun Prairie, WI 53596 www.generalcasualty.com<br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Srini Sent: Wednesday, January 17, 2007 2:30 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Copy Production Data to Test using DSN1COPY [...]
5561 87 31_Re: DB2 V7 IBM Admin Tool Issue26_Lucier, David CIV DISA CDB21_LucierD@MECH.DISA.MIL31_Wed, 17 Jan 2007 11:59:34 -0500416_us-ascii We have been able to settle on 6144K for TSO and either 6M or 0M for batch. David Lucier Database Support DSN 430.7629 Comm 717.605.7629<br><br><br><br><br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Kirk Hampton Sent: Wednesday, January 17, 2007 11:43 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 V7 IBM Admin Tool Issue [...]
5649 17 33_Re: z/OS DB2 7.1 DSNL032I message11_Chris Bowen22_chris.bowen@MACRO4.COM31_Wed, 17 Jan 2007 11:07:27 -0600593_- Joel, Steve,<br><br>Thanks for your input.<br><br>I will start digging out the SMF102s.<br><br>Best regards, Chris Bowen<br><br>--------------------------------------------------------------------------------- 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
5667 316 31_Re: DB2 V7 IBM Admin Tool Issue10_Tobin, Jim17_Jim.Tobin@AIG.COM31_Wed, 17 Jan 2007 12:17:00 -0500359_us-ascii Kirk,<br><br>I also experienced same issue after I upgraded Admin Tool from V4.2 to V7.1. V4.2 ran fine with 4096K for all TSO users. V7.1 had issues with 4096K (GEN line command I believe). Having TSO users bump up to 8192K, as a test, resolved the issue.<br><br>BTW, z/OS prevents them (or myself) from bumping higher than 8192K on this LPAR. [...]
5984 28 20_Share your knowledge12_Bill Shipley28_william_shipley@VANGUARD.COM31_Wed, 17 Jan 2007 14:37:57 -0500379_US-ASCII As you may know the members area of the IDUG website has an E-Tip of the Week section. I would like to invite those of you with any DB2 tips or tricks to share them with other IDUG members. If you have a tip you would like to share with the DB2 Community, please fill out our online submission form in the Submit new Tip option of the members area on www.idug.org. [...]
6013 59 40_Odp: [DB2-L] DB2 V7 IBM Admin Tool Issue17_Mariusz Stakowski20_StakowskiM@PROKOM.PL31_Thu, 18 Jan 2007 09:52:33 +0100442_ISO-8859-2 Hello,<br><br>Our environment seems to be simalar to yours. From the time to time we had memory abends when DB2Admin treated many objects. So for certain jobs we have increased REGION to 0M. After that I have found that this situation is described in Chapter 27. DB2 Admin with a large number of objects (Other recommendations for a large number of objects) of IBM DB2 Administration Tool for z/OS User?s Guide and Reference. [...]
6073 21 38_OS/390 offsite disk mirroring/recovery10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Thu, 18 Jan 2007 07:01:11 -0600374_- We need to come up with a proposal to be able to recover a DB2 system at a second site. The disks would be mirrored - one set in the primary data centre and the second set in a second centre a couple of hundred miles away. If the primary data centre goes down, then we will need to IPL a machine at the second centre and recover the systems within a couple of hours. [...]
6095 83 42_Re: OS/390 offsite disk mirroring/recovery13_Pearson, Eric19_Eric.Pearson@53.COM31_Thu, 18 Jan 2007 08:29:15 -0500636_US-ASCII I've been in shops that do this with integrated hardware/software combinations from the vendor (HDS and EMC). Other vendors likely provide similar solutions. Works well, but biggest concerns:<br><br>1) Which set(s) of devices must be consistent with each other? Example: DB2 BSDS, Active Log, Catalog, and Directory absolutely must. Preferably DB2 application objects also should. If the underlying software (load libraries, etc.) Do your CICS, MQ, etc. data and logs need to be exactly in synch with the DB2 stuff? If the underlying software ( load libraries, etc.) is a little behind it is no big deal. Ask vendor about [...]
6179 312 36_Declared Temporary Table on DB2 Z/OS15_Schade, Jeffrey15_JSchade@ISO.COM31_Thu, 18 Jan 2007 08:43:42 -0500367_US-ASCII I have an interesting problem. My developer runs the following sequence in SPUFI on TSO and it works perfectly but when we run it via an ODBC connection such as Command Editor it never returns any rows as if the INSERT never occurred even though all commands execute successfully:<br><br><br><br><br><br>DECLARE GLOBAL TEMPORARY TABLE RI_ADJACENCY_LIST [...]
6492 321 40_Re: Declared Temporary Table on DB2 Z/OS14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 18 Jan 2007 13:48:18 -0000445_iso-8859-1 Your ODBC connection may be committing or connecting/disconnecting between each SQL statement<br><br>Do you have a monitor you can use to determine that they are all in the same UOW??<br><br>Phil Grainger CA<br><br>________________________________<br><br>From: DB2 Data Base Discussion List on behalf of Schade, Jeffrey Sent: Thu 18/01/2007 13:43 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Declared Temporary Table on DB2 Z/OS [...]
6814 417 40_Re: Declared Temporary Table on DB2 Z/OS15_Moschelli Mauro34_mauro.moschelli@INTESASANPAOLO.COM31_Thu, 18 Jan 2007 14:50:02 +0100503_us-ascii Il contenuto e gli allegati di questo messaggio sono strettamente confidenziali, e ne sono vietati la diffusione e l'uso non autorizzato.<br><br>Le opinioni ivi eventualmente espresse sono quelle dell'autore: di conseguenza il messaggio non costituisce impegno contrattuale tra il Gruppo Intesa Sanpaolo ed il destinatario, e la banca non assume alcuna responsabilita' riguardo ai contenuti del testo e dei relativi allegati, ne' per eventuali intercettazioni, modifiche o danneggiamenti. [...]
7232 16 40_Re: Declared Temporary Table on DB2 Z/OS8_wtrovijo19_wtrovijo@UOL.COM.BR31_Thu, 18 Jan 2007 12:04:42 -0200609_iso-8859-1 Use ON COMMIT PRESERVE ROWS when declaring table. Your ODBC app is probably commiting after each sql.<br><br>Walter Trovijo Jr.<br><br>--------------------------------------------------------------------------------- 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
7249 82 63_Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 18 Jan 2007 14:14:43 -0000543_- Hey Steve,<br><br>Your timing is perfect - I spent the first two days this week at one of our regular DR tests, and mirroring is exactly what we do. The first day was spent re-proving our backup DR method (using BMC's Recovery Manager) still works in case PPRC goes AWOL - it does. The 2nd day was basically an hour or so waiting for the Sysprogs to bring up the LPAR at our snap point, DB2 subsystems included, and having a quick butchers at our subsystems to make sure they were fine (they were), followed by several hours of sitting [...]
7332 47 40_Re: Declared Temporary Table on DB2 Z/OS15_Schade, Jeffrey15_JSchade@ISO.COM31_Thu, 18 Jan 2007 09:25:38 -0500583_US-ASCII This corrected my problem. Thank you to all who replied.<br><br>Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering<br><br>Insurance Services Office, Inc. 545 Washington Boulevard Jersey City, NJ 07310 Voice: (201) 469-3738 FAX: (201) 748-1500 jschade@iso.com<br><br><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of wtrovijo Sent: Thursday, January 18, 2007 9:05 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Declared Temporary Table on DB2 Z/OS [...]
7380 27 32_Addressing the DB2 RIB from REXX11_Mick Graley25_mick.graley@TISCALI.CO.UK31_Thu, 18 Jan 2007 13:40:08 +0000815_ISO-8859-15 Hi All,<br><br>Does anybody know if it is possible to address the DB2 RIB from a REXX program connected via DSNREXX?<br><br>Cheers,<br><br>Mick.<br><br><br><br>___________________________________________________________<br><br>Tiscali Broadband only 9.99 a month for your first 3 months! http://www.tiscali.co.uk/products/broadband/<br><br>--------------------------------------------------------------------------------- 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
7408 11 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT15_Patrick Bossman18_bossman@US.IBM.COM31_Thu, 18 Jan 2007 08:39:25 -0600571_- Dynamic SQL subject to REOPT(VARS) will not be cached. However, the SQL will undergo two prepares.<br><br>--------------------------------------------------------------------------------- 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
7420 42 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Thu, 18 Jan 2007 10:00:27 -0500479_US-ASCII So, to summarize: If I Bind Plan DSNTIAUL with REOPT(VARS), then any SQL statement I execute with this utility will be prepared twice? Why is that?<br><br>- Lock Lyon Principal DBA Fifth Third Bancorp<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Patrick Bossman Sent: Thursday, January 18, 2007 9:39 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT [...]
7463 85 49_DB2 for z/OS Version 7 - converting Oracle PL/SQL12_Jim McAlpine22_Jim.McAlpine@CEDAR.COM31_Thu, 18 Jan 2007 15:31:16 -0000592_iso-8859-1 We have the following function written in Oracle PL/SQL which we need to implement in DB2. What options do we have to convert PL/SQL to provide the same functionality in DB2.<br><br>CREATE FUNCTION E5CONCAT (SYSREF NUMBER) RETURN CLOB AS STR CLOB; CURSOR C1 IS SELECT TRIM(TXT) FROM TXEDLINE WHERE DIARY_SYSREF=SYSREF ORDER BY LINE_SEQ; TXT TXEDLINE.TXT%TYPE; X NUMBER; BEGIN STR := ''; X := 0; OPEN C1; LOOP FETCH C1 INTO TXT; X := X + 1; EXIT WHEN C1%NOTFOUND; IF X = 1 THEN STR := TXT; ELSE DBMS_LOB.APPEND(STR, CHR(13) || TXT); END IF; END LOOP; RETURN STR; END E5CONCAT; [...]
7549 286 20_Fw: DB2 Forum Jan 239_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Thu, 18 Jan 2007 10:21:19 -0600473_iso-8859-1 DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at: http://www.db2forum.com<br><br>Come to the 1st Quarter DB2 Forum Meeting. DB2 Forum would like to thank Compuware for sponsoring this meeting.<br><br>Date: Tuesday January 23, 2007<br><br>Location: Crowne Plaza North Dallas/Addison<br><br>14315 Midway Road<br><br>Addison, TX 75001<br><br>Phone - 972.980-8877<br><br><br><br><br><br>Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M [...]
7836 30 31_DB2 Systems Programmer Position11_Ruth Sutlic25_Ruth_A_Sutlic@KEYBANK.COM31_Thu, 18 Jan 2007 10:46:17 -0600755_- Mainframe DB2 Database Systems Installer Full time permanent position.<br><br>Serve as DB2 technical lead for defning tasks, estimating and establishing timelines Perform database installations and upgrades as required. Perform DB2 and QMF installations and apply maintenance using SMP/e. Effectively raise priority conflicts to management. Effectively communicate with team members and supervisor. Perform BMC Tools instllations and apply maintenance as required. Provide 24x7 coverage for on-call support as defined in on-call rotation. Ensure adherence to KTS techincal standards and design principles. Ensure all DB security, change management and problem management policies are adhered to. Mentor others and take leadership role. Proactively [...]
7867 84 33_DB2 for z/OS V8 DDF Conversations10_Irwin, Jim19_Jim.Irwin@OA.MO.GOV31_Thu, 18 Jan 2007 11:05:45 -0600424_us-ascii I don't know exactly what I want to ask here but can someone explain what constitutes a "conversation" as it relates to DDF and VTAM? We have a subsystem that does maybe 6000 distributed threads in a 15 minute period but the number of conversations is in the 1+ billion range if (and it's a big if) Omegamon is reporting correctly. Any illumination would be appreciated. Jim Irwin Technical Support Supervisor [...]
7952 11 35_Re: DB2 Systems Programmer Position11_Ruth Sutlic25_Ruth_A_Sutlic@KEYBANK.COM31_Thu, 18 Jan 2007 11:18:33 -0600573_- There are two locations for Keybank. We are posting this position for Albany, NY or Cleveland, Ohio.<br><br>--------------------------------------------------------------------------------- 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
7964 44 42_Re: OS/390 offsite disk mirroring/recovery11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Thu, 18 Jan 2007 11:49:01 -0600396_us-ascii -----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Pearson, Eric Sent: Thursday, January 18, 2007 7:29 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] OS/390 offsite disk mirroring/recovery<br><br><snip><br><br>6) How to return to 'home site' after crisis passes. I do not know anybody who has tried this (or even tested!). [...]
8009 379 40_Re: Declared Temporary Table on DB2 Z/OS11_John Miller26_John.L.Miller@ATCOITEK.COM31_Thu, 18 Jan 2007 10:53:19 -0700746_us-ascii In Command Editor goto menu Tools->Tools Settings then to tab Command Editor. Ensure "Automatically commit SQL statements" checkbox is not checked.<br><br><br><br><br><br>________________________________<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Schade, Jeffrey Sent: Thursday, January 18, 2007 6:44 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Declared Temporary Table on DB2 Z/OS<br><br><br><br><br><br>I have an interesting problem. My developer runs the following sequence in SPUFI on TSO and it works perfectly but when we run it via an ODBC connection such as Command Editor it never returns any rows as if the INSERT never occurred even though all commands execute successfully: [...]
8389 128 40_Re: Declared Temporary Table on DB2 Z/OS15_Schade, Jeffrey15_JSchade@ISO.COM31_Thu, 18 Jan 2007 14:08:16 -0500397_US-ASCII Hi John,<br><br>This also works. To be safe I think I will recommend to Development that they code the ON COMMIT PRESERVE ROWS option so that they get what they want without having to set the AUOTCOMMIT off in all their ODBC tools. Thanks for the additional information.<br><br>Jeff _________________________________________ Jeffrey Schade Systems Consultant, Technology Engineering [...]
8518 57 24_Rows-to-columns question0_25_Dave.Schaeffer@BENDIX.COM31_Thu, 18 Jan 2007 14:17:03 -0500280_us-ascii Hello everyone,<br><br>I've been messing around with some SQL and was hoping to get some ideas on how to write this. The environment is - DB2 v7.1 on z/OS What I'm trying to do is take a table that is in rows and report it in columns, below is a sample of the data. [...]
8576 107 28_Re: Rows-to-columns question26_Sorensen Henrik (KSFA 321)33_henrik.sorensen@CREDIT-SUISSE.COM31_Thu, 18 Jan 2007 20:47:26 +0100349_us-ascii Hi,<br><br>I wrote a simple table function, PIVOT, that takes and sql as parameter, and returns a table with the rows as columns.<br><br>select * from PIVOT("select ID,COL from mytable order by ID")<br><br>If sql returns: Row ! ID ! COL ! 1 ! A ! 12/03 ! 2 ! A ! 05/06 ! 3 ! A ! 18/08 ! 4 ! B ! 01/01 ! 5 ! B ! 07/09 ! 6 ! C ! 24/12 ! [...]
8684 97 28_Re: Rows-to-columns question10_Doyle Mark19_Mark.Doyle@WUSH.COM31_Thu, 18 Jan 2007 14:04:29 -0600585_us-ascii If you know how many MKTs (and the values) you have, I expect you can use this kind of construct:<br><br>Select case when sum(a.first) > 0 then quote_grp else null end as "MKT_1_QUOTE_GRP" , case when sum(a.second) > 0 then quote_grp else null end as "MKT_2_QUOTE_GRP", case when sum(a.third) > 0 then quote_grp else null end as "MKT_3_QUOTE_GRP", etc. case when sum(a.last) > 0 then quote_grp else null end as "MKT_x_QUOTE_GRP", From ( Select quote_grp, case when mkt=1 then 1 else 0 end as "first", case when mkt=2 then 1 else 0 end as "second", case when mkt=3 then 1 [...]
8782 109 37_Re: Rows-to-columns question (resend)10_Doyle Mark19_Mark.Doyle@WUSH.COM31_Thu, 18 Jan 2007 14:23:58 -0600591_us-ascii Oops! Missed the inner from clause . . .<br><br>If you know how many MKTs (and the values) you have, I expect you can use this kind of construct:<br><br>Select case when sum(a.first) > 0 then quote_grp else null end as "MKT_1_QUOTE_GRP" , case when sum(a.second) > 0 then quote_grp else null end as "MKT_2_QUOTE_GRP", case when sum(a.third) > 0 then quote_grp else null end as "MKT_3_QUOTE_GRP", etc. case when sum(a.last) > 0 then quote_grp else null end as "MKT_x_QUOTE_GRP", From ( Select quote_grp, case when mkt=1 then 1 else 0 end as "first", case when mkt=2 then 1 else [...]
8892 21 33_Re: [z/os] LOBS and empty strings13_Patric Becker21_patric_becker@GMX.NET31_Thu, 18 Jan 2007 14:16:36 -0600752_- Ivan,<br><br>check the Redbook 'LOBs with DB2 for z/OS: Stronger and Faster'. It explains the meaning of the flag bytes on page 33 (3.1.3 Manual creation of objects, section A few more details about the base table).<br><br>Hope this helps.<br><br>Have a great day !<br><br>Patric<br><br>--------------------------------------------------------------------------------- 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
8914 17 50_Minimum DB2 Connect version that works with DB2 V812_Bruce Crosby26_bruce_c_crosby@KEYBANK.COM31_Thu, 18 Jan 2007 15:21:47 -0600544_- We are beginning our conversison of our z/OS DB2 subsystems to DB2 V8. We have requested that all of our DB2 Connect users upgrade to DB2 Connect V81 FP13. However we have some DB2 Connect users and server administrators that are dragging their feet. I don't want to delay our upgrade schedule because of a few reluctant DB2 Connect users. Does anyone know if DB2 Connect V7 will work with z/OS DB2 V8? What type of problems could we have if we migrate to DB2 V8 before all of our DB2 Connect users have been upgraded to DB2 Connect V81 [...]
8932 45 54_Re: Minimum DB2 Connect version that works with DB2 V87_Ed Long19_rdhm99a@PRODIGY.NET31_Thu, 18 Jan 2007 14:19:37 -0800612_iso-8859-1 Based upon the DST research I've been doing, (Y2K Lite), I'd suggest FP14. That way you get the DST corrections at no extra charge or effort.<br><br><br><br>Bruce Crosby <bruce_c_crosby@KEYBANK.COM> wrote: We are beginning our conversison of our z/OS DB2 subsystems to DB2 V8. We have requested that all of our DB2 Connect users upgrade to DB2 Connect V81 FP13. However we have some DB2 Connect users and server administrators that are dragging their feet. I don't want to delay our upgrade schedule because of a few reluctant DB2 Connect users. Does anyone know if DB2 Connect V7 will work with [...]
8978 16 11_Use of LOBs12_Bob Pingston28_robert.pingston.cs@BCBSA.COM31_Thu, 18 Jan 2007 16:09:07 -0600414_- As a systems guy, design is not one of my strengths. So I post to the list for advice. We are thinking of using a LOB as a "scratch pad" for an application that works with large amounts of data. Its not that the volume is large, its the "record size" that is large. In the size of about 1.2MB in length. Currently this is a VSAM application, but it is being altered to use DB2. Any suggestions are welcome. [...]
8995 44 54_Re: Minimum DB2 Connect version that works with DB2 V813_Willie Favero21_wfavero@ATTGLOBAL.NET31_Thu, 18 Jan 2007 16:45:23 -0600660_ISO-8859-1 You will be way ahead of the game if you are using the latest and greatest release of DB2 Connect. It should be 8.1 FixPak 14 or 8.2 Fixpak 7...<br><br>I just posted this same information in my blog -- http://blogs.ittoolbox.com/database/db2zos/archives/a-db2-connect-quick-tip-13895<br><br>Willie<br><br>Bruce Crosby wrote:<br><br>>We are beginning our conversison of our z/OS DB2 subsystems to DB2 V8. We >have requested that all of our DB2 Connect users upgrade to DB2 Connect V81 >FP13. However we have some DB2 Connect users and server administrators >that are dragging their feet. I don't want to delay our upgrade schedule >because of a [...]
9040 153 63_Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Thu, 18 Jan 2007 17:47:47 -0500698_US-ASCII Why is suspending the logs briefly while you take your snaps, not necessary?<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Sent: Thursday, January 18, 2007 9:15 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery<br><br><br><br><br><br><br><br><br><br><br><br>Hey Steve,<br><br>Your timing is perfect - I spent the first two days this week at one of our regular DR tests, and mirroring is exactly what we do. The first day was spent re-proving our backup DR method (using BMC's Recovery Manager) still works in case PPRC goes AWOL - it does. The 2nd day was basically an [...]
9194 49 54_Re: Minimum DB2 Connect version that works with DB2 V812_Myron Miller22_myronwmiller@YAHOO.COM31_Thu, 18 Jan 2007 15:19:09 -0800524_iso-8859-1 First off, DB2 connect V7 is minimally supported, if at all. You really really don't want anyone still on V7. V8 is faster, more stable, etc, etc,<br><br>IBM states that DB2 Connect v8.1 FP14 is the minimum required (even better is V9 fp1). But from my experience is that except for a couple of very minor issues, FP10 will work just fine. In fact, I've got a lot of servers on FP7 with several hotfixes that are working just fine with it. And I've done a very large amount of testing with them on our apps. [...]
9244 28 29_Re: DSNTPSMP V7.1 on Z/os 1.414_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Jan 2007 12:34:20 +1100314_US-ASCII The hard way is to change the REXX code. (Well, up front it's easy, but when PTFs come ...)<br><br>The easy way is to look in the REXX code for the documentation for the CFGTPSMP file, and include one in the WLM JCL.<br><br>James Campbell<br><br>On 16 Jan 2007 at 11:28, BudGreenman@ONGOV.NET wrote: [...]
9273 53 53_Re: DB2 for z/OS Version 7 - converting Oracle PL/SQL14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Jan 2007 12:34:21 +1100311_US-ASCII DB2 V7 - you will have to write a UDF in COBOL, Assembler, C, etc to do this.<br><br>DB2 V8 - you might be able to conjure up some nested (ie WITH .... SELECT .... type code) to do this<br><br>DB2 V9 - not enough information in the public arena at this time to know if V9 will have other options. [...]
9327 41 36_Re: Addressing the DB2 RIB from REXX14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Jan 2007 12:34:21 +1100316_US-ASCII Well I presume it's loaded somewhere under the user's TCB - so it's simply a matter of following the CDE chain looking for an associated LLE for DSNARIB.<br><br>However, what's in it that you want? If it's just the DB2 VRM, an SQL CONNECT (without parameters) will give you that.<br><br>James Campbell [...]
9369 20 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT15_Patrick Bossman18_bossman@US.IBM.COM31_Thu, 18 Jan 2007 19:25:53 -0600482_- Hello Lockwood, I did a little further tracing on this. Not all SQL will be prepared twice, you've got to have a predicate which benefits from reoptimization. If there are no predicates, or you don't have any parameter markers / special registers (current date, current timestamp), then you'll avoid the reoptimization. You're going to have all literals in DSNTIAUL, but you could use special registers which would trigger the reoptimization at execution time (open cursor). [...]
9390 13 47_migration of MQ functions with DB2 V8 migration10_Mike Frame30_mike_frame@AMERICANCENTURY.COM31_Thu, 18 Jan 2007 21:01:41 -0600622_- Has anyone figured out what or if there is a migration needed for the MQ functions when you migration from DB2 V7 to DB2 V8 ?<br><br>Thank you, Mike.<br><br>--------------------------------------------------------------------------------- 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
9404 38 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Fri, 19 Jan 2007 17:31:19 +1100432_US-ASCII If I might poke my nose in here, I think there is a semantic disconnect in this conversation.<br><br>I think Pat means that when some SQL is executed a second time there will be (subject to the caveat below) a second PREPARE; I think Lockwood interpreted the original statement to mean that there will be two PREPAREs the first time time some SQL is executed - which would certainly call for some further explanation. [...]
9443 100 28_Re: Rows-to-columns question37_=?iso-8859-2?B?UG9zcO25aWwgRHW5YW4=?=17_DPospisil@CSAS.CZ31_Fri, 19 Jan 2007 08:44:23 +0100872_iso-8859-2 What about ---------+---------+---------+---------+---------+---------+---------+ SELECT CASE WHEN SUM(MKT_1_)>0 THEN SUM(MKT_1_) ELSE NULL END AS MKT_1_QUOTE_GRP , CASE WHEN SUM(MKT_2_)>0 THEN SUM(MKT_2_) ELSE NULL END AS MKT_2_QUOTE_GRP , CASE WHEN SUM(MKT_3_)>0 THEN SUM(MKT_3_) ELSE NULL END AS MKT_3_QUOTE_GRP FROM ( SELECT QUOTE_GRP MKT_1_,0 MKT_2_,0 MKT_3_,QUOTE_GRP GBY FROM IDAG WHERE MKT = 1 UNION ALL SELECT 0 MKT_1_,QUOTE_GRP MKT_2_,0 MKT_3_,QUOTE_GRP GBY FROM IDAG WHERE MKT = 2 UNION ALL SELECT 0 MKT_1_,0 MKT_2_,QUOTE_GRP MKT_3_,QUOTE_GRP GBY FROM IDAG WHERE MKT = 3 ) U1 GROUP BY GBY ORDER BY GBY ---------+---------+---------+---------+---------+---------+---------+ MKT_1_QUOTE_GRP MKT_2_QUOTE_GRP MKT_3_QUOTE_GRP ---------+---------+---------+---------+---------+---------+---------+ 10 10 10 20 20 --------------- --------------- 30 30 [...]
9544 172 15_Re: Use of LOBs10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 19 Jan 2007 09:15:36 +0100550_US-ASCII Just some hints I lernt working with developers for a CLOB application:<br><br>1) Don't use the maximun size of the object, but use a 'mean' size and calculate how many objects (in %) are away from it. I discovered that no object reached the maximum forecasted length, and only 1% where more 100k (when the predicted size was 250KB and more). This has a big impact on the size of VSAM for LOB object if you choose the wrong page size based on max object size. As you know you've to COPY/RECOVER LOB tablespace to increase size (in V7). [...]
9717 154 35_Re: DB2 Systems Programmer Position10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 19 Jan 2007 09:18:38 +0100909_US-ASCII Not near Venice (Italy) I suppose..... :-)))<br><br>Max Scarpa<br><br><br><br><br><br><br><br>Ruth Sutlic <Ruth_A_Sutlic@KEYBANK.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 18/01/2007 17.46 Please respond to DB2 Database Discussion list at IDUG <DB2-L@WWW.IDUGDB2-L.ORG><br><br><br><br>To DB2-L@WWW.IDUGDB2-L.ORG cc<br><br>Subject [DB2-L] DB2 Systems Programmer Position<br><br><br><br><br><br><br><br><br><br><br><br>Mainframe DB2 Database Systems Installer Full time permanent position.<br><br>Serve as DB2 technical lead for defning tasks, estimating and establishing timelines Perform database installations and upgrades as required. Perform DB2 and QMF installations and apply maintenance using SMP/e. Effectively raise priority conflicts to management. Effectively communicate with team members and supervisor. Perform BMC Tools instllations and apply maintenance as [...]
9872 293 53_Compuware September 2006 Technical Spotlight Sessions17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Fri, 19 Jan 2007 10:26:14 -0000370_us-ascii Hi All,<br><br>please find below the February schedule for Spotlight Sessions, for all you Compuware users/customers out there.<br><br>Remember, our customers are required to register for FrontLine to access these sessions, the February 6 Spotlight is a great opportunity to register and gain an insight and understanding of how FrontLine can benefit you. [...]
10166 111 53_Re: DB2 for z/OS Version 7 - converting Oracle PL/SQL12_Jim McAlpine22_Jim.McAlpine@CEDAR.COM31_Fri, 19 Jan 2007 11:30:11 -0000567_iso-8859-1 OK, forget that. The syntax is described in chapter 6 of the SQL Reference Manual.<br><br>Jim McAlpine<br><br>-----Original Message----- From: Jim McAlpine Sent: 19 January 2007 11:23 To: 'DB2 Database Discussion list at IDUG' Subject: RE: [DB2-L] DB2 for z/OS Version 7 - converting Oracle PL/SQL<br><br><br><br>Thanks James. One thought we has was that we could implement this as a stored procedure instead of a function. In the DB2 Version 7 Introduction to DB2 manual it has a sample of a procedure written with SQL Procedure Language like this - [...]
10278 99 53_Re: DB2 for z/OS Version 7 - converting Oracle PL/SQL12_Jim McAlpine22_Jim.McAlpine@CEDAR.COM31_Fri, 19 Jan 2007 11:22:57 -0000619_iso-8859-1 Thanks James. One thought we has was that we could implement this as a stored procedure instead of a function. In the DB2 Version 7 Introduction to DB2 manual it has a sample of a procedure written with SQL Procedure Language like this -<br><br>CREATE PROCEDURE ITERATOR() LANGUAGE SQL BEGIN .. DECLARE not_found CONDITION FOR SQLSTATE '02000'; DECLARE c1 CURSOR FOR ....; DECLARE CONTINUE HANDLER FOR not_found (2) SET at_end = 1; OPEN c1; ftch_loop1: LOOP FETCH c1 INTO v_dept, v_deptname, v_admdept; (1) IF at_end = 1 THEN LEAVE ftch_loop1; (3) ELSEIF v_dept = 'D01' THEN ITERATE ftch_loop1; END IF; [...]
10378 195 64_Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/re covery13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 19 Jan 2007 11:02:31 -0000544_- Brian,<br><br>Basically because the snapping isn't used for our DB2 recoveries, but for everything (i.e. non-DB2) else.<br><br>Our normal DR recovery process is to make use of the hot DASD at the DR site via PPRC, so all we do is start 'er up and off we go. If we have to fall back to our 'recover everything' process, we go back to our last archive log point. We effectively do a conditional restart to the point of the last archive - which for us will be immediately prior to the snap, because we've manually -ARCHIVEd the log at that [...]
10574 72 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Fri, 19 Jan 2007 08:25:35 -0500497_US-ASCII My thanks for James' nose-poking :) That's what I (mis)understood regarding a second prepare.<br><br>"Semantic disconnect" ?! Wow, gotta get out my Funk and Wagnals ...<br><br>- Lock Lyon Principal DBA Fifth Third Bancorp<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of James Campbell Sent: Friday, January 19, 2007 1:31 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT [...]
10647 48 25_Testing for Invalid Dates14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Fri, 19 Jan 2007 08:29:34 -0500389_US-ASCII Esteemed List:<br><br>Okay, I've forgotten this (again). I have a character column which 'usually' contains a valid date. If, however, the date is invalid (e.g., spaces) I wish to use Current Date. I tried:<br><br>SELECT DATE('11/31/2007') FROM SYSIBM.SYSDUMMY1<br><br>But instead of Null I get an SQLCode -181 (bad datetime value). I had been hoping to code something like: [...]
10696 18 63_Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Fri, 19 Jan 2007 07:36:53 -0600710_- Ray,<br><br>Thanks for that. How "current" are you at the second site when you invoke DR? It now looks like they want to go for an asynch link to the second site, with sorting out DB2 and IMS recovery "manually", rather than having PPRC POC's or whatever .<br><br>Steve<br><br>--------------------------------------------------------------------------------- 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 [...]
10715 33 29_Re: Testing for Invalid Dates8_wtrovijo19_wtrovijo@UOL.COM.BR31_Fri, 19 Jan 2007 11:50:22 -0200580_iso-8859-1 Hard to say without knowing what you're trying to do. Best way is to define it as a date column. If there's some kind of application/environment compatibility issues with date columns, I'd say that application should take the responsibility of assuring valid AND correct dates are used when inserting/updating. Also, it does not make much sense to me - again, I'm trying to figure out the whole picture - to set current date instead of a invalid date; let's say you're trying to insert some kind of expiration date to be two years from now, date is wrong you then [...]
10749 59 29_Re: Testing for Invalid Dates14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Fri, 19 Jan 2007 09:07:04 -0500518_US-ASCII I greatly simplified my example in order to protect the developers / database designers.<br><br>Here's the question, re-stated: "How, in an SQL statement, can I determine if a CHAR(8) column contains a vaild date?".<br><br>- Lock Lyon Principal DBA Fifth Third Bancorp<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of wtrovijo Sent: Friday, January 19, 2007 8:50 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Testing for Invalid Dates [...]
10809 24 29_Re: Testing for Invalid Dates8_wtrovijo19_wtrovijo@UOL.COM.BR31_Fri, 19 Jan 2007 12:20:44 -0200344_iso-8859-1 So the short answer, imho, is to handle -181.<br><br>> I greatly simplified my example in order to protect the developers / > database designers. > > Here's the question, re-stated: "How, in an SQL statement, can I > determine if a CHAR(8) column contains a vaild date?". > > - Lock Lyon > Principal DBA > Fifth Third Bancorp > [...]
10834 76 29_Re: Testing for Invalid Dates0_22_BRIAN_GOLDBERG@QVC.COM31_Fri, 19 Jan 2007 09:43:01 -0500405_US-ASCII You could write a CASE statement to parse the string for values in a range:<br><br>case when substr(test_date_char, 1, 4) > '1900' and substr(test_date_char, 1, 4) < '2100' and substr(test_date_char, 5, 2) > '00' and substr(test_date_char, 5, 2) < '13' and substr(test_date_char, 7, 2) > '00' and substr(test_date_char, 7, 2) < '32' then test_date_char else 'invalid date' end as valid_date [...]
10911 128 29_Re: Testing for Invalid Dates14_Lyon, Lockwood20_Lockwood.Lyon@53.COM31_Fri, 19 Jan 2007 09:51:31 -0500307_US-ASCII Well, with this solution I think you'd also need to consider months with < 31 days, and February in leap year. While I certainly could code such a statement, I was hoping for a simple function (or set of functions) that would return NULL (or something) if the conversion of the string failed. [...]
11040 120 35_Re: DB2 Systems Programmer Position12_Carol Sutfin24_carol.sutfin@REGIONS.COM31_Fri, 19 Jan 2007 09:01:55 -0600470_us-ascii Max<br><br>Actually, it is in one of the colder, snowier places in the U.S.<br><br>Otherwise, I would apply for the spot.<br><br>Carol Sutfin Corporate DBA Regions Financial Corp. (205)261-5214 carol.sutfin@regions.com<br><br><br><br><br><br>Max Scarpa <Massimo.Scarpa@P HOENIXSPA.IT> To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List <DB2-L@IDUGDB2-L. Subject ORG> Re: [DB2-L] DB2 Systems Programmer Position<br><br>01/19/2007 02:18 AM [...]
11161 40 42_Re: OS/390 offsite disk mirroring/recovery14_Avram Friedman25_ibmsysprog@GEEK-SITES.COM31_Fri, 19 Jan 2007 08:57:22 -0600369_- Few got-you's I have experienced with this sort of recovery are:<br><br>Lots of pages in the LPL at the remote site. Remember do the recovery test at quite times the first few tests to stablize procedures Then at peek time ... disasters ALWAYS happen at the worst possible time<br><br><br><br>CF / SYSPLEX management Its more than just an IPL of the base system [...]
11202 22 30_DB2 7.1 for z/OS Text extender11_Mick Norman18_db2bloke@GMAIL.COM31_Fri, 19 Jan 2007 08:57:20 -0600317_- Hello,<br><br>A colleague has passed to me a rumour that Text Extender for DB2 v7.1 on z/OS will no longer be available under z/OS V1.7. Does anybody know if this is true, or can point me to a place in the literature that might have this announcement?<br><br>Regards<br><br>Mick Norman<br><br>DB2 DBA ACS Inc. [...]
11225 360 29_Re: Testing for Invalid Dates15_Mike Hutchinson24_mike.hutchinson@JNLI.COM31_Fri, 19 Jan 2007 10:19:57 -0500522_US-ASCII Lockwood: I'm guessing you might be able to set-up a LOCAL non-default DB2 exit which returns null for invalid values, and then code CHAR(HIREDATE, LOCAL) during the retrieval. See the dsnagj13.pdf appendices.<br><br>Mike Hutchinson Sr Applications DBA Jackson National Life<br><br><br><br><br><br><br><br>"Lyon, Lockwood" <Lockwood.Lyon@53.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 01/19/2007 09:53 AM Please respond to DB2 Database Discussion list at IDUG <DB2-L@WWW.IDUGDB2-L.ORG> [...]
11586 356 29_Re: Testing for Invalid Dates15_Mike Hutchinson24_mike.hutchinson@JNLI.COM31_Fri, 19 Jan 2007 10:27:21 -0500457_US-ASCII But a UDF returning NULL when the date is invalid would have less system-wide impact. At least it's simple to use once it's coded.<br><br>Mike Hutchinson Sr Applications DBA 517-367-3488 (x23488) Jackson National Life<br><br><br><br><br><br>"Lyon, Lockwood" <Lockwood.Lyon@53.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 01/19/2007 09:53 AM Please respond to DB2 Database Discussion list at IDUG <DB2-L@WWW.IDUGDB2-L.ORG> [...]
11943 57 34_Re: DB2 7.1 for z/OS Text extender13_Pearson, Eric19_Eric.Pearson@53.COM31_Fri, 19 Jan 2007 10:26:33 -0500363_US-ASCII If you get an answer on this, please post here. I would be very glad not to be in the Text Extender business!<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Mick Norman Sent: Friday, January 19, 2007 9:57 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] DB2 7.1 for z/OS Text extender [...]
12001 66 87_Re: ***SPAM*** Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/re covery11_Tom Moulder30_tom.moulder@TREXASSOCIATES.COM31_Fri, 19 Jan 2007 09:41:56 -0600636_us-ascii <snip><br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: Friday, January 19, 2007 5:03 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: ***SPAM*** Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery<br><br>So the snaps aren't for us, nor are they used by us. They're hangovers from a previous DR strategy we used to have, involving stopping the subsystems (you can stop laughing now), and should be removed. However if you're using the snap copies for your DR then yes, it might be a good idea to suspend the log while you snap. [...]
12068 81 88_Re: [Maybe Spam] Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/recovery13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 19 Jan 2007 15:34:12 -0000606_- Steve,<br><br>Ordinarily we're bang up-to-date. Well, kind of. In a real DR 'invocation' we'd be bang up-to-date, as PPRC will have been faithfully replicating updates in realtime. Any inflight/indoubt URs will be dealt with automagically when DB2 comes up at the DR site. I hope.<br><br>Our actual DR test involves starting up at a pre-arranged 'disaster' point. That point is established each night during our regular processing, when we snap all the volumes we'll need. Currently we suspend the DB2 log during that 4 minute period, but it's pointless for us in a 'real' DR as we'll rely on PPRC, [...]
12150 16 15_Re: Use of LOBs33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 19 Jan 2007 09:46:48 -0600339_- Bob<br><br>I must admit, that I have no experience with lobs, but I would not recommend lobs for a scratch pad area. I think update and deletes are difficult with lobs with respect to reusing space. I would split the data in several rows, e.g. with a counter per key, and store those rows in a table with 8K, 16K or 32K row-length. [...]
12167 10 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT10_Steve Lamb25_steven.lamb@CAPGEMINI.COM31_Fri, 19 Jan 2007 10:29:53 -0600491_- Get yet what out?!<br><br>--------------------------------------------------------------------------------- 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
12178 147 29_Re: Testing for Invalid Dates13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 19 Jan 2007 11:43:37 -0500334_us-ascii Marty Kenney Sr. DB2 DBA (919) 651-5211<br><br>The following SQL does not check for invalid years, and I was much to lazy to do leap year checking, but other than those two scenerios it should do what you want (date entered if valid, current date if not valid).<br><br>SELECT CASE WHEN INT(SUBSTR('04/31/2007',1,2)) = 1 [...]
12326 56 61_Recall: Compuware September 2006 Technical Spotlight Sessions17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Fri, 19 Jan 2007 17:01:42 -0000443_us-ascii Dell'Anno, Aurora would like to recall the message, "Compuware September 2006 Technical Spotlight Sessions". The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. [...]
12383 311 52_Compuware February 2006 Technical Spotlight Sessions17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Fri, 19 Jan 2007 17:02:15 -0000480_us-ascii SORRY FOR THE RE-SEND, WRONG MONTH IN THE LAST TITLE... WELL IT'S FRIDAY...<br><br>===================<br><br>Hi All,<br><br>please find below the February schedule for Spotlight Sessions, for all you Compuware users/customers out there.<br><br>Remember, our customers are required to register for FrontLine to access these sessions, the February 6 Spotlight is a great opportunity to register and gain an insight and understanding of how FrontLine can benefit you. [...]
12695 26 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT7_P Adhia20_padhia@MYREALBOX.COM31_Fri, 19 Jan 2007 12:26:40 -0500478_ISO-8859-1 Patrick Bossman wrote: > Dynamic SQL subject to REOPT(VARS) will not be cached. However, the SQL > will undergo two prepares. > Just for my clarification. Will the SQL not go to the cache, or the plan for the cached SQL will not be used? I am just asking because, let's say, if I were to run a large mix of dynamic SQLs and with REOPT(VARS) option, then of course they'll be reoptimized; but will these SQLs be cached for use by some other non REOPT(VARS) plan? [...]
12722 14 49_Re: DB2V7-Z/OS - DISABLE CACHED DYNAMIC STATEMENT15_Patrick Bossman18_bossman@US.IBM.COM31_Fri, 19 Jan 2007 11:37:38 -0600621_- Dynamic SQL executed from within a package / plan bound with REOPT(VARS/ALWAYS) will neither search nor populate the cache.<br><br>Happy Friday, Pat<br><br>--------------------------------------------------------------------------------- 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
12737 239 64_Re: [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/re covery11_Bear, Brian23_Brian.Bear@CHARMING.COM31_Fri, 19 Jan 2007 12:50:58 -0500466_US-ASCII Ray,<br><br>Thanks. I thought I was missing something about NOT having to do the SET LOG SUSPEND during our flash copy. Again thanks for the clarification.<br><br>Regards.<br><br>Brian. Charming Shoppes.<br><br>-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] Sent: Friday, January 19, 2007 6:03 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] OS/390 offsite disk mirroring/re covery [...]
12977 160 29_Re: Testing for Invalid Dates15_Philip Sevetson22_db2.dba.guru@GMAIL.COM31_Fri, 19 Jan 2007 14:06:05 -0500588_ISO-8859-1 Marty,<br><br>This is good work. You obviously have too much time on your hands, or a sick and twisted obsession with getting SQL to do everything.<br><br>--Phil<br><br><br><br>On 1/19/07, Kenney, Marty <Marty.Kenney@railinc.com> wrote: > > Marty Kenney > Sr. DB2 DBA > (919) 651-5211 > > The following SQL does not check for invalid years, and I was much to > lazy to do leap year checking, but other than those two scenerios it > should > do what you want (date entered if valid, current date if not valid). > > SELECT CASE WHEN INT(SUBSTR('04/31/2007',1,2)) = 1 > THEN [...]
13138 64 23_Job Description for DBA16_Nichols, Suzanne27_Suzanne_Nichols@KYFBINS.COM31_Fri, 19 Jan 2007 15:51:47 -0500649_us-ascii Listers,<br><br>Please send a sample DBA job description if you have one. My boss is rewriting ours and would like more input.<br><br>Thanks for any help.<br><br>Suzanne<br><br>--------------------------------------------------------------------------------- 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
13203 93 18_Contokens under V819_Wasserman, Hirschel27_Hirschel.Wasserman@ICBC.COM31_Fri, 19 Jan 2007 12:52:28 -0800382_us-ascii Could someone please explain .... For recently complied programs...<br><br>In the DBRMLIB, the contoken appears in hex as 18009A48 106C7357 (blanks inserted for readability)<br><br>In the load modules, the contoken appears as 18009A48 00180280 106C7357.<br><br>i.e. it appears that a constant (even from program to program) x'00180280' is inserted in the load module. [...]
13297 180 22_Re: Contokens under V815_Pradeep Gunjala31_Pradeep_Gunjala@TAX.STATE.NY.US31_Fri, 19 Jan 2007 16:06:00 -0500389_ISO-8859-1 If you are in V8 NFM and compiling with NEWFUN(YES), then the DBRM is in unicode format. According to IBM manual CONTOKEN is stored as FOR BIT DATA, so the conversion will not take place to EBCDIC when you query the table, it needs explicit conversion. I am not aware of how to convert it to EBCIDIC from Unicode format. May be somebody in this list would respond on that. [...]
13478 194 29_Re: Testing for Invalid Dates0_18_iwant2beme@AOL.COM31_Fri, 19 Jan 2007 16:13:27 -0500797_us-ascii Another convoluted way: * 0000-PREPARE-DATE-CHECK. * 1. DROPS AND DECLARES TEMPORARY TABLE TO VALIDATE INPUT * DATE *************************************************************** * 0000-PREPARE-DATE-CHECK. * EXEC SQL DROP TABLE SESSION.CKDT END-EXEC.<br><br>EXEC SQL DECLARE GLOBAL TEMPORARY TABLE SESSION.CKDT ( CKDT_TMSTMP TIMESTAMP NOT NULL ) END-EXEC. *<br><br>IF SQLCODE NOT = 0 <snip> PERFORM 9500-FORMAT-OUTMSG THRU 9500-FORMAT-OUTMSG-EXIT PERFORM 9999-RETURN-ERROR THRU 9999-RETURN-ERROR-EXIT END-IF. * 0110-VALID-DATE. MOVE ' ' TO WS-VALID-UPDDATE. MOVE CHARDATE TO WS-UPDATE * PERFORM 185-VALIDATE-DATE THRU 185-VALIDATE-DATE-EXIT. IF WS-VALID-UPDDATE NOT = 'Y' MOVE '0110-VALID-DATE ' TO P-OUTMSG-PARG <snip> PERFORM 9999-RETURN-ERROR THRU 9999-RETURN-ERROR-EXIT END-IF. [...]
13673 110 22_Re: Contokens under V89_Mike Bell21_mbell11a1@VERIZON.NET31_Fri, 19 Jan 2007 15:20:04 -0600450_US-ASCII The information in SYSIBM.SYSPACKSTMT and SYSSTMT is exact copy of the DBRM. The CONTOKEN is NOT stored in unicode. neither is the rest of the DBRM header (the first 2 line in the DBRM member). This includes the DBRM name, contoken, version and other stuff that is defined in header. The SQL text is only unicode if the precompile specified newfun(yes) in V8. Then the SQL text in both the SYSSTMT and SYSPACKSTMT will also be unicode. [...]
13784 20 39_UDB v9.1 on Linux - tablespace question14_Bruce Lightsey30_Bruce.Lightsey@ITS.STATE.MS.US31_Fri, 19 Jan 2007 15:48:10 -0600402_US-ASCII We have discovered that we will need a large tablespace to be > 2 terrabytes in size. Said tablespace is currently defined with 4k pages and we would like to move to 16k or 32k page size. What would be the preferred method to do this - very little is loaded right now and I'd like to get this cured before serious loading begins. FYI this is to store raster data in a GIS implementation. [...]
13805 30 40_DB2 Connect - db2syscs.exe & db2diag.log16_Natalie Faulkner21_nfaulkner@WVADMIN.GOV31_Fri, 19 Jan 2007 15:40:19 -0600461_ISO-8859-1 I’m an old mainframer who has recently inherited our DB2 Connect Server and Software so please speak s-l-o-w-l-y !!!!<br><br>I have 2 questions...<br><br>1) db2syscs.exe pegged our DB2 Connect box this morning and only allowed minimal traffic to go through to the enterprise server... I have looked through db2diag.log and couldn't find anything abnormal. Any ideas on where I could find further log information or what may have caused this ??? [...]
13836 76 44_Re: DB2 Connect - db2syscs.exe & db2diag.log8_Dan Tuck18_dan.tuck@GMAIL.COM31_Fri, 19 Jan 2007 15:54:00 -0600608_ISO-8859-1 For your second question, deleting the file will not cause DB2 any troubles (as long as you don't need the info). DB2 will create a new empty file.<br><br>For your first question, I would also be interested in that answer.<br><br><br><br>On 1/19/07, Natalie Faulkner <nfaulkner@wvadmin.gov> wrote: > > I'm an old mainframer who has recently inherited our DB2 Connect Server > and Software so please speak s-l-o-w-l-y !!!! > > I have 2 questions... > > 1) db2syscs.exe pegged our DB2 Connect box this morning and only allowed > minimal traffic to go through to the enterprise server... I have [...]
13913 64 43_Re: UDB v9.1 on Linux - tablespace question8_Dan Tuck18_dan.tuck@GMAIL.COM31_Fri, 19 Jan 2007 15:56:44 -0600594_ISO-8859-1 Changing tablespace page size means dropping and recreating the tablespace. Or creating a near duplicate tablespace, with the new page size, and corresponding objects.<br><br>On 1/19/07, Bruce Lightsey <Bruce.Lightsey@its.state.ms.us> wrote: > > We have discovered that we will need a large tablespace to be > 2 > terrabytes in size. Said tablespace is currently defined with 4k pages and > we would like to move to 16k or 32k page size. > What would be the preferred method to do this - very little is loaded > right > now and I'd like to get this cured before serious loading [...]
13978 107 32_FOR BIT DATA and GENERATE UNIQUE19_Wasserman, Hirschel27_Hirschel.Wasserman@ICBC.COM31_Fri, 19 Jan 2007 13:57:21 -0800548_US-ASCII How essential is it to specify FOR BIT DATA for columns to be populated with GENERATE UNIQUE? (We are new to Version 8 and unicode.)<br><br>Without the FOR BIT DATA, it defaults to SBCS. Is there a performance implication?<br><br>Thanks in advance..<br><br><br><br>Hirschel Wasserman<br><br>---- The GENERATE_UNIQUE function returns a bit data character string 13 bytes long (CHAR(13) FOR BIT DATA) ---- FOR subtype DATA Specifies a subtype for a character string column, which is a column with a data type of CHAR, VARCHAR, or CLOB. [...]
14086 227 27_Re: Job Description for DBA9_Dee Reins24_dee.reins@CENTURYTEL.COM31_Fri, 19 Jan 2007 16:04:27 -0600414_us-ascii I would check job recruiting websites.<br><br><br><br><br><br>If this is not perspicuous please let me know. Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell<br><br>_____<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Nichols, Suzanne Sent: Friday, January 19, 2007 12:52 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: [DB2-L] Job Description for DBA [...]
14314 85 65_Re: [Maybe Spam] [DB2-L] DB2 Connect - db2syscs.exe & db2diag.log13_Bell, Raymond22_raymond.bell@LANDG.COM31_Fri, 19 Jan 2007 22:39:06 -0000328_iso-8859-1 Hi Natalie,<br><br>1) Dunno. I'm a mainframer too - mostly - but also dabble in the black art that is UDB on Windows. Unfortunately I'm not au fait (I'm doing French evening classes on a Tuesday - does it show?) enough with the various services to know what that one is, let alone why it might nail your server. [...]
14400 71 36_Re: FOR BIT DATA and GENERATE UNIQUE11_Suresh Sane21_data_arch@HOTMAIL.COM31_Fri, 19 Jan 2007 16:58:19 -0600350_- Hirschel,<br><br>This is not a performance issue but one of data consistency.<br><br>If you plan to access this data from the mainframe only (for ever and ever...), leaving out the FOR BIT DATA is OK.<br><br>If not, you will get undesirable translation. This is just like any encrypted data such as passwords which you do NOT want translated. [...]
14472 254 27_Re: Job Description for DBA13_BOND Victor A30_Victor.A.BOND@ODOT.STATE.OR.US31_Fri, 19 Jan 2007 15:23:45 -0800516_us-ascii Dee, I don't think DBAs can use the word 'perspicuous'.<br><br>________________________________<br><br>From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Dee Reins Sent: Friday, January 19, 2007 2:04 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Job Description for DBA<br><br><br><br><br><br>I would check job recruiting websites.<br><br><br><br><br><br>If this is not perspicuous please let me know. Dee Reins 360 905-7343 Business 360 905-7212 Fax 360 608-5262 Cell [...]
14727 146 22_Re: Contokens under V819_Wasserman, Hirschel27_Hirschel.Wasserman@ICBC.COM31_Fri, 19 Jan 2007 15:53:43 -0800389_US-ASCII Thanks Mike .. You are spot on. We are PLI shop and it just how the compiler stores the constants and initialises the SQLPLIST structure. DCL 1 SQLPLIST6 UNALIGNED , 2 SQLPLLEN FIXED BIN(15) INIT(64), 2 SQLFLAGS FIXED BIN(15) INIT(0), 2 SQLCTYPE FIXED BIN(15) INIT(50), 2 SQLPROGN CHAR(8) INIT('TESTV8Y '), 2 SQLTIMES(2) FIXED BIN(31) UNALIGNED INIT(402712004,91975265), etc [...]
14874 312 29_Re: Testing for Invalid Dates13_Kenney, Marty24_Marty.Kenney@RAILINC.COM31_Fri, 19 Jan 2007 20:43:15 -0500625_us-ascii If a program will work for you then the very simple SQL stored procedure works fine:<br><br><br><br><br><br>CREATE PROCEDURE AMPSPASD.NAK1<br><br>(INOUT DATE_INPUT CHAR(10))<br><br>FENCED<br><br>EXTERNAL NAME 'NAK1'<br><br>DYNAMIC RESULT SETS 0<br><br>LANGUAGE SQL<br><br>NOT DETERMINISTIC<br><br>READS SQL DATA<br><br>NO DBINFO<br><br>COLLID AMPSPASD<br><br>WLM ENVIRONMENT DB2BSTLD<br><br>ASUTIME NO LIMIT<br><br>STAY RESIDENT NO<br><br>SECURITY DB2<br><br>RUN OPTIONS 'MSGFILE(SYSOUT,FBA,121,0,ENQ)'<br><br>COMMIT ON RETURN NO<br><br>P1: BEGIN NOT ATOMIC<br><br>DECLARE CONTINUE HANDLER FOR SQLSTATE '22007' [...]
15187 107 34_Re: DB2 7.1 for z/OS Text extender11_Mick Norman18_db2bloke@GMAIL.COM31_Sat, 20 Jan 2007 01:52:30 +0000618_ISO-8859-1 Apparently what has happened with z/OS 1.7 is that z/OS Text Search, which DB2 Text Extender needs to function, is no longer supplied as default. z/OS Text Search is however available as a no-charge download from the IBM website to allow DB2 Text Extender to function under z/OS 1.7.<br><br>Mick<br><br><br><br>On 1/19/07, Pearson, Eric <Eric.Pearson@53.com> wrote: > > If you get an answer on this, please post here. > I would be very glad not to be in the > Text Extender business! > > -----Original Message----- > From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Mick [...]
15295 90 29_Re: Testing for Invalid Dates14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Fri, 19 Jan 2007 20:28:18 -0600405_us-ascii It seems to me a simple UDF is the answer.<br><br>Pass in your text field and the current date....in the code, if it's valid, pass the text field back. If it's invalid, use the current date field. This would always return back a single (and valid) date.<br><br>You could write some SQL to interpret the text, but the permutations to cover would be significant (not to mention the overhead). [...]
15386 54 34_Re: DB2 7.1 for z/OS Text extender14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 20 Jan 2007 17:16:39 +1100655_US-ASCII However, the announcement letter for DB2 V9 Beta ( http://www.ibm.com/common/ssi/rep_ca/8/897/ENUS206-098/ENUS206-098.PDF ) is explicit: "Text Extender is removed."<br><br>So it is going to happen.<br><br>James Campbell<br><br>On 20 Jan 2007 at 1:52, Mick Norman wrote:<br><br>> > Apparently what has happened with z/OS 1.7 is that z/OS Text Search, which DB2 Text Extender > needs to function, is no longer supplied as default. z/OS Text Search is however available as a > no-charge download from the IBM website to allow DB2 Text Extender to function under z/OS > 1.7. > > Mick > > > On 1/19/07, Pearson, Eric <Eric.Pearson@53.com> wrote: [...]
15441 30 53_Re: DB2 for z/OS Version 7 - converting Oracle PL/SQL14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Sat, 20 Jan 2007 17:16:40 +1100347_US-ASCII The problem with using a SP is, while it would "work", the user SQL is still expecting a result of a function - not something returned by a call to a procedure; so you also have to change that.<br><br>Until DB2 V9, the SQL Language code is translated into C code - so you still have the overheads of the trip to a WLM address space. [...]
15472 80 44_Re: DB2 Connect - db2syscs.exe & db2diag.log23_Walter Trovijo Jr (UOL)19_wtrovijo@UOL.COM.BR31_Sat, 20 Jan 2007 12:02:14 -0300565_iso-8859-1 Natalie,<br><br>Is it a wintel box? If so, your second question partially answers the first one. Windows is the only software that burns; yes, like a bulb. It works for some time - even several years in some cases - but one day it will burn, you have to reinstall it. I've had this problem 3 times over last 7 years with our DB2 Connect servers, and we only have half-dozen servers like this; from time to time you have to install everything from scratch. Other suspects are hw problems, like a malfunctioning hdd, it does not generate any messages [...]
15553 150 29_Re: Testing for Invalid Dates23_Walter Trovijo Jr (UOL)19_wtrovijo@UOL.COM.BR31_Sat, 20 Jan 2007 12:39:38 -0300492_iso-8859-1 Jacquie, I've suggested a program already but Lyon didn't seem to like it.<br><br><br><br>Anyway, I'd code something like this:<br><br>SELECT DATE(COLUMN_NAME) INTO :COLUMN-NAME FROM OWNER.TBNAME WHERE COL=:KEY-VALUE<br><br>IF SQLCODE = -181 PERFORM DISPLAY 'INVALID DATE ' COLUMN-NAME ', RECORD ' KEY-VALUE END-PERFORM END-IF<br><br>If char column is not in a format supported by DATE function it can be converted in a valid DATE function argument using cobol move and then: [...]
15704 459 29_Re: Testing for Invalid Dates0_24_db46@DAIMLERCHRYSLER.COM31_Sat, 20 Jan 2007 14:29:21 -0500492_US-ASCII select date (date_var) from sysibm.sysdummy1;<br><br>The table sysibm.sysdummy1 is a one row, one column table specifically designed for such things (like date, time, timestamp verification);<br><br>Dean J. Burchill 248-576-8319 (8) 776-8319<br><br><br><br><br><br><br><br>Mike Hutchinson <mike.hutchinson@JNLI.COM> Sent by: DB2 Data Base Discussion List <DB2-L@IDUGDB2-L.ORG> 01/19/2007 10:27 AM Please respond to DB2 Database Discussion list at IDUG <DB2-L@WWW.IDUGDB2-L.ORG> [...]
16164 43 23_Check for Invalid Dates0_24_db46@DAIMLERCHRYSLER.COM31_Sat, 20 Jan 2007 14:32:47 -0500347_US-ASCII select date (date_var) from sysibm.sysdummy1;<br><br>The table sysibm.sysdummy1 is a one row, one column table specifically designed for such things (like date, time, timestamp verification);<br><br><br><br>Dean J. Burchill 248-576-8319 (8) 776-8319<br><br>---------------------------------------------------------------------------------
16208 29 27_Re: Check for Invalid Dates14_Peter Vanroose26_peter_vanroose@YAHOO.CO.UK31_Sat, 20 Jan 2007 21:02:23 +0100486_iso-8859-1 > select > date (date_var) from sysibm.sysdummy1;<br><br>On z/OS, from version 8 on, you may also write values (date(date_var)) instead, as was already the case on version 7 for distributed platforms.<br><br>-- Peter.<br><br><br><br><br><br><br><br><br><br>_________________________________________________________ Flyger tiden iväg? Fånga dagen med Yahoo! Mails inbyggda kalender. Dessutom 250 MB gratis, virusscanning och antispam. Få den på: http://se.mail.yahoo.com [...]
16238 113 27_Re: Job Description for DBA10_IBMsysProg25_IBMsysProg@GEEK-SITES.COM31_Sat, 20 Jan 2007 19:15:08 -0500490_iso-8859-1 Job Description for DBAMore Powerful than a Locomotive. Faster than a Speeding Bullet. Able to leap over tall buildings in a single bound.<br><br>Other duties as assigned. ----- Original Message ----- From: Nichols, Suzanne<mailto:Suzanne_Nichols@KYFBINS.COM> Sent: Friday, January 19, 2007 3:51 PM Subject: Job Description for DBA<br><br><br><br>Listers,<br><br>Please send a sample DBA job description if you have one. My boss is rewriting ours and would like more input. [...]
16352 126 27_Re: Job Description for DBA16_Lance D. Jackson30_ljackson@PANDRUEASSOCIATES.COM31_Sun, 21 Jan 2007 03:57:24 +0000525_iso-8859-1 I hope this helps...<br><br><br><br>-----Original Message----- From: IBMsysProg [mailto:IBMsysProg@GEEK-SITES.COM] Sent: Saturday, January 20, 2007 07:15 PM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Job Description for DBA<br><br>More Powerful than a Locomotive. Faster than a Speeding Bullet. Able to leap over tall buildings in a single bound.<br><br>Other duties as assigned. ----- Original Message ----- From:Nichols, Suzanne Sent: Friday, January 19, 2007 3:51 PM Subject: Job Description for DBA [...]
16479 385 27_Re: Job Description for DBA10_IBMsysProg25_IBMsysProg@GEEK-SITES.COM31_Sun, 21 Jan 2007 12:12:34 -0500288_iso-8859-1 It's about as easy to write a DBA job discription from the request as to write one for a CEO. In both cases it is easier to build a high performace best selling motor vehicle from the raw materials is a square yard of undeveloped desert property with no tools or capital. [...]
16865 286 45_Don't miss Sheryl Larson at DB2 Forum Tuesday9_Bob Brock28_brock@KRYPTON-CONSULTING.COM31_Sun, 21 Jan 2007 16:53:14 -0600473_iso-8859-1 DB2 Forum - The Southwest DB2 Users Group. Visit our webpage at: http://www.db2forum.com<br><br>Come to the 1st Quarter DB2 Forum Meeting. DB2 Forum would like to thank Compuware for sponsoring this meeting.<br><br>Date: Tuesday January 23, 2007<br><br>Location: Crowne Plaza North Dallas/Addison<br><br>14315 Midway Road<br><br>Addison, TX 75001<br><br>Phone - 972.980-8877<br><br><br><br><br><br>Registration & Continental Breakfast: 8:00 A.M. - 9:00 A.M [...]
17152 76 23_Job Description for DBA12_Rodney Krick15_rk@AFORMATIK.DE31_Mon, 22 Jan 2007 07:04:41 +0100361_ISO-8859-1 <br><br><br><br><br><br>Suzanne,<br><br>if you want a lot of good pointers for the job definition and specification, you should give a look at the book "Database Administration: Practices & Procedures by Craig S. Mullins".<br><br>@Craig -> I waited for you to give the hint, but it didn't come ;-)<br><br>Mit freundlichen Grüßen / Best regards, [...]