DSXchange

You have to count all fields, not just the key columns. There is a single byte delimiter between each field. Count those too. That is the figure to present to HFC - it does the rest. ... Hi Ray, Can u plz confirm/correct the following: Char - 1 Byte Integer - 4 Bytes SmallInt - 2 Bytes Date - ? Dec...

That is output from the HASH.HELP.DETAIL command or something similar. The record length is not calculated from the field sizes; it is actually measured from the data stored in the file. What you ... Hi Ray, Please trhow some light on relation between the data stored and the bytes, for a particular...

Hi, I am trying to use ANALYZE.FILE D_HashTest But I am getting the following error: Illegal option found on command line: D_HashTest Please note that D_HashTest is a dynamic hased file. Plz suggest. Thx Another Query: Can someone please explain how the number of bytes calculated from the field len...

Hi,

I am trying to use ANALYZE.FILE D_HashTest

But I am getting the following error:
Illegal option found on command line: D_HashTest

Please note that D_HashTest is a dynamic hased file.

Plz suggest.
Thx

Hi Friends, I am in trouble again! In my job, I am appending the incoming data to a same target seq file. The Seq File Stage has 1 input streams which is appending the data to the same seq file. This seq file satge is a part of the shared container and my job uses 3 instances of that shared containe...

Hi, My Job is giving the below error: DataStage Job 178 Phantom 2772 Program "DSD.StageRun": Line 617, Nonnumeric data when numeric required. Zero used. I read in the prev posts and chechked in the JOB.1638052153.DT.1419972357.TRANS1 file, but to my wonder the file has just 610 lines and a...

Hi Friends, My Job uses a Lik Partitioner, partitioning into 4 liks and each llink goes into a sort stage and the they are collected in a Link Collector. int the job Monitior I get %CP as higlhlighted in the imgae. I am running it on a Siblge Processor System, so with respect to this, plz interpret ...

Hi Friends,

Is their any way for Bulk Loading in DB2, hosted on Mainframes,
from Ascential DS Server Edition 7.5.1 A version?

I read in a post on this forum, that DB2 Bulk Load utility does not supoort DB2 on Mainframes.

Thx

Thanks Ray & ArndW!

Any comments on this..

Also this 'Kb' 0 Kilo Bits or Kilo Bytes?
(Acco to me Kb = Kile Bits and KB = Kile Bytes.)
What do u say?

Thx

This is a tab-separated report obtained by enabling stage tracing from the Job Run Options dialog when issuing a job run request and checking the Statistics check box. Copy it from there and paste ... Well Ray, this is been copy and psted from the logs itself. I am sorry I can't allign them here.. ...

ArndW wrote:Where are these statistics coming from? Without a frame of reference it is impossible to do anything with these stats. What do you want to get out of them? ...

This is the perf statistics for a Transformer Stage.

Hi, I have enabled Row -Buffering, inter-process, in my jobs. In the Job prperties (Performance tab) I am unable to set Buffer Siez > 1024 Kb. If I type , say 4096, it changes back to 1024 as I tab out of it. Anyways, I am using a Job Parameter also to set the IPC buffer size at individual IPCs. Whi...

Hi plz help me interpreting this stats. The Inter Process buffering was enabled. It was run on a single processor system. Trans_FSCM_2_EPM_LN: Name Percent Count Minimum Average Collect_And_Sort.SortedData_To_Trans 92 5000 1 3174 R_JrnlSync_Hash.Max_JrnlSync_lkp 0 5000 2 3 R_MaxJrnlLines_Hash.Read_P...

Hi Friends, I read in a document that the 'Hashed Files are commonly used to provide a reference table based on a single key'. So, with ref to aboce stmt, plz comment on thw case where I have more than one key and need a reference lookup against the composite key. Thx One more Q. I cant find where ...

Hi Friends,

I read in a document that the 'Hashed Files are commonly used to provide a reference table based on a single key'.
So, with ref to aboce stmt, plz comment on thw case where I have more than one key and need a reference lookup against the composite key.

Thx