Local time zone for Amazon RDS for Db2 DB instances
The time zone of an Amazon RDS DB instance running Db2 is set by default. The default is Coordinated Universal Time (UTC). To match the time zone of your applications, you can set the time zone of your DB instance to a local time zone instead.
You set the time zone when you first create your DB instance. You can create your DB instance by using the Amazon Web Services Management Console, the RDS API, or the Amazon CLI. For more information, see Creating a DB instance.
If your DB instance is part of a Multi-AZ deployment, then when it fails over, its time zone remains the local time zone that you set.
You can restore your DB instance to a point in time that you specifiy. The time appears in your local time zone. For more information, see Restoring a DB instance to a specified time.
Setting the local time zone on your DB instance has the following limitations:
-
You can't modify the time zone of an existing RDS for Db2 DB instance.
-
You can't restore a snapshot from a DB instance in one time zone to a DB instance in a different time zone.
-
We strongly recommend that you don't restore a backup file from one time zone to a different time zone. If you restore a backup file from one time zone to another, then you must audit your queries and applications for the effects of the time zone change.
Available time zones
You can use the following values for the time zone setting.
| Zone | Time zone |
|---|---|
|
Africa |
Africa/Cairo, Africa/Casablanca, Africa/Harare, Africa/Lagos, Africa/Luanda, Africa/Monrovia, Africa/Nairobi, Africa/Tripoli, Africa/Windhoek |
|
America |
America/Araguaina, America/Argentina/Buenos_Aires, America/Asuncion, America/Bogota, America/Caracas, America/Chicago, America/Chihuahua, America/Cuiaba, America/Denver, America/Detroit, America/Fortaleza, America/Godthab, America/Guatemala, America/Halifax, America/Lima, America/Los_Angeles, America/Manaus, America/Matamoros, America/Mexico_City, America/Monterrey, America/Montevideo, America/New_York, America/Phoenix, America/Santiago, America/Sao_Paulo, America/Tijuana, America/Toronto |
|
Asia |
Asia/Amman, Asia/Ashgabat, Asia/Baghdad, Asia/Baku, Asia/Bangkok, Asia/Beirut, Asia/Calcutta, Asia/Damascus, Asia/Dhaka, Asia/Hong_Kong, Asia/Irkutsk, Asia/Jakarta, Asia/Jerusalem, Asia/Kabul, Asia/Karachi, Asia/Kathmandu, Asia/Kolkata, Asia/Krasnoyarsk, Asia/Magadan, Asia/Manila, Asia/Muscat, Asia/Novosibirsk, Asia/Rangoon, Asia/Riyadh, Asia/Seoul, Asia/Shanghai, Asia/Singapore, Asia/Taipei, Asia/Tehran, Asia/Tokyo, Asia/Ulaanbaatar, Asia/Vladivostok, Asia/Yakutsk, Asia/Yerevan |
|
Atlantic |
Atlantic/Azores, Atlantic/Cape_Verde |
|
Australia |
Australia/Adelaide, Australia/Brisbane, Australia/Darwin, Australia/Eucla, Australia/Hobart, Australia/Lord_Howe, Australia/Perth, Australia/Sydney |
|
Brazil |
Brazil/DeNoronha, Brazil/East |
|
Canada |
Canada/Newfoundland, Canada/Saskatchewan |
|
Etc |
Etc/GMT-3 |
|
Europe |
Europe/Amsterdam, Europe/Athens, Europe/Berlin, Europe/Dublin, Europe/Helsinki, Europe/Kaliningrad, Europe/London, Europe/Madrid, Europe/Moscow, Europe/Paris, Europe/Prague, Europe/Rome, Europe/Sarajevo, Europe/Stockholm |
|
Pacific |
Pacific/Apia, Pacific/Auckland, Pacific/Chatham, Pacific/Fiji, Pacific/Guam, Pacific/Honolulu, Pacific/Kiritimati, Pacific/Marquesas, Pacific/Samoa, Pacific/Tongatapu, Pacific/Wake |
|
US |
US/Alaska, US/Central, US/East-Indiana, US/Eastern, US/Pacific |
|
UTC |
UTC |