cemdogan.com

If we want to create a bat file to get a backup of the database;

set username = db2admin
set password = password
db2 CONNECT TO DBADI;
db2 quiesce DATABASE IMMEDIATE FORCE CONNECTIONS;
db2 CONNECT RESET;
DBADI db2 BACKUP DATABASE TO 'D: \ db2yedekdenemesi "with 2 buffers BUFFER 1024 WITHOUT prompting a parallelism;
db2 CONNECT TO DBADI;
DATABASE db2 UNQUIESCE;
db2 CONNECT RESET;

We take if we want to restore a backup using the Command Editor software;

RESTORE DATABASE FROM DBADI d: to c:

That you may need scripts,

VersionNumber select, from version_timestamp sysibm.sysversions; - version to find out
select * from syscat.tabauth; - powers to list
select * from syscat.dbauth where grantee = current user;
select * from syscat.tabauth where grantee = current user;
select current server from sysibm.sysdummy1; - the database name
select from SchemaName syscat.schemata;-List databases
select name from sysibm.systables;-tables, lists

Prepared by using the DB2 Thin-client instead of the ODBC connection is provided using the ODBC connection ZendCoreForIBM garbled characters may be blocked from returning.

To install the license file;

/ Usr/opt/db2_08_01/adm/db2licm-a / cdrom/db2/license/db2dlm.lic