DSXchange

Hello,

I am trying to get DataStage users logged in into Designer at UVSH.
The method I am using is to list the user locks.
Problem is that, I am getting only 80 characters in my output which truncates the Item-ID. I want to list the full strings. I read one of the thread that talks about setting up the UVSH term type.
I am using putty.
I tried:
SET.TERM.TYPE WIDTH 132

now at UNIX command prompt I am running uvtic..it is hanging there for last 15 mins or so.
What am I doing wrong?

uvtic?

You have to forgive my lack of knowledge on uvsh...I just read one of the thread...and tried those things..

http://dsxchange.com/viewtopic.php?t=11 ... e52173009d

The SET.TERM.TYPE command isn't a UNIX command, but needs to be executed inside the TCL session, i.e. when you have the ">" prompt.

That is what I did...:
>GET.TERM.TYPE
xterm terminal emulator (xterm)
Width : 80
Depth : 65
Map : ISO8859-1
>SET.TERM.TYPE WIDTH 132
xterm terminal emulator (xterm)
>GET.TERM.TYPE
xterm terminal emulator (xterm)
Width : 132
Depth : 65
Map : ISO8859-1
>LIST.READU ALL

Active Record Locks:
Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID.............
71864456 51678 0 58757 86 RL 6779 zakup BCA_US&!DS.ADMIN!&

====================
It still does not give me longer string for "BCA_US&!DS.ADMIN!&"...I want to filter the entries by client and produce a log.

vipson wrote:You have to forgive my lack of knowledge on uvsh...I just read one of the thread...and tried those things..

http://dsxchange.com/viewtopic.php?t=11 ... e52173009d

Ha! And mine, too, it seems. I've not seen that particular command in a long while and forgot about the whole "Term Info Compiler" needed for stuff like that.

the "Item-ID" column output is not affected by the terminal width setting. The items are listed correctly, though. The item ID you displayed is the complete record ID that is locked.

So, how do I get the information about locks held by users per project/client type.
My basic purpose of this is to:
1. Manger users per project, leverage budget etc.
2. Capacity planning - user licenses

LIST.READU (list_readu) is hard coded for 80 column output. The device width does not affect that.

You can use LIST.READU INTERNAL to capture the data into a dynamic array and DataStage BASIC routine to format it however you like.

In version 8 you probably really need to interrogate the XMETALOCKINFO table.

I tried that...but the output still is almost same without spaces in between the values that I would get from LIST.READU ALL.

XMETALOCKINFO had the user info but I am struggling to connect one of the column to identify what client was used.

It (the output from LIST.READU INTERNAL) is a dynamic array. You have to extract the date from the dynamic array using DataStage BASIC.

You are at the forefront of those trying to understand the relationships between tables in the unified metadata repository. Good luck.