Which of the following tools can NOT be used to catalog a database?
A. Control Center
B. SQL Assist
C. Configuration Assistant
D. Command Line Processor
3 Comments on “Which of the following tools can NOT be used to catalog a database?”
swamysays:
To catalog a database with a different alias name using the command line processor, use the CATALOG DATABASE command.
The Configuration Assistant is for manage DB2® database configuration (Related reference:
CATALOG DATABASE command)
The Control Center interface
Setting DB2 administration tools preferences
Cataloging database systems
In order to access DB2 instances and databases on other servers, DB2 needs to catalog that system in the admin node directory of the client. Adding a system adds an entry to the admin node directory giving DB2 the information it needs to communicate with the remote system. All systems that you access will have an entry in the admin node directory.
0
0
rasays:
SQL Assist is just tool to help you build SQL queries
0
0
Chow, Kenneth KYsays:
SQL Assist
SQL Assist is a graphical tool you can use to build SELECT, INSERT, UPDATE, and
DELETE statements. The tool uses a notebook to help you organize the information
you need to create an SQL statement. SQL Assist is available from multiple tools
and wizards.
SQL Assist makes it really easy for novice users to point and click their way through
query creation and build more complex SQL statements. The next time you query
your database with the Command Editor, or build a view using the Control Center,
invoke the SQL Assist tool to get a feel for how much it can help you. The following
figure shows the SQL Assist tool.
To catalog a database with a different alias name using the command line processor, use the CATALOG DATABASE command.
The Configuration Assistant is for manage DB2® database configuration (Related reference:
CATALOG DATABASE command)
The Control Center interface
Setting DB2 administration tools preferences
Cataloging database systems
In order to access DB2 instances and databases on other servers, DB2 needs to catalog that system in the admin node directory of the client. Adding a system adds an entry to the admin node directory giving DB2 the information it needs to communicate with the remote system. All systems that you access will have an entry in the admin node directory.
0
0
SQL Assist is just tool to help you build SQL queries
0
0
SQL Assist
SQL Assist is a graphical tool you can use to build SELECT, INSERT, UPDATE, and
DELETE statements. The tool uses a notebook to help you organize the information
you need to create an SQL statement. SQL Assist is available from multiple tools
and wizards.
SQL Assist makes it really easy for novice users to point and click their way through
query creation and build more complex SQL statements. The next time you query
your database with the Command Editor, or build a view using the Control Center,
invoke the SQL Assist tool to get a feel for how much it can help you. The following
figure shows the SQL Assist tool.
0
0