Troubleshooting
Problem
Running many parallel queries via procedure and SQL nodes in a jobstream accessing Sybase IQ database via the ODBC driver, it fails intermittently
Symptom
DS-DBMS-E402: UDA driver reported the following:
UDA-SQL-0031 Unable to access the '<database name>' database.
UDA-SQL-0449 An error occurred when allocating memory during the 'attach' operation.
[iODBC][Driver Manager]Driver's SQLAllocEnv() failed
[PROGRESS - 03:10:59] SQL Node 7 '<table name>'; reported the following:
DS-DBMS-E306: UDA driver error connecting to '<database name>'.
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Manager","Platform":[{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.2","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
1037332
Was this topic helpful?
Document Information
Modified date:
13 January 2026
UID
swg21342548