Page 1 of 1

DB2 basics for a DataStage Developer ????

Posted: Tue Nov 22, 2011 3:15 pm
by Developer9
Hi,

I am new to the mainframe DB2 UDB databases with UNIX

Environment:AIX 5.3 ,putty,command line processor DB2

Putty: I login to DB server(devit) using user name and password

Showed me Database information..(devit)

db2=>? help

1. Hoe to execute commands to view all tables/tablespaces/scmeas in (devit )server??list tables ??
2.what BASIC things to learn/prepare about DB2 TABLES/environment ??


Thanks for sharing ideas and support

Posted: Tue Nov 22, 2011 4:26 pm
by ray.wurlod
In DB2 you need to connect to the database you intend to use.

Most IBM products have an Information Center; DB2 is no exception. You can find out all you need to know and more there.