Db2

 View Only
  • 1.  db2 11.5.8 SQL5099N error when Restoring db to a new server

    Posted yesterday

    Db2 11.5.8 on Windows 

    Restoring an online bkp into a new server which has different filesystems settings.  (redirect restore) on storage group etc .... 


    Fails with following: 

    restore db noxgr from D:\backup , D:\backup,  D:\backup TAKEN AT 202502 on G: dbpath on G:\ INTO NOXGR  replace existing parallelism 6
    SQL5099N  The value "L:\db2ActiveLogs\DB2\NOXGR\" indicated by the database
    configuration parameter "IMAGELOGPATH" is not valid, reason code "2".
    SQLSTATE=08004

    Yes,  that is the original logpath that only exists at the original server.  

    Why does it requires this path to exist?  it makes no sense ! 

    I've tried also to use LOGTARGET clause at the restore comand, pointing to a valid existing path, but no luck , same error. 

    I'm stuck !  

    Also, Found this trhead in SAP site saying exactly the same ..  but I am not a SAP customer, and can't see the information. 

    3193409 - Db2 LUW: Redirected restore errors with SQL5099N for IMAGELOGPATH | SAP Knowledge Base Article

    IBM need help !!  



    ------------------------------
    Samuel Pizarro
    ------------------------------


  • 2.  RE: db2 11.5.8 SQL5099N error when Restoring db to a new server

    Posted yesterday

    I've managed to overcome this by specifying the NEWLOGPATH clause, and pointing to a valid path at the target system. 

    I've done hundreds of restores like this before, and I never had to specify NEWLOGPATH for this kind of restore..  if the cfg path that is saved within the image does not exist..  why not just use the defaul path for the log files and move on !? 

    IBM ??  

    Regards



    ------------------------------
    Samuel Pizarro
    ------------------------------