Search found 284 matches

by manuel.gomez
Wed Feb 29, 2012 10:24 am
Forum: General
Topic: migrating to Datastage 8.5 from Datastage 7.5
Replies: 9
Views: 7946

The upgrade is fairly straightforward, and jobs and sequences will be upgraded as part of it. Details about how to upgrade from version 7.5 can be found in the Installation and Upgrade manual for Information Server, which you have with the version 8.5 software. It's also available from the Informat...
by manuel.gomez
Thu Nov 17, 2011 5:09 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Column analysis fails
Replies: 5
Views: 8993

Column analysis fails

Hello there, I am currently having problems that I just can label as very strange. Let me go into details. Run column analysis is failing. Error message returned is as it follows: Message: pxbridge(0): ODBC function "SQLConnect" reported: SQLSTATE = IM002: Native Error Code = 0: Msg = [Dat...
by manuel.gomez
Thu Aug 04, 2011 3:44 am
Forum: General
Topic: Get last modification date (and other data) for any job
Replies: 4
Views: 3842

I was typing LOCALUV instead of localuv Now I have two problems: Stage Universe not executing the query when pressing View Data (but query is working in command line) SELECT INSTANCE, MODIFIER, MAX(DTM) AS MOST_RECENT_MOD FROM UNNEST DS_AUDIT ON MODS GROUP BY INSTANCE, MODIFIER; And what's worse, I ...
by manuel.gomez
Thu Aug 04, 2011 2:16 am
Forum: General
Topic: Get last modification date (and other data) for any job
Replies: 4
Views: 3842

Ray, I followed your instructions, but I am having a problem when trying to read universe table: it is asking me to specify an account or directory path As far as I am accessing a universe table (and not a hashed file trhough this stage) I dont know what to indicate in here Can you please advice? Th...
by manuel.gomez
Mon Aug 01, 2011 4:12 am
Forum: General
Topic: Get last modification date (and other data) for any job
Replies: 4
Views: 3842

Get last modification date (and other data) for any job

Hello all, In order to check job version consistency between, we would like to extract, from repository, a list with all jobs and their last modification date, created by, ... data I can figure three ways to do this: - Check DS_AUDIT job, but I am not very used to work with Universe tables. Do I nee...
by manuel.gomez
Thu Jul 14, 2011 3:27 am
Forum: General
Topic: Cant access VSAM files via Classic Federation
Replies: 1
Views: 1892

Cant access VSAM files via Classic Federation

I do have Information Server 8.1 and Classic Federation installed in AIX, but when trying to use External source stage with Classic federation, I am getting the following error: ##W IIS-DSEE-TOIX-00175 09:17:35(000) <RGPGM301,0> Source subproc: Could not load program caccfxt: Dependent module cacsql...
by manuel.gomez
Wed Jun 15, 2011 6:02 am
Forum: General
Topic: Developer users to change their passwords
Replies: 2
Views: 2236

ray.wurlod wrote:Have you tried a non-administrator user logging in to the Web Console and editing their own password in their user record?
As soon as I wrote this post I figured just to try this, and it worked

Dummy question, sorry about that
by manuel.gomez
Wed Jun 15, 2011 2:51 am
Forum: General
Topic: Developer users to change their passwords
Replies: 2
Views: 2236

Developer users to change their passwords

I just created some developer users, and I defined passwords for them in the IIS console, as usual I would like to know if there is any way to get these users to change their passwords without, obviously, getting into the IIS console with the wasadmin user. At the moment, the only alternative I have...
by manuel.gomez
Wed Jun 15, 2011 2:36 am
Forum: General
Topic: Hiding password when executing istool command
Replies: 2
Views: 2281

I figured myself to do it by this

Code: Select all

./istool import -replace -domain xxxxxx -u dsadm -p  `cat /opt/pagina1/pases/20110608_pruebas/password.dat`  -ar /opt/pagina1/pases/20110608_pruebas/generar_logs.isx -ds ' "user/proyect" '
Marking as resolved
by manuel.gomez
Thu Jun 09, 2011 5:21 am
Forum: General
Topic: Hiding password when executing istool command
Replies: 2
Views: 2281

Hiding password when executing istool command

Hello guys, I am generating scripts to import jobs into production environment, and I would like to have password hidden in a file only accesible by dsadm user I read great post from asorrel, where he quoted this possible solution: -u dsadm -p 8 8</dir/dir/pw_file But I tried this and I could not ge...
by manuel.gomez
Tue May 17, 2011 8:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem reading binary separators in cobol char field
Replies: 3
Views: 4172

I would not use "fun" as the more appropiate word, hahaha I dont mean to be rude at all (thanks for bothering answer me), apologizes if my English sounds so, but "philosophy" questions as you are raising are out of the scope of this topic. It is true what you are saying and very ...
by manuel.gomez
Tue May 17, 2011 5:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem reading binary separators in cobol char field
Replies: 3
Views: 4172

Re: Problem reading binary separators in cobol char field

manuel.gomez wrote: I just made a final test: read with FTP and write to a sequential file, coded as EBCDIC. Downloaded this text file to local computer, opened with UltraEdit and checked hexadecimal character for this separator, code was '1A'
I was wrong here

The hex codes for these separators are: FB and FE
by manuel.gomez
Tue May 17, 2011 3:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem reading binary separators in cobol char field
Replies: 3
Views: 4172

Problem reading binary separators in cobol char field

Hello guys, Let me introduce my scenario and the problem I am having. I am reading a host file, using FTP Enteprise stage. At the moment I a just performing a test: reading a file with FTP enteprise, pass it thorugh other FTP enterprise to write to same host. Result should be an exact copy from the ...
by manuel.gomez
Tue May 17, 2011 3:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem reading binary separators in cobol char field
Replies: 0
Views: 1591

Problem reading binary separators in cobol char field

Hello guys, Let me introduce my scenario and the problem I am having. I am reading a host file, using FTP Enteprise stage. At the moment I a just performing a test: reading a file with FTP enteprise, pass it thorugh other FTP enterprise to write to same host. Result should be an exact copy from the ...
by manuel.gomez
Tue May 17, 2011 3:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem reading binary separators in cobol char field
Replies: 0
Views: 1429

Problem reading binary separators in cobol char field

Hello guys, Let me introduce my scenario and the problem I am having. I am reading a host file, using FTP Enteprise stage. At the moment I a just performing a test: reading a file with FTP enteprise, pass it thorugh other FTP enterprise to write to same host. Result should be an exact copy from the ...