1,126
edits
m (Moved CMOD to the top.) |
m (Minor changes to troubleshooting DB2 on IBM CMOD.) |
||
| Line 48: | Line 48: | ||
=== IBM DB2 === | === IBM DB2 === | ||
IBM DB2 is provided by default as a 'limited use' license with Content Manager OnDemand at no cost, and as such, is the most popular database for CMOD. DB2 has a concept | IBM DB2 is provided by default as a 'limited use' license with Content Manager OnDemand at no cost, and as such, is the most popular database for IBM CMOD. DB2 has a concept called 'instances', which is like a complete installation of DB2 that is unique and managed at the operating system's user account level. If users Alice and Bob both have accounts on a single server, they can each have their own instance, and that instance is complete and wholly functional and independent of each other. To facilitate this user-level instance, DB2 creates a directory called 'sqllib' inside the user's home directory (in our example, Alice would have /home/alice/sqllib, and Bob would have /home/bob/sqllib). Inside the sqllib directory is the 'db2dump' subdirectory, which contains a file called 'db2diag.log'. It contains the majority of the diagnostic information for DB2. | ||
Log in as the database instance owner, then run these commands: | Log in as the database instance owner, then run these commands: | ||
| Line 57: | Line 57: | ||
Alternately, you can see the last 500 lines of the log with tail: | Alternately, you can see the last 500 lines of the log with tail: | ||
tail -n 500 ~/sqllib/db2dump/db2diag.log # Show the last 500 lines -- may be different on | tail -n 500 ~/sqllib/db2dump/db2diag.log # Show the last 500 lines -- may be different on other Operating Systems! | ||
Or of you want to monitor messages as they're written into the database: | Or of you want to monitor messages as they're written into the file by the database: | ||
tail -f ~/sqllib/db2dump/db2diag.log # Prints new messages as they're added to the log file. | tail -f ~/sqllib/db2dump/db2diag.log # Prints new messages as they're added to the log file. | ||