ODBC erro

[cpu533]

Hi there,
We are using Informix 7.31UD3 on AIX machine, the ODBC driver version is 2.91TC1. We try to run some query through ODBC, but some times it failed, some times it works regardless the size of result.
We capture the query and run it in DBACCESS, no errors.

Error Description:
(8007000E): [Informix][Informix ODBC Driver][Informix]Memory allocation failed during query processing.
Source = Microsoft OLE DB Provider for ODBC Drivers
NativeError = -208
SQLState = S1001
(7): Source = CTariffBaseBODT::FindTariff
(7): Source = CTariffBase::FindTariff
(7): Source = WCTRB::lGetTrbRes

Any advice?

Thanks,
Denny

 

[vpshriyan]

Is the finderr -208 explanation helps?

 

[cpu533]

thanks for reply, If u using finderr -208, it will tell you it caused by unable to allocate memory for this query. But we try the same query on the informix server using dbaccess, no errors.

Any suggestion.

Thanks,
Denny

 

[thorkild]

Hello
Theres a difference that you must remember in this case.
Then you uses dbaccess you run locally on the server side which means that you uses setting from the login instance for temp space usage.
Then you run via ODBC you uses the Informix server settings.
The problem here could be that you uses different setting for the temp spaces when you run locally in contrast to when you run via ODBC.
If you haven't allocated a disk space/file system solely for Informix temporary files, Informix compiets with the rest of the unix system about temporary spaces. This error indicats that your temporary spaces fills up on the server side. As far as I know sorts allways runs on the server side.
My suggestion to you is that you should look into your setting for temporary diskspaces/tablespaces allocated to the Informix server on your server side. A good places to start reading is Informix Performace Guide for Informix Dymanic server. Exspecily the page on DBSPACETEMP and PSORT_DBTEMP.
Good luck
Thorkild