Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I retrieve the current time and date via a DB2 command?

April 26, 2017Command db2 time

0

Posted

How do I retrieve the current time and date via a DB2 command?

1 Answer

0

Posted

Run the following commands from a DB2 command line window For the current time: $ db2 values current time 1 ——– 14:52:46 1 record(s) selected. For the current date: $ db2 values current date 1 ———- 04/10/2008 1 record(s) selected. For the current timestamp: $ db2 values current timestamp 1 ————————– 2008-04-10-14.53.02.562000 1 record(s) selected. C.14 I issued an alter table statement to extend the size of my tablespace containers and the DB2 re-balancer kicked in. Is there a way to find out information on progress of the re-balancer, like the number of extents remaining ? You can issue a db2 list utilities show detail command to see the status of the re-balancer. db2 list utilities show detail ID = 1 Type = REBALANCE Database Name = SAMPLE Partition Number = 0 Description = Tablespace ID: 6 Start Time = 05/05/2008 01:22:36.014403 Throttling: Priority = Unthrottled Progress Monitoring: Estimated Percentage Complete = 61 Total Work = 101 extents Completed Wo