Sometime back, I wrote about how to know about a fenced user id in DB2 at The other day, someone asked me how do I change the fenced user id in DB2?

This is very easy but will require an outage if you are already in production. I wonder why there would be a need to change fenced id in production but it might be required at times. Who knows?

Here are the steps:

1. Run db2cfexp command to export settings to a file.


C:\> db2cfexp mydb2instance.txt

It will dump your instance parameters, registry variables, all cataloged nodes, instances, databases, ODBC settings etc to a file.

2. Stop the instance

3. Drop the instance

4. Create the instance with new fenced user id

5. Import the configuration settings (Step-1) using db2cfimp command