Need help setting up UVSH

vipson · Post by **vipson** » Thu Aug 27, 2009 5:42 am

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?

chulett · Post by **chulett** » Thu Aug 27, 2009 5:44 am

uvtic?

vipson · Post by **vipson** » Thu Aug 27, 2009 5:48 am

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

ArndW · Post by **ArndW** » Thu Aug 27, 2009 5:54 am

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.

vipson · Post by **vipson** » Thu Aug 27, 2009 6:03 am

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.

chulett · Post by **chulett** » Thu Aug 27, 2009 8:45 am

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.

ArndW · Post by **ArndW** » Thu Aug 27, 2009 9:14 am

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.

vipson · Post by **vipson** » Thu Aug 27, 2009 12:01 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Aug 27, 2009 4:22 pm

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.

vipson · Post by **vipson** » Thu Aug 27, 2009 5:56 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 27, 2009 6:39 pm

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.