db2 => list database directory System Database Directory Number of entries in the directory = 5 Database 1 entry: Database alias = MYEJE Database name = MYEJE Local database directory = /home/db2inst1 Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 2 entry: Database alias = DWESAMP Database name = DWESAMP Local database directory = /home/db2inst1 Database release level = c.00 Comment = Ejemplo Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 3 entry: Database alias = DWECTRL Database name = DWECTRL Local database directory = /home/db2inst1 Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 4 entry: Database alias = ALPHABL Database name = ALPHABL Local database directory = /home/db2inst1 Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = Database 5 entry: Database alias = SAMPLE Database name = SAMPLE Local database directory = /home/db2inst1 Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = db2 => /home/db2inst1/sqllib/bnd db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue bash-3.2$ db2 connect to DWESAMP Database Connection Information Database server = DB2/AIX64 9.5.3 SQL authorization ID = DB2INST1 Local database alias = DWESAMP bash-3.2$ db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. bash-3.2$ db2 terminate DB20000I The TERMINATE command completed successfully. bash-3.2$ db2 connect to DWECTRL Database Connection Information Database server = DB2/AIX64 9.5.3 SQL authorization ID = DB2INST1 Local database alias = DWECTRL bash-3.2$ db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. bash-3.2$ db2 terminate DB20000I The TERMINATE command completed successfully. bash-3.2$ db2 connect to ALPHABL Database Connection Information Database server = DB2/AIX64 9.5.3 SQL authorization ID = DB2INST1 Local database alias = ALPHABL bash-3.2$ db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. bash-3.2$ bash-3.2$ db2 terminate DB20000I The TERMINATE command completed successfully. bash-3.2$ db2 connect to SAMPLE Database Connection Information Database server = DB2/AIX64 9.5.3 SQL authorization ID = DB2INST1 Local database alias = SAMPLE bash-3.2$ db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. bash-3.2$ bash-3.2$ db2 terminate DB20000I The TERMINATE command completed successfully. bash-3.2$ db2 connect to MYEJE Database Connection Information Database server = DB2/AIX64 9.5.3 SQL authorization ID = DB2INST1 Local database alias = MYEJE bash-3.2$ db2 bind /home/db2inst1/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. bash-3.2$