DSXchange

Hi,

I am not able to connect SAP BW 4.2 server through Datastage 7.1. and getting following error when I pressed Monitor RFC.

Unable to read BW Load Pack log file connection "DATA-38" and Source "ASC-38"


Regards

Recently we have migrated SAP BW load pack 4.1 to 4.2. Load pack 4.2 generate log file very long. Its shows packet size sending to BW, The packet size multiple of 100000 rows Please let me know how I can avoid Packet size log file Below mentioned shows log file. Occurred: 8:14:48 AM On date: 1/2/200...

I want to know how I will get Jobs name, which is using routines. In a query routines name is CaseTimeBand.

I am not able to find out jobs name, which is using routines in following query.

SELECT dsrid,ds_routines.category,ds_jobs.name from ds_routines,ds_jobs where dsrid like 'cASEtIMEbAND' and ds_routines.jobtypeind = ds_jobs.jobtypeind


Regards
Vikas Gupta

How I will get monitoring sheet of all jobs, which is run at night. Like Job Name, Start time, End time etc.

Regards
Vikas Gupta

Hi,

How I will find out those jobs names, which are using given column name. Suppose column name is Satus then which jobs are using this column.


Regards

Vikas Gupta

How I will avoid warring massage in below bold letter, when I am updating records using DB2/UDB API Stage. I know that target database have no match id records. [IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02...

I got it.

Thanks to all.

Vikas Gupta

I know only that path using for hash file, outside project directory

Vikas Gupta

I used SETFILE as follows for count hash file but it gives error and hash file H_Cmd_HS file is strored in path /u05/PRODDSS/data3/srcfiles/cmd/hash >SETFILE /u05/PRODDSS/data3/srcfiles/cmd/hash H_Cmd_HS OVERWRITING *** Warning *** The DICT file pathname "/u05/PRODDSS/data3/srcfiles/cmd/D_hash&...

Sorry! I posted in Parallel extender.
Count number of records in hashed file, which is not stored under the Project directory. It is stored in local path

Is it any way to count hash file stored in local directory not in project directory.

I am using DB2Load Plugin for bulk data load into DataBase table. I am getting following error.

The filetype modifier "NOHEADER" was specified, but the nodegroup on
which the table is defined is not a single-node nodegroup.


Thanks
Vikas Gupta

enabled Pre_load file to memory in hash file and I updated Read cache and write cache to size 999MB

Then also I got following error

Error: add_to_heap() - Unable to allocate memory

I have sequential file, which have three records against one id with different values. Is it possible through datastage to convert three records into one record against id?