Personal tools
You are here: Home
Navigation
Log in


Forgot your password?
 

Search results

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

392 items matching your criteria. RSS Feed
When to use CLEANUP ONLY or CLEANUP ONLY PAGES on REORG Utility [1%] by Perallis, 2009-02-13 15:38
Do you known when to use the option CLEANUP ONLY or CLEANUP ONLY PAGES on REORG Utility ?
When to REORG a table on DB2 [1%] by Perallis, 2009-04-08 09:35
Do you know when you have to reorg your table ?
How to investigate a bad page in table space [1%] by Perallis, 2009-02-13 11:23
ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error" DIA8426C A invalid page checksum was found for page "".
How to check if a backup was executed in a specific day [1%] by Perallis, 2009-02-15 19:35
using sysibmadm.db_history view
How to ckeck the application priority [1%] by Perallis, 2009-02-12 10:55
db2pd -agents | get snapshot for applications
How to find out which log files are required for a table space rollforward operation [1%] by Perallis, 2009-02-10 23:30
use the db2logsForRfwd command to find out which log files are required for a table space rollforward operation
How to drop all tables and Views from a specific schema [1%] by Perallis, 2010-02-01 17:28
dropping all tables and views from a specific SCHEMA, SYSPROC.ADMIN_DROP_SCHEMA
How to restore a database compressed by DB2 in other system [1%] by Perallis, 2009-02-10 21:57
COMPRLIB option
How to list the DB2 products and features installed on your system [1%] by Perallis, 2009-02-10 10:06
where DB2 products are installed on your system and list the DB2 product level with db2ls command
How to put a database in rollforward pending state [1%] by Perallis, 2009-02-10 09:48
The db2rfpen tool is a utility to switch on the database rollforward pending state.
How to check CPU Info [1%] by Perallis, 2009-02-09 11:02
reading the file /proc/cpuinfo to check cpu information: bits, model, Mhz, Cache,etc ...
DB2 Lock Modes [1%] by Perallis, 2009-03-04 15:44
some of the locking modes used by DB2
What are the Restrictions for HADR ? [1%] by Perallis, 2009-02-06 10:21
What are the Restrictions for high availability disaster recovery (HADR)
Tablespace is not avaiable in the HADR Server [1%] by Perallis, 2009-02-06 10:03
If a takeover operation occurs, the new table space that you created is not available on the new primary database. To recover from this situation, restore the ...
How to run a reorg and runstats online [1%] by Perallis, 2009-02-13 15:39
How to allow write on table during the runstats and reorg for indexes
How to Calculate the size of one Table or one Schema [1%] by Perallis, 2011-04-19 14:28
calculating the size of one table and one schema
Script Python to check locks waiting on DB2 [1%] by Perallis, 2009-02-03 14:24
Script to check locks waiting in DB2 Database,this script is can be used transparently as a nagios plugin. Ex: python check_log_usage.py sample user password ...
How to convert milliseconds, seconds, minutes to DATE on DB2 [1%] by Perallis, 2009-02-02 16:31
converting milliseconds, seconds, minutes, days to date on DB2
How to detach a partition in a patitioned table [1%] by Perallis, 2009-05-21 15:15
detaching a specific partition ins a partitioned table
How to attach a new table in a partitioned table [1%] by Perallis, 2009-05-27 14:45
adding a new partition in a partitioned table structure
How to create partitioned tables on DB2 v9 [1%] by Perallis, 2009-07-23 14:03
creating partitioned tables on DB2 v9 to get a lot of benefits
How To's [1%] by Perallis, 2009-01-30 08:06
This topic contains hints and procedures step by step about how to do DBA tasks on MySQL Database.
Problem Resolution [1%] by Perallis, 2009-01-29 18:36
Step-by-Step to fix the SQL Server Databases errors: Errors - Causes - Investigation - Resolution
Script Python to check database connections [1%] by Perallis, 2009-01-28 17:18
Script to check database connections in DB2 Database, this script is can be used transparently as a nagios plug
Python Script to check inserts per second in DB2 Databases V9 [1%] by Perallis, 2009-01-23 16:57
Script to check the rate per second of inserts in db2 databases
How to install fixpack on DB2 [1%] by Perallis, 2009-04-13 19:08
steps to install fixpack on DB2
Python Scripts to DB2 [1%] by Perallis, 2009-01-23 15:44
Python Scripts to execute DB2 Tasks
KSH Script to force all applications from a specified database [1%] by Perallis, 2009-01-23 11:26
When you need to force all applications from just one database,perform this script KSH Script to force all applications from a specified database
Shell Scripts to DB2 [1%] by Perallis, 2009-01-23 11:03
Shell Scripts to execute DB2 Tasks
How to truncate a table [1%] by Perallis, 2010-02-12 11:20
to delete all data from one table in the DB2 remotely
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls