1. Login as datastage server administrator user in your UNIX machine where
DataStage Server is installed.
2. cd into DataStage home directory. You can enter "cat /.dshome" to find the DataStage home directory.
3. Enter ". ./dsenv" (i.e. .space./dsenv) to source the dsenv file.
4. Enter "bin/uvsh". It will bring you into UV Administration menu. Hit ESC key to get out of the menu and it bring you to ">" TCL prompt.
5. At TCL prompt, you can enter "LOGTO project name" to log into the project account. The project name is case sensitive.
6. To find out what the job description number, enter "LIST DS_JOBS
job name".
7. Enter "LIST.READU EVERY" at TCL. Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number.
8. Write down the inode number and user number for the lock that is not a valid lock.
9. Enter "LOGTO UV" to log into UV account. The UNLOCK command lives in UV account.
10. Enter "UNLOCK INODE inode# USER user# ALL". This will unlock the lock hold on this file (inode#) and hold by this user (user#) for file locks, group locks and record locks.
If you need to see all the locks again, enter "LIST.READU EVERY". OR Enter "UNLOCK USER user# ALL"
11. Type Q to logout of Universe.
2. cd into DataStage home directory. You can enter "cat /.dshome" to find the DataStage home directory.
3. Enter ". ./dsenv" (i.e. .space./dsenv) to source the dsenv file.
4. Enter "bin/uvsh". It will bring you into UV Administration menu. Hit ESC key to get out of the menu and it bring you to ">" TCL prompt.
5. At TCL prompt, you can enter "LOGTO project name" to log into the project account. The project name is case sensitive.
6. To find out what the job description number, enter "LIST DS_JOBS
job name".
7. Enter "LIST.READU EVERY" at TCL. Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number.
8. Write down the inode number and user number for the lock that is not a valid lock.
9. Enter "LOGTO UV" to log into UV account. The UNLOCK command lives in UV account.
10. Enter "UNLOCK INODE inode# USER user# ALL". This will unlock the lock hold on this file (inode#) and hold by this user (user#) for file locks, group locks and record locks.
If you need to see all the locks again, enter "LIST.READU EVERY". OR Enter "UNLOCK USER user# ALL"
11. Type Q to logout of Universe.
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Datastage, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Sangita Mohanty
MaxMunus
E-mail: sangita@maxmunus.com
Ph:(0) 9738075708 / 080 - 41103383
http://www.maxmunus.com/