Database BackUp
Hi e’rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database has a [...]
Answer Question
| May 30, 2006 11:35 AM
Access, Data analysis, Data mining/analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Hi e’rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database has a [...]
Answer Question
| May 30, 2006 11:35 AM
Access, Data analysis, Data mining/analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
SQL Function to return triggered update columns?
We need to retrieve the code that defines a trigger. Not just the code of the trigger(systriggers.action_statement) but the full create statement. I think we have all the elements except for the list of columns in the UPDATE OF clause. This information can be retrieved as follows: SELECT TRIGGERED_UPDATE_COLUMNS FROM QSYS2.SYSTRIGUPD where EVENT_OBJECT_SCHEMA = ‘%s’ [...]
Answer Question
| May 10, 2006 3:01 PM
DB2 Universal Database
We need to retrieve the code that defines a trigger. Not just the code of the trigger(systriggers.action_statement) but the full create statement. I think we have all the elements except for the list of columns in the UPDATE OF clause. This information can be retrieved as follows: SELECT TRIGGERED_UPDATE_COLUMNS FROM QSYS2.SYSTRIGUPD where EVENT_OBJECT_SCHEMA = ‘%s’ [...]
Answer Question
| May 10, 2006 3:01 PM
DB2 Universal Database
Performance Problem
We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index and is [...]
Answer Question
| December 6, 2009 2:38 PM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index and is [...]
Answer Question
| December 6, 2009 2:38 PM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
Group policy change – cannot get back into Group policy MMC
Recently implemented change to group policy recommended by software vendor by the below instructions: 1. Click Start, point to Programs, point to Administrative Tools, and then click Domain Controller Security Policy. 2. Click Security Settings. 3. Click Local Policies, and then click User Rights Assignment. 4. In the right pane, double-click Impersonate a client after [...]
Answer Question
| May 8, 2006 8:17 AM
Application security, Biometrics, configuration, Database, DataCenter, Desktops, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, OS, Patch management, patching, PEN testing, Platform Security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Software, SQL Server, Tech support, vulnerability management
Recently implemented change to group policy recommended by software vendor by the below instructions: 1. Click Start, point to Programs, point to Administrative Tools, and then click Domain Controller Security Policy. 2. Click Security Settings. 3. Click Local Policies, and then click User Rights Assignment. 4. In the right pane, double-click Impersonate a client after [...]
Answer Question
| May 8, 2006 8:17 AM
Application security, Biometrics, configuration, Database, DataCenter, Desktops, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, OS, Patch management, patching, PEN testing, Platform Security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Software, SQL Server, Tech support, vulnerability management
function not found – 2 questions
I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn’t the [...]
Answer Question
| May 5, 2006 8:52 PM
DB2 Universal Database, SQL
I wrote a function to change a date in character *USA format to *ISO character format. There is a lot of data to insert and all the dates are in *USA format rather than ISO format. The function is created but running the statement, I am told the function does not exist. Why isn’t the [...]
Answer Question
| May 5, 2006 8:52 PM
DB2 Universal Database, SQL
What is SSI injection
I recently read an article that mentioned SSI injection. I’m aware of SQL injection, but not SSI. Can anyone explain what it is and what should be done to protect against it? Thanks
Answer Question
| May 5, 2006 3:31 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Development, Encryption, Exchange, filtering, Hacking, human factors, Instant Messaging, Secure Coding, Servers, Spyware, SSL/TLS, Trojans, Viruses, Web security, worms
I recently read an article that mentioned SSI injection. I’m aware of SQL injection, but not SSI. Can anyone explain what it is and what should be done to protect against it? Thanks
Answer Question
| May 5, 2006 3:31 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Development, Encryption, Exchange, filtering, Hacking, human factors, Instant Messaging, Secure Coding, Servers, Spyware, SSL/TLS, Trojans, Viruses, Web security, worms
Prompting for and passing partial search criteria to queries
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME) ALWQRYDFN(*YES) QMFORM(*QMQRY) from the a command line, the system prompts me for FIELDLASTNAME. This [...]
Answer Question
| December 6, 2009 3:29 PM
AS/400, DB2 Universal Database
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME) ALWQRYDFN(*YES) QMFORM(*QMQRY) from the a command line, the system prompts me for FIELDLASTNAME. This [...]
Answer Question
| December 6, 2009 3:29 PM
AS/400, DB2 Universal Database
AS400 Console
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
route mail with fax service in sbs 2003
i have a sbs 2003 on my network and i configure him to get all the fax of my company, the only problem is that when i configure him to route all the incoming fax to some mail it does not seem to work, i check the event log and i get error 32083 and [...]
Answer Question
| April 27, 2006 3:30 PM
Access, Access control, AIM, Application security, Availability, backdoors, Backup & recovery, Bandwidth, Biometrics, Brightmail, Browsers, Budgeting, Business/IT alignment, Career development, CipherTrust, ClearSwift, CLP, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, Desktops, Digital certificates, Disaster Recovery, Encryption, Ethernet, Exchange, Exchange security, FDDI, filtering, Firewalls, Forensics, Frame Relay, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, Network protocols, Network security, Networking, OS, Outsourcing, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Postini, Project management, provisioning, Regulations, Risk management, Rockliffe, ROI & cost justification, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SQL Server, SSL/TLS, standards, Storage, Symantec, TrendMicro, Trojans, Vendors, Viruses, VPN, vulnerability management, Web development, Web security, Web services, Web Services Standards, Wireless, worms
i have a sbs 2003 on my network and i configure him to get all the fax of my company, the only problem is that when i configure him to route all the incoming fax to some mail it does not seem to work, i check the event log and i get error 32083 and [...]
Answer Question
| April 27, 2006 3:30 PM
Access, Access control, AIM, Application security, Availability, backdoors, Backup & recovery, Bandwidth, Biometrics, Brightmail, Browsers, Budgeting, Business/IT alignment, Career development, CipherTrust, ClearSwift, CLP, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, Desktops, Digital certificates, Disaster Recovery, Encryption, Ethernet, Exchange, Exchange security, FDDI, filtering, Firewalls, Forensics, Frame Relay, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, Network protocols, Network security, Networking, OS, Outsourcing, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Postini, Project management, provisioning, Regulations, Risk management, Rockliffe, ROI & cost justification, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SQL Server, SSL/TLS, standards, Storage, Symantec, TrendMicro, Trojans, Vendors, Viruses, VPN, vulnerability management, Web development, Web security, Web services, Web Services Standards, Wireless, worms
Number of records in the Flat file
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
Answer Question
| April 27, 2006 10:26 AM
390, Application development, Career development, Data analysis, DataCenter, DB2, DB2 Universal Database, Development, Mainframe, zSeries
I have a huge Flat file in the Mainframe. What is the quickest way (utility, TSO command or TSO function) to find the exact number of records in the file? Thank you for your help!
Answer Question
| April 27, 2006 10:26 AM
390, Application development, Career development, Data analysis, DataCenter, DB2, DB2 Universal Database, Development, Mainframe, zSeries
Looking for application vulnerability scanner
My group is considering implementing an application vulnerability scanner to look for security holes in our Web sites. Can you recommend some products? Thanks
Answer Question
| November 13, 2009 2:59 PM
Application security, Automated, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Software testing, Software testing tools, vulnerability management, Web
My group is considering implementing an application vulnerability scanner to look for security holes in our Web sites. Can you recommend some products? Thanks
Answer Question
| November 13, 2009 2:59 PM
Application security, Automated, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Software testing, Software testing tools, vulnerability management, Web
End Program – explorer.exe-2
From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one [...]
Answer Question
| April 19, 2006 2:03 AM
Career development, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, E-business, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, Oracle, OS, Patch management, Security, Servers, Software, SQL Server, Systems management software, Tech support, Web site design & management
From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one [...]
Answer Question
| April 19, 2006 2:03 AM
Career development, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, E-business, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, Oracle, OS, Patch management, Security, Servers, Software, SQL Server, Systems management software, Tech support, Web site design & management
End Program – explorer.exe
From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes [...]
Answer Question
| April 19, 2006 7:24 AM
Active Directory, Backup & recovery, Cabling, Computer Associates, Corporate portal applications, Data analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, DHCP, Disk drives, DNS, Exchange, Hardware, Hubs, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Mobile, Network applications management, Network management software, Network protocols, Networking, Networking services, Oracle, OS, Performance management, Routers, Security, Servers, Software, Spam, SQL Server, Storage, Storage products and equipment, Switches, Systems management software, Tech support, Web services, Web site design & management, WINS, Wireless
From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes [...]
Answer Question
| April 19, 2006 7:24 AM
Active Directory, Backup & recovery, Cabling, Computer Associates, Corporate portal applications, Data analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, DHCP, Disk drives, DNS, Exchange, Hardware, Hubs, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Mobile, Network applications management, Network management software, Network protocols, Networking, Networking services, Oracle, OS, Performance management, Routers, Security, Servers, Software, Spam, SQL Server, Storage, Storage products and equipment, Switches, Systems management software, Tech support, Web services, Web site design & management, WINS, Wireless
Physical / Logical file definitions
Can a logical file have fields that differ in definition of type than the physical? I’ve got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 [...]
Answer Question
| December 3, 2009 3:08 PM
DB2 Universal Database, RPG, RPGLE
Can a logical file have fields that differ in definition of type than the physical? I’ve got a physical file with fields defined as: FLD1 A 20 1 20 FLD2 S 8 0 21 28 FLD3 S 11 2 29 39 and the logical defined as: FLD1 A 20 1 20 FLD2 P 8 0 [...]
Answer Question
| December 3, 2009 3:08 PM
DB2 Universal Database, RPG, RPGLE
Laptop Security (Remotely)
Hi, I am an Information Security Consultant. We want to monitor all activities done by Laptop Users when they are working offline. Can somebody suggest a tool which can push all logs on server while a user is working offline. We have banned USB sticks in our office and also all email activity is monitored [...]
Answer Question
| April 28, 2006 7:20 AM
Access control, Application security, backdoors, Biometrics, Browsers, Budgeting, Business/IT alignment, Call Centers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Network security, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, standards, Storage, Trojans, Vendors, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Hi, I am an Information Security Consultant. We want to monitor all activities done by Laptop Users when they are working offline. Can somebody suggest a tool which can push all logs on server while a user is working offline. We have banned USB sticks in our office and also all email activity is monitored [...]
Answer Question
| April 28, 2006 7:20 AM
Access control, Application security, backdoors, Biometrics, Browsers, Budgeting, Business/IT alignment, Call Centers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Network security, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, standards, Storage, Trojans, Vendors, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Trouble with package execution after Oracle upgrade
Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under 9.2.0.7 – is [...]
Answer Question
| April 12, 2006 6:07 PM
Database, DB2, Hardware, Oracle, Software
Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under 9.2.0.7 – is [...]
Answer Question
| April 12, 2006 6:07 PM
Database, DB2, Hardware, Oracle, Software
Synchronizing the values in the form with the record in Oracle
I am new to Oracle forms and am faced with a problem. For records of a certain type, instead of updating the current record with the values in the form items, I am creating a new record in the table with the same values, but with a new sequence number (the primary key is a [...]
Answer Question
| April 12, 2006 6:22 PM
Database, DB2, Oracle
I am new to Oracle forms and am faced with a problem. For records of a certain type, instead of updating the current record with the values in the form items, I am creating a new record in the table with the same values, but with a new sequence number (the primary key is a [...]
Answer Question
| April 12, 2006 6:22 PM
Database, DB2, Oracle
Can not figure out this error message
I am creating a table and tring to insert headings into it but I keep getting this one error and I just can not figure it out. Please help if you can. The first statement is: “create table qtemp/rrlib (hdgs char (3000 ) not null with default” Then my insert statement: “insert into qtemp/rrlib values(“cs#200″,”nm1200″,”ln3200″,”cty200″,”stc200″,”zip200″,”art203″,”ct#203″,”dat203″,”opn203″) [...]
Answer Question
| March 31, 2006 5:44 PM
DB2 Universal Database
I am creating a table and tring to insert headings into it but I keep getting this one error and I just can not figure it out. Please help if you can. The first statement is: “create table qtemp/rrlib (hdgs char (3000 ) not null with default” Then my insert statement: “insert into qtemp/rrlib values(“cs#200″,”nm1200″,”ln3200″,”cty200″,”stc200″,”zip200″,”art203″,”ct#203″,”dat203″,”opn203″) [...]
Answer Question
| March 31, 2006 5:44 PM
DB2 Universal Database
inserts through a database link
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]
Answer Question
| March 31, 2006 10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML
Hello every body. Here I go again… Do you know if there is a restriction about performing inserts through a database link ? We are experiencing the following situation: We have two Oracle 8i instances running on a win 2k3 server, and a Forms applications needs to insert data from one instance to the second [...]
Answer Question
| March 31, 2006 10:13 AM
Architecture/Design, Availability, Backup & recovery, Database, DB2, Installation, Migration, Oracle, Oracle 8i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows, XML
MSWord Password and MSExcel Password
I am using different password for my secured files but I loose which one i use in certain file. Now I can not retrieve it. Is there any way i can open it again or retrieve my password so I can open my files? I have little knowledge in VB6, is there any one generous [...]
Answer Question
| April 3, 2006 8:08 PM
Application security, Biometrics, Compliance, CRM, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Software, VPN, Wireless
I am using different password for my secured files but I loose which one i use in certain file. Now I can not retrieve it. Is there any way i can open it again or retrieve my password so I can open my files? I have little knowledge in VB6, is there any one generous [...]
Answer Question
| April 3, 2006 8:08 PM
Application security, Biometrics, Compliance, CRM, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Software, VPN, Wireless
