Error while executing runstats cmd

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dwblore
Charter Member
Charter Member
Posts: 40
Joined: Tue Mar 28, 2006 12:02 am

Error while executing runstats cmd

Post by dwblore »

Hello

I have successfully excuted cmds related to the computation of statistics in the Oracle OCI stage (Datastage Server Edition) however while trying the same in the parallel edition's db2 stage I'm getting the following error...

Tgt_Stg_Na_Gif_Event_Hist_Vin_Tab,0: Warning: jGIF_STG_GIF_EVENT_HIST_STG_VIN.Tgt_Stg_Na_Gif_Event_Hist_Vin_Tab: SQLExecDirect: Error executing statement 'RUNSTATS ON TABLE etl.STG_NA_GIF_EVENT_HIST_VIN WITH DISTRIBUTION ON ALL COLUMNS AND SAMPLED DETAILED INDEXES ALL ALLOW WRITE ACCESS'.

please note that this is after checking the
"treat errors as non fatal" option - otherwise this error exhibits itself as a fatal error...

any ideas?
Post Reply