Prev: Sinking Feeling
Next: Any body could help me out on DB2 stored procedure on Z/OS
From: Rahul Babbar on 7 Jan 2008 01:30
Hi,

I tried to generate the query plan for a query using a tool called
Aqua Data Studio.
It showed the explain plan and showed that a particular scan on a
particular table was taking a long time.
It showed the tablename correctly but showed the column name as
"com.ibm.db2.jcc.b.dc(a)1d5b3a"

Can somebody explain what this column name could refer to...like some
syscat/sysibm tables where this column name will refer to some actual
column.

I tried to run the query plan from command Editor but it seems Command
Editor just generates some errors and closes.

Please help as to how i could find the column alised
"com.ibm.db2.jcc.b.dc(a)1d5b3a".

Any help will be greately appreciated.

Thanks

Rahul
From: jabernet on 8 Jan 2008 14:07
I'd suspect this is an error message or some memory address (looks
like output of a java Object.toString() method) in the DB2 java
driver.

I don't think you will be able to make much sense of this, though.

Regards,
Janick


On 7 Jan., 07:30, Rahul Babbar <rahul.babb...(a)gmail.com> wrote:
> Hi,
>
> I tried to generate the query plan for a query using a tool called
> Aqua Data Studio.
> It showed the explain plan and showed that a particular scan on a
> particular table was taking a long time.
> It showed the tablename correctly but showed the column name as
> "com.ibm.db2.jcc.b.dc(a)1d5b3a"
>
> Can somebody explain what this column name could refer to...like some
> syscat/sysibm tables where this column name will refer to some actual
> column.
>
> I tried to run the query plan from command Editor but it seems Command
> Editor just generates some errors and closes.
>
> Please help as to how i could find the column alised
> "com.ibm.db2.jcc.b.dc(a)1d5b3a".
>
> Any help will be greately appreciated.
>
> Thanks
>
> Rahul

 | 
Pages: 1
Prev: Sinking Feeling
Next: Any body could help me out on DB2 stored procedure on Z/OS