Insert data items into the IBM®
Sametime® Advanced Server database on Linux™ or Windows™ to accommodate new
configuration settings. This task does not affect existing data.
About this task
Using the existing Sametime 8.5.2x Advanced
database requires that you insert items to support configuration changes
for Sametime 9. This
change does not affect existing data.
Note: The DB2® commands used in the following procedure work
with the DB2 Control Center's command editor, which was
discontinued in DB2 10.1. If you are using DB2 10.1 or later, use IBM Data Studio to
insert the data in step x into the database.
Procedure
- Log in to the DB2 server
as the DB2 administrator.
- Start the DB2 command
window by running the following command:
- Windows:
db2cmd
- Linux:
db2
- Connect to the Sametime Advanced database
by running the following command:
db2 connect to STAdvanced_database_name
where STAdvanced_database_name is
the name of the Sametime Advanced
database (the default name is STADV).
- Insert 3 new rows into the ORGCOL.PC_SETTING table by running
the following SQL commands:
INSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES ('admin.only.delete', 3, 'false');
INSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES ('remove.invalid.members', 3, 'true');
INSERT INTO ORGCOL.PC_SETTING (SETTING_NAME,SETTING_TYPE,SETTING_VALUE) VALUES ('wildcard.search.enabled', 3, 'false');
- Close the DB2 command
window by running the following command:
quit