Clearing user record locks in Universe Database in Datastage |
|
Step - 1:Identify the lockTo identifying the file-item locks- enter command "LIST.READU" this shows user, pid & other relavent data regarding specific file-item locks. See the UniVerse documentation for further explaination. Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID............. 655369 325891 0 45385 49 RU 18448 mrfrear UniVerse\localuv\BudE xpEncTable 655369 59639 0 45385 93 RL 18448 mrfrear development&!DS.ADMIN !& 655369 59639 0 57425 93 RL 06408 mrfrear development&!DS.ADMIN !& Step - 2: Clearing the lockYou need to use UNLOCK command for this. For the above example enter Syntax for UNLOCK command:UNLOCK [NODE node] [USER user.number] [FILE pathname | [DEVICE device.number] [INODE i.node.number]] [GROUP group.address] [RECORD record.ID] {FILELOCK | GROUPLOCK | READULOCK | READLLOCK | ALL} |
Free tutorials on fundamental concepts of business intelligence and data warehousing: