Search results

Did you not find what you were looking for? Try the Advanced Search for more precise search options.

89 items matching your criteria.

Re: Select [1%] by perallis, 2009-05-07 10:04: Hello Nair,   See the solution in the link below: How to use DB2 Federation
Re: Performance issue [1%] by perallis, 2009-05-06 14:43: Hello Johan, Could you please provide us your the query and the tables statistics used from your query, such as: number of inserts, number of reads, ...
Re: implementation of table partitioning [1%] by perallis, 2009-05-06 09:01: Hello Pawan, For example, the following statement creates a table where rows with fired ≥  2009-01-01 and fire ≤ 2009-01-31 are in PART 0 (the ...
Re: recent updates on a table? [1%] by perallis, 2009-04-28 15:13: If the updates are DDL updates, see the solution on link below: how-to-know-when-an-alter-table-statement-was-last-executed     
Re: how point-in-time recovery [1%] by perallis, 2009-04-22 11:35: To use recover command see the link below: Using RECOVER command inspite of RESTORE and ROLLFORWARD command
Re: How to upgrade a fix pack in UNIX [1%] by perallis, 2009-04-11 12:16: Hello Pawan,   Follow the steps in the link below: How to install fixpack on DB2
Re: please open forum for mysql [1%] by perallis, 2009-04-11 12:07: Hello Pawan, the Mysql forum has been created.   Thank you for your suggestion !!!   Previously Pawan wrote: Hi, ...
Re: documents related database [1%] by perallis, 2009-03-31 16:12: Documents related with:   - Who uses the database - Politics of Backup, Runstats, Reorg - How the database is monitored - Configurations: IPs, ...
Re: difference among log shipping,mirroring and replication [1%] by perallis, 2009-03-31 15:52: Helow Pawan, below some definitions, see the words in italic to understand the differences:   LOG SHIPPING: Log shipping is a method where ...
Re: db2nodes.cfg error on windows [1%] by perallis, 2009-02-12 14:11: Hello Elder, Edit the db2nodes.cfg file to write the following line: 0 <machine_name> 0 On Windows you can discover the machine name in: My ...
Re: db2 Backup [1%] by perallis, 2009-02-04 07:37: Hello Ramesh, If these schemas are in one tablespace that don't have other schemas you can take a backup to this tablespace and so, you will have a ...
Re: Error in db2 size procedure [1%] by perallis, 2009-01-21 09:28: Hello Kanakarajuy, You don't need to set any parameters to execute this script, but If want, you can set some parameters to extra functions, ...
Re: Error in db2 size procedure [1%] by perallis, 2009-01-20 11:26: Hi Kanakarajuy, You have another option to discover the size of database when this routine doesn't work. Execute the script in the below: ...
Re: Restore is incomplete [1%] by perallis, 2009-01-19 10:36: Your image is ful,incremental, or delta ?
Re: how to install in AIX [1%] by perallis, 2009-01-03 23:40: Hello Kanakarajuy, Please take a llok at this page: http://www.dbatodba.com/db2/db2-udb-v9/how-to-install-db2-v9-5-in-aix
Re: child table and parent tables [1%] by perallis, 2008-12-22 11:16: To check what tables are children from table TAB_A and schema TABS_B, perform the select below: db2 "select substr(TABNAME,1,20),substr(REFTABNAME,1,20) ...
Re: what is command to check dbbkup [1%] by perallis, 2008-12-04 17:44: If you want to check the information from backups you can use: db2 list history backup all for db <db_name> Or you can use: ...
Re: How to declare identity column in db2 [1%] by perallis, 2008-12-04 17:30: Hello kanakaraju.Y, The following is an example of defining an identity column on the CREATE TABLE statement: CREATE TABLE table (col1 INT, ...
Re: How to set priviliges [1%] by perallis, 2008-12-04 17:25: Hello KanaKaraju, First Step - Check the priveliges all users have in a specif table db2 " select substr(GRANTOR,1,40),substr(GRANTEE1,40), ...
Re: How to check the % of backup during the offline backup running [1%] by perallis, 2008-09-30 08:23: Hello Kanakarajuy, Type the following command: db2 list utilities Output: ID = 353578 ...
Re: Binding [1%] by perallis, 2008-09-19 08:39: Prepares SQL statements stored in the bind file generated by the precompiler, and creates a package that is stored in the database. - A DB2 bind ...
Re: Difference between these two commands [1%] by perallis, 2008-09-13 14:26: Hello Kanakarajuy, When you are executing the db2 activate database db_name command, you are allocating all resource necessary(memory, etc) to the database ...
Re: recent updates on a table? [1%] by perallis, 2008-08-08 16:19: cheking ...
Re: column level authorization? [1%] by perallis, 2008-07-28 17:40: Hello Pawan, Yes, you can give access of perticular field, but it is just possible on DB2 Version 9. For a successful import operation into a table ...
Re: reorgchk issue.....with deadlock [1%] by perallis, 2008-07-28 01:06: Pawan, take a look below, if this is your case, please let us know: ONLINE INDEX REORG In SMS mode, online index reorganization and online backup ...
Re: New user creation on linux but not able to access db2 [1%] by perallis, 2008-07-28 01:02: Add the db2profile path in the home directory of the new user $ vi .profile Hello Pawan, You just need to add the db2profile path in the home ...
Re: moving records from one db to another db [1%] by perallis, 2008-06-02 04:01: Pawan, You can export the data from table A and import to the table B for both cases above.
Re: How to Stop One Database Under Single Instance?? [1%] by perallis, 2008-05-12 08:39: Example: db2 connect to sample Database Connection Information Database server = DB2/NT 9.5.0 SQL authorization ID = PERALLIS Local ...
Re: How to Stop One Database Under Single Instance?? [1%] by perallis, 2008-05-12 08:35: Hello Pawan, You do that executing the followings commands: db2 connect to <dbname> Where <dbname> is the database name you desire no ...
Re: Drop database left some settings befind, so create database can't be executed [1%] by perallis, 2008-05-09 18:57: Hello Pawan, Try to drop manually the files related with the old database in the first director. Or Catalog db yourdbname drop db yourdbname ...

« Previous 30 items Next 29 items » 1 [2] 3

DBA to DBA

Personal tools

Search results

Would you like your company to implement gamification into your security awareness program?