Search found 20 matches

by anudako
Wed Nov 03, 2010 5:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ''Dropping component'' warning in LK stage-no same colums
Replies: 4
Views: 2315

[quote="ArndW"]In the log file you should have an entry starting with "...Schemas.." where you can check the actual runtime schema for the input link which I still suspect contains your reference column name. ...[/quote] where i can see the log file? i don't have much experience ...
by anudako
Wed Nov 03, 2010 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ''Dropping component'' warning in LK stage-no same colums
Replies: 4
Views: 2315

[quote="ArndW"]Try setting your environment variable $OSH_PRINT_SCHEMAS to "true" and check both input links to your lookup stage for "Flag1" - my first guess is that you have RCP enabled and are inadvertantly passi ...[/quote] I set my environment variable $OSH_PRINT_S...
by anudako
Wed Nov 03, 2010 2:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ''Dropping component'' warning in LK stage-no same colums
Replies: 4
Views: 2315

''Dropping component'' warning in LK stage-no same colums

Hi, I have the ''Dropping component 'Flag1' because of a prior component with the same name" warning for my lookup stage. i saw in many of the post as This warning is because of the same columns (except key columns) in both of the inputs of the Lookup stage and have to rename one of the inout f...
by anudako
Wed Nov 03, 2010 12:36 am
Forum: General
Topic: not able to login datastage and not to start WAS
Replies: 6
Views: 9489

yes...i have missed this point....i reset to old password what i used on installing IIS. Now able to restart WAS and login to Datastage...

Thanks a lot for all who helped me on this.....
by anudako
Tue Nov 02, 2010 11:00 pm
Forum: General
Topic: not able to login datastage and not to start WAS
Replies: 6
Views: 9489

My xmeta reposity password was expired. I change the password now and able to login to xmeta using xmeta user and new password . Still am not able to restart WAS.Below is the log in systemout . Could anyone help me? ************ Start Display Current Environment ************ WebSphere Platform 6.0 [...
by anudako
Fri Oct 29, 2010 4:05 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

[quote="ArndW"]Could you give us a hint - does the command give a syntax error? I would suggest opening up a new thread on the topic, as this one is not only over a year old but already marked as "resolved". ...[/quote] Hi ArndW...this has been already posted as new thread as i s...
by anudako
Fri Oct 29, 2010 3:59 am
Forum: General
Topic: not able to login datastage and not to start WAS
Replies: 6
Views: 9489

not able to login datastage and not to start WAS

hi, I can not log in to datastage designer,administrator and director today morning and not able to start the application server. I saw the same issue in the below post. http://www.dsxchange.com/viewtopic.php?t=128270&highlight=start+server+stop+windows Saw the reason as xmeta is disabled and th...
by anudako
Fri Oct 29, 2010 3:39 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

[quote="ArndW"]What is wrong with trying my suggestion in my last post? ...[/quote]
''alter login xmeta enable'' also not working
by anudako
Fri Oct 29, 2010 3:38 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

unlock xmeta-db2

[quote="ArndW"]What is wrong with trying my suggestion in my last post? ...[/quote] thanks ArndW for the reply.. it was given- can use "alter user xmeta account unlock;" if it is oracle repository. Mine is Db2 and this command is not working. We don't have a DBA and DB2 is instal...
by anudako
Fri Oct 29, 2010 3:36 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

unlock xmeta-db2

[quote="ArndW"]What is wrong with trying my suggestion in my last post? ...[/quote] thanks ArndW for the reply.. it was given- can use "alter user xmeta account unlock;" if it is oracle repository. Mine is Db2 and this command is not working. We don't have a DBA and DB2 is instal...
by anudako
Fri Oct 29, 2010 12:40 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

same issue db2 repository-but not able start WAS

hi,

i am facing the same issue.can not log in to datastage designer,administrator and director and not able to start the application server.
Saw the reason as xmeta is disables and mine is db2 repository.
Could yiou please help me on enabling my db2 xmeta?
by anudako
Fri Oct 29, 2010 12:37 am
Forum: General
Topic: Can't access datastage designer but still running
Replies: 17
Views: 17398

same issue db2 repository-but not able start WAS

hi,

i am facing the same issue.can not log in to datastage designer,administrator and director and not able to start the application server.
Saw the reason as xmeta is disables and mine is db2 repository.
Could yiou please help me on enabling my db2 xmeta?
by anudako
Thu Oct 14, 2010 12:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: iteration checking in datastage
Replies: 4
Views: 3764

Sorry i posted wrongly,it is parallel job. It can go to any number of sublevels.And i have to check to what group is top in its hierarchy and have to take it as group_id. in my eample, for product_id= 1,the immediate group_id is 20, whose parent is 30 and on iteration checking 30 id again child of 7...
by anudako
Wed Oct 13, 2010 10:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: iteration checking in datastage
Replies: 4
Views: 3764

iteration checking in datastage

Hi, In my Source system, there are 3 tables to retrive a product details. I found difficulty in mapping the group and subgroup of each product as there is some iteration in hierarchy exists for each group. The main table gives me the product_id,group_id and product details. The second table gives re...
by anudako
Tue Oct 05, 2010 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: key from timestamp in YYYYMMDDHHMM format
Replies: 1
Views: 1951

key from timestamp in YYYYMMDDHHMM format

I have a timestamp field and want to create a unique key in the format, YYYYMMDDHHMM from this timestamp. I tried in the below method in transformer Is float(year(TS) : month(TS) : day(TS) : hour(TS) : min(TS)) But the problem is if the value of any of the concatenating fields is zero, it is not tak...