Datastage Engine Performance Tuning :UVCONFIG

Improve the performance of Datastage Engine.Tunable parameters in the UVCONFIG file :DK®

The UVCONFIG file contains several parameters that you can configure to improve performance and avoid troubleshooting.DK®

Change wasadmin password:Disable global security

Wasadmin password changing options or Open websphere without prompting the password : If you forgot the password for websphere console or not able to stop services tire due to wasadmin password change. then you can follow, below option to rest your password.DK®

Datastage Scenario Based Question/Answer : 3

Find the missing values from source data.

Datastage Scenario Based Question/Answer : 2

Datastage Scenario Based Question/Answer : 2

Without a key column,Pivoting the Output data in Required Format.

Error 6 initializing SQLPLUS Error in Unix/Linux

Error 6 initializing SQLPLUS Error in Unix/Linux :DK®

Error Description :DK®

Error 6 initializing SQL*Plus

Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Check Datastage Project for any corrupted files

How to verify if DataStage project has any corrupted files :DK®

If DataStage project or temp directory runs out of disk space, some of the buffered write requests might not get correctly completed and the project might ended up having corrupted hash files.DK®

Resources unavailable to create a Datastage Job

Resources un-available to create a DataStage parallel job:

DataStage is unable to create parallel jobs when system resources are limited.DK®