Is there a way to track the execution of an ALTER DATABASE SCHEMA FROM FILE command?

We were wondering if we could follow the progress of a database schema update, to alert the user about how much he should wait until the execution is completed.

Ps: We are targeting the iPhone and Android devices.

asked 31 Jan '12, 11:19

Alex's gravatar image

Alex
975153747
accept rate: 25%


I'm afraid the answer is currently no. And it is true that altering columns or creating indexes can take some time when there are a lot of rows.

I suggest you synchronize any pending changes first, then request users patiently wait for the update to complete (possibly ensuring there is enough power available). Unlike a synchronization/network operation, while the alter-database request is active, you can be sure that work is progressing. Given that, it seems appropriate that the UI thread display some kind of "yes, I'm still alive and working" indication.

permanent link

answered 31 Jan '12, 18:01

Tim%20McClements's gravatar image

Tim McClements
1.7k1825
accept rate: 34%

Could I track the progress somehow using the table observers?

(01 Feb '12, 10:34) Alex
Replies hidden

Sorry, not sure what you mean by table observers...

(01 Feb '12, 18:27) Tim McClements
Comment Text Removed

The feature you can use to track modifications in any database object (such tables).
I think the best name is notification (UlConnection.getNotification)

http://dcx.sybase.com/index.html#1201/en/uldotnet/uldotnet-uldnet-ulconnection-cla-getnotification-met.html

(02 Feb '12, 06:58) Alex

Oh yes... we call those events or notifications usually.

But no, currently events will not do what you are asking for here.

(03 Feb '12, 17:46) Tim McClements
Comment Text Removed

Ohn.. ok, but thank you anyway.

(13 Feb '12, 06:15) Alex

Create a stand-in screen or page (depending on whether the system is client-server or http-saas) which tells the user how long the system will be down. In our c-s systems we swap the real main executable with a stand-in executable that displays, for instance, "System down for maintenance and will return at 1200 Pacific." The stand-in executable reads a text file which we can edit to change the time and certain other information. In one of our systems, the database update DDL is contained in a text file. In another system, the DDL is in-line, with product code. I'm not sure how you might give the user an actual real-time, accurate status on the update. The database update process might maintain a field in the database which would contain a progress number and would be read periodically by the stand-in page or executable. I've found that users are satisfied just knowing approximately when their system will be available again.

permanent link

answered 04 Feb '12, 10:06

dejstone's gravatar image

dejstone
959385069
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×131
×75
×22
×20
×10

question asked: 31 Jan '12, 11:19

question was seen: 1,345 times

last updated: 13 Feb '12, 06:15