can anybody tell me how to set authority in DB2.I'm getting this error SQL1092N "SYSTEM" does not have the authority to perform the requested command when trying to create a sample db.My code is
I get the instance,login and pwd from the user thru form.
$ins="db2icrt ".$instance." -s ee -p D:\ -u ".$Login.",".$pwd;
echo "<BR><BR>Instance ($instance) created succseefully";
system('db2cmd /c /w /i db2 get instance');
system('db2sampl'); //Gettring Error
The output is:
Instance (check) created succseefully
The current database manager instance is: CHECK
SQL1092N "SYSTEM" does not have the authority to perform the requested command.
Thanx in advance.