DB2 Error

[rajivblr@gmail.com]

Hi All,

Could any one tell me if you have come across this error?

java.sql.SQLExc eption: [informatica][DB2 JDBC Driver]Resource Limits

Reached( ALLOCATE MEMORY FOR NEW SQLSTT FAILED ). Diagnostic

Info: FUNCTION ID = 0049 , PROBE POINT = 0400 , TRACE POINT =

0030 , SUBCODE1 = FFFFFFFF8B0F000 0, SUBCODE2 =

0000000078A68A9 8, SUBCODE3 = 000000000000000 0, ERROR MSG =

Parser: Memory allocation error.

java.lang.NullP ointerException


If so , what could is the reason and how to get through this? I could
find much help googling

Regards,
Pattabhi RAman

[Phil Sherman]

Re: DB2 Error

I haven't seen this but it looks like a program that doesn't properly
close something, probably statements. As the program runs, more and more
resources are tied up by the "finished" stuff until there's nothing left
for the next request.

Phil Sherman


rajivblr@gmail. com wrote:

Hi All,
>
Could any one tell me if you have come across this error?
>
java.sql.SQLExc eption: [informatica][DB2 JDBC Driver]Resource Limits
>
Reached( ALLOCATE MEMORY FOR NEW SQLSTT FAILED ). Diagnostic
>
Info: FUNCTION ID = 0049 , PROBE POINT = 0400 , TRACE POINT =
>
0030 , SUBCODE1 = FFFFFFFF8B0F000 0, SUBCODE2 =
>
0000000078A68A9 8, SUBCODE3 = 000000000000000 0, ERROR MSG =
>
Parser: Memory allocation error.
>
java.lang.NullP ointerException
>
>
If so , what could is the reason and how to get through this? I could
find much help googling
>
Regards,
Pattabhi RAman
>

[rajivblr@gmail.com]

Re: DB2 Error

Phil,

Thanks for the information, but i have a scenario here, when i try to
connect to the instance out side the application from the command
prompt it works fine, it only when i try to conenct through the
application ( when i specify db2 as the database for creating domain
tables in the database using Powercenter) ...

Regard,
Pattabhi Raman