DB2 gets the correct parsing of the current time for the classic edition!

This article describes how to correctly parse the current time of DB2. The following article will provide you with a correct resolution solution for obtaining the current time of DB2, the following is a detailed description of the related content of the correct resolution solution obtained by DB2 for the current time. I hope it will help you in this regard.

Modify the password of the db2 database administrator 11: 27db2 running environment: win2003 + db2 v8.1. the db2 administrator set during the installation process uses the administrator (system administrator ).

Get current year month day:

 
 

  
  
SELECT current date FROM sysibm.sysdummy1 
 
 

Obtain the current hour, minute, and second:

 
 

  
  
SELECT current time FROM sysibm.sysdummy1 
 
 

Obtain the current year, month, day, hour, minute, and second:

 
 

  
  
SELECT current timestamp FROM sysibm.sysdummy1 
 
 

Modify the password of the db2 database administrator 11: 27db2 running environment: win2003 + db2 v8.1. the db2 administrator set during the installation process uses the administrator (system administrator ).

Problem: Because the administrator password is too simple, it is not safe for the system and you want to change the password.

Steps:

1. Modify the logon password of administrator.

2. "Start"-> "Administrative Tools"-> "service"-> right-click "DB2-DB2-0" (db2 service name) select "properties"> "Log on" in the displayed window"

". \ Administrator" is found in this account, and then enter the password to be modified in the box after "password" and "Confirm Password.

 

The above content is the description of the current time parsing for DB2, hoping to help you in this regard.