informix中如何用事务？

xuanyuan000000 发表于 2008-01-15 20:37

我想问下informix中如何才能执行事务？我目前是在SE中执行的，xp系统。
1.如果用create database rtsysdb建库，之后执行相关的事务语句会报错。于是想执行ontape之类的命令（cmd中），报错Archive failed - Invalid logging change to rtsysdb。
2.create database rtsysdb with log in"d:/Informix/testrtsysdb.log"，报错Filename must be specified with a full path name。

3sane 发表于 2008-01-15 22:12

回复 #1 xuanyuan000000 的帖子

没有 with log in xxx这种写法的吧？你可以用ontape改，比如ontape -s -U rtsysdb

xuanyuan000000 发表于 2008-01-15 22:26

回复 #2 3sane 的帖子

ontape -s -U rtsysdb
报错Server is in an incompatible state or user authentication failed

xuanyuan000000 发表于 2008-01-15 22:35

回复 #2 3sane 的帖子

刚才的那个错误是还没有启动服务。
D:\Informix>ontape -s -U rtsysdb
Your evaluation license will expire on 2008-06-26 00:00:00
Please enter the level of archive to be performed (0, 1, or 2) 1
Archive failed - Invalid logging change to rtsysdb

-------
D:\Informix>ontape -s -U rtsysdb
Your evaluation license will expire on 2008-06-26 00:00:00
Please enter the level of archive to be performed (0, 1, or 2) 2
Archive failed - Invalid logging change to rtsysdb

------
D:\Informix>ontape -s -U rtsysdb
Your evaluation license will expire on 2008-06-26 00:00:00
Please enter the level of archive to be performed (0, 1, or 2) 0

Please mount tape 1 on \\.\TAPE0 and press Return to continue ...
这里不知道输入什么。

麻烦将详细的情况说下，谢谢！

页: [1]

Chinaunix's Archiver