JustinMcNamara74

Setup For DMP Developement

Install Windows Environment

1. Install Parallels
   • Trial Version
     • You will need to aquire a parallel license (see functional Manager)
   • Will need an MSDN account to obtain product keys
     • here is the list of product keys

JustinMcNamara74

git commit -m "Something terribly misguided"

Dammit, I forgot a [puts, console.log, etc..]

😟

Undo commit

• git reset HEAD~

JustinMcNamara74

Lists all user/group permissions

SELECT CASE WHEN _V_USER.USERNAME  IS NOT NULL THEN 'USER'
           WHEN _V_GROUP.GROUPNAME IS NOT NULL THEN 'GROUP'
               ELSE 'UNKNOWN' END                            AS USERS_GROUPS,
        COALESCE(_V_USER.USERNAME,_V_GROUP.GROUPNAME)        AS NAME,             
    NVL(_V_DATABASE. DATABASE,'GLOBAL' )                     AS DATABASE ,
    _T_OBJECT.OBJNAME                                        AS OBJECTNAME,

JustinMcNamara74

Netezza ticket Instructions
call 1-800-426-7378
Option 2
Option 2
Ask to open a Netezza appliance ticket 

JustinMcNamara74

List all altered tabled

Run the command:

nz_alterd_tables

Sample Results:

| Database | Schema | Table Name | Size (Bytes) | # Of Versions |

JustinMcNamara74

use [db_name]
select * 
from sysusers 
order by name ;

JustinMcNamara74

SELECT TOP 100 name, create_date, modify_date 
FROM sys.objects
WHERE type = 'P' 
ORDER BY modify_date DESC

JustinMcNamara74

 SELECT DB_NAME(database_id)
    ,OBJECT_NAME(object_id)
    ,cached_time
    ,last_execution_time
    ,execution_count
FROM sys.dm_exec_procedure_stats
WHERE DB_NAME(database_id) = 'DB_NAME'
ORDER BY last_execution_time DESC

JustinMcNamara74

-- This will force the user to enter a new passowrd upon the next login. User needs to know currentl PW.
-- http://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/c_sysadm_password_expiration.html
ALTER USER User EXPIRE PASSWORD;

JustinMcNamara74

Reference

Create User

CREATE USER User WITH PASSWORD 'password';

Check current perms after each step by using the following command:

\dpu User;

Grants list privileges. Without it, user cannot list tables in aginity when selecting a DB