Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Danny Wright — — source: IIUG Forums & Mailing Lists
I have an instance where dbexport (dbexport system
-ss) hangs. (AIX 4.3; Informix 7.24.UC7)
The system.sql appears to have everything in it except the UPDATE STATS
statements....
onstat -u shows this line:
5003f0d4 Y--P--- 2715 azit-dw - 5047a248 0 1 25526 0
onstat -s doesn't show any latches
onstat -k shows this:
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
30114538 0 5003f0d4 0 HDR+X 100002 220 0
1 active, 300000 total, 65536 hash buckets
onstat -g sql 2715 shows it's running the following SQL statement:select data , seqno from informix . sysprocbody where procid = ? and datakey ='T' order by seqno
I ran every oncheck command I could think of to see if I could find anything
wrong, but everything looked okay. It always hangs at this point.
Any ideas?
And have all your stored procedures written out
successfully?
From: "Danny Wright" <dwright@sherwoodfoods.com>
>
>I have an instance where dbexport (dbexport system -ss) hangs. (AIX 4.3;
>Informix 7.24.UC7)
>
>The system.sql appears to have everything in it except the UPDATE STATS
>statements....
>
>onstat -u shows this line:>
>5003f0d4 Y--P--- 2715 azit-dw - 5047a248 0 1 25526 0
>
>onstat -s doesn't show any latches
>onstat -k shows this:>
>Locks
>address wtlist owner lklist type tblsnum rowid key#/bsiz
>30114538 0 5003f0d4 0 HDR+X 100002 220 0
> 1 active, 300000 total, 65536 hash buckets
>
>onstat -g sql 2715 shows it's running the following SQL statement:>
> select data , seqno from informix . sysprocbody where procid = ? and> datakey = 'T' order by seqno
>
>I ran every oncheck command I could think of to see if I could find
>anything wrong, but everything looked okay. It always hangs at this point.
>
>Any ideas?
>
_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.