Topic
  • 2 replies
  • Latest Post - ‏2012-12-06T13:53:54Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic "default" schema not being used in DS 3.1.1

‏2012-12-04T19:45:16Z |
Hi, I connect to my Z/os DB2 system with my personal RACFID but I set my "default schema" on connection to our DBA schema. I'm trying to pull values out of the statement cache into DSN_STATEMENT_CACHE_TABLE but it fails because it says table myracfid.DSN_STATEMENT_CACHE_TABLE doesn't exist. Why isn't it using default_schema.DSN_STATEMENT_CACHE_TABLE?

Thanks,

Art.
Updated on 2012-12-06T13:53:54Z at 2012-12-06T13:53:54Z by SystemAdmin
  • YuanFeng
    YuanFeng
    78 Posts

    Re: "default" schema not being used in DS 3.1.1

    ‏2012-12-06T02:31:43Z  
    Hi,
    Are you using the default schema at create a connection?
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: "default" schema not being used in DS 3.1.1

    ‏2012-12-06T13:53:54Z  
    • YuanFeng
    • ‏2012-12-06T02:31:43Z
    Hi,
    Are you using the default schema at create a connection?
    Yes, however instead of looking for <default schema>.DSN_STATEMENT_CACHE it's looking for <user name>.DSN_STATEMENT_CACHE and of course can't find it.