MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 12 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: DB2 UDB 8.2 installation
Vreddy

Replies: 2
Views: 2170

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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.
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group