Tuesday, September 25, 2018

Data_Validation


1.       


 

Total Table count:

Enovia:


 

Total Table count:

Enovia Test:


 

 

 

2.

Total Number of Database Objects present in each Schema.

ENOTEST:

 

 

SQL> select count(*),owner from dba_objects group by owner;

 

  COUNT(*) OWNER

---------- ------------------------------

        12 OWBSYS_AUDIT

       166 IAM_ADMIN

      1509 MDSYS

         4 X3DSADMIN

     27732 PUBLIC

         9 OUTLN

       366 CTXSYS

       719 OLAPSYS

        12 FLOWS_FILES

         2 OWBSYS

        34 HR

 

  COUNT(*) OWNER

---------- ------------------------------

        31 R2015XZ

       117 X3DS

       529 SYSTEM

         8 ORACLE_OCM

       310 EXFSYS

      2406 APEX_030200

         6 SCOTT

        16 CAS

        27 PM

       127 OE

        65 DBSNMP

 

  COUNT(*) OWNER

---------- ------------------------------

      2532 ORDSYS

        10 ORDPLUGINS

      3491 SYSMAN

      1165 V6R2015X

      1164 R2015XV6

        55 IX

         3 APPQOSSYS

       844 XDB

       248 ORDDATA

     31152 SYS

       316 WMSYS

 

  COUNT(*) OWNER

---------- ------------------------------

         8 SI_INFORMTN_SCHEMA

 

34 rows selected.

 

 

 

 

 

ENOVIA :

SQL> select count(*),owner from dba_objects group by owner;

 

  COUNT(*) OWNER

---------- ------------------------------

        12 OWBSYS_AUDIT

       166 IAM_ADMIN

      1509 MDSYS

         4 X3DSADMIN

     27732 PUBLIC

         9 OUTLN

       366 CTXSYS

       719 OLAPSYS

        12 FLOWS_FILES

         2 OWBSYS

        34 HR

 

  COUNT(*) OWNER

---------- ------------------------------

        31 R2015XZ

       117 X3DS

       529 SYSTEM

         8 ORACLE_OCM

       310 EXFSYS

      2406 APEX_030200

         6 SCOTT

        16 CAS

        27 PM

       127 OE

        65 DBSNMP

 

  COUNT(*) OWNER

---------- ------------------------------

      2532 ORDSYS

        10 ORDPLUGINS

      3491 SYSMAN

      1165 V6R2015X

      1164 R2015XV6

        55 IX

         3 APPQOSSYS

       844 XDB

       248 ORDDATA

     31177 SYS

       316 WMSYS

 

  COUNT(*) OWNER

---------- ------------------------------

         8 SI_INFORMTN_SCHEMA

 

34 rows selected.

 

 

 

 

 

 

 

 

 

 

 

 

3.

VALID/INVALID OBJECT STATUS:

 

 

 


 

 

 

 

 

 

 

 

 


 

 

 

 

 

 

4.

 

select OBJECT_NAME,OBJECT_TYPE,CREATED from dba_objects where status='VALID' and created >= '31-MAY-18';

 

 


 

 

 

 

5.

Details regarding Datafile:

ENOVIA PROD:

SQL> select name from v$datafile;

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/system01.dbf

/u01/app/oracle/oradata/orcl/sysaux01.dbf

/u01/app/oracle/oradata/orcl/undotbs01.dbf

/u01/app/oracle/oradata/orcl/users01.dbf

/u01/app/oracle/oradata/orcl/example01.dbf

/u01/app/oracle/oradata/orcl/MX_DATA15X.dbf

/u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf

/u01/app/oracle/oradata/orcl/dash_TS01.DBF

/u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF

/u01/app/oracle/oradata/orcl/iam_TS01.DBF

/u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/cas_TS01.DBF

/u01/app/oracle/oradata/orcl/users02.dbf

/u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF

/u01/app/oracle/oradata/orcl/dash_TS02.dbf

/u01/app/oracle/oradata/orcl/iam_TS02.dbf

/u01/app/oracle/oradata/orcl/iam_TS03.dbf

/u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf

/u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf

/u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf

/u01/app/oracle/oradata/orcl/cas_TS02.dbf

/u01/app/oracle/oradata/orcl/sysaux02.dbf

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/system02.dbf

/u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf

/u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf

/u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf

/u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf

/u01/app/oracle/oradata/orcl/system03.dbf

/u01/app/oracle/oradata/orcl/sysaux03.dbf

/u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf

/u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf

 

31 rows selected.

 

SQL> select name from v$tempfile;

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/temp01.dbf

/u01/app/oracle/oradata/orcl/temp02.dbf

/u01/app/oracle/oradata/orcl/temp04.dbf

 

SQL> select name from v$controlfile;

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/control01.ctl

/u01/app/oracle/flash_recovery_area/orcl/control02.ctl

 

SQL> select member as name from v$logfile;

 

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/redo03.log

/u01/app/oracle/oradata/orcl/redo02.log

/u01/app/oracle/oradata/orcl/redo01.log

 

 

 

 

 

 

 

ENOTEST:

 

SQL> select name from v$datafile;

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/system01.dbf

/home/u02/app/oracle/oradata/sysaux01.dbf

/home/u02/app/oracle/oradata/undotbs01.dbf

/home/u02/app/oracle/oradata/users01.dbf

/home/u02/app/oracle/oradata/example01.dbf

/home/u02/app/oracle/oradata/MX_DATA15X.dbf

/home/u02/app/oracle/oradata/MX_INDEX15X.dbf

/home/u02/app/oracle/oradata/dash_TS01.DBF

/home/u02/app/oracle/oradata/dashadmin_TS01.DBF

/home/u02/app/oracle/oradata/iam_TS01.DBF

/home/u02/app/oracle/oradata/iam_admin_TS01.DBF

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/cas_TS01.DBF

/home/u02/app/oracle/oradata/users02.dbf

/home/u02/app/oracle/oradata/dashadmin_TS02.DBF

/home/u02/app/oracle/oradata/dash_TS02.dbf

/home/u02/app/oracle/oradata/iam_TS02.dbf

/home/u02/app/oracle/oradata/iam_TS03.dbf

/home/u02/app/oracle/oradata/iam_admin_TS02.dbf

/home/u02/app/oracle/oradata/MX_DATA15X1.dbf

/home/u02/app/oracle/oradata/MX_INDEX15X1.dbf

/home/u02/app/oracle/oradata/cas_TS02.dbf

/home/u02/app/oracle/oradata/sysaux02.dbf

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/system02.dbf

/home/u02/app/oracle/oradata/R2015X/MX_DATA15X.dbf

/home/u02/app/oracle/oradata/R2015X/MX_INDEX15X.dbf

/home/u02/app/oracle/oradata/MX_V6DATA15X.dbf

/home/u02/app/oracle/oradata/MX_V6INDEX15X.dbf

/home/u02/app/oracle/oradata/system03.dbf

/home/u02/app/oracle/oradata/sysaux03.dbf

/home/u02/app/oracle/oradata/MX_INDEX15X02.dbf

/home/u02/app/oracle/oradata/MX_DATA15X02.dbf

 

31 rows selected.

 

SQL> select name from v$tempfile;

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/temp001.dbf

 

SQL> select name from v$controlfile;

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/cntrlorcl01.dbf

/home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf

 

SQL> select member as name from v$logfile;

 

NAME

--------------------------------------------------------------------------------

/home/u02/app/oracle/oradata/redo03.log

/home/u02/app/oracle/oradata/redo02.log

/home/u02/app/oracle/oradata/redo01.log

 

 

 

 

 

 

 

6.Number of records for V6R2015X Schema for tables.

 

ENOTEST:

select table_name,num_rows counter 

from dba_tables 

where owner = 'V6R2015X'

order by table_name;

 

TABLE_NAME                        COUNTER

------------------------------ ----------

IX65808C12_2B40FA89                     0

IX65808C12_37806708                     0

IX65808C12_5B8081F2                     0

IX65808C12_8700B9BB                     0

IX65808C12_8C8036A1                     0

IX65808C12_E5C042E3                     0

LXBINARY_2B40FA89                       0

LXBINARY_37806708                       0

LXBINARY_5B8081F2                       0

LXBINARY_8700B9BB                       0

LXBINARY_8C8036A1                       0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXBINARY_E5C042E3                       0

LXBOOL_2B40FA89                       594

LXBOOL_37806708                         0

LXBOOL_5B8081F2                         0

LXBOOL_8700B9BB                      1264

LXBOOL_8C8036A1                         0

LXBOOL_E5C042E3                         2

LXBO_2B40FA89                       66523

LXBO_37806708                           0

LXBO_5B8081F2                         400

LXBO_8700B9BB                         263

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXBO_8C8036A1                           0

LXBO_E5C042E3                         962

LXDATE_2B40FA89                    170421

LXDATE_37806708                         0

LXDATE_5B8081F2                         0

LXDATE_8700B9BB                       177

LXDATE_8C8036A1                         0

LXDATE_E5C042E3                        14

LXDESC_2B40FA89                       830

LXDESC_37806708                         0

LXDESC_5B8081F2                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXDESC_8700B9BB                        12

LXDESC_8C8036A1                         0

LXDESC_E5C042E3                       291

LXDRO_2B40FA89                          0

LXDRO_37806708                          0

LXDRO_5B8081F2                          0

LXDRO_8700B9BB                          7

LXDRO_8C8036A1                          0

LXDRO_E5C042E3                          0

LXFILE_2B40FA89                         9

LXFILE_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXFILE_5B8081F2                         0

LXFILE_8700B9BB                         0

LXFILE_8C8036A1                         0

LXFILE_E5C042E3                         0

LXFOREIGN_2B40FA89                      0

LXFOREIGN_37806708                      0

LXFOREIGN_5B8081F2                      0

LXFOREIGN_8700B9BB                      0

LXFOREIGN_8C8036A1                      0

LXFOREIGN_E5C042E3                      0

LXGRANT_2B40FA89                        1

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXGRANT_37806708                        0

LXGRANT_5B8081F2                        0

LXGRANT_8700B9BB                        0

LXGRANT_8C8036A1                        0

LXGRANT_E5C042E3                        0

LXHIST_2B40FA89                   1955427

LXHIST_37806708                         0

LXHIST_5B8081F2                      2776

LXHIST_8700B9BB                       559

LXHIST_8C8036A1                         0

LXHIST_E5C042E3                      4295

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXIMG_2B40FA89                          0

LXIMG_37806708                          0

LXIMG_5B8081F2                          0

LXIMG_8700B9BB                          0

LXIMG_8C8036A1                          0

LXIMG_E5C042E3                          0

LXINST_2B40FA89                         0

LXINST_37806708                         0

LXINST_5B8081F2                         0

LXINST_8700B9BB                         0

LXINST_8C8036A1                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXINST_E5C042E3                         0

LXINTER_2B40FA89                        0

LXINTER_37806708                        0

LXINTER_5B8081F2                      199

LXINTER_8700B9BB                        0

LXINTER_8C8036A1                        0

LXINTER_E5C042E3                        0

LXINT_2B40FA89                      73032

LXINT_37806708                          0

LXINT_5B8081F2                          1

LXINT_8700B9BB                       1337

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXINT_8C8036A1                          0

LXINT_E5C042E3                         12

LXLONG_2B40FA89                         2

LXLONG_37806708                         0

LXLONG_5B8081F2                         0

LXLONG_8700B9BB                         0

LXLONG_8C8036A1                         0

LXLONG_E5C042E3                         0

LXMBOOL_2B40FA89                        0

LXMBOOL_37806708                        0

LXMBOOL_5B8081F2                        0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMBOOL_8700B9BB                        0

LXMBOOL_8C8036A1                        0

LXMBOOL_E5C042E3                        0

LXMDATE_2B40FA89                        0

LXMDATE_37806708                        0

LXMDATE_5B8081F2                        0

LXMDATE_8700B9BB                        0

LXMDATE_8C8036A1                        0

LXMDATE_E5C042E3                        0

LXMINT_2B40FA89                         0

LXMINT_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMINT_5B8081F2                         0

LXMINT_8700B9BB                         0

LXMINT_8C8036A1                         0

LXMINT_E5C042E3                         0

LXMREAL_2B40FA89                        0

LXMREAL_37806708                        0

LXMREAL_5B8081F2                        0

LXMREAL_8700B9BB                        0

LXMREAL_8C8036A1                        0

LXMREAL_E5C042E3                        0

LXMSTR_2B40FA89                       664

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMSTR_37806708                         0

LXMSTR_5B8081F2                         0

LXMSTR_8700B9BB                         0

LXMSTR_8C8036A1                         0

LXMSTR_E5C042E3                         0

LXOID_2B40FA89                    3963669

LXOID_37806708                          0

LXOID_5B8081F2                       1192

LXOID_8700B9BB                        278

LXOID_8C8036A1                          0

LXOID_E5C042E3                       1106

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXOWNER_2B40FA89                    24279

LXOWNER_37806708                        0

LXOWNER_5B8081F2                        0

LXOWNER_8700B9BB                        0

LXOWNER_8C8036A1                        0

LXOWNER_E5C042E3                        0

LXPATH_2B40FA89                         0

LXPATH_37806708                         0

LXPATH_5B8081F2                         0

LXPATH_8700B9BB                         0

LXPATH_8C8036A1                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXPATH_E5C042E3                         0

LXPE_2B40FA89                           0

LXPE_37806708                           0

LXPE_5B8081F2                           0

LXPE_8700B9BB                           0

LXPE_8C8036A1                           0

LXPE_E5C042E3                           0

LXREAL_2B40FA89                    121422

LXREAL_37806708                         0

LXREAL_5B8081F2                         0

LXREAL_8700B9BB                         7

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXREAL_8C8036A1                         0

LXREAL_E5C042E3                         2

LXRES_2B40FA89                          0

LXRES_37806708                          0

LXRES_5B8081F2                          0

LXRES_8700B9BB                          0

LXRES_8C8036A1                          0

LXRES_E5C042E3                          0

LXRO_2B40FA89                      248117

LXRO_37806708                           0

LXRO_5B8081F2                         792

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXRO_8700B9BB                           0

LXRO_8C8036A1                           0

LXRO_E5C042E3                         140

LXSET_2B40FA89                     172357

LXSET_37806708                          0

LXSET_5B8081F2                          0

LXSET_8700B9BB                          0

LXSET_8C8036A1                          0

LXSET_E5C042E3                          0

LXSIGN_2B40FA89                         0

LXSIGN_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSIGN_5B8081F2                         0

LXSIGN_8700B9BB                         0

LXSIGN_8C8036A1                         0

LXSIGN_E5C042E3                         0

LXSLONG_2B40FA89                        0

LXSLONG_37806708                        0

LXSLONG_5B8081F2                        0

LXSLONG_8700B9BB                        0

LXSLONG_8C8036A1                        0

LXSLONG_E5C042E3                        0

LXSTATE_2B40FA89                    39436

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSTATE_37806708                        0

LXSTATE_5B8081F2                      400

LXSTATE_8700B9BB                      236

LXSTATE_8C8036A1                        0

LXSTATE_E5C042E3                     1662

LXSTRING_2B40FA89                  471300

LXSTRING_37806708                       0

LXSTRING_5B8081F2                     998

LXSTRING_8700B9BB                    2687

LXSTRING_8C8036A1                       0

LXSTRING_E5C042E3                   25465

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSTRUC_2B40FA89                        0

LXSTRUC_37806708                        0

LXSTRUC_5B8081F2                        0

LXSTRUC_8700B9BB                        0

LXSTRUC_8C8036A1                        0

LXSTRUC_E5C042E3                        0

LXTEMPSET_2B40FA89

LXTEMPSET_37806708

LXTEMPSET_5B8081F2

LXTEMPSET_8700B9BB

LXTEMPSET_8C8036A1

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXTEMPSET_E5C042E3

LXUNIT_2B40FA89                      9888

LXUNIT_37806708                         0

LXUNIT_5B8081F2                         0

LXUNIT_8700B9BB                         0

LXUNIT_8C8036A1                         0

LXUNIT_E5C042E3                         0

LXVCCN_2B40FA89                         0

LXVCCN_37806708                         0

LXVCCN_5B8081F2                         0

LXVCCN_8700B9BB                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXVCCN_8C8036A1                         0

LXVCCN_E5C042E3                         0

LXWRGR_2B40FA89                         4

LXWRGR_37806708                         0

LXWRGR_5B8081F2                         0

LXWRGR_8700B9BB                         0

LXWRGR_8C8036A1                         0

LXWRGR_E5C042E3                         0

MXACCESS                             2032

MXADMIN                                15

MXAPPLICATION                           2

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXASSIGN                             1887

MXATTRTYPE                           8526

MXBUSTYPE                            1965

MXCHANNEL                              93

MXCUE                                 213

MXCUSTOMEVENT                           1

MXDEFINT                                0

MXDEFREAL                               0

MXDESC                             407190

MXDIMENSION                           379

MXDRVINFO                           63946

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXEXPRESSION                           74

MXFAMILY                                7

MXFIELD                              7547

MXFILEAUX                               0

MXFILTER                             3974

MXFORM                                220

MXFORMAT                               56

MXFRAME                                 0

MXFUNCTION                           3546

MXHIST                             173133

MXIADMIN                                0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXICON                                543

MXIDENT                             78065

MXINDEX                                12

MXINTERFACE                          1181

MXLATTICE                               7

MXLIST                                 30

MXLOCATION                              1

MXMAIL                             369219

MXMAILRCP                          495589

MXMENU                               3108

MXNAMEDLONG                            64

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXOBJEVENTLOG                           0

MXOBJEVENTMONITOR                       1

MXOID                              689613

MXOTHERADMIN                       295500

MXOV                                  241

MXOWNER                              1546

MXPACKAGE                             717

MXPARENT                                0

MXPATHTYPE                              2

MXPERSONPROD                          357

MXPOLICY                              364

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXPOLINFO                            2165

MXPORTAL                               66

MXPRODUCT                               1

MXPROGRAM                            1506

MXPROPERTY                         328554

MXQUERY                                 2

MXRANGELIST                          2276

MXRELTYPE                            1265

MXREPORT                                0

MXREPORTFIELD                           0

MXSCHEMA                              118

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXSERVER                                1

MXSET                              264846

MXSETOBJ                           245465

MXSIGREQ                                0

MXSRVLAT                                0

MXSTATEREQ                           1196

MXSTATEREQUSR                       16277

MXSTORE                                 4

MXTEMPOID

MXTENANT                                1

MXTNR                               17587

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXTRANSATTR                             0

MXTTABLE                              542

MXUNIQUEKEY                             0

MXUNIT                               1228

MXUSER                                844

MXVER6                                  1

MXWALLET                                0

MXWEBREPEXT                           112

MXWEBREPORT                            22

MXWEBREPSUM                            44

MXWRGR                                 45

 

308 rows selected.

 

 

 

 

 

ENOVIA PRODUCTION:

TABLE_NAME                        COUNTER

------------------------------ ----------

IX65808C12_2B40FA89                     0

IX65808C12_37806708                     0

IX65808C12_5B8081F2                     0

IX65808C12_8700B9BB                     0

IX65808C12_8C8036A1                     0

IX65808C12_E5C042E3                     0

LXBINARY_2B40FA89                       0

LXBINARY_37806708                       0

LXBINARY_5B8081F2                       0

LXBINARY_8700B9BB                       0

LXBINARY_8C8036A1                       0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXBINARY_E5C042E3                       0

LXBOOL_2B40FA89                       594

LXBOOL_37806708                         0

LXBOOL_5B8081F2                         0

LXBOOL_8700B9BB                      1264

LXBOOL_8C8036A1                         0

LXBOOL_E5C042E3                         2

LXBO_2B40FA89                       66523

LXBO_37806708                           0

LXBO_5B8081F2                         400

LXBO_8700B9BB                         263

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXBO_8C8036A1                           0

LXBO_E5C042E3                         962

LXDATE_2B40FA89                    170421

LXDATE_37806708                         0

LXDATE_5B8081F2                         0

LXDATE_8700B9BB                       177

LXDATE_8C8036A1                         0

LXDATE_E5C042E3                        14

LXDESC_2B40FA89                       830

LXDESC_37806708                         0

LXDESC_5B8081F2                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXDESC_8700B9BB                        12

LXDESC_8C8036A1                         0

LXDESC_E5C042E3                       291

LXDRO_2B40FA89                          0

LXDRO_37806708                          0

LXDRO_5B8081F2                          0

LXDRO_8700B9BB                          7

LXDRO_8C8036A1                          0

LXDRO_E5C042E3                          0

LXFILE_2B40FA89                         9

LXFILE_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXFILE_5B8081F2                         0

LXFILE_8700B9BB                         0

LXFILE_8C8036A1                         0

LXFILE_E5C042E3                         0

LXFOREIGN_2B40FA89                      0

LXFOREIGN_37806708                      0

LXFOREIGN_5B8081F2                      0

LXFOREIGN_8700B9BB                      0

LXFOREIGN_8C8036A1                      0

LXFOREIGN_E5C042E3                      0

LXGRANT_2B40FA89                        1

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXGRANT_37806708                        0

LXGRANT_5B8081F2                        0

LXGRANT_8700B9BB                        0

LXGRANT_8C8036A1                        0

LXGRANT_E5C042E3                        0

LXHIST_2B40FA89                   1955427

LXHIST_37806708                         0

LXHIST_5B8081F2                      2776

LXHIST_8700B9BB                       559

LXHIST_8C8036A1                         0

LXHIST_E5C042E3                      4295

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXIMG_2B40FA89                          0

LXIMG_37806708                          0

LXIMG_5B8081F2                          0

LXIMG_8700B9BB                          0

LXIMG_8C8036A1                          0

LXIMG_E5C042E3                          0

LXINST_2B40FA89                         0

LXINST_37806708                         0

LXINST_5B8081F2                         0

LXINST_8700B9BB                         0

LXINST_8C8036A1                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXINST_E5C042E3                         0

LXINTER_2B40FA89                        0

LXINTER_37806708                        0

LXINTER_5B8081F2                      199

LXINTER_8700B9BB                        0

LXINTER_8C8036A1                        0

LXINTER_E5C042E3                        0

LXINT_2B40FA89                      73032

LXINT_37806708                          0

LXINT_5B8081F2                          1

LXINT_8700B9BB                       1337

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXINT_8C8036A1                          0

LXINT_E5C042E3                         12

LXLONG_2B40FA89                         2

LXLONG_37806708                         0

LXLONG_5B8081F2                         0

LXLONG_8700B9BB                         0

LXLONG_8C8036A1                         0

LXLONG_E5C042E3                         0

LXMBOOL_2B40FA89                        0

LXMBOOL_37806708                        0

LXMBOOL_5B8081F2                        0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMBOOL_8700B9BB                        0

LXMBOOL_8C8036A1                        0

LXMBOOL_E5C042E3                        0

LXMDATE_2B40FA89                        0

LXMDATE_37806708                        0

LXMDATE_5B8081F2                        0

LXMDATE_8700B9BB                        0

LXMDATE_8C8036A1                        0

LXMDATE_E5C042E3                        0

LXMINT_2B40FA89                         0

LXMINT_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMINT_5B8081F2                         0

LXMINT_8700B9BB                         0

LXMINT_8C8036A1                         0

LXMINT_E5C042E3                         0

LXMREAL_2B40FA89                        0

LXMREAL_37806708                        0

LXMREAL_5B8081F2                        0

LXMREAL_8700B9BB                        0

LXMREAL_8C8036A1                        0

LXMREAL_E5C042E3                        0

LXMSTR_2B40FA89                       664

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXMSTR_37806708                         0

LXMSTR_5B8081F2                         0

LXMSTR_8700B9BB                         0

LXMSTR_8C8036A1                         0

LXMSTR_E5C042E3                         0

LXOID_2B40FA89                    3963669

LXOID_37806708                          0

LXOID_5B8081F2                       1192

LXOID_8700B9BB                        278

LXOID_8C8036A1                          0

LXOID_E5C042E3                       1106

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXOWNER_2B40FA89                    24279

LXOWNER_37806708                        0

LXOWNER_5B8081F2                        0

LXOWNER_8700B9BB                        0

LXOWNER_8C8036A1                        0

LXOWNER_E5C042E3                        0

LXPATH_2B40FA89                         0

LXPATH_37806708                         0

LXPATH_5B8081F2                         0

LXPATH_8700B9BB                         0

LXPATH_8C8036A1                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXPATH_E5C042E3                         0

LXPE_2B40FA89                           0

LXPE_37806708                           0

LXPE_5B8081F2                           0

LXPE_8700B9BB                           0

LXPE_8C8036A1                           0

LXPE_E5C042E3                           0

LXREAL_2B40FA89                    121422

LXREAL_37806708                         0

LXREAL_5B8081F2                         0

LXREAL_8700B9BB                         7

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXREAL_8C8036A1                         0

LXREAL_E5C042E3                         2

LXRES_2B40FA89                          0

LXRES_37806708                          0

LXRES_5B8081F2                          0

LXRES_8700B9BB                          0

LXRES_8C8036A1                          0

LXRES_E5C042E3                          0

LXRO_2B40FA89                      248117

LXRO_37806708                           0

LXRO_5B8081F2                         792

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXRO_8700B9BB                           0

LXRO_8C8036A1                           0

LXRO_E5C042E3                         140

LXSET_2B40FA89                     172357

LXSET_37806708                          0

LXSET_5B8081F2                          0

LXSET_8700B9BB                          0

LXSET_8C8036A1                          0

LXSET_E5C042E3                          0

LXSIGN_2B40FA89                         0

LXSIGN_37806708                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSIGN_5B8081F2                         0

LXSIGN_8700B9BB                         0

LXSIGN_8C8036A1                         0

LXSIGN_E5C042E3                         0

LXSLONG_2B40FA89                        0

LXSLONG_37806708                        0

LXSLONG_5B8081F2                        0

LXSLONG_8700B9BB                        0

LXSLONG_8C8036A1                        0

LXSLONG_E5C042E3                        0

LXSTATE_2B40FA89                    39436

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSTATE_37806708                        0

LXSTATE_5B8081F2                      400

LXSTATE_8700B9BB                      236

LXSTATE_8C8036A1                        0

LXSTATE_E5C042E3                     1662

LXSTRING_2B40FA89                  471300

LXSTRING_37806708                       0

LXSTRING_5B8081F2                     998

LXSTRING_8700B9BB                    2687

LXSTRING_8C8036A1                       0

LXSTRING_E5C042E3                   25465

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXSTRUC_2B40FA89                        0

LXSTRUC_37806708                        0

LXSTRUC_5B8081F2                        0

LXSTRUC_8700B9BB                        0

LXSTRUC_8C8036A1                        0

LXSTRUC_E5C042E3                        0

LXTEMPSET_2B40FA89

LXTEMPSET_37806708

LXTEMPSET_5B8081F2

LXTEMPSET_8700B9BB

LXTEMPSET_8C8036A1

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXTEMPSET_E5C042E3

LXUNIT_2B40FA89                      9888

LXUNIT_37806708                         0

LXUNIT_5B8081F2                         0

LXUNIT_8700B9BB                         0

LXUNIT_8C8036A1                         0

LXUNIT_E5C042E3                         0

LXVCCN_2B40FA89                         0

LXVCCN_37806708                         0

LXVCCN_5B8081F2                         0

LXVCCN_8700B9BB                         0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

LXVCCN_8C8036A1                         0

LXVCCN_E5C042E3                         0

LXWRGR_2B40FA89                         4

LXWRGR_37806708                         0

LXWRGR_5B8081F2                         0

LXWRGR_8700B9BB                         0

LXWRGR_8C8036A1                         0

LXWRGR_E5C042E3                         0

MXACCESS                             2032

MXADMIN                                15

MXAPPLICATION                           2

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXASSIGN                             1887

MXATTRTYPE                           8526

MXBUSTYPE                            1965

MXCHANNEL                              93

MXCUE                                 213

MXCUSTOMEVENT                           1

MXDEFINT                                0

MXDEFREAL                               0

MXDESC                             407190

MXDIMENSION                           379

MXDRVINFO                           63946

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXEXPRESSION                           74

MXFAMILY                                7

MXFIELD                              7547

MXFILEAUX                               0

MXFILTER                             3974

MXFORM                                220

MXFORMAT                               56

MXFRAME                                 0

MXFUNCTION                           3546

MXHIST                             173133

MXIADMIN                                0

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXICON                                543

MXIDENT                             78065

MXINDEX                                12

MXINTERFACE                          1181

MXLATTICE                               7

MXLIST                                 30

MXLOCATION                              1

MXMAIL                             369219

MXMAILRCP                          495589

MXMENU                               3108

MXNAMEDLONG                            64

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXOBJEVENTLOG                           0

MXOBJEVENTMONITOR                       1

MXOID                              689613

MXOTHERADMIN                       295500

MXOV                                  241

MXOWNER                              1546

MXPACKAGE                             717

MXPARENT                                0

MXPATHTYPE                              2

MXPERSONPROD                          357

MXPOLICY                              364

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXPOLINFO                            2165

MXPORTAL                               66

MXPRODUCT                               1

MXPROGRAM                            1506

MXPROPERTY                         328554

MXQUERY                                 2

MXRANGELIST                          2276

MXRELTYPE                            1265

MXREPORT                                0

MXREPORTFIELD                           0

MXSCHEMA                              118

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXSERVER                                1

MXSET                              264846

MXSETOBJ                           245465

MXSIGREQ                                0

MXSRVLAT                                0

MXSTATEREQ                           1196

MXSTATEREQUSR                       16277

MXSTORE                                 4

MXTEMPOID

MXTENANT                                1

MXTNR                               17587

 

TABLE_NAME                        COUNTER

------------------------------ ----------

MXTRANSATTR                             0

MXTTABLE                              542

MXUNIQUEKEY                             0

MXUNIT                               1228

MXUSER                                844

MXVER6                                  1

MXWALLET                                0

MXWEBREPEXT                           112

MXWEBREPORT                            22

MXWEBREPSUM                            44

MXWRGR                                 45

 

308 rows selected.

No comments:

Post a Comment

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files. I got the issue below wh...