C:\Program Files\IBM\SQLLIB\BIN>db2 -td DB21002E The parameter for option "-t" specified after the 'db2' command or in the DB2OPTIONS variable is missing or incorrect. C:\Program Files\IBM\SQLLIB\BIN>db2 -td; (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 11.5.8.0 You can issue database manager commands and SQL statements from the command prompt. For example: db2 => connect to sample db2 => bind sample.bnd For general help, type: ?. For command help, type: ? command, where command can be the first few keywords of a database manager command. For example: ? CATALOG DATABASE for help on the CATALOG DATABASE command ? CATALOG for help on all of the CATALOG commands. To exit db2 interactive mode, type QUIT at the command prompt. Outside interactive mode, all commands must be prefixed with 'db2'. To list the current command option settings, type LIST COMMAND OPTIONS. For more detailed help, refer to the Online Reference Manual. db2 => list database list db2 (cont.) => ; SQL0104N An unexpected token "list" was found following "DATABASE". Expected tokens may include: "DIRECTORY". SQLSTATE=42601 db2 => create database test; DB20000I The CREATE DATABASE command completed successfully. db2 => connect to test user db2admin using admin@123; Database Connection Information Database server = DB2/NT64 11.5.8.0 SQL authorization ID = DB2ADMIN Local database alias = TEST db2 => CREATE TABLE Account ( db2 (cont.) => AccountId INTEGER NOT NULL, db2 (cont.) => Branch_Id INTEGER NOT NULL, db2 (cont.) => CustomerId INTEGER, db2 (cont.) => AccountType VARCHAR(10), db2 (cont.) => ProductId INTEGER, db2 (cont.) => AccountOpenDate DATE, db2 (cont.) => AccountWithdrawlLimit INTEGER NOT NULL, db2 (cont.) => AccountCashLimit INTEGER NOT NULL, db2 (cont.) => AccountClosureDate DATE, db2 (cont.) => AccountStatus CHAR(1), db2 (cont.) => CONSTRAINT Account_pk PRIMARY KEY (AccountId) db2 (cont.) => ); DB20000I The SQL command completed successfully. db2 => INSERT INTO Account(AccountId,Branch_Id,CustomerId,AccountType,ProductId,AccountOpenDate, AccountWithdrawlLimit,AccountCashLimit,AccountClosureDate,AccountStatus) VALUES ( '1','1','55','CA','10','01/26/2017','40000','10000',NULL,'A'); DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007 db2 => INSERT INTO Account(AccountId,Branch_Id,CustomerId,AccountType,ProductId,AccountOpenDate, AccountWithdrawlLimit,AccountCashLimit,AccountClosureDate,AccountStatus) VALUES ( '2','1','85','CA','6','02/13/2018','58000','14500',NULL,'A');