Topic
  • No replies
Валентин
Валентин
2 Posts

Pinned topic DB2 backup error SQL0901N

‏2013-04-18T06:01:58Z |

Hello. If i try to make a backup of an error occurs

SQL0901N The SQL statement failed because of a non system error. Subsequent SQL statements can be processed. (Reason "121".) SQLSTATE = 58004

and no backup is created.

The script backup

force applications all
connect to MYDB user db2admin using pass
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS
CONNECT RESET
BACKUP DATABASE MYDB TO "C: \ dbcopy \" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING
connect to MYDB user db2admin using pass
UNQUIESCE DATABASE
connect reset


Version of DB2 v9.7.400.501. Thanks in advance.