WhatsApp Messenger: Android

Hey, I just downloaded WhatsApp Messenger on my Android. It is a Smartphone Messenger which replaces SMS. This app even lets me send pictures, video and other multi-media! WhatsApp Messenger is available for Android, iPhone, Nokia and BlackBerry and there is no PIN or username to remember – it works just like SMS and uses your internet data plan. Get it now from http://www.whatsapp.com/download/ and say good-bye to SMS.

Partition table MyISAM vs InnoDB

Benchmark partition table with MyISAM & InnoDB engine

Partitions table with MyISAM:
Load data 1.000.000 rows
mysql> call load_test_part_myisam();
Query OK, 1 row affected (57.69 sec)

mysql> select count(*) from test_part_myisam where c3 > date ’2000-01-01′ and c3 < date '2000-12-31';
+———-+
| count(*) |
+———-+
| 99681 |
+———-+
1 row in set (0.10 sec)

Partitions table with InnoDB:
Load data 1.000.000 rows
mysql> call load_test_part_innodb();
Query OK, 1 row affected (1 hour 11 min 25.19 sec)

mysql> select count(*) from test_part_innodb where c3 > date ’2000-01-01′ and c3 < date '2000-12-31';
+———-+
| count(*) |
+———-+
| 99681 |
+———-+
1 row in set (0.22 sec)

Export & Load some table in DB2

How can I export / Import some table in DB2 on command prompt

C:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

exp / imp some table in Oracle

How can I export / Import some table in Oracle on command prompt

C:\Documents and Settings\david>exp ods0_mart_postpaid/ods0_mart_postpaid@cognos file=dim_region.dmp tables=dim_region log=dim_region.log

Export: Release 10.2.0.1.0 – Production on Mon Jul 5 17:12:42 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Data Filtering current_date -7 days

I run query REFRESH TABLE DEV.MQT_AAA_APN_D_H7 on the sql tools such as toad is running well but i get errors when refresh table on db2 console.

This query MQ tables (MQT_AAA_APN_D_H7):
select DAY_ID, PRODUCT_ID, HIT, sum(sendkbytes) as SENDKBYTES, sum(receivekbytes) as RECEIVEKBYTES
from DEV.aaa_apn_d_t
WHERE day_id > cast(replace(char(current_date - 7 days),'-','') as integer) group by DAY_ID,PRODUCT_ID;

Limit the number of rows in DB

How can I limit the number of rows in DB2, MySQL, Oracle, SQL Server

in Oracle:
SELECT * FROM Table_Name where rownum <= 5

in DB2:
SELECT * FROM Table_Name fetch first 5 rows only

in MySQL:
SELECT * FROM Table_Name limit 5

in SQL Server:
SELECT TOP 5 * from Table_Name

hopefully useful…

Create Catalog to connect DB2 server

The following command is how to Create Catalog in DB2

C:\Program Files\IBM\SQLLIB\BIN>db2 catalog tcpip node DEV_NODE remote 10.22.199.22 server 50000

C:\Program Files\IBM\SQLLIB\BIN>db2 catalog database DEV_DB as DEV_DB at node DEV_NODE authentication server

How to check DB2 Status

pada level OS bisa dicek dengan command:
$ ps -ef |grep db2

pada DB2 prompt:
$ db2 connect to bcudb user bcuaix using passwd
Database Connection Information
Database server = DB2/AIX64 9.5.1
SQL authorization ID = BCUAIX
Local database alias = BCUDB

How to create a self-signed SSL Certificate

The following command steps I did to generate  SSL Certificates on AIX Version 5.3!

Step 1: Generate a Private Key
openssl genrsa -des3 -out server.key 1024

Step 2: Generate a CSR (Certificate Signing Request)
openssl req -new -key server.key -out server.csr

SQL0668N Operation not allowed for reason code “x” on table

When you loading all database with db2move command, propably most of the tables being loaded are in pending state. To check which ones, execute SQL statement:

SELECT tabname,status,const_checked FROM syscat.tables WHERE status=’C’
This command will list all tables in pending state

Reson code:

* “1″ – table is in pending state – to fix this execute
SET INTEGRITY FOR table_name IMMEDIATE CHECKED

* “3″ – previous load operation on this table failed. You have to terminate or restart previous load command

source: http://www.dbforums.com/6464822-post1.html