DB2 gets a reasonable analysis of the current time and has to look at it.

Source: Internet
Author: User

Today we will mainly tell you about the correct parsing of DB2's current time. The following is a detailed description of the main content of the correct parsing of DB2's current time, I hope you will have a better understanding of it after browsing. Modify the password of the DB2 database administrator 11: 27db2 running environment:

Win2003 + db2 v8.1, the db2 administrator set during the installation process, using the administrator (system administrator ).

Get current year month day:

 
 
  1. SELECT current date FROM sysibm.sysdummy1 

Obtain the current hour, minute, and second:

 
 
  1. SELECT current time FROM sysibm.sysdummy1 

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

 
 
  1. 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 an introduction to the current time parsing of DB2. I hope you will get some benefits.

The above content is an introduction to the current time parsing of DB2. I hope you will get some benefits.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.