SAP Note 1309424 - DB6: DBA Cockpit Correction Collection SAP Basis 7.01 / 7.11

Composant : CCMS/Database Monitors for DB2 Universal Database - DB2 Universal Database for Unix / NT

Solution : https://service.sap.com/sap/support/notes/1309424 (Connexion à SAP Service Marketplace requise)

Résumé :
Cette note SAP constitue une ressource regroupant des corrections pour le DBA Cockpit dans les versions SAP Basis 7.01 et 7.11. Elle intègre d'autres notes SAP nécessaires, régulièrement mises à jour et étendues, utilisables via la transaction SNOTE comme mécanisme de mise à jour générique pour le DBA Cockpit. La note aborde les erreurs de programmation dans le DBA Cockpit, recommandant une mise en œuvre récurrente de la note à chaque mise à jour via la transaction SNOTE. Les mises à jour appliquent uniquement les modifications incrémentales. L'intégration à l'Assistant de Notes SAP garantit l'exactitude de l'implémentation des corrections, tout en tenant compte du niveau de Package de Support du système SAP.

Mots Clés :
sap note assistant guarantees, implement succeeding corrections automatically, sap note includes, sap basis release 7, generic update mechanism, support package level, required sap notes, prerequisites programm errors, terms dba cockpit, dba cockpit solution

Notes associées :

1639631DBA Cockpit: Failed schedulings in DB13
1626472DB6: Error message SQL0443N in background process
1624436DBA Cockpit: Errors when accessing SHM area CL_DBA_SHM_AREA
1619636DBA Cockpit: Daily scheduling is not deleted
1619084DBA Cockpit: Runtime err MESSAGE_TYPE_X when alert displayed
1615698DBA Cockpit: Incorrect date selection in DB13C
1613270DB6: Runtime error DYNPRO_FIELD_CONVERSION in DBA cockpit
1602403DB6: No VOLATILE attribute after RUNSTATS or REORG job
1599764DB6: SQL error 1428 when calling transaction SM50
1597281DB6: Incorrect compression displays for tables
1576094DB6: Database error SQL1751N in partitioning wizard
1571365DB6: SQL error SQL0443N in alert monitoring of DPF system
1569669DB6: Incomplete history for performance data
1569592DB6: SQL error SQL0433N in EXPLAIN
1568800DB6: Error when deleting alert messages
1563327DB6: SQL error SQL0551N when accessing SYSSTAT.TABLES
1559967DB6: SQL error 206 when collecting the table history
1559699DB6: Missing data in SQL cache display
1557981DB6: Adjustments in DBA Cockpit for new database versions
1552812DB6: Use of db2sap functions
1551729DB6: Incorrect number of key fields in EXPLAIN
1546866DB6: Runstats_DBSTATC interprets runtime param. incorrectly
1542311DB6: Runtime error BCD_OVERFLOW in auto maintenance display
1536787DBA Cockpit: WebDynpro Explain - LOADDATA requires a model
1532114DB6: Too many locks when collecting table history
1522617DB6: Availability of BW-specific functions in DBA Cockpit
1521525DB6: Table display is not sorted
1519347DB6: Container path cannot be created
1511803DB6: DB_TABLE_DATA_READ does not return data
1509121DBA Cockpit: Endless loop occurs when starting DBA Cockpit
1508252DB6: No display of name in tablespace history
1508074RZ20: 'Connection' attribute does not report alerts
1501130DB6: SQL error 802 in DB6_DIAG_COUNT_TABLE_ENTRIES
1496515DB6: SQL error 1428N when starting the DBA Cockpit
1486972DB6: Parameters for DB/DBM configuration cannot be changed
1485313DBA Cockpit: Incomplete system entries after SLD import
1469515DB6: Runtime error GETWA_NOT_ASSIGNED_RANGE in SAPLSDB6MON
1464858DB6: COMPUTE_BCD_OVERFLOW during EXPLAIN Test Execute
1464800DB6: SQL Commands executes automatically on system change
1462855DB6: Incorrect database name in HA environment
1460895DB6: SQL0104N during creation of WLM threshold
1456379DB6: No display of indexes in data classes
1455897DB6: Display of data classes is not updated
1452502DBA Cockpit: Jobs are missing in central planning calendar
1452197DB6: SQL error 100 in job REORGCHK_ALL
1451958DBA Cockpit: Incorrect start time for jobs
1449482DB6: Error message 'Command LIST_DB2DUMP failed'
1444373DB6: Loading the package cache with monitor functions
1439835DB6: No System Catalog information shown in EXPLAIN
1438168DB6: REORGCHK recommendations for indexes are missing
1430058DB6: Short Dump in CL_DB6_TASK_SCHEDULER_NATIVE
1429687DB6: SQL cache performance
1429082DB6: No REORG after deactivating compression
1427030DB6: Container specifications for tablespaces not changeable
1426480DB2: Incorrect display of registry values for DPF systems
1426092DB6: Incorrect DROPPED TABLE clause for tablespaces
1421157DB6: SQL error 204 when accessing table DBSTATC
1414626DB6: Incorrect display of file system sizes of containers
1414624DB6: Performance views if database monitors are deactivated
1413008DB6: SQL0206N in function module DB6_PM_LOCKSNAP
1409540DB6: CCMS Adoptions for DB2 pureScale Feature
1400843DB6: Incorrect display of key fields in EXPLAIN
1398258DB6: Job REORGCHK_ALL places load on package cache
1387297DB6: SQL-Fehler 901 during RUNSTATS and REORGCHK
1387022DBA Cockpit: Month displayed incorrectly in DB13C
1384238DB6: Defect scheduler on DB2 9.1 FP7/FP8 for LUW on Linux
1382996DB6: Update of DPW Back-End in Monitored DBs does not work
1382634DB6: Unable to create view 'SAPTOOLS.DBH_TABCLASS'
1381179DB6: Incorrect values for 'number of objects in tablespace'
1379346DB6: Scheduling of data collectors fails
1378499DB6: CLI error CLI0112E with "REORGCHK_ALL" job
1376543DB6: OPTIONS parameters for backup jobs in DB13
1373957DB6: CX_SY_CONVERSION_OVERFLOW in new EXPLAIN
1372652DB6: Short dump when viewing diaglog due to NULL bytes
1368327DB6: Runtime error UNCAUGHT_EXCEPTION in the DBA Cockpit
1367709DB6: Infinite Loop in Lockwaits and Deadlocks Analysis
1357500DB6: Database error SQL0443N in background processes
1355260DB6: Option is set incorrectly for tape archiving in DB13
1344899DB6: Short dump in WLM Critical Activities
1342954DB6: WLM event monitor setup fails on DPF systems
1341435DB6: EXPLAIN collect button: db2look uses incorrect schema
1340089DB6: SQL -104 in system log when using index advisor
1339167DBA Cockpit: Error if system ID contains lower case letters
1334756DB6: SQL error SQL0443N in alert monitoring of DPF system
1327732DB6: Option is set incorrectly for tape archiving in DB13
1327048DB6: Compression candidates displayed incorrectly
1323797DBA Cockpit: Incorrect date selection in planning calendar
1320008DBA Cockpit: Selection in "Missing Tables and Indexes"
1316579DB6: Missing privilege to alter WLM service class priority
1314173DB6: RSDB6ST04LIST fails with unkown connection AZ9_REM
1313004DBA Cockpit: Adding BI Web Tamplate causes Short Dump
1312958DB6: Runtime error COMPUTE_BCD_OVERFLOW in job Reorgchk_All
1312904DB6: Table/Index History is displayed in wrong order
1311910DB6: Incorrect displays in SQL cache for DPF systems
1310535DB6: Transaction log overflows with job 'Reorgchk_All'
1305925DB6: Missing functionality in 'SAP WLM Setup Status'
1299894DB6: Automatic DB/DDIC comparison
1293864DB6: Short Dump in Automatic Maintenance for Backup
1293321DB6: Backup jobs are displayed with incorrect status
1286561DB6: Enhancements in RZ20 alert monitor
1285006DB6: REORGCHK job terminates early
1284357DB6: History data is not retrieved
1283258DB6: Create BP with AUTOMATIC option not possible
1280387DB6: WLM report for violations has no service class
1279399DB6: EXPLAIN Test Execute ignores opt.guidelines
1277114DB6: Wrong Values for Tablespace Growth in Reporting
1273973DB6: Changing the DB configuration changes all partitions
1265982DB6: Alerts 'Missing Log Files'/'User Exit Status' in RZ20
1263872DB6: Runtime errors with "Delta to Checkpoint" function
1261679DBA Cockpit: Java schema not recognized
1256801DB6: Missing FLUSH Privilege in Deadlock Event Monitor
1251027DB6: RUNSTATS_DBSTATC does not process tables
1242505DB6: Shortdump due to INT overflow in SQL cache + DB Snap.
1242278DB6: Status 'Scheduling failed' in planning calendar
1240689DB6: Alert "Missing Log Files" when switching logging
1227051DB6: No alert data for AUTORESIZE tablespaces