I want to add a unique constraint on 3 fields, to only allow the value in the field ONE time. The value will NEVER be the same for anything else. This is the table structure Code: Create Table Employees ( Continue reading Table Constraint
Hi all, I have been trying to figure out what is the difference between following files ../adm/db2start and ..adm/db2star2 ../adm/db2stop and ..adm/db2stop2 db2start and db2stop commands in db2diag.log report ..adm/db2star2 and ..adm/db2stop2 are called so what about ../adm/db2start ../adm/db2stop ? Continue reading Difference between ../adm/db2start and ../db2star2
Dear friends, just for understanding. what happens when my space is going out of space and i do have tons of log files in my “newlogpath” folder that already have been completed. If there is a young offline backup database Continue reading Removing Log files from newlogpath folder
How to do paging in mysql store procedure?? input paramter will be (in pageno INT, IN no_records) result will be for example i pass value 1 and 10 : first 10 records it will show. or 2 and 10 then Continue reading Paging in mysql
Hi Experts, How do I create a table from multiple other tables? All tables have some columns.
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.
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
I have 2 users..U1 and U2………. U1 contains some packages… I want U2 to compile U1 packages……. I have given Execute and debug grants to U2 but it says insufficient privilages and I can not give ‘alter any procedure’ grant Continue reading grant compile to other users package gives insufficient privilages
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?
Hi Experts, I want to create an aggregated or summary level at database level. As my raw data is huge and my raw tables are partitioned into different tables to store such huge amount of data. I want to create Continue reading Table or View