Search found 537 matches

by Natarajan
Mon Apr 09, 2012 2:38 pm
Forum: CICS
Topic: Difference between TSQ AND TDQ
Replies: 2
Views: 7471

TDQs are read destructive.. as soon as read occurs on a record, that record will get deleted from TDQ.

Whereas, in TSQ, program can read the records sequentailly (or) randomly. it wont delete records when read happened.
by Natarajan
Mon Apr 09, 2012 12:47 pm
Forum: CICS
Topic: Need of Queue concepts in CICS
Replies: 4
Views: 8419

.2 cents on this.

DFHCOMMAREA has storage limitation, only limited data can be passed to next level program. TSQ, TDQ solves this issue. DFHCOMMAREA data wont be avaiable after program terminates. Queues solve this issue also.
by Natarajan
Fri Jan 07, 2011 9:49 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22884

Oh.. thanks anuj for pointing out.

here is the link..

http://publibz.boulder.ibm.com/cgi-bin/ ... 4240&CASE=
by Natarajan
Wed Jan 05, 2011 6:10 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22884

S04E S04E abend while loading.

another reason why use job had failed is ..because of invalid data loading to the table.

Refer below ibm manual for S04E
by Natarajan
Mon Jan 03, 2011 6:28 pm
Forum: CICS
Topic: suggest me certification
Replies: 1
Views: 4527

some of the tips, to keep updating your knowledge.

1. participate in discussion forums
2. go thru the ibm manuals / red books / tutorials avaiable online for
COBOL, JCL, DB2, CICS.
by Natarajan
Mon Jan 03, 2011 6:26 pm
Forum: JOB DISCUSSION
Topic: Please post new job vacancies for2 + exp in mainframe tech?
Replies: 1
Views: 5390

Hi,

as per my knowledge Capgemini ( Hyderabad/pune ) have interviews on this week end. J.P.morgan also started recruitment in hyderabad. I dont exact mail ids of HR.


request to other members of this board, please share the mail ids of H.R.
if you have.
by Natarajan
Mon Jan 03, 2011 6:12 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22884

Try to contact your DBA group to solve this issue. If you feel , the problem is with your jcl. post the jcl step that you have used. so that we can analyse and tell some suggestion, if any changes are required. another suggestion is , get DB2 e-book , where you have load jcl explained well. since yo...
by Natarajan
Sun Jan 02, 2011 9:47 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Database RW,UTUT Error - S04E loading data
Replies: 9
Views: 22884

do you have step to remove copy pending status after load step?
by Natarajan
Sun Jan 02, 2011 9:18 pm
Forum: COBOL
Topic: msg
Replies: 3
Views: 6292

Main tech / other providers provide mainframe access which can be accesses from home. they charge monthly.
by Natarajan
Sun Jan 02, 2011 8:56 pm
Forum: COBOL
Topic: need explanation on flow of perform stmt?
Replies: 6
Views: 10166

following cobol material from mainframegurukul , may be useful to you to learn cobol.

http://www.mainframegurukul.com/tutoria ... orial.html
by Natarajan
Fri Dec 24, 2010 5:59 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: COBOL DB2 Program tuning
Replies: 1
Views: 3925

some of my suggestions.. 1. since you are processing more records.. make sure you do commits for less intervals.. aprrox. 25 to 50 records. 2. Make sure you defined enough buffer pools... DBA has to take care of this 3. while updating records, make sure you use the all indexed fields in the db2 sql ...
by Natarajan
Fri Dec 24, 2010 5:49 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to load data from a (15,2) table to (16,0) table
Replies: 3
Views: 5711

one solution is .. unload data from source table..
convert the file using cobol program to 16,0 length.. based on business rules provided by the client.

load that file to target db2 table.
by Natarajan
Tue Dec 14, 2010 4:48 pm
Forum: Entertainment
Topic: How technology has impacted us
Replies: 2
Views: 7375

ha .. ha.. ha.. :) ..
Really.. even though technology has provided valuable things to live with....
In long run... we are getting impacted badly due to more usage of technology...
by Natarajan
Thu Dec 09, 2010 2:26 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to check the date of data load into a Table
Replies: 4
Views: 7480

You should have that data in SYSIBM tables.
try searching in SYSIBM.SYSTABLES.
by Natarajan
Thu Dec 09, 2010 2:22 pm
Forum: FILE-AID
Topic: XREF and XMLGEN
Replies: 1
Views: 5228

I have used this option for a normal file. it is worked well.
For your requiredment use XREF.. it will create the xml , for all headers, data formats.