Search found 74 matches

by altruist
Tue Jan 14, 2014 8:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Configuration
Replies: 8
Views: 4795

I see only "lib" in oracle home directory.

Note: I am connecting to 10.2.0.4 - 32 bit Oracle Server on windows, through client on AIX 6.1 with 11.2.0.1 - 64 bit. We have tested the connected through AIX with sqlplus and it worked fine.
by altruist
Tue Jan 14, 2014 12:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Configuration
Replies: 8
Views: 4795

That is the entire error message in dialog box, it occurs when I try to import column definitions from Oracle - "Unable to initialize Plug-in" I have rectified minor mistakes and bounced the server, but still with the same error if [ -n "$DSHOME" ] && [ -d "$DSHOME&q...
by altruist
Tue Jan 14, 2014 6:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Configuration
Replies: 8
Views: 4795

Oracle Configuration

Hi All, I am trying to configure Datastage to connect to Oracle database by adding the below highlighted contents in dsenv file. But I am getting the error as "Unable to Initialize plug-in". I have bounced the server after modifying the dsenv, but it's still not working. if [ -n "$DSH...
by altruist
Wed Oct 09, 2013 3:45 am
Forum: General
Topic: Failed Installation : Lib Files
Replies: 1
Views: 671

Failed Installation : Lib Files

Hi All, I am trying to install IIS Suite application on AIX box. It gave an error as below Ensure the following libraries do not exist: /usr/lib/libicuio.a, /usr/lib/libicuuc.a, /usr/lib/libicui18n.a. These libraries may cause uvsh to not work properly. I manually removed these files by executing su...
by altruist
Tue Oct 08, 2013 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instance Surrogate Key Generator
Replies: 5
Views: 3730

Thanks a lot Vincet for the detailed explanation
by altruist
Mon Oct 07, 2013 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Instance Surrogate Key Generator
Replies: 5
Views: 3730

Multiple Instance Surrogate Key Generator

Hi,

Can I run multiple instance of jobs to generate surrogate key generator with SAME State File i.e. jobs to run simultaneously and generate common surrogate key
by altruist
Mon Aug 19, 2013 10:02 pm
Forum: General
Topic: Installing v9.1 and v8.1
Replies: 1
Views: 737

Installing v9.1 and v8.1

Hi,

We have one AIX box. Our plan is to install v8.1 and v9.1 on the same box for some tests. Is it possible to have both engines installed on the same box ?

Thanks & Regards
by altruist
Thu Aug 15, 2013 7:32 am
Forum: General
Topic: AIX Space requirements for v9.1
Replies: 5
Views: 1767

We are going to install all components of Infosphere Suite (including Information Analyzer, Quality Stage, fasttrack etc.). I am not aware of DataStage Operations Console, but we are planning to install all. The whole installation is for training purpose, so I am guessing at max we might have avg 30...
by altruist
Tue Aug 13, 2013 11:55 pm
Forum: General
Topic: AIX Space requirements for v9.1
Replies: 5
Views: 1767

Hi Ray, This is a training server, so at max I might have only 1-2 million records in all datasets combined. 1) Based on my understanding /opt directory should have atleast 15.6 GB based on the below mentioned requirements in the link that you have provided. This include both Installation and compon...
by altruist
Tue Aug 13, 2013 11:30 pm
Forum: General
Topic: AIX Space requirements for v9.1
Replies: 5
Views: 1767

I just came up with a document mentioning that we need to have /tmp and /var/tmp directories with high I/O. but didn't mention their sizes

Appreciate your help on this.
by altruist
Tue Aug 13, 2013 9:32 am
Forum: General
Topic: AIX Space requirements for v9.1
Replies: 5
Views: 1767

AIX Space requirements for v9.1

Hi, We are planning to install v9.1 on AIX box. I have the below structure on my AIX box /opt /var /usr /tmp /admin /proc /opt I went through the requirements document and it mentions that Installation of each component requires the below specified space Metadata Repository - 6.7 GB Services Tier - ...
by altruist
Sat Jul 27, 2013 8:56 am
Forum: General
Topic: Job Report Through Unix - Including File Paths
Replies: 3
Views: 1551

Hi Ray,

Can you please let me know where I can get the information to write the shell script. I basically want to search for any string pattern in the entire project.

Are there any UV tables where I can get ALL the information pertaining to job.
by altruist
Sat Jul 27, 2013 1:14 am
Forum: General
Topic: Job Report Through Unix - Including File Paths
Replies: 3
Views: 1551

Job Report Through Unix - Including File Paths

Hi,

I wanted to kick off a script, which can fetch me ALL the job details eg. Job Description, File Paths etc. similar to File Menu > Generate Report.

I have checked dsjob -report , but it doesn't fetch all the details as listed above.
by altruist
Fri Feb 10, 2012 7:31 am
Forum: General
Topic: Access Xmeta
Replies: 6
Views: 3533

Code: Select all

#!/bin/ksh

db2 << EOF > /home/db2inst1/log

connect to xmeta

select distinct tabschema || ','|| tabname from syscat.tables

EOF
This is part of test code [test.sh]. Where can I place this code in Windows Server and how can I call it ?
by altruist
Thu Feb 09, 2012 11:24 pm
Forum: General
Topic: Access Xmeta
Replies: 6
Views: 3533

Access Xmeta

Hi,

I want to query a xmeta table to get user info. Can you please let me know how to access xmeta.

I was able to do the same in Unix Server through Shell Script. But not sure how to access from Windows Server.

Thanks