Hi,

I am getting the following problem when trying to compile the SP on DB2
database using the following command.

db2 -td! -f m.db2

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1585N A system temporary table space with sufficient page size does
not
exist. LINE NUMBER=410. SQLSTATE=54048"

I have SMS temporary tablespace with pagesize 4k.

If anybody has any idea about this, please let me know.

Thanks,
Jayaprakash.

DB2 & UDB email list listserv db2-l LazyDBA home page