Page 1 of 1
user information in ds 8.1
Posted: Tue Jul 13, 2010 12:28 pm
by meet_deb85
Hi All,
can anyone tell me the that in datastage 8.1 which table stores all user created information with date and timestamp.
I think it is store in XMETA database but dont know the table name.
Please help me to get this info.
Thanks
Posted: Tue Jul 13, 2010 1:06 pm
by chulett
Do you mean when the users themselves were created, or when those users have created something else, jobs for example? What kind of 'number' are you seeing?
Posted: Tue Jul 13, 2010 1:14 pm
by meet_deb85
Thanks for your quick responce,
Just i have checked one random table and found that the datatype of timestamp is bigint
Code: Select all
describe table XMETA.AGENT_XMETAGEN_NAMEVALUE5874305
Column Type Type
name schema name Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
XMETA_CREATION_TIMESTAMP_XMETA SYSIBM BIGINT 8 0 Yes
And i want those userid's date of creation who is accessing the datastage like creating jobs and those who is accessing information server.
Posted: Tue Jul 13, 2010 2:09 pm
by meet_deb85
Please help me to get date value.. is there any conversion function??
Posted: Tue Jul 13, 2010 2:14 pm
by chulett
No clue as you haven't let us know what database you are using for XMETA storage, nor provided any samples of what they look like.
Posted: Tue Jul 13, 2010 2:25 pm
by meet_deb85
chulett wrote:No clue as you haven't let us know what database you are using for XMETA storage, nor provided any samples of what they look like. ...
Hi,
XMETA is stored on Oracle database and here i m giving u the sample.
XMETA_CREATED_BY_USER_XMETA|XMETA_CREATION_TIMESTAMP_XMETA|XMETAMODIFICATIONTIMESTAMPXMET|XMETA_MODIFIED_BY_USER_XMETA
SRVLAJ-DSADMIN|12,65,16,54,66,361|12,76,28,19,56,971|KALLAS01
Here 12,65,16,54,66,361 value is in integer and i want a date format.
Is it possible to get date format?
Posted: Tue Jul 13, 2010 2:27 pm
by chulett
I'm sorry but how is "12,65,16,54,66,361" any kind of an integer? How did you select this value?
Posted: Tue Jul 13, 2010 2:38 pm
by meet_deb85
chulett wrote:I'm sorry but how is "12,65,16,54,66,361" any kind of an integer? How did you select this value?
...
Yes that's interesting.
I dont know but in table structure also its coming as Bigint....
but it should be as timestamp.I was asked to get a date from this bigint value.
Posted: Tue Jul 13, 2010 2:45 pm
by chulett
Please answer the second question.
Posted: Tue Jul 13, 2010 3:08 pm
by meet_deb85
chulett wrote:Please answer the second question. ...
select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305
Posted: Tue Jul 13, 2010 9:13 pm
by meet_deb85
meet_deb85 wrote:chulett wrote:Please answer the second question. ...
select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305
can someone tell me how to get date of creation of userid's..??
Posted: Wed Jul 14, 2010 4:03 am
by meet_deb85
meet_deb85 wrote:meet_deb85 wrote:chulett wrote:Please answer the second question. ...
select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305
can someone tell me how to get date of creation of userid's..??
Is it a bug or is there some rules for conversion,please tell me..??
Posted: Wed Jul 14, 2010 5:59 am
by chulett
If someone knows, they would post. Be a little more patient.
I, for example, have no clue and no direct access to do any investigation on my own. Why run open a case with your official support provider and ask them?
Posted: Wed Jul 14, 2010 8:25 am
by priyadarshikunal
This seems like unix timestamp to me, have you tried adding that number of milli seconds to 01-01-1970? 12,65,16,54,66,361 seems to be 03-02-2010 02:51:06.361