How can I change the default schema for my user account on a DB2 database? Currently, my default schema is my user schema, and I have to run "set schema 'BLAH'" every time I log in to the server. I want 'BLAH' to be my default schema.

If you have DB2 LUW 9.7, you can create a stored procedure that checks the current user and if it is the one for your account, then you can execute the set schema command. The stored procedure will be executed every time anyone logs on to the database if the SP is specified in this db cfg parm:

Connect procedure (CONNECT_PROC) = XXX.XXXXXXXXX

You can configure it in the db2-client you are using (i.e. db2cli.cfg: DB2 Database for Linux, UNIX, and Windows )
or as a parameter in the java/jdbc connect or in the perl/DBI connect.
You never have to code it in your application.

or create a user BLAH on OS and loggin from tht to db.

regds
Paul