Hello Andreas,
Thank you for your response. I tried several ways to restore the database (not even the tenant restore). Here are the steps for non-tenant restoration.
[06:33 informix@informixnew ~] $ onmode -kuy
[06:33 informix@informixnew ~] $ onclean -ky
onclean: Cleaning up processes and resources for 'hpbib'...
- Looking for the shmem key: 52564803
- Looking for semaphore ID: 65537
- Looking for the shmem key: 52564801
- Looking for the shmem key: 52564802
- Looking for semaphore ID: 65538
- Looking for semaphore ID: 65539
- Looking for semaphore ID: 65540
- Looking for semaphore ID: 65541
- Looking for semaphore ID: 65542
- Looking for semaphore ID: 65543
- Looking for semaphore ID: 65544
onclean: IBM Informix Dynamic Server seems to have shutdown cleanly.
[06:33 informix@informixnew ~] $ onbar -r -p -O
Verifying physical disk space, please wait ...
Verifying physical disk space, please wait ...
Verifying physical disk space, please wait ...
attn: Ignoring unknown or deprecated config parameter (MIRROR)
Warning: The IBM Informix Dynamic Server Workgroup Edition license restriction limits
the total shared memory size for this server to 33554432 KB. The
maximum allowable shared memory will be set to this size. (SHMTOTAL)
Warning: Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
Warning: Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
Warning: Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
(-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
[06:34 informix@informixnew ~] $ ll /opt/IBM/informix/14.10FC10X3/storage/
total 15229976
-rw-rw----. 1 informix informix 157286400 Oct 3 06:34 datadbs
drwxrwxr-x. 2 informix informix 31 Sep 29 17:55 dbsp
drwxrwxr-x. 2 informix informix 6 Sep 27 08:46 dbsp1
-rw-rw----. 1 informix informix 42991616 Oct 3 06:34 llogdbs
-rw-rw----. 1 informix informix 838860800 Oct 3 06:34 plogdbs
-rw-rw----. 1 informix informix 977272832 Oct 3 06:34 rootdbs
-rw-rw----. 1 informix informix 94371840 Oct 3 06:34 sbspace
-rw-rw----. 1 informix informix 62914560 Oct 3 06:30 tempdbs
drwxrwxr-x. 2 informix informix 6 Oct 2 05:59 test
-rw-rw----. 1 informix informix 2147483648 Oct 3 06:34 testm1_blsp
-rw-rw----. 1 informix informix 2147483648 Oct 3 06:34 testm1_dbsp
-rw-rw----. 1 informix informix 536870912 Oct 3 06:34 testm1_plogsp
-rw-rw----. 1 informix informix 1073741824 Oct 3 06:34 testm1_sbsp
-rw-rw----. 1 informix informix 536870912 Oct 3 06:34 testm1_tdbsp
-rw-rw----. 1 informix informix 268435456 Oct 3 06:34 testm1_tsbsp
-rw-rw----. 1 informix informix 2147483648 Oct 3 06:34 testm_blsp
-rw-rw----. 1 informix informix 2147483648 Oct 3 06:34 testm_dbsp
-rw-rw----. 1 informix informix 536870912 Sep 27 08:45 testm_plogsp
-rw-rw----. 1 informix informix 1073741824 Oct 3 06:34 testm_sbsp
-rw-rw----. 1 informix informix 536870912 Oct 2 07:41 testm_tdbsp
-rw-rw----. 1 informix informix 268435456 Oct 2 07:41 testm_tsbsp
[06:36 informix@informixnew ~] $ onbar -r -l
Here is bar_act.log for the commands above.
2023-10-03 06:34:21 726998 726996 (-43061) BAR_MAX_BACKUP has been reduced to 27060 to avoid allocating more
than SHMTOTAL KB.
2023-10-03 06:34:21 726998 726996 (-43141) The edition of Informix Dynamic Server currently running restricts the
number of parallel backup or restore processes to 1. Resetting BAR_MAX_BACKUP
to 1.
2023-10-03 06:34:21 726998 726996 /opt/IBM/informix/14.10FC10X3/bin/onbar_d -r -p -O
2023-10-03 06:34:21 726998 726996 Using IBM Corporation's TSM version 5.3.2.0 as the Storage Manager. XBSA API version is 1.0.3.
2023-10-03 06:34:22 726998 726996 Successfully connected to Storage Manager.
2023-10-03 06:34:22 726998 726996 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 21 Current log id: 21
2023-10-03 06:34:22 726998 726996 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 46 Current log id: 22
2023-10-03 06:34:23 726998 726996 Successfully connected to Storage Manager.
2023-10-03 06:34:23 726998 726996 Begin reserved pages read (level 0 of rootdbs, Storage Manager copy ID: 0 41264 [0
41264]).
2023-10-03 06:34:23 726998 726996 Completed reserved pages read (level 0 of rootdbs).
2023-10-03 06:34:24 726998 726996 Creating /opt/IBM/informix/14.10FC10X3/storage/testm1_tdbsp to allow restore
2023-10-03 06:34:31 726998 726996 Creating /opt/IBM/informix/14.10FC10X3/storage/testm1_blsp to allow restore
2023-10-03 06:34:31 726998 726996 Creating /opt/IBM/informix/14.10FC10X3/storage/testm1_tsbsp to allow restore
2023-10-03 06:34:32 726998 726996 Successfully connected to Storage Manager.
2023-10-03 06:34:32 726998 726996 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 0 41264 [0 41264]).
2023-10-03 06:34:42 726998 726996 Completed cold level 0 restore rootdbs.
2023-10-03 06:34:42 726998 726996 Begin cold level 0 restore testm_sbsp (Storage Manager copy ID: 0 41152 [0 41152]).
2023-10-03 06:34:43 726998 726996 Completed cold level 0 restore testm_sbsp.
2023-10-03 06:34:43 726998 726996 Begin cold level 0 restore testm_blsp (Storage Manager copy ID: 0 41155 [0 41155]).
2023-10-03 06:34:44 726998 726996 Completed cold level 0 restore testm_blsp.
2023-10-03 06:34:44 726998 726996 Begin cold level 0 restore testm_dbsp (Storage Manager copy ID: 0 41157 [0 41157]).
2023-10-03 06:34:45 726998 726996 Completed cold level 0 restore testm_dbsp.
2023-10-03 06:34:45 726998 726996 Begin cold level 0 restore testm1_sbsp (Storage Manager copy ID: 0 41265 [0 41265]).
2023-10-03 06:34:46 726998 726996 Completed cold level 0 restore testm1_sbsp.
2023-10-03 06:34:46 726998 726996 Begin cold level 0 restore sbspace (Storage Manager copy ID: 0 41266 [0 41266]).
2023-10-03 06:34:47 726998 726996 Completed cold level 0 restore sbspace.
2023-10-03 06:34:47 726998 726996 Begin cold level 0 restore testm1_blsp (Storage Manager copy ID: 0 41267 [0 41267]).
2023-10-03 06:34:48 726998 726996 Completed cold level 0 restore testm1_blsp.
2023-10-03 06:34:48 726998 726996 Begin cold level 0 restore testm1_dbsp (Storage Manager copy ID: 0 41268 [0 41268]).
2023-10-03 06:34:49 726998 726996 Completed cold level 0 restore testm1_dbsp.
2023-10-03 06:34:49 726998 726996 Begin cold level 0 restore logdbs (Storage Manager copy ID: 0 41269 [0 41269]).
2023-10-03 06:34:50 726998 726996 Completed cold level 0 restore logdbs.
2023-10-03 06:34:50 726998 726996 Begin cold level 0 restore testm1_plogsp (Storage Manager copy ID: 0 41270 [0 41270]).
2023-10-03 06:34:51 726998 726996 Completed cold level 0 restore testm1_plogsp.
2023-10-03 06:34:51 726998 726996 Begin cold level 0 restore datadbs (Storage Manager copy ID: 0 41271 [0 41271]).
2023-10-03 06:34:52 726998 726996 Completed cold level 0 restore datadbs.
2023-10-03 06:34:52 726998 726996 Begin cold level 0 restore physdbs (Storage Manager copy ID: 0 41272 [0 41272]).
2023-10-03 06:34:53 726998 726996 Completed cold level 0 restore physdbs.
2023-10-03 06:34:55 726998 726996 Successfully connected to Storage Manager.
2023-10-03 06:34:55 726998 726996 (-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
2023-10-03 06:34:55 726998 726996 /opt/IBM/informix/14.10FC10X3/bin/onbar_d complete, returning 179 (0xb3)
-------------------------------
2023-10-03 06:36:28 728214 728212 (-43061) BAR_MAX_BACKUP has been reduced to 27060 to avoid allocating more
than SHMTOTAL KB.
2023-10-03 06:36:28 728214 728212 (-43141) The edition of Informix Dynamic Server currently running restricts the
number of parallel backup or restore processes to 1. Resetting BAR_MAX_BACKUP
to 1.
2023-10-03 06:36:28 728214 728212 /opt/IBM/informix/14.10FC10X3/bin/onbar_d -r -l
2023-10-03 06:36:28 728214 728212 Using IBM Corporation's TSM version 5.3.2.0 as the Storage Manager. XBSA API version is 1.0.3.
2023-10-03 06:36:31 728214 728212 Successfully connected to Storage Manager.
2023-10-03 06:36:31 728214 728212 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 21 Current log id: 21
2023-10-03 06:36:31 728214 728212 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 46 Current log id: 22
2023-10-03 06:36:33 728214 728212 Successfully connected to Storage Manager.
2023-10-03 06:36:33 728214 728212 Begin restore logical log 82 (Storage Manager copy ID: 0 41162 [0 41162]).
2023-10-03 06:36:33 728214 728212 Completed restore logical log 82.
2023-10-03 06:36:33 728214 728212 Begin restore logical log 83 (Storage Manager copy ID: 0 41167 [0 41167]).
2023-10-03 06:36:33 728214 728212 Completed restore logical log 83.
2023-10-03 06:36:33 728214 728212 Begin restore logical log 84 (Storage Manager copy ID: 0 41168 [0 41168]).
2023-10-03 06:36:33 728214 728212 Completed restore logical log 84.
2023-10-03 06:36:33 728214 728212 Begin restore logical log 85 (Storage Manager copy ID: 0 41172 [0 41172]).
2023-10-03 06:36:33 728214 728212 Completed restore logical log 85.
2023-10-03 06:36:33 728214 728212 Begin restore logical log 86 (Storage Manager copy ID: 0 41186 [0 41186]).
2023-10-03 06:36:50 728214 728212 Completed restore logical log 86.
2023-10-03 06:36:50 728214 728212 Begin restore logical log 87 (Storage Manager copy ID: 0 41187 [0 41187]).
2023-10-03 06:36:51 728214 728212 Completed restore logical log 87.
2023-10-03 06:36:51 728214 728212 Begin restore logical log 88 (Storage Manager copy ID: 0 41188 [0 41188]).
2023-10-03 06:36:52 728214 728212 Completed restore logical log 88.
2023-10-03 06:36:52 728214 728212 Begin restore logical log 89 (Storage Manager copy ID: 0 41189 [0 41189]).
2023-10-03 06:36:53 728214 728212 Completed restore logical log 89.
2023-10-03 06:36:53 728214 728212 Begin restore logical log 90 (Storage Manager copy ID: 0 41190 [0 41190]).
2023-10-03 06:36:54 728214 728212 Completed restore logical log 90.
2023-10-03 06:36:54 728214 728212 Begin restore logical log 91 (Storage Manager copy ID: 0 41191 [0 41191]).
2023-10-03 06:36:55 728214 728212 Completed restore logical log 91.
2023-10-03 06:36:55 728214 728212 Begin restore logical log 92 (Storage Manager copy ID: 0 41192 [0 41192]).
2023-10-03 06:36:56 728214 728212 Completed restore logical log 92.
2023-10-03 06:36:56 728214 728212 Begin restore logical log 93 (Storage Manager copy ID: 0 41193 [0 41193]).
2023-10-03 06:36:56 728214 728212 Completed restore logical log 93.
2023-10-03 06:36:56 728214 728212 Begin restore logical log 94 (Storage Manager copy ID: 0 41194 [0 41194]).
2023-10-03 06:36:58 728214 728212 Completed restore logical log 94.
2023-10-03 06:36:58 728214 728212 Begin restore logical log 95 (Storage Manager copy ID: 0 41195 [0 41195]).
2023-10-03 06:36:59 728214 728212 Completed restore logical log 95.
2023-10-03 06:36:59 728214 728212 Begin restore logical log 96 (Storage Manager copy ID: 0 41196 [0 41196]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 96.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 97 (Storage Manager copy ID: 0 41197 [0 41197]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 97.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 98 (Storage Manager copy ID: 0 41198 [0 41198]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 98.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 99 (Storage Manager copy ID: 0 41199 [0 41199]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 99.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 100 (Storage Manager copy ID: 0 41200 [0 41200]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 100.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 101 (Storage Manager copy ID: 0 41245 [0 41245]).
2023-10-03 06:37:00 728214 728212 Completed restore logical log 101.
2023-10-03 06:37:00 728214 728212 Begin restore logical log 102 (Storage Manager copy ID: 0 41259 [0 41259]).
2023-10-03 06:37:06 728214 728212 Completed restore logical log 102.
2023-10-03 06:37:06 728214 728212 Begin restore logical log 103 (Storage Manager copy ID: 0 41260 [0 41260]).
2023-10-03 06:37:07 728214 728212 Completed restore logical log 103.
2023-10-03 06:37:07 728214 728212 Begin restore logical log 104 (Storage Manager copy ID: 0 41261 [0 41261]).
2023-10-03 06:37:08 728214 728212 Completed restore logical log 104.
2023-10-03 06:37:08 728214 728212 Begin restore logical log 105 (Storage Manager copy ID: 0 41262 [0 41262]).
2023-10-03 06:37:09 728214 728212 Completed restore logical log 105.
2023-10-03 06:37:09 728214 728212 Begin restore logical log 106 (Storage Manager copy ID: 0 41263 [0 41263]).
2023-10-03 06:37:09 728214 728212 Completed restore logical log 106.
2023-10-03 06:37:09 728214 728212 Begin restore logical log 107 (Storage Manager copy ID: 0 41277 [0 41277]).
2023-10-03 06:37:09 728214 728212 Completed restore logical log 107.
2023-10-03 06:37:09 728214 728212 Begin restore logical log 108 (Storage Manager copy ID: 0 41278 [0 41278]).
2023-10-03 06:37:12 728214 728212 Completed restore logical log 108.
2023-10-03 06:37:12 728214 728212 Begin restore logical log 109 (Storage Manager copy ID: 0 41279 [0 41279]).
2023-10-03 06:37:13 728214 728212 Completed restore logical log 109.
2023-10-03 06:37:13 728214 728212 Begin restore logical log 110 (Storage Manager copy ID: 0 41280 [0 41280]).
2023-10-03 06:37:14 728214 728212 Completed restore logical log 110.
2023-10-03 06:37:14 728214 728212 Begin restore logical log 111 (Storage Manager copy ID: 0 41281 [0 41281]).
2023-10-03 06:37:15 728214 728212 Completed restore logical log 111.
2023-10-03 06:37:15 728214 728212 Begin restore logical log 112 (Storage Manager copy ID: 0 41282 [0 41282]).
2023-10-03 06:37:16 728214 728212 Completed restore logical log 112.
2023-10-03 06:37:16 728214 728212 Begin restore logical log 113 (Storage Manager copy ID: 0 41305 [0 41305]).
2023-10-03 06:37:20 728214 728212 Completed restore logical log 113.
2023-10-03 06:37:20 728214 728212 Begin restore logical log 114 (Storage Manager copy ID: 0 41306 [0 41306]).
2023-10-03 06:37:21 728214 728212 Completed restore logical log 114.
2023-10-03 06:37:21 728214 728212 Begin restore logical log 115 (Storage Manager copy ID: 0 41307 [0 41307]).
2023-10-03 06:37:21 728214 728212 Completed restore logical log 115.
2023-10-03 06:37:21 728214 728212 Begin restore logical log 116 (Storage Manager copy ID: 0 41308 [0 41308]).
2023-10-03 06:37:22 728214 728212 Completed restore logical log 116.
2023-10-03 06:37:26 728214 728212 Completed logical restore.
2023-10-03 06:37:26 728214 728212 Successfully connected to Storage Manager.
2023-10-03 06:37:27 728214 728212 /opt/IBM/informix/14.10FC10X3/bin/onbar_d complete, returning 0 (0x00)
So everything looks OK, but when I try to connect to tenant databases...
[06:37 informix@informixnew ~] $ dbaccess testm1db -
27002: No connections are allowed in quiescent mode.
[06:40 informix@informixnew ~] $ onmode -m
[06:40 informix@informixnew ~] $ dbaccess testm1db -
311: Cannot open system catalog (systables).
155: ISAM error: Primary and Mirror chunks are bad
[06:40 informix@informixnew ~] $ dbaccess testmdb -
311: Cannot open system catalog (systables).
155: ISAM error: Primary and Mirror chunks are bad
[06:44 informix@informixnew ~] $ dbaccess sysadmin -
Database selected.
> EXECUTE FUNCTION task('tenant drop', 'testmdb');
(expression) Database [testmdb] is not a tenant database.
1 row(s) retrieved.
> EXECUTE FUNCTION task('tenant drop', 'testm1db');
(expression) Database [testm1db] is not a tenant database.
1 row(s) retrieved.
>
If I then try the tenant point-in-time restore:
[06:51 informix@informixnew ~] $ onbar -r -T testmdb -t "2023-10-01 08:35:05" -O
---- bar_act.log----
2023-10-03 06:51:41 735636 735634 (-43061) BAR_MAX_BACKUP has been reduced to 27060 to avoid allocating more
than SHMTOTAL KB.
2023-10-03 06:51:41 735636 735634 (-43141) The edition of Informix Dynamic Server currently running restricts the
number of parallel backup or restore processes to 1. Resetting BAR_MAX_BACKUP
to 1.
2023-10-03 06:51:41 735636 735634 /opt/IBM/informix/14.10FC10X3/bin/onbar_d -r -T testmdb -t 2023-10-01 08:35:05 -O
2023-10-03 06:51:41 735636 735634 Unable to retrieve space list for tenant database 'testmdb'.
2023-10-03 06:51:41 735636 735634 /opt/IBM/informix/14.10FC10X3/bin/onbar_d complete, returning -1 (0xffffffff)
----- onstat -d ----
[06:53 informix@informixnew ~] $ onstat -d update
IBM Informix Dynamic Server Version 14.10.FC10X3WE -- On-Line -- Up 00:18:58 -- 185996 Kbytes
2023-10-03 06:53:30
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
459a4028 1 0x20001 1 1 2048 N BA informix rootdbs
459a4dd0 2 0x1 2 1 2048 N BA informix physdbs
45ae4a50 3 0x1 3 1 2048 N BA informix logdbs
45ae4c98 4 0x1 4 1 2048 N BA informix datadbs
45ac7c50 5 0x8001 5 1 2048 N SBA informix sbspace
459a5b88 6 0x2001 6 2 2048 N TBA informix tempdbs
459a5dd0 7 0x8000005 7 1 2048 ND BA informix testm_dbsp
47b97028 8 0x8000015 8 1 4096 NDBBA informix testm_blsp
47b97270 9 0x8008005 9 1 2048 NDSBA informix testm_sbsp
47b97700 11 0x2001 11 1 2048 N TBA informix testm_tdbsp
47b97948 12 0xa001 12 1 2048 N UBA informix testm_tsbsp
47b97b90 13 0x8000005 13 1 2048 ND BA informix testm1_dbsp
47b99028 15 0x8008005 15 1 2048 NDSBA informix testm1_sbsp
47b99270 16 0x1000001 16 1 2048 N PBA informix testm1_plogsp
14 active, 2047 maximum
Waiting for server to update BLOB chunk statistics...
Chunks
address chunk/dbs offset size free bpages flags pathname
459a4270 1 1 0 477184 465644 PO-B-D /opt/IBM/informix/14.10FC10X3/storage/rootdbs
47b9a028 2 2 0 409600 409547 PO-B-D /opt/IBM/informix/14.10FC10X3/storage/plogdbs
47b9b028 3 3 0 20992 459 PO-B-D /opt/IBM/informix/14.10FC10X3/storage/llogdbs
47b9c028 4 4 0 76800 76747 PO-B-D /opt/IBM/informix/14.10FC10X3/storage/datadbs
47b9d028 5 5 0 46080 42903 42903 POSB-D /opt/IBM/informix/14.10FC10X3/storage/sbspace
Metadata 3124 2325 3124
47b9e028 6 6 0 30720 30667 PO-B-- /opt/IBM/informix/14.10FC10X3/storage/tempdbs
47b9f028 7 7 0 1048576 1046761 PD-BED /opt/IBM/informix/14.10FC10X3/storage/testm_dbsp
47ba0028 8 8 0 1048576 524288 524288 PDBB-D /opt/IBM/informix/14.10FC10X3/storage/testm_blsp
47ba1028 9 9 0 524288 -1 -1 PDSB-D /opt/IBM/informix/14.10FC10X3/storage/testm_sbsp
47ba3028 11 11 0 262144 262091 PO-BE- /opt/IBM/informix/14.10FC10X3/storage/testm_tdbsp
47ba4028 12 12 0 131072 122173 122173 POSB-- /opt/IBM/informix/14.10FC10X3/storage/testm_tsbsp
Metadata 8846 6583 8846
47ba5028 13 13 0 1048576 1046633 PD-BED /opt/IBM/informix/14.10FC10X3/storage/testm1_dbsp
47ba7028 15 15 0 524288 -1 -1 PDSB-D /opt/IBM/informix/14.10FC10X3/storage/testm1_sbsp
47ba8028 16 16 0 262144 0 PO-BED /opt/IBM/informix/14.10FC10X3/storage/testm1_plogsp
47baa028 18 6 0 60000 44997 PO-BE- /opt/IBM/informix/14.10FC10X3/storage/dbsp/hpbib_tempdbs_p_1
15 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always
[06:53 informix@informixnew ~] $
Hopefully, it gives you more info.
Thank you for any advice.
Regards
------------------------------
Ondřej Žižka
------------------------------
Original Message:
Sent: Mon October 02, 2023 03:41 PM
From: Andreas Legner
Subject: Cannot delete tenant database
Hi Ondřej,
it's not too clear, from your description, what all has happened to this tenant db, but the most fundamental problem now seems to be that ISAM error 155 which likely indicates a restore either still has to happen or has to run to completion, incl. the logical restore.
How did you perform this tenant restore? Could you post command, output and corresponding section from server message log?
BR,
Andreas
------------------------------
Andreas Legner
Original Message:
Sent: Mon October 02, 2023 02:44 AM
From: Ondřej Žižka
Subject: Cannot delete tenant database
Hello,
I have been playing a bit with the tenant database and I see an issue when I try to delete the tenant database.
The database has been created using the following command:
EXECUTE FUNCTION task('tenant create', 'testmdb', '{dbspace:"testm_dbsp", blobspace:"testm_blsp", sbspace:"testm_sbsp", dbspacetemp:"testm_tdbsp", dbspacetemp:"testm_tsbsp", vpclass:"cpu,num=1", logmode:"UNBUFFERED"}');
Then I back up the database to TSM (Spectrum Protect - configured for logs backup as well). I was playing a bit with backups and restores to point-in-time, but later I was not able to bring the database back to work. The error was.
[06:46 informix@informixnew ~] $ dbaccess testmdb - 311: Cannot open system catalog (systables). 155: ISAM error: Primary and Mirror chunks are bad
I tried to recreate the master database (
https://www.ibm.com/support/pages/rebuilding-sysmaster-database), but the error still persists. I tried to restore it with onbar command (onbar -r , onbar -r -w ). Then I wanted to delete the database, but I saw an error:
> EXECUTE FUNCTION task('tenant drop', 'testmdb');(expression) Database [testmdb] is not a tenant database.1 row(s) retrieved.>
I tried to delete it as a normal database (drop database).
311: Cannot open system catalog (systables). 155: ISAM error: Primary and Mirror chunks are bad
I am able to connect to sysmaster and sysadmin databases.
[08:35 informix@informixnew ~] $ dbaccess sysmaster -Database selected.> [08:41 informix@informixnew ~] $ dbaccess sysadmin -Database selected.>
Is there a way to fix the issue? How to delete the tenant database in this situation?
Thank you for any advice.
------------------------------
Regards
Ondřej Žižka
------------------------------