privileged rctl project.max-sem-ids (value 128) exceeded

I got the following message in /var/adm/messages file inside Solaris 10 Global Zone:

Mar 9 17:24:19 servername genunix: [ID 748619 kern.notice] privileged rctl project.max-sem-ids (value 128) exceeded by process 26387 in project 3.

It turns out that the DB2 running on this local zone, is not aware of project settings I made.

So to make it aware, get into the local zone, and do:
prctl -t privileged -n project.max-shm-ids -s -v 4096 -i process 26387
prctl -t privileged -n project.max-msg-ids -s -v 4096 -i process 26387
…

It works now with DB2 database creation after the above changes ..

DB2 “does not have the authority to perform the requested command”

It turns out user used “chown -R instanceUsername:anotherGroupname sqllib”, thus changed lots of permissions.

Tried to reset permission using “/opt/IBM/db2/V9.5/instance/db2iupdt -k instanceUsername”, but still not working after that.

The workaround, per IBM, is to:

1. Uncatalog database;
2. Drop instance;
3. Create instance;
4. Catalog database again;

so as instance owner (note: I got the same error: instance owner does not have authority .. This step can be skipped .. ):
db2 uncatalog database db1
db2 uncatalog database db2

as root:
/opt/IBM/db2/V9.5/instance/db2idrop instanceUsername

/opt/IBM/db2/V9.5/instance/db2icrt -u db2fenc1 instanceUsername

as instance owner:
db2 catalog database db1 as db1
db2 catalog database db2 as db2
db2 terminate

db2fmcu – DB2 fault monitor controller command

As root user:
Stop it: /opt/IBM/db2/V9/bin/db2fmcu -d
Start it: /opt/IBM/db2/V9/bin/db2fmcu -u -p /opt/IBM/db2/V9/bin/db2fmcd