Author |
Message |
Topic: DB2 UDB 8.2 installation |
Vreddy
Replies: 2
Views: 2170
|
Forum: Database Posted: Mon May 23, 2005 11:18 am Subject: DB2 UDB 8.2 installation |
Thanks a lot Kosulu |
Topic: DB2 UDB 8.2 installation |
Vreddy
Replies: 2
Views: 2170
|
Forum: Database Posted: Mon May 23, 2005 9:44 am Subject: DB2 UDB 8.2 installation |
I downloaded DB2_V82_ESE_WIN_32_NLV from IBM site and installed on my PC(in Office). During installation i used my LAN userid and password. After isntallion I tried to define the DB2 UDB Sample databa ... |
Topic: Stored Procedrue calling a cobol program having SQL statemen |
Vreddy
Replies: 4
Views: 3423
|
Forum: Database Posted: Fri Apr 23, 2004 10:42 am Subject: Stored Procedrue calling a cobol program having SQL statemen |
Kosulu,
do we need to link edit stored procedure also as DSNELI. Our shop is using standard JCL for stored procedures and it it is link editing to DSNRLI.
I am link editing db2-cobol as DSNELI a ... |
Topic: Stored Procedrue calling a cobol program having SQL statemen |
Vreddy
Replies: 4
Views: 3423
|
Forum: Database Posted: Fri Apr 23, 2004 9:43 am Subject: Stored Procedrue calling a cobol program having SQL statemen |
I am getting -927 when a stored procedure calls a cobol program having SQL's
I saw the meaning of -927 it says language interface. I link edited cobol program with DSNELI and Stored procedure as DSNR ... |
Topic: SQL server database |
Vreddy
Replies: 3
Views: 1899
|
Forum: Database Posted: Wed May 28, 2003 1:09 pm Subject: SQL server database |
Can i SQL server database from COBOl/DB2 program running in mainframe. The reason for this is some information is in DB2 and some information is in SQL server databse. I need to extract the informatio ... |
Topic: SYSOUD |
Vreddy
Replies: 7
Views: 7304
|
Forum: Job Control Language(JCL) Posted: Mon Mar 17, 2003 10:12 am Subject: SYSOUD |
Thanks a lot Spolacek. |
Topic: SYSOUD |
Vreddy
Replies: 7
Views: 7304
|
Forum: Job Control Language(JCL) Posted: Tue Mar 11, 2003 5:18 pm Subject: SYSOUD |
Kosulu,
I mean SYSOUD only. I saw this DD name in one my procs and it not defined as a ddname in the program. |
Topic: SYSOUD |
Vreddy
Replies: 7
Views: 7304
|
Forum: Job Control Language(JCL) Posted: Tue Mar 11, 2003 4:19 pm Subject: SYSOUD |
Hi,
Please tell me What is SYSOUD . |
Topic: Performance tuning |
Vreddy
Replies: 5
Views: 4624
|
Forum: Database Posted: Fri Feb 07, 2003 12:43 pm Subject: Performance tuning |
Hi BIthead/Kosulu,
How frequently we need to do Runstats/reorg.. The tables are updated/inserted every day. there will be around 35,000 updates/inserts to the database... |
Topic: Performance tuning |
Vreddy
Replies: 5
Views: 4624
|
Forum: Database Posted: Fri Feb 07, 2003 12:40 pm Subject: Performance tuning |
Hi Kosulu,
The other database is Datacom/DB. I did run the Runstats and reorg and recompiled the programs. It is taking long time. We are testing in test environment. Is there any problem with buff ... |
Topic: Performance tuning |
Vreddy
Replies: 5
Views: 4624
|
Forum: Database Posted: Wed Feb 05, 2003 5:55 pm Subject: Performance tuning |
Hi,
We converted the databse to Db2 and i ran one program in Db2 and in old database. In db2 it is taking 48 seconds and in other database it is taking 4 seconds. I saw the queries in Db2 and all q ... |
Topic: Finding COBOL-DB2 execution status |
Vreddy
Replies: 4
Views: 5501
|
Forum: Database Posted: Mon Feb 03, 2003 4:54 pm Subject: Finding COBOL-DB2 execution status |
Hi Kolusu,
I am using OMEGAMON, but is there any way to see whether the query is uising index or table scan. |
|