Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Smile Unanswered: ERROR OCCUR when connect to db

    Hi,

    Am getting these error when i connect the DB. Can you give the solution for this

    >db2 connect to db3_test

    SQL0752N Connecting to a database is not permitted within a logical unit of
    work when the CONNECT type 1 setting is in use.



    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Well, as the error message says, complete the active unit of work (transaction) by committing it or rolling it back.

  3. #3
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Smile

    Hi,
    see am getting these error.

    C:\Program Files\IBM\SQLLIB\BIN>db2 connect to db3_test
    SQL1119N A connection to or activation of database "DB3_TEST" cannot be made
    because a previous restore is incomplete or still in progress. SQLSTATE=57019

    C:\Program Files\IBM\SQLLIB\BIN>db2 commit work
    SQL1024N A database connection does not exist. SQLSTATE=08003

    C:\Program Files\IBM\SQLLIB\BIN>db2 rollback
    SQL1024N A database connection does not exist. SQLSTATE=08003

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by sowndharya View Post
    Hi,
    see am getting these error.

    C:\Program Files\IBM\SQLLIB\BIN>db2 connect to db3_test
    SQL1119N A connection to or activation of database "DB3_TEST" cannot be made
    because a previous restore is incomplete or still in progress. SQLSTATE=57019
    Look up the details of this message in the manual and see what it says. The PDF manual is DB2 Message Reference Vol 2, or you can search using InfoCenter. Make sure you have the right version of manual for your DB2 version.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •