Re: database restore with ontape -r on Informix Online Dynamic Server
David Williams wrote:
> "Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That
> will make it a lot tidier, should be able to use a case statement.
>
>>I will revise next week sometime.
>>
>
>
> http://www.smooth1.demon.co.uk/ifaq06.htm#6.33
>
> 6.33 What status codes does onstat return?
> On 21st May 1998 mdstock@informix.com (Mark D. Stock) wrote:-
>
> As a point of interest, you can check the current mode of IDS by checking
> the status ($?) after onstat -.
>
> The values returned by 'onstat -' are:
>
> a.. -1 Offline
> b.. 0 Initialisation
> c.. 1 Quiescent
> d.. 2 Recovery
> e.. 3 Backup
> f.. 4 Shutdown
> g.. 5 Online
> h.. 6 Abort
Wow! You remembered! Perhaps I should add some:
Return codes
IDS 7 & 9
-1 Off-line (-1 = 255)
0 Initialisation
1 Quiescent
2 Recovery
3 Backup
4 Shutdown
5 On-line
6 Abort
IDS 8
-1 Off-line (-1 = 255)
0 Initialisation
1 Quiescent
2 Micro kernel
3 Recovery
4 Backup
5 Shutdown
6 On-line
7 Abort
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list