db2 SET CURRENT OPTIMIZATION PROFILE = DB2INST4.
PROFIL1

SQL0104N  An unexpected token "OPTIMIZATION" was found following "CURRENT".
Expected tokens may include:  "DEGREE".  SQLSTATE=42601

Database Connection Information

 Database server        = DB2/6000 8.2.9
 SQL authorization ID   = DB2INST4
 Local database alias   = IM_0609


C:\Program Files\IBM\SQLLIB\BIN>db2 IMPORT FROM profilOptimFileOfImport.txt OF D
EL MODIFIED BY LOBSINFILE INSERT INTO SYSTOOLS.OPT_PROFILE
SQL3109N  The utility is beginning to load data from file
"profilOptimFileOfImport.txt".

SQL3110N  The utility has completed processing.  "1" rows were read from the
input file.

SQL3221W  ...Begin COMMIT WORK. Input Record Count = "1".

SQL3222W  ...COMMIT of any database changes was successful.

SQL3149N  "1" rows were processed from the input file.  "1" rows were
successfully inserted into the table.  "0" rows were rejected.


Number of rows read         = 1
Number of rows skipped      = 0
Number of rows inserted     = 1
Number of rows updated      = 0
Number of rows rejected     = 0
Number of rows committed    = 1


C:\Program Files\IBM\SQLLIB\BIN>db2set db2_optprofile=YES

C:\Program Files\IBM\SQLLIB\BIN>db2 SET CURRENT OPTIMIZATION PROFILE = DB2INST4.
PROFIL1
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "OPTIMIZATION" was found following "CURRENT".
Expected tokens may include:  "DEGREE".  SQLSTATE=42601

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "OPTIMIZATION" was found following "CURRENT".
Expected tokens may include:  "DEGREE".  SQLSTATE=42601