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...
07-29-2009 05:31 AM
momi.sabag@gmail.com Go to last post
3 206
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...
07-24-2009 06:30 PM
Todd Burch Go to last post
7 317
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...
07-24-2009 05:08 AM
3 216
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 344
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...
07-22-2009 01:42 PM
pickel@us.ibm.com Go to last post
3 190
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 820
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...
07-21-2009 09:43 PM
Todd Burch Go to last post
4 243
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...
07-21-2009 09:42 PM
Todd Burch Go to last post
3 174
How to display from ISPF DB2 connection locks, open transactions, connection status. The only command I found so far is -display thread (*).
07-19-2009 02:24 PM
alexg00@hotmail.com Go to last post
2 164
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...
07-18-2009 03:44 PM
Todd Burch Go to last post
2 236
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...
07-17-2009 06:29 AM
sdasinger@monlife.com Go to last post
1 204
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 211
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...
07-13-2009 10:51 AM
momi.sabag@gmail.com Go to last post
1 161
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...
07-12-2009 01:16 PM
momi.sabag@gmail.com Go to last post
1 296
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...
07-08-2009 08:03 PM
alexg00@hotmail.com Go to last post
2 224
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...
07-06-2009 09:29 PM
Todd Burch Go to last post
1 200
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...
07-06-2009 09:26 PM
Todd Burch Go to last post
2 212
Hi, The target table has one extra column. how can I skip that column while loading?
07-06-2009 09:22 PM
Todd Burch Go to last post
3 194
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...
07-06-2009 03:25 PM
db2@dts.ca.gov Go to last post
1 158
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...
07-02-2009 10:31 AM
arens@de.ibm.com Go to last post
2 205
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...
06-30-2009 12:48 AM
pgkrish@yahoo.com Go to last post
1 214
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...
06-29-2009 05:43 PM
chafa Go to last post
2 228
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...
06-26-2009 06:46 PM
pickel@us.ibm.com Go to last post
2 267
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 181
(DAYS(CURRENT_DATE - 2 MONTHS) - days('12/31/1899')) Thanks in advance
06-19-2009 07:54 PM
Jan M. Nelken Go to last post
2 265
Hi All: Has anyone tried to execute a cobol subprogram from within an sql stored procedure? Your help is appreciated
06-09-2009 11:17 AM
isaac.el-serafi@agricorp.com Go to last post
4 282
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...
06-09-2009 10:52 AM
momi.sabag@gmail.com Go to last post
1 241
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...
06-07-2009 04:13 AM
Go to last post
1 199
I've been trying to determine when and how VPPSEQT would come into play, or what specific functionality would take advantage of adjusting its...
05-15-2009 03:00 PM
db2@dts.ca.gov Go to last post
1 270
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
05-15-2009 11:50 AM
rraghav28ster@gmail.com Go to last post
1 176
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 261
first scenario: in my program the first DB2 statement is : EXEC SQL SELECT CURRENT TIMESTAMP INTO: WS-TIMESTAMP FROM SYSIBM.SYSDUMMY1 END-EXEC. the...
05-12-2009 10:22 AM
Andreas Lerch Go to last post
11 438
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...
05-08-2009 02:10 PM
jeffrey.s.debo@usps.gov Go to last post
5 271
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...
05-01-2009 10:10 AM
db2@dts.ca.gov Go to last post
1 220
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...
04-24-2009 04:06 PM
sdasinger@monlife.com Go to last post
1 211
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) ...
04-17-2009 09:10 AM
sdasinger@monlife.com Go to last post
2 232
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...
04-16-2009 09:39 AM
db2@dts.ca.gov Go to last post
5 277
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 223
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 236
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...
04-03-2009 04:13 PM
sdasinger@monlife.com Go to last post
1 193
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...
03-31-2009 10:00 AM
gnanas.sekar@gmail.com Go to last post
7 510
Is it necessary to specify the files in JCL on the same order which is specified in COBOL program?
03-31-2009 05:58 AM
sdasinger@monlife.com Go to last post
1 206
Can anyone tell me, what is Row-level access and Table-level access in DB2?
03-27-2009 07:30 AM
rajasekaran.rajamanickam@tcs.com Go to last post
4 263
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...
03-24-2009 10:33 AM
db2@dts.ca.gov Go to last post
2 303
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...
03-24-2009 05:11 AM
sdasinger@monlife.com Go to last post
1 220
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...
03-23-2009 05:24 AM
miklos.szigetvari@isis-papyrus.com Go to last post
2 309
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...
03-18-2009 10:50 AM
kimchin@gmail.com Go to last post
2 260
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...
03-13-2009 08:27 AM
Todd Burch Go to last post
1 208
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 276
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:...
03-06-2009 09:04 PM
Todd Burch Go to last post
2 295
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 - 2015, Jelsoft Enterprises Ltd.