How to test SQL -911 error while developing COB-DB2 program

Answers were Sorted based on User's Feedback



How to test SQL -911 error while developing COB-DB2 program..

Answer / valmiki1980

1. put autocomit No in spufi and run insert command
2. run the insert command thru cob-db2 program.
this results -911 error

Is This Answer Correct ?    1 Yes 1 No

How to test SQL -911 error while developing COB-DB2 program..

Answer / Anupam Bharati

SQL -911 is a DB2 error indicating that the database manager terminated abnormally. To test this error, you can intentionally cause such an event by executing commands that would overload the system or by manually stopping the database server while the program is running. However, it's important to note that testing SQL errors should be done carefully and within controlled environments to avoid data loss or system damage.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

Is schema the same as database?

1 Answers  


What is a SELECT statement?

1 Answers  


What is difference between isnull and coalesce?

1 Answers  


What is rct?

1 Answers  


What is a synonym? How is it used?

2 Answers  


What is db2 connect?

1 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


What is index in db2?

1 Answers  


When is the skeleton cursor table created?

1 Answers  


What is the difference between spufi and qmf?

1 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


What is the connection string to connect to the DB2 Database ?

1 Answers   MCN Solutions,


Categories