db2 strip

The STRIP environment product of the string scalar function added by DB2 V9: DB2 UDB platform: Linux Unix Windows Version: V9 V9.5 the problem starts from DB2 V9 and a new string scalar function STRIP is added, it is convenient for developers to

BKJIA exclusive Article: First of all, this article is not a detailed list of new features of DB2 9.7. I only list a list that is very important to DBAs or developers. Online solution Modification Please refer to Burt's article on online solution

The shell script is used to export the DB2 database table to a file, and in another blog post, Java code calls the shell script and passes in the parameter implementation DB2 database table export to a file to invoke the script and pass in the

Several Common commands are mentioned in the previous article, but they are rarely found on many websites.   This article focuses on the DB2 tablespace, because in the system I will frequently operate 16 tables and my business data table tablespace

The shell script is used to export the DB2 database table to a file, and in another blog post, Java code calls the shell script and passes in the parameter implementation DB2 database table export to a file to invoke the script and pass in the

1. Install Ubuntu 12.04 In the VM2. Set the IP address in the same segment as the local machine and ping the IP address.If the Windows host and Ubuntu virtual machine can communicate with each other, they must be in the same network segment, while

DB2 built-in functions are really a lot, it is almost impossible to master each function, so this article is not intended to describe the specific use of each function, but rather to provide an overview of the functions of each function, so that

Stripe technology is a widely used I/O load balancing technology, can greatly improve I/O performance without additional hardware input. However, in an environment where this technology is used, only the I/O processing of the database and operating

Table space management, creation, and maintenance1 storage physical structure Datapage data page is the minimum storage structure of db2: 4 kb, 8 KB, 16 KB, 32 KB The minimum storage structure of the operating system is block: windows Minimum kb,

Dim objconnection ' Connection object instanceDim objRecordSet ' Recordset object instanceDim objcommand ' Command object instanceDim strconnectionstring ' connection string ' ********************************************************************'