Customer would like to import data into a Controller DB2 database table, from a CSV (flat file) source.
How can they do this?
The source CSV file may have come from a different database (see separate IBM Technote #0741797 for more details).
- Controller 10.3.1
- DB2 10.5 & DB2 11
- However, the author does not recommend this because it can lead to the DB2 database becoming stuck in 'backup pending' status (after a failed load).
- TIP: The quickest type of backup is 'backup to NULL'. This causes a 'fake' backup to take place.
- Windows: db2 backup db <database> ONLINE to NUL
- Unix/Linux: db2 backup db <database> ONLINE to /dev/null
27 June 2019