Create New Users

Hello, I must create more 2 users(DBA) in my main instance. Actually I access my databases with a single instance user. How can I add more users with DBA profile to access the instance. SO AIX 6.1 DB2 V9.7 Regards.

Posted in SQL

online reorg in place steps

Db2level 9.7.10 Do indexes get reorg’d during an online reorg like a traditional offline reorg. I can’t find anything that explicitly states that indexes are reorg’d during on ONLINE reorg. Thanks, james

Posted in SQL

" Mysql error: Could not load database file"

I get this error: “Error: Could not load database file mysql!” My configfile looks like like this: CODE: SELECT ALL // DB define(‘DB_DRIVER’, ‘mysql’); define(‘DB_HOSTNAME’, ‘localhost’); define(‘DB_USERNAME’, ‘s12587xxxxxx’); define(‘DB_PASSWORD’, ‘xxxxx’); define(‘DB_DATABASE’, ‘db125874xxxxx’); define(‘DB_PREFIX’, ”); Any idea?

Posted in SQL