Questions tagged [roll-forward]
5 questions
0
votes
2 answers
Db2 rollforward "to end of backup" vs. "to end of logs"?
On Db2 Enterpise Server Edition v11.1 single patitioned database on Linux/Intel using LOGARCHMETH1 I executed backup and restore commands:
db2 "backup database mydb online to /path/to/backup include logs without prompting"
Then on identical…
folow
- 229
- 1
- 5
- 14
0
votes
1 answer
db2 rollforward command output show '-' in "Log FIles processed" column for non-Catalog partitions
I have rollforward the database after restore command. Below are the outputs of queries:
db2 "rollforward db hdpf1 query status"
Rollforward Status
Input database alias = hdpf1
Number of…
Tom12345
- 11
- 4
0
votes
1 answer
Restoring database not all rows restored
I have a table EMPLOYEE.EMPLOYEE inside database HELLO which contains 3 records as listed below:
EMP_NO BIRTH_DATE FIRST_NAME LAST_NAME GENDER HIRE_DATE BANK_ACCOUNT_NUMBER PHONE_NUMBER
------- ---------- ------------------…
Sparker0i
- 1,787
- 4
- 35
- 60
0
votes
1 answer
Creating a One-Day-Ahead Roll-Forward Forecast in R
I am attempting to compute the predictive measures for roll-forward one-day-ahead forecasts and plot the results.
I had a few questions about my example code below:
What can I do to resolve the "replacement has length zero" error below?
How can I…
user1477388
- 20,790
- 32
- 144
- 264
0
votes
0 answers
How to restore older database in db2 9.7
When restoring a database in DB2 you need to specify the rollforward. I have created a new database using:
db2 RESTORE DATABASE dbname USER adminuser USING 'adminpassword' FROM 'C:\databases' TAKEN AT 20161231131530 INTO newdbnew without…
davejal
- 6,009
- 10
- 39
- 82