Author Topic: Identifying data tables  (Read 1886 times)

Mark@M

  • Newbie
  • *
  • Posts: 6
    • View Profile
Identifying data tables
« on: January 07, 2020, 09:06:54 AM »
Is there a way to identify the CMOD data tables when pulling all CMOD tables from SYSIBM.SYSTABLES ? 

Here is the generic query I have to pull all the tables ....
SELECT *                                               
--SELECT SUBSTR(DBNAME,1,8)   AS DBNAME                 
--     , RTRIM(SUBSTR(CREATOR,1,5)) CONCAT '.' CONCAT   
--       SUBSTR(NAME,1,20)    AS TABLE                 
FROM SYSIBM.SYSTABLES                                   
WHERE DBNAME LIKE 'ARS%' AND TYPE='T'                   
ORDER BY 1,2                                           
                                                       
                                                       

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Identifying data tables
« Reply #1 on: January 07, 2020, 10:53:04 AM »
Hey Mark.

You're going to love this article on IBM CMOD Tables in the CMOD wiki: 

https://cmod.wiki/index.php?title=Content_Manager_OnDemand_Database_Tables#arsseg_-_IBM_CMOD_Segment_Table

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR