Performance: DB2 Redirect Restore vs Optim Extracts and Loads

I'm using Optim Test Data Management to populate over 12 test systems with masked data. The product works great.There are two more systems that require a direct clone of production. Traditionally this is done by a DB2 redirect restore which only takes a couple of hours. Q: What's the difference in p ...

db2's restore practice procedures

If my AIX system failure, and db2 on the system.daily backup is OK.What is the restore procedure ? just focus on the step by step procedure.such as:Step 1: recovery the system hardwareStep 2: recovery the OSStep 3:...any body can help me! ...

db2 backup/restore problem

I installed DB2 7.2 PE on Windows 2000 and do the following test:1. db2sampl2. db2 create table test (a int)3. db2 insert into test(100)4. db2 backup db sample5. db2 update db cfg for sample using logretain on6. db2stop7. db2start8. db2 backup db sample online9. db2 update db cfg for sample using tr ...

Problem with DB2 redirect restore

I have the same problem as sosdb:http://www.dbforums.com/archive/inde...t-1218647.htmlAIX 5.3, DB2 UDB 8.2 Fixpak 11I want to change tablespace containers from files to RAW devices via a redirect restore.db2 restore db AAA from /backup/20070429AAA/ replace existing redirect without rolling forward;d ...

DB2 Backup/restore issue

Can you restore a DB2 database just from its backup file.....i.e. i have backed up a database so i have the backup file DB.0.db2inst.NODE0000.CATN0000.20070507030007.001now i delete the databasecan i just restore the database using this file and nothing else...is it possible???? ...

problems with db2 catalog/restore

Some background - Last night I applied fix pack 16 for db2 8.1. My current version was 8.1.1.56 and the new version was 8.1.1.144. Needles to say my application had problems and I was informed by the vendor that they only support upto fix pack 12. I restored the system with the mksysb I took prior t ...

DB2 on AIX - DPF

Hi, we mainly use command line to interact/administer db2 except the schedule jobs via cron for the housekeeping etc.Could someone advise is there a better way of interacting with db2 other than the comand line in db2 with DPF. I tried the control center but to change the partitions still one needs ...

Inaccessible DB2 after restore from V8

I have to restore old DB2 data. Unfortunately I'm not a DB2 administrator and I'm facing a strange problem. Scenario:I have DB2 version 9.7 and six backups (= six individual files). Two of them were taken from DB2 version 9.5, the others from DB2 version 8.? (I don't know the exact version). Operati ...

DB2 Backup/Restore

I want to call DB2 native APIs to backup and restore db2 existing database. I have read an example backrest explaining backup and restore of DB2 database. ihad also read an article explaining backup/restore for vendor products.I was unable to link these both articles. Can anybody guide me what is th ...

DB2 database restore issue.

I have got a database backup with name as below...."EHA0710.0.db2inst1.NODE0000.CATN0000.20100810150436.001"This I want to restore to my database EHA0710, which I have created myself using DB2 express c "control center".But when I try to restore It by right clicking on the database and then restore ...

db2 cannot restore from mounted directory?

db2 restore db databaseName from Directory doesn't work (hangs and does nothing, no error, no time out) for me if the Directory is a nfs mounted directory. Any idea how to make it work? Now I copy the bckup file to /tmp, restore, and delete from /tmp* db2 v 9.7* mounted from / to SuSe ...

DB2 dump restore

We have a DB2 database dump of version 8.1.When we try to restore it on 8.1 it is giving following error:SQL2054NThe backup or copy image is corrupted.ExplanationThe backup or copy image in use is corruptedThis can also mean that the Restore utility determined that a compressed image was not decompr ...

DB2 TSM restore

Sorry to bother you again but I still haven't managed to get restore to work.If I have the following two lines in the db cfg, what am I missing??Rollforward pending = DATABASERestore pending = YES Please help. A backup is kind of useless if I can't restore. ...

db2 online restore

I am working on db2 V9.1 on AIX server.setup: 1. Userexit= ON2. logsecond= -13. db2 backup database xxx online to <path>Problem:1. how do i determine the isotime at the time of performing rollforward operation 2. Get SQL4970N error, how do i resolve this? I have copied all the active logs befo ...

DB2 V8.2 DPF on AIX - Tablespace status

Hi, Is it possible to find out all tablespaces in restricted states (backup/check pending etc.) in all nodes in a single command ? Is it possible to recover a single tablespace from a full backup taken at database level under DB2 v8.2 ? ...

db2 redirect restore

After i am restoring the database from one system backup into another , i typed the list tablespaces, those are in Restore Pending + Storage May be Defined. How to rectify this problem. ...

db2/2 Restore

When I try to restore my backup files the answer of the system is:SQL2068N*An invalid image was encountered on media "<media>". There was no media header. **Explanation: *An invalid image was encountered during the processing of a database utility. The utility was not able to locate a valid me ...

BACKUP issues in DB2 ESE with DPF

Im geeting in some strange situation whenI'm running parallel bckups on DB partition db , this job use to run fine ...until now for last days my backup will not start on all db partitions and will take longer than usually...what can be wrong ...??db2_all "|| db2 backup db $DB2DBDFT online to '/.../ ...

DB2 backup/restore time

Is there any benchmark that the restore of <nn> GB database will take <x> * <backuptime> ?I want to know the time required for the restore of my database ,say 1TB which took 2Hrs for the backup. ...

DB2 backup/restore time

Is there any benchmark that the restore of <nn> GB database will take <x> * <backuptime> ?I want to know the time required for the restore of my database ,say 1TB which took 2Hrs for the backup. ...

DB2 Restore problem

I have created a backup image of a database "dbname1" on "SERVER1\K". I need to create a new database "dbname2" on "SERVER2" using backup image on SERVER1 over the network. I issued the following command at db2 prompt,"restore database dbname1 from \\serv ...

failed to restore db2 database from windows to AIX

I made a backup db2 database on windows, and could be restored to create new database or replacing existing one on other windows machine. But it failed to restore on AIX, which has the same version 8.1 DB2/UDB. The only error message is cannot find the backup image with certain timestamp. Obviously, ...

DB2 Backup and Restore to another DB2

Can anyone help me regarding the DB2 Redirected Restore Scripts the reason is that i want to backup a DB2 and replicate it to another DB2 Server and eventually it is a Windows Server 2003. ...

bash shell with DB2 Linux DPF (InfoSphere Warehouse)

DB2 InfoSphere Warehouse 9.7 on Red Hat Linux (previously known as DB2 ESE with DPF feature).Has anyone used bash shell (default for Linux) on the instance owner when using DPF (InfoSphere Warehouse)? I notice that when I run db2_all it can't find .profile, which doesn't exist with bash shell. ...

DB2 V9 FP1, FCM buffer pool utilization in DPF environment

Please let me request some help on the following issues:AIX 5.3, DB2 V9 FP1, DPF enabled (two physical partitions)We want to calculate the FCM buffer pool utilization. IBM describes this as: "Use the number of FCM buffers currently free in conjunction with the fcm_num_buffers configuration parameter ...

redirected restore problem

I am trying to create a test DB (AIX 5.1 ,db2 V7.2) from the image copy of Production (AIX 4.3 ,db2 V7.2) I created the DB first with the same code page as productionthen executed the script asdb2 -v "restore db db1 from '/backup' taken at 20040403220734 to /db2/db200001/dbnc3db into db1 redire ...

Restore of DMS temporary TS with redirection

I have db MYDB that I try to restore but I can't find out what is the problem with redirection of one TEMPORARY (8k) DMS tablespace. I try to make restore to a new db (NEWONEDB) from offline backup of MYDB.$ db2 connect to mydbDatabase Connection InformationDatabase server = DB2/AIX64 8.2.0SQL autho ...

db2 SQL0294N

i had taken up the backup of sap database which runs on db2 now when i am restoring it to a new database i am facing few issues.kindly help me with them1.since source database and target database will be on the same machine will it use it log files of source database or of the target database,or the ...

Creating instance on DPF (Data Partitioning Feature)

DB2 InfoSphere Warehouse 9.7 on Red Hat Linux (previously known as DB2 ESE with DPF feature). Is one supposed to create an instance on each physical node of a DPF system with multiple physical machines? I created an instance on the Admin Node which has the instance owner NFS mounted and shared on my ...

DB2 Email Interoperability

Is there a way to send an email dynamically within DB2.Please excuse my micosoftization but I have just moved from SQLServer to DB2 8.2 DPF programming/admin. There is a class library that allowed me to simply config and program this operation but I have yet to find something similar in DB2.marc ...

Oracle colne db2 to db1 on same server ??

I have 2 DB, lets call them db1 and db2....lets say i want to restore db2 into db1....and they are both on the same server...db2 get loaded with some new data...and now we want db2 to reflectas db1 (without replication)...as we want to do a restore of db1 couple of times after our stress testing is ...

Working on restoring prod data in dev environment

.....and it's not going as smoothly as I expected it.I can't use db2move because I don't have any sense of time, and would hate to copy the WHOLE db nightly, so I'm using restore/rollforward.I have a backup strategy of a full online backup on Sunday, and incremental deltas Monday-Saturday, which als ...

rollforward issue

We have successfully restore from TSM but when we perform rollback got error as below.ON /db2/GQB/sapdata6 ,/db2/GQB/sapdata5 ,/db2/GQB/sapdata4 ,/db2/GQB/sapdata3 ,/db2/GQB/sapdata2 ,/db2/GQB/sapdata1 DBPATH ON /db2/GQB INTO GQB LOGTARGET /db2/GQB/log_dir/NODE0000/ WITH 2 BUFFERS BUFFER 1024SQL2528 ...

data management tools

I have to get some opinions on a tool called DB2 Recovery Expert and some related tools, like Db2 Log Analysis Tool and Db2 Object Restore to decide whether we get them or not.We´re running DB2 UDB V7.2 Fixpak 7 on an aix box V4.3.3Have you heard anything about them? Are they accurate? Do they work ...

Why this error

From Perl when I execute the following script$command="db2cmd.exe DB2CLP.BAT DB2.EXE RESTORE DATABASE testdb user db2admin FROM C: TAKEN AT 20030919155911 to D: INTO testdb1 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING";system $command;I get the errorSQL0104N An unexpected token "END- ...

Backup question

I'm rather new in AIX so I want some comments about backup scheme I've developed to backup every part of the system. I have the following hardware: Power6 570 server with two VIO server and 3 LPARs NIM server outside (on the other Power server) Windows 2003 Server with Tivoli Storage Manager 5.5.2 S ...

Move database to different platform

I would like to move a DB2 UDB ESE V8 database on AIX to DB2 UDB ESE V8 on LINUX. Has anyone done this and is it via a db2 backup witha db2 redirected restore? Also does anyone have any benchmarks for DB2 on AIX vs DB2 on LINUX. ...

Roll Forward recovery

Hi, I am trying to test roll forward recovery on db2 v8.2 DPF , AIX 5.3 and having following issues:a) When I issue db2_all to update db cfg to update TRACKMOD, the command returns 'update db cfg using ... completed ok' But does not update. Initially I have issued db2 update db cfg command to update ...

Sync databases manually

This is my first post on this website. Hi to all.I have a question that may have a very simple answer, or not...I work in a company with two offices each with its SQL server and different databases DB1 and DB2 for different apps. Recently half of the team from one office moved to the second one and ...

db2start on Ubuntu (Jaunty) ... always works SECOND TIME only

Folks,I've got DB2 Express-C 9.7 installed on a number of Ubuntu Jaunty machines and I always have to issue the db2start command twice to get it to start. I've discovered I get exactly the same error with other editions of DB2 on Ubuntu Jaunty as well, all the way up to DB2 ESE with DPF, so it isn't ...

[HOT]BI Positions in IBM GDC CHina

IBM GDC HR Contact:*Karen Gong for Filenet/Data Mining/ILOG/SPSSEmail:ylgong@cn.ibm.com; MSN:gong_yuanlikaren@hotmail.com*Nancy Zhu for CognosEmail: zhuqing@cn.ibm.com, MSN:zhunancy999@hotmail.com*Cleo Liu for Data Architect/BI PM/DB2 DBAEmail: changliu@cn.ibm.com, MSN:cleo_darlingliu@hotmail.com*Sh ...

Help restoring a CQ backup

I have a CQ/DB2 installation. I had to reinstall my server and I followed these steps in order to recover my CQ environment: Create the DB2 databases Restore the DB2 backups of the schema and user databases I have. No problem with this. In the CQ Maintenance tool, I created the connection as always. ...

DB2 DPF restore/recovery

I have installed DB2 9.7 with DPF 3 partitions.I took the backup of all the three nodes.I want to understand the restore scenarios for the DPF environment, following are my doubts:1. For restore is the necessary to restore the catalog node first?2. Is it possible to resotre a single partition (non c ...

db2 backup and restore not working

I'm using DB2 v9.1 LUW. I created a simple database and table and inserted some rows. I'm testing the backups and restores. Then did a db2 backup (both online and offline). Then I deleted the rows from the table. Then did a restore and rollforward. Well the table shows 0 rows so it didn't restore th ...

Restore DB2 Database from RS/6000 to AS/400

Can a DB2 database backup created on an RS/6000 running AIX be restored to an AS/400 running OS/400 and DB2? I don't know the DB2 release levels of either. I expect this would determine success or failure. Are the hardware platforms and/or OS versions a factor, also?If this type of restore is possib ...

db2 restore to another server

We have to try to restore our prod db to our dev server. The OS on both is linux(versions are the same).The database is db2 v7.2.We run our backups to a /db_arch/backup directoryWhen I restore it to the new server what command will have to issue? Something similar to this:"db2 restore db day2pr ...

Db2 Restore Problem

Iam facing the following problem when i try to restore database from an Image file.I did the following steps.1. db2 force applications all2. db2 restore database DBNAME from C:\ redirect without rolling forwardAfter executing this command, i have got the following message.SQL2539W Warning! Restoring ...

cannot find image to restore DB2 database help

I cannot find a good image to run a restore from our DB2 database.What can I do?# db2 "restore database mydatabase use tsm taken at 20010208164859"SQL2542N No match for a database image file was found based on the source database alias "mydatabase" and timestamp "20010208164 ...

Error Restore Db2 V7.2 To Db2 V8.1

ERROR RESTORE DB2 V7.2 TO DB2 V8.1SQL2519N The database was restored but the restored database was not migratedto the current release. Error "-101" with tokens "" is returned.SQLSTATE=54001 ...

about DB2 V8.1 Restore and create new database from other database backups

I tried to duplicate a DB2 V8.1 database on another machine. I create the database with restore my current database backups. And it did. Everything was there. And I could connect to the database in command center, but whatever SELECT statement I tried in command center, it shows me "Database co ...