IBM Support

savekd8export.sql error on migrate-export/import

Technical Blog Post


Abstract

savekd8export.sql error on migrate-export/import

Body

image

savekd8export.sql error on migrate-import

An error of  "Colud not find find sqllib\savekd8export.sql"

is seen on a migrate-import command.

This is due to there being no data provider tables.

If  KD8_ITM_REST_SERVICE_ENABLE=N,  then there are no kd8 tables and the sql is not created.

The kd8 import/export was added to TEPS in TMS630 for data provider tables.
If you are using the dashboard applications then these tables would be needed

 When the data provider functionality was added , a  separate script was made to export/import kd8 tables.
Here are the tables that export/import for data provider.
 
source.table1.name=KD8DBVER
source.table2.name=KD8CACHEDEF
source.table3.name=KD8UISOLDEF
source.table4.name=KD8VMDEF
source.table5.name=KD8VMDEPS

When the variable KD8_ITM_REST_SERVICE_ENABLE is Y,  migrate-export will generate saveexport.sql and savekd8export.sql.
If the  variable is KD8_ITM_REST_SERVICE_ENABLE is  N, migrate-export will generate saveexport.sql only.

However in the migrate-import.bat script, we look for 'saveexport.sql' and 'savekd8export.sql' regardless of this variable.
If it can find both scripts, it will  import both.


If it finds only 'saveexport.sql', it will import saveexport.sql only and generate a


'Could not find sqllib\savekd8export.sql'

message which can be ignored.

Tutorials Point

Subscribe and follow us for all the latest information directly on your social feeds:

image

image

image

  

Check out all our other posts and updates:
Academy Blogs:  http://ow.ly/Otue0
Academy Videos:  http://ow.ly/PIKFz
Academy Google+:  http://ow.ly/Dj3nn
Academy Twitter Handle:  http://ow.ly/Dj35c

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTFXA","label":"Tivoli Monitoring"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

UID

ibm11084113