Datastage Training Online For low Cost

Ready to teach Datastage online 6 AM to 7:30 AM IST for low cost @3000 Rs per candidate.
 Reach out to below details.

Ramakrishna.
 krishnan459@hotmail.com
 Mobile:+91-9542186361

Datastage Certification 8.5 Dumps

Java Transformer Stage Usage in DataStage

Java Transformer Stage

DataStage Director receives errors and aborts when trying to browse folders.

Problem(Abstract)

In DataStage Director, the following errors occur when try to view folders in a project:

Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project (The connection is broken (81002))

Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project (The connection is broken (81002))

Cause

The errors were received because the Logging Agent was not running.

Diagnosing the problem

1. Check permission's on the project. Verify the user has RWX permission's on the files in the project.
2. Verify the Agents, Logging Agent and ASB Agent, are running:
   
   • On Unix/Linux execute the following:
     
     ps -ef | grep java | grep Agent
     
     If the Agents are not running they need to be started. When the Agents are running you would see entries similar to the following:
     
     $ ps -ef | grep java | grep Agent
     
     root 295106 1 0 Feb 03 - 9:09 ./../apps/jre/bin/java -Djava.security.auth.login.config=./../conf/auth.conf -Dcom.ibm.CORBA.ConfigURL=file:./../conf/sas.client.props -Djava.util.logging.manager=com.ibm.ws.bootstrap.WsLogManager -Djava.util.logging.configureByServer=true -classpath ./../conf:./../lib/java/ACS_client.jar:./../lib/java/ACS_common.jar:./../lib/java/ASB_utils.jar:./../lib/java/ASB_util_client.jar:./../lib/java/WASClient.jar com.ascential.acs.logging.agent.LoggingAgentSocketImpl
     
     root 413844 1 0 Feb 03 - 76:25 /opt/IBM/InformationServer/ASBNode/bin/RunAgent -Xbootclasspath/a:conf -Djava.ext.dirs=apps/jre/lib/ext:lib/java -Djava.class.path=conf -Djava.security.auth.login.config=/opt/IBM/InformationServer/ASBNode/conf/auth.conf -Dcom.ibm.CORBA.ConfigURL=file:/opt/IBM/InformationServer/ASBNode/conf/sas.client.props -Djava.util.logging.manager=com.ibm.ws.bootstrap.WsLogManager -Djava.util.logging.configureByServer=true -class com/ascential/asb/agent/impl/AgentImpl
     
   • On Windows go to Control Panel > Administrative Tools > Services and verify the ASB Agent and Logging Agent services are started.

Resolving the problem

To start the Agents:

• On Unix/Linux run the following command as root to start the ASB Agent and the Logging Agent.
  
  /opt/IBM/InformationServer/ASBNode/bin/NodeAgents.sh start
  
  The path shown in this command assumes that the product is installed in the default location. Your path will vary if you installed IBM Information Server in a different location. Then verify the Agents are now running (see step 3 above). If the Agents did not start successfully you can check the directory ../u2/IS810/IBM/InformationServer/ASBNode for the following files which may have additional information:
  
  asbagent_startup.err
  asbagent_startup.out
  logging-agent.err
  logging-agent.out
  
• On Windows go to Control Panel > Administrative Tools > Services and start the ASB Agent and Logging Agent.

How to use ms excel file in datastage?

Firstly the first row in excel file should have column names. After you prepared your excel file with the data you want to be loaded in to the table, Convert the excel file to CSV format. Then using WINSCP tool i.e SFTP file transfer you can transfer the CSV file from local system to the server.

Secondly after transferring you can access the CSV file in datastage by using sequential file.Open the sequential file and map or locate the CSV file.

Finally you can compile and run the job.

Looking to improve your essay writing skills

Here are some tips for writing with this type of organization:

1. Make sure you distinguish clearly between cause and effect. It’s not uncommon to confuse the two, especially once you’re dealing with a whole lot of information on the table.
2. Make sure you have a valid cause and effect relationship. Two things can merely follow each other, such as day and night. One doesn’t cause another — be vigilant about ensuring that when you’re writing this type of essay.
3. Make sure your cause is sufficient to create the effect. Remember that a cause can be merely contributory, making it insufficient when presented as a cause all on its own. A cause can also be unnecessary, meaning other things can lead to the same result.
4. Use either a chronological or reverse-chronological order. Those two are the most natural for conveying a cause and effect relationship. Sticking with either of the two is usually enough — no need to get fancy.
5. Be careful not to overstate your case. Many cause and effect relationships cannot be proven to be 100% accurate. In those cases, don’t word your language in absolutes. Use qualifiers to set more appropriate parameters.

Shell Scripting Basics