IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 7 replies
  • Latest Post - ‏2013-04-03T21:21:26Z by sumithar
sumithar
sumithar
30 Posts

Pinned topic packages a table is used in

‏2013-02-18T20:41:47Z |
In the Data Studio product if where would I look to find the packages that a table is used in? It'd approximately correspond to this query

select grantee, insertauth,selectauth,deleteauth,updateauth
from sysibm.systabauth where ttname = 'TABLE_NAME' and Tcreator = 'TCREATOR' and granteetype = 'P'
with UR
Updated on 2013-04-03T21:21:26Z at 2013-04-03T21:21:26Z by sumithar
  • CatherineWu
    CatherineWu
    11 Posts

    Re: packages a table is used in

    ‏2013-03-07T07:34:00Z  
    Hi,

    You can try this with Data Studio v3.2. In Administration Explore, click "table". Right click the table you want to search in OLE, click "impact analysis..." in context menu. Then you will see all impact objects and after you order by object type, you will see list of packages.
  • sumithar
    sumithar
    30 Posts

    Re: packages a table is used in

    ‏2013-03-28T20:21:06Z  
    Hi,

    You can try this with Data Studio v3.2. In Administration Explore, click "table". Right click the table you want to search in OLE, click "impact analysis..." in context menu. Then you will see all impact objects and after you order by object type, you will see list of packages.
    Catherine,
    I had tried this with the "both" option (impactor and dependent objects) but I didn't get the list of packages.
    Thanks!
  • YuanFeng
    YuanFeng
    78 Posts

    Re: packages a table is used in

    ‏2013-03-29T02:20:25Z  
    • sumithar
    • ‏2013-03-28T20:21:06Z
    Catherine,
    I had tried this with the "both" option (impactor and dependent objects) but I didn't get the list of packages.
    Thanks!
    Could you check the containe objects and Recursive objects as well with Both, see my attachment
  • sumithar
    sumithar
    30 Posts

    Re: packages a table is used in

    ‏2013-04-02T19:45:08Z  
    • YuanFeng
    • ‏2013-03-29T02:20:25Z
    Could you check the containe objects and Recursive objects as well with Both, see my attachment
    Hi Yuan Feng,
    This is what I did, right clicked on table name
    http://img706.imageshack.us/img706/2669/analyzeimpact.jpg
    When I do that I get a list of indexes and such like, still no packages.
    Thanks!
  • YuanFeng
    YuanFeng
    78 Posts

    Re: packages a table is used in

    ‏2013-04-03T06:40:27Z  
    • sumithar
    • ‏2013-04-02T19:45:08Z
    Hi Yuan Feng,
    This is what I did, right clicked on table name
    http://img706.imageshack.us/img706/2669/analyzeimpact.jpg
    When I do that I get a list of indexes and such like, still no packages.
    Thanks!
    Hi,
    I tried on my local with data studio 3.2. I can find package is list,please reference my attachement.

    Are you using Data Studio 3.2?
  • sumithar
    sumithar
    30 Posts

    Re: packages a table is used in

    ‏2013-04-03T21:20:59Z  
    • YuanFeng
    • ‏2013-04-03T06:40:27Z
    Hi,
    I tried on my local with data studio 3.2. I can find package is list,please reference my attachement.

    Are you using Data Studio 3.2?
    Yeah- even for me it works fine when it's a local database but not when it's a remote one.
  • sumithar
    sumithar
    30 Posts

    Re: packages a table is used in

    ‏2013-04-03T21:21:26Z  
    • sumithar
    • ‏2013-04-03T21:20:59Z
    Yeah- even for me it works fine when it's a local database but not when it's a remote one.
    Oops- yes, I am using 3.2