dbTalk Databases Forums  

Sponsored Links


ibm.software.db2.mvs ibm.software.db2.mvs


Discuss in the ibm.software.db2.mvs forum.



Post New Thread
Threads in Forum : ibm.software.db2.mvs Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
3 196
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 Go to last post
7 235
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 Go to last post
3 197
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 Go to last post
1 276
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 Go to last post
3 164
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 Go to last post
4 732
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 Go to last post
4 203
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 Go to last post
3 158
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 Go to last post
2 147
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 Go to last post
2 210
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 Go to last post
1 186
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 Go to last post
2 193
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 Go to last post
1 132
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 Go to last post
1 255
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 Go to last post
2 205
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 Go to last post
1 180
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 Go to last post
2 202
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 Go to last post
3 184
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 Go to last post
1 147
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 Go to last post
2 193
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 Go to last post
1 203
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 Go to last post
2 210
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 Go to last post
2 252
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 Go to last post
1 167
(DAYS(CURRENT_DATE - 2 MONTHS) - days('12/31/1899')) Thanks in advance
lzlzgh@yahoo.com
06-19-2009 07:54 PM
Jan M. Nelken Go to last post
2 251
Hi All: Has anyone tried to execute a cobol subprogram from within an sql stored procedure? Your help is appreciated
isaac.el-serafi@agricorp.com
06-09-2009 11:17 AM
isaac.el-serafi@agricorp.com Go to last post
4 265
Hi All: Is any one tried to : 1.Call COBOL program from a DB2 SQL stored procedure or 2.Fire a jcl job from a stored procedure Your advise is truly...
isaac.el-serafi@agricorp.com
06-09-2009 10:52 AM
momi.sabag@gmail.com Go to last post
1 223
I am trying to load/unload LOB data between DB2 UDB on LUW and z/OS. The original record is pre-existing on the mainframe table and only the LOB...
bnagarat@in.ibm.com
06-07-2009 04:13 AM
Go to last post
1 189
I've been trying to determine when and how VPPSEQT would come into play, or what specific functionality would take advantage of adjusting its...
db2@dts.ca.gov
05-15-2009 03:00 PM
db2@dts.ca.gov Go to last post
1 256
Hi, I would like to know if there is a way to mask/remove the Codes/Input Statement used in SYSIN appearing in the SYSPRINT. Thanks
new2db2@gmail.com
05-15-2009 11:50 AM
rraghav28ster@gmail.com Go to last post
1 170
This is for DB2 8.1.5 running on z/OS mainframe... Say you have a table with a million rows and you want to prevent users from overwhelming the...
05-13-2009 05:53 AM
sdasinger@monlife.com Go to last post
3 230
first scenario: in my program the first DB2 statement is : EXEC SQL SELECT CURRENT TIMESTAMP INTO: WS-TIMESTAMP FROM SYSIBM.SYSDUMMY1 END-EXEC. the...
lognet@tiscali.it
05-12-2009 10:22 AM
Andreas Lerch Go to last post
11 407
DB2 connect is used to access our DB2 V8 zos database. When our batch runs we would like to prevent our end users from submitting queries via DB2...
rgrieco@btmna.com
05-08-2009 02:10 PM
jeffrey.s.debo@usps.gov Go to last post
5 252
Hi All, I was trying to update DB2 table. I already had a temporary table whose data I needed to refer to update my table. Now when the rows in temp...
sushil.nayak@gmail.com
05-01-2009 10:10 AM
db2@dts.ca.gov Go to last post
1 207
Hi All , Would you know where I can find docs and manuals about Pricenton softech tools for DB2? IBM own these tools now and called it Optim , but...
marcosbalb@ig.com.br
04-24-2009 04:06 PM
sdasinger@monlife.com Go to last post
1 201
Hi Experts, I am having trouble in retrieving the results from a table using select query. I have a table (Users) as below Name (VARG) ...
ballanarasimhamurthy@gmail.com
04-17-2009 09:10 AM
sdasinger@monlife.com Go to last post
2 219
Hello, It seems, the parsing of UNDO/REDO records is problematic with the new Reordered Row Format, RRF (see the attached file, please). Do anybody...
alex@bsafesolutions.com
04-16-2009 09:39 AM
db2@dts.ca.gov Go to last post
5 262
Since SYSUTILX and SYSLGRNX cannot be reorged, how do I relocate the datasets if not using SMS? Do I simply delete and define the TableSpace...
Roy Morse
04-10-2009 11:07 AM
krk@krw.ru Go to last post
1 217
Hello *Guyz*, I have a doubt in calculating the record length in a page(4KB). I calculated like in the following..... 4KB = 4096; Page Header = 22,...
Sushanth Bobby Lloyds
04-08-2009 01:02 PM
db2@dts.ca.gov Go to last post
1 225
I have a table with two columns. ID - char comment - clob. When I created the table, I see "DB2_GENERATED_ROWID_FOR_LOBS" column with type name...
caesarkim
04-03-2009 04:13 PM
sdasinger@monlife.com Go to last post
1 182
I am getting an error "IEF450I GO - ABEND=S04C U0000 REASON=00000000" . Can u tell me what may be the reason for this abend? On that step I am...
rajasekaran.rajamanickam@tcs.com
03-31-2009 10:00 AM
gnanas.sekar@gmail.com Go to last post
7 474
Is it necessary to specify the files in JCL on the same order which is specified in COBOL program?
rajasekaran.rajamanickam@tcs.com
03-31-2009 05:58 AM
sdasinger@monlife.com Go to last post
1 184
Can anyone tell me, what is Row-level access and Table-level access in DB2?
rajasekaran.rajamanickam@tcs.com
03-27-2009 07:30 AM
rajasekaran.rajamanickam@tcs.com Go to last post
4 249
Hi, i'm trying to predict the growth rate in mb of a partitioned tablespace broken down by partition (63 in all) up to March 2012. Has anyone any...
bryan.deeprose@british-energy.com
03-24-2009 10:33 AM
db2@dts.ca.gov Go to last post
2 288
hello.. i am trying to retrieve all the table names from DB2 database. can someone tell me the procedure to do that? any sample code will also be of...
suchismita_sen@syntelinc.com
03-24-2009 05:11 AM
sdasinger@monlife.com Go to last post
1 208
We're trying to build our C/C++ app in 64-bit mode using the XL C/C++ compiler and the compile option LP64. Our program source compiles fine, but...
john.carter@oracle.com
03-23-2009 05:24 AM
miklos.szigetvari@isis-papyrus.com Go to last post
2 288
This customer site is using DB2 for z/OS v7. The application is using DB2 plans only, no packages yet. The online system is very active, and during...
kimchin@gmail.com
03-18-2009 10:50 AM
kimchin@gmail.com Go to last post
2 246
Hi, Does anyone have a sample of an SP called from COBOL that uses indicator variables to pass nullable parameters? I’m using the Dev. Ctr. in...
bjohnso1@edd.ca.gov
03-13-2009 08:27 AM
Todd Burch Go to last post
1 195
I couldn't find any examples of using multi-row inserts when calling a stored procedure via JDBC. Is this possible on DB2 v8 on z/OS? Thanks
03-09-2009 08:49 AM
nickvalo@hotmail.com Go to last post
2 262
Hi, We create stored procedure with Rational Business Developer on DB2 V8 on Z/10. When I run a stored procedure with a tool ( example:...
Eric
03-06-2009 09:04 PM
Todd Burch Go to last post
2 277
Post New Thread

Display Options
Showing threads 51 to 100 of 613
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.