 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 33 matches |
| Author | Message |
|---|---|
 Topic: DB2 702 or 703? |
|
| Catherine Replies: 1 Views: 1213 |
 Forum: Database Posted: Tue Jun 08, 2010 5:45 am Subject: DB2 702 or 703? |
| Hi friends,
I have application development experience in mainframe technologies of nearly 5 years . I have already taken up DB2 700 exam and thinking of which to do next. Although i donot have ... |
|
| Topic: -438 sqlcode |
|
| Catherine Replies: 9 Views: 10895 |
Forum: Database Posted: Wed Jul 01, 2009 7:51 am Subject: -438 sqlcode |
| Hi dina,
Thanks very much for info |
|
| Topic: -438 sqlcode |
|
| Catherine Replies: 9 Views: 10895 |
Forum: Database Posted: Wed Jul 01, 2009 4:30 am Subject: -438 sqlcode |
| Hi,
Im getting -438 SQLCODE while inserting a row in DB2 table. Can you please help me why is this error occuring. Imnt able to underatand the description provided for this sqlcode Thanks Cathe ... |
|
| Topic: AFCY abend |
|
| Catherine Replies: 0 Views: 2493 |
Forum: CICS and Middleware Posted: Fri Apr 03, 2009 6:39 am Subject: AFCY abend |
| When 2 transactions try to WRITE the same record to a File one after the other, assume that the transactions are not committed at this point in time
Will not one of the transactions encounter DUPLI ... |
|
| Topic: File Deadlock |
|
| Catherine Replies: 2 Views: 2249 |
Forum: CICS and Middleware Posted: Fri Mar 27, 2009 3:02 am Subject: File Deadlock |
| Thanks Kolusu
My VSAM File is defined to have a SHARE OPTION ( 2 3) T1 & T2 transactions belong to the same CICS region Other SHARE OPT 3, 4 are not recommended as per our standards This m ... |
|
| Topic: File Deadlock |
|
| Catherine Replies: 2 Views: 2249 |
Forum: CICS and Middleware Posted: Thu Mar 26, 2009 7:11 am Subject: File Deadlock |
| There were 2 transactions T1, T2 corresponding to a Single Program P which were trying to WRITE to the File F1
( T1 , T2 are multiple transaction running on a single program ) The Program P actual ... |
|
| Topic: File Deadlock |
|
| Catherine Replies: 0 Views: 1625 |
Forum: CICS and Middleware Posted: Thu Mar 26, 2009 7:10 am Subject: File Deadlock |
| There were 2 transactions T1, T2 corresponding to a Single Program P which were trying to WRITE to the File F1
( T1 , T2 are multiple transaction running on a single program ) The Program P actual ... |
|
| Topic: RLSA abend |
|
| Catherine Replies: 2 Views: 1726 |
Forum: CICS and Middleware Posted: Fri Jan 04, 2008 7:26 am Subject: RLSA abend |
| Hi,
My transaction encounters an RLSA abend. The Processing is as below A Links B B Links C C Links D Since the Linking through Programs A thru D is a Single unit of work, All the Workin ... |
|
| Topic: EXECUTE IMMEDIATE |
|
| Catherine Replies: 2 Views: 1201 |
Forum: Database Posted: Fri Dec 07, 2007 8:32 am Subject: EXECUTE IMMEDIATE |
| Hi all,
Please let me know how and when a EXECUTE IMMEDIATE statement is used. Will it help to improve my performance of the Query? I understand that EXECUTE IMMEDIATE can be used starting from D ... |
|
| Topic: Group by on 3 Columns and get unique rows query |
|
| Catherine Replies: 9 Views: 4526 |
Forum: Database Posted: Tue Mar 27, 2007 8:52 am Subject: SQL Query |
| Kolusu,
I just want to confirm this The output of this Query SELECT A.ID, A.NAME, B.TRNS FROM EMP A, TRANSACTION B WHERE A.ID = B.ID GROUP BY A.ID, A.NAME, B.TRNS will be 1 A CR ... |
|
| Topic: Group by on 3 Columns and get unique rows query |
|
| Catherine Replies: 9 Views: 4526 |
Forum: Database Posted: Tue Mar 27, 2007 7:24 am Subject: SQL Query |
| Nic,
I get the same result |
|
| Topic: Group by on 3 Columns and get unique rows query |
|
| Catherine Replies: 9 Views: 4526 |
Forum: Database Posted: Tue Mar 27, 2007 6:51 am Subject: SQL Query |
| Nic,
Sorry thats B.TRNS instead of B.TRNS_TY SELECT A.ID, A.NAME, B.TRNS FROM EMP A, TRANSACTION B WHERE A.ID = B.ID GROU ... |
|
| Topic: Group by on 3 Columns and get unique rows query |
|
| Catherine Replies: 9 Views: 4526 |
Forum: Database Posted: Tue Mar 27, 2007 5:18 am Subject: Group by on 3 Columns and get unique rows query |
| Hi,
I have got 2 tables Table Emp: ID Primary key ID NAME 1 A 2 B 3 C 4 D Table TRANSACTION ID TRNS DATE 1 CR ... |
|
| Topic: isolation levels |
|
| Catherine Replies: 13 Views: 7715 |
Forum: Database Posted: Fri Mar 23, 2007 3:17 am Subject: Isolation levels |
| Christian,
Suppose i have defined LOCKSIZE=PAGE, I query the table with a SELECT statement. When I try to retrieve a row 1) The page containing the Row is put in "Share" Lock mode ... |
|
| Topic: isolation levels |
|
| Catherine Replies: 13 Views: 7715 |
Forum: Database Posted: Wed Mar 21, 2007 4:50 am Subject: isolation levels |
| Kolusu,
Can you plz refer this link and explain me? http://www.dbazine.com/db2/db2-mfarticles/mullins4 In the above article under table locks and tablespace locks i find that even if i giv ... |
|
All times are GMT - 5 Hours |