First, download the current patch from VMware. In my case, it was ESXi550-201312001 that I downloaded from Download Patches page. You will need to have a valid VMware login but you don’t have to pay for a support contract 🙂
Copy the downloaded zip file to your ESXi server. I put it in /vmfs/volumes/52f573f2-d2dddb9e-e83a-001b213a7c46/Patches/ESXi550-201312001.zip but you can put it anywhere on your server. How to transfer it? Either temporarily enable ssh on the server and use winscp or scp.
Log into the console (I enabled ssh on the server) and issue the following command:
esxcli software vib update -d *where ever you put it*/ESXi550-201312001.zip
Last year, April -> October, I asked the question about IQ supporting Huge Pages on Linux. It was mentioned that under SA CR 728597 and Red Hat Bug 891857 that there was a bug in the Linux kernel handling of direct I/O while using transparent huge memory pages (a variant of Linux Huge memory pages).
This problem is related to a possible bug in the transparent huge pages (THP) feature introduced in these operating system versions. Red Hat bug 891857 has been created to track this issue.
The problem can be triggered by calling an external environment, xp_cmdshell, or other procedure that causes a fork while other I/O is occurring. A known limitation with the Linux kernel limits the use of fork while doing O_DIRECT I/O operations. Essentially what can happen is that the data can come from or go to the wrong process’ memory after the fork. SQL Anywhere performs O_DIRECT I/O operations according to the documented safe usage. However, THP appears to cause further problems and the O_DIRECT I/O data comprising database page reads/writes appears to get lost.
http://scn.sap.com/thread/3338917 and http://froebe.net/blog/2013/06/17/does-anyone-have-any-details-on-redhat-linux-bug-891857/
Does anyone know the status of this ongoing FIVE year old issue?
You will need to create one or more application groups. In the below example we create the mygroup group:
sp_iqaddlogin "mygroup", null;
GRANT CONNECT TO "mygroup";
GRANT GROUP TO "mygroup";
After that you can create a user:
sp_iqaddlogin "henry", null;
GRANT CONNECT TO "henry" IDENTIFIED BY 'password';
Note that if you are copying a user from one IQ system to another and want to keep the password, this is a simple thing. You just need to grab the password column of sysuser for the user in question:
where user_name = "henry";
You will need to escape each byte in order to add the password:
GRANT CONNECT TO "henry"
IDENTIFIED BY ENCRYPTED
Now we need to add henry to the mygroup group:
IN GROUP "mygroup" to 'henry';
Any and all object permissions should be granted to the group not the user.