Column analysis getting aborted with unclear error msg

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Column analysis getting aborted with unclear error msg

Post by BradMiller »

When I am running column analysis against a file its getting aborted with a typical error message "pxbridge(4): [IIS-CONN-ODBC-000013] ODBC Info: SQLSTATE = HY000: Native Error Code = -289: Msg = [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]Unknown error: SQLCODE -289".

When I searched at the SQLCODE -289 error it says I have to increase the pages by running this command DB2 "ALTER TABLESPACE tablespace_name EXTEND (ALL 100000)".

I am just running 20,000 records and record length is small too so the default Info Analyzer installation with IADB database would not be created with sufficent space to store the statistics & handle it.

Or is it a misleading error message with actual error being something else.
Post Reply