1 WWW.IDUGDB2-L.ORG /home/listserv/home/db2-l May 2004, week 5
2 348 26_Re: DBA opening in Chicago19_Michael L. McCawley20_Mike_DBA@HOTMAIL.COM31_Sat, 29 May 2004 17:43:29 -0500502_iso-8859-1 DB2 Mainframe to Oracle Unix? Prospects for sucess seem limited. Several have announced these intentions, has anyone really successfully done this? ----- Original Message ----- From: Patterson, Michael T Newsgroups: bit.listserv.db2-l To: DB2-L@WWW.IDUGDB2-L.ORG Sent: Friday, May 28, 2004 1:09 PM Subject: DBA opening in Chicago
I am looking for someone in living in the City of Chicago with the following skill sets. Please e-mail resumes to: mtpatterson@cps.k12.il.us [...]
351 34 19_sqm.sqlm_log_ev_err11_ali hasnain23_me_alihasnain@YAHOO.COM31_Sun, 30 May 2004 07:57:33 -0700953_us-ascii Hi;
I'm working on DB2 UDB for win2000 and getting the following error in db2diag.log. I can't find solution to this error and need help.
2004-05-12-00.02.15.437000 Instance:DB2 Node:000 PID:924(db2syscs.exe) TID:2048 Appid:*LOCAL.DB2.040512040215 database_monitor sqm.sqlm_log_ev_err Probe:1 Database:AHABIBBR
DiagData 0cce ffff .Î˙˙
__________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG [...]
386 373 33_Re: Archive Log MODE(Quiesce) RBA12_Troy Coleman25_troy.coleman@SOFTBASE.COM31_Sun, 30 May 2004 14:51:12 -0500571_us-ascii Hi Lee, Unfortunately DB2 does not keep the information for system quiesce points in a catalog. That would be a nice enhancement!! However, DB2 keeps this information in the Bootstrap Dataset (BSDS). You can print the contents using an IBM supplied utility called DSNJU004. Take a look at the Utility Guide for information on how to run this utility. The contents in the report are: * Log data set name, log RBA association, and log LRSN for both copy1 and copy2 of all active and archive log data sets * Active log data sets that are available for new log [...]
760 29 48_DB2 UDB for Linux, UNIX, and Windows DBA needed.12_Phil Gunning22_pgunning@GUNNINGTS.COM31_Mon, 31 May 2004 00:33:04 -0400548_iso-8859-1 I have an immediate opening for a good to expert level DBA to provide performance and tuning support, along with general DBA on the job training, and knowledge transfer. Position is in south central US. Work from home office and fly to customer site. Return home each weekend. Some remote support possible. Environment is DB2 UDB V8.1 FP5. AIX Regatta, PeopleSoft Financials. Contract term is 3-6 months. Rate is $100.00 per hr plus expenses. Please email me offline if you are interested or contact me at my 888 number. Rgds, Phil [...]
790 33 11_db2 clients8_duam lee20_duam_lee@HOTMAIL.COM31_Mon, 31 May 2004 08:33:38 +0000626_- Hi All UDB experts. I was having some questions while burried my head for client. I have this following questions.
I have application development need and Data administration need. What exactly client i need to install. The team will be developing a application on AIX enevironment. The appliaction would be EJB application connecting to Db2 on Z/OS. My question is how the set up will be like during development phase there will be Administration client installed at work station so that the developers test the appliaction connecting to the db2 installed on work station. Similarly when the devlopemnt is over [...]
824 47 37_Stored procedures basic question ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Mon, 31 May 2004 05:05:18 -0700619_us-ascii A very basic question. Our shop is considering moving to Stored Procedures and I was in the process of testing out a DB2 managed procedure (will later on move to WLM). My SQL CALL to stored procedure receives SQLCODE -444:
# Explanation: DB2 received an SQL CALL statement for a stored procedure # or an SQL statement containing an invocation of a user-defined function, # and found the row in the SYSIBM.SYSROUTINES catalog table associated with # the requested procedure name. However, the MVS load module identified in # the EXTERNAL_NAME column of the SYSIBM.SYSROUTINES row could not be found [...]
872 35 26_Residency experiences ....16_Raquel Rodriguez28_raquel_rodriguezus@YAHOO.COM31_Mon, 31 May 2004 05:07:02 -0700576_us-ascii Was considering applying for a Redbook Residency….but before that, thought it would be great to hear experiences from esteemed listers who already have done residencies. How is it like? Are there any IBM experts available for clarifying doubts or do the residents have to sort everything among themselves? Are the redbook sections to be written 'divided' among the residents or do all residents collectively work on everything related to the book. Does the lead author decide who should do what or do the residents have a say in their specific area of interest. [...]
908 84 30_Re: Residency experiences ....13_Martin Packer24_martin_packer@UK.IBM.COM31_Mon, 31 May 2004 14:52:19 +0100499_UTF-8
Raquel, I'm an IBMer but I have done numerous residencies, one of which was explicitly DB2. And I know friends of mine who are customers who were on my latest residency hang out here. They can corroborate or contradict the following...
Residencies have always been pretty informal. The team, including the host, decide what gets done and how to do it. Occasionally specific experts are drafted in to help - and might get assigned specific chapters. [...]
993 83 41_Re: Stored procedures basic question ....13_Murat Umurhan25_Murat.Umurhan@TCMB.GOV.TR31_Mon, 31 May 2004 17:26:18 +0300420_ISO-8859-9 Raquel,
The steplib datasets in DSN*SPAS address space must contain the load module of stored procedure.
There are several ways:
1. If you don't want to add user private libraries to the DSN*SPAS then you may copy the load module to the DSN*SPAS steplib dataset like xx.RUNLIB.LOAD
2. You may add the user private libraries to the DSN*SPAS steplib concatenation, if you want. [...]
1077 88 43_Db2udb 8.1 setup error in Red hat linux 9.04_Teja21_tejaswips@HOTMAIL.COM31_Mon, 31 May 2004 12:17:20 -0700713_iso-8859-1
Hi,
I am a newbie to linux, I got this error below while doing the setup for db2udb8.1 in redehat 9.0. Can anyone resolve this for me.
---------------------------------------------------------------------------------- [root@localhost 009_ESE_LNX_32_NLV]# ./db2setup DBI1190I db2setup is preparing the DB2 Setup Wizard which will guide you through the program setup process. Please wait.
/home/teju/db2/009_ESE_LNX_32_NLV/db2/linux/install/db2jinst: line 130: 3823 Segmentation fault $JAVA_PATH/$JAVA_INTERPRETER $JAVA_OPTIONS -cp $JAVA_CLASSPATH $DB2SetupRun "$@" 2>/tmp/db2setup.err.running ------------------------------------------------------------------- [...]
1166 43 33_Re: Archive Log MODE(Quiesce) RBA0_16_DBMSUser@AOL.COM29_Mon, 31 May 2004 19:00:13 EDT687_US-ASCII Troy, Is it safe to do a TORBA on a group of tablespaces using the Archive Log MODE(Quiesce) RBA? Is everything flushed to the active logs for all tablespaces. Are the tablespaces really in Sync?
Lee,
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-REQUEST@www.idugdb2-l.org. Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
1210 51 48_Isaac Yassin - Re: Archive Log MODE(Quiesce) RBA0_16_DBMSUser@AOL.COM29_Mon, 31 May 2004 19:44:31 EDT367_US-ASCII Isaac, Are you saying that the Archive Log Mode(Quiesce) RBA may NOT be valid for a TORBA recovery for all tablespaces? Do you have any more information of this matter? The IBM Command Reference states that using Mode(Quiesce) will give a system-wide point of consistency. Anyone else have any information of the RBA of a Archive Log Mode(Quiesce) RBA? [...]