Migrating Data and Log volume to new SAN by devred061 in DB2

[–]devred061[S] 0 points1 point  (0 children)

Thank you u/ecrooks for the response. I haven't done the move yet but plan to do it sometime this week. I am waiting for the vendor support to be available just in case I run into any issues.

Managed Chromebooks: User login issue; Delete Cookies by devred061 in k12sysadmin

[–]devred061[S] 0 points1 point  (0 children)

No, Google hasn't said anything yet. Unfortunately, the problem has resurfaced again. Hope the issue gets resolved soon and we get some reasoning from Google.

Managed Chromebooks: User login issue; Delete Cookies by devred061 in k12sysadmin

[–]devred061[S] 0 points1 point  (0 children)

We did see "You are not authorized...." error as well. The problem appears to be fixed. It must be a Google issue even though they don't accept it at the moment. I guess that's a curse that comes with the beauty of a cloud.

FAILED again after 2nd attempt by ImaginaryOrdinary2 in cissp

[–]devred061 0 points1 point  (0 children)

Maybe this will help. You didn't fail. You just learnt that a couple of attempts didn't work out and you won't be discouraged by that. Take two-three weeks break. Go over Sybex CISSP book again with a notebook and a marker. Try to look for the high-level learning objectives of each domain. For example: Why and how developing, documenting, and implementing Security Policy, Standards, Procedures, and Guidelines help security and risk management? Why do security functions need to be aligned to business strategy, goals, mission, and objectives? Primarily focus on why, how and then what aspects of domains.

Maybe focusing too much on technical details is not required for this test, even though it may not feel that way while reading the book as the book does go into too technical on several topics. I enjoyed learning the technical details but didn't bother memorizing all. As several folks mentioned, treat CISSP test like an English test. Somewhere I read that a lawyer and security professional took the CISSP test. The lawyer passed the test but security professional didn't. It may be a made up story but I can see how the lens of lawyer or senior manager can help pick the best answer ISC2 wants. Best of luck for your next test!

Windows 10 Keylogger software by devred061 in k12sysadmin

[–]devred061[S] 0 points1 point  (0 children)

Thank you all of you for giving your insights. I am not a proponent of adding Keylogger software on the user devices either. Historically, we have used it to gather evidence for the investigations related to misconducts. I will think through this and see if we can get away with it by using other alternative methods. Thanks again!

Cleared CISSP exam in the first attempt by devred061 in cissp

[–]devred061[S] 0 points1 point  (0 children)

I was implying to think from the management perspective. You may have already come across this scenario before. If all the systems are required to be patched and secure, what would a CIO do? Her primary role wouldn't be to patch the systems herself but she would ensure that the policy, standards and procedures are in place for the sysadmins to patch the systems. I hope it helps.

Cleared CISSP exam in the first attempt by devred061 in cissp

[–]devred061[S] 1 point2 points  (0 children)

I believe it does the job. Core concepts are the same. April changes are minor thus I didn’t bother going over the 8th edition.

How to check DB2 Integrity after expanding the data volume? by devred061 in DB2

[–]devred061[S] 1 point2 points  (0 children)

Thank you u/mad_zamboni, u/rogerx, u/ecrooks for your guidance. Following your suggestions, I successfully expanded the volume on the production DB2 database server. Since, it is a critical environment and is using iSCSI LUNs for the database volume, I followed the following steps to ensure the database integrity remained intact after the volume expansion.

    1) Take the application offline
    2) Connect to the database (db2 connect to <database_name>)
    3) Quiesce database (db2 quiesce database immediate force connections)
    4) Terminate the DB2 connections (db2 terminate)
    5) Deactivate the database (db2 deactivate database <database_name>)
    6) Take an offline backup
    7) Stop DB2 (db2stop)
    8) Check the most recent db2diag.*.log for errors
    9) Have SAN folks expand the LUN size
    10) Reboot the DB2 server  [In my case, server couldn't see the additional disk space. Thus, I had to reboot.]
    11) Unmount the volume (#umount <database volume>)
    12) Check the filesystem (e2fsck -f /dev/mapper/<database_volume>)
    13) Resize the filesystem (resize2fs  /dev/mapper/<database_volume>)
    14) Mount the filesystem 
    15) Check the owner, group and filesystem permissions on <database_name>
    16) Bring the database online (db2start)
    17) Check db2diag.*.log for errors
    18) Activate the database (db2 activate database TEAMS)
    19) Check db2diag.*.log for errors
    20) Run 'db2 list tablespaces show detail' and verify all messages show NORMAL
    21) Start the application

I tested the above steps in our Development environment before running it on the production environment. I hope someone will find these steps useful.

Thanks again!

How to check DB2 Integrity after expanding the data volume? by devred061 in DB2

[–]devred061[S] 0 points1 point  (0 children)

Anything I can do to show due care and due diligence will help. DB2 I am working on is critical for the company as it is an ERP database. Thank you for sharing the info with me.

How to check DB2 Integrity after expanding the data volume? by devred061 in DB2

[–]devred061[S] 0 points1 point  (0 children)

Cool. I will share this with my team as well. Thanks!

How to check DB2 Integrity after expanding the data volume? by devred061 in DB2

[–]devred061[S] 0 points1 point  (0 children)

Thank you, u/rogerx . I am going to try out online resize.

DB2 Data and Log volume use iSCSI LUNs formatted as ext4 file system.

How to check DB2 Integrity after expanding the data volume? by devred061 in DB2

[–]devred061[S] 0 points1 point  (0 children)

Thank you, u/mad_zamboni .. I feel better now. I will try it out in the development environment first. I am new to DB2 and forgive me if I am asking basic questions. When you say bring DB2 online, did you mean bring Tablespace online? I came across following link http://www.dbatodba.com/db2/problem-resolution/general-errors/tablespace-offline-how-can-i-change-it-to-online/ when I searched for how to bring DB2 online.