DB6 10.5.4 - task scheduler don't start collectors

[martin_mikala]

Hi,

I've got one sandbox ECC607/NW740SP6 + RHEL6.5 with refreshed db from production. I implemented there fixpack 4 for 10.5 LUW + latest db2_update.db.sh script and latest SAP kernel 741 lvl 110 and latest dba cockpit correction note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31/7.40 v71.

When I changed collectors owner to this new and migrated to task scheduler, collectors don't run and auto maintenance probably too.

In db2diag aren't any errors and collectors logs and execution list are empty too.
I tried repair all collectors but without success.

In task list are task defined, db2acd is running and DB2_ATS_ENABLE=YES.

Only in "Diagnostic ->Self-monitoring" are yellow or red warnings.

" yellow 2014-10-29 14:34:53    Fast    Data Collection    Check of execution of data collector 'Tables (Storage)' by scheduler    Data Collection Framework Configuration    1801381"

note 1801381 seem only for older version of db2.

Manually is possible start this collectors, egs.

db2 "call SAPTOOLS.DBH_DIAG_LOG_COLLECT"

  Return Status = 0

Any idea what is wrong or where is possible check it?

db2 "SELECT SUBSTR(NAME,1,30) AS NAME,BEGIN_TIME,END_TIME,SUBSTR(SCHEDULE,1,30) AS SCHEDULE from SYSTOOLS.ADMIN_TASK_LIST"

NAME                           BEGIN_TIME                 END_TIME                   SCHEDULE

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

SAPTOOLS.DBH_FWK_CLEANUP       2014-10-28-23.29.45.017826 -                          0 0 * * *

SAPTOOLS.DBH_DB_COLLECT        2014-10-29-13.24.29.573478 -                          0 * * * *

SAPTOOLS.DBH_TBSP_COLLECT      2014-10-29-13.24.29.613250 -                          0 * * * *

SAPTOOLS.DBH_TBSPSTO_COLLECT   2014-10-28-23.34.49.612990 -                          0 0 * * *

SAPTOOLS.DBH_BP_COLLECT        2014-10-29-13.24.29.627810 -                          0 * * * *

SAPTOOLS.DBH_MEMORY_COLLECT    2014-10-29-13.24.29.637167 -                          0 * * * *

SAPTOOLS.DBH_TABLE_COLLECT     2014-10-28-23.34.57.797785 -                          0 0 * * *

SAPTOOLS.DBH_TABLEPRF_COLLECT  2014-10-28-23.34.50.363025 -                          0 0 * * *

SAPTOOLS.DBH_INDEX_COLLECT     2014-10-28-23.34.58.700634 -                          0 0 * * *

SAPTOOLS.DBH_CFG_COLLECT       2014-10-29-13.24.29.681000 -                          0 * * * *

SAPTOOLS.DBH_RSRC_COLLECT      2014-10-29-13.24.29.690339 -                          0 * * * *

SAPTOOLS.DBH_WLM_ACTS_COLLECT  2014-10-29-13.24.29.699684 -                          0 * * * *

SAPTOOLS.DBH_WLM_STATS_COLLECT 2014-10-29-13.24.29.710442 -                          0 * * * *

SAPTOOLS.DBH_WLM_THRS_COLLECT  2014-10-29-13.24.29.720629 -                          0 * * * *

SAPTOOLS.DBH_DIAG_LOG_COLLECT  2014-10-28-23.34.52.988319 -                          0,15,30,45 * * * *

SAPTOOLS.DBH_LCKEVENTS_COLLECT 2014-10-29-13.24.29.744965 -                          0 * * * *

SAPTOOLS.DBH_CONTAINER_COLLECT 2014-10-29-13.24.29.755133 -                          0 * * * *

SAPTOOLS.DBH_INDEXPRF_COLLECT  2014-10-28-23.34.53.806478 -                          0 0 * * *

SAPTOOLS.DBH_PKGCACHE_COLLECT  2014-10-28-23.34.54.527480 -                          0,15,30,45 * * * *

SAPTOOLS.DBH_CHGHISEVT_COLLECT 2014-10-28-23.34.54.712539 -                          0 * * * *

SAPTOOLS.DBH_LATCHWAIT_COLLECT 2014-10-28-23.34.54.995914 -                          0,15,30,45 * * * *

SAPTOOLS.DBH_HADR_COLLECT      2014-10-28-23.34.55.309313 -                          0,15,30,45 * * * *

db2 "SELECT SUBSTR(NAME,1,30) AS NAME,STATUS,BEGIN_TIME,END_TIME,RC from SYSTOOLS.ADMIN_TASK_STATUS ORDER BY BEGIN_TIME"
NAME	STATUS	BEGIN_TIME	END_TIME	RC

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

  0 record(s) selected.

[Former Member · Accepted solution]

Hi Martin,

check first who is the owner of the collectors with query

select key, varchar(value, 50) as value, varchar(dft, 50) as deferred_value from saptools.cockpit_cfg

usually is the Solution Manager connected to the system.  Then go to the SolMan and try to set up the collectors as described in the DBAcockpit guide

https://websmp109.sap-ag.de/~sapidb/011000358700000237582014E

Regards,
Javier

[martin_mikala · Accepted solution]

HI,

I didn't find this table cockpit_cfg.

db2 "select key, varchar(value, 50) as value, varchar(dft, 50) as deferred_value from saptools.cockpit_cfg"

SQL0204N  "SAPTOOLS.COCKPIT_CFG" is an undefined name.  SQLSTATE=42704

db2 list tables for schema saptools | grep -i cockpit

db2 list tables for all | grep -i cockpit

CEXO_COCKPIT_ENH                SAPSR3          T     2013-05-11-15.57.18.978146

CKMLCOCKPITSTATE                SAPSR3          T     2013-05-11-13.51.30.307418

[martin_mikala · Accepted solution]

Hi, Seems, that this table i missing. In DEV is available.

db2 "select key, varchar(value, 50) as value, varchar(dft, 50) as deferred_value from saptools.cockpit_cfg"

KEY                              VALUE                                              DEFERRED_VALUE

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

VERSION                          07.40.0006                                         07.40.0006

KEEP_STG_DATA                    336                                                336

KEEP_FW_DATA                     336                                                336

MSG_LEVEL                        2                                                  2

VERSION_DB                       07.40.0006                                         07.40.0006

[martin_mikala · Accepted solution]

Unable to insert key/value to configuration table

Exception CX_DBA_DBH_SETUP in class CL_DB6_DBH_SETUP method IF_DBA_DBH_SETUP~SET_VALUE line 107

      Kernel Error ID:      

      WP ID:      33 

      WP PID:      17036

      Application Server:      cisb227

      SYSID:      

      SY-SUBRC:      0 

      SY-TABIX:      0 

      Message:                       Unable to insert key/value to configuration table

      Database: 

      caused by

      Exception CX_DBA_ADBC in program RSDB0002  line 0 

           Kernel Error ID:      

           WP ID:      33 

           WP PID:      17036

           Application Server:      cisb227

           SYSID:      SB2

           SY-SUBRC:      0 

           SQL statement: INSERT INTO SAPTOOLS.COCKPIT_CFG( KEY, VALUE, DFT ) VALUES('MSG_LEVEL', '2', '2')

           Database: +++DB6ADM

      caused by

      Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT 

           Kernel Error ID:      

           DB Error:           Yes

           SQL Code:           204-

           SQL Message:      SQL0204N  "SAPTOOLS.COCKPIT_CFG" is an undefined name.  SQLSTATE=42704

           DB Object Exists:      No

           Duplicated Key:      No

           Internal Error:      5 

           Invalid Cursor:      No

           Unknown Connection:      No

           Connection Closed:      No

[former_member213250 · Accepted solution]

Hi Martin
Based on your current basis release SAPKB74006 there might be some code correction necessary.
I would say open and incident with SAP with the all the information.

Thanking you
Regards
Venkat Kunaal

[Former Member · Accepted solution]

Hello,

If there was a solution to your problem?

Can you provide, please?

Thanks

[martin_mikala · Accepted solution]

Hi,
I'm not sure how exactly it was solved. But I've only restarted databases and repaired all collectors from DBA cockpit. I think problem is occasionally with hang collector's process.

db2 get snapshot for database on $DB2DBDFT | grep oldest 

db2 get snapshot for application all | grep ATS

[former_member213250]

Hi Martin

Please check of all the DCF collectors are active.

Delete all the tasks with the red alerts in self monitoring and reactive them.
this may help.

Regards
Venkat.

[martin_mikala]

Hi,

I dropped all collectors and recreated them again, but without success.