Sponsored Content
Full Discussion: DB2 user query utilization?
Operating Systems AIX DB2 user query utilization? Post 302792621 by bakunin on Wednesday 10th of April 2013 05:05:29 PM
Old 04-10-2013
Quote:
Originally Posted by savigabi
I checked for the Command Center on the server and it doesn't appear to be installed and I cannot install anything as my team doesn't have root privileges, although, we do have a back door if needed
I wouldn't rely on such tactics, if i were you. If it isn't you at least someone has to have root-privileges and this one can be made responsible to install the software you need - or pass over root privileges to you. If this takes some time, then so be it - if the organization structure is designed in a way that nothing can get done in time than this organization structure has to be changed instead of trying to work around the problem. If the company decides to not pay for the electricity necessary to operate the server you wouldn't bring a battery to work, but make clear that work is impossible. The same principle is applying here: don't rely on backdoors but make sure things are changed in a way that work is possible - officially.

Just my two cents.

bakunin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pad db2 query result to 8 bits

Hi , I am using a db2 query to get the maximum sequence number from a field.Now this value is taking up only 2 places.(i.e its less than 100).It can grow up to 3 places later but me requirement is that when i write it in a text file, it should be padded upto 8 places. Please help (1 Reply)
Discussion started by: lifzgud
1 Replies

2. Shell Programming and Scripting

Db2 query with script

Hi All, I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field.and i should return on the screen the un matched records .. Could any one please help me in connecting database tables using Unix and retriving data from the same. (1 Reply)
Discussion started by: kanakaraju
1 Replies

3. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ... (2 Replies)
Discussion started by: hanul
2 Replies

4. Shell Programming and Scripting

Need Fix in Exporting a db2 query output

When I use export for sql query in a Script : Select '1',ModHist',count(*) from cc.mdhist; it was exporting the record to a file as: "1" "ModHist" 778201 Here 1 & ModHist are coming in Doublequotes. If I run the above query directly in Unix prompt it was displaying the output as... (1 Reply)
Discussion started by: karumudi7
1 Replies

5. Shell Programming and Scripting

Printing the output of a db2 query on to an unix file

I want to print the output of a db2 query, on to an unix file in a manner that the columns are separated by 'commas'. Please help me out..thanx in advance (1 Reply)
Discussion started by: prasan_ven
1 Replies

6. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies

7. Shell Programming and Scripting

Db2 query on other host

Hello, i need some help with a script. I made a script, which connect to different hosts to get some informations. But i got now some problems with getting informations of a database (db2) which is on a other host. I tried something like var=$(rsh HOST su - db2adm -c "db2 connect to database;... (2 Replies)
Discussion started by: Cyver
2 Replies

8. Programming

DB2 Query -Convert multi values from column to rows

Hi Team I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows . For example : Column 1 Column2 Jan,Feb Hold,Sell,Buy Expected Result Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies

9. Programming

DB2 Query to pick hierarchy values

Dear Team I am using DB2 v9 . I have a condition to check roles based on hierarchies like below example. 1.Ramesh has Roles as "Manager" and "Interviewer" 2.KITS has Roles as "Interviewer" 3.ANAND has Roles as "Manager" and "Interviewer" select * FROM TESTING NAME ... (6 Replies)
Discussion started by: Perlbaby
6 Replies

10. UNIX for Beginners Questions & Answers

DB2 Query modification to remove duplicate values using LISTAGG function

I am using DB2 v9 and trying to get country values in comma seperated format using below query SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE) FROM LOCATION ; Output Achieved MEXICO,UNITED STATES,INDIA,JAPAN,UNITED KINGDOM,MEXICO,UNITED STATES The table... (4 Replies)
Discussion started by: Perlbaby
4 Replies
profiles.old(1) 					    BSD General Commands Manual 					   profiles.old(1)

NAME
profiles -- Profiles Tool SYNOPSIS
profiles [[-I | -R | -i] [-F file_path_to_profile | -]] [[-L] [-U username]] [[-r] [-p profile_id] [-u uuid] [-o output_file_path] [-Y shortname]] [-PHDdCchfvxVzYeN] DESCRIPTION
profiles allows you to install, remove or list configuration profiles, or to install provisioning profiles. Some commands may only work with elevated privileges, or for the current user. -I Install a configuration profile for a particular user from a profile file. -i Install a provisioning profile from a profile file. -V Verify a provisioning profile from a profile file. -R Remove a configuration profile for a particular user from a profile file. -r Remove a provisioning profile given a identifier and uuid. -L List configuration profile information for a particular user, or the current user if no Username was specified. -F Specify the file path to the profile file. Use '-' as the file path to input the configuration profile (not provisioning profile) XML plist via stdin. -U Specify the short username. If installing or removing a profile as root (or sudo), the designated user must be logged in. -H Returns whether configuration profiles are installed. -P List configuration profile information for everyone. -C List configuration profile information for the computer. -c List provisioning profile information. -p A profile identifier used to locate the configuration or provisioning profile. -u A uuid identifier used to locate the provisioning profile. The uuid must be in its canonical 36 character form. -z The profile removal password. If not specified and the profile requires a removal password, you will be prompted. -o The output file path for profile information (-L, -P, -C, -c) as a plist file. The path argument must be specified to use this option, Use 'stdout' to send this informaton to the console. File output will be written as an XML plist file, or you can use 'stdout-xml' to write XML to the console. The toplevel key will contain the user name, or _computerLevel for device or provisioning profile information. -h Displays help information. -v Enables verbose mode. A 'pass' or 'fail' indicator may also be displayed based on the command return status to stdout. -x Displays tool version number. The version is in the format x.yy, where x will change if new or incompatible commands are added. The version initially starts at 2.00 -f Automatically confirm any questions, or when used with -s, will retry startup profiles at each startup until successfully installed. -s Sets profile for startup. (Requires root privileges) -S Sync up and remove any configuration profiles that aren't assigned to any current local user. (Requires root privileges) -Y Specify the shortname of a local user that will be enrolled with MDM if the configuration profile being installed contains a MDM payload. Will only be used if the profile is being installed as root. -W Attempt to renew the certificates in an installed profile. -e Print the Device Enrollment configuration, if any, for the computer. Can be combined with the -o option to write output to a plist. -N Re-enable the user notifications for DEP enrollment. EXAMPLES
profiles -I -F /testfile.configprofile Installs the profile file 'testfile.mobileconfig' into current user. profiles -R -F /profiles/testfile2.configprofile Removes the profile file '/profiles/testfile2.mobileconfig' into the current user. profiles -H Returns whether or not configuration profiles are installed on the system. profiles -P Displays information on all installed configuration profiles on the system. profiles -L Displays information for installed profiles for the current user. profiles -L -o /outputfile Displays information for installed profiles for the current user and sends the output as a dictionary to /outputfile.plist. profiles -Lv Displays extended information for installed configuration profiles for the current user. profiles -R -p com.example.profile1 -z pass Removes any installed profiles with the identifier com.example.profile1 in the current user and using a removal password of 'pass'. profiles -s -F /startupprofile.mobileconfig -f Sets up the profile as a startup profile to be triggered at the next system startup time. If the profile can't be installed, it will try again at next startup time. profiles -I -F - < /configprofile.mobileconfig Installs the configuration profile read in from stdin. The stdin data must be a fully formed XML plist containing the configura- tion profile information. CAVEATS
Certain configuration profiles may be marked as a device profile (system) using the PayloadScope key. However, the profiles tool will ignore the PayloadScope key and install the profile based on how the profile is installed; either a user profile if installed from a user, or a device profile if installed from root (or sudo). If you are installing a profile as root, you may use the -U parameter to install or remove the profile for that active user. Specific payload dictionary information is not available since it may contain sensitive information. Non-sensitive information can be viewed using the System Report. Because this command line tool was not designed to ask for missing information, some profiles may fail to install properly. The only recourse is to insert the missing information before installing the configuration profile. The System Preferences application's Profiles pane is designed to handle the querying of missing information. Configuration profiles installed to the wrong user domain (user vs system) may not behave in the way you expect since the information may not be useful to that particular domain. For example, adding a Mail payload to the system domain will not do anything since Mail payloads must have a user account. Additionally, since profiles are stored by the user shortname and only stored on the local client, care should be taken to not install a profile that could be used by a same named local user. The profiles tool should only be used from the /usr/bin folder since certain operations are privileged and may fail if moved. SEE ALSO
profiles(1) macOS May 26, 2017 macOS
All times are GMT -4. The time now is 09:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy