List of Contributions

>> GRANT CREATE TABLE TO that_user; This makes sense, thank you! That will help them create their own tables in the same environment as the tables they'd like to CTAS source or import their own data. Then, it would be a training task to ask them to create all of their tables as "ABC_", for example, ...

Have a request where users would like to be able to create their own table objects. They would like to run CREATE TABLE FROM or import their own data into Netezza to work with. With these caveats, what's the best approach to granting a user their own personal functional "sandbox" Obviously, ...

Need some advice here I'm working with a 3rd party tool that will insert data using JDBC connection into Netezza using singleton INSERT statements. I know that's not ideal, but it's the only way this 3rd party tool can pass through the data. For example, 5,500 rows takes about 4min to insert. ...

Thanks, Brian! You encouraged me to rummage through config files and logs again which led me to stumble upon the issue - DSOMD!!! Found in a log file that DSOMD service had stopped back on 11/22/2020 2020-11-22 02:43:41,264 INFO com.ibm.datastage.runtime.omdmonapp.OMDMonApp.run(OMDMonApp.java:314) ...

Hello! Before 1/20/2021 our XMETA SQL Server transaction logs were averaging ~4MB size every 15min. The morning of 1/20/2021, we restarted services and since then the XMETA transactions logs have been MUCH larger than usual. We're unable to decipher what's hitting XMETA, exactly, through these *trn ...