Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cotaurus

    DB2 restore problem without log files

    The backup you are running doesn't seem to be online. For online you would have the ONLINE keyword, therefore use the logs. If that's the case, you may recover with the normal restore command, and as you cannot rollforward, you will have to send the file SQLOGCTL.LFH to IBM (I had this problem...
  2. cotaurus

    Concanate to one row

    The closest approach: db2 &quot;select a.name||' '||a.hobby||', '||b.hobby from table a, table b where a.name=b.name and a.hobby<b.hobby&quot;
  3. cotaurus

    user exit and roll forward

    Your must have the S0000003.LOG file in the active log directory: /home/db2inst1/db2inst1/NODE0000/SQL00007/SQLOGDIR/ Get the backup from your history log file like this: db2 list backup all for <dbname> The output may look like: Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log...
  4. cotaurus

    user exit and roll forward

    Your must have the S0000003.LOG file in the active log directory: /home/db2inst1/db2inst1/NODE0000/SQL00007/SQLOGDIR/ Get the backup from your history log file like this: db2 list backup all for <dbname> The output may look like: Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log...
  5. cotaurus

    user exit and roll forward

    When you took the backup, it probably was using one more log file. You need to put it in the active log directory and issue: db2 rollforward db <dbname> to end of logs db2 rollforward db <dbname> complete or try rollforward to a pit: db2 rollforward db <dbname> to yyyy-mm-dd-hh.mm.ss.nnnnnn...
  6. cotaurus

    Dropped database restore

    You can restore without any skeleton: db2 restore database mytest from <device> taken at <timestamp> if using TSM: db2 restore database mytest taken at <timestamp> use tsm
  7. cotaurus

    create stored procedure failed UDB 7.2 : URGENT HELP needed !!!!!!

    Have you checked your diagnostics file? Look for P1439170.log. There is probably a problem with the C compiler.
  8. cotaurus

    Unique Index and duplicate nulls in DB2

    Thanks for your reply Mr.Blom. The situation is that besides the primary key, I dont want duplicates in the second column, but I can allow nulls. I think I was not clear enough from the beginning. Thanks
  9. cotaurus

    Unique Index and duplicate nulls in DB2

    Hi all. I have a table with two columns, a primary key and the other column must be unique index to avoid duplicate values, but allowing multiple nulls. The unique index in DB2 for UNIX does not allow duplicate nulls. How can I solve this issue? Any ideas using triggers or something...

Part and Inventory Search

Back
Top