Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  SQL0204N for select from IBMCONSOLE table

    Posted 12/23/19 04:36 PM
    Snippet from "tables/views from schema IBMCONSOLE"
    ​PS D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin> db2 list tables for schema IBMCONSOLE |findstr /i throughp
    THROUGHPUT_ALL                  IBMCONSOLE      V     2019-12-20-10.37.27.496000
    THROUGHPUT_ALL_DPF              IBMCONSOLE      V     2019-12-20-10.37.27.525001
    THROUGHPUT_ALL_WL               IBMCONSOLE      V     2019-12-20-10.37.32.044001
    THROUGHPUT_CONNECTION           IBMCONSOLE      V     2019-12-20-10.37.27.549001
    THROUGHPUT_MEMBER               IBMCONSOLE      V     2019-12-20-10.37.27.571001
    THROUGHPUT_SERVICECLASS         IBMCONSOLE      V     2019-12-20-10.37.27.597001
    THROUGHPUT_SYSTEM               IBMCONSOLE      V     2019-12-20-10.37.27.611001
    THROUGHPUT_WORKLOAD             IBMCONSOLE      V     2019-12-20-10.37.27.625001
    throughputAll                   IBMCONSOLE      T     2019-12-20-10.37.24.628001
    throughputAllDpf                IBMCONSOLE      T     2019-12-20-10.37.24.698001
    throughputAllWL                 IBMCONSOLE      T     2019-12-20-10.37.27.770001
    throughputConnection            IBMCONSOLE      T     2019-12-20-10.37.24.774001
    throughputMember                IBMCONSOLE      T     2019-12-20-10.37.24.940001
    throughputServiceclass          IBMCONSOLE      T     2019-12-20-10.37.25.019001
    throughputSystem                IBMCONSOLE      T     2019-12-20-10.37.25.179001
    throughputWorkload              IBMCONSOLE      T     2019-12-20-10.37.25.097001
    PS D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin>

    Anything wrong here ? its complaining table doesn't exist for the existing tables.

    PS D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin> db2 "select count(*) from IBMCONSOLE.wlmServiceSubclassStats with UR"
    SQL0204N  "IBMCONSOLE.WLMSERVICESUBCLASSSTATS" is an undefined name.
    SQLSTATE=42704
    PS D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin>

    S D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin> db2 runstats on table IBMCONSOLE.wlmServiceSubclass  with distribution and detailed indexes all
    QL2306N  The table or index "IBMCONSOLE.WLMSERVICESUBCLASS" does not exist.
    S D:\DB2_DMC\ibm-dmc-win64\ibm-datamgmtconsole\bin>

    ------------------------------
    srijith sudhakaran
    ------------------------------

    #Db2


  • 2.  RE: SQL0204N for select from IBMCONSOLE table

    Posted 12/24/19 03:37 AM
    Edited by System Admin 01/20/23 04:41 PM

    Hi srijit,
    Thanks for contacting.

    This table name is case sensitive, you need to add double quotes for its name: IBMCONSOLE."wlmServiceSubclassStats".

    Please have a try. If you have more questions, contact us freely.

    ------------------------------
    LI HUI YAN (Autumn Yan)
    From DMC team
    ------------------------------



Related Content