Hi everyone,   When I set BULK LOAD option as active, SCD2 transformation create the following code (for ETLS_CLOSE as example):   proc append base = EXT_VI."W6B3BTSM"n ( BULKLOAD=YES ) data = work."ETLS_CLOSE"n force; run; But this code doesn't work. I need to set "bl_psql_path='/PATH' " and "bl_delete_datafile=no" dataset option to BULKLOAD works properly. I aware that I can change the automatic generated code to add these options.   Is there a way to configure these options at the transformation level? Or a way that I can add these options without change the code manually?   Thanks in advance. ... View more

Hi experts,   We are trying to copy a work table (72 millions obs) to a POSTGRES database and it is taking a long time to run. We had a similar issue to copy a huge work table to SQL Server database and we solve it put INSERTBUFF options (32767) at library level. Down below I share the comparison between copying a work table to SQL Server (we already have it optimized) VS copying it to POSTGRES database:   Postgres execution (STG_PG.PRUEBA3): SQL Server execution (staging.PRUEBA3): At the odbc.ini level this is the configuration for SAS/ACCESS Interface to PostgreSQL: Finally, we execute the following code (same as before) with BULK_LOAD, BL_PSQL_PATH and BL_DELETE_DATAFILE at dataset options level and real time decreased:         Is there a way to configure these options at the library level (BL_PSQL_PATH and BL_DELETE_DATAFILE)? How can I set these options so that BULK LOAD is always active?   Please, if anyone has faced this problem before or knows what is missing, please, let us know. It will be more than welcome.   Thanks in advance. ... View more

Hi Experts,   We have a batch process that executes every day. This week, a job that usually does not past 18 minutes of execution time (real time, as you can see), now is taking more than 45 minutes to finish. We already have Fullstimmer option active, but we don't know why only the real time was increased and why only this week.    It might be an I/O issue. Does anyone know how we can identify if it is really an I/O problem or if it could be some other issue (network, for example)?   In old documentation there are Fullstimmer stats that could help to identify the problem but they do not appear in log. The stats are those down below, as you can see: Please, if anyone has faced this problem before or knows what is missing, please, let us know. It will be more than welcome.   Thanks in advance. ... View more