The Database Utility Use. The database utility is the interface between the ABAP Dictionary and the relational database underlying the SAP system. The database utility allows you to edit (create, delete and adjust to changes to their definition in the ABAP Dictionary) database objects derived from objects of the ABAP Dictionary. If running a 64-bit version of Windows, the Nucleus Database Utility will be in Program Files (x86) Daktronics Nucleus Server Database Utility. The database backup includes all data files and content for M3 widget, it may take several minutes if the system has many files.
Database Utility
By Sailaja Tadikonda
Introduction:
The database utility is a tool to provide the interface between the ABAP Dictionary and the underlying database management system (DBMS).
Content moved to parent page! Sap; utility; database; abap; options; Overview. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering corrupted databases. Although you can run the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 3.x and 4.x, Jetcomp.exe may be able to recover some databases that these utilities cannot.
Uses:
a)Convert Data (I.e. change field lengthsand data types etc)
b)Activate Objects
c)Create/Delete/Change of tables and indexes
Approach:
Go to Transaction SE14
The Initial screen of database utility is displayed. Enter Name of either table/view/Match code/Pool/Cluster tables
I given table name as “ZDATA_UTL”
Choose Edit button or Enter Key.
Next screen will be displayed as below.
Indexes: It will display the list of indexes that are created for this table
Microsoft Database Utility
Processing Type:
The DB Utility can be run either online or in the background.
A)Direct:the create/delete/modify operations of the object will be performed in foreground.
B)Background:the create/delete/modify operations of the object will be performed in background
Database Utility Manager
C)Enter for Mass processing:
If you want to modify large no of objects, choose this option.
If you run DB Utility, a log file gets created which contains information on whether or not the conversion was successful and the point of failure during the conversion if it was not successful.