Skip to Content
author's profile photo
Former Member

How to view /SAPAPO/ tables using SQL Studio question

Hi,

This is for Livecache 7.4 on AIX.

I have installed a SQL Studio 7.6. When I logged using SUPERDBA/admin, I can only see tables owned by SUPERDBA, SYS, and DOMAIN.

I cannot see any tables owned by SAP<LC Name>. I want to see details about table e.g. /SAPAPO/ORDKEY, which is owed by SAP<LC Name>.

Is it possible to see it using SQL Studio?

Please let me know if anybody has any idea about it.

Regards.

Sume.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 06:29 PM

    Hi Sume,

    in SQL studio, if you log on to liveCache as the sap<sid> user, you should be able to see all tables owned by sap<sid>, including /SAPAPO/ORDKEY.

    Regards,

    Ashwath

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Sume,

      If you would like to see details about table e.g. /SAPAPO/ORDKEY.

      =>

      Did you check the owner of this table?

      => You could check, for example, in LC10 -> liveCache:Monitoring

      -> Problem Analysis -> Tables/Views/Synonyms ->

      Database Object Schema SAPLCT

      Name of Database Object *

      < execute >

      & review if the table /SAPAPO/ORDKEY is listed.

      => If the table is listed, you should be able to run the select statement as SAPLCT user on this table.

      If you are sure that you was using the SAPLCT user, please

      Check if this user has application tables:

      < May be the password was changed from the default sap for the

      Standard liveCache user, you should know it. >

      dbmcli -d LCT -u control,control

      dbmcli on LCT>sql_connect SAPLCT,sap

      dbmcli on LCT> sql_execute select * from users

      dbmcli on LCT> sql_execute select * from users

      < I would like to see what DBA users you have in liveCche &

      when the SAPLCT user was created. >

      dbmcli on LCT>sql_execute select tablename from tables where owner='SAPLCT'

      < If the SAPLCT is the owner of the liveCche application tables,

      and the table /SAPAPO/ORDKEY will be listed. >

      dbmcli on LCT> sql_execute select * from tables where owner='SAPLCT'

      ...

      dbmcli on LCT> sql_execute select count(*) from "SAPLCT"."/SAPAPO/ORDKEY"

      < to get number of the entries in the table with owner - SAPLCT >

      dbmcli on LCT>exit

      ***

      You could also to check what user did you set for the LCA connection.

      And run //om16 transaction in the liveCache relevant client on the system

      to see the entries in the /sapapo/ordkey & /sapapo/ordmap in liveCache in this client.

      ***

      Question: What details you need about table /SAPAPO/ORDKEY?

      Do you have problems on your system?

      Thank you and best regards, Natlia Khlopina