Tips & Tools for db2 dba's & Developers. Making our db2 Data Warehouses easy to Administer and Control.
Tips & Tools for db2 dba's & Developers.Making our db2 Data Warehouses easy to Administer and Control.

Most Common Issues

Issue: The view Utilities errors out message "SQL1585N  A system temporary table space with sufficient page size does not exist.  SQLSTATE=54048"

Solution: Create a new system temporary tablespace with larger than 4K page size. This issue occurs  in newly created databases where only one system temporary tablespace of 4 K page size exists.


Print | Sitemap
db admin tools© db2gdba©