|
Problem IT28302
|
Status: Closed |
ONSMSYNC DOES NOT INCLUDE NEEDED LOGICAL LOG FILE IN EXPORT OBJECTS AND FAILS
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
From bar_act.log:
2018-12-12 18:58:21 565 29831 onsmsync -E -p test -g 1
2018-12-12 18:58:21 565 29831 Using IBM's PSM version
12.10.FC10 as the Storage Manager. XBSA API version is 1.0.3.
2018-12-12 18:58:21 565 29831 The PSM is ready.
2018-12-12 18:58:21 565 29831 Informix Primary Storage Manager
session 40 opened.
2018-12-12 18:58:21 565 29831 Successfully connected to
Storage Manager.
2018-12-12 18:58:21 565 29831 Begin reserved pages read (level
0 of rootdbs, Storage Manager copy ID: 0 1).
2018-12-12 18:58:21 565 29831 Completed reserved pages read
(level 0 of rootdbs).
2018-12-12 18:58:21 565 29831 Informix Primary Storage Manager
session 40 closed
2018-12-12 18:58:21 565 29831 Export objects list
2018-12-12 18:58:21 565 29831 bar_export: rootdbs 0
R 0 1 2018-12-12 15:44:33 0:1
2018-12-12 18:58:21 565 29831 bar_export: indx01 0
ND 0 9 2018-12-12 15:44:35 0:2
2018-12-12 18:58:21 565 29831 bar_export: data01 0
ND 0 11 2018-12-12 15:44:35 0:3
2018-12-12 18:58:21 565 29831 bar_export: indx02 0
ND 0 10 2018-12-12 15:44:35 0:4
2018-12-12 18:58:21 565 29831 bar_export: cdr_rows 0
ND 0 2 2018-12-12 15:44:37 0:5
2018-12-12 18:58:21 565 29831 bar_export: data02 0
ND 0 3 2018-12-12 15:44:40 0:6
2018-12-12 18:58:21 565 29831 bar_export: sysadmin 0
ND 0 4 2018-12-12 15:44:46 0:7
2018-12-12 18:58:21 565 29831 bar_export: cdr_trans 0
ND 0 5 2018-12-12 15:45:46 0:8
2018-12-12 18:58:21 565 29831 bar_export: logsdbs 0
CD 0 6 2018-12-12 15:45:48 0:9
2018-12-12 18:58:21 565 29831 bar_export: physdbs 0
CD 0 7 2018-12-12 15:45:50 0:10
2018-12-12 18:58:21 565 29831 bar_export: sds_alt_comm 0
ND 0 8 2018-12-12 15:45:52 0:11
2018-12-12 18:58:21 565 29831 The PSM is ready.
2018-12-12 18:58:21 565 29831 Informix Primary Storage Manager
session 41 opened.
2018-12-12 18:58:21 565 29831 Successfully connected to
Storage Manager.
2018-12-12 18:58:21 565 29831 Export of PSM objects started.
2018-12-12 19:17:38 565 29831 Export of PSM objects completed.
2018-12-12 19:17:38 565 29831 Informix Primary Storage Manager
session 41 closed
2018-12-12 19:17:38 565 29831 onsmsync complete, returning 0
(0x00)
ixbar.1 shows:
dbservername rootdbs R 0 7534 0 0 1
2018-12-05 19:35:49 1 34757 503301004 7534 0 - -
34757 1544038549 1544038135 2278
dbservername cdr_rows ND 0 7535 0 0 5
2018-12-05 19:35:53 1 34757 503324052 7535 0 - -
34757 1544038553 1544038135 2282
dbservername data02 ND 0 7536 0 0 6
2018-12-05 19:35:56 1 34757 503343441 7536 0 - -
34757 1544038556 1544038135 2283
dbservername sysadmin ND 0 7537 0 0 7
2018-12-05 19:36:01 1 34757 503401513 7537 0 - -
34757 1544038561 1544038135 2284
dbservername cdr_trans ND 0 7538 0 0 8
2018-12-05 19:36:07 1 34757 503435207 7538 0 - -
34757 1544038567 1544038135 2285
dbservername logsdbs CD 0 7539 0 0 9
2018-12-05 19:36:09 1 34757 503439588 7539 0 - -
34757 1544038569 1544038135 2286
dbservername physdbs CD 0 7540 0 0 10
2018-12-05 19:36:11 1 34757 503446480 7540 0 - -
34757 1544038571 1544038135 2287
dbservername sds_alt_comm ND 0 7541 0 0 11
2018-12-05 19:36:13 1 34757 503456557 7541 0 - -
34757 1544038573 1544038135 2288
dbservername indx01 ND 0 7542 0 0 4
2018-12-05 19:35:51 1 34757 503323772 7542 0 - -
34757 1544038551 1544038135 2281
dbservername indx02 ND 0 7543 0 0 3
2018-12-05 19:35:51 1 34757 503323772 7543 0 - -
34757 1544038551 1544038135 2280
dbservername 34757 L 0 7544 0 0 12
2018-12-05 19:42:57 1 0 0 7544 0 - -
34757 1544038976 1544038135 0
dbservername data01 ND 0 7545 0 0 2
2018-12-05 19:35:51 1 34757 503323772 7545 0 - -
34757 1544038551 1544038135 2279
dbservername 34758 L 0 7546 0 0 13
2018-12-05 19:43:40 1 0 0 7546 0 - -
34758 1544039020 1544038976 0
Informix Primary Storage Manager Device List
Type Prio Block/Size (MB) Pool Name Device Name
FILE LOW --/-- DBSPOOL
/opt/informix/backups
FILE HIGH --/-- DBSPOOL /backups/dbspaces
FILE LOW --/-- LOGPOOL
/opt/informix/backups
FILE HIGH --/-- LOGPOOL /backups/llogs
FILE HIGH --/-- EXTPOOL /backups/EXT
Informix Primary Storage Manager Object List
Object ID Date Created Size (MB) Logical path
(name.version)
1 2018-12-12 15:44:35 12.8
/dbservername/rootdbs/0/dbservername.3
2 2018-12-12 15:44:37 6348.3
/dbservername/indx01/0/dbservername.3
3 2018-12-12 15:44:37 46713.5
/dbservername/data01/0/dbservername.3
4 2018-12-12 15:44:37 26912.3
/dbservername/indx02/0/dbservername.3
5 2018-12-12 15:44:39 97.5
/dbservername/cdr_rows/0/dbservername.3
6 2018-12-12 15:44:42 168.0
/dbservername/data02/0/dbservername.3
7 2018-12-12 15:44:48 160.6
/dbservername/sysadmin/0/dbservername.3
8 2018-12-12 15:45:48 0.1
/dbservername/cdr_trans/0/dbservername.3
9 2018-12-12 15:45:50 0.1
/dbservername/logsdbs/0/dbservername.3
10 2018-12-12 15:45:52 0.1
/dbservername/physdbs/0/dbservername.3
11 2018-12-12 15:45:54 0.1
/dbservername/sds_alt_comm/0/dbservername.3
12 2018-12-12 15:57:01 4.2
/dbservername/1/34757/dbservername.1
13 2018-12-12 15:57:01 0.0
/dbservername/critical_files/ixbar/dbservername.3
14 2018-12-12 15:57:01 0.0
/dbservername/critical_files/oncfg/dbservername.3
15 2018-12-12 15:57:01 0.1
/dbservername/critical_files/onconfig/dbservername.3
16 2018-12-12 15:57:01 0.0
/dbservername/critical_files/sqlhosts/dbservername.3
17 2018-12-12 18:04:29 3.3
/dbservername/1/34758/dbservername.1 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.03.2019
27.02.2020
27.02.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14
|
| Problem solved according to the fixlist(s) of the following version(s) |
