Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

Thanks but this would be cold backup with manual move to different server

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

Ahh. Then unload by insertingbthe data into an external table and reload by reading from an external table.

Thanks but this would be cold backup with manual move to different server

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

Ok, that step i wanted to avoid. Is there a way to use dbexport or dbunload ?

Ahh. Then unload by insertingbthe data into an external table and reload by reading from an external table.

Thanks but this would be cold backup with manual move to different server

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

dbexport can do it, but it only exports the entire database so not a single table or handful of tables. There is no dbunload, only dbload.

You can use myexport in external table mode. If you don't want to have to hand build the external tables, myschema can generate them for you:

art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ myschema -d art -t systables --export-scripts /dev/null
Writing full schema DDL to:       /dev/null
art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ dir art.systables.export.sql
-rw-rw-r-- 1 art art 827 Oct  5 10:14 art.systables.export.sql
art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ cat art.systables.export.sql
CREATE EXTERNAL TABLE IF NOT EXISTS systables_external (  
       tabname VARCHAR(128,0),
       owner CHAR(32),
       partnum INTEGER,
       tabid SERIAL(3421),
       rowsize SMALLINT,
       ncols SMALLINT,
       nindexes SMALLINT,
       nrows FLOAT,
       created DATE,
       version INTEGER,
       tabtype CHAR(1),
       locklevel CHAR(1),
       npused FLOAT,
       fextsize INTEGER,
       nextsize INTEGER,
       flags SMALLINT,
       site VARCHAR(128,0),
       dbname VARCHAR(128,0),
       type_xid INTEGER,
       am_id INTEGER,
       pagesize INTEGER,
       ustlowts DATETIME YEAR TO FRACTION(5),
       secpolicyid INTEGER,
       protgranularity CHAR(1),
       statchange SMALLINT,
       statlevel CHAR(1)
) USING ( FORMAT "DELIMITED",  
   DATAFILES ( "disk:/home/art/GoogleDrive/MyConsulting/Scripts/systables.unl" ),  
   DELIMITER "|", DELUXE, ESCAPE ON );  
INSERT INTO systables_myexport  
   SELECT * FROM systables;
DROP TABLE systables_myexport;

Ok, that step i wanted to avoid. Is there a way to use dbexport or dbunload ?

Ahh. Then unload by insertingbthe data into an external table and reload by reading from an external table.

Thanks but this would be cold backup with manual move to different server

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks

Oops, that got away from me. You may have to edit the file to add a path to the blob file location, see the SQL Syntax manual for details.

dbexport can do it, but it only exports the entire database so not a single table or handful of tables. There is no dbunload, only dbload.

You can use myexport in external table mode. If you don't want to have to hand build the external tables, myschema can generate them for you:

art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ myschema -d art -t systables --export-scripts /dev/null
Writing full schema DDL to:       /dev/null
art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ dir art.systables.export.sql
-rw-rw-r-- 1 art art 827 Oct  5 10:14 art.systables.export.sql
art@Elezar-II:~/GoogleDrive/MyConsulting/Scripts$ cat art.systables.export.sql
CREATE EXTERNAL TABLE IF NOT EXISTS systables_external (  
       tabname VARCHAR(128,0),
       owner CHAR(32),
       partnum INTEGER,
       tabid SERIAL(3421),
       rowsize SMALLINT,
       ncols SMALLINT,
       nindexes SMALLINT,
       nrows FLOAT,
       created DATE,
       version INTEGER,
       tabtype CHAR(1),
       locklevel CHAR(1),
       npused FLOAT,
       fextsize INTEGER,
       nextsize INTEGER,
       flags SMALLINT,
       site VARCHAR(128,0),
       dbname VARCHAR(128,0),
       type_xid INTEGER,
       am_id INTEGER,
       pagesize INTEGER,
       ustlowts DATETIME YEAR TO FRACTION(5),
       secpolicyid INTEGER,
       protgranularity CHAR(1),
       statchange SMALLINT,
       statlevel CHAR(1)
) USING ( FORMAT "DELIMITED",  
   DATAFILES ( "disk:/home/art/GoogleDrive/MyConsulting/Scripts/systables.unl" ),  
   DELIMITER "|", DELUXE, ESCAPE ON );  
INSERT INTO systables_myexport  
   SELECT * FROM systables;
DROP TABLE systables_myexport;

Ok, that step i wanted to avoid. Is there a way to use dbexport or dbunload ?

Ahh. Then unload by insertingbthe data into an external table and reload by reading from an external table.

Thanks but this would be cold backup with manual move to different server

If the smartblob spaces are logged, and the table has a primary key, you can use ER to move the table from one server to a new one and maintain them in sync until turnover!

Hello,

is there a smooth way to backup smartblobs from 11.70 to 14.10 (different server)?

System would be RHEL7 and RHEL8

Thanks