Unanswered: Sybase ASE -> Sybase IQ LOCATION & locking
I need to copy a few million rows on a daily basis from a Production ASE server to our new IQ reporting server. I was planning on using the method :
insert into tablename location 'srvname.dbname' etc.
What I have not been able to determine exactly what the impact will be on the source ASE server during the copy i.e does IQ do a dirty read, or is there a possible that production users would be stopped from writing new data to the various tables used in the SELECT due to locking?