SAP Database Interface, Database Platforms in Basis (BC-DB) Component Details & Tutorials

SAP BC-DB sub module is an application component stands for Database Interface, Database Platforms in Basis. It is coming under the BC module (BASIS). Here is a quick overview tutorial about its sub modules, transaction codes and tables for your training purpose.

SAP BC-DB module

SAP BC-DB SUB COMPONENTS

Here is the list of sub components coming under the SAP Database Interface, Database Platforms in Basis application component with the package name they belong to.

  1. HLB0009780 → BC-DB → Database Interface, Database Platforms
  2. HLB0009132 → BC-DB-DB2 → DB2 for z/OS
  3. B200001319 → BC-DB-DB2-CCM → DB2 for z/OS – CCM/Database Monitors
  4. B200001320 → BC-DB-DB2-DBA → DB2 for z/OS – Database Administration
  5. BYI3000910 → BC-DB-DB2-ICL → DB2 for z/OS – ICLI
  6. B200001321 → BC-DB-DB2-INS → DB2 for z/OS – Installation
  7. B200001322 → BC-DB-DB2-SYS → DB2 for z/OS – Database Interface
  8. B200001323 → BC-DB-DB2-UPG → DB2 for z/OS – Upgrade
  9. HLB0009782 → BC-DB-DB4 → DB2 for AS/400
  10. HLB0100139 → BC-DB-DB6 → DB2 Universal Database for UNIX / NT
  11. HLB0100141 → BC-DB-DB6-CCM → CCMS / Database Monitors for DB2 Universal Database
  12. HLB0100140 → BC-DB-DB6-DBA → Database Administration With DB2 Universal Database
  13. HLB0100142 → BC-DB-DB6-INS → SAP System Installation with DB2 Universal Database
  14. HLB0100143 → BC-DB-DB6-SYS → Database Interface / DBMS for DB2 Universal Database
  15. HLB0100144 → BC-DB-DB6-UPG → SAP System Upgrade with DB2 Universal Database
  16. HLB0009781 → BC-DB-DBI → DB-Independent Database Interface
  17. BYI3000021 → BC-DB-HDB → SAP HANA database
  18. BYI3000612 → BC-DB-HDB-AFL → SAP HANA Application Function Library
  19. BYI3000901 → BC-DB-HDB-AFL-DQ → SAP HANA Data Quality Library
  20. BYI3000613 → BC-DB-HDB-AFL-PAL → SAP HANA Predictive Analysis Library
  21. BYI3000614 → BC-DB-HDB-AFL-SOP → SAP HANA Sales&Operations Planning
  22. BYI3000615 → BC-DB-HDB-BAC → SAP HANA Backup & Recovery
  23. BYI3000616 → BC-DB-HDB-CCM → CCMS for SAP HANA
  24. BYI3000617 → BC-DB-HDB-CLI → SAP HANA Clients (JDBC, ODBC)
  25. BYI3000022 → BC-DB-HDB-DBA → Database Administration for SAP HANA
  26. BYI3000701 → BC-DB-HDB-DEC → Obsolete, please use BC-DB-HDB-DXC
  27. BYI3000618 → BC-DB-HDB-DXC → SAP HANA direct extractor connector
  28. BYI3000104 → BC-DB-HDB-ENG → Engine of SAP HANA DB
  29. BYI3000976 → BC-DB-HDB-HLM → SAP HANA Lifecycle Manager
  30. BYI3000023 → BC-DB-HDB-INS → Engine of SAP HANA DB
  31. BYI3000977 → BC-DB-HDB-LVC → SAP HANA integrated liveCache
  32. BYI3000105 → BC-DB-HDB-MDX → MDX Engine/Excel Client for SAP HANA
  33. BYI3000031 → BC-DB-HDB-PER → Database Persistence for SAP HANA
  34. BYI3000619 → BC-DB-HDB-POR → DB Porting for SAP HANA
  35. BYI3000620 → BC-DB-HDB-R → SAP HANA Integration with R
  36. BYI3000822 → BC-DB-HDB-SCN → Snapshot Management Environment
  37. BYI3000621 → BC-DB-HDB-SCR → SAP HANA SQL Script
  38. BYI3000978 → BC-DB-HDB-SCR-CLT → SQLScript Editor and Debugger Client
  39. BYI3000622 → BC-DB-HDB-SEC → SAP HANA Security & User Management
  40. BYI3000032 → BC-DB-HDB-SYS → Database Interface/DBMS for HDB
  41. BYI3000623 → BC-DB-HDB-TXT → SAP HANA Text & Search Features
  42. BYI3000033 → BC-DB-HDB-UPG → Upgrade of SAP HANA
  43. BYI3000691 → BC-DB-HDB-XS → SAP HANA Application Services
  44. BYI3000624 → BC-DB-HDB-XS-WB → Workbench / Team Provider for SAP HANA DB
  45. HLB0009164 → BC-DB-INF → Informix
  46. HLB0100123 → BC-DB-INF-CCM → CCMS / Database Monitors for Informix
  47. HLB0100122 → BC-DB-INF-DBA → Database Administration with Informix
  48. HLB0100124 → BC-DB-INF-INS → SAP System Installation with Informix
  49. HLB0100126 → BC-DB-INF-SYS → Database Interface / DBMS for Informix
  50. HLB0100127 → BC-DB-INF-UPG → SAP System Upgrade with Informix
  51. B200001938 → BC-DB-LCA → liveCache Applications
  52. B200003520 → BC-DB-LCA-APS → Advanced Planning and Scheduling Objects
  53. B200003521 → BC-DB-LCA-ATP → Object Availability Check
  54. B200003522 → BC-DB-LCA-COR → Customer Corrections
  55. B200003523 → BC-DB-LCA-DP → IC Applications for Demand Planning Objects
  56. B200003524 → BC-DB-LCA-INS → Installation and Handling of IC Applications
  57. B200003525 → BC-DB-LCA-REC → Recovery und Logging (< APO 3.0)
  58. B200003526 → BC-DB-LCA-REP → Reservation Planning Objects (Autom.)
  59. B200003527 → BC-DB-LCA-RPM → Rapid Planning Matrix Objects (Autom.)
  60. B200003528 → BC-DB-LCA-UTL → Test and Analysis Tools for IC Applications
  61. HLB0100441 → BC-DB-LVC → liveCache
  62. BIO0000011 → BC-DB-LVC-CCM → liveCache Administration and Monitor
  63. B200001939 → BC-DB-LVC-INS → liveCache Installation
  64. HLB0100442 → BC-DB-LVC-KNL → liveCache Kernel
  65. HLB0100444 → BC-DB-LVC-OMS → OMS Class for C++
  66. HLB0100443 → BC-DB-LVC-SQL → SQL Class for C++
  67. B200001940 → BC-DB-LVC-UPG → liveCache Upgrade
  68. BYI3000979 → BC-DB-MON → DBOS Cockpit Monitoring Infrastructure for Databases
  69. HLB0009133 → BC-DB-MSS → Microsoft SQL Server
  70. HLB0100136 → BC-DB-MSS-CCM → CCMS / Database Monitors for SQL Server
  71. HLB0100137 → BC-DB-MSS-INS → SAP System Installation for SQL Server
  72. HLB0100138 → BC-DB-MSS-UPG → Upgrade with SQL Server
  73. HLB0009163 → BC-DB-OPS → Oracle Parallel Server
  74. HLB0009162 → BC-DB-ORA → Oracle
  75. HLB0100128 → BC-DB-ORA-CCM → CCMS / Database Monitors for Oracle
  76. HLB0100129 → BC-DB-ORA-DBA → Database Administration with Oracle
  77. HLB0100130 → BC-DB-ORA-INS → SAP System Installation with Oracle
  78. B200001548 → BC-DB-ORA-RAC → Oracle Real Application Clusters (RAC)
  79. BYI3000911 → BC-DB-ORA-SEC → Oracle Security Messages
  80. B200001468 → BC-DB-ORA-SYS → Database Interface/DBMS for Oracle
  81. HLB0009131 → BC-DB-SDB → MaxDB
  82. B200004530 → BC-DB-SDB-BDG → Gateway for database (Terradata, etc.) connection to SAP BW
  83. HLB0100132 → BC-DB-SDB-CCM → CCMS/Database Monitors for MaxDB
  84. HLB0100131 → BC-DB-SDB-DBA → Database Administration on MaxDB
  85. HLB0100133 → BC-DB-SDB-INS → Installation with MaxDB
  86. HLB0100134 → BC-DB-SDB-SYS → Database Interface/DBMS for MaxDB
  87. HLB0100135 → BC-DB-SDB-UPG → Upgrade with MaxDB
  88. BYI3000091 → BC-DB-SYB → Sybase ASE Database Platform
  89. B200004531 → BC-DB-TD → Teradata database

SAP BC-DB (Database Interface, Database Platforms in Basis) TCODES

See some sample transaction codes used with SAP BC-DB sub module. I have added Full list with details in another tutorial (see the link after this list).

  1. DB2W → DB2 z/OS: Workload Manager Monitor
  2. DB20ORA → Update DB Statistics: Oracle
  3. DBACOCKPIT_SOLMAN → Start DBA Cockpit
  4. DB6FSC → DB6: File System Configuration
  5. LCA02 → LCA Object Tracing
  6. LC11 → Creating the liveCache connection
  7. /SAPAPO/OM19 → liveCache Browser
  8. DB6DBM → DB6: Database Manager Configuration
  9. DB16ORA → Display DB Check Results: Oracle
  10. DB6EXPLAIN → DB6: Explain SQL Statement
  11. LCA04 → Display the Current LCA Version
  12. DB17ORA → Configure DB Check: Oracle
  13. /SAPAPO/OM20 → Profiling
  14. DB6EXL → DB6: Analyze Exclusive Lock Waits
  15. DB14 → Display DBA Operation Logs
  16. View full list of SAP BC-DB tcodes with details