Search found 284 matches
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- Wed Jun 15, 2011 6:02 am
- Forum: General
- Topic: Developer users to change their passwords
- Replies: 2
- Views: 2236
- 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...
- 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
Marking as resolved
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" '
- 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...
- 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
- 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
I was wrong heremanuel.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'
The hex codes for these separators are: FB and FE
- 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 ...
- 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 ...
- 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 ...