SQL0286N A table space could not be found with a page size of at least 32768

Question: I got this error on MYDB on MYSERVER: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0286N A table space could not be found with a page size of at least "32768" that authorization ID "DB2USER" is authorized to use. SQLSTATE=42727 Answer: You must be attempting to execute a CREATE TABLE statement where the requirement is for a pagesize greater that the tablespace pagesizes available. You could verify this by connecting to the database and running the LIST TABLESPACES SHOW DETAIL command. If... Read more →

ADM11001E DB2 did not create a memory segment for running fenced routines

Question:We are carrying out an application installation. The installation is failing with the following message in the .nfy file . ADM11001E DB2 did not create a memory segment for running fenced routines. This was specified by the use of DB2_FMP_COMM_HEAPSZ registry variable. How can I bypass these errors to allow the installation to finish? Answer: I’ve seen this problem plenty of times where a DBA has set the DB2 registry value : DB2_FMP_COMM_HEAPSZ=0. On many occasions , it is to force fenced routines such as the DB2 Health Monitor :Monitor health of instance and databases to not run. It is... Read more →

How to grant privileges for a windows username on a new schema

Question: I am new to DB2 and have a question about the post SQL0286N A default table space could not be found - DBA DB2 I want to access a database schema from a client on my desktop. However, I am not sure how to grant my windows username to the new schema Answer: On Windows , users and groups in db2 are handled by the OS, use OS tools to find the list of users. You can then use various commands within DB2 to confirm privileges. And execute any GRANT statements This includes local Windows users and Active Directory... Read more →