I have this weird issue when wanting to use a alter index command . see below. I cannot get it to work. Please help.
db2 -tvf another.sql
connect to dbe
Database Connection Information
Database server = DB2/AIX64 9.7.4
SQL authorization ID = DB2DBE
Local database alias = DBE
ALTER INDEX "SAPDBE "."SLGSK~0" COMPRESSION YES
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 "COMPRESSION" was found following ""SAPDBE
"."SLGSK~0"". Expected tokens may include: "COMPRESS". SQLSTATE=42601