Appendix B. Use of Uppercase Versus Lowercase in DB2

Table B.1 identifies which kinds of commands, parameters, objects, and data are case-sensitive in DB2 UDB for Linux, UNIX, and Windows and gives examples.

Table B.1. Table B.1 Case-Sensitivity Requirements in DB2
CategoryDescriptionExamples
DB2 system commands (including the db2 executable)You can treat DB2 system commands like any other program or application launched from the operating system.

On Windows, the case does not matter.

On Linux and UNIX, the case does matter, and since all DB2 system commands are named in lowercase, you need to issue the commands in lowercase.		These work in Linux, UNIX, and Windows: 
								db2
								db2start
								db2ilist
These only work in Windows: 
								dB2
								db2STARt
								DB2ILIST
CLP commands ...

Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial