I am installing WebSphere Service Registry & Repository on z/OS. The first part consists of jobs that set up the DB2 definitions. I am not yet any...

George Owen

09-16-2009 02:39 PM
George Owen

What specifically can I derive from the output associated with DSNB420I? I presume that 'system page' here does not reflect the context of a 'system...

DTSDB2

09-15-2009 01:33 PM
DTSDB2

The DB2 for z/OS Information Development team wants to know how you find answers to your questions about DB2 for z/OS. We are particularly interested...

djlyle@us.ibm.com

09-14-2009 05:47 PM
djlyle@us.ibm.com

Hi Folks , I am getting the message below during the archiving process : DSNJ114I -DB2D ERROR ON ARCHIVE DATA SET, OFFLOAD CONTINUING WITH ONLY...

mahenrique@hotmail.com

09-13-2009 02:48 AM
momi.sabag@gmail.com

Hi all, I recently asked how to start DB2 via JCL in this forum. As recommended, I now use operator commands from within JCL to do so. However,...

Arens

09-13-2009 02:36 AM
momi.sabag@gmail.com

Hi All, I want to start a DB2 subsystem (v8 and v9) via JCL. For this, I currently have the following step to start the DB2 subsystem. //DB2RSTRT...

arens@de.ibm.com

09-08-2009 07:11 AM
Arens

spam spam spam -- admin

admin

09-05-2009 06:53 AM
admin

HI Folks , I am using DIAGNOSE DISPLAY MEPL to check the PTFs applied in the mods. Would you know if just the SDSNLOAD modules are checked ? I...

Marcos_Caurim

09-04-2009 07:26 AM
n314890

erantz_dba_db2, That is not an easy question to answer as performance can involve other things such as Number of Rows, Indexes, and when Runstats was...

sdasinger@monlife.com

08-30-2009 05:51 AM
sdasinger@monlife.com

Hi , Can anyone throw some light on how the performance of the UNION operator compares with using an OR? I am looking for a generic recommendation...

erantz_dba_db2

08-30-2009 04:49 AM
erantz_dba_db2

*Hello Guyz,* As per the Manual +"Plans and packages are not invalidated unless the new column is a TIME, TIMESTAMP, or DATE."+ And I did the...

Bobby.Dreamer

08-26-2009 09:54 AM
DTSDB2

Hello! I want to order subj but I'm not resident of USA. Are there any ways to buy it online or download?

krk@krw.ru

08-25-2009 03:09 PM
djlyle@us.ibm.com

Right now our system is using DB2 connect professional to connect to DB2 on Mainframes Z/OS through CLI. For this sake we need to install DB2...

vamsykurapati@gmail.com

08-24-2009 08:38 AM
mspringgay

Hi I have a CICS/DB2 web application in which I need to get the row count of the result set. This is so I can calculate the number of pages to...

Andy Dossett

08-23-2009 07:03 AM
Andy Dossett

Due to new business requirements and some modernization issues, we are embarking on a complete rewrite of a major mainframe batch Cobal application...

tstratto@gmail.com

08-19-2009 10:10 AM
DTSDB2

The attached query is required due to data source. The tables involved are 3 - 8 million rows. DB2 version 8. I'm having them alter to use multirow...

chris.meisinger@wachovia.com

08-19-2009 09:51 AM
DTSDB2

Hi, Someone has the material or known something for study for certification 000-737 DB2 9 System Administrator for z/OS? Redbooks?...

glaucio_gallo@yahoo.com.br

08-10-2009 12:56 PM
glaucio_gallo@yahoo.com.br

Hi, Someone has the material or known something for study for certification 000-737 DB2 9 System Administrator for z/OS? Redbooks?...

glaucio_gallo@yahoo.com.br

08-10-2009 12:55 PM
glaucio_gallo@yahoo.com.br

Please, Someone has or known What's the material for exame 000-737 DB2 9 System Administrator for z/OS? Some book? Redbook? thanks, Gallo

glaucio_gallo@yahoo.com.br

08-10-2009 12:50 PM
glaucio_gallo@yahoo.com.br

Please, Someone has or known What's the material for exame 000-737 DB2 9 System Administrator for z/OS? Some book? Redbook? thanks, Gallo

glaucio_gallo@yahoo.com.br

08-10-2009 12:50 PM
glaucio_gallo@yahoo.com.br

Please, Someone has or known What's the material for exame 000-737 DB2 9 System Administrator for z/OS? Some book? Redbook? thanks, Gallo

glaucio_gallo@yahoo.com.br

08-10-2009 12:50 PM
glaucio_gallo@yahoo.com.br

I tried to create a stored procedure on DB2 V9 on OS390 and get error as SQL0628N Multiple or conflicting keywords involving the "" clause...

cshiong@gmail.com

08-07-2009 03:34 PM
cshiong@gmail.com

28 128 pages 32 ≥ 128 pages 64

eduardo.nicdao@yahoo.com

08-05-2009 04:35 PM
mahenrique@hotmail.com

I'm migrating to SMS, but am currently using a FILTLST of dataset names for the TABLESPACES. No way is this the way to migrate to SMS. Dont I...

Roy Morse

07-31-2009 11:21 AM
Roy Morse

Hey guys we are in the process of moving our databases from Z/OS to DB2 UDB on AIX and we have created nicknames and trying to load using cursor. The...

shan.matad@gmail.com

07-29-2009 05:31 AM
momi.sabag@gmail.com

Hello Experts, I have previously worked with Oracle databases but new to DB2 and Mainframes. In my project I am working on OS 390 with DB2...

ronak.panchal@cognizant.com

07-24-2009 06:30 PM
Todd Burch

hello, in z/OS DB2 (V8) I have some Stored Procs, which sometimes write to an MQ-queue. The SP works with DSNRLI. if the SP recognizes a failure...

woifi.fritsch@allianz.de

07-24-2009 05:08 AM
WOIFI.FRITSCH@ALLIANZ.DE

DBAs just brought it to my attention that these system tables are not populated. Any idea wht RUNSTATS wouldn't be loading them?

Roy Morse

07-24-2009 01:20 AM
momi.sabag@gmail.com

Is there a minimum version of DB2 Connect that the Data Server Driver can use? We are using DB2 Connect v7 to connect to DB2 v7.1.2 on an S/390...

chrisrblevins@hotmail.com

07-22-2009 01:42 PM
pickel@us.ibm.com

Some of our stored procedures started timing out with reason code 00D3003B on z/OS. I have looked at the CMTSTAT and it is set to 'INACTIVE'. Also,...

07-22-2009 10:48 AM
mary.irby@state.tn.us

Hi, I am using DB2 9.5 on a windows environment. I would like to know how to find out the names of the tablespaces of a database that has already...

nithisha@niharinfo.com

07-21-2009 09:43 PM
Todd Burch

To access VSAM and PS files through DB2 stored procedure DB2 SPAS WLM JCL needs to be modified Can you provide me the required WLM JCL where in...

veena_bp@infosys.com

07-21-2009 09:42 PM
Todd Burch

How to display from ISPF DB2 connection locks, open transactions, connection status. The only command I found so far is -display thread (*).

alexg00@hotmail.com

07-19-2009 02:24 PM
alexg00@hotmail.com

Hi, I am trying to execute a COBOL stored procedure on Z/OS from Java program. I am getting the SQLCODE as -805. I checked the IBM manual and...

veena_bp@infosys.com

07-18-2009 03:44 PM
Todd Burch

Hello, We use different owners for our tables across environments. To avoid hard coding the owners in our programs, we use synonyms for our tables...

eduardo.nicdao@yahoo.com

07-17-2009 06:29 AM
sdasinger@monlife.com

I am in the process of migrating to SMS managed for my DB2 subsystem. I've created SMS FILTLST and ACS routines and have successfully migrated a...

Roy Morse

07-16-2009 03:43 PM
Roy Morse

Are there any basic guidelines on when to use MERGE statement? I want to to know if there are any considerations on the MERGE usage w.r.t...

vijayasri.yerraguntla.po7v@statefarm.com

07-13-2009 10:51 AM
momi.sabag@gmail.com

Hi, I am trying to execute a SQL stored procedure which will select a set of columns from the table(select ename, sal from emp). The procedure is...

veena_bp@infosys.com

07-12-2009 01:16 PM
momi.sabag@gmail.com

I am having problem creating procedures in v8. Here's an example: CREATE PROCEDURE sum ( IN p_a INTEGER, IN p_b INTEGER, OUT p_s INTEGER) LANGUAGE...

alexg00@hotmail.com

07-08-2009 08:03 PM
alexg00@hotmail.com

Let's see your CREATE PROCEDURE statement and the snippet of code where you are making to the call to the SPROC. Todd

Todd Burch

07-06-2009 09:32 PM
Todd Burch

Hi, I have to write an application, The idea of the application is to generate DSN1COPY OBIDXLAT parameters. For every object in a subsystem i need...

rashmibiliya@gmail.com

07-06-2009 09:29 PM
Todd Burch

I am getting an error code -917 with CD=S000|U0060, when I am trying to promote a test program which is accessing DB2 database. Can you tell me what...

rajasekaran.rajamanickam@tcs.com

07-06-2009 09:26 PM
Todd Burch

Hi, The target table has one extra column. how can I skip that column while loading?

pgkrish@yahoo.com

07-06-2009 09:22 PM
Todd Burch

The attached protoSQL is provided as is. If you identify a bug, or a total failure in coding, reply with your findings. This SQL was prototyped...

db2@dts.ca.gov

07-06-2009 03:25 PM
db2@dts.ca.gov

Hello, I'm trying to find the static statement cache (not dynamic). As far as I know it is somewhere in the catalog but I didn't find it. Could you...

arens@de.ibm.com

07-02-2009 10:31 AM
arens@de.ibm.com

Hi <br /> <br /> I worked on Z/0S, OS 390 DB2. Could anyone please guide me as to what would be the best certification I could take to start off...

chandana.tumuluri@gmail.com

06-30-2009 12:48 AM
pgkrish@yahoo.com

We are re-architecting a J2EE web application and are weighing the pros and cons of sqlj. Our preference is to use JDBC/Hibernate but the dba (db2...

bradley.r.clark@accenture.com

06-29-2009 05:43 PM
chafa

When we have a client server topology with the client being a DB2 for Windows and server consisting of DB2 for z/OS - where do we need to install DB2...

whisp_official@yahoo.com

06-26-2009 06:46 PM
pickel@us.ibm.com

Alright, we may be slow, but we're on the move. I have just about completed migration to DB2 v8 NFM across my subsystems. The next thing I'm doing...

Roy Morse

06-25-2009 09:48 AM
db2@dts.ca.gov

Does this type of submittal violate the etiquette of the forum? Don't use the forums to advertise or publicize any event or product. We will delete...

db2@dts.ca.gov

06-24-2009 10:43 AM
db2@dts.ca.gov