SAS Platform Admin Blog

To enable bulk loading for SQL Server you need to add EnableBulkLoad=1 option in odbc.ini file. Below is the sample SQL Server entry in odbc.ini file that shows enabling bulk loading. [EFFSIR] Driver=/ODBC/lib/S0msss26.so Description=EFFSIR Address=117.132.256.67,1433 AnsiNPW=Yes Database=CDKSP LogonID= Password= QuotedId=No EnableBulkLoad=1 EnableProcessLicensing=1 If you want to turn of Bulk Load then the entry should be: [EFFSIR] Driver=/ODBC/lib/S0msss26.so Description=EFFSIR Address=117.132.256.67,1433 AnsiNPW=Yes Database=CDKSP LogonID= Password= QuotedId=No EnableProcessLicensing=1 You no need to specify the option.

To get SAS/ACCESS to DB2 connection details use following commands in the server: To List Node Directory: db2 list node directory Sample output: (output copied from IBM website) Node 1 entry:  Node name                      = LANNODE  Comment                        =  Directory entry type           = LDAP  Protocol                       = TCPIP  Hostname                       = LAN.db2ntd3.torolab.ibm.com  Service name                   = 50000 To List Database Directory: db2 list db  directory Sample output:  (output copied from IBM website) System Database Directory              Numbe...

PM commands issue an error when executed on the shell. It throws error even though I had run the profile.js and profile.lsf before running the command. ERROR Message: jsub Error: Could not find or load main class com.platform.LSFJobFlow.app.cli.JFSubmitFlow caleditor Error: Could not find or load main class com.platform.LSFJobFlow.app.caleditor.JFCalContainer [/users/admin]$ jsub Exception in thread "main" java.lang.NoClassDefFoundError: com.platform.LSFJobFlow.api.JFException         at java.lang.J9VMInternals.verifyImpl(Native Method)         at java.lang.J9VMInternals.verify(J9VMInternals.java:93)         at java.lang.J9VMInternals.verify(J9VMInternals.java:91)         at java.lang.J9VMInternals.prepare(J9VMInternals.java:490)         at java.lang.Class.getMethod(Class.j...

IBM Process Manager patching steps: Stop PM - If your PM was setup to use EGO then use EGO to stop or use root id to stop process manager. During the patching PM should be stopped. [root@localhost ~]# . /sas/pm/jfd/conf/profile.js [root@localhost ~]# cd /sas/pm/jfd [root@localhost jfd]# jadmin stop Shutting down jfd ... jfd is being shut down. Checking whether the jfd is stopped. It will take atlest 5 minutes to stop. In my first check it is not stopped but in second check it is stopped. [root@localhost jfd]# ps -ef | grep jfd root      1336 12194  0 12:00 pts/11   00:00:00 grep jfd lsfadmin 43550     1  0 11:39 ?        00:00:04 /sas/pm/jfd/9.1/linux2.6-glibc2.3-x86_64/etc/jfd lsfadmin 43604 43550  0 11:39 ?        00:00:00 /sas/pm/jfd/9.1/linux2.6-glibc2.3-x86_64/etc/eem.local [root@localhost jfd]# ps -ef | grep jfd root      1336 12194  0 12:00 pts/11   00:0...

Issue: I had some issues with SAS EG, Whenever I open up SAS EG, I got the issue that EG needs to be restarted or closed. I did try to reinstall it, but didn’t help. Every time I launch it showed only Exit SAS Enterprise Guide and Restart option with SAS Enterprise Guide has encountered a problem and needs to close. Sorry for the inconvenience error message. Issue screenshot below:  Information in Show Details: Thanks for the quick reply, detail is shown below '.', hexadecimal value 0x00, is an invalid character. Line 1, position 1. -------------------------- Technical Information Follows -------------------------- Exception Details: ---------------------------------------- Exception type:  System.Xml.XmlException Message:         '.', hexadecimal value 0x00, is an invalid character. Line 1, position 1. Source:          System.Xml Target Site:...