1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l February 2003, week 3
2 13 37_Mark Hardenburg is out of the office.15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Sat, 15 Feb 2003 01:04:18 -0500350_us-ascii I will be out of the office starting 02/14/2003 and will not return until 02/18/2003.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
16 65 44_DB2 SW & Service Quality - reply to Dr Ebert10_Max Scarpa16_mscarpa@CESVE.IT31_Sat, 15 Feb 2003 21:08:57 +0100
82 95 25_Re: OT: DB2 Certification14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 17 Feb 2003 00:13:49 +1000480_US-ASCII Hmm, I did the OS/390 tests (over 2 years ago), passed and thought/still think the pass rate is pretty low. (http://listserv.ylassoc.com/cgi/wa.exe?A2=ind0011C&L=DB2-L&P=R10151 just in case you missed it)
I even managed to pass the V7 UDB certification by reading the certification guide and about 20 hours actual usage of UDB. And am I an expert? "Yes" according to IBM. Glad it's not my signature on the certificate - I like my signature to mean something. [...]
178 38 44_Re: Stored Procedure Builder: RC=-1 errno=9114_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 17 Feb 2003 00:13:49 +1000630_US-ASCII far from a TSO session at the moment, but try running a rexx with the statement say errortext(91)
Anything in the SPB WLM SPAS job log or SYSTSPRT?
James Campbell
On 13 Feb 2003 at 16:04, Waldo Tumanut wrote:
> I'm getting the following message when rebuilding a SQLJ stored procedure > for z/OS: > > CLEANUP DSNTJSPP 2291 Remove of //'SYSADM.TEST.DBRMLIB(SPB1331)' failed > with RC=-1 errno=91 > > SYSADM.TEST.DBRMLIB is a PDSE. Any ideas on what may be wrong? What can I > check? > > TIA > Waldo Tumanut > DBA, American Century > > ================================================ > To [...]
217 48 7_Re: UDF14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 17 Feb 2003 00:13:49 +1000584_US-ASCII is it a table UDF that you're trying to implement? If so, you need to write code to generate each row and format each row.
James Campbell
On 14 Feb 2003 at 10:04, Mark Anzmann wrote:
> DB2 List- > > We are attempting to implement a UDF that we found in a paper called How to > Temporarily Disable Triggers in DB2 Universal Database by Paul Yip, Erasmo > Acosta and Tony Lee (DB2Dev Domain) in an OS/390 DB2 V7 environment. > > The UDF looks like: > > CREATE FUNCTION db2admin.trigger_enabled ( > v_schema VARCHAR(128), > v_name VARCHAR(30)) [...]
266 23 27_Re: Choosing the right tool14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 17 Feb 2003 00:13:50 +1000330_US-ASCII On the SPUFI panel, specify YES to CHANGE DEFAULTS and change the output dataset record length.
James Campbell
On 13 Feb 2003 at 17:02, Janakiram Garimella wrote:
> Also, I never could obtain the output of SPUFI > in batch in a single row if the output is more than > 132 bytes. Is it possible? [...]
290 50 27_Re: Choosing the right tool12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 16 Feb 2003 21:45:04 +0200274_us-ascii Hi, As I read it , The original question was related to "SPUFI in batch" which is the name many people give to the DSNTEP2 program, and this goes with the 132 LRECL. The way to do it, is to fix the DSNTEP2 source and recompile it - if you have a PL1 compiler. [...]
341 151 25_Re: OT: DB2 Certification12_Isaac Yassin20_yassini@BEZEQINT.NET31_Sun, 16 Feb 2003 21:49:08 +0200464_us-ascii Hi, "if everybody is somebody, then nobody is anybody." (The Gondoliers, W. S. Gilbert)
Which reminds me: "nobody walks faster than me" (Alice in wonderland - L.Carol)
Isaac Yassin
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of James Campbell Sent: Sunday, February 16, 2003 4:14 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: OT: DB2 Certification [...]
493 68 34_Re: DSNACCOR Stored Procedure Info23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Sun, 16 Feb 2003 20:43:18 -0000386_- Randy excellent .. we actually got it all working on late Fri night.
I'll take a look at the book and get back to you once I have had a read.
All the best
Leslie
-----Original Message----- From: Randy Ebersole [mailto:ebersole@US.IBM.COM] Sent: Friday, February 14, 2003 10:12 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DSNACCOR Stored Procedure Info [...]
562 148 23_Re: DSN1LOGP - Question12_Subha Sivaji22_subha_sivaji@YAHOO.COM31_Sun, 16 Feb 2003 15:51:48 -0800285_us-ascii Thanks Phil and Tony.
The Names of the Archive Log files are Named in such a way . I got them from DSNJ0004 - Log map . I may have to check the access to these archive log files. Since the DBA ID I am using has SYSADM capability , I think I am fine with the Auth. [...]
711 73 27_Re: Choosing the right tool19_Janakiram Garimella20_jgarimella@YAHOO.COM31_Sun, 16 Feb 2003 16:08:06 -0800541_us-ascii Thanks Eric, Issac and James.
I thought QMF in batch would be the best option and suggested the same to the user.
Regards, Janakiram
--- Isaac Yassin wrote: > Hi, > As I read it , The original question was related to > "SPUFI in batch" which > is the name many people give to the DSNTEP2 program, > and this goes with the > 132 LRECL. > The way to do it, is to fix the DSNTEP2 source and > recompile it - if you > have a PL1 compiler. > > Isaac Yassin > > -----Original Message----- [...]
785 49 11_Re: WRTHRSH13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Mon, 17 Feb 2003 12:46:04 +1100309_iso-8859-1 Off Topic.
John, I notice you say you received no responses and yet in clearing up my db2-l box I saw three responses to your question. Did you not receive them or did you perhaps miss them? I ask as I recently received no responses for a question and wonder if there are lisr problem. [...]
835 90 59_From One to the Other: Converting from Oracle To Either DB27_Ed Long19_rdhm99a@PRODIGY.NET31_Sun, 16 Feb 2003 21:12:17 -0500418_iso-8859-1 I have to develop a portable scheme for converting an Oracle database to an identical UDB/NT or DB2/390 database. What are we missing? Is there a better way? What about an ODBC connection?
Portable means it must be easy to install at a customer site(I.E. no assumed existing 3rd party packages). There are 350 tables so every process must be capable of being generated via PERL, COBOL, or REXX. [...]
926 16 46_Re: Converting hex to text for Runstats output15_Stephen Mallett25_Stephen.Mallett@NT.GOV.AU31_Sun, 16 Feb 2003 22:10:18 -0600412_- Hi Martin,
I know I could RTFM to find out, but if it's easy for you could you give us a sample of the JCL you'd use for this?
thanks, Steve
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
943 15 50_Wayne Goodwin/CIS/TJX/TJXCOS is out of the office.13_Wayne Goodwin21_Wayne_Goodwin@TJX.COM31_Mon, 17 Feb 2003 01:01:01 -0500403_us-ascii I will be out of the office starting 02/15/2003 and will not return until 02/23/2003.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
959 67 27_AW: IBM's Xperanto Software12_Peter, Georg15_G.Peter@DZBW.DE31_Mon, 17 Feb 2003 09:45:47 +0100678_iso-8859-1 Steve,
the following link may help: http://www7b.boulder.ibm.com/dmdd/library/demos/0203xperanto/0203xperanto.ht ml
With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, EURurope e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language): http://www.dzbw.de [...]
1027 45 39_Re: development with DB2 on OS390 & GUI10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 17 Feb 2003 09:56:31 +0100418_us-ascii Hi All
I agree that GUI is in many cases a cosmetic improvement, but **THIS** simple features is very very very often indicated as brand new and great improvement (with respect to green screen) by many IT managers.Many new application (here we have some example) are the SAME of the past but ONLY with a trivial GUI interface (and you pay for 'new' thing) as it happens for a lot of DOS programs. [...]
1073 70 46_Re: Converting hex to text for Runstats output13_Martin Packer24_martin_packer@UK.IBM.COM31_Mon, 17 Feb 2003 09:03:33 +0000332_us-ascii Stephen, I think you're asking me. I've no idea what I said in my original note so could you do me a favour and either reply to the newsgroup with the original text of mine, or tell me how to retrieve it directly from the archive? (I'm not that good at listservers yet - this might be part of the learning curve.) :-) [...]
1144 28 34_Any samples on VB and DB2 BLOBs???11_Popi Dimoka24_dimokap@INTERAMERICAN.GR31_Mon, 17 Feb 2003 12:22:39 +0200559_iso-8859-7 Hello List, > i guess such topics have been previously discussed,but UNFORTUNATELY > i am not able to search the db2-l archives anymore ,due to the security > limitations our Web Admins (...) have imposed here (no comments...). We are using DB2 for OS/390 V6.1.1 and DB2 Connect V7.2 and we'd like to insert images into DB2 through a VB application (currently running on Sql Server).The base,auxiliary table ,lob tablespace etc are created and i'd like to know how to manipulate the BLOB data through VB. Any help would be highly appreciated! [...]
1173 135 13_Re: Db2 Exam.14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Mon, 17 Feb 2003 10:02:08 -0000437_iso-8859-1 No
-----Original Message----- From: HABIB Mohiden [mailto:msh_habib@YAHOO.CO.UK] Sent: 14 February 2003 23:18 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Db2 Exam.
Dear Expert,
I am planning to take the 516 exam (DB2 V7.1 for OS/390 Administration). Is it pre-requirement to pass the exam 512 (DB2 family Fundamentals) before taking 516 exam. Can I take 516 exam without taking 512 exam. [...]
1309 149 9_Db2 Exam.12_Rodney Krick30_rk@HAENCHEN.SOFTWAREZENTRUM.DE31_Mon, 17 Feb 2003 11:38:44 +0100375_ISO-8859-1 Habib, you can take them in any order. You need both to become certified. Look at http://www-1.ibm.com/certify/certs/db_index.shtml
I would recommed to take 512 first (it's easier and you get a feeling how the tests are built).
Mit freundlichen Grüßen / Best regards,
Rodney Krick Hänchen & Partner GmbH Calwer Straße 1 D-71034 Böblingen [...]
1459 56 9_Db2 Exam.12_Rodney Krick30_rk@HAENCHEN.SOFTWAREZENTRUM.DE31_Mon, 17 Feb 2003 12:01:33 +0100369_ISO-8859-1 Habib, you can take them in any order. You need both to become certified. Look at http://www-1.ibm.com/certify/certs/db_index.shtml
I would recommed to take 512 first (it's easier and you get a feeling how the tests are built).
Mit freundlichen Grüßen / Best regards,
Rodney Krick Hänchen & Partner GmbH Calwer Straße 1 D-71034 Böblingen
1516 21 50_Stored Procedures (STP) and Workload Manager (WLM)19_Thorsten Tovacovsky20_tovaco@KARLSRUHER.DE31_Mon, 17 Feb 2003 06:08:59 -0600403_- Hello List,
does someone know when the Workload Manager (WLM) determines the creation of new adress spaces for an application environment ?
We have a long running STP which was called three times at the same moment.
So the first request was running and at his end the next request start AND a second application environemt adress space was created to run the thierd request. [...]
1538 162 23_Re: DSN1LOGP - Question14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Mon, 17 Feb 2003 22:49:30 +1000516_US-ASCII Did you actually act upon Tony's response?
There is little point in providing both copies of the archive log - one is enough.
James Campbell
On 16 Feb 2003 at 15:51, Subha Sivaji wrote:
> Thanks Phil and Tony. > > The Names of the Archive Log files are Named in such a > way . I got them from DSNJ0004 - Log map . I may have > to check the access to these archive log files. Since > the DBA ID I am using has SYSADM capability , I think > I am fine with the Auth. > [...]
1701 50 30_DB2 Connect Enterprise Edition15_Foweather, Iris30_Iris.Foweather@UK.EXPERIAN.COM31_Mon, 17 Feb 2003 13:07:13 -0000628_iso-8859-1 Can anyone help with this problem please:
Problem was we moved our Test DB2 subsystem to another LPAR this weekend so the TCP/IP address changed. I changed the TCP/IP number on the DB2 Connect Server and 'test connection' worked OK. but I still could not connect my client (I got the ever helpful 'SQL SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "10061", "*", "*". SQLSTATE=08001) [...]
1752 98 34_Re: DB2 Connect Enterprise Edition10_Alice Frus16_FRUSA@BCBSIL.COM31_Mon, 17 Feb 2003 07:36:34 -0600495_us-ascii There is a 'door' on the server side that has to be 'open' to talk to the client and when you rebooted possibly this took care of it, but in our shop the AIX admins can see if you are 'getting in' to the server or not - we also get this when a firewall exists that has not had a hole punched to get in...or if going against the Mainframe there is also a 'door' that needs to be opened and talking to the AIX box, Check if someone else made a change at the same time you rebooted.. [...]
1851 72 38_Re: Any samples on VB and DB2 BLOBs???11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Mon, 17 Feb 2003 08:48:48 -0500533_iso-8859-7 You don't have to use the internet to search the archives. Send an email to LISTSERV@LISTSERV.YLASSOC.COM and use this command in the text of the message:
SEArch listname word1 > Search list archives or: word1 > IN listname FROM date1 -> From this date TODAY -> From today TODAY-7 -> In the last 7 days TO date2 -> To this date WHERE SUBJECT CONTAINS xxxx -> Only this subject AND/OR SENDER CONTAINS xxxx -> Only this author Complex boolean operations are supported, see database guide [...]
1924 26 54_Re: Stored Procedures (STP) and Workload Manager (WLM)10_Max Scarpa16_mscarpa@CESVE.IT31_Mon, 17 Feb 2003 14:58:50 +0100377_us-ascii Hi
Very briefly, WLM starts additional AS for SP basing on WLM queue for SP and when WLM is missing goals defined for SP (it's called Server Address Space Management). There are some differences if SP is called by a local client application (CICS,TSO) or via DDF, anyway as local calls inherit the priority of calling AS. Maybe your SP have high priority. [...]
1951 28 54_Frank Rosser/RoyalSunAlliance/AU is out of the office.12_Frank Rosser28_Frank_Rosser@ROYALSUN.COM.AU31_Tue, 18 Feb 2003 01:01:25 +1000592_us-ascii I will be out of the office starting 17/02/2003 and will not return until 17/03/2003.
Please contact Carey Fletcher or Mike Jaques
CAUTION - This message is intended for the addressee named above It may contain privileged or confidential information. If you are not the intended recipient of this message you must not use, copy, distribute or disclose it to anyone other than the addressee. If you have received this message in error please return the message to the sender by replying to it and then delete the message from your computer. [...]
1980 86 22_DB2 Development center15_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Mon, 17 Feb 2003 14:40:17 -0000468_- Hi list,
Just as I'd installed connect 7.2 and the relevant ptf's to enable external name usage with SPB and got it all working very nicely thank you very much, along comes V8 onto my desk.
I am having problems trying to create SQL stored procedures with V8.
By importing a procedure that was used before I can get it to build correctly after changing the name, I can also copy this procedure, change the name and SQL and it will build ok. [...]
2067 34 54_Re: Stored Procedures (STP) and Workload Manager (WLM)19_Thorsten Tovacovsky20_tovaco@KARLSRUHER.DE31_Mon, 17 Feb 2003 10:32:57 -0600337_ISO-8859-1 okay.
We have had some DDF-Threads from PC-Clients.
But first AFTER the Mega-STP-Call was finished, the WLM starts additional AS für further SPs (which where queued).
That means to me, WLM did not look periodly into the enclave. He only becames a feedback from DB2 at the End of the STP. Not sooner. [...]
2102 28 39_SQLDA name changes in COBOL coprocessor12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Mon, 17 Feb 2003 13:19:32 -0500629_us-ascii Folks, We are considering switching to the COBOL coprocessor (IGYCRCTL with SQL parm.) in place of the DB2 pre-processor (DSNHPC), and have come across a change in some of the SQLDA names; for example, the SQLDATA element is now named SQLVAR-DATA. This is somewhat inconvenient.
The SQLDA in both cases is being generated from an EXEC SQL INCLUDE SQLDA END-EXEC statement - i.e. there is no explicit SQLDA member in SYSLIB; has anyone else encountered this change, and are there any suggestions on avoiding the need to change corresponding references to the changed SQLDA names, aside from using an explicit [...]
2131 74 37_Re: DB2 SW & Service quality - Part I12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 17 Feb 2003 10:33:49 -0800480_us-ascii I've read a number of the replies to Dr. Eberts email and I don't agree with those that state that the quality of the software has gotten better with V7.
In response to Dr. Eberts three questions: 1) # of problems opened in last year - Well over a hundred. And many others taken care of by direct contact with the developers. Every single new "feature" seems to have not been tested thoroughly enough and has lots of problems when we try to productionize it. [...]
2206 50 43_Re: Follow Up Question About Text Extenders12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 17 Feb 2003 10:47:37 -0800456_us-ascii Joseph, I have installed both the Text Extender and the Net search extender. I've been away from the office for several days and in fact am now. It looks like due to the snow in the Northeast that I won't make it back in until Wednesday at the earliest. At that time, I'll send you more complete documentation on the install. There's an INFO APAR that I don't have the number with me on that describes many potential Igotchas on the install. [...]
2257 62 37_Re: DB2 SW & Service quality - Part I11_Mark Ediger22_MEDIGER@TRANSUNION.COM31_Mon, 17 Feb 2003 13:11:11 -0600578_US-ASCII Hi Myron,
I am afraid you are right for an environment with just 1 system programmer. Corners have to be cut to get the job done, but that is management's choice and certainly not the system programmer's fault. I am very fortunate to be part of an extremely talented team right now, but I have been in small shops most of my career. I have found, as a rule-of-thumb, that the time saved not doing the research prior to maintenance is small compared to the time spent investigating and correcting the problems that are sometimes introduced. But I have never [...]
2320 46 32_Re: Cognos PowerPlay transformer12_Myron Miller22_myronwmiller@YAHOO.COM31_Mon, 17 Feb 2003 11:26:05 -0800564_us-ascii I'd talk to your COGNOS support staff. What's happening is that the Server is queueing up the requests and may not be optimally tuned for multiple users. There are a number of tuning parameters for COGNOS and DB2. Plus I'd look carefully at the TCPIP and DB2 Connect settings on the server. This area makes a bit of difference as well, much more so than on an individual's PC. Its also entirely possible that the server is just flat underpowered. I've found that COGNOS uses a ton of CPU on a server and without enough horsepower, the queries take a [...]
2367 97 27_Re: Choosing the right tool0_16_khampto1@TXU.COM31_Mon, 17 Feb 2003 13:34:00 -0600326_us-ascii I've never tried it, so was just wondering, is it possible to run the actual SPUFI program (NOT DSNTEP2) in a batch job ? If so, can someone share the JCL to do so ?
Kirk Hampton DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 TXU Business Services Dallas, Texas [...]
2465 28 11_DB2 Logging15_Morris, Deborah20_DMorris@UNCH.UNC.EDU31_Mon, 17 Feb 2003 16:23:20 -0500464_iso-8859-1 According to the DB2 SQL Reference V7 Manual, you are suppose to be able to execute an alter on a tablesspace setting the LOG option to NO (i.e. alter tablespace dbname.tsname log no).
When I execute this ddl, I get the following sql code:
-109 Log No Clause is not permitted.
We are executing DB2 OS 390 V7. Can anyone tell me whether the log option is permitted or is there some trick to getting the alter statement to work. [...]
2494 43 15_Re: DB2 Logging13_Willie Favero21_wfavero@ATTGLOBAL.NET31_Mon, 17 Feb 2003 15:51:05 -0600545_us-ascii You are attempting to ALTER a LOB table space, correct?
Willie
"Morris, Deborah" wrote:
> According to the DB2 SQL Reference V7 Manual, you are suppose to be able to > execute an alter on a tablesspace setting the LOG option to NO > (i.e. alter tablespace dbname.tsname log no). > > When I execute this ddl, I get the following sql code: > > -109 Log No Clause is not permitted. > > We are executing DB2 OS 390 V7. Can anyone tell me whether the log option > is permitted or is there some trick to getting the [...]
2538 51 15_Re: DB2 Logging17_Kornblum, Kenneth24_Kenneth_Kornblum@BMC.COM31_Mon, 17 Feb 2003 15:51:04 -0600622_iso-8859-1 Hi Deborah,
I'm pretty sure LOG NO is only supported for LOB tablespaces.
Cheers! Ken Kornblum Lead Developer - Reorg Plus for DB2 BMC Software Austin (in the GREAT State of) Texas kenneth_kornblum@bmc.com
-----Original Message----- From: Morris, Deborah [mailto:DMorris@UNCH.UNC.EDU] Sent: Monday, February 17, 2003 3:23 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: [DB2-L] DB2 Logging
According to the DB2 SQL Reference V7 Manual, you are suppose to be able to execute an alter on a tablesspace setting the LOG option to NO (i.e. alter tablespace dbname.tsname log no). [...]
2590 38 15_Re: DB2 Logging10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 17 Feb 2003 15:52:56 -0600593_- Hi Deborah,
The LOG YES/NO parameter is only for LOB tablespaces. Please check if yours is a LOB tablespace.
Regards, Kals
On Mon, 17 Feb 2003 16:23:20 -0500, Morris, Deborah wrote:
>According to the DB2 SQL Reference V7 Manual, you are suppose to be able to >execute an alter on a tablesspace setting the LOG option to NO >(i.e. alter tablespace dbname.tsname log no). > >When I execute this ddl, I get the following sql code: > > -109 Log No Clause is not permitted. > >We are executing DB2 OS 390 V7. Can anyone tell me whether the [...]
2629 46 27_Re: Choosing the right tool19_Murari Selvakesavan22_MSelvakesavan@FHSC.COM31_Mon, 17 Feb 2003 16:57:58 -0500482_US-ASCII Kirk, Though I have not tried, it is my understanding that SPFUI is not supported in Batch, you have to use DB2I primary option menu.
Murari Selvakesavan. Data Resource Management. First Health Services Corp. 804.965.7601
>>> khampto1@TXU.COM 02/17/03 02:34PM >>> I've never tried it, so was just wondering, is it possible to run the actual SPUFI program (NOT DSNTEP2) in a batch job ? If so, can someone share the JCL to do so ? [...]
2676 45 15_Re: DB2 Logging12_McKown, John22_JMckown@UICIINSCTR.COM31_Mon, 17 Feb 2003 16:00:03 -0600567_- Deborah, Looking in my manual, "DB2 Universal Database for OS/390 and z/OS: SQL Reference" (SC26-9944-01), the LOG NO only seems to apply to LOB tablespace, not a normal tablespace.
-----Original Message----- From: Morris, Deborah [mailto:DMorris@UNCH.UNC.EDU] Sent: Monday, February 17, 2003 3:23 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 Logging
According to the DB2 SQL Reference V7 Manual, you are suppose to be able to execute an alter on a tablesspace setting the LOG option to NO (i.e. alter tablespace dbname.tsname log no). [...]
2722 33 58_SQL query help ............................ help required.12_abanis nayak16_abanis@LYCOS.COM31_Mon, 17 Feb 2003 14:05:47 -0800592_us-ascii Hi All,
Can anyone help me in understanding what the below SQL statement would do. I have tried looking into a some manuals and red books. I even searched the archives of this group but to no avail.
Thanks in advance.
EXEC SQL SET RESULT SETS ARRAY:WS-TABLEX:INDIC-REC FOR :WS-XX-ROWS ROWS END-EXEC.
Cheers, Ab.
_____________________________________________________________ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus [...]
2756 34 27_Re: Choosing the right tool10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Mon, 17 Feb 2003 16:34:36 -0600277_- Hi Kirk,
I think I have run SPUFI in batch before, like a normal CLIST, with all the ISPF DDname concatenations, but I don't have the JCL now. In fact, I thought that was what the original post referred to (running the actual SPUFI in batch). But I may be wrong. [...]
2791 16 11_Re: WRTHRSH11_John Vernon23_John.M.Vernon@LOWES.COM31_Mon, 17 Feb 2003 17:49:00 -0500421_- Steve, I did not receive any responses...but thank you for checking in on the subject. I'll go check archives and see what I can retrieve.
Many thanks, John
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
2808 119 27_Re: Choosing the right tool13_David S Waugh16_dsw-dba@JUNO.COM29_Mon, 17 Feb 2003 23:48:02 GMT338_- Kirk:
Take a look at the following post in the DB2-L Archives: Item #22474 (14 Feb 2001 12:26) - Re: DSNTEP2 question
It describes a technique whereby you can kludge SPUFI (real SPUFI, not DSNTEP2 or DSNTIAUL) to get it to work via 'batch' ISPF.
Never tried it (I prefer DSNTEP2), so I don't know if it works. [...]
2928 211 48_Re: Insights please--V7 LISTDEF and Image Copies13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Tue, 18 Feb 2003 11:35:24 +1100531_iso-8859-1 Hi Pantazis, I'm in the fortunate position of working in a development only environment. This means only myself and couple of other DBA's run the jobs and fix them ourselves. The future backups for production are not yet designed but I can see it being a real headache.
Regards,
Steve T
-----Original Message----- From: Pantazis Pantazi [mailto:PPantazi@LAIKI.COM] Sent: Wednesday, 12 February 2003 20:53 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Insights please--V7 LISTDEF and Image Copies [...]
3140 40 25_Re: OT: DB2 Certification13_David S Waugh16_dsw-dba@JUNO.COM29_Tue, 18 Feb 2003 00:54:05 GMT493_- And I hope the next time I have surgery, it's done by a doctor who has done the operation many times before and knows what he's doing, not by someone who just barely squeaked by in Med School and doesn't have much experience.
The Bar Exam is *worlds* tougher (and requires *many* more years of study) than the DB2 Certification exams, so it doesn't surprise me that scoring 50-60% on it is considered 'pretty good'. Other than that, there's really no comparison between the two. [...]
3181 34 47_Alex Andrade/GS/UK/Zurich is in sunny DUBAI !!!12_Alex Andrade26_alex.andrade@UK.ZURICH.COM31_Tue, 18 Feb 2003 01:00:48 +0000573_us-ascii I will be out of the office starting 14/02/2003 and will not return until 26/02/2003.
Please call Steve Jackson on 7901 1305 for any queries
___________________________________________________________________________
The information contained in this message is confidential and may be legally privileged. If you are not the intended recipient, please do not read, copy or otherwise use it and do not disclose it to anyone else. Please notify the sender of the delivery error and then delete the message from your system. [...]
3216 21 34_AIX overview for OS/390 developer?12_Gregg Sawyer26_gregg.a.sawyer@VERIZON.COM31_Mon, 17 Feb 2003 20:13:31 -0500570_us-ascii Folks, Looking for some pointers on DB2 under AIX from the perspective of an experienced OS/390 DB2 application developer. This seems too broad a subject to be covered here, so I'm after existing stores of wisdom, on the 'net or elsewhere; any suggestions would be appreciated.
Thanks,
Gregg
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3238 117 37_Re: DB2 SW & Service quality - Part I15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Mon, 17 Feb 2003 20:25:45 -0500402_- I agree completely with Myron Miller. Even though I haven't open a ticket (I did not have authority to do this, Otherwise I would have open many) I can say many new features I tried when it comes out first, it never worked properly. Think that many of these new features were available years and years back in other DBMS. Ironically DB2 is one of the old database trying to catch with new ones. [...]
3356 34 18_DB2 NT REPLICATION11_ali hasnain23_me_alihasnain@YAHOO.COM31_Mon, 17 Feb 2003 18:03:25 -0800374_us-ascii HI; I'M WORKING ON DB2 UDB NT V7.0. I'M DOING REPLICATION ON SERVER THROUGH ASNCCP AND ASNAPPLY CMD'S OR BAT FILES.
THE PROBLEM IS I DON'T WANT TO GIVE SERVER OPERATOR ANY PRIVILIGE OTHER THEN TAKING BACKUP OF THE DATABASE ON SERVER. BUT WHEN I DO THIS THE REPLICATION CMDS OR BAT FILES DOESN'T WORK CAUZ THEY/REPLICATION DEMANDS THE RIGHTS OF DBADMIN. [...]
3391 32 37_Re: DB2 SW & Service quality - Part I10_Max Scarpa16_mscarpa@CESVE.IT31_Tue, 18 Feb 2003 09:26:48 +0100471_us-ascii Hi all
I'm following with interest the discussion about SW & software quality.
I'm wondering how many people, expecially people who thinks that quality is worsening, works/worked with ORACLE or others RDMBS. I've the impression they worked or are becoming to work with them. I wonder it because their words are the same (more or less) words I heard talking about IBM mainframe with people working (previously) with BULL 'mainframes'. Strange. [...]
3424 33 9_DBArtisan13_Thomas Schulz20_thomas.schulz@SVI.DE31_Tue, 18 Feb 2003 02:37:29 -0600425_- Hello List User's
I have installed DBArtisan 7.0 on Win NT to access and maintain our Oracle Databases and DB2 6.1 Subsystems on os/390.
ZPARM definition Decimal point is comma.
Now: If DBArtisan trys to read all the tablespaces for a selected database he builds the follwoing select
select ....... substr(char(statstime),1,16) from sysibm......
This will result in -104 token 1.... [...]
3458 51 13_Re: Db2 Exam.14_Martin Flavell18_mflavell@I-TCS.COM31_Tue, 18 Feb 2003 09:06:41 +0000
3510 16 62_Re: SQL query help ............................ help required.33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 18 Feb 2003 03:25:04 -0600330_- Hi
I see, you got no response to your question. Well, I must admit, I never saw this syntax. Is that for DB2 OS/390??. Did you successfully precompile this statement? The statement looks like COBOL. Maybe it could be to work with a result set coming from a stored procedure. But I've no experiences with that stuff. [...]
3527 33 62_Re: SQL query help ............................ help required.6_Daniel15_bufes@YAHOO.COM31_Tue, 18 Feb 2003 03:25:42 -0600422_- On Mon, 17 Feb 2003 14:05:47 -0800, abanis nayak wrote:
> Hi All, > > Can anyone help me in understanding what the below SQL statement would do. I have tried looking into a some manuals and red books. I even searched the archives of this group but to no avail. > >Thanks in advance. > > EXEC SQL > SET RESULT SETS ARRAY:WS-TABLEX:INDIC-REC FOR :WS-XX-ROWS ROWS > END-EXEC. > >Cheers, >Ab. [...]
3561 19 13_Datawarehouse18_Sridharan, Sunil K23_sunil.sridharan@EDS.COM31_Tue, 18 Feb 2003 03:29:41 -0600400_iso-8859-1 Hello Listers,
Please let me know what would be the best book to Learn Data warehousing Concepts.
Regards Sunil
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
3581 78 15_Re: DB2 Logging14_Grainger, Phil20_Phil.Grainger@CA.COM31_Tue, 18 Feb 2003 09:43:02 -0000581_iso-8859-1 until V8 anyway.....
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: McKown, John [mailto:JMckown@UICIINSCTR.COM] Sent: 17 February 2003 22:00 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] DB2 Logging
Deborah, Looking in my manual, "DB2 Universal Database for OS/390 and z/OS: SQL Reference" (SC26-9944-01), the LOG NO only seems to apply to LOB tablespace, not a normal tablespace. [...]
3660 90 58_LISTDEF (Wildcarding) with IBM Reorg - anybody using this?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 18 Feb 2003 09:53:25 -0000467_utf-8 Hi all,
is anybody using the new "wildcard" feature of Reorg in V7 DB2 Z/os?
I've taken a look at it and I have to say I have found it to be, albeit workable, overly complex and not for the novice. Anybody feel the same way?
I requested wildcarding a few years back and was pleased to see they had included into the product ... I'm just amazed they have not made it simple on the surface and put all the LISTDEF junk under the covers. [...]
3751 39 38_Strange behaviour of the DB2 optimizer33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 18 Feb 2003 03:59:00 -0600521_- Hi folks
Did anybody experience the following behaviour of the DB2 OS/390 Version 7 optimizer:
SELECT ... FROM INTB0037 WHERE SAM_LNR = :H AND ((GELD_VERWE_BEL_NR = :H AND AUFT_NR >= :H) OR GELD_VERWE_BEL_NR > :H) ORDER BY SAM_LNR, GELD_VERWE_BEL_NR, AUFT_NR
Index DB2 used:
primary clustering (ratio: 99%), 609.144 leaf pages, 4 levels 122.771.927 distinct entries statstime is 2003-02-16-07.01.32.993296 key columns: 1.) SAM_LNR (asc.) 2.) GELD_VERWE_BEL_NR (asc.) 3.) AUFT_NR (asc.) [...]
3791 142 18_Development Center15_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Tue, 18 Feb 2003 10:26:54 -0000398_iso-8859-1 Hi list
Has anyone actually got the V8 Development Center to work with SQL stored procedures?
Apart from failure to build I also have issues with the fact that you can only look at the properties for a procedure once in a session, the drop of a procedure does not work at all in server view and sticks at 'in progress' in the project view, (even though it completes). [...]
3934 29 58_LISTDEF (Wildcarding) with IBM Reorg - anybody using this?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 18 Feb 2003 10:35:12 -0000465_iso-8859-1 Hi all, is anybody using the new "wildcard" feature of Reorg in V7 DB2 Z/os? I've taken a look at it and I have to say I have found it to be, albeit workable, overly complex and not for the novice. Anybody feel the same way? I requested wildcarding a few years back and was pleased to see they had included into the product ... I'm just amazed they have not made it simple on the surface and put all the LISTDEF junk under the covers. thanks Leslie [...]
3964 25 32_DB2 v6 & 64 bit Operating system12_Paul Packham26_paul.packham@ROYALMAIL.COM31_Tue, 18 Feb 2003 10:28:42 +0000300_us-ascii Hi All,
It looks like that our system programmers are trying to win the race between them and ourselves. They are rolling out the 64 bit operating system, we are upgrading DB2 from v6 to v7. So this begs the question, does DB2 v6 tolerate the 64 bit operating system (z/OS 1.2). [...]
3990 65 28_Answer: Datawarehouse (book)12_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 18 Feb 2003 11:46:58 +0100851_iso-8859-1 Sunil
I took my first learning steps on Data Warehousing with a book from Alex Berson and Stephen J. Smith.
The title is "Data Warehousing, Data Mining & Olap", published by McGraw-Hill.
The american ISBN number is 0-07-006272-2.
Hope that helps.
With kind regards - mit freundlichen Gruessen, Georg H. Peter c/o ------------------------------------------------------------------- Datenzentrale Baden-Wuerttemberg Software Development & Technology Center Knowledge Center Database Systems Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, EURurope e:mail G.Peter@dzbw.de Phone 0049-711-8108-271 PC-Fax 004971189696071 Internet (only in german language):http://www.dzbw.de ---------------------------------------------------------------------- Life's too short to be taken seriously ALL the time... [...]
4056 68 36_Re: DB2 v6 & 64 bit Operating system15_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Tue, 18 Feb 2003 10:48:52 -0000633_- yes
Cheers,
Steve McAuliffe DB2 Systems/IMS team Network Computing Group Tel: (020) 8760 6988 Internal: x 66988
-----Original Message----- From: Paul Packham [mailto:paul.packham@ROYALMAIL.COM] Sent: 18 February 2003 10:29 To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 v6 & 64 bit Operating system
Hi All,
It looks like that our system programmers are trying to win the race between them and ourselves. They are rolling out the 64 bit operating system, we are upgrading DB2 from v6 to v7. So this begs the question, does DB2 v6 tolerate the 64 bit operating system (z/OS 1.2). [...]
4125 58 36_Re: DB2 v6 & 64 bit Operating system23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Tue, 18 Feb 2003 11:38:11 -0000635_- Hi Paul
it all worked ok here ... then we went to V7 a while back and again all ok.
we are on z/Os 1.3.
Les
-----Original Message----- From: Paul Packham [mailto:paul.packham@ROYALMAIL.COM] Sent: Tuesday, February 18, 2003 10:29 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 v6 & 64 bit Operating system
Hi All,
It looks like that our system programmers are trying to win the race between them and ourselves. They are rolling out the 64 bit operating system, we are upgrading DB2 from v6 to v7. So this begs the question, does DB2 v6 tolerate the 64 bit operating system (z/OS [...]
4184 22 62_Re: LISTDEF (Wildcarding) with IBM Reorg - anybody using this?33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 18 Feb 2003 06:09:24 -0600574_- Hi
I've worked recently a few times with LISTDEF and TEMPLATE and I've got the same feeling as you. The description in the manual is sometimes unclear or incomplete.
One example: I wanted to unload all but one table of a tablespace containing 25 tables. So, I thought, I use LISTDEF with INCLUDE TABLESPACE 'my tablespace' and EXCLUDE the one table I don't want to unload. I studied the manual but found no hint, that this resulted in an empty list. I tried it many times with different codings, but always got same error message. So I reported that to [...]
4207 232 48_Re: Insights please--V7 LISTDEF and Image Copies11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Tue, 18 Feb 2003 07:29:12 -0500390_iso-8859-1 We're still on V6 and currently using BMC Copy Plus, so I've never seen IBM's V7 copy utility. When you restart a BMC copy job, he remembers where he left off and continues on from there. Are you saying that IBM's V7 copy utility, when using listdefs, doesn't do this -- that it starts at the beginning of the list of tablespaces? Or have I misunderstood what's being said? [...]
4440 40 32_Re: Answer: Datawarehouse (book)9_Ben Relle27_Ben.Relle@MORGANSTANLEY.COM31_Tue, 18 Feb 2003 12:41:41 +0000353_us-ascii Ralph Kimbal has written a number of books on this subject. I found them well written and have successfully implemented a star schema database using his books as guidance. Since implementing the original 4 dimension, single fact table design, the star has grown another 5 or so fact tables and about the same number of further dimensions. [...]
4481 40 25_Doubt in Stored Procedure29_RAGHAVAN Vadakkupattu Sampath21_VRaghava@COVANSYS.COM31_Tue, 18 Feb 2003 18:21:49 +0530393_iso-8859-1 Hi Everyone,
Kindly clarify my doubt,
We are receiving the following SQL code while executing a Stored Procedure(built with COBOL Language) calling from a COBOL program using EXEC SQL call statement.
-981 THE SQL STATEMENT FAILED BECAUSE THE RRSAF CONNECTION IS NOT IN A STATE THAT ALLOWS SQL OPERATIONS, REASON reason-code.
Reason code is 00C12216 [...]
4522 61 42_Re: Strange behaviour of the DB2 optimizer14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Tue, 18 Feb 2003 22:57:14 +1000336_ISO-8859-1 did you consider adding > AND GELD_VERWE_BEL_NR >= :H to the query? (I am assuming that the the two predicates involving GELD_VERWE_BEL_NR refer to the same column - which would be used by this.) This would allow DB2 to increase matchcols to 2.
James Campbell
On 18 Feb 2003 at 3:59, Walter Janißen wrote: [...]
4584 77 42_Re: Strange behaviour of the DB2 optimizer0_19_mike.holmans@BT.COM31_Tue, 18 Feb 2003 13:07:57 -0000314_iso-8859-1 Hi,
I can't say that I've experienced it with the V7 optimizer, but we've only been on V7 for a couple of months. I did experience an almost identical scenario with V3 and V4, though. The difference is between 99% and 100% only, though. I didn't get that sort of change between 98% and 99%. [...]
4662 19 14_cache database12_Rakesh Singh14_rasun@JUNO.COM31_Tue, 18 Feb 2003 05:09:53 -0800458_us-ascii Hi Folks, Has anybody used cache databases. They call them self post relational database and i don't know what it means. How does it compare to UDB.
Thanks for any insight
-Rakesh
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
4682 51 48_Re: Insights please--V7 LISTDEF and Image Copies16_Pantazis Pantazi18_PPantazi@LAIKI.COM31_Tue, 18 Feb 2003 15:18:38 +0200319_us-ascii I do not know how it works since I am currently at V6 and on the way to V7.
I am only trying to understand the whole concept of LISTDEF from all perspectives, in order to be prepared when the migration will be over in 2 months time, to start using the capabilities of V7 (one of which is LISTDEF). [...]
4734 101 29_Re: Doubt in Stored Procedure15_Steve McAuliffe35_Stephen.McAuliffe@BANKOFAMERICA.COM31_Tue, 18 Feb 2003 13:46:07 -0000624_- Raghaven,
Is your RRS address space running?
The 'Getting Started with DB2 Stored Procedures' guide gives some help with RRS return codes if you can find those anywhere in your logs:
12.13 Common RRSAF Errors The following are some common RRSAF error return codes. The error codes cover not having the RRS address space running, having an invalid DB2 subsystem name, and an invalid plan name. 12.13.1 IDENTIFY Return Code 8 Reason Code 15925393 When the RRS address space is not running, you get a return code 8 from the IDENTIFY function. The reason code returned is 15925393. -JOBNAME STEPNAME [...]
4836 82 42_Re: Strange behaviour of the DB2 optimizer33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 18 Feb 2003 07:53:15 -0600542_ISO-8859-1 On Tue, 18 Feb 2003 22:57:14 +1000, James Campbell wrote:
Hello James
Well for this query, I overlooked it, but in general we advised our developers to use that kind of coding in all cursors used for repositioning. I explained the statement with your hint and clusterratio 99 and I get my desired access path. But why on the other hand is 1% that important, that DB2 decides to do an additional sort. The bigger the estimated result set would be the more undesirable would be a sort. [...]
4919 73 15_Decimal problem16_Raoul A. Joemman30_Raoul.Joemman@NL.MARTINAIR.COM31_Tue, 18 Feb 2003 14:57:35 +0100348_us-ascii Hi all,
We have some problems with the decimal function. See the query and query-output below. The query works fine on DB2/6000 for AIX. But for DB2 on OS/390 the decimal results are wrong. When using the float function the results are as espected. On both AIX and OS/390 we use DB2 v7.2 Have you ever had these same problems? [...]
4993 126 29_Re: Doubt in Stored Procedure13_Johnny Wilder28_Johnny.Wilder@MOTION-IND.COM31_Tue, 18 Feb 2003 08:07:33 -0600354_iso-8859-1 I have a COBOL program that calls a COBOL Stored Procedure. I do not use RRSAF (DSNRLI) in the calling program. I use Call Attach (CAF) (DSNALI) in the calling program to attach to DB2. The methods for using both are similar from the documentation I have seen for RRSAF. I will give you an example using CAF to see if this will help you. [...]
5120 120 19_Re: Decimal problem11_Moyeen Khan25_mak44@DAIMLERCHRYSLER.COM31_Tue, 18 Feb 2003 09:34:31 -0500411_us-ascii Try reducing the number of digits from 23 to 15 SELECT 26.000260 / 286.000000 , DECIMAL (26.000260,09,6) / DECIMAL (286.000000,09,6) , DECIMAL (DECIMAL(26.000260,09,6) / DECIMAL (286.000000,09,6) ,09,6) , FLOAT (26.000260) / FLOAT (286.000000) , DECIMAL ( FLOAT (26.000260) / FLOAT (286.000000) , 09,6) FROM SYSIBM.SYSDUMMY1 ;
Result:_
0.0909100 0.090910 0.090910 9.091E-02 0.090910 [...]
5241 12 42_Re: Strange behaviour of the DB2 optimizer33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Tue, 18 Feb 2003 08:57:02 -0600337_- Mike
The table in question has over 100M rows. So your assumption holds.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5254 27 8_00f3009114_Robert Niemiec23_rniemiec@KRAKOW.TPSA.PL31_Tue, 18 Feb 2003 16:23:06 +0100440_us-ascii When I run EzJava.class on z/OS I get message:
SQLException: DB2SQLJConnection error in native method: constructor: RRS "IDENIFY" failed using DB2 system:DB2T, RC=08 and REASON=00f30091 SQLSTATE=FFFFF and SQLCODE=-1
EzJava is the sample program from book: "Application Programming Guide and Reference for Java" version 7
I did all needed installation steps.
Thanks in advance
Robert Niemiec [...]
5282 166 27_Re: Choosing the right tool0_16_khampto1@TXU.COM31_Tue, 18 Feb 2003 09:05:26 -0600506_us-ascii Thanks, David. Wow, that does look kludgy, so I guess it's possible, however not very practical, which I suppose is why they wrote DSNTEP2.
Kirk Hampton DB2 OS/390 Sysprog IBM Certified Solutions Expert - DB2 V7 Database Administration OS/390 TXU Business Services Dallas, Texas
David S Waugh cc: Sent by: DB2 Data Subject: Re: Choosing the right tool Base Discussion List [...]
5449 68 12_AW: 00f3009112_Peter, Georg15_G.Peter@DZBW.DE31_Tue, 18 Feb 2003 16:42:40 +0100472_iso-8859-1 00F30091
Explanation: The application program issued an RRSAF IDENTIFY function request, but RRS/MVS is not available.
System Action: The IDENTIFY request is not processed.
Module: CSQ3ID30
User Response: Retry the IDENTIFY request after RRS/MVS has been started.
An additional idea: Under http://www-3.ibm.com/software/data/db2/os390/odbc/service.html is an APAR mentioned for a 00F30091 problem. May be it is yours.... [...]
5518 48 51_Re: Alex Andrade/GS/UK/Zurich is in sunny DUBAI !!!15_Blaney, Bill L.21_Bill.L.Blaney@SSA.GOV31_Tue, 18 Feb 2003 10:51:20 -0500398_iso-8859-1 Sure, rub it in. I just dug out from under over 2 feet of snow!
-----Original Message----- From: Alex Andrade [mailto:alex.andrade@UK.ZURICH.COM] Sent: Monday, February 17, 2003 8:01 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Alex Andrade/GS/UK/Zurich is in sunny DUBAI !!!
I will be out of the office starting 14/02/2003 and will not return until 26/02/2003. [...]
5567 26 17_DB2 basic package15_Perryman, Brian18_BPerryman@TNSI.COM31_Tue, 18 Feb 2003 11:01:12 -0500396_iso-8859-1 Hi folks
If I were to install the base and no-charge package of DB2 V7, is there any product or utility included in it that will allow us manipulate (edit, delete, insert) database records without writing a Cobol program, ie ad-hoc time-to-time usage?
I'm thinking about if the support staff need to check out records and maybe sometimes correct errors in the data. [...]
5594 176 23_Re: DSN1LOGP - Question16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Tue, 18 Feb 2003 08:02:33 -0800576_windows-1252 Maybe you misunderstood me. I'm talking about changing the DDname, not the DSname.
Replace this: //SYSUT1 DD DSN=DB2S.ARCHLOG1.A0013308,... with this: //ARCHIVE DD DSN=DB2S.ARCHLOG1.A0013308,...
Tony Provenzola Nike Database Services Venturi Technology Partners, Consulting Phone * 503-532-0772 Fax * 503-532-3223 Email * Tony.Provenzola@nike.com
-----Original Message----- From: Subha Sivaji [mailto:subha_sivaji@YAHOO.COM] Sent: Sunday, February 16, 2003 3:52 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DSN1LOGP - Question [...]
5771 24 88_HELP I'm stumped finding an identifier to tell me what process ca used a trigger to fire16_Kelly Ray Oliver29_Kelly.Oliver@MAIL.STATE.KY.US31_Tue, 18 Feb 2003 11:20:16 -0500639_iso-8859-1 What system fields are available to triggers? I need to determine which process (i.e. transaction application,qmf,sql,batch program) caused the trigger to fire.
Kelly Oliver G.O.T. Governor's Office of Technology Commonwealth of Kentucky 100 Fair Oaks Lane Frankfort, KY 40601 Phone: (502) 564-1404 ext(4486) e-mail kelly.oliver@mail.state.ky.us Fax: (502) 564-6855
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5796 70 21_Re: DB2 basic package22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Tue, 18 Feb 2003 10:29:37 -0600677_- SPUFI (SQL Processing Using File Input).
QMF is a separately licensed product.
Venkatesh Mokshagundam Database Administrator Corporate Systems, Amarillo, TX 79102 Ph: 806-337-3374 Fax: 806-345-2736
-----Original Message----- From: Perryman, Brian [mailto:BPerryman@TNSI.COM] Sent: Tuesday, February 18, 2003 10:01 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DB2 basic package
Hi folks
If I were to install the base and no-charge package of DB2 V7, is there any product or utility included in it that will allow us manipulate (edit, delete, insert) database records without writing a Cobol program, ie ad-hoc time-to-time usage? [...]
5867 81 21_Re: DB2 basic package0_16_khampto1@TXU.COM31_Tue, 18 Feb 2003 10:31:58 -0600471_us-ascii Sure, with some caveats. Included in the base product are SPUFI, the TSO/ISPF based way of executing dynamic SQL statements, then there are two batch programs, DSNTIAD, which is a supported tool, and DSNTEP2, which is a "sample" program, meaning you get the source code, so if you alter it you suport it yourself. I beleive you also get a copy of DB2 Connect Personal, which would let you run SQL from your Windows desktop to modify the contents of tables. [...]
5949 18 21_Re: DB2 basic package15_Perryman, Brian18_BPerryman@TNSI.COM31_Tue, 18 Feb 2003 11:41:21 -0500382_iso-8859-1 Ok, thanks all.
So, presumably it would be sensible to purchase QMF as well then?
Thanks
Brian
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5968 19 21_Re: DB2 basic package14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Tue, 18 Feb 2003 10:32:46 -0600417_iso-8859-1 Brian,
you could use SPUFI online or DSNTEP2 in batch. I don't think they are a chargeable option yet.
Colin
(my opinions etc...)
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
5988 22 7_db2.log20_Borgoglio, Francesco27_F.Borgoglio@CEDACRIOVEST.IT31_Tue, 18 Feb 2003 17:53:43 +0100298_iso-8859-1 Hi gurus, this is a question for you. The platform is NT 4.0, the db2 version are 5.2 and 7.2. I ask you if the db2.log, in the db2log directory, captures all the instance and db activities, and how manage this log (i say change location, disable, and so on...). Thank you so much. [...]
6011 83 21_Re: DB2 basic package0_16_khampto1@TXU.COM31_Tue, 18 Feb 2003 11:25:18 -0600547_us-ascii As usual ,that depends. If you just want to perform ad-hoc lookup and update of DB2 table data, SPUFI can do that just fine. If you want to produce nice ad-hoc reports from your DB2 tables, then QMF has all the advantage in formatting capability over SPUFI, but at a price. Are you intending to allow ad-hoc reporting and/or updating to the client community at large, or strictly to a small support staff ? We have had QMF here pretty much since day one, but its daily use is somewhat dying out, and I don't know that every shop has [...]
6095 107 21_Re: DB2 basic package12_Higgins John26_HigginsJohnP@JOHNDEERE.COM31_Tue, 18 Feb 2003 11:55:13 -0600685_iso-8859-1 No one else has mentioned this, but I find Excel via ODBC useful.
Best regards, John P. Higgins
-----Original Message----- From: khampto1@TXU.COM [mailto:khampto1@TXU.COM] Sent: Tuesday, February 18, 2003 11:25 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 basic package
As usual ,that depends. If you just want to perform ad-hoc lookup and update of DB2 table data, SPUFI can do that just fine. If you want to produce nice ad-hoc reports from your DB2 tables, then QMF has all the advantage in formatting capability over SPUFI, but at a price. Are you intending to allow ad-hoc reporting and/or updating to the client [...]
6203 22 38_What is the best book for dsm for AIX?10_Shi, Zhong23_Zhong.Shi@INCEPTURE.COM31_Tue, 18 Feb 2003 14:44:55 -0500428_iso-8859-1 List Expert,
Can any of you recommend me a good book or a good link of the book for dsm on AIX? Thank you in advance.
Zhong Shi DBA Incepture, Inc.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
6226 191 27_Re: Choosing the right tool13_David S Waugh16_dsw-dba@JUNO.COM29_Tue, 18 Feb 2003 19:53:40 GMT426_- You're right Kirk -- it doesn't look very practical. You could probably put the majority of the JCL in a parameterized JCL PROC and just execute the PROC, but still... Kludgy.
That reminds me...
Over the years, I've occasionally heard that there's a COBOL version of DSNTEP2 floating around (that somebody apparently took the time to re-write from PL/I to COBOL). Never actually seen a copy of it though. [...]
6418 31 27_Re: Choosing the right tool12_Jim Harrison12_jimh@QIS.NET31_Tue, 18 Feb 2003 15:34:22 -0500379_us-ascii There is a shareware program that replicates TEP2's function and then some. I just Googled it and came up with this URL. I seem to recall getting it at a UK DB2 web site originally. Been using it for several years now with good results.
http://www.gseukdb2.org.uk/shareware.htm
At 07:53 PM 2/18/2003 +0000, David S Waugh said: [...]
6450 231 27_Re: Choosing the right tool11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Tue, 18 Feb 2003 15:44:58 -0500358_iso-8859-1 You get the object module for DSNTEP2 with DB2 V6. So now you only have to link and bind it.
Here's something I found that may help you reformat output of DSNTEP2: http://www.mainframeweek.com/code/showcode.php/0031/mw31db21.txt. Not exactly what you want, but maybe it will suffice. I just found it on the net, so I haven't tried it. [...]
6682 49 92_Re: HELP I'm stumped finding an identifier to tell me what process ca used a trigger to fire13_LOMBARD,Shaun25_shaun.lombard@DEWR.GOV.AU31_Wed, 19 Feb 2003 07:54:34 +1100482_US-ASCII Will CURRENT SQLID do ?
-----Original Message----- From: Kelly Ray Oliver [mailto:Kelly.Oliver@MAIL.STATE.KY.US] Sent: Wednesday, February 19, 2003 3:20 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: HELP I'm stumped finding an identifier to tell me what process ca used a trigger to fire
What system fields are available to triggers? I need to determine which process (i.e. transaction application,qmf,sql,batch program) caused the trigger to fire. [...]
6732 43 47_EDBAB016/EDBAB017 COBOL replacement for DSNTEP213_David S Waugh16_dsw-dba@JUNO.COM29_Tue, 18 Feb 2003 21:12:01 GMT569_- Ooooohhh - Thanks Jim (and Tony, who sent it to me off-line). This should come in REALLY handy!
David
---------- Jim Harrison writes:
From: Jim Harrison To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Choosing the right tool Date: Tue, 18 Feb 2003 15:34:22 -0500
There is a shareware program that replicates TEP2's function and then some. I just Googled it and came up with this URL. I seem to recall getting it at a UK DB2 web site originally. Been using it for several years now with good results. [...]
6776 31 92_Re: HELP I'm stumped finding an identifier to tell me what process ca used a trigger to fire0_30_Steve_Grimes@AISMAIL.WUSTL.EDU31_Tue, 18 Feb 2003 15:20:32 -0600700_us-ascii From the V7 SQL Manual:
Table 45. Rules for the values of special registers in triggers Special register The value is .... CURRENT DATE, CURRENT TIME, CURRENT TIMESTAMP Inherited from the triggering SQL operation (delete,insert, update). All triggered SQL statements, including the SQL statements in a user-defined function or a stored procedure invoked by the trigger, inherit these values. CURRENT PACKAGESET Set to the schema name of the trigger CURRENT TIMEZONE Set to the MVS TIMEZONE parameter CURRENT DEGREE, CURRENT LC_CTYPE, CURRENT OPTIMIZATION HINT, CURRENT PATH, CURRENT PRECISION, CURRENT RULES, CURRENT SERVER, CURRENT SQLID, USER Inherited from the triggering SQL [...]
6808 56 44_Re: Stored Procedure Builder: RC=-1 errno=9113_Waldo Tumanut52_Waldo_Tumanut/MO/americancentury@AMERICANCENTURY.COM31_Tue, 18 Feb 2003 15:32:27 -0600412_- Thanks for the response, James.
errortext(91) is blank. I don't have a SYSTSPRT DD statement in DSNTJSPP WLM JCL. The stored proc DSNTJSPP does not use REXX (except when calling DSNTBIND which runs in another WLM environment). Do REXX stored procs use SYSTSPRT?
Waldo Tumanut DBA, American Century
On Mon, 17 Feb 2003 00:13:49 +1000, James Campbell wrote: [...]
6865 58 91_Re: HELP I'm stumped finding an identifier to tell me whatprocess ca used a trigger to fire11_David Nance16_DWNance@FHSC.COM31_Tue, 18 Feb 2003 16:41:52 -0500314_US-ASCII Be careful on using those special registers, they don't all give you what the manual states they will. IBM is supposed to be coming out with a doc update for that table. We were trying to use the CURRENT PATH register, but the trigger was using its own path, which IBM states is working as designed. [...]
6924 75 27_Re: Choosing the right tool0_19_csutfin@AMSOUTH.COM31_Tue, 18 Feb 2003 15:52:14 -0600395_us-ascii Yes, They have a DSNTEP2 cobol replacement named Darwin. It does work quite well. I implemented it here because DSNTEP2 was the only thing we had that was using PLI. I was told to get rid of it or find a replacement.
You can download the program and compile it using most cobol compilers. This removes the need for the PLI compiler. It does come with the usual disclaimers. [...]
7000 85 42_Re: Strange behaviour of the DB2 optimizer14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 19 Feb 2003 08:15:11 +1000352_ISO-8859-1 How many rows are there on a page?
My thinking is along the lines that if there are too many rows/page, sequential prefetch will have to be broken too often (to get the row out of sequence), and DB2 decides that it is easier to go the list prefetch/sort route.
The other tuning knob that might work is OPTIMIZE FOR 1 ROW. [...]
7086 131 21_Re: DB2 basic package3_DBA21_DBA@WILLIAMSONS.ID.AU31_Wed, 19 Feb 2003 08:12:00 +1000487_us-ascii Or MS Access via ODBC or any other ODBC compliant front end tool. Be careful about performance when doing mass insert/update/delete processing from ODBC clients as some do have "interesting ways" of building queries which may not be optimal for DB2,
-----Original Message----- From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] On Behalf Of Higgins John Sent: 19 February 2003 03:55 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 basic package [...]
7218 57 37_AW: DB2 SW & Service quality - Part I16_Roland Schiradin28_SchiradinR@ALTE-LEIPZIGER.DE31_Wed, 19 Feb 2003 00:19:52 +0100563_iso-8859-1 I agree 100%
1. We tryed new MQSeries stuff and the IVP fails because in Germany we use DECIMAL=COMMA. APAR P69030 assigned since 12/10/02 2. We tryed to use the integrated compiler (COBOL) and 4 PMR create at least 3 APAR's (one for Cobol and two for DB2). Cobol APAR closed but seems to be not working in every case. DB2 APAR PQ69319 still open since 01/03. One PMR still Open "Abend in the Cobol compile" since end of january 3. SPB (Stored procedure builder) cause confusing msg if running in a WLM with DD JAVAENV. (still open) 4. XML [...]
7276 33 22_Memo: Re: AW: 00f3009111_Alice Cheng22_alicecheng@HSBC.COM.HK31_Wed, 19 Feb 2003 09:44:50 +0800688_us-ascii Have you ever enable RRS in your MVS environment?
************************************************************ The Hongkong and Shanghai Banking Corporation Limited 1 Queen's Road Central, Hong Kong ************************************************************
********************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
7310 33 13_QMF & Pricing12_Cianci, Nick19_nick.cianci@EDS.COM31_Wed, 19 Feb 2003 13:28:52 +1100486_iso-8859-1 Dear dudes, may not be a topic for the list in which case, somebody give me a slap on the wrist, and be gentle on the Flames.
I've heard from our friendly neighbouring DB2 SysProg. types that QMF is intended to be removed from us :-( relatively soon.
We are at the moment V7, and have heard through the grape-vine that in V8 (whenever we go to it) QMF pricing will rise significantly, as it is beginning to incorporate some Data Warehousing functionality. [...]
7344 33 17_Re: QMF & Pricing0_17_JTonchick@AOL.COM29_Wed, 19 Feb 2003 00:47:06 EST270_US-ASCII QMF is an application to DB2. You can run a "down level" version of QMF. The drawbacks are: 1) you will not be able to automaticly take advantage of new features in the "higher" levels of DB2, and 2) eventually you will be running an unsupported version of QMF.
7378 15 33_John Ordman is out of the office.0_29_John_Ordman@READERSDIGEST.COM31_Wed, 19 Feb 2003 01:00:36 -0500403_us-ascii I will be out of the office starting 02/18/2003 and will not return until 02/24/2003.
I will respond to your message when I return.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
7394 155 21_Re: DB2 basic package14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Wed, 19 Feb 2003 08:20:18 +0100673_us-ascii A very useful tool for accessing DB2 (and others!) is AQT - Advanced Query Tool
Peter
DBA wrote:
>Or MS Access via ODBC or any other ODBC compliant front end tool. Be >careful about performance when doing mass insert/update/delete >processing from ODBC clients as some do have "interesting ways" of >building queries which may not be optimal for DB2, > >-----Original Message----- >From: DB2 Data Base Discussion List [mailto:DB2-L@LISTSERV.YLASSOC.COM] >On Behalf Of Higgins John >Sent: 19 February 2003 03:55 >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: Re: DB2 basic package > > >No one else has mentioned this, but I find Excel via ODBC [...]
7550 139 30_NEW, EXCITING DB2 UDB EXPRESS!12_Phil Gunning20_pgunning@COMCAST.NET31_Wed, 19 Feb 2003 02:25:01 -0500679_iso-8859-1 FYI. Reposted for DB2 Interested Parties. Phil
Dear DB2 Interested Parties, > > IBM DB2 Universal Database Express Edition was introduced today at the IBM > PartnerWorld conference in New Orleans. DB2 Express is a full-function > (i.e., same code base as DB2 UDB for Linux, UNIX, Windows), specially > tailored DB2 database offering for business partners and for midmarket > companies (aka, the Small Medium Business (SMB) market segment of companies > with 100 to 1,000 employees). This is an important initiative in IBM's > competitive thrust versus Microsoft SQL Server and Oracle's entry-level > database. (Similarly targeted offerings [...]
7690 111 46_Re: Converting hex to text for Runstats output15_Stephen Mallett25_Stephen.Mallett@NT.GOV.AU31_Wed, 19 Feb 2003 01:20:05 -0600287_- Hi Martin,
This was the original posting from Mathew
. . . Does anybody have an easy way of converting the hex output of the runstats utility from hex to text? I'd like to be able to identify high and low vaues without having to do the hex translation myself. . . . [...]
7802 28 11_What is LPL19_Briggs, N. - Neil -28_Neil.Briggs@CANON-EUROPE.COM31_Wed, 19 Feb 2003 10:27:04 +0100355_iso-8859-1 Dear list,
DB2 v5 os390
Please could somebody explain to me what a logical page list is. I know that it seems to be a range of pages that DB2 considers logically unavailable. But where is it, how does it effect pages in the bufferpool, does db2 check this list to determine when a page is broken. What causes this condition? [...]
7831 13 21_Re: DB2 basic package15_Perryman, Brian18_BPerryman@TNSI.COM31_Wed, 19 Feb 2003 04:31:46 -0500363_iso-8859-1 Thanks everyone for all the info about QMF and other related DB2 software - that's very helpful.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
7845 115 59_Stored Procedures and accessing dataset using ISPF funtions37_=?iso-8859-1?Q?=C4rlebrandt_Michael?=28_Michael.Arlebrandt@VOLVO.COM31_Wed, 19 Feb 2003 10:51:08 +0100396_iso-8859-1 Hi!
I have a programmer that wants to use a subpgm in a Stored Procedure and access members in an PDS using ISPF commands LMINIT, LMMFIND, LMCLOSE
we have added DD statements for the customer libraries in the WLM STC proc and also tested to add some libraries for ISPF (ISPPLIB, ISPMLIB, ISPSLIB, ISPTLIB) but we still get our RC=0020 when we issue the LMINIT call. [...]
7961 43 19_Answer: What is LPL12_Peter, Georg15_G.Peter@DZBW.DE31_Wed, 19 Feb 2003 10:52:41 +0100404_iso-8859-1 Good morning, Neill.
Pages that are logically in error are written to a special list known as the logical page list.
A logical error is one that can be corrected without redefining physical devices, for example, caused by a connection problem.
Logical page errors can be cleared by starting the object in question (this can be a database, a tablespace, a partition). [...]
8005 24 44_Re: Stored Procedure Builder: RC=-1 errno=9114_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 19 Feb 2003 20:55:54 +1000328_US-ASCII If you don't provide one, the TSO/E Environment Service (which does the actual running of the REXX code) allocates one to DUMMY. If you put it in your JCL as SYSOUT=* you might see something.
James Campbell
On 18 Feb 2003 at 15:32, Waldo Tumanut wrote:
>Do REXX stored procs use > SYSTSPRT? > [...]
8030 58 63_Re: Stored Procedures and accessing dataset using ISPF funtions14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Wed, 19 Feb 2003 20:55:54 +1000598_ISO-8859-1 I presume the actual code is REXX. Try adding ADDRESS ISPEXEC CONTROL ERRORS RETURN before the LMINIT, and LMINIT_RC = RC IF LMINIT_RC > 4 THEN DO SAY 'LMINIT FAILED. RC='LMINIT_RC ZERRSM SAY ZERRLM EXIT LMINIT_RC END after it.
James Campbell
On 19 Feb 2003 at 10:51, Ärlebrandt Michael wrote:
> Hi! > > I have a programmer that wants to use a subpgm in a Stored Procedure and access members in an PDS using ISPF commands LMINIT, LMMFIND, LMCLOSE > > we have added DD statements for the customer libraries in the WLM STC proc and also tested to [...]
8089 13 51_David Ayers/ISG/CORP/Highmark is out of the office.11_David Ayers24_david.ayers@HIGHMARK.COM31_Wed, 19 Feb 2003 06:09:26 -0500350_us-ascii I will be out of the office starting 02/19/2003 and will not return until 02/20/2003.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
8103 59 48_Re: Insights please--V7 LISTDEF and Image Copies10_Steve Lamb25_steve.lamb@POWERGEN.CO.UK31_Wed, 19 Feb 2003 05:43:15 -0600482_- Pantazis,
There are some thngs to watch out for with TEMPLATEs and LISTDEFs for the COPY utility. We stack our copies on "tape" - virtual or otherwise. I've been playing around and I'm not impressed with the "restartability" if you get problems. I used a very simple TEMPLATE and LISTDEF: TEMPLATE DB2QIC07 DSN 'DB2QIC.TMS.ICOPY.&DB..&TS.(+1)' UNIT 3490 MODELDCB MODEL.DSCB STACK YES LISTDEF DB2QIC07 INCLUDE TABLESPACE DVEZEQ03.% COPY LIST DB2QIC07 COPYDDN(DB2QIC07) [...]
8163 104 42_Re: Strange behaviour of the DB2 optimizer33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 19 Feb 2003 06:04:07 -0600500_ISO-8859-1 On Wed, 19 Feb 2003 08:15:11 +1000, James Campbell wrote:
>How many rows are there on a page?
The average record length is 58. Page size 4K, 10% PCTFREE: 63 rows on average on a page. The table has 117 million rows stored with 1,5 million different SAM_LNR. I do not know, if the remainder of the WHERE-condition has any influence on the filtor factor, because it isn't stage1. With these numbers the result set will have 78 rows on average. [...]
8268 22 15_Re: What is LPL33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Wed, 19 Feb 2003 06:12:27 -0600571_- Neil
I'm not sure, that I know all about LPL. That's my understanding:
LPL will only occur in a data sharing environment, where a pageset is 'Group Bufferpool dependet', that means 2 member are interested in that pageset and at least 1 member wants to update it. If pages are getting updated, they will be stored in the local or virtual bufferpool. On Commit or if some thresholds are hit, they have to written to the group bufferpool. But if the group bufferpool is full, because the castout process is too slow, these pages will go the LPL. If the [...]
8291 143 48_Re: Insights please--V7 LISTDEF and Image Copies16_Pantazis Pantazi18_PPantazi@LAIKI.COM31_Wed, 19 Feb 2003 14:32:12 +0200357_us-ascii How about when using it to backup on disks ? Does it have any similar problems of restartability ?
Currently I have one step for each tablespace in my system and this causes a lot of UTILINIT and UTILTERM operations. However, the restartability is very easy in this scenario.
I have 58 databases and a total of 4000 tablespaces. [...]
8435 81 17_Re: QMF & Pricing0_17_sjvagnier@AEP.COM31_Wed, 19 Feb 2003 08:01:16 -0500449_us-ascii Nick, don't know about any QMF pricing rumors. QMF V6.1 does work with DB2 V7. We are a heavy user of QMF for OS/390 and QMF for Windows (V6.1.1). Currently migrating to QMF V7.1 for OS/390.
Regards,
**************************************** Steve Vagnier American Electric Power Information Management Infrastructure One Riverside Plaza Columbus, Ohio 43215 Email: sjvagnier@aep.com Phone: 614-716-3677 Audinet: 200-3677 [...]
8517 62 62_Re: LISTDEF (Wildcarding) with IBM Reorg - anybody using this?23_Pendlebury-Bowe, Leslie34_Leslie.Pendlebury-Bowe@EU.SONY.COM31_Wed, 19 Feb 2003 13:48:05 -0000468_utf-8 I am in the labs in May (I hope to see some of the Utilities guys while there) and I will raise the issue with them.
I am stunned that they did not think of an easier way to implement this feature.
Leslie
-----Original Message----- From: Walter Janißen [mailto:walter.janissen@VICTORIA.DE] Sent: Tuesday, February 18, 2003 12:09 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: LISTDEF (Wildcarding) with IBM Reorg - anybody using this? [...]
8580 34 49_DSN1COPY vs. unload/load --- different row counts13_Michalik, Ken19_kmichalik@KRAFT.COM31_Wed, 19 Feb 2003 09:19:44 -0600457_iso-8859-1 I was wondering if someone has had this experience, or if this test of mine should work...
Segmented tablespace, 2 tables. I cloned similar tables in a similar tablespace (different subsystem, both V7). No indexes on the cloned tables.
I created a load file for one of the tables from a full image copy of the original tablespace, and used it to load/replace the cloned tablespace. Count(*) resulted in 4M rows for this table. [...]
8615 62 53_Re: DSN1COPY vs. unload/load --- different row counts10_jwkwan200025_jwkwan2000@HOUSTON.RR.COM31_Wed, 19 Feb 2003 09:49:34 -0600529_iso-8859-1 Ken,
Are you using a fuzzy image copy? There might be duplicate entries in the image copy which unload cannot detect since there is no unique index.
Regards,
James Kwan IBM Certified Solutions Expert - DB2 V7.1 Database Administration for OS/390
----- Original Message ----- From: "Michalik, Ken" Newsgroups: bit.listserv.db2-l To: Sent: Wednesday, February 19, 2003 9:19 AM Subject: DSN1COPY vs. unload/load --- different row counts [...]
8678 27 47_Performance degradation if PRIMARY KEY defined.10_Max Scarpa16_mscarpa@CESVE.IT31_Wed, 19 Feb 2003 17:41:38 +0100581_us-ascii Good mornig/good afternoon Estimeed Listers
A quick question came out while discussing yesterday with a programmer about Primary Key yes/no. I saw the topic discussed many time in the list, but my question is short: does anyone detected some kind of performance degradation defining a Primary Key even if no RI and at the end not really necessary ? It's enough a yes or not, hopefully with some numbers if the aswer is yes (or any paper reporting these numbers). I did some tests and I didn't find any delay/overhead but it was a test table (even if with many [...]
8706 67 53_Re: DSN1COPY vs. unload/load --- different row counts12_michael bell24_mbell11@WORLDNET.ATT.NET31_Wed, 19 Feb 2003 10:44:19 -0600452_iso-8859-1 The only difference I can think of is the space map pages from the image copy are not rebuilt when you use DSN1COPY. DB2 uses the space map pages to control a tablespace scan for a segmented tablespace. Another possible is DELETE from table (no where clause so only space map reset) followed by insert to rebuild (maybe load RESUME). It would have to be something that doesn't rebuild the space map pages like REORG, LOAD REPLACE, etc. [...]
8774 150 53_Re: DSN1COPY vs. unload/load --- different row counts17_Dr. Michael Ebert18_mebert@AMADEUS.NET31_Wed, 19 Feb 2003 18:02:21 +0100642_us-ascii I seem to remember that the Unload Utility cannot correctly handle Inline ICs which may have duplicated pages.
Dr. Michael Ebert DB2 Database Administrator aMaDEUS Data Processing Erding / Munich, Germany
The only difference I can think of is the space map pages from the image copy are not rebuilt when you use DSN1COPY. DB2 uses the space map pages to control a tablespace scan for a segmented tablespace. Another possible is DELETE from table (no where clause so only space map reset) followed by insert to rebuild (maybe load RESUME). It would have to be something that doesn't rebuild [...]
8925 45 63_Re: Stored Procedures and accessing dataset using ISPF funtions12_Jim Harrison17_jharrison@GMX.NET31_Wed, 19 Feb 2003 12:09:56 -0500
8971 50 51_Re: Central PA DB2 Users Group Meeting - March 12th19_Insixiengmay, Vince22_vinsixieng@STATE.PA.US31_Wed, 19 Feb 2003 12:14:53 -0500477_iso-8859-1 Kathy,
Please register the following people for the upcoming Central PA DB2 User Group Meeting on 3/12/2003: 1. Walt Cook 2. Vince Insixiengmay 3. Doug Leighty 4. Brad Hoffman 5. Robert Rescigno
Thanks,
Vince
-----Original Message----- From: Cathy Peck [mailto:cathy.peck@HIGHMARK.COM] Sent: Wednesday, February 12, 2003 5:54 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Central PA DB2 Users Group Meeting - March 12th [...]
9022 136 51_Re: Performance degradation if PRIMARY KEY defined.13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Wed, 19 Feb 2003 12:21:46 -0500365_US-ASCII Max,
I believe that you already know these things, but I will share them for completeness.
In DB2 for OS/390 and z/OS defining a Primary Key constraint requires also defining a Unique Index. Therefore, INSERTs and DELETEs to the table will, by definition, require additional cycles and GETPAGEs to access the Index as well as the Table. [...]
9159 81 45_Re: Bindagent with RACF/DB2 External Security12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Feb 2003 11:33:51 -0600450_ISO-8859-1 BINDAGENT uses a DB2 technique called secondary authids. RACF has individual users and groups. We decided that the current wording was not clear enough, so there is an update to the documentation on the web. The best technique is probably to start at the main DB2 for z/OS web page, ibm.com/software/db2zos Click on Library (on left of page, near the top) Click on DB2 Information Updates (middle of page, under Libraries by version) [...]
9241 44 12_Re: 00f3009116_Jaiwant Jonathan16_jjaiwant@AOL.COM31_Wed, 19 Feb 2003 11:35:24 -0600457_- Robert,
The explanation for this reason code states that RRS needs to be started. I think the example is using the Recoverable Resources System Attachment Facility (RRSAF) to connect to DB2. I have not tried Java on the mainframe, but if it needs a linkedit step using a module like DSNHLIR(RRSAF), try to change that to something that uses DSNELI(TSO) or DSNHLI2(CAF). You may have to change the JCL also to accomodate this. Hope this helps. [...]
9286 101 45_Re: Bindagent with RACF/DB2 External Security12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Feb 2003 11:43:01 -0600555_ISO-8859-1 Please pardon me, I hit the wrong key and sent too early.
BINDAGENT uses a DB2 technique called secondary authids. RACF has individual users and groups. We decided that the current wording was not clear enough, so there is an update to the documentation on the web. The best technique is probably to start at the main DB2 for z/OS web page, ibm.com/software/db2zos Click on Library (on left of page, near the top) Click on DB2 Information Updates (middle of page, under Libraries by version) Click on Administration Guide, Volume 2 [...]
9388 85 15_Re: What is LPL22_Venkatesh Mokshagundam21_Vmokshagun@CSEDGE.COM31_Wed, 19 Feb 2003 12:00:27 -0600554_- What causes this condition?
This is one of the causes (no Data Sharing), was due to human error and I'll never forget Thanksgiving 2002!
We're on DB2 V7.1 for OS/390.
We were in the process of moving all of our prod data to a test LPAR (at volume level, using DFDSS) and I don't know exactly what our sys prog did, but, somehow, the VTOC entries for 3 volumes got MOVED to the test LPAR and was not available to the prod LPAR. We started getting VSAM Catalog errors. We restored VTOC data back and DB2 stated creating LPL for [...]
9474 40 27_Re: IBM's Xperanto Software12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Feb 2003 12:40:38 -0600702_- The new product deliveries are called Information Integrator. Start at the main data web page: http://www.ibm.com/software/data/
Click on Information Integrator or Announcing Information Integrator Be sure to check the technology preview.
Roger Miller
On Fri, 14 Feb 2003 13:38:25 -0500, Whittaker, Stephen wrote:
>Anybody know of any good information sources for this new product?? > I've heard plans for shipment are around June 2003 but was wondering if >there were any white papers out there >on exactly what this product does. What I've found so far is that its a >little like their Datajoiner product but thats about >as [...]
9515 24 15_Re: What is LPL16_Jaiwant Jonathan16_jjaiwant@AOL.COM31_Wed, 19 Feb 2003 12:43:25 -0600541_- We always watch for LPL errors when DB2 abends and has to be brought back again. It happens when index changes have to be backed out of a type-2 index during restart. Usually you will have to recover the index in this case. In other cases, the tablespace page would be in LPL and it will be reset (in most cases) by a START DATABASE ACCESS(RW). Refer to restart in the Admin guide (page 4-105 in V5 manual) for more details. DB2 uses the logical page list during restart and tries to synchronize changes. If there are any errors that [...]
9540 39 52_Re: Lots of DB2 Accounting Records from DDF Inactive12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Feb 2003 12:48:08 -0600387_- I think we have a good answer for you coming in Version 8, but not before. Check the Version 8 overview and try about foil 82. Or check the topic Improved control for accounting aggregation in the What's New? http://www.ibm.com/software/data/db2/os390/db2zosv8.html
Roger Miller
On Fri, 14 Feb 2003 15:19:55 -0600, Michalik, Ken wrote: [...]
9580 103 23_Missing eMails on db2-l14_Grainger, Phil20_Phil.Grainger@CA.COM31_Wed, 19 Feb 2003 19:43:41 -0000354_iso-8859-1 Has anyone else noticed this - I have started seeing replied to db2-l postings when I have not seen the originals. It's as if some of the eMail from db2-l is not getting to me.
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com [...]
9684 46 38_Re: AIX overview for OS/390 developer?12_Roger Miller19_millerrl@US.IBM.COM31_Wed, 19 Feb 2003 13:45:44 -0600527_- For the SQL, the SQL Reference for Cross-Platform Development describes how to develop for portability.
I like the overview of structure differences in the Jim Wankowski presentation on the Quest web site. http://www.quest.com/quest_central/db2/technical_presentations.asp
The DB2 Developer Domain is one of the places I look for most questions like this one. http://www7b.boulder.ibm.com/dmdd/
It has several articles and introductions. http://www7b.boulder.ibm.com/dmdd/zones/newcomers/index.html [...]
9731 107 27_Re: Missing eMails on db2-l11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Wed, 19 Feb 2003 15:06:04 -0500378_iso-8859-1 If someone is posting from the newsgroup but is not subscribed to DB2-L, then we don't see their post. They see all posts, but we (on the listserv) only see posts from subscribers.
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: February 19, 2003 2:44 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Missing eMails on db2-l [...]
9839 20 27_Re: Missing eMails on db2-l12_Jim Harrison17_jharrison@GMX.NET31_Wed, 19 Feb 2003 15:24:08 -0500
9860 211 23_Re: DSN1LOGP - Question12_Subha Sivaji22_subha_sivaji@YAHOO.COM31_Wed, 19 Feb 2003 12:30:02 -0800735_us-ascii Thanks for clearing the misunderstanding. Su.
--- "Provenzola, Tony" wrote: > Maybe you misunderstood me. I'm talking about > changing the DDname, not the > DSname. > > Replace this: > //SYSUT1 DD DSN=DB2S.ARCHLOG1.A0013308,... > with this: > //ARCHIVE DD DSN=DB2S.ARCHLOG1.A0013308,... > > Tony Provenzola > Nike Database Services > Venturi Technology Partners, Consulting > Phone * 503-532-0772 > Fax * 503-532-3223 > Email * Tony.Provenzola@nike.com > > > -----Original Message----- > From: Subha Sivaji [mailto:subha_sivaji@YAHOO.COM] > Sent: Sunday, February 16, 2003 3:52 PM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: Re: DSN1LOGP - Question > > > Thanks Phil and [...]
10072 18 27_Re: Missing eMails on db2-l26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 19 Feb 2003 14:32:25 -0600357_- If you're gaited to comp.bitnet via Google or another News Engine, they've established separate lists. It's an administraitive hassle. Our list owner blocks newsgroups from posting due to past security exposures, so it's a one way street. For "googlers" probably the best solution is to read on Google, post on db2-l and set db2-l options to nomail. [...]
10091 119 27_Re: Missing eMails on db2-l13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Thu, 20 Feb 2003 07:50:17 +1100420_iso-8859-1 Not sure about the missing ones but my last three posts have bounced back saying they are duplicates. I have no idea if they really did get through.
Regards,
Steve T
PS I've cc'd the list owners
-----Original Message----- From: Grainger, Phil [mailto:Phil.Grainger@CA.COM] Sent: Thursday, 20 February 2003 06:44 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Missing eMails on db2-l [...]
10211 61 27_Re: Missing eMails on db2-l12_Phil Gunning20_pgunning@COMCAST.NET31_Wed, 19 Feb 2003 16:18:19 -0500547_iso-8859-1 Ed's on the right track here. Google newsgroups do not let you subscribe via email. Can only post and review via google. I haven't noticed any missing posts or duplicates. We used to get posted via UUNet to bit.listserv.dab-l and vice versa. This was working in 1997 when we were at American.edu but at times, has been on and off since then. I know we checked into this in the past, I'll see what the exact story is when I get some spare time.. it might be awhile:) In the meantime if anyone knows of a solution, email me offline. [...]
10273 28 46_DSNTIJIN migration job (V6 to V7) question....15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Wed, 19 Feb 2003 15:35:46 -0600547_US-ASCII We ran the installation clist with the migration option. I was expecting to see in the PDS member .NEW.SDSNSAMP(DSNTIJIN) only objects that are new in version 7 for the catalog and directory. But I get them all (even for existing objects like SYSCOPY, SYSPACKAGE etc). Is that normal in version 7 - (the job has defines and no deletes and hence I would only get bad return codes on existing objects and the job would end creating all the new objects). Or have I missed something and this is not the way it is supposed to be? [...]
10302 69 30_DB2 Connect/SPB DSNTPSMP error13_Michael Kovas14_mkovas@USG.COM31_Wed, 19 Feb 2003 15:47:08 -0600291_- My shop is running DB2 v7 for OS/390. I installed, on my Windows 2000 machine, DB2 Connect PE v7.2. I am able to connect and I am able to run existing COBOL Stored Procedures in SPB, but whenever I try to build a SQL SP through the wizard I get the message below: STEP FILE SEQN LINE [...]
10372 71 50_Re: DSNTIJIN migration job (V6 to V7) question....22_Christina S. Maldonado34_christina.maldonado@ADVANCEPCS.COM31_Wed, 19 Feb 2003 14:52:32 -0700566_us-ascii DSNTIJIN for V7, if you specify MIGRATION on the clist, will only produce the new required objects and should not produce all objects. You should verify the INSTALL TYPE option from the install panel
Also, I just went V7 last weekend and had a problem with catalog reorg which required PTF UQ70169. I had just put on HIPERS and PRPs only since I was close to the install date. It appears that one of the PTFS that came on during the HIPERS and PRPs ruined the catalog reorg, since before the maintenance I had no problem with the catalog reorg. [...]
10444 18 27_Re: Missing eMails on db2-l26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Wed, 19 Feb 2003 15:56:59 -0600519_- Don't know if was funding or staffing, but American lost interest in supporting newsgroups. Then they started having machine problems and it was really bad for a few months there. Think we finally went with "NEWSGUY" as our primary, but any newsgroup anywhere can subcribe(for a little while). > This was working in 1997 when we were at American.edu but at > times, has been on and off since then. I know we checked into this in the > past, I'll see what the exact story is when I get some spare time.. it might [...]
10463 79 53_Re: DSN1COPY vs. unload/load --- different row counts14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 20 Feb 2003 08:17:31 +1000563_US-ASCII Is the unload from image copy picking up rows in segments (I presume it's a segmented ts) that are marked (in the space map pages) as being unused? (Seen it happen with other products of this type.)
James Campbell
On 19 Feb 2003 at 10:44, michael bell wrote:
> The only difference I can think of is the space map pages from the image > copy are not rebuilt when you use DSN1COPY. DB2 uses the space map pages to > control a tablespace scan for a segmented tablespace. > Another possible is DELETE from table (no where clause so [...]
10543 95 55_DB2 UDB ( Win OS2 Unix) Problem Determination Tutorials13_Merritt, Hank16_HMerritt@GHI.COM31_Wed, 19 Feb 2003 17:29:48 -0500518_iso-8859-1 Dear List,
Just announced in the online DB2 Magazine, are 9 problem determination tutorials for V7.2 (with V8.1 highlights) for the windows, os2, unix platform. Follow this link to get there:
HTTP://WWW-3.IBM.COM/cgi-bin/db2www/data/db2/udb/winos2unix/support/tutorial _main.d2w/toc
I had copied the page into a previous post, but with the HTML formatting it exceeded the 250 line limit. [...]
10639 74 15_Re: What is LPL12_Paul Redhead35_paul.a.redhead@TRANSPORT.QLD.GOV.AU31_Thu, 20 Feb 2003 08:31:15 +1000510_us-ascii I'll add the comment that the only time I'd ever run into the LPL problem, and that was a number ( 7 or 8 ?) of years ago now, I had a user using QMF pointing out to me that depending on whether or not they appended a 'WHERE CLAUSE' to their SQL on a small table they would or would not get (I think) a -904. Seemed quite strange. It turned out that the 'WHERE CLAUSE' identified a row on the page in the LPL and so was unavailable, whereas a tablespace scan happily read all AVAILABLE (read NON [...]
10714 32 25_Case Insensitive Searches15_Bergeson, Loren24_LBergeson@IDAHOPOWER.COM31_Wed, 19 Feb 2003 17:08:47 -0700336_iso-8859-1 Is there any way on mainframe DB2 to do case insensitive searches? For example, I want the following query to return all rows with "fish" in the product name, regardless of the case which is used to store the text in the product name column.
SELECT PROD_ID, PROD_NAME FROM PRODUCTS WHERE PROD_NAME LIKE '%fish%'; [...]
10747 48 50_Re: DSNTIJIN migration job (V6 to V7) question....13_David S Waugh16_dsw-dba@JUNO.COM29_Thu, 20 Feb 2003 00:37:01 GMT357_- Tonmoy:
Every time I've done a migration, the DSNTIJIN job only generates IDCAMS DEFINEs for the NEW objects that you don't yet have. I just verified that in my last V7 migration documentation & NEW.SDSNSAMP library. Same was true of my last V5 install (I've not migrated to V6, so I don't know about it, but I would expect the same is true). [...]
10796 58 29_Re: Case Insensitive Searches10_John Hardy25_john_hardy@ALLIANZ.COM.AU31_Wed, 19 Feb 2003 19:23:41 -0600462_- I have a feeling that you might get lots of replies to this one, but here goes:
SELECT PROD_ID, PROD_NAME FROM PRODUCTS WHERE LOWER(PROD_NAME) LIKE '%fish%' (or UPPER(PROD_NAME) LIKE '%FISH%')
The use of the scalar function will of course make the predicate Stage 2, which might hurt you if (for instance) PROD_NAME is indexed (but probably not much in this exact case, due to the wildchar in the first character of your 'LIKE' comparison). [...]
10855 73 29_Re: Case Insensitive Searches25_Thanikachalam Sundarrajan21_billysundar@YAHOO.COM31_Wed, 19 Feb 2003 18:08:40 -0800607_us-ascii We have an additional column in some of our name search tables which are populated with the upper case of the name column whenever the name column is populated (updated/inserted).
We also convert the search string to upper.
Then the SQL then looks like UPPER_PROD_NAME LIKE '%FISH%'
--- "Bergeson, Loren" wrote: > Is there any way on mainframe DB2 to do case > insensitive searches? For > example, I want the following query to return all > rows with "fish" in the > product name, regardless of the case which is used > to store the text in the [...]
10929 170 64_Re: Stored Procedures and accessing dataset using ISPF fu ntions37_=?iso-8859-1?Q?=C4rlebrandt_Michael?=28_Michael.Arlebrandt@VOLVO.COM31_Thu, 20 Feb 2003 10:07:04 +0100455_iso-8859-1 Thanks Jim (and James),
I forwarded your answer to my programmer and he considers to give up or change his strategy.
at least he stops bugging me about the errors he gets ;)
/Michael
-----Original Message----- From: Jim Harrison [mailto:jharrison@GMX.NET] Sent: Wednesday, February 19, 2003 6:10 PM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: [DB2-L] Stored Procedures and accessing dataset using ISPF funtions [...]
11100 56 27_Re: Missing eMails on db2-l14_Grainger, Phil20_Phil.Grainger@CA.COM31_Thu, 20 Feb 2003 09:33:26 -0000406_iso-8859-1 Sorry to keep harping on about this, but I want to make sure I solve this problem.
In Edwards reply below, he quotes someone elses mail (the bit preceded by the ">" signs) - this never reached me, but because of the way it is quoted, I can't tell where it came from. If anyone has the original that Edward is replying to, could they forward it to me DIRECTLY at phil.grainger@ca.com [...]
11157 37 8_00f3009114_Robert Niemiec23_rniemiec@KRAKOW.TPSA.PL31_Thu, 20 Feb 2003 11:21:02 +0100362_us-ascii In addition to my e-mail from 18 Feb 2003(below), I inform: in my properties file .db2sqljjdbc.properties I set DB2SQLJATTACHTYPE=CAF and it is a JDBC program. Can I use CAF attachment facility or I must use RRSAF ? If CAF is possible, what is wrong?
My e-mail from 18 Feb 2003:
When I run EzJava.class on z/OS I get message: [...]
11195 25 27_Re: Missing eMails on db2-l6_Daniel15_bufes@YAHOO.COM31_Thu, 20 Feb 2003 03:53:29 -0600466_- On Wed, 19 Feb 2003 14:32:25 -0600, Edward(Ed) J. Finnell, III wrote:
>If you're gaited to comp.bitnet via Google or another News Engine, they've >established separate lists. It's an administraitive hassle. Our list owner blocks newsgroups >from posting due to past security exposures, so it's a one way street. For "googlers" >probably the best solution is to read on Google, post on db2-l and set db2- l options >to nomail. [...]
11221 34 18_Memo: Re: 00f3009111_Alice Cheng22_alicecheng@HSBC.COM.HK31_Thu, 20 Feb 2003 18:18:53 +0800740_us-ascii Which DB2 version are you using DB2 V6 or DB2 V7. According to my understanding, DB2 V7 must use RRS.
************************************************************ The Hongkong and Shanghai Banking Corporation Limited 1 Queen's Road Central, Hong Kong ************************************************************
********************************************************************** This E-mail is confidential. It may also be legally privileged. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return E-mail. [...]
11256 84 34_Re: DB2 Connect/SPB DSNTPSMP error14_James Campbell25_jacampbell@ACSLINK.NET.AU31_Thu, 20 Feb 2003 20:26:05 +1000331_US-ASCII This message screams "REXX execio error". Usually these have a more detailed OS error message in the JES Job Log. In this case, of the WLM address space that runs SPB.
You did include the appropriate DDs in this WLM's JCL, didn't you?
James Campbell
On 19 Feb 2003 at 15:47, Michael Kovas wrote: [...]
11341 43 24_DISPLAY DATABASE COMMAND12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 20 Feb 2003 11:54:37 +0100638_iso-8859-1 Good morning together.
Environment: DB2 for OS/390 V6.
If I fire the DB2 command -DIS DATABASE(*)SPACENAM(*)RESTRICT I receive the following error: "DSNT305I - SUBSYSTEM FAILURE DURING DISPLAY DATABASE COMMAND PROCESSING. RC=0000000C, REASON=00E30089 DSN9023I - DSNTDDIS 'DISPLAY DATABASE' ABNORMAL COMPLETION***
Doing the same with -DIS DATABASE(D*)SPACENAM(*)RESTRICT the display command works fine.
Does this mean that in every case I have to write at least one character followed by an asterix for the database name(s) ? And what do I have to write if I want a -DIS over all my databases ? [...]
11385 118 28_Re: DISPLAY DATABASE COMMAND18_Whittaker, Stephen29_stephen.whittaker@PGNMAIL.COM31_Thu, 20 Feb 2003 06:15:07 -0500460_iso-8859-1 Georg: It works just fine on our DB2 v6 OS/390 & we're at level 0105... I put in -dis database(*) spacenam(*) restrict and I got the results I needed. This probably doesn't help you much but at least you know your command is valid.
--Steve....
-----Original Message----- From: Peter, Georg [mailto:G.Peter@DZBW.DE] Sent: Thursday, February 20, 2003 5:55 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DISPLAY DATABASE COMMAND [...]
11504 25 28_Re: DISPLAY DATABASE COMMAND10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 20 Feb 2003 12:38:35 +0100349_us-ascii Morgen
No, I hope !
I execute every morning the command -DIS DB(*)SPACENAM(*)RES LIMIT(*) to check via REXX exec if there are tablespace in abnormal state and to execute the proper actions. Until now no problem and the environment is the same - DB2 V6 OS/390 2.10. You should have some error in LOGREC readable via EREP. [...]
11530 62 28_Re: DISPLAY DATABASE COMMAND14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Thu, 20 Feb 2003 05:38:54 -0600280_iso-8859-1 Georg,
There is nothing wrong with the command. Do you have any databases whose names do not begin with 'D' ? What happens if you try to display them - either individually or with the wildcard ?
Are there any 'interesting' messages in %MSTR ?
Colin
11593 133 28_Re: DISPLAY DATABASE COMMAND16_Pantazis Pantazi18_PPantazi@LAIKI.COM31_Thu, 20 Feb 2003 13:48:43 +0200671_us-ascii If you are issuing the command through spufi, then it is possible that your output file is full, due to the size of the results set. Have you checked it ?
Regards,
Pantazis Pantazi Database Administrator
Enterprise Systems Support Information Services Division Laiki Group, Cyprus Tel: +357-22812530, Fax: +357-22812583 Email: ppantazi@laiki.com
|---------+----------------------------------> | | "Whittaker, Stephen" | | | | | | Sent by: DB2 Data Base | | | Discussion List | | | | | | 20/02/2003 13:15 | | | Please respond to DB2 | | | Data Base [...]
11727 21 11_SDSNEXIT...11_Frost, Mark24_mark.frost@CITIGROUP.COM31_Thu, 20 Feb 2003 12:01:41 -0000333_iso-8859-1 Hi list
Can anyone tell me why you need to steplib the sdsnexit library on application JCL ? What exactly does the application address space need access to in that library ? The DECP, signon, connection, ZPARM, user exits are loaded by the DB2 master address space after all ?
Many thanks Mark. [...]
11749 168 50_DB2 for AS400 - WAS - Re: DISPLAY DATABASE COMMAND16_Farnsworth, Dave31_DFarnsworth@ASHLEYFURNITURE.COM31_Thu, 20 Feb 2003 06:37:05 -0600485_iso-8859-1 Does anyone know of a list like this that is more for DB2 on an AS400? There seems to be quite a difference for DB2 on an AS400 compared to other OS versions of DB2. Most of this list is unix,OS/390 or NT based from what I can tell.
Thanks,
Dave
-----Original Message----- From: Whittaker, Stephen [mailto:stephen.whittaker@PGNMAIL.COM] Sent: Thursday, February 20, 2003 5:15 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DISPLAY DATABASE COMMAND [...]
11918 34 29_Suppress SQLDA in precompiler14_Martin Flavell18_mflavell@I-TCS.COM31_Thu, 20 Feb 2003 11:34:42 +0000
11953 108 34_Re: DB2 Connect/SPB DSNTPSMP error12_Myron Miller22_Myron.Miller@BMWNA.COM31_Thu, 20 Feb 2003 08:02:15 -0500505_iso-8859-1 Actually the problem is that several dd's in the SPB address space do not have DCB=(RECFM=FB,LRECL=80,BLKSIZE=27920) specified on them. At least SQLLIN is required to have this problem. There's an APAR documenting this issue. I don't have the number readily available.
Myron
-----Original Message----- From: James Campbell [mailto:jacampbell@ACSLINK.NET.AU] Sent: Thursday, February 20, 2003 5:26 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DB2 Connect/SPB DSNTPSMP error [...]
12062 51 12_Re: 00f3009112_Myron Miller22_Myron.Miller@BMWNA.COM31_Thu, 20 Feb 2003 08:03:17 -0500524_iso-8859-1 Your stored procedure address space must use RRS.
Myron
-----Original Message----- From: Robert Niemiec [mailto:rniemiec@KRAKOW.TPSA.PL] Sent: Thursday, February 20, 2003 5:21 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: 00f30091
In addition to my e-mail from 18 Feb 2003(below), I inform: in my properties file .db2sqljjdbc.properties I set DB2SQLJATTACHTYPE=CAF and it is a JDBC program. Can I use CAF attachment facility or I must use RRSAF ? If CAF is possible, what is wrong? [...]
12114 45 15_Re: SDSNEXIT...13_Jeremiah Eden28_JEREMIAH.EDEN@RADIOSHACK.COM31_Thu, 20 Feb 2003 07:27:39 -0600348_- I would only think you would need it for initial testing with the install jobs, since some of the test programs go in there. I got bit on this once because I didn't expect IBM to put a test edit proc there. Last migration we copied them to runlib.load for consistency. DSNTWR is there, but you wouldn't steplib to it in a batch application. [...]
12160 21 31_Development Center Presentation12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Thu, 20 Feb 2003 07:36:37 -0600415_us-ascii I need to role out the new Development Center in 8.1 to approximately 60 developers in our organization. Does anyone have, or know of a good presentation, for this tool? I did not role out the Stored Procedure Builder because I knew this was coming so they have no knowledge of SQL Procedures yet. They do use and create external procedures, however, I want to really get them into SQL were possible. [...]
12182 115 38_Declare Temp Tables and Recoverability23_DePratti, Roland A A13325_Roland.DePratti@CIGNA.COM31_Thu, 20 Feb 2003 08:45:15 -0500562_us-ascii Hi All,
I am looking for some clarification from some of you that have worked with Declared temp tables more than I have. I have built some prototype batch programs that declare, insert, built indexes and drop these structures, but have not figured out a way to restart batch jobs using them. The IBM manuals refer to the ability for these structures to roll back the last commit point at a DB2 problem, but I am not sure what that means. Does that mean that, for example, if db2 returns a -904 and the program traps it, the application can [...]
12298 166 52_Re: Performance degradation if PRIMARY KEY defin ed.0_19_mike.holmans@BT.COM31_Thu, 20 Feb 2003 13:59:42 -0000507_iso-8859-1 Lockwood,
As far as I can see, all you're saying is that defining a primary key means you have to have a unique index.
There aren't all that many tables in most applications which don't have a unique index, in my experience. So, assuming that you would be defining a unique index anyway, I thought Max's question was whether or not coding a PRIMARY KEY clause was going to lead to a performance degradation over and above any overheads associated with the normal unqiue index. [...]
12465 101 50_Re: DSNTIJIN migration job (V6 to V7) question....15_Tonmoy Dasgupta32_tonmoy.dasgupta@MAIL.STATE.AR.US31_Thu, 20 Feb 2003 08:06:28 -0600409_US-ASCII Further to yours and David S Waugh's response, I confirm that I did indeed choose the "migrate" option. The new version 7 zparms got merged with the tuned version 6 zparms in .NEW.SDSNSAMP(DSNTIJUZ) as expected but DSNTIJIN did not get customized correctly for migration.
-----Original Message----- From: Christina S. Maldonado [mailto:christina.maldonado@ADVANCEPCS.COM] [...]
12567 19 15_Re: SDSNEXIT...10_Bruce, Mae26_BruceM@MAIL.OA.STATE.MO.US31_Thu, 20 Feb 2003 08:17:08 -0600307_- We have had to add the sdsnexit library to some jobs where our CAF programs did not do an explicit CONNECT to a subsystem. There apparently is a module in that library that will establish that connection for you. (Sorry don't know which one; I am more of an application person than a system person.) [...]
12587 206 44_Answer: DISPLAY DATABASE COMMAND (PTF 61009)12_Peter, Georg15_G.Peter@DZBW.DE31_Thu, 20 Feb 2003 15:22:42 +0100325_iso-8859-1 Stephen, Max, Colin & Pantazis.
Thanks a lot for your responses. In the meantime a DB2 collegue contacted me offline.
He told me that a missing program temporary fix may cause my problem. The PTF is # 61009 from December 31, 2001. Now I have to find out our service level and search this PTF... [...]
12794 30 60_Re: Performance degradation if PRIMARY KEY defined - Thanks.10_Max Scarpa16_mscarpa@CESVE.IT31_Thu, 20 Feb 2003 15:32:42 +0100417_us-ascii Hi Mike and all listers
Yes is what I meant and what we was discussing yesterday to decide a 'standard' ie if, when defining indexes UNIQUE on a table (and it happens almost for every application) we had to define a PRIMARY KEY as well, even if not really necessary. I some shops where I worked we defined a PK only if you had RI, others defined a PK in every case when creating an UNIQUE index. [...]
12825 23 27_Re: Missing eMails on db2-l12_Jim Harrison17_jharrison@GMX.NET31_Thu, 20 Feb 2003 09:36:03 -0500298_us-ascii I am a religious Googler and a preacher. Even have the toolbar installed on my browser. I find it much more user friendly than the archive search engine. And I use it more often than I use vendor's KBs. Often I find problems that cross boundaries so a wide open search is preferable. [...]
12849 48 15_Re: SDSNEXIT...15_soumitra mandal25_soumitra_mandal@YAHOO.COM31_Thu, 20 Feb 2003 06:38:18 -0800605_us-ascii If I remember correctly, one of those members is used to pass a control to RACF(or alternative sw) for security checking.
There are other modules. Looking at the installation guide one may get few pointers.
Soumitra
--- "Bruce, Mae" wrote: > We have had to add the sdsnexit library to some jobs > where our CAF programs > did not do an explicit CONNECT to a subsystem. There > apparently is a module > in that library that will establish that connection > for you. (Sorry don't > know which one; I am more of an application person > [...]
12898 46 15_Re: SDSNEXIT...16_Pearson, Eric L,23_Eric.Pearson@NSCORP.COM31_Thu, 20 Feb 2003 09:37:50 -0500453_iso-8859-1 With implicit CONNECT, CAF gets SSID from DSHNDECP. Typically the tailored DSNHDECP with correct SSID resides in SDSNEXIT. If the CAF program does not get the SSID from there, it gets it from the 'default' DSNHDECP which SMP/E seems to place in SDSNLOAD for some reason. The 'default' one has SSID = 'DSN'. So if you do implicit CAF CONNECT without a 'tailored' DSNHDECP, your CONNECT fails (unless your subsystem name really is 'DSN'). [...]
12945 122 42_Re: Declare Temp Tables and Recoverability11_Tina Hilton29_Tina.Hilton@ARVATOSYSTEMS.COM31_Thu, 20 Feb 2003 09:46:34 -0500687_iso-8859-1 If the program ends or abends, the temporary table and the data in it is gone. I don't know what happens if your program has retry logic.
Tina
-----Original Message----- From: DePratti, Roland A A133 [mailto:Roland.DePratti@CIGNA.COM] Sent: February 20, 2003 8:45 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Declare Temp Tables and Recoverability
Hi All,
I am looking for some clarification from some of you that have worked with Declared temp tables more than I have. I have built some prototype batch programs that declare, insert, built indexes and drop these structures, but have not figured out a way to restart batch jobs [...]
13068 125 54_Re: DB2 for AS400 - WAS - Re: DISPLAY DATABASE COMMAND14_Davage, Marcus29_Marcus.Davage@LLOYDSTSB.CO.UK31_Thu, 20 Feb 2003 14:00:57 -0000568_iso-8859-1 No. I've looked. From what I can pick up DB2 for AS/400 is nothing more than an SQL front end to the OS/400 file system. E.g. why "CREATE TABLE B LIKE TABLE A; INSERT INTO B SELECT * FROM A;" when you can "COPY FILE"? In my opinion, "DB2" is a complete misnomer. It bears no relation whatsoever to the DB2s we know and love on OS/390, unix, linux, windows, OS/2. Marcus Davage CEng MBCS IBM Certified Solutions Expert DB2 UDB V7.1 Database Administration for UNIX, Linux, Windows and OS/2 DB2 UDB V7.1 Database Administration for OS/390 [...]
13194 20 27_The connection test failed.8_Ralph P.18_PiotrowskiR@ZUS.PL31_Thu, 20 Feb 2003 15:40:49 +0100522_- when i try connect to db2 i get this message:
The connection test failed.
[IBM][CLI Driver] SQL0332N There is no available conversion for the source code page "850" to the target code page "1250". Reason Code "1". SQLSTATE=57017
what's wrong ?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
13215 53 35_Re: Development Center Presentation12_Phil Gunning20_pgunning@COMCAST.NET31_Thu, 20 Feb 2003 09:59:03 -0500279_iso-8859-1 Mark, There is an excellent book out of IBM Press, SQL Procedures. I'm not sure if it uses the new Development Center, but it is a v8 book so it probably does. I don't know of a presentation. The What's New for V8 has a decent amount of info on it. Regards, Phil [...]
13269 45 12_Re: 00f3009116_Jaiwant Jonathan16_jjaiwant@AOL.COM31_Thu, 20 Feb 2003 08:56:43 -0600595_- Robert, If your attachment type is set to CAF, then you must use CAF. Try changing the attachment type to RRSAF and execute the current JCL or try the other way around.
HTH ...Jaiwant
On Thu, 20 Feb 2003 11:21:02 +0100, Robert Niemiec wrote:
>In addition to my e-mail from 18 Feb 2003(below), I inform: >in my properties file .db2sqljjdbc.properties I set > DB2SQLJATTACHTYPE=CAF >and it is a JDBC program. >Can I use CAF attachment facility or I must use RRSAF ? >If CAF is possible, what is wrong? > > >My e-mail from 18 Feb 2003: > >When [...]
13315 176 45_Re: Bindagent with RACF/DB2 External Security12_Oscar Puerta15_puerta_o@TSM.ES31_Thu, 20 Feb 2003 16:20:00 +0100371_iso-8859-1 Yes, we know this is not merely a security issue.
We explain our scenario.
1. People in production area are responsible of doing BIND to the batch and online plans.
2. They are also, in some very controlled cases, responsible of update tables via QMF or SQL.
3. We are working with all the security working with RACF profiles. [...]
13492 54 46_Re: Development Center Presentation, Addl Info12_Phil Gunning20_pgunning@COMCAST.NET31_Thu, 20 Feb 2003 10:23:57 -0500413_iso-8859-1 Mark, I do have a presentation I gave at the Tech Conference on SQL Procedures. I can send that to you if you want. It does not include the Development Center as it was not available at the time. Also, at IDUG NA 2003 there will be several presentations on SQL procedures, one will be a case study of an entire application developed using SQL Procedures (over 300 SQL Procedures on DB2 for z/OS). [...]
13547 52 31_Re: The connection test failed.10_Lisa Bates29_Lisa.Bates@ROCKETSOFTWARE.COM31_Thu, 20 Feb 2003 10:33:51 -0500453_iso-8859-1 Ralph, We have seen this error. Depending on you OS, either conversion services is not installed, or if it is, it doesn't have the required conversion strings defined to it. Conversion services is included with z/os 1.3. If you're running a 390 system earlier than that, there is a ptf that enables the functionality. Look at II13048 and II13049 for more info. The last thing we had to do to resolve this problem was a SET CODEPAGE=xxxx [...]
13600 34 17_UDB vs SQL Server9_Nabin Dey25_Nabin_Dey@PROGRESSIVE.COM31_Thu, 20 Feb 2003 10:34:19 -0500473_us-ascii Hi all, This may not be the most appropriate forum but since I have been subscribing it for such a long time, I thought I might as well ask some questions.
We have currently our application (back end processing with flat files and VSAM files) on the IBM mainframe and the front end on the C/S. We have 5 master file. One of the master files has over 5 Million records and rest of them have less than 100,000. We have current around 250 batch programs. [...]
13635 81 9_Cert Info12_Phil Gunning20_pgunning@COMCAST.NET31_Thu, 20 Feb 2003 10:46:14 -0500475_iso-8859-1 Repost for DB2 Professionals:
One of the benefits of attending IDUG is the free DB2 certification exams. But that is NOT the only place where you can take these exams. DB2 certification exams are published worldwide on the Prometric and VUE testing systems. That means that there may be a testing center very close to your home or office where you can take the exam for $120. See www.prometric.com or www.vue.com/ibm to find a testing center. ======== [...]
13717 61 31_Re: The connection test failed.13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Thu, 20 Feb 2003 09:42:04 -0600414_iso-8859-1 Hi,
Sorry I have not solution for you ...
What version are you on, are you installing the product. I am installing DB2Connect V8.1 on Linux S390, and got the same error except for the codepages.
This is my error
[IBM][CLI Driver] SQL0332N There is no available conversion for the source code page "1208" to the target code page"UNKNOWN". Reason Code "1". SQLSTATE=57017 [...]
13779 92 46_Re: Development Center Presentation, Addl Info12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Thu, 20 Feb 2003 09:55:03 -0600291_us-ascii Thanks Phil, I will take you up on the presentation. You can send it to mark_buzzard@aric.com. I have two DBAs going to IDUG NA this year so I will make sure they bring the case study home. Also thanks for the guide reference. I have been looking for this for quite some time. [...]
13872 13 46_Re: Development Center Presentation, Addl Info31_Poston, William L (COMFIN, VFS)21_william.poston@GE.COM31_Thu, 20 Feb 2003 11:26:18 -0500330_iso-8859-1 Phil can you send it to me also? we are using sql procedures also
===============================================To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
13886 88 21_Re: UDB vs SQL Server12_Mark Buzzard21_Mark_Buzzard@ARIC.COM31_Thu, 20 Feb 2003 10:28:43 -0600505_us-ascii Hi Nabin,
I currently use OS/390 v6.1/v7.1 and SQL Server. From your description, size wise I don't think you will have much problems with SQL Server. I have two problems with SQL Server that I try to work around.
1) Understanding its security which I think is overly complicated sometimes. For example if I deny one object and grant one object I can sometimes inadvertantly override what I had previously denied depending on the relation of the two objects (view of a table). [...]
13975 38 18_DB2 Unload Dataset14_Smith, Brent E19_brent.smith@EDS.COM31_Thu, 20 Feb 2003 11:51:26 -0500414_iso-8859-1 List,
I've recently started comparing the new DB2 unload utility to DSNTIAUL. Everything is working great, except I'm trying to figure out why there are 4 bytes of nothing appended to end of every record. Turning hex on shows nothing in these last 4 bytes either.
I realize the SYSREC dataset is now variable block, but these additional bytes are showing up on the end of the record. [...]
14014 132 19_Re: DB2 and Dot Net15_Gaston, Raymond17_GastonRay@ORU.COM31_Thu, 20 Feb 2003 11:59:45 -0500381_iso-8859-1 Leon / DB2List...
We're on OS/390 DB2V7 and DB2Connect V5. We are currently converting to DB2Connect V7.2. Also, plans are to introduce Microsoft's .NET in the near future. Please, clarify if you would:
1) Will .Net work with DB2V7 or do we have to go to DB2V8? 2) Will .Net work with DB2Connect V5 or must we wait for DB2Connect V7.2? DB2Connect V8? [...]
14147 110 21_Re: UDB vs SQL Server15_Philip, Sibimon20_SPhilip@CSXLINES.COM31_Thu, 20 Feb 2003 12:13:50 -0500313_- I have not used UDB on windows. Regarding the point 2 on SQLserver, you can do a partial restore using file group to restore a table to a different database. I think one table in one table space in DB2 on os/390 is same as one table in one file in SQLserver. But nobody does that way I think in SQLserver. [...]
14258 161 19_Re: DB2 and Dot Net0_15_leon@CA.IBM.COM31_Thu, 20 Feb 2003 12:46:32 -0500394_us-ascii All of the new leading edge .Net enablement we do is based on DB2 Connect V8. DB2 Connect V8 does support connectivity to DB2 for OS/390 V6.1 and V7.1 and will also support the next version of the DB2 for OS/390 when it comes out.
There are options for older versions of DB2 Connect, but, we really want are counting on V8 as the base for the leading edge .Net enablement. [...]
14420 55 27_Re: Missing eMails on db2-l26_Edward(Ed) J. Finnell, III23_efinnell@SEEBECK.UA.EDU31_Thu, 20 Feb 2003 13:00:27 -0600311_- Sorry, it's pretty easy to back track by going to the ylassic web page and searhcing on thread by author or subject or just archive date. The LSoft search engine with the light bulbs and arrows shows the "threaded" posts by subject or author. I was reponding to Phil Gunnings post on the topic. HTH..... [...]
14476 76 53_Re: DSN1COPY vs. unload/load --- different row counts16_Jaiwant Jonathan16_jjaiwant@AOL.COM31_Thu, 20 Feb 2003 14:13:44 -0600411_- Two possibilities that I can think of that could lead to this, though I have not tried with two tables in the same segmented TS. 1) SEGSIZE is different. 2) Image copy tape spans multiple volumes. DSN1COPY works well with the simple VOL=RETAIN parameter in this case. Any special JCL to handle datasets spanning multiple volumes results in this kind of data loss, while giving an acceptable return code. [...]
14553 80 29_Re: Case Insensitive Searches13_Steve Tennant28_steve.tennant@CUSTOMS.GOV.AU31_Fri, 21 Feb 2003 07:54:33 +1100464_iso-8859-1 The 'or' phrase is redundant, surely.
-----Original Message----- From: John Hardy [mailto:john_hardy@ALLIANZ.COM.AU] Sent: Thursday, 20 February 2003 12:24 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Case Insensitive Searches
I have a feeling that you might get lots of replies to this one, but here goes:
SELECT PROD_ID, PROD_NAME FROM PRODUCTS WHERE LOWER(PROD_NAME) LIKE '%fish%' (or UPPER(PROD_NAME) LIKE '%FISH%') [...]
14634 108 29_Re: Case Insensitive Searches9_Sally Mir22_sally.mir@WACHOVIA.COM31_Thu, 20 Feb 2003 16:04:15 -0500674_us-ascii And unnecessary, too. :)
Steve Tennant @LISTSERV.YLASSOC.COM> on 02/20/2003 03:54:33 PM
Please respond to DB2 Data Base Discussion List
Sent by: DB2 Data Base Discussion List
To: DB2-L@LISTSERV.YLASSOC.COM cc:
Subject: Re: Case Insensitive Searches
The 'or' phrase is redundant, surely.
-----Original Message----- From: John Hardy [mailto:john_hardy@ALLIANZ.COM.AU] Sent: Thursday, 20 February 2003 12:24 To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: Case Insensitive Searches [...]
14743 34 14_AIX DB2 Memory12_DOUG KESTNER23_DHSTS57@DHS.STATE.IL.US31_Thu, 20 Feb 2003 15:09:16 -0600586_US-ASCII AIX 4.3, DB2 UDB 7.2 EE with intra-partition parallelism turned on, multiple bufferpools, about 425 Forte connections and 1200 agents running within 4 Gig of memory.
I'm looking for very detailed description of how DB2 allocates, uses and deallocates memory on AIX within a system as described above. I have read the DB2 UDB 7.2 Performance and Tuning and the Administration Guide on Performance from IBM. I didn't get enough detail from these, specifically on how memory is allocated, used and when or if deallocated by the DB2 agents (coordinator and subagents). [...]
14778 79 29_Re: Case Insensitive Searches10_Teldb2kals22_teldb2kals@TELSTRA.COM31_Thu, 20 Feb 2003 15:37:59 -0600786_- I think what John meant was, use either the LOWER function, or the UPPER function.
On Thu, 20 Feb 2003 16:04:15 -0500, Sally Mir wrote:
>And unnecessary, too. :) > >Steve Tennant @LISTSERV.YLASSOC.COM> on >02/20/2003 03:54:33 PM > >Please respond to DB2 Data Base Discussion List > > >Sent by: DB2 Data Base Discussion List > > >To: DB2-L@LISTSERV.YLASSOC.COM >cc: > >Subject: Re: Case Insensitive Searches > > >The 'or' phrase is redundant, surely. > >-----Original Message----- >From: John Hardy [mailto:john_hardy@ALLIANZ.COM.AU] >Sent: Thursday, 20 February 2003 12:24 >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: Re: Case Insensitive Searches > > >I [...]
14858 148 29_Re: Case Insensitive Searches12_Bill Skorija18_wskori@BOSCOVS.COM31_Thu, 20 Feb 2003 16:45:08 -0500633_iso-8859-1 How about using the translate function
> >SELECT PROD_ID, PROD_NAME > >FROM PRODUCTS > >WHERE TRANSLATE(PROD_NAME) ='FISH';
SELECT TRANSLATE ('FISH') AS FISH, TRANSLATE ('Fish') AS FISH, TRANSLATE ('fish') AS FISH, TRANSLATE ('fisH') AS FISH, TRANSLATE ('fiSH') AS FISH
FROM SYSIBM.SYSDUMMY1
---------+---------+---------+--------- FISH FISH FISH FISH FISH
----- Original Message ----- From: "Sally Mir" Newsgroups: bit.listserv.db2-l To: Sent: Thursday, February 20, 2003 4:04 PM Subject: Re: Case Insensitive Searches [...]
15007 152 29_Re: Case Insensitive Searches14_Peter Backlund21_pbacklu@ATTGLOBAL.NET31_Thu, 20 Feb 2003 22:55:22 +0100773_us-ascii But didn't the 'or' specify alternative ways?????
Peter
Sally Mir wrote:
>And unnecessary, too. :) > > > > > >Steve Tennant @LISTSERV.YLASSOC.COM> on >02/20/2003 03:54:33 PM > >Please respond to DB2 Data Base Discussion List > > >Sent by: DB2 Data Base Discussion List > > >To: DB2-L@LISTSERV.YLASSOC.COM >cc: > >Subject: Re: Case Insensitive Searches > > >The 'or' phrase is redundant, surely. > >-----Original Message----- >From: John Hardy [mailto:john_hardy@ALLIANZ.COM.AU] >Sent: Thursday, 20 February 2003 12:24 >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: Re: Case Insensitive Searches > > >I have a feeling that you might get lots of replies to [...]
15160 133 29_Re: Case Insensitive Searches13_Neil Courtney37_Neil.Courtney@TEAM.TELSTRACLEAR.CO.NZ31_Fri, 21 Feb 2003 11:12:25 +1300331_- not at all redundant or unnecessary.
What John actually said, if you look at the syntax (brackets) closely, is 'You can use the LOWER function, or alternatively, you can use the UPPER function, if you so choose.'. Sometimes using lower case characters in an SQL statement is not straight forward.
Cheers, Neil [...]
15294 60 15_Re: SDSNEXIT...13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 21 Feb 2003 00:46:51 GMT624_- That would be the DSNX@XAC module, I believe. This exit allows you to bypass some or most of DB2 authorization checking and to specify your own authorization checking, if you wish. There's also the DSNACICX module -- you can use DSNACICX to change the values of DSNACICS input parameters before you pass those parameters to CICS. DSNACICX is called by DSNACICS, which "gives workstation applications a way to invoke CICS server programs while using TCP/IP as their communication protocol". And then there are the usual DSN3@ATH and DSN3@SGN authorization and signon exits. All of these modules are stored in SDSNEXIT [...]
15355 112 50_Re: DSNTIJIN migration job (V6 to V7) question....13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 21 Feb 2003 01:02:37 GMT683_- Tonmoy:
If that's the case, then you have a reportable bug...
David Waugh, NCW DSW Consulting & Services
---------- Tonmoy Dasgupta writes:
From: Tonmoy Dasgupta To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: DSNTIJIN migration job (V6 to V7) question.... Date: Thu, 20 Feb 2003 08:06:28 -0600
Further to yours and David S Waugh's response, I confirm that I did indeed choose the "migrate" option. The new version 7 zparms got merged with the tuned version 6 zparms in .NEW.SDSNSAMP(DSNTIJUZ) as expected but DSNTIJIN did not get customized correctly for migration. [...]
15468 58 28_Re: DISPLAY DATABASE COMMAND13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 21 Feb 2003 01:12:53 GMT589_- Georg:
This kind of thing used to happen under V4 when you were trying to display a long list of tablespaces & index spaces (like when you have SAP or PeopleSoft and the resultant bazillion tablespaces & indexes). In that case, there was some DB2 internal buffer that was getting filled up, and DB2 would just 'barf' with a message like this. Narrow it down (like you did with -DIS DB(D*), which would produce results only for databases starting with 'D........') and DB2 didn't barf. Sometimes, adding 'LIMIT(*)' would help, sometimes not. I believe there was a PTF fix for [...]
15527 31 35_Re: Development Center Presentation16_Ian D. Bjorhovde23_ianbjor@MOBILEAUDIO.COM31_Thu, 20 Feb 2003 20:15:06 -0700441_us-ascii Mark Buzzard wrote: >I need to role out the new Development Center in 8.1 to approximately 60 >developers in our organization. Does anyone have, or know of a good >presentation, for this tool? I did not role out the Stored Procedure >Builder because I knew this was coming so they have no knowledge of SQL >Procedures yet. They do use and create external procedures, however, I >want to really get them into SQL were possible. [...]
15559 21 32_Upgrade from DB2 OS/390 V6 to V78_Alan Liu23_anitadnchan@HSBC.COM.HK31_Thu, 20 Feb 2003 22:03:19 -0600367_- Hi All,
We are in the planning stages of going from DB2 v6 OS/390 to DB2 v7 OS/390. If anyone has already upgraded to DB2 v7 OS/390, did you encounter any problems/issues on performance/compatibility that were not mentioned in IBM's DB2 V7 Release Planning Guide? I would appreciate hearing any problems/tips that were not mentioned in IBM's V7 manual. [...]
15581 13 37_Mark Hardenburg is out of the office.15_Mark Hardenburg30_mark.hardenburg@PRUDENTIAL.COM31_Fri, 21 Feb 2003 01:03:53 -0500350_us-ascii I will be out of the office starting 02/19/2003 and will not return until 02/24/2003.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
15595 133 15_Re: SDSNEXIT...37_=?iso-8859-1?Q?=C4rlebrandt_Michael?=28_Michael.Arlebrandt@VOLVO.COM31_Fri, 21 Feb 2003 08:36:14 +0100398_iso-8859-1 In our shop we don't use SDSNEXIT, we have put the 2 needed modules (for us) DSNZPARM and DSNHDECP in SDSNLOAD (available in LINKLIST), we run 25 DB2 systems sharing the same DSNLOAD having individual ZPARM DSNZd2xx and use same settings in DSNDECP.
So we always need to specify what system we want to attach to using DSN or CAF and can't go for the default one in DSNHDECP. [...]
15729 22 59_Derez D. Lusk/Household International is out of the office.13_Derez D. Lusk20_ddlusk@HOUSEHOLD.COM31_Fri, 21 Feb 2003 01:37:28 -0600389_us-ascii I will be out of the office starting 02/20/2003 and will not return until 02/24/2003.
ENTERPRISE WAREHOUSE, CONTACT JOHN MAZZAFERI, MARS ISSUES CONTACT HTSMARS
Please call 847-824-2871 leave a message or via - page EMPZ59 or send email to DDLUSK@HOUSEHOLD.COM Any critical issues Please notify Mars Primary Support HTSMARS - via connect / inotes or lotus notes [...]
15752 17 18_Re: AIX DB2 Memory12_David Harvey17_dmh@ONETEL.NET.UK31_Fri, 21 Feb 2003 03:23:35 -0600394_- Doug,
Try Redbook SG24-5511-01
See URL: http://publib- b.boulder.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg245511.html?Open
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
15770 25 24_vqube vs statement table9_accenture38_zbigniew.kowalski@ACCENTURESERVICES.PL31_Fri, 21 Feb 2003 13:51:22 +0100350_- Dear Listers!
Does anybody have compared results of a query cost coming from VQUBE (very quick upper bound estimate - CF 96) and from statement table (column PROCMS)? Are the ment to estimate the same value? (Why do they differ so much?) Or vqube estimates only I/O time whilst PROCMS only cpu time? (Shoud they be added in this case?) [...]
15796 52 36_Re: Upgrade from DB2 OS/390 V6 to V711_David Nance16_DWNance@FHSC.COM31_Fri, 21 Feb 2003 07:58:17 -0500384_US-ASCII Alan, We just upgraded last month and have been very happy. We have had no issues whatsoever with existing code. In fact, huge gains in performance for quite a few application processes, due to improvements in the optimizer. We do have an issue with the pre-compiler not excepting an order by on singleton selects that use the fetch first 1 row only, though. Good luck. [...]
15849 57 29_ODP: vqube vs statement table8_Ralph P.18_PiotrowskiR@ZUS.PL31_Fri, 21 Feb 2003 14:22:37 +0100640_iso-8859-2 Yes, VQUBE estimates i/o time only, (QUBE is more complicated). but i don't know anything about PROCMS.
> ---------- > Od: accenture[SMTP:zbigniew.kowalski@ACCENTURESERVICES.PL] > Odpowiedz do: accenture > Wys³ano: 21 lutego 2003 13:51 > Do: DB2-L@LISTSERV.YLASSOC.COM > Temat: vqube vs statement table > > Dear Listers! > > Does anybody have compared results of a query cost coming from VQUBE (very > quick upper bound estimate - CF 96) and from statement table (column > PROCMS)? > Are the ment to estimate the same value? (Why do they differ so much?) > Or vqube estimates only I/O time whilst PROCMS only [...]
15907 68 36_Re: Upgrade from DB2 OS/390 V6 to V715_Goldberg, Carol26_Carol.Goldberg@ACS-INC.COM31_Fri, 21 Feb 2003 08:48:54 -0500290_iso-8859-1 We did run into problems with CA (platinum Fast unload 99f release), a patch had to be applied to unload from the J linear datasets. Also we were using an old release of BMC SMF tool and the SMF record layout has changed.
Those are the biggest things I can think of. [...]
15976 11 43_Thanks - Re: DB2 Connect/SPB DSNTPSMP error13_Michael Kovas14_mkovas@USG.COM31_Fri, 21 Feb 2003 08:11:54 -0600331_- Thanks for all the help...I was able to get SPB up and running yesterday.
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
15988 24 42_ANYTHING LIKE A VIEW BUT ALLOWING UNION???11_Popi Dimoka24_dimokap@INTERAMERICAN.GR31_Fri, 21 Feb 2003 16:26:38 +0200380_iso-8859-7 Hello List, we are using an sql query consisting of many unions .That query is being used in many different programs,so we would like to create a structure and use that instead of issuing the same query many times.It would be ideal if we were able to create a view,but that's impossible due to the union clause. So,is there something else we could possibly try??? [...]
16013 72 36_Re: Upgrade from DB2 OS/390 V6 to V712_Myron Miller22_Myron.Miller@BMWNA.COM31_Fri, 21 Feb 2003 09:39:55 -0500563_iso-8859-1 I can't give the same endorsement. We've only gotten it as far as Developer Test. The conversion went pretty straightforward, but we've had to apply a number of PTFs to resolve issues. And we have two major showstopper issues from moving on. We have a SQL Stored procedure that worked in V6 that won't execute in V7. And we have about three SQL Stored procedures that BUILT in V6 and will not build in V7 at all. Both have open PMRs with IBM. Plus I'm researching now some other problems with a major Access application that worked just fine with [...]
16086 43 46_Re: ANYTHING LIKE A VIEW BUT ALLOWING UNION???12_McKown, John22_JMckown@UICIINSCTR.COM31_Fri, 21 Feb 2003 08:45:33 -0600599_- How about using a "stored procedure" which contains the SQL and just having your programs call it? We do that a lot for the Visual Basic programmers using SQL Server.
> -----Original Message----- > From: Popi Dimoka [mailto:dimokap@INTERAMERICAN.GR] > Sent: Friday, February 21, 2003 8:27 AM > To: DB2-L@LISTSERV.YLASSOC.COM > Subject: ANYTHING LIKE A VIEW BUT ALLOWING UNION??? > > > Hello List, > we are using an sql query consisting of many unions > .That query is being used in many different programs,so we > would like to create a structure and use that instead of > issuing the [...]
16130 13 46_Re: ANYTHING LIKE A VIEW BUT ALLOWING UNION???33_Walter Jani=?ISO-8859-1?Q?=DFen?=27_walter.janissen@VICTORIA.DE31_Fri, 21 Feb 2003 08:51:19 -0600384_- Hi
I think, you know, that in version 7, you can use union in a view and therefore you are at most on version 6, right?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
16144 42 46_Re: ANYTHING LIKE A VIEW BUT ALLOWING UNION???12_Myron Miller22_Myron.Miller@BMWNA.COM31_Fri, 21 Feb 2003 09:52:52 -0500454_iso-8859-7 Well, any union can be rewritten as an OUTER JOIN. It takes a little bit of thought to do it but its possible. Check the archives for examples of this. Terry's provided a number of excellent examples over the years.
Myron
-----Original Message----- From: Popi Dimoka [mailto:dimokap@INTERAMERICAN.GR] Sent: Friday, February 21, 2003 9:27 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: ANYTHING LIKE A VIEW BUT ALLOWING UNION??? [...]
16187 87 36_Re: Upgrade from DB2 OS/390 V6 to V712_Bejoy Kurian28_Bejoy.Kurian@EDWARDJONES.COM31_Fri, 21 Feb 2003 09:08:46 -0600565_US-ASCII I agree with Myron, We have lots of problems with reorg utilities, remote binds, Stataistics, RI contraints etc etc.
Bejoy
> I can't give the same endorsement. We've only gotten it as far as Developer > Test. The conversion went pretty straightforward, but we've had to apply a > number of PTFs to resolve issues. And we have two major showstopper issues > from moving on. We have a SQL Stored procedure that worked in V6 that won't > execute in V7. And we have about three SQL Stored procedures that BUILT in > V6 and will not build in [...]
16275 63 60_Re: Performance degradation if PRIMARY KEY defined - Thanks.15_Smith, Dennis J22_dennis.j.smith@EDS.COM31_Fri, 21 Feb 2003 09:18:25 -0600587_- Most programmers like to define a PK because in some relation databases, this has some influence to their particular optimizers. Defining a PK means that this is the main access and weighs a bit heavier. However, DB2 does not support that thinking. DB2 has such a concept internally however. The first index defined (or the oldest index in cases where indexes are dropped), is the "primary index". It is documented in the books, and only comes into play under very unique circumstances. Like there are no clustering indexes, the SQL has no ORDER BY clause, and the SQL result set [...]
16339 114 120_Press Release - DGI and LECCOTECH Announce Alliance to Provide Breakthrough SQL Analysis and Tuning Solution for DB2 UDB14_Pam Greenfield28_pgreenfi@BREAKTHROUGHDB2.COM31_Fri, 21 Feb 2003 09:16:25 -0600414_ISO-8859-1 DGI and LECCOTECH Announce Alliance to Provide Breakthrough SQL Analysis and Tuning Solution for DB2 UDB
Rochester, NY & San Francisco (February 21, 2003) - DGI, the leading provider of IBM DB2 UDB* database performance management solutions, and LECCO Technology (LECCOTECH), a leading provider of SQL optimization solutions, announced today they have entered into a strategic relationship. [...]
16454 53 36_Re: Upgrade from DB2 OS/390 V6 to V713_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Fri, 21 Feb 2003 10:23:59 -0500170_US-ASCII List,
I published an article listing some of our issues. It may be found at:
http://www.dbazine.com/lyon1.html
- Lockwood Lyon Meijer Stores
16508 56 46_Re: ANYTHING LIKE A VIEW BUT ALLOWING UNION???14_Grainger, Phil20_Phil.Grainger@CA.COM31_Fri, 21 Feb 2003 15:26:47 -0000534_iso-8859-7 Hi Popi,
Get to Version 7 and then you CAN do UNION in a VIEW!!
Maybe this will help to "persuade" the management to upgrade eh?
Phil Grainger Computer Associates Product Manager, DB2 Tel: +44 (0)161 928 9334 Fax: +44 (0)161 941 3775 Mobile: +44 (0)7970 125 752 phil.grainger@ca.com
-----Original Message----- From: Popi Dimoka [mailto:dimokap@INTERAMERICAN.GR] Sent: 21 February 2003 14:27 To: DB2-L@LISTSERV.YLASSOC.COM Subject: [DB2-L] ANYTHING LIKE A VIEW BUT ALLOWING UNION??? [...]
16565 99 46_Performance degradation if PRIMARY KEY defined13_Lockwood Lyon24_Lockwood.Lyon@MEIJER.COM31_Fri, 21 Feb 2003 10:38:43 -0500634_US-ASCII A few last minute thoughts . . .
Defining a Primary Key will result in an additional row in the Catalog for the constraint. This may cause your Catalog Image Copy job to run a few nanoseconds longer. Trivial? Yes, totally. Ignore this one.
Instead, consider: If you *ever* in the lifetime of this table wish to implement DBMS-enforced referential integrity you must issue the DDL statement ALTER TABLE. This will require locks on the catalog and directory, as well as plans and packages that reference this object. Depending upon your environment, this may be difficult. Defining the appropriate (whatever [...]
16665 57 53_Re: DSN1COPY vs. unload/load --- different row counts16_Provenzola, Tony24_Tony.Provenzola@NIKE.COM31_Fri, 21 Feb 2003 07:45:35 -0800527_iso-8859-1 Which one is correct?
Tony Provenzola Nike Database Services Venturi Technology Partners, Consulting Phone * 503-532-0772 Fax * 503-532-3223 Email * Tony.Provenzola@nike.com
-----Original Message----- From: Michalik, Ken [mailto:kmichalik@KRAFT.COM] Sent: Wednesday, February 19, 2003 7:20 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: DSN1COPY vs. unload/load --- different row counts
I was wondering if someone has had this experience, or if this test of mine should work... [...]
16723 13 53_Re: DSN1COPY vs. unload/load --- different row counts14_Clayton, Colin21_Colin_Clayton@BMC.COM31_Fri, 21 Feb 2003 10:11:15 -0600333_iso-8859-1 What about the other table ? Does RUNSTATS give the same figures ?
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
16737 156 46_Re: Converting hex to text for Runstats output13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 21 Feb 2003 16:46:14 +0000589_us-ascii Thanks. So, if the problem is how to make hex readable then I think you want something like...
OPTION COPY INREC FIELDS=(n,m,HEX,...) END
as a DFSORT incantation.
Or did I misunderstand? Martin
Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)
Stephen Mallett cc: Sent by: DB2 Data Subject: Re: Converting hex to text for Runstats output Base Discussion List [...]
16894 104 15_Re: SDSNEXIT...13_David S Waugh16_dsw-dba@JUNO.COM29_Fri, 21 Feb 2003 17:03:46 GMT561_- Hi Michael:
I'm curious - what happens when you apply maintenance? Don't you run the risk of clobbering your customized DSN3@ATH, DSN3@SGN and DSNHDECP modules in SDSNLOAD with maintenance that hits those modules? Not that this happens very often, but still...
David Waugh, NCW DSW Consulting & Services
---------- =?iso-8859-1?Q?=C4rlebrandt_Michael?= writes:
From: =?iso-8859-1?Q?Ärlebrandt_Michael?Subject: Re: SDSNEXIT... To: DB2-L@LISTSERV.YLASSOC.COM Date: Fri, 21 Feb 2003 08:36:14 +0100 [...]
16999 24 31_Re: The connection test failed.16_Jaiwant Jonathan16_jjaiwant@AOL.COM31_Fri, 21 Feb 2003 11:02:49 -0600415_- I ran into this problem and used this solution while installing DB2 V8.1 on Win2K. I am assuming you are trying to connect to the mainframe using the CLP/CCA/etc.
Add the following line in the DB2CLI.INI file under each DBALIAS. DISABLEUNICODE=1
This line has to be defined for each sub-system that has been configured. Restart the CCA after saving the DB2CLI.INI file and test the connection. [...]
17024 42 31_Re: The connection test failed.13_Mackey, Glenn20_GMackey@GUIDEONE.COM31_Fri, 21 Feb 2003 11:33:33 -0600370_iso-8859-1 I installed fix pack 1 for V8.1, Linux S/390 and that solved the issue. In my case, the error did not happen at the DB2 command prompt, only via a JDBC call.
-----Original Message----- From: Jaiwant Jonathan [mailto:jjaiwant@AOL.COM] Sent: Friday, February 21, 2003 11:03 AM To: DB2-L@LISTSERV.YLASSOC.COM Subject: Re: The connection test failed. [...]
17067 189 23_Re: DSN1LOGP - Question9_Su A.siva22_subha_sivaji@YAHOO.COM31_Fri, 21 Feb 2003 12:58:23 -0600790_- Thanks Tony . You are right . The problem is DDName. Thanks again for helping .
Su.
On Tue, 18 Feb 2003 08:02:33 -0800, Provenzola, Tony wrote:
>Maybe you misunderstood me. I'm talking about changing the DDname, not the >DSname. > >Replace this: >//SYSUT1 DD DSN=DB2S.ARCHLOG1.A0013308,... >with this: >//ARCHIVE DD DSN=DB2S.ARCHLOG1.A0013308,... > >Tony Provenzola >Nike Database Services >Venturi Technology Partners, Consulting >Phone * 503-532-0772 >Fax * 503-532-3223 >Email * Tony.Provenzola@nike.com > > >-----Original Message----- >From: Subha Sivaji [mailto:subha_sivaji@YAHOO.COM] >Sent: Sunday, February 16, 2003 3:52 PM >To: DB2-L@LISTSERV.YLASSOC.COM >Subject: Re: DSN1LOGP - Question > > >Thanks Phil and Tony. > [...]
17257 26 11_SEQCACH=SEQ16_Michael Lefebvre27_mike.lefebvre@CAREFIRST.COM31_Fri, 21 Feb 2003 13:21:53 -0600498_ISO-8859-1 Has anyone noticed any improvement by changing zparm seqcach from bypass to seq. We switched to EMC's Symmetrics 8530 with ficon three months ago and saw much faster I/O. I was told by my storage team that all disk requests (for this model and older one’s) must go through the controller cache, that DB2 cannot bypass the cache. If true, using seqcach=seq will have no impact. But if does work, did it have an impact on your I/O, where was it most noticable? We use DB2 V7 on z/OS. [...]
17284 79 95_SPECIAL SESSION on 3/12/03 Featuring Gabrielle Wiorkowski-Baltimore/Washington DB2 Users' Group14_Henry L Nalven25_henry.nalven@MARRIOTT.COM31_Fri, 21 Feb 2003 13:46:56 -0600718_ISO-8859-1 Special DB2 Course with Gabrielle Wiorkowski Sponsored by the Baltimore/Washington DB2 Users' Group
WWW.BWDB2UG.ORG
When? Wednesday, March 12, 2003, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Inn, 10207 Wincopin Circle, Columbia, MD
Who?
Gabrielle Wiorkowski is a senior DB2 consultant, founder of Gabrielle & Associates and affiliated with Codd & Date International. She worked for IBM as a DB2 specialist and has contributed sig-nificantly to the design and development of over 25 application systems on DB2 since 1984. She has lectured widely on DB2 to over 16,000 professionals in 27 countries on 6 continents. Gabri-elle is also the author of [...]
17364 89 15_Re: SEQCACH=SEQ13_Martin Packer24_martin_packer@UK.IBM.COM31_Fri, 21 Feb 2003 19:54:12 +0000489_iso-8859-1 You really have to first answer the question "what would this particular CU do with the sequential bit on?". Ditto bypass.
Cheers, Martin
Martin Packer, MBCS Martin Packer/UK/IBM 020-8832-5167 in the UK (+44) (MOBX 273643, Internal 7-325167, Mobile 07802-245584)
Michael Lefebvre cc: Sent by: DB2 Data Subject: SEQCACH=SEQ Base Discussion List [...]
17454 22 18_DB2 Control Center10_Rob Badger17_rbadger@WPSIC.COM31_Fri, 21 Feb 2003 15:43:34 -0600372_- How can I perform a 'SET CURRENT SQLID' in the Control Center?
I do not want to grant authority with my userid. We are using the Control Center with DB2 version 5 and version 7.
Thanks for you advice in advance.
Rob Badger Wisconsin Physicians Service Senior IRM Analyst, DBA Office: (608) 224-2771 Fax: (608) 223-3609 Email: rbadger@wpsic.com [...]
17477 22 32_Upgrade from DB2 OS/390 V6 to V714_Mark McCormack27_mamccormack@STATESTREET.COM31_Fri, 21 Feb 2003 18:49:04 -0500487_us-ascii I agree with Myron, We have lots of problems with reorg utilities, remote binds, Stataistics, RI contraints etc etc. Bejoy
Bejoy, Can you go into more detail on your problems with reorg ? Regards, Mark
================================================ To change your subscription options or to cancel your subscription visit the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list can be reached at DB2-L-REQUEST@listserv.ylassoc.com.
17500 42 36_Re: Upgrade from DB2 OS/390 V6 to V719_Jardine, Lawrence J19_JardineLJ@AETNA.COM31_Fri, 21 Feb 2003 22:20:49 -0500351_- In general, we've been satisfied with the move to V7. We experienced several "minor" problems with reorg -- mostly with the cleaning up (or failure to clean up) of obsolete (I or J) datasets. Certainly the improved BUILD2 phase (parallel index build) was worth the move. I say the problems were minor since I have run more than 7000 V7 reorgs. [...]