1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l December 2006, week 4
2 19 35_Re: V7 on z/OS - XRC, BSDS and Logs12_Adam Baldwin19_y0027528@ES.IBM.COM31_Fri, 22 Dec 2006 01:03:50 -0600558_- Thanks Tom and Amit. We have tested our system various times and have only hada problem once. What worries me is that, as Tom says, XRC works at the physical volume level. Even with BSDS and LOGS and all other subsystem files grouped into one consitstency group it seems to me that once could still encounter problems. My understanding of logging - please feel free to correct me feloow listers - is that physical writes to logs and BSDS do not always happen at the same time. Therefore a DR solution based on physical timestamps has a basic flaw. It [...]
22 16 38_Any version on z/OS - BSDS and Logging12_Adam Baldwin19_y0027528@ES.IBM.COM31_Fri, 22 Dec 2006 01:07:02 -0600307_- Can anyone clarify the relative timing of writes to the active logs and the BSDS? I know that the BSDS has the highest written RBA/LRSN and that this is updated at the end of each complete cycle of log buffers but am I correct in assuming that within the cycle there are physical writes to the logs? [...]
39 72 23_Re: z/OS download fixes10_Max Scarpa28_Massimo.Scarpa@PHOENIXSPA.IT31_Fri, 22 Dec 2006 08:43:40 +0100544_US-ASCII Hi Cathy
Apart the links posted by J. Campbell, you can go directly to PTF download page from IBM technical help web page
http://www14.software.ibm.com/webapp/set2/srchBroker/views/srchBroker.jsp?rs=112
You search the desired apar/PTF (or some words), at the bottom of the relative page there's the PTF(s) (usually more than 1) you need for your z/OS,DB2,VTAM etc version and clicking on it will bring you directly to PTF order page, so you don't need to save the link to that page that can change over time. [...]
112 372 38_Re: z/OS Db2 V8.1 CM Invalid Packages.14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 22 Dec 2006 09:13:07 -0000454_us-ascii
I would imagine so, yes
Creating a trigger changes the work that a statement is doing, so it does seem reasonable that DB2 will need to make some access path changes to take account of the triggered statement.....
Phil Grainger
CA
Product Manager
Phone: +44 (0)161 929 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752 [...]
485 12 81_Re: ODBC error using MS ACCESS and ODBC, when selecting DB2 table-data from Z/OS.10_Bill Brown21_db2_dba@BELLSOUTH.NET31_Fri, 22 Dec 2006 07:10:29 -0600581_- we also ran intothis problem. you need to contact ibm. there is a fix for this. dont have the number, sorry.
--------------------------------------------------------------------------------- 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
498 328 32_Re: Auto maintenance Windows 8.213_Rhea, Matthew24_Matthew_Rhea@CONSECO.COM31_Fri, 22 Dec 2006 08:37:53 -0500675_us-ascii If anyone's interested, here's the cause of the problem:
http://www-1.ibm.com/support/docview.wss?rs=0&q1=JR22370&uid=swg1JR22370 &loc=en_US&cs=utf-8&cc=us&lang=en
We have to upgrade to fix it.
________________________________
From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Rhea, Matthew Sent: Friday, December 15, 2006 10:55 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Auto maintenance Windows 8.2
Hello.
I'm trying to get automatic maintenance to run on windows 8.2 fixpack 10. I have set the following parms in the database: [...]
827 16 13_SIGNOFF DB2-L16_laurens Zwanepol31_lbn.zwanepol@BELASTINGDIENST.NL31_Fri, 22 Dec 2006 15:44:17 +0100891_- ------------------------------------------------------------------------------ De Belastingdienst gebruikt e-mail niet voor de uitwisseling van vertrouwelijke informatie met de burger of voor de bekendmaking van beslissingen. De Belastingdienst hanteert conventies voor het gebruik van e-mail. Deze zijn te vinden op www.belastingdienst.nl. =============================================================================
--------------------------------------------------------------------------------- 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
844 36 50_z/OS: Can I load my DCOLLECT Data into DB2 tables?7_Ed Long19_rdhm99a@PRODIGY.NET31_Fri, 22 Dec 2006 07:49:27 -0800390_iso-8859-1 Hi everyone. Santa has not found Massachusetts yet so I thought I'd ask the group.
I'd like to load my DCOLLECT data into DB2 tables; after much searching I can't find any precoded table definitions or LOAD cards. All I have so far are the SYS1.MACLIB definitions.
I have access to SAS and MXG so I do have the option of going that route, but, z/OS is easier. [...]
881 155 23_Re: z/OS download fixes7_Ale Eba15_aeba@CA.IBM.COM31_Fri, 22 Dec 2006 10:53:49 -0500890_US-ASCII Works for me link is https://www-304.ibm.com/usrsrvc/account/userservices/jsp/login.jsp?persistPage=true
Ale
"Taddei, Cathy" Sent by: DB2 Data Base Discussion List 12/21/2006 05:53 PM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] z/OS download fixes
Help! My link to download PTF's doesn't work any more, and I have not been able to find a page on IBM's web site to perform this function. Does anyone have a link that works? It seems like IBM loves to torment me by changing the location of the things I need from time to time. Thanks! Cathy Taddei ------------------------------------------------------------------------------ [...]
1037 97 31_V7 on z/OS - XRC, BSDS and Logs17_McCormack, Mark A27_mamccormack@STATESTREET.COM31_Fri, 22 Dec 2006 10:57:38 -0500404_us-ascii Adam,
We also use EMC's ASRDF. We perform normal DB2 restart at the DR site, and DB2 performs normal rollback on inflight URs. We have never needed to perform conditional restart or cold start in a DR drill. It is essential that the dasd for the whole DB2 subsystem (DB2 catalog and directory, BSDS, logs, appl data and indices, ICF catalogs, etc.) be in the same consistency group. [...]
1135 140 35_Re: V7 on z/OS - XRC, BSDS and Logs10_Sysdba AHE18_Sysdba.AHE@TNT.COM31_Fri, 22 Dec 2006 16:26:37 +0000337_US-ASCII Adam,
Our DR is also based on XRC, with everything in a single consistency group, and it works just as if there had been a power failure at the primary site.
If there was any inherent issue around pending writes to the log, BSDS or pagesets then you would have problems bringing DB2 up after a power failure. [...]
1276 230 54_Re: z/OS: Can I load my DCOLLECT Data into DB2 tables?11_Ivan Losada22_ivan.losadajuan@BDE.ES31_Fri, 22 Dec 2006 17:44:07 +0100464_us-ascii AFAIK you can make this with IBM TDS (Tivoli Decission Support), and can find some information about the tables in the product manuals.
Regards and "Feliz Navidad"
________________________________
De: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] En nombre de Ed Long Enviado el: viernes, 22 de diciembre de 2006 16:49 Para: DB2-L@WWW.IDUGDB2-L.ORG Asunto: [DB2-L] z/OS: Can I load my DCOLLECT Data into DB2 tables? [...]
1507 321 54_Re: z/OS: Can I load my DCOLLECT Data into DB2 tables?15_Michael Wickman20_Mwickman@WADDELL.COM31_Fri, 22 Dec 2006 10:43:15 -0600286_us-ascii We do this by using one of the CBT freebie REXX routines that sorted the data then produced reports. The sorted data is feed into the DB2 load utility. Been too long since we found and implemented this but my notes at the time mentions it was on file 206 of the CBT tape. [...]
1829 131 54_Re: z/OS: Can I load my DCOLLECT Data into DB2 tables?14_Amsden, John W19_John.Amsden@LFG.COM31_Fri, 22 Dec 2006 12:01:24 -0500405_iso-8859-1 Hi Ed, I have a set of DDL/DML/JCL that executes DCOLLECT and then loads the data to DB2 tables. We use the data for a set of reports to help us manage our dasd.
I would be glad to share this if it can be of use to you or anyone else. Be aware though that if you archive DB2 datasets the DCOLLECT function does not report the actual space used by an archived tablespace/indexspace. [...]
1961 232 23_Re: z/OS download fixes13_Taddei, Cathy27_Cathy.Taddei@PACIFICORP.COM31_Fri, 22 Dec 2006 09:44:23 -0800617_us-ascii Thanks, Max, and thanks to everyone else who sent links. I followed them all, and though I found various ways of obtaining PTF's, none were the page I was looking for. But I did submit a feedback to IBM, and Bill Stern came through for me with this link:
http://www-304.ibm.com/jct01004c/systems/support/z/zos/downloading.html
In my opinion, it's the best way to download PTF's -- you can paste in any number of PTF's, submit the order, and in a few minutes you get an email with a userid, password, directory, and dataset names that you retrieve from IBM's ftp site. I have automated the [...]
2194 57 76_IBM DB2 TOOLS Workbench problem? how to generate VIEW URGENT !!!!!!!!!! HELP10_Tommy Tsui19_tommytsui@GMAIL.COM31_Sat, 23 Dec 2006 22:24:01 +0800385_ISO-8859-1 Hi all, Anyone have experience to use the DB2 TOOLs to generate VIEW..
I try to generate the VIEW DDL use batch mode but failed ? anyone know how to generate
TB DB=XXDBSPAC OUTC TS IX VW END END
* it does'nt works. if I ignore the "VW" it works and run only few minutes. If I add "VW" back it run serveral hours and nerve end... anyone know why??? [...]
2252 45 66_what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time.7_he_ming17_he_ming@BAYSS.COM31_Sun, 24 Dec 2006 09:29:11 +0800193_gb2312 what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time? It is almost same, isnt it?
Best regards,
He Ming（贺 明） Mobile: 1392-500-5956,
2298 25 48_[ADMIN] - Testing server updates - please delete13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Wed, 27 Dec 2006 03:18:23 -060061_us-ascii this is a test of the latest server updates.
2324 144 70_Re: what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time.15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Wed, 27 Dec 2006 10:34:40 +0100342_GB2312 It is my understanding that L8 TCB CPU time is more like CL1 CPU Time as it includes all work done under that TCB and not only DB2 work. Newer versions of CICS permit more work to be done under that TCB in addition to the DB2 work. Depending on what version of CICS you are you may see more or less difference on the two figures. [...]
2469 46 38_how to get IBM DB2 tool trail version?7_he_ming17_he_ming@BAYSS.COM31_Wed, 27 Dec 2006 22:09:38 +0800233_gb2312 Anybody know how to get IBM DB2/ZOS tool trail version? I can get cics tools from http://www-306.ibm.com/software/os/zseries/trials/cicstools/
Best regards,
He Ming（贺 明） Mobile: 1392-500-5956,
2516 156 42_Re: how to get IBM DB2 tool trail version?13_Seibert, Dave26_Dave.Seibert@COMPUWARE.COM31_Wed, 27 Dec 2006 10:22:18 -0500448_GB2312 Hello He Ming,
I'm not aware of any free trials of IBM z/OS DB2 tools downladable. There are the free downloads of Visual Explain for DB2 for z/OS and you can download DB2 9 Enterprise Server for Windows, Linux, or Unix. And there may be stuff at Alphaworks, http://www.alphaworks.ibm.com/
Here's a site for downloads but there are no DB2 tools other than the above. http://www14.software.ibm.com/webapp/download/home.jsp [...]
2673 121 51_Re: Application Optimization and Season's Greetings17_Dell'Anno, Aurora32_Aurora.DellAnno@UK.COMPUWARE.COM31_Wed, 27 Dec 2006 17:03:24 -0000518_iso-8859-1 Frank,
how about using Strobe? You can analyse your application, pinpoint which are the most CPU intensive queries, use the EXPLAIN functionality in iStrobe, and generally manage your DB2 applications' performance (and have a look at outside/around DB2, too).
Oh, and happy holidays to you too...
ciao!
Aurora Emanuela Dell'Anno Compuware Ltd. Systems Engineer, Mainframe pre-Sales ___________________________________________________________________________________________ [...]
2795 132 32_Re: Auto maintenance Windows 8.212_tim malamphy20_timalamphy@YAHOO.COM31_Wed, 27 Dec 2006 16:44:32 -0800337_iso-8859-1 Sneaky problem...Loopbacks seem to cause as many problems as they "work around". Can't you just uncatalog the loopback entry, catalog a fake entry (or as many as you need), so that when you recatalog the loopback entry it appears farther down the list? What problem were you trying to get around with the loopback entry? [...]
2928 131 70_Re: what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time.7_he_ming17_he_ming@BAYSS.COM31_Thu, 28 Dec 2006 08:53:37 +0800642_gb2312 en, CPU cost is in CICS address space or DB2 MASTER?
Best regards,
He Ming (贺 明) Mobile: 1392-500-5956,
发件人： Moschelli Mauro 发送时间： 2006-12-27 17:52:45 收件人： DB2-L@WWW.IDUGDB2-L.ORG 抄送： 主题： Re: [DB2-L] what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time.
It is my understanding that L8 TCB CPU time is more like CL1 CPU Time as it includes all work done under that TCB and not only DB2 work. Newer versions of CICS permit more work to be done under that TCB in addition to the DB2 work. Depending on what version of CICS you are [...]
3060 23 25_[Admin] New Year Message.12_Cuneyt GOKSU19_cuneytgoksu@USA.NET31_Thu, 28 Dec 2006 14:34:14 +0200680_ISO-8859-1 Esteemed DB2-L members,
GRANT ALL ON PLEASANT.NEWYEAR, PEACEFUL.NEWYEAR, HEALTHY.NEWYEAR TO ESTEEMED DB2-L MEMBERS WITH GRANT OPTION;
Kind Regards, Cuneyt Goksu on behalf of DB2-L Team
--------------------------------------------------------------------------------- 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
3084 224 70_Re: what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time.15_Moschelli Mauro31_mauro.moschelli@SANPAOLOIMI.COM31_Thu, 28 Dec 2006 13:40:13 +0100444_GB2312 In CICS address space
regards
Mauro Moschelli SanPaoloIMI S.p.A.
IBM Certified Database Administrator - DB2 UDB V8.1 for z/OS
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG]On Behalf Of he_ming Sent: Thursday, December 28, 2006 1:54 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] what's relation between CICS L8 TCB CPU time and DB2 CL2 CPU time. [...]
3309 149 32_Re: Auto maintenance Windows 8.212_Matthew Rhea24_matthew_rhea@CONSECO.COM31_Thu, 28 Dec 2006 07:48:03 -0600361_- I made a mistake. I confused loopback entries with "plain old" remote entries. We don't have any loopback entries, so I'll have to find another cause. IBM suggested simiply uncataloging the databases and recataloging them. I'll give that a try.
Matthew
On Wed, 27 Dec 2006 16:44:32 -0800, tim malamphy wrote: [...]
3459 21 28_DB2 UDB 8.2 Auto Maintenance12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Thu, 28 Dec 2006 08:30:37 -0600422_- Matthew, Runstats are run based on activity...so if not enough activity then not run. Also, you need to define a maintenance window. You can do that via control center, configure automatic maintenance. You can see entries in db2diag.log when auto maintenance candidates are being evaluated. I have a presentation on this that I gave at some RUGS and IDUG Europe. Email me offline if you would like a copy. Hth Phil [...]
3481 35 25_LISTDEF wildcard question2_JJ16_tzs61x@YAHOO.COM31_Thu, 28 Dec 2006 07:27:03 -0800491_iso-8859-1 To all: Is there a way to wildcard all database under one LISTDEF? ie. LISTDEF J INCLUDE TABLESPACES DATABASE *
I tried with no sucess.
The best I could do is LISTDEF J INCLUDE TABLESPACES DATABASE A* INCLUDE TABLESPACES DATABASE B* etc....
Thanks for your advice
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [...]
3517 82 29_Re: LISTDEF wildcard question15_Dave Petronella24_dpetronella@PERSHING.COM31_Thu, 28 Dec 2006 10:43:46 -0500587_US-ASCII Try
LISTDEF J INCLUDE TABLESPACE A.* INCLUDE TABLESPACE B.*
Thanks. Dave. x7747
JJ To Sent by: DB2 Data DB2-L@WWW.IDUGDB2-L.ORG Base Discussion cc List [DB2-L] LISTDEF wildcard question
12/28/2006 10:27 AM
Please respond to DB2 Database Discussion list at IDUG
To all: Is there a way to wildcard all database under one LISTDEF? ie. LISTDEF J INCLUDE TABLESPACES DATABASE * [...]
3600 196 29_Re: LISTDEF wildcard question12_Ahmed Elbana20_Ahmed.Elbana@BBH.COM31_Thu, 28 Dec 2006 10:35:45 -0500651_US-ASCII Hi,
You may try that:
LISTDEF NAME1 INCLUDE TABLESPACE DBxx001.* INCLUDE TABLESPACE DBxx001.* EXCLUDE TABLESPACE DBxx001.SS*
Thanks, Ahmed.
JJ Sent by: DB2 Data Base Discussion List 12/28/2006 10:27 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] LISTDEF wildcard question
To all: Is there a way to wildcard all database under one LISTDEF? ie. LISTDEF J INCLUDE TABLESPACES DATABASE * [...]
3797 194 37_Fw: [DB2-L] LISTDEF wildcard question12_Ahmed Elbana20_Ahmed.Elbana@BBH.COM31_Thu, 28 Dec 2006 10:38:20 -0500559_US-ASCII Hi,
You may try that:
LISTDEF NAME1 INCLUDE TABLESPACE DBxx001.* INCLUDE TABLESPACE DBxx001.* EXCLUDE TABLESPACE DBxx001.SS*
Thanks, Ahmed.
----- Forwarded by Ahmed Elbana/JerseyCity/BBH on 12/28/2006 10:37 AM -----
JJ Sent by: DB2 Data Base Discussion List 12/28/2006 10:27 AM Please respond to DB2 Database Discussion list at IDUG
To DB2-L@WWW.IDUGDB2-L.ORG cc
Subject [DB2-L] LISTDEF wildcard question [...]
3992 141 41_Re: Fw: [DB2-L] LISTDEF wildcard question2_JJ16_tzs61x@YAHOO.COM31_Thu, 28 Dec 2006 07:58:01 -0800620_iso-8859-1 Hi Ahmed: I am trying to wildcard at database level. INCLUDE TABLESPACES DATABASE * Not at tablespace level. Thanks for your help anyway Joe --- Ahmed Elbana wrote:
> Hi, > > You may try that: > > > LISTDEF NAME1 INCLUDE TABLESPACE DBxx001.* > INCLUDE > TABLESPACE DBxx001.* > EXCLUDE > TABLESPACE DBxx001.SS* > > > Thanks, Ahmed. > > ----- Forwarded by Ahmed Elbana/JerseyCity/BBH on > 12/28/2006 10:37 AM > ----- > > JJ > Sent by: DB2 Data Base Discussion List > > 12/28/2006 10:27 AM > Please respond to > DB2 Database Discussion [...]
4134 186 41_Re: Fw: [DB2-L] LISTDEF wildcard question13_Bell, Raymond22_raymond.bell@LANDG.COM31_Thu, 28 Dec 2006 16:02:20 -0000595_- Joe,
Looks like you're out of luck. From the V7 Utility manual, under Listdef:
You can specify the database-name explicitly or as a pattern-matched name. DATABASE * and DATABASE % are not supported.
So what you were doing (A*, B*, etc) looks to be the only way.
Cheers,
Raymond Bell Database Administrator
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of JJ Sent: 28 December 2006 15:58 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Fw: [DB2-L] LISTDEF wildcard question [...]
4321 246 41_Re: Fw: [DB2-L] LISTDEF wildcard question14_Fazio, Richard21_RFAZIO@TRANSUNION.COM31_Thu, 28 Dec 2006 10:20:03 -0600513_US-ASCII Perhaps create a small REXX Exec to dynamically generate your control cards. Put the REXX code in the jobstep prior to your DSNUTILB step.
SQL inside the REXX code would be SELECT NAME FROM SYSIBM.SYSDATABASE
Just a thought, faz
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf Of Bell, Raymond Sent: Thursday, December 28, 2006 10:02 AM To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] Fw: [DB2-L] LISTDEF wildcard question [...]
4568 232 41_Re: Fw: [DB2-L] LISTDEF wildcard question2_JJ16_tzs61x@YAHOO.COM31_Thu, 28 Dec 2006 08:32:21 -0800584_iso-8859-1 Thanks! Joe
--- "Bell, Raymond" wrote:
> Joe, > > Looks like you're out of luck. From the V7 Utility > manual, under Listdef: > > You can specify the database-name > explicitly or as a > pattern-matched name. DATABASE * and DATABASE % are > not supported. > > So what you were doing (A*, B*, etc) looks to be the > only way. > > Cheers, > > > Raymond Bell > Database Administrator > > > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On Behalf > Of JJ > Sent: 28 December [...]
4801 231 41_Re: Fw: [DB2-L] LISTDEF wildcard question2_JJ16_tzs61x@YAHOO.COM31_Thu, 28 Dec 2006 08:33:05 -0800620_iso-8859-1 Thanks Joe
--- "Fazio, Richard" wrote:
> Perhaps create a small REXX Exec to dynamically > generate your control > cards. Put the REXX code in the jobstep prior to > your DSNUTILB step. > > SQL inside the REXX code would be SELECT NAME FROM > SYSIBM.SYSDATABASE > > Just a thought, > faz > > -----Original Message----- > From: DB2 Data Base Discussion List > [mailto:DB2-L@IDUGDB2-L.ORG] On > Behalf Of Bell, Raymond > Sent: Thursday, December 28, 2006 10:02 AM > To: DB2-L@WWW.IDUGDB2-L.ORG > Subject: Re: [DB2-L] Fw: [DB2-L] LISTDEF wildcard > question > > Joe, > [...]
5033 40 44_DB2 DBA/Director position in Westchester, NY13_Agarwal, Amit33_amit_agarwal@STANDARDANDPOORS.COM31_Thu, 28 Dec 2006 20:23:00 -0500728_us-ascii Apologize for this nontechnical post.
If you are in the market looking for a change and are willing to relocate to Westchester,NY - please contact Joe at 408/354-1602. From what I know, this position is to manage a group of DB2 DBAs(Z and unix). His email id is joe.connell@comcast.net
Amit Agarwal
--------------------------------------------------------
The information contained in this message is intended only for the recipient, and may be a confidential attorney-client communication or may otherwise be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for [...]
5074 32 59_Sendmail problem with db2 UDB v8.1 FP 12 and dasuser userid16_Harold Pritchett14_harold@UGA.EDU31_Thu, 28 Dec 2006 20:42:40 -0500589_ISO-8859-1 I am getting this error from sendmail. It appears that the administrative user is trying to send an error message, and sendmail is failing to send it because the user name is not fully qualified.
Dec 28 20:35:01 www sendmail[24715]: kBT1Z1Au024715: ruleset=check_mail, arg1=, relay=www.benyshek-hough.com [10.0.2.40], reject=553 5.5.4 ... Domain name required for sender address dasusr1 Dec 28 20:35:01 www sendmail[24715]: kBT1Z1Au024715: from=, size=0, class=0, nrcpts=0, proto=SMTP, daemon=MTA, relay=www.benyshek-hough.com [10.0.2.40] [...]
5107 358 38_Re: z/OS Db2 V8.1 CM Invalid Packages.14_Dash, Sushanta21_Sushanta.Dash@FMR.COM31_Thu, 28 Dec 2006 23:20:34 -0500592_us-ascii Hi Wayne,
When you created the trigger the trigger packages are created with the name of trigger. The packages will not be invalidated unless you do the following like dropping the reference table or alias or adding another index or column to the same table or played with any grants. As you had not done any such above listed activity which would have made the triggers invalid, the auto rebind is the result of choosing the access paths for the first time as a result of first attempt to invoke the trigger after these triggers are created. This is the [...]
5466 149 74_Re: [Maybe Spam] [DB2-L] Global change in a TSO SPUFI lib rary pos sible ?0_28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 29 Dec 2006 16:41:35 +1100658_iso-8859-1 Also File-Aid has some nifty options that allow this, I do this often.
-----Original Message----- From: Bell, Raymond [mailto:raymond.bell@LANDG.COM] Sent: Thursday, 21 December 2006 09:14 To: DB2-L@WWW.IDUGDB2-L.ORG Subject: Re: [DB2-L] [Maybe Spam] [DB2-L] Global change in a TSO SPUFI library pos sible ?
Hi George,
You've already had some good suggestions, but here's another. Do you have Ezy-Edit? Or Sleasy Edit as we call it. It'll do this very easily. Or you could set up a P-Comm (or whatever your terminal emulator software is) 'play' key and record something like S, C XYX ABC ALL, END, tab, S and hit [...]