DB2 InfoSphere Warehouse 9.7 on Red Hat Linux (previously known as DB2 ESE with DPF feature).

Has anyone used bash shell (default for Linux) on the instance owner when using DPF (InfoSphere Warehouse)? I notice that when I run db2_all it can't find .profile, which doesn't exist with bash shell.

bash reads the profiles in certain sequence, starting with .bashrc, then .profile, then /etc/profile, if I remember correctly (read the bash man page to be sure). It executes the first one it finds and does not search further. I think if invoked as /bin/sh it skips .bashrc for compatibility, so you may want to try creating a symlink to bash, named sh, or create a copy of the bash executable named sh.

That's not what I mean.

The db2_all script that comes with DB2 is a ksh script and it looks for the .profile file on the instance owner directory and can't find it. I could make a .profile file with the same info as bashrc (to invoke the db2profile), but I am also wondering if I am going to run into other problems down the road.

I think you could either rename .bashrc to .profile, and bash will happily find it, or symlink .profile to .bashrc - this way you'll need to maintain only one file. I don't see any problems from that point of view; however, pdksh (I guess that's what you have on Red Hat) is not completely compatible with the AIX korn shell so, depending on what your script is doing, you may run into some problems. For example, getopts behaves a bit differently in functions, which I had a pleasure to discover recently.

I have the ksh.x86_64 package installed, not pdksh.

But at this point I need to find someone who has experience with DPF on Red Hat Linux to know for sure if this is going to work with the bash shell (with a workaround similar to what you suggested).