Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to enable database logging?

Status
Not open for further replies.
carstos2000

carstos2000

Programmer
Mar 1, 2008
1
RO
Hello all,

I have imported a database and each time I want to execute a stored procedure I get: Error: Transaction not available. I searched for this error and it seems I must have logging enabled. Can you please tell me how to do that? I am running Informix Dynamic Server Express Edition on Windows.

Thanks all.
 
Sort by date Sort by votes
use ontape to set logging mode ontape -s -U dbname
 
Upvote 0 Downvote
forgot to mention I'm using IDS on an AIX box so I'm not sure how you'd accomplish ontape -s -U dbname on a Windows server ... sorry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

daYorkie
  • Locked
  • Question
How many UNIONs can i use in a single query?
Replies
2
Views
377
daYorkie
daYorkie
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
370
jamescpp
jamescpp
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
360
arunkumar.ceg
arunkumar.ceg
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
364
kray4660
kray4660
chongseng
  • Locked
  • Question
How to using informix 4gl send email?
Replies
1
Views
257
chongseng
chongseng

Part and Inventory Search

Sponsor

Back
Top