DSXchange

prasson_ibm

There could be possibly workaroud, if your source is sequential file then you can generate sequence nunumber and then in transformer constraint give condition like seqno> 4

prasson_ibm

I remember i have converted text to hex using basic trasformer stage,so there must be some conversion function to convert Hex to text.

Code: Select all

OCONV(to_tsfm_hex.ntfEventpayload,"MX0C")

This may help you.

prasson_ibm

Are you passing the invocation id to job in sequence?

prasson_ibm

ArndW wrote: as I usually do, use the Before-Job and After-Job subroutine calls to perform this logging directly using BASIC-Code or to use the BASIC-Code to start up a background PX job which will do the logging.

Thats interesting,can you please share a basic code to trigger a job.

prasson_ibm

You can design a job with multiple instance which will insert the job log.

Design a sequence and call this job with some instance before your main job starts and call it again with another instance after main job finishes.

prasson_ibm

thirupathireddy.gankidi wrote:Fatal: TJClient::initialize: unable to create Java Virtual Machine; classpath = /opt/IBM/InformationServer/Server/DSEngine/java/lib/wsclient.jar

Add

Code: Select all

/opt/IBM/InformationServer/Server/DSEngine/java/lib/tr4j.jar

to your CLASSPATH and restart the engine.

prasson_ibm

Ok. Can you please tell me your .profile settings or you make sure below settings are there in .profile. 1.Add java client path to the path variable in .profile of dsadm user. 2.Add Datastage java classpath to .profile 3.Compile your code using javac command.It will generate .class file. 4.Use that ...

prasson_ibm

Hi, What is the setting of your .profile for JVM? If you are adding add DATASTAGE_JRE and DATASTAGE_JVM in the project (DataStage Administrator) level and job level or .profile:- There is no need to add JRE/JVM variables to the .profile or DataStage administrator. As per new IIS 8.7 the DataStage kn...

prasson_ibm

Hi,

I am working with DBA on this and will update you the result.

prasson_ibm

Hi Chullet,
You are right its working in SP stage but i will also try to execute it in After SQL of the ODBC stage.
I am making this topic as resolved.

prasson_ibm

Hi,
How can you make sure that it is using bulk load method? Which stage are you using to perform bulk insert?

prasson_ibm

If the key source is a flat file, specify how keys are generated: ■To generate keys in sequence from the highest value that was last used, set the Generate Key from Last Highest Value property to Yes. Any gaps in the key range are ignored. ■To specify a value to initialize the key source, add the Fi...

prasson_ibm

What blocksize you have selected?

prasson_ibm

Hi Chullet,

Thanks I will test with stored proc stage and then post the result.

prasson_ibm

Hi,

Can not i call it in stored procedure stage.

DSXchange

Search found 531 matches

Re: Unable to create Java Virtual Machine claspath