You can manage your database by creating and deleting database schemas.
Use the To run this application, simply type The syntax of the command follows:
where:
Managing Your Database
Creating a Database Schema
lc_create_schema
application to create the database table definitions used by Log Central to store message data. These tables are shown in detail in Appendix E, "Database Schema." The initialization file msg_processor.ini
contains information about connecting to the database. This file is described in detail in Appendix F, "Initialization File."
lc_create_schema
on the Central Host.
lc_create_schema [-inifile
inifilename
]
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
If an error occurs, or the script called by the application aborts, run the lc_drop_schema
application to clean up files that may have been created, correct the problem, and recreate the schema.
Use the lc_drop_schema
application to drop the Log Central database schema. You might want to do this because the script called by the lc_create_schema
application aborted. If so, ignore all error messages generated by lc_drop_schema
, since it may try to drop tables and synonyms that were not yet created. You might also run the lc_drop_schema
application before reinstalling Log Central.
The syntax of the command follows:
lc_drop_schema [-inifileinifilename
]
where:
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
You might wish to partition the Log Central database, separating various messages (such as NT events, Oracle messages, BEA TUXEDO messages, and so on) into different categories. These categories represent a resource that generates messages; these resources are known as subsystems. Every message has two unique attributes, message ID and subsystem. You can create, add, or drop subsystem entries, and delete subsystems within Log Central, using the subsystem_create
and subsystem_delete
commands.
Use the subsystem_create
application to create subsystem entries in the Log Central database. The syntax of the command follows:
subsystem_create -ssubsystem_name
[subsystem_name
]
-dsubsystem_description
[-inifileinifilename
]
where:
subsystem_name
subsystem_description
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
An example follows:
subsystem_create -s ORACLE -d "Oracle Database Alert Log"
Note: If you wish only to modify the subsystem description, use the message definition editor. Modifying the subsystem description is described in Chapter 9, "Using the Log Central Console."
Use the subsystem_delete
application to delete a subsystem entry from the Log Central database from the command line. All the message definitions for the specified subsystem are also deleted; however, the Log Central messages for the specified subsystem not deleted. The syntax of the command follows:
subsystem_delete -ssubsystem_name
[subsystem_name
]
[-inifileinifilename
]
where:
subsystem_name
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
An example follows:
subsystem_delete -s ORACLE
Log Central provides a number of commands for creating and deleting users, modifying user password, and listing available users found in the Log Central database.
Use the lc_user_create
application to create a new user in the Log Central database. The syntax of the command follows:
lc_user_create -uusername
-ppassword
[-inifileinifilename
]
where:
username
password
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
An example follows:
lc_user_create -u simpson -p simps0n
Use the lc_user_delete
application to delete a user from the Log Central database. The syntax of the command follows:
lc_user_delete -uusername
-ppassword
[-inifileinifilename
]
where:
username
password
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
An example follows:
lc_user_delete -u simpson -p simps0n
Use the lc_user_modify
application to modify a user password in the Log Central database. The syntax of the command follows:
lc_user_modify -uusername
-poldpassword
-nnewpassword
[-inifileinifilename
]
where:
username
oldpassword
newpassword
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."
An example follows:
lc_user_modify -u simpson -p simps0n -n s1mps0n
You can use the lc_user_list
application to list all the users in the Log Central database. The syntax of the command follows:
lc_user_list [-inifileinifilename
]
where:
inifilename
msg_processor.ini
is used. The initialization file is described in detail in Appendix F, "Initialization File."