UV 10.1.7 on AIX 5.2.2 The LIST.READU DETAIL returns: >LIST.READU DETAIL
Active Record Locks: Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID............. 2490371 25564 0 34 17 RU 08644 karen-sa 777775 2490371 45272 0 106 18 RU 35872 cp-tracy 001361 2490371 46066 0 225 26 RU 41448 cp-linda 145544 2490371 25460 0 34 27 RU 08644 karen-sa 352017 2490371 25564 0 108 37 RU 60434 jerry-sa 920575 2490371 25975 0 63 40 RU 13830 patti-ac ANGIE 2490371 25288 0 108 49 RU 60434 jerry-sa 351959*024 2490371 24703 0 108 56 RU 60434 jerry-sa 351959*025 2490371 25455 0 34 65 RU 08644 karen-sa 352017 2490371 352452 0 295 71 RU 40888 gary-aw 350701 2490371 25127 0 236 88 RU 74892 arussell 253036*004**524498*001 2490371 24650 0 294 88 RU 86586 clock 013291*2*13731 2490371 25156 0 108 94 RU 60434 jerry-sa 52162*01 > LIST.READU EVERY returns: > >LIST.READU EVERY Active Group Locks: Record Group Group Group Device.... Inode.... Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX 2490371 25331 0 315 12 IN 104000 1 0 0 0 2490371 45272 0 106 18 IN 2A9000 1 0 0 0 2490371 25156 0 108 23 IN 917800 1 0 0 0 2490371 46066 0 225 35 IN 48800 1 0 0 0 2490371 25564 0 49 37 IN 115000 1 0 0 0 2490371 25975 0 26 40 IN 26000 1 0 0 0 2490371 24703 0 108 58 IN 1E800 1 0 0 0 2490371 24942 0 183 64 IN F800 1 0 0 0 2490371 25288 0 108 76 IN 28000 1 0 0 0 2490371 46066 0 225 77 IN 15800 1 0 0 0 2490371 25127 0 133 88 IN 319000 1 0 0 0 Active Record Locks: Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID............. 2490371 25331 0 315 12 RU 00224 young-ac 013647 2490371 45272 0 106 18 RU 35872 cp-tracy 001361 2490371 25156 0 108 23 RU 60434 jerry-sa 52526*01 2490371 46066 0 225 35 RU 41448 cp-linda 145536 2490371 25564 0 108 37 RU 60434 jerry-sa 920575 2490371 25975 0 63 40 RU 13830 patti-ac ANGIE 2490371 24703 0 108 58 RU 60434 jerry-sa 351959*034 2490371 24942 0 59 64 RU 17124 arussell ADJ-IN-USE 2490371 25288 0 108 76 RU 60434 jerry-sa 351959*033 2490371 46066 0 225 77 RU 41448 cp-linda 145536*001 2490371 25127 0 236 88 RU 74892 arussell 253036*004**524498*001 Active Read Waiters: Owner Waiter Device.... Inode.... Userno Userno 2490371 25975 63 26 2490371 25975 63 47 Tom Dodds -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Roberts Sent: Thursday, August 04, 2005 8:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] File name of the RECORDS which are listed in LIST.READU output Doesn't LIST.READU DETAIL give you the file name? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pankaj Gupta04 Sent: Thursday, August 04, 2005 2:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] File name of the RECORDS which are listed in LIST.READU output Hi All, I have some records which are locked. The Item ID is same. Can I get the database filename to which the records belong? I am using Universe at unix platform. The output of LIST.READU is given below: >LIST.READU Active Record Locks: Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID............. 34485434 9968 0 55990 9 RU 9546 appsadm GGB1010300001 34485434 9964 0 37921 12 RU 27615 appsadm CCB1011300764 34485433 478438 0 60553 17 RU 4983 appsadm HHB1010300083 34485433 478423 0 36137 31 RU 29399 appsadm GGB1010300001 34485434 9969 0 52754 63 RU 12782 appsadm FFB1010300015 34485434 9991 0 53543 102 RU 11993 appsadm GGB1010300001 34485434 9964 0 50360 107 RU 15176 appsadm GGB1010300001 34485434 10391 0 47313 121 RU 18223 appsadm GGB1010300001 Regards, Pankaj Gupta **************** CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ########################################### This message has been scanned by F-Secure Anti-Virus. ########################################### This message has been scanned by F-Secure Anti-Virus. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/