Some settings in the Control Center, before I blew it away. System name: rhino Remote instance: inst1 Operating system: AIX Protocol: TCP/IP Protocol parameters: Host name: rhino Service name: 523 Which resulted in UNCATALOG NODE rhino CATALOG ADMIN TCPIP NODE RHINO REMOTE rhino REMOTE_INSTANCE inst SYSTEM rhino OSTYPE AIX ======================================================================== Defining a New Database Asks you where you want to place User Tables System Catalog Tables System Temporary Tables Your choices were either SMS = System-Managed Space (the default and what I took) or DMS = Database-Managed Space - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The Code Set originally gave you only two choices, IBM-1252 (the default) and UTF-8 A db2 get db cfg for patent | grep -i code command on elephant yielded Database code page = 819 Database code set = ISO8859-1 so I changed the default to ISO8859-1. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The resulting command was CREATE DATABASE PATENT ON C: USING CODESET ISO8859-1 TERRITORY US COLLATE USING SYSTEM WITH "Sample Patent Database" which created 71 tables in the SYSCATSPACE table space, all Schema=SYSIBM. Virtually all of this data exists at C:\DB2\NODE0000\SQL00001. There are three tiny files in the C:\DB2\NODE0000\SQLDBDIR directory and the DB2 log at C:\DB2LOG\db2.log (equivalent to /home/inst1/sqllib/db2dump/db2diag.log under AIX). That db2.log file tells me that I have the following 3 products installed, DB2 Personal Edition DB2 Application Development Client DB2 Administration Client (Previously, this was all I had installed) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The installed DB2 Services on my Windows 2000 machine are Started Automatically: Service Name Program Name Under C:\PROGRA~1\SQLLIB\bin ====================== ========================================= DB2 - DB2 db2syscs.exe DB2 - DB2DAS00 db2syscs.exe (yes, the same as above) DB2 JDBC Applet Server db2jds.exe DB2 Remote Command db2rcmd.exe DB2 Security Server db2sec.exe Started Manually: Service Name Program Name Under C:\PROGRA~1\SQLLIB\bin ====================== ========================================= DB2 Governer db2govds.exe DB2 JDBC Applet Server - Control Center db2ccs.exe - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -