DSXchange

How are you checking? You can't use "the same user" and check from the command line, you need to check from a job's environment. Take any job and add an "ExecSH" before-job call to "ulimit -a" and s ... Actually the abort we are encountering is in 'PROD' environment. C...

That's controlled by the operating system via the ulimit function. Have a chat with your SysAdmin and see if they're willing to bump that up for your user. ... Thanks for a quick response. But, the current ulimit function is set to unlimited. I beleive this error is more specific to Datastage and i...

Is there an Environment variable we can set at the Project level, to increase the 'heap size limit'. Please find the attached error message below: The current soft limit on the data segment (heap) size (1610612736) is less than the hard limit (2147483647), consider increasing the heap size limit Any...

chulett wrote: ps. Didn't really answer my tangential question as to exactly what you're doing in this script, but that's ok.

dsjob -file $XCONFIG_DIR/dsjobfile.txt $DOMAIN_PORT $ETL_PORT -run -jobstatus -param $DS_GLOBAL_PARAM $DS_PROJECT $XDS_NAME >> $LOG_FILE

I'm curious, what 'project setting values' are you fetching in your script and how are you using them? The script actually grabs all the values at the Project level and tries to execute the 'DSJob command'. The default value for 'Warning counts' is 50, I beleive unless and untill one specifies it at...

In order to run our application we have a shell script that actually grabs the project setting values set at the project level and executes the 'dsjob' command. The Problem is I donot see an Environment variable (at the Admin/Proj Level) that actually overwrites the default 'Warning Limit' count val...

Is there a way we can populate 'Parameter sets' with a dynamical date value. Let's say I have two environments and each every environment has its own value file. I was wondering if there is a way we can dynamically assign 'current system timestamp' value to the parameter set value files. I know that...

Hi,

I was wondering to know when we use 'Write method' as Load, does it create 'Table level locks' on the table during the process of loading. If somebody could shed more light on this, it would be great.

Thanks

Hi I was trying to assign a 'user defined environment variable'[global] as the derivation for populating one of the fields in Transformer. The job would not even compile. Here is the error message: 'Invalid local variable declaration'. 1.I was wondering if there is a way we can assign a 'user define...

Actually i am having the same issue when i am trying to browse for the table names based upon the owner. I could individually enter the <schema-name>.<tablename> and can retreive and import meta data, where is if i try to import them based upon owner. By the way the version 8.0.1 and Oracle 10g Erro...

Hi I was trying to execute a shell script whose primary purpose is to truncate tables, drop indexes etc. I defined Before stage subroutine: 'ExecSH' Input Value <shell-script-name.sh> -options the script which i am pointing to actually is under oracle/bin directory. 1. I was wondering where would ac...

Thanks chulett.

Job is like this: SEQ --> Transform --> Oracle Enterprise stage Stage options: Write method: Load with 'Rebuild Index' option turned on. I just have a record in the file, which gets inserted into the database but 'DataStage Director' strangely reports that its a fatal error but sucessfully runs to c...

NLS is enabled, and default map selected for a project, using the Administrator client NLS button once that project has been selected. ... Ray, surprisingly for the none of the project's in Administrator 'NLS' tab is neither highlighted or enabled. So how would DS do the charecter mapping between D...

Why not try to get them to load without aborting? Perhaps if you posted the errors generated, we could help make that happen. ... The error is: sqlcode is: -12899 esql complaint: ORA-12899: value too large for column "<schema_name>"."<table_name"."<column_name>" (actua...