And applications with transparent installed IBM DB2 Universal Database Express Edition

August 2nd, 2008 admin Posted in IBM DB2 No Comments »

  : 


DB2 basic commands

August 1st, 2008 admin Posted in IBM DB2 No Comments »

  1.    Database launched 
db2start
  2.    Stop database 
db2stop
  3.    Connecting to the database 
  db2 connect to o_yd user db2 using pwd 
  4.    Reading database…


Add sql server database approach – Li

August 1st, 2008 admin Posted in IBM DB2 No Comments »

  http://www.chineseco.com/demo/sql_append.swf 

  1.   In SQL Server Management Studio Object Explorer, to connect to Microsoft SQL Server database engine example, to start the instance. 

  2.   Right-click on the "database", pointing to "mandate",…


DB2 need to connect the memory space (in English)

August 1st, 2008 admin Posted in IBM DB2 No Comments »

  Number of clients connecting to a server Memory space needed 
  10 concurrent connections 80 MB 
  25 concurrent connections 96 MB 
  50 concurrent connections 186 MB 
  DB2 UDB Administration Tools 30 MB 


Oracle database: NOARCHIVELOG mode resume sample

August 1st, 2008 admin Posted in IBM DB2 No Comments »

  Full database recovery: NOARCHIVELOG mode 
  1. Disable the automatic closure of databases and archives.    The routines and start loading the database.    The database is set to NOARCHIVELOG…


DB2 V71 OLAP features on the use of

July 28th, 2008 admin Posted in IBM DB2 No Comments »

  IBM DB2 UDB V7.1 for Winows NT/2000 there is no common reporting tool, but the installation of DB2 OLAP Starter Kit, can create a multidimensional database, and then use Microsoft Excel 97/2000 or Lotus 1-2-3 access multi-dimensional database The data and use Excel


DB2 system commands and configuration parameters Daquan

July 27th, 2008 admin Posted in IBM DB2 No Comments »

  DB2 system orders 
  dasauto – automatically activate the DB2 server management 
  dascrt – create a DB2 server management 
  dasdrop – remove DB2 server management 
  dasmigr – DB2 migration management server …


The use of DB2 Visual Studio 2005 Add-in with the Notes to the decomposition of XML schema

July 27th, 2008 admin Posted in IBM DB2 No Comments »

  Notes with the XML model of decomposition in the DB2 ® 9 in the introduction, which can be the whole of XML documents or fragments of XML documents to the decomposition of relations in the table.    DB2 9 XML decomposition of the use of XML technology in the mode of the Notes…


Understanding DB2 study notes 3

July 24th, 2008 admin Posted in IBM DB2 No Comments »

  DB2 environment 

  Instance (1): in Instance in DB2 to provide an…


DB2 environment variable settings

July 23rd, 2008 admin Posted in IBM DB2 No Comments »

  DB2 environment from the following components: 

  1 DB2 profile registry: db2set.    Role is to set up unified approach DB2 environment, making many of the key factors can be controlled centrally managed. 

  2 operating system environment variables:…