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 34 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Issue with Table locks
pkarthik@email.com

Replies: 2
Views: 4125

PostForum: Database   Posted: Fri May 17, 2019 1:58 pm   Subject: Issue with Table locks
Thanks Kolusu.

I will discuss with my team and DBA to apply page lock or row lock instead of Table lock. Also try to reorder the records to update in different order to avoid contention.

Mulli ...
  Topic: Issue with Table locks
pkarthik@email.com

Replies: 2
Views: 4125

PostForum: Database   Posted: Fri May 17, 2019 1:04 pm   Subject: Issue with Table locks
Hi,

I have a table that has 8 million records. We are performing an initial load in a staging table with 30+ columns. we have 5 COBOL DB2 programs that are updating different columns in a row. DBA ...
  Topic: SOC7 Occured but No COMP-3 data type involvement
pkarthik@email.com

Replies: 7
Views: 7450

PostForum: Application Programming   Posted: Tue Sep 06, 2011 10:58 pm   Subject: SOC7 Occured but No COMP-3 data type involvement
Hi All,

This is a existing program executing in production for several years .Failed un-expectedly twice in production last week.

1. C390-Array is defined as X(100).
2. SUB1 has no reference ...
  Topic: SOC7 Occured but No COMP-3 data type involvement
pkarthik@email.com

Replies: 7
Views: 7450

PostForum: Application Programming   Posted: Tue Sep 06, 2011 1:25 am   Subject: SOC7 Occured but No COMP-3 data type involvement
We received below error.

The system detected a data exception (System Completion Code=0C7).
From compile unit BSP390 at entry point BSP390 at compile unit offset +00000DC4 at entr ...
  Topic: Selecting MAXIMUM and Minimum Value in DB2
pkarthik@email.com

Replies: 6
Views: 3708

PostForum: Database   Posted: Tue Jul 08, 2008 5:42 pm   Subject: Selecting MAXIMUM and Minimum Value in DB2
Thanks JSharon,
I will follow this for all the queries
  Topic: Selecting MAXIMUM and Minimum Value in DB2
pkarthik@email.com

Replies: 6
Views: 3708

PostForum: Database   Posted: Tue Jul 08, 2008 5:40 pm   Subject: Selecting MAXIMUM and Minimum Value in DB2
HI,
My Query is


SELECT F.CU_ITEM_NUMBER
, F.TU_SUFFIX
, MIN(F.PO_UNIT_COST)
...
  Topic: Selecting MAXIMUM and Minimum Value in DB2
pkarthik@email.com

Replies: 6
Views: 3708

PostForum: Database   Posted: Tue Jul 08, 2008 12:51 am   Subject: Selecting MAXIMUM and Minimum Value in DB2
Hi,
I did not provide the where caluse.

I have different where clauses. So Getting two rows because of UNION.


To be simple. I require maximum of Union and Minimum of Union.

Regards,
Kart ...
  Topic: Selecting MAXIMUM and Minimum Value in DB2
pkarthik@email.com

Replies: 6
Views: 3708

PostForum: Database   Posted: Tue Jul 08, 2008 12:25 am   Subject: Selecting MAXIMUM and Minimum Value in DB2
Hi all ,
I need a single row having the maximum of UNIT_COST and Minimum of UNIT_COST.

As I have two select clause. I am getting two seperate rows. Please helkp me in thsi regard.


SELECT F. ...
  Topic: Problem in Update Query
pkarthik@email.com

Replies: 8
Views: 3972

PostForum: Database   Posted: Tue Nov 06, 2007 12:27 am   Subject: Problem in Update Query
Thanks Dick and Sharon.

SET ENT_QTY_CURRENT = 0
,ENT_VAL_CURRENT = 0

worked out well.
  Topic: Problem in Update Query
pkarthik@email.com

Replies: 8
Views: 3972

PostForum: Database   Posted: Mon Nov 05, 2007 5:29 am   Subject: Problem in Update Query
Hi,
Please find my compile listig.

My code is as below.

1154 C4000-UPDATE-TABLES SECTION.
1155 EXEC SQL ...
  Topic: Problem in Update Query
pkarthik@email.com

Replies: 8
Views: 3972

PostForum: Database   Posted: Mon Nov 05, 2007 4:39 am   Subject: Problem in Update Query
Hi,
I have to update selective rows in a table after performing an innerjoin.I am getting an error saying syntax error.Please help me in this regard.I am new to DB2.

Showing error in below set sta ...
  Topic: How to get current date using sort card???
pkarthik@email.com

Replies: 3
Views: 12102

PostForum: Utilities   Posted: Mon May 21, 2007 11:00 am   Subject: How to get current date using sort card???
Hi Kolusu,

Sorry I didnt get exactly how the date can be got from the syste, using sort card. Can you pls expalin me breifly?? . I would be a great help for me.

Cheers,
Karthik P
  Topic: How to get current date using sort card???
pkarthik@email.com

Replies: 3
Views: 12102

PostForum: Utilities   Posted: Mon May 21, 2007 10:30 am   Subject: How to get current date using sort card???
Is there any possibility to get current date from the system using sort card without writing a cobol program.

Can any one help me out with this???
  Topic: How to remove a Hex char from a variable length file
pkarthik@email.com

Replies: 2
Views: 2347

PostForum: Job Control Language(JCL)   Posted: Thu Oct 12, 2006 10:41 pm   Subject: How to remove a Hex char from a variable length file
Hi, we have a requirement to remove a hexadecimal value which might appear at any position in a variable length record. sample given below.

Here is an extract :

:21S:ABCDE
:21R: ...
  Topic: Linkage section signed number passing
pkarthik@email.com

Replies: 6
Views: 3388

PostForum: Application Programming   Posted: Thu Jun 08, 2006 10:28 pm   Subject: Linkage section signed number passing
Could you please expalin me how come 23M=-234.
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group