Search found 20 matches

by sonakasi
Wed Jan 04, 2012 8:03 pm
Forum: JCL INTERVIEW QUESTIONS
Topic: GDG interview question
Replies: 10
Views: 12739

Hi Anuj,
After completion of the job, the current version will always point to the one successfully created and it will be version '0' and thats why in the above job you have mentioned as ''You'll have HLQ.FIRST.GDG..G0001V00"..... am I right in telling that ???
by sonakasi
Wed Jan 04, 2012 4:24 pm
Forum: JCL INTERVIEW QUESTIONS
Topic: GDG interview question
Replies: 10
Views: 12739

Thanks for your reply !!
by sonakasi
Tue Jan 03, 2012 8:12 pm
Forum: JCL INTERVIEW QUESTIONS
Topic: GDG interview question
Replies: 10
Views: 12739

GDG interview question

Hi All, I have 2 questions on GDG QUES1 : A Job has 3 steps 1) Step01 creating New GDG file(+), 2) Step02 Input from step01 3) Step03 Input from Step02 When we run this job, it gets an abend in step02, so when we restart the job what will be the version of file. ??? QUES2: A Job has 3 steps 1) Step0...
by sonakasi
Fri Dec 30, 2011 3:17 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: DB2 check utility ??
Replies: 4
Views: 4374

Thank you :D
by sonakasi
Fri Dec 30, 2011 3:15 pm
Forum: ABEND CODES / ERROR CODES
Topic: SOC 7 abend - interview question
Replies: 13
Views: 21470

Hi DikDude,
core dump here you talk about..is it CEEDUMP ???
by sonakasi
Fri Dec 30, 2011 2:36 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 109405

Hi Krishna,


I would like to read DB2 ebook, Kindly provide me the password for 631.
Thanks in Advance.
by sonakasi
Thu Dec 29, 2011 7:54 pm
Forum: ABEND CODES / ERROR CODES
Topic: SOC 7 abend - interview question
Replies: 13
Views: 21470

SOC 7 abend - interview question

Hi All, I have been questioned as , If we are processing through millions of records and we get a SOC7 abend, so how do you find out where excatly its abended and how do you resolve this ?? Answer : When we run the program and it abends with SOC7, we have to take the last 4 bytes in compiler listing...
by sonakasi
Thu Dec 29, 2011 4:10 pm
Forum: JCL
Topic: JCL syntax check
Replies: 4
Views: 4260

Thank you very much :D
by sonakasi
Thu Dec 29, 2011 1:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Having multiple indexes on a table ???
Replies: 2
Views: 2529

Having multiple indexes on a table ???

Hi all,

In our project, we have a table, which is having too many index and I think having too many index will affect performance.
Can some one explain if this right and the reason ??
by sonakasi
Thu Dec 29, 2011 1:33 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: DB2 check utility ??
Replies: 4
Views: 4374

Sorry for posting the question with very less information.

actually I have been asked for DB2 check utility in an interview, But in my present organisation, I dont have possibility to use this utility in DB2.

I answered as this utility checks for data and index consistencies.
by sonakasi
Thu Dec 29, 2011 1:23 pm
Forum: DB2 INTERVIEW QUESTIONS
Topic: SQLCODE -818
Replies: 2
Views: 2845

thank you :D
by sonakasi
Thu Dec 29, 2011 1:19 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Mass delete using cursors
Replies: 4
Views: 4263

Thanks for explanation.... :D
by sonakasi
Thu Dec 29, 2011 1:14 pm
Forum: JCL
Topic: Difference between internal sort and external sort
Replies: 2
Views: 3967

Thank you very much !!!
by sonakasi
Thu Dec 29, 2011 1:12 pm
Forum: JCL
Topic: JCL syntax check
Replies: 4
Views: 4260

Thank you very much...but is there some command called 'JSCAN' to perform the same ???
I have answer to the interviewer as 'TYPRUN=SCAN'
by sonakasi
Wed Dec 28, 2011 5:06 pm
Forum: JCL
Topic: JCL syntax check
Replies: 4
Views: 4260

JCL syntax check

Hi All,

Interview question in Attra, How do you check the syntax of JCL without submitting the job.

Ans : TYPERUN = SCAN

Please clarify.