06-18-2014 02:23 AM
Trying to create datasets/tables on DEV database using data from PROD database all in the Netezza Platform. I have found it takes a long time (hours) for a small data set. If I downloaded the data from PROD into to SAS and bulkloaded it back to the DEV database runs very fast.
Confused why there would be a difference? I would have thought that processing the data from DEV to PROD in Netezza would be quicker than downloading and uploading the data.
data ndev.tmp /*Netezza DEV DB*/;
set nprod.small_table; /*Netezza PROD DB*/
06-18-2014 02:59 AM
I keep getting the following error message in SAS 9.3 log:
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: ERROR: Cross
Database Access not supported for this type of command.
tried differing ways proc sql, data step and proc summary to see if it made a difference... to no avail... don't know if it is a SAS or Netezza issue that is preventing data being written between databases on Netezza using SAS 9.3.
06-18-2014 07:01 AM
Using standard sas sql to netezza you can be trapped by a lot of caveats.
Using sas/access netezza can require a lot of knowledge of the impact what is happening.
Updating a database is different to reading. Bulkloading is the fastest because a lot of checks are bypassed.
The automatic copying prod to develop has to copy records into sas and back. Sometimes cursor operations and locking can cause a lot of delay.