https://tech.snathan.org/ 2026-04-24T09:04:42+00:00 https://tech.snathan.org/ https://tech.snathan.org/_media/wiki/dokuwiki.svg text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_creating_database?rev=1416064423&do=diff Created database dbtest login as: db2inst1 db2inst1@ub1's password: Linux ub1 2.6.24-24-server #1 SMP Fri Sep 18 16:47:05 UTC 2009 x86_64 The programs included with the Ubuntu system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. To access official Ubuntu documentation, please visit: http://help.ubuntu.com/ Last login: Sa… text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_install_on_windows?rev=1416064423&do=diff Install Details DAS The DB2 Admin Server (DAS) runs on your computer to provide support required by the DB2 tools. User for DAS is below: UserPassdb2admin*** This is the “Local user” (Not domain user or local system account) Using the same name for the remaining DB2 services text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_min_resources?rev=1416064423&do=diff Minimum resources for db2 Min Req for db2 text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_moving_table_to_different_tablespace?rev=1416064423&do=diff Steps on Ubuntu to move db2 table to a different tablespace FIXME Start the instance as root * /etc/init.d/db2exc start Become db2inst1 user * su db2inst1 Get into command line mode * db2 Run the following commands db2 => connect to dbtest db2 => list tables db2 => create table test01 (a integer not null, b varchar(10), primary key(a)) db2 => create table test02 (x integer not null, y integer not null, z varchar(10), primary key(x,y)) db2 => create view v_test01 as select * from … text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_on_ubuntu?rev=1416064423&do=diff DB2 on Ubuntu Resources db2exc 9.7.0-8 (amd64 binary) in ubuntu hardy db2exc package Ubuntu Server Edition Downloads db2exc_9.7.0.orig.tar.gz 388.0 MiB 215c3fd33ae17c5958e60143a12a2fa7 db2exc_9.7.0-8.diff.gz 13.1 KiB b7e6cdaf7cf16f6f0b1e7f0de9e48979 db2exc_9.7.0-8.dsc 566 bytes 4f92a2e685e4b09de12d18cf08bf506c Steps text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_reference?rev=1416064423&do=diff db2 references Some reference material Show schemas in a database select schemaname from syscat.schemata text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_resources?rev=1416064423&do=diff DB2 resources Leverage your Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows DB2 Version 9.7 for Linux, UNIX, and Windows Administration text/html 2016-10-12T11:25:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/db2_select_dual?rev=1476271549&do=diff DB2 Select from dual Oracle equivalent of dual table in DB2 select CURRENT_DATE from sysibm.sysdummy1; text/html 2014-11-15T15:13:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://tech.snathan.org/tech/db2/finding_version?rev=1416064423&do=diff Command to find the db2 version SELECT service_level, fixpack_num, bld_level FROM TABLE (sysproc.env_get_inst_info()) as A;